/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('case_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case ID'), 'description' => 'Unique Case ID', 'required' => true, 'import' => true, 'where' => 'civicrm_case.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'case_type_id' => array('name' => 'case_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case Type'), 'description' => 'FK to civicrm_case_type.id', 'import' => true, 'where' => 'civicrm_case.case_type_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => false, 'FKClassName' => 'CRM_Case_DAO_CaseType', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_case_type', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'case_subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Case Subject'), 'description' => 'Short name of the case.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_case.subject', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'case_start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Case Start Date'), 'description' => 'Date on which given case starts.', 'import' => true, 'where' => 'civicrm_case.start_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'case_end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Case End Date'), 'description' => 'Date on which given case ends.', 'import' => true, 'where' => 'civicrm_case.end_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'details' => array('name' => 'details', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Details'), 'description' => 'Details about the meeting (agenda, notes, etc).', 'rows' => 8, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'case_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case Status'), 'description' => 'Id of case status.', 'required' => true, 'import' => true, 'where' => 'civicrm_case.status_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => false, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'case_status', 'optionEditPath' => 'civicrm/admin/options/case_status')), 'case_deleted' => array('name' => 'is_deleted', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Case is in the Trash'), 'import' => true, 'where' => 'civicrm_case.is_deleted', 'headerPattern' => '', 'dataPattern' => '', 'export' => true));
}
return self::$_fields;
}
/**
* returns all the column names of this table
*
* @access public
* @return array
*/
function &fields()
{
if (!self::$_fields) {
self::$_fields = array('case_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_case.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'case_type_id' => array('name' => 'case_type_id', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Case Type'), 'required' => true, 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_case.case_type_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Subject'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'case_start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Case Start Date'), 'import' => true, 'where' => 'civicrm_case.start_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'case_end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Case End Date'), 'import' => true, 'where' => 'civicrm_case.end_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'details' => array('name' => 'details', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Details'), 'rows' => 8, 'cols' => 60), 'case_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case Status'), 'required' => true, 'import' => true, 'where' => 'civicrm_case.status_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'case_deleted' => array('name' => 'is_deleted', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Case is in the Trash'), 'import' => true, 'where' => 'civicrm_case.is_deleted', 'headerPattern' => '', 'dataPattern' => '', 'export' => true));
}
return self::$_fields;
}
