/// <summary>
/// Updates the preferred currency and transaction source up.
/// </summary>
private void UpdatePreferredCurrencyAndTransactionSourceUp()
{
RockMigrationHelper.AddDefinedTypeAttribute("4F02B41E-AB7D-4345-8A97-3904DDD89B01", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Icon CSS Class", "IconCssClass", "", 1055, "fa-hand-holding-usd", "CB1E9401-E1FD-4DBB-B15F-4E6994602723");
RockMigrationHelper.AddAttributeQualifier("CB1E9401-E1FD-4DBB-B15F-4E6994602723", "ispassword", "False", "746974E9-0A05-4DD4-8277-922C442F76F0");
RockMigrationHelper.AddAttributeQualifier("CB1E9401-E1FD-4DBB-B15F-4E6994602723", "maxcharacters", "", "1ECBE523-F5EF-4362-A09A-FD9BC9436D7F");
RockMigrationHelper.AddAttributeQualifier("CB1E9401-E1FD-4DBB-B15F-4E6994602723", "showcountdown", "False", "84CE2ECD-B7DE-4F10-B69A-57285AC950E3");
RockMigrationHelper.AddDefinedValueAttributeValue("260EEA80-821A-4F79-973F-49DF79C955F7", "CB1E9401-E1FD-4DBB-B15F-4E6994602723", @"fa-cash-register");
RockMigrationHelper.AddDefinedValueAttributeValue("61E46A46-7399-4817-A6EC-3D8495E2316E", "CB1E9401-E1FD-4DBB-B15F-4E6994602723", @"fa-money-check");
RockMigrationHelper.AddDefinedValueAttributeValue("7D705CE7-7B11-4342-A58E-53617C5B4E69", "CB1E9401-E1FD-4DBB-B15F-4E6994602723", @"fa-desktop");
RockMigrationHelper.AddDefinedValueAttributeValue("8ADCEC72-63FC-4F08-A4CC-72BCE470172C", "CB1E9401-E1FD-4DBB-B15F-4E6994602723", @"fa-mobile-alt");
RockMigrationHelper.AddDefinedValueAttributeValue("8BA95E24-D291-499E-A535-4DCAC365689B", "CB1E9401-E1FD-4DBB-B15F-4E6994602723", @"fa-sms");
RockMigrationHelper.AddDefinedValueAttributeValue("BE7ECF50-52BC-4774-808D-574BA842DB98", "CB1E9401-E1FD-4DBB-B15F-4E6994602723", @"fa-church");
RockMigrationHelper.AddDefinedTypeAttribute("1D1304DE-E83A-44AF-B11D-0C66DD600B81", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Icon CSS Class", "IconCssClass", "", 1054, "fa-credit-card", "9617D1DC-6561-4314-83EB-7F0ACBA2E259");
RockMigrationHelper.AddAttributeQualifier("9617D1DC-6561-4314-83EB-7F0ACBA2E259", "ispassword", "False", "7A492FD1-60F2-4055-BE72-6A367E31022C");
RockMigrationHelper.AddAttributeQualifier("9617D1DC-6561-4314-83EB-7F0ACBA2E259", "maxcharacters", "", "AC52CCC9-FE9C-4481-A21C-B9CA0C1ADE29");
RockMigrationHelper.AddAttributeQualifier("9617D1DC-6561-4314-83EB-7F0ACBA2E259", "showcountdown", "False", "E3188133-82B5-4B21-9286-D850CCC3A77E");
RockMigrationHelper.AddDefinedValueAttributeValue("0FDF0BB3-B483-4C0A-9DFF-A35ABE3B688D", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-dollar-sign");
RockMigrationHelper.AddDefinedValueAttributeValue("56C9AE9C-B5EB-46D5-9650-2EF86B14F856", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-question");
RockMigrationHelper.AddDefinedValueAttributeValue("6151F6E0-3223-46BA-A59E-E091BE4AF75C", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-google-pay");
RockMigrationHelper.AddDefinedValueAttributeValue("7950FF66-80EE-E8AB-4A77-4A13EDEB7513", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-file-contract");
RockMigrationHelper.AddDefinedValueAttributeValue("8B086A19-405A-451F-8D44-174E92D6B402", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-money-check");
RockMigrationHelper.AddDefinedValueAttributeValue("928A2E04-C77B-4282-888F-EC549CEE026A", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-credit-card");
RockMigrationHelper.AddDefinedValueAttributeValue("D42C4DF7-1AE9-4DDE-ADA2-774B866B798C", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-apple-pay");
RockMigrationHelper.AddDefinedValueAttributeValue("DABEE8FD-AEDF-43E1-8547-4C97FA14D9B6", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-university");
RockMigrationHelper.AddDefinedValueAttributeValue("F3ADC889-1EE8-4EB6-B3FD-8C10F3C8AF93", "9617D1DC-6561-4314-83EB-7F0ACBA2E259", @"fa-money-bill");
}
private void AddGivingJourneyPersonAttributes()
{
var givingOverviewCategory = new List <string>()
{
SystemGuid.Category.PERSON_ATTRIBUTES_GIVING_OVERVIEW
};
// Rename "Giving Analytic" person category to "Giving Overview"
RockMigrationHelper.UpdatePersonAttributeCategory("Giving Overview", "fas fa-hand-holding-usd", "Attributes that describe the most recent classification of this person's giving habits", SystemGuid.Category.PERSON_ATTRIBUTES_GIVING_OVERVIEW);
RockMigrationHelper.AddOrUpdatePersonAttributeByGuid(
SystemGuid.FieldType.SINGLE_SELECT,
givingOverviewCategory,
"Current Journey Giving Stage",
"",
"CurrentJourneyGivingStage",
"",
"",
2010,
"",
SystemGuid.Attribute.PERSON_GIVING_CURRENT_GIVING_JOURNEY_STAGE);
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_CURRENT_GIVING_JOURNEY_STAGE, "fieldtype", "ddl", "69BF55DD-2331-4112-9594-95C38F5A713B");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_CURRENT_GIVING_JOURNEY_STAGE, "repeatColumns", "", "C30349DC-3AF9-4C6A-A815-67B1BE2C9D91");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_CURRENT_GIVING_JOURNEY_STAGE, "values", "0^Non-Giver, 1^New Giver, 2^Occasional Giver, 3^Consistent Giver, 4^Lapsed Giver, 5^Former Giver", "1A9213FC-B567-4793-AF57-89F4C443FF02");
RockMigrationHelper.AddOrUpdatePersonAttributeByGuid(
SystemGuid.FieldType.SINGLE_SELECT,
givingOverviewCategory,
"Previous Journey Giving Stage",
"",
"PreviousJourneyGivingStage",
"",
"",
2011,
"",
SystemGuid.Attribute.PERSON_GIVING_PREVIOUS_GIVING_JOURNEY_STAGE);
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_PREVIOUS_GIVING_JOURNEY_STAGE, "fieldtype", "ddl", "831BF3D6-3873-4C03-852F-0FC58AD883F6");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_PREVIOUS_GIVING_JOURNEY_STAGE, "repeatColumns", "", "0C9C5A69-E8F8-447F-9A40-CB9FB5D2C6E4");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_PREVIOUS_GIVING_JOURNEY_STAGE, "values", "0^Non-Giver, 1^New Giver, 2^Occasional Giver, 3^Consistent Giver, 4^Lapsed Giver, 5^Former Giver", "4B61627F-3B3A-4150-9F79-01CB023439FC");
RockMigrationHelper.AddOrUpdatePersonAttributeByGuid(
SystemGuid.FieldType.DATE,
givingOverviewCategory,
"Journey Giving Stage Change Date",
"",
"JourneyGivingStageChangeDate",
"",
"",
2012,
"",
SystemGuid.Attribute.PERSON_GIVING_GIVING_JOURNEY_STAGE_CHANGE_DATE);
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_GIVING_JOURNEY_STAGE_CHANGE_DATE, "datePickerControlType", "Date Picker", "7C3E6647-E3BD-4B31-9170-3E2C77B042CD");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_GIVING_JOURNEY_STAGE_CHANGE_DATE, "displayCurrentOption", "False", "CFD9E6C2-568B-41E8-98BD-E6C5E7FC3FAE");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_GIVING_JOURNEY_STAGE_CHANGE_DATE, "displayDiff", "False", "68F54381-86EB-4779-BF1C-4EE70A26284E");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_GIVING_JOURNEY_STAGE_CHANGE_DATE, "format", "", "0DDC2021-CC42-4994-8AC7-0A861773A231");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.PERSON_GIVING_GIVING_JOURNEY_STAGE_CHANGE_DATE, "futureYearCount", "", "5B0BDD4C-0261-49C7-A61B-4FB089BB1F48");
}
/// <summary>
/// SK: Block Template Picker Control, Field Type & Attribute
/// </summary>
private void SmsSettingsUp()
{
RockMigrationHelper.AddDefinedType("CMS Settings", "Template Block", "List of blocks which have built-in support for BlockTemplateFields. The block attribute uses the well-known Guid of a particular defined value like this: <code>[BlockTemplateField( \"ABC12345-1111-1111-1111-ABC123000000\", \"Format Templates\", \"This template controls the...\" )]</code>", "0F8E2B71-985E-44C4-BF5A-2FB1AAF3E183", @"");
RockMigrationHelper.AddDefinedType("CMS Settings", "Template", "List of Templates that can be used by the corresponding Template Blocks that Rock supports.", "A6E267E2-66A4-44D7-A5C9-9399666CBF95", @"");
RockMigrationHelper.AddDefinedTypeAttribute("A6E267E2-66A4-44D7-A5C9-9399666CBF95", "59D5A94C-94A0-4630-B80A-BB25697D74C7", "Template Block", "TemplateBlock", "", 1034, "", "0AAFF537-7EC6-4AA9-A987-68DA1FF8511D");
RockMigrationHelper.AddDefinedTypeAttribute("A6E267E2-66A4-44D7-A5C9-9399666CBF95", "97F8157D-A8C8-4AB3-96A2-9CB2A9049E6D", "Icon", "Icon", "", 1035, "", "831403EB-262E-4BC5-8B5E-F16153493BF5");
RockMigrationHelper.AddAttributeQualifier("0AAFF537-7EC6-4AA9-A987-68DA1FF8511D", "allowmultiple", "False", "92AA03B0-D134-4C81-B6F9-982E520CD3B0");
Sql(string.Format(@" DECLARE @AttributeId int = (SELECT TOP 1 [Id] FROM [Attribute] WHERE [Guid] = '{0}')
DECLARE @DefinedTypeId int = (SELECT TOP 1 [Id] FROM [DefinedType] WHERE [Guid] = '{1}')
IF NOT EXISTS (
SELECT *
FROM AttributeQualifier
WHERE [AttributeId] = @AttributeId
AND [Key] = 'definedtype'
)
BEGIN
INSERT INTO [AttributeQualifier] ([IsSystem], [AttributeId], [Key], [Value], [Guid])
VALUES
(0, @AttributeId, 'definedtype', @DefinedTypeId, 'B7D9102E-0CEB-4C5A-88FB-CA5C86D06859')
END ", "0AAFF537-7EC6-4AA9-A987-68DA1FF8511D", "0F8E2B71-985E-44C4-BF5A-2FB1AAF3E183"));
RockMigrationHelper.AddAttributeQualifier("0AAFF537-7EC6-4AA9-A987-68DA1FF8511D", "displaydescription", "False", "325925BF-0A0A-49DD-838E-06D40DDAD77A");
RockMigrationHelper.AddAttributeQualifier("0AAFF537-7EC6-4AA9-A987-68DA1FF8511D", "enhancedselection", "False", "E8C0D449-1CA1-40A1-BB1B-6856A0A3AF11");
RockMigrationHelper.AddAttributeQualifier("0AAFF537-7EC6-4AA9-A987-68DA1FF8511D", "includeInactive", "False", "2BFE679D-9085-4579-9DC4-9269A989E96B");
RockMigrationHelper.AddAttributeQualifier("831403EB-262E-4BC5-8B5E-F16153493BF5", "binaryFileType", "c1142570-8cd6-4a20-83b1-acb47c1cd377", "AE0CCDCC-018D-4F7A-8266-529085A3D97E");
RockMigrationHelper.AddAttributeQualifier("831403EB-262E-4BC5-8B5E-F16153493BF5", "formatAsLink", "False", "74CF1266-5CC0-4694-805B-76220D9293BC");
RockMigrationHelper.AddAttributeQualifier("831403EB-262E-4BC5-8B5E-F16153493BF5", "img_tag_template", "", "3EF02D92-C542-4C1E-AD09-B7D963CF5885");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddGroupType("Check in by Data View", "", "Group", "Member", false, false, false, "", 0, "", 0, "6BCED84C-69AD-4F5A-9197-5C0F9C02DD34", "DC7ED2FD-5F88-4760-B3C8-494EDB1CFC06", true);
RockMigrationHelper.AddGroupTypeGroupAttribute("DC7ED2FD-5F88-4760-B3C8-494EDB1CFC06", SystemGuid.FieldType.DATAVIEWS, "Data View", "The data view a person must be included in to be able to check into this group.", 0, "", "E8F8498F-5C51-4216-AC81-875349D6C2D0");
RockMigrationHelper.AddAttributeQualifier("E8F8498F-5C51-4216-AC81-875349D6C2D0", "entityTypeName", "Rock.Model.Person", "D59BAD04-4C23-497C-810A-328B760B7C6B");
RockMigrationHelper.UpdateEntityType("Rock.Workflow.Action.CheckIn.FilterGroupsByDataView", "E6490F9B-21C6-4D0F-AD15-9729AC22C094", false, true);
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("E6490F9B-21C6-4D0F-AD15-9729AC22C094", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "0B1FF2A0-D0CE-42A5-95BC-C65F02D14399");
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("E6490F9B-21C6-4D0F-AD15-9729AC22C094", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "869473D0-AC93-4F8F-B164-2A332571E779");
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("E6490F9B-21C6-4D0F-AD15-9729AC22C094", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Remove", "Remove", "Select 'Yes' if groups should be removed. Select 'No' if they should just be marked as excluded.", 0, @"True", "5EE8CC8E-455D-4115-88F4-81D224A30A28");
RockMigrationHelper.UpdateWorkflowActionType("EB744DF1-E454-482C-B111-80A54EF8A674", "Filter Groups by DataView", 0, "E6490F9B-21C6-4D0F-AD15-9729AC22C094", true, false, "", "66EF6CB1-1A96-2F81-4534-3BCA5C33D4CD", 1, "False", "31F407AA-50BB-4915-BB22-7AF463989D98");
Sql(@"
-- Fix the ordering of the Unattended Check-in Id: 10 workflow activity so that the 'Filter By Data View' activity is immediately after 'Filter By Gender'
DECLARE @ActivityTypeId int = ( SELECT TOP 1 [Id] FROM [WorkflowActivityType] WHERE [Guid] = 'EB744DF1-E454-482C-B111-80A54EF8A674' )
DECLARE @EntityTypeId int = ( SELECT TOP 1 [Id] FROM [EntityType] WHERE [Name] = 'Rock.Workflow.Action.CheckIn.FilterGroupsByGender' )
DECLARE @Order int = ISNULL( ( SELECT TOP 1 [Order] FROM [WorkflowActionType] WHERE [ActivityTypeId] = @ActivityTypeId AND [EntityTypeId] = @EntityTypeId ), 0)
IF @Order IS NOT NULL AND @Order > 0
BEGIN
UPDATE [WorkflowActionType] SET [Order] = [Order] + 1 WHERE [ActivityTypeId] = @ActivityTypeId AND [Order] > @Order
UPDATE [WorkflowActionType] SET [Order] = @Order + 1 WHERE [Guid] = '31F407AA-50BB-4915-BB22-7AF463989D98'
END
");
}
public override void Up()
{
//Childrens checkin base
RockMigrationHelper.AddGroupType("Children Check-In", "Base checkin group for all of check-in.", "Group", "Member", false, false, false,
"", 100, Constants.GROUP_TYPE_BY_BASE, 0, Rock.SystemGuid.DefinedValue.GROUPTYPE_PURPOSE_CHECKIN_FILTER, Constants.GROUP_TYPE_BY_CHILDREN_CHECKIN_BASE);
RockMigrationHelper.AddGroupTypeGroupAttribute("5398A1C2-F422-4ADC-A48B-B9EFFE3598AD", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Link Locations", @"Should all all locations for this group be required to be the same?", 0, "False", "0A8723A4-4AEE-4D21-A32B-350845FC8FA9", "");
RockMigrationHelper.AddGroupTypeGroupAttribute("5398A1C2-F422-4ADC-A48B-B9EFFE3598AD", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Is Volunteer", @"Do people checking into this group count as volunteers?", 1, "", "F5DAD320-B77D-4282-98C9-35414FB0A6DC", "");
RockMigrationHelper.AddGroupTypeGroupAttribute("5398A1C2-F422-4ADC-A48B-B9EFFE3598AD", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Give Priority", @"", 2, "False", "DABEABAC-F052-471B-AC61-A7630465888B", "");
//Checkin by Birthday
RockMigrationHelper.AddGroupType("Check in by Birthday", "Checkin filter using birthdays.", "Group", "Member", false, false, false,
"", 101, Constants.GROUP_TYPE_BY_CHILDREN_CHECKIN_BASE, 0, Rock.SystemGuid.DefinedValue.GROUPTYPE_PURPOSE_CHECKIN_FILTER, Constants.GROUP_TYPE_BY_BIRTHDAY);
RockMigrationHelper.AddGroupTypeGroupAttribute("3600C17B-1D92-4929-B7B7-BBC156F2D47A", "9C7D431C-875C-4792-9E76-93F3A32BB850", "Date Range", @"", 0, "", "DABCC6EA-29EE-41EA-83DC-C2DF0065631D", "");
RockMigrationHelper.AddGroupTypeGroupAttribute("3600C17B-1D92-4929-B7B7-BBC156F2D47A", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Filter GradeSchool Students", @"", 1, "", "8919515B-D654-43AA-A429-91A2B8A092CF", "");
//Checkin by Membership
RockMigrationHelper.AddGroupType("Check in by Membership", "Checkin filter using group membership.", "Group", "Member", false, false, false,
"", 102, Constants.GROUP_TYPE_BY_CHILDREN_CHECKIN_BASE, 0, Rock.SystemGuid.DefinedValue.GROUPTYPE_PURPOSE_CHECKIN_FILTER, Constants.GROUP_TYPE_BY_MEMBERSHIP);
RockMigrationHelper.AddGroupTypeGroupAttribute("2098AE58-58D4-4CEF-8D40-C2657D2E7A6A", "F4399CEF-827B-48B2-A735-F7806FCFE8E8", "Group", @"", 0, null, "22C7D86E-ABEA-4DFB-A83C-FC18100C9834", "");
RockMigrationHelper.AddGroupTypeGroupAttribute(Constants.GROUP_TYPE_BY_MEMBERSHIP, Rock.SystemGuid.FieldType.SINGLE_SELECT, "Check Requirements",
"Should the requirements of the group be checked before allowing check-in. This is slower but needed in some situations.",
5, "0", Constants.GROUP_ATTRIBUTE_CHECK_REQUIREMENTS, false);
RockMigrationHelper.AddAttributeQualifier(Constants.GROUP_ATTRIBUTE_CHECK_REQUIREMENTS, "values", "0^Do Not Check,1^Check Required Only,2^Check Required and Warning", "9E659023-6860-4872-B7C9-EB019FF76145");
RockMigrationHelper.AddGroupTypeGroupAttribute(Constants.GROUP_TYPE_BY_MEMBERSHIP, Rock.SystemGuid.FieldType.SINGLE_SELECT, "Member Role",
"Optional filter to only allow people if they are a member or leader.",
6, "0", Constants.GROUP_ATTRIBUTE_MEMBER_ROLE, false);
RockMigrationHelper.AddAttributeQualifier(Constants.GROUP_ATTRIBUTE_MEMBER_ROLE, "values", "0^Any,1^Leaders Only,2^Non Leaders Only", "840B04D7-DC1B-452B-A869-0AEB4904DC26");
RockMigrationHelper.AddGroupTypeGroupAttribute(Constants.GROUP_TYPE_BY_MEMBERSHIP, Rock.SystemGuid.FieldType.BOOLEAN, "Save Attendance To Group",
"If selected, the attendance will be set on the group the person is a member of instead of on the check-in group.",
7, "False", Constants.GROUP_ATTRIBUTE_ATTENDANCE_ON_GROUP);
}
public override void Up()
{
var contentChannelTypeId = ( int )SqlScalar("SELECT [Id] FROM [ContentChannelType] WHERE [Guid] = @Guid",
new Dictionary <string, object> {
{ "@Guid", SystemGuid.ContentChannelType.DIGITAL_SIGNAGE }
});
//
// Add the attributes to the content channel.
//
RockMigrationHelper.AddEntityAttribute("Rock.Model.ContentChannelItem", Rock.SystemGuid.FieldType.SINGLE_SELECT,
"ContentChannelTypeId", contentChannelTypeId.ToString(), "Include Content From", string.Empty,
"Includes the content from the specified content channel, takes precedence over Slide and Slide Url fields.",
2, string.Empty,
SystemGuid.Attribute.CONTENT_CHANNEL_ITEM_INCLUDE_CONTENT_FROM, "com_shepherdchurch_IncludeContentFrom");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.Attribute.CONTENT_CHANNEL_ITEM_INCLUDE_CONTENT_FROM,
"values",
string.Format("SELECT [Guid] AS [Value], [Name] AS [Text] FROM [ContentChannel] WHERE [ContentChannelTypeId] = {0}", contentChannelTypeId),
SystemGuid.AttributeQualifier.CONTENT_CHANNEL_ITEM_INCLUDE_CONTENT_FROM_VALUES);
RockMigrationHelper.AddEntityAttribute("Rock.Model.ContentChannelItem", Rock.SystemGuid.FieldType.CAMPUSES,
"ContentChannelTypeId", contentChannelTypeId.ToString(), "Campus Filter", string.Empty,
"Which campuses this slide will be displayed at. If nothing is selected then all campuses are active.",
3, string.Empty,
SystemGuid.Attribute.CONTENT_CHANNEL_ITEM_CAMPUS_FILTER, "com_shepherdchurch_CampusFilter");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddAttributeQualifier(Rock.SystemGuid.Attribute.GLOBAL_PUBLIC_APPLICATION_ROOT,
"ShouldAlwaysShowCondensed",
"True",
"0FF3DF1A-55FB-4328-B8EA-AFF16084E3E3");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddAttributeQualifier(Rock.SystemGuid.Attribute.GLOBAL_PUBLIC_APPLICATION_ROOT,
"ShouldRequireTrailingForwardSlash",
"True",
"068E9B90-0A42-43BF-A17B-052E78A99ABB");
RockMigrationHelper.UpdateGlobalAttribute("PublicApplicationRoot",
"",
"",
Rock.SystemGuid.Attribute.GLOBAL_PUBLIC_APPLICATION_ROOT,
Rock.SystemGuid.FieldType.URL_LINK,
"Public Application Root",
"The application root URL of the public Rock website",
0);
Sql(@"UPDATE AttributeValue
SET [Value] = CASE WHEN RIGHT([Value], 1) = '/' THEN [Value]
WHEN CHARINDEX('?', [Value], 0) > 0 THEN SUBSTRING([Value], 0, CHARINDEX('?', [Value], 0)) + '/'
ELSE [Value] + '/' END
FROM Attribute a
INNER JOIN AttributeValue av ON av.AttributeId = a.Id
WHERE a.[Key] = 'PublicApplicationRoot'
AND a.EntityTypeId IS NULL
AND a.EntityTypeQualifierColumn = ''
AND a.EntityTypeQualifierValue = ''
AND av.[EntityId] IS NULL" );
UpdateAttributeValues();
UpdateRegistrationTemplates();
UpdateDefinedValues();
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
var zrDefinedTypeId = new DefinedTypeService(new Rock.Data.RockContext()).Get(ZoomGuid.DefinedType.ZOOM_ROOM.AsGuid()).Id;
RockMigrationHelper.AddAttributeQualifier(ZoomGuid.Attribute.ZOOM_ROOM_LOCATION_ENTITY_ATTRIBUTE, "definedtype", zrDefinedTypeId.ToString(), "D210E7BF-7C3D-4B8E-A8AB-423C97DA6FACf");
RockMigrationHelper.AddAttributeQualifier(ZoomGuid.Attribute.ZOOM_ROOM_LOCATION_ENTITY_ATTRIBUTE, "displaydescription", "True", "85D4A488-3F71-49EF-9EBC-28927D4C15A4");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
AddColumn("dbo.ContentChannelType", "IncludeTime", c => c.Boolean(nullable: false));
Sql("UPDATE [ContentChannelType] SET [IncludeTime] = 1");
// MP: Bank Checks DefinedValue
RockMigrationHelper.AddDefinedTypeAttribute("4F02B41E-AB7D-4345-8A97-3904DDD89B01", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Show in Check Scanner", "core.ShowInCheckScanner", "", 37, "False", "B4D4CCD3-94CD-4584-94FD-C677213A1A51");
RockMigrationHelper.AddAttributeQualifier("B4D4CCD3-94CD-4584-94FD-C677213A1A51", "falsetext", "No", "2CDE5641-4FF8-422B-8607-EFA28550B06A");
RockMigrationHelper.AddAttributeQualifier("B4D4CCD3-94CD-4584-94FD-C677213A1A51", "truetext", "Yes", "581EE78A-C122-413F-91C2-D30B2D9DA937");
RockMigrationHelper.AddDefinedValue("4F02B41E-AB7D-4345-8A97-3904DDD89B01", "Bank Checks", "Transactions that originated from a bank's bill pay system", "61E46A46-7399-4817-A6EC-3D8495E2316E", false);
RockMigrationHelper.AddDefinedValueAttributeValue("61E46A46-7399-4817-A6EC-3D8495E2316E", "B4D4CCD3-94CD-4584-94FD-C677213A1A51", @"True");
RockMigrationHelper.AddDefinedValueAttributeValue("BE7ECF50-52BC-4774-808D-574BA842DB98", "B4D4CCD3-94CD-4584-94FD-C677213A1A51", @"True");
// MP: GroupMember PageRoute
RockMigrationHelper.AddPageRoute(Rock.SystemGuid.Page.GROUP_MEMBER_DETAIL_GROUP_VIEWER, "GroupMember/{GroupMemberId}");
// DT: New Transaction List Settings
// Attrib for BlockType: Transaction List:Show Only Active Accounts on Filter
RockMigrationHelper.AddBlockTypeAttribute("E04320BC-67C3-452D-9EF6-D74D8C177154", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Show Only Active Accounts on Filter", "ActiveAccountsOnlyFilter", "", "If account filter is displayed, only list active accounts", 2, @"False", "81AD58EA-F94B-42A1-AC57-16902B717092");
// Attrib for BlockType: Transaction List:Transaction Types
RockMigrationHelper.AddBlockTypeAttribute("E04320BC-67C3-452D-9EF6-D74D8C177154", "59D5A94C-94A0-4630-B80A-BB25697D74C7", "Transaction Types", "TransactionTypes", "", "Optional list of transation types to limit the list to (if none are selected all types will be included).", 3, @"", "293F8A3E-020A-4260-8817-3E368CF31ABB");
// Attrib Value for Block:Transaction List, Attribute:Transaction Types Page: Contributions, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("9382B285-3EF6-47F7-94BB-A47C498196A3", "293F8A3E-020A-4260-8817-3E368CF31ABB", @"2d607262-52d6-4724-910d-5c6e8fb89acc");
// MP: Event Calendar Security Updates
// add entity APPROVE security for Event Calendar
RockMigrationHelper.AddSecurityAuthForEntityType("Rock.Model.EventCalendar", 0, Rock.Security.Authorization.APPROVE, true, Rock.SystemGuid.Group.GROUP_CALENDAR_ADMINISTRATORS, 0, "25EB8621-70C5-4467-B161-72A067880560");
RockMigrationHelper.AddSecurityAuthForEntityType("Rock.Model.EventCalendar", 1, Rock.Security.Authorization.APPROVE, true, Rock.SystemGuid.Group.GROUP_COMMUNICATION_ADMINISTRATORS, 0, "A7B792E5-1367-4966-9795-7566A1E936C3");
RockMigrationHelper.AddSecurityAuthForEntityType("Rock.Model.EventCalendar", 2, Rock.Security.Authorization.APPROVE, false, null, Rock.Model.SpecialRole.AllUsers.ConvertToInt(), "4F8D78AD-4161-4124-874C-C23F8500474F");
// add page ADMINISTRATE security for Calendars
RockMigrationHelper.AddSecurityAuthForPage(Rock.SystemGuid.Page.CALENDARS, 1, Rock.Security.Authorization.ADMINISTRATE, true, Rock.SystemGuid.Group.GROUP_COMMUNICATION_ADMINISTRATORS, Rock.Model.SpecialRole.None.ConvertToInt(), "C76D94F5-96C8-4371-80F5-99C50089D430");
RockMigrationHelper.AddSecurityAuthForPage(Rock.SystemGuid.Page.CALENDARS, 0, Rock.Security.Authorization.ADMINISTRATE, true, Rock.SystemGuid.Group.GROUP_CALENDAR_ADMINISTRATORS, Rock.Model.SpecialRole.None.ConvertToInt(), "2DEE6ECD-461D-487F-9932-9DDDE08A641D");
// add page EDIT security for Calendars
RockMigrationHelper.AddSecurityAuthForPage(Rock.SystemGuid.Page.CALENDARS, 1, Rock.Security.Authorization.EDIT, true, Rock.SystemGuid.Group.GROUP_STAFF_MEMBERS, Rock.Model.SpecialRole.None.ConvertToInt(), "A796B28F-E0A6-4E66-9981-CDB0F8A24565");
RockMigrationHelper.AddSecurityAuthForPage(Rock.SystemGuid.Page.CALENDARS, 2, Rock.Security.Authorization.EDIT, true, Rock.SystemGuid.Group.GROUP_STAFF_LIKE_MEMBERS, Rock.Model.SpecialRole.None.ConvertToInt(), "32E66F8B-A145-488B-A8CD-D76B334C3FC2");
// MK: New block attribute/vales
// Attrib for BlockType: Data View Detail: Data View Page
RockMigrationHelper.AddBlockTypeAttribute("EB279DF9-D817-4905-B6AC-D9883F0DA2E4", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Data View Detail Page", "DataViewDetailPage", "", "Page used to view a data view.", 0, @"", "11C7EF84-14D5-4CAF-940B-B0A2AAD9DFE9");
// Attrib for BlockType: Report Detail: Report Page
RockMigrationHelper.AddBlockTypeAttribute("EB279DF9-D817-4905-B6AC-D9883F0DA2E4", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Report Detail Page", "ReportDetailPage", "", "Page used to view a report.", 1, @"", "2BBE2EF5-9FD7-411D-8C36-8F0DAF5A73C8");
// Attrib value for Block: Data View Detail, Attribute: Data View Detail Page, Page: Data Views, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("7868AF5C-6512-4F33-B127-93B159E08A56", "11C7EF84-14D5-4CAF-940B-B0A2AAD9DFE9", "4011CB37-28AA-46C4-99D5-826F4A9CADF5");
// Attrib value for Block: Data View Detail, Attribute: Report Detail Page, Page: Data Views, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("7868AF5C-6512-4F33-B127-93B159E08A56", "2BBE2EF5-9FD7-411D-8C36-8F0DAF5A73C8", "0FDF1F63-CFB3-4F8E-AC5D-A5312B522D6D");
// JE: Add RSR - Family Manager security group
Sql(@"
IF NOT EXISTS(SELECT * FROM [Group] WHERE [Guid] = 'D832E933-1972-4482-B24D-6AF0AC6BDF20' )
BEGIN
DECLARE @SecurityGroupTypeId int = (SELECT TOP 1 [Id] FROM [GroupType] WHERE [Guid] = 'AECE949F-704C-483E-A4FB-93D5E4720C4C')
INSERT INTO [Group] ([IsSystem], [GroupTypeId], [Name], [Description], [IsSecurityRole], [IsActive], [Order], [Guid], [IsPublic])
VALUES (1, @SecurityGroupTypeId, 'RSR - Family Manager', 'Used to grant access for use of the Family Registration application.', 1, 1, 100, 'D832E933-1972-4482-B24D-6AF0AC6BDF20', 0)
END
");
// JE: Disable Name Search on Connection Search
RockMigrationHelper.AddBlockAttributeValue("2B60FE4A-5AD8-4F0A-9205-0744485C3DDD", "4361D6EE-B95F-4DE7-88C5-F53A5494A1F6", @"False");
}
public override void Up()
{
RockMigrationHelper.AddOrUpdatePersonAttributeByGuid(Rock.SystemGuid.FieldType.SINGLE_SELECT, new List <string>(), "Steps to Care Notification", "Steps to Care Notification", "rocks_kfs_StepsToCare_Notification", "", "Choose how you would like to receive Steps to Care notifications. Default: Email", 0, "Email", SystemGuid.PersonAttribute.NOTIFICATION);
RockMigrationHelper.AddAttributeQualifier(SystemGuid.PersonAttribute.NOTIFICATION, "values", "None^None,Email^Email,SMS^SMS,Both^Email & SMS", "A8E56BDB-8523-4BEA-9707-5C1463750BBB");
RockMigrationHelper.AddAttributeQualifier(SystemGuid.PersonAttribute.NOTIFICATION, "fieldtype", "rb", "C56B40EA-1594-448C-9742-50B3477EC04A");
Sql(string.Format("UPDATE [Attribute] SET IsSystem = 1 WHERE [Guid] = '{0}'", SystemGuid.PersonAttribute.NOTIFICATION));
}
/// <summary>
/// The commands to run to migrate plugin to the specific version
/// </summary>
public override void Up()
{
RockMigrationHelper.UpdateEntityType("Rock.Model.Workflow", "3540E9A7-FE30-43A9-8B0A-A372B63DFC93", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActivity", "2CB52ED0-CB06-4D62-9E2C-73B60AFA4C9F", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActionType", "23E3273A-B137-48A3-9AFF-C8DC832DDCA6", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Workflow.Action.SendSms", "F22FA171-B5E7-497F-9AE6-F7B98A377D0E", false, true);
RockMigrationHelper.UpdateEntityType("Rock.Workflow.Action.SetAttributeFromEntity", "972F19B9-598B-474B-97A4-50E56E7B59D2", false, true);
RockMigrationHelper.UpdateEntityType("Rock.Workflow.Action.SetAttributeToCurrentPerson", "24B7D5E6-C30F-48F4-9D7E-AF45A342CF3A", false, true);
RockMigrationHelper.UpdateEntityType("Rock.Workflow.Action.UserEntryForm", "486DC4FA-FCBC-425F-90B0-E606DA8A9F68", false, true);
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("24B7D5E6-C30F-48F4-9D7E-AF45A342CF3A", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "DE9CB292-4785-4EA3-976D-3826F91E9E98"); // Rock.Workflow.Action.SetAttributeToCurrentPerson:Active
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("24B7D5E6-C30F-48F4-9D7E-AF45A342CF3A", "33E6DF69-BDFA-407A-9744-C175B60643AE", "Person Attribute", "PersonAttribute", "The attribute to set to the currently logged in person.", 0, @"", "BBED8A83-8BB2-4D35-BAFB-05F67DCAD112"); // Rock.Workflow.Action.SetAttributeToCurrentPerson:Person Attribute
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("24B7D5E6-C30F-48F4-9D7E-AF45A342CF3A", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "89E9BCED-91AB-47B0-AD52-D78B0B7CB9E8"); // Rock.Workflow.Action.SetAttributeToCurrentPerson:Order
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("486DC4FA-FCBC-425F-90B0-E606DA8A9F68", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "234910F2-A0DB-4D7D-BAF7-83C880EF30AE"); // Rock.Workflow.Action.UserEntryForm:Active
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("486DC4FA-FCBC-425F-90B0-E606DA8A9F68", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "C178113D-7C86-4229-8424-C6D0CF4A7E23"); // Rock.Workflow.Action.UserEntryForm:Order
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("972F19B9-598B-474B-97A4-50E56E7B59D2", "1D0D3794-C210-48A8-8C68-3FBEC08A6BA5", "Lava Template", "LavaTemplate", "By default this action will set the attribute value equal to the guid (or id) of the entity that was passed in for processing. If you include a lava template here, the action will instead set the attribute value to the output of this template. The mergefield to use for the entity is 'Entity.' For example, use {{ Entity.Name }} if the entity has a Name property. <span class='tip tip-lava'></span>", 4, @"", "44836A7C-5007-4213-9AE7-E787225659C3"); // Rock.Workflow.Action.SetAttributeFromEntity:Lava Template
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("972F19B9-598B-474B-97A4-50E56E7B59D2", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "9392E3D7-A28B-4CD8-8B03-5E147B102EF1"); // Rock.Workflow.Action.SetAttributeFromEntity:Active
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("972F19B9-598B-474B-97A4-50E56E7B59D2", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Entity Is Required", "EntityIsRequired", "Should an error be returned if the entity is missing or not a valid entity type?", 2, @"True", "05B2AC7A-6C94-41C0-BF92-EE3DEF7895B1"); // Rock.Workflow.Action.SetAttributeFromEntity:Entity Is Required
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("972F19B9-598B-474B-97A4-50E56E7B59D2", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Use Id instead of Guid", "UseId", "Most entity attribute field types expect the Guid of the entity (which is used by default). Select this option if the entity's Id should be used instead (should be rare).", 3, @"False", "1246C53A-FD92-4E08-ABDE-9A6C37E70C7B"); // Rock.Workflow.Action.SetAttributeFromEntity:Use Id instead of Guid
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("972F19B9-598B-474B-97A4-50E56E7B59D2", "33E6DF69-BDFA-407A-9744-C175B60643AE", "Attribute", "Attribute", "The attribute to set the value of.", 1, @"", "61E6E1BC-E657-4F00-B2E9-769AAA25B9F7"); // Rock.Workflow.Action.SetAttributeFromEntity:Attribute
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("972F19B9-598B-474B-97A4-50E56E7B59D2", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "AD4EFAC4-E687-43DF-832F-0DC3856ABABB"); // Rock.Workflow.Action.SetAttributeFromEntity:Order
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("F22FA171-B5E7-497F-9AE6-F7B98A377D0E", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "9A4A3446-56D0-44AE-BFC7-22006547F22E"); // Rock.Workflow.Action.SendSms:Active
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("F22FA171-B5E7-497F-9AE6-F7B98A377D0E", "3B1D93D7-9414-48F9-80E5-6A3FC8F94C20", "Message|Attribute Value", "Message", "The message or an attribute that contains the message that should be sent. <span class='tip tip-lava'></span>", 2, @"", "42E9674B-7413-41C4-A3F7-5E8265E83EAE"); // Rock.Workflow.Action.SendSms:Message|Attribute Value
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("F22FA171-B5E7-497F-9AE6-F7B98A377D0E", "3B1D93D7-9414-48F9-80E5-6A3FC8F94C20", "Recipient|Attribute Value", "To", "The phone number or an attribute that contains the person or phone number that message should be sent to. <span class='tip tip-lava'></span>", 1, @"", "2A4DB4D3-8FDD-4E25-B28E-0FB0FE8ABFA9"); // Rock.Workflow.Action.SendSms:Recipient|Attribute Value
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("F22FA171-B5E7-497F-9AE6-F7B98A377D0E", "59D5A94C-94A0-4630-B80A-BB25697D74C7", "From", "From", "The phone number to send message from", 0, @"", "85946B94-55DB-4219-A04E-EAB1D8C9022E"); // Rock.Workflow.Action.SendSms:From
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("F22FA171-B5E7-497F-9AE6-F7B98A377D0E", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "05A85E0D-4860-4BFB-ACA9-C7B668B89500"); // Rock.Workflow.Action.SendSms:Order
RockMigrationHelper.UpdateCategory("C9F3C4A5-1526-474D-803F-D6C7A45CBBAE", "Messaging", "fa fa-mobile", "", "D1AF4B37-FFFB-4A05-9A7B-7BCB7A866D0D", 0); // Messaging
RockMigrationHelper.UpdateWorkflowType(false, true, "Send A Text Message", "Sends a text message to a user from their profile page.", "D1AF4B37-FFFB-4A05-9A7B-7BCB7A866D0D", "Work", "fa fa-mobile", 0, true, 0, "F3218F81-423F-46EA-B748-ED7AB365CD07"); // Send A Text Message
RockMigrationHelper.UpdateWorkflowTypeAttribute("F3218F81-423F-46EA-B748-ED7AB365CD07", "C28C7BF3-A552-4D77-9408-DEDCF760CED0", "Message", "Message", "The message to send", 2, @"", "D4438B4B-8D7C-49F1-B025-F37BEC10E3D3"); // Send A Text Message:Message
RockMigrationHelper.UpdateWorkflowTypeAttribute("F3218F81-423F-46EA-B748-ED7AB365CD07", "E4EAB7B2-0B76-429B-AFE4-AD86D7428C70", "Recipient", "recipient", "Sets the recipient of the message", 0, @"", "494280DA-D7BF-4523-9774-20B477062113"); // Send A Text Message:Recipient
RockMigrationHelper.UpdateWorkflowTypeAttribute("F3218F81-423F-46EA-B748-ED7AB365CD07", "E4EAB7B2-0B76-429B-AFE4-AD86D7428C70", "Sender", "Sender", "Sets the sender", 1, @"", "3E27AC12-BE52-4CBA-AABE-F97D58523121"); // Send A Text Message:Sender
RockMigrationHelper.AddAttributeQualifier("D4438B4B-8D7C-49F1-B025-F37BEC10E3D3", "allowhtml", @"False", "5DA52708-4152-416D-812D-969BFB1B6FE0"); // Send A Text Message:Message:allowhtml
RockMigrationHelper.AddAttributeQualifier("D4438B4B-8D7C-49F1-B025-F37BEC10E3D3", "numberofrows", @"", "643FF567-279A-469C-94C2-ABE76BAFDA74"); // Send A Text Message:Message:numberofrows
RockMigrationHelper.UpdateWorkflowActivityType("F3218F81-423F-46EA-B748-ED7AB365CD07", true, "Send The Text", "", false, 0, "9D5C50E2-9D67-4362-B398-7E9E2B488283"); // Send A Text Message:Send The Text
RockMigrationHelper.UpdateWorkflowActionForm(@"Enter your message:", @"", "Send^fdc397cd-8b4a-436e-bea1-bce2e6717c03^^Your text has been sent!|", "88C7D1CC-3478-4562-A301-AE7D4D7FFF6D", true, "", "C961B02A-CD18-40F5-B323-DBBA067B4D8A"); // Send A Text Message:Send The Text:Enter The Message
RockMigrationHelper.UpdateWorkflowActionFormAttribute("C961B02A-CD18-40F5-B323-DBBA067B4D8A", "494280DA-D7BF-4523-9774-20B477062113", 0, false, true, false, "78723B66-8B8D-4398-8859-8DA30153E54B"); // Send A Text Message:Send The Text:Enter The Message:Recipient
RockMigrationHelper.UpdateWorkflowActionFormAttribute("C961B02A-CD18-40F5-B323-DBBA067B4D8A", "3E27AC12-BE52-4CBA-AABE-F97D58523121", 1, false, true, false, "5742591D-5D4A-40AC-91A8-A868DBACE1C9"); // Send A Text Message:Send The Text:Enter The Message:Sender
RockMigrationHelper.UpdateWorkflowActionFormAttribute("C961B02A-CD18-40F5-B323-DBBA067B4D8A", "D4438B4B-8D7C-49F1-B025-F37BEC10E3D3", 2, true, false, true, "B72D158D-AA06-4770-BB6C-832A519FC388"); // Send A Text Message:Send The Text:Enter The Message:Message
RockMigrationHelper.UpdateWorkflowActionType("9D5C50E2-9D67-4362-B398-7E9E2B488283", "Sender", 1, "24B7D5E6-C30F-48F4-9D7E-AF45A342CF3A", true, false, "", "", 1, "", "9ACD91CE-9946-4DB4-8985-8BAB84679862"); // Send A Text Message:Send The Text:Sender
RockMigrationHelper.UpdateWorkflowActionType("9D5C50E2-9D67-4362-B398-7E9E2B488283", "Sets The Recipient", 0, "972F19B9-598B-474B-97A4-50E56E7B59D2", true, false, "", "", 1, "", "B433A848-90B1-467D-8B16-2080A8331965"); // Send A Text Message:Send The Text:Sets The Recipient
RockMigrationHelper.UpdateWorkflowActionType("9D5C50E2-9D67-4362-B398-7E9E2B488283", "Enter The Message", 2, "486DC4FA-FCBC-425F-90B0-E606DA8A9F68", true, false, "C961B02A-CD18-40F5-B323-DBBA067B4D8A", "", 1, "", "3CB6173C-9F2F-4E7F-A998-9B4832C539B0"); // Send A Text Message:Send The Text:Enter The Message
RockMigrationHelper.UpdateWorkflowActionType("9D5C50E2-9D67-4362-B398-7E9E2B488283", "Send Message", 3, "F22FA171-B5E7-497F-9AE6-F7B98A377D0E", true, false, "", "", 1, "", "7EAE659C-5A08-4BFF-869C-A12FA5ED021E"); // Send A Text Message:Send The Text:Send Message
RockMigrationHelper.AddActionTypeAttributeValue("B433A848-90B1-467D-8B16-2080A8331965", "9392E3D7-A28B-4CD8-8B03-5E147B102EF1", @"False"); // Send A Text Message:Send The Text:Sets The Recipient:Active
RockMigrationHelper.AddActionTypeAttributeValue("B433A848-90B1-467D-8B16-2080A8331965", "AD4EFAC4-E687-43DF-832F-0DC3856ABABB", @""); // Send A Text Message:Send The Text:Sets The Recipient:Order
RockMigrationHelper.AddActionTypeAttributeValue("B433A848-90B1-467D-8B16-2080A8331965", "61E6E1BC-E657-4F00-B2E9-769AAA25B9F7", @"494280da-d7bf-4523-9774-20b477062113"); // Send A Text Message:Send The Text:Sets The Recipient:Attribute
RockMigrationHelper.AddActionTypeAttributeValue("B433A848-90B1-467D-8B16-2080A8331965", "05B2AC7A-6C94-41C0-BF92-EE3DEF7895B1", @"True"); // Send A Text Message:Send The Text:Sets The Recipient:Entity Is Required
RockMigrationHelper.AddActionTypeAttributeValue("B433A848-90B1-467D-8B16-2080A8331965", "1246C53A-FD92-4E08-ABDE-9A6C37E70C7B", @"False"); // Send A Text Message:Send The Text:Sets The Recipient:Use Id instead of Guid
RockMigrationHelper.AddActionTypeAttributeValue("B433A848-90B1-467D-8B16-2080A8331965", "44836A7C-5007-4213-9AE7-E787225659C3", @""); // Send A Text Message:Send The Text:Sets The Recipient:Lava Template
RockMigrationHelper.AddActionTypeAttributeValue("9ACD91CE-9946-4DB4-8985-8BAB84679862", "DE9CB292-4785-4EA3-976D-3826F91E9E98", @"False"); // Send A Text Message:Send The Text:Sender:Active
RockMigrationHelper.AddActionTypeAttributeValue("9ACD91CE-9946-4DB4-8985-8BAB84679862", "BBED8A83-8BB2-4D35-BAFB-05F67DCAD112", @"3e27ac12-be52-4cba-aabe-f97d58523121"); // Send A Text Message:Send The Text:Sender:Person Attribute
RockMigrationHelper.AddActionTypeAttributeValue("9ACD91CE-9946-4DB4-8985-8BAB84679862", "89E9BCED-91AB-47B0-AD52-D78B0B7CB9E8", @""); // Send A Text Message:Send The Text:Sender:Order
RockMigrationHelper.AddActionTypeAttributeValue("3CB6173C-9F2F-4E7F-A998-9B4832C539B0", "234910F2-A0DB-4D7D-BAF7-83C880EF30AE", @"False"); // Send A Text Message:Send The Text:Enter The Message:Active
RockMigrationHelper.AddActionTypeAttributeValue("3CB6173C-9F2F-4E7F-A998-9B4832C539B0", "C178113D-7C86-4229-8424-C6D0CF4A7E23", @""); // Send A Text Message:Send The Text:Enter The Message:Order
RockMigrationHelper.AddActionTypeAttributeValue("7EAE659C-5A08-4BFF-869C-A12FA5ED021E", "85946B94-55DB-4219-A04E-EAB1D8C9022E", @"d4a21848-fd21-4af8-952c-a095fdc177cb"); // Send A Text Message:Send The Text:Send Message:From
RockMigrationHelper.AddActionTypeAttributeValue("7EAE659C-5A08-4BFF-869C-A12FA5ED021E", "05A85E0D-4860-4BFB-ACA9-C7B668B89500", @""); // Send A Text Message:Send The Text:Send Message:Order
RockMigrationHelper.AddActionTypeAttributeValue("7EAE659C-5A08-4BFF-869C-A12FA5ED021E", "9A4A3446-56D0-44AE-BFC7-22006547F22E", @"False"); // Send A Text Message:Send The Text:Send Message:Active
RockMigrationHelper.AddActionTypeAttributeValue("7EAE659C-5A08-4BFF-869C-A12FA5ED021E", "2A4DB4D3-8FDD-4E25-B28E-0FB0FE8ABFA9", @"494280da-d7bf-4523-9774-20b477062113"); // Send A Text Message:Send The Text:Send Message:Recipient|Attribute Value
RockMigrationHelper.AddActionTypeAttributeValue("7EAE659C-5A08-4BFF-869C-A12FA5ED021E", "42E9674B-7413-41C4-A3F7-5E8265E83EAE", @"{{ Workflow.Message }} - {{ Workflow.Sender }} @ NewSpring Church"); // Send A Text Message:Send The Text:Send Message:Message|Attribute Value
}
public override void Up()
{
RockMigrationHelper.AddDefinedTypeAttribute("8CC5A105-E6B9-4F63-89E0-A83F81ACBB21", "73B02051-0D38-4AD9-BF81-A2D477DE4F70", "Response Headers", "ResponseHeaders", string.Empty, 5, string.Empty, "D39AFB27-C4F1-4F3B-992D-6496CC37A826");
RockMigrationHelper.AddAttributeQualifier("D39AFB27-C4F1-4F3B-992D-6496CC37A826", "allowhtml", "False", "10E1EF5E-0BEE-4CD6-BBD9-BF91082D62CB");
RockMigrationHelper.AddAttributeQualifier("D39AFB27-C4F1-4F3B-992D-6496CC37A826", "customvalues", string.Empty, "4AF90BEB-B9FB-4622-9203-F03E91D4C341");
RockMigrationHelper.AddAttributeQualifier("D39AFB27-C4F1-4F3B-992D-6496CC37A826", "definedtype", string.Empty, "3399647C-8786-4866-8F33-406B445FC3DA");
RockMigrationHelper.AddAttributeQualifier("D39AFB27-C4F1-4F3B-992D-6496CC37A826", "displayvaluefirst", "False", "C7F313BE-55D7-47E7-9E6A-31E4A8F5B7A1");
RockMigrationHelper.AddAttributeQualifier("D39AFB27-C4F1-4F3B-992D-6496CC37A826", "keyprompt", "Name", "2D84C3C9-E338-4431-93DD-57074508432A");
RockMigrationHelper.AddAttributeQualifier("D39AFB27-C4F1-4F3B-992D-6496CC37A826", "valueprompt", "Value", "36A10CB1-90D1-486F-926F-5146B4D96C10");
}
/// <summary>
/// ED: Location Selection Strategy
/// </summary>
private void CreateLocationSelectionStrategy()
{
// insert the attribute
Sql(@"
DECLARE @GroupTypeEntityId int = (SELECT [Id] FROM [EntityType] WHERE [Name] = 'Rock.Model.GroupType')
DECLARE @GroupTypeId int = (SELECT [Id] FROM [GroupType] WHERE [Guid] = '0572A5FE-20A4-4BF1-95CD-C71DB5281392')
DECLARE @FieldTypeId int = (SELECT [Id] FROM [FieldType] WHERE [Guid] = '7525C4CB-EE6B-41D4-9B64-A08048D5A5C0')
IF NOT EXISTS (
SELECT [Id]
FROM [Attribute]
WHERE [EntityTypeId] = @GroupTypeEntityId
AND [EntityTypeQualifierColumn] = 'Id'
AND [EntityTypeQualifierValue] = @GroupTypeId
AND [Key] = 'core_LocationSelectionStrategy' )
BEGIN
INSERT INTO [Attribute] (
[IsSystem]
, [FieldTypeId]
, [EntityTypeId]
, [EntityTypeQualifierColumn]
, [EntityTypeQualifierValue]
, [Key]
, [Name]
, [Description]
, [Order]
, [IsGridColumn]
, [DefaultValue]
, [IsMultiValue]
, [IsRequired]
, [Guid])
VALUES (
1
, @FieldTypeId
, @GroupTypeEntityId
, 'Id'
, @GroupTypeId
, 'core_LocationSelectionStrategy'
, 'Location Selection Strategy'
, 'Determines how the location for the group will selected. Ask will offer all available scheduled locations that are open. Load balance will fill rooms in an even manner. Fill In Order will fill locations in their configured order until they are full. The location balancing feature is intended for use with Family check-in because it asks for service time selection before room selection. If you attempt to use this feature with Individual check-in, you are likely to experience unexpected results.'
, 0
, 0
, 0
, 0
, 1
, '9C626619-2FBD-4157-8789-896944C3C60E')
END");
// Insert the attribute qualifiers
RockMigrationHelper.AddAttributeQualifier("9C626619-2FBD-4157-8789-896944C3C60E", "fieldtype", "rb", "86FF0539-9F2D-4BCD-A634-506B8DBB03DF");
RockMigrationHelper.AddAttributeQualifier("9C626619-2FBD-4157-8789-896944C3C60E", "repeatColumns", "", "D617CDD6-B2BC-4040-8338-09F498A1F0C4");
RockMigrationHelper.AddAttributeQualifier("9C626619-2FBD-4157-8789-896944C3C60E", "values", "0^Ask, 1^Load Balance, 2^Fill In Order", "9374899C-50C4-4FAB-9FDE-0B9E5DB502BB");
}
public override void Up()
{
// Update the footer on the Summary User Entry Forms to only show valid visits
RockMigrationHelper.UpdateWorkflowActionForm(@"<div class=""panel panel-default""> <div class=""panel-heading""> <div class=""panel-title""> <i class=""fa fa-info-circle""></i> Homebound Resident Information </div> </div> <div class=""panel-body""> <div class=""col-md-6""> <div class=""form-group static-control"" style=""margin-top: 57px;""> <label class=""control-label"">Age</label><div class=""control-wrapper""> <p class=""form-control-static"">{{ Workflow | Attribute:'HomeboundPerson','Age' }}</p> </div> </div>", @" </div> </div>{% capture visitList %} <div class=""panel panel-default""> <div class=""panel-heading""> <div class=""panel-title""> <i class=""fa fa-calendar""></i> Visit History </div> </div> <div class=""panel-body""> <table class=""table table-striped table-bordered""> <thead> <tr> <th>Visitor</th> <th>Date</th> <th>Visit Notes</th> </tr> </thead> <tbody> {% for activity in Workflow.Activities reversed %} {% assign visitDateSize = activity | Attribute:'VisitDate' | Size %}{% if activity.ActivityType.Name == 'Visitation Info' and visitDateSize > 0 %}{% assign showVisits = true %} <tr> <td>{{ activity.Visitor }}</td> <td>{{ activity.VisitDate }}</td> <td>{{ activity.VisitNote }}</td> </tr> {% endif %} {% endfor %} </tbody> </table> </div> </div>{% endcapture %}{% if showVisits == 'true' %}{{visitList}}{% endif %}", "Edit^fdc397cd-8b4a-436e-bea1-bce2e6717c03^F5F74E70-3643-4122-9221-5FAAB0DBF47F^Your information has been submitted successfully.|Add Visit^fdc397cd-8b4a-436e-bea1-bce2e6717c03^61E356D3-2A02-457B-9A43-B67806C67A45^|Close^fdc397cd-8b4a-436e-bea1-bce2e6717c03^9F9FEF18-1259-43D1-B922-C37C17B7D9D8^|", "", true, "", "87FDE195-3C3E-408C-BD42-19A9FE01D224"); // Homebound Resident:Homebound Resident Summary:Entry Form
RockMigrationHelper.UpdateWorkflowActionForm(@"<div class=""panel panel-default""> <div class=""panel-heading""> <div class=""panel-title""> <i class=""fa fa-info-circle""></i> Resident Information </div> </div> <div class=""panel-body""> <div class=""col-md-6""> <div class=""form-group static-control"" style=""margin-top: 57px;""> <label class=""control-label"">Age</label><div class=""control-wrapper""> <p class=""form-control-static"">{{ Workflow | Attribute:'PersonToVisit','Age' }} </p> </div> </div>", @" </div> </div>{% capture visitList %} <div class=""panel panel-default""> <div class=""panel-heading""> <div class=""panel-title""> <i class=""fa fa-calendar""></i> Visit History </div> </div> <div class=""panel-body""> <table class=""table table-striped table-bordered""> <thead> <tr> <th>Visitor</th> <th>Date</th> <th>Visit Notes</th> </tr> </thead> <tbody> {% for activity in Workflow.Activities reversed %} {% assign visitDateSize = activity | Attribute:'VisitDate' | Size %}{% if activity.ActivityType.Name == 'Visitation Info' and visitDateSize > 0 %}{% assign showVisits = true %} <tr> <td>{{ activity.Visitor }}</td> <td>{{ activity.VisitDate }}</td> <td>{{ activity.VisitNote }}</td> </tr> {% endif %} {% endfor %} </tbody> </table> </div> </div>{% endcapture %}{% if showVisits == 'true' %}{{visitList}}{% endif %}", "Edit Request^fdc397cd-8b4a-436e-bea1-bce2e6717c03^c5bc1151-7a01-4422-8a67-fc495c2d937c^Your information has been submitted successfully.|Add Visit^fdc397cd-8b4a-436e-bea1-bce2e6717c03^6dcf3214-b88f-4d4e-9251-3cf4a8cbea6b^|Discharge^fdc397cd-8b4a-436e-bea1-bce2e6717c03^8a694803-6cce-4be1-b3c5-5ff23e0e5539^", "", true, "", "4992F4AB-998B-4939-B442-AF93A11485F0"); // Nursing Home Resident:Resident Summary Info:Entry Form
RockMigrationHelper.UpdateWorkflowActionForm(@"<div class=""panel panel-default""> <div class=""panel-heading""> <div class=""panel-title""> <i class=""fa fa-info-circle""></i> Patient Information </div> </div> <div class=""panel-body""> <div class=""col-md-6""> <div class=""form-group static-control"" style=""margin-top: 57px;""> <label class=""control-label"">Age</label><div class=""control-wrapper""> <p class=""form-control-static"">{{ Workflow | Attribute:'PersonToVisit','Age' }} </p> </div> </div>", @" </div> </div>{% capture visitList %} <div class=""panel panel-default""> <div class=""panel-heading""> <div class=""panel-title""> <i class=""fa fa-calendar""></i> Visit History </div> </div> <div class=""panel-body""> <table class=""table table-striped table-bordered""> <thead> <tr> <th>Visitor</th> <th>Date</th> <th>Visit Notes</th> </tr> </thead> <tbody> {% for activity in Workflow.Activities reversed %} {% assign visitDateSize = activity | Attribute:'VisitDate' | Size %}{% if activity.ActivityType.Name == 'Visitation Info' and visitDateSize > 0 %}{% assign showVisits = true %} <tr> <td>{{ activity.Visitor }}</td> <td>{{ activity.VisitDate }}</td> <td>{{ activity.VisitNote }}</td> </tr> {% endif %} {% endfor %} </tbody> </table> </div> </div>{% endcapture %}{% if showVisits == 'true' %}{{visitList}}{% endif %}", "Edit Request^fdc397cd-8b4a-436e-bea1-bce2e6717c03^00E9E98E-2027-4B7D-AAAD-87D11B0EC06B^Your information has been submitted successfully.|Add Visit^fdc397cd-8b4a-436e-bea1-bce2e6717c03^8E7746D0-5920-434B-BC61-78333100740A^|Discharge^fdc397cd-8b4a-436e-bea1-bce2e6717c03^03FCE7A7-82BE-49E2-9A67-05D31AE0E1CA^|", "", true, "", "7E6636A3-52C3-4727-8B9E-0DB50406BCF8"); // Hospital Admission:Patient Summary Info:Entry Form
// Create the Attribute Command attributes
RockMigrationHelper.UpdateWorkflowActivityTypeAttribute("61E356D3-2A02-457B-9A43-B67806C67A45", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Activity Command", "ActivityCommand", "", 3, @"", "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74B"); // Homebound Resident:Visitation Info:Activity Command
RockMigrationHelper.AddAttributeQualifier("7ACF21F1-D8B8-4B51-A040-95B7E4FFA74B", "ispassword", @"False", "90CDEA76-75FC-4BB7-9789-A202CEB7B153"); // Hospital Admission:Activity Command:ispassword
RockMigrationHelper.UpdateWorkflowActivityTypeAttribute("6DCF3214-B88F-4D4E-9251-3CF4A8CBEA6B", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Activity Command", "ActivityCommand", "", 3, @"", "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74C"); // Nursing Home Resident:Visitation Info:Activity Command
RockMigrationHelper.AddAttributeQualifier("7ACF21F1-D8B8-4B51-A040-95B7E4FFA74C", "ispassword", @"False", "90CDEA76-75FC-4BB7-9789-A202CEB7B154"); // Hospital Admission:Activity Command:ispassword
RockMigrationHelper.UpdateWorkflowActivityTypeAttribute("8E7746D0-5920-434B-BC61-78333100740A", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Activity Command", "ActivityCommand", "", 3, @"", "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74D"); // Hospital Admission:Visitation Info:Activity Command
RockMigrationHelper.AddAttributeQualifier("7ACF21F1-D8B8-4B51-A040-95B7E4FFA74D", "ispassword", @"False", "90CDEA76-75FC-4BB7-9789-A202CEB7B155"); // Hospital Admission:Activity Command:ispassword
// Add the cancel button
RockMigrationHelper.UpdateWorkflowActionForm(@"", @"", "Save Visit^fdc397cd-8b4a-436e-bea1-bce2e6717c03^3b165553-0d50-4d1d-a53f-f4fff50cbe3f^Your information has been submitted successfully.|Cancel^5683e775-b9f3-408c-80ac-94de0e51cf3a^3b165553-0d50-4d1d-a53f-f4fff50cbe3f^|", "", true, "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74B", "D8CC1582-5F0A-4270-931D-C9AE1BF91672"); // Homebound Resident:Visitation Info:Form Entry
RockMigrationHelper.UpdateWorkflowActionForm(@"", @"", "Save Visit^fdc397cd-8b4a-436e-bea1-bce2e6717c03^b55f9a75-d6fa-4854-b67d-4c84afa0883d^Your information has been submitted successfully.|Cancel^5683e775-b9f3-408c-80ac-94de0e51cf3a^b55f9a75-d6fa-4854-b67d-4c84afa0883d^|", "", true, "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74C", "41C3DD25-249D-42E7-90E4-F2ED09A40938"); // Nursing Home Resident:Visitation Info:Form Entry
RockMigrationHelper.UpdateWorkflowActionForm(@"", @"", "Save Visit^fdc397cd-8b4a-436e-bea1-bce2e6717c03^A24F45F9-CDCC-42C9-8457-7F4438F9C0F9^Your information has been submitted successfully.|Cancel^5683e775-b9f3-408c-80ac-94de0e51cf3a^A24F45F9-CDCC-42C9-8457-7F4438F9C0F9^|", "", true, "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74D", "62E4A560-CBBA-4ABB-9BA0-36E3408B7B49"); // Hospital Admission:Visitation Info:Form Entry
// Add actions to clear the visit date
RockMigrationHelper.UpdateWorkflowActionType("61E356D3-2A02-457B-9A43-B67806C67A45", "Clear the Visit Date", 2, "C789E457-0783-44B3-9D8F-2EBAB5F11110", true, false, "", "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74B", 1, "Cancel", "044E0BC8-FDE1-44A2-8796-264E8D1B3489"); // Homebound Resident:Visitation Info:Clear the Visit Date
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3489", "D7EAA859-F500-4521-9523-488B12EAA7D2", @"False"); // Homebound Resident:Visitation Info:Clear the Visit Date:Active
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3489", "44A0B977-4730-4519-8FF6-B0A01A95B212", @"5F961235-C39A-41E1-BA6E-A030815F8AAB"); // Homebound Resident:Visitation Info:Clear the Visit Date:Attribute
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3489", "57093B41-50ED-48E5-B72B-8829E62704C8", @""); // Homebound Resident:Visitation Info:Clear the Visit Date:Order
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3489", "E5272B11-A2B8-49DC-860D-8D574E2BC15C", @""); // Homebound Resident:Visitation Info:Clear the Visit Date:Text Value|Attribute Value
RockMigrationHelper.UpdateWorkflowActionType("6DCF3214-B88F-4D4E-9251-3CF4A8CBEA6B", "Clear the Visit Date", 2, "C789E457-0783-44B3-9D8F-2EBAB5F11110", true, false, "", "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74C", 1, "Cancel", "044E0BC8-FDE1-44A2-8796-264E8D1B3490"); // Nursing Home Resident:Visitation Info:Clear the Visit Date
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3490", "D7EAA859-F500-4521-9523-488B12EAA7D2", @"False"); // Nursing Home Resident:Visitation Info:Clear the Visit Date:Active
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3490", "44A0B977-4730-4519-8FF6-B0A01A95B212", @"6800068F-D799-4787-8241-948F1F910949"); // Nursing Home Resident:Visitation Info:Clear the Visit Date:Attribute
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3490", "57093B41-50ED-48E5-B72B-8829E62704C8", @""); // Nursing Home Resident:Visitation Info:Clear the Visit Date:Order
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3490", "E5272B11-A2B8-49DC-860D-8D574E2BC15C", @""); // Nursing Home Resident:Visitation Info:Clear the Visit Date:Text Value|Attribute Value
RockMigrationHelper.UpdateWorkflowActionType("8E7746D0-5920-434B-BC61-78333100740A", "Clear the Visit Date", 2, "C789E457-0783-44B3-9D8F-2EBAB5F11110", true, false, "", "7ACF21F1-D8B8-4B51-A040-95B7E4FFA74D", 1, "Cancel", "044E0BC8-FDE1-44A2-8796-264E8D1B3491"); // Hospital Admission:Visitation Info:Clear the Visit Date
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3491", "D7EAA859-F500-4521-9523-488B12EAA7D2", @"False"); // Hospital Admission:Visitation Info:Clear the Visit Date:Active
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3491", "44A0B977-4730-4519-8FF6-B0A01A95B212", @"A411555B-D3F9-4341-A27A-69C767C8EE83"); // Hospital Admission:Visitation Info:Clear the Visit Date:Attribute
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3491", "57093B41-50ED-48E5-B72B-8829E62704C8", @""); // Hospital Admission:Visitation Info:Clear the Visit Date:Order
RockMigrationHelper.AddActionTypeAttributeValue("044E0BC8-FDE1-44A2-8796-264E8D1B3491", "E5272B11-A2B8-49DC-860D-8D574E2BC15C", @""); // Hospital Admission:Visitation Info:Clear the Visit Date:Text Value|Attribute Value
// Add an action to make sure the activity is complete
RockMigrationHelper.UpdateWorkflowActionType("61E356D3-2A02-457B-9A43-B67806C67A45", "Activity Complete", 3, "0D5E33A5-8700-4168-A42E-74D78B62D717", true, true, "", "", 1, "", "A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58C8"); // Homebound Resident:Visitation Info:Activity Complete
RockMigrationHelper.AddActionTypeAttributeValue("A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58C8", "27BCE39D-9E9B-4704-AAD0-4E8ADC114F72", @""); // Homebound Resident:Visitation Info:Activity Complete:Order
RockMigrationHelper.AddActionTypeAttributeValue("A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58C8", "1CFB9BFA-6665-4058-8E28-1FD9D5F8F69A", @"False"); // Homebound Resident:Visitation Info:Activity Complete:Active
RockMigrationHelper.UpdateWorkflowActionType("6DCF3214-B88F-4D4E-9251-3CF4A8CBEA6B", "Activity Complete", 3, "0D5E33A5-8700-4168-A42E-74D78B62D717", true, true, "", "", 1, "", "A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58C9"); // Nursing Home Resident:Visitation Info:Activity Complete
RockMigrationHelper.AddActionTypeAttributeValue("A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58C9", "27BCE39D-9E9B-4704-AAD0-4E8ADC114F72", @""); // Nursing Home Resident:Visitation Info:Activity Complete:Order
RockMigrationHelper.AddActionTypeAttributeValue("A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58C9", "1CFB9BFA-6665-4058-8E28-1FD9D5F8F69A", @"False"); // Nursing Home Resident:Visitation Info:Activity Complete:Active
RockMigrationHelper.UpdateWorkflowActionType("8E7746D0-5920-434B-BC61-78333100740A", "Activity Complete", 3, "0D5E33A5-8700-4168-A42E-74D78B62D717", true, true, "", "", 1, "", "A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58CA"); // Hospital Admission:Visitation Info:Activity Complete
RockMigrationHelper.AddActionTypeAttributeValue("A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58CA", "27BCE39D-9E9B-4704-AAD0-4E8ADC114F72", @""); // Hospital Admission:Visitation Info:Activity Complete:Order
RockMigrationHelper.AddActionTypeAttributeValue("A4EA2FB5-75F6-4F44-9D73-B0CB7E9C58CA", "1CFB9BFA-6665-4058-8E28-1FD9D5F8F69A", @"False"); // Hospital Admission:Visitation Info:Activity Complete:Active
}
/// <summary>
/// The commands to run to migrate plugin to the specific version
/// </summary>
public override void Up()
{
// modify keys if they exist
RockMigrationHelper.EnsureAttributeByGuid("3DF6068C-AFD2-4D59-8FCE-9BE9D4930E0D", "kfs_mm_firstname", Rock.SystemGuid.EntityType.FINANCIAL_TRANSACTION, Rock.SystemGuid.FieldType.TEXT, "", "");
RockMigrationHelper.EnsureAttributeByGuid("D9A20523-2979-41E3-B6E2-C4C75EC079FE", "kfs_mm_lastname", Rock.SystemGuid.EntityType.FINANCIAL_TRANSACTION, Rock.SystemGuid.FieldType.TEXT, "", "");
RockMigrationHelper.EnsureAttributeByGuid("3E99FD9F-87DB-429D-9DDA-09ACC73C2911", "kfs_mm_personkey", Rock.SystemGuid.EntityType.FINANCIAL_TRANSACTION, Rock.SystemGuid.FieldType.TEXT, "", "");
RockMigrationHelper.EnsureAttributeByGuid("C500B2C3-79A0-4EBC-9E6A-0B356A66B970", "kfs_mm_tripname", Rock.SystemGuid.EntityType.FINANCIAL_TRANSACTION, Rock.SystemGuid.FieldType.TEXT, "", "");
RockMigrationHelper.EnsureAttributeByGuid("3025ACDB-40D1-4A52-AF0A-547D7126D90D", "kfs_mm_purposecode", Rock.SystemGuid.EntityType.FINANCIAL_TRANSACTION, Rock.SystemGuid.FieldType.TEXT, "", "");
RockMigrationHelper.EnsureAttributeByGuid("6A5F63FA-23D6-4BA4-84A1-3D10951646DB", "kfs_mm_tripkey", Rock.SystemGuid.EntityType.FINANCIAL_TRANSACTION, Rock.SystemGuid.FieldType.TEXT, "", "");
RockMigrationHelper.EnsureAttributeByGuid("A30C07EB-AE07-4AF4-9831-B32F9B073B31", "kfs_mm_incomeaccount", Rock.SystemGuid.EntityType.FINANCIAL_TRANSACTION, Rock.SystemGuid.FieldType.TEXT, "", "");
RockMigrationHelper.EnsureAttributeByGuid("BFC71CD0-2A4C-4491-847E-A5DCB1A1E876", "kfs_mm_ManagedMissionsSyncDate", Rock.SystemGuid.EntityType.FINANCIAL_TRANSACTION, Rock.SystemGuid.FieldType.TEXT, "", "");
// mm url fields
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.FinancialTransaction", Rock.SystemGuid.FieldType.TEXT, "", "", "Person First Name", "", 100, "", "3DF6068C-AFD2-4D59-8FCE-9BE9D4930E0D", "kfs_mm_firstname");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.FinancialTransaction", Rock.SystemGuid.FieldType.TEXT, "", "", "Person Last Name", "", 101, "", "D9A20523-2979-41E3-B6E2-C4C75EC079FE", "kfs_mm_lastname");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.FinancialTransaction", Rock.SystemGuid.FieldType.TEXT, "", "", "Person Import/Export Key", "", 102, "", "3E99FD9F-87DB-429D-9DDA-09ACC73C2911", "kfs_mm_personkey");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.FinancialTransaction", Rock.SystemGuid.FieldType.TEXT, "", "", "Trip Name", "", 103, "", "C500B2C3-79A0-4EBC-9E6A-0B356A66B970", "kfs_mm_tripname");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.FinancialTransaction", Rock.SystemGuid.FieldType.TEXT, "", "", "Trip Purpose Code", "", 104, "", "3025ACDB-40D1-4A52-AF0A-547D7126D90D", "kfs_mm_purposecode");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.FinancialTransaction", Rock.SystemGuid.FieldType.TEXT, "", "", "Trip Import/Exort Key", "", 105, "", "6A5F63FA-23D6-4BA4-84A1-3D10951646DB", "kfs_mm_tripkey");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.FinancialTransaction", Rock.SystemGuid.FieldType.TEXT, "", "", "Income Account Number", "", 106, "", "A30C07EB-AE07-4AF4-9831-B32F9B073B31", "kfs_mm_incomeaccount");
// sync date
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.FinancialTransaction", Rock.SystemGuid.FieldType.DATE_TIME, "", "", "Managed Missions Sync Date", "Date this Transaction was synced", 107, "", "BFC71CD0-2A4C-4491-847E-A5DCB1A1E876", "kfs_mm_ManagedMissionsSyncDate");
RockMigrationHelper.AddAttributeQualifier("BFC71CD0-2A4C-4491-847E-A5DCB1A1E876", "displayDiff", "False", "7257C567-E916-4439-8A3E-BAEBC5BE82CA");
RockMigrationHelper.AddAttributeQualifier("BFC71CD0-2A4C-4491-847E-A5DCB1A1E876", "format", "", "E490A27C-A995-44D7-BC79-5772AAD59F91");
RockMigrationHelper.UpdateCategory("5997C8D3-8840-4591-99A5-552919F90CBD", "Managed Missions Transactions", "fa fa-plane", "", "0A7C03CF-8204-4F25-9156-30A91045CC52");
Sql(@"
DECLARE @TransactionEntityTypeId int = ( SELECT TOP 1 [Id] FROM [EntityType] WHERE [Guid] = '2C1CB26B-AB22-42D0-8164-AEDEE0DAE667' )
DECLARE @CategoryId int = ( SELECT TOP 1 [Id] FROM [Category] WHERE [Guid] = '0A7C03CF-8204-4F25-9156-30A91045CC52' )
UPDATE [Category]
SET [EntityTypeQualifierColumn] = 'EntityTypeId', [EntityTypeQualifierValue] = @TransactionEntityTypeId
WHERE [Id] = @CategoryId
INSERT INTO [AttributeCategory]
SELECT [Id], @CategoryId
FROM [Attribute]
LEFT OUTER JOIN [AttributeCategory] ON [Attribute].[Id] = [AttributeCategory].[AttributeId] AND [AttributeCategory].[CategoryId] = @CategoryId
WHERE ([Attribute].[Guid] = '3DF6068C-AFD2-4D59-8FCE-9BE9D4930E0D'
OR [Attribute].[Guid] = 'D9A20523-2979-41E3-B6E2-C4C75EC079FE'
OR [Attribute].[Guid] = '3E99FD9F-87DB-429D-9DDA-09ACC73C2911'
OR [Attribute].[Guid] = 'C500B2C3-79A0-4EBC-9E6A-0B356A66B970'
OR [Attribute].[Guid] = '3025ACDB-40D1-4A52-AF0A-547D7126D90D'
OR [Attribute].[Guid] = '6A5F63FA-23D6-4BA4-84A1-3D10951646DB'
OR [Attribute].[Guid] = 'A30C07EB-AE07-4AF4-9831-B32F9B073B31'
OR [Attribute].[Guid] = 'BFC71CD0-2A4C-4491-847E-A5DCB1A1E876')
AND [AttributeCategory].[AttributeId] IS NULL
");
}
/// <summary>
/// The commands to run to migrate plugin to the specific version
/// </summary>
public override void Up()
{
#region Email Attribute
var attributeMatrixTemplateEmailId = new AttributeMatrixTemplateService(new RockContext()).Get(KFSConst.Attribute.ATTRIBUTE_MATRIX_TEMPLATE_SCHEDULED_EMAILS.AsGuid()).Id.ToString();
// recurrence attribute
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.AttributeMatrixItem", Rock.SystemGuid.FieldType.SINGLE_SELECT, "AttributeMatrixTemplateId", attributeMatrixTemplateEmailId, "Recurrence", "", 1, "0", KFSConst.Attribute.MATRIX_ATTRIBUTE_EMAIL_SEND_RECURRENCE, "rocks.kfs.ScheduledGroupCommunication.EmailSendRecurrence");
RockMigrationHelper.AddAttributeQualifier(KFSConst.Attribute.MATRIX_ATTRIBUTE_EMAIL_SEND_RECURRENCE, "values", "0^OneTime,1^Weekly,2^BiWeekly,3^Monthly", "F1F0873E-CA36-4935-90F5-DFEFD79083C8");
// reorder existing matrix attributes
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.AttributeMatrixItem", Rock.SystemGuid.FieldType.EMAIL, "AttributeMatrixTemplateId", attributeMatrixTemplateEmailId, "From Email", "", 2, "", KFSConst.Attribute.MATRIX_ATTRIBUTE_EMAIL_FROM_EMAIL, "rocks.kfs.ScheduledGroupCommunication.EmailFromAddress");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.AttributeMatrixItem", Rock.SystemGuid.FieldType.TEXT, "AttributeMatrixTemplateId", attributeMatrixTemplateEmailId, "From Name", "", 3, "", KFSConst.Attribute.MATRIX_ATTRIBUTE_EMAIL_FROM_NAME, "rocks.kfs.ScheduledGroupCommunication.EmailFromName");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.AttributeMatrixItem", Rock.SystemGuid.FieldType.TEXT, "AttributeMatrixTemplateId", attributeMatrixTemplateEmailId, "Subject", "", 4, "", KFSConst.Attribute.MATRIX_ATTRIBUTE_EMAIL_SUBJECT, "rocks.kfs.ScheduledGroupCommunication.EmailSubject");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.AttributeMatrixItem", Rock.SystemGuid.FieldType.HTML, "AttributeMatrixTemplateId", attributeMatrixTemplateEmailId, "Message", "", 5, "", KFSConst.Attribute.MATRIX_ATTRIBUTE_EMAIL_MESSAGE, "rocks.kfs.ScheduledGroupCommunication.EmailMessage");
// set attribute to be required
Sql(@"
UPDATE [Attribute] SET [IsRequired] = 1
WHERE (
[Guid] = '9BC4F790-A9F7-4822-AEEE-91095A3E3D4C'
)
");
#endregion
#region SMS Attributes
var rockContextSMS = new RockContext();
var attributeMatrixTemplateSMSId = new AttributeMatrixTemplateService(rockContextSMS).Get(KFSConst.Attribute.ATTRIBUTE_MATRIX_TEMPLATE_SCHEDULED_SMS.AsGuid()).Id.ToString();
// recurrence attribute
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.AttributeMatrixItem", Rock.SystemGuid.FieldType.SINGLE_SELECT, "AttributeMatrixTemplateId", attributeMatrixTemplateSMSId, "Recurrence", "", 1, "0", KFSConst.Attribute.MATRIX_ATTRIBUTE_SMS_SEND_RECURRENCE, "rocks.kfs.ScheduledGroupCommunication.SMSSendRecurrence");
RockMigrationHelper.AddAttributeQualifier(KFSConst.Attribute.MATRIX_ATTRIBUTE_SMS_SEND_RECURRENCE, "values", "0^OneTime,1^Weekly,2^BiWeekly,3^Monthly", "4FAE15C5-C1AB-4FDB-B21D-CBF467B1D395");
// reorder existing matrix attributes
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.AttributeMatrixItem", Rock.SystemGuid.FieldType.DEFINED_VALUE, "AttributeMatrixTemplateId", attributeMatrixTemplateSMSId, "From Number", "", 2, "", KFSConst.Attribute.MATRIX_ATTRIBUTE_SMS_FROM_NUMBER, "rocks.kfs.ScheduledGroupCommunication.SMSFromNumber");
RockMigrationHelper.UpdateEntityAttribute("Rock.Model.AttributeMatrixItem", Rock.SystemGuid.FieldType.MEMO, "AttributeMatrixTemplateId", attributeMatrixTemplateSMSId, "Message", "", 3, "", KFSConst.Attribute.MATRIX_ATTRIBUTE_SMS_MESSAGE, "rocks.kfs.ScheduledGroupCommunication.SMSMessage");
// set attribute to be required
Sql(@"
UPDATE [Attribute] SET [IsRequired] = 1
WHERE (
[Guid] = 'EC6D13F7-A256-4B03-A94B-3B713F26E62D'
)
");
#endregion
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
// Drop views that were pointing to AnalyticsDimDate and re-create them after the rename
Sql(@"
IF OBJECT_ID(N'[dbo].[AnalyticsDimAttendanceDate]', 'V') IS NOT NULL
DROP VIEW [dbo].AnalyticsDimAttendanceDate
GO
IF OBJECT_ID(N'[dbo].[AnalyticsDimFinancialTransactionDate]', 'V') IS NOT NULL
DROP VIEW [dbo].AnalyticsDimFinancialTransactionDate
GO
IF OBJECT_ID(N'[dbo].[AnalyticsDimPersonBirthDate]', 'V') IS NOT NULL
DROP VIEW [dbo].AnalyticsDimPersonBirthDate
GO
");
RenameTable(name: "dbo.AnalyticsDimDate", newName: "AnalyticsSourceDate");
Sql(MigrationSQL._201709191729044_Analytics2_AnalyticsDimAttendanceDate);
Sql(MigrationSQL._201709191729044_Analytics2_AnalyticsDimFamilyHeadOfHouseholdBirthDate);
Sql(MigrationSQL._201709191729044_Analytics2_AnalyticsDimFinancialTransactionDate);
Sql(MigrationSQL._201709191729044_Analytics2_AnalyticsDimPersonCurrentBirthDate);
Sql(MigrationSQL._201709191729044_Analytics2_AnalyticsDimPersonHistoricalBirthDate);
// DT: vCard Format
RockMigrationHelper.AddGlobalAttribute(Rock.SystemGuid.FieldType.CODE_EDITOR, "", "", "vCard Format", "Lava format to use when creating a vCard for a person", 0, @"
BEGIN:VCARD
VERSION:2.1
N:{{ Person.LastName }};{{ Person.NickName }}
FN:{{ Person.FullName }}
{% assign cellPhone = Person | PhoneNumber:''Mobile'', true %}{% if cellPhone and cellPhone != '''' %}TEL;PREF;CELL:{{ cellPhone }}{% endif %}
{% assign homePhone = Person | PhoneNumber:''Home'', true %}{% if homePhone and homePhone != '''' %}TEL;HOME:{{ homePhone }}{% endif %}
{% assign workPhone = Person | PhoneNumber:''Work'', true %}{% if workPhone and workPhone != '''' %}TEL;WORK:{{ workPhone }}{% endif %}
{% if Person.Email and Person.Email != '''' %}EMAIL;PREF;HOME:{{ Person.Email}}{% endif %}
{{ Person | Address:''Home'',''ADR;HOME;PREF:;;[[Street1]];[[City]];[[State]];[[PostalCode]]'' }}
{{ Person | Address:''Work'',''ADR;WORK:;;[[Street1]];[[City]];[[State]];[[PostalCode]]'' }}
{% assign employer = Person | Attribute:''Employer'' %}{% if employer and employer != '''' %}ORG:{{ employer }}{% endif %}
{% assign position = Person | Attribute:''Position'' %}{% if position and position != '''' %}TITLE:{{ position }}{% endif %}
{% if Person.PhotoId %}PHOTO;ENCODING=BASE64;TYPE=JPEG:{{ Person.PhotoId | Base64Encode:''h=92&w=92&mode=max&format=jpg'' }}{% endif %}
END:VCARD
", "DC0C0ED9-3347-4EBA-A6B5-CC5A8F547F92", "VCardFormat");
RockMigrationHelper.AddAttributeQualifier("DC0C0ED9-3347-4EBA-A6B5-CC5A8F547F92", "editorHeight", "400", "41C08E15-2B78-4F50-9BC6-5A3217B542BD");
RockMigrationHelper.AddAttributeQualifier("DC0C0ED9-3347-4EBA-A6B5-CC5A8F547F92", "editorMode", "3", "C28D3C9C-586B-40F2-BDEA-5BF67F2ED0C9");
RockMigrationHelper.AddAttributeQualifier("DC0C0ED9-3347-4EBA-A6B5-CC5A8F547F92", "editorTheme", "0", "A07ED4B6-9391-459A-AA4D-472926F259C9");
}
public override void Up()
{
RockMigrationHelper.AddGroupTypeGroupAttribute(Constants.GROUP_TYPE_BY_MEMBERSHIP, Rock.SystemGuid.FieldType.SINGLE_SELECT, "Check Requirements",
"Should the requirements of the group be checked before allowing check-in. This is slower but needed in some situations.",
5, "0", Constants.GROUP_ATTRIBUTE_CHECK_REQUIREMENTS, false);
RockMigrationHelper.AddAttributeQualifier(Constants.GROUP_ATTRIBUTE_CHECK_REQUIREMENTS, "values", "0^Do Not Check,1^Check Required Only,2^Check Required and Warning", "9E659023-6860-4872-B7C9-EB019FF76145");
RockMigrationHelper.AddGroupTypeGroupAttribute(Constants.GROUP_TYPE_BY_MEMBERSHIP, Rock.SystemGuid.FieldType.SINGLE_SELECT, "Member Role",
"Optional filter to only allow people if they are a member or leader.",
6, "0", Constants.GROUP_ATTRIBUTE_MEMBER_ROLE, false);
RockMigrationHelper.AddAttributeQualifier(Constants.GROUP_ATTRIBUTE_MEMBER_ROLE, "values", "0^Any,1^Leaders Only,2^Non Leaders Only", "840B04D7-DC1B-452B-A869-0AEB4904DC26");
RockMigrationHelper.AddGroupTypeGroupAttribute(Constants.GROUP_TYPE_BY_MEMBERSHIP, Rock.SystemGuid.FieldType.BOOLEAN, "Save Attendance To Group",
"If selected, the attendance will be set on the group the person is a member of instead of on the check-in group.",
7, "False", Constants.GROUP_ATTRIBUTE_ATTENDANCE_ON_GROUP);
}
public override void Up()
{
RockMigrationHelper.AddDefinedType("", "Html To Image", "Templates for creating images from Html and Lava", "8CC5A105-E6B9-4F63-89E0-A83F81ACBB21");
RockMigrationHelper.AddDefinedTypeAttribute("8CC5A105-E6B9-4F63-89E0-A83F81ACBB21", "1D0D3794-C210-48A8-8C68-3FBEC08A6BA5", "Template", "Template", "", 0, "", "A247948E-AF88-4622-996D-DBE69CE41832");
RockMigrationHelper.AddDefinedTypeAttribute("8CC5A105-E6B9-4F63-89E0-A83F81ACBB21", "4BD9088F-5CC6-89B1-45FC-A2AAFFC7CC0D", "Enabled Lava Commands", "EnabledLavaCommands", "", 1, "", "40286BE2-F841-423C-B920-78D827C65B81");
RockMigrationHelper.AddDefinedTypeAttribute("8CC5A105-E6B9-4F63-89E0-A83F81ACBB21", "7525C4CB-EE6B-41D4-9B64-A08048D5A5C0", "Image Type", "ImageType", "", 2, "", "3735CF5F-405A-4914-9880-9CC64343CD11");
RockMigrationHelper.AddDefinedTypeAttribute("8CC5A105-E6B9-4F63-89E0-A83F81ACBB21", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Height", "Height", "", 4, "", "D7759B7A-7D4B-4370-A665-18396F7D6768");
RockMigrationHelper.AddDefinedTypeAttribute("8CC5A105-E6B9-4F63-89E0-A83F81ACBB21", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Width", "Width", "", 3, "", "9191028F-A80B-4D1A-B8B8-3B11E4DFDAD5");
RockMigrationHelper.AddAttributeQualifier("3735CF5F-405A-4914-9880-9CC64343CD11", "fieldtype", "ddl", "27978DCD-6C83-4E5C-96CD-32DA5EDDF2F5");
RockMigrationHelper.AddAttributeQualifier("3735CF5F-405A-4914-9880-9CC64343CD11", "repeatColumns", "", "50FF293A-53FB-4BE6-8F84-C6C4F4D118FE");
RockMigrationHelper.AddAttributeQualifier("3735CF5F-405A-4914-9880-9CC64343CD11", "values", "png,jpg", "5BA047C2-B988-492B-8F46-D48FCF5EBDFE");
RockMigrationHelper.AddAttributeQualifier("40286BE2-F841-423C-B920-78D827C65B81", "repeatColumns", "", "0BC7C7E7-5DE6-485D-97F4-6C630D337A81");
RockMigrationHelper.AddAttributeQualifier("A247948E-AF88-4622-996D-DBE69CE41832", "editorHeight", "400", "CE4187E7-D83F-4BAF-8EBC-A1124474959B");
RockMigrationHelper.AddAttributeQualifier("A247948E-AF88-4622-996D-DBE69CE41832", "editorMode", "3", "354730E0-C67A-4686-817F-11FE82A34AE0");
RockMigrationHelper.AddAttributeQualifier("A247948E-AF88-4622-996D-DBE69CE41832", "editorTheme", "0", "FC2F6D93-69AC-4616-BF97-2CD3F6FAF856");
}
/// <summary>
/// The commands to run to migrate plugin to the specific version
/// </summary>
public override void Up()
{
// Data Automation Settings
RockMigrationHelper.AddPage(true, "84FD84DF-F58B-4B9D-A407-96276C40AB7E", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Data Integrity Settings", "", "A2D5F989-1E30-47B9-AAFC-F7EC627AFF21", "fa fa-tachometer"); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("Data Automation Settings", "Block used to set values specific to data automation (NCOA, Updating Person Status, Family Campus, Etc).", "~/Blocks/Administration/DataAutomationSettings.ascx", "Administration", "E34C45E9-97CA-4902-803B-1EFAC9174083");
RockMigrationHelper.AddBlock(true, "A2D5F989-1E30-47B9-AAFC-F7EC627AFF21", "", "E34C45E9-97CA-4902-803B-1EFAC9174083", "Data Automation Settings", "Main", @"", @"", 0, "AD705C56-1451-4FD6-BDC3-66072F54034D");
RockMigrationHelper.AddDefinedTypeAttribute("E17D5988-0372-4792-82CF-9E37C79F7319", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Allow Automated Reactivation", "AllowAutomatedReactivation", "", 1001, "True", "E47870C0-17C7-4556-A922-D7866DFC2C57");
RockMigrationHelper.AddAttributeQualifier("E47870C0-17C7-4556-A922-D7866DFC2C57", "falsetext", "No", "0EBAAE3D-DC46-4834-8EE7-F44CA07D43E6");
RockMigrationHelper.AddAttributeQualifier("E47870C0-17C7-4556-A922-D7866DFC2C57", "truetext", "Yes", "C322A622-C1FE-45C7-87B8-60A357BDC2D8");
RockMigrationHelper.UpdateDefinedValue("E17D5988-0372-4792-82CF-9E37C79F7319", "Does not attend with family", "The individual has not attended with family.", "2BDE800A-C562-4077-9636-5C68770D9676", false);
RockMigrationHelper.AddDefinedValueAttributeValue("05D35BC4-5816-4210-965F-1BF44F35A16A", "E47870C0-17C7-4556-A922-D7866DFC2C57", @"False");
RockMigrationHelper.AddDefinedValueAttributeValue("2BDE800A-C562-4077-9636-5C68770D9676", "E47870C0-17C7-4556-A922-D7866DFC2C57", @"False");
RockMigrationHelper.UpdateDefinedValue("E17D5988-0372-4792-82CF-9E37C79F7319", "No Activity", "The individual has not participated in any recent activity.", "64014FE6-943D-4ACF-8014-FED9F9169AE8", true);
Sql(@"IF NOT EXISTS(SELECT [Id] FROM [ServiceJob] WHERE [Class] = 'Rock.Jobs.DataAutomation')
BEGIN
INSERT INTO [ServiceJob] (
[IsSystem]
,[IsActive]
,[Name]
,[Description]
,[Class]
,[CronExpression]
,[NotificationStatus]
,[Guid] )
VALUES (
0
,1
,'Data Automation'
,'Updates person/family information based on data automation settings.'
,'Rock.Jobs.DataAutomation'
,'0 0 4 ? * TUE *'
,1
,'059DC06D-39F1-4113-A6C3-94622A40F1CE');
END");
// JE: Makes the interaction channel for Short Links a well known channel, changes the name of the channel to something more readable
// and adds formatting to the lists and details that one would expect.
Sql(HotFixMigrationResource._047_DataAutomation_ShortLinkInteractionFix);
// SK: Fixes #2761 Mapped case worker correct address while printing Benevolence Request
Sql(HotFixMigrationResource._047_DataAutomation_FixBenevolenceCaseWorker);
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddGlobalAttribute(
"7525C4CB-EE6B-41D4-9B64-A08048D5A5C0",
string.Empty,
string.Empty,
"Same Site Cookie Setting",
"SameSite Setting",
@"This setting is to protect Rock from Cross Site Request Forgery attacks by restricting the websites that have access to the Rock cookie. If this setting is changed then it will be applied to each user as they log in. The ""Strict"" setting will keep the browser from sending the Rock cookie to any other domains, while the ""Lax"" setting provides a balance between security and usability. In most cases the ""Lax"" setting is appropriate.",
1033,
"Lax",
Rock.SystemGuid.Attribute.SAME_SITE_COOKIE_SETTING,
"core_SameSiteCookieSetting",
false
);
RockMigrationHelper.AddAttributeQualifier(Rock.SystemGuid.Attribute.SAME_SITE_COOKIE_SETTING, "values", "None,Lax,Strict", "BDDC44B7-DBBA-48BC-8EE5-D9D17D28FAB8");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddDefinedType("Global", "Liquid Templates", "Defined type to store various liquid templates for features in Rock.", "C3D44004-6951-44D9-8560-8567D705A48B");
RockMigrationHelper.AddDefinedTypeAttribute("C3D44004-6951-44D9-8560-8567D705A48B", "9C204CD0-1233-41C5-818A-C5DA439445AA", "MIME Type", "MimeType", "The MIME type that should be returned when using the template.", 1, "", "4FBF9D1A-06A4-4941-B9F4-85D2C4C12F2A");
RockMigrationHelper.AddDefinedTypeAttribute("C3D44004-6951-44D9-8560-8567D705A48B", "1D0D3794-C210-48A8-8C68-3FBEC08A6BA5", "Template", "Template", "", 2, "", "1E13E409-B568-45D0-B4B6-556C87D61232");
RockMigrationHelper.AddAttributeQualifier("1E13E409-B568-45D0-B4B6-556C87D61232", "editorMode", "3", "F28A4FD3-BFEE-4617-88A3-2132E71ADAD5");
RockMigrationHelper.AddAttributeQualifier("1E13E409-B568-45D0-B4B6-556C87D61232", "editorTheme", "0", "9E9DFC12-81CB-4C71-A7E8-9F74E29CEA46");
RockMigrationHelper.AddAttributeQualifier("1E13E409-B568-45D0-B4B6-556C87D61232", "editorHeight", "600", "6543D502-A6C5-4754-9755-AC6F88DF6CEA");
RockMigrationHelper.AddDefinedValue("C3D44004-6951-44D9-8560-8567D705A48B", "Default RSS Channel", "The default RSS channel template used by the RSS provider if one is not provided.", "D6149581-9EFC-40D8-BD38-E92C0717BEDA");
RockMigrationHelper.AddDefinedValueAttributeValue("D6149581-9EFC-40D8-BD38-E92C0717BEDA", "4FBF9D1A-06A4-4941-B9F4-85D2C4C12F2A", "application/rss+xml");
RockMigrationHelper.AddDefinedValueAttributeValue("D6149581-9EFC-40D8-BD38-E92C0717BEDA", "1E13E409-B568-45D0-B4B6-556C87D61232", @"{% assign timezone = 'Now' | Date:'zzz' | Replace:':','' -%}
<?xml version=""1.0"" encoding=""utf-8""?>
<rss version=""2.0"" xmlns:atom=""http://www.w3.org/2005/Atom"">
<channel>
<title>{{ Channel.Name }}</title>
<link>{{ Channel.ChannelUrl }}</link>
<description>{{ Channel.Description }}</description>
<language>en-us</language>
<ttl>{{ Channel.TimeToLive }}</ttl>
<lastBuildDate>{{ 'Now' | Date:'ddd, dd MMM yyyy HH:mm:00' }} {{ timezone }}</lastBuildDate>
{% for item in Items -%}
<item>
<title>{{ item.Title }}</title>
<guid>{{ Channel.ItemUrl }}?Item={{ item.Id }}</guid>
<link>{{ Channel.ItemUrl }}?Item={{ item.Id }}</link>
<pubDate>{{ item.StartDateTime | Date:'ddd, dd MMM yyyy HH:mm:00' }} {{ timezone }}</pubDate>
<description>{{ item.Content | Escape }}</description>
</item>
{% endfor -%}
</channel>
</rss>");
// update new location of statementgenerator installer
Sql("UPDATE [AttributeValue] set [Value] = 'http://storage.rockrms.com/externalapplications/sparkdevnetwork/statementgenerator/1.1.2/statementgenerator.exe' where [Guid] = '10BE2E03-7827-41B5-8CB2-DEB473EA107A'");
// update to computed column to handle ISO 8601 formatted values
Sql(@"
ALTER TABLE [dbo].[AttributeValue] DROP COLUMN [ValueAsDateTime]
ALTER TABLE [dbo].[AttributeValue] ADD [ValueAsDateTime] AS CASE WHEN [value] LIKE '____-__-__T__:__:__%' THEN CONVERT(datetime, CONVERT(datetimeoffset, [value])) ELSE CASE WHEN (LEN([value]) < 50 AND ISDATE( [value]) = 1) THEN CONVERT(datetime, [value]) ELSE NULL END END
");
}
/// <summary>
/// DL: Add Lava Engine Framework Setting
/// </summary>
private void UpLavaEngineSystemSettings()
{
RockMigrationHelper.AddGlobalAttribute(
Rock.SystemGuid.FieldType.SINGLE_SELECT,
string.Empty,
string.Empty,
"Lava Engine Liquid Framework",
"Lava Engine Framework",
@"The Liquid rendering framework used by the Lava Engine to parse and render templates. 'Default' ensures that the currently recommended framework is always used. Changes to this setting will not take effect until Rock is restarted.",
0,
"Default",
GLOBAL_LAVA_ENGINE_LIQUID_FRAMEWORK,
LAVA_ENGINE_LIQUID_FRAMEWORK,
false
);
RockMigrationHelper.AddAttributeQualifier(GLOBAL_LAVA_ENGINE_LIQUID_FRAMEWORK, "fieldtype", "ddl", "B4C0B3BC-3416-402F-8874-CD5D33CEB5AD");
RockMigrationHelper.AddAttributeQualifier(GLOBAL_LAVA_ENGINE_LIQUID_FRAMEWORK, "values", "Default^Default,RockLiquid^RockLiquid,DotLiquid^DotLiquid,Fluid^Fluid", "E11456FF-F57B-4964-877E-85468971C238");
}
public override void Up()
{
RockMigrationHelper.UpdateEntityType("Rock.Model.Workflow", "3540E9A7-FE30-43A9-8B0A-A372B63DFC93", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActivity", "2CB52ED0-CB06-4D62-9E2C-73B60AFA4C9F", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActionType", "23E3273A-B137-48A3-9AFF-C8DC832DDCA6", true, true);
RockMigrationHelper.UpdateEntityType("com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode", "CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", false, true);
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "E7EF5DBB-BE01-409A-ABAE-051D9918E3E0"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:Active
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "9C204CD0-1233-41C5-818A-C5DA439445AA", "GeneratedCode", "GeneratedCode", "Code that is generated from this action", 0, @"", "BE4F9C67-0FE9-4B85-B318-DC9E3FEDC5FF"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:GeneratedCode
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "9C204CD0-1233-41C5-818A-C5DA439445AA", "ServiceName", "ServiceName", "Service to generate the code for", 0, @"", "416D2781-3A19-438A-B676-412F631A55A7"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:ServiceName
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "836DFFD2-D0A9-4BE5-B30A-5827E407FC51"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:Order
RockMigrationHelper.UpdateWorkflowType(false, true, "Generate CDA Code", "", "54E7AF83-F2B8-4099-A1EC-B341B1F8739F", "Work", "fa fa-list-ol", 0, true, 0, "7B06A50F-1F78-4D7A-8232-E9044A327E77"); // Generate CDA Code
RockMigrationHelper.UpdateWorkflowTypeAttribute("7B06A50F-1F78-4D7A-8232-E9044A327E77", "9C204CD0-1233-41C5-818A-C5DA439445AA", "GeneratedCode", "GeneratedCode", "", 0, @"", "93EF2488-7F6F-487A-9D40-FD0906522F5E"); // Generate CDA Code:GeneratedCode
RockMigrationHelper.AddAttributeQualifier("93EF2488-7F6F-487A-9D40-FD0906522F5E", "ispassword", @"False", "2197044A-487D-46B3-91B6-FC525AF1FB50"); // Generate CDA Code:GeneratedCode:ispassword
RockMigrationHelper.UpdateWorkflowActivityType("7B06A50F-1F78-4D7A-8232-E9044A327E77", true, "Generate Code", "", true, 0, "3FA3C493-E079-4BC7-9C42-E76BA6CCD898"); // Generate CDA Code:Generate Code
RockMigrationHelper.UpdateWorkflowActionType("3FA3C493-E079-4BC7-9C42-E76BA6CCD898", "Generate Code", 0, "CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", true, false, "", "", 1, "", "52EA0B1C-9F3D-4C27-8475-48508AF311FA"); // Generate CDA Code:Generate Code:Generate Code
RockMigrationHelper.AddActionTypeAttributeValue("52EA0B1C-9F3D-4C27-8475-48508AF311FA", "416D2781-3A19-438A-B676-412F631A55A7", @"CDA"); // Generate CDA Code:Generate Code:Generate Code:ServiceName
RockMigrationHelper.AddActionTypeAttributeValue("52EA0B1C-9F3D-4C27-8475-48508AF311FA", "BE4F9C67-0FE9-4B85-B318-DC9E3FEDC5FF", @"{{Workflow.GeneratedCode}}"); // Generate CDA Code:Generate Code:Generate Code:GeneratedCode
RockMigrationHelper.AddActionTypeAttributeValue("52EA0B1C-9F3D-4C27-8475-48508AF311FA", "836DFFD2-D0A9-4BE5-B30A-5827E407FC51", @""); // Generate CDA Code:Generate Code:Generate Code:Order
RockMigrationHelper.AddActionTypeAttributeValue("52EA0B1C-9F3D-4C27-8475-48508AF311FA", "E7EF5DBB-BE01-409A-ABAE-051D9918E3E0", @"False"); // Generate CDA Code:Generate Code:Generate Code:Active
}
public override void Up()
{
RockMigrationHelper.UpdateFieldType("Range Slider", "", "Rock", "Rock.Field.Types.RangeSliderFieldType", "E239F99B-09EE-4AAE-8AA9-53E03EE45F19");
RockMigrationHelper.UpdateEntityType("Rock.Model.Workflow", "3540E9A7-FE30-43A9-8B0A-A372B63DFC93", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActivity", "2CB52ED0-CB06-4D62-9E2C-73B60AFA4C9F", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActionType", "23E3273A-B137-48A3-9AFF-C8DC832DDCA6", true, true);
RockMigrationHelper.UpdateEntityType("com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode", "CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", false, true);
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "E7EF5DBB-BE01-409A-ABAE-051D9918E3E0"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:Active
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "9C204CD0-1233-41C5-818A-C5DA439445AA", "GeneratedCode", "GeneratedCode", "Code that is generated from this action", 0, @"", "BE4F9C67-0FE9-4B85-B318-DC9E3FEDC5FF"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:GeneratedCode
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "9C204CD0-1233-41C5-818A-C5DA439445AA", "ServiceName", "ServiceName", "Service to generate the code for", 0, @"", "416D2781-3A19-438A-B676-412F631A55A7"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:ServiceName
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "836DFFD2-D0A9-4BE5-B30A-5827E407FC51"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:Order
RockMigrationHelper.UpdateWorkflowType(false, true, "Generate THIRST Code", "", "4D57D6C1-B4A1-4CC1-BD79-71EF8494ED70", "Work", "fa fa-list-ol", 0, true, 0, "41A69E9A-A7A2-4DED-B99C-73B1D093801D"); // Generate THIRST Code
RockMigrationHelper.UpdateWorkflowTypeAttribute("41A69E9A-A7A2-4DED-B99C-73B1D093801D", "9C204CD0-1233-41C5-818A-C5DA439445AA", "GeneratedCode", "GeneratedCode", "", 0, @"", "597B7E81-E000-404F-A340-78C06E485E50"); // Generate THIRST Code:GeneratedCode
RockMigrationHelper.AddAttributeQualifier("597B7E81-E000-404F-A340-78C06E485E50", "ispassword", @"False", "9EB808A8-FCF9-4D37-AD9B-64F94EE7CB80"); // Generate THIRST Code:GeneratedCode:ispassword
RockMigrationHelper.UpdateWorkflowActivityType("41A69E9A-A7A2-4DED-B99C-73B1D093801D", true, "Generate Code", "", true, 0, "CA5C23C7-2097-4E69-A613-5A9E1089441B"); // Generate THIRST Code:Generate Code
RockMigrationHelper.UpdateWorkflowActionType("CA5C23C7-2097-4E69-A613-5A9E1089441B", "Generate Code", 0, "CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", true, false, "", "", 1, "", "8958A5EE-3011-4D99-B515-F98CD6C58180"); // Generate THIRST Code:Generate Code:Generate Code
RockMigrationHelper.AddActionTypeAttributeValue("8958A5EE-3011-4D99-B515-F98CD6C58180", "416D2781-3A19-438A-B676-412F631A55A7", @"THIRST"); // Generate THIRST Code:Generate Code:Generate Code:ServiceName
RockMigrationHelper.AddActionTypeAttributeValue("8958A5EE-3011-4D99-B515-F98CD6C58180", "BE4F9C67-0FE9-4B85-B318-DC9E3FEDC5FF", @"{{Workflow.GeneratedCode}}"); // Generate THIRST Code:Generate Code:Generate Code:GeneratedCode
RockMigrationHelper.AddActionTypeAttributeValue("8958A5EE-3011-4D99-B515-F98CD6C58180", "836DFFD2-D0A9-4BE5-B30A-5827E407FC51", @""); // Generate THIRST Code:Generate Code:Generate Code:Order
RockMigrationHelper.AddActionTypeAttributeValue("8958A5EE-3011-4D99-B515-F98CD6C58180", "E7EF5DBB-BE01-409A-ABAE-051D9918E3E0", @"False"); // Generate THIRST Code:Generate Code:Generate Code:Active
}
public override void Up()
{
RockMigrationHelper.UpdateFieldType("Range Slider", "", "Rock", "Rock.Field.Types.RangeSliderFieldType", "E239F99B-09EE-4AAE-8AA9-53E03EE45F19");
RockMigrationHelper.UpdateEntityType("Rock.Model.Workflow", "3540E9A7-FE30-43A9-8B0A-A372B63DFC93", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActivity", "2CB52ED0-CB06-4D62-9E2C-73B60AFA4C9F", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActionType", "23E3273A-B137-48A3-9AFF-C8DC832DDCA6", true, true);
RockMigrationHelper.UpdateEntityType("com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode", "CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", false, true);
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "E7EF5DBB-BE01-409A-ABAE-051D9918E3E0"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:Active
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "9C204CD0-1233-41C5-818A-C5DA439445AA", "GeneratedCode", "GeneratedCode", "Code that is generated from this action", 0, @"", "BE4F9C67-0FE9-4B85-B318-DC9E3FEDC5FF"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:GeneratedCode
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "9C204CD0-1233-41C5-818A-C5DA439445AA", "ServiceName", "ServiceName", "Service to generate the code for", 0, @"", "416D2781-3A19-438A-B676-412F631A55A7"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:ServiceName
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "836DFFD2-D0A9-4BE5-B30A-5827E407FC51"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:Order
RockMigrationHelper.UpdateWorkflowType(false, true, "Generate PF Code", "", "4D57D6C1-B4A1-4CC1-BD79-71EF8494ED70", "Work", "fa fa-list-ol", 0, true, 0, "D25299B5-62C1-42B8-BAFF-D215877705D0"); // Generate PF Code
RockMigrationHelper.UpdateWorkflowTypeAttribute("D25299B5-62C1-42B8-BAFF-D215877705D0", "9C204CD0-1233-41C5-818A-C5DA439445AA", "GeneratedCode", "GeneratedCode", "", 0, @"", "DDE58601-6972-47A8-97C3-0737EA7AF430"); // Generate PF Code:GeneratedCode
RockMigrationHelper.AddAttributeQualifier("DDE58601-6972-47A8-97C3-0737EA7AF430", "ispassword", @"False", "FACD6D7B-171B-4404-9013-1C428AA4172E"); // Generate PF Code:GeneratedCode:ispassword
RockMigrationHelper.UpdateWorkflowActivityType("D25299B5-62C1-42B8-BAFF-D215877705D0", true, "Generate Code", "", true, 0, "62C80DFA-6C5B-45D6-933C-8492DAFDC001"); // Generate PF Code:Generate Code
RockMigrationHelper.UpdateWorkflowActionType("62C80DFA-6C5B-45D6-933C-8492DAFDC001", "Generate Code", 0, "CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", true, false, "", "", 1, "", "707B60B0-B351-4B95-B5C5-18598E22C544"); // Generate PF Code:Generate Code:Generate Code
RockMigrationHelper.AddActionTypeAttributeValue("707B60B0-B351-4B95-B5C5-18598E22C544", "416D2781-3A19-438A-B676-412F631A55A7", @"PF"); // Generate PF Code:Generate Code:Generate Code:ServiceName
RockMigrationHelper.AddActionTypeAttributeValue("707B60B0-B351-4B95-B5C5-18598E22C544", "BE4F9C67-0FE9-4B85-B318-DC9E3FEDC5FF", @"{{Workflow.GeneratedCode}}"); // Generate PF Code:Generate Code:Generate Code:GeneratedCode
RockMigrationHelper.AddActionTypeAttributeValue("707B60B0-B351-4B95-B5C5-18598E22C544", "836DFFD2-D0A9-4BE5-B30A-5827E407FC51", @""); // Generate PF Code:Generate Code:Generate Code:Order
RockMigrationHelper.AddActionTypeAttributeValue("707B60B0-B351-4B95-B5C5-18598E22C544", "E7EF5DBB-BE01-409A-ABAE-051D9918E3E0", @"False"); // Generate PF Code:Generate Code:Generate Code:Active
}
public override void Up()
{
RockMigrationHelper.UpdateFieldType("Range Slider", "", "Rock", "Rock.Field.Types.RangeSliderFieldType", "E239F99B-09EE-4AAE-8AA9-53E03EE45F19");
RockMigrationHelper.UpdateEntityType("Rock.Model.Workflow", "3540E9A7-FE30-43A9-8B0A-A372B63DFC93", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActivity", "2CB52ED0-CB06-4D62-9E2C-73B60AFA4C9F", true, true);
RockMigrationHelper.UpdateEntityType("Rock.Model.WorkflowActionType", "23E3273A-B137-48A3-9AFF-C8DC832DDCA6", true, true);
RockMigrationHelper.UpdateEntityType("com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode", "CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", false, true);
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Active", "Active", "Should Service be used?", 0, @"False", "E7EF5DBB-BE01-409A-ABAE-051D9918E3E0"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:Active
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "9C204CD0-1233-41C5-818A-C5DA439445AA", "GeneratedCode", "GeneratedCode", "Code that is generated from this action", 0, @"", "BE4F9C67-0FE9-4B85-B318-DC9E3FEDC5FF"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:GeneratedCode
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "9C204CD0-1233-41C5-818A-C5DA439445AA", "ServiceName", "ServiceName", "Service to generate the code for", 0, @"", "416D2781-3A19-438A-B676-412F631A55A7"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:ServiceName
RockMigrationHelper.UpdateWorkflowActionEntityAttribute("CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Order", "Order", "The order that this service should be used (priority)", 0, @"", "836DFFD2-D0A9-4BE5-B30A-5827E407FC51"); // com.reallifeministries.RockExtensions.Workflow.Action.GenerateAttendanceCode:Order
RockMigrationHelper.UpdateWorkflowType(false, true, "Generate RECOVERY Code", "", "4D57D6C1-B4A1-4CC1-BD79-71EF8494ED70", "Work", "fa fa-list-ol", 0, true, 0, "E5F05F80-12EF-4418-A9CA-43563FCEAEE2"); // Generate RECOVERY Code
RockMigrationHelper.UpdateWorkflowTypeAttribute("E5F05F80-12EF-4418-A9CA-43563FCEAEE2", "9C204CD0-1233-41C5-818A-C5DA439445AA", "GeneratedCode", "GeneratedCode", "", 0, @"", "B195D571-ECED-4621-96AF-0F98DC907C9D"); // Generate RECOVERY Code:GeneratedCode
RockMigrationHelper.AddAttributeQualifier("B195D571-ECED-4621-96AF-0F98DC907C9D", "ispassword", @"False", "F98F4B12-4885-4084-AAE3-88524ADE64AB"); // Generate RECOVERY Code:GeneratedCode:ispassword
RockMigrationHelper.UpdateWorkflowActivityType("E5F05F80-12EF-4418-A9CA-43563FCEAEE2", true, "Generate Code", "", true, 0, "FACB1155-4F72-4430-8199-FC93A803AD95"); // Generate RECOVERY Code:Generate Code
RockMigrationHelper.UpdateWorkflowActionType("FACB1155-4F72-4430-8199-FC93A803AD95", "Generate Code", 0, "CDA6C7A8-3870-4F4E-8371-6F5EC2F4CD78", true, false, "", "", 1, "", "E90B3E59-CB77-405F-A724-8F0DEDCB17D3"); // Generate RECOVERY Code:Generate Code:Generate Code
RockMigrationHelper.AddActionTypeAttributeValue("E90B3E59-CB77-405F-A724-8F0DEDCB17D3", "416D2781-3A19-438A-B676-412F631A55A7", @"RECOVERY"); // Generate RECOVERY Code:Generate Code:Generate Code:ServiceName
RockMigrationHelper.AddActionTypeAttributeValue("E90B3E59-CB77-405F-A724-8F0DEDCB17D3", "BE4F9C67-0FE9-4B85-B318-DC9E3FEDC5FF", @"{{Workflow.GeneratedCode}}"); // Generate RECOVERY Code:Generate Code:Generate Code:GeneratedCode
RockMigrationHelper.AddActionTypeAttributeValue("E90B3E59-CB77-405F-A724-8F0DEDCB17D3", "836DFFD2-D0A9-4BE5-B30A-5827E407FC51", @""); // Generate RECOVERY Code:Generate Code:Generate Code:Order
RockMigrationHelper.AddActionTypeAttributeValue("E90B3E59-CB77-405F-A724-8F0DEDCB17D3", "E7EF5DBB-BE01-409A-ABAE-051D9918E3E0", @"False"); // Generate RECOVERY Code:Generate Code:Generate Code:Active
}
public override void Up()
{
RockMigrationHelper.UpdateWorkflowTypeAttribute("88978527-0CA4-4C52-8FDA-CF915FAFA472", "309460EF-0CC5-41C6-9161-B3837BA3D374", "PF Prayer Category", "PFPrayerCategory", "", 7, @"17c3406f-788b-4932-810c-ab2ecc484506", "65FCFB06-FF75-45B5-A9D7-D62B68E78C79"); // Text Prayer Request:PF Prayer Category
RockMigrationHelper.UpdateWorkflowTypeAttribute("88978527-0CA4-4C52-8FDA-CF915FAFA472", "309460EF-0CC5-41C6-9161-B3837BA3D374", "CDA Prayer Category", "CDAPrayerCategory", "", 8, @"41d4ef74-af83-49ec-a98a-5fc14b9fa908", "3109787B-B7FE-4BAC-86FB-DC8523348253"); // Text Prayer Request:CDA Prayer Category
RockMigrationHelper.UpdateWorkflowTypeAttribute("88978527-0CA4-4C52-8FDA-CF915FAFA472", "309460EF-0CC5-41C6-9161-B3837BA3D374", "Prayer Category", "PrayerCategory", "", 9, @"", "07976A20-5EBF-4211-9C9F-E6AE732A3098"); // Text Prayer Request:Prayer Category
RockMigrationHelper.AddAttributeQualifier("65FCFB06-FF75-45B5-A9D7-D62B68E78C79", "qualifierColumn", @"", "3A523554-2FED-4219-A9F7-457029E9DAD0"); // Text Prayer Request:PF Prayer Category:qualifierColumn
RockMigrationHelper.AddAttributeQualifier("65FCFB06-FF75-45B5-A9D7-D62B68E78C79", "qualifierValue", @"", "6AA1E31F-E643-4819-918E-D7509160B0BB"); // Text Prayer Request:PF Prayer Category:qualifierValue
RockMigrationHelper.AddAttributeQualifier("3109787B-B7FE-4BAC-86FB-DC8523348253", "entityTypeName", @"Rock.Model.PrayerRequest", "F3CED749-5825-40D5-A6B9-876192B2628E"); // Text Prayer Request:CDA Prayer Category:entityTypeName
RockMigrationHelper.AddAttributeQualifier("3109787B-B7FE-4BAC-86FB-DC8523348253", "qualifierColumn", @"", "D209D7C2-A941-4A16-8702-0DCBAD93C447"); // Text Prayer Request:CDA Prayer Category:qualifierColumn
RockMigrationHelper.AddAttributeQualifier("3109787B-B7FE-4BAC-86FB-DC8523348253", "qualifierValue", @"", "4F0ECD00-6D66-4126-A7C0-C938BC642AE9"); // Text Prayer Request:CDA Prayer Category:qualifierValue
RockMigrationHelper.AddAttributeQualifier("07976A20-5EBF-4211-9C9F-E6AE732A3098", "entityTypeName", @"Rock.Model.PrayerRequest", "7596AF7B-7E85-48AC-8B22-9AFCA58667DA"); // Text Prayer Request:Prayer Category:entityTypeName
RockMigrationHelper.AddAttributeQualifier("07976A20-5EBF-4211-9C9F-E6AE732A3098", "qualifierColumn", @"", "C2C7BD60-F140-4BDD-9ECA-29E4959805B3"); // Text Prayer Request:Prayer Category:qualifierColumn
RockMigrationHelper.AddAttributeQualifier("07976A20-5EBF-4211-9C9F-E6AE732A3098", "qualifierValue", @"", "74BAE1EC-ABC7-4372-8DC0-0D3749AE13EB"); // Text Prayer Request:Prayer Category:qualifierValue
RockMigrationHelper.AddActionTypeAttributeValue("8520DE5F-F4F2-41B7-9DAF-8B13FDF03032", "D7EAA859-F500-4521-9523-488B12EAA7D2", @"False"); // Text Prayer Request:Submit Prayer Request:Set Prayer Category if PF:Active
RockMigrationHelper.AddActionTypeAttributeValue("8520DE5F-F4F2-41B7-9DAF-8B13FDF03032", "44A0B977-4730-4519-8FF6-B0A01A95B212", @"07976a20-5ebf-4211-9c9f-e6ae732a3098"); // Text Prayer Request:Submit Prayer Request:Set Prayer Category if PF:Attribute
RockMigrationHelper.AddActionTypeAttributeValue("8520DE5F-F4F2-41B7-9DAF-8B13FDF03032", "57093B41-50ED-48E5-B72B-8829E62704C8", @""); // Text Prayer Request:Submit Prayer Request:Set Prayer Category if PF:Order
RockMigrationHelper.AddActionTypeAttributeValue("8520DE5F-F4F2-41B7-9DAF-8B13FDF03032", "E5272B11-A2B8-49DC-860D-8D574E2BC15C", @"65fcfb06-ff75-45b5-a9d7-d62b68e78c79"); // Text Prayer Request:Submit Prayer Request:Set Prayer Category if PF:Text Value|Attribute Value
RockMigrationHelper.AddActionTypeAttributeValue("E43F12B1-DB12-476C-8337-B20EA7267874", "D7EAA859-F500-4521-9523-488B12EAA7D2", @"False"); // Text Prayer Request:Submit Prayer Request:Set Prayer Category If CDA:Active
RockMigrationHelper.AddActionTypeAttributeValue("E43F12B1-DB12-476C-8337-B20EA7267874", "44A0B977-4730-4519-8FF6-B0A01A95B212", @"07976a20-5ebf-4211-9c9f-e6ae732a3098"); // Text Prayer Request:Submit Prayer Request:Set Prayer Category If CDA:Attribute
RockMigrationHelper.AddActionTypeAttributeValue("E43F12B1-DB12-476C-8337-B20EA7267874", "57093B41-50ED-48E5-B72B-8829E62704C8", @""); // Text Prayer Request:Submit Prayer Request:Set Prayer Category If CDA:Order
RockMigrationHelper.AddActionTypeAttributeValue("E43F12B1-DB12-476C-8337-B20EA7267874", "E5272B11-A2B8-49DC-860D-8D574E2BC15C", @"3109787b-b7fe-4bac-86fb-dc8523348253"); // Text Prayer Request:Submit Prayer Request:Set Prayer Category If CDA:Text Value|Attribute Value
}
public override void Up()
{
RockMigrationHelper.AddDefinedType("Tools", "Distance Mappable Entities", "Endpoint for getting distance for various entities. Route is /api/mapping/distance/{{DefinedValueId}}/{{Address}}", Constants.UniversalDefinedTypeGuid, @"");
RockMigrationHelper.AddDefinedTypeAttribute("7F70ABE9-1705-4DED-BABE-6D720EC52914", "7525C4CB-EE6B-41D4-9B64-A08048D5A5C0", "Entity Type", "EntityType", "", 1248, "", "A4E5D4F4-580D-459E-8C83-C6A92B47396A");
RockMigrationHelper.AddDefinedTypeAttribute("7F70ABE9-1705-4DED-BABE-6D720EC52914", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Entity Id", "EntityId", "The id of the entity (Group Type Id, Parent Group Id or Attribute Id) to calculate distances from.", 1249, "", "1BC6FD9F-DDE2-4083-9539-7821C728014A");
RockMigrationHelper.AddAttributeQualifier("1BC6FD9F-DDE2-4083-9539-7821C728014A", "ispassword", "False", "FDCC5DBA-F3A9-4896-BB35-F93B630612BB");
RockMigrationHelper.AddAttributeQualifier("1BC6FD9F-DDE2-4083-9539-7821C728014A", "maxcharacters", "", "1257C2FD-BB2B-4BBE-992E-54BFCB829FF4");
RockMigrationHelper.AddAttributeQualifier("1BC6FD9F-DDE2-4083-9539-7821C728014A", "showcountdown", "False", "7E762A8E-39D4-4EF2-8092-8C5407127BEA");
RockMigrationHelper.AddAttributeQualifier("A4E5D4F4-580D-459E-8C83-C6A92B47396A", "fieldtype", "ddl", "8AE3FF18-6B1E-4096-8494-3B798AAA471B");
RockMigrationHelper.AddAttributeQualifier("A4E5D4F4-580D-459E-8C83-C6A92B47396A", "repeatColumns", "", "4D143B57-93D5-47EE-9697-2F26879DBF73");
RockMigrationHelper.AddAttributeQualifier("A4E5D4F4-580D-459E-8C83-C6A92B47396A", "values", "GroupType^Group Type,ParentGroup^Child Groups of Group,Campus^Campus,Attribute^Address Attribute", "97BB896B-A83D-4F96-8677-4FCD2609F1D5");
RockMigrationHelper.UpdateDefinedValue("7F70ABE9-1705-4DED-BABE-6D720EC52914", "Blankenbaker Home Groups", "", "2E216362-0B05-4CE7-BBA8-E2C3DCAAEB07", false);
RockMigrationHelper.UpdateDefinedValue("7F70ABE9-1705-4DED-BABE-6D720EC52914", "Campus", "", "EB39F521-F9AA-4812-BA8F-102C029C8516", false);
RockMigrationHelper.UpdateDefinedValue("7F70ABE9-1705-4DED-BABE-6D720EC52914", "Content Channel Attributes", "", "F4D7D410-5096-460F-B740-4F6E0673CE16", false);
RockMigrationHelper.UpdateDefinedValue("7F70ABE9-1705-4DED-BABE-6D720EC52914", "Home Groups", "", "7E83A576-07FC-49EA-98BC-73C123D24DD8", false);
RockMigrationHelper.AddDefinedValueAttributeValue("2E216362-0B05-4CE7-BBA8-E2C3DCAAEB07", "1BC6FD9F-DDE2-4083-9539-7821C728014A", @"820057");
RockMigrationHelper.AddDefinedValueAttributeValue("2E216362-0B05-4CE7-BBA8-E2C3DCAAEB07", "A4E5D4F4-580D-459E-8C83-C6A92B47396A", @"ParentGroup");
RockMigrationHelper.AddDefinedValueAttributeValue("7E83A576-07FC-49EA-98BC-73C123D24DD8", "1BC6FD9F-DDE2-4083-9539-7821C728014A", @"60");
RockMigrationHelper.AddDefinedValueAttributeValue("7E83A576-07FC-49EA-98BC-73C123D24DD8", "A4E5D4F4-580D-459E-8C83-C6A92B47396A", @"GroupType");
RockMigrationHelper.AddDefinedValueAttributeValue("EB39F521-F9AA-4812-BA8F-102C029C8516", "A4E5D4F4-580D-459E-8C83-C6A92B47396A", @"Campus");
RockMigrationHelper.AddDefinedValueAttributeValue("F4D7D410-5096-460F-B740-4F6E0673CE16", "1BC6FD9F-DDE2-4083-9539-7821C728014A", @"89281");
RockMigrationHelper.AddDefinedValueAttributeValue("F4D7D410-5096-460F-B740-4F6E0673CE16", "A4E5D4F4-580D-459E-8C83-C6A92B47396A", @"Attribute");
}