Helix Installation   Getting Started   Reference Documentation   Global Functions   Quick Start
ModulesClassesFunctions
 

Class Reference

class employee extends employee_ext

Hide Inherited MembersHuman Resources
Description
No description.
 
Constants
constantTABLENAME ["hr_employee"][ employee ]
 
Properties
protected_cdate[ employee_db ]
protected_cdate_dirty[ employee_db ]
protected_code[ employee_db ]
protected_code_dirty[ employee_db ]
protected_deleted[ employee_db ]
protected_deleted_dirty[ employee_db ]
protected_department_id[ employee_db ]
protected_department_id_dirty[ employee_db ]
protected_description[ entity_db ]
protected_description_dirty[ entity_db ]
protected_dirty[ obj ]
protected_employee_type_id[ employee_db ]
protected_employee_type_id_dirty[ employee_db ]
protected_employeestatus_id[ employee_db ]
protected_employeestatus_id_dirty[ employee_db ]
protected_entity_id[ person_db ]
protected_entity_id_dirty[ person_db ]
protected_entity_type_id[ entity_db ]
protected_entity_type_id_dirty[ entity_db ]
protected_first_name[ person_db ]
protected_first_name_dirty[ person_db ]
protected_id[ entity_db ]
protected__id[ employee_db ]
protected_id_dirty[ entity_db ]
protected__id_dirty[ employee_db ]
protected_initials[ person_db ]
protected_initials_dirty[ person_db ]
protected_last_name[ person_db ]
protected_last_name_dirty[ person_db ]
protected_mdate[ employee_db ]
protected_mdate_dirty[ employee_db ]
protected_middle_name[ person_db ]
protected_middle_name_dirty[ person_db ]
protected_nickname[ person_db ]
protected_nickname_dirty[ person_db ]
protected_person_entity_id[ employee_db ]
protected_person_entity_id_dirty[ employee_db ]
protected_person_type_id[ person_db ]
protected_person_type_id_dirty[ person_db ]
publicproperty_objects_array[ obj ]
protected_suffix[ person_db ]
protected_suffix_dirty[ person_db ]
protected_title[ employee_db ]
protected_title_dirty[ employee_db ]
 
