<?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="accounthistory.php";		//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'];
	//}
	//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 accounthistory where username ='".$username ."' and domain='".$domain ."' and date(dateused) >=  date('" .$begindate."') and date(dateused) <= date('" .$enddate."')";
		//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 (($mypage != "") || ($submit=="submit")){
     
	$total_pages = mysql_fetch_array(mysql_query($query));
	$total_pages = $total_pages[num];
	
	/* Setup vars for query. */
	$targetpage = "accounthis.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,page,oldbal,amtcharged,newbal FROM accounthistory where username ='".$username ."' and domain='".$domain ."' and date(dateused) >=  date('" .$begindate."') and date(dateused) <= date('" .$enddate."')  order by sn desc LIMIT $start, $limit";
		//}
		//else
		  //{
		    //$sql = "SELECT dateused,phonenumber,message,status,failurereason FROM messagesent where username ='".$username ."' and domain='".$domain ."' and date(dateused) >=  date('" .$begindate."') and date(dateused) <= date('" .$enddate."') and status  like '".$tblfilter."%' order by sn desc LIMIT $start, $limit";
		  //}
		
	//echo $sql;
	
	$result = mysql_query($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&begin_date=$begindate&end_date=$enddate&submit=submit\">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&begin_date=$begindate&end_date=$enddate&submit=submit\">$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&begin_date=$begindate&end_date=$enddate&submit=submit\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1&begin_date=$begindate&end_date=$enddate&submit=submit\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage&begin_date=$begindate&end_date=$enddate&submit=submit\">$lastpage</a>";		
			}
			//in middle; hide some front and some back
			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
			{
				$pagination.= "<a href=\"$targetpage?page=1&begin_date=$begindate&end_date=$enddate&submit=submit\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2&begin_date=$begindate&end_date=$enddate&submit=submit\">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&begin_date=$begindate&end_date=$enddate&submit=submit\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1&begin_date=$begindate&end_date=$enddate&submit=submit\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage&begin_date=$begindate&end_date=$enddate&submit=submit\">$lastpage</a>";		
			}
			//close to end; only hide early pages
			else
			{
				$pagination.= "<a href=\"$targetpage?page=1&begin_date=$begindate&end_date=$enddate&submit=submit\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2&begin_date=$begindate&end_date=$enddate&submit=submit\">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&begin_date=$begindate&end_date=$enddate&submit=submit\">$counter</a>";					
				}
			}
		}
		
		//next button
		if ($page < $counter - 1) 
			$pagination.= "<a href=\"$targetpage?page=$next&begin_date=$begindate&end_date=$enddate&submit=submit\">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>Airbornesms, Powering Messaging Platform</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>airbornesms.com<span>Welcome <?php $username=$_SESSION['username'];
	    //$username=getUsername("nosaosahon",'sms4real.com');
	    echo $username."&nbsp;&nbsp;";
	     
	
	?>Credit:  <?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 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>
		  <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="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>Account History </h2>
	<p>Check your Account Balance movement here</p>
	<table    class="table table-hover table-bordered">
                <form action="accounthis.php" method="post" name="fltform">
	
    <tr>
      <td height="20"  class='text'><B>Begin Date</B>:&nbsp;</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>:&nbsp;</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 colspan="2" >
           <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>
   
<hr width="80%">   

			
			
			
			
		   
		   
		   
		   
		   
		   
		   
		 <?php  
		    
			
			if ( ($submit !="") || ($mypage != "")){
			
			if (mysql_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>Page</th>
                      <th>Old balance</th>
                      <th>Amount Charged</th>
					  <th>New Balance</th>

                    </tr>
                  </thead>
                  <tbody>";
                  		   
	
		while($row = mysql_fetch_array($result))
		{
                   		
			       echo "<tr>";
				       echo "<td>" . $row["dateused"]."</td>";
					 echo "<td>" . $row["phonenumber"]."</td>";	  
					 echo "<td>" .$row["page"]."</td>";
                      echo "<td>" . $row["oldbal"]."</td>";
					 echo "<td>" .$row["amtcharged"]."</td>";
					 echo "<td>" .$row["newbal"]."</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; 2010 Airbornesms Solution 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)};
    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>