C

@cheerasak777

DUPLICATE ORDER (ทดสอบ)

SQL
2 months ago
-- 1. ตั้งค่าตัวแปร (Configuration) DECLARE @TargetDays INT = 90; DECLARE @StartDate DATETIME = '2024-10-01 00:00:00'; DECLARE @EndDate DATETIME = '2025-09-30 23:59:59'; -- 2. กำหนดรายการรหัสเทสที่ต้องการวัดผล DECLARE @Test_code TABLE (ItemCode VARCHAR(50)); INSERT INTO @Test_code VALUES ('SR065'), ('SRT079'); -- 3. ส่วนการคำนวณ Logic

DuplicateTests_test details by gee

SQL
3 months ago
WITH DuplicateTests AS ( SELECT v.[HN], v.[FULLNAME] AS Name, v.[REQ ITEM NAME] AS TestName, v.[LN], v.[REQ ITEM ORDER DATETIME] AS OrderDate, COUNT(*) OVER (PARTITION BY v.[HN], v.[REQ ITEM CODE]) AS TestCount FROM view_lab_statistic_Order_List v JOIN view_lab_information_Request_Items_Specimen i

duplicat order test count

SQL
3 months ago
SELECT o.[HN], o.[FULLNAME] AS Name, o.[REQ ITEM NAME] AS Test FROM view_lab_statistic_Order_List AS o JOIN tbl_lab_setup_Test_Control AS c ON o.[REQ ITEM CODE] = c.Test_Code WHERE o.[order inactive] <> 'Y' AND o.[req item state] <> 'R' AND c.Test_Limit_Order_Flag = 1

data_MV

SQL
3 months ago
SELECT [dbo].[tbl_lab_information_Request].[IREQ_PID] AS _col_1, [dbo].[tbl_lab_information_Result_Items].[IRESI_LN] AS _col_2, [dbo].[tbl_lab_information_Result_Items].[IRESI_STATE] AS _col_3, count_big( * ) AS _col_4 FROM [dbo].[tbl_lab_information_Request], [dbo].[tbl_lab_information_Request_Items], [dbo].[tbl_lab_information_Result_Items], [dbo].[tbl_lab_setup_Test]

UpdateAnalyzerName{TRIGGER}

SQL
3 months ago
BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here Declare @LN varchar(20) SELECT @LN = i.LN FROM inserted AS i Declare @TestCode varchar(6) SELECT @TestCode = i.Test_Code FROM inserted AS i

SERUM INDEX (IN MYCONFIG_INTERFACE)

Deno
3 months ago
<?xml version="1.0" encoding="utf-8"?> <object name="" type="TK0" assembly=""> <!-- Data section : Don't edit any attributes ! --> <properties> <property name="Encoder" type="TK1" assembly="">utf-8</property> <property name="SerumIndexEnabled" type="TK2" assembly="">False</property> <property name="AutoAddLISOrder" type="TK2" assembly="">True</property> <property name="AutoAddLISOrderList" type="TK3" assembly=""> <items> <item name="0" type="TK1" assembly="">L<

LAB_ORDER_DUPLICATE

SQL
3 months ago
SELECT v.[HN], v.[FULLNAME] AS PatientName, r.[REQ ITEM NAME] AS LabTest, v.[REQ ITEM ORDER DATETIME] AS OrderDate, COUNT(v.[LN]) AS TestCount FROM view_lab_statistic_Order_List v JOIN view_lab_information_Request_Items_Specimen r

Script AutoHotkey (v2) สำหรับกรอกข้อมูล i-Link

TypeScript
4 months ago
; กด F8 เพื่อเริ่มการทำงาน F8:: { try { ; เชื่อมต่อกับ Excel ที่เปิดค้างไว้ xl := ComObjectActive("Excel.Application") } catch { MsgBox "กรุณาเปิดไฟล์ Excel ก่อนเริ่มใช้งานเด้อครับ", "บ่พ้อไฟล์" return }

BIG_FISH_BY_3sub.GROUP UNION ALL

MySQL
4 months ago
-- กลุ่มที่ 33 SELECT sub.lab_items_sub_group_code AS group_id, item.lab_items_name, item.display_order FROM lab_items_sub_group_list sub INNER JOIN lab_items item ON item.lab_items_code = sub.lab_items_code WHERE sub.lab_items_sub_group_code = '33' UNION ALL -- กลุ่มที่ 43 SELECT sub.lab_items_sub_group_code AS group_id, item.lab_items_name, item.display_order

Google Apps Script สำหรับ

Ruby
4 months ago
// Google Apps Script สำหรับบันทึกเวลาเข้า-ออกงานและส่งอีเมล // ตั้งค่าเริ่มต้น const CONFIG = { spreadsheetId: 'YOUR_SPREADSHEET_ID', // ID ของ Google Sheets สำหรับเก็บข้อมูล sheetName: 'AttendanceRecords', // ชื่อชีตสำหรับเก็บข้อมูล folderId: 'YOUR_FOLDER_ID', // ID ของ Google Drive Folder สำหรับเก็บรูปภาพ adminEmail: 'admin@company.com', // อีเมลแอดมิน emailSubject: 'ยืนยันการบันทึกเวลาเข้า-ออกงาน', dateFormat: 'dd/MM/yyyy',

รายชื่อคนไข้ที่มีhb a1c มากกว่า1เรียงตามhn(ORDER_DUPLICATION)

SQL
5 months ago
SELECT * FROM dbo.view_lab_statistic_Order_List AS v WHERE v.[REQ ITEM CODE] IN ('SR065', 'SRT079') AND v.[REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000' AND '2025-09-30 00:00:00.000' AND v.[HN] IN ( SELECT [HN] FROM dbo.view_lab_statistic_Order_List WHERE [REQ ITEM CODE] IN ('SR065', 'SRT079') AND [REQ ITEM CHECKIN DATETIME] BETWEEN '2024-10-01 00:00:00.000'

ABO BLD.GROUP TUBE METHOD

SQL
6 months ago
CASE -- Group O: Anti-A Neg, Anti-B Neg, Anti-AB Neg, A cell Pos, B cell Pos WHEN "%BB007A%" = "Negative" AND "%BB007B%" = "Negative" AND "%BB007C%" = "Negative" AND "%Acell%" LIKE "%Positive%" AND "%Bcell%" LIKE "%Positive%" THEN "O" -- Group A: Anti-A Pos, Anti-B Neg, Anti-AB Pos, A cell Neg, B cell Pos

Backup/ ย้ายไฟล์/ ZIP ไป Backup

Bash
7 months ago
@echo off set SOURCE=C:\Users\reall\Documents\Work set TEMP=C:\Users\reall\Documents\TempBackup set DEST=D:\WorkBackup if not exist "%TEMP%" mkdir "%TEMP%" if not exist "%DEST%" for /f "tokens=1-4 delims=/ " %%a in ('date /t') do set dt=%%d-%%b-%%c set ZIPFILE=%TEMP%\WorkBackup_%dt%.zip

UACR

SQL
8 months ago
CASE -- กรณี Creatinine < 10 WHEN U_CREA < 10 AND U_ALB < 10 THEN 'Re-Collect' WHEN U_CREA < 10 AND U_ALB = 10 THEN 'Re-Collect' WHEN U_CREA < 10 AND U_ALB >= 30 THEN 'N/A' -- กรณี Creatinine = 10 WHEN U_CREA = 10 AND U_ALB < 10 THEN 'Re-Collect' WHEN U_CREA = 10 AND U_ALB = 10 THEN 'Re-Collect' WHEN U_CREA = 10 AND U_ALB = 30 THEN 300

INTERPRETED 3 LINE Immunochromatography

SQL
8 months ago
CASE -- ถ้าแถบควบคุมไม่ขึ้น (C ไม่ใช่ 'Seen') ให้ถือว่าผลไม่ถูกต้อง WHEN CC0008 <> 'Seen' THEN 'Invalid' -- แถบควบคุมขึ้น แต่ทั้ง IgM และ IgG ไม่ขึ้น → ผลลบ WHEN CC0008 = 'Seen' AND TT0008 = 'Non seen' AND TT0018 = 'Non seen' THEN 'Negative'

ตัวอย่าง SQL Query สำหรับการประเมินผล Reactive/Non-reactive

SQL
9 months ago
SELECT CASE WHEN rc > 0 AND nc = 0 THEN 'Positive' WHEN nc > 0 AND rc = 0 THEN 'Negative' ELSE 'Inconclusive' END AS result_status FROM ( SELECT IM0951 AS c1, IM0952 AS c2,

Model ตั้งโต๊ะSet up the table and fill it up.

Go
9 months ago
Use the nano-banana model to create a 1/7 scale commercialized figure of the character in the illustration, in a realistic style and environment. Place the figure on a computer desk, using a circular transparent acrylic base without any text. On the computer screen, display the ZBrush modeling process of the figure. Next to the computer screen, place a BANDAl-style toy packaging box printed with the original artwork."

Tuner’s Gee

PHP
9 months ago
<!DOCTYPE html> <html lang="th"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>เครื่องตั้งสายกีตาร์แบบ Chromatic</title> <style> * { box-sizing: border-box; margin: 0;

CRMGee structure

PHP
9 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 href="/favicon.ico" rel="shortcut icon" type="image/x-icon" /> <link rel="stylesheet" href="/css/site.css" /> <link href="/css/sb-admin-2.css" rel="stylesheet" />

Code.gs

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