Internal-Claim System

An automated web application for tracking, escalating, and resolving internal production issues across multiple departments.

Internal Claim System Dashboard

Project Overview

The Internal Claim Web Application is a comprehensive system designed to digitize and automate the workflow for handling internal production issues at PT. Astra Visteon Indonesia. The primary goal of this project is to enhance response speed, ensure departmental accountability, and provide a centralized data repository for analysis and reporting. By automating this process, the system is targeted to improve overall efficiency by up to 40%.

Key Features

This system was engineered with a multi-layered workflow and role-based access to manage a complex issue-resolution process:

  • Dynamic Dashboard: Features a statistical dashboard with interactive charts summarizing pending tasks, problem statuses (Open vs. Close), and issue frequency per product model.
  • Multi-Level Role Access: Implements five distinct user roles (Production, Quality, Engineering, R&D, and Admin), each with specific permissions and dedicated input pages to ensure a structured and secure workflow.
  • Automated Escalation Workflow: A sophisticated, multi-phase workflow that starts with an issue report from Production and escalates sequentially through Quality, Engineering, and finally R&D for complex cases.
  • Integrated Email Notifications: The system automatically sends email notifications (to both primary recipients and CCs) at each critical step of the workflow, keeping all relevant departments informed.
  • Draft & Final Submission: Users in analysis roles (Quality, Engineering, R&D) can save their findings as a draft before final submission, allowing for careful review and preventing premature conclusions.
  • Centralized Reporting & Data Management: All findings, analyses, attachments, and final actions are stored in a centralized database, with features to view detailed reports and export data to Excel.
  • Admin Control Panel: A dedicated interface for Admins to manage users, roles, and master data like Serial Number references without direct database access.

Technical Stack & Architecture

The application is built on the Laravel framework, leveraging a structured MVC (Model-View-Controller) architecture and a relational database.

  • Backend Framework: Laravel (PHP), as evidenced by the file structure (`app/Http/Controllers`, `resources/views`, `routes/web.php`) and native Laravel tables (`migrations`, `sessions`, `jobs`).
  • Database: SQL Server.
  • Core Models: The data structure is managed through Eloquent models.
  • Role & Permission Management: The system utilizes a robust role-based access control (RBAC) structure, managed through `roles` and `model_has_roles` tables, likely implemented with a package like Spatie/laravel-permission.
  • Asynchronous Filtering: The main dashboard table is refreshed via AJAX requests to provide a seamless user experience when filtering data.