---

function () {
  var appData = registerTable.data();
  var data = {};

  data.registerType = "АНПФ";

  var id_register = application().id;

  if (skip_url_app) {
    data.id = -1;
  } else {
    data.id = id_register;
  }

  var filter_status = $("#filter_status").val();
  var filter_date_from = $("#filter\\.created_at_from").val();
  var filter_date_to = $("#filter\\.created_at_to").val();
  var filter_number = $("#filter\\.register_number").val();

  data.filter_status = filter_status;
  data.filter_date_from = filter_date_from;
  data.filter_date_to = filter_date_to;
  data.filter_number = filter_number;

  data.showRecords = !!(
    filter_status ||
    filter_date_from ||
    filter_date_to ||
    filter_number ||
    id_register
  );

  return data;
}



and :showRecords

#if ($filter_status)
  and mftv.count = CAST(:filter_status as int)
#end

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

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

#if ($filter_number)
  and UPPER(cast(r.number as text)) like '%' || UPPER(:filter_number) || '%'
#end