MMCT TEAM
Server IP : 2a02:4780:3:1378:0:3736:a38e:10  /  Your IP : 3.135.185.223
Web Server : LiteSpeed
System : Linux sg-nme-web1278.main-hosting.eu 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64
User : u926327694 ( 926327694)
PHP Version : 7.4.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0755) :  /home/u926327694/domains/smsoft.in/public_html/demo/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/u926327694/domains/smsoft.in/public_html/demo/recpt_report_excle_print2.php
<?php 

    // First we execute our common code to connection to the database and start the session 
    require("common.php"); 
     
    // At the top of the page we check to see whether the user is logged in or not 
    if(!isset($_SESSION['user']) && !isset($_SESSION['Mng_User'])) 
    { 
        // If they are not, we redirect them to the login page. 
        header("Location: login.php"); 
         
        // Remember that this die statement is absolutely critical.  Without it, 
        // people can view your members-only content without logging in. 
        die("Redirecting to login.php"); 
    } 
     
    // Everything below this point in the file is secured by the login system 
     
    // We can display the user's username to them by reading it from the session array.  Remember that because 
    // a username is user submitted content we must use htmlentities on it before displaying it to the user. 
?> 






<?php include "config/config.php";
$r=mysqli_query($con,"select * from class");
$r1=mysqli_query($con,"select * from division");
$r2=mysqli_query($con,"select * from head  ");
?>

<!DOCTYPE html>
<html>
<head>
  <!-- start: Meta -->
  <meta charset="utf-8">
<title>Receipt Report List</title>  <meta name="description" content="Bootstrap Metro Dashboard">
  <meta name="author" content="Dennis Ji">
  <meta name="keyword" content="Metro, Metro UI, Dashboard, Bootstrap, Admin, Template, Theme, Responsive, Fluid, Retina">
  <!-- end: Meta -->
  
  <!-- start: Mobile Specific -->
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <!-- end: Mobile Specific -->
  
  <!-- start: CSS -->
  <link id="bootstrap-style" href="css/bootstrap.min.css" rel="stylesheet">
  <link href="css/bootstrap-responsive.min.css" rel="stylesheet">
  <link id="base-style" href="css/style.css" rel="stylesheet">
  <link id="base-style-responsive" href="css/style-responsive.css" rel="stylesheet">
  <link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800&subset=latin,cyrillic-ext,latin-ext' rel='stylesheet' type='text/css'>
  <!-- end: CSS -->
  

  <!-- The HTML5 shim, for IE6-8 support of HTML5 elements -->
  <!--[if lt IE 9]>
      <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
    <link id="ie-style" href="css/ie.css" rel="stylesheet">
  <![endif]-->
  
  <!--[if IE 9]>
    <link id="ie9style" href="css/ie9.css" rel="stylesheet">
  <![endif]-->
    
  <!-- start: Favicon -->
  <link rel="shortcut icon" href="img/favicon.ico">
  <!-- end: Favicon -->
  
    <style type="text/css">
<!--
.style1 {
  color: #3300CC;
  font-weight: bold;
}
.style2 {
  color: #FF0000;
  font-weight: bold;
}
.style4 {
  color: #CC00FF;
  font-weight: bold;
}
-->
</style>

    







     <script src="https://code.jquery.com/jquery-3.3.1.js"></script>
 <script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css"/>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.1/css/buttons.dataTables.min.css"/>
    <script type="text/javascript">
    	$.fn.dataTable.ext.errMode = 'none';
        $(document).ready(function() {
    $('#example').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copyHtml5',
            'excelHtml5',
            'csvHtml5',
            'pdfHtml5'
        ]
    } );
} );
                $(document).ready(function() {
    $('#example1').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copyHtml5',
            'excelHtml5',
            'csvHtml5',
            'pdfHtml5'
        ]
    } );
} );
    $(document).ready(function() {
    $('#example2').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copyHtml5',
            'excelHtml5',
            'csvHtml5',
            'pdfHtml5'
        ]
    } );
} );
     $(document).ready(function() {
    $('#example3').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copyHtml5',
            'excelHtml5',
            'csvHtml5',
            'pdfHtml5'
        ]
    } );
} );
    $(document).ready(function() {
    $('#example4').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copyHtml5',
            'excelHtml5',
            'csvHtml5',
            'pdfHtml5'
        ]
    } );
} );
    </script>
        <script src="js/jquery-migrate-1.0.0.min.js"></script>
    
    
        <script src="js/jquery-ui-1.10.0.custom.min.js"></script>
    
      <script src="js/jquery.ui.touch-punch.js"></script>
    
        <script src="js/modernizr.js"></script>
  <script src="js/bootstrap.min.js"></script>
    
          
         <script src="js/jquery.cookie.js"></script>
    
        <script src='js/fullcalendar.min.js'></script>
    
        

         <script src="js/excanvas.js"></script>
    <script src="js/jquery.flot.js"></script>
    <script src="js/jquery.flot.pie.js"></script>
    <script src="js/jquery.flot.stack.js"></script>
    <script src="js/jquery.flot.resize.min.js"></script>
    
        <script src="js/jquery.chosen.min.js"></script>
    
        <script src="js/jquery.uniform.min.js"></script>
        
        <script src="js/jquery.cleditor.min.js"></script>
    
        <script src="js/jquery.noty.js"></script>
    
        <script src="js/jquery.elfinder.min.js"></script>
    
        <script src="js/jquery.raty.min.js"></script>
    
        <script src="js/jquery.iphone.toggle.js"></script>
    
        <script src="js/jquery.uploadify-3.1.min.js"></script>
    
        <script src="js/jquery.gritter.min.js"></script>
    
        <script src="js/jquery.imagesloaded.js"></script>
    
        <script src="js/jquery.masonry.min.js"></script>
    
        <script src="js/jquery.knob.modified.js"></script>
    
        <script src="js/jquery.sparkline.min.js"></script>
    
        <script src="js/counter.js"></script>
    
        <script src="js/retina.js"></script>

        <script src="js/custom.js"></script>
        <style>
            .table-responsive {
    display: block;
    width: 100%;
    overflow-x: auto;
    -webkit-overflow-scrolling: touch;
    -ms-overflow-style: -ms-autohiding-scrollbar;
}
        </style>
