We need to have an internal billing programmed developed to charge our customers for phone calls they have made using our system.
The phone system provides us with detailed call records showing who made a call, to where, duration, cost and rate applied.
The data will be uploaded to the database each month from a .csv file.
The database will require a table(s) to store call detail records (from the upload) and another table to hold the using info (ref table, this will be manually update over time with new customer information) - I will provide the table design on project start.
A simple web interface to secure access to the program and database is required (username and password)
The main functions within the application will be:
1 – Upload call detail records from csv file (with specified validation – ie no duplicates, no missing fields)
2 – Run queries by user or by time period ( date range ) showing call detail records
3 – Add new Customers
4 – Set call rates for different call types ( ref table)
5 – Generate bills for each user for a given period (date range) Each bill will show detail call records sorted by date/time, total amount. The bill is then automatically emailed to the customer as a pdf.
18 freelance ont fait une offre moyenne de 386 £ pour ce travail
Hi, Thanks for posting the project on freelancer. I have gone through the requirement and I can do this project on time and with quality. Thanks Blueasso
Hello, Why you donćt want to use one of existing billing systems? For example www.freeside.biz. This system has all features you need. I can make a server for you based on this system.