if ($SerchOptioncount == 0) {
$querymemo = "";
}
$x = $querymemo;
}
$queryarray[] = "SELECT id FROM list WHERE year in(" . implode(") UNION (", $input[$SerchOption]) . ")";
break;
case "code":
$input[$SerchOption] = array_map(function ($x) {
return explode(",", $x);
}, $input[$SerchOption]);
foreach ($input[$SerchOption] as &$x) {
$SerchOptioncount = 0;
$querymemo = "SELECT DISTINCT(D0.id) FROM";
foreach ($x as &$y) {
$y = $db->escape($y);
$memo = "";
$memo = "(SELECT id FROM summary WHERE code LIKE '%{$y}%' ) as D{$SerchOptioncount} ";
if ($SerchOptioncount > 0) {
$querymemo .= " JOIN " . $memo . "ON D0.id = D{$SerchOptioncount}.id";
} else {
$querymemo .= $memo;
}
$SerchOptioncount++;
}
$x = $querymemo;
}
$queryarray[] = "SELECT id FROM summary WHERE id in(" . implode(") UNION (", $input[$SerchOption]) . ")";
break;
case "schedule":
$input[$SerchOption] = array_map(function ($x) {
