<?php
class Samplingverify extends MY_Controller
{
   var $db_onedev;
   public function index()
   {
      echo "Samplingverify API";
   }
   
   public function __construct()
   {
      parent::__construct();
      $this->db_onedev = $this->load->database("onedev", true);
	  $this->load->helper(array('form', 'url'));
   }
   
   
   function getphotos($orderid,$sampletypeid){
		$rows  = [];
		//print_r($_SERVER);
		$urlbase = 'http://'.$_SERVER['SERVER_NAME']."/one-media/one-image-nonlab/";
		$sql = "SELECT So_ImageUploadID as id,
				So_ImageUploadOldName as oldname,
				CONCAT('{$urlbase}',So_ImageUploadNewName) as newname
				FROM so_imageupload	
				WHERE
					So_ImageUploadT_OrderHeaderID = {$orderid} AND So_ImageUploadT_SampleTypeID = {$sampletypeid}  AND So_ImageUploadIsActive = 'Y'";
		//echo $sql;
		$rows = $this->db_onedev->query($sql)->result_array();
		return $rows;
		
   }
   
   function getdoctors($sampletypeid){
		$rows  = [];

		$sql = "SELECT M_DoctorID as id,
				CONCAT(M_DoctorPrefix,' ',M_DoctorName,' ',M_DoctorSufix) as name
				FROM m_doctorso
				JOIN m_doctor ON M_DoctorSOM_DoctorID = M_DoctorID
				JOIN t_test ON T_TestT_SampleTypeID = {$sampletypeid} AND M_DoctorSONat_SubGroupID = T_TestNat_SubgroupID
				WHERE
					M_DoctorSOIsActive = 'Y'";
		//echo $sql;
		$rows = $this->db_onedev->query($sql)->result_array();
		return $rows;
		
   }
   
