laporan

//query pasok

select a.id_pasok,a.tanggal ,b.nama_distributor, c.judul,c.tahun ,a.jumlah from tbl_buku c inner join (tbl_pasok a inner join distributor b on a.id_distributor = b.id_distributor) on c.id_buku = a.id_buku where a.tanggal between $P{dari} and $P{sampai}

//query penjualan
select a.id_penjualan, a.tanggal , b.judul,b.harga_jual,b.diskon, a.jumlah,a.total,c.nama,b.id_buku from tbl_kasir c inner join (tbl_buku b inner join tbl_penjualan a on b.id_buku = a.id_buku) on c.id_kasir = a.id_kasir where a.tanggal between $P{dari} and $P{sampai}

//faktur pasok
select a.id_pasok,a.tanggal ,b.id_distributor, c.id_buku ,a.jumlah from tbl_buku c inner join (tbl_pasok a inner join distributor b on a.id_distributor = b.id_distributor) on c.id_buku = a.id_buku where a.id_pasok = $P{idPasok}

//faktur penjualan
select a.id_penjualan, a.tanggal, b.judul, b.penulis, b.harga_jual, a.jumlah, a.total, c.nama  from tbl_kasir c inner join (tbl_buku b inner join tbl_penjualan a on b.id_buku = a.id_buku) on c.id_kasir = a.id_kasir where a.id_penjualan = $P{idPenjualan}