เปลี่ยนตามอาจารย์ ใช้ได้แล้วครับ

แต่ผมงงนิดหนึ่งครับตรงที่ Shot date แบบเดิม " วันที่เริ่มใช้ " บันทึกได้ แต่ " วันหมดอายุ " กลับบันทึกไม่ได้นะครับ แต่ไม่เป็นไรแล้วครับ

ขอบคุณมากครับอาจารย์ 

ขอบคุณครับอาจารย์ 

การคำนวน DRG ของผู้ป่วยในที่มีการลง ICD9 ประมาณ 25 รายการขึ้นไปจะมีการลงลำดับความสำคัญของ ICD9 แต่พอโปรแกรมส่งเข้าไปคำนวนกลับไม่เรียงลำดับตามความสำคัญครับ แต่เรียงตามวันที่และเวลา

ตามนี้ครับ

 select idx.*,doctor.name as dname,icd9cm1.name as icdname from iptoprt idx  left outer join doctor on doctor.code=idx.doctor  left outer join icd9cm1 on icd9cm1.code=idx.icd9  where idx.an='550027502' order by idx.opdate,idx.optime

-------------------------------------------------------------------------------------------------------------------------

ไฟล์  transact.txt


select bw from ipt where an='550027502'
select idx.*,doctor.name as dname,icd101.name as icdname,diagtype.name as dxname  from iptdiag idx  left outer join doctor on doctor.code=idx.doctor  left outer join icd101 on icd101.code=idx.icd10  left outer join diagtype on diagtype.diagtype=idx.diagtype  where idx.an='550027502' order by idx.diagtype,idx.ipt_diag_id
select name from icd101 where code='B200'
SHOW KEYS FROM hos.icd101
select name from icd101 where code = 'B20'
select name from icd101 where code='A162'
select name from icd101 where code = 'A16'
select name from icd101 where code='G442'
select name from icd101 where code = 'G44'
select dchstts from ipt where an='550027502'
select name from dchstts where dchstts='02'
SHOW KEYS FROM hos.dchstts
select count(*) as cc from sys_var where sys_name='track-ipt-trx'
select sys_value from sys_var where sys_name='track-ipt-trx'
select an from ipt where an = '550027502'
select * from ipt where an='550027502' 
select ipd_hour_cut from pttype where pttype = '89'
select * from opitemrece where an='550027502' order by rxdate,rxtime,order_no,icode
SHOW TABLES FROM hos LIKE 'opitemrece'
SHOW COLUMNS FROM hos.opitemrece LIKE '%'
select now() as cc
select * from ward_pc_online where computer_name = 'PERJER4675'
UPDATE ward_pc_onlineSET  last_agent_active = '2012-10-24 09:24:29'WHERE  computer_name = 'PERJER4675'
SHOW KEYS FROM hos.opitemrece
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','UPDATE ward_pc_online\r\nSET\r\n  last_agent_active = \'2012-10-24 09:24:29\'\r\nWHERE\r\n  computer_name = \'PERJER4675\'')
select * from iptdiag where an='550027502' and diagtype='1'
SHOW KEYS FROM hos.iptdiag
select * from an_stat where an='550027502'
SHOW KEYS FROM hos.an_stat
select * from inc_ipd_stat where an='550027502'
SHOW TABLES FROM hos LIKE 'inc_ipd_stat'
SHOW COLUMNS FROM hos.inc_ipd_stat LIKE '%'
SHOW KEYS FROM hos.inc_ipd_stat
select pttypeno from ipt_pttype where an='550027502' and pttype_number=1
SHOW TABLES FROM hos LIKE 'ipt_pttype'
SHOW COLUMNS FROM hos.ipt_pttype LIKE '%'
SHOW KEYS FROM hos.ipt_pttype
select hospmain from ovst where hn='510038528' and vstdate='2012-09-21'
SHOW KEYS FROM hos.ovst
select hospsub from ovst where hn='510038528' and vstdate='2012-09-21'
select max(vn) as vn from vn_stat where hn='510038528'  and vstdate='2012-09-21'
select r.rcpno from rcpt_print r  where r.vn='550027502' and r.rcpno not in (select rcpno from rcpt_abort where vn = '550027502')
SHOW TABLES FROM hos LIKE 'rcpt_print'
SHOW COLUMNS FROM hos.rcpt_print LIKE '%'
SHOW KEYS FROM hos.rcpt_print
select debt_id from rcpt_debt where vn='550027502'  and debt_id not in (select debt_id from rcpt_debt_cancel where vn = '550027502')
SHOW TABLES FROM hos LIKE 'rcpt_debt'
SHOW COLUMNS FROM hos.rcpt_debt LIKE '%'
SHOW KEYS FROM hos.rcpt_debt
select pcode from pttype where pttype='89'
select in_region from pttype where pttype='89'
select region_type from pttype where pttype='89'
select * from iptoprt where an='550027502' order by priority,opdate,optime
SHOW KEYS FROM hos.iptoprt
select * from iptdiag where an='550027502' and diagtype<>'1' order by ipt_diag_id
select a.an from ipt a  where a.hn = '510038528' and a.regdate< '2012-09-21' and dchdate is not null order by regdate desc limit 1
select * from ipt where an='550019744'
select pdx from an_stat where hn='510038528' and regdate < '2012-09-21' order by regdate desc limit 1
select hn,sex,chwpart,amppart,tmbpart,birthday from patient where hn='510038528'
select count(an) as cc from ipt where hn='510038528' and an<'550027502' and regdate between '2012-09-01' and '2012-09-30'
select count(an) as cc from ipt where hn='510038528' and an<'550027502' and regdate between '2012-01-01' and '2012-12-31'
select spclty from ipt where an='550027502'
select leave_home_day from ipt where an = '550027502'
select count(*) as cc from ipt where an='550027502' and dchdate is not null
select pttype,paidst,discount,debtor from pttype where pttype='89'
select count(*) as cc from sys_var where sys_name='income_auto_type_1'
select sys_value from sys_var where sys_name='income_auto_type_1'
select count(*) as cc from ipt_income_auto where an='550027502'
SHOW TABLES FROM hos LIKE 'ipt_income_auto'
SHOW COLUMNS FROM hos.ipt_income_auto LIKE '%'
select count(*) as cc from sys_var where sys_name='income_auto_type_2'
select sys_value from sys_var where sys_name='income_auto_type_2'
select p1.pcode from ipt i,pttype p1 where i.an = '550027502' and i.pttype = p1.pttype
select hos_guid from opitemrece where an='550027502' and (finance_number is NULL or finance_number='')
select hos_guid from opitemrece where an='550027502' and (finance_number is NULL or finance_number=''  or (finance_number<>'' and income='') )
select icode from s_drugitems where must_paid='Y' and paidst<>'03' and icode in ('1500068','1500235','1500293','1500309','1500371','1500529','1500553','1500631','1500779','3000001','3000137','3000139','3000140','3000145','3001211','3001372','3002008','3002408','3002409','3503170','3501162','3501237','3501744','3501753','3501552','3501586','1510004','3501185','3501263','3501940','3501965','3502099','3501872','3501873','3000198','1500736','3000073','3005350','1500161','1500527','3501206','3501208','1500353','1500435','1500366','3502117','3504144','1500069','3501176','3501964','1500236')
SHOW TABLES FROM hos LIKE 's_drugitems'
SHOW COLUMNS FROM hos.s_drugitems LIKE '%'
SHOW KEYS FROM hos.s_drugitems
select icode from s_drugitems where must_paid='Y' and paidst<>'03' and icode in ('1500068','1500235','1500293','1500309','1500371','1500529','1500553','1500631','1500779','3000001','3000137','3000139','3000140','3000145','3001211','3001372','3002008','3002408','3002409','3503170','3501162','3501237','3501744','3501753','3501552','3501586','1510004','3501185','3501263','3501940','3501965','3502099','3501872','3501873','3000198','1500736','3000073','3005350','1500161','1500527','3501206','3501208','1500353','1500435','1500366','3502117','3504144','1500069','3501176','3501964','1500236') and icode in ('')
select icode from s_drugitems where must_paid='Y' and paidst='03' and icode in ('1500068','1500235','1500293','1500309','1500371','1500529','1500553','1500631','1500779','3000001','3000137','3000139','3000140','3000145','3001211','3001372','3002008','3002408','3002409','3503170','3501162','3501237','3501744','3501753','3501552','3501586','1510004','3501185','3501263','3501940','3501965','3502099','3501872','3501873','3000198','1500736','3000073','3005350','1500161','1500527','3501206','3501208','1500353','1500435','1500366','3502117','3504144','1500069','3501176','3501964','1500236') and icode in ('')
select icode from drugitems where drugaccount<>'' and drugaccount is not null and icode in ('1500068','1500235','1500293','1500309','1500371','1500529','1500553','1500631','1500779','3000001','3000137','3000139','3000140','3000145','3001211','3001372','3002008','3002408','3002409','3503170','3501162','3501237','3501744','3501753','3501552','3501586','1510004','3501185','3501263','3501940','3501965','3502099','3501872','3501873','3000198','1500736','3000073','3005350','1500161','1500527','3501206','3501208','1500353','1500435','1500366','3502117','3504144','1500069','3501176','3501964','1500236')
SHOW TABLES FROM hos LIKE 'drugitems'
SHOW COLUMNS FROM hos.drugitems LIKE '%'
SHOW KEYS FROM hos.drugitems
select icode from drugitems where (drugaccount='' or drugaccount is null) and icode in ('1500068','1500235','1500293','1500309','1500371','1500529','1500553','1500631','1500779','3000001','3000137','3000139','3000140','3000145','3001211','3001372','3002008','3002408','3002409','3503170','3501162','3501237','3501744','3501753','3501552','3501586','1510004','3501185','3501263','3501940','3501965','3502099','3501872','3501873','3000198','1500736','3000073','3005350','1500161','1500527','3501206','3501208','1500353','1500435','1500366','3502117','3504144','1500069','3501176','3501964','1500236')
select count(*) as cc from sys_var where sys_name='MIRROR_OPI_TRX'
select sys_value from sys_var where sys_name='MIRROR_OPI_TRX'
select finance_status from ipt_finance_status where an = '550027502'
SHOW KEYS FROM hos.ipt_finance_status
select * from ipt_pttype where an = '550027502' order by pttype_number
select order_no from ipt_order_no where an = '550027502' and order_type = 'TRx'
SHOW TABLES FROM hos LIKE 'ipt_order_no'
SHOW COLUMNS FROM hos.ipt_order_no LIKE '%'
SHOW KEYS FROM hos.ipt_order_no
select order_no from ipt_order_no where an = '550027502' and order_type = 'Hme'
select use_contract_id from pttype where pttype='89'
select max_debt_money from pttype where pttype='89'
select count(*) as cc from ovst_finance where vn = '550027502' and finance_status < 9
SHOW TABLES FROM hos LIKE 'ovst_finance'
SHOW COLUMNS FROM hos.ovst_finance LIKE '%'
select vn from ipt where an = '550027502'
select hos_guid from opitemrece_charge where vn = '550920212048' and vn<>''
SHOW TABLES FROM hos LIKE 'opitemrece_charge'
SHOW COLUMNS FROM hos.opitemrece_charge LIKE '%'
SHOW KEYS FROM hos.opitemrece_charge
select * from opitemrece_charge where vn = '550027502'
select charge_guid from opitemrece_charge where vn = '550027502'
select * from opitemrece limit 0
select * from opitemrece_charge where vn = '550027502'
select * from inc_ipd_stat where an='550027502'
UPDATE inc_ipd_stat SET uinc01=0,uinc04=0,uinc06=0,uinc12=0,uinc14=0,uinc16=0,uinc17=0 WHERE an='550027502'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','UPDATE inc_ipd_stat SET uinc01=0,uinc04=0,uinc06=0,uinc12=0,uinc14=0,uinc16=0,uinc17=0 WHERE an=\'550027502\'')
select * from an_stat where an='550027502'
UPDATE an_stat SET inc01=0,inc04=0,inc06=0,inc12=0,inc14=0,inc16=0,inc17=0 WHERE an='550027502'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','UPDATE an_stat SET inc01=0,inc04=0,inc06=0,inc12=0,inc14=0,inc16=0,inc17=0 WHERE an=\'550027502\'')
select * from an_stat where an='550027502'
select discount from pttype where pttype='89'
select hos_guid from patient where hn='510038528'
select count(*) as cc from ipt where an='550027502' and dchdate is NULL
update patient set admit = 'N' where hos_guid in ('{FBF676CD-9B9A-4346-BECC-C62C0BE94E46}')
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','update patient set admit = \'N\' where hos_guid in (\'{FBF676CD-9B9A-4346-BECC-C62C0BE94E46}\')')
select hos_guid from opitemrece where an='550027502'
select * from inc_ipd_stat where an='550027502'
delete from incith where an='550027502'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','delete from incith where an=\'550027502\'')
select * from incith where an='550027502' and paidst = '02'
SHOW TABLES FROM hos LIKE 'incith'
SHOW COLUMNS FROM hos.incith LIKE '%'
SHOW KEYS FROM hos.incith
select income,paidst,sum(sum_price) as sp from opitemrece where an='550027502' and paidst = '02' group by income,paidst   
select r2.income as income,sum(r2.amount) as sp  from rcpt_debt r1,rcpt_debt_detail r2  where r1.vn='550027502' and r1.debt_id = r2.debt_id  group by r2.income
SHOW TABLES FROM hos LIKE 'rcpt_debt_detail'
SHOW COLUMNS FROM hos.rcpt_debt_detail LIKE '%'
select * from incith where an='550027502' and paidst = '02'
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','01','02',NULL,3000,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'01\',\'02\',NULL,3000,NULL,NULL,NULL,NULL,\'N\',NULL)')
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','03','02',NULL,629,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'03\',\'02\',NULL,629,NULL,NULL,NULL,NULL,\'N\',NULL)')
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','04','02',NULL,343,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'04\',\'02\',NULL,343,NULL,NULL,NULL,NULL,\'N\',NULL)')
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','05','02',NULL,172,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'05\',\'02\',NULL,172,NULL,NULL,NULL,NULL,\'N\',NULL)')
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','07','02',NULL,1665,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'07\',\'02\',NULL,1665,NULL,NULL,NULL,NULL,\'N\',NULL)')
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','08','02',NULL,10170,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'08\',\'02\',NULL,10170,NULL,NULL,NULL,NULL,\'N\',NULL)')
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','11','02',NULL,200,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'11\',\'02\',NULL,200,NULL,NULL,NULL,NULL,\'N\',NULL)')
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','12','02',NULL,3300,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'12\',\'02\',NULL,3300,NULL,NULL,NULL,NULL,\'N\',NULL)')
INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES ('550027502','2012-09-21','10:48:00','2012-09-21','10:48:00','16','02',NULL,1200,NULL,NULL,NULL,NULL,'N',NULL)
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','INSERT INTO incith (an,billdate,billtime,incdate,inctime,income,paidst,rcpno,rcptamt,`user`,computer,finance_number,porder,verify,pttype) VALUES (\'550027502\',\'2012-09-21\',\'10:48:00\',\'2012-09-21\',\'10:48:00\',\'16\',\'02\',NULL,1200,NULL,NULL,NULL,NULL,\'N\',NULL)')
select count(*) as cc from rcpt_print where vn='550027502' and department='IPD' and bill_amount>0
select income,paidst,sum(sum_price) as sp from opitemrece where an='550027502' and paidst in ('01','03') group by income,paidst
select income,paidst,sum(sum_price) as sp from opitemrece where an='550027502' and paidst in ('01','03') group by income,paidst   
select sum(sum_price) as cc from opitemrece where an = '550027502'
select sum(rcptamt) as cc from incith where an = '550027502'
select count(*) as cc from incith_summary where an='550027502'
SHOW TABLES FROM hos LIKE 'incith_summary'
SHOW COLUMNS FROM hos.incith_summary LIKE '%'
select sum(rcptamt) as cc from incith where an='550027502'
select sum(rcptamt) as cc from incith where an='550027502' and paidst = '02'
select sum(sum_price) as cc from opitemrece where an='550027502' and paidst in ('01','03')
select sum(bill_amount) as cc from rcpt_print where vn='550027502'
select sum(discount) as cc from rcpt_print where vn='550027502'
select sum(rcptamt) as cc from incith where an='550027502'
select sum(rcptamt) as cc from incith where an='550027502' and paidst = '00'
select sum(sum_price) as cc from opitemrece where an='550027502'
select pttype from ipt where an='550027502'
select spclty from ipt where an='550027502'
select g.income_group as income_group,sum(o.rcptamt) as samt  from income_group g,income i,incith o  where o.an='550027502'  and i.income=o.income  and g.income_group=i.income_group  group by g.income_group
SHOW TABLES FROM hos LIKE 'income_group'
SHOW COLUMNS FROM hos.income_group LIKE '%'
SHOW TABLES FROM hos LIKE 'income'
SHOW COLUMNS FROM hos.income LIKE '%'
select g.income_group as income_group,sum(o.rcptamt) as samt  from income_group g,income i,incith o  where o.an='550027502'  and i.income=o.income  and g.income_group=i.income_group and o.paidst in ('01','03') group by g.income_group
select sum(rcptamt) as cc from incith where an='550027502' and paidst in ('01','03') and income in ('03',17 )
select sum(rcptamt) as cc from incith where an='550027502' and paidst in ('01','03') and income in ('05')
select g.income_group as income_group,sum(o.rcptamt) as samt  from income_group g,income i,incith o  where o.an='550027502'  and i.income=o.income  and g.income_group=i.income_group and o.paidst in ('00','02') group by g.income_group
select sum(rcptamt) as cc from incith where an='550027502' and paidst in ('00','02') and income in ('03',17 )
select sum(rcptamt) as cc from incith where an='550027502' and paidst in ('00','02') and income in ('05')
select * from inc_ipd_stat where an='550027502'
UPDATE inc_ipd_stat SET uinc01=1665,uinc04=10170,uinc06=200,uinc12=1144,uinc14=1200,uinc16=3000,uinc17=3300,uincome=20679,uinc_drug=629 WHERE an='550027502'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','UPDATE inc_ipd_stat SET uinc01=1665,uinc04=10170,uinc06=200,uinc12=1144,uinc14=1200,uinc16=3000,uinc17=3300,uincome=20679,uinc_drug=629 WHERE an=\'550027502\'')
select * from an_stat where an='550027502'
UPDATE an_stat SET income=20679,uc_money=20679,item_money=20679,inc01=1665,inc04=10170,inc06=200,inc12=1144,inc14=1200,inc16=3000,inc17=3300 WHERE an='550027502'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','UPDATE an_stat SET income=20679,uc_money=20679,item_money=20679,inc01=1665,inc04=10170,inc06=200,inc12=1144,inc14=1200,inc16=3000,inc17=3300 WHERE an=\'550027502\'')
select * from ipt_pregnancy where an = '550027502'
SHOW TABLES FROM hos LIKE 'ipt_pregnancy'
SHOW COLUMNS FROM hos.ipt_pregnancy LIKE '%'
SHOW KEYS FROM hos.ipt_pregnancy
select * from iptbedmove where an = '550027502' order by movedate,movetime
select * from ipt_ward_stat where an = '550027502'
SHOW TABLES FROM hos LIKE 'ipt_ward_stat'
SHOW COLUMNS FROM hos.ipt_ward_stat LIKE '%'
SHOW KEYS FROM hos.ipt_ward_stat
select ward,first_ward,regdate,regtime,dchdate,dchtime from ipt where an = '550027502'
select vn from ipt where an = '550027502'
select hos_guid from opitemrece where an = '550027502'
select hos_guid from opitemrece_summary where vn in ('550027502' , '550920212048') 
SHOW TABLES FROM hos LIKE 'opitemrece_summary'
SHOW COLUMNS FROM hos.opitemrece_summary LIKE '%'
SHOW KEYS FROM hos.opitemrece_summary
select * from opitemrece_summary where hos_guid in ('{03824953-8AF6-4B89-B5CA-97BE8B2FD7F5}','{04D3525B-10DD-45CA-84CB-403625323243}','{0624F163-EECC-4999-9307-AF031C092BE9}','{09B481DD-9754-4C52-9DA6-AEFEDA32C749}','{0ACF20EE-11BD-4BDF-91EC-69EE274BA8A1}','{0B824033-7D2D-4C3A-A544-2A5094327CAD}','{0F7191B6-8D82-42A8-89AC-F3060D64C422}','{119941DE-BEAB-4003-8620-07C6565E3184}','{12C0F70F-27D6-4090-ACFF-41833FD5379F}','{1463C21F-4A7B-4602-83D9-ECFA83E88C91}','{1560E2C6-D40A-4F61-9A92-916CC68E6143}','{1B7F93CC-975E-4B6C-BBE2-066A7F7D323C}','{1B9450B2-1840-457F-BA84-71DC0F1E76C6}','{1C43AA5C-8FDE-41EC-A6B8-ECA112A6AE07}','{1D74413D-4508-49F6-ADB0-52D738B805B8}','{21A3BAA9-E832-45A7-8D63-666E17A6A46F}','{23D5CDA4-082D-45EF-A14A-DE0A64E3A482}','{29DDF63E-B344-4FFD-9FA3-25B067402EE6}','{2AF4B682-8672-43EC-B31C-71503E4A49D9}','{2BD1B338-1293-4267-BF32-8F2350CD81C8}','{2C8798A5-3309-4002-9573-FC0CCA16970E}','{2DDF9E00-50BE-4B1B-A37A-05C9006F4F46}','{3158BF1E-22AB-4A04-B063-5B9271624072}','{35B3ACFC-B209-4B81-AA37-9CBC9F0E15F3}','{36417892-CEA8-48A4-9541-266A636E424B}','{368CF7D2-72A2-4045-A4D7-00F774858D5F}','{3ED585B5-C9C5-4958-B3C8-7A282B2EC2AC}','{3F914063-CCDA-4EBE-BC8E-2DCE4594F93C}','{43863C22-C92D-4DBF-ACA1-D57632BDFDE7}','{460177AB-4AD1-4D59-A8EA-434F1147679D}','{4665FC34-EAD1-4D46-ADE2-F931747FD006}','{46ED5BB9-4B20-49B8-87EB-05FC2BFFB182}','{47CC6641-C04A-47E2-828A-B25F946730C3}','{4B42BFDE-A696-48C3-ADEE-4D505539CEC9}','{4C539B3F-3C4C-4469-8F13-1DE49A786C03}','{4D0F964A-50A2-4022-B62E-784F54B3CB25}','{4D6249CC-1DB7-41CB-8D62-F2A866FAC46C}','{4F6F389D-EF0A-4920-A19E-169B90245FCE}','{50181202-66E0-440D-A17F-5295BAC0E715}','{50794ADC-9305-4C34-8AB1-7DBB74115DDA}','{538D0A22-E934-4C86-8D35-AE5F90B76190}','{541AB0FF-2BAA-4BB6-9E5F-79FD277E1DC0}','{5601E651-F8D2-4CAB-8B4F-49CE68D34C96}','{569434A4-6FB6-4266-B255-F3A83EDA81D1}','{599E0455-1707-46A2-A2F1-E9E6D0EB1B9A}','{5BAE5D11-8660-4AFC-B3FE-BCE882A74239}','{5C459D9B-443E-43EF-9D42-F4D8956088BD}','{6162C970-3162-4D6D-B886-58BE3D71D419}','{66EC4930-DB50-4D14-BFA5-C6B991AA37A7}','{6AD1F526-5E0C-42EF-89EB-6430F18AA6E3}','{6B21FE47-4359-45DA-8542-98451747FFFB}','{6E5A2A20-B49C-4987-97F4-CB4FEFB44A81}','{70C54D8C-2BDA-45C1-8443-CEE149B3DB82}','{75400951-E7ED-4DD9-9D60-9E098CC2E7DA}','{77B1B2CE-CEDB-474E-96E6-6C70F693B0C0}','{78813221-0761-419C-9015-FC7391A3D079}','{78DB50CA-2DF3-40E1-8FD6-F8F657C509A6}','{7927A6C8-0786-41F2-A12E-13FEB0DAEF06}','{7C759350-0CE3-4229-9F1F-545DCF93D013}','{7D24CCE2-5670-4CA6-80BF-194D9D4BD437}','{7E2CC7B4-D90F-4F97-82BB-A89CEF9F851F}','{8263DCFF-319D-40B4-BCCA-06B8866D4001}','{82690002-7C17-4EBC-ABB4-D6195CBAAC52}','{8349CA6E-4D31-419E-A0E1-DE2D3B3FF52F}','{84000E2F-3EF8-4563-A162-4D39F0450EF0}','{8545F93C-F801-4E52-81FE-7E2867309B1E}','{85564DFC-7497-4BC2-88EB-25480CFCFD90}','{85BFA600-4740-44F7-B1C6-AE3C4D6F11C3}','{87E47CA6-F3A0-4D1F-B9E3-09DE9B36FB29}','{88420D0E-114E-470B-AAF4-B078D22788EC}','{889EC774-BEC9-4C97-A777-2D89ABE1E133}','{90D13118-DDB0-4360-BE72-358299F8D2F5}','{92B159F4-4442-4EDC-9D1E-69A3C15CE97A}','{92E47CC2-2E9D-45E4-9484-DECDC815A57C}','{943AF666-A846-4733-ACEE-E0A56D139C9C}','{998F41D3-10BE-47E3-850E-79F6B866FA9D}','{9E1C22C3-014B-4188-A8AB-5B1E3A5C1E4C}','{9E996C8B-C03E-4339-BE2A-C6FF413E3229}','{A38C6257-684C-4832-A7E8-A7D11717F1AE}','{A678C5DE-AF99-4E66-BECC-56AA623C6AE9}','{A6C39094-57E1-459C-98A3-AD070630F89D}','{A71EEDB9-13D7-47EA-98D6-5415B22BE21E}','{A8B6EE8C-0A53-4DA4-B7B9-C432BC752A9C}','{A9305116-D632-408D-B6B7-DECEDBB86C27}','{A9A8B9A1-8838-4326-B179-66F6C7ACEC60}','{AFE6CC5E-52AF-450E-8AF8-78065D511EAB}','{B3EB6EE9-DC68-4F22-8C85-DC0465B7DF8C}','{B50D768B-E880-411D-B5DA-3CC980F9F7FF}','{B6ED2D19-8132-47A7-9F51-910B6D4728B1}','{B795F006-C073-4DA0-BBFC-E07D9EEB4BE7}','{BA267995-C639-4BE2-BC62-C8CF1B2EA046}','{BA5161CC-483D-43AC-97B4-0321B9BB0E73}','{BB5981CF-3691-4B5A-B746-BCFE428B4D7F}','{BC9C22F7-C653-4E96-AEA9-7C3BF145FA47}','{BD02FEF6-1599-40AC-A3C8-241E0FD14B2D}','{C0DF404E-8BA6-4D17-8D5C-84D615B0C44C}','{C24C9B01-9B07-43A6-AD71-412C72344980}','{C3E0494A-DFD3-4E78-8B4C-5616FB964010}','{C3FEAD38-67BE-4A5A-8B54-4059A5DFDE4F}','{C403A43F-427F-4A03-A482-CCE65F098168}','{C6D656F9-E048-4C81-8644-781ADB470EBD}','{C7C2B1D5-6CF1-46B4-AE58-B783EA512515}','{C920E54F-E013-4313-8175-A613516C8368}','{D0C92B16-8BE6-4CA2-BA66-62FF833CAF96}','{D1B0AF1F-1047-4DE4-B86E-0E806FB88F96}','{D2C37DAB-D8AC-4E3F-BFE4-C6292DD5604F}','{D47A73ED-1175-44EF-852E-A13EB3CECCD1}','{D645B8D2-BB8F-4C43-9533-7E590CC9A186}','{D95C09D7-6657-4A90-B6B7-8596935526EB}','{D9B4BDC5-8E23-4D56-9202-FDFBBCF647A0}','{DABC442F-4AF9-43E5-BE5B-73EDFED9F408}','{DBF255E3-FD35-4EB8-91B5-B31966EEA88D}','{DC5FD0CE-31EE-4F70-AEE6-4DD7AFEC905D}','{DD691F3D-886D-486F-8C25-0F6CB51D23D1}','{DE577DB2-EEF3-4FCC-967D-B089BEA9E7E1}','{E44DF526-AEC7-474F-BD7B-49B7187AAAE4}','{E559B67B-C246-49CA-936E-B7AA7C88C7A4}','{E8BC3933-89CB-493F-A86A-41973B9915FF}','{E975A9EB-98E1-492B-B656-48AFB08D6630}','{EECB5A44-F62E-47D1-9E57-0DC05ECDD129}','{F34AEEF2-B1A4-4F91-B1AB-0DC37032FD0A}','{F3CC1149-2E57-4475-A94E-D185A449A6F0}','{F428EB2D-A450-438E-B638-8BF91F6202A1}','{F701E366-7A14-4E8C-BC45-A2B204009DFF}','{FA2E8586-DC26-42B0-BBB8-B6C60A73D175}','{FB52DC69-CE98-4509-B5C5-F8FFBAACA3B6}','{FD07A96F-DBC8-4FD9-A08B-975D55F0F8BD}','{FD900775-1BD9-4E71-987E-BFB9EB11FAB0}','{FE66A78F-8957-4FE7-9EF4-3C85E6381193}','{FF972041-CCBB-496D-82B0-C5F49B4754A8}','{03824953-8AF6-4B89-B5CA-97BE8B2FD7F5}','{04D3525B-10DD-45CA-84CB-403625323243}','{0624F163-EECC-4999-9307-AF031C092BE9}','{09B481DD-9754-4C52-9DA6-AEFEDA32C749}','{0ACF20EE-11BD-4BDF-91EC-69EE274BA8A1}','{0B824033-7D2D-4C3A-A544-2A5094327CAD}','{0F7191B6-8D82-42A8-89AC-F3060D64C422}','{119941DE-BEAB-4003-8620-07C6565E3184}','{11B73AE0-B649-4FCA-A295-596F4466CFBB}','{12C0F70F-27D6-4090-ACFF-41833FD5379F}','{1463C21F-4A7B-4602-83D9-ECFA83E88C91}','{1560E2C6-D40A-4F61-9A92-916CC68E6143}','{1B7F93CC-975E-4B6C-BBE2-066A7F7D323C}','{1B9450B2-1840-457F-BA84-71DC0F1E76C6}','{1C43AA5C-8FDE-41EC-A6B8-ECA112A6AE07}','{1D74413D-4508-49F6-ADB0-52D738B805B8}','{21A3BAA9-E832-45A7-8D63-666E17A6A46F}','{23D5CDA4-082D-45EF-A14A-DE0A64E3A482}','{29DDF63E-B344-4FFD-9FA3-25B067402EE6}','{2AF4B682-8672-43EC-B31C-71503E4A49D9}','{2BD1B338-1293-4267-BF32-8F2350CD81C8}','{2C8798A5-3309-4002-9573-FC0CCA16970E}','{2C9C10C0-2904-443E-9C83-39F0B42554CC}','{2DDF9E00-50BE-4B1B-A37A-05C9006F4F46}','{3158BF1E-22AB-4A04-B063-5B9271624072}','{35B3ACFC-B209-4B81-AA37-9CBC9F0E15F3}','{36417892-CEA8-48A4-9541-266A636E424B}','{368CF7D2-72A2-4045-A4D7-00F774858D5F}','{3ED585B5-C9C5-4958-B3C8-7A282B2EC2AC}','{3F914063-CCDA-4EBE-BC8E-2DCE4594F93C}','{43863C22-C92D-4DBF-ACA1-D57632BDFDE7}','{460177AB-4AD1-4D59-A8EA-434F1147679D}','{4665FC34-EAD1-4D46-ADE2-F931747FD006}','{46ED5BB9-4B20-49B8-87EB-05FC2BFFB182}','{47CC6641-C04A-47E2-828A-B25F946730C3}','{4B42BFDE-A696-48C3-ADEE-4D505539CEC9}','{4C539B3F-3C4C-4469-8F13-1DE49A786C03}','{4D0F964A-50A2-4022-B62E-784F54B3CB25}','{4D6249CC-1DB7-41CB-8D62-F2A866FAC46C}','{4F6F389D-EF0A-4920-A19E-169B90245FCE}','{50181202-66E0-440D-A17F-5295BAC0E715}','{50794ADC-9305-4C34-8AB1-7DBB74115DDA}','{530FE7E7-A898-4D93-8C9F-82EDF95A010C}','{538D0A22-E934-4C86-8D35-AE5F90B76190}','{541AB0FF-2BAA-4BB6-9E5F-79FD277E1DC0}','{5601E651-F8D2-4CAB-8B4F-49CE68D34C96}','{569434A4-6FB6-4266-B255-F3A83EDA81D1}','{599E0455-1707-46A2-A2F1-E9E6D0EB1B9A}','{5BAE5D11-8660-4AFC-B3FE-BCE882A74239}','{5C459D9B-443E-43EF-9D42-F4D8956088BD}','{5C5A5B57-F1E7-4DAB-AA78-F4B4E562621A}','{6162C970-3162-4D6D-B886-58BE3D71D419}','{61ABC2C4-02E3-43A2-BDBD-D2AEBE48018A}','{66EC4930-DB50-4D14-BFA5-C6B991AA37A7}','{6AD1F526-5E0C-42EF-89EB-6430F18AA6E3}','{6B21FE47-4359-45DA-8542-98451747FFFB}','{6E5A2A20-B49C-4987-97F4-CB4FEFB44A81}','{70C54D8C-2BDA-45C1-8443-CEE149B3DB82}','{75400951-E7ED-4DD9-9D60-9E098CC2E7DA}','{77B1B2CE-CEDB-474E-96E6-6C70F693B0C0}','{78813221-0761-419C-9015-FC7391A3D079}','{78DB50CA-2DF3-40E1-8FD6-F8F657C509A6}','{7927A6C8-0786-41F2-A12E-13FEB0DAEF06}','{79F2E83C-D68E-41A2-AEB5-D5C293720BC6}','{7C759350-0CE3-4229-9F1F-545DCF93D013}','{7D24CCE2-5670-4CA6-80BF-194D9D4BD437}','{7E2CC7B4-D90F-4F97-82BB-A89CEF9F851F}','{8263DCFF-319D-40B4-BCCA-06B8866D4001}','{82690002-7C17-4EBC-ABB4-D6195CBAAC52}','{8349CA6E-4D31-419E-A0E1-DE2D3B3FF52F}','{84000E2F-3EF8-4563-A162-4D39F0450EF0}','{8545F93C-F801-4E52-81FE-7E2867309B1E}','{85564DFC-7497-4BC2-88EB-25480CFCFD90}','{85BFA600-4740-44F7-B1C6-AE3C4D6F11C3}','{87E47CA6-F3A0-4D1F-B9E3-09DE9B36FB29}','{88420D0E-114E-470B-AAF4-B078D22788EC}','{889EC774-BEC9-4C97-A777-2D89ABE1E133}','{90D13118-DDB0-4360-BE72-358299F8D2F5}','{92B159F4-4442-4EDC-9D1E-69A3C15CE97A}','{92E47CC2-2E9D-45E4-9484-DECDC815A57C}','{943AF666-A846-4733-ACEE-E0A56D139C9C}','{998F41D3-10BE-47E3-850E-79F6B866FA9D}','{9E1C22C3-014B-4188-A8AB-5B1E3A5C1E4C}','{9E996C8B-C03E-4339-BE2A-C6FF413E3229}','{A38C6257-684C-4832-A7E8-A7D11717F1AE}','{A3943872-001D-43A3-A620-2CFEC99DCF5F}','{A678C5DE-AF99-4E66-BECC-56AA623C6AE9}','{A6C39094-57E1-459C-98A3-AD070630F89D}','{A71EEDB9-13D7-47EA-98D6-5415B22BE21E}','{A7BA4740-7F8D-4A27-8D9B-FE6157ABB794}','{A8B6EE8C-0A53-4DA4-B7B9-C432BC752A9C}','{A9305116-D632-408D-B6B7-DECEDBB86C27}','{A9A8B9A1-8838-4326-B179-66F6C7ACEC60}','{AFE6CC5E-52AF-450E-8AF8-78065D511EAB}','{B3EB6EE9-DC68-4F22-8C85-DC0465B7DF8C}','{B50D768B-E880-411D-B5DA-3CC980F9F7FF}','{B6ED2D19-8132-47A7-9F51-910B6D4728B1}','{B795F006-C073-4DA0-BBFC-E07D9EEB4BE7}','{BA267995-C639-4BE2-BC62-C8CF1B2EA046}','{BA5161CC-483D-43AC-97B4-0321B9BB0E73}','{BB5981CF-3691-4B5A-B746-BCFE428B4D7F}','{BC9C22F7-C653-4E96-AEA9-7C3BF145FA47}','{BD02FEF6-1599-40AC-A3C8-241E0FD14B2D}','{C0DF404E-8BA6-4D17-8D5C-84D615B0C44C}','{C24C9B01-9B07-43A6-AD71-412C72344980}','{C2E22B61-944A-4318-AB91-6B9E83035242}','{C3E0494A-DFD3-4E78-8B4C-5616FB964010}','{C3FEAD38-67BE-4A5A-8B54-4059A5DFDE4F}','{C403A43F-427F-4A03-A482-CCE65F098168}','{C6D656F9-E048-4C81-8644-781ADB470EBD}','{C7C2B1D5-6CF1-46B4-AE58-B783EA512515}','{C920E54F-E013-4313-8175-A613516C8368}','{D0C92B16-8BE6-4CA2-BA66-62FF833CAF96}','{D1B0AF1F-1047-4DE4-B86E-0E806FB88F96}','{D2C37DAB-D8AC-4E3F-BFE4-C6292DD5604F}','{D47A73ED-1175-44EF-852E-A13EB3CECCD1}','{D645B8D2-BB8F-4C43-9533-7E590CC9A186}','{D95C09D7-6657-4A90-B6B7-8596935526EB}','{D9B4BDC5-8E23-4D56-9202-FDFBBCF647A0}','{DABC442F-4AF9-43E5-BE5B-73EDFED9F408}','{DBF255E3-FD35-4EB8-91B5-B31966EEA88D}','{DC5FD0CE-31EE-4F70-AEE6-4DD7AFEC905D}','{DD691F3D-886D-486F-8C25-0F6CB51D23D1}','{DE577DB2-EEF3-4FCC-967D-B089BEA9E7E1}','{E44DF526-AEC7-474F-BD7B-49B7187AAAE4}','{E559B67B-C246-49CA-936E-B7AA7C88C7A4}','{E8BC3933-89CB-493F-A86A-41973B9915FF}','{E975A9EB-98E1-492B-B656-48AFB08D6630}','{EAC3EE69-B1D9-48C2-8452-24750D0648A9}','{EECB5A44-F62E-47D1-9E57-0DC05ECDD129}','{EFF44908-E323-4712-A341-06460BBE1BBE}','{F34AEEF2-B1A4-4F91-B1AB-0DC37032FD0A}','{F3CC1149-2E57-4475-A94E-D185A449A6F0}','{F428EB2D-A450-438E-B638-8BF91F6202A1}','{F701E366-7A14-4E8C-BC45-A2B204009DFF}','{FA2E8586-DC26-42B0-BBB8-B6C60A73D175}','{FB52DC69-CE98-4509-B5C5-F8FFBAACA3B6}','{FD07A96F-DBC8-4FD9-A08B-975D55F0F8BD}','{FD900775-1BD9-4E71-987E-BFB9EB11FAB0}','{FE4F652E-AF62-4FDD-AAA4-6193ED08EA5F}','{FE66A78F-8957-4FE7-9EF4-3C85E6381193}','{FF972041-CCBB-496D-82B0-C5F49B4754A8}')
select * from opitemrece_summary where hos_guid in ('{03824953-8AF6-4B89-B5CA-97BE8B2FD7F5}','{04D3525B-10DD-45CA-84CB-403625323243}','{0624F163-EECC-4999-9307-AF031C092BE9}','{09B481DD-9754-4C52-9DA6-AEFEDA32C749}','{0ACF20EE-11BD-4BDF-91EC-69EE274BA8A1}','{0B824033-7D2D-4C3A-A544-2A5094327CAD}','{0F7191B6-8D82-42A8-89AC-F3060D64C422}','{119941DE-BEAB-4003-8620-07C6565E3184}','{12C0F70F-27D6-4090-ACFF-41833FD5379F}','{1463C21F-4A7B-4602-83D9-ECFA83E88C91}','{1560E2C6-D40A-4F61-9A92-916CC68E6143}','{1B7F93CC-975E-4B6C-BBE2-066A7F7D323C}','{1B9450B2-1840-457F-BA84-71DC0F1E76C6}','{1C43AA5C-8FDE-41EC-A6B8-ECA112A6AE07}','{1D74413D-4508-49F6-ADB0-52D738B805B8}','{21A3BAA9-E832-45A7-8D63-666E17A6A46F}','{23D5CDA4-082D-45EF-A14A-DE0A64E3A482}','{29DDF63E-B344-4FFD-9FA3-25B067402EE6}','{2AF4B682-8672-43EC-B31C-71503E4A49D9}','{2BD1B338-1293-4267-BF32-8F2350CD81C8}','{2C8798A5-3309-4002-9573-FC0CCA16970E}','{2DDF9E00-50BE-4B1B-A37A-05C9006F4F46}','{3158BF1E-22AB-4A04-B063-5B9271624072}','{35B3ACFC-B209-4B81-AA37-9CBC9F0E15F3}','{36417892-CEA8-48A4-9541-266A636E424B}','{368CF7D2-72A2-4045-A4D7-00F774858D5F}','{3ED585B5-C9C5-4958-B3C8-7A282B2EC2AC}','{3F914063-CCDA-4EBE-BC8E-2DCE4594F93C}','{43863C22-C92D-4DBF-ACA1-D57632BDFDE7}','{460177AB-4AD1-4D59-A8EA-434F1147679D}','{4665FC34-EAD1-4D46-ADE2-F931747FD006}','{46ED5BB9-4B20-49B8-87EB-05FC2BFFB182}','{47CC6641-C04A-47E2-828A-B25F946730C3}','{4B42BFDE-A696-48C3-ADEE-4D505539CEC9}','{4C539B3F-3C4C-4469-8F13-1DE49A786C03}','{4D0F964A-50A2-4022-B62E-784F54B3CB25}','{4D6249CC-1DB7-41CB-8D62-F2A866FAC46C}','{4F6F389D-EF0A-4920-A19E-169B90245FCE}','{50181202-66E0-440D-A17F-5295BAC0E715}','{50794ADC-9305-4C34-8AB1-7DBB74115DDA}','{538D0A22-E934-4C86-8D35-AE5F90B76190}','{541AB0FF-2BAA-4BB6-9E5F-79FD277E1DC0}','{5601E651-F8D2-4CAB-8B4F-49CE68D34C96}','{569434A4-6FB6-4266-B255-F3A83EDA81D1}','{599E0455-1707-46A2-A2F1-E9E6D0EB1B9A}','{5BAE5D11-8660-4AFC-B3FE-BCE882A74239}','{5C459D9B-443E-43EF-9D42-F4D8956088BD}','{6162C970-3162-4D6D-B886-58BE3D71D419}','{66EC4930-DB50-4D14-BFA5-C6B991AA37A7}','{6AD1F526-5E0C-42EF-89EB-6430F18AA6E3}','{6B21FE47-4359-45DA-8542-98451747FFFB}','{6E5A2A20-B49C-4987-97F4-CB4FEFB44A81}','{70C54D8C-2BDA-45C1-8443-CEE149B3DB82}','{75400951-E7ED-4DD9-9D60-9E098CC2E7DA}','{77B1B2CE-CEDB-474E-96E6-6C70F693B0C0}','{78813221-0761-419C-9015-FC7391A3D079}','{78DB50CA-2DF3-40E1-8FD6-F8F657C509A6}','{7927A6C8-0786-41F2-A12E-13FEB0DAEF06}','{7C759350-0CE3-4229-9F1F-545DCF93D013}','{7D24CCE2-5670-4CA6-80BF-194D9D4BD437}','{7E2CC7B4-D90F-4F97-82BB-A89CEF9F851F}','{8263DCFF-319D-40B4-BCCA-06B8866D4001}','{82690002-7C17-4EBC-ABB4-D6195CBAAC52}','{8349CA6E-4D31-419E-A0E1-DE2D3B3FF52F}','{84000E2F-3EF8-4563-A162-4D39F0450EF0}','{8545F93C-F801-4E52-81FE-7E2867309B1E}','{85564DFC-7497-4BC2-88EB-25480CFCFD90}','{85BFA600-4740-44F7-B1C6-AE3C4D6F11C3}','{87E47CA6-F3A0-4D1F-B9E3-09DE9B36FB29}','{88420D0E-114E-470B-AAF4-B078D22788EC}','{889EC774-BEC9-4C97-A777-2D89ABE1E133}','{90D13118-DDB0-4360-BE72-358299F8D2F5}','{92B159F4-4442-4EDC-9D1E-69A3C15CE97A}','{92E47CC2-2E9D-45E4-9484-DECDC815A57C}','{943AF666-A846-4733-ACEE-E0A56D139C9C}','{998F41D3-10BE-47E3-850E-79F6B866FA9D}','{9E1C22C3-014B-4188-A8AB-5B1E3A5C1E4C}','{9E996C8B-C03E-4339-BE2A-C6FF413E3229}','{A38C6257-684C-4832-A7E8-A7D11717F1AE}','{A678C5DE-AF99-4E66-BECC-56AA623C6AE9}','{A6C39094-57E1-459C-98A3-AD070630F89D}','{A71EEDB9-13D7-47EA-98D6-5415B22BE21E}','{A8B6EE8C-0A53-4DA4-B7B9-C432BC752A9C}','{A9305116-D632-408D-B6B7-DECEDBB86C27}','{A9A8B9A1-8838-4326-B179-66F6C7ACEC60}','{AFE6CC5E-52AF-450E-8AF8-78065D511EAB}','{B3EB6EE9-DC68-4F22-8C85-DC0465B7DF8C}','{B50D768B-E880-411D-B5DA-3CC980F9F7FF}','{B6ED2D19-8132-47A7-9F51-910B6D4728B1}','{B795F006-C073-4DA0-BBFC-E07D9EEB4BE7}','{BA267995-C639-4BE2-BC62-C8CF1B2EA046}','{BA5161CC-483D-43AC-97B4-0321B9BB0E73}','{BB5981CF-3691-4B5A-B746-BCFE428B4D7F}','{BC9C22F7-C653-4E96-AEA9-7C3BF145FA47}','{BD02FEF6-1599-40AC-A3C8-241E0FD14B2D}','{C0DF404E-8BA6-4D17-8D5C-84D615B0C44C}','{C24C9B01-9B07-43A6-AD71-412C72344980}','{C3E0494A-DFD3-4E78-8B4C-5616FB964010}','{C3FEAD38-67BE-4A5A-8B54-4059A5DFDE4F}','{C403A43F-427F-4A03-A482-CCE65F098168}','{C6D656F9-E048-4C81-8644-781ADB470EBD}','{C7C2B1D5-6CF1-46B4-AE58-B783EA512515}','{C920E54F-E013-4313-8175-A613516C8368}','{D0C92B16-8BE6-4CA2-BA66-62FF833CAF96}','{D1B0AF1F-1047-4DE4-B86E-0E806FB88F96}','{D2C37DAB-D8AC-4E3F-BFE4-C6292DD5604F}','{D47A73ED-1175-44EF-852E-A13EB3CECCD1}','{D645B8D2-BB8F-4C43-9533-7E590CC9A186}','{D95C09D7-6657-4A90-B6B7-8596935526EB}','{D9B4BDC5-8E23-4D56-9202-FDFBBCF647A0}','{DABC442F-4AF9-43E5-BE5B-73EDFED9F408}','{DBF255E3-FD35-4EB8-91B5-B31966EEA88D}','{DC5FD0CE-31EE-4F70-AEE6-4DD7AFEC905D}','{DD691F3D-886D-486F-8C25-0F6CB51D23D1}','{DE577DB2-EEF3-4FCC-967D-B089BEA9E7E1}','{E44DF526-AEC7-474F-BD7B-49B7187AAAE4}','{E559B67B-C246-49CA-936E-B7AA7C88C7A4}','{E8BC3933-89CB-493F-A86A-41973B9915FF}','{E975A9EB-98E1-492B-B656-48AFB08D6630}','{EECB5A44-F62E-47D1-9E57-0DC05ECDD129}','{F34AEEF2-B1A4-4F91-B1AB-0DC37032FD0A}','{F3CC1149-2E57-4475-A94E-D185A449A6F0}','{F428EB2D-A450-438E-B638-8BF91F6202A1}','{F701E366-7A14-4E8C-BC45-A2B204009DFF}','{FA2E8586-DC26-42B0-BBB8-B6C60A73D175}','{FB52DC69-CE98-4509-B5C5-F8FFBAACA3B6}','{FD07A96F-DBC8-4FD9-A08B-975D55F0F8BD}','{FD900775-1BD9-4E71-987E-BFB9EB11FAB0}','{FE66A78F-8957-4FE7-9EF4-3C85E6381193}','{FF972041-CCBB-496D-82B0-C5F49B4754A8}','{03824953-8AF6-4B89-B5CA-97BE8B2FD7F5}','{04D3525B-10DD-45CA-84CB-403625323243}','{0624F163-EECC-4999-9307-AF031C092BE9}','{09B481DD-9754-4C52-9DA6-AEFEDA32C749}','{0ACF20EE-11BD-4BDF-91EC-69EE274BA8A1}','{0B824033-7D2D-4C3A-A544-2A5094327CAD}','{0F7191B6-8D82-42A8-89AC-F3060D64C422}','{119941DE-BEAB-4003-8620-07C6565E3184}','{11B73AE0-B649-4FCA-A295-596F4466CFBB}','{12C0F70F-27D6-4090-ACFF-41833FD5379F}','{1463C21F-4A7B-4602-83D9-ECFA83E88C91}','{1560E2C6-D40A-4F61-9A92-916CC68E6143}','{1B7F93CC-975E-4B6C-BBE2-066A7F7D323C}','{1B9450B2-1840-457F-BA84-71DC0F1E76C6}','{1C43AA5C-8FDE-41EC-A6B8-ECA112A6AE07}','{1D74413D-4508-49F6-ADB0-52D738B805B8}','{21A3BAA9-E832-45A7-8D63-666E17A6A46F}','{23D5CDA4-082D-45EF-A14A-DE0A64E3A482}','{29DDF63E-B344-4FFD-9FA3-25B067402EE6}','{2AF4B682-8672-43EC-B31C-71503E4A49D9}','{2BD1B338-1293-4267-BF32-8F2350CD81C8}','{2C8798A5-3309-4002-9573-FC0CCA16970E}','{2C9C10C0-2904-443E-9C83-39F0B42554CC}','{2DDF9E00-50BE-4B1B-A37A-05C9006F4F46}','{3158BF1E-22AB-4A04-B063-5B9271624072}','{35B3ACFC-B209-4B81-AA37-9CBC9F0E15F3}','{36417892-CEA8-48A4-9541-266A636E424B}','{368CF7D2-72A2-4045-A4D7-00F774858D5F}','{3ED585B5-C9C5-4958-B3C8-7A282B2EC2AC}','{3F914063-CCDA-4EBE-BC8E-2DCE4594F93C}','{43863C22-C92D-4DBF-ACA1-D57632BDFDE7}','{460177AB-4AD1-4D59-A8EA-434F1147679D}','{4665FC34-EAD1-4D46-ADE2-F931747FD006}','{46ED5BB9-4B20-49B8-87EB-05FC2BFFB182}','{47CC6641-C04A-47E2-828A-B25F946730C3}','{4B42BFDE-A696-48C3-ADEE-4D505539CEC9}','{4C539B3F-3C4C-4469-8F13-1DE49A786C03}','{4D0F964A-50A2-4022-B62E-784F54B3CB25}','{4D6249CC-1DB7-41CB-8D62-F2A866FAC46C}','{4F6F389D-EF0A-4920-A19E-169B90245FCE}','{50181202-66E0-440D-A17F-5295BAC0E715}','{50794ADC-9305-4C34-8AB1-7DBB74115DDA}','{530FE7E7-A898-4D93-8C9F-82EDF95A010C}','{538D0A22-E934-4C86-8D35-AE5F90B76190}','{541AB0FF-2BAA-4BB6-9E5F-79FD277E1DC0}','{5601E651-F8D2-4CAB-8B4F-49CE68D34C96}','{569434A4-6FB6-4266-B255-F3A83EDA81D1}','{599E0455-1707-46A2-A2F1-E9E6D0EB1B9A}','{5BAE5D11-8660-4AFC-B3FE-BCE882A74239}','{5C459D9B-443E-43EF-9D42-F4D8956088BD}','{5C5A5B57-F1E7-4DAB-AA78-F4B4E562621A}','{6162C970-3162-4D6D-B886-58BE3D71D419}','{61ABC2C4-02E3-43A2-BDBD-D2AEBE48018A}','{66EC4930-DB50-4D14-BFA5-C6B991AA37A7}','{6AD1F526-5E0C-42EF-89EB-6430F18AA6E3}','{6B21FE47-4359-45DA-8542-98451747FFFB}','{6E5A2A20-B49C-4987-97F4-CB4FEFB44A81}','{70C54D8C-2BDA-45C1-8443-CEE149B3DB82}','{75400951-E7ED-4DD9-9D60-9E098CC2E7DA}','{77B1B2CE-CEDB-474E-96E6-6C70F693B0C0}','{78813221-0761-419C-9015-FC7391A3D079}','{78DB50CA-2DF3-40E1-8FD6-F8F657C509A6}','{7927A6C8-0786-41F2-A12E-13FEB0DAEF06}','{79F2E83C-D68E-41A2-AEB5-D5C293720BC6}','{7C759350-0CE3-4229-9F1F-545DCF93D013}','{7D24CCE2-5670-4CA6-80BF-194D9D4BD437}','{7E2CC7B4-D90F-4F97-82BB-A89CEF9F851F}','{8263DCFF-319D-40B4-BCCA-06B8866D4001}','{82690002-7C17-4EBC-ABB4-D6195CBAAC52}','{8349CA6E-4D31-419E-A0E1-DE2D3B3FF52F}','{84000E2F-3EF8-4563-A162-4D39F0450EF0}','{8545F93C-F801-4E52-81FE-7E2867309B1E}','{85564DFC-7497-4BC2-88EB-25480CFCFD90}','{85BFA600-4740-44F7-B1C6-AE3C4D6F11C3}','{87E47CA6-F3A0-4D1F-B9E3-09DE9B36FB29}','{88420D0E-114E-470B-AAF4-B078D22788EC}','{889EC774-BEC9-4C97-A777-2D89ABE1E133}','{90D13118-DDB0-4360-BE72-358299F8D2F5}','{92B159F4-4442-4EDC-9D1E-69A3C15CE97A}','{92E47CC2-2E9D-45E4-9484-DECDC815A57C}','{943AF666-A846-4733-ACEE-E0A56D139C9C}','{998F41D3-10BE-47E3-850E-79F6B866FA9D}','{9E1C22C3-014B-4188-A8AB-5B1E3A5C1E4C}','{9E996C8B-C03E-4339-BE2A-C6FF413E3229}','{A38C6257-684C-4832-A7E8-A7D11717F1AE}','{A3943872-001D-43A3-A620-2CFEC99DCF5F}','{A678C5DE-AF99-4E66-BECC-56AA623C6AE9}','{A6C39094-57E1-459C-98A3-AD070630F89D}','{A71EEDB9-13D7-47EA-98D6-5415B22BE21E}','{A7BA4740-7F8D-4A27-8D9B-FE6157ABB794}','{A8B6EE8C-0A53-4DA4-B7B9-C432BC752A9C}','{A9305116-D632-408D-B6B7-DECEDBB86C27}','{A9A8B9A1-8838-4326-B179-66F6C7ACEC60}','{AFE6CC5E-52AF-450E-8AF8-78065D511EAB}','{B3EB6EE9-DC68-4F22-8C85-DC0465B7DF8C}','{B50D768B-E880-411D-B5DA-3CC980F9F7FF}','{B6ED2D19-8132-47A7-9F51-910B6D4728B1}','{B795F006-C073-4DA0-BBFC-E07D9EEB4BE7}','{BA267995-C639-4BE2-BC62-C8CF1B2EA046}','{BA5161CC-483D-43AC-97B4-0321B9BB0E73}','{BB5981CF-3691-4B5A-B746-BCFE428B4D7F}','{BC9C22F7-C653-4E96-AEA9-7C3BF145FA47}','{BD02FEF6-1599-40AC-A3C8-241E0FD14B2D}','{C0DF404E-8BA6-4D17-8D5C-84D615B0C44C}','{C24C9B01-9B07-43A6-AD71-412C72344980}','{C2E22B61-944A-4318-AB91-6B9E83035242}','{C3E0494A-DFD3-4E78-8B4C-5616FB964010}','{C3FEAD38-67BE-4A5A-8B54-4059A5DFDE4F}','{C403A43F-427F-4A03-A482-CCE65F098168}','{C6D656F9-E048-4C81-8644-781ADB470EBD}','{C7C2B1D5-6CF1-46B4-AE58-B783EA512515}','{C920E54F-E013-4313-8175-A613516C8368}','{D0C92B16-8BE6-4CA2-BA66-62FF833CAF96}','{D1B0AF1F-1047-4DE4-B86E-0E806FB88F96}','{D2C37DAB-D8AC-4E3F-BFE4-C6292DD5604F}','{D47A73ED-1175-44EF-852E-A13EB3CECCD1}','{D645B8D2-BB8F-4C43-9533-7E590CC9A186}','{D95C09D7-6657-4A90-B6B7-8596935526EB}','{D9B4BDC5-8E23-4D56-9202-FDFBBCF647A0}','{DABC442F-4AF9-43E5-BE5B-73EDFED9F408}','{DBF255E3-FD35-4EB8-91B5-B31966EEA88D}','{DC5FD0CE-31EE-4F70-AEE6-4DD7AFEC905D}','{DD691F3D-886D-486F-8C25-0F6CB51D23D1}','{DE577DB2-EEF3-4FCC-967D-B089BEA9E7E1}','{E44DF526-AEC7-474F-BD7B-49B7187AAAE4}','{E559B67B-C246-49CA-936E-B7AA7C88C7A4}','{E8BC3933-89CB-493F-A86A-41973B9915FF}','{E975A9EB-98E1-492B-B656-48AFB08D6630}','{EAC3EE69-B1D9-48C2-8452-24750D0648A9}','{EECB5A44-F62E-47D1-9E57-0DC05ECDD129}','{EFF44908-E323-4712-A341-06460BBE1BBE}','{F34AEEF2-B1A4-4F91-B1AB-0DC37032FD0A}','{F3CC1149-2E57-4475-A94E-D185A449A6F0}','{F428EB2D-A450-438E-B638-8BF91F6202A1}','{F701E366-7A14-4E8C-BC45-A2B204009DFF}','{FA2E8586-DC26-42B0-BBB8-B6C60A73D175}','{FB52DC69-CE98-4509-B5C5-F8FFBAACA3B6}','{FD07A96F-DBC8-4FD9-A08B-975D55F0F8BD}','{FD900775-1BD9-4E71-987E-BFB9EB11FAB0}','{FE4F652E-AF62-4FDD-AAA4-6193ED08EA5F}','{FE66A78F-8957-4FE7-9EF4-3C85E6381193}','{FF972041-CCBB-496D-82B0-C5F49B4754A8}')
DELETE FROM opitemrece_summary WHERE hos_guid='{11B73AE0-B649-4FCA-A295-596F4466CFBB}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{11B73AE0-B649-4FCA-A295-596F4466CFBB}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{2C9C10C0-2904-443E-9C83-39F0B42554CC}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{2C9C10C0-2904-443E-9C83-39F0B42554CC}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{530FE7E7-A898-4D93-8C9F-82EDF95A010C}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{530FE7E7-A898-4D93-8C9F-82EDF95A010C}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{5C5A5B57-F1E7-4DAB-AA78-F4B4E562621A}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{5C5A5B57-F1E7-4DAB-AA78-F4B4E562621A}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{61ABC2C4-02E3-43A2-BDBD-D2AEBE48018A}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{61ABC2C4-02E3-43A2-BDBD-D2AEBE48018A}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{79F2E83C-D68E-41A2-AEB5-D5C293720BC6}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{79F2E83C-D68E-41A2-AEB5-D5C293720BC6}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{A3943872-001D-43A3-A620-2CFEC99DCF5F}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{A3943872-001D-43A3-A620-2CFEC99DCF5F}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{A7BA4740-7F8D-4A27-8D9B-FE6157ABB794}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{A7BA4740-7F8D-4A27-8D9B-FE6157ABB794}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{C2E22B61-944A-4318-AB91-6B9E83035242}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{C2E22B61-944A-4318-AB91-6B9E83035242}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{EAC3EE69-B1D9-48C2-8452-24750D0648A9}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{EAC3EE69-B1D9-48C2-8452-24750D0648A9}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{EFF44908-E323-4712-A341-06460BBE1BBE}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{EFF44908-E323-4712-A341-06460BBE1BBE}\'')
DELETE FROM opitemrece_summary WHERE hos_guid='{FE4F652E-AF62-4FDD-AAA4-6193ED08EA5F}'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','DELETE FROM opitemrece_summary WHERE hos_guid=\'{FE4F652E-AF62-4FDD-AAA4-6193ED08EA5F}\'')
select * from ipt where an = '550027502'
select * from opitemrece_trx where an = '550027502'
SHOW TABLES FROM hos LIKE 'opitemrece_trx'
SHOW COLUMNS FROM hos.opitemrece_trx LIKE '%'
SHOW KEYS FROM hos.opitemrece_trx
update an_stat set dchdate = NULL where an = '550027502' and dchdate = '1899-12-30'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PERJER4675','update an_stat set dchdate = NULL where an = \'550027502\' and dchdate = \'1899-12-30\'')
select count(*) as cc from an_stat_resync where an = '550027502'
SHOW TABLES FROM hos LIKE 'an_stat_resync'
SHOW COLUMNS FROM hos.an_stat_resync LIKE '%'
select count(*) as cc from sys_var where sys_name='send-nhso-drug-dispensing'
select sys_value from sys_var where sys_name='send-nhso-drug-dispensing'
select a.*,i.regtime,i.dchtime,i.dchtype,i.dchstts,i.leave_home_day from an_stat a left outer join ipt i on i.an=a.an where a.an='550027502'
select birthday from patient where hn='510038528'
select icd10 from iptdiag where an = '550027502' and diagtype<>'1' order by diagtype,ipt_diag_id
select distinct icd9 from iptoprt where an = '550027502'
select count(an) as cc from ipt where an='550027502' and dchdate IS NULL
select count(an) as cc from ipt_newborn where an='550027502'
SHOW TABLES FROM hos LIKE 'ipt_newborn'
SHOW COLUMNS FROM hos.ipt_newborn LIKE '%'
select bw from  ipt where an='550027502'
select * from ipt where an = '550027502'
select * from an_stat where an = '550027502'
select idx.icd10 from iptdiag idx  where idx.diagtype='1' and idx.an='550027502'
select adjrw from ipt where an = '550027502'
select k.* ,o.name as user_name  from ksklog   k  left outer join opduser o on o.loginname=k.loginname  where k.tablename = 'IPTDIAG' and k.modifytype = 'EDIT'  and k.detail = '550027502'  order by k.ksklog_id
select lockdx  from ipt where an='550027502'
select idx.*,doctor.name as dname,icd9cm1.name as icdname from iptoprt idx  left outer join doctor on doctor.code=idx.doctor  left outer join icd9cm1 on icd9cm1.code=idx.icd9  where idx.an='550027502' order by idx.opdate,idx.optime
select count(*) as cc from ipt where an = '550027502' and ipt_type = 4

