Asterisk setup, some AGI & PHP scripting

I am running a commercial website and would need to track phone calls via it so I can optimize my PPC ad spending. The project is implementing this in a straightforward way. ** ** **Skills required: Knowledge of Asterisk, AGI scripting, PHP or Python, and basic SQL.** The process: I have a toll-free phonenumber that's routed to my Asterisk via SIP. Asterisk is running on a VServer. Site visitors are shown a phone number on my website that they can call to place an order - it's the above no plus a two digit extension. Those 2 digits ? should be randomly generated by a PHP or Python script when it is called from my website, passing some variables via HTTP Get.? It stores the variables alongside the extension in a mySQL DB. Once the extension is called, an AGI script accesses an external tracking URL and flags the data set as "converted". Your job is setting up Asterisk to take calls from that no and signal it at a local SIP account of my choice, as well as implementing these features. ## Deliverables **Project details - read thoroughly before placing a bid. Thanks!** ** ** Technical platform: Asterisk 1.6.2.6 on a Ubuntu VServer, compiled, running, but ? not configured yet Apache2, PHP, safe_mode off., mySQL 14.12 **Detailed functions you need to implement** ** ** **a) Configure Asterisk** -it has to take calls at my service no. The number is currently routed via SIP to the VServer's IP address. Asterisk has to take the call,? -signal it at an extension which I will use for my local VoIP / SIP phone (behind NAT) -I need to be able to forward the calls to a different number at times. I have a SIP account for the outgoing calls with a local provider. -set up a system that processes the last two digits appended to the no ? (my routing provider passes the full dialed no), and implement AGI scripts that call an external tracking website as well as your handler scripts for the data storage as outlined in b) **b) Website scripting** -Write a script that is called as an image from my website, passing along some variables via HTTP Get, like Google ads keyword, or user agent (all type "string"). When called, it allocates an extension exclusively, sets a cookie for two days so it doesnt generate a new extension for every reload / different page, stores the data in mySQL, and returns an image with the complete number for display to the user.? If this extension is called, the data set gets flagged as "converted" (say, by a boolean field in the DB), and the extension is freed again. If you have a better idea than the image-based system, it can also be done otherwise after contacting me. -Write a component that either periodically or by user "pull" checks for non-converted mySQL data sets older than two days, and purges them to free the number pool. -Write a simple display script that shows a) all currently allocated extensions and the associated data and b) all "converted" data sets & associated data. Doesn't need user controls for now. That's it! I am looking forward to working with you! Also, this is only phase one of the project, so there should be follow-up orders for you if I'm satisfied with your work. Don't hesitate to ask questions you may have about the project.? Please note that you need to be able to demonstrate your qualification before placing a bid. This can either be rentacoder customer feedback related to stuff needed for this project, work samples, or copies of certificates you may hold. Thanks for taking the time, and happy bidding!