-- https://www.phpmyadmin.net/
--
-- إصدار الخادم: 10.11.14-MariaDB

START TRANSACTION;



--
-- Database: `pioneergym_shapooov_v1`
--

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

--
-- بنية الجدول `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `root_subscription_id` bigint(20) UNSIGNED DEFAULT NULL,
  `parent_subscription_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subscription_no` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(50) NOT NULL,
  `parent_invoice_no` varchar(255) DEFAULT NULL,
  `invoice_kind` enum('sale','adjustment') NOT NULL DEFAULT 'sale',
  `verification_code` varchar(100) DEFAULT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `member_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subscription_type` enum('service','offer') NOT NULL,
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `duration` int(10) UNSIGNED NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `account_user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_methods` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_methods`)),
  `status` enum('new','under_review','approved','rejected') NOT NULL DEFAULT 'under_review',
  `lifecycle_status` enum('active','paused','ended') NOT NULL DEFAULT 'active',
  `generated_reason` enum('pause') DEFAULT NULL,
  `rejection_notes` text DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `root_subscription_id`, `parent_subscription_id`, `subscription_no`, `invoice_no`, `parent_invoice_no`, `invoice_kind`, `verification_code`, `branch_id`, `member_id`, `subscription_type`, `item_id`, `item_name`, `start_date`, `end_date`, `duration`, `price`, `tax`, `discount`, `total`, `created_by`, `account_user_id`, `payment_methods`, `status`, `lifecycle_status`, `generated_reason`, `rejection_notes`, `active`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 1001, 'QRN/2026/M1001', NULL, 'sale', '000076', 1, 4, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 06:30:47', '2026-03-01 09:32:42'),