อนุโมทนาบุญสาธุด้วยนะครับอาจารย์ 

 - การค้นหาชื่อผู้ร่วมทำหัตถการทำได้ยากเนื่องจากระบบการค้นหาต้องพิมพ์ชื่อให้ถูกต้องทุกตัวอักษร รวมทั้งต้องพิมพ์คำนำหน้าชื่อให้ถูกต้องอีกด้วย

 - อยากให้ระบบการค้นหาเป็นแบบการค้นหาบางคำจากชื่อ

ยังไม่สามารถสมัคร อบรมได้ hrd ต้องลงเอง
รูปแบบยัง งง ๆ อยู่เล็กน้อย

เป็นเฟสแรกครับ คือให้ HRD ลงข้อมูลได้และออกรายงานสรุป

เฟสที่สอง คือ ให้ HRD เป็นผู้ลงหัวขอการประชุมและ บุคลากรผู้สนใจก็สมัคเข้าอบรม โดย HRD จะตรวจสอบและอนุมัติให้แค่นั้นครับ

และอีกระบบหนึ่งคือระบบงาน IC จะเริ่มพัฒนาในเดือนตุลาคมครับ โดยส่วนนี้ผมได้ผู้รวมงานมาช่วยทำ ก็จะทำให้สามารถทำได้เร็วขึ้นกว่าเดิม ถ้ามีเวลามากขึ้นก็จะได้พัฒนาเป็นแบบ OOP

