$cd_sale = $_REQUEST["cd_sale"]; // $sql = "SELECT // t.* // , d.nm_name nm_name_dealer_p // , d.nm_zip nm_zip_dealer_p // , d.nm_addr nm_addr_dealer_p // , d.nm_addr_sub nm_addr_sub_dealer_p // , d.nm_area nm_area_dealer_p // , p.nm_name nm_name_dealer // , concat_ws('-',concat_ws('-',p.nm_hp_01,p.nm_hp_02),p.nm_hp_03) nm_hp_dealer // , p.nm_file nm_file_dealer // , s.nm_file_trading // , s.nm_file_performance // , report.cd_dealer_p_min // , report.cd_dealer_p_max // , report.nm_price_min // , report.nm_price_max // , report.nm_price_avg // , report.nm_name_min // , report.nm_name_max // , report.cnt // FROM tender_master t // inner join dealer_master d // on (t.cd_dealer_p = d.cd_dealer // and t.cd_sale = '$cd_sale' // and t.ds_delind = 'N' // and t.ds_status = 'Z0' // ) // inner join dealer_master p on (t.cd_dealer = p.cd_dealer) // inner join sale_master s on (t.cd_sale = s.cd_sale ) // inner join ( // select // ff.cd_sale // , ff.cd_dealer_p_min // , ff.cd_dealer_p_max // , ff.nm_price_min // , ff.nm_price_max // , ff.nm_price_avg // , ff.cnt // , d1.nm_name nm_name_min // , d2.nm_name nm_name_max // from ( // select // max(cc.cd_sale) cd_sale // , max(cc.cd_dealer_p_min) cd_dealer_p_min // , max(cc.cd_dealer_p_max) cd_dealer_p_max // , max(cc.nm_price_min) nm_price_min // , max(cc.nm_price_max) nm_price_max // , max(cc.nm_price_avg) nm_price_avg // , max(cc.cnt) cnt // from ( // select // aa.cd_sale // , case when aa.nm_price = bb.nm_price_min then aa.cd_dealer_p else 0 end cd_dealer_p_min // , case when aa.nm_price = bb.nm_price_max then aa.cd_dealer_p else 0 end cd_dealer_p_max // , bb.nm_price_min // , bb.nm_price_max // , bb.nm_price_avg // , bb.cnt // from (select * from tender_master where cd_sale = '$cd_sale' and ds_delind = 'N') aa // , ( // select // min(nm_price) nm_price_min // , max(nm_price) nm_price_max // , round(avg(nm_price)) nm_price_avg // , count(*) cnt // from tender_master // where cd_sale = '$cd_sale' and ds_delind = 'N' // ) bb // ) cc // ) ff // inner join dealer_master d1 // on (ff.cd_dealer_p_min = d1.cd_dealer) // inner join dealer_master d2 // on (ff.cd_dealer_p_max = d2.cd_dealer) // ) report // on (t.cd_sale = report.cd_sale // ) "; $price_sql ="select count(*) cnt , min(nm_price) min_price , avg(nm_price) avg_price , max(nm_price) max_price , max(case when ds_status = 'Z0' then nm_price else 0 end) tender_price from tender_master where cd_sale = $cd_sale "; // echo $price_sql; $price_col = mysql_fetch_array(mysql_query($price_sql)); $teder_success_sql = "SELECT t.* , a.nm_name nm_name_company FROM tender_master t INNER JOIN aap_master a on t.cd_dealer_p = a.cd_dealer WHERE t.cd_sale = '$cd_sale' AND t.ds_status = 'Z0' AND t.ds_delind = 'N' LIMIT 1 "; // echo $teder_success_sql; // exit; $col=mysql_fetch_array(mysql_query($teder_success_sql)); if (!empty($col['cd_sale'])){ $cd_sale = $col['cd_sale']; $nm_price = $col['nm_price']; $nm_commission = $col['nm_commission']; // $nm_file_trading = $col['nm_file_trading']; // $nm_file_performance = $col['nm_file_performance']; // // $nm_name_dealer_p = $col['nm_name_dealer_p']; // $nm_zip_dealer_p = $col['nm_zip_dealer_p']; // $nm_addr_dealer_p = $col['nm_addr_dealer_p']; // $nm_addr_sub_dealer_p = $col['nm_addr_sub_dealer_p']; // $nm_area_dealer_p = $col['nm_area_dealer_p']; $nm_name_company = $col['nm_name_company']; $nm_tender_name = $col['nm_name']; $nm_hp = $col['nm_hp']; $cd_tender_success = $col['cd_tender']; // $nm_hp_dealer = $col['nm_hp_dealer']; // $nm_file_dealer = $col['nm_file_dealer']; // $cd_dealer_p_min = $col['cd_dealer_p_min']; // $cd_dealer_p_max = $col['cd_dealer_p_max']; // $nm_price_min = $col['nm_price_min']; // $nm_price_max = $col['nm_price_max']; // $nm_price_avg = $col['nm_price_avg']; // $nm_name_min = $col['nm_name_min']; // $nm_name_max = $col['nm_name_max']; // $cnt = $col['cnt']; /* $arr_nm_info1 = explode("-",$nm_info1); if(count($arr_nm_info1) == 3){ $nm_info11 = $arr_nm_info1[0]; $nm_info12 = $arr_nm_info1[1]; $nm_info13 = $arr_nm_info1[2]; }else{ $nm_info11 = ""; $nm_info12 = ""; $nm_info13 = ""; } $arr_nm_info3 = explode("@",$nm_info3); if(count($arr_nm_info3) == 2){ $nm_info31 = $arr_nm_info3[0]; $nm_info32 = $arr_nm_info3[1]; }else{ $nm_info31 = ""; $nm_info32 = ""; } $nm_info3 = $col[nm_info3]; */ }else{ // AlertBack("지정되지않은 요청입니다"); } ?>
낙찰금액 : =number_format($nm_price)?>만원, 수수료: =number_format($nm_commission)?>만원 if($ds_status_sale == "ZE"){ ?>
견적실수 } ?>