Postingan lainnya
error saat membuat report pdf di php
saya lagi membuat eksport data ke pdf tapi ada error seperti ini untuk pemanggilan file config dan class html2pdf udah benar.
Parse error: syntax error, unexpected 'if' (T_IF) in C:\xampp\htdocs\newperpus1\admin\exporttransaksipdf.php on line 78
apa yg salah ya ?
file exporttransaksipdf.php
<?php
require_once '../config/config.php';
function terlambat($tgl_dateline, $tgl_kembali) {
$tgl_dateline_pcs = explode ("-", $tgl_dateline);
$tgl_dateline_pcs = $tgl_dateline_pcs[2]."-".$tgl_dateline_pcs[1]."-".$tgl_dateline_pcs[0];
$tgl_kembali_pcs = explode ("-", $tgl_kembali);
$tgl_kembali_pcs = $tgl_kembali_pcs[2]."-".$tgl_kembali_pcs[1]."-".$tgl_kembali_pcs[0];
$selisih = strtotime ($tgl_kembali_pcs) - strtotime ($tgl_dateline_pcs);
$selisih = $selisih / 86400;
if ($selisih>=1) {
$hasil_tgl = floor($selisih);
}
else {
$hasil_tgl = 0;
}
return $hasil_tgl;
}
$denda1=2000;
$content = '<style>
.tabel {
border-collapse:collapse;
}
.tabel th{
padding: 8px 5px;
background-color:#cccccc;
}
.tabel td{
padding: 8px 5px;
}
</style>';
$content .= '
<page>
<h2>Laporan Transaksi Peminjaman Buku</h2>
<table width="100%" style="width: 330px" class="tabel" border="1">
<tr class="header">
<th>No</th>
<th>No Transaksi</th>
<th>Nama</th>
<th>Judul Buku</th>
<th>Jumlah Pinjam</th>
<th>Tanggal Pinjam</th>
<th>Tanggal Kembali</th>
<th>Terlambat</th>
<th>Status</th>
</tr>';
$no=1;
foreach($db->ShowTransaksi() as $data){
$tgl_pinjam = $data['tgl_pinjam'];
$tgl_dateline=$data['tgl_kembali'];
$tgl_kembali=date('d-m-Y');
$lambat=terlambat($tgl_dateline, $tgl_kembali);
$denda=$lambat*$denda1;
$content.='
<tr>
<td>'.$no++.'</td>
<td>'.$data['NoTrans'].'</td>
<td>'.$data['nama'].'</td>
<td>'.$data['judulbuku'].'</td>
<td>'.$data['jumlah_pinjam'].'</td>
<td>'.$data['tgl_pinjam'].'</td>
<td>'.$data['tgl_kembali'].'</td>
<td>'.if($lambat>0) {
echo "<font color='red'>$lambat hari<br>(Rp $denda)</font>"
}else{
echo $lambat." hari"
}.'</td>
</tr>';
}
$content.='</table>
</page>
';
require '../assets/html2pdf/html2pdf.class.php';
$html2pdf = new HTML2PDF('P','A4','fr');
$html2pdf->WriteHTML($content);
$html2pdf->Output('Example.pdf'); ?>
0
3 Jawaban:
function ShowTransaksi()
{
$sql = "SELECT * FROM transaksi where status='pinjam' order by id_transaksi desc";
$query = $this->mysqli->query($sql);
$result = array();
while($data = $query->fetch_assoc()) {
$result[]=$data;
json_encode($data);
}
return $result;
}
0
Jawaban Terpilih
coba ini gan
<?php
require_once '../config/config.php';
function terlambat($tgl_dateline, $tgl_kembali) {
$tgl_dateline_pcs = explode ("-", $tgl_dateline);
$tgl_dateline_pcs = $tgl_dateline_pcs[2]."-".$tgl_dateline_pcs[1]."-".$tgl_dateline_pcs[0];
$tgl_kembali_pcs = explode ("-", $tgl_kembali);
$tgl_kembali_pcs = $tgl_kembali_pcs[2]."-".$tgl_kembali_pcs[1]."-".$tgl_kembali_pcs[0];
$selisih = strtotime ($tgl_kembali_pcs) - strtotime ($tgl_dateline_pcs);
$selisih = $selisih / 86400;
if ($selisih>=1) {
$hasil_tgl = floor($selisih);
}
else {
$hasil_tgl = 0;
}
return $hasil_tgl;
}
$denda1=2000;
$content = '<style>
.tabel {
border-collapse:collapse;
}
.tabel th{
padding: 8px 5px;
background-color:#cccccc;
}
.tabel td{
padding: 8px 5px;
}
</style>';
$content .= '
<page>
<h2>Laporan Transaksi Peminjaman Buku</h2>
<table width="100%" style="width: 330px" class="tabel" border="1">
<tr class="header">
<th>No</th>
<th>No Transaksi</th>
<th>Nama</th>
<th>Judul Buku</th>
<th>Jumlah Pinjam</th>
<th>Tanggal Pinjam</th>
<th>Tanggal Kembali</th>
<th>Terlambat</th>
<th>Status</th>
</tr>';
$no=1;
foreach($db->ShowTransaksi() as $data){
$tgl_pinjam = $data['tgl_pinjam'];
$tgl_dateline=$data['tgl_kembali'];
$tgl_kembali=date('d-m-Y');
$lambat=terlambat($tgl_dateline, $tgl_kembali);
$denda=$lambat*$denda1;
$content.='
<tr>
<td>'.$no++.'</td>
<td>'.$data['NoTrans'].'</td>
<td>'.$data['nama'].'</td>
<td>'.$data['judulbuku'].'</td>
<td>'.$data['jumlah_pinjam'].'</td>
<td>'.$data['tgl_pinjam'].'</td>
<td>'.$data['tgl_kembali'].'</td>
<td>';
// ane edit disini
if($lambat>0) {
$content.= "<font color='red'>$lambat hari<br>(Rp $denda)</font>";
}else{
$content.= $lambat." hari";
}
$content.= '</td>
</tr>';
// ane edit disini
}
$content.='</table>
</page>
';
require '../assets/html2pdf/html2pdf.class.php';
$html2pdf = new HTML2PDF('P','A4','fr');
$html2pdf->WriteHTML($content);
$html2pdf->Output('Example.pdf'); ?>
1