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
16 freelancers are bidding on average $78 for this job
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,
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.
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
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.