/*
 * MosP - Mind Open Source Project         http://www.mosp.jp/
 * Copyright (C) 1987-2009 MIND Co., Ltd.  http://www.e-mind.co.jp/
 * 
 * This program 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 2
 * of the License, or (at your option) any later version.
 * 
 * This program 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 this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 */
/*
 * MosP - Mind Open Source Project         http://www.mosp.jp/
 * Copyright (C) 1987-2008 MIND Co., Ltd.  http://www.e-mind.co.jp/
 * 
 * This program 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 2
 * of the License, or (at your option) any later version.
 * 
 * This program 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 this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 */
package jp.mosp.payroll.common.action;

import java.io.Serializable;
import java.sql.SQLException;
import java.util.Comparator;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import jp.mosp.common.CommonConst;
import jp.mosp.common.common.BaseVo;
import jp.mosp.common.common.MospConst;
import jp.mosp.common.common.MospException;
import jp.mosp.common.common.MospUtility;
import jp.mosp.common.common.VoInterface;
import jp.mosp.human.dao.MKihonDao;
import jp.mosp.payroll.dao.MExportPaymentDao;
import jp.mosp.payroll.dao.PaymentListDao;
import jp.mosp.payroll.dao.PhPaymentDao;
import jp.mosp.payroll.dao.PmDetailPaDao;
import jp.mosp.payroll.dao.PmDetailPbDao;
import jp.mosp.payroll.dao.PmDetailPdDao;
import jp.mosp.payroll.dao.PmDetailPsDao;
import jp.mosp.payroll.dao.PmDetailPtDao;
import jp.mosp.payroll.dto.DetailMoneyDto;
import jp.mosp.payroll.dto.DetailPaDto;
import jp.mosp.payroll.dto.DetailPbDto;
import jp.mosp.payroll.dto.DetailPdDto;
import jp.mosp.payroll.dto.DetailTimeDto;
import jp.mosp.payroll.dto.MExportPaymentDto;
import jp.mosp.payroll.dto.PaymentListDto;
import jp.mosp.payroll.payment.vo.PaymentReportVo;
import jp.mosp.payroll.base.Bonus;
import jp.mosp.payroll.base.Payment;
import jp.mosp.payroll.base.PayrollAction;
import jp.mosp.payroll.base.PayrollConst;
import jp.mosp.payroll.bonus.dao.BonusListDao;
import jp.mosp.payroll.bonus.dao.PdBonAllowanceDao;
import jp.mosp.payroll.bonus.dao.PdBonDeductionDao;
import jp.mosp.payroll.bonus.dao.PdBonSumDao;
import jp.mosp.payroll.bonus.dao.PhBounsDao;
import jp.mosp.payroll.bonus.dao.PmDetailBaDao;
import jp.mosp.payroll.bonus.dao.PmDetailBdDao;
import jp.mosp.payroll.bonus.dao.PmDetailBsDao;
import jp.mosp.payroll.bonus.dto.BonusListDto;
import jp.mosp.payroll.bonus.dto.PhBounsDto;
import jp.mosp.payroll.bonus.dto.PmDetailBaDto;
import jp.mosp.payroll.bonus.dto.PmDetailBdDto;
import jp.mosp.payroll.bonus.dto.PmDetailBsDto;
import jp.mosp.payroll.common.vo.ExportCardVo;


public class ExportCardAction extends PayrollAction {

	// コマンド
	private static final String CMD_EXPORT_SHOW 	= "P9003";
	private static final String CMD_EXPORT_DATA	= "P9006";

	// フィールド

	/**
	 * コンストラクタ
	 */
	public ExportCardAction() {
		super();
	}
	
	/* (non-Javadoc)
	 * @see jp.mosp.common.common.BaseAction#getSpecificVo()
	 */
	@Override
	protected BaseVo getSpecificVo() {
		return new PaymentReportVo();
	}
	
	/**
	 * アクション
	 */
	public void action() throws Exception {		
		// DBコネクション取得
		getConnection();
		// 計算管理権限確認
		confirmCalculateAuth();
		// VOの取得
		ExportCardVo vo = getInitVo();
		init(vo);
		// コマンド毎の処理
		if (cmd.equals(CMD_EXPORT_SHOW)) {
			// 表示
			show(vo);
		} else if (cmd.equals(CMD_EXPORT_DATA)) {
			// エクスポート
			export(vo);
		} 
		else {
			throw new MospException(MospConst.EX_CMD_INVALID);
		}
	}

