se_other.js 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. 'use strict';
  2. /**
  3. * 期 - 其他
  4. *
  5. * @author Mai
  6. * @date 2020/2/12
  7. * @version
  8. */
  9. const mainSpreadSetting = {
  10. cols: [
  11. {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 185, formatter: '@'},
  12. {title: '金额', colSpan: '1', rowSpan: '1', field: 'e_type', hAlign: 1, width: 80, formatter: '@'},
  13. {title: '本期金额', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 100, type: 'Number'},
  14. {title: '截止本期金额', colSpan: '1', rowSpan: '1', field: 'total_price', hAlign: 2, width: 100, type: 'Number', readOnly: true},
  15. {title: '时间', colSpan: '1', rowSpan: '1', field: 'total_price', hAlign: 2, width: 100, type: 'Number'},
  16. {title: '备注', colSpan: '1', rowSpan: '1', field: 'memo', hAlign: 0, width: 150, formatter: '@', cellType: 'ellipsisAutoTip'}
  17. ],
  18. emptyRows: 3,
  19. headRows: 1,
  20. headRowHeight: [32],
  21. defaultRowHeight: 21,
  22. headerFont: '12px 微软雅黑',
  23. font: '12px 微软雅黑',
  24. };
  25. const subSpreadSetting = {
  26. cols: [
  27. {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 185, formatter: '@'},
  28. {title: '金额', colSpan: '1', rowSpan: '1', field: 'e_type', hAlign: 1, width: 80, formatter: '@'},
  29. {title: '本期金额', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 100, type: 'Number'},
  30. {title: '截止本期金额', colSpan: '1', rowSpan: '1', field: 'total_price', hAlign: 2, width: 100, type: 'Number', readOnly: true},
  31. {title: '时间', colSpan: '1', rowSpan: '1', field: 'total_price', hAlign: 2, width: 100, type: 'Number'},
  32. {title: '备注', colSpan: '1', rowSpan: '1', field: 'memo', hAlign: 0, width: 150, formatter: '@', cellType: 'ellipsisAutoTip'}
  33. ],
  34. emptyRows: 3,
  35. headRows: 1,
  36. headRowHeight: [32],
  37. defaultRowHeight: 21,
  38. headerFont: '12px 微软雅黑',
  39. font: '12px 微软雅黑',
  40. };
  41. $(document).ready(() => {
  42. autoFlashHeight();
  43. const mainSpread = SpreadJsObj.createNewSpread($('#main-spread')[0]);
  44. const mainSheet = mainSpread.getActiveSheet();
  45. SpreadJsObj.initSheet(mainSheet, mainSpreadSetting);
  46. const subSpread = SpreadJsObj.createNewSpread($('#sub-spread')[0]);
  47. const subSheet = subSpread.getActiveSheet();
  48. SpreadJsObj.initSheet(subSheet, subSpreadSetting);
  49. $.subMenu({
  50. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  51. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  52. key: 'menu.1.0.0',
  53. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  54. callback: function (info) {
  55. if (info.mini) {
  56. $('.panel-title').addClass('fluid');
  57. $('#sub-menu').removeClass('panel-sidebar');
  58. } else {
  59. $('.panel-title').removeClass('fluid');
  60. $('#sub-menu').addClass('panel-sidebar');
  61. }
  62. autoFlashHeight();
  63. mainSpread.refresh();
  64. subSpread.refresh();
  65. }
  66. });
  67. // 上下窗口resizer
  68. $.divResizer({
  69. select: '#main-resize',
  70. callback: function () {
  71. mainSpread.refresh();
  72. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  73. $(".sp-wrap").height(bcontent-30);
  74. subSpread.refresh();
  75. }
  76. });
  77. });