function parseRequest($lineData)
{
$formData = array();
$formData['aid'] = normalizeData($lineData['aid']);
$formData['pwd'] = normalizeData($lineData['pwd']);
return $formData;
}
function getData()
{
$repo = empty($_GET['repo']) ? null : $_GET['repo'];
$sha = empty($_GET['sha']) ? null : $_GET['sha'];
if (is_null($repo) || is_null($sha)) {
return null;
}
$path = "{$repo}/" . substr($sha, 0, 2) . "/{$sha}.json";
$data = @file_get_contents(JQUERY_CLA_SERVER_URL . "/{$path}");
if (!$data) {
return null;
}
$data = json_decode($data);
$data = normalizeData($data);
$data->repo = $repo;
return $data;
}
function create_search_sql($searchInfo)
{
/*** 検索条件 ***/
//var_dump($searchInfo);
//$fiels = array(FLD_OCCURRENCE_PLACE, FLD_SCREEN_ID, FLD_ERR_CONTENT, FLD_CAUTION, FLD_VERSION, FLD_CORRECTIONS);
// 空白 [ \t\n\r\f] または全角空白で分割
$key_words = mb_convert_encoding($searchInfo["key_word"], "EUC-JP", "auto");
//print "$key_words";
// キーワードを整形
$key_words = normalizeData($searchInfo["key_word"]);
// 全角スペースを半角スペースに変換。(↑その他の変換も含め上記メソッドを使用)
//$key_words = str_replace(' ', ' ', $key_words);
//$keyword = mb_convert_kana($keyword, 's'); <-- 全角スペースを半角スペースに変換するにはこの方法でもOK
$words = preg_split("/[\\s,]+/", $key_words, -1, PREG_SPLIT_NO_EMPTY);
//var_dump($words);
$sql_param_search = "";
//print "count: " . count($words);
if (count($words) > 0 && $words[0] != null) {
foreach ($searchInfo as $key => $val) {
if ($key == "key_word") {
continue;
}
if (strlen($sql_param_search) > 0) {
$sql_param_search .= " OR ";
}
$sql_param_word = "";
foreach ($words as $word) {
if (strlen($sql_param_word) > 0) {
$sql_param_word .= " AND ";
}
$sql_param_word .= "{$key} " . bind_like($word);
}
$sql_param_search .= "(" . $sql_param_word . ")";
}
}
return $sql_param_search;
}
