<?php 

// Заполнение нормативно-правовой базы проверки по задаче

require_once "un.api.php";
$log->log("ok");
$sch=$ui->getfield('SYS_GUID'); 	
$count1 = "select count(sys_guid) from check_npa_f where check_npa_f.sys_guidfk = '$sch'";
$db->exec($count1);
$sql = "insert into check_npa_f (check_npa_f.sys_guidfk, check_npa_f.ofidocfk)
		select '$sch',
		sys_guid from  (select distinct npa_base.sys_guid from npa_base
		left join npa_events on npa_base.sys_guid=npa_events.sys_guidfk
		left join checks_events on checks_events.sys_guid=npa_events.events
		left join CHECK_F_EVENT on CHECK_F_EVENT.EVENTS = CHECKS_EVENTS.SYS_GUID
		left join CHECKS_F on CHECK_F_EVENT.SYS_GUIDFK = CHECKS_F.SYS_GUID
		where checks_f.sys_guid='$sch' and npa_base.sys_guid not in  (select check_npa_f.ofidocfk from
		check_npa_f where check_npa_f.sys_guidfk='$sch'))
		";
$db->exec($sql);
$count = "select count(sys_guid) from check_npa_f where check_npa_f.sys_guidfk = '$sch'";
$msg = 'Записей добавлено: '.$db->getone($count).' Записей было: '.$db->getone($count1);
gt_state($msg);
$ui->refresh('CHECK_NPA_F');
?>