TableExplorer.js 12 KB

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