format("Y-m-d");
$prfTime = date('H:i:s');
$myDate = date_create() ->format("Y-m-d");
$activeID=$user_data['u_id'];
if(isset($_POST['getData'])){
$start = mysql_real_escape_string($_POST['start']);
$limit = mysql_real_escape_string($_POST['limit']);
$infCanvass = mysql_real_escape_string($_POST['infCanvass']);
if($infCanvass=='' || $infCanvass == null){
$getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 4 ORDER BY `id` DESC LIMIT $start, $limit");
}else{
$getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 4 AND `po_number`='$infCanvass' ORDER BY `id` DESC");
}
while($row=mysql_fetch_array($getItemHdr)){
$vendorID = $row['vendor_id'];
$vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0);
$reqCompID=$row['comp_id'];
$reqDealID=$row['dealer_id'];
$reqCompName = mysql_result(mysql_query("SELECT `comp_code` FROM vts_company WHERE comp_id='$reqCompID'"),0);
$reqDealName = mysql_result(mysql_query("SELECT `deal_code` FROM vts_dealerships WHERE deal_id='$reqDealID'"),0);
$myTokenID = $row['token'];
$poNote = $row['delivery_note'];
if($poNote ==='Full Delivery'){
$deliverNote = "FD";
$pdColor ='#ddfc9f';
}else if($poNote ==='Waiting For Delivery'){
$deliverNote = "WD";
$pdColor ='#ddfc9f';
}else{
$deliverNote = "PD";
$pdColor ='#fccaba';
}
?>".$row['id']."";
echo "| ".$row['po_number']." | ";
echo "".$row['date_posted']." | ";
echo "".$reqCompName." | ";
echo "".$reqDealName." | ";
echo "".$vendorName." | ";
echo "".$row['terms']." Days | ";
echo "";
$poStat = mysql_result(mysql_query("SELECT `po_status` FROM `prf_po_status` WHERE `po_code`='".$row['po_status']."'"),0);
echo $poStat;
echo" | ";
echo "".$row['remarks']." | ";
echo "";
echo $deliverNote;
echo" | ";
echo "
📑 | ";
echo "
";
}
}
?>