</head>

<body onLoad="myFunction()">
		<!-- start: Header -->

	<!-- start: Header -->

			
		



<div class="table-responsive">
<table width="945" border="3" align="center">
  <tr>
    <td width="313">Fees Code:
      <?php if($d=isset($_POST["head"]))
	{
	
	 $sql6=mysqli_query($con,"SELECT * FROM `head` WHERE `Head_Id` = '$_POST[head]'");
                	$row9=mysqli_fetch_array($sql6);
                	echo "<font color='Blue'><b> $row9[Name] </b> </font>";


	}
	?> </td>
	<td>Class:<?php if($e=isset($_POST["Class"]))
	{
	echo "<font color='Blue'><b> $_POST[Class] </b> </font>";
	}
	?></td>
    <td>Division:<?php if($f=isset($_POST["Division"]))
	{
	echo "<font color='Blue'><b> $_POST[Division] </b> </font>";
	}
	?></td>
    </tr>
</table>
</div>
<br>

<div class="box-content">
<div class="row-fluid sortable">		
				<div class="box span12">
					<div class="box-header" data-original-title>
						<h2><i class="halflings-icon white user"></i><span class="break"></span>Students</h2>
						<div class="box-icon">
							
						</div>
					</div>
					<div class="box-content" >
					
					

<?php 


 




