Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select dt.id_detail_transaksi, tp.id_tipe_pelanggan, tp.nama_tipe_pelanggan, dt.id_header_transaksi, ht.id_tipe_produk, tpro.nama_tipe_produk, dt.id_terminal, c.id_seq_pelanggan as id_seq_pelanggan_corp , m.id_seq_pelanggan as id_seq_pelanggan_mer,
- (case when tp.nama_tipe_pelanggan = 'mitra' then '' else c.nama_pelanggan end) as nama_corporate_customer,
- (case when tp.nama_tipe_pelanggan = 'mitra' then '' else c.id_pelanggan end) as corporate_customer_id,
- m.nama_pelanggan as nama_merchant, m.alamat_pelanggan, t.tid, m.id_pelanggan as MID, t.header_1, t.header_2, t.header_3, t.header_4,
- t.f2_f4_passwords, t.password_edit_parameter, t.password_bank, t.password_kasir, tk.nama_tipe_koneksi, t.parameter_komunikasi, t.kode_bank,
- t.nomor_rekening, t.nomor_seri_vendor,
- (case when exists
- (SELECT * FROM histori_detail_transaksi hdt
- inner join status_detail_transaksi sdt on sdt.id_status_detail_transaksi = hdt.id_status_detail_transaksi
- WHERE hdt.id_detail_transaksi = dt.id_detail_transaksi and lower(sdt.nama_status_detail_transaksi) like lower('%regist%'))
- then 'Sudah'
- else 'Belum'
- end) as status_registrasi
- from detail_transaksi dt
- inner join terminal t on t.id_terminal = dt.id_terminal
- inner join tipe_koneksi tk on t.id_tipe_koneksi = tk.id_tipe_koneksi
- inner join pelanggan m on dt.id_seq_pelanggan = m.id_seq_pelanggan
- left join pelanggan c on m.id_pelanggan_parent = c.id_seq_pelanggan
- left join tipe_pelanggan tp on c.id_tipe_pelanggan = tp.id_tipe_pelanggan
- inner join header_transaksi ht on ht.id_header_transaksi = dt.id_header_transaksi
- inner join tipe_produk tpro on tpro.id_tipe_produk = ht.id_tipe_produk
- where
- dt.id_header_transaksi = 6
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement