| | |
|---|
| | | |
|---|
| | | <select id="queryOperaIteml" parameterType="com.xzx.gc.model.admin.ItemModel" |
|---|
| | | resultType="com.xzx.gc.model.admin.ItemModel"> |
|---|
| | | select a.id,a.title,a.del_flag as delFlag,a.show_flag as showFlag,a.item_unit as itemUnit, |
|---|
| | | select a.id,a.title,a.del_flag as delFlag,a.show_flag as showFlag,a.item_unit as itemUnit,a.min_price minPrice,a.max_price maxPrice, |
|---|
| | | (select b.title from xzx_sys_environmental_info b where b.id=a.parent_id) as type, |
|---|
| | | a.price as price,a.second_price as secondPrice,IFNULL(a.put_storage_price,0.00) as putStoragePrice,a.sort as |
|---|
| | | sort, |
|---|
