public HomeNavigationConfiguration(NavigationItem navItem)
{
HasName(navItem.Name);
HasLabel(navItem.Label);
Layout.HasController <HomeNavigationLayoutController>();
HasWidget(new WelcomeTextnImageWidgetConfiguration(WidgetItems.WidgetWelcomeTextnImage()));
HasWidget(new CombinationChartWidgetConfiguration(WidgetItems.HomeTrendChart()));
HasWidget(new Top10CompaniesTableConfiguration(WidgetItems.Top10CompanyTables()));
HasWidget(new Top10IntPrdTableConfiguration(WidgetItems.Top10IntPrdTable()));
this.HasExportController <NavExportController>();
ExtendedProperties.Add("ExportFileName").WithValue(navItem.Label + "_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
private string GetNameColumnText(WidgetItem widgetItem)
{
if (widgetItem.Name == WidgetItems.CompanyExpCollapseTableWidget().Name)
{
return("Company");
}
if (widgetItem.Name == WidgetItems.IntlProductsAllLocByProdExpCollapseWidget().Name || widgetItem.Name == WidgetItems.IntlProductsAllProdByLocExpCollapseWidget().Name)
{
return("Intl Product");
}
if (widgetItem.Name == WidgetItems.ProductsAllLocByProdExpCollapseWidget().Name || widgetItem.Name == WidgetItems.ProductsAllProdByLocExpCollapseWidget().Name)
{
return("Product");
}
return("Name");
}
public CombinationChartWidgetConfiguration(WidgetItem widgetItem)
{
HasName(widgetItem.Name);
View.HasConfig("")
.HasController <CombiChartWidgetController>();
View.DataFlow.AddSource <CubeDataSourceBase>()
.WithModule(widgetItem.ViewId)
.Transform().By <CombinationChartTransformer>()
.HasProperty(t => t.WidgetName).WithValue(widgetItem.Name)
.HasProperty(t => t.RegionOrCluster).WithValue(p => p["@@" + ParameterList.RegionOrCluster + "_text"])
.HasProperty(t => t.country).WithValue(p => p["@@" + ParameterList.Country + "_text"])
.HasProperty(t => t.KPI).WithValue(p => p["@@KPI_text"])
.HasProperty(t => t.PeriodType).WithValue(p => p["@@" + ParameterList.TimePeriod + "_text"])
.HasProperty(t => t.RevertAxis).WithValue(p => p["@@TimePeriod_text"] == "MAT" || p["@@TimePeriod_text"] == "YTD")
.HasProperty(t => t.UnitValue).WithValue(p => p["@@" + ParameterList.UnitOrValue + "_text"])
//.HasProperty(t => t.StartDate).WithValue(p => p["@@" + ParameterList.StartDate + "_text"])
.HasProperty(t => t.EndDate).WithValue(p => p["@@" + ParameterList.EndDate + "_text"])
.HasProperty(t => t.UncheckedItems).WithValue(p => widgetItem.Name == WidgetItems.AllRegionCombinationChart().Name ? p[ParameterList.RegionUncheckedItems] : p[ParameterList.KsaUncheckedItems]);
Export.HasConfig("HomeTrend" /*GetExportConfig*/).HasController <HomeExportController>()//p=>p["@@"+ParameterList.KPI+"_text"
.DataFlow.AddSource <CubeDataSourceBase>().WithModule(widgetItem.ViewId)
.Transform().By <CubeDataToXTableTrendTransformer>()
//.HasProperty(t => t.KPI).WithValue(p => p["@@UnitOrValue_text"])
//.HasProperty(t => t.PeriodType).WithValue(p => p["@@" + ParameterList.TimePeriod + "_text"])
//.HasProperty(t => t.EndDate).WithValue(p => p["@@" + ParameterList.EndDate + "_text"])
.Transform().By <ExportModelTransformer>()
.HasProperty(t => t.NavigationNameString).WithValue(p => p.CurrentNavigationLabel())
.HasProperty(t => t.RegionOrCluster).WithValue(p => p["@@" + ParameterList.RegionOrCluster + "_text"])
.HasProperty(t => t.Country).WithValue(p => p["@@" + ParameterList.Country + "_text"])
.HasProperty(t => t.Segment).WithValue(p => p["@@" + ParameterList.Segment + "_text"])
//.HasProperty(t => t.Forms).WithValue(p => p["@@" + ParameterList.Form + "_text"])
.HasProperty(t => t.UnitValue).WithValue(p => p["@@" + ParameterList.UnitOrValue + "_text"])
.HasProperty(t => t.PeriodType).WithValue(p => p["@@" + ParameterList.TimePeriod + "_text"])
.HasProperty(t => t.EndDate).WithValue(p => p["@@" + ParameterList.EndDate + "_text"]);
//.HasProperty(t => t.KPI).WithValue(p => p["@@KPI_text"])
//.HasProperty(t => t.RevertAxis).WithValue(p => p["@@TimePeriod_text"] == "MAT" || p["@@TimePeriod_text"] == "YTD")
//.HasProperty(t => t.StartDate).WithValue(p => p["@@" + ParameterList.StartDate + "_text"])
//.HasProperty(t => t.UncheckedItems).WithValue(p => widgetItem.Name == WidgetItems.AllRegionCombinationChart().Name ? p[ParameterList.RegionUncheckedItems] : p[ParameterList.KsaUncheckedItems]);
HasParameterDependency.On(widgetItem.HasParamDependency);
}
public TrendTableWidgetConfiguration(WidgetItem widgetItem)
{
HasName(widgetItem.Name);
View.HasConfig(p => p)
.HasController <TrendTableWidgetController>();
View.DataFlow.AddSource <CubeDataSourceBase>()//DummyTableDataSource
.WithModule(widgetItem.ViewId)
.Transform().By <TableChartTransformer>()
.HasProperty(t => t.ShowFullLength).WithValue(true)
.HasProperty(t => t.NavigationName).WithValue(p => p.CurrentNavigationName())
.HasProperty(t => t.MeasureType).WithValue(p => p["@@KPI_text"])
.HasProperty(t => t.PeriodType).WithValue(p => p["@@" + ParameterList.TimePeriod + "_text"])
.HasProperty(t => t.Date).WithValue(p => p["@@" + ParameterList.EndDate + "_text"])
.HasProperty(t => t.UncheckedItems).WithValue(p => widgetItem.Name == WidgetItems.AllRegionTrendTableWidget().Name ? p[ParameterList.RegionUncheckedItems] : p[ParameterList.KsaUncheckedItems])
.HasProperty(t => t.ParamName).WithValue(p => widgetItem.Name == WidgetItems.AllRegionTrendTableWidget().Name ? ParameterList.RegionUncheckedItems : ParameterList.KsaUncheckedItems)
.HasProperty(t => t.AbsoluteTousandValue).WithValue(p => p[ParameterList.AbsoluteThousandFilter])
.HasProperty(t => t.KPI).WithValue(p => p["@@KPI_text"]);
Export.HasConfig(GetExportConfig).HasController <TableExportController>()
.DataFlow.AddSource <CubeDataSourceBase>().WithModule(widgetItem.ViewId)
.Transform().By <CubeDataToXTableTrendTransformer>()
//.HasProperty(t => t.KPI).WithValue(p => p["@@_text"])
//.HasProperty(t => t.PeriodType).WithValue(p => p["@@" + ParameterList.TimePeriod + "_text"])
//.HasProperty(t => t.EndDate).WithValue(p => p["@@" + ParameterList.EndDate + "_text"])
.Transform().By <ExportModelTransformer>()
.HasProperty(t => t.NavigationNameString).WithValue(p => p.CurrentNavigationLabel())
.HasProperty(t => t.KPI).WithValue(p => p["@@KPI_text"])
.HasProperty(t => t.PeriodType).WithValue(p => p["@@" + ParameterList.TimePeriod + "_text"])
//.HasProperty(t => t.RevertAxis).WithValue(p => p["@@TimePeriod_text"] == "MAT" || p["@@TimePeriod_text"] == "YTD")
.HasProperty(t => t.UnitValue).WithValue(p => p["@@" + ParameterList.UnitOrValue + "_text"])
.HasProperty(t => t.StartDate).WithValue(p => p["@@" + ParameterList.StartDate + "_text"])
.HasProperty(t => t.EndDate).WithValue(p => p["@@" + ParameterList.EndDate + "_text"])
//.HasProperty(t => t.UncheckedItems).WithValue(p => widgetItem.Name == WidgetItems.AllRegionCombinationChart().Name ? p[ParameterList.RegionUncheckedItems] : p[ParameterList.KsaUncheckedItems])
.Transform().By <ExportTableSplitTrasformerForPpt>();
//.HasProperty(t => t.KPI).WithValue(p => p["@@KPI_text"]);
if (widgetItem.HasParamDependency != null && widgetItem.HasParamDependency.Count > 0)
{
HasParameterDependency.On(widgetItem.HasParamDependency);
}
}
private string GetParamName()
{
if (widgetItem.Name == WidgetItems.CompanyTrendTableChartWidget().Name)
{
return(ParameterList.CorporationUncheckedItems);
}
if (widgetItem.Name == WidgetItems.IntlProdTrendTableChartWidget().Name)
{
return(ParameterList.IntProductUncheckedItems);
}
if (widgetItem.Name == WidgetItems.ProductTrendTableChartWidget().Name)
{
return(ParameterList.ProductUncheckedItems);
}
if (widgetItem.Name == WidgetItems.SegmentTrendTableChartWidget().Name)
{
return(ParameterList.SegmentUncheckedItems);
}
return("ParamNames");
}
private string GetUncheckedItems(IReadOnlyDictionary <string, string> param)
{
if (widgetItem.Name == WidgetItems.CompanyTrendTableChartWidget().Name)
{
return(param[ParameterList.CorporationUncheckedItems]);
}
if (widgetItem.Name == WidgetItems.IntlProdTrendTableChartWidget().Name)
{
return(param[ParameterList.IntProductUncheckedItems]);
}
if (widgetItem.Name == WidgetItems.ProductTrendTableChartWidget().Name)
{
return(param[ParameterList.ProductUncheckedItems]);
}
if (widgetItem.Name == WidgetItems.SegmentTrendTableChartWidget().Name)
{
return(param[ParameterList.SegmentUncheckedItems]);
}
return("UncheckedItems");
}
public SingleChartModel GetData()
{
var model = new SingleChartModel {
Chart = ""
};
if (WidgetName == WidgetItems.HomeTrendChart().Name)
{
if (RegionOrCluster == "-ALL-" && country == "-na-")
{
model.Title = "Total Market vs Merck Sales trend in global" + "-" + PeriodType + "-" + //StartDate +
"-" + EndDate;
}
else if (country == "ALL COUNTRIES")
{
model.Title = "Total Market vs Merck Sales trend in " + RegionOrCluster + "-" + PeriodType + "-" +// StartDate +
"-" + EndDate;
}
else if (RegionOrCluster != "-ALL-" && country != "ALL COUNTRIES")
{
model.Title = "Total Market vs Merck Sales trend in " + country + "-" + PeriodType + "-" + //StartDate +
"-" + EndDate;
}
model.Chart = new MsCombinationChart()
{
WidgetName = WidgetName,
Input = Input,
UncheckedItems = UncheckedItems,
KPI = KPI,
RevertAxis = RevertAxis,
UnitValue = UnitValue,
CategoryString = CategoryString,
PeriodType = PeriodType,
MeasureValue = MeasureValue,
}.GetChart();
}
else if (KPI.ToUpper() == "SALES" || KPI.ToUpper() == "SALES PERFORMANCE VS COMPETITORS")
{
if (KPI.ToUpper() == "SALES")
{
model.Title = "Sales (in " + UnitValue + ")";
}
if (KPI.ToUpper() == "SALES PERFORMANCE VS COMPETITORS")
{
model.Title = "Performance vs. Competitors (in " + UnitValue + ")";
}
model.Chart = new MsCombinationChart()
{
Input = Input,
UncheckedItems = UncheckedItems,
KPI = KPI,
RevertAxis = RevertAxis,
UnitValue = UnitValue,
CategoryString = CategoryString,
PeriodType = PeriodType,
MeasureValue = MeasureValue,
}.GetChart();
}
else if (KPI.ToUpper() == "MARKET SHARE" || KPI.ToUpper() == "EVOLUTION INDEX")
{
if (KPI.ToUpper() == "MARKET SHARE")
{
model.Title = "Market Share % (" + UnitValue + ")";
}
if (KPI.ToUpper() == "EVOLUTION INDEX")
{
model.Title = "Evolution Index (" + UnitValue + ")";
}
model.Chart = new MsMerckLineChart()
{
Input = Input,
UncheckedItems = UncheckedItems,
KPI = KPI,
RevertAxis = RevertAxis,
CategoryString = CategoryString,
PeriodType = PeriodType,
MeasureValue = MeasureValue,
}.GetChart();
}
else//bubble chart
{
if (KPI.ToUpper() == "GROWTH")
{
model.Title = "Growth % (" + UnitValue + ")";
}
model.Chart = new MsBubbleChart()
{
Input = Input,
UncheckedItems = UncheckedItems,
KPI = KPI,
CategoryString = CategoryString,
PeriodType = PeriodType,
EndDate = EndDate,
MeasureValue = MeasureValue,
}.GetChart();
}
return(model);
}
