hitch-sb-antd/src/views/remote/opc/RemoteOpc.vue

<template>
  <a-card :bordered="false">
    <div v-show="visible">
      <div class="table-page-search-wrapper" @keyup.enter="handleEnter">
        <a-form layout="inline">
          <a-row :gutter="48" v-show="advanced">
            <a-col :md="6" :sm="24">
              <a-form-item label="关键字">
                <a-input v-model="queryParam.keyword" placeholder="请输入名称/类型名称" />
              </a-form-item>
            </a-col>
            <a-col :md="6" :sm="24">
              <a-form-item label="是否模拟量">
                <a-select v-model="queryParam.avFlag" placeholder="请选择">
                  <a-select-option
                    v-for="(label,value) in yesNoMap"
                    :key="value"
                    :label="label"
                    :value="parseInt(value)">{{ label }}
                  </a-select-option>
                </a-select>
              </a-form-item>
            </a-col>
            <a-col :md="6" :sm="24">
              <a-form-item label="opc服务端是否创建">
                <a-select v-model="queryParam.createdFlag" placeholder="请选择">
                  <a-select-option
                    v-for="(label,value) in yesNoMap"
                    :key="value"
                    :label="label"
                    :value="parseInt(value)">{{ label }}
                  </a-select-option>
                </a-select>
              </a-form-item>
            </a-col>
          </a-row>
          <a-row :gutter="48">
            <a-col :md="24 || 24" :sm="24" style="text-align: right">
              <span class="table-page-search-submitButtons">
                <a-button type="primary" @click="$refs.table.refresh(true)">查询</a-button>
                <a-button style="margin-left: 8px" @click="resetSearchForm">重置</a-button>
                <a @click="()=>{ this.advanced = !this.advanced}" style="margin-left: 8px">
                  {{ advanced ? '收起' : '展开' }}
                  <a-icon :type="advanced ? 'up' : 'down'" />
                </a>
              </span>
            </a-col>
          </a-row>
        </a-form>
      </div>

      <div class="table-operator" style="margin-bottom: 8px;">
        <a-row>
          <a-col :md="16">
            <a-button v-if="$auth('remote-opcs-add')" type="primary" icon="plus" @click="handleAdd()">新增</a-button>
            <a-button
              style="margin-left: 8px"
              v-if="$auth('remote-opcs-export')"
              type="primary"
              icon="download"
              @click="doExport">导出
            </a-button>
            <a-button style="margin-left:8px;" type="primary" @click="doImport">
              <a-icon type="upload" />
              新增导入
            </a-button>
            <a-button
              style="margin-left: 8px"
              v-if="$auth('remote-opcs-add')"
              type="primary"
              icon="download"
              @click="doAddAll">全部采集
            </a-button>
            <a-dropdown v-action:edit v-if="selectedRowKeys.length > 0 && $auth('remote-opcs-del')">
              <a-menu slot="overlay">
                <a-popconfirm title="是否要删除所选数据？" @confirm="batchDelete()">
                  <a-menu-item key="1">
                    <a-icon type="delete" />
                    <a>删除</a>
                  </a-menu-item>
                </a-popconfirm>
                <a-popconfirm title="是否要删除所选数据？" @confirm="update(1, 1)">
                  <a-menu-item key="1">
                    <a-icon />
                    <a>模拟量</a>
                  </a-menu-item>
                </a-popconfirm>
                <a-popconfirm title="是否要删除所选数据？" @confirm="update(1, 0)">
                  <a-menu-item key="1">
                    <a-icon />
                    <a>数字量</a>
                  </a-menu-item>
                </a-popconfirm>
                <a-popconfirm title="是否要删除所选数据？" @confirm="update(2, 1)">
                  <a-menu-item key="1">
                    <a-icon />
                    <a>OPC server已配置</a>
                  </a-menu-item>
                </a-popconfirm>
                <a-popconfirm title="是否要删除所选数据？" @confirm="update(2, 0)">
                  <a-menu-item key="1">
                    <a-icon />
                    <a>OPC server未配置</a>
                  </a-menu-item>
                </a-popconfirm>
              </a-menu>
              <a-button style="margin-left: 8px">
                批量操作
                <a-icon type="down" />
              </a-button>
            </a-dropdown>
          </a-col>
        </a-row>
      </div>

      <s-table
        ref="table"
        size="default"
        rowKey="id"
        :columns="columns"
        :data="loadData"
        :alert="options.alert"
        :rowSelection="options.rowSelection"
        showPagination="auto"
      >
        <span slot="action" slot-scope="record">
          <template>
            <a @click="handleView(record)">查看</a>
            <operation-button
              v-if="$auth('remote-opcs-edit')"
              @click="handleEdit(record)"
            >修改</operation-button>
            <operation-button
              v-if="$auth('remote-opcs-del')"
              :type="2"
              title="是否要删除该条数据？"
              @confirm="batchDelete(record.id)">删除</operation-button>
            <a-divider
              v-if="record.type == 2"
              type="vertical" />
            <a
              v-if="record.type == 2"
              @click="handleAddFetch(record)">就地点位
            </a>
            <!--            <a
              style="margin-left: 8px"
              @click="doTestAdd(record)">测试写入
            </a>
            <a-divider type="vertical" />
            <a
              style="margin-left: 8px"
              @click="doTestAddBatch(record)">测试批量写入
            </a>
            <a-divider type="vertical" />
            <a
              style="margin-left: 8px"
              @click="doTestSelect(record)">测试查询
            </a>-->
          </template>
        </span>
      </s-table>
    </div>
    <import-form-add ref="importModal" @ok="handleOk" />
    <base-form ref="baseModal" @ok="handleOk" />
    <detail ref="detailModal" @ok="handleOk" />
  </a-card>
