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/ |
<?php
$error = "";
$message = "";
include "db_connection.php";
include "sessioncheck.php";
?>
<!-- Header Start-->
<?php include("header.php");?>
<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;
}
</style>
<!-- Header Ends-->
<!-- Content Start-->
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<ul class="nav nav-tabs">
<li class="nav-item"><a class="nav-link active" data-toggle="tab" href="#orders">Latest Orders</a></li>
<li class="nav-item"><a class="nav-link" data-toggle="tab" href="#ads">Latest Ads</a></li>
</ul>
<div class="tab-content" style="padding-top:20px;">
<div id="orders" class="tab-pane fade in active show">
<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>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 id="ads" class="tab-pane fade ">
<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>
</div><!-- /.card-body -->
</div><!-- /.card -->
<div class="card">
<!-- /.card-header -->
<div class="card-body">
<!-- Flash Message -->
<?php if(!empty($message)) : ?><div class="alert alert-info" role="alert"><?php echo $message; ?></div><?php endif; ?>
<!-- Flash Message -->
<!-- Error Message -->
<?php if(!empty($error)) : ?><div class="alert alert-info" role="alert" style="color:#FF0000;"><?php echo $error; ?></div><?php endif; ?>
<!-- Error Message -->
<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-cart-arrow-down 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-cart-arrow-down 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 if(!empty($suprt_unread)){echo $suprt_unread;}else{ echo "0";}?>
</p>
<small><span class="text-semibold"><i class="fa fa-comment 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-shopping-cart 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-money fa-fw"></i><?php echo $total?></span> Total Earning This Month</small> </div>
</div>
</div>
</div>
</div><!-- /.card-body -->
</div><!-- /.card -->
</div>
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
</section>
<!-- Content Ends-->
<script>
$(document).ready(function() {
$('#ad_table').DataTable({
responsive: true,
"iDisplayLength": 50,
"bsort": false,
"oLanguage": {"oPaginate": {"sPrevious": "Back"}, "sSearch": '', sLengthMenu: "<select class='custom-select custom-select-sm form-control form-control-sm'>"+
"<option value='50'>Show 50</option>"+
"<option value='100'>Show 100</option>"+
"<option value='500'>Show 500</option>"+
"<option value='1000'>Show 1000</option>"+
"<option value='2500'>Show 2500</option>"+
"</select>", } ,
"scrollX": true,
"scrollY": 300,
'processing': false,
'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").remove();
$('#delete_ad_'+val).closest("tr").remove();
//window.location.href = window.location.href;
}
}
});
$('.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,
"oLanguage": {"oPaginate": {"sPrevious": "Back"}, "sSearch": '', sLengthMenu: "<select class='custom-select custom-select-sm form-control form-control-sm'>"+
"<option value='50'>Show 50</option>"+
"<option value='100'>Show 100</option>"+
"<option value='500'>Show 500</option>"+
"<option value='1000'>Show 1000</option>"+
"<option value='2500'>Show 2500</option>"+
"</select>", } ,
"scrollX": true,
"scrollY": 300,
'processing': false,
'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: 'payment_date' },
{ data: 'payment_status' },
{ data: 'action' },
]
});
$('.dataTables_filter input').attr("placeholder", "Search");
$(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").remove();
$('#delete_user_'+val).closest("tr").remove();
//window.location.href = window.location.href;
}
}
});
$('.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>
<!-- Footer Start-->
<?php include("footer.php");?>
<!-- Footer Ends-->