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("지정되지않은 요청입니다"); } ?>