File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_CanvassAwardToVendor_BACKUP.php

Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("Y/m/d"); $notes='via App'; $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $ApiKey= $_REQUEST['keyID']; // Expect LoginName, LoginPassword //========================================================= if($ApiKey == '34234234000000324234234'){ $uid = $_REQUEST['userID']; $itemID= $_REQUEST['itemID']; $ExecomSelectedCanvassID= $_REQUEST['canvassSheetID']; $proposalID= $_REQUEST['proposalID']; $MyCode= $_REQUEST['approvalCode']; $selectedVendorAmountComma= $_REQUEST['canvassAmount']; $selectedVendorAmount = str_replace(',', '', $selectedVendorAmountComma); $selectedVendorQty= $_REQUEST['canvassQTY']; $error = ''; //================================================================ //================================================================ //================================================================ //$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`='$proposalID'"),0); //10 $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 '<script>alert("WARNING: You already approved this request. Waiting for other EXECOM to approve this transaction.")</script>'; $error=1; }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) > 2 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) > 2 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 $deptVendorApprovalID = mysql_result(mysql_query("SELECT `vendor_id` from prf_uploadedcanvass WHERE `id` = '$proposalID'"),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) > 2 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'"; $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'"; $chkIFReqAprSigned = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApprover'"),0); $chkExecomApproval = mysql_result(mysql_query("SELECT COUNT(1) from prf_execomcanvassapproval WHERE `item_code` = '$itemID' GROUP BY canvass_id HAVING COUNT(canvass_id) > 2"),0); $chkSVPApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID'"),0); //echo "SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID'"; switch($aprMatrix){ //################################################################################################# case '1': if($chkExecomApproval){ //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){ //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($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 `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; //################################################################################################# } //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'"); } //=================================================================== //=================================================================== //=================================================================== //=================================================================== //=================================================================== //=================================================================== //================================================================ //================================================================ //================================================================ if($error == ''){ $messsage ='Update complete.'; $saveButton ='false'; $backButton ='true'; }else{ $messsage ='Error: Unable to process request.'; $saveButton ='true'; $backButton ='false'; } $json = json_encode(["userID" => "$uid","itemDesc" => "$itemID","canvassID" => "$ExecomSelectedCanvassID","approvalCode" => "$MyCode","canvassAmount" => "$selectedVendorAmount","canvassQTY" => "$selectedVendorQty","message" => "$messsage","canvassSheetID" => "$canvassSheetID","canvassVendorID" => "$canvassVendorID","prfCode" => "$prfCode","requestorID" => "$requestorID","chkIfWithMyApproval" => "$chkIfWithMyApproval","backButton" => "$backButton","saveButton" => "$saveButton"]); } echo $json; ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings