Changelog

All notable changes to the SGI Punch Quotation System are documented here.

[Version 2.0.0] - 2025-11-12

Major Features Added

  • 🎨 Complete UI Redesign - Modern, clean interface with corporate styling
  • 📊 Enhanced Dashboard - Statistics cards with format breakdown badges
  • 🔍 Improved Item Check - Visual indicators and gradient headers
  • 📈 Better Reports - Summary report with DataTables integration
  • 🎯 Smart Filtering - Automatic exclusion of notes and dates from item checks

UI/UX Improvements

  • Redesigned login page with minimal, professional styling
  • Corporate color scheme throughout (Navy #1e3a5f, Blue #2563eb, Green #166534)
  • Format-specific badges with icons (TMMIN 🚗, METINDO 🚚, MARUICHI 💰)
  • Improved table navigation with search, pagination, and sorting
  • Responsive design for tablet and mobile access

Bug Fixes

  • Fixed METINDO date extraction (Jakarta comma spacing issue)
  • Resolved JavaScript syntax errors in session detail page
  • Fixed duplicate variable declarations in table rendering
  • Corrected PDF template title alignment
  • Fixed DataTables initialization conflicts

Technical Improvements

  • Added comprehensive logging system (django.log, extraction.log)
  • Implemented regex-based filtering for non-item entries
  • Enhanced SAP HANA connection handling with detailed logging
  • Background server execution with start/stop scripts
  • Database cleanup management command

Data Filtering

Automatically excludes from item checks:

  • Delivery notes: "11 HARI KERJA", "15 working days"
  • Dates: "2025-10-23", "23-10-2025"
  • Text notes: "CATATAN", "NOTE", "ESTIMASI PENGIRIMAN"
  • Totals: "TOTAL", "SUBTOTAL", "TAX", "PAJAK"
  • Company names: "PT. PUNCH", "PT. SOMAGEDE"

New Management Commands

  • clean_db - Clean up all database records
  • configure_email - Configure email settings
  • configure_teams - Configure Teams webhook
  • setup_users - Create demo user accounts

Scripts Added

  • start_server.sh - Start Django server in background
  • stop_server.sh - Stop background Django server
  • view_logs.sh - View application logs

[Version 1.5.0] - 2025-01-15

Features Added

  • MARUICHI format support with discount pricing
  • METINDO format with ETD column
  • Bulk PDF generation
  • Teams notification integration

Improvements

  • Better error handling during upload
  • Improved SAP HANA query performance
  • Enhanced PDF template formatting

Bug Fixes

  • Fixed PII/SGI sheet detection
  • Resolved header row detection issues
  • Corrected total calculation for MARUICHI format

[Version 1.0.0] - 2024-10-01

Initial Release

  • Excel file upload and processing
  • Standard PII/SGI format support
  • TMMIN format support
  • SAP HANA integration for item checking
  • PDF generation
  • User authentication and authorization
  • Dashboard with session management
  • Basic reporting features

Supported Formats

  • Standard (PII + SGI) - 12 columns
  • TMMIN (Toyota) - 8 columns

Core Features

  • Multi-sheet Excel processing
  • Automatic format detection
  • QTI number extraction
  • Customer and salesman identification
  • Item availability checking
  • PDF quotation generation
  • Session-based upload tracking

[Version 0.9.0] - 2024-08-15

Beta Release

  • Initial testing version
  • Basic upload functionality
  • Simple PDF generation
  • Limited format support

Known Issues

  • Performance issues with large files
  • Limited error handling
  • Basic UI

Upgrade Notes

Upgrading to 2.0.0

  1. Backup Database:

    python manage.py dumpdata > backup_pre_2.0.json
cp db.sqlite3 db.sqlite3.backup

  2. Pull Latest Code:

    git pull origin main

  3. Update Dependencies:

    pip install -r requirements.txt

  4. Run Migrations:

    python manage.py migrate

  5. Update System Settings:

    python manage.py init_settings

  6. Restart Server:

    ./stop_server.sh
./start_server.sh

Breaking Changes in 2.0.0

  • None - Fully backward compatible
  • Old sessions will continue to work
  • No database schema changes required

Deprecated Features

  • None in this release

Roadmap

Planned for Version 2.1.0

  • [ ] Email notification support
  • [ ] Export to multiple PDF formats
  • [ ] Advanced search and filtering in dashboard
  • [ ] Batch file upload
  • [ ] Custom report generation
  • [ ] API endpoints for integration

Future Considerations

  • Mobile app for uploads
  • Real-time collaboration features
  • Advanced analytics dashboard
  • Integration with other ERP systems
  • Automated email distribution of quotations
  • Digital signature support

Support

For version-specific support:

  • Current Version: 2.0.0
  • Minimum Supported: 1.0.0
  • End of Life: 0.9.0 (no longer supported)

Contributors

  • PT Somagede Indonesia IT Team
  • Development Team
  • Sales Department (Format specifications)
  • Testing Team

License

© 2025 PT Somagede Indonesia. All rights reserved. Proprietary software for internal use only.

Note: This is an internal system. Version numbers and features are subject to change based on business requirements.

results matching ""

    No results matching ""