The "timecard report" tab in the timecard module where
you select a span of time to view a worker's hours
wasn't working for me, so I changed the
vw_calendar_by_user.php file and it seems to work now.
I am attaching the file since i kind of forget what i
did, but as I remember all I did was change the query
on line 96 to the following, much simpler and possibly
inferior, but working query:
$sql = "SELECT task_log.*, tasks.task_id,
projects.project_name
FROM
task_log, tasks, projects
WHERE
task_log.task_log_task =
tasks.task_id AND
task_log.task_log_creator =
".$user_id." AND
tasks.task_project= projects.project_id AND
task_log.task_log_creator=".$user_id." AND
task_log.task_log_date >=
'".$start_date->format( FMT_DATETIME_MYSQL )."' AND
task_log.task_log_date <= '".$end_date->format(
FMT_DATETIME_MYSQL )."'
ORDER BY task_log_date";