   function getsetdoctoraddress($doctorid){
		$rows  = [];

		$sql = "SELECT M_DoctorAddressID as id, M_DoctorAddressDescription as name
					FROM m_doctoraddress 
					WHERE	
						M_DoctorAddressM_DoctorID = {$doctorid} AND M_DoctorAddressIsActive = 'Y'";
		//echo $sql;
		$rows = $this->db_onedev->query($sql)->result_array();
		return $rows;
		
   }
   
   
   public function search()
   {
      $prm = $this->sys_input;
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
	  
	  $nolab = $prm["nolab"];
	  $sampletypeid = $prm["sampletypeid"];
	  $filter_sampletype = '';
	  if(intval($sampletypeid) > 0)
		  $filter_sampletype = " AND T_SampleTypeID = {$sampletypeid}";
	  $limit = '';
	  
	  $filter_search = '';
	  if ($nolab != "") {
         $filter_search = "WHERE ( M_PatientName like '%$nolab%' OR T_OrderHeaderLabNumber LIKE '%$nolab%' OR T_OrderHeaderLabNumberExt LIKE '%$nolab%')";
      }
	  
      $sql_where = "WHERE T_OrderHeaderIsActive = 'Y'";
	  $sql_where_cito = "WHERE T_OrderHeaderIsActive = 'Y' AND T_OrderHeaderIsCito = 'Y' {$filter_search}";
	  
		
		$sql = 	"SELECT * FROM (
				SELECT T_OrderHeaderID,T_BarcodeLabID,T_BarcodeLabBarcode,T_SampleTypeName,T_OrderHeaderLabNumber,
						T_OrderHeaderLabNumberExt,
						IFNULL(JSON_UNQUOTE(JSON_EXTRACT(fn_get_patient_atribute(T_OrderHeaderM_PatientID), '$.M_PatientPhotoThumb')),'') as M_PatientPhotoThumb,
						JSON_UNQUOTE(JSON_EXTRACT(fn_get_patient_atribute(T_OrderHeaderM_PatientID), '$.M_SexName')) as M_SexName, 
						JSON_UNQUOTE(JSON_EXTRACT(fn_get_patient_atribute(T_OrderHeaderM_PatientID), '$.M_TitleName')) as M_TitleName, 
						JSON_UNQUOTE(JSON_EXTRACT(fn_get_patient_atribute(T_OrderHeaderM_PatientID), '$.patient_fullname')) as patient_fullname,
						JSON_UNQUOTE(JSON_EXTRACT(fn_get_patient_atribute(T_OrderHeaderM_PatientID), '$.M_PatientName')) as M_PatientName,
						M_CompanyName,
						JSON_UNQUOTE(JSON_EXTRACT(fn_get_patient_atribute(T_OrderHeaderM_PatientID), '$.M_PatientDOB')) as patient_dob,
						DATE_FORMAT(T_OrderHeaderDate,'%d-%m-%Y %H:%i') as order_date,
						T_SampleStationID, T_SampleTypeID,
						T_OrderSampleID,
						T_SampleStationID as stationid,
						T_OrderSampleVerification,
						IFNULL(T_OrderHeaderFoNote,'') as fo_note,
						IFNULL(T_OrderHeaderVerificationNote,'') as fo_ver_note,
						IFNULL(T_OrderHeaderSamplingNote,'') as sampling_note,
						IF(T_OrderSampleVerification <> 'Y','D','V') as status,
						CONCAT(DATE_FORMAT(T_OrderSampleReceiveDate,'%d-%m-%Y'),' ',DATE_FORMAT(T_OrderSampleReceiveTime,'%H:%i')) as sampling_time,
						fn_getstaffname(T_OrderSampleReceiveUserID) as sampling_user,
						T_OrderHeaderIsCito,
						fn_getrequirement_status(T_OrderSampleID) as requirement_status,
						'' as requirements,
						IF(fn_fo_ver_have_reqs(T_OrderHeaderID) = 0,'Y','N') as fo_ver_status_req,
						fn_fo_reg_have_reqs(T_OrderHeaderID) as fo_reg_status_req,
						fn_sampling_have_reqs(T_OrderHeaderID,T_SampleStationID,T_OrderSampleID,2) as sampling_status_req,
						T_OrderSampleReceiveDate,
						T_OrderSampleReceiveTime
				FROM t_orderheader	
				JOIN m_company ON T_OrderHeaderM_CompanyID = M_CompanyID 
				JOIN t_orderdetail ON T_OrderDetailT_OrderHeaderID = T_OrderHeaderID AND T_OrderDetailIsActive = 'Y' AND T_OrderDetailT_TestIsResult = 'Y'
				JOIN t_test ON T_OrderDetailT_TestID = T_TestID
				JOIN t_sampletype ON T_TestT_SampleTypeID = T_SampleTypeID $filter_sampletype
				JOIN t_barcodelab ON T_BarcodeLabT_OrderHeaderID = T_OrderHeaderID AND T_BarcodeLabT_SampleTypeID = T_SampleTypeID
				JOIN t_bahan ON T_SampleTypeT_BahanID = T_BahanID
				JOIN t_ordersample ON T_OrderSampleT_OrderHeaderID = T_OrderHeaderID AND T_OrderSampleT_SampleTypeID = T_SampleTypeID AND 
					T_OrderSampleT_BarcodeLabID = T_BarcodeLabID AND T_OrderSampleReceive = 'Y' AND T_OrderSampleVerification <> 'Y' AND T_OrderSampleIsActive = 'Y'
				JOIN t_samplestation ON T_OrderSampleT_SampleStationID = T_SampleStationID AND T_SampleStationIsNonLab = ''
				$sql_where
				GROUP BY T_BarcodeLabID
				) x
				{$filter_search}
				ORDER BY T_OrderHeaderIsCito DESC, T_OrderSampleReceiveDate ASC, T_OrderSampleReceiveTime ASC, T_OrderHeaderID ASC
				";
				
