<template>
  <div style="flex:1;width: 100%" class="flex" id="charge-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 @sort="sort">
      <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_user_name"
                     condition="s.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>
              <input type="text" class="form-control" v-model="model.f_idnumber"
                     condition="f_idnumber like '%{}%'" placeholder="身份证号"
                     :size="model.f_idnumber ? model.f_idnumber.length * 2 : 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_residential_area"
                     condition="f_residential_area like '%{}%'" placeholder="小区"
                     :size="model.f_residential_area ? model.f_residential_area.length * 2 : 1"/>-->
              <v-select :value.sync="model.f_residential_area" v-model="model.f_residential_area" value-single
                        :options='$parent.$parent.residential' placeholder='小区'
                        close-on-select condition="f_residential_area like '%{}%'">
              </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="s.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_type"
                        :options='$parent.$parent.usertypes' placeholder='请选择' v-model="model.f_user_type"
                        condition="s.f_user_type = '{}'"
                        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_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" title="付款方式查询专用">收款方式</label>
              <v-select :value.sync="model.f_payment"
                        v-model="model.f_payment"
                        :options='$parent.$parent.payments' placeholder='请选择'
                        close-on-select
                        condition="s.f_payment in {}"
              ></v-select>
            </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 HH:mm:ss'"
                          :show-reset-button="true"
                          condition="s.f_delivery_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 HH:mm:ss'"
                          :show-reset-button="true"
                          condition="s.f_delivery_date <= '{}'">
              </datepicker>
            </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 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 class="col-sm-3 form-group form-input-group" style="width: 20%">
              <label class="control-label">操作人</label>
              <v-select :value.sync="model.f_operator" v-model='model.f_operator'
                        :options='$parent.$parent.operators' placeholder='操作人'
                        close-on-select
                        condition="s.f_operator = '{}'"></v-select>
            </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="refundQuery" 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('refund-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 v-if="item !== '用户地址'">{{item}}</nobr>
              <data-order v-else field="f_residential_area,f_building,f_unit,f_floor,f_room" name="用户地址"
                          :order.sync="$parent.$parent.$parent.orderAddressFields.f_address"></data-order>
            </th>
          </tr>
        </template>
        <template partial='body'>
          <td style="text-align: center" v-for="item in $parent.$parent.$parent.bodyData">
            <nobr v-if="item !== '操作'">{{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.collection}}</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" :printview>
          </print-table>
        </center>
      </footer>
    </modal>
  </div>
</template>

<script>
  import {HttpResetClass, PagedList} from 'vue-client'
  import defaultPrint from './config/DefaultPrint'

  let readySomething = async function (self) {
    self.$refs.paged.$refs.cri.model.startDate = self.$login.toStandardDateString() + ' 00:00:00'
    self.$refs.paged.$refs.cri.model.endDate = self.$login.toStandardDateString() + ' 23:59:59'
    self.$refs.paged.$refs.cri.model.f_charge_state = ['有效']

    await self.$refs.paged.$refs.cri.search()
    self.sumsmodel = self.$refs.paged.$refs.grid.model.sums
  }
  export default {
    data() {
      return {
        countmodel: {
          user_count:0
        },
        currentRow: {},
        updateShow: false,
        operators: [],
        orderAddressFields: {
          f_residential_area: 'no',
          f_unit: 'no',
          f_floor: 'no',
          f_room: 'no'
        },
        residential: [],
        showinfo: false,
        businesstype: '收费查询',
        data: {},
        model: new PagedList('rs/sql/refundQuery', 20, {}, {f_collection: 0}),
        criteriaShow: true,
        classname: 'table table-bordered table table-hover',
        headData: [],
        bodyData: [],
        tableData: [
          ["f_userinfo_code", "用户编号"], ["f_user_name", "用户姓名"], ["f_user_phone", "用户电话"],  ["collection", "退款"],
          ["f_balance", "上期结余"], ["f_curbalance", "本期结余"], ["f_delivery_date", "退费日期"], ["f_mark", "费用区间"], ["f_operator", "操作员"],
          ["f_charge_state", "状态"], ["f_user_type", "用户类型"], ["f_payment", "收款方式"], ["f_residential_area", "小区"], ["f_address", "用户地址"],
          ["f_outlets", "营业网点"], ["f_filiale", "分公司"]
        ],
        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$))`,
        orderItem: 'f_delivery_date desc',
        orderDefault: 'f_delivery_date desc',
        modelval: [],
        printshow: false,
        all: false,
        fields: {},
        thead: '',
        tfoot: '',
        //合计数据
        sumsmodel: {}
      }
    },
    async ready() {
      const map = new Map(this.tableData)
      for (let [key, value] of map) {
        this.bodyData.push(key)
        this.headData.push(value)
      }
      await this.getOperators()
      await this.getArea()
      readySomething(this).then(() => {
        this.$emit('ready')
      }).catch((error) => {
        this.$emit('error', error)
      })
    },
    methods: {
      subtr(arg1, arg2) {
        var r1, r2, m, n;
        try {
          r1 = arg1.toString().split(".")[1].length
        } catch (e) {
          r1 = 0
        }
        try {
          r2 = arg2.toString().split(".")[1].length
        } catch (e) {
          r2 = 0
        }
        m = Math.pow(10, Math.max(r1, r2));
        n = (r1 >= r2) ? r1 : r2;
        return ((arg1 * m - arg2 * m) / m).toFixed(n);
      },
      async getOperators() {
        this.operators = [{label: '全部', value: ''}]
        let oprts = await this.$resetpost('rs/sql/singleTableParam', {
          data: {
            items: '*',
            tablename: 't_user',
            condition: '1=1'
          }
        },{resolveMsg: null, rejectMsg: '获取操作人失败!'})
        for (let index in oprts.data) {
          let json = {label: '', value: ''}
          json.label = oprts.data[index].name
          json.value = oprts.data[index].name
          this.operators.push(json)
        }
      },
      search() {
        this.$refs.paged.$refs.cri.search()
      },
      sort(field, rule) {
        // 将所有排序方式设为不排序，实现相互排斥
        for (let key in this.orderAddressFields) {
          if (key === field) {
            this.orderAddressFields[key] = rule
          } else {
            this.orderAddressFields[key] = 'no'
          }
        }
        // 如果新规则不排序，还原为默认排序
        if (rule === 'no') {
          this.orderItem = this.orderDefault
        } else {
          this.orderItem = field.replace(new RegExp(",", "gm"), ' ' + rule + ',') + ` ${rule}`
        }
        this.search()
      },
      async getArea() {
        let resCondition = `1=1`
        this.residential = [{label: '全部', value: ''}]
        console.log('我是修正是发的获取小区请求')
        let getResCondition = await this.$resetpost('rs/sql/manageSingleTable_OrderBy', {
          data: {
            items: 'id,f_residential_area',
            tablename: 't_area',
            condition: resCondition,
            orderitem: 'f_operate_date desc'
          }
        }, {resolveMsg: null, rejectMsg: '获取小区失败!'})
        getResCondition.data.forEach((row) => {
          this.residential.push({label: row.f_residential_area, value: row.f_residential_area})
        })
        return this.residential
      },
      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 s.f_orgstr like '${f_orgstr}%'`
        console.log('我的阐述', JSON.stringify(args.condition))
        //附加参数
        let addition = {orderItem: `'${this.orderItem}'`}
        this.model.paramSource = addition
        await this.model.search(args.condition, args.model)

        this.sumsmodel = this.$refs.paged.$refs.grid.model.sums
        console.log('合计字段', this.sumsmodel)
        this.getUserCount()
      },
      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() {
        debugger
        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()
        }
      },
      'model.rows'() {
        let data = this.model.sums
        data.f_collection = this.subtr(data.f_collection,data.expense_fee)
        // data.f_covered_area = this.subtr(data.f_covered_area,data.stoping_area)
      },
      'modelval.length'() {
        this.put()
      },
    },
    computed: {
      getExpenseType() {
        return [{label: '全部', value: ''}, {label: '报停', value: '报停'}, {label: '供暖', value: '供暖'}]
      },
      getCondition() {
        return {
          condition: `${this.$refs.paged.$refs.cri.condition}  and s.f_orgstr like '${this.filialeCodeStr}%'`,
          orderItem:  this.orderItem
        }
      },
      getfield() {
        let data = {}
        this.bodyData.forEach((value, index) => {
          if(this.headData[index] !== '操作')
            data[this.bodyData[index]] = this.headData[index]
        })

        //合计字段打印
        this.tfoot = `<tr><th colspan=${this.modelval.length}>全表汇总信息: `
        this.tfoot += '退费金额合计: ' + `<font color="blue">${this.sumsmodel.collection} </font>`
        this.tfoot += '</th></tr>'

        return data
      },
      usertypes() {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('用户类型')]
      },
      user_state() {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('用户状态')]
      },
      gasproperties() {
        let rs = []
        if (this.$refs.paged.$refs.cri.model.f_user_type.length === 1) {
          rs = this.$appdata.getParam(this.$refs.paged.$refs.cri.model.f_user_type[0])
        }
        return [{label: '全部', value: ''}, ...rs]
      },
      pricenames() {
        let arr = []
        this.$GetSaleParam.getOnlyPrice().forEach((item) => {
          console.log('看看气价的分公司..', item.value, this.$login.f.f_filiale)
          if (item.value) {
            if (this.$login.f.f_fengongsi === item.value.f_filiale) {
              let temp = {}
              temp.label = item.label
              temp.value = item.value.f_price_name
              arr.push(temp)
            }
          }
        })
        return [{label: '全部', value: ''}, ...arr]
      },
      metertypes() {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('气表类型')]
      },
      meterbrands() {
        let arr = []
        this.$GetSaleParam.getGasbrand().forEach((item) => {
          let temp = {}
          temp.label = item.label
          temp.value = item.value.f_meter_brand
          arr.push(temp)
        })
        return [{label: '全部', value: ''}, ...arr]
      },
      payments() {
        return [{label: '全部', value: ''}, {label: '余额', value: '余额'}, {label: '现金', value: '现金缴费'}]
      },
      changePayment() {
        return [...this.$appdata.getParam('付款方式')]
      },
      charge_state() {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('收费状态')]
      }
    }
  }
</script>

<style scoped>
  .input_search {
    padding: 6px;
    width: 100px;
    height: 30px;
    background-color: #ffffff;
    border-radius: 2px;
    border: solid 1px #c7c7c7;
    color: #333333;
    font-size: 12px;
    font-family: PingFang;
  }
</style>
