ded39c83acc8d825fade0e515f32e09927da2cd4.svn-base 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132
  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 multiple
  17. collapse-tags placeholder="督查状态">
  18. <el-option label="未督查" value="0"></el-option>
  19. <el-option label="督查中" value="1"></el-option>
  20. <el-option label="已督查" value="2"></el-option>
  21. </el-select>
  22. <el-button type="primary" icon="el-icon-download"
  23. style="float: right;margin:0 5px"
  24. @click="exportExecl">导出</el-button>
  25. <el-button type="primary" icon="el-icon-search" style="float: right;margin:0 5px" @click="searchExecl">查询</el-button>
  26. </div>
  27. </el-card>
  28. <el-card :body-style="{'height':dxdcMainHeight + 'px','padding':'0'}">
  29. <form ref="formMain3" id="formMain3" target="frameMain3" :action="reportSrc" method="post">
  30. <input type="hidden" name="width" v-model="windowWidth">
  31. <input type="hidden" name="height" v-model="windowHeight">
  32. <input type="hidden" name="ids" v-model="ids">
  33. <input type="hidden" name="excelName" v-model="excelName">
  34. <input type="hidden" id="sttm" name="sttm" v-model="sttm">
  35. <input type="hidden" id="ettm" name="ettm" v-model="ettm">
  36. <input type="hidden" name="state" v-model="dcType.join(',')">
  37. <input type="hidden" name="year" v-model="newYear">
  38. </form>
  39. <div style="width: 100%;height: 100%;" v-loading="loading">
  40. <iframe ref="frameMain3" id="frameMain3" name="frameMain3" src="" frameborder="0" width="100%" height="100%" style="overflow: auto"></iframe>
  41. </div>
  42. </el-card>
  43. </el-col>
  44. </el-row>
  45. </template>
  46. <script>
  47. import {dateFormat,getFirstDayOfMonth} from '../../utils/gw_date.js';
  48. export default {
  49. components: {
  50. // exportTreeListWithCheckBoxSk:exportTreeListWithCheckBoxSk,
  51. },
  52. props: ['ids','newYear'],
  53. data() {
  54. return {
  55. // ids:[],
  56. pid:'000',
  57. pidNodes:[],
  58. type:'001',
  59. dxdcMainHeight: window.innerHeight-215,
  60. dxdcAsideHeight: window.innerHeight-180,
  61. windowHeight:window.innerHeight - 160,
  62. windowWidth:window.innerWidth - 350,
  63. reportSrc:'/demo/reportJsp/showReport.jsp?rpx=dc_ry_20year_04.rpx&scroll=yes',
  64. radioTable:1,
  65. loading:false,
  66. leftCol:4,
  67. rightCol:20,
  68. excelName:'农村供水工程水费收缴及水质保障情况表',
  69. findTime: [getFirstDayOfMonth(new Date(), 'yyyy-MM-dd'), dateFormat(new Date(), 'yyyy-MM-dd')],
  70. sttm: getFirstDayOfMonth(new Date(), 'yyyy-MM-dd'),
  71. ettm: dateFormat(new Date(), 'yyyy-MM-dd'),
  72. treeWidth: 250,
  73. dcType: ['0','1','2'],
  74. }
  75. },
  76. computed: {
  77. userId: function () {
  78. return localStorage.getItem("userid")
  79. ? localStorage.getItem("userid")
  80. : "1098101939614724096";
  81. }
  82. },
  83. methods: {
  84. // 获取Excel数据
  85. searchExecl(){
  86. this.loading = true;
  87. // 使用form表单post提交,彻底解决参数值过长的问题
  88. this.$refs.formMain3.submit();
  89. // 使用_this
  90. let _this = this;
  91. this.$refs.frameMain3.onload = function(){
  92. _this.loading = false;
  93. };
  94. },
  95. // 导出Excel数据
  96. exportExecl(){
  97. v = window.frames["frameMain3"];
  98. // v.contentWindow.report1_saveAsExcel();
  99. v.report1_saveAsExcel();
  100. },
  101. },
  102. watch:{
  103. findTime(n,o){
  104. if(!n){
  105. this.sttm = "";
  106. this.ettm = "";
  107. }else{
  108. this.sttm = n[0];
  109. this.ettm = n[1];
  110. }
  111. }
  112. },
  113. activated() {
  114. this.searchExecl();
  115. }
  116. }
  117. </script>
  118. <style scoped>
  119. </style>