/** * Return default contact IM type * * @access public * @param Contact $contact * @return ImType */ function getDefaultContactImType(Contact $contact) { $contact_im_values_table = ContactImValues::instance()->getTableName(true); $im_types_table = ImTypes::instance()->getTableName(true); $sql = "SELECT {$im_types_table}.* FROM {$im_types_table}, {$contact_im_values_table} WHERE {$im_types_table}.`id` = {$contact_im_values_table}.`im_type_id` AND {$contact_im_values_table}.`is_default` = '1' AND {$contact_im_values_table}.`contact_id` = ?"; $row = DB::executeOne($sql, $contact->getId()); if (is_array($row)) { return ImTypes::instance()->loadFromRow($row); } // if return null; }
/** * Return default contact Address type * * @access public * @param Contact $contact * @return AddressType */ function getContactMainAddressType(Contact $contact) { $contact_address_values_table = ContactAddresss::instance()->getTableName(true); $address_types_table = AddressTypes::instance()->getTableName(true); $sql = "SELECT {$address_types_table}.* FROM {$address_types_table}, {$contact_address_values_table} WHERE {$address_types_table}.`id` = {$contact_address_values_table}.`address_type_id` AND {$contact_address_values_table}.`is_main` = '1' AND {$contact_address_values_table}.`contact_id` = ?"; $row = DB::executeOne($sql, $contact->getId()); if (is_array($row)) { return ImTypes::instance()->loadFromRow($row); } // if return null; }
/** * Return main contact IM type * * @access public * @param Contact $contact * @return ImType */ function getContactMainImType(Contact $contact) { $contact_im_values_table = ContactImValues::instance()->getTableName(true); $im_types_table = ImTypes::instance()->getTableName(true); $sql = "SELECT $im_types_table.* FROM $im_types_table, $contact_im_values_table WHERE $im_types_table.`id` = $contact_im_values_table.`im_type_id` AND $contact_im_values_table.`is_main` = '1' AND $contact_im_values_table.`contact_id` = ?"; $row = DB::executeOne($sql, $contact->getId()); if(is_array($row)) { return ImTypes::instance()->loadFromRow($row); } // if return null; } // getContactMainImType
/** * Return manager instance * * @access protected * @param void * @return ImTypes */ function manager() { if (!$this->manager instanceof ImTypes) { $this->manager = ImTypes::instance(); } return $this->manager; }
/** * This function will return paginated result. Result is an array where first element is * array of returned object and second populated pagination object that can be used for * obtaining and rendering pagination data using various helpers. * * Items and pagination array vars are indexed with 0 for items and 1 for pagination * because you can't use associative indexing with list() construct * * @access public * @param array $arguments Query argumens (@see find()) Limit and offset are ignored! * @param integer $items_per_page Number of items per page * @param integer $current_page Current page number * @return array */ function paginate($arguments = null, $items_per_page = 10, $current_page = 1) { if (isset($this) && instance_of($this, 'ImTypes')) { return parent::paginate($arguments, $items_per_page, $current_page); } else { return ImTypes::instance()->paginate($arguments, $items_per_page, $current_page); //$instance =& ImTypes::instance(); //return $instance->paginate($arguments, $items_per_page, $current_page); } // if }
/** * Return manager instance * * @access protected * @param void * @return ImTypes */ function manager() { if(!($this->manager instanceof ImTypes)) $this->manager = ImTypes::instance(); return $this->manager; } // manager