(2, 2, NULL, 1002, 'QRN/2026/M1002', NULL, 'sale', '000057', 1, 5, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 06:42:49', '2026-03-01 09:32:42'),
(3, 3, NULL, 1003, 'QRN/2026/M1003', NULL, 'sale', '000074', 1, 6, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 06:47:22', '2026-03-01 09:32:42'),
(4, 4, NULL, 1004, 'QRN/2026/M1004', NULL, 'sale', '000100', 1, 7, 'offer', 1, 'عرض المؤسس', '2026-01-22', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 06:53:14', '2026-03-01 09:32:42'),
(5, 5, NULL, 1005, 'QRN/2026/M1005', NULL, 'sale', '000098', 1, 8, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 06:56:50', '2026-03-01 09:32:42'),
(6, 6, NULL, 1006, 'QRN/2026/M1006', NULL, 'sale', '000083', 1, 9, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"3\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:07:14', '2026-03-01 09:32:42'),
(7, 7, NULL, 1007, 'QRN/2026/M1007', NULL, 'sale', '000085', 1, 10, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:11:11', '2026-03-01 09:32:42'),
(8, 8, NULL, 1008, 'QRN/2026/M1008', NULL, 'sale', '000014', 1, 11, 'service', 1, 'اشتراك نصف سنوي', '2026-01-22', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:18:04', '2026-03-01 09:32:42'),
(9, 9, NULL, 1009, 'QRN/2026/M1009', NULL, 'sale', '000094', 1, 12, 'service', 1, 'اشتراك نصف سنوي', '2026-01-22', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:23:56', '2026-03-01 09:32:42'),
(10, 10, NULL, 1010, 'QRN/2026/M1010', NULL, 'sale', '000097', 1, 14, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:27:52', '2026-03-01 09:32:42'),
(11, 11, NULL, 1011, 'QRN/2026/M1011', NULL, 'sale', '000124', 1, 13, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:29:38', '2026-03-01 09:32:42'),
(12, 12, NULL, 1012, 'QRN/2026/M1012', NULL, 'sale', '000125', 1, 15, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:34:04', '2026-03-01 09:32:42'),
(13, 13, NULL, 1013, 'QRN/2026/M1013', NULL, 'sale', '000034', 1, 16, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:37:43', '2026-03-01 09:32:42'),
(14, 14, NULL, 1014, 'QRN/2026/M1014', NULL, 'sale', '000082', 1, 17, 'service', 1, 'اشتراك نصف سنوي', '2026-01-22', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:37:55', '2026-03-01 09:32:42'),
(15, 15, NULL, 1015, 'QRN/2026/M1015', NULL, 'sale', '000035', 1, 18, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:41:21', '2026-03-01 09:32:42'),
(16, 16, NULL, 1016, 'QRN/2026/M1016', NULL, 'sale', '000126', 1, 19, 'service', 2, 'اشتراك سنوي', '2026-01-22', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:41:48', '2026-03-01 09:32:42'),
(17, 17, NULL, 1017, 'QRN/2026/M1017', NULL, 'sale', '000055', 1, 20, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:43:46', '2026-03-01 09:32:42'),
(18, 18, NULL, 1018, 'QRN/2026/M1018', NULL, 'sale', '000127', 1, 21, 'service', 2, 'اشتراك سنوي', '2026-01-22', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:44:39', '2026-03-01 09:32:42'),
(19, 19, NULL, 1019, 'QRN/2026/M1019', NULL, 'sale', '000128', 1, 22, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:46:38', '2026-03-01 09:32:42'),
(20, 20, NULL, 1020, 'QRN/2026/M1020', NULL, 'sale', '000043', 1, 23, 'service', 1, 'اشتراك نصف سنوي', '2026-01-22', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:46:51', '2026-03-01 09:32:42'),
(21, 21, NULL, 1021, 'QRN/2026/M1021', NULL, 'sale', '000129', 1, 24, 'service', 1, 'اشتراك نصف سنوي', '2026-01-22', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:49:58', '2026-03-01 09:32:42'),
(22, 22, NULL, 1022, 'QRN/2026/M1022', NULL, 'sale', '000053', 1, 25, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:51:21', '2026-03-01 09:32:42'),
(23, 23, NULL, 1023, 'QRN/2026/M1023', NULL, 'sale', '000068', 1, 26, 'service', 1, 'اشتراك نصف سنوي', '2026-01-22', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"7\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:54:23', '2026-03-01 09:32:42'),
(24, 24, NULL, 1024, 'QRN/2026/M1024', NULL, 'sale', '000130', 1, 27, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:54:37', '2026-03-01 09:32:42'),
(25, 25, NULL, 1025, 'QRN/2026/M1025', NULL, 'sale', '000059', 1, 28, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 07:58:50', '2026-03-01 09:32:42'),
(26, 26, NULL, 1026, 'QRN/2026/M1026', NULL, 'sale', '000005', 1, 29, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 08:01:41', '2026-03-01 09:32:42'),
(27, 27, NULL, 1027, 'QRN/2026/M1027', NULL, 'sale', '000056', 1, 31, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 08:09:00', '2026-03-01 09:32:42'),
(28, 28, NULL, 1028, 'QRN/2026/M1028', NULL, 'sale', '000131', 1, 32, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 08:11:40', '2026-03-01 09:32:42'),
(29, 29, NULL, 1029, 'QRN/2026/M1029', NULL, 'sale', '000047', 1, 33, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"7\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 08:13:27', '2026-03-01 09:32:42'),
(30, 30, NULL, 1030, 'QRN/2026/M1030', NULL, 'sale', '000029', 1, 34, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-22 08:15:07', '2026-03-01 09:32:42'),
(31, 31, NULL, 1031, 'QRN/2026/M1031', NULL, 'sale', '000015', 1, 63, 'service', 2, 'اشتراك سنوي', '2026-01-24', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 07:02:27', '2026-03-01 09:32:42'),
(32, 32, NULL, 1032, 'QRN/2026/M1032', NULL, 'sale', '000039', 1, 64, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 07:06:36', '2026-03-01 09:32:42'),
(33, 33, NULL, 1033, 'QRN/2026/M1033', NULL, 'sale', '000042', 1, 65, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 07:09:45', '2026-03-01 09:32:42'),
(34, 34, NULL, 1034, 'QRN/2026/M1034', NULL, 'sale', '000132', 1, 67, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 07:16:32', '2026-03-01 09:32:42'),
(35, 35, NULL, 1035, 'QRN/2026/M1035', NULL, 'sale', '000117', 1, 69, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"7\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 07:36:59', '2026-03-01 09:32:42'),
(36, 36, NULL, 1036, 'QRN/2026/M1036', NULL, 'sale', '000001', 1, 71, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"7\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 07:59:04', '2026-03-01 09:32:42'),
(37, 37, NULL, 1037, 'QRN/2026/M1037', NULL, 'sale', '000069', 1, 73, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 08:18:14', '2026-03-01 09:32:42'),
(38, 38, NULL, 1038, 'QRN/2026/M1038', NULL, 'sale', NULL, 1, 78, 'offer', 1, 'عرض المؤسس', '2026-01-24', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 1, 1, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'rejected', 'active', NULL, NULL, 1, '2026-01-24 11:12:14', '2026-03-01 09:32:42'),
(39, 39, NULL, 1039, 'QRN/2026/M1039', NULL, 'sale', '000031', 1, 78, 'offer', 1, 'عرض المؤسس', '2026-01-24', '2028-01-12', 1, 13000.00, 1200.00, 5000.00, 9200.00, 1, 1, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 11:28:42', '2026-03-01 09:32:42'),
(40, 40, NULL, 1040, 'QRN/2026/M1040', NULL, 'sale', '000054', 1, 81, 'offer', 1, 'عرض المؤسس', '2026-01-24', '2028-01-12', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 12:06:55', '2026-03-01 09:32:42'),
(41, 41, NULL, 1041, 'QRN/2026/M1041', NULL, 'sale', '000133', 1, 82, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 12:12:52', '2026-03-01 09:32:42'),
(42, 42, NULL, 1042, 'QRN/2026/M1042', NULL, 'sale', '000037', 1, 83, 'offer', 1, 'عرض المؤسس', '2026-01-24', '2028-01-12', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 12:17:58', '2026-03-01 09:32:42'),
(43, 43, NULL, 1043, 'QRN/2026/M1043', NULL, 'sale', '000050', 1, 30, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 12:40:07', '2026-03-01 09:32:42'),
(44, 44, NULL, 1044, 'QRN/2026/M1044', NULL, 'sale', '000046', 1, 85, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 12:47:19', '2026-03-01 09:32:42'),
(45, 45, NULL, 1045, 'QRN/2026/M1045', NULL, 'sale', '000078', 1, 86, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 12:51:12', '2026-03-01 09:32:42'),
(46, 46, NULL, 1046, 'QRN/2026/M1046', NULL, 'sale', '000080', 1, 87, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"7\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 12:55:23', '2026-03-01 09:32:42'),
(47, 47, NULL, 1047, 'QRN/2026/M1047', NULL, 'sale', '000049', 1, 88, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 13:02:22', '2026-03-01 09:32:42'),
(48, 48, NULL, 1048, 'QRN/2026/M1048', NULL, 'sale', '000134', 1, 89, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 13:06:00', '2026-03-01 09:32:42'),
(49, 49, NULL, 1049, 'QRN/2026/M1049', NULL, 'sale', '000040', 1, 90, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 13:13:18', '2026-03-01 09:32:42'),
(50, 50, NULL, 1050, 'QRN/2026/M1050', NULL, 'sale', '000030', 1, 91, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 13:21:31', '2026-03-01 09:32:42'),
(51, 51, NULL, 1051, 'QRN/2026/M1051', NULL, 'sale', '000004', 1, 93, 'offer', 1, 'عرض المؤسس', '2026-01-24', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 13:53:02', '2026-03-01 09:32:42'),
(52, 52, NULL, 1052, 'QRN/2026/M1052', NULL, 'sale', '000036', 1, 94, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 14:05:35', '2026-03-01 09:32:42'),
(53, 53, NULL, 1053, 'QRN/2026/M1053', NULL, 'sale', '000135', 1, 95, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 14:10:53', '2026-03-01 09:32:42'),
(54, 54, NULL, 1054, 'QRN/2026/M1054', NULL, 'sale', '000013', 1, 97, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 14:14:32', '2026-03-01 09:32:42'),
(55, 55, NULL, 1055, 'QRN/2026/M1055', NULL, 'sale', '000041', 1, 98, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 14:17:57', '2026-03-01 09:32:42'),
(56, 56, NULL, 1056, 'QRN/2026/M1056', NULL, 'sale', '000003', 1, 99, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 14:22:50', '2026-03-01 09:32:42'),
(57, 57, NULL, 1057, 'QRN/2026/M1057', NULL, 'sale', '000136', 1, 103, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 14:40:49', '2026-03-01 09:32:42'),
(58, 58, NULL, 1058, 'QRN/2026/M1058', NULL, 'sale', '000002', 1, 104, 'service', 2, 'اشتراك سنوي', '2026-01-24', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 14:56:44', '2026-03-01 09:32:42'),
(59, 59, NULL, 1059, 'QRN/2026/M1059', NULL, 'sale', '000088', 1, 105, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"7\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 15:09:08', '2026-03-01 09:32:42'),
(60, 60, NULL, 1060, 'QRN/2026/M1060', NULL, 'sale', '000012', 1, 106, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 15:12:38', '2026-03-01 09:32:42'),
(61, 61, NULL, 1061, 'QRN/2026/M1061', NULL, 'sale', '000062', 1, 96, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 15:15:09', '2026-03-01 09:32:42'),
(62, 62, NULL, 1062, 'QRN/2026/M1062', NULL, 'sale', '000060', 1, 107, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 15:16:22', '2026-03-01 09:32:42'),
(63, 63, NULL, 1063, 'QRN/2026/M1063', NULL, 'sale', '000011', 1, 108, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 15:18:41', '2026-03-01 09:32:42'),
(64, 64, NULL, 1064, 'QRN/2026/M1064', NULL, 'sale', '000137', 1, 109, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 15:19:43', '2026-03-01 09:32:42'),
(65, 65, NULL, 1065, 'QRN/2026/M1065', NULL, 'sale', '000138', 1, 110, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 15:26:57', '2026-03-01 09:32:42'),
(66, 66, NULL, 1066, 'QRN/2026/M1066', NULL, 'sale', '000027', 1, 111, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 15:29:27', '2026-03-01 09:32:42'),
(67, 67, NULL, 1067, 'QRN/2026/M1067', NULL, 'sale', '000071', 1, 112, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 16:03:27', '2026-03-01 09:32:42'),
(68, 68, NULL, 1068, 'QRN/2026/M1068', NULL, 'sale', '000084', 1, 113, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 16:06:32', '2026-03-01 09:32:42'),
(69, 69, NULL, 1069, 'QRN/2026/M1069', NULL, 'sale', '000139', 1, 114, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 16:07:31', '2026-03-01 09:32:42'),
(70, 70, NULL, 1070, 'QRN/2026/M1070', NULL, 'sale', '000044', 1, 115, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 16:09:32', '2026-03-01 09:32:42'),
(71, 71, NULL, 1071, 'QRN/2026/M1071', NULL, 'sale', '000140', 1, 116, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 16:10:07', '2026-03-01 09:32:42'),
(72, 72, NULL, 1072, 'QRN/2026/M1072', NULL, 'sale', '000051', 1, 117, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 16:14:49', '2026-03-01 09:32:42'),
(73, 73, NULL, 1073, 'QRN/2026/M1073', NULL, 'sale', '000141', 1, 101, 'offer', 1, 'عرض المؤسس', '2026-01-24', '2028-01-12', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 16:41:02', '2026-03-01 09:32:42'),
(74, 74, NULL, 1074, 'QRN/2026/M1074', NULL, 'sale', '000009', 1, 119, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 16:45:05', '2026-03-01 09:32:42'),
(75, 75, NULL, 1075, 'QRN/2026/M1075', NULL, 'sale', '000023', 1, 120, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 17:03:58', '2026-03-01 09:32:42'),
(76, 76, NULL, 1076, 'QRN/2026/M1076', NULL, 'sale', '000142', 1, 121, 'offer', 1, 'عرض المؤسس', '2026-01-24', '2028-01-12', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 17:47:17', '2026-03-01 09:32:42'),
(77, 77, NULL, 1077, 'QRN/2026/M1077', NULL, 'sale', '000061', 1, 118, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-24 21:30:59', '2026-03-01 09:32:42'),
(78, 78, NULL, 1078, 'QRN/2026/M1078', NULL, 'sale', '000026', 1, 124, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 01:48:39', '2026-03-01 09:32:42'),
(79, 79, NULL, 1079, 'QRN/2026/M1079', NULL, 'sale', '000143', 1, 125, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 01:56:31', '2026-03-01 09:32:42'),
(80, 80, NULL, 1080, 'QRN/2026/M1080', NULL, 'sale', '000006', 1, 130, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 06:06:03', '2026-03-01 09:32:42'),
(81, 81, NULL, 1081, 'QRN/2026/M1081', NULL, 'sale', '000007', 1, 131, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 06:09:21', '2026-03-01 09:32:42'),
(82, 82, NULL, 1082, 'QRN/2026/M1082', NULL, 'sale', '000008', 1, 132, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 06:20:04', '2026-03-01 09:32:42'),
(83, 83, NULL, 1083, 'QRN/2026/M1083', NULL, 'sale', '000010', 1, 133, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 06:43:19', '2026-03-01 09:32:42'),
(84, 84, NULL, 1084, 'QRN/2026/M1084', NULL, 'sale', '000018', 1, 136, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 07:38:41', '2026-03-01 09:32:42'),
(85, 85, NULL, 1085, 'QRN/2026/M1085', NULL, 'sale', '000019', 1, 137, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 07:39:15', '2026-03-01 09:32:42'),
(86, 86, NULL, 1086, 'QRN/2026/M1086', NULL, 'sale', '000020', 1, 140, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 08:13:18', '2026-03-01 09:32:42'),
(87, 87, NULL, 1087, 'QRN/2026/M1087', NULL, 'sale', '000021', 1, 143, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 09:16:20', '2026-03-01 09:32:42'),
(88, 88, NULL, 1088, 'QRN/2026/M1088', NULL, 'sale', '000024', 1, 46, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 09:32:01', '2026-03-01 09:32:42'),
(89, 89, NULL, 1089, 'QRN/2026/M1089', NULL, 'sale', '000028', 1, 145, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 09:45:25', '2026-03-01 09:32:42'),
(90, 90, NULL, 1090, 'QRN/2026/M1090', NULL, 'sale', '000017', 1, 19, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 09:51:28', '2026-03-01 09:32:42'),
(91, 91, NULL, 1091, 'QRN/2026/M1091', NULL, 'sale', '000022', 1, 146, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 09:56:26', '2026-03-01 09:32:42'),
(92, 92, NULL, 1092, 'QRN/2026/M1092', NULL, 'sale', '000016', 1, 148, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 10:21:33', '2026-03-01 09:32:42'),
(93, 93, NULL, 1093, 'QRN/2026/M1093', NULL, 'sale', '000025', 1, 149, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 10:31:30', '2026-03-01 09:32:42'),
(94, 94, NULL, 1094, 'QRN/2026/M1094', NULL, 'sale', '000032', 1, 150, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 11:25:02', '2026-03-01 09:32:42'),
(95, 95, NULL, 1095, 'QRN/2026/M1095', NULL, 'sale', '000033', 1, 152, 'offer', 1, 'عرض المؤسس', '2026-01-27', '2028-01-26', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 11:33:14', '2026-03-01 09:32:42'),
(96, 96, NULL, 1096, 'QRN/2026/M1096', NULL, 'sale', '000048', 1, 153, 'service', 2, 'اشتراك سنوي', '2026-01-25', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 12:32:10', '2026-03-01 09:32:42'),
(97, 97, NULL, 1097, 'QRN/2026/M1097', NULL, 'sale', '000045', 1, 15, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 12:40:30', '2026-03-01 09:32:42'),
(98, 98, NULL, 1098, 'QRN/2026/M1098', NULL, 'sale', '000038', 1, 155, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 12:50:43', '2026-03-01 09:32:42'),
(99, 99, NULL, 1099, 'QRN/2026/M1099', NULL, 'sale', '000110', 1, 158, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2027-01-18', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 13:57:03', '2026-03-01 09:32:42'),
(100, 100, NULL, 1100, 'QRN/2026/M1100', NULL, 'sale', '000063', 1, 160, 'service', 1, 'اشتراك نصف سنوي', '2026-01-26', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 14:10:44', '2026-03-01 09:32:42'),
(101, 101, NULL, 1101, 'QRN/2026/M1101', NULL, 'sale', '000067', 1, 161, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 14:13:44', '2026-03-01 09:32:42'),
(102, 102, NULL, 1102, 'QRN/2026/M1102', NULL, 'sale', '000065', 1, 13, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 15:21:11', '2026-03-01 09:32:42'),
(103, 103, NULL, 1103, 'QRN/2026/M1103', NULL, 'sale', '000064', 1, 163, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2028-01-24', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-25 15:33:50', '2026-03-01 09:32:42'),
(104, 104, NULL, 1104, 'QRN/2026/M1104', NULL, 'sale', '000073', 1, 167, 'offer', 1, 'عرض المؤسس', '2026-01-26', '2028-01-25', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 15:44:29', '2026-03-01 09:32:42'),
(105, 105, NULL, 1105, 'QRN/2026/M1105', NULL, 'sale', '000058', 1, 168, 'offer', 1, 'عرض المؤسس', '2026-01-26', '2028-01-25', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 15:47:14', '2026-03-01 09:32:42'),
(106, 106, NULL, 1106, 'QRN/2026/M1106', NULL, 'sale', '000066', 1, 166, 'offer', 1, 'عرض المؤسس', '2026-01-25', '2028-01-24', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 15:47:59', '2026-03-01 09:32:42'),
(107, 107, NULL, 1107, 'QRN/2026/M1107', NULL, 'sale', '000070', 1, 169, 'service', 1, 'اشتراك نصف سنوي', '2026-01-25', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-25 19:13:22', '2026-03-01 09:32:42'),
(108, 108, NULL, 1108, 'QRN/2026/M1108', NULL, 'sale', '000052', 1, 172, 'offer', 2, 'عرض الأصدقاء', '2026-01-26', '2027-01-19', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-26 05:03:10', '2026-03-01 09:32:42'),
(109, 109, NULL, 1109, 'QRN/2026/M1109', NULL, 'sale', '000075', 1, 176, 'offer', 1, 'عرض المؤسس', '2026-01-26', '2028-01-25', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"7\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-26 06:42:32', '2026-03-01 09:32:42'),
(110, 110, NULL, 1110, 'QRN/2026/M1110', NULL, 'sale', '000072', 1, 177, 'service', 1, 'اشتراك نصف سنوي', '2026-01-26', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-26 06:46:13', '2026-03-01 09:32:42'),
(111, 111, NULL, 1111, 'QRN/2026/M1111', NULL, 'sale', '000077', 1, 180, 'offer', 1, 'عرض المؤسس', '2026-01-26', '2028-01-25', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"7\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-26 08:25:21', '2026-03-01 09:32:42'),
(112, 112, NULL, 1112, 'QRN/2026/M1112', NULL, 'sale', '000099', 1, 184, 'service', 1, 'اشتراك نصف سنوي', '2026-01-26', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-26 09:20:34', '2026-03-01 09:32:42'),
(113, 113, NULL, 1113, 'QRN/2026/M1113', NULL, 'sale', '000087', 1, 186, 'offer', 1, 'عرض المؤسس', '2026-01-26', '2028-01-25', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-26 11:16:46', '2026-03-01 09:32:42'),
(114, 114, NULL, 1114, 'QRN/2026/M1114', NULL, 'sale', '000086', 1, 50, 'offer', 1, 'عرض المؤسس', '2026-01-26', '2028-01-25', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-26 11:24:39', '2026-03-01 09:32:42'),
(115, 115, NULL, 1115, 'QRN/2026/M1115', NULL, 'sale', '000081', 1, 192, 'service', 2, 'اشتراك سنوي', '2026-01-26', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-26 14:05:58', '2026-03-01 09:32:42'),
(116, 116, NULL, 1116, 'QRN/2026/M1116', NULL, 'sale', '000079', 1, 194, 'service', 1, 'اشتراك نصف سنوي', '2026-01-26', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-26 15:18:27', '2026-03-01 09:32:42'),
(117, 117, NULL, 1117, 'QRN/2026/M1117', NULL, 'sale', '000111', 1, 195, 'offer', 2, 'عرض الأصدقاء', '2026-01-26', '2027-01-19', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-26 16:50:21', '2026-03-01 09:32:42'),
(118, 118, NULL, 1118, 'QRN/2026/M1118', NULL, 'sale', '000104', 1, 197, 'offer', 2, 'عرض الأصدقاء', '2026-01-26', '2027-01-19', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-26 17:03:59', '2026-03-01 09:32:42'),
(119, 119, NULL, 1119, 'QRN/2026/M1119', NULL, 'sale', '000105', 1, 200, 'offer', 2, 'عرض الأصدقاء', '2026-01-27', '2027-01-20', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-27 00:17:41', '2026-03-01 09:32:42'),
(120, 120, NULL, 1120, 'QRN/2026/M1120', NULL, 'sale', '000096', 1, 205, 'service', 1, 'اشتراك نصف سنوي', '2026-01-27', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-27 05:20:35', '2026-03-01 09:32:42'),
(121, 121, NULL, 1121, 'QRN/2026/M1121', NULL, 'sale', '000095', 1, 206, 'service', 1, 'اشتراك نصف سنوي', '2026-01-27', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-27 06:22:31', '2026-03-01 09:32:42'),
(122, 122, NULL, 1122, 'QRN/2026/M1122', NULL, 'sale', '000089', 1, 209, 'service', 2, 'اشتراك سنوي', '2026-01-27', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-27 08:38:25', '2026-03-01 09:32:42'),
(123, 123, NULL, 1123, 'QRN/2026/M1123', NULL, 'sale', '000092', 1, 218, 'service', 2, 'اشتراك سنوي', '2026-02-03', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-27 11:25:30', '2026-03-01 09:32:42'),
(124, 124, NULL, 1124, 'QRN/2026/M1124', NULL, 'sale', '000093', 1, 219, 'service', 1, 'اشتراك نصف سنوي', '2026-01-27', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-27 11:58:23', '2026-03-01 09:32:42'),
(125, 125, NULL, 1125, 'QRN/2026/M1125', NULL, 'sale', '000106', 1, 222, 'offer', 3, 'عرض ابوربيعة', '2026-01-27', '2027-01-20', 1, 5999.00, 449.93, 2999.50, 3449.43, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"3449.43\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-27 12:55:43', '2026-03-01 09:32:42'),
(126, 126, NULL, 1126, 'QRN/2026/M1126', NULL, 'sale', '000107', 1, 223, 'offer', 3, 'عرض ابوربيعة', '2026-01-27', '2027-01-20', 1, 5999.00, 449.93, 2999.50, 3449.43, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"3449.43\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-27 12:56:55', '2026-03-01 09:32:42'),
(127, 127, NULL, 1127, 'QRN/2026/M1127', NULL, 'sale', '000206', 1, 147, 'service', 1, 'اشتراك نصف سنوي', '2026-01-28', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-27 14:35:17', '2026-03-01 09:32:42'),
(128, 128, NULL, 1128, 'QRN/2026/M1128', NULL, 'sale', '000090', 1, 232, 'offer', 2, 'عرض الأصدقاء', '2026-01-28', '2027-01-21', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-28 05:44:57', '2026-03-01 09:32:42'),
(129, 129, NULL, 1129, 'QRN/2026/M1129', NULL, 'sale', '000091', 1, 235, 'service', 2, 'اشتراك سنوي', '2026-01-28', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-28 06:42:33', '2026-03-01 09:32:42'),
(130, 130, NULL, 1130, 'QRN/2026/M1130', NULL, 'sale', '000173', 1, 246, 'service', 2, 'اشتراك سنوي', '2026-01-28', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-28 11:55:02', '2026-03-01 09:32:42'),
(131, 131, NULL, 1131, 'QRN/2026/M1131', NULL, 'sale', '000112', 1, 249, 'offer', 2, 'عرض الأصدقاء', '2026-01-28', '2027-01-21', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-28 12:58:11', '2026-03-01 09:32:42'),
(132, 132, NULL, 1132, 'QRN/2026/M1132', NULL, 'sale', '000174', 1, 188, 'service', 1, 'اشتراك نصف سنوي', '2026-01-28', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-28 15:17:59', '2026-03-01 09:32:42'),
(133, 133, NULL, 1133, 'QRN/2026/M1133', NULL, 'sale', '000175', 1, 255, 'offer', 1, 'عرض المؤسس', '2026-01-28', '2028-01-27', 1, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-28 16:27:37', '2026-03-01 09:32:42'),
(134, 134, NULL, 1134, 'QRN/2026/M1134', NULL, 'sale', '000103', 1, 258, 'service', 2, 'اشتراك سنوي', '2026-01-29', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-29 02:08:49', '2026-03-01 09:32:42'),
(135, 135, NULL, 1135, 'QRN/2026/M1135', NULL, 'sale', '000101', 1, 259, 'service', 2, 'اشتراك سنوي', '2026-01-29', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-29 04:10:26', '2026-03-01 09:32:42'),
(136, 136, NULL, 1136, 'QRN/2026/M1136', NULL, 'sale', '000102', 1, 268, 'service', 2, 'اشتراك سنوي', '2026-01-29', '2028-01-13', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-29 06:28:50', '2026-03-01 09:32:42'),
(137, 137, NULL, 1137, 'QRN/2026/M1137', NULL, 'sale', '000108', 1, 271, 'offer', 2, 'عرض الأصدقاء', '2026-01-29', '2027-01-22', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-29 08:47:15', '2026-03-01 09:32:42'),
(138, 138, NULL, 1138, 'QRN/2026/M1138', NULL, 'sale', '000109', 1, 273, 'offer', 2, 'عرض الأصدقاء', '2026-01-29', '2027-01-22', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-29 09:21:27', '2026-03-01 09:32:42'),
(139, 139, NULL, 1139, 'QRN/2026/M1139', NULL, 'sale', '000113', 1, 276, 'offer', 2, 'عرض الأصدقاء', '2026-01-29', '2027-01-22', 1, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-29 10:37:53', '2026-03-01 09:32:42'),
(140, 140, NULL, 1140, 'QRN/2026/M1140', NULL, 'sale', '000120', 1, 278, 'service', 1, 'اشتراك نصف سنوي', '2026-01-29', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-29 10:53:50', '2026-03-01 09:32:42'),
(141, 141, NULL, 1141, 'QRN/2026/M1141', NULL, 'sale', '000122', 1, 285, 'service', 1, 'اشتراك نصف سنوي', '2026-01-30', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-29 12:07:26', '2026-03-01 09:32:42'),
(142, 142, NULL, 1142, 'QRN/2026/M1142', NULL, 'sale', '000176', 1, 289, 'offer', 1, 'عرض المؤسس', '2026-01-29', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-29 13:30:30', '2026-03-01 09:32:42'),
(143, 143, NULL, 1143, 'QRN/2026/M1143', NULL, 'sale', '000177', 1, 300, 'offer', 1, 'عرض المؤسس', '2026-01-29', '2028-01-13', 1, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-29 17:08:02', '2026-03-01 09:32:42'),
(144, 144, NULL, 1144, 'QRN/2026/M1144', NULL, 'sale', '000169', 1, 301, 'service', 1, 'اشتراك نصف سنوي', '2026-01-30', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"3\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-29 20:02:52', '2026-03-01 09:32:42'),
(145, 145, NULL, 1145, 'QRN/2026/M1145', NULL, 'sale', '000170', 1, 314, 'offer', 2, 'عرض الأصدقاء', '2026-01-30', '2028-01-13', 360, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-01-30 07:22:15', '2026-03-01 09:32:42'),
(146, 146, NULL, 1146, 'QRN/2026/M1146', NULL, 'sale', '000171', 1, 316, 'service', 1, 'اشتراك نصف سنوي', '2026-01-30', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-30 07:34:48', '2026-03-01 09:32:42'),
(147, 147, NULL, 1147, 'QRN/2026/M1147', NULL, 'sale', '000172', 1, 333, 'service', 1, 'اشتراك نصف سنوي', '2026-02-01', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-30 12:38:59', '2026-03-01 09:32:42'),
(148, 148, NULL, 1148, 'QRN/2026/M1148', NULL, 'sale', NULL, 1, 2, 'offer', 2, 'عرض الأصدقاء', '2026-01-25', '2028-01-13', 360, 5999.00, 0.00, 5999.00, 0.00, 1, 1, NULL, 'rejected', 'active', NULL, NULL, 1, '2026-01-30 12:45:47', '2026-03-01 09:32:42'),
(149, 149, NULL, 1149, 'QRN/2026/M1149', NULL, 'sale', '000121', 1, 164, 'service', 1, 'اشتراك نصف سنوي', '2026-01-30', '2028-01-13', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-30 15:38:24', '2026-03-01 09:32:42'),
(150, 150, NULL, 1150, 'QRN/2026/M1150', NULL, 'sale', '000118', 1, 371, 'service', 1, 'اشتراك نصف سنوي', '2026-02-01', '2026-07-30', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-31 12:59:44', '2026-03-01 09:32:42'),
(151, 151, NULL, 1151, 'QRN/2026/M1151', NULL, 'sale', '000119', 1, 372, 'offer', 1, 'عرض المؤسس', '2026-01-31', '2028-01-20', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-31 13:59:09', '2026-03-01 09:32:42'),
(152, 152, NULL, 1152, 'QRN/2026/M1152', NULL, 'sale', '000150', 1, 376, 'offer', 1, 'عرض المؤسس', '2026-02-01', '2028-01-21', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-01-31 17:35:03', '2026-03-01 09:32:42'),
(153, 153, NULL, 1153, 'QRN/2026/M1153', NULL, 'sale', '000116', 1, 399, 'service', 1, 'اشتراك نصف سنوي', '2026-02-01', '2026-07-30', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-01 14:08:04', '2026-03-01 09:32:42'),
(154, 154, NULL, 1154, 'QRN/2026/M1154', NULL, 'sale', '000115', 1, 400, 'offer', 1, 'عرض المؤسس', '2026-02-01', '2028-01-21', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-01 14:38:25', '2026-03-01 09:32:42'),
(155, 155, NULL, 1155, 'QRN/2026/M1155', NULL, 'sale', '000168', 1, 403, 'offer', 1, 'عرض المؤسس', '2026-02-17', '2028-02-06', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-01 15:46:56', '2026-03-01 09:32:42'),
(156, 156, NULL, 1156, 'QRN/2026/M1156', NULL, 'sale', '000114', 1, 406, 'offer', 1, 'عرض المؤسس', '2026-02-01', '2028-01-21', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-01 16:09:05', '2026-03-01 09:32:42'),
(157, 157, NULL, 1157, 'QRN/2026/M1157', NULL, 'sale', '000167', 1, 408, 'service', 1, 'اشتراك نصف سنوي', '2026-02-03', '2026-08-01', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-01 17:46:28', '2026-03-01 09:32:42'),
(158, 158, NULL, 1158, 'QRN/2026/M1158', NULL, 'sale', '000123', 1, 409, 'service', 1, 'اشتراك نصف سنوي', '2026-02-03', '2026-08-01', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-02 00:49:05', '2026-03-01 09:32:42'),
(159, 159, NULL, 1159, 'QRN/2026/M1159', NULL, 'sale', '000166', 1, 410, 'service', 2, 'اشتراك سنوي', '2026-02-02', '2027-01-27', 360, 5999.00, 899.85, 0.00, 6898.85, 5, 5, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-02 02:03:48', '2026-03-01 09:32:42'),
(160, 160, NULL, 1160, 'QRN/2026/M1160', NULL, 'sale', '000165', 1, 74, 'service', 1, 'اشتراك نصف سنوي', '2026-02-02', '2026-07-31', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-02 11:58:57', '2026-03-01 09:32:42'),
(161, 161, NULL, 1161, 'QRN/2026/M1161', NULL, 'sale', '000164', 1, 428, 'offer', 1, 'عرض المؤسس', '2026-02-02', '2028-01-22', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-02 18:10:38', '2026-03-01 09:32:42'),
(162, 162, NULL, 1162, 'QRN/2026/M1162', NULL, 'sale', '000163', 1, 429, 'offer', 1, 'عرض المؤسس', '2026-02-02', '2028-01-22', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-02 19:11:27', '2026-03-01 09:32:42'),
(163, 163, NULL, 1163, 'QRN/2026/M1163', NULL, 'sale', '000144', 1, 444, 'service', 1, 'اشتراك نصف سنوي', '2026-02-03', '2026-08-01', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-03 13:45:07', '2026-03-01 09:32:42'),
(164, 164, NULL, 1164, 'QRN/2026/M1164', NULL, 'sale', '000162', 1, 449, 'offer', 2, 'عرض الأصدقاء', '2026-02-03', '2027-01-28', 360, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-02-03 14:48:11', '2026-03-01 09:32:42'),
(165, 165, NULL, 1165, 'QRN/2026/M1165', NULL, 'sale', '000145', 1, 450, 'service', 1, 'اشتراك نصف سنوي', '2026-02-03', '2026-08-01', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-03 15:56:53', '2026-03-01 09:32:42'),
(166, 166, NULL, 1166, 'QRN/2026/M1166', NULL, 'sale', '000146', 1, 451, 'service', 2, 'اشتراك سنوي', '2026-02-03', '2027-01-28', 360, 5999.00, 899.85, 0.00, 6898.85, 5, 5, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-03 16:42:28', '2026-03-01 09:32:42');
INSERT INTO `subscriptions` (`id`, `root_subscription_id`, `parent_subscription_id`, `subscription_no`, `invoice_no`, `parent_invoice_no`, `invoice_kind`, `verification_code`, `branch_id`, `member_id`, `subscription_type`, `item_id`, `item_name`, `start_date`, `end_date`, `duration`, `price`, `tax`, `discount`, `total`, `created_by`, `account_user_id`, `payment_methods`, `status`, `lifecycle_status`, `generated_reason`, `rejection_notes`, `active`, `created_at`, `updated_at`) VALUES
(167, 167, NULL, 1167, 'QRN/2026/M1167', NULL, 'sale', '000161', 1, 199, 'service', 1, 'اشتراك نصف سنوي', '2026-02-04', '2026-08-02', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-03 23:22:13', '2026-03-01 09:32:42'),
(168, 168, NULL, 1168, 'QRN/2026/M1168', NULL, 'sale', '000160', 1, 22, 'service', 1, 'اشتراك نصف سنوي', '2026-02-04', '2026-08-02', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-04 14:14:15', '2026-03-01 09:32:42'),
(169, 169, NULL, 1169, 'QRN/2026/M1169', NULL, 'sale', '000159', 1, 478, 'offer', 1, 'عرض المؤسس', '2026-02-04', '2028-01-24', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-04 17:24:56', '2026-03-01 09:32:42'),
(170, 170, NULL, 1170, 'QRN/2026/M1170', NULL, 'sale', '000147', 1, 491, 'offer', 1, 'عرض المؤسس', '2026-02-05', '2028-01-25', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-05 06:57:20', '2026-03-01 09:32:42'),
(171, 171, NULL, 1171, 'QRN/2026/M1171', NULL, 'sale', '000148', 1, 390, 'service', 2, 'اشتراك سنوي', '2026-02-05', '2027-01-30', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"6898.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-05 09:06:20', '2026-03-01 09:32:42'),
(172, 172, NULL, 1172, 'QRN/2026/M1172', NULL, 'sale', '000149', 1, 441, 'offer', 1, 'عرض المؤسس', '2026-02-05', '2028-01-25', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '[{\"method_id\":\"5\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-05 09:16:25', '2026-03-01 09:32:42'),
(173, 173, NULL, 1173, 'QRN/2026/M1173', NULL, 'sale', '000158', 1, 266, 'service', 1, 'اشتراك نصف سنوي', '2026-02-05', '2026-08-03', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '[{\"method_id\":\"4\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-05 13:15:54', '2026-03-01 09:32:42'),
(174, 174, NULL, 1174, 'QRN/2026/M1174', NULL, 'sale', '000157', 1, 502, 'service', 1, 'اشتراك نصف سنوي', '2026-02-05', '2026-08-03', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '[{\"method_id\":\"5\",\"amount\":\"4598.85\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-05 14:29:22', '2026-03-01 09:32:42'),
(175, 175, NULL, 1175, 'QRN/2026/M1175', NULL, 'sale', '000156', 1, 507, 'offer', 1, 'عرض المؤسس', '2026-02-18', '2028-02-07', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '[{\"method_id\":\"4\",\"amount\":\"9200.00\"}]', 'approved', 'active', NULL, NULL, 1, '2026-02-05 17:39:51', '2026-03-01 09:32:42'),
(176, 176, NULL, 1176, 'QRN/2026/M1176', NULL, 'sale', '000151', 1, 526, 'service', 1, 'اشتراك نصف سنوي', '2026-02-06', '2026-08-04', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-06 12:17:55', '2026-03-01 09:32:42'),
(177, 177, NULL, 1177, 'QRN/2026/M1177', NULL, 'sale', '000152', 1, 557, 'service', 1, 'اشتراك نصف سنوي', '2026-02-07', '2026-08-05', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-07 10:41:15', '2026-03-01 09:32:42'),
(178, 178, NULL, 1178, 'QRN/2026/M1178', NULL, 'sale', '000154', 1, 559, 'offer', 1, 'عرض المؤسس', '2026-02-07', '2028-01-27', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-07 11:36:43', '2026-03-01 09:32:42'),
(179, 179, NULL, 1179, 'QRN/2026/M1179', NULL, 'sale', '000153', 1, 426, 'service', 1, 'اشتراك نصف سنوي', '2026-02-07', '2026-08-05', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-07 12:23:47', '2026-03-01 09:32:42'),
(180, 180, NULL, 1180, 'QRN/2026/M1180', NULL, 'sale', '000155', 1, 561, 'service', 1, 'اشتراك نصف سنوي', '2026-02-08', '2026-08-06', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-07 13:57:47', '2026-03-01 09:32:42'),
(181, 181, NULL, 1181, 'QRN/2026/M1181', NULL, 'sale', '000178', 1, 571, 'offer', 1, 'عرض المؤسس', '2026-02-08', '2028-01-28', 720, 13000.00, 1200.00, 5000.00, 9200.00, 1, 1, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-08 11:54:25', '2026-03-01 09:32:42'),
(182, 182, NULL, 1182, 'QRN/2026/M1182', NULL, 'sale', '000179', 1, 571, 'offer', 1, 'عرض المؤسس', '2026-02-08', '2028-01-28', 720, 13000.00, 1200.00, 5000.00, 9200.00, 1, 1, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-08 11:54:40', '2026-03-01 09:32:42'),
(183, 183, NULL, 1183, 'QRN/2026/M1183', NULL, 'sale', '000180', 1, 522, 'offer', 1, 'عرض المؤسس', '2026-02-08', '2028-01-28', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-08 12:04:28', '2026-03-01 09:32:42'),
(184, 184, NULL, 1184, 'QRN/2026/M1184', NULL, 'sale', '000181', 1, 521, 'offer', 1, 'عرض المؤسس', '2026-02-08', '2028-01-28', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-08 12:17:02', '2026-03-01 09:32:42'),
(185, 185, NULL, 1185, 'QRN/2026/M1185', NULL, 'sale', '000182', 1, 224, 'service', 1, 'اشتراك نصف سنوي', '2026-02-08', '2026-08-06', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-08 12:37:48', '2026-03-01 09:32:42'),
(186, 186, NULL, 1186, 'QRN/2026/M1186', NULL, 'sale', '000185', 1, 573, 'service', 2, 'اشتراك سنوي', '2026-02-08', '2027-02-02', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"6898.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-08 13:22:15', '2026-03-01 09:32:42'),
(187, 187, NULL, 1187, 'QRN/2026/M1187', NULL, 'sale', '000184', 1, 579, 'service', 1, 'اشتراك نصف سنوي', '2026-02-09', '2026-08-07', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-09 05:26:28', '2026-03-01 09:32:42'),
(188, 188, NULL, 1188, 'QRN/2026/M1188', NULL, 'sale', '000183', 1, 398, 'service', 1, 'اشتراك نصف سنوي', '2026-02-09', '2026-08-07', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-09 13:25:57', '2026-03-01 09:32:42'),
(189, 189, NULL, 1189, 'QRN/2026/M1189', NULL, 'sale', '000186', 1, 588, 'service', 2, 'اشتراك سنوي', '2026-02-09', '2027-02-03', 360, 5999.00, 899.85, 0.00, 6898.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"6898.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-09 14:06:00', '2026-03-01 09:32:42'),
(190, 190, NULL, 1190, 'QRN/2026/M1190', NULL, 'sale', '000187', 1, 589, 'service', 1, 'اشتراك نصف سنوي', '2026-02-09', '2026-08-07', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-09 14:10:52', '2026-03-01 09:32:42'),
(191, 191, NULL, 1191, 'QRN/2026/M1191', NULL, 'sale', '000188', 1, 582, 'service', 1, 'اشتراك نصف سنوي', '2026-02-10', '2026-08-08', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-10 11:21:09', '2026-03-01 09:32:42'),
(192, 192, NULL, 1192, 'QRN/2026/M1192', NULL, 'sale', '000189', 1, 600, 'offer', 1, 'عرض المؤسس', '2026-02-11', '2028-01-31', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-10 13:07:09', '2026-03-01 09:32:42'),
(193, 193, NULL, 1193, 'QRN/2026/M1193', NULL, 'sale', '000195', 1, 590, 'service', 1, 'اشتراك نصف سنوي', '2026-02-10', '2026-08-08', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-10 16:47:49', '2026-03-01 09:32:42'),
(194, 194, NULL, 1194, 'QRN/2026/M1194', NULL, 'sale', '000194', 1, 606, 'offer', 1, 'عرض المؤسس', '2026-02-11', '2028-01-31', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-11 08:43:32', '2026-03-01 09:32:42'),
(195, 195, NULL, 1195, 'QRN/2026/M1195', NULL, 'sale', '000190', 1, 652, 'offer', 1, 'عرض المؤسس', '2026-02-14', '2028-02-03', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-14 07:10:08', '2026-03-01 09:32:42'),
(196, 196, NULL, 1196, 'QRN/2026/M1196', NULL, 'sale', '000191', 1, 650, 'offer', 1, 'عرض المؤسس', '2026-02-14', '2028-02-03', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-14 07:10:22', '2026-03-01 09:32:42'),
(197, 197, NULL, 1197, 'QRN/2026/M1197', NULL, 'sale', '000192', 1, 651, 'offer', 1, 'عرض المؤسس', '2026-02-14', '2028-02-03', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-14 07:11:44', '2026-03-01 09:32:42'),
(198, 198, NULL, 1198, 'QRN/2026/M1198', NULL, 'sale', '000193', 1, 653, 'service', 2, 'اشتراك سنوي', '2026-02-14', '2027-02-08', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"6898.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-14 08:00:09', '2026-03-01 09:32:42'),
(199, 199, NULL, 1199, 'QRN/2026/M1199', NULL, 'sale', '000196', 1, 665, 'service', 1, 'اشتراك نصف سنوي', '2026-02-15', '2026-08-13', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-14 16:34:18', '2026-03-01 09:32:42'),
(200, 200, NULL, 1200, 'QRN/2026/M1200', NULL, 'sale', '000197', 1, 667, 'service', 2, 'اشتراك سنوي', '2026-02-15', '2027-02-09', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"6898.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-15 02:46:14', '2026-03-01 09:32:42'),
(201, 201, NULL, 1201, 'QRN/2026/M1201', NULL, 'sale', '000198', 1, 682, 'service', 7, 'اشتراك شهر', '2026-02-16', '2026-03-17', 30, 870.00, 130.50, 0.00, 1000.50, 1, 1, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"1000.50\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-16 13:17:08', '2026-03-01 09:32:42'),
(202, 202, NULL, 1202, 'QRN/2026/M1202', NULL, 'sale', '000199', 1, 684, 'service', 1, 'اشتراك نصف سنوي', '2026-02-16', '2026-08-14', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-16 15:11:06', '2026-03-01 09:32:42'),
(203, 203, NULL, 1203, 'QRN/2026/M1203', NULL, 'sale', '000200', 1, 692, 'offer', 2, 'عرض الأصدقاء', '2026-02-17', '2027-02-11', 360, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-02-17 09:46:57', '2026-03-01 09:32:42'),
(204, 204, NULL, 1204, 'QRN/2026/M1204', NULL, 'sale', '000201', 1, 698, 'offer', 1, 'عرض المؤسس', '2026-02-17', '2028-02-06', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-17 16:19:13', '2026-03-01 09:32:42'),
(205, 205, NULL, 1205, 'QRN/2026/M1205', NULL, 'sale', '000202', 1, 699, 'service', 1, 'اشتراك نصف سنوي', '2026-02-17', '2026-08-15', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-17 17:52:41', '2026-03-01 09:32:42'),
(206, 206, NULL, 1206, 'QRN/2026/M1206', NULL, 'sale', '000203', 1, 708, 'service', 1, 'اشتراك نصف سنوي', '2026-02-19', '2026-08-17', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-18 16:04:25', '2026-03-01 09:32:42'),
(207, 207, NULL, 1207, 'QRN/2026/M1207', NULL, 'sale', '000204', 1, 712, 'service', 1, 'اشتراك نصف سنوي', '2026-02-18', '2026-08-16', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-18 17:50:41', '2026-03-01 09:32:42'),
(208, 208, NULL, 1208, 'QRN/2026/M1208', NULL, 'sale', '000205', 1, 713, 'offer', 1, 'عرض المؤسس', '2026-02-21', '2028-02-10', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-18 20:06:09', '2026-03-01 09:32:42'),
(209, 209, NULL, 1209, 'QRN/2026/M1209', NULL, 'sale', '000207', 1, 562, 'offer', 1, 'عرض المؤسس', '2026-02-19', '2028-02-08', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-19 14:26:58', '2026-03-01 09:32:42'),
(210, 210, NULL, 1210, 'QRN/2026/M1210', NULL, 'sale', '000212', 1, 715, 'service', 1, 'اشتراك نصف سنوي', '2026-02-23', '2026-08-21', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-19 16:40:18', '2026-03-01 09:32:42'),
(211, 211, NULL, 1211, 'QRN/2026/M1211', NULL, 'sale', '000211', 1, 716, 'service', 2, 'اشتراك سنوي', '2026-02-21', '2027-02-15', 360, 5999.00, 899.85, 0.00, 6898.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"6898.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-19 17:09:23', '2026-03-01 09:32:42'),
(212, 212, NULL, 1212, 'QRN/2026/M1212', NULL, 'sale', '000208', 1, 718, 'service', 1, 'اشتراك نصف سنوي', '2026-02-19', '2026-08-17', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-19 18:14:59', '2026-03-01 09:32:42'),
(213, 213, NULL, 1213, 'QRN/2026/M1213', NULL, 'sale', '000209', 1, 700, 'service', 1, 'اشتراك نصف سنوي', '2026-02-21', '2026-08-19', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-19 18:33:29', '2026-03-01 09:32:42'),
(214, 214, NULL, 1214, 'QRN/2026/M1214', NULL, 'sale', '000210', 1, 723, 'service', 1, 'اشتراك نصف سنوي', '2026-02-27', '2026-08-25', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-20 15:29:42', '2026-03-01 09:32:42'),
(215, 215, NULL, 1215, 'QRN/2026/M1215', NULL, 'sale', '000213', 1, 728, 'service', 2, 'اشتراك سنوي', '2026-02-20', '2027-02-14', 360, 5999.00, 899.85, 0.00, 6898.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"6898.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-20 16:26:07', '2026-03-01 09:32:42'),
(216, 216, NULL, 1216, 'QRN/2026/M1216', NULL, 'sale', '000214', 1, 725, 'offer', 1, 'عرض المؤسس', '2026-02-21', '2028-02-10', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-20 16:40:39', '2026-03-01 09:32:42'),
(217, 217, NULL, 1217, 'QRN/2026/M1217', NULL, 'sale', '000215', 1, 737, 'offer', 2, 'عرض الأصدقاء', '2026-02-22', '2027-02-16', 360, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-02-22 13:38:29', '2026-03-01 09:32:42'),
(218, 218, NULL, 1218, 'QRN/2026/M1218', NULL, 'sale', '000216', 1, 743, 'service', 1, 'اشتراك نصف سنوي', '2026-02-23', '2026-08-21', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-23 12:38:59', '2026-03-01 09:32:42'),
(219, 219, NULL, 1219, 'QRN/2026/M1219', NULL, 'sale', '000218', 1, 746, 'offer', 1, 'عرض المؤسس', '2026-02-23', '2028-02-12', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-23 14:22:33', '2026-03-01 09:32:42'),
(220, 220, NULL, 1220, 'QRN/2026/M1220', NULL, 'sale', '000219', 1, 748, 'offer', 3, 'عرض ابوربيعة', '2026-02-23', '2027-02-17', 360, 5999.00, 449.93, 2999.50, 3449.43, 2, 2, '\"[{\\\"method_id\\\":\\\"1\\\",\\\"amount\\\":\\\"3449.43\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-23 15:39:28', '2026-03-01 09:32:42'),
(221, 221, NULL, 1221, 'QRN/2026/M1221', NULL, 'sale', '000217', 1, 427, 'service', 1, 'اشتراك نصف سنوي', '2026-02-23', '2026-08-21', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-23 15:55:22', '2026-03-01 09:32:42'),
(222, 222, NULL, 1222, 'QRN/2026/M1222', NULL, 'sale', '000220', 1, 758, 'service', 1, 'اشتراك نصف سنوي', '2026-02-25', '2026-08-23', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-24 14:29:46', '2026-03-01 09:32:42'),
(223, 223, NULL, 1223, 'QRN/2026/M1223', NULL, 'sale', '000221', 1, 767, 'service', 1, 'اشتراك نصف سنوي', '2026-01-28', '2026-07-26', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-25 13:44:57', '2026-03-01 09:32:42'),
(224, 224, NULL, 1224, 'QRN/2026/M1224', NULL, 'sale', '000222', 1, 768, 'offer', 2, 'عرض الأصدقاء', '2026-02-25', '2027-02-19', 360, 5999.00, 0.00, 5999.00, 0.00, 7, 7, NULL, 'approved', 'active', NULL, NULL, 1, '2026-02-25 14:26:53', '2026-03-01 09:32:42'),
(225, 225, NULL, 1225, 'QRN/2026/M1225', NULL, 'sale', '000223', 1, 773, 'service', 1, 'اشتراك نصف سنوي', '2026-02-25', '2026-08-23', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-25 18:42:29', '2026-03-01 09:32:42'),
(226, 226, NULL, 1226, 'QRN/2026/M1226', NULL, 'sale', '000224', 1, 355, 'service', 2, 'اشتراك سنوي', '2026-02-26', '2027-02-20', 360, 5999.00, 899.85, 0.00, 6898.85, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"6898.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-26 12:42:52', '2026-03-01 09:32:42'),
(227, 227, NULL, 1227, 'QRN/2026/M1227', NULL, 'sale', '000225', 1, 134, 'offer', 3, 'عرض ابوربيعة', '2026-02-26', '2027-02-20', 360, 5999.00, 449.93, 2999.50, 3449.43, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"3449.43\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-26 13:11:18', '2026-03-01 09:32:42'),
(228, 228, NULL, 1228, 'QRN/2026/M1228', NULL, 'sale', '000226', 1, 640, 'service', 1, 'اشتراك نصف سنوي', '2026-02-26', '2026-08-24', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-26 14:08:35', '2026-03-01 09:32:42'),
(229, 229, NULL, 1229, 'QRN/2026/M1229', NULL, 'sale', '000228', 1, 756, 'offer', 1, 'عرض المؤسس', '2026-03-10', '2028-02-27', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-26 18:28:51', '2026-03-05 14:24:12'),
(230, 230, NULL, 1230, 'QRN/2026/M1230', NULL, 'sale', '000229', 1, 379, 'service', 1, 'اشتراك نصف سنوي', '2026-02-26', '2026-08-24', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-26 19:03:03', '2026-03-05 14:24:12'),
(231, 231, NULL, 1231, 'QRN/2026/M1231', NULL, 'sale', '000230', 1, 425, 'service', 1, 'اشتراك نصف سنوي', '2026-02-26', '2026-08-24', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-26 19:34:19', '2026-03-05 14:24:12'),
(232, 232, NULL, 1232, 'QRN/2026/M1232', NULL, 'sale', '000231', 1, 792, 'service', 1, 'اشتراك نصف سنوي', '2026-02-27', '2026-08-25', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-27 16:11:34', '2026-03-05 14:24:12'),
(233, 233, NULL, 1233, 'QRN/2026/M1233', NULL, 'sale', '000232', 1, 803, 'service', 1, 'اشتراك نصف سنوي', '2026-02-28', '2026-08-26', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-02-28 16:10:43', '2026-03-05 14:24:12'),
(234, NULL, NULL, 1234, 'QRN/2026/M1234', NULL, 'sale', '000233', 1, 806, 'service', 1, 'اشتراك نصف سنوي', '2026-03-01', '2026-08-27', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-01 13:44:39', '2026-03-05 14:24:12'),
(235, NULL, NULL, 1235, 'QRN/2026/M1235', NULL, 'sale', '000227', 1, 807, 'offer', 1, 'عرض المؤسس', '2026-03-01', '2028-02-18', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-01 14:33:28', '2026-03-01 14:36:23'),
(236, NULL, NULL, 1236, 'QRN/2026/M1236', NULL, 'sale', '000234', 1, 812, 'offer', 1, 'عرض المؤسس', '2026-03-02', '2028-02-19', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-02 14:23:39', '2026-03-05 14:24:12'),
(237, NULL, NULL, 1237, 'QRN/2026/M1237', NULL, 'sale', '000235', 1, 816, 'service', 1, 'اشتراك نصف سنوي', '2026-03-03', '2026-08-29', 180, 3999.00, 599.85, 0.00, 4598.85, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-02 17:07:58', '2026-03-05 14:24:13'),
(238, NULL, NULL, 1238, 'QRN/2026/M1238', NULL, 'sale', '000236', 1, 824, 'service', 1, 'اشتراك نصف سنوي', '2026-03-03', '2026-03-23', 21, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 0, '2026-03-03 15:53:50', '2026-03-21 01:00:38'),
(239, NULL, NULL, 1239, 'QRN/2026/M1239', NULL, 'sale', '000237', 1, 831, 'offer', 1, 'عرض المؤسس', '2026-03-08', '2028-02-25', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-04 14:51:26', '2026-03-05 14:24:22'),
(240, NULL, NULL, 1240, 'QRN/2026/M1240', NULL, 'sale', '000239', 1, 837, 'offer', 2, 'عرض الأصدقاء', '2026-03-05', '2027-02-27', 360, 5999.00, 0.00, 5999.00, 0.00, 5, 5, NULL, 'approved', 'active', NULL, NULL, 1, '2026-03-05 18:15:53', '2026-03-13 16:49:48'),
(241, NULL, NULL, 1241, 'QRN/2026/M1241', NULL, 'sale', '000240', 1, 864, 'offer', 1, 'عرض المؤسس', '2026-03-10', '2028-02-27', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-10 17:20:43', '2026-03-13 16:49:48'),
(242, NULL, NULL, 1242, 'QRN/2026/M1242', NULL, 'sale', '000238', 1, 883, 'offer', 2, 'عرض الأصدقاء', '2026-03-10', '2027-03-04', 360, 5999.00, 0.00, 5999.00, 0.00, 2, 2, NULL, 'approved', 'active', NULL, NULL, 1, '2026-03-10 17:43:09', '2026-03-10 17:43:55'),
(243, NULL, NULL, 1243, 'QRN/2026/M1243', NULL, 'sale', '000241', 1, 736, 'offer', 1, 'عرض المؤسس', '2026-03-13', '2028-03-01', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-11 15:19:08', '2026-03-13 16:49:48'),
(244, NULL, NULL, 1244, 'QRN/2026/M1244', NULL, 'sale', '000242', 1, 899, 'service', 1, 'اشتراك نصف سنوي', '2026-03-20', '2026-09-15', 180, 3999.00, 599.85, 0.00, 4598.85, 7, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-11 16:07:15', '2026-03-13 16:49:48'),
(245, NULL, NULL, 1245, 'QRN/2026/M1245', NULL, 'sale', '000243', 1, 850, 'offer', 1, 'عرض المؤسس', '2026-03-11', '2028-02-28', 720, 13000.00, 1200.00, 5000.00, 9200.00, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-11 18:22:56', '2026-03-13 16:49:48'),
(246, NULL, NULL, 1246, 'QRN/2026/M1246', NULL, 'sale', '000244', 1, 900, 'service', 1, 'اشتراك نصف سنوي', '2026-03-11', '2026-03-18', 8, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 0, '2026-03-11 18:43:45', '2026-03-19 17:29:33'),
(247, NULL, NULL, 1247, 'QRN/2026/M1247', NULL, 'sale', '000245', 1, 904, 'service', 1, 'اشتراك نصف سنوي', '2026-03-13', '2026-03-18', 6, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 0, '2026-03-12 13:18:56', '2026-03-19 17:22:33'),
(248, NULL, NULL, 1248, 'QRN/2026/M1248', NULL, 'sale', '000246', 1, 891, 'offer', 1, 'عرض المؤسس', '2026-03-13', '2028-03-01', 720, 13000.00, 1200.00, 5000.00, 9200.00, 2, 2, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4200.00\\\"},{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"5000.00\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-13 14:39:36', '2026-03-13 16:49:48'),
(249, NULL, NULL, 1249, 'QRN/2026/M1249', NULL, 'sale', NULL, 1, 923, 'offer', 1, 'عرض المؤسس', '2026-03-13', '2028-03-01', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'under_review', 'active', NULL, NULL, 1, '2026-03-13 17:28:34', '2026-03-13 17:28:34'),
(250, NULL, NULL, 1250, 'QRN/2026/M1250', NULL, 'sale', NULL, 1, 966, 'service', 1, 'اشتراك نصف سنوي', '2026-03-25', '2026-09-20', 180, 3999.00, 599.85, 0.00, 4598.85, 5, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'under_review', 'active', NULL, NULL, 1, '2026-03-18 15:48:30', '2026-03-18 15:48:30'),
(251, 247, 247, 1251, '001/2026/M1251', 'QRN/2026/M1247', 'adjustment', NULL, 1, 904, 'service', 1, 'اشتراك نصف سنوي', '2026-03-29', '2026-09-18', 174, 3999.00, 599.85, 0.00, 4598.85, 1, 5, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', 'pause', NULL, 1, '2026-03-19 17:22:33', '2026-03-19 17:22:33'),
(252, 246, 246, 1252, '001/2026/M1252', 'QRN/2026/M1246', 'adjustment', NULL, 1, 973, 'service', 1, 'اشتراك نصف سنوي', '2026-03-19', '2026-09-06', 172, 3999.00, 599.85, 0.00, 4598.85, 1, 5, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-19 17:29:33', '2026-03-19 17:29:33'),
(253, 238, 238, 1253, '001/2026/M1253', 'QRN/2026/M1238', 'adjustment', NULL, 1, 973, 'service', 1, 'اشتراك نصف سنوي', '2026-03-24', '2026-08-29', 159, 3999.00, 599.85, 0.00, 4598.85, 1, 7, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'approved', 'active', NULL, NULL, 1, '2026-03-21 01:00:38', '2026-03-21 01:00:38'),
(254, NULL, NULL, 1254, 'QRN/2026/M1254', NULL, 'sale', NULL, 1, 1017, 'service', 1, 'اشتراك نصف سنوي', '2026-03-21', '2026-09-16', 180, 3999.00, 599.85, 0.00, 4598.85, 3, 3, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"4598.85\\\"}]\"', 'under_review', 'active', NULL, NULL, 1, '2026-03-21 11:39:31', '2026-03-21 11:39:31'),
(255, NULL, NULL, 1255, 'QRN/2026/M1255', NULL, 'sale', NULL, 1, 1025, 'offer', 1, 'عرض المؤسس', '2026-03-22', '2028-03-10', 720, 13000.00, 1200.00, 5000.00, 9200.00, 3, 3, '\"[{\\\"method_id\\\":\\\"4\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'under_review', 'active', NULL, NULL, 1, '2026-03-22 06:12:18', '2026-03-22 06:12:18'),
(256, NULL, NULL, 1256, 'QRN/2026/M1256', NULL, 'sale', NULL, 1, 1029, 'service', 2, 'اشتراك سنوي', '2026-03-22', '2027-03-16', 360, 5999.00, 899.85, 0.00, 6898.85, 3, 3, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"6898.85\\\"}]\"', 'under_review', 'active', NULL, NULL, 1, '2026-03-22 10:38:30', '2026-03-22 10:38:30'),
(257, NULL, NULL, 1257, 'QRN/2026/M1257', NULL, 'sale', NULL, 1, 919, 'offer', 1, 'عرض المؤسس', '2026-03-23', '2028-03-11', 720, 13000.00, 1200.00, 5000.00, 9200.00, 7, 7, '\"[{\\\"method_id\\\":\\\"5\\\",\\\"amount\\\":\\\"9200.00\\\"}]\"', 'under_review', 'active', NULL, NULL, 1, '2026-03-23 13:45:40', '2026-03-23 13:45:40');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_invoice_no` (`invoice_no`),
  ADD KEY `idx_branch_id` (`branch_id`),
  ADD KEY `idx_member_id` (`member_id`),
  ADD KEY `fk_subscriptions_created_by` (`created_by`),
  ADD KEY `fk_subscriptions_account_user` (`account_user_id`),
  ADD KEY `subs_root_idx` (`root_subscription_id`),
  ADD KEY `subs_parent_idx` (`parent_subscription_id`),
  ADD KEY `subs_lifecycle_idx` (`lifecycle_status`),
  ADD KEY `subs_invoice_kind_idx` (`invoice_kind`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=258;

--
-- قيود الجداول المُلقاة.
--

--
-- قيود الجداول `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD CONSTRAINT `subs_parent_fk` FOREIGN KEY (`parent_subscription_id`) REFERENCES `subscriptions` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `subs_root_fk` FOREIGN KEY (`root_subscription_id`) REFERENCES `subscriptions` (`id`) ON DELETE SET NULL;
COMMIT;

