<월간상세일정>
<월간상세일정>
query($sql); // 검색조건에 맞는글 stmh
$counter = 0;
while ($row = $stmh->fetch(PDO::FETCH_ASSOC)) {
$equipmentList = json_decode($row['equipmentList'], true);
if (!$equipmentList || !is_array($equipmentList)) {
$equipmentList = []; // 비어있거나 JSON 파싱 실패시 빈 배열 처리
}
foreach ($equipmentList as $equipment) {
if(!empty($equipment['col2']) && empty($equipment['col3']) )
{
$counter++;
}
}
}
if($counter>0)
include "./load_request_equipment.php";
// 시공중 현장
$a = " where (is_deleted IS NULL or is_deleted = 0) and workStatus='시공중' ";
$sql="select * from {$DB}.work " . $a;
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row=$stmh->rowCount();
if($total_row>0)
include "./load_work.php";
// 결선중 현장
$a = " where (is_deleted IS NULL or is_deleted = 0) and cableworkStatus='결선중' ";
$sql="select * from {$DB}.work " . $a;
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row=$stmh->rowCount();
if($total_row>0)
include "./load_work_wire.php";
// 착공전
$sql="select * from {$DB}.work where (is_deleted IS NULL or is_deleted = 0) and workStatus='착공전' order by workday desc";
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row = $stmh->rowCount();
if($total_row > 0)
include "./load_work_before.php";
// 착공(1개월 이내) 등록된 현장을 필터링
// $a = " WHERE regist_day >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) and (is_deleted IS NULL or is_deleted = 0) ";
// $sql = "SELECT * FROM {$DB}.work " . $a;
// $stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
// $total_row = $stmh->rowCount();
// if($total_row > 0)
// include "./load_work_new.php";
// 방문요청
$a = " where (is_deleted IS NULL or is_deleted = 0) and checkstep like '%방문요청%' ";
$sql = "SELECT * FROM {$DB}.work " . $a;
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row = $stmh->rowCount();
if($total_row > 0)
include "./load_request_visit.php";
// 실측요청
$a = " where (is_deleted IS NULL or is_deleted = 0) and checkstep like '%실측요청%' ";
$sql = "SELECT * FROM {$DB}.work " . $a;
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row = $stmh->rowCount();
if($total_row > 0)
include "./load_request_measure.php";
// 발주요청
$a = " where (is_deleted IS NULL or is_deleted = 0) and checkstep like '%발주요청%' ";
$sql = "SELECT * FROM {$DB}.work " . $a;
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row = $stmh->rowCount();
if($total_row > 0)
include "./load_request_order.php";
// 결선요청
$a = " where (is_deleted IS NULL or is_deleted = 0) and checkstep like '%결선요청%' ";
$sql = "SELECT * FROM {$DB}.work " . $a;
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row = $stmh->rowCount();
if($total_row > 0)
include "./load_request_cablework.php";
// 인정라벨부착요청
$a = " where (is_deleted IS NULL or is_deleted = 0) and checkstep like '%인정라벨부착요청%' ";
$sql = "SELECT * FROM {$DB}.work " . $a;
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row = $stmh->rowCount();
if($total_row > 0)
include "./load_request_label.php";
// AS요청
$a = " where (is_deleted IS NULL or is_deleted = 0) and checkstep like '%AS요청%' ";
$sql = "SELECT * FROM {$DB}.work " . $a;
$stmh = $pdo->query($sql); // 검색조건에 맞는글 stmh
$total_row = $stmh->rowCount();
if($total_row > 0)
include "./load_request_as.php";
?>
';
$imgpath = './img/goodwordgif/' . $rndimg . '.gif' ;
$imgsize = getimagesize($imgpath);
print '
';
?>