update code surkon

database/satu_data/lokasi_ruang/daftar_lokasi_ruang.go

@@ -0,0 +1,24 @@
+package lokasiruang
+
+import (
+	"bridging-rssa/config"
+	"errors"
+	"log"
+
+	"gorm.io/gorm"
+)
+
+func GetDaftarLokasiRuang(idSimgos string) (int, error) {
+	var idRuangan int
+	query := `select dlr."id" from "daftar_lokasi_ruang" dlr where dlr."Id_location_simgos" = ?`
+	err := config.SatuDataDB.Debug().Raw(query, idSimgos).First(&idRuangan).Error
+	if err != nil {
+		if errors.Is(err, gorm.ErrRecordNotFound) {
+			log.Println(err)
+			return 128, nil
+		}
+		log.Println(err)
+		return 0, err
+	}
+	return idRuangan, nil
+}