package com.javaweb.platform.service.impl;

import java.io.InputStream;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.ss.formula.eval.ErrorEval;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellValue;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import com.javaweb.common.utils.DateUtils;
import com.javaweb.common.utils.IdGenerate;
import com.javaweb.common.utils.StringUtils;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;

import com.javaweb.platform.mapper.ProjectInfoMapper;
import com.javaweb.platform.domain.ProjectInfo;
import com.javaweb.platform.service.IProjectInfoService;
import com.javaweb.common.core.text.Convert;

/**
 * 项目信息Service业务层处理
 * 
 * @author zmk
 * @date 2022-03-08
 */
@Service
public class ProjectInfoServiceImpl implements IProjectInfoService 
{
    @Autowired
    private ProjectInfoMapper projectInfoMapper;

    /**
     * 查询项目信息
     * 
     * @param id 项目信息ID
     * @return 项目信息
     */
    @Override
    public ProjectInfo selectProjectInfoById(String id)
    {
        return projectInfoMapper.selectProjectInfoById(id);
    }

    /**
     * 查询项目信息列表
     * 
     * @param projectInfo 项目信息
     * @return 项目信息
     */
    @Override
    public List<ProjectInfo> selectProjectInfoList(ProjectInfo projectInfo)
    {
        return projectInfoMapper.selectProjectInfoList(projectInfo);
    }

    /**
     * 新增项目信息
     * 
     * @param projectInfo 项目信息
     * @return 结果
     */
    @Override
    public int insertProjectInfo(ProjectInfo projectInfo)
    {
        projectInfo.setCreateTime(DateUtils.getNowDate());
        return projectInfoMapper.insertProjectInfo(projectInfo);
    }

    /**
     * 修改项目信息
     * 
     * @param projectInfo 项目信息
     * @return 结果
     */
    @Override
    public int updateProjectInfo(ProjectInfo projectInfo)
    {
        projectInfo.setUpdateTime(DateUtils.getNowDate());
        return projectInfoMapper.updateProjectInfo(projectInfo);
    }

    /**
     * 删除项目信息对象
     * 
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    @Override
    public int deleteProjectInfoByIds(String ids)
    {
        return projectInfoMapper.deleteProjectInfoByIds(Convert.toStrArray(ids));
    }

    /**
     * 删除项目信息信息
     * 
     * @param id 项目信息ID
     * @return 结果
     */
    @Override
    public int deleteProjectInfoById(String id)
    {
        return projectInfoMapper.deleteProjectInfoById(id);
    }

	@Override
	public List<ProjectInfo> selectByPolygon(String polygon) {

		return projectInfoMapper.selectByPolygon(polygon);
	}

	@Override
	public List<ProjectInfo> selectBynCircle(Double lat, Double lng, Double radius) {

		return projectInfoMapper.selectBynCircle(lat, lng, radius);
	}
	
	
	@Override
	public String importData(MultipartFile file, boolean updateSupport) {
		
		String string = "";
		List<ProjectInfo> docInfos = new ArrayList<>();
		try {
			InputStream inputStream = file.getInputStream();
			Workbook wb = WorkbookFactory.create(inputStream);
			Sheet sheet = wb.getSheetAt(0);// 打开第1个工作薄

			docInfos = getProjectInfo(sheet);

		} catch (Exception e) {

			string = "读取信息错误：" + e.toString();
			return string;
		}

		string = insertTemplateData(docInfos);

		return string;
	}
	
	private String insertTemplateData(List<ProjectInfo> infos){
		try {
			for (ProjectInfo info : infos) {
				insertProjectInfo(info);	
			}
		} catch (Exception e) {
			return e.toString();
		}

		return "导入完毕";
		
	}
	
	//获取表格数据
	private List<ProjectInfo> getProjectInfo(Sheet sheet){
		int lastRowNo = sheet.getLastRowNum() + 1;// 假如有10行数据
		List<ProjectInfo> list = new ArrayList<>();
		try {
			for (int i = 1; i < lastRowNo; i++) {
				ProjectInfo info = new ProjectInfo();
				Row row = sheet.getRow(i);
				
				String address = String.valueOf(getCellValue(row, 11));
				if(StringUtils.isEmpty(address)){
				  break;
				}
				
				String projectname = String.valueOf(getCellValue(row, 1));				
				info.setProjectName(projectname);
				
				String ConstructionUnit = String.valueOf(getCellValue(row, 2));				
				info.setConstructionUnit(ConstructionUnit);
				
				String ServiceUnit = String.valueOf(getCellValue(row, 3));				
				info.setServiceUnit(ServiceUnit);
				
				String ProjectLeader = String.valueOf(getCellValue(row, 6));				
				info.setProjectLeader(ProjectLeader);
						
				info.setAddress(address);
				
				info.setId(IdGenerate.nextId());
		
			    list.add(info);
			}

		} catch (Exception e) {
			e.printStackTrace();
			throw e;
		}
		return list;
	}
	
	private Date DateTimeFormat(String str){
		if(StringUtils.isEmpty(str)){
			return null;
		}
		
		return DateUtils.parseDate(str.trim());
		
	}
	
	/**
	 * 获取单元格数据
	 * 
	 * @param row
	 * @param column
	 * @return
	 */
	@SuppressWarnings("deprecation")
	private Object getCellValue(Row row, int column) {
		if (row == null) {
			return row;
		}
		Object val = "";
		try {
			Cell cell = row.getCell(column);
			if (cell != null) {
				if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
					val = cell.getNumericCellValue();
					if (HSSFDateUtil.isCellDateFormatted(cell)) {
						val = DateUtil.getJavaDate((Double) val); // POI Excel
																	// 日期格式转换
					} else {
						if ((Double) val % 1 > 0) {
							val = new DecimalFormat("0.000000").format(val);
						} else {
							val = new DecimalFormat("0").format(val);
						}
					}
				} else if (cell.getCellType() == Cell.CELL_TYPE_STRING) {
					val = cell.getStringCellValue();

				} else if (cell.getCellType() == Cell.CELL_TYPE_FORMULA) {
					try {
						val = cell.getStringCellValue();
					} catch (Exception e) {
						FormulaEvaluator evaluator = cell.getSheet().getWorkbook().getCreationHelper()
								.createFormulaEvaluator();
						evaluator.evaluateFormulaCell(cell);
						CellValue cellValue = evaluator.evaluate(cell);
						switch (cellValue.getCellType()) {
						case Cell.CELL_TYPE_NUMERIC:
							val = cellValue.getNumberValue();
							break;
						case Cell.CELL_TYPE_STRING:
							val = cellValue.getStringValue();
							break;
						case Cell.CELL_TYPE_BOOLEAN:
							val = cellValue.getBooleanValue();
							break;
						case Cell.CELL_TYPE_ERROR:
							val = ErrorEval.getText(cellValue.getErrorValue());
							break;
						default:
							val = cell.getCellFormula();
						}
					}
				} else if (cell.getCellType() == Cell.CELL_TYPE_BOOLEAN) {
					val = cell.getBooleanCellValue();
				} else if (cell.getCellType() == Cell.CELL_TYPE_ERROR) {
					val = cell.getErrorCellValue();
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
			return val;
		}
		return val;
	}

	@Override
	public List<ProjectInfo> selectByPolygonContains(String polygon) {
		return projectInfoMapper.selectByPolygonContains(polygon);
	}
}