<?php
    include_once("../../cfg/db.php"); 

    if(isset($_GET['search'])){
        $search = $db -> escape(trim($_GET['search']));
    } else {
        $search = "";
    }

    if(isset($_GET['offset'])){
        $offset = $db -> escape(trim($_GET['offset']));
    } else {
        $offset = "";
    }

    if(isset($_GET['limit'])){
        $limit =   $db -> escape(trim($_GET['limit']));
        $offset_limit = " LIMIT ". $offset.",".$limit;
    } else {
        $offset_limit = "";
    }

    $json_arr['rows'] = array();

    $count = " count(scmv.id) ";
    $fields = " scmv.id, scm.name AS model_name, scmv.name AS variant_name, e.first_name, e.last_name, DATE_FORMAT(scmv.date_added, '%M %d, %Y / %h:%i:%s %p') AS date_added, scmv.status ";

    $variant_query = "
        SELECT %s FROM `source_car_model_variant` scmv 
        INNER JOIN `employee` e ON scmv.added_by=e.id 
        INNER JOIN `source_car_model` scm ON scm.id=scmv.car_model_id 
        WHERE scmv.name LIKE '%%%s%%' AND scmv.id != 0 ORDER BY scmv.name ASC "; //echo sprintf($variant_query, $fields, $search); return; 
    $variant_list_query =  $db -> sql_query(sprintf($variant_query, $fields, $search)." $offset_limit");
  
    $variant_list_query_count = $db -> select(sprintf($variant_query, $count, $search));
 
    //$menu_arr = array();
    //$sub_menu_arr = array();
     
    while($row = $variant_list_query->fetch_assoc()) {
        $json_arr['rows'] = array_merge($json_arr['rows'],array(array(
        'id'=>$row['id'], 
        'model_name'=>$row['model_name'], 
        'variant_name'=>$row['variant_name'], 
        'added_by'=>$row['first_name']. " " .$row['last_name'], 
        'date_added'=>$row['date_added'], 
        'status'=>$row['status']//, 
            //'customer_name_id'=>(($row['name']) <> "" ? $row['name'] : "<span style='color:red;'>(Not provided)</span>")
            // 'customer_name_id'=>(($row['customer_id']) <> "" ? $row['customer_id'] : "<span style='color: red;'></span>") . " / " . 
            //     (($row['name']) <> "" ? $row['name'] : "<span style='color:red;'>(Not provided)</span>")
        )));   
    }
  
 
    $json_arr['total'] = $variant_list_query_count; //total number of result
    
    echo json_encode($json_arr);
?>