Methods
publiccommit ( )[ employee_db ]
Parameters
No parameters for this method
Code
157  public function commit()
158  {
159      if ($this->_person_entity_id > 0)
160      {
161          $this->update();
162      }
163      else
164      {
165          $this->insert();
166      }
167 
168      foreach ($this->property_objects_array as $property=>$object)
169      {
170          $this->{$property} = $object;
171      }
172 
173      return true;
174  }
public__construct ( person_entity_id , code )[ employee_db ]
Parameters
optionalperson_entity_id
optionalcode
Code
050  public function __construct($__person_entity_id=null, $__code=null)
051  {
052      $this->__id = 0;
053      $this->_person_entity_id = 0;
054      $this->_code = $__code;
055      $this->_title = "";
056      $this->_employee_type_id = 0;
057      $this->_employeestatus_id = 0;
058      $this->_department_id = 0;
059      $this->_mdate = null;
060      $this->_cdate = null;
061      $this->_deleted = false;
062      $this->_entity_id = 0;
063      $this->_first_name = "";
064      $this->_middle_name = "";
065      $this->_last_name = "";
066      $this->_suffix = "";
067      $this->_nickname = "";
068      $this->_initials = "";
069      $this->_person_type_id = 0;
070      $this->_id = 0;
071      $this->_description = "";
072      $this->_entity_type_id = 0;
073 
074      $this->__id_dirty = false;
075      $this->_person_entity_id_dirty = false;
076      $this->_code_dirty = false;
077      $this->_title_dirty = false;
078      $this->_employee_type_id_dirty = false;
079      $this->_employeestatus_id_dirty = false;
080      $this->_department_id_dirty = false;
081      $this->_mdate_dirty = false;
082      $this->_cdate_dirty = false;
083      $this->_deleted_dirty = false;
084      $this->_entity_id_dirty = false;
085      $this->_first_name_dirty = false;
086      $this->_middle_name_dirty = false;
087      $this->_last_name_dirty = false;
088      $this->_suffix_dirty = false;
089      $this->_nickname_dirty = false;
090      $this->_initials_dirty = false;
091      $this->_person_type_id_dirty = false;
092      $this->_id_dirty = false;
093      $this->_description_dirty = false;
094      $this->_entity_type_id_dirty = false;
095 
096      if (is_null($__person_entity_id) && is_null($__code))
097      {
098          return;
099      }
100 
101      $db = employee::db();
102      $q  = " SELECT cor_entity.id,cor_entity.description,cor_entity.entity_type_id,cor_person.entity_id,cor_person.first_name,cor_person.middle_name,cor_person.last_name,cor_person.suffix,cor_person.nickname,cor_person.initials,cor_person.person_type_id,hr_employee._id,hr_employee.person_entity_id,hr_employee.code,hr_employee.title,hr_employee.employee_type_id,hr_employee.employeestatus_id,hr_employee.department_id,hr_employee.mdate,hr_employee.cdate,hr_employee.deleted ";
103      $q .= " FROM hr_employee ";
104      $q .= " INNER JOIN cor_person ON hr_employee.person_entity_id=cor_person.entity_id ";
105      $q .= is_null($__person_entity_id) ? "" : " AND cor_person.entity_id='$__person_entity_id' ";
106      $q .= is_null($__code) ? "" : " AND hr_employee.code='$__code' ";
107      $q .= " INNER JOIN cor_entity ON cor_person.entity_id=cor_entity.id ";       
108 
109      $db->query($q);
110      if ($db->next_record() && $db->num_rows() == 1)
111      {
112          $this->_id = $db->f("id");
113          $this->_description = $db->f("description");
114          $this->_entity_type_id = $db->f("entity_type_id");
115          $this->_entity_id = $db->f("entity_id");
116          $this->_first_name = $db->f("first_name");
117          $this->_middle_name = $db->f("middle_name");
118          $this->_last_name = $db->f("last_name");
119          $this->_suffix = $db->f("suffix");
120          $this->_nickname = $db->f("nickname");
121          $this->_initials = $db->f("initials");
122          $this->_person_type_id = $db->f("person_type_id");
123          $this->__id = $db->f("_id");
124          $this->_person_entity_id = $db->f("person_entity_id");
125          $this->_code = $db->f("code");
126          $this->_title = $db->f("title");
127          $this->_employee_type_id = $db->f("employee_type_id");
128          $this->_employeestatus_id = $db->f("employeestatus_id");
129          $this->_department_id = $db->f("department_id");
130          $this->_mdate = $db->f("mdate");
131          $this->_cdate = $db->f("cdate");
132          $this->_deleted = $db->f("deleted");
133      }
134  }
protected staticdb ( )[ employee_db ]
Parameters
No parameters for this method
Code
966  protected static function db()
967  {
968      return new db();
969  }
public staticddl ( value )[ employee_ext ]
Parameters
optionalvalue
Code
055  public static function ddl($value=null)
056  {
057      $db = new db;
058      $ids = array();
059      $q  = "
060          SELECT entity_id, concat(last_name,', ',first_name) as name
061          FROM hr_employee e INNER JOIN cor_person p ON e.person_entity_id=p.entity_id AND e.deleted=0 AND length(concat(last_name,', ',first_name))>0
062          ORDER BY last_name
063      ";
064     
065      $db->query($q);
066     
067      $select = new select($name);
068     
069      while ($db->next_record())
070      {
071          $select->add($db->f("entity_id"),$db->f("name"));
072      }
073      if (!is_null($value))
074      {
075          $select->value = $value;
076      }
077      return $select;
078  }
publicdelete ( )[ employee_db ]
Parameters
No parameters for this method
Code
224  public function delete()
225  {
226      parent::delete();
227      $db = employee::db();
228      $q  = " UPDATE hr_employee SET ";
229      $q .= " deleted = 1 ";
230      $q .= " WHERE person_entity_id = " . $this->_person_entity_id;
231      $db->query($q);
232      $this->deleted = true;
233      return true;
234  }
public staticdelete_all ( )[ employee_db ]
Parameters
No parameters for this method
Code
340  public static function delete_all()
341  {
342      $db = employee::db();
343      $q  = " UPDATE hr_employee SET ";
344      $q .= " deleted = 1 ";
345     
346      $db->query($q);
347      return true;
348  }
public__get ( p )[ obj ]
Parameters
requiredp
Code
007  public function __get($p)
008  {
009      $methods = get_class_methods($this);
010      $properties = get_object_vars($this);
011      if (in_array("get_$p",$methods))
012      {
013          return $this->{"get_$p"}();
014      }
015      else if (array_key_exists("_$p",$properties))
016      {
017          return $this->{"_$p"};
018      }
019      else if (in_array("get_" . substr($p,strpos($p,"_")+1), $methods))
020      {
021          return $this->{"get_" . substr($p,strpos($p,"_")+1)}(substr($p,0,strpos($p,"_")));
022      }
023      else
024      {
025          trigger_error("This object [" . get_class($this) . ":$this->id] has no private property '_$p' for the requested public property '$p'",E_USER_WARNING);
026          return null;
027      }
028  }
publicget_address ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
938  public function get_address($__type="default")
939  {
940      $object = is_null(keyval($this->property_objects_array,"{$__type}_address")) ? new address($this->get_address_id($__type)) : $this->property_objects_array["{$__type}_address"];
941      $this->property_objects_array["{$__type}_address"] = $object;
942      return $object;
943  }
publicget_address_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
944  public function get_address_id($__type="default")
945  {
946      $ids = $this->get_address_ids($__type, true);
947      return (count($ids)==1 ? $ids[0] : null);
948  }
publicget_address_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
949  public function get_address_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
950  {
951      $address_ids = array();
952      $db = entity::db();
953      $q  = " SELECT cor_address.id FROM cor_address_entity INNER JOIN cor_address ON cor_address_entity.address_id=cor_address.id AND cor_address_entity.deleted=0 AND cor_address.deleted=0 AND cor_address_entity.entity_id='$this->id' " . (is_null($__type) ? "" : " AND cor_address_entity.address_entity_type_id='" . address_entity::type_id($__type) . "'") . ($__get_primary ? " AND cor_address_entity.primary=1 " : "");
954      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
955      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
956      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
957      $db->query($q);
958      while ($db->next_record())
959      {
960          $address_ids[] = $db->f("id");
961      }
962      return $address_ids;
963  }
publicget_address_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
964  public function get_address_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
965  {
966      $ids = $this->get_address_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
967      $objects = array();
968      foreach ($ids as $index=>$id)
969      {
970          $objects[$index] = new address($id);
971      }
972      return $objects;
973  }
publicget_array ( )[ obj ]
Parameters
No parameters for this method
Code
096  public function get_array()
097  {
098      return get_object_vars($this);
099  }
publicget_asset ( type ["default"] )[ person_db ]
Parameters
optionaltype ["default"]
Code
426  public function get_asset($__type="default")
427  {
428      $object = is_null(keyval($this->property_objects_array,"{$__type}_asset")) ? new asset($this->get_asset_id($__type)) : $this->property_objects_array["{$__type}_asset"];
429      $this->property_objects_array["{$__type}_asset"] = $object;
430      return $object;
431  }
publicget_asset_id ( type ["default"] )[ person_db ]
Parameters
optionaltype ["default"]
Code
432  public function get_asset_id($__type="default")
433  {
434      $ids = $this->get_asset_ids($__type, true);
435      return (count($ids)==1 ? $ids[0] : null);
436  }
publicget_asset_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ person_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
437  public function get_asset_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
438  {
439      $asset_ids = array();
440      $db = person::db();
441      $q  = " SELECT am_asset.id FROM am_asset_person INNER JOIN am_asset ON am_asset_person.asset_id=am_asset.id AND am_asset_person.deleted=0 AND am_asset.deleted=0 AND am_asset_person.person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND am_asset_person.asset_person_type_id='" . asset_person::type_id($__type) . "'") . ($__get_primary ? " AND am_asset_person.primary=1 " : "");
442      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
443      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
444      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
445      $db->query($q);
446      while ($db->next_record())
447      {
448          $asset_ids[] = $db->f("id");
449      }
450      return $asset_ids;
451  }
publicget_asset_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ person_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
452  public function get_asset_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
453  {
454      $ids = $this->get_asset_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
455      $objects = array();
456      foreach ($ids as $index=>$id)
457      {
458          $objects[$index] = new asset($id);
459      }
460      return $objects;
461  }
publicget_business ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
667  public function get_business($__type="default")
668  {
669      $object = is_null(keyval($this->property_objects_array,"{$__type}_business")) ? new business($this->get_business_id($__type)) : $this->property_objects_array["{$__type}_business"];
670      $this->property_objects_array["{$__type}_business"] = $object;
671      return $object;
672  }
publicget_business_id ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
673  public function get_business_id($__type="default")
674  {
675      $ids = $this->get_business_ids($__type, true);
676      return (count($ids)==1 ? $ids[0] : null);
677  }
publicget_business_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
678  public function get_business_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
679  {
680      $business_ids = array();
681      $db = employee::db();
682      $q  = " SELECT bus_business.entity_id FROM hr_business_employee INNER JOIN bus_business ON hr_business_employee.business_entity_id=bus_business.entity_id AND hr_business_employee.deleted=0 AND bus_business.deleted=0 AND hr_business_employee.employee_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND hr_business_employee.business_employee_type_id='" . business_employee::type_id($__type) . "'") . ($__get_primary ? " AND hr_business_employee.primary=1 " : "");
683      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
684      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
685      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
686      $db->query($q);
687      while ($db->next_record())
688      {
689          $business_ids[] = $db->f("entity_id");
690      }
691      return $business_ids;
692  }
publicget_business_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
693  public function get_business_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
694  {
695      $ids = $this->get_business_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
696      $objects = array();
697      foreach ($ids as $index=>$id)
698      {
699          $objects[$index] = new business($id);
700      }
701      return $objects;
702  }
public staticget_by_last_name ( starts_with , order_by )[ person_ext ]
Parameters
optionalstarts_with
optionalorder_by
Code
032  public static function get_by_last_name($__starts_with=null, $__order_by=null)
033  {
034      $db = new db;
035      $ids = array();
036      $q  = " SELECT entity_id ";
037      $q .= " FROM " . self::TABLENAME . " ";
038      $q .= " WHERE deleted = 0 ";
039      $q .= " AND last_name LIKE '$__starts_with%' ";
040      $q .= " ORDER BY last_name, first_name ";
041     
042      $db->query($q);
043     
044      while ($db->next_record())
045      {
046          $ids[] = $db->f("entity_id");
047      }
048     
049      return $ids;   
050  }
publicget_classname ( )[ obj ]
Parameters
No parameters for this method
Code
086  public function get_classname()
087  {
088      return get_class($this);
089  }
public staticget_columns ( columns , order , lookups , where_clause , limit , offset [0] )[ employee_db ]
Parameters
requiredcolumns
optionalorder
optionallookups
optionalwhere_clause
optionallimit
optionaloffset [0]
Code
258  public static function get_columns($__columns, $__order=null, $__lookups=null, $__where_clause=null, $__limit=null, $__offset=0)
259  {
260      $lookups = is_array($__lookups) ? $__lookups : array($__lookups);
261      $colarray = is_array($__columns) ? $__columns : explode(",",$__columns);
262      $colstring = is_array($__columns) ? implode(",",$__columns) : $__columns;
263 
264      $db = employee::db();
265      $data = array();
266      $q  = " SELECT $colstring ";
267      $q .= " FROM hr_employee ";
268      $q .= " INNER JOIN cor_person ON hr_employee.person_entity_id=cor_person.entity_id ";
269      $q .= array_key_exists("person_type_id",$lookups) ? " AND cor_person.person_type_id='" . $lookups["person_type_id"] . "' " : "";
270      $q .= " INNER JOIN cor_entity ON cor_person.entity_id=cor_entity.id ";
271      $q .= array_key_exists("entity_type_id",$lookups) ? " AND cor_entity.entity_type_id='" . $lookups["entity_type_id"] . "' " : "";
272      $q .= " WHERE hr_employee.deleted = 0 ";
273      $q .= is_null($__where_clause) ? null : " AND ($__where_clause) ";
274      $q .= array_key_exists("employee_type_id",$lookups) ? " AND hr_employee.employee_type_id='" . $lookups["employee_type_id"] . "' " : "";
275      $q .= array_key_exists("employeestatus_id",$lookups) ? " AND hr_employee.employeestatus_id='" . $lookups["employeestatus_id"] . "' " : "";
276      $q .= array_key_exists("department_id",$lookups) ? " AND hr_employee.department_id='" . $lookups["department_id"] . "' " : "";
277 
278      if (is_string($__order))
279      {
280          $q .= "ORDER BY " . $__order;
281      }
282      else if (is_array($__order) and count($__order)>0)
283      {
284          $orderings = array();
285          foreach ($__order as $col=>$dir)
286          {
287              $orderings[] = " $col $dir ";
288          }
289          $q .= "ORDER BY " . implode(", ", $orderings);
290      }
291      else if (is_object($__order))
292      {
293          $q .= "";
294      }
295      else
296      {
297          // THERE IS NO `order` COLUMN ON THIS OBJECT
298      }
299 
300      if (!is_null($__limit))
301      {
302          $q .= " LIMIT $__offset , $__limit ";
303      }
304 
305      $db->query($q);
306 
307      if (count($colarray)>1 || $colstring=="*")
308      {
309          while ($db->next_record())
310          {
311              $data[] = $db->record;
312          }
313      }
314      else
315      {
316          while ($db->next_record())
317          {
318              $data[] = $db->f(0);
319          }
320      }
321 
322      return $data;
323  }
publicget_department ( )[ employee_db ]
Parameters
No parameters for this method
Code
458  public function get_department()
459  {
460      return new department($this->department_id);
461  }
publicget_dirty ( )[ obj ]
Parameters
No parameters for this method
Code
063  public function get_dirty()
064  {
065      if ($this->id === 0)
066      {
067          $this->_dirty = true;
068      }
069      else
070      {
071          foreach (get_object_vars($this) as $k=>$v)
072          {
073              if ($this->_dirty)
074              {
075                  break;
076              }
077              if (preg_match('/_dirty$/',$k))
078              {
079                  $this->_dirty = $this->_dirty || $v;
080              }
081          }
082      }
083      return $this->_dirty;
084  }
publicget_document ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1433  public function get_document($__type="default")
1434  {
1435      $object = is_null(keyval($this->property_objects_array,"{$__type}_document")) ? new document($this->get_document_id($__type)) : $this->property_objects_array["{$__type}_document"];
1436      $this->property_objects_array["{$__type}_document"] = $object;
1437      return $object;
1438  }
publicget_document_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1439  public function get_document_id($__type="default")
1440  {
1441      $ids = $this->get_document_ids($__type, true);
1442      return (count($ids)==1 ? $ids[0] : null);
1443  }
publicget_document_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
1444  public function get_document_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1445  {
1446      $document_ids = array();
1447      $db = entity::db();
1448      $q  = " SELECT doc_document.id FROM doc_document_entity INNER JOIN doc_document ON doc_document_entity.document_id=doc_document.id AND doc_document_entity.deleted=0 AND doc_document.deleted=0 AND doc_document_entity.entity_id='$this->id' " . (is_null($__type) ? "" : " AND doc_document_entity.document_entity_type_id='" . document_entity::type_id($__type) . "'") . ($__get_primary ? " AND doc_document_entity.primary=1 " : "");
1449      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
1450      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
1451      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
1452      $db->query($q);
1453      while ($db->next_record())
1454      {
1455          $document_ids[] = $db->f("id");
1456      }
1457      return $document_ids;
1458  }
publicget_document_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
1459  public function get_document_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1460  {
1461      $ids = $this->get_document_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
1462      $objects = array();
1463      foreach ($ids as $index=>$id)
1464      {
1465          $objects[$index] = new document($id);
1466      }
1467      return $objects;
1468  }
publicget_email ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1037  public function get_email($__type="default")
1038  {
1039      $object = is_null(keyval($this->property_objects_array,"{$__type}_email")) ? new email($this->get_email_id($__type)) : $this->property_objects_array["{$__type}_email"];
1040      $this->property_objects_array["{$__type}_email"] = $object;
1041      return $object;
1042  }
publicget_email_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1043  public function get_email_id($__type="default")
1044  {
1045      $ids = $this->get_email_ids($__type, true);
1046      return (count($ids)==1 ? $ids[0] : null);
1047  }
publicget_email_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
1048  public function get_email_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1049  {
1050      $email_ids = array();
1051      $db = entity::db();
1052      $q  = " SELECT cor_email.id FROM cor_email_entity INNER JOIN cor_email ON cor_email_entity.email_id=cor_email.id AND cor_email_entity.deleted=0 AND cor_email.deleted=0 AND cor_email_entity.entity_id='$this->id' " . (is_null($__type) ? "" : " AND cor_email_entity.email_entity_type_id='" . email_entity::type_id($__type) . "'") . ($__get_primary ? " AND cor_email_entity.primary=1 " : "");
1053      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
1054      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
1055      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
1056      $db->query($q);
1057      while ($db->next_record())
1058      {
1059          $email_ids[] = $db->f("id");
1060      }
1061      return $email_ids;
1062  }
publicget_email_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
1063  public function get_email_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1064  {
1065      $ids = $this->get_email_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
1066      $objects = array();
1067      foreach ($ids as $index=>$id)
1068      {
1069          $objects[$index] = new email($id);
1070      }
1071      return $objects;
1072  }
publicget_employee_type ( )[ employee_db ]
Parameters
No parameters for this method
Code
434  public function get_employee_type()
435  {
436      return new employee_type($this->employee_type_id);
437  }
publicget_employeedate ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
470  public function get_employeedate($__type="default")
471  {
472      $object = is_null(keyval($this->property_objects_array,"{$__type}_employeedate")) ? new employeedate($this->get_employeedate_id($__type)) : $this->property_objects_array["{$__type}_employeedate"];
473      $this->property_objects_array["{$__type}_employeedate"] = $object;
474      return $object;
475  }
publicget_employeedate_id ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
476  public function get_employeedate_id($__type="default")
477  {
478      $ids = $this->get_employeedate_ids($__type, true);
479      return (count($ids)==1 ? $ids[0] : null);
480  }
publicget_employeedate_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
481  public function get_employeedate_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
482  {
483      $employeedate_ids = array();
484      $db = employee::db();
485      $q  = " SELECT hr_employeedate.id FROM hr_employee_employeedate INNER JOIN hr_employeedate ON hr_employee_employeedate.employeedate_id=hr_employeedate.id AND hr_employee_employeedate.deleted=0 AND hr_employeedate.deleted=0 AND hr_employee_employeedate.employee_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND hr_employee_employeedate.employee_employeedate_type_id='" . employee_employeedate::type_id($__type) . "'") . ($__get_primary ? " AND hr_employee_employeedate.primary=1 " : "");
486      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
487      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
488      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
489      $db->query($q);
490      while ($db->next_record())
491      {
492          $employeedate_ids[] = $db->f("id");
493      }
494      return $employeedate_ids;
495  }
publicget_employeedate_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
496  public function get_employeedate_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
497  {
498      $ids = $this->get_employeedate_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
499      $objects = array();
500      foreach ($ids as $index=>$id)
501      {
502          $objects[$index] = new employeedate($id);
503      }
504      return $objects;
505  }
publicget_employeestatus ( )[ employee_db ]
Parameters
No parameters for this method
Code
446  public function get_employeestatus()
447  {
448      return new employeestatus($this->employeestatus_id);
449  }
publicget_entity ( )[ person_db ]
Parameters
No parameters for this method
Code
402  public function get_entity()
403  {
404      return new entity($this->entity_id);
405  }
publicget_entity_type ( )[ entity_db ]
Parameters
No parameters for this method
Code
332  public function get_entity_type()
333  {
334      return new entity_type($this->entity_type_id);
335  }
publicget_event ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
542  public function get_event($__type="default")
543  {
544      $object = is_null(keyval($this->property_objects_array,"{$__type}_event")) ? new event($this->get_event_id($__type)) : $this->property_objects_array["{$__type}_event"];
545      $this->property_objects_array["{$__type}_event"] = $object;
546      return $object;
547  }
publicget_event_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
548  public function get_event_id($__type="default")
549  {
550      $ids = $this->get_event_ids($__type, true);
551      return (count($ids)==1 ? $ids[0] : null);
552  }
publicget_event_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
553  public function get_event_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
554  {
555      $event_ids = array();
556      $db = entity::db();
557      $q  = " SELECT cal_event.id FROM cal_entity_event INNER JOIN cal_event ON cal_entity_event.event_id=cal_event.id AND cal_entity_event.deleted=0 AND cal_event.deleted=0 AND cal_entity_event.entity_id='$this->id' " . (is_null($__type) ? "" : " AND cal_entity_event.entity_event_type_id='" . entity_event::type_id($__type) . "'") . ($__get_primary ? " AND cal_entity_event.primary=1 " : "");
558      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
559      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
560      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
561      $db->query($q);
562      while ($db->next_record())
563      {
564          $event_ids[] = $db->f("id");
565      }
566      return $event_ids;
567  }
publicget_event_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
568  public function get_event_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
569  {
570      $ids = $this->get_event_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
571      $objects = array();
572      foreach ($ids as $index=>$id)
573      {
574          $objects[$index] = new event($id);
575      }
576      return $objects;
577  }
public staticget_ids ( order , lookups , where_clause , limit , offset [0] )[ employee_db ]
Parameters
optionalorder
optionallookups
optionalwhere_clause
optionallimit
optionaloffset [0]
Code
325  public static function get_ids($__order=null, $__lookups=null, $__where_clause=null, $__limit=null, $__offset=0)
326  {
327      return employee::get_columns("person_entity_id", $__order, $__lookups, $__where_clause, $__limit, $__offset);
328  }
publicget_json ( )[ obj ]
Parameters
No parameters for this method
Code
101  public function get_json()
102  {
103      $class = new ReflectionClass($this->classname);
104      $methods = $class->getMethods();
105      usort($methods,"sort_reflection_objects");
106      $accessors = array();
107      foreach ($methods as $index=>$method)
108      {
109          $declarer = $method->getDeclaringClass()->name;
110          if (preg_match('/^(get|set|)_(.+)$/',$method->name,$matches))
111          {
112              $accessor = $matches[2];
113              $getset = $matches[1];
114              eval("\$accessors[\$accessor] = \$this->".$accessor.";");
115          }
116      }
117      //return json_encode($this->get_array());
118      return json_encode($accessors);
119  }
publicget_menu ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1532  public function get_menu($__type="default")
1533  {
1534      $object = is_null(keyval($this->property_objects_array,"{$__type}_menu")) ? new menu($this->get_menu_id($__type)) : $this->property_objects_array["{$__type}_menu"];
1535      $this->property_objects_array["{$__type}_menu"] = $object;
1536      return $object;
1537  }
publicget_menu_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1538  public function get_menu_id($__type="default")
1539  {
1540      $ids = $this->get_menu_ids($__type, true);
1541      return (count($ids)==1 ? $ids[0] : null);
1542  }
publicget_menu_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
1543  public function get_menu_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1544  {
1545      $menu_ids = array();
1546      $db = entity::db();
1547      $q  = " SELECT ifc_menu.id FROM ifc_entity_menu INNER JOIN ifc_menu ON ifc_entity_menu.menu_id=ifc_menu.id AND ifc_entity_menu.deleted=0 AND ifc_menu.deleted=0 AND ifc_entity_menu.entity_id='$this->id' " . (is_null($__type) ? "" : " AND ifc_entity_menu.entity_menu_type_id='" . entity_menu::type_id($__type) . "'") . ($__get_primary ? " AND ifc_entity_menu.primary=1 " : "");
1548      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
1549      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
1550      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
1551      $db->query($q);
1552      while ($db->next_record())
1553      {
1554          $menu_ids[] = $db->f("id");
1555      }
1556      return $menu_ids;
1557  }
publicget_menu_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
1558  public function get_menu_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1559  {
1560      $ids = $this->get_menu_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
1561      $objects = array();
1562      foreach ($ids as $index=>$id)
1563      {
1564          $objects[$index] = new menu($id);
1565      }
1566      return $objects;
1567  }
publicget_name ( )[ person_ext ]
Parameters
No parameters for this method
Code
008  public function get_name()
009  {
010      if (is_null($this->_first_name) && is_null($this->_last_name))
011      {
012          return null;
013      }
014      else
015      {
016          return $this->_first_name . " " . $this->_last_name;
017      }
018  }
public staticget_objects ( order , lookups , where_clause , limit , offset [0] )[ employee_db ]
Parameters
optionalorder
optionallookups
optionalwhere_clause
optionallimit
optionaloffset [0]
Code
330  public static function get_objects($__order=null, $__lookups=null, $__where_clause=null, $__limit=null, $__offset=0)
331  {
332      $objects = array();
333      foreach (employee::get_columns("person_entity_id", $__order, $__lookups, $__where_clause, $__limit, $__offset) as $id)
334      {
335          $objects[] = new employee($id);
336      }
337      return $objects;
338  }
publicget_office ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
568  public function get_office($__type="default")
569  {
570      $object = is_null(keyval($this->property_objects_array,"{$__type}_office")) ? new office($this->get_office_id($__type)) : $this->property_objects_array["{$__type}_office"];
571      $this->property_objects_array["{$__type}_office"] = $object;
572      return $object;
573  }
publicget_office_id ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
574  public function get_office_id($__type="default")
575  {
576      $ids = $this->get_office_ids($__type, true);
577      return (count($ids)==1 ? $ids[0] : null);
578  }
publicget_office_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
579  public function get_office_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
580  {
581      $office_ids = array();
582      $db = employee::db();
583      $q  = " SELECT bus_office.entity_id FROM hr_employee_office INNER JOIN bus_office ON hr_employee_office.office_entity_id=bus_office.entity_id AND hr_employee_office.deleted=0 AND bus_office.deleted=0 AND hr_employee_office.employee_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND hr_employee_office.employee_office_type_id='" . employee_office::type_id($__type) . "'") . ($__get_primary ? " AND hr_employee_office.primary=1 " : "");
584      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
585      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
586      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
587      $db->query($q);
588      while ($db->next_record())
589      {
590          $office_ids[] = $db->f("entity_id");
591      }
592      return $office_ids;
593  }
publicget_office_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
594  public function get_office_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
595  {
596      $ids = $this->get_office_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
597      $objects = array();
598      foreach ($ids as $index=>$id)
599      {
600          $objects[$index] = new office($id);
601      }
602      return $objects;
603  }
publicget_order ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
641  public function get_order($__type="default")
642  {
643      $object = is_null(keyval($this->property_objects_array,"{$__type}_order")) ? new order($this->get_order_id($__type)) : $this->property_objects_array["{$__type}_order"];
644      $this->property_objects_array["{$__type}_order"] = $object;
645      return $object;
646  }
publicget_order_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
647  public function get_order_id($__type="default")
648  {
649      $ids = $this->get_order_ids($__type, true);
650      return (count($ids)==1 ? $ids[0] : null);
651  }
publicget_order_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
652  public function get_order_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
653  {
654      $order_ids = array();
655      $db = entity::db();
656      $q  = " SELECT com_order.id FROM com_entity_order INNER JOIN com_order ON com_entity_order.order_id=com_order.id AND com_entity_order.deleted=0 AND com_order.deleted=0 AND com_entity_order.entity_id='$this->id' " . (is_null($__type) ? "" : " AND com_entity_order.entity_order_type_id='" . entity_order::type_id($__type) . "'") . ($__get_primary ? " AND com_entity_order.primary=1 " : "");
657      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
658      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
659      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
660      $db->query($q);
661      while ($db->next_record())
662      {
663          $order_ids[] = $db->f("id");
664      }
665      return $order_ids;
666  }
publicget_order_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
667  public function get_order_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
668  {
669      $ids = $this->get_order_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
670      $objects = array();
671      foreach ($ids as $index=>$id)
672      {
673          $objects[$index] = new order($id);
674      }
675      return $objects;
676  }
publicget_orders ( )[ entity_ext ]
Parameters
No parameters for this method
Code
008  public function get_orders()
009  {
010      return $this->order_list;
011  }
publicget_orgchart ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
443  public function get_orgchart($__type="default")
444  {
445      $object = is_null(keyval($this->property_objects_array,"{$__type}_orgchart")) ? new orgchart($this->get_orgchart_id($__type)) : $this->property_objects_array["{$__type}_orgchart"];
446      $this->property_objects_array["{$__type}_orgchart"] = $object;
447      return $object;
448  }
publicget_orgchart_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
449  public function get_orgchart_id($__type="default")
450  {
451      $ids = $this->get_orgchart_ids($__type, true);
452      return (count($ids)==1 ? $ids[0] : null);
453  }
publicget_orgchart_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
454  public function get_orgchart_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
455  {
456      $orgchart_ids = array();
457      $db = entity::db();
458      $q  = " SELECT bus_orgchart.id FROM bus_entity_orgchart INNER JOIN bus_orgchart ON bus_entity_orgchart.orgchart_id=bus_orgchart.id AND bus_entity_orgchart.deleted=0 AND bus_orgchart.deleted=0 AND bus_entity_orgchart.entity_id='$this->id' " . (is_null($__type) ? "" : " AND bus_entity_orgchart.entity_orgchart_type_id='" . entity_orgchart::type_id($__type) . "'") . ($__get_primary ? " AND bus_entity_orgchart.primary=1 " : "");
459      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
460      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
461      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
462      $db->query($q);
463      while ($db->next_record())
464      {
465          $orgchart_ids[] = $db->f("id");
466      }
467      return $orgchart_ids;
468  }
publicget_orgchart_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
469  public function get_orgchart_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
470  {
471      $ids = $this->get_orgchart_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
472      $objects = array();
473      foreach ($ids as $index=>$id)
474      {
475          $objects[$index] = new orgchart($id);
476      }
477      return $objects;
478  }
publicget_orgposition ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
344  public function get_orgposition($__type="default")
345  {
346      $object = is_null(keyval($this->property_objects_array,"{$__type}_orgposition")) ? new orgposition($this->get_orgposition_id($__type)) : $this->property_objects_array["{$__type}_orgposition"];
347      $this->property_objects_array["{$__type}_orgposition"] = $object;
348      return $object;
349  }
publicget_orgposition_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
350  public function get_orgposition_id($__type="default")
351  {
352      $ids = $this->get_orgposition_ids($__type, true);
353      return (count($ids)==1 ? $ids[0] : null);
354  }
publicget_orgposition_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
355  public function get_orgposition_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
356  {
357      $orgposition_ids = array();
358      $db = entity::db();
359      $q  = " SELECT bus_orgposition.id FROM bus_entity_orgposition INNER JOIN bus_orgposition ON bus_entity_orgposition.orgposition_id=bus_orgposition.id AND bus_entity_orgposition.deleted=0 AND bus_orgposition.deleted=0 AND bus_entity_orgposition.entity_id='$this->id' " . (is_null($__type) ? "" : " AND bus_entity_orgposition.entity_orgposition_type_id='" . entity_orgposition::type_id($__type) . "'") . ($__get_primary ? " AND bus_entity_orgposition.primary=1 " : "");
360      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
361      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
362      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
363      $db->query($q);
364      while ($db->next_record())
365      {
366          $orgposition_ids[] = $db->f("id");
367      }
368      return $orgposition_ids;
369  }
publicget_orgposition_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
370  public function get_orgposition_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
371  {
372      $ids = $this->get_orgposition_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
373      $objects = array();
374      foreach ($ids as $index=>$id)
375      {
376          $objects[$index] = new orgposition($id);
377      }
378      return $objects;
379  }
publicget_payment ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
740  public function get_payment($__type="default")
741  {
742      $object = is_null(keyval($this->property_objects_array,"{$__type}_payment")) ? new payment($this->get_payment_id($__type)) : $this->property_objects_array["{$__type}_payment"];
743      $this->property_objects_array["{$__type}_payment"] = $object;
744      return $object;
745  }
publicget_payment_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
746  public function get_payment_id($__type="default")
747  {
748      $ids = $this->get_payment_ids($__type, true);
749      return (count($ids)==1 ? $ids[0] : null);
750  }
publicget_payment_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
751  public function get_payment_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
752  {
753      $payment_ids = array();
754      $db = entity::db();
755      $q  = " SELECT com_payment.id FROM com_entity_payment INNER JOIN com_payment ON com_entity_payment.payment_id=com_payment.id AND com_entity_payment.deleted=0 AND com_payment.deleted=0 AND com_entity_payment.entity_id='$this->id' " . (is_null($__type) ? "" : " AND com_entity_payment.entity_payment_type_id='" . entity_payment::type_id($__type) . "'") . ($__get_primary ? " AND com_entity_payment.primary=1 " : "");
756      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
757      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
758      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
759      $db->query($q);
760      while ($db->next_record())
761      {
762          $payment_ids[] = $db->f("id");
763      }
764      return $payment_ids;
765  }
publicget_payment_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
766  public function get_payment_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
767  {
768      $ids = $this->get_payment_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
769      $objects = array();
770      foreach ($ids as $index=>$id)
771      {
772          $objects[$index] = new payment($id);
773      }
774      return $objects;
775  }
publicget_paymentaccount ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
839  public function get_paymentaccount($__type="default")
840  {
841      $object = is_null(keyval($this->property_objects_array,"{$__type}_paymentaccount")) ? new paymentaccount($this->get_paymentaccount_id($__type)) : $this->property_objects_array["{$__type}_paymentaccount"];
842      $this->property_objects_array["{$__type}_paymentaccount"] = $object;
843      return $object;
844  }
publicget_paymentaccount_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
845  public function get_paymentaccount_id($__type="default")
846  {
847      $ids = $this->get_paymentaccount_ids($__type, true);
848      return (count($ids)==1 ? $ids[0] : null);
849  }
publicget_paymentaccount_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
850  public function get_paymentaccount_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
851  {
852      $paymentaccount_ids = array();
853      $db = entity::db();
854      $q  = " SELECT com_paymentaccount.id FROM com_entity_paymentaccount INNER JOIN com_paymentaccount ON com_entity_paymentaccount.paymentaccount_id=com_paymentaccount.id AND com_entity_paymentaccount.deleted=0 AND com_paymentaccount.deleted=0 AND com_entity_paymentaccount.entity_id='$this->id' " . (is_null($__type) ? "" : " AND com_entity_paymentaccount.entity_paymentaccount_type_id='" . entity_paymentaccount::type_id($__type) . "'") . ($__get_primary ? " AND com_entity_paymentaccount.primary=1 " : "");
855      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
856      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
857      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
858      $db->query($q);
859      while ($db->next_record())
860      {
861          $paymentaccount_ids[] = $db->f("id");
862      }
863      return $paymentaccount_ids;
864  }
publicget_paymentaccount_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
865  public function get_paymentaccount_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
866  {
867      $ids = $this->get_paymentaccount_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
868      $objects = array();
869      foreach ($ids as $index=>$id)
870      {
871          $objects[$index] = new paymentaccount($id);
872      }
873      return $objects;
874  }
publicget_person ( )[ employee_db ]
Parameters
No parameters for this method
Code
422  public function get_person()
423  {
424      return new person($this->person_id);
425  }
publicget_person_type ( )[ person_db ]
Parameters
No parameters for this method
Code
414  public function get_person_type()
415  {
416      return new person_type($this->person_type_id);
417  }
publicget_persondate ( type ["default"] )[ person_db ]
Parameters
optionaltype ["default"]
Code
525  public function get_persondate($__type="default")
526  {
527      $object = is_null(keyval($this->property_objects_array,"{$__type}_persondate")) ? new persondate($this->get_persondate_id($__type)) : $this->property_objects_array["{$__type}_persondate"];
528      $this->property_objects_array["{$__type}_persondate"] = $object;
529      return $object;
530  }
publicget_persondate_id ( type ["default"] )[ person_db ]
Parameters
optionaltype ["default"]
Code
531  public function get_persondate_id($__type="default")
532  {
533      $ids = $this->get_persondate_ids($__type, true);
534      return (count($ids)==1 ? $ids[0] : null);
535  }
publicget_persondate_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ person_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
536  public function get_persondate_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
537  {
538      $persondate_ids = array();
539      $db = person::db();
540      $q  = " SELECT cor_persondate.id FROM cor_person_persondate INNER JOIN cor_persondate ON cor_person_persondate.persondate_id=cor_persondate.id AND cor_person_persondate.deleted=0 AND cor_persondate.deleted=0 AND cor_person_persondate.person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND cor_person_persondate.person_persondate_type_id='" . person_persondate::type_id($__type) . "'") . ($__get_primary ? " AND cor_person_persondate.primary=1 " : "");
541      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
542      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
543      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
544      $db->query($q);
545      while ($db->next_record())
546      {
547          $persondate_ids[] = $db->f("id");
548      }
549      return $persondate_ids;
550  }
publicget_persondate_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ person_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
551  public function get_persondate_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
552  {
553      $ids = $this->get_persondate_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
554      $objects = array();
555      foreach ($ids as $index=>$id)
556      {
557          $objects[$index] = new persondate($id);
558      }
559      return $objects;
560  }
publicget_phone ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1135  public function get_phone($__type="default")
1136  {
1137      $object = is_null(keyval($this->property_objects_array,"{$__type}_phone")) ? new phone($this->get_phone_id($__type)) : $this->property_objects_array["{$__type}_phone"];
1138      $this->property_objects_array["{$__type}_phone"] = $object;
1139      return $object;
1140  }
publicget_phone_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1141  public function get_phone_id($__type="default")
1142  {
1143      $ids = $this->get_phone_ids($__type, true);
1144      return (count($ids)==1 ? $ids[0] : null);
1145  }
publicget_phone_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
1146  public function get_phone_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1147  {
1148      $phone_ids = array();
1149      $db = entity::db();
1150      $q  = " SELECT cor_phone.id FROM cor_entity_phone INNER JOIN cor_phone ON cor_entity_phone.phone_id=cor_phone.id AND cor_entity_phone.deleted=0 AND cor_phone.deleted=0 AND cor_entity_phone.entity_id='$this->id' " . (is_null($__type) ? "" : " AND cor_entity_phone.entity_phone_type_id='" . entity_phone::type_id($__type) . "'") . ($__get_primary ? " AND cor_entity_phone.primary=1 " : "");
1151      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
1152      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
1153      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
1154      $db->query($q);
1155      while ($db->next_record())
1156      {
1157          $phone_ids[] = $db->f("id");
1158      }
1159      return $phone_ids;
1160  }
publicget_phone_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ entity_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
1161  public function get_phone_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1162  {
1163      $ids = $this->get_phone_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
1164      $objects = array();
1165      foreach ($ids as $index=>$id)
1166      {
1167          $objects[$index] = new phone($id);
1168      }
1169      return $objects;
1170  }
publicget_projectentity ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
867  public function get_projectentity($__type="default")
868  {
869      $object = is_null(keyval($this->property_objects_array,"{$__type}_projectentity")) ? new projectentity($this->get_projectentity_id($__type)) : $this->property_objects_array["{$__type}_projectentity"];
870      $this->property_objects_array["{$__type}_projectentity"] = $object;
871      return $object;
872  }
publicget_projectentity_id ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
873  public function get_projectentity_id($__type="default")
874  {
875      $ids = $this->get_projectentity_ids($__type, true);
876      return (count($ids)==1 ? $ids[0] : null);
877  }
publicget_projectentity_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
878  public function get_projectentity_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
879  {
880      $projectentity_ids = array();
881      $db = employee::db();
882      $q  = " SELECT prj_projectentity.id FROM prj_employee_projectentity INNER JOIN prj_projectentity ON prj_employee_projectentity.projectentity_id=prj_projectentity.id AND prj_employee_projectentity.deleted=0 AND prj_projectentity.deleted=0 AND prj_employee_projectentity.employee_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND prj_employee_projectentity.employee_projectentity_type_id='" . employee_projectentity::type_id($__type) . "'") . ($__get_primary ? " AND prj_employee_projectentity.primary=1 " : "");
883      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
884      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
885      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
886      $db->query($q);
887      while ($db->next_record())
888      {
889          $projectentity_ids[] = $db->f("id");
890      }
891      return $projectentity_ids;
892  }
publicget_projectentity_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
893  public function get_projectentity_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
894  {
895      $ids = $this->get_projectentity_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
896      $objects = array();
897      foreach ($ids as $index=>$id)
898      {
899          $objects[$index] = new projectentity($id);
900      }
901      return $objects;
902  }
publicget_properties ( )[ obj ]
Parameters
No parameters for this method
Code
121  public function get_properties()
122  {
123      return array_keys($this->array);
124  }
publicget_rating ( type ["default"] )[ person_db ]
Parameters
optionaltype ["default"]
Code
623  public function get_rating($__type="default")
624  {
625      $object = is_null(keyval($this->property_objects_array,"{$__type}_rating")) ? new rating($this->get_rating_id($__type)) : $this->property_objects_array["{$__type}_rating"];
626      $this->property_objects_array["{$__type}_rating"] = $object;
627      return $object;
628  }
publicget_rating_id ( type ["default"] )[ person_db ]
Parameters
optionaltype ["default"]
Code
629  public function get_rating_id($__type="default")
630  {
631      $ids = $this->get_rating_ids($__type, true);
632      return (count($ids)==1 ? $ids[0] : null);
633  }
publicget_rating_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ person_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
634  public function get_rating_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
635  {
636      $rating_ids = array();
637      $db = person::db();
638      $q  = " SELECT rating_rating.id FROM rating_person_rating INNER JOIN rating_rating ON rating_person_rating.rating_id=rating_rating.id AND rating_person_rating.deleted=0 AND rating_rating.deleted=0 AND rating_person_rating.person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND rating_person_rating.person_rating_type_id='" . person_rating::type_id($__type) . "'") . ($__get_primary ? " AND rating_person_rating.primary=1 " : "");
639      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
640      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
641      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
642      $db->query($q);
643      while ($db->next_record())
644      {
645          $rating_ids[] = $db->f("id");
646      }
647      return $rating_ids;
648  }
publicget_rating_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ person_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
649  public function get_rating_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
650  {
651      $ids = $this->get_rating_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
652      $objects = array();
653      foreach ($ids as $index=>$id)
654      {
655          $objects[$index] = new rating($id);
656      }
657      return $objects;
658  }
publicget_resource ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
766  public function get_resource($__type="default")
767  {
768      $object = is_null(keyval($this->property_objects_array,"{$__type}_resource")) ? new resource($this->get_resource_id($__type)) : $this->property_objects_array["{$__type}_resource"];
769      $this->property_objects_array["{$__type}_resource"] = $object;
770      return $object;
771  }
publicget_resource_id ( type ["default"] )[ employee_db ]
Parameters
optionaltype ["default"]
Code
772  public function get_resource_id($__type="default")
773  {
774      $ids = $this->get_resource_ids($__type, true);
775      return (count($ids)==1 ? $ids[0] : null);
776  }
publicget_resource_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
777  public function get_resource_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
778  {
779      $resource_ids = array();
780      $db = employee::db();
781      $q  = " SELECT cor_resource.id FROM hr_employee_resource INNER JOIN cor_resource ON hr_employee_resource.resource_id=cor_resource.id AND hr_employee_resource.deleted=0 AND cor_resource.deleted=0 AND hr_employee_resource.employee_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND hr_employee_resource.employee_resource_type_id='" . employee_resource::type_id($__type) . "'") . ($__get_primary ? " AND hr_employee_resource.primary=1 " : "");
782      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
783      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
784      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
785      $db->query($q);
786      while ($db->next_record())
787      {
788          $resource_ids[] = $db->f("id");
789      }
790      return $resource_ids;
791  }
publicget_resource_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ employee_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary