Anonymous Login
2019-08-20 04:49 PDT

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
0000705Third-party ModulesTimecardpublic2014-04-05 17:39
Reportersasquatch58 
Assigned Topedroa 
PrioritynormalSeveritymajorReproducibilityalways
StatusassignedResolutionopen 
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

-Relationships
+Relationships

-Notes

~0001583

sasquatch58 (reporter)

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 (reporter)

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 (reporter)

fixed in r218

~0001913

jonhalle (reporter)

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)
+Notes

-Issue History
Date Modified Username Field Change
2011-01-25 00:20 sasquatch58 New Issue
2011-01-25 00:36 sasquatch58 Note Added: 0001583
2011-01-31 04:16 eureka Note Added: 0001590
2011-01-31 04:17 eureka Note Edited: 0001590
2011-01-31 08:24 eureka Note Edited: 0001590
2011-02-08 11:17 eureka Note Added: 0001606
2011-02-22 01:45 pedroa Status new => assigned
2011-02-22 01:45 pedroa Assigned To => pedroa
2011-05-15 17:06 jonhalle Note Added: 0001913
2014-04-05 17:39 caseydk Category General => Timecard
+Issue History