File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/controllers/dealer.php
Back
<?php class Dealer{ function read($search,$company_ids,$db){ // $dealers = $db -> return_result("SELECT `id`,`name`, `code` FROM `source_dealer` WHERE status != '0' AND concat(name,' ',code) LIKE '%$search%' AND dms_id IN ($company_ids) ORDER by code ASC"); $dealers = $db -> return_result("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.status = 1 AND sd.status = 1 AND scd.type = 1 AND scd.company_id IN ($company_ids) AND CONCAT(sd.code,' ',sd.name) LIKE '%$search%' GROUP BY sd.id ORDER BY sd.code ASC"); $json = []; foreach($dealers as $dealer){ $json[] = ['id'=>$dealer['id'], 'text'=>$dealer['code'].' - '.$dealer['name']]; } echo json_encode($json); } function read_dealer_ids($company_ids,$db){ $dealers = $db -> return_result("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.status = 1 AND sd.status = 1 AND scd.type = 1 AND scd.company_id IN ($company_ids) GROUP BY sd.id ORDER BY sd.code ASC"); $json = []; foreach($dealers as $dealer){ $json[] = ['id'=>$dealer['id']]; } echo json_encode($json); } function read_dealer_content($search,$company_id,$db){ $dealers = $db -> return_result("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.status = 1 AND sd.status = 1 AND scd.type = 1 AND scd.company_id IN ($company_id) AND CONCAT(sd.code,' ',sd.name) LIKE '%$search%' GROUP BY sd.id ORDER BY sd.code ASC LIMIT 10"); $json = []; foreach($dealers as $dealer){ $json[] = ['id'=>$dealer['id'], 'text'=>$dealer['code'].' - '.$dealer['name']]; } echo json_encode($json); } function read_dealer_ids_by_company($company_id,$db){ return $db -> return_result("SELECT sd.id FROM `source_company_dealer` scd INNER JOIN source_dealer sd ON scd.`dealer_id` = sd.id WHERE scd.status = 1 AND sd.status = 1 AND scd.type = 1 AND scd.company_id IN ($company_id) GROUP BY sd.id ORDER BY sd.code ASC"); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings