Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory : /home/u107206879/domains/escort46.de/public_html/admin_escort46/ |
<?php
include "db_connection.php";
include "sessioncheck.php";
?>
<html lang="en">
<head>
<?php include_once "head.php"; ?>
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css" />
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.colVis.min.js"></script>
<style>
.panel {
box-shadow: 0 2px 0 rgba(0,0,0,0.05);
border-radius: 0;
border: 0;
margin-bottom: 24px;
}
.panel-dark.panel-colorful {
background-color: #3b4146;
border-color: #3b4146;
color: #fff;
}
.panel-danger.panel-colorful {
background-color: #f76c51;
border-color: #f76c51;
color: #fff;
}
.panel-primary.panel-colorful {
background-color: #5fa2dd;
border-color: #5fa2dd;
color: #fff;
}
.panel-info.panel-colorful {
background-color: #4ebcda;
border-color: #4ebcda;
color: #fff;
}
.panel-body {
padding: 25px 20px;
}
.panel hr {
border-color: rgba(0,0,0,0.1);
}
.mar-btm {
margin-bottom: 15px;
}
h2, .h2 {
font-size: 28px;
}
.small, small {
font-size: 85%;
}
.text-sm {
font-size: .9em;
}
.text-thin {
font-weight: 300;
}
.text-semibold {
font-weight: 600;
}
Similar snippets
</style>
</head>
<body data-spy="scroll" data-target=".navbar" data-offset="60">
<?php include_once "navbar.php"; ?>
<div id="pricing" class="container-fluid myprofile_div">
<div class="container bootstrap snippet mt-10 mb-10 mt-10">
<div class="row">
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="panel panel-dark panel-colorful">
<div class="panel-body text-center">
<p class="text-uppercase mar-btm text-sm">Total Visits</p>
<i class="fa fa-users fa-5x"></i>
<hr>
<?php $sql_visiter=mysqli_query($connection,"SELECT * FROM counter WHERE id=1");
$data_visiter = mysqli_fetch_assoc($sql_visiter);
?>
<p class="h2 text-thin"><?php echo number_format($data_visiter["visits"])?></p>
<small><span class="text-semibold">Total Visits</span> Till Today</small>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="panel panel-primary panel-colorful">
<div class="panel-body text-center">
<p class="text-uppercase mar-btm text-sm">New Ads</p>
<i class="fa fa-shopping-cart fa-5x"></i>
<hr>
<?php $sql_ads=mysqli_query($connection,"SELECT * FROM advertise WHERE MONTH(`createdat`) = MONTH(CURRENT_DATE())
AND YEAR(`createdat`) = YEAR(CURRENT_DATE())");
$data_ads = mysqli_num_rows($sql_ads);
?>
<p class="h2 text-thin"><?php echo number_format($data_ads);?></p>
<small><span class="text-semibold"><i class="fa fa-shopping-cart fa-fw"></i> <?php echo number_format($data_visiter);?></span> Ads in this month</small>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="panel panel-danger panel-colorful">
<div class="panel-body text-center">
<p class="text-uppercase mar-btm text-sm">Support</p>
<i class="fa fa-comment fa-5x"></i>
<hr>
<p class="h2 text-thin"><?php echo $suprt_unread?></p>
<small><span class="text-semibold"><i class="fa fa-unlock-alt fa-fw"></i> <?php $suprt_unread?></span> Support Tickets</small>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="panel panel-info panel-colorful">
<div class="panel-body text-center">
<p class="text-uppercase mar-btm text-sm">New Orders</p>
<i class="fa fa-dollar fa-5x"></i>
<hr>
<?php $sql_payment=mysqli_query($connection,"SELECT * FROM payment WHERE MONTH(`payment_date`) = MONTH(CURRENT_DATE())
AND YEAR(`payment_date`) = YEAR(CURRENT_DATE()) and payment_status='Completed'");
$total = "0";
while($row_payment = mysqli_fetch_assoc($sql_payment)){
$total = $total+$row_payment["rec_amount"];
}
?>
<p class="h2 text-thin"><?php echo $total ?></p>
<small><span class="text-semibold"><i class="fa fa-dollar fa-fw"></i><?php echo $total?></span> Total Earning This Month</small>
</div>
</div>
</div>
</div>
<div class="row">
<ul class="nav nav-tabs">
<li class="active"><a data-toggle="tab" href="#ads">Latest Ads</a></li>
<li><a data-toggle="tab" href="#orders">Latest Orders</a></li>
</ul>
<div class="tab-content">
<div id="ads" class="tab-pane fade in active mt-10 mb-10 mt-10">
<div class="table-responsive">
<table class="table table-hover display nowrap" id="ad_table" width="100%">
<thead>
<tr>
<th>A_ID</th>
<th>Profile Title</th>
<th>Telephone</th>
<th>Create Date</th>
<th>Approval</th>
<th>Action</th>
</tr>
</thead>
</table>
</div>
</div>
<div id="orders" class="tab-pane fade mt-10 mb-10 mt-10">
<div class="table-responsive">
<table class="table table-hover display nowrap" id="users_table" width="100%">
<thead>
<tr>
<th>Order ID</th>
<th>Ad</th>
<th>Email</th>
<th>Plan</th>
<th>Days</th>
<!--<th>Plan Type</th>-->
<th>Payment</th>
<th>Amount</th>
<th>Currency</th>
<th>Date</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
</table>
</div>
<div class="modal fade Modal_Dialog" id="editUserModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog">
<div class="modal-content user_output">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function() {
$('#ad_table').DataTable({
responsive: true,
"iDisplayLength": 50,
"bsort": false,
"scrollX": true,
"scrollY": 300,
'processing': true,
'serverSide': true,
'serverMethod': 'post',
"order": [[ 0, "desc" ]],
'ajax': {
'url':'service/load_data_adverts_dashboard'
},
'columns': [
{ data: 'id' },
{ data: 'profile_tile' },
{ data: 'telephone_no' },
{ data: 'createdat' },
{ data: 'isApproved' },
{ data: 'action' },
]
});
});
$(document.body).on('click','.btn-confirm-delete',function(e){
var crud = 'delete';
var val = $(this).data("id");
$.ajax({
url:'service/delete_ad',
type:'post',
data:{crud:crud,value:val},
success:function (data) {
if(data=='1'){
$('.modal-backdrop.fade.in').remove();
$('#delete_ad_'+val).closest("tr").remove();
}
}
});
$('.btn-confirm-delete').unbind();
});
$(document.body).on('click', '.delete_ad', function(e){
$(".btn-confirm-delete").attr("data-id",$(this).data('id'));
$('.delete_ad').unbind();
});
$(document.body).on('click', '.btn-confirm-close', function(e){
$(".btn-confirm-delete").attr("data-id","0");
$('.btn-confirm-close').unbind();
});
// User Status Change
$(document.body).on('click','.approval_change',function(e){
var trans = 'change';
var val = $(this).data("id");
var status = $(this).data("status-id");
$.ajax({
url:'service/approve_ad',
type:'post',
data:{trans:trans,value:val,status:status},
success:function (data){
if(data=='1'){
if(status == '1'){
$('#approval_change_'+val).html("Pending");
$('#approval_change_'+val).data('status-id','0');
$('#approval_change_'+val).removeClass('label-success');
$('#approval_change_'+val).addClass('label-danger');
}else if(status == '0'){
$('#approval_change_'+val).html("Approved");
$('#approval_change_'+val).data('status-id','1');
$('#approval_change_'+val).removeClass('label-danger');
$('#approval_change_'+val).addClass('label-success');
}
}
}
});
$('.approval_change').unbind();
});
</script>
<!-- Order code -->
<script>
$(document).ready(function() {
var table = $('#users_table').DataTable({
responsive: true,
"iDisplayLength": 50,
"bsort": false,
"scrollX": true,
"scrollY": 300,
'processing': true,
'serverSide': true,
'serverMethod': 'post',
"order": [[ 0, "desc" ]],
'ajax': {
'url':'service/load_data_orders_dashboard'
},
'columns': [
{ data: 'id' },
{ data: 'ad_id' },
{ data: 'payer_email' },
{ data: 'plan_id' },
{ data: 'sub_plan_id' },
/*{ data: 'plan_type' },*/
{ data: 'payment_type' },
{ data: 'rec_amount' },
{ data: 'currency' },
{ data: 'payment_date' },
{ data: 'payment_status' },
{ data: 'action' },
]
});
$(document.body).on('click','.edit_user',function(e){
var trans = 'get_user';
var val = $(this).data("id");
$.ajax({
url:'service/get_order_detail',
type:'post',
data:{trans:trans,value:val},
success:function (data){
//alert(data);
if(data != ''){
$('.user_output').html(data);
$('#editUserModal').modal('toggle');
}
}
});
$('.edit_user').unbind();
});
$(document.body).on('click','#submitForm',function(e){
$('.Modal_Dialog').modal('hide');
$.ajax({
type: 'post',
data: $("#editUser_form").serializeArray(),
url: 'service/edit_order',
success: function(data) {
document.getElementById("editUser_form").reset();
alert(data);
window.location.reload();
}
});
});
$(document.body).on('click','.btn-confirm-delete-order',function(e){
var crud = 'delete';
var val = $(this).data("id");
$.ajax({
url:'service/delete_order',
type:'post',
data:{crud:crud,value:val},
success:function (data) {
if(data=='1'){
$('.modal-backdrop.fade.in').remove();
$('#delete_user_'+val).closest("tr").remove();
}
}
});
$('.btn-confirm-delete').unbind();
});
$(document.body).on('click', '.delete_user', function(e){
$(".btn-confirm-delete").attr("data-id",$(this).data('id'));
$('.delete_user').unbind();
});
$(document.body).on('click', '.btn-confirm-close-order', function(e){
$(".btn-confirm-delete").attr("data-id","0");
$('.btn-confirm-close').unbind();
});
// User Status Change
$(document.body).on('click','.status_change_order',function(e){
var trans = 'change';
var val = $(this).data("id");
var status = $(this).data("status-id");
$.ajax({
url:'service/status_change_order',
type:'post',
data:{trans:trans,value:val,status:status},
success:function (data){
if(data=='1'){
if(status == '1'){
$('#status_change_'+val).html("Pending");
$('#status_change_'+val).data('status-id','0');
$('#status_change_'+val).removeClass('label-success');
$('#status_change_'+val).addClass('label-danger');
}else if(status == '0'){
$('#status_change_'+val).html("Completed");
$('#status_change_'+val).data('status-id','1');
$('#status_change_'+val).removeClass('label-danger');
$('#status_change_'+val).addClass('label-success');
}
}
}
});
$('.status_change').unbind();
});
$('a[data-toggle="tab"]').on('shown.bs.tab', function(e){
$($.fn.dataTable.tables(true)).DataTable()
.columns.adjust()
.responsive.recalc();
});
});
</script>
</body>
</html>