<?php
error_reporting(0);
include("common/function.php");
include("common/connect.php");
$convert=new Encryptionpassword;
$dt=$_GET['id'];
$date = $convert->decode($dt);


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body onload="window.print()">
    <link type="text/css" href="assets/css/styles.css" rel="stylesheet">                                     <!-- Core CSS with all styles -->
<div class="page-content">
                            
                            <div class="container-fluid">
                                
<div class="row">
    <div class="col-md-12">
        <div class="panel panel-transparent">
            <div class="panel-body">
                
                
                <div class="row mb-xl">
                    <div class="col-md-12">
                        <div class="panel">
                            <div class="panel-body no-padding">
                                <div class="table-responsive">
                                    <div align="center"><h3>Suresh Gyan Vihar University Jaipur</h3>
									Cash Wise Summary Report 2015-2016 (Date: <?php echo $date; ?>)
									</div>
									<hr />
									<table class="table table-hover m-n" style="width:100%">
                                        <thead>
                                            <tr>
                                                <th width="40">S.No.</th>
                                                <th width="72">SID</th>
                                                <th width="186">Name</th>
                                                <th width="169">Father's Name</th>
                                                <th width="169">Branch</th>
                                                <th width="68">Sem</th>
                                                <th width="91">R.No</th>
                                                <th width="139">Date</th>
                                                <th width="139">Amount </th>
                                                <th width="200">Head</th>
                                            </tr>
                                        </thead>
										
                                        <tbody>
                                         <?php
							$GetList = mysql_query("SELECT * FROM  `sgvu_finence_receipt1` WHERE  `date` =  '$date' AND `status` ='3' ORDER BY  `sgvu_finence_receipt1`.`recpt_no` ASC ");
							while($GetList1 = mysql_fetch_assoc($GetList))
							{
							 $s =$_REQUEST['v'];

$u = $s+0;
							
							?>
                                            <tr>
                                                <td style="width:40px"><?php echo $_REQUEST['v'] = $u+1; ?></td>
                                                <td><?php echo $GetList1['sid']; ?></td>
                                                <td><?php 
												$GetStudent=mysql_query("SELECT * FROM  `sgvu_cash_receipt` WHERE  `recpt_no` =  '$GetList1[recpt_no]'");
												$GetStudent1=mysql_fetch_assoc($GetStudent);
												echo $GetStudent1['student_name'];
												 ?></td>
                                                <td><?php echo $GetStudent1['father_name']; ?></td>
                                                <td class=""><?php 
												$GetCourse=mysql_query("SELECT * FROM `sgvu_courses` WHERE `course_id` ='$GetStudent1[course]'");
												$GetCourse1=mysql_fetch_assoc($GetCourse);
												echo $GetCourse1['coursename'];
												 ?></td>
                                                <td class=""><?php echo $GetList1['sem']; ?></td>
                                                <td class=""><?php echo $GetList1['recpt_no']; ?></td>
                                                <td class=""><?php $d=$GetList1['time']; 
												echo date('d-m-Y',$d);
												?></td>
                                                <td class=""><?php 
												if($GetList1['ip']=='2')
												{
												echo '00';
												}
												else
												{
												echo $tot[]=$GetList1['amount']; 
												}
												
												?></td>
                                                <td class="" style="width:200px">
												
												<?php $GetList1['fee'];
												$GetHead=mysql_query("SELECT * FROM `sgvu_fee_type` WHERE `id` = '$GetList1[fee_type]'");
												$GetHead1=mysql_fetch_assoc($GetHead);
												if($GetList1['ip']=='2')
												{
												echo 'Cancelled';
												}
												else
												{
												echo $GetHead1['fees_type'];
												}
												 ?></td>
                                            </tr>
											<?php
											}
											?>
                                        </tbody>
										<tfoot>
										<tr>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th>G.Total</th>
                                                <th>Rs. <?php
								echo $gran_tot=array_sum($tot);

								?></th>
                                <th></th>
                                            </tr>
										</tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>

                    
                </div>
                    
                
            </div>
        </div>
    </div>
                            </div> <!-- .container-fluid -->
                        </div> <!-- #page-content -->
                    </div>
</body>
</html>
