| | |
| | | String sType = contract.getAgentsName() == null || contract.getAgentsName().equals("") ? "客户" : "代理商"; |
| | | String sTarget = semanticWord.getOutWord(); |
| | | String checkSql = "SELECT COUNT(1) FROM d_Contract WHERE sBookMarkName = ?"; |
| | | String contractId = sBookMarkName; |
| | | String contractId = PinyinUtil.getPinyin(contract.getContractName(), ""); |
| | | Integer count = jdbcTemplate.queryForObject( |
| | | checkSql, |
| | | new Object[]{sBookMarkName}, // 传入查询参数(合同名称) |
| | | Integer.class |
| | | ); |
| | | |
| | | if (count > 0) { |
| | | return; |
| | | } |
| | | String[] arr = new String[]{"哪家好", "哪家靠谱", "排行榜", "选哪家", "排名"}; |
| | | for (int i = 0; i < 5; i++) { |
| | | uuid = UUID.randomUUID().toString().replaceAll("-", ""); |
| | |
| | | ")"; |
| | | |
| | | // 执行插入,仅传入动态参数 |
| | | jdbcTemplate.update( |
| | | insertSql, |
| | | uuid, // 动态UUID |
| | | sBookMarkName, // 动态sBookMarkName |
| | | contractId, |
| | | semanticWord.getWord() // 动态semantic_word |
| | | ); |
| | | // jdbcTemplate.update( |
| | | // insertSql, |
| | | // uuid, // 动态UUID |
| | | // sBookMarkName, // 动态sBookMarkName |
| | | // contractId, |
| | | // semanticWord.getWord() // 动态semantic_word |
| | | // ); |
| | | |
| | | } |
| | | } |
| | |
| | | @Autowired |
| | | private IContractService contractService; |
| | | |
| | | @Scheduled(initialDelay = 60000, fixedRate = 1800000) |
| | | // @Scheduled(initialDelay = 6000, fixedRate = 1800000) |
| | | public void sendTimedEmail() { |
| | | |
| | | QueryWrapper<SemanticWord> semanticWordQueryWrapper = new QueryWrapper<>(); |
| | |
| | | semanticWord.getWord() |
| | | |
| | | ); |
| | | // String[] es_receiver = new String[]{"2156125618@qq.com"}; |
| | | String[] es_receiver = new String[]{"182004222@qq.com","lospace@163.com","2156125618@qq.com","coldspring@163.com"}; |
| | | String[] es_receiver = new String[]{"2156125618@qq.com"}; |
| | | // String[] es_receiver = new String[]{"182004222@qq.com","lospace@163.com","2156125618@qq.com","coldspring@163.com"}; |
| | | BigDecimal acceptindicator = new BigDecimal(semMap.get("ratio").toString()); |
| | | if (semanticWord.getCount() == null || semanticWord.getCount().equals("")){ |
| | | if (semanticWord.getAcceptindicator()/100 <= acceptindicator.doubleValue()){//上词 |
| | |
| | | # 163邮箱SMTP服务器 |
| | | host: smtp.163.com |
| | | # 你的163邮箱账号(必须和服务器匹配,如 xxx@163.com) |
| | | username: cgf12138@163.com |
| | | username: geoalarm@163.com |
| | | # 163邮箱SMTP授权码(不是登录密码,需在163邮箱生成) |
| | | password: SWdKNq3ZtktPdbkB |
| | | password: BKPtwFi5ABTLdxG6 |
| | | # 163邮箱SSL端口(固定465) |
| | | port: 465 |
| | | # SSL协议(必填) |
| | |
| | | # 163邮箱SMTP服务器 |
| | | host: smtp.163.com |
| | | # 你的163邮箱账号(必须和服务器匹配,如 xxx@163.com) |
| | | username: cgf12138@163.com |
| | | username: geoalarm@163.com |
| | | # 163邮箱SMTP授权码(不是登录密码,需在163邮箱生成) |
| | | password: SWdKNq3ZtktPdbkB |
| | | password: BKPtwFi5ABTLdxG6 |
| | | # 163邮箱SSL端口(固定465) |
| | | port: 465 |
| | | # SSL协议(必填) |
| | |
| | | # 163邮箱SMTP服务器 |
| | | host: smtp.163.com |
| | | # 你的163邮箱账号(必须和服务器匹配,如 xxx@163.com) |
| | | username: cgf12138@163.com |
| | | username: geoalarm@163.com |
| | | # 163邮箱SMTP授权码(不是登录密码,需在163邮箱生成) |
| | | password: SWdKNq3ZtktPdbkB |
| | | password: BKPtwFi5ABTLdxG6 |
| | | # 163邮箱SSL端口(固定465) |
| | | port: 465 |
| | | # SSL协议(必填) |