Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if ($_GET['tanggal']){
- $ex = explode(' - ', $_GET['tanggal']);
- $tanggal1 = tgl_indo(tgl_filter($ex[0]));
- $tanggal2 = tgl_indo(tgl_filter($ex[1]));
- $tanggal = " ".$tanggal1." s/d ".$tanggal2;
- $tanggall1 = tgl_filter($ex[0]);
- $tanggall2 = tgl_filter($ex[1]);
- $tot = $this->db->query("SELECT sum((datediff(sampai_tanggal, dari_tanggal)+1)*((c.sewa_perhari/e.durasi)+(if (d.id_sopir is NULL, '0',e.harga_sopir)))) as total FROM `orders` a LEFT JOIN pengembalian b ON a.id_orders=b.id_orders
- JOIN orders_detail c ON a.kode_orders=c.kode_orders
- LEFT JOIN orders_sopir d ON c.id_orders_detail=d.id_orders_detail JOIN mobil e ON c.id_mobil=e.id_mobil
- where b.id_pengembalian is not NULL
- AND ((c.dari_tanggal <= '$tanggall1' AND c.sampai_tanggal >= '$tanggall1') OR
- (c.dari_tanggal <= '$tanggall2' AND c.sampai_tanggal >= '$tanggall2') OR
- (c.dari_tanggal >= '$tanggall1' AND c.sampai_tanggal <= '$tanggall2'))
- ORDER BY a.id_orders DESC")->row_array();
- }else{
- $tanggal = "";
- $tot = $this->db->query("SELECT sum((datediff(sampai_tanggal, dari_tanggal)+1)*((c.sewa_perhari/e.durasi)+(if (d.id_sopir is NULL, '0',e.harga_sopir)))) as total FROM `orders` a LEFT JOIN pengembalian b ON a.id_orders=b.id_orders
- JOIN orders_detail c ON a.kode_orders=c.kode_orders
- LEFT JOIN orders_sopir d ON c.id_orders_detail=d.id_orders_detail JOIN mobil e ON c.id_mobil=e.id_mobil
- where b.id_pengembalian is not NULL
- ORDER BY a.id_orders DESC")->row_array();
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Print Data</title>
- </head>
- <body onload="window.print()">
- <h2 style='margin:0px'><center>LAPORAN DATA PENYEWAAN</center></h2>
- <center><?php echo $tanggal; ?></center><br>
- <table border='1' width='100%'>
- <thead>
- <tr bgcolor='#cecece'>
- <th style='width:20px'>No</th>
- <th>Nama Pemesan</th>
- <th>No Telpon</th>
- <th>Alamat Email</th>
- <th>Jumlah</th>
- <th>Waktu Pesan</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $no = 1;
- foreach ($record->result_array() as $row){
- $jml = $this->db->query("SELECT * FROM orders_detail where kode_orders='$row[kode_orders]'")->num_rows();
- if ($row['status']=='Pending'){ $color = "red"; $icon = 'ok'; $bg = 'success'; $stat = 'Proses'; }else{ $color = "green"; $icon = 'remove'; $bg = 'default'; $stat = 'Pending'; }
- echo "<tr><td>$no</td>
- <td>$row[nama_pemesan]</td>
- <td>$row[no_telpon]</td>
- <td>$row[email]</td>
- <td>$jml Unit</td>
- <td>".tgl_indo($row['waktu'])."</td>
- </tr>";
- $no++;
- }
- ?>
- </tbody>
- </table>
- <h3 style='float:right'>Rp <?php echo rupiah($tot['total']); ?></h3>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
