Merge branch 'score-shop' of http://120.27.238.55:7000/r/xzx into score-shop
| | |
| | | package com.xzx.gc.entity; |
| | | |
| | | import com.xzx.gc.common.entity.BaseEntity; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import javax.persistence.Table; |
| | |
| | | |
| | | @Data |
| | | @Table(name = "xzx_jhy_order_items") |
| | | @ApiModel(value = "JhyOrderItems", description = "订单详情") |
| | | public class JhyOrderItems extends BaseEntity { |
| | | |
| | | private Long orderId; |
| | | |
| | | @ApiModelProperty(value="标题") |
| | | private String title; |
| | | |
| | | @ApiModelProperty(value="价格") |
| | | private BigDecimal price; |
| | | |
| | | @ApiModelProperty(value="图片") |
| | | private String picture; |
| | | |
| | | @ApiModelProperty(value="备注") |
| | | private String remark; |
| | | |
| | | @ApiModelProperty(value="重量") |
| | | private BigDecimal weight; |
| | | |
| | | @ApiModelProperty(value="积分") |
| | | private String score; |
| | | |
| | | @ApiModelProperty(value="类型") |
| | | private Long itemType; |
| | | } |
| | |
| | | SELECT |
| | | a.id id, |
| | | a.order_no orderNo, |
| | | b.nick_name name, |
| | | b.nick_name nickName, |
| | | b.mobile_phone mobilePhone, |
| | | a.area area, |
| | | a.address address, |
| | |
| | | d.mobile mobile, |
| | | date_format(a.receiving_time,'%Y-%m-%d %H:%i:%S') receivingTime, |
| | | a.remark remark, |
| | | 'a. COMMENT' comments, |
| | | a. COMMENT comments, |
| | | a.score score, |
| | | a.is_anonymous isAnonymous |
| | | FROM |
| | |
| | | @ApiModelProperty(value = "身份证正面") |
| | | private String cardPos; |
| | | |
| | | @ApiModelProperty(value = "是否集物员") |
| | | @ApiModelProperty(value = "是否集货员 1-是2-否") |
| | | private String isJhy; |
| | | |
| | | @ApiModelProperty(value = "状态") |
| | | @ApiModelProperty(value = "审核状态 1-待审核 2-审核通过 3-审核拒绝") |
| | | private Integer status; |
| | | |
| | | @ApiModelProperty(value = "申请时间") |
| | |
| | | </select> |
| | | |
| | | <select id="selectJhyInfoList" resultType="com.xzx.gc.user.vo.JhyInfoListVo"> |
| | | select * from xzx_jhy_info |
| | | select *,CREATED_TIME createTime from xzx_jhy_info |
| | | <where> |
| | | 1=1 |
| | | <if test="record.name != null and record.name != ''"> |
| | | and (username like CONCAT(CONCAT(#{record.name}, '%'), '%') or phone=#{record.phone}) |
| | | </if> |
| | | <if test="record.isJhy != null and record.name != ''"> |
| | | <if test="record.isJhy != null and record.isJhy != ''"> |
| | | and is_jhy=#{record.isJhy} |
| | | </if> |
| | | <if test="record.status != null"> |