File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/dms.php
Back
<?php class DMS{ function read($search,$dms_ids,$db){ $companies = $db -> return_result("SELECT `id`,`name`, `code` FROM `source_dms` WHERE status != '0' AND concat(name,' ',code) LIKE '%$search%' AND dms_id IN ($dms_ids) ORDER by code ASC"); $json = []; foreach($companies as $dms){ $json[] = ['id'=>$dms['id'], 'text'=>$dms['code'].' - '.$dms['name']]; } echo json_encode($json); } function read_dms_ids($dms_ids,$db){ $companies = $db -> return_result("SELECT `id` FROM `source_dms` WHERE status != '0' AND dms_id IN ($dms_ids) ORDER by code ASC"); $json = []; foreach($companies as $dms){ $json[] = ['id'=>$dms['id']]; } echo json_encode($json); } function read_dms_name_by_id($dms_id,$db){ return $db -> select("SELECT `name` FROM `source_dms` WHERE status != '0' AND id IN ($dms_id) LIMIT 1"); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings