/home3/vehiclea/public_html/mamacloud/userList.php
<?php
session_start();
$_SESSION['active'] = 'userReport';
include 'header.php';
include 'sidelinks.php';
?>
<div class="content-wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-sm-12 p-0">
<div class="main-header">
<h4 style="color:#2567b3">USER REPORT</h4>
<ol class="breadcrumb breadcrumb-title breadcrumb-arrow">
<li class="breadcrumb-item">
<a href="index.php">
<i class="icofont icofont-home"></i>
</a>
</li>
<li class="breadcrumb-item"><a href="#">Reports</a></li>
<li class="breadcrumb-item"><a href="userList.php">User Report</a>
</li>
</ol>
</div>
</div>
</div>
<?php
if(!empty($_GET['upd'])){
?>
<div align="center"><h4 style="color:green;">Updated User Data Succefully </h4></div>
<?php
header( "refresh:1;url=userList.php" );
}
?>
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<h5 class="card-header-text">User Report</h5>
</div>
<div class="card-header">
<div class="col-md-4">
<label class="control-label"><b>From Date:</b></label>
<div class="form-group">
<input class="form-control" id="min" placeholder="DD-MM-YYYY" type="text"/>
</div>
</div>
<div class="col-md-4">
<label class="control-label"><b>To Date:</b></label>
<div class="form-group">
<input class="form-control" id="max" placeholder="DD-MM-YYYY" type="text"/>
</div>
</div>
<div class="col-sm-4" >
<h4 style="font-size:16px;">
<b>Total Value :</b><b style="color:Red;"> <label id="Sum_TotalRecords"></label></b></h4>
</div>
</div>
<div class="card-block" style="overflow-x:auto;">
<table class="table datatable" id="getting_data">
<thead>
<tr>
<th>S.NO.</th>
<th>Partner Name</th>
<th>Partner ID</th>
<th>User ID</th>
<th>Firstname</th>
<th>Lastname</th>
<th>Phone No</th>
<th>Mail ID</th>
<th>Created Date</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tfoot id="tfoot1">
<tr>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search S.NO.">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Partner Name">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Partner Id">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search User Id">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Firstname">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Lastname">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Phone No">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Mail ID">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Created Date">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Status">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Action">
</th>
</tr>
</tfoot>
<tbody>
<?php
$i=1;
if ($_SESSION['type'] == 'partner') {
$addUserData = mysqli_query($conn,"SELECT * FROM addUser where partnerId = '".$_SESSION['partnerId']."'");
} else {
$addUserData = mysqli_query($conn,"SELECT * FROM addUser");
}
while($addUserDataRec = mysqli_fetch_array($addUserData)){
$userName = mysqli_query($conn,"SELECT partnerId,firstName,lastName FROM addPartner where partnerId = '".$addUserDataRec['partnerId']."'");
$userNameData = mysqli_fetch_array($userName);
$name = $userNameData['firstName'].' '.$userNameData['lastName'];
?>
<tr>
<td><?= $i ?></td>
<td><?= $name ?></td>
<td><?= $addUserDataRec['partnerId']?></td>
<td><?= $addUserDataRec['userId']?></td>
<td><?= $addUserDataRec['firstName']?></td>
<td><?= $addUserDataRec['lastName']?></td>
<td><?= $addUserDataRec['phoneNo']?></td>
<td><?= $addUserDataRec['mailId']?></td>
<td><?= date('d-M-Y',strtotime($addUserDataRec['create_date']))?></td>
<td><?php if($addUserDataRec['status'] == '0'){ ?> Inactive <?php } else { ?> Active <?php } ?></td>
<!-- <td>
<a href="userEdit.php?editId=<?php echo $addUserDataRec['id']?>" class="btn btn-primary"><i class="icofont icofont-edit"></i> Edit </a>
<a href="addInstance.php?editId=<?php echo $addUserDataRec['id']?>" class="btn btn-primary"><i class="icofont icofont-edit"></i> Instance </a>
</td> -->
<td> <ul class="top-nav">
<li class="dropdown">
<a href="#" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false" class="dropdown-toggle drop icon-circle drop-image"> Action </a>
<ul class="dropdown-menu settings-menu" style="color:green;">
<li><a href="addInstance.php?editId=<?php echo $addUserDataRec['id']?>" ><i class="icofont icofont-edit"></i> Add Instance </a></li>
<li><a href="userEdit.php?editId=<?php echo $addUserDataRec['id']?>"><i class="icofont icofont-edit"></i> Edit Profile</a></li>
</ul>
</li>
</ul></td>
</tr>
<?php $i++; } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function() {
$('#getting_data tfoot th').each(function () {
var title = $('#getting_data thead th').eq($(this).index()).text();
$(this).html('<input type="text" placeholder="Search ' + title + '" />');
});
var table = $('#getting_data').DataTable({
dom: 'Bfrtip',
buttons: [
'colvis','excel', 'pdf'
],
"fnDrawCallback": function (oSettings) {
var api = this.api(), data;
var intVal = function (i) {
return typeof i === 'string' ?
i.replace(/[\$,]/g, '') * 1 :
typeof i === 'number' ?
i : 0;
};
}
});
$("#getting_data tfoot input").on('keyup change', function () {
table
.column($(this).parent().index() + ':visible')
.search(this.value)
.draw();
});
});
</script>
<script type="text/javascript">
$(document).ready(function() {
$.fn.dataTable.ext.search.push(
function(settings, data, dataIndex) {
var min = $('#min').datepicker("getDate");
var max = $('#max').datepicker("getDate");
var startDate = new Date(data[9]);
if (min == null && max == null) {
return true;
}
if (min == null && startDate <= max) {
return true;
}
if (max == null && startDate >= min) {
return true;
}
if (startDate <= max && startDate >= min) {
return true;
}
return false;
}
);
$("#min").datepicker({
dateFormat: "dd-M-yy",
type: 'datetime',
onSelect: function() {
table.draw();
},
changeMonth: true,
changeYear: true
});
$("#max").datepicker({
dateFormat: "dd-M-yy",
type: 'datetime',
onSelect: function() {
table.draw();
},
changeMonth: true,
changeYear: true
});
var table = $('#getting_data').DataTable();
$('#min, #max').change(function() {
table.draw();
});
});
</script>
<?php include 'footer.php' ?>
@LwBee Strong Bypass
Upload File
Create New File