[Fmsystem-commits] [7722] Added function get_control_items_by_control_id.

[Torstein]

Revision: 7722
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=7722
Author:   vator
Date:     2011-09-27 05:45:29 +0000 (Tue, 27 Sep 2011)
Log Message:
-----------
Added function get_control_items_by_control_id. This has to be refactored 
later. into the query function.

Modified Paths:
--------------
    trunk/controller/inc/class.socontrol_item.inc.php

Modified: trunk/controller/inc/class.socontrol_item.inc.php
===================================================================
--- trunk/controller/inc/class.socontrol_item.inc.php   2011-09-27 05:43:17 UTC 
(rev 7721)
+++ trunk/controller/inc/class.socontrol_item.inc.php   2011-09-27 05:45:29 UTC 
(rev 7722)
@@ -253,6 +253,52 @@
                return $results;
        }
        
+       function get_control_items_by_control_id($control_id)
+       {
+               $results = array();
+               
+               $sql = "SELECT ci.* FROM controller_control_item ci, 
controller_control_item_list cl, controller_control c ";
+               $sql .= "WHERE c.id=$control_id AND c.id=cl.control_id AND 
cl.control_item_id=ci.id GROUP BY ";
+               $this->db->limit_query($sql, $start, __LINE__, __FILE__, 
$limit);
+               
+               while ($this->db->next_record()) {
+                       $control_item = new 
controller_control_item($this->unmarshal($this->db->f('id', true), 'int'));
+                       
$control_item->set_title($this->unmarshal($this->db->f('title', true), 
'string'));
+                       
$control_item->set_required($this->unmarshal($this->db->f('required', true), 
'boolean'));
+                       
$control_item->set_what_to_do($this->unmarshal($this->db->f('what_to_do', 
true), 'string'));
+                       
$control_item->set_how_to_do($this->unmarshal($this->db->f('how_to_do', true), 
'string'));
+                       
$control_item->set_control_group_id($this->unmarshal($this->db->f('control_group_id',
 true), 'int'));
+                       
$control_item->set_control_area_id($this->unmarshal($this->db->f('control_area_id',
 true), 'int'));
+                       
+                       $results[] = $control_item;
+               }
+               
+               return $results;
+       }
+       
+       function get_control_items_by_control_id_and_group($control_id, 
$control_group_id)
+       {
+               $results = array();
+               
+               $sql = "SELECT ci.* FROM controller_control_item ci, 
controller_control_item_list cl, controller_control c ";
+               $sql .= "WHERE c.id=$control_id AND c.id=cl.control_id AND 
cl.control_item_id=ci.id AND ci.control_group_id=$control_group_id";
+               $this->db->limit_query($sql, $start, __LINE__, __FILE__, 
$limit);
+               
+               while ($this->db->next_record()) {
+                       $control_item = new 
controller_control_item($this->unmarshal($this->db->f('id', true), 'int'));
+                       
$control_item->set_title($this->unmarshal($this->db->f('title', true), 
'string'));
+                       
$control_item->set_required($this->unmarshal($this->db->f('required', true), 
'boolean'));
+                       
$control_item->set_what_to_do($this->unmarshal($this->db->f('what_to_do', 
true), 'string'));
+                       
$control_item->set_how_to_do($this->unmarshal($this->db->f('how_to_do', true), 
'string'));
+                       
$control_item->set_control_group_id($this->unmarshal($this->db->f('control_group_id',
 true), 'int'));
+                       
$control_item->set_control_area_id($this->unmarshal($this->db->f('control_area_id',
 true), 'int'));
+                       
+                       $results[] = $control_item->toArray();
+               }
+               
+               return $results;
+       }
+       
        function populate(int $control_item_id, &$control_item)
        {