<?php
$no++;
}
?>
<tr class="footer">
<td colspan="6"><div align="center"><strong>TOTAL PEMBELIAN</strong></div></td>
<td align="right"><strong><?php
echo number_format($total['total'], 2, '.', ',');
?>
</strong></td>
</tr>
</table>
<?php
$jmldata = mysql_num_rows(mysql_query("SELECT * FROM kd_pemb where kd_pemb.status='tunai' and tanggal between '{$thn_sekarang}-{$bln_sekarang}-1' and '{$tgl_sekarang}'"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET[lap_pembelian], $jmlhalaman);
echo "<div id=paging>Hal: {$linkHalaman}</div>\n\t\t\t</div>\n\t\t\t</div>\n\t\t\t</div>\n\t\t\t</div>\n\t\t\t</div>\n\t\t\t";
break;
case "stok":
$qmin = mysql_fetch_array(mysql_query("select min(bulan) as bulan, min(tahun) as tahun from master_laporan"));
$pertamax = $qmin['bulan'];
$pertama2 = $qmin['tahun'];
//untuk menyelesaikan transaksi
$query_transaksi = mysql_query("SELECT b.kode ,b.jenis, b.nama , b.satuan , p.pembelian , j.penjualan , b.stok , b.hrg_beli \nFROM barang b\n\nleft join\n(\nselect id_product ,SUM(jumlah) as pembelian\nfrom pembelian\nwhere tanggal BETWEEN '{$thn_sekarang}-{$bln_sekarang}-1' AND '{$tgl_sekarang}'\ngroup by id_product \n) p on p.id_product = b.kode\n\nleft join\n(\nselect id_product,SUM(jumlah) as penjualan\nfrom penjualan\nwhere tanggal BETWEEN '{$thn_sekarang}-{$bln_sekarang}-1' AND '{$tgl_sekarang}'\ngroup by id_product \n) j on j.id_product = b.kode\n\nORDER BY b.nama") or die(mysql_error());
$pemilik = mysql_fetch_array(mysql_query("select nm_perusahaan,alamat from bigbook_perusahaan")) or die("gagal");
?>
<!-- DATA TABLE SCRIPTS -->
<script src="assets/js/dataTables/jquery.dataTables.js"></script>
<script src="assets/js/dataTables/dataTables.bootstrap.js"></script>
<script>
$tgl_posting = tgl_indo($d[tgl_posting]);
$tgl_mulai = tgl_indo($d[tgl_mulai]);
$tgl_selesai = tgl_indo($d[tgl_selesai]);
$isi_agenda = nl2br($d[isi_agenda]);
echo "<div class=contentberita><div class=contentberitaborderag><div class=contentberitaborder2ag><table>";
echo "<tr><td colspan=2 ><span class=tanggal><div class=calendar>\n\t\t<img src={$f['folder']}/images/calendar.png></div><div class=calendarsub>{$tgl_posting}</div></span></td></tr>";
echo "<tr><td colspan=2><span class=judul>{$d['tema']}</span></td></tr>";
echo "<tr><td valign=top><b>Topik</b> </td><td> : {$isi_agenda} </td></tr>";
echo "<tr><td><b>Tanggal</b> </td><td> : {$tgl_mulai} s/d {$tgl_selesai} </td></tr>";
echo "<tr><td><b>Pukul</b> </td><td> : {$d['jam']} </td></tr>";
echo "<tr><td><b>Tempat</b> </td><td> : {$d['tempat']} </td></tr>";
echo "<tr><td><b>Pengirim</b> </td><td> : {$d['pengirim']} \n </td></tr></table></div></div></div>";
}
$jmldata = mysql_num_rows(mysql_query("SELECT * FROM agenda"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET[halagenda], $jmlhalaman);
echo "<div class=halberita>Hal: {$linkHalaman} </div><br /><br />";
echo "</div>\n </div>";
} elseif ($_GET['module'] == 'semuadownload') {
echo "<div id='content'> \n <div id='content-detail'>";
echo "<span class=judul_head><div class=panah>\n\t\t<img src={$f['folder']}/images/panah.png></div>Download</span><br /><br />";
$p = new Paging5();
$batas = 20;
$posisi = $p->cariPosisi($batas);
// Tampilkan semua download
$sql = mysql_query("SELECT * FROM download \n ORDER BY id_download DESC LIMIT {$posisi},{$batas}");
echo "<div class=contentberita><div class=contentberitaborderbrt><div class=contentberitaborder2brt>\n <ul>";
while ($d = mysql_fetch_array($sql)) {
echo "<li><a href='downlot.php?file={$d['nama_file']}'>{$d['judul']}</a> ({$d['hits']})</li>";
}
echo "</ul></div></div></div>";