CRM_Case_BAO_Case

Class constructor.

Returns the names of this table

Initialize the DAO object.

Generate and assign an arbitrary value to a field of a test object.

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

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.

Defines the default key as 'id'.

Tells DB_DataObject which keys use autoincrement.

'id' is autoincrementing by default.

Returns foreign keys and entity references.

Returns all the column names of this table

Get/set an associative array of table columns

Save DAO object.

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.

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.

(or for all text fields) in the DAO object.

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.

Get the name of the CiviCRM database.

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.

Find a DAO object for the given ID and return it.

Returns all results as array-encoded records.

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.

This is a wrapper around new functionality exposed with CRM-17748.

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.

and all the fields in the 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 (.

..)" queries.

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.

ONLY USE FOR TESTING

Set defaults when creating new entity.

(don't call this set defaults as already in use with different signature in some places)

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

Wrapper function to drop triggers.

Given a list of fields, create a list of references.

Find all records which refer to this entity.

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.

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.

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.

Get options for a given case field.

Populate option labels for this object's fields.

Provides documentation and validation for the buildOptions $context param

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

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.

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

This returns the final permissioned query string for this entity

With acls from related entities + additional clauses from hook_civicrm_selectWhereClause

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 if this table needs to be logged

Returns the list of fields that can be imported

Returns the list of fields that can be exported

Returns the list of indices

Is CiviCase enabled?

Create a case object.

The function extracts all the params it needs to initialize the create a case object. the params array could contain additional unused name/value pairs

Takes an associative array and creates a case object.

Process case activity add/delete takes an associative array and

Get the case subject for Activity.

Get the case type.

Delete the record that are associated with this case.

record are deleted from case

Enable disable case related relationships.

Retrieve contact_id by case_id.

Look up a case using an activity ID.

Retrieve contact names by caseId.

Retrieve case_id by contact_id.

Retrieve cases related to particular contact or whole contact used in Dashboard and Tab.

Get the summary of cases counts by type and status.

Get Case roles.

Get Case Activities.

Get Case Related Contacts.

Send e-mail copy of activity

Retrieve count of activities having a particular type, and associated with a particular case.

Create an activity for a case via email.

Retrieve the scheduled activity type and date.

Combine all the exportable fields from the lower levels object.

Restore the record that are associated with this case.

Convenience function to get both case contacts and global in one array.

Get Case ActivitiesDueDates with given criteria.

Create activities when Case or Other roles assigned/modified/deleted.

Get case manger contact which is assigned a case role of case manager.

Retrieve related case ids for given case.

Retrieve related case details for given case.

Merge two duplicate contacts' cases - follow CRM-5758 rules.

Function perform two task.

1. Merge two duplicate contacts cases - follow CRM-5758 rules.
2. Merge two cases of same contact - follow CRM-5598 rules.

Validate contact permission for edit/view on activity record and build links.

Validate contact permission for given operation on activity record.

Since we drop 'access CiviCase', allow access if user has 'access my cases and activities' or 'access all cases and activities'

Verify user has permission to access a case.

Check whether activity is a case Activity.

Get all the case type ids currently in use.

Get all the case status ids currently in use.

Get all the encounter medium ids currently in use.

Check case configuration.

Used during case component enablement and during ugprade.

Helper function, also used by the upgrade in case of error

Add/copy relationships, when new client is added for a case

Get the list of clients for a case.

CRM-20308: Method to get the contact id to use as from contact for email copy 1. Activity Added by Contact's email address 2. System Default From Address 3. Default Organization Contact email address 4. Logged in user