} 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>"; }