case "価格":
$sql = 'SELECT DISTINCT id,name,comment FROM wasemeshi_list NATURAL JOIN menu_list NATURAL JOIN scene_list WHERE price BETWEEN :PRICE2 AND :PRICE';
$sql = add_sql($sql, $menu, $place, $scene, $gate, $price);
$stmt = $pdo->prepare($sql);
$price_set = price_set($tag);
$priceX = $price_set[0];
$priceX2 = $price_set[1];
$stmt->bindValue(':PRICE', $priceX, PDO::PARAM_INT);
$stmt->bindValue(':PRICE2', $priceX2, PDO::PARAM_INT);
$stmt = set_stmt($stmt, $menu, $place, $scene, $gate, $price);
break;
case "シーン":
$sql = 'SELECT DISTINCT id,name,comment FROM wasemeshi_list NATURAL JOIN menu_list NATURAL JOIN scene_list WHERE ';
$sql = add_sql($sql, $menu, $place, $scene, $gate, $price);
$stmt = $pdo->prepare($sql);
$stmt = set_stmt($stmt, $menu, $place, $scene, $gate, $price);
break;
default:
print "error";
break;
}
//件数表示
$stmt->execute();
$resultset = $stmt->fetchAll();
$resultNum = count($resultset);
$stmt->execute();
$pdo = null;
?>
<!DOCTYPE HTML>
<html lang="ja">
function get_log($file = null)
{
global $_STATE;
$fields = "";
foreach ($_STATE->headings as $name) {
$fields .= $name . ",";
}
$stmt = set_stmt($fields . " task_id AS charged");
$from = $_STATE->from_date->format('Y-m-d');
$to = $_STATE->to_date->format('Y-m-d');
$task_id = $_STATE->firstID;
$charged = add_charged($from, $to, $task_id);
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
if (end($row) != $task_id) {
$task_id = end($row);
$charged = add_charged($from, $to, $task_id);
}
$row[count($row) - 1] = $charged;
if (is_null($file)) {
echo "<tr>";
foreach ($row as $value) {
echo "<td>" . $value . "</td>";
}
echo "</tr>\n";
} else {
fputcsv($file, $row);
}
}
$stmt->closeCursor();
}
