Bug Fixes (in R_2_47, not in Prod)6
NoteEmergency Stop Fix — dispense.php
NoteThe emergency stop unblock was using the wrong ID (f_wo_id instead of f_workorder_id) to clear the stop flag. Now correctly looks up the matching f_adjustwo_id via t_workorder_details before updating t_adjust_workorder.
NoteReel Not Found Redirect — dispense.php
NoteWhen reel_id is 0, instead of showing a dead-end error message, users are now redirected to the reel selection page with the correct workorder IDs. Applies to multi-dispense (MD) workflow. Developer note: "May not be 100% correct so further testing is required."
NotePreset Amount Aggregation Fix — admin_model.php:511
NoteSUM(wd.f_configured_preset_amount) changed to MAX(wd.f_configured_preset_amount) in Wo_maint_prprd(). The JOIN to t_dispense duplicated preset rows, so SUM inflated the preset value. MAX returns the correct single value. This is the root cause fix that made the "WO ALL TECH fix" controller workaround unnecessary.
Enhancements (in R_2_47, not in Prod)4
NoteDB Version Updater Rewrite — maintenance.php & version.php
NoteAdded SQL trigger support (multi-line CREATE TRIGGER...END; statements no longer break)
NoteAdded file-based logging to update_db_version.log for every SQL line read, executed, and errors
NoteAdded auto-initialization of t_autoexport_settings and job recipe top-off fields
Nothing matches these filters.