/home3/vehiclea/public_html/mamacloud/instance.php
<?php
session_start();
$_SESSION['active'] = 'instanceReport';
include 'header.php';
include 'sidelinks.php';
$selectInstance = select_addInstance();
?>
?>
<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">INSTANCE 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="instanceReport.php">Instance Report</a>
</li>
</ol>
</div>
</div>
</div>
<?php
if(!empty($_GET['mailIdSame']))
{
?>
<div align="center"><h4 style="color:red;"> Mail Id Already Registered </h4></div>
<?php
// header( "refresh:5;url=addInstanceEdit.php" );
}
?>
<?php
if(!empty($_GET['subUserStored'])){
?>
<div align="center"><h4 style="color:Green;">Sub User Data Inserted Sucessfully</h4></div>
<?php
// header( "refresh:5;url=addInstanceEdit.php" );
}
?>
<?php
if(!empty($_GET['failed'])){
?>
<div align="center"><h4 style="color:red;">Already Instance Data Inserted </h4></div>
<?php
// header( "refresh:5;url=addInstanceEdit.php" );
}
?>
<?php
if(!empty($_GET['del'])){
?>
<div align="center"><h4 style="color:red;">Instance Data Deleted Sucessfully </h4></div>
<?php
// header( "refresh:5;url=addInstanceEdit.php" );
}
if(!empty($_GET['updated'])){
?>
<div align="center"><h4 style="color:green;">Updated Instance Data Successfully </h4></div>
<?php
}
?>
<?php
if(!empty($_GET['succ'])){
?>
<div align="center"><h4 style="color:green;">Instance Data Inserted Sucessfully </h4></div>
<?php
// header( "refresh:5;url=addInstanceEdit.php" );
}
?>
<?php if($_SESSION['loginType'] == 'admin') { ?>
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<h5 class="card-header-text">INSTANCE REPORT</h5>
</div>
<div class="card-header">
<div class="col-md-6">
<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-6">
<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>
<div class="card-block" style="overflow-x:auto;">
<table class="table datatable" id="getting_data">
<thead>
<tr>
<th>S.No.</th>
<th>Date Of Creation</th>
<th>Partner Name</th>
<th>Customer</th>
<th>Instance</th>
<th>ID NO.</th>
<th>Company Name</th>
<th>Created At</th>
<th>INSTANCES EXPIRY DATE</th>
<th>TOTAL USERS</th>
<th>ACTIVE USERS</th>
<th>RATE PER USER</th>
<th>TOTAL DUE</th>
<th>BILL GENERATED DATE</th>
<th>AMOUT PAID DETAILS</th>
<th>UPI LINK</th>
<th>TALLY LICENSE SL.NO.</th>
<th>TALLY VERSION</th>
<th>TALLY RELEASE</th>
<th>TALLY DOT NET ID</th>
<th>TALLY DOT NET PASSWORD</th>
<th>TSS EXPIRY DATE</th>
<th>CONTACT PERSON NAME</th>
<th>MOBILE NO</th>
<th>SERVER IP</th>
<th>RDP LOGIN ID</th>
<th>PASSWORD</th>
<th>FILEZILLA ID</th>
<th>PASSWORD</th>
<th>Status</th>
<th>Logins</th>
<th>#</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 Date Of Creation">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Partner Name">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Customer">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Instance">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search ID NO.">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Company Name">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Created At">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search INSTANCES EXPIRY DATE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TOTAL USERS">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search ACTIVE USERS">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search RATE PER USER">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TOTAL DUE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search BILL GENERATED DATE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search AMOUT PAID DETAILS">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search UPI LINK">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY LICENSE SL.NO.">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY VERSION">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY RELEASE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY DOT NET ID">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY DOT NET PASSWORD">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TSS EXPIRY DATE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search CONTACT PERSON NAME">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search MOBILE NO">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search SERVER IP">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search RDP LOGIN ID">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search PASSWORD">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search FILEZILLA ID">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search PASSWORD">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Status">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Logins">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search #">
</th>
</tr>
</tfoot>
<tbody>
<?php
$i=1;
while($selectInstanceData = mysqli_fetch_array($selectInstance))
{
$addpartName = mysqli_query($conn,"SELECT * FROM addPartner where partnerId = '".$selectInstanceData['partnerId']."'");
$addpartNameData = mysqli_fetch_array($addpartName);
$fullName = $addpartNameData['firstName'].' '.$addpartNameData['lastName'];
$addInstUID = "SELECT COUNT(*) FROM addInstance where userId = '".$selectInstanceData['userId']."'";
$addInstUIDData = mysqli_query($conn,$addInstUID);
$addInstCount = mysqli_fetch_array($addInstUIDData)[0];
?>
<tr>
<td><?= $i; ?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['dateofcreation'])) ?></td>
<td><?= $fullName ?></td>
<td><?= $selectInstanceData['contactPersonName']?></td>
<td><?= $addInstCount ?></td>
<td><?= $selectInstanceData['instanceId']?></td>
<td><?= $selectInstanceData['companyName']?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['dateofcreation']))?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['instanceExpiryDate']))?></td>
<td><?= $selectInstanceData['totalUsers']?></td>
<td><?= $selectInstanceData['activeUsers']?></td>
<td><?= $selectInstanceData['ratePerUser']?></td>
<td><?= $selectInstanceData['totalDue']?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['billGeneratedDate']))?></td>
<td><?= $selectInstanceData['amountPaidDetails']?></td>
<td><?= $selectInstanceData['UPILink']?></td>
<td><?= $selectInstanceData['tallyLicenseSlNo']?></td>
<td><?= $selectInstanceData['tallyVersion']?></td>
<td><?= $selectInstanceData['tallyRelease']?></td>
<td><?= $selectInstanceData['tallyDotNetId']?></td>
<td><?= $selectInstanceData['tallyDotNetPassword']?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['tssExpiryDate']))?></td>
<td><?= $selectInstanceData['contactPersonName']?></td>
<td><?= $selectInstanceData['mobileNo']?></td>
<td><?php
if ($selectInstanceData['port'] > 0){
echo $selectInstanceData['serverIp'].':'.$selectInstanceData['port'];
} else {
echo $selectInstanceData['serverIp'];
}
?></td>
<td><?= $selectInstanceData['rdpLoginId']?></td>
<td><?= $selectInstanceData['password']?></td>
<td><?= $selectInstanceData['filezillaId']?></td>
<td><?= $selectInstanceData['password1']?></td>
<td>
<?php if($selectInstanceData['status'] == '0'){ ?> Inactive <?php } else { ?> Active <?php } ?>
</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"> Logins </a>
<ul class="dropdown-menu settings-menu" style="color:green;">
<li><a href="MyCloud.php"><i class="icofont icofont-login"></i> RDP Login</a></li>
<li><a href="http://<?php echo $selectInstanceData['serverIp'] ?>/" target="_blank"><i class="icofont icofont-login"></i> WebLogin</a></li>
</ul>
</li>
</ul>
</td>
<td> <a href="addInstanceEdit.php?editId=<?php echo $selectInstanceData['id']?>" class="btn btn-primary"><i class="icofont icofont-edit"></i> Edit </a>
</td>
</tr>
<?php $i++;}?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php } if ($_SESSION['loginType'] == 'partner') { ?>
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<h5 class="card-header-text">INSTANCE REPORT</h5>
</div>
<div class="card-header">
<div class="col-md-6">
<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-6">
<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>
<div class="card-block" style="overflow-x:auto;">
<table class="table datatable" id="getting_data">
<thead>
<tr>
<th>Instance</th>
<th>ID NO.</th>
<th>Company Name</th>
<th>Created At</th>
<th>INSTANCES EXPIRY DATE</th>
<th>TOTAL USERS</th>
<th>ACTIVE USERS</th>
<th>RATE PER USER</th>
<th>TOTAL DUE</th>
<th>BILL GENERATED DATE</th>
<th>AMOUT PAID DETAILS</th>
<th>UPI LINK</th>
<th>TALLY LICENSE SL.NO.</th>
<th>TALLY VERSION</th>
<th>TALLY RELEASE</th>
<th>TALLY DOT NET ID</th>
<th>TALLY DOT NET PASSWORD</th>
<th>TSS EXPIRY DATE</th>
<th>CONTACT PERSON NAME</th>
<th>MOBILE NO</th>
<th>SERVER IP</th>
<th>RDP LOGIN ID</th>
<th>PASSWORD</th>
<th>FILEZILLA ID</th>
<th>PASSWORD</th>
<th>Status</th>
<th>Logins</th>
<th>#</th>
</tr>
</thead>
<tfoot id="tfoot1">
<tr>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Instance">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search ID NO.">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Company Name">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Created At">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search INSTANCES EXPIRY DATE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TOTAL USERS">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search ACTIVE USERS">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search RATE PER USER">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TOTAL DUE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search BILL GENERATED DATE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search AMOUT PAID DETAILS">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search UPI LINK">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY LICENSE SL.NO.">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY VERSION">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY RELEASE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY DOT NET ID">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TALLY DOT NET PASSWORD">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search TSS EXPIRY DATE">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search CONTACT PERSON NAME">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search MOBILE NO">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search SERVER IP">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search RDP LOGIN ID">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search PASSWORD">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search FILEZILLA ID">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search PASSWORD">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Status">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Logins">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search #">
</th>
</tr>
</tfoot>
<tbody>
<?php
$i=1;
while($selectInstanceData = mysqli_fetch_array($selectInstance))
{
$addpartName = mysqli_query($conn,"SELECT * FROM addPartner where partnerId = '".$selectInstanceData['partnerId']."'");
$addpartNameData = mysqli_fetch_array($addpartName);
$fullName = $addpartNameData['firstName'].' '.$addpartNameData['lastName'];
$addInstUID = "SELECT COUNT(*) FROM addInstance where userId = '".$selectInstanceData['userId']."'";
$addInstUIDData = mysqli_query($conn,$addInstUID);
$addInstCount = mysqli_fetch_array($addInstUIDData)[0];
?>
<tr>
<td><?= $addInstCount ?></td>
<td><?= $selectInstanceData['instanceId']?></td>
<td><?= $selectInstanceData['companyName']?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['dateofcreation'])) ?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['instanceExpiryDate']))?></td>
<td><?= $selectInstanceData['totalUsers']?></td>
<td><?= $selectInstanceData['activeUsers']?></td>
<td><?= $selectInstanceData['ratePerUser']?></td>
<td><?= $selectInstanceData['totalDue']?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['billGeneratedDate']))?></td>
<td><?= $selectInstanceData['amountPaidDetails']?></td>
<td><?= $selectInstanceData['UPILink']?></td>
<td><?= $selectInstanceData['tallyLicenseSlNo']?></td>
<td><?= $selectInstanceData['tallyVersion']?></td>
<td><?= $selectInstanceData['tallyRelease']?></td>
<td><?= $selectInstanceData['tallyDotNetId']?></td>
<td><?= $selectInstanceData['tallyDotNetPassword']?></td>
<td><?= date('d-M-Y',strtotime($selectInstanceData['tssExpiryDate'])) ?></td>
<td><?= $selectInstanceData['contactPersonName']?></td>
<td><?= $selectInstanceData['mobileNo']?></td>
<td><?php
if ($selectInstanceData['port'] > 0){
echo $selectInstanceData['serverIp'].':'.$selectInstanceData['port'];
} else {
echo $selectInstanceData['serverIp'];
}
?></td>
<td><?= $selectInstanceData['rdpLoginId']?></td>
<td><?= $selectInstanceData['password']?></td>
<td><?= $selectInstanceData['filezillaId']?></td>
<td><?= $selectInstanceData['password1']?></td>
<td>
<?php if($selectInstanceData['status'] == '0'){ ?> Inactive <?php } else { ?> Active <?php } ?>
</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"> Logins </a>
<ul class="dropdown-menu settings-menu" style="color:green;">
<li><a href="MyCloud.php"><i class="icofont icofont-login"></i> RDP Login</a></li>
<li><a href="http://<?php echo $selectInstanceData['serverIp'] ?>/" target="_blank"><i class="icofont icofont-login"></i> WebLogin</a></li>
</ul>
</li>
</ul>
</td>
<td>
<a href="addInstanceEdit.php?editId=<?php echo $selectInstanceData['id']?>" class="btn btn-primary"><i class="icofont icofont-edit"></i> Edit </a>
</td>
</tr>
<?php $i++;}?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php } ?>
<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[2]);
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: "d-M-yy",
type: 'datetime',
onSelect: function() {
table.draw();
},
changeMonth: true,
changeYear: true
});
$("#max").datepicker({
dateFormat: "d-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