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