/src/com/sogou/qadev/service/cynthia/service/DataAccessSession.java

package com.sogou.qadev.service.cynthia.service;

import java.sql.Timestamp;
import java.util.List;
import java.util.Map;

import com.sogou.qadev.service.cynthia.bean.Action;
import com.sogou.qadev.service.cynthia.bean.Attachment;
import com.sogou.qadev.service.cynthia.bean.Data;
import com.sogou.qadev.service.cynthia.bean.DataAccessAction;
import com.sogou.qadev.service.cynthia.bean.Field;
import com.sogou.qadev.service.cynthia.bean.Filter;
import com.sogou.qadev.service.cynthia.bean.Flow;
import com.sogou.qadev.service.cynthia.bean.GuideBean;
import com.sogou.qadev.service.cynthia.bean.JSTree;
import com.sogou.qadev.service.cynthia.bean.Option;
import com.sogou.qadev.service.cynthia.bean.QueryCondition;
import com.sogou.qadev.service.cynthia.bean.Role;
import com.sogou.qadev.service.cynthia.bean.Script;
import com.sogou.qadev.service.cynthia.bean.Stat;
import com.sogou.qadev.service.cynthia.bean.TagBean;
import com.sogou.qadev.service.cynthia.bean.Template;
import com.sogou.qadev.service.cynthia.bean.TemplateOperateLog;
import com.sogou.qadev.service.cynthia.bean.TemplateType;
import com.sogou.qadev.service.cynthia.bean.Timer;
import com.sogou.qadev.service.cynthia.bean.TimerAction;
import com.sogou.qadev.service.cynthia.bean.UUID;
import com.sogou.qadev.service.cynthia.bean.UserInfo;
import com.sohu.rd.td.util.reference.Pair;

/**
 * @description:data process interface
 * @author:liming
 * @mail:liming@sogou-inc.com
 * @date:2014-5-6 上午10:13:32
 * @version:v1.0
 */
public interface DataAccessSession
{
	/**
	 * @description:update cache
	 * @date:2014-5-6 上午10:12:00
	 * @version:v1.0
	 * @param daa: delete update 
	 * @param key:cache data key
	 * @param object:cache data 
	 */
	public void updateCache(DataAccessAction daa, String key ,Object object);
	
	/**
	 * @description:return data filter interface
	 * @date:2014-5-6 上午10:13:26
	 * @version:v1.0
	 * @return
	 */
	public DataFilter getDataFilter();

	/**
	 * @description:return current user
	 * @date:2014-5-6 上午10:14:11
	 * @version:v1.0
	 * @return
	 */
	public String getUsername();

	/**
	 * @description:TODO
	 * @date:2014-5-6 上午10:14:29
	 * @version:v1.0
	 * @return
	 */
	public long getKeyId();

	/**
	 * @description:TODO
	 * @date:2014-5-6 上午10:14:35
	 * @version:v1.0
	 * @return
	 */
	public String getAgent();
	
	/**
	 * @description:remove flow from database
	 * @date:2014-5-6 上午10:14:40
	 * @version:v1.0
	 * @param flowId
	 * @return
	 */
	public ErrorCode removeFlow(UUID flowId);

	/**
	 * @description:begin transcation
	 * @date:2014-5-6 上午10:15:29
	 * @version:v1.0
	 * @return
	 */
	public ErrorCode beginTranscation();

	/**
	 * @description:transcation rollback
	 * @date:2014-5-6 上午10:15:48
	 * @version:v1.0
	 * @return
	 */
	public ErrorCode rollbackTranscation();

	/**
	 * @description:commit transcation
	 * @date:2014-5-6 上午10:16:01
	 * @version:v1.0
	 * @return
	 */
	public ErrorCode commitTranscation();

	/**
	 * @description:query data by data id
	 * @date:2014-5-6 上午10:16:11
	 * @version:v1.0
	 * @param id:data id
	 * @return
	 */
	public Data queryData(UUID id); 
	
	/**
	 * @description:query data from data id and template id
	 * @date:2014-5-6 上午10:16:24
	 * @version:v1.0
	 * @param id
	 * @param templateId
	 * @return
	 */
	public Data queryData(UUID id , UUID templateId);   
	
	/**
	 * @description:query data from sql
	 * @date:2014-5-6 上午10:16:47
	 * @version:v1.0
	 * @param sql
	 * @param needLog:need data log
	 * @param templateId
	 * @return
	 */
	public List<Data> queryDataBySql(String sql , boolean needLog, UUID templateId);

	/**
	 * @description:add data, get data uuid
	 * @date:2014-5-6 上午10:17:13
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public Data addData(UUID templateId);
	
	/**
	 * @description:copy data
	 * @date:2014-5-6 上午10:18:00
	 * @version:v1.0
	 * @param dataId
	 * @param templateId
	 * @param actionId
	 * @param actionUser
	 * @param actionComment
	 * @param baseValueMap
	 * @param extValueMap
	 * @return
	 */
	public Data copyData(UUID dataId, UUID templateId, UUID actionId, String actionUser, String actionComment,
			Map<String, Pair<Object, Object>> baseValueMap, Map<UUID, Pair<Object, Object>> extValueMap); 

	/**
	 * @description:remove template from database
	 * @date:2014-5-6 上午10:18:23
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public ErrorCode removeTemplate(Template templateId);

	/**
	 * @description:query template from cache or database
	 * @date:2014-5-6 上午10:18:35
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public Template queryTemplate(UUID templateId); 
	
	/**
	 * @description:query all templates by templatetype
	 * @date:2014-5-6 上午10:19:15
	 * @version:v1.0
	 * @param templateTypeId
	 * @return
	 */
	public List<Template> queryTemplates(UUID templateTypeId); 

