package pt.utl.ist.scripts.runOnce;

import java.io.FileOutputStream;

import net.sourceforge.fenixedu.domain.accounting.Event;
import net.sourceforge.fenixedu.domain.accounting.events.ImprovementOfApprovedEnrolmentEvent;
import pt.utl.ist.fenix.tools.util.excel.Spreadsheet;
import pt.utl.ist.fenix.tools.util.excel.Spreadsheet.Row;
import pt.utl.ist.scripts.commons.AtomicScript;

public class NotPayedImprovements extends AtomicScript {

    final static Spreadsheet spreadsheet = new Spreadsheet("");

    @Override
    protected void run() throws Exception {

        for (final Event event : rootDomainObject.getAccountingEventsSet()) {
            if (event instanceof ImprovementOfApprovedEnrolmentEvent && event.isInDebt()) {
                Row row = spreadsheet.addRow();
                row.setCell(event.getPerson().getStudent().getNumber().toString());
                row.setCell(event.getPerson().getName());
            }
        }

        spreadsheet.exportToCSV(new FileOutputStream(EXPORT_DIR_PATH + "/improvementInDebt.csv"), "\t");

    }

    /**
     * @param args
     */
    public static void main(String[] args) {
        process(new NotPayedImprovements());
        System.exit(0);
    }

}