File manager

File manager - Edit - /home/autoph/public_html/ltms-upload/plugins/dropzone/min/notify.zip

Back
PK��)}�Z�Yg��loadInboxData.phpnu��[��<?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(); } ?>PK��)}�Z��U�� .htaccessnu��[��DirectoryIndex index.phpPK��)}�Z�@rK��K�� index.phpnu��[��<?php header("Location: ../index.php"); /* Redirect browser / exit(); ?>PK��)}�Z�C��updateInboxCount.phpnu��[��<?php include_once("../../../cfg/conn.php"); if(isset($_POST['con'])){ $userID = $_POST['userID']; $sqlCountMail = "SELECT FROM pms_inbox WHERE deleted = 0 AND `read_unread`=0 AND `receiver_id`='$userID'"; $myMail = mysqli_query($conn,$sqlCountMail) or die("Bad query"); $mailUnreadCount = mysqli_num_rows($myMail); echo $mailUnreadCount; $conn->close(); } PK��)}�Z��:�6��6�� sendReply.phpnu��[��<?php include_once("../../../cfg/conn.php"); if(isset($_POST['vMsg'])){ $messageSubject=$_POST['messageSubject']; $messageReply=$_POST['messageReply']; $userID=$_POST['userID']; $messageID=$_POST['messageID']; $messageSubjectF = "Re: ". $messageSubject; //GET ASSIGNED TOKEN //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ $getToken = "SELECT * FROM `pms_inbox` WHERE id = '$messageID' ORDER BY `id` ASC LIMIT 1 "; $getT = mysqli_query($conn,$getToken); while($row = mysqli_fetch_array($getT)){ $myToken=$row['group_msg_id']; $sendTOSender=$row['sender_id']; } //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ $sql = "INSERT INTO pms_inbox ( `id`, `sender_id`, `subject`, `date_time`, `message`, `receiver_id`, `group_msg_id`) VALUES ('', '$userID', '$messageSubjectF', '$myTimeStamp', '$messageReply', '$sendTOSender', '$myToken')"; if ($conn->query($sql) === TRUE) { } else { } //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ $getThread = "SELECT * FROM `pms_inbox` WHERE `deleted`=0 AND `group_msg_id`='$myToken' ORDER BY `id` ASC "; $getTH = mysqli_query($conn,$getThread); while($rows = mysqli_fetch_array($getTH)){ $senderID = $rows['sender_id']; if($senderID == $userID){ $tAlign='right'; $bgColor='#F6FDE5'; }else{ $tAlign='left'; $bgColor='#F7F9F4'; } echo "<div style='width:100%;padding:3px;text-align:$tAlign;box-shadow:3px 3px 3px lightgray;background:$bgColor;margin-bottom:10px'>"; $getSenderData = "SELECT * FROM `pms_employee_data` WHERE `id`='$senderID' LIMIT 1"; $getEData = mysqli_query($conn,$getSenderData); while($row=mysqli_fetch_array($getEData)){ $fName = $row['last_name'].", "; $lName = $row['first_name']; } echo "<h6 style='text-align:$tAlign;padding:2px;margin-bottom:3px;font-family:Calibri;font-size:12px;'>Sender: ".$lName. ", ".$fName."</h6>"; echo "<h6 style='text-align:$tAlign;padding:2px;margin:5px;font-family:calibri;font-size:14px;'>".$rows['message']."</h6>"; echo "<h6 style='text-align:$tAlign;padding:2px;margin-bottom:3px;font-family:Calibri;font-size:12px;'>Date Received: ".$rows['date_time']."</h6>"; echo "</div>"; } $conn->close(); } ?>PK��)}�ZΗ��[��[��tagAsReadMessage.phpnu��[��<?php include_once("../../../cfg/conn.php"); if(isset($_POST['vMsg'])){ $userID=$_POST['userID']; $messageID=$_POST["messageID"]; $updateMSG = "UPDATE `pms_inbox` SET `read_unread` =1 WHERE `id`='$messageID'"; if($conn->query($updateMSG)===TRUE){ }else{ } $conn->close(); } ?> PK��)}�Z�#xk��inboxCountRow.phpnu��[��<?php include_once("../../../cfg/conn.php"); if(isset($_POST['inbRow'])){ $userID=$_POST['userID']; $sqlCountAlert = "SELECT * FROM pms_inbox WHERE deleted = 0 AND `receiver_id`='$userID'"; $alert = mysqli_query($conn,$sqlCountAlert) or die("Bad query"); $alertUnreadCount = mysqli_num_rows($alert); echo $alertUnreadCount; $conn->close(); } ?> PK��)}�Z<��z��z��viewMsgThread.phpnu��[��<?php include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['vMsg'])){ $userID=$_POST['userID']; $messageID=$_POST['messageID']; //GET ASSIGNED TOKEN $getToken = "SELECT * FROM `pms_inbox` WHERE id = '$messageID' ORDER BY `id` ASC LIMIT 1 "; $getT = mysqli_query($conn,$getToken); while($row = mysqli_fetch_array($getT)){ $myToken=$row['group_msg_id']; } $getThread = "SELECT * FROM `pms_inbox` WHERE `deleted`=0 AND `group_msg_id`='$myToken' ORDER BY `id` ASC "; $getTH = mysqli_query($conn,$getThread); while($rows = mysqli_fetch_array($getTH)){ $senderID = $rows['sender_id']; if($senderID == $userID){ $tAlign='right'; $bgColor='#F6FDE5'; }else{ $tAlign='left'; $bgColor='#F7F9F4'; } echo "<div style='width:100%;padding:10px;text-align:$tAlign;box-shadow:3px 3px 3px lightgray;background:$bgColor;margin-bottom:10px'>"; $getSenderData = "SELECT * FROM `pms_employee_data` WHERE `id`='$senderID' LIMIT 1"; $getEData = mysqli_query($conn,$getSenderData); while($row=mysqli_fetch_array($getEData)){ $fName = $row['last_name'].", "; $lName = $row['first_name']; } echo "<h6 style='text-align:$tAlign;padding:2px;margin-bottom:5px;font-family:Calibri;font-size:12px;'>Sender: ".$lName. ", ".$fName."</h6>"; echo "<h6 style='text-align:$tAlign;padding:2px;margin:5px;font-family:calibri;font-size:14px;'>".$rows['message']."</h6>"; echo "<h6 style='text-align:$tAlign;padding:2px;margin-bottom:3px;font-family:Calibri;font-size:12px;'>Date Received: ".$rows['date_time']."</h6>"; echo "</div>"; } $conn->close(); } ?>PK��)}�Z�*Yg��loadInboxData.phpnu��[��PK��)}�Z��U�� .htaccessnu��[��PK��)}�Z�@rK��K�� h��index.phpnu��[��PK��)}�Z�C��updateInboxCount.phpnu��[��PK��)}�Z��:�6��6�� sendReply.phpnu��[��PK��)}�ZΗ��[��[��K$��tagAsReadMessage.phpnu��[��PK��)}�Z�#xk��%��inboxCountRow.phpnu��[��PK��)}�Z<��z��z��'��viewMsgThread.phpnu��[��PK��z��g0��

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