	/**
	 * @description:query field from templates by fieldId
	 * @date:2014-5-6 上午10:19:34
	 * @version:v1.0
	 * @param fieldId
	 * @return
	 */
	public Field queryField(UUID fieldId); 
	
	/**
	 * @description:query field from template
	 * @date:2014-5-6 上午10:20:02
	 * @version:v1.0
	 * @param fieldId
	 * @param templateId
	 * @return
	 */
	public Field queryField(UUID fieldId , UUID templateId); 

	/**
	 * @description:query option from template by template id
	 * @date:2014-5-6 上午10:20:25
	 * @version:v1.0
	 * @param optionId
	 * @param templateId
	 * @return
	 */
	public Option queryOption(UUID optionId ,UUID templateId);
	
	/**
	 * @description:query option from template
	 * @date:2014-5-6 上午10:21:04
	 * @version:v1.0
	 * @param optionId
	 * @param template
	 * @return
	 */
	public Option queryOption(UUID optionId, Template template); 
	
	/**
	 * @description:query datas by template id and other query conditions
	 * @date:2014-5-6 上午10:21:18
	 * @version:v1.0
	 * @param templateId
	 * @param queryConditions
	 * @param needLog
	 * @return
	 */
	public Data[] queryDatas(UUID templateId, List<QueryCondition> queryConditions,boolean needLog);

	/**
	 * @description:query template type by templatetype id
	 * @date:2014-5-6 上午10:22:05
	 * @version:v1.0
	 * @param templateTypeId
	 * @return
	 */
	public TemplateType queryTemplateType(UUID templateTypeId); 

	/**
	 * @description:create attachment from name and atta data
	 * @date:2014-5-6 上午10:22:20
	 * @version:v1.0
	 * @param name
	 * @param data
	 * @return
	 */
	public Attachment createAttachment(String name, byte[] data); 

	/**
	 * @description:query attachement by id 
	 * @date:2014-5-6 上午10:22:46
	 * @version:v1.0
	 * @param id
	 * @param needData:if attachment data need
	 * @return
	 */
	public Attachment queryAttachment(UUID id, boolean needData);

	/**
	 * @description: query attachments by ids
	 * @date:2014-5-6 上午10:23:24
	 * @version:v1.0
	 * @param ids
	 * @param needData:if attachment data need
	 * @return
	 */
	public Attachment[] queryAttachments(UUID[] ids, boolean needData); 

	/**
	 * @description:modify data
	 * @date:2014-5-6 上午10:24:11
	 * @version:v1.0
	 * @param data
	 * @return
	 */
	public Pair<ErrorCode, String> modifyData(Data data);  

	/**
	 * @description:remove data
	 * @date:2014-5-6 上午10:24:22
	 * @version:v1.0
	 * @param data
	 * @return
	 */
	public ErrorCode removeData(Data data); 

	/**
	 * @description:remove data from cache
	 * @date:2014-5-6 上午10:24:31
	 * @version:v1.0
	 * @param data
	 * @return
	 */
	public ErrorCode removeDataFromCache(Data data);   

	/**
	 * @description:close and commit transcation
	 * @date:2014-5-6 上午10:25:20
	 * @version:v1.0
	 */
	public void close();  

	/**
	 * @description:return is transcation is commit automatic
	 * @date:2014-5-6 上午10:25:40
	 * @version:v1.0
	 * @return
	 */
	public boolean isAutoCommit();   

	/**
	 * @description:set transcation if commit automatic 
	 * @date:2014-5-6 上午10:26:40
	 * @version:v1.0
	 * @param b:true auto ,  false not
	 */
	public void setAutoCommit(boolean b);   

	/**
	 * @description:return script process interface
	 * @date:2014-5-6 上午10:27:26
	 * @version:v1.0
	 * @return
	 */
	public ScriptAccessSession createScriptAccessSession(); 

	/**
	 * @description:create flow
	 * @date:2014-5-6 上午10:28:37
	 * @version:v1.0
	 * @param userName:create user name
	 * @return
	 */
	public Flow createFlow(String userName); 

	/**
	 * @description:create template
	 * @date:2014-5-6 上午10:29:37
	 * @version:v1.0
	 * @param templateTypeId:template type
	 * @return
	 */
	public Template createTemplate(UUID templateTypeId); 

	/**
	 * @description:update template
	 * @date:2014-5-6 上午10:31:08
	 * @version:v1.0
	 * @param template
	 * @return
	 */
	public ErrorCode updateTemplate(Template template);   

	/**
	 * @description:query flow by flow id
	 * @date:2014-5-6 上午10:31:49
	 * @version:v1.0
	 * @param flowId
	 * @return
	 */
	public Flow queryFlow(UUID flowId);  
	
	/**
	 * @description:update flow svgcode
	 * @date:2014-5-6 上午10:32:01
	 * @version:v1.0
	 * @param flowId
	 * @param svgCode
	 * @return
	 */
	public boolean updateSvg(UUID flowId,String svgCode);
	
	/**
	 * @description:query flow svgcode
	 * @date:2014-5-6 上午10:32:16
	 * @version:v1.0
	 * @param flowId
	 * @return
	 */
	public String queryFlowSvg(UUID flowId); 

	/**
	 * @description:query stat from flow
	 * @date:2014-5-6 上午10:32:26
	 * @version:v1.0
	 * @param statId
	 * @param flowId
	 * @return
	 */
	public Stat queryStat(UUID statId , UUID flowId); 

	/**
	 * @description:query action from flow
	 * @date:2014-5-6 上午10:32:36
	 * @version:v1.0
	 * @param actionId
	 * @param flowId
	 * @return
	 */
	public Action queryAction(UUID actionId , UUID flowId); 
	
