25개 이상의 토픽을 선택하실 수 없습니다.
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
33 lines
820 B
PHP
33 lines
820 B
PHP
<?php
|
|
/**
|
|
* Search for a given term (q=) in a given category (from=) and spit out JSON.
|
|
*/
|
|
require 'required.php';
|
|
|
|
require 'dieifnotloggedin.php';
|
|
|
|
$q = $_GET['q'];
|
|
$from = $_GET['from'];
|
|
require 'readfrom.php';
|
|
|
|
if (is_empty($q)) {
|
|
die(json_encode(['status' => 'OK', 'results' => []]));
|
|
}
|
|
|
|
$results;
|
|
// If you want to search through more/different fields, just add them.
|
|
if ($from == 'assets') {
|
|
$results = $database->select($from, '*', ['OR' => ['name[~]' => $q, 'asset_tag[~]' => $q, 'serial[~]' => $q, 'order_number[~]' => $q]]);
|
|
} else {
|
|
$results = $database->select($from, '*', ['OR' => ['name[~]' => $q, 'order_number[~]' => $q]]);
|
|
}
|
|
|
|
if ($results == false) {
|
|
$results = [];
|
|
}
|
|
|
|
//var_dump($database->error());
|
|
//var_dump($results);
|
|
|
|
die(json_encode(['status' => 'OK', 'results' => $results]));
|