5) {
sleep(1);
header("Location:" . $WebSite . "login/login_form.php");
exit;
}
include $_SERVER['DOCUMENT_ROOT'] . '/load_header.php';
$title_message = '수입검사 관리대장';
// 품질담당자 및 관리자인 경우 권한 부여
$QCadmin = 0 ;
if($user_name=='이세희' || $user_name=='개발자' || $user_name=='함신옥' || $user_name=='노완호' )
$QCadmin = 1 ;
?>
<?=$title_message?>
query($sql);
$itemNames = $stmh->fetchAll(PDO::FETCH_COLUMN, 0); // item_name 컬럼의 값을 배열로 저장
// 중복 제거
$uniqueItemNames = array_unique($itemNames);
// 결과 출력 (예: 배열 확인용)
// print_r($uniqueItemNames);
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
}
// 현재 날짜
$currentDate = date("Y-m-d");
// fromdate 또는 todate가 빈 문자열이거나 null인 경우 기본 날짜 설정
if ($fromdate === "" || $fromdate === null || $todate === "" || $todate === null) {
$fromdate = date("Y-m-d", strtotime("-32 weeks", strtotime($currentDate))); // 16주 전
$todate = date("Y-m-d", strtotime("+3 months", strtotime($currentDate))); // 3개월 후
$Transtodate = $todate;
} else {
$Transtodate = $todate; // 설정된 기간
}
$SettingDate = "inspection_date"; // 정렬 기준 날짜
$order = " ORDER BY inspection_date DESC, lot_no asc ";
if(checkNull($search)) {
$sql = "SELECT * FROM {$DB}.{$tablename}
WHERE inspection_date BETWEEN date('$fromdate') AND date('$Transtodate') AND searchtag LIKE '%$search%' AND is_deleted IS NULL " . $order;
} else {
$sql = "SELECT * FROM ".$DB.".".$tablename . " WHERE inspection_date BETWEEN date('$fromdate') AND date('$Transtodate') AND is_deleted IS NULL " . $order;
}
try {
$stmh = $pdo->query($sql);
$total_row = $stmh->rowCount();
?>