	/**
	 * @description:query role from flow
	 * @date:2014-5-6 上午10:32:45
	 * @version:v1.0
	 * @param roleId
	 * @param flowId
	 * @return
	 */
	public Role queryRole(UUID roleId , UUID flowId); 

	/**
	 * @description:query flows by from ids
	 * @date:2014-5-6 上午10:32:56
	 * @version:v1.0
	 * @param flowIdArray
	 * @return
	 */
	public Flow[] queryFlows(UUID[] flowIdArray); 

	/**
	 * @description:query templates by template ids
	 * @date:2014-5-6 上午10:33:09
	 * @version:v1.0
	 * @param templateIdArray
	 * @return
	 */
	public Template[] queryTemplates(UUID[] templateIdArray); 

	/**
	 * @description:query templatetypes by templatetype ids
	 * @date:2014-5-6 上午10:33:23
	 * @version:v1.0
	 * @param templateTypeIdArray
	 * @return
	 */
	public TemplateType[] queryTemplateTypes(UUID[] templateTypeIdArray);

	/**
	 * @description:update flow
	 * @date:2014-5-6 上午10:33:37
	 * @version:v1.0
	 * @param flow
	 * @return
	 */
	public ErrorCode updateFlow(Flow flow);  

	/**
	 * @description:query all flows
	 * @date:2014-5-6 上午10:33:54
	 * @version:v1.0
	 * @return
	 */
	public Flow[] queryAllFlows();  

	/**
	 * @description:query all templates
	 * @date:2014-5-6 上午10:34:27
	 * @version:v1.0
	 * @return
	 */
	public Template[] queryAllTemplates(); 
 
	/**
	 * @description:query all templatetypes
	 * @date:2014-5-6 上午10:34:47
	 * @version:v1.0
	 * @return
	 */
	public TemplateType[] queryAllTemplateTypes(); 

	/**
	 * @description:add filter to database
	 * @date:2014-5-6 上午10:35:05
	 * @version:v1.0
	 * @param filter
	 * @return
	 */
	public Filter addFilter(Filter filter); 

	/**
	 * @description:query filter by filter id
	 * @date:2014-5-6 上午10:35:18
	 * @version:v1.0
	 * @param filterId
	 * @return
	 */
	public Filter queryFilter(UUID filterId); 

	/**
	 * @description:query all filters of user
	 * @date:2014-5-6 上午10:37:27
	 * @version:v1.0
	 * @param username
	 * @return
	 */
	public Filter[] queryFilters(String username); 

	/**
	 * @description:query filter id and name of user
	 * @date:2014-5-6 上午10:37:53
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public Map<String,String> queryFilterIdNameMap(String userName);
	
	/**
	 * @description:query system filters
	 * @date:2014-5-6 上午10:38:15
	 * @version:v1.0
	 * @param username
	 * @return
	 */
	public Filter[] querySysFilters(String username);  

	/**
	 * @description:query all focus filter of user
	 * @date:2014-5-6 上午10:39:04
	 * @version:v1.0
	 * @param username
	 * @return
	 */
	public Filter[] queryFocusFilters(String username); 

	/**
	 * @description:query all filters
	 * @date:2014-5-6 上午10:39:33
	 * @version:v1.0
	 * @return
	 */
	public List<Filter> queryAllFilters();  

	/**
	 * @description:remove filter by filter id
	 * @date:2014-5-6 上午10:39:42
	 * @version:v1.0
	 * @param filterId
	 * @return
	 */
	public ErrorCode removeFilter(UUID filterId);  

	/**
	 * 	@description:update filter 
	 * @date:2014-5-6 上午10:39:56
	 * @version:v1.0
	 * @param filter
	 * @return
	 */
	public ErrorCode updateFilter(Filter filter); 

	/**
	 * @description:create filter 
	 * @date:2014-5-6 上午10:40:11
	 * @version:v1.0
	 * @param createUser
	 * @param createTime
	 * @param fatherId:father folder id
	 * @return
	 */
	public Filter createFilter(String createUser, Timestamp createTime, UUID fatherId); 

	/**
	 * @description:create tmp filter
	 * @date:2014-5-6 上午10:40:59
	 * @version:v1.0
	 * @param createUser
	 * @param createTime
	 * @param fatherId
	 * @return
	 */
	public Filter createTempFilter(String createUser, Timestamp createTime, UUID fatherId); 

	/**
	 * @description:get filters new and old datas
	 * @date:2014-5-6 上午10:42:15
	 * @version:v1.0
	 * @param filterIdArray
	 * @param username
	 * @return:xml
	 */
	public String getNewTaskIdsByFilterAndUser(UUID[] filterIdArray, String username); 

	/**
	 * @description:set data old of filter
	 * @date:2014-5-6 上午10:43:12
	 * @version:v1.0
	 * @param filterId
	 * @param taskIdArray
	 * @param username
	 * @return
	 */
	public String cleanNewTagByTaskIds(UUID filterId, UUID[] taskIdArray, String username);  

	/**
	 * @description:remove old data
	 * @date:2014-5-6 上午10:45:38
	 * @version:v1.0
	 * @param dataId
	 */
	public void deleteFilterUserTasks(UUID dataId);
	
	/**
	 * @description:query filters focused by user
	 * @date:2014-5-6 上午10:45:58
	 * @version:v1.0
	 * @param username
	 * @return
	 */
	public UUID[] queryUserFocusFilters(String username);   

	/**
	 * @description:remove user focus filter
	 * @date:2014-5-6 上午10:46:15
	 * @version:v1.0
	 * @param username
	 * @param filterId
	 * @return
	 */
	public ErrorCode removeUserFocusFilter(String username, UUID filterId);  

	/**
	 * @description:add user focus filter
	 * @date:2014-5-6 上午10:46:29
	 * @version:v1.0
	 * @param username
	 * @param filterId
	 * @return
	 */
	public ErrorCode addUserFocusFilter(String username, UUID filterId);  

	/**
	 * @description:remove user by username
	 * @date:2014-5-6 上午10:46:43
	 * @version:v1.0
	 * @param username
	 * @return
	 */
	public ErrorCode removeRelatedUser(String username); 

	/**
	 * @description:create timer return uuid
	 * @date:2014-5-6 上午10:48:01
	 * @version:v1.0
	 * @param createUser
	 * @return
	 */
	public Timer createTimer(String createUser);  

	/**
	 * @description:add timer to database
	 * @date:2014-5-6 上午10:48:13
	 * @version:v1.0
	 * @param timer
	 * @return
	 */
	public ErrorCode addTimer(Timer timer); 

	/**
	 * @description:remove timer from database
	 * @date:2014-5-6 上午10:49:06
	 * @version:v1.0
	 * @param timerId
	 * @return
	 */
	public ErrorCode removeTimer(UUID timerId); 

	/**
	 * @description:modify timer
	 * @date:2014-5-6 上午10:49:17
	 * @version:v1.0
	 * @param timer
	 * @return
	 */
	public ErrorCode modifyTimer(Timer timer); 

	/**
	 * @description:query timer from timer id
	 * @date:2014-5-6 上午10:49:32
	 * @version:v1.0
	 * @param timerId
	 * @return
	 */
	public Timer queryTimer(UUID timerId); 

	/**
	 * @description:query timers by user
	 * @date:2014-5-6 上午10:49:46
	 * @version:v1.0
	 * @param username
	 * @return
	 */
	public Timer[] queryTimers(String username); 

	/**
	 * @description:query all timers
	 * @date:2014-5-6 上午10:49:57
	 * @version:v1.0
	 * @return
	 */
	public Timer[] queryTimers(); 
	
	/**
	 * @description:query timer by timer action id
	 * @date:2014-5-6 上午10:50:08
	 * @version:v1.0
	 * @param timerActionId
	 * @return
	 */
	public Timer[] queryTimersByActionId(UUID timerActionId);

	/**
	 * @description:create timer action
	 * @date:2014-5-6 上午10:50:22
	 * @version:v1.0
	 * @return
	 */
	public TimerAction createTimerAction();  

	/**
	 * @description:add timer action to database
	 * @date:2014-5-6 上午10:50:33
	 * @version:v1.0
	 * @param timerAction
	 * @return
	 */
	public ErrorCode addTimerAction(TimerAction timerAction); 

	/**
	 * @description:remove timer action from database
	 * @date:2014-5-6 上午10:50:46
	 * @version:v1.0
	 * @param timerActionId
	 * @return
	 */
	public ErrorCode removeTimerAction(UUID timerActionId); 

	/**
	 * @description:modify timer action from database
	 * @date:2014-5-6 上午10:51:01
	 * @version:v1.0
	 * @param timerAction
	 * @return
	 */
	public ErrorCode modifyTimerAction(TimerAction timerAction); 

	/**
	 * @description:query timer action from timer action id
	 * @date:2014-5-6 上午10:51:16
	 * @version:v1.0
	 * @param timerActionId
	 * @return
	 */
	public TimerAction queryTimerAction(UUID timerActionId); 

	/**
	 * @description:query all timer actions
	 * @date:2014-5-6 上午10:51:30
	 * @version:v1.0
	 * @return
	 */
	public TimerAction[] queryTimerActions(); 

	/**
	 * @description:query data create users by templatetype id
	 * @date:2014-5-6 上午10:52:36
	 * @version:v1.0
	 * @param templateTypeId
	 * @return
	 */
	public String[] queryTemplateTypeCreateUsers(UUID templateTypeId); 

	/**
	 * @description:query all assign users by templatetype id
	 * @date:2014-5-6 上午10:52:54
	 * @version:v1.0
	 * @param templateTypeId
	 * @return
	 */
	public String[] queryTemplateTypeAssignUsers(UUID templateTypeId); 

	/**
	 * @description:query all statu names by template type id
	 * @date:2014-5-6 上午10:53:12
	 * @version:v1.0
	 * @param templateTypeId
	 * @return
	 */
	public String[] queryTemplateTypeStats(UUID templateTypeId);  
	
	/**
	 * @description:query all datas by template id(need datalog)
	 * @date:2014-5-6 上午10:54:08
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public Data[] queryTemplateDatas(UUID templateId);  
	
	/**
	 * @description:query all datas by template id
	 * @date:2014-5-6 上午10:54:22
	 * @version:v1.0
	 * @param templateId
	 * @param needLog:if need data log
	 * @return
	 */
	public Data[] queryTemplateDatas(UUID templateId , boolean needLog);  
	
	/**
	 * @description:query datas by template id and create time 
	 * @date:2014-5-6 上午10:55:16
	 * @version:v1.0
	 * @param templateId
	 * @param needLog
	 * @param startTime:createTime start
	 * @param endTime:createTime end
	 * @return
	 */
	public Data[] queryTemplateDatas(UUID templateId , boolean needLog , Timestamp startTime , Timestamp endTime);  
	
	/**
	 * @description:query datas by template id
	 * @date:2014-5-6 上午10:56:07
	 * @version:v1.0
	 * @param templateId
	 * @param needLog
	 * @param startTime
	 * @param endTime
	 * @param allQueryList:other query conditions
	 * @return
	 */
	public Data[] queryTemplateDatas(UUID templateId , boolean needLog , Timestamp startTime, Timestamp endTime , List<QueryCondition> allQueryList);

