Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT rmp.id_kunjungan,
- rmp.id,
- rmp.id_rekam_medis,
- rmp.tanggal_catat, pd.id AS id_produk,
- pd.kode AS kode_produk, pd.nama AS nama_produk,
- pd.static_code AS static_code, rmp.jumlah,
- shp.id AS id_setting_harga_produk,
- shp.total AS harga,
- NULL AS id_setting_paket_produk,
- 'Non Paket' AS nama_paket,
- NULL AS id_setting_paket_produk_detail,
- tpp.total_harga AS total_include,
- rmp.id_setting_promo
- FROM rekam_medis_tindakan rmp,
- rekam_medis rm, kunjungan kj,
- master_produk pd,
- setting_harga_produk shp,
- transaksi_pasien tp,
- transaksi_pasien_produk tpp
- WHERE rm.id = rmp.id_rekam_medis
- AND kj.id = rmp.id_kunjungan
- AND pd.id = rmp.id_produk
- AND shp.id_produk = rmp.id_produk
- AND tp.id_kunjungan = rmp.id_kunjungan
- AND tpp.id_transaksi_pasien = tp.id
- AND tpp.id_produk = rmp.id_produk
- AND rmp.id_setting_paket_produk = 0
- AND rmp.id_setting_promo = 0
- AND tpp.status_bayar = 'BELUM_BAYAR'
- AND rmp.id_kunjungan = 2
- GROUP BY rmp.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement