C

@cheerasak777

CRMGee structure

PHP
11 months ago
<!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 hr

Code.gs

TypeScript
11 months ago
function doGet() { return HtmlService.createHtmlOutputFromFile('index') .setTitle('i-Link LIS Mind Map') .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); }

Ilink analytical html

Java
11 months ago
<!DOCTYPE html> <html> <head> <base target="_top"> <style> body { font-family: 'Kanit', sans-serif; padding: 20px; background-color: #f4f7fa; color: #333;

LINE::GEMINI BOT

Go
1 year ago
var channelToken = ""; //Token Line var apiKey = ""; //Key Gemini function replyMsg(replyToken, mess, channelToken) { var url = 'https://api.line.me/v2/bot/message/reply'; var opt = { 'headers': { 'Content-Type': 'application/json; ch

Trigger [dbo].[CallIfSelectContact]

SQL
1 year ago
USE [LAB_DB] GO /****** Object: Trigger [dbo].[CallIfSelectContact] Script Date: 3/7/2568 17:09:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

Chromatic tuner

Python
1 year ago
<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Chromatic Tuner สำหรับกีตาร์</title> <style> * { box-sizing: border-box;

Chromatic tuner

Java
1 year ago
<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Chromatic Tuner สำหรับกีตาร์</title> <style> * { box-sizing: border-box;

interpret decclare_APRI_score_calc_@Index FLOAT

SQL
1 year ago
((%CH015% + 0.0) / (%CH1095% + 0.0) / (%HM014% + 0.0)) * 100 ------------------------------------------------------------------ DECLARE @Index FLOAT = (((%CH015% + 0.0) / (%CH1095% + 0.0) / (%HM014% + 0.0)) * 100) SELECT CASE WHEN @Inde

TRIGGER @critical contrax

Deno
1 year ago
USE [LAB_DB] GO /****** Object: Trigger [dbo].[CallIfSelectContact] Script Date: 3/7/2568 17:09:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

Ewhammy

Java
1 year ago
<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>เอฟเฟกต์เสียง Whammy กีตาร์</title> <!-- โหลด Tailwind CSS สำหรับการจัดสไตล์ --> <script

check Alert!! test in REACTIVE(X.XXX)

SQL
1 year ago
SELECT CASE WHEN "%IM054%" IS NULL THEN " " WHEN "%IM054%" = " " THEN " "

check Alert!! test in POSITIVE(X.XXX)

SQL
1 year ago
CASE WHEN "%IM054%" IS NULL THEN " " WHEN "%IM054%" = " " THEN " " WHEN

CorWBCs is RUNNING when NRBC not null

SQL
1 year ago
select CASE WHEN NULLIF(LTRIM(RTRIM(%HM020%)),"") IS NULL THEN NULL ELSE ("%HM003%" * 100) / ("%HM020%"+ 100) END

LABoratory with CASS Ex-1

SQL
1 year ago
-- 1. สร้างตารางตัวอย่างสำหรับผลการทดสอบ -- หากมีตารางอยู่แล้ว สามารถข้ามส่วนนี้ได้ CREATE TABLE LabTestResults ( ResultID INT PRIMARY KEY IDENTITY(1,1), PatientID INT NOT NULL, TestName VARCHAR(100) NOT NULL, RawResultValue DECIMAL(

BIG_SHACK_FOR_MYSQL

MySQL
1 year ago
SET @SubGroupCode = '106'; ---แทน'106'ด้วยเลข(lab_items_sub_group_code) SELECT sg_list.lab_items_sub_group_code AS SubGroupCode, sg.lab_items_sub_group_name AS SubGroupName, li.ecode AS ItemECode, li.lab_items_name AS ItemName,

Clear DB for newal

SQL
1 year ago
use lab_dbXXX declare @count int declare @max int declare @tsql nvarchar(255) declare @tbl table(rownum int IDENTITY (1, 1) Primary key NOT NULL , cmd nvarchar(255)) insert into @tbl(cmd) select ('delete ' + name) as cmd from sys.tables where nam

Statistics of the number of items ordered for inspectiสถิติการนับจำนวนรายการสั่งตรวจ มากกว่า 1 ครั้ง

SQL
1 year ago
Select view_lab_statistic_Order_List.[HN ] , view_lab_statistic_Order_List.[FULLNAME] as Name , [REQ ITEM NAME] as Test , Count(LN) as Count From view_lab

NI_InstReg_GR5.exe " (Run as administrator)

SQL
1 year ago
(* if you don't have previous installation.) 1. Go to " Crack " Folder -> Run " NI_InstReg_GR5.exe " (Run as administrator) -> Click " Yes " 2. Go to " Setup " Folder -> Install : Guitar Rig 5 Setup PC.exe

ไม่ให้ได้คำตอบออกก่อนก่อนจะมีค่า when case A then B

SQL
1 year ago
SELECT case when (%CH264A% <> "") THEN ((%CH264A%*%CH266V%)/1000) ELSE 0 END

[ TRY_CAST ] เปลี่ยน mALB เป็นช่วง ถ้าตรวจสอบว่า "%CH050A%" ไม่ใช่ตัวเลข

SQL
1 year ago
CASE WHEN TRY_CAST("%CH050A%" AS FLOAT) IS NULL THEN "%CH050A%" ELSE CASE WHEN CAST("%CH050A%" AS FLOAT) < 30 THEN