package com.goafanti.common.dao; import com.goafanti.admin.bo.AdminContacts; import com.goafanti.admin.bo.AdminListBo; import com.goafanti.common.model.Admin; import com.goafanti.common.model.Role; import org.apache.ibatis.annotations.Param; import java.util.List; public interface AdminMapper { int deleteByPrimaryKey(String id); int insert(Admin record); int insertSelective(Admin record); Admin selectByPrimaryKey(String id); int updateByPrimaryKeySelective(Admin record); int updateByPrimaryKey(Admin record); Admin selectByMobile(String mobile); List selectRolesByPrimaryKey(String uid); List selectCognizanceConsultant(); List selectCognizancePrincipal(); List selectPatentAuthor(); List selectPatentPrincipal(); List selectCopyrightConsultant(); List selectCopyrightPrincipal(); List selectTechprojectConsultant(); List selectTechprojectPrincipal(); List selectRoleByPrimaryKey(String uid); List selectAccoutManager(); List selectTechnician(); List selectSalesman(); List selectContractManager(); List selectTechBroder(); List listAdminSelectBySuperAdmin(); List listAdminSelectByAreaAdmin(@Param("provinceList")List provinceList, @Param("cityList")List cityList); List listAdminByName(@Param("name")String name); int insertn(Admin record); String selectUserNoBySuperiorId(String superiorId); int selectCountBySuperiorId(String superiorId); String selectIdByUserNo(String userNo); Admin selectAllByid(@Param("id") String id); String selectNameByid(String id); ListselectRolesByUid(String id); ListselectRolesIdByUid(String id); String selectStatusByMobile(@Param("mobile")String mobile); int deleteById(String id); List selectIDNBySuperiorId(String superiorId); String selectUserNoById(String superiorId); int updateByUserNo(Admin record); ListselectIdBySuperiorId(String superiorId); /** * 查询下级人员 * @param adminId * @return */ List selectSubList(@Param("adminId")String adminId); /** * @return */ Admin selectAdminByRoleId(@Param("roleId")String roleId); /** * 查询部门下的员工 * @param departmentId * @param name * @return */ List selectDepartmentStaff(String departmentId, String name); Admin selectAdminName(@Param("name")String name); List selectAllAdmin(@Param("depId")String depId); int updateLockIds(@Param("lockIds")String lockIds); int getCountById(String id); AdminListBo getDeptNameByAid(String id); List getAdminRoleList(String roleName); int addAdminContacts(AdminContacts a); int deleteFrequentContacts(String id); List getaidFrequentContacts(String id); List listNameByDepAndName(@Param("depId")String depId,@Param("roleName")String roleName); List selectBySuperId(String aid); Admin selectFinanceAdminByOrderDep(String orderDep); String getPermission(String transferId); List selectDepIdWithSpuerId(String superId); List getAdminRoleListByAid(String id); Admin selectByOpeid(String openid); Admin selectGetSuper(String aid); String getFinanceDep(String aid); List getLowerFinanceDep(String aid); }