นายสือกล่าวในส่วนเงินลงทุนในระบบ e-Office ว่าจะสามารถคืนทุนจากการลดต้นทุนในการบริหารจัดการองค์กรได้ภายในเวลา 4 – 8 เดือน

ผมกลัวมันจะไม่ตรงกับความต้องการการใช้งานนะครับ แต่ก็น่าจะดีมีของฟรีใช้กันงิงิงิงิ

เอาไปทดสอบกันได้เลยครับ HRD Demo ทำมาได้ 8 วันละครับ

เฟสต้อไป คือ การที่บุคลากรสามารถลงสมัคเข้าอบรมแบบออนไลน์ และการยืนยันการเข้ารวมอบรมโดยเจ้าหน้าที่ HRD ครับ ประมาณอีกสามวันครับ หากไม่มีงานเข้า 55555555555

      แก้ไขไฟล์ติดต่อฐานข้อมูลได้ที่ 4 ไฟล์นี้นะครับ
             host.txt
             dbasse.txt
             passwd.txt
             user.txt
      ฐานข้อมูล .sql อยู๋ใน folder DB นะครับลืมบอกไป

เขียน php เคยใช้แต่ EditPlus มีของใหม่แบบนี้ต้องลองซะแล้ว อิอิอิอิ

เช้าวันนี้เกิดปัญหาไม่สามารถตรวจสอบสิทธิผ่าน NHSO ได้ครับ มี Error ขึ้นเหมือนในรูปครับ ไม่ทราบว่าที่อื่นเป็นเหมือนกันไหมครับ

