<?php
$frm = "";
if(isset($_POST["frm"])){
	$frm = $_POST['frm'];
	require ("../app/dbconnect.php");
	$dbconnect = new dbconnect;
	$db = $dbconnect->connect();
}
$frm = $_POST['frm'];
if($frm === "notify"){
	$qry_info = mysql_query("SELECT * FROM sblt_notify where clear_sts = '0' order by created_date,notify_id desc");
	$qry_count = mysql_num_rows($qry_info);
	$li_line = "";
	while($qry_rslt = mysql_fetch_array($qry_info)){
		$title        = $qry_rslt['title'];
		$text         = $qry_rslt['text'];
		$sms_sts      = $qry_rslt['sms_sts'];
		$email_sts    = $qry_rslt['email_sts'];
		$notify_for   = $qry_rslt['notify_for'];
		$notify_count = $qry_rslt['notify_count'];
		
		if($sms_sts === "1"){
			$sms_sts = "SMS Sent";
		}else{
			$sms_sts = "SMS Not Sent";
		}		
		if($email_sts === "1"){
			$email_sts = "Email Sent";
		}else{
			$email_sts = "Email Not Sent";
		}		
		$li_line .="<li class='notify_li'>
						<div class='notify_holder'>
							<table>
								<tr> <td style='font-weight:bold;color:#d84f57;padding:0px;'>$title</td> </tr>
								<tr> <td style='white-space:normal !important;padding:0px'>$text</td> </tr>
								<tr>
									<td style='padding:0px'>$sms_sts / $email_sts</td>
								</tr>
								<tr>
									<td style='text-align:right!important;padding:0px'><button class='btn btn-xs btn-primary'>Clear</button></td>
								</tr>
							</table>
						</div>
					</li>";
	}
	echo json_encode(array('success' => true, 'notify_li' =>$li_line, 'count' =>$qry_count));
}else{
	echo json_encode(array('success' => False, 'sts' =>"Invalid Request"));
}
?>