Build a custom php website (can be wordpress or other php frame work)

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

Please see attached file for full report*

<SUMMARY>

Battery Management and Data Display Website

Possible PHP Framework: Wordpress, Yii 2, Joomla, Zend Framework

Battery management database management and user level management

Requirements

Overall:

1. Users (owner or worker) can sign up

2. Admin can assign user (admin, owner or worker)to each database set: batteries and solar panel (future development)

3. Data is extracted from external database (from Amazon AWS)

o Each database has different table and column name

Image 1: Databases & their respective column names

4. Database will be referred as battery.

5. Show battery data in table and graphs

6. Capability to view latest data (SQL query must be able to see latest data)

7. Capability to show historical data (filter and process data based on battery date and time)

8. Each battery can be viewed by multiple users

9. Each user can view his own battery data

10. User level:

o Admin - can assign each user to specific battery or multiple batteries (1 or more batteries)

o Owner - can assign worker for each battery, can check all batteries status (1 or more batteries)

o Worker - can check batteries status only (1 or more batteries)

11. Require tidy codes with comments for future reference and development

12. Website to be made ready for future development

- Code to make ready for connection to MongolDB (non-sql database)

Capabilities

Admin:

1. Access to admin dashboard

2. Can create new users

3. Can set user roles (admin, owner or worker)

4. Can assign user(s) to battery (1 or more batteries)

5. Can view current status of all batteries and historical data

6. Battery data to be displayed in tables and graphs

7. Owner can set new connection to new database(s) (such as solar panel)

Owner:

1. Can sign up in website

2. To be assigned to batteries by admin

3. Can view one or multiple batteries in frontend/backend

4. Can assign worker to own batteries (1 or more batteries) in frontend/backend

5. Display battery data in tables and graphs

Worker

1. Can sign up in website

2. To be assigned to batteries by admin or owner

3. Can view one or multiple batteries in frontend/backend

4. Display battery data in tables and graphs

Backend Development

1. Ready for addition of new databases, which will have different column name

2. Ready for MongolDB connection

Technical Requirement:

1. User access level and management

2. Connection to external database

3. Possible approach to fetching database data

- periodic update (via cron job or other methods) to save in own database

- Only request data on request (when user select batteries data display)

4. Display data in tables and graphs (data over a period of time will be fetched and display in graphs)

5. Data can be filtered according to date and time

Updated Project Requirement (Update 18 August 2016)

Please refer to this update and ignore the previous description.
Please refer to attached document for Illustration and images.

Battery Management and Data Display Website

Table of Content
1. Project scope
2. Possible Technologies to be used
3. Major modules of the proposed system identified are
4. Technical Requirement
5. User Management
6. Battery Management
7. Charts and Tables Module
8. Admin Dashboard
9. Owner Dashboard
10. Worker Dashboard
11. Backend Development
12. Database Table
13. Other Information
14. Estimated Timeline
15. Note on solar panel (new table)
16. Project Milestone
17. Payment Milestone

Battery management database management and user level management
1. Project scope
To develop a system which manages Batteries, displays their data retrieved from battery database from AWS.
To allow new users to sign up.
To assign users to the batteries to manage the batteries and data.
System to handle different levels of users with their specific roles and privileges.

2. Possible Technologies to be used
The system can be developed in plain PHP or a popular PHP framework such as Wordpress, CodeIgniter, Laravel, Yii etc.,
HTML, CSS, AngularJS, JQuery.

3. Major modules of the proposed system identified are
User access level, user privileges module.
AWS / External database Import module
Charts and Tables Display module.
Battery management module.

