go节假日execl导入

最新推荐文章于 2022-12-22 11:13:16 发布
最新推荐文章于 2022-12-22 11:13:16 发布
阅读量212 收藏
点赞数
分类专栏： go
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44699162/article/details/105246280
版权 
//导入
func (c *HolidayController) Import() {
	if c.Ctx.Request.Method == "POST" {
		c.ImportSave()
	}
	c.setTpl("holiday/import.html", "shared/layout_pullbox.html")
	c.LayoutSections = make(map[string]string)
	c.LayoutSections["footerjs"] = "holiday/import_footerjs.html"
}
type MonthCoordinate struct{
	MonthLine int
	MonthRow  int
}

/*数字转换成Excle列中的字母，支持AA、AAA等，实际导入用不到那么多列*/
func Div(Num int)  string{
	var(
		Str string = ""
		k int
		temp []int   //保存转化后每一位数据的值，然后通过索引的方式匹配A-Z
	)
	//用来匹配的字符A-Z
	Slice := []string{"","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O",
		"P","Q","R","S","T","U","V","W","X","Y","Z"}

	if Num >26 {  //数据大于26需要进行拆分
		for {
			k = Num % 26  //从个位开始拆分，如果求余为0，说明末尾为26，也就是Z，如果是转化为26进制数，则末尾是可以为0的，这里必须为A-Z中的一个
			if k == 0 {
				temp = append(temp, 26)
				k = 26
			} else {
				temp = append(temp, k)
			}
			Num = (Num - k) / 26 //减去Num最后一位数的值，因为已经记录在temp中
			if Num <= 26{   //小于等于26直接进行匹配，不需要进行数据拆分
				temp = append(temp, Num)
				break
			}
		}
	}else{
		return Slice[Num]
	}

	for _,value := range temp{
		Str = Slice[value] + Str //因为数据切分后存储顺序是反的，所以Str要放在后面
	}
	return Str
}

func IsSingleDigit(data string) bool {
	digit := []string{"0", "1", "2", "3", "4", "5", "6", "7", "8", "9"}
	for _, item := range digit {
		if data == item {
			return true
		}
	}
	return false
}

/*判断字符串是否是纯数字*/
func IsDigit(data string) bool {
	for _, item := range data {
		if IsSingleDigit(string(item)) {
			continue
		} else {
			return false
		}
	}
	return true
}

