-- ===================================================================== -- Order ratings (تقييم الطلبات) - app/Services/OrderRating -- -- 1. Table `order_ratings` (utf8mb4): one row per PURCHASE (combined order, all -- its sellers), created when every live order of it is "delivered" (unique -- combined_order_id keeps the push to one). Table `order_rating_scores`: the -- answers to the criteria of config/order_ratings.php, one row each. -- 2. Staff Roles section "Order Ratings": view_order_ratings and -- manage_order_rating_settings, granted to the "full access" and "CEO" roles. -- 3. Notification type `order_rate_customer` (app inbox "rate your order"). -- 4. Business setting `order_rating_alert_emails` = mohannad@kapitano.shop -- (who gets the email when an order is rated below 5 stars). -- 5. Arabic UI strings. -- -- Same as migrations 2026_09_29_000005_create_order_ratings_table and -- 2026_09_29_000006_add_order_rating_permissions. Re-running the file changes -- nothing (only missing rows are inserted). -- After running: php artisan cache:clear (permissions, settings and -- translations are cached). -- ===================================================================== SET NAMES utf8mb4; CREATE TABLE IF NOT EXISTS `order_ratings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint unsigned NOT NULL, `combined_order_id` bigint unsigned DEFAULT NULL, `user_id` bigint unsigned NOT NULL, `seller_id` bigint unsigned DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'pending' COMMENT 'pending | rated | dismissed', `rating` tinyint unsigned DEFAULT NULL, `comment` text, `source` varchar(10) DEFAULT NULL COMMENT 'app | web', `product_id` bigint unsigned DEFAULT NULL, `review_id` bigint unsigned DEFAULT NULL, `review_skipped_reason` varchar(30) DEFAULT NULL COMMENT 'multiple_products | already_reviewed | no_product', `requested_at` timestamp NULL DEFAULT NULL, `notified_at` timestamp NULL DEFAULT NULL, `rated_at` timestamp NULL DEFAULT NULL, `dismissed_at` timestamp NULL DEFAULT NULL, `alert_sent_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `order_ratings_order_id_unique` (`order_id`), UNIQUE KEY `order_ratings_combined_order_id_unique` (`combined_order_id`), KEY `order_ratings_seller_id_index` (`seller_id`), KEY `order_ratings_rating_index` (`rating`), KEY `order_ratings_requested_at_index` (`requested_at`), KEY `order_ratings_rated_at_index` (`rated_at`), KEY `order_ratings_user_id_status_requested_at_index` (`user_id`, `status`, `requested_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `order_rating_scores` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `order_rating_id` bigint unsigned NOT NULL, `criterion` varchar(40) NOT NULL COMMENT 'a key of config/order_ratings.php criteria', `score` tinyint unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `order_rating_scores_order_rating_id_criterion_unique` (`order_rating_id`, `criterion`), KEY `order_rating_scores_criterion_score_index` (`criterion`, `score`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Optional, like the index advice in the other sqlupdates files: the "already -- reviewed this product?" check (and the product page) scan `reviews` without it. -- ALTER TABLE `reviews` ADD INDEX `reviews_user_id_product_id_index` (`user_id`, `product_id`); INSERT INTO `permissions` (`name`, `section`, `guard_name`, `created_at`, `updated_at`) SELECT 'view_order_ratings', 'order_ratings', 'web', NOW(), NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `permissions` WHERE `name` = 'view_order_ratings' AND `guard_name` = 'web'); INSERT INTO `permissions` (`name`, `section`, `guard_name`, `created_at`, `updated_at`) SELECT 'manage_order_rating_settings', 'order_ratings', 'web', NOW(), NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `permissions` WHERE `name` = 'manage_order_rating_settings' AND `guard_name` = 'web'); INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) SELECT p.id, r.id FROM `permissions` p JOIN `roles` r ON LOWER(r.name) IN ('full access', 'ceo') WHERE p.name IN ('view_order_ratings', 'manage_order_rating_settings') AND p.guard_name = 'web' AND NOT EXISTS (SELECT 1 FROM `role_has_permissions` x WHERE x.permission_id = p.id AND x.role_id = r.id); INSERT INTO `notification_types` (`user_type`, `type`, `name`, `image`, `default_text`, `status`, `created_at`, `updated_at`) SELECT 'customer', 'order_rate_customer', 'Rate your order', NULL, 'Your order [[order_code]] was delivered. How was it? Rate it in a few seconds.', 1, NOW(), NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `notification_types` WHERE `type` = 'order_rate_customer'); INSERT INTO `notification_type_translations` (`notification_type_id`, `name`, `default_text`, `lang`, `created_at`, `updated_at`) SELECT nt.id, 'Rate your order', 'Your order [[order_code]] was delivered. How was it? Rate it in a few seconds.', 'en', NOW(), NOW() FROM `notification_types` nt WHERE nt.type = 'order_rate_customer' AND NOT EXISTS (SELECT 1 FROM `notification_type_translations` x WHERE x.notification_type_id = nt.id AND x.lang = 'en'); INSERT INTO `notification_type_translations` (`notification_type_id`, `name`, `default_text`, `lang`, `created_at`, `updated_at`) SELECT nt.id, 'قيّم طلبك', 'تم توصيل طلبك [[order_code]]. كيف كانت تجربتك؟ قيّمه بثوانٍ.', 'ar', NOW(), NOW() FROM `notification_types` nt WHERE nt.type = 'order_rate_customer' AND NOT EXISTS (SELECT 1 FROM `notification_type_translations` x WHERE x.notification_type_id = nt.id AND x.lang = 'ar'); INSERT INTO `notification_type_translations` (`notification_type_id`, `name`, `default_text`, `lang`, `created_at`, `updated_at`) SELECT nt.id, 'قيّم طلبك', 'تم توصيل طلبك [[order_code]]. كيف كانت تجربتك؟ قيّمه بثوانٍ.', 'sa', NOW(), NOW() FROM `notification_types` nt WHERE nt.type = 'order_rate_customer' AND NOT EXISTS (SELECT 1 FROM `notification_type_translations` x WHERE x.notification_type_id = nt.id AND x.lang = 'sa'); INSERT INTO `business_settings` (`type`, `value`, `created_at`, `updated_at`) SELECT 'order_rating_alert_emails', 'mohannad@kapitano.shop', NOW(), NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `business_settings` WHERE `type` = 'order_rating_alert_emails'); INSERT INTO `translations` (`lang`, `lang_key`, `lang_value`, `created_at`, `updated_at`) SELECT s.lang, s.lang_key, s.lang_value, NOW(), NOW() FROM ( SELECT 'en' AS lang, 'view_order_ratings' AS lang_key, 'View Order Ratings' AS lang_value UNION ALL SELECT 'ar' AS lang, 'view_order_ratings' AS lang_key, 'عرض تقييمات الطلبات' AS lang_value UNION ALL SELECT 'sa' AS lang, 'view_order_ratings' AS lang_key, 'عرض تقييمات الطلبات' AS lang_value UNION ALL SELECT 'en' AS lang, 'manage_order_rating_settings' AS lang_key, 'Manage Order Rating Settings' AS lang_value UNION ALL SELECT 'ar' AS lang, 'manage_order_rating_settings' AS lang_key, 'إدارة إعدادات تقييم الطلبات' AS lang_value UNION ALL SELECT 'sa' AS lang, 'manage_order_rating_settings' AS lang_key, 'إدارة إعدادات تقييم الطلبات' AS lang_value UNION ALL SELECT 'en' AS lang, 'how_was_your_order' AS lang_key, 'How was your order?' AS lang_value UNION ALL SELECT 'ar' AS lang, 'how_was_your_order' AS lang_key, 'كيف كان طلبك؟' AS lang_value UNION ALL SELECT 'sa' AS lang, 'how_was_your_order' AS lang_key, 'كيف كان طلبك؟' AS lang_value UNION ALL SELECT 'en' AS lang, 'rate_your_order_order_code_and_help_us_serve_you_better' AS lang_key, 'Rate your order [[order_code]] and help us serve you better' AS lang_value UNION ALL SELECT 'ar' AS lang, 'rate_your_order_order_code_and_help_us_serve_you_better' AS lang_key, 'قيّم طلبك [[order_code]] وساعدنا نخدمك بشكل أفضل' AS lang_value UNION ALL SELECT 'sa' AS lang, 'rate_your_order_order_code_and_help_us_serve_you_better' AS lang_key, 'قيّم طلبك [[order_code]] وساعدنا نخدمك بشكل أفضل' AS lang_value UNION ALL SELECT 'en' AS lang, 'shipping__delivery' AS lang_key, 'Shipping & delivery' AS lang_value UNION ALL SELECT 'ar' AS lang, 'shipping__delivery' AS lang_key, 'الشحن والتوصيل' AS lang_value UNION ALL SELECT 'sa' AS lang, 'shipping__delivery' AS lang_key, 'الشحن والتوصيل' AS lang_value UNION ALL SELECT 'en' AS lang, 'packaging__protection' AS lang_key, 'Packaging & protection' AS lang_value UNION ALL SELECT 'ar' AS lang, 'packaging__protection' AS lang_key, 'التغليف والحماية' AS lang_value UNION ALL SELECT 'sa' AS lang, 'packaging__protection' AS lang_key, 'التغليف والحماية' AS lang_value UNION ALL SELECT 'en' AS lang, 'matches_description__photos' AS lang_key, 'Matches description & photos' AS lang_value UNION ALL SELECT 'ar' AS lang, 'matches_description__photos' AS lang_key, 'مطابقة الوصف والصور' AS lang_value UNION ALL SELECT 'sa' AS lang, 'matches_description__photos' AS lang_key, 'مطابقة الوصف والصور' AS lang_value UNION ALL SELECT 'en' AS lang, 'product_price' AS lang_key, 'Product price' AS lang_value UNION ALL SELECT 'ar' AS lang, 'product_price' AS lang_key, 'سعر المنتج' AS lang_value UNION ALL SELECT 'sa' AS lang, 'product_price' AS lang_key, 'سعر المنتج' AS lang_value UNION ALL SELECT 'en' AS lang, 'customer_service__communication' AS lang_key, 'Customer service & communication' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customer_service__communication' AS lang_key, 'خدمة العملاء والتواصل' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customer_service__communication' AS lang_key, 'خدمة العملاء والتواصل' AS lang_value UNION ALL SELECT 'en' AS lang, 'buying_experience_in_the_app' AS lang_key, 'Buying experience in the app' AS lang_value UNION ALL SELECT 'ar' AS lang, 'buying_experience_in_the_app' AS lang_key, 'تجربة الشراء من التطبيق' AS lang_value UNION ALL SELECT 'sa' AS lang, 'buying_experience_in_the_app' AS lang_key, 'تجربة الشراء من التطبيق' AS lang_value UNION ALL SELECT 'en' AS lang, 'your_order_has_arrived' AS lang_key, 'Your order has arrived' AS lang_value UNION ALL SELECT 'ar' AS lang, 'your_order_has_arrived' AS lang_key, 'وصل طلبك' AS lang_value UNION ALL SELECT 'sa' AS lang, 'your_order_has_arrived' AS lang_key, 'وصل طلبك' AS lang_value UNION ALL SELECT 'en' AS lang, 'order' AS lang_key, 'Order' AS lang_value UNION ALL SELECT 'ar' AS lang, 'order' AS lang_key, 'الطلب' AS lang_value UNION ALL SELECT 'sa' AS lang, 'order' AS lang_key, 'الطلب' AS lang_value UNION ALL SELECT 'en' AS lang, 'overall_rating' AS lang_key, 'Overall rating' AS lang_value UNION ALL SELECT 'ar' AS lang, 'overall_rating' AS lang_key, 'التقييم العام' AS lang_value UNION ALL SELECT 'sa' AS lang, 'overall_rating' AS lang_key, 'التقييم العام' AS lang_value UNION ALL SELECT 'en' AS lang, 'very_bad' AS lang_key, 'Very bad' AS lang_value UNION ALL SELECT 'ar' AS lang, 'very_bad' AS lang_key, 'سيئ جداً' AS lang_value UNION ALL SELECT 'sa' AS lang, 'very_bad' AS lang_key, 'سيئ جداً' AS lang_value UNION ALL SELECT 'en' AS lang, 'bad' AS lang_key, 'Bad' AS lang_value UNION ALL SELECT 'ar' AS lang, 'bad' AS lang_key, 'سيئ' AS lang_value UNION ALL SELECT 'sa' AS lang, 'bad' AS lang_key, 'سيئ' AS lang_value UNION ALL SELECT 'en' AS lang, 'okay' AS lang_key, 'Okay' AS lang_value UNION ALL SELECT 'ar' AS lang, 'okay' AS lang_key, 'مقبول' AS lang_value UNION ALL SELECT 'sa' AS lang, 'okay' AS lang_key, 'مقبول' AS lang_value UNION ALL SELECT 'en' AS lang, 'good' AS lang_key, 'Good' AS lang_value UNION ALL SELECT 'ar' AS lang, 'good' AS lang_key, 'جيد' AS lang_value UNION ALL SELECT 'sa' AS lang, 'good' AS lang_key, 'جيد' AS lang_value UNION ALL SELECT 'en' AS lang, 'excellent' AS lang_key, 'Excellent' AS lang_value UNION ALL SELECT 'ar' AS lang, 'excellent' AS lang_key, 'ممتاز' AS lang_value UNION ALL SELECT 'sa' AS lang, 'excellent' AS lang_key, 'ممتاز' AS lang_value UNION ALL SELECT 'en' AS lang, 'tap_a_star_to_rate' AS lang_key, 'Tap a star to rate' AS lang_value UNION ALL SELECT 'ar' AS lang, 'tap_a_star_to_rate' AS lang_key, 'اضغط على نجمة للتقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'tap_a_star_to_rate' AS lang_key, 'اضغط على نجمة للتقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'sorry_it_was_not_perfect_tell_us_what_fell_short' AS lang_key, 'Sorry it was not perfect. Tell us what fell short:' AS lang_value UNION ALL SELECT 'ar' AS lang, 'sorry_it_was_not_perfect_tell_us_what_fell_short' AS lang_key, 'نأسف لأن التجربة لم تكن كاملة. أخبرنا أين كان التقصير:' AS lang_value UNION ALL SELECT 'sa' AS lang, 'sorry_it_was_not_perfect_tell_us_what_fell_short' AS lang_key, 'نأسف لأن التجربة لم تكن كاملة. أخبرنا أين كان التقصير:' AS lang_value UNION ALL SELECT 'en' AS lang, 'write_a_note_about_your_order_optional' AS lang_key, 'Write a note about your order (optional)' AS lang_value UNION ALL SELECT 'ar' AS lang, 'write_a_note_about_your_order_optional' AS lang_key, 'اكتب ملاحظة عن طلبك (اختياري)' AS lang_value UNION ALL SELECT 'sa' AS lang, 'write_a_note_about_your_order_optional' AS lang_key, 'اكتب ملاحظة عن طلبك (اختياري)' AS lang_value UNION ALL SELECT 'en' AS lang, 'send_rating' AS lang_key, 'Send rating' AS lang_value UNION ALL SELECT 'ar' AS lang, 'send_rating' AS lang_key, 'إرسال التقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'send_rating' AS lang_key, 'إرسال التقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'sending' AS lang_key, 'Sending...' AS lang_value UNION ALL SELECT 'ar' AS lang, 'sending' AS lang_key, 'جارٍ الإرسال...' AS lang_value UNION ALL SELECT 'sa' AS lang, 'sending' AS lang_key, 'جارٍ الإرسال...' AS lang_value UNION ALL SELECT 'en' AS lang, 'later' AS lang_key, 'Later' AS lang_value UNION ALL SELECT 'ar' AS lang, 'later' AS lang_key, 'لاحقاً' AS lang_value UNION ALL SELECT 'sa' AS lang, 'later' AS lang_key, 'لاحقاً' AS lang_value UNION ALL SELECT 'en' AS lang, 'dont_ask_about_this_order' AS lang_key, 'Don''t ask about this order' AS lang_value UNION ALL SELECT 'ar' AS lang, 'dont_ask_about_this_order' AS lang_key, 'لا تسألني عن هذا الطلب' AS lang_value UNION ALL SELECT 'sa' AS lang, 'dont_ask_about_this_order' AS lang_key, 'لا تسألني عن هذا الطلب' AS lang_value UNION ALL SELECT 'en' AS lang, 'please_rate_each_item_above' AS lang_key, 'Please rate each item above.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'please_rate_each_item_above' AS lang_key, 'يرجى تقييم كل بند من البنود أعلاه.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'please_rate_each_item_above' AS lang_key, 'يرجى تقييم كل بند من البنود أعلاه.' AS lang_value UNION ALL SELECT 'en' AS lang, 'something_went_wrong_please_try_again' AS lang_key, 'Something went wrong, please try again.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'something_went_wrong_please_try_again' AS lang_key, 'حدث خطأ، يرجى المحاولة مرة أخرى.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'something_went_wrong_please_try_again' AS lang_key, 'حدث خطأ، يرجى المحاولة مرة أخرى.' AS lang_value UNION ALL SELECT 'en' AS lang, 'thank_you_for_your_rating' AS lang_key, 'Thank you for your rating!' AS lang_value UNION ALL SELECT 'ar' AS lang, 'thank_you_for_your_rating' AS lang_key, 'شكراً لتقييمك!' AS lang_value UNION ALL SELECT 'sa' AS lang, 'thank_you_for_your_rating' AS lang_key, 'شكراً لتقييمك!' AS lang_value UNION ALL SELECT 'en' AS lang, 'thank_you_your_rating_has_been_received' AS lang_key, 'Thank you! Your rating has been received.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'thank_you_your_rating_has_been_received' AS lang_key, 'شكراً لك! تم استلام تقييمك.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'thank_you_your_rating_has_been_received' AS lang_key, 'شكراً لك! تم استلام تقييمك.' AS lang_value UNION ALL SELECT 'en' AS lang, 'we_are_glad_you_liked_your_order' AS lang_key, 'We are glad you liked your order.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'we_are_glad_you_liked_your_order' AS lang_key, 'يسعدنا أن طلبك نال إعجابك.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'we_are_glad_you_liked_your_order' AS lang_key, 'يسعدنا أن طلبك نال إعجابك.' AS lang_value UNION ALL SELECT 'en' AS lang, 'your_feedback_reached_our_team_and_we_will_work_on_it' AS lang_key, 'Your feedback reached our team and we will work on it.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'your_feedback_reached_our_team_and_we_will_work_on_it' AS lang_key, 'وصلت ملاحظاتك إلى فريقنا وسنعمل عليها.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'your_feedback_reached_our_team_and_we_will_work_on_it' AS lang_key, 'وصلت ملاحظاتك إلى فريقنا وسنعمل عليها.' AS lang_value UNION ALL SELECT 'en' AS lang, 'your_rating_of_this_order' AS lang_key, 'Your rating of this order' AS lang_value UNION ALL SELECT 'ar' AS lang, 'your_rating_of_this_order' AS lang_key, 'تقييمك لهذا الطلب' AS lang_value UNION ALL SELECT 'sa' AS lang, 'your_rating_of_this_order' AS lang_key, 'تقييمك لهذا الطلب' AS lang_value UNION ALL SELECT 'en' AS lang, 'rate_order' AS lang_key, 'Rate order' AS lang_value UNION ALL SELECT 'ar' AS lang, 'rate_order' AS lang_key, 'قيّم الطلب' AS lang_value UNION ALL SELECT 'sa' AS lang, 'rate_order' AS lang_key, 'قيّم الطلب' AS lang_value UNION ALL SELECT 'en' AS lang, 'rated' AS lang_key, 'Rated' AS lang_value UNION ALL SELECT 'ar' AS lang, 'rated' AS lang_key, 'تم التقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'rated' AS lang_key, 'تم التقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'comment' AS lang_key, 'Comment' AS lang_value UNION ALL SELECT 'ar' AS lang, 'comment' AS lang_key, 'التعليق' AS lang_value UNION ALL SELECT 'sa' AS lang, 'comment' AS lang_key, 'التعليق' AS lang_value UNION ALL SELECT 'en' AS lang, 'this_order_is_not_yours' AS lang_key, 'This order is not yours.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'this_order_is_not_yours' AS lang_key, 'هذا الطلب ليس لك.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'this_order_is_not_yours' AS lang_key, 'هذا الطلب ليس لك.' AS lang_value UNION ALL SELECT 'en' AS lang, 'you_can_rate_an_order_once_it_is_delivered' AS lang_key, 'You can rate an order once it is delivered.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'you_can_rate_an_order_once_it_is_delivered' AS lang_key, 'يمكنك تقييم الطلب بعد توصيله.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'you_can_rate_an_order_once_it_is_delivered' AS lang_key, 'يمكنك تقييم الطلب بعد توصيله.' AS lang_value UNION ALL SELECT 'en' AS lang, 'you_have_already_rated_this_order' AS lang_key, 'You have already rated this order.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'you_have_already_rated_this_order' AS lang_key, 'لقد قيّمت هذا الطلب مسبقاً.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'you_have_already_rated_this_order' AS lang_key, 'لقد قيّمت هذا الطلب مسبقاً.' AS lang_value UNION ALL SELECT 'en' AS lang, 'order_ratings_are_not_available_yet' AS lang_key, 'Order ratings are not available yet.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'order_ratings_are_not_available_yet' AS lang_key, 'تقييم الطلبات غير متاح بعد.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'order_ratings_are_not_available_yet' AS lang_key, 'تقييم الطلبات غير متاح بعد.' AS lang_value UNION ALL SELECT 'en' AS lang, 'order_not_found' AS lang_key, 'Order not found' AS lang_value UNION ALL SELECT 'ar' AS lang, 'order_not_found' AS lang_key, 'الطلب غير موجود' AS lang_value UNION ALL SELECT 'sa' AS lang, 'order_not_found' AS lang_key, 'الطلب غير موجود' AS lang_value UNION ALL SELECT 'en' AS lang, 'order_ratings' AS lang_key, 'Order ratings' AS lang_value UNION ALL SELECT 'ar' AS lang, 'order_ratings' AS lang_key, 'تقييمات الطلبات' AS lang_value UNION ALL SELECT 'sa' AS lang, 'order_ratings' AS lang_key, 'تقييمات الطلبات' AS lang_value UNION ALL SELECT 'en' AS lang, 'what_customers_say_once_their_order_is_delivered_below_5_stars_they_tell_us_what_fell_short' AS lang_key, 'What customers say once their order is delivered. Below 5 stars they tell us what fell short.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'what_customers_say_once_their_order_is_delivered_below_5_stars_they_tell_us_what_fell_short' AS lang_key, 'ما يقوله العملاء بعد توصيل طلباتهم. عند التقييم بأقل من 5 نجوم يخبروننا أين كان التقصير.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'what_customers_say_once_their_order_is_delivered_below_5_stars_they_tell_us_what_fell_short' AS lang_key, 'ما يقوله العملاء بعد توصيل طلباتهم. عند التقييم بأقل من 5 نجوم يخبروننا أين كان التقصير.' AS lang_value UNION ALL SELECT 'en' AS lang, 'order_code_customer_phone_or_comment' AS lang_key, 'Order code, customer, phone or comment' AS lang_value UNION ALL SELECT 'ar' AS lang, 'order_code_customer_phone_or_comment' AS lang_key, 'رقم الطلب، العميل، الهاتف أو التعليق' AS lang_value UNION ALL SELECT 'sa' AS lang, 'order_code_customer_phone_or_comment' AS lang_key, 'رقم الطلب، العميل، الهاتف أو التعليق' AS lang_value UNION ALL SELECT 'en' AS lang, 'not_rated_yet' AS lang_key, 'Not rated yet' AS lang_value UNION ALL SELECT 'ar' AS lang, 'not_rated_yet' AS lang_key, 'لم يُقيَّم بعد' AS lang_value UNION ALL SELECT 'sa' AS lang, 'not_rated_yet' AS lang_key, 'لم يُقيَّم بعد' AS lang_value UNION ALL SELECT 'en' AS lang, 'declined_to_rate' AS lang_key, 'Declined to rate' AS lang_value UNION ALL SELECT 'ar' AS lang, 'declined_to_rate' AS lang_key, 'رفض التقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'declined_to_rate' AS lang_key, 'رفض التقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'below_5_stars' AS lang_key, 'Below 5 stars' AS lang_value UNION ALL SELECT 'ar' AS lang, 'below_5_stars' AS lang_key, 'أقل من 5 نجوم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'below_5_stars' AS lang_key, 'أقل من 5 نجوم' AS lang_value UNION ALL SELECT 'en' AS lang, 'weak_on' AS lang_key, 'Weak on' AS lang_value UNION ALL SELECT 'ar' AS lang, 'weak_on' AS lang_key, 'ضعيف في' AS lang_value UNION ALL SELECT 'sa' AS lang, 'weak_on' AS lang_key, 'ضعيف في' AS lang_value UNION ALL SELECT 'en' AS lang, 'with_a_comment_only' AS lang_key, 'With a comment only' AS lang_value UNION ALL SELECT 'ar' AS lang, 'with_a_comment_only' AS lang_key, 'مع تعليق فقط' AS lang_value UNION ALL SELECT 'sa' AS lang, 'with_a_comment_only' AS lang_key, 'مع تعليق فقط' AS lang_value UNION ALL SELECT 'en' AS lang, 'ratings' AS lang_key, 'ratings' AS lang_value UNION ALL SELECT 'ar' AS lang, 'ratings' AS lang_key, 'تقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'ratings' AS lang_key, 'تقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'five_stars' AS lang_key, 'five stars' AS lang_value UNION ALL SELECT 'ar' AS lang, 'five_stars' AS lang_key, 'خمس نجوم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'five_stars' AS lang_key, 'خمس نجوم' AS lang_value UNION ALL SELECT 'en' AS lang, 'no_ratings_in_this_range_yet' AS lang_key, 'No ratings in this range yet' AS lang_value UNION ALL SELECT 'ar' AS lang, 'no_ratings_in_this_range_yet' AS lang_key, 'لا توجد تقييمات في هذه الفترة بعد' AS lang_value UNION ALL SELECT 'sa' AS lang, 'no_ratings_in_this_range_yet' AS lang_key, 'لا توجد تقييمات في هذه الفترة بعد' AS lang_value UNION ALL SELECT 'en' AS lang, 'rating_distribution' AS lang_key, 'Rating distribution' AS lang_value UNION ALL SELECT 'ar' AS lang, 'rating_distribution' AS lang_key, 'توزيع التقييمات' AS lang_value UNION ALL SELECT 'sa' AS lang, 'rating_distribution' AS lang_key, 'توزيع التقييمات' AS lang_value UNION ALL SELECT 'en' AS lang, 'where_it_fell_short' AS lang_key, 'Where it fell short' AS lang_value UNION ALL SELECT 'ar' AS lang, 'where_it_fell_short' AS lang_key, 'أين كان التقصير' AS lang_value UNION ALL SELECT 'sa' AS lang, 'where_it_fell_short' AS lang_key, 'أين كان التقصير' AS lang_value UNION ALL SELECT 'en' AS lang, 'average_of_the_ratings_below_5_stars_weakest_first' AS lang_key, 'Average of the ratings below 5 stars, weakest first' AS lang_value UNION ALL SELECT 'ar' AS lang, 'average_of_the_ratings_below_5_stars_weakest_first' AS lang_key, 'متوسط التقييمات الأقل من 5 نجوم، الأضعف أولاً' AS lang_value UNION ALL SELECT 'sa' AS lang, 'average_of_the_ratings_below_5_stars_weakest_first' AS lang_key, 'متوسط التقييمات الأقل من 5 نجوم، الأضعف أولاً' AS lang_value UNION ALL SELECT 'en' AS lang, 'no_rating_below_5_stars_in_this_range' AS lang_key, 'No rating below 5 stars in this range.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'no_rating_below_5_stars_in_this_range' AS lang_key, 'لا يوجد تقييم أقل من 5 نجوم في هذه الفترة.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'no_rating_below_5_stars_in_this_range' AS lang_key, 'لا يوجد تقييم أقل من 5 نجوم في هذه الفترة.' AS lang_value UNION ALL SELECT 'en' AS lang, 'weakest_point' AS lang_key, 'Weakest point' AS lang_value UNION ALL SELECT 'ar' AS lang, 'weakest_point' AS lang_key, 'أضعف نقطة' AS lang_value UNION ALL SELECT 'sa' AS lang, 'weakest_point' AS lang_key, 'أضعف نقطة' AS lang_value UNION ALL SELECT 'en' AS lang, 'customers_asked' AS lang_key, 'Customers asked' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customers_asked' AS lang_key, 'عملاء طُلب منهم التقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customers_asked' AS lang_key, 'عملاء طُلب منهم التقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'customers_have_not_rated_yet' AS lang_key, 'customers have not rated yet' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customers_have_not_rated_yet' AS lang_key, 'لم يقيّموا بعد' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customers_have_not_rated_yet' AS lang_key, 'لم يقيّموا بعد' AS lang_value UNION ALL SELECT 'en' AS lang, 'customers_declined' AS lang_key, 'customers declined' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customers_declined' AS lang_key, 'رفضوا' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customers_declined' AS lang_key, 'رفضوا' AS lang_value UNION ALL SELECT 'en' AS lang, 'purchases_delivered_in_this_range_the_customer_is_asked_once_per_purchase_even_when_it_came_from_several_sellers' AS lang_key, 'Purchases delivered in this range; the customer is asked once per purchase, even when it came from several sellers.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'purchases_delivered_in_this_range_the_customer_is_asked_once_per_purchase_even_when_it_came_from_several_sellers' AS lang_key, 'الطلبات المُسلَّمة في هذه الفترة؛ يُطلب من العميل تقييم واحد لكل طلب حتى لو كان من أكثر من تاجر.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'purchases_delivered_in_this_range_the_customer_is_asked_once_per_purchase_even_when_it_came_from_several_sellers' AS lang_key, 'الطلبات المُسلَّمة في هذه الفترة؛ يُطلب من العميل تقييم واحد لكل طلب حتى لو كان من أكثر من تاجر.' AS lang_value UNION ALL SELECT 'en' AS lang, 'sellers_in_this_purchase' AS lang_key, 'sellers in this purchase' AS lang_value UNION ALL SELECT 'ar' AS lang, 'sellers_in_this_purchase' AS lang_key, 'تجار في هذا الطلب' AS lang_value UNION ALL SELECT 'sa' AS lang, 'sellers_in_this_purchase' AS lang_key, 'تجار في هذا الطلب' AS lang_value UNION ALL SELECT 'en' AS lang, 'customers_rated' AS lang_key, 'customers rated' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customers_rated' AS lang_key, 'قيّموا' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customers_rated' AS lang_key, 'قيّموا' AS lang_value UNION ALL SELECT 'en' AS lang, 'each_one_was_emailed_to' AS lang_key, 'Each one was emailed to' AS lang_value UNION ALL SELECT 'ar' AS lang, 'each_one_was_emailed_to' AS lang_key, 'يُرسل كل واحد بالإيميل إلى' AS lang_value UNION ALL SELECT 'sa' AS lang, 'each_one_was_emailed_to' AS lang_key, 'يُرسل كل واحد بالإيميل إلى' AS lang_value UNION ALL SELECT 'en' AS lang, 'with_a_comment' AS lang_key, 'With a comment' AS lang_value UNION ALL SELECT 'ar' AS lang, 'with_a_comment' AS lang_key, 'مع تعليق' AS lang_value UNION ALL SELECT 'sa' AS lang, 'with_a_comment' AS lang_key, 'مع تعليق' AS lang_value UNION ALL SELECT 'en' AS lang, 'became_product_reviews' AS lang_key, 'became product reviews' AS lang_value UNION ALL SELECT 'ar' AS lang, 'became_product_reviews' AS lang_key, 'أصبحت تقييمات منتجات' AS lang_value UNION ALL SELECT 'sa' AS lang, 'became_product_reviews' AS lang_key, 'أصبحت تقييمات منتجات' AS lang_value UNION ALL SELECT 'en' AS lang, 'a_oneproduct_order_is_also_published_as_a_review_of_that_product' AS lang_key, 'A one-product order is also published as a review of that product.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'a_oneproduct_order_is_also_published_as_a_review_of_that_product' AS lang_key, 'الطلب الذي يحوي منتجاً واحداً يُنشر تقييمه أيضاً كتقييم لذلك المنتج.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'a_oneproduct_order_is_also_published_as_a_review_of_that_product' AS lang_key, 'الطلب الذي يحوي منتجاً واحداً يُنشر تقييمه أيضاً كتقييم لذلك المنتج.' AS lang_value UNION ALL SELECT 'en' AS lang, 'customer_ratings' AS lang_key, 'Customer ratings' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customer_ratings' AS lang_key, 'تقييمات العملاء' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customer_ratings' AS lang_key, 'تقييمات العملاء' AS lang_value UNION ALL SELECT 'en' AS lang, 'no_ratings_match_these_filters' AS lang_key, 'No ratings match these filters.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'no_ratings_match_these_filters' AS lang_key, 'لا توجد تقييمات مطابقة لهذه الفلاتر.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'no_ratings_match_these_filters' AS lang_key, 'لا توجد تقييمات مطابقة لهذه الفلاتر.' AS lang_value UNION ALL SELECT 'en' AS lang, 'customers_are_asked_to_rate_an_order_the_moment_it_is_marked_delivered' AS lang_key, 'Customers are asked to rate an order the moment it is marked delivered.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customers_are_asked_to_rate_an_order_the_moment_it_is_marked_delivered' AS lang_key, 'يُطلب من العميل تقييم الطلب لحظة تحويله إلى "تم التوصيل".' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customers_are_asked_to_rate_an_order_the_moment_it_is_marked_delivered' AS lang_key, 'يُطلب من العميل تقييم الطلب لحظة تحويله إلى "تم التوصيل".' AS lang_value UNION ALL SELECT 'en' AS lang, 'asked' AS lang_key, 'Asked' AS lang_value UNION ALL SELECT 'ar' AS lang, 'asked' AS lang_key, 'طُلب التقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'asked' AS lang_key, 'طُلب التقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'product_review' AS lang_key, 'Product review' AS lang_value UNION ALL SELECT 'ar' AS lang, 'product_review' AS lang_key, 'تقييم منتج' AS lang_value UNION ALL SELECT 'sa' AS lang, 'product_review' AS lang_key, 'تقييم منتج' AS lang_value UNION ALL SELECT 'en' AS lang, 'website' AS lang_key, 'Website' AS lang_value UNION ALL SELECT 'ar' AS lang, 'website' AS lang_key, 'الموقع' AS lang_value UNION ALL SELECT 'sa' AS lang, 'website' AS lang_key, 'الموقع' AS lang_value UNION ALL SELECT 'en' AS lang, 'app' AS lang_key, 'App' AS lang_value UNION ALL SELECT 'ar' AS lang, 'app' AS lang_key, 'التطبيق' AS lang_value UNION ALL SELECT 'sa' AS lang, 'app' AS lang_key, 'التطبيق' AS lang_value UNION ALL SELECT 'en' AS lang, 'email_these_addresses_when_an_order_gets_below_5_stars' AS lang_key, 'Email these addresses when an order gets below 5 stars' AS lang_value UNION ALL SELECT 'ar' AS lang, 'email_these_addresses_when_an_order_gets_below_5_stars' AS lang_key, 'أرسل إيميل إلى هذه العناوين عند تقييم طلب بأقل من 5 نجوم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'email_these_addresses_when_an_order_gets_below_5_stars' AS lang_key, 'أرسل إيميل إلى هذه العناوين عند تقييم طلب بأقل من 5 نجوم' AS lang_value UNION ALL SELECT 'en' AS lang, 'separate_several_addresses_with_commas_these_emails_are_sent_even_while_site_email_is_switched_off' AS lang_key, 'Separate several addresses with commas. These emails are sent even while site email is switched off.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'separate_several_addresses_with_commas_these_emails_are_sent_even_while_site_email_is_switched_off' AS lang_key, 'افصل بين العناوين بفاصلة. تُرسل هذه الإيميلات حتى لو كان إرسال الإيميل في الموقع متوقفاً.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'separate_several_addresses_with_commas_these_emails_are_sent_even_while_site_email_is_switched_off' AS lang_key, 'افصل بين العناوين بفاصلة. تُرسل هذه الإيميلات حتى لو كان إرسال الإيميل في الموقع متوقفاً.' AS lang_value UNION ALL SELECT 'en' AS lang, 'invalid_email' AS lang_key, 'Invalid email' AS lang_value UNION ALL SELECT 'ar' AS lang, 'invalid_email' AS lang_key, 'إيميل غير صالح' AS lang_value UNION ALL SELECT 'sa' AS lang, 'invalid_email' AS lang_key, 'إيميل غير صالح' AS lang_value UNION ALL SELECT 'en' AS lang, 'newest' AS lang_key, 'Newest' AS lang_value UNION ALL SELECT 'ar' AS lang, 'newest' AS lang_key, 'الأحدث' AS lang_value UNION ALL SELECT 'sa' AS lang, 'newest' AS lang_key, 'الأحدث' AS lang_value UNION ALL SELECT 'en' AS lang, 'oldest' AS lang_key, 'Oldest' AS lang_value UNION ALL SELECT 'ar' AS lang, 'oldest' AS lang_key, 'الأقدم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'oldest' AS lang_key, 'الأقدم' AS lang_value UNION ALL SELECT 'en' AS lang, 'lowest_rating_first' AS lang_key, 'Lowest rating first' AS lang_value UNION ALL SELECT 'ar' AS lang, 'lowest_rating_first' AS lang_key, 'الأقل تقييماً أولاً' AS lang_value UNION ALL SELECT 'sa' AS lang, 'lowest_rating_first' AS lang_key, 'الأقل تقييماً أولاً' AS lang_value UNION ALL SELECT 'en' AS lang, 'highest_rating_first' AS lang_key, 'Highest rating first' AS lang_value UNION ALL SELECT 'ar' AS lang, 'highest_rating_first' AS lang_key, 'الأعلى تقييماً أولاً' AS lang_value UNION ALL SELECT 'sa' AS lang, 'highest_rating_first' AS lang_key, 'الأعلى تقييماً أولاً' AS lang_value UNION ALL SELECT 'en' AS lang, 'customer_comment' AS lang_key, 'Customer comment' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customer_comment' AS lang_key, 'تعليق العميل' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customer_comment' AS lang_key, 'تعليق العميل' AS lang_value UNION ALL SELECT 'en' AS lang, 'the_customer_left_no_comment' AS lang_key, 'The customer left no comment.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'the_customer_left_no_comment' AS lang_key, 'لم يكتب العميل تعليقاً.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'the_customer_left_no_comment' AS lang_key, 'لم يكتب العميل تعليقاً.' AS lang_value UNION ALL SELECT 'en' AS lang, 'details_of_the_rating' AS lang_key, 'Details of the rating' AS lang_value UNION ALL SELECT 'ar' AS lang, 'details_of_the_rating' AS lang_key, 'تفاصيل التقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'details_of_the_rating' AS lang_key, 'تفاصيل التقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'five_stars_the_customer_was_not_asked_for_details' AS lang_key, 'Five stars: the customer was not asked for details.' AS lang_value UNION ALL SELECT 'ar' AS lang, 'five_stars_the_customer_was_not_asked_for_details' AS lang_key, 'خمس نجوم: لم يُطلب من العميل تفاصيل.' AS lang_value UNION ALL SELECT 'sa' AS lang, 'five_stars_the_customer_was_not_asked_for_details' AS lang_key, 'خمس نجوم: لم يُطلب من العميل تفاصيل.' AS lang_value UNION ALL SELECT 'en' AS lang, 'products_in_the_order' AS lang_key, 'Products in the order' AS lang_value UNION ALL SELECT 'ar' AS lang, 'products_in_the_order' AS lang_key, 'منتجات الطلب' AS lang_value UNION ALL SELECT 'sa' AS lang, 'products_in_the_order' AS lang_key, 'منتجات الطلب' AS lang_value UNION ALL SELECT 'en' AS lang, 'deleted_product' AS lang_key, 'Deleted product' AS lang_value UNION ALL SELECT 'ar' AS lang, 'deleted_product' AS lang_key, 'منتج محذوف' AS lang_value UNION ALL SELECT 'sa' AS lang, 'deleted_product' AS lang_key, 'منتج محذوف' AS lang_value UNION ALL SELECT 'en' AS lang, 'customer__order' AS lang_key, 'Customer & order' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customer__order' AS lang_key, 'العميل والطلب' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customer__order' AS lang_key, 'العميل والطلب' AS lang_value UNION ALL SELECT 'en' AS lang, 'inhouse' AS lang_key, 'In-house' AS lang_value UNION ALL SELECT 'ar' AS lang, 'inhouse' AS lang_key, 'متجرنا' AS lang_value UNION ALL SELECT 'sa' AS lang, 'inhouse' AS lang_key, 'متجرنا' AS lang_value UNION ALL SELECT 'en' AS lang, 'published_as_a_review_of' AS lang_key, 'Published as a review of' AS lang_value UNION ALL SELECT 'ar' AS lang, 'published_as_a_review_of' AS lang_key, 'نُشر كتقييم للمنتج' AS lang_value UNION ALL SELECT 'sa' AS lang, 'published_as_a_review_of' AS lang_key, 'نُشر كتقييم للمنتج' AS lang_value UNION ALL SELECT 'en' AS lang, 'open_the_product_reviews' AS lang_key, 'Open the product reviews' AS lang_value UNION ALL SELECT 'ar' AS lang, 'open_the_product_reviews' AS lang_key, 'فتح تقييمات المنتج' AS lang_value UNION ALL SELECT 'sa' AS lang, 'open_the_product_reviews' AS lang_key, 'فتح تقييمات المنتج' AS lang_value UNION ALL SELECT 'en' AS lang, 'no_product_review_was_created' AS lang_key, 'No product review was created' AS lang_value UNION ALL SELECT 'ar' AS lang, 'no_product_review_was_created' AS lang_key, 'لم يُنشأ تقييم منتج' AS lang_value UNION ALL SELECT 'sa' AS lang, 'no_product_review_was_created' AS lang_key, 'لم يُنشأ تقييم منتج' AS lang_value UNION ALL SELECT 'en' AS lang, 'the_order_holds_more_than_one_product' AS lang_key, 'The order holds more than one product' AS lang_value UNION ALL SELECT 'ar' AS lang, 'the_order_holds_more_than_one_product' AS lang_key, 'الطلب يحوي أكثر من منتج' AS lang_value UNION ALL SELECT 'sa' AS lang, 'the_order_holds_more_than_one_product' AS lang_key, 'الطلب يحوي أكثر من منتج' AS lang_value UNION ALL SELECT 'en' AS lang, 'the_customer_had_already_reviewed_this_product' AS lang_key, 'The customer had already reviewed this product' AS lang_value UNION ALL SELECT 'ar' AS lang, 'the_customer_had_already_reviewed_this_product' AS lang_key, 'العميل قيّم هذا المنتج مسبقاً' AS lang_value UNION ALL SELECT 'sa' AS lang, 'the_customer_had_already_reviewed_this_product' AS lang_key, 'العميل قيّم هذا المنتج مسبقاً' AS lang_value UNION ALL SELECT 'en' AS lang, 'the_product_no_longer_exists' AS lang_key, 'The product no longer exists' AS lang_value UNION ALL SELECT 'ar' AS lang, 'the_product_no_longer_exists' AS lang_key, 'المنتج لم يعد موجوداً' AS lang_value UNION ALL SELECT 'sa' AS lang, 'the_product_no_longer_exists' AS lang_key, 'المنتج لم يعد موجوداً' AS lang_value UNION ALL SELECT 'en' AS lang, 'timeline' AS lang_key, 'Timeline' AS lang_value UNION ALL SELECT 'ar' AS lang, 'timeline' AS lang_key, 'التسلسل الزمني' AS lang_value UNION ALL SELECT 'sa' AS lang, 'timeline' AS lang_key, 'التسلسل الزمني' AS lang_value UNION ALL SELECT 'en' AS lang, 'notification' AS lang_key, 'Notification' AS lang_value UNION ALL SELECT 'ar' AS lang, 'notification' AS lang_key, 'الإشعار' AS lang_value UNION ALL SELECT 'sa' AS lang, 'notification' AS lang_key, 'الإشعار' AS lang_value UNION ALL SELECT 'en' AS lang, 'declined' AS lang_key, 'Declined' AS lang_value UNION ALL SELECT 'ar' AS lang, 'declined' AS lang_key, 'رفض' AS lang_value UNION ALL SELECT 'sa' AS lang, 'declined' AS lang_key, 'رفض' AS lang_value UNION ALL SELECT 'en' AS lang, 'alert_email' AS lang_key, 'Alert email' AS lang_value UNION ALL SELECT 'ar' AS lang, 'alert_email' AS lang_key, 'إيميل التنبيه' AS lang_value UNION ALL SELECT 'sa' AS lang, 'alert_email' AS lang_key, 'إيميل التنبيه' AS lang_value UNION ALL SELECT 'en' AS lang, 'not_sent' AS lang_key, 'Not sent' AS lang_value UNION ALL SELECT 'ar' AS lang, 'not_sent' AS lang_key, 'لم يُرسل' AS lang_value UNION ALL SELECT 'sa' AS lang, 'not_sent' AS lang_key, 'لم يُرسل' AS lang_value UNION ALL SELECT 'en' AS lang, 'customer_rating' AS lang_key, 'Customer rating' AS lang_value UNION ALL SELECT 'ar' AS lang, 'customer_rating' AS lang_key, 'تقييم العميل' AS lang_value UNION ALL SELECT 'sa' AS lang, 'customer_rating' AS lang_key, 'تقييم العميل' AS lang_value UNION ALL SELECT 'en' AS lang, 'delivered__asked' AS lang_key, 'Delivered / asked' AS lang_value UNION ALL SELECT 'ar' AS lang, 'delivered__asked' AS lang_key, 'تاريخ التوصيل / الطلب' AS lang_value UNION ALL SELECT 'sa' AS lang, 'delivered__asked' AS lang_key, 'تاريخ التوصيل / الطلب' AS lang_value UNION ALL SELECT 'en' AS lang, 'rated_at' AS lang_key, 'Rated at' AS lang_value UNION ALL SELECT 'ar' AS lang, 'rated_at' AS lang_key, 'تاريخ التقييم' AS lang_value UNION ALL SELECT 'sa' AS lang, 'rated_at' AS lang_key, 'تاريخ التقييم' AS lang_value UNION ALL SELECT 'en' AS lang, 'source' AS lang_key, 'Source' AS lang_value UNION ALL SELECT 'ar' AS lang, 'source' AS lang_key, 'المصدر' AS lang_value UNION ALL SELECT 'sa' AS lang, 'source' AS lang_key, 'المصدر' AS lang_value ) s WHERE NOT EXISTS (SELECT 1 FROM `translations` t WHERE t.lang = s.lang AND t.lang_key = s.lang_key);