package com.tairun.component.popedom.dao.daoimp;

import com.tairun.component.popedom.dao.PrivilegeDAO;
import com.tairun.component.popedom.model.Privilege;
import com.tairun.component.popedom.util.Primary;
import com.tairun.component.popedom.util.DAORuntimeException;


import javax.sql.DataSource;
import java.util.List;
import java.util.Vector;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.ResultSet;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.jdbc.core.RowCallbackHandler;


/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: 2005-12-6
 * Time: 9:05:22
 * To change this template use File | Settings | File Templates.
 */
public class PrivilegeDAOImp implements PrivilegeDAO{

        DataSource ds;

     public void setDataSource(DataSource ds){
       this.ds=ds;
     }                 

    public void create(Privilege privilege)throws DAORuntimeException{
        final Privilege pri=privilege;
        JdbcTemplate jt=new JdbcTemplate(ds);
        jt.update("insert into popedom values(?,?,?,?,?,?,?,?,?)",new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setLong(1,pri.getPrivilegeID());
                ps.setString(2,pri.getFunctionID());
                ps.setLong(3,pri.getRoleID());
                ps.setString(4,pri.getPrivatestatus());
                ps.setShort(5,Primary.ENABLE);
                ps.setTimestamp(6,new Timestamp(System.currentTimeMillis()));
                ps.setTimestamp(7,new Timestamp(System.currentTimeMillis()));
                ps.setString(8,pri.getWill1());
                ps.setString(9,pri.getWill2());
             }
        });
    }

    public void update(Privilege privilege)throws DAORuntimeException{
        final Privilege pri=privilege;
        JdbcTemplate jt=new JdbcTemplate(ds);
        jt.update("update popedom set privilege_status=?,updatetime=?,will1=?,will2=? where PK_privilegeID="+privilege.getPrivilegeID()+" and status="+Primary.ENABLE
                 ,new PreparedStatementSetter() {
                   public void setValues(PreparedStatement ps) throws SQLException {
                    ps.setString(1,pri.getPrivatestatus());
                    ps.setTimestamp(2,new Timestamp(System.currentTimeMillis()));
                    ps.setString(3,pri.getWill1());
                    ps.setString(4,pri.getWill2());
             }
        });

    }

    public List getlist(long roleID)throws DAORuntimeException{
        final List list=new Vector();
        JdbcTemplate jt=new JdbcTemplate(ds,true);
        jt.query("select * from popedom where FK_roleID="+roleID+" and status="+Primary.ENABLE+" order by 0+RPAD(FK_function,6,'0') asc",new RowCallbackHandler() {
            public void processRow(ResultSet rs) throws SQLException {
               Privilege pri=new Privilege();
               pri.setPrivilegeID(rs.getLong("PK_privilegeID"));
               pri.setFunctionID(rs.getString("FK_function"));
               pri.setRoleID(rs.getLong("FK_roleID"));
               pri.setPrivatestatus(rs.getString("privilege_status"));
               list.add(pri);
            }
        });
        return list;
    }
   public List getlist_first(long roleID)throws DAORuntimeException{
        final List list=new Vector();
        JdbcTemplate jt=new JdbcTemplate(ds,true);
        jt.query("select * from popedom where FK_roleID="+roleID+" and status="+Primary.ENABLE+" and FK_function like '"+"__'",new RowCallbackHandler() {
            public void processRow(ResultSet rs) throws SQLException {
               Privilege pri=new Privilege();
               pri.setPrivilegeID(rs.getLong("PK_privilegeID"));
               pri.setFunctionID(rs.getString("FK_function"));
               pri.setRoleID(rs.getLong("FK_roleID"));
               pri.setPrivatestatus(rs.getString("privilege_status"));
               list.add(pri);
            }
        });
        return list;
    }
    public List getlist_second(long roleID,String father_funID)throws DAORuntimeException{
        final List list=new Vector();
        JdbcTemplate jt=new JdbcTemplate(ds,true);
        jt.query("select * from popedom where FK_roleID="+roleID+" and status="+Primary.ENABLE+" and FK_function like '"+father_funID+"__'",new RowCallbackHandler() {
            public void processRow(ResultSet rs) throws SQLException {
               Privilege pri=new Privilege();
               pri.setPrivilegeID(rs.getLong("PK_privilegeID"));
               pri.setFunctionID(rs.getString("FK_function"));
               pri.setRoleID(rs.getLong("FK_roleID"));
               pri.setPrivatestatus(rs.getString("privilege_status"));
               list.add(pri);
            }
        });
        return list;
    }
}