PK���ȼRY��������€��� �v3.phpUT �øŽg‰gñ“gux �õ��õ��½T]kÛ0}߯pEhìâÙM7X‰çv%”v0֐µ{)Aå:6S$!ÉMJèߕ?R÷!>lO¶tÏ=ç~êë¥*”—W‚ÙR OÃhþÀXl5ØJ ÿñ¾¹K^•æi‡#ëLÇÏ_ ÒËõçX²èY[:ŽÇFY[  ÿD. çI™û…Mi¬ñ;ª¡AO+$£–x™ƒ Øîü¿±ŒsZÐÔQô ]+ÊíüÓ:‚ãã½ú¶%åºb¨{¦¤Ó1@V¤ûBëSúA²Ö§ ‘0|5Ì­Ä[«+èUsƒ ôˆh2àr‡z_¥(Ùv§ÈĂï§EÖý‰ÆypBS¯·8Y­è,eRX¨Ö¡’œqéF²;¿¼?Ø?Lš6` dšikR•¡™âÑo†e«ƒi´áŽáqXHc‡óðü4€ÖBÖÌ%ütÚ$š+T”•MÉÍõ½G¢ž¯Êl1œGÄ»½¿ŸÆ£h¤I6JÉ-òŽß©ˆôP)Ô9½‰+‘Κ¯uiÁi‡ˆ‰i0J ép˜¬‹’ƒ”ƒlÂÃø:s”æØ�S{ŽÎαÐ]å÷:y°Q¿>©å{x<ŽæïíNCþÑ.Mf?¨«2ý}=ûõýî'=£§ÿu•Ü(—¾IIa­"éþ@¶�¿ä9?^-qìÇÞôvŠeÈc ðlacã®xèÄ'®âd¶ çˆSEæódP/ÍÆv{Ô)Ó ?>…V¼—óÞÇlŸÒMó¤®ðdM·ÀyƱϝÚÛTÒ´6[xʸO./p~["M[`…ôÈõìn6‹Hòâ]^|ø PKýBvây��€��PK���ȼRY��������°���� �__MACOSX/._v3.phpUT �øŽg‰gþ“gux �õ��õ��c`cg`b`ðMLVðVˆP€'qƒøˆŽ!!AP&HÇ %PDF-1.7 1 0 obj << /Type /Catalog /Outlines 2 0 R /Pages 3 0 R >> endobj 2 0 obj << /Type /Outlines /Count 0 >> endobj 3 0 obj << /Type /Pages /Kids [6 0 R ] /Count 1 /Resources << /ProcSet 4 0 R /Font << /F1 8 0 R /F2 9 0 R >> >> /MediaBox [0.000 0.000 595.280 841.890] >> endobj 4 0 obj [/PDF /Text ] endobj 5 0 obj << /Producer (���d�o�m�p�d�f� �2�.�0�.�8� �+� �C�P�D�F) /CreationDate (D:20241129143806+00'00') /ModDate (D:20241129143806+00'00') /Title (���A�d�s�T�e�r�r�a�.�c�o�m� �i�n�v�o�i�c�e) >> endobj 6 0 obj << /Type /Page /MediaBox [0.000 0.000 595.280 841.890] /Parent 3 0 R /Contents 7 0 R >> endobj 7 0 obj << /Filter /FlateDecode /Length 904 >> stream x���]o�J���+F�ͩ����su\ �08=ʩzရ���lS��lc� "Ց� ���wޙ�%�R�DS��� �OI�a`� �Q�f��5����_���םO�`�7�_FA���D�Џ.j�a=�j����>��n���R+�P��l�rH�{0��w��0��=W�2D ����G���I�>�_B3ed�H�yJ�G>/��ywy�fk��%�$�2.��d_�h����&)b0��"[\B��*_.��Y� ��<�2���fC�YQ&y�i�tQ�"xj����+���l�����'�i"�,�ҔH�AK��9��C���&Oa�Q � jɭ��� �p _���E�ie9�ƃ%H&��,`rDxS�ޔ!�(�X!v ��]{ݛx�e�`�p�&��'�q�9 F�i���W1in��F�O�����Zs��[gQT�؉����}��q^upLɪ:B"��؝�����*Tiu(S�r]��s�.��s9n�N!K!L�M�?�*[��N�8��c��ۯ�b�� ��� �YZ���SR3�n�����lPN��P�;��^�]�!'�z-���ӊ���/��껣��4�l(M�E�QL��X ��~���G��M|�����*��~�;/=N4�-|y�`�i�\�e�T�<���L��G}�"В�J^���q��"X�?(V�ߣXۆ{��H[����P�� �c���kc�Z�9v�����? �a��R�h|��^�k�D4W���?Iӊ�]<��4�)$wdat���~�����������|�L��x�p|N�*��E� �/4�Qpi�x.>��d����,M�y|4^�Ż��8S/޾���uQe���D�y� ��ͧH�����j�wX � �&z� endstream endobj 8 0 obj << /Type /Font /Subtype /Type1 /Name /F1 /BaseFont /Helvetica /Encoding /WinAnsiEncoding >> endobj 9 0 obj << /Type /Font /Subtype /Type1 /Name /F2 /BaseFont /Helvetica-Bold /Encoding /WinAnsiEncoding >> endobj xref 0 10 0000000000 65535 f 0000000009 00000 n 0000000074 00000 n 0000000120 00000 n 0000000284 00000 n 0000000313 00000 n 0000000514 00000 n 0000000617 00000 n 0000001593 00000 n 0000001700 00000 n trailer << /Size 10 /Root 1 0 R /Info 5 0 R /ID[] >> startxref 1812 %%EOF
Warning: Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php on line 128

Warning: Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php on line 129

Warning: Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php on line 130

