File manager - Edit - /home/autoph/public_html/connect/home/prf_userRecanvassRequest.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"); $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'])){ $selectedRecordID = mysql_escape_string($_POST['selectedRecordID']); mysql_query("UPDATE `prf_request_detl` SET `user_canvass_approval` = '0', `user_approval_ts` = '', `item_status` = 4 WHERE `id` = '$selectedRecordID'"); exit(); } ?> <div style='width:100%;height:30px;background:white'> <table> <thead> <th style='width:10%'>REC. NO</th> <th style='width:65%'>ITEM DESCRIPTION</th> <th style='width:10%'>QUANTITY</th> <th style='width:5%'>UOM</th> <th style='width:10%;text-align:right'>DATE NEEDED</th> </thead> </table> </div> <div class='PRFTableItems' style='padding:0px;background:white'> <table id='LoadActiveCanvassForUserApproval' > <?php $getItemInfo = mysql_query(" SELECT prf_request_detl.id, prf_request_hdr.reference_code, prf_request_hdr.`comp_id`, prf_request_hdr.`deal_id`, prf_request_hdr.category_id, prf_request_hdr.sub_category_id, prf_request_hdr.date_needed, prf_request_hdr.request_by, prf_request_detl.header_ref_code, prf_request_detl.item_description, prf_request_detl.uom, prf_canvass_sheet.item_id, prf_canvass_sheet.canvass_id, prf_uploadedcanvass.`ref_code`, prf_canvass_sheet.quantity, prf_canvass_sheet.amount, prf_canvass_sheet.item_id, prf_uploadedcanvass.`vendor_id`, prf_uploadedcanvass.`vendor_code`, prf_uploadedcanvass.`vendor_name`, prf_uploadedcanvass.`file_code` FROM `prf_request_hdr` JOIN `prf_request_detl` ON prf_request_detl.`header_ref_code` = prf_request_hdr.reference_code JOIN prf_canvass_sheet ON prf_canvass_sheet.item_id = prf_request_detl.id JOIN prf_uploadedcanvass ON prf_uploadedcanvass.`id` = prf_canvass_sheet.`canvass_id` WHERE prf_request_hdr.request_by='$uniqueRefID' AND `user_canvass_approval`=1 AND `user_approval_ts`='' AND `create_canvass_sheet`= 0 GROUP BY prf_canvass_sheet.item_id ORDER BY prf_request_detl.item_description ASC "); while($row=mysql_fetch_array($getItemInfo)){ $cvFileCode = $row['file_code']; ?><tr onclick="javascript:getUserActionInfo(this);" ><?php echo "<td style='width:10%'>".$row['id']."</td>"; echo "<td style='width:65%'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:10%;text-align:center'>".$row['quantity']."</td>"; echo "<td style='width:5%;text-align:center'>".strtoupper($row['uom'])."</td>"; echo "<td style='width:10%;text-align:right'>".$row['date_needed']."</td>"; echo "</tr>"; } ?> <tr><td colspan='9' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='9' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-weight:bold'> <input type='hidden' id='selectedRecordID' class='TableBottomLabel'> <p style='float:left;width:auto;padding-right:10px'>Selected Record:</p> <p style='float:left:width:70%;font-family:Yu Gothic Light;color:gray' id='selectedPRFHeaderIDLabel'></p> </td> </tr> </table> </div>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings