spider_editor/finishtime/finishtime.go

package finishtime

import (
	_ "log"
	"qfw/util"
	"time"

	"github.com/tealeg/xlsx"
)

/*
	time_two	紧急程度的时间的时间戳
	timeNow		当前时间戳
	unix_time	零点时间戳
	finishtime  完成时间
	timeInt
	time_twelve
	time_thirteen_thirty
*/
var time_two, timeNow, ret, unix_time, finishtime, time_twelve, time_eight_thirty, time_ten_thirty, time_thirteen_thirty, time_fitteen_thirty, time_eightten, time_dvalueS int64
var finishdate, date string
var err error
var Holiday []map[string]interface{}

//初始数据
func init() {
	timeNow = time.Now().Unix() //当前时间戳
	time_two = 7200
	date = time.Unix(timeNow, 0).Format("2006-01-02")
	the_time, err := time.ParseInLocation("2006-01-02", date, time.Local)
	if err == nil {
		unix_time = the_time.Unix()
	}
	time_eight_thirty = unix_time + 30600    //当前日期08:30的时间戳
	time_ten_thirty = unix_time + 37800      //当前日期10:30的时间戳
	time_twelve = unix_time + 43200          //当前日期12:00的时间戳
	time_thirteen_thirty = unix_time + 48600 //当前日期13:30的时间戳
	time_fitteen_thirty = unix_time + 55800  //当前日期15:30点的时间戳
	time_eightten = unix_time + 64800        //当前日期18:00点的时间戳
}

func LastTime(timeHour int) int64 {
	//func main() {
	var days int
	//传入时间
	//timeHour := 120
	//传入当前时间戳
	time_now := time.Now().Unix()
	if time_now <= time_eight_thirty {
		time_now = time_eight_thirty
	} else if time_now > time_twelve && time_now <= time_thirteen_thirty {
		time_now = time_thirteen_thirty
	}
	if timeHour == 2 {
		//传来2并且时间戳在12点之前 上午导入
		if time_now <= time_twelve && time_now >= time_eight_thirty {
			time_dvalueS = time_twelve - time_now - time_two
			ret = twoBeforeTwelve(time_dvalueS)
		} else if time_now >= time_thirteen_thirty && time_now < time_eightten {
			//传来2并且时间戳在13:30点之后 下午导入
			time_dvalueS = time_eightten - time_now - time_two
			ret = twoAfterTwelve(time_dvalueS)
		} else if time_now >= time_eightten {
			//18:00之后导入
			finishtime = time_ten_thirty + 86400
			ret = getDay(finishtime)
			//ret = ioExcel(finishtime)
		}
	} else if timeHour == 6 {
		//传来6并且时间戳在10:30点之前 上午导入 当天可完成
		if time_now >= time_eight_thirty && time_now <= time_ten_thirty {
			finishtime = time_eightten - time_ten_thirty + time_now
			//ret = sixBeforeTenthirty(finishtime)
			ret = finishtime
		} else if time_now > time_eight_thirty && time_now <= time_twelve {
			//传来6并且时间戳在10:30-12:00点 上午导入,第二天完成,验证是否是法定节假日
			time_dvalueS = time_twelve - time_now
			ret = sixAfterTenthirty(time_dvalueS)
		} else if time_now >= time_thirteen_thirty && time_now <= time_fitteen_thirty {
			//传来6并且时间戳在13:30-15:30点 下午导入,第二天上午完成,验证是否是法定节假日
			time_dvalueS = time_fitteen_thirty - time_now
			ret = sixBeforeFitteenthirty(time_dvalueS)
		} else if time_now > time_thirteen_thirty && time_now <= time_eightten {
			//传来6并且时间戳在15:30-18:00点 下午导入,第二天下午完成,验证是否是法定节假日
			time_dvalueS = time_now - time_fitteen_thirty
			ret = sixAfterFitteenthirty(time_dvalueS)
		}
	} else if timeHour == 48 { //2天
		days = 2
		ret = getDays(days)
	} else if timeHour == 120 { //5天
		days = 5
		ret = getDays(days)
	}
	return ret
}

//2小时上午开始
func twoBeforeTwelve(time_dvalue int64) int64 {
	//10点前导入，上午下班前即可完成
	if time_dvalue > 0 {
		finishtime = time_twelve - time_dvalue
		//finishdate = time.Unix(finishtime, 0).Format("2006-01-02 15:04:05")
	} else {
		//10-12点之间导入，下午下班前即可完成
		finishtime = time_thirteen_thirty - time_dvalue
		//finishdate = time.Unix(finishtime, 0).Format("2006-01-02 15:04:05")
	}
	return finishtime
}

//2小时下午开始
func twoAfterTwelve(time_dvalue int64) int64 {
	//16点前导入，下午下班前即可完成
	if time_dvalue > 0 {
		finishtime = time_eightten - time_dvalue
		finishdate = time.Unix(finishtime, 0).Format("2006-01-02 15:04:05")
	} else {
		//16-18点之间导入，第二天上午即可完成，验证是否是法定节假日
		finishtime = time_eight_thirty + 86400 - time_dvalue
		//验证是否是节假日
		finishtime = getDay(finishtime)
		//finishtime = ioExcel(finishtime)
	}
	return finishtime
}

func getDay(finishtime int64) int64 {
	//finishtime为第二天应该完成的准确时间
	now := time.Now().UTC()
	addtime := now.AddDate(0, 0, 1)
	var index int64 = 0
	for _, v := range Holiday {
		start, _ := time.Parse("2006-01-02", v["start"].(string))
		end, _ := time.Parse("2006-01-02", v["end"].(string))
		if (now.Before(start) && (addtime.After(end) || addtime.Equal(end))) || ((addtime.After(start) || addtime.Equal(start)) && (addtime.Before(end) || addtime.Equal(end))) {
			addtime = addtime.AddDate(0, 0, util.IntAll(v["count"]))
			//timeUnix = addtime.Unix()
			index = index + util.Int64All(v["count"])
		}
	}
	finishtime = finishtime + index*86400
	return finishtime
}

//6小时 10:30-12:00导入
func sixAfterTenthirty(time_dvalue int64) int64 {
	finishtime = time_eight_thirty + 86400 + 5400 - time_dvalue
	finishtime = getDay(finishtime)
	//finishtime = ioExcel(finishtime)
	return finishtime
}

//6小时 13:30-15:30导入
func sixBeforeFitteenthirty(time_dvalue int64) int64 {
	finishtime = time_twelve + 86400 - time_dvalue
	finishtime = getDay(finishtime)
	//finishtime = ioExcel(finishtime)
	return finishtime
}

//6小时 15:30-18:00导入
func sixAfterFitteenthirty(time_dvalue int64) int64 {
	finishtime = time_thirteen_thirty + 86400 + time_dvalue
	finishtime = getDay(finishtime)
	//finishtime = ioExcel(finishtime)
	return finishtime
}

func getDays(days int) int64 {
	var timeUnix int64
	now := time.Now()
	addtime := now.AddDate(0, 0, days)
	for _, v := range Holiday {
		start, _ := time.Parse("2006-01-02", v["start"].(string))
		end, _ := time.Parse("2006-01-02", v["end"].(string))
		if (now.Before(start) && (addtime.After(end) || addtime.Equal(end))) || ((addtime.After(start) || addtime.Equal(start)) && (addtime.Before(end) || addtime.Equal(end))) {
			addtime = addtime.AddDate(0, 0, util.IntAll(v["count"]))
			timeUnix = addtime.Unix()
		} else {
			timeUnix = addtime.Unix()
		}
	}
	return timeUnix
}

//验证法定节假日
func ioExcel(finishtime int64) int64 {
	finishdate = time.Unix(finishtime, 0).Format("2006-01-02")
	var index int64 = 0
	var finishtimed int64
	ex, err := xlsx.OpenFile("dayOff.xlsx")
	if err == nil {
		sheet := ex.Sheets[0]
		rows := sheet.Rows
		for _, v := range rows {
			cols := v.Cells[0].Value
			if cols == finishdate {
				index = index + 1
				finishtimed = finishtime + 86400*index
				finishdate = time.Unix(finishtimed, 0).Format("2006-01-02")
			}
		}
	}
	finishtime = finishtime + index*86400
	//finishdate = time.Unix(finishtime, 0).Format("2006-01-02 15:04:05")
	return finishtime
}