|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/intra/ |
Upload File : |
<?
include "../include/top_iframe.html";
include "_common.php";
//테이블명
$table = "TB_MEMBER_S03";
if (!$start_key) $start_key = "mb_date";
if(!$start_s1) $start_s1 = date("Y-m-")."01"; // 기간 검색
if(!$start_s2) $start_s2 = date("Y-m-d"); // 기간 검색
// 검색 설정
$sql_where = "";
$sql_where .= " and date_format({$start_key},'%Y-%m-%d') between '{$start_s1}' and '{$start_s2}' ";// 출발/도착일 검색
if ( $title_key and $title_s ) $sql_where .= " and {$title_key} like '%{$title_s}%' ";// 행사명
$sql_where .= " and mb_id='{$mb_id}' ";
// 리스트 수 가져옴
$sql = "select count(*) as total from {$table} where 1 {$sql_where} ";
$row = db_fetch($sql);
$total = $row[total];
// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = 20; // 보여줄 갯수
$list = 10; // 블럭 갯수
$total_page = ceil($total / $line); // 총페이지
if ($total == 0) $total_page = 1; // 데이터가 하나도 없으면 총페이지 1
if ($page > $total_page) $page = $total_page; // 페이지가 전체 페이지보다 크면 페이지 번호를 바꿈
$total_list = intval($total_page / $list);
if ($total_page % $list == 0) $total_list--;
$curr_list = intval($page / $list);
if ($page % $list == 0) $curr_list--;
$start_page = $curr_list * $list + 1;
$prev_list = $start_page - $list;
$next_list = $start_page + $list;
$olds = $line * ($page - 1);
// 정렬 설정
$sql_order="";
// limit
$limit = " $olds , $line ";
//배열에 저장
$data = array();
$data = toad_menager_state("TB_MEMBER_S03",$sql_where,$sql_order,$limit);
$href = "mb_id={$mb_id}&start_key={$start_key}&start_s1={$start_s1}&start_s2={$start_s2}";
$_href = $href."&page={$page}";
?>
<div class="iframe ma0">
<div class="popbox">
<!-- 폼 -->
<form name="frm_search" id="frm_search" method="get">
<input type="hidden" name="mb_id" value="<?=$mb_id?>">
<div class="c_top_bar">
<div class="lo_left">
근태일
<input type="text" name="start_s1" class="cal_input" value="<?=$start_s1?>" size="15" onclick="AjaxCal(this,event);" readonly> ~
<input type="text" name="start_s2" class="cal_input" value="<?=$start_s2?>" size="15" onclick="AjaxCal(this,event);" readonly>
</div>
<div class="lo_left">
<input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_img" />
</div>
</div>
</form>
<!-- /폼 -->
<div class="lo_left" style="width:100%;height:10px;"></div>
<table border="0" cellspacing="0" cellpadding="0" width="780" class="setting_write">
<thead>
<tr>
<td colspan="20" class="t_top_line"></td>
</tr>
<tr>
<th width="30">No.</th>
<th>일자</th>
<th>구분</th>
<th>시작일</th>
<th>종료일</th>
<th>일수</th>
<th>입력자</th>
<th>수정일</th>
<th>수정자</th>
<th>-</th>
</tr>
<?
for($i=0 ; $i<count($data) ; $i++)
{
$num = count($data) - $i;
$row = $data[$i];
?>
<tr>
<td><?=$num?></td>
<td><?=$row['mb_date2']?></td><!-- 일자 -->
<td><?=$row['gubun2']?></td><!-- 구분 -->
<td><?=$row['start_dt']?></td><!-- 시작일 -->
<td><?=$row['end_dt']?></td><!-- 종료일 -->
<td><?=$row['voca_cnt']?>일</td><!-- 일수 -->
<td><?=$row['ins_nm']?></td><!-- 입력자 -->
<td><?=$row['edit_dt2']?></td><!-- 수정일 -->
<td><?=$row['edit_nm']?></td><!-- 수정자 -->
<td>
<img src="../image/btn/icon_write.gif" style="cursor:pointer;" onclick="to_dialog.ajax('../setting/manager_s03_edit.html?seq=<?=$row['seq']?>&tmp_layer_id=<?=$tmp_layer_id?>&mb_id=<?=$mb_id?>','근태수정','500','300',true,true);">
<img src="../image/btn/icon_del.gif" style="cursor:pointer;" onclick="if(!confirm('삭제하시겠습니까?'))return;document.location.href='manager_proc.php?SqlType=s03_dele&seq=<?=$row['seq']?>&tmp_layer_id=<?=$tmp_layer_id?>&mb_id=<?=$mb_id?>';"></td>
</tr>
<?
}
?>
</table>
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
<?
include "../include/footer_iframe.html";
?>
<script Language="Javascript">
function check_form()
{
var f = document.frm_member_manager;
// 폼체크
var result = to_validation(f);
if (result == false) return false;
if(!confirm("수정하시겠습니까?")) return false;
ajax_post('','manager_proc.php','frm_member_manager');
}
</script>