package cn.com.lzt.leave.dao;

import java.util.Date;
import java.util.List;
import java.util.Map;

import org.jeecgframework.minidao.annotation.MiniDao;
import org.jeecgframework.minidao.annotation.Param;
import org.jeecgframework.minidao.annotation.ResultType;
import org.jeecgframework.minidao.annotation.Sql;
import org.jeecgframework.minidao.pojo.MiniDaoPage;
import org.jeecgframework.web.system.pojo.base.TSUserOrg;

import cn.com.lzt.leave.dto.LeaveDto;

/**
 * Minidao例子
 * 
 */
@MiniDao
public interface LeaveMinidaoDao {
	
	@ResultType(LeaveDto.class)
	public MiniDaoPage<LeaveDto> getAllEntities(@Param("leaveDto") LeaveDto leaveDto,@Param("useridList")List<String> useridList,
			@Param("useridList1")List<String> useridList1,@Param("orgidList")List<String> orgidList,@Param("page")int page, @Param("rows")int rows,@Param("authSql")String authSql);


	@ResultType(LeaveDto.class)
	public MiniDaoPage<LeaveDto> getAllActivitiEntities(@Param("leaveDto") LeaveDto leaveDto,@Param("useridList")List<String> useridList,
												@Param("useridList1")List<String> useridList1,@Param("orgidList")List<String> orgidList,@Param("page")int page, @Param("rows")int rows,@Param("authSql")String authSql);

	/**
	 * 通过时间查询工作流已完成的数据
	 * @param userid 用户id
	 * @param leaveDate 申请离职时间
	 */
	@Sql("select * from t_bus_leave where bpm_status = 3 and to_days(leave_date) = to_days(:leaveDate) and delete_flag = 0")
	public List<LeaveDto> getByDate(@Param("leaveDate")Date leaveDate);
	
	/**
	 * 通过时间查询工作流已完成的数据
	 * @param userid 用户id
	 * @param leaveDate 申请离职时间
	 */
	@Sql("select * from t_s_user_org where user_id = :userid and ifpluralism = 0 and status = 0")
	public List<TSUserOrg> getByuserid(@Param("userid")String userid);

	/**
	 * 获得用户所在部门同类型证书数量
	 * @param depId
	 * @param userid
	 * @return
	 */
	public List<Map<String,Object>> getDepCertByUser(@Param("depid") String depId,@Param("userid") String userid);
}