| | |
| | | @ApiModelProperty(value="联系人/手机号") |
| | | private String account; |
| | | |
| | | @ApiModelProperty(value="手机号") |
| | | private String accountPhone; |
| | | |
| | | @ApiModelProperty(value="状态 1-待接单2-服务中3-已收款4-待入库5-已完成6-已取消") |
| | | private Integer status; |
| | | |
| | |
| | | import cn.hutool.core.bean.BeanUtil; |
| | | import cn.hutool.core.collection.CollUtil; |
| | | import cn.hutool.core.convert.Convert; |
| | | import cn.hutool.core.util.StrUtil; |
| | | import com.github.pagehelper.PageHelper; |
| | | import com.github.pagehelper.PageInfo; |
| | | import com.xzx.gc.common.utils.StringUtils; |
| | |
| | | |
| | | public Map<String, Object> queryOrderList(QueryJhyOrderListDto model) { |
| | | PageHelper.startPage(model.getPage(), model.getLimit()); |
| | | String accountPhone = model.getAccount(); |
| | | String name = StrUtil.isEmpty(model.getAccount())?model.getAccount():StringUtils.encode(model.getAccount()); |
| | | model.setAccount(name); |
| | | model.setAccountPhone(accountPhone); |
| | | List<QueryJhyOrderListVo> maps = jhyOrderMapper.queryOrderList(model); |
| | | if(CollUtil.isNotEmpty(maps)){ |
| | | for(QueryJhyOrderListVo queryJhyOrderListVo : maps){ |
| | |
| | | private IdUtils idUtils; |
| | | |
| | | public Map<String, Object> queryOrderList(QueryOrderListDto model) { |
| | | String name = model.getName(); |
| | | String name = StrUtil.isEmpty(model.getName())?model.getName():StringUtils.encode(model.getName()); |
| | | String orderNo = model.getOrderNo(); |
| | | Integer status = model.getStatus() == null ? 0 : model.getStatus(); |
| | | Date createdTimeStart = model.getCreatedTimeStart(); |
| | |
| | | </if> |
| | | <if test="record.account != null and record.account != ''"> |
| | | and ( b.nick_name like concat('%',#{record.account},'%') |
| | | or b.mobile_phone like concat('%',#{record.account},'%') ) |
| | | or b.mobile_phone like concat('%',#{record.accountPhone},'%') ) |
| | | </if> |
| | | <if test="record.reserveTimeStart != null"> |
| | | and a.reserve_time >= #{record.reserveTimeStart} |
| | |
| | | <where> |
| | | 1=1 |
| | | <if test="record.name != null and record.name != ''"> |
| | | and (username like CONCAT(CONCAT(#{record.name}, '%'), '%') or phone=#{record.phone}) |
| | | and (username like concat('%',#{record.name},'%') |
| | | or phone like concat('%',#{record.phone},'%') ) |
| | | </if> |
| | | <if test="record.isJhy != null and record.isJhy != ''"> |
| | | and is_jhy=#{record.isJhy} |