File manager - Edit - /home/autoph/public_html/pms_v1/ajaxCall/loadActiveOpsByDepartment.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); if(isset($_POST['active'])){ $userID = $_POST['userID']; $report = $_POST['report']; $selCompID = $_POST['selCompID']; ?> <table style="width:100%;border-collapse:collapse"> <thead> <th class='col-1 text-dark'>NO</thd> <th class='col-1 text-dark'>YEAR</th> <th class='col-3 text-dark'>COMPANY</thd> <th class='col-5 text-dark'>OPSPLAN DESCRIPTION</th> <th class='col-1 text-dark'>STATUS</th> <th class='col-1 text-dark'></th> </thead> <?php $count = 0; if($report == 0 ){ $sqlOps = "SELECT * FROM `ops_department_level` WHERE `record_id`='$selCompID' ORDER BY `id` ASC "; $qOps = mysqli_query($conn,$sqlOps); while($ops=mysqli_fetch_array($qOps)){ $count = $count + 1; $recordID = $ops['id']; echo "<tr>"; echo "<td class='col-1 text-primary decoration-underline'><u>".$count."</u></td>"; echo "<td class='col-1 text-primary'><u>".$ops['coverage_year']."</u></td>"; echo "<td class='col-3 text-primary'><u>".strtoupper(getDepartmentName($ops['record_id'])[1])."</u></td>"; echo "<td class='col-5 text-primary'><u>".strtoupper($ops['ops_name'])."</u></td>"; echo "<td class='col-1 text-primary'><u>".$ops['status']."</u></td>"; echo "<td class='col-1 text-danger text-right'><a href='pdfViewer/ops_pdfDepartmentView.php?compID=$selCompID&source=$userID&recordID=".$ops['id']."' target='_blank'><i class='fa fa-print'></i></a></td>"; echo "</tr>"; echo "</tr>"; } }else{ $sqlOps = "SELECT * FROM `ops_department_level` WHERE `record_id`='$selCompID' AND `deleted`='0' ORDER BY `id` ASC "; $qOps = mysqli_query($conn,$sqlOps); while($ops=mysqli_fetch_array($qOps)){ $count = $count + 1; echo "<tr>"; echo "<td class='col-1 text-primary decoration-underline'><u>".$ops['id']."</u></td>"; echo "<td class='col-1 text-primary'><u>".$ops['coverage_year']."</u></td>"; echo "<td class='col-3 text-primary'><u>".strtoupper(getDepartmentName($ops['record_id'])[0])."</u></td>"; echo "<td class='col-5 text-primary'><u>".strtoupper($ops['ops_name'])."</u></td>"; echo "<td class='col-1 text-primary'><u>".$ops['status']."</u></td>"; echo "<td class='col-1 text-danger text-right'><a href='pdfViewer/ops_pdfDepartmentView.php?compID=$selCompID&source=$userID&recordID=".$ops['id']."' target='_blank'><i class='fa fa-print'></i></a></td>"; echo "</tr>"; } } ?> </table> <?php $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings