package bean.TreeCom;

import java.io.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;
import database.DBPoolManager;

public class TreeBean {

	private ArrayList treenodes;
	private byte   	  temp[];
	
	public TreeBean() {
		treenodes = new ArrayList();
	}
	public String ISOtoGB(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("iso-8859-1"),"gb2312");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {

    				e.printStackTrace();
    			}
    		}
    		return out; 		
        } 
	public String GBtoISO(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("gb2312"),"iso-8859-1");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {

    				e.printStackTrace();
    			}
    		}
    		return out;		
        } 
	
	
	public ArrayList getMenuTree() {
		treenodes.clear();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;			
			String    sql  = "select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu order by sup_menu_id, menu_id Desc ";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("menu_id") == null){
					ht.put("menu_id", "");
				}
				else{
				        s = rest.getString("menu_id");
				        s = s.trim();
					ht.put("menu_id", s);
				}
				if (rest.getString("menu_name") == null){
					ht.put("menu_name", "");
				}
				else{
				        s = rest.getString("menu_name");
				        s = s.trim();				
					ht.put("menu_name", s);
				}
				if (rest.getString("sup_menu_id") == null){
					ht.put("sup_menu_id", "");
				}
				else{
				        s = rest.getString("sup_menu_id");
				        s = s.trim();							
					ht.put("sup_menu_id", s);
				}
				if (rest.getString("menu_herf") == null){
					ht.put("menu_herf", "");
				}
				else{
				        s = rest.getString("menu_herf");
				        s = s.trim();								
					ht.put("menu_herf", s);
				}	
				if (rest.getString("open_ico") == null){
					ht.put("open_ico", "");
				}
				else{
				        s = rest.getString("open_ico");
				        s = s.trim();				
					ht.put("open_ico", s);
				}
				if (rest.getString("close_ico") == null){
					ht.put("close_ico", "");
				}
				else{
				        s = rest.getString("close_ico");
				        s = s.trim();					
					ht.put("close_ico", s);
				}															
				treenodes.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get MenuTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.treenodes;
	}

	public ArrayList getMenuTree(String menu_id) {
		treenodes.clear();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;			
			String    sql  = "select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu start with menu_id="+menu_id+" connect by prior menu_id=sup_menu_id order by sup_menu_id, menu_id Desc";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("menu_id") == null){
					ht.put("menu_id", "");
				}
				else{
				        s = rest.getString("menu_id");
				        s = s.trim();
					ht.put("menu_id", s);
				}
				if (rest.getString("menu_name") == null){
					ht.put("menu_name", "");
				}
				else{
				        s = rest.getString("menu_name");
				        s = s.trim();				
					ht.put("menu_name", s);
				}
				if (rest.getString("sup_menu_id") == null){
					ht.put("sup_menu_id", "");
				}
				else{
				        s = rest.getString("sup_menu_id");
				        s = s.trim();							
					ht.put("sup_menu_id", s);
				}
				if (rest.getString("menu_herf") == null){
					ht.put("menu_herf", "");
				}
				else{
				        s = rest.getString("menu_herf");
				        s = s.trim();								
					ht.put("menu_herf", s);
				}	
				if (rest.getString("open_ico") == null){
					ht.put("open_ico", "");
				}
				else{
				        s = rest.getString("open_ico");
				        s = s.trim();				
					ht.put("open_ico", s);
				}
				if (rest.getString("close_ico") == null){
					ht.put("close_ico", "");
				}
				else{
				        s = rest.getString("close_ico");
				        s = s.trim();					
					ht.put("close_ico", s);
				}															
				treenodes.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get MenuTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.treenodes;
	}
	
	public ArrayList getPurviewMenuTree(String Purview) {
		treenodes.clear();	
		DBPoolManager dbpool = new DBPoolManager();
		String    sql  = null;
		dbpool.getConnection();	
		try {
			char      temp ;
			String    s    = null;
			
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = null;
			if(Purview.length()==0){
				//sql  = "select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu start with menu_id="+menu_id+" connect by prior menu_id=sup_menu_id order by sup_menu_id, menu_id Desc ";
				sql  = "select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu where 1=2 ";
			}
			else{
				Purview	       = Purview.trim();			
				Purview	       = Purview.replace('a',',');
				
				temp	       = Purview.charAt(0);
				if(temp==',')	 Purview = Purview.substring(1);
				temp	       = Purview.charAt(Purview.length()-1);
				if(temp==',')	 Purview = Purview.substring(0,Purview.length()-1);			

				Purview =	"("+Purview+")";
				sql	=	" select distinct menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from ";
				sql  	= 	sql +	"( select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu  start with menu_id in "+Purview+" connect by prior sup_menu_id=menu_id ) order by sup_menu_id, menu_id desc";
			}
			rest	=	stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("menu_id") == null){
					ht.put("menu_id", "");
				}
				else{
				        s = rest.getString("menu_id");
				        s = s.trim();
					ht.put("menu_id", s);
				}
				if (rest.getString("menu_name") == null){
					ht.put("menu_name", "");
				}
				else{
				        s = rest.getString("menu_name");
				        s = s.trim();				
					ht.put("menu_name", s);
				}
				if (rest.getString("sup_menu_id") == null){
					ht.put("sup_menu_id", "");
				}
				else{
				        s = rest.getString("sup_menu_id");
				        s = s.trim();							
					ht.put("sup_menu_id", s);
				}
				if (rest.getString("menu_herf") == null){
					ht.put("menu_herf", "");
				}
				else{
				        s = rest.getString("menu_herf");
				        s = s.trim();								
					ht.put("menu_herf", s);
				}	
				if (rest.getString("open_ico") == null){
					ht.put("open_ico", "");
				}
				else{
				        s = rest.getString("open_ico");
				        s = s.trim();				
					ht.put("open_ico", s);
				}
				if (rest.getString("close_ico") == null){
					ht.put("close_ico", "");
				}
				else{
				        s = rest.getString("close_ico");
				        s = s.trim();					
					ht.put("close_ico", s);
				}															
				treenodes.add(ht);