sam-kd/load_request_cablework.php

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

$title_message = '결선요청';   

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> ';	
} 
 
$sql="select * from chandj.work where (is_deleted IS NULL or  is_deleted = 0) and checkstep like '%결선요청%' order by num desc"; 					
	                         
$nowday=date("Y-m-d");   // 현재일자 변수지정          					 

$start_num=1;					
	   
 try{   
    $stmh = $pdo->query($sql);             
    $total_row = $stmh->rowCount();  
  } catch (PDOException $Exception) {
	print "오류: ".$Exception->getMessage();
  }   
  
$display_cablework = $total_row;
  
?>
	
<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_request_cablework.php?header=header">
					<span class="badge bg-success me-1 fs-6">  <?=$title_message?> </span> 				
				</a>  </span> 			
			  <h6> <span id="display_cablework_su" class="badge bg-success"></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-success">
		<tr>
			<th class="text-center" style="width:40px;">번호</th>
			<th class="text-center" style="width:90px;">접수일</th>
			<th class="text-center" style="width:220px;">현장명</th> 
			<th class="text-center" style="width:120px;">발주처</th>
			<th class="text-center" style="width:120px;">담당자</th>
			<th class="text-center" style="width:100px;">연락처</th>
			<th class="text-center" style="width:60px;">공사담당</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_cablework('<?= $num ?>', '<?= $tablename ?>')">
			<td class="text-center"><?= $start_num ?></td>
			<td class="text-center"><?= $regist_day ?></td> 							
			<td class="text-start fw-bold text-success" 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-success"; break;  // 파란색														
					case 3: $state_str = "시공완료"; $badge_class = "badge bg-danger"; break;  // 빨간색
					default: $state_str = "계약전"; $badge_class = "badge bg-success"; break;  // 회색
				}
				?>
				<span class="<?= $badge_class ?>"><?= $state_str ?></span>

			</td>  
			<td class="text-center">
				<?php
				switch ($cableworkStatus) {									
					case "결선중" : $badge_class = "badge bg-success"; break;
					case "결선완료" : $badge_class = "badge bg-danger"; break;  // 빨간색
					default: $badge_class = "badge bg-secondary"; break;  // 회색
				}
				?>
				<span class="<?= $badge_class ?>"><?= $cableworkStatus ?></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_cablework(num) {
	popupCenter("./work/write_form.php?mode=view&tablename=work&num=" + num , "공사수주내역", 1850, 900); 	      
}
$(document).ready(function(){	    	
	document.getElementById('display_cablework_su').textContent = ' <?= $total_row ?>';
}); 
</script>