require_once ("scriptheader.php"); $empobj = new objwh; if($_GET['id']!=''){ global $conn; $param_id=$_GET['id']; $param_Edata=""; $sql="Select * ,concat(day(DATE_S),'/',MONTH(DATE_S),'/',year(DATE_S)) AS DATE_SS ,concat(day(DATE_S),'/',MONTH(DATE_E),'/',year(DATE_E)) AS DATE_EE ,concat(day(DATEOUT),'/',MONTH(DATEOUT),'/',year(DATEOUT)) AS DATE_OO from `tb_carjob` where Status='1' and ref='".$param_id."' "; $result = mysql_query( $sql , $conn ); $nrow = mysql_num_rows($result); if ($nrow>0){ $param_Edata= mysql_fetch_array($result); $param_hset=explode("|",$param_Edata['ROUND']); $param_hs=explode(":", $param_hset[0]); $param_he=explode(":", $param_hset[1]); if($param_Edata['PALLET_ID']!=NULL){ $sql="Select * from tb_pallet_send where JOB_ID='".$param_id."' and status='1'"; $result = mysql_query( $sql , $conn ); $nrow = mysql_num_rows($result); if ($nrow>0){ $param_EPdata= mysql_fetch_array($result); } } } } if($_GET['ref']!=''){ global $conn; $param_id=$_GET['ref']; $param_Edata=""; $sql="Select * ,concat(day(DATE_S),'/',MONTH(DATE_S),'/',year(DATE_S)) AS DATE_SS ,concat(day(DATE_S),'/',MONTH(DATE_E),'/',year(DATE_E)) AS DATE_EE ,concat(day(DATEOUT),'/',MONTH(DATEOUT),'/',year(DATEOUT)) AS DATE_OO from `tb_carjob` where ref='".$param_id."' "; $result = mysql_query( $sql , $conn ); $nrow = mysql_num_rows($result); if ($nrow>0){ $param_Edata= mysql_fetch_array($result); $param_Edata['SHIPMENT_ID']=''; if($param_Edata['PALLET_ID']!=NULL){ $sql="Select * from tb_pallet_send where JOB_ID='".$param_id."' and status='1'"; $result = mysql_query( $sql , $conn ); $nrow = mysql_num_rows($result); if ($nrow>0){ $param_EPdata= mysql_fetch_array($result); } } } } ?>