<?php
$sub_menu = "400100";
include_once('./_common.php');
include (G5_SKIN_PATH.'/multi_category/lib.php');
 
auth_check($auth[$sub_menu], 'r');
 
$g5['title'] = '전체 접수내역';
include_once('./handling.sub.php');
 
$colspan = 5;
 
$max = 0;
$sum_count = 0;
$sql = " select * from {$g5['write_aaaa_table']}
            where wr_3 between '{$fr_date}' and '{$to_date}' order by wr_id desc";
$result = sql_query($sql);
 
?>
 
<div class="tbl_head01 tbl_wrap">
 
    <table>
    <caption><?php echo $g5['title']; ?> 목록</caption>
    <thead>
    <tr>
        <th scope="col">분류</th>
        <th scope="col">제목</th>
        <th scope="col">접수경로</th>
        <th scope="col">접수일</th>
        <th scope="col">접수시간</th>
        <th scope="col">접수자</th>
        <th scope="col">연락처</th>
        <th scope="col">휴대전화</th>
        <th scope="col">지역</th>
        <th scope="col">상세주소</th>
        <th scope="col">내용</th>
        <th scope="col">기타사항</th>
        <th scope="col">처리상태</th>
        <th scope="col">처리완료일</th>
        <th scope="col">처리불가 사유</th>
 
    </tr>
    </thead>
 
    <tbody>
      <?php
      $h1 = 0;
      $h2 = 0;
      $h3 = 0;
      $h4 = 0;
      $no = 0;
 
      for ($i=0; $row=sql_fetch_array($result); $i++) {
          $no = $i+1;
          $ca_name = $row['ca_name'];
            include('handle_multi.php');
          $wr_1 = $row['wr_1'];
          $wr_2 = $row['wr_2'];
          $wr_3 = $row['wr_3'];
          $wr_4 = $row['wr_4'];
          $wr_5 = $row['wr_5'];
          $wr_6 = $row['wr_6'];
          $wr_7 = $row['wr_7'];
          $wr_8 = $row['wr_8'];
          $wr_9 = $row['wr_9'];
          $wr_10 = $row['wr_10'];
          $wr_11 = $row['wr_11'];
          $wr_12 = $row['wr_12'];
          $wr_13 = $row['wr_13'];
          $wr_subject = $row['wr_subject'];
          $wr_content = $row['wr_content'];
          $bg = 'bg'.($i%2);
 
          if($wr_1 == '처리중'){
            $h1 = $h1 + 1;
          }
          else if($wr_1 == '처리완료'){
            $h2 = $h2 + 1;
          }
          else if($wr_1 == '처리불가'){
            $h3 = $h3 + 1;
          }
          else {
            $h4 = $h4 + 1;
          }
    ?>
 
    <tr class="<?php echo $bg; ?>">
        <td><?php echo $ca_name ?></td>
        <td><?php echo $wr_subject ?></td>
        <td><?php echo $wr_2 ?></td>
        <td><?php echo $wr_3 ?></td>
        <td><?php echo $wr_4 ?></td>
        <td><?php echo $wr_5 ?></td>
        <td><?php echo $wr_6 ?></td>
        <td><?php echo $wr_7 ?></td>
        <td><?php echo $wr_8 ?></td>
        <td><?php echo $wr_9 ?></td>
        <td><?php echo $wr_content ?></td>
        <td><?php echo $wr_10 ?></td>
        <td><?php echo $wr_1 ?></td>
        <td><?php echo $wr_12 ?></td>
        <td><?php echo $wr_13 ?></td>
    </tr>
 
    <?php
    }
    $sum_count = $no;
    if ($i == 0)
        echo '<tr><td colspan="15" class="empty_table">자료가 없습니다.</td></tr>';
 
    ?>
    </tbody>
    <tfoot>
    <tr>
        <td>합계</td>
        <td><strong><?php echo $sum_count ?></strong></td>
        <td colspan="13"> 처리중 : <?php echo $h1 ?> | 처리완료 : <?php echo $h2 ?> | 처리불가 : <?php echo $h3 ?> | 대기 : <?php echo $h4 ?></td>
    </tr>
    </tfoot>
    </table>
</div>
 
<?php
include_once('./admin.tail.php');
?>