File manager - Edit - /home/autoph/public_html/connect/home/PRF_UnAssignedCanvass.php
Back
<?php include 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['getData'])){ $start = mysql_real_escape_string($_POST['start']); $limit = mysql_real_escape_string($_POST['limit']); $infCanvass = mysql_real_escape_string($_POST['infCanvass']); if($infCanvass=='' || $infCanvass == null){ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval`=0 AND `item_status`=4 AND `canvass_by`=0 AND `ahg_admin_id`!=0 ORDER BY `ahg_admin_date` ASC LIMIT $start, $limit"); //SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval` = 0 AND `item_status`=4 AND `canvass_by`=0 }else{ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval`=0 AND `item_status`=4 AND `canvass_by`=0 AND `header_ref_code`='$infCanvass' AND `ahg_admin_id`!=0 ORDER BY `ahg_admin_date` ASC"); } 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:8%'>".strtoupper($row['ahg_admin_date'])."</td>"; echo "<td style='width:7%'>".strtoupper($dealCode)."</td>"; echo "<td style='width:40%;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:12%'>".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>"; //} } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings