echajoa/manage/buy/inc_ViewTender.php

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

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

	$pagestartpoint=($PageNo-1)*$PageSize;

	$OrderBy = $_REQUEST['OrderBy'];
	if( $OrderBy != "" ){
		$sOrderBy = "ORDER BY ".$OrderBy;
	}else{
		$sOrderBy = "ORDER BY cast(t.nm_price as decimal) desc";
	}

	//AAP
	if($ds_dealer_type_sale == 'A0') {
		$dealer_table = "aap_master";
	}
	//딜러 : 현재는 딜러가 없음
	else {
		$dealer_table = "dealer_master";
	}
	//$sql = "where ds_delind='N'";
	$tender_add_sql = "";

	$tender_sql = "select count(*) FROM
						$dealer_table u
						inner join tender_master t on (u.cd_dealer = t.cd_dealer_p and t.cd_sale = $cd_sale and t.ds_delind='N' $tender_add_sql) ";
	// echo $tender_sql;

	$totalrows = @mysql_result(mysql_query($tender_sql),0,0);

?>
	<div class="area_title">
		<h3><em>▶</em> 입찰업체 리스트</h3>
		<span class="select">
			<select onchange="location.href='./buy_view.php?list_url=<?=$list_url?>&cd_sale=<?=$cd_sale?>&ds_status_sale=<?=$ds_status_sale?>&ListPageNo=<?=$ListPageNo?>&OrderBy='+this.value;">
				<option value="t.dt_insert"<? if($OrderBy=="t.dt_insert"){ ?> selected<? } ?>>최근순</option>
				<option value="t.nm_price desc"<? if($OrderBy=="cast(t.nm_price as decimal) desc"){ ?> selected<? } ?>>입찰가격 높은순</option>
				<option value="t.nm_price"<? if($OrderBy=="cast(t.nm_price as decimal)"){ ?> selected<? } ?>>입찰가격 낮은순</option>
			</select>
		</span>
	</div>
	<div class="tbl_wrap">
		<table class="tbl_list ty2" id="layout_tender_table">
			<colgroup>
			<?php if($ds_status_sale == 'Z0') { ?>
				<col width="4%">
			<?php } ?>
				<col width="7%">
				<col width="12%">
				<col width="*%">
				<col width="14%">
				<col width="14%">
				<col width="10%">
			<?php if($ds_status_sale == 'Z0') { ?>
				<col width="6%">
			<?php } ?>
			</colgroup>
			<thead>
			<tr>
			<?php if($ds_status_sale == 'Z0') { ?>
				<th>
					<span class="check_wrap">
						<input type="checkbox" name="" value="Y" /> <i style=""></i> <label for="img_delete2" ></lable>
					</span>
				</th>
			<?php } ?>
				<th>번호</th>
				<th>입찰업체</th>
				<th>입찰금액</th>
				<th>담당자</th>
				<th>연락처</th>
				<th>입찰일</th>
			<?php if($ds_status_sale == 'Z0') { ?>
				<th>삭제</th>
			<?php } ?>
			</tr>
			</thead>
<?php

?>
<?php
		if($totalrows>0) {
			$tender_sql = "SELECT t.*
								, d.nm_name nm_company_dealer
								FROM $dealer_table d
								inner join tender_master t on (d.cd_dealer = t.cd_dealer_p and t.cd_sale = $cd_sale and t.ds_delind='N' $tender_add_sql)
							$sOrderBy
							LIMIT $pagestartpoint,$PageSize";
			$r = mysql_query($tender_sql);

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

				// $apply_vat_price = (int)$col['nm_price'] - ((int)$col['nm_commission']/10000);
				$nm_commission = $col['nm_commission'];
?>
			<tr<? if($col['ds_status'] == "Z0"){ ?> bgcolor="fffaa7"<? } ?>>
			<?php if($ds_status_sale == 'Z0') { ?>
				<td>
					<span class="check_wrap">
						<input type="checkbox" name="chg_cd_tender[]" value="<?=$col['cd_tender']?>" /> <i style=""></i> <label for="img_delete2" ></lable>
					</span>
				</td>
			<?php } ?>
				<td><?=$i?></td>
				<td><?=$col['nm_company_dealer']?></td>
				<td>
					입찰금액 <input type="text" class="inp_txt" style="width:120px;" id="nm_price<?=$col['cd_tender']?>" name="nm_price<?=$col['cd_tender']?>" value="<?=$col['nm_price']?>"> 만원,&nbsp;&nbsp;&nbsp;
					수수료 적용금액 <input type="text" class="inp_txt" style="width:120px;" id="nm_ex_vat_price<?=$col['cd_tender']?>" name="nm_ex_vat_price<?=$col['cd_tender']?>" value="<?=$col['nm_ex_vat_price']?>" readonly> 만원,&nbsp;&nbsp;&nbsp;
					구간별 수수료 <input type="text" class="inp_txt" style="width:120px;" id="nm_commission<?=$col['cd_tender']?>" name="nm_commission<?=$col['cd_tender']?>" value="<?=$nm_commission?>" readonly> 만원,&nbsp;&nbsp;&nbsp;
					<input type="text" class="inp_txt" style="width:120px;" id="nm_manager_price<?=$col['cd_tender']?>" name="nm_manager_price<?=$col['cd_tender']?>" value="<?=$col['nm_manager_price']?>"> 만원

					<a href="javascript:;" class="rnd_btn ty3 black" id="btn_nm_price" style="margin-left:10px;padding:0 10px;width:auto;font-size:12px;" onclick="changeNmPrice('<?=$col['cd_sale']?>', '<?=$col['cd_tender']?>')">금액수정</a>
				</td>
				<td>
					<?=$col['nm_name']?>
				<?php if($ds_status_sale == 'E0') { ?>
					<a href="javascript:;" class="rnd_btn ty3 black" id="btn_nm_price" style="margin-left:10px;padding:0 10px;width:auto;font-size:12px;" onclick="changeTender('<?=$col['cd_sale']?>','<?=$col['cd_tender']?>')">낙찰하기</a>
				<?php
					} else if($ds_status_sale == 'Z0') {
						$bid_status = "유찰";
						if($col['ds_status'] == 'Z0') {
							$bid_status = '낙찰';
						}
				?>
					(<?=$bid_status?>)
				<?php } ?>
				</td>
				<td><?=$col['nm_hp']?></td>
				<td><?=$col['dt_insert']?></td>
			<?php if($ds_status_sale == 'Z0') { ?>
				<td><a href="javascript:;" class='btn_delete_tender' cd_tender="<?=$col['cd_tender']?>">삭제</a></td>
			<?php } ?>
			</tr>
<?php
				$i++;
			}
		}else{
?>
			<tr>
				<td colspan="6">데이터가 존재 하지 않습니다.</td>
			</tr>
<?php
		}
