File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_searchForCanvass.php

Back
<?php include 'core/init.php'; protected_page(); $uniqueRefID = $user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; $NewRefCode = $refMonth.''.$refMinute.''.$refSecond; if(isset($_POST['done'])){ $searchText = mysql_escape_string($_POST['searchText']); //$filterBuyerID = mysql_escape_string($_POST['filterBuyerID']); $searchTXT=trim(str_replace(' ', '', $searchText)); $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 `header_ref_code`='$searchTXT' AND `item_status`=4 ORDER BY `ahg_admin_date` ASC"); } ?> <!DOCTYPE html> <div style='width:120%;height:33px;background:white'> <table <thead> <th style='width:5%'>REC. NO</th> <th style='width:7%'>REF. CODE</th> <th style='width:7%'>REQ. DATE</th> <th style='width:7%'>COMPANY</th> <th style='width:35%'>ITEM DESC</th> <th style='width:5%'>QTY</th> <th style='width:8%'>REQUEST BY</th> <th style='width:8%'>CANVASS BY</th> <th style='width:13%'>CATEGORY</th> <th style='width:5%'>DOC</th> </thead> </table> </div> <div class='PRFTableItems' id='reloadCanvassItem' style='width:120%'> <table> <?php while($row=mysql_fetch_array($getItemHdr)){ $itemRefCode=$row['header_ref_code']; $attDoc =mysql_result(mysql_query("SELECT `attachment` FROM `prf_request_hdr` WHERE `reference_code`='$itemRefCode'"),0); $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); $canBy = $row['canvass_by']; $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); $picTS = $row['date_time_pick']; $canByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$canBy'"),0); $canByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$canBy'"),0); $getPRFApprovalCode = mysql_result(mysql_query("SELECT current_status FROM prf_request_hdr WHERE reference_code='$itemRefCode' "),0); //if($getPRFApprovalCode == 4){ //onDblclick="javascript:showActionViewDelete(this);" ?><tr onclick="javascript:showPRFheaderForDeletion(this);" ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:7%'>".strtoupper($row['header_ref_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['ahg_admin_date'])."</td>"; echo "<td style='width:7%'>".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:8%'>".strtoupper($reqByLName).", ".strtoupper($reqByFName)."</td>"; echo "<td style='width:8%'>".strtoupper($canByLName).", ".strtoupper($canByFName)."<br>".$picTS."</td>"; echo "<td style='width:13%'>".strtoupper($CatName)."</td>"; echo "<td style='width:5%;text-align:center;font-size:14px;padding:3px'>"; $chkAttachment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $withMail ='📝'; $attFilename = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $noMail = '-'; if($chkAttachment > 0){ echo "<a href='FILES/prfdoc/".$attFilename."' target='_Blank'><abbr title='View Attached document'>📑</abbr></a>"; }else{ echo $noMail; } echo"</td>"; echo "</tr>"; //} } ?> <tr><td colspan='10' ><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='7' style='background:white;'> <input type='hidden' id='selectedPRFHeaderID' class='TableBottomLabel'> <input disabled type='hidden' 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