File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_PostNewDISAPPROVED.php

Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $fullDateTime =$prfDate . " ".$prfTime; $myDate = date_create() ->format("Y-m-d"); $uniqueRefID=$user_data['u_id']; $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); if(isset($_POST['done'])){ $UpdateReferenceHeaderCode = mysql_escape_string($_POST['UpdateReferenceHeaderCode']); $DisApprovalCode = mysql_escape_string($_POST['DisApprovalCode']); $requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); mysql_query("UPDATE prf_request_hdr SET current_status = $DisApprovalCode WHERE reference_code='$UpdateReferenceHeaderCode'"); switch($DisApprovalCode){ case '91': // next is GM $deptHeadID = mysql_result(mysql_query("SELECT `approving_GM_id` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); mysql_query("UPDATE prf_request_hdr SET dept_approval_date = $fullDateTime WHERE reference_code='$UpdateReferenceHeaderCode'"); break; case '92': // Authorizing Departmente, Checking Asset $deptHeadID = mysql_result(mysql_query("SELECT `authorizing_dept_id` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); mysql_query("UPDATE prf_request_hdr SET gm_approval_date = $fullDateTime WHERE reference_code='$UpdateReferenceHeaderCode'"); break; case '93': // Admin Approval before canvass $deptHeadID = mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); mysql_query("UPDATE prf_request_hdr SET authorizing_approval_date = $fullDateTime WHERE reference_code='$UpdateReferenceHeaderCode'"); break; case '94': // Admin Approval before canvass $deptHeadID = mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); mysql_query("UPDATE prf_request_hdr SET admin_approval_date = $fullDateTime WHERE reference_code='$UpdateReferenceHeaderCode'"); break; } $empUFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$requestorID'"),0); $empULname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$requestorID'"),0); $deptheadMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$requestorID'"),0); $deptHeadEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$requestorID'"),0); //######################################################################################################################### mysql_query("INSERT INTO prf_ff_message(ref_code,sender_id,message,send_to,sms,email,date,time) VALUES('{$UpdateReferenceHeaderCode}','{$uniqueRefID}','Your purchase request with reference # ".$UpdateReferenceHeaderCode." has been disapproved','{$requestorID}','sms','email','{$prfDate}','{$prfTime}')"); //######################################################################################################################### //######################################################################################################################### //######################################################################################################################### $SMSMessage = "Hi ". $empUFname. "! ". " Your purchase request with reference number ".$UpdateReferenceHeaderCode." has been disapproved."; $result = itexmo($deptheadMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo '<script>alert("Transaction complete but SMS notification failed.")</script>'; }else if ($result == 0){ //echo "SMS Sent!"; } else{ //echo "Error Num ". $result . " was encountered!"; } //######################################################################################################################### //######################################################################################################################### $from = "support@autohubgroup.com"; $to = $deptHeadEmail; $headersH = "From:" . $from; $subject = "NEW PURCHASE REQUEST"; $msgBox = "Hi ".$empUFname."! Your purchase request with reference number ".$UpdateReferenceHeaderCode." has been disapproved. Autohub Support"; mail($to,$subject,$msgBox, $headersH); //######################################################################################################################### //######################################################################################################################### } ?> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:3%'>NO</th> <th style='width:10%'>REF. CODE</th> <th style='width:7%'>DATE</th> <th style='width:18%'>COMPANY</th> <th style='width:15%'>DEALER</th> <th style='width:14%'>REQ. CATEGOY</th> <th style='width:15%'>REQ. TYPE</th> <th style='width:14%'>STATUS</th> <th style='width:5%'></th> </thead> </table> </div> <div class='PRFTableItems'> <table> <?php //$getItemHdr = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `deleted`=0 AND `request_by`='$uniqueRefID' AND `current_status` = 1 ORDER BY id DESC"); $getItemHdrDeptHead = mysql_query("SELECT FROM `prf_request_hdr` WHERE `dept_head_id` ='$uniqueRefID' AND `current_status`=1 AND `deleted`=0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdrDeptHead)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?><tr onclick="javascript:showPRFUpdateA(this);" onDblclick="javascript:showFollowUp(this);" ><?php echo "<td style='width:3%'>".$count."</td>"; echo "<td style='width:10%'>".strtoupper($row['reference_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['date_created'])."</td>"; echo "<td style='width:18%'>".strtoupper($prfCompName)."</td>"; echo "<td style='width:15%'>".strtoupper($prfDealName)."</td>"; echo "<td style='width:14%'>".strtoupper($prfCatName)."</td>"; echo "<td style='width:15%'>".strtoupper($prfSubCatName)."</td>"; echo "<td style='width:14%;font-family:Yu Gothic;font-weight:normal;color:blue;font-size:12px'>"; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo"</td>"; echo "<td style='width:5%;text-align:center;font-size:14px;padding:3px'>"; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "<b style='text-shadow:0 0 5px red;font-size:13px'>".$withMail."</b>"; }else{ echo $noMail; } echo"</td>"; echo "</tr>"; } //################################################################################################################################################################################## //FOR GM APPROVAL APPEND TO TABLE $getItemHdrGM = mysql_query("SELECT FROM `prf_request_hdr` WHERE `approving_GM_id` ='$uniqueRefID' AND `current_status`= 2 AND `deleted`=0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdrGM)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?><tr onclick="javascript:showPRFUpdateB(this);" onDblclick="javascript:showFollowUp(this);" ><?php echo "<td style='width:3%'>".$count."</td>"; echo "<td style='width:10%'>".strtoupper($row['reference_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['date_created'])."</td>"; echo "<td style='width:18%'>".strtoupper($prfCompName)."</td>"; echo "<td style='width:15%'>".strtoupper($prfDealName)."</td>"; echo "<td style='width:14%'>".strtoupper($prfCatName)."</td>"; echo "<td style='width:15%'>".strtoupper($prfSubCatName)."</td>"; echo "<td style='width:14%;font-family:Yu Gothic;font-weight:normal;color:blue;font-size:12px'>"; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo"</td>"; echo "<td style='width:5%;text-align:center;font-size:14px;padding:3px'>"; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "<b style='text-shadow:0 0 5px red;font-size:13px'>".$withMail."</b>"; }else{ echo $noMail; } echo"</td>"; echo "</tr>"; } //################################################################################################################################################################################## //AUTHORIZE $getItemHdrAsset = mysql_query("SELECT FROM `prf_request_hdr` WHERE `authorizing_dept_id` ='$uniqueRefID' AND `current_status`= 3 AND `deleted`=0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdrAsset)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?><tr onclick="javascript:showPRFUpdateC(this);" onDblclick="javascript:showFollowUp(this);" ><?php echo "<td style='width:3%'>".$count."</td>"; echo "<td style='width:10%'>".strtoupper($row['reference_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['date_created'])."</td>"; echo "<td style='width:18%'>".strtoupper($prfCompName)."</td>"; echo "<td style='width:15%'>".strtoupper($prfDealName)."</td>"; echo "<td style='width:14%'>".strtoupper($prfCatName)."</td>"; echo "<td style='width:15%'>".strtoupper($prfSubCatName)."</td>"; echo "<td style='width:14%;font-family:Yu Gothic;font-weight:normal;color:blue;font-size:12px'>"; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo"</td>"; echo "<td style='width:5%;text-align:center;font-size:14px;padding:3px'>"; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "<b style='text-shadow:0 0 5px red;font-size:13px'>".$withMail."</b>"; }else{ echo $noMail; } echo"</td>"; echo "</tr>"; } //################################################################################################################################################################################## //ADMIN DEPARTMENT $getItemHdrAsset = mysql_query("SELECT FROM `prf_request_hdr` WHERE `approving_admin_id` ='$uniqueRefID' AND `current_status`= 4 AND `deleted`=0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdrAsset)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?><tr onclick="javascript:showPRFUpdateD(this);" onDblclick="javascript:showFollowUp(this);" ><?php echo "<td style='width:3%'>".$count."</td>"; echo "<td style='width:10%'>".strtoupper($row['reference_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['date_created'])."</td>"; echo "<td style='width:18%'>".strtoupper($prfCompName)."</td>"; echo "<td style='width:15%'>".strtoupper($prfDealName)."</td>"; echo "<td style='width:14%'>".strtoupper($prfCatName)."</td>"; echo "<td style='width:15%'>".strtoupper($prfSubCatName)."</td>"; echo "<td style='width:14%;font-family:Yu Gothic;font-weight:normal;color:blue;font-size:12px'>"; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo"</td>"; echo "<td style='width:5%;text-align:center;font-size:14px;padding:3px'>"; $checkUnReadMail = 1; $withMail ='📩'; $noMail = '✉'; if($checkUnReadMail > 0){ echo "<b style='text-shadow:0 0 5px red;font-size:13px'>".$withMail."</b>"; }else{ echo $noMail; } echo"</td>"; echo "</tr>"; } //################################################################################################################################################################################## ?> <tr><td colspan='9' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='3' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-weight:normal'>Selected Record:</td> <td colspan='6' style='background:white;'> <input type='hidden' id='selectedPRFHeaderID' class='TableBottomLabel'> <input disabled type='text' id='selectedPRFHeaderIDLabel' style='background:white;border:0px;font-family:Yu Gothic;font-size:14px;color: #f97d43 ;font-weight:normal'> </td> </tr> </table> </div>

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