| |
[tanya|laporan per bulan] selamat shubuh para master semuanya.... bagaimana cara untuk menampilkan laporan perbulan.... ane udah punya script untuk nampilin laporan per tanggal,,,, tapi untuk laporan per bulan ane masih bingung...... ------------------------------------------------------------------ <head> <title>Laporan Per Tamu</title> </head> <div align="center"> <h1>Laporan Per Tamu</h1> <table border="1" width=600> <?php include "koneksi.php"; $no = $_GET['nomor']; $sql = "SELECT * FROM transaksi, kamar where tglci='$no' AND kamar.no_kamar = transaksi.no_kamar "; $result = mysql_query($sql); while($row=mysql_fetch_array($result)) { ?> <tr> <td><p><strong>Kode Registrasi : </strong><?php echo $row['kode_registrasi'];?> </p> <p><strong>No Kamar : </strong><?php echo $row['no_kamar'];?> </p> <p><strong>Tipe Kamar : </strong><?php echo $row['jenis_kamar'];?> </p> <p><strong>Harga Kamar : </strong><?php echo $row['harga_kamar'];?> </p> <p><strong>Kode ID : </strong><?php echo $row['kode_id'];?> </p> <p><strong>Tanggal Chech-In : </strong><?php echo $row['tglci'];?> </p> <p><strong>Tanggal Check-Out : </strong><?php echo $row['tglco'];?> </p> <p><strong>Lama Menginap : </strong><?php echo $row['lama_menginap'];?> </p> <p></p> <p align="center"><strong>Data Data Tagihan<hr></strong></p></td> </tr> <td> <table border=1 width=600> <tr> <td>Tagihan Kamar</td><td>Tagihan Resto</td><td>Tagihan Loundry</td><td>Total Tagihan</td> </tr> <?php $sql1 = "SELECT * FROM transaksi, transaksi_resto, transaksi_loundry WHERE transaksi.no_kamar =$row[no_kamar] AND transaksi.tglci='$no' AND transaksi_resto.no_kamar=$row[no_kamar] "; $result1 = mysql_query($sql1); $no = 0; $row1=mysql_fetch_array($result1) ?> <tr> <?php $tipe=$row['jenis_kamar']; if($tipe == "STANDARD") { $harga=165000; } else if($tipe == "SUPERIOR") { $harga=235000; } else { $harga=295000; } $total=$row['lama_menginap'] * $harga; ?> <td><?php echo $total;?></td> <td><?php echo $row1['total_bayar_resto'];?></td> <td><?php echo $row1['total_bayar'];?></td> <?php $price = $total + $row1['total_bayar'] + $row1['total_bayar_resto']; ?> <td><?php echo $price;?></td> </tr> <?php } ?> </table> </td> </tr> </table> </div> -------------------------------------------------------------------------------------------- | ||
| |
share tablenya.. en biasakan pake pastebin.com ini fb tidak ramah atas tulisan codig | ||
| |
di klausa where bisa gunakan : WHERE tglci BETWEN $startdate AND $endate .. atau dengan WHERE MONTH(tglci)=$bulan AND YEAR(tglci)=$tahun ... ya model2 gitu kali ya gan.. maklum gan ane nubi yang sukanya iseng.. jadi harap maklum, jangan dibata gan ^_^V | ||
| |
^dikasi rumah aja... sekalian batanya lebih banyak | ||
| |
thank's oom semua..... :D | ||
Fikri D'progoel 28 Jun, 2013
-
Source: http://www.facebook.com/groups/35688476100/?id=10151720171046101
--
Manage subscription | Powered by rssforward.com
Tidak ada komentar:
Posting Komentar