private List <RelevantFootNotesRow> getRelevantGroupingNotes(bool inPresentationModus)
{
List <RelevantFootNotesRow> myOut = new List <RelevantFootNotesRow>();
foreach (PXSqlVariable var in mMeta.Variables.Values)
{
if (var.IsClassificationVariable)
{
PXSqlVariableClassification clVar = (PXSqlVariableClassification)var;
StringCollection groupingids = new StringCollection();
if (inPresentationModus)
{
if (clVar.isSelected && !String.IsNullOrEmpty(clVar.CurrentGroupingId))
{
groupingids.Add(clVar.CurrentGroupingId);
}
}
else
{
groupingids = clVar.GroupingInfos.GroupingIDs;
}
if (groupingids.Count > 0)
{
foreach (FootnoteGroupingRow fgr in mMeta.MetaQuery.GetFootnoteGroupingRows(groupingids, true).Values)
{
myOut.Add(new RelevantFootNotesRow(clVar.Name, mMeta.MetaQuery.GetFootnoteRow(fgr.FootnoteNo), mMeta.Config, mMeta.LanguageCodes));
}
}
}
}
return(myOut);
}
/// <summary>
/// Constructor called when parser is in selectionmode and there are no grouping ids in pxs or no pxs at all.
/// </summary>
/// <returns></returns>
public PXSqlGrouping(GroupingRow groupingRow, PXSqlMeta_22 meta, PXSqlVariableClassification var, GroupingIncludesType include)
{
Init(groupingRow, meta, var);
//TODO overriding include from paxiom, have to discuss how paxion can override database default.
this.mIncludeType = include;
// DONE, is now passed to paxiom as part of GroupingInfo ... this.mIncludeType = this.mDefaultIncludeType;
//TODO end
tempValueList = new StringCollection();
StringCollection tempParentList = new StringCollection();
mGroups = new List <PXSqlGroup>();
PXSqlGroup tmpGroup = null;
this.isHierarchy = this.mHierarchy != meta.Config.Codes.HierarchyNon;
if (!isHierarchy)
// Not hierarchical groups
{
this.mIncludeType = include;
List <ValueGroupRow> myValuegroupRows = meta.MetaQuery.GetValueGroupRowsSorted(mGroupingId, null, true, meta.MainLanguageCode);
foreach (ValueGroupRow myRow in myValuegroupRows)
{
if (!tempParentList.Contains(myRow.GroupCode))
{
tmpGroup = new PXSqlGroup(myRow.GroupCode);
mGroups.Add(tmpGroup);
tempParentList.Add(myRow.GroupCode);
}
else
{
foreach (PXSqlGroup group in mGroups)
{
if (group.ParentCode == myRow.GroupCode)
{
tmpGroup = group;
break;
}
}
}
tmpGroup.AddChildCode(myRow.ValueCode);
}
AddValues(mValuePoolId, tempParentList, valuePoolValueTextExists);
}
else
//hierarchical groups
{
this.mIncludeType = GroupingIncludesType.All;
createHierarchy(meta.MetaQuery.GetValueGroupRowsSorted(mGroupingId, levelOne, true, meta.MainLanguageCode));
setHierarchyLevelsOpen();
setHierarchyLevels();
setHierarchyNames();
variable.Values.Clear();
AddValues(mValuePoolId, tempValueList, valuePoolValueTextExists);
}
}
//for selection or presentation with grouping id in from pxs
public PXSqlGrouping(GroupingRow groupingRow, PXSqlMeta_22 meta, PXSqlVariableClassification var, StringCollection outputCodes)
{
Init(groupingRow, meta, var);
StringCollection tempParentList = new StringCollection();
mGroups = new List <PXSqlGroup>();
PXSqlGroup tmpGroup = null;
this.isHierarchy = this.mHierarchy != meta.Config.Codes.HierarchyNon;
foreach (string code in outputCodes)
{
tmpGroup = new PXSqlGroup(code);
mGroups.Add(tmpGroup);
}
foreach (PXSqlGroup group in mGroups)
{
//TODO; 2.2 bytt VSGroupRow
// throw new NotImplementedException("i PXSqlGrouping");
Dictionary <string, ValueGroupRow> templist = meta.MetaQuery.GetValueGroupRowskeyValueCode(mGroupingId, group.ParentCode, true);
if (templist.Count > 0)
{
foreach (KeyValuePair <string, ValueGroupRow> row in templist)
{
group.AddChildCode(row.Key);
}
}
else
{
group.AddChildCode(group.ParentCode);
}
//List<VSGroupRow> tempList = meta.MetaQuery.GetVSGroupRow(mValuePoolId, mValuesetIds, mGroupingId,group.ParentCode);
//if (tempList.Count > 0)
//{
// foreach(VSGroupRow row in tempList)
// {
// group.AddChildCode(row.ValueCode);
// }
//}
//else
//{
// group.AddChildCode(group.ParentCode);
//}
}
// Add the values to valuecollection of this variable
AddValues(mValuePoolId, outputCodes, valuePoolValueTextExists);
}
//for presentation without grouping id in from pxs
public PXSqlGrouping(PXSqlMeta_22 meta, PXSqlVariableClassification var, List <PXSqlGroup> groupFromPxs)
{
this.meta = meta;
this.variable = var;
this.valuePoolValueTextExists = var.ValuePool.ValueTextExists;
this.mValuePoolId = var.ValuePool.ValuePool;
this.mGroups = groupFromPxs;
StringCollection parentCodes = new StringCollection();
foreach (PXSqlGroup group in groupFromPxs)
{
parentCodes.Add(group.ParentCode);
}
AddValues(mValuePoolId, parentCodes, valuePoolValueTextExists);
}
private void Init(GroupingRow groupingRow, PXSqlMeta_22 meta, PXSqlVariableClassification var)
{
this.meta = meta;
this.variable = var;
this.valuePoolValueTextExists = var.ValuePool.ValueTextExists;
this.mValuePoolId = groupingRow.ValuePool;
this.mValuesetIds = var.ValusetIds;
this.mGroupingId = groupingRow.Grouping;
this.mGroupPres = groupingRow.GroupPres;
// throw new NotImplementedException("I init i PXSqlGrouping");
//TODO; tok bort this.mGeoAreaNo = groupingRow.GeoAreaNo;
// this.mGeoAreaNo = groupingRow.GeoAreaNo;
this.mHierarchy = groupingRow.Hierarchy;
this.Description = groupingRow.Description;
this.PresText = new Dictionary <string, string>();
foreach (string langCode in meta.LanguageCodes)
{
this.PresText[langCode] = groupingRow.texts[langCode].PresText;
}
this.SortCode = groupingRow.texts[meta.MainLanguageCode].SortCode;
//TODO added databasedefault to override value from paxiom, should be possible to do both
switch (this.mGroupPres.ToUpper())
{
case "I":
mDefaultIncludeType = GroupingIncludesType.SingleValues;
break;
case "A":
mDefaultIncludeType = GroupingIncludesType.AggregatedValues;
break;
case "B":
mDefaultIncludeType = GroupingIncludesType.All;
break;
default:
mDefaultIncludeType = GroupingIncludesType.AggregatedValues;
break;
}
}