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