echajoa/mypage/dealer.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'];

	$s_ds_usertype = $_SESSION['s_ds_usertype'];
	$s_ds_company_bp1 = $_SESSION['s_ds_company_bp1'];
	$s_ds_branch1 = $_SESSION['s_ds_branch1'];
	$s_ds_company_bp2 = $_SESSION['s_ds_company_bp2'];
	$s_ds_branch2 = $_SESSION['s_ds_branch2'];
	$s_ds_company_bp3 = $_SESSION['s_ds_company_bp3'];
	$s_ds_branch3 = $_SESSION['s_ds_branch3'];

	$PageSize=2; //목록개수설정
	$pagestartpoint=0;

	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' ";
	}

?>
<? 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>

		<!-- 2019-04-26 layer popup -->
		<div class="dealer_notice_popup">
			<div class="popup_wrap">
				<dl>
					<dt>딜러 패널티 부분 관련</dt>
					<dd>이에스모터스는 신뢰를 바탕으로 고객과 상사를<br>
					연결해주는 회사입니다. 정직하게 운영하는 상사와<br>
					고객과의 신뢰를 위하여 아래와 같은 패널티 제도를<br>
					운영하고 있습니다. 패널티 내용 숙지하여 주시기 바랍니다.
						<ol>
							<li>1. 경고 (3회 누적시 회사 심의 후 퇴출 결정, 최후 경고 후<br>6개월 내에 경고 없을시 초기화)
								<ol>
									<li>1) 거래 후 영업일 기준 2일이내 명의 이전을 하지 않은 경우</li>
									<li>2) 거래 후 영업일 기준 2일이내 성능지를 올리지 않은 경우</li>
									<li>3) 매매계약 진행시 24시간내여 연락이 안되는 경우</li>
									<li>4) 정당한 사유 없이 낙찰을 거부하는 경우</li>
									<li>5) 터무니 없는 금액으로 입찰하는 경우</li>
								</ol>
							</li>
							<li>2. 퇴출 (퇴출 사유 발생시 회사 심의 후 결정)
								<ol>
									<li>1) 고객, 관리자, 유프로 관련 진행 중 폭언, 욕설, 비난<br>
									등으로 물의를 빚는 경우</li>
									<li>2) 고객과 거래 진행시 감가사유가 아닌 것을 감가하는 경우</li>
									<li>3) 거래완료시 수수료를 횡령하기 위해 고객과 거래를<br>
									직접적으로 하는 경우</li>
									<li>4) 상대방에게 위압감을 주거나, 불량한 행동 및 언행으로<br>
									매매계약을 강요하는 경우</li>
									<li>5) 성능기록부를 조작하는 경우</li>
									<li>6) 기타 상사와 관계자 원칙에 위배된다고 판단되는 경우</li>
									<li>7) 상사와 단합하여 매입가격을 조정하는 경우</li>
								</ol>
							</li>
						</ol>
					</dd>
				</dl>
				<dl>
					<dt>수수료 변경</dt>
					<dd>
						<dl>
							<dt>변경 전</dt>
							<dd>
								<span>대당</span>
								<span>수수료(VAT포함)</span>
								<span>338,800</span>
							</dd>
							<dt>변경 후</dt>
							<dd>
								<table class="tbl_v">
									<colgroup>
										<col width="70%">
										<col width="*">
									</colgroup>
									<thead>
									<tr>
										<th>구간</th>
										<th>수수료<br>(VAT포함)</th>
									</tr>
									</thead>
									<tr>
										<td class="al">0 ~ 200만원 미만 낙찰</td>
										<td>55,000</td>
									</tr>
									<tr>
										<td class="al">200만원 ~ 500만원 미만 낙찰</td>
										<td>130,000</td>
									</tr>
									<tr>
										<td class="al">500만원 ~ 2000만원 미만 낙찰</td>
										<td>220,000</td>
									</tr>
									<tr>
										<td class="al">2000만원 ~ 3000만원 미만 낙찰</td>
										<td>270,000</td>
									</tr>
									<tr>
										<td class="al">3000만원 이상</td>
										<td>330,000</td>
									</tr>
								</table>
							</dd>
						</dl>
					</dd>
				</dl>
			</div>
			<div class="close" onclick="closeLayer('dealer_notice');">레이어팝업 닫기</div>
		</div>
			
		<div class="dim"></div>
		<!-- // 2019-04-26 layer popup -->

