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; }