format("Y-m-d");
$prfTime = date('H:i:s');
$myDate = date_create() ->format("Y-m-d");
$prfDateTime=$prfDate. " ".$prfTime;
if(isset($_POST['done'])){
$itemID = mysql_escape_string($_POST['AwardItemID']);
$ExecomSelectedCanvassID = mysql_escape_string($_POST['canvassID']); //47 canvassID
//$ExecomSelectedCanvassID = mysql_escape_string($_POST['canvassID']); //47 AwardItemID
$selectedVendorAmount = mysql_escape_string($_POST['AwardItemAmount']);
$selectedVendorQty = mysql_escape_string($_POST['AwardItemQty']);
$token = md5(md5($itemID));
$prfCode = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0);
//$proposalID = mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `id`='$ExecomSelectedCanvassID'"),0);//6
//$proposalCode = mysql_result(mysql_query("SELECT `ref_code` FROM `prf_uploadedcanvass` WHERE `id`='$proposalID'"),0);
$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
///$canvassVendorID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_uploadedcanvass` WHERE `id`='$ExecomSelectedCanvassID'"),0);
$notes='Portal';
$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`='$PRFRefCodeID'"),0);
$chkIfWithMyApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$uid'"),0);
//echo "SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$uid'";
//exit;
//#########################################################################################################################################
//#########################################################################################################################################
//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}')");
$canvassAwardIDGMLevel = 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);
$vendorAwardIDGMLevel = 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);
$canvassAwardIDEXECOMB = mysql_result(mysql_query("SELECT `canvass_id` from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 2 LIMIT 1"),0);
$vendorAwardIDEXECOMB = mysql_result(mysql_query("SELECT `vendor_id` from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 2 LIMIT 1"),0);
//canvassAwardVendorIDSVP canvassAwardIDSVP
//$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`po_code` = '$prfCode' AND `matrix_level`!=0 ORDER BY `matrix_level` DESC LIMIT 1"),0);
//$byPassExecom
if($byPassExecom == 1){
$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);
}
$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'"),0);
$chkExecomApproval = intval($chkExecomApprovalX);
$chkSVPApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID'"),0);
switch($aprMatrix){
//#################################################################################################
case '1':
if($chkExecomApproval > 2){
//CHECK IF THE REQUIRED APPROVER SIGNED
if($chkIFReqAprSigned > 0){
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$vendorAwardIDEXECOMB',`approved_proposal_code`='$canvassAwardIDEXECOMB',`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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE `po_code` = '$prfCode' AND `item_id`='$itemID'");
}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}')");
}
}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}')");
}
break;
//#################################################################################################
case '2':
if($chkExecomApproval > 2){
//CHECK IF THE REQUIRED APPROVER SIGNED
if($chkIFReqAprSigned > 0){
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$vendorAwardIDEXECOMB',`approved_proposal_code`='$canvassAwardIDEXECOMB',`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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE `po_code` = '$prfCode' AND `item_id`='$itemID'");
}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}')");
}
}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}')");
}
break;
//#################################################################################################
case '3':
if($chkExecomApproval > 1){
//CHECK IF THE REQUIRED APPROVER SIGNED
if($chkIFReqAprSigned > 0){
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$vendorAwardIDGMLevel',`approved_proposal_code`='$canvassAwardIDGMLevel',`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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE `po_code` = '$prfCode' AND `item_id`='$itemID'");
}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}')");
}
}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}')");
}
break;
//#################################################################################################
case '4':
if($chkSVPApproval > 0){ // 1
//CHECK IF THE REQUIRED APPROVER SIGNED fs
if($chkIFReqAprSigned > 0){
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassVendorID',`approved_proposal_code`='$ExecomSelectedCanvassID',`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}')");
mysql_query("UPDATE `prf_validate_links` SET `completed` = '1' WHERE `po_code` = '$prfCode' AND `item_id`='$itemID'");
}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}')");
}
}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}')");
}
break;
//#################################################################################################
case '5':
mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$prfDateTime',`awarded`=1,`award_to_vendor_id`='$canvassVendorID',`approved_proposal_code`='$ExecomSelectedCanvassID',`approved_qty`='$selectedVendorQty',`approved_amount`='$selectedVendorAmount' WHERE `id`='$itemID'");
$messageToReq ="You ".$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 `po_code` = '$prfCode' AND `item_id`='$itemID'");
break;
//#################################################################################################
}
//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);
$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`='$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'");
}
}
?>
(".$getDeptIDFName." ".$getDeptIDLName.")";
$pendingDeptName = "Waiting for ". $getDeptIDFName . " " . $getDeptIDLName. " Approval";
if($getDeptID == $uniqueRefID){
$bgColor='#d1faa0';
$view='True';
}else{
$bgColor='#eef0eb';
$view='False';
}
}
if($getMatrixLevel == 4){
$chkIfGMSigned = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."' AND `approved_by_execom` = '$getCompanyGMID'"),0);
if($chkIfRAOSigned == 1){
$rSign = '✅';
}else{
$rSign = '❌';
}
if($chkIfGMSigned == 1){
$gSign = '✅';
}else{
$gSign = '❌';
}
$pendingApproval ="GM/SVP/AVP
(".$gSign.") ".$getGMIDFName." ".$getGMIDLName."
(".$rSign.") ".$getRAFName." ".$getRALName." ";
$pendingDeptName = "Waiting for approval...";
if($getCompanyGMID == $uniqueRefID || $getRequiredApprover==$uniqueRefID){
$bgColor='#ff8480 ';
$view='True';
}else{
$bgColor='#eef0eb';
$view='False';
}
}
if($getMatrixLevel < 4){
$chkIfImExecom = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `execom_id`='$uniqueRefID' AND `authority` < 4"),0);
$ExecomCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."'"),0);
if($chkIfRAOSigned == 1){
$rSign = '✅';
}else{
$rSign = '❌';
}
$pendingApproval ="EXECOM:(Any of EXECOM Members)";
$pendingApproval ="ANY EXECOM MEMBERS:
".$ExecomCount." out of 3 has been signed
(".$rSign.") ".$getRAFName." ".$getRALName." ";
$pendingDeptName = "Waiting for ". $getGMIDFName . " " . $getGMIDLName. " Approval";
$pendingDeptName = "Waiting for EXECOM Approval";
if($chkIfImExecom > 0){
$bgColor='#ff8480 ';
$view='True';
}else{
$bgColor='#eef0eb';
$view='False';
}
}
if($PRFPUR==1){
?>".$row['id']."";
echo "".strtoupper($reqCompName);
echo "
PRF.#: ".$regHDRcode ."";
echo " | ";
echo "".strtoupper($reqByLName).", ".strtoupper($reqByFName);
echo" | ";
echo "".strtoupper($row['item_description'])." | ";
echo "".$regCatName." | ";
echo "".strtoupper($row['quantity'])." | ";
echo "".strtoupper($dateNeeded)." | ";
echo "".strtoupper($pendingApproval)." | ";
echo "".strtoupper($getMatrixLevel)." | ";
echo "
";
}else{
if($view === 'True'){
?>".$row['id']."";
echo "| ".strtoupper($reqCompName)." | ";
echo "".strtoupper($reqByLName).", ".strtoupper($reqByFName)." | ";
echo "".strtoupper($row['item_description'])." | ";
echo "".$regCatName." | ";
echo "".strtoupper($row['quantity'])." | ";
echo "".strtoupper($dateNeeded)." | ";
echo "".strtoupper($pendingApproval)." | ";
echo "".strtoupper($getMatrixLevel)." | ";
echo "
";
}
}
}
}
?>
|
| Selected Record: |
|