package com.minpay.common.service.impl;


import java.util.List;
import java.util.Map;

import com.minpay.common.constant.Constant;
import com.minpay.common.format.IFormatService;
import com.minpay.common.service.IDianwangService;
import com.minpay.common.util.CommonUtil;
import com.minpay.db.table.mapper.*;
import com.minpay.db.table.model.*;
import com.startup.minpay.frame.exception.MINBusinessException;
import com.startup.minpay.frame.jdbc.MINRowBounds;
import com.startup.minpay.frame.service.base.IMINDataBaseService;
import com.startup.minpay.frame.service.base.Service;
import com.startup.minpay.frame.target.MINComponent;

import net.sf.json.JSONArray;

/**
 * 电网公共查询
 * @author 86159
 *
 */
@MINComponent
public class DianwangServiceImpl implements IDianwangService {
	private IMINDataBaseService db;

	@Override
	public List queryFileInfDetail(Map<String, String> param, MINRowBounds rows) throws MINBusinessException {
		db = Service.lookup(IMINDataBaseService.class);
		
		String fileType = param.get("fileType");
		String fileId = param.get("fileId");
		String fileIdListStr = param.get("fileIdListStr");
    	// 台区停电
    	if (Constant.FILE_DETAIL_TYPE_00.equals(fileType)) {
    		DwFileDetail00Example fileDetail00Example = new DwFileDetail00Example();
    		// 单个原始文件id查询
    		if (!CommonUtil.isEmpty(fileId)) {
    			fileDetail00Example.createCriteria().andFileIdEqualTo(fileId);
    		// 多个原始文件id查询
    		} else if (!CommonUtil.isEmpty(fileIdListStr)) {
    			JSONArray fileIdList = JSONArray.fromObject(fileIdListStr);
    			fileDetail00Example.createCriteria().andFileIdIn(fileIdList);
    		}
    		
    		fileDetail00Example.setOrderByClause("CAST(DFD0_NUMBER AS SIGNED)");
    		List<DwFileDetail00> resList = db.selectByExample(DwFileDetail00Mapper.class, fileDetail00Example, rows);
    		
    		resList = Service.lookup(IFormatService.class).formatDate(resList, "date");
    		resList = Service.lookup(IFormatService.class).formatDateTime(resList, "startTime", "endTime");
    		return resList;
    	// 终端投托运
    	} else if (Constant.FILE_DETAIL_TYPE_01.equals(fileType)) {
    		DwFileDetail01Example fileDetail01Example = new DwFileDetail01Example();
    		fileDetail01Example.createCriteria().andFileIdEqualTo(fileId);
    		List<DwFileDetail01> resList = db.selectByExample(DwFileDetail01Mapper.class, fileDetail01Example, rows);
    		resList = Service.lookup(IFormatService.class).formatDateTime(resList, "excelTytime");
    		return resList;
    	} else if (Constant.FILE_DETAIL_TYPE_02.equals(fileType)) {
    		DwFileDetail02Example fileDetail02Example = new DwFileDetail02Example();
    		fileDetail02Example.createCriteria().andFileIdEqualTo(fileId);
    		List<DwFileDetail02> resList = db.selectByExample(DwFileDetail02Mapper.class, fileDetail02Example, rows);
    		resList = Service.lookup(IFormatService.class).formatDateTime(resList, "beginTime", "endTime");
    		return resList;
    	}else if(Constant.FILE_DETAIL_TYPE_03.equals(fileType)){
    		DwFileDetail03Example fileDetail03Example = new DwFileDetail03Example();
    		fileDetail03Example.createCriteria().andFileIdEqualTo(fileId);
    		List<DwFileDetail03> resList = db.selectByExample(DwFileDetail03Mapper.class, fileDetail03Example, rows);
    		resList = Service.lookup(IFormatService.class).formatDate(resList, "sjrq");
    		return resList;
    	}else if(Constant.FILE_DETAIL_TYPE_04.equals(fileType)){
    		DwFileDetail04Example fileDetail04Example = new DwFileDetail04Example();
    		fileDetail04Example.createCriteria().andFileIdEqualTo(fileId);
    		List<DwFileDetail04> resList = db.selectByExample(DwFileDetail04Mapper.class, fileDetail04Example, rows);
    		resList = Service.lookup(IFormatService.class).formatDate(resList, "sjrq");
    		return resList;
    	} else if (Constant.FILE_DETAIL_TYPE_05.equals(fileType)) {
    		DwFileDetail05Example fileDetail05Example = new DwFileDetail05Example();
    		fileDetail05Example.createCriteria().andFileIdEqualTo(fileId);
    		List<DwFileDetail05> resList = db.selectByExample(DwFileDetail05Mapper.class, fileDetail05Example, rows);
    		return resList;
    	} else if (Constant.FILE_DETAIL_TYPE_06.equals(fileType)) {
			DwFileDetail07Example fileDetail07Example = new DwFileDetail07Example();
			fileDetail07Example.createCriteria().andFileIdEqualTo(fileId);
			List<DwFileDetail07> resList = db.selectByExample(DwFileDetail07Mapper.class, fileDetail07Example, rows);
			return resList;
		} else if (Constant.FILE_DETAIL_TYPE_07.equals(fileType)) {//客户信息
			DwFileDetail08Example fileDetail08Example = new DwFileDetail08Example();
			fileDetail08Example.createCriteria().andFileIdEqualTo(fileId);
			List<DwFileDetail08> resList = db.selectByExample(DwFileDetail08Mapper.class, fileDetail08Example, rows);
			return resList;
		} else if (Constant.FILE_DETAIL_TYPE_08.equals(fileType)) {//配变过重载
			DwFileDetail09Example fileDetail09Example = new DwFileDetail09Example();
			fileDetail09Example.createCriteria().andFileIdEqualTo(fileId);
			fileDetail09Example.setOrderByClause("dfd9_sequ");
			List<DwFileDetail09> resList = db.selectByExample(DwFileDetail09Mapper.class, fileDetail09Example, rows);
			return resList;
		} else if (Constant.FILE_DETAIL_TYPE_09.equals(fileType)) {//线路过重载
			DwFileDetail10Example fileDetail10Example = new DwFileDetail10Example();
			fileDetail10Example.createCriteria().andFileIdEqualTo(fileId);
			fileDetail10Example.setOrderByClause("dfd10_sequ");
			List<DwFileDetail10> resList = db.selectByExample(DwFileDetail10Mapper.class, fileDetail10Example, rows);
			return resList;
		}
    	return null;
	}
	
}