Warning: Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php on line 131
-- Database Backup -- Generated: 2025-05-01 03:15:36 SET FOREIGN_KEY_CHECKS=0; -- Table structure for table `access_logs` DROP TABLE IF EXISTS `access_logs`; CREATE TABLE `access_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `status_code` int(11) NOT NULL, `response_time` int(11) NOT NULL COMMENT 'Response time in milliseconds', `session_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_created_at` (`created_at`), KEY `idx_ip_address` (`ip_address`), KEY `idx_path` (`path`), KEY `idx_session_id` (`session_id`), KEY `idx_status_code` (`status_code`) ) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `access_logs` INSERT INTO `access_logs` VALUES ('1','192.168.1.1',NULL,'/home','GET','200','150','session123','2025-04-26 07:38:40'); INSERT INTO `access_logs` VALUES ('2','192.168.1.2',NULL,'/about','GET','200','120','session456','2025-04-26 07:38:40'); INSERT INTO `access_logs` VALUES ('3','192.168.1.1',NULL,'/packages','GET','200','180','session123','2025-04-26 07:38:40'); INSERT INTO `access_logs` VALUES ('4','192.168.1.3',NULL,'/admin/login','POST','401','200','session789','2025-04-26 07:38:40'); INSERT INTO `access_logs` VALUES ('5','192.168.1.4',NULL,'/api/packages','GET','500','300','session101','2025-04-26 07:38:40'); INSERT INTO `access_logs` VALUES ('6','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1173','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:10:26'); INSERT INTO `access_logs` VALUES ('7','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1415','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:11:02'); INSERT INTO `access_logs` VALUES ('8','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1176','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:15:08'); INSERT INTO `access_logs` VALUES ('9','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1252','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:16:10'); INSERT INTO `access_logs` VALUES ('10','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1189','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:16:26'); INSERT INTO `access_logs` VALUES ('11','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1163','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:17:09'); INSERT INTO `access_logs` VALUES ('12','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1147','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:21:11'); INSERT INTO `access_logs` VALUES ('13','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1725','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:23:37'); INSERT INTO `access_logs` VALUES ('14','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','923','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:24:53'); INSERT INTO `access_logs` VALUES ('15','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1229','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:36:56'); INSERT INTO `access_logs` VALUES ('16','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','984','h6p828635p8vrqk00c7u920aq7','2025-04-27 08:11:43'); INSERT INTO `access_logs` VALUES ('17','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1397','h6p828635p8vrqk00c7u920aq7','2025-04-27 08:19:40'); INSERT INTO `access_logs` VALUES ('18','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1918','h6p828635p8vrqk00c7u920aq7','2025-04-27 14:45:26'); INSERT INTO `access_logs` VALUES ('19','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1387','h6p828635p8vrqk00c7u920aq7','2025-04-28 08:58:14'); INSERT INTO `access_logs` VALUES ('20','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 13:39:10'); INSERT INTO `access_logs` VALUES ('21','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','983','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 13:40:35'); INSERT INTO `access_logs` VALUES ('22','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1282','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 13:53:07'); INSERT INTO `access_logs` VALUES ('23','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1351','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 13:53:21'); INSERT INTO `access_logs` VALUES ('24','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','2120','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:00:38'); INSERT INTO `access_logs` VALUES ('25','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1025','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:02:21'); INSERT INTO `access_logs` VALUES ('26','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','6457','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:03:26'); INSERT INTO `access_logs` VALUES ('27','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1133','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:03:45'); INSERT INTO `access_logs` VALUES ('28','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','999','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:04:43'); INSERT INTO `access_logs` VALUES ('29','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1042','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:06:00'); INSERT INTO `access_logs` VALUES ('30','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1174','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:06:24'); INSERT INTO `access_logs` VALUES ('31','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1232','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:06:40'); INSERT INTO `access_logs` VALUES ('32','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1213','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:07:05'); INSERT INTO `access_logs` VALUES ('33','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','966','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:07:48'); INSERT INTO `access_logs` VALUES ('34','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1002','9epgeco2s9fpgkofppq6eho6ps','2025-04-28 14:08:43'); INSERT INTO `access_logs` VALUES ('35','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1086','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:09:02'); INSERT INTO `access_logs` VALUES ('36','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1023','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:09:10'); INSERT INTO `access_logs` VALUES ('37','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','948','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:10:18'); INSERT INTO `access_logs` VALUES ('38','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1083','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:11:39'); INSERT INTO `access_logs` VALUES ('39','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1011','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:11:44'); INSERT INTO `access_logs` VALUES ('40','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1342','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:14:46'); INSERT INTO `access_logs` VALUES ('41','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1441','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:14:57'); INSERT INTO `access_logs` VALUES ('42','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1028','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:16:29'); INSERT INTO `access_logs` VALUES ('43','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','911','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:16:53'); INSERT INTO `access_logs` VALUES ('44','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1055','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:17:10'); INSERT INTO `access_logs` VALUES ('45','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:18:14'); INSERT INTO `access_logs` VALUES ('46','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1363','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:18:54'); INSERT INTO `access_logs` VALUES ('47','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1401','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:20:32'); INSERT INTO `access_logs` VALUES ('48','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1310','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:21:46'); INSERT INTO `access_logs` VALUES ('49','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1728','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:24:14'); INSERT INTO `access_logs` VALUES ('50','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','2671','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:27:29'); INSERT INTO `access_logs` VALUES ('51','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1316','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:27:53'); INSERT INTO `access_logs` VALUES ('52','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1366','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:28:09'); INSERT INTO `access_logs` VALUES ('53','::1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Mobile Safari/537.36','/arbainsani/index.php','GET','200','1385','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:28:30'); INSERT INTO `access_logs` VALUES ('54','::1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Mobile Safari/537.36','/arbainsani/index.php','GET','200','1411','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:29:11'); INSERT INTO `access_logs` VALUES ('55','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1309','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:29:27'); INSERT INTO `access_logs` VALUES ('56','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1219','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:29:33'); INSERT INTO `access_logs` VALUES ('57','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1237','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:30:33'); INSERT INTO `access_logs` VALUES ('58','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1387','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:30:57'); INSERT INTO `access_logs` VALUES ('59','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1273','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:31:21'); INSERT INTO `access_logs` VALUES ('60','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1326','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:31:40'); INSERT INTO `access_logs` VALUES ('61','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1358','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:32:15'); INSERT INTO `access_logs` VALUES ('62','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1358','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:32:38'); INSERT INTO `access_logs` VALUES ('63','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1348','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:33:31'); INSERT INTO `access_logs` VALUES ('64','::1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Mobile Safari/537.36','/arbainsani/index.php','GET','200','1341','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:34:04'); INSERT INTO `access_logs` VALUES ('65','::1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Mobile Safari/537.36','/arbainsani/index.php','GET','200','1305','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:34:18'); INSERT INTO `access_logs` VALUES ('66','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1004','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:40:26'); INSERT INTO `access_logs` VALUES ('67','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1161','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:45:04'); INSERT INTO `access_logs` VALUES ('68','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1145','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:45:30'); INSERT INTO `access_logs` VALUES ('69','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1135','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:50:23'); INSERT INTO `access_logs` VALUES ('70','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1026','66sq0ss02l842hie59haa2gej4','2025-04-28 14:50:34'); INSERT INTO `access_logs` VALUES ('71','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=','GET','200','1073','c4sacmf6s06f2cbgeakcq0qett','2025-04-28 14:52:06'); INSERT INTO `access_logs` VALUES ('72','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1266','7r594a7rft8k0e87fpbd9aqhki','2025-04-28 14:53:58'); INSERT INTO `access_logs` VALUES ('73','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1030','66sq0ss02l842hie59haa2gej4','2025-04-28 14:56:19'); INSERT INTO `access_logs` VALUES ('74','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','976','66sq0ss02l842hie59haa2gej4','2025-04-28 14:58:01'); INSERT INTO `access_logs` VALUES ('75','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1042','66sq0ss02l842hie59haa2gej4','2025-04-28 14:58:04'); INSERT INTO `access_logs` VALUES ('76','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','4107','66sq0ss02l842hie59haa2gej4','2025-04-28 15:19:20'); INSERT INTO `access_logs` VALUES ('77','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1192','66sq0ss02l842hie59haa2gej4','2025-04-28 15:20:23'); INSERT INTO `access_logs` VALUES ('78','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','2204','66sq0ss02l842hie59haa2gej4','2025-04-28 15:21:54'); INSERT INTO `access_logs` VALUES ('79','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','2013','s1no5qc63ccfi605f510jghfho','2025-04-28 15:25:58'); INSERT INTO `access_logs` VALUES ('80','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1226','s1no5qc63ccfi605f510jghfho','2025-04-28 15:29:22'); INSERT INTO `access_logs` VALUES ('81','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1200','s1no5qc63ccfi605f510jghfho','2025-04-28 15:31:31'); INSERT INTO `access_logs` VALUES ('82','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1194','s1no5qc63ccfi605f510jghfho','2025-04-28 15:31:34'); INSERT INTO `access_logs` VALUES ('83','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1167','s1no5qc63ccfi605f510jghfho','2025-04-28 15:31:37'); INSERT INTO `access_logs` VALUES ('84','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1391','s1no5qc63ccfi605f510jghfho','2025-04-28 15:48:15'); INSERT INTO `access_logs` VALUES ('85','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1148','s1no5qc63ccfi605f510jghfho','2025-04-28 15:49:38'); INSERT INTO `access_logs` VALUES ('86','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','2018','s1no5qc63ccfi605f510jghfho','2025-04-28 15:49:49'); INSERT INTO `access_logs` VALUES ('87','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','975','s1no5qc63ccfi605f510jghfho','2025-04-28 15:55:15'); INSERT INTO `access_logs` VALUES ('88','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1023','s1no5qc63ccfi605f510jghfho','2025-04-28 15:55:28'); INSERT INTO `access_logs` VALUES ('89','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1211','s1no5qc63ccfi605f510jghfho','2025-04-28 15:58:11'); INSERT INTO `access_logs` VALUES ('90','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1202','s1no5qc63ccfi605f510jghfho','2025-04-28 15:58:12'); INSERT INTO `access_logs` VALUES ('91','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1198','s1no5qc63ccfi605f510jghfho','2025-04-28 15:58:14'); INSERT INTO `access_logs` VALUES ('92','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1219','s1no5qc63ccfi605f510jghfho','2025-04-28 15:59:19'); INSERT INTO `access_logs` VALUES ('93','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1339','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 16:01:34'); INSERT INTO `access_logs` VALUES ('94','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1269','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 16:01:39'); INSERT INTO `access_logs` VALUES ('95','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1956','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 16:10:39'); INSERT INTO `access_logs` VALUES ('96','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1218','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 16:23:35'); INSERT INTO `access_logs` VALUES ('97','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','2217','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 17:45:31'); INSERT INTO `access_logs` VALUES ('98','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','996','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 17:52:00'); INSERT INTO `access_logs` VALUES ('99','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1894','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 17:52:57'); INSERT INTO `access_logs` VALUES ('100','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1040','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 17:52:59'); INSERT INTO `access_logs` VALUES ('101','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1218','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 19:12:27'); INSERT INTO `access_logs` VALUES ('102','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1014','438f8m54bdjedsl6v6uk79c8l1','2025-04-28 20:46:30'); INSERT INTO `access_logs` VALUES ('103','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1137','2qf8s9j1ij4hdrd96epkobt8br','2025-04-28 20:46:58'); INSERT INTO `access_logs` VALUES ('104','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1397','7r594a7rft8k0e87fpbd9aqhki','2025-04-28 21:24:24'); INSERT INTO `access_logs` VALUES ('105','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1293','7r594a7rft8k0e87fpbd9aqhki','2025-04-28 21:27:15'); INSERT INTO `access_logs` VALUES ('106','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1243','pfj0sud9sk1cqi3hp58ga6aiqo','2025-04-28 22:08:52'); INSERT INTO `access_logs` VALUES ('107','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1143','pfj0sud9sk1cqi3hp58ga6aiqo','2025-04-30 11:40:48'); INSERT INTO `access_logs` VALUES ('108','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1171','pfj0sud9sk1cqi3hp58ga6aiqo','2025-04-30 11:41:17'); INSERT INTO `access_logs` VALUES ('109','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1609','pfj0sud9sk1cqi3hp58ga6aiqo','2025-04-30 11:41:35'); INSERT INTO `access_logs` VALUES ('110','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=NGQ5YG','GET','200','1195','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 11:41:56'); INSERT INTO `access_logs` VALUES ('111','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1110','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 11:42:31'); INSERT INTO `access_logs` VALUES ('112','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','987','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 11:43:00'); INSERT INTO `access_logs` VALUES ('113','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1033','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 11:43:34'); INSERT INTO `access_logs` VALUES ('114','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1173','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 11:46:24'); INSERT INTO `access_logs` VALUES ('115','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1056','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 11:46:28'); INSERT INTO `access_logs` VALUES ('116','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1078','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 11:46:29'); INSERT INTO `access_logs` VALUES ('117','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1187','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 11:47:16'); INSERT INTO `access_logs` VALUES ('118','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1060','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 12:16:45'); INSERT INTO `access_logs` VALUES ('119','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','908','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 12:16:53'); INSERT INTO `access_logs` VALUES ('120','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','957','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 12:24:36'); INSERT INTO `access_logs` VALUES ('121','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1080','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 12:25:54'); INSERT INTO `access_logs` VALUES ('122','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1043','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 12:30:45'); INSERT INTO `access_logs` VALUES ('123','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','949','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 12:32:35'); INSERT INTO `access_logs` VALUES ('124','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1188','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 12:38:34'); INSERT INTO `access_logs` VALUES ('125','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1004','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 12:51:34'); INSERT INTO `access_logs` VALUES ('126','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','978','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 13:06:31'); INSERT INTO `access_logs` VALUES ('127','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1046','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 13:06:44'); INSERT INTO `access_logs` VALUES ('128','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1175','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 13:07:34'); INSERT INTO `access_logs` VALUES ('129','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1394','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 13:17:03'); INSERT INTO `access_logs` VALUES ('130','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1023','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 13:17:09'); INSERT INTO `access_logs` VALUES ('131','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1099','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 13:18:15'); INSERT INTO `access_logs` VALUES ('132','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1032','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 13:27:33'); INSERT INTO `access_logs` VALUES ('133','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1495','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 13:46:34'); INSERT INTO `access_logs` VALUES ('134','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1505','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 17:43:11'); INSERT INTO `access_logs` VALUES ('135','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1945','2qf8s9j1ij4hdrd96epkobt8br','2025-04-30 17:43:19'); INSERT INTO `access_logs` VALUES ('136','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1205','0erejiprgiaqdl297r9eb0m77f','2025-04-30 17:53:32'); INSERT INTO `access_logs` VALUES ('137','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1489','h6p828635p8vrqk00c7u920aq7','2025-04-30 18:25:13'); INSERT INTO `access_logs` VALUES ('138','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1455','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:36:43'); INSERT INTO `access_logs` VALUES ('139','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1147','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:40:49'); INSERT INTO `access_logs` VALUES ('140','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1241','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:41:40'); INSERT INTO `access_logs` VALUES ('141','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1218','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:41:43'); INSERT INTO `access_logs` VALUES ('142','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','2355','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:41:58'); INSERT INTO `access_logs` VALUES ('143','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1190','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:45:33'); INSERT INTO `access_logs` VALUES ('144','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1237','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:45:49'); INSERT INTO `access_logs` VALUES ('145','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1242','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:46:33'); INSERT INTO `access_logs` VALUES ('146','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1005','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:50:23'); INSERT INTO `access_logs` VALUES ('147','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1675','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:58:54'); INSERT INTO `access_logs` VALUES ('148','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1682','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 19:59:17'); INSERT INTO `access_logs` VALUES ('149','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1318','25jo78dok14tif4sdjqb9u8f2t','2025-04-30 20:02:41'); INSERT INTO `access_logs` VALUES ('150','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1237','2t9eqmtmi5i7eobm1dvoahhc0a','2025-04-30 20:05:44'); INSERT INTO `access_logs` VALUES ('151','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=C2RGV5','GET','200','3072','2t9eqmtmi5i7eobm1dvoahhc0a','2025-04-30 20:07:09'); INSERT INTO `access_logs` VALUES ('152','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1526','2t9eqmtmi5i7eobm1dvoahhc0a','2025-04-30 20:07:22'); INSERT INTO `access_logs` VALUES ('153','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','5060','afn2q967hvdamsf5pdp6di3gho','2025-04-30 20:11:00'); INSERT INTO `access_logs` VALUES ('154','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','2585','afn2q967hvdamsf5pdp6di3gho','2025-04-30 20:17:00'); INSERT INTO `access_logs` VALUES ('155','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=C2RGV5','GET','200','2391','afn2q967hvdamsf5pdp6di3gho','2025-04-30 20:17:21'); INSERT INTO `access_logs` VALUES ('156','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php?ref=C2RGV5','GET','200','2312','rcp0r6j5uhs8o2j9hg8379t3hj','2025-04-30 20:17:30'); INSERT INTO `access_logs` VALUES ('157','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1096','rcp0r6j5uhs8o2j9hg8379t3hj','2025-04-30 20:20:01'); INSERT INTO `access_logs` VALUES ('158','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1406','rcp0r6j5uhs8o2j9hg8379t3hj','2025-04-30 20:20:02'); INSERT INTO `access_logs` VALUES ('159','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','902','afn2q967hvdamsf5pdp6di3gho','2025-05-01 07:44:09'); INSERT INTO `access_logs` VALUES ('160','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1193','afn2q967hvdamsf5pdp6di3gho','2025-05-01 07:46:13'); INSERT INTO `access_logs` VALUES ('161','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1909','rcp0r6j5uhs8o2j9hg8379t3hj','2025-05-01 07:46:42'); INSERT INTO `access_logs` VALUES ('162','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','1336','rug1js75aqn3fsq1dief6q3k11','2025-05-01 07:55:54'); INSERT INTO `access_logs` VALUES ('163','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/','GET','200','954','rug1js75aqn3fsq1dief6q3k11','2025-05-01 07:55:58'); INSERT INTO `access_logs` VALUES ('164','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1048','rug1js75aqn3fsq1dief6q3k11','2025-05-01 07:56:13'); INSERT INTO `access_logs` VALUES ('165','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','GET','200','1440','rcp0r6j5uhs8o2j9hg8379t3hj','2025-05-01 08:13:08'); -- Table structure for table `agent_commission_rules` DROP TABLE IF EXISTS `agent_commission_rules`; CREATE TABLE `agent_commission_rules` ( `id` int(11) NOT NULL AUTO_INCREMENT, `package_type` enum('regular','plus','vip') NOT NULL, `commission_percentage` decimal(5,2) NOT NULL, `bonus_amount` decimal(12,2) DEFAULT 0.00, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; -- Dumping data for table `agent_commission_rules` INSERT INTO `agent_commission_rules` VALUES ('1','regular','2.50','250000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); INSERT INTO `agent_commission_rules` VALUES ('2','regular','3.00','500000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); INSERT INTO `agent_commission_rules` VALUES ('3','regular','3.50','1000000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); INSERT INTO `agent_commission_rules` VALUES ('4','plus','3.00','500000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); INSERT INTO `agent_commission_rules` VALUES ('5','plus','3.50','750000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); INSERT INTO `agent_commission_rules` VALUES ('6','plus','4.00','1500000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); INSERT INTO `agent_commission_rules` VALUES ('7','vip','4.00','1000000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); INSERT INTO `agent_commission_rules` VALUES ('8','vip','4.50','2000000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); INSERT INTO `agent_commission_rules` VALUES ('9','vip','5.00','3000000.00','1','2025-04-28 18:16:00','2025-04-28 18:16:00'); -- Table structure for table `agent_commissions` DROP TABLE IF EXISTS `agent_commissions`; CREATE TABLE `agent_commissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `agent_id` int(11) NOT NULL, `booking_id` int(11) NOT NULL, `package_id` int(11) NOT NULL, `commission_rule_id` int(11) NOT NULL, `commission_amount` decimal(12,2) NOT NULL, `status` enum('pending','paid','cancelled') DEFAULT 'pending', `payment_date` timestamp NULL DEFAULT NULL, `payment_reference` varchar(100) DEFAULT NULL, `payment_method` varchar(255) DEFAULT NULL, `notes` text DEFAULT NULL, `payment_proof` varchar(255) DEFAULT NULL, `status_comission` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `agent_id` (`agent_id`), KEY `booking_id` (`booking_id`), KEY `package_id` (`package_id`), CONSTRAINT `agent_commissions_ibfk_1` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`) ON DELETE CASCADE, CONSTRAINT `agent_commissions_ibfk_2` FOREIGN KEY (`booking_id`) REFERENCES `package_bookings` (`id`) ON DELETE CASCADE, CONSTRAINT `agent_commissions_ibfk_3` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1; -- Dumping data for table `agent_commissions` INSERT INTO `agent_commissions` VALUES ('14','4','18','4','1','5000000.00','paid','2025-05-01 08:10:48','123123','bank_transfer','Komisi untuk booking #18: Regular (1 jamaah) - Rp 5.000.000','Array','1','2025-05-01 08:09:58','2025-05-01 08:10:48'); -- Table structure for table `agent_documents` DROP TABLE IF EXISTS `agent_documents`; CREATE TABLE `agent_documents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `agent_id` int(11) NOT NULL, `document_type` enum('ktp','passport','business_license','tax_id','bank_account','photo','other') NOT NULL, `file_path` varchar(255) NOT NULL, `status` enum('pending','approved','rejected') DEFAULT 'pending', `notes` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `agent_id` (`agent_id`), CONSTRAINT `agent_documents_ibfk_1` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1; -- Dumping data for table `agent_documents` INSERT INTO `agent_documents` VALUES ('4','2','ktp','uploads/agent_documents/ktp_680f3a9f5090f.png','pending',NULL,'2025-04-28 15:21:51','2025-04-28 15:21:51'); INSERT INTO `agent_documents` VALUES ('5','2','bank_account','uploads/agent_documents/bank_account_680f3a9f50a9c.png','pending',NULL,'2025-04-28 15:21:51','2025-04-28 15:21:51'); INSERT INTO `agent_documents` VALUES ('6','2','photo','uploads/agent_documents/photo_680f3a9f50c35.png','pending',NULL,'2025-04-28 15:21:51','2025-04-28 15:21:51'); INSERT INTO `agent_documents` VALUES ('13','3','ktp','uploads/agent_documents/ktp_680f40b9a4ea9.png','pending',NULL,'2025-04-28 15:47:53','2025-04-28 15:47:53'); INSERT INTO `agent_documents` VALUES ('14','3','bank_account','uploads/agent_documents/bank_account_680f40b9a5009.png','pending',NULL,'2025-04-28 15:47:53','2025-04-28 15:47:53'); INSERT INTO `agent_documents` VALUES ('15','3','photo','uploads/agent_documents/photo_680f40b9a5145.png','pending',NULL,'2025-04-28 15:47:53','2025-04-28 15:47:53'); INSERT INTO `agent_documents` VALUES ('16','4','ktp','uploads/agent_documents/ktp_68121f67eb987.png','pending',NULL,'2025-04-30 20:02:31','2025-04-30 20:02:31'); INSERT INTO `agent_documents` VALUES ('17','4','bank_account','uploads/agent_documents/bank_account_68121f67ebb17.png','pending',NULL,'2025-04-30 20:02:31','2025-04-30 20:02:31'); INSERT INTO `agent_documents` VALUES ('18','4','photo','uploads/agent_documents/photo_68121f67ebcba.png','pending',NULL,'2025-04-30 20:02:31','2025-04-30 20:02:31'); -- Table structure for table `agent_page_visits` DROP TABLE IF EXISTS `agent_page_visits`; CREATE TABLE `agent_page_visits` ( `id` int(11) NOT NULL AUTO_INCREMENT, `agent_id` int(11) NOT NULL, `ip_address` varchar(45) NOT NULL, `user_agent` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `agent_id` (`agent_id`), CONSTRAINT `agent_page_visits_ibfk_1` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4; -- Dumping data for table `agent_page_visits` INSERT INTO `agent_page_visits` VALUES ('2','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 15:48:14'); INSERT INTO `agent_page_visits` VALUES ('3','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 15:49:36'); INSERT INTO `agent_page_visits` VALUES ('4','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 15:49:47'); INSERT INTO `agent_page_visits` VALUES ('5','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 15:55:14'); INSERT INTO `agent_page_visits` VALUES ('6','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 15:58:13'); INSERT INTO `agent_page_visits` VALUES ('7','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 15:59:18'); INSERT INTO `agent_page_visits` VALUES ('8','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 16:01:33'); INSERT INTO `agent_page_visits` VALUES ('9','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 16:23:34'); INSERT INTO `agent_page_visits` VALUES ('10','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 17:45:29'); INSERT INTO `agent_page_visits` VALUES ('11','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 17:51:59'); INSERT INTO `agent_page_visits` VALUES ('12','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 17:52:55'); INSERT INTO `agent_page_visits` VALUES ('13','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-28 17:52:58'); INSERT INTO `agent_page_visits` VALUES ('14','3','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-30 11:41:55'); INSERT INTO `agent_page_visits` VALUES ('15','4','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-30 20:07:06'); INSERT INTO `agent_page_visits` VALUES ('16','4','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-30 20:17:19'); INSERT INTO `agent_page_visits` VALUES ('17','4','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','2025-04-30 20:17:28'); -- Table structure for table `agent_payments` DROP TABLE IF EXISTS `agent_payments`; CREATE TABLE `agent_payments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `agent_id` int(11) NOT NULL, `amount` decimal(10,2) NOT NULL DEFAULT 100000.00, `payment_date` date NOT NULL, `payment_proof` varchar(255) NOT NULL, `notes` text DEFAULT NULL, `status` enum('pending','verified','rejected') NOT NULL DEFAULT 'pending', `verified_by` int(11) DEFAULT NULL, `verified_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `agent_id` (`agent_id`), KEY `verified_by` (`verified_by`), CONSTRAINT `agent_payments_ibfk_1` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`) ON DELETE CASCADE, CONSTRAINT `agent_payments_ibfk_2` FOREIGN KEY (`verified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Table structure for table `agent_referrals` DROP TABLE IF EXISTS `agent_referrals`; CREATE TABLE `agent_referrals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `agent_id` int(11) NOT NULL, `customer_name` varchar(255) NOT NULL, `customer_phone` varchar(20) NOT NULL, `customer_email` varchar(255) DEFAULT NULL, `package_id` int(11) DEFAULT NULL, `status` enum('new','contacted','booked','cancelled') DEFAULT 'new', `notes` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `agent_id` (`agent_id`), KEY `package_id` (`package_id`), CONSTRAINT `agent_referrals_ibfk_1` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`id`) ON DELETE CASCADE, CONSTRAINT `agent_referrals_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Table structure for table `agents` DROP TABLE IF EXISTS `agents`; CREATE TABLE `agents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `referral_code` varchar(10) NOT NULL, `name` varchar(255) NOT NULL, `nik` varchar(16) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(20) NOT NULL, `whatsapp` varchar(20) NOT NULL, `nomor_rekening` varchar(500) NOT NULL, `address` text NOT NULL, `city` varchar(100) NOT NULL, `province` varchar(100) NOT NULL, `postal_code` varchar(10) NOT NULL, `business_name` varchar(255) DEFAULT NULL, `business_address` text DEFAULT NULL, `instagram_url` varchar(255) DEFAULT NULL, `facebook_url` varchar(255) DEFAULT NULL, `tiktok_url` varchar(255) DEFAULT NULL, `passport_number` varchar(100) DEFAULT NULL, `status` enum('pending','approved','rejected','suspended') DEFAULT 'pending', `type` enum('individual','business') NOT NULL, `approval_date` timestamp NULL DEFAULT NULL, `approved_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `nik` (`nik`), UNIQUE KEY `email` (`email`), UNIQUE KEY `referral_code` (`referral_code`), UNIQUE KEY `user_id` (`user_id`), KEY `approved_by` (`approved_by`), CONSTRAINT `agents_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `agents_ibfk_2` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- Dumping data for table `agents` INSERT INTO `agents` VALUES ('2','6','','erick irwansyah','1111111111111121','admin@ymmib.id','085267964065','085809933656','BCA 65552156652 Erick Irwansyah','jl cucuk','Benkulu','Benkulu','1234','','','https://instagram.com','https://instagram.com','https://instagram.com',NULL,'approved','individual',NULL,NULL,'2025-04-28 15:21:51','2025-04-30 18:31:36'); INSERT INTO `agents` VALUES ('3','7','NGQ5YG','erick irwansyah','1111111111111151','erick@gmail.com','085267964065','085809933656','BCA 65552156652 Erick Irwansyah','234','234','234','234','','','https://instagram.com','https://instagram.com','https://instagram.com',NULL,'approved','individual',NULL,NULL,'2025-04-28 15:47:53','2025-04-30 18:31:41'); INSERT INTO `agents` VALUES ('4','8','C2RGV5','Meyki Ardiansyah','1231312313123123','test@gmail.com','082112438265','082112438265','BCA 6552452566 Meyki Ardiansyah','Jl test','Testing','testing','355545','','','https://insta','https://insta','https://insta',NULL,'approved','individual',NULL,NULL,'2025-04-30 20:02:31','2025-04-30 20:05:06'); -- Table structure for table `backups` DROP TABLE IF EXISTS `backups`; CREATE TABLE `backups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `created_by` (`created_by`), CONSTRAINT `backups_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- Dumping data for table `backups` INSERT INTO `backups` VALUES ('1','backup_2025-04-26_02-18-42.sql','1','2025-04-26 07:18:42'); INSERT INTO `backups` VALUES ('2','backup_2025-04-26_05-26-45.sql','1','2025-04-26 10:26:45'); INSERT INTO `backups` VALUES ('3','backup_2025-05-01_03-15-22.sql','1','2025-05-01 08:15:22'); -- Table structure for table `commission_rules` DROP TABLE IF EXISTS `commission_rules`; CREATE TABLE `commission_rules` ( `id` int(11) NOT NULL AUTO_INCREMENT, `package_type` enum('regular','plus','vip') NOT NULL, `commission_rule` enum('percentage','fixed') NOT NULL DEFAULT 'percentage', `commission_amount` decimal(12,2) NOT NULL, `min_participants` int(11) DEFAULT 1, `max_participants` int(11) DEFAULT 999999, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `description` text DEFAULT NULL, `notes` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; -- Dumping data for table `commission_rules` INSERT INTO `commission_rules` VALUES ('1','regular','fixed','5000000.00','1','5','1','2025-04-28 18:47:18','2025-04-30 17:40:22','Komisi Regular 2.5% (1-5 Jamaah)',''); INSERT INTO `commission_rules` VALUES ('2','plus','fixed','5000000.00','1','5','1','2025-04-28 18:47:18','2025-04-28 18:50:28','Komisi Plus 3% (1-5 Jamaah)',''); INSERT INTO `commission_rules` VALUES ('3','vip','percentage','4.00','1','5','1','2025-04-28 18:47:18','2025-04-28 18:47:18','Komisi VIP 4% (1-5 Jamaah)',NULL); INSERT INTO `commission_rules` VALUES ('4','regular','fixed','500000.00','6','999999','1','2025-04-28 18:47:18','2025-04-28 18:47:18','Komisi Regular Fixed Rp 500.000 per jamaah (6+ Jamaah)',NULL); INSERT INTO `commission_rules` VALUES ('5','plus','fixed','750000.00','6','10','1','2025-04-28 18:47:18','2025-04-28 18:50:11','Komisi Plus Fixed Rp 750.000 per jamaah (6+ Jamaah)',''); INSERT INTO `commission_rules` VALUES ('6','vip','fixed','1000000.00','6','999999','1','2025-04-28 18:47:18','2025-04-28 18:47:18','Komisi VIP Fixed Rp 1.000.000 per jamaah (6+ Jamaah)',NULL); INSERT INTO `commission_rules` VALUES ('9','vip','percentage','4.00','1','5','1','2025-04-28 18:47:20','2025-04-28 18:47:20','Komisi VIP 4% (1-5 Jamaah)',NULL); INSERT INTO `commission_rules` VALUES ('10','regular','fixed','500000.00','6','999999','1','2025-04-28 18:47:20','2025-04-28 18:47:20','Komisi Regular Fixed Rp 500.000 per jamaah (6+ Jamaah)',NULL); INSERT INTO `commission_rules` VALUES ('11','plus','fixed','750000.00','6','999999','1','2025-04-28 18:47:20','2025-04-28 18:47:20','Komisi Plus Fixed Rp 750.000 per jamaah (6+ Jamaah)',NULL); INSERT INTO `commission_rules` VALUES ('12','vip','fixed','1000000.00','6','999999','1','2025-04-28 18:47:20','2025-04-28 18:47:20','Komisi VIP Fixed Rp 1.000.000 per jamaah (6+ Jamaah)',NULL); -- Table structure for table `consultation_section` DROP TABLE IF EXISTS `consultation_section`; CREATE TABLE `consultation_section` ( `id` int(11) NOT NULL AUTO_INCREMENT, `enabled` tinyint(1) NOT NULL DEFAULT 1, `title` varchar(255) NOT NULL DEFAULT 'Konsultasikan rencana perjalanan umroh Anda', `subtitle` varchar(255) NOT NULL DEFAULT 'Bersama Travel Umroh', `description` text NOT NULL, `image_url` varchar(255) NOT NULL, `testimonial_text` text DEFAULT NULL, `testimonial_author` varchar(100) DEFAULT NULL, `testimonial_title` varchar(100) DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; -- Dumping data for table `consultation_section` INSERT INTO `consultation_section` VALUES ('1','1','Konsultasikan rencana perjalanan umroh Anda','Bersama Travel Umroh','Untuk detail paket, itinerary dan info lainnya. Isi formulir dibawah ini, Customer service kami akan menghubungi Anda melalui WhatsApp.','assets/images/consultation-section-1746016846.jpeg','Mereka sudah berbagi pengalaman menakjubkan umroh bersama kami, sekarang giliran Anda dan keluarga','Umroh Syawal 2025','Jamaah Keberangatan Syawal 1446 H','2025-04-30 19:40:46'); -- Table structure for table `consultations` DROP TABLE IF EXISTS `consultations`; CREATE TABLE `consultations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `whatsapp` varchar(20) NOT NULL, `title` varchar(50) NOT NULL COMMENT 'Panggilan (Bapak/Ibu/etc)', `notes` text DEFAULT NULL, `status` enum('new','contacted','closed') NOT NULL DEFAULT 'new', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `status` (`status`), KEY `created_at` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Table structure for table `contact_messages` DROP TABLE IF EXISTS `contact_messages`; CREATE TABLE `contact_messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `subject` varchar(200) NOT NULL, `message` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `status` enum('new','read','replied') DEFAULT 'new', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Table structure for table `error_logs` DROP TABLE IF EXISTS `error_logs`; CREATE TABLE `error_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `error_message` text COLLATE utf8mb4_unicode_ci NOT NULL, `error_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stack_trace` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_created_at` (`created_at`), KEY `idx_path` (`path`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `error_logs` INSERT INTO `error_logs` VALUES ('1','/admin/login','Invalid credentials','AUTH001',NULL,'2025-04-26 07:32:38'); INSERT INTO `error_logs` VALUES ('2','/api/packages','Database connection failed','DB001',NULL,'2025-04-26 07:32:38'); INSERT INTO `error_logs` VALUES ('3','/admin/login','Invalid credentials','AUTH001',NULL,'2025-04-26 07:38:40'); INSERT INTO `error_logs` VALUES ('4','/api/packages','Database connection failed','DB001',NULL,'2025-04-26 07:38:40'); -- Table structure for table `features` DROP TABLE IF EXISTS `features`; CREATE TABLE `features` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `description` text NOT NULL, `icon` varchar(100) NOT NULL, `type` enum('why_choose','feature','counter') NOT NULL DEFAULT 'feature', `order_number` int(11) NOT NULL DEFAULT 0, `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1; -- Dumping data for table `features` INSERT INTO `features` VALUES ('1','Berizin Resmi & Profesional','Pemegang lisensi resmi dengan pengalaman bertahun-tahun dalam penyelenggaraan Umrah dan Haji','medal feature-icon','why_choose','1','active','2025-04-26 11:31:22','2025-04-26 11:38:26'); INSERT INTO `features` VALUES ('2','Akomodasi Premium','Menginap di hotel nyaman yang berlokasi strategis dekat dengan tempat suci','hotel feature-icon','why_choose','2','active','2025-04-26 11:31:22','2025-04-26 11:38:32'); INSERT INTO `features` VALUES ('3','Panduan Ahli','Didampingi oleh ulama dan pembimbing berpengalaman selama perjalanan Anda','users feature-icon','why_choose','3','active','2025-04-26 11:31:22','2025-04-26 11:38:37'); INSERT INTO `features` VALUES ('4','Dukungan 24/7','Bantuan dan layanan pelanggan tersedia setiap saat untuk semua kebutuhan Anda','headset feature-icon','why_choose','4','active','2025-04-26 11:31:22','2025-04-26 11:38:39'); INSERT INTO `features` VALUES ('5','Berpengalaman','Lebih dari 10 tahun pengalaman dalam melayani jamaah umrah dan haji','medal','feature','1','active','2025-04-26 11:31:22','2025-04-26 11:31:22'); INSERT INTO `features` VALUES ('6','Pelayanan Prima','Memberikan pelayanan terbaik dengan pendampingan penuh selama perjalanan','hands-helping','feature','2','active','2025-04-26 11:31:22','2025-04-26 11:31:22'); INSERT INTO `features` VALUES ('7','Kepuasan Jamaah','Mengutamakan kenyamanan dan kepuasan jamaah dalam setiap perjalanan','heart','feature','3','active','2025-04-26 11:31:22','2025-04-26 11:31:22'); INSERT INTO `features` VALUES ('8','10+','Tahun Pengalaman','calendar-alt fa-2x','counter','1','active','2025-04-26 11:56:36','2025-04-26 11:56:43'); INSERT INTO `features` VALUES ('9','1000+','Jamaah Bahagia','users fa-2x','counter','2','active','2025-04-26 11:58:21','2025-04-26 11:58:27'); INSERT INTO `features` VALUES ('10','100+','Muthawiff','user-tie fa-2x','counter','3','active','2025-04-26 11:58:21','2025-04-26 11:58:30'); INSERT INTO `features` VALUES ('11','4.9','Skor Rating','star fa-2x','counter','4','active','2025-04-26 11:58:21','2025-04-26 11:58:32'); -- Table structure for table `gallery` DROP TABLE IF EXISTS `gallery`; CREATE TABLE `gallery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image` varchar(255) NOT NULL, `caption` text DEFAULT NULL, `description` varchar(500) DEFAULT NULL, `status` enum('pending','approved','rejected') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `category` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- Dumping data for table `gallery` INSERT INTO `gallery` VALUES ('1','assets/images/gallery/image1.jpg','Umrah Plus Turkye','','approved','2025-03-18 11:53:04','hajj'); INSERT INTO `gallery` VALUES ('2','assets/images/gallery/image2.jpg','Umrah Plus Turkye','','approved','2025-03-18 11:53:04','umrah'); INSERT INTO `gallery` VALUES ('3','assets/images/gallery/image3.jpg','Umrah Reguler','','approved','2025-03-18 11:53:04','halal-tour'); -- Table structure for table `hotels` DROP TABLE IF EXISTS `hotels`; CREATE TABLE `hotels` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `rating` int(11) NOT NULL, `description` text NOT NULL, `image_url` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- Dumping data for table `hotels` INSERT INTO `hotels` VALUES ('1','Hilton Suites Makkah','Makkah, Saudi Arabia','5','Hotel mewah dengan pemandangan langsung ke Masjidil Haram','assets/images/hotels/hilton-makkah.jpg','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `hotels` VALUES ('2','Le Meridien Madinah','Madinah, Saudi Arabia','5','Hotel bintang 5 dekat dengan Masjid Nabawi','assets/images/hotels/meridien-madinah.jpg','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `hotels` VALUES ('3','Movenpick Istanbul','Istanbul, Turki','5','Hotel mewah di pusat kota Istanbul','assets/images/hotels/movenpick-istanbul.jpg','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `hotels` VALUES ('4','Address Dubai Mall','Dubai, UAE','5','Hotel mewah terintegrasi dengan Dubai Mall','assets/images/hotels/address-dubai.jpg','2025-03-17 22:34:34','2025-03-17 22:34:34'); -- Table structure for table `itineraries` DROP TABLE IF EXISTS `itineraries`; CREATE TABLE `itineraries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `package_id` int(11) NOT NULL, `day` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL, PRIMARY KEY (`id`), KEY `itineraries_ibfk_1` (`package_id`), CONSTRAINT `itineraries_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; -- Dumping data for table `itineraries` INSERT INTO `itineraries` VALUES ('1','1','1','Keberangkatan dari Jakarta','Berkumpul di Bandara Soekarno-Hatta, penerbangan ke Jeddah via Istanbul'); INSERT INTO `itineraries` VALUES ('2','1','2','Tiba di Istanbul','City tour Istanbul, mengunjungi Blue Mosque dan Hagia Sophia'); INSERT INTO `itineraries` VALUES ('3','1','3','Istanbul - Makkah','Penerbangan ke Jeddah, transfer ke Makkah, Umrah pertama'); INSERT INTO `itineraries` VALUES ('4','2','1','Keberangkatan dari Jakarta','Berkumpul di Bandara Soekarno-Hatta, penerbangan langsung ke Jeddah'); INSERT INTO `itineraries` VALUES ('5','2','2','Tiba di Makkah','Transfer ke hotel Makkah, Umrah pertama'); INSERT INTO `itineraries` VALUES ('6','3','1','Keberangkatan dari Jakarta','Berkumpul di Bandara Soekarno-Hatta, penerbangan ke Dubai'); INSERT INTO `itineraries` VALUES ('7','3','2','Dubai City Tour','Mengunjungi Burj Khalifa, Dubai Mall, dan Desert Safari'); INSERT INTO `itineraries` VALUES ('8','4','1','Keberangkatan Ramadhan','Berkumpul di Bandara Soekarno-Hatta, penerbangan langsung ke Jeddah'); INSERT INTO `itineraries` VALUES ('9','4','2','Ibadah di Masjidil Haram','Umrah pertama dan ibadah di Masjidil Haram'); -- Table structure for table `marketing_materials` DROP TABLE IF EXISTS `marketing_materials`; CREATE TABLE `marketing_materials` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `file_size` varchar(255) NOT NULL, `type` enum('PDF','DOC','IMAGE','etc') NOT NULL, `status` enum('active','inactive') DEFAULT 'active', `created_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `drive_link` varchar(255) NOT NULL, `icon_class` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `created_by` (`created_by`), CONSTRAINT `marketing_materials_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- Dumping data for table `marketing_materials` INSERT INTO `marketing_materials` VALUES ('1','Company Profile','Company Profile','2.5 MB','PDF','active',NULL,'2025-04-28 16:58:52','2025-04-28 17:06:10','https://google.drive','fas fa-file-pdf'); -- Table structure for table `newsletter_campaigns` DROP TABLE IF EXISTS `newsletter_campaigns`; CREATE TABLE `newsletter_campaigns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `subject` varchar(255) NOT NULL, `content` text NOT NULL, `status` enum('draft','sent') NOT NULL DEFAULT 'draft', `sent_at` timestamp NULL DEFAULT NULL, `recipients_count` int(11) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; -- Dumping data for table `newsletter_campaigns` INSERT INTO `newsletter_campaigns` VALUES ('1','SERVER MAINTENANCE ','

2313123

','sent','2025-04-27 08:23:16','0','2025-04-27 08:14:14','2025-04-27 08:23:16'); INSERT INTO `newsletter_campaigns` VALUES ('2','SERVER MAINTENANCE ','

asdsad

','sent','2025-04-27 08:27:57','0','2025-04-27 08:27:54','2025-04-27 08:27:57'); INSERT INTO `newsletter_campaigns` VALUES ('3','test','

234

','sent','2025-05-01 08:14:13','0','2025-05-01 08:14:04','2025-05-01 08:14:13'); -- Table structure for table `newsletter_subscribers` DROP TABLE IF EXISTS `newsletter_subscribers`; CREATE TABLE `newsletter_subscribers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, `name` varchar(100) DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4; -- Dumping data for table `newsletter_subscribers` INSERT INTO `newsletter_subscribers` VALUES ('1','erickirwansyah5a@gmail.com','','active','2025-04-27 08:14:05','2025-04-27 08:14:05'); INSERT INTO `newsletter_subscribers` VALUES ('2','meykiardiansyah191@gmail.com','','active','2025-04-30 19:44:52','2025-04-30 19:44:52'); -- Table structure for table `newsletter_tracking` DROP TABLE IF EXISTS `newsletter_tracking`; CREATE TABLE `newsletter_tracking` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` int(11) NOT NULL, `subscriber_id` int(11) NOT NULL, `status` enum('sent','opened','clicked','failed') NOT NULL DEFAULT 'sent', `sent_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `campaign_id` (`campaign_id`), KEY `subscriber_id` (`subscriber_id`), CONSTRAINT `fk_campaign` FOREIGN KEY (`campaign_id`) REFERENCES `newsletter_campaigns` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_subscriber` FOREIGN KEY (`subscriber_id`) REFERENCES `newsletter_subscribers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; -- Dumping data for table `newsletter_tracking` INSERT INTO `newsletter_tracking` VALUES ('1','1','1','failed','2025-04-27 08:23:16'); INSERT INTO `newsletter_tracking` VALUES ('2','2','1','failed','2025-04-27 08:27:57'); INSERT INTO `newsletter_tracking` VALUES ('3','3','1','failed','2025-05-01 08:14:12'); INSERT INTO `newsletter_tracking` VALUES ('4','3','2','failed','2025-05-01 08:14:13'); -- Table structure for table `notification_settings` DROP TABLE IF EXISTS `notification_settings`; CREATE TABLE `notification_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `description` varchar(255) NOT NULL, `value` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; -- Dumping data for table `notification_settings` INSERT INTO `notification_settings` VALUES ('1','pelunasan_umroh','Template notifikasi untuk pelunasan paket umroh','Silakan melakukan pelunasan pembayaran ke:\r\n\r\nBank: [NAMA BANK]\r\nNo. Rekening: [NOMOR REKENING]\r\nAtas Nama: [NAMA PEMILIK REKENING]\r\n\r\n','2025-04-30 15:39:07','2025-04-30 16:08:22'); INSERT INTO `notification_settings` VALUES ('2','dp_umroh','Template notifikasi untuk pembayaran DP umroh','Terima kasih telah melakukan pembayaran DP sebesar {dp_amount} untuk paket umroh {package_name}.\n\nSisa pembayaran: {sisa_pembayaran}\nBatas waktu pelunasan: {batas_pelunasan}','2025-04-30 15:39:07','2025-04-30 15:39:07'); INSERT INTO `notification_settings` VALUES ('3','konfirmasi_booking','Template notifikasi untuk konfirmasi booking','Booking ID: #{booking_id}\nPaket: {package_name}\nTanggal: {tanggal}\nJumlah Peserta: {jumlah_peserta}\nTotal Harga: {total_harga}\nDP (10%): {dp_amount}','2025-04-30 15:39:07','2025-04-30 15:39:07'); INSERT INTO `notification_settings` VALUES ('4','pengingat_pelunasan','Template notifikasi untuk pengingat pelunasan','Assalamualaikum Wr. Wb.\n\nMohon maaf, ini adalah pengingat untuk pelunasan pembayaran paket umroh Anda:\nBooking ID: #{booking_id}\nSisa pembayaran: {sisa_pembayaran}\nBatas waktu: {batas_pelunasan}\n\nSilakan abaikan jika sudah melakukan pembayaran.','2025-04-30 15:39:07','2025-04-30 15:39:07'); -- Table structure for table `notifications` DROP TABLE IF EXISTS `notifications`; CREATE TABLE `notifications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `type` varchar(50) NOT NULL, `title` varchar(255) NOT NULL, `message` text NOT NULL, `is_read` tinyint(1) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=latin1; -- Dumping data for table `notifications` INSERT INTO `notifications` VALUES ('1','1','system','System INFO','Error in package_functions.php:152 - New booking created: ID 2','0','2025-03-18 10:32:01'); INSERT INTO `notifications` VALUES ('2','1','system','System INFO','Error in package-details.php:60 - New booking created: ID 2 for package ID 2','0','2025-03-18 10:32:01'); INSERT INTO `notifications` VALUES ('3','1','system','System INFO','Error in package_functions.php:187 - New booking created: ID 3','0','2025-03-18 10:32:25'); INSERT INTO `notifications` VALUES ('4','1','system','System INFO','Error in package-details.php:60 - New booking created: ID 3 for package ID 2','0','2025-03-18 10:32:25'); INSERT INTO `notifications` VALUES ('5','1','system','System INFO','Error in package_functions.php:187 - New booking created: ID 5','0','2025-03-18 10:33:32'); INSERT INTO `notifications` VALUES ('6','1','system','System INFO','Error in package-details.php:60 - New booking created: ID 5 for package ID 2','0','2025-03-18 10:33:32'); INSERT INTO `notifications` VALUES ('7','1','system','System INFO','Error in package-details.php:60 - New booking created: ID 7 for package ID 2','0','2025-03-18 10:35:36'); INSERT INTO `notifications` VALUES ('8','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:29:48'); INSERT INTO `notifications` VALUES ('9','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:29:48'); INSERT INTO `notifications` VALUES ('10','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:29:48'); INSERT INTO `notifications` VALUES ('11','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:31:02'); INSERT INTO `notifications` VALUES ('12','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:31:02'); INSERT INTO `notifications` VALUES ('13','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:31:02'); INSERT INTO `notifications` VALUES ('14','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:31:03'); INSERT INTO `notifications` VALUES ('15','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:31:03'); INSERT INTO `notifications` VALUES ('16','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:31:03'); INSERT INTO `notifications` VALUES ('17','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:32:43'); INSERT INTO `notifications` VALUES ('18','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:32:43'); INSERT INTO `notifications` VALUES ('19','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:32:43'); INSERT INTO `notifications` VALUES ('20','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:18'); INSERT INTO `notifications` VALUES ('21','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:18'); INSERT INTO `notifications` VALUES ('22','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:33:18'); INSERT INTO `notifications` VALUES ('23','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:21'); INSERT INTO `notifications` VALUES ('24','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:21'); INSERT INTO `notifications` VALUES ('25','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:33:21'); INSERT INTO `notifications` VALUES ('26','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:21'); INSERT INTO `notifications` VALUES ('27','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:21'); INSERT INTO `notifications` VALUES ('28','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:33:21'); INSERT INTO `notifications` VALUES ('29','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:17'); INSERT INTO `notifications` VALUES ('30','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:17'); INSERT INTO `notifications` VALUES ('31','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:17'); INSERT INTO `notifications` VALUES ('32','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('33','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('34','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('35','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('36','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('37','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('38','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('39','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('40','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:18'); INSERT INTO `notifications` VALUES ('41','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('42','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('43','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('44','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('45','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('46','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('47','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('48','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('49','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:19'); INSERT INTO `notifications` VALUES ('50','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:36:56'); INSERT INTO `notifications` VALUES ('51','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:36:56'); INSERT INTO `notifications` VALUES ('52','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:36:56'); INSERT INTO `notifications` VALUES ('53','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:38:45'); INSERT INTO `notifications` VALUES ('54','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:38:45'); INSERT INTO `notifications` VALUES ('55','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:38:45'); INSERT INTO `notifications` VALUES ('56','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:40:19'); INSERT INTO `notifications` VALUES ('57','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:40:19'); INSERT INTO `notifications` VALUES ('58','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:40:19'); INSERT INTO `notifications` VALUES ('59','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:40:42'); INSERT INTO `notifications` VALUES ('60','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:40:42'); INSERT INTO `notifications` VALUES ('61','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:40:42'); INSERT INTO `notifications` VALUES ('62','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:41:31'); INSERT INTO `notifications` VALUES ('63','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:43:49'); INSERT INTO `notifications` VALUES ('64','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:46:04'); INSERT INTO `notifications` VALUES ('65','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:46:06'); INSERT INTO `notifications` VALUES ('66','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:46:47'); INSERT INTO `notifications` VALUES ('67','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 08:10:05'); INSERT INTO `notifications` VALUES ('68','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 10:26:54'); INSERT INTO `notifications` VALUES ('69','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 11:24:46'); INSERT INTO `notifications` VALUES ('70','1','system','Maintenance Mode Update','Website maintenance mode has been disabled by admin','0','2025-04-26 18:41:18'); INSERT INTO `notifications` VALUES ('71','1','system','Maintenance Mode Update','Website maintenance mode has been enabled by admin','0','2025-04-26 18:41:20'); INSERT INTO `notifications` VALUES ('72','1','system','Maintenance Mode Update','Website maintenance mode has been disabled by admin','0','2025-04-26 18:41:20'); INSERT INTO `notifications` VALUES ('73','1','system','Maintenance Mode Update','Website maintenance mode has been enabled by admin','0','2025-04-26 18:41:21'); INSERT INTO `notifications` VALUES ('74','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 18:52:47'); INSERT INTO `notifications` VALUES ('75','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:01:48'); INSERT INTO `notifications` VALUES ('76','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:01:58'); INSERT INTO `notifications` VALUES ('77','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:06:16'); INSERT INTO `notifications` VALUES ('78','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:06:22'); INSERT INTO `notifications` VALUES ('79','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:06:26'); INSERT INTO `notifications` VALUES ('80','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:06:27'); INSERT INTO `notifications` VALUES ('81','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:06:27'); INSERT INTO `notifications` VALUES ('82','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:06:28'); INSERT INTO `notifications` VALUES ('83','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:06:29'); INSERT INTO `notifications` VALUES ('84','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:10:47'); INSERT INTO `notifications` VALUES ('85','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:11:05'); INSERT INTO `notifications` VALUES ('86','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:11:06'); INSERT INTO `notifications` VALUES ('87','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:28:19'); INSERT INTO `notifications` VALUES ('88','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:28:33'); INSERT INTO `notifications` VALUES ('89','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:28:36'); INSERT INTO `notifications` VALUES ('90','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-27 07:29:30'); INSERT INTO `notifications` VALUES ('91','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-28 14:58:38'); -- Table structure for table `package_bookings` DROP TABLE IF EXISTS `package_bookings`; CREATE TABLE `package_bookings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `agent_id` int(11) DEFAULT NULL, `package_id` int(11) NOT NULL, `customer_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(50) NOT NULL, `participants` int(11) NOT NULL, `package_name` varchar(255) NOT NULL, `merchant_ref` varchar(500) NOT NULL, `amount` decimal(10,2) NOT NULL, `payment_status` enum('pending','paid','completed','expired','failed','refunded') DEFAULT 'pending', `payment_proof` varchar(255) DEFAULT NULL, `payment_notes` text DEFAULT NULL, `payment_completed_at` timestamp NULL DEFAULT NULL, `paid_amount` decimal(10,2) DEFAULT 0.00, `payment_method` varchar(50) DEFAULT NULL, `payment_reference` varchar(100) DEFAULT NULL, `reff` varchar(100) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `package_id` (`package_id`), KEY `idx_merchant_ref` (`merchant_ref`), KEY `idx_payment_status` (`payment_status`), KEY `idx_created_at` (`created_at`), CONSTRAINT `package_bookings_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4; -- Dumping data for table `package_bookings` INSERT INTO `package_bookings` VALUES ('1','2','4','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Promo Umroh Haji Ramdhan','0','5000000.00','completed','payment_1_1746013971.jpg','123123','2025-04-30 13:52:51','0.00',NULL,NULL,NULL,'2025-04-30 12:20:43','2025-05-01 08:03:06'); INSERT INTO `package_bookings` VALUES ('2','3','4','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Promo Umroh Haji Ramdhan','werwerwerwerwer','5000000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 12:22:41','2025-04-30 14:06:41'); INSERT INTO `package_bookings` VALUES ('3',NULL,'4','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Promo Umroh Haji Ramdhan','0','5000000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 12:28:17','2025-04-30 12:28:17'); INSERT INTO `package_bookings` VALUES ('4',NULL,'4','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Promo Umroh Haji Ramdhan','0','5000000.00','completed',NULL,'Pelunasan sudah terkonfirmasi','2025-04-30 11:34:54','0.00',NULL,NULL,NULL,'2025-04-30 12:29:12','2025-04-30 17:20:14'); INSERT INTO `package_bookings` VALUES ('5',NULL,'4','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Promo Umroh Haji Ramdhan','BOOK-1745990989-706','5000000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 12:29:49','2025-04-30 12:29:49'); INSERT INTO `package_bookings` VALUES ('6',NULL,'2','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','3','Paket Umroh Ramadhan 1446H Plua Turki','BOOK-1745991166-280','3200000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 12:32:46','2025-04-30 12:32:46'); INSERT INTO `package_bookings` VALUES ('7',NULL,'2','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Paket Umroh Ramadhan 1446H Plua Turki','BOOK-1745991527-965','3200000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 12:38:47','2025-04-30 12:38:47'); INSERT INTO `package_bookings` VALUES ('8',NULL,'3','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','2','Promo Umroh Lancar Ibadah Khusus','BOOK-1745993199-842','3000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 13:06:39','2025-04-30 13:06:39'); INSERT INTO `package_bookings` VALUES ('9',NULL,'2','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Paket Umroh Ramadhan 1446H Plua Turki','BOOK-1745994463-429','3200000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 13:27:43','2025-04-30 13:27:43'); INSERT INTO `package_bookings` VALUES ('10',NULL,'3','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Promo Umroh Lancar Ibadah Khusus','BOOK-1745994540-684','3000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 13:29:00','2025-04-30 13:29:00'); INSERT INTO `package_bookings` VALUES ('11',NULL,'2','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Paket Umroh Ramadhan 1446H Plua Turki','BOOK-1745996118-498','3200000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 13:55:18','2025-04-30 13:55:18'); INSERT INTO `package_bookings` VALUES ('12',NULL,'2','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','1','Paket Umroh Ramadhan 1446H Plua Turki','BOOK-1745996208-102','3200000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 13:56:48','2025-04-30 13:56:48'); INSERT INTO `package_bookings` VALUES ('13',NULL,'4','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','2','Promo Umroh Haji Ramdhan','BOOK-1746017233-748','5000000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 19:47:13','2025-04-30 19:47:13'); INSERT INTO `package_bookings` VALUES ('14',NULL,'4','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','3','Promo Umroh Haji Ramdhan','BOOK-1746017704-333','5000000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 19:55:04','2025-04-30 19:55:04'); INSERT INTO `package_bookings` VALUES ('15',NULL,'4','Meyki Ardiansyah','meykiardiansyah191@gmail.com','085809933656','3','Promo Umroh Haji Ramdhan','BOOK-1746018496-479','5000000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 20:08:16','2025-04-30 20:08:16'); INSERT INTO `package_bookings` VALUES ('16',NULL,'4','test','timkodingcom@gmail.com','082279107372','1','Promo Umroh Haji Ramdhan','BOOK-1746019120-265','5000000.00','pending',NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'2025-04-30 20:18:40','2025-04-30 20:18:40'); INSERT INTO `package_bookings` VALUES ('18','4','4','test','timkodingcom@gmail.com','082112438265','1','Promo Umroh Haji Ramdhan','BOOK-1746060410-444','50000000.00','completed','payment_18_1746061798.png','Pelunasan','2025-05-01 03:09:58','0.00',NULL,NULL,NULL,'2025-05-01 07:46:50','2025-05-01 08:09:58'); -- Table structure for table `package_hotels` DROP TABLE IF EXISTS `package_hotels`; CREATE TABLE `package_hotels` ( `id` int(11) NOT NULL AUTO_INCREMENT, `package_id` int(11) NOT NULL, `hotel_id` int(11) NOT NULL, `nights` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `hotel_id` (`hotel_id`), KEY `package_hotels_ibfk_1` (`package_id`), CONSTRAINT `package_hotels_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE, CONSTRAINT `package_hotels_ibfk_2` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; -- Dumping data for table `package_hotels` INSERT INTO `package_hotels` VALUES ('4','2','1','5'); INSERT INTO `package_hotels` VALUES ('5','2','2','5'); INSERT INTO `package_hotels` VALUES ('6','3','1','5'); INSERT INTO `package_hotels` VALUES ('7','3','2','4'); INSERT INTO `package_hotels` VALUES ('8','3','4','4'); INSERT INTO `package_hotels` VALUES ('9','4','1','8'); INSERT INTO `package_hotels` VALUES ('10','4','2','7'); INSERT INTO `package_hotels` VALUES ('14','1','1','5'); INSERT INTO `package_hotels` VALUES ('15','1','2','4'); INSERT INTO `package_hotels` VALUES ('16','1','3','3'); -- Table structure for table `packages` DROP TABLE IF EXISTS `packages`; CREATE TABLE `packages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `package_type` enum('vip','plus','regular') NOT NULL, `description` text NOT NULL, `duration` int(11) NOT NULL, `price` decimal(12,2) NOT NULL, `departure_date` date NOT NULL, `status` enum('active','inactive') DEFAULT 'active', `category` varchar(255) NOT NULL DEFAULT 'umrah', `image_url` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `hotel_rating` int(11) DEFAULT NULL, `features` text DEFAULT NULL, `rating` decimal(3,1) DEFAULT 0.0 COMMENT 'Average rating from reviews (0-5)', `review_count` int(11) DEFAULT 0 COMMENT 'Number of reviews for this package', `is_featured` tinyint(1) DEFAULT 0 COMMENT 'Whether this package is featured', `departure_city` varchar(100) DEFAULT NULL, `total_seats` int(11) DEFAULT 40, `booked_seats` int(11) DEFAULT 0, `airline` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- Dumping data for table `packages` INSERT INTO `packages` VALUES ('1','Paket Umroh Syawals','vip','Paket Umroh Syawal 1446H','10','40000000.00','2025-07-12','active','umrah','uploads/packages/package_67daaf3d9cb50.jpg','2025-03-17 22:34:34','2025-04-28 18:53:06','3','Hotel Bintang 4,Makan 3x Sehari,Guide Lokal,Tiket Wisata,Transport AC','4.1','83','1','Jakarta','40','13','Garuda Indonesia'); INSERT INTO `packages` VALUES ('2','Paket Umroh Ramadhan 1446H Plua Turki','plus','Paket Umroh Ramadhan 1446H','10','32000000.00','2025-06-20','active','umrah','uploads/packages/package_67daaf706b3de.jpg','2025-03-17 22:34:34','2025-04-28 18:53:15','5','Perlengkapan Umroh,Handling,Pembimbing Berpengalaman,Manasik,Ziarah, Tiket Domestik','4.5','91','0','Jakarta','40','27','Garuda Indonesia'); INSERT INTO `packages` VALUES ('3','Promo Umroh Lancar Ibadah Khusus','regular','Promo Umroh Lancar Ibadah Khusus','9','30000.00','2025-07-12','active','umrah','uploads/packages/package_67daafa3ddab0.jpg','2025-03-17 22:34:34','2025-04-28 18:53:01','4','Free Ziarah Kota Thaif, Fre Lounge (Resto) Bandara Jakarta, Free Hotel 1 Malam Di Jakarta, Free Sertifikat Umroh, Free Perlengkapan Umroh, Free Gamis Premium, Free Kurma 3kg','4.8','87','1','Bengkulu','40','27','Garuda Indonesia'); INSERT INTO `packages` VALUES ('4','Promo Umroh Haji Ramdhan','regular','Promo Umroh Haji Ramdhan 1446H','10','50000000.00','2025-05-17','active','umrah','uploads/packages/package_67daafda2f282.jpg','2025-03-17 22:34:34','2025-04-28 18:53:04','5','Perlengkapan Umroh,Handling,Pembimbing Berpengalaman,Manasik,Ziarah, Tiket Domestik, Ziarah','4.5','17','1','Jakarta','40','17','Emirates'); -- Table structure for table `partners_logos` DROP TABLE IF EXISTS `partners_logos`; CREATE TABLE `partners_logos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image` varchar(255) NOT NULL, `alt_text` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; -- Dumping data for table `partners_logos` INSERT INTO `partners_logos` VALUES ('1','assets/images/partners/iata.png','IATA'); INSERT INTO `partners_logos` VALUES ('2','assets/images/partners/amphuri.png','AMPHURI'); INSERT INTO `partners_logos` VALUES ('3','assets/images/partners/kan.png','KAN'); INSERT INTO `partners_logos` VALUES ('4','assets/images/partners/kemenag.png','Kemenag'); INSERT INTO `partners_logos` VALUES ('5','assets/images/partners/siskopatuh.png','SikoPatuh'); -- Table structure for table `partners_section` DROP TABLE IF EXISTS `partners_section`; CREATE TABLE `partners_section` ( `id` int(11) NOT NULL AUTO_INCREMENT, `enabled` tinyint(1) NOT NULL DEFAULT 1, `title` varchar(255) NOT NULL, `subtitle` varchar(255) NOT NULL, `description` text DEFAULT NULL, `achievement_points` text DEFAULT NULL, `image` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- Dumping data for table `partners_section` INSERT INTO `partners_section` VALUES ('1','1','Mitra Kerja Sama','Dipercaya dan Berizin Resmi','Komitmen Kami untuk Pelayanan Terbaik','[\"Terakreditasi A oleh Kementerian Agama RI\",\"Anggota resmi AMPHURI (Asosiasi Muslim Penyelenggara Haji dan Umrah Republik Indonesia)\",\"Mitra resmi Saudi Tourism Authority\",\"Bersertifikasi IATA untuk standar pelayanan internasional\"]','assets/images/partnership.jpg'); -- Table structure for table `performance_logs` DROP TABLE IF EXISTS `performance_logs`; CREATE TABLE `performance_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `duration` int(11) NOT NULL COMMENT 'Response time in milliseconds', `memory_usage` int(11) NOT NULL COMMENT 'Memory usage in bytes', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_created_at` (`created_at`), KEY `idx_path` (`path`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `performance_logs` INSERT INTO `performance_logs` VALUES ('1','/home','150','1048576','2025-04-26 07:32:38'); INSERT INTO `performance_logs` VALUES ('2','/about','120','1048576','2025-04-26 07:32:38'); INSERT INTO `performance_logs` VALUES ('3','/packages','180','2097152','2025-04-26 07:32:38'); INSERT INTO `performance_logs` VALUES ('4','/contact','100','1048576','2025-04-26 07:32:38'); INSERT INTO `performance_logs` VALUES ('5','/home','150','1048576','2025-04-26 07:38:40'); INSERT INTO `performance_logs` VALUES ('6','/about','120','1048576','2025-04-26 07:38:40'); INSERT INTO `performance_logs` VALUES ('7','/packages','180','2097152','2025-04-26 07:38:40'); INSERT INTO `performance_logs` VALUES ('8','/contact','100','1048576','2025-04-26 07:38:40'); -- Table structure for table `resource_usage_logs` DROP TABLE IF EXISTS `resource_usage_logs`; CREATE TABLE `resource_usage_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `disk_usage_percent` decimal(5,2) NOT NULL, `memory_usage_percent` decimal(5,2) NOT NULL, `cpu_usage_percent` decimal(5,2) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_created_at` (`created_at`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `resource_usage_logs` INSERT INTO `resource_usage_logs` VALUES ('1','65.50','70.20','45.30','2025-04-26 07:32:38'); INSERT INTO `resource_usage_logs` VALUES ('2','66.10','71.50','48.70','2025-04-26 07:32:38'); INSERT INTO `resource_usage_logs` VALUES ('3','65.50','70.20','45.30','2025-04-26 07:38:40'); INSERT INTO `resource_usage_logs` VALUES ('4','66.10','71.50','48.70','2025-04-26 07:38:40'); -- Table structure for table `scheduled_tasks` DROP TABLE IF EXISTS `scheduled_tasks`; CREATE TABLE `scheduled_tasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `frequency` varchar(50) NOT NULL, `last_run` datetime DEFAULT NULL, `next_run` datetime DEFAULT NULL, `active` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; -- Dumping data for table `scheduled_tasks` INSERT INTO `scheduled_tasks` VALUES ('1','Database Backup','Create a backup of the database','daily',NULL,'2025-04-27 07:22:56','1','2025-04-26 07:22:56','2025-04-26 07:22:56'); INSERT INTO `scheduled_tasks` VALUES ('2','Clean Old Logs','Remove logs older than 30 days','weekly',NULL,'2025-05-03 07:22:56','1','2025-04-26 07:22:56','2025-04-26 07:22:56'); INSERT INTO `scheduled_tasks` VALUES ('3','Update Statistics','Update system statistics and analytics','hourly',NULL,'2025-04-26 08:22:56','1','2025-04-26 07:22:56','2025-04-26 07:22:56'); -- Table structure for table `settings` DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `value` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `unique_setting` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=356 DEFAULT CHARSET=latin1; -- Dumping data for table `settings` INSERT INTO `settings` VALUES ('1','company_name','Bismillah Travel','2025-03-17 22:34:34','2025-04-28 14:57:57'); INSERT INTO `settings` VALUES ('2','company_email','info@code80vity.com','2025-03-17 22:34:34','2025-04-26 12:30:52'); INSERT INTO `settings` VALUES ('3','company_phone','+6282112438265','2025-03-17 22:34:34','2025-04-30 17:52:56'); INSERT INTO `settings` VALUES ('4','company_address','Samping Carefour Cibinong, Jl. Raya Bogor, Ciriung, Kec. Cibinong, Kabupaten Bogor, Jawa Barat 16918','2025-03-17 22:34:34','2025-03-19 18:18:25'); INSERT INTO `settings` VALUES ('5','maintenance_mode','0','2025-03-17 22:34:34','2025-04-28 13:40:32'); INSERT INTO `settings` VALUES ('6','booking_reminder_days','7','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `settings` VALUES ('7','payment_reminder_days','3','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `settings` VALUES ('8','document_reminder_days','30','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `settings` VALUES ('9','backup_retention_days','30','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `settings` VALUES ('10','log_retention_days','30','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `settings` VALUES ('11','smtp_host','mail.code80vity.com','2025-03-17 22:34:34','2025-04-26 12:36:49'); INSERT INTO `settings` VALUES ('12','smtp_port','587','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `settings` VALUES ('13','smtp_user','admin@code80vity.com','2025-03-17 22:34:34','2025-04-26 12:37:08'); INSERT INTO `settings` VALUES ('14','smtp_pass','code80vity','2025-03-17 22:34:34','2025-04-26 12:37:10'); INSERT INTO `settings` VALUES ('15','mailchimp_list_id','your-list-id','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `settings` VALUES ('16','stripe_webhook_secret','your-webhook-secret','2025-03-17 22:34:34','2025-03-17 22:34:34'); INSERT INTO `settings` VALUES ('17','business_hours','{\"monday\":\"09:00 - 17:00\",\"tuesday\":\"09:00 - 17:00\",\"wednesday\":\"09:00 - 17:00\",\"thursday\":\"09:00 - 17:00\",\"friday\":\"09:00 - 17:00\",\"saturday\":\"09:00 - 17:00\",\"sunday\":\"09:00 - 17:00\"}','2025-03-18 19:44:03','2025-03-18 19:51:22'); INSERT INTO `settings` VALUES ('18','primary_color','#04b942','2025-03-18 19:44:36','2025-04-25 19:14:21'); INSERT INTO `settings` VALUES ('19','secondary_color','#ffffff','2025-03-18 19:44:36','2025-04-25 19:32:19'); INSERT INTO `settings` VALUES ('20','accent_color','#616161','2025-03-18 19:44:45','2025-04-25 19:37:40'); INSERT INTO `settings` VALUES ('21','site_logo','assets/images/logo.png','2025-03-18 19:46:34','2025-04-25 19:16:30'); INSERT INTO `settings` VALUES ('30','facebook_url','https://facebook.com/code80vity','2025-03-18 19:51:22','2025-03-18 19:51:22'); INSERT INTO `settings` VALUES ('31','twitter_url','https://x.com/code80vity','2025-03-18 19:51:22','2025-03-18 19:51:22'); INSERT INTO `settings` VALUES ('32','instagram_url','https://instagram.com/code80vity','2025-03-18 19:51:22','2025-03-18 19:51:22'); INSERT INTO `settings` VALUES ('33','whatsapp_number','082279107372','2025-03-18 19:51:22','2025-03-18 19:51:22'); INSERT INTO `settings` VALUES ('55','gradient_style','none','2025-03-19 11:29:27','2025-03-19 11:37:00'); INSERT INTO `settings` VALUES ('56','gradient_start_color','#bf953f','2025-03-19 11:29:27','2025-03-19 11:29:27'); INSERT INTO `settings` VALUES ('57','gradient_end_color','#fcf6ba','2025-03-19 11:29:27','2025-03-19 11:29:27'); INSERT INTO `settings` VALUES ('58','gradient_direction','to right','2025-03-19 11:29:27','2025-03-19 11:37:00'); INSERT INTO `settings` VALUES ('87','light_color','#f8f9fa','2025-03-19 11:36:20','2025-03-19 11:36:20'); INSERT INTO `settings` VALUES ('88','dark_color','#1a1f3c','2025-03-19 11:36:20','2025-03-19 11:36:20'); INSERT INTO `settings` VALUES ('311','maintenance_message','We are currently performing maintenance. Please check back later.','2025-04-26 18:41:18','2025-04-26 18:41:18'); INSERT INTO `settings` VALUES ('318','maintenance_allowed_ips','::1','2025-04-26 18:42:46','2025-04-26 18:43:40'); INSERT INTO `settings` VALUES ('320','dark_logo','assets/images/dark_logo.png','2025-03-18 19:46:34','2025-04-26 19:03:19'); -- Table structure for table `system_health_logs` DROP TABLE IF EXISTS `system_health_logs`; CREATE TABLE `system_health_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `check_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Type of health check (disk, memory, database, etc.)', `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Status of the check (healthy, warning, critical)', `message` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`details`)), `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_created_at` (`created_at`), KEY `idx_check_type` (`check_type`), KEY `idx_status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `system_health_logs` INSERT INTO `system_health_logs` VALUES ('1','disk','healthy','Disk usage is within normal limits',NULL,'2025-04-26 07:32:38'); INSERT INTO `system_health_logs` VALUES ('2','memory','warning','Memory usage is approaching limit',NULL,'2025-04-26 07:32:38'); INSERT INTO `system_health_logs` VALUES ('3','database','healthy','Database connection is stable',NULL,'2025-04-26 07:32:38'); INSERT INTO `system_health_logs` VALUES ('4','disk','healthy','Disk usage is within normal limits',NULL,'2025-04-26 07:38:40'); INSERT INTO `system_health_logs` VALUES ('5','memory','warning','Memory usage is approaching limit',NULL,'2025-04-26 07:38:40'); INSERT INTO `system_health_logs` VALUES ('6','database','healthy','Database connection is stable',NULL,'2025-04-26 07:38:40'); -- Table structure for table `system_logs` DROP TABLE IF EXISTS `system_logs`; CREATE TABLE `system_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(50) NOT NULL, `message` text NOT NULL, `level` enum('info','warning','error') NOT NULL DEFAULT 'info', `user_id` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `system_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=latin1; -- Dumping data for table `system_logs` INSERT INTO `system_logs` VALUES ('4','auth','User admin logged in successfully','info','1','2025-03-18 13:10:21'); INSERT INTO `system_logs` VALUES ('5','settings','Added new team member: Meyki Ardiansyah','info','1','2025-03-18 19:24:17'); INSERT INTO `system_logs` VALUES ('6','settings','Updated team member: Nanda Iskandar','info','1','2025-03-18 19:24:36'); INSERT INTO `system_logs` VALUES ('7','settings','Added new team member: Niko Adi Saputra','info','1','2025-03-18 19:25:02'); INSERT INTO `system_logs` VALUES ('8','settings','Added new team member: Besti Neliza Lubis','info','1','2025-03-18 19:25:36'); INSERT INTO `system_logs` VALUES ('9','settings','Added new team member: Esanda Audria','info','1','2025-03-18 19:25:55'); INSERT INTO `system_logs` VALUES ('10','settings','Updated general settings','info','1','2025-03-18 19:51:22'); INSERT INTO `system_logs` VALUES ('11','settings','Updated general settings','info','1','2025-03-18 20:20:24'); INSERT INTO `system_logs` VALUES ('12','packages','Package updated: Promo Khusus Umpast','info','1','2025-03-19 11:04:51'); INSERT INTO `system_logs` VALUES ('13','packages','Package updated: Gebyar Umroh Spesial Milad','info','1','2025-03-19 11:06:04'); INSERT INTO `system_logs` VALUES ('14','packages','Package updated: Paket Umrah Mabrur','info','1','2025-03-19 11:07:13'); INSERT INTO `system_logs` VALUES ('15','packages','Package updated: Paket Umrah Samawa','info','1','2025-03-19 11:07:47'); INSERT INTO `system_logs` VALUES ('16','packages','Package updated: Promo Khusus Umpast','info','1','2025-03-19 11:12:42'); INSERT INTO `system_logs` VALUES ('17','packages','Package updated: Gebyar Umroh Spesial Milad','info','1','2025-03-19 11:14:08'); INSERT INTO `system_logs` VALUES ('18','packages','Package updated: Paket Umrah Mabrur','info','1','2025-03-19 11:16:04'); INSERT INTO `system_logs` VALUES ('19','packages','Package updated: Paket Umrah Samawa','info','1','2025-03-19 11:16:46'); INSERT INTO `system_logs` VALUES ('20','packages','Package updated: Gebyar Umroh Spesial Milad','info','1','2025-03-19 11:17:26'); INSERT INTO `system_logs` VALUES ('21','packages','Package updated: Paket Umrah Mabrur','info','1','2025-03-19 11:17:32'); INSERT INTO `system_logs` VALUES ('22','packages','Package updated: Paket Umrah Samawa','info','1','2025-03-19 11:17:39'); INSERT INTO `system_logs` VALUES ('23','settings','Updated general settings','info','1','2025-03-19 11:29:27'); INSERT INTO `system_logs` VALUES ('24','settings','Updated general settings','info','1','2025-03-19 11:29:46'); INSERT INTO `system_logs` VALUES ('25','settings','Updated general settings','info','1','2025-03-19 11:36:20'); INSERT INTO `system_logs` VALUES ('26','settings','Updated general settings','info','1','2025-03-19 11:37:00'); INSERT INTO `system_logs` VALUES ('27','settings','Updated general settings','info','1','2025-03-19 11:43:57'); INSERT INTO `system_logs` VALUES ('28','settings','Updated team member: Fulan Bin Fulan','info','1','2025-03-19 11:55:21'); INSERT INTO `system_logs` VALUES ('29','settings','Updated team member: Fulan Bin Fulan','info','1','2025-03-19 11:55:33'); INSERT INTO `system_logs` VALUES ('30','settings','Updated team member: Fulan Bin Fulan','info','1','2025-03-19 11:55:42'); INSERT INTO `system_logs` VALUES ('31','settings','Updated team member: Fulan Bin Fulan','info','1','2025-03-19 11:55:55'); INSERT INTO `system_logs` VALUES ('32','settings','Updated general settings','info','1','2025-03-19 18:16:50'); INSERT INTO `system_logs` VALUES ('33','settings','Updated general settings','info','1','2025-03-19 18:17:07'); INSERT INTO `system_logs` VALUES ('34','settings','Updated general settings','info','1','2025-03-19 18:17:42'); INSERT INTO `system_logs` VALUES ('35','settings','Updated general settings','info','1','2025-03-19 18:18:25'); INSERT INTO `system_logs` VALUES ('36','packages','Package updated: Paket Umroh Syawal','info','1','2025-03-19 18:49:11'); INSERT INTO `system_logs` VALUES ('37','packages','Package updated: Paket Umroh Syawal','info','1','2025-03-19 18:49:17'); INSERT INTO `system_logs` VALUES ('38','packages','Package updated: Paket Umroh Ramadhan 1446H','info','1','2025-03-19 18:50:08'); INSERT INTO `system_logs` VALUES ('39','packages','Package updated: Promo Umroh Lancar Ibadah Khusus','info','1','2025-03-19 18:50:59'); INSERT INTO `system_logs` VALUES ('40','packages','Package updated: Promo Umroh Haji Ramdhan','info','1','2025-03-19 18:51:54'); INSERT INTO `system_logs` VALUES ('41','settings','Updated general settings','info','1','2025-03-19 19:04:20'); INSERT INTO `system_logs` VALUES ('47','auth','User admin logged in successfully','info','1','2025-04-25 19:10:03'); INSERT INTO `system_logs` VALUES ('48','settings','Updated general settings','info','1','2025-04-25 19:10:37'); INSERT INTO `system_logs` VALUES ('49','settings','Updated general settings','info','1','2025-04-25 19:12:45'); INSERT INTO `system_logs` VALUES ('50','settings','Updated general settings','info','1','2025-04-25 19:14:21'); INSERT INTO `system_logs` VALUES ('51','settings','Updated general settings','info','1','2025-04-25 19:32:19'); INSERT INTO `system_logs` VALUES ('52','settings','Updated general settings','info','1','2025-04-25 19:32:58'); INSERT INTO `system_logs` VALUES ('53','settings','Updated general settings','info','1','2025-04-25 19:37:40'); INSERT INTO `system_logs` VALUES ('54','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:49:24'); INSERT INTO `system_logs` VALUES ('55','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:49:57'); INSERT INTO `system_logs` VALUES ('56','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:49:58'); INSERT INTO `system_logs` VALUES ('57','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:00'); INSERT INTO `system_logs` VALUES ('58','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:07'); INSERT INTO `system_logs` VALUES ('59','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:32'); INSERT INTO `system_logs` VALUES ('60','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:33'); INSERT INTO `system_logs` VALUES ('61','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:33'); INSERT INTO `system_logs` VALUES ('62','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:34'); INSERT INTO `system_logs` VALUES ('63','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:35'); INSERT INTO `system_logs` VALUES ('64','database','Bookings table created','info',NULL,'2025-04-25 20:59:15'); INSERT INTO `system_logs` VALUES ('65','bookings','Booking updated: ID 0','info',NULL,'2025-04-25 21:00:49'); INSERT INTO `system_logs` VALUES ('66','bookings','Booking updated: ID 0','info',NULL,'2025-04-25 21:00:55'); INSERT INTO `system_logs` VALUES ('67','backup','Created new database backup','info',NULL,'2025-04-26 07:18:42'); INSERT INTO `system_logs` VALUES ('68','backup','Created new database backup','info',NULL,'2025-04-26 10:26:45'); INSERT INTO `system_logs` VALUES ('69','packages','Package updated: Paket Umroh Syawal','info',NULL,'2025-04-26 10:59:30'); INSERT INTO `system_logs` VALUES ('70','packages','Package updated: Paket Umroh Syawals','info',NULL,'2025-04-26 10:59:37'); INSERT INTO `system_logs` VALUES ('71','why_choose_us','Item updated: Berizin Resmi & Profesional','info',NULL,'2025-04-26 11:21:53'); INSERT INTO `system_logs` VALUES ('72','users','New user created: staff','info',NULL,'2025-04-26 17:50:09'); INSERT INTO `system_logs` VALUES ('73','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:04:15'); INSERT INTO `system_logs` VALUES ('74','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:04:21'); INSERT INTO `system_logs` VALUES ('75','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:04:23'); INSERT INTO `system_logs` VALUES ('76','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:04:23'); INSERT INTO `system_logs` VALUES ('77','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:05:38'); INSERT INTO `system_logs` VALUES ('78','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:04'); INSERT INTO `system_logs` VALUES ('79','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:07'); INSERT INTO `system_logs` VALUES ('80','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:07'); INSERT INTO `system_logs` VALUES ('81','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:07'); INSERT INTO `system_logs` VALUES ('82','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:07'); INSERT INTO `system_logs` VALUES ('83','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:18'); INSERT INTO `system_logs` VALUES ('84','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:44'); INSERT INTO `system_logs` VALUES ('85','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:48'); INSERT INTO `system_logs` VALUES ('86','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:50'); INSERT INTO `system_logs` VALUES ('87','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:07:43'); INSERT INTO `system_logs` VALUES ('88','bookings','Booking updated: ID 11','info',NULL,'2025-04-26 18:07:47'); INSERT INTO `system_logs` VALUES ('89','bookings','Booking updated: ID 11','info',NULL,'2025-04-26 18:07:51'); INSERT INTO `system_logs` VALUES ('90','bookings','Booking deleted: ID 11','warning',NULL,'2025-04-26 18:07:56'); INSERT INTO `system_logs` VALUES ('91','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:19:35'); INSERT INTO `system_logs` VALUES ('92','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:19:39'); INSERT INTO `system_logs` VALUES ('93','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:21:46'); INSERT INTO `system_logs` VALUES ('94','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:01'); INSERT INTO `system_logs` VALUES ('95','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:11'); INSERT INTO `system_logs` VALUES ('96','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:11'); INSERT INTO `system_logs` VALUES ('97','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:21'); INSERT INTO `system_logs` VALUES ('98','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:26'); INSERT INTO `system_logs` VALUES ('99','features','New item added: 123','info',NULL,'2025-04-26 18:23:48'); INSERT INTO `system_logs` VALUES ('100','features','New item added: 324','info',NULL,'2025-04-26 18:24:12'); INSERT INTO `system_logs` VALUES ('101','features','New item added: 3453','info',NULL,'2025-04-26 18:24:21'); INSERT INTO `system_logs` VALUES ('102','features','Item updated: 324','info',NULL,'2025-04-26 18:24:50'); INSERT INTO `system_logs` VALUES ('103','features','Item deleted: ID 13','warning',NULL,'2025-04-26 18:25:40'); INSERT INTO `system_logs` VALUES ('104','features','Item deleted: ID 12','warning',NULL,'2025-04-26 18:25:44'); INSERT INTO `system_logs` VALUES ('105','features','Item deleted: ID 14','warning',NULL,'2025-04-26 18:25:47'); INSERT INTO `system_logs` VALUES ('106','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:31:55'); INSERT INTO `system_logs` VALUES ('107','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:32:24'); INSERT INTO `system_logs` VALUES ('108','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:32:59'); INSERT INTO `system_logs` VALUES ('109','users','User updated: ID 2','info',NULL,'2025-04-26 18:33:50'); INSERT INTO `system_logs` VALUES ('110','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:33:53'); INSERT INTO `system_logs` VALUES ('111','users','User details viewed: ID 1','info',NULL,'2025-04-26 18:34:02'); INSERT INTO `system_logs` VALUES ('112','users','User updated: ID 2','info',NULL,'2025-04-26 18:34:13'); INSERT INTO `system_logs` VALUES ('113','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:34:14'); INSERT INTO `system_logs` VALUES ('114','users','User updated: ID 2','info',NULL,'2025-04-26 18:34:16'); INSERT INTO `system_logs` VALUES ('115','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:34:18'); INSERT INTO `system_logs` VALUES ('116','users','User updated: ID 2','info',NULL,'2025-04-26 18:34:20'); INSERT INTO `system_logs` VALUES ('117','users','User updated: ID 2','info',NULL,'2025-04-26 18:36:16'); INSERT INTO `system_logs` VALUES ('118','users','User updated: ID 2','info',NULL,'2025-04-26 18:36:36'); INSERT INTO `system_logs` VALUES ('119','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:36:37'); INSERT INTO `system_logs` VALUES ('120','users','User updated: ID 2','info',NULL,'2025-04-26 18:36:39'); INSERT INTO `system_logs` VALUES ('121','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:36:41'); INSERT INTO `system_logs` VALUES ('122','users','User updated: ID 2','info',NULL,'2025-04-26 18:36:44'); INSERT INTO `system_logs` VALUES ('123','auth','Failed login attempt for username: admin','warning',NULL,'2025-04-26 18:48:09'); INSERT INTO `system_logs` VALUES ('124','auth','Failed login attempt for username: admin','warning',NULL,'2025-04-26 18:48:13'); INSERT INTO `system_logs` VALUES ('125','auth','User admin logged in successfully','info',NULL,'2025-04-26 18:48:19'); INSERT INTO `system_logs` VALUES ('126','backup','Database restored from backup','info',NULL,'2025-04-26 18:51:59'); INSERT INTO `system_logs` VALUES ('127','bookings','New booking added: ERICK IRWANSYAH','info',NULL,'2025-04-26 21:14:13'); INSERT INTO `system_logs` VALUES ('128','bookings','Booking deleted: ID 12','warning',NULL,'2025-04-26 21:15:32'); INSERT INTO `system_logs` VALUES ('129','bookings','New booking added: ERICK IRWANSYAH','info',NULL,'2025-04-26 21:24:15'); INSERT INTO `system_logs` VALUES ('130','auth','User admin logged in successfully','info',NULL,'2025-04-26 21:56:55'); INSERT INTO `system_logs` VALUES ('131','auth','User admin logged in successfully','info',NULL,'2025-04-28 14:54:22'); INSERT INTO `system_logs` VALUES ('132','auth','Failed login attempt for username: admin','warning',NULL,'2025-04-28 15:56:42'); INSERT INTO `system_logs` VALUES ('133','auth','User admin logged in successfully','info',NULL,'2025-04-28 15:56:48'); INSERT INTO `system_logs` VALUES ('134','bookings','Booking updated: ID 18','info',NULL,'2025-04-28 18:00:17'); INSERT INTO `system_logs` VALUES ('135','bookings','Booking updated: ID 18','info',NULL,'2025-04-28 18:03:35'); INSERT INTO `system_logs` VALUES ('136','bookings','Booking updated: ID 18','info',NULL,'2025-04-28 18:07:50'); INSERT INTO `system_logs` VALUES ('137','bookings','Booking updated: ID 18','info',NULL,'2025-04-28 18:08:04'); INSERT INTO `system_logs` VALUES ('138','bookings','Booking updated: ID 18','info',NULL,'2025-04-28 18:08:31'); INSERT INTO `system_logs` VALUES ('139','bookings','Booking updated and commission added: ID 18 - Amount: Rp 1.600.000','info',NULL,'2025-04-28 19:00:57'); INSERT INTO `system_logs` VALUES ('140','bookings','Booking updated and commission added: ID 18 - Amount: Rp 1.600.000','info',NULL,'2025-04-28 19:03:09'); INSERT INTO `system_logs` VALUES ('141','bookings','Booking updated and commission added: ID 18 - Amount: Rp 1.600.000','info',NULL,'2025-04-28 19:05:58'); INSERT INTO `system_logs` VALUES ('142','auth','User admin logged in successfully','info',NULL,'2025-04-30 13:58:03'); INSERT INTO `system_logs` VALUES ('143','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-30 14:01:28'); INSERT INTO `system_logs` VALUES ('144','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-30 14:02:03'); INSERT INTO `system_logs` VALUES ('145','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-30 14:02:20'); INSERT INTO `system_logs` VALUES ('146','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-30 14:02:22'); INSERT INTO `system_logs` VALUES ('147','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-30 14:02:23'); INSERT INTO `system_logs` VALUES ('148','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-30 14:02:36'); INSERT INTO `system_logs` VALUES ('149','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-30 14:02:37'); INSERT INTO `system_logs` VALUES ('150','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-30 14:02:37'); INSERT INTO `system_logs` VALUES ('151','bookings','Booking updated: ID 4','info',NULL,'2025-04-30 14:32:10'); INSERT INTO `system_logs` VALUES ('152','bookings','Booking updated (tanpa agen): ID 4','info',NULL,'2025-04-30 14:35:32'); INSERT INTO `system_logs` VALUES ('153','bookings','Booking updated (tanpa agen): ID 4','info',NULL,'2025-04-30 14:35:46'); INSERT INTO `system_logs` VALUES ('154','bookings','Booking updated and commission added: ID 1 - Amount: Rp 125.000','info',NULL,'2025-04-30 14:41:47'); INSERT INTO `system_logs` VALUES ('155','bookings','Booking updated (tanpa agen): ID 4','info',NULL,'2025-04-30 16:33:29'); INSERT INTO `system_logs` VALUES ('156','bookings','Booking updated (tanpa agen): ID 4','info',NULL,'2025-04-30 16:34:54'); INSERT INTO `system_logs` VALUES ('157','bookings','Booking updated and commission added: ID 1 - Amount: Rp 125.000','info',NULL,'2025-04-30 16:43:07'); INSERT INTO `system_logs` VALUES ('158','bookings','Booking updated and commission added: ID 1 - Amount: Rp 125.000','info',NULL,'2025-04-30 16:44:29'); INSERT INTO `system_logs` VALUES ('159','bookings','Booking updated and commission added: ID 1 - Amount: Rp 1.250.000','info',NULL,'2025-04-30 17:39:26'); INSERT INTO `system_logs` VALUES ('160','bookings','Booking updated and commission added: ID 1 - Amount: Rp 5.000.000','info',NULL,'2025-04-30 17:40:34'); INSERT INTO `system_logs` VALUES ('161','bookings','Booking updated (tanpa agen): ID 1','info',NULL,'2025-04-30 17:42:48'); INSERT INTO `system_logs` VALUES ('162','auth','User admin logged in successfully','info',NULL,'2025-04-30 18:25:17'); INSERT INTO `system_logs` VALUES ('163','bookings','Booking updated and commission added: ID 1 - Amount: Rp 5.000.000','info',NULL,'2025-04-30 18:46:59'); INSERT INTO `system_logs` VALUES ('164','bookings','Booking updated and commission added: ID 1 - Amount: Rp 5.000.000','info',NULL,'2025-04-30 18:48:09'); INSERT INTO `system_logs` VALUES ('165','bookings','Booking updated and commission added: ID 1 - Amount: Rp 5.000.000','info',NULL,'2025-04-30 18:52:51'); INSERT INTO `system_logs` VALUES ('166','bookings','Booking updated (tanpa agen): ID 1','info',NULL,'2025-04-30 18:53:04'); INSERT INTO `system_logs` VALUES ('167','auth','User admin logged in successfully','info',NULL,'2025-04-30 19:39:47'); INSERT INTO `system_logs` VALUES ('168','auth','User admin logged in successfully','info',NULL,'2025-04-30 20:04:45'); INSERT INTO `system_logs` VALUES ('169','auth','User admin logged in successfully','info',NULL,'2025-04-30 20:05:31'); INSERT INTO `system_logs` VALUES ('170','auth','User admin logged in successfully','info',NULL,'2025-04-30 20:09:51'); INSERT INTO `system_logs` VALUES ('171','auth','User admin logged in successfully','info',NULL,'2025-05-01 07:50:42'); INSERT INTO `system_logs` VALUES ('172','bookings','Booking updated (tanpa agen): ID 18','info',NULL,'2025-05-01 07:51:11'); INSERT INTO `system_logs` VALUES ('173','auth','User admin logged in successfully','info',NULL,'2025-05-01 08:00:27'); INSERT INTO `system_logs` VALUES ('174','bookings','Booking updated (tanpa agen): ID 18','info',NULL,'2025-05-01 08:01:47'); INSERT INTO `system_logs` VALUES ('175','bookings','Booking updated (tanpa agen): ID 18','info',NULL,'2025-05-01 08:03:27'); INSERT INTO `system_logs` VALUES ('176','bookings','Booking updated and commission added: ID 18 - Amount: Rp 5.000.000','info',NULL,'2025-05-01 08:09:58'); INSERT INTO `system_logs` VALUES ('177','backup','Created new database backup','info',NULL,'2025-05-01 08:15:22'); -- Table structure for table `task_history` DROP TABLE IF EXISTS `task_history`; CREATE TABLE `task_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `task_id` int(11) DEFAULT NULL, `task_name` varchar(255) NOT NULL, `status` enum('success','failed','running') NOT NULL, `message` text DEFAULT NULL, `duration` int(11) DEFAULT NULL, `executed_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `task_id` (`task_id`), CONSTRAINT `task_history_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `scheduled_tasks` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Table structure for table `team_members` DROP TABLE IF EXISTS `team_members`; CREATE TABLE `team_members` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `position` varchar(100) NOT NULL, `photo` varchar(255) NOT NULL, `facebook` varchar(255) DEFAULT NULL, `instagram` varchar(255) DEFAULT NULL, `linkedin` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- Dumping data for table `team_members` INSERT INTO `team_members` VALUES ('1','Fulan Bin Fulan','Komisaris Utama','assets/images/team/67da4e391c925.jpg','https://facebook.com','https://facebook.com','https://facebook.com','2025-03-18 19:24:17','2025-03-19 11:55:21'); INSERT INTO `team_members` VALUES ('2','Fulan Bin Fulan','Direktur Utama','assets/images/team/67da4e45bdfba.jpg','https://facebook.com','https://facebook.com','https://facebook.com','2025-03-18 19:25:02','2025-03-19 11:55:33'); INSERT INTO `team_members` VALUES ('3','Fulan Bin Fulan','Direktur Pemasaran','assets/images/team/67da4e4ee0459.jpg','https://facebook.com','https://facebook.com','https://facebook.com','2025-03-18 19:25:36','2025-03-19 11:55:42'); INSERT INTO `team_members` VALUES ('4','Fulan Bin Fulan','Direktur Keuangan','assets/images/team/67da4e5b81ea2.jpg','https://facebook.com','https://facebook.com','https://facebook.com','2025-03-18 19:25:55','2025-03-19 11:55:55'); -- Table structure for table `testimonials` DROP TABLE IF EXISTS `testimonials`; CREATE TABLE `testimonials` ( `id` int(11) NOT NULL AUTO_INCREMENT, `package_id` int(11) NOT NULL, `customer_name` varchar(100) NOT NULL, `rating` int(11) NOT NULL, `review` text NOT NULL, `image` varchar(255) DEFAULT NULL, `status` enum('pending','approved','rejected') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `package_id` (`package_id`), CONSTRAINT `testimonials_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- Dumping data for table `testimonials` INSERT INTO `testimonials` VALUES ('1','1','Ahmad Syafiq','5','Alhamdulillah, perjalanan umrah yang sangat berkesan. Pelayanan sangat memuaskan dan pembimbing sangat membantu.',NULL,'approved','2025-03-17 23:15:33'); INSERT INTO `testimonials` VALUES ('2','1','Siti Aminah','4','Pengalaman spiritual yang luar biasa. Hotel dekat dengan Masjidil Haram, sangat memudahkan untuk beribadah.',NULL,'approved','2025-03-17 23:15:33'); INSERT INTO `testimonials` VALUES ('3','1','Muhammad Rizki','5','Terima kasih Arbain Sani Travel. Semua diurus dengan profesional, dari keberangkatan sampai kepulangan.',NULL,'approved','2025-03-17 23:15:33'); -- Table structure for table `users` DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `password` varchar(255) NOT NULL, `role` enum('admin','staff','agent') NOT NULL DEFAULT 'staff', `name` varchar(100) NOT NULL, `email` varchar(100) DEFAULT NULL, `status` enum('active','inactive') NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; -- Dumping data for table `users` INSERT INTO `users` VALUES ('1','admin','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','admin','Administrator','admin@arbainsani.com','active','2025-03-18 13:06:10'); INSERT INTO `users` VALUES ('2','staff','$2y$10$EBBPPxIqbOJ3a7c4ix4FVupzcoonMjlP56sxcgg9G96lmKLc7J9NO','staff','','staff@example.com','active','2025-04-26 17:50:09'); INSERT INTO `users` VALUES ('6','employee','$2y$10$TIAz2iedAySyzhGOedzq3eTJoSC32knHw76/VKikoQPqwH3UVwUsi','agent','erick irwansyah','admin@ymmib.com','active','2025-04-28 14:40:25'); INSERT INTO `users` VALUES ('7','Agen','$2y$10$B84ybe/ms7.F7kteR8CbU.TL5Mb74PrcsTuwOaX39TK3y0UwZgBxe','agent','Agen Travel Umroh','agen@gmail.com','active','2025-04-28 15:25:56'); INSERT INTO `users` VALUES ('8','admin@test.com','$2y$10$vpQwnM/NCGHLl.T/x51bfOUfSvpYyda0vXbo40JTBDTT7/KL67xba','agent','Meyki Ardiansyah','test@gmail.com','active','2025-04-30 19:59:15'); -- Table structure for table `video_gallery` DROP TABLE IF EXISTS `video_gallery`; CREATE TABLE `video_gallery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `video_id` varchar(100) NOT NULL, `duration` varchar(10) DEFAULT NULL, `date_recorded` date DEFAULT NULL, `order_number` int(11) NOT NULL DEFAULT 0, `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- Dumping data for table `video_gallery` INSERT INTO `video_gallery` VALUES ('1','Umroh Plus Dubai','Saksikan perjalanan spiritual jamaah kami mengunjungi tempat-tempat bersejarah Islam sambil menikmati keindahan modern Dubai.','3tprx4h_dZU','12:30','2024-03-01','1','active','2025-04-26 12:19:28','2025-04-26 12:19:28'); INSERT INTO `video_gallery` VALUES ('2','Umroh Plus Turki','Perjalanan umroh dengan tambahan mengunjungi situs-situs bersejarah Islam di Turki.','3tprx4h_dZU','15:45','2024-02-01','2','active','2025-04-26 12:19:28','2025-04-26 12:19:28'); INSERT INTO `video_gallery` VALUES ('3','Umroh Plus Mesir','Dokumentasi perjalanan umroh dengan tambahan mengunjungi peninggalan Islam di Mesir.','3tprx4h_dZU','10:20','2024-01-01','3','active','2025-04-26 12:19:28','2025-04-26 12:19:28'); -- Table structure for table `visitor_logs` DROP TABLE IF EXISTS `visitor_logs`; CREATE TABLE `visitor_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `session_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_created_at` (`created_at`), KEY `idx_ip_address` (`ip_address`), KEY `idx_path` (`path`), KEY `idx_session_id` (`session_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `visitor_logs` INSERT INTO `visitor_logs` VALUES ('1','192.168.1.1',NULL,'/home','session123','2025-04-26 07:32:38'); INSERT INTO `visitor_logs` VALUES ('2','192.168.1.2',NULL,'/about','session456','2025-04-26 07:32:38'); INSERT INTO `visitor_logs` VALUES ('3','192.168.1.1',NULL,'/packages','session123','2025-04-26 07:32:38'); INSERT INTO `visitor_logs` VALUES ('4','192.168.1.1',NULL,'/home','session123','2025-04-26 07:38:40'); INSERT INTO `visitor_logs` VALUES ('5','192.168.1.2',NULL,'/about','session456','2025-04-26 07:38:40'); INSERT INTO `visitor_logs` VALUES ('6','192.168.1.1',NULL,'/packages','session123','2025-04-26 07:38:40'); INSERT INTO `visitor_logs` VALUES ('7','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:05:52'); INSERT INTO `visitor_logs` VALUES ('8','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:05:57'); INSERT INTO `visitor_logs` VALUES ('9','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:06:06'); INSERT INTO `visitor_logs` VALUES ('10','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','/arbainsani/index.php','h6p828635p8vrqk00c7u920aq7','2025-04-27 07:06:17'); -- Table structure for table `why_choose_us` DROP TABLE IF EXISTS `why_choose_us`; CREATE TABLE `why_choose_us` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `description` text NOT NULL, `icon` varchar(100) NOT NULL, `order_number` int(11) NOT NULL DEFAULT 0, `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- Dumping data for table `why_choose_us` INSERT INTO `why_choose_us` VALUES ('1','Berizin Resmi & Profesional','Pemegang lisensi resmi dengan pengalaman bertahun-tahun dalam penyelenggaraan Umrah dan Haji','medal feature-icon','1','active','2025-04-26 11:05:02','2025-04-26 11:36:37'); INSERT INTO `why_choose_us` VALUES ('2','Akomodasi Premium','Menginap di hotel nyaman yang berlokasi strategis dekat dengan tempat suci','hotel feature-icon','2','active','2025-04-26 11:05:02','2025-04-26 11:36:47'); INSERT INTO `why_choose_us` VALUES ('3','Panduan Ahli','Didampingi oleh ulama dan pembimbing berpengalaman selama perjalanan Anda','users feature-icon','3','active','2025-04-26 11:05:02','2025-04-26 11:36:56'); INSERT INTO `why_choose_us` VALUES ('4','Dukungan 24/7','Bantuan dan layanan pelanggan tersedia setiap saat untuk semua kebutuhan Anda','headset feature-icon','4','active','2025-04-26 11:05:02','2025-04-26 11:37:05'); SET FOREIGN_KEY_CHECKS=1;