MantisBT - Third-party Modules
View Issue Details
0000705Third-party ModulesTimecardpublic2011-01-25 00:202014-04-05 17:39
Reportersasquatch58 
Assigned Topedroa 
PrioritynormalSeveritymajorReproducibilityalways
StatusassignedResolutionopen 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
Summary0000705: W2P V2.2 - Timecard R212
Description- Create New Task Log from Timecard module:
  - cannot select available task with dropdown box
  - if Tasklog created in Project or Tasks with recorded hours >24 then can't be edited/ saved in Timecard module
    Note, I suggest Timecard module is correct & perhaps Task Log time entry needs mods if practical.
- Weekly Time Card tab:
  - Ignore 0 hours check box appears to do nothing
  - If start date & end date set the same, no data appears on Submit.
  - No pdf file generated
- Summary by User tab:
  - no Users appear or are selectable even when correct Company selected
- Summary by Project:
  - suggest alternate selection for Project Department/ User Department (we have them disabled in Modules)
  - works OK for All Users but any user selection other than All Users fails on sql query (see additional info below)
Additional InformationERROR: /opt/web2project/classes/w2p/Database/Query.class.php(1116) : query failed(SELECT task_log_creator,contact_department,projects.project_id,project_name,department_id,project_company,company_name,sum(task_log_hours) as hours FROM ((`task_log` AS task_log)) LEFT JOIN `tasks` AS tasks ON task_log.task_log_task = tasks.task_id LEFT JOIN `projects` AS projects ON tasks.task_project = projects.project_id LEFT JOIN `users` AS users ON task_log.task_log_creator = users.user_id LEFT JOIN `companies` AS companies ON projects.project_company = companies.company_id LEFT JOIN `project_departments` AS project_departments ON projects.project_id = project_departments.project_id LEFT JOIN `contacts` AS contacts ON users.user_contact = contacts.contact_id WHERE ( projects.project_id in (5, 2, 1) OR task_log_task=0 ) AND task_log_date >= '2011-01-04 00:00:00' AND task_log_date <= '2011-03-05 23:59:59' AND task_log_creator = 2' GROUP BY project_company,projects.project_id,task_log.task_log_creator) - error was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' GROUP BY project_company,projects.project_id,task_log.task_log_creator' at line 1
Backtrace:
0 /opt/web2project/classes/w2p/Database/Query.class.php:1116 dprint()
1 /opt/web2project/classes/w2p/Database/Query.class.php:1153 exec()
2 /opt/web2project/modules/timecard/vw_weekly_by_project.php:159 loadList()
3 /opt/web2project/style/web2project/overrides.php:101 require()
4 /opt/web2project/modules/timecard/index.php:44 show()
5 /opt/web2project/index.php:363 require()
TagsNo tags attached.
Attached Files

Notes
(0001583)
sasquatch58   
2011-01-25 00:36   
Check on other Projects - Tasks are available in drop down. Example project used has about 30 tasks including dependencies (milestones etc) from imported project. Issue for Task selection may be related to this.
(0001590)
eureka   
2011-01-31 04:16   
(Last edited: 2011-01-31 08:24)
icchengineer wrote :

- Create New Task Log from Timecard module:

  - cannot select available task with dropdown box
  eureka >> I can't reproduce this

  - if Tasklog created in Project or Tasks with recorded hours >24 then can't be edited/ saved in Timecard module
  eureka >> in Timecard module, you are limited to the number of worked hours per day

- Weekly Time Card tab:

  - Ignore 0 hours check box appears to do nothing
  eureka >> I can't reproduce this, it work fine for me

  - If start date & end date set the same, no data appears on Submit.
  eureka >> start date & end date can't be set the same in this tab

  - No pdf file generated
  eureka >> this option is not available in this tab, fixed in the "Task Log By Date" tab

- Summary by User tab:

  - no Users appear or are selectable even when correct Company selected
  eureka >> fixed, i'm waiting sourgeforge svn

- Summary by Project:

  - works OK for All Users but any user selection other than All Users fails on sql query (see additional info below)
  eureka >> fixed, i'm waiting sourgeforge svn

(0001606)
eureka   
2011-02-08 11:17   
fixed in r218
(0001913)
jonhalle   
2011-05-15 17:06   
mot of my tasks were not turning up in the dropdown on weekly view. tracked this down to

modules/timecard/vw_timecard.php line 714

$q->addWhere('t.task_dynamic = 0');

should in my opinion read

$q->addWhere('t.task_dynamic <> 1');

task_dynamic is being used for a few different things and only tasks with task_dynamic set to 1 are actually dynamic tasks for the purpose of not appearing in this dropdown (for example tasks with task_dynamic=31 are non-dynamic but track dependencies and should be be included)

Issue History
2011-01-25 00:20sasquatch58New Issue
2011-01-25 00:36sasquatch58Note Added: 0001583
2011-01-31 04:16eurekaNote Added: 0001590
2011-01-31 04:17eurekaNote Edited: 0001590
2011-01-31 08:24eurekaNote Edited: 0001590
2011-02-08 11:17eurekaNote Added: 0001606
2011-02-22 01:45pedroaStatusnew => assigned
2011-02-22 01:45pedroaAssigned To => pedroa
2011-05-15 17:06jonhalleNote Added: 0001913
2014-04-05 17:39caseydkCategoryGeneral => Timecard