EurekaLog 6.0.20

Application:
-------------------------------------------------------
  1.1 Start Date      : Thu, 27 Aug 2009 08:59:16 +0700
  1.2 Name/Description: HOSMy.exe
  1.3 Version Number  : 3.52.7.12
  1.4 Parameters      :
  1.5 Compilation Date: Sun, 12 Jul 2009 12:02:15 +0700
  1.6 Up Time         : 2 minutes, 45 seconds

Exception:
--------------------------------------------------------------------------------------------------------------------------------------------------------------
  2.1 Date          : Thu, 27 Aug 2009 09:02:01 +0700
  2.2 Address       : 00ABAAC1
  2.3 Module Name   : HOSMy.exe
  2.4 Module Version: 3.52.7.12
  2.5 Type          : ESOAPHTTPException
  2.6 Message       : The connection with the server was reset - URL:http://ucws.nhso.go.th:80/RightsSearchService/RightsSearchServiceService - SOAPAction:"".
  2.7 ID            : DA0F
  2.8 Count         : 1
  2.9 Status        : New
  2.10 Note         :

User:
-------------------------------------------------------
  3.1 ID        : KRIANGKRAI
  3.2 Name      : Your Name Here
  3.3 Email     :
  3.4 Company   :
  3.5 Privileges: SeIncreaseQuotaPrivilege        - OFF
                  SeSecurityPrivilege             - OFF
                  SeTakeOwnershipPrivilege        - OFF
                  SeLoadDriverPrivilege           - OFF
                  SeSystemProfilePrivilege        - OFF
                  SeSystemtimePrivilege           - OFF
                  SeProfileSingleProcessPrivilege - OFF
                  SeIncreaseBasePriorityPrivilege - OFF
                  SeCreatePagefilePrivilege       - OFF
                  SeBackupPrivilege               - OFF
                  SeRestorePrivilege              - OFF
                  SeShutdownPrivilege             - OFF
                  SeDebugPrivilege                - OFF
                  SeSystemEnvironmentPrivilege    - OFF
                  SeChangeNotifyPrivilege         - ON
                  SeRemoteShutdownPrivilege       - OFF
                  SeUndockPrivilege               - OFF
                  SeManageVolumePrivilege         - OFF
                  SeImpersonatePrivilege          - ON
                  SeCreateGlobalPrivilege         - ON
                  SeIncreaseWorkingSetPrivilege   - OFF
                  SeTimeZonePrivilege             - OFF
                  SeCreateSymbolicLinkPrivilege   - OFF

