sam-kd/load_work_new.php

<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/session.php");  


$header = $_REQUEST['header'] ?? '';

$title_message = '착공 (1개월 이내) ';   

if($header == 'header') 
{
	include $_SERVER['DOCUMENT_ROOT'] . '/load_header.php'; 
	require_once($_SERVER['DOCUMENT_ROOT'] . '/myheader1.php');	
	$tablename = 'work'; 
	require_once($_SERVER['DOCUMENT_ROOT'] . "/lib/mydb.php");
	$pdo = db_connect();  

   echo '<title>  ' . $title_message . ' </title> ';
	
}

$now = date("Y-m-d",time());  

 // 기간을 정하는 구간
$fromdate=date("Y-m-d");   	      
$sql="select * from chandj.work where (is_deleted IS NULL or  is_deleted = 0) and regist_day >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) order by workday desc";
$nowday=date("Y-m-d");   // 현재일자 변수지정          					 

$start_num=1;
try{   
    $stmh = $pdo->query($sql);             
    $total_row = $stmh->rowCount();  
  } catch (PDOException $Exception) {
	print "오류: ".$Exception->getMessage();
}   
  
$total_work_new_su = $total_row;
$WorkboforeCount = $total_row; // 1개월이내 착공건수  
?>

<style>
    .rounded-card {
        border-radius: 15px !important;  /* 조절하고 싶은 라운드 크기로 설정하세요. */
    }
	th {		
	   text-align : center;	
	}
  
.table-hover tbody tr:hover {
	cursor: pointer;
}	
</style>
	
<div class="card rounded-card  mb-2 mt-3">
<div class="card-header  text-center ">            
		<div class="row"> 		
			<div class="col-sm-12"> 		
				<div class="d-flex  justify-content-center align-items-center "> 				   
					<span  class="text-dark fs-6 me-3"> 
					<a href="../load_work_new.php?header=header">
						<span class="badge bg-dark me-1 fs-6">  <?=$title_message?>  </span> 				
					 </a>  </span> 			
				  <h6> <span id="total_work_new_su_display" class="badge bg-dark"></span> 
				  </h6>
				</div>			 
			</div>				 
		</div>			
	</div>
<div class="card-body p-2 m-1 mb-3  d-flex justify-content-center">	
		
<table class="table table-bordered table-hover table-sm">
	<thead class="table-primary">
		<tr>
			<th class="text-center" style="width:60px;">번호</th>
			<th class="text-center" style="width:90px;">등록일</th>
			<th class="text-center" style="width:250px;">현장명</th>
			<th class="text-center" style="width:150px;">발주처</th>
			<th class="text-center" style="width:150px;">담당자</th>
			<th class="text-center" style="width:120px;">연락처</th>
			<th class="text-center" style="width:100px;">공사담당</th>
			<th class="text-center" style="width:100px;">진행현황</th>                        
			<th class="text-center">시공내역</th>
		</tr>
	</thead>
<tbody>	  
	<?php
	$start_num = $total_row;
	while ($row = $stmh->fetch(PDO::FETCH_ASSOC)) {
		include $_SERVER['DOCUMENT_ROOT'] . '/work/_row.php'; 
	?>
		<tr onclick="redirectToView_worknew('<?= $num ?>', '<?= $tablename ?>')">
			<td class="text-center"><?= $start_num ?></td>
			<td class="text-center"><?= $regist_day?></td> 							
			<td class="text-start fw-bold text-primary" title="<?= htmlspecialchars($workplacename) ?>"> <!-- 현장명 -->
				<?php 
				$workplacename = $row['workplacename'];
				if (mb_strlen($workplacename, 'UTF-8') > 20) {
					echo htmlspecialchars(mb_substr($workplacename, 0, 20, 'UTF-8')) . '...';
				} else {
					echo htmlspecialchars($workplacename);
				}
				?>
			</td>
			<td class="text-center"><?= $secondord ?></td>
			<td class="text-center"><?= $secondordman ?></td>
			<td class="text-center"><?= $secondordmantel?></td>
			<td class="text-center"><?= $chargedperson ?></td>
		   <td class="text-center">
				<?php
				$state_work = 0;
				if ($row["checkbox"] == 0) $state_work = 1;
				if (substr($row["workday"], 0, 2) == "20") $state_work = 2;
				if (substr($row["endworkday"], 0, 2) == "20") $state_work = 3;                        
				
				switch ($state_work) {
					case 1: $state_str = "착공전"; $badge_class = "badge bg-dark"; break;  // 검정색
					case 2: $state_str = "시공중"; $badge_class = "badge bg-primary"; break;  // 파란색														
					case 3: $state_str = "시공완료"; $badge_class = "badge bg-danger"; break;  // 빨간색
					default: $state_str = "계약전"; $badge_class = "badge bg-secondary"; break;  // 회색
				}
				?>
				<span class="<?= $badge_class ?>"><?= $state_str ?></span>

			</td>                         
			<td class="text-start" title="<?= htmlspecialchars($worklist) ?>"> <!-- 시공내역 -->
				<?php 
				$worklist = $row['worklist'];
				if (mb_strlen($worklist, 'UTF-8') > 22) {
					echo htmlspecialchars(mb_substr($worklist, 0, 22, 'UTF-8')) . '...';
				} else {
					echo htmlspecialchars($worklist);
				}
				?>
			</td>
		</tr>
	<?php
		$start_num--;
	}
	?>
</tbody>
</table>
</div>
</div> <!--container-->
	
<script>
// 페이지 로딩
$(document).ready(function(){	
    var loader = document.getElementById('loadingOverlay');
    if(loader) 
		loader.style.display = 'none';
});
</script>	
<script> 
function redirectToView_worknew(num) {
	popupCenter("./work/write_form.php?mode=view&tablename=work&num=" + num , "공사수주내역", 1850, 900); 	      
}

$(document).ready(function(){	    	
	document.getElementById('total_work_new_su_display').textContent = '<?= $total_row ?>';
}); 
</script>