	protected ExportCardVo getInitVo() {
		return new ExportCardVo();
	}
	
	protected PaymentReportVo getPayReportVo() {
		return new PaymentReportVo();
	}
	
	/**
	 * 初期処理
	 * @param vo	対象VO
	 */
	protected void init(ExportCardVo vo) {
		vo.initVo(cfg, msg, cmd, aspUser, user);
		// VO及びフォワード先URLの設定
		setVo(vo);
		setUrl(vo.getRetUrl());
		session.setAttribute(MospConst.ATT_FORMER_VO, vo);
		// プルダウンリスト
		Date date = util.getSystemDate();
		vo.aryPltYear 	= util.getYearArray(MospUtility.getYear (date), 4, 1);
		vo.aryPltMonth	= util.getMonthArray();
		vo.aryPltDay    = util.getDayArray();
	}

	/**
	 * 表示
	 * @param vo			対象VO
	 * @throws Exception
	 */
	protected void show(ExportCardVo vo) throws Exception {
		Date date = util.getSystemDate();
		vo.setPltYear(String.valueOf(MospUtility.getYear(date)));
		vo.setPltMonth(String.valueOf(MospUtility.getMonth(date)));
		vo.setPltDay(String.valueOf(MospUtility.getDay(date)));
		// 検索
		session.removeAttribute(MospConst.ATT_DTO);
		searchExportCard(vo);
		vo.setPageButton();
		sortList(vo);
	}

	/**
	 * エクスポート
	 * @param vo			対象VO
	 * @throws Exception
	 */
	protected void export(ExportCardVo vo) throws Exception {
		// パラメータ取得
		vo.setParams(request);
		// VOに情報をセット
		// Export名称
		vo.setTxtEName(key1);
		// 対象ファイルID
		vo.setTxtEFile(key2);	
		// 出力
		String fileNameType = "";
		if (key2.equals(PayrollConst.NAM_DATA_M_PAYROLL)) {
			fileNameType = PayrollConst.NAM_FILE_PAYROLL;
		} else {
			fileNameType = PayrollConst.NAM_FILE_BONUS;
		}
		StringBuffer fileName = new StringBuffer();
		fileName.append(vo.getPltYear());
		fileName.append(CommonConst.FILE_NAME_SEPARATOR);
		fileName.append(vo.getPltMonth());
		fileName.append(CommonConst.FILE_NAME_SEPARATOR);
		fileName.append(fileNameType);
		fileName.append(CommonConst.FILE_COMMON_CSV);
		// DBコネクション取得
		if (conn == null) {
			getConnection();
		}
		// 選択項目取得
		MExportPaymentDao mExportDao = new MExportPaymentDao();
		mExportDao.initDao(cfg, cmd, aspUser, user, conn);
		List<MExportPaymentDto> listSelected = mExportDao.findForCondition(vo.getTxtEName(), vo.getTxtEFile());
		request.setAttribute(MospConst.ATT_FILE_NAME  , fileName.toString());
		request.setAttribute(MospConst.ATT_FILE_OBJECT, makeHumanData(listSelected, vo.getTxtEFile(), vo.getPltYear(), vo.getPltMonth(), vo.getPltDay(), vo));
		// 処理シーケンスを発行しない。
		setNeedProcSeq(false);
	}

	/**
	 * 給与情報作成
	 * @param vo 対象VO
	 * @return 給与情報文字列
	 * @throws Exception 
	 * @throws IllegalAccessException 
	 * @throws SQLException 
	 * @throws Exception
	 */
	protected StringBuffer makeHumanData(List<MExportPaymentDto> listSelected, String txtEFile, String pltYear, String pltMonth, String pltDay, VoInterface vo) throws Exception {
		// 帳票作成準備
		StringBuffer sb = new StringBuffer();
		// ヘッダー情報設定
		sb.append(appendHeader(listSelected));
		// データ追記
		if (key2.equals(PayrollConst.NAM_DATA_M_PAYROLL)) {
			sb.append(appendData(listSelected, txtEFile, pltYear, pltMonth, vo));
		} else {
			sb.append(appendDataBonus(listSelected, txtEFile, pltYear, pltMonth, pltDay, vo));
		}
		return sb;
	}

