";
		   $sql = "select t_orderheader.* from t_orderheader join t_orderheaderaddon on T_OrderHeaderID = T_OrderHeaderAddOnT_OrderHeaderID
			   where T_OrderHeaderLabNumber like ? or T_OrderHeaderAddonLabNumberOrigin like ?";
	   $qry = $this->db->query($sql, array("%" . $order . "%", "%{$order}%"));
	   if (! $qry) {
		   echo "ERR : \n" ;
		   print_r($this->db->error());
		   exit;
	   }
	   $rows = $qry->result_array();
	   foreach($rows as $r) {
		   echo "{$r['T_OrderHeaderID']}\t{$r['T_OrderHeaderDate']}\t{$r['T_OrderHeaderLabNumber']}\n";
	   }
   }
   function cek($headerID, $all=false) {
		   echo "
";
	   $sql ="select *
		   from t_ordersample 
		   join t_sampletype  on T_OrderSampleT_SampleTypeID = T_SampleTypeID
		where T_OrderSampleIsActive = 'Y' and T_OrderSampleT_OrderHeaderID=? order by T_OrderSampleID";
	if ($all) {
	   $sql ="select *
		  from t_ordersample 
		  left join t_sampletype  on T_OrderSampleT_SampleTypeID = T_SampleTypeID
		where  T_OrderSampleT_OrderHeaderID=? order by T_OrderSampleID";
	}
	   $qry = $this->db->query($sql,array($headerID));
	if (! $qry) {
		   echo "ERR : \n" ;
		   print_r($this->db->error());
		   exit;
	}
	$rows = $qry->result_array();
		echo "T_OrderSampleID\tT_OrderSampleBarcode\tT_SampleTypeName\tT_OrderSampleWorklistReceive\tWl RcvDate\Wl RcvTime\tIsActive\n"; 
	foreach($rows as $r) {
		echo "{$r['T_OrderSampleID']}\t{$r['T_OrderSampleBarcode']}\t{$r['T_SampleTypeName']}\t{$r['T_OrderSampleWorklistReceive']}\t" .
			"{$r['T_OrderSampleWorklistReceiveDatetime']}\t{$r['T_OrderSampleWorklistReceiveUserID']}\t{$r['T_OrderSampleIsActive']}\n";	
	}
   }
   function preanalytic($headerID) {
	   $sql ="select *
		   from t_orderdetailaddon
		   join t_orderdetail on T_OrderDetailID = T_OrderDetailAddOnT_OrderDetailID and T_OrderDetailIsActive = 'Y'
			and T_OrderDetailAddOnIsActive = 'Y' and T_OrderDetailT_OrderHeaderID = ?";
	$qry = $this->db->query($sql,array($headerID));
	if (! $qry) {
		   echo "ERR : \n" ;
		   print_r($this->db->error());
		   exit;
	}
	$rows = $qry->result_array();
		echo "T_OrderDetailID\tT_OrderDetailT_TestName\tT_OrderDetailAddOnPreAnalytic\tT_OrderDetailAddOnPreAnalyticDate\n";
	foreach($rows as $r) {
		echo "{$r['T_OrderDetailID']}\t{$r['T_OrderDetailT_TestName']}\t{$r['T_OrderDetailAddOnPreAnalytic']}\t{$r['T_OrderDetailAddOnPreAnalyticDate']}\n";
	}
   }
   function pre_copy_from_to($fromID,$toID) {
	   $sql = "update 
		   t_orderdetailaddon a 
			join t_orderdetailaddon b on  a.T_OrderDetailAddOnT_OrderDetailID = ?
				and b.T_OrderDetailAddOnT_OrderDetailID = ?
			set b.T_OrderDetailAddOnPreAnalytic = a.T_OrderDetailAddOnPreAnalytic ,
				b.T_OrderDetailAddOnPreAnalyticDate = a.T_OrderDetailAddOnPreAnalyticDate
	";
	$qry = $this->db->query($sql, array($fromID,$toID));
	echo $this->db->last_query() . "\n";		
	if (! $qry) {
		   echo "ERR : \n" ;
		   print_r($this->db->error());
		   exit;
	}
	 echo "Pre Analytic Update";
   }
   function cek_kuning($headerID) {
	   $sql ="select a.T_OrderSampleWorklistReceive , b.T_OrderSampleWorklistReceive bRcv,
		   a.T_OrderSampleWorklistReceiveDatetime, b.T_OrderSampleWorklistReceiveDatetime bDate,
		   a.T_OrderSampleWorklistReceiveUserID, b.T_OrderSampleWorklistReceiveUserID bUser
		   from t_ordersample a
		   join t_ordersample b on a.T_OrderSampleT_OrderHeaderID = b.T_OrderSampleT_OrderHeaderID
			and a.T_OrderSampleBarcode like '%SK%' and b.T_OrderSampleBarcode like '%SP%' and b.T_OrderSampleWorklistReceive = 'Y'
			and a.T_OrderSampleIsActive = 'Y' and b.T_OrderSampleIsActive = 'Y'
		   and a.T_OrderSampleT_OrderHeaderID = ?";
	$qry = $this->db->query($sql,array($headerID));
	if (! $qry) {
		   echo "ERR : \n" ;
		   print_r($this->db->error());
		   exit;
	}
	$rows = $qry->result_array();
	print_r($rows);
   }

   function update_kuning($headerID) {
		  $sql = "update t_ordersample a
		   join t_ordersample b on a.T_OrderSampleT_OrderHeaderID = b.T_OrderSampleT_OrderHeaderID
			and a.T_OrderSampleBarcode like '%SK%' and b.T_OrderSampleBarcode like '%SP%' and b.T_OrderSampleWorklistReceive = 'Y'
			and a.T_OrderSampleIsActive = 'Y' and b.T_OrderSampleIsActive = 'Y'
		   and a.T_OrderSampleT_OrderHeaderID = ?
		   set 
		   a.T_OrderSampleWorklistReceive = b.T_OrderSampleWorklistReceive ,
		   a.T_OrderSampleWorklistReceiveDatetime = b.T_OrderSampleWorklistReceiveDatetime ,
		   a.T_OrderSampleWorklistReceiveUserID =  b.T_OrderSampleWorklistReceiveUserID 
		   ";
	$qry = $this->db->query($sql,array($headerID));
	if (! $qry) {
		   echo "ERR : \n" ;
		   print_r($this->db->error());
		   exit;
	}
	echo "Serum Kuning di update";
   }
}