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 ] |
---|
<?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">© 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>