	/**
	 * ヘッダー情報設定
	 * @param listSelected		対象選択マスタ
	 * @param sb				対象データ
	 * @return
	 * <p>
	 * 選択マスタのヘッダー情報
	 * <p>
	 * @throws Exception
	 */
	private StringBuffer appendHeader(
			List<MExportPaymentDto> listSelected
	) throws Exception {
		StringBuffer sb = new StringBuffer();
		// ヘッダー情報設定
		for (int i = 0; i < listSelected.size(); i++) {
			MExportPaymentDto ExportDto = (MExportPaymentDto)listSelected.get(i);
			// ヘッダー情報設定
			sb.append(getCsvData(getEFnameItem(ExportDto.getEFname(), 3)));
			// セパレータ設定
			if (i == listSelected.size() - 1) {
				sb.append(CommonConst.STR_CSV_NEW_LINE);
			} else {
				sb.append(CommonConst.STR_CSV_SEPARATOR);
			}
		}
		return sb;
	}

	/**
	 * データ情報取得(給与)
	 * @param txtEFile		対象テーブル
	 * @param pltYear		対象年
	 * @param pltMonth		対象月
	 * @return
	 * <p>
	 * 条件によるテーブルデータ
	 * </p>
	 * @throws Exception
	 */
	protected StringBuffer appendData(
			List<MExportPaymentDto> listSelected,
			String txtEFile,
			String pltYear,
			String pltMonth,
			VoInterface vo
	) throws Exception {
		StringBuffer sb = new StringBuffer();
		PaymentReportVo PaymentReport_Vo = getPayReportVo();
		PaymentReport_Vo.setPltYear(Integer.valueOf(pltYear));
		PaymentReport_Vo.setPltMonth(Integer.valueOf(pltMonth));
		//対象年月取得
		Date targetMonth = getDate(PaymentReport_Vo.getPltYear(), PaymentReport_Vo.getPltMonth(), PayrollConst.TIME_DEFAULT_DAY);
		// DAO準備
		PaymentListDao dao = new PaymentListDao(cfg, cmd, aspUser, user, conn);
		//検索処理
		List<PaymentListDto> list = dao.findForPayment(targetMonth);
		//給与情報項目検索
		PmDetailPaDao daoPa = new PmDetailPaDao(cfg, cmd, aspUser, user, conn);
		List<DetailPaDto> listdtoPa = daoPa.findAll();
		PmDetailPbDao daoPb = new PmDetailPbDao(cfg, cmd, aspUser, user, conn);
		List<DetailPbDto> listdtoPb = daoPb.findAll();
		PmDetailPdDao daoPd = new PmDetailPdDao(cfg, cmd, aspUser, user, conn);
		List<DetailPdDto> listdtoPd = daoPd.findAll();
		PmDetailPsDao daoPs = new PmDetailPsDao(cfg, cmd, aspUser, user, conn);
		List<DetailMoneyDto> listdtoPs = daoPs.findAll();
		PmDetailPtDao daoPt = new PmDetailPtDao(cfg, cmd, aspUser, user, conn);
		List<DetailTimeDto> listdtoPt = daoPt.findAll();
		sb.append(appendData(list, listdtoPa, listdtoPb, listdtoPd, listdtoPs, listdtoPt, listSelected, targetMonth));
		return sb;
	}
	
