---

#set($hasFilter = false)

#if ("$!status" != "")
  #set($hasFilter = true)
#end

#if ("$!created_at_from" != "")
  #set($hasFilter = true)
#end

#if ("$!created_at_to" != "")
  #set($hasFilter = true)
#end

#if ("$!register_number" != "")
  #set($hasFilter = true)
#end

#if (!$hasFilter)
  and 1 = 0
#end

#if ("$!status" != "")
  and mftv.count = cast(:status as integer)
#end

#if ("$!created_at_from" != "")
  and r.date >= to_date(:created_at_from, 'YYYY-MM-DD')
#end

#if ("$!created_at_to" != "")
  and r.date < to_date(:created_at_to, 'YYYY-MM-DD') + interval '1 day'
#end

#if ("$!register_number" != "")
  and cast(r.number as text) ILIKE '%' || :register_number || '%'
#end