001    /*
002     * Copyright 2011 The Kuali Foundation.
003     * 
004     * Licensed under the Educational Community License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     * 
008     * http://www.opensource.org/licenses/ecl2.php
009     * 
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013     * See the License for the specific language governing permissions and
014     * limitations under the License.
015     */
016    package org.kuali.kfs.module.ar.document.dataaccess.impl;
017    
018    import java.util.Collection;
019    import java.util.List;
020    
021    import org.apache.ojb.broker.query.Criteria;
022    import org.apache.ojb.broker.query.QueryFactory;
023    import org.kuali.kfs.module.ar.businessobject.CustomerInvoiceDetail;
024    import org.kuali.kfs.module.ar.document.dataaccess.CustomerInvoiceDetailDao;
025    import org.kuali.kfs.sys.KFSConstants;
026    import org.kuali.rice.kns.dao.impl.PlatformAwareDaoBaseOjb;
027    import org.kuali.rice.kns.util.KNSPropertyConstants;
028    
029    public class CustomerInvoiceDetailDaoOjb extends PlatformAwareDaoBaseOjb implements CustomerInvoiceDetailDao{
030    
031        /**
032         * This method retrieves all CustomerInvoiceDetail objects for the accountNumber if invoiceNumber is from the invoiceNumberList
033         * @return CustomerInvoiceDetail objects
034         */
035        public Collection getCustomerInvoiceDetailsByAccountNumberByInvoiceDocumentNumbers(String accountNumber,List documentNumbers) {
036            Criteria criteria = new Criteria();
037            criteria.addIn(KNSPropertyConstants.DOCUMENT_NUMBER, documentNumbers);
038            criteria.addEqualTo(KFSConstants.CustomerOpenItemReport.ACCOUNT_NUMBER, accountNumber);
039            
040            return getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(CustomerInvoiceDetail.class, criteria));
041        }
042    }