File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/company.php
Back
<?php class Company{ function read($search,$dms_ids,$db){ $companies = $db -> return_result("SELECT `id`,`name`, `code` FROM `source_company` WHERE status != '0' AND concat(name,' ',code) LIKE '%$search%' AND dms_id IN ($dms_ids) ORDER by code ASC"); $json = []; foreach($companies as $company){ $json[] = ['id'=>$company['id'], 'text'=>$company['code'].' - '.$company['name']]; } echo json_encode($json); } function read_company_ids($dms_ids,$db){ $companies = $db -> return_result("SELECT `id` FROM `source_company` WHERE status != '0' AND dms_id IN ($dms_ids) ORDER by code ASC"); $json = []; foreach($companies as $company){ $json[] = ['id'=>$company['id']]; } echo json_encode($json); } function read_company_content($search,$companies_ids,$dms_id,$db){ $companies = $db -> return_result("SELECT id,name,code FROM `source_company` WHERE (dms_id = '$dms_id' AND status=1 AND concat(`name`,' ',`code`) LIKE '%$search%') AND id IN (".$companies_ids.") ORDER BY name ASC LIMIT 10"); $json = []; foreach($companies as $company){ $json[] = ['id'=>$company['id'], 'text'=>$company['code'].' - '.$company['name']]; } echo json_encode($json); } function read_company_ids_by_dms($dms_id,$db){ return $db -> return_result("SELECT `id` FROM `source_company` WHERE status != '0' AND dms_id IN ($dms_id) ORDER by code ASC"); } function read_company_name_by_id($company_id,$db){ return $db -> select("SELECT `name` FROM `source_company` WHERE status != '0' AND id IN ($company_id) LIMIT 1"); } function read_company_ids_by_group_id($group_id,$db){ $query = "SELECT * FROM `source_company_group_list` WHERE status = 1 AND company_group_id IN ($group_id,1) "; // echo $query; return $db -> sql_query($query); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings