#!/bin/bash
mysql -u root -psatriopiningit1924 keuangan_bpp<<EOFMYSQL
select a.no_trans, a.tgl_bukti, a.kode_trans, a.nama as nis, b.nama, a.jumlah, a.akun_debet, a.akun_kredit, a.remark, a.created_by, a.created_date, a.updated_by, a.updated_date, a.pos_anggaran from transaksi a, siswa b
where a.nama=b.nis and a.kode_trans in ('OPENING_US','UANGSAKU')
order by b.nama, a.tgl_bukti;
EOFMYSQL