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