	/**
	 * データ情報取得(賞与)
	 * @param txtEFile		対象テーブル
	 * @param pltYear		対象年
	 * @param pltMonth		対象月
	 * @param pltDay		対象日
	 * @return
	 * <p>
	 * 条件によるテーブルデータ
	 * </p>
	 * @throws Exception
	 */
	protected StringBuffer appendDataBonus(
			List<MExportPaymentDto> listSelected,
			String txtEFile,
			String pltYear,
			String pltMonth,
			String pltDay,
			VoInterface vo
	) throws Exception {
		StringBuffer sb = new StringBuffer();
		PaymentReportVo PaymentReport_Vo = getPayReportVo();
		PaymentReport_Vo.setPltYear(Integer.valueOf(pltYear));
		PaymentReport_Vo.setPltMonth(Integer.valueOf(pltMonth));
		PaymentReport_Vo.setPltDay(Integer.valueOf(pltDay));
		//対象年月日取得
		Date targetMonth = getDate(PaymentReport_Vo.getPltYear(), PaymentReport_Vo.getPltMonth(), PaymentReport_Vo.getPltDay());
		//DAO準備
		BonusListDao dao = new BonusListDao(cfg, cmd, aspUser, user, conn);
		//検索処理
		List<BonusListDto> list = dao.findForPayment(targetMonth);
		//賞与情報項目検索
		PmDetailBaDao daoBa = new PmDetailBaDao(cfg, cmd, aspUser, user, conn);
		List<PmDetailBaDto> listdtoBa = daoBa.findAll();
		PmDetailBdDao daoBd = new PmDetailBdDao(cfg, cmd, aspUser, user, conn);
		List<PmDetailBdDto> listdtoBd = daoBd.findAll();
		PmDetailBsDao daoBs = new PmDetailBsDao(cfg, cmd, aspUser, user, conn);
		List<PmDetailBsDto> listdtoBs = daoBs.findAll();
		sb.append(appendDataBonus(list, listdtoBa, listdtoBd, listdtoBs, listSelected, targetMonth));
		return sb;
	}
	
	
	/**
	 * データ情報設定
	 * @param sb
	 * @param rs
	 * @param listSelected
	 * @return
	 * @throws Exception
	 */
	protected StringBuffer appendData(
			List<PaymentListDto> list,
			List<DetailPaDto> listdtoPa,
			List<DetailPbDto> listdtoPb,
			List<DetailPdDto> listdtoPd,
			List<DetailMoneyDto> listdtoPs,
			List<DetailTimeDto> listdtoPt,
			List<MExportPaymentDto> listSelected,
			Date targetMonth
	) throws Exception {
		StringBuffer sb = new StringBuffer();
		
		for (Iterator<PaymentListDto> it = list.iterator(); it.hasNext();) {
			PaymentListDto dto = it.next();
			Payment payment = getPayment(dto.getKCode(), targetMonth);
			
			for (int i = 0; i < listSelected.size(); i++) {
				
				MExportPaymentDto ExportDto = (MExportPaymentDto)listSelected.get(i);
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(PhPaymentDao.COL_KCODE)){
					sb.append(getCsvData(dto.getKCode()));	// 社員コード
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(MKihonDao.COL_SIMEI)){
					sb.append(getCsvData(dto.getSimei()));	// 氏名
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(MKihonDao.COL_JCODE)){
					sb.append(getCsvData(dto.getJCode()));	// 事業所コード
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(MKihonDao.COL_SCODE)){
					sb.append(getCsvData(dto.getSCode()));	// 所属コード
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(MKihonDao.COL_YCODE)){
					sb.append(getCsvData(dto.getYCode()));	// 役職コード
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(PhPaymentDao.COL_CALC_MONTH)){
					sb.append(getCsvData(payment.getCalcMonthStr()));	// 計算年月
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(PhPaymentDao.COL_PAY_DATE)){
					sb.append(getCsvData(payment.getPayDate()));	// 支給日
					sb.append(appendConma(i, listSelected));
					continue;
				}
				for(int j = 0; j < listdtoPt.size(); j++) {
					DetailTimeDto dtoTime = listdtoPt.get(j);
					if (getEFnameItem(ExportDto.getEFname(), 3).equals(dtoTime.getDetailName())) {
						sb.append(getCsvData(payment.getTimeAmount(listdtoPt.get(j).getDetailCode())));
						break;
					} else {
						continue;
					}
					
				}
				
				for(int j = 0; j < listdtoPa.size(); j++) {
					DetailPaDto dtoPa = listdtoPa.get(j);
					if (getEFnameItem(ExportDto.getEFname(), 3).equals(dtoPa.getDetailName())) {
						sb.append(getCsvData(payment.getAllowanceAmount(listdtoPa.get(j).getDetailCode())));
						break;
					} else {
						continue;
					}
					
				}
				
				for(int j = 0; j < listdtoPb.size(); j++) {
					DetailPbDto dtoPb = listdtoPb.get(j);
					if (getEFnameItem(ExportDto.getEFname(), 3).equals(dtoPb.getDetailName())) {
						sb.append(getCsvData(payment.getBreakdownAmount(listdtoPb.get(j).getDetailCode())));
						break;
					} else {
						continue;
					}
					
				}
				
				for(int j = 0; j < listdtoPd.size(); j++) {
					DetailPdDto dtoPd = listdtoPd.get(j);
					if (getEFnameItem(ExportDto.getEFname(), 3).equals(dtoPd.getDetailName())) {
						sb.append(getCsvData(payment.getDeductionAmount(listdtoPd.get(j).getDetailCode())));
						break;
					} else {
						continue;
					}
					
				}
				
				for(int j = 0; j < listdtoPs.size(); j++) {
					DetailMoneyDto dtoPs = listdtoPs.get(j);
					if (getEFnameItem(ExportDto.getEFname(), 3).equals(dtoPs.getDetailName())) {
						sb.append(getCsvData(payment.getSumAmount(listdtoPs.get(j).getDetailCode())));
						break;
					} else {
						continue;
					}
					
				}
				sb.append(appendConma(i, listSelected));
				
			}
			
		}
		return sb;
	}
	
	/**
	 * データ情報設定(賞与)
	 * @param sb
	 * @param rs
	 * @param listSelected
	 * @return
	 * @throws Exception
	 */
	protected StringBuffer appendDataBonus(
			List<BonusListDto> list,
			List<PmDetailBaDto> listdtoBa,
			List<PmDetailBdDto> listdtoBd,
			List<PmDetailBsDto> listdtoBs,
			List<MExportPaymentDto> listSelected,
			Date targetMonth
	) throws Exception {
		StringBuffer sb = new StringBuffer();
		for (Iterator<BonusListDto> it = list.iterator(); it.hasNext();) {
			BonusListDto dto = it.next();
			Bonus bouns = getBouns(dto.getKCode(), targetMonth);
			
			for (int i = 0; i < listSelected.size(); i++) {
				
				MExportPaymentDto ExportDto = (MExportPaymentDto)listSelected.get(i);
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(PhPaymentDao.COL_KCODE)){
					sb.append(getCsvData(dto.getKCode()));	// 社員コード
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(MKihonDao.COL_SIMEI)){
					sb.append(getCsvData(dto.getSimei()));	// 氏名
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(MKihonDao.COL_JCODE)){
					sb.append(getCsvData(dto.getJCode()));	// 事業所コード
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(MKihonDao.COL_SCODE)){
					sb.append(getCsvData(dto.getSCode()));	// 所属コード
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(MKihonDao.COL_YCODE)){
					sb.append(getCsvData(dto.getYCode()));	// 役職コード
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(PhPaymentDao.COL_CALC_MONTH)){
					sb.append(getCsvData(bouns.getCalcMonthStr()));	// 計算年月
					sb.append(appendConma(i, listSelected));
					continue;
				}
				if(getEFnameItem(ExportDto.getEFname(), 2).equals(PhPaymentDao.COL_PAY_DATE)){
					sb.append(getCsvData(bouns.getPayDate()));	// 支給日
					sb.append(appendConma(i, listSelected));
					continue;
				}
				for(int j = 0; j < listdtoBa.size(); j++) {
					PmDetailBaDto dtoBa = listdtoBa.get(j);
					if (getEFnameItem(ExportDto.getEFname(), 3).equals(dtoBa.getDetailName())) {
						sb.append(getCsvData(bouns.getAllowanceAmount(listdtoBa.get(j).getDetailCode())));
						break;
					} else {
						continue;
					}
					
				}
				
				for(int j = 0; j < listdtoBd.size(); j++) {
					PmDetailBdDto dtoBd = listdtoBd.get(j);
					if (getEFnameItem(ExportDto.getEFname(), 3).equals(dtoBd.getDetailName())) {
						sb.append(getCsvData(bouns.getDeductionAmount(listdtoBd.get(j).getDetailCode())));
						break;
					} else {
						continue;
					}
					
				}
				
				for(int j = 0; j < listdtoBs.size(); j++) {
					PmDetailBsDto dtoBs = listdtoBs.get(j);
					if (getEFnameItem(ExportDto.getEFname(), 3).equals(dtoBs.getDetailName())) {
						sb.append(getCsvData(bouns.getSumAmount(listdtoBs.get(j).getDetailCode())));
						break;
					} else {
						continue;
					}
					
				}
				sb.append(appendConma(i, listSelected));
			}
		}
		return sb;
	}
	
	/**
	 * 給与伝票インスタンスを取得、設定する。<br><br>
	 * kCode、calcDateをキーとして給与情報を取得し、{@link #payment}に格納する。
	 * @param kCode     社員コード
	 * @param calcMonth 計算年月
	 * @return 給与伝票
	 * @throws NoSuchFieldException 
	 * @throws IllegalAccessException 
	 * @throws SQLException 
	 */
	protected Bonus getBouns(
			String kCode, Date calcMonth
	) throws SQLException, IllegalAccessException, NoSuchFieldException {
		PhBounsDto header = new PhBounsDao(
				cfg, cmd, aspUser, user, conn).findForKey(kCode, calcMonth);
		if (header == null) {
			return null;
		}
		return new Bonus(
				header,
				new PmDetailBaDao(cfg, cmd, aspUser, user, conn).findForSlip(header.getSlipCode()),
				new PmDetailBdDao(cfg, cmd, aspUser, user, conn).findForSlip(header.getSlipCode()),
				new PmDetailBsDao(cfg, cmd, aspUser, user, conn).findForSlip(header.getSlipCode()),
				new PdBonAllowanceDao(cfg, cmd, aspUser, user, conn).find(kCode, calcMonth),
				new PdBonDeductionDao(cfg, cmd, aspUser, user, conn).find(kCode, calcMonth),
				new PdBonSumDao      (cfg, cmd, aspUser, user, conn).find(kCode, calcMonth)
				
		);
	}
	
	
	/**
	 * データ情報追記
	 * @param sb
	 * @param rs
	 * @param listSelected
	 * @return
	 * @throws Exception
	 */
	protected StringBuffer appendConma(
			int i,
			List<MExportPaymentDto> listSelected
	) throws Exception {
		StringBuffer sb = new StringBuffer();
			if (i == listSelected.size() - 1) {
				sb.append(PayrollConst.STR_CSV_NEW_LINE);
			} else {
				sb.append(PayrollConst.STR_CSV_SEPARATOR);
			}
		return sb;
	}
	
	/**
	 * リスト検索
	 * @param vo Voインスタンス
	 * @throws Exception
	 */
	protected void searchExportCard(ExportCardVo vo) throws Exception {
		//DBコネクション取得
		getConnection();
		MExportPaymentDao dao = new MExportPaymentDao();
		dao.initDao(cfg, cmd, aspUser, user, conn);
		//対象ファイルID(画面ボタンの制御)
		vo.setTxtEFile(key1);	
		if (!key1.equals(PayrollConst.FB_OUTPUT_DETAIL_BONUS)) {
			//給与・賞与含め取得する
			vo.setFields(dao.findForCondition());
		} else {
			//賞与分のみを取得する
			vo.setFields(dao.findForConditionBonus());
		}
		
		//対象がなかった場合のメッセージ設定
		if (vo.getEscAryEName().length == 0) {
			vo.addErrMessage(MospUtility.getMessage(msg, MospConst.MSG_NO_DATA, ""));
		}
	}

	/**
	 * ソート(VO内のキー情報でソート)
	 * @param vo ソート対象Listを含むVO
	 * @throws MospException
	 */
	protected void sortList(ExportCardVo vo) throws MospException {
		vo.sortList(getComparator(vo.getFormerKey(), vo));
		vo.setFields(vo.getList());
	}

	/**
	 * 比較クラス取得
	 * @param key ソートキー
	 * @param vo ソート対象Listを含むVO
	 * @throws MospException
	 */
	protected Comparator<Object> getComparator(String key, ExportCardVo vo) throws MospException {
		Comparator<Object> comp = null;
		if (key.equals(vo.KEY_E_NAME)) {
			comp = new CompExportName();
		} else {
			throw new MospException(MospConst.EX_SORTKEY_INVALID);
		}
		return comp;
	}

	/**
	 * 名称による比較クラス
	 */
	protected static class CompExportName implements Comparator<Object>, Serializable {
		private static final long serialVersionUID = -5375772027347639889L;
		public int compare(Object obj1, Object obj2) {
			MExportPaymentDto dto1 = (MExportPaymentDto)obj1;
			MExportPaymentDto dto2 = (MExportPaymentDto)obj2;
			return dto1.getEName().compareTo(dto2.getEName());
		}
	}

}
