File manager

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

Back
<?php include 'core/init.php'; protected_page(); $uniqueRefID = $user_data['u_id']; //echo $uniqueRefID; $prfDate = date_create() ->format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; $curDateTime = $prfDate.' '.date('H:i:s'); $getRequiredApproverID = mysql_result(mysql_query("SELECT `requiredApproverID` FROM `prf_approval_matrix` WHERE `level` < 5 limit 1"),0); ///usr/bin/php /home/autoph/public_html/connect/home/PRF_AutomateApproval.php //CRON PATH $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); ?> <!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/> <link rel="stylesheet" type="text/css" href="css/jquery-ui.css"/> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1"/> </head> <body> <div class='NewPRFHeader'> <p class='PRFBodyTitle'>📝  AUTOMATE APPROVAL</p> </div> <!--########################## POPUP MESSAGE ############################################--> <!--########################################################################################################--> <div id='saveMessage' style='display:none;background:yellow;border:1px solid orange;padding:0px;width:400px;top:40px;position:fixed;left:50px;position:absolute;z-index:999999999;opacity: 0.95;'> <b style=''></b> <p style='margin:20px;background:yellow;font-family:Yu Gothic;font-size:1.5vw;text-align:center'>New record has been saved.</p> </div> <!--########################################################################################################--> <!--########################## MAIN TABLE WINDOW ############################################--> <div class='NewPRFBody' > <div id='mainTable' class='PRFTableBody' style='background: #ffffff;overflow:auto'> <div style='width:100%;height:32px;background:white'> <table> <thead> <th style='width:10%'>ITEM ID</th> <th style='width:10%'>DATE START </th> <th style='width:10%'>TODAYS DATE</th> <th style='width:10%'>DAYS LAPSE</th> <th style='width:10%'>VALID</th> <th style='width:10%'>SIGNED BY R.A</th> <th style='width:1%'> </th> </thead> </table> </div> <div id='displaySupplier' class='PRFTableItems' style='width:100%;overflow:auto'> <table> <?php $getItemHdr = mysql_query("SELECT `id`,`header_ref_code`,`comp_id`,`create_canvass_sheet`,`canvass_sheet_creation_ts`,`for_execom_canvass_approval`,`execom_approval_ts`,`deleted`,`item_status` FROM `prf_request_detl` WHERE `deleted`=0 AND `awarded`=0 AND `execom_approval_ts`='' AND `item_status`='6' AND `for_execom_canvass_approval`=1 ORDER BY `canvass_sheet_creation_ts` DESC"); while($row=mysql_fetch_array($getItemHdr)){ $errorC=0; $errorD=0; $execomID = $row['execom_id']; echo "<tr>"; echo "<td style='width:10%'>".$row['id']."</td>"; echo "<td style='width:10%'>".$row['canvass_sheet_creation_ts']."</td>"; echo "<td style='width:10%'>".$curDateTime."</td>"; $startDate = strtotime($prfDate); $EndDate = strtotime($row['canvass_sheet_creation_ts']); $datediff = $startDate - $EndDate; $mandays = round($datediff / (60 * 60 * 24)); echo "<td style='width:10%'>".$mandays."</td>"; echo "<td style='width:10%'>"; if($mandays ==0){ echo "Active"; } if($mandays ==1){ echo "Sending FF Reminder 1"; } if($mandays ==2){ //############################################################################################################## $exeApproverEmail =mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$execomID'"),0); //SEND EMAIL NOTIFICATIONS $from = "support@autohub.ph"; $to = $exeApproverEmail; $subject = "PENDING CANVASS APPROVAL"; $SMSMessage = "This is to remind you of your pending CANVASS APPROVAL. The system will Automatically approve this request within 48 hours. please login to your ASA APP for more details. Thank you!"; $headers = "From:" . $from; mail($to,$subject,$SMSMessage, $headers); //######################################END OF EMAIL $exeApproverMobile =mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$execomID'"),0); $result = itexmoAA($exeApproverMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo '<script>alert("No response from SMS server. SMS failed to send")</script>'; }else if ($result == 0){ //echo "SMS Sent!"; }else{ //echo "Error Num ". $result . " was encountered!"; } //NOTIFICATION####################################################### } if($mandays ==3){ //############################################################################################################## $exeApproverEmail =mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$execomID'"),0); //SEND EMAIL NOTIFICATIONS $from = "support@autohub.ph"; $to = $exeApproverEmail; $subject = "PENDING CANVASS APPROVAL"; $SMSMessage = "This is to remind you of your pending CANVASS APPROVAL. The system will Automatically approve this request within 24 hours. please login to your ASA APP for more details. Thank you!"; $headers = "From:" . $from; mail($to,$subject,$SMSMessage, $headers); //######################################END OF EMAIL NOTIFICATION####################################################### $exeApproverMobile =mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$execomID'"),0); $result = itexmoAA($exeApproverMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo '<script>alert("No response from SMS server. SMS failed to send")</script>'; }else if ($result == 0){ //echo "SMS Sent!"; }else{ //echo "Error Num ". $result . " was encountered!"; } } if($mandays > 3){ echo "Execute Automation "; } echo "</td>"; echo "<td style='width:10%'>"; $itemID = $row['id']; $getItemAmountFromCanvassSheet = mysql_result(mysql_query("SELECT MIN(`amount`) FROM `prf_canvass_sheet` WHERE `item_id`='$itemID' AND `user_feedback`=1"),0); echo $itemID . " \| "; $chckIfWithApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); $aprMatrix = mysql_result(mysql_query("SELECT `level` FROM `prf_approval_matrix` WHERE '$getItemAmountFromCanvassSheet' BETWEEN `min_amount` AND `max_amount`"),0); echo "My Matrix: ". $aprMatrix ."<br>"; if($aprMatrix < 5){ //execom approval if($chckIfWithApproval > 0){ //execute automated approval //echo $chckIfWithApproval; $approvedQTY = mysql_result(mysql_query("SELECT `canvass_qty` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); $approvedAmount= mysql_result(mysql_query("SELECT `approved_amount` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); $approvedVendorID= mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); $approvedCanvassID= mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' AND `approved_by_execom`='$getRequiredApproverID'"),0); echo "<br>".$approvedQTY. "<br>"; echo $approvedAmount. "<br>"; echo $approvedVendorID. "<br>"; echo $approvedCanvassID. "<br>"; if($approvedVendorID ==''){$errorD=$errorD + 1;} if($approvedCanvassID ==''){$errorD=$errorD + 1;} if($errorD == 0){ mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$curDateTime', `awarded`=1, `award_to_vendor_id`='$approvedVendorID', `approved_proposal_code`='$approvedCanvassID',`approved_qty`='$approvedQTY',`approved_amount`='$approvedAmount',`item_status`=7,`approval_type`='auto' WHERE `id`='$itemID'"); mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `item_id`='$itemID' AND `link` LIKE '%exapr.php%'"); } }else{ echo "Pending ".$chckIfWithApproval; } }else{ //department head approval $approvedQTY = mysql_result(mysql_query("SELECT `quantity` FROM `prf_canvass_sheet` WHERE `item_id`='$itemID' AND `user_feedback`=1"),0); $approvedAmount=mysql_result(mysql_query("SELECT `amount` FROM `prf_canvass_sheet` WHERE `item_id`='$itemID' AND `user_feedback`=1"),0); $approvedCanvassID= mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `item_id`='$itemID' AND `user_feedback`=1"),0); $approvedVendorID= mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_uploadedcanvass` WHERE `id`='$approvedCanvassID'"),0); echo "<br>QTY:".$approvedQTY; echo "<br>Amount:".$approvedAmount; echo "<br>Vendor:".$approvedVendorID; echo "<br>Canvass:".$approvedCanvassID; if($approvedVendorID ==''){$errorC=$errorC + 1;} if($approvedCanvassID ==''){$errorC=$errorC + 1;} if($errorC == 0){ mysql_query("UPDATE `prf_request_detl` SET `execom_approval_ts`='$curDateTime', `awarded`=1, `award_to_vendor_id`='$approvedVendorID', `approved_proposal_code`='$approvedCanvassID',`approved_qty`='$approvedQTY',`approved_amount`='$approvedAmount',`item_status`=7,`approval_type`='auto' WHERE `id`='$itemID'"); mysql_query("UPDATE `prf_validate_links` SET `completed`=1 WHERE `item_id`='$itemID' AND `link` LIKE '%exapr.php%'"); } } echo "</td>"; echo "</tr>"; } ?> </table> </div> </div> </div> </body> </html> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== $("#saveForm").click(function(){ var MyVendorCode = $("#MyVendorCode").val(); var vendorName = $("#vendorName").val(); var vendorTerm = $("#vendorTerm").val(); var vendorTIN = $("#vendorTIN").val(); var vendorAddress = $("#vendorAddress").val(); var vendorFax = $("#vendorFax").val(); var vendorLandline = $("#vendorLandline").val(); var vendorContactPerson = $("#vendorContactPerson").val(); var vendorMobile = $("#vendorMobile").val(); var vendorEmail = $("#vendorEmail").val(); var vendorNotes = $("#vendorNotes").val(); //alert(MyVendorCode); if(MyVendorCode==''){ alert('ERROR: Invalid Vendor Code'); exit; } if(vendorName==''){ alert('ERROR: Vendor name is required.'); exit; } if(vendorName==''){ alert('ERROR: Vendor name is required.'); exit; } if(vendorEmail==''){ alert('ERROR: E-mail address is required'); exit; } if(vendorMobile==''){ alert('ERROR: Mobile number s is required'); exit; } ShowUploadBar(); $.ajax({ url: "prf_saveNewSupplier.php", type: "POST", async: false, data: { "MyVendorCode": MyVendorCode, "vendorNotes": vendorNotes, "vendorName": vendorName, "vendorTerm": vendorTerm, "vendorTIN": vendorTIN, "vendorAddress": vendorAddress, "vendorFax": vendorFax, "vendorLandline": vendorLandline, "vendorContactPerson": vendorContactPerson, "vendorMobile": vendorMobile, "vendorEmail": vendorEmail, "done": 1 }, success: function(d){ ShowUploadBar(); hideAddVendorForm(); $("#displaySupplier").html(d); //showSaveForm(); //hideSaveForm(); } }) }); }); </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> function hideActionSlipForm(){ $("#PRFCreateNewRequest").fadeOut(500); }; function showActionSlipForm(){ $("#PRFCreateNewRequest").fadeIn(500); }; </script>

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