package com.northglass.service.glass;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;

import com.northglass.constants.StateConstants.GlassArrangeState;
import com.northglass.constants.StateConstants.ManufactureBatchState;
import com.northglass.constants.StateConstants.sendGlassState;
import com.northglass.entity.CardNumber;
import com.northglass.entity.Glass;
import com.northglass.entity.GlassOrder;
import com.northglass.entity.SingalGlass;
import com.northglass.repository.CardNumberDao;
import com.northglass.repository.GlassDao;
import com.northglass.repository.ManufactureBatchDao;
import com.northglass.repository.SingalGlassDao;
import com.northglass.util.ExcelUtil;

@Component
@Transactional
public class GlassService {

	private static final Logger LOGGER = LoggerFactory.getLogger(GlassService.class);

	private static final int DATA_START_ROW = 1;

	private static final int MANUFACTURER_COLUMN = 2;
	private static final int APART_ID_COLUMN = 4;
	private static final int ORDER_NUMBER_COLUMN = 6;
	private static final int PIECE_SIGN_COLUMN = 7;
	private static final int PIECE_COLUMN = 8;
	private static final int LENGTH_COLUMN = 11;
	private static final int WIDTH_COLUMN = 10;
	private static final int CUSTOMER_COLUMN = 20;
	private static final int APPLICATION_COLUMN = 21;
	private static final int FLOOR_NUMBER = 22;
	private static final int PRODUCTION_COLUMN = 23;
	private static final int SINGLE_COLUMN = 24;
	private static final int REMARK_COLUMN = 29;

	private static final String COLOR = "Low_E";

	private String glasscolor = "";

	@Autowired
	private GlassDao glassDao;
	
	@Autowired
	private CardNumberDao cardNumberDao;

	@Autowired
	private ManufactureBatchDao manufactureBatchDao;
	
	@Autowired
	private SingalGlassDao singalGlassDao;

	public Glass save(Glass glass) {
		return glassDao.save(glass);
	}

	public Glass getById(Long id) {
		return glassDao.findOne(id);
	}

	public List<Glass> findAll() {
		return glassDao.findAll();
	}

	public String parseGlassExcel(File excelFile, String manufacture_batch) throws IOException {
		LOGGER.debug("> Start parseGlassExcel");

		ExcelUtil excel = new ExcelUtil(excelFile.getAbsolutePath());
		XSSFSheet sheet = excel.getSheet(0);

//		ManufactureBatch manufactureBatch = manufactureBatchDao.findWaitingManufactureBatch();
//		String manufacture_batch = manufactureBatch.getNumber();
		for (int i = DATA_START_ROW; i <= sheet.getLastRowNum(); i++) {
			String apart_id = excel.getStringValueAt(sheet, i, APART_ID_COLUMN);// 得到流程卡号
			String order_number = excel.getStringValueAt(sheet, i, ORDER_NUMBER_COLUMN);// 得到订单序号
			String piece_sign = excel.getStringValueAt(sheet, i, PIECE_SIGN_COLUMN);// 得到片标记
			int pieces = Integer.parseInt(excel.getStringValueAt(sheet, i, PIECE_COLUMN));// 得到数量
			double length = Double.parseDouble(excel.getStringValueAt(sheet, i, LENGTH_COLUMN));// 得到长度
			double width = Double.parseDouble(excel.getStringValueAt(sheet, i, WIDTH_COLUMN));// 得到高度
			String customer = excel.getStringValueAt(sheet, i, CUSTOMER_COLUMN);// 得到客户名称
			String application = excel.getStringValueAt(sheet, i, APPLICATION_COLUMN);// 得到项目名称
			String floor_number = excel.getStringValueAt(sheet, i, FLOOR_NUMBER);// 得到楼层编号
			String production = excel.getStringValueAt(sheet, i, PRODUCTION_COLUMN);// 得到成品名称
			String single = excel.getStringValueAt(sheet, i, SINGLE_COLUMN);// 得到单品名称
			double thickness = Double.parseDouble(single.substring(0, single.indexOf("m")));// 得到单品名称中的厚度
			if (single.contains("CLR")) {
				glasscolor = GlassService.COLOR;
			} else {
				glasscolor = "white";
			}
			String remark = excel.getStringValueAt(sheet, i, REMARK_COLUMN);// 得到明细备注

			Glass glass = new Glass(GlassArrangeState.MEASURE, 0, length, width, thickness, glasscolor, customer,
					GlassArrangeState.MEASURE, "", apart_id, manufacture_batch, pieces, 0,0, null, application,
					production, floor_number, order_number, piece_sign, remark,sendGlassState.NOTSEND,sendGlassState.NOTSEND);
			glassDao.save(glass);
			List<CardNumber> cardNumbers = cardNumberDao.findAll();
			if (cardNumbers.size()>0) {
				for (int j = 0; j < cardNumbers.size(); j++) {
					CardNumber cardNumber = cardNumbers.get(j);
					if (cardNumber.getNumber().equals(apart_id)) {
						break;
					}
					if (j == cardNumbers.size() - 1) {
						CardNumber cardNumber1 = new CardNumber(apart_id,ManufactureBatchState.WAITING);
						cardNumberDao.save(cardNumber1);
					}
				}
			}else{
				CardNumber cardNumber = new CardNumber(apart_id,ManufactureBatchState.WAITING);
				cardNumberDao.save(cardNumber);
			}
		}

		// 添加任务
		String custom = excel.getStringValueAt(sheet, 2, CUSTOMER_COLUMN);
		LOGGER.debug("> End parseGlassExcel");
		return "success";
	}
	
	private void setGlassOrder(String matchname){
//		List<SingalGlass> glasses = singalGlassDao.findByApartId(matchname);
		List<SingalGlass> glasses = singalGlassDao.findByBatch(matchname);
		if (glasses.size()>0) {
			for (int i = 0; i < glasses.size(); i++) {
				List<SingalGlass> gl = singalGlassDao.findByA(matchname,glasses.get(i).getApart_id());//找到当前要匹配的玻璃
				List<GlassOrder> orderes = new ArrayList<GlassOrder>();
				for (int j = 0; j < gl.size()-1; j++) {
					
					if (gl.get(j).getGlassId() == gl.get(j+1).getGlassId()
							&&gl.get(j).getLength() == gl.get(j+1).getLength()
							&&gl.get(j).getWidth() == gl.get(j+1).getWidth()
							&&gl.get(j).getId().equals(gl.get(j+1).getId())) {
						GlassOrder order = new GlassOrder();
					}else {
						GlassOrder order = new GlassOrder();
					}
				}
			}
		}
		
	}

}