id_, name_, code_, address_, asset_nature_, registered_capital_, establish_date_, equity_ratio_, investment_ways_, investment_money_, investment_actual_money_, belongs_org_id_, belongs_org_name_, belongs_org_full_id_, directors_, executives_, visitors_, expatriate_, 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(investment_actual_money_), 0) as book_value_ FROM biz_asset_stock_info WHERE is_dele_='0' and asset_audit_='2' and belongs_org_full_id_ like '${fullId}%' SELECT asset_nature_ as assetNature, IFNULL(count(*),0) as count FROM biz_asset_stock_info WHERE is_dele_ = '0' AND asset_audit_ = '2' and belongs_org_full_id_ like '${fullId}%' GROUP BY asset_nature_