SysAgencyLeaderMapper.java 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. package com.ydtech.modules.admin.dao;
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import com.baomidou.mybatisplus.core.metadata.IPage;
  4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  5. import com.ydtech.modules.admin.model.SysAgencyLeader;
  6. import com.ydtech.modules.admin.model.dto.AgencyUserInsAreaDto;
  7. import com.ydtech.modules.admin.model.dto.DeptBalanceDto;
  8. import com.ydtech.modules.admin.model.dto.SysAgencyLeaderListDto;
  9. import com.ydtech.modules.admin.model.dto.SysAgencyLeaderPageDto;
  10. import com.ydtech.modules.admin.model.vo.AgencyUserInsAreaVo;
  11. import com.ydtech.modules.admin.model.vo.DeptBalanceVo;
  12. import org.apache.ibatis.annotations.Mapper;
  13. import org.apache.ibatis.annotations.Param;
  14. import java.math.BigDecimal;
  15. import java.util.HashMap;
  16. import java.util.List;
  17. /**
  18. * 配置机构负责人(AgencyLeader)表数据库访问层
  19. *
  20. * @author makejava
  21. * @since 2024-07-22 14:08:34
  22. */
  23. @Mapper
  24. public interface SysAgencyLeaderMapper extends BaseMapper<SysAgencyLeader> {
  25. List<SysAgencyLeader> getByUserIdList( @Param("userIds") List<String> collect);
  26. /**
  27. * @version
  28. * @author: hxl
  29. * @Date: 2024/8/31 12:42
  30. * @Description: 分页查询机构负责人
  31. */
  32. IPage<DeptBalanceDto> queryPage(Page page, @Param("vo") DeptBalanceVo deptBalanceVo);
  33. HashMap<String, BigDecimal> getBigDecimalNum(@Param("deptId") String deptId, @Param("createTime") String createTime,@Param("beginTime") String beginTime,@Param("endTime") String endTime);
  34. HashMap<String, Object> getAreaCompanyByUserId(@Param("orderNoList") List<String> orderNoList);
  35. List<AgencyUserInsAreaVo> queryUserInsAreaExcel(@Param("dto")AgencyUserInsAreaDto agencyUserInsAreaDto);
  36. /**
  37. * 正常员工
  38. * @param page
  39. * @param sysAgencyLeaderPageDto
  40. * @return
  41. */
  42. IPage<SysAgencyLeader> queryLeaderPage(Page page,@Param("dto") SysAgencyLeaderPageDto sysAgencyLeaderPageDto);
  43. int updateByIds(@Param("dto") SysAgencyLeaderListDto sysAgencyLeaderDto);
  44. }