Active Controls:
--------------------------------
  4.1 Form Class   : TMainForm
  4.2 Form Text    : :: HOSxP ::
  4.3 Control Class: TBitBtn
  4.4 Control Text : NHSO

Computer:
---------------------------------------------------------------------------------------------------
  5.1 Name          : PERJER4675
  5.2 Total Memory  : 2038 Mb
  5.3 Free Memory   : 978 Mb
  5.4 Total Disk    : 22.29 Gb
  5.5 Free Disk     : 4.39 Gb
  5.6 System Up Time: 58 minutes, 12 seconds
  5.7 Processor     : Intel(R) Core(TM)2 Duo CPU     T7100  @ 1.80GHz
  5.8 Display Mode  : 1280 x 800, 32 bit
  5.9 Display DPI   : 96
  5.10 Video Card   : Mobile Intel(R) 965 Express Chipset Family (driver 7.15.10.1591 - RAM 448 MB)
  5.11 Printer      : Microsoft XPS Document Writer (driver 6.0.6001.18000)

Operating System:
---------------------------------------
  6.1 Type    : Microsoft Windows Vista
  6.2 Build # : 6001
  6.3 Update  : Service Pack 1
  6.4 Language: Thai
  6.5 Charset : 222

Network:
---------------------------------------------------
  7.1 IP Address: 000.000.000.000 - 192.168.010.120
  7.2 Submask   : 000.000.000.000 - 255.255.000.000
  7.3 Gateway   : 000.000.000.000 - 192.168.010.254
  7.4 DNS 1     : 000.000.000.000 - 203.144.207.049
  7.5 DNS 2     : 000.000.000.000 - 000.000.000.000
  7.6 DHCP      : ON              - OFF           

