57 lines
1.6 KiB
Go
57 lines
1.6 KiB
Go
package satu_data
|
|
|
|
import (
|
|
"api-poliklinik/pkg/models/simrs"
|
|
"errors"
|
|
"gorm.io/gorm"
|
|
"log"
|
|
)
|
|
|
|
func (s *DatabaseService) Getdokter() []*simrs.Practitionerdoktersimrs {
|
|
var datadokter []*simrs.Practitionerdoktersimrs
|
|
query := `select
|
|
md.kddokter as id_kddokter, md.kdpoly as id_kdpoly, md.kode_dpjp as id_kodedpjp, md.nip as id_nip,
|
|
md.aktif as st_aktif,
|
|
md.namadokter as nm_namadokter,
|
|
md.no_hp as te_nomorhp, md.email as te_email,
|
|
md.tgl_akhir_sip as qu_sip, md.tgl_akhir_spk as qu_spk,
|
|
md.kdsmf as ex_smf, md.kategori as ex_kategori
|
|
from m_dokter md`
|
|
errQuery := s.DB.Debug().Raw(query).Scan(&datadokter).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 datadokter
|
|
}
|
|
|
|
func (s *DatabaseService) Getperawat() []*simrs.Practitionerperawatsimrs {
|
|
var dataperawat []*simrs.Practitionerperawatsimrs
|
|
query := `select
|
|
mp.idperawat as id_perawat, mp.nip as id_nip, mp.noktp as id_noktp,
|
|
mp.aktif as st_status,
|
|
mp.nama as nm_nama,
|
|
mp.notelp as te_telpon,
|
|
mp.jeniskelamin as ge_jeniskelamin,
|
|
mp.tgllahir as bir_tgllahir,
|
|
mp.alamat as ad_alamat, mp.kelurahan as ad_kelurahan, mp.kdkecamatan as ad_kecamatan, mp.kota as ad_kota, mp.kdprovinsi as ad_provinsi,
|
|
mp.tempat as ex_tempatlahir
|
|
from m_perawat mp`
|
|
errQuery := s.DB.Debug().Raw(query).Scan(&dataperawat).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 dataperawat
|
|
}
|