xt-ems-front/src/views/energyBalance/components/balanceData2.vue

<template>
    <!-- 电平衡项目数据维护 -->
    <div class="BalanceData">
        <div class="box">
            <div class="box-top">
                <el-form
                    style="overflow: hidden;"
                    :style="filterForm.show ? null : { height: '0px' }"
                    size="mini"
                    label-width="70px"
                >
                    <el-row>
                        <el-col :span="6">
                            <el-form-item label="时间粒度">
                                <el-select
                                    filterable clearable
                                    v-model="filterForm.data.timegranid"
                                    placeholder=""
                                    style="width: 100%;"
                                >
                                    <el-option
                                        v-for="item of nameObj.timegranid.arr"
                                        :key="item.id"
                                        :value="item.id"
                                        :label="item.name"
                                    ></el-option>
                                </el-select>
                            </el-form-item>
                        </el-col>
                        <el-col :span="6">
                            <el-form-item label="时间">
                                <!-- <zj-timegran-date
                                    v-model="filterForm.data.clock"
                                    style="width: 100%;"
                                    :type="'daterange'"
                                    :timegranId="filterForm.data.timegranid"
                                    :oneFoo="getTableData"
                                    :defaultOffset="-1"
                                ></zj-timegran-date> -->
                                <el-date-picker
                                    v-model="filterForm.data.clock"
                                    style="width: 100%;"
                                    :type="filterForm.data.timegranid === 'DAY' ? 'daterange' : 'daterange'"
                                    range-separator="-"
                                    :format="filterForm.data.timegranid === 'DAY' ? 'yyyy-MM-dd' : 'yyyy-MM'"
                                    :value-format="filterForm.data.timegranid === 'DAY' ? 'yyyy-MM-dd' : 'yyyy-MM'"
                                    start-placeholder="开始日期"
                                    end-placeholder="结束日期">
                                </el-date-picker>
                            </el-form-item>
                        </el-col>
                        <el-col :span="6">
                            <el-form-item label="工序">
                                <el-select
                                    filterable
                                    clearable
                                    multiple
                                    collapse-tags
                                    v-model="filterForm.data.workprocid"
                                    placeholder=""
                                    :disabled="filterForm.disabled.workprocid"
                                    style="width: 100%;"
                                >
                                    <el-option
                                        v-for="item of nameObj.workprocid.arr"
                                        :key="item.id"
                                        :value="item.id"
                                        :label="item.name"
                                    ></el-option>
                                </el-select>
                            </el-form-item>
                        </el-col>
                        <el-col :span="6">
                            <el-form-item label="能介">
                                <el-select
                                    filterable
                                    clearable
                                    multiple
                                    collapse-tags
                                    v-model="filterForm.data.energyid"
                                    :disabled="filterForm.disabled.energyid"
                                    placeholder=""
                                    style="width: 100%;"
                                >
                                    <el-option
                                        v-for="item of nameObj.energyid.arr"
                                        :key="item.id"
                                        :value="item.id"
                                        :label="item.name"
                                    ></el-option>
                                </el-select>
                            </el-form-item>
                        </el-col>
                    </el-row>
                    <el-row>
                        <el-col :span="6">
                            <el-form-item label="属性">
                                <el-select
                                    filterable
                                    clearable
                                    multiple
                                    collapse-tags
                                    v-model="filterForm.data.propertyid"
                                    placeholder=""
                                    style="width: 100%;"
                                >
                                    <el-option
                                        v-for="item of nameObj.propertyid.arr"
                                        :key="item.id"
                                        :value="item.id"
                                        :label="item.name"
                                    ></el-option>
                                </el-select>
                            </el-form-item>
                        </el-col>
                        <el-col :span="6">
                            <el-form-item label="项目编号">
                                <el-tooltip content="精准查询，多个用逗号隔开" placement="bottom">
                                    <el-input clearable
                                        v-model.trim="filterForm.data.itemid"
                                        placeholder=""
                                        style="width: 100%;"
                                        @keyup.enter.native="getTableData(1)"
                                    ></el-input>
                                </el-tooltip>
                            </el-form-item>
                        </el-col>
                        <el-col :span="6">
                            <el-form-item label="项目名称">
                                <el-tooltip content="模糊查询" placement="bottom">
                                    <el-input clearable
                                        v-model.trim="filterForm.data.itemname"
                                        placeholder=""
                                        style="width: 100%;"
                                        @keyup.enter.native="getTableData(1)"
                                    ></el-input>
                                </el-tooltip>
                            </el-form-item>
                        </el-col>
                        <el-col :span="6">
                            <el-form-item label="项目描述">
                                <el-tooltip content="模糊查询" placement="bottom">
                                    <el-input clearable
                                        v-model.trim="filterForm.data.itemdesc"
                                        placeholder=""
                                        style="width: 100%;"
                                        @keyup.enter.native="getTableData(1)"
                                    ></el-input>
                                </el-tooltip>
                            </el-form-item>
                        </el-col>
                    </el-row>
                    <el-row>
                        <el-col :span="6">
                            <el-form-item label="子项目编号">
                                <el-tooltip content="精确查询" placement="bottom">
                                    <el-input clearable
                                        v-model.trim="filterForm.data.measureid"
                                        placeholder=""
                                        style="width: 100%;"
                                        @keyup.enter.native="getTableData(1)"
                                    ></el-input>
                                </el-tooltip>
                            </el-form-item>
                        </el-col>
                    </el-row>
                </el-form>
                <div class="box-top-gjl">
                    <el-button
                        class="button"
                        type="primary"
                        size="mini"
                        @click="but_more()"
                    >修改</el-button>
                    <el-button
                        class="button"
                        type="primary"
                        size="mini"
                        icon="el-icon-refresh"
                        @click="but_re_compute()"
                    >重新计算</el-button>
                     <el-button
                        class="button"
                        type="primary"
                        size="mini"
                        v-privilege="activeMenu + 'PUT'"
                        @click="but_redata()"
                        :loading="loading"
                    >重新生成数据</el-button>
                    <div style="float:right; text-align: right;">
                        <el-tooltip content="每月1、2号早上9点生成上月数据" placement="left">
                            <el-button
                                class="button"
                                type="primary"
                                size="mini"
                                icon="el-icon-search"
                                v-privilege="activeMenu + 'QUERY'"
                                @click="getTableData(1)"
                            >查询</el-button>
                        </el-tooltip>
                        <el-button
                            class="button"
                            type="primary"
                            size="mini"
                            icon="el-icon-refresh"
                            v-privilege="activeMenu + 'QUERY'"
                            @click="tableDataCancel();"
                        >重置</el-button>
                        <el-button
                            size="mini"
                            :icon="filterForm.show ? 'el-icon-caret-top' : 'el-icon-caret-bottom'"
                            :title="filterForm.show ? '收起搜索区' : '展开搜索区'"
                            @click="filterForm.show = !filterForm.show;
                                $nextTick(() => {
                                    singleTableHeight = getRoleHeight($refs['singleTable'].$el) - 45;
                                }
                            );"
                        >{{ filterForm.show ? '收起' : '展开' }}</el-button>
                    </div>
                </div>
            </div>
             <el-tabs v-model="activeName" @tab-click="handleClick">
                <el-tab-pane label="安泰" name="安泰-">

                </el-tab-pane>

                <el-tab-pane label="新泰" name="新泰-">

                </el-tab-pane>
                <el-tab-pane label="附表" name="附表" >

                </el-tab-pane>
            </el-tabs>
            <div class="box-bottom">
                <el-form
                    size="mini"
                    ref="dialog_form_arr"
                    label-width="0px"
                    :model="tableFormDataObj"
                >
                    <el-table
                        stripe
                        id="singleTable"
                        ref="singleTable"
                        :data="tableData"
                        v-loading="tableLoading"
                        style="width: 100%;"
                        :height="singleTableHeight"
                        border
                        size="mini"
                        highlight-current-row
                        @selection-change="handleSelectionChange"
                        :row-class-name="tableRowClassName"
                        @cell-click="cellClick"
                        show-summary
                        :summary-method="getSummaries">
                        <el-table-column
                            sortable
                            type="selection"
                            width="40"
                            align="center"
                            fixed="left"
                        ></el-table-column>
                        <el-table-column
                        sortable
                            prop="clock"
                            label="时间"
                            width="63px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="workprocid"
                            label="工序"
                            width="100px"
                            :show-overflow-tooltip="true"
                            :sort-by="function(row, index) { return sortFoo(row, index, 'workprocid') }"
                        >
                            <template slot-scope="scope">
                                <span>{{ nameObj.workprocid.obj[scope.row.workprocid] ? nameObj.workprocid.obj[scope.row.workprocid] : scope.row.workprocid }}</span>
                            </template>
                        </el-table-column>
                        <el-table-column
                            sortable
                            prop="energyid"
                            label="能介"
                            width="75px"
                            :show-overflow-tooltip="true"
                            :sort-by="function(row, index) { return sortFoo(row, index, 'energyid') }"
                        >
                            <template slot-scope="scope">
                                <span>{{ nameObj.energyid.obj[scope.row.energyid] ? nameObj.energyid.obj[scope.row.energyid] : scope.row.energyid }}</span>
                            </template>
                        </el-table-column>
                        <el-table-column
                            sortable
                            prop="propertyid"
                            label="属性"
                            width="58px"
                            :show-overflow-tooltip="true"
                            :sort-by="function(row, index) { return sortFoo(row, index, 'propertyid') }"
                        >
                            <template slot-scope="scope">
                                <span>{{ nameObj.propertyid.obj[scope.row.propertyid] ? nameObj.propertyid.obj[scope.row.propertyid] : scope.row.propertyid }}</span>
                            </template>
                        </el-table-column>
                        <el-table-column
                            sortable
                            prop="itemdesc"
                            label="项目描述"
                            width="150px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="rav"
                            label="实绩值"
                            width="118px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="ftv"
                            label="分摊值"
                            width="110px"
                            :show-overflow-tooltip="true"
                        >
                            <template slot-scope="scope">
                                <span>{{ isNaN(scope.row.apportvalue - scope.row.rav) ? '' : floatComputed(scope.row.apportvalue, scope.row.rav, '-') }}</span>
                            </template>
                        </el-table-column>
                        <!-- <el-table-column
                        sortable
                            prop="timegranid"
                            label="时间粒度"
                            width="75px"
                            :show-overflow-tooltip="true"
                        >
                            <template slot-scope="scope">
                                <span>{{ nameObj.timegranid.obj[scope.row.timegranid] ? nameObj.timegranid.obj[scope.row.timegranid] : scope.row.timegranid }}</span>
                            </template>
                        </el-table-column> -->
                        <el-table-column
                            sortable
                            prop="apportvalue"
                            label="最终值(平衡)"
                            width="135px"
                            :show-overflow-tooltip="true"
                        >
                            <template slot-scope="scope">
                                <el-form-item
                                    v-if="scope.row.isSelection"
                                    :prop="'s' + scope.row.seq + '.apportvalue'"
                                    :rules="tableFormRules.numbers"
                                >
                                    <el-input clearable @keydown.native="keyDown" :id="scope.column.id + scope.$index"
                                        style="width: 100%;"
                                        v-model="tableFormDataObj['s' + scope.row.seq].apportvalue"
                                        refcous="true"
                                        @change="getCorrectvalue('s' + scope.row.seq)"
                                    ></el-input>
                                </el-form-item>
                                <span v-else>{{scope.row.apportvalue}}</span>
                            </template>
                        </el-table-column>
                        <el-table-column
                            sortable
                            prop="unitid"
                            label="单位"
                            width="65px"
                            :show-overflow-tooltip="true"
                        >
                            <template slot-scope="scope">
                                <span>{{ nameObj.unitid.obj[scope.row.unitid] ? nameObj.unitid.obj[scope.row.unitid] : scope.row.unitid }}</span>
                            </template>
                        </el-table-column>
                        <el-table-column
                            sortable
                            prop="showno"
                            width="100px"
                            label="序号"
                            align="center"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="itemid"
                            label="项目编号"
                            width="103px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="itemname"
                            label="项目名称"
                            width="175px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="actualvalue"
                            label="计算值"
                            width="110px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="correctvalue"
                            label="修正值"
                            width="120px"
                            :show-overflow-tooltip="true"
                        >
                            <template slot-scope="scope">
                                <el-form-item
                                    v-if="scope.row.isSelection"
                                    :prop="'s' + scope.row.seq + '.correctvalue'"
                                    :rules="tableFormRules.numbers"
                                >
                                    <el-input clearable
                                        style="width: 100%;" @keydown.native="keyDown" :id="scope.column.id + scope.$index"
                                        v-model.trim="tableFormDataObj['s' + scope.row.seq].correctvalue"
                                        refcous="true"
                                        @change="getApportvalue('s' + scope.row.seq)"
                                    ></el-input>
                                </el-form-item>
                                <span v-else>{{scope.row.correctvalue}}</span>
                            </template>
                        </el-table-column>
                        <!-- <el-table-column
                            sortable
                            prop="stdvalue"
                            label="折标值"
                            width="118px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="ucvalue"
                            label="单耗值"
                            width="90px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="productvalue"
                            label="实绩产量"
                            width="100px"
                            :show-overflow-tooltip="true"
                        ></el-table-column> -->
                        <el-table-column
                            sortable
                            prop="rectime"
                            label="创建时间"
                            width="125px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                        <el-table-column
                            sortable
                            prop="updateUser"
                            label="修改人"
                            width="80px"
                            :show-overflow-tooltip="true">
                        </el-table-column>
                        <el-table-column
                            sortable
                            prop="updateclock"
                            label="修改时间"
                            width="125px"
                            :show-overflow-tooltip="true"
                        ></el-table-column>
                           <el-table-column
                            sortable
                            class-name="gn-TableDownloadExcel-none"
                            label="操作"
                            align="center"
                            width="86px"
                            fixed="right"
                        >
                            <template slot-scope="scope">
                                <div>
                                    <el-button
                                        type="primary"
                                        size="mini"
                                        v-privilege="activeMenu + 'QUERY'"
                                        @click="but_sdata(scope.row)"
                                    >计算过程</el-button>
                                </div>
                            </template>
                        </el-table-column>
                    </el-table>
                </el-form>
                <el-pagination
                    layout="total, sizes, prev, pager, next, jumper"
                    :total="total"
                    :page-sizes="[10, 20, 50, 100, 500, 1000]"
                    :page-size="pageSize"
                    :current-page.sync="pageNum"
                    @size-change="tableSizeChange"
                    @current-change="getTableData()"
                    style="text-align: right;margin-top: 10px;"
                ></el-pagination>
            </div>
        </div>
    </div>
