echajoa/manage/member/aap_view3.php

<?php

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

	$mp = "21";	//set top nav

	$cd_dealer = $_REQUEST["cd_dealer"];
	$cd_dealer_p = $cd_dealer;

	if(empty($cd_dealer)){
		AlertRedirect("잘못된 요청입니다.",ADMIN_PATH."/index.php");
	}

	$PageNo =$_REQUEST['pageno'];
	$PageSize =$_REQUEST['PageSize'];
	if (empty($PageNo)) {$PageNo=1;}else{$PageNo=$PageNo;}
	if (empty($PageSize)) {
		$PageSize=10; //목록개수설정
	}else{$PageSize=$PageSize;}

	$pagestartpoint=($PageNo-1)*$PageSize;
	$sql = "where ds_delind='N'";

	$searchtype = $_REQUEST['searchtype'];
	$searchword = $_REQUEST['searchword'];
	$dt_start = $_REQUEST['dt_start'];
	$dt_end = $_REQUEST['dt_end'];

	$sql = $sql. "	and cd_dealer_p = '$cd_dealer' ";

	$ds_type = "D1";
	$sql = $sql. "	and ds_type = '$ds_type' ";

	if($searchword != ""){
		if($searchtype=="" || $searchtype==null){
			$sql = $sql. "	and (nm_name like '$searchword%' or nm_email like '$searchword%') ";
		}else{
			$sql = $sql. "	and $searchtype like '$searchword%'";
		}
	}
	if($dt_start != "" && $dt_end != ""){
		$sql = $sql. "	and dt_insert between '$dt_start' and '$dt_end' ";
	}

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

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

<section id="contents">
	<h2>딜러 / AAP 회원관리</h2>

<? include("../inc/inc_header_aap.php") ?>


	<div class="tbl_wrap">
		<table class="tbl_list">
			<colgroup>
				<col width="7%">
				<col width="18%">
                <col width="18%">
				<col width="16%">
				<col width="*">
				<col width="17%">
				<col width="15%">
			</colgroup>
			<thead>
			<tr>
				<th>번호</th>
                <th>사진</th>
				<th>아이디</th>
				<th>이름</th>
				<th>부서</th>
				<th>연락처</th>
				<th>등록일</th>
			</tr>
			</thead>
<?
		if($totalrows>0) {

			$r = mysql_query("SELECT * FROM aap_master $sql ORDER BY cd_dealer desc  LIMIT $pagestartpoint,$PageSize");

			$i=1;
			while($col = mysql_fetch_array($r)) {
?>
			<tr onclick="location.href='./aap_view3_detail.php?cd_dealer=<?=$col['cd_dealer']?>&cd_dealer_p=<?=$cd_dealer_p?>&PageNo=<?=$PageNo?>';" style="cursor: pointer; cursor: hand;">
				<td><?=$i?></td>
				<td>
				<? if(!empty($col['nm_file'])){ ?>
				<img src="<?=UPLOAD_PATH?>dealer/nm_file/<?=$col['nm_file']?>" width="50">
				<? } ?>
				</td>
				<td><?=$col['cd_dealerid']?></td>
				<td><?=$col['nm_name']?></td>
				<td><?=$col['nm_title']?></td>
				<td><?=$col['nm_hp_01']."-".$col['nm_hp_02']."-".$col['nm_hp_03']?></td>
				<td><?=$col['dt_insert']?></td>
			</tr>
<?
				$i++;
			}
		}else{
?>
			<tr>
				<td colspan="7">데이터가 존재 하지 않습니다.</td>
			</tr>
<?
		}
?>
		</table>
	</div>

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

	<div class="btn_right">
		<!--a href="./aap_view3_detail.php?cd_dealer_p=<?=$cd_dealer_p?>" class="rnd_btn gray">부관리자 등록</a-->
	</div>
</section>

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