########################################################################
# FULL HTML PREVIEW
########################################################################

$catalogId=full_html_preview_content
$catalogName=Full HTML Preview Site
$catalogVersionStaged=Staged
$catalogVersionOnline=Online
$contentCV=catalogVersion(catalog(id[default=$catalogId]),version[default=$catalogVersionOnline])[default=$catalogId:$catalogVersionOnline]
$readPrincipals=cmsmanagergroup,econtentgroup
$writePrincipals=cmsmanagergroup,econtentgroup
$writePrincipals=cmsmanagergroup,econtentgroup

$allowedTypes=DividerCMSComponent,ColumnDefinitionCMSComponent

# Page Templates
INSERT_UPDATE PageTemplate;uid[unique=true];active;name;frontendTemplateName;$contentCV[unique=true,virtual=true];
;master_full_html_preview_template;true;Master Main Template;/pages/master/full_html_master_preview_template.jsp;

# Default Product Page
INSERT_UPDATE ContentPage;$contentCV[unique=true];uid[unique=true];name;masterTemplate(uid,$contentCV);defaultPage;approvalStatus(code);label;
;;full_html_master_preview_page;Full HTML Master Preview Page;master_full_html_preview_template;true;approved;RegionalMaster

########################################################################
# TAB 1 - Content Slots, Content Slots Names & Components
########################################################################

# ContentSlotName
INSERT_UPDATE ContentSlotName;name[unique=true];template(uid,$contentCV)[unique=true];validComponentTypes(code)
;csn_tab_7;master_full_html_preview_template;$allowedTypes
;csn_tab_8;master_full_html_preview_template;$allowedTypes
;csn_tab_9;master_full_html_preview_template;$allowedTypes
;csn_tab_10;master_full_html_preview_template;$allowedTypes
;csn_tab_11;master_full_html_preview_template;$allowedTypes

# Create Content Slot
INSERT_UPDATE ContentSlot;$contentCV[unique=true];uid[unique=true];name;active;cmsComponents(uid,$contentCV);
;;cs_tab_7;Tab 7 Slot;true;marketDistributionsVersionComponent;
;;cs_tab_8;Tab 8 Slot;true;masterNameComponent,blueDividerComponent,masterTitleComponent,blueDividerComponent,masterCartalogVersionComponent,blueDividerComponent,masterMarketDescriptionComponent,blueDividerComponent,masterProductFeaturesComponent,blueDividerComponent,masterAdditionalComponenent;
;;cs_tab_9;Tab 9 Slot;true;masterKeywordsComponent,blueDividerComponent
;;cs_tab_10;Tab 10 Slot;true;masterApprovalInfoComponent,blueDividerComponent,masterCompletenesComponent,masterCoverageErrorMessagesComponent,blueDividerComponent,masterQualityComponent,masterQualityErrorMessagesComponent,blueDividerComponent,masterCarsInformationComponent
;;cs_tab_11;Tab 11 Slot;true;masterFPCChildsComponent

# Bind Content Slots to Page Templates
INSERT_UPDATE ContentSlotForTemplate;$contentCV[unique=true];uid[unique=true];position[unique=true];pageTemplate(uid,$contentCV)[unique=true];contentSlot(uid,$contentCV)[unique=true];allowOverwrite;
;;csfpt_tab7;csn_tab_7;master_full_html_preview_template;cs_tab_7;true;
;;csfpt_tab8;csn_tab_8;master_full_html_preview_template;cs_tab_8;true;
;;csfpt_tab9;csn_tab_9;master_full_html_preview_template;cs_tab_9;true;
;;csfpt_tab10;csn_tab_10;master_full_html_preview_template;cs_tab_10;true;
;;csfpt_tab11;csn_tab_11;master_full_html_preview_template;cs_tab_11;true;

INSERT DateFormatter;&ItemDF;pattern
;dateFormatter;"yyyy-MM-dd";

INSERT DecimalFormatter; &ItemP; decimalSeparator; pattern
;percentageFormatter;".";"###%";

INSERT ColumnDefinition; &ItemCD; attribute; columnName; formatter(&ItemP)
; completenessCD;coverageInformation.coverage;Overall Completeness %;percentageFormatter