</template>

<script>
import { zCheckNumber1 } from '~/utils/validator.js'
import store from '@/store/index.js';
import timegranDate from '~/components/zg/timegranDate.vue'
import {formatDate, XtcommonSummaries} from '@/utils/util.js';
export default {
    name: 'BalanceData',
    components: {
        'zj-timegran-date': timegranDate
    },
    data () {
        let start = new Date(new Date().getFullYear(), new Date().getMonth() - 1, '01');
        return {
            rowIndex: '',
            columnId: '',
            focusTarget: null,
            seqArr: [],
            editSetFlag: '',
            multipleSelection: [],
            tableFormDataObj: {},
            store,
            userInfo: {
                data: null
            },
            activeMenu: '',
            filterForm: {
                show: true,
                data: {
                    timegranid: 'MONTH',
                    clock: [formatDate(start, 'yyyy-MM'), formatDate(start, 'yyyy-MM')],
                    workprocid: '',
                    energyid: '',
                    propertyid: '',
                    itemid: '',
                    itemname: '',
                    itemdesc: '',
                    measureid: ''
                },
                rules: {

                },
                disabled: {
                    workprocid: false,
                    energyid: false
                }
            },
            tableFormRules: {
                numbers: [
                    { validator: zCheckNumber1, trigger: 'change' }
                ]
            },
            pageNum: 1,
            pageSize: 20,
            total: 0,
            singleTableHeight: 100,
            tableData: [],
            nameObj: {
                timegranid: {
                    obj: {
                        'MONTH': '月',
                        'YEAR': '年'
                    },
                    arr: [{id: 'MONTH', name: '月'}, {id: 'YEAR', name: '年'}]
                },
                workprocid: {
                    obj: {},
                    arr: []
                },
                energyid: {
                    obj: {},
                    arr: []
                },
                propertyid: {
                    obj: {},
                    arr: []
                },
                unitid: {
                    obj: {},
                    arr: []
                }
            },
            loading: false,
            tableLoading: false,
            dialog: {
                editorBox: {
                    type: '',
                    form: {
                        data: {
                            itemid: '',
                            clock: '',
                            timegranid: '',
                            actualvalue: '',
                            correctvalue: '',
                            apportvalue: ''
                        },
                        rules: {
                            correctvalue: [
                                { required: true, message: '该项不能为空', trigger: 'change' },
                                { validator: zCheckNumber1, trigger: 'change' }
                            ],
                            apportvalue: [
                                { required: true, message: '该项不能为空', trigger: 'change' },
                                { validator: zCheckNumber1, trigger: 'change' }
                            ]
                        }
                    }
                }
            }
        }
    },
    created () {
        this.activeMenu = window.localStorage.getItem('activeMenu');
    },
    mounted () {
        let that = this;
        window.PEDataObj = {
            // 将数据绑定到window上，供main页面使用
            vm: that,
            // tableArr：用于导出成Excel的表格的信息
            tableArr: [
                {
                    name: '',
                    id: 'singleTable'
                }
            ]
        };
        that.$nextTick(() => {
            // 立即获取的height有一定偏差，通过setTimeout延迟来解决
            setTimeout(() => {
                that.singleTableHeight = that.getRoleHeight(that.$refs['singleTable'].$el) - 45;
            }, 1);
        });
        // that.store.dispatch('getUserInfo').then((res) => {
        //     that.userInfo.data = res.data;
        // });
        // 接收路由参数
        if (that.$route.query.workprocid) {
            that.filterForm.disabled.workprocid = true;
            that.filterForm.data.workprocid = that.$route.query.workprocid.split(',');
        }
        if (that.$route.query.energyid) {
            that.filterForm.disabled.energyid = true;
            that.filterForm.data.energyid = that.$route.query.energyid.split(',');
        }
        that.getWorkprocIdData();
        that.getEnergyIdData();
        that.getPropertyIdData();
        that.getUnitIdData();
        that.getTableData();
    },
    methods: {
      // 选项卡切换
        handleClick (tab, event) {
          this.filterForm.data.itemdesc = tab.name;
          this.pageSize = 100;
          this.getTableData(1);
      	},
        //  计算树区域高度
        getRoleHeight (dom) {
            return window.innerHeight - dom.offsetTop;
        },
        // 用于表格特殊列的过滤方法（:sort-by="function(row, index) { return sortFoo() }"）
        sortFoo (row, index, objName, name) {
            name = name || objName;
            let s = this.nameObj[objName].obj[row[name]] ? this.nameObj[objName].obj[row[name]] : row[name];
            return s;
        },
        // 自定义的表格合计方法：只给指定列进行合计
        getSummaries (param) {
            const prop = ['actualvalue', 'correctvalue', 'apportvalue', 'rav', 'ftv']; // 合计列绑定的prop
            return XtcommonSummaries(param, prop);
        },
        // 获取工序(供需实际)
        getWorkprocIdData () {
            let that = this
            let url = 'pass/ems/v1/trmworkprocs/getIdAndName?isreal=1';
            that.axios.get(url)
                .then(function (res) {
                    if (res.code === '0') {
                        let arr = [];
                        let obj = {};
                        for (let item of res.data) {
                            arr.push({
                                id: item.id,
                                name: item.name
                            })
                            obj[item.id] = item.name;
                        }
                        that.nameObj.workprocid.arr = arr;
                        that.nameObj.workprocid.obj = obj;
                    } else {
                        that.$message.error(res.message);
                    }
                });
        },
        // 获取能介(供需实际)
        getEnergyIdData () {
            let that = this
            let url = 'pass/ems/v1/trmenergys/selectNameAndId/?isreal=1';
            that.axios.get(url)
                .then(function (res) {
                    if (res.code === '0') {
                        let arr = [];
                        let obj = {};
                        for (let item of res.data) {
                            arr.push({
                                id: item.id,
                                name: item.name
                            })
                            obj[item.id] = item.name;
                        }
                        that.nameObj.energyid.arr = arr;
                        that.nameObj.energyid.obj = obj;
                    } else {
                        that.$message.error(res.message);
                    }
                });
        },
        // 获取属性
        getPropertyIdData () {
            let that = this
            let url = 'pass/ems/v1/trmenergypropertys/getidandname/';
            that.axios.get(url)
                .then(function (res) {
                    if (res.code === '0') {
                        let arr = [];
                        let obj = {};
                        for (let item of res.data) {
                            arr.push({
                                id: item.id,
                                name: item.name
                            })
                            obj[item.id] = item.name;
                        }
                        that.nameObj.propertyid.arr = arr;
                        that.nameObj.propertyid.obj = obj;
                    } else {
                        that.$message.error(res.message);
                    }
                });
        },
        // 获取标准计量单位
        getUnitIdData () {
            let that = this
            let url = 'pass/ems/v1/trmunits/getIdAndName';
            that.axios.get(url)
                .then(function (res) {
                    if (res.code === '0') {
                        let arr = [];
                        let obj = {};
                        for (let item of res.data) {
                            arr.push({
                                id: item.id,
                                name: item.name
                            })
                            obj[item.id] = item.name;
                            if (item.name === '吨') {
                                that.nameObj.unitid.defaults = that.nameObj.unitid.defaults ? that.nameObj.unitid.defaults : item.id;
                            }
                        }
                        that.nameObj.unitid.arr = arr;
                        that.nameObj.unitid.obj = obj;
                    } else {
                        that.$message.error(res.message);
                    }
                });
        },
        // 获取表格中的数据
        getTableData (pageNum) {
            let that = this,
                params = {
                    timegranid: that.filterForm.data.timegranid,
                    startDate: that.filterForm.data.clock[0] || '',
                    endDate: that.filterForm.data.clock[1] || '',
                    workprocid: that.filterForm.data.workprocid.toString(),
                    energyid: that.filterForm.data.energyid.toString(),
                    propertyid: that.filterForm.data.propertyid.toString(),
                    itemid: that.filterForm.data.itemid,
                    itemname: that.filterForm.data.itemname,
                    itemdesc: that.filterForm.data.itemdesc,
                    measureid: that.filterForm.data.measureid
                };
            that.pageNum = pageNum || that.pageNum;
            that.tableLoading = true;
            let url = 'pass/ems/v1/trmactitems/getBalanceData/?pageNum=' + that.pageNum + '&pageSize=' + that.pageSize + '&itemtype=B';
            that.axios.get(url, {
                params: params
            })
                .then(function (res) {
                    if (res.code === '0') {
                        let arr = [];
                        for (let i = 0; i < res.data.list.length; i++) {
                            let item = res.data.list[i];
                            arr.push({
                                seq: i,
                                itemid: item.ITEMID,
                                clock: item.CLOCK,
                                timegranid: item.TIMEGRANID,
                                itemname: item.ITEMNAME,
                                itemdesc: item.ITEMDESC,
                                unitid: item.UNITID,
                                actualvalue: item.ACTUALVALUE,
                                correctvalue: item.CORRECTVALUE,
                                apportvalue: item.APPORTVALUE,
                                stdvalue: item.STDVALUE,
                                sumvalue: item.SUMVALUE,
                                sumstdvalue: item.SUMSTDVALUE,
                                ucvalue: item.UCVALUE,
                                sumucvalue: item.SUMUCVALUE,
                                productvalue: item.PRODUCTVALUE,
                                rectime: item.REC_TIME,
                                workprocid: item.WORKPROCID,
                                energyid: item.ENERGYID,
                                propertyid: item.PROPERTYID,
                                seqno: item.SEQNO,
                                updateUser: item.USERID,
                                updateclock: item.UPTIME,
                                rav: item.RAV,
                                ftv: Number(item.APPORTVALUE) - Number(item.RAV),
                                showno: item.SHOWNO
                            })
                        }
                        that.tableData = arr;
                        that.total = res.data.total;
                    } else {
                        that.$message.error(res.message);
                    }
                    that.tableLoading = false;
                }).catch(function () {
                    that.tableLoading = false;
                });
        },
        // 改变表格显示条数
        tableSizeChange (val) {
            let that = this;
            that.pageSize = val;
            that.getTableData(1);
        },
        // 重置搜索
        tableDataCancel () {
            let that = this;
            that.filterForm.data.timegranid = '';
            that.filterForm.data.clock = '';
            that.filterForm.data.workprocid = '';
            that.filterForm.data.energyid = '';
            that.filterForm.data.propertyid = '';
            that.filterForm.data.itemid = '';
            that.filterForm.data.itemname = '';
            that.filterForm.data.itemdesc = '';
            that.getTableData(1);
        },
        dataSave () {
            let that = this;
            let SubmitData = {
                itemid: that.dialog.editorBox.form.data.itemid,
                clock: that.dialog.editorBox.form.data.clock,
                timegranid: that.dialog.editorBox.form.data.timegranid,
                correctvalue: that.dialog.editorBox.form.data.correctvalue,
                apportvalue: that.dialog.editorBox.form.data.apportvalue,
                fid: that.dialog.editorBox.form.data.fid
            };
            that.$refs['dialog_form'].validate((valid) => {
                if (valid) {
                    that.loading = true;
                    that.axios.put('pass/ems/v1/trmactvalues/update', SubmitData)
                        .then(function (res) {
                            if (res.code === '0') {
                                that.$message({
                                    message: '修改成功',
                                    type: 'success'
                                });
                                that.getTableData();
                            } else {
                                that.$message.error(res.message);
                            }
                            that.loading = false;
                        }).catch(function () {
                            that.loading = false;
                        });
                }
            });
        },
        // 计算最终值
        getApportvalue (ids) {
            let that = this;
            let apportvalue = that.floatComputed(that.tableFormDataObj[ids].actualvalue, that.tableFormDataObj[ids].correctvalue, '+');
            that.tableFormDataObj[ids].apportvalue = apportvalue;
        },
        // 计算修正值
        getCorrectvalue (ids) {
            let that = this;
            let correctvalue = that.floatComputed(that.tableFormDataObj[ids].apportvalue, that.tableFormDataObj[ids].actualvalue, '-');
            that.tableFormDataObj[ids].correctvalue = correctvalue;
        },
        // 批量重新计算
        but_re_compute () {
            let that = this;
            if (that.multipleSelection.length > 0) {
                that.$refs['dialog_form_arr'].validate((valid) => {
                    if (valid) {
                        let SubmitData = [];
                        for (let key in that.tableFormDataObj) {
                            SubmitData.push({
                                clock: that.tableFormDataObj[key].clock,
                                timegranid: that.tableFormDataObj[key].timegranid,
                                itemid: that.tableFormDataObj[key].itemid
                            });
                        }
                        that.loading = true;
                        that.axios.put('pass/ems/v1/trmbalancevalues/batchCompute', SubmitData)
                            .then(function (res) {
                                if (res.code === '0') {
                                    that.$message({
                                        message: '重新生成数据成功',
                                        type: 'success'
                                    });
                                    that.getTableData();
                                } else {
                                    that.$message.error(res.message);
                                }
                                that.loading = false;
                            }).catch(function () {
                                that.loading = false;
                            });
                    }
                });
            } else {
                this.$message.error('至少要选择一条数据');
            }
        },
        // 批量修改
        but_more () {
            let that = this;
            if (that.multipleSelection.length > 0) {
                that.$refs['dialog_form_arr'].validate((valid, obj) => {
                    if (valid) {
                        let SubmitData = [];
                        for (let obj in that.tableFormDataObj) {
                            SubmitData.push({
                                itemid: that.tableFormDataObj[obj].itemid,
                                clock: that.tableFormDataObj[obj].clock,
                                timegranid: that.tableFormDataObj[obj].timegranid,
                                correctvalue: that.tableFormDataObj[obj].correctvalue,
                                apportvalue: that.tableFormDataObj[obj].apportvalue,
                                actualvalue: that.tableFormDataObj[obj].actualvalue
                            })
                        }
                        that.loading = true;
                        that.axios.put('pass/ems/v1/trmbalancevalues/batchUpdate', SubmitData)
                            .then(function (res) {
                                if (res.code === '0') {
                                    that.$message({
                                        message: '修改成功',
                                        type: 'success'
                                    });
                                    that.getTableData();
                                } else {
                                    that.$message.error(res.message);
                                }
                                that.loading = false;
                            }).catch(function () {
                                that.loading = false;
                            });
                    } else {
                        let col = Object.keys(obj)[0].split('.')[1];
                        if (col && col === 'correctvalue') {
                            this.$message.error('请填写正确的修正值');
                        } else if (col && col === 'apportvalue') {
                            this.$message.error('请填写正确的最终值');
                        } else {
                            this.$message.error('数据不完整或者格式错误');
                        }
                    }
                });
            } else {
                this.$message.error('至少要选择一条数据');
            }
        },
        // 表格中多选按钮的相关方法
        handleSelectionChange (val) {
            let that = this;
            let tableFormDataObj = {};
            let arr = [];
            for (let item of val) {
                arr.push(item.seq);
            }
            this.seqArr = arr.sort(sortNumber);
            for (let item of that.tableData) {
                item.isSelection = false;
            }
            for (let item of val) {
                let obj = {};
                let xId = 's' + item.seq;
                if (that.tableFormDataObj[xId]) {
                    tableFormDataObj[xId] = that.tableFormDataObj[xId];
                } else {
                    for (let key in item) {
                        obj[key] = item[key];
                    }
                    tableFormDataObj[xId] = obj;
                }
                item.isSelection = true;
            }
            that.tableFormDataObj = tableFormDataObj;
            that.multipleSelection = val;
        },
        tableRowClassName ({row, rowIndex}) {
            // 把每一行的索引放进row
            row.index = rowIndex;
        },
        cellClick (row, column, cell, event) {
            let _this = this;
            this.rowIndex = row.index;
            this.columnId = column.id;
            _this.editSetFlag = column.id + row.index;
            _this.focusTarget = event.target;
            while (_this.focusTarget.tagName !== 'TD') {
                _this.focusTarget = _this.focusTarget.parentElement;
            }
            _this.$nextTick(() => {
                let target = this.focusTarget;
                $(target).find('input').focus();
            });
        },
        keyDown (event1) {
            let tdTarget = event1.target;
            let _this = this;
            while (tdTarget.tagName !== 'TD') {
                tdTarget = tdTarget.parentElement;
            }
            // 如果按下键盘下键或者回车键
            if (event.keyCode === 40 || event.keyCode === 13) {
                let index = parseInt(this.rowIndex);
                if (index !== this.seqArr[this.seqArr.length - 1]) {
                    for (let i = 0; i < this.seqArr.length; i++) {
                        if (index === this.seqArr[i]) {
                        index = this.seqArr[i + 1];
                        break;
                        }
                    }
                }
                this.editSetFlag = this.columnId + index;
                let id = '#' + this.editSetFlag;
                this.$nextTick(() => {
                    $(id).click();
                });
            } else if (event.keyCode === 38) { // 键盘上键
                let index = parseInt(this.rowIndex);
                if (index !== this.seqArr[0]) {
                    for (let i = 0; i < this.seqArr.length; i++) {
                        if (index === this.seqArr[i]) {
                        index = this.seqArr[i - 1];
                        break;
                        }
                    }
                }
                this.editSetFlag = this.columnId + index;
                let id = '#' + this.editSetFlag;
                this.$nextTick(() => {
                    $(id).click();
                });
            } else if (event.keyCode === 37) { // 键盘左键
                $(tdTarget).prev().click();
                $(tdTarget).prev().find('input').select();
            } else if (event.keyCode === 39) { // 键盘右键
                $(tdTarget).next().click();
                $(tdTarget).next().find('input').select();
            }
        },
      // 重新生成数据
        but_redata () {
            let that = this;
            if (!that.filterForm.data.clock || that.filterForm.data.clock.length === 0) {
                that.$message.warning('请选择日期范围');
                return true;
            }
            if (!that.filterForm.data.clock[0] || !that.filterForm.data.clock[1]) {
                that.$message.warning('请选择开始日期与结束日期');
                return true;
            }
            if (!that.filterForm.data.timegranid) {
                that.$message.warning('请选择时间粒度');
                return true;
            }
            let params = {
                timegranid: that.filterForm.data.timegranid,
                clock: that.filterForm.data.clock[0], // 开始时间
                clocke: that.filterForm.data.clock[1], // 结束时间
                workprocid: that.filterForm.data.workprocid.toString(), // 工序
                energyid: that.filterForm.data.energyid.toString(), // 能介
                propertyid: that.filterForm.data.propertyid.toString(), // 用能属性
                itemid: that.filterForm.data.itemid, // 项目编号
                itemname: that.filterForm.data.itemname, // 项目名称
                itemdesc: that.filterForm.data.itemdesc, // 项目描述
                measureid: that.filterForm.data.measureid, // 公式编号
                itemtype: 'B' // 平衡表
            };
            that.$confirm('是否重新生成数据？日期跨度不易太长！否则运行时间较长', '提示', {
                confirmButtonText: '确定',
                cancelButtonText: '取消',
                state: 'warning'
            }).then(() => {
                that.loading = true;
                let url = 'pass/ems/v1/trmactitems/reData'
                that.axios.get(url, {
                    params: params
                })
                    .then(function (res) {
                        if (res.code === '0') {
                            if (res.message && res.message !== '操作成功') {
                                that.$message.warning('重新生成数据成功, 其中【' + res.message + '】');
                            } else {
                                that.$message({
                                    message: '重新生成数据成功',
                                    type: 'success'
                                });
                            }
                            that.getTableData();
                        } else {
                            that.$message.error(res.message);
                        }
                        that.loading = false;
                    }).catch(function () {
                        that.loading = false;
                    });
            }).catch(() => {
            });
        },
          but_sdata (row) {
            let that = this;
            let params = {
                timegranid: row.timegranid,
                clock: row.clock, // 开始时间
                itemid: row.itemid // 项目编号
            };
            that.axios.get('pass/ems/v1/formulas/getAnaByVal/', {
                params: params
            }).then(function (res) {
                if (res.code === '0') {
                    that.$message({
                        message: res.data,
                        type: 'success'
                    });
                } else {
                    that.$message.error(res.message);
                }
            }).catch(function () {});
        }
    }
}
function sortNumber (a, b) {
  return a - b
}
</script>

<style lang="less">
.BalanceData {
    min-width: 700px;
    height: 100%;
    .box {
        height: 100%;
        padding: 15px 15px 0 15px;
        .box-top {
            .el-form-item {
                margin-bottom: 7px;
            }
            .box-top-gjl {
                overflow: hidden;
                padding: 7px 0;
                border-top: 1px solid #ccc;
                // margin-bottom: 6px;
            }
        }
    }
    .el-table__body .el-form-item--mini.el-form-item {
        margin: 0px;
        .error {
            overflow: hidden;
            color: #f56c6c;
            font-size: 12px;
            line-height: 1;
        }
    }
    .el-table__body input {
        font-weight: normal;
        padding-left: 8px;
        padding-right: 25px;
    }
}
</style>