<? include("./inc_menu_dealer.php") ?>
		<div class="tit_wrap">
			<h3>입찰요청 리스트</h3>
			<a href="./dealer_tender_list.php?ds_status=E0" class="button">+더보기</a>
		</div>
		<table class="tbl_v">
			<colgroup>
				<col width="7%">
				<col width="10%">
				<col width="11%">
				<col width="*">
				<col width="13%">
				<col width="8%">
				<col width="11%">
				<col width="15%">
			</colgroup>
			<thead>
			<tr>
				<th>번호</th>
				<th>판매자</th>
				<th>지역</th>
				<th>차종</th>
				<th>주행거리</th>
				<th>년식</th>
				<th>등록일</th>
				<th>입찰 마감시간</th>
			</tr>
			</thead>
			<tbody>
<?

	$sql = "where s.ds_delind='N'";

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

	if($s_ds_usertype == "B0"){	//kcar 딜러
	$sql = $sql. "	and (
							(
							s.ds_company_bp = '$s_ds_company_bp1' and ds_branch = '$s_ds_branch1' 
							) 
							or (
							s.ds_company_bp = '$s_ds_company_bp2' and ds_branch = '$s_ds_branch2' 
							) 
							or (
							s.ds_company_bp = '$s_ds_company_bp3' and ds_branch = '$s_ds_branch3' 
							) 
		) ";
	}else{
	$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 
		) ";
	}

	$sql = $sql. "	and s.ds_status in ('E0','F0')";

	$sql = $sql. "	and s.dt_approve >=  DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_TENDER."' HOUR) ";

	$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)";	//본인 입찰 건 제외한 입찰 건
	}
/*	echo "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 
							, 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  
							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";
*/
	$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 
							, 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  
							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)) { 
?>
			<tr onclick="location.href='./dealer_tender_view.php?list_url=<?=$list_url?>&cd_sale=<?=$col[cd_sale]?>&cd_dealer=<?=$s_cd_dealer_p?>&ds_status=E0&ds_status_sale=<?=$col[ds_status_sale]?>&ListPageNo=<?=$PageNo?>';" style="cursor: pointer; cursor: hand;">
				<td><?=$i?></td>
				<td><?=$col[nm_name_sale]?></td>
				<td><?=$col[nm_area]?></td>
				<td><?=$col[nm_brand]." ".$col[nm_model]?></td>
				<td><?=$col[nm_mileage]?>km</td>
				<td><?=$col[ds_year]?></td>
				<td><?=$col[dt_insert]?></td>
				<td><em class="txt_bold"><?=$col[time_limit_tender]?></em></td>
			</tr>
<?
		$i++;
	}
?>
			</tbody>
		</table>

		<div class="tit_wrap">
			<h3>입찰중 리스트</h3>
			<a href="./dealer_tender_list.php?ds_status=F0" class="button">+더보기</a>
		</div>
		<table class="tbl_v">
			<colgroup>
				<col width="7%">
				<col width="10%">
				<col width="11%">
				<col width="*">
				<col width="13%">
				<col width="8%">
				<col width="11%">
				<col width="15%">
			</colgroup>
			<thead>
			<tr>
				<th>번호</th>
				<th>판매자</th>
				<th>지역</th>
				<th>차종</th>
				<th>주행거리</th>
				<th>년식</th>
				<th>등록일</th>
				<th>상태</th>
			</tr>
			</thead>
			<tbody>
