Shaikh Sonny Aman’s Blog

previously www.mailtoaman.com

Lightwieght VOIP billing software using mysql,servlet and ajax

Posted on | July 7, 2008 |

Though I don’t like to do extra work beside my day job, but there are some people (and some offer :P)  whom I don’t like to refuse. Surely the work must be interesting.

Before some days,  one of my ex bosses gave a project to build a VOIP billing software. I was studying SIP protocol for a while and the offer seemed very interesting.

The task was simple though. It will just show the call history mainly.  But the challenge was to make it as light weight as possible and secondly there is no documentation about the data!

The reason behind making it light weight  is that the application will be hosted on the switch, i.e. the web server is running on the switch box. Well, I decided to use no flashy look at all, used plain css just the login prompt is made of ext-js. The pagination appears on top right is also ajax based.

Main problem was to find out the data. I have been given the credential to log on to the mysql server but they could not provide any information which table contains which data. The database was complex enough with more than 60 tables and the designer seemed to take extra care to put redundant data on different tables with similar name like “clients”,”client164″,”clientinfo” etc. And guess what, the actual log in infromation is in client164 table :P

Here are some screen shots:

Login page

Connecting in progress

Call log

Category: Ajax, Freelancing, JavaScript, PHP, jQuery, mysql, myworks

Comments

4 Responses to “Lightwieght VOIP billing software using mysql,servlet and ajax”

  1. Hasin
    July 10th, 2008 @ 2:48 am

    Aman

    Nice work! Sometime I really feel how challenging these instant rnd projects are. You must have enjoyed? SIP is a great protocol

  2. Shaikh Sonny Aman
    July 10th, 2008 @ 3:02 am

    Thanks hasin bhai for you inspiration.
    I enjoyed it :) it was given by my first ever country manager
    Tareq bhai of Cention AB.

  3. Naseer Ahmad Mughal
    August 23rd, 2008 @ 4:59 pm

    Nice project brother,

    i can not see the screen shots that you place in post. How can i see them?

    regards,

  4. admin
    August 25th, 2008 @ 10:56 am

    unfortunately my previous hosting provider goofed up my space :( and I lost all the images…

    Thank you for visiting my pages.

Leave a Reply