package com.happy.dao.impl;

import com.happy.Model.Consume;
import com.happy.Model.Recharge;
import com.happy.dao.ConsumeDao;
import com.happy.dao.RechargeDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository("RechargeDao")
public class RechargeDaoImpl implements RechargeDao {

    @Autowired
    private NamedParameterJdbcTemplate namedParameterJdbcTemplate;

    public NamedParameterJdbcTemplate getNamedParameterJdbcTemplate() {
        return namedParameterJdbcTemplate;
    }

    public void setNamedParameterJdbcTemplate(
            NamedParameterJdbcTemplate namedParameterJdbcTemplate) {
        this.namedParameterJdbcTemplate = namedParameterJdbcTemplate;
    }

    public List<Recharge> queryByStu(String stu_number, String re_time){
        String sql="select * from `recharge` where stu_number=:stu_number and re_time like '" + re_time + "%' order by id desc";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("stu_number", stu_number);
        List<Recharge> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Recharge>(Recharge.class));
        if(list != null && list.size() >0){
            return list;
        }
        return null;
    }

    public int insertRecharge(Recharge recharge){
        String sql = "insert into recharge(order_num, card_number, user_name, account, re_time, state, stu_number) values(:order_num, :card_number, :user_name, :account, :re_time, :state, :stu_number)";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("order_num", recharge.getOrder_num());
        sps.addValue("card_number", recharge.getCard_number());
        sps.addValue("user_name", recharge.getUser_name());
        sps.addValue("account", recharge.getAccount());
        sps.addValue("re_time", recharge.getRe_time());
        sps.addValue("state", recharge.getState());
        sps.addValue("stu_number", recharge.getStu_number());
        int num = 0;
        try{
            num = namedParameterJdbcTemplate.update(sql, sps);
        }
        catch(Exception e){
            e.printStackTrace();
        }
        return num;
    }

    public int insertRecharge2(Recharge recharge){
        String sql = "insert into `recharge_elc`(order_num, card_number, user_name, account, re_time, state, stu_number) values(:order_num, :card_number, :user_name, :account, :re_time, :state, :stu_number)";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("order_num", recharge.getOrder_num());
        sps.addValue("card_number", recharge.getCard_number());
        sps.addValue("user_name", recharge.getUser_name());
        sps.addValue("account", recharge.getAccount());
        sps.addValue("re_time", recharge.getRe_time());
        sps.addValue("state", recharge.getState());
        sps.addValue("stu_number", recharge.getStu_number());
        int num = 0;
        try{
            num = namedParameterJdbcTemplate.update(sql, sps);
        }
        catch(Exception e){
            e.printStackTrace();
        }
        return num;
    }

    //根据订单号查找支付记录信息
    public Recharge findPayByNo(String order_num) {
        String sql = "select * from recharge where order_num=:order_num";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("order_num", order_num);
        Recharge recharge = null;
        try{
            recharge = namedParameterJdbcTemplate.queryForObject(sql, sps, new BeanPropertyRowMapper<Recharge>(Recharge.class));
        }
        catch(Exception e){
            recharge = null;
        }
        return recharge;
    }

    public List<Recharge> queryRecordByStu(String stu_number, String re_time){
        String sql="select * from recharge_elc where stu_number=:stu_number and re_time like '"+ re_time +"%' order by id desc";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("stu_number", stu_number);
        List<Recharge> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Recharge>(Recharge.class));
        if(list != null && list.size() >0){
            return list;
        }
        return null;
    }

}