Extra days in this weeks timesheet.

[dhirsh]

I have the following problem timetrex has decided to extend this week into next. our normal week ends on fri and starts on sat. It has included sat. in the current week. below you will find the details on what is happening but it appears to be a time problem in the end of the week.
It is strange that this happened the week that DST started our time zone is
CST/CDT.
We do not use the Tax tables and are running on aix which seems to be a problem and causes a great deal of trouble upgrading so that unless there are good reasons I would prefer not to up grade at the present time.
The test machine that I use to check the code is running on an fedora core 8 and it has the same problem as production.
I will be happy to supply any other data that
your require
Thanks
Doug



Timetrex info
timetrex professional version 2.0.2
php version PHP 5.2.4
aix 5.3

Schema Version
Group A: 1013A
Group B: 1014B
Group T: 1004T
our pay periodes end on the 15th and the last day of the month.
transaction dates are on the 1 and the 16th
This weeks time sheets are displaying the week the 15th which is in the next week plus 6 blank days.
as below.
Branch: Dept: Employee: Add:
Date: Pick a date
View Schedule Print Timesheet Sat Sun Mon Tue Wed Thu Fri Sat
Mar 8 Mar 9 Mar 10 Mar 11 Mar 12 Mar 13 Mar 14 Mar 15
Accumulated Time
Total Time 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00
Pay Period: 01-Mar-08 to 15-Mar-08

It appears that the week end day had an hour added to it I don't know that caused this but it
appears that one hour was added to the 15-Mar-08 entry when the begin week was called.

This is the debug information from the screen build routine if you check the marked
line in TTDate::getBeginWeekEpoch() below it appears that it used 12:59 AM instead of 11:59 PM
which is what it did on the week before and after this.