INSERT ColumnDefinition;&ItemCD;attribute;columnName;formatter(&ItemDF)
;masterNameCD;name;Master Name;
;masterIdCD;id;Master Id;
;masterCartalogVersionCD;catalogVersion;Master Catalog Version;
;masterReferenceFPCCD;referenceFPC;Reference FPC;
;masterInitiativeNameCD;initiativeNameLoc;Initiative Name;
;masterfirstSosCD;firstSos;First SOS;dateFormatter
;masterProductTitleSuperLongCD;productTitleSuperLong;Product Title Super Long;
;masterProductTitleLongCD;productTitleLong;Product Title Long;
;masterProductTitleShortCD;productTitleShort;Product Title Short;
;masterproductMarketSubbrandCD;productMarketSubbrand;Product Market Subbrand;
;masterProductDescriptionCD;productDescription;Product Description;
;masterProductFeature1CD;productFeature1;Product Feature 1;
;masterProductFeature2CD;productFeature2;Product Feature 2;
;masterProductFeature3CD;productFeature3;Product Feature 3;
;masterProductFeature4CD;productFeature4;Product Feature 4;
;masterProductFeature5CD;productFeature5;Product Feature 5;
;masterProductFeature6CD;productFeature6;Product Feature 6;
;masterProductFeature7CD;productFeature7;Product Feature 7;
;masterProductFeature8CD;productFeature8;Product Feature 8;
;masterProductSearchCD;productSearch;Product Search;
;masterProductIndicationsCD;productIndications;Product Indications;
;masterProductDirectionsCD;productDirections;Product Directions;
;masterProductFlavorScentCD;productFlavorScent;Product FlavorScent;
;masterProductHairTypeCD;productHairType;Product Hair Type;
;masterProductSkinTypeCD;productSkinType;Product Skin Type;
;masterKeywords1CD;keywords1;TagWords 1;
;masterKeywords2CD;keywords2;TagWords 2;
;masterKeywords3CD;keywords3;TagWords 3;
;approvalStatusCD;approvalStatus.code;Current Approval Status;
;lastApprovalDateCD;lastApprovalTimestamp;Last Approval Date;dateFormatter;
;lastApproverCD;lastApprovalUser.userEmail;Last Approver;
;masterBCOCD;masterBCO;Master BCO;
;masterBCCCD;masterBCC;Master BCC;
;childsCD;childs;Childs;

INSERT BeanshellColumnDefinition;&ItemCD;expression;columnName;
;qualityCD;"
product = getItem();

