CRM_Contact_BAO_Relationship
class CRM_Contact_BAO_Relationship extends CRM_Contact_DAO_Relationship
Class CRM_Contact_BAO_Relationship.
Constants
NOT_NULL |
|
IS_NULL |
|
DB_DAO_NOTNULL |
|
VALUE_SEPARATOR |
|
BULK_INSERT_COUNT |
|
BULK_INSERT_HIGH_COUNT |
|
QUERY_FORMAT_WILDCARD |
|
QUERY_FORMAT_NO_QUOTES |
|
ALL |
Various constants to indicate different type of relationships. |
PAST |
Various constants to indicate different type of relationships. |
DISABLED |
Various constants to indicate different type of relationships. |
CURRENT |
Various constants to indicate different type of relationships. |
INACTIVE |
Various constants to indicate different type of relationships. |
Properties
static null | $_nullObject | from CRM_Core_DAO | |
static array | $_nullArray | from CRM_Core_DAO | |
static | $_dbColumnValueCache | from CRM_Core_DAO | |
static array | $_testEntitiesToSkip | Define entities that shouldn't be created or deleted when creating/ deleting test objects - this prevents world regions, countries etc from being added / deleted | from CRM_Core_DAO |
static object | $_factory | The factory class for this application. | from CRM_Core_DAO |
static | $_checkedSqlFunctionsExist | from CRM_Core_DAO | |
protected | $_options | https://issues.civicrm.org/jira/browse/CRM-17748 internal variable for DAO to hold per-query settings | from CRM_Core_DAO |
static string | $_tableName | Static instance to hold the table name. | from CRM_Contact_DAO_Relationship |
static boolean | $_log | Should CiviCRM log any modifications to this table in the civicrm_log table. | from CRM_Contact_DAO_Relationship |
int | $id | Relationship ID | from CRM_Contact_DAO_Relationship |
int | $contact_id_a | id of the first contact | from CRM_Contact_DAO_Relationship |
int | $contact_id_b | id of the second contact | from CRM_Contact_DAO_Relationship |
int | $relationship_type_id | id of the relationship | from CRM_Contact_DAO_Relationship |
date | $start_date | date when the relationship started | from CRM_Contact_DAO_Relationship |
date | $end_date | date when the relationship ended | from CRM_Contact_DAO_Relationship |
boolean | $is_active | is the relationship active ? | from CRM_Contact_DAO_Relationship |
string | $description | Optional verbose description for the relationship. | from CRM_Contact_DAO_Relationship |
boolean | $is_permission_a_b | is contact a has permission to view / edit contact and related data for contact b ? | from CRM_Contact_DAO_Relationship |
boolean | $is_permission_b_a | is contact b has permission to view / edit contact and related data for contact a ? | from CRM_Contact_DAO_Relationship |
int | $case_id | FK to civicrm_case | from CRM_Contact_DAO_Relationship |
Methods
Generate and assign an arbitrary value to a field of a test object.
Execute a query by the current DAO, localizing it along the way (if needed).
Static function to set the factory instance for this class.
Factory method to instantiate a new object from a table name.
Initialization for all DAO objects. Since we access DB_DO programatically we need to set the links manually.
Returns foreign keys and entity references.
Deletes items from table which match current objects variables.
Given an associative array of name/value pairs, extract all the values that belong to this object and initialize the object with said values
Store all the values from this object in an associative array this is a destructive store, calling function is responsible for keeping sanity of id's.
Create an attribute for this specific field. We only do this for strings and text
Get the size and maxLength attributes for this text field.
Check if there is a record with the same name in the db.
Check if there is a given column in a specific table.
Scans all the tables using a slow query and table name.
Checks if a constraint exists for a specified table.
Checks if CONSTRAINT keyword exists for a specified table.
Checks if the FK constraint name is in the format 'FK_tableName_columnName' for a specified column of a table.
Check whether a specific column in a specific table has always the same value.
Check whether a specific column in a specific table is always NULL.
Check if there is a given table in the database.
Get all the result records as mapping between columns.
Given a DAO name, a column name and a column value, find the record and GET the value of another column in that record
Given a DAO name, a column name and a column value, find the record and SET the value of another column in that record
Get sort string.
Fetch object based on array of properties.
Delete the object records that are associated with this contact.
Execute an unbuffered query.
Execute a query.
Execute a query and get the single result.
Compose the query by merging the parameters into it.
make a shallow copy of an object.
Cascade update through related entities.
Given the component id, compute the contact id since its used for things like send email
Fetch object based on array of properties.
Escape a list of strings for use with "WHERE X IN (.
Creates a test object, including any required objects it needs via recursion createOnly: only create in database, do not store or return the objects (useful for perf testing) ONLY USE FOR TESTING
Deletes the this object plus any dependent objects that are associated with it.
Set defaults when creating new entity.
No description
No description
Build a list of triggers via hook and add them to (err, reconcile them with) the database.
Because sql functions are sometimes lost, esp during db migration, we check here to avoid numerous support requests
Given a list of fields, create a list of references.
List all tables which have hard foreign keys to this table.
Lookup the value of a MySQL global configuration variable.
Update the fields array to also hold keys for pseudoconstant fields that relate to contained fields.
Get options for the called BAO object's field.
Provides documentation and validation for the buildOptions $context param
Get SQL where clause for SQL filter syntax input parameters.
SQL has a limit of 64 characters on various names: table name, trigger name, column name .
https://issues.civicrm.org/jira/browse/CRM-17748 Sets the internal options to be used on a query
https://issues.civicrm.org/jira/browse/CRM-17748 wrapper to pass internal DAO options down to DB_mysql/DB_Common level
Generates acl clauses suitable for adding to WHERE or ON when doing an api.get for this entity
This returns the final permissioned query string for this entity
ensure database name is 'safe', i.e. only contains word characters (includes underscores) and dashes, and contains at least one [a-z] case insenstive.
Return a mapping from field-name to the corresponding key (as used in fields()).
Returns the list of fields that can be imported
Returns the list of fields that can be exported
Create function - use the API instead.
Create multiple relationships for one contact.
Takes an associative array and creates a relationship object.
This is the function that check/add if the relationship created is valid.
Add relationship to recent links.
Load contact ids and relationship type id when doing a create call if not provided.
Resolve passed in contact IDs to contact_id_a & contact_id_b.
Specify defaults for creating a relationship.
Check if there is data to create the object.
Get get list of relationship type based on the contact type.
Given a list of relationship types, return the list with duplicate types removed, being careful to retain only the duplicate which matches the given 'a_b' or 'b_a' suffix.
Delete current employer relationship.
Delete the relationship.
Disable/enable the relationship.
Delete the object records that are associated with this contact.
Get the other contact in a relationship.
Check if the relationship type selected between two contacts is correct.
This function does the validtion for valid relationship.
This function checks for duplicate relationship.
Update the is_active flag in the db.
Fetch a relationship object and store the values in the values array.
Helper function to form the sql for relationship retrieval.
Get a list of relationships.
Get get list of relationship type based on the target contact type.
Create / update / delete membership for related contacts.
Helper function to check whether the membership is expired or not.
Get Current Employer for Contact.
Function to return list of permissioned contacts for a given contact and relationship type.
Merge relationships from otherContact to mainContact.
Set 'is_valid' field to false for all relationships whose end date is in the past, ie. are expired.
Function filters the query by possible relationships for the membership type.
Wrapper for contact relationship selector.
Details
in CRM_Contact_DAO_Relationship at line 124
CRM_Core_DAO
__construct()
Class constructor.
in CRM_Contact_DAO_Relationship at line 325
static
getTableName()
Returns the names of this table
in CRM_Core_DAO at line 112
static
init(string $dsn)
Initialize the DAO object.
in CRM_Core_DAO at line 131
static DB_common
getConnection()
in CRM_Core_DAO at line 142
protected
assignTestFK(string $fieldName, $fieldDef, array $params)
in CRM_Core_DAO at line 191
protected
assignTestValue(string $fieldName, array $fieldDef, int $counter)
Generate and assign an arbitrary value to a field of a test object.
in CRM_Core_DAO at line 303
reset()
Reset the DAO object.
DAO is kinda crappy in that there is an unwritten rule of one query per DAO.
We attempt to get around this crappy restriction by resetting some of DAO's internal fields. Use this with caution
in CRM_Core_DAO at line 323
static string
getLocaleTableName(string $tableName)
in CRM_Core_DAO at line 345
object
query(string $query, bool $i18nRewrite = TRUE)
Execute a query by the current DAO, localizing it along the way (if needed).
in CRM_Core_DAO at line 374
static
setFactory(object $factory)
Static function to set the factory instance for this class.
in CRM_Core_DAO at line 383
factory(string $table = '')
Factory method to instantiate a new object from a table name.
in CRM_Core_DAO at line 395
initialize()
Initialization for all DAO objects. Since we access DB_DO programatically we need to set the links manually.
in CRM_Core_DAO at line 411
array
keys()
Defines the default key as 'id'.
in CRM_Core_DAO at line 426
array
sequenceKey()
Tells DB_DataObject which keys use autoincrement.
'id' is autoincrementing by default.
in CRM_Contact_DAO_Relationship at line 134
static array
getReferenceColumns()
Returns foreign keys and entity references.
in CRM_Contact_DAO_Relationship at line 150
static array
fields()
Returns all the column names of this table
in CRM_Core_DAO at line 462
array
table()
Get/set an associative array of table columns
in CRM_Core_DAO at line 485
CRM_Core_DAO
save(bool $hook = TRUE)
Save DAO object.
in CRM_Core_DAO at line 536
delete(bool $useWhere = FALSE)
Deletes items from table which match current objects variables.
Returns the true on success
for example
Designed to be extended
$object = new mytable(); $object->ID=123; echo $object->delete(); // builds a conditon
$object = new mytable(); $object->whereAdd('age > 12'); $object->limit(1); $object->orderBy('age DESC'); $object->delete(true); // dont use object vars, use the conditions, limit and order.
in CRM_Core_DAO at line 552
log(bool $created = FALSE)
in CRM_Core_DAO at line 587
bool
copyValues(array $params)
Given an associative array of name/value pairs, extract all the values that belong to this object and initialize the object with said values
in CRM_Core_DAO at line 628
static
storeValues(object $object, array $values)
Store all the values from this object in an associative array this is a destructive store, calling function is responsible for keeping sanity of id's.
in CRM_Core_DAO at line 650
static array|null
makeAttribute(array $field)
Create an attribute for this specific field. We only do this for strings and text
in CRM_Core_DAO at line 703
static array
getAttribute(string $class, string $fieldName = NULL)
Get the size and maxLength attributes for this text field.
(or for all text fields) in the DAO object.
in CRM_Core_DAO at line 731
static
transaction($type)
in CRM_Core_DAO at line 754
static bool
objectExists(string $value, string $daoName, string $daoID, string $fieldName = 'name', string $domainID = NULL)
Check if there is a record with the same name in the db.
in CRM_Core_DAO at line 780
static bool
checkFieldExists(string $tableName, string $columnName, bool $i18nRewrite = TRUE)
Check if there is a given column in a specific table.
in CRM_Core_DAO at line 798
static array
getTableNames()
Scans all the tables using a slow query and table name.
in CRM_Core_DAO at line 820
static bool
isDBMyISAM(int $maxTablesToCheck = 10)
in CRM_Core_DAO at line 837
static string
getDatabaseName()
Get the name of the CiviCRM database.
in CRM_Core_DAO at line 851
static bool
checkConstraintExists(string $tableName, string $constraint)
Checks if a constraint exists for a specified table.
in CRM_Core_DAO at line 879
static bool
schemaRequiresRebuilding(array $tables = array("civicrm_contact"))
Checks if CONSTRAINT keyword exists for a specified table.
in CRM_Core_DAO at line 915
static bool
checkFKConstraintInFormat(string $tableName, string $columnName)
Checks if the FK constraint name is in the format 'FK_tableName_columnName' for a specified column of a table.
in CRM_Core_DAO at line 944
static bool
checkFieldHasAlwaysValue(string $tableName, string $columnName, string $columnValue)
Check whether a specific column in a specific table has always the same value.
in CRM_Core_DAO at line 961
static bool
checkFieldIsAlwaysNull(string $tableName, string $columnName)
Check whether a specific column in a specific table is always NULL.
in CRM_Core_DAO at line 977
static bool
checkTableExists(string $tableName)
Check if there is a given table in the database.
in CRM_Core_DAO at line 995
bool
checkVersion($version)
in CRM_Core_DAO at line 1013
static object
findById(int $id)
Find a DAO object for the given ID and return it.
in CRM_Core_DAO at line 1027
array
fetchAll()
Returns all results as array-encoded records.
in CRM_Core_DAO at line 1045
array
fetchMap(string $keyColumn, string $valueColumn)
Get all the result records as mapping between columns.
in CRM_Core_DAO at line 1070
static string|null
getFieldValue(string $daoName, int $searchValue, string $returnColumn = 'name', string $searchColumn = 'id', bool $force = FALSE)
Given a DAO name, a column name and a column value, find the record and GET the value of another column in that record
in CRM_Core_DAO at line 1120
static bool
setFieldValue(string $daoName, int $searchValue, string $setColumn, string $setValue, string $searchColumn = 'id')
Given a DAO name, a column name and a column value, find the record and SET the value of another column in that record
in CRM_Core_DAO at line 1146
static string
getSortString(array|object $sort, string $default = NULL)
Get sort string.
in CRM_Core_DAO at line 1177
static object
commonRetrieve(string $daoName, array $params, array $defaults, array $returnProperities = NULL)
Fetch object based on array of properties.
in CRM_Core_DAO at line 1202
static
deleteEntityContact(string $daoName, int $contactId)
Delete the object records that are associated with this contact.
in CRM_Core_DAO at line 1227
static CRM_Core_DAO
executeUnbufferedQuery(string $query, array $params = array(), bool $abort = TRUE, null $daoName = NULL, bool $freeDAO = FALSE, bool $i18nRewrite = TRUE, bool $trapException = FALSE)
Execute an unbuffered query.
This is a wrapper around new functionality exposed with CRM-17748.
in CRM_Core_DAO at line 1293
static CRM_Core_DAO|object
executeQuery(string $query, array $params = array(), bool $abort = TRUE, null $daoName = NULL, bool $freeDAO = FALSE, bool $i18nRewrite = TRUE, bool $trapException = FALSE)
Execute a query.
in CRM_Core_DAO at line 1343
static string|null
singleValueQuery(string $query, array $params = array(), bool $abort = TRUE, bool $i18nRewrite = TRUE)
Execute a query and get the single result.
in CRM_Core_DAO at line 1381
static string
composeQuery(string $query, array $params, bool $abort = TRUE)
Compose the query by merging the parameters into it.
in CRM_Core_DAO at line 1428
static
freeResult(null $ids = NULL)
in CRM_Core_DAO at line 1474
static CRM_Core_DAO
copyGeneric(string $daoName, array $criteria, array $newData = NULL, string $fieldsFix = NULL, string $blockCopyOfDependencies = NULL)
make a shallow copy of an object.
and all the fields in the object
in CRM_Core_DAO at line 1557
static CRM_Core_DAO|null
cascadeUpdate(string $daoName, $fromId, $toId, array $newData = array())
Cascade update through related entities.
in CRM_Core_DAO at line 1601
static array
getContactIDsFromComponent($componentIDs, string $tableName)
Given the component id, compute the contact id since its used for things like send email
in CRM_Core_DAO at line 1636
static object
commonRetrieveAll(string $daoName, string $fieldIdName = 'id', int $fieldId, $details, array $returnProperities = NULL)
Fetch object based on array of properties.
in CRM_Core_DAO at line 1658
static
dropAllTables()
in CRM_Core_DAO at line 1680
static string
escapeString($string)
in CRM_Core_DAO at line 1709
static string
escapeStrings(array $strings, string $default = NULL)
Escape a list of strings for use with "WHERE X IN (.
..)" queries.
in CRM_Core_DAO at line 1728
static string
escapeWildCardString($string)
in CRM_Core_DAO at line 1756
static object|array|NULL
createTestObject(string $daoName, array $params = array(), int $numObjects = 1, bool $createOnly = FALSE)
Creates a test object, including any required objects it needs via recursion createOnly: only create in database, do not store or return the objects (useful for perf testing) ONLY USE FOR TESTING
in CRM_Core_DAO at line 1839
static
deleteTestObjects(string $daoName, array $params = array())
Deletes the this object plus any dependent objects that are associated with it.
ONLY USE FOR TESTING
in CRM_Core_DAO at line 1885
static
setCreateDefaults(array $params, $defaults)
Set defaults when creating new entity.
(don't call this set defaults as already in use with different signature in some places)
in CRM_Core_DAO at line 1903
static string
createTempTableName(string $prefix = 'civicrm', bool $addRandomString = TRUE, null $string = NULL)
in CRM_Core_DAO at line 1923
static bool
checkTriggerViewPermission(bool $view = TRUE, bool $trigger = TRUE)
in CRM_Core_DAO at line 1971
static
debugPrint(null $message = NULL, bool $printDAO = TRUE)
in CRM_Core_DAO at line 1995
static
triggerRebuild(string $tableName = NULL, bool $force = FALSE)
deprecated
deprecated
Build a list of triggers via hook and add them to (err, reconcile them with) the database.
in CRM_Core_DAO at line 2006
static
checkSqlFunctionsExist()
Because sql functions are sometimes lost, esp during db migration, we check here to avoid numerous support requests
in CRM_Core_DAO at line 2023
static
dropTriggers(string $tableName = NULL)
deprecated
deprecated
Wrapper function to drop triggers.
in CRM_Core_DAO at line 2034
static
createTriggers(array $info, string $onlyTableName = NULL)
deprecated
deprecated
in CRM_Core_DAO at line 2045
static array
createReferenceColumns(string $className)
Given a list of fields, create a list of references.
in CRM_Core_DAO at line 2068
array
findReferences()
Find all records which refer to this entity.
in CRM_Core_DAO at line 2097
array
getReferenceCounts()
in CRM_Core_DAO at line 2134
static array
getReferencesToTable(string $tableName)
List all tables which have hard foreign keys to this table.
For now, this returns a description of every entity_id/entity_table reference. TODO: filter dynamic entity references on the $tableName, based on schema metadata in dynamicForeignKey which enumerates a restricted set of possible entity_table's.
in CRM_Core_DAO at line 2158
static mixed
getGlobalSetting(string $name, mixed $default = NULL)
Lookup the value of a MySQL global configuration variable.
in CRM_Core_DAO at line 2183
static protected
appendPseudoConstantsToFields(array $fields)
Update the fields array to also hold keys for pseudoconstant fields that relate to contained fields.
This is relevant where we want to offer both the ID field and the label field as an option, e.g. search builder.
It is currently limited for optionGroupName for purposes keeping the scope of the change small, but is appropriate for other sorts of pseudoconstants.
in CRM_Core_DAO at line 2209
static array|bool
buildOptions(string $fieldName, string $context = NULL, array $props = array())
Get options for the called BAO object's field.
This function can be overridden by each BAO to add more logic related to context. The overriding function will generally call the lower-level CRM_Core_PseudoConstant::get
in CRM_Core_DAO at line 2220
getOptionLabels()
Populate option labels for this object's fields.
in CRM_Core_DAO at line 2246
static array
buildOptionsContext(string $context = NULL)
Provides documentation and validation for the buildOptions $context param
in CRM_Core_DAO at line 2266
bool|array
getFieldSpec(string $fieldName)
in CRM_Core_DAO at line 2309
static NULL|string|array
createSQLFilter(string $fieldName, array $filter, string $type = NULL, string $alias = NULL, bool $returnSanitisedArray = FALSE)
Get SQL where clause for SQL filter syntax input parameters.
SQL version of api function to assign filters to the DAO based on the syntax $field => array('IN' => array(4,6,9)) OR $field => array('LIKE' => array('%me%)) etc
in CRM_Core_DAO at line 2372
static array
acceptedSQLOperators()
in CRM_Core_DAO at line 2409
static string
shortenSQLName(string $string, int $length = 60, bool $makeRandom = FALSE)
SQL has a limit of 64 characters on various names: table name, trigger name, column name .
..
For custom groups and fields we generated names from user entered input which can be longer than this length, this function helps with creating strings that meet various criteria.
in CRM_Core_DAO at line 2435
setOptions(array $options)
https://issues.civicrm.org/jira/browse/CRM-17748 Sets the internal options to be used on a query
in CRM_Core_DAO at line 2448
protected
_setDBOptions(array $options)
https://issues.civicrm.org/jira/browse/CRM-17748 wrapper to pass internal DAO options down to DB_mysql/DB_Common level
in CRM_Core_DAO at line 2463
setApiFilter(array $params)
deprecated
deprecated
in CRM_Core_DAO at line 2480
array
addSelectWhereClause()
Generates acl clauses suitable for adding to WHERE or ON when doing an api.get for this entity
Return format is in the form of fieldname => clauses starting with an operator. e.g.:
in CRM_Core_DAO at line 2521
static array
getSelectWhereClause(string $tableAlias = NULL)
This returns the final permissioned query string for this entity
With acls from related entities + additional clauses from hook_civicrm_selectWhereClause
in CRM_Core_DAO at line 2544
static bool
requireSafeDBName($database)
ensure database name is 'safe', i.e. only contains word characters (includes underscores) and dashes, and contains at least one [a-z] case insenstive.
in CRM_Contact_DAO_Relationship at line 314
static array
fieldKeys()
Return a mapping from field-name to the corresponding key (as used in fields()).
in CRM_Contact_DAO_Relationship at line 333
boolean
getLog()
Returns if this table needs to be logged
in CRM_Contact_DAO_Relationship at line 343
static array
import(bool $prefix = false)
Returns the list of fields that can be imported
in CRM_Contact_DAO_Relationship at line 354
static array
export(bool $prefix = false)
Returns the list of fields that can be exported
in CRM_Contact_DAO_Relationship at line 361
static
indices($localize = TRUE)
Returns the list of indices
at line 53
static CRM_Contact_BAO_Relationship
create(array $params)
Create function - use the API instead.
Note that the previous create function has been renamed 'legacyCreateMultiple' and this is new in 4.6 All existing calls have been changed to legacyCreateMultiple except the api call - however, it is recommended that you call that as the end to end testing here is based on the api & refactoring may still be done.
at line 110
static array
createMultiple(array $params, string $primaryContactLetter)
Create multiple relationships for one contact.
The relationship details are the same for each relationship except the secondary contact id can be an array.
at line 162
static CRM_Contact_BAO_Relationship
legacyCreateMultiple(array $params, array $ids = array())
deprecated
deprecated
Takes an associative array and creates a relationship object.
at line 281
static CRM_Contact_BAO_Relationship
add(array $params, array $ids = array(), int $contactId = NULL)
This is the function that check/add if the relationship created is valid.
at line 352
static
addRecent(array $params, CRM_Contact_DAO_Relationship $relationship)
Add relationship to recent links.
at line 397
static array
loadExistingRelationshipDetails(array $params)
Load contact ids and relationship type id when doing a create call if not provided.
There are are various checks done in create which require this information which is optional when using id.
at line 432
static array
setContactABFromIDs(array $params, array $ids = array(), null $contactID = NULL)
Resolve passed in contact IDs to contact_id_a & contact_id_b.
at line 468
static array
getdefaults()
Specify defaults for creating a relationship.
at line 489
static bool
dataExists(array $params)
Check if there is data to create the object.
at line 521
static array
getContactRelationshipType(int $contactId = NULL, null $contactSuffix = NULL, string $relationshipId = NULL, string $contactType = NULL, bool $all = FALSE, string $column = 'label', bool $biDirectional = TRUE, array $contactSubType = NULL, bool $onlySubTypeRelationTypes = FALSE)
Get get list of relationship type based on the contact type.
at line 617
static array
removeRelationshipTypeDuplicates(array $relationshipTypeList, string $suffix = NULL)
Given a list of relationship types, return the list with duplicate types removed, being careful to retain only the duplicate which matches the given 'a_b' or 'b_a' suffix.
at line 646
static CRM_Contact_DAO_Relationship
clearCurrentEmployer(int $id, int $action)
Delete current employer relationship.
at line 686
static null
del(int $id)
Delete the relationship.
at line 736
static
disableEnableRelationship(int $id, int $action, array $params = array(), array $ids = array(), bool $active = FALSE)
Disable/enable the relationship.
at line 777
static
deleteContact(int $contactId)
Delete the object records that are associated with this contact.
at line 799
static CRM_Contact_DAO_Relationship
getRelationshipByID(int $id)
Get the other contact in a relationship.
at line 823
static bool
checkRelationshipType(int $contact_a, int $contact_b, int $relationshipTypeId)
Check if the relationship type selected between two contacts is correct.
at line 865
static string
checkValidRelationship(array $params, array $ids, int $contactId)
This function does the validtion for valid relationship.
at line 891
static bool
checkDuplicateRelationship(array $params, int $id, int $contactId, int $relationshipId)
This function checks for duplicate relationship.
at line 1013
static Object
setIsActive(int $id, bool $is_active)
Update the is_active flag in the db.
at line 1044
static array
getValues(array $params, array $values)
Fetch a relationship object and store the values in the values array.
at line 1088
static array
makeURLClause(int $contactId, int $status, int $numRelationship, int $count, int $relationshipId, string $direction, array $params = array())
Helper function to form the sql for relationship retrieval.
at line 1240
static array|int
getRelationship(int $contactId = NULL, int $status, int $numRelationship, int $count, int $relationshipId, array $links = NULL, int $permissionMask = NULL, bool $permissionedContact = FALSE, array $params = array())
Get a list of relationships.
at line 1453
static array
getRelationType(string $targetContactType)
Get get list of relationship type based on the target contact type.
at line 1486
static
relatedMemberships(int $contactId, array $params, array $ids, const|int $action = CRM_Core_Action::ADD, bool $active = TRUE)
Create / update / delete membership for related contacts.
This function will create/update/delete membership for related contact based on 1) contact have active membership 2) that membership is is extedned by the same relationship type to that of the existing relationship.
at line 1786
static bool
isRelatedMembershipExpired(array $membershipTypeRelationshipTypeIDs, int $contactId, int $mainRelatedContactId, int $relTypeId, array $relIds)
Helper function to check whether the membership is expired or not.
Function takes a list of related membership types and if it is not also passed a relationship ID of that types evaluates whether the membership status should be changed to expired.
at line 1827
static array
getCurrentEmployer($contactIds)
Get Current Employer for Contact.
at line 1859
static array
getPermissionedContacts(int $contactID, int $relTypeId = NULL, string $name = NULL, string $contactType = NULL)
Function to return list of permissioned contacts for a given contact and relationship type.
at line 1921
static
mergeRelationships(int $mainId, int $otherId, array $sqls)
Merge relationships from otherContact to mainContact.
Called during contact merge operation
at line 1956
static bool
disableExpiredRelationships()
Set 'is_valid' field to false for all relationships whose end date is in the past, ie. are expired.
at line 1983
static array|void
membershipTypeToRelationshipTypes(array $params, null $direction = NULL)
Function filters the query by possible relationships for the membership type.
It is intended to be called when constructing queries for the api (reciprocal & non-reciprocal) and to add clauses to limit the return to those relationships which COULD inherit a membership type (as opposed to those who inherit a particular membership
at line 2032
static array
getContactRelationshipSelector(array $params)
Wrapper for contact relationship selector.