echajoa/m/member/inc_ViewTender.20230417.php

<?php
	//이 페이지는 2가지 상황에서 사용됨
	//입찰중, 거래중
	$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 == "") $OrderBy = "cast(t.nm_price as unsigned) desc, t.cd_tender desc ";

	$sOrderBy = "ORDER BY ".$OrderBy;

	$add_sql = " WHERE d.ds_delind='N' ";

	//매물 상태별 처리
	$tender_list_title = "";
	switch($ds_status_sale) {
		//입찰중
		case 'F0':
			$tender_list_title = "입찰업체";
			$add_sql.= "  ";

			break;
		//거래중
		case 'Z0':
			//낙찰한 상태이면
			if(empty($ds_status_contract_step1)) {
				$tender_list_title = "입찰업체";
				$add_sql.= "  ";
			}else {
				$tender_list_title = "낙찰업체";
				$add_sql.= " AND t.ds_status = 'Z0' ";
			}


			break;
	}

	$sql = "SELECT count(*)
				FROM aap_master 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' )
				inner join sale_master s on t.cd_sale = s.cd_sale and s.cd_sale = $cd_sale AND s.ds_delind='N'
				$add_sql
	";
	// echo $sql;

	// echo "select count(*) FROM ucaro_master 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' $sql)";

	$totalrows = @mysql_result(mysql_query($sql),0,0);