func (c *HolidayController) ImportSave() {
	var sheetCount int
	var mystr string
	t :=time.Now()
	var ImportYear string
	var MyMonth  = [12]MonthCoordinate{
		{0,0},
		{0,0},
		{0,0},
		{0,0},
		{0,0},
		{0,0},
		{0,0},
		{0,0},
		{0,0},
		{0,0},
		{0,0},
		{0,0},
	}

	//获取上传url
	str := c.GetString("Url")
	fmt.Println("Url:", str)
	//read excel
	excelFileName := "static/excel/" + str
	fmt.Println("excelFileName:", excelFileName)
	//判断文件后缀 .xlsx
	//fmt.Println("文件后缀:",path.Ext(excelFileName))
	if path.Ext(excelFileName) != ".xlsx" {
		c.jsonResult(enums.JRCodeFailed, "文件类型错误,请选择 *.xlsx 文件 !", 0)
	}
	//xlFile, err := xlsx.OpenFile(excelFileName)
	xlFile, err := excelize.OpenFile(excelFileName)
	//defer os.Remove(excelFileName)
	if err != nil {
		fmt.Printf("open failed: %s\n", err)
		c.jsonResult(enums.JRCodeFailed, "文件打开失败!", 0)
	}

	sheetCount = 0
	for index, name := range xlFile.GetSheetMap() {
		sheetCount++  //统计工作表个数
		fmt.Println(index, name)
	}
	//reVal :=
	if sheetCount > 1 {
		c.jsonResult(enums.JRCodeFailed, fmt.Sprintf("导入文件存在多个工作表! 必须保证只有一个有效的工作表！当前存在%d个", sheetCount), 0)
	}
	SheetIndex :=  xlFile.GetActiveSheetIndex()
	fmt.Println("SheetIndex:",SheetIndex)
	SheetName := xlFile.GetSheetName(SheetIndex)
	fmt.Println("GetDefinedName:",SheetName)
	SheetNameNumber := SheetName[0:4]
	fmt.Println("SheetNameNumber:",SheetNameNumber)
	if !IsDigit(SheetNameNumber){ //如果表单名前四字节不是数字，则返回异常
		c.jsonResult(enums.JRCodeFailed, fmt.Sprintf("表单名的前四个字节必须填入正确年份，当前输入异常，值为：%s", SheetNameNumber), 0)
	}

	CurrentYear :=fmt.Sprintf("%d", t.Year())
	fmt.Println("CurrentYear is :",CurrentYear)
	if SheetNameNumber >= CurrentYear{
		ImportYear = SheetNameNumber
	}else{
		c.jsonResult(enums.JRCodeFailed, fmt.Sprintf("表单名的前四个字节年份小于当前实际年份，当前年份是：%s，要求导入年份是：%s", CurrentYear,SheetNameNumber), 0)
	}

	// 获取工作表中指定单元格的值,判断是否定义了节假日对应选项 Q3  --  Q7
	for i:=0 ; i<5 ;i++{
		cell, err := xlFile.GetCellValue(SheetName, fmt.Sprintf("Q%d", i+3))
		if err != nil {
			println(err.Error())
		}
		println(cell)
		if i ==0 {
			mystr = "假日类型对应颜色："
		}else if i==1 {
			mystr = "周末"
		}else if i==2{
			mystr = "法定节假日"
		}else if i==3{
			mystr = "年休假"
		}else if i==4{
			mystr = "调休上班日"
		}
		if cell != "假日类型对应颜色：" && cell != "周末" && cell != "法定节假日" && cell != "年休假" && cell != "调休上班日"{
			c.jsonResult(enums.JRCodeFailed, fmt.Sprintf("工作表Q%d定义异常，必须定义为:%s", i+3,mystr), 0)
		}
	}

	weekend,_ := xlFile.GetCellStyle(SheetName, "Q4")
	holiday,_ := xlFile.GetCellStyle(SheetName, "Q5")
	annualleave,_ := xlFile.GetCellStyle(SheetName, "Q6")
	other,_ := xlFile.GetCellStyle(SheetName, "Q8")
	fmt.Println("weekend:",weekend,"holiday:",holiday,"annualleave:",annualleave,"other:",other)

/*	weekend1,_ := xlFile.GetCellStyle(SheetName, "N6")
	holiday1,_ := xlFile.GetCellStyle(SheetName, "O13")
	annualleave1,_ := xlFile.GetCellStyle(SheetName, "O4")
	fmt.Println("weekend:",weekend1,"holiday:",holiday1,"annualleave:",annualleave1,"other:",other)*/
	var line int
	var column int
	line = 0


	qs := orm.NewOrm().QueryTable(models.HolidayTBName())
	i, _ := qs.PrepareInsert()
	defer i.Close(); os.Remove(excelFileName)
	succNum := 0
	failNum := 0
	fail := ""

	// 获取 Sheet1 上所有单元格，并且获取指定的节假日数据
	rows, err := xlFile.GetRows(SheetName)
	fmt.Println("rows:", rows)
	//fmt.Println("================================================================================================")
	for _, row := range rows {
		line++
		column = 0
		//fmt.Println("line:",line,"row:",row)
		fmt.Println("row:",row)
		for _, colCell := range row {
			column++
			print(colCell, "\t")
			//记录月份坐标
			if colCell == "1月"{
				MyMonth[0].MonthLine = line
				MyMonth[0].MonthRow = column
				fmt.Println("get the 1月：",line, column)
			}else if colCell == "2月"{
				MyMonth[1].MonthLine = line
				MyMonth[1].MonthRow = column
				fmt.Println("get the 2月：",line, column)
			}else if colCell == "3月"{
				MyMonth[2].MonthLine = line
				MyMonth[2].MonthRow = column
				fmt.Println("get the 3月：",line, column)
			}else if colCell == "4月"{
				MyMonth[3].MonthLine = line
				MyMonth[3].MonthRow = column
				fmt.Println("get the 4月：",line, column)
			}else if colCell == "5月"{
				MyMonth[4].MonthLine = line
				MyMonth[4].MonthRow = column
				fmt.Println("get the 5月：",line, column)
			}else if colCell == "6月"{
				MyMonth[5].MonthLine = line
				MyMonth[5].MonthRow = column
				fmt.Println("get the 6月：",line, column)
			}else if colCell == "7月"{
				MyMonth[6].MonthLine = line
				MyMonth[6].MonthRow = column
				fmt.Println("get the 7月：",line, column)
			}else if colCell == "8月"{
				MyMonth[7].MonthLine = line
				MyMonth[7].MonthRow = column
				fmt.Println("get the 8月：",line, column)
			}else if colCell == "9月"{
				MyMonth[8].MonthLine = line
				MyMonth[8].MonthRow = column
				fmt.Println("get the 9月：",line, column)
			}else if colCell == "10月"{
				MyMonth[9].MonthLine = line
				MyMonth[9].MonthRow = column
				fmt.Println("get the 10月：",line, column)
			}else if colCell == "11月"{
				MyMonth[10].MonthLine = line
				MyMonth[10].MonthRow = column
				fmt.Println("get the 11月：",line, column)
			}else if colCell == "12月"{
				MyMonth[11].MonthLine = line
				MyMonth[11].MonthRow = column
				fmt.Println("get the 12月：",line, column)
			}

			//根据月份坐标，查找对应节假日节点，并写入到数据库中
			if line > MyMonth[0].MonthLine + 1 && line < MyMonth[0].MonthLine + 8 && column >= MyMonth[0].MonthRow && column <= MyMonth[0].MonthRow + 6 {
			//1月 ，月份数据占用行数，最大是七行（包括了星期标识行），举例如下：
			//	3月
			//	一	二	三	四	五	六	日
			//	                        1
			//	2	3	4	5	6	7	8
			//	9	10	11	12	13	14	15
			//	16	17	18	19	20	21	22
			//	23	24	25	26	27	28	29
			//	30	31
			//fmt.Printf("Row:%s,line:%d",Div(column),line)
			dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
			fmt.Println("dayStyle:",dayStyle)
			if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
				data := models.Holiday{}
				if dayStyle == weekend{
					data.Name = "周末"
				}else if dayStyle == holiday{
					data.Name = "法定节假日"
				}else if dayStyle == annualleave{
					data.Name = "年休假"
				}
				//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
				//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
				day,_ := strconv.Atoi(colCell)
				data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,1,day)
				fmt.Println("holiday is :",data.Holiday)
				data.Modify = time.Now().Format("2006-01-02 15:04:05")
				data.Creator = &c.curUser

				if data.Name == "" || data.Holiday == ""{
					failNum += 1
					fail += "假日名称或假日时间不能为空."
					continue
				}else {

					succNum += 1
					id, _ := i.Insert(&data)
					fmt.Printf("id :%v \n", id)
				}
			}
			}else if line > MyMonth[1].MonthLine + 1 && line < MyMonth[1].MonthLine + 8 && column >= MyMonth[1].MonthRow && column <= MyMonth[1].MonthRow + 6 {//二月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,2,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[2].MonthLine + 1 && line < MyMonth[2].MonthLine + 8 && column >= MyMonth[2].MonthRow && column <= MyMonth[2].MonthRow + 6 {//三月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,3,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[3].MonthLine + 1 && line < MyMonth[3].MonthLine + 8 && column >= MyMonth[3].MonthRow && column <= MyMonth[3].MonthRow + 6 {//四月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,4,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[4].MonthLine + 1 && line < MyMonth[4].MonthLine + 8 && column >= MyMonth[4].MonthRow && column <= MyMonth[4].MonthRow + 6 {//四月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,5,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[5].MonthLine + 1 && line < MyMonth[5].MonthLine + 8 && column >= MyMonth[5].MonthRow && column <= MyMonth[5].MonthRow + 6 {//六月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,6,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[6].MonthLine + 1 && line < MyMonth[6].MonthLine + 8 && column >= MyMonth[6].MonthRow && column <= MyMonth[6].MonthRow + 6 {//七月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,7,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[7].MonthLine + 1 && line < MyMonth[7].MonthLine + 8 && column >= MyMonth[7].MonthRow && column <= MyMonth[7].MonthRow + 6 {//八月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,8,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[8].MonthLine + 1 && line < MyMonth[8].MonthLine + 8 && column >= MyMonth[8].MonthRow && column <= MyMonth[8].MonthRow + 6 {//九月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,9,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[9].MonthLine + 1 && line < MyMonth[9].MonthLine + 8 && column >= MyMonth[9].MonthRow && column <= MyMonth[9].MonthRow + 6 {//十月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,10,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[10].MonthLine + 1 && line < MyMonth[10].MonthLine + 8 && column >= MyMonth[10].MonthRow && column <= MyMonth[10].MonthRow + 6 {//十一月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,11,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}else if line > MyMonth[11].MonthLine + 1 && line < MyMonth[11].MonthLine + 8 && column >= MyMonth[11].MonthRow && column <= MyMonth[11].MonthRow + 6 {//十二月
				//fmt.Printf("Row:%s,line:%d",Div(column),line)
				dayStyle,_ := xlFile.GetCellStyle(SheetName,fmt.Sprintf("%s%d",Div(column),line) )
				fmt.Println("dayStyle:",dayStyle)
				if dayStyle == weekend || dayStyle == holiday ||dayStyle == annualleave  {
					data := models.Holiday{}
					if dayStyle == weekend{
						data.Name = "周末"
					}else if dayStyle == holiday{
						data.Name = "法定节假日"
					}else if dayStyle == annualleave{
						data.Name = "年休假"
					}
					//data.Name = fmt.Sprintf("%s", sheet.Rows[j].Cells[0])
					//data.Holiday = fmt.Sprintf("%s", sheet.Rows[j].Cells[1])
					day,_ := strconv.Atoi(colCell)
					data.Holiday  = fmt.Sprintf("%s-%02d-%02d", ImportYear,12,day)
					fmt.Println("holiday is :",data.Holiday)
					data.Modify = time.Now().Format("2006-01-02 15:04:05")
					data.Creator = &c.curUser

					if data.Name == "" || data.Holiday == ""{
						failNum += 1
						fail += "假日名称或假日时间不能为空."
						continue
					}else {

						succNum += 1
						id, _ := i.Insert(&data)
						fmt.Printf("id :%v \n", id)
					}
				}

			}

			//print("column",column,colCell, "\t")
		}
		//for idx ,val :=range MyMonth{
		//	fmt.Println("idx:",idx,"val:",val)
		//}
		println()
	}

	if succNum > 0 && failNum > 0 {
		c.jsonResult(enums.JRCodeSucc, "成功数量:"+strconv.Itoa(succNum)+",失败数量:"+strconv.Itoa(failNum)+";原因:"+fail, 0)
	}else if succNum > 0 && failNum == 0 {
		c.jsonResult(enums.JRCodeSucc, "成功数量: "+strconv.Itoa(succNum)+".", 0)
	}else {
		c.jsonResult(enums.JRCodeFailed, "失败数量:"+strconv.Itoa(failNum)+";原因:"+fail, 0)
	}
}
//文件上传
func (c *HolidayController) Upload() {
	//这里type没有用，只是为了演示传值
	stype, _ := c.GetInt32("type", 0)
	if stype > 0 {
		f, h, err := c.GetFile("fileUrl")
		if err != nil {
			c.jsonResult(enums.JRCodeFailed, "上传失败", "")
		}
		defer f.Close()
		if !FileExists("static/excel") {
			os.MkdirAll("static/excel", os.ModePerm)
		}
		filePath := "static/excel/" + h.Filename
		// 保存位置在 static/upload, 没有文件夹要先创建
		c.SaveToFile("fileUrl", filePath)
		c.jsonResult(enums.JRCodeSucc, "上传成功", h.Filename)
	} else {
		c.jsonResult(enums.JRCodeFailed, "上传失败", "")
	}
}
在这里插入图片描述
zzia_shiguang
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
2019-2020 年节假日表 (excel) 文件
05-02
共开发所需的19个字段,分别为date_key date_value day_in_year day_in_month is_first_day_in_month is_last_day_in_month weekday week_in_month is_first_day_in_week is_dayoff is_workday is_holiday date_type month_number year quarter_name quarter_number year_quarter year_month_number
2021节假日excel.xlsx
12-03
2021节假日excel文件，内含2021年所有节假日信息(双休日+法定节假日)，方便略作更改后直接导入数据库。
cal:Go（golang）日历库，用于处理假期和工作日
05-03
cal / v2：用于处理假期和工作日的Go（golang）日历库 该库增加了Go时间包，可轻松处理假期和工作日（工作日）。 假期实例是通过内置函数或用户创建的函数来计算的，以支持确切的日期，浮动日（例如每月的第三个星期一），年度偏移量（例如每年的第100天）或更复杂的规则（例如复活节的偏移量）。 如果假期是在一周中的特定日期（通常是周末），则假期可以在另一天庆祝的情况下提供单独的实际日期和观察日期。 日历类型提供了用于创建带假日的年度日历的基本功能。 BusinessCalendar添加了用于计算工作日和工作时间的其他功能。 与v1的差异 对于v2，该库的许多功能都进行了重写，以解决v1版本的缺点。 与v1相比，此版本具有以下优点： 假期 观察规则与个别假期相关，而不是按日历设置 添加了名称，描述和遵守类型字段 开始，结束和例外年份选项 假期定义通过ISO代码分成子包（不再需要将
api获取国家休息日 并填写到数据库中
i_qiangqiang的博客
10-11 1321
/最近要获取节假日，并需要保存在数据中做考勤计算，为了不手动操作就用hangfire定时操作； 先看一下获取节假日的代码： int Yeahs = DateTime.Now.Year;//当前年份 var model = LTDB.OffDay.Where(o => o.OffDate.Year == Yeahs).ToList();//...
Go 语言读写 Excel
xuri
12-23 1万+
Excelize 是&amp;amp;amp;amp;nbsp;Golang 编写的一个用来操作 Office Excel 文档类库，基于 ECMA-376 Office OpenXML 标准。可以使用它来读取、写入 XLSX 文件。相比较其他的开源类库，Excelize 支持写入原本带有图片(表)的文档，还支持向 Excel 中插入图片，并且在保存后不会丢失图表样式。 安装 go get github.com/...
golangExcel:用go语言实现本地excel数据导入数据库
07-07
golangExcel用go语言实现本地excel数据导入数据库
基于Goframe的Excel文件导入模版
最新发布
07-23
基于Goframe的Excel文件导入模版
基于golang 的excel导入导出
10-21
基于golang的excel导入导出util类。
2020法定节假日.xlsx
11-22
2020法定节假日，导出类型excel。需要的拿走不谢
Go语言导出内容到Excel的方法
09-22
主要介绍了Go语言导出内容到Excel的方法,涉及Go语言操作excel的技巧,具有一定参考借鉴价值,需要的朋友可以参考下
Go-xlsx-GoogleGo(golang)库用于读写ExcelXLSX文件
08-13
xlsx - Google Go (golang)库用于读写Excel XLSX文件
Golang Excel导入数据并标注此行背景色和异常数据提示展示
Salted fish in hand, I have the world.
01-10 807
https://www.jianshu.com/p/d8d18de0e3dc
2023年节假日信息得json文件
weixin_41904543的博客
12-22 914
2023年节假日信息json
如何使用go读写excel
思月行云
05-14 6311
go读写excel文件 首先，需要安装golang用来操作excel文档的类库： go get github.com/Luxurioust/excelize 一、excel文件创建与写入 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 .
获取全年所有节假日非工作日
热门推荐
罗_星星的博客
01-09 3万+
#写了一个获取全年的节假日，2019年节假日的工具类 说明文档 获取全年的节假日 1.修改DBhelper数据库配置文件 2.执行sql文件 3.配置getHolidays方法中的法定节假日和调休日期 4.运行main方法 日期格式自定义，用20190101或2019-01-01 项目地址 https://github.com/lufei222/san-holiday.git 现成的sql数据 2...
生成和获取法定节假日
weixin_43988567的博客
12-20 2165
如何生成法定节假日数据
GO 获取时间的年份、月份以及日期
蜗牛先生的博客
09-22 1万+
网上很多资料提供time将时间戳转成字符串的例子，但如何将获得的时间分为年、月、日分别展示，例如： ，上面显示的是日期，下面显示的是月份。作为初学者，表示网上的资料有点看不懂，记录一下，还望斧正。首先要获取一个Time类型的变量，平时要获取现在的时间的话，直接使用now即可，但若是从数据库中读取的数据应当如何呢？下面叙述： 直接获取系统时间 year:=time.Now().Year() mo
判断是否为节假日的接口
test的博客
06-28 1757
http://api.goseek.cn/Tools/holiday?date=20191008
推荐Go语言开源项目：Excelize ，Go语言创建自定义Excel表格（一）
CN_Eden
11-23 1361
摘要项目地址中文项目文档项目简介例子 项目地址 开源项目地址：https://github.com/xuri/excelize 中文项目文档 https://xuri.me/excelize/zh-hans/ 项目简介 Excelize 是 Go 语言编写的用于操作 Office Excel 文档基础库，基于 ECMA-376，ISO/IEC 29500 国际标准。可以使用它来读取、写入由 Microsoft Excel™ 2007 及以上版本创建的电子表格文档。支持 XLSX / XLSM / XLTM
go语言写个excel导入
02-28
下面是一个基本的示例，演示如何使用该库读取 Excel 文件并将其导入到 Go 中的切片中： ```go package main import ( "fmt" "github.com/tealeg/xlsx" ) func main() { // 打开 Excel 文件 xlFile, err := ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值