		//echo $sql;
		$query = $this->db_onedev->query($sql);
		$rows = $query->result_array();
		if($rows){
			foreach($rows as $k => $v){
				$zxprm = array();
				$zxprm['status'] = $v['status'];
				$zxprm['orderid'] = $v['T_OrderHeaderID'];
				$zxprm['sampletypeid'] = $v['T_SampleTypeID'];
				$rows[$k]['requirements'] = array();//$this->getrequirements($zxprm);
			}
		}
		//$rst = array_merge($rows_cito,$rows_not_cito);
		$result = array("total" => count($rst), "records" => $rows, "sql"=> $this->db_onedev->last_query());
		$this->sys_ok($result);
		exit;
   }
   
   function getrequirements(){
	    //sipe add IsAllTest 
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		
		$prm = $this->sys_input;
		$query = "
				SELECT Nat_RequirementID as id, 
				Nat_RequirementName as name, '{$prm['status']}' as status,
				if(ISNULL(T_OrderSampleReqID),'N', if(json_contains(T_OrderSampleReqs,Nat_RequirementID),'Y','N') ) as chex, 
				Nat_RequirementPositionNat_PositionID as positionid
				FROM nat_requirement
				JOIN nat_testrequirement ON Nat_TestRequirementNat_RequirementID = Nat_RequirementID
				JOIN nat_requirementposition ON Nat_RequirementPositionNat_RequirementID = Nat_RequirementID AND 
						Nat_RequirementPositionNat_PositionID = 3 AND 
						Nat_RequirementPositionIsActive = 'Y'
				JOIN t_barcodelab ON T_barcodeLabT_OrderHeaderID = {$prm['T_OrderHeaderID']} AND 
						T_BarcodeLabT_SampleTypeID = {$prm['T_SampleTypeID']}
				JOIN t_test ON T_TestNat_TestID = Nat_TestRequirementNat_TestID 
				JOIN t_orderdetail on T_OrderDetailT_OrderHeaderID = T_barcodeLabT_OrderHeaderID AND 
						T_OrderDetailT_TestID = T_TestID
				JOIN t_ordersample ON T_OrderSampleT_OrderHeaderID = T_barcodeLabT_OrderHeaderID AND 
						T_OrderSampleT_SampleTypeID = T_BarcodeLabT_SampleTypeID AND 
						T_OrderSampleT_BarcodeLabID = T_BarcodeLabID AND 
						T_OrderSampleIsActive = 'Y'
				LEFT JOIN t_ordersamplereq ON T_OrderSampleReqT_OrderSampleID = T_OrderSampleID AND 
						T_OrderSampleReqT_OrderHeaderID = T_barcodeLabT_OrderHeaderID AND
						T_OrderSampleReqNat_PositionID = Nat_RequirementPositionNat_PositionID
				WHERE	
				Nat_TestRequirementIsActive = 'Y'
                GROUP BY nat_requirementID
                UNION
                SELECT Nat_RequirementID as id, 
				Nat_RequirementName as name, '{$prm['status']}' as status,
				if(ISNULL(T_OrderSampleReqID),'N', if(json_contains(T_OrderSampleReqs,Nat_RequirementID),'Y','N') ) as chex, 
				Nat_RequirementPositionNat_PositionID as positionid
				FROM nat_requirement
				JOIN nat_requirementposition ON Nat_RequirementPositionNat_RequirementID = Nat_RequirementID AND 
						Nat_RequirementPositionNat_PositionID = 3 AND 
						Nat_RequirementPositionIsActive = 'Y' AND 
						Nat_RequirementIsAllTest = 'Y'
				JOIN t_barcodelab ON T_barcodeLabT_OrderHeaderID = {$prm['T_OrderHeaderID']} AND 
						T_BarcodeLabT_SampleTypeID = {$prm['T_SampleTypeID']}
				JOIN t_ordersample ON T_OrderSampleT_OrderHeaderID = T_barcodeLabT_OrderHeaderID AND 
						T_OrderSampleT_SampleTypeID = T_BarcodeLabT_SampleTypeID AND 
						T_OrderSampleT_BarcodeLabID = T_BarcodeLabID AND 
						T_OrderSampleIsActive = 'Y'
				LEFT JOIN t_ordersamplereq ON T_OrderSampleReqT_OrderSampleID = T_OrderSampleID AND 
						T_OrderSampleReqT_OrderHeaderID = T_barcodeLabT_OrderHeaderID AND
						T_OrderSampleReqNat_PositionID = Nat_RequirementPositionNat_PositionID
                GROUP BY nat_requirementID
		";
                //file_put_contents("/xtmp/query",$this->db_onedev->last_query());
		$rows = $this->db_onedev->query($query)->result_array();	

		//return $rows;
		$result = array(
			"total" => count($rows) , 
			"records" => $rows, 
		); 
		$this->sys_ok($result);
		exit;
	}
   
   function getstationstatus(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$rows = [];
		$query ="	SELECT T_SampleStationID as id, T_SampleStationName as name
					FROM t_samplestation 
					WHERE	
						T_SampleStationIsActive = 'Y' AND T_SampleStationIsNonLab = ''
				";
				//echo $query;
		$rows['stations'] = $this->db_onedev->query($query)->result_array();
		$rows['statuses'] = array(array('id'=>'D','name'=>'Belum Verifikasi'),array('id'=>'V','name'=>'Sudah Verifikasi'));
		$sql = "SELECT T_SampleTypeID as id, T_SampletypeName as name
				FROM t_ordersample
				JOIN t_sampletype ON T_OrderSampleT_sampleTypeID = T_sampleTypeID
				JOIN t_bahan ON T_SampleTypeT_BahanID = T_BahanID
				JOIN t_samplestation ON T_BahanT_SampleStationID = T_SampleStationID AND T_SampleStationIsNonLab = ''
				WHERE
				T_OrderSampleReceive = 'Y' AND 
				T_OrderSampleVerification <> 'Y' AND 
				T_OrderSampleIsActive = 'Y'
				GROUP BY T_SampleTypeID";
		$rows['sampletypes'] = $this->db_onedev->query($sql)->result_array();
		array_push($rows['sampletypes'],array('id'=> 0,'name'=> 'Semua'));
		$result = array(
			"total" => count($rows) , 
			"records" => $rows, 
		); 
		$this->sys_ok($result);
		exit;
	}
	
	function getdoctoraddress(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$query ="	SELECT M_DoctorAddressID as id, M_DoctorAddressDescription as name
					FROM m_doctoraddress 
					WHERE	
						M_DoctorAddressM_DoctorID = {$prm['id']} AND M_DoctorAddressIsActive = 'Y'
				";
				//echo $query;
		$rows = $this->db_onedev->query($query)->result_array();

		$result = array(
			"total" => count($rows) , 
			"records" => $rows, 
		); 
		$this->sys_ok($result);
		exit;
	}
	
	function doaction(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$userid = $this->sys_user["M_UserID"];

		//$next_status = $prm['statusnextid'];
		
		if($prm['act'] == 'reject'){
			$sql = "INSERT INTO t_ordersample (
						T_OrderSampleT_OrderHeaderID,
						T_OrderSampleT_SampleTypeID,
						T_OrderSampleT_BarcodeLabID,
						T_OrderSampleUserID
					)
					VALUES(
						{$prm['orderid']},
						{$prm['sampleid']},
						{$prm['barcodeid']},
						{$userid}
					) ON DUPLICATE KEY UPDATE 
							T_OrderSampleReceiveDate = NULL, 
							T_OrderSampleReceiveTime = NULL,
							T_OrderSampleReceiveUserID = NULL,
							T_OrderSampleReceive = 'N',
							T_OrderSampleSamplingDate = NULL, 
							T_OrderSampleSamplingTime = NULL,
							T_OrderSampleSamplingUserID = NULL,
							T_OrderSampleSampling = 'X',
							T_OrderSampleReadyToProcessDateTime = NULL,
							T_OrderSampleIsActive = 'Y',
							T_OrderSampleUserID = {$userid}";
	
			$this->db_onedev->query($sql);
			
			/*$stationid = $this->db_onedev->query("
												SELECT T_BahanT_SampleStationID as id
												FROM t_sampletype 
												JOIN t_bahan ON T_SampleTypeT_BahanID = T_BahanID
												JOIN t_samplestation ON T_BahanT_SampleStationID = T_SampleStationID AND T_SampleStationIsNonLab = ''
												WHERE T_SampleTypeID = {$prm['sampleid']} AND T_SampleStationIsActive = 'Y' LIMIT 1")->row()->id;*/
			$stationid = $prm['sample']['T_SampleStationID'];
			$xreq = $prm['sample']['requirements'];
			$arr_requirements = array();
			foreach($xreq as $k=>$v){
				if($v['chex'] == 'Y')
					array_push($arr_requirements,$v['id']);
			}
			$requirements = '['.join(',',$arr_requirements).']';
			
			$sql = "INSERT INTO t_ordersamplereq(
						T_OrderSampleReqT_OrderHeaderID,
						T_OrderSampleReqT_SampleStationID,
						T_OrderSampleReqT_OrderSampleID,
						T_OrderSampleReqNat_PositionID,
						T_OrderSampleReqStatus,
						T_OrderSampleReqs,
						T_OrderSampleReqUserID,
						T_OrderSampleReqCreated
					)
					VALUES(
						{$prm['sample']['T_OrderHeaderID']},
						{$stationid},
						{$prm['sample']['T_OrderSampleID']},
						{$prm['sample']['requirements'][0]['positionid']},
						'{$prm['sample']['requirement_status']}',
						'{$requirements}',
						{$userid},
						NOW()
					)ON DUPLICATE KEY UPDATE 
							T_OrderSampleReqStatus = '{$prm['sample']['requirement_status']}',
							T_OrderSampleReqs = '{$requirements}',
							T_OrderSampleReqUserID = {$userid}";
					//echo $sql;
			$this->db_onedev->query($sql);
			
			$sql = "INSERT INTO sample_by_step(
								SampleByStepM_StatusSampleCode,
								SampleByStepT_OrderHeaderID,
								SampleByStepT_BarcodeLabID,
								SampleByStepRequirementStatus,
								SampleByStepRequirements,
								SampleByStepUserID,
								SampleByStepDateTime
							)
							VALUES(
								'SAMPLING.Verification.Reject',
								{$prm['orderid']},
								{$prm['barcodeid']},
								'{$prm['sample']['requirement_status']}',
								'{$requirements}',
								{$userid},
								NOW()
							)";
			$this->db_onedev->query($sql);
			
			$next_status = 2;
			$dt_json = json_encode(array('T_SampleStationID'=>$stationid,'T_OrderHeaderID'=>$prm['orderid'],'T_SamplingQueueStatusID'=>$next_status));
			$query = "INSERT INTO  one_log.log_sampling_queue (Log_SamplingQueueDate,Log_SamplingQueueJSON,Log_SamplingQueueUserID)
						VALUES(NOW(),'{$dt_json}',{$userid})";
					//echo $query;
			$rows = $this->db_onedev->query($query);
		
			$query = "INSERT INTO  t_sampling_queue_last_status (
					T_SamplingQueueLastStatusT_SampleStationID,
					T_SamplingQueueLastStatusT_OrderHeaderID,
					T_SamplingQueueLastStatusT_SamplingQueueStatusID,
					T_SamplingQueueLastStatusUserID)
				VALUES(
					{$stationid},
					{$prm['orderid']},
					{$next_status},
					{$userid}) ON DUPLICATE KEY UPDATE T_SamplingQueueLastStatusT_SamplingQueueStatusID = {$next_status}";
				//echo $query;
			$rows = $this->db_onedev->query($query);
		
		}

		if($prm['act'] == 'verify'){
			$sql = "INSERT INTO t_ordersample (
						T_OrderSampleT_OrderHeaderID,
						T_OrderSampleT_SampleTypeID,
						T_OrderSampleT_BarcodeLabID,
						T_OrderSampleUserID
					)
					VALUES(
						{$prm['orderid']},
						{$prm['sampleid']},
						{$prm['barcodeid']},
						{$userid}
					) ON DUPLICATE KEY UPDATE 
							T_OrderSampleVerificationDate = CURDATE(), 
							T_OrderSampleVerificationTime = CURTIME(),
							T_OrderSampleVerificationUserID = {$userid},
							T_OrderSampleVerification = 'Y',
							T_OrderSampleIsActive = 'Y',
							T_OrderSampleUserID = {$userid}";
			$this->db_onedev->query($sql);
			
			$xreq = $prm['sample']['requirements'];
			$arr_requirements = array();
			foreach($xreq as $k=>$v){
				if($v['chex'] == 'Y')
					array_push($arr_requirements,$v['id']);
			}
			$requirements = '['.join(',',$arr_requirements).']';
			
			$sql = "INSERT INTO t_ordersamplereq(
						T_OrderSampleReqT_OrderHeaderID,
						T_OrderSampleReqT_SampleStationID,
						T_OrderSampleReqT_OrderSampleID,
						T_OrderSampleReqNat_PositionID,
						T_OrderSampleReqStatus,
						T_OrderSampleReqs,
						T_OrderSampleReqUserID,
						T_OrderSampleReqCreated
					)
					VALUES(
						{$prm['sample']['T_OrderHeaderID']},
						{$prm['sample']['T_SampleStationID']},
						{$prm['sample']['T_OrderSampleID']},
						{$prm['sample']['requirements'][0]['positionid']},
						'{$prm['sample']['requirement_status']}',
						'{$requirements}',
						{$userid},
						NOW()
					)ON DUPLICATE KEY UPDATE 
							T_OrderSampleReqStatus = '{$prm['sample']['requirement_status']}',
							T_OrderSampleReqs = '{$requirements}',
							T_OrderSampleReqUserID = {$userid}";
					//echo $sql;
			$this->db_onedev->query($sql);
			$sql = "INSERT INTO sample_by_step(
								SampleByStepM_StatusSampleCode,
								SampleByStepT_OrderHeaderID,
								SampleByStepT_BarcodeLabID,
								SampleByStepRequirementStatus,
								SampleByStepRequirements,
								SampleByStepUserID,
								SampleByStepDateTime
							)
							VALUES(
								'SAMPLING.Verification.Verify',
								{$prm['orderid']},
								{$prm['barcodeid']},
								'{$prm['sample']['requirement_status']}',
								'{$requirements}',
								{$userid},
								NOW()
							)";
			$this->db_onedev->query($sql);
			
			$sql = "CALL sp_sampling_set_normal({$prm['orderid']},{$prm['sampleid']})";
			$this->db_onedev->query($sql);
		}
		

		if($prm['act'] == 'unverify'){
			$sql = "INSERT INTO t_ordersample (
						T_OrderSampleT_OrderHeaderID,
						T_OrderSampleT_SampleTypeID,
						T_OrderSampleT_BarcodeLabID,
						T_OrderSampleUserID
					)
					VALUES(
						{$prm['orderid']},
						{$prm['sampleid']},
						{$prm['barcodeid']},
						{$userid}
					) ON DUPLICATE KEY UPDATE 
							T_OrderSampleVerificationDate = NULL, 
							T_OrderSampleVerificationTime = NULL,
							T_OrderSampleVerificationUserID = {$userid},
							T_OrderSampleVerification = 'N',
							T_OrderSampleIsActive = 'Y',
							T_OrderSampleUserID = {$userid}";
			$this->db_onedev->query($sql);
			
			$sql = "INSERT INTO t_ordersamplereq(
						T_OrderSampleReqT_OrderHeaderID,
						T_OrderSampleReqT_SampleStationID,
						T_OrderSampleReqT_OrderSampleID,
						T_OrderSampleReqNat_PositionID,
						T_OrderSampleReqStatus,
						T_OrderSampleReqs,
						T_OrderSampleReqUserID,
						T_OrderSampleReqCreated
					)
					VALUES(
						{$prm['sample']['T_OrderHeaderID']},
						{$prm['stationid']},
						{$prm['sample']['T_OrderSampleID']},
						{$prm['sample']['requirements'][0]['positionid']},
						'{$prm['sample']['requirement_status']}',
						'{$requirements}',
						{$userid},
						NOW()
					)ON DUPLICATE KEY UPDATE 
							T_OrderSampleReqStatus = 'X',
							T_OrderSampleReqs = '[]',
							T_OrderSampleReqUserID = {$userid}";
					//echo $sql;
			$this->db_onedev->query($sql);
		}
		
		
		
		
		$result = array(
			"total" => 1 , 
			"records" => array('status'=>'OK')
		); 
		$this->sys_ok($result);
		
		exit;
	}
	
	function deletephoto(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$userid = $this->sys_user["M_UserID"];
		$query ="	UPDATE so_imageupload SET So_ImageUploadIsActive = 'N', So_ImageUploadUserID = {$userid} WHERE So_ImageUploadID = {$prm['id']}";
				//echo $query;
		$actdelete = $this->db_onedev->query($query);
		
		if($actdelete){
			$result = array(
				"total" => 1 , 
				"records" => array(), 
			); 
			$this->sys_ok($result);
			exit;
		}
		else{
			$this->sys_error_db("so_imageupload delete", $this->db_onedev);
			exit;
		}
		
	}
	
	
	function getdatanoterequirement(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$rst_data = array();	
		$prm = $this->sys_input;
		
		$sql = "SELECT IFNULL(T_OrderHeaderFoNote,'') as fo_note, 
				fn_getstaffname(T_OrderHeaderFoNoteM_UserID) as fo_note_user,
				IFNULL(T_OrderHeaderVerificationNote,'') as fo_ver_note, 
				fn_getstaffname(T_OrderHeaderVerificationNoteM_UserID) as fo_ver_note_user,
				IFNULL(T_OrderHeaderSamplingNote,'') as sampling_note, 
				fn_getstaffname(T_OrderHeaderSamplingNoteM_UserID) as sampling_note_user
				FROM t_orderheader
				WHERE
					T_OrderHeaderID = {$prm['T_OrderHeaderID']}";
		$notes = $this->db_onedev->query($sql)->row_array();
		
		$sql = "SELECT 'fo registration' as position,GROUP_CONCAT(DISTINCT Nat_RequirementName separator ',') as requirements
				FROM t_orderheader
				JOIN t_orderreq ON T_OrderReqT_OrderHeaderID = T_OrderHeaderID
				JOIN nat_requirement ON json_contains(T_OrderReqs,Nat_RequirementID)
				WHERE T_OrderHeaderID = {$prm['T_OrderHeaderID']}
				GROUP BY T_OrderHeaderID";
		//echo $sql;
		$query = $this->db_onedev->query($sql)->row_array();
		if($query){
			array_push($rst_data,$query);
		}
		
		$sql = "SELECT  'fo verifikasi' as position, GROUP_CONCAT(DISTINCT Fo_VerificationsLabelName separator ',') as requirements
				FROM fo_verificationsvalue
				JOIN fo_verificationslabel ON Fo_VerificationsValueFo_VerificationsLabelID = Fo_VerificationsLabelID
				WHERE
				Fo_VerificationsValueCheck = 'N' AND 
				Fo_VerificationsValueT_OrderHeaderID = {$prm['T_OrderHeaderID']}
				GROUP BY Fo_VerificationsValueT_OrderHeaderID
				";
		//echo $sql;
		$query = $this->db_onedev->query($sql)->row_array();
		if($query){
			array_push($rst_data,$query);
		}
		
		$sql = "SELECT  
				Nat_PositionName as position, GROUP_CONCAT(DISTINCT Nat_RequirementName separator ',') as requirements
				FROM t_ordersamplereq
				JOIN nat_requirement ON json_contains(T_OrderSampleReqs,Nat_RequirementID)
				JOIN nat_position ON Nat_PositionID = 2
				WHERE T_OrderSampleReqT_OrderHeaderID = {$prm['T_OrderHeaderID']} AND T_OrderSampleReqT_OrderSampleID = {$prm['T_OrderSampleID']} AND
				T_OrderSampleReqNat_PositionID = 2
				";
		//echo $sql;
		$query = $this->db_onedev->query($sql)->result_array();
		if($query){
			foreach($query as $k => $v){
				if($v['requirements'] != null)
				array_push($rst_data,$v);
			}
		}
		
		$result = array(
			"total" => 1 , 
			"records" => array('notes'=>$notes,'reqs'=>$rst_data)
		); 
		$this->sys_ok($result);
		
		exit;
	}
   
   
   
}