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


    $dealer_query = "SELECT %s FROM `source_dealer` sd 
        INNER JOIN `employee` e 
        ON sd.add_by=e.id 
        INNER JOIN source_company_dealer scd 
        ON sd.id = scd.dealer_id 
        INNER JOIN source_company sc 
        ON sc.id = scd.company_id 
        WHERE sd.code LIKE '%%%s%%' AND sd.id != 0 AND scd.status = 1 ORDER BY sd.`name` ASC ";
    //echo sprintf($company_query,$fields,$search)." $offset_limit";return;
    $dealer_list_query = $db -> sql_query(sprintf($dealer_query, $fields, $search)." $offset_limit"); // echo sprintf($dealer_query,$count,$search); exit;
  
    $dealer_list_query_count = $db->select(sprintf($dealer_query,$count,$search));
 
    //$menu_arr = array();
    //$sub_menu_arr = array();
     
    while($row = $dealer_list_query->fetch_assoc()) {
        $json_arr['rows'] = array_merge($json_arr['rows'],array(array('code'=>$row['code'] , 
        'id'=>$row['id'], 
        'name'=>$row['name'], 
            'add_by'=>$row['first_name']. " " .$row['last_name'], 
            'date_added'=>$row['date_added'],
            'dealer_company'=>$row['company'],
            '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'] = $dealer_list_query_count; //total number of result
    
    echo json_encode($json_arr);
?>