{"status":"success","schema_source":"INFORMATION_SCHEMA","database":"sooa7192_SIAM","generated_at":"2026-04-16T06:09:06+07:00","files":[{"file":"_helper.php","tables":[],"columns":[],"summary":"OK"},{"file":"add_barang.php","tables":[{"name":"MSTR_BARANG","exists":true}],"columns":[{"table":"MSTR_BARANG","name":"KODE_BARANG","exists":true},{"table":"MSTR_BARANG","name":"NAMA_BARANG","exists":true},{"table":"MSTR_BARANG","name":"HARGA_BARANG","exists":true},{"table":"MSTR_BARANG","name":"JUMLAH_BARANG","exists":true},{"table":"MSTR_BARANG","name":"STATUS","exists":true}],"summary":"OK"},{"file":"add_cicilan.php","tables":[{"name":"kolom","exists":false},{"name":"PIUTANG_CUSTOMER","exists":true},{"name":"TRS_CICILAN_PIUTANG","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"JURNAL_DETAIL","exists":true},{"name":"DB","exists":false},{"name":"status","exists":false},{"name":"NOTA_JUAL","exists":true}],"columns":[{"table":"kolom","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"kolom","name":"WAKTU_CICIL","exists":false},{"table":"kolom","name":"JUMLAH_BAYAR","exists":false},{"table":"kolom","name":"TANGGAL","exists":false},{"table":"kolom","name":"REF","exists":false},{"table":"kolom","name":"KETERANGAN","exists":false},{"table":"kolom","name":"ID_JURNAL_UMUM","exists":false},{"table":"kolom","name":"KODE_AKUN","exists":false},{"table":"kolom","name":"POSISI","exists":false},{"table":"kolom","name":"NILAI","exists":false},{"table":"kolom","name":"STATUS","exists":false},{"table":"kolom","name":"JUMLAH_PIUTANG","exists":false},{"table":"kolom","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"kolom","name":0,"exists":false},{"table":"kolom","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"kolom","name":"JUMLAH_PIUTANG","exists":false},{"table":"kolom","name":"NOMOR_NOTA","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"PIUTANG_CUSTOMER","name":"WAKTU_CICIL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_BAYAR","exists":false},{"table":"PIUTANG_CUSTOMER","name":"TANGGAL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"REF","exists":false},{"table":"PIUTANG_CUSTOMER","name":"KETERANGAN","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_JURNAL_UMUM","exists":false},{"table":"PIUTANG_CUSTOMER","name":"KODE_AKUN","exists":false},{"table":"PIUTANG_CUSTOMER","name":"POSISI","exists":false},{"table":"PIUTANG_CUSTOMER","name":"NILAI","exists":false},{"table":"PIUTANG_CUSTOMER","name":"STATUS","exists":true},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_PIUTANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"PIUTANG_CUSTOMER","name":0,"exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_PIUTANG","exists":true},{"table":"PIUTANG_CUSTOMER","name":"NOMOR_NOTA","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"WAKTU_CICIL","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"JUMLAH_BAYAR","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"TANGGAL","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"REF","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"KETERANGAN","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"ID_JURNAL_UMUM","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"KODE_AKUN","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"POSISI","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"NILAI","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"STATUS","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"JUMLAH_PIUTANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":0,"exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"ID_CICILAN_PIUTANG","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"JUMLAH_PIUTANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"NOMOR_NOTA","exists":false},{"table":"JURNAL_UMUM","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"WAKTU_CICIL","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_BAYAR","exists":false},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"REF","exists":true},{"table":"JURNAL_UMUM","name":"KETERANGAN","exists":true},{"table":"JURNAL_UMUM","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_UMUM","name":"KODE_AKUN","exists":false},{"table":"JURNAL_UMUM","name":"POSISI","exists":false},{"table":"JURNAL_UMUM","name":"NILAI","exists":false},{"table":"JURNAL_UMUM","name":"STATUS","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"JURNAL_UMUM","name":0,"exists":false},{"table":"JURNAL_UMUM","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":"NOMOR_NOTA","exists":false},{"table":"JURNAL_DETAIL","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"JURNAL_DETAIL","name":"WAKTU_CICIL","exists":false},{"table":"JURNAL_DETAIL","name":"JUMLAH_BAYAR","exists":false},{"table":"JURNAL_DETAIL","name":"TANGGAL","exists":false},{"table":"JURNAL_DETAIL","name":"REF","exists":false},{"table":"JURNAL_DETAIL","name":"KETERANGAN","exists":false},{"table":"JURNAL_DETAIL","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_DETAIL","name":"KODE_AKUN","exists":true},{"table":"JURNAL_DETAIL","name":"POSISI","exists":true},{"table":"JURNAL_DETAIL","name":"NILAI","exists":true},{"table":"JURNAL_DETAIL","name":"STATUS","exists":false},{"table":"JURNAL_DETAIL","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_DETAIL","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"JURNAL_DETAIL","name":0,"exists":false},{"table":"JURNAL_DETAIL","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"JURNAL_DETAIL","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_DETAIL","name":"NOMOR_NOTA","exists":false},{"table":"DB","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"DB","name":"WAKTU_CICIL","exists":false},{"table":"DB","name":"JUMLAH_BAYAR","exists":false},{"table":"DB","name":"TANGGAL","exists":false},{"table":"DB","name":"REF","exists":false},{"table":"DB","name":"KETERANGAN","exists":false},{"table":"DB","name":"ID_JURNAL_UMUM","exists":false},{"table":"DB","name":"KODE_AKUN","exists":false},{"table":"DB","name":"POSISI","exists":false},{"table":"DB","name":"NILAI","exists":false},{"table":"DB","name":"STATUS","exists":false},{"table":"DB","name":"JUMLAH_PIUTANG","exists":false},{"table":"DB","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"DB","name":0,"exists":false},{"table":"DB","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"DB","name":"JUMLAH_PIUTANG","exists":false},{"table":"DB","name":"NOMOR_NOTA","exists":false},{"table":"status","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"status","name":"WAKTU_CICIL","exists":false},{"table":"status","name":"JUMLAH_BAYAR","exists":false},{"table":"status","name":"TANGGAL","exists":false},{"table":"status","name":"REF","exists":false},{"table":"status","name":"KETERANGAN","exists":false},{"table":"status","name":"ID_JURNAL_UMUM","exists":false},{"table":"status","name":"KODE_AKUN","exists":false},{"table":"status","name":"POSISI","exists":false},{"table":"status","name":"NILAI","exists":false},{"table":"status","name":"STATUS","exists":false},{"table":"status","name":"JUMLAH_PIUTANG","exists":false},{"table":"status","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"status","name":0,"exists":false},{"table":"status","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"status","name":"JUMLAH_PIUTANG","exists":false},{"table":"status","name":"NOMOR_NOTA","exists":false},{"table":"NOTA_JUAL","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"NOTA_JUAL","name":"WAKTU_CICIL","exists":false},{"table":"NOTA_JUAL","name":"JUMLAH_BAYAR","exists":false},{"table":"NOTA_JUAL","name":"TANGGAL","exists":false},{"table":"NOTA_JUAL","name":"REF","exists":false},{"table":"NOTA_JUAL","name":"KETERANGAN","exists":false},{"table":"NOTA_JUAL","name":"ID_JURNAL_UMUM","exists":false},{"table":"NOTA_JUAL","name":"KODE_AKUN","exists":false},{"table":"NOTA_JUAL","name":"POSISI","exists":false},{"table":"NOTA_JUAL","name":"NILAI","exists":false},{"table":"NOTA_JUAL","name":"STATUS","exists":true},{"table":"NOTA_JUAL","name":"JUMLAH_PIUTANG","exists":false},{"table":"NOTA_JUAL","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"NOTA_JUAL","name":0,"exists":false},{"table":"NOTA_JUAL","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"NOTA_JUAL","name":"JUMLAH_PIUTANG","exists":false},{"table":"NOTA_JUAL","name":"NOMOR_NOTA","exists":true}],"summary":"ISSUES"},{"file":"add_customer.php","tables":[{"name":"CUSTOMER","exists":true}],"columns":[{"table":"CUSTOMER","name":"NIK_CUSTOMER","exists":true},{"table":"CUSTOMER","name":"NAMA_CUSTOMER","exists":true},{"table":"CUSTOMER","name":"EMAIL","exists":true},{"table":"CUSTOMER","name":1,"exists":false}],"summary":"ISSUES"},{"file":"add_karyawan.php","tables":[{"name":"KARYAWAN","exists":true}],"columns":[{"table":"KARYAWAN","name":"NIK_KARYAWAN","exists":true},{"table":"KARYAWAN","name":"NAMA_KARYAWAN","exists":true},{"table":"KARYAWAN","name":"EMAIL","exists":true},{"table":"KARYAWAN","name":"PASSWORD","exists":true},{"table":"KARYAWAN","name":"ROLE","exists":true}],"summary":"OK"},{"file":"add_member_to_membership.php","tables":[{"name":"MASTER_MEMBERSHIP","exists":true},{"name":"TRANSAKSI_MEMBERSHIP","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"JURNAL_DETAIL","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"MASTER_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":false},{"table":"MASTER_MEMBERSHIP","name":"TANGGAL","exists":false},{"table":"MASTER_MEMBERSHIP","name":"REF","exists":false},{"table":"MASTER_MEMBERSHIP","name":"KETERANGAN","exists":false},{"table":"MASTER_MEMBERSHIP","name":"ID_JURNAL_UMUM","exists":false},{"table":"MASTER_MEMBERSHIP","name":"KODE_AKUN","exists":false},{"table":"MASTER_MEMBERSHIP","name":"POSISI","exists":false},{"table":"MASTER_MEMBERSHIP","name":"NILAI","exists":false},{"table":"MASTER_MEMBERSHIP","name":"STATUS","exists":true},{"table":"MASTER_MEMBERSHIP","name":1,"exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_TRANSAKSI_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"TANGGAL","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"REF","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"KETERANGAN","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_JURNAL_UMUM","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"KODE_AKUN","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"POSISI","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"NILAI","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"STATUS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":1,"exists":false},{"table":"JURNAL_UMUM","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"NIK_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"NAMA_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"HARGA_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"POTONGAN","exists":false},{"table":"JURNAL_UMUM","name":"TIMESTAMP_HABIS","exists":false},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"REF","exists":true},{"table":"JURNAL_UMUM","name":"KETERANGAN","exists":true},{"table":"JURNAL_UMUM","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_UMUM","name":"KODE_AKUN","exists":false},{"table":"JURNAL_UMUM","name":"POSISI","exists":false},{"table":"JURNAL_UMUM","name":"NILAI","exists":false},{"table":"JURNAL_UMUM","name":"STATUS","exists":false},{"table":"JURNAL_UMUM","name":1,"exists":false},{"table":"JURNAL_DETAIL","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"NIK_CUSTOMER","exists":false},{"table":"JURNAL_DETAIL","name":"NAMA_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"HARGA_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"POTONGAN","exists":false},{"table":"JURNAL_DETAIL","name":"TIMESTAMP_HABIS","exists":false},{"table":"JURNAL_DETAIL","name":"TANGGAL","exists":false},{"table":"JURNAL_DETAIL","name":"REF","exists":false},{"table":"JURNAL_DETAIL","name":"KETERANGAN","exists":false},{"table":"JURNAL_DETAIL","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_DETAIL","name":"KODE_AKUN","exists":true},{"table":"JURNAL_DETAIL","name":"POSISI","exists":true},{"table":"JURNAL_DETAIL","name":"NILAI","exists":true},{"table":"JURNAL_DETAIL","name":"STATUS","exists":false},{"table":"JURNAL_DETAIL","name":1,"exists":false}],"summary":"ISSUES"},{"file":"add_membership.php","tables":[{"name":"MASTER_MEMBERSHIP","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP","name":"STATUS","exists":true},{"table":"MASTER_MEMBERSHIP","name":"LAST_UPDATED","exists":true}],"summary":"OK"},{"file":"add_membership_type.php","tables":[{"name":"MASTER_MEMBERSHIP_TYPE","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP_TYPE","name":"ID_MEMBERSHIP_TYPE","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"STATUS","exists":true}],"summary":"OK"},{"file":"add_metode_pembayaran.php","tables":[{"name":"MSTR_METODE_PEMBAYARAN","exists":true}],"columns":[{"table":"MSTR_METODE_PEMBAYARAN","name":"ID_MPEM","exists":true},{"table":"MSTR_METODE_PEMBAYARAN","name":"NAMA_MPEM","exists":true},{"table":"MSTR_METODE_PEMBAYARAN","name":"STATUS","exists":true}],"summary":"OK"},{"file":"add_nota_jual.php","tables":[{"name":"JURNAL_DETAIL","exists":true},{"name":"INFORMATION_SCHEMA","exists":false},{"name":"CUSTOMER","exists":true},{"name":"MSTR_METODE_PEMBAYARAN","exists":true},{"name":"NOTA_JUAL","exists":true},{"name":"MSTR_BARANG","exists":true},{"name":"DETAIL_NOTA_JUAL","exists":true},{"name":"stok","exists":false},{"name":"PIUTANG_CUSTOMER","exists":true},{"name":"jumlah","exists":false},{"name":"piutang","exists":false},{"name":"JURNAL_UMUM","exists":true},{"name":"KODE_AKUN","exists":true}],"columns":[{"table":"JURNAL_DETAIL","name":"ID_DETAIL","exists":true},{"table":"JURNAL_DETAIL","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_DETAIL","name":"KODE_AKUN","exists":true},{"table":"JURNAL_DETAIL","name":"POSISI","exists":true},{"table":"JURNAL_DETAIL","name":"NILAI","exists":true},{"table":"JURNAL_DETAIL","name":"NOMOR_NOTA","exists":false},{"table":"JURNAL_DETAIL","name":"NIK_CUSTOMER","exists":false},{"table":"JURNAL_DETAIL","name":"NIK_KARYAWAN","exists":false},{"table":"JURNAL_DETAIL","name":"ID_MPEM","exists":false},{"table":"JURNAL_DETAIL","name":"KODE_BARANG","exists":false},{"table":"JURNAL_DETAIL","name":"JUMLAH_BARANG","exists":false},{"table":"JURNAL_DETAIL","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_DETAIL","name":"STATUS","exists":false},{"table":"JURNAL_DETAIL","name":"TANGGAL","exists":false},{"table":"JURNAL_DETAIL","name":"REF","exists":false},{"table":"JURNAL_DETAIL","name":"KETERANGAN","exists":false},{"table":"JURNAL_DETAIL","name":"NAMA_AKUN","exists":false},{"table":"JURNAL_DETAIL","name":"TIPE","exists":false},{"table":"JURNAL_DETAIL","name":"DATA_TYPE","exists":false},{"table":"JURNAL_DETAIL","name":"COLUMN_TYPE","exists":false},{"table":"JURNAL_DETAIL","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"JURNAL_DETAIL","name":"0) + 1","exists":false},{"table":"JURNAL_DETAIL","name":"NAMA_MPEM","exists":false},{"table":"JURNAL_DETAIL","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"JURNAL_DETAIL","name":"ID_MPEM) VALUES (?","exists":false},{"table":"JURNAL_DETAIL","name":"?","exists":false},{"table":"JURNAL_DETAIL","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"JURNAL_DETAIL","name":"$nomor_nota","exists":false},{"table":"JURNAL_DETAIL","name":"$nik_customer","exists":false},{"table":"JURNAL_DETAIL","name":"$nik_karyawan","exists":false},{"table":"JURNAL_DETAIL","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"JURNAL_DETAIL","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"JURNAL_DETAIL","name":1,"exists":false},{"table":"INFORMATION_SCHEMA","name":"ID_DETAIL","exists":false},{"table":"INFORMATION_SCHEMA","name":"ID_JURNAL_UMUM","exists":false},{"table":"INFORMATION_SCHEMA","name":"KODE_AKUN","exists":false},{"table":"INFORMATION_SCHEMA","name":"POSISI","exists":false},{"table":"INFORMATION_SCHEMA","name":"NILAI","exists":false},{"table":"INFORMATION_SCHEMA","name":"NOMOR_NOTA","exists":false},{"table":"INFORMATION_SCHEMA","name":"NIK_CUSTOMER","exists":false},{"table":"INFORMATION_SCHEMA","name":"NIK_KARYAWAN","exists":false},{"table":"INFORMATION_SCHEMA","name":"ID_MPEM","exists":false},{"table":"INFORMATION_SCHEMA","name":"KODE_BARANG","exists":false},{"table":"INFORMATION_SCHEMA","name":"JUMLAH_BARANG","exists":false},{"table":"INFORMATION_SCHEMA","name":"JUMLAH_PIUTANG","exists":false},{"table":"INFORMATION_SCHEMA","name":"STATUS","exists":false},{"table":"INFORMATION_SCHEMA","name":"TANGGAL","exists":false},{"table":"INFORMATION_SCHEMA","name":"REF","exists":false},{"table":"INFORMATION_SCHEMA","name":"KETERANGAN","exists":false},{"table":"INFORMATION_SCHEMA","name":"NAMA_AKUN","exists":false},{"table":"INFORMATION_SCHEMA","name":"TIPE","exists":false},{"table":"INFORMATION_SCHEMA","name":"DATA_TYPE","exists":false},{"table":"INFORMATION_SCHEMA","name":"COLUMN_TYPE","exists":false},{"table":"INFORMATION_SCHEMA","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"INFORMATION_SCHEMA","name":"0) + 1","exists":false},{"table":"INFORMATION_SCHEMA","name":"NAMA_MPEM","exists":false},{"table":"INFORMATION_SCHEMA","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"INFORMATION_SCHEMA","name":"ID_MPEM) VALUES (?","exists":false},{"table":"INFORMATION_SCHEMA","name":"?","exists":false},{"table":"INFORMATION_SCHEMA","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"INFORMATION_SCHEMA","name":"$nomor_nota","exists":false},{"table":"INFORMATION_SCHEMA","name":"$nik_customer","exists":false},{"table":"INFORMATION_SCHEMA","name":"$nik_karyawan","exists":false},{"table":"INFORMATION_SCHEMA","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"INFORMATION_SCHEMA","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"INFORMATION_SCHEMA","name":1,"exists":false},{"table":"CUSTOMER","name":"ID_DETAIL","exists":false},{"table":"CUSTOMER","name":"ID_JURNAL_UMUM","exists":false},{"table":"CUSTOMER","name":"KODE_AKUN","exists":false},{"table":"CUSTOMER","name":"POSISI","exists":false},{"table":"CUSTOMER","name":"NILAI","exists":false},{"table":"CUSTOMER","name":"NOMOR_NOTA","exists":false},{"table":"CUSTOMER","name":"NIK_CUSTOMER","exists":true},{"table":"CUSTOMER","name":"NIK_KARYAWAN","exists":false},{"table":"CUSTOMER","name":"ID_MPEM","exists":false},{"table":"CUSTOMER","name":"KODE_BARANG","exists":false},{"table":"CUSTOMER","name":"JUMLAH_BARANG","exists":false},{"table":"CUSTOMER","name":"JUMLAH_PIUTANG","exists":false},{"table":"CUSTOMER","name":"STATUS","exists":false},{"table":"CUSTOMER","name":"TANGGAL","exists":false},{"table":"CUSTOMER","name":"REF","exists":false},{"table":"CUSTOMER","name":"KETERANGAN","exists":false},{"table":"CUSTOMER","name":"NAMA_AKUN","exists":false},{"table":"CUSTOMER","name":"TIPE","exists":false},{"table":"CUSTOMER","name":"DATA_TYPE","exists":false},{"table":"CUSTOMER","name":"COLUMN_TYPE","exists":false},{"table":"CUSTOMER","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"CUSTOMER","name":"0) + 1","exists":false},{"table":"CUSTOMER","name":"NAMA_MPEM","exists":false},{"table":"CUSTOMER","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"CUSTOMER","name":"ID_MPEM) VALUES (?","exists":false},{"table":"CUSTOMER","name":"?","exists":false},{"table":"CUSTOMER","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"CUSTOMER","name":"$nomor_nota","exists":false},{"table":"CUSTOMER","name":"$nik_customer","exists":false},{"table":"CUSTOMER","name":"$nik_karyawan","exists":false},{"table":"CUSTOMER","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"CUSTOMER","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"CUSTOMER","name":1,"exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"ID_DETAIL","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"ID_JURNAL_UMUM","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"KODE_AKUN","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"POSISI","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"NILAI","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"NOMOR_NOTA","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"NIK_CUSTOMER","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"NIK_KARYAWAN","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"ID_MPEM","exists":true},{"table":"MSTR_METODE_PEMBAYARAN","name":"KODE_BARANG","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"JUMLAH_BARANG","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"JUMLAH_PIUTANG","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"STATUS","exists":true},{"table":"MSTR_METODE_PEMBAYARAN","name":"TANGGAL","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"REF","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"KETERANGAN","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"NAMA_AKUN","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"TIPE","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"DATA_TYPE","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"COLUMN_TYPE","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"0) + 1","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"NAMA_MPEM","exists":true},{"table":"MSTR_METODE_PEMBAYARAN","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"ID_MPEM) VALUES (?","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"?","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"$nomor_nota","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"$nik_customer","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"$nik_karyawan","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":1,"exists":false},{"table":"NOTA_JUAL","name":"ID_DETAIL","exists":false},{"table":"NOTA_JUAL","name":"ID_JURNAL_UMUM","exists":false},{"table":"NOTA_JUAL","name":"KODE_AKUN","exists":false},{"table":"NOTA_JUAL","name":"POSISI","exists":false},{"table":"NOTA_JUAL","name":"NILAI","exists":false},{"table":"NOTA_JUAL","name":"NOMOR_NOTA","exists":true},{"table":"NOTA_JUAL","name":"NIK_CUSTOMER","exists":true},{"table":"NOTA_JUAL","name":"NIK_KARYAWAN","exists":true},{"table":"NOTA_JUAL","name":"ID_MPEM","exists":true},{"table":"NOTA_JUAL","name":"KODE_BARANG","exists":false},{"table":"NOTA_JUAL","name":"JUMLAH_BARANG","exists":false},{"table":"NOTA_JUAL","name":"JUMLAH_PIUTANG","exists":false},{"table":"NOTA_JUAL","name":"STATUS","exists":true},{"table":"NOTA_JUAL","name":"TANGGAL","exists":false},{"table":"NOTA_JUAL","name":"REF","exists":false},{"table":"NOTA_JUAL","name":"KETERANGAN","exists":false},{"table":"NOTA_JUAL","name":"NAMA_AKUN","exists":false},{"table":"NOTA_JUAL","name":"TIPE","exists":false},{"table":"NOTA_JUAL","name":"DATA_TYPE","exists":false},{"table":"NOTA_JUAL","name":"COLUMN_TYPE","exists":false},{"table":"NOTA_JUAL","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"NOTA_JUAL","name":"0) + 1","exists":false},{"table":"NOTA_JUAL","name":"NAMA_MPEM","exists":false},{"table":"NOTA_JUAL","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"NOTA_JUAL","name":"ID_MPEM) VALUES (?","exists":false},{"table":"NOTA_JUAL","name":"?","exists":false},{"table":"NOTA_JUAL","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"NOTA_JUAL","name":"$nomor_nota","exists":false},{"table":"NOTA_JUAL","name":"$nik_customer","exists":false},{"table":"NOTA_JUAL","name":"$nik_karyawan","exists":false},{"table":"NOTA_JUAL","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"NOTA_JUAL","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"NOTA_JUAL","name":1,"exists":false},{"table":"MSTR_BARANG","name":"ID_DETAIL","exists":false},{"table":"MSTR_BARANG","name":"ID_JURNAL_UMUM","exists":false},{"table":"MSTR_BARANG","name":"KODE_AKUN","exists":false},{"table":"MSTR_BARANG","name":"POSISI","exists":false},{"table":"MSTR_BARANG","name":"NILAI","exists":false},{"table":"MSTR_BARANG","name":"NOMOR_NOTA","exists":false},{"table":"MSTR_BARANG","name":"NIK_CUSTOMER","exists":false},{"table":"MSTR_BARANG","name":"NIK_KARYAWAN","exists":false},{"table":"MSTR_BARANG","name":"ID_MPEM","exists":false},{"table":"MSTR_BARANG","name":"KODE_BARANG","exists":true},{"table":"MSTR_BARANG","name":"JUMLAH_BARANG","exists":true},{"table":"MSTR_BARANG","name":"JUMLAH_PIUTANG","exists":false},{"table":"MSTR_BARANG","name":"STATUS","exists":true},{"table":"MSTR_BARANG","name":"TANGGAL","exists":false},{"table":"MSTR_BARANG","name":"REF","exists":false},{"table":"MSTR_BARANG","name":"KETERANGAN","exists":false},{"table":"MSTR_BARANG","name":"NAMA_AKUN","exists":false},{"table":"MSTR_BARANG","name":"TIPE","exists":false},{"table":"MSTR_BARANG","name":"DATA_TYPE","exists":false},{"table":"MSTR_BARANG","name":"COLUMN_TYPE","exists":false},{"table":"MSTR_BARANG","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"MSTR_BARANG","name":"0) + 1","exists":false},{"table":"MSTR_BARANG","name":"NAMA_MPEM","exists":false},{"table":"MSTR_BARANG","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"MSTR_BARANG","name":"ID_MPEM) VALUES (?","exists":false},{"table":"MSTR_BARANG","name":"?","exists":false},{"table":"MSTR_BARANG","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"MSTR_BARANG","name":"$nomor_nota","exists":false},{"table":"MSTR_BARANG","name":"$nik_customer","exists":false},{"table":"MSTR_BARANG","name":"$nik_karyawan","exists":false},{"table":"MSTR_BARANG","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"MSTR_BARANG","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"MSTR_BARANG","name":1,"exists":false},{"table":"DETAIL_NOTA_JUAL","name":"ID_DETAIL","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"ID_JURNAL_UMUM","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"KODE_AKUN","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"POSISI","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"NILAI","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"NOMOR_NOTA","exists":true},{"table":"DETAIL_NOTA_JUAL","name":"NIK_CUSTOMER","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"NIK_KARYAWAN","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"ID_MPEM","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"KODE_BARANG","exists":true},{"table":"DETAIL_NOTA_JUAL","name":"JUMLAH_BARANG","exists":true},{"table":"DETAIL_NOTA_JUAL","name":"JUMLAH_PIUTANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"STATUS","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"TANGGAL","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"REF","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"KETERANGAN","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"NAMA_AKUN","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"TIPE","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"DATA_TYPE","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COLUMN_TYPE","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"0) + 1","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"NAMA_MPEM","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"ID_MPEM) VALUES (?","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"?","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"$nomor_nota","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"$nik_customer","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"$nik_karyawan","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"DETAIL_NOTA_JUAL","name":1,"exists":false},{"table":"stok","name":"ID_DETAIL","exists":false},{"table":"stok","name":"ID_JURNAL_UMUM","exists":false},{"table":"stok","name":"KODE_AKUN","exists":false},{"table":"stok","name":"POSISI","exists":false},{"table":"stok","name":"NILAI","exists":false},{"table":"stok","name":"NOMOR_NOTA","exists":false},{"table":"stok","name":"NIK_CUSTOMER","exists":false},{"table":"stok","name":"NIK_KARYAWAN","exists":false},{"table":"stok","name":"ID_MPEM","exists":false},{"table":"stok","name":"KODE_BARANG","exists":false},{"table":"stok","name":"JUMLAH_BARANG","exists":false},{"table":"stok","name":"JUMLAH_PIUTANG","exists":false},{"table":"stok","name":"STATUS","exists":false},{"table":"stok","name":"TANGGAL","exists":false},{"table":"stok","name":"REF","exists":false},{"table":"stok","name":"KETERANGAN","exists":false},{"table":"stok","name":"NAMA_AKUN","exists":false},{"table":"stok","name":"TIPE","exists":false},{"table":"stok","name":"DATA_TYPE","exists":false},{"table":"stok","name":"COLUMN_TYPE","exists":false},{"table":"stok","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"stok","name":"0) + 1","exists":false},{"table":"stok","name":"NAMA_MPEM","exists":false},{"table":"stok","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"stok","name":"ID_MPEM) VALUES (?","exists":false},{"table":"stok","name":"?","exists":false},{"table":"stok","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"stok","name":"$nomor_nota","exists":false},{"table":"stok","name":"$nik_customer","exists":false},{"table":"stok","name":"$nik_karyawan","exists":false},{"table":"stok","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"stok","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"stok","name":1,"exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_DETAIL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_JURNAL_UMUM","exists":false},{"table":"PIUTANG_CUSTOMER","name":"KODE_AKUN","exists":false},{"table":"PIUTANG_CUSTOMER","name":"POSISI","exists":false},{"table":"PIUTANG_CUSTOMER","name":"NILAI","exists":false},{"table":"PIUTANG_CUSTOMER","name":"NOMOR_NOTA","exists":true},{"table":"PIUTANG_CUSTOMER","name":"NIK_CUSTOMER","exists":false},{"table":"PIUTANG_CUSTOMER","name":"NIK_KARYAWAN","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_MPEM","exists":false},{"table":"PIUTANG_CUSTOMER","name":"KODE_BARANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_BARANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_PIUTANG","exists":true},{"table":"PIUTANG_CUSTOMER","name":"STATUS","exists":true},{"table":"PIUTANG_CUSTOMER","name":"TANGGAL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"REF","exists":false},{"table":"PIUTANG_CUSTOMER","name":"KETERANGAN","exists":false},{"table":"PIUTANG_CUSTOMER","name":"NAMA_AKUN","exists":false},{"table":"PIUTANG_CUSTOMER","name":"TIPE","exists":false},{"table":"PIUTANG_CUSTOMER","name":"DATA_TYPE","exists":false},{"table":"PIUTANG_CUSTOMER","name":"COLUMN_TYPE","exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"0) + 1","exists":false},{"table":"PIUTANG_CUSTOMER","name":"NAMA_MPEM","exists":false},{"table":"PIUTANG_CUSTOMER","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_MPEM) VALUES (?","exists":false},{"table":"PIUTANG_CUSTOMER","name":"?","exists":false},{"table":"PIUTANG_CUSTOMER","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"PIUTANG_CUSTOMER","name":"$nomor_nota","exists":false},{"table":"PIUTANG_CUSTOMER","name":"$nik_customer","exists":false},{"table":"PIUTANG_CUSTOMER","name":"$nik_karyawan","exists":false},{"table":"PIUTANG_CUSTOMER","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"PIUTANG_CUSTOMER","name":1,"exists":false},{"table":"jumlah","name":"ID_DETAIL","exists":false},{"table":"jumlah","name":"ID_JURNAL_UMUM","exists":false},{"table":"jumlah","name":"KODE_AKUN","exists":false},{"table":"jumlah","name":"POSISI","exists":false},{"table":"jumlah","name":"NILAI","exists":false},{"table":"jumlah","name":"NOMOR_NOTA","exists":false},{"table":"jumlah","name":"NIK_CUSTOMER","exists":false},{"table":"jumlah","name":"NIK_KARYAWAN","exists":false},{"table":"jumlah","name":"ID_MPEM","exists":false},{"table":"jumlah","name":"KODE_BARANG","exists":false},{"table":"jumlah","name":"JUMLAH_BARANG","exists":false},{"table":"jumlah","name":"JUMLAH_PIUTANG","exists":false},{"table":"jumlah","name":"STATUS","exists":false},{"table":"jumlah","name":"TANGGAL","exists":false},{"table":"jumlah","name":"REF","exists":false},{"table":"jumlah","name":"KETERANGAN","exists":false},{"table":"jumlah","name":"NAMA_AKUN","exists":false},{"table":"jumlah","name":"TIPE","exists":false},{"table":"jumlah","name":"DATA_TYPE","exists":false},{"table":"jumlah","name":"COLUMN_TYPE","exists":false},{"table":"jumlah","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"jumlah","name":"0) + 1","exists":false},{"table":"jumlah","name":"NAMA_MPEM","exists":false},{"table":"jumlah","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"jumlah","name":"ID_MPEM) VALUES (?","exists":false},{"table":"jumlah","name":"?","exists":false},{"table":"jumlah","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"jumlah","name":"$nomor_nota","exists":false},{"table":"jumlah","name":"$nik_customer","exists":false},{"table":"jumlah","name":"$nik_karyawan","exists":false},{"table":"jumlah","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"jumlah","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"jumlah","name":1,"exists":false},{"table":"piutang","name":"ID_DETAIL","exists":false},{"table":"piutang","name":"ID_JURNAL_UMUM","exists":false},{"table":"piutang","name":"KODE_AKUN","exists":false},{"table":"piutang","name":"POSISI","exists":false},{"table":"piutang","name":"NILAI","exists":false},{"table":"piutang","name":"NOMOR_NOTA","exists":false},{"table":"piutang","name":"NIK_CUSTOMER","exists":false},{"table":"piutang","name":"NIK_KARYAWAN","exists":false},{"table":"piutang","name":"ID_MPEM","exists":false},{"table":"piutang","name":"KODE_BARANG","exists":false},{"table":"piutang","name":"JUMLAH_BARANG","exists":false},{"table":"piutang","name":"JUMLAH_PIUTANG","exists":false},{"table":"piutang","name":"STATUS","exists":false},{"table":"piutang","name":"TANGGAL","exists":false},{"table":"piutang","name":"REF","exists":false},{"table":"piutang","name":"KETERANGAN","exists":false},{"table":"piutang","name":"NAMA_AKUN","exists":false},{"table":"piutang","name":"TIPE","exists":false},{"table":"piutang","name":"DATA_TYPE","exists":false},{"table":"piutang","name":"COLUMN_TYPE","exists":false},{"table":"piutang","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"piutang","name":"0) + 1","exists":false},{"table":"piutang","name":"NAMA_MPEM","exists":false},{"table":"piutang","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"piutang","name":"ID_MPEM) VALUES (?","exists":false},{"table":"piutang","name":"?","exists":false},{"table":"piutang","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"piutang","name":"$nomor_nota","exists":false},{"table":"piutang","name":"$nik_customer","exists":false},{"table":"piutang","name":"$nik_karyawan","exists":false},{"table":"piutang","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"piutang","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"piutang","name":1,"exists":false},{"table":"JURNAL_UMUM","name":"ID_DETAIL","exists":false},{"table":"JURNAL_UMUM","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_UMUM","name":"KODE_AKUN","exists":false},{"table":"JURNAL_UMUM","name":"POSISI","exists":false},{"table":"JURNAL_UMUM","name":"NILAI","exists":false},{"table":"JURNAL_UMUM","name":"NOMOR_NOTA","exists":false},{"table":"JURNAL_UMUM","name":"NIK_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"NIK_KARYAWAN","exists":false},{"table":"JURNAL_UMUM","name":"ID_MPEM","exists":false},{"table":"JURNAL_UMUM","name":"KODE_BARANG","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_BARANG","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":"STATUS","exists":false},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"REF","exists":true},{"table":"JURNAL_UMUM","name":"KETERANGAN","exists":true},{"table":"JURNAL_UMUM","name":"NAMA_AKUN","exists":false},{"table":"JURNAL_UMUM","name":"TIPE","exists":false},{"table":"JURNAL_UMUM","name":"DATA_TYPE","exists":false},{"table":"JURNAL_UMUM","name":"COLUMN_TYPE","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"JURNAL_UMUM","name":"0) + 1","exists":false},{"table":"JURNAL_UMUM","name":"NAMA_MPEM","exists":false},{"table":"JURNAL_UMUM","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"JURNAL_UMUM","name":"ID_MPEM) VALUES (?","exists":false},{"table":"JURNAL_UMUM","name":"?","exists":false},{"table":"JURNAL_UMUM","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"JURNAL_UMUM","name":"$nomor_nota","exists":false},{"table":"JURNAL_UMUM","name":"$nik_customer","exists":false},{"table":"JURNAL_UMUM","name":"$nik_karyawan","exists":false},{"table":"JURNAL_UMUM","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"JURNAL_UMUM","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":1,"exists":false},{"table":"KODE_AKUN","name":"ID_DETAIL","exists":false},{"table":"KODE_AKUN","name":"ID_JURNAL_UMUM","exists":false},{"table":"KODE_AKUN","name":"KODE_AKUN","exists":true},{"table":"KODE_AKUN","name":"POSISI","exists":false},{"table":"KODE_AKUN","name":"NILAI","exists":false},{"table":"KODE_AKUN","name":"NOMOR_NOTA","exists":false},{"table":"KODE_AKUN","name":"NIK_CUSTOMER","exists":false},{"table":"KODE_AKUN","name":"NIK_KARYAWAN","exists":false},{"table":"KODE_AKUN","name":"ID_MPEM","exists":false},{"table":"KODE_AKUN","name":"KODE_BARANG","exists":false},{"table":"KODE_AKUN","name":"JUMLAH_BARANG","exists":false},{"table":"KODE_AKUN","name":"JUMLAH_PIUTANG","exists":false},{"table":"KODE_AKUN","name":"STATUS","exists":false},{"table":"KODE_AKUN","name":"TANGGAL","exists":false},{"table":"KODE_AKUN","name":"REF","exists":false},{"table":"KODE_AKUN","name":"KETERANGAN","exists":false},{"table":"KODE_AKUN","name":"NAMA_AKUN","exists":true},{"table":"KODE_AKUN","name":"TIPE","exists":true},{"table":"KODE_AKUN","name":"DATA_TYPE","exists":false},{"table":"KODE_AKUN","name":"COLUMN_TYPE","exists":false},{"table":"KODE_AKUN","name":"COALESCE((CAST(ID_DETAIL","exists":false},{"table":"KODE_AKUN","name":"0) + 1","exists":false},{"table":"KODE_AKUN","name":"NAMA_MPEM","exists":false},{"table":"KODE_AKUN","name":"terbaru) $sql_nota = INSERT INTO NOTA_JUAL (NOMOR_NOTA","exists":false},{"table":"KODE_AKUN","name":"ID_MPEM) VALUES (?","exists":false},{"table":"KODE_AKUN","name":"?","exists":false},{"table":"KODE_AKUN","name":"?); $stmt_nota = $koneksi->prepare($sql_nota); if (!$stmt_nota) { throw new Exception(Prepare insert nota gagal: . $koneksi->error); } $stmt_nota->bind_param(ssss","exists":false},{"table":"KODE_AKUN","name":"$nomor_nota","exists":false},{"table":"KODE_AKUN","name":"$nik_customer","exists":false},{"table":"KODE_AKUN","name":"$nik_karyawan","exists":false},{"table":"KODE_AKUN","name":"$id_mpem); if (!$stmt_nota->execute()) { throw new Exception(Insert nota gagal: . $stmt_nota->error); } $stmt_nota->close(); // NOMOR_NOTA sudah ditentukan di atas; tidak perlu SELECT berdasarkan kombinasi non-unik // Hitung total transaksi berdasarkan harga barang x jumlah $totalTransaksi = 0.0; // Insert detail nota (skema baru) foreach ($detail_items as $item) { $kode_barang = $item['KODE_BARANG'] ?? ''; $qty = (int)($item['QTY'] ?? ($item['JUMLAH_BARANG'] ?? 0)); // Validasi barang dan stok $stmt_barang = $koneksi->prepare(SELECT HARGA_BARANG","exists":false},{"table":"KODE_AKUN","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"KODE_AKUN","name":1,"exists":false}],"summary":"ISSUES"},{"file":"assign_membership_from_type.php","tables":[{"name":"MASTER_MEMBERSHIP_TYPE","exists":true},{"name":"MASTER_MEMBERSHIP","exists":true},{"name":"TRANSAKSI_MEMBERSHIP","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"JURNAL_DETAIL","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP_TYPE","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"NIK_CUSTOMER","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"STATUS","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"LAST_UPDATED","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"TIMESTAMP_HABIS","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"TANGGAL","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"REF","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"KETERANGAN","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"ID_JURNAL_UMUM","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"KODE_AKUN","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"POSISI","exists":false},{"table":"MASTER_MEMBERSHIP_TYPE","name":"NILAI","exists":false},{"table":"MASTER_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP","name":"STATUS","exists":true},{"table":"MASTER_MEMBERSHIP","name":"LAST_UPDATED","exists":true},{"table":"MASTER_MEMBERSHIP","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"MASTER_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":false},{"table":"MASTER_MEMBERSHIP","name":"TANGGAL","exists":false},{"table":"MASTER_MEMBERSHIP","name":"REF","exists":false},{"table":"MASTER_MEMBERSHIP","name":"KETERANGAN","exists":false},{"table":"MASTER_MEMBERSHIP","name":"ID_JURNAL_UMUM","exists":false},{"table":"MASTER_MEMBERSHIP","name":"KODE_AKUN","exists":false},{"table":"MASTER_MEMBERSHIP","name":"POSISI","exists":false},{"table":"MASTER_MEMBERSHIP","name":"NILAI","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"STATUS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"LAST_UPDATED","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_TRANSAKSI_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"TANGGAL","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"REF","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"KETERANGAN","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_JURNAL_UMUM","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"KODE_AKUN","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"POSISI","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"NILAI","exists":false},{"table":"JURNAL_UMUM","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"NIK_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"NAMA_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"HARGA_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"POTONGAN","exists":false},{"table":"JURNAL_UMUM","name":"STATUS","exists":false},{"table":"JURNAL_UMUM","name":"LAST_UPDATED","exists":false},{"table":"JURNAL_UMUM","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"TIMESTAMP_HABIS","exists":false},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"REF","exists":true},{"table":"JURNAL_UMUM","name":"KETERANGAN","exists":true},{"table":"JURNAL_UMUM","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_UMUM","name":"KODE_AKUN","exists":false},{"table":"JURNAL_UMUM","name":"POSISI","exists":false},{"table":"JURNAL_UMUM","name":"NILAI","exists":false},{"table":"JURNAL_DETAIL","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"NIK_CUSTOMER","exists":false},{"table":"JURNAL_DETAIL","name":"NAMA_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"HARGA_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"POTONGAN","exists":false},{"table":"JURNAL_DETAIL","name":"STATUS","exists":false},{"table":"JURNAL_DETAIL","name":"LAST_UPDATED","exists":false},{"table":"JURNAL_DETAIL","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"TIMESTAMP_HABIS","exists":false},{"table":"JURNAL_DETAIL","name":"TANGGAL","exists":false},{"table":"JURNAL_DETAIL","name":"REF","exists":false},{"table":"JURNAL_DETAIL","name":"KETERANGAN","exists":false},{"table":"JURNAL_DETAIL","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_DETAIL","name":"KODE_AKUN","exists":true},{"table":"JURNAL_DETAIL","name":"POSISI","exists":true},{"table":"JURNAL_DETAIL","name":"NILAI","exists":true}],"summary":"ISSUES"},{"file":"check_schema.php","tables":[{"name":"INFORMATION_SCHEMA","exists":false},{"name":"INSERT","exists":false},{"name":"if","exists":false}],"columns":[{"table":"INFORMATION_SCHEMA","name":"DATABASE() AS db')) { if ($row = $res->fetch_assoc()) { $db = $row['db'] ?? ''; } $res->close(); } return $db; } function loadSchema($koneksi) { $schema = ['tables' => []","exists":false},{"table":"INFORMATION_SCHEMA","name":"'columns' => []]; if ($res = $koneksi->query('SELECT TABLE_NAME","exists":false},{"table":"INFORMATION_SCHEMA","name":"COLUMN_NAME","exists":false},{"table":"INSERT","name":"DATABASE() AS db')) { if ($row = $res->fetch_assoc()) { $db = $row['db'] ?? ''; } $res->close(); } return $db; } function loadSchema($koneksi) { $schema = ['tables' => []","exists":false},{"table":"INSERT","name":"'columns' => []]; if ($res = $koneksi->query('SELECT TABLE_NAME","exists":false},{"table":"INSERT","name":"COLUMN_NAME","exists":false},{"table":"if","name":"DATABASE() AS db')) { if ($row = $res->fetch_assoc()) { $db = $row['db'] ?? ''; } $res->close(); } return $db; } function loadSchema($koneksi) { $schema = ['tables' => []","exists":false},{"table":"if","name":"'columns' => []]; if ($res = $koneksi->query('SELECT TABLE_NAME","exists":false},{"table":"if","name":"COLUMN_NAME","exists":false}],"summary":"ISSUES"},{"file":"config.php","tables":[],"columns":[],"summary":"OK"},{"file":"delete_barang.php","tables":[{"name":"MSTR_BARANG","exists":true}],"columns":[],"summary":"OK"},{"file":"delete_customer.php","tables":[{"name":"CUSTOMER","exists":true}],"columns":[],"summary":"OK"},{"file":"delete_karyawan.php","tables":[{"name":"KARYAWAN","exists":true}],"columns":[],"summary":"OK"},{"file":"delete_membership.php","tables":[{"name":"TRANSAKSI_MEMBERSHIP","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"JURNAL_DETAIL","exists":true},{"name":"MASTER_MEMBERSHIP","exists":true}],"columns":[{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_TRANSAKSI_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_JURNAL_UMUM","exists":false},{"table":"JURNAL_UMUM","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_DETAIL","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"ID_JURNAL_UMUM","exists":true},{"table":"MASTER_MEMBERSHIP","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"MASTER_MEMBERSHIP","name":"ID_JURNAL_UMUM","exists":false}],"summary":"ISSUES"},{"file":"delete_metode_pembayaran.php","tables":[{"name":"MSTR_METODE_PEMBAYARAN","exists":true}],"columns":[],"summary":"OK"},{"file":"generate_code.php","tables":[],"columns":[],"summary":"OK"},{"file":"get_active_membership.php","tables":[{"name":"MASTER_MEMBERSHIP","exists":true},{"name":"TRANSAKSI_MEMBERSHIP","exists":true}],"columns":[{"table":"mm","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"mm","name":"NAMA_MEMBERSHIP","exists":false},{"table":"mm","name":"HARGA_MEMBERSHIP","exists":false},{"table":"mm","name":"POTONGAN","exists":false},{"table":"mm","name":"STATUS","exists":false},{"table":"MASTER_MEMBERSHIP","name":1,"exists":false},{"table":"MASTER_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"MASTER_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":1,"exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":true},{"table":"tm","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"tm","name":"TIMESTAMP_HABIS","exists":false},{"table":"tm","name":"NIK_CUSTOMER","exists":false}],"summary":"ISSUES"},{"file":"get_barang.php","tables":[{"name":"MSTR_BARANG","exists":true}],"columns":[{"table":"MSTR_BARANG","name":"KODE_BARANG","exists":true},{"table":"MSTR_BARANG","name":"NAMA_BARANG","exists":true},{"table":"MSTR_BARANG","name":"HARGA_BARANG","exists":true},{"table":"MSTR_BARANG","name":"JUMLAH_BARANG","exists":true},{"table":"MSTR_BARANG","name":"STATUS","exists":true}],"summary":"OK"},{"file":"get_buku_besar.php","tables":[{"name":"BUKU_BESAR","exists":true},{"name":"JURNAL_DETAIL","exists":true},{"name":"JURNAL_UMUM","exists":true}],"columns":[{"table":"BUKU_BESAR","name":"ID_JURNAL_UMUM","exists":true},{"table":"BUKU_BESAR","name":"KODE_AKUN","exists":true},{"table":"BUKU_BESAR","name":"TANGGAL","exists":true},{"table":"BUKU_BESAR","name":"KETERANGAN","exists":true},{"table":"BUKU_BESAR","name":"DEBIT","exists":true},{"table":"BUKU_BESAR","name":"KREDIT","exists":true},{"table":"BUKU_BESAR","name":"CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"BUKU_BESAR","name":"CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_DETAIL","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_DETAIL","name":"KODE_AKUN","exists":true},{"table":"JURNAL_DETAIL","name":"TANGGAL","exists":false},{"table":"JURNAL_DETAIL","name":"KETERANGAN","exists":false},{"table":"JURNAL_DETAIL","name":"DEBIT","exists":false},{"table":"JURNAL_DETAIL","name":"KREDIT","exists":false},{"table":"JURNAL_DETAIL","name":"CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_DETAIL","name":"CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_UMUM","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_UMUM","name":"KODE_AKUN","exists":false},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"KETERANGAN","exists":true},{"table":"JURNAL_UMUM","name":"DEBIT","exists":false},{"table":"JURNAL_UMUM","name":"KREDIT","exists":false},{"table":"JURNAL_UMUM","name":"CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_UMUM","name":"CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"ju","name":"ID_JURNAL_UMUM","exists":false},{"table":"ju","name":"TANGGAL","exists":false},{"table":"ju","name":"KETERANGAN","exists":false},{"table":"jd","name":"KODE_AKUN","exists":false},{"table":"jd","name":"POSISI","exists":false}],"summary":"ISSUES"},{"file":"get_cicilan.php","tables":[{"name":"TRS_CICILAN_PIUTANG","exists":true},{"name":"PIUTANG_CUSTOMER","exists":true}],"columns":[{"table":"c","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"c","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"c","name":"WAKTU_CICIL","exists":false},{"table":"c","name":"JUMLAH_BAYAR","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"p.STATUS","exists":false},{"table":"PIUTANG_CUSTOMER","name":"p.STATUS","exists":false},{"table":"p","name":"ID_PIUTANG_CUSTOMER","exists":false}],"summary":"ISSUES"},{"file":"get_customer.php","tables":[{"name":"CUSTOMER","exists":true}],"columns":[],"summary":"OK"},{"file":"get_dashboard_metrics.php","tables":[{"name":"JURNAL_UMUM","exists":true},{"name":"DETAIL_NOTA_JUAL","exists":true},{"name":"MSTR_BARANG","exists":true},{"name":"PIUTANG_CUSTOMER","exists":true},{"name":"TRS_CICILAN_PIUTANG","exists":true},{"name":"CUSTOMER","exists":true}],"columns":[{"table":"JURNAL_UMUM","name":"COALESCE((dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"JURNAL_UMUM","name":0,"exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"JURNAL_UMUM","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"NOMOR_NOTA","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":"STATUS","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"(*","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((JUMLAH_BARANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":0,"exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"NOMOR_NOTA","exists":true},{"table":"DETAIL_NOTA_JUAL","name":"JUMLAH_PIUTANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"STATUS","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"TANGGAL","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"(*","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((JUMLAH_BARANG","exists":false},{"table":"MSTR_BARANG","name":"COALESCE((dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"MSTR_BARANG","name":0,"exists":false},{"table":"MSTR_BARANG","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"MSTR_BARANG","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"MSTR_BARANG","name":"NOMOR_NOTA","exists":false},{"table":"MSTR_BARANG","name":"JUMLAH_PIUTANG","exists":false},{"table":"MSTR_BARANG","name":"STATUS","exists":true},{"table":"MSTR_BARANG","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"MSTR_BARANG","name":"TANGGAL","exists":false},{"table":"MSTR_BARANG","name":"(*","exists":false},{"table":"MSTR_BARANG","name":"COALESCE((JUMLAH_BARANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":0,"exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"PIUTANG_CUSTOMER","name":"NOMOR_NOTA","exists":true},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_PIUTANG","exists":true},{"table":"PIUTANG_CUSTOMER","name":"STATUS","exists":true},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"PIUTANG_CUSTOMER","name":"TANGGAL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"(*","exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((JUMLAH_BARANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":0,"exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"NOMOR_NOTA","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"JUMLAH_PIUTANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"STATUS","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"TANGGAL","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"(*","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((JUMLAH_BARANG","exists":false},{"table":"CUSTOMER","name":"COALESCE((dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"CUSTOMER","name":0,"exists":false},{"table":"CUSTOMER","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"CUSTOMER","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"CUSTOMER","name":"NOMOR_NOTA","exists":false},{"table":"CUSTOMER","name":"JUMLAH_PIUTANG","exists":false},{"table":"CUSTOMER","name":"STATUS","exists":false},{"table":"CUSTOMER","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"CUSTOMER","name":"TANGGAL","exists":false},{"table":"CUSTOMER","name":"(*","exists":false},{"table":"CUSTOMER","name":"COALESCE((JUMLAH_BARANG","exists":false},{"table":"dn","name":"NOMOR_NOTA","exists":false},{"table":"mb","name":"KODE_BARANG","exists":false}],"summary":"ISSUES"},{"file":"get_detail_nota.php","tables":[{"name":"DETAIL_NOTA_JUAL","exists":true},{"name":"MSTR_BARANG","exists":true}],"columns":[{"table":"dn","name":"NOMOR_NOTA","exists":false},{"table":"dn","name":"KODE_BARANG","exists":false},{"table":"dn","name":"JUMLAH_BARANG","exists":false},{"table":"mb","name":"NAMA_BARANG","exists":false},{"table":"mb","name":"HARGA_BARANG","exists":false},{"table":"mb","name":"KODE_BARANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"(dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"MSTR_BARANG","name":"(dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false}],"summary":"ISSUES"},{"file":"get_jurnal_detail.php","tables":[{"name":"JURNAL_DETAIL","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"KODE_AKUN","exists":true},{"name":"DETAIL_NOTA_JUAL","exists":true},{"name":"MSTR_BARANG","exists":true}],"columns":[{"table":"jd","name":"ID_DETAIL","exists":false},{"table":"jd","name":"ID_JURNAL_UMUM","exists":false},{"table":"jd","name":"KODE_AKUN","exists":false},{"table":"jd","name":"POSISI","exists":false},{"table":"jd","name":"NILAI","exists":false},{"table":"ka","name":"NAMA_AKUN","exists":false},{"table":"JURNAL_DETAIL","name":"REF","exists":false},{"table":"JURNAL_DETAIL","name":"(dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"JURNAL_UMUM","name":"REF","exists":true},{"table":"JURNAL_UMUM","name":"(dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"KODE_AKUN","name":"REF","exists":false},{"table":"KODE_AKUN","name":"(dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"REF","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"(dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"MSTR_BARANG","name":"REF","exists":false},{"table":"MSTR_BARANG","name":"(dn.JUMLAH_BARANG * mb.HARGA_BARANG","exists":false},{"table":"dn","name":"KODE_BARANG","exists":false},{"table":"dn","name":"JUMLAH_BARANG","exists":false},{"table":"dn","name":"NOMOR_NOTA","exists":false},{"table":"mb","name":"NAMA_BARANG","exists":false},{"table":"mb","name":"HARGA_BARANG","exists":false},{"table":"mb","name":"KODE_BARANG","exists":false}],"summary":"ISSUES"},{"file":"get_jurnal_umum.php","tables":[{"name":"JURNAL_UMUM","exists":true},{"name":"JURNAL_DETAIL","exists":true}],"columns":[{"table":"JURNAL_UMUM","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"KETERANGAN","exists":true},{"table":"JURNAL_UMUM","name":"(CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_UMUM","name":"(CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_DETAIL","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_DETAIL","name":"TANGGAL","exists":false},{"table":"JURNAL_DETAIL","name":"KETERANGAN","exists":false},{"table":"JURNAL_DETAIL","name":"(CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_DETAIL","name":"(CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"jd","name":"POSISI","exists":false},{"table":"jd","name":"ID_JURNAL_UMUM","exists":false}],"summary":"ISSUES"},{"file":"get_kartu_piutang.php","tables":[{"name":"PIUTANG_CUSTOMER","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"TRS_CICILAN_PIUTANG","exists":true}],"columns":[{"table":"PIUTANG_CUSTOMER","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"PIUTANG_CUSTOMER","name":"NOMOR_NOTA","exists":true},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_PIUTANG","exists":true},{"table":"PIUTANG_CUSTOMER","name":"STATUS","exists":true},{"table":"PIUTANG_CUSTOMER","name":"TANGGAL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"WAKTU_CICIL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_BAYAR","exists":false},{"table":"JURNAL_UMUM","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"NOMOR_NOTA","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":"STATUS","exists":false},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"ID_CICILAN_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":"WAKTU_CICIL","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_BAYAR","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"NOMOR_NOTA","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"JUMLAH_PIUTANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"STATUS","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"TANGGAL","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"ID_CICILAN_PIUTANG","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"WAKTU_CICIL","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"JUMLAH_BAYAR","exists":true}],"summary":"ISSUES"},{"file":"get_karyawan.php","tables":[{"name":"KARYAWAN","exists":true}],"columns":[],"summary":"OK"},{"file":"get_kode_akun.php","tables":[{"name":"KODE_AKUN","exists":true}],"columns":[],"summary":"OK"},{"file":"get_membership.php","tables":[{"name":"MASTER_MEMBERSHIP","exists":true},{"name":"TRANSAKSI_MEMBERSHIP","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP","name":"STATUS","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"MASTER_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"STATUS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":true}],"summary":"ISSUES"},{"file":"get_membership_type.php","tables":[{"name":"MASTER_MEMBERSHIP_TYPE","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP_TYPE","name":"ID_MEMBERSHIP_TYPE","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"STATUS","exists":true}],"summary":"OK"},{"file":"get_membership_with_customer.php","tables":[{"name":"MASTER_MEMBERSHIP","exists":true},{"name":"TRANSAKSI_MEMBERSHIP","exists":true},{"name":"CUSTOMER","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP","name":"STATUS","exists":true},{"table":"MASTER_MEMBERSHIP","name":"COALESCE(c.NAMA_CUSTOMER","exists":false},{"table":"MASTER_MEMBERSHIP","name":"CASE WHEN tm.TIMESTAMP_HABIS > NOW() THEN 1 ELSE 0 END","exists":false},{"table":"MASTER_MEMBERSHIP","name":"DATEDIFF(tm.TIMESTAMP_HABIS","exists":false},{"table":"MASTER_MEMBERSHIP","name":"NOW()","exists":false},{"table":"MASTER_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"MASTER_MEMBERSHIP","name":"(TIMESTAMP_HABIS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_MASTER_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"STATUS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"COALESCE(c.NAMA_CUSTOMER","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"CASE WHEN tm.TIMESTAMP_HABIS > NOW() THEN 1 ELSE 0 END","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"DATEDIFF(tm.TIMESTAMP_HABIS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"NOW()","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"NIK_CUSTOMER","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"(TIMESTAMP_HABIS","exists":false},{"table":"CUSTOMER","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"CUSTOMER","name":"NAMA_MEMBERSHIP","exists":false},{"table":"CUSTOMER","name":"HARGA_MEMBERSHIP","exists":false},{"table":"CUSTOMER","name":"POTONGAN","exists":false},{"table":"CUSTOMER","name":"STATUS","exists":false},{"table":"CUSTOMER","name":"COALESCE(c.NAMA_CUSTOMER","exists":false},{"table":"CUSTOMER","name":"CASE WHEN tm.TIMESTAMP_HABIS > NOW() THEN 1 ELSE 0 END","exists":false},{"table":"CUSTOMER","name":"DATEDIFF(tm.TIMESTAMP_HABIS","exists":false},{"table":"CUSTOMER","name":"NOW()","exists":false},{"table":"CUSTOMER","name":"NIK_CUSTOMER","exists":true},{"table":"CUSTOMER","name":"(TIMESTAMP_HABIS","exists":false},{"table":"tm","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"tm","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"tm","name":"NIK_CUSTOMER","exists":false},{"table":"tm","name":"NAMA_MEMBERSHIP","exists":false},{"table":"tm","name":"HARGA_MEMBERSHIP","exists":false},{"table":"tm","name":"POTONGAN","exists":false},{"table":"tm","name":"TIMESTAMP_HABIS","exists":false},{"table":"latest","name":"ID_MASTER_MEMBERSHIP","exists":false},{"table":"latest","name":"NIK_CUSTOMER","exists":false},{"table":"latest","name":"MAX_TS","exists":false},{"table":"c","name":"NIK_CUSTOMER","exists":false}],"summary":"ISSUES"},{"file":"get_metode_pembayaran.php","tables":[{"name":"MSTR_METODE_PEMBAYARAN","exists":true}],"columns":[{"table":"MSTR_METODE_PEMBAYARAN","name":"ID_MPEM","exists":true},{"table":"MSTR_METODE_PEMBAYARAN","name":"NAMA_MPEM","exists":true},{"table":"MSTR_METODE_PEMBAYARAN","name":"STATUS","exists":true}],"summary":"OK"},{"file":"get_neraca_saldo.php","tables":[{"name":"KODE_AKUN","exists":true},{"name":"BUKU_BESAR","exists":true},{"name":"JURNAL_DETAIL","exists":true},{"name":"JURNAL_UMUM","exists":true}],"columns":[{"table":"ka","name":"KODE_AKUN","exists":false},{"table":"ka","name":"NAMA_AKUN","exists":false},{"table":"KODE_AKUN","name":"COALESCE((bb.DEBIT","exists":false},{"table":"KODE_AKUN","name":0,"exists":false},{"table":"KODE_AKUN","name":"COALESCE((bb.KREDIT","exists":false},{"table":"KODE_AKUN","name":"0) - COALESCE((bb.KREDIT","exists":false},{"table":"KODE_AKUN","name":"COALESCE((CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"KODE_AKUN","name":"COALESCE((CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"KODE_AKUN","name":"0) - COALESCE((CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"BUKU_BESAR","name":"COALESCE((bb.DEBIT","exists":false},{"table":"BUKU_BESAR","name":0,"exists":false},{"table":"BUKU_BESAR","name":"COALESCE((bb.KREDIT","exists":false},{"table":"BUKU_BESAR","name":"0) - COALESCE((bb.KREDIT","exists":false},{"table":"BUKU_BESAR","name":"COALESCE((CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"BUKU_BESAR","name":"COALESCE((CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"BUKU_BESAR","name":"0) - COALESCE((CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_DETAIL","name":"COALESCE((bb.DEBIT","exists":false},{"table":"JURNAL_DETAIL","name":0,"exists":false},{"table":"JURNAL_DETAIL","name":"COALESCE((bb.KREDIT","exists":false},{"table":"JURNAL_DETAIL","name":"0) - COALESCE((bb.KREDIT","exists":false},{"table":"JURNAL_DETAIL","name":"COALESCE((CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_DETAIL","name":"COALESCE((CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_DETAIL","name":"0) - COALESCE((CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((bb.DEBIT","exists":false},{"table":"JURNAL_UMUM","name":0,"exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((bb.KREDIT","exists":false},{"table":"JURNAL_UMUM","name":"0) - COALESCE((bb.KREDIT","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((CASE WHEN jd.POSISI = 'D' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"JURNAL_UMUM","name":"0) - COALESCE((CASE WHEN jd.POSISI = 'K' THEN jd.NILAI ELSE 0 END","exists":false},{"table":"jd","name":"POSISI","exists":false},{"table":"jd","name":"KODE_AKUN","exists":false},{"table":"ju","name":"ID_JURNAL_UMUM","exists":false}],"summary":"ISSUES"},{"file":"get_nota_jual.php","tables":[{"name":"NOTA_JUAL","exists":true},{"name":"CUSTOMER","exists":true},{"name":"MSTR_METODE_PEMBAYARAN","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"DETAIL_NOTA_JUAL","exists":true},{"name":"MSTR_BARANG","exists":true},{"name":"PIUTANG_CUSTOMER","exists":true},{"name":"TRS_CICILAN_PIUTANG","exists":true}],"columns":[{"table":"N","name":"NOMOR_NOTA","exists":false},{"table":"N","name":"NIK_CUSTOMER","exists":false},{"table":"N","name":"NIK_KARYAWAN","exists":false},{"table":"N","name":"ID_MPEM","exists":false},{"table":"C","name":"NAMA_CUSTOMER","exists":false},{"table":"C","name":"NIK_CUSTOMER","exists":false},{"table":"M","name":"NAMA_MPEM","exists":false},{"table":"M","name":"ID_MPEM","exists":false},{"table":"NOTA_JUAL","name":"TANGGAL","exists":false},{"table":"NOTA_JUAL","name":"(D.JUMLAH_BARANG * B.HARGA_BARANG","exists":false},{"table":"NOTA_JUAL","name":"COALESCE((JUMLAH_PIUTANG","exists":false},{"table":"NOTA_JUAL","name":0,"exists":false},{"table":"NOTA_JUAL","name":"COALESCE((STATUS","exists":false},{"table":"NOTA_JUAL","name":"COALESCE((c.JUMLAH_BAYAR","exists":false},{"table":"NOTA_JUAL","name":"STATUS","exists":true},{"table":"CUSTOMER","name":"TANGGAL","exists":false},{"table":"CUSTOMER","name":"(D.JUMLAH_BARANG * B.HARGA_BARANG","exists":false},{"table":"CUSTOMER","name":"COALESCE((JUMLAH_PIUTANG","exists":false},{"table":"CUSTOMER","name":0,"exists":false},{"table":"CUSTOMER","name":"COALESCE((STATUS","exists":false},{"table":"CUSTOMER","name":"COALESCE((c.JUMLAH_BAYAR","exists":false},{"table":"CUSTOMER","name":"STATUS","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"TANGGAL","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"(D.JUMLAH_BARANG * B.HARGA_BARANG","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"COALESCE((JUMLAH_PIUTANG","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":0,"exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"COALESCE((STATUS","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"COALESCE((c.JUMLAH_BAYAR","exists":false},{"table":"MSTR_METODE_PEMBAYARAN","name":"STATUS","exists":true},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"(D.JUMLAH_BARANG * B.HARGA_BARANG","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":0,"exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((STATUS","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((c.JUMLAH_BAYAR","exists":false},{"table":"JURNAL_UMUM","name":"STATUS","exists":false},{"table":"JURNAL_UMUM","name":"REF","exists":true},{"table":"DETAIL_NOTA_JUAL","name":"TANGGAL","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"(D.JUMLAH_BARANG * B.HARGA_BARANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((JUMLAH_PIUTANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":0,"exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((STATUS","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((c.JUMLAH_BAYAR","exists":false},{"table":"DETAIL_NOTA_JUAL","name":"STATUS","exists":false},{"table":"MSTR_BARANG","name":"TANGGAL","exists":false},{"table":"MSTR_BARANG","name":"(D.JUMLAH_BARANG * B.HARGA_BARANG","exists":false},{"table":"MSTR_BARANG","name":"COALESCE((JUMLAH_PIUTANG","exists":false},{"table":"MSTR_BARANG","name":0,"exists":false},{"table":"MSTR_BARANG","name":"COALESCE((STATUS","exists":false},{"table":"MSTR_BARANG","name":"COALESCE((c.JUMLAH_BAYAR","exists":false},{"table":"MSTR_BARANG","name":"STATUS","exists":true},{"table":"PIUTANG_CUSTOMER","name":"TANGGAL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"(D.JUMLAH_BARANG * B.HARGA_BARANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((JUMLAH_PIUTANG","exists":false},{"table":"PIUTANG_CUSTOMER","name":0,"exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((STATUS","exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((c.JUMLAH_BAYAR","exists":false},{"table":"PIUTANG_CUSTOMER","name":"STATUS","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"TANGGAL","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"(D.JUMLAH_BARANG * B.HARGA_BARANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((JUMLAH_PIUTANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":0,"exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((STATUS","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((c.JUMLAH_BAYAR","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"STATUS","exists":false},{"table":"B","name":"KODE_BARANG","exists":false},{"table":"D","name":"NOMOR_NOTA","exists":false},{"table":"p","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"p","name":"NOMOR_NOTA","exists":false}],"summary":"ISSUES"},{"file":"get_piutang.php","tables":[{"name":"PIUTANG_CUSTOMER","exists":true},{"name":"NOTA_JUAL","exists":true},{"name":"CUSTOMER","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"TRS_CICILAN_PIUTANG","exists":true}],"columns":[{"table":"PIUTANG_CUSTOMER","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"PIUTANG_CUSTOMER","name":"NOMOR_NOTA","exists":true},{"table":"PIUTANG_CUSTOMER","name":"JUMLAH_PIUTANG","exists":true},{"table":"PIUTANG_CUSTOMER","name":"STATUS","exists":true},{"table":"PIUTANG_CUSTOMER","name":"NIK_CUSTOMER","exists":false},{"table":"PIUTANG_CUSTOMER","name":"ID_MPEM","exists":false},{"table":"PIUTANG_CUSTOMER","name":"NAMA_CUSTOMER","exists":false},{"table":"PIUTANG_CUSTOMER","name":"TANGGAL","exists":false},{"table":"PIUTANG_CUSTOMER","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"PIUTANG_CUSTOMER","name":0,"exists":false},{"table":"PIUTANG_CUSTOMER","name":"(WAKTU_CICIL","exists":false},{"table":"NOTA_JUAL","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"NOTA_JUAL","name":"NOMOR_NOTA","exists":true},{"table":"NOTA_JUAL","name":"JUMLAH_PIUTANG","exists":false},{"table":"NOTA_JUAL","name":"STATUS","exists":true},{"table":"NOTA_JUAL","name":"NIK_CUSTOMER","exists":true},{"table":"NOTA_JUAL","name":"ID_MPEM","exists":true},{"table":"NOTA_JUAL","name":"NAMA_CUSTOMER","exists":false},{"table":"NOTA_JUAL","name":"TANGGAL","exists":false},{"table":"NOTA_JUAL","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"NOTA_JUAL","name":0,"exists":false},{"table":"NOTA_JUAL","name":"(WAKTU_CICIL","exists":false},{"table":"CUSTOMER","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"CUSTOMER","name":"NOMOR_NOTA","exists":false},{"table":"CUSTOMER","name":"JUMLAH_PIUTANG","exists":false},{"table":"CUSTOMER","name":"STATUS","exists":false},{"table":"CUSTOMER","name":"NIK_CUSTOMER","exists":true},{"table":"CUSTOMER","name":"ID_MPEM","exists":false},{"table":"CUSTOMER","name":"NAMA_CUSTOMER","exists":true},{"table":"CUSTOMER","name":"TANGGAL","exists":false},{"table":"CUSTOMER","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"CUSTOMER","name":0,"exists":false},{"table":"CUSTOMER","name":"(WAKTU_CICIL","exists":false},{"table":"JURNAL_UMUM","name":"ID_PIUTANG_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"NOMOR_NOTA","exists":false},{"table":"JURNAL_UMUM","name":"JUMLAH_PIUTANG","exists":false},{"table":"JURNAL_UMUM","name":"STATUS","exists":false},{"table":"JURNAL_UMUM","name":"NIK_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"ID_MPEM","exists":false},{"table":"JURNAL_UMUM","name":"NAMA_CUSTOMER","exists":false},{"table":"JURNAL_UMUM","name":"TANGGAL","exists":true},{"table":"JURNAL_UMUM","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"JURNAL_UMUM","name":0,"exists":false},{"table":"JURNAL_UMUM","name":"(WAKTU_CICIL","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"ID_PIUTANG_CUSTOMER","exists":true},{"table":"TRS_CICILAN_PIUTANG","name":"NOMOR_NOTA","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"JUMLAH_PIUTANG","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"STATUS","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"NIK_CUSTOMER","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"ID_MPEM","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"NAMA_CUSTOMER","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"TANGGAL","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"COALESCE((JUMLAH_BAYAR","exists":false},{"table":"TRS_CICILAN_PIUTANG","name":0,"exists":false},{"table":"TRS_CICILAN_PIUTANG","name":"(WAKTU_CICIL","exists":false}],"summary":"ISSUES"},{"file":"get_sold_items_detail.php","tables":[{"name":"JURNAL_UMUM","exists":true},{"name":"DETAIL_NOTA_JUAL","exists":true},{"name":"MSTR_BARANG","exists":true}],"columns":[{"table":"mb","name":"KODE_BARANG","exists":false},{"table":"mb","name":"NAMA_BARANG","exists":false},{"table":"JURNAL_UMUM","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"JURNAL_UMUM","name":0,"exists":false},{"table":"DETAIL_NOTA_JUAL","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"DETAIL_NOTA_JUAL","name":0,"exists":false},{"table":"MSTR_BARANG","name":"COALESCE((dn.JUMLAH_BARANG","exists":false},{"table":"MSTR_BARANG","name":0,"exists":false},{"table":"dn","name":"NOMOR_NOTA","exists":false}],"summary":"ISSUES"},{"file":"login.php","tables":[{"name":"KARYAWAN","exists":true}],"columns":[{"table":"KARYAWAN","name":"NIK_KARYAWAN","exists":true},{"table":"KARYAWAN","name":"NAMA_KARYAWAN","exists":true},{"table":"KARYAWAN","name":"EMAIL","exists":true},{"table":"KARYAWAN","name":"PASSWORD","exists":true},{"table":"KARYAWAN","name":"ROLE","exists":true}],"summary":"OK"},{"file":"migrate_roles.php","tables":[{"name":"INFORMATION_SCHEMA","exists":false}],"columns":[{"table":"INFORMATION_SCHEMA","name":1,"exists":false}],"summary":"ISSUES"},{"file":"remove_member_from_membership.php","tables":[{"name":"TRANSAKSI_MEMBERSHIP","exists":true},{"name":"JURNAL_UMUM","exists":true},{"name":"JURNAL_DETAIL","exists":true}],"columns":[{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_TRANSAKSI_MEMBERSHIP","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_JURNAL_UMUM","exists":false},{"table":"JURNAL_UMUM","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"JURNAL_UMUM","name":"ID_JURNAL_UMUM","exists":true},{"table":"JURNAL_DETAIL","name":"ID_TRANSAKSI_MEMBERSHIP","exists":false},{"table":"JURNAL_DETAIL","name":"ID_JURNAL_UMUM","exists":true}],"summary":"ISSUES"},{"file":"update_barang.php","tables":[{"name":"MSTR_BARANG","exists":true}],"columns":[{"table":"MSTR_BARANG","name":"NAMA_BARANG","exists":true},{"table":"MSTR_BARANG","name":"HARGA_BARANG","exists":true},{"table":"MSTR_BARANG","name":"JUMLAH_BARANG","exists":true},{"table":"MSTR_BARANG","name":"STATUS","exists":true}],"summary":"OK"},{"file":"update_customer.php","tables":[{"name":"CUSTOMER","exists":true}],"columns":[{"table":"CUSTOMER","name":"NAMA_CUSTOMER","exists":true},{"table":"CUSTOMER","name":"EMAIL","exists":true}],"summary":"OK"},{"file":"update_karyawan.php","tables":[{"name":"KARYAWAN","exists":true}],"columns":[{"table":"KARYAWAN","name":"NAMA_KARYAWAN","exists":true},{"table":"KARYAWAN","name":"EMAIL","exists":true},{"table":"KARYAWAN","name":"PASSWORD","exists":true},{"table":"KARYAWAN","name":"ROLE","exists":true}],"summary":"OK"},{"file":"update_member_status.php","tables":[{"name":"TRANSAKSI_MEMBERSHIP","exists":true}],"columns":[{"table":"TRANSAKSI_MEMBERSHIP","name":"STATUS","exists":false},{"table":"TRANSAKSI_MEMBERSHIP","name":"TIMESTAMP_HABIS","exists":true},{"table":"TRANSAKSI_MEMBERSHIP","name":"ID_TRANSAKSI_MEMBERSHIP","exists":true}],"summary":"ISSUES"},{"file":"update_membership.php","tables":[{"name":"MASTER_MEMBERSHIP","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP","name":"STATUS","exists":true}],"summary":"OK"},{"file":"update_membership_status.php","tables":[{"name":"MASTER_MEMBERSHIP","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP","name":"STATUS","exists":true},{"table":"MASTER_MEMBERSHIP","name":"LAST_UPDATED","exists":true}],"summary":"OK"},{"file":"update_membership_type.php","tables":[{"name":"MASTER_MEMBERSHIP_TYPE","exists":true}],"columns":[{"table":"MASTER_MEMBERSHIP_TYPE","name":"NAMA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"HARGA_MEMBERSHIP","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"POTONGAN","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"STATUS","exists":true},{"table":"MASTER_MEMBERSHIP_TYPE","name":"LAST_UPDATED","exists":true}],"summary":"OK"},{"file":"update_membership_with_journal.php","tables":[],"columns":[],"summary":"OK"},{"file":"update_metode_pembayaran.php","tables":[{"name":"MSTR_METODE_PEMBAYARAN","exists":true}],"columns":[{"table":"MSTR_METODE_PEMBAYARAN","name":"NAMA_MPEM","exists":true},{"table":"MSTR_METODE_PEMBAYARAN","name":"STATUS","exists":true}],"summary":"OK"}]}