package com.goafanti.common.dao; import com.goafanti.admin.bo.*; import com.goafanti.common.bo.AdminNoticeBo; import com.goafanti.common.model.Admin; import com.goafanti.common.model.AdminUserCount; import com.goafanti.common.model.Department; import com.goafanti.common.model.Role; import org.apache.ibatis.annotations.Param; import java.math.BigDecimal; 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,@Param("status")Integer status); 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); List selectRolesByUid(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 getAdminRoleNameList(String roleName); List getAdminRoleNamesList(List list); List getAdminRoleTypesList(List list); List getAdminRoleTypeList(String roleType); int addAdminContacts(AdminContacts a); int deleteFrequentContacts(String id); List getaidFrequentContacts(String id); /** * 获取属于某部门的角色 * @param depId * @param roleType * @return */ List listNameByDepAndName(@Param("depId")String depId,@Param("roleType")String roleType); List listAdminBydepIdAndRoleType(@Param("depId")String depId,@Param("roleType")String roleType); List selectBySuperId(String aid); Admin selectFinanceAdminByOrderDep(String orderDep); Admin selectFinanceAdminByAid(String aid); String getPermission(String transferId); List selectDepIdWithSpuerId(String superId); List getAdminRoleListByAid(String id); Admin selectByOpeid(String openid); AdminNoticeBo selectMyAndSuperBySuperId(String id); List getFinanceDep(String aid); List getLowerFinanceDep(String aid); int selectByAmbIdCount(String id); List selectAdminByRoleType(@Param("roleType") String roleType); List selectByDeps(@Param("depIds") List depIds,@Param("seniorStaff") Integer seniorStaff); List selectRoleTypeByid(String aid); AdminStatisticsBo adminStatisticsInfo(@Param("aid") String aid); AdminStatisticsBo adminStatisticsInfoByTime(@Param("aid") String aid, @Param("startTime") String startTime, @Param("endTime") String endTime); List thisMonthUser( @Param("firstDay")String firstDay, @Param("endDay")String endDay, @Param("aid")String aid); List selectAdminPublicRelease(String aid); List selectAdminUserFollow(String aid); List selectAdminOrder(String aid); Integer adminStatisticsPublicReleaseByAidAndTime(@Param("aid") String aid, @Param("startTime") String startTime, @Param("endTime") String endTime); BigDecimal addAdminContactsRangeReceivables(@Param("aid") String aid, @Param("startTime") String startTime, @Param("endTime") String endTime); ConsultantStatisticsBo consultantStatisticsInfo(@Param("aid") String aid,@Param("type") Integer type); ConsultantStatisticsBo consultantStatisticsInfoByTime(@Param("aid") String aid, @Param("startTime") String startTime, @Param("endTime") String endTime); List consultantthisMonthUser(@Param("firstDay")String firstDay, @Param("endDay")String endDay, @Param("aid")String aid); Admin selectOrderByFinanacial(String orderNo); }