Helix Installation   Getting Started   Reference Documentation   Global Functions   Quick Start
ModulesClassesFunctions
 

Class Reference

class contact extends contact_ext

Hide Inherited MembersContact Relationship
Description
No description.
 
Constants
constantTABLENAME ["crm_contact"][ contact ]
 
Properties
protected_abbreviation[ contact_db ]
protected_abbreviation_dirty[ contact_db ]
protected_cdate[ contact_db ]
protected_cdate_dirty[ contact_db ]
protected_deleted[ contact_db ]
protected_deleted_dirty[ contact_db ]
protected_description[ entity_db ]
protected_description_dirty[ entity_db ]
protected_dirty[ obj ]
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[ contact_db ]
protected_id_dirty[ entity_db ]
protected__id_dirty[ contact_db ]
protected_initials[ person_db ]
protected_initials_dirty[ person_db ]
protected_last_name[ person_db ]
protected_last_name_dirty[ person_db ]
protected_long_title[ contact_db ]
protected_long_title_dirty[ contact_db ]
protected_mdate[ contact_db ]
protected_mdate_dirty[ contact_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[ contact_db ]
protected_person_entity_id_dirty[ contact_db ]
protected_person_type_id[ person_db ]
protected_person_type_id_dirty[ person_db ]
protected_prefix[ contact_db ]
protected_prefix_dirty[ contact_db ]
publicproperty_objects_array[ obj ]
protected_suffix[ person_db ]
protected_suffix_dirty[ person_db ]
protected_title[ contact_db ]
protected_title_dirty[ contact_db ]
 
Methods
publiccommit ( )[ contact_db ]
Parameters
No parameters for this method
Code
151  public function commit()
152  {
153      if ($this->_person_entity_id > 0)
154      {
155          $this->update();
156      }
157      else
158      {
159          $this->insert();
160      }
161 
162      foreach ($this->property_objects_array as $property=>$object)
163      {
164          $this->{$property} = $object;
165      }
166 
167      return true;
168  }
public__construct ( person_entity_id , abbreviation )[ contact_db ]
Parameters
optionalperson_entity_id
optionalabbreviation
Code
048  public function __construct($__person_entity_id=null, $__abbreviation=null)
049  {
050      $this->__id = 0;
051      $this->_person_entity_id = 0;
052      $this->_abbreviation = $__abbreviation;
053      $this->_prefix = "";
054      $this->_title = "";
055      $this->_long_title = "";
056      $this->_mdate = null;
057      $this->_cdate = null;
058      $this->_deleted = false;
059      $this->_entity_id = 0;
060      $this->_first_name = "";
061      $this->_middle_name = "";
062      $this->_last_name = "";
063      $this->_suffix = "";
064      $this->_nickname = "";
065      $this->_initials = "";
066      $this->_person_type_id = 0;
067      $this->_id = 0;
068      $this->_description = "";
069      $this->_entity_type_id = 0;
070 
071      $this->__id_dirty = false;
072      $this->_person_entity_id_dirty = false;
073      $this->_abbreviation_dirty = false;
074      $this->_prefix_dirty = false;
075      $this->_title_dirty = false;
076      $this->_long_title_dirty = false;
077      $this->_mdate_dirty = false;
078      $this->_cdate_dirty = false;
079      $this->_deleted_dirty = false;
080      $this->_entity_id_dirty = false;
081      $this->_first_name_dirty = false;
082      $this->_middle_name_dirty = false;
083      $this->_last_name_dirty = false;
084      $this->_suffix_dirty = false;
085      $this->_nickname_dirty = false;
086      $this->_initials_dirty = false;
087      $this->_person_type_id_dirty = false;
088      $this->_id_dirty = false;
089      $this->_description_dirty = false;
090      $this->_entity_type_id_dirty = false;
091 
092      if (is_null($__person_entity_id) && is_null($__abbreviation))
093      {
094          return;
095      }
096 
097      $db = contact::db();
098      $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,crm_contact._id,crm_contact.person_entity_id,crm_contact.abbreviation,crm_contact.prefix,crm_contact.title,crm_contact.long_title,crm_contact.mdate,crm_contact.cdate,crm_contact.deleted ";
099      $q .= " FROM crm_contact ";
100      $q .= " INNER JOIN cor_person ON crm_contact.person_entity_id=cor_person.entity_id ";
101      $q .= is_null($__person_entity_id) ? "" : " AND cor_person.entity_id='$__person_entity_id' ";
102      $q .= is_null($__abbreviation) ? "" : " AND crm_contact.abbreviation='$__abbreviation' ";
103      $q .= " INNER JOIN cor_entity ON cor_person.entity_id=cor_entity.id ";       
104 
105      $db->query($q);
106      if ($db->next_record() && $db->num_rows() == 1)
107      {
108          $this->_id = $db->f("id");
109          $this->_description = $db->f("description");
110          $this->_entity_type_id = $db->f("entity_type_id");
111          $this->_entity_id = $db->f("entity_id");
112          $this->_first_name = $db->f("first_name");
113          $this->_middle_name = $db->f("middle_name");
114          $this->_last_name = $db->f("last_name");
115          $this->_suffix = $db->f("suffix");
116          $this->_nickname = $db->f("nickname");
117          $this->_initials = $db->f("initials");
118          $this->_person_type_id = $db->f("person_type_id");
119          $this->__id = $db->f("_id");
120          $this->_person_entity_id = $db->f("person_entity_id");
121          $this->_abbreviation = $db->f("abbreviation");
122          $this->_prefix = $db->f("prefix");
123          $this->_title = $db->f("title");
124          $this->_long_title = $db->f("long_title");
125          $this->_mdate = $db->f("mdate");
126          $this->_cdate = $db->f("cdate");
127          $this->_deleted = $db->f("deleted");
128      }
129  }
protected staticdb ( )[ contact_db ]
Parameters
No parameters for this method
Code
1001  protected static function db()
1002  {
1003      return new db();
1004  }
publicdelete ( )[ contact_db ]
Parameters
No parameters for this method
Code
215  public function delete()
216  {
217      parent::delete();
218      $db = contact::db();
219      $q  = " UPDATE crm_contact SET ";
220      $q .= " deleted = 1 ";
221      $q .= " WHERE person_entity_id = " . $this->_person_entity_id;
222      $db->query($q);
223      $this->deleted = true;
224      return true;
225  }
public staticdelete_all ( )[ contact_db ]
Parameters
No parameters for this method
Code
328  public static function delete_all()
329  {
330      $db = contact::db();
331      $q  = " UPDATE crm_contact SET ";
332      $q .= " deleted = 1 ";
333     
334      $db->query($q);
335      return true;
336  }
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_ancestors ( )[ contact_ext ]
Parameters
No parameters for this method
Code
045  public function get_ancestors()
046  {
047      $ancestors = array();
048      $contact = $this;
049      while (!$contact->parent->is_root)
050      {
051          $ancestors[] = $contact->parent;
052          $contact = $contact->parent;
053      }
054      return $ancestors;
055  }
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"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
504  public function get_business($__type="default")
505  {
506      $object = is_null(keyval($this->property_objects_array,"{$__type}_business")) ? new business($this->get_business_id($__type)) : $this->property_objects_array["{$__type}_business"];
507      $this->property_objects_array["{$__type}_business"] = $object;
508      return $object;
509  }
publicget_business_id ( type ["default"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
510  public function get_business_id($__type="default")
511  {
512      $ids = $this->get_business_ids($__type, true);
513      return (count($ids)==1 ? $ids[0] : null);
514  }
publicget_business_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
515  public function get_business_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
516  {
517      $business_ids = array();
518      $db = contact::db();
519      $q  = " SELECT bus_business.entity_id FROM crm_business_contact INNER JOIN bus_business ON crm_business_contact.business_entity_id=bus_business.entity_id AND crm_business_contact.deleted=0 AND bus_business.deleted=0 AND crm_business_contact.contact_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND crm_business_contact.business_contact_type_id='" . business_contact::type_id($__type) . "'") . ($__get_primary ? " AND crm_business_contact.primary=1 " : "");
520      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
521      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
522      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
523      $db->query($q);
524      while ($db->next_record())
525      {
526          $business_ids[] = $db->f("entity_id");
527      }
528      return $business_ids;
529  }
publicget_business_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
530  public function get_business_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
531  {
532      $ids = $this->get_business_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
533      $objects = array();
534      foreach ($ids as $index=>$id)
535      {
536          $objects[$index] = new business($id);
537      }
538      return $objects;
539  }
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_calendar ( type ["default"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
405  public function get_calendar($__type="default")
406  {
407      $object = is_null(keyval($this->property_objects_array,"{$__type}_calendar")) ? new calendar($this->get_calendar_id($__type)) : $this->property_objects_array["{$__type}_calendar"];
408      $this->property_objects_array["{$__type}_calendar"] = $object;
409      return $object;
410  }
publicget_calendar_id ( type ["default"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
411  public function get_calendar_id($__type="default")
412  {
413      $ids = $this->get_calendar_ids($__type, true);
414      return (count($ids)==1 ? $ids[0] : null);
415  }
publicget_calendar_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
416  public function get_calendar_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
417  {
418      $calendar_ids = array();
419      $db = contact::db();
420      $q  = " SELECT cal_calendar.id FROM crm_calendar_contact INNER JOIN cal_calendar ON crm_calendar_contact.calendar_id=cal_calendar.id AND crm_calendar_contact.deleted=0 AND cal_calendar.deleted=0 AND crm_calendar_contact.contact_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND crm_calendar_contact.calendar_contact_type_id='" . calendar_contact::type_id($__type) . "'") . ($__get_primary ? " AND crm_calendar_contact.primary=1 " : "");
421      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
422      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
423      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
424      $db->query($q);
425      while ($db->next_record())
426      {
427          $calendar_ids[] = $db->f("id");
428      }
429      return $calendar_ids;
430  }
publicget_calendar_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
431  public function get_calendar_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
432  {
433      $ids = $this->get_calendar_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
434      $objects = array();
435      foreach ($ids as $index=>$id)
436      {
437          $objects[$index] = new calendar($id);
438      }
439      return $objects;
440  }
publicget_child_count ( )[ contact_ext ]
Parameters
No parameters for this method
Code
062  public function get_child_count()
063  {
064      return count(contact_contact::get_ids(null,$this->_id));
065  }
publicget_children ( )[ contact_ext ]
Parameters
No parameters for this method
Code
020  public function get_children()
021  {
022      $children = array();
023      foreach (contact_contact::get_ids(null,$this->_id) as $contact_contact_id)
024      {
025          $contact_contact = new contact_contact($contact_contact_id);
026          $children[] = new contact($contact_contact->child_id);
027      }
028      return $children;
029  }
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] )[ contact_db ]
Parameters
requiredcolumns
optionalorder
optionallookups
optionalwhere_clause
optionallimit
optionaloffset [0]
Code
249  public static function get_columns($__columns, $__order=null, $__lookups=null, $__where_clause=null, $__limit=null, $__offset=0)
250  {
251      $lookups = is_array($__lookups) ? $__lookups : array($__lookups);
252      $colarray = is_array($__columns) ? $__columns : explode(",",$__columns);
253      $colstring = is_array($__columns) ? implode(",",$__columns) : $__columns;
254 
255      $db = contact::db();
256      $data = array();
257      $q  = " SELECT $colstring ";
258      $q .= " FROM crm_contact ";
259      $q .= " INNER JOIN cor_person ON crm_contact.person_entity_id=cor_person.entity_id ";
260      $q .= array_key_exists("person_type_id",$lookups) ? " AND cor_person.person_type_id='" . $lookups["person_type_id"] . "' " : "";
261      $q .= " INNER JOIN cor_entity ON cor_person.entity_id=cor_entity.id ";
262      $q .= array_key_exists("entity_type_id",$lookups) ? " AND cor_entity.entity_type_id='" . $lookups["entity_type_id"] . "' " : "";
263      $q .= " WHERE crm_contact.deleted = 0 ";
264      $q .= is_null($__where_clause) ? null : " AND ($__where_clause) ";
265 
266      if (is_string($__order))
267      {
268          $q .= "ORDER BY " . $__order;
269      }
270      else if (is_array($__order) and count($__order)>0)
271      {
272          $orderings = array();
273          foreach ($__order as $col=>$dir)
274          {
275              $orderings[] = " $col $dir ";
276          }
277          $q .= "ORDER BY " . implode(", ", $orderings);
278      }
279      else if (is_object($__order))
280      {
281          $q .= "";
282      }
283      else
284      {
285          // THERE IS NO `order` COLUMN ON THIS OBJECT
286      }
287 
288      if (!is_null($__limit))
289      {
290          $q .= " LIMIT $__offset , $__limit ";
291      }
292 
293      $db->query($q);
294 
295      if (count($colarray)>1 || $colstring=="*")
296      {
297          while ($db->next_record())
298          {
299              $data[] = $db->record;
300          }
301      }
302      else
303      {
304          while ($db->next_record())
305          {
306              $data[] = $db->f(0);
307          }
308      }
309 
310      return $data;
311  }
publicget_comment ( type ["default"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
702  public function get_comment($__type="default")
703  {
704      $object = is_null(keyval($this->property_objects_array,"{$__type}_comment")) ? new comment($this->get_comment_id($__type)) : $this->property_objects_array["{$__type}_comment"];
705      $this->property_objects_array["{$__type}_comment"] = $object;
706      return $object;
707  }
publicget_comment_id ( type ["default"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
708  public function get_comment_id($__type="default")
709  {
710      $ids = $this->get_comment_ids($__type, true);
711      return (count($ids)==1 ? $ids[0] : null);
712  }
publicget_comment_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
713  public function get_comment_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
714  {
715      $comment_ids = array();
716      $db = contact::db();
717      $q  = " SELECT cor_comment.id FROM crm_comment_contact INNER JOIN cor_comment ON crm_comment_contact.comment_id=cor_comment.id AND crm_comment_contact.deleted=0 AND cor_comment.deleted=0 AND crm_comment_contact.contact_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND crm_comment_contact.comment_contact_type_id='" . comment_contact::type_id($__type) . "'") . ($__get_primary ? " AND crm_comment_contact.primary=1 " : "");
718      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
719      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
720      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
721      $db->query($q);
722      while ($db->next_record())
723      {
724          $comment_ids[] = $db->f("id");
725      }
726      return $comment_ids;
727  }
publicget_comment_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
728  public function get_comment_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
729  {
730      $ids = $this->get_comment_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
731      $objects = array();
732      foreach ($ids as $index=>$id)
733      {
734          $objects[$index] = new comment($id);
735      }
736      return $objects;
737  }
publicget_descendants ( )[ contact_ext ]
Parameters
No parameters for this method
Code
031  public function get_descendants()
032  {
033      $descendants = array();
034      foreach ($this->children as $child)
035      {
036          $descendants[] = $child;
037          if ($child->has_children)
038          {
039              $descendants = array_unique(array_merge($descendants, $child->descendants));
040          }
041      }
042      return $descendants;
043  }
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_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"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
603  public function get_event($__type="default")
604  {
605      $object = is_null(keyval($this->property_objects_array,"{$__type}_event")) ? new event($this->get_event_id($__type)) : $this->property_objects_array["{$__type}_event"];
606      $this->property_objects_array["{$__type}_event"] = $object;
607      return $object;
608  }
publicget_event_id ( type ["default"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
609  public function get_event_id($__type="default")
610  {
611      $ids = $this->get_event_ids($__type, true);
612      return (count($ids)==1 ? $ids[0] : null);
613  }
publicget_event_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
614  public function get_event_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
615  {
616      $event_ids = array();
617      $db = contact::db();
618      $q  = " SELECT cal_event.id FROM crm_contact_event INNER JOIN cal_event ON crm_contact_event.event_id=cal_event.id AND crm_contact_event.deleted=0 AND cal_event.deleted=0 AND crm_contact_event.contact_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND crm_contact_event.contact_event_type_id='" . contact_event::type_id($__type) . "'") . ($__get_primary ? " AND crm_contact_event.primary=1 " : "");
619      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
620      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
621      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
622      $db->query($q);
623      while ($db->next_record())
624      {
625          $event_ids[] = $db->f("id");
626      }
627      return $event_ids;
628  }
publicget_event_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
629  public function get_event_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
630  {
631      $ids = $this->get_event_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
632      $objects = array();
633      foreach ($ids as $index=>$id)
634      {
635          $objects[$index] = new event($id);
636      }
637      return $objects;
638  }
publicget_group ( type ["default"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
801  public function get_group($__type="default")
802  {
803      $object = is_null(keyval($this->property_objects_array,"{$__type}_group")) ? new group($this->get_group_id($__type)) : $this->property_objects_array["{$__type}_group"];
804      $this->property_objects_array["{$__type}_group"] = $object;
805      return $object;
806  }
publicget_group_id ( type ["default"] )[ contact_db ]
Parameters
optionaltype ["default"]
Code
807  public function get_group_id($__type="default")
808  {
809      $ids = $this->get_group_ids($__type, true);
810      return (count($ids)==1 ? $ids[0] : null);
811  }
publicget_group_ids ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
812  public function get_group_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
813  {
814      $group_ids = array();
815      $db = contact::db();
816      $q  = " SELECT cor_group.id FROM crm_contact_group INNER JOIN cor_group ON crm_contact_group.group_id=cor_group.id AND crm_contact_group.deleted=0 AND cor_group.deleted=0 AND crm_contact_group.contact_person_entity_id='$this->id' " . (is_null($__type) ? "" : " AND crm_contact_group.contact_group_type_id='" . contact_group::type_id($__type) . "'") . ($__get_primary ? " AND crm_contact_group.primary=1 " : "");
817      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
818      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
819      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
820      $db->query($q);
821      while ($db->next_record())
822      {
823          $group_ids[] = $db->f("id");
824      }
825      return $group_ids;
826  }
publicget_group_list ( type , order , where_clause , limit , offset [0] , get_primary [false] )[ contact_db ]
Parameters
optionaltype
optionalorder
optionalwhere_clause
optionallimit
optionaloffset [0]
optionalget_primary [false]
Code
827  public function get_group_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
828  {
829      $ids = $this->get_group_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
830      $objects = array();
831      foreach ($ids as $index=>$id)
832      {
833          $objects[$index] = new group($id);
834      }
835      return $objects;
836  }
publicget_has_children ( )[ contact_ext ]
Parameters
No parameters for this method
Code
057  public function get_has_children()
058  {
059      return ($this->child_count > 0);
060  }
public staticget_ids ( order , lookups , where_clause , limit , offset [0] )[ contact_db ]
Parameters
optionalorder
optionallookups
optionalwhere_clause
optionallimit
optionaloffset [0]
Code
313  public static function get_ids($__order=null, $__lookups=null, $__where_clause=null, $__limit=null, $__offset=0)
314  {
315      return contact::get_columns("person_entity_id", $__order, $__lookups, $__where_clause, $__limit, $__offset);
316  }
publicget_is_root ( )[ contact_ext ]
Parameters
No parameters for this method
Code
095  public function get_is_root()
096  {
097      return ($this->parent->id == 0);
098  }
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_level ( )[ contact_ext ]
Parameters
No parameters for this method
Code
067  public function get_level()
068  {
069      if ($this->is_root)
070      {
071          return 0;
072      }
073      $level = 1;
074      $parent = $this->parent;
075      while (!$parent->is_root)
076      {
077          $parent = $parent->parent;
078          $level++;
079      }
080      return $level;
081  }
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] )[ contact_db ]
Parameters
optionalorder
optionallookups
optionalwhere_clause
optionallimit
optionaloffset [0]
Code
318  public static function get_objects($__order=null, $__lookups=null, $__where_clause=null, $__limit=null, $__offset=0)
319  {
320      $objects = array();
321      foreach (contact::get_columns("person_entity_id", $__order, $__lookups, $__where_clause, $__limit, $__offset) as $id)
322      {
323          $objects[] = new contact($id);
324      }
325      return $objects;
326  }
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_parent ( )[ contact_ext ]
Parameters
No parameters for this method
Code
083  public function get_parent()
084  {
085      $parent = new contact();
086      foreach (contact_contact::get_ids($this->_id,null) as $contact_contact_id)
087      {
088          $contact_contact = new contact_contact($contact_contact_id);
089          $parent = new contact($contact_contact->parent_id);
090          break;
091      }
092      return $parent;
093  }
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 ( )[ contact_db ]
Parameters
No parameters for this method
Code
393  public function get_person()
394  {
395      return new person($this->person_id);
396  }
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_prefixed_name ( )[ contact_ext ]
Parameters
No parameters for this method
Code
114  public function get_prefixed_name()
115  {
116      return "$this->_prefix $this->name";
117  }
publicget_projectentity ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1631  public function get_projectentity($__type="default")
1632  {
1633      $object = is_null(keyval($this->property_objects_array,"{$__type}_projectentity")) ? new projectentity($this->get_projectentity_id($__type)) : $this->property_objects_array["{$__type}_projectentity"];
1634      $this->property_objects_array["{$__type}_projectentity"] = $object;
1635      return $object;
1636  }
publicget_projectentity_id ( type ["default"] )[ entity_db ]
Parameters
optionaltype ["default"]
Code
1637  public function get_projectentity_id($__type="default")
1638  {
1639      $ids = $this->get_projectentity_ids($__type, true);
1640      return (count($ids)==1 ? $ids[0] : null);
1641  }
publicget_projectentity_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
1642  public function get_projectentity_ids($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1643  {
1644      $projectentity_ids = array();
1645      $db = entity::db();
1646      $q  = " SELECT prj_projectentity.id FROM prj_entity_projectentity INNER JOIN prj_projectentity ON prj_entity_projectentity.projectentity_id=prj_projectentity.id AND prj_entity_projectentity.deleted=0 AND prj_projectentity.deleted=0 AND prj_entity_projectentity.entity_id='$this->id' " . (is_null($__type) ? "" : " AND prj_entity_projectentity.entity_projectentity_type_id='" . entity_projectentity::type_id($__type) . "'") . ($__get_primary ? " AND prj_entity_projectentity.primary=1 " : "");
1647      $q .= is_null($__where_clause) ? "" : " WHERE {$__where_clause}";
1648      $q .= is_null($__order) ? "" : " ORDER BY {$__order}";
1649      $q .= is_null($__limit) ? "" : " LIMIT {$__offset}, {$__limit}";
1650      $db->query($q);
1651      while ($db->next_record())
1652      {
1653          $projectentity_ids[] = $db->f("id");
1654      }
1655      return $projectentity_ids;
1656  }
publicget_projectentity_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
1657  public function get_projectentity_list($__type=null, $__order=null, $__where_clause=null, $__limit=null, $__offset=0, $__get_primary=false)
1658  {
1659      $ids = $this->get_projectentity_ids($__type, $__order, $__where_clause, $__limit, $__offset, $__get_primary);
1660      $objects = array();
1661      foreach ($ids as $index=>$id)
1662      {
1663          $objects[$index] = new projectentity($id);
1664      }
1665      return $objects;
1666  }
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  }
public