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