<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
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...<br>
<br>
Thanks<br>
<br>
Tilghman Lesher wrote:
<blockquote
cite="mid200509261457.18644.tilghman@mail.jeffandtilghman.com"
type="cite">
<pre wrap="">On Monday 26 September 2005 10:56, Chuck Bunn wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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...
</pre>
</blockquote>
<pre wrap=""><!---->
<a class="moz-txt-link-freetext" href="http://bugs.digium.com/view.php?id=5055">http://bugs.digium.com/view.php?id=5055</a>
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.
</pre>
</blockquote>
<br>
</body>
</html>