File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF_ENDORSECanvassToUserForApproval.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'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; $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'])){ $ItemRecordID = mysql_escape_string($_POST['ItemRecordID']); $cvssID = mysql_result(mysql_query("SELECT `id` FROM `prf_uploadedcanvass` WHERE `ref_code`='$ENmyCanvassCode'"),0); //mysql_query("UPDATE `prf_request_detl` SET `user_canvass_approval`='1',`item_status` = '5' WHERE `id`='$ItemRecordID'"); mysql_query("UPDATE `prf_request_detl` SET `user_canvass_approval`='1',`approved_canvass`='1',`item_status` = '5' WHERE `id`='$ItemRecordID'"); $refCodeID = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$ItemRecordID'"),0); mysql_query("UPDATE `prf_request_hdr` SET `current_status='5' WHERE `reference_code`='$refCodeID'"); $requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$refCodeID'"),0); $Message ='Canvass sheet has been routed to user for approval'; mysql_query("INSERT INTO prf_ff_message(ref_code,sender_id,message,send_to,sms,email,date,time) VALUES('{$refCodeID}','{$uniqueRefID}','{$Message}','{$requestorID}','sms','email','{$prfDate}','{$prfTime}')"); //$SMSMessage = "Canvass Sheet has been routed to your for your review and approval. Please login to your ASA Portal to process this request."; //$empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$requestorID'"),0); //$empEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$requestorID'"),0); //$empFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$requestorID'"),0); //$result = itexmo($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd); //$result = itexmoAA($empMobile, $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!"; //} //######################################MAIL SENDER####################################################### //######################################MAIL SENDER####################################################### $from = "support@autohub.ph"; $to = $empEmail; $subject = "APPROVAL OF CANVASS"; $msgBox = "Hi ".$empFName."! Canvass Sheet has been routed to you for your review and approval. Please login to https://autohub.ph/connect to process this transaction."; $headers = "From:" . $from; mail($to,$subject,$msgBox, $headers); //######################################MAIL SENDER####################################################### } ?> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:5%'>REC. NO</th> <th style='width:10%'>REF. CODE</th> <th style='width:10%'>REQ. DATE</th> <th style='width:10%'>COMPANY</th> <th style='width:35%'>ITEM DESC</th> <th style='width:5%'>QTY</th> <th style='width:15%'>REQUEST BY</th> <th style='width:20%'>CANVASS</th> </thead> </table> </div> <div class='PRFTableItems'> <table> <?php //$getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 ORDER BY id DESC"); $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `ahg_admin_date`!='' AND `canvass_by`='$uniqueRefID' ORDER BY `ahg_admin_date` ASC"); while($row=mysql_fetch_array($getItemHdr)){ $itemRefCode=$row['header_ref_code']; $Cat = $row['category_id']; $SubCat = $row['sub_category_id']; $CatName = mysql_result(mysql_query("SELECT description FROM prf_expensecategory WHERE id='$Cat'"),0); $SubCatName = mysql_result(mysql_query("SELECT description FROM prf_expenseitems WHERE id='$SubCat'"),0); $compCode = mysql_result(mysql_query("SELECT comp_code FROM vts_company WHERE comp_id='".$row['comp_id']."'"),0); $dealCode = mysql_result(mysql_query("SELECT deal_code FROM vts_dealerships WHERE deal_id='".$row['dealer_id']."'"),0); $reqBy = mysql_result(mysql_query("SELECT request_by FROM prf_request_hdr WHERE reference_code='$itemRefCode'"),0); $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$reqBy'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$reqBy'"),0); $getPRFApprovalCode = mysql_result(mysql_query("SELECT current_status FROM prf_request_hdr WHERE reference_code='$itemRefCode' "),0); if($getPRFApprovalCode == 4){ ?><tr onclick="javascript:showPRFheaderForDeletion(this);" onDblclick="javascript:showActionViewDelete(this);" ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:10%'>".strtoupper($row['header_ref_code'])."</td>"; echo "<td style='width:10%'>".strtoupper($row['date_created'])."</td>"; echo "<td style='width:10%'>".strtoupper($dealCode)."</td>"; echo "<td style='width:35%;text-align:left'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:5%;text-align:center'>".strtoupper($row['quantity'])."</td>"; echo "<td style='width:15%'>".strtoupper($reqByLName).", ".strtoupper($reqByFName)."</td>"; echo "<td style='width:20%'>"; 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