MASTER

SAVING...

BERHASIL DIUBAH!

EDITING: ubah_deposit.php

<?php
  include_once '../koneksi.php';
  if (!isset($_SESSION['kode_staff'])) {
    echo '
      <script>
        alert("Terjadi kesalahan, harap masuk kembali!");
        window.location.replace("'.$alamat_staff.'keluar.php");
      </script>
    ';
  }
  if (isset($_GET['id_deposit'])) {
    $id_deposit = $_GET['id_deposit'];
    $deposit = mysqli_query($koneksi, "SELECT * FROM deposit WHERE id_deposit = '$id_deposit'");
    $data_deposit = mysqli_fetch_array($deposit);
    $id_anggota_deposit = $data_deposit['id_anggota_deposit'];
    $kode_deposit = $data_deposit['kode_deposit'];
    $asal_deposit = $data_deposit['asal_deposit'];
    $tujuan_deposit = $data_deposit['tujuan_deposit'];
    $jumlah_deposit = $data_deposit['jumlah_deposit'];
    $tanggal_deposit = $data_deposit['tanggal_deposit'];
    $status_deposit = $data_deposit['status_deposit'];
    $anggota = mysqli_query($koneksi, "SELECT * FROM anggota WHERE id_anggota = '$id_anggota_deposit'");
    $data_anggota = mysqli_fetch_array($anggota);
    $saldo_anggota = $data_anggota['saldo_anggota'];
  } else {
    echo '
      <script>
        alert("Pilih deposit yang ingin diubah!");
        window.location.replace("'.$alamat_staff.'deposit");
      </script>
    ';
  }
  if (isset($_POST['ubah_data'])) {
    $status_deposit_2 = $_POST['status_deposit'];
    if ($status_deposit_2 == "disetujui") {
      $saldo_anggota_fix = $saldo_anggota + $jumlah_deposit;
      $perbarui_anggota = mysqli_query($koneksi, "UPDATE anggota SET saldo_anggota = '$saldo_anggota_fix' WHERE id_anggota = '$id_anggota_deposit'");
      if ($perbarui_anggota) {
        $ubah_data = mysqli_query($koneksi, "UPDATE deposit SET status_deposit = '$status_deposit_2' WHERE id_deposit = '$id_deposit'");
        if ($ubah_data) {
          echo '
            <script>
              alert("Berhasil ubah data.");
              window.location.replace("'.$alamat_staff.'deposit");
            </script>
          ';
        } else {
          echo "Proses Gagal<br>Error : ".$perbarui_anggota."<br>".mysqli_error($koneksi);
        }
      } else {
        echo "Proses Gagal<br>Error : ".$perbarui_anggota."<br>".mysqli_error($koneksi);
      }
    } else {
      $ubah_data = mysqli_query($koneksi, "UPDATE deposit SET status_deposit = '$status_deposit_2' WHERE id_deposit = '$id_deposit'");
      if ($ubah_data) {
        echo '
          <script>
            alert("Berhasil ubah data.");
            window.location.replace("'.$alamat_staff.'deposit");
          </script>
        ';
      } else {
        echo "Proses Gagal<br>Error : ".$perbarui_anggota."<br>".mysqli_error($koneksi);
      }
    }
  } else if (isset($_POST['hapus_data'])) {
    $hapus_data = mysqli_query($koneksi, "DELETE FROM deposit WHERE id_deposit = '$id_deposit'");
    if ($hapus_data) {
      echo '
        <script>
          alert("Berhasil hapus data.");
          window.location.replace("'.$alamat_staff.'deposit");
        </script>
      ';
    } else {
      echo "Proses Gagal<br>Error : ".$hapus_deposit."<br>".mysqli_error($koneksi);
    }
  }
?>
<div class="container-xxl flex-grow-1 container-p-y">
  <div class="row gy-4 mb-4">
    <div class="col-md-6">
      <div class="fw-bold fs-4 text-center text-md-start">Deposit</div>
    </div>
    <div class="col-md-6">
      <div class="text-center text-md-end">
        <a href="<?php echo $alamat_staff.'deposit'; ?>" class="btn btn-sm btn-primary waves-effect waves-light">
          <span class="tf-icons mdi mdi-chevron-double-left me-1"></span>
          Kembali
        </a>
      </div>
    </div>
  </div>

<div class="card mb-4">
    <h5 class="card-header">Ubah Data Deposit</h5>
    <form method="post" class="card-body">
      <div class="row g-3">
        <div class="col-md-6">
          <div class="form-floating form-floating-outline">
            <input type="text" class="form-control" value="<?php echo $jumlah_deposit; ?>" readonly disabled>
            <label>Jumlah</label>
          </div>
        </div>
        <div class="col-md-6">
          <div class="form-floating form-floating-outline mb-4">
            <?php
              if ($status_deposit == "diproses") {
            ?>
            <select name="status_deposit" class="form-select select2" required>
            <?php
              } else {
            ?>
            <select name="status_deposit" class="form-select select2" required disabled>
            <?php
              }
            ?>
              <option value="diproses" selected>Diproses</option>
              <option value="dibatalkan">Dibatalkan</option>
              <option value="disetujui">Disetujui</option>
            </select>
            <label>Status</label>
          </div>
        </div>
      </div>
      <div class="pt-4 text-end">
        <button type="button" class="btn btn-danger waves-effect waves-light me-sm-3 me-1" data-bs-toggle="modal" data-bs-target="#hapus_data">
          <span class="tf-icons mdi mdi-delete me-1"></span>
          Hapus
        </button>
        <button type="submit" name="ubah_data" class="btn btn-primary waves-effect waves-light">
          <span class="tf-icons mdi mdi-content-save me-1"></span>
          Simpan
        </button>
      </div>
    </form>
  </div>
</div>

<div class="modal fade" id="hapus_data" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <h1 class="modal-title fs-5">Hapus Data</h1>
        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
      </div>
      <form method="post">
        <div class="modal-body">
          Yakin ingin menghapus data ini?
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
          <button type="submit" name="hapus_data" class="btn btn-danger">Hapus</button>
        </div>
      </form>
    </div>
  </div>
</div>