return_result($query); echo $query; return;
foreach($model as $data){
echo "";
}
}
else if($type == 2){ //get variant fields details
$variant_id = $_POST['variant_id'];
$query = "SELECT scmv.id, scmv.name, scmv.car_model_id, concat(e.first_name, ' ', e.last_name) AS creator, DATE_FORMAT(scmv.date_added, '%M %d, %Y / %h:%i:%s %p') AS date_added
FROM `source_car_model_variant` scmv
INNER JOIN employee e ON e.id = scmv.added_by
WHERE scmv.status != 0 AND scmv.id = '$variant_id'";
// echo $query; return;
$variant_details = $db -> return_result($query);
foreach($variant_details AS $data){
$arr['name'] = $data['name'];
$arr['id'] = $data['id'];
$arr['model_id'] = $data['car_model_id'];
$arr['date_added'] = $data['date_added'];
$arr['creator'] = $data['creator'];
}
echo json_encode($arr);
}
else if($type == 3){ //populate variant list based by selected brand
if(isset($_POST['model_id'])){
$model_id = $_POST['model_id'];
$query = "SELECT `id`, `name` FROM `source_car_model_variant` WHERE (car_model_id = '$model_id' AND status != 0) ORDER BY name ASC";
$variant = $db->return_result($query);
// echo $query; return;
foreach($variant as $data){
echo "";
}
}
}
else if($type == 4){ //populate model list by search
$search_item = $db->escape(trim($_POST['search_item']));
$model_id_selected = $db->escape(trim($_POST['model_id_selected']));
$search_query = "SELECT id, name FROM source_car_model_variant WHERE (name LIKE '%%$search_item%%') AND car_model_id = '$model_id_selected' AND id != 0 AND status = 1 ORDER BY name ASC";
// echo $search_query; return;
$result = $db->sql_query($search_query);
//echo $search_query; return;
while($row = $result->fetch_assoc()) {
echo '';
}
}
?>