Sedang Disiapkan

need a small csv parsing an billing tool

hello, i am running a callcenter and need a billing tool which calculates how much money a customer has to pay for using my callcenter.

from my phone provider i get an itemised bill (you can see in the attachment). the csv has the following fields:

phone number of caller;toll free-service phone number called;destination number;date of call;time of call;duration of call;result of call;call was picked up? J=YES N=NO

every customer of mine gets his own service phone number (0800999111800-0800999111899) - so i have total of 100 numbers.

for every customer (for every service number) i want to define in a mysql-db:

a) monthly fee for each number he has (e.g. 5 EUR)

b) connection fee, for a picked a call of my call center (e.g. 0,50 EUR)

c) rate per minute (e.g. 0,80 EUR per minute for paying the agent)

d) billing increment for the first minute and for the rest e.g. 60/30 means the first minute of a call is always counted as 60 seconds even if the call lasted only 45 seconds, the next minute is splited in 30 secods. so if a call is 65 secods long the call should be billed as if was 90 seconds long. (if was longer than 60 seconds so the next step are 30 seconds, 60+30=90 seconds)

e) additional charges if the call comes from a mobile phone (numbers beginning with 017XXX or 016XXX in germany) e.g. (0,30 EURs extra)

as currency it should calculate in euro

what i want you to do is to write a program which

a) calculates how much money a customer has to pay for using the call center and write those data in a seperate table in mysql-db

b) generate a text itemised bill with only 1 service phone number and with a detailed list how much every call costs, how long it was, where the call came from and so on. (so that the customer understands the bill)

c) sum up all calls for every service number the calculate the final price

another nice feature would be that the customer could log in on a web-page and see how much phone costs he already spent this month (so you could add a password field in mysql-db) and the customer can login with his service-number and a password to see all calls online.

i want to import the cdr (call data records) hourly, i can download it from a web-page so your tool should not be confused if a import the call data records very often.

the description is long but the program should be made quickly.

i want to have it written in php with mysql-support...

please make some offers

thanks

martin

Kemahiran: PHP

Lihat lebih lanjut: table customer, phone call center hourly, pay rate for customer service, online service offers, money on table, i want to write online for money, i want to have a call center, i need a call center, how to make some money online for free, get a phone number for support, g. e. money, free calls online, do not call phone number, define hourly, currency table rate, currency table list, currency rate table, call center service provider, call center rate per minute euro, call center price per minute, call center price per call, call center pay rate, call center number, call center list, call center germany price

Tentang Majikan:
( 5 ulasan ) Wuerzburg, Germany

ID Projek: #5601

Dianugerahkan kepada:

mafi

Hello Martin, what you need sounds like a billing system which could be build very easy. Seems you are only getting inbound calls, what about the outbound calls. There are some other problems in your project desc Lagi

$20 USD dalam sehari
(2 Ulasan)
0.6

16 pekerja bebas membida secara purata $78 untuk pekerjaan ini

siddhartha1

Sir, there are more details required,we can do it, pls contact us via pm

$100 USD dalam 12 hari
(35 Ulasan)
7.6
raduc

We can do it. Regards

$80 USD dalam 2 hari
(43 Ulasan)
5.8
auraspan

Greetings, I've over 7years of extensive website development experience and can accomplish the said goals with ease. Looking forward to a positive reply. Regards,

$100 USD dalam 5 hari
(50 Ulasan)
5.7
HarrisConsulting

Sounds simple enough to do, contact me via pmb and we can discuss how you want to proceed with this, it's kind of similar to a job I done here before for another customer.

$75 USD dalam sehari
(11 Ulasan)
5.2
ispg

We always make you cheer!! :) Please see PMB

$75 USD dalam 3 hari
(3 Ulasan)
4.3
WhiteRabit

I can write such a system for you. Have plenty of experience parsing csv. $100 bid is the absolute lowest I will accept for writing this code.

$100 USD dalam 3 hari
(3 Ulasan)
3.9
qweb

I am interested in your project,I have checked all your requirement, I will give you the best solution in PHP/MySQL/Linux. Please open a private message board for further discussion. Thanks

$90 USD dalam 2 hari
(1 Ulasan)
3.9
gunjankvel

We are a group of professionals having more than 5 yrs [url removed, login to view] can do the work for you

$50 USD dalam 5 hari
(2 Ulasan)
3.1
vps

I'll create script in PHP that will parse and process all your data. You will have two mysql tables and textual report for the clients.

$80 USD dalam 2 hari
(0 Ulasan)
0.0
jmiguely

I am graduating this fall trying to build up my resume. Give me a chance. If you do not liek what I have done, I give it to you for free

$25 USD dalam 2 hari
(0 Ulasan)
0.0
manusarkar

sir, i just finished a project for vandana export group requiring the same thing as you are demanding. So, i am now conversent with all technical details of a billing project. i will enjoy to work on your project.

$100 USD dalam 15 hari
(0 Ulasan)
0.0
mosh

Let's do it

$80 USD dalam sehari
(0 Ulasan)
0.0
thewebartists

The Web Artists, India's Leading Internet Presence Provider guarantess to work with you and offer 100% Satisfaction.

$100 USD dalam 2 hari
(0 Ulasan)
3.1
WidnesViking

It will take me longer than most to complete the project but it will be created with care and thoroughly tested.

$95 USD dalam 10 hari
(0 Ulasan)
0.0
speedinsure

Latest project: [url removed, login to view]

$75 USD dalam 15 hari
(0 Ulasan)
0.0