Case Study

Case Management System

Comprehensive case management and tracking platform built for Unilever, featuring case data management, sample tracking, brand management, authority lookup, user administration, reporting, and bilingual support. The system includes a Laravel 10 backend with Vue.js 3 admin SPA, supporting multiple case types (Counterfeit, Regulatory Infringement Grey, Look A-Like, Range Extension), Excel exports, hierarchical sample categorization, case attachments, audit trails, and role-based access control.

La
Laravel
Technology
PH
PHP
Technology
Vu
Vue.js
Technology
MySQL
MySQL
Database
Vite
Vite
Tools
Ma
Maatwebsite Excel
Technology
Ax
Axios
Technology
Fl
Flatpickr
Technology
Tailwind CSS
Tailwind CSS
Frontend
Po
PostCSS
Technology
Au
Autoprefixer
Technology
QR
QRCode.js
Technology
js
js-cookie
Technology

Project Overview

Unilever Case Management System is a comprehensive enterprise case tracking and management platform built in 2025 for Unilever. The platform provides a complete solution for managing legal and compliance cases, tracking samples, managing brands and authorities, generating reports, and maintaining detailed case histories. Built on Laravel 10 with a Vue.js 3 single-page admin application, the system supports four main case types: Counterfeit (CFT), Regulatory Infringement Grey (RIG), Look A-Like (LL), and Range Extension (RE). The platform enables administrators to create and manage cases with detailed information including case numbers, prosecution numbers, compliant numbers, merchant details, locations, scouts, barcodes, and attachments. The system includes comprehensive sample management with hierarchical categorization through Brands, BGs (Business Groups), Categories, and CPG Descriptions. Key modules include Dashboard with case distribution analytics (by type, authority, and monthly trends), Case Data Management, Case Information with sample and attachment management, Advanced Search functionality, User Management, Reports & Analytics, Brand Management, Authority Lookup, and Translations (bilingual support for Arabic and English). The platform features extensive Excel export capabilities with customizable column selection, media file management, case report audit trails, barcode generation, print functionality, advanced filtering and search across all modules, and a centralized bilingual translation system for Arabic and English content.

Project Details

Client
Unilever
Industry
Legal & Compliance Case Management
Year
2025
Project Type
Enterprise Case Management & Tracking System
Project Gallery

Project Showcase

Explore the comprehensive interface and features of Case Management System

Dashboard

Dashboard

Admin dashboard providing overview of case distribution statistics, case distribution by type, case distribution by government authority, and case distribution for the last 4 months with interactive visualizations and clickable navigation to filtered case data

Case Data Management

Case Data Management

Comprehensive case data management interface with listing, filtering, search, print functionality, Excel export with customizable columns, case creation, editing, and deletion with password verification. Supports filtering by type, date range, authority, complaint number, case number, prosecution details, location, merchant, scout, and barcode

Advanced Case Search

Advanced Case Search

Advanced case search interface with comprehensive filtering options including keyword search, case type selection, date ranges, authority filtering, complaint numbers, case numbers, prosecution details, location, merchant, scout identifier, and barcode search with pagination and sorting capabilities

User Management

User Management

Complete user management system for creating, editing, and managing admin users with user type support, username, email, password management, last login tracking, user export to Excel, and comprehensive user administration

Add New User

Add New User

User creation and editing interface with form validation, user type selection, username, email, and password management for administrative user accounts

Brand Management

Brand Management

Brand management system for creating and managing brands with bilingual support (English and Arabic names), brand listing, editing, deletion, and Excel export functionality

Authority Lookup

Authority Lookup

Government authority management system for creating and managing authorities with bilingual support (English and Arabic names), authority listing, editing, deletion, and Excel export functionality. Authorities are associated with cases for tracking and reporting

Case Reports & Analytics

Case Reports & Analytics

Comprehensive case reports and analytics system tracking all case actions (Add, Edit, Delete) with user information, timestamps, case names, filtering by user type, year/month, brand, keyword search, pagination, sorting, and Excel export capabilities for audit trail management

