<?php
class Mcu_resume extends MY_Controller
{
   var $db_onedev;
   public function index()
   {
      echo "Resultentry API";
   }
   
   public function __construct()
   {
      parent::__construct();
      $this->db_onedev = $this->load->database("onedev", true);
	  $this->load->helper(array('form', 'url'));
   }
   
   function getdetails($id){
		$rows  = [];

		$sql = "SELECT so_walklettercourierdetail.*, M_SexName, 
					CONCAT(M_TitleName,' ',M_PatientName) as patient_fullname,
					T_SampleTypeName as samplename,
					T_OrderHeaderLabNumber as labnumber, 
					'Y' as active, 
					So_WalkLetterCourierDetailFlagImage as flag_image,
					So_WalkLetterCourierDetailFlagReceiveImage as flag_image_receive,
					So_WalkLetterCourierDetailFlagReceiveResult as flag_result_receive,
					So_WalkLetterCourierDetailID as idx,
					T_OrderHeaderID as orderid,
					T_SampleTypeID as sampleid
					FROM so_walklettercourierdetail 
					JOIN t_orderheader ON So_WalkLetterCourierDetailT_OrderHeaderID = T_OrderHeaderID
					JOIN t_sampletype ON So_WalkLetterCourierDetailT_SampleTypeID = T_SampleTypeID
					JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID
					JOIN m_title ON M_PatientM_TitleID = M_TitleID
					JOIN m_sex ON M_PatientM_SexID = M_SexID
					WHERE	
						So_WalkLetterCourierDetailSo_WalkLetterCourierID = {$id} AND So_WalkLetterCourierDetailIsActive = 'Y'";
		//echo $sql;
		$rows = $this->db_onedev->query($sql)->result_array();
		return $rows;
		
   }
   
   function getdeliveries($orderid){
		$query ="	SELECT T_OrderDeliveryID as id, 
					IFNULL(Fo_VerificationDeliveryID,0) as xid,
					M_DeliveryTypeCode as code,
					IF(ISNULL(Fo_VerificationDeliveryID),'N',Fo_VerificationDeliveryIsOK) as chex,
					M_DeliveryID as deliveryid,
					M_DeliveryTypeID as typedeliveryid,
					T_OrderDeliveryM_KelurahanID as vilageid,
					IF(ISNULL(Fo_VerificationDeliveryID),'',Fo_VerificationDeliveryReason) as note,
					'reguler' as type,
					CASE
						WHEN T_OrderDeliveryM_DeliveryID = 1 THEN M_DeliveryName
						WHEN T_OrderDeliveryM_DeliveryID = 4 THEN CONCAT(M_DeliveryName)
						WHEN T_OrderDeliveryM_DeliveryID = 2 THEN CONCAT(M_DeliveryName)
						WHEN ( T_OrderDeliveryM_DeliveryID = 7 OR T_OrderDeliveryM_DeliveryID = 9 ) THEN CONCAT(M_DeliveryName)
						WHEN ( T_OrderDeliveryM_DeliveryID = 6 OR T_OrderDeliveryM_DeliveryID = 8 ) THEN CONCAT(M_DeliveryName)
						ELSE 
							CONCAT(M_DeliveryName)
					END as label,
					CASE
						WHEN T_OrderDeliveryM_DeliveryID = 1 THEN ''
						WHEN T_OrderDeliveryM_DeliveryID = 4 THEN M_DoctorAddressDescription
						WHEN T_OrderDeliveryM_DeliveryID = 2 THEN M_PatientAddressDescription
						WHEN ( T_OrderDeliveryM_DeliveryID = 7 OR T_OrderDeliveryM_DeliveryID = 9 ) THEN M_DoctorHP
						WHEN ( T_OrderDeliveryM_DeliveryID = 6 OR T_OrderDeliveryM_DeliveryID = 8 ) THEN M_PatientHP
						ELSE 
							T_OrderDeliveryDestination
					END as destination,
					CASE
						WHEN T_OrderDeliveryM_DeliveryID = 4 THEN M_DoctorAddressID
						WHEN T_OrderDeliveryM_DeliveryID = 2 THEN M_PatientAddressID
						ELSE 
							0
					END as addressid
					FROM t_orderdelivery
					JOIN t_orderheader ON T_OrderDeliveryT_OrderHeaderID = T_OrderHeaderID
					JOIN m_delivery ON T_OrderDeliveryM_DeliveryID = M_DeliveryID
					JOIN m_deliverytype ON T_OrderDeliveryM_DeliveryTypeID = M_DeliveryTypeID
					LEFT JOIN m_doctoraddress ON T_OrderDeliveryAddressID = M_DoctorAddressID AND T_OrderDeliveryM_DeliveryID = 4
					LEFT JOIN m_patientaddress ON T_OrderDeliveryAddressID = M_PatientAddressID AND T_OrderDeliveryM_DeliveryID = 2
					LEFT JOIN fo_verification_delivery ON Fo_VerificationDeliveryT_OrderHeaderID =  T_OrderDeliveryT_OrderHeaderID  AND Fo_VerificationDeliveryIsActive = 'Y'
					LEFT JOIN m_doctor ON T_OrderHeaderSenderM_DoctorID = M_DoctorID AND ( T_OrderDeliveryM_DeliveryID = 7 OR T_OrderDeliveryM_DeliveryID = 9 )
					LEFT JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID AND ( T_OrderDeliveryM_DeliveryID = 6 OR T_OrderDeliveryM_DeliveryID = 8 )
					WHERE
					T_OrderDeliveryT_OrderHeaderID =  {$orderid} AND T_OrderDeliveryIsActive = 'Y' 
					GROUP BY T_OrderDeliveryID
					UNION
					SELECT 0 as id, 
					IFNULL(Fo_VerificationDeliveryAddID,0) as xid,
					M_DeliveryTypeCode as code,
					IF(ISNULL(Fo_VerificationDeliveryAddID),'N',Fo_VerificationDeliveryAddOK) as chex,
					Fo_VerificationDeliveryAddM_DeliveryID as deliveryid,
					Fo_VerificationDeliveryAddM_DeliveryTypeID as typedeliveryid,
					Fo_VerificationDeliveryAddM_KelurahanID as vilageid,
					IF(ISNULL(Fo_VerificationDeliveryAddID),'',Fo_VerificationDeliveryAddReason) as note,
					'reguler' as type,
					CASE
						WHEN Fo_VerificationDeliveryAddM_DeliveryID = 1 THEN 'Ambil Sendiri'
						WHEN Fo_VerificationDeliveryAddM_DeliveryID = 4 THEN CONCAT(M_DeliveryName)
						WHEN Fo_VerificationDeliveryAddM_DeliveryID = 2 THEN CONCAT(M_DeliveryName)
						WHEN ( Fo_VerificationDeliveryAddM_DeliveryID = 7 OR Fo_VerificationDeliveryAddM_DeliveryID = 9 ) THEN CONCAT(M_DeliveryName)
						WHEN ( Fo_VerificationDeliveryAddM_DeliveryID = 6 OR Fo_VerificationDeliveryAddM_DeliveryID = 8 ) THEN CONCAT(M_DeliveryName)
						ELSE 
							CONCAT(M_DeliveryName)
					END as label,
					CASE
						WHEN Fo_VerificationDeliveryAddM_DeliveryID = 1 THEN ''
						WHEN Fo_VerificationDeliveryAddM_DeliveryID = 4 THEN M_DoctorAddressDescription
						WHEN Fo_VerificationDeliveryAddM_DeliveryID = 2 THEN M_PatientAddressDescription
						WHEN ( Fo_VerificationDeliveryAddM_DeliveryID = 7 OR Fo_VerificationDeliveryAddM_DeliveryID = 9 ) THEN M_DoctorHP
						WHEN ( Fo_VerificationDeliveryAddM_DeliveryID = 6 OR Fo_VerificationDeliveryAddM_DeliveryID = 8 ) THEN M_PatientHP
						ELSE 
							Fo_VerificationDeliveryAddDestination
					END as destination,
					CASE
						WHEN Fo_VerificationDeliveryAddM_DeliveryID  = 4 THEN M_DoctorAddressID
						WHEN Fo_VerificationDeliveryAddM_DeliveryID  = 2 THEN M_PatientAddressID
						ELSE 
							0
					END as addressid
					FROM fo_verification_delivery_add
					JOIN t_orderheader ON Fo_VerificationDeliveryAddT_OrderHeaderID = T_OrderHeaderID
					JOIN m_delivery ON Fo_VerificationDeliveryAddM_DeliveryID = M_DeliveryID
					JOIN m_deliverytype ON Fo_VerificationDeliveryAddM_DeliveryTypeID = M_DeliveryTypeID
					LEFT JOIN m_doctoraddress ON Fo_VerificationDeliveryAddAddressID = M_DoctorAddressID AND Fo_VerificationDeliveryAddM_DeliveryID  = 4
					LEFT JOIN m_patientaddress ON Fo_VerificationDeliveryAddAddressID = M_PatientAddressID AND Fo_VerificationDeliveryAddM_DeliveryID  = 2
					LEFT JOIN m_doctor ON T_OrderHeaderSenderM_DoctorID = M_DoctorID AND ( Fo_VerificationDeliveryAddM_DeliveryID = 7 OR Fo_VerificationDeliveryAddM_DeliveryID = 9 )
					LEFT JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID AND ( Fo_VerificationDeliveryAddM_DeliveryID = 6 OR Fo_VerificationDeliveryAddM_DeliveryID = 8 )
					WHERE
					Fo_VerificationDeliveryAddT_OrderHeaderID = {$orderid} AND Fo_VerificationDeliveryAddIsActive = 'Y' 
				";
				//echo $query ;
		$rows = $this->db_onedev->query($query)->result_array();
		//echo $this->db_onedev->last_query();
		$rst = '';
		foreach($rows as $k => $v){
			if($rst != ''){
				$rst = $rst.' , '.$v['label'];
			}
			else{
				$rst = $v['label'];
			}
		}
		return $rst;
	}
	
	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 searchcompany(){
		if (! $this->isLogin) {
        $this->sys_error("Invalid Token");
        exit;
        }
		$prm = $this->sys_input;

		$max_rst = 12;
		$tot_count =0;

		$q = [
			'search'     => '%'
		];

		if ($prm['search'] != '')
		{
			$q['search'] = "%{$prm['search']}%";  
		}

		  // QUERY TOTAL
		$sql = "SELECT count(*) as total
				FROM m_company
				JOIN m_mou ON M_MouM_CompanyID = M_CompanyID AND M_MouIsActive = 'Y'
				WHERE 
				M_CompanyName like ?
				AND M_CompanyIsActive = 'Y'";
		$query = $this->db_onedev->query($sql,$q['search']);
		//echo $query;
		//echo $this->db_onedev->last_query();
		if ($query) { 
			$tot_count = $query->result_array()[0]["total"]; 
		} 
		else {
			$this->sys_error_db("m_city count",$this->db_onedev);
			exit;
		}
		
		$sql = "
			SELECT M_CompanyID as id, M_CompanyName as name, '' as mous
			FROM m_company
			JOIN m_mou ON M_MouM_CompanyID = M_CompanyID AND M_MouIsActive = 'Y'
			WHERE 
				M_CompanyName like ? AND 
				M_CompanyIsActive = 'Y'
			ORDER BY M_CompanyName DESC
		";
		$query = $this->db_onedev->query($sql, array($q['search']));
			
		if($query) { 
			$rows = $query->result_array();
			if($rows){
				foreach($rows as $k => $v){
					$sql = "SELECT M_MouID as id, M_MouName as name
							FROM m_mou
							WHERE
								M_MouM_CompanyID = {$v['id']} AND M_MouIsActive = 'Y'";
					$details = $this->db_onedev->query($sql)->result_array();
					$rows[$k]['mous'] = $details;
				}
			}
			//echo $this->db_onedev->last_query();
			$result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
			$this->sys_ok($result);
		} 
		else {
			$this->sys_error_db("m_company rows",$this->db_onedev);
			exit;
		}
	}
   
