echajoa/mypage/sell_view_postscript02.php

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

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

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

	$sql = "select 
					d.*
					, ff.nm_score_postscript_avg 
					, ff.rate_success 
					from (
						select 
							t.cd_dealer 
							, t.cd_dealer_p
							, avg(s.nm_score_postscript) 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 
							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' 
							) 
					) ff 
					inner join dealer_master d 
					on (ff.cd_dealer_p = d.cd_dealer)
				";

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

		$nm_name = $col[nm_name];
		$nm_file = $col[nm_file];

		$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_name?> <span></span></dt>
					<!--<dd class="thumb" style="background-image:url('<?=UPLOAD_PATH?>dealer/nm_file/<?=$nm_file?>');"></dd>-->
                    <dd class="thumb" style="background-image:url('<?=UPLOAD_PATH?>dealer/nm_file/<?=$nm_file_dealer?>');"></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">
	$("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");
	});
</script>
<? include("../include/inc_bottom.php") ?>
<?
mysql_close($connect);
?>