/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
package org.springblade.modules.information.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.apache.ibatis.annotations.Param;
|
import org.springblade.modules.information.entity.Information;
|
import org.springblade.modules.information.vo.InformationVO;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* Mapper 接口
|
*
|
* @author BladeX
|
* @since 2021-07-07
|
*/
|
public interface InformationMapper extends BaseMapper<Information> {
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param information
|
* @return
|
*/
|
List<InformationVO> selectInformationPage(IPage<InformationVO> page, @Param("information")InformationVO information);
|
void insertIn(@Param("information")Information information);
|
void deleteIn(@Param("departmentid")String departmentid);
|
void deleteSh(@Param("deptId")String deptId);
|
void deleteMe(@Param("deptId")String deptId);
|
Map selectCount(String departmentid);
|
List<Map<Object,String>> selectInCount();
|
void deleteDept(@Param("id") String id);
|
List<Map<Object,Object>> selectExtype(String deptid,String jurisdiction);
|
List<Map<Object,Object>> selectHold(String deptid,String jurisdiction);
|
List<Map<Object,Object>> selectDis(String deptid);
|
List<Map<Object,Object>> selectDisp(String deptid,String jurisdiction);
|
List<Map<Object,Object>> selectSoil(String deptid,String jurisdiction);
|
|
/**
|
* 查询培训单位信息(可以报名)
|
* @param page
|
* @param information 保安单位信息对象
|
* @return
|
*/
|
List<InformationVO> securityPage(IPage<InformationVO> page, @Param("information") InformationVO information);
|
List queryYearKh(@Param("year") String year,@Param("jurisdiction")String jurisdiction,@Param("deptid")String deptid);
|
|
/**
|
* 根据deptid 删除用户信息
|
* @param deptId
|
*/
|
void deleteUserByDeptId(@Param("deptId") String deptId);
|
}
|
