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/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
	include "../db_connection.php";
	include "../sessioncheck.php";	  
	
	## 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 (`plan` like  '%".$searchValue."%'  or  `plan_days` like  '%".$searchValue."%' or  `sub_plan_id` like  '%".$searchValue."%' or  `amount` like  '%".$searchValue."%' or `currency` like  '%".$searchValue."%' or  `status` like  '%".$searchValue."%' or  `payment_link` like  '%".$searchValue."%') ";	    
	}
	
	## Total number of records without filtering
	$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM plans ");
	$records = mysqli_fetch_assoc($sql);	 
	$totalRecords = $records['allcount'];	
	
	## Total number of records with filtering
	$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM plans WHERE 1 ".$searchQuery);
	$records = mysqli_fetch_assoc($sql);	 
	$totalRecordwithFilter = $records['allcount'];
	
	## Fetch records	
	$query = "SELECT * FROM plans  WHERE 1 ".$searchQuery."   order by ".$columnName." ".$columnSortOrder." limit ".$start.",".$rowperpage;	
	$sql=mysqli_query($connection,$query);
	$data = array();
	while($record=mysqli_fetch_assoc($sql)){
		$status ="";
		$class_status =""; 
		if($record['status'] == "Active"){
			$status = 'Active';
			$class_status = 'badge-success';
		}else {
			$status = 'Inactive';
			$class_status = 'badge-danger';
		} 
		
		$block ="";
		$class_block ="";
		if($record['block_user'] == 1){
			$block = 'Block';
			$class_block = 'badge-success';
		}else {
			$block = 'Unblock';
			$class_block = 'badge-danger';
		}
	
		 $data[] = array(
		  "id"=>$record['id'],
		  "plan_id"=>$record['plan_id'],
		  "sub_plan_id"=>$record['sub_plan_id'],
		  "plan"=>$record['plan'],
		  "plan_days"=>$record['plan_days'],
		  "amount"=>$record['amount'],
		  "currency"=> $record['currency'],  			 
		  "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>",		
		  "payment_link"=> $record['payment_link'],  		   	  
		  "action"=>"<a href='payment_plans_edit.php?id=".$record['id']."' id='edit_user_".$record['id']."' class='edit_plan btn menu-icon vd_bg-yellow' data-id='".$record['id']."' data-placement='top' data-toggle='tooltip' data-original-title='Edit Plan' title='Edit Plan'><i class='fa fa-edit fa-lg'></i></a>",	  
	   );
	}
	 
	## Response
$response = array(
  "draw" => intval($draw),
  "iTotalRecords" => $totalRecords,
  "iTotalDisplayRecords" => $totalRecordwithFilter,
  "aaData" => $data
);

echo json_encode($response);