	/**
	 * @description:query datas of template by lastmodifytime
	 * @date:2014-5-6 上午10:56:35
	 * @version:v1.0
	 * @param templateId
	 * @param needLog
	 * @param startTime:last modify time start
	 * @param endTime:last modify time end
	 * @return
	 */
	public Data[] queryTemplateDatasByLastModifyTime(UUID templateId , boolean needLog , Timestamp startTime , Timestamp endTime);  
	
	/**
	 * @description:query all createusers by template id
	 * @date:2014-5-6 上午10:57:08
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public String[] queryTemplateCreateUsers(UUID templateId); 

	/**
	 * @description:query all assign users by template id
	 * @date:2014-5-6 上午10:57:32
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public String[] queryTemplateAssignUsers(UUID templateId);  

	/**
	 * @description:query all stats by template id
	 * @date:2014-5-6 上午10:57:44
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public Stat[] queryTemplateStats(UUID templateId);  

	/**
	 * @description:query all reference datas by template id and reference field id
	 * @date:2014-5-6 上午11:00:38
	 * @version:v1.0
	 * @param templateId
	 * @param fieldId
	 * @return
	 */
	public Data[] queryTemplateFieldReferences(UUID templateId, UUID fieldId); 

	/**
	 * @description:query all attachments by template and field id
	 * @date:2014-5-6 上午11:01:13
	 * @version:v1.0
	 * @param templateId
	 * @param fieldId
	 * @return
	 */
	public Attachment[] queryTemplateFieldAttachments(UUID templateId, UUID fieldId); 

	/**
	 * @description:check user privilege of data
	 * @date:2014-5-6 上午11:02:23
	 * @version:v1.0
	 * @param data
	 * @param action
	 * @return
	 */
	public boolean checkUserPrivilege(Data data, DataAccessAction action);
			
	/**
	 * @description:check user privilege
	 * @date:2014-5-6 上午11:02:48
	 * @version:v1.0
	 * @param data
	 * @param action
	 * @param template
	 * @param flow
	 * @return
	 */
	public boolean checkUserPrivilege(Data data, DataAccessAction action ,Template template , Flow flow); 

	/**
	 * @description:check if data exist
	 * @date:2014-5-6 上午11:03:20
	 * @version:v1.0
	 * @param dataId
	 * @return
	 */
	public boolean isDataExist(UUID dataId); 

	/**
	 * @description:query all focus user of filter
	 * @date:2014-5-6 上午11:04:21
	 * @version:v1.0
	 * @param filterId
	 * @return
	 */
	public List<String> queryFocusUsersByFilter(UUID filterId); 

	/**
	 * @description:query all children nodes by node id and user
	 * @date:2014-5-6 上午11:04:39
	 * @version:v1.0
	 * @param id
	 * @param userName
	 * @return
	 */
	public List<JSTree> queryChilderNodes(int nodeId ,String userName); 

	/**
	 * @description:query JStree node by nodeId
	 * @date:2014-5-6 上午11:05:45
	 * @version:v1.0
	 * @param nodeId
	 * @return
	 */
	public JSTree queryJSTreeNodeById(int nodeId); 

	/**
	 * @description:add jstree node
	 * @date:2014-5-6 上午11:06:00
	 * @version:v1.0
	 * @param parentId
	 * @param position
	 * @param title
	 * @param userName
	 * @return
	 */
	public int addJSTreeNode(int parentId,int position,String title,String userName); 

	/**
	 * @description:remove jstree node
	 * @date:2014-5-6 上午11:06:12
	 * @version:v1.0
	 * @param id
	 * @param userName
	 * @return
	 */
	public boolean removJSTreeNode(int id,String userName); 
 
	/**
	 * @description:update jstree node title 
	 * @date:2014-5-6 上午11:06:24
	 * @version:v1.0
	 * @param id
	 * @param title
	 * @return
	 */
	public boolean updateJSTreeNode(int id,String title); 

	/**
	 * @description:move jstree node
	 * @date:2014-5-6 上午11:06:37
	 * @version:v1.0
	 * @param id
	 * @param refId
	 * @param position
	 * @param title
	 * @param copy
	 * @param userName
	 * @return
	 */
	public boolean moveJSTreeNode(int id,int refId,int position,String title, boolean copy,String userName); 

	/**
	 * @description:move filter position in jstree
	 * @date:2014-5-6 上午11:06:58
	 * @version:v1.0
	 * @param filterId
	 * @param refId
	 * @param parentId
	 * @return
	 */
	public boolean moveFilterNode(int filterId,int refId,int parentId);  

	/**
	 * @description:query all filters from jstree
	 * @date:2014-5-6 上午11:07:22
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public List<String> queryAllFolderFilters(String userName); 

	/**
	 * @description:query timers by filter id
	 * @date:2014-5-6 上午11:08:07
	 * @version:v1.0
	 * @param filterId
	 * @return
	 */
	public Timer[] queryTimerByFilterId(UUID filterId); 

	/**
	 * @description:query filters by folder node if
	 * @date:2014-5-6 上午11:08:42
	 * @version:v1.0
	 * @param nodeId
	 * @return
	 */
	public List<String> queryFolderFilters(int nodeId); 

	/**
	 * @description:query all root node of jstree
	 * @date:2014-5-6 上午11:09:03
	 * @version:v1.0
	 * @param id
	 * @return
	 */
	public List<JSTree> queryRootNode(int id); 

	/**
	 * @description:remove filter from jstree
	 * @date:2014-5-6 上午11:09:22
	 * @version:v1.0
	 * @param filterId
	 * @param parentId
	 * @return
	 */
	public boolean removeFilterId(int filterId,int parentId); 

