-- ============================================
-- Import Group Status from SQL Dump
-- ============================================
-- 
-- This file imports group status data from the old database structure
-- Table: tbl_group_status -> group_statuses
-- Columns mapped:
--   group_status_id -> id
--   status_name_sort -> sort_order
--   status_name_ar -> name_ar
--   status_name_la -> name_en
--   status_group_locked -> is_locked
--   color -> color
--   fontcolor -> font_color
-- ============================================

INSERT IGNORE INTO `group_statuses` (`id`, `sort_order`, `name_ar`, `name_en`, `is_locked`, `color`, `font_color`, `created_at`, `updated_at`) VALUES
	(1, 0, 'جديد', 'New', 0, NULL, NULL, NOW(), NOW()),
	(2, 5, 'تم التدقيق', 'Reviewed', 1, 0, 0, NOW(), NOW()),
	(3, 7, 'تم الارسال', 'Sent', 1, 16777215, 13107, NOW(), NOW()),
	(4, 1, 'في الانتظار', 'Pending', 1, NULL, NULL, NOW(), NOW()),
	(5, 2, 'قيد الادخال', 'Feeding', 1, 0, 0, NOW(), NOW()),
	(6, 3, 'تم الادخال', 'Feeding Done', 1, NULL, NULL, NOW(), NOW()),
	(7, 8, 'تم اصدار التاشيرات', 'Visa Issued', 1, NULL, NULL, NOW(), NOW()),
	(8, 4, 'قيد التدقيق', 'Review', 1, NULL, NULL, NOW(), NOW()),
	(9, 13, 'ملغاة', 'Cancelled', 1, NULL, NULL, NOW(), NOW()),
	(10, 2, 'في الانتظار', 'On Hold', 0, NULL, NULL, NOW(), NOW()),
	(12, 11, 'مؤرشفة', 'Archived', 1, NULL, NULL, NOW(), NOW()),
	(14, 10, 'تم التسليم', 'Delivered', 1, NULL, NULL, NOW(), NOW()),
	(15, 6, 'جاهز للارسال', 'Ready to Send', 1, 0, 0, NOW(), NOW()),
	(18, 9, 'تسليم جزئي', 'Partial Delivery', 1, NULL, NULL, NOW(), NOW()),
	(19, 12, 'تسليم معلق', 'Hold Delivery', 1, NULL, NULL, NOW(), NOW()),
	(20, 20, 'طباعة', 'Print', 0, NULL, NULL, NOW(), NOW());
