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
}