public string TranslateElement(ReportElement element, string reference)
{
return Repository.RepositoryTranslate(ExecutionView.CultureInfo.TwoLetterISOLanguageName, "Element", element.MetaColumn.Category + '.' + element.DisplayNameEl, reference);
}
public string TranslateElement(ReportElement element, string reference)
{
return RepositoryTranslate("Element", element.MetaColumn.Category + '.' + element.DisplayNameEl, reference);
}
ResultCell[] GetResultCells(ReportElement[] elements, DataRow row)
{
ResultCell[] result = new ResultCell[elements.Length];
for (int i = 0; i < elements.Length; i++)
{
result[i] = new ResultCell() { Element = elements[i], Value = row[elements[i].SQLColumnName] };
}
return result.ToArray();
}
ResultCell[] GetResultCells(ReportElement[] elements, ResultCell[] row, ResultCell[] col)
{
ResultCell[] result = new ResultCell[elements.Length];
for (int i = 0; i < elements.Length; i++)
{
ResultCell val = row.FirstOrDefault(v => v.Element == elements[i]);
if (val == null) val = col.FirstOrDefault(v => v.Element == elements[i]);
result[i] = new ResultCell() { Element = elements[i], Value = val.Value };
}
return result.ToArray();
}
public bool SetMetaColumn(TreeNodeCollection nodes, ReportElement element)
{
//select meta element in TreeView
foreach (TreeNode node in nodes)
{
if (element.MetaColumn == node.Tag)
{
elementTreeView.SelectedNode = node;
elementTreeView.SelectedNode.EnsureVisible();
elementTreeView.Focus();
return true;
}
if (SetMetaColumn(node.Nodes, element)) return true;
}
return false;
}
public void SetMetaColumn(ReportElement element)
{
SetMetaColumn(elementTreeView.Nodes, element);
}
public Button AddElement(ElementPanel panel, ReportElement element, bool selectButton)
{
Button button = new Button() { Text = element.DisplayNameEl };
button.Tag = element;
button.MouseDown += new MouseEventHandler(btn_MouseDown);
panel.Controls.Add(button);
if (selectButton) btn_MouseDown(button, null);
panel.ResizeControls();
return button;
}
public ReportExecution Navigate(string navigation, Report rootReport)
{
var parameters = HttpUtility.ParseQueryString(navigation);
string reportPath = parameters.Get("rpa"); //For subreports
string executionGuid = parameters.Get("exe"); //For drill
bool isSubReport = !string.IsNullOrEmpty(reportPath);
bool isDrill = !string.IsNullOrEmpty(executionGuid);
Report newReport = null;
//Check if the same navigation with the same execution GUID occured
var previousNav = Navigations.Values.FirstOrDefault(i => i.Execution.NavigationParameter == navigation && i.Execution.RootReport.ExecutionGUID == rootReport.ExecutionGUID);
if (previousNav != null)
{
newReport = previousNav.Execution.Report;
}
string destLabel = "", srcRestriction = "", srcGUID = "";
if (Navigations.Count(i => i.Value.Execution.RootReport.ExecutionGUID == rootReport.ExecutionGUID) == 1)
{
//For the first navigation, we update the JS file in the result to show up the button
string html = File.ReadAllText(rootReport.ResultFilePath);
html = html.Replace("var hasNavigation = false;/*SRKW do not modify*/", "var hasNavigation = true;");
rootReport.ResultFilePath = Helpers.FileHelper.GetUniqueFileName(rootReport.ResultFilePath);
File.WriteAllText(rootReport.ResultFilePath, html, System.Text.Encoding.UTF8);
rootReport.IsNavigating = true;
rootReport.HasNavigation = true;
Navigations.First(i => i.Value.Execution.RootReport.ExecutionGUID == rootReport.ExecutionGUID).Value.Link.Href = !string.IsNullOrEmpty(rootReport.WebUrl) ? ReportExecution.ActionViewHtmlResultFile + "?execution_guid=" + rootReport.ExecutionGUID : rootReport.ResultFilePath;
}
if (!string.IsNullOrEmpty(reportPath))
{
//Sub-Report
if (newReport == null)
{
string path = reportPath.Replace(Repository.SealRepositoryKeyword, rootReport.Repository.RepositoryPath);
newReport = Report.LoadFromFile(path, rootReport.Repository);
int index = 1;
while (true)
{
string res = parameters.Get("res" + index.ToString());
string val = parameters.Get("val" + index.ToString());
if (string.IsNullOrEmpty(res) || string.IsNullOrEmpty(val))
{
break;
}
foreach (var model in newReport.Models)
{
foreach (var restriction in model.Restrictions.Where(i => i.MetaColumnGUID == res && i.Prompt != PromptType.None))
{
restriction.SetNavigationValue(val);
srcRestriction = restriction.GeNavigationDisplayValue();
}
}
index++;
}
//Get display value
string dis = parameters.Get("dis");
if (!string.IsNullOrEmpty(dis))
{
srcRestriction = HttpUtility.HtmlDecode(dis);
}
}
}
else if (!string.IsNullOrEmpty(executionGuid))
{
//Drill
if (newReport == null)
{
if (Navigations.ContainsKey(executionGuid))
{
newReport = Navigations[executionGuid].Execution.Report.Clone();
}
else
{
//Drill from dashboard
newReport = rootReport.Clone();
}
newReport.ExecutionGUID = Guid.NewGuid().ToString();
string src = parameters.Get("src");
string dst = parameters.Get("dst");
string val = parameters.Get("val");
newReport.DrillParents.Add(src);
foreach (var model in newReport.Models)
{
ReportElement element = model.Elements.FirstOrDefault(i => i.MetaColumnGUID == src);
//Has already restriction ? if down check src, if up check dest
bool hasAlreadyRestriction = model.Restrictions.Exists(i => i.MetaColumnGUID == (val != null ? src : dst));
if (element != null || hasAlreadyRestriction)
{
if (element != null)
{
string initialLabel = element.DisplayNameEl;
element.ChangeColumnGUID(dst);
destLabel = element.DisplayNameElTranslated;
newReport.ExecutionView.ReplaceInParameterValues("nvd3_chart_title", "%" + initialLabel + "%", "%" + element.DisplayNameEl + "%");
}
if (val != null)
{
//Drill Down: Add restriction
ReportRestriction restriction = ReportRestriction.CreateReportRestriction();
restriction.Source = model.Source;
restriction.Report = newReport;
restriction.Model = model;
restriction.MetaColumnGUID = src;
restriction.SetDefaults();
restriction.Operator = Operator.Equal;
if (val == "")
{
restriction.Operator = Operator.IsEmpty;
}
else if (val == null)
{
restriction.Operator = Operator.IsNull;
}
restriction.SetNavigationValue(val);
model.Restrictions.Add(restriction);
if (!string.IsNullOrEmpty(model.Restriction))
{
model.Restriction = string.Format("({0}) AND ", model.Restriction);
}
model.Restriction += ReportRestriction.kStartRestrictionChar + restriction.GUID + ReportRestriction.kStopRestrictionChar;
srcRestriction = restriction.GeNavigationDisplayValue();
srcGUID = restriction.MetaColumnGUID;
}
else
{
//Drill Up: Remove restrictions
var restrictions = model.Restrictions.Where(i => i.MetaColumnGUID == dst).ToList();
foreach (var restr in restrictions)
{
model.Restrictions.Remove(restr);
model.Restriction = model.Restriction.Replace(ReportRestriction.kStartRestrictionChar + restr.GUID + ReportRestriction.kStopRestrictionChar, "1=1");
}
}
}
}
}
}
if (newReport == null)
{
throw new Exception("Invalid Navigation");
}
newReport.WebUrl = rootReport.WebUrl;
newReport.IsNavigating = true;
newReport.HasNavigation = true;
if (previousNav == null)
{
if (!string.IsNullOrEmpty(srcRestriction))
{
newReport.DisplayName = string.Format("{0} > {1}", newReport.ExecutionName, srcRestriction);
}
else
{
newReport.DisplayName = string.Format("{0} < {1}", newReport.ExecutionName, destLabel);
}
}
return(new ReportExecution()
{
NavigationParameter = navigation, Report = newReport, RootReport = rootReport
});
}
public string TranslateElement(ReportElement element, string reference)
{
return(RepositoryTranslate("Element", element.MetaColumn.Category + '.' + element.DisplayNameEl, reference));
}
