File manager - Edit - /home/autoph/public_html/connectv1/app/misc/get_company.php
Back
<?php include("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; if(isset($_GET['searchTerm'])){ $search = $db -> escape(trim($_GET['searchTerm'])); $search_q = " AND concat(sc.code,' - ',sc.`name`) LIKE '%$search%' "; }else{ $search = ""; $search_q = ""; } if(isset($_GET['dms_id'])){ $dms_id = $db -> escape(($_GET['dms_id'])); $dms_id_q = " AND sc.dms_id = '$dms_id' "; }else{ $dms_id = ""; $dms_id_q = ""; } $type = $_GET['type']; $query = "SELECT sc.`id`, sc.code,sc.`name` FROM `source_company` sc INNER JOIN source_company_dealer scd ON sc.id = scd.company_id WHERE sc.status = 1 AND scd.type = 1 AND sc.id IN (".$granted_company_ids.") %s %s GROUP BY sc.id ORDER by sc.`name` ASC LIMIT 10 "; // -- // echo sprintf($query,$search_q,$dms_id_q); $employee_info = $db -> return_result(sprintf($query,$search_q,$dms_id_q)); // print_r($employee_info); $json = []; foreach($employee_info as $data){ $json[] = ['id'=>$data['id'], 'text'=>$data['code'] .' - '. $data['name']]; } if(isset($_GET['import'])){ $json[] = ['id'=>0, 'text'=>'DIFFERENT COMPANIES (SYSTEM DECIDED)']; } echo json_encode($json); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings