private List <string> GetReportsQueryDialogFilter(ReportsQueryDialogMode pReportsQueryDialogMode, string pDatabaseSourceObject)
{
PosReportsQueryDialog dialog = new PosReportsQueryDialog(_sourceWindow, DialogFlags.DestroyWithParent, pReportsQueryDialogMode, pDatabaseSourceObject);
ResponseType response = (ResponseType)dialog.Run();
List <string> result = new List <string>();
// Filter SellDocuments
string filterField = string.Empty;
string statusField = string.Empty;
bool filterSellDocuments = false;
string extraFilter = string.Empty;
if (response == ResponseType.Ok)
{
// Filter SellDocuments
if (pReportsQueryDialogMode.Equals(ReportsQueryDialogMode.FINANCIAL))
{
filterSellDocuments = true;
filterField = "DocumentType";
statusField = "DocumentStatusStatus";
}
else if (pReportsQueryDialogMode.Equals(ReportsQueryDialogMode.FINANCIAL_DETAIL) || pReportsQueryDialogMode.Equals(ReportsQueryDialogMode.FINANCIAL_DETAIL_GROUP))
{
filterSellDocuments = true;
filterField = "ftOid";
statusField = "fmDocumentStatusStatus";
}
// Add extraFilter for SellDocuments
if (filterSellDocuments == true)
{
extraFilter = $@" AND ({statusField} <> 'A') AND (
{filterField} = '{SettingsApp.XpoOidDocumentFinanceTypeInvoice}' OR
{filterField} = '{SettingsApp.XpoOidDocumentFinanceTypeSimplifiedInvoice}' OR
{filterField} = '{SettingsApp.XpoOidDocumentFinanceTypeInvoiceAndPayment}' OR
{filterField} = '{SettingsApp.XpoOidDocumentFinanceTypeConsignationInvoice}' OR
{filterField} = '{SettingsApp.XpoOidDocumentFinanceTypeDebitNote}'
)".Replace(Environment.NewLine, string.Empty);
}
// Assign Dialog FilterValue to Method Result Value
result.Add($"{dialog.FilterValue}{extraFilter}");
result.Add(dialog.FilterValueHumanReadble);
}
else
{
// Destroy Dialog on Cancel
dialog.Destroy();
// Assign Result
result = null;
}
return(result);
}
private void PrintReportRouter(object sender, EventArgs e)
{
CustomReportDisplayMode displayMode = (Debugger.IsAttached)
? CustomReportDisplayMode.Design
: CustomReportDisplayMode.ExportPDF;
// Override Default Development Mode
displayMode = CustomReportDisplayMode.ExportPDF;
// Local Variables
string reportFilter = string.Empty;
string reportFilterHumanReadable = string.Empty;
string databaseSourceObject = string.Empty;
AccordionChildButton button = (sender as AccordionChildButton);
//_log.Debug(String.Format("Button.Name: [{0}], Button.label: [{1}]", button.Name, button.Label));
// Get Token From buttonName
ReportsTypeToken token = (ReportsTypeToken)Enum.Parse(typeof(ReportsTypeToken), button.Name, true);
// Prepare ReportsQueryDialogMode
ReportsQueryDialogMode reportsQueryDialogMode = ReportsQueryDialogMode.UNDEFINED;
// Catch REPORT_SALES_DETAIL_* and REPORT_SALES_DETAIL_GROUP_* use same View
if (token.ToString().StartsWith("REPORT_SALES_DETAIL_"))
{
reportsQueryDialogMode = ReportsQueryDialogMode.FINANCIAL_DETAIL;
databaseSourceObject = "view_documentfinance";
}
else if (token.ToString().StartsWith("REPORT_SALES_"))
{
reportsQueryDialogMode = ReportsQueryDialogMode.FINANCIAL;
databaseSourceObject = "fin_documentfinancemaster";
}
else if (token.ToString().Equals("REPORT_LIST_STOCK_MOVEMENTS"))
{
reportsQueryDialogMode = ReportsQueryDialogMode.ARTICLE_STOCK_MOVEMENTS;
databaseSourceObject = "view_articlestockmovement";
}
else if (token.ToString().Equals("REPORT_LIST_AUDIT_TABLE"))
{
reportsQueryDialogMode = ReportsQueryDialogMode.SYSTEM_AUDIT;
databaseSourceObject = "view_systemaudit";
}
else if (token.ToString().Equals("REPORT_LIST_CURRENT_ACCOUNT"))
{
reportsQueryDialogMode = ReportsQueryDialogMode.CURRENT_ACCOUNT;
databaseSourceObject = "view_documentfinancecurrentaccount";
}
else if (token.ToString().Equals("REPORT_LIST_USER_COMMISSION"))
{
reportsQueryDialogMode = ReportsQueryDialogMode.USER_COMMISSION;
databaseSourceObject = "view_usercommission";
}
// Common GetReportsQueryDialogFilter for All Non Undefined ReportsQueryDialogMode
if (reportsQueryDialogMode != ReportsQueryDialogMode.UNDEFINED)
{
// Call PosReportsQueryDialog to get Filter
List <string> dialogresultFilter = GetReportsQueryDialogFilter(reportsQueryDialogMode, databaseSourceObject);
if (dialogresultFilter != null && dialogresultFilter.Count == 2)
{
reportFilter = dialogresultFilter[0];
reportFilterHumanReadable = dialogresultFilter[1];
}
// ResponseType.Cancel
else
{
reportFilter = null;
reportFilterHumanReadable = null;
}
}
// Proceed if we have a Filter != null (ResponseType.Ok), ex can be a string.Empty
//if (reportFilter != null || !financialViewMode)
if (reportFilter != null /* || reportsQueryDialogMode != ReportsQueryDialogMode.UNDEFINED*/)
{
switch (token)
{
case ReportsTypeToken.REPORT_SALES_PER_FINANCE_DOCUMENT:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.DocumentType.Ord]"
, "[DocumentFinanceMaster.DocumentType.Designation] ([DocumentFinanceMaster.DocumentType.Code])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_PER_DATE:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.DocumentDate]"
, "[DocumentFinanceMaster.DocumentDate]",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_PER_USER:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.CreatedBy.Ord]"
, "[DocumentFinanceMaster.CreatedBy.Name] ([DocumentFinanceMaster.CreatedBy.Code])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_PER_TERMINAL:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.CreatedWhere.Ord]"
, "[DocumentFinanceMaster.CreatedWhere.Designation] ([DocumentFinanceMaster.CreatedWhere.Code])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_PER_CUSTOMER:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.EntityFiscalNumber]"
, "[DocumentFinanceMaster.EntityName] ([DocumentFinanceMaster.EntityFiscalNumber])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_PER_PAYMENT_METHOD:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.PaymentCondition.Ord]"
, "[DocumentFinanceMaster.PaymentCondition.Designation] ([DocumentFinanceMaster.PaymentCondition.Code])",
// Required to Exclude Documents without PaymentMethod else Errors Occur
(string.IsNullOrEmpty(reportFilter)) ? "PaymentMethod IS NOT NULL" : string.Format("{0} AND PaymentMethod IS NOT NULL", reportFilter),
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_PER_PAYMENT_CONDITION:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.PaymentCondition.Ord]"
, "[DocumentFinanceMaster.PaymentCondition.Designation] ([DocumentFinanceMaster.PaymentCondition.Code])",
// Required to Exclude Documents without PaymentCondition else Errors Occur
(string.IsNullOrEmpty(reportFilter)) ? "PaymentCondition IS NOT NULL" : string.Format("{0} AND PaymentCondition IS NOT NULL", reportFilter),
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_PER_CURRENCY:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.Currency.Ord]"
, "[DocumentFinanceMaster.Currency.Designation] ([DocumentFinanceMaster.Currency.Code])",
// Required to Exclude Documents without PaymentCondition else Errors Occur
(string.IsNullOrEmpty(reportFilter)) ? "PaymentCondition IS NOT NULL" : string.Format("{0} AND PaymentCondition IS NOT NULL", reportFilter),
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_PER_COUNTRY:
CustomReport.ProcessReportDocumentMasterList(displayMode
, Resx.ResourceManager.GetString(token.ToString().ToLower())
, "[DocumentFinanceMaster.EntityCountry]"
, "[DocumentFinanceMaster.EntityCountry]",
reportFilter,
reportFilterHumanReadable
);
break;
//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
// Detail
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_FINANCE_DOCUMENT:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.DocumentTypeOrd]"
, "[DocumentFinanceDetail.DocumentTypeDesignation] ([DocumentFinanceDetail.DocumentTypeCode])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_DATE:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.DocumentDate]"
, "[DocumentFinanceDetail.DocumentDate]",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_USER:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.UserDetailOrd]"
, "[DocumentFinanceDetail.UserDetailName] ([DocumentFinanceDetail.UserDetailCode])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_TERMINAL:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.TerminalOrd]"
, "[DocumentFinanceDetail.TerminalDesignation] ([DocumentFinanceDetail.TerminalCode])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_CUSTOMER:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.EntityFiscalNumber]"
, "[DocumentFinanceDetail.EntityName] ([DocumentFinanceDetail.EntityFiscalNumber])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_PAYMENT_METHOD:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.PaymentMethodOrd]"
, "[DocumentFinanceDetail.PaymentMethodDesignation] ([DocumentFinanceDetail.PaymentMethodCode])",
(string.IsNullOrEmpty(reportFilter)) ? "fmPaymentMethod IS NOT NULL" : string.Format("{0} AND fmPaymentMethod IS NOT NULL", reportFilter),
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_PAYMENT_CONDITION:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.PaymentConditionOrd]"
, "[DocumentFinanceDetail.PaymentConditionDesignation] ([DocumentFinanceDetail.PaymentConditionCode])",
(string.IsNullOrEmpty(reportFilter)) ? "fmPaymentCondition IS NOT NULL" : string.Format("{0} AND fmPaymentCondition IS NOT NULL", reportFilter),
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_CURRENCY:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.CurrencyOrd]"
, "[DocumentFinanceDetail.CurrencyDesignation] ([DocumentFinanceDetail.CurrencyCode])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_COUNTRY:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.CountryOrd]"
, "[DocumentFinanceDetail.CountryDesignation] ([DocumentFinanceDetail.EntityCountryCode2])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_FAMILY:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.ArticleFamilyOrd]"
, "[DocumentFinanceDetail.ArticleFamilyDesignation] ([DocumentFinanceDetail.ArticleFamilyCode])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_FAMILY_AND_SUBFAMILY:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.ArticleSubFamilyOrd]"
, "[DocumentFinanceDetail.ArticleFamilyDesignation] ([DocumentFinanceDetail.ArticleFamilyCode]) / [DocumentFinanceDetail.ArticleSubFamilyDesignation] ([DocumentFinanceDetail.ArticleSubFamilyCode])",
reportFilter,
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_PLACE:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.PlaceOrd]"
, "[DocumentFinanceDetail.PlaceDesignation] ([DocumentFinanceDetail.PlaceCode])",
// Required to Exclude Documents without Place
(string.IsNullOrEmpty(reportFilter)) ? "cpPlace IS NOT NULL" : string.Format("{0} AND cpPlace IS NOT NULL", reportFilter),
reportFilterHumanReadable
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_PER_PLACE_TABLE:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "[DocumentFinanceDetail.PlaceTableOrd]"
, "[DocumentFinanceDetail.PlaceDesignation] ([DocumentFinanceDetail.PlaceCode]) / [DocumentFinanceDetail.PlaceTableDesignation] ([DocumentFinanceDetail.PlaceTableCode])",
// Required to Exclude Documents without PlaceTable
(string.IsNullOrEmpty(reportFilter)) ? "dmPlaceTable IS NOT NULL" : string.Format("{0} AND dmPlaceTable IS NOT NULL", reportFilter),
reportFilterHumanReadable
);
break;
//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
// Detail/Group
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_FINANCE_DOCUMENT:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "ftOid, ftDocumentTypeOrd, ftDocumentTypeCode, ftDocumentTypeDesignation"
, "ftOid AS GroupOid, ftDocumentTypeOrd AS GroupOrd, ftDocumentTypeCode AS GroupCode, ftDocumentTypeDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, reportFilter
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_DATE:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "fmDocumentDate"
, "fmDocumentDate AS GroupOid, fmDocumentDate AS GroupOrd, fmDocumentDate AS GroupCode, fmDocumentDate AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation]"
, reportFilter
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_USER:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "udUserDetail, udUserDetailOrd, udUserDetailCode, udUserDetailName"
, "udUserDetail AS GroupOid, udUserDetailOrd AS GroupOrd, udUserDetailCode AS GroupCode, udUserDetailName AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, reportFilter
, reportFilterHumanReadable
, true
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_TERMINAL:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "trTerminal, trTerminalOrd, trTerminalCode, trTerminalDesignation"
, "trTerminal AS GroupOid, trTerminalOrd AS GroupOrd, trTerminalCode AS GroupCode, trTerminalDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, reportFilter
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_CUSTOMER:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "fmEntity, cuEntityOrd, cuEntityCode, fmEntityName"
, "fmEntity AS GroupOid, cuEntityOrd AS GroupOrd, cuEntityCode AS GroupCode, fmEntityName AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, reportFilter
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_PAYMENT_METHOD:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "fmPaymentMethod, pmPaymentMethodOrd, pmPaymentMethodCode, pmPaymentMethodDesignation"
, "fmPaymentMethod AS GroupOid, pmPaymentMethodOrd AS GroupOrd, pmPaymentMethodCode AS GroupCode, pmPaymentMethodDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, (string.IsNullOrEmpty(reportFilter)) ? "fmPaymentMethod IS NOT NULL" : string.Format("{0} AND fmPaymentMethod IS NOT NULL", reportFilter)
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_PAYMENT_CONDITION:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "fmPaymentCondition, pcPaymentConditionOrd, pcPaymentConditionCode, pcPaymentConditionDesignation"
, "fmPaymentCondition AS GroupOid, pcPaymentConditionOrd AS GroupOrd, pcPaymentConditionCode AS GroupCode, pcPaymentConditionDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, (string.IsNullOrEmpty(reportFilter)) ? "fmPaymentCondition IS NOT NULL" : string.Format("{0} AND fmPaymentCondition IS NOT NULL", reportFilter)
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_CURRENCY:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "fmCurrency, crCurrencyOrd, crCurrencyCode, crCurrencyDesignation"
, "fmCurrency AS GroupOid, crCurrencyOrd AS GroupOrd, crCurrencyCode AS GroupCode, crCurrencyDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, reportFilter
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_COUNTRY:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "ccCountry, ccCountryOrd, ccCountryCode, ccCountryDesignation"
, "ccCountry AS GroupOid, ccCountryOrd AS GroupOrd, ccCountryCode AS GroupCode, ccCountryDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, reportFilter
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_FAMILY:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "afFamily, afFamilyOrd, afFamilyCode, afFamilyDesignation"
, "afFamily AS GroupOid, afFamilyOrd AS GroupOrd, afFamilyCode AS GroupCode, afFamilyDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, reportFilter
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_FAMILY_AND_SUBFAMILY:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "sfSubFamily, sfSubFamilyOrd, sfSubFamilyCode, sfSubFamilyDesignation"
, "sfSubFamily AS GroupOid, sfSubFamilyOrd AS GroupOrd, sfSubFamilyCode AS GroupCode, sfSubFamilyDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, reportFilter
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_PLACE:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "cpPlace, cpPlaceOrd, cpPlaceCode, cpPlaceDesignation"
, "cpPlace AS GroupOid, cpPlaceOrd AS GroupOrd, cpPlaceCode AS GroupCode, cpPlaceDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, (string.IsNullOrEmpty(reportFilter)) ? "cpPlace IS NOT NULL" : string.Format("{0} AND cpPlace IS NOT NULL", reportFilter)
, reportFilterHumanReadable
, true
);
break;
case ReportsTypeToken.REPORT_SALES_DETAIL_GROUP_PER_PLACE_TABLE:
CustomReport.ProcessReportDocumentDetail(displayMode
, token.ToString().ToLower()
, "dmPlaceTable, ctPlaceTableOrd, ctPlaceTableCode, ctPlaceTableDesignation"
, "dmPlaceTable AS GroupOid, ctPlaceTableOrd AS GroupOrd, ctPlaceTableCode AS GroupCode, ctPlaceTableDesignation AS GroupDesignation"
, "[DocumentFinanceDetail.GroupOid]"
, "[DocumentFinanceDetail.GroupDesignation] ([DocumentFinanceDetail.GroupCode])"
, (string.IsNullOrEmpty(reportFilter)) ? "dmPlaceTable IS NOT NULL" : string.Format("{0} AND dmPlaceTable IS NOT NULL", reportFilter)
, reportFilterHumanReadable
, true
);
break;
//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
// Where it is Called?
/*
* case ReportsTypeToken.REPORT_SALES_PER_FAMILY_AND_SUBFAMILY:
* CustomReport.ProcessReportDocumentDetail(displayMode
* , Resx.ResourceManager.GetString(token.ToString().ToLower())
* , "[DocumentFinanceDetail.ArticleFamilyCode]"
* , "[DocumentFinanceDetail.ArticleFamilyDesignation] ([DocumentFinanceDetail.ArticleFamilyCode])"
* , false
* );
* break;
* // Where it is Called?
* case ReportsTypeToken.REPORT_SALES_PER_ZONE_TABLE:
* CustomReport.ProcessReportDocumentDetail(displayMode
* , Resx.ResourceManager.GetString(token.ToString().ToLower())
* , "[DocumentFinanceDetail.ArticleFamilyCode]"
* , "[DocumentFinanceDetail.ArticleFamilyDesignation] ([DocumentFinanceDetail.ArticleFamilyCode])"
* , true
* );
* break;
*/
//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
// Other Non REPORT_SALES_* Reports
// Auxiliar Tables
case ReportsTypeToken.REPORT_LIST_FAMILY_SUBFAMILY_ARTICLES:
// Where it is Called?
CustomReport.ProcessReportArticle(displayMode);
break;
case ReportsTypeToken.REPORT_LIST_CUSTOMERS:
CustomReport.ProcessReportCustomer(displayMode);
break;
// Other Reports
case ReportsTypeToken.REPORT_LIST_AUDIT_TABLE:
CustomReport.ProcessReportSystemAudit(displayMode, reportFilter, reportFilterHumanReadable);
break;
case ReportsTypeToken.REPORT_LIST_STOCK_MOVEMENTS:
CustomReport.ProcessReportArticleStockMovement(displayMode, reportFilter, reportFilterHumanReadable);
break;
case ReportsTypeToken.REPORT_LIST_CURRENT_ACCOUNT:
CustomReport.ProcessReportDocumentFinanceCurrentAccount(displayMode, reportFilter, reportFilterHumanReadable);
break;
case ReportsTypeToken.REPORT_LIST_USER_COMMISSION:
CustomReport.ProcessReportUserCommission(displayMode, reportFilter, reportFilterHumanReadable);
break;
// ABove are not Implemented Yet
case ReportsTypeToken.REPORT_TOTAL_PER_FAMILY:
break;
case ReportsTypeToken.REPORT_TOP_CLOSE_EMPLOYEES:
break;
case ReportsTypeToken.REPORT_OCCUPATION_AVERAGE:
break;
case ReportsTypeToken.REPORT_ZONE_TOTAL:
break;
case ReportsTypeToken.REPORT_CLOSE_PEAK_HOUR:
break;
case ReportsTypeToken.REPORT_TOP_OFFERS:
break;
case ReportsTypeToken.REPORT_TOP_EMPLOYEE_RECORDS:
break;
case ReportsTypeToken.REPORT_RECORD_PEAK_HOUR:
break;
case ReportsTypeToken.REPORT_EMPLOYEE_MOVENTS:
break;
case ReportsTypeToken.REPORT_ACOUNT_BALANCE:
break;
case ReportsTypeToken.REPORT_WITHHOLDING_TAX:
break;
case ReportsTypeToken.REPORT_BALANCE_SHEET:
break;
case ReportsTypeToken.REPORT_SERVICE_HOURS:
break;
case ReportsTypeToken.REPORT_COURIER_DELIVER:
break;
case ReportsTypeToken.REPORT_CANCELED_ARTICLES_PER_EMPLOYEE:
break;
case ReportsTypeToken.REPORT_LIST_INVENTORY:
break;
case ReportsTypeToken.REPORT_DISCOUNTS_PER_USER:
break;
case ReportsTypeToken.REPORT_LIST_CONSUMPTION_PER_USER:
break;
case ReportsTypeToken.REPORT_CASH_TOTAL:
break;
case ReportsTypeToken.REPORT_LIST_WORKSESSION:
break;
case ReportsTypeToken.REPORT_LIST_CLOSE_WORKSESSION:
break;
default:
_log.Error(String.Format("Undetected Token: [{0}]", token));
break;
}
}
}