   public function search()
   {
      $prm = $this->sys_input;
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
	  $filterbytype = '';

      $search = $prm["search"];
	  $type = $prm["type"];
	  if($type == 'C'){
		  $filterbytype = " AND M_MouIsMcu = 'Y'";
	  }
	  else{
		  $filterbytype = " AND T_OrderHeaderAddOnPatientMcu = 'Y'";
	  }
	  $startdate = $prm["startdate"];
	  $enddate = $prm["enddate"];
	  $company = $prm["company"];
	  $mou = $prm["mou"];
	 
	  if(!isset($prm['current_page']))
		  $prm['current_page'] = 1;
	  
	  $sql_where = "WHERE ( T_OrderHeaderDate BETWEEN '{$startdate} 00:00:00' AND '{$enddate} 23:59:59' ) AND T_OrderHeaderIsActive = 'Y'";
	  $number_limit = 10;
	  $number_offset = ($prm['current_page'] - 1) * $number_limit ;
      //$sql_param = array();
      if ($search != "") {
         $sql_where = " WHERE ( T_OrderHeaderLabNumber like '%$search%' OR M_PatientName like '%$search%' ) ";
      }


      $sql = "	SELECT count(*) as total
				FROM (
					SELECT 
						IFNULL(mcu_resumeID,0) as re_id,
						T_OrderHeaderID as trx_id,
						M_PatientID as patientid,
						T_OrderHeaderLabNumber as ordernumber,
						UPPER(CONCAT(M_TitleName,' ',M_PatientName)) as patient_fullname,
						UPPER(M_SexName) as sexname,
						DATE_FORMAT(T_OrderHeaderDate,'%d-%m-%Y') as orderdate,
						DATE_FORMAT(M_PatientDOB,'%d-%m-%Y') as dob,
						UPPER(T_OrderHeaderM_PatientAge) as umur,
						M_LangID as language_id,
						M_LangName as languange_name,
						UPPER(M_CompanyName) as company_name,
						UPPER(M_MouName) as mou_name,
						'' as details,
						T_OrderHeaderIsCito as iscito,
						IFNULL(Mcu_ResumeStatus,'NEW') as status
					FROM t_orderheader
					LEFT JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID
					JOIN m_mou ON T_OrderHeaderM_MouID = M_MouID AND M_MouID = {$mou} $filterbytype
					JOIN m_company ON T_OrderHeaderM_CompanyID = M_CompanyID AND M_CompanyID = {$company}
					JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID
					JOIN m_sex ON M_PatientM_SexID = M_SexID
					LEFT JOIN m_title ON M_PatientM_TitleID = M_TitleID
					LEFT JOIN mcu_resume ON Mcu_ResumeT_OrderHeaderID = T_OrderHeaderID
					LEFT JOIN m_lang ON Mcu_ResumeM_LangID = M_LangID
					$sql_where
					GROUP BY T_OrderHeaderID
				) x
				";
		//echo $sql;
		$query = $this->db_onedev->query($sql);

		$tot_count = 0;
		$tot_page = 0;
		if ($query) {
			$tot_count = $query->result_array()[0]["total"];
			$tot_page = ceil($tot_count/$number_limit);
		} else {
			$this->sys_error_db("t_samplestorageout count", $this->db_onedev);
			exit;
		}  
	  
	  
		$sql = 	"SELECT 
					IFNULL(mcu_resumeID,0) as re_id,
					T_OrderHeaderID as trx_id,
					M_PatientID as patientid,
					T_OrderHeaderLabNumber as ordernumber,
					UPPER(CONCAT(M_TitleName,' ',M_PatientName)) as patient_fullname,
					UPPER(M_SexName) as sexname,
					DATE_FORMAT(T_OrderHeaderDate,'%d-%m-%Y') as orderdate,
					DATE_FORMAT(M_PatientDOB,'%d-%m-%Y') as dob,
					UPPER(T_OrderHeaderM_PatientAge) as umur,
					M_LangID as lang_id,
					M_LangName as lang_name,
					T_OrderHeaderLangIsSI as lang_is_si,
					'' as langs,
					UPPER(M_CompanyName) as company_name,
					UPPER(M_MouName) as mou_name,
					'' as details,
					T_OrderHeaderIsCito as iscito,
					IFNULL(Mcu_ResumeStatus,'NEW') as status
				FROM t_orderheader
				LEFT JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID
				JOIN m_mou ON T_OrderHeaderM_MouID = M_MouID AND M_MouID = {$mou} 
				JOIN m_company ON T_OrderHeaderM_CompanyID = M_CompanyID AND M_CompanyID = {$company}	
				JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID
				JOIN m_sex ON M_PatientM_SexID = M_SexID
				LEFT JOIN m_title ON M_PatientM_TitleID = M_TitleID
				LEFT JOIN mcu_resume ON Mcu_ResumeT_OrderHeaderID = T_OrderHeaderID
				LEFT JOIN m_lang ON T_OrderHeaderM_LangID = M_LangID
				$sql_where $filterbytype
				GROUP BY T_OrderHeaderID
				ORDER BY iscito DESC,T_OrderHeaderID ASC
				limit $number_limit offset $number_offset";
		echo $sql;
		$query = $this->db_onedev->query($sql);
		$rows = $query->result_array();
		//echo $this->db_onedev->last_query();
		if($rows){
			foreach($rows as $k => $v){
				$rows[$k]['langs'] = $this->getlangs($v['trx_id']);
			}
		}
	  
	  
		//$this->_add_address($rows);
		$result = array("total" => $tot_page, "records" => $rows, "sql"=> $this->db_onedev->last_query());
		$this->sys_ok($result);
		exit;
   }
   
