Encerrado

Client Login Portal SQL

SQL Portal Database & Reporting

We need a SQL backend for our client portal below outlines the functionality required. Hosting of SQL will be by on our providers server.

Our company carries out annual air conditioning servicing. Retail stores(client) sell air conditioners to their customers(end user) then submit details to us for annual servicing.

Clients receive a commission on every service we carry out every year after for their customer. They need to be able to see what customers they have with us? When they were last serviced and how much they have earned?

We need to be able to administer these functions.

Protectair- Our Company

Client – Retail Store

Customer- End User

CLIENT FUNCTION

[url removed, login to view] login to portal

[url removed, login to view] can submit Customer details to Protectair for annual servicing by Protectair

i. Name

ii. Surname

iii. Address

iv. Contact Numbers

v. Purchase Date

vi. Make

vii. Model Number

viii. Serial Number

3. Client can run report to see all of their customers submitted to us.

4. Client can see when client last serviced and when next service is due.

5. Client can run a commission earned report for the current month then by calendar dates eg. Last Month, Year to date, Last year

PROTECTAIR ADMIN FUNCTIONS

1. Search and view individual client customer base

2. Set a service appointment/date for customer- reminder function for month due ???

3. Enter date service completed

4. Set a commission rate % and $

5. Run Client Commission Report –Print

Habilidades:

Ver mais: login portal sql, service air, portal functionality, numbers function, login to, function numbers, sql air login, sql server admin, on sql, vi, sql server reporting, sql database report, sql c, report sql, login a, customer login, conditioning, annual report, all portal, air conditioning, calendar print, store portal, functions login, administer, backend login

Acerca do Empregador:
( 94 comentários ) Gold Coast, Australia

ID do Projeto: #143611

5 freelancers estão ofertando em média $284 para este trabalho

multicom

Hello, We will create a SQL backend for your client portal according to all the requirements you posted. Let's discuss details in PMB. Best regards, Nikolay Karyaka.

$250 USD in 0 dias
(63 Comentários)
7.1
webapplication

Hi, PLease check PM for details. Regards.

$290 USD in 8 dias
(23 Comentários)
4.6
acumensofttech

Please check your PM for details.

$290 USD in 6 dias
(10 Comentários)
3.6
www6STECHcom

Hi, We would like to introduce ourselves as a company of professionals who are driven by the philosophy of customer satisfaction through QUALITY and INNOVATION. We specialize in web-related technologies and soft Mais

$300 USD in 0 dias
(162 Comentários)
3.1
bendriss

Hello, Your needs are clear, i can start immediately, please see pm

$290 USD in 7 dias
(16 Comentários)
1.9