We use a program called Panalog for logging call data from our Panasonic PBX. The program logs all data into an Access database.
I need a web app that will pull the data from the database and allow me to run reports based on extension, username, total talk time, total number of dials, gaps in talk time, and any other custom searches and reports management needs.
I already have a connection script to the database, and some simple queries I had help creating on [login to view URL], but I am just not learning fast enough and need this done soon.
I know it's not going to be that big of a job for a php guru, so that's who I am hoping for. I will provide connection script, database and current queries as needed. Thanks for the bids!
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows :
a) All code should just be able to be dropped onto my web server and run without any configuration on the cliant's side (aside from styles which should be in css format to be edited by the custiomer)
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
**Extra Information about what I am requesting: (UPDATED)**
What I am hoping for is a main page that contains a summary with charts and table data that displays overall call totals by extension and date. So something like my sample page with extensions and names, their total talk time, and total calls per day, hour, week month, and gaps in call data. As well as usage by line (trunk).
Then there should be another page for extension data. This page would have a list along the side or top displaying the extension and user name. When the name or ext is clicked, it should display a usage report on the page containing all the same reports as the main page, and have an option to filter by date, time, date range, week, week range, month, month range, etc. or to show an overall summary of that extension's usage.
Then I would like a search box that will handle almost all of the other queries and spit out the data/reports. Something that will allow any single or ranged criteria to be queried and reported on.
For example. If I want to know how many times a certain number was called at an extension, weather it was incoming, or outgoing, on a single day or during a range of days, I want to be able to query that. A more complex query that needs to take place would be to select more than one extension or groups of extensions and compare the usage (total talk time, total number of calls, total local calls, long distance calls, calls broken down by state (Zip Code) and data broken down by hour in 5/15/30 min increments.
So we will need to have a table of extension codes and the city/state they apply to (which I think I might have somewhere if you need it).
Keep in mind also that I will want to be able to edit the name associated with the extension, and maybe have a notes field for each call or report. Also I would like to group the extensions or users into separate departments so I can have departmental reports for specific managers.
That's all I can think of right now. I did not sit down and plan out everything I need to have it do, I was thinking I would work on that with a coder, but I can see I need to have some specifics on my side, so I will get with the management that will be using this on a daily basis and get their input on EXACTLY what they want.
Also, this will need to be secure, so I need to have a log in area, and be able to add/edit/delete users and access levels. If at all possible (I'm not sure it is) but I would like to automatically allow them access if they are logged in as one of the users in the Management group in Active Directory. I do not know if it's possible, but it would be really cool!! Not a need to have, don't spend to much time on it if it's not easy to do, I don't need to have it if it's going to significantly raise the cost of the project.
## Platform
IIS 6.0 on MS Server 2003 with PHP 5.2.4 and MySQL.
If you know of a way to link the database to a mysql database and run all the queries against that, it is a possability, as I am running MySQL on the serer for other apps.
**Updated:
**
The databse is running on the same machine as the web server (although this might change).
I cannot access the database while I am logging call data, so I am copying it (every 5 min) to a shared location on the web server and running queries on it there.