设备台账导出

qushaowei

2025-06-04 aa3a264ebddd490fb9d830c6fadc8efb76d649a9

 src/views/eam/EquipmentListOfAll.vue

@@ -13,12 +13,14 @@
          :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="统一编号群"
              label="统一编码群"
              :labelCol="labelCol"
              :wrapperCol="wrapperCol"
            >
@@ -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"
@@ -371,6 +403,13 @@
        icon="calendar"
        v-has="'equipmentAccount:add&delete&import&Edit'"
      >质保期变更</a-button>
      <a-button
        :disabled="selectedRowKeys.length==0"
        @click="batchDel"
        type="danger"
        icon="delete"
        v-has="'equipmentAccount:add&delete&import&Edit'"
      >批量删除</a-button>
      <a-button
        @click="handleUpdateKeyEquipment"
        type="primary"
@@ -558,6 +597,51 @@
            :length="8"
          />
        </span>
        <span
          slot="yseNoInspectionStandard"
          slot-scope="text"
        >
          <a-icon
            type="check"
            style="color: chartreuse;"
            v-if="text==='0'"
          />
          <a-icon
            type="close"
            v-else
            style="color:red;"
          />
        </span>
        <span
          slot="yseNoMaintenance2Standard"
          slot-scope="text"
        >
          <a-icon
            type="check"
            style="color: chartreuse;"
            v-if="text==='0'"
          />
          <a-icon
            type="close"
            v-else
            style="color:red;"
          />
        </span>
        <span
          slot="yseNoMaintenance3Standard"
          slot-scope="text"
        >
          <a-icon
            type="check"
            style="color: chartreuse;"
            v-if="text==='0'"
          />
          <a-icon
            type="close"
            v-else
            style="color:red;"
          />
        </span>

        <template
          slot="num"
@@ -632,8 +716,15 @@

    <a-tabs defaultActiveKey="1">
      <a-tab-pane
        tab="工艺参数"
        tab="设备文档"
        key="1"
      >
        <EquipmentDocumentList :mainId="selectedMainId" />
      </a-tab-pane>
      <a-tab-pane
        tab="工艺参数"
        key="2"
        v-if="isOpenProcess"
      >
        <EquipmentProcessParametersList
          :mainId="selectedMainId"
@@ -642,8 +733,8 @@
      </a-tab-pane>
      <a-tab-pane
        tab="设备精度"
        key="2"
        forceRender
        key="3"
        v-if="isOpenPrecision"
      >
        <EquipmentPrecisionParametersList
          :isOpen="isOpenPrecision"
@@ -651,53 +742,71 @@
        />
      </a-tab-pane>
      <a-tab-pane
        tab="设备文档"
        key="3"
        forceRender
      >
        <EquipmentDocumentList :mainId="selectedMainId" />
      </a-tab-pane>
      <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="日保标准"
        tab="点检标准"
        key="7"
        forceRender
      >
        <daily-maintenance-list :mainId="selectedMainId"></daily-maintenance-list>
      </a-tab-pane>

      <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"
      >
        <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