Key Features

Powerful Features

Innovative solutions designed to deliver exceptional user experience and business value

Multi-Type Case Management

Comprehensive case management supporting four case types: Counterfeit (CFT), Regulatory Infringement Grey (RIG), Look A-Like (LL), and Range Extension (RE). Each case includes detailed information such as case number, prosecution number, compliant number, merchant, location, scout identifier, barcode, country, town, description, response, and prosecution details

Core Feature

Sample Management System

Complete sample management system with hierarchical categorization through Brands, BGs (Business Groups), Categories, and CPG Descriptions. Samples include case type, name, description, size, and quantity. Supports multiple samples per case with full CRUD operations

Core Feature

User Management

Multi-type user system supporting different user types with profile management, username, email, password management, last login tracking, user export to Excel, and comprehensive user administration with role-based access

Core Feature

Brand Management

Brand management system with bilingual support (English and Arabic names), brand listing, creation, editing, deletion, and Excel export functionality. Brands are used in the hierarchical sample categorization system

Core Feature

Authority Lookup

Government authority management system with bilingual support (English and Arabic names), authority listing, creation, editing, deletion, and Excel export functionality. Authorities are associated with cases for tracking and reporting purposes

Core Feature

Case Reports & Audit Trail

Comprehensive case report system tracking all case actions (Add, Edit, Delete) with user information, timestamps, case names, filtering by user type, year/month, brand, keyword search, pagination, sorting, and Excel export capabilities for complete audit trail management

Core Feature

Advanced Search & Filtering

Comprehensive search and filtering across all modules with keyword search, case type filters, date ranges, authority filters, complaint numbers, case numbers, prosecution details, location, merchant, scout identifier, barcode search, and pagination support with customizable ordering

Core Feature

Excel Export System

Extensive Excel export capabilities with customizable column selection for case data, user exports, brand exports, authority exports, case report exports, BG exports, category exports, and CPG description exports with Maatwebsite Excel integration

Core Feature

Dashboard Analytics

Comprehensive dashboard with case distribution analytics including case distribution by type with clickable navigation, case distribution by government authority with interactive charts, and case distribution for the last 4 months with percentage calculations and visual representations

Core Feature

Case Attachments Management

Case attachment system with file upload, storage, deletion, and association with cases. Supports multiple attachments per case with title, type, file path, uploader tracking, and sortable ordering for organized document management

Core Feature

Bilingual Translation System

Centralized translation management for Arabic and English with search functionality, real-time translation updates, and automatic JSON file generation for frontend consumption ensuring seamless bilingual user experience across the platform

Core Feature

Barcode Generation

Automatic barcode generation for cases with unique case ID assignment. Each case receives a unique 6-digit case ID that is automatically generated and can be used for barcode scanning and case identification

Core Feature

Print Functionality

Print functionality for case data with formatted output, allowing users to generate physical copies of case information for record-keeping and documentation purposes

Core Feature

Hierarchical Sample Categorization

Four-level hierarchical categorization system for samples: Brand → BG (Business Group) → Category → CPG Description. This structure enables detailed product classification and organization for compliance and tracking purposes

Core Feature

Role-Based Access Control

Secure admin authentication system with session-based authentication, middleware protection, password verification for sensitive operations (like case deletion), and comprehensive permission management ensuring data security

Core Feature

Excel Import Functionality

Excel import capability for bulk data upload, allowing administrators to import large datasets efficiently through Excel file uploads with data validation and error handling

Core Feature

Media File Management

Centralized media file handling with upload, storage, deletion, and association with cases and attachments. Supports various file types with proper file management and organization

Core Feature

Case Information Management

Detailed case information management with comprehensive case details, sample management within cases, attachment management, case editing, and full case lifecycle management with audit trail tracking

Core Feature
Let's Get Started

Ready to Create Your Next Success Story?

Let's discuss your project requirements and create a custom solution that drives your business forward.