dataTable.js 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287
  1. mgJsComponentHandler.addDefaultComponent('mg-datatable', {
  2. template : '#t-mg-datatable',
  3. props: [
  4. 'component_id',
  5. 'component_namespace',
  6. 'component_index',
  7. 'autoload_data_after_created',
  8. 'start_length'
  9. ],
  10. data : function() {
  11. return {
  12. dataRows: [],
  13. length: 10,
  14. iSortCol_0 : '',
  15. sSortDir_0 : '',
  16. addTimeout : false,
  17. sSearch : false,
  18. sSearchPrevious : false,
  19. dataShowing : 0,
  20. dataTo : 0,
  21. dataFrom : 0,
  22. curPage : 1,
  23. allPages : 1,
  24. pagesMap : [],
  25. loading : false,
  26. show : true,
  27. showModal : false,
  28. noData : false,
  29. onOffSwitchEnabled : false,
  30. children: [],
  31. searchEnabled: true
  32. };
  33. },
  34. created: function () {
  35. var self = this;
  36. self.length = self.start_length;
  37. this.addTimeout = true;
  38. if (this.autoload_data_after_created) {
  39. this.updateProjects();
  40. }
  41. this.$parent.$root.$on('reloadMgData', this.updateMgData);
  42. mgEventHandler.on('DatatableFilterUpdated', self.component_id, function(id, params){
  43. self.checkRequiredFilters();
  44. });
  45. this.$nextTick(function(){
  46. this.checkRequiredFilters();
  47. });
  48. },
  49. updated: function (){
  50. var self = this;
  51. initMassActionsOnDatatables(self.component_id);
  52. initTooltipsForDatatables(self.component_id);
  53. },
  54. methods: {
  55. checkRequiredFilters: function() {
  56. var requiredFilters = this.$store.getters.getComponentData(this.component_id, 'requiredFilters');
  57. if (typeof requiredFilters === 'object'){
  58. this.searchEnabled = true;
  59. for (var key in requiredFilters) {
  60. if (!requiredFilters.hasOwnProperty(key)) {
  61. continue;
  62. }
  63. if (requiredFilters[key] === true) {
  64. this.searchEnabled = false;
  65. }
  66. }
  67. }
  68. },
  69. updateMgData: function(toReloadId){
  70. var self = this;
  71. if(self.component_id === toReloadId){
  72. self.updateProjects();
  73. self.$nextTick(function() {
  74. self.$emit('restartRefreshingState');
  75. });
  76. }
  77. },
  78. updateProjects: function(){
  79. var self = this;
  80. self.loading = true;
  81. var resp = self.$parent.$root.$options.methods.vloadData(
  82. {
  83. loadData : self.component_id,
  84. namespace : self.component_namespace,
  85. index: self.component_index,
  86. iDisplayLength : self.length,
  87. iDisplayStart : self.dataShowing,
  88. sSearch : (self.sSearch !== false ? self.sSearch : ''),
  89. iSortCol_0 : self.iSortCol_0,
  90. sSortDir_0 : self.sSortDir_0,
  91. filters: self.getFilters()
  92. });
  93. resp.done(function(data){
  94. if (data.data.status === 'error') {
  95. self.noData = true;
  96. mgPageControler.vueLoader.handleErrorMessage(data.data);
  97. } else {
  98. var actionData = data.data.rawData;
  99. data = data.data.rawData.recordsSet;
  100. if( typeof data.records == "undefined"){
  101. data.records =[];
  102. }
  103. if (data.records.length === 0 && self.dataShowing > 0) {
  104. self.dataShowing = 0;
  105. return self.updateProjects();
  106. }
  107. self.dataRows = data.records;
  108. self.runCalbacks(actionData);
  109. mgEventHandler.runCallback('DatatableDataLoaded', self.component_id, {data: data.records, datatable: self});
  110. self.dataShowing = data.offset;
  111. self.dataTo = data.records.length + data.offset;
  112. self.dataFrom = data.fullDataLenght;
  113. self.addTimeout = false;
  114. if(self.addTimeout === true){
  115. setTimeout(self.updateProjects, 60000);
  116. self.addTimeout = false;
  117. }
  118. self.noData = data.records.length > 0 ? false : true;
  119. }
  120. self.updatePagination();
  121. self.loading = false;
  122. }).fail(function(jqXHR, textStatus, errorThrown) {
  123. self.loading = false;
  124. self.dataRows = [];
  125. self.noData = true;
  126. mgEventHandler.runCallback('DatatableDataLoadingFailed', self.component_id, {jqXHR: jqXHR, textStatus: textStatus, errorThrown: errorThrown});
  127. mgPageControler.vueLoader.handleServerError(jqXHR, textStatus, errorThrown);
  128. });
  129. uncheckSelectAllCheck(self.tableWrapperId);
  130. },
  131. runCalbacks: function(data) {
  132. var self = this;
  133. if (typeof data.recordsSet !== 'undefined' && typeof data.recordsSet.records !== 'undefined' && data.recordsSet.records.length > 0)
  134. {
  135. $('#loadedTemplates').append(data.template);
  136. self.$nextTick(function() {
  137. for (var key in data.registrations) {
  138. mgJsComponentHandler.extendRegisterByDefaultTemplate(key.toLowerCase(), data.registrations[key]);
  139. }
  140. });
  141. }
  142. },
  143. updateLength: function(event){
  144. var self = this;
  145. var btnTarget = (typeof $(event.target).attr('data-length') === 'undefined') ? $(event.target).parent() : $(event.target);
  146. self.length = $(btnTarget).attr('data-length');
  147. self.dataShowing = 0;
  148. $(btnTarget).parent().children('.active').removeClass('active');
  149. $(btnTarget).addClass('active');
  150. self.updateProjects();
  151. },
  152. updateSorting: function(event){
  153. var self = this;
  154. var sortTarget = $(event.target)[0].tagName === 'TH' ? $(event.target) : $(event.target).parents('th').first();
  155. self.iSortCol_0 = $(sortTarget).attr('name');
  156. self.dataShowing = 0;
  157. var currentDir = self.getSortDir($(sortTarget), true);
  158. $(event.target).parents('tr').first().children('.sorting_asc, .sorting_desc').addClass('sorting').removeClass('sorting_asc').removeClass('sorting_desc');
  159. $(sortTarget).removeClass('sorting').removeClass('sorting_asc').removeClass('sorting_desc').addClass(self.reverseSort(currentDir));
  160. self.sSortDir_0 = self.getSortDir($(sortTarget), false);
  161. self.updateProjects();
  162. },
  163. reverseSort: function(sort){
  164. var sortingType = 'sorting_asc';
  165. if(sort === 'sorting_asc'){
  166. sortingType = 'sorting_desc';
  167. }
  168. return sortingType;
  169. },
  170. getSortDir: function(elem, rawClass){
  171. var sorts = ['sorting_asc', 'sorting_desc', 'sorting'];
  172. var sorting = '';
  173. $.each(sorts, function(key, sort) {
  174. if($(elem).hasClass(sort) === true) {
  175. sorting = rawClass ? sort : sort.replace('sorting_', '').replace('sorting', '');
  176. return sorting;
  177. }
  178. });
  179. return sorting;
  180. },
  181. searchDataEnter: function(event){
  182. event.preventDefault();
  183. this.searchData(event);
  184. },
  185. searchData: function(event){
  186. var self = this;
  187. self.sSearch = $(event.target).val() === '' ? false : $(event.target).val();
  188. if (self.sSearch !== false) {
  189. if (self.sSearchPrevious !== false && self.sSearchPrevious !== self.sSearch) {
  190. self.dataShowing = 0;
  191. }
  192. self.sSearchPrevious = self.sSearch;
  193. } else {
  194. self.sSearchPrevious = false;
  195. }
  196. self.updateProjects();
  197. },
  198. updatePagination: function(){
  199. var self = this;
  200. self.curPage = (parseInt(self.dataShowing) / parseInt(self.length)) + 1;
  201. var tempPages = parseInt(parseInt(self.dataFrom) / parseInt(self.length));
  202. self.allPages = parseInt(tempPages + ((parseInt(self.length) * tempPages) < parseInt(self.dataFrom) ? 1 : 0));
  203. self.updatePagesMap();
  204. },
  205. updatePagesMap: function(){
  206. var self = this;
  207. if (self.allPages === 1) {
  208. self.pagesMap = [1];
  209. return;
  210. }
  211. self.pagesMap = [
  212. self.curPage -5,
  213. self.curPage -4,
  214. self.curPage -3,
  215. self.curPage -2,
  216. self.curPage -1,
  217. self.curPage,
  218. self.curPage +1,
  219. self.curPage +2,
  220. self.curPage +3,
  221. self.curPage +4,
  222. self.curPage +5
  223. ];
  224. for(i=0; i< self.pagesMap.length; i++){
  225. if(self.pagesMap[i] < 0 || self.pagesMap[i] > self.allPages){
  226. self.pagesMap[i] = null;
  227. }
  228. }
  229. if(self.pagesMap.indexOf(self.allPages) === -1) {
  230. self.pagesMap[self.pagesMap.length-1] = self.allPages;
  231. }
  232. if(self.pagesMap.indexOf(1) === -1) {
  233. self.pagesMap[0] = 1;
  234. }
  235. if(self.allPages > 7 && self.curPage > 4) {
  236. self.pagesMap[self.pagesMap.indexOf(Math.min(
  237. self.curPage-1 > 1 ? self.curPage-1 : self.curPage,
  238. self.curPage-2 > 1 ? self.curPage-2 : self.curPage,
  239. self.curPage-3 > 1 ? self.curPage-3 : self.curPage,
  240. self.curPage-4 > 1 ? self.curPage-4 : self.curPage
  241. ))] = '...';
  242. }
  243. for(i=self.pagesMap.length-1; i > self.pagesMap.indexOf(self.curPage); i--){
  244. if(i === 8 && self.pagesMap[i] === self.curPage + 3 && self.pagesMap[i] !== self.allPages) {
  245. self.pagesMap[i] = null;
  246. }
  247. }
  248. if(self.allPages > 7 && (4 <= self.allPages - self.curPage)) {
  249. self.pagesMap[self.pagesMap.indexOf(self.allPages) - 1] = '...';
  250. }
  251. },
  252. changePage: function(event) {
  253. var self = this;
  254. if($(event.target).parent().hasClass('disabled') === false && $(event.target).hasClass('disabled') === false){
  255. var newPageNumber = $(event.target).attr('data-dt-idx');
  256. self.dataShowing = ((newPageNumber < 1) ? 0 : newPageNumber -1) * parseInt(self.length);
  257. self.updateProjects();
  258. }
  259. },
  260. rowDrow : function(name, DataRow, customFunctionName) {
  261. if(window[customFunctionName] === undefined) {
  262. return DataRow[name];
  263. } else {
  264. return window[customFunctionName](name, DataRow);
  265. }
  266. },
  267. loadModal: function(event, targetId, namespace, index, params, addSpinner){
  268. mgPageControler.vueLoader.loadModal(event, targetId,
  269. typeof namespace !== 'undefined' ? namespace : getItemNamespace(targetId),
  270. typeof index !== 'undefined' ? index : getItemIndex(targetId), params, addSpinner);
  271. },
  272. onOffSwitch: function(event, targetId){
  273. var switchPostData = $(event.target).is(':checked') ? {'value' : 'on'} : {'value' : 'off'};
  274. mgPageControler.vueLoader.ajaxAction(event, targetId, getItemNamespace(targetId), getItemIndex(targetId), switchPostData);
  275. },
  276. redirect : function (event, params, targetBlank) {
  277. mgPageControler.vueLoader.redirect(event, params, targetBlank);
  278. },
  279. getFilters: function () {
  280. return this.$store.getters.getComponentData(this.component_id, 'filters');
  281. }
  282. }
  283. });