   function getlangs($orderid){
	   $sql = "
					SELECT M_LangID as id, M_LangCode as code, M_LangName as name, 'N' as chex
					FROM t_orderheader
					JOIN m_lang ON T_OrderHeaderM_LangID = M_LangID
					WHERE
					T_OrderHeaderID = {$orderid}
					UNION
					SELECT M_LangID as id, M_LangCode as code, M_LangName as name, 'N' as chex
					FROM t_orderheader
					JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID
					JOIN m_lang ON T_OrderHeaderAddOnSecondM_LangID = M_LangID
					WHERE
					T_OrderHeaderID = {$orderid}
		";
		$rst = $this->db_onedev->query($sql)->result_array();
		return $rst;
   }
   
   function getordersamples(){
	   $prm = $this->sys_input;
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$doctorid = $prm['doctorid'];
		$doctoraddressid = $prm['doctoraddressid'];
	   $sql = "SELECT 
					0 as idx,
					M_SexName, 
					CONCAT(M_TitleName,' ',M_PatientName) as patient_fullname,
					T_SampleTypeName as samplename, 
					T_OrderHeaderLabNumber as labnumber, 
					T_OrderHeaderID as orderid,
					T_SampleTypeID as sampleid,
					'Y' as active, 
					'N' as flag_image
					FROM t_samplingso
					JOIN t_orderheader ON T_SamplingSoT_OrderHeaderID = T_OrderHeaderID
					JOIN t_sampletype ON T_SamplingSoT_SampleTypeID = T_SampleTypeID
					JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID
					JOIN m_title ON M_PatientM_TitleID = M_TitleID
					JOIN m_sex ON M_PatientM_SexID = M_SexID
					WHERE	
						T_SamplingSoM_DoctorID = {$doctorid} AND T_SamplingSoM_DoctorAddressID = {$doctoraddressid} AND T_SamplingSoVerifyFlagWL = 'N' AND T_SamplingSoIsActive = 'Y'";
		//echo $sql;
		$rows = $this->db_onedev->query($sql)->result_array();
		$result = array(
			"total" => count($rows) , 
			"records" => $rows, 
		); 
		$this->sys_ok($result);
		exit;
	   
   }
   
	function getgroups(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$rows = [];
		$query ="	SELECT Nat_GroupID as id, Nat_GroupName as title, CONCAT('GROUP : ',Nat_GroupName) as fulltitle, '' as childrens
					FROM nat_group 
					WHERE	
						Nat_GroupIsActive = 'Y' AND ( Nat_GroupCode = 2 OR Nat_GroupCode = 3 )
				";
				//echo $query;
		$rows['groups'] = $this->db_onedev->query($query)->result_array();
		if($rows['groups']){
			foreach($rows['groups'] as $k => $v){	
				$childrens = array(array('id'=> 0, 'title'=>'Semua', 'fulltitle'=>'Subgroub : Semua'));
				$query ="	SELECT Nat_SubGroupID as id, Nat_SubGroupName as title, CONCAT('SUBGROUP : ',Nat_SubGroupName) as fulltitle
					FROM nat_subgroup 
					WHERE	
						Nat_SubGroupNat_GroupID = {$v['id']} AND Nat_SubGroupIsActive = 'Y'
				";
				//echo $query;
				$xrst = $this->db_onedev->query($query)->result_array();
				if($xrst){
					foreach($xrst as $ki => $vi){				
						array_push($childrens,$vi);
					}
				}
				$rows['groups'][$k]['childrens'] = $childrens ;
			}
		}
		$query ="	SELECT M_LangID as id, M_LangCode as name
					FROM m_lang 
					WHERE	
						M_LangIsActive = 'Y' 
				";
				//echo $query;
		$rows['langs'] = $this->db_onedev->query($query)->result_array();
		$result = array(
			"total" => count($rows) , 
			"records" => $rows, 
		); 
		$this->sys_ok($result);
		exit;
	}
	
	function getsubgroups(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$rows = array(array('id'=>0, 'title'=>'Semua', 'fulltitle'=>'Subgroub : Semua'));
		$query ="	SELECT Nat_SubGroupID as id, Nat_SubGroupName as title, CONCAT('SUBGROUP : ',Nat_SubGroupName) as fulltitle
					FROM nat_subgroup 
					WHERE	
						Nat_SubGroupNat_GroupID = {$prm['id']} AND Nat_SubGroupIsActive = 'Y'
				";
				//echo $query;
		$rst = $this->db_onedev->query($query)->result_array();
		if($rst){
			foreach($rst as $k => $v){				
				array_push($rows,$v);
			}
		}
		$result = array(
			"total" => count($rows) , 
			"records" => $rows, 
		); 
		$this->sys_ok($result);
		exit;
	}
   
