package cn.com.tobosoft.epolicy.task;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import org.apache.log4j.Logger;
import com.alibaba.fastjson.JSON;
import cn.com.tobosoft.epolicy.customer.model.StatusUpdateInfo;
import cn.com.tobosoft.epolicy.policycheck.common.SpringCfgPropHelper;
import cn.com.tobosoft.epolicy.policycheck.rechargeable.biz.action.SendConfirmSignStatusToDMS;
import cn.com.tobosoft.epolicy.report.biz.service.ReportService;
public class PolicyReSendRouteTask {
protected static Logger logger = Logger.getLogger(PolicyReSendRouteTask.class);
ReportService reportService;
public ReportService getReportService() {
return reportService;
}
public void setReportService(ReportService reportService) {
this.reportService = reportService;
}
public void getReSendRouteJob() throws Exception {
//String sql = "select policy_info_id as policyInfoId,policy_no as policyNo,sign_status as signStatus,sign_status_updated_time as signStatusUpdatedTime from policy_info where import_time>'2022-06-07 20:00' and confirmSign='Y' and vipFlag='3' and signSendResult='1' and sign_status in ('0','1')";
String sql = "select policy_info_id as policyInfoId,policy_no as policyNo,sign_status as signStatus,sign_status_updated_time as signStatusUpdatedTime from policy_info where import_time>'2022-06-07 20:00' and confirmSign='Y' and vipFlag='3' and signSendResult='1' and sign_status in ('0','1')";
List


