47 lines
1.3 KiB
Go
47 lines
1.3 KiB
Go
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
|
|
}
|