-拧紧数据

admin

2024-11-22 20c287a2d82d0e28a3f5ec6e6235a95b21f48907

-拧紧数据

 billion-main/src/main/java/com/billion/main/da/controller/DaTightenCollectionController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.billion.main.da.controller;

import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.billion.common.annotation.Log;
import com.billion.common.core.controller.BaseController;
import com.billion.common.core.domain.AjaxResult;
import com.billion.common.enums.BusinessType;
import com.billion.main.da.domain.DaTightenCollection;
import com.billion.main.da.service.IDaTightenCollectionService;
import com.billion.common.utils.poi.ExcelUtil;
import com.billion.common.core.page.TableDataInfo;

/**
 * æ‹§ç´§é‡‡é›†Controller
 * 
 * @author Billion-Yi
 * @date 2024-11-22
 */
@RestController
@RequestMapping("/da/tightenCollection")
public class DaTightenCollectionController extends BaseController
{
    @Autowired
    private IDaTightenCollectionService daTightenCollectionService;

    /**
     * æŸ¥è¯¢æ‹§ç´§é‡‡é›†åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('da:tightenCollection:list')")
    @GetMapping("/list")
    public TableDataInfo list(DaTightenCollection daTightenCollection)
    {
        startPage();
        List<DaTightenCollection> list = daTightenCollectionService.selectDaTightenCollectionList(daTightenCollection);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ‹§ç´§é‡‡é›†åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('da:tightenCollection:export')")
    @Log(title = "拧紧采集", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, DaTightenCollection daTightenCollection)
    {
        List<DaTightenCollection> list = daTightenCollectionService.selectDaTightenCollectionList(daTightenCollection);
        ExcelUtil<DaTightenCollection> util = new ExcelUtil<DaTightenCollection>(DaTightenCollection.class);
        util.exportExcel(response, list, "拧紧采集数据");
    }

    /**
     * èŽ·å–拧紧采集详细信息
     */
    @PreAuthorize("@ss.hasPermi('da:tightenCollection:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(daTightenCollectionService.selectDaTightenCollectionById(id));
    }

    /**
     * æ–°å¢žæ‹§ç´§é‡‡é›†
     */
    @PreAuthorize("@ss.hasPermi('da:tightenCollection:add')")
    @Log(title = "拧紧采集", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody DaTightenCollection daTightenCollection)
    {
        return toAjax(daTightenCollectionService.insertDaTightenCollection(daTightenCollection));
    }

    /**
     * ä¿®æ”¹æ‹§ç´§é‡‡é›†
     */
    @PreAuthorize("@ss.hasPermi('da:tightenCollection:edit')")
    @Log(title = "拧紧采集", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody DaTightenCollection daTightenCollection)
    {
        return toAjax(daTightenCollectionService.updateDaTightenCollection(daTightenCollection));
    }

    /**
     * åˆ é™¤æ‹§ç´§é‡‡é›†
     */
    @PreAuthorize("@ss.hasPermi('da:tightenCollection:remove')")
    @Log(title = "拧紧采集", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(daTightenCollectionService.deleteDaTightenCollectionByIds(ids));
    }
}

 billion-main/src/main/java/com/billion/main/da/domain/DaParamCollection.java

@@ -52,5 +52,11 @@
    @TableField(exist = false)
    private String[] timeQuery;

    @TableField(exist = false)
    private String startTime;

    @TableField(exist = false)
    private String stopTime;


}

 billion-main/src/main/java/com/billion/main/da/domain/DaTightenCollection.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.billion.main.da.domain;

import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.billion.common.annotation.Excel;
import com.billion.main.common.BaseEntity;

/**
 * æ‹§ç´§é‡‡é›†å¯¹è±¡ da_tighten_collection
 * 
 * @author Billion-Yi
 * @date 2024-11-22
 */
