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
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 Daha Fazla
Bu iş için 16 freelancer ortalamada $78 teklif veriyor
Sir, there are more details required,we can do it, pls contact us via pm
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 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.
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
We are a group of professionals having more than 5 yrs [login to view URL] can do the work for you
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.
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
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.
The Web Artists, India's Leading Internet Presence Provider guarantess to work with you and offer 100% Satisfaction.
It will take me longer than most to complete the project but it will be created with care and thoroughly tested.