package cn.com.lzt.sameleveltransfer.dao;

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

import org.jeecgframework.minidao.annotation.Arguments;
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 cn.com.lzt.sameleveltransfer.entity.SamelevelTransferDaoEntity;

/**
 * Minidao例子
 * 
 */
@MiniDao
public interface SameleveltransferMinidaoDao {
	
	@Arguments({"samelevelTransferDao","useridList","useridList1","orgidList", "page", "rows","authSql"})
	@ResultType(SamelevelTransferDaoEntity.class)
	public MiniDaoPage<SamelevelTransferDaoEntity> getAllEntities(SamelevelTransferDaoEntity samelevelTransferDao,List<String> useridList,List<String> useridList1,List<String> orgidList, int page, int rows,String authSql);

	@Arguments({"samelevelTransferDao","useridList","useridList1","orgidList", "page", "rows","authSql"})
	@ResultType(SamelevelTransferDaoEntity.class)
	public MiniDaoPage<SamelevelTransferDaoEntity> getAllActivitiEntities(SamelevelTransferDaoEntity samelevelTransferDao,List<String> useridList,List<String> useridList1,List<String> orgidList, int page, int rows,String authSql);


	/**
	 * 通过时间查询工作流已完成的数据
	 * @param userid 用户id
	 * @param inTime 调入日期
	 */
	@Sql("select * from t_bus_samelevel_transfer where bpm_status = 3 and to_days(in_time) = to_days(:inTime) and delete_flag = 0")
	public List<SamelevelTransferDaoEntity> getByDate(@Param("inTime")Date inTime);

	//获得部门下某岗位的人数
	@Arguments({"departId","postId"})
	public Integer getDepartPostUserCount(String departId,String postId);

	//获得父部门下某岗位的人数
	@Arguments({"departId","postId"})
	public Integer getParentDepartPostUserCount(String departId,String postId);
}