@Data
public class DaTightenCollection extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”®id */
    private Long id;

    /** æ€»æˆåºåˆ—号 */
    @Excel(name = "总成序列号")
    private String sfcCode;

    /** å·¥ä½ç¼–码 */
    @Excel(name = "工位编码")
    private String locationCode;

    /** å‚数集编码 */
    @Excel(name = "参数集编码")
    private String paramSetCode;

    /** å‚数集名称 */
    @Excel(name = "参数集名称")
    private String paramSetName;

    /** æ‰­çŸ©å€¼ */
    @Excel(name = "扭矩值")
    private String torque;

    /** æ‰­çŸ©çŠ¶æ€ */
    @Excel(name = "扭矩状态")
    private String torqueStatus;

    /** è§’度值 */
    @Excel(name = "角度值")
    private String angle;

    /** è§’度状态 */
    @Excel(name = "角度状态")
    private String angleStatus;

    /** é‡‡é›†æ—¶é—´ */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "采集时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date collectTime;


}

 billion-main/src/main/java/com/billion/main/da/mapper/DaTightenCollectionMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.billion.main.da.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.billion.main.da.domain.DaTightenCollection;

/**
 * æ‹§ç´§é‡‡é›†Mapper接口
 * 
 * @author Billion-Yi
 * @date 2024-11-22
 */
public interface DaTightenCollectionMapper extends BaseMapper<DaTightenCollection>
{
    /**
     * æŸ¥è¯¢æ‹§ç´§é‡‡é›†
     * 
     * @param id æ‹§ç´§é‡‡é›†ä¸»é”®
     * @return æ‹§ç´§é‡‡é›†
     */
    public DaTightenCollection selectDaTightenCollectionById(Long id);

    /**
     * æŸ¥è¯¢æ‹§ç´§é‡‡é›†åˆ—表
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return æ‹§ç´§é‡‡é›†é›†åˆ
     */
    public List<DaTightenCollection> selectDaTightenCollectionList(DaTightenCollection daTightenCollection);

    /**
     * æ–°å¢žæ‹§ç´§é‡‡é›†
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return ç»“æžœ
     */
    public int insertDaTightenCollection(DaTightenCollection daTightenCollection);

    /**
     * ä¿®æ”¹æ‹§ç´§é‡‡é›†
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return ç»“æžœ
     */
    public int updateDaTightenCollection(DaTightenCollection daTightenCollection);

    /**
     * åˆ é™¤æ‹§ç´§é‡‡é›†
     * 
     * @param id æ‹§ç´§é‡‡é›†ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteDaTightenCollectionById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤æ‹§ç´§é‡‡é›†
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteDaTightenCollectionByIds(Long[] ids);
}

 billion-main/src/main/java/com/billion/main/da/service/IDaTightenCollectionService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.billion.main.da.service;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.IService;
import com.billion.main.da.domain.DaTightenCollection;

/**
 * æ‹§ç´§é‡‡é›†Service接口
 * 
 * @author Billion-Yi
 * @date 2024-11-22
 */
public interface IDaTightenCollectionService extends IService<DaTightenCollection>
{
    /**
     * æŸ¥è¯¢æ‹§ç´§é‡‡é›†
     * 
     * @param id æ‹§ç´§é‡‡é›†ä¸»é”®
     * @return æ‹§ç´§é‡‡é›†
     */
    public DaTightenCollection selectDaTightenCollectionById(Long id);

    /**
     * æŸ¥è¯¢æ‹§ç´§é‡‡é›†åˆ—表
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return æ‹§ç´§é‡‡é›†é›†åˆ
     */
    public List<DaTightenCollection> selectDaTightenCollectionList(DaTightenCollection daTightenCollection);

    /**
     * æ–°å¢žæ‹§ç´§é‡‡é›†
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return ç»“æžœ
     */
    public int insertDaTightenCollection(DaTightenCollection daTightenCollection);

    /**
     * ä¿®æ”¹æ‹§ç´§é‡‡é›†
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return ç»“æžœ
     */
    public int updateDaTightenCollection(DaTightenCollection daTightenCollection);

    /**
     * æ‰¹é‡åˆ é™¤æ‹§ç´§é‡‡é›†
     * 
     * @param ids éœ€è¦åˆ é™¤çš„拧紧采集主键集合
     * @return ç»“æžœ
     */
    public int deleteDaTightenCollectionByIds(Long[] ids);