	/**
	 * @description:query all favorite filters by user
	 * @date:2014-5-6 上午11:10:15
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public String[] queryFavoriteFilters(String userName); 

	/**
	 * @description:add favorite filter of user
	 * @date:2014-5-6 上午11:10:40
	 * @version:v1.0
	 * @param userName
	 * @param filterId
	 * @return
	 */
	public boolean addFavoriteFilter(String userName,String filterId); 

	/**
	 * @description:remove favorite filter of user
	 * @date:2014-5-6 上午11:11:02
	 * @version:v1.0
	 * @param userName
	 * @param filterId
	 * @return
	 */
	public boolean removeFavoriteFilter(String userName,String filterId); 

	/**
	 * @description:update all favorite filters of user
	 * @date:2014-5-6 上午11:12:52
	 * @version:v1.0
	 * @param filterarrays
	 * @param userName
	 * @return
	 */
	public boolean updataFavoriteFilters(String filterarrays,String userName); 

	/**
	 * @description:query user home filter
	 * @date:2014-5-6 上午11:13:11
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public String queryHomeFilter(String userName); 

	/**
	 * @description:add home filter 
	 * @date:2014-5-6 上午11:13:21
	 * @version:v1.0
	 * @param userName
	 * @param filterId
	 * @return
	 */
	public boolean addHomeFilter(String userName,String filterId); 
 
	/**
	 * @description:update home filter
	 * @date:2014-5-6 上午11:13:32
	 * @version:v1.0
	 * @param userName
	 * @param filterId
	 * @return
	 */
	public boolean updateHomeFilter(String userName,String filterId); 

	/**
	 * @description:update favoriter filter position
	 * @date:2014-5-6 上午11:13:47
	 * @version:v1.0
	 * @param filterId
	 * @param position
	 * @param userName
	 * @return
	 */
	public boolean updateFavoritesFilters(String filterId,int position,String userName); 

	/**
	 * @description:add filter to jstree node
	 * @date:2014-5-6 上午11:15:16
	 * @version:v1.0
	 * @param fitlerId
	 * @param nodeId
	 * @return
	 */
	public boolean addFilterToFolder(String fitlerId,int nodeId); 

	/**
	 * @description:query all scripts of user
	 * @date:2014-5-6 上午11:21:03
	 * @version:v1.0
	 * @param userName
	 * @param keyId
	 * @return
	 */
	public List<Script> queryAllScripts(String userName,long keyId); 

	/**
	 * @description:update filter orders of node
	 * @date:2014-5-6 上午11:21:34
	 * @version:v1.0
	 * @param folderId
	 * @param userName
	 * @param newOrders
	 * @return
	 */
	public boolean updateFilterOrders(int folderId,String userName,String newOrders); 

	/**
	 * @description:update default filters
	 * @date:2014-5-6 上午11:21:52
	 * @version:v1.0
	 * @param userName
	 * @param filters
	 * @return
	 */
	public boolean updateDefaultFilters(String userName,String filters); 

	/**
	 * @description:query all default filters
	 * @date:2014-5-6 上午11:25:51
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public List<String> queryDefaultFilters(String userName); 
 
	/**
	 * @description:add event
	 * @date:2014-5-6 上午11:27:22
	 * @version:v1.0
	 * @param eventName
	 * @return
	 */
	public boolean addEvent(String eventName);  

	/**
	 * @description:update event
	 * @date:2014-5-6 上午11:27:34
	 * @version:v1.0
	 * @param eventName
	 * @return
	 */
	public boolean updateEvent(String eventName); 

	/**
	 * @description:add event user
	 * @date:2014-5-6 上午11:27:45
	 * @version:v1.0
	 * @param userName
	 * @param eventId
	 * @return
	 */
	public boolean addEventUser(String userName,int eventId); 

	/**
	 * @description:remove event user
	 * @date:2014-5-6 上午11:27:56
	 * @version:v1.0
	 * @param userName
	 * @param eventId
	 * @return
	 */
	public boolean removeEventUser(String userName,int eventId); 

	/**
	 * @description:query if user is valid of event
	 * @date:2014-5-6 上午11:28:27
	 * @version:v1.0
	 * @param userName
	 * @param eventId
	 * @return
	 */
	public boolean isValidUser(String userName,int eventId); 

	/**
	 * @description:query template by template name
	 * @date:2014-5-6 上午11:30:47
	 * @version:v1.0
	 * @param templateName
	 * @return
	 */
	public Template queryTemplateByName(String templateName); 

	/**
	 * @description:query all scripts
	 * @date:2014-5-6 上午11:31:04
	 * @version:v1.0
	 * @return
	 */
	public List<Script> queryAllScripts(); 

	/**
	 * @description:add script
	 * @date:2014-5-6 上午11:31:13
	 * @version:v1.0
	 * @param script
	 * @return
	 */
	public UUID addScript(Script script); 

	/**
	 * @description:update script to database
	 * @date:2014-5-6 上午11:31:23
	 * @version:v1.0
	 * @param script
	 * @return
	 */
	public ErrorCode updateScript(Script script); 

	/**
	 * @description:query script by id
	 * @date:2014-5-6 上午11:31:35
	 * @version:v1.0
	 * @param scriptId
	 * @return
	 */
	public Script queryScript(UUID scriptId); 
	
	/**
	 * @description:query script not contain import info
	 * @date:2014-5-6 上午11:31:49
	 * @version:v1.0
	 * @param scriptId
	 * @return
	 */
	public Script queryScriptNoImport(UUID scriptId); 

	/**
	 * @description:remove script
	 * @date:2014-5-6 上午11:32:14
	 * @version:v1.0
	 * @param scriptId
	 * @return
	 */
	public ErrorCode removeScript(UUID scriptId); 

