mirza.millahsyafiq.0912/api-bpjs-surkon
SHA256
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

fix get dokter

Browse Source
This commit is contained in:
Mirza Millahsyafiq Khusni
2024-09-26 07:53:33 +07:00
parent d5b06ff328
commit 7a508c6691
5 changed files with 24 additions and 10 deletions
Download Patch File Download Diff File Expand all files Collapse all files

5
database/satu_data/dokter/dokter.go
View File

@@ -43,12 +43,13 @@ func GetDokter() ([]dokter.DaftarDokterRes, error) {
func GetNamaLengkapDokter(idDokter []string) ([]dokter.NamaLengkap, error) {
var namaDokter []dokter.NamaLengkap
result := config.SatuDataDB.Debug().Raw(`select dp.id
result := config.SatuDataDB.Debug().Raw(`select dp.id,
array(
select dgd. "Gelar_depan"
from data_pegawai_daftar_gelar_depan dpdgd
left join daftar_gelar_depan dgd on dpdgd.daftar_gelar_depan_id = dgd.id where dpdgd.data_pegawai_id = dp.id
) AS gelardepan,dk."Nama_lengkap" ,
) AS gelardepan ,
dk."Nama_lengkap" ,
array(
select dgb. "Gelar_belakang"
from data_pegawai_daftar_gelar_belakang dpdgb

2
database/satu_data/dokter/jadwal_dokter.go
View File

@@ -21,7 +21,7 @@ func GetJadwalDokterByDate(hari string) ([]string, error) {
func GetJadwalDokterBySpesialis(hari string, spesialis string) ([]string, error) {
var listDokter []string
errSelect := config.SatuDataDB.Debug().Raw(`select "Dokter" from "daftar_jadwal_dokter" where "Nama_hari" = ? and Spesialis = ? order by "Spesialis"`, hari, spesialis).Scan(&listDokter).Error
errSelect := config.SatuDataDB.Debug().Raw(`select "Dokter" from "daftar_jadwal_dokter" where "Nama_hari" = ? and "Spesialis" = ? order by "Spesialis"`, hari, spesialis).Scan(&listDokter).Error
if errSelect != nil {
log.Printf("Failed get data : %v", errSelect)
return nil, errSelect