home/autoph/public_html/connectv1/api/controllers/dms.php000064400000001767150311217660017626 0ustar00 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"); } } ?>home/autoph/public_html/connectv1/dms.php000064400000706773150312177320014517 0ustar00start($db); // if(!(isset($_SESSION['user']['action_permissions']['4']['sub_18_1']) && // $_SESSION['user']['action_permissions']['4']['sub_18_1'])){ // header('location:signin.php'); // } if(isset($_GET['dms']) && isset($_GET['type'])){ $source_dms_id = intval($db -> escape($_GET['dms'])); if($db -> sql_query("SELECT id FROM source_dms WHERE status <> 0 AND id = '$source_dms_id' AND status =1 ") -> num_rows < 1){ header('location:dms.php'); } $source_dms_type_id = intval($db -> escape($_GET['type'])); if($db -> sql_query("SELECT id FROM source_dms_type WHERE id = '$source_dms_type_id' AND status =1 ") -> num_rows < 1){ header('location:dms.php'); } }else{ $source_dms_id = (int) $db -> select ("SELECT id FROM source_dms WHERE status <> 0 ORDER BY name ASC LIMIT 1"); $source_dms_type_id = (int) $db -> select ("SELECT `id`, `name` FROM `source_dms_type` WHERE `status` = 1 ORDER BY name ASC LIMIT 1"); } $_SESSION['selected_dms_id'] = $source_dms_id; $_SESSION['selected_dms_type_id'] = $source_dms_type_id; ?> <?php echo $variable['site_name']; ?> | DMS Settings

DMS Settings

  1. Home
  2. DMS Settings
Loading, please wait...
" id="db-" role="tabpanel" aria-labelledby="db-tab-">
" id="db-" role="tabpanel" aria-labelledby="db-tab-">
" id="db-" role="tabpanel" aria-labelledby="db-tab-">
" id="db-" role="tabpanel" aria-labelledby="db-tab-">