id_, type_id_, name_, code_, model_, manufacturer_, min_number_, unit_, price_, belongs_org_id_, belongs_org_name_, belongs_org_full_id_, remark_, 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 * from (SELECT b.*,t.name_ as typeName FROM biz_asset_fixed_info b LEFT JOIN biz_asset_fixed_type t on t.id_ = b.type_id_ ) s ${ew.customSqlSegment} SELECT IFNULL(sum(b.amount_), 0) as book_value_ FROM biz_asset_fixed_info a LEFT JOIN biz_asset_fixed_inventory b on b.fixed_id_ = a.id_ WHERE a.is_dele_ = '0' and a.belongs_org_full_id_ like '${fullId}%' select (case when 100000>a.amount_ then '10万以下' when 1000000>a.amount_ and a.amount_>100000 then '10-100万元' when 5000000>a.amount_ and a.amount_ > 1000000 then '100-500万元' when 10000000>a.amount_ and a.amount_ >5000000 then '500-1000万元' when 50000000>a.amount_ and a.amount_ >10000000 then '1000-5000万元' else '5000万元以上' end ) as level, IFNULL(count(*),0) as count from biz_asset_fixed_inventory a LEFT JOIN biz_asset_fixed_info f on f.id_ = a.fixed_id_ WHERE f.is_dele_ = '0' and f.belongs_org_full_id_ like '${fullId}%' GROUP BY LEVEL