D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
balhit1357
/
balhit.ac.in
/
bal-vidyalaya
/
admin
/
Filename :
circularreport.php
back
Copy
<?php session_start(); require_once 'include/connection.php'; $uname="".$_SESSION['user_name']; if(!$_SESSION['user_name']) { $_SESSION['redirectURL'] = $_SERVER['REQUEST_URI']; ?> <script>window.location.href='index.php';</script> <?php } if( isset( $_SESSION['user_name']) ) { ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <link rel="shortcut icon" href="images/small.png" type="image/x-icon"> <title>BHUVNESH BAL VIDYALAYA</title> <!-- Bootstrap Core CSS --> <link href="bootstrap/dist/css/bootstrap.min.css" rel="stylesheet"> <!-- Menu CSS --> <link href="plugins/bower_components/sidebar-nav/dist/sidebar-nav.min.css" rel="stylesheet"> <!-- toast CSS --> <link href="plugins/bower_components/toast-master/css/jquery.toast.css" rel="stylesheet"> <!-- morris CSS --> <link href="plugins/bower_components/morrisjs/morris.css" rel="stylesheet"> <!-- chartist CSS --> <link href="plugins/bower_components/chartist-js/dist/chartist.min.css" rel="stylesheet"> <link href="plugins/bower_components/chartist-plugin-tooltip-master/dist/chartist-plugin-tooltip.css" rel="stylesheet"> <!--- data Table ------> <link href="plugins/bower_components/datatables/jquery.dataTables.min.css" rel="stylesheet" type="text/css" /> <!-- Calendar CSS --> <link href="plugins/bower_components/calendar/dist/fullcalendar.css" rel="stylesheet" /> <!-- animation CSS --> <link href="css/animate.css" rel="stylesheet"> <!-- Custom CSS --> <link href="css/style.css" rel="stylesheet"> <!-- color CSS --> <link href="css/colors/default.css" id="theme" rel="stylesheet"> <!---- calendar -----> <link rel="stylesheet" type="text/css" href="calendar2/css/sliderman.css" /> <link rel="stylesheet" type="text/css" href="calendar2/css/DateTimePicker.min.css"> </head> <body class="fix-header"> <div class="preloader"> <svg class="circular" viewBox="25 25 50 50"> <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" /> </svg> </div> <div id="wrapper"> <nav class="navbar navbar-default navbar-static-top m-b-0"> <?php include "include/header.php"; ?> </nav> <div class="navbar-default sidebar" role="navigation"> <div class="sidebar-nav slimscrollsidebar"> <div class="sidebar-head"> <h3><span class="fa-fw open-close"><i class="ti-close ti-menu"></i></span> <span class="hide-menu">Navigation</span></h3> </div> <div align="center"> </div> <div class="user-profile"> <div class="dropdown user-pro-body"> </div> </div> <ul class="nav" id="side-menu"> <?php include "include/menu.php"; ?> </ul> </div> </div> <div id="page-wrapper"> <div class="container-fluid"> <div class="kk_dsk_n"></div> <div style="float:right; margin-top: 20px;"><strong><a href="logout.php"> <input type="button" class="btn btn-primary-kk" value="LOGOUT" style="border-radius:4px;"> </a></strong></div> <div class="row"> <div class="col-md-12 col-sm-12 col-xs-12 kk_clear" style="margin-bottom:30px;"> <div style="padding:5px 30px; background-color:#5a8793; border-top-left-radius:8px; border-top-right-radius:8px;"><h2 style="color:#fff">Circular Report</h2> <div class="col-md-6"></div> </div> <div class="real_kk_block kk_tbl_white"> <div class="table-responsive table-striped" style="padding-top:25px;"> <!--<form onSubmit="return EW_checkMyForm(this);" action="Cadd_action.php" method="post" enctype="multipart/form-data">--> <?php $rs = mysqli_query($link, "select * from cir_detail order by sr_no desc"); ?> <!--<table width="100%" class="table" >--> <table id="myTable" class="table table-striped"> <!--<thead style="font-weight:bold;" ><tr><td>Sr.No.</td><td>Title</td><td>Description</td><td>Path</td><td>Edit</td><td>Delete</td></tr></thead>--> <thead> <tr> <th style="min-width:80px;">Sr. No. </th> <th>Title</th> <th style="min-width:100px;">Date</th> <th>Description</th> <th style="text-align:center">View</th> <th style="text-align:center">Edit</th> <th style="text-align:center">Delete</th> </tr> </thead> <?php $i = 1; while($row = mysqli_fetch_array($rs)){ ?> <tr> <td style="text-align:center"><?php echo $i; ?></td> <td><?php echo $row["title"]; ?></td> <td><?php echo $row["date"]; ?></td> <td><?php echo $row["description"]; ?></td> <td style="text-align:center"> <?php $fl = $row["datapath"]; $ext = strrchr($fl, '.'); if ($ext == ".pdf" || $ext == ".doc" || $ext == ".docx") { ?> <a href="textdoc/<?php echo $row["datapath"]; ?>" target="_blank"><i class="fa fa-search"></i><br> Download</a> <?php } elseif($fl == "" ) { ?> <?php } else { ?> <a href="javascript:void(0)" data-toggle="modal" data-target="#<?php echo $i; ?>"> <i class="fa fa-search"></i><br> view </a> <div id="<?php echo $i; ?>" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" style="display: none;"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-content"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> </div> <div class="modal-body"><img class="img-responsive" src="textdoc/<?php echo $row["datapath"]; ?>" /> </div> <div class="modal-footer"> <button type="button" class="btn btn-danger waves-effect waves-light" data-dismiss="modal">Close</button> </div> </div> </div> </div> <?php }?> </td> <td style="text-align:center"><a href="circularform_edit.php?id=<?php echo $row["sr_no"]; ?>" class="fa fa-pencil"><br><div style="font-size:11px; line-height:12px; font-family:Amiko">edit</div> </a></td> <td style="text-align:center"><a class="fa fa-trash" href="circulardelete.php?id=<?php echo $row["sr_no"]; ?>"><br><div style="font-size:11px; line-height:12px; font-family:Amiko">delete</div></a></td></tr> <?php $i++; } ?> </table> <!-- </form>--> </div> <br> </div> </div> </div> </div> <!-- /.container-fluid --> <footer class="footer text-center"> <?php include "include/footer.php"; ?> </footer> </div> </div> <!-- go-up --> <div class="go-up"><i class="fa fa-chevron-up"></i></div> <!-- js --> <script src="plugins/bower_components/jquery/dist/jquery.min.js"></script> <!-- Bootstrap Core JavaScript --> <script src="bootstrap/dist/js/bootstrap.min.js"></script> <!-- Menu Plugin JavaScript --> <script src="plugins/bower_components/sidebar-nav/dist/sidebar-nav.min.js"></script> <!--slimscroll JavaScript --> <script src="js/jquery.slimscroll.js"></script> <!--Wave Effects --> <script src="js/waves.js"></script> <!--Counter js --> <script src="plugins/bower_components/waypoints/lib/jquery.waypoints.js"></script> <script src="plugins/bower_components/counterup/jquery.counterup.min.js"></script> <!-- chartist chart --> <script src="plugins/bower_components/chartist-js/dist/chartist.min.js"></script> <script src="plugins/bower_components/chartist-plugin-tooltip-master/dist/chartist-plugin-tooltip.min.js"></script> <!-- Sparkline chart JavaScript --> <script src="plugins/bower_components/jquery-sparkline/jquery.sparkline.min.js"></script> <!---- calendar -----> <script src="calendar2/js/DateTimePicker.min.js"></script> <script> $('#dob1').DateTimePicker(); $('#dobp1').DateTimePicker(); $('#dobp2').DateTimePicker(); $('#dobp3').DateTimePicker(); $('#dobp4').DateTimePicker(); $('#dobp5').DateTimePicker(); $('#dobp6').DateTimePicker(); $('#cdate').DateTimePicker(); $('#jdate').DateTimePicker(); $('#jedate').DateTimePicker(); </script> <script> $(document).ready(function () { $('#myTable').DataTable(); $(document).ready(function () { var table = $('#example').DataTable({ "columnDefs": [ { "visible": false , "targets": 2 } ] , "order": [[2, 'asc']] , "displayLength": 25 , "drawCallback": function (settings) { var api = this.api(); var rows = api.rows({ page: 'current' }).nodes(); var last = null; api.column(2, { page: 'current' }).data().each(function (group, i) { if (last !== group) { $(rows).eq(i).before('<tr class="group"><td colspan="5">' + group + '</td></tr>'); last = group; } }); } }); // Order by the grouping $('#example tbody').on('click', 'tr.group', function () { var currentOrder = table.order()[0]; if (currentOrder[0] === 2 && currentOrder[1] === 'asc') { table.order([2, 'desc']).draw(); } else { table.order([2, 'asc']).draw(); } }); }); }); $('#example23').DataTable({ dom: 'Bfrtip' , buttons: [ 'copy', 'csv', 'excel', 'pdf', 'print' ] }); </script> <!-- go-up --> <script src="js/go_up.js"></script> <script src="plugins/bower_components/datatables/jquery.dataTables.min.js"></script> <!-- Custom Theme JavaScript --> <script src="js/custom.min.js"></script> <script src="js/dashboard1.js"></script> <script src="plugins/bower_components/toast-master/js/jquery.toast.js"></script> <!--Style Switcher --> <script src="plugins/bower_components/styleswitcher/jQuery.style.switcher.js"></script> </body> </html> <?php } else { ?> <script> window.location.href="index.php"; </script> <?php } ?>