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
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
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.
We already have the domain name [[url removed, login to view]] 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]]). 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.