|
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/erp/ |
Upload File : |
<?
include "../include/top.html";
include "_common.php";
//테이블명
$table = "TB_GUIDE";
// 검색 설정
if($search_key and $search_word) $sql_where .= " and {$search_key} like '%{$search_word}%' ";// 검색
// 리스트 수 가져옴
$sql = "select count(*) as total from {$table} where 0=0 {$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="";
// 데이터
$data = array();
$sql = "select * from {$table} where 0=0 {$sql_where}";
if($sql_where) $sql .= " ".$sql_where ;
if($sql_order) $sql .= " order by ".$sql_order;
else $sql .= " order by seq desc ";
if($olds>=0 and $line>0) $sql .= " limit $olds , $line";
$rs = db_query($sql);
for ($i=0 ; $row = db_fetch_array($rs) ; $i++ ){
$data[] = $row;
}
$today = date("Y-m-d");
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title"><strong>가이드 리스트</strong></div>
<div class="contents_detail">
<!-- 폼 -->
<form name="frm_list" id="frm_list" method="get">
<div class="c_top_bar">
<ul class="c_top_search">
<li class="pl10">
<select name="search_key" id="search_key">
<option value="guide_nm" <?=($search_key=="guide_nm")?"selected":""?>>가이드명</option>
</select>
</li>
<li>
<label for="search_word" class="v_none2">검색어 입력</label>
<input class="search_box" id="search_word" name="search_word" type="text" value="<?=$search_word?>" onfocus="this.style.background='#ffffff url(none)'" onblur="if(this.value.length == 0) {this.style.background='#ffffff url(../image/common/search_txtbg03.gif)';this.style.backgroundRepeat='no-repeat';this.style.backgroundPosition='5px 1px';}" /><input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_btn_search" />
</li>
</ul>
</div>
</form>
<!-- /폼 -->
<div id="Content_box">
<div class="top_txt_s">
<div class="bar_wrap">
<p class="search_result_txt"><span>Total : <?=$total?></span> </p>
<!-- 상품정렬 -->
<ul class="search_rt_btn">
<li><a class="Tbtn red" href="new_guidelist.html">가이드 등록하기</a></li>
</ul>
</div>
</div>
<!-- 폼 -->
<form name="frm_main_list" id="frm_main_list" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list" summary="버스회사 관리하실 수 있습니다.">
<caption>버스회사 관리</caption>
<colgroup>
<col style="width:30px" />
<col style="width:50px" />
<col style="width:130px"/>
<col style="width:130px" />
<col style="width:130px" />
<col style="width:130px" />
<col style="width:130px" />
<col style="width:;" />
<col style="width:130px" />
<col style="width:180px" />
<col style="width:130px" />
</colgroup>
<thead>
<tr>
<th scope="col">□</th>
<th scope="col">No</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>
<?
for($i=0 ; $i < count($data) ; $i++){
$row = $data[$i];
$num = $total - ($page - 1) * $line - $i;
?>
<tr>
<td><input type="checkbox" name="check" value="y"></td>
<td><?=$num?></td>
<td><?=$row['MEM_NM']?></td>
<td>
<?=$row['MEM_PH']?><br>
</td>
<td><?=$row['MEM_GD']?></td>
<td><?=$row['lanague']?></td>
<td><?=$row['infonumber']?></td>
<td>
<?=$row['event_no']?><br>
</td>
<td><?=$row['complane']?></td>
<td>
<span class="c_red_b"><?=$row['bank_nm']?></span>
</td>
<td>
<?=$row['payment_day']?>
</td>
<td><?=$row['payment_file']?></td>
<td>
<input type="button" name="mb_out" id="mb_out" value="등록" class="Table_btn" onClick="bus_del('<?=$row['number']?>');" />
<input type="button" name="mb_out" id="mb_out" value="삭제" class="Table_btn" onClick="bus_del('<?=$row['number']?>');" />
</td>
</tr>
<?}?>
</tbody>
</table>
</form>
<!-- /폼 -->
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
</div>
</div>
<script type="text/javascript">
function bus_del(number)
{
if(!confirm('완전히 삭제됩니다.'))return;
ajax_loader("bus_proc.php?SqlType=corp_delete&bc_idx="+bc_idx);
}
</script>
<? include "../include/footer.html" ?>