<?

	$sql = "where s.ds_delind='N'";

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

	$sql = $sql. "	and s.ds_status in ('E0','F0')";

	$sql = $sql. "	and s.dt_approve >=  DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ";

	$sql = $sql. "	and s.cd_sale in (select cd_sale from tender_master where ds_delind = 'N' ".$sql_ds_type." group by cd_sale)";

	$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 
							, case when a.nm_act_yn in ('Y') then '유'  else '무' end as nm_act_yn_name 
							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)) { 
?>
			<tr onclick="location.href='./dealer_tender_view.php?list_url=<?=$list_url?>&cd_sale=<?=$col[cd_sale]?>&cd_dealer=<?=$s_cd_dealer_p?>&ds_status=F0&ds_status_sale=<?=$col[ds_status_sale]?>&ListPageNo=<?=$PageNo?>';" style="cursor: pointer; cursor: hand;">
				<td><?=$i?></td>
				<td><?=$col[nm_name_sale]?></td>
				<td><?=$col[nm_area]?></td>
				<td><?=$col[nm_brand]." ".$col[nm_model]?></td>
				<td><?=$col[nm_mileage]?>km</td>
				<td><?=$col[ds_year]?></td>
				<td><?=$col[dt_insert]?></td>
				<td><em class="txt_bold"><?=$col[nm_status_sale]?></em></td>
			</tr>
<?
		$i++;
	}
?>
			</tbody>
		</table>

<?
	$cd_board = "01";
	$ds_kind = $_SESSION['s_ds_kind'];

	if (empty($PageNo)) {$PageNo=1;}else{$PageNo=$PageNo;}
	$PageSize=2; //목록개수설정
	$pagestartpoint=($PageNo-1)*$PageSize;
	$sql = "where cd_board='$cd_board' and ds_delind='N'";
	$sql = $sql." and ds_kind='$ds_kind' ";

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

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

?>

		<div class="tit_wrap">
			<h3>공지사항</h3>
			<a href="/customer/notice_list.php?cd_board=<?=$cd_board?>&ds_kind=<?=$ds_kind?>" class="button">+더보기</a>
		</div>
		<table class="tbl_v">
			<colgroup>
				<col width="7%">
				<col width="*">
				<col width="15%">
			</colgroup>
			<thead>
			<tr>
				<th>번호</th>
				<th>제목</th>
				<th>등록일</th>
			</tr>
			</thead>
			<tbody>
<?
		if($totalrows>0) {
			$r = mysql_query("SELECT * FROM board_master  $sql ORDER BY ds_top desc, no_famally ASC, no_order ASC  LIMIT $pagestartpoint,$PageSize");

			$i=1;
			while($col = mysql_fetch_array($r)) { 
				$date = strtotime ($col[dt_insert]);
				$view_date = strtotime ("-1 day",time());
				if($date >= $view_date) {
					$newicon = " <img src='".ADMIN_PATH."img/i_new.gif' style='margin-top:1px;' /> ";
				} else { 
					$newicon = "";
				}

				if($col[no_step]>0){
					$padding = $col[no_step] * 8;
					$step = "<span style=\"padding-left:".$padding."px\"/>";
				}

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

?>
			<tr onclick="location.href='/customer/notice_view.php?cd_board=<?=$cd_board?>&ds_kind=<?=$ds_kind?>&cd_seq=<?=$col[cd_seq]?>&PageNo=<?=$PageNo?>';" style="cursor: pointer; cursor: hand;">
				<td><?=$no?></td>
				<td class="al"><?=text_cut($col[nm_title],50)?></td>
				<td><?=$col[dt_insert]?></td>
			</tr>
<?
				$i++;
			}
		}else{
?>
			<tr>
				<td colspan="3">등록된 정보가 없습니다.</td>
			</tr>
<?
		}
?>
			</tbody>
		</table>
	</section>
</section>

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