/**
* returns all the column names of this table
*
* @access public
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('membership_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Membership ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_membership.id', 'headerPattern' => '/^(m(embership\\s)?id)$/i', 'dataPattern' => '', 'export' => true), 'membership_contact_id' => array('name' => 'contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contact ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_membership.contact_id', 'headerPattern' => '/contact(.?id)?/i', 'dataPattern' => '/^\\d+$/', 'export' => true, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'membership_type_id' => array('name' => 'membership_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Membership Type Id'), 'required' => true, 'import' => true, 'where' => 'civicrm_membership.membership_type_id', 'headerPattern' => '/^(m(embership\\s)?type)$/i', 'dataPattern' => '', 'export' => false, 'FKClassName' => 'CRM_Member_DAO_MembershipType'), 'join_date' => array('name' => 'join_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Member Since'), 'import' => true, 'where' => 'civicrm_membership.join_date', 'headerPattern' => '/^join|(j(oin\\s)?date)$/i', 'dataPattern' => '/\\d{4}-?\\d{2}-?\\d{2}/', 'export' => true), 'membership_start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Membership Start Date'), 'import' => true, 'where' => 'civicrm_membership.start_date', 'headerPattern' => '/(member(ship)?.)?start(s)?(.date$)?/i', 'dataPattern' => '/\\d{4}-?\\d{2}-?\\d{2}/', 'export' => true), 'membership_end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Membership Expiration Date'), 'import' => true, 'where' => 'civicrm_membership.end_date', 'headerPattern' => '/(member(ship)?.)?end(s)?(.date$)?/i', 'dataPattern' => '/\\d{4}-?\\d{2}-?\\d{2}/', 'export' => true), 'membership_source' => array('name' => 'source', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Source'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_membership.source', 'headerPattern' => '/^(member(ship?))?source$/i', 'dataPattern' => '', 'export' => true), 'status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Membership Status Id'), 'required' => true, 'import' => true, 'where' => 'civicrm_membership.status_id', 'headerPattern' => '/(member(ship|).)?(status)$/i', 'dataPattern' => '', 'export' => false, 'FKClassName' => 'CRM_Member_DAO_MembershipStatus'), 'is_override' => array('name' => 'is_override', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Status Override'), 'import' => true, 'where' => 'civicrm_membership.is_override', 'headerPattern' => '/override$/i', 'dataPattern' => '', 'export' => true), 'reminder_date' => array('name' => 'reminder_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Reminder Date')), 'owner_membership_id' => array('name' => 'owner_membership_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Primary Member ID'), 'export' => true, 'where' => 'civicrm_membership.owner_membership_id', 'headerPattern' => '', 'dataPattern' => '', 'FKClassName' => 'CRM_Member_DAO_Membership'), 'member_is_test' => array('name' => 'is_test', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Test'), 'import' => true, 'where' => 'civicrm_membership.is_test', 'headerPattern' => '/(is.)?test(.member(ship)?)?/i', 'dataPattern' => '', 'export' => true), 'member_is_pay_later' => array('name' => 'is_pay_later', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Pay Later'), 'import' => true, 'where' => 'civicrm_membership.is_pay_later', 'headerPattern' => '/(is.)?(pay(.)?later)$/i', 'dataPattern' => '', 'export' => true), 'contribution_recur_id' => array('name' => 'contribution_recur_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contribute_DAO_ContributionRecur'), 'member_campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Campaign ID'), 'import' => true, 'where' => 'civicrm_membership.campaign_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Campaign_DAO_Campaign'));
}
return self::$_fields;
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('membership_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Membership ID'), 'description' => 'Membership Id', 'required' => true, 'import' => true, 'where' => 'civicrm_membership.id', 'headerPattern' => '/^(m(embership\\s)?id)$/i', 'dataPattern' => '', 'export' => true), 'membership_contact_id' => array('name' => 'contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contact ID'), 'description' => 'FK to Contact ID', 'required' => true, 'import' => true, 'where' => 'civicrm_membership.contact_id', 'headerPattern' => '/contact(.?id)?/i', 'dataPattern' => '/^\\d+$/', 'export' => true, 'FKClassName' => 'CRM_Contact_DAO_Contact', 'html' => array('type' => 'Autocomplete-Select')), 'membership_type_id' => array('name' => 'membership_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Membership Type Id'), 'description' => 'FK to Membership Type', 'required' => true, 'import' => true, 'where' => 'civicrm_membership.membership_type_id', 'headerPattern' => '/^(m(embership\\s)?type)$/i', 'dataPattern' => '', 'export' => false, 'FKClassName' => 'CRM_Member_DAO_MembershipType', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_membership_type', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'join_date' => array('name' => 'join_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Member Since'), 'description' => 'Beginning of initial membership period (member since...).', 'import' => true, 'where' => 'civicrm_membership.join_date', 'headerPattern' => '/^join|(j(oin\\s)?date)$/i', 'dataPattern' => '/\\d{4}-?\\d{2}-?\\d{2}/', 'export' => true, 'html' => array('type' => 'Select Date')), 'membership_start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Membership Start Date'), 'description' => 'Beginning of current uninterrupted membership period.', 'import' => true, 'where' => 'civicrm_membership.start_date', 'headerPattern' => '/(member(ship)?.)?start(s)?(.date$)?/i', 'dataPattern' => '/\\d{4}-?\\d{2}-?\\d{2}/', 'export' => true, 'html' => array('type' => 'Select Date')), 'membership_end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Membership Expiration Date'), 'description' => 'Current membership period expire date.', 'import' => true, 'where' => 'civicrm_membership.end_date', 'headerPattern' => '/(member(ship)?.)?end(s)?(.date$)?/i', 'dataPattern' => '/\\d{4}-?\\d{2}-?\\d{2}/', 'export' => true, 'html' => array('type' => 'Select Date')), 'membership_source' => array('name' => 'source', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Source'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_membership.source', 'headerPattern' => '/^(member(ship?))?source$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Membership Status Id'), 'description' => 'FK to Membership Status', 'required' => true, 'import' => true, 'where' => 'civicrm_membership.status_id', 'headerPattern' => '/(member(ship|).)?(status)$/i', 'dataPattern' => '', 'export' => false, 'FKClassName' => 'CRM_Member_DAO_MembershipStatus', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_membership_status', 'keyColumn' => 'id', 'labelColumn' => 'label')), 'is_override' => array('name' => 'is_override', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Status Override'), 'description' => 'Admin users may set a manual status which overrides the calculated status. When this flag is true, automated status update scripts should NOT modify status for the record.', 'import' => true, 'where' => 'civicrm_membership.is_override', 'headerPattern' => '/override$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'CheckBox')), 'owner_membership_id' => array('name' => 'owner_membership_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Primary Member ID'), 'description' => 'Optional FK to Parent Membership.', 'export' => true, 'where' => 'civicrm_membership.owner_membership_id', 'headerPattern' => '', 'dataPattern' => '', 'FKClassName' => 'CRM_Member_DAO_Membership'), 'max_related' => array('name' => 'max_related', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Max Related'), 'description' => 'Maximum number of related memberships (membership_type override).', 'html' => array('type' => 'Text')), 'member_is_test' => array('name' => 'is_test', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Test'), 'import' => true, 'where' => 'civicrm_membership.is_test', 'headerPattern' => '/(is.)?test(.member(ship)?)?/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'CheckBox')), 'member_is_pay_later' => array('name' => 'is_pay_later', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Pay Later'), 'import' => true, 'where' => 'civicrm_membership.is_pay_later', 'headerPattern' => '/(is.)?(pay(.)?later)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'CheckBox')), 'contribution_recur_id' => array('name' => 'contribution_recur_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Memberhip Recurring Contribution'), 'description' => 'Conditional foreign key to civicrm_contribution_recur id. Each membership in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events.', 'FKClassName' => 'CRM_Contribute_DAO_ContributionRecur'), 'member_campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Campaign'), 'description' => 'The campaign for which this membership is attached.', 'import' => true, 'where' => 'civicrm_membership.campaign_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')));
}
return self::$_fields;
}
