|
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/board/ |
Upload File : |
<?
include "../include/top.html";
include "_common.php";
// 1차카테고리 체크
if (!$b_uid_s) $b_uid_s=0; // 1차카테고리 전체
// 카테고리별 일정표 갯수
$cate_sch_arr = toad_schedule_cnt();
//테이블명
$table = " TB_Schedule ";
// 검색 설정
$sql_where = " and Sort='2' ";
if($b_uid_s and $b_uid_ss!='99999' ) $sql_where .= " and b_uid='{$b_uid_ss}' ";
// 리스트 수 가져옴
$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();
$data = toad_schedule("",$sql_where,$sql_order," limit {$olds} , {$line} ");
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title">일정표 폼관리<span class="arrow">></span><strong>일정표 목록</strong></div>
<div class="contents_detail">
<div id="Content_box">
<?
include "_tab_menu.html";
?>
<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 href="#" class="Tbtn red" onclick="to_dialog.iframe('scheduleform_write.html?b_uid_ss=<?=$b_uid_s?>&SqlType=schedule_ins','일정표폼 등록','1000','720',true,true,'no');">일정표 폼등록</a></li>
</ul><!-- 일정표폼등록 -->
</div>
</div>
<!-- 폼 -->
<form name="frm_schedule" id="frm_schedule" method="post">
<input type="hidden" name="SqlType" value="chgorder">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list">
<colgroup>
<col style=" width:45px" />
<col style=" width:45px" />
<col style=" width:50px" />
<col style=" width:150px" />
<col />
<col style=" width:150px" />
<col style=" width:60px" />
</colgroup>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">사용</th>
<th scope="col"><a href="#" onClick="change_ordernum();">순서</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><?=$num?></td>
<td><span id="DelFlag_<?=$row['SiDX']?>" style="cursor:pointer;"><img src="<?=$row['DelFlag_icon']?>" onclick="ajax_obj_loader('scheduleform_proc.html?SqlType=chgflag&SiDX=<?=$row['SiDX']?>&DelFlag=<?=$row['DelFlag_opp']?>','DelFlag_<?=$row['SiDX']?>');"></span></td>
<td>
<input name="OrderNum_arr[]" value="<?=$row['OrderNum']?>" type="text" class="t_no" style="text-align:center; width:24px;" onKeyDown="ChkNum(this,event);" autocomplete='off' /><input type="hidden" name="SiDX_arr[]" value="<?=$row['SiDX']?>" />
</td><!-- 정렬 -->
<td><?=$row['b_name']?></td>
<td class="t_title"><a href="javascript:;" onclick="to_dialog.iframe('scheduleform_write.html?b_uid_s=<?=$b_uid_s?>&SqlType=schedule_edit&SiDX=<?=$row['SiDX']?>','일정표폼 수정','1000','720',true,true,'no');"><?=$row['ScheduleTitle']?></a></td>
<td><?=$row['RegDate2']?></td>
<td><input class="Table_btn" onclick="if(!confirm('정말삭제하시겠습니까?'))return;ajax_loader('scheduleform_proc.html?SqlType=delete_schedule&SiDX=<?=$row['SiDX']?>');" type="button" value="삭제"/></td>
</tr>
<?}?>
</tbody>
</table>
</form>
<!-- /폼 -->
<?=adm_get_paging($total_page, $page, $list, "?$dshref&page=", "")?>
</div>
</div>
</div>
<script type="text/javascript">
function change_ordernum()
{
ajax_post("","scheduleform_proc.html","frm_schedule");
}
</script>
<? include "../include/footer.html" ?>