search

dh-hos / dhg.hospitalreports

1 stars 0 forks source link

Lỗi - xem xuất 1 số BC báo lỗi #14

Closed le-an-87 closed 1 year ago

le-an-87 commented 1 year ago
`Công ty TNHH Giải Pháp Kỹ Thuật Số DH - Mẫu: DH-08.1: Phiếu ghi nhận lỗi phát sinh DHG.Hospital 3.1`
Simple Icons

PHIẾU GHI NHẬN LỖI PHÁT SINH

#

chi_tiet_loi
mo_ta_loi
Xuất báo cáo báo lỗi:
1. Sổ xuất viện
2. Sổ lưu trữ Ngoại trú/ Nội trú
3. Sổ Tử vong
4. Sổ ra vào viện

Lỗi sổ xuất viện
Phiên bản :2022.10.04.145652PM
Npgsql.NpgsqlException:
column reference "keluu" is ambiguous
Severity: ERROR
Code: 42702
   at DH.Reports.DataAccess.Adapter.AdapterReports.GetSoXuatVien(String pThangKT, String pNamKT, DateTime pNgayBD, DateTime pNgayKT, Int32 pThangQui)
   at DH.Reports.BusinessLogic.BLBusinessLogicReports.GetSoXuatVien()
   at DH.Reports.Forms.FrmSoXuatVien.LoadDataGrid()
   at DH.Reports.Forms.FrmSoXuatVien.ctrBtn_ButtonEvtXem_click(Object sender, EventArgs e)
 SELECT nt.mabn,nt.maba AS maba2,date_part('day',nt.ngayvv), nt.maba, bn.holot||' '||bn.ten as hoten,nt.madt,bn.dienthoai,      dk.tuoi,      CASE WHEN dk.dvttuoi = 1 THEN 'Năm'            WHEN dk.dvttuoi = 2 THEN 'Tháng'            WHEN dk.dvttuoi = 3 THEN 'Ngày'        END as dvttuoi , '' as hoten_luutru,keluu,       CASE WHEN bn.gioitinh = 1 THEN         CASE             WHEN dk.dvttuoi = 2 THEN dk.tuoi || ' Th'             WHEN dk.dvttuoi = 3 THEN dk.tuoi || ' Ng'             ELSE dk.tuoi || ''         END ELSE null       END as tuoinam,       CASE WHEN bn.gioitinh = 0 THEN         CASE             WHEN dk.dvttuoi = 2 THEN dk.tuoi || ' Th'             WHEN dk.dvttuoi = 3 THEN dk.tuoi || ' Ng'             ELSE dk.tuoi || ''         END ELSE null       END as tuoinu,       CASE WHEN bn.vienchuc = 1 THEN 'X' ELSE null END as vienchuc,        dtuong.bhyt as dienphi,        CASE WHEN dtuong.bhyt IN (1,2) THEN nt.mathe || '-' || nt.mabvdk ELSE null END as bhyt ,        CASE WHEN bn.thanhthi = 1 THEN 'X' ELSE null END as thanhthi,        CASE WHEN bn.vienchuc = 2 THEN 'X' ELSE null END as nongthon,        CASE WHEN (dk.dvttuoi = 2 and dk.tuoi <= 12) OR  dk.dvttuoi = 3 THEN 'X' ELSE null END as tre1,        CASE WHEN (dk.dvttuoi = 1 AND  dk.tuoi <= 15) OR (dk.dvttuoi = 2 AND  dk.tuoi > 12) THEN 'X' ELSE null END as tre2,        ng.tennghe as nghenghiep, bn.diachi, dk.noigt,        nt.ngayvv,        CASE WHEN nt.ravien NOT IN (3,4) THEN nt.ngayrv ELSE null END AS ngayrv,       CASE WHEN nt.ravien = 4 THEN nt.ngayrv ELSE null END as ngaycv,       CASE WHEN nt.ravien = 3 THEN nt.ngayrv ELSE nt.ngaygiotv END AS ngaygiotv, tv.diengiai as tvtrong24g,       CASE WHEN nt.ravien = 2 THEN nt.ngayrv ELSE null END as ngaytrv,        dk.cdoantd as kqcdoantd,       '['||nt.maicdvv||'] '|| nt.kqcdoanvv as kqcdoankkb,       '['||nt.maicd||'] '|| nt.kqcdoan as kqcdoankdt,       gpb.kqcdoankgp,       CASE WHEN nt.makq = '01' THEN 'X' ELSE null END as khoi ,        CASE WHEN nt.makq = '02' THEN 'X' ELSE null END as dogiam ,       CASE WHEN nt.makq = '03' THEN 'X' ELSE null END as khongdoi ,        CASE WHEN nt.makq = '04' THEN 'X' ELSE null END as nanghon ,       CASE WHEN nt.makq = '05' THEN 'X' ELSE null END as tvong ,        CASE WHEN nt.ngayrv is null THEN CURRENT_DATE - nt.ngayvv ::date          ELSE (nt.ngayrv :: date - nt.ngayvv ::date) + 1        END as songaydt,       nt.ravien, nt.madv, dv.tendv,nt.makb,'' AS tenhh,'' AS tencls,tinh.tentinh,COALESCE(nt.tvtruoc24h,'') AS tvtruoc24h,       '84006' AS ma_cskcb,       COALESCE(dv.ma_khoa_cv2348, '') AS ma_khoa,       CASE WHEN SUBSTRING(nt.mathe,6,2) = 'KT' THEN '' ELSE COALESCE(nt.mathe,'') END AS ma_the,       CASE WHEN SUBSTRING(nt.mathe,6,2) = 'KT' THEN '' ELSE SUBSTRING(COALESCE(nt.mathe,''),6,10) END AS ma_sobhxh,       COALESCE(bn.diachi, '') AS dia_chi,       COALESCE(bn.holot, '') || ' ' || COALESCE(bn.ten, '') AS ho_ten,       CASE WHEN COALESCE(dk.namsinh, 0) = 1 THEN to_char(bn.ngaysinh, 'yyyy') ELSE to_char(bn.ngaysinh, 'dd/MM/yyyy') END AS ngay_sinh,       COALESCE(dantoc.ma_medisoft, '99') AS dan_toc,       CASE              WHEN COALESCE(bn.gioitinh, 0) = 1 THEN '1'              WHEN COALESCE(bn.gioitinh, 0) = 0 THEN '2'              ELSE '3'       END AS gioi_tinh,       to_char(nt.ngayvv, 'dd/MM/yyyy HH24:mi') AS ngay_vao,       to_char(nt.ngayrv, 'dd/MM/yyyy HH24:mi') AS ngay_ra,       COALESCE(nt.kqcdoanvv, '') AS chan_doan_vao,       CASE WHEN COALESCE(nt.kqcdoanp, '') = '' THEN COALESCE(nt.kqcdoan, '') ELSE COALESCE(nt.kqcdoan, '') || '; ' || COALESCE(nt.kqcdoanp, '') END AS chan_doan,       COALESCE(pp.diengiai, '') AS pp_dieutri,       '' AS ma_bs,       to_char(nt.ngayrv, 'dd/MM/yyyy') AS ngay_ct,       '' AS ten_bs,       CASE WHEN COALESCE(dtuong.bhyt,0) IN (1,2) THEN 1 ELSE 0 END AS doituong,       '' AS nguoi_dai_dien,       CASE WHEN UPPER(COALESCE(dk.loaiqh,'')) IN ('CHA','BA') THEN COALESCE(dk.hotenqh,'') ELSE '' END AS ho_ten_cha,       CASE WHEN UPPER(COALESCE(dk.loaiqh,'')) IN ('MẸ','MÁ') THEN COALESCE(dk.hotenqh,'') ELSE '' END AS ho_ten_me,       CASE WHEN SUBSTRING(nt.mathe,6,2) = 'KT' THEN '1' ELSE '' END AS tekt,       COALESCE(dv.manv_truongkhoa,'') AS manv_truongkhoa  FROM current.bnnoitru nt        LEFT JOIN current.dmbenhnhan bn on nt.mabn = bn.mabn        LEFT JOIN current.dmxa xa on bn.maxa = xa.maxa        LEFT JOIN current.dmdantoc dantoc ON bn.madt = dantoc.madt       LEFT JOIN current.dmppdt pp ON nt.mappdt = pp.mappdt       LEFT JOIN current.dmnhanvien nv ON nt.manv = nv.manv       LEFT JOIN current.dmhuyen huyen on xa.mahuyen = huyen.mahuyen        LEFT JOIN current.dmtinh tinh on huyen.matinh = tinh.matinh        LEFT JOIN current.psdangky dk on nt.makb = dk.makb and nt.mabn = dk.mabn       LEFT JOIN current.dmdoituong  dtuong on nt.madt = dtuong.madt        LEFT JOIN current.dmxutri xt on nt.maxt = xt.maxt        LEFT JOIN current.dmnghe ng on bn.manghe = ng.manghe        LEFT JOIN current.dmtgtv tv on nt.matgtv = tv.matgtv        LEFT JOIN current.dmdonvi dv on nt.madv = dv.madv        LEFT JOIN         (             SELECT  mabn,makb,current.sumtext(TRIM(chandoangiaiphaubenh) || '
') AS kqcdoankgp             FROM   current.pssinhthiet             WHERE   TRIM(COALESCE(chandoangiaiphaubenh,'')) != ''             GROUP BY mabn,makb         ) gpb ON nt.mabn = gpb.mabn AND nt.makb = gpb.makb  WHERE      COALESCE(nt.ravien,0) != 0 AND             nt.namvien = 1 AND             nt.thangrv IN ('10') AND nt.namrv IN ('2022') AND  nt.ngayrv BETWEEN (('2022-10-31 00:00:00')) AND (('2022-10-31 23:59:59')) AND             COALESCE(dk.tiepnhan,'') = '' AND COALESCE(nt.xoa,0) = 0  ORDER BY nt.maba ASC

sổ xuất viện image Sổ ra vào viện image Sổ tử vong image

vinh-dh commented 1 year ago

Reports 31/10/2022

le-an-87 commented 1 year ago

đã fix!