| | |
| | | @TableField("create_time") |
| | | private LocalDateTime createTime; |
| | | |
| | | @ApiModelProperty(value = "店长姓名") |
| | | @TableField(exist = false) |
| | | private String managerName; |
| | | |
| | | |
| | | } |
| | |
| | | Page<Shop> page = new Page<>(); |
| | | page.setCurrent(PageNum); |
| | | page.setSize(pageSize); |
| | | IPage<Shop> shopIPage = shopMapper.selectShopList(page, shop); |
| | | return shopIPage; |
| | | return shopMapper.selectShopList(page, shop); |
| | | } |
| | | |
| | | @Override |
| | |
| | | ts.id, |
| | | ts.`name`, |
| | | ts.business_date, |
| | | tau.`name` managerName, |
| | | ts.start_time, |
| | | ts.end_time, |
| | | ts.phone, |
| | | ts.address, |
| | | ts.`status` |
| | | ts.`status`, |
| | | ts.shop_manager |
| | | FROM |
| | | `qijisheng_other`.t_shop ts |
| | | LEFT JOIN `qijisheng_account`.t_app_user tau ON ts.app_user_id = tau.id |
| | | t_shop ts |
| | | <where> |
| | | ts.del_flag = 0 |
| | | <if test="shop.name != null and shop.name != ''"> |
| | | and ts.name like concat('%',#{shop.name},'%') |
| | | </if> |
| | | <if test="shop.managerName != null and shop.managerName != ''"> |
| | | and tau.name like concat('%',#{shop.managerName},'%') |
| | | <if test="shop.shopManager != null and shop.shopManager != ''"> |
| | | and ts.shop_manager like concat('%',#{shop.shopManager},'%') |
| | | </if> |
| | | <if test="shop.phone != null and shop.phone != ''"> |
| | | and ts.phone like concat('%',#{shop.phone},'%') |