echajoa/sa/main.php

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


	$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") ?>

<main class="pb-5">
	<section>
		<div class="main--visual">
			<div class="main--visual--title--wrap">
				<h2><!--이차조아 소개 카피라이터 부분입니다--></h2>
				<p>
			<!--		이차조아 소개글 상세 내용입니다. 이차조아 소개글 상세 내용입니다.<br/>이차조아 소개글 상세 내용입니다. 이차조아 소개글 상세 내용입니다.-->
				</p>

				<div class="main--visual--contents">

					<div class="box--01">
						<h2>거래중</h2>
						<div><?=number_format($totalrows['Z0_cnt'])?></div>
					</div>

					<div class="box--02">
						<h2>판매완료</h2>
						<div><?=number_format($totalrows['ZS_cnt'])?></div>
					</div>
					<form name="searchForm" id="searchForm" method="POST" action="search_detail.php">
					<div class="car--find">

						<div>
							<h2>소유주명 또는 담당SA명</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>
						<button type="button" class="car--find--btn" id="btn_car_search">차량조회<i class="zoom--icon"></i></button>

					</div>
					</form>

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

	<section>
		<div class="car--list--wrap">
			<div class="title--wrapper">
				<h2>입찰 대기중 차량</h2>
				<button type="button" class="more--btn" onclick="link('standby_list.php')">more+</button>
			</div>
			<ul>
		<?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="">
				<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="info_no" style="width: 100%;text-align: center; ">
				<dl class="inner">
					<dt>등록된 정보가 없습니다.</dt>
				</dl>
			</li>

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

	<section>
		<div class="car--list--wrap vertical--type">
			<div class="title--wrapper">
				<h2>입찰중 차량</h2>
				<button type="button" class="more--btn" onclick="link('prepare_list.php')">more+</button>
			</div>
			<ul>
			<?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="">
					<a href="prepare_view.php?cd_sale=<?=$col['cd_sale']?>">
					<div class="car--box--wrap ">
						<div class="thumb--wrap">
							<?=$car_image?>
						</div>
						<div>
							<div class="car--info">
								<h2 class="car--name"><?=$col['nm_brand']." ".$col['nm_model']?></h2>
								<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>

					</div>
					</a>
				</li>
			<?php
					$i++;
				}
			?>
			<?php
				if($i == 1) {
			?>
				<li class="info_no" style="width: 100%;text-align: center; ">
					<dl class="inner">
						<dt>등록된 정보가 없습니다.</dt>
					</dl>
				</li>

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

<script>
$(function() {
	$("#btn_car_search").on("click",function(){
		var custom_opts = {
			title : '',
			btn_close_show : false,
		}

		var fieldlist = [["req_nm_name","소유주명"],["req_nm_number","차량 번호"]];
		//,["nm_hp1", "판매자 연락처"],["nm_hp2", "판매자 연락처"],["nm_hp3", "판매자 연락처"]];
		//

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

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

	});

	$(".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") ?>