|
| From: | sigurdne |
| Subject: | [Fmsystem-commits] [15684] property: refactoring generic-class |
| Date: | Fri, 16 Sep 2016 07:05:39 +0000 (UTC) |
Revision: 15684
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=15684
Author: sigurdne
Date: 2016-09-16 07:05:38 +0000 (Fri, 16 Sep 2016)
Log Message:
-----------
property: refactoring generic-class
Modified Paths:
--------------
trunk/property/inc/class.bogeneric.inc.php
trunk/property/inc/class.uigeneric.inc.php
Added Paths:
-----------
trunk/property/inc/class.sogeneric_.inc.php
Removed Paths:
-------------
trunk/property/inc/class.sogeneric.inc.php
Modified: trunk/property/inc/class.bogeneric.inc.php
===================================================================
--- trunk/property/inc/class.bogeneric.inc.php 2016-09-16 01:43:02 UTC (rev
15683)
+++ trunk/property/inc/class.bogeneric.inc.php 2016-09-16 07:05:38 UTC (rev
15684)
@@ -51,7 +51,11 @@
function __construct( $session = false )
{
- $this->so = CreateObject('property.sogeneric');
+ $called_class = get_called_class();
+ $called_class_arr = explode('_', $called_class);
+ $appname = !empty($called_class_arr[0]) &&
!empty($GLOBALS['phpgw_info']['apps'][$called_class_arr[0]]) ?
$called_class_arr[0] : 'property';
+ $this->so = CreateObject("{$appname}.sogeneric");
+
$this->custom = & $this->so->custom;
$this->bocommon = CreateObject('property.bocommon');
Deleted: trunk/property/inc/class.sogeneric.inc.php
===================================================================
--- trunk/property/inc/class.sogeneric.inc.php 2016-09-16 01:43:02 UTC (rev
15683)
+++ trunk/property/inc/class.sogeneric.inc.php 2016-09-16 07:05:38 UTC (rev
15684)
@@ -1,3769 +0,0 @@
-<?php
- /**
- * phpGroupWare - property: a Facilities Management System.
- *
- * @author Sigurd Nes <address@hidden>
- * @copyright Copyright (C) 2003,2004,2005,2006,2007,2008,2009 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/bbb_/ekstern/
- * @package property
- * @subpackage admin
- * @version $Id$
- */
-
- /**
- * Description
- * @package property
- */
- class property_sogeneric
- {
-
- var $type;
- var $type_id;
- var $location_info = array();
- var $tree = array();
- protected $table;
- var $appname = 'property';
-
- function __construct( $type = '', $type_id = 0 )
- {
- $this->account =
$GLOBALS['phpgw_info']['user']['account_id'];
- $this->custom = createObject('property.custom_fields');
- $this->_db = & $GLOBALS['phpgw']->db;
- $this->_db2 = clone($this->_db);
- $this->_like = & $this->_db->like;
- $this->_join = & $this->_db->join;
-
- if ($type)
- {
- $this->get_location_info($type, $type_id);
- }
- }
-
- function read( $data )
- {
- $start = isset($data['start']) && $data['start'] ?
$data['start'] : 0;
- $query = isset($data['query']) ? $data['query'] : '';
- $sort = isset($data['sort']) && $data['sort'] ?
$data['sort'] : 'DESC';
- $order = isset($data['order']) ? $data['order'] : '';
- $allrows = isset($data['allrows']) ? $data['allrows'] :
'';
- $custom_criteria = isset($data['custom_criteria']) &&
$data['custom_criteria'] ? $data['custom_criteria'] : array();
- $custom_filter = isset($data['custom_filter']) &&
$data['custom_filter'] ? $data['custom_filter'] : array();
- $filter = isset($data['filter']) && $data['filter'] ?
$data['filter'] : array();
- $results = isset($data['results']) ?
(int)$data['results'] : 0;
-
- $values = array();
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return $values;
- }
-
-
- $_join_method = array();
- $_filter_array = array();
- if ($custom_criteria)
- {
- foreach ($custom_criteria as $_custom_criteria)
- {
- if
(isset($this->location_info['custom_criteria'][$_custom_criteria]['join']) &&
is_array($this->location_info['custom_criteria'][$_custom_criteria]['join']))
- {
- $_join_method =
array_merge($_join_method,
$this->location_info['custom_criteria'][$_custom_criteria]['join']);
- }
- if
(isset($this->location_info['custom_criteria'][$_custom_criteria]['filter']) &&
is_array($this->location_info['custom_criteria'][$_custom_criteria]['filter']))
- {
- $_filter_array =
array_merge($_filter_array,
$this->location_info['custom_criteria'][$_custom_criteria]['filter']);
- }
- }
- }
-
- foreach ($this->location_info['fields'] as $field)
- {
- if (isset($field['filter']) && $field['filter'])
- {
- if (isset($filter[$field['name']]) &&
$filter[$field['name']] && $field['type'] == 'multiple_select')
- {
- $_filter_array[] =
"{$field['name']} {$this->_like} '%,{$filter[$field['name']]},%'";
- }
- else if (isset($filter[$field['name']])
&& $filter[$field['name']])
- {
- $_filter_array[] =
"{$field['name']} = '{$filter[$field['name']]}'";
- }
- }
- }
-
- $uicols = array();
- $uicols['input_type'][] = 'text';
- $uicols['name'][] = $this->location_info['id']['name'];
- $uicols['descr'][] = lang('id');
- $uicols['datatype'][] =
$this->location_info['id']['type'] == 'varchar' ? 'V' : 'I';
- $uicols['sortable'][] = true;
- $uicols['formatter'][] = '';
-
- foreach ($this->location_info['fields'] as $field)
- {
- $uicols['input_type'][] =
isset($field['hidden']) && $field['hidden'] ? 'hidden' : 'text';
- $uicols['name'][] = $field['name'];
- $uicols['descr'][] = $field['descr'];
- $uicols['datatype'][] = $field['type'];
- $uicols['sortable'][] =
isset($field['sortable']) && $field['sortable'] ? true : false;
- $uicols['formatter'][] = $field['type'] ==
'int' ? 'FormatterRight' : '';
- }
-
- $custom_fields = false;
- if
($GLOBALS['phpgw']->locations->get_attrib_table($this->location_info['acl_app'],
$this->location_info['acl_location']))
- {
- $custom_fields = true;
- $choice_table = 'phpgw_cust_choice';
- $attribute_table = 'phpgw_cust_attribute';
- $location_id =
$GLOBALS['phpgw']->locations->get_id($this->location_info['acl_app'],
$this->location_info['acl_location']);
- $attribute_filter = " location_id =
{$location_id}";
-
- $user_columns =
isset($GLOBALS['phpgw_info']['user']['preferences'][$this->location_info['acl_app']]["generic_columns_{$this->type}_{$this->type_id}"])
?
$GLOBALS['phpgw_info']['user']['preferences'][$this->location_info['acl_app']]["generic_columns_{$this->type}_{$this->type_id}"]
: '';
-
- $user_column_filter = '';
- if (isset($user_columns) AND
is_array($user_columns) AND $user_columns[0])
- {
- $user_column_filter = " OR
($attribute_filter AND id IN (" . implode(',', $user_columns) . '))';
- }
-
- $this->_db->query("SELECT * FROM
$attribute_table WHERE list=1 AND $attribute_filter $user_column_filter ORDER
BY attrib_sort ASC");
-
- $i = count($uicols['name']);
- while ($this->_db->next_record())
- {
- $uicols['input_type'][] = 'text';
- $uicols['name'][] =
$this->_db->f('column_name');
- $uicols['descr'][] =
$this->_db->f('input_text');
- $uicols['statustext'][] =
$this->_db->f('statustext');
- $uicols['datatype'][$i] =
$this->_db->f('datatype');
- $uicols['attib_id'][$i] =
$this->_db->f('id');
- $uicols['formatter'][$i] =
$this->_db->f('datatype') == 'I' ? 'FormatterRight' : '';
- $cols_return_extra[] = array(
- 'name' =>
$this->_db->f('column_name'),
- 'datatype' =>
$this->_db->f('datatype'),
- 'attrib_id' =>
$this->_db->f('id')
- );
-
- $i++;
- }
- }
-
- $where = 'WHERE';
- $filtermethod = '';
- if (isset($this->location_info['check_grant']) &&
$this->location_info['check_grant'])
- {
- $filtermethod = "{$where} user_id =
{$this->account} OR public = 1";
- $where = 'AND';
- }
-
- if (isset($this->location_info['filter']) &&
$this->location_info['filter'] && is_array($this->location_info['filter']))
- {
- $_filtermethod = array();
- foreach ($this->location_info['filter'] as
$_argument => $_argument_value)
- {
- if (preg_match('/^##/',
$_argument_value))
- {
- $_argument_value_name =
trim($_argument_value, '#');
- $_argument_value =
$values[$_argument_value_name];
- }
- if (preg_match('/^\$this->/',
$_argument_value))
- {
- $_argument_value_name =
ltrim($_argument_value, '$this->');
- $_argument_value =
$this->$_argument_value_name;
- }
-
- $_filtermethod[] = "{$_argument} =
'{$_argument_value}'";
- }
-
-
- if ($_filtermethod)
- {
- $filtermethod = "{$where} " . implode('
AND ', $_filtermethod);
- $where = 'AND';
- }
- }
-
- if ($_filter_array)
- {
- $filtermethod .= " $where " . implode(' AND ',
$_filter_array);
- $where = 'AND';
- }
-
- if ($custom_filter)
- {
- $filtermethod .= " $where " . implode(' AND ',
$custom_filter);
- $where = 'AND';
- }
-
- $this->uicols = $uicols;
-
- if ($order)
- {
- $ordermethod = " ORDER BY {$table}.{$order}
{$sort}";
- }
- else
- {
- $ordermethod = " ORDER BY
{$table}.{$this->location_info['id']['name']} ASC";
- }
-
- if ($query)
- {
- if ($this->location_info['id']['type'] ==
'auto' || $this->location_info['id']['type'] == 'int')
- {
- $id_query = (int)$query;
- }
- else
- {
- $id_query = "'{$query}'";
- }
-
- $_query_start = '';
- $_query_end = '';
-
- if ($filtermethod)
- {
- $_query_start = '(';
- $_query_end = ')';
- }
- $query = $this->_db->db_addslashes($query);
- $querymethod = " {$where } {$_query_start}
({$table}.{$this->location_info['id']['name']} = {$id_query}";
- //_debug_array($filtermethod);
- //_debug_array($where);die();
-
- if ($this->location_info['id']['type'] ==
'varchar')
- {
- $querymethod .= " OR
{$table}.{$this->location_info['id']['name']} $this->_like '%$query%'";
- $where = 'OR';
- }
- else
- {
- $querymethod .= " OR CAST
({$table}.{$this->location_info['id']['name']} AS TEXT) $this->_like
'%$query%'";
- }
-
- foreach ($this->location_info['fields'] as
$field)
- {
- if ($field['type'] == 'varchar')
- {
- $querymethod .= " OR
{$table}.{$field['name']} $this->_like '%$query%'";
- }
- $where = 'OR';
- }
- $querymethod .= ')';
-
- if ($custom_fields)
- {
- $_querymethod = array();
-
- $this->_db->query("SELECT * FROM
$attribute_table WHERE $attribute_filter AND search='1'", __LINE__, __FILE__);
-
- while ($this->_db->next_record())
- {
- if ($this->_db->f('datatype')
== 'V' || $this->_db->f('datatype') == 'email' || $this->_db->f('datatype') ==
'CH')
- {
- $_querymethod[] =
"$table." . $this->_db->f('column_name') . " {$this->_like} '%{$query}%'";
- }
- else if
($this->_db->f('datatype') == 'I')
- {
- if (ctype_digit($query))
- {
- $_querymethod[]
= "$table." . $this->_db->f('column_name') . '=' . (int)$query;
- }
- }
- else
- {
- $_querymethod[] =
"$table." . $this->_db->f('column_name') . " = '$query'";
- }
- }
-
- if (isset($_querymethod) &&
is_array($_querymethod) && $_querymethod)
- {
- $querymethod .= " $where (" .
implode(' OR ', $_querymethod) . ')';
- }
- }
-
- $querymethod .= $_query_end;
- }
-
- $join_method = $_join_method ? implode(' ',
$_join_method) : '';
-
- $sql = "SELECT DISTINCT {$table}.* FROM {$table}
{$join_method} {$filtermethod} {$querymethod}";
-
- $this->_db->query('SELECT count(*) as cnt ' .
substr($sql, strripos($sql, 'from')), __LINE__, __FILE__);
- $this->_db->next_record();
- $this->total_records = $this->_db->f('cnt');
-
- if (!$allrows)
- {
- $this->_db->limit_query($sql . $ordermethod,
$start, __LINE__, __FILE__, $results);
- }
- else
- {
- $this->_db->query($sql . $ordermethod,
__LINE__, __FILE__);
- }
-
- $cols_return = $uicols['name'];
- $j = 0;
-
- $dataset = array();
- while ($this->_db->next_record())
- {
- foreach ($cols_return as $key => $field)
- {
- $dataset[$j][$field] = array
- (
- 'value' =>
$this->_db->f($field, true),
- 'datatype' =>
$uicols['datatype'][$key],
- 'attrib_id' =>
$uicols['attib_id'][$key]
- );
- }
- $j++;
- }
-
- $values = $this->custom->translate_value($dataset,
$location_id);
-
- return $values;
- }
-
- function get_location_info( $type, $type_id )
- {
- $type_id = (int)$type_id;
- $this->type = $type;
- $this->type_id = $type_id;
- $info = array();
-
- if (!$type)
- {
- return $info;
- }
-
- switch ($type)
- {
- //-------- ID type integer
- case 'part_of_town':
- $info = array
- (
- 'table' => 'fm_part_of_town',
- 'id' => array('name' => 'id',
'type' => 'int', 'descr' => lang('id')),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar',
- 'nullable' =>
false,
- 'size' => 20
- ),
- array
- (
- 'name' =>
'district_id',
- 'descr' =>
lang('district'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'district', 'selected' => '##district_id##')
- )
- ),
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('part of town'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::location::town',
- /*
- 'default'
=> array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' => array('add'
=> 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- */
- 'check_grant' => false
- );
-
- break;
-
- case 'dimb':
- $info = array
- (
- 'table' => 'fm_ecodimb',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'org_unit_id',
- 'descr' =>
lang('department'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'org_unit', 'selected' => '##org_unit_id##')
- )
- )
- ),
- 'custom_criteria' => array
- (
- 'dimb_role_user' =>
array
- (
- 'join' =>
array("{$this->_db->join} fm_ecodimb_role_user ON fm_ecodimb.id =
fm_ecodimb_role_user.ecodimb"),
- 'filter' =>
array('fm_ecodimb_role_user.user_id = ' . (int)$this->account)
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('dimb'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::accounting_dimb'
- );
- break;
- case 'dimd':
- $info = array
- (
- 'table' => 'fm_ecodimd',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('dimd'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::accounting_dimd'
- );
- break;
- case 'periodization':
- $info = array
- (
- 'table' =>
'fm_eco_periodization',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'active',
- 'descr' =>
lang('active'),
- 'type' =>
'checkbox',
- 'default' =>
'checked'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('periodization'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::periodization'
- );
- break;
- case 'tax':
- $info = array
- (
- 'table' => 'fm_ecomva',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'percent',
- 'descr' =>
lang('percent'),
- 'type' => 'int'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('tax code'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::accounting_tax'
- );
- break;
- case 'voucher_cat':
- $info = array
- (
- 'table' =>
'fm_ecobilag_category',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => '',
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::voucher_cats'
- );
- break;
- case 'voucher_type':
- $info = array
- (
- 'table' => 'fm_ecoart',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => '',
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::voucher_type'
- );
- break;
- case 'tender_chapter':
- $info = array
- (
- 'table' => 'fm_chapter',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => '',
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::tender'
- );
- break;
- case 'location':
-
- $this->_db->query("SELECT id FROM
fm_location_type WHERE id ={$type_id}", __LINE__, __FILE__);
-
- if ($this->_db->next_record())
- {
- $info = array
- (
- 'table' =>
"fm_location{$type_id}_category",
- 'id' => array('name' =>
'id', 'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name'
=> 'descr',
- 'descr'
=> lang('descr'),
- 'type'
=> 'varchar'
- )
- ),
- 'edit_msg' =>
lang('edit'),
- 'add_msg' =>
lang('add'),
- 'name' => '',
- 'acl_app' => 'property',
- 'acl_location' =>
'.admin',
- 'menu_selection' =>
"admin::property::location::location::category_{$type_id}"
- );
- }
- else
- {
- throw new
Exception(lang('ERROR: illegal type %1', $type_id));
- }
- break;
- case 'owner_cats':
- $info = array
- (
- 'table' => 'fm_owner_category',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => '',
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::owner::owner_cats'
- );
- break;
- case 'tenant_cats':
- $info = array
- (
- 'table' => 'fm_tenant_category',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('tenant
category'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::tenant::tenant_cats'
- );
- break;
- case 'vendor_cats':
- $info = array
- (
- 'table' => 'fm_vendor_category',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('vendor
category'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::vendor::vendor_cats'
- );
- break;
- case 'vendor':
- $info = array
- (
- 'table' => 'fm_vendor',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'contact_phone',
- 'descr' =>
lang('contact phone'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'category',
- 'descr' =>
lang('category'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'vendor_cats', 'selected' => '##category##')
- )
- ),
- array
- (
- //FIXME
- 'name' =>
'member_of',
- 'descr' =>
lang('member'),
- 'type' =>
'multiple_select',
- 'nullable' =>
true,
- 'filter' =>
true,
- 'sortable' =>
false,
- 'hidden' =>
false,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bocommon.get_categories',
-
'method_input' => array('app' => 'property', 'acl_location' => '.vendor',
-
'selected' => '##member_of##')
- )
- ),
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('vendor'),
- 'acl_app' => 'property',
- 'acl_location' => '.vendor',
- 'menu_selection' =>
'property::economy::vendor',
- 'default' => array
- (
- 'owner_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- //
'modified_date' => array('edit' => 'time()'),
- )
- );
- break;
- case 'owner':
- $info = array
- (
- 'table' => 'fm_owner',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'remark',
- 'descr' =>
lang('remark'),
- 'type' => 'text'
- ),
- array
- (
- 'name' =>
'category',
- 'descr' =>
lang('category'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'owner_cats', 'selected' => '##category##')
- )
- ),
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('owner'),
- 'acl_app' => 'property',
- 'acl_location' => '.owner',
- 'menu_selection' =>
'admin::property::owner',
- 'default' => array
- (
- 'owner_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- //
'modified_date' => array('edit' => 'time()'),
- )
- );
- break;
- case 'tenant':
- $info = array
- (
- 'table' => 'fm_tenant',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'contact_email',
- 'descr' =>
lang('contact_email'),
- 'type' =>
'varchar',
- 'sortable' =>
true,
- ),
- array
- (
- 'name' =>
'category',
- 'descr' =>
lang('category'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'tenant_cats', 'selected' => '##category##')
- )
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('tenant'),
- 'acl_app' => 'property',
- 'acl_location' => '.tenant',
- 'menu_selection' =>
'admin::property::tenant',
- 'default' => array
- (
- 'owner_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- //
'modified_date' => array('edit' => 'time()'),
- )
- );
- break;
- case 'district':
- $info = array
- (
- 'table' => 'fm_district',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('district'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::location::district'
- );
- break;
- case 'street':
- $info = array
- (
- 'table' => 'fm_streetaddress',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('streetaddress'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::location::street'
- );
- break;
- case 's_agreement':
- $info = array
- (
- 'table' =>
'fm_s_agreement_category',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => '',
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::agreement::service_agree_cats'
- );
- break;
- case 'tenant_claim':
- $info = array
- (
- 'table' =>
'fm_tenant_claim_category',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => '',
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::tenant::claims_cats'
- );
- break;
- case 'wo_hours':
- $info = array
- (
- 'table' =>
'fm_wo_hours_category',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => '',
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::workorder_detail'
- );
- break;
- case 'r_condition_type':
- $info = array
- (
- 'table' =>
'fm_request_condition_type',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => 'condition type',
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::request_condition'
- );
- break;
- case 'authorities_demands':
- $info = array
- (
- 'table' =>
'fm_authorities_demands',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('authorities
demands'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::authorities_demands',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => false
- );
- break;
- case 'b_account':
- case 'b_account_category':
- $info = array
- (
- 'table' =>
'fm_b_account_category',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array(
- 'name' =>
'active',
- 'descr' =>
lang('active'),
- 'type' =>
'checkbox',
- 'default' =>
'checked',
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => array(array('id' => 1, 'name' => lang('active'))),
- )
- ),
- array
- (
- 'name' =>
'external_project',
- 'descr' =>
lang('mandatory project group'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('budget account
group'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::accounting_cats'
- );
- break;
-
- case 'dimb_role':
- $info = array
- (
- 'table' => 'fm_ecodimb_role',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit role'),
- 'add_msg' => lang('add role'),
- 'name' => lang('dimb role'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::dimb_role'
- );
- break;
- case 'condition_survey_status':
- $info = array
- (
- 'table' =>
'fm_condition_survey_status',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'sorting',
- 'descr' =>
lang('sorting'),
- 'type' =>
'integer',
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'in_progress',
- 'descr' =>
lang('In progress'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'delivered',
- 'descr' =>
lang('delivered'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'closed',
- 'descr' =>
lang('closed'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit
status'),
- 'add_msg' => lang('add status'),
- 'name' => lang('request
status'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::condition_survey_status'
- );
- break;
-
- case 'request_responsible_unit':
- $_lang_responsible_unit =
lang('responsible unit');
- $info = array
- (
- 'table' =>
'fm_request_responsible_unit',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit') . '
' . $_lang_responsible_unit,
- 'add_msg' => lang('add') . ' '
. $_lang_responsible_unit,
- 'name' =>
$_lang_responsible_unit,
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::request_responsible_unit'
- );
- break;
-
- case 'ticket_priority':
- $_lang_priority = lang('priority');
- $info = array
- (
- 'table' => 'fm_tts_priority',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- ),
- 'edit_msg' => lang('edit') . '
' . $_lang_priority,
- 'add_msg' => lang('add') . ' '
. $_lang_priority,
- 'name' => $_lang_priority,
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::ticket::ticket_priority'
- );
- break;
-
- //-------- ID type varchar
- case 'external_project':
- $info = array
- (
- 'table' =>
'fm_external_project',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array(
- array(
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array(
- 'name' =>
'budget',
- 'descr' =>
lang('budget'),
- 'type' => 'int'
- ),
- array(
- 'name' =>
'active',
- 'descr' =>
lang('active'),
- 'type' =>
'checkbox',
- 'default' =>
'checked',
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => array(array('id' => 1, 'name' => lang('active'))),
- )
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('external
project'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::external_project'
- );
- break;
- case 'unspsc_code':
- $info = array
- (
- 'table' => 'fm_unspsc_code',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array(
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('unspsc code'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::unspsc_code'
- );
- break;
- case 'project_status':
- $info = array
- (
- 'table' => 'fm_project_status',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'approved',
- 'descr' =>
lang('approved'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'closed',
- 'descr' =>
lang('closed'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit
status'),
- 'add_msg' => lang('add status'),
- 'name' => lang('project
status'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::project_status'
- );
- break;
- case 'workorder_status':
- $info = array
- (
- 'table' =>
'fm_workorder_status',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'approved',
- 'descr' =>
lang('approved'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'in_progress',
- 'descr' =>
lang('In progress'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'delivered',
- 'descr' =>
lang('delivered'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'closed',
- 'descr' =>
lang('closed'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit
status'),
- 'add_msg' => lang('add status'),
- 'name' => lang('workorder
status'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::workorder_status'
- );
- break;
- case 'request_status':
- $info = array
- (
- 'table' => 'fm_request_status',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'sorting',
- 'descr' =>
lang('sorting'),
- 'type' =>
'integer',
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'in_progress',
- 'descr' =>
lang('In progress'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'delivered',
- 'descr' =>
lang('delivered'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'closed',
- 'descr' =>
lang('closed'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit
status'),
- 'add_msg' => lang('add status'),
- 'name' => lang('request
status'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::request_status'
- );
- break;
- case 'agreement_status':
- $info = array
- (
- 'table' =>
'fm_agreement_status',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit
status'),
- 'add_msg' => lang('add status'),
- 'name' => lang('agreement
status'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::agreement::agreement_status'
- );
- break;
- case 'building_part':
-
- $config =
CreateObject('phpgwapi.config', 'property');
- $config->read();
-
- $filter_buildingpart =
isset($config->config_data['filter_buildingpart']) ?
$config->config_data['filter_buildingpart'] : array();
-
- $info = array
- (
- 'table' => 'fm_building_part',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'filter_1',
- 'descr' =>
isset($filter_buildingpart[1]) && $filter_buildingpart[1] ?
$filter_buildingpart[1] : 'Filter 1',
- 'type' =>
'checkbox',
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => array(array('id' => 1, 'name' => lang('active'))),
- )
- ),
- array
- (
- 'name' =>
'filter_2',
- 'descr' =>
isset($filter_buildingpart[2]) && $filter_buildingpart[2] ?
$filter_buildingpart[2] : 'Filter 2',
- 'type' =>
'checkbox',
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => array(array('id' => 1, 'name' => lang('active'))),
- )
- ),
- array
- (
- 'name' =>
'filter_3',
- 'descr' =>
isset($filter_buildingpart[3]) && $filter_buildingpart[3] ?
$filter_buildingpart[3] : 'Filter 3',
- 'type' =>
'checkbox',
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => array(array('id' => 1, 'name' => lang('active'))),
- )
- ),
- array
- (
- 'name' =>
'filter_4',
- 'descr' =>
isset($filter_buildingpart[4]) && $filter_buildingpart[4] ?
$filter_buildingpart[4] : 'Filter 4',
- 'type' =>
'checkbox',
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => array(array('id' => 1, 'name' => lang('active'))),
- )
- ),
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('building part'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::building_part'
- );
- break;
- case 'document_status':
- $info = array
- (
- 'table' => 'fm_document_status',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit
status'),
- 'add_msg' => lang('add status'),
- 'name' => lang('document
status'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::document_status'
- );
- break;
- case 'ns3420':
- $info = array
- (
- 'table' => 'fm_ns3420',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'parent_id',
- 'descr' =>
lang('parent'),
- 'type' =>
'select',
- 'sortable' =>
true,
- 'nullable' =>
true,
- 'filter' =>
false,
- 'role' =>
'parent',
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'ns3420', 'role' => 'parent', 'selected' =>
'##parent_id##',
-
'id_in_name' => 'num', 'mapping' => array('name' => 'tekst1')
- )
- )
- ),
- array
- (
- 'name' => 'num',
- 'descr' =>
lang('num'),
- 'type' =>
'varchar',
- 'nullable' =>
false,
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'tekst1',
- 'descr' =>
'tekst1',
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'tekst2',
- 'descr' =>
'tekst2',
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'tekst3',
- 'descr' =>
'tekst3',
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'tekst4',
- 'descr' =>
'tekst4',
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'tekst5',
- 'descr' =>
'tekst5',
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'tekst6',
- 'descr' =>
'tekst6',
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('ns3420'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::ns3420',
- 'check_grant' => false
- );
- break;
- case 'unit':
- $info = array
- (
- 'table' => 'fm_standard_unit',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit unit'),
- 'add_msg' => lang('add unit'),
- 'name' => lang('unit'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::unit'
- );
- break;
- case 'budget_account':
- $info = array
- (
- 'table' => 'fm_b_account',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar',
- 'nullable' =>
false,
- 'size' => 60,
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'category',
- 'descr' =>
lang('category'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'b_account', 'selected' =>
'##category##')//b_account_category
- )
- ),
- array
- (
- 'name' => 'mva',
- 'descr' =>
lang('tax code'),
- 'type' => 'int',
- 'nullable' =>
true,
- 'size' => 4,
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'responsible',
- 'descr' =>
lang('responsible'),
- 'type' =>
'select',
- 'filter' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'get_single_value' => 'get_user',
-
'method' => 'property.bocommon.get_user_list_right2',
-
'method_input' => array('selected' => '##responsible##', 'right' => 128,
-
'acl_location' => '.invoice')
- )
- ),
- array
- (
- 'name' =>
'active',
- 'descr' =>
lang('active'),
- 'type' =>
'checkbox',
- 'default' =>
'checked'
- ),
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('budget
account'),
- 'acl_app' => 'property',
- 'acl_location' => '.b_account',
- 'menu_selection' =>
'property::economy::budget_account',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => false
- );
-
- break;
- case 'voucher_process_code':
- $info = array
- (
- 'table' =>
'fm_ecobilag_process_code',
- 'id' => array('name' => 'id',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- ),
- 'edit_msg' => lang('edit
process code'),
- 'add_msg' => lang('add process
code'),
- 'name' => lang('process code'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::process_code',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- )
- );
- break;
-
- case 'org_unit':
-
- $info = array
- (
- 'table' => 'fm_org_unit',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array(
- array(
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar',
- 'nullable' =>
false,
- 'size' => 60,
- 'sortable' =>
true
- ),
- array(
- 'name' =>
'parent_id',
- 'descr' =>
lang('parent'),
- 'type' =>
'select',
- 'sortable' =>
true,
- 'nullable' =>
true,
- 'filter' =>
false,
- 'role' =>
'parent',
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'method_input' => array('type' => 'org_unit', 'role' => 'parent', 'selected' =>
'##parent_id##')
- )
- ),
- array(
- 'name' =>
'active',
- 'descr' =>
lang('active'),
- 'type' =>
'checkbox',
- 'default' =>
'checked',
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array(
-
'valueset' => array(array('id' => 1, 'name' => lang('active'))),
- )
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('department'),
- 'acl_app' => 'property',
- 'acl_location' => '.org_unit',
- 'menu_selection' =>
'admin::property::accounting::org_unit',
- 'default' => array
- (
- 'created_by' =>
array('add' => '$this->account'),
- 'created_on' =>
array('add' => 'time()'),
- 'modified_by' =>
array('edit' => '$this->account'),
- 'modified_on' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => false
- );
- break;
-
- case 'eco_service':
- $info = array(
- 'table' => 'fm_eco_service',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array(
- array(
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar',
- 'nullable' =>
false,
- 'size' => 50,
- 'sortable' =>
true
- ),
- array(
- 'name' =>
'active',
- 'descr' =>
lang('active'),
- 'type' =>
'checkbox',
- 'default' =>
'checked'
- ),
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('service'),
- 'acl_app' => 'property',
- 'acl_location' => '.b_account',
- 'menu_selection' =>
'property::economy::eco_service',
- 'check_grant' => false
- );
- break;
- //-------- ID type auto
-
- case 'dimb_role_user':
-
- $info = array
- (
- 'table' =>
'fm_ecodimb_role_user',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'ecodimb',
- 'descr' =>
lang('dim b'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'method_input' => array('type' => 'dimb', 'selected' =>
'##ecodimb##')//b_account_category
- )
- ),
- array
- (
- 'name' =>
'role_id',
- 'descr' =>
lang('role type'),
- 'type' =>
'select',
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'dimb_role', 'selected' => '##role_id##')
- )
- ),
- array
- (
- 'name' =>
'user_id',
- 'descr' =>
lang('user'),
- 'type' =>
'select',
- 'filter' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'get_single_value' => 'get_user',
-
'method' => 'property.bocommon.get_user_list_right2',
-
'method_input' => array('selected' => '##user_id##', 'right' => 1,
'acl_location' => '.invoice')
- )
- ),
- array
- (
- 'name' =>
'default_user',
- 'descr' =>
lang('default'),
- 'type' =>
'checkbox',
- 'default' =>
'checked'
- ),
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('dimb role'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::dimb_role_user',
- 'default' => array
- (
- 'created_by' =>
array('add' => '$this->account'),
- 'created_on' =>
array('add' => 'time()'),
- ),
- 'check_grant' => false
- );
- break;
-
- case 'order_dim1':
- $info = array
- (
- 'table' => 'fm_order_dim1',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' => 'num',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar',
- 'nullable' =>
false
- ),
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('order_dim1'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::order_dim1'
- );
- break;
- case 'branch':
- $info = array
- (
- 'table' => 'fm_branch',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' => 'num',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('branch'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::branch'
- );
-
- break;
- case 'key_location':
- $info = array
- (
- 'table' => 'fm_key_loc',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' => 'num',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('key location'),
- 'type' => 'text'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('branch'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::key_location'
- );
-
- break;
-
- case 'async':
- $info = array
- (
- 'table' => 'fm_async_method',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'data',
- 'descr' =>
lang('data'),
- 'type' => 'text'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' => 'text'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('Async
services'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::async'
- );
- break;
-
- case 'event_action':
- $info = array
- (
- 'table' => 'fm_event_action',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'action',
- 'descr' =>
lang('action'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'data',
- 'descr' =>
lang('data'),
- 'type' => 'text'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' => 'text'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('event action'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::event_action',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- )
- );
-
- break;
-
- case 'ticket_status':
-
- $info = array
- (
- 'table' => 'fm_tts_status',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'sorting',
- 'descr' =>
lang('sorting'),
- 'type' =>
'integer',
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'color',
- 'descr' =>
lang('color'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'approved',
- 'descr' =>
lang('approved'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'in_progress',
- 'descr' =>
lang('In progress'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'delivered',
- 'descr' =>
lang('delivered'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'closed',
- 'descr' =>
lang('closed'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'actual_cost',
- 'descr' =>
lang('mandatory actual cost'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('ticket status'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::ticket::ticket_status'
- );
- break;
-
-
- case 'regulations':
- $info = array
- (
- 'table' => 'fm_regulations',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'parent_id',
- 'descr' =>
lang('parent'),
- 'type' =>
'select',
- 'sortable' =>
true,
- 'nullable' =>
true,
- 'filter' =>
false,
- 'role' =>
'parent',
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'method_input' => array('type' => 'regulations', 'role' => 'parent', 'selected'
=> '##parent_id##')
- )
- ),
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar',
- 'sortable' =>
true,
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' => 'text'
- ),
- array
- (
- 'name' =>
'external_ref',
- 'descr' =>
lang('external ref'),
- 'type' => 'link'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('regulations'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::regulations',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- )
- );
- break;
-//START HELPDESK - APP
- case 'helpdesk_status':
- // the helpdesk app
- $info = array
- (
- 'table' =>
'phpgw_helpdesk_status',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'sorting',
- 'descr' =>
lang('sorting'),
- 'type' =>
'integer',
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'color',
- 'descr' =>
lang('color'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'approved',
- 'descr' =>
lang('approved'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'in_progress',
- 'descr' =>
lang('In progress'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'delivered',
- 'descr' =>
lang('delivered'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'closed',
- 'descr' =>
lang('closed'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('event action'),
- 'acl_app' => 'helpdesk',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::helpdesk::ticket_status'
- );
- break;
-
-//END HELPDESK - APP
- case 'pending_action_type':
- $info = array
- (
- 'table' =>
'fm_action_pending_category',
- 'id' => array('name' => 'num',
'type' => 'varchar'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' => 'text'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('Pending action
type'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::action_type'
- );
-
- break;
-
- case 'order_template':
-
- $info = array
- (
- 'table' => 'fm_order_template',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'content',
- 'descr' =>
lang('content'),
- 'type' => 'text'
- ),
- array
- (
- 'name' =>
'public',
- 'descr' =>
lang('public'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('order
template'),
- 'acl_app' => 'property',
- 'acl_location' =>
'.ticket.order',
- 'menu_selection' =>
'property::helpdesk::order_template',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => true
- );
-
- break;
- case 'response_template':
-
- $info = array
- (
- 'table' =>
'fm_response_template',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'content',
- 'descr' =>
lang('content'),
- 'type' => 'text'
- ),
- array
- (
- 'name' =>
'public',
- 'descr' =>
lang('public'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('response
template'),
- 'acl_app' => 'property',
- 'acl_location' => '.ticket',
- 'menu_selection' =>
'property::helpdesk::response_template',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => true
- );
-
- break;
-
- case 'responsibility_role':
-
- $info = array
- (
- 'table' =>
'fm_responsibility_role',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'remark',
- 'descr' =>
lang('remark'),
- 'type' => 'text'
- ),
- array(
- 'name' =>
'location_level',
- 'descr' =>
lang('location level'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'responsibility_id',
- 'descr' =>
lang('responsibility'),
- 'type' =>
'select',
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'get_single_value' => 'property.soresponsible.get_responsibility_name',
-
'method' => 'property.boresponsible.get_responsibilities',
-
'method_input' => array('appname' => '$this->appname', 'selected' =>
'##responsibility_id##')
- )
- )
- ),
- 'edit_action' =>
'property.uiresponsible.edit_role',
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('responsibility
role'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::responsibility_role',
- 'default' => array
- (
- 'appname' =>
array('add' => '$this->appname'),
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => false,
- 'filter' => array('appname' =>
'$this->appname')
- );
-
- break;
-
- case 'custom_menu_items':
- $info = array
- (
- 'table' =>
'fm_custom_menu_items',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'parent_id',
- 'descr' =>
lang('parent'),
- 'type' =>
'select',
- 'sortable' =>
true,
- 'nullable' =>
true,
- 'filter' =>
false,
- 'role' =>
'parent',
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'method_input' => array('type' => 'custom_menu_items', 'role' => 'parent',
-
'selected' => '##parent_id##', 'mapping' => array('name' => 'text'))
- )
- ),
- array
- (
- 'name' =>
'text',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' => 'url',
- 'descr' =>
lang('url'),
- 'type' => 'text'
- ),
- array
- (
- 'name' =>
'target',
- 'descr' =>
lang('target'),
- 'type' =>
'select',
- 'filter' =>
false,
- 'values_def' =>
array
- (
-
'valueset' => array(array('id' => '_blank', 'name' => '_blank'), array(
-
'id' => '_parent', 'name' => '_parent')),
- )
- ),
- array
- (
- 'name' =>
'location',
- 'descr' =>
lang('location'),
- 'type' =>
'select',
- 'filter' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'preferences.boadmin_acl.get_locations',
-
'method_input' => array('acl_app' => 'property', 'selected' => '##location##')
- )
- ),
- array
- (
- 'name' =>
'local_files',
- 'descr' =>
lang('local files'),
- 'type' =>
'checkbox',
- 'default' => ''
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('custom menu
items'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::custom_menu_items',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => false,
- 'mapping' => array('name' =>
'text')
- );
-
- break;
- case 'location_contact':
- $info = array
- (
- 'table' =>
'fm_location_contact',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'contact_id',
- 'descr' =>
lang('contact'),
- 'type' =>
'int', //contact
- 'nullable' =>
false,
- ),
- array
- (
- 'name' =>
'location_code',
- 'descr' =>
lang('location_code'),
- 'type' =>
'varchar', //location
- 'nullable' =>
false,
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('location
contact'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::location::location_contact',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- )
- );
-
- break;
-
- case 'periodization_outline':
- $valueset_month = array();
-
- for ($i = 1; $i < 13; $i++)
- {
- $valueset_month[] = array
- (
- 'id' => $i,
- 'name' => $i
- );
- }
-
- $info = array
- (
- 'table' =>
'fm_eco_periodization_outline',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'periodization_id',
- 'descr' =>
lang('periodization'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'periodization', 'selected' =>
'##periodization_id##')
- )
- ),
- array
- (
- 'name' =>
'month',
- 'descr' =>
lang('month'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => $valueset_month,
- )
- ),
- array
- (
- 'name' =>
'value',
- 'descr' =>
lang('value'),
- 'type' =>
'numeric',
- 'nullable' =>
true,
- 'size' => 4,
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'dividend',
- 'descr' =>
lang('fraction::dividend'),
- 'type' =>
'integer',
- 'nullable' =>
true,
- 'size' => 4,
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'divisor',
- 'descr' =>
lang('fraction::divisor'),
- 'type' =>
'integer',
- 'nullable' =>
true,
- 'size' => 4,
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'remark',
- 'descr' =>
lang('remark'),
- 'type' =>
'varchar',
- 'nullable' =>
false,
- 'size' => 60,
- 'sortable' =>
true
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('periodization'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::periodization_outline'
- );
-
- break;
-
- case 'period_transition':
- $valueset_month = array();
- $valueset_day = array();
- $valueset_hour = array();
-
- $lang_default = lang('default');
- for ($i = 1; $i < 14; $i++)
- {
- $valueset_month[] = array
- (
- 'id' => $i,
- 'name' => $i == 13 ?
"{$i} ({$lang_default})" : $i
- );
- }
-
- for ($i = 1; $i < 32; $i++)
- {
- $valueset_day[] = array
- (
- 'id' => $i,
- 'name' => $i
- );
- }
-
- for ($i = 1; $i < 25; $i++)
- {
- $valueset_hour[] = array
- (
- 'id' => $i,
- 'name' => $i
- );
- }
-
- $info = array
- (
- 'table' =>
'fm_eco_period_transition',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'month',
- 'descr' =>
lang('month'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => $valueset_month,
- )
- ),
- array
- (
- 'name' => 'day',
- 'descr' =>
lang('day'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'size' => 4,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => $valueset_day,
- )
- ),
- array
- (
- 'name' =>
'hour',
- 'descr' =>
lang('hour'),
- 'type' =>
'select',
- 'nullable' =>
true,
- 'size' => 4,
- 'sortable' =>
true,
- 'values_def' =>
array
- (
-
'valueset' => $valueset_hour,
- )
- ),
- array
- (
- 'name' =>
'remark',
- 'descr' =>
lang('remark'),
- 'type' =>
'varchar',
- 'nullable' =>
true,
- 'size' => 60,
- 'sortable' =>
true
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('period
transition'),
- 'acl_app' => 'property',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::property::accounting::period_transition',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- )
- );
-
- break;
-
- case 'entity_group':
- $info = array
- (
- 'table' => 'fm_entity_group',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'descr',
- 'descr' =>
lang('descr'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'active',
- 'descr' =>
lang('active'),
- 'type' =>
'checkbox',
- 'default' =>
'checked'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('entity group'),
- 'acl_app' => 'property',
- 'acl_location' =>
'.admin.entity',
- 'menu_selection' =>
'admin::property::entity::entity_group',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('add' => 'time()', 'edit' => 'time()'),
- ),
- 'check_grant' => false
- );
-
- break;
-
-// START BOOKING TABLES
- case 'bb_office':
- $info = array
- (
- 'table' => 'bb_office',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'description',
- 'descr' =>
lang('description'),
- 'type' => 'text'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' =>
$GLOBALS['phpgw']->translation->translate('office', array(), false, 'booking'),
- 'acl_app' => 'booking',
- 'acl_location' => '.office',
- 'menu_selection' =>
'booking::settings::office',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => false
- );
-
- break;
- case 'bb_office_user':
- $info = array
- (
- 'table' => 'bb_office_user',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array(
- array(
- 'name' =>
'office',
- 'descr' =>
$GLOBALS['phpgw']->translation->translate('office', array(), false, 'booking'),
- 'type' =>
'select',
- 'filter' =>
true,
- 'values_def' =>
array(
-
'valueset' => false,
-
'method' => 'property.bogeneric.get_list',
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method_input' => array('type' => 'bb_office', 'selected' => '##office##')
- )
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' =>
$GLOBALS['phpgw']->translation->translate('office user', array(), false,
'booking'),
- 'acl_app' => 'booking',
- 'acl_location' =>
'.office.user',
- 'menu_selection' =>
'booking::settings::office::office_user',
- 'default' => array
- (
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- ),
- 'check_grant' => false
- );
-
- break;
-
-// END BOOKING TABLES
-// START CONTROLLER TABLES
- case 'controller_check_item_status':
- $info = array
- (
- 'table' =>
'controller_check_item_status',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'sorting',
- 'descr' =>
lang('sorting'),
- 'type' =>
'integer',
- 'sortable' =>
true
- ),
- array
- (
- 'name' =>
'open',
- 'descr' =>
lang('open'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'pending',
- 'descr' =>
lang('pending'),
- 'type' =>
'checkbox'
- ),
- array
- (
- 'name' =>
'closed',
- 'descr' =>
lang('closed'),
- 'type' =>
'checkbox'
- )
- ),
- 'edit_msg' => lang('edit'),
- 'add_msg' => lang('add'),
- 'name' => lang('status'),
- 'acl_app' => 'controller',
- 'acl_location' => 'admin',
- 'menu_selection' =>
'admin::controller::check_item_status'
- );
- break;
-
-// END CONTROLLER TABLES
-// START RENTAL TABLES
- case 'location_factor':
- $info = array
- (
- 'table' =>
'rental_location_factor',
- 'id' => array('name' => 'id',
'type' => 'auto'),
- 'fields' => array(
- array(
- 'name' =>
'part_of_town_id',
- 'descr' =>
lang('location'),
- 'type' =>
'select',
- 'nullable' =>
false,
- 'filter' =>
true,
- 'values_def' =>
array(
-
'valueset' => false,
-
'get_single_value' => 'property.sogeneric.get_name',
-
'method' => 'property.bogeneric.get_list',
-
'method_input' => array('type' => 'part_of_town', 'selected' =>
'##part_of_town_id##')
- )
- ),
- array(
- 'name' =>
'factor',
- 'descr' =>
lang('factor'),
- 'type' =>
'numeric',
- 'nullable' =>
false,
- 'size' => 4,
- 'sortable' =>
true
- ),
- array(
- 'name' =>
'remark',
- 'descr' =>
lang('remark'),
- 'type' => 'text'
- )
- ),
- 'edit_msg' => lang('edit unit'),
- 'add_msg' => lang('add unit'),
- 'name' => lang('unit'),
- 'acl_app' => 'rental',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::rental::location_factor',
- 'default' => array(
- 'user_id' =>
array('add' => '$this->account'),
- 'entry_date' =>
array('add' => 'time()'),
- 'modified_date' =>
array('edit' => 'time()'),
- )
- );
- break;
- case 'composite_standard':
- $info = array
- (
- 'table' =>
'rental_composite_standard',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- array
- (
- 'name' =>
'factor',
- 'descr' =>
lang('factor'),
- 'type' =>
'numeric',
- 'nullable' =>
false,
- 'size' => 4,
- 'sortable' =>
true
- )
- ),
- 'edit_msg' => lang('edit unit'),
- 'add_msg' => lang('add unit'),
- 'name' => lang('unit'),
- 'acl_app' => 'rental',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::rental::composite_standard'
- );
- break;
- case 'responsibility_unit':
- $info = array
- (
- 'table' =>
'rental_contract_responsibility_unit',
- 'id' => array('name' => 'id',
'type' => 'int'),
- 'fields' => array
- (
- array
- (
- 'name' =>
'name',
- 'descr' =>
lang('name'),
- 'type' =>
'varchar'
- ),
- ),
- 'edit_msg' => lang('edit unit'),
- 'add_msg' => lang('add unit'),
- 'name' => lang('unit'),
- 'acl_app' => 'rental',
- 'acl_location' => '.admin',
- 'menu_selection' =>
'admin::rental::responsibility_unit'
- );
- break;
-// END RENTAL TABLES
-
- default:
- $message = lang('ERROR: illegal type
%1', $type);
- phpgwapi_cache::message_set($message,
'error');
-// throw new Exception(lang('ERROR: illegal type
%1', $type));
- }
-
- $this->location_info = $info;
- return $info;
- }
-
- public function get_name( $data )
- {
- if (isset($data['type']) && $data['type'] && !
$this->location_info)
- {
- $this->get_location_info($data['type']);
- }
- $values = $this->read_single($data);
- return isset($values['name']) ? $values['name'] :
$values['descr'];
- }
-
- function read_single( $data, $values = array() )
- {
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return $values;
- }
-
- if ($this->location_info['id']['type'] == 'auto' ||
$this->location_info['id']['type'] == 'int')
- {
- $id = (int)$data['id'];
- }
- else
- {
- $id = "'{$data['id']}'";
- }
-
- $sql = "SELECT * FROM $table WHERE
{$this->location_info['id']['name']} = {$id}";
-
- $this->_db->query($sql, __LINE__, __FILE__);
-
- if ($this->_db->next_record())
- {
- $values['id'] =
$this->_db->f($this->location_info['id']['name']);
-
- // FIXME - add field to $values['attributes']
- foreach ($this->location_info['fields'] as
$field)
- {
- $values[$field['name']] =
$this->_db->f($field['name'], true);
- }
-
- if (isset($values['attributes']) &&
is_array($values['attributes']))
- {
- foreach ($values['attributes'] as
&$attr)
- {
- $attr['value'] =
$this->_db->f($attr['column_name'], true);
- }
- }
- }
- return $values;
- }
-
- //deprecated
- function select_generic_list( $data )
- {
- return $this->get_entity_list($data);
- }
-
- function get_list( $data )
- {
- $values = array();
-
- $this->get_location_info($data['type'],
$data['type_id']);
-
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return $values;
- }
-
- $filtermthod = '';
- if (isset($data['filter']) && is_array($data['filter']))
- {
- $_filter = array();
- foreach ($data['filter'] as $_field => $_value)
- {
- if ($data['filter_method'] == 'like')
- {
- $_filter[] = "{$_field}
{$this->_db->like} '%{$_value}%'";
- }
- else
- {
- $_filter[] = "{$_field} =
'{$_value}'";
- }
- }
- if ($_filter)
- {
- $filtermthod = 'WHERE ' . implode(' AND
', $_filter);
- }
- }
-
- $order = isset($data['order']) && $data['order'] ?
$data['order'] : '';
-
- if ($order)
- {
- $ordermethod = " ORDER BY {$table}.{$order}
{$sort}";
- }
- else
- {
- $ordermethod = " ORDER BY
{$table}.{$this->location_info['id']['name']} ASC";
- }
-
- foreach ($this->location_info['fields'] as $field)
- {
- $fields[] = $field['name'];
- }
-
- // Add extra info to name
- if (isset($data['id_in_name']) && $data['id_in_name'])
- {
- $id_in_name = 'id';
- if (in_array($data['id_in_name'], $fields))
- {
- $id_in_name = $data['id_in_name'];
- }
- }
-
- $fields = implode(',', $fields);
-
- $this->_db->query("SELECT
{$this->location_info['id']['name']} as id, {$fields} FROM {$table}
{$filtermthod} {$ordermethod}");
-
- $return_fields = isset($data['fields']) &&
$data['fields'] && is_array($data['fields']) ? $data['fields'] : array();
-
- $i = 0;
- while ($this->_db->next_record())
- {
- $_extra = $this->_db->f($id_in_name);
- $id = $this->_db->f('id');
- if (!$name = $this->_db->f('name', true))
- {
- $name = $this->_db->f('descr', true);
- }
-
- if ($_extra)
- {
- $name = "{$_extra} - {$name}";
- }
-
- $values[$i] = array
- (
- 'id' => $id,
- 'name' => $name
- );
-
- foreach ($return_fields as $return_field)
- {
- $values[$i][$return_field] =
$this->_db->f($return_field, true);
- }
-
- $i++;
- }
- return $values;
- }
-
- function add( $data, $values_attribute )
- {
- $receipt = array();
-
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- $receipt['error'][] = array('msg' => lang('not
a valid type'));
- return $receipt;
- }
-
- if (isset($data['save']))
- {
- unset($data['save']);
- }
- if (isset($data['apply']))
- {
- unset($data['apply']);
- }
-
- // in case of backslash characters - as in
path-references
- foreach ($data as $_key => &$_value)
- {
- $_value = str_replace('\\', '/', $_value);
- }
- unset($_key);
- unset($_value);
-
-
- foreach ($this->location_info['fields'] as $field)
- {
- if (isset($field['filter']) && $field['filter'])
- {
- if (isset($data[$field['name']]) &&
$data[$field['name']] && $field['type'] == 'multiple_select')
- {
- $data[$field['name']] = ',' .
implode(',', $data[$field['name']]) . ',';
- }
- }
- }
-
- $cols = array();
- $vals = array();
-
- $data['descr'] =
$this->_db->db_addslashes($data['descr']);
-
- if (isset($data['extra']))
- {
- foreach ($data['extra'] as $input_name =>
$value)
- {
- if (isset($value) && $value)
- {
- $cols[] = $input_name;
- $vals[] = $value;
- }
- }
- }
- unset($data['extra']);
-
- foreach ($data as $input_name => $value)
- {
- if (isset($value) && $value)
- {
- $cols[] = $input_name;
- $vals[] =
$this->_db->db_addslashes($value);
- }
- }
-
- $data_attribute = $this->custom->prepare_for_db($table,
$values_attribute);
- if (isset($data_attribute['value_set']))
- {
- foreach ($data_attribute['value_set'] as
$input_name => $value)
- {
- if (isset($value) && $value)
- {
- $cols[] = $input_name;
- $vals[] = $value;
- }
- }
- }
-
-
- if (isset($this->location_info['default']) &&
is_array($this->location_info['default']))
- {
- foreach ($this->location_info['default'] as
$field => $default)
- {
- if (isset($default['add']))
- {
- $cols[] = $field;
- eval('$vals[] = ' .
$default['add'] . ';');
- }
- }
- }
-
- $this->_db->transaction_begin();
-
- if ($this->location_info['id']['type'] != 'auto')
- {
- $this->_db->query("SELECT
{$this->location_info['id']['name']} AS id FROM {$table} WHERE
{$this->location_info['id']['name']} =
'{$data[$this->location_info['id']['name']]}'", __LINE__, __FILE__);
- if ($this->_db->next_record())
- {
- $receipt['error'][] = array('msg' =>
lang('duplicate key value'));
- $receipt['error'][] = array('msg' =>
lang('record has not been saved'));
- return $receipt;
- }
- $id = $data[$this->location_info['id']['name']];
- }
- else
- {
- $id = $this->_db->next_id($table);
- $cols[] = 'id';
- $vals[] = $id;
- }
-
- $cols = implode(",", $cols);
- $vals = $this->_db->validate_insert($vals);
-
- $this->_db->query("INSERT INTO {$table} ({$cols})
VALUES ({$vals})", __LINE__, __FILE__);
-
- /*
if($this->location_info['id']['type']=='auto')
- {
- if(!$data['id'] =
$this->_db->get_last_insert_id($table, 'id'))
- {
- $this->_db->transaction_abort();
- $receipt['error'][]=array('msg'=>lang('record has not
been saved'));
- }
- }
- */
- $this->_db->transaction_commit();
- $receipt['id'] = $id;
- $receipt['message'][] = array('msg' => lang('record has
been saved'));
- return $receipt;
- }
-
- function edit( $data, $values_attribute )
- {
-
- $receipt = array();
-
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- $receipt['error'][] = array('msg' => lang('not
a valid type'));
- return $receipt;
- }
-
- // in case of backslash characters - as in
path-references
- foreach ($data as $_key => &$_value)
- {
- $_value = str_replace('\\', '/', $_value);
- }
- unset($_key);
- unset($_value);
-
- $value_set = array();
-
- if (isset($data['extra']))
- {
- foreach ($data['extra'] as $input_name =>
$value)
- {
- $value_set[$input_name] = $value;
- }
- unset($data['extra']);
- }
-
- $data_attribute = $this->custom->prepare_for_db($table,
$values_attribute, $data['id']);
-
- if (isset($data_attribute['value_set']))
- {
- $value_set = array_merge($value_set,
$data_attribute['value_set']);
- }
-
- $has_to_move = array();
-
- foreach ($this->location_info['fields'] as $field)
- {
- if (isset($field['filter']) && $field['filter'])
- {
- if (isset($data[$field['name']]) &&
$data[$field['name']] && $field['type'] == 'multiple_select')
- {
- $data[$field['name']] = ',' .
implode(',', $data[$field['name']]) . ',';
- }
- }
- $value_set[$field['name']] =
$this->_db->db_addslashes($data[$field['name']]);
-
- // keep hierarchy in order
- if (isset($field['role']) && $field['role'] ==
'parent')
- {
- //FIXME
- $this->_db->query("SELECT parent_id
FROM $table WHERE {$this->location_info['id']['name']}='{$data['id']}'",
__LINE__, __FILE__);
- $this->_db->next_record();
- $orig_parent_id =
$this->_db->f('parent_id');
-
- if ($orig_parent_id &&
(int)$orig_parent_id != (int)$data['parent_id'])
- {
-
- $this->_db->query("SELECT
{$this->location_info['id']['name']} as id FROM $table WHERE parent_id
='{$data['id']}'", __LINE__, __FILE__);
-
- while
($this->_db->next_record())
- {
- $has_to_move[] =
$this->_db->f('id');
- }
- }
- }
- }
-
- if (isset($this->location_info['default']) &&
is_array($this->location_info['default']))
- {
- foreach ($this->location_info['default'] as
$field => $default)
- {
- if (isset($default['edit']))
- {
- eval('$value_set[$field] = ' .
$default['edit'] . ';');
- }
- }
- }
-
- $value_set = $this->_db->validate_update($value_set);
- $this->_db->transaction_begin();
- $this->_db->query("UPDATE $table SET {$value_set} WHERE
{$this->location_info['id']['name']} = '{$data['id']}'", __LINE__, __FILE__);
-
- // keep hierarchy in order
- foreach ($has_to_move as $id)
- {
- $value_set =
$this->_db->validate_update(array('parent_id' => $orig_parent_id));
- $this->_db->query("UPDATE $table SET
{$value_set} WHERE {$this->location_info['id']['name']} = '{$id}'", __LINE__,
__FILE__);
- }
-
- //FIXME
- if (isset($data_attribute['history_set']) &&
is_array($data_attribute['history_set']))
- {
- $historylog =
CreateObject('property.historylog', $this->location_info['acl_app'],
$this->location_info['acl_location']);
- foreach ($data_attribute['history_set'] as
$attrib_id => $history)
- {
- $historylog->add('SO', $data['id'],
$history['value'], isset($history['old_value']) ? $history['old_value'] : null,
$attrib_id, $history['date']);
- }
- }
-
- $this->_db->transaction_commit();
-
- $receipt['id'] = $data['id'];
-
- $receipt['message'][] = array('msg' => lang('record has
been edited'));
- return $receipt;
- }
-
- function delete( $id )
- {
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return false;
- }
-
- $has_to_move = array();
-
- $this->_db->transaction_begin();
-
- foreach ($this->location_info['fields'] as $field)
- {
- // keep hierarchy in order
- if (isset($field['role']) && $field['role'] ==
'parent')
- {
- $this->_db->query("SELECT parent_id
FROM $table WHERE {$this->location_info['id']['name']}='{$id}'", __LINE__,
__FILE__);
- $this->_db->next_record();
- $orig_parent_id =
$this->_db->f('parent_id');
-
- $this->_db->query("SELECT
{$this->location_info['id']['name']} as id FROM $table WHERE parent_id
='{$id}'", __LINE__, __FILE__);
-
- while ($this->_db->next_record())
- {
- $has_to_move[] =
$this->_db->f('id');
- }
- }
- }
-
- $this->_db->query("DELETE FROM $table WHERE
{$this->location_info['id']['name']}='{$id}'", __LINE__, __FILE__);
-
- // keep hierarchy in order
- foreach ($has_to_move as $id)
- {
- $value_set =
$this->_db->validate_update(array('parent_id' => $orig_parent_id));
- $this->_db->query("UPDATE $table SET
{$value_set} WHERE {$this->location_info['id']['name']} = '{$id}'", __LINE__,
__FILE__);
- }
-
- $this->_db->transaction_commit();
- }
-
- public function get_tree2( $data )
- {
- $values = array();
-
- $this->get_location_info($data['type'],
$data['type_id']);
-
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return $values;
- }
- $this->table = $table;
-
- $filtermthod = 'WHERE (parent_id = 0 OR parent_id IS
NULL)';
-
- if (isset($data['filter']) && is_array($data['filter']))
- {
- $_filter = array();
- foreach ($data['filter'] as $_field => $_value)
- {
- $_filter[] = "{$_field} = '{$_value}'";
- }
- if ($_filter)
- {
- $filtermthod .= implode(' AND ',
$_filter);
- }
- }
-
- $order = isset($data['order']) && $data['order'] ?
$data['order'] : '';
-
- if ($order)
- {
- $ordermethod = " ORDER BY {$table}.{$order}
{$sort}";
- }
- else
- {
- $ordermethod = " ORDER BY
{$table}.{$this->location_info['id']['name']} ASC";
- }
-
- foreach ($this->location_info['fields'] as $field)
- {
- $fields[] = $field['name'];
- }
-
- // Add extra info to name
- if (isset($data['id_in_name']) && $data['id_in_name'])
- {
- $id_in_name = 'id';
- if (in_array($data['id_in_name'], $fields))
- {
- $id_in_name = $data['id_in_name'];
- }
- }
-
- $fields = implode(',', $fields);
-
- $this->_db->query("SELECT id, {$fields} FROM {$table}
{$filtermthod} {$ordermethod}", __LINE__, __FILE__);
-
- $return_fields = isset($data['fields']) &&
$data['fields'] && is_array($data['fields']) ? $data['fields'] : array();
-//-----------
- $mapping = array();
- if (isset($data['mapping']) && $data['mapping'])
- {
- $mapping = $data['mapping'];
- }
- else
- {
- $mapping = array('name' => 'name');
- }
-
- $values = array();
- $i = 0;
- while ($this->_db->next_record())
- {
- $_extra = $this->_db->f($id_in_name);
- $id = $this->_db->f('id');
- $name = $this->_db->f($mapping['name'], true);
-
- if ($_extra)
- {
- $name = "{$_extra} - {$name}";
- }
-
- $values[$i] = array
- (
- 'id' => $id,
- 'name' => $name,
- 'parent_id' => 0
- );
-
- foreach ($return_fields as $return_field)
- {
- $values[$i][$return_field] =
$this->_db->f($return_field, true);
- }
-
- $i++;
- }
-
-
- $this->tree = array();
-
- foreach ($values as $value)
- {
- $this->tree[] = $value;
- $this->get_children2($data, $value['id'], 1);
- }
- return $this->tree;
- }
-
- public function get_children2( $data, $parent, $level, $reset =
false )
- {
- $parent = (int)$parent;
- $mapping = array();
- if (isset($data['mapping']) && $data['mapping'])
- {
- $mapping = $data['mapping'];
- }
- else
- {
- $mapping = array('name' => 'name');
- }
-
- if ($reset)
- {
- $this->tree = array();
- }
- $db = clone($this->_db);
- if (!$table = $this->table)
- {
- return $this->tree;
- }
- $sql = "SELECT * FROM {$table} WHERE parent_id =
{$parent}";
-
- $db->query($sql, __LINE__, __FILE__);
-
- while ($db->next_record())
- {
- $id = $db->f('id');
- $this->tree[] = array
- (
- 'id' => $id,
- 'name' => str_repeat('..', $level) .
$db->f($mapping['name'], true),
- 'parent_id' => $parent
- );
- $this->get_children2($data, $id, $level + 1);
- }
- return $this->tree;
- }
-
- /**
- * used for retrive a child-node from a hierarchy
- *
- * @param integer $entity_id Entity id
- * @param integer $parent is the parent of the children we want
to see
- * @param integer $level is increased when we go deeper into
the tree,
- * @return array $child Children
- */
- protected function get_children( $data, $parent, $level )
- {
- $children = array();
-
- $this->get_location_info($data['type'],
$data['type_id']);
-
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return $children;
- }
- $this->table = $table;
-
- $filtermthod = 'WHERE parent_id = ' . (int)$parent;
-
- $sql = "SELECT * FROM {$table} {$filtermthod}";
- $this->_db2->query($sql, __LINE__, __FILE__);
-
- $fields = array(0 => 'id');
- foreach ($this->location_info['fields'] as $field)
- {
- $fields[] = $field['name'];
- }
-
- while ($this->_db2->next_record())
- {
- $id = $this->_db2->f('id');
- foreach ($fields as $field)
- {
- $children[$id][$field] =
$this->_db2->f($field, true);
- }
- }
-
- foreach ($children as &$child)
- {
- $_children = $this->get_children($data,
$child['id'], $level + 1);
- if ($_children)
- {
- $child['children'] = $_children;
- }
- }
- return $children;
- }
-
- /**
- * Get tree from your node
- * @param array $data - 'node_id' as parent and 'type'
- * @return array tree
- */
- public function read_tree( $data )
- {
- $parent_id = isset($data['node_id']) &&
$data['node_id'] ? (int)$data['node_id'] : 0;
- $tree = array();
-
- $this->get_location_info($data['type'],
$data['type_id']);
-
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return $tree;
- }
- $this->table = $table;
-
- if ($parent_id)
- {
- $filtermthod = "WHERE parent_id = {$parent_id}";
- }
- else
- {
- $filtermthod = 'WHERE (parent_id = 0 OR
parent_id IS NULL)';
- }
-
- if (isset($data['filter']) && is_array($data['filter']))
- {
- $_filter = array();
- foreach ($data['filter'] as $_field => $_value)
- {
- $_filter[] = "{$_field} = '{$_value}'";
- }
- if ($_filter)
- {
- $filtermthod .= ' AND ' . implode(' AND
', $_filter);
- }
- }
-
- $sql = "SELECT * FROM {$table} {$filtermthod}";
-
- $this->_db2->query($sql, __LINE__, __FILE__);
- $this->total_records = $this->_db2->num_rows();
-
- $fields = array(0 => 'id');
- foreach ($this->location_info['fields'] as $field)
- {
- $fields[] = $field['name'];
- }
- $node = array();
- $i = 0;
- while ($this->_db2->next_record())
- {
- $id = $this->_db2->f('id');
-
- foreach ($fields as $field)
- {
- $tree[$i][$field] =
$this->_db2->f($field, true);
- }
- $i++;
- }
-
- foreach ($tree as &$node)
- {
- $children = $this->get_children($data,
$node['id'], 0);
- if ($children)
- {
- $node['children'] = $children;
- }
- }
- return $tree;
- }
-
- /**
- * used for retrive the path for a particular node from a
hierarchy
- *
- * @param integer $node is the id of the node we want the path
of
- * @return array $path Path
- */
- public function get_path( $data )
- {
-
- $this->get_location_info($data['type'],
$data['type_id']);
-
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return array();
- }
- $this->table = $table;
-
- if (isset($this->location_info['mapping']) &&
$this->location_info['mapping'])
- {
- $mapping = $this->location_info['mapping'];
- }
- else
- {
- $mapping = array('name' => 'name');
- }
-
- $sql = "SELECT {$mapping['name']}, parent_id FROM
{$table} WHERE id = '{$data['id']}'";
-
- $this->_db->query($sql, __LINE__, __FILE__);
- $this->_db->next_record();
-
- $parent_id = $this->_db->f('parent_id');
-
- $name = $this->_db->f('name', true);
-
- $path = array($name);
-
- if ($parent_id)
- {
- $path =
array_merge($this->get_path(array('type' => $data['type'], 'id' =>
$parent_id)), $path);
- }
- return $path;
- }
-
- public function edit_field( $data = array() )
- {
- if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
- {
- return false;
- }
-
- $value_set =
$this->_db->validate_update(array($data['field_name'] => $data['value']));
- return $this->_db->query("UPDATE $table SET
{$value_set} WHERE {$this->location_info['id']['name']} = '{$data['id']}'",
__LINE__, __FILE__);
- }
- }
\ No newline at end of file
Copied: trunk/property/inc/class.sogeneric_.inc.php (from rev 15683,
trunk/property/inc/class.sogeneric.inc.php)
===================================================================
--- trunk/property/inc/class.sogeneric_.inc.php (rev 0)
+++ trunk/property/inc/class.sogeneric_.inc.php 2016-09-16 07:05:38 UTC (rev
15684)
@@ -0,0 +1,1108 @@
+<?php
+ /**
+ * phpGroupWare - property: a Facilities Management System.
+ *
+ * @author Sigurd Nes <address@hidden>
+ * @copyright Copyright (C) 2003,2004,2005,2006,2007,2008,2009 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/bbb_/ekstern/
+ * @package property
+ * @subpackage admin
+ * @version $Id$
+ */
+
+ /**
+ * Description
+ * @package property
+ */
+ abstract class property_sogeneric_
+ {
+
+ var $type;
+ var $type_id;
+ var $location_info = array();
+ var $tree = array();
+ protected $table;
+ var $appname = 'property';
+
+ function __construct( $type = '', $type_id = 0 )
+ {
+ $this->account =
$GLOBALS['phpgw_info']['user']['account_id'];
+ $this->custom = createObject('property.custom_fields');
+ $this->_db = & $GLOBALS['phpgw']->db;
+ $this->_db2 = clone($this->_db);
+ $this->_like = & $this->_db->like;
+ $this->_join = & $this->_db->join;
+
+ if ($type)
+ {
+ $this->get_location_info($type, $type_id);
+ }
+ }
+
+ function read( $data )
+ {
+ $start = isset($data['start']) && $data['start'] ?
$data['start'] : 0;
+ $query = isset($data['query']) ? $data['query'] : '';
+ $sort = isset($data['sort']) && $data['sort'] ?
$data['sort'] : 'DESC';
+ $order = isset($data['order']) ? $data['order'] : '';
+ $allrows = isset($data['allrows']) ? $data['allrows'] :
'';
+ $custom_criteria = isset($data['custom_criteria']) &&
$data['custom_criteria'] ? $data['custom_criteria'] : array();
+ $custom_filter = isset($data['custom_filter']) &&
$data['custom_filter'] ? $data['custom_filter'] : array();
+ $filter = isset($data['filter']) && $data['filter'] ?
$data['filter'] : array();
+ $results = isset($data['results']) ?
(int)$data['results'] : 0;
+
+ $values = array();
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return $values;
+ }
+
+
+ $_join_method = array();
+ $_filter_array = array();
+ if ($custom_criteria)
+ {
+ foreach ($custom_criteria as $_custom_criteria)
+ {
+ if
(isset($this->location_info['custom_criteria'][$_custom_criteria]['join']) &&
is_array($this->location_info['custom_criteria'][$_custom_criteria]['join']))
+ {
+ $_join_method =
array_merge($_join_method,
$this->location_info['custom_criteria'][$_custom_criteria]['join']);
+ }
+ if
(isset($this->location_info['custom_criteria'][$_custom_criteria]['filter']) &&
is_array($this->location_info['custom_criteria'][$_custom_criteria]['filter']))
+ {
+ $_filter_array =
array_merge($_filter_array,
$this->location_info['custom_criteria'][$_custom_criteria]['filter']);
+ }
+ }
+ }
+
+ foreach ($this->location_info['fields'] as $field)
+ {
+ if (isset($field['filter']) && $field['filter'])
+ {
+ if (isset($filter[$field['name']]) &&
$filter[$field['name']] && $field['type'] == 'multiple_select')
+ {
+ $_filter_array[] =
"{$field['name']} {$this->_like} '%,{$filter[$field['name']]},%'";
+ }
+ else if (isset($filter[$field['name']])
&& $filter[$field['name']])
+ {
+ $_filter_array[] =
"{$field['name']} = '{$filter[$field['name']]}'";
+ }
+ }
+ }
+
+ $uicols = array();
+ $uicols['input_type'][] = 'text';
+ $uicols['name'][] = $this->location_info['id']['name'];
+ $uicols['descr'][] = lang('id');
+ $uicols['datatype'][] =
$this->location_info['id']['type'] == 'varchar' ? 'V' : 'I';
+ $uicols['sortable'][] = true;
+ $uicols['formatter'][] = '';
+
+ foreach ($this->location_info['fields'] as $field)
+ {
+ $uicols['input_type'][] =
isset($field['hidden']) && $field['hidden'] ? 'hidden' : 'text';
+ $uicols['name'][] = $field['name'];
+ $uicols['descr'][] = $field['descr'];
+ $uicols['datatype'][] = $field['type'];
+ $uicols['sortable'][] =
isset($field['sortable']) && $field['sortable'] ? true : false;
+ $uicols['formatter'][] = $field['type'] ==
'int' ? 'FormatterRight' : '';
+ }
+
+ $custom_fields = false;
+ if
($GLOBALS['phpgw']->locations->get_attrib_table($this->location_info['acl_app'],
$this->location_info['acl_location']))
+ {
+ $custom_fields = true;
+ $choice_table = 'phpgw_cust_choice';
+ $attribute_table = 'phpgw_cust_attribute';
+ $location_id =
$GLOBALS['phpgw']->locations->get_id($this->location_info['acl_app'],
$this->location_info['acl_location']);
+ $attribute_filter = " location_id =
{$location_id}";
+
+ $user_columns =
isset($GLOBALS['phpgw_info']['user']['preferences'][$this->location_info['acl_app']]["generic_columns_{$this->type}_{$this->type_id}"])
?
$GLOBALS['phpgw_info']['user']['preferences'][$this->location_info['acl_app']]["generic_columns_{$this->type}_{$this->type_id}"]
: '';
+
+ $user_column_filter = '';
+ if (isset($user_columns) AND
is_array($user_columns) AND $user_columns[0])
+ {
+ $user_column_filter = " OR
($attribute_filter AND id IN (" . implode(',', $user_columns) . '))';
+ }
+
+ $this->_db->query("SELECT * FROM
$attribute_table WHERE list=1 AND $attribute_filter $user_column_filter ORDER
BY attrib_sort ASC");
+
+ $i = count($uicols['name']);
+ while ($this->_db->next_record())
+ {
+ $uicols['input_type'][] = 'text';
+ $uicols['name'][] =
$this->_db->f('column_name');
+ $uicols['descr'][] =
$this->_db->f('input_text');
+ $uicols['statustext'][] =
$this->_db->f('statustext');
+ $uicols['datatype'][$i] =
$this->_db->f('datatype');
+ $uicols['attib_id'][$i] =
$this->_db->f('id');
+ $uicols['formatter'][$i] =
$this->_db->f('datatype') == 'I' ? 'FormatterRight' : '';
+ $cols_return_extra[] = array(
+ 'name' =>
$this->_db->f('column_name'),
+ 'datatype' =>
$this->_db->f('datatype'),
+ 'attrib_id' =>
$this->_db->f('id')
+ );
+
+ $i++;
+ }
+ }
+
+ $where = 'WHERE';
+ $filtermethod = '';
+ if (isset($this->location_info['check_grant']) &&
$this->location_info['check_grant'])
+ {
+ $filtermethod = "{$where} user_id =
{$this->account} OR public = 1";
+ $where = 'AND';
+ }
+
+ if (isset($this->location_info['filter']) &&
$this->location_info['filter'] && is_array($this->location_info['filter']))
+ {
+ $_filtermethod = array();
+ foreach ($this->location_info['filter'] as
$_argument => $_argument_value)
+ {
+ if (preg_match('/^##/',
$_argument_value))
+ {
+ $_argument_value_name =
trim($_argument_value, '#');
+ $_argument_value =
$values[$_argument_value_name];
+ }
+ if (preg_match('/^\$this->/',
$_argument_value))
+ {
+ $_argument_value_name =
ltrim($_argument_value, '$this->');
+ $_argument_value =
$this->$_argument_value_name;
+ }
+
+ $_filtermethod[] = "{$_argument} =
'{$_argument_value}'";
+ }
+
+
+ if ($_filtermethod)
+ {
+ $filtermethod = "{$where} " . implode('
AND ', $_filtermethod);
+ $where = 'AND';
+ }
+ }
+
+ if ($_filter_array)
+ {
+ $filtermethod .= " $where " . implode(' AND ',
$_filter_array);
+ $where = 'AND';
+ }
+
+ if ($custom_filter)
+ {
+ $filtermethod .= " $where " . implode(' AND ',
$custom_filter);
+ $where = 'AND';
+ }
+
+ $this->uicols = $uicols;
+
+ if ($order)
+ {
+ $ordermethod = " ORDER BY {$table}.{$order}
{$sort}";
+ }
+ else
+ {
+ $ordermethod = " ORDER BY
{$table}.{$this->location_info['id']['name']} ASC";
+ }
+
+ if ($query)
+ {
+ if ($this->location_info['id']['type'] ==
'auto' || $this->location_info['id']['type'] == 'int')
+ {
+ $id_query = (int)$query;
+ }
+ else
+ {
+ $id_query = "'{$query}'";
+ }
+
+ $_query_start = '';
+ $_query_end = '';
+
+ if ($filtermethod)
+ {
+ $_query_start = '(';
+ $_query_end = ')';
+ }
+ $query = $this->_db->db_addslashes($query);
+ $querymethod = " {$where } {$_query_start}
({$table}.{$this->location_info['id']['name']} = {$id_query}";
+ //_debug_array($filtermethod);
+ //_debug_array($where);die();
+
+ if ($this->location_info['id']['type'] ==
'varchar')
+ {
+ $querymethod .= " OR
{$table}.{$this->location_info['id']['name']} $this->_like '%$query%'";
+ $where = 'OR';
+ }
+ else
+ {
+ $querymethod .= " OR CAST
({$table}.{$this->location_info['id']['name']} AS TEXT) $this->_like
'%$query%'";
+ }
+
+ foreach ($this->location_info['fields'] as
$field)
+ {
+ if ($field['type'] == 'varchar')
+ {
+ $querymethod .= " OR
{$table}.{$field['name']} $this->_like '%$query%'";
+ }
+ $where = 'OR';
+ }
+ $querymethod .= ')';
+
+ if ($custom_fields)
+ {
+ $_querymethod = array();
+
+ $this->_db->query("SELECT * FROM
$attribute_table WHERE $attribute_filter AND search='1'", __LINE__, __FILE__);
+
+ while ($this->_db->next_record())
+ {
+ if ($this->_db->f('datatype')
== 'V' || $this->_db->f('datatype') == 'email' || $this->_db->f('datatype') ==
'CH')
+ {
+ $_querymethod[] =
"$table." . $this->_db->f('column_name') . " {$this->_like} '%{$query}%'";
+ }
+ else if
($this->_db->f('datatype') == 'I')
+ {
+ if (ctype_digit($query))
+ {
+ $_querymethod[]
= "$table." . $this->_db->f('column_name') . '=' . (int)$query;
+ }
+ }
+ else
+ {
+ $_querymethod[] =
"$table." . $this->_db->f('column_name') . " = '$query'";
+ }
+ }
+
+ if (isset($_querymethod) &&
is_array($_querymethod) && $_querymethod)
+ {
+ $querymethod .= " $where (" .
implode(' OR ', $_querymethod) . ')';
+ }
+ }
+
+ $querymethod .= $_query_end;
+ }
+
+ $join_method = $_join_method ? implode(' ',
$_join_method) : '';
+
+ $sql = "SELECT DISTINCT {$table}.* FROM {$table}
{$join_method} {$filtermethod} {$querymethod}";
+
+ $this->_db->query('SELECT count(*) as cnt ' .
substr($sql, strripos($sql, 'from')), __LINE__, __FILE__);
+ $this->_db->next_record();
+ $this->total_records = $this->_db->f('cnt');
+
+ if (!$allrows)
+ {
+ $this->_db->limit_query($sql . $ordermethod,
$start, __LINE__, __FILE__, $results);
+ }
+ else
+ {
+ $this->_db->query($sql . $ordermethod,
__LINE__, __FILE__);
+ }
+
+ $cols_return = $uicols['name'];
+ $j = 0;
+
+ $dataset = array();
+ while ($this->_db->next_record())
+ {
+ foreach ($cols_return as $key => $field)
+ {
+ $dataset[$j][$field] = array
+ (
+ 'value' =>
$this->_db->f($field, true),
+ 'datatype' =>
$uicols['datatype'][$key],
+ 'attrib_id' =>
$uicols['attib_id'][$key]
+ );
+ }
+ $j++;
+ }
+
+ $values = $this->custom->translate_value($dataset,
$location_id);
+
+ return $values;
+ }
+
+ abstract function get_location_info( $type, $type_id );
+
+ public function get_name( $data )
+ {
+ if (isset($data['type']) && $data['type'] && !
$this->location_info)
+ {
+ $this->get_location_info($data['type']);
+ }
+ $values = $this->read_single($data);
+ return isset($values['name']) ? $values['name'] :
$values['descr'];
+ }
+
+ function read_single( $data, $values = array() )
+ {
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return $values;
+ }
+
+ if ($this->location_info['id']['type'] == 'auto' ||
$this->location_info['id']['type'] == 'int')
+ {
+ $id = (int)$data['id'];
+ }
+ else
+ {
+ $id = "'{$data['id']}'";
+ }
+
+ $sql = "SELECT * FROM $table WHERE
{$this->location_info['id']['name']} = {$id}";
+
+ $this->_db->query($sql, __LINE__, __FILE__);
+
+ if ($this->_db->next_record())
+ {
+ $values['id'] =
$this->_db->f($this->location_info['id']['name']);
+
+ // FIXME - add field to $values['attributes']
+ foreach ($this->location_info['fields'] as
$field)
+ {
+ $values[$field['name']] =
$this->_db->f($field['name'], true);
+ }
+
+ if (isset($values['attributes']) &&
is_array($values['attributes']))
+ {
+ foreach ($values['attributes'] as
&$attr)
+ {
+ $attr['value'] =
$this->_db->f($attr['column_name'], true);
+ }
+ }
+ }
+ return $values;
+ }
+
+ //deprecated
+ function select_generic_list( $data )
+ {
+ return $this->get_entity_list($data);
+ }
+
+ function get_list( $data )
+ {
+ $values = array();
+
+ $this->get_location_info($data['type'],
$data['type_id']);
+
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return $values;
+ }
+
+ $filtermthod = '';
+ if (isset($data['filter']) && is_array($data['filter']))
+ {
+ $_filter = array();
+ foreach ($data['filter'] as $_field => $_value)
+ {
+ if ($data['filter_method'] == 'like')
+ {
+ $_filter[] = "{$_field}
{$this->_db->like} '%{$_value}%'";
+ }
+ else
+ {
+ $_filter[] = "{$_field} =
'{$_value}'";
+ }
+ }
+ if ($_filter)
+ {
+ $filtermthod = 'WHERE ' . implode(' AND
', $_filter);
+ }
+ }
+
+ $order = isset($data['order']) && $data['order'] ?
$data['order'] : '';
+
+ if ($order)
+ {
+ $ordermethod = " ORDER BY {$table}.{$order}
{$sort}";
+ }
+ else
+ {
+ $ordermethod = " ORDER BY
{$table}.{$this->location_info['id']['name']} ASC";
+ }
+
+ foreach ($this->location_info['fields'] as $field)
+ {
+ $fields[] = $field['name'];
+ }
+
+ // Add extra info to name
+ if (isset($data['id_in_name']) && $data['id_in_name'])
+ {
+ $id_in_name = 'id';
+ if (in_array($data['id_in_name'], $fields))
+ {
+ $id_in_name = $data['id_in_name'];
+ }
+ }
+
+ $fields = implode(',', $fields);
+
+ $this->_db->query("SELECT
{$this->location_info['id']['name']} as id, {$fields} FROM {$table}
{$filtermthod} {$ordermethod}");
+
+ $return_fields = isset($data['fields']) &&
$data['fields'] && is_array($data['fields']) ? $data['fields'] : array();
+
+ $i = 0;
+ while ($this->_db->next_record())
+ {
+ $_extra = $this->_db->f($id_in_name);
+ $id = $this->_db->f('id');
+ if (!$name = $this->_db->f('name', true))
+ {
+ $name = $this->_db->f('descr', true);
+ }
+
+ if ($_extra)
+ {
+ $name = "{$_extra} - {$name}";
+ }
+
+ $values[$i] = array
+ (
+ 'id' => $id,
+ 'name' => $name
+ );
+
+ foreach ($return_fields as $return_field)
+ {
+ $values[$i][$return_field] =
$this->_db->f($return_field, true);
+ }
+
+ $i++;
+ }
+ return $values;
+ }
+
+ function add( $data, $values_attribute )
+ {
+ $receipt = array();
+
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ $receipt['error'][] = array('msg' => lang('not
a valid type'));
+ return $receipt;
+ }
+
+ if (isset($data['save']))
+ {
+ unset($data['save']);
+ }
+ if (isset($data['apply']))
+ {
+ unset($data['apply']);
+ }
+
+ // in case of backslash characters - as in
path-references
+ foreach ($data as $_key => &$_value)
+ {
+ $_value = str_replace('\\', '/', $_value);
+ }
+ unset($_key);
+ unset($_value);
+
+
+ foreach ($this->location_info['fields'] as $field)
+ {
+ if (isset($field['filter']) && $field['filter'])
+ {
+ if (isset($data[$field['name']]) &&
$data[$field['name']] && $field['type'] == 'multiple_select')
+ {
+ $data[$field['name']] = ',' .
implode(',', $data[$field['name']]) . ',';
+ }
+ }
+ }
+
+ $cols = array();
+ $vals = array();
+
+ $data['descr'] =
$this->_db->db_addslashes($data['descr']);
+
+ if (isset($data['extra']))
+ {
+ foreach ($data['extra'] as $input_name =>
$value)
+ {
+ if (isset($value) && $value)
+ {
+ $cols[] = $input_name;
+ $vals[] = $value;
+ }
+ }
+ }
+ unset($data['extra']);
+
+ foreach ($data as $input_name => $value)
+ {
+ if (isset($value) && $value)
+ {
+ $cols[] = $input_name;
+ $vals[] =
$this->_db->db_addslashes($value);
+ }
+ }
+
+ $data_attribute = $this->custom->prepare_for_db($table,
$values_attribute);
+ if (isset($data_attribute['value_set']))
+ {
+ foreach ($data_attribute['value_set'] as
$input_name => $value)
+ {
+ if (isset($value) && $value)
+ {
+ $cols[] = $input_name;
+ $vals[] = $value;
+ }
+ }
+ }
+
+
+ if (isset($this->location_info['default']) &&
is_array($this->location_info['default']))
+ {
+ foreach ($this->location_info['default'] as
$field => $default)
+ {
+ if (isset($default['add']))
+ {
+ $cols[] = $field;
+ eval('$vals[] = ' .
$default['add'] . ';');
+ }
+ }
+ }
+
+ $this->_db->transaction_begin();
+
+ if ($this->location_info['id']['type'] != 'auto')
+ {
+ $this->_db->query("SELECT
{$this->location_info['id']['name']} AS id FROM {$table} WHERE
{$this->location_info['id']['name']} =
'{$data[$this->location_info['id']['name']]}'", __LINE__, __FILE__);
+ if ($this->_db->next_record())
+ {
+ $receipt['error'][] = array('msg' =>
lang('duplicate key value'));
+ $receipt['error'][] = array('msg' =>
lang('record has not been saved'));
+ return $receipt;
+ }
+ $id = $data[$this->location_info['id']['name']];
+ }
+ else
+ {
+ $id = $this->_db->next_id($table);
+ $cols[] = 'id';
+ $vals[] = $id;
+ }
+
+ $cols = implode(",", $cols);
+ $vals = $this->_db->validate_insert($vals);
+
+ $this->_db->query("INSERT INTO {$table} ({$cols})
VALUES ({$vals})", __LINE__, __FILE__);
+
+ /*
if($this->location_info['id']['type']=='auto')
+ {
+ if(!$data['id'] =
$this->_db->get_last_insert_id($table, 'id'))
+ {
+ $this->_db->transaction_abort();
+ $receipt['error'][]=array('msg'=>lang('record has not
been saved'));
+ }
+ }
+ */
+ $this->_db->transaction_commit();
+ $receipt['id'] = $id;
+ $receipt['message'][] = array('msg' => lang('record has
been saved'));
+ return $receipt;
+ }
+
+ function edit( $data, $values_attribute )
+ {
+
+ $receipt = array();
+
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ $receipt['error'][] = array('msg' => lang('not
a valid type'));
+ return $receipt;
+ }
+
+ // in case of backslash characters - as in
path-references
+ foreach ($data as $_key => &$_value)
+ {
+ $_value = str_replace('\\', '/', $_value);
+ }
+ unset($_key);
+ unset($_value);
+
+ $value_set = array();
+
+ if (isset($data['extra']))
+ {
+ foreach ($data['extra'] as $input_name =>
$value)
+ {
+ $value_set[$input_name] = $value;
+ }
+ unset($data['extra']);
+ }
+
+ $data_attribute = $this->custom->prepare_for_db($table,
$values_attribute, $data['id']);
+
+ if (isset($data_attribute['value_set']))
+ {
+ $value_set = array_merge($value_set,
$data_attribute['value_set']);
+ }
+
+ $has_to_move = array();
+
+ foreach ($this->location_info['fields'] as $field)
+ {
+ if (isset($field['filter']) && $field['filter'])
+ {
+ if (isset($data[$field['name']]) &&
$data[$field['name']] && $field['type'] == 'multiple_select')
+ {
+ $data[$field['name']] = ',' .
implode(',', $data[$field['name']]) . ',';
+ }
+ }
+ $value_set[$field['name']] =
$this->_db->db_addslashes($data[$field['name']]);
+
+ // keep hierarchy in order
+ if (isset($field['role']) && $field['role'] ==
'parent')
+ {
+ //FIXME
+ $this->_db->query("SELECT parent_id
FROM $table WHERE {$this->location_info['id']['name']}='{$data['id']}'",
__LINE__, __FILE__);
+ $this->_db->next_record();
+ $orig_parent_id =
$this->_db->f('parent_id');
+
+ if ($orig_parent_id &&
(int)$orig_parent_id != (int)$data['parent_id'])
+ {
+
+ $this->_db->query("SELECT
{$this->location_info['id']['name']} as id FROM $table WHERE parent_id
='{$data['id']}'", __LINE__, __FILE__);
+
+ while
($this->_db->next_record())
+ {
+ $has_to_move[] =
$this->_db->f('id');
+ }
+ }
+ }
+ }
+
+ if (isset($this->location_info['default']) &&
is_array($this->location_info['default']))
+ {
+ foreach ($this->location_info['default'] as
$field => $default)
+ {
+ if (isset($default['edit']))
+ {
+ eval('$value_set[$field] = ' .
$default['edit'] . ';');
+ }
+ }
+ }
+
+ $value_set = $this->_db->validate_update($value_set);
+ $this->_db->transaction_begin();
+ $this->_db->query("UPDATE $table SET {$value_set} WHERE
{$this->location_info['id']['name']} = '{$data['id']}'", __LINE__, __FILE__);
+
+ // keep hierarchy in order
+ foreach ($has_to_move as $id)
+ {
+ $value_set =
$this->_db->validate_update(array('parent_id' => $orig_parent_id));
+ $this->_db->query("UPDATE $table SET
{$value_set} WHERE {$this->location_info['id']['name']} = '{$id}'", __LINE__,
__FILE__);
+ }
+
+ //FIXME
+ if (isset($data_attribute['history_set']) &&
is_array($data_attribute['history_set']))
+ {
+ $historylog =
CreateObject('property.historylog', $this->location_info['acl_app'],
$this->location_info['acl_location']);
+ foreach ($data_attribute['history_set'] as
$attrib_id => $history)
+ {
+ $historylog->add('SO', $data['id'],
$history['value'], isset($history['old_value']) ? $history['old_value'] : null,
$attrib_id, $history['date']);
+ }
+ }
+
+ $this->_db->transaction_commit();
+
+ $receipt['id'] = $data['id'];
+
+ $receipt['message'][] = array('msg' => lang('record has
been edited'));
+ return $receipt;
+ }
+
+ function delete( $id )
+ {
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return false;
+ }
+
+ $has_to_move = array();
+
+ $this->_db->transaction_begin();
+
+ foreach ($this->location_info['fields'] as $field)
+ {
+ // keep hierarchy in order
+ if (isset($field['role']) && $field['role'] ==
'parent')
+ {
+ $this->_db->query("SELECT parent_id
FROM $table WHERE {$this->location_info['id']['name']}='{$id}'", __LINE__,
__FILE__);
+ $this->_db->next_record();
+ $orig_parent_id =
$this->_db->f('parent_id');
+
+ $this->_db->query("SELECT
{$this->location_info['id']['name']} as id FROM $table WHERE parent_id
='{$id}'", __LINE__, __FILE__);
+
+ while ($this->_db->next_record())
+ {
+ $has_to_move[] =
$this->_db->f('id');
+ }
+ }
+ }
+
+ $this->_db->query("DELETE FROM $table WHERE
{$this->location_info['id']['name']}='{$id}'", __LINE__, __FILE__);
+
+ // keep hierarchy in order
+ foreach ($has_to_move as $id)
+ {
+ $value_set =
$this->_db->validate_update(array('parent_id' => $orig_parent_id));
+ $this->_db->query("UPDATE $table SET
{$value_set} WHERE {$this->location_info['id']['name']} = '{$id}'", __LINE__,
__FILE__);
+ }
+
+ $this->_db->transaction_commit();
+ }
+
+ public function get_tree2( $data )
+ {
+ $values = array();
+
+ $this->get_location_info($data['type'],
$data['type_id']);
+
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return $values;
+ }
+ $this->table = $table;
+
+ $filtermthod = 'WHERE (parent_id = 0 OR parent_id IS
NULL)';
+
+ if (isset($data['filter']) && is_array($data['filter']))
+ {
+ $_filter = array();
+ foreach ($data['filter'] as $_field => $_value)
+ {
+ $_filter[] = "{$_field} = '{$_value}'";
+ }
+ if ($_filter)
+ {
+ $filtermthod .= implode(' AND ',
$_filter);
+ }
+ }
+
+ $order = isset($data['order']) && $data['order'] ?
$data['order'] : '';
+
+ if ($order)
+ {
+ $ordermethod = " ORDER BY {$table}.{$order}
{$sort}";
+ }
+ else
+ {
+ $ordermethod = " ORDER BY
{$table}.{$this->location_info['id']['name']} ASC";
+ }
+
+ foreach ($this->location_info['fields'] as $field)
+ {
+ $fields[] = $field['name'];
+ }
+
+ // Add extra info to name
+ if (isset($data['id_in_name']) && $data['id_in_name'])
+ {
+ $id_in_name = 'id';
+ if (in_array($data['id_in_name'], $fields))
+ {
+ $id_in_name = $data['id_in_name'];
+ }
+ }
+
+ $fields = implode(',', $fields);
+
+ $this->_db->query("SELECT id, {$fields} FROM {$table}
{$filtermthod} {$ordermethod}", __LINE__, __FILE__);
+
+ $return_fields = isset($data['fields']) &&
$data['fields'] && is_array($data['fields']) ? $data['fields'] : array();
+//-----------
+ $mapping = array();
+ if (isset($data['mapping']) && $data['mapping'])
+ {
+ $mapping = $data['mapping'];
+ }
+ else
+ {
+ $mapping = array('name' => 'name');
+ }
+
+ $values = array();
+ $i = 0;
+ while ($this->_db->next_record())
+ {
+ $_extra = $this->_db->f($id_in_name);
+ $id = $this->_db->f('id');
+ $name = $this->_db->f($mapping['name'], true);
+
+ if ($_extra)
+ {
+ $name = "{$_extra} - {$name}";
+ }
+
+ $values[$i] = array
+ (
+ 'id' => $id,
+ 'name' => $name,
+ 'parent_id' => 0
+ );
+
+ foreach ($return_fields as $return_field)
+ {
+ $values[$i][$return_field] =
$this->_db->f($return_field, true);
+ }
+
+ $i++;
+ }
+
+
+ $this->tree = array();
+
+ foreach ($values as $value)
+ {
+ $this->tree[] = $value;
+ $this->get_children2($data, $value['id'], 1);
+ }
+ return $this->tree;
+ }
+
+ public function get_children2( $data, $parent, $level, $reset =
false )
+ {
+ $parent = (int)$parent;
+ $mapping = array();
+ if (isset($data['mapping']) && $data['mapping'])
+ {
+ $mapping = $data['mapping'];
+ }
+ else
+ {
+ $mapping = array('name' => 'name');
+ }
+
+ if ($reset)
+ {
+ $this->tree = array();
+ }
+ $db = clone($this->_db);
+ if (!$table = $this->table)
+ {
+ return $this->tree;
+ }
+ $sql = "SELECT * FROM {$table} WHERE parent_id =
{$parent}";
+
+ $db->query($sql, __LINE__, __FILE__);
+
+ while ($db->next_record())
+ {
+ $id = $db->f('id');
+ $this->tree[] = array
+ (
+ 'id' => $id,
+ 'name' => str_repeat('..', $level) .
$db->f($mapping['name'], true),
+ 'parent_id' => $parent
+ );
+ $this->get_children2($data, $id, $level + 1);
+ }
+ return $this->tree;
+ }
+
+ /**
+ * used for retrive a child-node from a hierarchy
+ *
+ * @param integer $entity_id Entity id
+ * @param integer $parent is the parent of the children we want
to see
+ * @param integer $level is increased when we go deeper into
the tree,
+ * @return array $child Children
+ */
+ protected function get_children( $data, $parent, $level )
+ {
+ $children = array();
+
+ $this->get_location_info($data['type'],
$data['type_id']);
+
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return $children;
+ }
+ $this->table = $table;
+
+ $filtermthod = 'WHERE parent_id = ' . (int)$parent;
+
+ $sql = "SELECT * FROM {$table} {$filtermthod}";
+ $this->_db2->query($sql, __LINE__, __FILE__);
+
+ $fields = array(0 => 'id');
+ foreach ($this->location_info['fields'] as $field)
+ {
+ $fields[] = $field['name'];
+ }
+
+ while ($this->_db2->next_record())
+ {
+ $id = $this->_db2->f('id');
+ foreach ($fields as $field)
+ {
+ $children[$id][$field] =
$this->_db2->f($field, true);
+ }
+ }
+
+ foreach ($children as &$child)
+ {
+ $_children = $this->get_children($data,
$child['id'], $level + 1);
+ if ($_children)
+ {
+ $child['children'] = $_children;
+ }
+ }
+ return $children;
+ }
+
+ /**
+ * Get tree from your node
+ * @param array $data - 'node_id' as parent and 'type'
+ * @return array tree
+ */
+ public function read_tree( $data )
+ {
+ $parent_id = isset($data['node_id']) &&
$data['node_id'] ? (int)$data['node_id'] : 0;
+ $tree = array();
+
+ $this->get_location_info($data['type'],
$data['type_id']);
+
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return $tree;
+ }
+ $this->table = $table;
+
+ if ($parent_id)
+ {
+ $filtermthod = "WHERE parent_id = {$parent_id}";
+ }
+ else
+ {
+ $filtermthod = 'WHERE (parent_id = 0 OR
parent_id IS NULL)';
+ }
+
+ if (isset($data['filter']) && is_array($data['filter']))
+ {
+ $_filter = array();
+ foreach ($data['filter'] as $_field => $_value)
+ {
+ $_filter[] = "{$_field} = '{$_value}'";
+ }
+ if ($_filter)
+ {
+ $filtermthod .= ' AND ' . implode(' AND
', $_filter);
+ }
+ }
+
+ $sql = "SELECT * FROM {$table} {$filtermthod}";
+
+ $this->_db2->query($sql, __LINE__, __FILE__);
+ $this->total_records = $this->_db2->num_rows();
+
+ $fields = array(0 => 'id');
+ foreach ($this->location_info['fields'] as $field)
+ {
+ $fields[] = $field['name'];
+ }
+ $node = array();
+ $i = 0;
+ while ($this->_db2->next_record())
+ {
+ $id = $this->_db2->f('id');
+
+ foreach ($fields as $field)
+ {
+ $tree[$i][$field] =
$this->_db2->f($field, true);
+ }
+ $i++;
+ }
+
+ foreach ($tree as &$node)
+ {
+ $children = $this->get_children($data,
$node['id'], 0);
+ if ($children)
+ {
+ $node['children'] = $children;
+ }
+ }
+ return $tree;
+ }
+
+ /**
+ * used for retrive the path for a particular node from a
hierarchy
+ *
+ * @param integer $node is the id of the node we want the path
of
+ * @return array $path Path
+ */
+ public function get_path( $data )
+ {
+
+ $this->get_location_info($data['type'],
$data['type_id']);
+
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return array();
+ }
+ $this->table = $table;
+
+ if (isset($this->location_info['mapping']) &&
$this->location_info['mapping'])
+ {
+ $mapping = $this->location_info['mapping'];
+ }
+ else
+ {
+ $mapping = array('name' => 'name');
+ }
+
+ $sql = "SELECT {$mapping['name']}, parent_id FROM
{$table} WHERE id = '{$data['id']}'";
+
+ $this->_db->query($sql, __LINE__, __FILE__);
+ $this->_db->next_record();
+
+ $parent_id = $this->_db->f('parent_id');
+
+ $name = $this->_db->f('name', true);
+
+ $path = array($name);
+
+ if ($parent_id)
+ {
+ $path =
array_merge($this->get_path(array('type' => $data['type'], 'id' =>
$parent_id)), $path);
+ }
+ return $path;
+ }
+
+ public function edit_field( $data = array() )
+ {
+ if (!isset($this->location_info['table']) || !$table =
$this->location_info['table'])
+ {
+ return false;
+ }
+
+ $value_set =
$this->_db->validate_update(array($data['field_name'] => $data['value']));
+ return $this->_db->query("UPDATE $table SET
{$value_set} WHERE {$this->location_info['id']['name']} = '{$data['id']}'",
__LINE__, __FILE__);
+ }
+ }
\ No newline at end of file
Modified: trunk/property/inc/class.uigeneric.inc.php
===================================================================
--- trunk/property/inc/class.uigeneric.inc.php 2016-09-16 01:43:02 UTC (rev
15683)
+++ trunk/property/inc/class.uigeneric.inc.php 2016-09-16 07:05:38 UTC (rev
15684)
@@ -62,10 +62,12 @@
function __construct()
{
parent::__construct();
+ $called_class = get_called_class();
+ $called_class_arr = explode('_', $called_class);
+ $appname = !empty($called_class_arr[0]) &&
!empty($GLOBALS['phpgw_info']['apps'][$called_class_arr[0]]) ?
$called_class_arr[0] : 'property';
+ $this->bo = CreateObject("{$appname}.bogeneric");
- //$GLOBALS['phpgw_info']['flags']['xslt_app'] = true;
$this->account =
$GLOBALS['phpgw_info']['user']['account_id'];
- $this->bo = CreateObject('property.bogeneric', true);
$this->bo->get_location_info();
$this->bocommon = & $this->bo->bocommon;
$this->custom = & $this->bo->custom;
| [Prev in Thread] | Current Thread | [Next in Thread] |