echajoa/manage/member/dealer_view4.php

<?php

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

	$s_cd_dealer = $_REQUEST["cd_dealer"];
	$s_cd_dealer_p = $s_cd_dealer;

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

	$pagestartpoint=($PageNo-1)*$PageSize;
	$sql = "where s.ds_delind='N'";
	$orderby = "order by s.dt_insert desc";

	$searchtype = $_REQUEST['searchtype'];
	$searchword = $_REQUEST['searchword'];
	$ds_usertype = $_REQUEST['ds_usertype'];
	$ds_status = $_REQUEST['ds_status'];

	$ds_type = "A0";	//A0 : 매입
	$sql_from = "";
	$sql = $sql. "	and s.ds_type = '$ds_type' ";

	$sql1 = "	and cd_dealer_p = '$s_cd_dealer' ";

	if($searchword != ""){
		if($searchtype=="" || $searchtype==null){
			$sql = $sql. "	and (s.nm_name like '$searchword%' or a.nm_number like '$searchword%') ";
		}else{
			$sql = $sql. "	and $searchtype like '$searchword%'";
		}
	}

	if($ds_usertype != ""){
		$sql = $sql. "	and s.ds_usertype = '$ds_usertype'";
	}

	$sql_from = $sql_from. "	inner join ( ";
	$sql_from = $sql_from. "	select cd_sale from tender_master where ds_delind = 'N' ".$sql1." group by cd_sale) i ";
	$sql_from = $sql_from. "	on (s.cd_sale = i.cd_sale)  ";
//	$sql = $sql. "	and s.cd_sale in (select cd_sale from tender_master where ds_delind = 'N' ".$sql1." group by cd_sale)";

	$totalrows = @mysql_result(mysql_query("select count(*) from sale_master s inner join car_master a on (	s.cd_car = a.cd_car ) $sql_from $sql"),0,0);

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

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

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

	<!--div class="select_view_type">
		<span class="select" style="width:160px;">
			<select>
				<option value="">10개 보기</option>
				<option value="">20개 보기</option>
				<option value="">30개 보기</option>
			</select>
		</span>
	</div-->

	<div class="tbl_wrap">
		<table class="tbl_list ty2">
			<colgroup>
				<col width="7%">
				<col width="11%">
				<col width="*">
				<col width="9%">
				<col width="11%">
				<col width="8%">
				<col width="8%">
				<col width="9%">
				<col width="9%">
				<col width="13%">
			</colgroup>
			<thead>
			<tr>
				<th>번호</th>
				<th>판매자</th>
				<th>차종</th>
				<th>차량번호</th>
				<th>주행거리</th>
				<th>색상</th>
				<th>변속기</th>
				<th>판매지역</th>
				<th>판매상태</th>
				<th>등록일</th>
			</tr>
			</thead>
<?
if($totalrows>0) {

$r = mysql_query("SELECT
						a.*
						, b.nm_model
						, c.nm_grade
						, d.nm_brand
						, e.nm_model_sub
						, getCode('car_master','ds_type',a.ds_type) as nm_type
						, getCode('car_master','ds_open',a.ds_open) as nm_open
						, getCode('car_master','ds_sales',a.ds_sales) as nm_sales
						, getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
						, getCode('member_master','ds_area',s.ds_area) as nm_area
						, getCode('sale_master','ds_status',s.ds_status) as nm_status
						, s.cd_sale
						, s.nm_name nm_name_sale
						, s.ds_status ds_status_sale
						, case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then '입찰중' when s.ds_status in ('G0') then '입찰마감' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZS') then '구매확정' else '' end as nm_status_sale
						FROM sale_master s
							inner join car_master a
							on (s.cd_car = a.cd_car)
							left outer join car_model b
							on (a.cd_model = b.cd_model)
							left outer join car_grade c
							on (a.cd_grade = c.cd_grade)
							left outer join car_brand d
							on (a.cd_brand = d.cd_brand)
							left outer join car_model_sub e
							on (a.cd_model_sub = e.cd_model_sub)
							$sql_from $sql $orderby LIMIT $pagestartpoint,$PageSize");

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

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

?>

			<tr onclick="location.href='./dealer_view4_detail.php?list_url=<?=$list_url?>&cd_sale=<?=$col['cd_sale']?>&cd_dealer=<?=$s_cd_dealer?>&ds_status_sale=<?=$col['ds_status_sale']?>&ListPageNo=<?=$PageNo?>';" style="cursor:pointer;">
				<td><?=$no?></td>
				<td><?=$col['nm_name_sale']?></td>
				<td><?=$col['nm_brand']." ".$col['nm_model']?></td>
				<td><?=$col['nm_number']?></td>
				<td><?=$col['nm_mileage']?>km</td>
				<td><?=$col['nm_color']?></td>
				<td><?=$col['nm_transmission']?></td>
				<td><?=$col['nm_area']?></td>
				<td><em class="txt_bold"><?=$col['nm_status']?></em></td>
				<td><?=$col['dt_insert']?></td>
			</tr>
<?
	$i++;
}
}else{
?>
			<tr>
				<td colspan="10">등록된 정보가 없습니다.</td>
			</tr>
<?
}
?>
		</table>
	</div>

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

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