package com.product.administration.service;




import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Date;
import java.util.List;



import cn.hutool.core.date.DateTime;
import cn.hutool.core.date.DateUnit;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.ObjectUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import com.product.administration.config.CmnConst;
import com.product.administration.config.SystemCode;
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.service.support.AbstractBaseService;
import com.product.core.spring.context.SpringMVCContextHolder;
import com.product.module.sys.entity.SystemUser;

/**
 * 	打卡记录
* Copyright  PRODUCT-BASE
* @Title: PRODUCT-BASE-
* @Project: PunchRecordService
* @Date: 2021年8月9日 上午11:30:38
* @Author: 杜洪波
* @Description:
 */
@Component
public class PunchRecordService extends AbstractBaseService{

	@Autowired
	BaseDao baseDao;

	/**
	 * 	考勤打卡列表
	 * @param fse
	 * @return
	 */
	public DataTableEntity listRecordInfo(FieldSetEntity fse) throws ParseException {
		DataTableEntity dt=baseDao.listTable(CmnConst.PRODUCT_OA_PUNCH_RECORD, "created_by=?", new Object[] {SpringMVCContextHolder.getCurrentUser().getUser_id()}, null, CmnConst.CREATED_UTC_DATETIME+" DESC", fse.getInteger(CmnConst.PAGESIZE), fse.getInteger(CmnConst.CPAGE));
		for (int i=0;i<dt.getRows();i++){
			FieldSetEntity fieldSetEntity = dt.getData().get(i);
			String punch_time_one = null;
			if (fieldSetEntity.getString("punch_time_one") != null) {
				punch_time_one=fieldSetEntity.getValue("punch_time_one").toString();
			}else if (fieldSetEntity.getString("punch_time_two") != null) {
				punch_time_one=fieldSetEntity.getValue("punch_time_two").toString();
			}else if (fieldSetEntity.getString("punch_time_three") != null) {
				punch_time_one=fieldSetEntity.getValue("punch_time_three").toString();
			}else if (fieldSetEntity.getString("punch_time_four") != null) {
				punch_time_one=fieldSetEntity.getValue("punch_time_four").toString();
			}
			String sign_date=null;
			if (null!=punch_time_one){
				Date date1=new Date(punch_time_one);
				SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
				 sign_date = dateFormat.format(date1);
				fieldSetEntity.setValue("sign_date",sign_date);
			}
			DateFormat dateFormatGet = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

			//获取早退迟到的分钟数
			List<Object>param1=new ArrayList<>();
			param1.add(fieldSetEntity.getValue("created_by").toString());
			param1.add(fieldSetEntity.getValue("punch_congfig_uuid").toString());
			param1.add(fieldSetEntity.getValue("created_by").toString()+",");

			//获取使用到的设置规则
			StringBuilder sbPunchTime=new StringBuilder();
			sbPunchTime.append(" SELECT c.* ");
			sbPunchTime.append(" FROM ( ");
			sbPunchTime.append(" SELECT d.* ");
			sbPunchTime.append(" FROM product_oa_punch_time d ");
			sbPunchTime.append(" left JOIN product_oa_punch_record b ");
			sbPunchTime.append(" on d.punch_site_uuid=b.punch_congfig_uuid and d.created_by=? where d.punch_site_uuid= ? ");
			sbPunchTime.append(" ) c ");
			sbPunchTime.append(" where  c.uuid in ( ");
			sbPunchTime.append(" SELECT DISTINCT uuid ");
			sbPunchTime.append(" FROM product_oa_punch_time ");
			sbPunchTime.append(" where LOCATE(?, concat(attendance_object,','))>0 ");
			sbPunchTime.append(" ) ");
			DataTableEntity dataTableEntity = baseDao.listTable(sbPunchTime.toString(), param1.toArray());


			//处理补卡的情况
			List<Object>param2=new ArrayList<>();
			param2.add(fieldSetEntity.getValue("created_by").toString());
			param2.add(sign_date);

			StringBuilder sbReplenish=new StringBuilder();
			sbReplenish.append(" SELECT T1.id,T1.uuid,T1.created_by,T1.applicant,T1.replenish_date,T1.reason,");
			sbReplenish.append(" SUBSTRING_INDEX( SUBSTRING_INDEX( T1.replacement_card_type, ',', T2.digit + 1 ), ',',- 1 ) AS type ");
			sbReplenish.append(" FROM (select * from product_oa_replenish_punch where flow_flag=2) T1 ");
			sbReplenish.append(" JOIN ( SELECT 0 AS digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 ) T2");
			sbReplenish.append(" ON T2.digit < ( length( T1.replacement_card_type )- length( REPLACE ( T1.replacement_card_type, ',', '' ))+ 1 )");
			sbReplenish.append(" where t1.created_by=? ");
			sbReplenish.append(" and DATE_FORMAT( t1.replenish_date, '%Y-%m-%d' )=? ");
			DataTableEntity dataTableEntity1 = baseDao.listTable(sbReplenish.toString(), param2.toArray());
			if(dataTableEntity1.getRows()!=0){

				for(int j=0;j<dataTableEntity1.getRows();j++){
					String type = dataTableEntity1.getData().get(j).getValue("type").toString();
					if(type.equals("1")){
						String morning_work = dataTableEntity.getData().get(0).getValue("morning_work").toString();
						Date parse = dateFormatGet.parse(morning_work);
						fieldSetEntity.setValue("punch_time_one", new Timestamp(parse.getTime()));
					}

					if(type.equals("2")){
						String morning_work_off = dataTableEntity.getData().get(0).getValue("morning_work_off").toString();
						Date parse = dateFormatGet.parse(morning_work_off);
						fieldSetEntity.setValue("punch_time_two", new Timestamp(parse.getTime()));
					}

					if(type.equals("3")){
						String afternoon_work = dataTableEntity.getData().get(0).getValue("afternoon_work").toString();
						Date parse = dateFormatGet.parse(afternoon_work);
						fieldSetEntity.setValue("punch_time_three", new Timestamp(parse.getTime()));
					}

					if(type.equals("4")){
						String afternoon_work_off = dataTableEntity.getData().get(0).getValue("afternoon_work_off").toString();
						Date parse = dateFormatGet.parse(afternoon_work_off);
						fieldSetEntity.setValue("punch_time_four", new Timestamp(parse.getTime()));
					}
				}
			}

			long beLate1 = 0;
			long beLate2 = 0;
			long beEarily1 = 0;
			long beEarily2 = 0;
			if(dataTableEntity.getRows()!=0){

				String morning_work="";
				String morning_work_off="";
				String afternoon_work="";
				String afternoon_work_off="";
				Date  morning_work_date;
				Date  morning_work_off_date;
				Date  afternoon_work_date;
				Date  afternoon_work_off_date;

				DateTime punch_time_one_date;
				DateTime punch_time_two_date;
				DateTime punch_time_three_date;
				DateTime punch_time_four_date;

				SimpleDateFormat dateFormatHHmmss = new SimpleDateFormat("HH:mm:ss");

				StringBuilder  lateSb=new StringBuilder();
				StringBuilder   earilySb=new StringBuilder();
				StringBuilder supereffective_distance=new StringBuilder();


				if(!ObjectUtil.isNotEmpty(dataTableEntity.getData().get(0).getValue("morning_work_off")) && !ObjectUtil.isNotEmpty(dataTableEntity.getData().get(0).getValue("afternoon_work"))){

					morning_work = dataTableEntity.getData().get(0).getValue("morning_work").toString();
					afternoon_work_off = dataTableEntity.getData().get(0).getValue("afternoon_work_off").toString();
					morning_work_date= DateUtil.parse(morning_work.split(" ")[1]);
					afternoon_work_off_date= DateUtil.parse(afternoon_work_off.split(" ")[1]);
					int distance = Integer.parseInt(dataTableEntity.getData().get(0).getValue("distance").toString());
					if(ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_time_one"))){
						String punch_time_one1 = dateFormatHHmmss.format(fieldSetEntity.getValue("punch_time_one"));
						punch_time_one_date = DateUtil.parse(punch_time_one1);
						if(punch_time_one_date.after(morning_work_date)){
							beLate1 = DateUtil.between(punch_time_one_date, morning_work_date, DateUnit.MINUTE);
							lateSb.append("迟到:"+beLate1+"分钟");
							//计算超出的有效距离
							int punch_range_one = Integer.parseInt(fieldSetEntity.getValue("punch_range_one").toString());
							if(punch_range_one>distance){
								int distanceMorning = punch_range_one- distance;
								fieldSetEntity.setValue("supereffective_distance","上班超有效距离:"+distanceMorning);
							}
						}

					}else {
						lateSb.append("上班未打卡");
					}

					if(ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_time_four"))){
						String punch_time_four = dateFormatHHmmss.format(fieldSetEntity.getValue("punch_time_four"));
						punch_time_four_date = DateUtil.parse(punch_time_four);
						if(punch_time_four_date.before(afternoon_work_off_date)){
							beEarily2 = DateUtil.between(punch_time_four_date, afternoon_work_off_date, DateUnit.MINUTE);
							earilySb.append("早退:"+beEarily2+"分钟");
							int punch_range_four = Integer.parseInt(fieldSetEntity.getValue("punch_range_four").toString());
							if(punch_range_four>distance){
								int distanceMorning = punch_range_four- distance;
								fieldSetEntity.setValue("supereffective_distance","下班超有效距离:"+distanceMorning);
							}
						}

					}else {
						earilySb.append("下班未打卡");
					}

				}else {

					morning_work = dataTableEntity.getData().get(0).getValue("morning_work").toString();
					morning_work_date= DateUtil.parse(morning_work.split(" ")[1]);
					morning_work_off = dataTableEntity.getData().get(0).getValue("morning_work_off").toString();
					morning_work_off_date= DateUtil.parse(morning_work_off.split(" ")[1]);
					afternoon_work =dataTableEntity.getData().get(0).getValue("afternoon_work").toString();
					afternoon_work_date= DateUtil.parse(afternoon_work.split(" ")[1]);
					afternoon_work_off = dataTableEntity.getData().get(0).getValue("afternoon_work_off").toString();
					afternoon_work_off_date= DateUtil.parse(afternoon_work_off.split(" ")[1]);


					int distance = Integer.parseInt(dataTableEntity.getData().get(0).getValue("distance").toString());

					if(ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_time_one"))&&ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_range_one"))){
						String punch_time_one1 = dateFormatHHmmss.format(fieldSetEntity.getValue("punch_time_one"));
						punch_time_one_date = DateUtil.parse(punch_time_one1);
						if(punch_time_one_date.after(morning_work_date)){
							beLate1 = DateUtil.between(punch_time_one_date, morning_work_date, DateUnit.MINUTE);
							lateSb.append("早上班迟到:"+beLate1+" ");
							int punch_range_one = Integer.parseInt(fieldSetEntity.getValue("punch_range_one").toString());
							if(punch_range_one>distance){
								int distanceMorning = punch_range_one- distance;
								supereffective_distance.append("早上班超有效距离:"+distanceMorning);
							}

						}

					}else {
						lateSb.append("早上班未打卡"+" ");

					}

					if(ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_time_two"))&&ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_range_two"))){
						String punch_time_two= dateFormatHHmmss.format(fieldSetEntity.getValue("punch_time_two"));
						punch_time_two_date = DateUtil.parse(punch_time_two);
						if(punch_time_two_date.before(morning_work_off_date)){
							beEarily1 = DateUtil.between(punch_time_two_date, morning_work_off_date, DateUnit.MINUTE);
							earilySb.append("早下班早退:"+beEarily1+" ");
							int punch_range_two = Integer.parseInt(fieldSetEntity.getValue("punch_range_two").toString());
							if(punch_range_two>distance){
								int distanceMorningoff = punch_range_two- distance;
								supereffective_distance.append("早下班超有效距离:"+distanceMorningoff);
							}
						}

					}else {
						earilySb.append("早下班未打卡"+" ");
					}
					if(ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_time_three"))&&ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_range_three"))){
						String punch_time_three = dateFormatHHmmss.format(fieldSetEntity.getValue("punch_time_three"));
						punch_time_three_date = DateUtil.parse(punch_time_three);
						if(punch_time_three_date.after(afternoon_work_date)){
							beLate2 = DateUtil.between(punch_time_three_date, afternoon_work_date, DateUnit.MINUTE);
							lateSb.append("下午上班迟到:"+beLate2+" ");
							int punch_range_three = Integer.parseInt(fieldSetEntity.getValue("punch_range_three").toString());
							if(punch_range_three>distance){
								int distanceAfternoon = punch_range_three- distance;
								supereffective_distance.append("下午上班超有效距离:"+distanceAfternoon);
							}
						}
					}else {
						lateSb.append("早上班未打卡"+" ");
					}
					if(ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_time_four"))&&ObjectUtil.isNotEmpty(fieldSetEntity.getValue("punch_range_four"))){
						String punch_time_four = dateFormatHHmmss.format(fieldSetEntity.getValue("punch_time_four"));
						punch_time_four_date = DateUtil.parse(punch_time_four);
						if(punch_time_four_date.before(afternoon_work_off_date)){
							beEarily2 = DateUtil.between(punch_time_four_date, afternoon_work_off_date, DateUnit.MINUTE);
							earilySb.append("下午下班早退:"+beEarily2+" ");
							int punch_range_four = Integer.parseInt(fieldSetEntity.getValue("punch_range_four").toString());
							if(punch_range_four>distance){
								int distanceAfternoonoff = punch_range_four- distance;
								supereffective_distance.append("下午下班超有效距离:"+distanceAfternoonoff);
							}

						}
					}else {
						earilySb.append("下午下班未打卡"+" ");
					}

				}
				fieldSetEntity.setValue("be_late",lateSb);
				fieldSetEntity.setValue("ealy_leave",earilySb);
				fieldSetEntity.setValue("supereffective_distance",supereffective_distance.toString());
			}

		}
		dt.setFieldFormat("punch_time_one", "HH:mm");
		dt.setFieldFormat("punch_time_two", "HH:mm");
		dt.setFieldFormat("punch_time_three", "HH:mm");
		dt.setFieldFormat("punch_time_four", "HH:mm");
		baseDao.loadPromptData(dt);
		return dt;
	}

	/**
	 * 	考勤打卡详情
	 * @param uuid
	 * @return
	 */
	public FieldSetEntity findRecordInfo(String uuid) {
		return baseDao.getFieldSetEntity(CmnConst.PRODUCT_OA_PUNCH_RECORD, uuid, false);
	}

	/**
	 * 	考勤打卡新增
	 * @param fse
	 * @return
	 */
	public String addRecordInfo(FieldSetEntity fse) {
		SimpleDateFormat df = new SimpleDateFormat(CmnConst.YYYYMMDDHHMMSS);

		SystemUser currentUser=SpringMVCContextHolder.getCurrentUser();	//获取打卡人
		Date created_datetime=fse.getDate("created_datetime");			//获取打卡时间
//		Date created_datetime=new Date();								//获取打卡时间
		String string_created_datetime=df.format(created_datetime);		//时间转string

		//获取公司打卡时间配置信息
		FieldSetEntity fseCompanyPunch=baseDao.getFieldSetEntityByFilter("product_oa_punch_time", "org_level_uuid=?", new Object[] {currentUser.getOrg_level_uuid()}, false);
		if (fseCompanyPunch==null) {
			throw new BaseException(SystemCode.SYSTEM_CONMAPNY_PUNCH_NO_EXIST.getValue(), SystemCode.SYSTEM_CONMAPNY_PUNCH_NO_EXIST.getText(), this.getClass(), "addRecordInfo");
		}

		//获取当天打卡信息
		FieldSetEntity fsePunchInfo=baseDao.getFieldSetEntityByFilter(CmnConst.PRODUCT_OA_PUNCH_RECORD, "created_by=? and DATE_FORMAT(created_utc_datetime,'%Y-%m-%d')like ?", new Object[] {currentUser.getUser_id(),string_created_datetime.substring(0, 10)+"%"}, false);
		if (fsePunchInfo==null) {
			FieldSetEntity fseNewPunchInfo = new FieldSetEntity();
			fseNewPunchInfo.setTableName(CmnConst.PRODUCT_OA_PUNCH_RECORD);
			fseNewPunchInfo.setValue(CmnConst.ORG_LEVEL_UUID, currentUser.getOrg_level_uuid());
			fseNewPunchInfo.setValue(CmnConst.DEPT_UUID, currentUser.getDept_uuid());
			fseNewPunchInfo.setValue(CmnConst.CREATED_BY, currentUser.getUser_id());
			fseNewPunchInfo.setValue(CmnConst.CREATED_UTC_DATETIME, created_datetime);
			fseNewPunchInfo.setValue("punch_time_one", created_datetime);
			//新增打卡信息
			return baseDao.add(fseNewPunchInfo);
		}else {

			//打卡模式(0:双卡  1:四卡)
			int punchMode=0;
			if (StringUtils.isEmpty(fseCompanyPunch.getString("work_time_two"))) {
				punchMode=1;
			}

			String punch_time_one=fsePunchInfo.getDate("punch_time_one", CmnConst.YYYYMMDDHHMMSS);
			String punch_time_two=fsePunchInfo.getDate("punch_time_two", CmnConst.YYYYMMDDHHMMSS);
			String punch_time_three=fsePunchInfo.getDate("punch_time_three", CmnConst.YYYYMMDDHHMMSS);
			String punch_time_four=fsePunchInfo.getDate("punch_time_four", CmnConst.YYYYMMDDHHMMSS);
			List<String> list=new ArrayList<>();
			if (punch_time_one!=null) {
				list.add(punch_time_one);
			}
			if (punch_time_two!=null) {
				list.add(punch_time_two);
			}
			if (punch_time_three!=null) {
				list.add(punch_time_three);
			}
			if (punch_time_four!=null) {
				list.add(punch_time_four);
			}
			list.add(string_created_datetime);
			Collections.sort(list);

			for (int i = 0; i < list.size(); i++) {
				if (punchMode==1) {
					if (i==0) {
						fsePunchInfo.setValue("punch_time_one", list.get(i));
					}else if (i==1) {
						fsePunchInfo.setValue("punch_time_four", list.get(i));
					}
				}else {
					if (i==0) {
						fsePunchInfo.setValue("punch_time_one", list.get(i));
					}else if (i==1) {
						fsePunchInfo.setValue("punch_time_two", list.get(i));
					}else if (i==2) {
						fsePunchInfo.setValue("punch_time_three", list.get(i));
					}else if (i==3) {
						fsePunchInfo.setValue("punch_time_four", list.get(i));
					}
				}
			}
			//修改打卡信息
			baseDao.update(fsePunchInfo);
			return fsePunchInfo.getUUID();
		}
	}

}