echo number_format($total['total'], 2, '.', ',');
?>
</strong></div></td>
</tr>
</table>
<?php
$jmldata = mysql_num_rows(mysql_query("SELECT * FROM kd_penj where tanggal between '{$thn_sekarang}-{$bln_sekarang}-1' and '{$tgl_sekarang}'"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
echo "<div id=paging>Hal: {$linkHalaman}</div><br></fieldset></div>";
break;
case "pembelian":
$query_tanggal = mysql_fetch_array(mysql_query("select min(tanggal_transaksi) as tanggal_pertama from master_transaksi"));
$tanggal_pertama = $query_tanggal['tanggal_pertama'];
//untuk menyelesaikan transaksi
$p = new Paging4();
$batas = 10;
$posisi = $p->cariPosisi($batas);
$no = 1;
if (isset($_POST['report'])) {
//tanggal periode laporan
$tanggal1 = $_POST[thn_1] . '-' . $_POST[bln_1] . '-' . $_POST[tgl_1];
$tanggal2 = $_POST[thn_2] . '-' . $_POST[bln_2] . '-' . $_POST[tgl_2];
$query_transaksi = mysql_query("select * from supplier,kd_pemb where kd_pemb.status='tunai' and kd_pemb.id_supplier=supplier.id_supplier and tanggal between '{$tanggal1}' and '{$tanggal2}' order by tanggal asc limit {$posisi},{$batas}");
$total = mysql_fetch_array(mysql_query("select sum(total) as total from kd_pemb where kd_pemb.status='tunai' and tanggal between '{$tanggal1}' and '{$tanggal2}' order by tanggal asc limit {$posisi},{$batas}"));
} else {
// $query_transaksi=mysql_query("select * from supplier,kd_pemb where kd_pemb.status='tunai' and kd_pemb.id_supplier=supplier.id_supplier and tanggal between '$thn_sekarang-$bln_sekarang-1' and '$tgl_sekarang' order by tanggal asc limit $posisi,$batas") or die (mysql_error());
//$total=mysql_fetch_array(mysql_query("select sum(total) as total from kd_pemb where kd_pemb.status='tunai' and tanggal between '$thn_sekarang-$bln_sekarang-1' and '$tgl_sekarang' order by tanggal asc"))or die (mysql_error());
unset($_POST['report']);
}
$pemilik = mysql_fetch_array(mysql_query("select nm_perusahaan,alamat from bigbook_perusahaan")) or die("gagal");
// membuat paragraf pada isi berita dan mengabaikan tag html
$isi = substr($isi_berita, 0, 220);
// ambil sebanyak 220 karakter
$isi = substr($isi_berita, 0, strrpos($isi, " "));
// potong per spasi kalimat
echo "{$isi} ... <div id=btn_selanjutnya class=selengkapnya><a href=berita-{$r['id_berita']}-{$r['judul_seo']}.html>Selengkapnya</a></div></div> <div class=bgkoment>{$r['jml']}</div><div class=katakomentar>Komentar</div>\n </div></div></div>";
}
$jmldata = mysql_num_rows(mysql_query("SELECT * FROM berita"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET[halberita], $jmlhalaman);
echo "<div class=halberita>Hal: {$linkHalaman} </div><br /><br />";
echo "</div>\n </div>";
} elseif ($_GET['module'] == 'semuaagenda') {
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>Agenda</span><br /><br />";
$p = new Paging4();
$batas = 5;
$posisi = $p->cariPosisi($batas);
// Tampilkan semua agenda
$sql = mysql_query("SELECT * FROM agenda \n ORDER BY id_agenda DESC LIMIT {$posisi},{$batas}");
while ($d = mysql_fetch_array($sql)) {
$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>";