@@ -734,7 +843,7 @@
import { mixinDevice } from '@/utils/mixin'
import JEllipsis from '@/components/jeecg/JEllipsis'
import EquipmentModal from './modules/equipmentNew/EquipmentModal'
import { getAction, downFile } from '@/api/manage'
import { getAction, downFile, deleteAction } from '@/api/manage'
import EquipmentProcessParametersList from './modules/equipmentNew/EquipmentProcessParametersList'
import EquipmentDocumentList from './modules/equipmentNew/EquipmentDocumentList'
import EquipmentPrecisionParametersList from './modules/equipmentNew/EquipmentPrecisionParametersList'
@@ -755,6 +864,11 @@
import SecondMaintenanceList from './modules/equipmentNew/SecondMaintenanceList.vue'
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",
@@ -781,11 +895,22 @@
    ThirdMaintenanceList,
    KeyEquipmentUpdateModel,
    JEllipsis,
    DailyInspectionOrderListComponent,
    DailyMaintenanceOrderListComponent,
    Daily3MaintenanceOrderListComponent,
    RepairOrderListComponent,
    EquipmentCalibrationOrderComponent,
  },
  props: {
    caytegoryParam: {
      type: String,
      default: 'all',
      required: true,
    },
  },
  data() {
    return {
      description: '设备台账管理页面',
      caytegoryParam: 'all',
      // 表头
      columns: [
        {
@@ -797,16 +922,61 @@
            return parseInt(index) + 1
          },
          width: 50,
          fixed: 'left',
        },
        {
          title: '设备类型',
          title: '统一编码',
          align: "center",
          dataIndex: 'num',
          scopedSlots: { customRender: 'num' },
          fixed: 'left',
        },
        {
          title: '设备名称',
          align: "center",
          dataIndex: 'name',
          scopedSlots: { customRender: 'name' },
          fixed: 'left',
        },
        {
          title: '使用部门',
          align: "center",
          dataIndex: 'useId_dictText',
        },
        {
          title: '中心',
          align: "center",
          dataIndex: 'workCenterId_dictText',
        },
        {
          title: '工区',
          align: "center",
          dataIndex: 'factoryModelId_dictText',
        },
        {
          title: '工段',
          align: "center",
          dataIndex: 'areaId_dictText',
        },
        {
          title: '维护部门',
          align: "center",
          dataIndex: 'manageId_dictText',
        },
        {
          title: '维修班组',
          align: "center",
          dataIndex: 'teamId_dictText',
        },
        {
          title: '设备所属分类',
          align: "center",
          dataIndex: 'equipmentCategoryId_dictText',
        },
        {
          title: '是否生产线设备',
          title: 'ABC标识',
          align: "center",
          dataIndex: 'isLineEquip_dictText',
          dataIndex: 'equipmentImportanceId',
        },
        {
          title: '关键设备标识',
@@ -814,16 +984,110 @@
          dataIndex: 'specificEquipment_dictText',
        },
        {
          title: '统一编码',
          title: '安全配置',
          align: "center",
          dataIndex: 'num',
          scopedSlots: { customRender: 'num' },
          dataIndex: 'securityConfiguration',
        },
        {
          title: '设备名称',
          title: '冷却系统',
          align: "center",
          dataIndex: 'name',
          scopedSlots: { customRender: 'name' },
          dataIndex: 'coolingSystem_dictText',
        },
        {
          title: '灭火器',
          align: "center",
          dataIndex: 'fireExtinguisher',
        },
        {
          title: '灭火器有效期',
          align: "center",
          dataIndex: 'fireExtinguisherValidityPeriod',
        },
        {
          title: '操作系统',
          align: "center",
          dataIndex: 'operatingSystem_dictText',
        },
        {
          title: '系统',
          align: "center",
          dataIndex: 'system',
        },
        {
          title: '设备端口',
          align: "center",
          dataIndex: 'port',
        },
        {
          title: '坐标数量',
          align: "center",
          dataIndex: 'coordinateNum',
        },
        {
          title: '设备状态',
          align: "center",
          dataIndex: 'equipmentStatus_dictText',
        },
        {
          title: '技术状态',
          align: "center",
          dataIndex: 'technologyStatus_dictText',
          scopedSlots: { customRender: 'technologyStatus' },
        },
        {
          title: '重量',
          align: "center",
          dataIndex: 'equipmentUda3',
        },
        {
          title: '重量计量单位',
          align: "center",
          dataIndex: 'equipmentUda4',
        },
        {
          title: '功能位置',
          align: "center",
          dataIndex: 'equipmentUda5',
        },
        {
          title: '安装位置',
          align: "center",
          dataIndex: 'location',
        },
        {
          title: '出厂日期',
          align: "center",
          dataIndex: 'leaveFactoryDate',
        },
        {
          title: '立项卡号',
          align: "center",
          dataIndex: 'projectApprovalNo',
        },
        {
          title: '资金来源',
          align: "center",
          dataIndex: 'fundSource',
        },
        {
          title: '验收日期',
          align: "center",
          dataIndex: 'acceptanceCheckDate',
        },
        {
          title: '出厂编号',
          align: "center",
          dataIndex: 'factoryNumber',
        },
        {
          title: '资产制造商',
          align: "center",
          dataIndex: 'constructorId_dictText',
        },
        {
          title: '资产的来源国家',
          align: "center",
          dataIndex: 'sourceCountry',
        },
        {
          title: '型号',
@@ -831,7 +1095,7 @@
          dataIndex: 'model',
        },
        {
          title: '规格',
          title: '设备规格',
          align: "center",
          dataIndex: 'specification',
        },
@@ -841,31 +1105,49 @@
          dataIndex: 'gpo',
        },
        {
          title: '使用部门',
          title: '创建人',
          align: "center",
          dataIndex: 'useId_dictText',
          dataIndex: 'createBy'
        },
        // {
        //   title: '维护部门',
        //   align: "center",
        //   dataIndex: 'manageId_dictText',
        // },
        // {
        //   title: '维修班组',
        //   align: "center",
        //   dataIndex: 'teamId_dictText',
        // },
        {
          title: 'ABC标识',
          title: '创建时间',
          align: "center",
          dataIndex: 'equipmentImportanceId',
          dataIndex: 'createTime',
        },

        {
          title: '技术状态',
          title: '更新人',
          align: "center",
          dataIndex: 'technologyStatus_dictText',
          scopedSlots: { customRender: 'technologyStatus' },
          dataIndex: 'updateBy'
        },
        {
          title: '更新时间',
          align: "center",
          dataIndex: 'updateTime',
        },
        {
          title: '质保开始日期',
          align: "center",
          dataIndex: 'warrantyStart'
        },
        {
          title: '质保结束日期',
          align: "center",
          dataIndex: 'warrantyEnd',
        },
        {
          title: '资产状态',
          align: "center",
          dataIndex: 'propertyStatus_dictText',
        },
        {
          title: '三保日期',
          align: "center",
          dataIndex: 'thirdMaintenanceTime',
        },
        {
          title: '技术鉴定日期',
          align: "center",
          dataIndex: 'technologyStatusQualificationTime',
        },
        {
          title: '技术状态鉴定类型',
@@ -878,112 +1160,20 @@
          dataIndex: 'nextTechnologyStatusQualificationTime',
        },
        {
          title: '是否生产线设备',
          align: "center",
          dataIndex: 'isLineEquip_dictText',
        },
        {
          title: '生产线编号',
          align: "center",
          dataIndex: 'lineId_dictText',
        },
        {
          title: '主设备?',
          title: '主设备',
          align: "center",
          dataIndex: 'isMeta_dictText',
        },
        // {
        //   title: '安全配置',
        //   align: "center",
        //   dataIndex: 'securityConfiguration',
        // },
        // {
        //   title: '冷却系统',
        //   align: "center",
        //   dataIndex: 'coolingSystem',
        // },
        // {
        //   title: '灭火器',
        //   align: "center",
        //   dataIndex: 'fireExtinguisher',
        // },


        // {
        //   title: '操作系统',
        //   align: "center",
        //   dataIndex: 'operatingSystem',
        // },
        // {
        //   title: '系统',
        //   align: "center",
        //   dataIndex: 'system',
        // },
        // {
        //   title: '设备端口',
        //   align: "center",
        //   dataIndex: 'port',
        // },
        // {
        //   title: '坐标数量',
        //   align: "center",
        //   dataIndex: 'coordinateNum',
        // },
        // {
        //   title: '设备状态',
        //   align: "center",
        //   dataIndex: 'equipmentStatus_dictText',
        // },
        // {
        //   title: '重量',
        //   align: "center",
        //   dataIndex: 'equipmentUda3',
        // },
        // {
        //   title: '重量计量单位',
        //   align: "center",
        //   dataIndex: 'equipmentUda4_dictText',
        // },
        // {
        //   title: '功能位置',
        //   align: "center",
        //   dataIndex: 'equipmentUda5',
        // },
        // {
        //   title: '安装位置',
        //   align: "center",
        //   dataIndex: 'equipmentUda2',
        // },
        // {
        //   title: '出厂日期',
        //   align: "center",
        //   dataIndex: 'leaveFactoryDate',
        // },
        // {
        //   title: '立项卡号',
        //   align: "center",
        //   dataIndex: 'projectApprovalNo',
        // },
        // {
        //   title: '资金来源',
        //   align: "center",
        //   dataIndex: 'fundSource',
        // },
        // {
        //   title: '验收日期',
        //   align: "center",
        //   dataIndex: 'acceptanceCheckDate',
        // },
        // {
        //   title: '出厂编号',
        //   align: "center",
        //   dataIndex: 'factoryNo',
        // },
        // {
        //   title: '资产制造商',
        //   align: "center",
        //   dataIndex: 'constructorId_dictText',
        // },
        // {
        //   title: '资产的来源国家',
        //   align: "center",
        //   dataIndex: 'sourceCountry',
        // }, 
        {
          title: '工艺参数管理',
          align: "center",
@@ -1006,6 +1196,24 @@
          align: "center",
          dataIndex: 'precisionParametersTemplateId_dictText',
        },
        {
          title: '有无点检标准',
          align: "center",
          dataIndex: 'yseNoInspectionStandard',
          scopedSlots: { customRender: 'yseNoInspectionStandard' }
        },
        {
          title: '有无二保标准',
          align: "center",
          dataIndex: 'yseNoMaintenance2Standard',
          scopedSlots: { customRender: 'yseNoMaintenance2Standard' }
        },
        {
          title: '有无三保标准',
          align: "center",
          dataIndex: 'yseNoMaintenance3Standard',
          scopedSlots: { customRender: 'yseNoMaintenance3Standard' }
        },
        // {
        //   title: '备注',
        //   align: "center",
@@ -1027,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',
@@ -1099,7 +1307,7 @@
      this.selectedMainId = ''
    },
    onSelectChange(selectedRowKeys, selectionRows) {
      if (selectedRowKeys.length == 1) {
      if (selectedRowKeys.length >= 1) {
        this.selectedMainId = selectedRowKeys[0]
        this.precisionParametersTemplateId = selectionRows[0].precisionParametersTemplateId;
        this.isOpenProcess = selectionRows[0].processParameters == 1;
@@ -1121,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) {
@@ -1264,6 +1475,11 @@
              }
            })
          }
          else {
            this.$message.warning('未查询到有效模板')
          }
        } else {
          this.$message.warning('未查询到有效模板')
        }
      })
    },