ex

package com.rsa.dkbm.dao.impl;

import com.rsa.dkbm.dao.Db2Dao;
import com.rsa.dkbm.dao.mapper.PolicyResponseDTOItemRowMapper;
import com.rsa.dkbm.util.DateTimeUtils;
import com.rsa.dkbm.web.bean.dto.*;
import org.apache.commons.lang.StringUtils;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;
import java.text.SimpleDateFormat;

import java.util.List;

import static com.rsa.dkbm.util.ValidationUtil.normalizeCarIdentificator;

/**
 * @author Dmitry Poddubnik
 * @since 26.08.14
 */
public class Db2DaoImpl extends NamedParameterJdbcDaoSupport implements Db2Dao {

    @Override
    public List<PolicyResponseDTOItem> loadPolicyResponseDtoList(PolicyRequestDTO policyRequestDTO) {
        String sql;
        if(!StringUtils.isBlank(policyRequestDTO.getVin())) {
            String s = normalizeCarIdentificator(policyRequestDTO.getVin());

            sql="SELECT bso_serial, bso_number, ins_company_id, is_restrict, policy_unq_id FROM policy_osago " +
                    "WHERE (?>=policy_beg and ?<=policy_end and veh_rec_id in( " +
                    "SELECT * FROM vehicle WHERE vehicle_normaliz_rec_id in( " +
                    "SELECT vehicle_normaliz_rec_id FROM vehicle_normaliz WHERE vin_normaliz = ?)))";
        }
        else {
            sql="SELECT bso_serial, bso_number, ins_company_id, is_restrict, policy_unq_id FROM policy_osago  " +
                    "WHERE (?>=policy_beg and ?<=policy_end and veh_rec_id in( " +
                    "SELECT * FROM vehicle WHERE WHERE license_plate=?))";

        }

        policyRequestDTO.getDate();
        String[] splitted = policyRequestDTO.getDate().split("-");
        String str = splitted[2] + "-" + splitted[1] + "-" + splitted[0] ;

        return getJdbcTemplate().query(sql, PolicyResponseDTOItemRowMapper.MAPPER, policyRequestDTO.getVin(),

                DateTimeUtils.getLocalDateTime(str),
                policyRequestDTO.getLicensePlate());
    }


//    @Override
//    public List<PolicyResponseDTO> loadPolicyResponseDtoList(PolicyRequestDTO policyRequestDTO) {
//
//    }



}