GO HERE timeclock application

Status
Not open for further replies.

MyKroFt

Guru
Joined
Oct 31, 2008
Messages
659
Reaction score
3
Aparently it does not

over_time_hour I set to 40 in the config, but i think this setting means after what hr during the day is considered overtime.

Gonna have to see if I can modify the report to subtotal per week when running a Hours Worked Report
 

MyKroFt

Guru
Joined
Oct 31, 2008
Messages
659
Reaction score
3
The PhPTimeClock guys have released a 2.0 RC to play with - prob is - it requires a newer version of PHP than what comes with IAF - am I crazy to force a newer php version to the system - and if so - will it come crashing down on me?

Thanks for input...

Tony
 

stuck

Member
Joined
Nov 8, 2007
Messages
238
Reaction score
1
I have the http://192.168.1.4/phptimeclock/timeclock.php working, but having issues with the login page.

No user name or password works for me on the http://192.168.1.4/phptimeclock/login.php page.

ALL PRIVILEGES for user timeclock and for the database timeclock.

not sure what I'm doing wrong.

I am having the same problem, the instructions didn't include the default password. So I tried to change the admin password from the mysql database table for admin password to my own. But I can't log in with it.
What is the default password?

NM, the default user/passwd is admin/admin
 

sigmaz

Member
Joined
Dec 17, 2010
Messages
100
Reaction score
1
Does anyone still use this module?
I recently installed it and the browser version works great.

However when I call extension 8000 and enter my user info the system always says Im punching out but whats more is that if I put in invalid creds it still acts as if I'm a legit user.
I'm using the same db creds as the browser.. any help is greatly appreciated.

Here is an example transaction.. the Db connection seems funny..


