package com.web.kanban.service.internal;

import com.web.kanban.entity.Item;
import com.web.kanban.entity.Wlqt;
import com.web.kanban.service.CJKanBanService;
import com.app.base.data.ApiResponseResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import java.text.SimpleDateFormat;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


@Service
public class CJKanBanServiceImpl implements CJKanBanService {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

    @Override
    public ApiResponseResult getZP3() {
        Map<String, Object> result = new HashMap<String, Object>();
        String sql = "select * from zp_wlqt3";
        List<Wlqt> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Wlqt.class));
        query.forEach(s -> s.setDaa006Form(sdf.format(s.getDaa006())));
        result.put("data1", query);

        sql = "select * from zp_item3";
        List<Item> query1 = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Item.class));

        result.put("data2", query1);

        sql = "select * from zp_wlqt7";
        List<Wlqt> query2 = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Wlqt.class));
        query2.forEach(s -> s.setDaa006Form(sdf.format(s.getDaa006())));
        result.put("data3", query2);

        sql = "select * from zp_item7";
        List<Item> query3 = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Item.class));
        result.put("data4", query3);

        return ApiResponseResult.success().data(result);
    }

    @Override
    public ApiResponseResult getZJ3() {
        Map<String, Object> result = new HashMap<String, Object>();
        String sql = "select * from zj_wlqt3";
        List<Wlqt> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Wlqt.class));
        query.forEach(s -> s.setDaa006Form(sdf.format(s.getDaa006())));
        result.put("data1", query);

        sql = "select * from zj_item3";
        List<Item> query1 = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Item.class));

        result.put("data2", query1);

        sql = "select * from zj_wlqt7";
        List<Wlqt> query2 = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Wlqt.class));
        query2.forEach(s -> s.setDaa006Form(sdf.format(s.getDaa006())));
        result.put("data3", query2);

        sql = "select * from zj_item7";
        List<Item> query3 = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Item.class));
        result.put("data4", query3);

        return ApiResponseResult.success().data(result);
    }
}