[Phpgroupware-cvs] projects/inc/class.soprojects.inc.php, 1.98

[nomail]

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

date: 2004/06/01 15:34:41;  author: ceb;  state: Exp;  lines: +50 -1

Log Message:
update
=====================================================================
Index: projects/inc/class.soprojects.inc.php
diff -u projects/inc/class.soprojects.inc.php:1.97 
projects/inc/class.soprojects.inc.php:1.98
--- projects/inc/class.soprojects.inc.php:1.97  Wed Apr 28 13:34:46 2004
+++ projects/inc/class.soprojects.inc.php       Tue Jun  1 15:34:41 2004
@@ -289,6 +289,55 @@
                        return $pro;
                }
 
+               function read_gantt_projects($data)
+               {
+                       $parent         = intval($data['parent']);
+                       $project_id     = intval($data['project_id']);
+
+                       $ordermethod = ' order by p_number,title,start_date 
ASC';
+
+                       $main_select = 'project_id=' . $data['project_id'];
+
+                       $sql = 'SELECT * from phpgw_p_projects WHERE ';
+
+                       $this->db->query($sql . $main_select . 
$ordermethod,__LINE__,__FILE__);
+
+                       $pro = $this->db2projects();
+
+                       if ($parent > 0)
+                       {
+                               $num_pro = count($pro);
+                               for ($i=0;$i < $num_pro;$i++)
+                               {
+                                       $sub_select = 'parent=' . 
$pro[$i]['project_id'] . ' AND level=' . ($pro[$i]['level']+1);
+
+                                       $this->db->query($sql . $sub_select . 
$ordermethod,__LINE__,__FILE__);
+                                       $subpro = $this->db2projects();
+
+                                       $num_subpro = count($subpro);
+                                       if ($num_subpro != 0)
+                                       {
+                                               $newpro = array();
+                                               for ($k = 0; $k <= $i; $k++)
+                                               {
+                                                       $newpro[$k] = $pro[$k];
+                                               }
+                                               for ($k = 0; $k < $num_subpro; 
$k++)
+                                               {
+                                                       $newpro[$k+$i+1] = 
$subpro[$k];
+                                               }
+                                               for ($k = $i+1; $k < $num_pro; 
$k++)
+                                               {
+                                                       $newpro[$k+$num_subpro] 
= $pro[$k];
+                                               }
+                                               $pro = $newpro;
+                                               $num_pro = count($pro);
+                                       }
+                               }
+                       }
+                       return $pro;
+               }
+
                function read_single_project($project_id)
                {
                        $this->db->query('SELECT * from phpgw_p_projects WHERE 
project_id=' . intval($project_id),__LINE__,__FILE__);