   function getstation(){
		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'
				";
				//echo $query;
		$rows['stations'] = $this->db_onedev->query($query)->result_array();
		//print_r($statuses);
		foreach($statuses as $k=>$v){
			array_push($rows['statuses'],$v);
		}

		$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 getdatadetails(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$orderid = $prm['trx_id'];
		$re_id = $prm['re_id'];
		$lang_id = $prm['lang_id'];
		$lang_is_si = $prm['lang_is_si'];
		$rows = array();
		$rows['Laboratorium'] = $this->generate_resume_lab($prm);
		$rows['Non Laboratorium'] = $this->generate_resume_nonlab($prm);
		$rows['Pemeriksaan Dokter'] = $this->generate_resume_pemeriksaan_dokter($prm);
		$conclusion['Kesimpulan'] = '';
		$conclusion['Rekomendasi'] = '';
		$conclusion['Saran'] = '';
		$sql = "SELECT 	IFNULL(Mcu_ResumeKesimpulan,'') as kesimpulan,
						IFNULL(Mcu_ResumeRekomendasi,'') as rekomendasi,
						IFNULL(Mcu_ResumeSaran,'') as saran
							FROM mcu_resume
							WHERE 
								Mcu_ResumeT_OrderHeaderID = {$orderid} AND
								Mcu_ResumeIsActive = 'Y' LIMIT 1";
								//echo $sql;
		$rst_conclusion = $this->db_onedev->query($sql)->row_array();
		if($rst_conclusion){
			$conclusion['kesimpulan'] = $rst_conclusion['kesimpulan'];
			$conclusion['rekomendasi'] = $rst_conclusion['rekomendasi'];
			$conclusion['saran'] = $rst_conclusion['saran'];
		}
								
		
		$rst = array('result'=>$rows, 'conclusion'=>$conclusion);

		$result = array(
			"total" => count($rst) , 
			"records" => $rst, 
		); 
		$this->sys_ok($result);
		exit;
	}
	
	function generate_resume_lab($prm){
		$rows = array();
		$orderid = $prm['trx_id'];
		$re_id = $prm['re_id'];
		$lang_id = $prm['lang_id'];
		$lang_is_si = $prm['lang_is_si'];
		$query = "
					SELECT 	'test' as type,
							'lab' as category,
							Nat_TestNat_SubSubGroupID as nat_subsubgroup_id,
							T_OrderDetailID as orderdetail_id, 
							T_TestID as test_id, 
							T_TestName as test_name, 
							T_TestCode as test_code, 
							T_TestSasCode as test_sas_code, 
							Nat_TestFlagMcu as flag_mcu, 
							{$lang_id} as lang_id,
							M_LangCode as lang_code,
							M_LangName as lang_name,
							'{$lang_is_si}' as lang_is_si,
							IFNULL(Mcu_ResumeDetailsResult,'') as result
					FROM t_orderdetail
					JOIN t_orderheader ON T_OrderDetailT_OrderHeaderID = T_OrderHeaderID
					JOIN t_test ON T_OrderDetailT_TestID = T_TestID
					JOIN m_lang ON {$lang_id} = M_LangID
					JOIN nat_test ON T_TestNat_TestID = Nat_TestID AND  (Nat_TestFlagMcu = 'G' OR Nat_TestFlagMcu = 'A')
					LEFT JOIN mcu_resumedetails ON Mcu_ResumeDetailsMcu_ResumeID = {$re_id} AND
						Mcu_ResumeDetailsT_OrderDetailID = T_OrderDetailID AND 
						Mcu_ResumeDetailsT_TestID = T_OrderDetailT_TestID AND 
						Mcu_ResumeDetailsM_LangID = {$lang_id} AND 
						Mcu_ResumeDetailsLangIsSI = '{$lang_is_si}' AND 
						Mcu_ResumeDetailsIsActive = 'Y'
					WHERE
						T_OrderDetailT_OrderHeaderID = {$orderid} AND 
						T_OrderDetailIsActive = 'Y' 
					UNION
					SELECT 	'subsubgroup' as type,
							'lab' as category,
							Nat_TestNat_SubSubGroupID as nat_subsubgroup_id,
							T_OrderDetailID as orderdetail_id, 
							T_TestID as test_id, 
							Nat_SubSubGroupName as test_name, 
							Nat_SubSubGroupCode as test_code, 
							T_TestSasCode as test_sas_code, 
							'G' as flag_mcu, 
							{$lang_id} as lang_id,
							M_LangCode as lang_code,
							M_LangName as lang_name,
							'{$lang_is_si}' as lang_is_si,
							IFNULL(Mcu_ResumeDetailsResult,'') as result
					FROM t_orderdetail
					JOIN t_orderheader ON T_OrderDetailT_OrderHeaderID = T_OrderHeaderID
					JOIN t_test ON T_OrderDetailT_TestID = T_TestID
					JOIN m_lang ON {$lang_id} = M_LangID
					JOIN nat_test ON T_TestNat_TestID = Nat_TestID AND Nat_TestFlagMcu = 'C'
					JOIN nat_subsubgroup ON Nat_SubSubGroupID = Nat_TestNat_SubSubGroupID
					LEFT JOIN mcu_resumedetails ON Mcu_ResumeDetailsMcu_ResumeID = {$re_id} AND
						Mcu_ResumeDetailsT_OrderDetailID = T_OrderDetailID AND 
						Mcu_ResumeDetailsT_TestID = T_OrderDetailT_TestID AND 
						Mcu_ResumeDetailsM_LangID = {$lang_id} AND 
						Mcu_ResumeDetailsLangIsSI = '{$lang_is_si}' AND 
						Mcu_ResumeDetailsIsActive = 'Y'
					WHERE
						T_OrderDetailT_OrderHeaderID = {$orderid} AND 
						T_OrderDetailIsActive = 'Y'
					GROUP BY Nat_TestNat_SubSubGroupID
						
				";
				//echo $query;
		$rows = $this->db_onedev->query($query)->result_array();
		if($rows){
			foreach($rows as $k => $v){
				if($v['result'] == ''){
					if($v['flag_mcu'] == 'G'){
						$rows[$k]['result'] = 'Dalam batas normal';
						if($v['type'] == 'test'){
							$sql = "SELECT T_OrderDetailID, 
									T_OrderDetailResult,  
									T_OrderDetailNat_NormalValueID,
									Nat_TestIsQuantitative,
									T_OrderDetailNormalValueNote,
									T_OrderdetailValidation,
									T_TestName
									FROM t_orderdetail
									JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND T_TestIsResult = 'Y'
									JOIN nat_test ON T_TestNat_TestID = Nat_TestID
									JOIN t_orderdetailaddon ON T_OrderDetailAddOnT_OrderDetailID = T_OrderDetailID AND 
										T_OrderDetailAddOnNormalFlag <> 'N' AND 
										T_OrderDetailAddOnIsActive = 'Y'
									WHERE
										T_TestSasCode LIKE '{$v['T_TestSasCode']}%' AND 
										T_OrderDetailValidation = 'Y' AND 
										T_OrderDetailResult IS NOT NULL AND
										T_OrderDetailResult <> '' AND
										T_OrderDetailT_OrderHeaderID = {$orderid} AND 
										T_OrderDetailIsActive = 'Y'";
						}
						if($v['type'] == 'subsubgroup'){
							$sql = "SELECT T_OrderDetailID, 
									T_OrderDetailResult,  
									T_OrderDetailNat_NormalValueID,
									Nat_TestIsQuantitative,
									T_OrderDetailNormalValueNote,
									T_TestName
									FROM t_orderdetail
									JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND T_TestIsResult = 'Y'
									JOIN nat_test ON T_TestNat_TestID = Nat_TestID AND Nat_TestFlagMcu = 'C' AND 
										Nat_TestNat_SubSubGroupID = {$v['nat_subsubgroup_id']}
									JOIN t_orderdetailaddon ON T_OrderDetailAddOnT_OrderDetailID = T_OrderDetailID AND 
										T_OrderDetailAddOnNormalFlag <> 'N' AND 
										T_OrderDetailAddOnIsActive = 'Y'
									WHERE
										T_OrderDetailValidation = 'Y' AND 
										T_OrderDetailResult IS NOT NULL AND
										T_OrderDetailT_OrderHeaderID = {$orderid} AND 
										T_OrderDetailResult <> '' AND
										T_OrderDetailIsActive = 'Y'";
						}
						//echo $sql;
						$details = $this->db_onedev->query($sql)->result_array();
						if($details){
							$result = '';
							foreach($details as $ik => $iv){
								$result_value = $iv['T_OrderDetailResult'];
								if($iv['Nat_TestIsQuantitative'] == 'Y'){
									$sql = "SELECT *
											FROM nat_normalvalue
											LEFT JOIN nat_normalvaluelang ON Nat_NormalValueLangNat_NormalValueID = Nat_NormalValueID AND
													Nat_NormalValueLangNat_LangID = {$v['lang_id']} AND Nat_NormalValueLangIsActive = 'Y'
											WHERE
												(
													((Nat_NormalValueMinValueInclusive = 'Y' AND {$result_value} >= Nat_NormalValueMinValue) OR 
													(Nat_NormalValueMinValueInclusive = 'N' AND {$result_value} > Nat_NormalValueMinValue)) AND
													((Nat_NormalValueMaxValueInclusive = 'Y' AND {$result_value} <= Nat_NormalValueMaxValue) OR 
													(Nat_NormalValueMinValueInclusive = 'N' AND {$result_value} < Nat_NormalValueMinValue))
												) AND
												Nat_NormalValueParentID = {$iv['T_OrderDetailNat_NormalValueID']} AND 
												Nat_NormalValueIsAbnormal = 'Y' AND 
												Nat_NormalValueIsActive = 'Y' LIMIT 1";
												//echo $sql;
									$data_x = $this->db_onedev->query($sql)->row();
									if($data_x){ 
										if($result != '')
											$result .= " , ";
													
										if($v['lang_code'] == 'ID'){
											if($v['lang_is_si'] == 'Y')
												$result .= $iv['T_TestName'].' '.$data_x->Nat_NormalValueLangNoteSI. " ( ".$result_value." )";
											else
												$result .= $iv['T_TestName'].' '.$data_x->Nat_NormalValueNote. " ( ".$result_value." )";
										}
										else{
											if($v['lang_is_si'] == 'N')
												$result .= $iv['T_TestName'].' '.$data_x->Nat_NormalValueLangNote. " ( ".$result_value." )";
											if($v['lang_is_si'] == 'Y')
												$result .= $iv['T_TestName'].' '.$data_x->Nat_NormalValueLangNoteSI. " ( ".$result_value." )";
										}
										
									}
								}
								else{
									if($iv['T_OrderDetailResult'] <> $iv['T_OrderDetailNormalValueNote']){
										if($result != '')
											$result .= " , ";
										
										if($v['lang_code'] == 'ID'){
											if($v['lang_is_si'] == 'Y')
												$result .= $iv['T_OrderDetailResult'];
											else
												$result .= $iv['T_OrderDetailResult'];
										}
										else{
											if($v['lang_is_si'] == 'N')
												$result .= $iv['T_OrderDetailResult'];
											if($v['lang_is_si'] == 'Y')
												$result .= $iv['T_OrderDetailResult'];
										}
									}
								}
								
							}
							if($result != '')
								$rows[$k]['result'] = $result; 
						}
						else{
							
							//$rows[$k]['result'] = 'Belum ada hasil';
						}
					}else{
						$sql = "SELECT T_OrderDetailID, 
								T_OrderDetailResult,  
								T_OrderDetailNat_NormalValueID,
								T_OrderDetailNormalValueNote
								FROM t_orderdetail
								JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND T_TestIsResult = 'Y'
								WHERE
									T_TestSasCode LIKE '{$v['T_TestSasCode']}%' AND 
									T_OrderDetailValidation = 'Y' AND 
									T_OrderDetailResult IS NOT NULL AND
									T_OrderDetailResult <> '' AND
									T_OrderDetailIsActive = 'Y'";
						$details = $this->db_onedev->query($sql)->result_array();
						if($details){
							$result = '';
							foreach($details as $ik => $iv){
								$result .= $vi['T_OrderDetailResult'];
							}
							$rows[$k]['result'] = $result ;
						}else{
							//$rows[$k]['result'] = 'Belum ada hasil';
						}
					}
				}
			}
		}

		return $rows;
		
	}
	
	
	function generate_resume_nonlab($prm){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		
		$orderid = $prm['trx_id'];
		$re_id = $prm['re_id'];
		$lang_id = $prm['lang_id'];
		$lang_is_si = $prm['lang_is_si'];
		
		$rows = array();
		$sql = "SELECT  T_TestID as test_id, 
						So_ResultEntryT_OrderDetailID as orderdetail_id,
						'nonlab' as category,
						T_TestName as test_name, 
						T_TestCode as test_code, 
						T_TestSasCode as test_sas_code,
						{$lang_id} as lang_id,
						M_LangCode as lang_code,
						M_LangName as lang_name,
						IF(So_ResultEntryValidation1 = 'Y',IF(ISNULL(Mcu_ResumeDetailsResult),So_ResultEntryDetailResult,IF(Mcu_ResumeDetailsResult = '',So_ResultEntryDetailResult,Mcu_ResumeDetailsResult)),'Belum ada hasil') as result
				FROM so_resultentry
				JOIN so_resultentrydetail ON So_ResultEntryDetailSo_ResultEntryID = So_ResultEntryID AND 
					So_ResultEntryDetailIsActive = 'Y'
				JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID AND T_OrderDetailIsActive = 'Y'
				JOIN t_test ON T_OrderDetailT_TestID = T_TestID
				JOIN so_templatedetail ON So_TemplateDetailID = So_ResultEntryDetailSo_TemplateDetailID AND
					( So_TemplateDetailName = 'Kesan' OR SO_TemplateDetailName = 'Conclusion') AND So_TemplateDetailIsActive = 'Y'
				JOIN m_lang ON {$lang_id} = M_LangID
				LEFT JOIN mcu_resumedetails ON Mcu_ResumeDetailsMcu_ResumeID = {$re_id} AND 
					Mcu_ResumeDetailsT_OrderDetailID = So_ResultEntryT_OrderDetailID AND 
					Mcu_ResumeDetailsM_LangID = So_ResultEntryM_LangID AND
					Mcu_ResumeDetailsIsActive = 'Y'
				JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID 
				JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID AND ( DocumentationGroupName <> 'lab' OR DocumentationGroupName <> 'other' )
				WHERE
					So_ResultEntryT_OrderHeaderID = {$prm['trx_id']} AND 
					So_ResultEntryM_LangID = {$lang_id} AND
					So_ResultEntryIsActive = 'Y'
				GROUP BY So_ResultEntryID
				UNION
				SELECT  T_TestID as test_id, 
						So_ResultEntryT_OrderDetailID as orderdetail_id,
						'nonlab' as category,
						T_TestName as test_name, 
						T_TestCode as test_code, 
						T_TestSasCode as test_sas_code,
						{$lang_id} as lang_id,
						M_LangCode as lang_code,
						M_LangName as lang_name,
						IF(So_ResultEntryValidation1 = 'Y',IF(ISNULL(Mcu_ResumeDetailsResult),So_ResultEntryDetailOtherResult,IF(Mcu_ResumeDetailsResult = '',So_ResultEntryDetailOtherResult,Mcu_ResumeDetailsResult)),'Belum ada hasil') as result
				FROM so_resultentry
				JOIN so_resultentrydetail_other ON So_ResultEntryDetailOtherSo_ResultEntryID = So_ResultEntryID AND 
					So_ResultEntryDetailOtherIsActive = 'Y'
				JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID AND T_OrderDetailIsActive = 'Y'
				JOIN t_test ON T_OrderDetailT_TestID = T_TestID
				JOIN so_templatedetail ON So_TemplateDetailID = So_ResultEntryDetailOtherSo_TemplateDetailID AND
					( So_TemplateDetailName = 'Kesan' OR SO_TemplateDetailName = 'Conclusion') AND So_TemplateDetailIsActive = 'Y'
				JOIN m_lang ON 1 = M_LangID
				LEFT JOIN mcu_resumedetails ON Mcu_ResumeDetailsMcu_ResumeID = 0 AND 
					Mcu_ResumeDetailsT_OrderDetailID = So_ResultEntryT_OrderDetailID AND 
					Mcu_ResumeDetailsM_LangID = So_ResultEntryDetailOtherM_LangID AND
					Mcu_ResumeDetailsIsActive = 'Y'
				JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID 
				JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID AND ( DocumentationGroupName <> 'lab' OR DocumentationGroupName <> 'other' )
				WHERE
					So_ResultEntryT_OrderHeaderID = {$prm['trx_id']} AND 
					So_ResultEntryDetailOtherM_LangID = {$lang_id} AND
					So_ResultEntryIsActive = 'Y'
				GROUP BY So_ResultEntryID";
		//echo $sql;
		$rows = $this->db_onedev->query($sql)->result_array();

		return $rows;
	}
	
	
	function generate_resume_pemeriksaan_dokter($prm) {
		$orderid = $prm['trx_id'];
		$re_id = $prm['re_id'];
		$langid = $prm['lang_id'];
		$lang_is_si = $prm['lang_is_si'];
		
		$sql = "SELECT 'fisik' as type,
				'docter' as category,
				Nat_TestNat_SubSubGroupID as nat_subsubgroup_id,
				Mcu_ResumeDetailsT_OrderDetailID as orderdetail_id, 
				T_TestID as test_id,
				T_TestName as test_name,
				T_TestCode as test_code,
				T_TestSasCode as test_sas_code,
				'X' as flag_mcu,
				{$langid} as lang_id,
				M_LangCode as lang_code,
				M_LangName as lang_name,
				Mcu_ResumeDetailsResult as result
				FROM mcu_resumedetails 
				JOIN t_test ON Mcu_ResumeDetailsT_TestID = T_TestID AND T_TestIsNonLab = 'FISIK UMUM'
				JOIN nat_test ON T_TestNat_TestID = Nat_testID
				JOIN m_lang ON Mcu_ResumeDetailsM_LangID = M_LangID
				WHERE
				Mcu_ResumeDetailsMcu_ResumeID = {$re_id} AND 
				Mcu_ResumeDetailsCategory = 'docter' AND 
				Mcu_ResumeDetailsM_LangID = {$langid} AND 
				Mcu_ResumeDetailsLangIsSI = '{$lang_is_si}' AND
				Mcu_ResumeDetailsIsActive = 'Y' LIMIT 1";
				//echo $sql;
		$rst_now = $this->db_onedev->query($sql)->row_array();
		if(!$rst_now || $rst_now['result'] == ''){
		
			$sql = "SELECT SO_ResultentryID as id
					FROM so_resultentry
					JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID
					JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND T_TestIsNonLab = 'FISIK UMUM'
					WHERE
					So_ResultEntryT_OrderHeaderID = {$orderid} AND So_ResultEntryIsActive = 'Y' AND So_ResultEntryValidation1 = 'Y' LIMIT 1";
					//echo $sql;
			$id = $this->db_onedev->query($sql)->row()->id;
			
		  $kode_gigi = array( "X" => "Berlubang" , "C" => "Tambalan", "O" => "Tanggal",
			 "R" => "Sisa akar", "A" => "Gigi Palsu" , "K" => "Karang Gigi" );
		  $sql = "select * from so_resultentry_fisik_umum
			 where So_ResultEntryFisikUmumSo_ResultEntryID = {$id}
			 and So_ResultEntryFisikUmumM_LangID = {$langid}
			 and So_ResultEntryFisikUmumType='fisik'";
			// echo $sql;
		  $rows = $this->db_onedev->query($sql)->result_array();
		 // $rows = $qry->result_array();
		  if ( count($rows) == 0 ) return '';
		  $data = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
		  $kesimpulan = "";
		  $arr_gigi = array();
		  foreach($data as $obj) {
			 if ( isset($obj["details"]) ) {
				$dd = $obj["details"];
				if (isset($dd["details"])) {
					  if (isset($dh["chx_x"])) {
						 if ($dh["chx_x"] == "1") {
							if ($kesimpulan != "" ) $kesimpulan .= ", ";
							$kesimpulan .= $dh["label"] . " " . $dh["label_x"];
						 }
					  } elseif (isset($dh["is_normal"])) {
						 if ($dh["is_normal"] == "N") {
							if ($kesimpulan != "" ) $kesimpulan .= ", ";
							$kesimpulan .= $dh["label"] . " " . $dh["value"];
						 }
					  } elseif (isset($dh["chx"])) {
						 if ($dh["chx"] == "1") {
							if ($kesimpulan != "" ) $kesimpulan .= ", ";
							$kesimpulan .= $dh["label"] . " " . $dh["value"];
						 }
					  }
				} else {
				   foreach($dd as $dh) {
					  if ( $obj["type_form"] == "TOOTH" ) {
						 foreach($dh["details"] as $xd) {
							if ($xd["value"] != "" ) {
							   if ( ! in_array($arr_gigi , $kode_gigi[$xd["value"]]) ) {
								  $arr_gigi[] = $kode_gigi[$xd["value"]];
								  }
							}
						 }
					  } elseif (isset($dh["chx_x"])) {
						 if ($dh["chx_x"] == "1") {
							if ($kesimpulan != "" ) $kesimpulan .= ", ";
							$kesimpulan .= $dh["label"] . " " . $dh["label_x"];
						 }
					  } elseif (isset($dh["is_normal"])) {
						 if ($dh["is_normal"] == "N") {
							if ($kesimpulan != "" ) $kesimpulan .= ", ";
							$kesimpulan .= $dh["label"] . " " . $dh["value"];
						 }
					  } elseif (isset($dh["chx"])) {
						 if ($dh["chx"] == "1") {
							if ($kesimpulan != "" ) $kesimpulan .= ", ";
							$kesimpulan .= $dh["label"] . " " . $dh["value"];
						 }
					  }
				   }
				}
			 }
		  }
		  if ($kesimpulan == "" ) {
			 $kesimpulan = "Dalam batas normal";
		  } else {
			 $kesimpulan = "Pada saat ini di dapatkan kelainan berupa : \n$kesimpulan";
		  }
		  if ( count($arr_gigi) > 0 ) {
			 $kesimpulan .= "\nGigi : " . join($arr_gigi);
		  }
		  
		  $sql = "	SELECT 'fisik' as type,
					'docter' as category,
					Nat_TestNat_SubSubGroupID as nat_subsubgroup_id,
					T_OrderDetailID as orderdetail_id, 
					T_TestID as test_id,
					T_TestName as test_name,
					T_TestCode as test_code,
					T_TestSasCode as test_sas_code,
					'X' as flag_mcu,
					{$langid} as lang_id,
					M_LangCode as lang_code,
					M_LangName as lang_name,
					'' as result
					FROM so_resultentry
					JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID
					JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND T_TestIsNonLab = 'FISIK UMUM'
					JOIN nat_test ON T_TestNat_TestID = Nat_testID
					JOIN m_lang ON {$langid} = M_LangID
					WHERE
					So_ResultEntryT_OrderHeaderID = {$orderid} AND So_ResultEntryIsActive = 'Y' LIMIT 1";
				//	echo $sql;
			$xrst = $this->db_onedev->query($sql)->row_array();
			$xrst['result'] = $kesimpulan;
		}
		else{
			$xrst = $rst_now;
		}
      //return $kesimpulan;
		$rst[] = $xrst;
		return $rst;
    }
	
	function saveresult(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		
		$prm = $this->sys_input;
		$userid = $this->sys_user["M_UserID"];
		$re_id = intval($prm['trx']['re_id']);
		if($re_id == 0){
			$sql = "INSERT INTO mcu_resume (
						Mcu_ResumeT_OrderHeaderID,
						Mcu_ResumeM_LangID,
						Mcu_ResumeKesimpulan,
						Mcu_ResumeRekomendasi,
						Mcu_ResumeSaran,
						Mcu_ResumeUserID,
						Mcu_ResumeCreated
					)
					VALUE(
						{$prm['trx']['trx_id']},
						{$prm['trx']['lang_id']},
						'{$prm['conclusions']['kesimpulan']}',
						'{$prm['conclusions']['rekomendasi']}',
						'{$prm['conclusions']['saran']}',
						{$userid},
						NOW()
					)";
					//echo $sql;
			$this->db_onedev->query($sql);
			$re_id = $this->db_onedev->insert_id();
		}
		else{
			$sql = "UPDATE mcu_resume SET 
						Mcu_ResumeKesimpulan = '{$prm['conclusions']['kesimpulan']}',
						Mcu_ResumeRekomendasi = '{$prm['conclusions']['rekomendasi']}',
						Mcu_ResumeSaran = '{$prm['conclusions']['saran']}',
						Mcu_ResumeUserID = {$userid}
					WHERE
						Mcu_ResumeID = {$re_id}
					";
				//	echo $sql;
			$this->db_onedev->query($sql);
		}
		
		$details = $prm['details'];
		if($details){
			foreach($details['Laboratorium'] as $k => $v){
				$sql = "INSERT INTO mcu_resumedetails(
							Mcu_ResumeDetailsMcu_ResumeID,
							Mcu_ResumeDetailsCategory,
							Mcu_ResumeDetailsT_OrderDetailID,
							Mcu_ResumeDetailsT_TestID,
							Mcu_ResumeDetailsM_LangID,
							Mcu_ResumeDetailsLangIsSI,
							Mcu_ResumeDetailsResult,
							Mcu_ResumeDetailsCreated,
							Mcu_ResumeDetailsUserID
						)
						VALUES(
							{$re_id},
							'{$v['category']}',
							{$v['orderdetail_id']},
							{$v['test_id']},
							{$prm['trx']['lang_id']},
							'{$prm['trx']['lang_is_si']}',
							'{$v['result']}',
							NOW(),
							{$userid}
						)
						ON DUPLICATE KEY UPDATE 
							Mcu_ResumeDetailsResult = '{$v['result']}',
							Mcu_ResumeDetailsUserID = {$userid},
							Mcu_ResumeDetailsIsActive = 'Y'
							";
				//echo $sql;
				$this->db_onedev->query($sql);
			}
			
			foreach($details['Non Laboratorium'] as $k => $v){
				$sql = "INSERT INTO mcu_resumedetails(
							Mcu_ResumeDetailsMcu_ResumeID,
							Mcu_ResumeDetailsCategory,
							Mcu_ResumeDetailsT_OrderDetailID,
							Mcu_ResumeDetailsT_TestID,
							Mcu_ResumeDetailsM_LangID,
							Mcu_ResumeDetailsLangIsSI,
							Mcu_ResumeDetailsResult,
							Mcu_ResumeDetailsCreated,
							Mcu_ResumeDetailsUserID
						)
						VALUES(
							{$re_id},
							'{$v['category']}',
							{$v['orderdetail_id']},
							{$v['test_id']},
							{$prm['trx']['lang_id']},
							'{$prm['trx']['lang_is_si']}',
							'{$v['result']}',
							NOW(),
							{$userid}
						)
						ON DUPLICATE KEY UPDATE 
							Mcu_ResumeDetailsResult = '{$v['result']}',
							Mcu_ResumeDetailsUserID = {$userid},
							Mcu_ResumeDetailsIsActive = 'Y'";
				$this->db_onedev->query($sql);
			}
			
