C
@cheerasak777
function doPost(e)
function doPost(e) {
var ssId = "<Your Google Sheet ID>";
var ss = SpreadsheetApp.openById(ssId);
var sheetData1 = ss.getSheetByName("data1");
var sheetData2 = ss.getSheetByName("data2");
//use BetterLog
Logger = BetterLog.useSpreadsheet(ssId);
//Logger.log("Hello from BetterLog :)");
GEE@BOT
var LINE_ACCESS_TOKEN = "JUcAiDYEDrl7z88nr8mCaaqYwzVPSRNJb9OwPI+10gMRvUfIBcIEKLyMc2JS5BfNFVPwpyJ8txjus+KGh7pE4dtYbnJKhZ4bEd/4t1MqQGtg0MmU2RRlyXUI3aK6GhJMgU/9UH5bGJY7OcMBOG8bXQdB04t89/1O/w1cDnyilFU=";
var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1v9E7oAWhQqhIuMJLa9OO4IqTsNX3AnqSx8yMeSMruQE/edit");
var sh = ss.getSheetByName("ซีต1");
function doPost(e) {
if (typeof e === "undefined") {
return;
BIG_FISH
SELECT
lab_items_sub_group_list.lab_items_sub_group_code,
lab_items_sub_group.lab_items_sub_group_name,
lab_items.ecode,
lab_items.lab_items_name,
lab_items.lab_items_code,
lab_items.display_order,
lab_items.lab_items_normal_value,
lab_items.possible_value,
lab_items.lab_items_unit
(Result) CD4 res.list
SELECT
tbl_lab_information_Patient.IPT_TITLE + ' ' + tbl_lab_information_Patient.IPT_FNAME + ' ' + tbl_lab_information_Patient.IPT_LNAME AS 'ชื่อ'
,[YEAR] as 'อายุ'
,[HN] as 'HN'
,[PATIENT TYPE NAME] as 'สิทธิการรักษา'
,(SELECT CAST(DATEPART(YYYY,[IREQ_LAST_CHK_DT]) AS VARCHAR) + '/' + CAST(DATEPART(MM,[IREQ_LAST_CHK_DT]) AS VARCHAR) + '/' + CAST(DATEPART(DD,[IREQ_LAST_CHK_DT]) AS VARCHAR) + ' ' + CONVERT(char(5), [IREQ_LAST_CHK_DT], 108)) as 'เวลาเจาะเลือด'
,'' as 'เวลาย้อม CD4'
,''
นับจำนวนคนไข้ตามHN
select HN
from(
SELECT convert(varchar(10), [IREQ_OD_DT], 120) as OrderDate
,[IREQ_PID] as HN
FROM [view_lab_information_Request]
where IREQ_INACTIVE = 'N' and IREQ_OD_DT between '@d1' and '@d2'
) as x
group by OrderDate, HN
---
Hide GroupsName Section LNTH
// Hide GroupsName Section LNTH
// (C) JaeKunGz 22-12-65 16.12
// Hide For Show Biochemistry Label
// Group Hide
stringVar array SectionHide :=
['ANC','Blood Bank','Bacteria C/S','Bodyfluid Exam','Genetics','Hemotology','Immunology','Microbiology','Microscopy','Pathology','CAPD','Stool Exam','Thyroid Horrmone','Toxicology','xCytologyx','xOUT LABx'];
// Test Hide ( Defind By TestDisplay Name )
stringVar array TestDetailHide :=
['FBS','Sugar','FBS, Sugar','Hb A1c ,eA','DTX','MB: Hct;MB
CRM GEE structXXX
<!DOCTYPE html>
<html lang="th_TH">
<head>
<meta charset="utf-8" UICulture="th" Culture="th-TH" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>บันทึกการรับแจ้งงาน LIS - ระบบ CRM </title>
<link href="/favicon.ico" rel="shortcut icon" type="image/x-icon" />
SMALL-FISH @GEE
SELECT
tbl_lab_setup_Test.Test_Code,
tbl_lab_setup_Test.Test_Name,
tbl_lab_setup_Test.Test_His_Code
FROM
dbo.tbl_lab_setup_Test_Profile
INNER JOIN
dbo.tbl_lab_setup_Test
ON
tbl_lab_setup_Test.Test_Code = tbl_lab_setup_Test_Profile.Test_Item_Code
BIG_FISH_BY_GEE
SELECT
lab_items_sub_group_list.lab_items_code,
lab_items.lab_items_code,
lab_items_sub_group_list.lab_items_sub_group_code,
lab_items.lab_items_name,
lab_items.ecode,
lab_items.display_order,
lab_items.lab_items_normal_value,
lab_items.possible_value,
lab_items.lab_items_unit