One Hat Cyber Team

View File Name : payment_query.php

<?
include("inc/header.php");
include_once("config_nsemem.php");
?>
<form id="form1" name="form1" method="get" action="payment_query2.php">
  <table width="100%" border="1" cellspacing="0" cellpadding="5" style="border: 1px solid #333333;" align="left">
    <tr>
      <td>Payment Date </td>
      <td>From: &nbsp;d
        <select name="date_day" id="date_day">
<?php

if ($Submit != Search){
$date_year = date("Y");
$date_month = date("m");
$date_day = date("d");
$date_year2 = date("Y");
$date_month2 = date("m");
$date_day2 = date("d");
}

for ($mday = 1; $mday<= 31; $mday++) {
?>
          <option value="<? if (strlen($mday) == 1) {$mday = "0$mday";} echo $mday ?>" <? if ($mday == $date_day) {echo "selected"; } ?>><? echo $mday ?></option>
          <?
}
?>
        </select>
         m 
         <select name="date_month" id="date_month">
           <option value='01' <? if ($date_month == 1) {echo "selected"; } ?>>Jan</option>
           <option value='02' <? if ($date_month == 2) {echo "selected"; } ?>>Feb</option>
           <option value='03' <? if ($date_month == 3) {echo "selected"; } ?>>March</option>
           <option value='04' <? if ($date_month == 4) {echo "selected"; } ?>>Apr</option>
           <option value='05' <? if ($date_month == 5) {echo "selected"; } ?>>May</option>
           <option value='06' <? if ($date_month == 6) {echo "selected"; } ?>>Jun</option>
           <option value='07' <? if ($date_month == 7) {echo "selected"; } ?>>Jul</option>
           <option value='08' <? if ($date_month == 8) {echo "selected"; } ?>>Aug</option>
           <option value='09' <? if ($date_month == 9) {echo "selected"; } ?>>Sept</option>
           <option value='10' <? if ($date_month == 10) {echo "selected"; } ?>>Oct</option>
           <option value='11' <? if ($date_month == 11) {echo "selected"; } ?>>Nov</option>
           <option value='12' <? if ($date_month == 12) {echo "selected"; } ?>>Dec</option>
         </select>
          y 
          <select name="date_year" id="date_year">
<?php
$tillyear = date(Y)-5;
for ($year = date(Y); $year >= $tillyear; $year--) {
?>
    <option value="<? echo $year ?>"  <? if ($year == $date_year) {echo "selected"; } ?>><? echo $year ?></option>
<?
}
?>
          </select>
          To: d
          <select name="date_day2" id="date_day2">
<?php
for ($mday = 1; $mday<= 31; $mday++) {
?>
          <option value="<? if (strlen($mday) == 1) {$mday = "0$mday";} echo $mday ?>" <? if ($mday == $date_day2) {echo "selected"; } ?>><? echo $mday ?></option>
          <?
}
?>
        </select>
         m 
         <select name="date_month2" id="date_month2">
           <option value='01' <? if ($date_month2 == 1) {echo "selected"; } ?>>Jan</option>
           <option value='02' <? if ($date_month2 == 2) {echo "selected"; } ?>>Feb</option>
           <option value='03' <? if ($date_month2 == 3) {echo "selected"; } ?>>March</option>
           <option value='04' <? if ($date_month2 == 4) {echo "selected"; } ?>>Apr</option>
           <option value='05' <? if ($date_month2 == 5) {echo "selected"; } ?>>May</option>
           <option value='06' <? if ($date_month2 == 6) {echo "selected"; } ?>>Jun</option>
           <option value='07' <? if ($date_month2 == 7) {echo "selected"; } ?>>Jul</option>
           <option value='08' <? if ($date_month2 == 8) {echo "selected"; } ?>>Aug</option>
           <option value='09' <? if ($date_month2 == 9) {echo "selected"; } ?>>Sept</option>
           <option value='10' <? if ($date_month2 == 10) {echo "selected"; } ?>>Oct</option>
           <option value='11' <? if ($date_month2 == 11) {echo "selected"; } ?>>Nov</option>
           <option value='12' <? if ($date_month2 == 12) {echo "selected"; } ?>>Dec</option>
         </select>
          y 
          <select name="date_year2" id="date_year2">
<?php
$tillyear = date(Y)-5;
for ($year = date(Y); $year >= $tillyear; $year--) {
?>
    <option value="<? echo $year ?>"  <? if ($year == $date_year2) {echo "selected"; } ?>><? echo $year ?></option>
<?
}
?>
          </select></td>

    </tr>
<tr>
      <td>Payment Type:</td>
      <td><label for="payment_mode"></label>
        <select name="payment_mode" id="payment_mode">
          <option value="ISW">Interswitch</option>
          <option value="BC">BranchCollect</option>
        </select></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td align="left"><input type="submit" name="Submit" value="Search" /></td>
    </tr>
    
  </table>
</form><br /><br />
<?
$date=$_GET['date'];
if(!$date){
$date=date("Y-m-d");
}

$sql="SELECT * FROM essay WHERE date='$date' AND status='Paid'";
$adjacents = 3;
$result=mysql_query($sql);
$total_pages=mysql_num_rows($result);
		$targetpage = "payment_query.php"; 	//your file name  (the name of this file)
	$limit = 5; 
	$page = $_GET['page'];
	if($page) 
		$start = ($page - 1) * $limit; 			//first item to display on this page
	else
		$start = 0;	

$sql22="SELECT * FROM essay WHERE date='$date' AND status='Paid' LIMIT $start,$limit";
$result22 = mysql_query($sql22) or die(mysql_error());
	$count22=mysql_num_rows($result22);
	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\">";
		if ($page > 1) 
			$pagination.= "<a href=\"$targetpage?page=$prev&date=$date\">« 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&date=$date\">$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&date=$date\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
			}
			//in middle; hide some front and some back
			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
			{
				$pagination.= "<a href=\"$targetpage?page=1&date=$date\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2&date=$date\">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&date=$date\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
			}
			//close to end; only hide early pages
			else
			{
				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2\">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&date=$date\">$counter</a>";					
				}
			}
		}
		
		//next button
		if ($page < $counter - 1) 
			$pagination.= "<a href=\"$targetpage?page=$next&date=$date\">next »</a>";
		else
			$pagination.= "<span class=\"disabled\">next »</span>";
		$pagination.= "</div>\n";		
	}

?><br /><br />
<table width="100%" border="1" cellspacing="0" cellpadding="5">
<th>S/No</th><th>Names</th><th>Trans Id</th><th>Amount</th><th>Date</th><th>Payment Mode</th>
<?
while ($row=mysql_fetch_array($result22))
{
	$sno++;
		$name=$row['name'];
	$amount=$row['amount'];
	$transid=$row['transactionid'];
	$mode=$row['payment_mode'];
	$stud_id=$row['stud_id'];
	$date_pay=$row['date'];
	$total+=$amount;
	?>
    
  <tr>
    <td><? echo $sno; ?></td>
    <td><? echo $name; ?></td>
    <td><? echo $transid ?></td>
    <td><? echo $amount ?></td>
    <td><? echo $date_pay ?></td>
    <td><? echo $mode ?></td>
  </tr>
  <? } ?>
  <tr><td colspan=5 align="right"><strong>Total: N <? echo number_format($total,2); ?></strong></td></tr>
  </table>
  <? 
if(!mysql_num_rows($result22)){
  echo "<div style=\"border: solid 1px;\">No Payment made today</div>";
	include("inc/footer.php");
		exit;
} ?>
  



<?=$pagination?>
<br /><br />
<? include("inc/footer.php"); ?>