| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/HostingSpaces/admin/247sms.com/wwwroot/test/adsense/dashboard/ |
Upload File : |
<?php
include "general2.php";
include "connect.php";
?>
<?php
/*
Place code to connect to your DB here.
*/
//include('config.php'); // include your code to connect to DB.
$tbl_name="messagesentbackup"; //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;
/*
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$page = $_GET['page'];
//if ($page ==""){
$tblfilter = $_REQUEST['myoption'];
$messfilter =$_REQUEST['strmessage'];
$begindate =$_REQUEST['begin_date'];
$enddate = $_REQUEST['end_date'];
$username = $_SESSION['username'];
//}
//echo $tblfilter ."<br>";
//echo $messfilter ."<br>";
//echo $begindate ."<br>";
//echo $enddate ."<br>";
//$query = "SELECT COUNT(*) as num FROM $tbl_name where username ='".$username ."' and domain='".$domain ."' and date(dateused) >= date('" .$begindate."') and date(dateused) <= date('" .$enddate."') and status like '".$tblfilter."%'";
// $domai = "247sms.com";
//$usern= "247sms";
if ($tblfilter !='awai'){
$query = "SELECT count(*) as num FROM messagesentbackup where username ='".$username ."' and domain='".$domain ."' and date(dateused) >= date('" .$begindate."') and date(dateused) <= date('" .$enddate."') and status like '".$tblfilter."%' and status != 'Long Message' ";
if ($tblfilter =='all')
$query = "SELECT count(*) as num FROM messagesentbackup where username ='".$username ."' and domain='".$domain ."' and date(dateused) >= date('" .$begindate."') and date(dateused) <= date('" .$enddate."') and status != 'Long Message'";
}
else
{
$query = "SELECT count(*) as num FROM messagesent where username ='".$username ."' and domain='".$domain ."' and date(dateused) >= date('" .$begindate."') and date(dateused) <= date('" .$enddate."') and status != 'Long Message' ";
}
if (($tblfilter != "") || ($mypage != "")){
$total_pages = mysqli_fetch_array(mysqli_query($con, $query));
$total_pages = $total_pages[num];
/* Setup vars for query. */
$targetpage = "messageawait.php"; //your file name (the name of this file)
$limit = 100; //how many items to show per page
if($page)
$start = ($page - 1) * $limit; //first item to display on this page
else{
$start = 0; //if no page var is given, set start to 0
$tblfilter2 =$tblfilter;
}
/* Get data. */
//$domai = "247sms.com";
//$usern= "247sms";
//echo $tblfilter;
if ($tblfilter !='awai'){
$sql = "SELECT dateused,phonenumber,sender,message,status,failurereason FROM messagesentbackup where username ='".$username ."' and domain='".$domain ."' and date(dateused) >= date('" .$begindate."') and date(dateused) <= date('" .$enddate."') and status like '".$tblfilter."%' and status != 'Long Message' order by sn desc LIMIT $start, $limit";
if ($tblfilter =="all")
$sql = "SELECT dateused,phonenumber,sender,message,status,failurereason FROM messagesentbackup where username ='".$username ."' and domain='".$domain ."' and date(dateused) >= date('" .$begindate."') and date(dateused) <= date('" .$enddate."') and status != 'Long Message' order by sn desc LIMIT $start, $limit ";
}
else
{
$sql = "SELECT dateused,phonenumber,sender,message,status,failurereason FROM messagesent where username ='".$username ."' and domain='".$domain ."' and date(dateused) >= date('" .$begindate."') and date(dateused) <= date('" .$enddate."') and status != 'Long Message' order by sn desc LIMIT $start, $limit";
}
$result = mysqli_query($con, $sql);
/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1
/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1)
$pagination.= "<a href=\"$targetpage?page=$prev&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">Previous</a>";
else
$pagination.= "<span class=\"disabled\">Previous</span>";
//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$targetpage?page=1&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">$counter</a>";
}
}
}
//next button
if ($page < $counter - 1)
$pagination.= "<a href=\"$targetpage?page=$next&myoption=$tblfilter&strmessage=$messfilter&begin_date=$begindate&end_date=$enddate\">Next </a>";
else
$pagination.= "<span class=\"disabled\">Next </span>";
$pagination.= "</div>\n";
}
}//mypage is not blank
?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<!--[if IE]><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><![endif]-->
<title>.::.247sms.com, The Bulksms People</title>
<meta name="keywords" content="sms, ems, bulk sms, massive sms,sms messenging,sms,bulk,cheap sms, low price sms,sms gateway,sms provider,sms nigeria,cheap sms, low pri sms, global sms, wide coverage sms, all countries sms, smpp, sms gateway" />
<meta name="description" content="sms messenging,sms,bulk,cheap sms, bulksms,low price sms,sms gateway,sms provider,sms nigeria, tone, tones, massive sms, smpp, smpp provider, bulksms, bulksms provider" />
<script language="JavaScript" src="count.js"></script>
<meta name="viewport" content="width=device-width">
<link rel="stylesheet" href="css/templatemo_main.css">
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-3672658228483041"
crossorigin="anonymous"></script>
</head>
<body>
<div class="navbar navbar-inverse" role="navigation">
<div class="navbar-header">
<div class="logo"><h1>247sms.com<span>Welcome <?php $username=$_SESSION['username'];
//$username=getUsername("nosaosahon",'247sms.com');
echo $username." ";
?>Credit: <?php
$bal=getBalance($username,$domain);
echo $bal."
(Customer Care 07062012965) ";
?></span></h1></div>
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
</div>
<div class="template-page-wrapper">
<div class="navbar-collapse collapse templatemo-sidebar">
<ul class="templatemo-sidebar-menu">
<li>
<form class="navbar-form">
<input type="text" class="form-control" id="templatemo_search_box" placeholder="Search...">
<span class="btn btn-default">Go</span>
</form>
</li>
<li class="active"><a href="dashboard.php"><i class="fa fa-home"></i>Dashboard</a></li>
<li class="sub" >
<a href="javascript:;">
<i class="fa fa-database"></i>To Send Message <div class="pull-right"><span class="caret"></span></div>
</a>
<ul class="templatemo-submenu"><li><a href="sendsms.php">Send Message</a></li>
<li><a href="sendaddress.php">Send Message Address</a></li>
<li><a href="sendaddressperson.php">Send Personalized Message</a></li>
<li><a href="addressbookupload.php">Create Addressbook</a></li>
<li><a href="addressbookuploadperson.php">Create Personalized Addressbook</a></li>
<li><a href="manaddressbook.php">Manage Addressbook</a></li>
<li><a href="manschedule.php">Manage Schedule</a></li>
</ul>
</li>
</li>
<li><a href="onlinepayment.php"><i class="fa fa-bank"></i>Online Payment</a></li>
<li><a href="messageawait.php"><i class="fa fa-cubes"></i>Messagelogs</a></li>
<li><a href="accounthis.php"><i class="fa fa-archive"></i>Account History</a></li>
<li><a href="paymenthis.php"><i class="fa fa-users"></i>Payment History</a></li>
<li><a href="preferences.php"><i class="fa fa-cog"></i>Preferences</a></li>
<li><a href="javascript:;" data-toggle="modal" data-target="#confirmModal"><i class="fa fa-sign-out"></i>Sign Out</a></li>
</ul>
</div><!--/.navbar-collapse -->
<div class="templatemo-content-wrapper">
<div class="templatemo-content">
<ol class="breadcrumb">
<li><a href="index.php">Home</a></li>
<li><a href="dashboard.php">Dashboard</a></li>
<li><a href="onlinepayment.php">Online Payment</a></li>
<li><a href="pricing.php">Pricing & Coverage</a></li>
<li><a href="tt.php">Trouble Ticket (TT)</a></li>
<li><a href="javascript:;" data-toggle="modal" data-target="#confirmModal"></i>Sign Out</a></li>
</ol>
<h2>Messagelogs </h2>
<table class="table table-hover table-bordered">
<form action="messageawait.php" method="post" name="fltform">
<tr>
<td height="20" class='text'><B>Begin Date</B>: </td>
<td><input type="text" name="begin_date" value="<?php echo date('Y/m/d');?>" required size=12 > yyyy/mm/dd</td>
</tr>
<tr>
<td class=text><B>End Date</B>: </td>
<td ><input type="text" name="end_date" value="<?php echo date('Y/m/d');?>" required size=12> yyyy/mm/dd</td>
</tr>
<tr>
<td class="text" colspan="2"><input name="myoption" type="radio" value="all" checked>All <input name="myoption" type="radio" value="deli" >Delivered <input name="myoption" type="radio" value="awai">Awaiting Report <input name="myoption" type="radio" value="unde">Undeliverable <input name="myoption" type="radio" value="expi">Expired <label>
<input type="checkbox" name="strmessage" value="trumess" checked="checked">
Truncate Message</label></td>
</tr>
<tr>
<td colspan="2" >
<div class="row templatemo-form-buttons">
<div class="col-md-12">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</td>
</tr>
</form>
</table>
<hr width="80%">
<?php
if ( ($tblfilter !="") || ($mypage != "")){
if (mysqli_num_rows($result) > 0 ){
echo "<div class='table-responsive'>
<table class='table table-striped table-hover table-bordered'>
<thead>
<tr>
<th>Datesent</th>
<th>Phonenumber</th>
<th>Sender</th>
<th>Message</th>
<th>Status</th>
<th>Failurereason</th>
</tr>
</thead>
<tbody>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row["dateused"]."</td>";
echo "<td>" . $row["phonenumber"]."</td>";
echo "<td>" . $row["sender"]."</td>";
$message =$row["message"];
if( $messfilter !="")
if (strlen($message) > 50)
$message =substr($message,0,50);
$message=str_replace("<br>","",$message);
echo "<td>" .$message."</td>";
echo "<td>" . $row["status"]."</td>";
echo "<td>" .$row["failurereason"]."</td>";
echo "</tr>";
}
echo "</tbody></table></div>";
echo $pagination;
}else//no records found
{
echo "<div class='alert alert-danger alert-dismissible' role='alert'>
<button type='button' class='close' data-dismiss='alert'><span aria-hidden='true'>×</span><span class='sr-only'>Close</span></button>Sorry, No Record Found</div>";
}
}
?>
</div>
</div>
<!-- Modal -->
<div class="modal fade" id="confirmModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>
<h4 class="modal-title" id="myModalLabel">Are you sure you want to sign out?</h4>
</div>
<div class="modal-footer">
<a href="processlogout.php?res=yes" class="btn btn-primary">Yes</a>
<button type="button" class="btn btn-default" data-dismiss="modal">No</button>
</div>
</div>
</div>
</div>
<footer class="templatemo-footer">
<div class="templatemo-copyright">
<p>Copyright © 2003 Swift Alliance Ltd</p>
</div>
</footer>
</div>
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/Chart.min.js"></script>
<script src="js/templatemo_script.js"></script>
<script type="text/javascript">
// Line chart
var randomScalingFactor = function(){ return Math.round(Math.random()*100)};
var lineChartData = {
labels : ["January","February","March","April","May","June","July"],
datasets : [
{
label: "My First dataset",
fillColor : "rgba(220,220,220,0.2)",
strokeColor : "rgba(220,220,220,1)",
pointColor : "rgba(220,220,220,1)",
pointStrokeColor : "#fff",
pointHighlightFill : "#fff",
pointHighlightStroke : "rgba(220,220,220,1)",
data : [randomScalingFactor(),randomScalingFactor(),randomScalingFactor(),randomScalingFactor(),randomScalingFactor(),randomScalingFactor(),randomScalingFactor()]
},
{
label: "My Second dataset",
fillColor : "rgba(151,187,205,0.2)",
strokeColor : "rgba(151,187,205,1)",
pointColor : "rgba(151,187,205,1)",
pointStrokeColor : "#fff",
pointHighlightFill : "#fff",
pointHighlightStroke : "rgba(151,187,205,1)",
data : [randomScalingFactor(),randomScalingFactor(),randomScalingFactor(),randomScalingFactor(),randomScalingFactor(),randomScalingFactor(),randomScalingFactor()]
}
]
}
window.onload = function(){
var ctx_line = document.getElementById("templatemo-line-chart").getContext("2d");
window.myLine = new Chart(ctx_line).Line(lineChartData, {
responsive: true
});
};
$('#myTab a').click(function (e) {
e.preventDefault();
$(this).tab('show');
});
$('#loading-example-btn').click(function () {
var btn = $(this);
btn.button('loading');
// $.ajax(...).always(function () {
// btn.button('reset');
// });
});
</script>
</body>
</html>