package logapi

import (
	"bridging-rssa/config"
	logapi "bridging-rssa/models/log_api"
	"log"
)

func InsertLogAPI(reqInsert *logapi.DataLogAPI) error {
	query := `insert into "data_log_api" (
        "id", "date_created", "User_agent", "IP", "Parameter", "Header", "Method", "URL", "Request", "Respon", "Respon_code", "Respontime_start", "Respontime_end", "Comment"
    ) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`
	err := config.SatuDataDB.Debug().Exec(query,
		reqInsert.ID,
		reqInsert.DateCreated,
		reqInsert.UserAgent,
		reqInsert.IP,
		reqInsert.Parameter,
		reqInsert.Header,
		reqInsert.Method,
		reqInsert.Url,
		reqInsert.Request,
		reqInsert.Respon,
		reqInsert.ResponCode,
		reqInsert.ResponTimeStart,
		reqInsert.ResponTimeEnd,
		reqInsert.Comment,
	).Error
	if err != nil {
		log.Println(err)
		return err
	}
	return nil
}

func GetLogAPI(req logapi.ReqGetDataLogAPI) ([]*logapi.DataLogAPI, error) {
	var dataLog []*logapi.DataLogAPI
	query := `select * from data_log_api dla where dla."Parameter" = 'BPJS-VClaim-RencanaKontrol' and dla."Request"->>'tipe_rawat' = ? and date(dla."date_created") between ? and ?`
	err := config.SatuDataDB.Debug().Raw(query, req.TipeRawat, req.TanggalAwal, req.TanggalAkhir).Scan(&dataLog).Error
	if err != nil {
		log.Println(err)
		return nil, err
	}
	log.Println("Berhasil Get Data")
	return dataLog, nil
}