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.