echajoa/manage/buy/underway_list.php.bak

<?php

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

	$list_url = "underway_list.php";
//	$mp = "34";	//set top nav
	$mp = "33";	//set top nav	20190805

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

	$pagestartpoint=($PageNo-1)*$PageSize;
	$add_sql = "where s.ds_delind='N'";
	// $orderby = "order by s.dt_insert desc";
	if(empty($PageSort)) {
		$orderby = "order by s.dt_update desc";
	}else {
		$sort = explode("|", $PageSort);
		$orderby = "order by $sort[0] $sort[1] ";
	}

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

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

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

	if($dt_start != "" && $dt_end != ""){
		$add_sql.= " and s.dt_success between '$dt_start' and '$dt_end' ";
	}

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

	$add_sql.= " and s.ds_status in ('Z0') and (s.ds_status_contract is null or s.ds_status_contract = '' or s.ds_status_contract = 'Z0') and s.ds_status_contract_step1 = 'Y' ";

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//관계사/지점 Setting
	$admin_ds_company_bp	= $_SESSION['admin_ds_company_bp'];	//관계사
	$admin_ds_branch		= $_SESSION['admin_ds_branch'];		//지점
	$admin_bp_ok			= ($admin_ds_company_bp != "" || $admin_ds_branch != "") ? true : false;	//admin_ds_company_bp 나 admin_ds_branch 값이 하나라도 있으면 관계사로 보고 권한 제한한다. $admin_bp_ok == true 이면 해당 관계사/지점 데이타만 확인 가능하다.

//관계사 일 경우 해당 관계사/지점 데이타만 확인 가능하다.
	// if($admin_bp_ok){
	// 	if($admin_ds_company_bp != "" && $admin_ds_branch != ""){
	// 		$add_sql.= "	and s.ds_company_bp = '$admin_ds_company_bp' and s.ds_branch = '$admin_ds_branch' ";
	// 	}else{	//admin_ds_company_bp 나 admin_ds_branch 값이 하나라도 없으면 데이타 확인 안되게 한다.
	// 		$add_sql.= "	and 1 = 2 ";
	// 	}
	// }
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

	$sql = "select count(*)
				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)
				$add_sql";
	$totalrows = @mysql_result(mysql_query($sql),0,0);

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

<section id="contents">
	<h2>진행중 리스트</h2>

<form id="frmSearch" name="frmSearch" method="post">
<input type="hidden" id="PageSort" name="PageSort">
<input type="hidden" id="PageSize" name="PageSize">
<input type="hidden" id="searchtype" name="searchtype" value="<?=$searchtype?>">
	<table class="tbl_search">
		<colgroup>
			<col width="10%">
			<col width="*">
		</colgroup>
		<tr>
			<th>검색어</th>
			<td>
				<span class="select2" style="margin-right:5px;width:100px;" id="sel_searchtype">
					<select>
						<option value="">전체</option>
						<option value="s.nm_name"<? if($searchtype =="s.nm_name"){?> selected<?}?>>판매자</option>
						<option value="a.nm_number"<? if($searchtype =="a.nm_number"){?> selected<?}?>>차량번호</option>
						<option value="d.nm_brand"<? if($searchtype =="d.nm_brand"){?> selected<?}?>>제조사</option>
						<option value="b.nm_model"<? if($searchtype =="b.nm_model"){?> selected<?}?>>모델명</option>
						<option value="a.nm_color"<? if($searchtype =="a.nm_color"){?> selected<?}?>>색상</option>
					</select>
				</span>
				<input type="text" id="searchword" name="searchword" class="inp_txt" style="width:60%;" value="<?=$searchword?>">
			</td>
		</tr>
		<tr>
			<th>기간검색</th>
			<td>
				<!--span class="select2" style="margin-right:5px;width:100px;">
					<select>
						<option value=""></option>
					</select>
				</span-->
				<input type="text" class="inp_txt" style="width:30%;" id="dt_start" name="dt_start" value="<?=$dt_start?>">
				<span class="btn_cal" id="btn_cal1">달력보기</span>
				~
				<input type="text" class="inp_txt" style="width:30%;" id="dt_end" name="dt_end" value="<?=$dt_end?>">
				<span class="btn_cal" id="btn_cal2">달력보기</span>
				<div class="sel_period">
					<span onclick="setSearchDate('day',0)">오늘</span>
					<span onclick="setSearchDate('day',-7)">7일</span>
					<span onclick="setSearchDate('day',-15)">15일</span>
					<span onclick="setSearchDate('month',-1)">1개월</span>
					<span onclick="setSearchDate('month',-3)">3개월</span>
					<span onclick="setSearchDate('year',-1)">1년</span>
				</div>
				<input type="submit" class="rnd_btn ty3 gray" value="검색" title="검색">
				<div class="btn_right" style="margin-top:-28px">
					<a href="javascript:;" id="btn_download_excel" class="rnd_btn black" style='width:110px;'>엑셀 다운로드</a>
				</div>
			</td>
		</tr>
	</table>
