[Fmsystem-commits] [9444]

[Torstein]

Revision: 9444
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9444
Author:   vator
Date:     2012-05-29 01:28:59 +0000 (Tue, 29 May 2012)
Log Message:
-----------


Added Paths:
-----------
    trunk/controller/inc/class.socontrol_item_option.inc.php

Added: trunk/controller/inc/class.socontrol_item_option.inc.php
===================================================================
--- trunk/controller/inc/class.socontrol_item_option.inc.php                    
        (rev 0)
+++ trunk/controller/inc/class.socontrol_item_option.inc.php    2012-05-29 
01:28:59 UTC (rev 9444)
@@ -0,0 +1,102 @@
+<?php
+       /**
+       * phpGroupWare - controller: a part of a Facilities Management System.
+       *
+       * @author Erik Holm-Larsen <address@hidden>
+       * @author Torstein Vadla <address@hidden>
+       * @copyright Copyright (C) 2011,2012 Free Software Foundation, Inc. 
http://www.fsf.org/
+       * This file is part of phpGroupWare.
+       *
+       * phpGroupWare is free software; you can redistribute it and/or modify
+       * it under the terms of the GNU General Public License as published by
+       * the Free Software Foundation; either version 2 of the License, or
+       * (at your option) any later version.
+       *
+       * phpGroupWare is distributed in the hope that it will be useful,
+       * but WITHOUT ANY WARRANTY; without even the implied warranty of
+       * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+       * GNU General Public License for more details.
+       *
+       * You should have received a copy of the GNU General Public License
+       * along with phpGroupWare; if not, write to the Free Software
+       * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 
 USA
+       *
+       * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
+       * @internal Development of this application was funded by 
http://www.bergen.kommune.no/
+       * @package property
+       * @subpackage controller
+       * @version $Id: class.socontrol_item.inc.php 8909 2012-02-17 08:51:35Z 
erikhl $
+       */      
+
+       phpgw::import_class('controller.socommon');
+
+       include_class('controller', 'control_item_option', 'inc/model/');
+
+       class controller_socontrol_item_option extends controller_socommon
+       {
+               protected static $so;
+
+               public static function get_instance()
+               {
+                       if (self::$so == null) {
+                               self::$so = 
CreateObject('controller.socontrol_item_option');
+                       }
+                       return self::$so;
+               }
+
+               function add(&$control_item_option)
+               {
+                       $cols = array(
+                                       'option_value',
+                                       'control_item_id'
+                       );
+
+                       $values = array(
+                               
$this->marshal($control_item_option->get_option_value(), 'string'),
+                               
$this->marshal($control_item_option->get_control_item_id(), 'int')
+                       );
+
+                       $result = $this->db->query('INSERT INTO 
controller_control_item_option (' . join(',', $cols) . ') VALUES (' . join(',', 
$values) . ')', __LINE__,__FILE__);
+
+                       if(isset($result)) {
+                               // return the new control item ID
+                               return 
$this->db->get_last_insert_id('controller_control_item_option', 'id');
+                       }
+                       else
+                       {
+                               return 0;
+                       }
+               }
+
+               function update($control_item_option)
+               {
+                       $id = intval($control_item_option->get_id());
+
+                       $values = array(
+                               'option_value = ' . 
$this->marshal($control_item_option->get_option_value(), 'string'),
+                               'control_item_id = ' . 
$this->marshal($control_item->get_control_item_id(), 'int')
+                       );
+
+                       $result = $this->db->query('UPDATE 
controller_control_item_option SET ' . join(',', $values) . " WHERE id=$id", 
__LINE__,__FILE__);
+
+                       return isset($result);
+               }
+               
+               function get_single($id)
+               {
+                       $id = (int)$id;
+                       $sql = "SELECT p.* FROM controller_control_item_option 
p {$joins} WHERE p.id = " . $id;
+                       $this->db->limit_query($sql, 0, __LINE__, __FILE__, 1);
+                       $this->db->next_record();
+
+                       $control_item_option = new 
controller_control_item_option($this->unmarshal($this->db->f('id', true), 
'int'));
+                       
$control_item_option->set_option_value($this->unmarshal($this->db->f('option_value',
 true), 'string'));
+                       
$control_item_option->set_control_item_id($this->unmarshal($this->db->f('control_item_id',
 true), 'int'));
+                                               
+                       return $control_item_option;
+               }
+               
+               function get_id_field_name(){}
+               function get_query(string $sort_field, boolean $ascending, 
string $search_for, string $search_type, array $filters, boolean 
$return_count){}
+               function populate(int $object_id, &$object){}
+       }