<template>
  <div style="flex:1;width: 100%" class="flex" id="user-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" @sort="sort" 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>-->
            <!--<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>
              <v-select :value.sync="model.f_user_state"
                        v-model="model.f_user_state"
                        :options='$parent.$parent.userstates' 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>-->
            <!--<v-select-->
            <!--:value.sync="model.f_slice_area"-->
            <!--v-model="model.f_slice_area"-->
            <!--:options='$parent.$parent.areas'-->
            <!--placeholder='请选择'-->
            <!--condition="f_slice_area = '{}'"-->
            <!--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_street"
                      condition="f_street like '%{}%'" placeholder='街道'
                      :size="model.f_street ? model.f_street.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_address"-->
            <!--condition="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="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_gasproperties" v-model="model.f_gasproperties"
                        :options='$parent.$parent.gasproperties' placeholder='请选择'
                        condition="f_gasproperties = '{}'"
                        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_residential_area"
                     condition="f_residential_area like '%{}%'" placeholder="小区"
                     :size="model.f_residential_area ? model.f_residential_area.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_building"
                      condition="f_building = '{}'" placeholder="楼栋"
                      :size="model.f_building ? model.f_building.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_unit"
                      condition="f_unit = '{}'" placeholder="单元"
                      :size="model.f_unit ? model.f_unit.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_floor"
                      condition="f_floor = '{}'" placeholder="楼层"
                      :size="model.f_floor ? model.f_floor.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_room"
                      condition="f_room = '{}'" placeholder="门牌号"
                      :size="model.f_room ? model.f_room.length * 2: 1">
            </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'"
                          :show-reset-button="true"
                          condition="f_createfile_date >= '{} 00:00:00'">
              </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'"
                          :show-reset-button="true"
                          condition="f_createfile_date <= '{} 23:59:59'">
              </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>
          <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="newuserinfoQuery" 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('user-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">
        <template partial='head'>
          <tr>
            <th>
              <nobr>
                <data-order field="f_userinfo_code" :order.sync="$parent.$parent.$parent.orderFields.f_userinfo_code" name="用户编号"></data-order>
              </nobr>
            </th>
            <th><nobr>旧用户编号</nobr></th>
            <th><nobr>用户姓名</nobr></th>
            <th><nobr>用户电话</nobr></th>
            <th><nobr>用户状态</nobr></th>
            <th><nobr>用户类型</nobr></th>
            <th><nobr>用热性质</nobr></th>
            <th><nobr>热价名称</nobr></th>
            <th><nobr>热价价格</nobr></th>
            <th><nobr>区/县</nobr></th>
            <th>
              <nobr>
                <data-order field="f_residential_area" :order.sync="$parent.$parent.$parent.orderFields.f_residential_area" name="小区"></data-order>
              </nobr>
            </th>
            <th>
              <nobr>
                <data-order field="f_building" :order.sync="$parent.$parent.$parent.orderFields.f_building" name="楼栋"></data-order>
              </nobr>
            </th>
            <th>
              <nobr>
                <data-order field="f_unit" :order.sync="$parent.$parent.$parent.orderFields.f_unit" name="单元"></data-order>
              </nobr>
            </th>
            <th>
              <nobr>
                <data-order field="f_floor" :order.sync="$parent.$parent.$parent.orderFields.f_floor" name="楼层"></data-order>
              </nobr>
            </th>
            <th>
              <nobr>
                <data-order field="f_room" :order.sync="$parent.$parent.$parent.orderFields.f_room" name="门牌号"></data-order>
              </nobr>
            </th>
            <th><nobr>账户余额</nobr></th>
            <th><nobr>建筑面积</nobr></th>
            <th><nobr>建档日期</nobr></th>
            <th><nobr>操作员</nobr></th>
            <th><nobr>营业网点</nobr></th>
            <th><nobr>分公司</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_balance}}</td>
      </tr>
    </table>
    <change-details v-ref:changedetails :showinfo="showinfo" userinfochange="档案历史信息" :userinfocode="userinfocode"  @close-info="showinfo=false"></change-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'
  let readySomething = async function (self) {
    // self.$refs.paged.$refs.cri.model.startDate = self.$login.toStandardDateString()
    // self.$refs.paged.$refs.cri.model.endDate = self.$login.toStandardDateString()

    // await self.$refs.paged.$refs.cri.search()
    self.sumsmodel = self.$refs.paged.$refs.grid.model.sums
  }

  export default {
    data() {
      return {
        userinfocode:"",
        showinfo: false,
        orderFields: {
          f_residential_area: 'asc'
        },
        sortstr:'f_residential_area asc',
        orderDefault: 'id',
        model: new PagedList('rs/sql/newuserinfoQuery', 20,{},{f_balance: 0}),
        criteriaShow: true,
        classname: 'table table-bordered table table-hover',
        headData: [],
        bodyData: [],
        tableData: [
          ["f_userinfo_code", "用户编号"],["f_olduserinfo_code", "旧用户编号"], ["f_user_name", "用户姓名"], ["f_user_phone", "用户电话"], ["f_user_state", "用户状态"], ["f_user_type", "用户类型"],
          ["f_gasproperties", "用热性质"],["f_price_name", "热价名称"],["f_price", "热价价格"], ["f_area", "区/县"], ["f_residential_area", "小区"],
          ["f_building", "楼栋"], ["f_unit", "单元"], ["f_floor", "楼层"],
          ["f_room", "门牌号"], ["f_balance", "账户余额"], ["f_covered_area", "建筑面积"], ["f_createfile_date", "建档日期"], ["f_operator", "操作员"],
          ["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$))`,

        modelval: [],
        printshow: false,
        all: false,
        fields: {},
        thead: '',
        tfoot: '',
        //合计数据
        sumsmodel: {}
      }
    },
    ready(){
      // const map = new Map();
      // for (let [i,v] of this.bodyData.entries()) {
      //   map.set(v,this.headData[i])
      // }
      // console.log(JSON.stringify(map))
      // this.sort()
      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: {
      selfSearch (args) {
        //sortstr:`${this.sortstr}`
        this.model.params.sortstr = this.sortstr
        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
        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
      },
      sort () {
        if(!this.orderFields){
          this.sortstr='f_residential_area asc'
          this.orderFields['f_residential_area']= 'asc'
        }else{
          let flag=false;
          this.sortstr=''
          for (let key in this.orderFields) {
            if(this.orderFields[key]!='no'){
              flag=true;
              this.sortstr+=key+" "+this.orderFields[key]+","
            }
          }
          if(!flag){
            this.sortstr='f_residential_area asc'
            this.orderFields['f_residential_area']= 'asc'
          }else{
            this.sortstr=this.sortstr.substring(0,this.sortstr.length-1)
          }
        }
        this.$refs.paged.$refs.cri.search()
      },
      // 对选择的列进行排序
      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:{
      getCondition(){
        return {condition: `${this.$refs.paged.$refs.cri.condition}  and f_orgstr like '${this.filialeCodeStr}%'`,sortstr: this.sortstr}
      },
      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
      },
      userstates () {
        return [{label: '全部', value: ''}, ...this.$appdata.getParam('用户状态')]
      },
      areas () {
        console.log('小区获取区县。。。。。', this.$login.f.f_allArea)
        let rs = []
        for (let i = 0; i < this.$login.f.f_allArea.length; i++) {
          let temp = {
            label: this.$login.f.f_allArea[i].label,
            value: this.$login.f.f_allArea[i].label
          }
          rs.push(temp)
        }
        return rs
      },
      sliceArea () {
        let rs = []
        console.log('小区片区。。。', this.$refs.paged.$refs.cri.model.f_area)
        if (this.$refs.paged.$refs.cri.model.f_area.length > 0) {
          for (let i = 0; i < this.$login.f.f_allArea.length; i++) {
            if (this.$login.f.f_allArea[i].label === this.$refs.paged.$refs.cri.model.f_area[0]) {
              rs = this.$login.f.f_allArea[i].value
            }
          }
        }
        console.log('获取小区片区。。。。', rs)
        return rs
      },
      usertypes () {
        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]
      },
    },
    events: {
      'dblclick' (row) {
        this.showinfo = true
        this.userinfocode = row
        this.$refs.changedetails.changedsearch(row)
      }
    }
  }
</script>
