package com.dao;

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

import com.toolsbean.DB;
import com.valuebean.OptionBean;

public class OptionDao {
	private DB mydb=null;
	
	public OptionDao(){
		mydb=new DB();
	}
	public List getOptions(){
		String sql="select * from tb_option order by option_order";
		List options=getList1(sql,null);		
		return options;
	}
	public List getOptionsForDay(){
		String sql="select o.*,t.num from tb_option as o left join (select voter_voteoption,count(id) as num from tb_voter where day(voter_votetime)=day(getdate()) group by voter_voteoption)  t on o.id=t.voter_voteoption";
		List options =getList2(sql,null);
		return options;		
	}
	public List getOptionsForMonth(){
		String sql="select o.*,t.num from tb_option as o left join (select voter_voteoption,count(id) as num from tb_voter where month(voter_votetime)=month(getdate()) group by voter_voteoption)  t on o.id=t.voter_voteoption";
		List options =getList2(sql,null);
		return options;		
	}
	
	private List getList1(String sql,Object[] params){
		List options=null;
		DB mydb=new DB();
		mydb.doPstm(sql,params);
		try {
			ResultSet rs = mydb.getRs();
			if(rs!=null){
				options=new ArrayList();
				while(rs.next()){
					OptionBean single=new OptionBean();
					single.setId(rs.getInt(1));
					single.setOptionName(rs.getString(2));
					single.setOptionBallot(rs.getInt(3));
					single.setOptionOrder(rs.getInt(4));
					options.add(single);
				}
				rs.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return options;
	}
	private List getList2(String sql,Object[] params){
		List options=null;
		DB mydb=new DB();
		mydb.doPstm(sql,params);
		try {
			ResultSet rs = mydb.getRs();
			if(rs!=null){
				options=new ArrayList();
				while(rs.next()){
					OptionBean single=new OptionBean();
					single.setId(rs.getInt(1));
					single.setOptionName(rs.getString(2));
					single.setOptionBallot(rs.getInt(5));
					options.add(single);
				}
				rs.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return options;
	}
	public int vote(int id){
		int i=-1;
		String sql="update tb_option set option_ballot=option_ballot+1 where id=?";
		Object[] params={id};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		try {
			i= mydb.getCount();
		} catch (SQLException e) {
			i=-1;
			e.printStackTrace();
		}
		return i;
	}
	public void closed(){
		mydb.closed();
	}
}