new branch

2024-12-20 08:57:06 +07:00
parent e7f4001ac7
commit 81b7cb08e8
24 changed files with 1273 additions and 166 deletions
@@ -0,0 +1,43 @@
+package mikrobiologi
+
+import (
+	"bridging-rssa/config"
+	"bridging-rssa/models/simrs/mikrobiologi"
+	"errors"
+	"log"
+
+	"gorm.io/gorm"
+)
+
+func GetDataMikroBiologi(req *mikrobiologi.RequestPasienMikrobiologi) ([]*mikrobiologi.DataPasienMikrobiologi, error) {
+	var dataPasien []*mikrobiologi.DataPasienMikrobiologi
+	query := `select tom."nomr" as nomr, tomm."nonota" as nonota, tom."idxdaftar" as idxdaftar, tom."tglorder" as tglorder, tom."nolab" as nolab, tom."rajal" as statusrajal, tom."aps" as statusaps,
+			mp."nama" as nama, mp."noktp" as noktp, mp."noktp_baru" as noktpbaru, mp."tempat" as tmptlahir, mp."tgllahir" as tgllahir, mp."jeniskelamin" as jeniskelamin, mp."alamat" as alamat,
+			mpa."nama" as namaaps, mpa."noktp" as noktpaps, mpa."tempat" as tmptlahiraps, mpa."tgllahir" as tgllahiraps, mpa."jeniskelamin" as jeniskelaminaps, mpa."alamat" as alamataps,
+			mr."nama" as namaruang, mr."kelas" as kelasruang,
+			trj."kodetarif" as kodetarifrajal,
+			trp."kodetarif" as kodetarifranap
+		from t_orderlabmikro tom
+		left join m_pasien mp on mp."nomr" = tom."nomr" 
+		left join m_pasien_aps mpa on mpa."nomr" = tom."nomr" 
+		left join m_ruang mr on mr."no" = tom."kdpoli" 
+		left join t_orderlabmikro_main tomm on tomm."nolab" = tom."nolab" 
+		left join t_billrajal trj on trj."nonota" = CAST(tomm."nonota" AS int8)
+		left join t_billranap trp on trp."nonota" = CAST(tomm."nonota" AS int8)
+		where tom."nomr" = ? 
+		and tom."idxdaftar" = ?
+		group by (tom."nomr",tomm."nonota",tom."idxdaftar",tom."tglorder",tom."nolab",tom."rajal",tom."aps",mp."nama",mp."noktp",mp."noktp_baru",mp."tempat",mp."tgllahir",mp."jeniskelamin",mp."alamat",mpa."nama",mpa."noktp",
+		mpa."tempat",mpa."tgllahir",mpa."jeniskelamin",mpa."alamat",mr."nama",mr."kelas",trj."kodetarif",trp."kodetarif")
+		`
+	errQuery := config.SimrsDB.Debug().Raw(query, req.NOMR, req.IDXDaftar).Scan(&dataPasien).Error
+	if errQuery != nil {
+		if errors.Is(errQuery, gorm.ErrRecordNotFound) {
+			errMsg := errors.New("Data Tidak Ditemukan")
+			log.Println(errMsg)
+			return nil, errMsg
+		}
+		log.Println(errQuery)
+		return nil, errQuery
+	}
+	return dataPasien, nil
+}