public static function getYamaiId($yamai_name, $yamai_type = "", $yamai_system = "")
{
global $db;
QLog::log("YamaiModel::getYamaiId({$yamai_name},{$yamai_type},{$yamai_system})");
$yamai_name_quoted = $db->quote($yamai_name);
$yamai_type_quoted = $db->quote($yamai_type);
$yamai_system_quoted = $db->quote($yamai_system);
$sql = "SELECT yamai_id FROM yamai \n\t\tWHERE yamai_name = {$yamai_name_quoted}\n\t\tAND yamai_type = {$yamai_type_quoted}\n\t\tAND yamai_system = {$yamai_system_quoted}\n\t\t";
$yamai_id = $db->getOne($sql);
QLog::log("getYamaiId::Search: [" . $sql . "] => {$yamai_id}");
if (empty($yamai_id)) {
$yamai_id = YamaiModel::createYamaiItem($yamai_name, $yamai_type, $yamai_system);
}
return $yamai_id;
}
echo json_encode(array('updated' => $afx === false ? '0' : '1'));
exit;
} elseif ($act == "list_yamai") {
$yamai_name = getRequest('yamai_name', '');
$yamai_type = getRequest('yamai_type', null);
$yamai_system = getRequest('yamai_system', null);
$limit = 0;
$offset = 0;
$list_of_yamai = YamaiModel::listYamai($yamai_name, $yamai_type, $yamai_system, $limit, $offset);
echo json_encode(array('list' => $list_of_yamai === false ? array() : $list_of_yamai));
exit;
} elseif ($act == "search") {
$keywords = getRequest('keywords', array());
$keywords = preg_split("/[\\s,]+/", $keywords);
$list_of_yamai = KYStoreModel::searchKeywords($keywords);
echo json_encode(array('list' => $list_of_yamai === false ? array() : $list_of_yamai));
exit;
} elseif ($act == 'possible_keywords') {
$keyword = getRequest('keyword', '');
$limit = getRequest('limit', 10);
$keywords = KeywordModel::queryKeywordWithPrefix($keyword, $limit);
echo json_encode(array('list' => $keywords === false ? array() : $keywords));
exit;
} elseif ($act == 'possible_yamai') {
$keyword = getRequest('keyword', '');
$type = getRequest('type', '');
$limit = getRequest('limit', 10);
$keywords = YamaiModel::queryYamaiWithTypeAndPrefix($type, $keyword, $limit);
echo json_encode(array('list' => $keywords === false ? array() : $keywords));
exit;
}