</form>

	<div class="select_view_type">
		<span class="select" style="width:160px;" id="selSort">
			<select id="page_sort">
				<option value=""<? if($PageSort==""){ ?> selected<? } ?>>정렬</option>
				<!-- <option value="s.dt_update|asc"<? if($PageSort=="s.dt_update|asc"){ ?> selected<? } ?>>수정일자 ↑</option>
				<option value="s.dt_update|desc"<? if($PageSort=="s.dt_update|desc"){ ?> selected<? } ?>>수정일자 ↓</option>
				<option value="s.dt_insert|asc"<? if($PageSort=="s.dt_insert|asc"){ ?> selected<? } ?>>등록일자 ↑</option>
				<option value="s.dt_insert|desc"<? if($PageSort=="s.dt_insert|desc"){ ?> selected<? } ?>>등록일자 ↓</option> -->
				<option value="s.dt_insert|asc"<? if($PageSort=="s.dt_insert|asc"){ ?> selected<? } ?>>등록일 높은순</option>
				<option value="s.dt_insert|desc"<? if($PageSort=="s.dt_insert|desc"){ ?> selected<? } ?>>등록일 낮은순</option>
				<option value="s.dt_success|asc"<? if($PageSort=="s.dt_success|asc"){ ?> selected<? } ?>>낙찰일 높은순</option>
				<option value="s.dt_success|desc"<? if($PageSort=="s.dt_success|desc"){ ?> selected<? } ?>>낙찰일 낮은순</option>
			</select>
		</span>
	</div>

	<div class="tbl_wrap">
		<table class="tbl_list ty2">
			<colgroup>
				<col width="7%">
				<col width="10%">
				<col width="*">
				<col width="11%">
				<col width="8%">
				<col width="10%">
				<col width="11%">
				<col width="11%">
				<col width="9%">
			</colgroup>
			<thead>
			<tr>
				<th>번호</th>
				<th>판매자</th>
				<th>차종</th>
				<th>차량번호</th>
				<th>판매지역</th>
				<th>단계</th>
				<!--th>낙찰금액</th-->
				<!--th>낙찰업체</th-->

				<th>등록일</th>
				<th>낙찰일</th>
				<th>SMS상태</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.nm_price nm_price_sale
// 						, s.nm_price_final nm_price_final_sale
// 						, s.nm_recommend nm_recommend_sale
// 						, s.ds_status ds_status_sale
// 						, s.ds_status_contract ds_status_contract_sale
// 						, s.ds_status_contract_step1 ds_status_contract_step1_sale
//						, s.ds_status_contract_step2 ds_status_contract_step2_sale
//						, s.ds_status_contract_step3 ds_status_contract_step3_sale
//						, s.ds_status_contract_step4 ds_status_contract_step4_sale
// 						, f.ds_underway_depth ds_underway_depth
// 						, f.cd_tender cd_tender
// 						, f.ds_lock_status ds_lock_status
// 						, s.dt_update dt_update_sale
// 						, s.dt_insert dt_insert_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)
// 							left outer join tender_master f on (s.cd_sale = f.cd_sale and f.ds_status = 'Z0' and f.ds_delind = 'N')
// 							$sql $orderby LIMIT $pagestartpoint,$PageSize");


