Devam Ediyor

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



Beceriler: PHP

Daha fazlasını gör: 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

İşveren Hakkında:
( 5 değerlendirme ) Wuerzburg, Germany

Proje NO: #5601



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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(2 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(35 Değerlendirme)

We can do it. Regards

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(43 Değerlendirme)

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,

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(50 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Let's do it

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde95%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Latest project: [login to view URL]

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)