</template>

<script>
import { STable, Ellipsis } from '@/components'
import BaseForm from './modules/BaseForm'
import Detail from './modules/Detail'
import {
  getRemoteOpcPage,
  deleteRemoteOpcs,
  updateRemoteOpcs,
  addToServerRemoteOpcs,
  fetchRemoteOpc,
  exportRemoteOpc
} from '@/api/remote/opc'

import ImportFormAdd from './modules/ImportFormAdd'
import { updateInfluxDB, updateInfluxDBBatch, queryInfluxDBHistory } from '@/api/influxDB/influxDB'

export default {
  name: 'RemoteOpcList',
  components: {
    STable,
    Ellipsis,
    ImportFormAdd,
    BaseForm,
    Detail
  },
  props: {
    createdFlag: {
      type: Number,
      default: 1
    }
  },
  data () {
    return {
      advanced: false,
      visible: true,
      map: {},
      // 查询参数
      queryParam: {
        createdFlag: this.createdFlag
      },
      // 表头
      columns: [
        {
          title: '序号',
          dataIndex: 'index',
          customRender: (text, record, index) => {
            return `${(this.$refs.table.localPagination.current - 1) * this.$refs.table.localPagination.pageSize + index + 1}`
          }
        },
        {
          title: '点位',
          dataIndex: 'positionNum'
        },
        {
          title: '类型',
          dataIndex: 'type',
          customRender: (text, record, index) => {
            return this.BaseTool.Object.getField(this.map, text)
          }
        },
        {
          title: '是否模拟量',
          dataIndex: 'avFlag',
          customRender: (text, record, index) => {
            return this.BaseTool.Object.getField(this.yesNoMap, text)
          }
        },
        {
          title: 'opc服务中心是否配置',
          dataIndex: 'createdFlag',
          customRender: (text, record, index) => {
            return this.BaseTool.Object.getField(this.yesNoMap, text)
          }
        },
        {
          title: '量程下限',
          dataIndex: 'low'
        },
        {
          title: '量程上限',
          dataIndex: 'high'
        },
        {
          title: '单位',
          dataIndex: 'unit'
        },
        {
          title: '系数',
          dataIndex: 'ratio',
          customRender: (text, record, index) => {
            return this.BaseTool.Amount.formatter(text)
          }
        },
        {
          title: '描述',
          dataIndex: 'description'
        },
        {
          title: '备注',
          dataIndex: 'remark'
        },
        {
          title: '操作',
          key: 'action',
          width: '200px',
          align: 'center',
          scopedSlots: { customRender: 'action' }
        }
      ],
      // 下拉框map
      // 加载数据方法 必须为 Promise 对象
      loadData: parameter => {
        parameter = {
          ...parameter,
          ...this.queryParam,
          dataScope: {
            sortBy: 'desc',
            sortName: 'created_time'
          }
        }
        return getRemoteOpcPage(Object.assign(parameter, this.queryParam))
          .then(res => {
            return res.data
          })
      },
      selectedRowKeys: [],
      selectedRows: [],
      yesNoMap: {},
      options: {
        alert: {
          show: true,
          clear: () => {
            this.selectedRowKeys = []
          }
        },
        rowSelection: {
          selectedRowKeys: this.selectedRowKeys,
          onChange: this.onSelectChange
        }
      },
      optionAlertShow: false
    }
  },
  created () {
    // 下拉框map
    this.tableOption()
    this.map = this.DictCache.getLabelByValueMapByType(this.DictCache.TYPE.REMOTE_OPC)
    this.yesNoMap = this.DictCache.getLabelByValueMapByType(this.DictCache.TYPE.YES_NO)
  },
  methods: {
    tableOption () {
      if (!this.optionAlertShow) {
        this.options = {
          alert: {
            show: true,
            clear: () => {
              this.selectedRowKeys = []
            }
          },
          rowSelection: {
            selectedRowKeys: this.selectedRowKeys,
            onChange: this.onSelectChange,
            getCheckboxProps: record => ({
              props: {
                disabled: false,
                name: record.id
              }
            })
          }
        }
        this.optionAlertShow = true
      } else {
        this.options = {
          alert: false,
          rowSelection: null
        }
        this.optionAlertShow = false
      }
    },
    batchDelete (id) {
      let ids = []
      if (this.BaseTool.String.isBlank(id)) {
        const length = this.selectedRows.length
        if (length === 0) {
          this.$message.info('请选择要删除的记录')
          return
        }
        ids = this.selectedRows.map(item => item.id)
      } else {
        ids = [id]
      }
      deleteRemoteOpcs(ids).then(res => {
        this.$message.info('删除成功')
        this.handleOk()
        this.$refs.table.clearSelected()
      })
    },
    update (updateType, value) {
      let ids = []
      const length = this.selectedRows.length
      if (length === 0) {
        this.$message.info('请选择要修改的数据')
        return
      }
      ids = this.selectedRows.map(item => item.id)
      updateRemoteOpcs({ updateType: updateType, value: value, ids: ids }).then(res => {
        this.handleOk()
      })
    },
    handleAdd () {
      const modal = this.$refs.baseModal
      modal.base({
        ...this.$route.query
      })
    },
    handleAddFetch (record) {
      fetchRemoteOpc({ id: record.id }).then(res => {
        const modal = this.$refs.baseModal
        const data = res.data
        data.id = null
        data.positionNum = null
        data.sbName = null
        data.description = null
        data.fetchFlag = 0
        data.remark = null
        modal.base(data)
      })
    },
    handleEdit (record) {
      fetchRemoteOpc({ id: record.id }).then(res => {
        const modal = this.$refs.baseModal
        modal.base(res.data)
      })
    },
    handleView (record) {
      // this.visible = false
      fetchRemoteOpc({ id: record.id }).then(res => {
        const modal = this.$refs.detailModal
        modal.base(res.data)
      })
    },
    doAddAll () {
      const parameter = {
        ...this.queryParam,
        sbIds: this.selectedRowKeys
      }
      addToServerRemoteOpcs(parameter).then(res => {
        this.$message.info('已添加，100秒后自动采集')
      })
    },
    doTestAdd (record) {
      updateInfluxDB(record).then(res => {
        this.$message.info('已添加')
      })
    },
    doTestAddBatch (record) {
      updateInfluxDBBatch(record).then(res => {
        this.$message.info('已批量添加')
      })
    },
    doTestSelect (record) {
      const parameter = {}
      parameter.id = record.id
      parameter.type = 1
      queryInfluxDBHistory(parameter).then(res => {
        console.log(res.data)
        this.$message.info('已查询')
      })
    },
    handleOk () {
      this.visible = true
      this.$refs.table.refresh()
    },
    onSelectChange (selectedRowKeys, selectedRows) {
      this.selectedRowKeys = selectedRowKeys
      this.selectedRows = selectedRows
    },
    resetSearchForm () {
      this.queryParam = {
        createdFlag: this.createdFlag
      }
      this.$refs.table.refresh(true)
    },
    doExport () {
      const parameter = {
        ...this.queryParam,
        ids: this.selectedRowKeys,
        dataScope: {
          sortBy: 'asc',
          sortName: 'no'
        }
      }
      exportRemoteOpc(parameter).then(file => {
        this.BaseTool.UPLOAD.downLoadExportExcel(file)
      })
    },
    doImport () {
      this.$refs.importModal.base()
    },
    handleEnter () {
      this.$refs.table.refresh(true)
    }
  }
}
</script>