include("../inc/inc_top.php") ?> $cd_dealer_p = $_REQUEST["cd_dealer_p"]; /* $sql = "select d.* , d1.nm_file nm_file_d_manager , 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) 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_name = $col[nm_name]; $nm_file = $col[nm_file]; $nm_file_d_manager = $col[nm_file_d_manager]; $nm_score_postscript_avg = $col[nm_score_postscript_avg]; $rate_success = $col[rate_success]; }else{ // AlertBack("지정되지않은 요청입니다"); } ?>