File manager

File manager - Edit - /home/autoph/public_html/pms_v1/notify/loadInboxData.php

Back
<?php include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['inb'])){ $txtLen=90; $txtLenS=40; $tColor ='#837E7D'; $tWeight ='normal'; $count=0; $userID = $_POST['userID']; $infCanvass = $_POST['infCanvass']; $start = $_POST['start']; $limit = $_POST['limit']; $unreadView = $_POST['unreadView']; if($infCanvass=='' \|\| $infCanvass == null){ $getKRAList = "SELECT * FROM `pms_inbox` WHERE `deleted`=0 AND `receiver_id`='$userID' ORDER BY `id` DESC LIMIT $start, $limit"; }else{ $getKRAList = "SELECT * FROM `pms_inbox` WHERE `deleted`=0 AND `receiver_id`='$userID' AND `subject` LIKE '%$infCanvass%' \|\| `deleted`=0 AND `receiver_id`='$userID' AND `message` LIKE '%$infCanvass%' ORDER BY `id` DESC LIMIT $start, $limit"; } if($unreadView==='1'){ $getKRAList = "SELECT * FROM `pms_inbox` WHERE `deleted`=0 AND `receiver_id`='$userID' AND `read_unread`='0' ORDER BY `id` DESC LIMIT $start, $limit"; } //$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'"; $getKRA = mysqli_query($conn,$getKRAList); $statRow = mysqli_num_rows($getKRA); if($statRow > 0){ while($row = mysqli_fetch_array($getKRA)){ $count = $count + 1; $isRead =$row['read_unread']; if($isRead==0){ $tColor ='#971007'; $tWeight ='bold'; }else{ $tColor ='#837E7D'; $tWeight ='normal'; } ?><tr onclick="javascript:getInfo(this);" ><?php echo "<td style='width:5%;font-family:Calibri;color:$tColor;font-weight:tWeight'>".$row['id']."</td>"; echo "<td style='width:10%;font-family:Calibri;color:$tColor;font-weight:tWeight'>"; $xDate = explode(" ",$row['date_time']); echo $xDate[0]; echo "</td>"; echo "<td style='width:20%;font-family:Calibri;color:$tColor;font-weight:tWeight'>"; if(strlen($row['subject'])>$txtLenS){ $strS = substr($row['subject'], 0, $txtLenS) . '...'; }else{ $strS = $row['subject']; } echo $strS; echo "</td>"; echo "<td style='width:44%;font-family:Calibri;color:$tColor;font-weight:tWeight'>"; if(strlen($row['message'])>$txtLen){ $str = substr($row['message'], 0, $txtLen) . '...'; }else{ $str = $row['message']; } echo $str; echo "</td>"; echo "<td style='width:17%;font-family:Calibri;color:$tColor;font-weight:tWeight'>"; $senderID =$row['sender_id']; $getSenderData = "SELECT * FROM `pms_employee_data` WHERE `id`='$senderID' LIMIT 1"; $getEData = mysqli_query($conn,$getSenderData); while($row=mysqli_fetch_array($getEData)){ echo $row['last_name'].", "; echo $row['first_name']; } echo"</td>"; echo "<td style='width:3%;> <abbr title='View record'> <i class='fa fa-envelope-o' data-toggle='modal' data-target='#viewMessage' aria-hidden='true' style='color:#64686b;float:right;font-size:14px;color:$tColor;font-weight:$tWeight'></i> </abbr> </td>"; // echo "<td style='width:3%'> // <abbr title='Edit record'> // <i class='fa fa-map-marker' pencilButton aria-hidden='true' style='color:#04559f;float:right;font-size:16px'></i> // </abbr> // </td>"; //echo "<td style='width:3%'> //<abbr title='Delete record'><i class='fa fa-trash ' aria-hidden='true' style='color:#FF0800;float:left;font-size:16px'></i></abbr> //</td>"; echo "<tr>"; } if($infCanvass!='' \|\| $infCanvass != null){ if($statRow===''){ $statRow = 0; } // echo "<tr>"; // echo "<td colspan='4' style='padding:15px;padding-top:20px;padding-bottom:20px;text-align:left;width:10%'>Record/s found: ".$statRow."</td>"; //echo "</tr>"; } } $conn->close(); } ?>

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