?>
		</table>
	</div>

<?php if($ds_status_sale == 'Z0') { ?>
	<div class="btn_right" style='padding-bottom:20px;'>
		체크 후 <a href="javascript:;" class="rnd_btn ty1 blue" id="btn_tender_chager_dealer">입찰업체 변경</a>
	</div>
<?php } ?>
	<div class="paging">
		<?php
				$url = "./buy_view.php?list_url=$list_url&cd_sale=$cd_sale&ds_status_sale=$ds_status_sale&ListPageNo=$ListPageNo&PageNo=$PageNo";
				ListPg1($url ,$PageNo,$PageSize,10,$totalrows,$leftboard[1],$rootpath);
		?>
	</div>

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

	function changeNmPrice(arg_cd_sale, arg_cd_tender){

		var nm_price_val = $("#nm_price"+arg_cd_tender).val();
		// var nm_ex_vat_price_val = $("#nm_ex_vat_price"+arg_cd_tender).val();
		var nm_ex_vat_price_val = 0;
		var nm_manager_price_val = $("#nm_manager_price"+arg_cd_tender).val();

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

		custom_opts.title = '금액을 수정하시겠습니까?';
		custom_modal_confirm(custom_opts, function(confirm) {
			if(confirm) {

				var data = {
					mode : "changePrice",
					cd_sale : arg_cd_sale,
					cd_tender : arg_cd_tender,
					nm_price : nm_price_val,
					nm_ex_vat_price : nm_ex_vat_price_val,
					nm_manager_price : nm_manager_price_val,
				}

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

						custom_modal_confirm_close();

						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();
						});

						return false;
					},
					error:function(request,status,error){

						custom_modal_confirm_close();

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

		// $.post("proc.php", { mode:"changePrice", cd_tender: arg_cd_tender, nm_price: nm_price_val},function(data) {
		// 	if(data=="Y"){
		// 		alert("정상적으로 처리되었습니다.");
		// 		return;
		// 	}else{
		// 		alert("정상적으로 처리되지 않았습니다.");
		// 		return;
		// 	}
		// });

	}

	function changeTender(arg_cd_sale, arg_cd_tender){

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

		custom_opts.title = '낙찰하시겠습니까?';
		custom_modal_confirm(custom_opts, function(confirm) {
			if(confirm) {

				var data = {
					mode:"changeTender",
					cd_sale: arg_cd_sale,
					cd_tender: arg_cd_tender
				}

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

						custom_modal_confirm_close();

						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();
						});

						return false;
					},
					error:function(request,status,error){

						custom_modal_confirm_close();

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

	}

	$(function() {
		$(".btn_delete_tender").on("click", function() {
			var cd_tender = $(this).attr("cd_tender");

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

			custom_opts.title = '삭제하시겠습니까?';
			custom_modal_confirm(custom_opts, function(confirm) {
				if(confirm) {
					var data = {
						mode:"deleteTender",
						cd_sale: "<?=$cd_sale?>",
						cd_tender: cd_tender
					}

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

							custom_modal_confirm_close();

							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();
							});

							return false;
						},
						error:function(request,status,error){

							custom_modal_confirm_close();

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

		$("#btn_tender_chager_dealer").on("click", function() {


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

			var checked_length = $("#layout_tender_table input[name='chg_cd_tender[]']:checked").length;
			if(checked_length < 1) {
				custom_opts.title = '변경하려는 입찰업체를 선택하세요.';
				custom_modal_alert(custom_opts);
				return false;
			}else if(checked_length > 1) {
				custom_opts.title = '변경하려는 입찰업체는 1개만 선택하세요.';
				custom_modal_alert(custom_opts);
				return false;
			}

			var cd_tender = $("#layout_tender_table input[name='chg_cd_tender[]']:checked").val();

			custom_opts.title = '입찰업체를 변경하시겠습니까?';
			custom_modal_confirm(custom_opts, function(confirm) {
				if(confirm) {
					var data = {
						mode:"changeTender",
						cd_sale: "<?=$cd_sale?>",
						cd_tender: cd_tender
					}

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

							custom_modal_confirm_close();

							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();
							});

							return false;
						},
						error:function(request,status,error){
							$("#btn_tender_chager_dealer").show();

							custom_modal_confirm_close();

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

</script>