Custom Information:
-----------------------------------------------------------------------------------------------
  8.1 Hospital Code            : 10685 [โรงพยาบาล สมุทรปราการ]
  8.2 Database Type            : MySQL
  8.3 Database Protocol        : mysql-4.1 [5.0.45-community
                                  Database hos @ 192.168.10.1]
  8.4                          :
  8.5 No 1                     : select nhso_password from opduser where loginname='perjer4675'
  8.6 No 2                     : select nhso_user from opduser where loginname='perjer4675'
  8.7 No 3                     : select nhso_password from opduser where loginname='perjer4675'
  8.8 DBMS Variables           :
  8.9                          :
  8.10 auto_increment_increment: 1
                                 auto_increment_offset = 1
                                 automatic_sp_privileges = ON
                                 back_log = 50
                                 basedir = /
                                 binlog_cache_size = 32768
                                 bulk_insert_buffer_size = 8388608
                                 character_set_client = tis620
                                 character_set_connection = tis620
                                 character_set_database = tis620
                                 character_set_filesystem = binary
                                 character_set_results = tis620
                                 character_set_server = tis620
                                 character_set_system = utf8
                                 character_sets_dir = /usr/share/mysql/charsets/
                                 collation_connection = tis620_thai_ci
                                 collation_database = tis620_thai_ci
                                 collation_server = tis620_thai_ci
                                 completion_type = 0
                                 concurrent_insert = 2
                                 connect_timeout = 5
                                 datadir = /var/lib/mysql/
                                 date_format = %Y-%m-%d
                                 datetime_format = %Y-%m-%d %H:%i:%s
                                 default_week_format = 0
                                 delay_key_write = ON
                                 delayed_insert_limit = 100
                                 delayed_insert_timeout = 300
                                 delayed_queue_size = 1000
                                 div_precision_increment = 4
                                 engine_condition_pushdown = OFF
                                 expire_logs_days = 0
                                 flush = OFF
                                 flush_time = 0
                                 ft_boolean_syntax = + -><()~*:""&|
                                 ft_max_word_len = 84
                                 ft_min_word_len = 4
                                 ft_query_expansion_limit = 20
                                 ft_stopword_file = (built-in)
                                 group_concat_max_len = 1024
                                 have_archive = YES
                                 have_bdb = NO
                                 have_blackhole_engine = YES
                                 have_compress = YES
                                 have_crypt = YES
                                 have_csv = YES
                                 have_dynamic_loading = YES
                                 have_example_engine = YES
                                 have_federated_engine = YES
                                 have_geometry = YES
                                 have_innodb = YES
                                 have_isam = NO
                                 have_merge_engine = YES
                                 have_ndbcluster = DISABLED
                                 have_openssl = NO
                                 have_ssl = NO
                                 have_query_cache = YES
                                 have_raid = NO
                                 have_rtree_keys = YES
                                 have_symlink = YES
                                 hostname = hosxp
                                 init_connect = SET NAMES tis620
                                 init_file =
                                 init_slave =
                                 innodb_additional_mem_pool_size = 25165824
                                 innodb_autoextend_increment = 8
                                 innodb_buffer_pool_awe_mem_mb = 0
                                 innodb_buffer_pool_size = 4294967296
                                 innodb_checksums = ON
                                 innodb_commit_concurrency = 0
                                 innodb_concurrency_tickets = 500
                                 innodb_data_file_path = ibdata1:100M:autoextend
                                 innodb_data_home_dir = /var/lib/mysql/
                                 innodb_doublewrite = OFF
                                 innodb_fast_shutdown = 1
                                 innodb_file_io_threads = 4
                                 innodb_file_per_table = ON
                                 innodb_flush_log_at_trx_commit = 2
                                 innodb_flush_method = O_DIRECT
                                 innodb_force_recovery = 0
                                 innodb_lock_wait_timeout = 50
                                 innodb_locks_unsafe_for_binlog = ON
                                 innodb_log_arch_dir =
                                 innodb_log_archive = OFF
                                 innodb_log_buffer_size = 2097152
                                 innodb_log_file_size = 268435456
                                 innodb_log_files_in_group = 2
                                 innodb_log_group_home_dir = /var/lib/mysql/
                                 innodb_max_dirty_pages_pct = 90
                                 innodb_max_purge_lag = 0
                                 innodb_mirrored_log_groups = 1
                                 innodb_open_files = 300
                                 innodb_rollback_on_timeout = OFF
                                 innodb_support_xa = OFF
                                 innodb_sync_spin_loops = 20
                                 innodb_table_locks = ON
                                 innodb_thread_concurrency = 0
                                 innodb_thread_sleep_delay = 10000
                                 interactive_timeout = 28800
                                 join_buffer_size = 2093056
                                 key_buffer_size = 1073741824
                                 key_cache_age_threshold = 300
                                 key_cache_block_size = 1024
                                 key_cache_division_limit = 100
                                 language = /usr/share/mysql/english/
                                 large_files_support = ON
                                 large_page_size = 0
                                 large_pages = OFF
                                 lc_time_names = en_US
                                 license = GPL
                                 local_infile = ON
                                 locked_in_memory = OFF
                                 log = OFF
                                 log_bin = OFF
                                 log_bin_trust_function_creators = OFF
                                 log_error =
                                 log_queries_not_using_indexes = OFF
                                 log_slave_updates = OFF
                                 log_slow_queries = OFF
                                 log_warnings = 1
                                 long_query_time = 10
                                 low_priority_updates = OFF
                                 lower_case_file_system = OFF
                                 lower_case_table_names = 0
                                 max_allowed_packet = 268434432
                                 max_binlog_cache_size = 18446744073709551615
                                 max_binlog_size = 1073741824
                                 max_connect_errors = 10
                                 max_connections = 1000
                                 max_delayed_threads = 20
                                 max_error_count = 64
                                 max_heap_table_size = 536870912
                                 max_insert_delayed_threads = 20
                                 max_join_size = 18446744073709551615
                                 max_length_for_sort_data = 1024
                                 max_prepared_stmt_count = 16382
                                 max_relay_log_size = 0
                                 max_seeks_for_key = 18446744073709551615
                                 max_sort_length = 1024
                                 max_sp_recursion_depth = 0
                                 max_tmp_tables = 32
                                 max_user_connections = 0
                                 max_write_lock_count = 18446744073709551615
                                 multi_range_count = 256
                                 myisam_data_pointer_size = 6
                                 myisam_max_sort_file_size = 9223372036854775807
                                 myisam_recover_options = OFF
                                 myisam_repair_threads = 1
                                 myisam_sort_buffer_size = 1073741824
                                 myisam_stats_method = nulls_unequal
                                 ndb_autoincrement_prefetch_sz = 32
                                 ndb_force_send = ON
                                 ndb_use_exact_count = ON
                                 ndb_use_transactions = ON
                                 ndb_cache_check_time = 0
                                 ndb_connectstring =
                                 net_buffer_length = 16384
                                 net_read_timeout = 30
                                 net_retry_count = 10
                                 net_write_timeout = 60
                                 new = OFF
                                 old_passwords = OFF
                                 open_files_limit = 5000
                                 optimizer_prune_level = 1
                                 optimizer_search_depth = 62
                                 pid_file = /var/lib/mysql/hosxp.pid
                                 port = 3306
                                 preload_buffer_size = 32768
                                 profiling = OFF
                                 profiling_history_size = 15
                                 protocol_version = 10
                                 query_alloc_block_size = 8192
                                 query_cache_limit = 1048576
                                 query_cache_min_res_unit = 4096
                                 query_cache_size = 314572800
                                 query_cache_type = ON
                                 query_cache_wlock_invalidate = OFF
                                 query_prealloc_size = 8192
                                 range_alloc_block_size = 2048
                                 read_buffer_size = 1044480
                                 read_only = OFF
                                 read_rnd_buffer_size = 1044480
                                 relay_log_purge = ON
                                 relay_log_space_limit = 0
                                 rpl_recovery_rank = 0
                                 secure_auth = OFF
                                 secure_file_priv =
                                 server_id = 0
                                 skip_external_locking = ON
                                 skip_networking = OFF
                                 skip_show_database = OFF
                                 slave_compressed_protocol = OFF
                                 slave_load_tmpdir = /tmp/
                                 slave_net_timeout = 3600
                                 slave_skip_errors = OFF
                                 slave_transaction_retries = 10
                                 slow_launch_time = 2
                                 socket = /var/lib/mysql/mysql.sock
                                 sort_buffer_size = 1048568
                                 sql_big_selects = ON
                                 sql_mode =
                                 sql_notes = ON
                                 sql_warnings = OFF
                                 ssl_ca =
                                 ssl_capath =
                                 ssl_cert =
                                 ssl_cipher =
                                 ssl_key =
                                 storage_engine = MyISAM
                                 sync_binlog = 0
                                 sync_frm = ON
                                 system_time_zone = ICT
                                 table_cache = 1500
                                 table_lock_wait_timeout = 50
                                 table_type = MyISAM
                                 thread_cache_size = 8
                                 thread_stack = 262144
                                 time_format = %H:%i:%s
                                 time_zone = SYSTEM
                                 timed_mutexes = OFF
                                 tmp_table_size = 33554432
                                 tmpdir = /tmp/
                                 transaction_alloc_block_size = 8192
                                 transaction_prealloc_size = 4096
                                 tx_isolation = REPEATABLE-READ
                                 updatable_views_with_limit = YES
                                 version = 5.0.45-community
                                 version_comment = MySQL Community Edition (GPL)
                                 version_compile_machine = x86_64
                                 version_compile_os = unknown-linux-gnu
                                 wait_timeout = 28800

