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.gl.dataaccess.impl;
017    
018    import org.kuali.kfs.gl.dataaccess.SufficientFundRebuildDao;
019    import org.kuali.rice.kns.dao.jdbc.PlatformAwareDaoBaseJdbc;
020    
021    /**
022     * This class...
023     */
024    public class SufficientFundRebuildDaoJdbc extends PlatformAwareDaoBaseJdbc implements SufficientFundRebuildDao {
025    
026        /**
027         * @see org.kuali.kfs.gl.dataaccess.SufficientFundRebuildDao#populateSufficientFundRebuild()
028         */
029        public void populateSufficientFundRebuild() {
030           getSimpleJdbcTemplate().update("INSERT INTO GL_SF_REBUILD_T (FIN_COA_CD, ACCT_NBR_FOBJ_CD, acct_fobj_typ_cd, obj_id, ver_nbr) "+ 
031                   "(SELECT FIN_COA_CD, ACCOUNT_NBR, 'A', obj_id, 1 FROM CA_ACCOUNT_T WHERE ACCT_CLOSED_IND = 'N')");
032    
033        }
034    
035        /**
036         * @see org.kuali.kfs.gl.dataaccess.SufficientFundRebuildDao#purgeSufficientFundRebuild()
037         */
038        public void purgeSufficientFundRebuild() {
039            getSimpleJdbcTemplate().update("DELETE FROM GL_SF_REBUILD_T");
040    
041        }   
042        
043    }