74 lines
2.6 KiB
Go
74 lines
2.6 KiB
Go
package dokter
|
|
|
|
import (
|
|
"bridging-rssa/config"
|
|
"bridging-rssa/models/bpjs/jadwal_dokter"
|
|
"log"
|
|
"strconv"
|
|
|
|
"github.com/google/uuid"
|
|
)
|
|
|
|
func GetJadwalDokterByDate(hari string) ([]string, error) {
|
|
var spesialis []string
|
|
errSelect := config.SatuDataDB.Debug().Raw(`select distinct "Spesialis" from "daftar_jadwal_dokter" where "Nama_hari" = ? order by "Spesialis"`, hari).Scan(&spesialis).Error
|
|
if errSelect != nil {
|
|
log.Printf("Failed get data : %v", errSelect)
|
|
return nil, errSelect
|
|
}
|
|
return spesialis, nil
|
|
}
|
|
|
|
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
|
|
if errSelect != nil {
|
|
log.Printf("Failed get data : %v", errSelect)
|
|
return nil, errSelect
|
|
}
|
|
return listDokter, nil
|
|
}
|
|
|
|
func DeleteJadwalDokter() error {
|
|
err := config.SatuDataDB.Debug().Exec(`truncate table "daftar_jadwal_dokter"`).Error
|
|
if err != nil {
|
|
log.Printf("Failed truncate data : %v", err)
|
|
return err
|
|
}
|
|
log.Println("Success truncate data")
|
|
return nil
|
|
}
|
|
|
|
func DeleteJadwalDokterTemp() error {
|
|
err := config.SatuDataDB.Debug().Exec(`truncate table "daftar_jadwal_dokter_temp"`).Error
|
|
if err != nil {
|
|
log.Printf("Failed truncate data : %v", err)
|
|
return err
|
|
}
|
|
log.Println("Success truncate data")
|
|
return nil
|
|
}
|
|
|
|
func InsertJadwalDokter(reqInsert *jadwal_dokter.JadwalDokterSatuData) error {
|
|
err := config.SatuDataDB.Debug().Exec(`insert into "daftar_jadwal_dokter" ("Hari", "Nama_hari", "Waktu", "Dokter", "Spesialis", "Sub_spesialis", "Status") values (?, ? ,?, ?, ?, ?, ?)`, reqInsert.Hari, reqInsert.NamaHari, reqInsert.Waktu, reqInsert.Dokter, reqInsert.Spesialis, reqInsert.SubSpesialis, reqInsert.Status).Error
|
|
if err != nil {
|
|
log.Printf("Failed insert data : %v", err)
|
|
return err
|
|
}
|
|
log.Println("Success insert data")
|
|
return nil
|
|
}
|
|
|
|
func InsertJadwalDokterTemp(reqInsert *jadwal_dokter.JadwalDokterSatuData) error {
|
|
spesialis := strconv.Itoa(reqInsert.Spesialis)
|
|
subspesialis := strconv.Itoa(reqInsert.SubSpesialis)
|
|
id := uuid.New()
|
|
err := config.SatuDataDB.Debug().Exec(`insert into "daftar_jadwal_dokter_temp" ("id", "Hari", "Nama_hari", "Waktu", "Dokter", "Spesialis", "Sub_spesialis", "Status") values (?, ?, ?, ?, ?, ?, ?, ?)`, id, reqInsert.Hari, reqInsert.NamaHari, reqInsert.Waktu, reqInsert.Dokter, spesialis, subspesialis, reqInsert.Status).Error
|
|
if err != nil {
|
|
log.Printf("Failed insert data : %v", err)
|
|
return err
|
|
}
|
|
log.Println("Success insert data")
|
|
return nil
|
|
}
|