5) {
sleep(1);
header("Location:" . $WebSite . "login/login_form.php");
exit;
}
include $_SERVER['DOCUMENT_ROOT'] . '/load_header.php';
$title_message = '절곡작업일지 관리';
?>
<?=$title_message?>
'가이드레일(벽면형)',
'S' => '가이드레일(측면형)',
'G' => '연기차단재',
'B' => '하단마감재(스크린)',
'T' => '하단마감재(철재)',
'L' => 'L - Bar',
'C' => '케이스'
];
// 종류명을 매핑하는 배열
$specNames = [
'I' => '화이바원단',
'S' => 'SUS(마감)',
'U' => 'SUS(마감)2',
'E' => 'EGI(마감)',
'A' => '스크린용',
'D' => 'D형',
'C' => 'C형',
'M' => '본체',
'T' => '본체(철재)',
'B' => '후면코너부',
'L' => '린텔부',
'P' => '점검구',
'F' => '전면부'
];
// 모양&길이를 매핑하는 배열
$slengthNames = [
'53' => 'W50 × 3000',
'54' => 'W50 × 4000',
'83' => 'W80 × 3000',
'84' => 'W80 × 4000',
'12' => '1219',
'24' => '2438',
'30' => '3000',
'35' => '3500',
'40' => '4000',
'41' => '4150',
'42' => '4200',
'43' => '4300'
];
// 작업일지 데이터 조회
try {
$whereClause = [];
$params = [];
if (checkNull($search)) {
$whereClause[] = "(work_order_no LIKE ? OR work_type LIKE ? OR worker LIKE ? OR remark LIKE ?)";
$searchParam = "%$search%";
$params = array_merge($params, [$searchParam, $searchParam, $searchParam, $searchParam]);
}
if (checkNull($workDateFrom)) {
$whereClause[] = "work_date >= ?";
$params[] = $workDateFrom;
}
if (checkNull($workDateTo)) {
$whereClause[] = "work_date <= ?";
$params[] = $workDateTo;
}
if (checkNull($prodCodeFilter)) {
$whereClause[] = "prod_code = ?";
$params[] = $prodCodeFilter;
}
$sql = "SELECT * FROM bending_work_log WHERE is_deleted IS NULL";
if (!empty($whereClause)) {
$sql .= " AND " . implode(' AND ', $whereClause);
}
$sql .= " ORDER BY work_date DESC, id DESC";
$stmt = $pdo->prepare($sql);
$stmt->execute($params);
$workLogs = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $Exception) {
print "오류: ".$Exception->getMessage();
}
?>