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

if (isset($_REQUEST['get_data'])) {
    if ($_REQUEST['get_data']==1) {
        $appversion = $conn->query("SELECT * FROM app_settings LIMIT 1");
        $app_version = mysqli_fetch_assoc($appversion);

        $sql = "SELECT *,vendor_app_version.id as id FROM vendor_app_version INNER JOIN vendor_login ON vendor_login.id=vendor_app_version.vendor_id INNER JOIN vendor_profile ON vendor_login.id=vendor_profile.vendor_id WHERE app_version='".$app_version['version_number']."'";
    }else{
        $sql = "SELECT *,vendor_app_version.id as id FROM vendor_app_version INNER JOIN vendor_login ON vendor_login.id=vendor_app_version.vendor_id INNER JOIN vendor_profile ON vendor_login.id=vendor_profile.vendor_id";
    }

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

    // Server-side processing
    if (!empty($_REQUEST['search']['value'])) {
        $searchValue = $_REQUEST['search']['value'];

    // Check if the query already has a WHERE clause
        if (strpos($sql, 'WHERE') !== false) {
            $sql .= " AND (vendor_app_version.id LIKE '%$searchValue%' 
            OR vendor_app_version.vendor_id LIKE '%$searchValue%' 
            OR device_name LIKE '%$searchValue%' 
            OR contact LIKE '%$searchValue%' 
            OR full_name LIKE '%$searchValue%' 
            OR app_version LIKE '%$searchValue%')";
        } else {
            $sql .= " WHERE (vendor_app_version.id LIKE '%$searchValue%' 
            OR vendor_app_version.vendor_id LIKE '%$searchValue%' 
            OR device_name LIKE '%$searchValue%' 
            OR contact LIKE '%$searchValue%' 
            OR full_name LIKE '%$searchValue%' 
            OR app_version LIKE '%$searchValue%')";
        }
    }

    $query = $conn->query($sql);
    $totalFiltered = $query->num_rows;

    // Add ordering and pagination
    $sql .= " ORDER BY vendor_app_version.id DESC";
    $sql .= " LIMIT " . $_REQUEST['start'] . ", " . $_REQUEST['length'];

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

    $data = array();
    $serial = $_REQUEST['start'] + 1; // Serial number counter

    while ($row = $result->fetch_assoc()) {
        $created_at = date("d-m-Y h:i A", strtotime($row['created_at']));

        $nestedData = array();
        $nestedData[] = $serial++; // Serial number
        $nestedData[] = $row['vendor_id'];
        $nestedData[] = $row['full_name'];
        $nestedData[] = $row['contact'];
        $nestedData[] = $row['app_version'];
        $nestedData[] = $row['device_name'];
        $nestedData[] = $created_at;
        $nestedData[] = '<button type="button" class="btn btn-danger" onclick="del(' . $row['id'] . ')"><i class="fa fa-trash"></i></button>';

        $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);
}

// get_not_updated_data
if (isset($_REQUEST['get_not_updated_data'])) {
  
  
  $sql = "SELECT * FROM vendor_login vl INNER JOIN vendor_profile ON vendor_profile.vendor_id = vl.id WHERE NOT EXISTS (SELECT 1 FROM vendor_app_version vav WHERE vav.vendor_id = vl.id)";


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

    // Server-side processing
  if (!empty($_REQUEST['search']['value'])) {
    $searchValue = $_REQUEST['search']['value'];

    $sql .= " AND (contact LIKE '%$searchValue%' 
    OR full_name LIKE '%$searchValue%' 
    OR vl.id LIKE '%$searchValue%')";
    
}

$query = $conn->query($sql);
$totalFiltered = $query->num_rows;

    // Add ordering and pagination
$sql .= " ORDER BY vl.id DESC";
$sql .= " LIMIT " . $_REQUEST['start'] . ", " . $_REQUEST['length'];

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

$data = array();
    $serial = $_REQUEST['start'] + 1; // Serial number counter

    while ($row = $result->fetch_assoc()) {
        $created_at = date("d-m-Y h:i A", strtotime($row['created_at']));

        $nestedData = array();
        $nestedData[] = $serial++; // Serial number
        $nestedData[] = $row['vendor_id'];
        $nestedData[] = $row['full_name'];
        $nestedData[] = $row['contact'];
        $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);
}

    //Delete
if (isset($_POST['delete_id'])) {
    $id = $_POST['delete_id'];
    $query = "DELETE FROM vendor_app_version WHERE id = " . $id;
    if ($conn->query($query)) {
        echo "Success";
    } else {
        echo "Something Wrong";
    }

}

?>