-- =====================================================================
-- Edit order shipping cost (order page > "Shipping (SYP)" field)
--
-- No schema change: shipping already lives on combined_orders.shipping_cost.
-- The admin edits it from the order page; the controller zeroes the legacy
-- order_details.shipping_cost of every child order and re-derives the combined
-- grand_total through CombinedOrderCouponUtility::recalculate().
--
-- 1. Permission `edit_order_shipping_cost` in the "Orders" Staff Roles section,
--    granted to nobody: tick it in Staff > Roles for whoever may adjust an
--    order's shipping (repeat customer, a staff order, …).
-- 2. Arabic UI strings.
--
-- Same rows as migration 2026_10_08_000001_add_edit_order_shipping_cost_permission.
-- Re-running the file changes nothing (only missing rows are inserted).
-- After running: php artisan cache:clear (permissions and translations are cached).
-- =====================================================================

SET NAMES utf8mb4;

INSERT INTO `permissions` (`name`, `section`, `guard_name`, `created_at`, `updated_at`)
SELECT 'edit_order_shipping_cost', 'orders', 'web', NOW(), NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM `permissions` WHERE `name` = 'edit_order_shipping_cost' AND `guard_name` = 'web'
);

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, 'edit_order_shipping_cost' AS lang_key, 'Edit Order Shipping Cost' AS lang_value
        UNION ALL SELECT 'ar', 'edit_order_shipping_cost', 'تعديل أجور شحن الطلب'
        UNION ALL SELECT 'sa', 'edit_order_shipping_cost', 'تعديل أجور شحن الطلب'
        UNION ALL SELECT 'en', 'orders', 'Orders'
        UNION ALL SELECT 'ar', 'orders', 'الطلبات'
        UNION ALL SELECT 'sa', 'orders', 'الطلبات'
        UNION ALL SELECT 'en', 'shipping_syp', 'Shipping (SYP)'
        UNION ALL SELECT 'ar', 'shipping_syp', 'الشحن (ل.س)'
        UNION ALL SELECT 'sa', 'shipping_syp', 'الشحن (ل.س)'
        UNION ALL SELECT 'en', 'edit_shipping', 'Edit shipping'
        UNION ALL SELECT 'ar', 'edit_shipping', 'تعديل الشحن'
        UNION ALL SELECT 'sa', 'edit_shipping', 'تعديل الشحن'
        UNION ALL SELECT 'en', 'shipping_cost_has_been_updated', 'Shipping cost has been updated'
        UNION ALL SELECT 'ar', 'shipping_cost_has_been_updated', 'تم تحديث أجور الشحن'
        UNION ALL SELECT 'sa', 'shipping_cost_has_been_updated', 'تم تحديث أجور الشحن'
        UNION ALL SELECT 'en', 'shipping_cost_must_be_zero_or_more', 'Shipping cost must be zero or more.'
        UNION ALL SELECT 'ar', 'shipping_cost_must_be_zero_or_more', 'يجب أن تكون أجور الشحن صفراً أو أكثر.'
        UNION ALL SELECT 'sa', 'shipping_cost_must_be_zero_or_more', 'يجب أن تكون أجور الشحن صفراً أو أكثر.'
) AS s
WHERE NOT EXISTS (
    SELECT 1 FROM `translations` t
    WHERE t.lang = s.lang AND t.lang_key = s.lang_key
);