From a6470c4de7867f5478197c390c158ad730ff5bae Mon Sep 17 00:00:00 2001
From: lrj <386002446@qq.com>
Date: 星期五, 25 十月 2024 14:51:21 +0800
Subject: [PATCH] bug
---
src/test/java/org/example/test.groovy | 31 +++++++++++++++++--------------
1 files changed, 17 insertions(+), 14 deletions(-)
diff --git a/src/test/java/org/example/test.groovy b/src/test/java/org/example/test.groovy
index 895a94e..73c0819 100644
--- a/src/test/java/org/example/test.groovy
+++ b/src/test/java/org/example/test.groovy
@@ -1,4 +1,5 @@
package com.ycl.scheme;
+
import java.util.List;
import java.util.ArrayList;
import java.util.ArrayList;
@@ -8,7 +9,9 @@
import java.time.LocalDate;
class scheme_1 extends AbstractSchemeRunner {
SchemeService service;
- void run(SchemeService service){
+ @Override
+ void run(Map<String,Parameter> pars,SchemeService service){
+ super.parameters.putAll(pars);
this.service = service;
if(func_0() &&func_1() ){
service.doAction(1)
@@ -16,12 +19,12 @@
}
def func_0(){
- List<Object> pars = new ArrayList<>();
- def sql= "select count() from t_info where create_time between ? and ? and content like '%鎶㈠ず%' and address like '%閲戠墰澶ч亾%' "
- def p_0 = LocalDateTime.now();;
- pars.add(p_0);
- def p_1 = LocalDateTime.now().minusDays(5);;
- pars.add(p_1);
+ Map<String,Object> pars = super.getSqlParameters();
+ def sql= "select count(*) from t_info where create_time between :beginTime and :endTime and content like '%鎶㈠ず%' and address like '%閲戠墰澶ч亾%' ";
+ def p_endTime = LocalDateTime.now();
+ pars.put('endTime',p_endTime);
+ def p_beginTime = LocalDateTime.now().minusDays(5);
+ pars.put('beginTime',p_beginTime);
def rs = service.execQuery(sql,pars);
if(rs > 2){
return true;
@@ -30,14 +33,14 @@
}
}
def func_1(){
- List<Object> pars = new ArrayList<>();
- def sql= "select from t_case where create_time between ? and ? and content like '%鍛芥%' and address like '%閲戠墰澶ч亾%' "
- def p_0 = LocalDateTime.now();;
- pars.add(p_0);
- def p_1 = LocalDateTime.now().minusDays(5);;
- pars.add(p_1);
+ Map<String,Object> pars = super.getSqlParameters();
+ def sql= "select sum(amt) from t_case where create_time between :beginTime and :endTime and content like '%璇堥獥%' and address like '%閾剁墰澶ч亾%' ";
+ def p_endTime = LocalDateTime.now();
+ pars.put('endTime',p_endTime);
+ def p_beginTime = LocalDateTime.now().minusDays(5);
+ pars.put('beginTime',p_beginTime);
def rs = service.execQuery(sql,pars);
- if(rs >=2){
+ if(rs >=100000){
return true;
}else{
return false;
--
Gitblit v1.8.0