TableExplorer.js 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310
  1. MWF.xDesktop.requireApp("query.QueryManager", "StatExplorer", null, false);
  2. MWF.xApplication.query.QueryManager.TableExplorer = new Class({
  3. Extends: MWF.xApplication.query.QueryManager.StatExplorer,
  4. Implements: [Options, Events],
  5. options: {
  6. "style": "default",
  7. "tooltip": {
  8. "create": MWF.xApplication.query.QueryManager.LP.table.create,
  9. "search": MWF.xApplication.query.QueryManager.LP.table.search,
  10. "searchText": MWF.xApplication.query.QueryManager.LP.table.searchText,
  11. "noElement": MWF.xApplication.query.QueryManager.LP.table.noStatNoticeText
  12. }
  13. },
  14. initialize: function(node, actions, options){
  15. this.setOptions(options);
  16. this.setTooltip();
  17. this.path = "../x_component_query_QueryManager/$Explorer/";
  18. this.cssPath = "../x_component_query_QueryManager/$Explorer/"+this.options.style+"/css.wcss";
  19. this._loadCss();
  20. this.actions = actions;
  21. this.node = $(node);
  22. this.initData();
  23. },
  24. keyCopy: function(e){
  25. if (this.selectMarkItems.length){
  26. var items = [];
  27. var i = 0;
  28. var checkItems = function(e){
  29. if (i>=this.selectMarkItems.length){
  30. if (items.length){
  31. var str = JSON.encode(items);
  32. if (e){
  33. e.clipboardData.setData('text/plain', str);
  34. }else {
  35. window.clipboardData.setData("Text", str);
  36. }
  37. this.app.notice(this.app.lp.copyed, "success");
  38. }
  39. }
  40. }.bind(this);
  41. this.selectMarkItems.each(function(item){
  42. this.app.restActions.getTable(item.data.id, function(json){
  43. json.data.elementType = "table";
  44. items.push(json.data);
  45. i++;
  46. checkItems(e);
  47. }.bind(this), null, false)
  48. }.bind(this));
  49. if (e) e.preventDefault();
  50. }
  51. },
  52. keyPaste: function(e){
  53. var dataStr = "";
  54. if (e){
  55. dataStr = e.clipboardData.getData('text/plain');
  56. }else{
  57. dataStr = window.clipboardData.getData("Text");
  58. }
  59. var data = JSON.decode(dataStr);
  60. this.pasteItem(data, 0);
  61. },
  62. pasteItem: function(data, i){
  63. if (i<data.length){
  64. var item = data[i];
  65. if (item.elementType==="table"){
  66. this.saveItemAs(item, function(){
  67. i++;
  68. this.pasteItem(data, i);
  69. }.bind(this), function(){
  70. i++;
  71. this.pasteItem(data, i);
  72. }.bind(this), function(){
  73. this.reload();
  74. }.bind(this));
  75. }else{
  76. i++;
  77. this.pasteItem(data, i);
  78. }
  79. }else{
  80. this.reload();
  81. }
  82. },
  83. saveItemAs: function(data, success, failure, cancel){
  84. this.app.restActions.listTable(this.app.options.application.id, function(dJson){
  85. var i=1;
  86. var someItems = dJson.data.filter(function(d){ return (d.name && d.name===data.name) || (d.alias && d.alias===data.alias) });
  87. if (someItems.length){
  88. var someItem = someItems[0];
  89. var lp = this.app.lp;
  90. var _self = this;
  91. var d1 = new Date().parse(data.lastUpdateTime || data.updateTime);
  92. var d2 = new Date().parse(someItem.lastUpdateTime || someItem.updateTime);
  93. var html = "<div>"+lp.copyConfirmInfor+"</div>";
  94. html += "<div style='overflow: hidden; margin: 10px 0px; padding: 5px 10px; background-color: #ffffff; border-radius: 6px;'><div style='font-weight: bold; font-size:14px;'>"+lp.copySource+" "+someItem.name+"</div>";
  95. html += "<div style='font-size:12px; color: #666666; float: left'>"+(someItem.lastUpdateTime || someItem.updateTime)+"</div>" +
  96. "<div style='font-size:12px; color: #666666; float: left; margin-left: 20px;'>"+MWF.name.cn(someItem.lastUpdatePerson || "")+"</div>" +
  97. "<div style='color: red; float: right;'>"+((d1>=d2) ? "": lp.copynew)+"</div></div>";
  98. html += "<div style='overflow: hidden; margin: 10px 0px; padding: 5px 10px; background-color: #ffffff; border-radius: 6px;'><div style='clear: both;font-weight: bold; font-size:14px;'>"+lp.copyTarget+" "+data.name+"</div>";
  99. html += "<div style='font-size:12px; color: #666666; float: left;'>"+(data.lastUpdateTime || data.updateTime)+"</div>" +
  100. "<div style='font-size:12px; color: #666666; float: left; margin-left: 20px;'>"+MWF.name.cn(data.lastUpdatePerson || "")+"</div>" +
  101. "<div style='color: red; float: right;'>"+((d1<=d2) ? "": lp.copynew)+"</div></div>";
  102. // html += "<>"
  103. this.app.dlg("inofr", null, this.app.lp.copyConfirmTitle, {"html": html}, 500, 290, [
  104. {
  105. "text": lp.copyConfirm_overwrite,
  106. "action": function(){_self.saveItemAsUpdate(someItem, data, success, failure);this.close();}
  107. },
  108. {
  109. "text": lp.copyConfirm_new,
  110. "action": function(){_self.saveItemAsNew(dJson, data, success, failure);this.close();}
  111. },
  112. {
  113. "text": lp.copyConfirm_skip,
  114. "action": function(){/*nothing*/ this.close(); if (success) success();}
  115. },
  116. {
  117. "text": lp.copyConfirm_cancel,
  118. "action": function(){this.close(); if (cancel) cancel();}
  119. }
  120. ]);
  121. }else{
  122. this.saveItemAsNew(dJson, data, success, failure)
  123. }
  124. }.bind(this), function(){if (failure) failure();}.bind(this));
  125. },
  126. saveItemAsUpdate: function(someItem, data, success, failure){
  127. var item = this.app.options.application;
  128. var id = item.id;
  129. var name = item.name;
  130. //var dataJson = (data.data) ? JSON.decode(data.data): "";
  131. var draftDataJson = (data.draftData) ? JSON.decode(data.draftData): "";
  132. data.draftData = draftDataJson;
  133. data.statu = "draft";
  134. var dataJson = (data.data) ? JSON.decode(data.data): "";
  135. data.data = dataJson;
  136. data.data.id = someItem.id;
  137. data.data = JSON.encode(data.data);
  138. data.id = someItem.id;
  139. data.isNewTable = false;
  140. data.application = id;
  141. data.applicationName = name;
  142. this.app.restActions.saveTable(data, function(){
  143. if (success) success();
  144. }.bind(this), function(){
  145. if (failure) failure();
  146. }.bind(this));
  147. },
  148. saveItemAsNew: function(dJson, data, success, failure){
  149. var item = this.app.options.application;
  150. var id = item.id;
  151. var name = item.name;
  152. var oldName = data.name;
  153. var i=1;
  154. while (dJson.data.some(function(d){ return d.name==data.name || d.alias==data.name })){
  155. data.name = oldName+"_copy"+i;
  156. data.alias = oldName+"_copy"+i;
  157. i++;
  158. }
  159. var draftDataJson = (data.draftData) ? JSON.decode(data.draftData): "";
  160. data.draftData = draftDataJson;
  161. var dataJson = (data.data) ? JSON.decode(data.data): "";
  162. data.data = dataJson;
  163. data.data.id = "";
  164. data.data = JSON.encode(data.data);
  165. data.id = "";
  166. data.isNewTable = true;
  167. data.application = id;
  168. data.applicationName = name;
  169. this.app.restActions.saveTable(data, function(){
  170. if (success) success();
  171. }.bind(this), function(){
  172. if (failure) failure();
  173. }.bind(this));
  174. },
  175. _createElement: function(e){
  176. var _self = this;
  177. var options = {
  178. "onQueryLoad": function(){
  179. this.actions = _self.app.restActions;
  180. this.application = _self.app.options.application;
  181. this.explorer = _self;
  182. }
  183. };
  184. this.app.desktop.openApplication(e, "query.TableDesigner", options);
  185. },
  186. _loadItemDataList: function(callback){
  187. this.app.restActions.listTable(this.app.options.application.id,callback);
  188. },
  189. _getItemObject: function(item){
  190. return new MWF.xApplication.query.QueryManager.TableExplorer.Table(this, item);
  191. },
  192. deleteItems: function(){
  193. this.hideDeleteAction();
  194. while (this.deleteMarkItems.length){
  195. var item = this.deleteMarkItems.shift();
  196. if (this.deleteMarkItems.length){
  197. item.deleteTable();
  198. }else{
  199. item.deleteTable(function(){
  200. //this.reloadItems();
  201. //this.hideDeleteAction();
  202. }.bind(this));
  203. }
  204. }
  205. }
  206. });
  207. MWF.xApplication.query.QueryManager.TableExplorer.Table= new Class({
  208. Extends: MWF.xApplication.query.QueryManager.StatExplorer.Stat,
  209. _open: function(e){
  210. var _self = this;
  211. var options = {
  212. "appId": "query.TableDesigner"+_self.data.id,
  213. "onQueryLoad": function(){
  214. this.actions = _self.explorer.actions;
  215. this.category = _self;
  216. this.options.id = _self.data.id;
  217. this.application = _self.explorer.app.options.application;
  218. }
  219. };
  220. this.explorer.app.desktop.openApplication(e, "query.TableDesigner", options);
  221. },
  222. _getIcon: function(){
  223. var x = (Math.random()*49).toInt();
  224. return "process_icon_"+x+".png";
  225. },
  226. _getLnkPar: function(){
  227. return {
  228. "icon": this.explorer.path+this.explorer.options.style+"/tableIcon/lnk.png",
  229. "title": this.data.name,
  230. "par": "query.TableDesigner#{\"appId\": \"query.TableDesigner"+this.data.id+"\", \"id\": \""+this.data.id+"\", \"applicationId\": \""+this.data.query+"\"}"
  231. };
  232. },
  233. deleteTable: function(callback){
  234. this.explorer.actions.deleteTable(this.data.id, function(){
  235. this.node.destroy();
  236. if (callback) callback();
  237. }.bind(this));
  238. },
  239. saveas: function(){
  240. MWF.xDesktop.requireApp("Selector", "package", function(){
  241. var selector = new MWF.O2Selector(this.explorer.app.content, {
  242. "title": this.explorer.app.lp.copyto,
  243. "type": "Query",
  244. "values": [this.explorer.app.options.application],
  245. "onComplete": function(items){
  246. items.each(function(item){
  247. this.saveItemAs(item.data);
  248. }.bind(this));
  249. }.bind(this),
  250. });
  251. }.bind(this));
  252. },
  253. saveItemAs: function(item){
  254. var id = item.id;
  255. var name = item.name;
  256. this.explorer.app.restActions.getTable(this.data.id, function(json){
  257. var draftDataJson = (data.draftData) ? JSON.decode(data.draftData): "";
  258. data.draftData = draftDataJson;
  259. var data = json.data;
  260. var dataJson = (data.data) ? JSON.decode(data.data): "";
  261. data.data = dataJson;
  262. data.status = "draft";
  263. data.data.id = "";
  264. data.data = JSON.encode(data.data);
  265. var oldName = data.name;
  266. this.explorer.app.restActions.listTable(id, function(dJson){
  267. var i=1;
  268. while (dJson.data.some(function(d){ return d.name==data.name || d.alias==data.name })){
  269. data.name = oldName+"_copy"+i;
  270. data.alias = oldName+"_copy"+i;
  271. i++;
  272. }
  273. data.id = "";
  274. data.isNewTable = true;
  275. data.application = id;
  276. data.applicationName = name;
  277. this.explorer.app.restActions.saveTable(data, function(){
  278. if (id == this.explorer.app.options.application.id) this.explorer.reload();
  279. }.bind(this));
  280. }.bind(this));
  281. }.bind(this));
  282. }
  283. });