表格输入框转换为科学计数法

gaoluyang

2024-07-04 7dba00a80cee072bc9e193d5d2a75c1f7cf72d28

 src/components/do/b3-work-time-management/work-time-statistics.vue

@@ -5,20 +5,24 @@
            <div class="search_label">日期：</div>
            <div class="search_input" style="display: flex;align-items: center;">
          <el-date-picker
            v-model="componentData.entity.month"
            v-model="entity.month"
            type="month"
            format="yyyy-MM"
            value-format="yyyy"
            placeholder="选择月" size="small" style="width: 100%;">
            value-format="yyyy-MM"
            placeholder="选择月" size="small" style="width: 100%;"
            :clearable="false"
            @change="refreshTable()">
          </el-date-picker>
        </div>
         </div>
         <div class="search_thing">
            <div class="search_label">员工：</div>
            <el-select v-model="componentData.entity.name" placeholder="全部" size="small" @change="refreshTable()">
            <!-- <el-select v-model="entity.name" placeholder="全部" size="small" @change="refreshTable()" clearable>
               <el-option v-for="item in personList" :key="item.id" :label="item.name" :value="item.id">
               </el-option>
            </el-select>
            </el-select> -->
        <el-input size="small" placeholder="请输入" clearable
          v-model="entity.name" @keyup.enter.native="refreshTable()"></el-input>
         </div>
         <div class="search_thing">
            <div class="search_label">部门：</div>
@@ -28,33 +32,39 @@
            </el-option>
          </el-select> -->
          <el-input size="small" placeholder="请输入" clearable
                  v-model="componentData.entity.departLims" @keyup.enter.native="refreshTable()"></el-input>
                  v-model="entity.departLims" @keyup.enter.native="refreshTable()"></el-input>
        </div>
         </div>
         <div class="search_thing" style="padding-left: 30px;width: 100px;">
         <div class="search_thing" style="padding-left: 30px;">
            <el-button size="small" @click="refresh()">重 置</el-button>
            <el-button size="small" type="primary" @click="refreshTable()">查 询</el-button>
         </div>
      <el-button size="small" type="primary" style="position: absolute;right: 50px;" @click="handleDown">导 出</el-button>
      <el-button size="small" type="primary" style="position: absolute;right: 120px;" @click="handleUp" v-show="currentTable == 'value0'">导 入</el-button>
      <div class="search_thing">
        <el-button size="small" type="primary"  @click="handleDown" v-show="currentTable == 'value0'&&down" :loading="outLoading">导 出</el-button>
        <el-button size="small" type="primary"  @click="handleUp" v-show="currentTable == 'value1'&&up">导 入</el-button>
      </div>
      </div>
    <el-radio-group v-model="currentTable" size="small" :key="'111'" style="margin-top: 10px;">
      <el-radio-button label="value0">
        原始工时
      </el-radio-button>
      <el-radio-button label="value1">
        修正工时
      </el-radio-button>
    </el-radio-group>
    <div style="text-align: left">
      <el-radio-group v-model="currentTable" size="small" :key="'111'" style="margin-top: 10px;">
        <el-radio-button label="value0">
          原始工时
        </el-radio-button>
        <el-radio-button label="value1">
          修正工时
        </el-radio-button>
      </el-radio-group>
    </div>
    <div class="table">
      <ValueTable ref="ValueTable0"
        v-show="currentTable == 'value0'"
            :url="$api.auxiliaryWorkingHours.selectAuxiliaryWorkingHours"
            :componentData="componentData" :inputUrl="$api.auxiliaryWorkingHours.selectAuxiliaryWorkingHours" :downUrl="$api.auxiliaryWorkingHours.selectAuxiliaryWorkingHours" :key="upIndex" />
        v-if="currentTable == 'value0'"
            :url="$api.auxiliaryOriginalHours.selectAuxiliaryOriginalHours"
            :componentData="componentData" :key="upIndex" />
      <ValueTable ref="ValueTable1"
        v-if="currentTable == 'value1'"
            :url="$api.auxiliaryCorrectionHours.selectAuxiliaryCorrectionHours"
            :componentData="componentData0" :key="upIndex" />
        :inputUrl="$api.auxiliaryCorrectionHours.upload"
            :componentData="componentData0"
        :key="upIndex1" />
    </div>
  </div>
