package satu_data

import (
	"api-poliklinik/pkg/models/simrs"
	"errors"
	"gorm.io/gorm"
	"log"
)

func (s *DatabaseService) Getruang() []*simrs.Location {
	var dataruang []*simrs.Location
	query := `select 
	mr."no" as id_idruang, mr.kode_ruang as id_kdruang, mr.kdunit as id_kdunit,
	mr.st_aktif as st_status,
	mr.nama as nm_namaruang,
	mr.keterangan as des_keterangan,
	mr.kelas as tp_kelas, mr.kelompok as tp_kelompokruang, mr.ruang as tp_typeruang, mr.subsistem as tp_subsistem, mr.is_partial as tp_partial,
	ms.kdsmf as id_kdsmf, ms.namasmf as nm_namasmf
from m_ruang mr 
left join m_unit mu on mu.kode_unit = mr.kdunit 
left join m_smf ms on ms.kdsmf = mu.smf`
	errQuery := s.DB.Debug().Raw(query).Scan(&dataruang).Error
	if errQuery != nil {
		if errors.Is(errQuery, gorm.ErrRecordNotFound) {
			errMsg := errors.New("Data Tidak Ditemukan")
			log.Println(errMsg)
			return nil
		}
		log.Println(errQuery)
		return nil
	}
	return dataruang
}