ตัวอย่างเอาไปรันดูครับ

select "tableA" as f1 union select "tableB" as f1

ผมทำเป็นตัวอย่างให้ อิอิอิ คิดคิดคิด ครับ งิงิงิ

น่าสนใจดีครับ ยิ่งข้อนี้ (Review Version ใหม่ ) ยิ่งนาสนใจหใญ่เลยครับ มีรายละเอียดให้ผมบ้างไหมครับ

หนับหนุนจ้าแต่ว่าปีงบประมาณนี้อะครับใช้งบไปเต็มที่เลยครับ ทั้งระบบเครือข่าย ทั้งเครื่องคอมให่มๆ ทั้ง server อีกตัวหนึ่ง และยังเชื่อมต่อกับ LAB อีก 555555 หัวจะหลุดอะเปล่าเรานิ อิอิอิอิอิ

สาเหตุการตายแบบA
สาเหตุการตายแบบB
สาเหตุการตายแบบC
สาเหตุการตายแบบD

หมายความว่าอะไรครับ

ก็ตามหน้าการลง ข้อมูลผู้ป่วยเสียชีวิตหน้านี้อะครับ แต่บอกไว้ก่อนนะครับรายงานนี้เขียนเพื่อบอกวิธีการใช้ ตัวแปล และการใช้ function ต่างๆแค่นั้นครับ ไม่อยากให้ยึดติดกับรายงานมากอยากให้นำไปลองแก้ไขเล่นหรือนำไปทดลองเล่นดูนะครับ

     วัตถุประสงค์ของการแจกเพื่อให้ผู้ที่ต้องการศึกษาวิธีเขียนรายงานบน Report Designer ใน HOSxP ได้ไปศึกษาดู เพราะการเขียนรายงานมีวิธีเขียนหลายรูปแบบ ผมจึงเขียนรายงานที่มีอะไรแปลกๆให้ผู้อื่นได้นำวีธีเขียนไปลองใช้บ้างนะครับ

    หากไม่เข้าใจใน code ส่วนไหนก็ถามเข้ามาได้นะครับ แน่ใจได้เลยว่ามีอาจารย์ และพี่ๆคอยให้ความรู้อยู่แล้วนะครับในสังคมแห่งนี้


                                                                                น้ำใจคนเหนือ(เพ้อเจ้อ4675)

  คือว่าที่โรงบาลอื่นเป็นเหมือนผมไหมครับ คือตอนนี้ผมใช้ Version 3.52.7.12 แล้วเจอปัญหาว่าพิมพ์ OPDCard แล้ว เลือกพิมพ์ที่เมนู เฉพาะรายการที่สั่งเพิ่ม แต่พอพิมพ์ ออกมาก็ออกมาทุกรายการครับ ไปดูในตาราง doctor_order_print พบว่ามีรายการทั้งหมดอยู่ทั้งรายการเก่าและรายการใหม่และฟิวล์ print_status ก็เป็น N ทั้งหมด ไม่ทราบว่าโรงบาลอื่นๆเป็นเหมือนกับผมไหม และมีวิธีแก้ไขอย่างไร

  ก็แบบที่อาจารย์ MN บอกครับท่านสามารถ download โปรแกรมและทำการติดตั้งเองโดยไม่เสียค่าใช้จ่ายครับ ส่วนที่เป็นการติดตั้งจากบริษัทหากท่านได้ลองทำงานในส่วนนี้ท่านก็จะรู้ว่ามันเป็นยังไง มันมีขั้นตอนมากมายเหมือนที่อาจารย์ MN ได้บอกไปครับ

  สุดท้ายนี้ผมอยากนั่งกินเหล้ากับคนที่พูดว่าให้โปรแกรมจังครับจะได้อธิบายชัดๆ นะครับ  แต่ติดที่อยู่ช่วงเข้าพรรษาครับ อิอิอิ 

