stephenk/Issue_KD
1
0
Code Issues 15 Packages Projects Wiki

Tidak Bisa Patient Handling Nonlab Elektromedis #1

New Issue
Open
opened 2025-10-14 09:49:35 +07:00 by stephenk · 0 comments
stephenk commented 2025-10-14 09:49:35 +07:00
Owner
Copy Link

Masalah Audiometri

Tidak Bisa Melanjutkan Proses dari patient Handling nonlab

image

Solusi

  1. Check Query apakah ada typenya di table documentation_group
    (ubah orderid dan samplestationid}
SELECT T_OrderDetailID as id, 
				T_OrderHeaderID as orderid, 
				T_TestCode as test_code,
				T_TestName as test_name,
				T_TestID as test_id,
				T_BahanName,
T_BahanT_SampleStationID ,
T_SampleStationID ,
				IFNULL(T_SamplingSoID,0) as T_SamplingSoID, 
				IF(ISNULL(T_SamplingSoID),'N',T_SamplingSoFlag) as status, 
				IF(ISNULL(T_SamplingSoProcessDate),'00-00-0000',DATE_FORMAT(T_SamplingSoProcessDate,'%d-%m-%Y')) as process_date,
				IF(ISNULL(T_SamplingSoProcessTime),'00:00',DATE_FORMAT(T_SamplingSoProcessTime,'%H:%i')) as process_time,
				IF(ISNULL(T_SamplingSoDoneDate) OR T_SamplingSoFlag = 'P','00-00-0000',DATE_FORMAT(T_SamplingSoDoneDate,'%d-%m-%Y')) as done_date,
				IF(ISNULL(T_SamplingSoDoneTime) OR T_SamplingSoFlag = 'P','00:00',DATE_FORMAT(T_SamplingSoDoneTime,'%H:%i')) as done_time,
				IF(ISNULL(T_SamplingSoRequirementID),'X',T_SamplingSoRequirementStatus) as requirement_status,
				'' as requirements,
				DocumentationGroupName as type,
				IF(DocumentationGroupName = 'xray',IF(ISNULL(T_SamplingSoFormExpose),'N','Y'),'Y') as fill_form,
				IFNULL(T_SamplingSoFormKv,'') as form_kv,
				IFNULL(T_SamplingSoFormMa,'') as form_ma,
				IFNULL(T_SamplingSoFormSecond,'') as form_second,
				IFNULL(T_SamplingSoFormExpose,'') as form_expose
				FROM t_orderheader	
				left JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID AND T_OrderHeaderAddOnIsActive = 'Y'
				JOIN t_orderdetail ON T_OrderDetailT_OrderHeaderID = T_OrderHeaderID AND T_OrderDetailIsActive = 'Y'
				JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND T_TestIsResult = 'Y'
				JOIN t_sampletype ON T_TestT_SampleTypeID = T_SampleTypeID
				JOIN t_bahan ON T_SampleTypeT_BahanID = T_BahanID
				left JOIN t_samplestation ON T_BahanT_SampleStationID = T_SampleStationID AND 
						T_SampleStationID = {samplestationid} AND 
						T_SampleStationIsNonLab = 'ELEKTROMEDIS'
				LEFT JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID 
				LEFT JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID
				LEFT JOIN t_samplingso ON T_SamplingSoT_OrderHeaderID = T_OrderHeaderID AND 
				T_SamplingSoT_TestID = T_TestID AND 
				T_SamplingSoT_SampleStationID = T_SampleStationID AND
						T_SamplingSoIsActive = 'Y'
				LEFT JOIN t_samplingso_requirement ON T_SamplingSoRequirementT_SamplingSoID = T_SamplingSoID AND 
						T_SamplingSoRequirementT_OrderHeaderID = T_OrderHeaderID AND 
						T_SamplingSoRequirementNat_PositionID = 8 AND
						T_SamplingSoRequirementIsActive = 'Y'
				LEFT JOIN t_samplingso_form ON T_SamplingSoFormT_SamplingSOID = T_SamplingSOID AND T_SamplingSoFormIsActive = 'Y'
				WHERE
					T_OrderHeaderID = {orderid} AND T_OrderHeaderIsActive = 'Y'
				GROUP BY T_OrderDetailID
  1. Jika Null typenya maka check documentationgroup nya sudah sesuai dengan natsubgroup ( 14 = fungsi pendengaran)
FROM `documentation_group_detail`
WHERE `DocumentationGroupDetailNat_SubGroupID` = 14
LIMIT 50

