File manager - Edit - /home/autoph/public_html/connectv1/lms/app/controllers/dealer.php
Back
<?php class Dealer{ function read_code_count($code,$utility_class,$db){ return $db->sql_query_num_rows("SELECT id FROM `lms2_dealers` WHERE `code` = '$code' AND status = 1"); } function read_name_count($name,$utility_class,$db){ return $db->sql_query_num_rows("SELECT id FROM `lms2_dealers` WHERE `name` = '$name' AND status = 1"); } function insert_dealer($array_data,$utility_class,$db){ $added_by = NULL; $login_info = $db->get_user_session(); if($login_info){ $added_by = $login_info['id']; } $query = "INSERT INTO `lms2_dealers`(`company_id`,`name`, `code`, `added_by`, `date_added`, `status`) VALUES ('".$array_data['dd_dealer_company']."','".$array_data['txt_dealer_name']."','".$array_data['txt_dealer_code']."',$added_by,NOW(),'1')"; $inserted_count = $db->sql_query_affected_rows($query); return intval($inserted_count); } function dealer_list($search,$utility_class,$db){ $query = "SELECT d.id,d.name,d.code FROM `lms2_dealers` d INNER JOIN lms2_companies c ON d.company_id = c.id WHERE 1 AND CONCAT (d.code,' ',d.name) LIKE '%%%s%%' AND c.status = 1 AND d.status = 1 ORDER BY d.name ASC"; $query_final = sprintf($query,$search); return $db->sql_query($query_final); } function dealer_list_by_company($search,$company_id,$utility_class,$db){ $query = "SELECT d.id,d.name,d.code FROM `lms2_dealers` d INNER JOIN lms2_companies c ON d.company_id = c.id WHERE 1 AND CONCAT (d.code,' ',d.name) LIKE '%%%s%%' AND c.status = 1 AND d.status = 1 AND c.id = $company_id ORDER BY d.name ASC"; $query_final = sprintf($query,$search); return $db->sql_query($query_final); } function dealer_list_by_ids($search,$user_dealers,$utility_class,$db){ $user_dealer_ids = implode(', ', $user_dealers); $query = "SELECT d.id,d.name,d.code FROM `lms2_dealers` d INNER JOIN lms2_companies c ON d.company_id = c.id WHERE 1 AND CONCAT (d.code,' ',d.name) LIKE '%%%s%%' AND c.status = 1 AND d.status = 1 AND d.id IN (".$user_dealer_ids.") ORDER BY d.name ASC"; // echo $query; $query_final = sprintf($query,$search); return $db->sql_query($query_final); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings