id_, target_name_en_, target_name_, target_unit_, type_, larger_type_, target_id_, year_, quarter_, month_, enterprise_code_, enterprise_area_, enterprise_type_, actual_, budget_ SELECT s.*, t.name_ AS targetName, t.unit_ AS targetUnit, t.sta_lat_, t.analyse_type_, t.larger_type_, t.type_, t.sn_ FROM sys_subject_target t LEFT JOIN ( SELECT year_, target_id_, enterprise_code_, sum(actual_) AS actual, sum(budget_) AS budget, count(*) as count FROM qf_financial_statistical WHERE target_id_ = #{vo.targetId} and year_= #{vo.year} and enterprise_code_ in #{enterpriseCode} ) GROUP BY enterprise_code_, year_, target_id_ ) s ON s.target_id_ = t.id_ WHERE t.business_ = 'Finance' AND t.id_ = #{vo.targetId} and s.year_ = #{vo.year} SELECT s.*, c.parent_id_ FROM sys_subject_target s LEFT JOIN sys_subject_class c ON c.id_ = s.subject_id_ WHERE s.business_ = 'Finance' AND ( s.target_level_ = 1 OR s.code_ IN ('FE008', 'FE009', 'FE014') ) ORDER BY s.sn_ ASC SELECT s.*, t.name_ AS targetName, t.unit_ AS targetUnit, t.sta_lat_, t.analyse_type_, t.larger_type_, t.type_ FROM sys_subject_target t LEFT JOIN sys_subject_class c on c.id_ = t.subject_id_ LEFT JOIN (SELECT year_, target_id_, sum(actual_) AS actual, sum(budget_) AS budget, count(*) as count FROM qf_financial_statistical AND enterprise_code_ = #{vo.enterpriseCode} GROUP BY target_id_, year_) s ON s.target_id_ = t.id_ and s.year_ >= #{vo.startYear} AND #{vo.endYear} >= s.year_ and t.id_= #{vo.targetId} and c.parent_id_= #{vo.parentTargetId} ORDER BY s.year_ ASC SELECT s.*, t.name_ AS targetName, t.unit_ AS targetUnit, t.sta_lat_, t.analyse_type_, t.larger_type_, t.type_ FROM sys_subject_target t LEFT JOIN ( SELECT quarter_, target_id_, sum(actual_) AS actual, sum(budget_) AS budget, count(*) as count FROM qf_financial_statistical WHERE year_ = #{vo.quarterYear} AND enterprise_code_ = #{vo.enterpriseCode} GROUP BY target_id_, quarter_ ) s ON s.target_id_ = t.id_ WHERE t.id_ = #{vo.targetId} and s.quarter_ >= #{vo.startQuarter} AND #{vo.endQuarter} >= s.quarter_ ORDER BY s.quarter_ ASC SELECT s.year_, s.month_, s.target_id_, s.actual_ AS actual, s.budget_ AS budget FROM qf_financial_statistical s WHERE s.target_id_ = #{vo.targetId} AND s.enterprise_code_ = #{vo.enterpriseCode} and s.year_ = #{vo.year} and s.month_ >= #{vo.startMonth} AND #{vo.endMonth} >= s.month_ ORDER BY s.month_ ASC SELECT s.year_, s.month_, s.target_id_, s.actual_ytd_ AS actual, s.budget_ytd_ AS budget FROM qf_financial_statistical s WHERE s.target_id_ = #{vo.targetId} AND s.enterprise_code_ = #{vo.enterpriseCode} and s.year_ = #{vo.year} and s.month_ >= #{vo.startMonth} AND #{vo.endMonth} >= s.month_ ORDER BY s.month_ ASC SELECT s.year_, s.month_, s.target_id_, s.actual_ytd_ AS actual, s.budget_ytd_ AS budget FROM qf_financial_statistical s WHERE s.target_id_ = #{vo.targetId} AND s.enterprise_code_ = #{vo.enterpriseCode} and s.year_ >= #{vo.startYear} AND #{vo.endYear} >= s.year_ and s.month_ >= #{vo.startMonth} AND #{vo.endMonth} >= s.month_ ORDER BY s.year_ ASC SELECT s.year_, s.month_, s.target_id_, s.actual_ AS actual FROM qf_financial_statistical s WHERE s.target_id_ = #{vo.targetId} AND s.enterprise_code_ = #{vo.enterpriseCode} and s.year_ = #{vo.year} and s.month_ >= #{vo.startMonth} AND #{vo.endMonth} >= s.month_ ORDER BY s.month_ ASC SELECT q.target_id_, q.year_, qf.actual_ytd_ AS actual, qf.budget_ytd_ AS budget, q.month_ FROM qf_financial_statistical qf LEFT JOIN ( SELECT year_, max(month_) AS month_, enterprise_code_, target_id_ FROM qf_financial_statistical WHERE target_id_ = #{vo.targetId} AND enterprise_code_ = #{vo.enterpriseCode} and year_ > #{vo.startYear} AND #{vo.endYear} >= year_ GROUP BY year_, enterprise_code_, target_id_ ) q ON q.target_id_ = qf.target_id_ AND q.enterprise_code_ = qf.enterprise_code_ AND q.year_ = qf.year_ AND q.month_ = qf.month_ WHERE q.target_id_ IS NOT NULL ORDER BY year_ ASC SELECT q.target_id_, qf.actual_ytd_ AS actual, qf.budget_ytd_ AS budget, q.enterprise_code_, q.year_ FROM qf_financial_statistical qf LEFT JOIN ( SELECT year_, max(month_) AS month_, enterprise_code_, target_id_ FROM qf_financial_statistical WHERE target_id_ = #{vo.targetId} and enterprise_type_ = '1' and enterprise_type_ != '1' and year_ = #{vo.year} and month_ >= #{vo.startMonth} AND #{vo.endMonth} >= month_ GROUP BY year_, enterprise_code_,target_id_ ) q ON q.target_id_ = qf.target_id_ AND q.enterprise_code_ = qf.enterprise_code_ AND q.year_ = qf.year_ AND q.month_ = qf.month_ WHERE q.target_id_ IS NOT NULL ORDER BY year_ ASC SELECT q.target_id_, q.year_, qf.actual_ytd_ AS actual, qf.budget_ytd_ AS budget, q.month_ FROM qf_financial_statistical qf LEFT JOIN ( SELECT year_, max(month_) AS month_, enterprise_code_, target_id_ FROM qf_financial_statistical WHERE target_id_ = #{vo.targetId} AND enterprise_code_ = #{vo.enterpriseCode} and year_ >= #{vo.startYear} AND #{vo.endYear} >= year_ GROUP BY year_,enterprise_code_, target_id_ ) q ON q.target_id_ = qf.target_id_ AND q.enterprise_code_ = qf.enterprise_code_ AND q.year_ = qf.year_ AND q.month_ = qf.month_ WHERE q.target_id_ IS NOT NULL ORDER BY year_ ASC SELECT q.target_id_, qf.actual_ytd_ AS actual, qf.budget_ytd_ AS budget, q.enterprise_code_, q.year_ FROM qf_financial_statistical qf LEFT JOIN ( SELECT year_, max(month_) AS month_, enterprise_code_, target_id_ FROM qf_financial_statistical WHERE target_id_ = #{vo.targetId} AND enterprise_code_ != #{vo.enterpriseCode} and year_ = #{vo.year} and month_ >= #{vo.startMonth} AND #{vo.endMonth} >= month_ GROUP BY year_, enterprise_code_,target_id_ ) q ON q.target_id_ = qf.target_id_ AND q.enterprise_code_ = qf.enterprise_code_ AND q.year_ = qf.year_ AND q.month_ = qf.month_ WHERE q.target_id_ IS NOT NULL ORDER BY year_ ASC SELECT s.year_, s.month_, s.target_id_, s.actual_ytd_ AS actual, s.budget_ytd_ AS budget FROM qf_financial_statistical s WHERE s.target_id_ = #{vo.targetId} AND s.enterprise_code_ = #{vo.enterpriseCode} and s.year_ = #{vo.year} and s.month_ >= #{vo.startMonth} AND #{vo.endMonth} >= s.month_ ORDER BY s.month_ ASC SELECT s.target_id_, s.target_name_, s.target_name_en_, s.year_, s.month_, s.actual_ AS actual, s.budget_ AS budget FROM qf_financial_statistical s and s.target_id_ in #{targetId} and s.enterprise_code_ = #{vo.enterpriseCode} and s.year_ = #{vo.year} and s.month_ >= #{vo.startMonth} AND #{vo.endMonth} >= s.month_ ORDER BY s.year_,s.month_ ASC SELECT qf.target_id_, qf.actual_ AS actual, qf.enterprise_code_, qf.month_, qf.year_ FROM qf_financial_statistical qf WHERE qf.target_id_ = #{vo.targetId} and qf.year_ = #{vo.year} and qf.month_ = #{vo.month} AND qf.enterprise_type_ IS NOT NULL SELECT s.target_id_, s.target_name_, s.target_name_en_, s.year_, s.month_, s.actual_ AS actual, s.budget_ AS budget FROM qf_financial_statistical s and s.enterprise_code_ = 'CIGR' and s.target_id_ = #{vo.targetId} and s.year_ = #{vo.year} and s.month_ >= #{vo.startMonth} AND #{vo.endMonth} >= s.month_ ORDER BY s.year_,s.month_ ASC SELECT s.actual_ytd_ FROM qf_financial_statistical s LEFT JOIN sys_subject_target t ON s.target_id_ = t.id_ WHERE t.code_ =#{targetCode} and s.enterprise_code_=#{enterpriseCode} and s.year_=#{lastYear} and s.month_='12' SELECT s.target_id_, s.target_name_, s.target_name_en_, s.actual_ AS actual, s.budget_ AS budget FROM qf_financial_statistical s left join sys_subject_target t on t.id_ = s.target_id_ and t.code_ in #{targetCode} and s.enterprise_code_ = #{vo.enterpriseCode} and s.year_ = #{vo.year} and s.month_ = #{vo.month} ORDER BY t.sn_ asc SELECT s.target_id_, s.target_name_, s.target_name_en_, s.actual_ytd_ AS actual, s.budget_ytd_ AS budget FROM qf_financial_statistical s left join sys_subject_target t on t.id_ = s.target_id_ and t.code_ in #{targetCode} and s.enterprise_code_ = #{vo.enterpriseCode} and s.year_ = #{vo.year} and s.month_ = #{vo.month} ORDER BY t.sn_ asc