<?php
error_reporting(0);
ob_start();
session_start();
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>
									DD/Cheque Wise Summary Report <?php 
$GetSes=mysql_query("SELECT * FROM `sgvu_session` WHERE `ses_id` ='$_SESSION[ses_id]'");
$GetSes1=mysql_fetch_assoc($GetSes);
echo $GetSes1['session'];
 ?> (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">DD/Cheque No</th>
                                                <th width="91">Receipt No</th>
                                                <th width="">Date</th>
                                                <th width="139">Amount </th>
                                                <th width="">Head</th>
                                            </tr>
                                        </thead>
										
                                        <tbody>
                                         <?php
							$GetList = mysql_query("SELECT * FROM `sgvu_new_admission_dd_cheque` WHERE `date` = '$date'");
							while($GetList1 = mysql_fetch_assoc($GetList))
							{
							 $s =$_REQUEST['v'];

							$u = $s+0;
							$GetStDetail=mysql_query("SELECT * FROM `step1_perosonal` WHERE `sid` = '$GetList1[sid]'");
							$GetStDetail1=mysql_fetch_assoc($GetStDetail);
							
							?>
                                            <tr>
                                                <td style="width:40px"><?php echo $_REQUEST['v'] = $u+1; ?></td>
                                                <td><?php echo $GetList1['sid']; ?></td>
                                                <td><?php echo $GetStDetail1['firstname'].' '.$GetStDetail1['middlename'].' '.$GetStDetail1['lastname']; ?></td>
                                                <td><?php echo $GetStDetail1['father_name']; ?></td>
                                                <td class=""><?php 
												$GetCourse=mysql_query("SELECT * FROM `sgvu_courses` WHERE `course_id` ='$GetStDetail1[program]'");
												$GetCourse1=mysql_fetch_assoc($GetCourse);
												echo $GetCourse1['coursename'];
												 ?></td>
                                                <td class="">1</td>
                                                <td class=""><?php echo $GetList1['dd_cheue_no']; ?></td>
                                                <td class=""><?php echo $GetList1['ReceptNo']; ?></td>
                                                <td class=""><?php echo $GetList1['dd_cheque_date']; ?></td>
                                                <td class=""><?php echo $tot[]=$GetList1['amount']; ?></td>
                                                <td class="" style="width:200px">DD/Cheque</td>
                                            </tr>
											<?php
											}
											?>
                                        </tbody>
										<tfoot>
										<tr>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                                <th>G.Total</th>
                                                <th><?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>