$sql = "SELECT *
			, getCode('car_master','ds_type',ds_type) as nm_type
			, getCode('car_master','ds_open',ds_open) as nm_open
			, getCode('car_master','ds_sales',ds_sales) as nm_sales
			, getCode('car_master','ds_transmission',ds_transmission) as nm_transmission
			, getCode('member_master','ds_area',ds_area_sale) as nm_area
			, getCode('sale_master','ds_status',ds_status_sale) as nm_status
			FROM (
					SELECT
						a.*
						, b.nm_model
						, c.nm_grade
						, d.nm_brand
						, e.nm_model_sub
						, s.cd_sale
						, s.nm_name nm_name_sale
						, s.nm_recommend nm_recommend_sale
						, s.ds_status ds_status_sale
						, s.ds_status_contract ds_status_contract_sale
						, s.ds_area ds_area_sale
						, s.dt_update dt_update_sale
						, s.dt_insert dt_insert_sale
						, s.dt_success dt_success_sale
						, s.nm_price nm_price_sale
						, s.nm_price_final nm_price_final_sale
						, s.ds_status_contract_step1 ds_status_contract_step1_sale
						, s.ds_status_contract_step2 ds_status_contract_step2_sale
						, s.ds_status_contract_step3 ds_status_contract_step3_sale
						, s.ds_status_contract_step4 ds_status_contract_step4_sale
						, f.ds_complete_depth ds_complete_depth
						, f.cd_tender cd_tender
						, f.ds_underway_depth ds_underway_depth
						, f.ds_lock_status ds_lock_status
						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)
							left outer join tender_master f on (s.cd_sale = f.cd_sale and f.ds_status = 'Z0' and f.ds_delind = 'N')
							$add_sql $orderby LIMIT $pagestartpoint,$PageSize
			) as car
";

$r = mysql_query($sql);

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

	$tmpNum =$totalrows-($PageSize*($PageNo-1));
	$no = ($tmpNum - $i)+1;
	//단계 추가
	$step = "";
	if($col['ds_status_contract_step4_sale'] == "Y") {
		$step = "거래마무리";
	}else if($col['ds_status_contract_step3_sale'] == "Y") {
		$step = "계약상황";
	}else if($col['ds_status_contract_step2_sale'] == "Y") {
		$step = "일정잡기";
	}else if($col['ds_status_contract_step1_sale'] == "Y") {
		$step = "차량정보확인";
	}


	//SMS 상태
	$sms_class = "";
	$clear_btn = "";
	$ds_underway_depth = "";
	switch($col['ds_underway_depth']) {
		case '0':
			$sms_class = "sms_send";			//미발송일 경우에만 클래스 지정으로 발송할 수 있게 처리
			$ds_underway_depth = "미발송";
			break;
		case '1':
		case '2':
		case '3':
			$ds_underway_depth = $col['ds_underway_depth']."단계";
			break;
	}
	if($col['ds_underway_depth'] == 3 && $col['ds_lock_status'] == 'A0') {
		$sms_class = "sms_unlock";
		$clear_btn = "<input type='button' class='rnd_btn ty3 gray btn_clear' value='해제' title='해제' style='width:42px;' cd_tender='$col[cd_tender]'>";
	}

?>

			<!-- <tr onclick="location.href='./buy_view.php?list_url=<?=$list_url?>&cd_sale=<?=$col['cd_sale']?>&ds_status_sale=<?=$col['ds_status_sale']?>&ds_status_contract_sale=<?=$col['ds_status_contract_sale']?>&ds_status_contract_step1_sale=<?=$col['ds_status_contract_step1_sale']?>&ListPageNo=<?=$PageNo?>';" style="cursor:pointer;"> -->
			<tr cd_sale='<?=$col['cd_sale']?>' cd_tender='<?=$col['cd_tender']?>' uri='./buy_view.php?list_url=<?=$list_url?>&cd_sale=<?=$col['cd_sale']?>&ds_status_sale=<?=$col['ds_status_sale']?>&ds_status_contract_sale=<?=$col['ds_status_contract_sale']?>&ds_status_contract_step1_sale=<?=$col['ds_status_contract_step1_sale']?>&ListPageNo=<?=$PageNo?>' _onclick="location.href=;" 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_area']?></td>
				<td><?=$step?></td>
				<!--td><?=$col['nm_price_final_sale']?></td-->
				<td><?=$col['dt_insert_sale']?></td>
				<td><?=$col['dt_success_sale']?></td>
				<td class='<?=$sms_class?>'><?=$ds_underway_depth?> <?=$clear_btn?></td>
			</tr>
