id_, main_id_, fill_year_, data_type_, fill_type_, fill_week_, fill_start_date, fill_end_date, fill_date_, enterprise_code_, enterprise_name_, enterprise_name_en_, fill_data_, last_time_ SELECT fill_week_ FROM qf_finance_liquidity_detail WHERE main_id_ =#{mainId} GROUP BY fill_week_ ORDER BY fill_week_ ASC SELECT q.enterprise_code_ FROM (SELECT enterprise_code_, sn_ FROM qf_finance_liquidity_detail WHERE main_id_ =#{mainId} GROUP BY enterprise_code_, sn_ ORDER BY sn_) q SELECT m.fill_week_ as week,d.fill_data_ as budget FROM qf_finance_liquidity_m m LEFT JOIN qf_finance_liquidity_detail d ON d.main_id_ = m.id_ WHERE d.fill_type_ = '2' AND d.fill_week_ = #{vo.week} and (m.fill_year_ = #{vo.startYear} or m.fill_year_ = #{vo.endYear}) and d.data_type_= #{vo.dataType} AND d.enterprise_code_ = #{vo.enterpriseCode} and m.fill_week_ in #{week} order by m.fill_week_ asc SELECT m.fill_week_ as week,d.fill_data_ as actual FROM qf_finance_liquidity_m m LEFT JOIN qf_finance_liquidity_detail d ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{vo.year} AND d.fill_type_ = '1' AND d.fill_week_ = #{vo.week} and d.data_type_= #{vo.dataType} AND d.enterprise_code_ = #{vo.enterpriseCode} SELECT m.fill_week_ as week,d.fill_data_ as warnValue FROM qf_finance_liquidity_m m LEFT JOIN qf_finance_liquidity_detail d ON d.main_id_ = m.id_ WHERE d.fill_type_ = '2' and (m.fill_year_ = #{vo.startYear} or m.fill_year_ = #{vo.endYear}) AND d.fill_week_ = #{vo.week} and d.data_type_= #{vo.dataType} and m.fill_week_ in #{week}