| Server IP : 91.108.119.88 / 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-keluar/ |
Upload File : |
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
<i class="fa fa-file-text-o icon-title"></i> Laporan Data Penjualan
</h1>
<ol class="breadcrumb">
<li><a href="?module=beranda"><i class="fa fa-home"></i> Beranda</a></li>
<li class="active">Laporan</li>
<li class="active">Data Penjualan</li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-md-12">
<!-- Form Laporan -->
<div class="box box-primary">
<!-- form start -->
<form role="form" class="form-horizontal" method="GET" action="modules/lap-helm-keluar/cetak.php" target="_blank">
<div class="box-body">
<div class="form-group">
<label class="col-sm-1">Tanggal</label>
<div class="col-sm-2">
<input type="text" class="form-control date-picker" data-date-format="dd-mm-yyyy" name="tgl_awal" autocomplete="off" required>
</div>
<label class="col-sm-1">s.d.</label>
<div class="col-sm-2">
<input style="margin-left:-35px" type="text" class="form-control date-picker" data-date-format="dd-mm-yyyy" name="tgl_akhir" autocomplete="off" required>
</div>
</div>
</div>
<div class="box-footer">
<div class="form-group">
<div class="col-sm-offset-1 col-sm-11">
<button type="submit" class="btn btn-primary btn-social btn-submit">
<i class="fa fa-print"></i> Cetak
</button>
</div>
</div>
</div>
</form>
</div><!-- /.box -->
</div><!--/.col -->
</div> <!-- /.row -->
</section><!-- /.content -->
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-md-12">
<?php
// fungsi untuk menampilkan pesan
// jika alert = "" (kosong)
// tampilkan pesan "" (kosong)
if (empty($_GET['alert'])) {
echo "";
}
// jika alert = 1
// tampilkan pesan Sukses "Data Helm Masuk berhasil disimpan"
elseif ($_GET['alert'] == 1) {
echo "<div class='alert alert-success alert-dismissable'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4> <i class='icon fa fa-check-circle'></i> Sukses!</h4>
Data Helm Keluar berhasil disimpan.
</div>";
}
?>
<div class="box box-primary">
<div class="box-body">
<!-- tampilan tabel Helm -->
<table id="dataTables1" class="table table-bordered table-striped table-hover">
<!-- tampilan tabel header -->
<thead>
<tr>
<th class="center">No.</th>
<th class="center">Kode Transaksi</th>
<th class="center">Tanggal</th>
<th class="center">Kode Helm</th>
<th class="center">Nama Helm</th>
<th class="center">Jumlah Keluar</th>
<th class="center">Satuan</th>
</tr>
</thead>
<!-- tampilan tabel body -->
<tbody>
<?php
$no = 1;
// fungsi query untuk menampilkan data dari tabel helm
$query = mysqli_query($mysqli, "SELECT a.kode_transaksi,a.tanggal_keluar,a.kode_helm,a.jumlah_keluar,b.kode_helm,b.nama_helm,b.satuan
FROM penjualan as a INNER JOIN is_helm as b ON a.kode_helm=b.kode_helm ORDER BY kode_transaksi DESC")
or die('Ada kesalahan pada query tampil Data Obat Masuk: '.mysqli_error($mysqli));
// tampilkan data
while ($data = mysqli_fetch_assoc($query)) {
$tanggal = $data['tanggal_keluar'];
$exp = explode('-',$tanggal);
$tanggal_keluar = $exp[2]."-".$exp[1]."-".$exp[0];
// menampilkan isi tabel dari database ke tabel di aplikasi
echo "<tr>
<td width='30' class='center'>$no</td>
<td width='100' class='center'>$data[kode_transaksi]</td>
<td width='80' class='center'>$tanggal_keluar</td>
<td width='80' class='center'>$data[kode_helm]</td>
<td width='200'>$data[nama_helm]</td>
<td width='100' align='right'>$data[jumlah_keluar]</td>
<td width='80' class='center'>$data[satuan]</td>
</tr>";
$no++;
}
?>
</tbody>
</table>
</div><!-- /.box-body -->
</div><!-- /.box -->
</div><!--/.col -->
</div> <!-- /.row -->
</section><!-- /.content