/*
Copyright (c) 2009 David Savage.

This file is part of "cong".

cong is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

cong is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with cong.  If not, see <http://www.gnu.org/licenses/>.
*/
package info.savaged.cong

class ExcelUploadController {

    def excelUploadService

    def index = {}

    def upload = {
        def sourceFile = request.getFile('myFile');
        if (!sourceFile.empty) {
	    def localFile = new File('cbs_report_proforma.xls')
	    sourceFile.transferTo(localFile)
            def year
	    def month
            if (params.starting_year != null) {
                year = Integer.parseInt(params.starting_year)
                log.debug "Using params.starting_year=${params.starting_year} for upload"
            }
            if (params.starting_month != null) {
                month = Integer.parseInt(params.starting_month)
                log.debug "Using params.starting_month=${params.starting_month} for upload"
            }
            excelUploadService.bindData localFile, month, year
            localFile.delete()
            log.debug "File uploaded"
        } else {
            log.error "File is empty"
        }
        redirect(controller:'monthServiceReportTotals')
    }

}
