[Fmsystem-commits] [10083] Logistic: Added function get_activities.

[Torstein]

Revision: 10083
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10083
Author:   vator
Date:     2012-10-02 08:40:04 +0000 (Tue, 02 Oct 2012)
Log Message:
-----------
Logistic: Added function get_activities. 

Modified Paths:
--------------
    trunk/logistic/inc/class.soactivity.inc.php

Modified: trunk/logistic/inc/class.soactivity.inc.php
===================================================================
--- trunk/logistic/inc/class.soactivity.inc.php 2012-10-02 08:35:55 UTC (rev 
10082)
+++ trunk/logistic/inc/class.soactivity.inc.php 2012-10-02 08:40:04 UTC (rev 
10083)
@@ -145,7 +145,36 @@
 
                        return $ret;
                }
+                               
+               /**
+                * Get activity items
+                * @return array containing activities
+               */
+               public function get_activities()
+               {
+                       $results = array();
+                       
+                       $sql = "select a.* from lg_activity a";
 
+                       $this->db->query($sql, __LINE__, __FILE__);
+                       
+                       while($this->db->next_record())
+                       {
+                               $activity = new logistic_activity((int) 
$this->unmarshal($this->db->f('id'), 'int'));
+                               
$activity->set_name($this->unmarshal($this->db->f('name'), 'string'));
+                               
$activity->set_parent_id($this->unmarshal($this->db->f('parent_id'), 'int'));
+                               
$activity->set_project_id($this->unmarshal($this->db->f('project_id'), 'int'));
+                               
$activity->set_start_date($this->unmarshal($this->db->f('start_date'), 'int'));
+                               
$activity->set_end_date($this->unmarshal($this->db->f('end_date'), 'int'));
+                               
$activity->set_responsible_user_id($this->unmarshal($this->db->f('responsible_user_id'),
 'int'));
+                               
$activity->set_update_date($this->unmarshal($this->db->f('update_date'), 
'int'));
+                               
$activity->set_update_user($this->unmarshal($this->db->f('update_user'), 
'int'));
+
+                               $results[] = $activity->toArray();
+                       }
+                       return $results;
+               }
+               
                protected function get_query(string $sort_field, boolean 
$ascending, string $search_for, string $search_type, array $filters, boolean 
$return_count)
                {
                        $clauses = array('1=1');