| | |
| | | */ |
| | | @ApiModelProperty("理由") |
| | | private String reason; |
| | | |
| | | public void setDonateName(String donateName) { |
| | | this.donateName = donateName.charAt(0)+"**"; |
| | | } |
| | | } |
| | |
| | | </insert> |
| | | |
| | | <select id="pageList" resultType="com.panzhihua.common.model.vos.community.warehouse.ComActWarehouseOperationVO"> |
| | | select t.*,t1.image,t1.item,t1.`name` as donateName,t2.actual_time,t2.apply_name,t2.reason,t1.is_anonymous from com_act_warehouse_operation t LEFT JOIN com_act_warehouse_donates t1 on t.goods_id =t1.id LEFT JOIN com_act_warehouse_apply t2 on t.apply_id = t2.id |
| | | select t.*,t1.image,t1.item,t1.`name` as donateName,t2.actual_time,t2.apply_name,t2.reason,t1.is_anonymous,t2.goods_num from com_act_warehouse_operation t LEFT JOIN com_act_warehouse_donates t1 on t.goods_id =t1.id LEFT JOIN com_act_warehouse_apply t2 on t.apply_id = t2.id |
| | | <where> |
| | | t.type = 2 |
| | | </where> |