format("Y-m-d");
$prfTime = date('H:i:s');
$myDate = date_create() ->format("Y-m-d");
$prfDateTime=$prfDate. " ".$prfTime;
//$myUID = $user_data['u_id'];
if(isset($_POST['done'])){
$itemID = mysql_escape_string($_POST['itemID']);
$uid = mysql_escape_string($_POST['uid']);
$ExecomSelectedCanvassID = mysql_escape_string($_POST['ExecomSelectedCanvassID']);
$selectedVendorAmount = mysql_escape_string($_POST['selectedVendorAmount']);
$selectedVendorQty = mysql_escape_string($_POST['selectedVendorQty']);
$canvassCode = mysql_result(mysql_query("SELECT `ref_code` FROM `prf_uploadedcanvass` WHERE `id`='$ExecomSelectedCanvassID'"),0);
$canvassID = mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `id`='$ExecomSelectedCanvassID'"),0);
$canvassVendorID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_uploadedcanvass` WHERE `id`='$canvassID'"),0);
$prfCode = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0);
$itemDes = mysql_result(mysql_query("SELECT `item_description` FROM `prf_request_detl` WHERE `id`='$itemID'"),0);
$requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$prfCode'"),0);
$chkIfWithMyApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$uid'"),0);
if($chkIfWithMyApproval!=0){
echo '';
}else{
mysql_query("INSERT INTO `prf_execomcanvassapproval`(prf_ref_code,canvass_id,item_code,vendor_id,canvass_qty,approved_amount,approved_by_execom,notes,date_approved,time_approved)
VALUES('{$prfCode}','{$ExecomSelectedCanvassID}','{$itemID}','{$canvassVendorID}','{$selectedVendorQty}','{$selectedVendorAmount}','{$uid}','{$notes}','{$myDate}','{$prfTime}')");
$getEXECOMAuthority = mysql_result(mysql_query("SELECT `authority` FROM `prf_execommembers` WHERE `execom_id`='$uid'"),0);
$chkExecomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID'"),0);
if($getEXECOMAuthority == 1){
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassVendorID',`approved_proposal_code`='$canvassCode',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount' WHERE `id`='$itemID'");
$messageToReq ="You ".$itemDes." request has been approved by EXECOM and forwarded to procurement for PO";
mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time)
VALUES('{$prfCode}','{$uid}','{$messageToReq}','{$requestorID}','{$myDate}','{$prfTime}')");
}
if($getEXECOMAuthority == 2){
if($chkExecomApproval == 2){
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassVendorID',`approved_proposal_code`='$canvassCode',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount' WHERE `id`='$itemID'");
$messageToReq ="You ".$itemDes." request has been approved by EXECOM and forwarded to procurement for PO";
mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time)
VALUES('{$prfCode}','{$uid}','{$messageToReq}','{$requestorID}','{$myDate}','{$prfTime}')");
} else{
$messageToReqB ="You ".$itemDes." request has been endorsed by EXECOM. Please wait for another EXECOM to approved your request before we proceed with the PO. ";
mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time)
VALUES('{$prfCode}','{$uid}','{$messageToReqB}','{$requestorID}','{$myDate}','{$prfTime}')");
}
}
if($getEXECOMAuthority == 3){
if($chkExecomApproval == 3){
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassVendorID',`approved_proposal_code`='$canvassCode',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount' WHERE `id`='$itemID'");
$messageToReq ="You ".$itemDes." request has been approved by EXECOM and forwarded to procurement for PO";
mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time)
VALUES('{$prfCode}','{$uid}','{$messageToReq}','{$requestorID}','{$myDate}','{$prfTime}')");
} else{
$messageToReqB ="You ".$itemDes." request has been endorsed by EXECOM. Please wait for another EXECOM to approved your request before we proceed with the PO. ";
mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time)
VALUES('{$prfCode}','{$uid}','{$messageToReqB}','{$requestorID}','{$myDate}','{$prfTime}')");
}
}
//CHECK IF ALL ITEMS IN THE PRF HAS BEEN APPROVED
$chekItemCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `id`='$itemID' AND `deleted`=0"),0);
$chekItemCountApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `id`='$itemID' AND `deleted`=0 AND `execom_approval_ts`!=''"),0);
if($chekItemCount = $chekItemCountApproval){
mysql_query("UPDATE `prf_request_hdr` SET `current_status`='7' WHERE `reference_code`='$canvassCode'");
mysql_query("UPDATE `prf_request_detl` SET `item_status`='7' WHERE `id`='$itemID'");
}else{
mysql_query("UPDATE `prf_request_detl` SET `item_status`='6' WHERE `id`='$itemID'");
}
//mysql_query("UPDATE `prf_request_hdr` SET `current_status`='7' WHERE `reference_code`='$canvassCode'");
}
echo '';
?>