?>

	<section class="mt-5 pt30">
		<div class="data--table--wrap">
			<div class="col-12 title--wrapper d-flex align-items-center justify-content-between">
				<h2><?=$tender_list_title?> 업체</h2>
				<div class="col-md-6 d-flex justify-content-end">
					<div>
						<select id="inputState" class="form-select" style="width:100px;">
							<option selected="">최근순</option>
							<option></option>
						</select>
					</div>
				</div>
			</div>
			<div class="table--m--wrap">
				<table class="table table-bordered mt-3">
					<colgroup>
						<col style="width:10%;">
						<col style="width:20%;">
						<col style="width:25%;">
						<col style="width:15%;">
						<col style="width:15%;">
						<col style="width:15%;">
					</colgroup>
					<thead>
						<tr>
							<th>
								<div class="d-flex justify-content-center">NO</div>
							</th>
							<th>
								<div class="d-flex justify-content-center">입찰업체</div>
							</th>
							<th>
								<div class="d-flex justify-content-center">입찰금액</div>
							</th>
							<th>
								<div class="d-flex justify-content-center">담당자</div>
							</th>
							<th>
								<div class="d-flex justify-content-center">연락처</div>
							</th>
							<th>
								<div class="d-flex justify-content-center">입찰일</div>
							</th>
						</tr>
					</thead>
					<tbody>
					<?php
						if($totalrows>0) {
							$sql = "SELECT t.*, d.nm_name nm_name_dealer, d.nm_name nm_name_dealer, s.ds_status ds_status_sale
													, getRemainTimeByPhase(".LIMIT_TIME_TENDER.", ".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell
													, d1.nm_name nm_name_dealer1
													, d1.nm_hp nm_hp_dealer1
													, s.nm_price_final
													FROM  aap_master 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')
													inner join aap_master d1 on (t.cd_dealer = d1.cd_dealer)
													inner join sale_master s on (t.cd_sale = s.cd_sale)
													 $add_sql
												$sOrderBy
												LIMIT $pagestartpoint,$PageSize";
							// echo $sql;
							// exit;
							$r = mysql_query($sql);


							$i=1;

							$status_bid_success = array('Z0', 'ZS', 'ZE');
							$status_bid_fail = array('E0', 'F0');

							while($col = mysql_fetch_array($r)) {
								$tmpNum =$totalrows-($PageSize*($PageNo-1));
								$aapNum = ($tmpNum - $i)+1;
					?>

					<?php
						//SA는 입찰 업체 정보 안보이게 처리
					?>
						<tr>
							<td>
								<div class="d-flex justify-content-center"><?=$aapNum?></div>
							</td>

							<td>
								<div class="d-flex justify-content-center"><?=$col['nm_name_dealer']?></div>
							</td>
							<td>
								<div class="d-flex align-items-center justify-content-center">
									<input type="text" class="form-control" style="max-width:200px" value="<?=number_format($col['nm_price'])?>" />
									<label class="ms-3">만원</label>
								</div>
							</td>
							<td>
								<div class="d-flex align-items-center justify-content-center">
									<?=$col['nm_name_dealer1']?>
								<?php
									$btn_bid_proc = "";
									//낙찰이후 상태
									if(in_array($col['ds_status_sale'], $status_bid_success)) {
										if($col['ds_status_sale'] == "ZE"){
											$status_text = '거래실수';
										}else {
											if($col['ds_status'] == "Z0") {
												$status_text = '낙찰';
											}else {
												$status_text = '낙첨';
											}
										}
									}else {
										if(in_array($col['ds_status_sale'], $status_bid_fail)) {
											if($col['time_limit_sell']=="0분"){
												$status_text = '낙첨';
											}
											else {
												$status_text = '입찰중';
												$btn_bid_proc = "<button type='button' class='btn btn-primary ms-3 btn_bid_proc' cd_tender='{$col['cd_tender']}' nm_name_dealer='{$col['nm_name_dealer']}' nm_price='{$col['nm_price']}' value='{$col['cd_tender']}' >낙찰하기</button>";

												//<button class="button button_s_rnd ty2" type='button' onclick="selectTender('{$col['cd_tender']}','{$col['nm_name_dealer1'}','{$col['nm_price'}')" >판매완료</button>
											}
										}
									}
								?>
								<?//$status_text?>
								<?=$btn_bid_proc?>
								<?/*<button class="button button_s_rnd ty2" type='button' onclick="selectTender('<?=$col[cd_tender]?>','<?=$col[nm_name_dealer1]?>','<?=$col[nm_price]?>')" >판매완료</button>*/?>
								</div>
							</td>
							<td>
								<div class="d-flex justify-content-center"><?=string_to_asterisk('phone', $col['nm_hp_dealer1'])?></div>
							</td>
							<td>
								<div class="d-flex justify-content-center"><?=$col['dt_insert']?></div>
							</td>
						</tr>
						<?php
										$i++;
									}
								}else{
						?>
									<tr>
										<td colspan="6" align="center">데이터가 존재 하지 않습니다.</td>
									</tr>
						<?php
								}
						?>
					</tbody>
				</table>
			</div>
		</div>
		<div class="col-12 d-flex justify-content-center pagination--wrapper">
			<?php
				$url = "./$list_url?searchtype=$searchtype&searchword=$searchword&ds_status=$ds_status&ds_usertype=$ds_usertype&PageSort=$PageSort";
				ListMobilePg($url ,$PageNo,$PageSize,10,$totalrows,$leftboard[1],$rootpath);
			?>
		</div>

	</section>
	<form name="frmTenderForm" id="frmTenderForm" method="post" action="sa_proc.php">
		<input type="hidden" name="mode" value="TenderSuccessAAP">
		<input type="hidden" name="cd_sale" value="<?=$cd_sale?>">
		<input type="hidden" name="cd_tender" >
		<input type="hidden" name="nm_price" >
	</form>

<script>
$(function() {
	$(".btn_bid_proc").on("click", function() {
		var custom_opts = {
			title : '',
			btn_close_show : false,
		}
		var cd_tender = $(this).val();
		var nm_price = $(this).attr("nm_price");
		var nm_name_dealer = $(this).attr("nm_name_dealer");

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

				$("#frmTenderForm input[name=cd_tender]").val(cd_tender);
				$("#frmTenderForm input[name=nm_price]").val(nm_price);

				$("#btn_bid_proc").hide();
				var data = $("#frmTenderForm").serialize();
				$.ajax({
					url : 'sa_proc.php',
					type: 'POST',
					dataType : 'json',
					data: data,
					success: function(res) {
						custom_modal_confirm_close();

						$("#btn_bid_proc").show();

						//세션 종료시 로그인 페이지로 이동
						if(res.CODE != "0000") {
							custom_opts.title = res.MSG;

							if(res.CODE == "4444") {
								window.location.href = res.DATAS.URL;
							}
							custom_modal_alert(custom_opts);
							return false;
						}

						custom_opts.title = '낙찰되었습니다.';
						custom_opts.event_esc_key = false;

						custom_modal_alert(custom_opts, function() {
							reload();
						});
					},
					error:function(request,status,error){
						$("#btn_bid_proc").show();

						custom_modal_confirm_close();

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

			}else {
				$("#btn_bid_proc").show();
				return false;
			}
		});

	});
})
</script>