	/**
	 * @description:create script by user
	 * @date:2014-5-6 上午11:32:24
	 * @version:v1.0
	 * @param createUser
	 * @return
	 */
	public Script createScript(String createUser); 

	/**
	 * @description:query allow template scripts
	 * @date:2014-5-6 上午11:35:13
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public Script[] queryAllowedTemplateScripts(UUID templateId); 

	/**
	 * @description:query template scripts
	 * @date:2014-5-6 上午11:35:25
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public Script[] queryTemplateScripts(UUID templateId); 

	/**
	 * @description:query user default template
	 * @date:2014-5-6 上午11:35:38
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public String getUserDefaultTemplate(String userName); 

	/**
	 * @description:add or update user default template
	 * @date:2014-5-6 上午11:35:51
	 * @version:v1.0
	 * @param userName
	 * @param templateId
	 * @return
	 */
	public boolean addOrUpdateUserDefaultTemplate(String userName,String templateId); 

	/**
	 * @description:add user
	 * @date:2014-5-6 上午11:36:06
	 * @version:v1.0
	 * @param userInfo
	 * @return
	 */
	public boolean addUserInfo(UserInfo userInfo); 

	/**
	 * @description:update user
	 * @date:2014-5-6 上午11:36:14
	 * @version:v1.0
	 * @param userInfo
	 * @return
	 */
	public boolean updateUserInfo(UserInfo userInfo); 

	/**
	 * @description:query user by userid
	 * @date:2014-5-6 上午11:36:23
	 * @version:v1.0
	 * @param userId
	 * @return
	 */
	public UserInfo queryUserInfoById(int userId); 

	/**
	 * @description:query user by userMail
	 * @date:2014-5-6 上午11:36:43
	 * @version:v1.0
	 * @param userMail
	 * @return
	 */
	public UserInfo queryUserInfoByUserName(String userMail); 

	/**
	 * @description:remove user
	 * @date:2014-5-6 上午11:36:58
	 * @version:v1.0
	 * @param userInfo
	 * @return
	 */
	public boolean removeUserInfo(UserInfo userInfo); 

	/**
	 * @description:query if user is exist
	 * @date:2014-5-6 上午11:37:07
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public boolean isUserExisted(String userName); 
	

	/*******************************tag data start****************************************/
	/**
	 * @description:return all user tag datas
	 * @date:2014-5-6 上午11:42:20
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public Map<String,String> getUserClassifyDataMap(String userName); 
	
	/**
	 * @description:add tag
	 * @date:2014-5-6 上午11:43:07
	 * @version:v1.0
	 * @param userName
	 * @param tagName
	 * @param tagColor
	 * @return
	 */
	public int addTag(String userName, String tagName, String tagColor);
	
	/**
	 * @description:update tag
	 * @date:2014-5-6 上午11:43:15
	 * @version:v1.0
	 * @param tagId
	 * @param tagName
	 * @param tagColor
	 * @return
	 */
	public boolean updateTag(String tagId, String tagName, String tagColor);
	
	/**
	 * @description:delete tag
	 * @date:2014-5-6 上午11:43:25
	 * @version:v1.0
	 * @param tagId
	 * @return
	 */
	public boolean deleteTag(String tagId);
	
	/**
	 * @description:get all tags of user
	 * @date:2014-5-6 上午11:43:34
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public List<TagBean> getAllTag(String userName);
	
	/**
	 * @description:add datas to tag
	 * @date:2014-5-6 上午11:43:45
	 * @version:v1.0
	 * @param toTagId
	 * @param dataIds
	 * @return
	 */
	public boolean addTagData(String toTagId, String[] dataIds);
	
	/**
	 * @description:delete datas from tag
	 * @date:2014-5-6 上午11:43:57
	 * @version:v1.0
	 * @param tagId
	 * @param dataIds
	 * @return
	 */
	public boolean deleteTagData(String tagId, String[] dataIds);
	
	/**
	 * @description:get all datas of tag
	 * @date:2014-5-6 上午11:44:07
	 * @version:v1.0
	 * @param tagId
	 * @return
	 */
	public String[] getTagDataById(String tagId);
	
	/**
	 * @description:get all tags of data
	 * @date:2014-5-6 上午11:44:24
	 * @version:v1.0
	 * @param userName
	 * @param dataId
	 * @return
	 */
	public List<TagBean> getDataTags(String userName,String dataId);
	/*****************************tag data end**********************************************/
	
	/*****************************user start************************************************/
	/**
	 * @description:query all users by user array
	 * @date:2014-5-6 上午11:46:10
	 * @version:v1.0
	 * @param userArray
	 * @return
	 */
	public List<UserInfo> queryAllUserInfo(String[] userArray);
	
	/**
	 * @description:query all users by user array
	 * @date:2014-5-6 上午11:46:31
	 * @version:v1.0
	 * @param userArray
	 * @param isQuit:user is quit
	 * @return
	 */
	public List<UserInfo> queryAllUserInfo(String[] userArray, boolean isQuit);
	/*****************************user end**************************************************/
	
	
	
	/**
	 * @description:query database colname of field
	 * @date:2014-5-6 上午11:46:51
	 * @version:v1.0
	 * @param fieldId
	 * @param templateId
	 * @return
	 */
	public String getDbFieldName(UUID fieldId, UUID templateId);  
	
	/**
	 * @description:add template operate log
	 * @date:2014-5-6 上午11:47:15
	 * @version:v1.0
	 * @param templateOperateLog
	 * @return
	 */
	public boolean addTemplateOpreateLog(TemplateOperateLog templateOperateLog);
	
	
	
