5d8347bf67e0d24334c36ac2ab1aa253d8ee2326.svn-base 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147
  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"></el-option>
  18. <el-option label="督查中" value="1"></el-option>
  19. <el-option label="已督查" value="2"></el-option>
  20. </el-select>
  21. <span class="demonstration" style="margin-right: 5px;margin-left: 7px">问题时间筛选</span>
  22. <el-date-picker
  23. v-model="findTimeWt"
  24. type="daterange"
  25. value-format="yyyy-MM-dd"
  26. range-separator="至"
  27. start-placeholder="开始日期"
  28. end-placeholder="结束日期">
  29. </el-date-picker>
  30. <el-button type="primary" icon="el-icon-download"
  31. style="float: right;margin:0 5px"
  32. @click="exportExecl">导出</el-button>
  33. <el-button type="primary" icon="el-icon-search" style="float: right;margin:0 5px" @click="searchExecl">查询</el-button>
  34. </div>
  35. </el-card>
  36. <el-card :body-style="{'height':dxdcMainHeight + 'px','padding':'0'}">
  37. <form ref="formMain6" id="formMain6" target="frameMain6" :action="reportSrc" method="post">
  38. <input type="hidden" name="width" v-model="windowWidth">
  39. <input type="hidden" name="height" v-model="windowHeight">
  40. <input type="hidden" name="ids" v-model="ids">
  41. <input type="hidden" name="excelName" v-model="excelName">
  42. <input type="hidden" id="sttm" name="sttm" v-model="sttm">
  43. <input type="hidden" id="ettm" name="ettm" v-model="ettm">
  44. <input type="hidden" id="pblm_sttm" name="pblm_sttm" v-model="pblm_sttm">
  45. <input type="hidden" id="pblm_ettm" name="pblm_ettm" v-model="pblm_ettm">
  46. <input type="hidden" name="state" v-model="dcType">
  47. <input type="hidden" name="year" v-model="newYear">
  48. </form>
  49. <div style="width: 100%;height: 100%;" v-loading="loading">
  50. <iframe ref="frameMain6" id="frameMain6" name="frameMain6" src="" frameborder="0" width="100%" height="100%" style="overflow: auto"></iframe>
  51. </div>
  52. </el-card>
  53. </el-col>
  54. </el-row>
  55. </template>
  56. <script>
  57. import {dateFormat,getFirstDayOfMonth} from '@util/gw_date.js';
  58. export default {
  59. props: ['ids','newYear'],
  60. data() {
  61. return {
  62. pid:'000',
  63. pidNodes:[],
  64. type:'001',
  65. dxdcMainHeight: window.innerHeight-200,
  66. dxdcAsideHeight: window.innerHeight-180,
  67. windowHeight:window.innerHeight - 200,
  68. windowWidth:window.innerWidth - 350,
  69. reportSrc:'/demo/reportJsp/showReport.jsp?rpx=dc_037ncysaqhtk_05.rpx',
  70. radioTable:1,
  71. loading:true,
  72. leftCol:4,
  73. rightCol:20,
  74. excelName:'附件5 农村供水工程问题清单 ',
  75. findTime: [getFirstDayOfMonth(new Date(), 'yyyy-MM-dd'), dateFormat(new Date(), 'yyyy-MM-dd')],
  76. findTimeWt: [],
  77. sttm: getFirstDayOfMonth(new Date(), 'yyyy-MM-dd'),
  78. ettm: dateFormat(new Date(), 'yyyy-MM-dd'),
  79. treeWidth: 250,
  80. dcType: '0',
  81. pblm_sttm: '',
  82. pblm_ettm: ''
  83. }
  84. },
  85. computed: {
  86. userId: function () {
  87. return localStorage.getItem("userid")
  88. ? localStorage.getItem("userid")
  89. : "1098101939614724096";
  90. }
  91. },
  92. methods: {
  93. // 获取Excel数据
  94. searchExecl(){
  95. this.loading = true;
  96. // 使用form表单post提交,彻底解决参数值过长的问题
  97. this.$refs.formMain6.submit();
  98. // 使用_this
  99. let _this = this;
  100. this.$refs.frameMain6.onload = function(){
  101. _this.loading = false;
  102. };
  103. },
  104. // 导出Excel数据
  105. exportExecl(){
  106. v = window.frames["frameMain6"];
  107. // v.contentWindow.report1_saveAsExcel();
  108. v.report1_saveAsExcel();
  109. },
  110. },
  111. watch:{
  112. findTime(n,o){
  113. if(!n){
  114. this.sttm = "";
  115. this.ettm = "";
  116. }else{
  117. this.sttm = n[0];
  118. this.ettm = n[1];
  119. }
  120. },
  121. findTimeWt(n,o){
  122. if(!n){
  123. this.pblm_sttm = "";
  124. this.pblm_ettm = "";
  125. }else{
  126. this.pblm_sttm = n[0];
  127. this.pblm_ettm = n[1];
  128. }
  129. }
  130. },
  131. activated() {
  132. this.searchExecl();
  133. }
  134. }
  135. </script>
  136. <style scoped>
  137. </style>