3.50.7.4 แจ้งการใช้งาน

[doramon]

3.50.7.4 แจ้งการใช้งาน
1. ทดสอบใช้แล้วครับ ใช้งานจริงทั้งระบบ
2. กำหนด max_station ที่ opduser มาแล้ว
3.

โค๊ด: SQL

1.  
2. ALTER TABLE village_temple_type  ADD `village_temple_type_name` VARCHAR(200) NOT NULL  
3. ALTER TABLE village_temple  ADD `village_temple_type_id` INT NULL  
4. ALTER TABLE village_survey_item  ADD `unit_name` VARCHAR(50) NULL  
5. ALTER TABLE village_survey_item  ADD `item_group` INT NULL  
6. ALTER TABLE village_survey_item  ADD `count_sql` VARCHAR(250) NULL  
7. ALTER TABLE village_survey_item  ADD `village_survey_item_name` VARCHAR(200) NOT NULL  
8. ALTER TABLE village_survey_detail  ADD `survey_value` INT NOT NULL  
9. ALTER TABLE village_survey_detail  ADD `village_survey_item_id` INT NOT NULL  
10. ALTER TABLE village_survey_detail  ADD `village_id` INT NOT NULL  
11. ALTER TABLE village_student  ADD `village_school_class_id` INT NOT NULL  
12. ALTER TABLE village_student  ADD `person_id` INT NOT NULL  
13. ALTER TABLE village_student  ADD `village_school_id` INT NOT NULL  
14. ALTER TABLE village_school_class  ADD `village_school_class_name` VARCHAR(150) NOT NULL  
15. ALTER TABLE village_priest  ADD `person_id` INT NOT NULL  
16. ALTER TABLE village_priest  ADD `village_temple_id` INT NOT NULL  
17. ALTER TABLE village  ADD `village_code` VARCHAR(10) NULL  
18. ALTER TABLE village  ADD `hos_guid` VARCHAR(38) NULL  
19. ALTER TABLE surveil_member_log  ADD `data_sync` CHAR(1) NULL  
20. ALTER TABLE surveil_member_log  ADD `op_type` VARCHAR(10) NULL  
21. ALTER TABLE surveil_member_log  ADD `sv_guid` VARCHAR(38) NOT NULL  
22. ALTER TABLE surveil_member  ADD `data_sync` CHAR(1) NULL  
23. ALTER TABLE surveil_member  ADD `sv_guid` VARCHAR(38) NULL  
24. ALTER TABLE surveil_member  ADD `hospcode` CHAR(5) NULL  
25. ALTER TABLE stock_return_list  ADD `stock_return_unit_qty` INT NULL  
26. ALTER TABLE stock_return_list  ADD `stock_draw_list_id` INT NOT NULL  
27. ALTER TABLE stock_return_list  ADD `stock_return_qty` INT NOT NULL  
28. ALTER TABLE stock_return_list  ADD `item_list_id` INT NOT NULL  
29. ALTER TABLE stock_return_list  ADD `stock_return_id` INT NOT NULL  
30. ALTER TABLE stock_return  ADD `remark` VARCHAR(250) NULL  
31. ALTER TABLE stock_return  ADD `department_id` INT NOT NULL  
32. ALTER TABLE stock_return  ADD `stock_return_date` DATE NULL  
33. ALTER TABLE stock_return  ADD `stock_draw_id` INT NOT NULL  
34. ALTER TABLE stock_item  ADD `unit_cost` DOUBLE NULL  
35. ALTER TABLE stock_adjust_detail  ADD `original_qty` INT NULL  
36. ALTER TABLE rx_summary  ADD `pttype` CHAR(2) NULL  
37. ALTER TABLE rx_summary  ADD `income` CHAR(2) NULL  
38. ALTER TABLE rx_summary  ADD `sum_price` DOUBLE NULL  
39. ALTER TABLE rx_summary  ADD `qty` INT NULL  
40. ALTER TABLE rx_summary  ADD `department` CHAR(3) NOT NULL  
41. ALTER TABLE rx_summary  ADD `rx_date` DATE NOT NULL  
42. ALTER TABLE rx_summary  ADD `icode` VARCHAR(7) NOT NULL  
43. ALTER TABLE risk_report  MODIFY COLUMN risk_level  VARCHAR(200)  
44. ALTER TABLE rcpt_bill_type_head  ADD `bookno` INT NULL  
45. ALTER TABLE rcpt_bill_type_head  ADD `department` CHAR(3) NULL  
46. ALTER TABLE rcpt_bill_type_head  ADD `rcpt_bill_type_active` CHAR(1) NULL  
47. ALTER TABLE rcpt_bill_type_head  ADD `rcpt_bill_type_name` VARCHAR(250) NULL  
48. ALTER TABLE rcpt_bill_type_detail  ADD `pttype` CHAR(2) NOT NULL  
49. ALTER TABLE rcpt_bill_type_detail  ADD `rcpt_bill_type_id` INT NOT NULL  
50. ALTER TABLE person  ADD `drug_allergy` VARCHAR(150) NULL  
51. ALTER TABLE person  ADD `family_position_id` INT NULL  
52. ALTER TABLE person  ADD `home_position_id` INT NULL  
53. ALTER TABLE person  ADD `income_per_year` INT NULL  
54. ALTER TABLE person  ADD `hos_guid` VARCHAR(38) NULL  
55. ALTER TABLE ovstoprt  ADD `ovst_diag_id` INT NULL  
56. ALTER TABLE ovstoprt  ADD `ovst_oper_type` INT NOT NULL  
57. ALTER TABLE ovstoprt  ADD `icd9cm` VARCHAR(7) NOT NULL  
58. ALTER TABLE ovstoprt  ADD `vn` VARCHAR(13) NOT NULL  
59. ALTER TABLE ovstdiag  ADD `ovst_oper_type` INT NULL  
60. ALTER TABLE ovst_oper_type  ADD `name` VARCHAR(100) NOT NULL  
61. ALTER TABLE opitemrece_summary  ADD `hos_guid` VARCHAR(38) NOT NULL  
62. ALTER TABLE opitemrece_summary  ADD `department` CHAR(3) NULL  
63. ALTER TABLE opitemrece_summary  ADD `sum_price` DOUBLE NULL  
64. ALTER TABLE opitemrece_summary  ADD `qty` INT NULL  
65. ALTER TABLE opitemrece_summary  ADD `income` CHAR(2) NULL  
66. ALTER TABLE opitemrece_summary  ADD `icode` VARCHAR(7) NOT NULL  
67. ALTER TABLE opitemrece_summary  ADD `rxdate` DATE NULL  
68. ALTER TABLE opduser  ADD `max_station` INT NULL  
69. ALTER TABLE opd_hn_change  ADD `opd_hn_change_id` INT NULL  
70. ALTER TABLE iptoprt  ADD `ovst_oper_type` INT NULL  
71. ALTER TABLE iptdiag  ADD `hos_guid` VARCHAR(38) NULL  
72. ALTER TABLE ipt_income_auto_check  ADD `last_check_date` DATE NULL  
73. ALTER TABLE ipt_income_auto_check  ADD `icode` VARCHAR(7) NOT NULL  
74. ALTER TABLE ipt_income_auto  ADD `last_charge_refdate` DATE NULL  
75. ALTER TABLE ipt_income_auto  ADD `last_charge_datetime` datetime NULL  
76. ALTER TABLE ipd_data_synchronize  ADD `sync_mode` VARCHAR(10) NULL  
77. ALTER TABLE ipd_data_synchronize  ADD `sync_complete` CHAR(1) NULL  
78. ALTER TABLE ipd_data_synchronize  ADD `last_sync` datetime NULL  
79. ALTER TABLE ipd_data_synchronize  ADD `last_update` datetime NULL  
80. ALTER TABLE ipd_data_synchronize  ADD `cid` VARCHAR(17) NULL  
81. ALTER TABLE ipd_data_synchronize  ADD `an_guid` VARCHAR(38) NULL  
82. ALTER TABLE ipd_data_synchronize  ADD `hn_guid` VARCHAR(38) NULL  
83. ALTER TABLE house_survey_yesno  ADD `name` VARCHAR(100) NULL  
84. ALTER TABLE house_survey_water  ADD `name` VARCHAR(100) NOT NULL  
85. ALTER TABLE house_survey_toilet  ADD `name` VARCHAR(150) NULL  
86. ALTER TABLE house_survey_summary  ADD `house_item_value_text` VARCHAR(200) NULL  
87. ALTER TABLE house_survey_summary  ADD `house_item_value` VARCHAR(25) NULL  
88. ALTER TABLE house_survey_summary  ADD `house_survey_item_id` INT NOT NULL  
89. ALTER TABLE house_survey_summary  ADD `house_id` INT NOT NULL  
90. ALTER TABLE house_survey_item  ADD `lookup_key_field` VARCHAR(30) NULL  
91. ALTER TABLE house_survey_item  ADD `survey_group` VARCHAR(50) NULL  
92. ALTER TABLE house_survey_item  ADD `lookup_field` VARCHAR(30) NULL  
93. ALTER TABLE house_survey_item  ADD `lookup_table` VARCHAR(30) NULL  
94. ALTER TABLE house_survey_item  ADD `item_data_type` VARCHAR(15) NOT NULL  
95. ALTER TABLE house_survey_item  ADD `house_survey_item_name` VARCHAR(250) NOT NULL  
96. ALTER TABLE house_survey_health  ADD `name` VARCHAR(150) NULL  
97. ALTER TABLE house_survey_garbage  ADD `name` VARCHAR(150) NULL  
98. ALTER TABLE house_survey_detail  ADD `hos_guid` VARCHAR(38) NULL  
99. ALTER TABLE house_survey_detail  ADD `house_item_value_text` VARCHAR(200) NULL  
100. ALTER TABLE house_survey_detail  ADD `house_item_value` VARCHAR(25) NULL  
101. ALTER TABLE house_survey_detail  ADD `house_survey_item_id` INT NULL  
102. ALTER TABLE house_survey_detail  ADD `house_survey_id` INT NOT NULL  
103. ALTER TABLE house_survey  ADD `survey_detail` text NULL  
104. ALTER TABLE house_survey  ADD `survey_date` DATE NULL  
105. ALTER TABLE house_survey  ADD `house_id` INT NOT NULL  
106. ALTER TABLE house  ADD `location_area_id` INT NULL  
107. ALTER TABLE house  ADD `hos_guid` VARCHAR(38) NULL  
108. ALTER TABLE doctor_cert  ADD `last_print_datetime` datetime NULL  
109. ALTER TABLE data_synchronize  ADD `department` CHAR(3) NULL  
110. CREATE TABLE village_temple_type ( `village_temple_type_id` INT NOT NULL  )
111. CREATE TABLE village_survey_item ( `village_survey_item_id` INT NOT NULL  )
112. CREATE TABLE village_survey_detail ( `village_survey_detail_id` INT NOT NULL  )
113. CREATE TABLE village_student ( `village_student_id` INT NOT NULL  )
114. CREATE TABLE village_school_class ( `village_school_clas_id` INT NOT NULL  )
115. CREATE TABLE village_priest ( `village_priest_id` INT NOT NULL  )
116. CREATE TABLE surveil_member_log ( `sv_member_log_id` INT NOT NULL  )
117. CREATE TABLE stock_return_list ( `stock_return_list_id` INT NOT NULL  )
118. CREATE TABLE stock_return ( `stock_return_id` INT NOT NULL  )
119. CREATE TABLE rx_summary ( `rx_summary_id` INT NOT NULL  )
120. CREATE TABLE rcpt_bill_type_head ( `rcpt_bill_type_id` INT NOT NULL  )
121. CREATE TABLE rcpt_bill_type_detail ( `rcpt_bill_type_detail_id` INT NOT NULL  )
122. CREATE TABLE ovstoprt ( `ovst_oprt_id` INT NOT NULL  )
123. CREATE TABLE ovst_oper_type ( `ovst_oper_type` INT NOT NULL  )
124. CREATE TABLE opitemrece_summary ( `vn` VARCHAR(13) NOT NULL  )
125. CREATE TABLE ipt_income_auto_check ( `an` VARCHAR(9) NOT NULL  )
126. CREATE TABLE ipd_data_synchronize ( `an` VARCHAR(9) NOT NULL  )
127. CREATE TABLE house_survey_yesno ( `house_survey_yesno_id` INT NOT NULL  )
128. CREATE TABLE house_survey_water ( `house_survey_water_id` INT NOT NULL  )
129. CREATE TABLE house_survey_toilet ( `house_survey_toilet_id` INT NOT NULL  )
130. CREATE TABLE house_survey_summary ( `house_survey_summary_id` INT NOT NULL  )
131. CREATE TABLE house_survey_item ( `house_survey_item_id` INT NOT NULL  )
132. CREATE TABLE house_survey_health ( `house_survey_health_id` INT NOT NULL  )
133. CREATE TABLE house_survey_garbage ( `house_survey_garbage_id` INT NOT NULL  )
134. CREATE TABLE house_survey_detail ( `house_survey_detail_id` INT NOT NULL  )
135. CREATE TABLE house_survey ( `house_survey_id` INT NOT NULL  )
136.  
137.  
138.  

