ikan Uploader :
Directory : /var/www/html/shardahospital_old.org/lp/hospital-lms/
Upload File : |
| Current File : /var/www/html/shardahospital_old.org/lp/hospital-lms/landing_user_manage.php |
<?php
include("secure/db_config.php");
$query_access = mysqli_query($connection,"select * from `tbl_user` where user_type='User' and id='".$_SESSION['sid']."' order by id DESC");
$shor = mysqli_fetch_array($query_access);
$newacc = explode(',',$shor['access']);
$departments = $shor['department'];
if($_POST['summit1']) {
$calendar1 = $_POST['date'];
$calendar2 = $_POST['date2'];
$dmystart = date("Y-m-d", strtotime($calendar1));
$timestamp2 = strtotime($calendar2);
$dmyend = date("Y-m-d", $timestamp2);
if(($dmystart=='1970-01-01') || ($dmyend=='1970-01-01')){
echo "<script>window.location.href='index.php?mode=landing-management-system'</script>";
} else {
echo "<script>window.location.href='index.php?mode=landing-management-system&startdate=".$dmystart."&enddate=".$dmyend."'</script>";
}
}
?>
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<script type="application/javascript">
$(function(){
$(document).on('click','.trash',function(){
var syncid= $(this).attr('id');
var $ele = $(this).parent().parent();
if(confirm('Are you sure to remove this record ?'))
{
$.ajax({
type:'POST',
url:'deleteAll_record.php',
data:{'syncid':syncid},
success: function(data){
if(data){
$ele.fadeOut().remove();
}else{
alert("can't delete the row")
}
}
});
}
});
});
</script>
<div class="col-md-12">
<div class="box">
<div class="box-header">
<h3 class="box-title col-md-6 float-left">LMS Detail</h3><div class="col-md-6 float-right"><?php if(($newacc[0]=='0') || ($newacc[1]=='0') || ($newacc[2]=='0')) { ?><button type="button" class="btn btn-primary" style="float:right;"><a href="csv_export_LMS.php?startdate=<?php echo $_GET['startdate'];?>&enddate=<?php echo $_GET['enddate'];?>&department=<?php echo $departments;?>" class="button btn-primary" > Export to CSV File</a></button> <?php } ?></div>
</div>
<div class="box-header">
<form name="FRM" id="FRM" method="POST" class="form-inline">
<!-- Date input -->
<div class="form-group mb-2">
<label class="control-label" for="date">Start Date</label>
<input class="form-control-plaintext" id="date" name="date" placeholder="DD-MM-YYY" type="text" autocomplete="off"/>
</div>
<!-- Date input -->
<div class="form-group mx-sm-3 mb-2">
<label class="control-label" for="date2">End Date</label>
<input class="" id="date" name="date2" placeholder="DD-MM-YYY" type="text" autocomplete="off"/>
</div>
<div class="form-group">
<input type="submit" class="btn btn-primary mb-2" name="summit1" value="submit"/>
</div>
</form>
</div>
<div class="box-body">
<div ng-app="sa_app" ng-controller="controller" ng-init="show_data()">
<table <?php if(($newacc[0]=='2') || ($newacc[1]=='2') || ($newacc[2]=='2')){ ?>id="example1" <?php } ?> class="table table-bordered table-striped">
<thead>
<?php
if((!empty($_GET['startdate'])) and (!empty($_GET['enddate']))){
//$KEYWORD_SEARCH_6="and c_date BETWEEN '".$_GET['startdate']."' and '".$_GET['enddate']."' ";
$KEYWORD_SEARCH_6="and c_date > '".$_GET['startdate']." "."00:00:00"."' and c_date <= '".$_GET['enddate']." "."23:59:59"."' ";
if(!empty($_GET['startdate'])){
$nevars = "between ".date('d-m-Y',strtotime($_GET['startdate']))." to ".date('d-m-Y',strtotime($_GET['enddate']))."";
}
}
$queryt_synch = mysqli_query($connection,"select * from `tbl_lms_reg` WHERE 1 $KEYWORD_SEARCH_6 order by id DESC") or die(mysqli_error());
$totalrec = mysqli_num_rows($queryt_synch);
echo "<font color='#003399'>Total number of result is ".$totalrec." between ".$_GET['startdate']." to ".$_GET['enddate']."</font>";
?>
<br/><br/>
<tr>
<th width="77">Sr.No</th>
<th width="77">Name</th>
<th width="104">Phone No</th>
<th width="104">Email Id</th>
<th width="104">Department</th>
<th width="104">Date-Time</th>
<th width="124">Create Date</th>
<?php if(($newacc[0]=='1') || ($newacc[1]=='1') || ($newacc[2]=='1')){ ?>
<th width="49"> Delete </th>
<?php } ?>
</tr>
</thead>
<tbody>
<?php
$i=1;
if($totalrec>=0){
while($ret = mysqli_fetch_array($queryt_synch)){
?>
<tr ng-repeat="x in names">
<td><?php echo $i;?></td>
<td><?php echo $ret['full_name'];?></td>
<td><?php echo $ret['phone_no'];?></td>
<td><?php echo $ret['email'];?> </td>
<td><?php echo $ret['department'];?></td>
<td><?php echo $ret['date_time'];?></td>
<td><?php echo $ret['c_date'];?></td>
<?php if(($newacc[0]=='1') || ($newacc[1]=='1') || ($newacc[2]=='1')){ ?>
<td><i class="fa fa-bitbucket trash" aria-hidden="true" id="<?php echo $ret['id'];?>"></i></td>
<?php } ?>
</tr>
<?php $i++;} } else { echo "<font color='#990000'>Data are not available.</font>";} ?>
</tbody>
<tfoot>
</tfoot>
</table>
</div>
</div>
</div>
</div>
<script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/js/bootstrap-datepicker.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/css/bootstrap-datepicker3.css"/>
<script>
$(document).ready(function(){
var date_input=$('input[name="date"]'); //our date input has the name "date"
var container=$('.bootstrap-iso form').length>0 ? $('.bootstrap-iso form').parent() : "body";
date_input.datepicker({
format: 'dd-mm-yyyy',
container: container,
todayHighlight: true,
autoclose: true,
})
var date_input2=$('input[name="date2"]'); //our date input has the name "date"
var container=$('.bootstrap-iso form').length>0 ? $('.bootstrap-iso form').parent() : "body";
date_input2.datepicker({
format: 'dd-mm-yyyy',
container: container,
todayHighlight: true,
autoclose: true,
})
})
</script>
<link rel="stylesheet" href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
<script src="bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<script>
$(function () {
$('#example1').DataTable()
$('#example2').DataTable({
'paging' : true,
'lengthChange': false,
'searching' : false,
'ordering' : true,
'info' : true,
'autoWidth' : false
})
})
</script>
Kontol Shell Bypass