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 ">Adverts</li>
<li class="breadcrumb-item">Reported Ads</li>
</ol>
</div>
</nav>
<?php if ($detect->isMobile() && !$detect->isTablet()) { ?>
<style>
div.dataTables_wrapper div.dataTables_paginate {
padding-top: 1em !IMPORTANT;
text-align: center !IMPORTANT;
}
div.dataTables_wrapper div.dataTables_paginate ul.pagination {
text-align: center !IMPORTANT;
}
</style>
<?php } else { ?>
<style>
.dataTables_length {
float: left;
}
.dataTables_filter {
float: right;
}
div.dataTables_wrapper div.dataTables_info {
padding-top: 1.5em;
!IMPORTANT;
float: left;
}
div.dataTables_wrapper div.dataTables_paginate {
padding-top: 1em;
!IMPORTANT;
float: right;
}
</style>
<?php } ?>
<!-- Header Ends-->
<!-- Content Start-->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0 text-dark">Reported Ads</h1>
</div>
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="<?php echo MAIN_URL ?>/admin/index">Home</a></li>
<li class="breadcrumb-item active">Adverts</li>
<li class="breadcrumb-item"><a href="<?php echo MAIN_URL ?>/admin/ads_reported">Reported Ads</a></li>
</ol>
</div>
</div>
</div>
</div>
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card">
<!--<div class="card-header">
<h3 class="card-title"><button type="button" class="btn btn-info" onClick="window.location.href='<?php echo MAIN_URL ?>/admin/ads_list'">All Ads</button> </h3>
</div>-->
<!-- /.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 -->
<table id="reported_ad_table" class="table table-bordered table-striped text-nowrap" width="100%">
<thead>
<tr>
<th>#</th>
<th>AD ID</th>
<th>Profile Title</th>
<th>Total Reports</th>
</tr>
</thead>
<tbody>
<?php
$count = 0;
$reportedQry = "SELECT adv.id, adv.profile_tile, r_ads.ad_id, COUNT(*) AS total_report_count FROM report_ads AS r_ads INNER JOIN advertise AS adv ON adv.id = r_ads.ad_id GROUP BY r_ads.ad_id ORDER BY total_report_count DESC";
$reportedResult = mysqli_query($connection, $reportedQry);
while ($reportedRow = mysqli_fetch_assoc($reportedResult)) {
$count++;
?>
<tr>
<td class="center"><?= $count ?></td>
<td class="center">
<a href="<?php echo MAIN_URL; ?>/user_detail/<?= $reportedRow['ad_id'] . "/" . friendly_seo_string($reportedRow['profile_tile']); ?>" class="search_link" data-placement="top" data-toggle="tooltip" data-original-title="view" target="_blank" title="View Ad"><?= $reportedRow['ad_id'] ?></a>
</td>
<td class="center">
<a href="<?php echo MAIN_URL; ?>/user_detail/<?= $reportedRow['ad_id'] . "/" . friendly_seo_string($reportedRow['profile_tile']); ?>" class="search_link" data-placement="top" data-toggle="tooltip" data-original-title="view" target="_blank" title="View Ad"><?= $reportedRow["profile_tile"] ?></a>
</td>
<td class="center">
<a id="reported_ad_<?= $reportedRow['ad_id'] ?>" class="reported_ad" data-id="<?= $reportedRow['ad_id'] ?>" data-placement="top" data-toggle="tooltip" data-original-title="Reported" title="Reported AD Count">
<?= $reportedRow['total_report_count'] ?>
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
<div class="modal fade Modal_Dialog" id="reportedAdModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog modal-lg">
<div class="modal-content report_output">
</div>
</div>
</section>
<!-- Content Ends-->
<script>
$(document).ready(function() {
var oTable = $('#reported_ad_table').DataTable({
responsive: true,
dom: 'lBfrtip',
"scrollX": true,
"iDisplayLength": 100,
"oLanguage": {
"oPaginate": {
"sPrevious": "Back"
},
"sSearch": '',
sLengthMenu: "<select class='custom-select custom-select-sm form-control form-control-sm'>" +
"<option value='100'>Show 100</option>" +
"<option value='500'>Show 500</option>" +
"<option value='1000'>Show 1000</option>" +
"<option value='2500'>Show 2500</option>" +
"<option value='5000'>Show 5000</option>" +
"</select>",
},
});
$('.dataTables_filter input').attr("placeholder", "Search");
$(".dataTables_scrollBody").height($(document).height() - 260);
});
$(document.body).on('click', '.reported_ad', function(e) {
var val = $(this).data("id");
$.ajax({
url: 'service/reported_ad_users',
type: 'post',
data: {
value: val
},
success: function(data) {
//alert(data);
if (data != '') {
$('.report_output').html(data);
if (!$.fn.DataTable.isDataTable('#reported_ad_users')) {
$('#reported_ad_users').DataTable({
responsive: true,
"iDisplayLength": 100,
"oLanguage": {
"oPaginate": {
"sPrevious": "Back"
},
"sSearch": '',
sLengthMenu: "<select class='custom-select custom-select-sm form-control form-control-sm'>" +
"<option value='100'>Show 100</option>" +
"<option value='500'>Show 500</option>" +
"<option value='1000'>Show 1000</option>" +
"<option value='2500'>Show 2500</option>" +
"<option value='5000'>Show 5000</option>" +
"</select>",
},
});
$('.dataTables_filter input').attr("placeholder", "Search");
}
$('#reportedAdModal').modal('toggle');
}
}
});
$('.reported_ad').unbind();
});
</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(250px + 4.6rem);
}
div.dataTables_wrapper div.dataTables_paginate {
left: calc(250px + 250px);
}
div.dataTables_wrapper div.dataTables_info {
padding-left: 6px;
}
.content-wrapper .content {
margin-top: 0px;
}
/*/////////////////for page end//////////////////*/
</style>