if(product.getDomainBasedCoverageInformations() != null){
    for(domainBasedCovInf : product.getDomainBasedCoverageInformations()){
        if(""QUALITY"".equalsIgnoreCase(domainBasedCovInf.getDomain())){
            df = new java.text.DecimalFormat(""###%"");
            symbols = new java.text.DecimalFormatSymbols();
            symbols.setDecimalSeparator(""."".charAt(0));
            df.setDecimalFormatSymbols(symbols);
            return df.format(domainBasedCovInf.getCoverage());
        }
    }
}
return ""N/A"";
";Quality %;

INSERT EmptyColumnDefinition;&columnId;
;keyColumnQualityMessages;
;valueColumnQualityMessages;

INSERT MapColumnDefinition;&Item;keyColumnDefinition(&columnId);valueColumnDefinition(&columnId);attribute;columnName;mapEntrySeparator;keyValueSeparator;
;qualityCoverageMsgCD;keyColumnQualityMessages;valueColumnQualityMessages;errorMessages;;<br/>;;

INSERT ColumnDefinition;&Item;attribute;columnName
;pgCoverageInformationDomainCD;domain;

INSERT FilteredListColumnDefinition;&ItemCD;itemValue(&Item);listSeparator;attribute;columnName;filterItemValueDefinition(&Item);filterValue
;qualityCoverageInfoCD;qualityCoverageMsgCD;" <br/>";domainBasedCoverageInformations;Content To Correct;pgCoverageInformationDomainCD;Quality

INSERT EmptyColumnDefinition;&columnId;
;keyColumn;
;valueColumn;

INSERT MapColumnDefinition;&ItemCD;keyColumnDefinition(&columnId);valueColumnDefinition(&columnId);attribute;columnName;mapEntrySeparator;keyValueSeparator;
;coverageMsgCD;keyColumn;valueColumn;coverageInformation.errorMessages;Gaps To Correct;<br/>;;

INSERT_UPDATE CMSColumnDefinition;&Item;columnDefinition(&ItemCD)[unique=true];indexColumnStyle(code)[unique=true];valueColor;
;coverageMsg;coverageMsgCD;_1;red;

INSERT_UPDATE CMSColumnDefinition;&Item;columnDefinition(&ItemCD)[unique=true];indexColumnStyle(code)[unique=true];
;masterNameCMSCD;masterNameCD;_1
;masterIdCMSCD;masterIdCD;_1
;masterCartalogVersionCMSCD;masterCartalogVersionCD;_1
;referenceFPCCMSCD;masterReferenceFPCCD;_1
;initiativeNameLocCMSCD;masterInitiativeNameCD;_1
;masterfirstSosCMSCD;masterfirstSosCD;_1
;masterProductTitleSuperLongCMSCD;masterProductTitleSuperLongCD;_1
;masterProductTitleLongCMSCD;masterProductTitleLongCD;_1
;masterProductTitleShortCMSCD;masterProductTitleShortCD;_1
;masterproductMarketSubbrandCMSCD;masterproductMarketSubbrandCD;_1
;masterProductDescriptionCMSCD;masterProductDescriptionCD;_1
;masterProductFeature1CMSCD;masterProductFeature1CD;_1
;masterProductFeature2CMSCD;masterProductFeature2CD;_1
;masterProductFeature3CMSCD;masterProductFeature3CD;_1
;masterProductFeature4CMSCD;masterProductFeature4CD;_1
;masterProductFeature5CMSCD;masterProductFeature5CD;_1
;masterProductFeature6CMSCD;masterProductFeature6CD;_1
;masterProductFeature7CMSCD;masterProductFeature7CD;_1
;masterProductFeature8CMSCD;masterProductFeature8CD;_1
;masterProductSearchCMSCD;masterProductSearchCD;_1
;masterProductIndicationsCMSCD;masterProductIndicationsCD;_1
;masterProductDirectionsCMSCD;masterProductDirectionsCD;_1
;masterProductFlavorScentCMSCD;masterProductFlavorScentCD;_1
;masterProductHairTypeCMSCD;masterProductHairTypeCD;_1
;masterProductSkinTypeCMSCD;masterProductSkinTypeCD;_1
;masterKeywords1CMSCD;masterKeywords1CD;_3
;masterKeywords2CMSCD;masterKeywords2CD;_3
;masterKeywords3CMSCD;masterKeywords3CD;_3
;approvalStatusCMSCD;approvalStatusCD;_3
;lastApprovalDateCMSCD;lastApprovalDateCD;_3
;lastApproverCMSCD;lastApproverCD;_3
;completeness;completenessCD; _3
;qualityCmsCD;qualityCD;_3;
;qualityCoverageInfo;qualityCoverageInfoCD;_1;
;masterBCOCMSCD;masterBCOCD;_3;
;masterBCCCMSCD;masterBCCCD;_3;
;childsCmsCD;childsCD;_3;


INSERT_UPDATE ColumnDefinitionCMSComponent;$contentCV[unique=true];uid[unique=true];name;displayLabel;cmsColumnDefinitions(&Item);itemName
;;masterNameComponent;Master Name Component;;masterIdCMSCD,masterNameCMSCD;regionalmaster
;;masterCartalogVersionComponent;Master Cartalog Version Component;;referenceFPCCMSCD,initiativeNameLocCMSCD,masterfirstSosCMSCD,masterBCOCMSCD,masterBCCCMSCD;regionalmaster
;;masterTitleComponent;Master Title Component;;masterProductTitleSuperLongCMSCD,masterProductTitleLongCMSCD,masterProductTitleShortCMSCD;regionalmaster
;;masterMarketDescriptionComponent;Master Title Component;;masterproductMarketSubbrandCMSCD,masterProductDescriptionCMSCD;regionalmaster
;;masterProductFeaturesComponent;Master Product Features Component;;masterProductFeature1CMSCD,masterProductFeature2CMSCD,masterProductFeature3CMSCD,masterProductFeature4CMSCD,masterProductFeature5CMSCD,masterProductFeature6CMSCD,masterProductFeature7CMSCD,masterProductFeature8CMSCD;regionalmaster
;;masterAdditionalComponenent;Master Additional Attributes Component;;masterProductSearchCMSCD,masterProductIndicationsCMSCD,masterProductDirectionsCMSCD,masterProductFlavorScentCMSCD,masterProductHairTypeCMSCD,masterProductSkinTypeCMSCD;regionalmaster
;;masterKeywordsComponent;Master Keywords Component;;masterKeywords1CMSCD,masterKeywords2CMSCD,masterKeywords3CMSCD;regionalmaster
;;masterApprovalInfoComponent;Approval Information Component;;approvalStatusCMSCD,lastApprovalDateCMSCD,lastApproverCMSCD;regionalmaster
;;masterCoverageErrorMessagesComponent;Coverage Error Messages Component;;coverageMsg;regionalmaster
;;masterCompletenesComponent;Completeness Information Component;;completeness;regionalmaster
;;masterQualityComponent;Quality;QUALITY;qualityCmsCD;regionalmaster
;;masterQualityErrorMessagesComponent;Content to correct;;qualityCoverageInfo;regionalmaster
;;masterFPCChildsComponent;Childs;CHILDS;childsCmsCD;regionalmaster

# Market Distributions

INSERT ColumnDefinition;&ItemCD;attribute;columnName;
;marketDistributionVersionCD;version;Market Distribution Version;

INSERT OrderedListColumnDefinition;&ItemLCD;itemValue(&ItemCD);listSeparator;attribute;columnName;order(code)
;marketDistributionVersionOLCD;marketDistributionVersionCD;" <br/>";marketDistributions;Market Distribution Version;ASC

INSERT_UPDATE CMSColumnDefinition;&Item;columnDefinition(&ItemLCD)[unique=true];indexColumnStyle(code)[unique=true];
;marketDistributionVersionCMSCD;marketDistributionVersionOLCD;_1

INSERT_UPDATE ColumnDefinitionCMSComponent;$contentCV[unique=true];uid[unique=true];name;displayLabel;cmsColumnDefinitions(&Item);itemName
;;marketDistributionsVersionComponent;Master Market Distributions Attributes Component;;marketDistributionVersionCMSCD;regionalmaster

INSERT BeanshellColumnDefinition;&ItemCD;expression;
;messagesCD;"
import java.lang.StringBuilder;
import java.util.Map.Entry;
import java.util.Map;
import com.google.common.base.Joiner;
import java.util.List;
import java.util.ArrayList;
import org.apache.commons.lang.StringUtils;

messages = getItem().getMessages();

TreeMap sortedMap = new TreeMap();
for (Entry message : messages.entrySet())
{
    if (message.getKey().equals(""Title Super Long""))
	{
		sortedMap.put(1, message.getKey());
	}
	else if (message.getKey().equals(""Title Long""))
	{
		sortedMap.put(2, message.getKey());
	}
	else if (message.getKey().equals(""Title Short""))
	{
		sortedMap.put(3, message.getKey());
	}
	else if (message.getKey().equals(""Title Super Short""))
	{
		sortedMap.put(4, message.getKey());
	}
	else if (message.getKey().equals(""Product Description""))
	{
		sortedMap.put(5, message.getKey());
	}
	else if (message.getKey().equals(""Secondary Images""))
	{
		sortedMap.put(6, message.getKey());
	}
}

List resultList = new ArrayList();
for (int i=1; i<=messages.size(); i++)
{
	String message = messages.get(sortedMap.get(i));

	if (StringUtils.isNotBlank(message))
	{
		if(message.equals(""Fail""))
		{
			resultList.add(""<span class='clavisMessages'>""+sortedMap.get(i)+"":</span> <span class='clavisNotPassedMessage'><b>""+message+""</b></span>"");
		}
		else if (message.equals(""Pass""))
		{
			resultList.add(""<span class='clavisMessages'>""+sortedMap.get(i)+"":</span> <span class='clavisPassedMessage'><b>""+message+""</b></span>"");
		}
		else
		{
			resultList.add(""<span class='clavisMessages'>""+sortedMap.get(i)+"":</span> <span>""+message+""</span>"");
		}
	}
}

return Joiner.on(""<br/>"").skipNulls().join(resultList);
";

INSERT ColumnDefinition;&ItemCD;attribute;columnName;
;carsCategoryCD;clavisCarsCategory.code;CARS category

INSERT RegexReplacementDefinition;&ident;regex;replacement;
;regExNotTrackedInClavis;^\z;"<span class='clavisNotPassedMessage'><b>Category not tracked in Clavis</b></span>";

INSERT RegexColumnDefinition;&ItemRCD;columnName;value(&ItemCD);regexReplacementDefs(&ident)
;carsCategoryRegExCD;CARS category;carsCategoryCD;regExNotTrackedInClavis

INSERT ColumnDefinition;&ItemCD;attribute;columnName;
;keywordsCD;clavisCarsCategory.keywords;Keywords used

INSERT ColumnDefinition;&columnIdentity;attribute;columnName;formatter(&formatId);
;pgCoverageInformationDomainCD;domain;;

INSERT FilteredListColumnDefinition;&ItemLCD;itemValue(&ItemCD);listSeparator;attribute;columnName;filterItemValueDefinition(&columnIdentity);filterValue
;domainCoverageInfoCD;messagesCD;" <br/>";domainBasedCoverageInformations;Validations;pgCoverageInformationDomainCD;CARS

INSERT_UPDATE CMSColumnDefinition;&Item;columnDefinition(&ItemLCD)[unique=true];indexColumnStyle(code)[unique=true];
;domainCoverageInfo;domainCoverageInfoCD;_2;

INSERT_UPDATE CMSColumnDefinition;&Item;columnDefinition(&ItemRCD)[unique=true];indexColumnStyle(code)[unique=true];
;carsCategory;carsCategoryRegExCD;_1;

INSERT_UPDATE CMSColumnDefinition;&Item;columnDefinition(&ItemCD)[unique=true];indexColumnStyle(code)[unique=true];
;carsCategoryKeywords;keywordsCD;_1;

INSERT_UPDATE ColumnDefinitionCMSComponent;$contentCV[unique=true];uid[unique=true];name;displayLabel;cmsColumnDefinitions(&Item);itemName
;;masterCarsInformationComponent;CARS Information;CARS;carsCategory,carsCategoryKeywords,domainCoverageInfo;regionalmaster