<?
	$i++;
}
}else{
?>
			<tr>
				<td colspan="9">등록된 정보가 없습니다.</td>
			</tr>
<?
}
?>
		</table>
	</div>

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

	<!-- layer popup1 -->
	<div class="layer_popup sms_send_popup">
		<form id="frmFormSmsSend" name="frmFormSmsSend" method="post" enctype="multipart/form-data">
			<input type="hidden" name="cd_sale" value="">
			<input type="hidden" name="cd_tender" value="">
			<div class="popup_wrap" style='width: 280px;height: 120px;'>
				<h4 style='padding:40px 0 20px 0;'>SMS를 발송하시겠습니까?</h4>
				<div class="btn_center">
					<a href="#" class="rnd_btn ty3 gray" onclick="closeLayer('sms_send'); return false;">취소</a>
					<a href="#" class="rnd_btn ty3 black" id="btn_sms_send">확인</a>
				</div>
			</div>
		</form>
		<div class="close">레이어팝업 닫기</div>
	</div>
	<!-- // layer popup1 -->

	<!-- layer popup1 -->
	<div class="layer_popup sms_unlock_popup">
		<form id="frmFormSmsUnlock" name="frmFormSmsUnlock" method="post" enctype="multipart/form-data">
			<input type="hidden" name="cd_sale" value="">
			<input type="hidden" name="cd_tender" value="">
		<div class="popup_wrap" style='width: 280px;height: 120px;'>
			<h4 style='padding:40px 0 20px 0;'>해제 하시겠습니까?</h4>
			<div class="btn_center">
				<a href="#" class="rnd_btn ty3 gray" onclick="closeLayer('sms_unlock'); return false;">취소</a>
				<a href="#" class="rnd_btn ty3 black" id="btn_sms_unlock">확인</a>
			</div>
		</div>
		</form>
		<div class="close">레이어팝업 닫기</div>
	</div>
	<!-- // layer popup1 -->

</section>

<form name="excelForm" id="excelForm" method="GET">
	<input type="hidden" name="searchtype" value="<?=$searchtype?>">
	<input type="hidden" name="searchword" value="<?=$searchword?>">
	<input type="hidden" name="ds_usertype" value="<?=$ds_usertype?>">
	<input type="hidden" name="dt_start" value="<?=$dt_start?>">
	<input type="hidden" name="dt_end" value="<?=$dt_end?>">
</form>

