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 selectSuperId(@Param("hideSign")Integer hideSign); /** * 根据组织名称查组织编号 */ String selectDepNoByName(String name); /** * 根据上级组织查组织编号 */ String selectDepNo(String id); /** /** * 查询相同上级下编号数量 */ int selectDepNoCount(String superId); /** * 模糊查询负责人名称 */ List selectName(String name); OrganizationListOut selectAllById(String id); int deleteById(String id); String selectAdminNameById(String name); String selectIdByDepNo(String depNo); /** * 查询有相同上级组织的信息 * @param superId * @return */ List 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 selectSubDeps(@Param("superIds")String superIds); List selectBysuperId(String id); List selectBysuperName(String name); /** * 查询当前集合 * @return */ List selectCurrentDeps(@Param("aid")String aid); /** * 查询所有部门 * @return */ List selectAllDeps(); /** * 查询最大编号 * @param abbreviation * @return */ String getMaxAbbreviation(String abbreviation); List getDepAll(@Param("depId")String depId, @Param("adminName")String adminName, @Param("startTime")String startTime, @Param("endTime")String endTime); List AlldepCount(@Param("depIds")List depIds ,@Param("startTime")String startTime, @Param("endTime")String endTime); }