[Asterisk-Dev] Open source time card application for Asterisk

[Mike Clark]

Chuck Bunn wrote:

> Joseph wrote:
>
>>On Fri, 2005-09-23 at 09:34 -0600, Chuck Bunn wrote:
>>  
>>
>>>Hi,
>>>
>>>I am in the process of developing a time card application that 
>>>integrates with Asterisk and I would like to know if anyone has done 
>>>this and if so can you recommend an open source time card application 
>>>that might reduce the amount of work required to connect it to Asterisk. 
>>>I do not want to reinvent the wheel and write a WEB based time card app, 
>>>I would rather spend my time getting Asterisk to connect to it. I will 
>>>be using LAMP so it will be written in PHP instead of C...
>>>
>>>Thanks
>>>    
>>>
>>
>>Do you mean employee time-card? With mysql database this would be very
>>interesting project.
>>Do you have a short description of what it would do?
>>
>>  
>>
> Hi,
>
> Thanks for responding. The basic system would work as follows. An 
> employee would call in and would transfer to a menu (either via an 
> operator or via the phone system if no operator is available). 
> Something like press 1 for sales and service press 2 for accounting 
> and press 3 if you are an employee. Upon pressing three the user would 
> be asked to enter their employee ID and password. The system would 
> capture the employee ID , time of day and if available the caller ID 
> from the location they are calling from. When they are finished they 
> would repeat the process thus capturing the finish data for filling 
> out a time card. The usage is a group of field nurses that need an 
> easy way to enter data into there time cards since the Internet is not 
> always available from the locations they call from. Although the 
> caller ID can easily be spoofed this is not as important as capture of 
> the time and employee data for filling out a time card. A second 
> application uses the same theory but for janitors. The caller ID helps 
> confirm they are where they are supposed to be. There are several PHP 
> time cards out there but I am trying to find the best for interfacing 
> with Asterisk. Phase one would be to capture the data to a flat file 
> phase 2 would be to get it into a database, phase three would 
> interface it to an existing LAMP based time card apt and phase 4 would 
> allow for phone access to information stored in the time card such as 
> how many hours worked, hours by day etc. A final phase would interface 
> these to both Peachtree and Quickbooks.

I would skip phase 1 and go to at least phase 2. Integrating MySQL or 
Postgres in phpagi is just about as easy as dealing with flatfiles.