zq-erp/src/main/java/com/matrix/system/fenxiao/dao/ShopSalesmanApplyDao.java
@@ -4,7 +4,7 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.matrix.system.fenxiao.entity.ShopSalesmanApply; import com.matrix.system.shopXcx.vo.SalesmanVo; import org.apache.ibatis.annotations.Param; /** * @description 推广员申请记录 @@ -13,6 +13,6 @@ */ public interface ShopSalesmanApplyDao extends BaseMapper<ShopSalesmanApply> { IPage<SalesmanVo> selectInvitationuserList(Page<SalesmanVo> page); IPage<ShopSalesmanApply> selectInvitationuserInPage(@Param("openId") String openId, Page<ShopSalesmanApply> page); } zq-erp/src/main/java/com/matrix/system/shopXcx/api/action/WxSalesmanAction.java
@@ -23,7 +23,6 @@ import com.matrix.system.fenxiao.entity.ShopSalesmanApply; import com.matrix.system.fenxiao.service.ShopSalesmanApplyService; import com.matrix.system.shopXcx.api.WeChatApiTools; import com.matrix.system.shopXcx.vo.SalesmanVo; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiResponse; @@ -205,9 +204,9 @@ @ApiResponse(code = 200, message = "ok", response = BasePageDto.class) }) AjaxResult getInvitationuserList(@RequestBody BasePageDto pageDto) { Page<SalesmanVo> page=new Page<>(pageDto.getPageNum(),pageDto.getPageSize()); IPage<SalesmanVo> shopSalesmanApplyIPage = salesmanApplyDao.selectInvitationuserList(page); BizUser loginUser = redisUserLoginUtils.getLoginUser(BizUser.class); Page<ShopSalesmanApply> page=new Page<>(pageDto.getPageNum(),pageDto.getPageSize()); IPage<ShopSalesmanApply> shopSalesmanApplyIPage = salesmanApplyDao.selectInvitationuserInPage(loginUser.getOpenId(), page); AjaxResult result=AjaxResult.buildSuccessInstance(shopSalesmanApplyIPage.getRecords()); return result; zq-erp/src/main/resources/mybatis/mapper/fenxiao/ShopSalesmanApplyDao.xml
@@ -34,8 +34,29 @@ <result property="companyId" column="company_id" /> </resultMap> <select id="selectInvitationuserList" resultType="com.matrix.system.fenxiao.entity.ShopSalesmanApply"> <select id="selectInvitationuserInPage" resultType="com.matrix.system.fenxiao.entity.ShopSalesmanApply"> select * from shop_salesman_apply <!-- SELECT a.nick_name, a.avatar_url, a.phone_number, ( SELECT IFNULL(sum(IFNULL( b.amount, 0 )),0) FROM shop_salesman_order b WHERE b.user_id = a.open_id AND b.sales_user_id = #{openId} ) AS revenueAmount, ( SELECT count( * ) FROM shop_salesman_order c WHERE c.user_id = a.open_id AND c.sales_user_id = #{openId} ) AS orderCount FROM biz_user a WHERE a.parent_open_id = #{openId} AND a.is_sales = 1 --> </select> </mapper>