</template>
@@ -70,54 +80,28 @@
  },
  data () {
    return{
      down:false,
      up:false,
      componentData: {
               entity: {
                  month: null,
                  month: getYearAndMonthAndDays().split('-')[0]+'-'+getYearAndMonthAndDays().split('-')[1],
                  name: null,
                  departLims: null,
                  orderBy: {
                     field: 'id',
                     order: 'desc'
                  }
               },
               isIndex: true,
               showSelect: false,
               select: false,
               do: [],
               tagField: {
                  deviceStatus: {
                     select: []
                  },
                  equipmentManager: {
                     select: []
                  },
                  authorizedPerson: {
                     select: []
                  },
            insProductIds:{
              select:[]
            }
               },
               linkEvent: {
                  deviceName: {
                     method: 'selectAllByOne'
                  }
               },
               selectField: {
                  authorizedPerson: {
                     select: [],
                     choose: true
                  },
                  equipmentManager: {
                     select: []
                  },
            insProductIds:{
              select:[],
              choose: true
            }
               },
               tagField: {},
               linkEvent: {},
               selectField: {},
               requiredAdd: [],
               requiredUp: []
               requiredUp: [],
          accept: '.xlsx',
          inputType: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
          cellSpecialStyle:{
            redColorByKey:'Hours'
          }
         },
      componentData0: {
               entity: {
@@ -133,57 +117,61 @@
               showSelect: false,
               select: false,
               do: [],
               tagField: {
                  deviceStatus: {
                     select: []
                  },
                  equipmentManager: {
                     select: []
                  },
                  authorizedPerson: {
                     select: []
                  },
            insProductIds:{
              select:[]
            }
               },
               tagField: {},
               linkEvent: {
                  deviceName: {
                     method: 'selectAllByOne'
                  }
               },
               selectField: {
                  authorizedPerson: {
                     select: [],
                     choose: true
                  },
                  equipmentManager: {
                     select: []
                  },
            insProductIds:{
              select:[],
              choose: true
            }
               },
               selectField: {},
               requiredAdd: [],
               requiredUp: []
               requiredUp: [],
          accept: '.xlsx',
          inputType: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
         },
      entity:{},
      entity:{
        month:getYearAndMonthAndDays(),
        name:'',
        departLims:''
      },
      entityCopy:{},
      entityCopy0:{},
      upIndex:0,
      upIndex1:100,
      weekList:[],
      personList:[],
      currentTable:'value0'
      currentTable:'value0',
      outLoading:false
    }
  },
  mounted(){
    this.getUsers()
    this.entityCopy = this.HaveJson(this.componentData.entity);
    this.entityCopy0 = this.HaveJson(this.componentData0.entity);
    this.getPower()
  },
  methods: {
    getYearAndMonthAndDays(date){
      return getYearAndMonthAndDays(date)
    refresh(){
      this.entity = {
        month:getYearAndMonthAndDays()
      }
      if(this.currentTable=='value0'){
        this.componentData.entity = this.HaveJson(this.entityCopy)
        this.upIndex++
      }else{
        this.componentData0.entity = this.HaveJson(this.entityCopy0)
        this.upIndex1++
      }
      this.refreshTable()
    },
    refresh(){},
    refreshTable(){},
    refreshTable(){
      let entity = {...this.entity}
      entity.month = entity.month.split('-')[0]+'-'+entity.month.split('-')[1]
      if(this.currentTable=='value0'){
        this.componentData.entity = {...this.componentData.entity,...entity}
        this.$refs['ValueTable0'].selectList()
      }else{
        this.componentData0.entity = {...this.componentData0.entity,...entity}
        this.$refs['ValueTable1'].selectList()
      }
    },
    getUsers(){
      this.$axios.post(this.$api.user.selectUserList, {
               page: {
@@ -206,14 +194,41 @@
        })
    },
    handleDown(){
      if(this.currentTable == 'value0'){
        this.$refs.ValueTable0.downFile(false)
      }else{
        this.$refs.ValueTable1.downFile(false)
      }
      // this.$refs.ValueTable0.downFile(false)
      let entity = {...this.entity}
      entity.month = entity.month.split('-')[0]+'-'+entity.month.split('-')[1]
      this.outLoading = true
      this.$axios.post(this.$api.auxiliaryOriginalHours.exportOriginalHours,{
        ...entity
        // params:entity,
      },{responseType: "blob"}).then(res => {
        this.outLoading = false
        this.$message.success('导出成功')
        const blob = new Blob([res],{ type: 'application/octet-stream' });
        const url = URL.createObjectURL(blob);
        const link = document.createElement('a');
        link.href = url;
        link.download = entity.month+'工时统计表.xlsx';
        link.click();
      })
    },
    handleUp(){
      this.$refs.ValueTable0.openUpload()
      this.$refs.ValueTable1.openUpload()
    },
    getPower(){
      let power = JSON.parse(sessionStorage.getItem('power'))
        let up = false
        let down = false
        for (var i = 0; i < power.length; i++) {
               if (power[i].menuMethod == 'exportOriginalHours') {
                  down = true
               }
               if (power[i].menuMethod == 'upload') {
                  up = true
               }
            }
        this.down = down
        this.up = up
    }
  }
}