Em Andamento

joomla website with customer database and chron job

Simple website to allow customers to see their data usage

The customer needs to see their data usage on a timely basis.

We buy the satellite services from one vendor and resell them to our customers.

Every 24 hours on our Vendor dealer portal an excel file is available for us to download that shows the previous 24 hours inbound and outbound Megabit usage for each of our customers. It is all on one sheet of one workbook with all the customers in a sort order of highest usage 1st.

We need to be able to allow each customer to only see their data. Our Vendor is unable to set up hierarchal access to our Vendor dealer portal and give access to our customers.

We want to create a website based on Joomla CMS for our customers and give each an account with permissions in place to only allow access to their information. The new website would pull data from our Vendor portal

## Deliverables

**OVERVIEW**

Our customers need to see their data usage on a timely basis.

We buy the satellite services from a vendor and resell them to our customers.

Every 24 hours on our vendor dealer portal an excel file is available for us to download that shows the previous 24 hours inbound and outbound Byte usage for each of our customers. It is all on one sheet of one workbook with all the customers in a highest user sort order. Each line has the customers identifier and usage details.

We need to be able to allow each customer to only see their data. Our Vendor is unable to set up hierarchal access to our vendor dealer portal and give access to our customers.

We want to create a website based on Joomla CMS for our customers and give each an account with permissions in place to only allow access to their information.

We want the website to automatically ( Chron job ?) log into our vendor dealer portal every day at noon, navigate to that excel file and download it to a customer database.

The process would go something like this:

log in to https://xxxxxxxxxxxxxxxxxxx/[url removed, login to view]

user name: Xxxxxxxxx

password: Xxxxxxxxxx

after log in, on the left hand side click on "site manager"

next click on "usage reports".

next click on " top sites by usage"

in the drop down box set the number of days to 1

click on "get report"

on the right hand side is a button to download the info as an excel file. This is the file we want to use to propagate the new joomla site database from which our customers should only be able see their usage and no one elses.

A sample excel file like the one that is downloaded every 24 hours is attached.

Accounts are identified in the excel file by their "*function location* "an alphanumeric ID that always starts with 30055-XXXXXXXXXXX. When the website, after a download recognizes a new function location it needs to create that customer in the database and use his Function location as his user ID.

**For the user page:****

**

On 1st log in the customer should be able to see a bar graph that shows each days usage for the current week starting on Monday. the horizontal "x" axis should be the day, the vertical "Y" axis should be the amount used.

the customer, via drop down menus should be able to view anywhere from the past 1-90 days usage.

they should be able to view it either as a line item like on the spread sheet, a bar graph, a pie chart, or a line graph.

That same page should also show in a prominent fashion 5 boxes.

**Box #1** showing the customers allowed total inbound and outbound limits set by the admin in MB.

**Box # 2** showing The total inbound and total outbound used for the current week since Monday in MB.

**Box # 3** showing the total Inbound and outbound amounts remaining in MB for the week ending on Sunday.

**Box # 4** should show the inbound and outbound amount in MB they have gone over so far in the current week and what it would have cost them for the overage at 11 cents per MB..

**Box # 5** should show the inbound and outbound totals since the 1st of the month in MB along with the amount they may have gone over in any given Monday to Sunday week in MB.

The customer also needs to be able to set an alert e-mail that gets automatically sent to them. Customer should be able to enter the e-mail address they want for the alert and a trigger point for the e-mail based on percent. So for instance if the customer sets it to 80% they will get an e-mail when their weekly total exceeds 80% of the alloted bandwidth usage.

Customer also needs to be able to download anywhere from 1-90 days usage as an excel file.

**For the administrator:****

**

Set the total allotted weekly bandwidth usage for inbound and outbound for each customer in MB.

Get an auto generated e-mail when a customer goes over their weekly allotment.

Once a new account is detected on download from our vendor portal, notify the admin via e-mail so that they can go in and add contact info, set customer data limit variable's, send an e-mail to the customer with a generic password and inviting them to log in, change their password and view their data.

**Miscellaneous details**

We already have the domain name [[url removed, login to view]][1] and a hosting plan. We will give you FTP access. We can preload the latest version of Joomla or leave it to you. We want to use Joomla because we are already somewhat familiar with the back end admin side.

We want to keep it very very simple with as few pages as possible.

A log in page, the customers page, a FAQ page ( we will supply text ) and that's about it.

Feel free to steal graphics and the general feel of our website ([[url removed, login to view]][2]). We don't want anything fancy, no flash, no animation no fancy graphics just a plain layout that is easy for the customer. You can do all the work on the live server since no customer will be invited to it until the site is ready. We don't care about search engine optimization

This needs to be developed as a Joomla module or component so that it can easily be loaded into Joomla in the future should we need to.

We are very open to suggestions on how best to give our customers access to their data usage from our vendor portal without actually having to give them access to our vendor portal.

Habilidades: PHP

Ver mais: x-axis, www job on line, www e fashion com, www create a graph, www create account website com, which graph to use for data, when you don t get the job, what we need to create a website, what's the best job, what job sites actually work, what is job id, what is a general manager, what graph to use for data, website to create website for free, website optimization services, website new account, website about animation, want to create website free, want to create a chart, top job search sites, top graph, top animation website, the spread .com, the best joomla website, starting a new job is right

Acerca do Empregador:
( 6 comentários ) United States

ID do Projeto: #2970792

Premiar a:

samirkumardas

See private message.

$595 USD em 15 dias
(246 Avaliações)
7.0

10 freelancers estão ofertando em média $510 para este trabalho

macropaks

See private message.

$424.15 USD in 15 dias
(123 Comentários)
6.6
vishaygupta

See private message.

$680 USD in 15 dias
(48 Comentários)
5.9
antonyngo

See private message.

$340 USD in 15 dias
(15 Comentários)
5.6
qareaeu

See private message.

$85 USD in 15 dias
(7 Comentários)
5.5
webseoexpertsvw

See private message.

$764.15 USD in 15 dias
(6 Comentários)
2.9
zarish

See private message.

$510 USD in 15 dias
(9 Comentários)
2.9
Exp123

See private message.

$680 USD in 15 dias
(1 Comentário)
2.7
craigmiller22

See private message.

$340 USD in 15 dias
(0 Comentários)
0.0
guardianpressinc

See private message.

$680 USD in 15 dias
(3 Comentários)
0.0