Find Jobs
Hire Freelancers

Database and Website Creation

$100-250 USD

Geschlossen
Veröffentlicht vor fast 13 Jahren

$100-250 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 2664065

Über das Projekt

17 Vorschläge
Remote Projekt
Aktiv vor 13 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
17 Freelancer bieten im Durchschnitt $172 USD für diesen Auftrag
Avatar des Nutzers
See private message.
$195,50 USD in 20 Tagen
4,9 (19 Bewertungen)
4,9
4,9
Avatar des Nutzers
See private message.
$136 USD in 20 Tagen
4,9 (30 Bewertungen)
4,8
4,8
Avatar des Nutzers
See private message.
$170 USD in 20 Tagen
5,0 (16 Bewertungen)
4,4
4,4
Avatar des Nutzers
See private message.
$148,75 USD in 20 Tagen
4,2 (35 Bewertungen)
4,5
4,5
Avatar des Nutzers
See private message.
$212,50 USD in 20 Tagen
4,8 (6 Bewertungen)
3,5
3,5
Avatar des Nutzers
See private message.
$212,50 USD in 20 Tagen
4,4 (7 Bewertungen)
2,9
2,9
Avatar des Nutzers
See private message.
$204 USD in 20 Tagen
5,0 (4 Bewertungen)
2,5
2,5
Avatar des Nutzers
See private message.
$195,50 USD in 20 Tagen
5,0 (2 Bewertungen)
2,4
2,4
Avatar des Nutzers
See private message.
$85 USD in 20 Tagen
5,0 (5 Bewertungen)
0,8
0,8
Avatar des Nutzers
See private message.
$148,75 USD in 20 Tagen
5,0 (2 Bewertungen)
0,5
0,5
Avatar des Nutzers
See private message.
$212,50 USD in 20 Tagen
5,0 (5 Bewertungen)
0,3
0,3
Avatar des Nutzers
See private message.
$127,50 USD in 20 Tagen
0,0 (1 Bewertung)
0,0
0,0
Avatar des Nutzers
See private message.
$170 USD in 20 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
See private message.
$204 USD in 20 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
See private message.
$110,50 USD in 20 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
See private message.
$212,50 USD in 20 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
See private message.
$170 USD in 20 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED KINGDOM
United Kingdom
4,2
10
Mitglied seit Nov. 15, 2006

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.