Database and Website Creation(repost)

Completed Posted May 6, 2011 Paid on delivery
Completed Paid on delivery

Creation of a relational database (6 tables)

table 1 reseller also called agent database - agent (reseller) contact details:

email, phone, mobile phone, post code, first name, last name

table2 Business - customer contact details

table 3 - Our company (Admin) - to which all details within above tables are related to

table 4 - campaign table

(more details later)

table 5 - recipients (the customers of the businesses) table

relationship link to shop

contact details: phone, name, email address

table 6 - zone agent with similiar contact details as agent

1. Create simple website (like Google white with logo in the middle - Logo already created)

2. Create admininstration signup for us, agent (reseller) signup logic and business signup logic with payment link to Paypal for business and agent.

3. Create login for administrator, zone agent, agent and business.

Create control panel with global view of agent and customer for administrator, with ability to add resellers, add customers directly, opportunity to assign customers to resellers

4. Control panel for agent (reseller) with view of his/her customer transactions, and option to add customer details and send email to customer.

5. Control panel for business to change their contact details, change passwords, buy 5 different product packages, upload SMS text with restriced characters in campaign field, opt in tick box to be globally viewable to other businesses, but not to recipients. Contact details such as phone number, email, names of the business' customer, show red flag if business does NOT want to be contacted by other businesses or green flag to show that they are ready to be contacted. The green and red flag should be globally viewable when the business has clicked on opt in.

6. Separate business registration independent of agent.

Integrate with 3rd party API - Google Map to see where businesses are

Requirement: Full documentation of every function.

Access: phpmyadmin and ftp access to server.

There will be two links that will be called from within.

## Deliverables

Keeping in mind that the previous programmer dissapeared and did not complete the work, I require an update every 2-3 days and would like to have part of the code delivered in these intervals.

Below are some questions the previous programmer asked, which were valid.

Creation of a relational database (7 tables)

table 1 user database - agent (reseller) contact details:

email, phone, mobile phone, post code, first name, last name

Table:Agent

userid

email

phone

mobile phone

post code

first name

last name

table2 Business- business contact details

Table:Customers

userid

email

phone

mobile phone

post code

Business Name

Type of Business

first name

last name

table 3 - Our company (admin) - to which all details within above tables are related to

table3:Company

CompanyID

ANSWER: Still pondering what the name for this service is going to be, at the moment it is called UK2Text

table4:Campaign

Campaignid

- text of campaign

- from field

- subject field

- date

- time

- number of recipients

- number of confirmed deliveries

table 5 - recipients table (recipients of SMS texts are the customers of the businesses)

relationship link to business or shop

contact details: phone, name, email address

table:Recipients

Recipientid

relationship link to shop

email

phone

mobile phone

post code

first name

last name

table 6 - zone agent who manages agents, same contact details as agents

1. Create simple website (like Google white with logo in the middle - Logo already created)

2. Create admininstration registraton for us, agent (reseller) registration and customer registration with payment link to Paypal for customer and agent.

Form:Admin Registration

Form:Agent Registration

Once registered should the user be forwarded to paypal to pay? or will there be a link on the registration page that takes them to Paypal to register? Will you be setting up a product in paypal and provide me with the link?

ANSWER: It needs to use IPN, the products are within the website, which means that there should be a 6th table.

3. Create login for administrator, agent and business

Create control panel with global view of agent and business for administrator, with ability to add agents, add businesses directly, opportunity to assign businesses to agents and the ability to remove agents businesses and the contact details of their customers, which are mainly phone numbers.

Form:Admin Login

Form:Agent Login

Form:Customer Login

Form:Admin Control Panel- view all agents and businesses assign businesses to agents, links to registration forms for agents and businesses.

4. Control panel for agent (reseller) with view of transactions of businesses. The agent needs to be able to see which package the business has bought, and option to add customer details (NOT to remove any details) and send email to customer.

5. Control panel for business to change their contact details, change passwords, buy product packages, upload SMS text with restriced characters, opt in to be globally viewable, add contact details such as phone number, email, names of their customer, show red flag if customer does NOT want to be contacted by other customers or green flag to show that he or she is ready to be contacted. The green and red flag should be globally viewable when the customer has clicked on opt in.

Form: Business Control Panel-Contact Details(see customer table above), Change password, opt in(checkbox), modify details from register process(see customer table above), contact me(checkbox). red or green flag shows in customer listing in agent view if the customer has checked "opt in". If the Customer has not checked "opt in" then the customer will not show up in agent listing of customers. However the customer will show up in admin control panel no matter what.

ANSWER: The business should be visible to all other businesses when they optin. The idea is to show that the business is prepared to co-promote with another business in the area when they choose the green button.

Integrate with 3rd party API - Google Map to see where businesses are located

Requirement: Full documentation of every function.

Access: phpmyadmin and ftp access to server.

There will be two links that will be called from within.

General Questions:

"There will be two links that will be called from within.", Where will these two links be, what are these links?

"Integrate with 3rd party API - Google Map to see where customers are", map shows up on Admin Control Panel and Agent control Panel.

The links are to a bulk SMS provider who we are using to send out SMS text messages. The customers will be able to buy additional SMS text packages from us.

If an agent adds a customer is the customer automatically assigned to that agent? Yes

Will customers only be assigned to one agent at at time? Yes

Will there be a 6th table that is used for the relation of agent to customer? or, will there be a column in the customer table that is used to hold the ID of the agent they are assigned to?

ANSWER: Good question: An additional table is better to make it more flexible.

If the project grows it might require a zone agent. Perhaps just in case that should be thought off as well.

Attached is an example how the accounts of the businesses should look like.

Engineering Linux MySQL PHP Project Management Software Architecture Software Testing User Interface / IA

Project ID: #3295820

About the project

6 proposals Remote project Active May 11, 2011

Awarded to:

ngscoder

See private message.

$170 USD in 20 days
(141 Reviews)
7.1

6 freelancers are bidding on average $174 for this job

bdtechies

See private message.

$153 USD in 20 days
(41 Reviews)
4.3
moizjam

See private message.

$85 USD in 20 days
(15 Reviews)
3.9
ieinfotech

See private message.

$212.5 USD in 20 days
(15 Reviews)
3.3
Dheerajakovtech

See private message.

$211.65 USD in 20 days
(0 Reviews)
0.0
websoftdevevw

See private message.

$212.5 USD in 20 days
(0 Reviews)
0.0