package com.dsh.guns.modular.system.util.task.jobs;

import com.dsh.guns.core.util.SinataUtil;
import com.dsh.guns.modular.system.util.ConstellationUtil;
import com.dsh.guns.modular.system.util.task.base.AbstractJob;
import org.apache.commons.lang.time.DateUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.quartz.JobDataMap;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * 定时1秒后导出用户详情记录
 */
public class AddMachine extends AbstractJob {

    public static final String name = "addMachineJob";

    @Override
    public void execute(JobExecutionContext context) throws JobExecutionException {
        JobDataMap maps = context.getMergedJobDataMap();
        Workbook book = (Workbook) maps.get("book");

        try {
            System.out.println("----定时2秒后导入机器人-----");
            Sheet sh = book.getSheetAt(0);   //获取到第一个表
            for (int i = 1; i <= sh.getLastRowNum(); i++) {
                Row row = sh.getRow(i);

                Cell cell0 = row.getCell(0);  //用户昵称
                String nickname = null;
                if (SinataUtil.isNotEmpty(cell0)){
                    nickname = String.valueOf(cell0.getStringCellValue()).trim();
                }

                Cell cell1 = row.getCell(1); //性别
                String sex = null;
                if (SinataUtil.isNotEmpty(cell1)){
                    sex = String.valueOf(cell1.getStringCellValue()).trim();
                }

                Cell cell2 = row.getCell(2);  //认证
                String authType = null;
                if (SinataUtil.isNotEmpty(cell2)){
                    authType = String.valueOf(cell2.getStringCellValue()).trim();
                }

                Cell cell3 = row.getCell(3);  //女神认证
                String isGoddess = null;
                if (SinataUtil.isNotEmpty(cell3)){
                    isGoddess = String.valueOf(cell3.getStringCellValue()).trim();
                }

                Cell cell4 = row.getCell(4);  //会员
                String isVip = null;
                if (SinataUtil.isNotEmpty(cell4)){
                    isVip = String.valueOf(cell4.getStringCellValue()).trim();
                }

                Cell cell5 = row.getCell(5);  //生日
                String birthday = null;
                if (SinataUtil.isNotEmpty(cell5)){
                    birthday = String.valueOf(cell5.getStringCellValue()).trim();
                }

                Cell cell6 = row.getCell(6);  //爱好
                String hobbyStr = null;
                if (SinataUtil.isNotEmpty(cell6)){
                    hobbyStr = String.valueOf(cell6.getStringCellValue()).trim();
                }

                Cell cell7 = row.getCell(7);  //交友原则
                String principleStr = null;
                if (SinataUtil.isNotEmpty(cell7)){
                    principleStr = String.valueOf(cell7.getStringCellValue()).trim();
                }

                Cell cell8 = row.getCell(8);  //身高cm
                String height = null;
                if (SinataUtil.isNotEmpty(cell8)){
                    height = String.valueOf(cell8.getStringCellValue()).trim();
                }

                Cell cell9 = row.getCell(9);  //体重kg
                String weight = null;
                if (SinataUtil.isNotEmpty(cell9)){
                    weight = String.valueOf(cell9.getStringCellValue()).trim();
                }

                Cell cell10 = row.getCell(10);  //个人简介
                String introduction = null;
                if (SinataUtil.isNotEmpty(cell10)){
                    introduction = String.valueOf(cell10.getStringCellValue()).trim();
                }

                if (SinataUtil.isEmpty(nickname) || SinataUtil.isEmpty(sex) || SinataUtil.isEmpty(authType)
                        || SinataUtil.isEmpty(isGoddess) || SinataUtil.isEmpty(isVip) || SinataUtil.isEmpty(birthday)
                        || SinataUtil.isEmpty(hobbyStr) || SinataUtil.isEmpty(principleStr)){
                    continue;
                }else{
                    if (SinataUtil.isNotEmpty(height)){
                        if (!isDouble(height)){
                            continue;
                        }
                    }
                    if (SinataUtil.isNotEmpty(weight)){
                        if (!isDouble(weight)){
                            continue;
                        }
                    }
                    String constellation = null;
                    try {
                        String time = importByExcelForDate(birthday);
                        constellation = ConstellationUtil.getConstellation(time);
                    }catch (Exception e){
                        continue;
                    }
                    /*AppUserInfo user = new AppUserInfo();
                    user.setAddTime(new Date());
                    user.setConstellation(constellation);
                    user.setNickname(nickname);
                    user.setSex(Integer.valueOf(sex));
                    user.setIsGoddess(Integer.valueOf(isGoddess));
                    user.setAuthType(Integer.valueOf(authType));
                    user.setIsVip(Integer.valueOf(isVip));
                    user.setState(1);
                    user.setBirthday(birthday);
                    user.setHobbyStr(hobbyStr);
                    user.setPrincipleStr(principleStr);
                    if (SinataUtil.isNotEmpty(height))
                        user.setHeight(Double.valueOf(height));
                    if (SinataUtil.isNotEmpty(weight))
                        user.setWeight(Double.valueOf(weight));
                    if (SinataUtil.isNotEmpty(introduction))
                        user.setIntroduction(introduction);
                    user.setIsComplete(1);
                    user.setIsMachine(2);
                    appUserInfoService.insert(user);*/
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 转换日期
     * @return
     */
    public static String importByExcelForDate(String value) {//value就是它的天数
        String currentCellValue = "";
        if(value != null && !value.equals("")){
            Calendar calendar = new GregorianCalendar(1900,0,-1);
            Date d = calendar.getTime();
            Date dd = DateUtils.addDays(d,Integer.valueOf(value));
            DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
            currentCellValue = formater.format(dd);
        }
        return currentCellValue;
    }

    /**
     * 验证是否可以字符转为金额值
     * @param str
     * @return
     */
    public static boolean isDouble(String str)
    {
        try{
            Double.parseDouble(str);
            return true;
        }catch(NumberFormatException e)
        {
            System.out.println("异常：\"" + str + "\"不是数字/整数/小数...");
            return false;
        }
    }
}