File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_LoadNewPRF.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_request_hdr` WHERE `deleted`=0 "),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_request_hdr` WHERE `deleted`=0 AND `request_by`='$myUID' AND `current_status` = 100 \|\| `deleted`=0 AND `request_by`='$myUID' AND `current_status` = 0 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdr)){ $count = $count + 1; $prfCompID = $row['comp_id']; $prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0); $prfDealID = $row['deal_id']; $prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0); $prfCatID = $row['category_id']; $prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0); $prfSubCatID = $row['sub_category_id']; $prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0); $prfDeptApproverID = $row['dept_head_id']; $prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0); $prfStatus = $row['current_status']; ?><tr onclick="javascript:showPRFheaderForDeletion(this);" onDblclick="javascript:showActionViewDelete(this);" ><?php echo "<td style='width:3%'>".$count."</td>"; echo "<td style='width:10%'>".strtoupper($row['reference_code'])."</td>"; echo "<td style='width:7%'>".strtoupper($row['date_created'])."</td>"; echo "<td style='width:19%'>".strtoupper($prfCompName)."</td>"; echo "<td style='width:16%'>".strtoupper($prfDealName)."</td>"; echo "<td style='width:13%'>".strtoupper($prfCatName)."</td>"; echo "<td style='width:12%'>".strtoupper($prfSubCatName)."</td>"; echo "<td style='width:12%'>".strtoupper($prfDeptApproverLName).", ".strtoupper($prfDeptApproverFName)."</td>"; echo "<td style='width:14%;font-family:Yu Gothic;font-weight:normal;color:blue;font-size:12px'>"; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo"</td>"; echo "</tr>"; } ?> <tr><td colspan='9' ><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='6' style='background:white;'> <input type='hidden' id='selectedPRFHeaderID' class='TableBottomLabel'> <input disabled type='text' id='selectedPRFHeaderIDLabel' style='background:white;border:0px;font-family:Yu Gothic;font-size:14px;color: #f97d43 ;font-weight:normal'> </td> </tr> </table> <?php } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings