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

[Chuck Bunn]

Hi,

A couple of questions... A clarification you are using the users voice 
mail password as the userid? Or am I misunderstanding the code. Short 
and sweat, nice code...

Thanks

Tilghman Lesher wrote:

>On Monday 26 September 2005 10:56, Chuck Bunn wrote:
>  
>
>>I have several clients interested in this application. The primary
>>has 40 nurses in the field and is having a hell of a time with time
>>cards. Using an automated system through the phone seems the best
>>way to meet her needs... If you have any other ways of doing this
>>please let me know...
>>    
>>
>
>http://bugs.digium.com/view.php?id=5055
>
>timeclock.sql:
>CREATE TABLE timeclock (
>	userid char(4) default '' not null,
>	timein integer,
>	timeout integer,
>	PRIMARY KEY (userid,timeout)
>);
>
>func_odbc.conf:
>[CLOCKIN]
>write=INSERT INTO timeclock (userid,timein) VALUES 
>('${ARG1}','${VAL1}')
>
>[CLOCKOUT]
>write=UPDATE timeclock SET timeout='${VAL1}' WHERE timeout IS NULL and 
>userid='${ARG1}'
>
>extensions.conf:
>exten => 9991,1,VMAuthenticate
>exten => 9991,2,Set(ODBC_CLOCKIN(${VM_AUTH})=${EPOCH})
>exten => 9991,3,Hangup
>
>exten => 9990,1,VMAuthenticate
>exten => 9990,2,Set(ODBC_CLOCKOUT(${VM_AUTH})=${EPOCH})
>exten => 9990,3,Hangup
>
>Voila!  Instant timeclock.
>
>  
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20050926/1ff0d5c6/attachment.htm