package xkng.dao.daoimpl;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import xkng.dao.HealthRegisterDao;
import xkng.entity.TemperatureRegistration;
import xkng.util.JDBCUtil;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

public class HealthRegisterImpl implements HealthRegisterDao {
    @Override
    public JSONObject HealthRegisterList() {

        String sql = "SELECT * FROM temperature_registration";
        JDBCUtil jdbcUtil = new JDBCUtil();
        List<Object> mapList = jdbcUtil.excuteQuery(sql, null);
        JSONArray jsonArray = JSONArray.parseArray(JSON.toJSONString(mapList));

        JSONObject jsonObject = new JSONObject();
        jsonObject.put("code","0");
        jsonObject.put("msg","成功");
        jsonObject.put("count",mapList.size());
        jsonObject.put("data",jsonArray);

        return jsonObject;
    }

    @Override
    public int HealthRegisterAdd(TemperatureRegistration temperatureRegistration) {
        Date date=new Date();
        DateFormat simpleDateFormat= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String time = simpleDateFormat.format(date);

        String sql = "insert into temperature_registration (name,temperature,isnormal,createtime,updatetime" +
                ",reson,explains) " +
                "values " +
                "(" +
                "'"+temperatureRegistration.getName()+"',"+
                "'"+temperatureRegistration.getTemperature()+"',"+
                "'"+temperatureRegistration.getIsnormal()+"',"+
                "'"+time+"',"+
                "'"+time +"',"+
                "'"+temperatureRegistration.getReson()+"',"+
                "'"+temperatureRegistration.getExplain()+"')";
        JDBCUtil jdbcUtil = new JDBCUtil();
        return jdbcUtil.executeUpdate(sql,null);
    }
}