File manager

File manager - Edit - /home/autoph/public_html/pms_v1/ajaxCall/loadActiveOpsByCompany.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 ){ $sql = "SELECT * FROM pms_officers WHERE deleted=0 AND `pms_officer_id`='$userID' AND `comp_id`='$selCompID' GROUP BY `comp_id` ORDER BY comp_id ASC"; $getGroup = mysqli_query($conn,$sql); $chkIfExist = mysqli_num_rows($getGroup); if($chkIfExist > 0){ while($row = mysqli_fetch_array($getGroup)){ $pcpEmpID = $row['pms_officer_id']; $pmsCompID = $row['comp_id']; $sqlOps = "SELECT * FROM `ops_company_level` WHERE `record_id`='$pmsCompID' AND `status` ='OPEN' 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(getCompanyNameSub($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_pdfCompanyView.php?compID=$selCompID&source=$userID&recordID=".$ops['id']."' target='_blank'><i class='fa fa-print'></i></a></td>"; echo "</tr>"; echo "</tr>"; } } }else{ echo "<p class='text-center m-2 p-2'>No record found.</p>"; } }else{ $sqlOps = "SELECT * FROM `ops_company_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(getCompanyNameSub($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_pdfCompanyView.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