From c635d78b479510ebe2556a420948effcd30a0731 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期六, 21 十二月 2024 18:40:43 +0800 Subject: [PATCH] 新建德森项目分支 --- zy-asrs-wms/src/main/java/com/zy/asrs/wms/common/interceptor/StockSortInterceptor.java | 136 ++++++++++++++++++++++---------------------- 1 files changed, 68 insertions(+), 68 deletions(-) diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/common/interceptor/StockSortInterceptor.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/common/interceptor/StockSortInterceptor.java index f05da9e..16c15cb 100644 --- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/common/interceptor/StockSortInterceptor.java +++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/common/interceptor/StockSortInterceptor.java @@ -1,68 +1,68 @@ -//package com.zy.asrs.wms.common.interceptor; -// -//import com.baomidou.mybatisplus.core.toolkit.PluginUtils; -//import com.baomidou.mybatisplus.extension.plugins.inner.InnerInterceptor; -//import org.apache.ibatis.executor.Executor; -//import org.apache.ibatis.mapping.BoundSql; -//import org.apache.ibatis.mapping.MappedStatement; -//import org.apache.ibatis.session.ResultHandler; -//import org.apache.ibatis.session.RowBounds; -// -//import java.sql.SQLException; -// -// -//public class StockSortInterceptor implements InnerInterceptor { -// -// @Override -// public void beforeQuery(Executor executor, MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql) throws SQLException { -// // 鑾峰彇鍘熷SQL璇彞 -// String originalSql = boundSql.getSql(); -// // 鍒ゆ柇鏂规硶鏄惁涓虹壒瀹氱殑鏌ヨ鏂规硶 -// if (isSpecificQueryMethod(ms)) { -// // 娣诲姞鎺掑簭閫昏緫 -// String sql = addSort(originalSql); -// // 淇敼瀹屾垚鐨剆ql 鍐嶈缃洖鍘� -// PluginUtils.MPBoundSql mpBoundSql = PluginUtils.mpBoundSql(boundSql); -// mpBoundSql.sql(sql); -// } -// } -// -// private boolean isSpecificQueryMethod(MappedStatement ms) { -// // 妫�鏌appedStatement鐨処D浠ュ垽鏂槸鍚︿负鐗瑰畾鐨勬煡璇㈡柟娉� -// String statementId = ms.getId(); -// return statementId.equals("com.zy.asrs.wms.asrs.mapper.LocDetlMapper.getStock"); -// } -// -// private String addSort(String originalSql) { -// // 鏍规嵁闇�瑕佹坊鍔犳帓搴忛�昏緫 -// return originalSql + " ORDER BY" + isQueue(); -// } -// -// private String isQueue() { -// //鍏堣繘鍏堝嚭锛氬湪鏌ヨ搴撳瓨璁板綍鏃讹紝鎺掑簭瀛楁鎸夌収man_loc_detl琛ㄧ殑createTime鍗囧簭鎺掑簭 -// return " create_time ASC"; -// } -// -// private String isFree() { -// //璁惧绌洪棽鎯呭喌锛氫紭鍏堟煡璇㈢┖闂茬殑璁惧锛屽湪鏈夌┖闂茬殑璁惧鏃讹紝浠庣┖闂茬殑璁惧瀵瑰簲鐨勮揣鏋朵笂鏌ヨ -// //TODO -// return " create_time ASC"; -// } -// -// private String isBarcodeDesc() { -// //鎵樼洏鏈�澶у�奸檷搴忥細灏辨槸鎸夌収鎵樼洏鍙烽檷搴� -// return " barcode DESC"; -// } -// -// private String isBarcodeAsc() { -// //鎵樼洏鏈�澶у�煎崌搴忥細灏辨槸鎸夌収鎵樼洏鍙峰崌搴� -// return " barcode ASC"; -// } -// -// private String isEven() { -// // 妤煎眰鍧囧寑鍒嗗竷锛� -// //TODO -// return " barcode ASC"; -// } -// -//} +//package com.zy.asrs.wms.common.interceptor; +// +//import com.baomidou.mybatisplus.core.toolkit.PluginUtils; +//import com.baomidou.mybatisplus.extension.plugins.inner.InnerInterceptor; +//import org.apache.ibatis.executor.Executor; +//import org.apache.ibatis.mapping.BoundSql; +//import org.apache.ibatis.mapping.MappedStatement; +//import org.apache.ibatis.session.ResultHandler; +//import org.apache.ibatis.session.RowBounds; +// +//import java.sql.SQLException; +// +// +//public class StockSortInterceptor implements InnerInterceptor { +// +// @Override +// public void beforeQuery(Executor executor, MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql) throws SQLException { +// // 鑾峰彇鍘熷SQL璇彞 +// String originalSql = boundSql.getSql(); +// // 鍒ゆ柇鏂规硶鏄惁涓虹壒瀹氱殑鏌ヨ鏂规硶 +// if (isSpecificQueryMethod(ms)) { +// // 娣诲姞鎺掑簭閫昏緫 +// String sql = addSort(originalSql); +// // 淇敼瀹屾垚鐨剆ql 鍐嶈缃洖鍘� +// PluginUtils.MPBoundSql mpBoundSql = PluginUtils.mpBoundSql(boundSql); +// mpBoundSql.sql(sql); +// } +// } +// +// private boolean isSpecificQueryMethod(MappedStatement ms) { +// // 妫�鏌appedStatement鐨処D浠ュ垽鏂槸鍚︿负鐗瑰畾鐨勬煡璇㈡柟娉� +// String statementId = ms.getId(); +// return statementId.equals("com.zy.asrs.wms.asrs.mapper.LocDetlMapper.getStock"); +// } +// +// private String addSort(String originalSql) { +// // 鏍规嵁闇�瑕佹坊鍔犳帓搴忛�昏緫 +// return originalSql + " ORDER BY" + isQueue(); +// } +// +// private String isQueue() { +// //鍏堣繘鍏堝嚭锛氬湪鏌ヨ搴撳瓨璁板綍鏃讹紝鎺掑簭瀛楁鎸夌収man_loc_detl琛ㄧ殑createTime鍗囧簭鎺掑簭 +// return " create_time ASC"; +// } +// +// private String isFree() { +// //璁惧绌洪棽鎯呭喌锛氫紭鍏堟煡璇㈢┖闂茬殑璁惧锛屽湪鏈夌┖闂茬殑璁惧鏃讹紝浠庣┖闂茬殑璁惧瀵瑰簲鐨勮揣鏋朵笂鏌ヨ +// //TODO +// return " create_time ASC"; +// } +// +// private String isBarcodeDesc() { +// //鎵樼洏鏈�澶у�奸檷搴忥細灏辨槸鎸夌収鎵樼洏鍙烽檷搴� +// return " barcode DESC"; +// } +// +// private String isBarcodeAsc() { +// //鎵樼洏鏈�澶у�煎崌搴忥細灏辨槸鎸夌収鎵樼洏鍙峰崌搴� +// return " barcode ASC"; +// } +// +// private String isEven() { +// // 妤煎眰鍧囧寑鍒嗗竷锛� +// //TODO +// return " barcode ASC"; +// } +// +//} -- Gitblit v1.9.1