[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] phpgwapi/inc/class.categories.inc.php, 1.122
From: |
nomail |
Subject: |
[Phpgroupware-cvs] phpgwapi/inc/class.categories.inc.php, 1.122 |
Date: |
Thu, 30 Dec 2004 07:47:30 +0100 |
Update of /phpgwapi/inc
Added Files:
Branch:
class.categories.inc.php
date: 2004/12/30 06:47:30; author: skwashd; state: Exp; lines: +307 -326
Log Message:
new HEAD
=====================================================================
<?php
/**
* Category manager
* @author Joseph Engo <address@hidden>
* @author Bettina Gille <address@hidden>
* @copyright Copyright (C) 2000-2004 Free Software Foundation, Inc.
http://www.fsf.org/
* @license http://www.gnu.org/licenses/lgpl.html GNU Lesser General
Public License
* @package phpgwapi
* @subpackage utilities
* @version $Id: class.categories.inc.php,v 1.122 2004/12/30 06:47:30
skwashd Exp $
*/
/**
* Add ability for applications to make use of categories
*
* @package phpgwapi
* @subpackage utilities
* @internal Examples can be found in notes app
*/
class categories
{
var $account_id;
var $app_name;
var $cats;
var $db;
var $total_records;
var $grants;
/**
* Constructor
*
* @param integer $accountid Account id
* @param string $app_name Application name defaults to current
application
*/
function categories($accountid = '',$app_name = '')
{
$account_id = get_account_id($accountid);
if (! $app_name)
{
$app_name =
$GLOBALS['phpgw_info']['flags']['currentapp'];
}
$this->account_id = $account_id;
$this->app_name =
$GLOBALS['phpgw']->db->db_addslashes($app_name);
$this->db = $GLOBALS['phpgw']->db;
$this->db2 = $this->db;
$this->grants =
$GLOBALS['phpgw']->acl->get_grants($app_name);
}
/**
* Define filter type
*
* @param string $type Can be 'subs', 'mains', 'appandmains',
'appandsubs', 'noglobal' or 'noglobalapp'
* @return string|boolean Part of SQL where clause or false
*/
function filter($type)
{
switch ($type)
{
case 'subs': $s = ' AND cat_parent
!= 0'; break;
case 'mains': $s = ' AND cat_parent =
0'; break;
case 'appandmains': $s = " AND
cat_appname='" . $this->app_name . "' AND cat_parent =0"; break;
case 'appandsubs': $s = " AND
cat_appname='" . $this->app_name . "' AND cat_parent !=0"; break;
case 'noglobal': $s = " AND cat_appname
!= '" . $this->app_name . "'"; break;
case 'noglobalapp': $s = " AND cat_appname
= '" . $this->app_name . "' AND cat_owner != " . $this->account_id; break;
default: return False;
}
return $s;
}
/**
* Get the total number of categories
*
* @param string $for Can be 'app', 'appandmains', 'appandsubs',
'subs' or 'mains'
* @return integer|boolean Number of categories or false
*/
function total($for = 'app')
{
switch($for)
{
case 'app': $w = " WHERE
cat_appname='" . $this->app_name . "'"; break;
case 'appandmains': $w = " WHERE
cat_appname='" . $this->app_name . "' AND cat_parent =0"; break;
case 'appandsubs': $w = " WHERE
cat_appname='" . $this->app_name . "' AND cat_parent !=0"; break;
case 'subs': $w = ' WHERE cat_parent
!= 0'; break;
case 'mains': $w = ' WHERE cat_parent
= 0'; break;
default: return False;
}
$this->db->query("SELECT COUNT(cat_id) FROM
phpgw_categories $w",__LINE__,__FILE__);
$this->db->next_record();
return $this->db->f(0);
}
/**
* Get categories
*
* @param string $type Can be 'subs', 'mains', 'appandmains',
'appandsubs', 'noglobal' or 'noglobalapp'
* @param integer $start Start position
* @param integer $limit Limit for number of categories
* @param string $query Query to search for in cat_name and
cat_description
* @param string $sort Sort order 'ASC'ending or 'DESC'ending,
defaults to ascending
* @param string $order Fieldname(s) on which the result should
be ordered
* @param boolean $globals True or False, includes the global
phpgroupware categories or not
* @return array $cats Categories
*/
function return_array($type,$start,$limit = True,$query =
'',$sort = '',$order = '',$globals = False, $parent_id = '', $lastmod = -1,
$column = '')
{
//casting and addslashes for security
$start = intval($start);
$parent_id = intval($parent_id);
$query = $this->db->db_addslashes($query);
$sort = $this->db->db_addslashes($sort);
$order = $this->db->db_addslashes($order);
if ($globals)
{
$global_cats = " OR cat_appname='phpgw'";
}
$filter = $this->filter($type);
if (!$sort)
{
$sort = 'ASC';
}
if ($order)
{
$ordermethod = " ORDER BY $order $sort";
}
else
{
$ordermethod = ' ORDER BY cat_main, cat_level,
cat_name ASC';
}
if ($this->account_id == '-1')
{
$grant_cats = ' cat_owner=-1 ';
}
else
{
if (is_array($this->grants))
{
$grants = $this->grants;
while(list($user) = each($grants))
{
$public_user_list[] = $user;
}
reset($public_user_list);
$grant_cats = ' (cat_owner=' .
$this->account_id . " OR cat_owner=-1 OR cat_access='public' AND cat_owner in("
. implode(',',$public_user_list) . ')) ';
}
else
{
$grant_cats = ' cat_owner=' .
$this->account_id . ' OR cat_owner=-1 ';
}
}
if ($parent_id > 0)
{
$parent_filter = ' AND cat_parent=' .
$parent_id;
}
if ($query)
{
$querymethod = " AND (cat_name LIKE '%$query%'
OR cat_description LIKE '%$query%') ";
}
if($lastmod && $lastmod >= 0)
{
$querymethod .= ' AND last_mod > ' . $lastmod;
}
if ($column)
{
switch($column)
{
case 'id':
$table_column = ' cat_id '; break;
case 'owner': $table_column =
' cat_owner '; break;
case 'access': $table_column =
' cat_access '; break;
case 'app_name': $table_column =
' cat_appname '; break;
case 'main': $table_column =
' cat_main '; break;
case 'parent': $table_column =
' cat_parent '; break;
case 'name': $table_column =
' cat_name '; break;
case 'description': $table_column = '
cat_description '; break;
case 'data': $table_column =
' cat_data '; break;
case 'last_mod': $table_column =
' last_mod '; break;
default:
$table_column = ' cat_id '; break;
}
}
else
{
$table_column = ' * ';
}
$sql = "SELECT $table_column from phpgw_categories
WHERE (cat_appname='" . $this->app_name . "' AND" . $grant_cats . $global_cats
. ')'
. $parent_filter . $querymethod . $filter;
$this->db2->query($sql,__LINE__,__FILE__);
$this->total_records = $this->db2->num_rows();
if ($limit)
{
$this->db->limit_query($sql .
$ordermethod,$start,__LINE__,__FILE__);
}
else
{
$this->db->query($sql .
$ordermethod,__LINE__,__FILE__);
}
while ($this->db->next_record())
{
if ($column)
{
$cats[] = array
(
"$column" => $this->db->f(0)
);
}
else
{
$cats[] = array
(
'id' =>
$this->db->f('cat_id'),
'owner' =>
$this->db->f('cat_owner'),
'access' =>
$this->db->f('cat_access'),
'app_name' =>
$this->db->f('cat_appname'),
'main' =>
$this->db->f('cat_main'),
'level' =>
$this->db->f('cat_level'),
'parent' =>
$this->db->f('cat_parent'),
'name' =>
$this->db->f('cat_name'),
'description' =>
$this->db->f('cat_description'),
'data' =>
$this->db->f('cat_data'),
'last_mod' =>
$this->db->f('last_mod')
);
}
}
return $cats;
}
function return_sorted_array($start,$limit = True,$query =
'',$sort = '',$order = '',$globals = False, $parent_id = '')
{
//casting and slashes for security
$start = intval($start);
$query = $this->db->db_addslashes($query);
$sort =
$sort?$this->db->db_addslashes($sort):'ASC';
$order =
$order?$this->db->db_addslashes($order):'cat_name';
$parent_id = intval($parent_id);
if ($globals)
{
$global_cats = " OR cat_appname='phpgw'";
}
$ordermethod = " ORDER BY $order $sort";
if ($this->account_id == '-1')
{
$grant_cats = " cat_owner='-1' ";
}
else
{
if (is_array($this->grants))
{
$grants = $this->grants;
while(list($user) = each($grants))
{
$public_user_list[] = $user;
}
reset($public_user_list);
$grant_cats = " (cat_owner='" .
$this->account_id . "' OR cat_owner='-1' OR cat_access='public' AND cat_owner
in(" . implode(',',$public_user_list) . ")) ";
}
else
{
$grant_cats = " cat_owner='" .
$this->account_id . "' or cat_owner='-1' ";
}
}
$parent_select = ' AND cat_parent=' . $parent_id;
if ($query)
{
$querymethod = " AND (cat_name LIKE '%$query%'
OR cat_description LIKE '%$query%') ";
}
$sql = "SELECT * from phpgw_categories WHERE
(cat_appname='" . $this->app_name . "' AND" . $grant_cats . $global_cats . ")"
. $querymethod;
$this->db->query($sql . $parent_select .
$ordermethod,__LINE__,__FILE__);
$total = $this->db->num_rows();
while ($this->db->next_record())
{
$cats[] = array
(
'id' =>
(int)$this->db->f('cat_id'),
'owner' =>
(int)$this->db->f('cat_owner'),
'access' =>
$this->db->f('cat_access'),
'app_name' =>
$this->db->f('cat_appname'),
'main' =>
(int)$this->db->f('cat_main'),
'level' =>
(int)$this->db->f('cat_level'),
'parent' =>
(int)$this->db->f('cat_parent'),
'name' =>
$this->db->f('cat_name'),
'description' =>
$this->db->f('cat_description'),
'data' =>
$this->db->f('cat_data')
);
}
$num_cats = count($cats);
for ($i=0;$i < $num_cats;$i++)
{
$sub_select = ' AND cat_parent=' .
$cats[$i]['id'] . ' AND cat_level=' . ($cats[$i]['level']+1);
$this->db->query($sql . $sub_select .
$ordermethod,__LINE__,__FILE__);
$total += $this->db->num_rows();
$subcats = array();
$j = 0;
while ($this->db->next_record())
{
$subcats[$j]['id'] =
(int)$this->db->f('cat_id');
$subcats[$j]['owner'] =
(int)$this->db->f('cat_owner');
$subcats[$j]['access'] =
$this->db->f('cat_access');
$subcats[$j]['app_name'] =
$this->db->f('cat_appname');
$subcats[$j]['main'] =
(int)$this->db->f('cat_main');
$subcats[$j]['level'] =
(int)$this->db->f('cat_level');
$subcats[$j]['parent'] =
(int)$this->db->f('cat_parent');
$subcats[$j]['name'] =
$this->db->f('cat_name');
$subcats[$j]['description'] =
$this->db->f('cat_description');
$subcats[$j]['data'] =
$this->db->f('cat_data');
$j++;
}
$num_subcats = count($subcats);
if ($num_subcats != 0)
{
$newcats = array();
for ($k = 0; $k <= $i; $k++)
{
$newcats[$k] = $cats[$k];
}
for ($k = 0; $k < $num_subcats; $k++)
{
$newcats[$k+$i+1] =
$subcats[$k];
}
for ($k = $i+1; $k < $num_cats; $k++)
{
$newcats[$k+$num_subcats] =
$cats[$k];
}
$cats = $newcats;
$num_cats = count($cats);
}
}
$this->total_records = $total;
if ($limit)
{
$max =
$GLOBALS['phpgw_info']['user']['preferences']['common']['maxmatchs'];
$max = $max + $start;
$k=0;
for($i=$start;$i<$max;++$i)
{
if(is_array($cats[$i]))
{
$scats[$k] = $cats[$i];
++$k;
}
}
if(is_array($scats))
{
$cats = $scats;
}
}
return $cats;
}
/**
* Get single category
*
* @param integer $id Category id
* @return array $cats Information for one category in index 0.
Includes the fields:
* 'id', 'owner', 'access', 'app_name', 'main', 'level',
'parent', 'name', 'description', 'data'
*/
function return_single($id = '')
{
$this->db->query('SELECT * FROM phpgw_categories WHERE
cat_id=' . intval($id),__LINE__,__FILE__);
if ($this->db->next_record())
{
$cats[0]['id'] =
$this->db->f('cat_id');
$cats[0]['owner'] =
$this->db->f('cat_owner');
$cats[0]['access'] =
$this->db->f('cat_access');
$cats[0]['app_name'] =
$this->db->f('cat_appname');
$cats[0]['main'] =
$this->db->f('cat_main');
$cats[0]['level'] =
$this->db->f('cat_level');
$cats[0]['parent'] =
$this->db->f('cat_parent');
$cats[0]['name'] =
$this->db->f('cat_name');
$cats[0]['description'] =
$this->db->f('cat_description');
$cats[0]['data'] =
$this->db->f('cat_data');
}
return $cats;
}
/**
* Return into a select box, list or other formats
*
* @param string|array $format Currently supports 'select'
(select box) or 'list'
* @param string $type Can be 'all' or something different
* @param array|string $selected Cat_id (list) or array with
cat_id values
* @param boolean $globals True or False, includes the global
phpgroupware categories or not
* @param string $site_link URL
* @return array Categories
*/
function formatted_list($format,$type='',$selected =
'',$globals = False,$site_link = 'site')
{
return
$this->formated_list($format,$type,$selected,$globals,$site_link);
}
function formated_list($format,$type='',$selected = '',$globals
= False,$site_link = 'site')
{
if(is_array($format))
{
$temp_format = $format['format'];
$type = ($format['type']?$format['type']:'all');
$selected =
(isset($format['selected'])?$format['selected']:'');
$self =
(isset($format['self'])?$format['self']:'');
$globals =
(isset($format['globals'])?$format['globals']:True);
$site_link =
(isset($format['site_link'])?$format['site_link']:'site');
settype($format,'string');
$format = ($temp_format?$temp_format:'select');
unset($temp_format);
}
if (!is_array($selected))
{
$selected = explode(',',$selected);
}
if ($type != 'all')
{
$cats =
$this->return_array($type,$start,False,$query,$sort,$order,$globals);
}
else
{
$cats =
$this->return_sorted_array($start,False,$query,$sort,$order,$globals);
}
if($self)
{
for ($i=0;$i<count($cats);++$i)
{
if ($cats[$i]['id'] == $self)
{
unset($cats[$i]);
}
}
}
if ($format == 'select')
{
while (is_array($cats) && (list(,$cat) =
each($cats)))
{
$s .= '<option value="' . $cat['id'] .
'"';
if (in_array($cat['id'],$selected))
{
$s .= ' selected="selected"';
}
$s .= '>';
for ($j=0;$j<$cat['level'];++$j)
{
$s .= ' ';
}
$s .=
$GLOBALS['phpgw']->strip_html($cat['name']);
if ($cat['app_name'] == 'phpgw')
{
$s .= ' <' .
lang('Global') . '>';
}
if ($cat['owner'] == '-1')
{
$s .= ' <' .
lang('Global') . ' ' . lang($this->app_name) . '>';
}
$s .= '</option>' . "\n";
}
return $s;
}
if ($format == 'list')
{
$space = ' ';
$s = '<table border="0" cellpadding="2"
cellspacing="2">' . "\n";
if ($this->total_records > 0)
{
for ($i=0;$i<count($cats);++$i)
{
$image_set = ' ';
if
(in_array($cats[$i]['id'],$selected))
{
$image_set = '<img
src="' . PHPGW_IMAGES_DIR . '/roter_pfeil.gif" />';
}
if (($cats[$i]['level'] == 0)
&& !in_array($cats[$i]['id'],$selected))
{
$image_set = '<img
src="' . PHPGW_IMAGES_DIR . '/grauer_pfeil.gif" />';
}
$space_set =
str_repeat($space,$cats[$i]['level']);
$s .= '<tr>' . "\n";
$s .= '<td width="8">' .
$image_set . '</td>' . "\n";
$s .= '<td>' . $space_set . '<a
href="' . $GLOBALS['phpgw']->link($site_link,'cat_id=' . $cats[$i]['id']) . '">'
.
$GLOBALS['phpgw']->strip_html($cats[$i]['name'])
. '</a></td>' . "\n"
. '</tr>' . "\n";
}
}
$s .= '</table>' . "\n";
return $s;
}
}
function formatted_xslt_list($data=0)
{
if(is_array($data))
{
$format =
(isset($data['format'])?$data['format']:'filter');
$type =
(isset($data['type'])?$data['type']:'all');
$selected =
(isset($data['selected'])?$data['selected']:'');
$self =
(isset($data['self'])?$data['self']:'');
$globals =
(isset($data['globals'])?$data['globals']:True);
$link_data =
(isset($data['link_data'])?$data['link_data']:0);
$select_name =
(isset($data['select_name'])?$data['select_name']:'cat_id');
}
else
{
return False;
}
if (!is_array($selected))
{
$selected = explode(',',$selected);
}
if ($type != 'all')
{
$cats =
$this->return_array($type,$start,False,$query,$sort,$order,$globals);
}
else
{
$cats =
$this->return_sorted_array($start,False,$query,$sort,$order,$globals);
}
$GLOBALS['phpgw']->xslttpl->add_file($GLOBALS['phpgw']->common->get_tpl_dir('phpgwapi','default')
. SEP . 'categories');
if($self)
{
for ($i=0;$i<count($cats);$i++)
{
if ($cats[$i]['id'] == $self)
{
unset($cats[$i]);
}
}
reset($cats);
}
while (is_array($cats) && list(,$cat) = each($cats))
{
$sel_cat = '';
if (in_array($cat['id'],$selected))
{
$sel_cat = 'selected';
}
$name = '';
for ($i=0;$i<$cat['level'];$i++)
{
$name .= ' . ';
}
$name .=
$GLOBALS['phpgw']->strip_html($cat['name']);
if ($cat['app_name'] == 'phpgw')
{
$name .= ' <' . lang('Global') . '>';
}
if ($cat['owner'] == '-1')
{
$name .= ' <' . lang('Global') . ' ' .
lang($this->app_name) . '>';
}
$cat_list[] = array
(
'cat_id' => $cat['id'],
'name' => $name,
'selected' => $sel_cat
);
}
$cat_data = array
(
'cat_list' =>
$cat_list,
'lang_no_cat' => lang('no
category'),
'lang_cat_statustext' => lang('Select the
category the data belong to. To do not use a category select NO CATEGORY'),
'select_url' =>
$GLOBALS['phpgw']->link('/index.php',$link_data),
'select_name' => $select_name,
'lang_submit' =>
lang('submit')
);
return $cat_data;
}
/**
* Add category
*
* @param array $values Array with the following fields: 'id',
'parent', 'level', 'main', 'descr', 'name', 'data', 'access'
* @return integer Id for the new category
*/
function add($values)
{
$values['id'] = intval($values['id']);
$values['parent'] = intval($values['parent']);
if ($values['parent'] > 0)
{
$values['level'] =
$this->id2name($values['parent'],'level')+1;
$values['main'] =
$this->id2name($values['parent'],'main');
}
$values['descr'] =
$this->db->db_addslashes($values['descr']);
$values['name'] =
$this->db->db_addslashes($values['name']);
if ($values['id'] > 0)
{
$id_col = 'cat_id,';
$id_val = $values['id'] . ',';
}
$this->db->query('INSERT INTO phpgw_categories (' .
$id_col .
'cat_parent,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data,'
. 'cat_main,cat_level, last_mod) VALUES (' .
$id_val . intval($values['parent']) . ',' . $this->account_id . ",'" .
$values['access']
. "','" . $this->app_name . "','" .
$values['name'] . "','" . $values['descr'] . "','" . $values['data']
. "'," . intval($values['main']) . ',' .
intval($values['level']) . ',' . time() . ')',__LINE__,__FILE__);
if ($values['id'] > 0)
{
$max = $values['id'];
}
else
{
$max =
$this->db->get_last_insert_id('phpgw_categories','cat_id');
}
$max = intval($max);
if ($values['parent'] == 0)
{
$this->db->query('UPDATE phpgw_categories SET
cat_main=' . $max . ' WHERE cat_id=' . $max,__LINE__,__FILE__);
}
return $max;
}
/**
* Delete category
*
* @param integer $cat_id Category id
* @param boolean $drop_subs Delete subcategroies
* @param boolean $modify_subs Modify subcategories
*/
/*function delete($cat_id,$subs = False)
{
$cat_id = intval($cat_id);
if ($subs)
{
$subdelete = ' OR cat_parent=' . $cat_id . ' OR
cat_main=' . $cat_id;
}
$this->db->query('DELETE FROM phpgw_categories WHERE
cat_id=' . $cat_id . $subdelete . " AND cat_appname='"
. $this->app_name .
"'",__LINE__,__FILE__);
} */
function delete($cat_id, $drop_subs = False, $modify_subs =
False)
{
$cat_id = intval($cat_id);
if ($drop_subs)
{
$subdelete = ' OR cat_parent=' . $cat_id . ' OR
cat_main=' . $cat_id;
}
if ($modify_subs)
{
$cats =
$this->return_sorted_array('',False,'','','',False, $cat_id);
$new_parent = $this->id2name($cat_id,'parent');
for ($i=0;$i<count($cats);$i++)
{
if ($cats[$i]['level'] == 1)
{
$this->db->query('UPDATE
phpgw_categories set cat_level=0, cat_parent=0, cat_main=' .
intval($cats[$i]['id'])
. ' WHERE cat_id=' . intval($cats[$i]['id']) . " AND cat_appname='" .
$this->app_name . "'",__LINE__,__FILE__);
$new_main = $cats[$i]['id'];
}
else
{
if ($new_main)
{
$update_main =
',cat_main=' . $new_main;
}
if ($cats[$i]['parent'] ==
$cat_id)
{
$update_parent =
',cat_parent=' . $new_parent;
}
$this->db->query('UPDATE
phpgw_categories set cat_level=' . ($cats[$i]['level']-1) . $update_main .
$update_parent
. ' WHERE cat_id=' . intval($cats[$i]['id']) . " AND cat_appname='" .
$this->app_name . "'",__LINE__,__FILE__);
}
}
}
$this->db->query('DELETE FROM phpgw_categories WHERE
cat_id=' . $cat_id . $subdelete . " AND cat_appname='"
. $this->app_name .
"'",__LINE__,__FILE__);
}
/**
* Edit a category
*
* @param array $values Array with the following fields: 'id',
'parent', 'old_parent', 'level', 'main', 'descr', 'name', 'data', 'access'
* @return integer Category id
*/
function edit($values)
{
$values['id'] = intval($values['id']);
$values['parent'] = intval($values['parent']);
if (isset($values['old_parent']) &&
intval($values['old_parent']) != $values['parent'])
{
$this->delete($values['id'],False,True);
return $this->add($values);
}
else
{
if ($values['parent'] > 0)
{
$values['main'] =
intval($this->id2name($values['parent'],'main'));
$values['level'] =
intval($this->id2name($values['parent'],'level')+1);
}
else
{
$values['main'] = $values['id'];
$values['level'] = 0;
}
}
$values['descr'] =
$this->db->db_addslashes($values['descr']);
$values['name'] =
$this->db->db_addslashes($values['name']);
$sql = "UPDATE phpgw_categories SET cat_name='" .
$values['name'] . "', cat_description='" . $values['descr']
. "', cat_data='" . $values['data'] .
"', cat_parent=" . $values['parent'] . ", cat_access='"
. $values['access'] . "', cat_main=" .
$values['main'] . ', cat_level=' . $values['level'] . ',last_mod=' . time()
. " WHERE cat_appname='" .
$this->app_name . "' AND cat_id=" . $values['id'];
$this->db->query($sql,__LINE__,__FILE__);
return $values['id'];
}
function name2id($cat_name)
{
$this->db->query("SELECT cat_id FROM phpgw_categories
WHERE cat_name='" . $this->db->db_addslashes($cat_name) . "' "
."AND cat_appname='" .
$this->app_name . "' AND (cat_owner=" . $this->account_id . ' OR
cat_owner=-1)',__LINE__,__FILE__);
if(!$this->db->num_rows())
{
return 0;
}
$this->db->next_record();
return $this->db->f('cat_id');
}
function id2name($cat_id = '', $item = 'name')
{
$cat_id = intval($cat_id);
if ($cat_id == 0)
{
return '--';
}
switch($item)
{
case 'name': $value = 'cat_name'; break;
case 'owner': $value = 'cat_owner'; break;
case 'main': $value = 'cat_main'; break;
case 'level': $value = 'cat_level'; break;
case 'parent': $value = 'cat_parent'; break;
}
$this->db->query("SELECT $value FROM phpgw_categories
WHERE cat_id=" . $cat_id,__LINE__,__FILE__);
$this->db->next_record();
if ($this->db->f($value))
{
return $this->db->f($value);
}
else
{
if ($item == 'name')
{
return '--';
}
}
}
/**
* Return category name given $cat_id
*
* @param $cat_id Category id
* @return string Category name
* @deprecated This is only a temp wrapper, use id2name() to
keep things matching across the board.
*/
function return_name($cat_id)
{
return $this->id2name($cat_id);
}
/**
* Test if a category name exists
*
* @param $type Can be 'subs', 'mains', 'appandmains',
'appandsubs', 'noglobal' or 'noglobalapp'
* @param $cat_name Category name
* @param $cat_id Category ID
* @return boolean True when the category exists otherwise false
*/
function exists($type,$cat_name = '',$cat_id = '')
{
$cat_id = intval($cat_id);
$filter = $this->filter($type);
if ($cat_name)
{
$cat_exists = " cat_name='" .
$this->db->db_addslashes($cat_name) . "' ";
}
if ($cat_id)
{
$cat_exists = ' cat_parent=' . $cat_id;
}
if ($cat_name && $cat_id)
{
$cat_exists = " cat_name='" .
$this->db->db_addslashes($cat_name) . "' AND cat_id != $cat_id ";
}
$this->db->query("SELECT COUNT(cat_id) FROM
phpgw_categories WHERE $cat_exists $filter",__LINE__,__FILE__);
$this->db->next_record();
if ($this->db->f(0))
{
return True;
}
else
{
return False;
}
}
}
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] phpgwapi/inc/class.categories.inc.php, 1.122,
nomail <=