/*2024.76*/

UPDATE OR INSERT INTO XML_STRUCTURE (ID, NAME, CAPTION, VERS, PARENT_ID, USER_ID, USE_IN_TRAINING, IS_SHOW, OKATO_REG, STRUCT_TYPE, FORMAT_TYPE, MED_DOC_CODE)
                             VALUES (64, 'Ôàéë Ðåãèîíàëüíûõ äàííûõ Ìóðìàíñê', '', '3.2', NULL, 1, 0, 0, '47000', NULL, NULL, NULL)
                           MATCHING (ID);

COMMIT WORK;

UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641562, 64, 'TOWN_HOSP', '', '
', 1641553, 'Ó', 2, 3, 0, 1, 1641553, 0, 'IIF(Q_U = 2, ''027'', NULL)', 0, NULL, 25, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641563, 64, 'PURPOSE', '', '
', 1641553, 'Ó', 2, 3, 0, 1, 1641553, 0, 'iif(q_u = 2, iif(ZSD.P_CEL=''3.1'',610, 607),null)', 0, NULL, 28, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641564, 64, 'SERV_METOD', '', '
', 1641553, 'Ó', 2, 3, 0, 1, 1641553, 0, 'IIF(Q_U = 2, ''000'',NULL)', 0, NULL, 30, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641552, 64, 'BED_PROF', '', '
', 1641534, 'Í', 2, 3, 0, 1, 1641534, 0, 'NULL', 0, NULL, 20, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641553, 64, 'USL', '', '
', 1641534, 'ÓÌ', NULL, NULL, NULL, 1, 1641534, 2, 'select * 
from zsd zsd 
          LEFT JOIN ZS ZS ON ZS.ID = ZSD.ZS_ID
          LEFT JOIN ZS_HDR ZS_ ON ZS_.ID = ZS.HDR_ID
          LEFT JOIN INVOICE INV ON INV.ID = ZS_.NAME
where zsd.ZSD_ID = :MAS_ZSD.ID AND COALESCE(ZSD.CODE_USL,'''') <> ''''', 0, NULL, 22, 'select F.RDB$FIELD_ID ID,
R.RDB$RELATION_NAME RELATION_NAME,
replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn,
cast(f.rdb$description as varchar(250)) as fd
from RDB$RELATIONS R
JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME
where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0)
and (R.RDB$RELATION_NAME in (''ZSD''))
and f.rdb$description <> '' ''
order by fd', NULL, NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641565, 64, 'VID_FIN', '', '
', 1641553, 'Ó', 1, 1, 0, 1, 1641553, 1, '1', 0, NULL, 31, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641532, 64, 'REG_LIST', '', '
', NULL, 'Î', NULL, NULL, NULL, 1, 1641532, 2, 'select * from INVOICE Inv join zs_hdr zs_ on zs_.name = inv.id left join contragents con on con.id = inv.contragent_id where zs_.id = :hdr_id', 0, NULL, 1, 'select F.RDB$FIELD_ID ID,
R.RDB$RELATION_NAME RELATION_NAME,
replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn,
cast(f.rdb$description as varchar(250)) as fd
from RDB$RELATIONS R
JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME
where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0)
and (R.RDB$RELATION_NAME in (''INVOICE'',''ZS_HDR'',''CONTRAGENTS''))
and f.rdb$description <> '' ''
order by fd', NULL, NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641566, 64, 'PAY_MODE', '', '
', 1641553, 'Ó', 1, 2, 0, 1, 1641553, 0, 'IIF(Q_U IN (1,3), 1, 33)', 0, NULL, 32, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641567, 64, 'PR_OPER', '', '
', 1641553, 'Ó', 1, 3, 0, 1, 1641553, 1, '0', 0, NULL, 33, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641533, 64, 'ZGLV', '', '
', 1641532, 'Î', NULL, NULL, NULL, 1, 1641532, 3, '', 0, NULL, 2, NULL, NULL, NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641534, 64, 'SLUCH', '', '
', 1641532, 'ÎÌ', NULL, NULL, NULL, 1, 1641532, 2, 'select * 
from zs zs join patients pat on pat.id = zs.patient_id
     join zs_hdr zs_ on zs_.id = zs.hdr_id
     join invoice inv on inv.id = zs_.name
    join zsd zsd on zsd.zs_id = zs.id
