

-- Bill Payment 

CREATE TABLE `bills` (
  `id` bigint UNSIGNED NOT NULL,
  `bill_service_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `data` json NOT NULL,
  `response_data` text COLLATE utf8mb4_unicode_ci,
  `amount` decimal(10,2) NOT NULL,
  `charge` decimal(10,2) NOT NULL,
  `status` enum('pending','completed','return') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `bill_services` (
  `id` bigint UNSIGNED NOT NULL,
  `api_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'service id from api',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'flutterwave, bloc etc',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` json NOT NULL,
  `data` json NOT NULL,
  `amount` int NOT NULL DEFAULT '0',
  `min_amount` int NOT NULL DEFAULT '0',
  `max_amount` int NOT NULL DEFAULT '0',
  `charge` double NOT NULL DEFAULT '0',
  `charge_type` enum('fixed','percentage','flexible','range') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `plugins` (`id`, `icon`, `type`, `name`, `description`, `data`, `status`, `created_at`, `updated_at`) VALUES
(NULL, 'global/plugin/pusher.png', 'notification', 'Pusher', 'Leader In Realtime Technologies\r\n\r\n\r\n', '{\"pusher_app_id\":\"2082097\",\"pusher_app_key\":\"ba4b4aa844f1b8140ad9\",\"pusher_app_secret\":\"0adc5d9eab8dfd44bd4e\",\"pusher_app_cluster\":\"ap2\"}', '1', NULL, '2025-11-24 17:33:28'),
(NULL, 'global/plugin/flutterwave.png', 'billing_service_provider', 'Flutterwave', 'Bill Payment APIs for Utility Payments.', '{\"secret_key\":\"FLWSECK_TEST-5eb882cefd374a5cb1da8b62d15c18a2-X\",\"currencies\":{\"NGN\":\"100\",\"ZMW\":\"150\",\"KES\":\"200\",\"GHS\":\"250\"}}', '1', '2023-12-19 12:45:26', '2025-07-09 11:32:54');


-- Passcode

ALTER TABLE `users` ADD COLUMN `passcode` TINYINT(1) NOT NULL DEFAULT 0 AFTER `balance`;


-- Landing Pages

TRUNCATE TABLE `landing_pages`;

INSERT INTO `landing_contents` (`id`, `theme`, `icon`, `title`, `description`, `photo`, `type`, `locale_id`, `locale`, `created_at`, `updated_at`) VALUES
(73, 'default', 'global/uploads/landing-list-assets/about/icons//69ukEZNRn6m8y9aQRQ32.png', 'Affiliate System', 'Earn rewards by referring users and partners. Grow your income while helping others experience seamless digital payments.', NULL, 'about', 73, 'en', '2025-04-08 10:27:59', '2025-12-09 05:48:12'),
(74, 'default', 'global/uploads/landing-list-assets/about/icons//CmXulJtkO46dsYcTdwe1.png', 'Withdraw Money', 'Easily transfer your funds to your bank or mobile wallet anytime, anywhere, quickly and securely.', NULL, 'about', 74, 'en', '2025-04-08 10:28:13', '2025-12-09 05:49:18'),
(75, 'default', 'global/uploads/landing-list-assets/about/icons//Jy2ClwuaUEvgZLxPgOfQ.png', 'Digital Platform', 'Experience instant, borderless payments for goods and services with just a few clicks.', NULL, 'about', 75, 'en', '2025-04-08 10:28:27', '2025-12-09 05:50:27'),
(76, 'default', 'global/uploads/images/KqXHqkwcEV3wySFffykW.webp', 'Agent & Merchant', 'Buy crypto using your credit or debit cards, bank transfers, and over 70 other payment methods tailored to suit your individual needs.Buy crypto using credit or debit cards, transfers,an', NULL, 'solutions', 76, 'en', '2025-04-08 11:05:16', '2025-04-28 05:51:02'),
(77, 'default', 'global/uploads/images/Z5jjM1yf5SatnJnxvsCo.webp', 'Internet Retailer & Ecommerce', 'Buy crypto using your credit or debit cards, bank transfers, and over 70 other payment methods tailored to suit your individual needs.Buy crypto using credit or debit cards, transfers,an', NULL, 'solutions', 77, 'en', '2025-04-08 11:05:33', '2025-04-27 09:20:57'),
(78, 'default', 'global/uploads/images/I1IPIeKFR5St3nnEiTo9.webp', 'Digital Payments', 'Buy crypto using your credit or debit cards, bank transfers, and over 70 other payment methods tailored to suit your individual needs.Buy crypto using credit or debit cards, transfers,an', NULL, 'solutions', 78, 'en', '2025-04-08 11:05:58', '2025-04-28 05:50:43'),
(79, 'default', 'global/uploads/images/n1TlRuDDS3U9ZpGAHKNh.webp', 'Affiliate Marketer', 'Buy crypto using your credit or debit cards, bank transfers, and over 70 other payment methods tailored to suit your individual needs.Buy crypto using credit or debit cards, transfers,an', NULL, 'solutions', 79, 'en', '2025-04-08 11:06:11', '2025-04-24 09:54:31'),
(88, 'default', 'global/uploads/landing-list-assets/merchant/icons//PS5q7O18BMOXudASIh8N.webp', 'Multi-Currency Support', 'Accept payments in various cryptocurrencies', NULL, 'merchant', 29, 'en', '2025-03-25 05:37:23', '2025-12-15 06:58:55'),
(89, 'default', 'global/uploads/landing-list-assets/merchant/icons//l9hfRon7Dmk1lAs1sEfV.webp', 'API & Plugins', 'Easy integration with major e-commerce, subscription platforms. online shops etc', NULL, 'merchant', 55, 'en', '2025-03-25 05:38:01', '2025-12-15 07:01:54'),
(90, 'default', 'global/uploads/landing-list-assets/merchant/icons//XyL3HcmpsQNcaDAQWIxV.webp', 'Custom Payment Links', 'Generate links for direct payments', NULL, 'merchant', 56, 'en', '2025-03-25 05:38:20', '2025-12-15 07:02:00'),
(91, 'default', 'global/uploads/landing-list-assets/merchant/icons//hkkw5fEXZOsbq3j1SdO2.webp', 'Instant Payouts', 'Withdraw funds in real-time', NULL, 'merchant', 57, 'en', '2025-03-25 05:38:35', '2025-12-15 07:02:06'),
(97, 'default', 'global/uploads/images/iAfBXIL1Knr3ai9PFXFe.png', 'Total Users', '52220', NULL, 'counter', 97, 'en', '2025-04-28 03:42:41', '2025-12-08 09:26:52'),
(98, 'default', 'global/uploads/landing-list-assets/counter/icons//0vGdVfjTjKCDfZAXHEaJ.png', 'Total Deposit', '25300', NULL, 'counter', 98, 'en', '2025-04-28 03:42:59', '2025-04-28 03:44:05'),
(99, 'default', 'global/uploads/images/EP78i91NKf9ZLArhGCNA.png', 'Total Agents', '250', NULL, 'counter', 99, 'en', '2025-04-28 03:44:20', '2025-04-28 03:44:20'),
(100, 'default', 'global/uploads/images/gvRiQb3F8CRR2OZPXb3h.png', 'Total Merchants', '300', NULL, 'counter', 100, 'en', '2025-04-28 03:44:37', '2025-04-28 03:44:37'),
(101, 'default', 'global/uploads/images/XosUFvm6asjsXa45lu7y.png', 'Register Account', 'By Registering the website you will able to start your operation', NULL, 'howitworks', 101, 'en', '2025-04-28 05:36:07', '2025-04-28 05:36:07'),
(102, 'default', 'global/uploads/images/cuTgwRUhXtZEaUiN1WQb.png', 'Verify Email', 'After creating the account user need to verify the email for account purpose', NULL, 'howitworks', 102, 'en', '2025-04-28 05:36:20', '2025-04-28 05:36:20'),
(103, 'default', 'global/uploads/images/UMjprpq2WKD17WxSJSq4.png', 'Verify KYC', 'Users\' KYC needs to verify to before making any withdrawals', NULL, 'howitworks', 103, 'en', '2025-04-28 05:36:34', '2025-04-28 05:36:34'),
(104, 'default', 'global/uploads/images/tIski8sScfXarKXARa5V.png', 'Deposit Money', 'Users can deposit using any automatic or manual gateways', NULL, 'howitworks', 104, 'en', '2025-04-28 05:37:10', '2025-04-28 05:37:10'),
(105, 'default', 'global/uploads/images/MYPgwN0YLPk5smvXW0UE.png', 'Merchants & Agents', 'User can pay to the merchant and also cashout money from agent.', NULL, 'howitworks', 105, 'en', '2025-04-28 05:37:56', '2025-04-30 16:40:29'),
(106, 'default', 'global/uploads/images/nNWtj0GYodUU3kh9wYb1.png', 'Transfer, Gift, Invoice', 'The user can transfer money to another user. Also, gift creation for other users and redeeming the gift. Also, create an invoice and pay.', NULL, 'howitworks', 106, 'en', '2025-04-28 05:39:32', '2025-04-28 05:39:32'),
(107, 'default', 'global/uploads/images/KvzkrRuf32hqfaE7Jsgh.png', 'Refer To Friends', 'User can refer their friends and get a referral bonus.', NULL, 'howitworks', 107, 'en', '2025-04-28 05:40:40', '2025-04-28 05:40:40'),
(108, 'default', 'global/uploads/images/jZXxwNV06fFDukHUfLUn.png', 'Withdraw & Cash Out', 'User can withdraw their money or cash out from the agent.', NULL, 'howitworks', 108, 'en', '2025-04-28 05:41:30', '2025-04-28 05:41:30'),
(111, 'default', 'global/uploads/landing-list-assets/about/icons//uXYOeuoRtIjTVEcx9ewN.png', 'Secure Transaction', 'Make fast and secure payments to online and offline merchants using your Qunzo balance.', NULL, 'about', 109, 'en', '2025-04-30 16:45:59', '2025-12-09 05:51:49'),
(117, 'default', 'global/uploads/images/hAEdFekUSr0uNSzMvyjG.svg', 'Agent & Merchant', 'Accept and manage payments easily in-store or online — fast, secure, and reliable.', NULL, 'features', 112, 'en', '2025-12-09 06:20:06', '2025-12-09 06:20:06'),
(118, 'default', 'global/uploads/images/aApqTOZi0fKsW0viB7iK.svg', 'Internet Retailer & Ecommerce', 'Power your store with instant, safe online payments that build customer trust.', NULL, 'features', 118, 'en', '2025-12-09 06:21:32', '2025-12-09 06:21:32'),
(119, 'default', 'global/uploads/images/1x0whI9UHTjX5lLjUmT9.svg', 'Digital Payments', 'Send or receive payments instantly safe, seamless, and always available.', NULL, 'features', 119, 'en', '2025-12-09 06:21:45', '2025-12-09 06:21:45'),
(120, 'default', 'global/uploads/images/WrSFo6jH9RNxkcaDPaxp.svg', 'Affiliate Marketer', 'Get paid quickly and securely for every sale or referral, anywhere, anytime.', NULL, 'features', 120, 'en', '2025-12-09 06:21:59', '2025-12-09 06:21:59'),
(121, 'default', NULL, 'How do I create an account?', 'Simply download the Qunzo app or visit our website, click \"Sign Up,\" and follow the registration process. You\'ll need to provide basic information and verify your email/phone number.', NULL, 'faqs', 121, 'en', '2025-12-09 06:43:59', '2025-12-09 06:43:59'),
(122, 'default', NULL, 'What is KYC verification and why is it required?', 'KYC (Know Your Customer) is an identity verification process required for security and regulatory compliance. It helps protect your account and enables higher transaction limits.', NULL, 'faqs', 122, 'en', '2025-12-09 06:44:17', '2025-12-09 06:44:17'),
(123, 'default', NULL, 'Can I have multiple wallets?', 'Yes, Qunzo supports multiple currency wallets. You can create and manage wallets for different currencies within a single account.', NULL, 'faqs', 123, 'en', '2025-12-09 06:44:27', '2025-12-09 06:44:27'),
(124, 'default', NULL, 'What are the transaction fees?', 'Transaction fees vary depending on the type of transaction (transfer, payment, withdrawal, etc.) and the payment method used. You\'ll see the exact fee before confirming any transaction.', NULL, 'faqs', 124, 'en', '2025-12-09 06:44:44', '2025-12-09 06:44:44'),
(125, 'default', NULL, 'Which currencies does Qunzo support?', 'Qunzo supports multiple fiat and cryptocurrencies. The available currencies depend on your region and account type. Check the app for the complete list of supported currencies.', NULL, 'faqs', 125, 'en', '2025-12-09 06:45:11', '2025-12-09 06:45:11'),
(126, 'default', NULL, 'Can I exchange between different currencies?', 'Yes, Qunzo offers currency exchange features allowing you to convert between different currencies in your wallet at competitive rates.', NULL, 'faqs', 126, 'en', '2025-12-09 06:45:24', '2025-12-09 06:45:24'),
(127, 'default', NULL, 'Can I integrate Qunzo with my website?', 'Yes, Qunzo provides API integration and plugins (including WooCommerce) to accept payments on your website or e-commerce platform.', NULL, 'faqs', 127, 'en', '2025-12-09 06:45:41', '2025-12-09 06:45:41'),
(128, 'default', 'global/uploads/landing-list-assets/agent/icons//VUJjfHbOwfOl5x9XmZTU.webp', 'Instant Cash Services', 'Provide fast cash-in and cash-out services to customers using Qunzo wallets.', NULL, 'agent', 59, 'en', '2025-03-25 08:25:04', '2025-12-15 06:49:09'),
(129, 'default', 'global/uploads/landing-list-assets/agent/icons//7qM2wlKOT9BzbLVB7wSS.webp', 'Agent Dashboard', 'Manage transactions, commissions, and balances from one powerful dashboard.', NULL, 'agent', 61, 'en', '2025-03-25 08:25:25', '2025-12-15 06:49:15'),
(130, 'default', 'global/uploads/landing-list-assets/agent/icons//wWlrmBEIzYo9bjAh51w1.webp', 'Cash In & Cash Out Commission', 'Earn commissions on every successful cash-in and cash-out transaction.', NULL, 'agent', 62, 'en', '2025-03-25 08:25:48', '2025-12-15 06:49:21'),
(131, 'default', 'global/uploads/landing-list-assets/agent/icons//hv0OPwj191gegF2AsLKz.webp', 'Secure Transactions', 'All agent activities are protected with advanced security and fraud prevention.', NULL, 'agent', 63, 'en', '2025-03-25 08:26:08', '2025-12-15 06:49:27');

TRUNCATE TABLE `landing_pages`;

INSERT INTO `landing_pages` (`id`, `theme`, `name`, `code`, `data`, `status`, `sort`, `locale`, `created_at`, `updated_at`) VALUES
(25, 'default', 'Hero Section', 'hero', '{\"hero_title\":\"Experience the Power of Modern Payments with [[color_text= Qunzo]].\",\"hero_description\":\"Empower your digital lifestyle with Qunzo, next-generation payments made simple, secure, and borderless for everyone, everywhere.\",\"bonus_text\":\"Fast, secure, and seamless \\u2014 the way payments should be.\",\"bubble_text\":\"Our client satisfy\",\"bubble_counter\":\"80+\",\"image\":\"global\\/uploads\\/landing-contents\\/image\\/UR5j1FsNT9q3ghAzJtDF.jpg\",\"button_label\":\"Get Started\",\"button_url\":\"\\/auth\\/login\",\"button_target\":\"_self\",\"rounded_button_label\":\"About\",\"rounded_button_url\":\"\\/about\",\"rounded_button_target\":\"_blank\",\"rounded_button_image\":\"global\\/uploads\\/landing-contents\\/rounded_button_image\\/OUo5Y0GHyEKzbI80RXAg.png\",\"bubble_image\":\"global\\/uploads\\/landing-contents\\/bubble_image\\/DQHJBD4Mfav5EcWOaQHI.webp\"}', 1, 1, 'en', NULL, '2025-12-17 11:21:43'),
(26, 'default', 'Features Section', 'features', '{\"features_title\":\"Qunzo [[color_text= Features ]]\",\"features_subtitle\":\"Discover how Qunzo makes every transaction faster, safer, and smarter empowering your daily financial activities with ease.\"}', 1, 5, 'en', NULL, '2025-12-10 05:31:10'),
(27, 'default', 'About Section', 'about', '{\"title\":\"[[color_text= What ]]  We Offer\"}', 1, 4, 'en', NULL, '2025-12-10 05:31:10'),
(29, 'default', 'FAQ Section', 'faqs', '{\"faq_title\":\"Frequently Asked [[color_text=Questions]]\",\"faq_subtitle\":\"Find quick answers to common questions about our  Qunzo app.\",\"image\":\"global\\/uploads\\/landing-contents\\/image\\/4E5SZpqjSRqSv6dZ1C3Y.webp\"}', 1, 8, 'en', NULL, '2025-12-10 05:31:10'),
(31, 'default', 'Marketing Section', 'marketing', '{\"merchant_title\":\"Looking for a [[color_text=  Business Account?]]\",\"merchant_subtitle\":\"Accepting payments as a merchant opens up new opportunities for businesses by enabling fast, secure, and borderless transactions.\",\"button_label\":\"Explore\",\"button_url\":\"\\/agent\",\"button_target\":\"_self\",\"agent_title\":\"Looking for a [[color_text=  Agent Account?]]\",\"agent_subtitle\":\"Becoming a payment agent allows individuals and businesses to facilitate digital transactions while earning commissions.\",\"merchant_image\":\"global\\/uploads\\/landing-contents\\/merchant_image\\/SFnga0pevC2Nb6EtBZQ8.svg\",\"agent_image\":\"global\\/uploads\\/landing-contents\\/agent_image\\/A5DK6meMYTr2VEXoPBLN.svg\",\"merchant_button_label\":\"Explore\",\"merchant_button_url\":\"\\/merchant\",\"merchant_button_target\":\"_self\"}', 1, 6, 'en', '2025-03-20 08:07:55', '2025-12-10 05:31:10'),
(33, 'default', 'Testimonial Section', 'testimonial', '{\"testimonial_title\":\"Trusted by Users [[color_text=Worldwide]]\",\"sub_title\":\"Don\'t just take our word for it. Here\'s what our community has to say about their experience.\"}', 1, 9, 'en', '2025-03-20 08:07:55', '2025-12-10 05:31:10'),
(34, 'default', 'Blog Section', 'blog', '{\"blog_title\":\"Our [[color_text=Blogs]]\",\"blog_subtitle\":\"Explore expert tips, platform updates, and the latest trends in digital payments.\"}', 1, 10, 'en', '2025-03-20 08:07:55', '2025-12-10 05:31:10'),
(35, 'default', 'Newsletter Section', 'newsletter', '{\"title\":\"Join With [[color_text= Qunzo ]] Platform\",\"subtitle\":\"Join thousands of users who stay informed about platform updates, new payment gateways, and exclusive promotions.\",\"button_label\":\"Join Now\",\"button_url\":\"\\/register\",\"button_target\":\"_self\"}', 1, 11, 'en', '2025-03-20 08:07:55', '2025-12-10 05:31:10'),
(36, 'default', 'Footer Section\r\n', 'footer', '{\"newsletter_title\":\"Empowering the future of digital payments.\",\"newsletter_sub_title\":\"By subscribing you agree to with our Privacy Policy and provide consent to receive updates from our company.\",\"copyright_text\":\"Qunzo \\u00a9 2025. All rights reserved.\",\"widget_title_1\":\"Company\",\"widget_title_2\":\"Important Links\",\"widget_title_3\":\"Help Center\",\"newsletter_description\":\"Stay updated with the latest in payments, and financial innovation.\",\"footer_bottom_text\":\"Qunzo\"}', 1, 15, 'en', '2022-10-22 07:54:48', '2025-12-17 04:08:33'),
(39, 'default', 'Counter Section', 'counter', '{\"title\":\"We are Helping Customer Globally Every Time\"}', 1, 2, 'en', NULL, '2025-12-10 05:31:10'),
(40, 'default', 'Gateway Section', 'gateway', '{}', 1, 7, 'en', NULL, '2025-12-10 05:31:10'),
(41, 'default', 'How It Works Section', 'howitworks', '{\"title\":\"How It [[color_text= Works]]\",\"subtitle\":\"Discover how Qunzo works\"}', 1, 3, 'en', NULL, '2025-12-10 05:31:10');

TRUNCATE TABLE `navigations`;

INSERT INTO `navigations` (`id`, `page_id`, `name`, `type`, `url`, `footer_position`, `header_position`, `status`, `created_at`, `updated_at`, `translate`) VALUES
(2, 31, 'Contact', '[\"widget_three\", \"widget_two\", \"header\"]', 'contact', 14, 7, 1, '2022-10-24 08:02:26', '2025-12-17 11:34:35', NULL),
(4, 14, 'Privacy', '[\"widget_two\"]', 'privacy-policy', 17, NULL, 1, '2022-10-24 08:05:24', '2025-12-17 11:35:52', NULL),
(11, 32, 'About', '[\"widget_two\", \"header\"]', 'about', NULL, 5, 1, '2022-10-27 09:38:03', '2025-12-17 11:34:27', NULL),
(14, NULL, 'Home', '[\"header\", \"widget_one\"]', '/', NULL, 1, 1, '2022-10-28 02:34:49', '2025-02-04 04:06:02', NULL),
(16, 30, 'Blog', '[\"widget_one\", \"header\"]', 'blog', NULL, 6, 1, '2022-11-16 20:35:57', '2025-12-18 04:33:47', NULL),
(18, NULL, 'Account Login', '[\"widget_one\"]', '/auth/login', 16, NULL, 1, '2022-11-16 18:01:03', '2025-12-17 11:35:05', NULL),
(19, 13, 'Terms and Conditions', '[\"widget_two\"]', 'terms-conditions', 15, NULL, 1, '2022-11-16 18:03:30', '2025-12-17 11:34:47', NULL),
(32, 8, 'Agent', '[\"header\"]', 'agent', 18, 3, 1, '2025-03-24 08:13:48', '2025-04-28 05:03:14', NULL),
(33, 7, 'Merchant', '[\"header\"]', 'merchant', 19, 4, 1, '2025-03-24 08:14:11', '2025-04-28 05:03:14', NULL),
(34, NULL, 'API Documentation', '[\"widget_three\"]', '/api-documentation', 20, NULL, 1, '2025-03-24 08:17:22', '2025-03-24 08:17:22', NULL),
(35, NULL, 'Agent Portal', '[\"widget_one\"]', 'https://qunzo-agent.tdevs.co', 21, NULL, 1, '2025-03-25 08:27:57', '2025-12-18 04:34:37', NULL),
(36, NULL, 'Merchant Portal', '[\"widget_one\"]', 'https://qunzo-merchant.tdevs.co', 22, NULL, 1, '2025-03-25 08:28:16', '2025-12-18 04:34:54', NULL),
(37, 37, 'How It Works', '[\"header\"]', 'how-it-works', 23, 2, 1, '2025-04-28 05:02:58', '2025-12-17 11:35:22', NULL);

TRUNCATE TABLE `pages`;

INSERT INTO `pages` (`id`, `theme`, `title`, `code`, `data`, `type`, `status`, `locale`, `url`, `created_at`, `updated_at`) VALUES
(13, 'default', 'Terms & Conditions', 'terms-conditions', '{\"section_id\":\"[]\",\"meta_keywords\":\"Terms and Conditions\",\"meta_description\":\"Terms and Conditions\",\"content\":\"<p>Welcome to <strong>Qunzo<\\/strong>. By accessing or using our platform, you agree to be bound by the following terms and conditions. Please read them carefully before using any Qunzo services.<\\/p>\\r\\n\\r\\n    <h4>1. Acceptance of Terms<\\/h4>\\r\\n    <p>By registering, accessing, or using Qunzo, you acknowledge that you have read, understood, and agree to comply with these Terms &amp; Conditions. If you do not agree, please discontinue using our services immediately.<\\/p>\\r\\n\\r\\n    <h4>2. Account Responsibilities<\\/h4>\\r\\n    <p>Each user is responsible for maintaining the confidentiality of their account credentials. Any actions taken under your account will be considered authorized by you. Please contact support immediately if you detect unauthorized activity.<\\/p>\\r\\n\\r\\n    <h4>3. Services Overview<\\/h4>\\r\\n    <p><strong>Qunzo<\\/strong> is a smart digital wallet and payment ecosystem designed to simplify financial management. Our key features include:<\\/p>\\r\\n    <ul>\\r\\n        <li>Multi-Wallet System (Main, Savings, Profit, etc.)<\\/li>\\r\\n        <li>Merchant Module for business payments<\\/li>\\r\\n        <li>Agent Module for cash-in and cash-out<\\/li>\\r\\n        <li>Gift Code and Invoice Payment Links<\\/li>\\r\\n        <li>Money Exchange between currencies<\\/li>\\r\\n        <li>Send &amp; Request Money features<\\/li>\\r\\n        <li>QR Code for all wallet operations<\\/li>\\r\\n        <li>Merchant API for developers<\\/li>\\r\\n    <\\/ul>\\r\\n\\r\\n    <h4>4. User Conduct<\\/h4>\\r\\n    <p>You agree not to use Qunzo for any unlawful or fraudulent activities, including but not limited to money laundering, scams, identity theft, or unauthorized access attempts.<\\/p>\\r\\n\\r\\n    <h4>5. Fees and Transactions<\\/h4>\\r\\n    <p>Applicable fees are displayed before confirming any transaction. You agree to review and accept all charges before proceeding. Qunzo reserves the right to modify fees with prior notice.<\\/p>\\r\\n\\r\\n    <h4>6. Refund Policy<\\/h4>\\r\\n    <p>All successful transactions are final. Refunds will only be issued in cases of technical errors or duplicate payments, verified by our system and support team.<\\/p>\\r\\n\\r\\n    <h4>7. Limitation of Liability<\\/h4>\\r\\n    <p>Qunzo is not liable for any indirect, incidental, or consequential damages resulting from service use, data loss, or technical failures, except as required by law.<\\/p>\\r\\n\\r\\n    <h4>8. Privacy Policy<\\/h4>\\r\\n    <p>We value your privacy. Your data is protected and processed in accordance with our <a href=\\\"\\/privacy-policy\\\">Privacy Policy<\\/a>. Qunzo ensures compliance with global data protection standards.<\\/p>\\r\\n\\r\\n    <h4>9. Modification of Terms<\\/h4>\\r\\n    <p>Qunzo reserves the right to update or modify these Terms at any time. Any significant changes will be communicated via email or platform notice. Continued use of Qunzo indicates acceptance of updates.<\\/p>\\r\\n\\r\\n    <h4>10. Suspension and Termination<\\/h4>\\r\\n    <p>Qunzo may suspend or terminate accounts that violate our Terms, engage in suspicious activity, or attempt to exploit system vulnerabilities.<\\/p>\\r\\n\\r\\n    <h4>11. Contact Information<\\/h4>\\r\\n    <p>For questions regarding these Terms &amp; Conditions, don\'t hesitate to get in touch with us at <a href=\\\"mailto:support@qunzo.com\\\">support@qunzo.com<\\/a>.<\\/p>\\r\\n\\r\\n    <p><em>Last Updated: November 1, 2025<\\/em><\\/p>\",\"title\":\"Terms and Conditions\"}', 'static', 1, 'en', 'terms-conditions', '2025-04-05 08:48:43', '2025-11-01 10:41:53'),
(14, 'default', 'Privacy & Policy', 'privacy-policy', '{\"meta_keywords\":\"Privacy & Policy\",\"meta_description\":\"Privacy & Policy\",\"section_id\":\"[]\",\"content\":\"<p>At <strong>Qunzo<\\/strong>, we value your privacy and are committed to protecting your personal data. This Privacy Policy explains how we collect, use, disclose, and safeguard your information when you use our platform and related services.<\\/p>\\r\\n\\r\\n    <h4>1. Information We Collect<\\/h4>\\r\\n    <p>We collect several types of information to provide and improve our services:<\\/p>\\r\\n    <ul>\\r\\n        <li><strong>Personal Information:<\\/strong> Name, email address, phone number, and verification documents (if required).<\\/li>\\r\\n        <li><strong>Financial Information:<\\/strong> Wallet details, transactions, and payment history.<\\/li>\\r\\n        <li><strong>Technical Data:<\\/strong> IP address, browser type, device information, and access timestamps.<\\/li>\\r\\n        <li><strong>Usage Data:<\\/strong> Interactions with our platform, preferences, and behavioral patterns.<\\/li>\\r\\n    <\\/ul>\\r\\n\\r\\n    <h4>2. How We Use Your Information<\\/h4>\\r\\n    <p>We use collected information to:<\\/p>\\r\\n    <ul>\\r\\n        <li>Provide, maintain, and improve Qunzo\\u2019s services.<\\/li>\\r\\n        <li>Process transactions securely and efficiently.<\\/li>\\r\\n        <li>Verify user identity and prevent fraudulent activities.<\\/li>\\r\\n        <li>Send important updates, alerts, and promotional messages (if permitted).<\\/li>\\r\\n        <li>Comply with legal and regulatory requirements.<\\/li>\\r\\n    <\\/ul>\\r\\n\\r\\n    <h4>3. Data Security<\\/h4>\\r\\n    <p>We implement industry-standard security measures, including encryption and access controls, to protect your personal information from unauthorized access, disclosure, or destruction. However, no online system is entirely risk-free, and users share data at their own discretion.<\\/p>\\r\\n\\r\\n    <h4>4. Cookies and Tracking<\\/h4>\\r\\n    <p>Qunzo uses cookies and similar technologies to enhance your browsing experience and analyze platform performance. You may adjust browser settings to reject cookies, but some features may not function properly.<\\/p>\\r\\n\\r\\n    <h4>5. Sharing of Information<\\/h4>\\r\\n    <p>We do not sell or rent user data. However, we may share information with:<\\/p>\\r\\n    <ul>\\r\\n        <li>Trusted service providers assisting in operations (e.g., payment gateways, analytics).<\\/li>\\r\\n        <li>Regulatory authorities, if legally required.<\\/li>\\r\\n        <li>Business partners with user consent or for integrated services.<\\/li>\\r\\n    <\\/ul>\\r\\n\\r\\n    <h4>6. Data Retention<\\/h4>\\r\\n    <p>Your data will be retained as long as necessary to provide services, comply with laws, or resolve disputes. Once no longer needed, we securely delete or anonymize the information.<\\/p>\\r\\n\\r\\n    <h4>7. Your Rights<\\/h4>\\r\\n    <p>You have the right to:<\\/p>\\r\\n    <ul>\\r\\n        <li>Access, review, or correct your personal data.<\\/li>\\r\\n        <li>Request deletion of your data (subject to legal retention requirements).<\\/li>\\r\\n        <li>Withdraw consent for promotional communications.<\\/li>\\r\\n        <li>File a complaint with a data protection authority if you believe your rights are violated.<\\/li>\\r\\n    <\\/ul>\\r\\n\\r\\n    <h4>8. Third-Party Links<\\/h4>\\r\\n    <p>Our platform may include links to third-party websites. Qunzo is not responsible for the privacy practices or content of external sites. We recommend reviewing their privacy policies before providing personal information.<\\/p>\\r\\n\\r\\n    <h4>9. Children\'s Privacy<\\/h4>\\r\\n    <p>Qunzo\\u2019s services are not directed toward individuals under 18 years old. We do not knowingly collect personal data from minors. If you believe we have done so inadvertently, please contact us for removal.<\\/p>\\r\\n\\r\\n    <h4>10. Policy Updates<\\/h4>\\r\\n    <p>We may revise this Privacy Policy periodically. Updates will be posted on this page with a new \\\"Last Updated\\\" date. Continued use of Qunzo after updates means you accept the revised policy.<\\/p>\\r\\n\\r\\n    <h4>11. Contact Us<\\/h4>\\r\\n    <p>If you have any questions or concerns regarding this Privacy Policy, don\'t hesitate to get in touch with us at:<\\/p>\\r\\n    <p><a href=\\\"mailto:support@qunzo.com\\\">support@qunzo.com<\\/a><\\/p>\\r\\n\\r\\n    <p><em>Last Updated: November 1, 2025<\\/em><\\/p>\",\"title\":\"Privacy & Policy\"}', 'static', 1, 'en', 'privacy-policy', '2025-04-05 09:02:29', '2025-11-01 10:42:52'),
(29, 'default', 'Api Documentation', 'api-documentation', '{\"title\":\"API Documentation\",\"meta_keywords\":\"API Documentation\",\"meta_description\":\"API Documentation\",\"section_id\":\"[]\"}', 'static', 1, 'en', 'api-documentation', '2025-04-05 09:02:29', '2025-11-01 08:51:00'),
(30, 'default', 'Blog ', 'blog', '{\"title\":\"All Blogs\",\"meta_keywords\":\"All Blogs\",\"meta_description\":\"All Blogs\",\"section_id\":\"[]\"}', 'static', 1, 'en', 'blog', '2025-01-13 11:10:19', '2025-12-09 09:49:23'),
(31, 'default', 'Contact', 'contact', '{\"title\":\"Contact Us\",\"phone_no\":\"+05555555555\",\"email\":\"contact@qunzo.com\",\"address\":\"2972 Westheimer Rd. Santa Ana, Illinois 85486\",\"meta_keywords\":\"contact us, email\",\"meta_description\":\"Contact\",\"phone_icon\":\"global\\/uploads\\/images\\/ct86uRaB6LjvH9O3ZwuS.svg\",\"email_icon\":\"global\\/uploads\\/images\\/iRMVI9m4woOAUNfoJhkB.svg\",\"address_icon\":\"global\\/uploads\\/images\\/l5ej7KAwWNA0jyhFKmjF.svg\",\"section_id\":\"[]\",\"phone_no_label\":\"Email Address\",\"email_label\":\"Email Address\",\"address_label\":\"Address\",\"form_right_image\":\"global\\/uploads\\/images\\/y6LyUrtki0rCNAd8MYSw.webp\",\"form_title\":\"Contact Information\",\"form_subtitle\":\"Say something to start a conversation!\",\"form_button_text\":\"Send Message\"}', 'static', 1, 'en', 'contact', '2025-01-13 11:10:19', '2025-12-17 04:04:43'),
(32, 'default', 'About', 'about', '{\"title\":\"About Us\",\"content\":\"<p>\\r\\n        We are a modern digital payment platform built to simplify how individuals and businesses\\r\\n        manage money in a fast-moving, borderless world. Our mission is to make financial\\r\\n        transactions seamless, secure, and accessible for everyone.\\r\\n      <\\/p>\\r\\n\\r\\n      <p>\\r\\n        From instant transfers and multi-wallet support to merchant and agent solutions,\\r\\n        our platform is designed with flexibility and performance at its core.\\r\\n        We combine cutting-edge technology with a user-first approach to deliver\\r\\n        reliable financial services you can trust.\\r\\n      <\\/p>\\r\\n\\r\\n      <p>\\r\\n        Whether you are sending money, managing your business payments, or exploring\\r\\n        new digital opportunities, we are committed to empowering your financial journey\\r\\n        with innovation, transparency, and security.\\r\\n      <\\/p>\\r\\n\\r\\n      <ul>\\r\\n        <li>\\u2714 Secure and scalable payment infrastructure<\\/li>\\r\\n        <li>\\u2714 User, merchant, and agent-friendly solutions<\\/li>\\r\\n        <li>\\u2714 Fast, reliable, and borderless transactions<\\/li>\\r\\n        <li>\\u2714 Built for modern digital economies<\\/li>\\r\\n      <\\/ul>\",\"meta_keywords\":\"About Us\",\"meta_description\":\"About Us\",\"section_id\":\"[\\\"27\\\"]\",\"about_title\":\"Who We Are\",\"button_label\":\"Start Your Journey\",\"button_url\":\"\\/login\",\"button_target\":\"_self\",\"right_image\":\"global\\/uploads\\/images\\/N2ltnepgPhrDWzQlv1hE.webp\",\"mission_title\":\"Our Mission\",\"mission_content\":\"At Qunzo, our mission is to simplify global payments through innovation, transparency, and security \\u2014 empowering individuals and businesses to transact freely without borders or hidden barriers.\",\"vision_title\":\"Our Vision\",\"vision_content\":\"We envision a world where financial freedom is accessible to everyone \\u2014 powered by digital currencies, smart technology, and a trusted ecosystem built for growth.\"}', 'static', 1, 'en', 'about', '2025-01-13 11:10:19', '2025-12-15 12:15:24'),
(33, 'default', 'Merchant', 'merchant', '{\"title\":\"Merchant\",\"section_title\":\"Power Your Business with Qunzo\",\"section_subtitle\":\"Instant payments, real-time tracking, and seamless customer checkout.\",\"button_label\":\"Join as Merchant\",\"button_url\":\"\\/merchant\\/register\",\"button_target\":\"_self\",\"content\":\"<h2>Become a Qunzo Merchant<\\/h2>\\r\\n  <p>\\r\\n    Grow your business with Qunzo by accepting fast, secure, and cashless\\r\\n    payments. As a Qunzo merchant, you can receive payments instantly, manage\\r\\n    transactions easily, and provide a smooth checkout experience for your\\r\\n    customers.\\r\\n  <\\/p>\\r\\n\\r\\n  <h3>What Can You Do as a Merchant?<\\/h3>\\r\\n  <ul>\\r\\n    <li><strong>Accept Digital Payments:<\\/strong> Receive payments via QR code, wallet balance, or digital transfer.<\\/li>\\r\\n    <li><strong>Instant Settlement:<\\/strong> Get paid instantly into your Qunzo merchant wallet.<\\/li>\\r\\n    <li><strong>Transaction History:<\\/strong> Track all sales and payments in real time.<\\/li>\\r\\n    <li><strong>Customer Payments:<\\/strong> Accept secure payments from Qunzo users anytime.<\\/li>\\r\\n  <\\/ul>\\r\\n\\r\\n  <h3>Why Choose Qunzo for Your Business?<\\/h3>\\r\\n  <ul>\\r\\n    <li><strong>Faster Payments:<\\/strong> No waiting, no delays \\u2014 instant confirmation.<\\/li>\\r\\n    <li><strong>Lower Costs:<\\/strong> Reduce cash handling and operational expenses.<\\/li>\\r\\n    <li><strong>Secure Transactions:<\\/strong> Protected by advanced security and fraud prevention.<\\/li>\\r\\n    <li><strong>Merchant Dashboard:<\\/strong> Manage payments, balance, and reports from one place.<\\/li>\\r\\n  <\\/ul>\\r\\n\\r\\n  <h3>How It Works<\\/h3>\\r\\n  <ol>\\r\\n    <li>Register for a merchant account<\\/li>\\r\\n    <li>Complete verification and approval<\\/li>\\r\\n    <li>Start accepting digital payments from customers<\\/li>\\r\\n  <\\/ol>\\r\\n\\r\\n  <h3>Who Can Become a Merchant?<\\/h3>\\r\\n  <p>\\r\\n    Retail stores, restaurants, online shops, service providers, and small\\r\\n    businesses can join Qunzo and go fully digital.\\r\\n  <\\/p>\\r\\n\\r\\n  <p>\\r\\n    <strong>Upgrade your business with Qunzo and accept payments smarter.<\\/strong>\\r\\n  <\\/p>\",\"section_id\":\"[]\"}', 'static', 1, 'en', 'merchant', '2025-01-13 11:10:19', '2025-12-15 06:57:41'),
(34, 'default', 'Agent', 'agent', '{\"title\":\"Agent\",\"section_title\":\"Become a Qunzo Agent\",\"button_label\":\"Join as Agent\",\"button_url\":\"\\/agent\\/register\",\"button_target\":\"_self\",\"content\":\"<h2>Become a Qunzo Agent<\\/h2>\\r\\n  <p>\\r\\n    Join Qunzo\\u2019s trusted agent network and earn by providing essential digital\\r\\n    financial services in your community. As an agent, you help customers\\r\\n    deposit, withdraw, and manage their money securely while growing your income.\\r\\n  <\\/p>\\r\\n\\r\\n  <h3>What Can You Do as an Agent?<\\/h3>\\r\\n  <ul>\\r\\n    <li><strong>Cash In &amp; Cash Out:<\\/strong> Help customers deposit or withdraw funds instantly through their Qunzo wallet.<\\/li>\\r\\n    <li><strong>Wallet Transfers:<\\/strong> Assist users with fast and secure wallet-to-wallet transfers.<\\/li>\\r\\n    <li><strong>Bill Payments:<\\/strong> Enable customers to pay utility bills, mobile recharges, and service fees.<\\/li>\\r\\n    <li><strong>Merchant Support:<\\/strong> Help local merchants accept digital payments and manage transactions.<\\/li>\\r\\n  <\\/ul>\\r\\n\\r\\n  <h3>Why Become a Qunzo Agent?<\\/h3>\\r\\n  <ul>\\r\\n    <li><strong>Earn Commission:<\\/strong> Get paid on every successful transaction.<\\/li>\\r\\n    <li><strong>Flexible Income:<\\/strong> Work on your own schedule and increase earnings.<\\/li>\\r\\n    <li><strong>Secure System:<\\/strong> All transactions are protected with advanced security.<\\/li>\\r\\n    <li><strong>Agent Dashboard:<\\/strong> Track balance, earnings, and transactions easily.<\\/li>\\r\\n  <\\/ul>\\r\\n\\r\\n  <h3>How It Works<\\/h3>\\r\\n  <ol>\\r\\n    <li>Apply for an agent account<\\/li>\\r\\n    <li>Complete verification and approval<\\/li>\\r\\n    <li>Start serving customers and earning commissions<\\/li>\\r\\n  <\\/ol>\\r\\n\\r\\n  <h3>Who Can Become an Agent?<\\/h3>\\r\\n  <p>\\r\\n    Shop owners, entrepreneurs, mobile recharge points, and small business\\r\\n    owners can become Qunzo agents and offer trusted financial services.\\r\\n  <\\/p>\\r\\n\\r\\n  <p>\\r\\n    <strong>Start your agent journey today and grow with Qunzo.<\\/strong>\\r\\n  <\\/p>\",\"section_id\":\"[]\",\"widget_title\":\"Start Earning as an Agent Today!\",\"widget_button_label\":\"Login As Agent\",\"widget_button_url\":\"\\/agent\\/login\",\"widget_button_target\":\"_self\",\"section_subtitle\":\"Join Qunzo\\u2019s trusted agent network and earn by providing essential digital financial services in your community. As an agent, you help customers deposit, withdraw, and manage their money securely \\u2014 while growing your own income.\"}', 'static', 1, 'en', 'agent', '2025-01-13 11:10:19', '2025-12-15 06:53:57'),
(37, 'default', 'How It Works', 'how-it-works', '{\"meta_keywords\":\"How It Works\",\"meta_description\":\"How It Works\",\"section_id\":\"[\\\"35\\\"]\",\"content\":\"\",\"title\":\"How It Works\"}', 'static', 1, 'en', 'how-it-works', '2025-04-27 10:13:11', '2025-12-15 06:09:36'),
(38, 'default', 'Custom Page', 'custom-page', '{\"section_id\":\"[]\",\"meta_keywords\":\"\",\"meta_description\":\"\",\"content\":\"<h1>HELLO,<\\/h1>\\r\\n\\r\\n<p><br><i><b>This is test description<\\/b><\\/i><\\/p>\"}', 'dynamic', 1, 'en', 'custom-page', '2025-12-15 09:56:13', '2025-12-15 09:56:53');

TRUNCATE TABLE `testimonials`;

INSERT INTO `testimonials` (`id`, `name`, `designation`, `picture`, `message`, `created_at`, `updated_at`) VALUES
(2, 'Sarah Ahmed', 'Business Owner', 'global/uploads/testimonials/J5n4kkxIjW54grrY2zuH.png', 'Qunzo App makes digital payments unbelievably simple. I can transfer money, pay bills, and withdraw anytime without any hassle.', '2025-12-09 06:51:06', '2025-12-09 06:57:44'),
(3, 'Jonathan Lee', 'Software Engineer', 'global/uploads/testimonials/XRDTdNHbVPcQ5fBpV42U.png', 'The app is fast, secure, and super reliable. Qunzo has become my go-to solution for managing daily financial transactions.', '2025-12-09 06:51:06', '2025-12-09 06:57:57'),
(4, 'Maria Gomez', 'Freelancer', 'global/uploads/testimonials/AOJiM8VoSLzimiowA7O7.png', 'I love how smooth everything works in Qunzo . From sending money to merchants to checking my wallet — everything is instant.', '2025-12-09 06:51:06', '2025-12-09 06:58:14'),
(5, 'David Khan', 'Agency Manager', 'global/uploads/testimonials/IIzOf1Y1LLx9GAivIobH.png', 'Qunzo App helped my business go fully digital. Accepting payments and managing customers is now easier than ever.', '2025-12-09 06:51:06', '2025-12-09 06:58:30'),
(6, 'Emily Carter', 'Marketing Specialist', 'global/uploads/testimonials/AETr79KucoI9kwZBbGLa.png', 'The user interface is clean and easy to understand. Even first-time users can handle transactions effortlessly with Qunzo.', '2025-12-09 06:51:06', '2025-12-09 06:58:43');


