[Fmsystem-commits] [8043] Added get_single function

[Torstein]

Revision: 8043
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8043
Author:   vator
Date:     2011-11-08 08:28:43 +0000 (Tue, 08 Nov 2011)
Log Message:
-----------
Added get_single function

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

Modified: trunk/controller/inc/class.socheck_item.inc.php
===================================================================
--- trunk/controller/inc/class.socheck_item.inc.php     2011-11-07 19:45:21 UTC 
(rev 8042)
+++ trunk/controller/inc/class.socheck_item.inc.php     2011-11-08 08:28:43 UTC 
(rev 8043)
@@ -45,13 +45,15 @@
                return isset($result) ? 
$this->db->get_last_insert_id('controller_check_item', 'id') : 0;
        }
        
-       
-       function update($object){
+       function update($check_item){
+               
+               $id = $check_item->get_id();
+               
                $values = array(
-                       'control_item_id = ' . 
$this->marshal($check_item->set_control_item_id(), 'int'),
-                       'status = ' . $this->marshal($check_item->set_status(), 
'string'),
-                       'comment = ' . 
$this->marshal($check_item->set_comment(), 'string'),
-                       'check_list_id = ' . 
$this->marshal($check_item->set_check_list_id(), 'int')
+                       'control_item_id = ' . 
$this->marshal($check_item->get_control_item_id(), 'int'),
+                       'status = ' . $this->marshal($check_item->get_status(), 
'string'),
+                       'comment = ' . 
$this->marshal($check_item->get_comment(), 'string'),
+                       'check_list_id = ' . 
$this->marshal($check_item->get_check_list_id(), 'int')
                );
                
                $result = $this->db->query('UPDATE controller_check_item SET ' 
. join(',', $values) . " WHERE id=$id", __LINE__,__FILE__);
@@ -63,5 +65,35 @@
                }
        }
        
+       public function get_single($check_item_id){
+               $sql = "SELECT ci.*, coi.id as coi_id, coi.* ";
+               $sql .= "FROM controller_check_item ci, controller_control_item 
coi "; 
+               $sql .= "WHERE ci.id = $check_item_id ";
+               $sql .= "AND ci.control_item_id=coi.id";
+               
+               $this->db->limit_query($sql, 0, __LINE__, __FILE__, 1);
+               
+               if($this->db->next_record()) {
+                       $check_item = new 
controller_check_item($this->unmarshal($this->db->f('id', true), 'int'));
+                       
$check_item->set_control_item_id($this->unmarshal($this->db->f('control_item_id',
 true), 'int'));
+                       
$check_item->set_status($this->unmarshal($this->db->f('status', true), 'bool'));
+                       
$check_item->set_comment($this->unmarshal($this->db->f('comment', true), 
'string'));
+                       
$check_item->set_check_list_id($this->unmarshal($this->db->f('check_list_id', 
true), 'int'));
+                       
+                       $control_item = new 
controller_control_item($this->unmarshal($this->db->f('coi_id', true), 'int'));
+                       $control_item->set_title($this->db->f('title', true), 
'string');
+                       $control_item->set_required($this->db->f('required', 
true), 'string');
+                       
$control_item->set_what_to_do($this->db->f('what_to_do', true), 'string');
+                       $control_item->set_how_to_do($this->db->f('how_to_do', 
true), 'string');
+                       
$control_item->set_control_group_id($this->db->f('control_group_id', true), 
'string');
+                       
+                       $check_item->set_control_item($control_item->toArray());
+                       
+                       return $check_item;
+               }else{
+                       return null;
+               }
+       }
+       
        function get_id_field_name(){}  
 }