public ReportQueryInvoicesReceived()
{
Name = Translator.GetString("Received Invoices Report");
AppendFilter(new FilterRange(false, true, DataFilterLabel.InvoiceNumber, DataField.DocumentNumber));
AppendFilter(new FilterDateRange(false, true, DataFilterLabel.InvoiceDate, DataField.DocumentDate));
AppendFilter(new FilterRange(false, true, DataFilterLabel.OperationNumber, DataField.DocumentOperationNumber));
AppendFilter(new FilterFind(false, false, DataFilterLabel.ItemCode, DataField.ItemCode));
AppendFilter(new FilterFind(false, false, DataFilterLabel.ItemName, DataField.ItemName));
AppendFilter(new FilterFind(false, false, DataFilterLabel.ItemBarcode, DataField.ItemBarcode1, DataField.ItemBarcode2, DataField.ItemBarcode3));
AppendFilter(new FilterFind(false, true, DataFilterLabel.ItemCatalog, DataField.ItemCatalog1, DataField.ItemCatalog2, DataField.ItemCatalog3));
AppendFilter(new FilterGroupFind(false, true, DataFilterLabel.ItemsGroupName, DataField.ItemsGroupName));
AppendFilter(new FilterFind(false, false, DataFilterLabel.PartnerName, DataField.PartnerName));
AppendFilter(new FilterGroupFind(false, true, DataFilterLabel.PartnersGroupsName, DataField.PartnersGroupsName));
AppendFilter(new FilterFind(false, true, DataFilterLabel.OperationsOperatorName, DataField.OperationsOperatorName));
AppendFilter(new FilterGroupFind(false, true, DataFilterLabel.OperationsOperatorsGroupsName, DataField.OperationsOperatorsGroupsName));
AppendFilter(new FilterChooseLong(false, true, PaymentType.GetAllFilters(), DataFilterLabel.InvoicePaymentTypeId, DataField.DocumentPaymentTypeId));
AppendOrder(new Order(
DataField.DocumentNumber,
DataField.DocumentDate,
DataField.DocumentOperationNumber,
DataField.ItemCode,
DataField.ItemName,
DataField.PartnerName,
DataField.OperationsOperatorName));
}
public ReportQueryPaymentsAdvance()
{
Name = Translator.GetString("Advance Payments Report");
AppendFilter(new FilterRange(false, false, DataFilterLabel.PaymentOperationId, DataField.PaymentOperationId));
AppendFilter(new FilterDateRange(false, true, DataFilterLabel.PaymentDate, DataField.PaymentDate));
AppendFilter(new FilterFind(true, true, DataFilterLabel.PartnerName, DataField.PartnerName));
AppendFilter(new FilterGroupFind(false, false, DataFilterLabel.PartnersGroupsName, DataField.PartnersGroupsName));
AppendFilter(new FilterFind(false, true, DataFilterLabel.UserName, DataField.UserName));
AppendFilter(new FilterGroupFind(false, false, DataFilterLabel.UsersGroupsName, DataField.UsersGroupsName));
AppendFilter(new FilterChooseLong(false, true, PaymentType.GetAllFilters(), DataFilterLabel.PaymentTypeId, DataField.PaymentTypeId));
AppendFilter(new FilterCompare(true, true, DataFilterLabel.PaymentAmount, DataField.PaymentAmount));
AppendOrder(new Order(DataField.PaymentDate, DataField.PaymentAmount, DataField.PartnerName));
}
public ReportQueryPaymentsHistory()
{
Name = Translator.GetString("Payments History Report");
AppendFilter(new FilterRange(true, true, DataFilterLabel.PaymentOperationId, DataField.PaymentOperationId));
AppendFilter(new FilterDateRange(true, true, DataFilterLabel.PaymentDate, DataField.PaymentDate));
AppendFilter(new FilterFind(true, true, DataFilterLabel.PartnerName, DataField.PartnerName));
AppendFilter(new FilterGroupFind(false, true, DataFilterLabel.PartnersGroupsName, DataField.PartnersGroupsName));
AppendFilterForPayableOperations(true);
AppendFilter(new FilterChooseLong(false, false, PaymentType.GetAllFilters(), DataFilterLabel.PaymentTypeId, DataField.PaymentTypeId));
AppendOrder(new Order(
DataField.PaymentId,
DataField.PaymentDate,
DataField.PartnerName));
}
public ReportQueryIncome()
{
Name = Translator.GetString("Income");
AppendFilter(new FilterRange(true, true, DataFilterLabel.OperationNumber, DataField.PaymentOperationId));
AppendFilter(new FilterDateRange(false, true, DataFilterLabel.PaymentDate, DataField.PaymentDate));
AppendFilter(new FilterFind(false, true, DataFilterLabel.PartnerName, DataField.PartnerName));
AppendFilter(new FilterGroupFind(false, true, DataFilterLabel.PartnersGroupsName, DataField.PartnersGroupsName));
AppendFilter(new FilterFind(false, true, DataFilterLabel.LocationName, DataField.LocationName));
AppendFilter(new FilterGroupFind(false, true, DataFilterLabel.LocationsGroupName, DataField.LocationsGroupsName));
AppendFilter(new FilterFind(false, true, DataFilterLabel.UserName, DataField.UserName));
AppendFilter(new FilterGroupFind(false, true, DataFilterLabel.UsersGroupsName, DataField.UsersGroupsName));
AppendFilterForPayableOperations(true);
AppendFilter(new FilterChooseLong(false, false, PaymentType.GetAllFilters(), DataFilterLabel.PaymentTypeId, DataField.PaymentTypeId));
AppendOrder(new Order(
DataField.PaymentOperationId,
DataField.PaymentDate,
DataField.PartnerName,
DataField.LocationName,
DataField.PaymentOperationType,
DataField.PaymentTypesName));
}
