// $saldo = $db['jml']*$db['harga_beli']; // $jml = $jml; if ($no % 40 == 1) { if ($no > 1) { myfooter(); ?> <div class="pagebreak" align="right"> <div class="page" align="center"><?php //hal ?> </div> </div> <?php $page++; } myheader($kop, $kop_kanan, $judul_H, $kop_noreg); } ?> <tr> <td colspan="3" > <?php if ($db['racikan'] == 1) { echo '(r)' . $db['nama_obat']; } else { echo $db['nama_obat']; } ?> (<?php echo $db['dosis']; ?> )</td> <td align="right"><?php
{ echo "</table>"; } $no = 1; $page = 1; while ($r_data = mysql_fetch_array($data)) { $tgllhr = jin_date_str($r_data['tgl_lahir']); $simpanan = simpanan($r_data['noanggota']); $pinjaman = sisaAngsuran($r_data['noanggota']); if ($no % 40 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\n\t\t<div class='page' align='center'>Hal - {$page}</div>\n\t\t</div>"; $page++; } myheader($profil, $judul_H); } echo "<tr>\n\t\t\t<td align='center'>{$no}</td>\n\t\t\t<td align='center'>{$r_data['noanggota']}</td>\n\t\t\t<td align='center'>{$r_data['noidentitas']}</td>\n\t\t\t<td align='left'>{$r_data['namaanggota']}</td>\n\t\t\t<td align='center'>{$r_data['jk']}</td>\n\t\t\t<td align='left'>{$r_data['tempat_lahir']}, {$tgllhr}</td>\n\t\t\t<td align='left'>{$r_data['alamat']}</td>\n\t\t\t<td align='left'>{$r_data['hp']}</td>\n\t\t\t<td align='right'>" . number_format($simpanan) . "</td>\n\t\t\t<td align='right'>" . number_format($pinjaman) . "</td>\n\t\t\t</tr>"; $no++; } myfooter(); echo "</table>"; //echo "<div class='akhir' align='right'> // Total <b>".number_format($gtotal)."</b> // </div>"; echo "<br>"; echo "<div class='akhir' align='right'>"; $kota = kotakoperasi(1); echo $kota . ", " . date('d F Y'); echo "<br>Staf Koperasi"; echo "<br><br><br>";
$jml = 0; foreach ($data->result_array() as $db) { if ($no % 40 == 1) { if ($no > 1) { myfooter(); ?> <div class="pagebreak" align="right"> <div class="page" align="center"><?php //hal ?> </div> </div> <?php $page++; } myheader($kop, $kop_kanan, $judul_H, $kop_alamat, $cara_bayar, $kop_nm_kota, $kop_nm_propinsi, $tanggal); } ?> <tr> <td align="center" style="font-size: 55px"><?php echo $db['no_antrian']; ?> </td> </tr> <tr> <td align="center"><?php echo '( ' . $db['nm_unit'] . ' )'; ?> <br/><br/></td> </tr> <tr>
$saldo = $db['jml']; $jml = $jml + $saldo; if ($no % 40 == 1) { if ($no > 1) { myfooter(); ?> <div class="pagebreak" align="right"> <div class="page" align="center"><?php //hal ?> </div> </div> <?php $page++; } myheader($kop, $logo_pus, $judul_H); } ?> <tr> <td align="center"><?php echo $no; ?> </td> <td align="center"><?php echo $db['jml'] . " " . $db['sat_kecil_obat']; ?> </td> <td><?php echo $db['nama_obat']; ?> </td>
<?php } $no = 1; $page = 1; $total = 0; $g_total = 0; foreach ($data->result_array() as $dp) { $total = $dp['jml'] * $dp['harga']; $tgl = $this->m_crud->tgl_indo($dp['tgl_bayar']); if ($no % 25 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\n\t\t<div class='page' align='center'>Hal - {$page}</div>\n\t\t</div>"; $page++; } myheader($kop, $logo_pus, $kop_kanan, $judul_H); } ?> <tr> <td style="text-align: center; width: 20px;"><?php echo $no; ?> </td> <td style="text-align: center; width: 20px;"><?php echo $dp['kd_bayar']; ?> </td> <td style="text-align: center; width: 110px;"><?php echo $tgl; ?> </td>
} function myfooter() { echo "</table>"; } $no = 1; $page = 1; foreach ($data->result_array() as $r) { $tgl = $this->app_model->tgl_indo($r['tgl_pengajuan']); if ($no % 25 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\n\t\t<div class='page' align='center'>Hal - {$page}</div>\n\t\t</div>"; $page++; } myheader($kiri, $kanan, $judul); } ?> <tr> <td align="center"><?php echo $no; ?> </td> <td align="center"><?php echo $r['nmr_surat']; ?> </td> <td align="center"><?php echo $tgl; ?> </td>
$total = $dp['jml']; $tgl = $this->m_crud->tgl_indo($dp['opname_tgl']); if ($no % 25 == 1) { if ($no > 1) { myfooter(); ?> <div class="pagebreak" align="right"> <div class="page" align="center"><?php //hal ?> </div> </div> <?php $page++; } myheader($kop, $kop_kanan, $judul_H); } ?> <tr> <td width="20" align="center"><?php echo $no; ?> </td> <td align="center"><?php echo $dp['opname_code']; ?> </td> <td align="center"><?php echo $tgl; ?> </td>
$debet = $r_data['jumlah']; $kredit = 0; } else { $debet = 0; $kredit = $r_data['jumlah']; } $saldo = $saldo + $debet - $kredit; //$total = $r_data[hargabeli]*$r_data[jmlbeli]; //$gtotal = $gtotal+$total; if ($no % 40 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\r\n\t\t<div class='page' align='center'>Hal - {$page}</div>\r\n\t\t</div>"; $page++; } myheader($judul_H); } echo "<tr>\r\n\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t<td align='center'>{$tgl}</td>\r\n\t\t\t<td align='left'>{$jenis} [{$r_data['ket']}]</td>\r\n\t\t\t<td align='right'>" . number_format($debet) . "</td>\r\n\t\t\t<td align='right'>" . number_format($kredit) . "</td>\r\n\t\t\t<td align='right'>" . number_format($saldo) . "</td>\r\n\t\t\t</tr>"; $no++; } myfooter(); echo "</table>"; /* echo "<div class='akhir' align='right'> Total : <b>".number_format($gtotal)."</b> </div>"; */ echo "<div class='page' align='center'>Hal - " . $page . "</div>"; /* header("Content-type: application/x-msdownload"); header("Content-Disposition: attachment; filename=laporan.xls");
if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\n <div class='page' align='center'>Hal - {$page}</div>\n </div>"; $page++; // ?> <!-- <div class="pagebreak" align="right">--> <!-- <div class="page" align="center">--><?php ////hal ?> <!--</div>--> <!-- </div>--> <!-- --><?php // $page++; } myheader($kop, $kop_kanan, $judul_H, $kop_pasien, $kop_umur, $kop_alamat, $kop_rkm); } ?> <tr> <td colspan="3" ><?php echo $db['produk']; ?> ( <?php echo $db['jml']; ?> x <?php echo number_format($db['harga_jual']); ?> )</td> <td align="right"><?php echo number_format($saldo);
$tglbayar = jin_date_str($r_data['tgl_bayar']); $angsuran = $r_data['angsuran']; $bunga = $r_data['bunga']; $total = $angsuran + $bunga; $jmlbayar = $r_data['jumlah_bayar']; //$total = $r_data[hargabeli]*$r_data[jmlbeli]; $gtotal = $gtotal + $total; $sisa = $sisa + $jmlbayar; $tsisa = $gtotal - $sisa; if ($no % 40 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\r\n\t\t<div class='page' align='center'>Hal - {$page}</div>\r\n\t\t</div>"; $page++; } myheader($profil, $judul_H, $ket); } echo "<tr>\r\n\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t<td align='center'>{$r_data['cicilan']}</td>\r\n\t\t\t<td align='center'>{$tgl}</td>\r\n\t\t\t<td align='right'>" . number_format($angsuran) . "</td>\r\n\t\t\t<td align='right'>" . number_format($bunga) . "</td>\r\n\t\t\t<td align='center'>" . number_format($total) . "</td>\r\n\t\t\t<td align='center'>{$tglbayar}</td>\r\n\t\t\t<td align='center'>" . number_format($jmlbayar) . "</td>\r\n\t\t\t</tr>"; $no++; } echo "<tr>\r\n\t\t\t<td colspan='5' align='center'>Total</td>\t\r\n\t\t\t<td align='right'><b>" . number_format($gtotal) . "</b></td>\r\n\t\t\t<td></td>\r\n\t\t\t<td align='right'><b>" . number_format($sisa) . "</b></td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td colspan='5' align='center'>Sisa Tagihan</td>\t\r\n\t\t\t<td colspan='3' align='center'><b>" . number_format($tsisa) . "</b></td>\r\n\t\t</tr>\r\n\t\t"; myfooter(); /* echo "<tr> <td colspan='5' align='center'>Total Tagihan</td> <td><b>".number_format($gtotal)."</b></td> </tr>"; echo "<tr> <td colspan='5' align='center'>Total Bayar</td> <td><b>".number_format($sisa)."</b></td> </tr>";
<?php } function myfooter() { echo "</table>"; } $no = 1; $page = 1; foreach ($data->result_array() as $r) { if ($no % 25 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\n\t\t<div class='page' align='center'>Hal - {$page}</div>\n\t\t</div>"; $page++; } myheader($kiri, $logo_pus, $kanan, $judul); } ?> <tr> <td align="center"><?php echo $no; ?> </td> <td align="center"><?php echo $r['kd_obat']; ?> </td> <td ><?php echo $r['nama_obat']; ?> </td>
$templine = ''; } } //echo "Import Website DB Import Done<br/>"; if ($_POST['ldomain'] != '') { mysql_query("UPDATE Config SET value='" . $_POST['ldomain'] . "' WHERE name='live_domain'"); //echo 'live_domain Updated for Website DB<br/>'; } if ($_POST['sdomain'] != '') { mysql_query("UPDATE Config SET value='" . $_POST['sdomain'] . "' WHERE name='staging_domain'"); //echo 'staging_domain Updated for Website DB<br/>'; } mysql_close(); } } myheader("index.php?install=1"); } define('BASEPATH', TRUE); if ($_GET['fixdir'] != '') { if (chmod($_GET['fixdir'], 0777)) { // more code chmod($_GET['fixdir'], 0755); } else { echo $_GET['fixdir'] . " Not Fixed contact administrator."; } } /* if ($_GET['fixdbmanage']=='y' || $_GET['fixdbweb']=='y'){ require_once($cms_dir.'../cms/local/database.php'); if (!(empty($db['default']['hostname']) || empty($db['default']['username']) || empty($db['default']['password']) || empty($db['default']['database']))) {
echo "</table>"; } $no = 1; $page = 1; foreach ($data->result_array() as $r) { $jur1 = $this->app_model->cari_jurusan($r['Jur1']); $jur2 = $this->app_model->cari_jurusan($r['Jur2']); $jur3 = $this->app_model->cari_jurusan($r['Jur3']); $tgl = $this->app_model->tgl_str($r['TglLhr']); if ($no % 15 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\r\n\t\t<div class='page' align='center'>Hal - {$page}</div>\r\n\t\t</div>"; $page++; } myheader($th); } ?> <tr> <td align="center"><?php echo $no; ?> </td> <td align="center"><?php echo $r['NoUjian']; ?> </td> <td align="center"><?php echo $r['NoDaftar']; ?> </td>
$saldo = $db['jml'] * $db['harga_jual']; $jml = $jml + $saldo; if ($no % 40 == 1) { if ($no > 1) { myfooter(); ?> <div class="pagebreak" align="right"> <div class="page" align="center"><?php //hal ?> </div> </div> <?php $page++; } myheader($kop, $kop_kanan, $judul_H, $pasien); } ?> <tr> <td colspan="3" ><?php echo $db['nama_obat']; ?> <br/><?php echo $db['jml']; ?> x <?php echo number_format($db['harga_jual']); ?> </td> <td align="right"><?php echo number_format($saldo);
$no = 1; $page = 1; while ($r_data = mysql_fetch_array($data)) { $tgl = jin_date_str($r_data['tgl_jatuh_tempo']); $angsuran = $r_data['angsuran']; $bunga = $r_data['bunga']; $total = $angsuran + $bunga; //$total = $r_data[hargabeli]*$r_data[jmlbeli]; $gtotal = $gtotal + $total; if ($no % 40 == 1) { if ($no > 1) { myfooter(); echo "<div class=\"pagebreak\" align='right'>\r\n\t\t<div class='page' align='center'>Hal - {$page}</div>\r\n\t\t</div>"; $page++; } myheader($judul_H, $ket); } echo "<tr>\r\n\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t<td align='center'>{$r_data['cicilan']}</td>\r\n\t\t\t<td align='center'>{$tgl}</td>\r\n\t\t\t<td align='right'>" . number_format($angsuran) . "</td>\r\n\t\t\t<td align='right'>" . number_format($bunga) . "</td>\r\n\t\t\t<td align='center'>" . number_format($total) . "</td>\r\n\t\t\t</tr>"; $no++; } myfooter(); echo "</table>"; echo "<div class='akhir' align='right'>\r\n\t\t\tTotal : <b>" . number_format($gtotal) . "</b>\r\n\t\t</div>"; echo "<div class='page' align='center'>Hal - " . $page . "</div>"; /* header("Content-type: application/x-msdownload"); header("Content-Disposition: attachment; filename=laporan.xls"); header("Pragma: no-cache"); header("Expires: 0"); */ //echo $content;
if ($openonly) { $ret .= "&openonly={$openonly}"; } if ($orderbyid) { $ret .= "&orderbyid={$orderbyid}"; } return $ret; } // Sanitizing input: if (!is_numeric($lastrev)) { $lastrev = ""; } if (!is_numeric($firstrev)) { $firstrev = ""; } myheader("Querying the JUnit database"); $db = new PDO("sqlite:{$dbfile}"); // Getting revisions and creating table header: if ($firstrev == "") { $sql = "SELECT id FROM revisions"; if ($lastrev != "") { $sql .= " where id<='{$lastrev}'"; } $sql .= " order by tested desc "; foreach ($db->query($sql) as $minrevision) { $id = $minrevision['id']; $i++; if ($i <= $maxrevs) { $minrev = $id; } }