echajoa/mypage/dealer_tender_list408.php

<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].'/common/dealer_chk.php';

	$s_cd_dealer = $_SESSION['s_cd_dealer'];
	$s_cd_dealer_p = $_SESSION['s_cd_dealer_p'];
	$s_ds_type = $_SESSION['s_ds_type'];

	$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 = $sql. "	and s.ds_type = '$ds_type' ";

	if($ds_status == "E0"){	//입찰하지 않은 판매건
	$sql = $sql. "	and s.dt_approve >=  DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_TENDER."' HOUR) ";
	$sql = $sql. "	and s.ds_area in (
						select
						   SUBSTRING_INDEX (SUBSTRING_INDEX(nm_area,',',numbers.n),',',-1) 
						from 
						   (select  1 n union  all  select 2  
							union  all  select  3  union  all select 4 
							union  all  select  5  union  all  select  6
							union  all  select  7  union  all  select  8 
							union  all  select  9 union  all  select  10
							union  all  select  11 union  all  select  12
							union  all  select  13 union  all  select  14
							union  all  select  15 union  all  select  16
							union  all  select  17 union  all  select  18
							union  all  select  19 union  all  select  20 
							) numbers INNER  JOIN dealer_master 
							on CHAR_LENGTH ( nm_area ) - CHAR_LENGTH ( REPLACE ( nm_area ,  ',' ,  '' ))>= numbers . n-1
						where cd_dealer = $s_cd_dealer_p 
		) ";
	}

	if($s_ds_type == "D0"){	//딜러
		$sql_ds_type = "	and cd_dealer_p = '$s_cd_dealer' ";
	}else{	//딜러-관리자
		$sql_ds_type = "	and cd_dealer = '$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'";
	}

	if($ds_status == "E0"){	//딜러 업체 소속 입찰 건이 2건 보다 작을 시만 입찰 요청 건에 보이게 한다.	//입찰하지 않은 판매건
		$sql = $sql. "	and s.ds_status in ('E0','F0')";

		$sql = $sql. "	and s.cd_sale not in (select cd_sale from tender_master where ds_delind = 'N' and cd_dealer_p = '$s_cd_dealer_p' group by cd_sale having count(*) > 1)";	//딜러 업체 소속 입찰 건이 2건 보다 작을 시만 입찰 요청 건에 보이게 한다.
		if($s_ds_type == "D1"){	//딜러-관리자
		$sql = $sql. "	and s.cd_sale not in (select cd_sale from tender_master where ds_delind = 'N' and cd_dealer = '$s_cd_dealer' group by cd_sale)";	//본인 입찰 건 제외한 입찰 건
		}

	}else{
		if($ds_status == "F0"){	//입찰 중인 판매건
			$sql = $sql. "	and s.ds_status in ('E0','F0')";
			$sql = $sql. "	and s.cd_sale in (select cd_sale from tender_master where ds_delind = 'N' ".$sql_ds_type." group by cd_sale)";
		}else if($ds_status == "Z0"){	//낙찰된 판매건
			$sql = $sql. "	and s.ds_status in ('Z0')";
			$sql = $sql. "	and s.cd_sale in (select cd_sale from tender_master where ds_delind = 'N' and ds_status in ('Z0') ".$sql_ds_type." group by cd_sale)";
		}else if($ds_status == "ZS"){	//구매 확정된 판매건
//			$sql = $sql. "	and s.ds_status in ('Z0')";
//			$sql = $sql. "	and s.ds_status_contract in ('Z0')";
			$sql = $sql. "	and s.ds_status in ('ZS')";
			$sql = $sql. "	and s.cd_sale in (select cd_sale from tender_master where ds_delind = 'N' and ds_status in ('Z0') ".$sql_ds_type." group by cd_sale)";
		}else{
			$sql = $sql. "	and 1!=1 ";
		}
	}

	if($ds_status == "E0"){
		$nm_title = "입찰대기 리스트";
	}else if($ds_status == "F0"){
		$nm_title = "입찰중 리스트";
	}else if($ds_status == "Z0"){
		$nm_title = "낙찰 리스트";
	}else if($ds_status == "ZS"){
		$nm_title = "구매확정 리스트";
	}

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

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

