PageRenderTime 59ms CodeModel.GetById 24ms RepoModel.GetById 1ms app.codeStats 0ms

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

https://github.com/desktopqa/Cynthia
Java | 1793 lines | 219 code | 193 blank | 1381 comment | 0 complexity | de465793957ffb828a57a109ea7dc536 MD5 | raw file
Possible License(s): GPL-2.0
  1. package com.sogou.qadev.service.cynthia.service;
  2. import java.sql.Timestamp;
  3. import java.util.List;
  4. import java.util.Map;
  5. import com.sogou.qadev.service.cynthia.bean.Action;
  6. import com.sogou.qadev.service.cynthia.bean.Attachment;
  7. import com.sogou.qadev.service.cynthia.bean.Data;
  8. import com.sogou.qadev.service.cynthia.bean.DataAccessAction;
  9. import com.sogou.qadev.service.cynthia.bean.Field;
  10. import com.sogou.qadev.service.cynthia.bean.Filter;
  11. import com.sogou.qadev.service.cynthia.bean.Flow;
  12. import com.sogou.qadev.service.cynthia.bean.GuideBean;
  13. import com.sogou.qadev.service.cynthia.bean.JSTree;
  14. import com.sogou.qadev.service.cynthia.bean.Option;
  15. import com.sogou.qadev.service.cynthia.bean.Pair;
  16. import com.sogou.qadev.service.cynthia.bean.QueryCondition;
  17. import com.sogou.qadev.service.cynthia.bean.Role;
  18. import com.sogou.qadev.service.cynthia.bean.Script;
  19. import com.sogou.qadev.service.cynthia.bean.Stat;
  20. import com.sogou.qadev.service.cynthia.bean.TagBean;
  21. import com.sogou.qadev.service.cynthia.bean.Template;
  22. import com.sogou.qadev.service.cynthia.bean.TemplateOperateLog;
  23. import com.sogou.qadev.service.cynthia.bean.TemplateType;
  24. import com.sogou.qadev.service.cynthia.bean.Timer;
  25. import com.sogou.qadev.service.cynthia.bean.TimerAction;
  26. import com.sogou.qadev.service.cynthia.bean.UUID;
  27. import com.sogou.qadev.service.cynthia.bean.UserInfo;
  28. /**
  29. * @description:data process interface
  30. * @author:liming
  31. * @mail:liming@sogou-inc.com
  32. * @date:2014-5-6 上午10:13:32
  33. * @version:v1.0
  34. */
  35. public interface DataAccessSession
  36. {
  37. /**
  38. * @description:update cache
  39. * @date:2014-5-6 上午10:12:00
  40. * @version:v1.0
  41. * @param daa: delete update
  42. * @param key:cache data key
  43. * @param object:cache data
  44. */
  45. public void updateCache(DataAccessAction daa, String key ,Object object);
  46. /**
  47. * @description:return data filter interface
  48. * @date:2014-5-6 上午10:13:26
  49. * @version:v1.0
  50. * @return
  51. */
  52. public DataFilter getDataFilter();
  53. /**
  54. * @description:return current user
  55. * @date:2014-5-6 上午10:14:11
  56. * @version:v1.0
  57. * @return
  58. */
  59. public String getUsername();
  60. /**
  61. * @description:TODO
  62. * @date:2014-5-6 上午10:14:29
  63. * @version:v1.0
  64. * @return
  65. */
  66. public long getKeyId();
  67. /**
  68. * @description:TODO
  69. * @date:2014-5-6 上午10:14:35
  70. * @version:v1.0
  71. * @return
  72. */
  73. public String getAgent();
  74. /**
  75. * @description:remove flow from database
  76. * @date:2014-5-6 上午10:14:40
  77. * @version:v1.0
  78. * @param flowId
  79. * @return
  80. */
  81. public ErrorCode removeFlow(UUID flowId);
  82. /**
  83. * @description:begin transcation
  84. * @date:2014-5-6 上午10:15:29
  85. * @version:v1.0
  86. * @return
  87. */
  88. public ErrorCode beginTranscation();
  89. /**
  90. * @description:transcation rollback
  91. * @date:2014-5-6 上午10:15:48
  92. * @version:v1.0
  93. * @return
  94. */
  95. public ErrorCode rollbackTranscation();
  96. /**
  97. * @description:commit transcation
  98. * @date:2014-5-6 上午10:16:01
  99. * @version:v1.0
  100. * @return
  101. */
  102. public ErrorCode commitTranscation();
  103. /**
  104. * @description:query data by data id
  105. * @date:2014-5-6 上午10:16:11
  106. * @version:v1.0
  107. * @param id:data id
  108. * @return
  109. */
  110. public Data queryData(UUID id);
  111. /**
  112. * @description:query data from data id and template id
  113. * @date:2014-5-6 上午10:16:24
  114. * @version:v1.0
  115. * @param id
  116. * @param templateId
  117. * @return
  118. */
  119. public Data queryData(UUID id , UUID templateId);
  120. /**
  121. * @description:query data from sql
  122. * @date:2014-5-6 上午10:16:47
  123. * @version:v1.0
  124. * @param sql
  125. * @param needLog:need data log
  126. * @param templateId
  127. * @return
  128. */
  129. public List<Data> queryDataBySql(String sql , boolean needLog, UUID templateId);
  130. /**
  131. * @description:add data, get data uuid
  132. * @date:2014-5-6 上午10:17:13
  133. * @version:v1.0
  134. * @param templateId
  135. * @return
  136. */
  137. public Data addData(UUID templateId);
  138. /**
  139. * @description:copy data
  140. * @date:2014-5-6 上午10:18:00
  141. * @version:v1.0
  142. * @param dataId
  143. * @param templateId
  144. * @param actionId
  145. * @param actionUser
  146. * @param actionComment
  147. * @param baseValueMap
  148. * @param extValueMap
  149. * @return
  150. */
  151. public Data copyData(UUID dataId, UUID templateId, UUID actionId, String actionUser, String actionComment,
  152. Map<String, Pair<Object, Object>> baseValueMap, Map<UUID, Pair<Object, Object>> extValueMap);
  153. /**
  154. * @description:remove template from database
  155. * @date:2014-5-6 上午10:18:23
  156. * @version:v1.0
  157. * @param templateId
  158. * @return
  159. */
  160. public ErrorCode removeTemplate(Template templateId);
  161. /**
  162. * @description:query template from cache or database
  163. * @date:2014-5-6 上午10:18:35
  164. * @version:v1.0
  165. * @param templateId
  166. * @return
  167. */
  168. public Template queryTemplate(UUID templateId);
  169. /**
  170. * @description:query all templates by templatetype
  171. * @date:2014-5-6 上午10:19:15
  172. * @version:v1.0
  173. * @param templateTypeId
  174. * @return
  175. */
  176. public List<Template> queryTemplates(UUID templateTypeId);
  177. /**
  178. * @description:query field from templates by fieldId
  179. * @date:2014-5-6 上午10:19:34
  180. * @version:v1.0
  181. * @param fieldId
  182. * @return
  183. */
  184. public Field queryField(UUID fieldId);
  185. /**
  186. * @description:query field from template
  187. * @date:2014-5-6 上午10:20:02
  188. * @version:v1.0
  189. * @param fieldId
  190. * @param templateId
  191. * @return
  192. */
  193. public Field queryField(UUID fieldId , UUID templateId);
  194. /**
  195. * @description:query option from template by template id
  196. * @date:2014-5-6 上午10:20:25
  197. * @version:v1.0
  198. * @param optionId
  199. * @param templateId
  200. * @return
  201. */
  202. public Option queryOption(UUID optionId ,UUID templateId);
  203. /**
  204. * @description:query option from template
  205. * @date:2014-5-6 上午10:21:04
  206. * @version:v1.0
  207. * @param optionId
  208. * @param template
  209. * @return
  210. */
  211. public Option queryOption(UUID optionId, Template template);
  212. /**
  213. * @description:query datas by template id and other query conditions
  214. * @date:2014-5-6 上午10:21:18
  215. * @version:v1.0
  216. * @param templateId
  217. * @param queryConditions
  218. * @param needLog
  219. * @return
  220. */
  221. public Data[] queryDatas(UUID templateId, List<QueryCondition> queryConditions,boolean needLog);
  222. /**
  223. * @description:query template type by templatetype id
  224. * @date:2014-5-6 上午10:22:05
  225. * @version:v1.0
  226. * @param templateTypeId
  227. * @return
  228. */
  229. public TemplateType queryTemplateType(UUID templateTypeId);
  230. /**
  231. * @description:create attachment from name and atta data
  232. * @date:2014-5-6 上午10:22:20
  233. * @version:v1.0
  234. * @param name
  235. * @param data
  236. * @return
  237. */
  238. public Attachment createAttachment(String name, byte[] data);
  239. /**
  240. * @description:query attachement by id
  241. * @date:2014-5-6 上午10:22:46
  242. * @version:v1.0
  243. * @param id
  244. * @param needData:if attachment data need
  245. * @return
  246. */
  247. public Attachment queryAttachment(UUID id, boolean needData);
  248. /**
  249. * @description: query attachments by ids
  250. * @date:2014-5-6 上午10:23:24
  251. * @version:v1.0
  252. * @param ids
  253. * @param needData:if attachment data need
  254. * @return
  255. */
  256. public Attachment[] queryAttachments(UUID[] ids, boolean needData);
  257. /**
  258. * @description:modify data
  259. * @date:2014-5-6 上午10:24:11
  260. * @version:v1.0
  261. * @param data
  262. * @return
  263. */
  264. public Pair<ErrorCode, String> modifyData(Data data);
  265. /**
  266. * @description:remove data
  267. * @date:2014-5-6 上午10:24:22
  268. * @version:v1.0
  269. * @param data
  270. * @return
  271. */
  272. public ErrorCode removeData(Data data);
  273. /**
  274. * @description:set all Template Data valid true or false
  275. * @date:2014-8-7 下午5:04:27
  276. * @version:v1.0
  277. * @param templateId
  278. * @param isValid
  279. */
  280. public boolean setValidDataOfTemplate(UUID templateId , boolean isValid);
  281. /**
  282. * @description:remove data from cache
  283. * @date:2014-5-6 上午10:24:31
  284. * @version:v1.0
  285. * @param data
  286. * @return
  287. */
  288. public ErrorCode removeDataFromCache(Data data);
  289. /**
  290. * @description:close and commit transcation
  291. * @date:2014-5-6 上午10:25:20
  292. * @version:v1.0
  293. */
  294. public void close();
  295. /**
  296. * @description:return is transcation is commit automatic
  297. * @date:2014-5-6 上午10:25:40
  298. * @version:v1.0
  299. * @return
  300. */
  301. public boolean isAutoCommit();
  302. /**
  303. * @description:set transcation if commit automatic
  304. * @date:2014-5-6 上午10:26:40
  305. * @version:v1.0
  306. * @param b:true auto , false not
  307. */
  308. public void setAutoCommit(boolean b);
  309. /**
  310. * @description:return script process interface
  311. * @date:2014-5-6 上午10:27:26
  312. * @version:v1.0
  313. * @return
  314. */
  315. public ScriptAccessSession createScriptAccessSession();
  316. /**
  317. * @description:create flow
  318. * @date:2014-5-6 上午10:28:37
  319. * @version:v1.0
  320. * @param userName:create user name
  321. * @return
  322. */
  323. public Flow createFlow(String userName);
  324. /**
  325. * @description:create template
  326. * @date:2014-5-6 上午10:29:37
  327. * @version:v1.0
  328. * @param templateTypeId:template type
  329. * @return
  330. */
  331. public Template createTemplate(UUID templateTypeId);
  332. /**
  333. * @description:update template
  334. * @date:2014-5-6 上午10:31:08
  335. * @version:v1.0
  336. * @param template
  337. * @return
  338. */
  339. public ErrorCode updateTemplate(Template template);
  340. /**
  341. * @description:query flow by flow id
  342. * @date:2014-5-6 上午10:31:49
  343. * @version:v1.0
  344. * @param flowId
  345. * @return
  346. */
  347. public Flow queryFlow(UUID flowId);
  348. /**
  349. * @description:update flow svgcode
  350. * @date:2014-5-6 上午10:32:01
  351. * @version:v1.0
  352. * @param flowId
  353. * @param svgCode
  354. * @return
  355. */
  356. public boolean updateSvg(UUID flowId,String svgCode);
  357. /**
  358. * @description:query flow svgcode
  359. * @date:2014-5-6 上午10:32:16
  360. * @version:v1.0
  361. * @param flowId
  362. * @return
  363. */
  364. public String queryFlowSvg(UUID flowId);
  365. /**
  366. * @description:query stat from flow
  367. * @date:2014-5-6 上午10:32:26
  368. * @version:v1.0
  369. * @param statId
  370. * @param flowId
  371. * @return
  372. */
  373. public Stat queryStat(UUID statId , UUID flowId);
  374. /**
  375. * @description:query action from flow
  376. * @date:2014-5-6 上午10:32:36
  377. * @version:v1.0
  378. * @param actionId
  379. * @param flowId
  380. * @return
  381. */
  382. public Action queryAction(UUID actionId , UUID flowId);
  383. /**
  384. * @description:query role from flow
  385. * @date:2014-5-6 上午10:32:45
  386. * @version:v1.0
  387. * @param roleId
  388. * @param flowId
  389. * @return
  390. */
  391. public Role queryRole(UUID roleId , UUID flowId);
  392. /**
  393. * @description:query flows by from ids
  394. * @date:2014-5-6 上午10:32:56
  395. * @version:v1.0
  396. * @param flowIdArray
  397. * @return
  398. */
  399. public Flow[] queryFlows(UUID[] flowIdArray);
  400. /**
  401. * @description:query templates by template ids
  402. * @date:2014-5-6 上午10:33:09
  403. * @version:v1.0
  404. * @param templateIdArray
  405. * @return
  406. */
  407. public Template[] queryTemplates(UUID[] templateIdArray);
  408. /**
  409. * @description:query templatetypes by templatetype ids
  410. * @date:2014-5-6 上午10:33:23
  411. * @version:v1.0
  412. * @param templateTypeIdArray
  413. * @return
  414. */
  415. public TemplateType[] queryTemplateTypes(UUID[] templateTypeIdArray);
  416. /**
  417. * @description:update flow
  418. * @date:2014-5-6 上午10:33:37
  419. * @version:v1.0
  420. * @param flow
  421. * @return
  422. */
  423. public ErrorCode updateFlow(Flow flow);
  424. /**
  425. * @description:query all flows
  426. * @date:2014-5-6 上午10:33:54
  427. * @version:v1.0
  428. * @return
  429. */
  430. public Flow[] queryAllFlows();
  431. /**
  432. * @Title: queryAllFlows
  433. * @Description: query user all flows
  434. * @param userMail
  435. * @return
  436. * @return: Flow[]
  437. */
  438. public Flow[] queryAllFlows(String userMail);
  439. /**
  440. * @description:query all templates
  441. * @date:2014-5-6 上午10:34:27
  442. * @version:v1.0
  443. * @return
  444. */
  445. public Template[] queryAllTemplates();
  446. /**
  447. * @description:query all templatetypes
  448. * @date:2014-5-6 上午10:34:47
  449. * @version:v1.0
  450. * @return
  451. */
  452. public TemplateType[] queryAllTemplateTypes();
  453. /**
  454. * @description:add filter to database
  455. * @date:2014-5-6 上午10:35:05
  456. * @version:v1.0
  457. * @param filter
  458. * @return
  459. */
  460. public Filter addFilter(Filter filter);
  461. /**
  462. * @description:query filter by filter id
  463. * @date:2014-5-6 上午10:35:18
  464. * @version:v1.0
  465. * @param filterId
  466. * @return
  467. */
  468. public Filter queryFilter(UUID filterId);
  469. /**
  470. * @description:query all filters of user
  471. * @date:2014-5-6 上午10:37:27
  472. * @version:v1.0
  473. * @param username
  474. * @return
  475. */
  476. public Filter[] queryFilters(String username);
  477. /**
  478. * @description:query filter id and name of user
  479. * @date:2014-5-6 上午10:37:53
  480. * @version:v1.0
  481. * @param userName
  482. * @return
  483. */
  484. public Map<String,String> queryFilterIdNameMap(String userName);
  485. /**
  486. * @description:query system filters
  487. * @date:2014-5-6 上午10:38:15
  488. * @version:v1.0
  489. * @param username
  490. * @return
  491. */
  492. public Filter[] querySysFilters(String username);
  493. /**
  494. * @description:query all focus filter of user
  495. * @date:2014-5-6 上午10:39:04
  496. * @version:v1.0
  497. * @param username
  498. * @return
  499. */
  500. public Filter[] queryFocusFilters(String username);
  501. /**
  502. * @description:query all filters
  503. * @date:2014-5-6 上午10:39:33
  504. * @version:v1.0
  505. * @return
  506. */
  507. public List<Filter> queryAllFilters();
  508. /**
  509. * @description:remove filter by filter id
  510. * @date:2014-5-6 上午10:39:42
  511. * @version:v1.0
  512. * @param filterId
  513. * @return
  514. */
  515. public ErrorCode removeFilter(UUID filterId);
  516. /**
  517. * @description:update filter
  518. * @date:2014-5-6 上午10:39:56
  519. * @version:v1.0
  520. * @param filter
  521. * @return
  522. */
  523. public ErrorCode updateFilter(Filter filter);
  524. /**
  525. * @description:create filter
  526. * @date:2014-5-6 上午10:40:11
  527. * @version:v1.0
  528. * @param createUser
  529. * @param createTime
  530. * @param fatherId:father folder id
  531. * @return
  532. */
  533. public Filter createFilter(String createUser, Timestamp createTime, UUID fatherId);
  534. /**
  535. * @description:create tmp filter
  536. * @date:2014-5-6 上午10:40:59
  537. * @version:v1.0
  538. * @param createUser
  539. * @param createTime
  540. * @param fatherId
  541. * @return
  542. */
  543. public Filter createTempFilter(String createUser, Timestamp createTime, UUID fatherId);
  544. /**
  545. * @description:get filters new and old datas
  546. * @date:2014-5-6 上午10:42:15
  547. * @version:v1.0
  548. * @param filterIdArray
  549. * @param username
  550. * @return:xml
  551. */
  552. public String getNewTaskIdsByFilterAndUser(UUID[] filterIdArray, String username);
  553. /**
  554. * @description:set data old of filter
  555. * @date:2014-5-6 上午10:43:12
  556. * @version:v1.0
  557. * @param filterId
  558. * @param taskIdArray
  559. * @param username
  560. * @return
  561. */
  562. public String cleanNewTagByTaskIds(UUID filterId, UUID[] taskIdArray, String username);
  563. /**
  564. * @description:remove old data
  565. * @date:2014-5-6 上午10:45:38
  566. * @version:v1.0
  567. * @param dataId
  568. */
  569. public void deleteFilterUserTasks(UUID dataId);
  570. /**
  571. * @description:query filters focused by user
  572. * @date:2014-5-6 上午10:45:58
  573. * @version:v1.0
  574. * @param username
  575. * @return
  576. */
  577. public UUID[] queryUserFocusFilters(String username);
  578. /**
  579. * @description:remove user focus filter
  580. * @date:2014-5-6 上午10:46:15
  581. * @version:v1.0
  582. * @param username
  583. * @param filterId
  584. * @return
  585. */
  586. public ErrorCode removeUserFocusFilter(String username, UUID filterId);
  587. /**
  588. * @description:remove all focus filter
  589. * @date:2014-8-5 下午8:01:47
  590. * @version:v1.0
  591. * @param filterId
  592. * @return
  593. */
  594. public ErrorCode removeUserFocusFilter(UUID filterId);
  595. /**
  596. * @description:add user focus filter
  597. * @date:2014-5-6 上午10:46:29
  598. * @version:v1.0
  599. * @param username
  600. * @param filterId
  601. * @return
  602. */
  603. public ErrorCode addUserFocusFilter(String username, UUID filterId);
  604. /**
  605. * @description:remove user by username
  606. * @date:2014-5-6 上午10:46:43
  607. * @version:v1.0
  608. * @param username
  609. * @return
  610. */
  611. public ErrorCode removeRelatedUser(String username);
  612. /**
  613. * @description:create timer return uuid
  614. * @date:2014-5-6 上午10:48:01
  615. * @version:v1.0
  616. * @param createUser
  617. * @return
  618. */
  619. public Timer createTimer(String createUser);
  620. /**
  621. * @description:add timer to database
  622. * @date:2014-5-6 上午10:48:13
  623. * @version:v1.0
  624. * @param timer
  625. * @return
  626. */
  627. public ErrorCode addTimer(Timer timer);
  628. /**
  629. * @description:remove timer from database
  630. * @date:2014-5-6 上午10:49:06
  631. * @version:v1.0
  632. * @param timerId
  633. * @return
  634. */
  635. public ErrorCode removeTimer(UUID timerId);
  636. /**
  637. * @description:modify timer
  638. * @date:2014-5-6 上午10:49:17
  639. * @version:v1.0
  640. * @param timer
  641. * @return
  642. */
  643. public ErrorCode modifyTimer(Timer timer);
  644. /**
  645. * @description:query timer from timer id
  646. * @date:2014-5-6 上午10:49:32
  647. * @version:v1.0
  648. * @param timerId
  649. * @return
  650. */
  651. public Timer queryTimer(UUID timerId);
  652. /**
  653. * @description:query timers by user
  654. * @date:2014-5-6 上午10:49:46
  655. * @version:v1.0
  656. * @param username
  657. * @return
  658. */
  659. public Timer[] queryTimers(String username);
  660. /**
  661. * @description:query all timers
  662. * @date:2014-5-6 上午10:49:57
  663. * @version:v1.0
  664. * @return
  665. */
  666. public Timer[] queryTimers();
  667. /**
  668. * @description:query timer by timer action id
  669. * @date:2014-5-6 上午10:50:08
  670. * @version:v1.0
  671. * @param timerActionId
  672. * @return
  673. */
  674. public Timer[] queryTimersByActionId(UUID timerActionId);
  675. /**
  676. * @description:create timer action
  677. * @date:2014-5-6 上午10:50:22
  678. * @version:v1.0
  679. * @return
  680. */
  681. public TimerAction createTimerAction();
  682. /**
  683. * @description:add timer action to database
  684. * @date:2014-5-6 上午10:50:33
  685. * @version:v1.0
  686. * @param timerAction
  687. * @return
  688. */
  689. public ErrorCode addTimerAction(TimerAction timerAction);
  690. /**
  691. * @description:remove timer action from database
  692. * @date:2014-5-6 上午10:50:46
  693. * @version:v1.0
  694. * @param timerActionId
  695. * @return
  696. */
  697. public ErrorCode removeTimerAction(UUID timerActionId);
  698. /**
  699. * @description:modify timer action from database
  700. * @date:2014-5-6 上午10:51:01
  701. * @version:v1.0
  702. * @param timerAction
  703. * @return
  704. */
  705. public ErrorCode modifyTimerAction(TimerAction timerAction);
  706. /**
  707. * @description:query timer action from timer action id
  708. * @date:2014-5-6 上午10:51:16
  709. * @version:v1.0
  710. * @param timerActionId
  711. * @return
  712. */
  713. public TimerAction queryTimerAction(UUID timerActionId);
  714. /**
  715. * @description:query all timer actions
  716. * @date:2014-5-6 上午10:51:30
  717. * @version:v1.0
  718. * @return
  719. */
  720. public TimerAction[] queryTimerActions();
  721. /**
  722. * @description:query data create users by templatetype id
  723. * @date:2014-5-6 上午10:52:36
  724. * @version:v1.0
  725. * @param templateTypeId
  726. * @return
  727. */
  728. public String[] queryTemplateTypeCreateUsers(UUID templateTypeId);
  729. /**
  730. * @description:query all assign users by templatetype id
  731. * @date:2014-5-6 上午10:52:54
  732. * @version:v1.0
  733. * @param templateTypeId
  734. * @return
  735. */
  736. public String[] queryTemplateTypeAssignUsers(UUID templateTypeId);
  737. /**
  738. * @description:query all statu names by template type id
  739. * @date:2014-5-6 上午10:53:12
  740. * @version:v1.0
  741. * @param templateTypeId
  742. * @return
  743. */
  744. public String[] queryTemplateTypeStats(UUID templateTypeId);
  745. /**
  746. * @description:query all datas by template id(need datalog)
  747. * @date:2014-5-6 上午10:54:08
  748. * @version:v1.0
  749. * @param templateId
  750. * @return
  751. */
  752. public Data[] queryTemplateDatas(UUID templateId);
  753. /**
  754. * @description:query all datas by template id
  755. * @date:2014-5-6 上午10:54:22
  756. * @version:v1.0
  757. * @param templateId
  758. * @param needLog:if need data log
  759. * @return
  760. */
  761. public Data[] queryTemplateDatas(UUID templateId , boolean needLog);
  762. /**
  763. * @description:query datas by template id and create time
  764. * @date:2014-5-6 上午10:55:16
  765. * @version:v1.0
  766. * @param templateId
  767. * @param needLog
  768. * @param startTime:createTime start
  769. * @param endTime:createTime end
  770. * @return
  771. */
  772. public Data[] queryTemplateDatas(UUID templateId , boolean needLog , Timestamp startTime , Timestamp endTime);
  773. /**
  774. * @description:query datas by template id
  775. * @date:2014-5-6 上午10:56:07
  776. * @version:v1.0
  777. * @param templateId
  778. * @param needLog
  779. * @param startTime
  780. * @param endTime
  781. * @param allQueryList:other query conditions
  782. * @return
  783. */
  784. public Data[] queryTemplateDatas(UUID templateId , boolean needLog , Timestamp startTime, Timestamp endTime , List<QueryCondition> allQueryList);
  785. /**
  786. * @description:query datas of template by lastmodifytime
  787. * @date:2014-5-6 上午10:56:35
  788. * @version:v1.0
  789. * @param templateId
  790. * @param needLog
  791. * @param startTime:last modify time start
  792. * @param endTime:last modify time end
  793. * @return
  794. */
  795. public Data[] queryTemplateDatasByLastModifyTime(UUID templateId , boolean needLog , Timestamp startTime , Timestamp endTime);
  796. /**
  797. * @description:query all createusers by template id
  798. * @date:2014-5-6 上午10:57:08
  799. * @version:v1.0
  800. * @param templateId
  801. * @return
  802. */
  803. public String[] queryTemplateCreateUsers(UUID templateId);
  804. /**
  805. * @description:query all assign users by template id
  806. * @date:2014-5-6 上午10:57:32
  807. * @version:v1.0
  808. * @param templateId
  809. * @return
  810. */
  811. public String[] queryTemplateAssignUsers(UUID templateId);
  812. /**
  813. * @description:query all stats by template id
  814. * @date:2014-5-6 上午10:57:44
  815. * @version:v1.0
  816. * @param templateId
  817. * @return
  818. */
  819. public Stat[] queryTemplateStats(UUID templateId);
  820. /**
  821. * @description:query all reference datas by template id and reference field id
  822. * @date:2014-5-6 上午11:00:38
  823. * @version:v1.0
  824. * @param templateId
  825. * @param fieldId
  826. * @return
  827. */
  828. public Data[] queryTemplateFieldReferences(UUID templateId, UUID fieldId);
  829. /**
  830. * @description:query all attachments by template and field id
  831. * @date:2014-5-6 上午11:01:13
  832. * @version:v1.0
  833. * @param templateId
  834. * @param fieldId
  835. * @return
  836. */
  837. public Attachment[] queryTemplateFieldAttachments(UUID templateId, UUID fieldId);
  838. /**
  839. * @description:check user privilege of data
  840. * @date:2014-5-6 上午11:02:23
  841. * @version:v1.0
  842. * @param data
  843. * @param action
  844. * @return
  845. */
  846. public boolean checkUserPrivilege(Data data, DataAccessAction action);
  847. /**
  848. * @description:check user privilege
  849. * @date:2014-5-6 上午11:02:48
  850. * @version:v1.0
  851. * @param data
  852. * @param action
  853. * @param template
  854. * @param flow
  855. * @return
  856. */
  857. public boolean checkUserPrivilege(Data data, DataAccessAction action ,Template template , Flow flow);
  858. /**
  859. * @description:check if data exist
  860. * @date:2014-5-6 上午11:03:20
  861. * @version:v1.0
  862. * @param dataId
  863. * @return
  864. */
  865. public boolean isDataExist(UUID dataId);
  866. /**
  867. * @description:query all focus user of filter
  868. * @date:2014-5-6 上午11:04:21
  869. * @version:v1.0
  870. * @param filterId
  871. * @return
  872. */
  873. public List<String> queryFocusUsersByFilter(UUID filterId);
  874. /**
  875. * @description:query all children nodes by node id and user
  876. * @date:2014-5-6 上午11:04:39
  877. * @version:v1.0
  878. * @param id
  879. * @param userName
  880. * @return
  881. */
  882. public List<JSTree> queryChilderNodes(int nodeId ,String userName);
  883. /**
  884. * @description:query JStree node by nodeId
  885. * @date:2014-5-6 上午11:05:45
  886. * @version:v1.0
  887. * @param nodeId
  888. * @return
  889. */
  890. public JSTree queryJSTreeNodeById(int nodeId);
  891. /**
  892. * @description:add jstree node
  893. * @date:2014-5-6 上午11:06:00
  894. * @version:v1.0
  895. * @param parentId
  896. * @param position
  897. * @param title
  898. * @param userName
  899. * @return
  900. */
  901. public int addJSTreeNode(int parentId,int position,String title,String userName);
  902. /**
  903. * @description:remove jstree node
  904. * @date:2014-5-6 上午11:06:12
  905. * @version:v1.0
  906. * @param id
  907. * @param userName
  908. * @return
  909. */
  910. public boolean removJSTreeNode(int id,String userName);
  911. /**
  912. * @description:update jstree node title
  913. * @date:2014-5-6 上午11:06:24
  914. * @version:v1.0
  915. * @param id
  916. * @param title
  917. * @return
  918. */
  919. public boolean updateJSTreeNode(int id,String title);
  920. /**
  921. * @description:move jstree node
  922. * @date:2014-5-6 上午11:06:37
  923. * @version:v1.0
  924. * @param id
  925. * @param refId
  926. * @param position
  927. * @param title
  928. * @param copy
  929. * @param userName
  930. * @return
  931. */
  932. public boolean moveJSTreeNode(int id,int refId,int position,String title, boolean copy,String userName);
  933. /**
  934. * @description:move filter position in jstree
  935. * @date:2014-5-6 上午11:06:58
  936. * @version:v1.0
  937. * @param filterId
  938. * @param refId
  939. * @param parentId
  940. * @return
  941. */
  942. public boolean moveFilterNode(int filterId,int refId,int parentId);
  943. /**
  944. * @description:query all filters from jstree
  945. * @date:2014-5-6 上午11:07:22
  946. * @version:v1.0
  947. * @param userName
  948. * @return
  949. */
  950. public List<String> queryAllFolderFilters(String userName);
  951. /**
  952. * @description:query timers by filter id
  953. * @date:2014-5-6 上午11:08:07
  954. * @version:v1.0
  955. * @param filterId
  956. * @return
  957. */
  958. public Timer[] queryTimerByFilterId(UUID filterId);
  959. /**
  960. * @description:query filters by folder node if
  961. * @date:2014-5-6 上午11:08:42
  962. * @version:v1.0
  963. * @param nodeId
  964. * @return
  965. */
  966. public List<String> queryFolderFilters(int nodeId);
  967. /**
  968. * @description:query all root node of jstree
  969. * @date:2014-5-6 上午11:09:03
  970. * @version:v1.0
  971. * @param id
  972. * @return
  973. */
  974. public List<JSTree> queryRootNode(int id);
  975. /**
  976. * @description:remove filter from jstree
  977. * @date:2014-5-6 上午11:09:22
  978. * @version:v1.0
  979. * @param filterId
  980. * @param parentId
  981. * @return
  982. */
  983. public boolean removeFilterId(int filterId,int parentId);
  984. /**
  985. * @description:query all favorite filters by user
  986. * @date:2014-5-6 上午11:10:15
  987. * @version:v1.0
  988. * @param userName
  989. * @return
  990. */
  991. public String[] queryFavoriteFilters(String userName);
  992. /**
  993. * @description:add favorite filter of user
  994. * @date:2014-5-6 上午11:10:40
  995. * @version:v1.0
  996. * @param userName
  997. * @param filterId
  998. * @return
  999. */
  1000. public boolean addFavoriteFilter(String userName,String filterId);
  1001. /**
  1002. * @description:remove favorite filter of user
  1003. * @date:2014-5-6 上午11:11:02
  1004. * @version:v1.0
  1005. * @param userName
  1006. * @param filterId
  1007. * @return
  1008. */
  1009. public boolean removeFavoriteFilter(String userName,String filterId);
  1010. /**
  1011. * @description:update all favorite filters of user
  1012. * @date:2014-5-6 上午11:12:52
  1013. * @version:v1.0
  1014. * @param filterarrays
  1015. * @param userName
  1016. * @return
  1017. */
  1018. public boolean updataFavoriteFilters(String filterarrays,String userName);
  1019. /**
  1020. * @description:query user home filter
  1021. * @date:2014-5-6 上午11:13:11
  1022. * @version:v1.0
  1023. * @param userName
  1024. * @return
  1025. */
  1026. public String queryHomeFilter(String userName);
  1027. /**
  1028. * @description:add home filter
  1029. * @date:2014-5-6 上午11:13:21
  1030. * @version:v1.0
  1031. * @param userName
  1032. * @param filterId
  1033. * @return
  1034. */
  1035. public boolean addHomeFilter(String userName,String filterId);
  1036. /**
  1037. * @description:update home filter
  1038. * @date:2014-5-6 上午11:13:32
  1039. * @version:v1.0
  1040. * @param userName
  1041. * @param filterId
  1042. * @return
  1043. */
  1044. public boolean updateHomeFilter(String userName,String filterId);
  1045. /**
  1046. * @description:update favoriter filter position
  1047. * @date:2014-5-6 上午11:13:47
  1048. * @version:v1.0
  1049. * @param filterId
  1050. * @param position
  1051. * @param userName
  1052. * @return
  1053. */
  1054. public boolean updateFavoritesFilters(String filterId,int position,String userName);
  1055. /**
  1056. * @description:add filter to jstree node
  1057. * @date:2014-5-6 上午11:15:16
  1058. * @version:v1.0
  1059. * @param fitlerId
  1060. * @param nodeId
  1061. * @return
  1062. */
  1063. public boolean addFilterToFolder(String fitlerId,int nodeId);
  1064. /**
  1065. * @description:query all scripts of user
  1066. * @date:2014-5-6 上午11:21:03
  1067. * @version:v1.0
  1068. * @param userName
  1069. * @param keyId
  1070. * @return
  1071. */
  1072. public List<Script> queryAllScripts(String userName,long keyId);
  1073. /**
  1074. * @description:update filter orders of node
  1075. * @date:2014-5-6 上午11:21:34
  1076. * @version:v1.0
  1077. * @param folderId
  1078. * @param userName
  1079. * @param newOrders
  1080. * @return
  1081. */
  1082. public boolean updateFilterOrders(int folderId,String userName,String newOrders);
  1083. /**
  1084. * @description:update default filters
  1085. * @date:2014-5-6 上午11:21:52
  1086. * @version:v1.0
  1087. * @param userName
  1088. * @param filters
  1089. * @return
  1090. */
  1091. public boolean updateDefaultFilters(String userName,String filters);
  1092. /**
  1093. * @description:query all default filters
  1094. * @date:2014-5-6 上午11:25:51
  1095. * @version:v1.0
  1096. * @param userName
  1097. * @return
  1098. */
  1099. public List<String> queryDefaultFilters(String userName);
  1100. /**
  1101. * @description:add event
  1102. * @date:2014-5-6 上午11:27:22
  1103. * @version:v1.0
  1104. * @param eventName
  1105. * @return
  1106. */
  1107. public boolean addEvent(String eventName);
  1108. /**
  1109. * @description:update event
  1110. * @date:2014-5-6 上午11:27:34
  1111. * @version:v1.0
  1112. * @param eventName
  1113. * @return
  1114. */
  1115. public boolean updateEvent(String eventName);
  1116. /**
  1117. * @description:add event user
  1118. * @date:2014-5-6 上午11:27:45
  1119. * @version:v1.0
  1120. * @param userName
  1121. * @param eventId
  1122. * @return
  1123. */
  1124. public boolean addEventUser(String userName,int eventId);
  1125. /**
  1126. * @description:remove event user
  1127. * @date:2014-5-6 上午11:27:56
  1128. * @version:v1.0
  1129. * @param userName
  1130. * @param eventId
  1131. * @return
  1132. */
  1133. public boolean removeEventUser(String userName,int eventId);
  1134. /**
  1135. * @description:query if user is valid of event
  1136. * @date:2014-5-6 上午11:28:27
  1137. * @version:v1.0
  1138. * @param userName
  1139. * @param eventId
  1140. * @return
  1141. */
  1142. public boolean isValidUser(String userName,int eventId);
  1143. /**
  1144. * @description:query template by template name
  1145. * @date:2014-5-6 上午11:30:47
  1146. * @version:v1.0
  1147. * @param templateName
  1148. * @return
  1149. */
  1150. public Template queryTemplateByName(String templateName);
  1151. /**
  1152. * @description:query all scripts
  1153. * @date:2014-5-6 上午11:31:04
  1154. * @version:v1.0
  1155. * @return
  1156. */
  1157. public List<Script> queryAllScripts();
  1158. /**
  1159. * @description:add script
  1160. * @date:2014-5-6 上午11:31:13
  1161. * @version:v1.0
  1162. * @param script
  1163. * @return
  1164. */
  1165. public UUID addScript(Script script);
  1166. /**
  1167. * @description:update script to database
  1168. * @date:2014-5-6 上午11:31:23
  1169. * @version:v1.0
  1170. * @param script
  1171. * @return
  1172. */
  1173. public ErrorCode updateScript(Script script);
  1174. /**
  1175. * @description:query script by id
  1176. * @date:2014-5-6 上午11:31:35
  1177. * @version:v1.0
  1178. * @param scriptId
  1179. * @return
  1180. */
  1181. public Script queryScript(UUID scriptId);
  1182. /**
  1183. * @description:query script not contain import info
  1184. * @date:2014-5-6 上午11:31:49
  1185. * @version:v1.0
  1186. * @param scriptId
  1187. * @return
  1188. */
  1189. public Script queryScriptNoImport(UUID scriptId);
  1190. /**
  1191. * @description:remove script
  1192. * @date:2014-5-6 上午11:32:14
  1193. * @version:v1.0
  1194. * @param scriptId
  1195. * @return
  1196. */
  1197. public ErrorCode removeScript(UUID scriptId);
  1198. /**
  1199. * @description:create script by user
  1200. * @date:2014-5-6 上午11:32:24
  1201. * @version:v1.0
  1202. * @param createUser
  1203. * @return
  1204. */
  1205. public Script createScript(String createUser);
  1206. /**
  1207. * @description:query allow template scripts
  1208. * @date:2014-5-6 上午11:35:13
  1209. * @version:v1.0
  1210. * @param templateId
  1211. * @return
  1212. */
  1213. public Script[] queryAllowedTemplateScripts(UUID templateId);
  1214. /**
  1215. * @description:query template scripts
  1216. * @date:2014-5-6 上午11:35:25
  1217. * @version:v1.0
  1218. * @param templateId
  1219. * @return
  1220. */
  1221. public Script[] queryTemplateScripts(UUID templateId);
  1222. /**
  1223. * @description:query user default template
  1224. * @date:2014-5-6 上午11:35:38
  1225. * @version:v1.0
  1226. * @param userName
  1227. * @return
  1228. */
  1229. public String getUserDefaultTemplate(String userName);
  1230. /**
  1231. * @description:add or update user default template
  1232. * @date:2014-5-6 上午11:35:51
  1233. * @version:v1.0
  1234. * @param userName
  1235. * @param templateId
  1236. * @return
  1237. */
  1238. public boolean addOrUpdateUserDefaultTemplate(String userName,String templateId);
  1239. /**
  1240. * @description:add user
  1241. * @date:2014-5-6 上午11:36:06
  1242. * @version:v1.0
  1243. * @param userInfo
  1244. * @return
  1245. */
  1246. public boolean addUserInfo(UserInfo userInfo);
  1247. /**
  1248. * @description:update user
  1249. * @date:2014-5-6 上午11:36:14
  1250. * @version:v1.0
  1251. * @param userInfo
  1252. * @return
  1253. */
  1254. public boolean updateUserInfo(UserInfo userInfo);
  1255. /**
  1256. * @description:query user by userid
  1257. * @date:2014-5-6 上午11:36:23
  1258. * @version:v1.0
  1259. * @param userId
  1260. * @return
  1261. */
  1262. public UserInfo queryUserInfoById(int userId);
  1263. /**
  1264. * @description:query user by userMail
  1265. * @date:2014-5-6 上午11:36:43
  1266. * @version:v1.0
  1267. * @param userMail
  1268. * @return
  1269. */
  1270. public UserInfo queryUserInfoByUserName(String userMail);
  1271. /**
  1272. * @description:query userInfo by usermails
  1273. * @date:2014-8-13 下午5:23:56
  1274. * @version:v1.0
  1275. * @param userMails
  1276. * @return
  1277. */
  1278. public Map<String, UserInfo> queryUserInfoByUserNames(String[] userMails);
  1279. /**
  1280. * @description:remove user
  1281. * @date:2014-5-6 上午11:36:58
  1282. * @version:v1.0
  1283. * @param userInfo
  1284. * @return
  1285. */
  1286. public boolean removeUserInfo(UserInfo userInfo);
  1287. /**
  1288. * @description:query if user is exist
  1289. * @date:2014-5-6 上午11:37:07
  1290. * @version:v1.0
  1291. * @param userName
  1292. * @return
  1293. */
  1294. public boolean isUserExisted(String userName);
  1295. /*******************************tag data start****************************************/
  1296. /**
  1297. * @description:return all user tag datas
  1298. * @date:2014-5-6 上午11:42:20
  1299. * @version:v1.0
  1300. * @param userName
  1301. * @return
  1302. */
  1303. public Map<String,String> getUserClassifyDataMap(String userName);
  1304. /**
  1305. * @description:add tag
  1306. * @date:2014-5-6 上午11:43:07
  1307. * @version:v1.0
  1308. * @param userName
  1309. * @param tagName
  1310. * @param tagColor
  1311. * @return
  1312. */
  1313. public int addTag(String userName, String tagName, String tagColor);
  1314. /**
  1315. * @description:update tag
  1316. * @date:2014-5-6 上午11:43:15
  1317. * @version:v1.0
  1318. * @param tagId
  1319. * @param tagName
  1320. * @param tagColor
  1321. * @return
  1322. */
  1323. public boolean updateTag(String tagId, String tagName, String tagColor);
  1324. /**
  1325. * @description:delete tag
  1326. * @date:2014-5-6 上午11:43:25
  1327. * @version:v1.0
  1328. * @param tagId
  1329. * @return
  1330. */
  1331. public boolean deleteTag(String tagId);
  1332. /**
  1333. * @description:get all tags of user
  1334. * @date:2014-5-6 上午11:43:34
  1335. * @version:v1.0
  1336. * @param userName
  1337. * @return
  1338. */
  1339. public List<TagBean> getAllTag(String userName);
  1340. /**
  1341. * @description:add datas to tag
  1342. * @date:2014-5-6 上午11:43:45
  1343. * @version:v1.0
  1344. * @param toTagId
  1345. * @param dataIds
  1346. * @return
  1347. */
  1348. public boolean addTagData(String toTagId, String[] dataIds);
  1349. /**
  1350. * @description:delete datas from tag
  1351. * @date:2014-5-6 上午11:43:57
  1352. * @version:v1.0
  1353. * @param tagId
  1354. * @param dataIds
  1355. * @return
  1356. */
  1357. public boolean deleteTagData(String tagId, String[] dataIds);
  1358. /**
  1359. * @description:get all datas of tag
  1360. * @date:2014-5-6 上午11:44:07
  1361. * @version:v1.0
  1362. * @param tagId
  1363. * @return
  1364. */
  1365. public String[] getTagDataById(String tagId);
  1366. /**
  1367. * @description:get all tags of data
  1368. * @date:2014-5-6 上午11:44:24
  1369. * @version:v1.0
  1370. * @param userName
  1371. * @param dataId
  1372. * @return
  1373. */
  1374. public List<TagBean> getDataTags(String userName,String dataId);
  1375. /*****************************tag data end**********************************************/
  1376. /*****************************user start************************************************/
  1377. /**
  1378. * @description:query all users by user array
  1379. * @date:2014-5-6 上午11:46:10
  1380. * @version:v1.0
  1381. * @param userArray
  1382. * @return
  1383. */
  1384. public List<UserInfo> queryAllUserInfo(String[] userArray);
  1385. /**
  1386. * @description:query all users by user array
  1387. * @date:2014-5-6 上午11:46:31
  1388. * @version:v1.0
  1389. * @param userArray
  1390. * @param isQuit:user is quit
  1391. * @return
  1392. */
  1393. public List<UserInfo> queryAllUserInfo(String[] userArray, boolean isQuit);
  1394. /*****************************user end**************************************************/
  1395. /**
  1396. * @description:query database colname of field
  1397. * @date:2014-5-6 上午11:46:51
  1398. * @version:v1.0
  1399. * @param fieldId
  1400. * @param templateId
  1401. * @return
  1402. */
  1403. public String getDbFieldName(UUID fieldId, UUID templateId);
  1404. /**
  1405. * @description:add template operate log
  1406. * @date:2014-5-6 上午11:47:15
  1407. * @version:v1.0
  1408. * @param templateOperateLog
  1409. * @return
  1410. */
  1411. public boolean addTemplateOpreateLog(TemplateOperateLog templateOperateLog);
  1412. /*****************************default values start******************************************/
  1413. /**
  1414. * @description:set user template default values
  1415. * @date:2014-5-6 上午11:48:11
  1416. * @version:v1.0
  1417. * @param userName
  1418. * @param templateId
  1419. * @param defaultValueJson
  1420. * @return
  1421. */
  1422. public boolean setDefaultValues(String userName, String templateId, String defaultValueJson);
  1423. /**
  1424. * @description:get user template default values
  1425. * @date:2014-5-6 上午11:48:22
  1426. * @version:v1.0
  1427. * @param userName
  1428. * @param templateId
  1429. * @return
  1430. */
  1431. public String getDefaultValues(String userName, String templateId);
  1432. /*****************************default values end********************************************/
  1433. /**
  1434. * @description:return all users has back rights
  1435. * @date:2014-5-6 上午11:48:58
  1436. * @version:v1.0
  1437. * @return
  1438. */
  1439. public List<UserInfo> getBackRightUsers(); //查询所有后台权限人员
  1440. /**
  1441. * @description:add back right of user
  1442. * @date:2014-5-6 上午11:49:14
  1443. * @version:v1.0
  1444. * @param userMail
  1445. * @return
  1446. */
  1447. public boolean addBackRightUser(String userMail); //添加后台权限人员
  1448. /**
  1449. * @description:remove back right of user
  1450. * @date:2014-5-6 上午11:49:28
  1451. * @version:v1.0
  1452. * @param userMail
  1453. * @return
  1454. */
  1455. public boolean delBackRightUser(String userMail); //删除后台权限人员
  1456. /**
  1457. * @description:get template operate right users
  1458. * @date:2014-5-6 上午11:49:41
  1459. * @version:v1.0
  1460. * @param templateId
  1461. * @return
  1462. */
  1463. public List<UserInfo> getTemplateRightUser(String templateId);
  1464. /**
  1465. * @description:remove user template operate right
  1466. * @date:2014-5-6 上午11:50:11
  1467. * @version:v1.0
  1468. * @param templateId
  1469. * @param userMail
  1470. * @return
  1471. */
  1472. public boolean delUserTemplateRight(String templateId, String userMail);
  1473. /**
  1474. * @description:add user template operate right
  1475. * @date:2014-5-6 上午11:50:27
  1476. * @version:v1.0
  1477. * @param templateId
  1478. * @param userMail
  1479. * @return
  1480. */
  1481. public boolean addUserTemplateRight(String[] templateId, String userMail);
  1482. /**
  1483. * @description:query all template rights of user
  1484. * @date:2014-5-6 上午11:51:02
  1485. * @version:v1.0
  1486. * @param userMail
  1487. * @return
  1488. */
  1489. public Map<String, String> queryUserTemplateRights(String userMail);
  1490. /**
  1491. * @description:set system setting(json)
  1492. * @date:2014-5-6 上午11:51:20
  1493. * @version:v1.0
  1494. * @param systemJson
  1495. * @return
  1496. */
  1497. public boolean setSystemOption(String systemJson);
  1498. /**
  1499. * @description:get system setting(json)
  1500. * @date:2014-5-6 上午11:51:35
  1501. * @version:v1.0
  1502. * @param userMail
  1503. * @return
  1504. */
  1505. public String getSystemOption(String userMail); //系统设置
  1506. /**
  1507. * @description:update data log
  1508. * @date:2014-5-6 上午11:51:53
  1509. * @version:v1.0
  1510. * @param dataId
  1511. * @param logIndex
  1512. * @param logContent
  1513. * @return
  1514. */
  1515. public boolean updateDataLog(UUID dataId, int logIndex, String logContent);
  1516. /**
  1517. * @description:add field database colname to database
  1518. * @date:2014-5-6 上午11:52:32
  1519. * @version:v1.0
  1520. * @param templateId
  1521. * @param fieldColName
  1522. * @param fieldId
  1523. * @param fieldType
  1524. * @return
  1525. */
  1526. public boolean addFieldColName(String templateId,String fieldColName,String fieldId,String fieldType);
  1527. /**
  1528. * @description:query all statistics of user
  1529. * @date:2014-5-6 上午11:52:53
  1530. * @version:v1.0
  1531. * @param userName
  1532. * @return
  1533. */
  1534. public TimerAction[] queryStatisticByUser(String userName);
  1535. /**
  1536. * @description:query all users by user status
  1537. * @date:2014-5-6 上午11:53:14
  1538. * @version:v1.0
  1539. * @param userStat
  1540. * @param userName
  1541. * @return
  1542. */
  1543. public List<UserInfo> queryAllUsersByStatAndName(String curUser,String userStat,String queryUserName);
  1544. /**
  1545. * @description:update attachment
  1546. * @date:2014-5-6 上午11:53:34
  1547. * @version:v1.0
  1548. * @param attachment
  1549. * @return
  1550. */
  1551. public boolean updateAttachment(Attachment attachment);
  1552. /**
  1553. * @description:add template right user
  1554. * @date:2014-5-6 上午11:53:45
  1555. * @version:v1.0
  1556. * @param templateId
  1557. * @param userMails
  1558. * @return
  1559. */
  1560. public boolean addtemplateUserRight(String templateId,String[] userMails);
  1561. /**
  1562. * @description:remove template operate user
  1563. * @date:2014-5-6 上午11:53:59
  1564. * @version:v1.0
  1565. * @param templateId
  1566. * @param user
  1567. * @return
  1568. */
  1569. public boolean delTemplateUserRight(String templateId,String user);
  1570. /********************使用说明开始********************************************/
  1571. /**
  1572. * @description:get all guide
  1573. * @date:2014-6-10 上午11:25:33
  1574. * @version:v1.0
  1575. * @return
  1576. */
  1577. public List<GuideBean> queryAllGuide();
  1578. /**
  1579. * @description:get guide by guideId
  1580. * @date:2014-6-10 上午11:25:55
  1581. * @version:v1.0
  1582. * @param guideId
  1583. * @return
  1584. */
  1585. public String queryGuideHtmlByGuideId( String guideId);
  1586. /**
  1587. * @description:save guide by guideid
  1588. * @date:2014-6-10 上午11:26:31
  1589. * @version:v1.0
  1590. * @param guideId
  1591. * @param guideHtml
  1592. * @return
  1593. */
  1594. public boolean saveGuideHtml(String guideId , String guideHtml);
  1595. /********************使用说明结束********************************************/
  1596. public enum ErrorCode
  1597. {
  1598. success, privilegeFail, dbFail, scriptBeforeFail, scriptAfterFail, nullClientFail, unknownFail, noSuchTemplateFail, noSuchTemplateTypeFail, alreadyDeleted, alreadyUpdate, autoCommitted;
  1599. }
  1600. }