File manager - Edit - /home/autoph/public_html/connect/home/prf_loadActivePO.php
Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; //$myUID = $user_data['u_id']; if(isset($_POST['done'])){ $MyPageCount = mysql_escape_string($_POST['MyPageCount']); $myOffSet = mysql_escape_string($_POST['myOffSet']); $MyRowCount = mysql_escape_string($_POST['MyRowCount']); $CurrentpageCount = mysql_escape_string($_POST['CurrentpageCount']); $recordPerPage = mysql_escape_string($_POST['recordPerPage']); ?> <table> <?php //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### $totalRows = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`=1 "),0); $noOfRecordPerPage = mysql_result(mysql_query("SELECT `page_count` FROM `asa_versioning_db` WHERE 1"),0); $myPageCount = ceil($totalRows / $noOfRecordPerPage); $offSet = ($myPageCount-1) * $noOfRecordPerPage; echo "<input type='hidden' id='MyPageCount' value='".$myPageCount."'>"; echo "<input type='hidden' id='MyRowCount' value='".$totalRows."'>"; echo "<input type='hidden' id='myOffSet' value='".$offSet."'>"; echo "<input type='hidden' id='recordPerPage' value='".$noOfRecordPerPage."'>"; //####################################################################################################### //####################################################################################################### $getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 1 || `po_status`= 0 ORDER BY `id` DESC LIMIT $offSet, $noOfRecordPerPage "); //$getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 1"); 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); ?><tr onclick="javascript:showPOActionaForm(this);" id='LoadUserApprovedCanvassItem' ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:15%'>".$row['po_number']."</td>"; echo "<td style='width:15%'>".$reqCompName."</td>"; echo "<td style='width:15%'>".$reqDealName."</td>"; echo "<td style='width:20%'>".$vendorName."</td>"; echo "<td style='width:15%'>"; $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 "</tr>"; } ?> </table> <?php } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings