| 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/sms4real.com/wwwroot/dashboard/ |
Upload File : |
<?php
include "general2.php";
include "connect.php";
?>
<?php
/*
Place code to connect to your DB here.
*/
//echo 'Nosa';
//die();;
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.com';
//$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.com";
$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>.::.sms4real.com, Bulksms Made Easy</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">
</head>
<body>
<div class="navbar navbar-inverse" role="navigation">
<div class="navbar-header">
<div class="logo"><h1>sms4real.com<span>Welcome <?php $username=$_SESSION['username'];
//$username=getUsername("nosaosahon",'sms4real.com');
echo $username." ";
?>Credit: <?php
$bal=getBalance($username,$domain);
echo $bal." Customer Care Line: 08069526082";
?></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 open" >
<a href="javascript:;">
<i class="fa fa-database"></i> 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="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>
<h1>Dashboard</h1>
<p>Check the performance of your bulksms messages</p>
<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 © 2010 Flex Global Concepts Company</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>