[ Index ]
 

Code source de eGroupWare 1.2.106-2

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/projectmanager/inc/ -> class.soprojectelements.inc.php (sommaire)

(pas de description)

Poids: 218 lignes (8 kb)
Inclus ou requis: 1 fois
Référencé: 0 fois
Nécessite: 1 fichier
 etemplate/inc/class.so_sql.inc.php

Définit 1 class

soprojectelements:: (5 méthodes):
  soprojectelements()
  summary()
  search()
  _fix_filter()
  read()


Classe: soprojectelements  - X-Ref

Elements storage object of the projectmanager

Tables: egw_pm_elements, egw_links

A project P is the parent of an other project C, if link_id1=P.pm_id and link_id2=C.pm_id !

soprojectelements($pm_id=null,$pe_id=null)   X-Ref
Constructor, calls the constructor of the extended class

It is sufficent to give just the pe_id, as it is unique!

param: int $pm_id pm_id of the project to use, default null
param: int $pe_id pe_id of the project-element to load, default null

summary($pm_id=null,$filter=array()   X-Ref
Summarize the information of all elements of a project: min(start-time), sum(time), avg(completion), ...

param: int/array $pm_id=null int project-id, array of project-id's or null to use $this->pm_id
param: array $filter=array() columname => value pairs to filter, eg. '
return: array/boolean with summary information (keys as for a single project-element), false on error

search($criteria,$only_keys=True,$order_by='',$extra_cols='',$wildcard='',$empty=False,$op='AND',$start=false,$filter=null,$join=true)   X-Ref
search elements, reimplemented to use $this->pm_id, if no pm_id given in criteria or filter

param: array/string $criteria array of key and data cols, OR a SQL query (content for WHERE), fully quoted (!)
param: boolean $only_keys True returns only keys, False returns all cols
param: string $order_by fieldnames + {ASC|DESC} separated by colons ','
param: string/array $extra_cols string or array of strings to be added to the SELECT, eg. "count(*) as num"
param: string $wildcard appended befor and after each criteria
param: boolean $empty False=empty criteria are ignored in query, True=empty have to be empty in row
param: string $op defaults to 'AND', can be set to 'OR' too, then criteria's are OR'ed together
param: int/boolean $start if != false, return only maxmatch rows begining with start
param: array $filter if set (!=null) col-data pairs, to be and-ed (!) into the query without wildcards
param: string/boolean $join=true default join with links-table or string as in so_sql
return: array of matching rows (the row is an array of the cols) or False

_fix_filter($filter)   X-Ref
Pas de description

read($keys,$extra_cols='',$join=true)   X-Ref
reads one project-element specified by $keys, reimplemented to use $this->pm_id, if no pm_id given

param: array $keys array with keys in form internalName => value, may be a scalar value if only one key
param: string/array $extra_cols string or array of strings to be added to the SELECT, eg. "count(*) as num"
param: string/boolean $join=true default join with links-table or string as in so_sql
return: array/boolean data if row could be retrived else False



Généré le : Sun Feb 25 17:20:01 2007 par Balluche grâce à PHPXref 0.7