echajoa/manage/buy/inc_ViewSuccess.php

<?
	$cd_sale = $_REQUEST["cd_sale"];

	// $sql = "SELECT
	// 			t.*
	// 			, d.nm_name nm_name_dealer_p
	// 			, d.nm_zip nm_zip_dealer_p
	// 			, d.nm_addr nm_addr_dealer_p
	// 			, d.nm_addr_sub nm_addr_sub_dealer_p
	// 			, d.nm_area nm_area_dealer_p
	// 			, p.nm_name nm_name_dealer
	// 			, concat_ws('-',concat_ws('-',p.nm_hp_01,p.nm_hp_02),p.nm_hp_03) nm_hp_dealer
	// 			, p.nm_file nm_file_dealer
	// 			, s.nm_file_trading
	// 			, s.nm_file_performance
	// 			, report.cd_dealer_p_min
	// 			, report.cd_dealer_p_max
	// 			, report.nm_price_min
	// 			, report.nm_price_max
	// 			, report.nm_price_avg
	// 			, report.nm_name_min
	// 			, report.nm_name_max
	// 			, report.cnt
	// 		FROM tender_master t
	// 			inner join dealer_master d
	// 			on (t.cd_dealer_p = d.cd_dealer
	// 				and t.cd_sale = '$cd_sale'
	// 				and t.ds_delind = 'N'
	// 				and t.ds_status = 'Z0'
	// 			)
	// 			inner join dealer_master p on (t.cd_dealer = p.cd_dealer)
	// 			inner join sale_master s on (t.cd_sale = s.cd_sale )
	// 			inner join (
	// 				select
	// 				ff.cd_sale
	// 				, ff.cd_dealer_p_min
	// 				, ff.cd_dealer_p_max
	// 				, ff.nm_price_min
	// 				, ff.nm_price_max
	// 				, ff.nm_price_avg
	// 				, ff.cnt
	// 				, d1.nm_name nm_name_min
	// 				, d2.nm_name nm_name_max
	// 				from (
	// 					select
	// 						max(cc.cd_sale) cd_sale
	// 						, max(cc.cd_dealer_p_min) cd_dealer_p_min
	// 						, max(cc.cd_dealer_p_max) cd_dealer_p_max
	// 						, max(cc.nm_price_min) nm_price_min
	// 						, max(cc.nm_price_max) nm_price_max
	// 						, max(cc.nm_price_avg) nm_price_avg
	// 						, max(cc.cnt) cnt
	// 					from (
	// 						select
	// 							aa.cd_sale
	// 							, case when aa.nm_price = bb.nm_price_min then aa.cd_dealer_p else 0 end cd_dealer_p_min
	// 							, case when aa.nm_price = bb.nm_price_max then aa.cd_dealer_p else 0 end cd_dealer_p_max
	// 							, bb.nm_price_min
	// 							, bb.nm_price_max
	// 							, bb.nm_price_avg
	// 							, bb.cnt
	// 						from (select * from tender_master where cd_sale = '$cd_sale' and ds_delind = 'N') aa
	// 						, (
	// 						select
	// 							min(nm_price) nm_price_min
	// 							, max(nm_price) nm_price_max
	// 							, round(avg(nm_price)) nm_price_avg
	// 							, count(*) cnt
	// 						from tender_master
	// 						where cd_sale = '$cd_sale' and ds_delind = 'N'
	// 						) bb
	// 					) cc
	// 				) ff
	// 				inner join dealer_master d1
	// 				on (ff.cd_dealer_p_min = d1.cd_dealer)
	// 				inner join dealer_master d2
	// 				on (ff.cd_dealer_p_max = d2.cd_dealer)
	// 			) report
	// 			on (t.cd_sale = report.cd_sale
	// 			) ";

	$price_sql ="select count(*) cnt
					, min(nm_price) min_price
					, avg(nm_price) avg_price
					, max(nm_price) max_price
					, max(case when ds_status = 'Z0' then nm_price else 0 end) tender_price
	 			from tender_master where cd_sale = $cd_sale ";
	// echo $price_sql;
	$price_col = mysql_fetch_array(mysql_query($price_sql));

	$teder_success_sql = "SELECT t.*
							, a.nm_name nm_name_company
							FROM tender_master t
							INNER JOIN aap_master a on t.cd_dealer_p = a.cd_dealer
							WHERE t.cd_sale = '$cd_sale'
								AND t.ds_status = 'Z0'
								AND t.ds_delind = 'N'
						LIMIT 1
	";
	// echo $teder_success_sql;
	// exit;
	$col=mysql_fetch_array(mysql_query($teder_success_sql));
	if (!empty($col['cd_sale'])){

		$cd_sale 				= $col['cd_sale'];
		$nm_price 				= $col['nm_price'];
		$nm_commission 			= $col['nm_commission'];
		// $nm_file_trading 		= $col['nm_file_trading'];
		// $nm_file_performance 	= $col['nm_file_performance'];
		//
		// $nm_name_dealer_p 		= $col['nm_name_dealer_p'];
		// $nm_zip_dealer_p 		= $col['nm_zip_dealer_p'];
		// $nm_addr_dealer_p 		= $col['nm_addr_dealer_p'];
		// $nm_addr_sub_dealer_p 	= $col['nm_addr_sub_dealer_p'];
		// $nm_area_dealer_p 		= $col['nm_area_dealer_p'];
		$nm_name_company 			= $col['nm_name_company'];
		$nm_tender_name 			= $col['nm_name'];
		$nm_hp 						= $col['nm_hp'];
		$cd_tender_success 			= $col['cd_tender'];
		// $nm_hp_dealer 			= $col['nm_hp_dealer'];
		// $nm_file_dealer 		= $col['nm_file_dealer'];
		// $cd_dealer_p_min 		= $col['cd_dealer_p_min'];
		// $cd_dealer_p_max 		= $col['cd_dealer_p_max'];
		// $nm_price_min 			= $col['nm_price_min'];
		// $nm_price_max 			= $col['nm_price_max'];
		// $nm_price_avg 			= $col['nm_price_avg'];
		// $nm_name_min 			= $col['nm_name_min'];
		// $nm_name_max 			= $col['nm_name_max'];
		// $cnt 					= $col['cnt'];

/*
		$arr_nm_info1 = explode("-",$nm_info1);
		if(count($arr_nm_info1) == 3){
			$nm_info11 = $arr_nm_info1[0];
			$nm_info12 = $arr_nm_info1[1];
			$nm_info13 = $arr_nm_info1[2];
		}else{
			$nm_info11 = "";
			$nm_info12 = "";
			$nm_info13 = "";
		}

		$arr_nm_info3 = explode("@",$nm_info3);
		if(count($arr_nm_info3) == 2){
			$nm_info31 = $arr_nm_info3[0];
			$nm_info32 = $arr_nm_info3[1];
		}else{
			$nm_info31 = "";
			$nm_info32 = "";
		}
		$nm_info3 = $col[nm_info3];
*/

	}else{
//			AlertBack("지정되지않은 요청입니다");
	}

