예제 #1
0
        private void ApplyFilters(PXSelectBase <CCProcTran> query)
        {
            CCPaymentFilter filter = this.Filter.Current;

            if (!string.IsNullOrEmpty(filter.ProcessingCenterID))
            {
                query.WhereAnd <Where <CCProcTran.processingCenterID, Equal <Current <CCPaymentFilter.processingCenterID> > > >();
            }

            if (!string.IsNullOrEmpty(filter.CustomerClassID))
            {
                query.WhereAnd <Where <Customer.customerClassID, Equal <Current <CCPaymentFilter.customerClassID> > > >();
            }

            if (filter.CustomerID.HasValue)
            {
                query.WhereAnd <Where <Customer.bAccountID, Equal <Current <CCPaymentFilter.customerID> > > >();
            }

            if (filter.DisplayType == DisplayTypes.Failed)
            {
                query.Join <LeftJoin <CCProcTranH, On <CCProcTranH.docType, Equal <CCProcTran.docType>,
                                                       And <CCProcTranH.refNbr, Equal <CCProcTran.refNbr>,
                                                            And <CCProcTranH.tranNbr, Greater <CCProcTran.tranNbr> > > > > >();
                query.WhereAnd <Where <CCProcTranH.tranNbr, IsNull,
                                       And <Where <CCProcTran.tranStatus, NotEqual <CCTranStatusCode.approved>,
                                                   Or <CCProcTran.tranStatus, IsNull> > > > >();
            }
        }
예제 #2
0
        protected virtual void CCPaymentFilter_EndDate_FieldUpdated(PXCache sender, PXFieldUpdatedEventArgs e)
        {
            CCPaymentFilter row = (CCPaymentFilter)e.Row;

            if (row.BeginDate.HasValue && row.EndDate.HasValue && row.EndDate.Value < row.BeginDate.Value)
            {
                row.BeginDate = row.EndDate;
            }
        }
예제 #3
0
        public virtual IEnumerable paymentTrans()
        {
            CCPaymentFilter filter = this.Filter.Current;

            if (filter != null)
            {
                PXSelectBase <CCProcTran> qCpmExists = new PXSelectJoin <CCProcTran,
                                                                         InnerJoin <CustomerPaymentMethod, On <CustomerPaymentMethod.pMInstanceID, Equal <CCProcTran.pMInstanceID> >,
                                                                                    LeftJoin <ARRegister, On <CCProcTran.refNbr, Equal <ARRegister.refNbr>,
                                                                                                              And <CCProcTran.docType, Equal <ARRegister.docType> > >,
                                                                                              InnerJoin <Customer, On <Customer.bAccountID, Equal <CustomerPaymentMethod.bAccountID> > > > >,
                                                                         Where <CCProcTran.startTime, GreaterEqual <Required <CCPaymentFilter.beginDate> >,
                                                                                And <CCProcTran.startTime, LessEqual <Required <CCPaymentFilter.endDate> > > > >(this);

                PXSelectBase <CCProcTran> qCpmNotExists = new PXSelectJoin <CCProcTran,
                                                                            LeftJoin <CustomerPaymentMethod, On <CustomerPaymentMethod.pMInstanceID, Equal <CCProcTran.pMInstanceID> >,
                                                                                      InnerJoin <ARRegister, On <CCProcTran.refNbr, Equal <ARRegister.refNbr>,
                                                                                                                 And <CCProcTran.docType, Equal <ARRegister.docType> > >,
                                                                                                 InnerJoin <Customer, On <Customer.bAccountID, Equal <ARRegister.customerID> > > > >,
                                                                            Where <CCProcTran.startTime, GreaterEqual <Required <CCPaymentFilter.beginDate> >,
                                                                                   And <CCProcTran.startTime, LessEqual <Required <CCPaymentFilter.endDate> >,
                                                                                        And <CCProcTran.pMInstanceID, Equal <PaymentTranExtTypes.NewPaymentProfile> > > > >(this);

                ApplyFilters(qCpmExists);
                ApplyFilters(qCpmNotExists);

                if (filter.EndDate != null)
                {
                    var result = qCpmExists.Select(filter.BeginDate, filter.EndDate.Value.AddDays(1));
                    result.AddRange(qCpmNotExists.Select(filter.BeginDate, filter.EndDate.Value.AddDays(1)));
                    foreach (PXResult <CCProcTran, CustomerPaymentMethod, ARRegister, Customer> it in result)
                    {
                        ARRegister doc    = it;
                        CCProcTran ccTran = it;
                        if (ccTran.TranType == CCTranTypeCode.Credit || ccTran.TranType == CCTranTypeCode.VoidTran)
                        {
                            ARRegister voiding = PXSelect <ARRegister, Where <ARRegister.refNbr, Equal <Required <ARRegister.refNbr> >,
                                                                              And <ARRegister.docType, Equal <ARDocType.voidPayment> > > > .Select(this, doc.RefNbr);

                            if (voiding != null)
                            {
                                doc.DocType = ARDocType.VoidPayment;
                            }
                        }
                        yield return(it);
                    }
                }
            }
            yield break;
        }
예제 #4
0
        public virtual IEnumerable paymentTrans()
        {
            CCPaymentFilter filter = this.Filter.Current;

            if (filter != null)
            {
                PXSelectBase <CCProcTran> select = new PXSelectJoin <CCProcTran,
                                                                     InnerJoin <CustomerPaymentMethod, On <CustomerPaymentMethod.pMInstanceID, Equal <CCProcTran.pMInstanceID> >,
                                                                                InnerJoin <Customer, On <Customer.bAccountID, Equal <CustomerPaymentMethod.bAccountID> >,
                                                                                           LeftJoin <ARPayment, On <CCProcTran.refNbr, Equal <ARPayment.refNbr>,
                                                                                                                    And <CCProcTran.docType, Equal <ARPayment.docType> > >,
                                                                                                     //LeftJoin<Customer, On<ARPayment.customerID, Equal<Customer.bAccountID>>,
                                                                                                     LeftJoin <CCProcTranH, On <CCProcTranH.docType, Equal <CCProcTran.docType>,
                                                                                                                                And <CCProcTranH.refNbr, Equal <CCProcTran.refNbr>,
                                                                                                                                     And <CCProcTranH.tranNbr, Greater <CCProcTran.tranNbr> > > > > > > >,
                                                                     Where <CCProcTran.startTime, GreaterEqual <Required <CCPaymentFilter.beginDate> >,
                                                                            And <CCProcTran.startTime, LessEqual <Required <CCPaymentFilter.endDate> > > >,
                                                                     OrderBy <Desc <ARPayment.refNbr> > >(this);

                if (!string.IsNullOrEmpty(filter.ProcessingCenterID))
                {
                    select.WhereAnd <Where <CCProcTran.processingCenterID, Equal <Current <CCPaymentFilter.processingCenterID> > > >();
                }

                if (!string.IsNullOrEmpty(filter.CustomerClassID))
                {
                    select.WhereAnd <Where <Customer.customerClassID, Equal <Current <CCPaymentFilter.customerClassID> > > >();
                }

                if (filter.CustomerID.HasValue)
                {
                    select.WhereAnd <Where <Customer.bAccountID, Equal <Current <CCPaymentFilter.customerID> > > >();
                }

                if (filter.DisplayType == DisplayTypes.Failed)
                {
                    select.WhereAnd <Where <CCProcTranH.tranNbr, IsNull,
                                            And <Where <CCProcTran.tranStatus, NotEqual <CCTranStatusCode.approved>,
                                                        Or <CCProcTran.tranStatus, IsNull> > > > >();
                }
                if (filter.EndDate != null)
                {
                    foreach (PXResult <CCProcTran, CustomerPaymentMethod, Customer, ARPayment, CCProcTranH> it in select.Select(filter.BeginDate, filter.EndDate.Value.AddDays(1)))
                    {
                        ARPayment  payment = it;
                        CCProcTran ccTran  = it;
                        if (ccTran.TranType == CCTranTypeCode.Credit || ccTran.TranType == CCTranTypeCode.VoidTran)
                        {
                            ARPayment voiding = PXSelect <ARPayment, Where <ARPayment.refNbr, Equal <Required <ARPayment.refNbr> >,
                                                                            And <ARPayment.docType, Equal <ARDocType.voidPayment> > > > .Select(this, payment.RefNbr);

                            if (voiding != null)
                            {
                                ((ARPayment)it).DocType = ARDocType.VoidPayment;
                            }
                        }
                        yield return(it);
                    }
                }
            }
            yield break;
        }