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