Custom registration pages needed
4701
£150(approx. $187)
- Posted:
- Proposals: 0
- Remote
- #75076
- Archived
Description
Experience Level: Expert
This is a repeat posting of a previous job, with immediate start job due to the previous bidder not completing the work in a timely fashion.
It is about 4 hours work.
We have a requirement for a series of custom registration pages to be written in a PHP/MySQL framework. The requirement has come about due to time constraints. We are not techno-ignorant, just very busy, and fully able to read, write and understand code.
We require the first registration page to request a VAT number. The page should then fetch the associated details for the european database (example here http://ec.europa.eu/taxation_customs/vies/ or vatchech.eu) and use these values as default values in the next registration page with these values in editable text fields.
(example output:
VAT number BE 0403200393 --> capture this
Name XYZ corporation --> capture this
Adres Rue de la Faux --> capture this
Country BELGIUM 0 --> capture this
Request date 26.05.11 --> is the start date, see below)
EU VAT number format definitions can be found here: http://www.advsofteng.com/vatid.html.
The client then fills in/corrects these details and adds contact telephone number and contact name.
The registrants adjusts as required, and goes to the next page.
Page two has drop down menus populated from BusinessTypes table. The structure "I_am", "one_of" "a_type" is a nested structure. Reverse the order and you get (shops > local shops > baker). The registrant picks one. There must be an option to fill in their own hierarchy if they don't see their business there (three editable text fields).
An example triple drop down menu is here: http://www.trans4mind.com/personal_development/JavaScript/tripleMenu.htm
Next page is where services are to be purchased. These are identified by being of the datatype 'enumerated' in the Businesses table. These should be basic listing, prestige listing, twitter, euromilions, payment terms in check box form as they are cumulative (please put in an html table with two columns).
The final page needs to "Accept terms and conditions, integrate with PayPal (or pay on receipt of invoice) and then...
From these steps you should now be able to get the latitude and longitude from a geolocation service (google, we presume), and insert the data into the appropriate tables (make sure the BusinessTables table is properly populated) using the VAT number as a foreign index.
The database user is defined in the constant 'SIUSER', and only has insert and select privileges to the listed tables.
This work does not require integration with Wordpress but will access the CSS, wp-config and other libraries as required .
We will do the integration with our website, error testing, etc. Alternatively, feel free to put them into a Wordpress plug-in, we are fully conversant with the technology.
Bidder should include an example of previous code.
Locations:
$describe_table="CREATE TABLE `$table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`business_name` VARCHAR( 40 ) NULL ,
`VAT` VARCHAR( 15 ) NULL ,
`street` VARCHAR( 40 ) NULL ,
`number` VARCHAR( 40 ) NULL ,
`city` VARCHAR( 40 ) NULL ,
`postcode` VARCHAR( 40 ) NULL ,
`state` VARCHAR( 2 ) NULL ,
`country` VARCHAR( 2 ) NULL ,
`page_id` INT,
`latitude` DOUBLE NULL ,
`longitude` DOUBLE NULL ,
`image_url` VARCHAR( 350 ),
UNIQUE (`id`));" ;
Businesses:
$describe_table="CREATE TABLE `$table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`business_id` int NULL ,
`contact_name` VARCHAR( 40 ) NULL ,
`phone` VARCHAR( 15 ) NULL ,
`VAT` VARCHAR( 15 ) NULL ,
`start` date NULL ,
`finish` date null,
`basic_listing` enum('yes', 'no'),
`prestige_banner` enum('yes', 'no'),
`simple_web_page` enum('yes', 'no'),
`full_web_site` enum('yes', 'no'),
`twitter_alerts` enum('yes', 'no'),
`euromillions` enum('yes', 'no'),
`copy_writer` enum('yes', 'no'),
`photographer` enum('yes', 'no'),
`payment_terms` enum('monthly', 'quarterly', 'yearly'),
UNIQUE (`id`));" ;
BusinessTypes:
$describe_table="CREATE TABLE `$table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`VAT` VARCHAR( 15 ) NULL ,
`grandparent` int NULL ,
`parent` int NULL ,
`child` int NULL ,
`i_am` VARCHAR( 15 ) NULL ,
`one_of` VARCHAR( 15 ) NULL ,
`a_type` VARCHAR( 15 ) NULL ,
UNIQUE (`id`));" ;
I am available all day for clarifications if required.
Many thanks
It is about 4 hours work.
We have a requirement for a series of custom registration pages to be written in a PHP/MySQL framework. The requirement has come about due to time constraints. We are not techno-ignorant, just very busy, and fully able to read, write and understand code.
We require the first registration page to request a VAT number. The page should then fetch the associated details for the european database (example here http://ec.europa.eu/taxation_customs/vies/ or vatchech.eu) and use these values as default values in the next registration page with these values in editable text fields.
(example output:
VAT number BE 0403200393 --> capture this
Name XYZ corporation --> capture this
Adres Rue de la Faux --> capture this
Country BELGIUM 0 --> capture this
Request date 26.05.11 --> is the start date, see below)
EU VAT number format definitions can be found here: http://www.advsofteng.com/vatid.html.
The client then fills in/corrects these details and adds contact telephone number and contact name.
The registrants adjusts as required, and goes to the next page.
Page two has drop down menus populated from BusinessTypes table. The structure "I_am", "one_of" "a_type" is a nested structure. Reverse the order and you get (shops > local shops > baker). The registrant picks one. There must be an option to fill in their own hierarchy if they don't see their business there (three editable text fields).
An example triple drop down menu is here: http://www.trans4mind.com/personal_development/JavaScript/tripleMenu.htm
Next page is where services are to be purchased. These are identified by being of the datatype 'enumerated' in the Businesses table. These should be basic listing, prestige listing, twitter, euromilions, payment terms in check box form as they are cumulative (please put in an html table with two columns).
The final page needs to "Accept terms and conditions, integrate with PayPal (or pay on receipt of invoice) and then...
From these steps you should now be able to get the latitude and longitude from a geolocation service (google, we presume), and insert the data into the appropriate tables (make sure the BusinessTables table is properly populated) using the VAT number as a foreign index.
The database user is defined in the constant 'SIUSER', and only has insert and select privileges to the listed tables.
This work does not require integration with Wordpress but will access the CSS, wp-config and other libraries as required .
We will do the integration with our website, error testing, etc. Alternatively, feel free to put them into a Wordpress plug-in, we are fully conversant with the technology.
Bidder should include an example of previous code.
Locations:
$describe_table="CREATE TABLE `$table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`business_name` VARCHAR( 40 ) NULL ,
`VAT` VARCHAR( 15 ) NULL ,
`street` VARCHAR( 40 ) NULL ,
`number` VARCHAR( 40 ) NULL ,
`city` VARCHAR( 40 ) NULL ,
`postcode` VARCHAR( 40 ) NULL ,
`state` VARCHAR( 2 ) NULL ,
`country` VARCHAR( 2 ) NULL ,
`page_id` INT,
`latitude` DOUBLE NULL ,
`longitude` DOUBLE NULL ,
`image_url` VARCHAR( 350 ),
UNIQUE (`id`));" ;
Businesses:
$describe_table="CREATE TABLE `$table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`business_id` int NULL ,
`contact_name` VARCHAR( 40 ) NULL ,
`phone` VARCHAR( 15 ) NULL ,
`VAT` VARCHAR( 15 ) NULL ,
`start` date NULL ,
`finish` date null,
`basic_listing` enum('yes', 'no'),
`prestige_banner` enum('yes', 'no'),
`simple_web_page` enum('yes', 'no'),
`full_web_site` enum('yes', 'no'),
`twitter_alerts` enum('yes', 'no'),
`euromillions` enum('yes', 'no'),
`copy_writer` enum('yes', 'no'),
`photographer` enum('yes', 'no'),
`payment_terms` enum('monthly', 'quarterly', 'yearly'),
UNIQUE (`id`));" ;
BusinessTypes:
$describe_table="CREATE TABLE `$table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`VAT` VARCHAR( 15 ) NULL ,
`grandparent` int NULL ,
`parent` int NULL ,
`child` int NULL ,
`i_am` VARCHAR( 15 ) NULL ,
`one_of` VARCHAR( 15 ) NULL ,
`a_type` VARCHAR( 15 ) NULL ,
UNIQUE (`id`));" ;
I am available all day for clarifications if required.
Many thanks
Xavier G.
99% (16)Projects Completed
11
Freelancers worked with
9
Projects awarded
39%
Last project
4 Dec 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies