id_, main_id_, fill_date_, bank_name_, enterprise_code_, enterprise_name_, enterprise_name_en_, long_src_, short_src_, currency_, rate_eur_, long_eur_, short_eur_, long_cny_, short_cny_, rate_cny_, cqlt_guarantee_, mutual_guarantee_, last_time_ SELECT m.fill_year_ as year, SUM(d.china_guarantee_) AS cqltGuarantee, sum(d.guarantee_amount_) AS eurMoney, sum(d.china_guarantee_) as cnyMoney FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ GROUP BY m.fill_year_ SELECT m.fill_quarter_ as quarter , SUM(d.china_guarantee_) AS cqltGuarantee, sum(d.guarantee_amount_) AS eurMoney, sum(d.china_guarantee_) as cnyMoney FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ and m.fill_year_ = #{vo.year} and m.fill_quarter_ >= #{vo.startQuarter} AND #{vo.endYear} >= m.fill_quarter_ GROUP BY m.fill_quarter_ SELECT m.fill_year_ as year, sum(d.guarantee_amount_) AS eurMoney, sum(d.china_guarantee_) as cnyMoney FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND d.enterprise_code_ = #{vo.enterpriseCode} GROUP BY m.fill_year_ SELECT m.fill_quarter_ as quarter, sum(d.guarantee_amount_) AS eurMoney, sum(d.china_guarantee_) as cnyMoney FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ and m.fill_quarter_ >= #{vo.startQuarter} AND #{vo.endQuarter} >= m.fill_quarter_ AND d.enterprise_code_ = #{vo.enterpriseCode} GROUP BY m.fill_quarter_ SELECT m.fill_year_ AS year, sum(d.guarantee_amount_) AS actual, sum(d.borrowing_balance_) AS budget FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_, max(m.fill_quarter_) AS fillQuarter FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ WHERE d.type_ = '1' AND d.enterprise_code_ = #{vo.enterpriseCode} and m.fill_year_ > #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ GROUP BY m.fill_year_ ) q ON q.fillQuarter = m.fill_quarter_ AND q.fill_year_ = m.fill_year_ WHERE d.type_ = '1' AND d.enterprise_code_ = #{vo.enterpriseCode} and m.fill_year_ > #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND q.fill_year_ IS NOT NULL GROUP BY m.fill_year_ ORDER BY m.fill_year_ ASC SELECT m.fill_year_ AS year, sum(d.loan_balance_) AS actual FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_, max(m.fill_quarter_) AS fillQuarter FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ WHERE d.type_ = '2' AND d.enterprise_code_ = #{vo.enterpriseCode} and m.fill_year_ > #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ GROUP BY m.fill_year_ ) q ON q.fillQuarter = m.fill_quarter_ AND q.fill_year_ = m.fill_year_ WHERE d.type_ = '2' AND q.fill_year_ IS NOT NULL AND d.enterprise_code_ = #{vo.enterpriseCode} and m.fill_year_ > #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ GROUP BY m.fill_year_ ORDER BY m.fill_year_ ASC SELECT d.enterprise_code_, sum(d.guarantee_amount_) AS actual, sum(d.borrowing_balance_) AS budget FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_,max(m.fill_quarter_) AS fillQuarter FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ WHERE d.type_ = '1' and m.fill_year_ = #{vo.year} GROUP BY m.fill_year_ ) q ON q.fillQuarter = m.fill_quarter_ AND q.fill_year_ = m.fill_year_ WHERE d.type_ = '1' AND q.fill_year_ IS NOT NULL and m.fill_year_ = #{vo.year} GROUP BY d.enterprise_code_ SELECT d.enterprise_code_, sum(d.loan_balance_) AS actual FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_,max(m.fill_quarter_) AS fillQuarter FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ WHERE d.type_ = #{dataType} and m.fill_year_ = #{vo.year} GROUP BY m.fill_year_ ) q ON q.fillQuarter = m.fill_quarter_ AND q.fill_year_ = m.fill_year_ WHERE d.type_ = #{dataType} AND q.fill_year_ IS NOT NULL and m.fill_year_ = #{vo.year} GROUP BY d.enterprise_code_ SELECT d.* FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ and d.type_ = #{dataType} and m.fill_year_ = #{vo.year} and m.fill_quarter_ = #{vo.quarter} AND d.enterprise_code_ = #{vo.enterpriseCode} SELECT d.early_uarantee_money_ FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m on d.main_id_ = m.id_ WHERE m.fill_year_= #{year} and d.early_uarantee_money_ is NOT NULL LIMIT 1 SELECT q.fill_year_ AS YEAR, d.guarantee_amount_ AS actual, d.borrowing_balance_ AS budget, d.bank_name_ FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_, max(m.fill_quarter_) AS fillQuarter FROM qf_finance_loan_d d LEFT JOIN qf_finance_loan_m m ON m.id_ = d.main_id_ WHERE d.type_ = #{dataType} AND bank_name_ LIKE '%汇丰银行%' and m.fill_year_ > #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ GROUP BY m.fill_year_ ) q ON q.fillQuarter = m.fill_quarter_ AND q.fill_year_ = m.fill_year_ WHERE d.type_ = #{dataType} AND bank_name_ LIKE '%汇丰银行%' AND q.fill_year_ IS NOT NULL and m.fill_year_ > #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ ORDER BY m.fill_year_ ASC