---

smevCheckTableNrd = new QueryTable("GjgFpbpG", {

						onRowDblClick: function (data, index) {
						},
						initComplete: function (queryAction) {

						},

						onRowSelect: function (data, index) {
							//$("#manualSuccessSelect").val(data.manual_success);
							//$("#amlcftComment").val(data.amlcft_comment);
							//$("#smevSACheckEditVisible").show();
							//uploadFileListSA.reload();
						},
						onRowDeselect: function (data, index) {
							//$("#smevSACheckEditVisible").hide();
						},
						drawCallback: function (settings) {
						}
					}, 
																						 function () {
						var data = {};
						var clientData = clientTable.data();

						data.isShown = smevCheckNrd;
						data.individual_id = (clientData ? clientData.id : application().id);

						return data;
					},
																						 selection,
																						 {
						showFilter: true,
						showExportToExcelButton: true,
						paginate: true
					});





SELECT
  s.id as id,
  to_char(sr.date, 'DD.MM.YYYY') as date,
  src.short_name as document_type,
  case when sr.type = 'OUT' then 'Исходящий'
when sr.type = 'IN' then 'Входящий' end as type,
  case when src.service_type = 'SMEF PFR' then 'СФР'
when src.service_type = 'SMEF NRD' then 'НРД'
when src.service_type = 'SMEF FNS' then 'ФНС' end as service,
  src.full_name as document_full_name,
  case when src.view_code is not null then '<a target="_blank" href="view?viewCode=' || src.view_code || '&id='|| s.smev_register_id || '&sid=' || s.id ||'">'|| sr.number ||'</a>' else sr.number end as registry_number,
  case mftv.count when 1 then 'Сформирован'
        when 2 then 'Проверяется'
        when 3 then 'ФЛК пройден'
  	when 4 then 'Ошибка ФЛК'
        when 5 then 'Отправлен'
  	else ''
end as status,
  sr.username as user,
  s.registry_type as registry_type 
