[load_grdList]
select 
(case when(mth.tok_cd is not null)then(1)else(0) end) as checkbox
, mt.tok_cd
, mt.tok_nm
from m_tokui mt
left join m_tok_hin mth on (mth.tok_cd = mt.tok_cd and mth.hin_cd = ':hin_cd')
order by mt.tok_cd, mt.tok_nm
;

[chkHin]
select
 coalesce(hin_cd,'') as chk_hin
from m_hin
where hin_cd = ':hin_cd'

[getDisp]
select 
 coalesce(tok_dsp_kbn,'0') as tok_dsp_kbn
from m_hin
where hin_cd = ':hin_cd'
;

[existKengen]
select
  m1.kino_id
, m1.kino_nm
, (case when(m2.kino_id is not null)then(1)else(0) end) as checkbox
from v_kino m1
left join m_kengen m2 on (m2.auth_kbn = '98' and m2.kino_id = m1.kino_id)
;

[updateBeforeChecked]
delete from m_tok_hin
where hin_cd = ':hin_cd'


[updateRecord]
insert into m_tok_hin (
tok_cd, hin_cd, del_flg, cre_id, cre_time, upd_id, upd_time
) values (
':tok_cd', ':hin_cd', 0, ':login_id', now(), ':login_id', now()
)
;

[updateDisp]
update m_hin set tok_dsp_kbn = ':tok_dsp_kbn'
where hin_cd = ':hin_cd'