package com.product.administration.service;
import com.product.administration.config.CmnConst;
import com.product.common.lang.StringUtils;
import com.product.core.dao.BaseDao;
import com.product.core.entity.DataTableEntity;
import com.product.core.entity.FieldSetEntity;
import com.product.core.exception.BaseException;
import com.product.core.permission.PermissionService;
import com.product.core.service.support.AbstractBaseService;
import com.product.core.service.support.QueryFilterService;
import com.product.core.spring.context.SpringMVCContextHolder;

import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.Date;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

/**
 * Copyright © LX-BASE
 *
 * @Title: LeaveRequestService
 * @Project: LX-BASE-SERVER
 * @Date: 2020-11-13 09:27:35
 * @Author: Xin.Luo
 * @Description: 请假申请
 */
@Component
public class LeaveRequestService extends AbstractBaseService {

	@Autowired
	private BaseDao baseDao;
	@Autowired
	PermissionService permissionService;
	@Autowired
	QueryFilterService queryFilterService;

	/**
	 * @Date: 2020-03-30 14:10
	 * @Author: ZhouJie
	 * 请假申请列表
	 */
	public DataTableEntity getLeaveRequestList(FieldSetEntity fs) throws BaseException {
		String filter=fs.getString("filter");
		String dataFilter = permissionService.getDataFilter(fs.getTableName(),CmnConst.CREATED_BY);
		if(!StringUtils.isEmpty(dataFilter)){
			filter += " and "+dataFilter;
		}
		DataTableEntity dt = baseDao.listTable(CmnConst.PRODUCT_SYS_ASK_FOR_LEAVE,filter,null,null,"id desc",fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE),false);
		baseDao.loadPromptData(dt);
		return dt;
	}
	/**
	 * @Date: 2020-03-30 14:46
	 * @Author: ZhouJie
	 * 请假申请详情
	 */
	public FieldSetEntity getLeaveRequestInfo(FieldSetEntity fs) throws BaseException {
		return baseDao.listInternationDataTable(baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_ASK_FOR_LEAVE, fs.getString(CmnConst.UUID), true),null);
	}
	/**
	 * @Date: 2020-03-30 15:32
	 * @Author: ZhouJie
	 * 请假申请保存
	 */
	public String saveLeaveRequest(FieldSetEntity fs) throws BaseException {
		DataTableEntity dataTableEntity = baseDao.listTable(CmnConst.PRODUCT_SYS_ASK_FOR_LEAVE, " uuid  not in (?) and user_id=? and ((start_time<=? and end_time>=?) or(start_time<=? and end_time>=?))"
				, new String[]{StringUtils.isEmpty(fs.getUUID())?"":fs.getUUID(), fs.getString("user_id"), fs.getString("start_time"), fs.getString("start_time"), fs.getString("end_time"), fs.getString("end_time")});
        if (dataTableEntity.getRows()>0){
			return "1";
		}else {
			if (StringUtils.isEmpty(fs.getString(CmnConst.UUID))) {
				fs.setValue("created_by", SpringMVCContextHolder.getCurrentUser().getUser_id());
				fs.setValue("created_utc_datetime", new Date());
				fs.setValue("org_level_uuid", SpringMVCContextHolder.getCurrentUser().getOrg_level_uuid());
				return baseDao.add(fs);
			} else {
				fs.setValue("updated_by", SpringMVCContextHolder.getCurrentUser().getUser_id());
				fs.setValue("updated_utc_datetime", new Date());
				baseDao.update(fs);
				return fs.getString(CmnConst.UUID);
			}

		}
	}

	/**
	 * 计算请假天数
	 * @param fs
	 * @return
	 * @throws BaseException
	 */
	public FieldSetEntity getDay(FieldSetEntity fs) throws BaseException {
		DataTableEntity dt = baseDao.listTable(com.product.org.admin.config.CmnConst.PRODUCT_SYS_COMPANY_HOLIDAY, "date_holiday >=? and date_holiday<=?", new String[]{fs.getString("start_time"), fs.getString("end_time")});
		String dateStr1 = fs.getString("start_time");
		String dateStr2 = fs.getString("end_time");

		// 使用DateTimeFormatter解析日期字符串
		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

		// 将字符串解析为LocalDate对象
		LocalDate date1 = LocalDate.parse(dateStr1, formatter);
		LocalDate date2 = LocalDate.parse(dateStr2, formatter);

		// 计算两个日期之间的天数差
		long daysBetween = java.time.Duration.between(date1.atStartOfDay(), date2.atStartOfDay()).toDays()+1;
		fs.setValue("day",daysBetween-dt.getRows());

		return fs;
	}
	/**
	 * @Date: 2020-03-30 16:43
	 * @Author: ZhouJie
	 * 删除请假申请
	 */
	public boolean deleteLeaveRequest(FieldSetEntity fs) throws BaseException {
		return baseDao.delete(CmnConst.PRODUCT_SYS_ASK_FOR_LEAVE,CmnConst.UUID+"=?",new Object[]{fs.getString(CmnConst.UUID)});
	}

	/**
	 * 根据申请人和请假日期获取请假单据
	 * @param fs
	 * @return
	 */
	public FieldSetEntity getLeave(FieldSetEntity fs){
		return  baseDao.getFieldSetByFilter(CmnConst.PRODUCT_SYS_ASK_FOR_LEAVE,"user_id=? and DATE_FORMAT(start_time,'%Y-%m-%d')<=? and DATE_FORMAT(end_time,'%Y-%m-%d')>=?",new String[]{fs.getString("user_id"),fs.getString("date"),fs.getString("date")},false);
	}

	/**
	 *
	 * @param fs
	 * @return
	 */
	public DataTableEntity leaveList(FieldSetEntity fs){
		String a="";
		ArrayList<String> list = new ArrayList<>();
		if (!StringUtils.isEmpty(fs.getString("yearAndMonth"))){
			a="(DATE_FORMAT( start_time, '%Y-%m' )=? or DATE_FORMAT( end_time, '%Y-%m' )=?) and user_id=? and";
			list.add(fs.getString("yearAndMonth"));
			list.add(fs.getString("yearAndMonth"));
			list.add(fs.getString("created_by"));
		}
		DataTableEntity dt = baseDao.listTable(CmnConst.PRODUCT_SYS_ASK_FOR_LEAVE, a + " flow_flag = 2", list.toArray());
		baseDao.loadPromptData(dt);
		return dt;
	}
}