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/service/ |
<?php
include "../db_connection.php";
include "../sessioncheck.php";
require_once '../../Mobile_Detect.php';
$detect = new Mobile_Detect;
## Read value
$draw = $_POST['draw'];
$start = $_POST['start'];
$rowperpage = $_POST['length']; // Rows display per page
$columnIndex = $_POST['order'][0]['column']; // Column index
$columnName = $_POST['columns'][$columnIndex]['data']; // Column name
$columnSortOrder = $_POST['order'][0]['dir']; // asc or desc
$searchValue = $_POST['search']['value']; // Search value
$searchArray = array();
## Search
$searchQuery = "";
if($searchValue != ''){
$searchQuery = " AND (`payment`.`id` like '%".$searchValue."%' or `ad_id` like '%".$searchValue."%' or `payment_type` like '%".$searchValue."%' or `paypal_txn_id` like '%".$searchValue."%' or `plan_type` like '%".$searchValue."%'
or `rec_amount` like '%".$searchValue."%' or `currency` like '%".$searchValue."%' or `payer_email` like '%".$searchValue."%' or `payer_id` like '%".$searchValue."%' or `payment_date` like '%".$searchValue."%' or `payment_status` like '%".$searchValue."%' or `paypal_payload` like '%".$searchValue."%') ";
}
## Total number of records without filtering
$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM payment ");
$records = mysqli_fetch_assoc($sql);
$totalRecords = $records['allcount'];
## Total number of records with filtering
$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM payment WHERE 1 ".$searchQuery);
$records = mysqli_fetch_assoc($sql);
$totalRecordwithFilter = $records['allcount'];
## Fetch records
$query = "SELECT payment.*, advertise.profile_tile FROM payment LEFT JOIN advertise ON advertise.id=payment.ad_id WHERE 1 ".$searchQuery." order by ".$columnName." ".$columnSortOrder." limit ".$start.",".$rowperpage;
$sql=mysqli_query($connection,$query);
$data = array();
while($record=mysqli_fetch_assoc($sql)){
#Get the days
if($record['plan_type']=="Boost"){
$sql_days=mysqli_query($connection,"select * from boost_plan where plan_id='".$record['plan_id']."' and sub_plan_id ='".$record['sub_plan_id']."'");
$record_days=mysqli_fetch_assoc($sql_days);
}else{
$sql_days=mysqli_query($connection,"select * from plans where plan_id='".$record['plan_id']."' and sub_plan_id ='".$record['sub_plan_id']."'");
$record_days=mysqli_fetch_assoc($sql_days);
}
$status ="";
$class_status ="";
if($record['payment_status'] == "Completed"){
$status = 'Completed';
$class_status = 'badge-success';
$record['status'] =1;
}else {
$status = 'Pending';
$class_status = 'badge-danger';
$record['status'] =0;
}
//plan
$plan = "";
if($record['plan_id']==1){
$plan = "BRONZE";
}elseif($record['plan_id']==2){
$plan = "SILVER";
}elseif($record['plan_id']==3){
$plan = "GOLD";
}elseif($record['plan_id']==4){
$plan = "Boost";
}else{
$plan = "FREE";
}
$delete_text = "Do you really want to delete these Record? ";
if($detect->isMobile()){
$delete_text .="<br />";
}
$delete_text .= "This process cannot be undone!";
$data[] = array(
"id"=>$record['id'],
"ad_id"=>"<a href='".MAIN_URL."/user_detail/".$record['ad_id'].'/'.friendly_seo_string($record['profile_tile'])."' class='search_link' data-placement='top' data-toggle='tooltip' data-original-title='view' target='_blank' title='View Ad'>".$record['ad_id']."</a>",
"payer_email"=>$record['payer_email'],
"plan_id"=> $plan,
"sub_plan_id"=> $record_days["plan_days"],
/*"plan_type"=> $record['plan_type'], */
"payment_type"=> $record['payment_type'],
"rec_amount"=> $record['rec_amount']." ".$record['currency'],
"payment_date"=> date("d-m-Y",strtotime($record['payment_date'])),
"payment_status"=>"<span class='lead'><span id='status_change_".$record['id']."' class='status_change label_status badge ".$class_status."' data-id='".$record['id']."' data-status-id='".$record['status']."' >".$status."</span></span>",
"action"=>"<a href='payment_order_edit.php?id=".$record['id']."' id='edit_user_".$record['id']."' class='edit_user btn menu-icon vd_bg-yellow' data-id='".$record['id']."' data-placement='top' data-toggle='tooltip' data-original-title='Edit Order' title='Edit Order'><i class='fa fa-edit fa-lg'></i></a><button id='delete_user_".$record['id']."' type='button' class='btn menu-icon vd_bg-red delete_user' data-id='".$record['id']."' data-placement='top' data-toggle='modal' data-original-title='Delete Order' title='Delete Order' data-target='#confirmModal_".$record['id']."'><i class='fa fa-trash fa-lg'></i></button>
<div class='modal fade' id='confirmModal_".$record['id']."'>
<div class='modal-dialog'>
<div class='modal-content delete_modal'>
<div class='modal-header'><div class='icon-box'><i class='fa fa-times' aria-hidden='true'></i></div></div>
<div class='modal-header'><h4 class='col-12 modal-title text-center'>Are you sure?</h4></div>
<div class='modal-body'>
<p>".$delete_text."</p>
</div>
<div class='modal-footer modal_footer'>
<div class='modal_foot modal_foot_confirm'>
<button type='button' class='btn btn-default btn_modal btn-confirm-delete'>Confirm</button>
</div>
<div class='modal_foot modal_foot_close'>
<button type='button' class='btn btn-default btn_modal btn-confirm-close' data-dismiss='modal'>Close</button>
</div>
</div>
</div>
</div>
</div>",
);
}
## Response
$response = array(
"draw" => intval($draw),
"iTotalRecords" => $totalRecords,
"iTotalDisplayRecords" => $totalRecordwithFilter,
"aaData" => $data
);
echo json_encode($response);