echajoa/mypage/sell_view_postscript.php

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

?>
<? include("../include/inc_top.php") ?>
<link rel="stylesheet" type="text/css" href="/css/swiper.min.css">

<?
	$cd_dealer_p = $_REQUEST["cd_dealer_p"];
	$cd_tender = $_REQUEST["cd_tender"];

/*
	$sql = "select 
					d.*
					, d1.nm_file nm_file_d_manager
					, d1.nm_name nm_name_d_manager
					, ff.nm_score_postscript_avg
					, ff.rate_success
					from (
						select
							max(case when t.cd_tender = '$cd_tender' then t.cd_dealer else -1 end) cd_dealer 
							, max(case when t.cd_tender = '$cd_tender' then t.cd_dealer_p else -1 end) cd_dealer_p
							, avg(ifnull(s.nm_score_postscript,0)) nm_score_postscript_avg
							, round(
								sum(case when t.ds_status = 'Z0' then 1 else 0 end)
								/count(*)*100
								, 0) rate_success
						from tender_master t
							left outer join sale_master s
							on (t.cd_sale = s.cd_sale
								and t.cd_dealer_p = '$cd_dealer_p'
								and t.ds_delind = 'N'
								and s.ds_status = 'ZS'
							)
						group by t.cd_dealer_p 
					) ff
					inner join dealer_master d
					on (ff.cd_dealer_p = d.cd_dealer)
					inner join dealer_master d1
					on (ff.cd_dealer = d1.cd_dealer)
				";
*/
	$sql = "select 
					d.*
					, d1.nm_file nm_file_d_manager
					, d1.nm_name nm_name_d_manager
					, ifnull(ff.nm_score_postscript_avg, 0) nm_score_postscript_avg
					, ifnull(ff.rate_success, 0) rate_success
					from tender_master tt
					inner join dealer_master d
					on (
						tt.cd_dealer_p = d.cd_dealer
						and tt.cd_tender = '$cd_tender' 
					)
					inner join dealer_master d1
					on (tt.cd_dealer = d1.cd_dealer)
					cross join 
					(
						select
							round(
								sum(nm_score_postscript_sum)
								/count(*)
								, 0) nm_score_postscript_avg
							, round(
								sum(cnt_success)
								/count(*)*100
								, 0) rate_success
						from (
							select
								max(case when t.ds_status = 'Z0' then ifnull(s.nm_score_postscript,0) else 0 end) nm_score_postscript_sum
								, max(case when t.ds_status = 'Z0' then 1 else 0 end) cnt_success
							from tender_master t 
								inner join sale_master s
								on (t.cd_sale = s.cd_sale
									and t.cd_dealer_p  = '$cd_dealer_p'
									and t.ds_delind = 'N'
									and s.ds_status = 'ZS'
								)
							group by s.cd_sale
						) ss 
					) ff
				";

	$col=mysql_fetch_array(mysql_query($sql));
	if (!empty($col[cd_dealer])){ 

		$nm_company = $col[nm_company];
		$nm_name = $col[nm_name];
		$nm_file = $col[nm_file];
		$nm_file_d_manager = $col[nm_file_d_manager];
		$nm_name_d_manager = $col[nm_name_d_manager];
        
		$nm_score_postscript_avg = $col[nm_score_postscript_avg];
		$rate_success = $col[rate_success];

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

?>
		<!-- layer popup -->
		<div class="review_popup">
			<div class="popup_wrap">
				<dl class="business_info">
					<dt><?=$nm_company?>/<?=$nm_name_d_manager?> <span></span></dt>
					<dd class="thumb review_rolling swiper-container">
						<ul class="swiper-wrapper">
							<li class="swiper-slide"><? if(!empty($nm_file)){ ?><img src="<?=UPLOAD_PATH?>dealer/nm_file/<?=$nm_file?>"><? } ?></li>
							<li class="swiper-slide"><? if(!empty($nm_file_d_manager)){ ?><img src="<?=UPLOAD_PATH?>dealer/nm_file/<?=$nm_file_d_manager?>"><? } ?></li>
						</ul>
						<div class="swiper-pagination"></div>
					</dd>
					<!--dd class="thumb" style="background-image:url('<?=UPLOAD_PATH?>dealer/nm_file/<?=$nm_file?>');background-size:cover;"></dd>
					<dd class="thumb" style="background-image:url('<?=UPLOAD_PATH?>dealer/nm_file/<?=$nm_file_d_manager?>');background-size:cover;"></dd -->
					<dd>약속드립니다.<br>정직하게 일하겠습니다.</dd>
					<dd class="estimation"><span>입찰성공률</span> <em><?=$rate_success?>%</em> <span>고객만족도</span> <em><?=$nm_score_postscript_avg?>점</em></dd>
				</dl>
				<dl class="review" id="postscript_list">
				</dl>
				<div class="btn_center">
					<a href="#" id="div_btn_more" class="button" style="display:none;">더 보기</a>
				</div>
			</div>
			<!--div class="close">레이어팝업 닫기</div-->
		</div>
		<!-- // layer popup -->

<form id="frmSearch" name="frmSearch">
	<input type="hidden" name="PostscriptPageNo" id="PostscriptPageNo" value="1"/>
	<input type="hidden" name="PostscriptPageSize" id="PostscriptPageSize" value="5"/>
</form>


<script type="text/javascript" charset="utf-8" src="/js/swiper.min.js"></script>
<script type="text/javascript">
	$("body, html").css("min-width","auto");

	$(function(){

		var cd_dealer_p ="<?=$cd_dealer_p?>";

		var setPostscriptList = function(pageNo, pageSize, cdDealerP, uiObj){
			var _pageNo = parseInt(pageNo);
			var _pageSize = parseInt(pageSize);
			var _pageStartPoint = (_pageNo-1)* _pageSize;
			var _cdDealerP =cdDealerP;
			var _uiObj =uiObj;

			$.ajax({
				url: '/common/dao/postscriptDao.php',
				data : {'mode':'listNormal','PageNo':_pageNo,'PageSize':_pageSize,'pageStartPoint':_pageStartPoint , 'cdDealerP' : _cdDealerP
					},
					
				dataType : 'json',
				method : 'POST',
				success : function(data){
					var _totalCnt = 0;
					$.each(data , function(idx, row){
						var html = "<dt><em>"+row.nm_model+"</em> 판매고객</dt>\n";
							html+= "<dd>\n";
if (row.nm_file_postscript != null && row.nm_file_postscript != "")
{
							html+= "	<img src=\"/uploadfile/dealer/contract_step/"+row.cd_sale+"_detail/"+row.nm_file_postscript+"\"><br><br>\n";
}
							html+= "	"+row.nm_cont_postscript+"\n";
							html+= "</dd>\n";

						_totalCnt = row.totalCnt;
						$(_uiObj).append(html);
					});

					var _lastPageNo = Math.ceil((_totalCnt/parseInt(_pageSize)));
					if(data.length ==0 || (_lastPageNo == parseInt($("#PostscriptPageNo").val())) ){
						$("#div_btn_more").hide();
					}else{
						$("#div_btn_more").show();
						$("#div_btn_more").unbind("click").bind("click",function(){

							$("#PostscriptPageNo").val(_pageNo+1);
							setPostscriptList($("#PostscriptPageNo").val(),$("#PostscriptPageSize").val(),'<?=$cd_dealer_p?>', "#postscript_list");
							return false;
						});
					}
				}
			});	
		};
		setPostscriptList($("#PostscriptPageNo").val(),$("#PostscriptPageSize").val(),'<?=$cd_dealer_p?>', "#postscript_list");

		var swiper = new Swiper('.review_rolling', {
			autoHeight : 'true',
			autoplay: {
				delay: 3500,
				disableOnInteraction: false,
			},
			pagination: {
				el: '.swiper-pagination',
			},
		});
	});
</script>
<? include("../include/inc_bottom.php") ?>
<?
mysql_close($connect);
?>