[Phpgroupware-cvs] projects/inc/class.soprojecthours.inc.php, 1.35

[nomail]

Update of /projects/inc
Modified Files:
        Branch: 
          class.soprojecthours.inc.php

date: 2004/05/02 20:56:52;  author: ceb;  state: Exp;  lines: +13 -7

Log Message:
update
=====================================================================
Index: projects/inc/class.soprojecthours.inc.php
diff -u projects/inc/class.soprojecthours.inc.php:1.34 
projects/inc/class.soprojecthours.inc.php:1.35
--- projects/inc/class.soprojecthours.inc.php:1.34      Tue Mar 16 17:06:21 2004
+++ projects/inc/class.soprojecthours.inc.php   Sun May  2 20:56:52 2004
@@ -451,15 +451,21 @@
 
                        for($i=0;$i<count($emps);$i++)
                        {
-                               $sql = 'SELECT SUM(minutes) as utime from 
phpgw_p_hours where employee=' . $emps[$i] . $select;
+                               $bemp[$i] = array
+                               (
+                                       'employee'      => $emps[$i]
+                               );
+
+                               $sql = 'SELECT minutes,start_date,end_date from 
phpgw_p_hours where employee=' . $emps[$i] . $select;
                                $this->db->query($sql,__LINE__,__FILE__);
-                               if($this->db->next_record())
+
+                               while($this->db->next_record())
                                {
-                                       //$minutes = $this->db->f('utime');
-                                       $bemp[] = array
+                                       $bemp[$i]['hours'][] = array
                                        (
-                                               'employee'      => $emps[$i],
-                                               'utime'         => 
$this->db->f('utime')
+                                               'minutes'       => 
$this->db->f('minutes'),
+                                               'sdate'         => 
$this->db->f('start_date'),
+                                               'edate'         => 
$this->db->f('end_date')
                                        );
                                }
                        }