传统办法管理信息首先需要花费的时间比较多，其次数据出错率比较高，而且对错误的数据进行更改也比较困难，最后，检索数据费事费力。因此，在计算机上安装扶贫助农系统软件来发挥其高效地信息处理的作用，可以规范信息管理流程，让管理工作可以系统化和程序化，同时，扶贫助农系统的有效运用可以帮助管理人员准确快速地处理信息。
扶贫助农系统在对开发工具的选择上也很慎重，为了便于开发实现，选择的开发工具为Eclipse，选择的数据库工具为Mysql。以此搭建开发环境实现扶贫助农系统的功能。其中管理员管理用户，新闻公告。
扶贫助农系统是一款运用软件开发技术设计实现的应用系统，在信息处理上可以达到快速的目的，不管是针对数据添加，数据维护和统计，以及数据查询等处理要求，扶贫助农系统都可以轻松应对。
关键词：扶贫助农系统；SpringBoot框架，系统分析，数据库设计
基于springboot的扶贫助农系统源码和论文612
演示视频：
基于springboot的扶贫助农系统源码和论文
Abstract
The traditional method of managing public transportation information first takes more time, and secondly, the data error rate is relatively high, and it is more difficult to modify the wrong data, and finally, it is laborious and laborious to retrieve the data. Therefore, installing the public transportation query website software on the computer to play its role in efficient information processing can standardize the public transportation information management process, so that the management work can be systematized and programmed. At the same time, the effective use of the public transportation query website can help managers accurately Process information quickly.
The public transportation query website is also very cautious in the selection of development tools. In order to facilitate the development and realization, the selected development tool is Eclipse, and the selected database tool is Mysql. In this way, the development environment is built to realize the functions of the public transport query website. Among them, the administrator manages users, drivers, news announcements, manages vehicles, stations, and trip information in the route management module, and responds to users' suggested messages in the message suggestion management module. Users inquire about the site, inquire about transfer information, post message suggestions, and check news announcements.
The bus query website is an application system designed and implemented using software development technology. It can achieve rapid information processing. Whether it is for data addition, data maintenance and statistics, and data query processing requirements, the bus query website can easily response.
Key Words：Public transport query website; bus number information; suggestion to leave a message; query site
package com.controller;
import java.io.File;
import java.math.BigDecimal;
import java.net.URL;
import java.text.SimpleDateFormat;
import com.alibaba.fastjson.JSONObject;
import java.util.*;
import org.springframework.beans.BeanUtils;
import javax.servlet.http.HttpServletRequest;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import com.service.TokenService;
import com.utils.*;
import java.lang.reflect.InvocationTargetException;
import com.service.DictionaryService;
import org.apache.commons.lang3.StringUtils;
import com.annotation.IgnoreAuth;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.*;
import com.entity.view.*;
import com.service.*;
import com.utils.PageUtils;
import com.utils.R;
import com.alibaba.fastjson.*;
/**
* 客服聊天
* 后端接口
* @author
* @email
*/
@RestController
@Controller
@RequestMapping("/chat")
public class ChatController {
private static final Logger logger = LoggerFactory.getLogger(ChatController.class);
private static final String TABLE_NAME = "chat";
@Autowired
private ChatService chatService;
@Autowired
private TokenService tokenService;
@Autowired
private DictionaryService dictionaryService;//字典
@Autowired
private ForumService forumService;//论坛
@Autowired
private NewsService newsService;//扶贫公告
@Autowired
private RenwuService renwuService;//任务信息
@Autowired
private RenwuYuyueService renwuYuyueService;//任务报名
@Autowired
private XinwenService xinwenService;//新闻信息
@Autowired
private XinwenCollectionService xinwenCollectionService;//新闻收藏
@Autowired
private XinwenLiuyanService xinwenLiuyanService;//新闻留言
@Autowired
private YonghuService yonghuService;//用户
@Autowired
private UsersService usersService;//管理员
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("page方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永不会进入");
else if("用户".equals(role))
params.put("yonghuId",request.getSession().getAttribute("userId"));
CommonUtil.checkMap(params);
PageUtils page = chatService.queryPage(params);
//字典表数据转换
List<ChatView> list =(List<ChatView>)page.getList();
for(ChatView c:list){
//修改对应字典表字段
dictionaryService.dictionaryConvert(c, request);
}
return R.ok().put("data", page);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("info方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
ChatEntity chat = chatService.selectById(id);
if(chat !=null){
//entity转view
ChatView view = new ChatView();
BeanUtils.copyProperties( chat , view );//把实体数据重构到view中
//级联表 用户
//级联表
YonghuEntity yonghu = yonghuService.selectById(chat.getYonghuId());
if(yonghu != null){
BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createTime", "insertTime", "updateTime", "yonghuId"});//把级联的数据添加到view中,并排除id和创建时间字段,当前表的级联注册表
view.setYonghuId(yonghu.getId());
}
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody ChatEntity chat, HttpServletRequest request){
logger.debug("save方法:,,Controller:{},,chat:{}",this.getClass().getName(),chat.toString());
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永远不会进入");
else if("用户".equals(role))
chat.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
Wrapper<ChatEntity> queryWrapper = new EntityWrapper<ChatEntity>()
.eq("yonghu_id", chat.getYonghuId())
.eq("chat_issue", chat.getChatIssue())
.eq("chat_reply", chat.getChatReply())
.eq("zhuangtai_types", chat.getZhuangtaiTypes())
.eq("chat_types", chat.getChatTypes())
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ChatEntity chatEntity = chatService.selectOne(queryWrapper);
if(chatEntity==null){
chat.setInsertTime(new Date());
chatService.insert(chat);
return R.ok();
}else {
return R.error(511,"表中有相同数据");
}
}
/**
* 后端修改
*/
@RequestMapping("/update")
public R update(@RequestBody ChatEntity chat, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {
logger.debug("update方法:,,Controller:{},,chat:{}",this.getClass().getName(),chat.toString());
ChatEntity oldChatEntity = chatService.selectById(chat.getId());//查询原先数据
String role = String.valueOf(request.getSession().getAttribute("role"));
// if(false)
// return R.error(511,"永远不会进入");
// else if("用户".equals(role))
// chat.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
chatService.updateById(chat);//根据id更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Integer[] ids, HttpServletRequest request){
logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString());
List<ChatEntity> oldChatList =chatService.selectBatchIds(Arrays.asList(ids));//要删除的数据
chatService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
/**
* 批量上传
*/
@RequestMapping("/batchInsert")
public R save( String fileName, HttpServletRequest request){
logger.debug("batchInsert方法:,,Controller:{},,fileName:{}",this.getClass().getName(),fileName);
Integer yonghuId = Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId")));
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//.eq("time", new SimpleDateFormat("yyyy-MM-dd").format(new Date()))
try {
List<ChatEntity> chatList = new ArrayList<>();//上传的东西
Map<String, List<String>> seachFields= new HashMap<>();//要查询的字段
Date date = new Date();
int lastIndexOf = fileName.lastIndexOf(".");
if(lastIndexOf == -1){
return R.error(511,"该文件没有后缀");
}else{
String suffix = fileName.substring(lastIndexOf);
if(!".xls".equals(suffix)){
return R.error(511,"只支持后缀为xls的excel文件");
}else{
URL resource = this.getClass().getClassLoader().getResource("static/upload/" + fileName);//获取文件路径
File file = new File(resource.getFile());
if(!file.exists()){
return R.error(511,"找不到上传文件，请联系管理员");
}else{
List<List<String>> dataList = PoiUtil.poiImport(file.getPath());//读取xls文件
dataList.remove(0);//删除第一行，因为第一行是提示
for(List<String> data:dataList){
//循环
ChatEntity chatEntity = new ChatEntity();
// chatEntity.setYonghuId(Integer.valueOf(data.get(0))); //提问用户 要改的
// chatEntity.setChatIssue(data.get(0)); //问题 要改的
// chatEntity.setIssueTime(sdf.parse(data.get(0))); //问题时间 要改的
// chatEntity.setChatReply(data.get(0)); //回复 要改的
// chatEntity.setReplyTime(sdf.parse(data.get(0))); //回复时间 要改的
// chatEntity.setZhuangtaiTypes(Integer.valueOf(data.get(0))); //状态 要改的
// chatEntity.setChatTypes(Integer.valueOf(data.get(0))); //数据类型 要改的
// chatEntity.setInsertTime(date);//时间
chatList.add(chatEntity);
//把要查询是否重复的字段放入map中
}
//查询是否重复
chatService.insertBatch(chatList);
return R.ok();
}
}
}
}catch (Exception e){
e.printStackTrace();
return R.error(511,"批量插入数据异常，请联系管理员");
}
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("list方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
CommonUtil.checkMap(params);
PageUtils page = chatService.queryPage(params);
//字典表数据转换
List<ChatView> list =(List<ChatView>)page.getList();
for(ChatView c:list)
dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段
return R.ok().put("data", page);
}
/**
* 前端详情
*/
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("detail方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
ChatEntity chat = chatService.selectById(id);
if(chat !=null){
//entity转view
ChatView view = new ChatView();
BeanUtils.copyProperties( chat , view );//把实体数据重构到view中
//级联表
YonghuEntity yonghu = yonghuService.selectById(chat.getYonghuId());
if(yonghu != null){
BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createDate"});//把级联的数据添加到view中,并排除id和创建时间字段
view.setYonghuId(yonghu.getId());
}
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody ChatEntity chat, HttpServletRequest request){
logger.debug("add方法:,,Controller:{},,chat:{}",this.getClass().getName(),chat.toString());
Wrapper<ChatEntity> queryWrapper = new EntityWrapper<ChatEntity>()
.eq("yonghu_id", chat.getYonghuId())
.eq("chat_issue", chat.getChatIssue())
.eq("chat_reply", chat.getChatReply())
.eq("zhuangtai_types", chat.getZhuangtaiTypes())
.eq("chat_types", chat.getChatTypes())
// .notIn("chat_types", new Integer[]{102})
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ChatEntity chatEntity = chatService.selectOne(queryWrapper);
if(chatEntity==null){
chat.setInsertTime(new Date());
chatService.insert(chat);
return R.ok();
}else {
return R.error(511,"表中有相同数据");
}
}
}
package com.controller;
import java.io.File;
import java.math.BigDecimal;
import java.net.URL;
import java.text.SimpleDateFormat;
import com.alibaba.fastjson.JSONObject;
import java.util.*;
import org.springframework.beans.BeanUtils;
import javax.servlet.http.HttpServletRequest;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import com.service.TokenService;
import com.utils.*;
import java.lang.reflect.InvocationTargetException;
import com.service.DictionaryService;
import org.apache.commons.lang3.StringUtils;
import com.annotation.IgnoreAuth;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.*;
import com.entity.view.*;
import com.service.*;
import com.utils.PageUtils;
import com.utils.R;
import com.alibaba.fastjson.*;
/**
* 业务人员
* 后端接口
* @author
* @email
*/
@RestController
@Controller
@RequestMapping("/yewurenyuan")
public class YewurenyuanController {
private static final Logger logger = LoggerFactory.getLogger(YewurenyuanController.class);
private static final String TABLE_NAME = "yewurenyuan";
@Autowired
private YewurenyuanService yewurenyuanService;
@Autowired
private TokenService tokenService;
@Autowired
private BaoxiuService baoxiuService;//报修
@Autowired
private BaoxiuCommentbackService baoxiuCommentbackService;//报修评价
@Autowired
private BaoxiuFenpeiService baoxiuFenpeiService;//报修分配
@Autowired
private DictionaryService dictionaryService;//字典
@Autowired
private FeiyongService feiyongService;//宽带缴费
@Autowired
private ForumService forumService;//论坛
@Autowired
private GonggaoService gonggaoService;//公告
@Autowired
private KuandaiService kuandaiService;//宽带
@Autowired
private KuandaiCollectionService kuandaiCollectionService;//宽带收藏
@Autowired
private KuandaiLiuyanService kuandaiLiuyanService;//宽带留言
@Autowired
private KuandaiOrderService kuandaiOrderService;//宽带开户
@Autowired
private KuandaiYuyueService kuandaiYuyueService;//宽带预约安装
@Autowired
private QianyiYuyueService qianyiYuyueService;//迁移申请
@Autowired
private YonghuService yonghuService;//用户
@Autowired
private UsersService usersService;//管理员
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("page方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永不会进入");
else if("用户".equals(role))
params.put("yonghuId",request.getSession().getAttribute("userId"));
else if("业务人员".equals(role))
params.put("yewurenyuanId",request.getSession().getAttribute("userId"));
CommonUtil.checkMap(params);
PageUtils page = yewurenyuanService.queryPage(params);
//字典表数据转换
List<YewurenyuanView> list =(List<YewurenyuanView>)page.getList();
for(YewurenyuanView c:list){
//修改对应字典表字段
dictionaryService.dictionaryConvert(c, request);
}
return R.ok().put("data", page);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("info方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
YewurenyuanEntity yewurenyuan = yewurenyuanService.selectById(id);
if(yewurenyuan !=null){
//entity转view
YewurenyuanView view = new YewurenyuanView();
BeanUtils.copyProperties( yewurenyuan , view );//把实体数据重构到view中
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody YewurenyuanEntity yewurenyuan, HttpServletRequest request){
logger.debug("save方法:,,Controller:{},,yewurenyuan:{}",this.getClass().getName(),yewurenyuan.toString());
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永远不会进入");
Wrapper<YewurenyuanEntity> queryWrapper = new EntityWrapper<YewurenyuanEntity>()
.eq("username", yewurenyuan.getUsername())
.or()
.eq("yewurenyuan_phone", yewurenyuan.getYewurenyuanPhone())
.or()
.eq("yewurenyuan_id_number", yewurenyuan.getYewurenyuanIdNumber())
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
YewurenyuanEntity yewurenyuanEntity = yewurenyuanService.selectOne(queryWrapper);
if(yewurenyuanEntity==null){
yewurenyuan.setCreateTime(new Date());
yewurenyuan.setPassword("123456");
yewurenyuanService.insert(yewurenyuan);
return R.ok();
}else {
return R.error(511,"账户或者业务人员手机号或者业务人员身份证号已经被使用");
}
}
/**
* 后端修改
*/
@RequestMapping("/update")
public R update(@RequestBody YewurenyuanEntity yewurenyuan, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {
logger.debug("update方法:,,Controller:{},,yewurenyuan:{}",this.getClass().getName(),yewurenyuan.toString());
YewurenyuanEntity oldYewurenyuanEntity = yewurenyuanService.selectById(yewurenyuan.getId());//查询原先数据
String role = String.valueOf(request.getSession().getAttribute("role"));
// if(false)
// return R.error(511,"永远不会进入");
if("".equals(yewurenyuan.getYewurenyuanPhoto()) || "null".equals(yewurenyuan.getYewurenyuanPhoto())){
yewurenyuan.setYewurenyuanPhoto(null);
}
yewurenyuanService.updateById(yewurenyuan);//根据id更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Integer[] ids, HttpServletRequest request){
logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString());
List<YewurenyuanEntity> oldYewurenyuanList =yewurenyuanService.selectBatchIds(Arrays.asList(ids));//要删除的数据
yewurenyuanService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
/**
* 批量上传
*/
@RequestMapping("/batchInsert")
public R save( String fileName, HttpServletRequest request){
logger.debug("batchInsert方法:,,Controller:{},,fileName:{}",this.getClass().getName(),fileName);
Integer yonghuId = Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId")));
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
try {
List<YewurenyuanEntity> yewurenyuanList = new ArrayList<>();//上传的东西
Map<String, List<String>> seachFields= new HashMap<>();//要查询的字段
Date date = new Date();
int lastIndexOf = fileName.lastIndexOf(".");
if(lastIndexOf == -1){
return R.error(511,"该文件没有后缀");
}else{
String suffix = fileName.substring(lastIndexOf);
if(!".xls".equals(suffix)){
return R.error(511,"只支持后缀为xls的excel文件");
}else{
URL resource = this.getClass().getClassLoader().getResource("static/upload/" + fileName);//获取文件路径
File file = new File(resource.getFile());
if(!file.exists()){
return R.error(511,"找不到上传文件，请联系管理员");
}else{
List<List<String>> dataList = PoiUtil.poiImport(file.getPath());//读取xls文件
dataList.remove(0);//删除第一行，因为第一行是提示
for(List<String> data:dataList){
//循环
YewurenyuanEntity yewurenyuanEntity = new YewurenyuanEntity();
// yewurenyuanEntity.setUsername(data.get(0)); //账户 要改的
// //yewurenyuanEntity.setPassword("123456");//密码
// yewurenyuanEntity.setYewurenyuanName(data.get(0)); //业务人员姓名 要改的
// yewurenyuanEntity.setYewurenyuanPhone(data.get(0)); //业务人员手机号 要改的
// yewurenyuanEntity.setYewurenyuanIdNumber(data.get(0)); //业务人员身份证号 要改的
// yewurenyuanEntity.setYewurenyuanPhoto("");//详情和图片
// yewurenyuanEntity.setSexTypes(Integer.valueOf(data.get(0))); //性别 要改的
// yewurenyuanEntity.setNewMoney(data.get(0)); //余额 要改的
// yewurenyuanEntity.setYewurenyuanEmail(data.get(0)); //业务人员邮箱 要改的
// yewurenyuanEntity.setCreateTime(date);//时间
yewurenyuanList.add(yewurenyuanEntity);
//把要查询是否重复的字段放入map中
//账户
if(seachFields.containsKey("username")){
List<String> username = seachFields.get("username");
username.add(data.get(0));//要改的
}else{
List<String> username = new ArrayList<>();
username.add(data.get(0));//要改的
seachFields.put("username",username);
}
//业务人员手机号
if(seachFields.containsKey("yewurenyuanPhone")){
List<String> yewurenyuanPhone = seachFields.get("yewurenyuanPhone");
yewurenyuanPhone.add(data.get(0));//要改的
}else{
List<String> yewurenyuanPhone = new ArrayList<>();
yewurenyuanPhone.add(data.get(0));//要改的
seachFields.put("yewurenyuanPhone",yewurenyuanPhone);
}
//业务人员身份证号
if(seachFields.containsKey("yewurenyuanIdNumber")){
List<String> yewurenyuanIdNumber = seachFields.get("yewurenyuanIdNumber");
yewurenyuanIdNumber.add(data.get(0));//要改的
}else{
List<String> yewurenyuanIdNumber = new ArrayList<>();
yewurenyuanIdNumber.add(data.get(0));//要改的
seachFields.put("yewurenyuanIdNumber",yewurenyuanIdNumber);
}
}
//查询是否重复
//账户
List<YewurenyuanEntity> yewurenyuanEntities_username = yewurenyuanService.selectList(new EntityWrapper<YewurenyuanEntity>().in("username", seachFields.get("username")));
if(yewurenyuanEntities_username.size() >0 ){
ArrayList<String> repeatFields = new ArrayList<>();
for(YewurenyuanEntity s:yewurenyuanEntities_username){
repeatFields.add(s.getUsername());
}
return R.error(511,"数据库的该表中的 [账户] 字段已经存在 存在数据为:"+repeatFields.toString());
}
//业务人员手机号
List<YewurenyuanEntity> yewurenyuanEntities_yewurenyuanPhone = yewurenyuanService.selectList(new EntityWrapper<YewurenyuanEntity>().in("yewurenyuan_phone", seachFields.get("yewurenyuanPhone")));
if(yewurenyuanEntities_yewurenyuanPhone.size() >0 ){
ArrayList<String> repeatFields = new ArrayList<>();
for(YewurenyuanEntity s:yewurenyuanEntities_yewurenyuanPhone){
repeatFields.add(s.getYewurenyuanPhone());
}
return R.error(511,"数据库的该表中的 [业务人员手机号] 字段已经存在 存在数据为:"+repeatFields.toString());
}
//业务人员身份证号
List<YewurenyuanEntity> yewurenyuanEntities_yewurenyuanIdNumber = yewurenyuanService.selectList(new EntityWrapper<YewurenyuanEntity>().in("yewurenyuan_id_number", seachFields.get("yewurenyuanIdNumber")));
if(yewurenyuanEntities_yewurenyuanIdNumber.size() >0 ){
ArrayList<String> repeatFields = new ArrayList<>();
for(YewurenyuanEntity s:yewurenyuanEntities_yewurenyuanIdNumber){
repeatFields.add(s.getYewurenyuanIdNumber());
}
return R.error(511,"数据库的该表中的 [业务人员身份证号] 字段已经存在 存在数据为:"+repeatFields.toString());
}
yewurenyuanService.insertBatch(yewurenyuanList);
return R.ok();
}
}
}
}catch (Exception e){
e.printStackTrace();
return R.error(511,"批量插入数据异常，请联系管理员");
}
}
/**
* 登录
*/
@IgnoreAuth
@RequestMapping(value = "/login")
public R login(String username, String password, String captcha, HttpServletRequest request) {
YewurenyuanEntity yewurenyuan = yewurenyuanService.selectOne(new EntityWrapper<YewurenyuanEntity>().eq("username", username));
if(yewurenyuan==null || !yewurenyuan.getPassword().equals(password))
return R.error("账号或密码不正确");
String token = tokenService.generateToken(yewurenyuan.getId(),username, "yewurenyuan", "业务人员");
R r = R.ok();
r.put("token", token);
r.put("role","业务人员");
r.put("username",yewurenyuan.getYewurenyuanName());
r.put("tableName","yewurenyuan");
r.put("userId",yewurenyuan.getId());
return r;
}
/**
* 注册
*/
@IgnoreAuth
@PostMapping(value = "/register")
public R register(@RequestBody YewurenyuanEntity yewurenyuan, HttpServletRequest request) {
// ValidatorUtils.validateEntity(user);
Wrapper<YewurenyuanEntity> queryWrapper = new EntityWrapper<YewurenyuanEntity>()
.eq("username", yewurenyuan.getUsername())
.or()
.eq("yewurenyuan_phone", yewurenyuan.getYewurenyuanPhone())
.or()
.eq("yewurenyuan_id_number", yewurenyuan.getYewurenyuanIdNumber())
;
YewurenyuanEntity yewurenyuanEntity = yewurenyuanService.selectOne(queryWrapper);
if(yewurenyuanEntity != null)
return R.error("账户或者业务人员手机号或者业务人员身份证号已经被使用");
yewurenyuan.setNewMoney(0.0);
yewurenyuan.setCreateTime(new Date());
yewurenyuanService.insert(yewurenyuan);
return R.ok();
}
/**
* 重置密码
*/
@GetMapping(value = "/resetPassword")
public R resetPassword(Integer id, HttpServletRequest request) {
YewurenyuanEntity yewurenyuan = yewurenyuanService.selectById(id);
yewurenyuan.setPassword("123456");
yewurenyuanService.updateById(yewurenyuan);
return R.ok();
}
/**
* 修改密码
*/
@GetMapping(value = "/updatePassword")
public R updatePassword(String oldPassword, String newPassword, HttpServletRequest request) {
YewurenyuanEntity yewurenyuan = yewurenyuanService.selectById((Integer)request.getSession().getAttribute("userId"));
if(newPassword == null){
return R.error("新密码不能为空") ;
}
if(!oldPassword.equals(yewurenyuan.getPassword())){
return R.error("原密码输入错误");
}
if(newPassword.equals(yewurenyuan.getPassword())){
return R.error("新密码不能和原密码一致") ;
}
yewurenyuan.setPassword(newPassword);
yewurenyuanService.updateById(yewurenyuan);
return R.ok();
}
/**
* 忘记密码
*/
@IgnoreAuth
@RequestMapping(value = "/resetPass")
public R resetPass(String username, HttpServletRequest request) {
YewurenyuanEntity yewurenyuan = yewurenyuanService.selectOne(new EntityWrapper<YewurenyuanEntity>().eq("username", username));
if(yewurenyuan!=null){
yewurenyuan.setPassword("123456");
yewurenyuanService.updateById(yewurenyuan);
return R.ok();
}else{
return R.error("账号不存在");
}
}
/**
* 获取用户的session用户信息
*/
@RequestMapping("/session")
public R getCurrYewurenyuan(HttpServletRequest request){
Integer id = (Integer)request.getSession().getAttribute("userId");
YewurenyuanEntity yewurenyuan = yewurenyuanService.selectById(id);
if(yewurenyuan !=null){
//entity转view
YewurenyuanView view = new YewurenyuanView();
BeanUtils.copyProperties( yewurenyuan , view );//把实体数据重构到view中
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 退出
*/
@GetMapping(value = "logout")
public R logout(HttpServletRequest request) {
request.getSession().invalidate();
return R.ok("退出成功");
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("list方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
CommonUtil.checkMap(params);
PageUtils page = yewurenyuanService.queryPage(params);
//字典表数据转换
List<YewurenyuanView> list =(List<YewurenyuanView>)page.getList();
for(YewurenyuanView c:list)
dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段
return R.ok().put("data", page);
}
/**
* 前端详情
*/
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("detail方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
YewurenyuanEntity yewurenyuan = yewurenyuanService.selectById(id);
if(yewurenyuan !=null){
//entity转view
YewurenyuanView view = new YewurenyuanView();
BeanUtils.copyProperties( yewurenyuan , view );//把实体数据重构到view中
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody YewurenyuanEntity yewurenyuan, HttpServletRequest request){
logger.debug("add方法:,,Controller:{},,yewurenyuan:{}",this.getClass().getName(),yewurenyuan.toString());
Wrapper<YewurenyuanEntity> queryWrapper = new EntityWrapper<YewurenyuanEntity>()
.eq("username", yewurenyuan.getUsername())
.or()
.eq("yewurenyuan_phone", yewurenyuan.getYewurenyuanPhone())
.or()
.eq("yewurenyuan_id_number", yewurenyuan.getYewurenyuanIdNumber())
// .notIn("yewurenyuan_types", new Integer[]{102})
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
YewurenyuanEntity yewurenyuanEntity = yewurenyuanService.selectOne(queryWrapper);
if(yewurenyuanEntity==null){
yewurenyuan.setCreateTime(new Date());
yewurenyuan.setPassword("123456");
yewurenyuanService.insert(yewurenyuan);
return R.ok();
}else {
return R.error(511,"账户或者业务人员手机号或者业务人员身份证号已经被使用");
}
}
}
扫一扫
536
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
