| | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springblade.modules.FTP.FtpUtil; |
| | | import org.springblade.modules.dispatcher.entity.Dispatcher; |
| | | import org.springblade.modules.dispatcher.entity.DispatcherUnit; |
| | | import org.springblade.modules.dispatcher.excel.DispatcherUnitExcel; |
| | |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.regex.Matcher; |
| | | import java.util.regex.Pattern; |
| | | |
| | | /** |
| | | * 服务实现类 |
| | |
| | | } |
| | | |
| | | if (dispatcherUnitExcel.getName()!=null && dispatcherUnitExcel.getName()!=""){ |
| | | //仅中文 |
| | | // String chinese = "^[\\u4E00-\\u9FA5\\uF900-\\uFA2D]+$"; |
| | | // Pattern compile = Pattern.compile(chinese); |
| | | // String name = compile.matcher(dispatcherUnitExcel.getName()).replaceAll(""); |
| | | dispatcherUnit.setName(dispatcherUnitExcel.getName()); |
| | | } |
| | | |
| | |
| | | //新增 |
| | | this.save(dispatcherUnit); |
| | | |
| | | //数据同步 |
| | | String s1 = |
| | | "insert into sys_dispatcher_unit(id,name,dept_id,linkman,phone,start_time,end_time) " + |
| | | "values(" + "'" + dispatcherUnit.getId() + "'" + "," + |
| | | "'" + dispatcherUnit.getName() + "'" + "," + |
| | | "'" + dispatcherUnit.getDeptId() + "'" + "," + |
| | | "'" + dispatcherUnit.getLinkman() + "'" + "," + |
| | | "'" + dispatcherUnit.getPhone() + "'" + "," + |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcherUnit.getStartTime()) + "'" + "," + |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcherUnit.getEndTime()) + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | }); |
| | | } |
| | | } |