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); }