-- Executing [8000@from-internal:3] Goto("SIP/701-00000008", "timeclock,s,1") in new stack
-- Goto (timeclock,s,1)
-- Executing [s@timeclock:1] Answer("SIP/701-00000008", "") in new stack
-- Executing [s@timeclock:2] Wait("SIP/701-00000008", "1") in new stack
-- Executing [s@timeclock:3] Read("SIP/701-00000008", "user,tm_userid,,,3,5") in new stack
-- <SIP/701-00000008> Playing 'tm_userid.gsm' (language 'en')
-- User entered '2828'
-- Executing [s@timeclock:4] NoOp("SIP/701-00000008", "2828") in new stack
-- Executing [s@timeclock:5] Wait("SIP/701-00000008", "2") in new stack
-- Executing [s@timeclock:6] Read("SIP/701-00000008", "pass,tm_pass,,,3,5") in new stack
-- <SIP/701-00000008> Playing 'tm_pass.gsm' (language 'en')
-- User entered '1234'
-- Executing [s@timeclock:7] NoOp("SIP/701-00000008", "1234") in new stack
-- Executing [s@timeclock:8] MYSQL("SIP/701-00000008", "Connect connid localhost root passw0rd timeclock") in new stack
-- Executing [s@timeclock:9] NoOp("SIP/701-00000008", "1") in new stack
-- Executing [s@timeclock:10] GotoIf("SIP/701-00000008", "0?error,1") in new stack
-- Executing [s@timeclock:11] MYSQL("SIP/701-00000008", "Query resultid 1 SELECT\ tstamp\ FROM\ employees\ WHERE\ empfullname=\2828\ AND\ employee_passwd\ =\ encrypt(\"1234\"\,\"xy\")") in new stack
-- Executing [s@timeclock:12] MYSQL("SIP/701-00000008", "Fetch fetchid tstamp") in new stack
-- Executing [s@timeclock:13] MYSQL("SIP/701-00000008", "Clear ") in new stack
-- Executing [s@timeclock:14] NoOp("SIP/701-00000008", "") in new stack
-- Executing [s@timeclock:15] GotoIf("SIP/701-00000008", "0?fail:next") in new stack
-- Goto (timeclock,s,18)
-- Executing [s@timeclock:18] NoOp("SIP/701-00000008", ""moving On"") in new stack
-- Executing [s@timeclock:19] NoOp("SIP/701-00000008", "") in new stack
-- Executing [s@timeclock:20] Set("SIP/701-00000008", "stat="in"") in new stack
-- Executing [s@timeclock:21] GotoIf("SIP/701-00000008", "0?initial") in new stack
-- Executing [s@timeclock:22] MYSQL("SIP/701-00000008", "Query resultid 1 SELECT\ info.inout\ FROM\ info\ WHERE\ fullname=\2828\ AND\ timestamp=\") in new stack
-- Executing [s@timeclock:23] MYSQL("SIP/701-00000008", "Fetch fetchid inout") in new stack
-- Executing [s@timeclock:24] MYSQL("SIP/701-00000008", "Clear ") in new stack
-- Executing [s@timeclock:25] NoOp("SIP/701-00000008", "") in new stack
-- Executing [s@timeclock:26] Set("SIP/701-00000008", "stat=") in new stack
-- Executing [s@timeclock:27] NoOp("SIP/701-00000008", "") in new stack
-- Executing [s@timeclock:28] NoOp("SIP/701-00000008", "initial login") in new stack
-- Executing [s@timeclock:29] MYSQL("SIP/701-00000008", "Query resultid 1 SELECT\ unix_timestamp( utc_timestamp( ) ) ") in new stack
-- Executing [s@timeclock:30] MYSQL("SIP/701-00000008", "Fetch fetchid time") in new stack
-- Executing [s@timeclock:31] MYSQL("SIP/701-00000008", "Clear ") in new stack
-- Executing [s@timeclock:32] NoOp("SIP/701-00000008", "") in new stack
-- Executing [s@timeclock:33] NoOp("SIP/701-00000008", ""CallerID is "701") in new stack
-- Executing [s@timeclock:34] MYSQL("SIP/701-00000008", "Query resultid 1 UPDATE\ employees\ SET\ tstamp=\'\\'\ WHERE \empfullname=\2828") in new stack
-- Executing [s@timeclock:35] MYSQL("SIP/701-00000008", "Clear ") in new stack
-- Executing [s@timeclock:36] MYSQL("SIP/701-00000008", "Query resultid 1 INSERT\ INTO\ info\ SET\ fullname=\'\2828\'\, info.inout=\'\\'\, timestamp=\'\\'\, ipaddress=\'\701\'\") in new stack
-- Executing [s@timeclock:37] MYSQL("SIP/701-00000008", "Fetch fetchid ") in new stack
-- Executing [s@timeclock:38] MYSQL("SIP/701-00000008", "Clear ") in new stack
-- Executing [s@timeclock:39] GotoIf("SIP/701-00000008", "0?in:eek:ut") in new stack
-- Goto (timeclock,s,42)
-- Executing [s@timeclock:42] Playback("SIP/701-00000008", "tm_clocked_out") in new stack
-- <SIP/701-00000008> Playing 'tm_clocked_out.gsm' (language 'en')
-- Executing [s@timeclock:43] Goto("SIP/701-00000008", "done") in new stack
-- Goto (timeclock,s,44)
-- Executing [s@timeclock:44] NoOp("SIP/701-00000008", ""Connection ID is "1") in new stack
-- Executing [s@timeclock:45] NoOp("SIP/701-00000008", ""Result ID is "") in new stack
-- Executing [s@timeclock:46] Wait("SIP/701-00000008", "1") in new stack
-- Executing [s@timeclock:47] MYSQL("SIP/701-00000008", "Clear ") in new stack
-- Executing [s@timeclock:48] MYSQL("SIP/701-00000008", "Disconnect 1") in new stack
-- Auto fallthrough, channel 'SIP/701-00000008' status is 'UNKNOWN'
-- Executing [h@timeclock:1] MYSQL("SIP/701-00000008", "clear ") in new stack
-- Executing [h@timeclock:2] MYSQL("SIP/701-00000008", "disconnect 1") in new stack
 

jmullinix

Guru
Joined
Oct 21, 2007
Messages
1,263
Reaction score
7
What version of Asterisk are you using? When Ed and I wrote the dialplan for the phpTimeClock application, we were using Asterisk 1.4. We haven't updated it since then.
 
Joined
Apr 17, 2009
Messages
829
Reaction score
9
I'd love to use this on my newer system:D

it would help out a lot for my techs.

Something I see that could benefit this would be that the people would say login to the time clock app, and also punch in a employee number, and say a work order number and then if they needed to login with someone else say a vendor, then the system would give the option to have them connect to that vendor and they could be connected to them directly.


just a thought..
 

sigmaz

Member
Joined
Dec 17, 2010
Messages
100
Reaction score
1
I'm using 1.8.5 and I thought I had it on the run but I gave up and went home.

Dahdi, Dundi, Seg Faults and all the other hurdles Ive gotten over you'd think I'd fight this one to the end.
 

sigmaz

Member
Joined
Dec 17, 2010
Messages
100
Reaction score
1
Sounds like you'll be doing some AGI developing in the near future.
 

MyKroFt

Guru
Joined
Oct 31, 2008
Messages
659
Reaction score
3
their newer version of the software has gone commercial and is only avail as a hosting service.

You cant even download the old version anymore..... :(

Myk
 

sigmaz

Member
Joined
Dec 17, 2010
Messages
100
Reaction score
1
I took the initiative to poke around a little more.. It turns out that I was able to get it working properly.

If you look at the logs from my original post you can see the problem when it echo's the execution of the command.

Now I know I'm no SQL coder and I think I've heard of a reason to insert \'s in your queries.. But I can't remember why and in my case they caused the lookup's and insertions to fail.
I think it had something to do with quotes or breaking out of a quote?

Anyway, I removed all the extra \'s and the queries ran just fine.

one example:

exten => s,n,MYSQL(Query resultid ${connid} SELECT\ info.inout\ FROM\ info\ WHERE\ fullname=\${user}\ AND\ timestamp=\${tstamp})

to

exten => s,n,MYSQL(Query resultid ${connid} SELECT info.inout FROM info WHERE fullname=${user} AND timestamp=${tstamp})

I'm now able to punch in and out without any trouble from the extensions.

I'm not sure if I just opened myself up for attack or whatever.. But I do know my timeclock app works now
 

helbda

New Member
Joined
Jan 5, 2012
Messages
2
Reaction score
0
I have phptc3.0.3.zip if anyone is interested. It appears I just happened to download one of the last freely released versions about a year ago when I was needing to set up such an application.
I didn't realize it until I migrated web servers and needed to reinstall the app. All I could find on the web was phptimeclock1.0.4 and that one is just a pain!
If anyone wants it just post a reply and I will throw it into dropbox public for all.
 

TheShniz

Guru
Joined
Nov 15, 2007
Messages
560
Reaction score
2
Yes, I'm interested... haven't ever been asked for this application (yet), but would definitely like it 'on file' (heh)!
 
Status
Not open for further replies.

Members online

Forum statistics

Threads
25,782
Messages
167,509
Members
19,203
Latest member
frapu
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.
Top