Modern admin dashboard

[dbltoe]

Partial blank page and the following:

File Contents( /home/enignet/_test/logs/myDEBUG-adm-20260114-181651-212929-error.log)[14-Jan-2026 18:16:51 UTC] Request URI: /******/, IP address: ###.###.###.###, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(757): trigger_error()
#2 /includes/classes/db/mysql/query_factory.php(701): queryFactory->show_error()
#3 /includes/classes/db/mysql/query_factory.php(280): queryFactory->set_error()
#4 /******/includes/modules/dashboard_widgets/RecentOrdersDashboardWidget.php(37): queryFactory->Execute()
#5 /******/index_dashboard.php(88): include('/home/enignet/_...')
#6 /******/index_dashboard.php(315): render_zone()
#7 /******/home.php(27): require('/home/enignet/_...')
#8 /******/index.php(16): require('/home/enignet/_...')
--> PHP Fatal error: FATAL MySQL error 1054: Unknown column 's.orders_status_color_code' in 'field list' :: SELECT o.orders_id, o.customers_name, o.customers_id, o.date_purchased,
o.currency, o.currency_value, o.orders_status,
ot.text as order_total, ot.value as order_value,
s.orders_status_name, s.orders_status_color_code
FROM orders o
LEFT JOIN orders_total ot ON (o.orders_id = ot.orders_id AND ot.class = 'ot_total')
LEFT JOIN orders_status s ON (o.orders_status = s.orders_status_id AND s.language_id = 1)
ORDER BY o.orders_id DESC LIMIT 10 ==> (as called by) /******/includes/modules/dashboard_widgets/RecentOrdersDashboardWidget.php on line 37 <== in /includes/classes/db/mysql/query_factory.php on line 757.

[balihr]

Partial blank page and the following:

Oh! In that case, the following is wrong:

I would suggest installing all 3 modifications (dashboard + header + status color) for the best experience, but all 3 are packed separately in hopes of getting better feedback.

Status color modification is REQUIRED, header is optional. Make sure you visit Localization->Orders Status so it runs the required alter table command.
Whoops

[balihr]

Actually, no, not required anymore, just updated index_dashboard.php and RecentOrdersDashboardWidget.php so you don't NEED to add it, but it's recommended.

[OldNGrey]

Now getting Undefined variable $product in \admin\includes\modules\dashboard_widgets\RecentOrdersDashboardWidget.php on line 193.

[balihr]

Lack of coffee and copy/paste... Sorry about that.
Updated the zip file - RecentOrdersDashboardWidget.php now updated (and back to foreach instead of while)

[OldNGrey]

I really like thi snew interface.
The only change I have needed to make is to declare $recentOrdersMaxRows as global in "admin/includes/modules/dashboard_widgets/RecentOrdersDashboardWidget.php" to alter the number of new orders displayed,
and the value set in "/admin/includes/extra_datafiles/site_specific_admin_overrides.php"

[balihr]

Plugin packed and submitted to the official Plugins section, pending approval.
https://www.zen-cart.com/downloads.php?do=file&id=2426

I've opted for the entire revamp, including header and order status color codes to be part of the plugin. Separate sets of files are included in the zip file, but the main one provides the best experience because it includes all three.

Feedback and suggestions for improvement still most welcome!

Github: https://github.com/zenexpert/modern-admin-dashboard/

Many thanks to OldNGrey, dbltoe, pilou2 and carlwhat for your help and advice.