[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] phpgwapi/inc/class.contact_org.inc.php, 1.2
From: |
nomail |
Subject: |
[Phpgroupware-cvs] phpgwapi/inc/class.contact_org.inc.php, 1.2 |
Date: |
Thu, 30 Dec 2004 07:47:30 +0100 |
Update of /phpgwapi/inc
Added Files:
Branch:
class.contact_org.inc.php
date: 2004/12/30 06:47:30; author: skwashd; state: Exp; lines: +156 -0
Log Message:
new HEAD
=====================================================================
<?php
/**
* Query statements for "org" table
* @author Edgar Antonio Luna <address@hidden>
* @copyright Copyright (C) 2003,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 contacts
* @version $Id: class.contact_org.inc.php,v 1.2 2004/12/30 06:47:30
skwashd Exp $
*/
/**
* Use SQL criteria
*/
include_once(PHPGW_API_INC . '/class.sql_criteria.inc.php');
/**
* Use SQL entity
*/
include_once(PHPGW_API_INC . '/class.sql_entity.inc.php');
/**
* Query statements for "org" table
*
* @package phpgwapi
* @subpackage contacts
*/
class contact_org extends sql_entity
{
var $map = array('org_id' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' =>
'org_id',
'type' =>
'integer'),
'org_name' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' =>
'name',
'type' =>
'string'),
'org_active' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' =>
'active',
'type' =>
'string'),
'org_parent' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' =>
'parent',
'type' =>
'integer'),
'org_creaton' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' =>
'created_on',
'type' =>
'integer'),
'org_creatby' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' =>
'created_by',
'type' =>
'integer'),
'org_modon' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' =>
'modified_on',
'type' =>
'integer'),
'org_modby' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' =>
'modified_by',
'type' =>
'integer'),
'name' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' => ''),
'count_orgs' => array('select' => '',
'criteria' => '',
'insert' => '',
'update' => '',
'delete' => '',
'sort' => '',
'field' => ''),
'people_org' => array('select' =>
'unlink_org'),
'organizations'=> array('select' =>
'relink_org_person'),
'orgs_local' => array('select' =>
'relink_org_person'));
function contact_org ($ali = '', $field = '', $criteria =
'')
{
$this->_constructor('phpgw_contact_org', 'contact_org');
if($field)
{
$this->add_select($field);
}
if($criteria)
{
$this->add_criteria($criteria);
}
$this->set_ilinks('org_id',
'phpgwapi.contact_central','contact_id', PHPGW_SQL_REQUIRED_KEY);
$this->set_ilinks('org_id',
'phpgwapi.contact_org_person','my_org_id', PHPGW_SQL_LAZY_KEY);
}
function unlink_org()
{
unset($this->ilink['phpgwapi.contact_central']);
}
function relink_org_person()
{
unset($this->ilink['phpgwapi.contact_org_person']);
$this->set_elinks('org_id',
'phpgwapi.contact_org_person', 'my_org_id');
}
function criteria_org_id($element)
{
$field = $this->put_alias($element['real_field']);
if(is_array($element['value']))
{
$this->_add_criteria(sql_criteria::in($field,
$element['value']));
}
else
{
$this->_add_criteria(sql_criteria::equal($field, $element['value']));
}
}
function select_count_orgs()
{
$this->add_field('count_orgs', 'count(org_id)');
}
}
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] phpgwapi/inc/class.contact_org.inc.php, 1.2,
nomail <=