X60-X64

SELECT o.REG_DATETIME , o.HN , o.VISIT_ID, p.CID, CONCAT(p.FNAME,'',p.LNAME) AS FULLNAME, p.BIRTHDATE, o.UNIT_REG, icd.ICD10_TM
FROM opd_visits o
INNER JOIN cid_hn c ON o.hn = c.hn 
INNER JOIN population p ON c.cid = p.cid 
INNER  JOIN opd_diagnosis dx ON dx.visit_id = o.visit_id and dx.is_cancel = 0
INNER  JOIN icd10new icd ON icd.icd10 = dx.icd10 and icd.ICD10_TM BETWEEN 'X60' AND 'X64'
WHERE o.REG_DATETIME BETWEEN '2017.01.01 00:00' and '2020.12.31 23:59' 
AND o.is_cancel = 0  ORDER BY o.REG_DATETIME DESC 

GetNuture SmartRefer

SELECT o.VISIT_ID as seq,
        DATE_FORMAT(date(o.REG_DATETIME),'%Y-%m-%d') as date_serv, 
DATE_FORMAT(time(o.REG_DATETIME),'%h:%i:%s') as time_serv, 
        '' as bloodgrp,
        o.WEIGHT as weight,
        o.HEIGHT as height,
       ROUND((o.WEIGHT / ((o.height / 100) * (o.height / 100))), 2) as BMI,
        o.BODY_TEMP as temperature,
        o.PULSE_RATE as pr,
        o.RESP_RATE as rr,
        o.BP_SYST as sbp,
        o.BP_DIAS as dbp,
        '' as symptom,
        s.UNIT_ID as depcode,
        s.UNIT_NAME as department
        FROM opd_visits  o 
LEFT JOIN service_units s ON o.unit_reg = s.unit_id
        WHERE o.VISIT_ID in ('0002265136' )

หาชื่อฟิลด์จากฐานข้อมูลScript

SELECT DISTINCT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name LIKE 'prepack'
AND TABLE_SCHEMA= 'mbase_data'

drugs-smartRefer

SELECT a.VISIT_ID as seq,

DATE_FORMAT(date(a.REG_DATETIME),'%Y%m%d') as date_serv,

time(a.REG_DATETIME) as time_serv,

c.DRUG_NAME as drug_name,

b.RX_AMOUNT as qty,

d.UUNIT_NAME as unit ,

smart-refer

*****smart-refer Update*****2020-03-11
เพิ่ม CC  PE ใน IPD

Lab Smart Refer

SELECT
      DATE_FORMAT(date(a.LREQ_DT),'%Y%m%d') as date_serv,DATE_FORMAT(time(a.LREQ_DT),'%h:%i:%s') as time_serv
      ,b.LAB_GROUP as labgroup,b.LAB_NAME as lab_name
      ,replace(replace(SUBSTR(a.LAB_RESULT, LOCATE('=', a.LAB_RESULT)+1),char(13),''),char(10),'')  as lab_result
, '' as unit,  b.normal_val as standard_result
      FROM lab_requests a
      INNER JOIN lab_lists b ON a.LAB_ID = b.LAB_ID AND b.IS_CANCEL =0
      WHERE a.VISIT_ID in('0002250317','0002250318','0002262813','0002255663')
AND a.is_cancel = 0
AND b.is_secret = 0

Smart Refer

ติดตั้ง smartrefer-api #Install Git on a Ubuntu 16.04 apt-get update apt-get install curl sudo curl -sL https://deb.nodesource.com/setup_10.x | sudo -E bash -apt-get install nodejs apt-get install git ———
#ติดตั้ง Apache2. ใช้คำสั่ง : sudo apt-get install apache2 sudo apt-get install libapache2-mod-php #ติดตั้ง PHP7.0 (Default version สำหรับ Ubuntu 16.04) sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql php-curl php-mbstring ———
#Install Git on a CentOS 6.4 curl -sL https://rpm.nodesource.com/setup_10.x | bash -yum install nodejs yum install git ———
#ติดตั้ง Apache2. ใช้คำสั่ง : yum install apache2 yum install libapache2-mod-php #ติดตั้ง PHP7.0 (Default version สำหรับ Ubuntu 16.04) yum install php libapache2-mod-php php-mcrypt php-mysql php-curl phpmbstring ———
node -v
npm -v
npm i -g typings
npm i -g typescript
npm i -g nodemon
npm i -g pm2
 git clone https://gitlab.com/ubon-refer/smart-refer-api.git
git clone https://gitlab.com/ubon-refer/smart-refer-web.git 
 cd smart-refer-api cp config.txt config nano config