File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/employee.php
Back
<?php class Employee { function read_sales_consultant_v2($search,$db){ $sales_consultant = $db -> return_result("SELECT sc.id,sc.first_name,sc.last_name FROM `sales_consultant` sc WHERE sc.status = 1 AND concat(sc.first_name,' ',sc.last_name) LIKE '%$search%' GROUP BY sc.id LIMIT 20"); $json = []; foreach($sales_consultant as $sc){ $json[] = ['id'=>$sc['id'], 'text'=>$sc['first_name'].' '.$sc['last_name']]; } echo json_encode($json); } function read_sales_consultant_gm($search, $db){ $sales_consultant = $db -> return_result("SELECT sc.id,sc.first_name,sc.last_name FROM `sales_consultant` sc INNER JOIN sales_group sg ON sc.id = sg.gm_id WHERE sc.status = 1 AND concat(sc.first_name,' ',sc.last_name) LIKE '%$search%' GROUP BY sc.id LIMIT 20"); $json = []; foreach($sales_consultant as $sc){ $json[] = ['id'=>$sc['id'], 'text'=>$sc['first_name'].' '.$sc['last_name']]; } echo json_encode($json); } function read_sales_consultant($search, $gm_id,$db){ $sales_consultant = $db -> return_result("SELECT sc.id,sc.first_name,sc.last_name FROM `sales_consultant` sc INNER JOIN sales_group sg ON sc.id = sg.sc_id WHERE sc.status = 1 AND concat(sc.first_name,' ',sc.last_name) LIKE '%$search%' AND gm_id= '$gm_id' GROUP BY sc.id LIMIT 20"); $json = []; foreach($sales_consultant as $sc){ $json[] = ['id'=>$sc['id'], 'text'=>$sc['first_name'].' '.$sc['last_name']]; } echo json_encode($json); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings