ผมอัพเวอร์ชั่นข้ามปีจาก 3.50.11.17 เป็น HOSxP_Full_Setup_3.51.8.6 แล้วอัพต่อเป็น3.51.10.21 ลองกับ server ใหม่ ครับ ผลออกมาเป็นแบบนี้ครับ เข้าโปรแกรมครั้งแรก หลังจากอัพเดท ตามรูปครับ
แล้วระบบลูกข่าย ก็อืดๆๆ ตามมาครับ ตามคำสั่งที่แทร็กมาให้ครับ
select count(rightname) as cc from accessoperation where rightname='OPDCEntry'
select count(loginname) as cc from opduser
select accessright from opduser where loginname='m'
select name from opduser where loginname='m'
select hospitalname as hn from opdconfig
delete from hnlock where onlineid='PANOMM'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','delete from hnlock where onlineid=\'PANOMM\'')
select count(rightname) as cc from accessoperation where rightname='OPDCARD_LOCK_PTTYPE'
select count(loginname) as cc from opduser
select accessright from opduser where loginname='m'
select count(hn) as cc from patient where hn='000000000'
select count(cardtype) as cc from cardtype where cardtype='01'
select name from cardtype where cardtype='01'
select count(cardtype) as cc from cardtype where cardtype='01'
select editmask from cardtype where cardtype='01'
select count(hn) as cc from patient where hn='000000000'
select count(pttype) as cc from pttype where pttype='10'
select name from pttype where pttype='10'
select regiment_name from regiment_type
select count(*) as cc from pname
select name from pname order by name
select count(rightname) as cc from accessoperation where rightname='VIEW_PATIENT_REAL_NAME'
select count(loginname) as cc from opduser
select accessright from opduser where loginname='m'
select name from marrystatus
delete from hnlock where onlineid='PANOMM'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','delete from hnlock where onlineid=\'PANOMM\'')
delete from hnlock where onlineid='PANOMM'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','delete from hnlock where onlineid=\'PANOMM\'')
select count(rightname) as cc from accessoperation where rightname='OPDCARD_LOCK_PTTYPE'
select count(loginname) as cc from opduser
select accessright from opduser where loginname='m'
select count(hn) as cc from patient where hn='000000000'
select count(cardtype) as cc from cardtype where cardtype='01'
select name from cardtype where cardtype='01'
select count(cardtype) as cc from cardtype where cardtype='01'
select editmask from cardtype where cardtype='01'
select count(hn) as cc from patient where hn='000000000'
select count(pttype) as cc from pttype where pttype='10'
select name from pttype where pttype='10'
delete from hnlock where onlineid='PANOMM'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','delete from hnlock where onlineid=\'PANOMM\'')
select hn as code,concat(pname,' ',fname,' ',lname) as ptname,fathername,mathername,admit from patient where hn in ('000000001','510000001','500000001','490000001','480000001','470000001','460000001','450000001','440000001','430000001','420000001','410000001','400000001','390000001','380000001','370000001','360000001','350000001','340000001','330000001','320000001','000000001') order by fname,lname limit 100
select birthday from patient where hn='000000001'
SHOW KEYS FROM hos.patient
select cardno from ptcardno where hn='000000001' and cardtype='01'
SHOW TABLES FROM hos LIKE 'ptcardno'
SHOW COLUMNS FROM hos.ptcardno LIKE '%'
SHOW KEYS FROM hos.ptcardno
select count(*) as cc from serial where name='app_storage_id'
LOCK TABLES serial WRITE
update serial set serial_no=serial_no+1 where name='app_storage_id'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','update serial set serial_no=serial_no+1 where name=\'app_storage_id\'')
select serial_no from serial where name='app_storage_id'
UNLOCK TABLES
select count(*) as cc from app_storage where app_storage_id = 605
select count(*) as cc from serial where name='app_storage_id'
LOCK TABLES serial WRITE
update serial set serial_no=serial_no+1 where name='app_storage_id'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','update serial set serial_no=serial_no+1 where name=\'app_storage_id\'')
select serial_no from serial where name='app_storage_id'
UNLOCK TABLES
select count(*) as cc from app_storage where app_storage_id = 606
select count(hn) as cc from patient where hn='000000001'
delete from hnlock where onlineid='PANOMM'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','delete from hnlock where onlineid=\'PANOMM\'')
delete from hnlock where onlineid='PANOMM'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','delete from hnlock where onlineid=\'PANOMM\'')
select count(onlineid) as hc from hnlock where onlineid='PANOMM'
SHOW TABLES FROM hos LIKE 'hnlock'
SHOW COLUMNS FROM hos.hnlock LIKE '%'
select count(hn) as co from hnlock where hn='000000001'
select count(onlineid) as co from hnlock where onlineid='PANOMM'
insert into hnlock (onlineid,hn,optype) values ('PANOMM','000000001','Modify')
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','insert into hnlock (onlineid,hn,optype) values (\'PANOMM\',\'000000001\',\'Modify\')')
select count(rightname) as cc from accessoperation where rightname='OPDCARD_LOCK_PTTYPE'
select count(loginname) as cc from opduser
select accessright from opduser where loginname='m'
select count(hn) as cc from patient where hn='000000001'
select cardno from ptcardno where hn='000000001' and cardtype=' '
select count(cardtype) as cc from cardtype where cardtype='01'
select name from cardtype where cardtype='01'
select count(cardtype) as cc from cardtype where cardtype='01'
select editmask from cardtype where cardtype='01'
select count(hn) as cc from patient where hn='000000001'
select cardno from ptcardno where hn='000000001' and cardtype='01'
select count(pttype) as cc from pttype where pttype='10'
select name from pttype where pttype='10'
select max(hn) as mhn from patient
select * from patient_birth where hn = '000000001'
SHOW TABLES FROM hos LIKE 'patient_birth'
SHOW COLUMNS FROM hos.patient_birth LIKE '%'
SHOW KEYS FROM hos.patient_birth
select * from patient_description where hn = '000000001'
SHOW TABLES FROM hos LIKE 'patient_description'
SHOW COLUMNS FROM hos.patient_description LIKE '%'
SHOW KEYS FROM hos.patient_description
select * from patient where hn='000000001'
select count(*) as cc from patient_pttype_lock where hn = '000000001' and lock_pttype = 'Y'
SHOW TABLES FROM hos LIKE 'patient_pttype_lock'
SHOW COLUMNS FROM hos.patient_pttype_lock LIKE '%'
select * from opd_hn_change where hos_guid = '{17F0A164-B315-4643-AB45-F1C36BCFF982}'
SHOW TABLES FROM hos LIKE 'opd_hn_change'
SHOW COLUMNS FROM hos.opd_hn_change LIKE '%'
SHOW KEYS FROM hos.opd_hn_change
select sex from pname where name='นาย'
select name from sex where code='1'
SHOW TABLES FROM hos LIKE 'sex'
SHOW COLUMNS FROM hos.sex LIKE '%'
SHOW KEYS FROM hos.sex
select hn from patient where fname='บัญชา' and lname='ทองจริง'
select count(occupation) as cc from occupation where occupation='209'
SHOW TABLES FROM hos LIKE 'occupation'
SHOW COLUMNS FROM hos.occupation LIKE '%'
select name from occupation where occupation='209'
SHOW KEYS FROM hos.occupation
select count(occupation) as cc from occupation where occupation='209'
select name from marrystatus where code='1'
select count(nationality) as cc from nationality where nationality='99'
SHOW TABLES FROM hos LIKE 'nationality'
SHOW COLUMNS FROM hos.nationality LIKE '%'
select name from nationality where nationality='99'
SHOW KEYS FROM hos.nationality
select count(nationality) as cc from nationality where nationality='99'
select count(nationality) as cc from nationality where nationality='99'
select name from nationality where nationality='99'
select count(nationality) as cc from nationality where nationality='99'
select count(religion) as cc from religion where religion='01'
SHOW TABLES FROM hos LIKE 'religion'
SHOW COLUMNS FROM hos.religion LIKE '%'
select name from religion where religion='01'
SHOW KEYS FROM hos.religion
select count(religion) as cc from religion where religion='01'
select count(chwpart) as cc from thaiaddress where chwpart='54' and codetype='1'
SHOW TABLES FROM hos LIKE 'thaiaddress'
SHOW COLUMNS FROM hos.thaiaddress LIKE '%'
select name from thaiaddress where chwpart='54' and codetype='1'
SHOW KEYS FROM hos.thaiaddress
select count(amppart) as cc from thaiaddress where amppart='06' and chwpart='54' and codetype='2'
select name from thaiaddress where amppart='06' and chwpart='54' and codetype='2'
select count(tmbpart) as cc from thaiaddress where tmbpart='02' and amppart='06' and chwpart='54' and codetype='3'
select name from thaiaddress where tmbpart='02' and amppart='06' and chwpart='54' and codetype='3'
select count(nationality) as cc from nationality where nationality='99'
select name from nationality where nationality='99'
select count(nationality) as cc from nationality where nationality='99'
select count(pttype) as cc from pttype where pttype='89'
select name from pttype where pttype='89'
select * from pttypeno where hn='000000001' and pttype='89'
SHOW TABLES FROM hos LIKE 'pttypeno'
SHOW COLUMNS FROM hos.pttypeno LIKE '%'
SHOW KEYS FROM hos.pttypeno
select * from patient_relation_address where hn = '000000001' and patient_relation_type_id = 4
SHOW TABLES FROM hos LIKE 'patient_relation_address'
SHOW COLUMNS FROM hos.patient_relation_address LIKE '%'
SHOW KEYS FROM hos.patient_relation_address
select clinic from clinicmember where hn='000000001'
SHOW TABLES FROM hos LIKE 'clinicmember'
SHOW COLUMNS FROM hos.clinicmember LIKE '%'
SHOW KEYS FROM hos.clinicmember
select name from clinic where clinic in ('')
SHOW TABLES FROM hos LIKE 'clinic'
SHOW COLUMNS FROM hos.clinic LIKE '%'
SHOW KEYS FROM hos.clinic
select * from ptcardno where hn='000000001' and cardtype='01'
select * from ptcardno where hn='000000001' and cardtype='02'
select * from patient_employer where hn='000000001'
SHOW TABLES FROM hos LIKE 'patient_employer'
SHOW COLUMNS FROM hos.patient_employer LIKE '%'
SHOW KEYS FROM hos.patient_employer
select * from patient_regiment where hn='000000001'
SHOW TABLES FROM hos LIKE 'patient_regiment'
SHOW COLUMNS FROM hos.patient_regiment LIKE '%'
SHOW KEYS FROM hos.patient_regiment
select p.* ,o.name as staff_name from ptnote p left outer join opduser o on o.loginname = p.note_staff where p.hn = '000000001'
select count(rightname) as cc from accessoperation where rightname='OPDCModify'
select count(loginname) as cc from opduser
select accessright from opduser where loginname='m'
select hn from patient where fname='บัญชา' and lname='ทองจริง'
select sex from pname where pname = 'นาย'
select count(*) as cc from ptcardno where cardtype='01' and cardno='3-5406-00515-95-8' and hn<>'000000001'
select count(occupation) as cc from occupation where occupation='209'
select count(tmbpart) as cc from thaiaddress where tmbpart='02' and amppart='06' and chwpart='54' and codetype='3'
select count(*) as cc from sys_var where sys_name='FORCE_REGIMENT'
select sys_value from sys_var where sys_name='FORCE_REGIMENT'
select sex from pname where name='นาย'
select code from sex where name='ชาย'
select * from patient where hn = '000000001'
select * from pttypeno where hn='000000001'
select * from pttypeno where hn='000000001'
UPDATE pttypeno SET expiredate='2008-10-22',pttype='89',pttypeno='',begindate='1990-01-01',hospmain='',hospsub='' WHERE hn='000000001' AND pttype='UC'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','UPDATE pttypeno SET expiredate=\'2008-10-22\',pttype=\'89\',pttypeno=\'\',begindate=\'1990-01-01\',hospmain=\'\',hospsub=\'\' WHERE hn=\'000000001\' AND pttype=\'UC\'')
select * from ptcardno where hn='000000001' and cardtype='01'
select * from ptcardno where hn='000000001' and cardtype='01'
UPDATE ptcardno SET expiredate='2009-10-22' WHERE hn='000000001' AND cardtype='01'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','UPDATE ptcardno SET expiredate=\'2009-10-22\' WHERE hn=\'000000001\' AND cardtype=\'01\'')
select hos_guid from patient where hn='000000001'
update patient set cid='3540600515958' where hos_guid in ('{17F0A164-B315-4643-AB45-F1C36BCFF982}')
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','update patient set cid=\'3540600515958\' where hos_guid in (\'{17F0A164-B315-4643-AB45-F1C36BCFF982}\')')
update vn_stat set cid='3540600515958' where hn='000000001' and cid<>'3-5406-00515-95-8'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','update vn_stat set cid=\'3540600515958\' where hn=\'000000001\' and cid<>\'3-5406-00515-95-8\'')
select * from ptcardno where hn = '000000001' and cardtype = '01'
select * from patient_pttype_lock where hn = '000000001'
SHOW KEYS FROM hos.patient_pttype_lock
select * from patient_pttype_lock where hn = '000000001'
INSERT INTO patient_pttype_lock (hn,lock_pttype) VALUES ('000000001','N')
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'PANOMM','INSERT INTO patient_pttype_lock (hn,lock_pttype) VALUES (\'000000001\',\'N\')')
select count(*) as cc from patient where hn='000000001'
select concat(fname,lname) as name from patient where hn='000000001'
select * from patient_realname where hn = '000000001' and staff = 'm'
SHOW TABLES FROM hos LIKE 'patient_realname'
SHOW COLUMNS FROM hos.patient_realname LIKE '%'
SHOW KEYS FROM hos.patient_realname
select * from patient where hn='000000001'
select * from patient where hn='000000001'
select count(nationality) as cc from nationality where nationality='99'
select count(nationality) as cc from nationality where nationality='99'
select count(religion) as cc from religion where religion='01'
select count(occupation) as cc from occupation where occupation='209'
select code from marrystatus where name = 'โสด'
select clinic from clinicmember where hn='000000001'
select name from clinic where clinic in ('')
select count(hn) as cc from patient where hn='000000001'
select * from ksklog where tablename='xxx' limit 1
select count(*) as cc from serial where name='ksklog_id'
select get_serialnumber('ksklog_id') as cc
หัวข้อ: เครื่องอืด มากๆ (อ่าน 10200 ครั้ง)