add log api and offset limit

database/satu_data/log_api/log_api.go

@@ -0,0 +1,34 @@
+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
+}

database/satu_data/surat_kontrol/surat_kontrol.go

@@ -78,7 +78,7 @@ func InsertDataSuratKontrol(reqInsert *suratkontrol.DataSuratKontrol) error {
 	return nil
 }
 
-func GetDataSuratKontrol() ([]*suratkontrol.GetDataSuratKontrol, error) {
+func GetDataSuratKontrol(offset, limit string) ([]*suratkontrol.GetDataSuratKontrol, error) {
 	var dataSurKon []*suratkontrol.GetDataSuratKontrol
 	err := config.SatuDataDB.Debug().Raw(`select dsk."id", dsk."Tanggal_cetak_surat_kontrol", dsk."Tanggal_rencana_kontrol",
 		dsk."Nomor_surat_kontrol", 
@@ -113,17 +113,14 @@ func GetDataSuratKontrol() ([]*suratkontrol.GetDataSuratKontrol, error) {
 		left join data_pegawai dp on dsk."DPJP_surat_kontrol" = dp."id"
 		left join data_ktp dk on dp."KTP" = dk. "id"
 		left join daftar_subspesialis ds on dp."Subspesialis" = ds."id"
-		where dsk."Status_surat_kontrol" = '1'`).Scan(&dataSurKon).Error
+		where dsk."Status_surat_kontrol" = '1' offset ? limit ?`, offset, limit).Scan(&dataSurKon).Error
 	if err != nil {
 		if errors.Is(err, gorm.ErrRecordNotFound) {
 			errMsg := errors.New("DPJP anda belum ada subspesialis")
 			log.Println(errMsg)
 			return nil, errMsg
 		}
-		log.Println(err)
-		return nil, err
 	}
-	log.Println("Data Surat Kontrol : ", dataSurKon)
 	return dataSurKon, nil
 }
 
@@ -169,10 +166,7 @@ func GetDataSuratKontrolByID(idxdaftar string) (*suratkontrol.GetDataSuratKontro
 			log.Println(errMsg)
 			return nil, errMsg
 		}
-		log.Println(err)
-		return nil, err
 	}
-	log.Println("Data Surat Kontrol : ", dataSurKon)
 	return dataSurKon, nil
 }
 
@@ -184,6 +178,7 @@ func UpdateDataSuratKontrol(reqUpdate *suratkontrol.DataSuratKontrol) error {
 	}
 	return nil
 }
+
 func GetIDXDaftarBySurKon(idSurKon string) (string, error) {
 	var idxDaftar string
 	err := config.SatuDataDB.Debug().Raw(`select dkp."IDXDAFTAR"
@@ -250,6 +245,5 @@ func SearchDataSurKon(req suratkontrol.RequestCariPasien, query string, args []i
 		log.Println(err)
 		return nil, err
 	}
-	log.Println("Data Surat Kontrol : ", dataSurKon)
 	return dataSurKon, nil
 }