id_, main_id_, fill_date_, enterprise_code_, enterprise_name_, enterprise_name_en_, subject_code_, subject_name_, subject_name_en_, subject_unit_, fill_data_, last_time_ SELECT q.enterprise_code_ FROM ( SELECT enterprise_code_, column_ FROM qf_hr_person_d WHERE main_id_ = #{mainId} GROUP BY enterprise_code_, column_ ORDER BY column_ ) q SELECT q.subject_code_ FROM (SELECT subject_code_, sn_ FROM qf_hr_person_d WHERE main_id_ =#{mainId} GROUP BY subject_code_, sn_ ORDER BY sn_) q SELECT m.enterprise_code_,m.subject_code_, (SELECT d.fill_data_ AS fillRealData FROM qf_hr_person_d d LEFT JOIN qf_hr_person_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} AND #{endMonth}=m.fill_month_ and d.enterprise_code_ = m.enterprise_code_ and d.subject_code_ = m.subject_code_ ) as fillRealData, (SELECT d.fill_data_ AS fillUnrealData FROM qf_hr_person_d d LEFT JOIN qf_hr_person_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} AND #{endMonth} - 1 = m.fill_month_ and d.enterprise_code_ = m.enterprise_code_ and d.subject_code_ = m.subject_code_ ) as fillUnrealData, (SELECT d.fill_data_ AS lastYearfillRealData FROM qf_hr_person_d d LEFT JOIN qf_hr_person_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear}-1 AND #{endMonth}=m.fill_month_ and d.enterprise_code_ = m.enterprise_code_ and d.subject_code_ = m.subject_code_ ) as lastYearfillRealData, (SELECT d.fill_data_ AS lastYearfillUnrealData FROM qf_hr_person_d d LEFT JOIN qf_hr_person_m m ON d.main_id_ = m.id_ WHERE m.fill_year_ = #{fillYear} -1 AND #{endMonth}-1 =m.fill_month_ and d.enterprise_code_ = m.enterprise_code_ and d.subject_code_ = m.subject_code_ ) as lastYearfillUnrealData FROM qf_hr_person_d m where m.subject_code_ in #{subjectCode} GROUP BY m.enterprise_code_,m.subject_code_ SELECT d.subject_code_, d.enterprise_code_, d.actual_, d.actual_ytd_ FROM qf_hr_person_d d LEFT JOIN qf_hr_person_m m ON m.id_ = d.main_id_ WHERE m.fill_year_ = #{vo.year} AND m.fill_month_ = #{vo.month} AND d.subject_code_ = #{subjectCode}