File manager - Edit - /home/autoph/public_html/pms_v1/reports/loadEmployeeMAR.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); include '../css/mainCSS.php'; error_reporting(0); if(isset($_POST['marView'])){ $activeRecordID = $_POST['SelectedRecordID']; $selectedPCPid = $_POST['selectedPCPid']; $userID = $_POST['userID']; $getMARHeaders = "SELECT * FROM `mar_emp_header` WHERE `deleted`=0 AND `pcp_id` ='$selectedPCPid' ORDER BY `mar_month` ASC"; $marHead = mysqli_query($conn,$getMARHeaders); $statRow = mysqli_num_rows($marHead); echo "<table class='w-100'>"; echo "<thead>"; echo "<th class='PeachBG''>ID</th>"; echo "<th class='PeachBG'>YEAR</th>"; echo "<th class='PeachBG''>MONTH</th>"; echo "<th class='PeachBG'>MAR DESCRIPTION</th>"; echo "<th class='PeachBG'></th>"; echo "</thead>"; while($row = mysqli_fetch_array($marHead)){ switch($row['mar_month']){ case '01': $mon="January";break; case '02': $mon="February";break; case '03': $mon="March";break; case '04': $mon="April";break; case '05': $mon="May";break; case '06': $mon="June";break; case '07': $mon="July";break; case '08': $mon="August";break; case '09': $mon="September";break; case '10': $mon="October";break; case '11': $mon="November";break; case '12': $mon="December";break; } $marID = $row['id']; ?><tr onclick="javascript:pcpSelection(this);" ><?php echo "<td class='text-dark'>".$row['id']."</td>"; echo "<td class='cotext-darkl'>".$row['mar_year']."</td>"; echo "<td class='text-dark'>".$mon."</td>"; echo "<td class='text-dark'>".$row['mar_description']."</td>"; echo "<td style='width:3%'>";?> <!--<abbr title='View KRA'><i class='fa fa-plus-circle' aria-hidden='true' style='cursor:pointer;color:green;float:right;font-size:18px'></i> </abbr>--> <i onClick="window.open('./pdfViewer/mar_employeeview.php?pcpIDpdf=<?php echo $marID;?>&source=<?php echo $userID;?>')" class="fa fa-print" style='cursor:pointer;color:green;float:right;font-size:16px'></i> <?php echo "</td>"; echo "<tr>"; } echo "</table>"; $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings