1. สร้างข้อมูลตั้งต้น-รายชื่อผู้ต้องขัง
ID | 832 |
---|---|
Parent ID | 63 |
Table Name | prison64_00_prisonerDB |
Title | 1. สร้างข้อมูลตั้งต้น-รายชื่อผู้ต้องขัง |
Description | |
Script | #SQL_OPTIONS# PROVIDERS=1 PROVIDER1=43STD PROVIDER1_VALIDATE_TABLES=person,chospital SCRIPT_FLOW=SQL #SQL_OPTIONS# #PROVIDER1_SQL# SET @provcode = :provcode; SET @rep_year = :rep_year; SET @hoscode = :hoscode; SET @hosname = :hosname; SET @hostype = :hostype; SET @address = :address; SET @subdistcode = :subdistcode; SET @distcode = :distcode; SET @level_service = :level_service; DROP TABLES IF EXISTS prison64_00_prisonerDB ; CREATE TABLE IF NOT EXISTS prison64_00_prisonerDB ( `HOSPCODE` varchar(5) NOT NULL, `PID` varchar(15) NOT NULL, `CID` varchar(13) DEFAULT NULL, `BIRTH` date DEFAULT NULL, `SEX` varchar(1) DEFAULT NULL, PRIMARY KEY (HOSPCODE,PID), KEY (cid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 IGNORE AS ( SELECT HOSPCODE,HOSNAME,PID,CID,BIRTH,SEX from person p LEFT JOIN chospital h ON p.HOSPCODE=h.hoscode WHERE HOSPCODE in('22777','22854','22746','22747','22739','22856','22866','22782','22790','22823','22849','22759','22858','22764','22813') AND NATION in('099','99') AND DISCHARGE ='9' AND CID <> '' AND CID is NOT NULL AND LENGTH(CID)=13 AND substr(CID,2,1)<>'0' #หลักที่2 เป็นเขตปกครองมหาดไทย GROUP BY CID ); #PROVIDER1_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2021-03-25 10:49:29 |
Last Update | 2021-03-25 10:49:29 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.