?>

	<!-- <ul class="tender_info">
		<li>
			<span>입찰자 수<em><?=$cnt?>곳</em></span>
		</li>
		<li>
			<span>최고가 업체<em><?=$nm_name_max?> <?=$nm_price_max?>만원</em></span>
			<span>최저가 업체<em><?=$nm_name_min?> <?=$nm_price_min?>만원</em></span>
		</li>
		<li>
			<span>평균입찰가<em><?=$nm_price_avg?>만원</em></span>
		</li>
	</ul> -->

	<h3><em>▶</em> 낙찰업체</h3>
	<div class="bid">
		<!-- <p class="name"><?=$nm_name_dealer_p?></p> -->
		<div class="info" style='padding-left:0px; '>
			<!-- <span class="thumb"><img src="<?=UPLOAD_PATH?>dealer/nm_file/<?=$nm_file_dealer?>"></span> -->
			<ul>
				<li><em>낙찰 업체</em>&nbsp;<?=$nm_name_company?></li>
				<!-- <li><em>주소</em>&nbsp;<?=$nm_addr_dealer_p." ".$nm_addr_sub_dealer_p?></li> -->
				<li><em>낙찰 담당자</em>&nbsp;<?=$nm_tender_name?></li>
				<li><em>연락처</em>&nbsp;<?=$nm_hp?></li>
				<!-- <li><em>매입지역</em>
			<?php
				$sql = "SELECT cd_seq as seq, nm_code as code , nm_name as name , nm_pcode as pcode , nm_etc_01 as etc
						 FROM  code_master WHERE  nm_table ='member_master' AND nm_column='ds_area' and  ds_delind = 'N' order by name ";

				$rows = mysql_query($sql);

				$i=1;
				while($row = mysql_fetch_array($rows)) {
			?>
			<?php if(strpos($nm_area_dealer_p,$row['code']) !== false){?>
				&nbsp;<?=$row['name']?>
			<?}?>
			<?php
					$i++;
				}
			?>
				</li> -->
			</ul>
			<!-- <p class="price">낙찰금액 :&nbsp;<em><?=number_format($nm_price)?>만원</em><? if($ds_status_sale == "ZE"){ ?><br>견적실수<? } ?></p> -->
			<p class="price">낙찰금액 :&nbsp;<em><?=number_format($nm_price)?>만원, 수수료: <?=number_format($nm_commission)?>만원</em><? if($ds_status_sale == "ZE"){ ?><br>견적실수<? } ?></p>
		</div>
		<!-- <div class="info">
	<? if($nm_file_trading != ""){ ?>
			<span class="thumb">상사이전등록증 <img src="<?=UPLOAD_PATH?>dealer/contract_step/<?=$cd_sale?>_detail/<?=$nm_file_trading?>"></span>
	<? } ?>
	<? if($$nm_file_performance != ""){ ?>
			<span class="thumb">상사이전등록증 <img src="<?=UPLOAD_PATH?>dealer/contract_step/<?=$cd_sale?>_detail/<?=$$nm_file_performance?>"></span>
	<? } ?>
		</div> -->
	</div>

	<div class="btn_right" style='padding-bottom:20px;'>
	<?php if($ds_status_sale == 'Z0' && $ds_status_contract_sale == 'B0') { ?>
		<a href="javascript:;" class="rnd_btn ty1 blue" id="btn_delay_reset" style='width:200px;'>거래연기 취소 후 입찰중</a>
	<?php } ?>
	<?php if($ds_status_sale == 'Z0' && $ds_status_contract_sale == 'C0') { ?>
		<a href="javascript:;" class="rnd_btn ty1 blue" id="btn_fail_reset" style='width:200px;'>거래실패 취소 후 입찰중</a>
	<?php } ?>
	<?php if($ds_status_sale == 'ZE') { ?>
		<a href="javascript:;" class="rnd_btn ty1 blue" id="btn_drop_reset" style='width:200px;'>유찰 취소 후 입찰중</a>
	<?php } ?>
	</div>

	<form id="frmDealyForm" name="frmDealyForm">
	<input type="hidden" name="mode" value="resetDelay" />
	<input type="hidden" name="cd_sale" value="<?=$cd_sale?>" />
	<input type="hidden" name="cd_tender" value="<?=$cd_tender_success?>" />

	</form>

	<form id="frmFailForm" name="frmFailForm">
	<input type="hidden" name="mode" value="resetFail" />
	<input type="hidden" name="cd_sale" value="<?=$cd_sale?>" />
	<input type="hidden" name="cd_tender" value="<?=$cd_tender_success?>" />
	</form>

	<form id="frmDropForm" name="frmDropForm">
	<input type="hidden" name="mode" value="resetDrop" />
	<input type="hidden" name="cd_sale" value="<?=$cd_sale?>" />
	<input type="hidden" name="cd_tender" value="<?=$cd_tender_success?>" />
	</form>


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

			custom_opts.title = '거래연기 취소 후 입찰중으로 변경하시겠습니까?';
			custom_modal_confirm(custom_opts, function(confirm) {
				if(confirm) {

					$("#btn_delay_reset").hide();
					var sdata = dataCarInfo();

					var data = $("#frmDealyForm").serialize();

					$.ajax({
						url : 'proc.php',
						type: 'POST',
						data: data,
						dataType: 'json',
						success: function(res) {
							$("#btn_delay_reset").show();

							custom_modal_confirm_close();

							// alert(res.MSG);
							if(res.CODE != "0000") {
								custom_opts.title = '실패하였습니다. 다시 시도해 주세요.';
								custom_modal_alert(custom_opts);
								return false;
							}

							custom_opts.title = '정상처리 되었습니다.';
							custom_opts.event_esc_key = false;

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

							// window.location.reload();
							return false;
						},
						error:function(request,status,error){
							$("#btn_delay_reset").show();
							custom_modal_confirm_close();

							alert("code:"+request.status+"\n"+"message:"+request.responseText+"\n"+"error:"+error);
						}
					});
				}else {
					$("#btn_delay_reset").show();
					return false;
				}
			});
		});


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

			custom_opts.title = '거래실패 취소 후 입찰중으로 변경하시겠습니까?';
			custom_modal_confirm(custom_opts, function(confirm) {
				if(confirm) {

					$("#btn_fail_reset").hide();
					var sdata = dataCarInfo();

					var data = $("#frmFailForm").serialize();

					$.ajax({
						url : 'proc.php',
						type: 'POST',
						data: data,
						dataType: 'json',
						success: function(res) {
							$("#btn_fail_reset").show();

							custom_modal_confirm_close();

							// alert(res.MSG);
							if(res.CODE != "0000") {
								custom_opts.title = '실패하였습니다. 다시 시도해 주세요.';
								custom_modal_alert(custom_opts);
								return false;
							}

							custom_opts.title = '정상처리 되었습니다.';
							custom_opts.event_esc_key = false;

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

							// window.location.reload();
							return false;
						},
						error:function(request,status,error){
							$("#btn_fail_reset").show();
							custom_modal_confirm_close();

							alert("code:"+request.status+"\n"+"message:"+request.responseText+"\n"+"error:"+error);
						}
					});
				}else {
					$("#btn_fail_reset").show();
					return false;
				}
			});
		});


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

			custom_opts.title = '유찰 취소 후 입찰중으로 변경하시겠습니까?';
			custom_modal_confirm(custom_opts, function(confirm) {
				if(confirm) {

					$("#btn_drop_reset").hide();
					var sdata = dataCarInfo();

					var data = $("#frmDropForm").serialize();

					$.ajax({
						url : 'proc.php',
						type: 'POST',
						data: data,
						dataType: 'json',
						success: function(res) {
							$("#btn_drop_reset").show();

							custom_modal_confirm_close();

							// alert(res.MSG);
							if(res.CODE != "0000") {
								custom_opts.title = '실패하였습니다. 다시 시도해 주세요.';
								custom_modal_alert(custom_opts);
								return false;
							}

							custom_opts.title = '정상처리 되었습니다.';
							custom_opts.event_esc_key = false;

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

							// window.location.reload();
							return false;
						},
						error:function(request,status,error){
							$("#btn_drop_reset").show();
							custom_modal_confirm_close();

							alert("code:"+request.status+"\n"+"message:"+request.responseText+"\n"+"error:"+error);
						}
					});
				}else {
					$("#btn_drop_reset").show();
					return false;
				}
			});
		});
	})
	</script>