SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | include('config.php');
| |
| 3 | include('cek-login.php');
| |
| 4 | ?> | |
| 5 | <style> | |
| 6 | tbody > tr:nth-child(2n+1) > td, tbody > tr:nth-child(2n+1) > th {
| |
| 7 | background-color: #CCC; | |
| 8 | } | |
| 9 | table{
| |
| 10 | ||
| 11 | margin: auto; | |
| 12 | border-collapse: collapse; | |
| 13 | box-shadow: darkgrey 3px; | |
| 14 | } | |
| 15 | thead tr {
| |
| 16 | background-color: #36c2ff; | |
| 17 | } | |
| 18 | </style> | |
| 19 | ||
| 20 | <?php | |
| 21 | if (!empty($_GET['message']) && $_GET['message'] == 'success') {
| |
| 22 | echo '<h3>Berhasil meng-update data!</h3>'; | |
| 23 | } else if (!empty($_GET['message']) && $_GET['message'] == 'delete') {
| |
| 24 | echo '<h3>Berhasil menghapus data!</h3>'; | |
| 25 | } | |
| 26 | ?> | |
| 27 | <h3>Data Customer</h3> | |
| 28 | <table border="1" cellpadding="5" cellspacing="0"> | |
| 29 | <thead> | |
| 30 | <tr align="center"> | |
| 31 | <td><b>No</b></td> | |
| 32 | <td><b>Customer</b></td> | |
| 33 | <td><b>Pelapor</b></td> | |
| 34 | <td><b>Problem</b></td> | |
| 35 | <td><b>Tanggal Keluhan</b></td> | |
| 36 | <td><b>Tanggapan</b></td> | |
| 37 | <td><b>Tanggal Tanggapan</b></td> | |
| 38 | <td><b>Waktu</b></td> | |
| 39 | <td><b>Status</b></td> | |
| 40 | <td><b>Opsi</b></td> | |
| 41 | ||
| 42 | </tr> | |
| 43 | </thead> | |
| 44 | <tbody> | |
| 45 | <?php | |
| 46 | $query = mysql_query("select customer.*, tindakan.*
| |
| 47 | FROM customer LEFT JOIN tindakan | |
| 48 | ON customer.idcustomer_st=tindakan.idcustomer"); | |
| 49 | ||
| 50 | $query = mysql_query("select customer.*, tindakan.*, DATEDIFF(tindakan.date,customer.datecustomer) selisih
| |
| 51 | FROM customer LEFT JOIN tindakan | |
| 52 | ON customer.idcustomer_st=tindakan.idcustomer"); | |
| 53 | ||
| 54 | - | $datetime1 = new DateTime($row['date']); |
| 54 | + | |
| 55 | $no = 1; | |
| 56 | while ($data = mysql_fetch_array($query)) {
| |
| 57 | $datetime1 = new DateTime($row['date']); | |
| 58 | $datetime2 = new DateTime($row['datecustomer']); | |
| 59 | $interval = $datetime1->diff($datetime2); | |
| 60 | ||
| 61 | ?> | |
| 62 | <tr> | |
| 63 | <td><?php echo $no; ?></td> | |
| 64 | <td><?php echo $data['customer']; ?></td> | |
| 65 | <td><?php echo $data['pelapor']; ?></td> | |
| 66 | <td><?php echo $data['problem']; ?></td> | |
| 67 | <td><?php echo $data['datecustomer']; ?></td> | |
| 68 | <td><?php if(empty($data['tindakan'])){ echo '<span style="color: #f00; ">Belum ada tanggapan</span>'; } else { echo $data['tindakan']; } ?></td>
| |
| 69 | <td><?php if(empty($data['date'])){ echo '<span style="color: #f00; ">Belum ada data</span>'; } else { echo $data['date']; } ?></td>
| |
| 70 | <td><?php echo $interval->format('%R%a days / %D %H:%I:%S'); ?></td>
| |
| 71 | ||
| 72 | <td><?php if(empty($data['selisih'])){ echo '<span style="color:#f00; ">belum</span>';} else echo'<span style="color:#36C; ">selesai</span>';?> </td>
| |
| 73 | ||
| 74 | <td> | |
| 75 | <a href="edittanggapan.php?id=<?php echo $data['idcustomer_st']; ?>"><img alt="edit" src="gambar/edit.png" /></a> | |
| 76 | <a href="deletetanggapan.php?id=<?php echo $data['idcustomer_st']; ?>" onclick="return confirm('Anda yakin akan menghapus data?')"><img alt="hapus" src="gambar/hapus.png" /></a>
| |
| 77 | </td> | |
| 78 | </tr> | |
| 79 | <?php | |
| 80 | $no++; | |
| 81 | } | |
| 82 | ?> | |
| 83 | </tbody> | |
| 84 | </table> |