From 491ad3f8d75f4254e0bb3dbc8544169e7e76f7a5 Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Wed, 30 Jun 2021 16:01:22 +0800 Subject: [PATCH] modify --- gc-order/src/main/resources/mapper/order/JhyOrderItemsMapper.xml | 4 +++- gc-core/src/main/java/com/xzx/gc/entity/JhyOrderItems.java | 3 +++ 2 files changed, 6 insertions(+), 1 deletions(-) diff --git a/gc-core/src/main/java/com/xzx/gc/entity/JhyOrderItems.java b/gc-core/src/main/java/com/xzx/gc/entity/JhyOrderItems.java index 6401db0..d446436 100644 --- a/gc-core/src/main/java/com/xzx/gc/entity/JhyOrderItems.java +++ b/gc-core/src/main/java/com/xzx/gc/entity/JhyOrderItems.java @@ -35,4 +35,7 @@ @ApiModelProperty(value="类型") private Long itemType; + + @ApiModelProperty(value = "单位") + private String itemUnit; } diff --git a/gc-order/src/main/resources/mapper/order/JhyOrderItemsMapper.xml b/gc-order/src/main/resources/mapper/order/JhyOrderItemsMapper.xml index f8eb86f..df9edd4 100644 --- a/gc-order/src/main/resources/mapper/order/JhyOrderItemsMapper.xml +++ b/gc-order/src/main/resources/mapper/order/JhyOrderItemsMapper.xml @@ -3,6 +3,8 @@ <mapper namespace="com.xzx.gc.order.mapper.JhyOrderItemsMapper"> <select id="selectOrderItems" resultType="com.xzx.gc.entity.JhyOrderItems"> - select * from xzx_jhy_order_items where order_id=#{orderId} + select a.*, b.item_unit itemUnit from xzx_jhy_order_items a + left join xzx_sys_environmental_info b on a.item_type=b.id + where a.order_id=#{orderId} </select> </mapper> \ No newline at end of file -- Gitblit v1.9.1