-- Grant permission to customer_statement.php for all users who have access to customers.php
INSERT IGNORE INTO user_permissions (user_id, page, can_view, can_add, can_edit, can_delete)
SELECT user_id, 'customer_statement.php', can_view, can_add, can_edit, can_delete
FROM user_permissions
WHERE page = 'customers.php'
ON DUPLICATE KEY UPDATE can_view = VALUES(can_view);
