CATATAN PONDOK INDUK

[SUDAH] samping logo : PONDOK PESANTREN BAHRUL ULUM (INDUK)
[SUDAH] hapus santri baru
[SUDAH] shortcut data santri
[SUDAH] placeholder (di isi sesuai KK)
[SUDAH] password santri baru
[SUDAH] max upload bukti 2MB
[SUDAH] import santri baru

[SUDAH] Tahapan Pembayaran Nominal Bisa dinamis
[SUDAH] Import Pembayaran

- Informasi Data Santri (Pembayaran, dll.)


PERUBAHAN DATABASE
- tambah option=background di tabel settings
- tambah kolom id_tahapan  di table data_santri

CREATE TABLE `pembayaran` (
  `pembayaran_id` bigint(20) NOT NULL,
  `no_induk` bigint(20) NOT NULL,
  `pembayaran` double NOT NULL,
  `bulan` int(11) NOT NULL,
  `tahun` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `keterangan` text NOT NULL,
  `created_by` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `tahapan` (
  `id_tahapan` int(11) NOT NULL,
  `tahap_1` double NOT NULL,
  `tahap_2` double NOT NULL,
  `tahun_aktif` int(11) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `pembayaran`
  ADD PRIMARY KEY (`pembayaran_id`);
ALTER TABLE `pembayaran`
  MODIFY `pembayaran_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;

ALTER TABLE `tahapan`
  ADD PRIMARY KEY (`id_tahapan`);
ALTER TABLE `tahapan`
  MODIFY `id_tahapan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;


ALTER TABLE `tahapan` ADD `status_aktif` INT NOT NULL DEFAULT '0' AFTER `tahun_aktif`;