zentaobiz.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717
  1. var echart;
  2. var noDataDom;
  3. $(function()
  4. {
  5. var chart = DataStorage.clone('chart');
  6. if(!chart.settings || !(chart.settings instanceof Array)) chart.settings = [{type: chart.type ? chart.type : 'pie'}];
  7. if(!chart.settings.length) chart.settings = [{type: chart.type ? chart.type : 'pie'}];
  8. if(!chart.filters || !(chart.filters instanceof Array)) chart.filters = [];
  9. DataStorage.chart = chart;
  10. switchStep(DataStorage.step);
  11. $('#type').picker({'maxDropHeight': pickerHeight});
  12. $('body').resize(() => {calcDesignGrowFilter(true);});
  13. });
  14. /**
  15. * Tab click callback.
  16. *
  17. * @param object evt
  18. * @param int nextStep
  19. * @access public
  20. * @return void
  21. */
  22. function tabClick(evt, nextStep)
  23. {
  24. var step = DataStorage.step;
  25. if($(evt).hasClass('disabled') || step == nextStep) return;
  26. if(nextStep < step)
  27. {
  28. DataStorage.step = nextStep;
  29. switchStep(nextStep);
  30. return;
  31. }
  32. finishStep(step, nextStep, function(nextStep)
  33. {
  34. DataStorage.step = nextStep;
  35. switchStep(nextStep);
  36. });
  37. }
  38. /**
  39. * Next step click callback.
  40. *
  41. * @access public
  42. * @return void
  43. */
  44. function nextStep()
  45. {
  46. var step = DataStorage.step;
  47. finishStep(step, step + 1, function(nextStep)
  48. {
  49. DataStorage.step = nextStep;
  50. switchStep(nextStep);
  51. });
  52. }
  53. /**
  54. * Submit publish.
  55. *
  56. * @access public
  57. * @return void
  58. */
  59. function publish(stage = 'published')
  60. {
  61. var chart = DataStorage.clone('chart');
  62. var isPublished = chart.stage == 'published';
  63. if(stage == 'published' && !validate()) return;
  64. if(stage == 'draft')
  65. {
  66. var chart = DataStorage.clone('chart');
  67. var newSql = $('#sql').val().replace(';', "").trim();
  68. var hasSettings = checkSettings();
  69. var sqlChange = chart.sql.length > 0 && newSql !== chart.sql;
  70. if(sqlChange && hasSettings)
  71. {
  72. bootbox.confirm(clearSettingsLang, function(res)
  73. {
  74. if(res)
  75. {
  76. /* Init chart design settings */
  77. chart.settings = [{type: 'pie'}];
  78. /* Init filter settings */
  79. chart.filters = [];
  80. loadConfigForm('pie', true);
  81. buildSettingForm(true);
  82. if(chart.used)
  83. {
  84. bootbox.confirm({message:confirmDraft,callback:save.bind(null, stage)});
  85. }
  86. else
  87. {
  88. if(isPublished) bootbox.confirm({message:chartLang.draftSave,callback:save.bind(null, stage)});
  89. if(!isPublished) save(stage);
  90. }
  91. DataStorage.chart = chart;
  92. }
  93. });
  94. }
  95. else
  96. {
  97. if(chart.used)
  98. {
  99. bootbox.confirm({message:confirmDraft,callback:save.bind(null, stage)});
  100. }
  101. else
  102. {
  103. if(isPublished) bootbox.confirm({message:chartLang.draftSave,callback:save.bind(null, stage)});
  104. if(!isPublished) save(stage);
  105. }
  106. }
  107. return;
  108. }
  109. if(chart.used) bootbox.confirm({message:confirmPublish,callback:save.bind(null, stage)});
  110. if(!chart.used) save(stage)
  111. }
  112. function save(stage, status = true)
  113. {
  114. if(!status || DataStorage.saving) return;
  115. DataStorage.saving = true;
  116. var chart = DataStorage.clone('chart');
  117. var fields = DataStorage.fields;
  118. var fieldSettings = DataStorage.fieldSettings;
  119. var langs = DataStorage.langs;
  120. var sqlbuilder = DataStorage.sqlbuilder;
  121. if(sqlbuilder && sqlbuilder.sql !== undefined) sqlbuilder.sql = window.latin1ToBase64(sqlbuilder.sql);
  122. chart.sql = window.latin1ToBase64($('#sql').val().replace(';', "").trim());
  123. chart.step = DataStorage.step;
  124. chart.mode = DataStorage.mode;
  125. chart.fields = Object.keys(fields);
  126. chart.fieldSettings = fieldSettings;
  127. chart.langs = langs;
  128. chart.stage = stage;
  129. chart.type = chart.settings[0].type;
  130. chart.acl = $('input[name="acl"]:checked').val();
  131. chart.whitelist = $('select[name="whitelist[]"]').val();
  132. chart.sqlbuilder = JSON.stringify(sqlbuilder);
  133. DataStorage.chart = chart;
  134. $.post(createLink('chart', 'design', 'chartID=' + chart.id), chart, function(response)
  135. {
  136. response = JSON.parse(response);
  137. if(response.result == 'success')
  138. {
  139. success(response.message);
  140. setTimeout(function()
  141. {
  142. window.location.href = createLink('chart', 'browse')
  143. DataStorage.saving = false;
  144. }, 2000);
  145. }
  146. else
  147. {
  148. DataStorage.saving = false;
  149. /* The result.message is just a string. */
  150. if($.type(response.message) == 'string')
  151. {
  152. if($('#responser').length == 0) return alert(response.message);
  153. return $('#responser').html(response.message).addClass('text-error').show().delay(3000).fadeOut(100);
  154. }
  155. /* The result.message is just a object. */
  156. if($.type(response.message) == 'object')
  157. {
  158. var triggered = new Array();
  159. $.each(response.message, function(key, value)
  160. {
  161. /* Define the id of the error objecjt and it's label. */
  162. var errorOBJ = '#legendBasicInfo #' + key;
  163. var errorLabel = key + 'Label';
  164. var i = triggered.push(false);
  165. /* Create the error message. */
  166. var errorMSG = '<div id="' + errorLabel + '" class="text-danger red">';
  167. errorMSG += $.type(value) == 'string' ? value : value.join(';');
  168. errorMSG += '</div>';
  169. /* Append error message, set style and set the focus events. */
  170. $('#' + errorLabel).remove();
  171. var isInputGroup = $(errorOBJ).closest('.input-group').size();
  172. var $showOBJ = isInputGroup ? $(errorOBJ).closest('.input-group').parent() : $(errorOBJ).parent();
  173. $showOBJ.append(errorMSG);
  174. $(errorOBJ).css('margin-bottom', 0);
  175. $(errorOBJ).css('border-color','#D2322D');
  176. if($(errorOBJ + '_chosen').size() > 0)
  177. {
  178. $(errorOBJ + '_chosen .chosen-single').css('border-color','#D2322D');
  179. $(errorOBJ + '_chosen').bind('keydown mousedown', function()
  180. {
  181. if(!triggered[i])
  182. {
  183. $(this).removeAttr('style');
  184. $('#' + errorLabel).remove();
  185. triggered[i] = true;
  186. }
  187. });
  188. }
  189. $(errorOBJ).bind('keydown mousedown', function()
  190. {
  191. if(!triggered[i])
  192. {
  193. $(this).removeAttr('style');
  194. $('#' + errorLabel).remove();
  195. triggered[i] = true;
  196. }
  197. });
  198. if(i == 1)$(errorOBJ).focus();
  199. })
  200. }
  201. }
  202. });
  203. }
  204. /**
  205. * Finish current step and check.
  206. *
  207. * @param int step
  208. * @access public
  209. * @return void
  210. */
  211. function finishStep(step, nextStep, callback)
  212. {
  213. if(step == 1)
  214. {
  215. var check = checkStep1();
  216. if(!check) return false;
  217. /* Update sql query values */
  218. getFieldSettings();
  219. var newSql = $('#sql').val().replace(';', "").trim();
  220. var hasSettings = checkSettings();
  221. var chart = DataStorage.clone('chart');
  222. /* Fix bug #32348. */
  223. chart.sqlChange = chart.sql.length > 0 && newSql !== chart.sql;
  224. if(chart.sqlChange && hasSettings)
  225. {
  226. bootbox.confirm(resetSettingsLang, function(res)
  227. {
  228. if(res)
  229. {
  230. /* Remove step active. */
  231. $('#step1').nextAll('.step-tab').removeClass('active');
  232. /* Set chart refreshTab for function getFinish. */
  233. chart.refreshTab = true;
  234. chart.stage = 'draft';
  235. /* Init chart design settings */
  236. chart.settings = [{type: 'pie'}];
  237. /* Init filter settings */
  238. chart.filters = [];
  239. loadConfigForm('pie', true);
  240. buildSettingForm(true);
  241. chart.sql = newSql;
  242. chart.fields = Object.keys(fields);
  243. chart.fieldSettings = fieldSettings;
  244. DataStorage.chart = chart;
  245. if(callback instanceof Function) callback(2);
  246. }
  247. });
  248. return false;
  249. }
  250. chart.sql = newSql;
  251. chart.fields = Object.keys(fields);
  252. chart.fieldSettings = fieldSettings;
  253. DataStorage.chart = chart;
  254. }
  255. if(step == 2)
  256. {
  257. var check = checkStep2();
  258. if(!check) return false;
  259. }
  260. if(callback instanceof Function) callback(nextStep);
  261. }
  262. /**
  263. * Load chart config form.
  264. *
  265. * @param string type
  266. * @access public
  267. * @return void
  268. */
  269. function loadConfigForm(type, update = false)
  270. {
  271. if(echart) echart.clear();
  272. var chart = DataStorage.clone('chart');
  273. chart.type = type;
  274. chart.settings = [{type: type}];
  275. DataStorage.chart = chart;
  276. if(update) $('select#type').data('zui.picker').setValue(type);
  277. /* Show current html form. */
  278. buildSettingForm(true, function()
  279. {
  280. if(validate()) ajaxGetChart();
  281. });
  282. }
  283. /**
  284. * Listen pie config form change.
  285. *
  286. * @param string value
  287. * @param string field
  288. * @param bool required
  289. * @access public
  290. * @return void
  291. */
  292. function pieChange(value, field, required = false, multi = 0)
  293. {
  294. if(multi)
  295. {
  296. refreshMulti(this);
  297. }
  298. else
  299. {
  300. var chart = DataStorage.clone('chart');
  301. /* Pie have group and metirc, others have xaxis. */
  302. var isEmpty = value == '';
  303. if(field == 'group' || field == 'xaxis')
  304. {
  305. var fieldName = isEmpty ? '' : DataStorage.fieldSettings[value].name;
  306. var fieldType = isEmpty ? '' : DataStorage.fieldSettings[value].type;
  307. var dateClass = fieldType == 'date' ? '' : 'hidden';
  308. $('#dateGroup').removeClass();
  309. $('#dateGroup').addClass(dateClass);
  310. clearRadioChecked();
  311. chart.settings[0][field] = [{field: value, name: fieldName, group: ''}];
  312. }
  313. else if(field == 'metric')
  314. {
  315. var agg = $('#valOrAgg').val();
  316. var fieldName = isEmpty ? '' : DataStorage.fieldSettings[value].name;
  317. chart.settings[0][field] = [{field: value, name: fieldName, valOrAgg: agg}];
  318. }
  319. else if(field == 'dateGroup')
  320. {
  321. var type = chart.settings[0].type;
  322. var field = type == 'pie' ? 'group' : 'xaxis';
  323. chart.settings[0][field][0].group = value;
  324. }
  325. else if(field == 'valOrAgg')
  326. {
  327. var field = $('#metric').val();
  328. var fieldName = DataStorage.fieldSettings[field].name;
  329. chart.settings[0]['metric'] = [{field: field, name: fieldName, valOrAgg: value}];
  330. }
  331. else if(field == 'rotateX' || field == 'rotateY')
  332. {
  333. var isChecked = $('input#' + field + '0')[0].checked;
  334. chart.settings[0][field] = isChecked ? 'use' : 'notuse';
  335. }
  336. DataStorage.chart = chart;
  337. }
  338. refreshChart();
  339. }
  340. /**
  341. * Build setting form.
  342. *
  343. * @access public
  344. * @return void
  345. */
  346. function buildSettingForm(dropOld = false, callback = '')
  347. {
  348. var chart = DataStorage.chart;
  349. var fieldSettings = DataStorage.fieldSettings;
  350. var langs = DataStorage.langs;
  351. var type = chart.settings[0].type;
  352. var $form = $('#chartForm');
  353. if(dropOld)
  354. {
  355. $form.empty();
  356. var fieldNames = {};
  357. Object.keys(fieldSettings).forEach(function(key){fieldNames[key] = fieldSettings[key].name});
  358. $.post(createLink('chart', 'ajaxGetTypeForm', 'id=' + chart.id + '&type=' + type),
  359. {
  360. fields: fieldNames,
  361. values: chart.settings[0],
  362. fieldSettings: fieldSettings,
  363. langs: langs,
  364. sql: window.latin1ToBase64(chart.sql)
  365. }, function(data)
  366. {
  367. $form.html($(data));
  368. initPicker($form);
  369. var type = chart.settings[0].type;
  370. if(type == 'waterpolo') $('.denominator-tip').popover();
  371. if(['line', 'cluBarX', 'cluBarY', 'stackedBar', 'stackedBarY'].includes(type)) $('.rotate-tip').popover();
  372. if(callback instanceof Function) callback();
  373. });
  374. }
  375. }
  376. /**
  377. * Add row.
  378. *
  379. * @param obj $obj
  380. * @param field $field
  381. * @access public
  382. * @return void
  383. */
  384. function addRow(obj, field)
  385. {
  386. var chart = DataStorage.chart;
  387. var type = chart.settings[0].type;
  388. var tplName = '#' + type + 'Column';
  389. var row = $(tplName).html();
  390. $('<tr class="addedRow">' + row + '</tr>').insertAfter($(obj).closest('tr'));
  391. var butClass = '.del-' + field;
  392. var delCount = $(obj).parents('tbody').find('.del-' + field).length;
  393. if(delCount == 2) $(obj).parents('tbody').find('.del-' + field).eq(0).removeClass('hidden');
  394. var $row = $(obj).closest('tr').next();
  395. initPicker($row, 'hidden-picker-select');
  396. }
  397. /**
  398. * Delete row.
  399. *
  400. * @param obj $obj
  401. * @param field $field
  402. * @access public
  403. * @return void
  404. */
  405. function deleteRow(obj, field)
  406. {
  407. var chart = DataStorage.chart;
  408. var type = chart.settings[0].type;
  409. var buttons = $('#chartForm .table-form .del-' + field);
  410. var delCount = buttons.length;
  411. var th = buttons.eq(0).parents('tr').find('th').text();
  412. $(obj).closest('tr').remove();
  413. if(delCount === 2) $('#chartForm .del-' + field).eq(0).addClass('hidden');
  414. $('#chartForm .del-' + field).eq(0).parents('tr').find('th').text(th);
  415. var isReady = validate();
  416. refreshMulti();
  417. refreshChart();
  418. }
  419. /**
  420. * Refresh multi form values.
  421. *
  422. * @access public
  423. * @return void
  424. */
  425. function refreshMulti()
  426. {
  427. var chart = DataStorage.clone('chart');
  428. var fieldSettings = DataStorage.fieldSettings;
  429. var type = chart.settings[0].type;
  430. var chartSetting = chartSettings[type];
  431. var multiColumn = multiColumns[type];
  432. var multiSettings = chartSetting[multiColumn];
  433. var fields = multiSettings.map(function(item){return item.field});
  434. var settingInfo = {};
  435. fields.forEach(function(field)
  436. {
  437. settingInfo[field] = [];
  438. $('#chartForm .table-form').find('.multi-' + field).each(function()
  439. {
  440. settingInfo[field].push($(this).val());
  441. });
  442. });
  443. /* Set chart.settings[0]['yaxis']. */
  444. var yaxisSetting = [];
  445. for(var index = 0; index < settingInfo.yaxis.length; index ++)
  446. {
  447. var yaxis = settingInfo.yaxis[index];
  448. if(yaxis.length == 0) continue;
  449. var fieldName = fieldSettings[yaxis].name;
  450. var valOrAgg = settingInfo.valOrAgg[index];
  451. yaxisSetting.push({field: yaxis, name: fieldName, valOrAgg: valOrAgg});
  452. }
  453. chart.settings[0]['yaxis'] = yaxisSetting;
  454. DataStorage.chart = chart;
  455. }
  456. /**
  457. * Refresh chart draw.
  458. *
  459. * @access public
  460. * @return void
  461. */
  462. function refreshChart()
  463. {
  464. var isReady = validate();
  465. if(isReady)
  466. {
  467. ajaxGetChart();
  468. }
  469. else
  470. {
  471. echart.clear();
  472. }
  473. }
  474. /**
  475. * Get current finish step stage.
  476. *
  477. * @access public
  478. * @return int
  479. */
  480. function getFinish()
  481. {
  482. var chart = DataStorage.clone('chart');
  483. if('refreshTab' in chart)
  484. {
  485. delete chart.refreshTab;
  486. DataStorage.chart = chart;
  487. return 1;
  488. }
  489. if(chart.stage == 'published' || chart.stage == 4) return 4;
  490. if(checkStep2(false)) return 2;
  491. if(checkStep1(false)) return 1;
  492. return 0;
  493. }
  494. function checkSettings()
  495. {
  496. var chart = DataStorage.chart;
  497. var type = chart.settings[0].type;
  498. var chartSetting = chartSettings[type];
  499. for(var key in chartSetting)
  500. {
  501. var exist = chartSetting[key].find(function(field)
  502. {
  503. return field.required && chart.settings[0][field.field];
  504. });
  505. if(exist) return true;
  506. }
  507. return false;
  508. }
  509. /**
  510. * Check step 1 is finished.
  511. *
  512. * @param bool page
  513. * @access public
  514. * @return bool
  515. */
  516. function checkStep1(page = true)
  517. {
  518. var chart = DataStorage.chart;
  519. if(!page)
  520. {
  521. var sql = chart.sql;
  522. var fields = DataStorage.fields;
  523. var fieldSettings = DataStorage.fieldSettings;
  524. return sql && fieldSettings && fields && sql.length > 0 && Object.keys(fieldSettings).length > 0 && Object.keys(fields). length > 0;
  525. }
  526. $.ajaxSettings.async = false;
  527. query();
  528. $.ajaxSettings.async = true;
  529. return $('#dataform .error').length == $('#dataform .error.hidden').length;
  530. }
  531. /**
  532. * Check step 2 is finished.
  533. *
  534. * @param bool page
  535. * @access public
  536. * @return bool
  537. */
  538. function checkStep2(page = true)
  539. {
  540. if(!page)
  541. {
  542. var settings = DataStorage.chart.settings;
  543. return settings instanceof Array && settings.length > 0 && validate();
  544. }
  545. return validate(true);
  546. }
  547. function switchStep(step)
  548. {
  549. setStepActive(step);
  550. setStepEnable(step);
  551. buildSettingForm(true, initStep(step));
  552. }
  553. function initStep(step)
  554. {
  555. if(step == 1) return;
  556. if(echart) echart.dispose();
  557. var echartDom = $('#step' + step + 'Content').find('#draw').get(0);
  558. echart = echarts.init(echartDom);
  559. noDataDom = $('#step' + step + 'Content').find('#draw-no-data');
  560. if(validate()) ajaxGetChart();
  561. if(step == 2 || step == 3 || step == 4) renderFilters(step);
  562. }
  563. /**
  564. * Set step tab label active.
  565. *
  566. * @param int step
  567. * @access public
  568. * @return void
  569. */
  570. function setStepActive(step)
  571. {
  572. /* Remove old class and Add new active class. */
  573. //$('.step-tab').removeClass('active current');
  574. $('.step-tab').removeClass('current');
  575. $('#step' + step).addClass('active current');
  576. $('#step' + step).prevAll('.step-tab').addClass('active');
  577. $('.step-content').hide();
  578. $('#step' + step + 'Content').show();
  579. }
  580. /**
  581. * Set step tab label enable.
  582. *
  583. * @access public
  584. * @return void
  585. */
  586. function setStepEnable(step)
  587. {
  588. var stus = [];
  589. var finish = getFinish();
  590. if(finish == 0) stus = [1, 1, 0, 0];
  591. if(finish == 1 && step == 1) stus = [1, 1, 0, 0];
  592. if(finish == 1 && step == 2) stus = [1, 1, 1, 0];
  593. if(finish == 2 || finish == 4) stus = [1, 1, 1, 1];
  594. $('.step-tab').removeClass('disabled');
  595. $('.step-tab').removeClass('clickable');
  596. stus.forEach(function(value, step)
  597. {
  598. var disable = value == 1 ? '' : 'disabled';
  599. $('#step' + (step + 1)).addClass(disable);
  600. /* If step haven't active and disabled, means it hasn't be clicked to set active, but it's clickable now. */
  601. if(!$('#step' + (step + 1)).hasClass('active') && !$('#step' + (step + 1)).hasClass('disabled')) $('#step' + (step + 1)).addClass('clickable')
  602. });
  603. }
  604. function clearRadioChecked()
  605. {
  606. $("#dateGroupday").prop('checked', false);
  607. $("#dateGroupdweek").prop('checked', false);
  608. $("#dateGroupmonth").prop('checked', false);
  609. $("#dateGroupyear").prop('checked', false);
  610. }
  611. function toggleRadioSelection(obj, value)
  612. {
  613. var radio1 = $("#dateGroupday");
  614. var radio2 = $("#dateGroupweek");
  615. var radio3 = $("#dateGroupmonth");
  616. var radio4 = $("#dateGroupyear");
  617. var clickedRadio = $('#' + $(obj).attr('id'));
  618. if(clickedRadio.hasClass('checked'))
  619. {
  620. clickedRadio.prop('checked', false);
  621. clickedRadio.removeClass('checked');
  622. }
  623. else
  624. {
  625. clearRadioChecked();
  626. radio1.removeClass('checked');
  627. radio2.removeClass('checked');
  628. radio3.removeClass('checked');
  629. radio4.removeClass('checked');
  630. clickedRadio.prop('checked', true);
  631. clickedRadio.addClass('checked');
  632. }
  633. var sendValue = clickedRadio.hasClass('checked') ? value : '';
  634. pieChange(sendValue, 'dateGroup');
  635. }