| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107 |
- package com.goafanti.common.dao;
- import com.goafanti.admin.bo.AdminCustomerBo;
- import com.goafanti.admin.bo.AdminListBo;
- import com.goafanti.admin.bo.depCountBo;
- import com.goafanti.common.model.Department;
- import com.goafanti.organization.bo.OrganizationListOut;
- import org.apache.ibatis.annotations.Param;
- import java.util.List;
- public interface DepartmentMapper {
- int deleteByPrimaryKey(String id);
- int insert(Department record);
- int insertSelective(Department record);
- Department selectByPrimaryKey(String id);
- int updateByPrimaryKeySelective(Department record);
- int updateByPrimaryKey(Department record);
- List<OrganizationListOut> selectSuperId(@Param("hideSign")Integer hideSign);
- /**
- * 根据组织名称查组织编号
- */
- String selectDepNoByName(String name);
- /**
- * 根据上级组织查组织编号
- */
- String selectDepNo(String id);
- /**
- /**
- * 查询相同上级下编号数量
- */
- int selectDepNoCount(String superId);
- /**
- * 模糊查询负责人名称
- */
- List<AdminListBo> selectName(String name);
- OrganizationListOut selectAllById(String id);
- int deleteById(String id);
- String selectAdminNameById(String name);
- String selectIdByDepNo(String depNo);
- /**
- * 查询有相同上级组织的信息
- * @param superId
- * @return
- */
- List<OrganizationListOut> selectIDNBySuperId(String superId);
- int updateByNumber(OrganizationListOut olo);
- int selectCountBySuperId(String superId);
- String selectIdByName(String name);
- String selectNameById(String id);
- String selectDepNoById(String id);
- int selectUserById(String id);
- /**
- * 查询下级集合
- * @param superIds
- * @return
- */
- List<Department> selectSubDeps(@Param("superIds")String superIds);
- List<depCountBo> selectBysuperId(String id);
- List<depCountBo> selectBysuperName(String name);
- /**
- * 查询当前集合
- * @return
- */
- List<Department> selectCurrentDeps(@Param("aid")String aid);
- /**
- * 查询所有部门
- * @return
- */
- List<Department> selectAllDeps();
- /**
- * 查询最大编号
- * @param abbreviation
- * @return
- */
- String getMaxAbbreviation(String abbreviation);
- List<AdminCustomerBo> getDepAll(@Param("depId")String depId,
- @Param("adminName")String adminName, @Param("startTime")String startTime, @Param("endTime")String endTime);
- List<AdminCustomerBo> AlldepCount(@Param("depIds")List<Department> depIds ,@Param("startTime")String startTime, @Param("endTime")String endTime);
- }
|