	/*****************************default values start******************************************/
	/**
	 * @description:set user template default values
	 * @date:2014-5-6 上午11:48:11
	 * @version:v1.0
	 * @param userName
	 * @param templateId
	 * @param defaultValueJson
	 * @return
	 */
	public boolean setDefaultValues(String userName, String templateId, String defaultValueJson);
	
	/**
	 * @description:get user template default values
	 * @date:2014-5-6 上午11:48:22
	 * @version:v1.0
	 * @param userName
	 * @param templateId
	 * @return
	 */
	public String getDefaultValues(String userName, String templateId);
	/*****************************default values end********************************************/
	
	/**
	 * @description:return all users has back rights
	 * @date:2014-5-6 上午11:48:58
	 * @version:v1.0
	 * @return
	 */
	public List<UserInfo> getBackRightUsers();  //查询所有后台权限人员
	
	/**
	 * @description:add back right of user
	 * @date:2014-5-6 上午11:49:14
	 * @version:v1.0
	 * @param userMail
	 * @return
	 */
	public boolean addBackRightUser(String userMail);  //添加后台权限人员 
	  
	/**
	 * @description:remove back right of user
	 * @date:2014-5-6 上午11:49:28
	 * @version:v1.0
	 * @param userMail
	 * @return
	 */
	public boolean delBackRightUser(String userMail);  //删除后台权限人员
	
	/**
	 * @description:get template operate right users
	 * @date:2014-5-6 上午11:49:41
	 * @version:v1.0
	 * @param templateId
	 * @return
	 */
	public List<UserInfo> getTemplateRightUser(String templateId);
	
	/**
	 * @description:remove user template operate right
	 * @date:2014-5-6 上午11:50:11
	 * @version:v1.0
	 * @param templateId
	 * @param userMail
	 * @return
	 */
	public boolean delUserTemplateRight(String templateId, String userMail);
	
	/**
	 * @description:add user template operate right
	 * @date:2014-5-6 上午11:50:27
	 * @version:v1.0
	 * @param templateId
	 * @param userMail
	 * @return
	 */
	public boolean addUserTemplateRight(String[] templateId, String userMail);
	
	/**
	 * @description:query all template rights of user
	 * @date:2014-5-6 上午11:51:02
	 * @version:v1.0
	 * @param userMail
	 * @return
	 */
	public Map<String, String> queryUserTemplateRights(String userMail);
	
	
	/**
	 * @description:set system setting(json)
	 * @date:2014-5-6 上午11:51:20
	 * @version:v1.0
	 * @param systemJson
	 * @return
	 */
	public boolean setSystemOption(String systemJson);
	
	/**
	 * @description:get system setting(json)
	 * @date:2014-5-6 上午11:51:35
	 * @version:v1.0
	 * @param userMail
	 * @return
	 */
	public String getSystemOption(String userMail);  //系统设置
	
	/**
	 * @description:update data log
	 * @date:2014-5-6 上午11:51:53
	 * @version:v1.0
	 * @param dataId
	 * @param logIndex
	 * @param logContent
	 * @return
	 */
	public boolean updateDataLog(UUID dataId, int logIndex, String logContent);
	
	/**
	 * @description:add field database colname to database
	 * @date:2014-5-6 上午11:52:32
	 * @version:v1.0
	 * @param templateId
	 * @param fieldColName
	 * @param fieldId
	 * @param fieldType
	 * @return
	 */
	public boolean addFieldColName(String templateId,String fieldColName,String fieldId,String fieldType);
	
	/**
	 * @description:query all statistics of user
	 * @date:2014-5-6 上午11:52:53
	 * @version:v1.0
	 * @param userName
	 * @return
	 */
	public TimerAction[] queryStatisticByUser(String userName);
	
	/**
	 * @description:query all users by user status
	 * @date:2014-5-6 上午11:53:14
	 * @version:v1.0
	 * @param userStat
	 * @param userName
	 * @return
	 */
	public List<UserInfo> queryAllUsersByStatAndName(String userStat,String userName);
	
	/**
	 * @description:update attachment
	 * @date:2014-5-6 上午11:53:34
	 * @version:v1.0
	 * @param attachment
	 * @return
	 */
	public boolean updateAttachment(Attachment attachment);
	
	/**
	 * @description:add template right user
	 * @date:2014-5-6 上午11:53:45
	 * @version:v1.0
	 * @param templateId
	 * @param userMails
	 * @return
	 */
	public boolean addtemplateUserRight(String templateId,String[] userMails);
	
	/**
	 * @description:remove template operate user
	 * @date:2014-5-6 上午11:53:59
	 * @version:v1.0
	 * @param templateId
	 * @param user
	 * @return
	 */
	public boolean delTemplateUserRight(String templateId,String user);
	
	/********************使用说明开始********************************************/
	/**
	 * @description:get all guide
	 * @date:2014-6-10 上午11:25:33
	 * @version:v1.0
	 * @return
	 */
	public List<GuideBean> queryAllGuide();
	
	/**
	 * @description：get guide by guideId
	 * @date:2014-6-10 上午11:25:55
	 * @version:v1.0
	 * @param guideId
	 * @return
	 */
	public String queryGuideHtmlByGuideId( String guideId);
	
	/**
	 * @description:save guide by guideid
	 * @date:2014-6-10 上午11:26:31
	 * @version:v1.0
	 * @param guideId
	 * @param guideHtml
	 * @return
	 */
	public boolean saveGuideHtml(String guideId , String guideHtml);
	/********************使用说明结束********************************************/
	
	public enum ErrorCode
	{
		success, privilegeFail, dbFail, scriptBeforeFail, scriptAfterFail, nullClientFail, unknownFail, noSuchTemplateFail, noSuchTemplateTypeFail, alreadyDeleted, alreadyUpdate, autoCommitted;
	}

	
}