File manager - Edit - /home/autoph/public_html/connectv1/app/misc/get_dealer_customer.php
Back
<?php include_once("../../cfg/db.php"); error_reporting(0); if(isset($_GET['searchTerm'])){ $search = $db -> escape(trim($_GET['searchTerm'])); $search_q = " AND concat(sd.code,' - ',sd.`name`) LIKE '%$search%' "; } else { $search = ""; $search_q = ""; } if(isset($_GET['company_id'])){ $company_id = $db -> escape(trim($_GET['company_id'])); $company_q = " AND scd.company_id = '$company_id' "; } else { $company_id = ""; $company_q = ""; } $type = $_GET['type']; $query = "SELECT sd.id, sd.code, sd.name FROM source_dealer sd INNER JOIN source_company_dealer scd ON sd.id=scd.dealer_id WHERE 1 %s %s AND type = $type AND sd.status = 1 and scd.status = 1 AND sd.id != 0 GROUP BY sd.id ORDER BY sd.name ASC LIMIT 10"; // echo sprintf($query,$search_q,$company_q); return; $employee_info = $db -> return_result(sprintf($query,$search_q,$company_q)); $json = []; $json[] = array('id'=>'0', 'text'=>'ALL'); foreach($employee_info as $data){ $json[] = array('id'=>$data['id'], 'text'=>$data['code'] .' - '. $data['name']); } if(isset($_GET['import'])){ $json[] = ['id'=>0, 'text'=>'DIFFERENT DEALERSHIP (SYSTEM DECIDED)']; } echo json_encode($json); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings