-- =========================================================================
-- MIGRATION: Susun semula dashboard_widgets untuk reka bentuk Investment
-- Performance baharu (gantikan set widget lama dari reka bentuk dashboard
-- sebelum ini).
-- Jalankan di phpMyAdmin > tab SQL, pada database SPMS sedia ada anda.
-- =========================================================================

TRUNCATE TABLE dashboard_widgets;

INSERT INTO dashboard_widgets (widget_id, label, display_order, col_span) VALUES
('chart_status', 'Performance Status (Donut)', 1, 2),
('chart_profitability', 'Profitability: Actual vs Budget', 2, 2),
('chart_division', 'Revenue by Division', 3, 2),
('list_pat_variance', 'PAT Variance by Company', 4, 2),
('table_monitoring', 'Subsidiary Monitoring (Jadual)', 5, 4);