<script language="javascript" type="text/javascript">

	$("#dt_start").datepicker({ dateFormat: 'yy-mm-dd' });
	$("#dt_end").datepicker({ dateFormat: 'yy-mm-dd' });

	function setSearchDate(arg1, arg2){
		var dtStart = getSearchDate(arg1, arg2);
		var dtEnd = getSearchDate("day", 0);

		$("#dt_start").val(dtStart);
		$("#dt_end").val(dtEnd);
	}

	$(document).ready(function() {

		//tr 에 걸려 있던 클릭을 SMS 상태 추가로 스트립트단으로 이동
		$(".tbl_wrap td").on("click", function() {
			var cd_sale = $(this).closest("tr").attr("cd_sale");
			var cd_tender = $(this).closest("tr").attr("cd_tender");
			if($(this).hasClass('sms_send')) {
				$("#frmFormSmsSend input[name=cd_sale]").val(cd_sale);
				$("#frmFormSmsSend input[name=cd_tender]").val(cd_tender);
				openLayer('sms_send');

			}else if($(this).hasClass('sms_unlock')) {
				$("#frmFormSmsUnlock input[name=cd_sale]").val(cd_sale);
				$("#frmFormSmsUnlock input[name=cd_tender]").val(cd_tender);
				openLayer('sms_unlock');

			}else {
				var uri = $(this).closest("tr").attr("uri");
				if(typeof uri != "undefined") {
					window.location.href = uri;
				}
			}
		});

		//SMS 발송 처리
		$("#btn_sms_send").on("click", function() {

			var arg_cd_sale = $("#frmFormSmsSend input[name=cd_sale]").val();
			var arg_cd_tender = $("#frmFormSmsSend input[name=cd_tender]").val();

			$.post("proc.php", { mode:"tenderSmsSend", ds_status: 'Z1', cd_sale: arg_cd_sale, cd_tender: arg_cd_tender},function(res) {
				var custom_opts = {
					title : '',
					btn_close_show : false,
				}

				if(res.CODE != "0000") {
					switch(""+res.CODE) {
						case "5555":
							custom_opts.title = '이미 SMS 1차 발송된 상태입니다. 2~3차는 자동발송됩니다.';

							custom_modal_alert(custom_opts, function() {
								reload();
							});
							break;
						default:
							custom_opts.title = '정상적으로 처리되지 않았습니다.';

							custom_modal_alert(custom_opts);
							break;
					}

					return false;
				}

				custom_opts.title = '정상적으로 처리되었습니다.';

				custom_modal_alert(custom_opts, function() {
					reload();
				});

				return false;

				//
				// if(data=="Y"){
				// 	custom_opts.title = '정상적으로 처리되었습니다.';
				//
				// 	custom_modal_alert(custom_opts, function() {
				// 		reload();
				// 	});
				//
				// 	return false;
				//
				// 	// alert("정상적으로 처리되었습니다.");
				// 	// window.location.reload();
				// 	return;
				// }else if(data=="E"){
				// 	custom_opts.title = '이미 SMS 1차 발송된 상태입니다. 2~3차는 자동발송됩니다.';
				//
				// 	custom_modal_alert(custom_opts, function() {
				// 		reload();
				// 	});
				//
				// 	return false;
				//
				// 	// window.location.reload();
				// 	return;
				// }else{
				// 	custom_opts.title = '정상적으로 처리되지 않았습니다.';
				//
				// 	custom_modal_alert(custom_opts);
				// 	return false;
				// }
			}, "json");
		});
		//차량 락 해제
		$("#btn_sms_unlock").on("click", function() {

			var arg_cd_sale = $("#frmFormSmsUnlock input[name=cd_sale]").val();
			var arg_cd_tender = $("#frmFormSmsUnlock input[name=cd_tender]").val();

			$.post("proc.php", { mode:"tenderSmsUnlock", cd_tender: arg_cd_tender},function(res) {

				var custom_opts = {
					title : '',
					btn_close_show : false,
				}

				if(res.CODE != "0000") {
					switch(""+res.CODE) {
						case "5555":
							custom_opts.title = '이미 해제된 건입니다.';

							custom_modal_alert(custom_opts, function() {
								reload();
							});
							break;
						default:
							custom_opts.title = '정상적으로 처리되지 않았습니다.';

							custom_modal_alert(custom_opts);
							break;
					}

					return false;
				}

				custom_opts.title = '정상적으로 처리되었습니다.';

				custom_modal_alert(custom_opts, function() {
					reload();
				});

				return false;

				// if(data=="Y"){
				// 	alert("정상적으로 처리되었습니다.");
				// 	window.location.reload();
				// 	return;
				// }else if(data=="E"){
				// 	alert("이미 해제된 건입니다.");
				// 	window.location.reload();
				// 	return;
				// }else{
				// 	alert("정상적으로 처리되지 않았습니다.");
				// 	return;
				// }
			}, "json");
		});

		$("#selSort div.jq_sel ul li a").bind("click",function(){
//			alert(this.value);
//			$("#PageSort").val(this.value);
			$("#PageSort").val($("#selSort option:selected").val());

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

		});
		$("#btn_cal1").bind("click",function(){
			$("#dt_start").datepicker('show');
		});

		$("#btn_cal2").bind("click",function(){
			$("#dt_end").datepicker('show');
		});
		$("#sel_searchtype div.jq_sel ul li a").bind("click",function(){
			$("#searchtype").val($("#sel_searchtype option:selected").val());

		});

		$("#btn_download_excel").click(function(e) {
			var url = "underway_list_excel.php?"+$("#excelForm").serialize();
			window.open(url, "excelWin");
		});
	});


	function fnSearch(){
		if($("#searchtype").val()!="" && $("#searchword").val()==""){
			alert("검색어를 입력하세요");
			return false;
		}
		$("#frmSearch").submit();
	}

</script>


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