<?php
include('lib/config.php');

$vendor_type = $_REQUEST['type'];

$sql = "SELECT * FROM other_vendor"; 


// Fetch data
$result = $conn->query($sql);
$totalData = $result->num_rows;


// Server-side processing

if (!empty($_REQUEST['search']['value'])) {
    $sql .= " AND (full_name LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR id LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR contact LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR email LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR city LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR timestamp LIKE '%" . $_REQUEST['search']['value'] . "%' ";
    $sql .= " OR state LIKE '%" . $_REQUEST['search']['value'] . "%' )";
}

$query = mysqli_query($conn, $sql);
$totalFiltered = mysqli_num_rows($query);



// Server-side processing
$sql .= " ORDER BY id DESC";
if($_REQUEST['length']!=-1){
    $sql .= " LIMIT " . $_REQUEST['start'] . ", " . $_REQUEST['length'];
    }

$result = $conn->query($sql);
$totalFiltered = $totalData;

$data = array();
$serial = $_REQUEST['start'] + 1; // Serial number counter
while ($row = $result->fetch_assoc()) {

    $row['reg_date']=date("d-m-Y H:i:s",strtotime($row['timestamp']));

    $nestedData = array();
    $nestedData[] = $serial++; // Serial number

    $nestedData[] = $row['id'];
    $nestedData[] = $row['full_name'];
    $nestedData[] = $row['contact'];
    $nestedData[] = $row['email'];
    $nestedData[] = $row['city'];
    $nestedData[] = $row['state'];
    $nestedData[] = $row['reg_date'];

    $data[] = $nestedData;
}

// Prepare JSON data
$json_data = array(
    "draw" => intval($_REQUEST['draw']),
    "recordsTotal" => intval($totalData),
    "recordsFiltered" => intval($totalFiltered),
    "data" => $data
);

echo json_encode($json_data);
?>