echajoa/m/sa/main.php

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

	$HEADER_LOC = 'main';

	$cd_user = $_SESSION['s_staff_user'];


	$pagestartpoint=($PageNo-1)*$PageSize;
	$sql.= " AND s.ds_delind='N' ";
	// echo $sql;
	$sql = $sql. "	and s.cd_user='$cd_user' ";

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

	$sql = $sql. "	and s.ds_type = 'A0' AND s.is_staff = 'Y' ";

	// $sql = $sql. "	and s.ds_status in ('B0','C0','D0','E0','F0','G0','Z0')";

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

	$totalrows = @mysql_fetch_array(mysql_query("SELECT
													ifnull(sum(case when s.ds_status = 'B0' or s.ds_status = 'C0' or s.ds_status = 'D0' then 1 else 0 end),0) D0_cnt
													, ifnull(sum(case when s.ds_status = 'Z0' then 1 else 0 end),0) Z0_cnt
													, ifnull(sum(case when s.ds_status = 'ZS' then 1 else 0 end),0) ZS_cnt
												FROM sale_master s
												INNER JOIN  car_master a on ( s.cd_car = a.cd_car )
													WHERE s.ds_delind = 'N'
												$sql"
											));

?>
<?php include("include/header.php") ?>
<style>
.swiper-slide .car--box--wrap .thumb--wrap img { max-width: 100%; }
</style>
<main class="pb123">
	<section>
		<div class="main--visual">
			<div class="main--visual--title--wrap">
				<h2>이차조아</h2>
				<p>
					이차조아에서는 사고 이력 조회 후 누구나 최고가로 내차를 판매할 수 있습니다.
				</p>

				<div class="main--visual--contents">
					<form name="searchForm" id="searchForm" method="POST" action="search_detail.php">
					<div class="car--find">
						<div style="border-right:0px!important;">
							<h2>소유주명</h2>
							<div><input type="text" class="form-control proprietor" id="req_nm_name" name="nm_name"></div>
						</div>
						<div>
							<h2>차량 번호</h2>
							<div><input type="text" class="form-control carnumber" id="req_nm_number" name="nm_number"></div>
						</div>
					</div>
					<button type="button" class="car--find--btn" id="btn_car_search">차량조회</button>
					</form>
				</div>
			</div>
		</div>
	</section>

	<section>
		<div class="car--list--wrap">
			<div class="title--wrapper">
				<h2>입찰 대기중 차량</h2>
			</div>
			<div class="swiper swp01">
				<ul class="swiper-wrapper">
				<?php
					$orderby = "order by s.dt_insert desc";

					$r = mysql_query("SELECT
									a.*
									, b.nm_model
									, d.nm_brand
									, 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.nm_price nm_price_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
									, getCode('car_master','ds_accident',a.ds_accident) as nm_act_yn_name
									-- , getRemainTime(".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell
									, getRemainTime(s.ds_auction_time, s.dt_approve, now()) as time_limit_sell
									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_brand d on (a.cd_brand = d.cd_brand)
										WHERE s.ds_delind = 'N'
										and s.ds_status in ('B0','C0','D0')
										$sql
										$orderby LIMIT 0,4");
					$i=1;


					while($col = mysql_fetch_array($r)) {
						$car_image = getCarBasicThumbImage($col['cd_car'], $col['nm_file_front'], '차량전면', false, 'car_basic');
						// $car_image = "/images/common/bg_no_photo.png";
						// if(file_exists($_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'])) {
						// 	$car_image = UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'];
						// }

				?>
					<li class="swiper-slide">
						<a href="standby_view.php?cd_sale=<?=$col['cd_sale']?>">
							<div class="car--box--wrap ">
								<h2 class="car--name"><?=$col['nm_brand']." ".$col['nm_model']?></h2>
								<div class="thumb--wrap">
									<?=$car_image?>
								</div>
								<div class="car--info">
									<dl>
										<dt>주행거리 : </dt>
										<dd><?=number_format($col['nm_mileage'])?>km</dd>
									</dl>
									<dl>
										<dt>최초 등록일 : </dt>
										<dd><?=$col['nm_regdate_mm']?> / <?=$col['nm_regdate_yyyy']?></dd>
									</dl>
									<dl>
										<dt>사고유무 : </dt>
										<dd><?=$col['nm_act_yn_name']?></dd>
									</dl>
									<dl>
										<dt>판매지역 : </dt>
										<dd><?=$col['nm_area']?></dd>
									</dl>
								</div>
								<div class="status--wrap">
								<?php if($col['ds_status_sale'] == 'D0') {?>
									<span>반려</span>
								<?php } else {?>
									<span class='ready'>대기중</span>
								<?php } ?>
								</div>
								<div class="btn--wrapper hide">
									<button type="button" onclick="link('standby_view.php?cd_sale=<?=$col['cd_sale']?>')">자동차 보러가기<i class="arrow--ic"></i></button>
								</div>
							</div>
						</a>
					</li>
				<?php
						$i++;
					}
				?>
				<?php
					if($i == 1) {
				?>
					<li class="">
						<dl class="inner">
							<dt>등록된 정보가 없습니다.</dt>
						</dl>
					</li>

				<?php
					}
				?>
				</ul>
			</div>

			<div class="pagination--wraps swp01"></div>
		</div>
	</section>

	<section>
		<div class="car--list--wrap">
			<div class="title--wrapper">
				<h2>입찰중 차량</h2>
			</div>
			<div class="swiper swp02">
				<ul class="swiper-wrapper">
				<?php
					$r = mysql_query("SELECT
									a.*
									, b.nm_model
									, d.nm_brand
									, 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.nm_price nm_price_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_SELL.", s.dt_approve, now()) as time_limit_sell
									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_brand d on (a.cd_brand = d.cd_brand)
									WHERE s.ds_delind = 'N'
										and s.ds_status in ('E0')
										$sql
										$orderby LIMIT 0,4");
					$i=1;
					while($col = mysql_fetch_array($r)) {
						$car_image = getCarBasicThumbImage($col['cd_car'], $col['nm_file_front'], '차량전면', false, 'car_basic');
						// $car_image = "/images/common/bg_no_photo.png";
						// if(file_exists($_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'])) {
						// 	$car_image = UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'];
						// }
				?>
					<li class="swiper-slide">
						<a href="prepare_view.php?cd_sale=<?=$col['cd_sale']?>">
							<div class="car--box--wrap ">
								<h2 class="car--name"><?=$col['nm_brand']." ".$col['nm_model']?></h2>
								<div class="thumb--wrap">
									<?=$car_image?>
								</div>
								<div class="car--info">
									<dl>
										<dt>주행거리 : </dt>
										<dd><?=number_format($col['nm_mileage'])?>km</dd>
									</dl>
									<dl>
										<dt>최초 등록일 : </dt>
										<dd><?=$col['nm_regdate_mm']?> / <?=$col['nm_regdate_yyyy']?></dd>
									</dl>
									<dl>
										<dt>사고유무 : </dt>
										<dd><?=$col['nm_act_yn_name']?></dd>
									</dl>
									<dl>
										<dt>판매지역 : </dt>
										<dd><?=$col['nm_area']?></dd>
									</dl>
								</div>
								<div class="status--wrap">
									<span>입찰중</span>
								</div>
								<div class="btn--wrapper hide">
									<button type="button" onclick="link('prepare_view.php?cd_sale=<?=$col['cd_sale']?>')">자동차 보러가기<i class="arrow--ic"></i></button>
								</div>
							</div>
						</a>
					</li>
				<?php
						$i++;
					}
				?>
				<?php
					if($i == 1) {
				?>
					<li class="">
						<dl class="inner">
							<dt>등록된 정보가 없습니다.</dt>
						</dl>
					</li>

				<?php
					}
				?>
				</ul>
			</div>
			<div class="pagination--wraps swp02"></div>

		</div>
	</section>
</main>

<script>
$(function() {
	$("#btn_car_search").on("click",function(){
		var custom_opts = {
			title : '',
			btn_close_show : false,
		}
<?php
if(empty($_SESSION['s_staff_userid'])){
?>
		custom_opts.title = "로그인 후 이용가능합니다.";
		custom_modal_alert(custom_opts, function() {
			link("login.php");
		});
		return false;
<?php } ?>
		var fieldlist = [["req_nm_name","소유주명"],["req_nm_number","차량 번호"]];
		//,["nm_hp1", "판매자 연락처"],["nm_hp2", "판매자 연락처"],["nm_hp3", "판매자 연락처"]];
		//

		if (!fnCheckForm(fieldlist)){
			return false;
		}

		$("#searchForm").submit();

	});

	//모바일이라 hover를 어떻게 처리할지 몰라 주석처리

	// $(".car--list--wrap li").hover(function() {
	// 	$(this).find(".car--box--wrap").addClass("on");
	// 	$(this).find(".status--wrap").addClass("hide");
	// 	$(this).find(".btn--wrapper").removeClass("hide");
	//
	// }, function() {
	// 	$(this).find(".car--box--wrap").removeClass("on");
	// 	$(this).find(".status--wrap").removeClass("hide");
	// 	$(this).find(".btn--wrapper").addClass("hide");
	// });
})

</script>

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