<section id="wrap">
	<section id="visual" class="visual_mypage">
		<h2>마이페이지</h2>
		<p>쉽고 간편한 내차팔기, 견적산출, 최종 매각까지 어떤 수수료도 요구하지 않습니다.</p>
	</section>

	<section id="content">
		<ul class="location">
			<li><a href="/" class="home">홈</a></li>
			<li><span class="depth1">마이페이지</span>
				<ul class="sub_depth">
					<li><a href="#">마이페이지</a></li>
					<li><a href="#">입찰정보</a></li>
					<li><a href="#">차량정보</a></li>
					<li><a href="#">문의내역</a></li>
				</ul>
			</li>
			<li><span class="depth2">딜러</span></li>
		</ul>

<? include("./inc_menu_dealer.php") ?>

		<h3><?=$nm_title?></h3>
		<div class="select_sort">
			<span class="select">
				<select>
					<option value="">최근</option>
					<option value="">종료임박순</option>
					<option value="">응찰적은순</option>
				</select>
			</span>
		</div>
		<ul class="car_list ty2">
<?
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 case when 'E0' = '$ds_status' then '입찰대기' else '입찰중' end 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 
						, case when a.nm_act_yn in ('Y') then '유'  else '무' end as nm_act_yn_name 
						, getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_tender  
						, getRemainTime(".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell  
						, ifnull((select min(nm_price) from tender_master where ds_delind = 'N' and cd_sale = s.cd_sale ".$sql_ds_type."), '') nm_price_tender 
						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 $orderby LIMIT $pagestartpoint,$PageSize");

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

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

?>
<?
	if($col[ds_status_sale] == "ZS"){
?>
			<li onclick="location.href='./dealer_tender_view3.php?list_url=<?=$list_url?>&cd_sale=<?=$col[cd_sale]?>&ds_status_sale=<?=$col[ds_status_sale]?>&ds_status=<?=$ds_status?>&ListPageNo=<?=$PageNo?>';" style="cursor:pointer;">
<?
	}else if($col[ds_status_sale] == "Z0"){
?>
			<li onclick="location.href='./dealer_tender_view2.php?list_url=<?=$list_url?>&cd_sale=<?=$col[cd_sale]?>&ds_status_sale=<?=$col[ds_status_sale]?>&ds_status=<?=$ds_status?>&ListPageNo=<?=$PageNo?>';" style="cursor:pointer;">
<?
	}else{
?>
			<li onclick="location.href='./dealer_tender_view.php?list_url=<?=$list_url?>&cd_sale=<?=$col[cd_sale]?>&ds_status_sale=<?=$col[ds_status_sale]?>&ds_status=<?=$ds_status?>&ListPageNo=<?=$PageNo?>';" style="cursor:pointer;">
<?
	}
?>
				<span class="thumb"><img src="<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$col[nm_file_front]?>" alt=""></span>
				<dl>
					<dt><?=$col[nm_model]." ".$col[nm_model_sub]." ".$col[nm_grade]?></dt>
					<dd>주행거리 : <?=$col[nm_mileage]?>km</dd>
					<dd>최초등록일 : <?=$col[nm_regdate_mm]?> / <?=$col[nm_regdate_yyyy]?></dd>
					<dd>사고유무 : <?=$col[nm_act_yn_name]?></dd>
					<dd>판매지역 : <?=$col[nm_area]?></dd>
<?
	if($ds_status != "E0"){	//입찰하지 않은 판매건
?>
					<dd>입찰금액 : <?=$col[nm_price_tender]?>만원  </dd>
<?
	}
?>
				<? if($ds_status == "E0" || $ds_status == "F0"){ ?>
                    <dd>마감시간 : <?=$col[time_limit_tender]?></dd>
				<? } ?>
				</dl>
				<div class="flag">
				<? if($col[time_limit_sell]=="0분" && ($col[ds_status_sale] == "E0" || $col[ds_status_sale] == "F0")){ ?>
				거래마감
				<? }else{ ?>
				<?=$col[nm_status_sale]?>
				<? } ?>
				</div>
			</li>
<?
	$i++;
}
}else{
?>
			<li class="info_no">
				등록된 정보가 없습니다.
			</li>
<?
}
?>
		</ul>

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

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