/src/com/sogou/qadev/service/cynthia/service/DataAccessSession.java
Java | 1759 lines | 215 code | 191 blank | 1353 comment | 0 complexity | 07fc832d928ffd6a51d6a42f9fc56309 MD5 | raw file
Possible License(s): GPL-2.0
- 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;
- }
-
- }