lalu

SELECT *
FROM `t_test`
WHERE `T_TestName` LIKE '%AUDIO%'
LIMIT 50
  1. Jika berbeda check ke regional apakah data sudah sesuai
### Masalah Audiometri Tidak Bisa Melanjutkan Proses dari patient Handling nonlab ![image](/attachments/0d5ab130-c97b-4c31-be8e-1f6e84843878) ### Solusi 1. Check Query apakah ada typenya di table documentation_group (ubah orderid dan samplestationid} ``` SELECT T_OrderDetailID as id, T_OrderHeaderID as orderid, T_TestCode as test_code, T_TestName as test_name, T_TestID as test_id, T_BahanName, T_BahanT_SampleStationID , T_SampleStationID , IFNULL(T_SamplingSoID,0) as T_SamplingSoID, IF(ISNULL(T_SamplingSoID),'N',T_SamplingSoFlag) as status, IF(ISNULL(T_SamplingSoProcessDate),'00-00-0000',DATE_FORMAT(T_SamplingSoProcessDate,'%d-%m-%Y')) as process_date, IF(ISNULL(T_SamplingSoProcessTime),'00:00',DATE_FORMAT(T_SamplingSoProcessTime,'%H:%i')) as process_time, IF(ISNULL(T_SamplingSoDoneDate) OR T_SamplingSoFlag = 'P','00-00-0000',DATE_FORMAT(T_SamplingSoDoneDate,'%d-%m-%Y')) as done_date, IF(ISNULL(T_SamplingSoDoneTime) OR T_SamplingSoFlag = 'P','00:00',DATE_FORMAT(T_SamplingSoDoneTime,'%H:%i')) as done_time, IF(ISNULL(T_SamplingSoRequirementID),'X',T_SamplingSoRequirementStatus) as requirement_status, '' as requirements, DocumentationGroupName as type, IF(DocumentationGroupName = 'xray',IF(ISNULL(T_SamplingSoFormExpose),'N','Y'),'Y') as fill_form, IFNULL(T_SamplingSoFormKv,'') as form_kv, IFNULL(T_SamplingSoFormMa,'') as form_ma, IFNULL(T_SamplingSoFormSecond,'') as form_second, IFNULL(T_SamplingSoFormExpose,'') as form_expose FROM t_orderheader left JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID AND T_OrderHeaderAddOnIsActive = 'Y' JOIN t_orderdetail ON T_OrderDetailT_OrderHeaderID = T_OrderHeaderID AND T_OrderDetailIsActive = 'Y' JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND T_TestIsResult = 'Y' JOIN t_sampletype ON T_TestT_SampleTypeID = T_SampleTypeID JOIN t_bahan ON T_SampleTypeT_BahanID = T_BahanID left JOIN t_samplestation ON T_BahanT_SampleStationID = T_SampleStationID AND T_SampleStationID = {samplestationid} AND T_SampleStationIsNonLab = 'ELEKTROMEDIS' LEFT JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID LEFT JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID LEFT JOIN t_samplingso ON T_SamplingSoT_OrderHeaderID = T_OrderHeaderID AND T_SamplingSoT_TestID = T_TestID AND T_SamplingSoT_SampleStationID = T_SampleStationID AND T_SamplingSoIsActive = 'Y' LEFT JOIN t_samplingso_requirement ON T_SamplingSoRequirementT_SamplingSoID = T_SamplingSoID AND T_SamplingSoRequirementT_OrderHeaderID = T_OrderHeaderID AND T_SamplingSoRequirementNat_PositionID = 8 AND T_SamplingSoRequirementIsActive = 'Y' LEFT JOIN t_samplingso_form ON T_SamplingSoFormT_SamplingSOID = T_SamplingSOID AND T_SamplingSoFormIsActive = 'Y' WHERE T_OrderHeaderID = {orderid} AND T_OrderHeaderIsActive = 'Y' GROUP BY T_OrderDetailID ``` 2. Jika Null typenya maka check documentationgroup nya sudah sesuai dengan natsubgroup ( 14 = fungsi pendengaran) ```SELECT * FROM `documentation_group_detail` WHERE `DocumentationGroupDetailNat_SubGroupID` = 14 LIMIT 50 ``` lalu ``` SELECT * FROM `t_test` WHERE `T_TestName` LIKE '%AUDIO%' LIMIT 50 ``` 3. Jika berbeda check ke regional apakah data sudah sesuai
image.png
99 KiB
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
stephenk
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: stephenk/Issue_KD#1
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?