-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: 24 مارس 2026 الساعة 11:32 -- إصدار الخادم: 10.11.14-MariaDB -- PHP Version: 8.3.14 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 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, `is_current` tinyint(1) NOT NULL DEFAULT 1, `closed_reason` varchar(50) DEFAULT NULL, `closed_at` timestamp NULL DEFAULT NULL, `closed_by` bigint(20) UNSIGNED DEFAULT NULL, `current_action_type` varchar(50) DEFAULT NULL, `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`, `is_current`, `closed_reason`, `closed_at`, `closed_by`, `current_action_type`, `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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '2026-01-31 17:35:03', '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`, `is_current`, `closed_reason`, `closed_at`, `closed_by`, `current_action_type`, `created_at`, `updated_at`) VALUES (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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '2026-02-03 16:42:28', '2026-03-01 09:32:42'), (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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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, 1, NULL, NULL, NULL, NULL, '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`), ADD KEY `subs_is_current_idx` (`is_current`), ADD KEY `subs_status_branch_current_idx` (`status`,`branch_id`,`is_current`), ADD KEY `subs_closed_by_idx` (`closed_by`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=261; -- -- قيود الجداول المُلقاة. -- -- -- قيود الجداول `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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;