5) {
sleep(1);
header("Location:" . $WebSite . "login/login_form.php");
exit;
}
include $_SERVER['DOCUMENT_ROOT'] . '/load_header.php';
$title_message = '제조 통계 (출고 예정까지 포함)';
$title_prefix = '스크린 + 철재(스라트)';
?>
<?= $title_prefix ?> <?= $title_message ?>
'1' OR devMode IS NULL) ORDER BY outdate DESC";
try {
$stmh = $pdo->prepare($sql);
$stmh->bindValue(':fromdate', $fromdate);
$stmh->bindValue(':transtodate', $transtodate);
$stmh->execute();
$rows = $stmh->fetchAll(PDO::FETCH_ASSOC);
$chartData = [];
$screenData = [];
$slatData = [];
foreach ($rows as $row) {
$date = date("Y-m-d", strtotime($row['outdate']));
$screen_m2 = intval(trim($row['screen_m2']));
$slat_m2 = intval(trim($row['slat_m2']));
if (!isset($chartData[$date])) {
$chartData[$date] = 0;
$screenData[$date] = 0;
$slatData[$date] = 0;
}
$chartData[$date] += $screen_m2 + $slat_m2;
$screenData[$date] += $screen_m2;
$slatData[$date] += $slat_m2;
}
$jsonChartData = json_encode($chartData);
$jsonScreenData = json_encode($screenData);
$jsonSlatData = json_encode($slatData);
} catch (PDOException $Exception) {
print "오류: " . $Exception->getMessage();
}
?>