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

    $type = $db->escape($_POST['type']);

    if($type == 1){
        if(isset($_POST['company'])){
            $company_value = $_POST['company'];
            $dealer_list = "";
            $query = "
                SELECT sd.id, sd.code, sd.name 
                FROM `source_company_dealer` scd 
                INNER JOIN source_dealer sd ON scd.dealer_id = sd.id  
                WHERE scd.company_id = '$company_value' AND sd.id != 0 
                GROUP BY id 
                ORDER by sd.name ASC";
    
            $dealer = $db -> return_result($query);
            //echo $query; return;
            $dealer_list = $dealer_list."<option value='0'>ALL</option>";

            foreach($dealer as $data){
                $dealer_list = $dealer_list."<option value='{$data['id']}'>".$data['code']."</option>";
            }
            echo $dealer_list;	
        }
    } 
    else if($type == 2){
        if(isset($_POST['company'])){
            $company_value = $_POST['company'];
            $dealer_list = "";
            $query = "
                SELECT sd.id, sd.code, sd.name 
                FROM `source_company_dealer` scd 
                INNER JOIN source_dealer sd ON scd.dealer_id = sd.id  
                WHERE scd.company_id = '$company_value' AND sd.id != 0 
                GROUP BY id 
                ORDER by sd.name ASC";
    
            $dealer = $db -> return_result($query);
            //echo $query; return;
            $dealer_list = $dealer_list."<option value=''>ALL</option>";

            foreach($dealer as $data){
                $dealer_list = $dealer_list."<option value='{$data['id']}'>".$data['code']."</option>";
            }
            echo $dealer_list;	
        }
    } 
    else if($type == 3){
        if(isset($_POST['company'])){
            $company_value = $_POST['company'];
            $dealer_list = "";
            $query = "
                SELECT sd.id, sd.code, sd.name 
                FROM `source_company_dealer` scd 
                INNER JOIN source_dealer sd ON scd.dealer_id = sd.id  
                WHERE scd.company_id = '$company_value' AND sd.id != 0 
                GROUP BY id 
                ORDER by sd.name ASC";
    
            $dealer = $db -> return_result($query);
            //echo $query; return;
            // $dealer_list = $dealer_list."<option value=''>ALL</option>";

            foreach($dealer as $data){
                $dealer_list = $dealer_list."<option value='{$data['id']}'>".$data['code']."</option>";
            }
            echo $dealer_list;	
        }
    }
?>