    /**
     * åˆ é™¤æ‹§ç´§é‡‡é›†ä¿¡æ¯
     * 
     * @param id æ‹§ç´§é‡‡é›†ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteDaTightenCollectionById(Long id);
}

 billion-main/src/main/java/com/billion/main/da/service/impl/DaParamCollectionServiceImpl.java

@@ -3,6 +3,7 @@
import java.util.Date;
import java.util.List;

import cn.hutool.core.util.ObjectUtil;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -43,6 +44,10 @@
    @Override
    public List<DaParamCollection> selectDaParamCollectionList(DaParamCollection daParamCollection)
    {
        if(ObjectUtil.isNotNull(daParamCollection.getTimeQuery())){
            daParamCollection.setStartTime(daParamCollection.getTimeQuery()[0]);
            daParamCollection.setStopTime(daParamCollection.getTimeQuery()[1]);
        }
        return daParamCollectionMapper.selectDaParamCollectionList(daParamCollection);
    }


 billion-main/src/main/java/com/billion/main/da/service/impl/DaTightenCollectionServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,95 @@
package com.billion.main.da.service.impl;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.billion.main.da.mapper.DaTightenCollectionMapper;
import com.billion.main.da.domain.DaTightenCollection;
import com.billion.main.da.service.IDaTightenCollectionService;

/**
 * æ‹§ç´§é‡‡é›†Service业务层处理
 * 
 * @author Billion-Yi
 * @date 2024-11-22
 */
@Service
public class DaTightenCollectionServiceImpl extends ServiceImpl<DaTightenCollectionMapper, DaTightenCollection> implements IDaTightenCollectionService
{
    @Autowired
    private DaTightenCollectionMapper daTightenCollectionMapper;

    /**
     * æŸ¥è¯¢æ‹§ç´§é‡‡é›†
     * 
     * @param id æ‹§ç´§é‡‡é›†ä¸»é”®
     * @return æ‹§ç´§é‡‡é›†
     */
    @Override
    public DaTightenCollection selectDaTightenCollectionById(Long id)
    {
        return daTightenCollectionMapper.selectDaTightenCollectionById(id);
    }

    /**
     * æŸ¥è¯¢æ‹§ç´§é‡‡é›†åˆ—表
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return æ‹§ç´§é‡‡é›†
     */
    @Override
    public List<DaTightenCollection> selectDaTightenCollectionList(DaTightenCollection daTightenCollection)
    {
        return daTightenCollectionMapper.selectDaTightenCollectionList(daTightenCollection);
    }

    /**
     * æ–°å¢žæ‹§ç´§é‡‡é›†
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return ç»“æžœ
     */
    @Override
    public int insertDaTightenCollection(DaTightenCollection daTightenCollection)
    {
        return daTightenCollectionMapper.insertDaTightenCollection(daTightenCollection);
    }

