---

SELECT
  r.id as id,
  to_char(r.date, 'dd.MM.yyyy') as date,
  r.year as year,
  r.number as number,
  case when mftv.zip_name is null then
  case when mftv.name is not null then
    '<a target="_blank" href="modelFileToVerification/modelFileToVerification/downloadSource?id='|| mftv.id ||'" '|| 
        case when mftv.name is null then 'style="color: #d9534f;"' else '' end ||'>	
    <span class="glyphicon glyphicon-file" aria-hidden="true"></span>' || case when mftv.name = '' then 
         '' else mftv.name end || '</a>'
  else ''
  end
else 
   '<a target="_blank" href="modelFileToVerification/modelFileToVerification/downloadArchive?ArchiveName='|| mftv.zip_name 
     ||'" '|| '>
    <span class="glyphicon glyphicon-file" aria-hidden="true"></span>' || mftv.zip_name ||   '</a>'
end as verified_file_id,
  case when  mftv.id is not null then
    '<a target="_blank" href="view?viewCode=9hUIiHYU&ids=' || mftv.id ||'">	
    <span class="glyphicon glyphicon-book" aria-hidden="true"></span>' || ' ' || mftv.id || '</a>'
else
    ' '
end as journal_id,
  case mftv.count when 1 then 'Сформирован'
        when 2 then 'Проверяется'
        when 3 then 'ФЛК пройден'
  	when 4 then 'Ошибка ФЛК'
        when 5 then 'Отправлен'
  	else ''
end as sfr_status,
  '<a href="queryDataSource/ufvhPMTj/queryDataSourceFile/download?id='|| smev.get_sk_file_id(r.sk1) ||'" '|| 
case when r.sk1 is not null then 
    case when smev.get_sk_file_status_id(r.sk1) = 0 then 'style="color: #d9534f;"' else '' end
end ||'>	
<span class="glyphicon glyphicon-file" aria-hidden="true"></span>' || case when r.sk1 is not null then 
    case when smev.get_sk_file_status_id(r.sk1) = 0 then 'Ошибка' else 'Отчёт' end
end || '</a>' as sk1,
  '<a href="queryDataSource/ufvhPMTj/queryDataSourceFile/download?id='|| smev.get_sk_file_id(r.sk2) ||'" '|| 
case when r.sk2 is not null then 
    case when smev.get_sk_file_status_id(r.sk2) = 0 then 'style="color: #d9534f;"' else '' end
end ||'>	
<span class="glyphicon glyphicon-file" aria-hidden="true"></span>' || case when r.sk2 is not null then 
    case when smev.get_sk_file_status_id(r.sk2) = 0 then 'Ошибка' else 'Отчёт' end
end || '</a>' as sk2,
  mftv.name as sfr_file_name,
  r.description as decription,
  mftv.id as v_file_id,
  mftv.count in (3,5) as ready_to_upload,
  r.short_name as short_name,
  r.inn as inn,
  r.kpp as kpp,
  r.address as address,
  r.guid as guid,
  r.username as username,
  to_char(r.version, 'DD.MM.YYYY HH24:MI:SS') as version 
FROM report.smev_register r
left join dev.model_file_to_verification mftv on r.verified_file_id = mftv.id
WHERE (case when :like_sign = false 
 then r.smev_register_type_code = any(string_to_array(:registerType, ','))
 else r.smev_register_type_code in ('РПФР-ДСВ','РПФР-М','РПФР-СВ') end)
AND case  
when :id = -1 then true
when :id is null then false 
else r.id = :id
end