format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $myPONumber = mysql_escape_string($_POST['myPONumber']); $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $myToken = md5(md5($myPONumber)); $cancelledNote = 'Cancelled P.O on ' .$prfDate. ' by: '. $myUID; mysql_query("UPDATE `prf_request_detl` SET `po_code_posted`='0',`po_code`='', `item_status`='7' WHERE `po_code`='$myPONumber'"); mysql_query("UPDATE `prf_purchase_order` SET `date_posted`='', `po_status`='9',`token`='',`delivery_note`='$cancelledNote' WHERE `po_number`='$myPONumber'"); mysql_query("INSERT INTO prf_changes_logs(id,action_taken,user_id,old_info,new_info, ref_number) VALUES('','Cancelled PO','{$myUID}','','','{$myPONumber}')"); echo ""; echo ""; $getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 0 AND `po_status`!=9 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); ?>".$row['id'].""; 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']."

"; } ?>