File manager - Edit - /home/autoph/public_html/connect/home/PRF_LOADCanvassListForUserApproval.php
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $selectedRecordID = mysql_escape_string($_POST['selectedRecordID']); } ?> <div style='width:100%;height:30px;background:yellow'> <table> <thead> <th style='width:7%'>REC#</th> <th style='width:10%'>RANK</th> <th style='width:45%'>SUPPLIER'S NAME</th> <th style='width:7%'>QTY</th> <th style='width:10%;text-align:right'>AMOUNT</th> <th style='width:15%;text-align:left'>ACTION</th> <th style='width:6%'>VIEW</th> </thead> </table> </div> <div class='PRFTableItems' style='padding:0px;background:white;height:198px'> <table> <?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.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_detl.`user_canvass_approval`=1 AND prf_canvass_sheet.item_id='$selectedRecordID' ORDER BY prf_canvass_sheet.amount ASC "); while($row=mysql_fetch_array($getItemInfo)){ $cvFileCode = $row['file_code']; $order = $order + 1; ?><tr onclick="javascript:getSelectedCanvassInfo(this);"><?php echo "<td style='width:7%'>".$row['id']."</td>"; echo "<td style='width:10%'>Rank # ".$order."</td>"; echo "<td style='width:45%'>".strtoupper($row['vendor_name'])."</td>"; echo "<td style='width:7%;text-align:center'>".$row['quantity']."</td>"; echo "<td style='width:10%;text-align:right'>".$row['amount']."</td>"; echo "<td style='width:15%;text-align:right'>"; echo "<select name='ApprovingPri[]' class='userReco' id='". $row['id']."' style='margin:0px;padding:0px;border:1px solid lightgray'>"; $getRecoData = mysql_query("SELECT * FROM `prf_user_recommendation` WHERE `deleted`=0 ORDER BY `code` ASC"); echo "<option value='0'>--Select--</option>"; while($rRow = mysql_fetch_array($getRecoData)){ echo "<option value='".$rRow['code']."'>".$rRow['desc']."</option>"; } echo "</select>"; echo "</td>"; echo "<td style='width:6%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$cvFileCode."' target='_blank'>📑</a></td>"; echo "</tr>"; } ?> </table> </div> <input type='hidden' id='selectedCanvassSheetID'> <!--- 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(){ $('.userReco').bind("change",function(){ var canvassRecoValue = $(this).val(); var selectedCanvassSheetID = $("#selectedCanvassSheetID").val(); //alert(selectedCanvassSheetID); //exit; $.ajax({ url: "PRF_UPDATE_CanvassSheetUserRecommendataion.php", type: "POST", async: true, data: { "canvassRecoValue": canvassRecoValue, "selectedCanvassSheetID": selectedCanvassSheetID, "done": 1 }, success: function(d){ // $("#templateUpdateMSG").html(d); } }) }); }); function getSelectedCanvassInfo(row) { var x=row.cells; document.getElementById("selectedCanvassSheetID").value = x[0].innerHTML; } </script>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings