Release Distribution Feed

Bug Fixes
1. Fixed invoice balance not clearing to zero after full payment in digital payment system.
2. Resolved partner revenue sharing calculation errors in bKash webhook and MFS IPN.
3. Fixed partial payment processing for overdue invoices across all payment gateways.
4. Corrected excess payment and advance balance handling in automatic payment systems.
5. Fixed date format issues causing payment record errors in bKash and MFS transactions.
6. Resolved payment status synchronization between mobile transactions and invoice records.

Improvements
1. Added comprehensive logging system for bKash webhook and MFS IPN payment monitoring.
2. Unified payment processing logic across manual assignment, bKash webhook, and MFS IPN.
3. Enhanced invoice payment tracking with detailed transaction records for each payment.
4. Improved automatic excess balance application when processing new renewals.
5. Strengthened payment validation and error handling in all digital payment methods.
6. Standardized payment descriptions and transaction references across bKash and MFS systems.

Bug Fixes & Enhancements
1. Fixed backup system functionality in admin and scripts.
2. Resolved location name display issues across multiple modules.
3. Fixed complaint category and status display bugs.
4. Corrected payment gateway integration issues (Nagad, bKash, SSL).
5. Fixed user data fetch and parental control update functions.
6. Fixed payment assignment processing for digital payments.
7. Resolved datatable state save issues.
8. Fixed system menu script functionality and navigation.

New Features & Improvements
1. Added Voice API integration system with settings management.
2. Introduced automated expired user voice call reminder script.
3. Added Email logging and monitoring system.
4. Implemented Voice call logging and history tracking.
5. Added bulk email and SMS sending functionality.
6. Introduced FTP backup settings configuration.
7. Enhanced partner management with voice API configuration.
8. Improved payment gateway callback handling and webhook processing.
9. Added MAC vendor identification (OUI lookup) for devices.

Bug Fixes

1. Fixed online status showing users as "online" even after proper disconnect/logout.
2. Fixed stale sessions remaining open forever when accounting updates stop for 4+ minutes.
3. Fixed router/NAS reboot leaving all user sessions incorrectly open in database.
4. Fixed some users having wrong speed (1k/1k) instead of actual profile speed.
5. Fixed slow query performance due to 6+ million old accounting records in main table.

New Features

1. Added automatic online status synchronization using real-time database triggers.
2. Added automatic stale session cleanup running every 3 minutes to close inactive sessions.
3. Added NAS reboot detection handler to instantly close all sessions when router restarts.
4. Added automatic profile speed synchronization from srzone_profiles to radgroupreply.
5. Added automatic archival system moving records older than 6 months to archive table daily at 3:00 AM.
6. Added authentication failure tracking system for monitoring potential security attacks.
7. Added automatic cleanup of old auth failure records (keeps only last 24 hours).
8. Added system health monitoring view showing real-time statistics (online users, stale sessions, archive status).
9. Added MySQL Event Scheduler configuration for fully automated maintenance tasks.
10. Added FreeRADIUS log rotation (30 days retention) to prevent log files from filling disk.

Performance Improvements

1. 40% disk space reduction after archiving old records to separate table.
2. 30-50% faster query performance on main radacct table after cleanup.
3. 100% accuracy in online status reporting (real-time sync).
4. Zero manual intervention required - all maintenance runs automatically.

What Runs Automatically After This Update

• Online status sync: Real-time (instant)
• Stale session cleanup: Every 3 minutes
• NAS reboot handler: Instant when router sends accounting packet
• Daily archive: Every night at 3:00 AM
• Auth failure cleanup: Every hour
• Log rotation: Daily

Bug Fixes
1. Fixed invoice amount calculation showing incorrect totals when old due exists (was showing 2100 instead of 1050).
2. Fixed partner balance being deducted twice for old due amounts during renewal.
3. Fixed system allowing renewals when partner balance is negative in sharing system.
4. Fixed invoice number generation creating duplicates when multiple partners share same prefix.

New Features
1. Added negative amount support in Add Money feature to deduct from user's excess payment.
2. Added smart partner balance clearance with detailed breakdown in transaction comments.
3. Added "Old Expiry Date" and "Renewal Date" columns to user listing for better renewal tracking.
5. Added prefix synchronization utility for one-click invoice sequence sync across all partners.
6. Added thread-safe invoice generation with prefix-based locking to prevent duplicates.
7. Added validation to prevent negative balance renewals in partner sharing system.

Technical Improvements
1. Improved invoice calculation logic to match user portal payment flow.
2. Enhanced partner revenue sharing to prevent duplicate deductions.
3. Optimized invoice number generation with cross-partner prefix collision prevention.
4. Added comprehensive backup and reporting in rollback utility scripts.

Bug Fixes
1. Fixed Nagad payment gateway API endpoint configuration.
2. Fixed currency symbol JavaScript scope errors on all payment pages.
3. Fixed payment method not displaying in finance reports.
4. Fixed auto-renewal not preserving payment method information.
5. Fixed SSL Commerz payment failures when "Payment For Month" field disabled.
6. Fixed payment button double-click causing duplicate submissions.
7. Fixed bKash webhook transactionReference undefined errors.

New Features
1. Added automatic account renewal using excess balance (no gateway needed).
2. Added real-time payment calculation display (Total, Excess Used, Amount to Pay).
3. Added partial payment support using excess balance with gateway.
4. Added button processing animation with spinning icon.
5. Added comprehensive error recovery on all payment gateways.
6. Added notification system showing excess balance usage.
7. Added double-click prevention on payment buttons.

Bug Fixes
1. Fixed checkbox selection in online users table.
2. Restricted license alerts to Super Admin only.
3. Fixed excess payment creation failures.
4. Resolved 0 amount payment entries issue.
5. Fixed excess balance not adding correctly.
6. Corrected payment method display.
7. Fixed payment gateway error handling (bKash, Nagad, PortPos, SSL).
8. Fixed QuickPay CSRF token conflicts.

New Features
1. Added excess balance auto-renewal (no gateway needed when balance sufficient).
2. Real-time payment calculation display (Total, Excess, Amount to Pay).
3. Unpaid invoice payment with excess balance support.
4. Server-side validation with CSRF protection.
5. Status-based excess tracking (unused/used).
6. Transaction-based processing with auto-rollback.
7. PayBill Added Admin Settings chose option.

Bug Fixes & Enhancements
1. Resolved critical issues in the user login and payment systems.
2. Fixed issues with the expired SMS notification system.
3. Complaint section notes now display fully using popovers.

New Features & Improvements
1. Added a user login log system, accessible from the admin panel’s logs section.

Bug Fixes & Enhancements
1. Improved Online User visibility — partner, admin, and branch roles can now access and view user data.
2. Resolved several minor bandwidth-related issues to enhance performance and stability.
3. Fixed multiple bugs in the PGW partner share module for improved accuracy and reliability.

Bug Fixes & Enhancements
1. Fixed multiple partner access issues related to user view permissions.

New Features & Improvements
1. Added a permission management system for the dashboard.

Bug Fixes & Enhancements
1. Corrected display of user renewal package names.
2. Fixed several issues related to location name display.
3. Resolved bugs in the backup system for improved stability.
4. Fixed issues encountered during OLT ONU import.

New Features & Improvements
1. Added permissions to allow partners or branches to view user details.
2. Introduced a comprehensive Finance Report with access permissions.
3. Added a Complaint Report module with configurable permissions.