<?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(scm.id) ";
    $fields = " scm.id, sb.name AS brand_name, scm.name AS model_name, e.first_name, e.last_name, scm.model_variant_description, DATE_FORMAT(scm.date_added, '%M %d, %Y / %h:%i:%s %p') AS date_added, scm.status ";


    $model_query = "
        SELECT %s FROM `source_car_model` scm 
        INNER JOIN `employee` e ON scm.added_by=e.id 
        INNER JOIN `source_brand` sb ON sb.id=scm.brand_id 
        WHERE scm.name LIKE '%%%s%%' AND scm.id != 0 ORDER BY scm.name ASC "; //echo sprintf($model_query, $fields, $search); return; 
    $model_list_query =  $db -> sql_query(sprintf($model_query, $fields, $search)." $offset_limit");
  
    $model_list_query_count = $db -> select(sprintf($model_query, $count, $search));
 
    //$menu_arr = array();
    //$sub_menu_arr = array();
     
    while($row = $model_list_query->fetch_assoc()) {
        $json_arr['rows'] = array_merge($json_arr['rows'],array(array(
        'id'=>$row['id'], 
        'brand_name'=>$row['brand_name'], 
        'model_name'=>$row['model_name'], 
        'model_variant_description'=>$row['model_variant_description'], 
        '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'] = $model_list_query_count; //total number of result
    
    echo json_encode($json_arr);
?>