1

hao

2025-05-20 8e24c6fea30d9b179375ee2893710cdec2443b13

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
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);
    }
}