			foreach($details['Pemeriksaan Dokter'] as $k => $v){
				$sql = "INSERT INTO mcu_resumedetails(
							Mcu_ResumeDetailsMcu_ResumeID,
							Mcu_ResumeDetailsCategory,
							Mcu_ResumeDetailsT_OrderDetailID,
							Mcu_ResumeDetailsT_TestID,
							Mcu_ResumeDetailsM_LangID,
							Mcu_ResumeDetailsLangIsSI,
							Mcu_ResumeDetailsResult,
							Mcu_ResumeDetailsCreated,
							Mcu_ResumeDetailsUserID
						)
						VALUES(
							{$re_id},
							'{$v['category']}',
							{$v['orderdetail_id']},
							{$v['test_id']},
							{$prm['trx']['lang_id']},
							'{$prm['trx']['lang_is_si']}',
							'{$v['result']}',
							NOW(),
							{$userid}
						)
						ON DUPLICATE KEY UPDATE 
							Mcu_ResumeDetailsResult = '{$v['result']}',
							Mcu_ResumeDetailsUserID = {$userid},
							Mcu_ResumeDetailsIsActive = 'Y'";
				$this->db_onedev->query($sql);
			}
		}
		
		if($prm['act'] == 'val1'){
			$sql = "UPDATE mcu_resume SET 
						Mcu_ResumeVerification = 'Y',
						Mcu_ResumeStatus = 'VAL1',
						Mcu_ResumeVerificationUserID = {$userid},
						Mcu_ResumeVerificationDateTime = NOW(),
						Mcu_ResumeUserID = {$userid}
					WHERE
						Mcu_ResumeID = {$re_id}
					";
			$this->db_onedev->query($sql);
		}
		
		if($prm['act'] == 'unval1'){
			$sql = "UPDATE mcu_resume SET 
						Mcu_ResumeVerification = 'N',
						Mcu_ResumeStatus = 'NEW',
						Mcu_ResumeVerificationUserID = 0,
						Mcu_ResumeVerificationDateTime = NULL,
						Mcu_ResumeUserID = {$userid}
					WHERE
						Mcu_ResumeID = {$re_id}
					";
			$this->db_onedev->query($sql);
		}
		
		
		
		$result = array(
			"total" => 1 , 
			"records" => array('status'=>'OK')
		); 
		$this->sys_ok($result);
		exit;
	}
	
	
	
	
	
   function deletetrx(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$userid = $this->sys_user["M_UserID"];
		
		$query ="UPDATE so_walklettercourier SET
					So_WalkLetterCourierIsActive = 'N',
					So_WalkLetterCourierUserID = '{$userid}'
				WHERE
					So_WalkLetterCourierID = {$prm['trx_id']}
			";
		//echo $query;
		$saveheader = $this->db_onedev->query($query);
		$last_id = $prm['trx_id'];
		
		$sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID = {$last_id}";
		$data_log_header = $this->db_onedev->query($sql)->result();
		$sql = "SELECT * FROM so_resultentrydetail WHERE So_ResultEntryDetailSo_ResultEntryID = {$last_id}";
		$data_log_details = $this->db_onedev->query($sql)->result();
		
		$data_log = json_encode(array('header'=>$data_log_header,'details'=>$data_log_details));
		$sql = "INSERT INTO one_log.log_resultentry_so (
					Log_ResultEntrySoDate,
					Log_ResultEntrySoJSON,
					Log_ResultEntrySoUserID
				)
				VALUES(
					NOW(),
					'{$data_log}',
					{$userid}
				)";
		//echo $sql;
		$this->db_onedev->query($sql);
		
		$result = array(
			"total" => 1 , 
			"records" => array('status'=>'OK'),
			"numbering" => $prm['trx_numbering'],
			"id" => $prm['trx_id']
		); 
		$this->sys_ok($result);
		exit;
	}
	
	
	function gettemplate(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$userid = $this->sys_user["M_UserID"];
		$rst = array();
		
		$sql = "SELECT So_TemplateLabelID as id, So_TemplateLabelName as label, '' as details
					FROM so_templatelabel
					WHERE
					So_TemplateLabelM_DoctorID = {$prm['doctor_id']} AND
					So_TemplateLabelT_TestID = {$prm['test_id']} AND 
					So_TemplateLabelSo_TemplateID = {$prm['template_id']} AND
					So_TemplateLabelIsActive = 'Y'";
		//echo $sql;
		$rst = $this->db_onedev->query($sql)->result();
		
		if(!$rst){
			$sql = "SELECT So_TemplateLabelID as id, So_TemplateLabelName as label, '' as details
					FROM so_templatelabel
					WHERE
					So_TemplateLabelM_DoctorID = 0 AND
					So_TemplateLabelT_TestID = {$prm['test_id']} AND 
					So_TemplateLabelSo_TemplateID = {$prm['template_id']} AND
					So_TemplateLabelIsActive = 'Y'";
			$rst = $this->db_onedev->query($sql)->result();
		}
		
		if($rst){
			foreach($rst as $k => $v){
				$sql = "SELECT so_templatevalueid as id, So_TemplateValueText as value, So_TemplateValueSo_TemplateDetailID as template_detail_id
						FROM so_templatevalue
						JOIN so_templatedetail ON So_TemplateValueSo_TemplateDetailID = So_TemplateDetailID AND
						 So_TemplateDetailM_LangID = {$prm['language_id']}
						WHERE
						So_TemplateValueSo_TemplateLabelID = {$v->id} AND So_TemplateValueIsActive = 'Y' ";
				//echo $sql;
				$v->details = $this->db_onedev->query($sql)->result();
			}
		}
		
		$result = array(
			"total" => 1 , 
			"records" => $rst
		); 
		$this->sys_ok($result);
		exit;
	}
	
	function printcount(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$userid = $this->sys_user["M_UserID"];
		$trx_id = $prm["trx_id"];
		$sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID = '{$trx_id}'";
		$orderdetail_id = $this->db_onedev->query($sql)->row()->So_ResultEntryT_OrderDetailID;
		
		$sql = "UPDATE t_orderdetail SET T_OrderDetailPrintCount = T_OrderDetailPrintCount + 1 WHERE T_OrderDetailID = '{$orderdetail_id}'";
		$this->db_onedev->query($sql);
		$result = array(
			"total" => 1 , 
			"records" => $prm
		); 
		$this->sys_ok($result);
		exit;
	}
	
	function getrstbylang(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$x_langid = $prm['lang']['id'];
		$x_reid = $prm['detail']['trx_id'];
		$sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID  = '{$x_reid}'";
		//echo $sql;
		$re_langid = $this->db_onedev->query($sql)->row()->So_ResultEntryM_LangID;
		if($x_langid == $re_langid){
			$sql = 	"SELECT 
					So_ResultEntryDetailID as trx_id,
					So_ResultEntryDetailSo_TemplateDetailID as template_detail_id,
					So_TemplateDetailName as result_label,
					IFNULL(So_ResultEntryDetailResult,'') as result_value
				FROM so_resultentrydetail
				JOIN so_templatedetail ON So_TemplateDetailID = So_ResultEntryDetailSo_TemplateDetailID
				JOIN so_resultentry ON So_ResultEntryDetailSo_ResultEntryID = So_ResultEntryID AND So_ResultEntryM_LangID = {$x_langid}
				WHERE
				So_ResultEntryDetailSo_ResultEntryID = {$x_reid} AND So_ResultEntryDetailisActive = 'Y'
				";
		}else{
			$sql = 	"
				SELECT 
					IFNULL(So_ResultEntryDetailOtherID,0) as trx_id,
					So_TemplateDetailID as template_detail_id,
					So_TemplateDetailName as result_label,
					So_ResultEntryDetailOtherResult as result_value
				FROM so_resultentry
				JOIN t_orderdetail ON T_OrderDetailID = So_ResultEntryT_OrderDetailID
				JOIN so_testtemplate ON So_TestTemplateT_TestID = T_OrderDetailT_TestID
				JOIN so_templatedetail ON So_TemplateDetailSo_TemplateID = So_TestTemplateSo_TemplateID AND So_TemplateDetailM_LangID = {$x_langid}
				LEFT JOIN so_resultentrydetail_other ON So_ResultEntryDetailOtherM_LangID = So_TemplateDetailM_LangID AND
					So_ResultEntryDetailOtherSo_ResultEntryID = So_ResultEntryID AND
					So_ResultEntryDetailOtherSo_TemplateDetailID = So_TemplateDetailID AND
					So_ResultEntryDetailOtherIsActive = 'Y'
				WHERE
				So_ResultEntryID = {$x_reid} AND So_ResultEntryIsActive = 'Y'
				";
		}
		
		//echo $sql;
		$rst = $this->db_onedev->query($sql)->result_array();
		$result = array(
			"total" => 1 , 
			"records" => $rst
		); 
		$this->sys_ok($result);
		exit;
	}
	
    
	function save_flagprint(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		
		$rst_data = array('status'=>'OK');
		
		$prm = $this->sys_input;
		$row = $prm['row'];
		$selected_trx = $prm['selected_trx'];
		$userid = $this->sys_user["M_UserID"];
		$sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID  = '{$selected_trx['re_id']}'";
		//echo $sql;
		$re_langid = $this->db_onedev->query($sql)->row()->So_ResultEntryM_LangID;
		if($re_langid == $prm['selected_trx']['language_id']){
			$sql = "UPDATE so_resultentrydetail SET 
						So_ResultEntryDetailFlagPrint = '{$row['flag_print']}', 
						So_ResultEntryDetailUserID = {$userid}
					WHERE So_ResultEntryDetailID = {$row['trx_id']}";
			//echo $sql;
			$this->db_onedev->query($sql);
		}
		else{
			$sql = "UPDATE so_resultentrydetail_other SET 
						So_ResultEntryDetailOtherFlagPrint = '{$row['flag_print']}', 
						So_ResultEntryDetailOtherUserID = {$userid}
					WHERE So_ResultEntryDetailOtherID = {$row['trx_id']}";
			//echo $sql;
			$this->db_onedev->query($sql);
		}
		
		
		$result = array(
			"total" => 1 , 
			"records" => $rst_data
		); 
		$this->sys_ok($result);
		
		exit;
	}
	
	function gethistory(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		
		$rst_data = array('status'=>'OK');
		
		$prm = $this->sys_input;
		$patientid = $prm['patientid'];
		$orderid = $prm['orderid'];
		$sql = "SELECT 
				T_OrderHeaderM_PatientID as patientid,
				T_OrderHeaderID as orderid,
				T_OrderHeaderLabNumber as noreg,
				date_format(T_OrderHeaderDate,'%d-%m-%Y') as order_date,
				T_OrderHeaderM_PatientAge as age, 
				GROUP_CONCAT(T_TestName separator ',') as tests
				FROM t_orderheader
				JOIN t_orderdetail ON T_OrderDetailT_OrderHeaderID = T_OrderHeaderID AND 
				T_OrderDetailIsActive = 'Y'
				JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND 
				T_OrderDetailT_TestIsResult = 'Y' AND 
				T_TestIsNonLab <> ''
				WHERE 
				T_OrderHeaderM_PatientID = {$patientid} AND 
				T_OrderHeaderID < {$orderid} AND
				T_OrderHeaderIsActive = 'Y'
				GROUP BY T_OrderHeaderID";
		
		$result = array(
			"total" => 1 , 
			"records" => $rst_data
		); 
		$this->sys_ok($result);
		
		exit;
	}
	
	function search_histories()
   {
		$prm = $this->sys_input;
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}

		$search = $prm["search"];
		$patientid = $prm['patientid'];
		$orderid = $prm['orderid'];
	  
		if(!isset($prm['current_page']))
			$prm['current_page'] = 1;
	  
		$sql_where = "";
		$number_limit = 10;
		$number_offset = ($prm['current_page'] - 1) * $number_limit ;
   
		if ($search != "") {
			$sql_where = "";
		}

		$sql = "	SELECT count(*) as total
				FROM (
					SELECT *
					FROM t_orderheader
					JOIN t_orderdetail ON T_OrderDetailT_OrderHeaderID = T_OrderHeaderID AND 
						T_OrderDetailIsActive = 'Y'
						JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND 
						T_OrderDetailT_TestIsResult = 'Y' AND 
						T_TestIsNonLab <> ''
					WHERE 
						T_OrderHeaderM_PatientID = {$patientid} AND 
						T_OrderHeaderID < {$orderid} AND
						T_OrderHeaderIsActive = 'Y'
					GROUP BY T_OrderHeaderID
				) x
				";
		//echo $sql;
		$query = $this->db_onedev->query($sql);

		$tot_count = 0;
		$tot_page = 0;
		if ($query) {
			$tot_count = $query->result_array()[0]["total"];
			$tot_page = ceil($tot_count/$number_limit);
		} else {
			$this->sys_error_db("t_samplestorageout count", $this->db_onedev);
			exit;
		}  
	  
	  
		$sql = 	"SELECT 
					T_OrderHeaderM_PatientID as patientid,
					T_OrderHeaderID as orderid,
					T_OrderHeaderLabNumber as noreg,
					date_format(T_OrderHeaderDate,'%d-%m-%Y') as order_date,
					T_OrderHeaderM_PatientAge as age, 
					GROUP_CONCAT(T_TestName separator ',') as tests
				FROM t_orderheader
				JOIN t_orderdetail ON T_OrderDetailT_OrderHeaderID = T_OrderHeaderID AND 
					T_OrderDetailValidation = 'Y' AND
					T_OrderDetailIsActive = 'Y'
					JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND 
					T_OrderDetailT_TestIsResult = 'Y' AND 
					T_TestIsNonLab <> ''
				WHERE 
					T_OrderHeaderM_PatientID = {$patientid} AND 
					T_OrderHeaderID < {$orderid} AND
					T_OrderHeaderIsActive = 'Y'
				GROUP BY T_OrderHeaderID
				ORDER BY T_OrderHeaderID DESC
				limit $number_limit offset $number_offset";
		//echo $sql;
		$query = $this->db_onedev->query($sql);
		$rows = $query->result_array();
		//echo $this->db_onedev->last_query();
		
		if($rows){
			foreach($rows as $k => $v){	
				$sql = 	"SELECT 
							So_ResultEntryID as trx_id,
							T_OrderDetailT_OrderHeaderID as orderid,
							UPPER(T_TestName) as test_name,
							T_TestID as test_id,
							M_LangID as language_id,
							M_LangName as language_name,
							CONCAT(M_DoctorPrefix,M_DoctorPrefix2,' ',M_DoctorName,'...') as doctor_fullname,
							'' as details,
							'N' as xshow
						FROM  so_resultentry
						JOIN t_orderdetail ON T_OrderDetailID = So_ResultEntryT_OrderDetailID AND T_OrderDetailIsActive = 'Y'
						JOIN t_orderheader ON So_ResultEntryT_OrderHeaderID = T_OrderHeaderID
						JOIN t_test ON T_OrderDetailT_TestID = T_TestID
						JOIN t_samplingso ON T_SamplingSoT_OrderHeaderID = T_OrderDetailT_OrderHeaderID AND 
							T_SamplingSoT_TestID = T_TestID
						JOIN m_doctor ON T_SamplingSoM_DoctorID = M_DoctorID
						JOIN m_lang ON So_ResultEntryM_LangID = M_LangID
						WHERE 
							So_ResultEntryT_OrderHeaderID = {$v['orderid']} AND So_ResultEntryValidation2 = 'Y'
						GROUP BY So_ResultEntryID
						";
				//echo $sql;
				$rst_details = $this->db_onedev->query($sql)->result_array();
				foreach($rst_details as $ki => $vi){	
					$sql = 	"SELECT 
								So_ResultEntryDetailID as trx_id,
								So_ResultEntryDetailSo_TemplateDetailID as template_detail_id,
								So_TemplateDetailName as result_label,
								So_ResultEntryDetailResult as result_value
							FROM so_resultentrydetail
							JOIN so_templatedetail ON So_TemplateDetailID = So_ResultEntryDetailSo_TemplateDetailID
							WHERE
							So_ResultEntryDetailSo_ResultEntryID = {$vi['trx_id']} AND So_ResultEntryDetailisActive = 'Y'";
					//echo $sql;
					$rst_details[$ki]['details'] = $this->db_onedev->query($sql)->result_array();
				}
				$rows[$k]['details'] = $rst_details;
			}
		}
	  
		$result = array("total" => $tot_page, "records" => $rows, "sql"=> $this->db_onedev->last_query());
		$this->sys_ok($result);
		exit;
   }
   
}