34 lines
950 B
Go
34 lines
950 B
Go
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
|
|
}
|