Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
bagaimana koding menampilkan cetak laporan?
saya sudah membuat koding laporan penjualan. namun ketika dijalankan masih error. dimana ya letak salah nya?
sebelumnya terimakasih.
ini koding laporan_penjualan.php
<?php
include '../../../../helper/connection.php';
?>
<?php
session_start();
if(!$_SESSION['username'] && !$_SESSION['password'] && $_SESSION['tipe_user'] != "Admin")
{
echo "
<script type='text/javascript'>
alert('Anda harus login terlebih dahulu!')
window.location='../../../index.php';
</script>";
}
else
{
?>
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="../../../assets/vendor/bootstrap/css/bootstrap.min.css">
<link href="../../../assets/vendor/fonts/circular-std/style.css" rel="stylesheet">
<link rel="stylesheet" href="../../../assets/libs/css/style.css">
<link rel="stylesheet" href="../../../assets/vendor/fonts/fontawesome/css/fontawesome-all.css">
<link rel="stylesheet" href="../../../assets/vendor/charts/chartist-bundle/chartist.css">
<link rel="stylesheet" href="../../../assets/vendor/charts/morris-bundle/morris.css">
<link rel="stylesheet" href="../../../assets/vendor/fonts/material-design-iconic-font/css/materialdesignicons.min.css">
<link rel="stylesheet" href="../../../assets/vendor/charts/c3charts/c3.css">
<link rel="stylesheet" href="../../../assets/vendor/fonts/flag-icon-css/flag-icon.min.css">
<link href='../../../../images/logo.png' rel='SHORTCUT ICON' />
<title>Admin | Toko Naga Mas</title>
</head>
<body>
<!-- ============================================================== -->
<!-- main wrapper -->
<!-- ============================================================== -->
<div class="dashboard-main-wrapper">
<!-- ============================================================== -->
<!-- navbar -->
<!-- ============================================================== -->
<div class="dashboard-header">
<nav class="navbar navbar-expand-lg bg-white fixed-top">
<a class="navbar-brand" href="../../../dashboard.php">Toko Naga Mas</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent"
aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse " id="navbarSupportedContent">
<ul class="navbar-nav ml-auto navbar-right-top">
<li class="nav-item">
</li>
<li class="nav-item dropdown nav-user">
<a class="nav-link nav-user-img" href="#" id="navbarDropdownMenuLink2" data-toggle="dropdown"
aria-haspopup="true" aria-expanded="false"><img src="../../../assets/images/avatar-1.jpg"
alt="" class="user-avatar-md rounded-circle"> Admin <i class="fas fa-angle-down"></i></a>
<div class="dropdown-menu dropdown-menu-right nav-user-dropdown" aria-labelledby="navbarDropdownMenuLink2">
<a class="dropdown-item" href="../../../process/logout.php"><i class="fas fa-power-off mr-2"></i>Logout</a>
</div>
</li>
</ul>
</div>
</nav>
</div>
<!-- ============================================================== -->
<!-- end navbar -->
<!-- ============================================================== -->
<!-- ============================================================== -->
<!-- left sidebar -->
<!-- ============================================================== -->
<div class="nav-left-sidebar sidebar-dark">
<div class="menu-list">
<nav class="navbar navbar-expand-lg navbar-light">
<a class="d-xl-none d-lg-none" href="#">Dashboard</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav"
aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav flex-column">
<li class="nav-divider">
Menu
</li>
<li class="nav-item ">
<a class="nav-link" href="../../../dashboard.php" aria-expanded="false" data-target="#submenu-1"
aria-controls="submenu-1"><i class="fa fa-fw fa-user-circle"></i>Dashboard
<span class="badge badge-success">6</span></a>
</li>
<li class="nav-item">
<a class="nav-link active" href="#" data-toggle="collapse" aria-expanded="true"
data-target="#submenu-5" aria-controls="submenu-5"><i class="fas fa-fw fa-table"></i>Tables</a>
<div id="submenu-5" class="collapse submenu show" style="">
<ul class="nav flex-column">
<li class="nav-item active">
<a class="nav-link" href="../susu/table_susu.php">Data Susu</a>
</li>
<li class="nav-item">
<a class="nav-link" href="../merek/table_merek.php">Data Merk</a>
</li>
<li class="nav-item">
<a class="nav-link" href="../customer/table_customer.php">Data Customer</a>
</li>
<li class="nav-item">
<a class="nav-link" href="../kategori/table_kategori.php">Data Kategori</a>
</li>
<li class="nav-item">
<a class="nav-link" href="../transaksi/table_transaksi.php">Data Transaksi</a>
</li>
<li class="nav-item">
<a class="nav-link" href="../user/table_user.php">Data User</a>
</li>
<li class="nav-item">
<a class="nav-link" href="../laporan/laporan_penjualan.php">Laporan</a>
</li>
</ul>
</div>
</li>
</ul>
</div>
</nav>
</div>
</div>
<!-- ============================================================== -->
<!-- end left sidebar -->
<!-- ============================================================== -->
<!-- ============================================================== -->
<!-- wrapper -->
<!-- ============================================================== -->
<div class="dashboard-wrapper">
<div class="dashboard-ecommerce">
<div class="container-fluid dashboard-content ">
<!-- ============================================================== -->
<!-- pageheader -->
<!-- ============================================================== -->
<div class="row">
<div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
<div class="page-header">
<h2 class="pageheader-title">Laporan</h2>
<div class="page-breadcrumb">
<nav aria-label="breadcrumb">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="#" class="breadcrumb-link">Tables</a></li>
<li class="breadcrumb-item active" aria-current="page">Laporan Penjualan</li>
</ol>
</nav>
</div>
</div>
</div>
</div>
<div class="col-xl-12">
<div class="card">
<h5 class="card-header">Laporan Penjualan</h5>
<div class="card-body">
<div class="col-md-12">
<form method="POST" class="form-inline">
<div class="form-group">
<input type="date" id="tgl1" class="form-control" name="tgl1">
</div>
<div class="form-group">
<label> Sampai </label>
<input type="date" id="tgl2" class="form-control" name="tgl2">
</div>
<div class="form-group">
<button id="formbtn" name="prosess" class="btn btn-primary"><i class="fa fa-play-circle-o"></i> Prosess</button>
<button class="btn btn-success" name="semua"><i class="fa fa-play-circle-o"></i> Semua Data</button>
</div>
</form>
</div>
</div>
<hr/>
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-heading" align="center">
<?php if (isset($_POST['prosess'])): ?>
<a href="laporan/cetaklaporanpenjualan.php?tgl1=<?php echo $_POST['tgl1']; ?>&tgl2=<?php echo $_POST['tgl2']; ?>" target="_BLANK" class="btn btn-info"><i class="fa fa-print"></i> Cetak</a>
<?php endif ?>
<?php if (isset($_POST['semua'])): ?>
<a href="laporan/cetaklaporanpenjualan.php?semua" target="_BLANK" class="btn btn-info"><i class="fa fa-print"></i> Cetak</a>
<?php endif ?>
<?php if (!isset($_POST['prosess']) && !isset($_POST['semua'])): ?>
<a href="#" class="btn btn-info" disabled="disabled"><i class="fa fa-print"></i> Cetak</a>
<?php endif ?>
</div>
<div class="panel-body">
<table class="table table-bordered table-hover">
<thead>
<tr class="active">
<th>No</th>
<th>Kode Susu</th>
<th>Tgl Transaksi</th>
<th>Nama Susu</th>
<th>Jumlah</th>
<th>Harga</th>
<th>Total</th>
</tr>
</thead>
<tbody>
<?php
if (isset($_POST['prosess'])) {
$total = $laporan->hitung_total_penjualan_bulan($_POST['tgl1'],$_POST['tgl2']);
$cek = $laporan->cek_penjualan_bulan($_POST['tgl1'],$_POST['tgl2']);
if ($cek === false) {
echo "<tr><td colspan='8' align='center'>Data Kosong</td></tr>";
}
else{
$lapbl = $laporan->tampil_penjualan_bulan($_POST['tgl1'],$_POST['tgl2']);
foreach ($lapbl as $index => $data) {
?>
<tr>
<td><?php echo $index + 1; ?></td>
<td><?php echo $data['kd_susu']; ?></td>
<td><?php echo date_format(date_create($data['tgl_transaksi']),'d-m-Y'); ?></td>
<td><?php echo $data['nm_susu']; ?></td>
<td><?php echo $data['jumlah']; ?></td>
<td>Rp. <?php echo number_format($data['harga']); ?></td>
<td>Rp. <?php echo number_format($data['total']); ?></td>
</tr>
<?php
}
?>
<?php
}?>
<tr>
<td colspan="7" align="center">TOTAL</td>
<td>Rp. <?php echo number_format($total); ?></td>
</tr>
<?php
}
elseif (isset($_POST['semua'])) {
$total = $laporan->hitung_total_penjualan();
$cek = $laporan->cek_penjualan();
if ($cek === false) {
echo "<tr><td colspan='8' align='center'>Data Kosong</td></tr>";
}
else{
$lap = $laporan->tampil_penjualan();
foreach ($lap as $index => $data) {
?>
<tr>
<td><?php echo $index + 1; ?></td>
<td><?php echo $data['kd_susu']; ?></td>
<td><?php echo date_format(date_create($data['tgl_transaksi']),'d-m-Y'); ?></td>
<td><?php echo $data['nm_susu']; ?></td>
<td><?php echo $data['jumlah']; ?></td>
<td>Rp. <?php echo number_format($data['harga']); ?></td>
<td>Rp. <?php echo number_format($data['total']); ?></td>
</tr>
<?php
}
?>
<?php
}?>
<tr>
<td colspan="7" align="center">TOTAL</td>
<td>Rp. <?php echo number_format($total); ?></td>
</tr>
<?php
}
else{
?>
<tr>
<td colspan="8" align="center">Pilih Opsi Tampil</td>
</tr>
<tr>
<td colspan="7" align="center">TOTAL</td>
<td></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- ============================================================== -->
<!-- footer -->
<!-- ============================================================== -->
<div class="footer">
<div class="container-fluid">
<div class="row">
<div class="col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12">
Copyright © 2021 Toko Naga Mas All rights reserved.
</div>
<div class="col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12">
</div>
</div>
</div>
</div>
<!-- ============================================================== -->
<!-- end footer -->
<!-- ============================================================== -->
</div>
<!-- ============================================================== -->
<!-- end wrapper -->
<!-- ============================================================== -->
</div>
<!-- ============================================================== -->
<!-- end main wrapper -->
<!-- ============================================================== -->
<!-- Optional JavaScript -->
<!-- jquery 3.3.1 -->
<script src="../../../assets/vendor/jquery/jquery-3.3.1.min.js"></script>
<!-- bootstap bundle js -->
<script src="../../../assets/vendor/bootstrap/js/bootstrap.bundle.js"></script>
<!-- slimscroll js -->
<script src="../../../assets/vendor/slimscroll/jquery.slimscroll.js"></script>
<!-- main js -->
<script src="../../../assets/libs/js/main-js.js"></script>
<!-- chart chartist js -->
<script src="../../../assets/vendor/charts/chartist-bundle/chartist.min.js"></script>
<!-- sparkline js -->
<script src="../../../assets/vendor/charts/sparkline/jquery.sparkline.js"></script>
<!-- morris js -->
<script src="../../../assets/vendor/charts/morris-bundle/raphael.min.js"></script>
<script src="../../../assets/vendor/charts/morris-bundle/morris.js"></script>
<!-- chart c3 js -->
<script src="../../../assets/vendor/charts/c3charts/c3.min.js"></script>
<script src="../../../assets/vendor/charts/c3charts/d3-5.4.0.min.js"></script>
<script src="../../../assets/vendor/charts/c3charts/C3chartjs.js"></script>
<script src="../../../assets/libs/js/dashboard-ecommerce.js"></script>
<script src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
<script>
$(document).ready(function () {
$('#tabell').DataTable();
});
</script>
</body>
</html>
<?php } ?>
sementara ini koding cetaklaporanpenjualan.php
<style type="text/css">
*{
font-family: Arial;
font-size: 12px;
margin:0px;
padding:0px;
}
@page {
margin-left:3cm 2cm 2cm 2cm;
}
.container{
margin-top: 10px;
width: 800px;
margin-left: auto;
margin-right: auto;
}
table.grid{
width:20.4cm ;
font-size: 9pt;
border-collapse:collapse;
}
table.grid th{
padding-top:1mm;
padding-bottom:1mm;
}
table.grid th{
background: #F0F0F0;
border: 0.2mm solid #000;
text-align:center;
padding-left:0.2cm;
}
table.grid tr td{
padding-top:0.5mm;
padding-bottom:0.5mm;
padding-left:2mm;
border:0.2mm solid #000;
}
h1{
font-size: 18pt;
}
h2{
font-size: 14pt;
}
h3{
font-size: 10pt;
}
.header{
display: block;
width:20.4cm ;
margin-bottom: 0.3cm;
text-align: center;
margin-top: 10px;
}
.attr{
font-size:9pt;
width: 100%;
padding-top:2pt;
padding-bottom:2pt;
border-top: 0.2mm solid #000;
border-bottom: 0.2mm solid #000;
}
.pagebreak {
width:20cm ;
page-break-after: always;
margin-bottom:10px;
}
.akhir {
width:20cm ;
}
.page {
font-size:13px;
padding-top: 20px;
}
.footer{
padding-top: 20px;
margin-left: 600px;
}
</style>
<?php
include '../laporan/class.php';
if (isset($_GET['tgl1']) && isset($_GET['tgl2'])) {
$dat = $cetaklaporan->laporan_penjualan_bulan($_GET['tgl1'],$_GET['tgl2']);
}else{
$dat = $cetaklaporan->laporan_semua_penjualan();
}
$judul_H = "CETAK BUKTI PENJUALAN <br>";
$tgl = date('d-m-Y');
function myheader($judul_H){
echo "<div class='header'>
<h2>".$judul_H."</h2>
</div>
<table class='grid'>
<tr>
<th width='3%'>No</th>
<th>Kode Susu</th>
<th>Tgl Transaksi</th>
<th>Nama Susu</th>
<th>Jumlah</th>
<th>Harga</th>
<th>Total</th>
</tr>";
}
function myfooter(){
echo "</table>";
}
echo "<div class='container' align='center'>";
$page =1;
$gtotal ="";
foreach ($dat as $index => $data) {
$no = $index + 1;
$total = $data['harga']*$data['jumlah'];
$gtotal = $gtotal + $total;
if(($no % 25) == 1){
if($index + 1 > 1){
myfooter();
echo "<div class='pagebreak'>
<div class='page' align='center'>Hal - $page</div>
</div>";
$page++;
}
myheader($judul_H);
}
echo "<tr>
<td align='center'>$no</td>
<td align='center'>$data[kd_susu]</td>
<td align='left'>".date_format(date_create($data['tgl_transaksi']),'d-m-Y')."</td>
<td align='center'>$data[nm_susu]</td>
<td align='center'>$data[jumlah]</td>
<td align='left'>Rp. ".number_format($data['harga'])."</td>
<td align='left'>Rp. ".number_format($total)."</td>
</tr>";
}
echo "<tr><td colspan='7' align='center'><b>Total</b></td><td><b>Rp. ".number_format($gtotal)."</td></tr>";
myfooter();
echo "<div class='footer'>
<div>$kota, ".date('d-m-Y')."</div>
<div style='margin-top:90px; margin-right:5px;'>$pemilik</div>
</div>";
echo "<div class='page' align='center'>Hal - ".$page."</div>";
echo "</div>";
?>
<script type="text/javascript">
window.print();
</script>
Tanggapan
Errornya seperti apa? Bisa di lampirkan screenshot nya mungkin, Agar mudah dianalisa
2 Jawaban:
<div>Coba kamu perhatikan kembali kecocokan antara nama kolum yang kamu buat . tiap komponen apa yang kamu beri nama pada form , hrus sesuai . jng sampai berbeda . nanti akan munculnya eror </div>
<div>kayak gini gan error nya<br><figure data-trix-attachment="{"contentType":"image/jpeg","filename":"w.jpg","filesize":56971,"height":372,"url":"https://i.ibb.co/DWLZLdP/w.jpg","width":1360}" data-trix-content-type="image/jpeg" data-trix-attributes="{"presentation":"gallery"}" class="attachment attachment--preview attachment--jpg"><img src="https://i.ibb.co/DWLZLdP/w.jpg" width="1360" height="372"><figcaption class="attachment__caption"><span class="attachment__name">w.jpg</span></figcaption></figure></div>