format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $itemID = mysql_escape_string($_POST['itemID']); $itemRefCode = mysql_escape_string($_POST['itemRefCode']); //$poCode = mysql_escape_string($_POST['poCode']); $notifyReq = mysql_escape_string($_POST['notifyReq']); $notifyVendor = mysql_escape_string($_POST['notifyVendor']); $poToVendor = mysql_escape_string($_POST['poToVendor']); $poByCompany = mysql_escape_string($_POST['poByCompany']); $myPONumber = mysql_escape_string($_POST['myPONumber']); $deliveryDate = date("Y-m-d", strtotime($_POST['deliveryDate'])); //mysql_escape_string($_POST['deliveryDate']); //$DateNeeded = date("Y-m-d", strtotime($ReqDateNeeded)); $myInstructions = mysql_escape_string($_POST['myInstructions']); $dealerID = mysql_result(mysql_query("SELECT `deal_id` FROM `prf_request_hdr` WHERE `reference_code`='$itemRefCode'"),0); $canvassID = mysql_result(mysql_query("SELECT `approved_proposal_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $terms = mysql_result(mysql_query("SELECT `terms` FROM `prf_suppliers` WHERE `id`='$poToVendor'"),0); mysql_query("UPDATE `prf_request_detl` SET `po_code`='$myPONumber' WHERE id='$itemID'"); $chkIfHeaderExist = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); if($chkIfHeaderExist > 0){ }else{ mysql_query("INSERT INTO `prf_purchase_order`(delivery_date,comp_id,dealer_id,canvass_id,vendor_id,po_number,date_created,terms,time_created,created_by,remarks) VALUES('{$deliveryDate}','{$poByCompany}','{$dealerID}','{$canvassID}','{$poToVendor}','{$myPONumber}','{$prfDate}','{$terms}','{$currentTime}','{$myUID}','{$myInstructions}')"); } ?> ".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

".$row['header_ref_code']."

".$reqCompName."

".$vendorName."

".$row['item_description']."

".$row['approved_qty']."

".$row['approved_amount']."

📋