updatedibook_kiki

select * from reggd

select * from desa where desaid='230B32B5CE944A5AE040A8C003001C9F'

select * from berkas where berkasnomor='4492' and berkasyear=2007

select * from dibook where berkasid='c2fd397c632545e5925c1e573b3d7ec0'

select * from berkasprosedur

select count(*), berkasid
from berkasprosedur where prosedurcode='31' and prosedurorder=1
group by berkasid
having count(*) = 1

select * from dibook
where exists (select 1
from berkasprosedur where prosedurcode='31' and prosedurorder=1
and berkasprosedur.berkasid=dibook.berkasid
group by berkasid
having count(*) = 1)
and dikode in ('DI301','DI208')
order by berkasid

select * from dibook
where exists (select 1
from berkasprosedur where prosedurcode='31' and prosedurorder=1
and berkasprosedur.berkasid=dibook.berkasid
group by berkasid
having count(*) = 1)
and dikode ='DI208'
and ditanggal <
(select ditanggal + 7 from dibook a
where a.berkasid=dibook.berkasid and dikode='DI301' and rownum=1)
order by berkasid

select * from dibook where berkasid='1df8833d21e349e3adf884d43bdba7b1'

and ditanggal <> (select ditanggal + 7 from dibook c
where exists (select 1
from berkasprosedur a where a.prosedurcode='31' and a.prosedurorder=1
and a.berkasid=dibook.berkasid and c.berkasid=a.berkasid)
and dikode ='DI301' and dibook.berkasid=c.berkasid)

select * from register where berkasid='1df8833d21e349e3adf884d43bdba7b1'

select * from regdi where regid='c5481f7d755244b1a3b90778ce8d37ca'


select * from dibook where berkasid='00005ee693744041894de35f57372f75'
and dikode='DI301'

select ditanggal + 7 from dibook where berkasid='00005ee693744041894de35f57372f75'
and dikode='DI301'