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[<a06db29b04022dfb709f8299f0d9e891><a06db29b04022dfb709f8299f0d9e891>]
>>
startxref
1812
%%EOF

<br />
<b>Warning</b>:  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 <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>128</b><br />
<br />
<b>Warning</b>:  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 <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>129</b><br />
<br />
<b>Warning</b>:  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 <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>130</b><br />
<br />
<b>Warning</b>:  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 <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>131</b><br />
-- Database Backup
-- Generated: 2025-04-26 02:18:42

SET FOREIGN_KEY_CHECKS=0;



-- 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 DEFAULT CHARSET=latin1;



-- Table structure for table `bookings`

DROP TABLE IF EXISTS `bookings`;

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_id` int(11) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `customer_email` varchar(255) NOT NULL,
  `customer_phone` varchar(50) NOT NULL,
  `participants` int(11) NOT NULL DEFAULT 1,
  `booking_date` date NOT NULL,
  `status` enum('pending','confirmed','cancelled') NOT NULL DEFAULT 'pending',
  `notes` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `package_id` (`package_id`),
  CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE
) 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 `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 `package_id` (`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 `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=8 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');



-- Table structure for table `package_bookings`

DROP TABLE IF EXISTS `package_bookings`;

CREATE TABLE `package_bookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  `total_amount` decimal(10,2) NOT NULL,
  `status` enum('pending','confirmed','cancelled') DEFAULT 'pending',
  `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`),
  CONSTRAINT `package_bookings_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

-- Dumping data for table `package_bookings`
INSERT INTO `package_bookings` VALUES ('11','2','ERICK IRWANSYAH','erickirwansyah5a@gmail.com','085809933656','2','70000000.00','pending','2025-03-18 10:47:29','2025-03-18 10:47:29');



-- 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 `package_id` (`package_id`),
  KEY `hotel_id` (`hotel_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=11 DEFAULT CHARSET=latin1;

-- Dumping data for table `package_hotels`
INSERT INTO `package_hotels` VALUES ('1','1','1','5');
INSERT INTO `package_hotels` VALUES ('2','1','2','4');
INSERT INTO `package_hotels` VALUES ('3','1','3','3');
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');



-- 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,
  `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,
  `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 COMMENT 'Hotel star rating (1-5)',
  `features` text DEFAULT NULL COMMENT 'Comma-separated list of package features',
  `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 COMMENT 'City of departure',
  `total_seats` int(11) DEFAULT 40 COMMENT 'Total seats available for the package',
  `booked_seats` int(11) DEFAULT 0 COMMENT 'Number of seats already booked',
  `airline` varchar(100) DEFAULT NULL COMMENT 'Airline used for the package',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table `packages`
INSERT INTO `packages` VALUES ('1','Paket Umroh Syawal','Paket Umroh Syawal 1446H','10','40000000.00','2025-04-15','active','umrah','uploads/packages/package_67daaf3d9cb50.jpg','2025-03-17 22:34:34','2025-03-19 18:49:17','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','Paket Umroh Ramadhan 1446H','10','32000000.00','2025-04-20','active','umrah','uploads/packages/package_67daaf706b3de.jpg','2025-03-17 22:34:34','2025-03-19 18:50:08','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','Promo Umroh Lancar Ibadah Khusus','9','30000.00','2025-05-01','active','umrah','uploads/packages/package_67daafa3ddab0.jpg','2025-03-17 22:34:34','2025-03-19 18:50:59','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','Promo Umroh Haji Ramdhan 1446H','10','50000000.00','2025-03-25','active','umrah','uploads/packages/package_67daafda2f282.jpg','2025-03-17 22:34:34','2025-03-19 18:51:54','5','Perlengkapan Umroh,Handling,Pembimbing Berpengalaman,Manasik,Ziarah, Tiket Domestik, Ziarah','4.5','17','1','Jakarta','40','17','Emirates');



-- 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=310 DEFAULT CHARSET=latin1;

-- Dumping data for table `settings`
INSERT INTO `settings` VALUES ('1','company_name','Awwaliyah Travel','2025-03-17 22:34:34','2025-03-19 18:18:25');
INSERT INTO `settings` VALUES ('2','company_email','info@awwaliyatravel.com','2025-03-17 22:34:34','2025-03-19 18:18:25');
INSERT INTO `settings` VALUES ('3','company_phone','082279107372','2025-03-17 22:34:34','2025-03-19 14:50:35');
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-03-17 22:34:34');
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','smtp.gmail.com','2025-03-17 22:34:34','2025-03-17 22:34:34');
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','noreply@aqmtour.com','2025-03-17 22:34:34','2025-03-19 14:50:42');
INSERT INTO `settings` VALUES ('14','smtp_pass','eW91ci1zbXRwLXBhc3N3b3Jk','2025-03-17 22:34:34','2025-03-17 22:34:34');
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');



-- 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=67 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');



-- 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') NOT NULL DEFAULT 'staff',
  `name` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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','2025-03-18 13:06:10');


SET FOREIGN_KEY_CHECKS=1;