File manager

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

Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; if(isset($_POST['done'])){ $SeletedPRFItemID = mysql_escape_string($_POST['SeletedPRFItemID']); $refCodeID = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$SeletedPRFItemID'"),0); $token = md5(md5($SeletedPRFItemID)); mysql_query("UPDATE `prf_request_detl` SET `for_execom_canvass_approval`='1',`item_status`='6',`execom_token`='$token',`canvass_sheet_creation_ts`='$prfDateTime' WHERE `id`='$SeletedPRFItemID'"); mysql_query("UPDATE `prf_request_hdr` SET `current_status`='6' WHERE `reference_code`='$refCodeID'"); $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); $requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$refCodeID'"),0); $itemDes = mysql_result(mysql_query("SELECT `item_description` FROM `prf_request_detl` WHERE `id`='$SeletedPRFItemID'"),0); $messageToReq ="You ".$itemDes." request has been routed to EXECOM for approval"; mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time) VALUES('{$refCodeID}','{$myUID}','{$messageToReq}','{$requestorID}','{$myDate}','{$prfTime}')"); $getExecomMembers=mysql_query("SELECT vts_users.`u_id`,vts_users.`u_fname`,vts_users.`u_lname`,vts_users.`usr_mobile`,vts_users.`email`, prf_execommembers.`comp_id`,prf_execommembers.`execom_id`,prf_execommembers.`authority` FROM prf_execommembers JOIN vts_users ON vts_users.`u_id` = prf_execommembers.`execom_id` WHERE prf_execommembers.`deleted`=0"); while($xRow = mysql_fetch_array($getExecomMembers)){ $exID = $xRow['u_id']; $randomCode = rand(10,9999).$exID; $exEmail = $xRow['email']; $empFName = $xRow['u_fname']; $valLink ="exapr.php?uid=".$exID."&token=".$token."&id=".$SeletedPRFItemID; $SMSMessage = "Purchase request has been routed to you for EXECOM Approval https://www.autohub.ph/xcom.php?c=".$randomCode; $empMobile = $xRow['usr_mobile']; //$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!"; } //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### $from = "support@autohub.ph"; $to = $exEmail; $subject = "FOR EXECOM APPROVAL"; $headers = "From:" . $from; mail($to,$subject,$SMSMessage, $headers); //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### //####################################################################### //####################################################################### mysql_query("INSERT INTO `prf_validate_links`(`code`,`link`,`po_code`,`uid`,`item_id`) VALUES('{$randomCode}','{$valLink}','{$refCodeID}','{$exID}','{$SeletedPRFItemID}')"); //####################################################################### //####################################################################### } ?> <div id='mainTable' class='PRFTableBody'> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:5%'>REC.#</th> <th style='width:20%'>COMPANY</th> <th style='width:15%'>REQUESTOR</th> <th style='width:30%'>ITEM DESCRIPTION</th> <th style='width:15%'>CATEGORY</th> <th style='width:5%'>QTY</th> <th style='width:10%'>DATE NEEDED</th> </thead> </table> </div> <div class='PRFTableItems'> <table> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `create_canvass_sheet`= 1 AND `deleted`=0 AND `awarded`='0' AND `for_execom_canvass_approval`=0 AND `canvass_sheet_creation_ts`=''"); while($row=mysql_fetch_array($getItemHdr)){ $regHDRcode=$row['header_ref_code']; $regCat=$row['category_id']; $regCatName =mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$regCat'"),0); $reqByID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); $reqCompID=$row['comp_id']; $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); $reqCompName = mysql_result(mysql_query("SELECT `comp_name` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$reqByID'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$reqByID'"),0); ?><tr onclick="javascript:getInfo(this);" id='LoadUserApprovedCanvassItem' ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:20%'>".strtoupper($reqCompName)."</td>"; echo "<td style='width:15%'>".strtoupper($reqByLName).", ".strtoupper($reqByFName)."</td>"; echo "<td style='width:30%;text-align:left'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:15%;text-align:left'>".$regCatName."</td>"; echo "<td style='width:5%;text-align:left'>".strtoupper($row['quantity'])."</td>"; echo "<td style='width:10%'>".strtoupper($dateNeeded)."</td>"; //echo "<td style='width:5%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$row['file_code']."' target='_blank'>View</a></td>"; echo "</tr>"; } ?> <tr><td colspan='9' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='2' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-weight:normal'>Selected Record:</td> <td colspan='7' style='background:white;'> <input type='text' id='selectedPRFHeaderID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> </td> </tr> </table> </div> </div> <?php }?>

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