<?php
class Physic extends MY_Controller
{
   var $db_onedev;
   public function index()
   {
      echo "Physic API";
		/*
		truncate t_orderphysic_allergy;
		truncate t_orderphysic_chestabdomen;
		truncate t_orderphysic_complaintnote;
		truncate t_orderphysic_conclusion;
		truncate t_orderphysic_drugconsumption;

		truncate t_orderphysic_eyes;
		truncate t_orderphysic_generalcondition;
		truncate t_orderphysic_lifestyle;

		truncate t_orderphysic_medicalhistory;
		truncate t_orderphysic_nerve;
		truncate t_orderphysic_suggestion;

		truncate t_orderphysic_tht;
		truncate t_orderphysic_tooth;
		*/
   }
   
   public function __construct()
   {
      parent::__construct();
      $this->db_onedev = $this->load->database("onedev", true);
	  $this->load->helper(array('form', 'url'));
   }
   
   
   public function search()
   {
      $prm = $this->sys_input;
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}

      $search = $prm["namelab"];
	  $status = $prm["stationid"];
	  $startdate = $prm["startdate"];
	  $enddate = $prm["enddate"];
	  
	  $sql_where = "WHERE T_OrderPhysicStatus = '{$status}' AND ( T_OrderHeaderDate BETWEEN '{$startdate} 00:00:00' AND '{$enddate} 23:59:59' ) AND T_OrderPhysicIsActive = 'Y'";
	  
      //$sql_param = array();
      if ($search != "") {
         if ($sql_where != "") {
            $sql_where .=" and ";
         }
         $sql_where .= " ( T_OrderHeaderLabNumber like '%$search%' OR M_PatientName like '%$search%' ) ";
      }

