Simple PHP (PWA)
Budget: $30 – $250 USD
I need to make a progressive web app using PHP & MySQL
The PWA front end will start with a login page as below
1- Screen 1 (Login Page)
2- When you log in it will check your credentials in the login table
3- Screen 2 You will be having a barcode reader
4- Screen 3 when u scan the bar code it will retrieve the employee details from the employee table using (EID) with confirm button
5- Screen 4 When you confirm you will retrieve the available services from the services table where the Service provider ID matches the login ID & the privilege ID matches the privilege id of the confirmed employee details.
6- Screen 4 Retrieve the Available Services Name, & Discount percentage in radio buttons &confirm
7- Screen 5 Text field where you can add (invoice total amount) and it calculates (Total amount, discount amount, & amount to be paid after discount) & confirms button
8- Screen 8 Thank you screen & you will insert to the Service_log table ( all the below mentioned fields in the Mysql structure)
MySQL Tables Structre
1-Login_table
1-1)LID
1-2)username
1-3)Password (md5)
2-Employees_table
2-1)EID (Long int 10 digits)
2-2)Employee_name (UTF8 Supports Arabic)
2-3)Employee_Position (UTF8 Supports Arabic)
2-4)Employee_picture
2-5)Previllage_ID
3-Previllage_table
3-1)Previllage_ID
3-2)Previllage_name
4-Service_Providers
4-1)SP_ID
4-2)SP_Name
4-3)LID
5)Services_Table
5-1)Sr_ID
5-2)Service_Name
5-3)Service_Type
5-4)Discount_Percentage
5-5)SP_ID
5-6)Previllage_ID
6)Serrvice_Log
6-1)SL_ID
6-2)SP_ID
6-3)Sr_ID
6-4)EID (Long int 10 digits)
6-5)Invoice_amount
6-6)Discount_amount
6-7)Paid_amount
The PWA front end will start with a login page as below
1- Screen 1 (Login Page)
2- When you log in it will check your credentials in the login table
3- Screen 2 You will be having a barcode reader
4- Screen 3 when u scan the bar code it will retrieve the employee details from the employee table using (EID) with confirm button
5- Screen 4 When you confirm you will retrieve the available services from the services table where the Service provider ID matches the login ID & the privilege ID matches the privilege id of the confirmed employee details.
6- Screen 4 Retrieve the Available Services Name, & Discount percentage in radio buttons &confirm
7- Screen 5 Text field where you can add (invoice total amount) and it calculates (Total amount, discount amount, & amount to be paid after discount) & confirms button
8- Screen 8 Thank you screen & you will insert to the Service_log table ( all the below mentioned fields in the Mysql structure)
MySQL Tables Structre
1-Login_table
1-1)LID
1-2)username
1-3)Password (md5)
2-Employees_table
2-1)EID (Long int 10 digits)
2-2)Employee_name (UTF8 Supports Arabic)
2-3)Employee_Position (UTF8 Supports Arabic)
2-4)Employee_picture
2-5)Previllage_ID
3-Previllage_table
3-1)Previllage_ID
3-2)Previllage_name
4-Service_Providers
4-1)SP_ID
4-2)SP_Name
4-3)LID
5)Services_Table
5-1)Sr_ID
5-2)Service_Name
5-3)Service_Type
5-4)Discount_Percentage
5-5)SP_ID
5-6)Previllage_ID
6)Serrvice_Log
6-1)SL_ID
6-2)SP_ID
6-3)Sr_ID
6-4)EID (Long int 10 digits)
6-5)Invoice_amount
6-6)Discount_amount
6-7)Paid_amount