    /**
     * ä¿®æ”¹æ‹§ç´§é‡‡é›†
     * 
     * @param daTightenCollection æ‹§ç´§é‡‡é›†
     * @return ç»“æžœ
     */
    @Override
    public int updateDaTightenCollection(DaTightenCollection daTightenCollection)
    {
        return daTightenCollectionMapper.updateDaTightenCollection(daTightenCollection);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ‹§ç´§é‡‡é›†
     * 
     * @param ids éœ€è¦åˆ é™¤çš„拧紧采集主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteDaTightenCollectionByIds(Long[] ids)
    {
        return daTightenCollectionMapper.deleteDaTightenCollectionByIds(ids);
    }

    /**
     * åˆ é™¤æ‹§ç´§é‡‡é›†ä¿¡æ¯
     * 
     * @param id æ‹§ç´§é‡‡é›†ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteDaTightenCollectionById(Long id)
    {
        return daTightenCollectionMapper.deleteDaTightenCollectionById(id);
    }
}

 billion-main/src/main/resources/mapper/da/DaParamCollectionMapper.xml

@@ -25,6 +25,8 @@
            <if test="locationCode != null  and locationCode != ''"> and location_code like concat('%', #{locationCode}, '%')</if>
            <if test="paramCode != null  and paramCode != ''"> and param_code = #{paramCode}</if>
            <if test="paramName != null  and paramName != ''"> and param_name like concat('%', #{paramName}, '%')</if>
            <if test="startTime != null"> and collect_time BETWEEN #{startTime} and #{stopTime}</if>

        </where>
    </select>
    

 billion-main/src/main/resources/mapper/da/DaTightenCollectionMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,94 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.billion.main.da.mapper.DaTightenCollectionMapper">
    
    <resultMap type="DaTightenCollection" id="DaTightenCollectionResult">
        <result property="id"    column="id"    />
        <result property="sfcCode"    column="sfc_code"    />
        <result property="locationCode"    column="location_code"    />
        <result property="paramSetCode"    column="param_set_code"    />
        <result property="paramSetName"    column="param_set_name"    />
        <result property="torque"    column="torque"    />
        <result property="torqueStatus"    column="torque_status"    />
        <result property="angle"    column="angle"    />
        <result property="angleStatus"    column="angle_status"    />
        <result property="collectTime"    column="collect_time"    />
    </resultMap>

    <sql id="selectDaTightenCollectionVo">
        select id, sfc_code, location_code, param_set_code, param_set_name, torque, torque_status, angle, angle_status, collect_time from da_tighten_collection
    </sql>

    <select id="selectDaTightenCollectionList" parameterType="DaTightenCollection" resultMap="DaTightenCollectionResult">
        <include refid="selectDaTightenCollectionVo"/>
        <where>  
            <if test="sfcCode != null  and sfcCode != ''"> and sfc_code = #{sfcCode}</if>
            <if test="locationCode != null  and locationCode != ''"> and location_code like concat('%', #{locationCode}, '%')</if>
            <if test="paramSetCode != null  and paramSetCode != ''"> and param_set_code like concat('%', #{paramSetCode}, '%')</if>
            <if test="paramSetName != null  and paramSetName != ''"> and param_set_name like concat('%', #{paramSetName}, '%')</if>
            <if test="torqueStatus != null  and torqueStatus != ''"> and torque_status = #{torqueStatus}</if>
            <if test="angleStatus != null  and angleStatus != ''"> and angle_status = #{angleStatus}</if>
            <if test="collectTime != null "> and collect_time = #{collectTime}</if>
        </where>
    </select>
    
    <select id="selectDaTightenCollectionById" parameterType="Long" resultMap="DaTightenCollectionResult">
        <include refid="selectDaTightenCollectionVo"/>
        where id = #{id}
    </select>

    <insert id="insertDaTightenCollection" parameterType="DaTightenCollection" useGeneratedKeys="true" keyProperty="id">
        insert into da_tighten_collection
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="sfcCode != null">sfc_code,</if>
            <if test="locationCode != null">location_code,</if>
            <if test="paramSetCode != null">param_set_code,</if>
            <if test="paramSetName != null">param_set_name,</if>
            <if test="torque != null">torque,</if>
            <if test="torqueStatus != null">torque_status,</if>
            <if test="angle != null">angle,</if>
            <if test="angleStatus != null">angle_status,</if>
            <if test="collectTime != null">collect_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="sfcCode != null">#{sfcCode},</if>
            <if test="locationCode != null">#{locationCode},</if>
            <if test="paramSetCode != null">#{paramSetCode},</if>
            <if test="paramSetName != null">#{paramSetName},</if>
            <if test="torque != null">#{torque},</if>
            <if test="torqueStatus != null">#{torqueStatus},</if>
            <if test="angle != null">#{angle},</if>
            <if test="angleStatus != null">#{angleStatus},</if>
            <if test="collectTime != null">#{collectTime},</if>
         </trim>
    </insert>

    <update id="updateDaTightenCollection" parameterType="DaTightenCollection">
        update da_tighten_collection
        <trim prefix="SET" suffixOverrides=",">
            <if test="sfcCode != null">sfc_code = #{sfcCode},</if>
            <if test="locationCode != null">location_code = #{locationCode},</if>
            <if test="paramSetCode != null">param_set_code = #{paramSetCode},</if>
            <if test="paramSetName != null">param_set_name = #{paramSetName},</if>
            <if test="torque != null">torque = #{torque},</if>
            <if test="torqueStatus != null">torque_status = #{torqueStatus},</if>
            <if test="angle != null">angle = #{angle},</if>
            <if test="angleStatus != null">angle_status = #{angleStatus},</if>
            <if test="collectTime != null">collect_time = #{collectTime},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteDaTightenCollectionById" parameterType="Long">
        delete from da_tighten_collection where id = #{id}
    </delete>

    <delete id="deleteDaTightenCollectionByIds" parameterType="String">
        delete from da_tighten_collection where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 billion-ui/src/api/main/da/tightenCollection.js

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,44 @@
import request from '@/utils/request'

// æŸ¥è¯¢æ‹§ç´§é‡‡é›†åˆ—表
export function listTightenCollection(query) {
  return request({
    url: '/da/tightenCollection/list',
    method: 'get',
    params: query
  })
}

// æŸ¥è¯¢æ‹§ç´§é‡‡é›†è¯¦ç»†
export function getTightenCollection(id) {
  return request({
    url: '/da/tightenCollection/' + id,
    method: 'get'
  })
}

// æ–°å¢žæ‹§ç´§é‡‡é›†
export function addTightenCollection(data) {
  return request({
    url: '/da/tightenCollection',
    method: 'post',
    data: data
  })
}

// ä¿®æ”¹æ‹§ç´§é‡‡é›†
export function updateTightenCollection(data) {
  return request({
    url: '/da/tightenCollection',
    method: 'put',
    data: data
  })
}

// åˆ é™¤æ‹§ç´§é‡‡é›†
export function delTightenCollection(id) {
  return request({
    url: '/da/tightenCollection/' + id,
    method: 'delete'
  })
}

 billion-ui/src/views/main/da/paramCollection/index.vue

@@ -22,7 +22,7 @@
      <el-form-item style="float: right">
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
            <el-button icon="el-icon-setting" size="mini" @click="toggleAdvancedSearch">高级查询</el-button>
        <el-button icon="el-icon-setting" size="mini" @click="toggleAdvancedSearch">高级查询</el-button>
      </el-form-item>
     <transition name="fade">
        <div v-if="advancedSearchVisible" class="advanced-search">
@@ -245,7 +245,6 @@
  methods: {
    toggleAdvancedSearch() {
      this.advancedSearchVisible = !this.advancedSearchVisible;

    },
    /** æŸ¥è¯¢å‚数采集列表 */
    getList() {

 billion-ui/src/views/main/da/tightenCollection/index.vue

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,319 @@
<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
      <el-form-item label-width="120" label="总成序列号" prop="sfcCode">
        <el-input
          v-model="queryParams.sfcCode"
          placeholder="请输入总成序列号"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="工位编码" prop="locationCode">
        <el-input
          v-model="queryParams.locationCode"
          placeholder="请输入工位编码"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
<!--      <el-form-item label="参数集编码" prop="paramSetCode">-->
<!--        <el-input-->
<!--          v-model="queryParams.paramSetCode"-->
<!--          placeholder="请输入参数集编码"-->
<!--          clearable-->
<!--          @keyup.enter.native="handleQuery"-->
<!--        />-->
<!--      </el-form-item>-->
<!--      <el-form-item label="参数集名称" prop="paramSetName">-->
<!--        <el-input-->
<!--          v-model="queryParams.paramSetName"-->
<!--          placeholder="请输入参数集名称"-->
<!--          clearable-->
<!--          @keyup.enter.native="handleQuery"-->
<!--        />-->
<!--      </el-form-item>-->
<!--      <el-form-item label="采集时间" prop="collectTime">-->
<!--        <el-date-picker clearable-->
<!--          v-model="queryParams.collectTime"-->
<!--          type="date"-->
<!--          value-format="yyyy-MM-dd"-->
<!--          placeholder="请选择采集时间">-->
<!--        </el-date-picker>-->
<!--      </el-form-item>-->
      <el-form-item style="float: right">
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
<!--        <el-button icon="el-icon-setting" size="mini" @click="toggleAdvancedSearch">高级查询</el-button>-->
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button
          type="primary"
          plain
          icon="el-icon-plus"
          size="mini"
          @click="handleAdd"
          v-hasPermi="['da:tightenCollection:add']"
        >新增</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="success"
          plain
          icon="el-icon-edit"
          size="mini"
          :disabled="single"
          @click="handleUpdate"
          v-hasPermi="['da:tightenCollection:edit']"
        >修改</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="danger"
          plain
          icon="el-icon-delete"
          size="mini"
          :disabled="multiple"
          @click="handleDelete"
          v-hasPermi="['da:tightenCollection:remove']"
        >删除</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="el-icon-download"
          size="mini"
          @click="handleExport"
          v-hasPermi="['da:tightenCollection:export']"
        >导出</el-button>
      </el-col>
      <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
    </el-row>

    <el-table border v-loading="loading" :data="tightenCollectionList" @selection-change="handleSelectionChange">
      <el-table-column type="selection" width="55" align="center" />
<!--      <el-table-column label="主键id" align="center" prop="id" />-->
      <el-table-column label="总成序列号" align="center" prop="sfcCode" />
      <el-table-column label="工位编码" align="center" prop="locationCode" />
      <el-table-column label="参数集编码" align="center" prop="paramSetCode" />
      <el-table-column label="参数集名称" align="center" prop="paramSetName" />
      <el-table-column label="扭矩值" align="center" prop="torque" />
      <el-table-column label="扭矩状态" align="center" prop="torqueStatus" />
      <el-table-column label="角度值" align="center" prop="angle" />
      <el-table-column label="角度状态" align="center" prop="angleStatus" />
      <el-table-column label="采集时间" align="center" prop="collectTime" width="180">
      </el-table-column>
      <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
        <template slot-scope="scope">
          <el-button
            size="mini"
            type="text"
            icon="el-icon-edit"
            @click="handleUpdate(scope.row)"
            v-hasPermi="['da:tightenCollection:edit']"
          >修改</el-button>
          <el-button
            size="mini"
            type="text"
            icon="el-icon-delete"
            @click="handleDelete(scope.row)"
            v-hasPermi="['da:tightenCollection:remove']"
          >删除</el-button>
        </template>
      </el-table-column>
    </el-table>

    <pagination
      v-show="total>0"
      :total="total"
      :page.sync="queryParams.pageNum"
      :limit.sync="queryParams.pageSize"
      @pagination="getList"
    />

    <!-- æ·»åŠ æˆ–修改拧紧采集对话框 -->
    <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
      <el-form ref="form" :model="form" :rules="rules" label-width="100px">
        <el-form-item label="总成序列号" prop="sfcCode">
          <el-input v-model="form.sfcCode" placeholder="请输入总成序列号" />
        </el-form-item>
        <el-form-item label="工位编码" prop="locationCode">
          <el-input v-model="form.locationCode" placeholder="请输入工位编码" />
        </el-form-item>
        <el-form-item label="参数集编码" prop="paramSetCode">
          <el-input v-model="form.paramSetCode" placeholder="请输入参数集编码" />
        </el-form-item>
        <el-form-item label="参数集名称" prop="paramSetName">
          <el-input v-model="form.paramSetName" placeholder="请输入参数集名称" />
        </el-form-item>
        <el-form-item label="扭矩值" prop="torque">
          <el-input v-model="form.torque" placeholder="请输入扭矩值" />
        </el-form-item>
        <el-form-item label="角度值" prop="angle">
          <el-input v-model="form.angle" placeholder="请输入角度值" />
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitForm">ç¡® å®š</el-button>
        <el-button @click="cancel">取 æ¶ˆ</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
import { listTightenCollection, getTightenCollection, delTightenCollection, addTightenCollection, updateTightenCollection } from "@/api/main/da/tightenCollection";

export default {
  name: "TightenCollection",
  data() {
    return {
      // é®ç½©å±‚
      loading: true,
      // é€‰ä¸­æ•°ç»„
      ids: [],
      // éžå•ä¸ªç¦ç”¨
      single: true,
      // éžå¤šä¸ªç¦ç”¨
      multiple: true,
      // æ˜¾ç¤ºæœç´¢æ¡ä»¶
      showSearch: true,
      // æ€»æ¡æ•°
      total: 0,
      // æ‹§ç´§é‡‡é›†è¡¨æ ¼æ•°æ®
      tightenCollectionList: [],
      // å¼¹å‡ºå±‚标题
      title: "",
      // æ˜¯å¦æ˜¾ç¤ºå¼¹å‡ºå±‚
      open: false,
      // æŸ¥è¯¢å‚æ•°
      queryParams: {
        pageNum: 1,
        pageSize: 10,
        sfcCode: null,
        locationCode: null,
        paramSetCode: null,
        paramSetName: null,
        torqueStatus: null,
        angleStatus: null,
        collectTime: null
      },
      // è¡¨å•å‚æ•°
      form: {},
      // è¡¨å•æ ¡éªŒ
      rules: {
      }
    };
  },
  created() {
    this.getList();
  },
  methods: {
    toggleAdvancedSearch() {
      this.advancedSearchVisible = !this.advancedSearchVisible;
    },
    /** æŸ¥è¯¢æ‹§ç´§é‡‡é›†åˆ—表 */
    getList() {
      this.loading = true;
      listTightenCollection(this.queryParams).then(response => {
        this.tightenCollectionList = response.rows;
        this.total = response.total;
        this.loading = false;
      });
    },
    // å–消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    // è¡¨å•é‡ç½®
    reset() {
      this.form = {
        id: null,
        sfcCode: null,
        locationCode: null,
        paramSetCode: null,
        paramSetName: null,
        torque: null,
        torqueStatus: null,
        angle: null,
        angleStatus: null,
        collectTime: null
      };
      this.resetForm("form");
    },
    /** æœç´¢æŒ‰é’®æ“ä½œ */
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getList();
    },
    /** é‡ç½®æŒ‰é’®æ“ä½œ */
    resetQuery() {
      this.resetForm("queryForm");
      this.handleQuery();
    },
    // å¤šé€‰æ¡†é€‰ä¸­æ•°æ®
    handleSelectionChange(selection) {
      this.ids = selection.map(item => item.id)
      this.single = selection.length!==1
      this.multiple = !selection.length
    },
    /** æ–°å¢žæŒ‰é’®æ“ä½œ */
    handleAdd() {
      this.reset();
      this.open = true;
      this.title = "添加拧紧采集";
    },
    /** ä¿®æ”¹æŒ‰é’®æ“ä½œ */
    handleUpdate(row) {
      this.reset();
      const id = row.id || this.ids
      getTightenCollection(id).then(response => {
        this.form = response.data;
        this.open = true;
        this.title = "修改拧紧采集";
      });
    },
    /** æäº¤æŒ‰é’® */
    submitForm() {
      this.$refs["form"].validate(valid => {
        if (valid) {
          if (this.form.id != null) {
            updateTightenCollection(this.form).then(response => {
              this.$modal.msgSuccess("修改成功");
              this.open = false;
              this.getList();
            });
          } else {
            addTightenCollection(this.form).then(response => {
              this.$modal.msgSuccess("新增成功");
              this.open = false;
              this.getList();
            });
          }
        }
      });
    },
    /** åˆ é™¤æŒ‰é’®æ“ä½œ */
    handleDelete(row) {
      const ids = row.id || this.ids;
      this.$modal.confirm('是否确认删除拧紧采集编号为"' + ids + '"的数据项？').then(function() {
        return delTightenCollection(ids);
      }).then(() => {
        this.getList();
        this.$modal.msgSuccess("删除成功");
      }).catch(() => {});
    },
    /** å¯¼å‡ºæŒ‰é’®æ“ä½œ */
    handleExport() {
      this.download('da/tightenCollection/export', {
        ...this.queryParams
      }, `tightenCollection_${new Date().getTime()}.xlsx`)
    }
  }
};
</script>