In Progress

Online Licence Generator (PHP MySQL)

An Online Licence Generator (OLG) is needed. This will be a web page written in PHP which will interface with a MySQL database and a back end licence generator which currently exists as a non-web application.

The OLG will allow multiple levels of user to log in and store those user passwords securely.

The OLG will allow users to generate 'activation codes' after they log in.

The OLG will allow these activation codes to be used to generate 'licences'.

The OLG will also provide management functions to manage users and other system features.

The system will be deployed on our servers which are configured and running.

Skills required include PHP programming with HTML output and with MYSQL database backend on a Linux platform (LAMP) and integration to an external licence generator (via PHP functions like shell_exec()).

Documentation will be added here as needed. Freelancers are welcome to adjust their bids once they have seen the additional information. I've put up a page of wireframe documents as a starter.

After recent problems with another freelancer, weekly updates will be required, and after each payment has been made, you must promptly upload the items we have paid for to our website. You are welcome to upload them earlier, but we do need to test all the items on our website on a weekly basis to ensure we are on track to continue development.

The project price to be quoted for is "phase 1" which is to demonstrate you can:

(a) upload files to our site.

(b) follow our documentation.

(c) write in PHP and talk to MySQL database.

(d) produce pages with tabs either across the top or down the side to select which page (see wireframes attached)

(e) provide a login page for users to log in, checking passwords in the MySQL database.

This must be demonstrated and (once we have paid) uploaded to our web site.

Once we've completed phase 1, we will proceed with mini projects until the entire Online Licence Generator is complete. It is anticipated the the entire project budget for phase 1, 2 and 3 will be around £2500 and completion is expected in around 4-6 weeks. For now the quote should just be for phase 1 as shown above. We will add milestones to the system as additional work afterwards and we can agree scope and price for each one as we proceed.

You will be required to either use a known IP address or use SSH login in order to upload php files securely. In emergency you can always email me a zip file directly. (Note: Your IP address is likely to be the same even if you don't have a static one, providing you don't reboot your router; we can change the address assigned when your changes).

All communication should be by email on this platform, as it provides a clear record of what has been agreed. I'm reluctant to talk over Skype or phone calls because I find it hard to hear, and there's no written record to refer to. And please don't spam everyone in the company after you've discovered our web page: it just annoys people and gets you blocked.

Andy Henson. Wavestore Global Ltd. [url removed, login to view]

Please read the OLG-background.txt document which gives and introduction to the requirement and some of the terms.

The sql schema are under development, initial proposed tables are in OLG-proposed-schema-19sept.zip

I've had discussions on secure passwords, so I've uploaded php-password.zip which contains some proposals. You are welcome to use others but should work with PHP 5.3 and later and must not suffer the change in behaviour occurred to fix a bug in PHP 5.3.7 CRYPT_BLOWFISH.

It's been pointed out that the Wireframes document contains the term "WG/Regional/ODM". The levels of company are defined in OLG-Background.txt and WG=the top level Wavestore Global company. Regional/ODM are the middle layer companies.
Also the term "TBD" means to be defined (in later phase).

== PHASES ==

Phase 1.0 - Proof of concept: User Login screen
Phase 1.5 - Proof of concept: Calling backend wavelicence programs.

Phase 2.0 - Simple Generate Licence Screen
Phase 2.1 - User maintenance screens (Add, Modify password, Delete, List) (Add Distributor)
Phase 2.2 - Reports and Credits basic screens (adding credits)
Phase 2.3 - Purchase Activation Code and Return AC screens.
Phase 2.4 - Testing and deployment.

Phase 3.0 - Enhanced Generate Licence Screen (multiple activation codes)
Phase 3.1 - Enhanced Reports and Credits screens
Phase 3.x - final details of this phase to be decided


== DETAIL ==

Phase 1.0 - Proof of concept: (proof freelancer can write basic PHP/MySQL code)
this is to demonstrate you can:
(a) upload files to our site.
(b) follow our documentation.
(c) write in PHP and talk to MySQL database.
(d) produce pages with tabs either across the top or down the side to select which page (see wireframes attached).
(e) provide a login page for users to log in, checking passwords in the MySQL database. It should look like the page suggested in the Wireframes.

This must be demonstrated and (once we have paid) uploaded to our web site.

Although this is a proof of concept, it will form the basis for later phases. it is probably worth having a Add User screen to set the password; passwords should be encrypted.

Phase 1.5 - Proof of concept: Calling backend wavelicence programs.

Code has been provided for this, but you might like to improve it.

The dummy code is be called when the user enters an activation code, machine id, and cameras into the Generate Licence screen.

For this "proof of concept" phase we will ignore the activation code and validation, we are just proving backend connectivity.

And also we will be testing a form for Generate Licence



Phase 2.0 - Development: Simple Generate licence Screen

Here we produce a validated version of above. Activation codes for test purposes will be added to the database via mysql command line and the OLG will use them.

Only a single activation code will be used in this phase. The developer should be aware that in future, multiple activation codes can be combined.

Phase 2.1 - User maintenance screens (Add, Modify Password, Delete, List) (Add Distributor)

As per wireframe. Passwords should be encrypted.

Phase 2.2 - Reports and Credits basic screens (adding credits)

Credit: Ability for admin staff to send credits to other companies. This should reduce the sender's balance and increase the recipient's balance.
CreditLimit: Ability for admin staff to set creditlimits of other companies. The creditlimit should again be transferred from the sender to the recipient.
Transactions should be used to ensure data is consistent.