		$number_limit = 10;
		$number_offset = ($prm['current_page'] - 1) * $number_limit ;
      $sql = "	SELECT count(*) as total
				FROM t_orderphysic	
				JOIN t_orderheader ON T_OrderPhysicT_OrderHeaderID = T_OrderHeaderID
				JOIN m_company ON T_OrderHeaderM_CompanyID = M_CompanyID
				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 m_doctor ON T_OrderPhysicM_DoctorID = M_DoctorID 
				$sql_where
				";
		//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_orderphysic count", $this->db_onedev);
			exit;
		}   
	  
		$sql = 	"SELECT 
					T_OrderPhysicID as trx_id,
					T_OrderHeaderID as orderid,
					T_OrderPhysicCode as code,
					T_OrderHeaderLabNumber as ordernumber,
					CONCAT(M_TitleName,' ',M_PatientName) as patient_fullname,
					UPPER(M_SexName) as sexname,
					M_CompanyName as companyname,
					M_CompanyAddress as companyaddress,
					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_DoctorID as doctor_id,
					CONCAT(M_DoctorPrefix,' ',UPPER(M_DoctorName),' ',M_DoctorSufix) as doctor_fullname,
					'' as details,
					CASE
						WHEN T_OrderPhysicStatus = 'NEW' THEN 'BARU'
						WHEN T_OrderPhysicStatus = 'VER'  THEN 'VERIFIKASI'
						WHEN T_OrderPhysicStatus = 'VAL'  THEN 'VALIDASI'
					END as status_name,
					T_OrderPhysicStatus as status
				FROM t_orderphysic	
				JOIN t_orderheader ON T_OrderPhysicT_OrderHeaderID = T_OrderHeaderID
				JOIN m_company ON T_OrderHeaderM_CompanyID = M_CompanyID
				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 m_doctor ON T_OrderPhysicM_DoctorID = M_DoctorID 
				$sql_where
				GROUP BY T_OrderHeaderID
				ORDER BY T_OrderHeaderID ASC
				limit $number_limit offset $number_offset";
		//echo $sql;
		//v-bind:class="backgroundInp(tooth.value)"
		$query = $this->db_onedev->query($sql);
		$rows = $query->result_array();
		if($rows){
			foreach($rows as $k => $v){	
				$details = array();
				$types = explode("+",$v['code']);
				foreach($types as $ki=>$vi){
					//$details['pasien'] = array();
					//$details['doctor'] = array();
					if($vi == 'DFLT'){
						$sql = "SELECT T_OrderPhysicComplaintNoteValue as value 
						FROM t_orderphysic_complaintnote 
						WHERE 
						T_OrderPhysicComplaintNoteT_OrderPhysicID = '{$v['trx_id']}' AND
						T_OrderPhysicComplaintNoteIsActive = 'Y'";
						$rows[$k]['details']['complaint'] = $this->db_onedev->query($sql)->row()->value;
						$rows[$k]['details']['medicalhistory'] = $this->getmedicalhistory($v['orderid']);
						$rows[$k]['details']['allergy'] = $this->getfromsp('sp_physic_dflt_get_allergy',$v['orderid']);
						$rows[$k]['details']['drugconsumption'] = $this->getfromsp('sp_physic_dflt_get_drugconsumption',$v['orderid']);
						$rows[$k]['details']['lifestyle'] = $this->getfromsp('sp_physic_dflt_get_lifestyle',$v['orderid']);
						$rows[$k]['details']['vitalsign'] = $this->getvitalsign($v['orderid']);
						$rows[$k]['details']['generalcondition'] = $this->getfromsp('sp_physic_dflt_get_generalcondition',$v['orderid']);
						$rows[$k]['details']['eyes'] = $this->getfromsp('sp_physic_dflt_get_eyes',$v['orderid']);
						$rows[$k]['details']['tooth'] = $this->getfromsp('sp_physic_dflt_get_tooth',$v['orderid']);
						$rows[$k]['details']['tht'] = $this->getfromsp('sp_physic_dflt_get_tht',$v['orderid']);
						$rows[$k]['details']['chestabdomen'] = $this->getfromsp('sp_physic_dflt_get_chestabdomen',$v['orderid']);
						$rows[$k]['details']['nerve'] = $this->getfromsp('sp_physic_dflt_get_nerve',$v['orderid']);
						$sql = "SELECT T_OrderPhysicConclusionValue as value 
								FROM t_orderphysic_conclusion 
								WHERE 
								T_OrderPhysicConclusionT_OrderPhysicID = '{$v['trx_id']}' AND
								T_OrderPhysicConclusionIsActive = 'Y'";
						$rows[$k]['details']['conslusion'] = $this->db_onedev->query($sql)->row()->value;
						$sql = "SELECT T_OrderPhysicSuggestionValue as value 
								FROM t_orderphysic_suggestion 
								WHERE 
								T_OrderPhysicSuggestionT_OrderPhysicID = '{$v['trx_id']}' AND
								T_OrderPhysicSuggestionIsActive = 'Y'";
						$rows[$k]['details']['suggestion'] = $this->db_onedev->query($sql)->row()->value;
					}	
					if($vi == 'K3'){
						$rows[$k]['details']['workplacehazards'] = $this->getfromsp('sp_physic_k3_workplace_hazards',$v['orderid']);
						$rows[$k]['details']['workplaceaccident'] = $this->getworkplaceaccident($v['orderid']);
					}
				}

			}
		}
	  
	  
		//$this->_add_address($rows);
		$result = array("total" => $tot_count, "records" => $rows, "sql"=> $this->db_onedev->last_query());
		$this->sys_ok($result);
		exit;
   }
   
   function temp_default(){
	   
   }
   
   public function search_old()
   {
      $prm = $this->sys_input;
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}

      $search = $prm["namelab"];
	  $status = $prm["stationid"];
	  $startdate = $prm["startdate"];
	  $enddate = $prm["enddate"];


	 
	  
	  
	  $sql_where = "WHERE T_OrderPhysicStatus = '{$status}' AND ( T_OrderHeaderDate BETWEEN '{$startdate} 00:00:00' AND '{$enddate} 23:59:59' ) AND T_OrderPhysicIsActive = 'Y'";
	  
      //$sql_param = array();
      if ($search != "") {
         if ($sql_where != "") {
            $sql_where .=" and ";
         }
         $sql_where .= " ( T_OrderHeaderLabNumber like '%$search%' OR M_PatientName like '%$search%' ) ";
      }

		$number_limit = 10;
		$number_offset = ($prm['current_page'] - 1) * $number_limit ;
      $sql = "	SELECT count(*) as total
				FROM t_orderphysic	
				JOIN t_orderheader ON T_OrderPhysicT_OrderHeaderID = T_OrderHeaderID
				JOIN m_company ON T_OrderHeaderM_CompanyID = M_CompanyID
				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 m_doctor ON T_OrderPhysicM_DoctorID = M_DoctorID 
				$sql_where
				";
		//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_orderphysic count", $this->db_onedev);
			exit;
		}   
	  
		$sql = 	"SELECT 
					T_OrderPhysicID as trx_id,
					T_OrderHeaderID as orderid,
					T_OrderHeaderLabNumber as ordernumber,
					CONCAT(M_TitleName,' ',M_PatientName) as patient_fullname,
					UPPER(M_SexName) as sexname,
					M_CompanyName as companyname,
					M_CompanyAddress as companyaddress,
					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_DoctorID as doctor_id,
					CONCAT(M_DoctorPrefix,' ',UPPER(M_DoctorName),' ',M_DoctorSufix) as doctor_fullname,
					'' as details,
					CASE
						WHEN T_OrderPhysicStatus = 'NEW' THEN 'BARU'
						WHEN T_OrderPhysicStatus = 'VER'  THEN 'VERIFIKASI'
						WHEN T_OrderPhysicStatus = 'VAL'  THEN 'VALIDASI'
					END as status_name,
					T_OrderPhysicStatus as status
				FROM t_orderphysic	
				JOIN t_orderheader ON T_OrderPhysicT_OrderHeaderID = T_OrderHeaderID
				JOIN m_company ON T_OrderHeaderM_CompanyID = M_CompanyID
				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 m_doctor ON T_OrderPhysicM_DoctorID = M_DoctorID 
				$sql_where
				GROUP BY T_OrderHeaderID
				ORDER BY T_OrderHeaderID ASC
				limit $number_limit offset $number_offset";
		//echo $sql;
		//v-bind:class="backgroundInp(tooth.value)"
		$query = $this->db_onedev->query($sql);
		$rows = $query->result_array();
		if($rows){
			foreach($rows as $k => $v){	
				$sql = "SELECT T_OrderPhysicComplaintNoteValue as value 
						FROM t_orderphysic_complaintnote 
						WHERE 
						T_OrderPhysicComplaintNoteT_OrderPhysicID = '{$v['trx_id']}' AND
						T_OrderPhysicComplaintNoteIsActive = 'Y'";
				$rst_complaint = $this->db_onedev->query($sql)->row()->value;
				$rst_medicalhistory = $this->getmedicalhistory($v['orderid']);
				$rst_allergy = $this->getfromsp('sp_physic_dflt_get_allergy',$v['orderid']);
				$rst_drugconsumption = $this->getfromsp('sp_physic_dflt_get_drugconsumption',$v['orderid']);
				$rst_lifestyle = $this->getfromsp('sp_physic_dflt_get_lifestyle',$v['orderid']);
				$rst_vitalsign = $this->getvitalsign($v['orderid']);
				$rst_generalcondition = $this->getfromsp('sp_physic_dflt_get_generalcondition',$v['orderid']);
				$rst_eyes = $this->getfromsp('sp_physic_dflt_get_eyes',$v['orderid']);
				$rst_tooth = $this->getfromsp('sp_physic_dflt_get_tooth',$v['orderid']);
				$rst_tht = $this->getfromsp('sp_physic_dflt_get_tht',$v['orderid']);
				$rst_chestabdomen = $this->getfromsp('sp_physic_dflt_get_chestabdomen',$v['orderid']);
				$rst_nerve = $this->getfromsp('sp_physic_dflt_get_nerve',$v['orderid']);
				$sql = "SELECT T_OrderPhysicConclusionValue as value 
						FROM t_orderphysic_conclusion 
						WHERE 
						T_OrderPhysicConclusionT_OrderPhysicID = '{$v['trx_id']}' AND
						T_OrderPhysicConclusionIsActive = 'Y'";
				$rst_conclusion = $this->db_onedev->query($sql)->row()->value;
				$sql = "SELECT T_OrderPhysicSuggestionValue as value 
						FROM t_orderphysic_suggestion 
						WHERE 
						T_OrderPhysicSuggestionT_OrderPhysicID = '{$v['trx_id']}' AND
						T_OrderPhysicSuggestionIsActive = 'Y'";
				$rst_suggestion = $this->db_onedev->query($sql)->row()->value;
				$rows[$k]['details'] = array(
					'complaint'=>$rst_complaint,
					'medicalhistory'=>$rst_medicalhistory,
					'allergy'=>$rst_allergy,
					'drugconsumption'=>$rst_drugconsumption,
					'lifestyle'=>$rst_lifestyle,
					'vitalsign'=>$rst_vitalsign,
					'generalcondition'=>$rst_generalcondition,
					'eyes'=>$rst_eyes,
					'tooth'=>$rst_tooth,
					'tht'=>$rst_tht,
					'chestabdomen'=>$rst_chestabdomen,
					'nerve'=>$rst_nerve,
					'conslusion'=>$rst_conclusion,
					'suggestion'=>$rst_suggestion
				);
			}
		}
	  
	  
		//$this->_add_address($rows);
		$result = array("total" => $tot_count, "records" => $rows, "sql"=> $this->db_onedev->last_query());
		$this->sys_ok($result);
		exit;
   }
   
   function getmedicalhistory($orderid){
		$sql = "CALL `sp_physic_dflt_get_medicalhistory`('{$orderid}')";
		$r = $this->db_onedev->query($sql)->result();
		$this->clean_mysqli_connection($this->db_onedev->conn_id);
		$data_return = array();
		if($r){
			$i = 1;
			$tem_arr = array();
			foreach($r as $k => $v){
				array_push($tem_arr,$v);
				if($i == 2){
					array_push($data_return,$tem_arr);
					$tem_arr = array();
					$i = 0;
				}
				$i++;
			}
		}
		return $data_return;
   }
   
   function getworkplaceaccident($orderid){
		$sql = "CALL `sp_physic_k3_workplace_accident`('{$orderid}')";
		//echo $sql;
		$r = $this->db_onedev->query($sql)->result();
		$this->clean_mysqli_connection($this->db_onedev->conn_id);
		$data_return = array();
		if($r){
			$i = 1;
			$tem_arr = array();
			foreach($r as $k => $v){
				array_push($tem_arr,$v);
				if($i == 2){
					array_push($data_return,$tem_arr);
					$tem_arr = array();
					$i = 0;
				}
				$i++;
			}
		}
		return $data_return;
   }
   
   function getvitalsign($orderid){
		$sql = "CALL `sp_physic_dflt_get_vitalsign`('{$orderid}')";
		$r = $this->db_onedev->query($sql)->result();
		$this->clean_mysqli_connection($this->db_onedev->conn_id);
		$data_return = array();
		if($r){
			$i = 1;
			$tem_arr = array();
			foreach($r as $k => $v){
				array_push($tem_arr,$v);
				if($i == 2){
					array_push($data_return,$tem_arr);
					$tem_arr = array();
					$i = 0;
				}
				$i++;
			}
		}
		return $data_return;
   }
   
   function getfromsp($spname,$orderid){
	   $sql = "CALL `{$spname}`('{$orderid}')";
		$r = $this->db_onedev->query($sql)->result();
		$this->clean_mysqli_connection($this->db_onedev->conn_id);
		
		return $r;
   }
   
   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 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 doaction(){
		if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
		}
		$prm = $this->sys_input;
		$details = $prm['details'];
		$userid = $this->sys_user["M_UserID"];
		if($prm['act'] === 'save'){
			$sql = "UPDATE t_orderphysic SET T_OrderPhysicUserID = '{$userid}', T_OrderPhysicLastUpdate = NOW() WHERE T_OrderPhysicID = {$prm['trx']['trx_id']}";
		}
		if($prm['act'] === 'ver'){
			$sql = "UPDATE t_orderphysic SET 
						T_OrderPhysicUserID = '{$userid}', 
						T_OrderPhysicLastUpdate = NOW(),
						T_OrderPhysicVerification = 'Y',
						T_OrderPhysicStatus = 'VER'
					WHERE T_OrderPhysicID = {$prm['trx']['trx_id']}";
		}
		if($prm['act'] === 'unver'){
			$sql = "UPDATE t_orderphysic SET 
						T_OrderPhysicUserID = '{$userid}', 
						T_OrderPhysicLastUpdate = NOW(),
						T_OrderPhysicVerification = 'N',
						T_OrderPhysicStatus = 'NEW'
					WHERE T_OrderPhysicID = {$prm['trx']['trx_id']}";
		}
		if($prm['act'] === 'val'){
			$sql = "UPDATE t_orderphysic SET 
						T_OrderPhysicUserID = '{$userid}', 
						T_OrderPhysicLastUpdate = NOW(),
						T_OrderPhysicValidation = 'Y',
						T_OrderPhysicStatus = 'VAL'
					WHERE T_OrderPhysicID = {$prm['trx']['trx_id']}";
		}
		if($prm['act'] === 'unval'){
			$sql = "UPDATE t_orderphysic SET 
						T_OrderPhysicUserID = '{$userid}', 
						T_OrderPhysicLastUpdate = NOW(),
						T_OrderPhysicValidation = 'N',
						T_OrderPhysicStatus = 'VER'
					WHERE T_OrderPhysicID = {$prm['trx']['trx_id']}";
		}
		
		$header_update = $this->db_onedev->query($sql);
		
		$workplacehazards = $details['workplacehazards'];
		foreach($workplacehazards as $k => $v){
			if($v['idx'] === '0' || $v['idx'] === 0){
				$sql = "INSERT INTO t_orderphysic_workplacehazards (
							T_OrderPhysicWorkPlaceHazardsT_OrderPhysicID,
							T_OrderPhysicWorkPlaceHazardsM_K3WorkPLaceHazardsID,
							T_OrderPhysicWorkPlaceHazardsHour,
							T_OrderPhysicWorkPlaceHazardsYear,
							T_OrderPhysicWorkPlaceHazardsUserID,
							T_OrderPhysicWorkPlaceHazardsCreated,
							T_OrderPhysicWorkPlaceHazardsLastUpdated
						)
						VALUES(
							'{$prm['trx']['trx_id']}',
							'{$v['id']}',
							'{$v['val_hour']}',
							'{$v['val_year']}',
							'{$userid}',
							NOW(),
							NOW()
						)";
						
				$x_ins = $this->db_onedev->query($sql);
				//echo $this->db_onedev->last_query();
			}
			else{
				$sql = 	"UPDATE t_orderphysic_workplacehazards SET
							T_OrderPhysicWorkPlaceHazardsT_OrderPhysicID = '{$prm['trx']['trx_id']}',
							T_OrderPhysicWorkPlaceHazardsM_K3WorkPLaceHazardsID = '{$v['id']}',
							T_OrderPhysicWorkPlaceHazardsHour = '{$v['val_hour']}',
							T_OrderPhysicWorkPlaceHazardsYear = '{$v['val_year']}',
							T_OrderPhysicWorkPlaceHazardsLastUpdated = NOW(),
							T_OrderPhysicWorkPlaceHazardsUserID = '{$userid}'
						WHERE
							T_OrderPhysicWorkPlaceHazardsID = '{$v['idx']}'
						";
				$x_upd = $this->db_onedev->query($sql);
			}
		}
		
		$workplaceaccident = $details['workplaceaccident'];
			foreach($workplaceaccident as $i => $vx){
				foreach($vx as $k => $v){
					if($v['idx'] === '0' || $v['idx'] === 0){
						$sql = "INSERT INTO t_orderphysic_workplaceaccident (
									T_OrderPhysicWorkPlaceAccidentT_OrderPhysicID,
									T_OrderPhysicWorkPlaceAccidentM_K3WorkPlazeAccidentID,
									T_OrderPhysicWorkPlaceAccidentValue,
									T_OrderPhysicWorkPlaceAccidentUserID,
									T_OrderPhysicWorkPlaceAccidentCreated,
									T_OrderPhysicWorkPlaceAccidentLastUpdated
								)
								VALUES(
									'{$prm['trx']['trx_id']}',
									'{$v['id']}',
									'{$v['value']}',
									'{$userid}',
									NOW(),
									NOW()
								)";
								
						$x_ins = $this->db_onedev->query($sql);
					}
					else{
						$sql = 	"UPDATE t_orderphysic_workplaceaccident SET
									T_OrderPhysicWorkPlaceAccidentT_OrderPhysicID = '{$prm['trx']['trx_id']}',
									T_OrderPhysicWorkPlaceAccidentM_K3WorkPlazeAccidentID = '{$v['id']}',
									T_OrderPhysicWorkPlaceAccidentValue = '{$v['value']}',
									T_OrderPhysicMedicalHistoryLastUpdated = NOW(),
									T_OrderPhysicWorkPlaceAccidentLastUpdated = '{$userid}'
								WHERE
									T_OrderPhysicMedicalHistoryID = '{$v['idx']}'
								";
						$x_upd = $this->db_onedev->query($sql);
					}
				}
			}
		
		$allergy = $details['allergy'];
		//print_r();
		foreach($allergy as $k => $v){
			if($v['idx'] === '0' || $v['idx'] === 0){
				$sql = "INSERT INTO t_orderphysic_allergy (
							T_OrderPhysicAllergyT_OrderPhysicID,
							T_OrderPhysicAllergyM_DFLT_AllergyID,
							T_OrderPhysicAllergyCheckbox,
							T_OrderPhysicAllergyValue,
							T_OrderPhysicAllergyUserID,
							T_OrderPhysicAllergyCreated,
							T_OrderPhysicAllergyLasUpdated
						)
						VALUES(
							'{$prm['trx']['trx_id']}',
							'{$v['id']}',
							'{$v['cbx']}',
							'{$v['value']}',
							'{$userid}',
							NOW(),
							NOW()
						)";
						
				$x_ins = $this->db_onedev->query($sql);
				//echo $this->db_onedev->last_query();
			}
			else{
				$sql = 	"UPDATE t_orderphysic_allergy SET
							T_OrderPhysicAllergyT_OrderPhysicID = '{$prm['trx']['trx_id']}',
							T_OrderPhysicAllergyM_DFLT_AllergyID = '{$v['id']}',
							T_OrderPhysicAllergyCheckbox = '{$v['cbx']}',
							T_OrderPhysicAllergyValue = '{$v['value']}',
							T_OrderPhysicAllergyLasUpdated = NOW(),
							T_OrderPhysicAllergyUserID = '{$userid}'
						WHERE
							T_OrderPhysicAllergyID = '{$v['idx']}'
						";
				$x_upd = $this->db_onedev->query($sql);
			}
		}
		
		$lifestyle = $details['lifestyle'];
		//print_r();
		foreach($lifestyle as $k => $v){
			if($v['idx'] === '0' || $v['idx'] === 0){
				$sql = "INSERT INTO t_orderphysic_lifestyle (
							T_OrderPhysicLifeStyleT_OrderPhysicID,
							T_OrderPhysicLifeStyleM_DFLT_LifeStyleID,
							T_OrderPhysicLifeStyleCheckbox,
							T_OrderPhysicLifeStyleValue,
							T_OrderPhysicLifeStyleUserID,
							T_OrderPhysicLifeStyleCreated,
							T_OrderPhysicLifeStyleLastUpdated
						)
						VALUES(
							'{$prm['trx']['trx_id']}',
							'{$v['id']}',
							'{$v['cbx']}',
							'{$v['value']}',
							'{$userid}',
							NOW(),
							NOW()
						)";
						
				$x_ins = $this->db_onedev->query($sql);
				//echo $this->db_onedev->last_query();
			}
			else{
				$sql = 	"UPDATE t_orderphysic_lifestyle SET
							T_OrderPhysicLifeStyleT_OrderPhysicID = '{$prm['trx']['trx_id']}',
							T_OrderPhysicLifeStyleM_DFLT_LifeStyleID = '{$v['id']}',
							T_OrderPhysicLifeStyleCheckbox = '{$v['cbx']}',
							T_OrderPhysicLifeStyleValue = '{$v['value']}',
							T_OrderPhysicLifeStyleLastUpdated = NOW(),
							T_OrderPhysicLifeStyleUserID = '{$userid}'
						WHERE
							T_OrderPhysicLifeStyleID = '{$v['idx']}'
						";
				$x_upd = $this->db_onedev->query($sql);
			}
		}
		
		$chestabdomen = $details['chestabdomen'];
		foreach($chestabdomen as $k => $v){
			if($v['idx'] === '0' || $v['idx'] === 0){
				$sql = "INSERT INTO t_orderphysic_chestabdomen (
							T_OrderPhysicChestAbdomenT_OrderPhysicID,
							T_OrderPhysicChestAbdomenM_DFLT_ChestAbdomenID,
							T_OrderPhysicChestAbdomenCheckboxN,
							T_OrderPhysicChestAbdomenCheckboxT,
							T_OrderPhysicChestAbdomenValue,
							T_OrderPhysicChestAbdomenUserID,
							T_OrderPhysicChestAbdomenCreated,
							T_OrderPhysicChestAbdomenLastUpdated
						)
						VALUES(
							'{$prm['trx']['trx_id']}',
							'{$v['id']}',
							'{$v['cbxN']}',
							'{$v['cbxT']}',
							'{$v['value']}',
							'{$userid}',
							NOW(),
							NOW()
						)";
						
				$x_ins = $this->db_onedev->query($sql);
			}
			else{
				$sql = 	"UPDATE t_orderphysic_chestabdomen SET
							T_OrderPhysicChestAbdomenT_OrderPhysicID = '{$prm['trx']['trx_id']}',
							T_OrderPhysicChestAbdomenM_DFLT_ChestAbdomenID = '{$v['id']}',
							T_OrderPhysicChestAbdomenCheckboxN = '{$v['cbxN']}',
							T_OrderPhysicChestAbdomenCheckboxT = '{$v['cbxT']}',
							T_OrderPhysicChestAbdomenValue = '{$v['value']}',
							T_OrderPhysicChestAbdomenLastUpdated = NOW(),
							T_OrderPhysicChestAbdomenUserID = '{$userid}'
						WHERE
							T_OrderPhysicChestAbdomenID = '{$v['idx']}'
						";
				$x_upd = $this->db_onedev->query($sql);
			}
		}	
			
			$drugconsumption = $details['drugconsumption'];
			foreach($drugconsumption as $k => $v){
				if($v['idx'] === '0' || $v['idx'] === 0){
					$sql = "INSERT INTO t_orderphysic_drugconsumption (
								T_OrderPhysicDrugConsumptionT_OrderPhysicID,
								T_OrderPhysicDrugConsumptionM_DFLT_DrugConsumptionID,
								T_OrderPhysicDrugConsumptionDose,
								T_OrderPhysicDrugConsumptionValue,
								T_OrderPhysicDrugConsumptionUserID,
								T_OrderPhysicDrugConsumptionCreated,
								T_OrderPhysicDrugConsumptionLastUpdated	
							)
							VALUES(
								'{$prm['trx']['trx_id']}',
								'{$v['id']}',
								'{$v['dose']}',
								'{$v['value']}',
								'{$userid}',
								NOW(),
								NOW()
							)";
							
					$x_ins = $this->db_onedev->query($sql);
				}
				else{
					$sql = 	"UPDATE t_orderphysic_drugconsumption SET
								T_OrderPhysicDrugConsumptionT_OrderPhysicID = '{$prm['trx']['trx_id']}',
								T_OrderPhysicDrugConsumptionM_DFLT_DrugConsumptionID = '{$v['id']}',
								T_OrderPhysicDrugConsumptionDose = '{$v['dose']}',
								T_OrderPhysicDrugConsumptionValue = '{$v['value']}',
								T_OrderPhysicDrugConsumptionLastUpdated = NOW(),
								T_OrderPhysicDrugConsumptionUserID = '{$userid}'
							WHERE
								T_OrderPhysicDrugConsumptionID = '{$v['idx']}'
							";
					$x_upd = $this->db_onedev->query($sql);
				}
			}
			
			$eyes = $details['eyes'];
			foreach($eyes as $k => $v){
				if($v['idx'] === '0' || $v['idx'] === 0){
					$sql = "INSERT INTO t_orderphysic_eyes (
								T_OrderPhysicEyesT_OrderPhysicID,
								T_OrderPhysicEyesM_DFLT_EyesID,
								T_OrderPhysicEyesCheckboxN,
								T_OrderPhysicEyesCheckboxT,
								T_OrderPhysicEyesValue,
								T_OrderPhysicEyesUserID,
								T_OrderPhysicEyesCreated,
								T_OrderPhysicEyesLastUpdated
							)
							VALUES(
								'{$prm['trx']['trx_id']}',
								'{$v['id']}',
								'{$v['cbxN']}',
								'{$v['cbxT']}',
								'{$v['value']}',
								'{$userid}',
								NOW(),
								NOW()
							)";
							
					$x_ins = $this->db_onedev->query($sql);
				}
				else{
					$sql = 	"UPDATE t_orderphysic_eyes SET
								T_OrderPhysicEyesT_OrderPhysicID = '{$prm['trx']['trx_id']}',
								T_OrderPhysicEyesM_DFLT_EyesID = '{$v['id']}',
								T_OrderPhysicEyesCheckboxN = '{$v['cbxN']}',
								T_OrderPhysicEyesCheckboxT = '{$v['cbxT']}',
								T_OrderPhysicEyesValue = '{$v['value']}',
								T_OrderPhysicEyesLastUpdated = NOW(),
								T_OrderPhysicEyesUserID = '{$userid}'
							WHERE
								T_OrderPhysicEyesID = '{$v['idx']}'
							";
					$x_upd = $this->db_onedev->query($sql);
				}
			}
			
			$generalcondition = $details['generalcondition'];
			foreach($generalcondition as $k => $v){
				if($v['idx'] === '0' || $v['idx'] === 0){
					$sql = "INSERT INTO t_orderphysic_generalcondition (
								T_OrderPhysicGeneralConditionT_OrderPhysicID,
								T_OrderPhysicGeneralConditionM_DFLT_GeneralConditionID,
								T_OrderPhysicGeneralConditionCheckboxY,
								T_OrderPhysicGeneralConditionCheckboxT,
								T_OrderPhysicGeneralConditionValue,
								T_OrderPhysicGeneralConditionUserID,
								T_OrderPhysicGeneralConditionCreated,
								T_OrderPhysicGeneralConditionLastUpdated
							)
							VALUES(
								'{$prm['trx']['trx_id']}',
								'{$v['id']}',
								'{$v['cbxY']}',
								'{$v['cbxT']}',
								'{$v['value']}',
								'{$userid}',
								NOW(),
								NOW()
							)";
							
					$x_ins = $this->db_onedev->query($sql);
				}
				else{
					$sql = 	"UPDATE t_orderphysic_generalcondition SET
								T_OrderPhysicGeneralConditionT_OrderPhysicID = '{$prm['trx']['trx_id']}',
								T_OrderPhysicGeneralConditionM_DFLT_GeneralConditionID = '{$v['id']}',
								T_OrderPhysicGeneralConditionCheckboxY = '{$v['cbxY']}',
								T_OrderPhysicGeneralConditionCheckboxT = '{$v['cbxT']}',
								T_OrderPhysicGeneralConditionValue = '{$v['value']}',
								T_OrderPhysicGeneralConditionLastUpdated = NOW(),
								T_OrderPhysicGeneralConditionUserID = '{$userid}'
							WHERE
								T_OrderPhysicGeneralConditionID = '{$v['idx']}'
							";
					$x_upd = $this->db_onedev->query($sql);
				}
			}
			
			$medicalhistory = $details['medicalhistory'];
			foreach($medicalhistory as $i => $vx){
				foreach($vx as $k => $v){
					if($v['idx'] === '0' || $v['idx'] === 0){
						$sql = "INSERT INTO t_orderphysic_medicalhistory (
									T_OrderPhysicMedicalHistoryT_OrderPhysicID,
									T_OrderPhysicMedicalHistoryM_DFLT_MedicalHistoryID,
									T_OrderPhysicMedicalHistoryCheckboxY,
									T_OrderPhysicMedicalHistoryCheckboxT,
									T_OrderPhysicMedicalHistoryValue,
									T_OrderPhysicMedicalHistoryUserID,
									T_OrderPhysicMedicalHistoryCreated,
									T_OrderPhysicMedicalHistoryLastUpdated
								)
								VALUES(
									'{$prm['trx']['trx_id']}',
									'{$v['id']}',
									'{$v['cbxY']}',
									'{$v['cbxT']}',
									'{$v['value']}',
									'{$userid}',
									NOW(),
									NOW()
								)";
								
						$x_ins = $this->db_onedev->query($sql);
					}
					else{
						$sql = 	"UPDATE t_orderphysic_medicalhistory SET
									T_OrderPhysicMedicalHistoryT_OrderPhysicID = '{$prm['trx']['trx_id']}',
									T_OrderPhysicMedicalHistoryM_DFLT_MedicalHistoryID = '{$v['id']}',
									T_OrderPhysicMedicalHistoryCheckboxY = '{$v['cbxY']}',
									T_OrderPhysicMedicalHistoryCheckboxT = '{$v['cbxT']}',
									T_OrderPhysicMedicalHistoryValue = '{$v['value']}',
									T_OrderPhysicMedicalHistoryLastUpdated = NOW(),
									T_OrderPhysicMedicalHistoryUserID = '{$userid}'
								WHERE
									T_OrderPhysicMedicalHistoryID = '{$v['idx']}'
								";
						$x_upd = $this->db_onedev->query($sql);
					}
				}
			}
			
			$nerve = $details['nerve'];
			foreach($nerve as $k => $v){
				if($v['idx'] === '0' || $v['idx'] === 0){
					$sql = "INSERT INTO t_orderphysic_nerve (
								T_OrderPhysicNerveT_OrderPhysicID,
								T_OrderPhysicNerveM_DFLT_NerveID,
								T_OrderPhysicNerveCheckboxN,
								T_OrderPhysicNerveCheckboxT,
								T_OrderPhysicNerveValue,
								T_OrderPhysicNerveUserID,
								T_OrderPhysicNerveCreated,
								T_OrderPhysicNerveLastUpdated
							)
							VALUES(
								'{$prm['trx']['trx_id']}',
								'{$v['id']}',
								'{$v['cbxN']}',
								'{$v['cbxT']}',
								'{$v['value']}',
								'{$userid}',
								NOW(),
								NOW()
							)";
							
					$x_ins = $this->db_onedev->query($sql);
				}
				else{
					$sql = 	"UPDATE t_orderphysic_nerve SET
								T_OrderPhysicNerveT_OrderPhysicID = '{$prm['trx']['trx_id']}',
								T_OrderPhysicNerveM_DFLT_NerveID = '{$v['id']}',
								T_OrderPhysicNerveCheckboxN = '{$v['cbxN']}',
								T_OrderPhysicNerveCheckboxT = '{$v['cbxT']}',
								T_OrderPhysicNerveValue = '{$v['value']}',
								T_OrderPhysicNerveLastUpdated = NOW(),
								T_OrderPhysicNerveUserID = '{$userid}'
							WHERE
								T_OrderPhysicNerveID = '{$v['idx']}'
							";
					$x_upd = $this->db_onedev->query($sql);
				}
			}
			
			$tht = $details['tht'];
			foreach($tht as $k => $v){
				if($v['idx'] === '0' || $v['idx'] === 0){
					$sql = "INSERT INTO t_orderphysic_tht (
								T_OrderPhysic_THTT_OrderPhysicID,
								T_OrderPhysic_THTM_DFLT_THTID,
								T_OrderPhysic_THTCheckboxN,
								T_OrderPhysic_THTCheckboxT,
								T_OrderPhysic_THTValue,
								T_OrderPhysic_THTUserID,
								T_OrderPhysic_THTCreated,
								T_OrderPhysic_THTLastUpdated
							)
							VALUES(
								'{$prm['trx']['trx_id']}',
								'{$v['id']}',
								'{$v['cbxN']}',
								'{$v['cbxT']}',
								'{$v['value']}',
								'{$userid}',
								NOW(),
								NOW()
							)";
							
					$x_ins = $this->db_onedev->query($sql);
				}
				else{
					$sql = 	"UPDATE t_orderphysic_tht SET
								T_OrderPhysic_THTT_OrderPhysicID = '{$prm['trx']['trx_id']}',
								T_OrderPhysic_THTM_DFLT_THTID = '{$v['id']}',
								T_OrderPhysic_THTCheckboxN = '{$v['cbxN']}',
								T_OrderPhysic_THTCheckboxT = '{$v['cbxT']}',
								T_OrderPhysic_THTValue = '{$v['value']}',
								T_OrderPhysic_THTLastUpdated = NOW(),
								T_OrderPhysic_THTUserID = '{$userid}'
							WHERE
								T_OrderPhysic_THTID = '{$v['idx']}'
							";
					$x_upd = $this->db_onedev->query($sql);
				}
			}
			
			$tooth = $details['tooth'];
			foreach($tooth as $k => $v){
				if($v['idx'] === '0' || $v['idx'] === 0){
					$sql = "INSERT INTO t_orderphysic_tooth (
								T_OrderPhysicToothT_OrderPhysicID,
								T_OrderPhysicToothM_DFLT_ToothID,
								T_OrderPhysicToothValue,
								T_OrderPhysicToothUserID,
								T_OrderPhysicToothCreated,
								T_OrderPhysicToothLastUpdated
							)
							VALUES(
								'{$prm['trx']['trx_id']}',
								'{$v['id']}',
								'{$v['value']}',
								'{$userid}',
								NOW(),
								NOW()
							)";
							
					$x_ins = $this->db_onedev->query($sql);
				}
				else{
					$sql = 	"UPDATE t_orderphysic_tooth SET
								T_OrderPhysicToothT_OrderPhysicID = '{$prm['trx']['trx_id']}',
								T_OrderPhysicToothM_DFLT_ToothID = '{$v['id']}',
								T_OrderPhysicToothValue = '{$v['value']}',
								T_OrderPhysicToothLastUpdated = NOW(),
								T_OrderPhysicToothLastUpdated = '{$userid}'
							WHERE
								T_OrderPhysicToothID = '{$v['idx']}'
							";
					$x_upd = $this->db_onedev->query($sql);
				}
			}
			
			$vitalsign = $details['vitalsign'];
			foreach($vitalsign as $i => $vx){
				foreach($vx as $k => $v){
					if($v['idx'] === '0' || $v['idx'] === 0){
						$sql = "INSERT INTO t_orderpysic_vitalsign (
									T_OrderPhysicVitalSignT_OrderPhysicID,
									T_OrderPhysicVitalSignM_DFLT_VitalSignID,
									T_OrderPhysicVitalSignCheckbox1,
									T_OrderPhysicVitalSignCheckbox2,
									T_OrderPhysicVitalSignValue,
									T_OrderPhysicVitalSignUserID,
									T_OrderPhysicVitalSignCreated,
									T_OrderPhysicVitalSignLastUpdated
								)
								VALUES(
									'{$prm['trx']['trx_id']}',
									'{$v['id']}',
									'{$v['cbx1']}',
									'{$v['cbx2']}',
									'{$v['value']}',
									'{$userid}',
									NOW(),
									NOW()
								)";
								
						$x_ins = $this->db_onedev->query($sql);
					}
					else{
						$sql = 	"UPDATE t_orderpysic_vitalsign SET
									T_OrderPhysicVitalSignT_OrderPhysicID = '{$prm['trx']['trx_id']}',
									T_OrderPhysicVitalSignM_DFLT_VitalSignID = '{$v['id']}',
									T_OrderPhysicVitalSignCheckbox1 = '{$v['cbx1']}',
									T_OrderPhysicVitalSignCheckbox2 = '{$v['cbx2']}',
									T_OrderPhysicVitalSignValue = '{$v['value']}',
									T_OrderPhysicVitalSignLastUpdated = NOW(),
									T_OrderPhysicVitalSignUserID = '{$userid}'
								WHERE
									T_OrderPhysicVitalSignID = '{$v['idx']}'
								";
						$x_upd = $this->db_onedev->query($sql);
					}
				}
			}
			
			$idx_complaint = 0;
			$sql ="SELECT * FROM t_orderphysic_complaintnote WHERE T_OrderPhysicComplaintNoteT_OrderPhysicID = '{$prm['trx']['trx_id']}' AND T_OrderPhysicComplaintNoteIsActive = 'Y' ";
			$idx_complaint = $this->db_onedev->query($sql)->row()->T_OrderPhysicComplaintNoteID;
			
			if($idx_complaint == 0){
				$sql = "INSERT INTO t_orderphysic_complaintnote (
					T_OrderPhysicComplaintNoteT_OrderPhysicID,
					T_OrderPhysicComplaintNoteValue,
					T_OrderPhysicComplaintNoteCreated,
					T_OrderPhysicComplaintNoteLastUpdated,
					T_OrderPhysicComplaintNoteUserID
				)
				VALUES(
					'{$prm['trx']['trx_id']}',
					'{$prm['details']['complaint']}',
					NOW(),
					NOW(),
					'{$userid}'
				)";
				$x_ins = $this->db_onedev->query($sql);
			}
			else{
				$sql = 	"UPDATE t_orderphysic_complaintnote SET
									T_OrderPhysicComplaintNoteT_OrderPhysicID = '{$prm['trx']['trx_id']}',
									T_OrderPhysicComplaintNoteValue = '{$prm['details']['complaint']}',
									T_OrderPhysicComplaintNoteLastUpdated = NOW(),
									T_OrderPhysicComplaintNoteUserID = '{$userid}'
								WHERE
									T_OrderPhysicComplaintNoteID = '{$idx_complaint}'
								";
						$x_upd = $this->db_onedev->query($sql);
			}
			
			$idx_conclusion = 0;
			$sql ="SELECT * FROM t_orderphysic_conclusion WHERE T_OrderPhysicConclusionT_OrderPhysicID = '{$prm['trx']['trx_id']}' AND T_OrderPhysicConclusionIsActive = 'Y' ";
			$idx_conclusion = $this->db_onedev->query($sql)->row()->T_OrderPhysicConclusionID;
			
			if($idx_conclusion == 0){
				$sql = "INSERT INTO t_orderphysic_conclusion (
					T_OrderPhysicConclusionT_OrderPhysicID,
					T_OrderPhysicConclusionValue,
					T_OrderPhysicConclusionCreated,
					T_OrderPhysicConclusionLastUpdated,
					T_OrderPhysicConclusionUserID
				)
				VALUES(
					'{$prm['trx']['trx_id']}',
					'{$prm['details']['conslusion']}',
					NOW(),
					NOW(),
					'{$userid}'
				)";
				$x_ins = $this->db_onedev->query($sql);
			}
			else{
				$sql = 	"UPDATE t_orderphysic_conclusion SET
									T_OrderPhysicConclusionT_OrderPhysicID = '{$prm['trx']['trx_id']}',
									T_OrderPhysicConclusionValue = '{$prm['details']['conslusion']}',
									T_OrderPhysicConclusionLastUpdated = NOW(),
									T_OrderPhysicConclusionUserID = '{$userid}'
								WHERE
									T_OrderPhysicConclusionID = '{$idx_conclusion}'
								";
						$x_upd = $this->db_onedev->query($sql);
			}
		
			
			$idx_suggestion = 0;
			$sql ="SELECT * FROM t_orderphysic_suggestion WHERE T_OrderPhysicSuggestionT_OrderPhysicID = '{$prm['trx']['trx_id']}' AND T_OrderPhysicSuggestionIsActive = 'Y' ";
			$idx_suggestion = $this->db_onedev->query($sql)->row()->T_OrderPhysicSuggestionID;
			
			if($idx_suggestion == 0){
				$sql = "INSERT INTO t_orderphysic_suggestion (
					T_OrderPhysicSuggestionT_OrderPhysicID,
					T_OrderPhysicSuggestionValue,
					T_OrderPhysicSuggestionCreated,
					T_OrderPhysicSuggestionLastUpdated,
					T_OrderPhysicSuggestionUserID
				)
				VALUES(
					'{$prm['trx']['trx_id']}',
					'{$prm['details']['suggestion']}',
					NOW(),
					NOW(),
					'{$userid}'
				)";
				$x_ins = $this->db_onedev->query($sql);
			}
			else{
				$sql = 	"UPDATE t_orderphysic_suggestion SET
									T_OrderPhysicSuggestionT_OrderPhysicID = '{$prm['trx']['trx_id']}',
									T_OrderPhysicSuggestionValue = '{$prm['details']['suggestion']}',
									T_OrderPhysicSuggestionLastUpdated = NOW(),
									T_OrderPhysicSuggestionUserID = '{$userid}'
								WHERE
									T_OrderPhysicSuggestionID = '{$idx_suggestion}'
								";
						$x_upd = $this->db_onedev->query($sql);
			}
			
			
			
		$result = array(
			"total" => 1 , 
			"records" => array('status'=>'OK')
		); 
		$this->sys_ok($result);
		
		exit;
	}
	
   
   
}