A user or admin facing problem managing data on excel sheet. He/She need a system to perform at least following operations
Show Listing and Search Data to get specific Information.
User need a system which should be accessible from internet so that he can work from any machine (laptop/desktop/mobile).
You need to develop a web application with best of your knowledge
With correct credentials admin should be able to login and see the dashboard.
if credentials are wrong he will stay on login page and show a message – wrong credentials.
On successful login admin can see users list perform all CRUDL operations.
NOTE: you need to use vim editor to edit files
Following are the wireframes for reference.
Technologies to be used
composer for package management and autoload
ini for configuration
git and gitlab for version control
HTML5 CSS3 Bootstrap 5 for UI/UX
php 7.4 or 8 as backend programming language
mysql 8 database
PDO for database operations
PHPUnit for unit testing
python and php for automation script (Use cron jobs to automatically run script)
nginx web server
use infinityfree / webserver / cloudserver for website hosting
Jenkins and git-ftp for CI/CD
MVP / Deliverable
Delete User Record
Add User Record with Profile Picture (User status should be enum in database table: enable, disable, blocked, active, inactive)
Update User Record
Session Management Login / Logout
View User Details in Modal Window
Frontend – Backend Validation
Export CSV Users
Bulk Upload CSV
Export Activity Log
Login with OTP i.e. 2FA (Use Redis to store OTP)
Login Logout for user account
Inactive User status if not logged in for 3 consecutive days
Change Admin and User Password from their respective account
Secret Questions and Forgot Password / Recover Password using secret questions or through the email link
REST API (Web Services) for User CRUDL Operations
Protect REST API using Basic Authentication or JWT token
Login with google API or Facebook API
PHPUnit test for all functionalities
Licensing or limit user registration
Dashboard showing following summary (Use highcharts)
License Count / Usage Count
Weekly Registration Stats
Ref SQL Queries
SELECT * FROM users ORDER BY id DESC;
SELECT * FROM users WHERE id = 3;
DELETE FROM users WHERE id = 3;
INSERT INTO users (id, name, age, city, added_at, updated_at) VALUES (NULL, 'sonam gupta', 18, 'gorakhpur', NOW(), NOW());
UPDATE users SET name = 'Sonam Gupta', age = 20, city = 'Gorakhpur', updated_at = NOW() WHERE id = 5;
Creating a personal mini car inventory system from scratch using your best knowledge and skills. The system will have inventory of manufacturer and models (cars) of each manufacturer owned.
System should be created using your own frontend and backend framework and should use caching.
Frontend should be a webapp a.k.a. SPA. (Ie: no refreshing/reloading pages)
Technology to be used:
Classes to be created:
Database – Class to deal with each and every operation of database. Manufacturer – Class to deal with all operations related to car manufacturer. Model – Class to deal with all operations related to car model.
Page 1: Add Manufacturer. The page should contain a input box for manufacturer name and a submit button.
Page 2: Add Model. This page should have a manufacturer dropdown on the right side and model name textbox on the left side (Both should be in the same line)
Add other details below about the car like “Color, manufacturing year, registration number, note and 2 pictures”. Pictures should be uploaded using any ajax plugin.
And lastly there should be a submit button.
Page 3: View Inventory. This page should populate a table of all the models and manufacturers from the DB.
It should have the columns as below
Serial Number, Manufacturer Name, Model Name, Count
Maruti WagonR 2
Tata Nano 1
On clicking on the row, a popup will appear which will have details of the individual models like color, manufacturing year etc. (Basically all details from page 2) and a Sold clickable link.
On clicking Sold, the row will be deleted and the DB will be updated accordingly.
In addition to this, on Page 3 when users are viewing the inventory and in case a car is sold, the View Inventory table for the column Count will have to be dynamically updated in case a car is sold at that moment.
Similarly in case the users are on any other page or pop up of the system, they should get an alert saying “make model is sold” when a car is sold.