ตอนเช้าโหลดเอา HOSxP 3.52.7.1 มาลองพอบ่ายกลายเป็น HOSxP 3.52.7.3 ซะแล้ว อิอิอิ

แบบนี้มันต้องถอนๆๆๆๆ งึกๆงักๆ

ไม่ทราบว่าตอนนี้ version ใหม่ตรวจสอบสิทธิได้หรือยังครับ

ท่านใดใช้ version ใหม่แล้วตอบทีครับ

ดันกระทู้คราบๆๆๆๆๆ

มาช่วยดันกระทู้งับ

ไฟล์นี้ชื่อจะขึ้นต้นด้วย ib ครับ น่าจะมีอยู่ 3 ไฟล์ลบทิ้งให้หมดครับ

ตามไม่ทันแล้ว งะ 

น้า jdadmin1  ไวจริงๆๆ นะงับ

select p.clinic,vn.hn,concat(vn.pdx,'  ',i.name) as pdxname,
concat(p.pname,p.fname,'  ',p.lname) as fullname,p.informaddr,vn.age_y
from vn_stat vn
inner join patient p on p.hn=vn.hn
inner join icd101 i on i.code=vn.pdx
where vn.pdx between 'I300' and 'I529' and vn.vstdate between '2008-03-01' and '2009-03-01'
and vn.hn in (select hn from clinicmember)
group by vn.hn
order by vn.hn asc

  ผมอับแล้ว อิอิอิ วันนี้ดูว่าผูู้ใช้จะว่าอย่างไรงับ 

ไม่ทราบว่าการตั้งค่าตรงนี้มีผลหรือเปล่าครับ.....

  เซ็ตดูหมดแล้วครับ ไม่เกี่ยวกับตรงนี้ครับ

ผมว่าพี่เกรียงน่าจะรอ 3.51.1.31 นะครับ อ.ปรับหน้าจอห้องฟันใหม่อีกตามกระทู้นี้ครับ
http://hosxp.net/index.php?option=com_smf&Itemid=28&topic=8734.msg50418#new
สำหรับผมใช้ 3.51.1.30b ไม่มีปัญหาเพราะยังไม่เปิดใช้งานห้องฟันอย่างเป็นทางการครับ

ผมว่าตามท่าน ขงเบ้ง ว่าแล้วกันครับ จะได้ชนะศึกนี้ซะที รอ 3.52.1.31 แบบท่าน ขงเบ้ง บอกดีกว่า  

3.52.1.30b มาจนได้ครับ  อับ 3.52.1.30 เมื่อคินนี้เอง 555555555 เอาใหม่อีกแล้วเรา