9347108909441d65c2b5c06ce18beb63c1908cfe.svn-base 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128
  1. <template>
  2. <el-row>
  3. <el-col :span="24">
  4. <el-card :body-style="{'padding-top':'10px'}">
  5. <div class="block">
  6. <span class="demonstration" style="margin-right: 5px">选择时间段</span>
  7. <el-date-picker
  8. v-model="findTime"
  9. type="daterange"
  10. value-format="yyyy-MM-dd"
  11. range-separator="至"
  12. start-placeholder="开始日期"
  13. end-placeholder="结束日期">
  14. </el-date-picker>
  15. <span class="demonstration" style="margin-right: 5px;margin-left: 7px">督查状态</span>
  16. <el-select v-model="dcType" clearable placeholder="督查状态">
  17. <el-option label="未督查" value="0"/>
  18. <el-option label="督查中" value="1"/>
  19. <el-option label="已督查" value="2"/>
  20. </el-select>
  21. <el-button type="primary" icon="el-icon-download"
  22. style="float: right;margin:0 5px"
  23. @click="exportExecl">导出
  24. </el-button>
  25. <el-button type="primary" icon="el-icon-search" style="float: right;margin:0 5px" @click="searchExecl">查询
  26. </el-button>
  27. </div>
  28. </el-card>
  29. <el-card :body-style="{'height':dxdcMainHeight + 'px','padding':'0'}">
  30. <form ref="formMain5" id="formMain5" target="frameMain5" :action="reportSrc" method="post">
  31. <input type="hidden" name="width" v-model="windowWidth">
  32. <input type="hidden" name="height" v-model="windowHeight">
  33. <input type="hidden" name="ids" v-model="ids">
  34. <input type="hidden" name="excelName" v-model="excelName">
  35. <input type="hidden" id="sttm" name="sttm" v-model="sttm">
  36. <input type="hidden" id="ettm" name="ettm" v-model="ettm">
  37. <input type="hidden" name="state" v-model="dcType">
  38. <input type="hidden" name="year" v-model="newYear">
  39. </form>
  40. <div style="width: 100%;height: 100%;" v-loading="loading">
  41. <iframe ref="frameMain5" id="frameMain5" name="frameMain5" src="" frameborder="0" width="100%" height="100%"
  42. style="overflow: auto"></iframe>
  43. </div>
  44. </el-card>
  45. </el-col>
  46. </el-row>
  47. </template>
  48. <script>
  49. import {dateFormat, getFirstDayOfMonth} from '@util/gw_date.js';
  50. export default {
  51. props: ['ids', 'newYear'],
  52. data() {
  53. return {
  54. pid: '000',
  55. pidNodes: [],
  56. type: '001',
  57. dxdcMainHeight: window.innerHeight - 200,
  58. dxdcAsideHeight: window.innerHeight - 180,
  59. windowHeight: window.innerHeight - 200,
  60. windowWidth: window.innerWidth - 350,
  61. reportSrc: '/demo/reportJsp/showReport.jsp?rpx=/033.节约用水/dc_033jyys_08.rpx',
  62. radioTable: 1,
  63. loading: true,
  64. leftCol: 4,
  65. rightCol: 20,
  66. excelName: '附件8 2020年水资源管理和节约用水监督检查工作情况统计表',
  67. findTime: [getFirstDayOfMonth(new Date(), 'yyyy-MM-dd'), dateFormat(new Date(), 'yyyy-MM-dd')],
  68. sttm: getFirstDayOfMonth(new Date(), 'yyyy-MM-dd'),
  69. ettm: dateFormat(new Date(), 'yyyy-MM-dd'),
  70. treeWidth: 250,
  71. dcType: '0',
  72. }
  73. },
  74. computed: {
  75. userId: function () {
  76. return localStorage.getItem("userid")
  77. ? localStorage.getItem("userid")
  78. : "1098101939614724096";
  79. }
  80. },
  81. methods: {
  82. // 获取Excel数据
  83. searchExecl() {
  84. this.loading = true;
  85. // 使用form表单post提交,彻底解决参数值过长的问题
  86. this.$refs.formMain5.submit();
  87. // 使用_this
  88. let _this = this;
  89. this.$refs.frameMain5.onload = function () {
  90. _this.loading = false;
  91. };
  92. },
  93. // 导出Excel数据
  94. exportExecl() {
  95. v = window.frames["frameMain5"];
  96. // v.contentWindow.report1_saveAsExcel();
  97. v.report1_saveAsExcel();
  98. },
  99. },
  100. watch: {
  101. findTime(n, o) {
  102. if (!n) {
  103. this.sttm = "";
  104. this.ettm = "";
  105. } else {
  106. this.sttm = n[0];
  107. this.ettm = n[1];
  108. }
  109. }
  110. },
  111. activated() {
  112. this.searchExecl();
  113. }
  114. }
  115. </script>
  116. <style scoped>
  117. </style>