<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";
//include $_SERVER['DOCUMENT_ROOT']."/conf/conf_i.php";
if(!$act) $act=1;
?>
<script type="text/javascript" src="/plugin/smartPop/jquery.smartPop.js"></script>
<link rel="stylesheet" href="/plugin/smartPop/jquery.smartPop.css" />
<script type="text/JavaScript">
function openshow(val)
{
	var tmpUrl="./profile_sort_list.php?act="+val;
	var tmpwidth = 840; var tmpheight = 800;
	$.smartPop.open({ background: "grey", width: tmpwidth, height: tmpheight, borderColor:"red", border: 1,bodyClose: true, url: tmpUrl});
}

function goPage(page)
{
	var f = document.form;
	f.page.value = page;
	f.action = '/admin/news.php';
	f.submit();
}
</script>

<script src="/share/js/formcheck.js" type="text/javascript"></script>
<script type="text/javascript">
function go_View(document_no) {
	var f = document.form;
	f.idx.value = document_no;
	f.action = 'profile_write.php?mode=write';
	f.submit();
}

function go_Write(val) {
	var f = document.form;
	f.action = 'profile_write.php?mode=write&division='+val;
	f.submit();
}

function go_Modify(document_no) {
	var f = document.form;
	f.idx.value = document_no;
	f.action = 'profile_write.php';
	f.submit();
}

function go_Delete(idxval) {
	if(confirm("등록된 글이 삭제 됩니다.\n삭제하시겠습니까?")) {
		var f = document.form;
		f.mode.value = 'del';
		f.idx.value = idxval;
		f.action = './Proc/profile_proc.php';
		f.submit();
	}
}
</script>
<div id="contents">
	<h2>PROFILES</h2>
	<div id="content">
 		<ul>
            <li><a href="profile.php?act=1" class="<?if($act==1) echo "act";?>">ALBUM</a></li>
            <li><a href="profile.php?act=2" class="<?if($act==2) echo "act";?>">OST</a></li>
            <li><a href="profile.php?act=3" class="<?if($act==3) echo "act";?>">MUSICCAL</a></li>
            <li><a href="profile.php?act=4" class="<?if($act==4) echo "act";?>">MOVIE</a></li>
            <li><a href="profile.php?act=5" class="<?if($act==5) echo "act";?>">Aword</a></li>
            <li><a href="profile.php?act=6" class="<?if($act==6) echo "act";?>">Ambassador</a></li>
						<span style="float:right;padding-top:8px;"><input type="button" value="우선순위"class="btn_red" onClick="openshow(<?=$act?>);" /></span>
		</ul>

	<table summary="관리자모드 게시판입니다" cellspacing="0" >
		<colgroup>
			<col width="65"/>
			<col width="110"/>
   <col width="110"/>
			<col />
			<col width="50"/>
			<col  width="110"/>
			<col width="70"/>
			<col width="75" />
		</colgroup>
 		<thead>
			<tr>
				<th>No</th>
    <th>구분</th>
				<th>일시</th>
				<th>title</th>
				<th>비밀글</th>
				<th>등록일</th>
				<th>삭제</th>
			</tr>
		</thead>
		<tbody>
		<form name="form" method="post" target="_self" onsubmit="return false;" >
		<input type="hidden" name="page" value="1">
		<input type="hidden" name="totalRow" value="70" >
		<input type="hidden" name="searchType" value="">
		<input type="hidden" name="searchStr" value="">
		<input type="hidden" name="searchGroup" value="">
		<input type="hidden" name="mode" value="">
		<input type="hidden" name="artist" value="">
		<input type="hidden" name="lang_code" value="KO">
		<input type="hidden" name="idx" value="">
		<input type="hidden" name="seq" value="">
		</form>
 <?
		// =============================================== Query
		$tableName = "board_profile";

		if(!$pageCount) $pageCount = 20;

		$show_one_page			= $pageCount;
		$show_view_page			= 10;

		$page     = ( $page ) ? $page : 1;
		$offset   = ($page-1)*$show_one_page;

		if($key_word) {
			$key_word = str_replace(" ","",$key_word);
			$where = "AND $key LIKE '%$key_word%'";
		}

  if($act) $where .="AND division='$act'";

		$order_by = ' ORDER BY sortNum asc,no desc';
		$url_tail = "&act=$act";

		$query_limit  = "limit $offset,$show_one_page";

		$QUERY_TOTAL = "SELECT count(*) FROM $tableName where 1=1  $where $order_by";
		$QUERY_PAGE  = "SELECT * FROM $tableName where 1=1 $where $order_by $query_limit";
		//SELECT *, DATE_FORMAT(writedate, '%Y.%m.%d') AS date FROM tour_community WHERE 1=1 and idx not in (1179,1186) ORDER BY sort DESC ,depth ASC limit 0,15
		//echo $QUERY_PAGE;

		$total_count  = get_db($QUERY_TOTAL);
		$total_page   = ceil( $total_count / $show_one_page);
		$start_num    = $total_count - $offset;  //
		$viewlist2     = ( !$total_count ) ? "" : Get_viewpage2($page,$total_count,$show_one_page,$show_view_page,$url_tail);

		$result= mysql_query($QUERY_PAGE,$db_con);
		if(!$result) {
			error("DB_ERROR");
			exit;
		}
		$total = mysql_affected_rows();
?>
<?
	if(!$total){
		//echo "<tr><td colspan='$colsNum' align=center  height='50px'>등록된 정보가 없습니다.</td></tr>";
		echo "<tr><td colspan=7>登録された情報がございません</td></tr>";

	}else{
		for($i=0; $i<$total; $i++) {
			$Num = $start_num - $i;
			$row = mysql_fetch_array($result);
			$regdate = substr($row[reg_date],0,10);
			$schedule_date = $row[subtitle];
			if($row[division] == "1") $generalName ="ALBUM";
   else if($row[division] == "2") $generalName ="OST";
   else if($row[division] == "3") $generalName ="MUSICAL";
   else if($row[division] == "4") $generalName ="MOVIE";
   else if($row[division] == "5") $generalName ="Aword";
   else if($row[division] == "6") $generalName ="Ambassador";

?>
			<tr>
				<td><?=$Num?></td>
    <td><?=$generalName?></td>
				<td><?=$schedule_date?></td>
				<td class="depth"><a href="javascript:go_View(<?=$row[no]?>);"><?=$row[subject]?></a></td>
				<td><?=$row[is_secret]?></td>
				<td><?=$regdate?></td>
				<td>
					<? if($row[is_delete] == 'Y'){ echo"삭제"; }else{ ?>
					<!--a href="javascript:go_Modify(<?=$row[no]?>);" title="수정"><img src="./images/check.png" alt="" /></a -->
					<a href="javascript:go_Delete(<?=$row[no]?>);" title="클릭삭제"><img src="./images/out.png" alt="" /></a>
					<? } ?>
				</td>
			</tr>
<?
		}
	}
?>


		</tbody>
		</table>
		<div class="btn">
			<a href="javascript:go_Write(<?=$act?>);" class="btn_blue">등록하기</a>
		</div>

	</div>
		<div class="page_list">
		<!--  prev/next_std -->
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
</div>
<p></p>
</body>
</html>