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'])){
$notes='via web';
$itemID = mysql_escape_string($_POST['itemID']); //ok lblPopItemName lblPopVendorname lblPopPrice
$uid = mysql_escape_string($_POST['uid']); //ok
$MyCode = mysql_escape_string($_POST['MyCode']); //ok
$myTokenomics = mysql_escape_string($_POST['myTokenomics']);
$selectedVendorAmountA = mysql_escape_string($_POST['selectedVendorAmount']);
$selectedVendorAmount = str_replace(',', '', $selectedVendorAmountA);
$selectedVendorQty = mysql_escape_string($_POST['selectedVendorQty']);
$ExecomSelectedCanvassID = mysql_escape_string($_POST['ExecomSelectedCanvassID']); //canvass sheet ID 523
//Proposal ID
$canvassSheetID = mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `id`='$ExecomSelectedCanvassID'"),0); //1174
$canvassVendorID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_uploadedcanvass` WHERE `id`='$canvassSheetID'"),0); //10
//18900 100013500
$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);
//#########################################################################################################################################
//check if item is consumable or office supplies
$itemCat = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_detl` WHERE `id`='$itemID' AND `sub_category_id` !=20"),0);
//echo "testing...". $itemCat." ";;
if($itemCat == 4 || $itemCat == 6){
$byPassExecom = 1;
}else{
$byPassExecom = 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}')");
//
$canvassAwardID = mysql_result(mysql_query("SELECT `canvass_id` from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 1 LIMIT 1"),0);
$canvassAwardIDSVP = mysql_result(mysql_query("SELECT `canvass_id` from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 0 LIMIT 1"),0);
$canvassAwardVendorID = mysql_result(mysql_query("SELECT `vendor_id` from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 1 LIMIT 1"),0);
$canvassAwardVendorIDSVP = mysql_result(mysql_query("SELECT `vendor_id` from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 0 LIMIT 1"),0);
//canvassAwardVendorIDSVP canvassAwardIDSVP
//getCanvassID muna using ExecomSelectedCanvassID
$deptVendorApprovalID = mysql_result(mysql_query("SELECT `vendor_id` from prf_uploadedcanvass WHERE `id` = '$canvassSheetID'"),0);
//$canvassCode = mysql_result(mysql_query("SELECT `id` FROM `prf_uploadedcanvass` WHERE `id`='$canvassAwardIDSVP'"),0);
$levelABProposalID = mysql_result(mysql_query("SELECT `canvass_id` from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 1 LIMIT 1"),0);
mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE code='$MyCode'");
//$getEXECOMAuthority = mysql_result(mysql_query("SELECT `authority` FROM `prf_execommembers` WHERE `execom_id`='$uid'"),0);
$getItemAmountFromCanvassSheet = mysql_result(mysql_query("SELECT MIN(`amount`) FROM `prf_canvass_sheet` WHERE `item_id`='$itemID'"),0);
$aprMatrix = mysql_result(mysql_query("SELECT `matrix_level` FROM `prf_validate_links` WHERE `code`='$MyCode'"),0);
//echo "SELECT `matrix_level` FROM `prf_validate_links` WHERE `code`='$MyCode'";
//$byPassExecom
if($byPassExecom == 1){
//$getRequiredApprover=mysql_query("SELECT //vts_users.`u_id`,vts_users.`u_fname`,vts_users.`u_lname`,vts_users.`usr_mobile`,vts_users.`email`,
//prf_execommembers.`comp_id`,prf_execommembers.`execom_id`,prf_execommembers.`authority`
//FROM prf_execommembers JOIN vts_users ON vts_users.`u_id` = prf_execommembers.`execom_id`
//WHERE prf_execommembers.`deleted`=0 AND `authority` = 8888");
$getRequiredApprover = mysql_result(mysql_query("SELECT `execom_id` FROM `prf_execommembers` WHERE `authority`='8888'"),0);
}else{
$getRequiredApprover = mysql_result(mysql_query("SELECT `requiredApproverID` FROM `prf_approval_matrix` WHERE `level`='$aprMatrix'"),0);
}
//$getRequiredApprover = mysql_result(mysql_query("SELECT `requiredApproverID` FROM `prf_approval_matrix` WHERE `level`='$aprMatrix'"),0);
//echo "SELECT `required_officers` FROM `prf_approval_matrix` WHERE `level`='$aprMatrix'";
$chkIFReqAprSignedX = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApprover'"),0);
$chkIFReqAprSigned = intval($chkIFReqAprSignedX);
$chkExecomApprovalX = mysql_result(mysql_query("SELECT COUNT(1) from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 1"),0);
$chkExecomApproval = $chkExecomApprovalX;
$chkSVPApprovalX = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID'"),0);
$chkSVPApproval= intval($chkSVPApprovalX);
//echo "SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID'";
switch($aprMatrix){
//#################################################################################################
case '1':
if($chkExecomApproval > 1){ //YES
//CHECK IF THE REQUIRED APPROVER SIGNED
if($chkIFReqAprSigned > 0){ //YES
//echo "SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApprover'";
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassAwardVendorID',`approved_proposal_code`='$levelABProposalID',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount',`item_status`='7' WHERE `id`='$itemID'");
$messageToReq ="Your ".$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}')");
//mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `code`='$MyCode'");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `item_id`='$itemID'");
}else{ //NO
$messageToReqB ="Your ".$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}')");
//$getScore = mysql_result(mysql_query("SELECT `exe_score` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `canvass_id`='$canvassID'"),0);
mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `code`='$MyCode'");
}
}else{
$messageToReqB ="Your ".$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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `code`='$MyCode'");
}
//exit;
break;
//#################################################################################################
case '2':
if($chkExecomApproval > 1){ //YES
//CHECK IF THE REQUIRED APPROVER SIGNED
if($chkIFReqAprSigned > 0){ //YES
//echo "SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApprover'";
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassAwardVendorID',`approved_proposal_code`='$levelABProposalID',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount',`item_status`='7' WHERE `id`='$itemID'");
$messageToReq ="Your ".$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}')");
//mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `code`='$MyCode'");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `item_id`='$itemID'");
}else{ //NO
$messageToReqB ="Your ".$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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `code`='$MyCode'");
}
}else{
$messageToReqB ="Your ".$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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `code`='$MyCode'");
}
//exit;
break;
//#################################################################################################
case '3':
if($chkExecomApproval > 0){ //YES
//CHECK IF THE REQUIRED APPROVER SIGNED
if($chkIFReqAprSigned > 0){ //YES
//echo "SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApprover'";
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassAwardVendorIDSVP',`approved_proposal_code`='$canvassAwardIDSVP',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount',`item_status`='7' WHERE `id`='$itemID'");
$messageToReq ="Your ".$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}')");
//mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `code`='$MyCode'");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `item_id`='$itemID'");
}else{ //NO
$messageToReqB ="Your ".$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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `code`='$MyCode'");
}
}else{
$messageToReqB ="Your ".$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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `code`='$MyCode'");
}
//exit;
break;
//#################################################################################################
case '4':
if($chkSVPApproval > 0){ //YES
//CHECK IF THE REQUIRED APPROVER SIGNED
if($chkIFReqAprSigned > 0){ //YES
//echo "SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApprover'";
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassAwardVendorIDSVP',`approved_proposal_code`='$canvassAwardIDSVP',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount',`item_status`='7' WHERE `id`='$itemID'");
$messageToReq ="Your ".$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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `item_id`='$itemID'");
}else{ //NO
$messageToReqB ="Your ".$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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `code`='$MyCode'");
}
}else{
$messageToReqB ="Your ".$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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `code`='$MyCode'");
}
//exit;
break;
//#################################################################################################
case '5':
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$deptVendorApprovalID',`approved_proposal_code`='$ExecomSelectedCanvassID',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount',`item_status`='7' WHERE `id`='$itemID'");
$messageToReq ="Your ".$itemDes." request has been approved 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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `code`='$MyCode'");
mysql_query("UPDATE `prf_validate_links` SET `completed` = 1 WHERE `item_id`='$itemID'");
break;
//#################################################################################################
}
//echo " byPassExecom:".$itemCat;
//echo " byPassExecom:".$byPassExecom;
//echo " Matrix:".$aprMatrix;
//echo " getRequiredApprover:".$getRequiredApprover;
//echo " chkIFReqAprSigned:".$chkIFReqAprSigned;
//echo " chkSVPApproval Approval:".$chkSVPApproval;
//CHECK IF ALL ITEMS IN THE PRF HAS BEEN APPROVED
$getHeaderID = mysql_result(mysql_query("SELECT `header_id` FROM `prf_request_detl` WHERE `id`='$itemID'"),0);
$getPRFNo = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0);
$chekItemCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_id`='$getHeaderID' AND `deleted`=0"),0);
$chekItemCountApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_id`='$getHeaderID' AND `deleted`=0 AND `execom_approval_ts`!=''"),0);
if($chekItemCount == $chekItemCountApproval){
mysql_query("UPDATE `prf_request_hdr` SET `current_status`='7' WHERE `reference_code`='$getPRFNo'");
//mysql_query("UPDATE `prf_request_detl` SET `item_status`='7' WHERE `id`='$itemID'");
}
//mysql_query("UPDATE `prf_request_hdr` SET `current_status`='7' WHERE `reference_code`='$canvassCode'");
}
//echo '';
?>