echajoa/manage/inc/inc_header_dealer.php

<?

$base_filename = basename($_SERVER['PHP_SELF']); //현재 페이지 파일명

if(strpos($base_filename,'test') !== false){
    //파일명에 test가 들어간 경로 접근시
    $register = true;
}

$cd_dealer = empty($_REQUEST["cd_dealer_p"]) ? $_REQUEST["cd_dealer"] : $_REQUEST["cd_dealer_p"];

/*	입찰 정보 없을 시 딜러 데이타도 없슴.
$sql_h = "SELECT
			max(a.cd_dealer_p) cd_deler_p
			, max(case when a.cd_dealer = a.cd_dealer_p then nm_company else '' end) nm_company_p
			, max(case when a.cd_dealer = a.cd_dealer_p then dt_lastlogin else '' end) dt_lastlogin_p
			, max(case when a.cd_dealer = a.cd_dealer_p then nm_deposit else '' end) nm_deposit_p
			, count(*) cnt_tender
			, case when sum(case when b.ds_status = 'Z0' then 1 else 0 end) is null then 0 else sum(case when b.ds_status = 'Z0' then 1 else 0 end) end cnt_success
			, case when count(*) > 0 && sum(case when b.ds_status = 'Z0' then 1 else 0 end) is not null then sum(case when b.ds_status = 'Z0' then 1 else 0 end)/count(*)*100 else 0 end rate_success
		FROM dealer_master a
		inner join tender_master b
		on (
			a.cd_dealer = b.cd_dealer
		)
		WHERE a.cd_dealer_p = $cd_dealer AND a.ds_delind='N' ";
*/
$sql_h = "
	SELECT
		cd_dealer_p
		, nm_company_p
		, case when dt_lastlogin_p is null then '' else dt_lastlogin_p end dt_lastlogin_p
		, nm_deposit_p
		, cnt_tender
		, case when cnt_success is null then 0 else cnt_success end cnt_success
		, case when cnt_tender > 0 && cnt_success is not null then cnt_success/cnt_tender*100 else 0 end rate_success
		, case when sum_score_postscript > 0 && cnt_success > 0 then sum_score_postscript/cnt_success else 0 end avg_score_postscript
	FROM
		(
			SELECT
				cd_dealer_p
				, nm_company nm_company_p
				, dt_lastlogin dt_lastlogin_p
				, nm_deposit nm_deposit_p
			FROM dealer_master
			where cd_dealer = $cd_dealer
		) c
		,
		(
			SELECT
				sum(case when b.ds_status = 'Z0' then s.nm_score_postscript else 0 end) sum_score_postscript
				, count(*) cnt_tender
				, sum(case when b.ds_status = 'Z0' then 1 else 0 end) cnt_success
			FROM dealer_master a
			inner join tender_master b
				on (
					a.cd_dealer = b.cd_dealer
					and a.cd_dealer_p = $cd_dealer AND a.ds_delind='N'
				)
			inner join sale_master s
				on (
					b.cd_sale = s.cd_sale
					and s.ds_status = 'ZS'
				)
		) d ";

$col=mysql_fetch_array(mysql_query($sql_h));

if (!empty($col['cd_dealer_p'])){
	$cd_dealer_p = $col['cd_dealer_p'];
	$nm_company_p = $col['nm_company_p'];
	$dt_lastlogin_p = $col['dt_lastlogin_p'];
	$nm_deposit_p = $col['nm_deposit_p'];
	$cnt_tender = $col['cnt_tender'];
	$cnt_success = $col['cnt_success'];
	$rate_success = $col['rate_success'];
	$avg_score_postscript = $col['avg_score_postscript'];
}else{
	$cd_deler_p = "";
	$nm_company_p = "";
	$dt_lastlogin_p = "";
	$nm_deposit_p = "";
	$cnt_tender = "";
	$cnt_success = "";
	$rate_success = "";
	$avg_score_postscript = "";
}

?>

	<div class="dealer_info">
		<p class="dealer_mem">
			<span class="name"><em>상호 : </em><?=$nm_company_p?></span>
            <span class="login_time_dealer">최종 로그인 : <?=$dt_lastlogin_p?></span>
			<!--span class="money">예치금 : <?=$nm_deposit_p?> 원</span-->
		</p>
		<p class="dealer_grade">
			<span>총 입찰횟수 : <em><?=$cnt_tender?>건</em></span>
			<span>낙찰건수 : <em><?=$cnt_success?>건</em></span>
			<span>낙찰률 : <em><?=$rate_success?>%</em></span>
			<span>평가점수 : <em><?=$avg_score_postscript?>점</em></span>
		</p>
	</div>
	<ul class="tab_menu tab6">
		<li><a href="dealer_view.php?cd_dealer=<?=$cd_dealer?>"<?if(strpos($base_filename,'dealer_view.php') !== false){?> class="on"<?}?>>요약보기</a></li>
		<li><a href="dealer_view2.php?cd_dealer=<?=$cd_dealer?>"<?if(strpos($base_filename,'dealer_view2') !== false){?> class="on"<?}?>>회원정보</a></li>
		<li><a href="dealer_view3.php?cd_dealer=<?=$cd_dealer?>"<?if(strpos($base_filename,'dealer_view3') !== false){?> class="on"<?}?>>부관리자 정보</a></li>
		<li><a href="dealer_view4.php?cd_dealer=<?=$cd_dealer?>"<?if(strpos($base_filename,'dealer_view4') !== false){?> class="on"<?}?>>입찰정보</a></li>
		<li><a href="dealer_view5.php?cd_dealer=<?=$cd_dealer?>"<?if(strpos($base_filename,'dealer_view5') !== false){?> class="on"<?}?>>입찰후기</a></li>
		<li><a href="dealer_view6.php?cd_dealer=<?=$cd_dealer?>"<?if(strpos($base_filename,'dealer_view6') !== false){?> class="on"<?}?>>문의내역</a></li>
	</ul>