?>
							
						
	
					

							<div class="table-responsive">
						<table id="example" class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							 <tr>
							     <th>Sr. No.</th>
								   <th>Class</th>
								    <th>Div</th>
								     <th>Student Name</th>
								      <th>Fees Code</th>
								        <th>Total</th>
								        <th>Balance</th>
								        <th>Date</th>
								  <th>Recipt No.</th>      
								       <?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') 
{

if (isset($_POST['Subb']))
 if ($_POST['Subb'] != NULL)
 {
 $Subb=$_POST["Subb"]; 
                
 }
  if (isset($_POST['head']))
 if ($_POST['head'] != NULL)
 {
 $Head_Id=$_POST["head"]; 
                
 }

?>
								       <?php
							if($Subb == "Yes")
							{ ?>
							
							<?php
							
							$qu=mysqli_query($con,"select `SubHeads` from head where `Head_Id` = '$Head_Id'");
							$qu1=mysqli_fetch_array($qu);
							
							$qu2=explode("/",$qu1[0]);
							foreach($qu2 as $qu3)
							{ ?>
							<th><?php 
							
							
							$qu4=mysqli_query($con,"select `Name` from sub_head where `Sub_Id` = '$qu3'");
							$qu5=mysqli_fetch_array($qu4);
							
							 echo $qu5[0]; ?></th>

							<?php
							}
							?>
							
							
						   <?php }else
							{
							?><th>
							<?php
							 
							 echo"Amount";
							 
							 
							 
							 ?>
							 </th>
							 <?php
							 }
							 
							 
							 
							 }
							  ?>
								  
						    </tr>
						  </thead>   
						  <tbody>

						  
							
							
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') 
{
	$argu="";
if (isset($_POST['Class']))
 if ($_POST['Class'] != NULL)
 {
 $Class=$_POST["Class"]; 
 $argu=$argu."and stud_basic.Class='$Class'";                 
 }



if (isset($_POST['Division']))
 if ($_POST['Division'] != NULL)
 {
 $Division=$_POST["Division"]; 
 $argu=$argu." and  stud_basic.Division='$Division'";  
 }


  if (isset($_POST['head']))
 if ($_POST['head'] != NULL)
 {
 $Head_Id=$_POST["head"]; 
 $argu=$argu."and paid_fees.Head_Id='$Head_Id'";                 
 }




if (isset($_POST['Subb']))
 if ($_POST['Subb'] != NULL)
 {
 $Subb=$_POST["Subb"]; 
                
 }


?>
	
		<?php
    $sqll= "SELECT paid_fees.Recipt_No, stud_basic.Class, stud_basic.Division, stud_basic.Name, paid_fees.Head_Id,
    paid_fees.Grand_Total, paid_fees.Paid_date, stud_basic.Stud_Id, paid_fees.Mode, paid_fees.DateNumber,
    paid_fees.Recp_Book_No AS recpno
FROM stud_basic
INNER JOIN stud_basic2 ON stud_basic.Stud_Id = stud_basic2.Stud_Id
INNER JOIN (
    SELECT Stud_Id, MAX(Paid_date) AS Last_Paid_date
    FROM paid_fees
    GROUP BY Stud_Id
) AS last_paid_dates ON stud_basic2.Stud_Id = last_paid_dates.Stud_Id
INNER JOIN paid_fees ON stud_basic2.Stud_Id = paid_fees.Stud_Id
    AND last_paid_dates.Stud_Id = paid_fees.Stud_Id
    AND last_paid_dates.Last_Paid_date = paid_fees.Paid_date
INNER JOIN head ON head.Head_Id = paid_fees.Head_Id
WHERE '0' = '0' $argu
GROUP BY paid_fees.Recipt_No, stud_basic.Class, stud_basic.Division, stud_basic.Name, paid_fees.Head_Id,
    paid_fees.Grand_Total, paid_fees.Paid_date, stud_basic.Stud_Id, paid_fees.Mode, paid_fees.DateNumber,
    paid_fees.Recp_Book_No";    

//echo "$sqll<br>";
 $res=mysqli_query($con,$sqll);
$ii=1;
 while($data=mysqli_fetch_array($res))
 {
 	//$cc=sizeof($data);
 	//echo "cc=$cc<br>$sqll";

 
 	//echo "$sqll";
 ?><tr>
 	<?php 
 	$hd_res=mysqli_query($con,"select * from head where Head_Id = '$data[4]'");
 	$hd=mysqli_fetch_array($hd_res);
 	
 	$Stud_Id=$data['Stud_Id'];
 	$tmp_rs=mysqli_query($con,"select SUM(stud_basic2.Total_Amount) AS Total_Amount,SUM(stud_basic2.Balance) AS Balance from stud_basic2 where Head_Id = '$data[4]' AND Stud_Id=$Stud_Id");
 	$pt_res=mysqli_fetch_array($tmp_rs);
 	 ?>
 	                        <td><?php echo $ii++; ?></td>
							<td><?php echo $data['1']; ?></td>
							<td><?php echo $data['2']; ?></td>
							<td><a href="stud_profile.php?key=<?php echo "$data[Stud_Id]";   ?>" ><?php echo "$data[3]"; ?></a></td>
							<td><?php echo $hd['Name']; ?>   </td>
							<td><?php echo $pt_res['Total_Amount']; ?></td>
							<td><?php echo $pt_res['Balance']; ?></td>
							<td><?php echo $data['6']; ?></td>
							<td><?php echo $data['0']; ?></td>
							 <?php
							if($Subb == "Yes")
							{ ?>
							
							<?php
							$qu=mysqli_query($con,"select `SubHeads` from head where `Head_Id` = '$Head_Id'");
							$qu1=mysqli_fetch_array($qu);
							
							$qu2=explode("/",$qu1[0]);
							foreach($qu2 as $qu3)
							{ ?>
							<td><?php 
							$qu4=mysqli_query($con,"select * from sub_head where `Sub_Id` = '$qu3'");
							$qu5=mysqli_fetch_array($qu4);
						
							$paid_res=mysqli_query($con,"SELECT * FROM `paid_fees` WHERE `Recipt_No` = '$data[recpno]'");
							$paid=mysqli_fetch_array($paid_res);
							
							$subid_arr=explode("/",$paid['Subhead_Ids']);
							
							$amount_arr=explode("/",$paid['Sub_Amounts']);
							 $index= array_search($qu3,$subid_arr,true);
                            if($index != ""){
                                echo $amount_arr[$index];
                            }else{
                                echo "0";
                            }
							 
							 ?></td>

							<?php
							}
							?>
							
							<?php
							}else
							{
							?><td>
							<?php
							 echo $data['5'];
							 ?>
							 </td>
							 <?php
							 }
							 ?>
							 
							 <?php
							 }
							  ?>
							
							
							
							
							
							
						 </tr> <?php
 }
  
	

			


				
						?>
						
						  </tbody>
					  </table> 

										</div>
					  
	


					
					</div> </div> </div>
							  	           
		
    

	
		

	
	<div class="clearfix"></div>
	
	
	<div class="clearfix"></div>
	
	<footer>

		<p>
			<span style="text-align:left;float:left">&copy; 2018 <a href="http://evisioninfotech.in" alt="Bootstrap_Metro_Dashboard">e vision infotech</a></span>
			
		</p>

	</footer>

</body>
</html>

	


MMCT - 2023