[nahos]

ขอโทษครับ
code ที่แนบมา หมายถึงอะไรครับ
 

[Khuad]

3.50.7.4 แจ้งการใช้งาน
2. กำหนด max_station ที่ opduser มาแล้ว

....แก้ปัญหาคนชอบแอบเอาชื่อคนอื่น login ได้ระดับหนึ่งนะครับ.... ...

[por]

setting ตรงใหนครับ

[somnuk]

(update structure ก่อน)
Tools > System Setting > ผู้มีสิทธิ์ใช้งานระบบ > ตั้งได้แตกต่างกันสำหรับ user แต่ละคน
(กรณี มี user เป็นร้อยคน ไป replace ปรับที่ Table opduser field max_station รวดเดียว แล้วรักใครชอบใคร ก็ไปเพิ่มให้คนนั้น  )

[มดตานอย ครับ..]

version ใหม่  - ปัจจุบัน   ตอน  admit  มีการดึงเลขที่สิทธิบัตร มาใหมครับ

[doramon]

select pttypeno from ipt_pttype where an = '500002407' and pttype_number = 1

select * from ipt_pttype

จากการตรวจสอบพบว่าตารางด้านบนไม่ได้เก็บข้อมูลมาครับ เลยไม่แสดงเลขที่บัตรครับ

[~ Red Indian ~]

เจ๋งจริงๆ อาจารย์ม่อน