format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; if(isset($_POST['trans'])){ echo ""; //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### //$totalRows = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`=4"),0); //$noOfRecordPerPage = mysql_result(mysql_query("SELECT `page_count` FROM `asa_versioning_db` WHERE 1"),0); //$myPageCount = ceil($totalRows / $noOfRecordPerPage); //$offSet = 0;//($myPageCount-1) * $noOfRecordPerPage; //echo ""; //echo ""; //echo ""; //echo ""; //####################################################################################################### //####################################################################################################### //SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1 //$getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 4 ORDER BY `id` DESC LIMIT $offSet, $noOfRecordPerPage "); $getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 4 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{ $deliverNote = "PD"; $pdColor ='#fccaba'; } ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".$row['po_number']."

".$row['date_posted']."

".$reqCompName."

".$reqDealName."

".$vendorName."

".$row['terms']." Days

"; $poStat = mysql_result(mysql_query("SELECT `po_status` FROM `prf_po_status` WHERE `po_code`='".$row['po_status']."'"),0); echo $poStat; echo"

".$row['remarks']."

"; echo $deliverNote; echo"

📑

"; } ?>