One Hat Cyber Team

View File Name : payment_query22.php

<?
include("inc/header.php");
include_once("config_nsemem.php");
?>
<? require_once("searchpay_form.php"); ?><br /><br />
<?
include "config_nsemem.php";


$from="$date_year-$date_month-$date_day";
$to="$date_year2-$date_month2-$date_day2";

$sql="SELECT * FROM essay WHERE date BETWEEN '$from' AND '$to' AND status='Paid' AND payment_mode='$payment_mode' ";
$result=mysql_query($sql);
$nr = mysql_num_rows($result); 
if (isset($_GET['pn'])) { 
$pn = preg_replace('#[^0-9]#i', '', $_GET['pn']);
} else {
	$pn = 1;
} 
$itemsPerPage = 5;
$lastPage = ceil($nr / $itemsPerPage);
if ($pn < 1) {
$pn = 1;
} elseif($pn > $lastPage) {
	$pn = $lastPage;
}
$centerPages = "";
$sub1 = $pn - 1;
$sub2 = $pn - 2;
$add1 = $pn + 1;
$add2 = $pn + 2;
if ($pn == 1) {
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
} else if ($pn == $lastPage) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
} else if ($pn > 2 && $pn < ($lastPage - 1)) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub2 . '">' . $sub2 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add2 . '">' . $add2 . '</a> &nbsp;';
} else if ($pn > 1 && $pn < $lastPage) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
}
$limit = 'LIMIT ' .($pn - 1) * $itemsPerPage .',' .$itemsPerPage; 
$sql22="SELECT * FROM essay WHERE date BETWEEN '$from' AND '$to' AND status='Paid' AND payment_mode='$payment_mode'";
//$sql22="SELECT * FROM essay WHERE date='$date' AND status='Paid'";
$paginationDisplay = "";
if ($lastPage != "1"){
	$paginationDisplay .= 'Page <strong>' . $pn . '</strong> of ' . $lastPage. '&nbsp;  &nbsp;  &nbsp; ';
	if ($pn != 1) {
        $previous = $pn - 1;
        $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $previous . '"> Back</a> ';
    } 
	$paginationDisplay .= '<span class="paginationNumbers">' . $centerPages . '</span>';
    // If we are not on the very last page we can place the Next button
    if ($pn != $lastPage) {
        $nextPage = $pn + 1;
        $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $nextPage . '"> Next</a> ';
    }
}
$result22=mysql_query($sql22);
if(!$result22){
	echo "<div style=\"border: solid 1px;\">No Payment made today</div>";
	include("inc/footer.php");
		exit;
}
$sno=0;
?>
<table width="100%" border="1" cellspacing="0" cellpadding="5">
<tr>
<!--  <th colspan="5">Search Date: From <? echo $from?> - <? $to; ?>"; ?>&nbsp;</th>-->
  <th>S/No</th><th>Names</th><th>Trans Id</th><th>Amount</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'];
	$total+=$amount;
	?>
    
  <tr>
    <td><? echo $sno; ?></td>
    <td><? echo $name; ?></td>
    <td><? echo $transid ?></td>
    <td><? echo $amount ?></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;
} ?>
  <div style="margin-left:64px; margin-right:64px;">
     <h2>Total Items: <?php echo $nr; ?></h2>
   </div>
      <div style="margin-left:58px; margin-right:58px; padding:6px; background-color:#FFF; "><?php echo $paginationDisplay; ?></div>
      <div style="margin-left:64px; margin-right:64px;"><?php print "$outputList"; ?></div>


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