File manager - Edit - /home/autoph/public_html/tasks/app/classes/model_class.php
Back
<?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Model{ function read_models($brand_id,$search,$utility_class,$db){ $query = "SELECT m.`id`, m.`name` FROM `vehicle_models` m INNER JOIN 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 read_model_by_name($brand_id,$model_name,$utility_class,$db){ $query = "SELECT m.* FROM `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); } function read_model_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `vehicle_models` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_model_id_by_name_n_brand_id($brand_id,$name,$utility_class,$db){ $query = "SELECT `id` FROM `vehicle_models` WHERE brand_id = $brand_id AND name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_model_variant_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `vehicle_model_variants` WHERE description = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_model_variants($vehicle_model_id,$search,$utility_class,$db){ $model_filter = $utility_class->isNotEmpty($vehicle_model_id) ? " AND vmv.model_id = $vehicle_model_id " : "" ; // $model_filter = ""; $query = "SELECT vmv.id, vmv.description, vm.id as model_id, vm.name as model,vb.id as brand_id, vb.name as brand FROM `vehicle_model_variants` vmv LEFT OUTER JOIN vehicle_models vm ON vmv.model_id = vm.id LEFT OUTER JOIN vehicle_brands vb ON vm.brand_id = vb.id WHERE 1 AND vmv.description LIKE '%%%s%%' %s /*model id*/ AND vmv.status = 1 GROUP BY vmv.description LIMIT 10"; $query_final = sprintf($query,$search,$model_filter); // echo $query_final;exit; return $db->sql_query($query_final); } function insert_model_variant($model_id,$model_variant,$utility_class,$db){ $query = "INSERT INTO `vehicle_model_variants`(`model_id`, `description`, `status`) VALUES ('$model_id','$model_variant',1)"; return $db->sql_query_id($query); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings