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"); ?>
<nav class=" navbar navbar-expand navbar-white navbar-light">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#">
<i class="fa fa-bars" style="color:white;"></i>
</a>
</li>
</ul>
<div>
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item ">Home</li>
</ol>
</div>
</nav>
<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">
<?php include_once 'notification.php'; ?>
<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 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>
</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 result = confirmbox();
//$('#anyConfirmationBox').modal('show');
var confrim = confirm('Do you really want to do these Opration? This process cannot be undone.');
if (!confrim) {
return false;
}
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-->
<footer class="main-footer">
<div class="row">
<div class="col-md-2 col-sm-6 col-6">
</div>
<div class="col-md-2 col-sm-6 col-6">
</div>
</div>
</footer>
<?php include("footer.php"); ?>
<style>
/* //////////////////common start////////////// */
.content-wrapper .content {
height: calc(100vh - 112px) !important;
overflow-y: auto;
margin-top: 56px;
}
.content-wrapper .navbar {
height: 56px;
}
.main-footer {
padding: 7px 8px;
border-top: 2px solid #0002;
height: 56px;
}
::-webkit-scrollbar {
height: 6px;
width: 6px;
}
::-webkit-scrollbar-track {
background-color: white;
}
::-webkit-scrollbar-thumb {
background-color: #aaa;
border-radius: 20px;
}
::-webkit-scrollbar-thumb:hover {
background-color: #aaa;
}
.card {
border-radius: 0px;
}
@media (min-width: 768px) {
.main-footer {
transition: margin-left 0.3s ease-in-out;
margin-left: 0px!important;
}
}
/*---------------------------------switsh=====*/
.switch {
float: right;
position: relative;
display: inline-block;
vertical-align: top;
width: 56px;
height: 20px;
padding: 3px;
background-color: white;
border-radius: 18px;
box-shadow: inset 0 -1px white, inset 0 1px 1px rgba(0, 0, 0, 0.05);
cursor: pointer;
background-image: -webkit-linear-gradient(top, #eeeeee, white 25px);
background-image: -moz-linear-gradient(top, #eeeeee, white 25px);
background-image: -o-linear-gradient(top, #eeeeee, white 25px);
background-image: linear-gradient(to bottom, #eeeeee, white 25px);
}
.switch-input {
position: absolute;
top: 0;
left: 0;
opacity: 0;
}
.switch-label {
position: relative;
display: block;
height: inherit;
font-size: 10px;
text-transform: uppercase;
background: #eceeef;
border-radius: inherit;
box-shadow: inset 0 1px 2px rgba(0, 0, 0, 0.12), inset 0 0 2px rgba(0, 0, 0, 0.15);
-webkit-transition: 0.15s ease-out;
-moz-transition: 0.15s ease-out;
-o-transition: 0.15s ease-out;
transition: 0.15s ease-out;
-webkit-transition-property: opacity background;
-moz-transition-property: opacity background;
-o-transition-property: opacity background;
transition-property: opacity background;
}
.switch-label:before, .switch-label:after {
position: absolute;
top: 50%;
margin-top: -.5em;
line-height: 1;
-webkit-transition: inherit;
-moz-transition: inherit;
-o-transition: inherit;
transition: inherit;
}
.switch-label:before {
content: attr(data-off);
right: 11px;
color: #aaa;
text-shadow: 0 1px rgba(255, 255, 255, 0.5);
}
.switch-label:after {
content: attr(data-on);
left: 11px;
color: white;
text-shadow: 0 1px rgba(0, 0, 0, 0.2);
opacity: 0;
}
.switch-input:checked ~ .switch-label {
background: #47a8d8;
box-shadow: inset 0 1px 2px rgba(0, 0, 0, 0.15), inset 0 0 3px rgba(0, 0, 0, 0.2);
}
.switch-input:checked ~ .switch-label:before {
opacity: 0;
}
.switch-input:checked ~ .switch-label:after {
opacity: 1;
}
.switch-handle {
position: absolute;
top: 4px;
left: 4px;
width: 18px;
height: 18px;
background: white;
border-radius: 10px;
box-shadow: 1px 1px 5px rgba(0, 0, 0, 0.2);
background-image: -webkit-linear-gradient(top, white 40%, #f0f0f0);
background-image: -moz-linear-gradient(top, white 40%, #f0f0f0);
background-image: -o-linear-gradient(top, white 40%, #f0f0f0);
background-image: linear-gradient(to bottom, white 40%, #f0f0f0);
-webkit-transition: left 0.15s ease-out;
-moz-transition: left 0.15s ease-out;
-o-transition: left 0.15s ease-out;
transition: left 0.15s ease-out;
}
.switch-handle:before {
content: '';
position: absolute;
top: 50%;
left: 50%;
margin: -6px 0 0 -6px;
width: 12px;
height: 12px;
background: #f9f9f9;
border-radius: 6px;
box-shadow: inset 0 1px rgba(0, 0, 0, 0.02);
background-image: -webkit-linear-gradient(top, #eeeeee, white);
background-image: -moz-linear-gradient(top, #eeeeee, white);
background-image: -o-linear-gradient(top, #eeeeee, white);
background-image: linear-gradient(to bottom, #eeeeee, white);
}
.switch-input:checked ~ .switch-handle {
left: 40px;
box-shadow: -1px 1px 5px rgba(0, 0, 0, 0.2);
}
.switch-green > .switch-input:checked ~ .switch-label {
background: #4fb845;
}
/* //////////////////common end////////////// */
/*/////////////////for page//////////////////*/
.dataTables_length {
right: 19px;
}
.sidebar-collapse div.dataTables_wrapper div.dataTables_paginate {
left: calc(228px + 4.6rem);
}
div.dataTables_wrapper div.dataTables_paginate {
left: calc(228px + 250px);
}
div.dataTables_wrapper div.dataTables_info {
padding-left: 6px;
}
/*/////////////////for page end//////////////////*/
</style>