$query = mysql_query($sql);
$d = mysql_fetch_array($query);
$jml = $d['jml'];
$satuan = $d3['satuan'];
$total = $jml * $satuan;
$t_jml = $t_jml + $jml;
$t_total = $t_total + $total;
echo "<tr>\n <td>{$no}</td>\n <td>{$d3['nm_kegiatan']}</td>\n <td>";
echo formatRupiah2($d3['satuan']);
echo "</td>\n <td>{$jml}</td>\n <td>";
echo formatRupiah2($total);
echo "</td>\n </tr> ";
$no++;
}
echo "\n <tr>\n <td colspan='3'><strong>Total Keseluruhan</strong></td><td></td><td>";
echo formatRupiah2($t_total);
echo "</td>\n </tr>";
?>
</tbody>
</table>
<?php
}
?>
<div class="clearfix">
</div>
</div>
$sqla = "SELECT\n\t\tcount(*)as totall, \n\t\tsum(kend_bbn1_pokok) as j1,\n\t\tsum(kend_bbn2_pokok) as j2,\n\t\tsum(kend_pkb_pokok) as j3,\n\t\tsum(kend_tpkb_pokok) as j4\n \n\tFROM tbm_notice \n\tWHERE utl_cetak_notice_tgl='{$waktu}' AND utl_cetak_notice='-1'";
$tbl1 = odbc_exec($koneksi, $sqla);
while (odbc_fetch_array($tbl1)) {
$a = odbc_result($tbl1, "j1");
$b = odbc_result($tbl1, "j2");
$c = odbc_result($tbl1, "j3");
$d = odbc_result($tbl1, "j4");
$tota = $a + $b + $c + $d;
$obyk = odbc_result($tbl1, "totall");
echo "<tr>";
echo "<td>Total Hari Ini</td>";
echo "<td><div align='right'>" . formatRupiah2($a) . "</div></td>";
echo "<td><div align='right'>" . formatRupiah2($b) . "</div></td>";
echo "<td><div align='right'>" . formatRupiah2($c) . "</div></td>";
echo "<td><div align='right'>" . formatRupiah2($d) . "</div></td>";
echo "<td><div align='right'>" . formatRupiah2($tota) . "</div></td>";
echo "<td><div align='right'>" . $obyk . "</div></td>";
echo "</tr>";
}
$bln = gmdate("m", time() + 60 * 60 * 7);
$cetak = $bln - 1;
echo "<br>" . $cetak;
if ($cetak == 1 or $cetak == 2 or $cetak == 3 or $cetak == 4 or $cetak == 5 or $cetak == 6 or $cetak == 7 or $cetak == 8 or $cetak == 9) {
$cetakh = "0" . $cetak;
} else {
$cetakh = $cetak;
}
$qla = "SELECT\n\t\t\n count(*)as totall,\n sum(kend_bbn1_pokok) as jm1,\n sum(kend_bbn2_pokok) as jm2,\n sum(kend_pkb_pokok) as jm3,\n sum(kend_tpkb_pokok) as jm4\n\n FROM tbm_notice\n WHERE utl_cetak_notice_tgl <='{$waktu}' AND utl_cetak_notice='-1' ";
$t2 = odbc_exec($koneksi, $qla);
odbc_fetch_array($t2);
$a1 = odbc_result($t2, "jm1");