where zs.hdr_id = :hdr_id
and zsd.id =zsd.zsd_id
 and target not in (9,10,13,14,15,16,17,18) and coalesce(zs.vid_hmp, '''') = ''''  and (((select IS_ONK from SP_CHECK_REESTR_AS_ONK(DS1, ZS.ID)) <> 1) AND (coalesce(ZS.ds_onk,0) <> 1))', 0, NULL, 10, 'select F.RDB$FIELD_ID ID,
R.RDB$RELATION_NAME RELATION_NAME,
replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn,
cast(f.rdb$description as varchar(250)) as fd
from RDB$RELATIONS R
JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME
where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0)
and (R.RDB$RELATION_NAME in (''ZS'',''PATIENTS'',''ZS_HDR'',''INVOICE'',''ZSD''))
and f.rdb$description <> '' ''
order by fd', NULL, NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641535, 64, 'VERSION', '', '
', 1641533, 'Î', 2, 5, 0, 1, 1641532, 1, '3.2', 0, NULL, 3, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641536, 64, 'DATA', '', '
', 1641533, 'Î', 3, 0, 0, 1, 1641532, 0, 'CURRENT_DATE', 0, NULL, 4, 'select F.RDB$FIELD_ID ID,
R.RDB$RELATION_NAME RELATION_NAME,
replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn,
cast(f.rdb$description as varchar(250)) as fd
from RDB$RELATIONS R
JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME
where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0)
and (R.RDB$RELATION_NAME in ())
and f.rdb$description <> '' ''
order by fd', 'YYYY-MM-DD', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641537, 64, 'FILENAME', '', '
', 1641533, 'Î', 2, 26, 0, 1, 1641532, 0, '''TM'' || INV.LPU ||  (select first 1 podr from zs where hdr_id = zs_.id) || ''027'' ||  iif(char_length(CON.ORG_CODE) > 2,''S'',''T'') || CON.ORG_CODE || ''_'' || substring(ZS_.Y from 3 for 2) || LPAD(ZS_.M,2,''0'') || INV.NPP', 0, NULL, 5, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641538, 64, 'FILENAME1', '', '
', 1641533, 'Î', 2, 26, 0, 1, 1641532, 0, '''HM'' || INV.LPU || (select first 1 podr from zs where hdr_id = zs_.id) || ''027'' || iif(char_length(CON.ORG_CODE) > 2,''S'',''T'') || CON.ORG_CODE || ''_'' || substring(ZS_.Y from 3 for 2) || LPAD(ZS_.M,2,''0'') || INV.NPP', 0, NULL, 6, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641539, 64, 'SUMMA', '', '
', 1641533, 'ÎÌ', NULL, NULL, NULL, 1, 1641532, 3, '', 0, NULL, 7, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641540, 64, 'SUMMAV', '', '
', 1641539, 'Î', 1, 15, 2, 1, 1641532, 0, '(select sum(zs.sum_uslf) 
from zs zs 
where zs.hdr_id = :hdr_id
 and target not in (9,10,13,14,15,16,17,18) and coalesce(vid_hmp, '''') = ''''  and (((select IS_ONK from SP_CHECK_REESTR_AS_ONK(DS1, ZS.ID)) <> 1) AND (coalesce(ZS.ds_onk,0) <> 1)))', 0, NULL, 8, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641541, 64, 'VID_FIN', '', '
', 1641539, 'Î', 1, 1, 0, 1, 1641532, 1, '1', 0, NULL, 9, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641542, 64, 'SL_ID', '', '
', 1641534, 'Î', 2, 36, 0, 1, 1641534, 0, 'ZSD.GUID_ID', 0, NULL, 11, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641543, 64, 'COUNT', '', '
', 1641534, 'Î', 2, 20, 0, 1, 1641534, 0, 'INV.NPP
', 0, NULL, 12, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641568, 64, 'NPR_DATE', '', '
', 1641553, 'Ó', 3, 0, 0, 1, 1641553, 0, 'ZS.DIRECTION_DATE', 0, NULL, 34, NULL, 'YYYY-MM-DD', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641544, 64, 'R_MP', '', '
', 1641534, 'Î', 2, 1, 0, 1, 1641534, 0, 'IIF(Q_U = 4, 1, 0)', 0, NULL, 13, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641545, 64, 'KRIM', '', '
', 1641534, 'Ó', 2, 1, 0, 1, 1641534, 0, 'IIF(Q_U IN (1,3), ''0'', NULL)', 0, NULL, 14, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641546, 64, 'TOWN_HOSP', '', '
', 1641534, 'Î', 2, 3, 0, 1, 1641534, 1, '027', 0, NULL, 15, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641547, 64, 'SUM', '', '
', 1641534, 'ÎÌ', NULL, NULL, NULL, 1, 1641534, 3, '', 0, NULL, 16, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641548, 64, 'ZS', '', '
', 1641534, 'Ó', 1, 1, 0, 1, 1641534, 0, 'IIF(Q_U IN (1,3), IIF((SELECT MIN(FINE_KOEF) from zsd WHERE KSG IS NOT NULL AND ZS_ID = :MAS_ZS_ID) < 1, 0,1),NULL)', 0, NULL, 21, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641569, 64, 'P_OTK', '', '
', 1641553, 'Ó', 1, 1, 0, 1, 1641553, 1, '0', 0, NULL, 38, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641570, 64, 'SNILS_DOC', '', '
', 1641553, 'Î', 2, 14, 0, 1, 1641553, 0, '(select ss from doctors where id = ZSD.PHYS_ID)', 0, NULL, 35, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641549, 64, 'TALON', '', '
', 1641534, 'Ó', 2, 6, 0, 1, 1641534, 0, 'iif(q_u in (1,3), ZS.DIRECTION_NUM, null)', 0, NULL, 19, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641571, 64, 'ADDR_CODE', '', '
', 1641553, 'Î', 2, 16, 0, 1, 1641553, 0, 'iif(zsd.lpu_1 = ''51043101'', ''4700051043101001'',''4700051043102002'')', 0, NULL, 36, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641572, 64, 'SUB_HOSP', '', '
', 1641553, 'Î', 2, 3, 0, 1, 1641553, 0, 'ZSD.PODR', 0, NULL, 37, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641551, 64, 'PURPOSE', '', '
', 1641534, 'Ó', 2, 3, 0, 1, 1641534, 0, 'iif(q_u = 2, iif(ZSD.P_CEL=''3.1'',610, 607),null)', 0, NULL, 39, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641554, 64, 'SNILS_DOC', '', '
', 1641534, 'Î', 2, 14, 0, 1, 1641534, 0, '(select ss from doctors where id = ZSD.PHYS_ID)', 0, NULL, 40, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641555, 64, 'ADDR_CODE', '', '
', 1641534, 'Î', 2, 16, 0, 1, 1641534, 0, 'iif(zsd.lpu_1 = ''51043101'', ''4700051043101001'',''4700051043102002'')', 0, NULL, 41, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641556, 64, 'SUB_HOSP', '', '
', 1641534, 'Î', 2, 3, 0, 1, 1641534, 0, 'ZSD.PODR', 0, NULL, 42, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641557, 64, 'RSLT', '', '
', 1641534, 'Ó', 1, 3, 0, 1, 1641534, 0, 'IIF(Q_U IN (1,3),ZS.RESULT, NULL)', 0, NULL, 43, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641558, 64, 'ISHOD', '', '
', 1641534, 'Ó', 1, 3, 0, 1, 1641534, 0, 'IIF(Q_U IN (1,3), ZS.OUTCOME, NULL)', 0, NULL, 44, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641559, 64, 'SUMV', '', '
', 1641547, 'Î', 1, 15, 2, 1, 1641534, 0, 'ZS.SUM_USLF', 0, NULL, 17, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641560, 64, 'VID_FIN', '', '
', 1641547, 'Î', 1, 1, 0, 1, 1641534, 1, '1', 0, NULL, 18, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641561, 64, 'IDSERV', '', '
', 1641553, 'Î', 2, 36, 0, 1, 1641553, 0, 'ZSD.ID', 0, NULL, 23, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641573, 64, 'REASON', '', '
', 1641553, 'Ó', 1, 2, 0, 1, 1641553, 0, 'IIF(Q_U = 2 and coalesce(npr_mo,'''') <> '''', 4, NULL)', 0, NULL, 29, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641919, 64, 'DIRECT_LPU', '', '
', 1641553, 'Ó', 2, 3, 0, 1, 1641553, 0, 'IIF(coalesce(npr_mo,'''') <> '''', substring(npr_mo from 4 for 3), NULL)', 0, NULL, 24, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641920, 64, 'DIR_SUBLPU', '', '
', 1641553, 'Ó', 2, 3, 0, 1, 1641553, 0, 'IIF(coalesce(npr_mo,'''') <> '''', substring(NPR_PODR from 1 for 3), NULL)', 0, NULL, 26, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1641921, 64, 'DIR_TOWN', '', '
', 1641553, 'Ó', 2, 3, 0, 1, 1641553, 0, 'IIF(coalesce(npr_mo,'''') <> '''', LPAD((select first 1 reg_code from h_lpu where code = npr_mo),3,0), NULL)', 0, NULL, 27, NULL, '', NULL)
                       MATCHING (ID);
UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY)
                         VALUES (1651164, 64, 'ALFA3', '', '
', 1641534, 'Î', 2, 3, 0, 1, 1641534, 1, 'RUS', 0, NULL, 45, NULL, '', NULL)
                       MATCHING (ID);

COMMIT WORK;

update xml_items
set id = id
where xml_structure_id = 64;