make a web app with php(HTML,CSS,JS Integrated),MySQL 'Fortuna Testing'. It should work on desktop and mobile but should be mobile first. Layout,design should be professional and elegant.
Admin Panel: Menu Button on left top corner, Fortuna Testing Heading in Top Middle
Dashboard Section:
Kpis- Month's testing
Today's testing
Today's Rejection
Yesterday's testing
Yesterday's Rejection
Master lists Section:
1.Ratings: buttons- add
List with filters: frame
Items clickable and redirect to view page with edit and delete buttons
Add Button:
Form with fields:
Frame, Core Length
2.Star Number: buttons- add
List with filters: frame
Items clickable and redirect to view page with edit and delete buttons
Add Button:
Form with fields:
Frame(Drop down),Core Length(Dropdown), KVA, Phase
3. Resistance: buttons- add, Import
List with filters: frame, Star Number
Items clickable and redirect to view page with edit and delete buttons
Add Button:
Form with fields:
Star Number(Dropdown),Dropdown(Stator/Rotor/Exciter Stator), Temperature, Minimum, Maximum
Import Button:
Sample file Download button, import box with import button
Sample file having fields same as add form with star number dropdown, stator/rotor/ exciter stator dropdown, temperature,minimum, maximum
4.Operator: Buttons- Add
Items clickable and redirect to view page with edit and delete buttons
Add Button:
Form with fields:
Operator name, checkbox (Pre-ZPF Testing), Checkbox (ZPF Testing)
Reports Section: Buttons:Export
List with Filters Date,Star Number 5 items per page
Export:
Download Filtered Report in excel
User Panel:Menu Button on left top corner, Fortuna Testing Heading in Top Middle
Dashboard Section:
Kpis- Month's testing
Today's testing
Today's Rejection
Yesterday's testing
Yesterday's Rejection
Pre-ZPF Testing Section: Buttons-Add
List with filters: Date,Star Number
Items clickable and redirect to view page with edit and delete buttons
Add Button:
Form With fields:
Serial Number Automatically (E.g ZDZE1 where Z is 2026 year,D is April month, Z is for Zen, E for Electric Company,1 for Serial Number),Star Number Scanner button: scans star number barcode,AVR Number Scanner button: Scans AVR number barcode, Temperature,Main Stator IR- Checkbox(100+ mohm),Main Rotor IR- Checkbox(100+ mohm),Exciter Stator IR- Checkbox(500+ mohm),Main Stator Resistance 1 Phase,Main Stator Resistance 2 Phase,Main Stator Resistance 3 Phase,Main Rotor Resistance,Exciter Stator Resistance,HV Test Leakage Current,Checkbox (Tested OK), Checkbox (Not OK)
Note-If Resistance values are violating the band of minimum and maximum with respect to temperature in the master list then show red warning and don't save the data.
ZPF Testing Section: Buttons- Add
List with filters: Date,Star Number
Items clickable and redirect to view page with edit and delete buttons
Add Button:
Shows Pre- ZPF (Tested OK) Machine List with clickable items, when clicking on any items shows form with fields:
Machine number Scanner button:scans Machine number barcode,MO number Scanner button:scans MO number barcode,Before Charging Residual Voltage, After Charging Residual Voltage,Checkbox (Phase Sequence),No Load Voltage, No Load Current, Full Load Voltage, Full Load Current,Checkbox (Tested OK), Checkbox (Not OK)