package com.vci.client.framework.systemConfig.log;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.GridBagConstraints;
import java.awt.GridLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collections;
import java.util.Comparator;
import java.util.LinkedHashMap;
import java.util.LinkedList;
import java.util.List;

import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.border.TitledBorder;

import org.apache.commons.lang3.StringUtils;

import com.vci.corba.common.VCIError;
import com.vci.mw.ClientContextVariable;
import com.vci.client.LogonApplication;
import com.vci.client.common.VCIBasePanel;
import com.vci.client.common.objects.LogObject;
import com.vci.client.common.objects.RoleObject;
import com.vci.client.common.objects.UserObject;
import com.vci.client.framework.delegate.LogManagementClientDelegate;
import com.vci.client.framework.delegate.RightManagementClientDelegate;
import com.vci.client.framework.util.JAutoCompleteComboBox;
import com.vci.client.oq.QTClient;
import com.vci.client.ui.date.PopupCalendarMethod;
import com.vci.client.ui.exception.VCIException;
import com.vci.client.ui.locale.LocaleDisplay;
import com.vci.client.ui.swing.VCIOptionPane;
import com.vci.client.ui.swing.VCISwingUtil;
import com.vci.client.ui.swing.components.VCIJButton;
import com.vci.client.ui.swing.components.VCIJComboBox;
import com.vci.client.ui.swing.components.VCIJPanel;
import com.vci.client.ui.swing.components.table.AbstractVCIJTableDataProvider;
import com.vci.client.ui.swing.components.table.VCIJTableNode;
import com.vci.client.ui.swing.components.table.VCIJTablePanel;
import com.vci.common.log.LogType;
/**
 * 
 * @author xiongfei
 * 日志管理
 * 创建时间：2011-06-13
 */
public class LogManagementPanel extends VCIJPanel {

	/**
	 * 
	 */
	private static final long serialVersionUID = -5588255327255334689L;
	
	//获取异常信息及国际化信息的文件名
	private String FILENAME = "RMIPFramework";
	//查询日期：由
	private String DATE_START = LocaleDisplay.getI18nString("rmip.framework.log.startDate", "RMIPFramework", getLocale());
	//到
	private String TO = LocaleDisplay.getI18nString("rmip.framework.log.to", "RMIPFramework", getLocale());
	//创建
	private String CREATE = LocaleDisplay.getI18nString("rmip.framework.log.create", "RMIPFramework", getLocale());
	//修改
	private String UPDATE = LocaleDisplay.getI18nString("rmip.framework.log.update", "RMIPFramework", getLocale());
	//删除
	private String DELETE = LocaleDisplay.getI18nString("rmip.framework.log.delete", "RMIPFramework", getLocale());
	//操作用户：
	private String OPERATEUSER = LocaleDisplay.getI18nString("rmip.framework.log.operateUser", "RMIPFramework", getLocale());
	//查询
	private String QUERY = LocaleDisplay.getI18nString("rmip.framework.log.query", "RMIPFramework", getLocale());
	//导出
	private String EXPORT = LocaleDisplay.getI18nString("rmip.framework.log.export", "RMIPFramework", getLocale());
	//日志管理
	private String LOGMANAGE = LocaleDisplay.getI18nString("rmip.framework.logManagementModel", "RMIPFramework", getLocale());
	
	/**
	 * 操作类型
	 */
	private String OPERATE_TYPE = LocaleDisplay.getI18nString("rmip.framework.log.operateType", "RMIPFramework", getLocale());
	
	private JLabel dateLabelStart = new JLabel(DATE_START);
	private JLabel dateLabelTo = new JLabel(TO);
	protected VCIJComboBox startDateBox = new VCIJComboBox();
	protected VCIJComboBox endDateBox = new VCIJComboBox();
	private JButton startDateButton = new PopupCalendarMethod().createDateDialogButton("date.gif",startDateBox);
	private JButton endDateButton = new PopupCalendarMethod().createDateDialogButton("date.gif",endDateBox);
	private JCheckBox create = new JCheckBox(CREATE);
	private JCheckBox modify = new JCheckBox(UPDATE);
	private JCheckBox delete = new JCheckBox(DELETE);
	private JLabel userLabel = new JLabel(OPERATEUSER);

	protected JAutoCompleteComboBox userCombox = new JAutoCompleteComboBox();
	//added by xf 增加按用户IP查询日志 ，支持模糊查询
	private JLabel ipLabel = new JLabel("用户IP：");
	protected JTextField ipText = new JTextField();
	private JLabel operateTypeLabel = new JLabel(OPERATE_TYPE);
	protected JTextField typeText = new JTextField();
	
	private LogManagementPanelActionListener logActionListener = new LogManagementPanelActionListener(this);
	private VCIJButton queryBtn = VCISwingUtil.createVCIJButton("query",QUERY,QUERY,"search.png",logActionListener);
	private VCIJButton exportBtn = VCISwingUtil.createVCIJButton("export",EXPORT,EXPORT,"export.gif",logActionListener);
	VCIJButton queryDetail = new VCIJButton("查看详细信息", VCISwingUtil.createImageIcon("search.png"));
	private String querySql = "";
	LogManagementClientDelegate logDel = new LogManagementClientDelegate(LogonApplication.getUserEntityObject());
	protected final String LOG_SAVE_PERIOD = "logSavePeriod";//日志保存期限
	
	// 控件的坐标位置变量
	private int x = 10;
	private int y = 20;
	private int width = 50;
	private int height = 25;
	/**
	 * 两控件间垂直间隔
	 */
	private int vspan = 5;
	/**
	 * 两控件间水平间隔
	 */
	private int hspan = 5;
	
	private VCIBasePanel vciBasePanel = null;
	private LinkedList<VCIJButton> selfCustomButtons = new LinkedList<VCIJButton>();
	{
		selfCustomButtons.add(exportBtn);
		selfCustomButtons.add(queryDetail);
	}
	
	private LogType logType = null;
	private boolean isManagerQuery = false;
	public LogType getLogType() {
		return logType;
	}
	public void setLogType(LogType logType) {
		this.logType = logType;
	}
	public boolean isManagerQuery() {
		return isManagerQuery;
	}
	public void setManagerQuery(boolean isManagerQuery) {
		this.isManagerQuery = isManagerQuery;
	}
	
	public LogManagementPanel(VCIBasePanel vciBasePanel, LogType logType, boolean isManagerQuery){
		this.vciBasePanel = vciBasePanel;
		this.logType = logType;
		this.isManagerQuery = isManagerQuery;
		init();
	}
	
	class MyDataProvider extends AbstractVCIJTableDataProvider<LogObject>{
		@Override
		public LogObject[] getDatas(int pageCount, int pageSize) {
			LogObject[] logInfos = new LogObject[0];
			try {
				querySql = getSQL();
				logInfos = logDel.getLogListByContion(pageCount,pageSize,querySql);
				
			} catch (VCIException e) {
				VCIOptionPane.showError(LogonApplication.frame, "RMIPFramework", e);
				return null;
			}
			return logInfos;
		}
		@Override
		public VCIJTableNode<LogObject> getNewRowNode(LogObject dataObj) {
			VCIJTableNode<LogObject> node = new VCIJTableNode<LogObject>(dataObj);	
			node.setPropertyValue(getSpecialColumns()[0], dataObj.getUsername());
			node.setPropertyValue(getSpecialColumns()[1], dataObj.getTruename());
			node.setPropertyValue(getSpecialColumns()[2], dataObj.getUserIp());
			node.setPropertyValue(getSpecialColumns()[3], dataObj.getModule());
			node.setPropertyValue(getSpecialColumns()[4], dataObj.getType());
			node.setPropertyValue(getSpecialColumns()[5], dataObj.getDate());
			String result = "操作成功";
			String memo = dataObj.getResult();
			if(StringUtils.isNotBlank(memo)){
				boolean hasResult =false;
				if(memo.startsWith("操作") && memo.length()>4){
					result = memo.substring(0,4);
					hasResult = true;
				}
				if((memo.startsWith("登入") || memo.startsWith("登出"))&& memo.length()>4){
					result = memo.substring(0,4);
					hasResult = true;
				}
				if(memo.length()>5 && hasResult){
					 memo = memo.substring(5);
					}else{
						//memo = "";
					}
			}
			node.setPropertyValue(getSpecialColumns()[6], result);
			node.setPropertyValue(getSpecialColumns()[7], memo);
			return node;
		}

		@Override
		public String[] getSpecialColumns() {
			return "用户名,姓名, 用户ip,模块,操作,时间,操作结果, 描述".split(",");
		}
		@Override
		public int getTotal() {
			querySql = getSQL();
			try {
				total = (int) logDel.getSumLogRows(querySql);
			} catch (VCIException e) {
				e.printStackTrace();
				VCIOptionPane.showError(LogonApplication.frame, "RMIPFramework", e);
			}
			return this.total;
		}
	}
	
	protected MyDataProvider dataProvider = new MyDataProvider();
	protected VCIJTablePanel<LogObject> tablePanel = new VCIJTablePanel<LogObject>(dataProvider);
	private VCIJPanel tablePanel(){
		LinkedHashMap<Integer, Integer> widthMaps = new LinkedHashMap<Integer, Integer>();
		widthMaps.put(2, 150);
		widthMaps.put(3, 150);
		widthMaps.put(4, 150);
		widthMaps.put(5, 150);
		widthMaps.put(6, 150);
		widthMaps.put(7, 150);
		widthMaps.put(8, 150);
		widthMaps.put(9, 350);
		tablePanel.setColumnWidthMaps(widthMaps);
		tablePanel.setCustomButtons(selfCustomButtons);
		tablePanel.setShowPaging(true);
		tablePanel.setCustomButtonFlowAlign(FlowLayout.CENTER);
		tablePanel.setPageButtonFlowAlign(FlowLayout.CENTER);
		tablePanel.setShowExport(false);
		tablePanel.buildTablePanel();
		tablePanel.refreshTableData();
		return tablePanel;
	}
	/**
	 * 初始化页面
	 */
	private void init(){
		JPanel palMain = new JPanel();
		palMain.setLayout(new BorderLayout());
		palMain.setBorder(new TitledBorder(LOGMANAGE));
		
		JPanel palTop = new JPanel();//上部
		//初始化
		initTop(palTop);//上部
		initComboBox();//下拉框
		initAction();
	    
		palMain.add(palTop, BorderLayout.NORTH);
		palMain.add(tablePanel(), BorderLayout.CENTER);
		this.setLayout(new BorderLayout());
		this.add(palMain,BorderLayout.CENTER);
	}
	
	private void initAction(){
		queryDetail.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent paramActionEvent) {
				queryDetai_Method();
				
			}
		});
	}
	private void queryDetai_Method(){
		int  select = tablePanel.getSelectedRowIndexs().length;
		if(select ==0){
			VCIOptionPane.showMessage(this, 
					"请选择要查看的数据!");
			return;
		}else if(select>1){
			VCIOptionPane.showMessage(this, 
					"请选择单条数据进行查看!");
			return;
		}else{
			LinkedList<LogObject> list = tablePanel.getSelectedRowObjects();
			LogObject dataObj = list.getFirst();
			new DetailDialog(dataObj.getResult());
		}
	}
	/**
	 * 初始化上部
	 * @param palTop
	 */
	private void initTop(JPanel palTop){
		JPanel palLeft = new JPanel();//上部左边的部分
		palLeft.setLayout(null);
		palLeft.setPreferredSize(new Dimension(700,200));
		initTopLeft(palLeft);
		
		palTop.setLayout(new GridLayout());
		palTop.setPreferredSize(new Dimension(900,50));
		palTop.add(palLeft,new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
	            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 30, 10, 0), 0, 0));
	}
	
	/**
	 * 初始化上部左边
	 * @param palLeft
	 */
	private void initTopLeft(JPanel palLeft){

		/*-----------------------------第一行---------------------------------*/
		
		x = 20; y = 10; width = 80; height = 25; 
		dateLabelStart.setBounds(x, y, width, height);//查询日期:由
		
		x += dateLabelStart.getBounds().width+hspan; y = 10; width=120;height=25;
		startDateBox.setBounds(x, y, width, height);//起始日期
		
		x += startDateBox.getBounds().width+hspan; y = 10;width=25;height=25;
		startDateButton.setBounds(x, y, width, height);//日期控件
		
		x+= startDateButton.getBounds().width+hspan;y = 10;width=25;height=25;
		dateLabelTo.setBounds(x, y, width, height);//到
		
		x+= dateLabelTo.getBounds().width+hspan;y = 10;width=120;height=25;
		endDateBox.setBounds(x, y, width, height);//结束日期
		
		x+= endDateBox.getBounds().width+hspan;y = 10;width=25;height=25;
		endDateButton.setBounds(x, y, width, height);//日期控件
		
		/*-----------------------------第三行---------------------------------*/
		
		x = 460;y = 10;width = 60;height = 25;
		userLabel.setBounds(x, y, width, height);
		
		x+=userLabel.getBounds().width+hspan+20; width=180;
		userCombox.setBounds(x, y, width, height);
		userCombox.setEditable(true);
		
		x+=userCombox.getBounds().width+hspan+15; width=60;
		ipLabel.setBounds(x, y, width, height);
		x+=ipLabel.getBounds().width+hspan; width = 105; 
		ipText.setBounds(x, y, width, height);
		

		x+= ipText.getBounds().width + hspan + 20;
		width = 80;
		operateTypeLabel.setBounds(x,y,width,height);
		
		x+= operateTypeLabel.getBounds().width + hspan ;
		width = 100;
		typeText.setBounds(x,y,width,height);
		
		x+= typeText.getBounds().width + hspan; width = 80; 
		queryBtn.setBounds(x, y, width, height);
		
		
		//第一行
		palLeft.add(dateLabelStart);
		palLeft.add(startDateBox);
		palLeft.add(startDateButton);
		palLeft.add(dateLabelTo);
		palLeft.add(endDateBox);
		palLeft.add(endDateButton);
		//第三行
		palLeft.add(userLabel);
		palLeft.add(userCombox);
		palLeft.add(ipLabel);
		palLeft.add(ipText);
		palLeft.add(operateTypeLabel);
		palLeft.add(typeText);
		
		
		palLeft.add(queryBtn);
	}
	
	/**
	 * 初始化下拉框，用户，期限
	 */
	protected void initComboBox(){
		initUser();
	}
	
	/***
     *  初始化用户
     */
    protected void initUser() {
    	UserObject[] users = getUserObjects();
    	setUserObjectToComboBox(users);
	}
    
    private static final String SYSTEM_ADMIN_ROLE = "系统管理员";
    
    private static final String SEC_ADMIN_ROLE = "安全管理员";
    
    private static final String AUDIT_ADMIN_ROLE = "审计管理员";
    
    
    protected UserObject[] getUserObjects(){
//    	UserObject[] users = new UserObject[0];
//    	try {
//			RightManagementClientDelegate del = new RightManagementClientDelegate(LogonApplication.getUserEntityObject());
//			int userType = 0;
//			
//			List<UserObject> lstUser = new ArrayList<UserObject>();
//			if(isManagerQuery()){
//				RoleObject role = del.fetchRoleByName(SYSTEM_ADMIN_ROLE);
//				users = del.fetchUsersByRoleId(role.getId());
//				for (UserObject user : users)
//					lstUser.add(user);
//				
//				role = del.fetchRoleByName(SEC_ADMIN_ROLE);
//				users = del.fetchUsersByRoleId(role.getId());
//				for (UserObject user : users)
//					lstUser.add(user);
//				
////				role = del.fetchRoleByName(AUDIT_ADMIN_ROLE);
////				users = del.fetchUsersByRoleId(role.getId());
////				for (UserObject user : users)
////					lstUser.add(user);
//				
//				users = lstUser.toArray(new UserObject[0]);
//				userType = 0;
//			} else {
//				userType = 1;
//				users = del.fetchUserInfoByType(userType);
//				//看是不是审计管理员，审计管理员可以看系统管理和安全管理
//				
//				if(isAdminByRoleName(AUDIT_ADMIN_ROLE)){
//					return wrapperAdminUser(users, Arrays.asList(new String[]{SYSTEM_ADMIN_ROLE,SEC_ADMIN_ROLE}));
//				}
//				if(isAdminByRoleName(SEC_ADMIN_ROLE)){
//					return wrapperAdminUser(users, Arrays.asList(new String[]{AUDIT_ADMIN_ROLE}));
//				}
//			}
//			//users = del.fetchUserInfoByType(userType);
//		} catch (VCIException re) {
//			VCIOptionPane.showError(LogonApplication.frame, FILENAME, re);
//		}
//    	return users;
    	List<UserObject> users = new ArrayList<UserObject>();
		if("secAdmin".equals(ClientContextVariable.getInvocationInfo().userName)){
			try {
				users.addAll(getUsersByUserNames(Arrays.asList("auditAdmin")));
				users.addAll(getUsersByUserNames(getUserNameByUserType(2)));
			} catch (VCIException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (VCIError e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else if("auditAdmin".equals(ClientContextVariable.getInvocationInfo().userName)){
			try {
				users.addAll(getUsersByUserNames(Arrays.asList("secAdmin", "sysAdmin")));
			} catch (VCIException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} else if("sysAdmin".equals((ClientContextVariable.getInvocationInfo().userName))){
			
		}
		return users.toArray(new UserObject[users.size()]);
    }
    private List<UserObject> getUsersByUserNames(List<String> userNames) throws VCIException{
		List<UserObject> userList = new ArrayList<UserObject>();
		RightManagementClientDelegate rmcd = new RightManagementClientDelegate(LogonApplication.getUserEntityObject());
		for(String userName : userNames){
			userList.add(rmcd.fetchUserInfoByName(userName));
		}

		Collections.sort(userList, new Comparator<UserObject>(){
			@Override
			public int compare(UserObject o1, UserObject o2) {
				return o1.getUserName().compareTo(o2.getUserName());
			}
		});
		return userList;
	}
    
	private List<String> getUserNameByUserType(int userType) throws VCIError{
		List<String> userNames = new ArrayList<String>();
		String sql = "select plusername,pltruename from pluser u where u.plusertype = " + String.valueOf(userType);
		String[][] valss = QTClient.getService().queryBySqlWithoutKey(sql);
		for(String[] vals : valss){
			userNames.add(vals[0]);
		}
		return userNames;
	}
    
    private UserObject[] wrapperAdminUser(UserObject[] users,List<String> adminRoleList){
    	List<UserObject> userObjList = new ArrayList<UserObject>();
		Collections.addAll(userObjList, users);
		RightManagementClientDelegate del = new RightManagementClientDelegate(LogonApplication.getUserEntityObject());
		try{
			for(String roleName:adminRoleList){
				RoleObject role = del.fetchRoleByName(roleName);
				UserObject[] tempUsers = del.fetchUsersByRoleId(role.getId());
				for (UserObject user : tempUsers){
					userObjList.add(user);
				}
			}
		}catch(Throwable e){
			
		}
		return userObjList.toArray(new UserObject[0]);
    }
    
    
    private boolean isAdminByRoleName(String roleName){
    	boolean isAuditUser = false;
		try{
	    	RightManagementClientDelegate del = new RightManagementClientDelegate(LogonApplication.getUserEntityObject());
	    	RoleObject role = del.fetchRoleByName(roleName);
			UserObject[] auditUsers = del.fetchUsersByRoleId(role.getId());

			for (UserObject user : auditUsers){
				if(user.getUserName().equals(LogonApplication.getUserObject().getUserName())){
					isAuditUser = true;
					break;
				}
			}
		}catch(Throwable a){
			
		}
		return isAuditUser;
    }
    

    protected void setUserObjectToComboBox(UserObject[] users){
		for(UserObject obj : users){
			userCombox.addItem(obj);
		}
		userCombox.setSelectedIndex(-1);
    }
    
    /**
     * 获取查询条件并拼成SQL，只拼where子句后面的SQL
     * @return
     */
    public String getSQL(){
    	String startDate = String.valueOf(this.startDateBox.getSelectedItem());//获取起始时间
    	String endDate = String.valueOf(this.endDateBox.getSelectedItem());//获取结束时间
    	
    	StringBuffer sql = new StringBuffer("");
    	int period = this.getPeriod(LOG_SAVE_PERIOD);//获取保存期限，以月为单位
    	//下面是拼出SQL
    	if(period != 0){
    		sql.append(" to_date(PLDATE) >= add_months(to_date(sysdate),"+(-period)+")");
    	}
    	if(!startDate.trim().equals("")&&!startDate.equals("null")&&startDate!=null){//起始日期
    		if(!sql.toString().equals("")){
    			sql.append(" and ");
    		}
    		sql.append(" to_date(PLDATE) >= to_date('"+startDate.trim()+"','yyyy-MM-dd') ");
    	}
    	if(!endDate.trim().equals("")&&!endDate.equals("null")&&endDate!=null){//结束日期
    		if(!sql.toString().equals("")){
    			sql.append(" and ");
    		}
    		sql.append(" trunc(PLDATE) <= to_date('"+endDate.trim()+"','yyyy-MM-dd')");
    	}
    	
    	if(getLogType() == LogType.Login) {//登入登出日志
    		if(!sql.toString().equals("")){
    			sql.append(" and ");
    		}
    		sql.append("PLLOGTYPE in ('" + getLogTypeString(LogType.Login) +"','" + getLogTypeString(LogType.Logout)+ "')");
    	} else if(getLogType() == LogType.GrantPrivileges) {//授权日志
    		if(!sql.toString().equals("")){
    			sql.append(" and ");
    		}
    		sql.append("PLLOGTYPE in('" + getLogTypeString(LogType.GrantPrivileges) + "')");
    	} else if(getLogType() == LogType.GeneralOperation) {//一般操作日志
    		if(!sql.toString().equals("")){
    			sql.append(" and ");
    		}
    		sql.append("PLLOGTYPE in('" + getLogTypeString(LogType.GeneralOperation) + "')");
    	}
//    	String roleNameSql = getSqlByRole();
//    	if(!"".equals(roleNameSql)) {
//    		sql.append(" and "+ roleNameSql);
//    	}
//    	
    	if(userCombox.getSelectedItem() !=  null&&!userCombox.getSelectedItem().equals("")){//操作用户
    		String userName = "";
    		Object obj = userCombox.getSelectedItem();
    		if(obj instanceof UserObject){
    			UserObject user = (UserObject)obj;
    			userName = user.getUserName();
    		}else{
    			userName = (String)obj;
    		}
    		if(!userName.trim().equals("")){//如果用户名为空格则不加用户条件
    			if(!sql.toString().equals("")){
    				sql.append(" and ");
    			}
    			if(userName.contains("*")){
    				userName = userName.trim().replaceAll("\\*", "%");
    				sql.append(" PLUSER like '").append(userName.trim()).append("'");
    			}else{
    				sql.append(" PLUSER = '").append(userName.trim()).append("'");
    			}
    		}
    	}
    	//按IP查询
    	if(!ipText.getText().trim().equals("")){
    		String ip = ipText.getText().trim();
    		if(!sql.toString().equals("")){
				sql.append(" and ");
			}
    		if(ip.trim().contains("*")){//模糊查询
    			ip = ip.trim().replaceAll("\\*", "%");
    			sql.append(" PLIP like '").append(ip.trim()).append("'");
    		}else{
    			sql.append(" PLIP = '").append(ip.trim()).append("'");
    		}
    	}
    	if(StringUtils.isNotBlank(typeText.getText())){
    		String typeValue = typeText.getText();
    		sql.append(" and pltype like '%").append(typeValue).append("%'");
    	}
    	//过滤掉admin和developer用户的日志记录
    	sql.append(" and PLUSER !='admin' and  PLUSER !='developer' ");
    	
    	sql.append(" and pluser != '" + ClientContextVariable.getInvocationInfo().userName + "' ");
    	

    	// 安全保密员不看系统管理员的日志
		if("secAdmin".equals(ClientContextVariable.getInvocationInfo().userName)){
	    	sql.append(" and pluser != 'sysAdmin' ");
		}
		// 审计管理员只看系统管理员和安全保密员的日志
		else if("auditAdmin".equals(ClientContextVariable.getInvocationInfo().userName)){
			sql.append(" and pluser in ('secAdmin', 'sysAdmin')");
		}
    	return sql.toString();
    }
    protected String getSqlByRole(){
		RightManagementClientDelegate del = new RightManagementClientDelegate(LogonApplication.getUserEntityObject());
		StringBuilder roleNameString = new StringBuilder();
		
		try {
			RoleObject[] roleObj =  del.fetchRoleInfoByRoleType(1);//取出管理员角色
			StringBuilder userString = new StringBuilder();
			for(int k = 0;k < roleObj.length;k++) {
				RoleObject obj = roleObj[k];
				userString.append(" '");
				userString.append(obj.getName());
				userString.append("' ");
				if(k < roleObj.length - 1) {
					userString.append(" ,");
				}
			}
			
			if("".equals(userString.toString())) {
				return "";
			}
			//管理员日志记录
			if(isManagerQuery()){
				roleNameString.append("PLROLENAME in ( ");
			}else{
				roleNameString.append("PLROLENAME not in ( ");
			}
			
			roleNameString.append(userString.toString());
			roleNameString.append(" ) ");
		} catch (VCIException e) {
			e.printStackTrace();
			VCIOptionPane.showError(LogonApplication.frame,"RMIPFramework", e);
		}
		
		return roleNameString.toString();
	}
    
    protected String getLogTypeString(LogType logType){
		String res = "";
		if(logType == LogType.Login) {
			res = "登录";
		} else if(logType == LogType.Logout) {
			res = "登出";
		} else if(logType == LogType.GrantPrivileges) {
			res = "授权";
		} else if(logType == LogType.GeneralOperation) {
			res = "一般操作";
		} else if(logType == LogType.Integration) {
			res = "集成应用";
		}
		return res;
	}
    
    /**
     * 获取日志保存期限
     * @param type 类型，判断是保存还是备份期限
     * @return
     */
    protected int getPeriod(String type){
    	int curPeriod = 0;
    	try {
    		curPeriod = this.logDel.getCurPeriod(type);
		} catch (VCIException e) {
			VCIOptionPane.showError(LogonApplication.frame, FILENAME, e);
			curPeriod = 0;
		}
		return curPeriod;
    }
    
    
    
}