FROM report.smev_register sr  
join (
select id, smev_register_id, contract_id, individual_id, 'nrd' as registry_type from report.smev_nrd
union all
select id, smev_register_id, contract_id, individual_id, 'nrd_dsv' as registry_type from report.smev_nrd_dsv
union all
select id, smev_register_id, null as contract_id, null as individual_id, 'anpv' as registry_type from report.smev_anpv
union all
select asls.id, smev_register_id, null as contract_id, i.id as individual_id, 'asls' as registry_type from report.smev_asls asls join ourpension.individual i on asls.insurance_number = i.insurance_number
union all
select znnch.id, smev_register_id, null as contract_id, i.id as individual_id, 'znnch' as registry_type from report.smev_znnch znnch join ourpension.individual i on znnch.insurance_number = i.insurance_number
union all
select vspnp.id, smev_register_id, null as contract_id, i.id as individual_id, 'vspn_p' as registry_type from report.smev_vspn_p vspnp join ourpension.individual i on vspnp.insurance_number = i.insurance_number
union all
select uvspnp.id, smev_register_id, null as contract_id, i.id as individual_id, 'u_vspn_p' as registry_type from report.smev_u_vspn_p uvspnp join ourpension.individual i on uvspnp.insurance_number = i.insurance_number
union all
select zspnnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'zspnnpf' as registry_type from report.smev_zspnnpf zspnnpf join ourpension.individual i on zspnnpf.insurance_number = i.insurance_number
union all
select uzspnnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'u_zspnnpf' as registry_type from report.smev_u_zspnnpf uzspnnpf join ourpension.individual i on uzspnnpf.insurance_number = i.insurance_number
union all
select upevvddsnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'upevdds_npf' as registry_type from report.smev_upevdds_npf upevvddsnpf join ourpension.individual i on upevvddsnpf.insurance_number = i.insurance_number
union  all
select zrspnnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'zrspn_npf' as registry_type from report.smev_zrspn_npf zrspnnpf join ourpension.individual i on zrspnnpf.insurance_number = i.insurance_number
union all
select inspn.id, smev_register_id, null as contract_id, i.id as individual_id, 'inspn' as registry_type from report.smev_inspn inspn join ourpension.individual i on inspn.insurance_number = i.insurance_number
union all
select uinspn.id, smev_register_id, null as contract_id, i.id as individual_id, 'u_inspn' as registry_type from report.smev_u_inspn uinspn join ourpension.individual i on uinspn.insurance_number = i.insurance_number
union all
select inspnv.id, smev_register_id, null as contract_id, i.id as individual_id, 'inspn_v' as registry_type from report.smev_inspn_v inspnv join ourpension.individual i on inspnv.insurance_number = i.insurance_number
union all
select uinspnv.id, smev_register_id, null as contract_id, i.id as individual_id, 'u_inspn_v' as registry_type from report.smev_u_inspn_v uinspnv join ourpension.individual i on uinspnv.insurance_number = i.insurance_number
union all
select rspnnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'rspnnpf' as registry_type from report.smev_rspnnpf rspnnpf join ourpension.individual i on rspnnpf.insurance_number = i.insurance_number
union all
select urspnnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'u_rspnnpf' as registry_type from report.smev_u_rspnnpf urspnnpf join ourpension.individual i on urspnnpf.insurance_number = i.insurance_number
union  all
select uzevddsnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'uzev_dds_npf' as registry_type from report.smev_uzev_dds_npf uzevddsnpf join ourpension.individual i on uzevddsnpf.insurance_number = i.insurance_number
union all
select uzevoddsnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'uzevo_dds_npf' as registry_type from report.smev_uzevo_dds_npf uzevoddsnpf join ourpension.individual i on uzevoddsnpf.insurance_number = i.insurance_number
union all
select sizlp.id, smev_register_id, null as contract_id, i.id as individual_id, 'sizlp' as registry_type from report.smev_sizlp sizlp join ourpension.individual i on sizlp.insurance_number = i.insurance_number
union all
select sfv.id, smev_register_id, null as contract_id, i.id as individual_id, 'sfv' as registry_type from report.smev_sfv sfv join ourpension.individual i on sfv.insurance_number = i.insurance_number
union all
select usfv.id, smev_register_id, null as contract_id, i.id as individual_id, 'u_sfv' as registry_type from report.smev_u_sfv usfv join ourpension.individual i on usfv.insurance_number = i.insurance_number
union all
select sfsnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'sfs_npf' as registry_type from report.smev_sfs_npf sfsnpf join ourpension.individual i on sfsnpf.insurance_number = i.insurance_number
union all
select usfsnpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'u_sfs_npf' as registry_type from report.smev_u_sfs_npf usfsnpf join ourpension.individual i on usfsnpf.insurance_number = i.insurance_number
union all
select unpf.id, smev_register_id, null as contract_id, i.id as individual_id, 'unpf' as registry_type from report.smev_unpf unpf join ourpension.individual i on unpf.insurance_number = i.insurance_number
union all
select uovm.id, uovm.smev_register_id, null as contract_id, i.id as individual_id, 'uovm' as registry_type from report.smev_uovm uovm join ourpension.individual i on uovm.insurance_number = i.insurance_number
union all
select uops.id, smev_register_id, null as contract_id, i.id as individual_id, 'uops' as registry_type from report.smev_uops uops join ourpension.individual i on uops.insurance_number = i.insurance_number
union all
select id, smev_register_id, null as contract_id, null as individual_id, 'uspn' as registry_type from report.smev_uspn uspn 
union all
select iszl.id, iszl.smev_register_id, null as contract_id, i.id as individual_id, 'iszl' as registry_type from report.smev_iszl iszl join ourpension.individual i on iszl.insurance_number = i.insurance_number
union all 
select uvmsk.id, smev_register_id, null as contract_id, i.id as individual_id, 'uvmsk' as registry_type from report.smev_uvmsk uvmsk join ourpension.individual i on uvmsk.insurance_number = i.insurance_number
union all 
select rpfr.id, smev_register_id, null as contract_id, i.id as individual_id, 'rpfr' as registry_type from report.smev_rpfr rpfr join ourpension.individual i on rpfr.insurance_number = i.insurance_number
union all 
select nspn.id, smev_register_id, null as contract_id, i.id as individual_id, 'nspn' as registry_type from report.smev_nspn nspn join ourpension.individual i on nspn.insurance_number = i.insurance_number
union all 
select uier.id, smev_register_id, null as contract_id, i.id as individual_id, 'uier' as registry_type from report.smev_uier uier join ourpension.individual i on uier.insurance_number = i.insurance_number
union all
select uker.id, smev_register_id, null as contract_id, i.id as individual_id, 'uker' as registry_type from report.smev_uker uker join ourpension.individual i on uker.insurance_number = i.insurance_number
union all 
select npf.id, smev_register_id, null as contract_id, i.id as individual_id, 'npf' as registry_type from report.smev_npf npf join ourpension.individual i on npf.insurance_number = i.insurance_number
union all
select uzev_dds_sfr.id, smev_register_id, null as contract_id, i.id as individual_id, 'uzev_dds_sfr' as registry_type from report.smev_uzev_dds_sfr uzev_dds_sfr join ourpension.individual i on uzev_dds_sfr.insurance_number = i.insurance_number
) s on s.smev_register_id = sr.id
join report.smev_register_codes src on sr.smev_register_type_code = src.short_name
left join dev.model_file_to_verification mftv on sr.verified_file_id = mftv.id
WHERE 
s.individual_id = :individual_id

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

order by sr.date