Phase 2.3 - Purchase Activation Code and Return AC screens.

Activation codes can be created by the system, stored in the database, and a charge in credits made for them. The cost of these is complex and Wavestore will supply the code for this (the sales staff change it regularly and it might be in the database).
Transactions should be used to ensure data is consistent.

Phase 2.4 - Testing and deployment. System goes live.

Skills: HTML, MySQL, PHP

See more: php mysql code generator online, ajax mysql php generator, software write mq4, software write chip epson, useful software write book, free mysql php generator next page system, software write web specs, order product online stores database mysql php, php mysql pdf generator, free software write user guide, php mysql rss generator, software write edid, free software write company profile, online help system mysql php, software write websites idea, software write book images, php mysql feed generator, software write books, php mysql graph generator, software write protection, mysql php generator linux, free software write book, software write book, added pictures online system mysql php, ajax php mysql graph generator

About the Employer:
( 1 review ) Uxbridge, United Kingdom

Project ID: #11550506

Awarded to:

ccpplinux

Hi, I have downloaded the file attached with this project description and have studied it. I need some clarification in regard to hierarchy of the multi user system that you want to develop. Under the Reports section More

£300 GBP in 10 days
(152 Reviews)
7.0

43 freelancers are bidding on average £601 for this job

meet2amitvw

Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat.....I will share some demo as well for recent works if you want to check. You can also c More

£721 GBP in 10 days
(158 Reviews)
9.3
TenStar718

How are you. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I can complete your project on time and within your budget. i have build Bank Management More

£631 GBP in 10 days
(198 Reviews)
8.3
seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience working on /PHP/MySQL/HTML5/jQuery/Laravel/Wordpress/Magento/Joomla/Drupal/[url removed, login to view] More

£773 GBP in 10 days
(119 Reviews)
8.7
nuked24

Hi, We are expert in designing as well in development. We will provide you quality of work. We will provide you our [url removed, login to view] want long term relationship with you. Please choose us and provide a chance to work wi More

£1546 GBP in 30 days
(167 Reviews)
8.6
akash9958

Hello, "I read through the project description carefully and I am sure that I can do this project very well. I would like to discuss this project with you." We are the team of 8 employees and over past 6 years w More

£1500 GBP in 20 days
(228 Reviews)
8.1
albertmobi29

Hi there, I read the requirements and I am happy to assist you on your project, I am Albert and I have 5+ years of experience in Web Development, I can assure you about quality work and you will receive fast and More

£1055 GBP in 20 days
(52 Reviews)
7.2
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 [url removed, login to view] Looking forward t More

£631 GBP in 10 days
(149 Reviews)
7.3
mxicoders

Dear Sir/Ma'am, We possess 7+ years of experience in I.T. Field and running MXI Coders Pvt Ltd (INDIA), Our strengths are in Web Designing, Web Development using -HTML 5, Flash, HTML/CSS/CSS3 web pages -Cloud c More

£555 GBP in 30 days
(43 Reviews)
7.2
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

£611 GBP in 10 days
(51 Reviews)
7.0
phpprogramming

5+ years experience in PHP, MySQL, Javascript, eCommerce, CodeIgniter and WordPress. [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] More

£555 GBP in 10 days
(216 Reviews)
6.8
£777 GBP in 20 days
(306 Reviews)
6.8
maxtechsl

Hello Andy Henson, we are ready to develop your OLG system using PHP/Mysql with user friendly admin panel as per requirement. We have gone thro the attached doc for Phase1 wirefrme. We assure you quality work, regular More

£566 GBP in 10 days
(90 Reviews)
6.4
Codomotive

Hello Sir, We thank you to give us the opportunity to bid on your project. We are really interested to work on your project. I had a look on your requirement and I think we have exact skill set to effectively complet More

£1000 GBP in 20 days
(32 Reviews)
5.8
peterftoth

Hi! I can start it right away! I have my own framework, to make this job done. You can check my previous jobs on my profile: [url removed, login to view] If you check my reviews you can see, my empl More

£388 GBP in 3 days
(16 Reviews)
5.9
osminosm

Well experienced backend web developer available. ####################################################################################################################################################

£250 GBP in 0 days
(40 Reviews)
5.3
webdesigncanada

Hi Andy, Warm Regards and thanks for reviewing our proposal. We have gone through your project description and we are pleased to say that we will complete your project as per your requirement. Please allow More

£555 GBP in 10 days
(17 Reviews)
5.6
amin6106

Hi there, I have gone through the document attached. From document it looks like user management and generation job. I will develop custom code. I have over 6+ years of experience in php, mysql, css, facebo More

£333 GBP in 7 days
(70 Reviews)
6.0
creativegurus

Greetings! My name is Moeez. We'll be glad to discuss the arrangement in detail to ensure we are on the same page. - GRAPHIC DESIGN - WEBSITE DESIGN - RESPONSIVE WEB DEVELOPMENT - E-COMMERCE SOLUTIONS - C More

£888 GBP in 15 days
(11 Reviews)
5.7
wondergenie

Thanks for the detailed document and I can do the 5-6 screens mentioned there within the time and budget specified. I assume that phase 1 does not include api integration for license generation. If my understanding is More

£600 GBP in 15 days
(4 Reviews)
5.4
FRConsulting

Thanks for considering me. The one thing I'm not sure of in your spec is that you appear to use the words menu and tabs interchangeably. If I'm correct in that assumption, your Phase 1 requirements seem quite straig More

£400 GBP in 10 days
(9 Reviews)
5.4