| 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/old247sms.co.uk/247sms.co.uk/wwwroot/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 = "messagestatsdetails"; //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'];
//$submit = $_REQUEST['submit'];
//$reporttype = $_REQUEST['mtype'];
$totaldeliveredstatus = 0;
$totalAwaiting = 0;
$totalmessagesent = 0;
$totalDelivered = 0;
$totalNotDelivered = 0;
$totalUndeliverable = 0;
$totalExpired = 0;
$totalRejected = 0;
$totalCredit = 0;
$totalnomoney = 0;
$totalothers = 0;
if ($submit == "") {
$begindate = date("Y-m-d");
//$enddate = date("Y-m-d");
}
//if ($reporttype != ""){
//$domain='247sms.co.uk';
//$username='247sms';
$day1 = "0";
$totalsent1 = 0;
$totaldelivered1 = 0;
$day2 = "0";
$totalsent2 = 0;
$totaldelivered2 = 0;
$day3 = "0";
$totalsent3 = 0;
$totaldelivered3 = 0;
$day4 = "0";
$totalsent4 = 0;
$totaldelivered4 = 0;
$day5 = "0";
$totalsent5 = 0;
$totaldelivered5 = 0;
$day6 = "0";
$totalsent6 = 0;
$totaldelivered6 = 0;
$day7 = "0";
$totalsent7 = 0;
$totaldelivered7 = 0;
//$mdate = date_create(date("Y-m-d"));
//date_sub($mdate, date_interval_create_from_date_string('6 days'));
//mdate = date_format($mdate, 'Y-m-d');
// $mdate = $date;
// echo $begindate."<br>";
// $username="247sms";
// $domain="247sms.co.uk";
$totalmess = gettotalmessage($username, $domain, $begindate);
// echo $totalmess."<br>";
//exit();
$mystring = explode("#", $totalmess);
$totalmessagesent = $mystring[0];
$totalDelivered = $mystring[1];
$totalAwaiting = $mystring[2];
$totalUndeliverable = $mystring[3];
$totalExpired = $mystring[4];
$totalRejected = $mystring[5];
$totalnomoney = $mystring[6];
$totalothers = $mystring[7];
$totalCredit = doubleval($mystring[8]);
$totalNotDelivered = $totalmessagesent - $totalDelivered;
//echo "nosa".$totalNotDelivered;
$mdate = date("Y-m-d");
$totalmess = gettotalmessageWeek($username, $domain, $mdate);
//week long statistics
//echo $totalmess;
//exit();
$strArr = explode("#", $totalmess);
$cnt10 = 1;
foreach ($strArr as $mystring) {
$value = explode(",", $mystring);
// foreach ( $innerstrArr as $value)
//{
//echo $value . "kings". "<br>";
if ($cnt10 == 1) {
$day1 = $value[0];
$totalsent1 = $value[1];
$totaldelivered1 = $value[2];
}
if ($cnt10 == 2) {
$day2 = $value[0];
$totalsent2 = $value[1];
$totaldelivered2 = $value[2];
}
if ($cnt10 == 3) {
$day3 = $value[0];
$totalsent3 = $value[1];
$totaldelivered3 = $value[2];
}
if ($cnt10 == 4) {
$day4 = $value[0];
$totalsent4 = $value[1];
$totaldelivered4 = $value[2];
}
if ($cnt10 == 5) {
$day5 = $value[0];
$totalsent5 = $value[1];
$totaldelivered5 = $value[2];
}
if ($cnt10 == 6) {
$day6 = $value[0];
$totalsent6 = $value[1];
$totaldelivered6 = $value[2];
}
if ($cnt10 == 7) {
$day7 = $value[0];
$totalsent7 = $value[1];
$totaldelivered7 = $value[2];
}
$cnt10 = $cnt10 + 1;
}
//exit();
?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<!--[if IE]><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><![endif]-->
<title>.::.247sms.co.uk, 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" />
<meta name="viewport" content="width=device-width">
<link rel="stylesheet" href="css/templatemo_main.css">
<script>
(function(i, s, o, g, r, a, m) {
i['GoogleAnalyticsObject'] = r;
i[r] = i[r] || function() {
(i[r].q = i[r].q || []).push(arguments)
}, i[r].l = 1 * new Date();
a = s.createElement(o),
m = s.getElementsByTagName(o)[0];
a.async = 1;
a.src = g;
m.parentNode.insertBefore(a, m)
})(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga');
ga('create', 'UA-96236566-1', 'auto');
ga('send', 'pageview');
</script>
<script data-ad-client="ca-pub-3672658228483041" async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
</head>
<body>
<div class="navbar navbar-inverse" role="navigation">
<div class="navbar-header">
<div class="logo">
<h1>247sms.co.uk<span>Welcome <?php $username = $_SESSION['username'];
//$username=getUsername("nosaosahon",'247sms.co.uk');
echo $username . " ";
?>Credit: <?php
$bal = getBalance($username, $domain);
echo $bal . " ";
?></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><a href="voicemessage.php"><i class="fa fa-bank"></i>Send Robo Call</a></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="onlinepayment.php">Payment</a></li>
<li><a href="pricing.php">Pricing</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>
<table class="table table-hover table-bordered">
<form action="dashboard.php" method="post" name="fltform">
<tr>
<td height="20" class='text'><B>Select Date to Generate Statistics</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 colspan="2">
<input type='hidden' name='mtype' value='1' />
<div class="row templatemo-form-buttons">
<div class="col-md-12">
<button type="submit" class="btn btn-primary" name="submit" value="submit">Submit</button>
</div>
</div>
</td>
</tr>
</form>
</table>
<div class="margin-bottom-30">
<div class="row">
<div class="col-md-12">
<ul class="nav nav-pills">
<li class="alert alert-info">Total SMS Sent <span class="badge"><?php echo $totalmessagesent; ?></span></li>
<li class="alert alert-success">Total SMS Delivered <span class="badge"><?php echo $totalDelivered; ?></span></li>
<li class="alert alert-warning">Total SMS not Delivered <span class="badge"><?php echo $totalNotDelivered; ?></span></li>
<li class="alert alert-danger">Total Credits Deducted <span class="badge"><?php echo number_format($totalCredit, 2, '.', ','); ?></span></li>
</ul>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-primary">
<div class="panel-heading">Today's Message Report (By Status)</div>
<canvas id="templatemo-bar-chart"></canvas>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-success">
<div class="panel-heading">One Weeek Message Report(Total Messages sent/Total Delivered )</div>
<canvas id="templatemo-bar-chart2"></canvas>
</div>
</div>
</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 © 2024 Tick Waves Limited</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)
}
<?php echo " var lineChartData = {
labels : ['Total Sent','Delivered','Awaiting','Undeliverable','Expired','Rejected'],
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 : [$totalmessagesent,$totalDelivered,$totalAwaiting,$totalUndeliverable,$totalExpired,$totalRejected]
}
]
} // lineChartData
"; ?>
<?php echo " var lineChartDataOper = {
labels : ['$day1','$day2','$day3','$day4','$day5','$day6','$day7'],
datasets : [
{
label: 'Total SMS Sent',
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 : [$totalsent1,$totalsent2,$totalsent3,$totalsent4,$totalsent5,$totalsent6,$totalsent7]},
{
label: 'Total Delivered',
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 : [$totaldelivered1,$totaldelivered2,$totaldelivered3,$totaldelivered4,$totaldelivered5,$totaldelivered6,$totaldelivered7]
}
]
}"; // lineChartData
?>
window.onload = function() {
var ctx_bar = document.getElementById("templatemo-bar-chart").getContext("2d");
var ctx_bar2 = document.getElementById("templatemo-bar-chart2").getContext("2d");
window.myBar = new Chart(ctx_bar).Bar(lineChartData, {
responsive: true
});
window.myBar = new Chart(ctx_bar2).Bar(lineChartDataOper, {
responsive: true
});
}
</script>
</body>
</html>