package main
 
import (
	"encoding/csv"
	"fmt"
	"os"
	"strconv"
	"time"
 
	_ "export/docs"
 
	"github.com/gin-gonic/gin"
	swaggerFiles "github.com/swaggo/files"
	ginSwagger "github.com/swaggo/gin-swagger"
	"gorm.io/driver/mysql"
	"gorm.io/gorm"
)
 
type Detail struct {
	Id        int
	Name      string
	FirstTime time.Time
	LastTime  time.Time
}
 
// @title NeoApi Swagger 標題
// @version 1.0 版本
// @description NeoApi Service 描述
// @BasePath /api  基礎(chǔ)路徑
// @query.collection.format multi
func main() {
	r := gin.Default()
	r.GET("/swagger/*any", ginSwagger.WrapHandler(swaggerFiles.Handler))
	r.GET("/api/export", export)
	r.POST("/api/data", func(c *gin.Context) {
		c.JSON(200, gin.H{
			"message": "success",
		})
	})
	r.Run("0.0.0.0:9527")
}
 
// @Summary 導出數(shù)據(jù)
// @Description 導出數(shù)據(jù)
// @Accept json
// @Produce json
// @Success 200 string string "success"
// @Router /api/export [get]
func export(c *gin.Context) {
	dsn := "dev:123456@tcp(192.168.1.203:33306)/menshen?charset=utf8mb4&parseTime=true"
	db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
	if err != nil {
		panic("failed to connect database")
	}
 
	var persons []uint
	db.Raw("select id from person").Scan(&persons)
	fmt.Println(persons)
 
	month := 3
	monthFile := "08.csv"
	csvfile, err := os.Create(monthFile)
	if err != nil {
		fmt.Println("Error:", err)
		return
	}
	defer csvfile.Close()
 
	for _, id := range persons {
		var data []Detail
		// 注意 Gorm 字段映射默認嚴格駝峰命名，否則取不到值
		db.Raw(`select s.person_id as id, s.person_name as name, min(s.origin_time) as first_time, max(s.origin_time) as last_time from (
		select person_id, person_name, origin_time, date_format(origin_time, '%d') as day FROM event_record
		where person_id=? and primary_type=100 and PERIOD_DIFF(date_format(now( ), '%Y%m'), date_format(origin_time, '%Y%m'))=?) s group by s.day
	  `, id, month).Scan(&data)
 
		writer := csv.NewWriter(csvfile)
		for _, da := range data {
			record := []string{strconv.Itoa(da.Id), da.Name, da.FirstTime.Format("2006-01-02 15:04:05"), da.LastTime.Format("2006-01-02 15:04:05")}
			err := writer.Write(record)
			if err != nil {
				fmt.Println("Error:", err)
				return
			}
		}
		writer.Flush()
	}
 
	c.JSON(200, gin.H{
		"message": "export success",
	})
}

	swaggerFiles "github.com/swaggo/files"
	ginSwagger "github.com/swaggo/gin-swagger"
 
	_ "export/docs"

	r.GET("/swagger/*any", ginSwagger.WrapHandler(swaggerFiles.Handler))