512659 Equipment-Calibration System 3

IT MUST BE DONE IN: Programming Language - PHP/MSSQL on IIS Project Overview – Equipment-Calibration System (ECS) The ECS is a system that manages the calibration and maintenance records of equipments in the company. Workflow Super administrator (SA) creates customers, projects and Person-in-charge (PIC). SA then assigns customer to project and PICs to projects. PIC then creates the relevant equipments to track in ECS. For every equipment, there is a calibration date where the PIC will then calibrate the equipment. On each calibration, the PIC will file a calibration report via ECS. For every equipment, there is also a preventive measure (PM) date where the PIC will conduct preventive measure actions to the equipment. On each PM, the PIC will file a PM report via ECS. Whenever an equipment breaks down, the PIC will file a breakdown report via ECS. During calibration, PM or break down, PIC may use spare parts to fix the equipment. The spare part module tracks the issue/receive orders of each spare part and is managed by the PIC. User Access Groups There will 2 user groups, namely Super Administrator and Person In-Charge (PIC). The role of Super Administrator is as followed: 1)Create/Delete other super administrators 2)Create/Edit/Delete PIC 3)Create/Edit/Delete Customers 4)Create/Edit/Delete Projects 5)Assign PIC to Projects 6)Assign Projects to Customers 7)Able to view master report of equipment list The role of PIC is as followed: 1)Create/Edit/Delete equipment information 2)Create/Edit/Delete calibration information 3)Create/Edit/Delete preventive measurements information 4)Create/Edit/Delete breakdown information 5)Create/Edit/Delete sites and workstations 6)Create/Edit/Delete manufacturers 7)Create/Edit/Delete breakdown categories 8)Create/Edit/Delete spare parts 9)Create spare parts issue and receive orders 10)Setup reminders 11)View reports based on their projects For more information, Please download attachments.