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