Find Jobs
Hire Freelancers

Database and Website Creation

$100-250 USD

Cerrado
Publicado hace casi 13 años

$100-250 USD

Pagado a la entrega
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.
ID del proyecto: 2664065

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 13 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
17 freelancers están ofertando un promedio de $172 USD por este trabajo
Avatar del usuario
See private message.
$195,50 USD en 20 días
4,9 (19 comentarios)
4,9
4,9
Avatar del usuario
See private message.
$136 USD en 20 días
4,9 (30 comentarios)
4,8
4,8
Avatar del usuario
See private message.
$170 USD en 20 días
5,0 (16 comentarios)
4,4
4,4
Avatar del usuario
See private message.
$148,75 USD en 20 días
4,2 (35 comentarios)
4,5
4,5
Avatar del usuario
See private message.
$212,50 USD en 20 días
4,8 (6 comentarios)
3,5
3,5
Avatar del usuario
See private message.
$212,50 USD en 20 días
4,4 (7 comentarios)
2,9
2,9
Avatar del usuario
See private message.
$204 USD en 20 días
5,0 (4 comentarios)
2,5
2,5
Avatar del usuario
See private message.
$195,50 USD en 20 días
5,0 (2 comentarios)
2,4
2,4
Avatar del usuario
See private message.
$85 USD en 20 días
5,0 (5 comentarios)
0,8
0,8
Avatar del usuario
See private message.
$148,75 USD en 20 días
5,0 (2 comentarios)
0,5
0,5
Avatar del usuario
See private message.
$212,50 USD en 20 días
5,0 (5 comentarios)
0,3
0,3
Avatar del usuario
See private message.
$127,50 USD en 20 días
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
See private message.
$170 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
See private message.
$204 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
See private message.
$110,50 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
See private message.
$212,50 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
See private message.
$170 USD en 20 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
United Kingdom
4,2
10
Miembro desde nov 15, 2006

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.