package com.cxs.dao;

import com.cxs.model.Project;
import com.cxs.utils.DBUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * @Description 用地审批dao层
 * @Package com.cxs.dao.landUserQueryDao
 * @ClassName LandUserQueryDao
 * @Data 2022-04-14 15:03
 * @Author cxs
 */
public class LandUserQueryDao {
    QueryRunner queryRunner = new QueryRunner(DBUtils.getDs());

    public List<Project> queryRange() throws SQLException {
        return queryRunner.query("select distinct LocationLand from bp_project", new BeanListHandler<>(Project.class));
    }

    public List<Project> queryType() throws SQLException {
        return queryRunner.query("select distinct ProjectType from bp_project", new ResultSetHandler<List<Project>>() {
            @Override
            public List<Project> handle(ResultSet resultSet) throws SQLException {
                List<Project> list = new ArrayList<>();
                while (resultSet.next()) {
                    Project project = new Project();
                    int pt = resultSet.getInt("ProjectType");
                    switch (pt) {
                        case 1:
                            project.setProjectType("单独选址");
                            break;
                        case 2:
                            project.setProjectType("城市分批次");
                            break;
                        case 3:
                            project.setProjectType("增选挂钩");
                            break;
                        case 4:
                            project.setProjectType("先行复垦");
                            break;
                        default:
                            project.setProjectType(null);
                    }
                    list.add(project);
                }
                return list;
            }
        });
    }

    public List<Project> queryLandData(String county, Date startTime, Date endTime, Integer projectType) throws SQLException {
       return queryRunner.query("select *from bp_project where LocationLand = ? and EndTime between ? and ? and ProjectType = ?",new BeanListHandler<>(Project.class),county,startTime,endTime,projectType);
    }
}