package cn.com.lzt.userwage.dao;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

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.arrangeduty.dto.ProjectDepartDto;
import cn.com.lzt.arrangedutyoperate.dto.UserAndUserPersonnelDto;
import cn.com.lzt.userwage.dto.UserWageDto;
import cn.com.lzt.userwage.dto.UserWageViewDto;
import cn.com.lzt.userwage.entity.UserWageEntity;

/**
 * Minidao例子
 * 
 */
@MiniDao
public interface UserWageMinidaoDao {
	
	@Arguments({"userAndUserPersonnelDto", "authSql"})
	@ResultType(UserAndUserPersonnelDto.class)
	public List<UserAndUserPersonnelDto> getUserAndUserPersonnelNoPage(UserAndUserPersonnelDto userAndUserPersonnelDto, String authSql);
	
	/**
	 * 工资一览明细列表
	 * @param userWageDto,@Param("page")
	 * @param authSql
	 * @return
	 */
	@ResultType(UserWageDto.class)
	public List<UserWageDto> getAllEntities(@Param("userWageDto")UserWageDto userWageDto,@Param("uidList")List<String> uidList,@Param("moth")String moth,@Param("authSql")String authSql);
	
	@ResultType(UserWageDto.class)
	public MiniDaoPage<UserWageDto> getPagedEntities(@Param("userWageDto")UserWageDto userWageDto,@Param("uidList")List<String> uidList,@Param("moth")String moth,@Param("page")int page,@Param("rows")int rows,@Param("authSql")String authSql);

	/**
	 *个人月度工资明细
	 * @return
	 */
	@ResultType(UserWageDto.class)
	public List<UserWageDto> getUserWage(@Param("userId")String userId,@Param("startMonth")String startMonth,@Param("endMonth")String endMonth);

	/**
	 *个人最近月度工资明细
	 * @return
	 */
	@ResultType(UserWageDto.class)
	public List<UserWageDto> getUserWageLast(@Param("userId")String userId,@Param("limit")Integer limit);

	/**
	 * 工资核算列表
	 * @param userWageDto
	 * @param authSql
	 * @return
	 */
	@ResultType(UserWageDto.class)
	public List<UserWageDto> getAll(@Param("userWageDto")UserWageDto userWageDto,@Param("uidList")List<String> uidList,@Param("moth")String moth,@Param("authSql")String authSql);
	
	/**
	 * 查询工资核算集合
	 * @param userWageDto
	 * @return
	 */
	@ResultType(Map.class)
	Map<String,Integer> getMoneySUM(@Param("userWageDto")UserWageDto userWageDto, @Param("uidList")List<String> uidList, @Param("moth")String moth);

	/**
	 * 按预算实体统计确认工资
	 * @param userWageDto
	 * @return
	 */
	@ResultType(UserWageDto.class)
	List<UserWageDto> getBudgetEntityMoneySUM(@Param("userWageDto")UserWageDto userWageDto);

	/**
	 * 查询工资核算一览
	 * @param userWageViewDto
	 * @param page
	 * @param rows
	 * @param authSql
	 * @return
	 */
	@ResultType(UserWageViewDto.class)
	public MiniDaoPage<UserWageViewDto> getViewEntities(@Param("userWageViewDto")UserWageViewDto userWageViewDto,@Param("uidList")List<String> uidList, @Param("page")int page, @Param("rows")int rows, @Param("authSql")String authSql);

	/**
	 * 查询工资核算集合
	 * @param userWageDto
	 * @return
	 */
	@ResultType(Map.class)
	Map<String,Integer> getMoneyViewSUM(@Param("userWageViewDto")UserWageViewDto userWageViewDto,@Param("uidList")List<String> uidList);
	
	/**
	 * 查询员工的工资策略
	 * @param userid
	 * @param monthly
	 * @return
	 */
	@Sql("select * from t_bus_user_wage where userid = :userid and monthly = :monthly")
	public List<UserWageEntity> getByuserid(@Param("userid")String userid,@Param("monthly")String monthly);
	
	
	/**
	 * 判断员工是否有职务和工资策略
	 * @param userid
	 * @return
	 */
	@Sql("SELECT w.basic_wage as basicWage FROM t_bus_user_personnel p"+
			" LEFT JOIN t_bus_duties d on p.belong_dutiesid = d.id and d.status = 0 and d.delete_flag = 0"+
			" LEFT JOIN t_bus_wagestrategy w on w.dutiesid = d.id and w.status = 0 and w.delete_flag = 0"+
			" where p.userid = :userid")
	public Map<String,String> isDuties(@Param("userid")String userid);
	
	/**
	 * 查询所有项目信息
	 * @author liujie
	 * @param projectDepartDto
	 * @param authSql
	 * @return
	 */
	@Arguments({"projectDepartDto", "authSql"})
	@ResultType(ProjectDepartDto.class)
	public List<ProjectDepartDto> getProjectDepartAll(ProjectDepartDto projectDepartDto, String authSql);
}