<?php 
class Model{ 
    function model_list($brand_id,$search,$utility_class,$db){ 
      $query = "SELECT m.`id`, m.`name` FROM `lms2_vehicle_models` m 
INNER JOIN lms2_vehicle_brands b 
ON m.`brand_id` = b.id
WHERE 1
AND m.status = 1
AND b.status = 1
AND b.id = $brand_id
AND m.name LIKE '%$search%'
ORDER BY m.name ASC;";
      return $db->sql_query($query);

    }

      function get_model_by_name($brand_id,$model_name,$utility_class,$db){
        $query = "SELECT m.* FROM `lms2_vehicle_models` m 
        INNER JOIN lms2_vehicle_brands b
        ON m.brand_id = b.id
        WHERE m.name = '$model_name' 
        AND m.status = 1 
        AND b.id = $brand_id
        ORDER BY m.name ASC 
        LIMIT 1;
        ";
        return $db->sql_query($query); 
    }

}


?>