ข้อมูลโรงเรียน

Update Delete

ID736
Parent ID46
Table NameSchool_trat
Titleข้อมูลโรงเรียน
Description
ScriptSET @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;



SELECT
(SELECT hospitalcode FROM opdconfig) AS HOSPCODE,
v.village_code AS VID,
CONCAT(v.village_code,vs.village_school_id) AS SCHOOLCODE,
vs.school_name AS SCHOOLNAME,
NULL AS SCHOOLOWNER,
NULL AS SCHOOLTYPE,
NULL AS CLOSEDDATE,
v.entry_datetime AS D_UPDATE
FROM village_school vs
INNER JOIN village v ON v.village_id = vs.village_id
WHERE RIGHT(v.village_code,2) <> '00'
AND (vs.school_name IS NOT NULL OR vs.school_name <> '')

;

Script Cron
Force Script Cron0
Active1
Client Office Type
Create Date2017-01-11 10:35:52
Last Update2017-01-11 10:35:52