[load_grdList]
select
  t.anken_cd
, t.anken_nm
, t.start_ymd
, t.jucyu_ymd
, fnc_get_anken_ops(t.anken_cd) as all_op_nm
, mt1.tan_nm as tan1_nm
, mt2.tan_nm as tan2_nm
, mt3.tan_nm as tan3_nm
, mt4.tan_nm as tan4_nm
, r.val_id
, r.val_nm
from t_anken t
inner join (
select 1 as val_id, '事業計画' as val_nm where :row1 = 1
union all select 2 as val_id, '実施計画' as val_nm where :row2 = 1
union all select 3 as val_id, '対事業計画差異' as val_nm where :row3 = 1
union all select 4 as val_id, '実施日' as val_nm where :row4 = 1
union all select 5 as val_id, '対実施計画差異' as val_nm where :row5 = 1
union all select 6 as val_id, '工程毎差異' as val_nm where :row6 = 1
) r on (1 = 1)
left join t_anken_tan t1 on (t1.anken_cd = t.anken_cd and t1.tan_kind = '01')
left join t_anken_tan t2 on (t2.anken_cd = t.anken_cd and t2.tan_kind = '02')
left join t_anken_tan t3 on (t3.anken_cd = t.anken_cd and t3.tan_kind = '03')
left join t_anken_tan t4 on (t4.anken_cd = t.anken_cd and t4.tan_kind = '04')
left join m_tanto mt1 on (mt1.tan_cd = t1.tan_cd)
left join m_tanto mt2 on (mt2.tan_cd = t2.tan_cd)
left join m_tanto mt3 on (mt3.tan_cd = t3.tan_cd)
left join m_tanto mt4 on (mt4.tan_cd = t4.tan_cd)
where 1 = 1
and ((t.anken_cd = ':anken_cd') or ('' = ':anken_cd'))
and (('' = ':syori_ymd_fr') or (t.start_ymd >= ':syori_ymd_fr'))
and (('' = ':syori_ymd_to') or (t.start_ymd <= ':syori_ymd_to'))
--and ((':nk_cond' != '0') or (uri.keshi_flg = 0))
--and ((':nk_cond' != '1') or (uri.keshi_flg = 1))
order by t.start_ymd desc, t.anken_cd desc, r.val_id

[getKouteiFields]
select koutei_cd, koutei_nm, kousyu_cd
from v_m_koutei
order by sort_key

[getKouteiValue1]
select koutei_cd, '' as val
from t_anken_m
where anken_cd = ':w_anken_cd'
order by koutei_no

[getKouteiValue2]
select koutei_cd, to_char(yotei_end_time,'yyyy/mm/dd') as val
from t_anken_m
where anken_cd = ':w_anken_cd'
order by koutei_no

[getKouteiValue3]
select koutei_cd, 0 as val
from t_anken_m
where anken_cd = ':w_anken_cd'
order by koutei_no

[getKouteiValue4]
select koutei_cd, to_char(end_time,'yyyy/mm/dd') as val
from t_anken_m
where anken_cd = ':w_anken_cd'
order by koutei_no

[getKouteiValue5]
select koutei_cd, 0 as val
from t_anken_m
where anken_cd = ':w_anken_cd'
order by koutei_no

[getKouteiValue6]
select koutei_cd, 0 as val
from t_anken_m
where anken_cd = ':w_anken_cd'
order by koutei_no









[deleteRowWork]
delete from w_basv3020_row where s_id = :s_id

[insertRowWork]
insert into w_basv3020_row (s_id, row_kind, del_flg, cre_id, cre_time, upd_id, upd_time)
values (:s_id, :row_kind, 0, ':login_id', now(), ':login_id', now())