echajoa/manage/car/brand.php

<?php

	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';

	$list_url = "brand.php";
	$mp = "10";	//set top nav

	$PageNo =$_REQUEST['pageno'];
	if (empty($PageNo)) {$PageNo=1;}else{$PageNo=$PageNo;}

	$PageSize=10; //목록개수설정
	$pagestartpoint=($PageNo-1)*$PageSize;

	$sql = "where ds_delind='N'";
	$orderby = "order by cd_model desc";

	/*
	$ds_cate = $_REQUEST[ds_cate];

	if($ds_cate){
		$sql = $sql. "	and ds_cate = '$ds_cate'";
	}
	*/

	$cd_category = $_REQUEST['cd_category'];
	if($cd_category){
		$sql = $sql. "	and cd_category = '$cd_category'";
	}

	if($searchword != ""){
		if($searchtype=="" || $searchtype==null){
			$sql = $sql. "	and (nm_category like '$searchword%')";
		}else{
			$sql = $sql. "	and $searchtype like '$searchword%'";
		}
	}

	$totalrows = @mysql_result(mysql_query("select count(*) from car_brand  $sql"),0,0);

?>
<? include("../inc/inc_top.php") ?>
<? include("../inc/inc_header.php") ?>

<section id="contents">
	<div class="area_title">
		<h2>제조사</h2>
		<div class="area_select">
			<span class="select" style="width:200px;" id="sel_cd_category">
				<select id="cd_category" name="cd_category" onchange="location.href='./brand.php?cd_category='+this.value;"></select>
			</span>
		</div>
	</div>
	<div class="tbl_wrap">
		<table class="tbl_list ty2">
			<colgroup>
				<col width="7%">
				<col width="*">
				<col width="13%">
			</colgroup>
			<thead>
			<tr>
				<th>번호</th>
				<th>제조사</th>
				<th>정보수정</th>
			</tr>
			</thead>
<?
if($totalrows>0) {

			$r = mysql_query("SELECT *
								,(select nm_category from car_category where car_category.cd_category = mst.cd_category) nm_category
								FROM car_brand mst  $sql order by cd_brand desc  LIMIT $pagestartpoint,$PageSize ");


$i=1;
while($col = mysql_fetch_array($r)) {

	$tmpNum =$totalrows-($PageSize*($PageNo-1));
	$no = ($tmpNum - $i)+1;

?>
			<tr>
				<td><?=$no?></td>
				<td><?=$col['nm_brand']?></td>
				<td><a href="./brand_form.php?cd_brand=<?=$col['cd_brand']?>&PageNo=<?=$PageNo?>" class="rnd_s_btn">수정</a></td>
			</tr>
<?
	$i++;
}
}else{
?>
	<tr>
		<td align="center" colspan="3">등록된 정보가 없습니다.</td>
	</tr>
<?
}
?>
		</table>
	</div>

	<!-- layer popup -->
	<div class="layer_popup modify_popup">
		<div class="close">팝업닫기</div>
		<div class="cont2">
			<table class="tbl_list2" style="width:460px;">
				<colgroup>
					<col width="20%">
					<col width="*">
				</colgroup>
				<tr>
					<th>구분</th>
					<td>
						<div class="radio_chk">
							<span class="check_wrap"><input type="radio" name="radiobutton" id="domestic"><i></i><label for="domestic">국내</label></span>
							<span class="check_wrap"><input type="radio" name="radiobutton" id="overseas"><i></i><label for="overseas">해외</label></span>
						</div>
					</td>
				</tr>
				<tr>
					<th>제조사</th>
					<td><input type="text" class="inp_txt" style="width:320px;" value="현대"></td>
				</tr>
			</table>
			<div class="btn_center">
				<a href="#" class="rnd_btn ty2 gray">수정</a>
				<a href="#" class="rnd_btn ty2 black">삭제</a>
			</div>
		</div>
	</div>
	<!-- // layer popup -->

	<div class="paging">
		<?
				$url = "./$list_url?searchtype=$searchtype&searchword=$searchword";
				ListPg1($url ,$PageNo,$PageSize,10,$totalrows,$leftboard[1],$rootpath);
		?>
	</div>

	<div class="btn_right">
		<a href="#" class="rnd_btn gray" onclick="location.replace('./brand_form.php');">+ 제조사 등록</a>
	</div>
</section>

<script language="javascript" type="text/javascript">

	$(document).ready(function() {
		setCodeSelectJqTransForm("listcategory","cd_category","car_category","cd_category","<?=$cd_category?>","선택하세요","");
	});
</script>

<? include("../inc/inc_footer.php") ?>
<? include("../inc/inc_bottom.php") ?>
<?
mysql_close($connect);
?>