| Server IP : 88.223.91.82 / Your IP : 216.73.216.174 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/event/modules/lap-helm-masuk/ |
Upload File : |
<!-- Aplikasi Persediaan Obat pada Apotek
*******************************************************
* Developer : Vanny Hadiwijaya, S.Kom
* Company : Wijaya Studio
* Release Date : 14 November 2018
* Blog : vannyhadiwijaya.blogspot.com
* E-mail : vannyhadiwijaya@gmail.com
* Phone : +62-821-3297-2137
-->
<?php
session_start();
ob_start();
// Panggil koneksi database.php untuk koneksi database
require_once "../../config/database.php";
// panggil fungsi untuk format tanggal
include "../../config/fungsi_tanggal.php";
// panggil fungsi untuk format rupiah
include "../../config/fungsi_rupiah.php";
$hari_ini = date("d-m-Y");
// ambil data hasil submit dari form
$tgl1 = $_GET['tgl_awal'];
$explode = explode('-',$tgl1);
$tgl_awal = $explode[2]."-".$explode[1]."-".$explode[0];
$tgl2 = $_GET['tgl_akhir'];
$explode = explode('-',$tgl2);
$tgl_akhir = $explode[2]."-".$explode[1]."-".$explode[0];
if (isset($_GET['tgl_awal'])) {
$no = 1;
// fungsi query untuk menampilkan data dari tabel Helm masuk
$query = mysqli_query($mysqli, "SELECT a.kode_transaksi,a.tanggal_masuk,a.kode_helm,a.jumlah_masuk,b.kode_helm,b.nama_helm,b.satuan
FROM is_obat_masuk as a INNER JOIN is_helm as b ON a.kode_helm=b.kode_helm
WHERE a.tanggal_masuk BETWEEN '$tgl_awal' AND '$tgl_akhir'
ORDER BY a.kode_transaksi ASC")
or die('Ada kesalahan pada query tampil Transaksi : '.mysqli_error($mysqli));
$count = mysqli_num_rows($query);
}
?>
<html xmlns="http://www.w3.org/1999/xhtml"> <!-- Bagian halaman HTML yang akan konvert -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>th-z (lm)</title>
<link rel="stylesheet" type="text/css" href="../../assets/css/laporan.css" />
</head>
<body>
<div id="title">
LAPORAN DATA HELM MASUK
</div>
<?php
if ($tgl_awal==$tgl_akhir) { ?>
<div id="title-tanggal">
Tanggal <?php echo tgl_eng_to_ind($tgl1); ?>
</div>
<?php
} else { ?>
<div id="title-tanggal">
Tanggal <?php echo tgl_eng_to_ind($tgl1); ?> s.d. <?php echo tgl_eng_to_ind($tgl2); ?>
</div>
<?php
}
?>
<hr><br>
<div id="isi">
<table width="100%" border="0.3" cellpadding="0" cellspacing="0">
<thead style="background:#e8ecee">
<tr class="tr-title">
<th height="20" align="center" valign="middle">NO.</th>
<th height="20" align="center" valign="middle">KODE TRANSAKSI</th>
<th height="20" align="center" valign="middle">TANGGAL</th>
<th height="20" align="center" valign="middle">KODE HELM</th>
<th height="20" align="center" valign="middle">NAMA HELM</th>
<th height="20" align="center" valign="middle">JUMLAH MASUK</th>
<th height="20" align="center" valign="middle">SATUAN</th>
</tr>
</thead>
<tbody>
<?php
// jika data ada
if($count == 0) {
echo " <tr>
<td width='40' height='13' align='center' valign='middle'></td>
<td width='120' height='13' align='center' valign='middle'></td>
<td width='80' height='13' align='center' valign='middle'></td>
<td width='80' height='13' align='center' valign='middle'></td>
<td style='padding-left:5px;' width='155' height='13' valign='middle'></td>
<td style='padding-right:10px;' width='100' height='13' align='right' valign='middle'></td>
<td width='80' height='13' align='center' valign='middle'></td>
</tr>";
}
// jika data tidak ada
else {
// tampilkan data
while ($data = mysqli_fetch_assoc($query)) {
$tanggal = $data['tanggal_masuk'];
$exp = explode('-',$tanggal);
$tanggal_masuk = $exp[2]."-".$exp[1]."-".$exp[0];
// menampilkan isi tabel dari database ke tabel di aplikasi
echo " <tr>
<td width='40' height='13' align='center' valign='middle'>$no</td>
<td width='120' height='13' align='center' valign='middle'>$data[kode_transaksi]</td>
<td width='80' height='13' align='center' valign='middle'>$tanggal_masuk</td>
<td width='80' height='13' align='center' valign='middle'>$data[kode_helm]</td>
<td style='padding-left:5px;' width='155' height='13' valign='middle'>$data[nama_helm]</td>
<td style='padding-right:10px;' width='100' height='13' align='right' valign='middle'>$data[jumlah_masuk]</td>
<td width='80' height='13' align='center' valign='middle'>$data[satuan]</td>
</tr>";
$no++;
}
}
?>
</tbody>
</table>
<div id="footer-tanggal">
Pekanbaru, <?php echo tgl_eng_to_ind("$hari_ini"); ?>
</div>
<div id="footer-jabatan">
Pimpinan
</div>
<div id="footer-nama">
Susilawati Rusli
</div>
</div>
<!-- Script Untuk Print Laporan -->
<script>
window.print();
</script>
</body>
</html><!-- Akhir halaman HTML yang akan di konvert -->