<?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 = "userlogin";		//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'];
$tblfilter = $_REQUEST['strmessage'];
//$begindate =$_REQUEST['begin_date'];
$username = $_REQUEST['username'];
//$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";



//$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."%'";


$query = 	"select count(*)  as num  from userlogin as a,smsaccount as b where a.username like '" . $username . "%' and a.domain='247sms.com' and a.username=b.username and a.domain=b.domain order by a.username";

//echo $query;
//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  like '".$tblfilter."%'";
//}




if (($tblfilter != "") || ($mypage != "")) {

	$total_pages = mysqli_fetch_array(mysqli_query($link, $query));
	$total_pages = $total_pages[num];

	/* Setup vars for query. */
	$targetpage = "finduser.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;


	$sql = "select a.username,email,phonenumber,country,state,address,lastlogin,balnaira,baleuro,baldollar from userlogin as a,smsaccount as b where a.username like '" . $username . "%' and a.domain='247sms.com' and a.username=b.username and a.domain=b.domain order by a.username  LIMIT $start, $limit";

	//echo $sql;


	$result = mysqli_query($link, $sql);

	//var_dump($result);

	//echo "nosa";

	/* 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">



</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 . "&nbsp;&nbsp;";


											?> <?php

												//$bal=getBalance($username,$domain);
												// echo $bal."&nbsp;&nbsp;";


												?></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><a href="index.php"><i class="fa fa-cubes"></i>Account Top</a></li>
				<li><a href="finduser.php"><i class="fa fa-bank"></i>Find User</a></li>
				<li><a href="activation.php"><i class="fa fa-bell"></i>New Activations</a></li>
				<li><a href="newusers.php"><i class="fa fa-bell"></i>New Users</a></li>
				<li><a href="messagelogs.php"><i class="fa fa-building"></i>Messagelogs</a></li>
				<li><a href="messtats.php"><i class="fa fa-car"></i>Message Stats</a></li>
				<li><a href="account.php"><i class="fa fa-briefcase"></i>Account History</a></li>
				<li><a href="payment.php"><i class="fa fa-money"></i>Payment History</a></li>
				<li><a href="trouble.php"><i class="fa fa-bell"></i>Trouble Ticket</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="javascript:;" data-toggle="modal" data-target="#confirmModal"></i>Sign Out</a></li>
				</ol>
				<h2>Find User </h2>
				<table class="table table-hover table-bordered">
					<form action="finduser.php" method="post" name="fltform">


						<tr>
							<td class=text><B>Username to Find</B>:&nbsp;</td>
							<td><input type="text" name="username" value="" required size='20'>first 3 letter</td>


						</tr>

						<tr>
							<td colspan="2">
								<div class="row templatemo-form-buttons">
									<div class="col-md-12">
										<input type="hidden" name="strmessage" value="trumess" checked="checked">
										<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>Username</th>
                      

                      <th>Email</th>
                      <th>Phonenumber</th>
                       
                      <th>Country</th>
                      <th>State</th>
					   <th>Address</th>
                      <th>lastlogin</th>
                      <th>Balnaira</th>
                       
                      <th>BalEuro</th>
                      <th>Baldollar</th>
                    </tr>
                  </thead>
                  <tbody>";


						while ($row = mysqli_fetch_array($result)) {
							echo "<tr>";
							echo "<td>" . $row["username"] . "</td>";
							echo "<td>" . $row["email"] . "</td>";
							echo "<td>" . $row["phonenumber"] . "</td>";
							echo "<td>" . $row["country"] . "</td>";
							echo "<td>" . $row["state"] . "</td>";
							echo "<td>" . $row["address"] . "</td>";
							echo "<td>" . $row["lastlogin"] . "</td>";
							echo "<td>" . $row["balnaira"] . "</td>";
							echo "<td>" . $row["baleuro"] . "</td>";
							echo "<td>" . $row["baldollar"] . "</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'>&times;</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">&times;</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 &copy; 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>