<?php 
include "config.php";

$columns = array(
	
0=>'id', 
1=>'post_name',
2=>'post_slug',
3=>'logo',
4=>'summary',
5=>'description',
6=>'post_by',
7=>'post_date',
8=>'status',
9=>'last_update_by',
10=>'last_update_date'
	);

$requestData= $_REQUEST;
$totalData = "0";
$query="SELECT id, post_name, post_slug, logo, summary, description, post_by, post_date, status, last_update_by, last_update_date FROM sp_other_links";
$sql=$db->prepare($query);
$sql->execute();
$totalFiltered = $sql->rowCount();

	$searchTerms = "";
	if( !empty($requestData['search']['value']) ) { 
		$searchTerms.=" AND ( post_name LIKE '".$requestData['search']['value']."%' ";
		$searchTerms.=" OR post_slug LIKE '".$requestData['search']['value']."%' ";
		$searchTerms.=" OR logo LIKE '".$requestData['search']['value']."%' ";
		$searchTerms.=" OR summary LIKE '".$requestData['search']['value']."%' ";
		$searchTerms.=" OR description LIKE '".$requestData['search']['value']."%') ";
	}

  $query  = "SELECT id, post_name, post_slug, logo, summary, description, post_by, post_date, status, last_update_by, last_update_date FROM sp_other_links where id !='' $searchTerms";
		$sql=$db->prepare($query);
		$sql->execute();

$curDate = date('Y-m-d H:i:s', strtotime('+5 hour 30 minutes'));
while($row=$sql->fetch()){

if($row['status']=='1'){ $show = "<span style='color:green'> Active</span>"; }	else { $show = "<span style='color:red'>Deactive</span>"; }

$nestedData=array(); 
$nestedData["id"] = $row['id'];
$nestedData["post_name"] = $row['post_name'];
$nestedData["post_slug"] = $row['post_slug'];
$nestedData["logo"] = $row['logo'];
$nestedData["summary"] = $row['summary'];
$nestedData["description"] = $row['description'];
$nestedData["post_by"] = $row['post_by'];
$nestedData["post_date"] = $row['post_date'];
$nestedData["status"] = $show ;
$nestedData["last_update_by"] = $row['last_update_by'];
$nestedData["last_update_date"] = $row['last_update_date'];
$data[] = $nestedData;
}

$json_data = array(
		"draw"            => intval( $requestData['draw'] ), 
		"recordsTotal"    => intval( $totalData ),  
		"recordsFiltered" => intval( $totalFiltered ), 
		"data"            => $data
	);
				
echo json_encode($json_data);
?>