File manager - Edit - /home/autoph/public_html/connect/home/activePOList.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_purchase_order` WHERE `po_status`= 4 ORDER BY `id` DESC LIMIT $start, $limit"); }else{ $getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 4 AND `po_number`='$infCanvass' ORDER BY `id` DESC"); } while($row=mysql_fetch_array($getItemHdr)){ $vendorID = $row['vendor_id']; $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $reqCompID=$row['comp_id']; $reqDealID=$row['dealer_id']; $reqCompName = mysql_result(mysql_query("SELECT `comp_code` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqDealName = mysql_result(mysql_query("SELECT `deal_code` FROM vts_dealerships WHERE deal_id='$reqDealID'"),0); $myTokenID = $row['token']; $poNote = $row['delivery_note']; if($poNote ==='Full Delivery'){ $deliverNote = "<b style='font-family:Yu Gothic Light;font-weight:bold;color:blue'>FD</b>"; $pdColor ='#ddfc9f'; }else if($poNote ==='Waiting For Delivery'){ $deliverNote = "<b style='font-family:Yu Gothic Light;font-weight:bold;color:blue'>WD</b>"; $pdColor ='#ddfc9f'; }else{ $deliverNote = "<b style='font-family:Yu Gothic Light;font-weight:bold;color:blue'>PD</b>"; $pdColor ='#fccaba'; } ?><tr onclick="javasctipt:getInfo(this);" ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:10%'>".$row['po_number']."</td>"; echo "<td style='width:8%'>".$row['date_posted']."</td>"; echo "<td style='width:10%'>".$reqCompName."</td>"; echo "<td style='width:10%'>".$reqDealName."</td>"; echo "<td style='width:21%'>".$vendorName."</td>"; echo "<td style='width:5%'>".$row['terms']." Days</td>"; echo "<td style='width:10%'>"; $poStat = mysql_result(mysql_query("SELECT `po_status` FROM `prf_po_status` WHERE `po_code`='".$row['po_status']."'"),0); echo $poStat; echo"</td>"; echo "<td style='width:15%'>".$row['remarks']."</td>"; echo "<td style='width:3%;background:$pdColor;text-align:center;'>"; echo $deliverNote; echo"</td>"; echo "<td style='width:3%;background:transaparent;text-align:center;'> <a href='poapr.php?id=".$row['po_number']."&uid=".$uniqueRefID."&token=".$myTokenID."' target='_Blank' styl='font-family:Yu Gothic Light;font-size:14px;font-weight:normal;color:red;'>📑</a></td>"; echo "</tr>"; } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings