设备台账导出

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"
@@ -686,7 +718,6 @@
      <a-tab-pane
        tab="设备文档"
        key="1"
        forceRender
      >
        <EquipmentDocumentList :mainId="selectedMainId" />
      </a-tab-pane>
@@ -713,28 +744,24 @@
      <a-tab-pane
        tab="备件"
        key="4"
        forceRender
      >
        <EquipmentSpareParts :mainId="selectedMainId" />
      </a-tab-pane>
      <a-tab-pane
        tab="ABC标识变更记录"
        key="5"
        forceRender
      >
        <equipment-update-ABC-list :mainId="selectedMainId" />
      </a-tab-pane>
      <a-tab-pane
        tab="质保期变更"
        key="6"
        forceRender
      >
        <equipment-update-warranty-list :mainId="selectedMainId" />
      </a-tab-pane>
      <a-tab-pane
        tab="点检标准"
        key="7"
        forceRender
      >
        <daily-maintenance-list :mainId="selectedMainId"></daily-maintenance-list>
      </a-tab-pane>
@@ -742,23 +769,44 @@
      <a-tab-pane
        tab="二保标准"
        key="8"
        forceRender
      >
        <second-maintenance-list :mainId="selectedMainId"></second-maintenance-list>
      </a-tab-pane>
      <a-tab-pane
        tab="三保标准"
        key="9"
        forceRender
      >
        <third-maintenance-list :mainId="selectedMainId"></third-maintenance-list>
      </a-tab-pane>
      <a-tab-pane
        tab="点检工单"
        key="10"
        forceRender
      >
        <daily-inspection-order-list-component :mainId="selectedMainId"></daily-inspection-order-list-component>
      </a-tab-pane>
      <a-tab-pane
        tab="二保工单"
        key="11"
      >
        <daily-maintenance-order-list-component :mainId="selectedMainId"></daily-maintenance-order-list-component>
      </a-tab-pane>
      <a-tab-pane
        tab="三保工单"
        key="12"
      >
        <daily3-maintenance-order-list-component :mainId="selectedMainId"></daily3-maintenance-order-list-component>
      </a-tab-pane>
      <a-tab-pane
        tab="维修工单"
        key="13"
      >
        <repair-order-list-component :mainId="selectedMainId"></repair-order-list-component>
      </a-tab-pane>
      <a-tab-pane
        tab="技术状态鉴定"
        key="14"
      >
        <equipment-calibration-order-component :mainId="selectedMainId"></equipment-calibration-order-component>
      </a-tab-pane>
    </a-tabs>
    <equipment-modal
@@ -817,6 +865,10 @@
import ThirdMaintenanceList from './modules/equipmentNew/ThirdMaintenanceList.vue'
import KeyEquipmentUpdateModel from './modules/equipmentNew/edit/KeyEquipmentUpdateModel.vue'
import DailyInspectionOrderListComponent from './modules/equipmentNew/DailyInspectionOrderListComponent.vue'
import DailyMaintenanceOrderListComponent from './modules/equipmentNew/DailyMaintenanceOrderListComponent.vue'
import Daily3MaintenanceOrderListComponent from './modules/equipmentNew/Daily3MaintenanceOrderListComponent.vue'
import RepairOrderListComponent from './modules/equipmentNew/RepairOrderListComponent.vue'
import EquipmentCalibrationOrderComponent from './modules/equipmentNew/EquipmentCalibrationOrderComponent.vue'

export default {
  name: "EquipmentList",
@@ -844,11 +896,21 @@
    KeyEquipmentUpdateModel,
    JEllipsis,
    DailyInspectionOrderListComponent,
    DailyMaintenanceOrderListComponent,
    Daily3MaintenanceOrderListComponent,
    RepairOrderListComponent,
    EquipmentCalibrationOrderComponent,
  },
  props: {
    caytegoryParam: {
      type: String,
      default: 'all',
      required: true,
    },
  },
  data() {
    return {
      description: '设备台账管理页面',
      caytegoryParam: 'all',
      // 表头
      columns: [
        {
@@ -929,7 +991,7 @@
        {
          title: '冷却系统',
          align: "center",
          dataIndex: 'coolingSystem',
          dataIndex: 'coolingSystem_dictText',
        },
        {
          title: '灭火器',
@@ -944,7 +1006,7 @@
        {
          title: '操作系统',
          align: "center",
          dataIndex: 'operatingSystem',
          dataIndex: 'operatingSystem_dictText',
        },
        {
          title: '系统',
@@ -980,7 +1042,7 @@
        {
          title: '重量计量单位',
          align: "center",
          dataIndex: 'equipmentUda4_dictText',
          dataIndex: 'equipmentUda4',
        },
        {
          title: '功能位置',
@@ -990,7 +1052,7 @@
        {
          title: '安装位置',
          align: "center",
          dataIndex: 'equipmentUda2',
          dataIndex: 'location',
        },
        {
          title: '出厂日期',
@@ -1015,7 +1077,7 @@
        {
          title: '出厂编号',
          align: "center",
          dataIndex: 'factoryNo',
          dataIndex: 'factoryNumber',
        },
        {
          title: '资产制造商',
@@ -1108,7 +1170,7 @@
          dataIndex: 'lineId_dictText',
        },
        {
          title: '主设备?',
          title: '主设备',
          align: "center",
          dataIndex: 'isMeta_dictText',
        },
@@ -1173,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',
@@ -1267,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) {
@@ -1410,6 +1475,11 @@
              }
            })
          }
          else {
            this.$message.warning('未查询到有效模板')
          }
        } else {
          this.$message.warning('未查询到有效模板')
        }
      })
    },