<template lang="html">
  <div class="span " id="table1">
    <p class="bg-info text-center " style="padding: 8px;">失联分析汇总</p>
    <div class="mystyle2 " >
      <label class="control-label">汇总项</label>
      <input type="checkbox" id="u.f_user_type" value="u.f_user_type"  v-model="nameForSql"/>
      <label for="u.f_user_type">用户类型</label>
      <input type="checkbox" id="u.f_gasproperties" value="u.f_gasproperties" v-model="nameForSql"/>
      <label for="u.f_gasproperties">用气性质</label>
      <input type="checkbox" id="uf.f_orgname" value="uf.f_orgname" v-model="nameForSql"/>
      <label for="uf.f_orgname">组织机构</label>

      <span style="float: right">
        <button class="button_search button_spacing" @click="searchData">查询</button>
        <button @click="$parent.notShowTotalForm()" class="button_clear button_spacing" style="width: max-content">隐藏汇总</button>
       <export-excel :data="getCondition" class="button_export button_spacing"
                     :field="getfield"
                     sqlurl="rs/logic/exportfile" sql-name="webmeter_getNewLoseGroup" template-name='失联分析汇总'
                     :choose-col="true"></export-excel>
        <report-print class="button_export button_spacing" style="width: max-content" id="table1" top='3cm' left='0' width='100%' height='100%'></report-print></span>
    </div>
    <table  class="table table-bordered padding-top: 10px;">
      <thead class="text-left">
      <tr>
        <th v-if="nameForSql.includes('u.f_user_type')" style="text-align:center">用户类型</th>
        <th v-if="nameForSql.includes('u.f_gasproperties')" style="text-align:center">用气性质</th>
        <th v-if="nameForSql.includes('uf.f_orgname')" style="text-align:center">组织机构</th>
        <th style="text-align:center"><nobr>5天之内</nobr></th>
        <th style="text-align:center"><nobr>5天到7天</nobr></th>
        <th style="text-align:center"><nobr>7天到15天</nobr></th>
        <th style="text-align:center"><nobr>15天到30天</nobr></th>
        <th style="text-align:center"><nobr>30天到60天</nobr></th>
        <th style="text-align:center"><nobr>60天以上</nobr></th>
        <th style="text-align:center"><nobr>未上报</nobr></th>
      </tr></thead>
      <tbody>
      <tr v-for="item in model2">

        <td style="text-align:center" v-if="nameForSql.includes('u.f_user_type')">{{item.f_user_type}}</td>
        <td style="text-align:center" v-if="nameForSql.includes('u.f_gasproperties')">{{item.f_gasproperties}}</td>
        <td style="text-align:center" v-if="nameForSql.includes('uf.f_orgname')">{{item.f_orgname}}</td>
        <td style="text-align:center">{{item._five}}</td>
        <td style="text-align:center">{{item.five_seven}}</td>
        <td style="text-align:center">{{item.seven_fifteen}}</td>
        <td style="text-align:center">{{item.fifteen_thirty}}</td>
        <td style="text-align:center">{{item.thirty_sixty}}</td>
        <td style="text-align:center">{{item.sixty_}}</td>
        <th style="text-align:center"><nobr>{{item._one}}</nobr></th>
      </tr>
      </tbody>
    </table>
  </div>
</template>

<script>
  import {PagedList} from 'vue-client'
  import * as Util from '../../../Util'
  import { all, HttpResetClass } from 'vue-client'

  export default {
    props:{
      condition:'1=1',
      startdate: {
        type: String,
        default: Util.toStandardDateString()
      },
      enddate: {
        type: String,
        default: Util.toStandardDateString()
      },
      // condition: {
      //   type: String,
      //   default: '1=1'
      // },
      // groupNameByDate: {
      //   type: [],
      //   default:['year']
      // }
    },
    data(){
      return{
        enddate:'',
        startdate:'',
        model2:null,
        conditionForSql: '1=1',
        nameForSql:[],
        groupNameForSql :''
        // exportfield:{"u.f_user_type":"客户类型","u.f_gasproperties":"用气性质","u.f_orgname":"组织机构"}
      }
    },
    ready (){
      this.nameForSql=['u.f_user_type']
      this.groupNameForSql= 'u.f_user_type'
      this.searchData()
    },
    methods :{
      async searchData(){
        if(this.groupNameForSql&& this.groupNameForSql !== 'undefined') {
          let load = new HttpResetClass()
          let res = await load.load('POST', 'rs/sql/webmeter_getNewLoseGroup',
            {data: {condition: this.condition, groupname: this.groupNameForSql,startDate:`to_Date('${this.startdate}','yyyy-mm-dd hh24:mi:ss')`,endDate:`to_Date('${this.enddate}','yyyy-mm-dd hh24:mi:ss')`}},
            {resolveMsg: null, rejectMsg: null})
          console.log('res返回', res)
          this.model2 = res.data
          console.log('res返回123', this.model2)
        }else{
          this.$showAlert('请选择汇总项', 'warning', 3000)
        }
      },
      //拼接groupName1
      getGroupName1(){
        console.log("this.nameForSql.length："+this.nameForSql.length)
        let str= ''
        let i=0
        for(;i<this.nameForSql.length-1;i++){
          str +=this.nameForSql[i]+','
        }
        str +=this.nameForSql[i]
        this.groupNameForSql =str.trim()
      }


    },
    computed: {
      getfield(){
        var fields={}
        let i = 0
        for (; i < this.nameForSql.length; i++) {
          if(this.nameForSql[i] ==='u.f_user_type' ){
            fields.f_user_type="客户类型"
          }else if(this.nameForSql[i] ==='u.f_gasproperties'){
            fields.f_gasproperties="用气性质"
          }else if(this.nameForSql[i] ==='uf.f_orgname'){
            fields.f_orgname="组织机构"
          }
        }
        fields._five="5天之内"
        fields.five_seven="5天到7天"
        fields.seven_fifteen="7天到15天"
        fields.fifteen_thirty="15天到30天"
        fields.thirty_sixty="30天到60天"
        fields.sixty_="60天以上"
        fields._one="未上报"
        return fields
      },
      getCondition() {
        return {
          condition: this.conditionForSql,
          groupname: this.groupNameForSql,
          startDate:this.startdate,
          endDate:this.enddate

        }
      }
    },
    watch:{
      'nameForSql'(){
        // this.nameForSql =this.groupNameByDate;
        this.getGroupName1()
      },
      'startdate'(val){
        this.startdate=val
      },
      'enddate'(val){
        this.enddate=val
      },
      'condition'(val){
        this.conditionForSql = val
      }
    }
  }
</script>

<style scoped>
  .mystyle2{
    width: 100%;
    height: 35px;
    /*background: #00A3F0;*/
    padding-left: 15px;
    float: left;
  }
  .datapanel {
    color: #333;
    background-color: white;
    box-shadow: darkgrey 0.5px 0.5px 0.5px 0.5px ;
    padding: 10px 30px 10px 30px;
    border-radius:15px;
  }

</style>
