<template>
  <div style="flex:1;width: 100%" class="flex" id="meter-read-query">
    <button class="btn btn-xs" v-show="!this.criteriaShow" @click="this.show()">
      <span class="glyphicon glyphicon-chevron-down" style="color: #000;"></span>
    </button>
    <criteria-paged :model="model" v-ref:paged>
      <criteria partial='criteria' @condition-changed='$parent.selfSearch' v-ref:cri v-show="$parent.criteriaShow">
        <div novalidate class="form-horizontal select-overspread container-fluid auto" partial>
          <div class="row">
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">用户编号</label>
              <input  type="text" class="form-control" v-model="model.f_userinfo_code"
                      condition="f_userinfo_code = '{}' " placeholder="用户编号"
                      :size="model.f_userinfo_code ? model.f_userinfo_code.length : 1">
            </div>
<!--            <div class="col-sm-3 form-group form-input-group" style="width: 20%">-->
<!--              <label class="control-label">旧用户编号</label>-->
<!--              <input  type="text" class="form-control" v-model="model.f_olduserinfo_code"-->
<!--                      condition="f_olduserinfo_code like '%{}%' " placeholder="旧用户编号"-->
<!--                      :size="model.f_olduserinfo_code ? model.f_olduserinfo_code.length : 1">-->
<!--            </div>-->
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">用户姓名</label>
              <input  type="text" class="form-control" v-model="model.f_user_name"
                      condition="f_user_name like '%{}%'" placeholder="用户姓名"
                      :size="model.f_user_name ? model.f_user_name.length : 1">
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">用户电话</label>
              <input  type="text" class="form-control" v-model="model.f_user_phone"
                      condition="f_user_phone like '%{}%'" placeholder="用户电话"
                      :size="model.f_user_phone ? model.f_user_phone.length : 1">
            </div>


            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">小区</label>
              <v-select :value.sync="model.f_residential_area"
                        v-model="model.f_residential_area"
                        :options='$parent.$parent.residential_area' placeholder='请选择'
                        condition="f_residential_area like '%{}%'"
                        close-on-select></v-select>
            </div>

            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">用户地址</label>
              <input  type="text" class="form-control" v-model="model.f_address"
                      condition="f_address like '%{}%'" placeholder='用户地址'
                      :size="model.f_address ? model.f_address.length * 2 : 1">
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">用户状态</label>
              <v-select :value.sync="model.f_user_state"
                        v-model="model.f_user_state"
                        :options='$parent.$parent.user_state' placeholder='请选择'
                        condition="f_user_state = '{}'"
                        close-on-select></v-select>
            </div>
            <!--<div class="col-sm-3 form-group form-input-group" style="width: 20%">-->
            <!--<label class="control-label">表编号</label>-->
            <!--<input  type="text" class="form-control" v-model="model.f_user_id"-->
            <!--condition="f_user_id = '{}'" placeholder='表编号'-->
            <!--:size="model.f_user_id ? model.f_user_id.length : 1">-->
            <!--</div>-->
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">欠费状态</label>
              <v-select :value.sync="model.f_hand_state"
                        v-model="model.f_hand_state"
                        :value-single = 'true'
                        :options='$parent.$parent.handstate' placeholder='请选择'
                        condition="f_hand_state = '{}'"
                        close-on-select></v-select>
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">操作人</label>
              <input  type="text" class="form-control" v-model="model.f_operator"
                      condition="f_operator like '%{}%'" placeholder='操作人'>
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">缴费状态</label>
              <v-select :value.sync="model.f_whether_pay"
                        v-model="model.f_whether_pay"
                        :options='$parent.$parent.whetherPay' placeholder='请选择'
                        condition="f_whether_pay = '{}'"
                        close-on-select></v-select>
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">用户类型</label>
              <v-select :value.sync="model.f_user_type"
                        :options='$parent.$parent.usertypes' placeholder='请选择' v-model="model.f_user_type"
                        condition="f_user_type = '{}'"
                        close-on-select></v-select>
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label for="endDate" class="control-label">组织机构</label>
              <right-tree :userid.sync='$parent.$parent.userid' :source.sync='$parent.$parent.source'  @re-res="$parent.$parent.getRes"></right-tree>
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label for="startDate" class="control-label">生成时间</label>
              <datepicker id="startDate" placeholder="开始日期" width='100%'
                          v-model="model.startDate"
                          :value.sync="model.startDate"
                          :format="'yyyy-MM-dd 00:00:00'"
                          :show-reset-button="true"
                          condition="f_hand_date >= '{}'">
              </datepicker>
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label for="endDate" class="control-label">生成时间</label>
              <datepicker id="endDate" placeholder="结束日期" width='100%'
                          v-model="model.endDate"
                          :value.sync="model.endDate"
                          :format="'yyyy-MM-dd 23:59:59'"
                          :show-reset-button="true"
                          condition="f_hand_date <= '{}'">
              </datepicker>
            </div>

            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">费用区间</label>
              <datepicker placeholder="开始日期" width='100%'
                          v-model="model.f_input_date"
                          :value.sync="model.f_input_date"
                          :format="'yyyy-MM-dd 00:00:00'"
                          :show-reset-button="true"
                          condition="f_input_date >= '{}'">
              </datepicker>
            </div>
            <div class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">费用区间</label>
              <datepicker placeholder="结束日期" width='100%'
                          v-model="model.f_end_date"
                          :value.sync="model.f_end_date"
                          :format="'yyyy-MM-dd 23:59:59'"
                          :show-reset-button="true"
                          condition="f_end_date <= '{}'">
              </datepicker>
            </div>

          </div>
          <div class="row">
            <div class="span" style = "float:right;margin-top:10px">
              <button class="btn btn-success" style="border-radius: 2px;margin-right: 10px" @click="search()">查询</button>
              <button class="btn btn-success" style="border-radius: 2px;margin-right: 10px" @click="$parent.$parent.clear()">清空</button>
              <button class="btn btn-default" style="border-radius: 2px;margin-right: 10px"
                      type="button" @click="$parent.$parent.stamp()">打印</button>

              <export-excel :data="$parent.$parent.getCondition"
                            :field="$parent.$parent.getfield"
                            sqlurl="rs/logic/exportfile" sql-name="newhandplanQuery" template-name='抄表查询导出' :choose-col="true"></export-excel>

              <button class="btn" @click="$parent.$parent.hidden()" style="margin-left: 10px">
                <span class="glyphicon glyphicon-chevron-up"></span>
              </button>

              <button class="btn" @click="$launchFullscreen('meter-read-query')" style="padding-left: 10px">
                <span class="glyphicon glyphicon-fullscreen" style="color: #337ab7"></span>
              </button>
            </div>
          </div>
        </div>
      </criteria>

      <data-grid  :model="model" partial='list' v-ref:grid :classname="$parent.classname" @dblclick="$parent.dblclick" >
        <template partial='head'>
          <tr>
            <th v-for="item in $parent.$parent.$parent.headData"><nobr>{{item}}</nobr></th>
          </tr>
        </template>
        <template partial='body'>
          <td style="text-align: center" v-for="item in $parent.$parent.$parent.bodyData"><nobr>{{row[item]}}</nobr></td>
        </template>
        <template partial='foot'></template>
      </data-grid>
    </criteria-paged>

    <table class="table-hover">
      <tr style="position: relative" class="table-bordered">
        <td style="display: inline-block;width: auto;border-right: 1px solid #F2F6FA;padding: 0px 10px 0px 10px;color: #5CB95C;font-weight: bold">汇总信息</td>
        <td style="display: inline-block;width: auto;border-right: 1px solid #F2F6FA;padding: 0px 10px 0px 10px">总金额合计:&emsp;{{sumsmodel.f_amount}}</td>
        <td style="display: inline-block;width: auto;border-right: 1px solid #F2F6FA;padding: 0px 10px 0px 10px">优惠金额合计:&emsp;{{sumsmodel.f_reduce_fee}}</td>
        <td style="display: inline-block;width: auto;border-right: 1px solid #F2F6FA;padding: 0px 10px 0px 10px">应交金额合计:&emsp;{{sumsmodel.f_oughtfee}}</td>
        <td style="display: inline-block;width: auto;border-right: 1px solid #F2F6FA;padding: 0px 10px 0px 10px">未交金额合计:&emsp;{{sumsmodel.real_charge}}</td>
        <!--        <td style="display: inline-block;width: auto;border-right: 1px solid #F2F6FA;padding: 0px 10px 0px 10px">用热面积合计:&emsp;{{sumsmodel.f_covered_area}}</td>-->
        <td style="display: inline-block;width: auto;border-right: 1px solid #F2F6FA;padding: 0px 10px 0px 10px">用热面积合计:&emsp;{{countmodel.coverd_area}}</td>
        <td style="display: inline-block;width: auto;border-right: 1px solid #F2F6FA;padding: 0px 10px 0px 10px">户数合计:&emsp;{{countmodel.user_count}}</td>
      </tr>
    </table>
    <!--<colligate-details :showinfo="showinfo" :businesstype="businesstype" :data="data" @close-info="showinfo=false"></colligate-details>-->
    <modal :show.sync="printshow" v-ref:modal backdrop="false">
      <header slot="modal-header" class="modal-header text-center">
        <h4 class="modal-title">打印列选择</h4>
        <input type="checkbox" class="" id="f_generations" v-model="all">
        <label for="f_generations" class="font-size">全选</label>
      </header>
      <article slot="modal-body">
        <div class="auto col-sm-11 col-md-offset-1"  style="margin-top: 10px;">
          <div class="col-sm-3" v-for="f in fields">
            <input type="checkbox" class="" :id="'water-owe-details-'+$index" v-model="modelval" :value="$key">
            <label :for="'water-owe-details-'+$index" class="font-size">{{f}}</label>
          </div>
        </div>
      </article>
      <footer slot="modal-footer" class="modal-footer">
        <center>
          <button v-show="printshow" type="button" class="btn btn-default" @click='close()'>取消</button>
          <button v-show="printshow" type="button" class="btn btn-success" @click='print()'>打印</button>
          <print-table :model='model' v-show="false" v-ref:print
                       :top='40' :left='60' :right='40' :bottom='60'
                       :thead="thead" :tfoot='tfoot' :attach="yangsen"
                       :fields="modelval" :printpage="true">
          </print-table>
        </center>
      </footer>
    </modal>
  </div>
