Sedang Disiapkan

MySQL database program

We have a telephone system that records call information into a mysql database. I need this information to be analyzed so we can spot trends etc. I would like to be able to display and print line graphs of calls taken and calls lost etc between two dates. Also be able to break down which how many each extension takes (theres only 3 extensions). I would also like reports automatically produced and emailed.

1) The shift reports that needs to be sent automatically following a schedule (which we can edit)

The email reports would need to give the details in text
e.g.
Date- From Time To Time
Total calls: 100 Total lost: 51
Ext 225: 50
Ext 227: 25
Ext 228: 25

then it would need a line graph displaying the same information embedded in the email.
I don't want a PDF, it's needs to be displayed so the person receiving it can't ignore it because they can't be bothered to open another program.

I also want a trigger to put a warning in the subject field when missed calls exceed a certain amount
(we need this amount to editable as an option)


2) The weekly report needs to sent out just in graph form which we will print out and store.
This will need to go to a different email address.

3) We then need a facilty to create a report at will.

We need to have the following choices.
By date range, including/excluding extension, including/excluding queues, answer/unanswered calls.
Outputting results by text / graphs /both.

Hope this helps you get a better idea of what we are after.

Kemahiran: Pemprosesan Data, Excel

Lihat lebih lanjut: program line, mysql database , lost excel, program graphs, data trends excel, display mysql, reports mysql , can program, database processing, telephone system, display program, theres, reports mysql database, calls database, print excel, program program excel, excel data mysql database, telephone data, database system excel, graphs excel, excel extension, database information, mysql database extension, data excel mysql, mysql display

Tentang Majikan:
( 10 ulasan ) Cheltenham, United Kingdom

ID Projek: #310033

Dianugerahkan kepada:

Arenabpo

Hello, we are web application experts, we can do this project, pls view PMB, Thank you!

$360 USD dalam 4 hari
(11 Ulasan)
5.0

34 pekerja bebas membida secara purata $436 untuk pekerjaan ini

asyraf1156

Hi.. I can do this program for you.. Please see Pm.. Thanks

$250 USD dalam 3 hari
(31 Ulasan)
5.0
becomeexpert

Easy job for me. Thanks, Tonmay

$500 USD dalam 7 hari
(22 Ulasan)
4.4
wincent

i can finish this work.

$500 USD dalam 5 hari
(6 Ulasan)
3.8
VisualTech585

Hi, I can help with this project. Please read PMB.

$750 USD dalam 14 hari
(1 Ulasan)
3.8
musaulker

I'm PHP-MySQL expert working over 5 years. I can do this job. I'm sending details in personal message..

$750 USD dalam 15 hari
(2 Ulasan)
3.7
majormf

i am ready

$300 USD dalam 6 hari
(2 Ulasan)
3.4
guruplus

Hi, Pls refer my PMB Regards Balaji

$250 USD dalam 5 hari
(3 Ulasan)
3.2
mjtk

Expert in LAMP, experience in additional open source tools which will yield a clean, functional, and robust system tailored to your needs. Please see PMB.

$750 USD dalam 14 hari
(1 Ulasan)
2.8
supweb

Hi, I have view your requirement ,it's clear, let me do it for you, we will provide quality [url removed, login to view] you!

$400 USD dalam 4 hari
(1 Ulasan)
2.4
megsoft

Please check your PMB

$350 USD dalam 7 hari
(2 Ulasan)
1.9
hendrolim

check PM please

$500 USD dalam 10 hari
(1 Ulasan)
1.0
mydearjani

I WILL DO IT FOR YOU AS SOON AS U CAN POSSIBLE

$500 USD dalam 5 hari
(0 Ulasan)
0.0
acumensofttech

Hello, Pls check pmb for more details. Thanks Sourav Acumen Soft Technologies

$750 USD dalam 25 hari
(0 Ulasan)
0.0
minhas760

Hi dear. We are willing to work on this job. Please! consider this bid and see pmb for further talk. Thank you.

$400 USD dalam 7 hari
(0 Ulasan)
0.0
restart

Please see the details in my PMB.

$600 USD dalam 10 hari
(0 Ulasan)
3.8
corinth24891

Corinth2489: Hi, I got your PM. Please send me the information from the MySQL database (the tables) or one of the CDR file (In my Broadsoft PABX experience, the machine produces CDR files which I need to analyze and Lagi

$250 USD dalam 30 hari
(0 Ulasan)
0.0
ciha

Please contact me. Thank you.

$350 USD dalam 14 hari
(0 Ulasan)
0.0
gthijs

Hello Sir/Madam, I work as a data typish in a big company for a few years. I know for sure to finish this kind of job correctly and fast. Please contact/email me. Thank you. Gthijs

$300 USD dalam 3 hari
(0 Ulasan)
0.0
rriahi

Dear Sir I have over 10 years of data manipulation and data mining experience. I would like to provide your company our high quality services. Please contact me for more details regarding tools and work methods. Lagi

$500 USD dalam 7 hari
(0 Ulasan)
0.0
cyberdocuments

Hi, I have gone over your RFP,Please Read My PMB for vital information regarding the bid

$500 USD dalam 15 hari
(0 Ulasan)
2.6