Debug Buffer
============================================================================
Memory Usage: 4071584
----------------------------------------------------------------------------
DEBUG [205]: [Function](): URI: /timetrex/interface/timesheet/ViewUserTimeSheet.php?filter_data[user_id]=138&filter_data[date]=1205816400&filter_data[group_ids]=-1&filter_data[branch_ids]=-1&filter_data[department_ids]=-1&prev_week=1
DEBUG [207]: [Function](): Production: 1
DEBUG [491]: Authentication::Check(): Session Name: SessionID
DEBUG [497]: Authentication::Check(): Session ID: 2d17aafba81f9a90dfc7ec5dc232fd18
DEBUG [302]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:2d17aafba81f9a90dfc7ec5dc232fd18
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [302]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:2d17aafba81f9a90dfc7ec5dc232fd18
DEBUG [67]: [Function](): User Authenticated: dhirsh Created Date: 1205252275
DEBUG [1689]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: CST6CDT
DEBUG [129]: TTDate::setDateFormat(): Setting Default Date Format: d-M-y
DEBUG [143]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A
DEBUG [157]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 10
DEBUG [98]: [Function](): Locale Cookie: en_US
DEBUG [235]: TTi18n::getLanguageFromLocale(): Locale: en_US
DEBUG [106]: [Function](): User Preference Language matches cookie!
DEBUG [270]: TTi18n::setLocale(): Attempting to set Locale to: en_US Category: 6 Current Locale:
DEBUG [273]: TTi18n::setLocale(): Attempting to set Locale to: en_US
DEBUG [287]: TTi18n::setLocale(): Setting translator normalized locale to: en_US
DEBUG [305]: TTi18n::setLocale(): Set Locale To: en_US
DEBUG [1689]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [1094]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete:
DEBUG [134]: [Function](): Station ID Cookie found! a50b33b12a89aa081992f70c2cfc2e4c
DEBUG [241]: [Function](): UnRead Messages: 0
DEBUG [116]: [Function](): Found Default Filter!
DEBUG [54]: FastTree::__construct(): Contruct...
DEBUG [60]: FastTree::__construct(): Setting Table to: user_group_tree
DEBUG [77]: FastTree::setTree(): Setting Tree ID to: 1
DEBUG [116]: FastTree::getNode(): Object ID: 0
DEBUG [98]: FastTree::_setupTree(): NOT Initiating Tree with Root object:
DEBUG [327]: FastTree::getAllChildren(): Object ID: Recurse: RECURSE
DEBUG [336]: FastTree::getAllChildren(): Getting Root ID: 0
DEBUG [116]: FastTree::getNode(): Object ID: 0
DEBUG [345]: FastTree::getAllChildren(): Left ID: 0 Level: 0
DEBUG [176]: [Function](): Viewing all users timesheet
DEBUG [302]: TTDate::parseDateTime(): String: 1205816400 Date Format: d-M-y
DEBUG [395]: TTDate::parseDateTime(): NO Custom Parse Format detected!
DEBUG [398]: TTDate::parseDateTime(): Parsing Date: 1205816400
DEBUG [145]: Validator::isLength(): Value: Default Length: 7 Min: 1 Max: 100
DEBUG [145]: Validator::isLength(): Value: /timetrex/interface/timesheet/ViewUserTimeSheet.php Length: 51 Min: 1 Max: 250
DEBUG [727]: Factory::isValid(): Calling Validate()
DEBUG [710]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0
DEBUG [756]: Factory::Save(): Calling preSave()
DEBUG [169]: UserGenericDataFactory::preSave(): Removing Default Flag From: 98
DEBUG [727]: Factory::isValid(): Calling Validate()
DEBUG [710]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [756]: Factory::Save(): Calling preSave()
DEBUG [727]: Factory::isValid(): Calling Validate()
DEBUG [799]: Factory::Save(): Updating...
DEBUG [624]: Factory::getUpdateQuery(): Update
DEBUG [257]: Validator::isDate(): Raw Date: 1205254625 Converted Value: 1205254625
DEBUG [655]: Factory::getUpdateQuery(): Data changed, set updated date:
DEBUG [106]: Validator::isNumeric(): Value:98
DEBUG [94]: Validator::inArrayKey(): Key: 20
DEBUG [145]: Validator::isLength(): Value: user_generic_data Length: 17 Min: 2 Max: 250
DEBUG [145]: Validator::isLength(): Value: Employee/Company Generic Data Length: 29 Min: 2 Max: 2000
DEBUG [710]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 1 Trans Off: 2
DEBUG [756]: Factory::Save(): Calling preSave()
DEBUG [257]: Validator::isDate(): Raw Date: 1205254625 Converted Value: 1205254625
DEBUG [786]: Factory::Save(): Insert ID: 82192
DEBUG [692]: Factory::getInsertQuery(): Insert
DEBUG [720]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 3
DEBUG [720]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 2
DEBUG [727]: Factory::isValid(): Calling Validate()
DEBUG [799]: Factory::Save(): Updating...
DEBUG [624]: Factory::getUpdateQuery(): Update
DEBUG [257]: Validator::isDate(): Raw Date: 1205254625 Converted Value: 1205254625
DEBUG [655]: Factory::getUpdateQuery(): Data changed, set updated date:
DEBUG [106]: Validator::isNumeric(): Value:98
DEBUG [94]: Validator::inArrayKey(): Key: 20
DEBUG [145]: Validator::isLength(): Value: user_generic_data Length: 17 Min: 2 Max: 250
DEBUG [145]: Validator::isLength(): Value: Employee/Company Generic Data Length: 29 Min: 2 Max: 2000
DEBUG [710]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [756]: Factory::Save(): Calling preSave()
DEBUG [257]: Validator::isDate(): Raw Date: 1205254625 Converted Value: 1205254625
DEBUG [786]: Factory::Save(): Insert ID: 82193
DEBUG [692]: Factory::getInsertQuery(): Insert
DEBUG [720]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 2
DEBUG [720]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [272]: [Function](): bPay Period Lookup:
DEBUG [293]: [Function](): Pay Period ID: 66
DEBUG [305]: [Function](): Action:
DEBUG [48]: BreadCrumb::setCrumb(): Dropping Bread Crumb: My Timesheet URL: /timetrex/interface/timesheet/ViewUserTimeSheet.php?filter_data[user_id]=138&filter_data[date]=1205816400&filter_data[group_ids]=-1&filter_data[branch_ids]=-1&filter_data[department_ids]=-1&prev_week=1
DEBUG [411]: [Function](): Default Action:
DEBUG [1113]: TTDate::getBeginWeekEpoch(): Epoch: 11-Mar-08 12:00 AM Retval: 08-Mar-08 12:00 AM Start Day of Week: 6 Offset: 3
DEBUG [1113]: TTDate::getBeginWeekEpoch(): Epoch: 11-Mar-08 12:00 AM Retval: 08-Mar-08 12:00 AM Start Day of Week: 6 Offset: 3
DEBUG [416]: [Function](): Start Date: 08-Mar-08 12:00 AM End Date: 15-Mar-08 12:59 AM
DEBUG [1239]: TTDate::getCalendarArray(): Start Day Of Week: 6
DEBUG [1241]: TTDate::getCalendarArray(): Raw Start Date: 08-Mar-08 12:00 AM Raw End Date: 15-Mar-08 12:59 AM
DEBUG [1113]: TTDate::getBeginWeekEpoch(): Epoch: 08-Mar-08 12:00 AM Retval: 08-Mar-08 12:00 AM Start Day of Week: 6 Offset: 0
-->DEBUG [1113]: TTDate::getBeginWeekEpoch(): Epoch: 15-Mar-08 12:59 AM Retval: 15-Mar-08 12:00 AM Start Day of Week: 6 Offset: 0
DEBUG [1252]: TTDate::getCalendarArray(): Cal Start Date: 08-Mar-08 12:00 AM Cal End Date: 21-Mar-08 11:59 PM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1204956000 Date: 08-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205042400 Date: 09-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205125200 Date: 10-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205211600 Date: 11-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205298000 Date: 12-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205384400 Date: 13-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205470800 Date: 14-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205557200 Date: 15-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205643600 Date: 16-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205730000 Date: 17-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205816400 Date: 18-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205902800 Date: 19-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1205989200 Date: 20-Mar-08 12:00 AM
DEBUG [1317]: TTDate::getCalendarArray(): i: 1206075600 Date: 21-Mar-08 12:00 AM
DEBUG [585]: [Function](): No Punch Count: 13 Max: 28
DEBUG [585]: [Function](): No Punch Count: 13 Max: 28
DEBUG [585]: [Function](): No Punch Count: 27 Max: 28
DEBUG [585]: [Function](): No Punch Count: 41 Max: 28
DEBUG [589]: [Function](): Stopping Loop at: 3
DEBUG [599]: [Function](): Popping Off Last TWO Row: 3
DEBUG [39]: TimeSheetFormatArrayByDate(): Group Array While Loop:
DEBUG [79]: TimeSheetFormatArrayByDate(): No Punch Count: 13 Max: 14
DEBUG [79]: TimeSheetFormatArrayByDate(): No Punch Count: 14 Max: 14
DEBUG [81]: TimeSheetFormatArrayByDate(): Stopping Loop at: 1
DEBUG [1224]: UserDateTotalListFactory::getWorkedTimeSumByUserIDAndPayPeriodId(): Total:
DEBUG [1171]: [Function](): Worked Total Time: 0
DEBUG [1304]: UserDateTotalListFactory::getPaidAbsenceTimeSumByUserIDAndPayPeriodId(): Total:
DEBUG [1174]: [Function](): Paid Absence Total Time:
DEBUG [1388]: UserDateTotalListFactory::getDockAbsenceTimeSumByUserIDAndPayPeriodId(): Total:
DEBUG [1177]: [Function](): Dock Absence Total Time:
DEBUG [1232]: [Function](): Pay Period Object Found!
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 26.5639 ms (6.64 %) Authentication::Check()
1 5.5518 ms (1.39 %) Interface.inc - Check for Exceptions
1 9.5270 ms (2.38 %) Interface.inc - Check for UNREAD messages...
13 20.7884 ms (5.19 %) getEmptyRecordSet()
1 6.0570 ms (1.51 %) getPermissionHierarchyChildrenByCompanyIdAndUserId
1 231.7121 ms (57.88 %) unprofiled

100.1527 ms (25.02 %) Missed
============================================================================
400.3530 ms (100.00 %) OVERALL TIME
=========================================================================

[shaunw]

Please upgrade to TimeTrex v2.2.7, it fixes this issue.

v2.0.2 of TimeTrex is almost 8 months old now and you really should upgrade anyways.

[dhirsh]

What is the process for getting the update for timetrex professional.
I followed the link form my timetrex to update and it just drops me onto the main site.
Thanks
Doug

[shaunw]

Please call customer support to obtain your Online Store login/password, that is where all the files can be downloaded now.

[dhirsh]

I just did the update of TimeTrex on my test machine and after the update I have the following 2 problems that croped up.
1. the totals on at least one of the peoples time sheets are wrong.
the regular time is 95:45 and should be 48
the overtime is 17:30 and should be 28:00
the total time is 113:15 and should be 76:00
I believe that this is a problem with the end of the pay period not being handled properly for we use semi-monthly and the change happed on wed of the week.
My main question on this error is does this update normally cause problem like this.
2. The program is reporting an invalid or missing license I know that we are up to date so I don't know what the problem is.

I will be happy to provide any information that you need but I cannot upgrade production until we solve the problems.

[dhirsh]

It appears that I can no longer set permissions any longer when logged in as the administrative user.
Thanks

[shaunw]

The upgrade shouldn't have affected any of those things, it sounds like there may have been an issue prior to the upgrade.

As for the totals, yes it sounds like your pay periods aren't correct. Have you checked them? Admin -> Payroll -> Pay Period Schedules, then click View on the pay periods. What does it say there? (whatever you do, make sure you do not delete any pay periods or pay period schedules)

As for the license, did you download the license file from the Online Store and upload it to Help -> About in your TimeTrex installation? If you upgraded from v2.0.2 this would be a new procedure that you have to do.

[dhirsh]

I did download the file but the help about screen does not have a selection that ask for it I won't be able to do it this evening but I will have to regress I guess and try to start over. unless you have some idea what would cause it not to ask for the license file. I did as the instructions stated and expanded the new version over the old and then ran the install. I also appear not to have access to the permissions settings but I did check and the pay period information appears to be correct.
Doug

[shaunw]

If the license information isn't appearing in Help -> About, it could be that your primary company ID isn't configured correctly.

If you go to Admin -> Company -> Company Information, what does the URL say? It should look something like this:

interface/company/EditCompany.php?id=1

If the ID=X at the end isn't 1, then you need to make sure that you add the following line to the [other] section of your TimeTrex.ini.php file:

primary_company_id = X

Replace X with the ID of the company in the URL above of course. If the ID is 1, then something else is the issue. I would recommend calling our support line so we can help you things sorted out in a timely manner.

[dhirsh]

When I reverted to the back up copy and then did the update a second time it worked. I just have one quick question though have you change the way that permissions are done because I don't see the permissions tab on the employee administration.
Thanks
Doug

[shaunw]

Yes, permissions are handled through Admin -> Company -> Permission Groups now.