id_, name_, deal_type_, deal_org_, contract_money_, year_earnings_rate_, return_type_, date_limit_, start_date_, end_date_, risk_measures_, loan_status_, belongs_org_id_, belongs_org_name_, belongs_org_full_id_, remark_, asset_audit_, create_by_, create_name_, create_org_id_, create_org_name_, create_dept_id_, create_dept_name_, create_time_, update_by_, update_name_, update_org_id_, update_org_name_, update_dept_id_, update_dept_name_, update_time_, is_dele_, last_time_, tenant_id_ SELECT IFNULL( sum(contract_money_), 0) as book_value_ FROM biz_asset_loan_info WHERE is_dele_='0' and asset_audit_='2' and belongs_org_full_id_ like '${fullId}%' SELECT DATE_FORMAT(l.return_date_, '%m') AS month, IFNULL(sum(l.add_up_money_),0) AS addUpMoney_ FROM BIZ_ASSET_LOAN_INTEREST l LEFT JOIN biz_asset_loan_info a on a.id_ = l.loan_id_ WHERE is_dele_='0' and asset_audit_='2' and belongs_org_full_id_ like '${fullId}%' and YEAR (l.return_date_) = #{year} GROUP BY month ORDER BY month