Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $table = 'buku';
- $primaryKey = 'id_buku';
- $fill = 'judul, noisbn, penulis, penerbit, tahun, harga_pokok, harga_jual, ppn, diskon';
- $id = '';
- $act = 'add';
- $judul = $noisbn = $penulis = $penerbit = $tahun = $stok = $harga_pokok = $harga_jual = $ppn = $diskon = '';
- if (isset($_POST['simpan'])) {
- $judul = $db->escape_string($_POST['judul']);
- $noisbn = $db->escape_string($_POST['noisbn']);
- $penulis = $db->escape_string($_POST['penulis']);
- $penerbit = $db->escape_string($_POST['penerbit']);
- $tahun = $db->escape_string($_POST['tahun']);
- $harga_pokok = $db->escape_string($_POST['harga_pokok']);
- $harga_jual = $db->escape_string($_POST['harga_jual']);
- $ppn = $db->escape_string($_POST['ppn']);
- $diskon = $db->escape_string($_POST['diskon']);
- $act = $db->escape_string($_POST['act']);
- switch ($act) {
- case 'add':
- $query = "INSERT INTO $table ($fill) VALUES ('$judul','$noisbn','$penulis','$penerbit','$tahun','$harga_pokok','$harga_jual','$ppn','$diskon')";
- break;
- case 'edit':
- $id = $_POST['id'];
- $query = "UPDATE buku SET judul = '$judul', noisbn = '$noisbn', penulis = '$penulis', penerbit = '$penerbit', tahun = '$tahun', harga_pokok = '$harga_pokok', harga_jual = '$harga_jual', ppn = '$ppn', diskon = '$diskon' WHERE id_buku = '$id'";
- break;
- }
- if ($db->query($query)) {
- URL::Redirect('buku');
- }else{
- $error = 'Terjadi kesalahan, mohon coba kembali.';
- }
- }
- if (isset($_GET['id'])) {
- $id = $_GET['id'];
- switch ($_GET['act']) {
- case 'edit':
- $data = $db->query("SELECT * FROM buku WHERE id_buku = '$id'");
- $row = $data->fetch_assoc();
- $judul = $row['judul'];
- $noisbn = $row['noisbn'];
- $penulis = $row['penulis'];
- $penerbit = $row['penerbit'];
- $tahun = $row['tahun'];
- $stok = $row['stok'];
- $harga_pokok = $row['harga_pokok'];
- $harga_jual = $row['harga_jual'];
- $ppn = $row['ppn'];
- $diskon = $row['diskon'];
- $act = 'edit';
- break;
- case 'delete':
- if ($db->query("DELETE FROM buku WHERE id_buku = '$id'")) {
- URL::Redirect('buku');
- }
- break;
- }
- }
- if (isset($_POST['filter'])) {
- $tahun = $db->escape_string($_POST['tahun_keluar']);
- $minimal = $db->escape_string($_POST['harga_minimal']);
- $maksimal = $db->escape_string($_POST['harga_maksimal']);
- $opsi = $db->escape_string($_POST['opsi_lain']);
- $query_basic = "SELECT * FROM buku";
- $query_advance = "SELECT *, sum(a.jumlah) as jumlah_buku FROM penjualan a RIGHT JOIN buku b ON b.id_buku = a.id_buku";
- $kondisi = array();
- if ($tahun != '') {
- if ($opsi == 'terlaku' || $opsi == 'kurang_laku') {
- $kondisi[] = "b.tahun='$tahun'";
- }else{
- $kondisi[] = "tahun='$tahun'";
- }
- }
- if ($minimal != '' || $maksimal != '') {
- if ($opsi == 'terlaku' || $opsi == 'kurang_laku') {
- $kondisi[] = "b.tahun BETWEEN '$minimal' AND '$maksimal'";
- }else{
- $kondisi[] = "tahun BETWEEN '$minimal' AND '$maksimal'";
- }
- }
- $sql = $query_basic;
- if ($opsi != '') {
- switch ($opsi) {
- case 'terlaku':
- $sql = $query_advance;
- if (count($kondisi) > 0) {
- $sql .= " WHERE ".implode(' AND ', $kondisi)."GROUP BY a.id_buku ORDER BY jumlah_buku DESC LIMIT 10";
- }
- break;
- case 'kurang_laku':
- $sql = $query_advance;
- if (count($kondisi) > 0) {
- $sql .= " WHERE ".implode(' AND ', $kondisi)."GROUP BY a.id_buku ORDER BY jumlah_buku ASC LIMIT 10";
- }
- break;
- case 'grosir':
- if (count($kondisi) > 0) {
- $sql .= " WHERE ".implode(' AND ', $kondisi)."AND diskon != '' ORDER BY diskon DESC";
- }
- break;
- default:
- if (count($kondisi) > 0) {
- $sql .= " WHERE ".implode(' AND ', $kondisi);
- }
- break;
- }
- }else{
- if (count($kondisi) > 0) {
- $sql .= " WHERE ".implode(' AND ', $kondisi);
- }
- }
- $query = $db->query($sql);
- $tahun = $tahun;
- $minimal = $minimal;
- $maksimal = $maksimal;
- $opsi = $opsi;
- }else{
- $tahun = '';
- $minimal = '';
- $maksimal = '';
- $opsi = '';
- $query = $db->query("SELECT * FROM buku ORDER BY id_buku DESC");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement