package satu_data

import (
	"api-poliklinik/pkg/models/simrs"
	"errors"
	"gorm.io/gorm"
	"log"
)

func (s *DatabaseService) Getbahasa() []*simrs.Bahasasimrs {
	var databahasa []*simrs.Bahasasimrs
	query := `select 
	mb.idxbahasa as id_idbahasa, mb.nmbahasa as nm_namabahasa
from m_bahasa mb`
	errQuery := s.DB.Debug().Raw(query).Scan(&databahasa).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 databahasa
}

func (s *DatabaseService) Getdisabilitas() []*simrs.Disabilitassimrs {
	var datadisabilitas []*simrs.Disabilitassimrs
	query := `select 
	md.kode_disabilitas as id_iddisabilitas, md.nama_disabilitas as nm_namadisabilitas
from m_disabilitas md`
	errQuery := s.DB.Debug().Raw(query).Scan(&datadisabilitas).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 datadisabilitas
}

func (s *DatabaseService) Getpendidikan() []*simrs.Pendidikansimrs {
	var datapendidikan []*simrs.Pendidikansimrs
	query := `select 
	mpp.id_pendidikan as id_idpendidikan, mpp.nama_pendidikan as nm_namapendidikan
from m_pendidikan_pasien mpp`
	errQuery := s.DB.Debug().Raw(query).Scan(&datapendidikan).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 datapendidikan
}

func (s *DatabaseService) Getpekerjaan() []*simrs.Pekerjaansimrs {
	var datapekerjaan []*simrs.Pekerjaansimrs
	query := `select 
	mp.idxpekerjaan as id_idpekerjaan, mp.nmpekerjaan as nm_namapekerjaan, mp.st_pekerjaan as des_pekerjaan
from m_pekerjaan mp`
	errQuery := s.DB.Debug().Raw(query).Scan(&datapekerjaan).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 datapekerjaan
}

func (s *DatabaseService) Getstatus() []*simrs.StatusPernikahansimrs {
	var datastatus []*simrs.StatusPernikahansimrs
	query := `select 
	msp.id_status as id_idstatus, msp.nama_status as nm_namastatus
from m_status_pasien msp`
	errQuery := s.DB.Debug().Raw(query).Scan(&datastatus).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 datastatus
}

func (s *DatabaseService) Getagama() []*simrs.Agamasimrs {
	var dataagama []*simrs.Agamasimrs
	query := `select 
	mag.id_agama as id_idagama, mag.nama_agama as nm_namaagama
from m_agama_pasien mag`
	errQuery := s.DB.Debug().Raw(query).Scan(&dataagama).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 dataagama
}

func (s *DatabaseService) Getsuku() []*simrs.Sukusimrs {
	var datasuku []*simrs.Sukusimrs
	query := `select 
	ms.idxsuku as id_idsuku, ms.nmsuku as nm_namasuku 
from m_suku ms`
	errQuery := s.DB.Debug().Raw(query).Scan(&datasuku).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 datasuku
}

func (s *DatabaseService) GetICD() []*simrs.Icd {
	var dataicd []*simrs.Icd
	query := `select 
	i.icd_code as id_idicd, i.icd_code as nm_icd, i.jenis_penyakit as des_deskripsijenispenyakit, i.sebabpenyakit as com_penyebabpenyakit
from icd i`
	errQuery := s.DB.Debug().Raw(query).Scan(&dataicd).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 dataicd
}

func (s *DatabaseService) GetSMF() []*simrs.Smfsimrs {
	var datasmf []*simrs.Smfsimrs
	query := `select 
	ms.idsmf as id_idsmf, ms.kdsmf as id_kodesmf, ms.namasmf as nm_namasmf, ms.aktif as st_smf
from m_smf ms`
	errQuery := s.DB.Debug().Raw(query).Scan(&datasmf).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 datasmf
}