INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (115,95,'LIBRARY_VISITOR','Pengunjung perpus','/dashboard/library-visitor',NULL,'groups',1,1,'2022-09-20 05:50:07',NULL);
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (116,NULL,'UKS','UKS',NULL,NULL,'medical_services',1,1,'2022-09-20 18:26:26',NULL);
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (117,116,'PATIENT','Pasien','/dashboard/patient',NULL,'personal_injury',1,1,'2022-09-20 18:28:00',NULL);
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (118,101,'STUDENT_PERMISSION','Izin siswa','/dashboard/student-permission',NULL,'rule',1,1,'2022-09-20 23:27:17','2022-09-20 23:27:32');
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (119,100,'EMPLOYEE_PERMISSION','Izin pegawai','/dashboard/employee-permission',NULL,'rule',1,1,'2022-09-21 00:23:21','2022-09-21 00:24:42');
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (120,NULL,'PARENT_PSB_ADMIN','PPDB Admin',NULL,NULL,'group_add',1,1,'2022-09-23 07:25:55','2022-09-23 07:26:34');
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (121,91,'DEFINED_EXPENSE','Jenis pengeluaran','/dashboard/defined-expense',NULL,'file_upload',1,1,'2022-09-24 20:49:59',NULL);

INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (492,115,'CREATE','Baru','2022-09-20 05:50:07',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (493,115,'EDIT','Ubah','2022-09-20 05:50:07',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (494,115,'DELETE','Hapus','2022-09-20 05:50:07',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (495,115,'READ_ALL','Semua Data','2022-09-20 05:50:07',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (496,116,'CREATE','Baru','2022-09-20 18:26:26',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (497,116,'EDIT','Ubah','2022-09-20 18:26:26',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (498,116,'DELETE','Hapus','2022-09-20 18:26:26',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (499,116,'READ_ALL','Semua Data','2022-09-20 18:26:26',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (500,117,'CREATE','Baru','2022-09-20 18:28:00',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (501,117,'EDIT','Ubah','2022-09-20 18:28:00',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (502,117,'DELETE','Hapus','2022-09-20 18:28:00',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (503,117,'READ_ALL','Semua Data','2022-09-20 18:28:00',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (504,118,'CREATE','Baru','2022-09-20 23:27:17',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (505,118,'EDIT','Ubah','2022-09-20 23:27:17',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (506,118,'DELETE','Hapus','2022-09-20 23:27:17',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (507,118,'READ_ALL','Semua Data','2022-09-20 23:27:17',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (508,119,'CREATE','Baru','2022-09-21 00:23:21',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (509,119,'EDIT','Ubah','2022-09-21 00:23:21',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (510,119,'DELETE','Hapus','2022-09-21 00:23:21',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (511,119,'READ_ALL','Semua Data','2022-09-21 00:23:21',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (512,5,'FINANCIAL_ACTION_SHORTCUT','Transaksi keuangan','2022-09-21 19:00:39',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (513,120,'CREATE','Baru','2022-09-23 07:25:55',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (514,120,'EDIT','Ubah','2022-09-23 07:25:55',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (515,120,'DELETE','Hapus','2022-09-23 07:25:55',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (516,120,'READ_ALL','Semua Data','2022-09-23 07:25:55',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (517,121,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (518,121,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (519,121,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (520,121,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (521,84,'ADD_BILL_TYPE','Tambah harga khusus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (522,84,'DELETE_BILL_TYPE','Hapus harga khusus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (523,72,'AUTO_DEBET_WITHDRAWAL','Tarik tunai auto debet','2022-09-24 20:49:59',NULL);

update menus set code='DEFINED_INCOME', name='Jenis penerimaan', webPath='/dashboard/defined-income', icon='download' where id=67;
update actions set name='Baru' where id=212;

update menus set name = REPLACE(name,'PSB','PPDB');

update settings set `group`='PPDB' where `group` ='PSB' ;

update settings set code = REPLACE(code,'PSB','PPDB');

update settings set name = REPLACE(name,'PSB','PPDB');

update settings set `tableSource`='tahun_pelajarans' where code='PPDB_YEAR';

update menus set name='Kepegawaian' where code='PARENT_EMPLOYEE';

update menus set code='NEW_STUDENT_ADM' where id=84;

update menus set code='NEW_PARENT_ADM' where id=110;

update menus set parent_id=120 where code in ('PSB_SETTING','PSB_FLOW','NEW_PARENT_ADM','NEW_STUDENT_ADM');

INSERT INTO `role_menu` (`role_id`,`menu_id`) VALUES (1,117);
INSERT INTO `role_menu` (`role_id`,`menu_id`) VALUES (1,116);
INSERT INTO `role_menu` (`role_id`,`menu_id`) VALUES (1,118);
INSERT INTO `role_menu` (`role_id`,`menu_id`) VALUES (1,119);
INSERT INTO `role_menu` (`role_id`,`menu_id`) VALUES (1,120);
INSERT INTO `role_menu` (`role_id`,`menu_id`) VALUES (1,121);


delete from menus where id = 81;
delete from actions where menu_id = 81;
delete from role_menu where menu_id = 81;

INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('queue','QUEUE_LIBRARY_OPERATION','Perpus Operator','Perpus operator aktif',0,NULL,NULL,1,1,'2022-09-20 07:08:35','2022-09-20 07:25:54');

update `stores` set `balance`=0;

select * from user_role
where role_id = 3
and user_id in (
select user_id from employees
);

autodebet
---------------------------------------------------------------------------
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (122,91,'BALANCE_AUTODEBET','Autodebet saldo','/dashboard/autodebet',NULL,'credit_score',1,1,'2022-09-23 07:25:55','2022-09-23 07:26:34');
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (123,91,'AUTODEBET_TYPE','Jenis Autodebet','/dashboard/autodebet-type',NULL,'fact_check',1,1,'2022-09-24 20:49:59',NULL);

INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (524,122,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (525,122,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (526,122,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (527,122,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (528,123,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (529,123,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (530,123,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (531,123,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);


student reward
---------------------------------------------------------------------------
UPDATE `menus` SET `code` = 'MONTHLY_TAHFIDZ', `name` = 'Tahfidz Bulanan', `webPath` = '/dashboard/monthly-tahfidz' WHERE (`id` = '60');

INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (124,97,'REWARD_TYPE','Jenis penghargaan','/dashboard/reward-type',NULL,'military_tech',1,1,'2022-09-23 07:25:55','2022-09-23 07:26:34');
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (125,97,'STUDENT_REWARD','Penghargaan siswa','/dashboard/student-reward',NULL,'stars',1,1,'2022-09-24 20:49:59',NULL);

INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (532,124,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (533,124,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (534,124,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (535,124,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (536,125,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (537,125,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (538,125,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (539,125,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (540,56,'EQUITY','Modal','2022-09-24 20:49:59',NULL);

INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (57,'KEUANGAN','BALANCE_AUTODEBET_DATE','Tanggal autodebet saldo','integer',NULL,1,0,NULL,NULL,NULL,21,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:51:40','2022-10-21 06:53:56');
INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (59,'KEUANGAN','BALANCE_AUTODEBET_STATUS','Status autodebet saldo','boolean',NULL,1,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:54:04',NULL);
INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (60,'KEUANGAN','BALANCE_AUTODEBET_AMOUNT','Nominal autodebet saldo','integer',NULL,1,0,NULL,NULL,NULL,8000,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:55:34',NULL);

---------------------------------------------------------------------------
tambah rekening perkiraan modal 3000

---------------------------------------------------------------------------
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (126,101,'STUDENT_GROUP','Grup siswa','/dashboard/student-group',NULL,'group_work',1,1,'2022-09-24 20:49:59',NULL);

INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (541,126,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (542,126,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (543,126,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (544,126,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);

---------------------------------------------------------------------------
INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (61,'KEUANGAN','DAILY_PAY_LIMIT_PARENT','Maksimal jajan oleh orang tua','boolean',NULL,0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-07 00:17:12',NULL);
INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (62,'KEUANGAN','WA_NOTIF_BILL','Notifikasi WhatsApp','boolean',NULL,0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-07 00:17:12',NULL);
---------------------------------------------------------------------------
INSERT INTO `parameters` (`id`,`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES (35,'psb_exam_type','WRITE_EXAM','Ujian tulis','Ujian tulis',1,NULL,NULL,0,1,'2022-11-19 01:42:55',NULL);
INSERT INTO `parameters` (`id`,`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES (36,'psb_exam_type','PRACTICE_EXAM','Ujian praktek','Ujian praktek',2,NULL,NULL,0,1,'2022-11-19 01:43:18','2022-11-19 06:42:24');

INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (127,120,'PSB_EXAM_PARTICIPANT','Peserta ujian','/dashboard/psb-exam-participant',NULL,'design_services',1,1,'2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (545,127,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (546,127,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (547,127,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (548,127,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
---------------------------------------------------------------------------
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (128,101,'STUDENT_ATTENDANCE','Kehadiran siswa','/dashboard/student-attendance',NULL,'how_to_reg',1,1,'2022-09-24 20:49:59',NULL);
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (129,100,'EMPLOYEE_ATTENDANCE','Kehadiran pegawai','/dashboard/employee-attendance',NULL,'how_to_reg',1,1,'2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (549,128,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (550,128,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (551,128,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (552,128,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (553,129,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (554,129,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (555,129,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (556,129,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);

UPDATE `menus` SET `code` = 'ATTENDANCE_BY_TEACHER', `webPath` = '/dashboard/student-attendance-by-teacher' WHERE (`id` = '108');
---------------------------------------------------------------------------
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (130,91,'CASH_HOLDER','Pemegang Kas','/dashboard/coa-holder',NULL,'manage_accounts',1,1,'2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (557,130,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (558,130,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (559,130,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (560,130,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
---------------------------------------------------------------------------
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(63, 'GENERAL', 'FOUNDATION_NAME', 'Nama Yayasan', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Nama Yayasan', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(64, 'KEUANGAN', 'BILL_PAYMENT_MESSAGE', 'Pesan pembayaran', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Terimakasih telah melakukan pembayaran sebesar #nominal# untuk : <br>#jenis_tagihan# <br>', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
---------------------------------------------------------------------------
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (131,98,'PRODUCT_REPORT','Laporan penjualan','/dashboard/product-report',NULL,'assessment',1,1,'2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (561,131,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
---------------------------------------------------------------------------
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(65, 'GENERAL', 'UKS_MESSAGE', 'Pesan UKS', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Assalamualaikum warohmatullohi wabarokatuh,<br> kepada YTH orang tua *#siswa#*,<br> kami informasikan bahwa ananda sakit dan berada di UKS mohon segera hubungi pihak sekolah untuk informasi lebih lanjut.<br> Terimakasih atas perhatiannya, wassalamualaikum warohmatullohi wabarokatuh.<br> *#pengirim#*', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
---------------------------------------------------------------------------
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(66, 'KEUANGAN', 'TRANSACTION_PAPER_WIDTH', 'Lebar kertas struk', 'integer', 0, 0, NULL, NULL, NULL, 210, NULL, NULL, NULL, NULL, NULL, NULL, '2022-03-12 20:13:38', '2022-05-25 21:35:38');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(67, 'KEUANGAN', 'TRANSACTION_PAPER_HEIGHT', 'Panjang kertas struk', 'integer', 0, 0, NULL, NULL, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, '2022-03-12 20:13:38', '2022-05-25 21:35:38');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(68, 'KEUANGAN', 'TRANSACTION_PAPER_ORIENTATION', 'Orientasi kertas struk', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'portrait', NULL, NULL, NULL, NULL, '2022-03-12 20:13:38', '2022-05-25 21:35:38');
---------------------------------------------------------------------------
INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (69,'KEUANGAN','WA_NOTIF_BALANCE','Notifikasi Tabungan','boolean',NULL,0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-07 00:17:12',NULL);
UPDATE `settings` SET `name` = 'Notifikasi Tagihan' WHERE (`id` = '62');
select * from settings where id = 62;
---------------------------------------------------------------------------
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (132,98,'UNPAID_BUY','Piutang Toko','/dashboard/store-unpaid-buy',NULL,'shopping_basket',1,1,'2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (562,132,'CREATE','Baru','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (563,132,'EDIT','Ubah','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (564,132,'DELETE','Hapus','2022-09-24 20:49:59',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (565,132,'READ_ALL','Semua Data','2022-09-24 20:49:59',NULL);
---------------------------------------------------------------------------
UPDATE transactions t
JOIN bill_transaction bt ON t.id = bt.transaction_id
JOIN bills b ON bt.bill_id = b.id
SET t.new_student_id = b.new_student_id
WHERE t.new_student_id IS NULL
  AND b.new_student_id IS NOT NULL;
---------------------------------------------------------------------------
UPDATE `settings` SET `code` = 'BILLING_DATE_1', `name` = 'Tanggal penagihan 1' WHERE (`id` = '33');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(70, 'KEUANGAN', 'BILLING_DATE_2', 'Tanggal penagihan 2', 'integer', 0, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '2022-05-22 20:03:45', '2022-05-25 21:35:28');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(71, 'KEUANGAN', 'BILLING_DATE_3', 'Tanggal penagihan 3', 'integer', 0, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '2022-05-22 20:03:45', '2022-05-25 21:35:28');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(72, 'KEUANGAN', 'BILLING_DATE_4', 'Tanggal penagihan 4', 'integer', 0, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '2022-05-22 20:03:45', '2022-05-25 21:35:28');
---------------------------------------------------------------------------
UPDATE `settings` SET `code` = 'BILL_REMINDER_MESSAGE_1', `name` = 'Pesan penagihan 1' WHERE (`id` = '56');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(73, 'KEUANGAN', 'BILL_REMINDER_MESSAGE_2', 'Pesan penagihan 2', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Assalamualaikum warohmatullohi wabarokatuh,<br> kepada YTH orang tua *#siswa#*,<br> mohon segera lakukan pembayaran <br> *#tagihan#* <br> sebesar *Rp#nominal#*.<br> Terimakasih atas perhatiannya, wassalamualaikum warohmatullohi wabarokatuh.<br> *#pengirim#*', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(74, 'KEUANGAN', 'BILL_REMINDER_MESSAGE_3', 'Pesan penagihan 3', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Assalamualaikum warohmatullohi wabarokatuh,<br> kepada YTH orang tua *#siswa#*,<br> mohon segera lakukan pembayaran <br> *#tagihan#* <br> sebesar *Rp#nominal#*.<br> Terimakasih atas perhatiannya, wassalamualaikum warohmatullohi wabarokatuh.<br> *#pengirim#*', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(75, 'KEUANGAN', 'BILL_REMINDER_MESSAGE_4', 'Pesan penagihan 4', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Assalamualaikum warohmatullohi wabarokatuh,<br> kepada YTH orang tua *#siswa#*,<br> mohon segera lakukan pembayaran <br> *#tagihan#* <br> sebesar *Rp#nominal#*.<br> Terimakasih atas perhatiannya, wassalamualaikum warohmatullohi wabarokatuh.<br> *#pengirim#*', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
ALTER TABLE parents
ADD COLUMN isAlive tinyint(4) DEFAULT 1;
----------------------------------------------------------------------------
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(76, 'GENERAL', 'SCHEDULER_BILLING', 'Penagihan otomatis', 'boolean',0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:54:04',NULL);
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(77, 'GENERAL', 'SCHEDULER_PAY_LIMIT', 'Batas jajan otomatis', 'boolean',0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:54:04',NULL);
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(78, 'GENERAL', 'SCHEDULER_ATTENDANCE', 'Cek kehadiran otomatis', 'boolean',0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:54:04',NULL);
----------------------------------------------------------------------------
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(79, 'PPDB', 'PPDB_REGISTER_MESSAGE', 'Pesan pendaftaran', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Assalamualaikum #name#, selamat anda telah berhasil mendaftar. silahkan klik link berikut untuk aktivasi akun #link#', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
INSERT INTO `links` (`name`,`code`,`group`,`url`,`isPublic`,`isNewTab`) VALUES ('Dokumentasi ZIAD','ZIAD_DOC',null,'https://ziad-manual-pages.vercel.app',1,1);
----------------------------------------------------------------------------
UPDATE `settings` SET `code` = 'ATTENDANCE_ONLINE' WHERE (`id` = '7');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(80, 'ATTENDANCE', 'PERMISSION_ONLINE', 'Izin online', 'boolean', 0, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-09 06:49:03', '2022-05-25 21:32:09');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(81, 'GENERAL', 'APPLICATION_NAME_FULL', 'Nama Aplikasi', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'ZIAD - School management system', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`id`, `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES(82, 'GENERAL', 'APPLICATION_NAME_SHORT', 'Judul Aplikasi', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'ZIAD', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
INSERT INTO `parameters` (`id`,`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES (41,'student_group','TAHFIDZ','TAHFIDZ','TAHFIDZ',1,NULL,NULL,0,1,'2023-07-08 21:18:47',NULL);
----------------------------------------------------------------------------
INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (83,'KEUANGAN','TOPUP_BALANCE_MESSAGE','Pesan isi saldo','string',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'Selamat, pengisian saldo #tipe_tabungan# ananda #siswa# sebesar #nominal# berhasil. Silahkan tekan angka saldo di aplikasi untuk melihat saldo terbaru',NULL,NULL,NULL,NULL,'2023-07-12 10:42:55',NULL);
INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (84,'GENERAL','RESET_PASSWORD_MESSAGE','Pesan reset password','string',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'Permintaan reset password diterima, silahkan klik link berikut untuk reset password #link#',NULL,NULL,NULL,NULL,'2023-07-12 10:42:55',NULL);
----------------------------------------------------------------------------
INSERT INTO `parameters` (`id`,`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES (42,'monthly_tahfidz_score','R','Rosyib','Rosyib',1,NULL,NULL,0,1,'2023-07-14 09:49:55',NULL);
INSERT INTO `parameters` (`id`,`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES (43,'monthly_tahfidz_score','MB','Maqbul','Maqbul',2,NULL,NULL,0,1,'2023-07-14 09:49:55',NULL);
INSERT INTO `parameters` (`id`,`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES (44,'monthly_tahfidz_score','J','Jayyid','Jayyid',3,NULL,NULL,0,1,'2023-07-14 09:49:55',NULL);
INSERT INTO `parameters` (`id`,`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES (45,'monthly_tahfidz_score','JJ','Jayyid Jiddan','Jayyid Jiddan',4,NULL,NULL,0,1,'2023-07-14 09:49:55',NULL);
INSERT INTO `parameters` (`id`,`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES (46,'monthly_tahfidz_score','MT','Mumtaz','Mumtaz',5,NULL,NULL,0,1,'2023-07-14 09:49:55',NULL);
----------------------------------------------------------------------------
INSERT INTO `settings` (`id`,`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES (85,'KEUANGAN','WA_NOTIF_WITHDRAWAL','Notifikasi Tarik Tunai','boolean',NULL,0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-07-15 09:42:10',NULL);
----------------------------------------------------------------------------
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('semester','GASAL','GASAL','GASAL',1,NULL,NULL,0,1,'2023-07-26 15:09:35','2023-07-26 15:10:48');
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('semester','GENAP','GENAP','GENAP',2,NULL,NULL,0,1,'2023-07-26 15:09:52',NULL);
----------------------------------------------------------------------------
/* terminal command */
composer dump-autoload
----------------------------------------------------------------------------
/* terminal command */
composer require doctrine/dbal

INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('active_day','MONDAY','Senin','senin',1,NULL,NULL,0,1,'2023-08-11 17:50:51',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('active_day','TUESDAY','Selasa','selasa',2,NULL,NULL,0,1,'2023-08-11 17:51:07',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('active_day','WEDNESDAY','Rabu','rabu',3,NULL,NULL,0,1,'2023-08-11 17:51:41',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('active_day','THURSDAY','Kamis','kamis',4,NULL,NULL,0,1,'2023-08-11 17:51:55',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('active_day','FRIDAY','Jumat','jumat',5,NULL,NULL,0,1,'2023-08-11 17:52:16',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('active_day','SATURDAY','Sabtu','sabtu',6,NULL,NULL,0,0,'2023-08-11 17:52:39',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('active_day','SUNDAY','Minggu','minggu',0,NULL,NULL,0,0,'2023-08-11 17:52:58',NULL);
----------------------------------------------------------------------------
UPDATE attendances SET day_value = DAYOFWEEK(attendance_date) - 1
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','STUDENT_STARTING_POINT','Poin awal siswa','integer',NULL,0,0,NULL,NULL,NULL,100,NULL,NULL,NULL,NULL,NULL,NULL,'2023-08-21 13:49:45',NULL);
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','STUDENT_POINT_STATUS','Status poin siswa','boolean',NULL,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-08-21 14:52:46',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','PERKELAHIAN','Perkelahian','Perkelahian',1,NULL,NULL,0,1,'2023-08-21 14:38:25',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','PENCURIAN','Pencurian','Pencurian',2,NULL,NULL,0,1,'2023-08-21 14:38:44',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','PERUSAKAN','Perusakan','Perusakan',3,NULL,NULL,0,1,'2023-08-21 14:39:06',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','BOLOS','Bolos','Bolos',4,NULL,NULL,0,1,'2023-08-21 14:39:21',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','TAWURAN','Tawuran','Tawuran',5,NULL,NULL,0,1,'2023-08-21 14:39:39',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','ASUSILA','Asusila','Asusila',6,NULL,NULL,0,1,'2023-08-21 14:39:53',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','NARKOBA','Narkoba','Narkoba',7,NULL,NULL,0,1,'2023-08-21 14:40:10',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','VANDALISME','Vandalisme','Vandalisme',8,NULL,NULL,0,1,'2023-08-21 14:40:31',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','KELUAR','Keluar tanpa izin','Keluar tanpa izin',9,NULL,NULL,0,1,'2023-08-21 14:41:34',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','MEROKOK','Merokok','Merokok',10,NULL,NULL,0,1,'2023-08-21 14:41:47',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','HP','Menggunakan HP','Menggunakan HP',11,NULL,NULL,0,1,'2023-08-21 14:42:00',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','BARANG','Barang terlarang','Barang terlarang',12,NULL,NULL,0,1,'2023-08-21 14:42:36',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('violation_type','BERJAMAAH','Tidak solat berjamaah','Tidak solat berjamaah',13,NULL,NULL,0,1,'2023-08-21 14:43:03',NULL,0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('achievement_type','LOMBA_ANTAR_SEKOLAH','Lomba antar sekolah','Lomba antar sekolah',3,NULL,NULL,0,1,'2023-08-22 09:49:21','2023-08-22 15:50:53',0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('achievement_type','LOMBA_NASIONAL','Lomba Nasional','Lomba Nasional',4,NULL,NULL,0,1,'2023-08-22 09:49:45','2023-08-22 15:51:03',0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('achievement_type','PTN','Diterima PTN','Diterima PTN',5,NULL,NULL,0,1,'2023-08-22 09:50:21','2023-08-22 15:51:09',0);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`,`number_value`) VALUES ('achievement_type','TAHFIDZ','Tahfidz','Tahfidz',6,NULL,NULL,0,1,'2023-08-22 09:51:02','2023-08-22 15:51:14',0);
UPDATE `parameters` SET `code` = 'JUARA_KELAS', `number_value` = '0' WHERE id = 25;
UPDATE `parameters` SET `code` = 'LOMBA_SEKOLAH', `name` = 'Lomba internal', `number_value` = '0' WHERE id = 24;
----------------------------------------------------------------------------
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (133,92,'INVENTORY_LENDING','Peminjaman Inventaris','/dashboard/inventory-lending','/','work_history',1,1,'2023-08-24 14:20:08','2023-08-24 14:22:09');
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (566,133,'CREATE','Baru','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (567,133,'EDIT','Ubah','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (568,133,'DELETE','Hapus','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (569,133,'READ_ALL','Semua Data','2023-08-24 14:20:08',NULL);
----------------------------------------------------------------------------
UPDATE `parameters` SET `number_value` = 1 WHERE `group` = 'student_group' and code='TAHFIDZ';
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('SCHEDULER', 'SCHEDULER_SISA_JAJAN_HOUR', 'Jam Sisa Jajan Otomatis', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, '01:00', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('SCHEDULER', 'SCHEDULER_BILLING_HOUR', 'Jam Penagihan Otomatis', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, '02:00', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('SCHEDULER', 'SCHEDULER_AUTODEBET_HOUR', 'Jam pengaturan Autodebet', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, '04:00', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('SCHEDULER', 'SCHEDULER_ATTENDANCE_HOUR', 'Jam pengaturan Kehadiran', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, '22:00', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
/*execute after php artisan migrate*/
UPDATE bills
JOIN students ON bills.student_id = students.id
SET bills.sex_type_value = students.sex_type_value;

UPDATE bills
JOIN new_students ON bills.new_student_id = new_students.id
SET bills.sex_type_value = new_students.sex_type_value;
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('MOBILE', 'MOBILE_MENU_BILLS', 'Menu Tagihan', 'boolean', 0, 0, NULL, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('MOBILE', 'MOBILE_MENU_BALANCE', 'Menu Tabungan', 'boolean', 0, 0, NULL, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('MOBILE', 'MOBILE_MENU_DONATION', 'Menu Donasi', 'boolean', 0, 0, NULL, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('MOBILE', 'MOBILE_MENU_STUDENT_GROUP', 'Menu Grup Siswa', 'boolean', 0, 0, NULL, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('MOBILE', 'MOBILE_MENU_PERMISSION', 'Menu Izin', 'boolean', 0, 0, NULL, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `menus` (`id`,`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (134,98,'PRODUCT_STOCK_LOG','Catatan stok','/dashboard/product-stock-log','/','shelves',1,1,'2023-08-24 14:20:08','2023-08-24 14:22:09');
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (570,134,'CREATE','Baru','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (571,134,'EDIT','Ubah','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (572,134,'DELETE','Hapus','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (573,134,'READ_ALL','Semua Data','2023-08-24 14:20:08',NULL);
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('KEUANGAN', 'BALANCE_WITHDRAWAL_CARD', 'Tarik saldo wajib kartu', 'boolean', 1, 0, NULL, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
update bank_accounts set student=1;
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('GENERAL', 'PERMISSION_REQUEST_MSG', 'Pesan Pengajuan Izin', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, '#nama# mengajukan izin karena #keterangan#, mohon dapat melakukan persetujuan di #link#', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (574,47,'PIN','PIN Transaksi','2022-04-07 06:44:38',NULL);
INSERT INTO `role_action` (`role_id`,`action_id`) VALUES (1,574);
INSERT INTO `role_action` (`role_id`,`action_id`) VALUES (7,574);
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('SCHEDULER', 'SCHEDULER_TOPUP_HOUR', 'Jam pengingat isi saldo', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, '18:00', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('KEUANGAN','LIMIT_BALANCE_TO_NOTIFY','Saldo minimal kirim notifikasi','integer',NULL,0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:55:34',NULL);
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('KEUANGAN', 'TOPUP_REMINDER_MESSAGE', 'Pesan pengingat saldo minimal', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Assalamualaikum, saldo ananda #nama# saat ini Rp#nominal#, mohon dapat mengisi saldo kembali. pesan ini dikirim secara otomatis oleh sistem #sistem#', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
UPDATE `quran_surats` SET `name` = 'Ar-Rum' WHERE `quran_surats`.`id` = 30;
----------------------------------------------------------------------------
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (575, 5,'NEW_STUDENT_STATISTIC','Statistik Siswa Baru','2023-10-05 05:50:07',NULL);
INSERT INTO `role_action` (`role_id`,`action_id`) VALUES (1,575);
----------------------------------------------------------------------------
INSERT INTO psb_flow_bill_type (psb_flow_id, bill_type_id)
SELECT p.id AS psb_flow_id, p.bill_type_id
FROM psb_flows p
where p.bill_type_id is not null;

update psb_flows set bill_type_id = null;

----------------------------------------------------------------------------
mkdir public/receipts
sudo chown -R www-data:www-data public
composer install
----------------------------------------------------------------------------
DELETE FROM `transaction_product`
WHERE transaction_id NOT IN (SELECT id FROM `transactions`);
----------------------------------------------------------------------------
INSERT INTO `actions` (`id`,`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (576, 5,'USER_STATISTIC','Statistik Pengguna','2023-10-05 05:50:07',NULL);
INSERT INTO `role_action` (`role_id`,`action_id`) VALUES (1,576);
----------------------------------------------------------------------------
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_NAME','Nama Siswa Baru','Nama Siswa Baru',1,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_JK','Jenis Kelamin','Jenis Kelamin',2,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_NIK','NIK Anak','NIK Anak',3,NULL,NULL,0,1,'2023-07-08 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_AKTA','Nomor Akta Lahir','Nomor Akta Lahir',4,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_PHONE','Nomor Handphone','Nomor Handphone',5,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_EMAIL','Email','Email',6,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_SKHUN','Nomor SKHUN','Nomor SKHUN',7,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_UN','Nomor Peserta Ujian Nasional','Nomor Peserta Ujian Nasional',8,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_IJAZAH','Nomor Ijazah Terakhir','Nomor Ijazah Terakhir',9,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_HEIGHT','Tinggi Badan (cm)','Tinggi Badan (cm)',10,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_WEIGHT','Berat Badang (kg)','Berat Badang (kg)',11,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_HEAD','Lingkar Kepala (cm)','Lingkar Kepala (cm)',12,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_SIBLINGS','Jumlah Saudara Kandung','Jumlah Saudara Kandung',13,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_PROVINCE','Provinsi','Provinsi',14,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_KOTA','Kota/Kabupaten','Kota/Kabupaten',15,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_KECAMATAN','Kecamatan','Kecamatan',16,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_DESA','Desa / Kelurahan','Desa / Kelurahan',17,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_RW','RW','RW',18,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_RT','RT','RT',19,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_POSTAL','Kode Pos','Kode Pos',20,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_ADDRESS','Alamat','Alamat',21,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_DISTANCE','Jarak dari rumah (km)','Jarak dari rumah (km)',22,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_TIME','Lama perjalanan ke Sekolah','Lama Perjalanan ke Sekolah',23,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_BIRTH_ORDER','Anak ke','Anak ke',24,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_BIRTH_PLACE','Kota Kelahiran','Kota Kelahiran',25,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_BIRTH_DATE','Tanggal Lahir','Tanggal Lahir',26,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_RELIGION','Agama','Agama',27,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_NATIONALITY','Warga Negara','Warga Negara',28,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_SCHOOL','Sekolah','Sekolah',29,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_CLASS','Kelas','Kelas',30,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_JURUSAN','Jurusan','Jurusan',31,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_ASAL_SEKOLAH','Sekolah Asal','Sekolah Asal',32,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_NPSN_ASAL','NPSN Sekolah Asal','NPSN Sekolah Asal',33,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_NISN','Nomor Induk Siswa Nasional','Nomor Induk Siswa Nasional',34,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_NO_KK','No Kartu Keluarga','No Kartu Keluarga',35,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_HOBBY','Hobi','Hobi',36,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_CITA_CITA','Cita-Cita','Cita-Cita',37,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_MED_HISTORY','Riwayat Penyakit','Riwayat Penyakit',38,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_ACHIEVEMENT','Prestasi Sebelumnya','Prestasi Sebelumnya',39,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NS_IS_POOR','Kurang Mampu','Kurang Mampu',40,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_NAME','Nama Ayah','Nama Ayah',41,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_STATUS','Status Ayah','Status Ayah',42,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_PHONE','Nomor Handphone','Nomor Handphone',43,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_KTP','KTP Ayah','KTP Ayah',44,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_BIRTH_DATE','Tanggal Lahir Ayah','Tanggal Lahir Ayah',45,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_BIRTH_PLACE','Kota Kelahiran Ayah','Kota Kelahiran Ayah',46,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_EDUCATION','Pendidikan Ayah','Pendidikan Ayah',47,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_JOB','Pekerjaan Ayah','Pekerjaan Ayah',48,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_COMPANY','Nama Usaha / Lembaga','Nama Usaha / Lembaga',49,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_POSITION','Posisi/Jabatan Ayah','Posisi/Jabatan  Ayah',50,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_MONTHLY_INCOME','Penghasilan Bulanan Ayah','Penghasilan Bulanan Ayah',51,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NF_JOB_ADDRESS','Penghasilan Bulanan Ayah','Penghasilan Bulanan Ayah',52,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_NAME','Nama Ibu','Nama Ibu',53,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_STATUS','Status Ibu','Status Ibu',54,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_PHONE','Nomor Handphone','Nomor Handphone',55,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_KTP','KTP Ibu','KTP Ibu',56,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_BIRTH_DATE','Tanggal Lahir Ibu','Tanggal Lahir Ibu',57,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_BIRTH_PLACE','Kota Kelahiran Ibu','Kota Kelahiran Ibu',58,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_EDUCATION','Pendidikan Ibu','Pendidikan Ibu',59,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_JOB','Pekerjaan Ibu','Pekerjaan Ibu',60,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_COMPANY','Nama Usaha / Lembaga','Nama Usaha / Lembaga',61,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_POSITION','Posisi/Jabatan Ibu','Posisi/Jabatan  Ibu',62,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_MONTHLY_INCOME','Penghasilan Bulanan Ibu','Penghasilan Bulanan Ibu',63,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NM_JOB_ADDRESS','Alamat Pekerjaan Ibu','Alamat Pekerjaan Ibu',64,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_EXIST','Ada Wali','Ada Wali',65,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_TYPE','Tipe Wali','Tipe Wali',66,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_JK','Jenis Kelamin','Jenis Kelamin',67,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_NAME','Nama Wali','Nama Wali',68,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_STATUS','Status Wali','Status Wali',69,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_PHONE','Nomor Handphone','Nomor Handphone',70,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_KTP','KTP Wali','KTP Wali',71,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_BIRTH_DATE','Tanggal Lahir Wali','Tanggal Lahir Wali',72,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_BIRTH_PLACE','Kota Kelahiran Wali','Kota Kelahiran Wali',73,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_EDUCATION','Pendidikan Wali','Pendidikan Wali',74,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_JOB','Pekerjaan Wali','Pekerjaan Wali',75,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_COMPANY','Nama Usaha / Lembaga','Nama Usaha / Lembaga',76,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_POSITION','Posisi/Jabatan Wali','Posisi/Jabatan  Wali',77,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_JOB_ADDRESS','Alamat Pekerjaan Wali','Alamat Pekerjaan Wali',78,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('psb_form','NW_MONTHLY_INCOME','Penghasilan Bulanan Wali','Penghasilan Bulanan Wali',79,NULL,NULL,0,1,'2023-10-19 21:18:47',NULL);
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('KEUANGAN', 'BILL_TRANSACTION_SIGN', 'TTD kuitansi tagihan', 'boolean', 0, 0, NULL, NULL, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` ( `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('GENERAL', 'FOUNDATION_CITY', 'Kota Yayasan', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Tangerang', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
INSERT INTO `settings` ( `group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('KEUANGAN', 'BILL_RECEIPT_NOTE', 'Catatan kuitansi', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, 'Setiap transaksi pembayaran, akan diberikan pesan whatsapp secara otomatis oleh sistem #application_name#. Jika Bapak & Ibu belum mendapatkan pesan tersebut, dipersilahkan segera menghubungi admin.', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('KEUANGAN', 'PRINT_OUTSTANDING', 'Print info tunggakan', 'boolean', 0, 0, NULL, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
UPDATE schedules
JOIN jam_pelajarans ON
    jam_pelajarans.school_id = schedules.school_id
    AND jam_pelajarans.kelas_id = schedules.kelas_id
    AND jam_pelajarans.day_value = schedules.day_value
    AND jam_pelajarans.jam_ke = schedules.jam_ke
SET schedules.jam_id = jam_pelajarans.id
WHERE schedules.schedule_type_value = 2;

UPDATE `settings` SET `code` = 'PERMISSION_REQUEST_MSG', `name`='Pesan Pengajuan Izin' WHERE (`code` = 'PERMISSION_APRVL_MSG');

INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('GENERAL', 'PERMISSION_APRVL_MSG', 'Pesan Persetujuan Izin', 'string', 0, 0, NULL, NULL, NULL, NULL, NULL, '*Assalamualaikum, Wr.Wb*<br>Diinformasikan bahwa pengajuan izin di sistem #application# atas nama #nama# telah #status# <br>*Wassalamualaikum. Wr.Wb*', NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
SELECT *
FROM employees
JOIN users ON users.detail_id = employees.id
WHERE users.user_type_value = 1
AND employees.user_id IS NULL;

UPDATE employees
JOIN users ON users.detail_id = employees.id
SET employees.user_id = users.id
WHERE users.user_type_value = 1
AND employees.user_id IS NULL;
----------------------------------------------------------------------------
UPDATE transactions
JOIN students ON transactions.student_id = students.id
SET transactions.sex_type_value = students.sex_type_value;
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('KEUANGAN','TRX_DELETE_APPROVER','Persetujuan hapus transaksi','integer','employees',0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2023-11-27 10:45:13','2023-11-27 15:32:51');
----------------------------------------------------------------------------
/*update student with user_id null*/
UPDATE students
JOIN users ON students.id = users.detail_id and users.detail_type = 'App\\Models\\Student'
SET students.user_id = users.id;
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('ATTENDANCE','STUDENT_PERMISSION_APPROVER','Persetujuan izin siswa','integer','employees',0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2023-11-27 10:45:13','2023-11-27 15:32:51');
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('ATTENDANCE','EMPLOYEE_PERMISSION_APPROVER','Persetujuan izin pegawai','integer','employees',0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2023-11-27 10:45:13','2023-11-27 15:32:51');
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('KEUANGAN','MANDATORY_BALANCE_APPROVER','Persetujuan pencairan tabungan wajib','integer','employees',0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2023-11-27 10:45:13','2023-11-27 15:32:51');
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES('KEUANGAN', 'MANDATORY_BALANCE', 'Tabungan wajib', 'boolean', 0, 0, NULL, NULL, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-11 00:42:43', '2022-06-11 00:49:43');
----------------------------------------------------------------------------
INSERT INTO parameters (`group`, `code`, `name`, `description`, `value`, `number_value`, `owner_user_id`, `owner_role_id`, `isRestricted`, `isActive`, `created_at`, `updated_at`) VALUES ('letter_template', 'AGENDA_BASE_TEMPLATE', 'agendaBase', 'For agenda PDF generated letter base template', 0, 0, NULL, NULL, 0, 1, '2023-12-25 01:43:18', '2023-12-25 01:43:18');
INSERT INTO parameters (`group`, `code`, `name`, `description`, `value`, `number_value`, `owner_user_id`, `owner_role_id`, `isRestricted`, `isActive`, `created_at`, `updated_at`) VALUES ('participant_level', 'POSITION', 'POSITION', 'POSITION', 8, 0, NULL, NULL, 0, 1, '2023-12-28 01:43:18', '2023-12-28 01:43:18');
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','SCHEDULER_STUDENT_ATTENDANCE','Cek kehadiran siswa otomatis','boolean',NULL,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:55:34',NULL);
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','SCHEDULER_EMPLOYEE_ATTENDANCE','Cek kehadiran pegawai otomatis','boolean',NULL,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-20 03:55:34',NULL);
----------------------------------------------------------------------------
INSERT INTO `coas` (`name`, `code`, `group`, `description`, `bank_account_id`, `school_id`, `store_id`) VALUES
('Modal pemilik', '3000', 'MODAL', NULL, NULL, NULL, NULL);

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('KEUANGAN','WA_NOTIF_BILL_PAY','Notifikasi Pembayaran Tagihan','boolean',NULL,0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-11-07 00:17:12',NULL);

----------------------------------------------------------------------------
insert into settings (isRestricted, isSelection, `group`,type, booleanValue, integerValue, code, name )
select 0, 0, 'PPDB', 'boolean', 1, id, code, name from schools;

----------------------------------------------------------------------------
INSERT INTO `actions` (`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (72,'APPROVAL','Persetujuan','2024-06-24 11:55:07',NULL);

----------------------------------------------------------------------------
ALTER TABLE parallels MODIFY COLUMN wali_kelas_id BIGINT NULL;

----------------------------------------------------------------------------
INSERT INTO `menus` (`parent_id`, `code`, `name`, `webPath`, `mobileRoute`, `icon`, `isActive`, `order`, `created_at`, `updated_at`) VALUES(NULL, 'LOG', 'Log', '/dashboard/log', NULL, 'settings', 1, 1, '2024-08-09 19:30:54', NULL);

----------------------------------------------------------------------------
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('parent_category','DEWAN_GURU','Dewan Guru','Dewan Guru',1,NULL,NULL,1,1,'2022-09-20 07:08:35','2022-09-20 07:25:54');
INSERT INTO `parameters` (`group`,`code`,`name`,`description`,`value`,`owner_user_id`,`owner_role_id`,`isRestricted`,`isActive`,`created_at`,`updated_at`) VALUES ('parent_category','DEWAN_PENDIRI','Dewan Pendiri','Dewan Pendiri',2,NULL,NULL,1,1,'2022-09-20 07:08:35','2022-09-20 07:25:54');

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('KEUANGAN','PAY_BILL_WITH_BALANCE', 'Bayar Tagihan via Saldo','boolean',NULL,0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-09-12 00:17:12',NULL);

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('KEUANGAN','FIX_BALANCE_BY_SCHEDULER', 'Perbaiki saldo otomatis','boolean',NULL,0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-09-12 00:17:12',NULL);

----------------------------------------------------------------------------
 INSERT INTO `menus` (`parent_id`, `code`, `name`, `webPath`, `mobileRoute`, `icon`, `isActive`, `order`, `created_at`, `updated_at`) VALUES(97, 'LAPORAN_NILAI', 'Laporan Nilai', '/dashboard/score-report', NULL, 'assignment_turned_in', 1, 1, '2024-12-09 19:30:54', NULL);

INSERT INTO `actions` (`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (139,'CREATE','Baru','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (139,'EDIT','Ubah','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (139,'DELETE','Hapus','2023-08-24 14:20:08',NULL);
INSERT INTO `actions` (`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (139,'READ_ALL','Semua Data','2023-08-24 14:20:08',NULL);

----------------------------------------------------------------------------
INSERT INTO parameters (`group`, code, name, description, value, owner_user_id, owner_role_id, created_at, updated_at, number_value)
VALUES ('score_report_type', 'LAPORAN_SEMESTER_GANJIL', 'Laporan Semester Ganjil', 'Laporan nilai semester ganjil', 1, null, null, now(), now(), null),
       ('score_report_type', 'LAPORAN_SEMESTER_GENAP', 'Laporan Semester Genap', 'Laporan nilai semester genap', 2, null, null, now(), now(), null);

----------------------------------------------------------------------------
INSERT INTO `menus` (`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (99,'ATTENDANCE_EVENT','Absen Kegiatan','/dashboard/attendance-event-by-teacher','/','co_present',1,1,'2023-08-24 14:20:08','2023-08-24 14:22:09');

INSERT INTO `actions` (`menu_id`, `code`, `name`, `created_at`, `updated_at`)
VALUES
  ((SELECT id FROM `menus` WHERE `code` = 'ATTENDANCE_EVENT' ORDER BY `id` DESC LIMIT 1), 'CREATE', 'Baru', '2023-08-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'ATTENDANCE_EVENT' ORDER BY `id` DESC LIMIT 1), 'EDIT', 'Ubah', '2023-08-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'ATTENDANCE_EVENT' ORDER BY `id` DESC LIMIT 1), 'DELETE', 'Hapus', '2023-08-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'ATTENDANCE_EVENT' ORDER BY `id` DESC LIMIT 1), 'READ_ALL', 'Semua Data', '2023-08-24 14:20:08', NULL);

INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('SCHEDULER','STATUS_SCHEDULER_MONTHLY_ATTENDANCE_REPORT', 'Entry Laporan Kehadiran Santri Per Bulan','boolean',NULL,1,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-01-24 00:17:12',NULL);
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('SCHEDULER','SCHEDULER_MONTHLY_ATTENDANCE_REPORT', 'Jam Entry Laporan Kehadiran Santri Per Bulan','string',NULL,1,0,NULL,NULL,NULL,NULL,NULL, '23:00',NULL,NULL,NULL,NULL,'2025-01-24 00:17:12',NULL);
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','WA_REPORT_MONTHLY_ATTENDANCE_VIOLATION_POINT_MSG', 'Pesan Laporan Kehadiran Santri Per Bulan','string',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'Assalamualaikum berikut adalah laporan bulanan santri #name#:<br> - Total Alpa: #total_alpa#<br> - Total Hadir: #total_hadir#<br> - Total Izin: #total_izin#<br> - Total Poin Pelanggaran: #total_violation_point#<br> Harap perhatikan poin pelanggaranmu, ya!',NULL,NULL,NULL,NULL,'2025-01-24 00:17:12',NULL);
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('SCHEDULER','STATUS_SCHEDULER_SEND_WA_ATTENDANCE_VIOLATION_PTS', 'Kirim Laporan Kehadiran Santri Per Bulan','boolean',NULL,0,0,NULL,NULL,0,NULL,NULL, NULL,NULL,NULL,NULL,NULL,'2025-01-24 00:17:12',NULL);
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('SCHEDULER','SCHEDULER_SEND_WA_ATTENDANCE_VIOLATION_PTS', 'Jam Kirim Laporan Kehadiran per Bulan','string',NULL,0,0,NULL,NULL,NULL,NULL,NULL, '05:00',NULL,NULL,NULL,NULL,'2025-01-24 00:17:12',NULL);

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','STATUS_SCHEDULER_EVENT_ATTENDANCE', 'Cek Kehadiran Kegiatan Siswa Otomatis','boolean',NULL,0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-07 00:17:12',NULL);
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('SCHEDULER','SCHEDULER_EVENT_ATTENDANCE', 'Jam Kehadiran Kegiatan Siswa Otomatis','string',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'03:00',NULL,NULL,NULL,NULL,'2025-02-07 00:17:12',NULL);

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','STATUS_SCHEDULER_EXTRA_ATTENDANCE', 'Cek Kehadiran Ekstrakulikuler Siswa Otomatis','boolean',NULL,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-02-07 00:17:12',NULL);
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('SCHEDULER','SCHEDULER_EXTRA_ATTENDANCE', 'Jam Kehadiran Ekstrakulikuler Siswa Otomatis','string',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'03:00',NULL,NULL,NULL,NULL,'2025-02-14 00:17:12',NULL);

----------------------------------------------------------------------------
INSERT INTO `menus` (`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (97,'SCORE_EXTRACURRICULAR','Nilai Ekstrakulikuler','/dashboard/score-extracurricular','/','star_rate',1,1,'2025-02-24 14:20:08','2023-08-24 14:22:09');
INSERT INTO `actions` (`menu_id`, `code`, `name`, `created_at`, `updated_at`)
VALUES
  ((SELECT id FROM `menus` WHERE `code` = 'SCORE_EXTRACURRICULAR' ORDER BY `id` DESC LIMIT 1), 'CREATE', 'Baru', '2023-08-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'SCORE_EXTRACURRICULAR' ORDER BY `id` DESC LIMIT 1), 'EDIT', 'Ubah', '2023-08-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'SCORE_EXTRACURRICULAR' ORDER BY `id` DESC LIMIT 1), 'DELETE', 'Hapus', '2023-08-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'SCORE_EXTRACURRICULAR' ORDER BY `id` DESC LIMIT 1), 'READ_ALL', 'Semua Data', '2023-08-24 14:20:08', NULL);


INSERT INTO `menus` (`parent_id`,`code`,`name`,`webPath`,`mobileRoute`,`icon`,`isActive`,`order`,`created_at`,`updated_at`) VALUES (99,'ATTENDANCE_EXTRA','Absen Ekstrakulikuler','/dashboard/attendance-extracurricular','/','co_present',1,1,'2025-02-24 14:20:08','2025-08-24 14:22:09');
INSERT INTO `actions` (`menu_id`, `code`, `name`, `created_at`, `updated_at`)
VALUES
  ((SELECT id FROM `menus` WHERE `code` = 'ATTENDANCE_EXTRA' ORDER BY `id` DESC LIMIT 1), 'CREATE', 'Baru', '2025-02-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'ATTENDANCE_EXTRA' ORDER BY `id` DESC LIMIT 1), 'EDIT', 'Ubah', '2025-02-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'ATTENDANCE_EXTRA' ORDER BY `id` DESC LIMIT 1), 'DELETE', 'Hapus', '2025-02-24 14:20:08', NULL),
  ((SELECT id FROM `menus` WHERE `code` = 'ATTENDANCE_EXTRA' ORDER BY `id` DESC LIMIT 1), 'READ_ALL', 'Semua Data', '2025-02-24 14:20:08', NULL);

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','VIOLATION_MESSAGE', 'PESAN PELANGGARAN SANTRI','string',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'*Assalamualaikum, Wr. Wb*<br><br> Kepada YTH orang tua/wali dari:<br><br> *#siswa#*<br><br> Kami informasikan bahwa siswa/i tersebut telah melakukan pelanggaran *#pelanggaran#* pada *#tanggal#* <br> Kami berharap Bapak/Ibu dapat memberikan arahan kepada ananda agar kejadian ini tidak terulang kembali. Terima kasih atas perhatian dan kerja samanya. Kami berharap ananda dapat lebih disiplin dalam menjalani kegiatan belajar di sekolah.<br><br> *Wassalamualaikum, Wr. Wb*<br> <br> Salam,<br> *GURU BK*',NULL,NULL,NULL,NULL,'2025-02-14 00:17:12',NULL);
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','USER_ID_BARCODE','Barcode pengguna','boolean',NULL,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-03-19 08:20:43','2025-03-19 09:04:17');
INSERT INTO `actions` (`menu_id`,`code`,`name`,`created_at`,`updated_at`) VALUES (1,'BARCODE','Set Default Barcode','2025-03-19 11:25:57',NULL);
composer require milon/barcode
----------------------------------------------------------------------------
INSERT INTO `settings` (`group`,`code`,`name`,`type`,`tableSource`,`isRestricted`,`isSelection`,`parameter_group`,`parameter_value`,`booleanValue`,`integerValue`,`decimalValue`,`stringValue`,`dateValue`,`dateTimeValue`,`timeValue`,`admin_employee_id`,`created_at`,`updated_at`) VALUES ('GENERAL','MSG_WARNING_BILL','Pesan Warning Tagihan','string',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'<br>*DIMOHON MELUNASI TAGIHAN SESUAI WAKTU YANG TELAH DITETAPKAN*<br>',NULL,NULL,NULL,NULL,'2025-03-19 08:20:43','2025-03-19 09:04:17');

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `tableSource`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES ('GENERAL', 'ONLY_CHARGE_ACTIVE_STUDENT', 'Hanya tagihkan ke siswa aktif', 'boolean', NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-06 09:00:00', '2025-05-06 09:00:00');

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `tableSource`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES ('GENERAL', 'STATUS_ALL_SCHEDULE', 'Filter Semua Absensi (Mobile)', 'boolean', NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-10 09:00:00', '2025-05-10 09:00:00');

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, `code`, `name`, `type`, `tableSource`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES ('ATTENDANCE', 'INTERVAL_DOUBLE_TAP', 'Interval Double Tap', 'integer', NULL, 0, 0, NULL, NULL, NULL, 60, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-10 09:00:00', '2025-05-10 09:00:00');

----------------------------------------------------------------------------
INSERT INTO `parameters` (`group`,`code`, `name`, `description`, `value`, `owner_user_id`, `owner_role_id`, `isRestricted`, `isActive`, `created_at`, `updated_at`) VALUES ( 'format_registration_number', 'FMT_REGNUM_DEFAULT', 'Format Nomor Registrasi Default (1)', 'Gabungan dari ID sekolah, tahun, bulan, tanggal, dan nomor urut pendaftar', 1, null, null, 0, 1, '2025-08-05 22:54:21', '2025-08-05 23:45:16');
INSERT INTO `parameters` (`group`,`code`, `name`, `description`, `value`, `owner_user_id`, `owner_role_id`, `isRestricted`, `isActive`, `created_at`, `updated_at`) VALUES ( 'format_registration_number', 'FMT_REGNUM_FULL', 'Format Nomor Registrasi Full (3)', 'Gabungan dari kode sekolah, tahun, bulan, tanggal, dan nomor urut pendaftar', 3, null, null, 0, 1, '2025-08-05 22:44:50', '2025-08-05 23:45:08');
INSERT INTO `parameters` (`group`,`code`, `name`, `description`, `value`, `owner_user_id`, `owner_role_id`, `isRestricted`, `isActive`, `created_at`, `updated_at`) VALUES ( 'format_registration_number', 'FMT_REGNUM_SIMPLE', 'Format Nomor Registrasi Simpel (2)', 'Kode sekolah + Tahun Ajaran + Nomor urut pendaftar', 2, null, null, 0, 1, '2025-08-05 22:38:08', '2025-08-05 23:44:58');
INSERT INTO `settings` (`group`, `code`, `name`, type, `tableSource`, `isRestricted`, `isSelection`, `parameter_group`, `parameter_value`, `booleanValue`, `integerValue`, `decimalValue`, `stringValue`, `dateValue`, `dateTimeValue`, `timeValue`, `admin_employee_id`, `created_at`, `updated_at`) VALUES ('PPDB', 'FMT_REGNUM', 'Format Nomor Registrasi', 'parameter', 'parameters', 0, 0, 'format_registration_number', 1, null, null, null, null, null, null, null, null, '2025-08-05 23:04:00', '2025-08-06 00:12:45');

----------------------------------------------------------------------------
INSERT INTO settings (`group`, code, name, type, tableSource, isRestricted, isSelection, parameter_group, parameter_value, booleanValue, integerValue, decimalValue, stringValue, dateValue, dateTimeValue, timeValue, admin_employee_id, created_at, updated_at) VALUES ('INPUT_FORM', 'NEW_STUDENT_REFERAL_SOURCE', 'Referensi Mendaftar - Siswa Baru', 'integer', null, 0, 0, null, null, null, 1, null, null, null, null, null, null, '2025-08-14 15:33:14', '2025-08-14 19:57:37');

INSERT INTO menus
    (id, parent_id, code, name, webPath, mobileRoute, icon, isActive, `order`, created_at, updated_at)
VALUES
    (142, 140, 'OPTIONAL_SERVICE', 'Layanan Pilihan', '/dashboard/optional-service', NULL, 'service', 1, 1, '2022-06-17 02:46:01', NULL),
    (141, 140, 'OPTIONAL_SERVICE_SUBS', 'Langganan', '/dashboard/optional-service-subscriber', NULL, 'service', 1, 1, '2022-06-17 02:46:01', NULL),
    (140, NULL, 'PARENT_OPTIONAL_SERVICE', 'Layanan Pilihan', NULL, NULL, 'service', 1, 1, '2022-06-17 02:46:01', NULL);

----------------------------------------------------------------------------

INSERT INTO `parameters` (`group`, code, name, description, value, owner_user_id, owner_role_id, isRestricted, isActive, created_at, updated_at, number_value) VALUES ('form_type', 'FORM_MANDATORY', 'Mandatory', 'Form mandatory', 3, null, null, 0, 1, '2025-08-28 08:52:30', null, null);
INSERT INTO `parameters` (`group`, code, name, description, value, owner_user_id, owner_role_id, isRestricted, isActive, created_at, updated_at, number_value) VALUES ('form_type', 'FORM_OPTIONAL', 'Optional', 'form optional', 2, null, null, 0, 1, '2025-08-28 08:51:20', null, null);
INSERT INTO `parameters` (`group`, code, name, description, value, owner_user_id, owner_role_id, isRestricted, isActive, created_at, updated_at, number_value) VALUES ('form_type', 'FORM_DISABLED', 'Disabled', 'disabled form', 1, null, null, 0, 1, '2025-08-28 08:40:17', '2025-08-28 08:53:41', null);

INSERT INTO `settings` (`group`, code, name, type, tableSource, isRestricted, isSelection, parameter_group, parameter_value, booleanValue, integerValue, decimalValue, stringValue, dateValue, dateTimeValue, timeValue, admin_employee_id, created_at, updated_at) VALUES ('INPUT_FORM', 'NEW_STUDENT_REFERAL_DESCRIPTION', 'Referensi Dari - Siswa Baru', 'parameter', null, 0, 0, 'form_type', 1, null, null, null, null, null, null, null, null, '2025-08-28 08:37:09', '2025-08-28 08:54:30');
INSERT INTO `settings` (`group`, code, name, type, tableSource, isRestricted, isSelection, parameter_group, parameter_value, booleanValue, integerValue, decimalValue, stringValue, dateValue, dateTimeValue, timeValue, admin_employee_id, created_at, updated_at) VALUES ('INPUT_FORM', 'NEW_STUDENT_REFERAL_SOURCE', 'Referensi Mendaftar - Siswa Baru', 'parameter', null, 0, 0, 'form_type', 1, null, null, null, null, null, null, null, null, '2025-08-14 15:33:14', '2025-08-28 08:54:41');

----------------------------------------------------------------------------
INSERT INTO `parameters`
(`group`, `code`, `name`, `description`, `value`, `owner_user_id`, `owner_role_id`, `isRestricted`, `isActive`, `created_at`, `updated_at`)
VALUES
('special_price_remark_options', 'REMARK_SAUDARA_KANDUNG', 'Saudara Kandung', 'Keterangan khusus: Saudara Kandung', 1, NULL, NULL, 0, 1, NOW(), NOW()),
('special_price_remark_options', 'REMARK_ALUMNI', 'Alumni', 'Keterangan khusus: Alumni', 2, NULL, NULL, 0, 1, NOW(), NOW()),
('special_price_remark_options', 'REMARK_PRESTASI', 'Prestasi', 'Keterangan khusus: Prestasi', 3, NULL, NULL, 0, 1, NOW(), NOW()),
('special_price_remark_options', 'REMARK_POTONGAN_LUNAS', 'Potongan Lunas', 'Keterangan khusus: Potongan Lunas', 4, NULL, NULL, 0, 1, NOW(), NOW()),
('special_price_remark_options', 'REMARK_ANAK_GURU', 'Potongan Anak Guru/Pegawai', 'Keterangan khusus: Potongan Anak Guru/Pegawai', 5, NULL, NULL, 0, 1, NOW(), NOW()),
('special_price_remark_options', 'REMARK_BEASISWA', 'Beasiswa', 'Keterangan khusus: Beasiswa', 6, NULL, NULL, 0, 1, NOW(), NOW()),
('special_price_remark_options', 'REMARK_DEWAN_PENDIRI', 'Dewan Pendiri', 'Keterangan khusus: Dewan Pendiri', 7, NULL, NULL, 0, 1, NOW(), NOW());

----------------------------------------------------------------------------
INSERT INTO `settings` (`group`, code, name, type, tableSource, isRestricted, isSelection, parameter_group, parameter_value, booleanValue, integerValue, decimalValue, stringValue, dateValue, dateTimeValue, timeValue, admin_employee_id, created_at, updated_at) VALUES ('ATTENDANCE', 'REPORT_MESSAGE_ABSEN_DAILY_FOR_PARENT', 'Pesan notifikasi Datang dan Pulang', 'string', null, 0, 0, null, null, null, null, null, 'Assalamu’alaikum Bapak/Ibu <br><br>Kami informasikan bahwa putra/putri Bapak/Ibu, *#siswa#*, telah melakukan absensi #status# pada hari ini, #tanggal#. <br><br> Terima kasih atas perhatian Bapak/Ibu.', null, null, null, null, '2021-12-23 04:32:56', '2025-09-21 14:36:22');
INSERT INTO `settings` (`group`, code, name, type, tableSource, isRestricted, isSelection, parameter_group, parameter_value, booleanValue, integerValue, decimalValue, stringValue, dateValue, dateTimeValue, timeValue, admin_employee_id, created_at, updated_at) VALUES ('ATTENDANCE', 'STATUS_NOTIFICATION_ABSEN_DAILY_MESSAGE', 'Notifikasi Datang dan Pulang', 'boolean', null, 0, 0, null, null, 1, null, null, null, null, null, null, null, '2021-12-23 04:32:56', '2025-09-21 10:52:42');