4. Technical Requirement
Demonstration of Prototype (Refer to Section 16 Project MIlestone)
User access level and management
Connection to external database (Amazon AWS EC2)
Approach to fetching database data
When user requests (user select batteries data display and filters), send MySQL command to database to fetch data
Battery info will be fetched via updated table (explained in section 12)
“num_id” is the unique key for each battery
“sysname” is the battery name
“systype” is the battery type
“description” is the description for each battery
Battery info (battery name) from this table to be shown to user for easy reference.
Unique key for each tables are “num_id”
Using unique key to retrieve battery information for each table.
MySQL have to be always checking for “num_id” and display the correct “sysname”.
Temporary store data in cookie or session for filtering purpose.
Display data in tables
Display data in graphs (data over a period of time will be fetched and displayed in graphs)
View latest data & historical data
Data can be filtered according to:
battery id “num_id”
battery name “sys_name”
time “last_updated”
Duplicate data (with same “num_id” and “last_updated” needs to be checked and sorted accordingly
Updating Amazon database is NOT part of requirement.
Front-end dashboard for admin, owner and worker to view battery data (in tables and graphs)
Require tidy codes with comments for future reference and development

Note:
Future development includes connection to MongolDB, a NoSQL database
(Not be developed now. Only to be developed once the MongolDB database is ready)

The features and functionality of the system can be described as follows:
5. User Management
Users of the system are: Admin, Owner, Worker.
Admin: Sells batteries to User.
Admin can create new Users in his Dashboard.
He can set user roles (admin, owner, worker).
Assigns User/Users to Batteries.
User Access Level illustration:
Each battery can be viewed by multiple users.
Each user can view his own battery data.

Image 1: Illustration of Battery Management

6. Battery Management
Admin can add new batteries.
All batteries will be in the same table
Can connect to new type of batteries (e.g. solar panel, etc).
All battery data will be stored temporarily in cookie or session for filtering (Storing battery data in local database is not required).

7. Charts and Tables Module
To display various charts/graphs with data over a period of time.
Battery data to be displayed in tables.
Data to be filtered based on Date and Time range.

8. Admin Dashboard
Manages Users ( create new user, set user roles, assign user/users to batteries)
Displays status of all batteries and historical data.
Charts, tables and Graphs will be displayed.
Can set new battery database table connection (All data will be in same database, different tables).


Image 2: Proposed format for adding new table connection

9. Owner Dashboard
Signup the website and views the dashboard.
Admin assigned batteries will be displayed.
Can Manage Workers - assign worker to 1 or more batteries owned by him.
Displays the battery data in Tables, Graphs and charts.
No access to CMS backend features


10. Worker Dashboard
Signup in the website and access his dashboard.
Admin or Owner assigned batteries can be viewed.
View battery data - tables, charts and graphs.

11. Backend Development
New battery databases can be connected / imported.
However based on the column names the data visualization module (charts and graphs) might need to be coded into the backend system.
This can be further explored based on the database schema.
MongolDB connection not required now and only will be developed in the future.

12. Database Table
The provided database from Amazon AWS consists of the following tables:
Table Names
mod_daily_reads
mod_monitor_status
stg_monitor_status
sys_daily_reads
sys_fixed_var (to be updated - might not have the same name)
sys_half_hr_read
sys_monitor_status
Database Table Column Name Updates:
Table “sys_fixed_var” will be used for battery listing. All battery unique key will be stored here to link to 6 other tables.
Table “sys_fixed_var” will be updated to have unique identifier for each battery.
Updated table consists of “num_id”, “sysname”, “sys_type”, “description”
“num_id” is the unique key for each battery
“sysname” is the battery name, which may or may not be unique and the name can be changed anytime.
“systype” is the battery type
“description” is the description for each battery
Battery info (battery name) from this table to be shown to user for easy reference.
Unique key for each tables are “num_id”
Using unique key to retrieve battery information for each table.
For other tables data, which column to be displayed in tables and graphs will be decided after prototype.

Image 3: Databases & their respective column names

13. Other Information
Graphs and Charts format to be shown on the dashboard are to be confirmed
Wireframes for Front-end User Dashboard design.

Image 4: Wireframe for User Front-end Dashboard
Note: Wireframe only. End result might differ from this design.

Sample data of the proposed battery database will be provided and used for prototype & end product.

14. Estimated Timeline
Approximate time to complete the project: 30-45 days

15. Note on solar panel (new table)
Will be adding Solar panel table (currently only 1 table) to the connection.
Solar Panel not required in Prototype.
Solar panel assignment to users, dashboard to display the solar panel data graphs and charts - current and historical.







16. Project Milestone (Estimated 30-45 days)
Milestone 1: Prototype
Prototype needs to show all data in the database.
Latest data must be read correctly
Historical data (10-20 data can be read accordingly)
All data must be shown in table
(Optional) Data to be shown in graph. Please estimate how long is required for data to be shown in graphs
User access level not required in prototype
Filtering in table and graph are not required.

Milestone 2: Development stage 1 - Data presentation
Confirmation of what filters to be used and which table to be shown
Demonstration of filters and graphs

Milestone 3: Development stage 2 - Completion of user access level
Demonstration of user access level in frontend
Demonstration of admin, owner and worker level user panel

Milestone 4: Development final stage – Completion of User Frontend Panel
Complete user front-end interface for admin, owner and worker to access battery database.
Owner able to filter data and the data will be shown in tables and graphs

17. Payment Milestone
Down Payment (25%)
Milestone 1: Prototype (25%)
Milestone 2: Development stage 1 - Data presentation (12.5%)
Milestone 3: Development stage 2 - Completion of user access level (25%)
Milestone 4: Development final stage – Completion of User Frontend Panel (12.5%)

MySQL PHP SQL

Project ID: #11244026

About the project

114 proposals Remote project Active 7 years ago

114 freelancers are bidding on average $2631 for this job

meet2amitvw

Lets discuss on freelancer message box for finalizing the technical scope with proper cost and time....I will share some demo as well for recent works if you want to check. You can also check my profile page as i ha More

$3000 SGD in 30 days
(173 Reviews)
9.3
sapotacorp

Hi sir. I see your docx file and read your requirement. I have a question about "4. Display battery data in tables and graphs", how the battery data look like in graphs?

$2117 SGD in 25 days
(882 Reviews)
9.0
codeguru786

Hi, Thanks a lot for posting the project, we have checked your project description it gives the idea of what your concept or end goal is but as you know that most of the requirements are not defined so it will be gre More

$3000 SGD in 30 days
(431 Reviews)
9.2
TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W More

$2647 SGD in 30 days
(254 Reviews)
8.8
graphicaa

Hello, I understand this website/portal is for monitoring battery health status. we can workout this. Question : Is the battery readings ( such as voltage/ AH) will get measured through other software and the data to More

$3000 SGD in 30 days
(633 Reviews)
9.2
mmagr99

very motivated and confident to get this done

$3529 SGD in 24 days
(228 Reviews)
8.6
kabirchy

Hi there, my name is Khorshed. I have read your project brief and project attached document. I can help you develop this site in Yii or CakePHP framework. I would love to discuss with you further to take this project o More

$3529 SGD in 30 days
(1242 Reviews)
9.3
webbookstudio

Hello, my name is Olya. I represent Ukrainian IT Company «Webbook». We provide website design and web and app development services for organizations, public and government institutions, company or private web-pages. More

$2500 SGD in 30 days
(335 Reviews)
8.7
shivmirthyusl

ABOUT US "IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 8+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networkin More

$2352 SGD in 30 days
(298 Reviews)
8.6
latatestTech

With Freelancer Preferred badge bound to give 100% Quality (Let's Chat) Hello, A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requiremen More

$2764 SGD in 30 days
(191 Reviews)
8.2
workspaceit

Hello, I m Tahsinul Alam, completed Masters in Software Engineering now working as one of the project manager of Workspace Infotech, software/Outsourcing firm located in Dhaka, Bangladesh. We have 13 different team More

$2500 SGD in 30 days
(55 Reviews)
8.0
alyaspk

Dear Employer, I am ready to work on your required task and can assure 100% satisfaction. You can read reviews/details about my past work on my profile http://www.freelancer.com/u/alyaspk.html Looking forward t More

$3411 SGD in 30 days
(194 Reviews)
7.5
identityself

Hi, we have gone through attached document , i think its best to do witth yii or ci , so lets start discussion and clarify more about job . Thanks

$2000 SGD in 30 days
(186 Reviews)
7.5
ITLove007

Hello. I have full experience in native Android, IOS and Web site and speak English fluently. I have developed apps like Social app like Meetout, ECommerce app, Radio app, OpenVPN, Chatting app, Photo Sharing, GPS T More

$2631 SGD in 30 days
(61 Reviews)
7.5
prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i More

$3529 SGD in 30 days
(56 Reviews)
7.1
cijagani

‌I have a lots of experience in PHP MVC,MySQL, Wordpress, Codeigniter, laravel and Web Designing. my aim to deliver quality products to our customers within specified deadline. If hired by you I will put in my best w More

$2117 SGD in 28 days
(153 Reviews)
7.1
iglobalvn

Hi sir, I have read your requirement carefully. I am interested to work for this project and i will provide within or before 30 days . If you wanna confirm me, please check my work history and portfolio kindly. T More

$2500 SGD in 30 days
(104 Reviews)
7.3
Shopify

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More

$3529 SGD in 50 days
(27 Reviews)
7.0
aksharkthakkar

hello i am expert in web design using css html js bootstrap and developing using php wordpress so lets make custom PHP/Wordpress website as described by you. i am perfect who can work on it :)

$2500 SGD in 30 days
(84 Reviews)
6.9
csajit

HELLO THERE, Over 200+ Positive Reviews. Over 90% Completion Rate. 5 Star Rating. 8+ Years of experience in PHP/MYSQL I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON More

$2500 SGD in 30 days
(282 Reviews)
6.8