|  |  | 
 |  |  |     @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} |