[Phpgroupware-tracker] [bugs #3377] SQL change suggestion for /projects/inc/class.sobilling.inc.php

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #3377] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Thu 07/15/2004 at 22:59 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
     Planned Release | None                      | 0.9.18.000







/**************************************************************************/
[bugs #3377] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=3377>
Project: phpGroupWare
Submitted by: Kai Hofmann
On: Tue 04/29/2003 at 09:10

Category:  projects
Item Group:  None
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  None
Assigned to:  ceb
Status:  Open
Component Version:  None
Platform Version:  None
Reproducibility:  None
Planned Release:  0.9.18.000
Fixed Release:  


Summary:  SQL change suggestion for /projects/inc/class.sobilling.inc.php

Original Submission:  Withinthe following sql statement 
"phpgw_p_hours.activity_id=phpgw_p_projectactivities.activity_id" should be 
replaced with
"phpgw_p_activities.id=phpgw_p_projectactivities.activity_id":

        $this->db->query("SELECT phpgw_p_hours.id as 
id,phpgw_p_hours.hours_descr,phpgw_p_activities.descr,phpgw_p_hours.status, "
                                                . 
"phpgw_p_hours.start_date,phpgw_p_hours.end_date,phpgw_p_hours.minutes,phpgw_p_hours.minperae,phpgw_p_hours.billperae,"
                                                . "phpgw_p_hours.employee FROM 
phpgw_p_hours " . $this->return_join() . " phpgw_p_activities ON "
                                                . 
"phpgw_p_hours.activity_id=phpgw_p_activities.id " . $this->return_join() . " 
phpgw_p_projectactivities ON "
                                                . 
"phpgw_p_hours.activity_id=phpgw_p_projectactivities.activity_id WHERE 
(phpgw_p_hours.status='done' OR "
                                                . 
"phpgw_p_hours.status='closed') AND (phpgw_p_hours.project_id='" . $project_id 
. "'" . $parent_hours . ") AND "
                                                . 
"phpgw_p_projectactivities.project_id='" . $project_id . "' AND 
phpgw_p_projectactivities.billable='Y' "
                                                . "AND 
phpgw_p_projectactivities.activity_id=phpgw_p_hours.activity_id " . 
$ordermethod,__LINE__,__FILE__);
./projects/inc/class.sobilling.inc.php












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=3377>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/