From 1391b345457a70d9449bb51e797c54039a3b0a53 Mon Sep 17 00:00:00 2001
From: 懒羊羊 <15939171744@163.com>
Date: 星期三, 17 一月 2024 17:39:48 +0800
Subject: [PATCH] 工单优化
---
jcdm-main/src/main/resources/mapper/bs/orderScheduling/BsOrderSchedulingMapper.xml | 13 +
jcdm-ui/src/views/main/om/productionOrde/index.vue | 7
jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/service/impl/BsOrderSchedulingServiceImpl.java | 7 +
jcdm-ui/src/views/main/bs/orderScheduling/index.vue | 258 +++++++++++++++++++++---------------------
jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java | 14 ++
jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java | 3
6 files changed, 165 insertions(+), 137 deletions(-)
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java
index 97ed85d..b03aeaf 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java
@@ -110,7 +110,19 @@
@Excel(name = "澶囨敞")
private String remarks;
- public void setId(Long id)
+ /** CVT鎶ュ伐 */
+ @Excel(name = "CVT鎶ュ伐")
+ private String report30;
+
+ public String getReport30() {
+ return report30;
+ }
+
+ public void setReport30(String report30) {
+ this.report30 = report30;
+ }
+
+ public void setId(Long id)
{
this.id = id;
}
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/service/impl/BsOrderSchedulingServiceImpl.java b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/service/impl/BsOrderSchedulingServiceImpl.java
index 7439a3b..60bbb70 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/service/impl/BsOrderSchedulingServiceImpl.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/service/impl/BsOrderSchedulingServiceImpl.java
@@ -1,6 +1,8 @@
package com.jcdm.main.bs.orderScheduling.service.impl;
import java.util.List;
+
+import cn.hutool.core.util.StrUtil;
import com.jcdm.common.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -41,6 +43,11 @@
@Override
public List<BsOrderScheduling> selectBsOrderSchedulingList(BsOrderScheduling bsOrderScheduling)
{
+
+// if(StrUtil.isNotBlank(bsOrderScheduling.getOperateTime())){
+//// String[] dateArray = gson.fromJson(jsonString, String[].class);
+//
+// }
return bsOrderSchedulingMapper.selectBsOrderSchedulingList(bsOrderScheduling);
}
diff --git a/jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java b/jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java
index 85934d5..bafb93a 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java
@@ -180,8 +180,9 @@
}
/**
- * table鍒椾笂绉讳笅绉�
+ * 鎺ユ敹宸ュ崟
*/
+ @PreAuthorize("@ss.hasPermi('om:productionOrde:receive')")
@GetMapping("/getProductionNotice")
public AjaxResult getProductionNotice(OmProductionOrdeInfo omProductionOrdeInfo)
{
diff --git a/jcdm-main/src/main/resources/mapper/bs/orderScheduling/BsOrderSchedulingMapper.xml b/jcdm-main/src/main/resources/mapper/bs/orderScheduling/BsOrderSchedulingMapper.xml
index f906af9..24ffd8a 100644
--- a/jcdm-main/src/main/resources/mapper/bs/orderScheduling/BsOrderSchedulingMapper.xml
+++ b/jcdm-main/src/main/resources/mapper/bs/orderScheduling/BsOrderSchedulingMapper.xml
@@ -31,10 +31,12 @@
<result property="updateUser" column="update_user" />
<result property="updateTime" column="update_time" />
<result property="remarks" column="remarks" />
+ <result property="report30" column="report_30" />
+
</resultMap>
<sql id="selectBsOrderSchedulingVo">
- select id, order_no, engine_no, product_type, model, production_status, working_hours, current_workstation, quality_status, whether_or_print, report_10, report_20, combined_box_time, final_assembly_time, operator, operate_time, status, spare_field_1, spare_field_2, spare_field_3, spare_field_4, create_user, create_time, update_user, update_time, remarks from bs_order_scheduling
+ select id, order_no, engine_no, product_type, model, production_status, working_hours, current_workstation, quality_status, whether_or_print, report_10, report_20, combined_box_time, final_assembly_time, operator, operate_time, status, spare_field_1, spare_field_2, spare_field_3, spare_field_4, create_user, create_time, update_user, update_time, remarks, report_30 from bs_order_scheduling
</sql>
<select id="selectBsOrderSchedulingList" parameterType="BsOrderScheduling" resultMap="BsOrderSchedulingResult">
@@ -63,6 +65,8 @@
<if test="createUser != null and createUser != ''"> and create_user = #{createUser}</if>
<if test="updateUser != null and updateUser != ''"> and update_user = #{updateUser}</if>
<if test="remarks != null and remarks != ''"> and remarks = #{remarks}</if>
+ <if test="report30 != null and report30 != ''"> and report_30 = #{report30}</if>
+
</where>
</select>
@@ -99,6 +103,7 @@
<if test="updateUser != null">update_user,</if>
<if test="updateTime != null">update_time,</if>
<if test="remarks != null">remarks,</if>
+ <if test="report30 != null">report_30,</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="orderNo != null">#{orderNo},</if>
@@ -126,7 +131,9 @@
<if test="updateUser != null">#{updateUser},</if>
<if test="updateTime != null">#{updateTime},</if>
<if test="remarks != null">#{remarks},</if>
- </trim>
+ <if test="report30 != null">#{report30},</if>
+
+ </trim>
</insert>
<update id="updateBsOrderScheduling" parameterType="BsOrderScheduling">
@@ -157,6 +164,8 @@
<if test="updateUser != null">update_user = #{updateUser},</if>
<if test="updateTime != null">update_time = #{updateTime},</if>
<if test="remarks != null">remarks = #{remarks},</if>
+ <if test="report30 != null">report_30 = #{report30},</if>
+
</trim>
where id = #{id}
</update>
diff --git a/jcdm-ui/src/views/main/bs/orderScheduling/index.vue b/jcdm-ui/src/views/main/bs/orderScheduling/index.vue
index c92d6e2..aefd1b7 100644
--- a/jcdm-ui/src/views/main/bs/orderScheduling/index.vue
+++ b/jcdm-ui/src/views/main/bs/orderScheduling/index.vue
@@ -10,15 +10,6 @@
@keyup.enter.native="handleQuery"
/>
</el-form-item>
- <el-form-item label="鍙戝姩鏈哄彿" prop="engineNo">
- <el-input
- v-model="queryParams.engineNo"
- placeholder="璇疯緭鍏ュ彂鍔ㄦ満鍙�"
- clearable
- @keyup.enter.native="handleQuery"
- />
- </el-form-item>
-
<el-form-item label="鏈哄瀷" prop="model">
<el-input
v-model="queryParams.model"
@@ -27,119 +18,85 @@
@keyup.enter.native="handleQuery"
/>
</el-form-item>
-
- <el-form-item label="宸ユ椂" prop="workingHours">
- <el-input
- v-model="queryParams.workingHours"
- placeholder="璇疯緭鍏ュ伐鏃�"
- clearable
- @keyup.enter.native="handleQuery"
- />
+ <el-form-item label="鐢熶骇鐘舵��" prop="productionStatus">
+ <el-select v-model="queryParams.productionStatus" placeholder="璇烽�夋嫨宸ュ崟鐘舵��" clearable>
+ <el-option
+ v-for="dict in dict.type.order_scheduling_produce_status"
+ :key="dict.value"
+ :label="dict.label"
+ :value="dict.value"/>
+ </el-select>
</el-form-item>
- <el-form-item label="褰撳墠宸ヤ綅" prop="currentWorkstation">
- <el-input
- v-model="queryParams.currentWorkstation"
- placeholder="璇疯緭鍏ュ綋鍓嶅伐浣�"
- clearable
- @keyup.enter.native="handleQuery"
- />
- </el-form-item>
-
- <el-form-item label="鏄惁鎵撳嵃" prop="whetherOrPrint">
- <el-input
- v-model="queryParams.whetherOrPrint"
- placeholder="璇疯緭鍏ユ槸鍚︽墦鍗�"
- clearable
- @keyup.enter.native="handleQuery"
- />
- </el-form-item>
- <el-form-item label="10鎶ュ伐" prop="report10">
- <el-input
- v-model="queryParams.report10"
- placeholder="璇疯緭鍏�10鎶ュ伐"
- clearable
- @keyup.enter.native="handleQuery"
- />
- </el-form-item>
- <el-form-item label="20鎶ュ伐" prop="report20">
- <el-input
- v-model="queryParams.report20"
- placeholder="璇疯緭鍏�20鎶ュ伐"
- clearable
- @keyup.enter.native="handleQuery"
- />
- </el-form-item>
- <el-form-item label="鎿嶄綔浜�" prop="operator">
- <el-input
- v-model="queryParams.operator"
- placeholder="璇疯緭鍏ユ搷浣滀汉"
- clearable
- @keyup.enter.native="handleQuery"
- />
- </el-form-item>
-
-<!-- <el-form-item label="棰勭暀瀛楁1" prop="spareField1">-->
-<!-- <el-input-->
-<!-- v-model="queryParams.spareField1"-->
-<!-- placeholder="璇疯緭鍏ラ鐣欏瓧娈�1"-->
-<!-- clearable-->
-<!-- @keyup.enter.native="handleQuery"-->
-<!-- />-->
-<!-- </el-form-item>-->
-<!-- <el-form-item label="棰勭暀瀛楁2" prop="spareField2">-->
-<!-- <el-input-->
-<!-- v-model="queryParams.spareField2"-->
-<!-- placeholder="璇疯緭鍏ラ鐣欏瓧娈�2"-->
-<!-- clearable-->
-<!-- @keyup.enter.native="handleQuery"-->
-<!-- />-->
-<!-- </el-form-item>-->
-<!-- <el-form-item label="棰勭暀瀛楁3" prop="spareField3">-->
-<!-- <el-input-->
-<!-- v-model="queryParams.spareField3"-->
-<!-- placeholder="璇疯緭鍏ラ鐣欏瓧娈�3"-->
-<!-- clearable-->
-<!-- @keyup.enter.native="handleQuery"-->
-<!-- />-->
-<!-- </el-form-item>-->
-<!-- <el-form-item label="棰勭暀瀛楁4" prop="spareField4">-->
-<!-- <el-input-->
-<!-- v-model="queryParams.spareField4"-->
-<!-- placeholder="璇疯緭鍏ラ鐣欏瓧娈�4"-->
-<!-- clearable-->
-<!-- @keyup.enter.native="handleQuery"-->
-<!-- />-->
-<!-- </el-form-item>-->
-<!-- <el-form-item label="鍒涘缓鐢ㄦ埛" prop="createUser">-->
-<!-- <el-input-->
-<!-- v-model="queryParams.createUser"-->
-<!-- placeholder="璇疯緭鍏ュ垱寤虹敤鎴�"-->
-<!-- clearable-->
-<!-- @keyup.enter.native="handleQuery"-->
-<!-- />-->
-<!-- </el-form-item>-->
-<!-- <el-form-item label="鏇存敼鐢ㄦ埛" prop="updateUser">-->
-<!-- <el-input-->
-<!-- v-model="queryParams.updateUser"-->
-<!-- placeholder="璇疯緭鍏ユ洿鏀圭敤鎴�"-->
-<!-- clearable-->
-<!-- @keyup.enter.native="handleQuery"-->
-<!-- />-->
-<!-- </el-form-item>-->
-<!-- <el-form-item label="澶囨敞" prop="remarks">-->
-<!-- <el-input-->
-<!-- v-model="queryParams.remarks"-->
-<!-- placeholder="璇疯緭鍏ュ娉�"-->
-<!-- clearable-->
-<!-- @keyup.enter.native="handleQuery"-->
-<!-- />-->
-<!-- </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 type="warning" icon="el-icon-copy-document" size="mini" @click="advancedQuery">楂樼骇鏌ヨ</el-button>
<el-button icon="el-icon-refresh" size="mini" @click="resetQuery">閲嶇疆</el-button>
</el-form-item>
</el-form>
+ <el-form :model="queryParams" ref="queryParams" size="small" :inline="true" v-show="advancedShowSearch" label-width="68px">
+ <el-form-item label="鍙戝姩鏈哄彿" prop="engineNo">
+ <el-input
+ v-model="queryParams.engineNo"
+ placeholder="璇疯緭鍏ュ彂鍔ㄦ満鍙�"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="璐ㄩ噺鐘舵��" prop="qualityStatus">
+ <el-select v-model="queryParams.qualityStatus" placeholder="璇烽�夋嫨璐ㄩ噺鐘舵��" clearable>
+ <el-option
+ v-for="dict in dict.type.quality_status"
+ :key="dict.value"
+ :label="dict.label"
+ :value="dict.value"/>
+ </el-select>
+ </el-form-item>
+ <el-form-item label="鏄惁鎵撳嵃" prop="whetherOrPrint">
+ <el-select v-model="queryParams.whetherOrPrint" placeholder="璇烽�夋嫨鏄惁鎵撳嵃" clearable>
+ <el-option
+ v-for="dict in dict.type.print_status"
+ :key="dict.value"
+ :label="dict.label"
+ :value="dict.value"/>
+ </el-select>
+ </el-form-item>
+ <el-form-item label="鍚堢鎶ュ伐" prop="report10">
+ <el-input
+ v-model="queryParams.report10"
+ placeholder="璇疯緭鍏ュ悎绠辨姤宸�"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="鎬昏鎶ュ伐" prop="report20">
+ <el-input
+ v-model="queryParams.report20"
+ placeholder="璇疯緭鍏ユ�昏鎶ュ伐"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="CVT鎶ュ伐" prop="report30">
+ <el-input
+ v-model="queryParams.report30"
+ placeholder="璇疯緭鍏VT鎶ュ伐"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="鎿嶄綔鏃堕棿" prop="operateTime">
+ <el-date-picker
+ v-model="queryParams.operateTime"
+ type="datetimerange"
+ :picker-options="pickerOptions"
+ value-format="yyyy-MM-dd HH:mm:ss"
+ range-separator="鑷�"
+ start-placeholder="寮�濮嬫棩鏈�"
+ end-placeholder="缁撴潫鏃ユ湡"
+ align="right">
+ </el-date-picker>
+ </el-form-item>
+ </el-form>
</el-card>
<el-card style="margin-top: 10px" class="box-card">
@@ -215,15 +172,22 @@
</el-table-column>
<el-table-column label="璐ㄩ噺鐘舵��" align="center" prop="qualityStatus">
-
+ <template slot-scope="scope">
+ <dict-tag :options="dict.type.quality_status" :value="scope.row.qualityStatus"/>
+ </template>
</el-table-column>
<el-table-column label="鏄惁鎵撳嵃" align="center" prop="whetherOrPrint">
+ <template slot-scope="scope">
+ <dict-tag :options="dict.type.print_status" :value="scope.row.whetherOrPrint"/>
+ </template>
+ </el-table-column>
+ <el-table-column label="鍚堢鎶ュ伐" align="center" prop="report10">
</el-table-column>
- <el-table-column label="10鎶ュ伐" align="center" prop="report10">
+ <el-table-column label="鎬昏鎶ュ伐" align="center" prop="report20">
</el-table-column>
- <el-table-column label="20鎶ュ伐" align="center" prop="report20">
+ <el-table-column label="CVT鎶ュ伐" align="center" prop="report30">
</el-table-column>
<el-table-column label="鍚堢涓婄嚎" align="center" prop="combinedBoxTime">
@@ -348,11 +312,14 @@
<el-form-item label="鏄惁鎵撳嵃" prop="whetherOrPrint">
<el-input v-model="form.whetherOrPrint" placeholder="璇疯緭鍏ユ槸鍚︽墦鍗�" />
</el-form-item>
- <el-form-item label="10鎶ュ伐" prop="report10">
- <el-input v-model="form.report10" placeholder="璇疯緭鍏�10鎶ュ伐" />
+ <el-form-item label="鍚堢鎶ュ伐" prop="report10">
+ <el-input v-model="form.report10" placeholder="璇疯緭鍏ュ悎绠辨姤宸�" />
</el-form-item>
- <el-form-item label="20鎶ュ伐" prop="report20">
- <el-input v-model="form.report20" placeholder="璇疯緭鍏�20鎶ュ伐" />
+ <el-form-item label="鎬昏鎶ュ伐" prop="report20">
+ <el-input v-model="form.report20" placeholder="璇疯緭鍏ユ�昏鎶ュ伐" />
+ </el-form-item>
+ <el-form-item label="30鎶ュ伐" prop="report20">
+ <el-input v-model="form.report30" placeholder="璇疯緭鍏�30鎶ュ伐" />
</el-form-item>
<el-form-item label="鎿嶄綔浜�" prop="operator">
<el-input v-model="form.operator" placeholder="璇疯緭鍏ユ搷浣滀汉" />
@@ -401,7 +368,7 @@
export default {
name: "OrderScheduling",
- dicts: ['order_scheduling_produce_status'],
+ dicts: ['order_scheduling_produce_status','quality_status','print_status'],
data() {
return {
// 閬僵灞�
@@ -413,6 +380,7 @@
single: true,
// 闈炲涓鐢�
multiple: true,
+ advancedShowSearch: false,
// 鏄剧ず鎼滅储鏉′欢
showSearch: true,
// 鎬绘潯鏁�
@@ -441,7 +409,7 @@
combinedBoxTime: null,
finalAssemblyTime: null,
operator: null,
- operateTime: null,
+ operateTime: '',
status: null,
spareField1: null,
spareField2: null,
@@ -458,7 +426,36 @@
id: [
{ required: true, message: "ID涓嶈兘涓虹┖", trigger: "blur" }
],
- }
+ },
+ pickerOptions: {
+ shortcuts: [{
+ text: '鏈�杩戜竴鍛�',
+ onClick(picker) {
+ const end = new Date();
+ const start = new Date();
+ start.setTime(start.getTime() - 3600 * 1000 * 24 * 7);
+ picker.$emit('pick', [start, end]);
+ }
+ }, {
+ text: '鏈�杩戜竴涓湀',
+ onClick(picker) {
+ const end = new Date();
+ const start = new Date();
+ start.setTime(start.getTime() - 3600 * 1000 * 24 * 30);
+ picker.$emit('pick', [start, end]);
+ }
+ }, {
+ text: '鏈�杩戜笁涓湀',
+ onClick(picker) {
+ const end = new Date();
+ const start = new Date();
+ start.setTime(start.getTime() - 3600 * 1000 * 24 * 90);
+ picker.$emit('pick', [start, end]);
+ }
+ }]
+ },
+ value1: [new Date(2000, 10, 10, 10, 10), new Date(2000, 10, 11, 10, 10)],
+ value2: ''
};
},
created() {
@@ -467,6 +464,9 @@
this.getList();
},
methods: {
+ advancedQuery(){
+ this.advancedShowSearch = (this.advancedShowSearch) ? this.advancedShowSearch = false : this.advancedShowSearch = true;
+ },
/** 鏌ヨ璁㈠崟鎺掍骇鍒楄〃 */
getList() {
this.loading = true;
@@ -509,14 +509,16 @@
createTime: null,
updateUser: null,
updateTime: null,
- remarks: null
+ remarks: null,
+ report30: null
};
this.resetForm("form");
},
/** 鎼滅储鎸夐挳鎿嶄綔 */
handleQuery() {
- this.queryParams.pageNum = 1;
- this.getList();
+ // this.queryParams.pageNum = 1;
+ // this.getList();
+ this.$modal.msgSuccess(this.queryParams.operateTime);
},
/** 閲嶇疆鎸夐挳鎿嶄綔 */
resetQuery() {
diff --git a/jcdm-ui/src/views/main/om/productionOrde/index.vue b/jcdm-ui/src/views/main/om/productionOrde/index.vue
index e9abfb2..00823a4 100644
--- a/jcdm-ui/src/views/main/om/productionOrde/index.vue
+++ b/jcdm-ui/src/views/main/om/productionOrde/index.vue
@@ -122,13 +122,14 @@
icon="el-icon-download"
size="mini"
@click="getProductionNotice"
+ v-hasPermi="['om:productionOrde:receive']"
>鎺ユ敹</el-button>
</el-col>
<el-col :span="1.5">
<el-button
type="primary"
plain
- icon="el-icon-createUpdate"
+ icon="el-icon-edit"
size="mini"
:disabled="single"
@click="CreatehandleUpdate"
@@ -551,10 +552,6 @@
getProductionNotice(){
getProductionNotice(this.queryParams).then(response => {
- console.log(response)
- console.log(response.data)
-
- console.log(response.data.msg)
this.$modal.msgSuccess(response.data.msg);
this.queryParams = {}
this.getList();
--
Gitblit v1.9.3