</template>

<script>
  import { PagedList } from 'vue-client'
  import defaultPrint from './config/DefaultPrint'
  import Vue from 'vue'
  let readySomething = async function (self) {
    let dt = new Date()
    self.$refs.paged.$refs.cri.model.startDate = dt.getFullYear() + '-01-01 00:00:00'
    self.$refs.paged.$refs.cri.model.endDate =  `${dt.getFullYear()}-12-31 23:59:59`
    self.$refs.paged.$refs.cri.model.f_whether_pay = '否'
    self.$refs.paged.$refs.cri.model.f_hand_state = '有效'
    await self.$refs.paged.$refs.cri.search()
    self.sumsmodel = self.$refs.paged.$refs.grid.model.sums
  }
  export default {
    data() {
      return {
        showinfo: false,
        businesstype: '抄表查询',
        data: {},
        model: new PagedList('rs/sql/newhandplanQuery', 20,{},{f_amount: 0,f_oughtfee: 0,f_reduce_fee: 0,real_charge: 0}),
        // model: new PagedList('rs/sql/newhandplanQuery', 20,{},{f_amount: 0,f_oughtfee: 0,f_reduce_fee: 0,f_covered_area: 0,real_charge: 0}),
        // model: new PagedList('rs/sql/newhandplanQuery', 20,{},{f_amount: 0,f_oughtfee: 0,f_reduce_fee: 0,real_charge: 0}),
        // model: new PagedList('rs/sql/newhandplanQuery', 20,{},{f_amount: 0,f_oughtfee: 0,f_reduce_fee: 0,f_covered_area: 0,real_charge: 0}),

        criteriaShow: true,
        classname: 'table table-bordered table table-hover',
        headData: [],
        bodyData: [],
        tableData: [
          ["f_userinfo_code", "用户编号"],["f_olduserinfo_code", "旧用户编号"], ["f_user_name", "用户姓名"], ["f_user_type", "用户类型"], ["f_user_phone", "用户电话"], ["f_residential_area", "小区"],
          ["f_address", "地址"], ["f_hand_state", "状态"], ["f_operator", "操作人"], ["f_whether_pay", "缴费状态"], ["f_oughtfee", "应交金额"],
          ["overdues","滞纳金"], ["real_charge", "未交金额"], ["real_amount", "总金额"], ["f_credit_amount", "减免金额"], ["f_reduce_fee", "优惠金额"],
          ["f_charge_mode", "计费方式"], ["f_charge_number", "天/月数"], ["f_price", "单价"], ["f_covered_area", "用热面积"],
          ["f_hand_date", "生成时间"], ["f_mark", "费用区间"]
        ],
        filialeNameStr: null,
        filialeCodeStr: this.$login.f.f_orgids,
        userid: this.$login.f.id,
        source:`tool.getFullTree(this.getRights().where(row.getType() != $zone$).where(row.getType() != $role$))`,

        modelval: [],
        printshow: false,
        all: false,
        fields: {},
        thead: '',
        tfoot: '',
        //合计数据
        sumsmodel: {},
        countmodel: {}
      }
    },
    ready(){
      const map = new Map(this.tableData)
      for (let [key, value] of map) {
        this.bodyData.push(key)
        this.headData.push(value)
      }
      readySomething(this).then(() => {
        this.$emit('ready')
      }).catch((error) => {
        this.$emit('error', error)
      })
    },
    methods: {
      dblclick(obj) {
        this.data = obj
        this.showinfo = true
      },
      async selfSearch (args) {
        let f_orgstr = this.filialeCodeStr
        console.log('xxxx',f_orgstr)
        args.condition =  `${args.condition} and f_orgstr like '${f_orgstr}%'`
        console.log('我的阐述',JSON.stringify(args.condition))
        this.model.search(args.condition, args.model)
        this.sumsmodel = this.$refs.paged.$refs.grid.model.sums
        await this.$resetpost('rs/sql/handplanQueryUserNumber',{data:{condition:args.condition}},{resolveMsg: null, rejectMsg: null}).then((res) => {
          this.countmodel = res.data.length > 0 ? res.data[0] : {}
        })
        console.log('合计字段',this.sumsmodel)
      },
      clear(){
        Object.keys(this.$refs.paged.$refs.cri.model).forEach((key) => {
          this.$refs.paged.$refs.cri.model[key] = ''
        })
      },
      show(){
        this.criteriaShow = true
      },
      hidden(){
        this.criteriaShow = false
      },
      getRes(obj) {
        this.filialeNameStr = obj.res
        this.filialeCodeStr = obj.resids
      },
      stamp () {
        this.all = false
        //默认选择要打印的列
        this.modelval = defaultPrint.config
        this.fields = this.getfield
        console.log('所有打印字段',this.fields)
        this.printshow = true
        this.put()
      },
      put () {
        // 对Modelval进行排序
        this.sortModelval()
        this.thead = `<tr><th colspan=${this.modelval.length}>抄表查询统计报表</th></tr><tr>`
        for (let key of this.modelval) {
          this.thead += '<th>' + this.fields[key] + '</th>'
        }
        this.thead += '</tr>'
      },
      print () {
        this.$refs.print.PrintAsFile()
        this.printshow = false
      },
      close () {
        this.printshow = false
        this.all = false
      },
      // 对选择的列进行排序
      sortModelval () {
        let sortModel = []
        Object.keys(this.fields).forEach((key) => {
          if (this.modelval.includes(key)) {
            sortModel.push(key)
          }
        })
        this.modelval = sortModel
        console.log('选择的打印的字段', this.modelval)
      }
    },
    watch:{
      'all' (val) {
        if (val) {
          this.modelval = this.bodyData
        } else {
          this.modelval = defaultPrint.config
          this.put()
        }
      },
      'modelval.length' () {
        this.put()
      },
    },
    computed:{
      residential_area () {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('小区')]
      },
      getCondition(){
        return {condition: `${this.$refs.paged.$refs.cri.condition}  and f_orgstr like '${this.filialeCodeStr}%'`}
      },
      getfield(){
        let data = {}
        this.bodyData.forEach((value, index)=>{
          data[this.bodyData[index]] = this.headData[index]
        })
        //合计字段打印
        this.tfoot = `<tr><th colspan=${this.modelval.length}>全表汇总信息: `
        if(this.sumsmodel){
          Object.keys(this.sumsmodel).forEach((key) => {
            this.tfoot += this.fields[key] + '合计: ' + `<font color="blue">${this.sumsmodel[key]} </font>`
          })
        }else{
          this.tfoot += '暂无'
        }
        this.tfoot += '</th></tr>'
        return data
      },
      usertypes () {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('用户类型')]
      },
      user_state () {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('用户状态')]
      },
      handstate () {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('欠费状态')]
      },
      whetherPay () {
        return [{label: '全部', value: ''}, {label: '已缴费', value: '是'}, {label: '未缴费', value: '否'}]
      }
    }
  }
</script>

