[load_grdList]
SELECT 
  uri.den_no
, uri.syori_ymd
, uri.biko1 as title
, uri.tok_nm
, uri.zeinuki_gaku as j_kingaku
, uri2.zeinuki_gaku as kingaku
, sir.kingaku as sir_kingaku
, syk.s_kingaku as syk_kingaku
, uri2.zeinuki_gaku - syk.s_kingaku as income
, round((uri2.zeinuki_gaku - syk.s_kingaku) / uri2.zeinuki_gaku * 100, 2)   as income_rate
, (case when(uri.zeinuki_gaku = uri2.zeinuki_gaku)then('Š®—¹')else('')end) as syukka_flg
, (case when(coalesce(sir2.kingaku,0) = 0)then('')when(sir.kingaku >= sir2.kingaku)then('')else('Žd“üŽc')end) as haccyu_flg
FROM t_uri uri
left join m_tokui tk on (uri.tok_cd = tk.tok_cd)
left join m_hanyo h1 on (h1.mst_kbn = '01' and h1.han_cd = uri.prc_sts)
left join m_hanyo h2 on (h2.mst_kbn = '09' and h2.han_cd = tk.furikikan)
left join (select jucyu_no, sum(zeinuki_gaku) as zeinuki_gaku from t_uri group by jucyu_no) uri2 on (uri.den_no = uri2.jucyu_no)
left join (select jucyu_no, sum(kingaku) as kingaku from t_sir_m a
				inner join t_sir b on a.den_no=b.den_no and hacyu_flg = 0
				group by jucyu_no) sir on (uri.den_no = sir.jucyu_no)
left join (select jucyu_no, sum(kingaku) as kingaku from t_sir_m a
				inner join t_sir b on a.den_no=b.den_no and hacyu_flg = 1
				group by jucyu_no) sir2 on (uri.den_no = sir2.jucyu_no)
left join (select jucyu_no, sum(kingaku) as s_kingaku from t_syuko group by jucyu_no) syk on (uri.den_no = syk.jucyu_no)
WHERE 1 = 1
and uri.jucyu_flg = 1
and uri.del_flg = 0
--	and uri.syori_ymd != ''
and ((uri.den_no = fnc_to_number(':den_no')) or ('' = ':den_no'))
and (('' = ':syori_ymd_fr') or (uri.syori_ymd >= ':syori_ymd_fr'))
and (('' = ':syori_ymd_to') or (uri.syori_ymd <= ':syori_ymd_to'))
and (('' = ':prc_sts') or (uri.prc_sts = ':prc_sts'))
and (('' = ':tok_cd') or (uri.tok_cd = ':tok_cd'))
and ((tk.tok_nm like '%:tok_nm%') or ('' = ':tok_nm'))
and ((uri.biko1 like '%:biko1%' or uri.biko2 like '%:biko1%') or ('' = ':biko1'))
and (('' = ':tori_kbn') or (tk.tok_cd is not null and tk.tori_kbn = ':tori_kbn'))
and ((':nk_cond' != '0') or (uri.keshi_flg = 0))
and ((':nk_cond' != '1') or (uri.keshi_flg = 1))
order by uri.syori_ymd , uri.den_no

[doSeikyu]
update t_uri set
  seikyu_flg = 1
, seikyu_ymd = to_char(now(),'yyyymmdd')
, upd_id = ':login_id'
, upd_time = now()
where den_no = :w_upd_key_value
and seikyu_flg = 0

[doNyukin]
update t_uri set
  keshi_flg = 1
, keshi_ymd = to_char(now(),'yyyymmdd')
, upd_id = ':login_id'
, upd_time = now()
where den_no = :w_upd_key_value
and keshi_flg = 0


[delete_w0110]
delete from w_basr0110
where s_id = :s_id
;

[insert_w0110]
insert into w_basr0110
(s_id, den_no)
SELECT 
 :s_id
 ,uri.den_no
FROM t_uri uri
left join m_tokui tk on (uri.tok_cd = tk.tok_cd)
left join m_hanyo h1 on (h1.mst_kbn = '01' and h1.han_cd = uri.prc_sts)
left join m_hanyo h2 on (h2.mst_kbn = '09' and h2.han_cd = tk.furikikan)
WHERE 1 = 1
and uri.jucyu_flg = 0
and uri.syori_ymd != ''
and ((uri.den_no = fnc_to_number(':den_no')) or ('' = ':den_no'))
and (('' = ':syori_ymd_fr') or (uri.syori_ymd >= ':syori_ymd_fr'))
and (('' = ':syori_ymd_to') or (uri.syori_ymd <= ':syori_ymd_to'))
and (('' = ':prc_sts') or (uri.prc_sts = ':prc_sts'))
and (('' = ':tok_cd') or (uri.tok_cd = ':tok_cd'))
and ((tk.tok_nm like '%:tok_nm%') or ('' = ':tok_nm'))
and ((uri.biko1 like '%:biko1%' or uri.biko2 like '%:biko1%') or ('' = ':biko1'))
and (('' = ':tori_kbn') or (tk.tok_cd is not null and tk.tori_kbn = ':tori_kbn'))
and ((':nk_cond' != '0') or (uri.keshi_flg = 0))
and ((':nk_cond' != '1') or (uri.keshi_flg = 1))
;