---

#if ( ("$!contract_number" == "")
   && ("$!client_full_name" == "")
   && ("$!contract_activity_type" == "")
   && ("$!account_number" == "")
   && ("$!created_at_from" == "")
   && ("$!created_at_to" == "")
   && ("$!certificate_id" == "") )
    and 1 = 0
#end




#if ("$!certificate_id" != "")
    and td.id = cast(:certificate_id as bigint)
#end




var data = {};
//Обработка фильтров
data.contract_number = getQueryParam('contract_number');
data.certificate_id = getQueryParam('certificate_id');




// Кнопка "Сбросить"
$('#filter\\.cleanFilter').click(function () {
    $('#searchOrdersFilter')[0].reset();
    $('#filter\\.contract_activity_type').val('').trigger('change');

    var url = new URL(window.location.href);
    url.searchParams.delete('certificate_id');
    url.searchParams.delete('contract_number');
    window.history.replaceState(window.history.state, '', url.toString());

    journal.reload();
    $('#incomingOrderInline').stop(true, true).slideUp(150);
});





'<a target="_blank" href="/ourpension/view?viewCode=n3mSokEw&amp;certificate_id='
    || td.id
    || '">'
    || td.number
    || '</a>' AS document_number,