设备台账导出

qushaowei

2025-06-04 aa3a264ebddd490fb9d830c6fadc8efb76d649a9

 src/views/eam/EquipmentListOfAll.vue

@@ -13,10 +13,12 @@
          :gutter="24"
          style="margin-bottom: 1%;"
        >
          <a-col :xl='6'
                :lg='7'
                :md='8'
                :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="统一编码群"
              :labelCol="labelCol"
@@ -29,26 +31,30 @@
              ></a-textarea>
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="设备所属分类"
              :labelCol="labelCol"
              :wrapperCol="wrapperCol"
            >
              <j-dict-select-tag
                dictCode="mom_eam_equipment_category,name,id,del_flag!='1'"
                :dictCode="caytegoryParam==='all'?'mom_eam_equipment_category,name,id,del_flag!=\'1\'':'mom_eam_equipment_category,name,id,equipment_category_uda1 = '+'\''+caytegoryParam+'\''"
                placeholder="请输入搜索条件并选择"
                v-model="queryParam.equipmentCategoryId"
              />
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              :labelCol="labelCol"
              :wrapperCol="wrapperCol"
@@ -60,10 +66,12 @@
              ></a-input>
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              :labelCol="labelCol"
              :wrapperCol="wrapperCol"
@@ -75,10 +83,12 @@
              ></a-input>
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="型号"
              :labelCol="labelCol"
@@ -91,10 +101,12 @@
            </a-form-item>
          </a-col>

          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="工区"
              :labelCol="labelCol"
@@ -124,10 +136,12 @@
              />
            </a-form-item>
          </a-col> -->
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="维护部门"
              :labelCol="labelCol"
@@ -148,10 +162,12 @@
              />
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="使用部门"
              :labelCol="labelCol"
@@ -172,10 +188,12 @@
              />
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="是否生产线设备"
              :labelCol="labelCol"
@@ -190,10 +208,12 @@
              />
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="ABC标识"
              :labelCol="labelCol"
@@ -208,10 +228,12 @@
              />
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="技术状态"
              :labelCol="labelCol"
@@ -226,10 +248,12 @@
              />
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="设备状态"
              :labelCol="labelCol"
@@ -244,10 +268,12 @@
              />
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="关键设备标识"
              :labelCol="labelCol"
@@ -262,10 +288,12 @@
              />
            </a-form-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-model-item
              label="质保开始日期"
              :labelCol="labelCol"
@@ -279,10 +307,12 @@
              ></j-date>
            </a-form-model-item>
          </a-col>
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-model-item
              label="质保结束日期"
              :labelCol="labelCol"
@@ -297,10 +327,12 @@
            </a-form-model-item>
          </a-col>
          <!-- 按维修班组检索 -->
          <a-col :xl='6'
                 :lg='7'
                 :md='8'
                 :sm='24'>
          <a-col
            :xl='6'
            :lg='7'
            :md='8'
            :sm='24'
          >
            <a-form-item
              label="维修班组"
              :labelCol="labelCol"
@@ -869,10 +901,16 @@
    RepairOrderListComponent,
    EquipmentCalibrationOrderComponent,
  },
  props: {
    caytegoryParam: {
      type: String,
      default: 'all',
      required: true,
    },
  },
  data() {
    return {
      description: '设备台账管理页面',
      caytegoryParam: 'all',
      // 表头
      columns: [
        {
@@ -953,7 +991,7 @@
        {
          title: '冷却系统',
          align: "center",
          dataIndex: 'coolingSystem',
          dataIndex: 'coolingSystem_dictText',
        },
        {
          title: '灭火器',
@@ -968,7 +1006,7 @@
        {
          title: '操作系统',
          align: "center",
          dataIndex: 'operatingSystem',
          dataIndex: 'operatingSystem_dictText',
        },
        {
          title: '系统',
@@ -1004,7 +1042,7 @@
        {
          title: '重量计量单位',
          align: "center",
          dataIndex: 'equipmentUda4_dictText',
          dataIndex: 'equipmentUda4',
        },
        {
          title: '功能位置',
@@ -1014,7 +1052,7 @@
        {
          title: '安装位置',
          align: "center",
          dataIndex: 'equipmentUda2',
          dataIndex: 'location',
        },
        {
          title: '出厂日期',
@@ -1039,7 +1077,7 @@
        {
          title: '出厂编号',
          align: "center",
          dataIndex: 'factoryNo',
          dataIndex: 'factoryNumber',
        },
        {
          title: '资产制造商',
@@ -1132,7 +1170,7 @@
          dataIndex: 'lineId_dictText',
        },
        {
          title: '主设备?',
          title: '主设备',
          align: "center",
          dataIndex: 'isMeta_dictText',
        },
@@ -1197,7 +1235,7 @@
        delete: "/eam/equipment/delete",
        deleteBatch: "/eam/equipment/deleteBatch",
        active: "/eam/equipment/active",
        exportXlsUrl: '/eam/equipment/exportXls',
        exportXlsUrl: '/eam/equipment/exportXlsNew',
        importExcelUrl: "/eam/equipment/importExcel",
        loadOptions: '/sys/sysDepart/loadDepartTreeOptions',
        uploadList: '/sys/upload/list',
@@ -1291,7 +1329,10 @@
        this.ipagination.current = 1;
      }
      this.onClearSelected()
      var params = this.getQueryParams();//查询条件
      if (this.caytegoryParam !== 'all') {
        this.queryParam.equipmentCategoryUda1 = this.caytegoryParam;
      }
      let params = this.getQueryParams();//查询条件
      this.loading = true;
      getAction(this.url.list, params).then((res) => {
        if (res.success) {
@@ -1434,6 +1475,11 @@
              }
            })
          }
          else {
            this.$message.warning('未查询到有效模板')
          }
        } else {
          this.$message.warning('未查询到有效模板')
        }
      })
    },