} 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>";
$jmldata = mysql_num_rows(mysql_query("SELECT * FROM download"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET[haldownload], $jmlhalaman);
echo "<div class=halberita>Hal: {$linkHalaman} </div><br /><br />";
echo "</div>\n </div>";
} elseif ($_GET['module'] == 'semuaalbum') {
echo "\n \n <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>Album</span><br />";
// Tentukan kolom
$col = 4;
$a = mysql_query("SELECT jdl_album, album.id_album, gbr_album, album_seo, \n COUNT(gallery.id_gallery) as jumlah \n FROM album LEFT JOIN gallery \n ON album.id_album=gallery.id_album \n WHERE album.aktif='Y' \n GROUP BY jdl_album");
echo "<div class=contentberitafull><div class=contentberitaborderfull><div class=contentberitaborder2full><div class=galls><table><tr>";
$cnt = 0;
while ($w = mysql_fetch_array($a)) {
if ($cnt >= $col) {
echo "</tr><tr>";
$cnt = 0;
}
?>
</div></td>
<td><div align="center"><?php
echo $r[1];
?>
</div></td>
</tr>
<?php
$no++;
}
?>
</table>
<?php
$jmldata = mysql_num_rows(mysql_query("select barang.nama, sum(penjualan.jumlah) from penjualan, barang where\n\t\t\t\t\t\t\t\t\t\t\tpenjualan.id_product=barang.kode and penjualan.tanggal between '{$thn_sekarang}-{$bln_sekarang}-1' and '{$tgl_sekarang}' group by barang.nama order by barang.nama asc"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET[bacth], $jmlhalaman);
echo "<div id=paging>Hal: {$linkHalaman}</div><br></fieldset></div>";
break;
case "trackbarang":
echo "<h2><img src='../img/icons/16x16_0320/database.png'> Pengeluaran Data Barang</h2><hr>\n <input class='btn'type=button value='Kembali' onClick=\"window.location.href='barang';\"></br></br>";
$query = mysql_query("select penjualan.tanggal,penjualan.id_transaksi,barang.nama,penjualan.jumlah from barang, penjualan\n\t\t\t\t\t\t\twhere barang.kode=penjualan.id_product and barang.kode='{$_GET['id']}'") or die(mysql_error());
echo "<div id='nota'><fieldset>\n\t\t\t\t<div class='kepala-nota'>\n\t\t\t\t<p>APOTEK AZKA Pekalongan<br>\n\t\t\t\tJl.Keradenan Besar Pekalongan Selatan No.26</p><hr><hr style='color:#000;'></div>\n\t\t\t\t<div class='kanan-nota'>\n </div>";
echo "<div id='scroll'><table class='nota'>\n <thead>\n <tr>\n\t\t\t\t\t\t\t\t\t\t<th>No.</th>\n <th>Tanggal</th>\n\t\t\t\t\t\t\t\t\t\t<th>Kode transaksi</th>\n <th>Nama</th>\n <th>Jumlah</th>\n </tr>\n </thead>";
$no = 1;
while ($r = mysql_fetch_row($query)) {
echo "<tr class=body>\n\t\t\t\t\t\t\t\t\t\t\t<td align='center'>{$no}</td>\n <td align='center'>{$r['0']}</td>\n <td align='center'>{$r['1']}</td>\n <td align='center'>{$r['2']}</td>\n <td align='center'>{$r['3']}</td>\n <td align='center'>{$r['4']}</td>\n </tr>";
$no++;
}
echo "<tr>\n <td colspan='5'><h4 align='right'></h4></td>\n <td colspan='5'><h4></h4></td>\n </tr>\n </table></div><h4 style='float:right; margin-right:20px;'></h4>\n\t\t\t\t\t\t\t\t\t<p style='font-size:8pt;float:left; padding-top:15px;'>*tracking barang <p></fieldset></div>";
}
