[getKino]
select kino_id
from v_kino

[deleteLogin]
delete from t_local_storage
where term_id = ':w_login_term'
and store_key = 'login'



[load_grdList]
select v.den_kbn, v.kbn, v.den_no, v.syori_ymd, v.tok_nm, v.koutei_no, v.tan_nm, v.ok_flg, v.caution1, v.biko
from v_todo v
where 1=1
and v.kbn = ':kbn';

[load_grdListExport]
SELECT 		'製造不良'::text AS den_kbn,
            '3'::text AS kbn,
            ts.shiji_no AS den_no,
            to_char(to_date(ts.syori_ymd,'yyyymmdd'),'yyyy/mm/dd') as syori_ymd,
			--tsm.end_time,
            jyu.tok_nm,
            tsm.koutei_no,
            tsm.koutei_nm AS tan_nm,
            ((('未完成：'::text || ((tst.suryo)::integer)::text) || ' / '::text) || (COALESCE(sum(ts2.suryo), ts.suryo))::text) AS caution1,
			(
                CASE
                    WHEN (COALESCE(ts.dshiji_no, ts.shiji_no) <> ts.shiji_no) THEN ((('親：'::text || (ts.dshiji_no)::text) || '/ 製品：'::text) || (mh.hin_nm)::text)
                    ELSE ''::text
                END ||
                CASE
                    WHEN (ts.syukka_flg = 1) THEN '出荷済'::text
                    ELSE ''::text
                END) AS biko
		FROM ((((t_seizou ts
			JOIN t_seizou_m tsm ON ((tsm.shiji_no = ts.shiji_no)))
			JOIN t_seizou_tan tst ON (((tst.shiji_no = ts.shiji_no) AND (tsm.koutei_no = tst.koutei_no))))
			LEFT JOIN t_uri jyu ON (((ts.jucyu_no = jyu.den_no) AND (jyu.jucyu_flg = 1))))
			LEFT JOIN t_seizou ts2 ON ((ts2.dshiji_no = ts.dshiji_no))
			LEFT JOIN m_hin mh ON ((mh.hin_cd = ts.hin_cd)))
--		WHERE ((tsm.status <> 3 ) and ((tst.tan_cd)::text = '99999'::text) AND ((1 = 1) AND (ts.del_flg = '0'::smallint)) AND (coalesce(tsm.mng1_flg,0) = 0 ) AND end_time < (DATE_TRUNC('month', now())))
--20200909改修分↓
		WHERE ((tsm.status <> 3 ) and ((tst.tan_cd)::text = '99999'::text) AND ((1 = 1) AND (ts.del_flg = '0'::smallint)) AND (coalesce(tsm.mng1_flg,0) = 0 ))
			AND (tsm.shiji_no, tsm.koutei_no) in (select den_no, row_no from w_todo where s_id = :s_id)
--20200909改修分↑
			AND exists (select 1 from t_uri_m jyum where jyum.den_no = jyu.den_no and (COALESCE(jyum.jucyu_su,0) - COALESCE(jyum.uri_su,0) > 0))
		GROUP BY ts.shiji_no,ts.syori_ymd, tsm.koutei_no, tsm.koutei_nm, ((('未完成：'::text || ((tst.suryo)::integer)::text) || ' / '::text) || (ts.suryo)::text), tst.suryo, ts.dshiji_no, jyu.tok_nm,mh.hin_nm,tsm.end_time
		order by ts.syori_ymd;

--20200909改修分↓
[del_w_todo]
delete from w_todo where s_id = :s_id;

[ins_w_todo]
insert into w_todo
	(s_id, den_no, row_no, del_flg, cre_id, cre_time, upd_id, upd_time)
values
	(:s_id, ':den_no', ':koutei_no', 0, ':tan_cd', now(), 'tan_cd', now());


[Del_ToDo]
update t_seizou_m m set mng1_flg = 1
where (m.shiji_no , m.koutei_no)
in(select den_no, row_no from w_todo where s_id = :s_id);

[Del_ToDo_old]
update t_seizou_m m set mng1_flg = 1
where (m.shiji_no , m.koutei_no)
in(SELECT 		ts.shiji_no,
			tsm.koutei_no
		FROM ((((t_seizou ts
			JOIN t_seizou_m tsm ON ((tsm.shiji_no = ts.shiji_no)))
			JOIN t_seizou_tan tst ON (((tst.shiji_no = ts.shiji_no) AND (tsm.koutei_no = tst.koutei_no))))
			LEFT JOIN t_uri jyu ON (((ts.jucyu_no = jyu.den_no) AND (jyu.jucyu_flg = 1))))
			LEFT JOIN t_seizou ts2 ON ((ts2.dshiji_no = ts.dshiji_no))
			LEFT JOIN m_hin mh ON ((mh.hin_cd = ts.hin_cd)))
		WHERE ((tsm.status <> 3 ) and ((tst.tan_cd)::text = '99999'::text) AND ((1 = 1) AND (ts.del_flg = '0'::smallint)) AND (coalesce(tsm.mng1_flg,0) = 0 ) AND end_time < (DATE_TRUNC('month', now())))
			AND exists (select 1 from t_uri_m jyum where jyum.den_no = jyu.den_no and (COALESCE(jyum.jucyu_su,0) - COALESCE(jyum.uri_su,0) > 0))
		GROUP BY ts.shiji_no, ts.syori_ymd, tsm.koutei_no, tsm.koutei_nm, ((('未完成：'::text || ((tst.suryo)::integer)::text) || ' / '::text) || (ts.suryo)::text), tst.suryo, ts.dshiji_no, jyu.tok_nm,mh.hin_nm)

[getkengen]
select mt.tan_cd,
	mt.tan_nm,
	mt.auth_kbn,
	mk.kino_id
from m_tanto mt
left join m_kengen mk on (mk.auth_kbn = mt.auth_kbn)
where kino_id = 'TODO.DEL'
and mt.tan_cd = ':login_id'
;

--20200909改修分↑