基于javaweb+mysql的springboot学生会管理系统(java+springboot+thymeleaf+html+layui+bootstrap+maven+mysql)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot学生会管理系统(java+springboot+thymeleaf+html+layui+bootstrap+maven+mysql)
项目介绍
学生会管理系统.主要功能包括:
后台首页:最新活动展示、最新公告、学生会部门职能介绍; 财务管理:资金报销登记、赞助商管理; 物资管理:物资借还管理、全部物资;添加、编辑、删除; 日常事务管理:工作计划管理、活动管理、文件管理; 申请请假:添加、修改、删除、查看;
我的待办;
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.是否Maven项目: 是;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
6.数据库:MySql 5.7版本;
技术栈
-
后端:SpringBoot
-
前端:Thymeleaf+html+layui+jQuery+bootstrap
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 将项目中application.yml及activiti.cfg.xml配置文件中的数据库配置改为自己的配置; 3. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,配置tomcat,然后运行; 4. 运行项目,输入localhost:8085 登录
@RestController
@RequestMapping("notice")
public class GongaoController {
@Autowired
private IgongaoService noticeService;
/**
* 公告的查询
* @param noticeVo
* @return
*/
@RequestMapping("loadAllNotice")
public Dataobj loadAllNotice(gongaov noticeVo){
IPage<Notice> page = new Page<Notice>(noticeVo.getPage(),noticeVo.getLimit());
QueryWrapper<Notice> q = new QueryWrapper<Notice>();
//进行模糊查询
q.like(StringUtils.isNotBlank(noticeVo.getTitle()),"title",noticeVo.getTitle());
q.like(StringUtils.isNotBlank(noticeVo.getOpername()),"opername",noticeVo.getOpername());
//公告创建时间应该大于搜索开始时间小于搜索结束时间
q.ge(noticeVo.getStartTime()!=null,"createtime",noticeVo.getStartTime());
q.le(noticeVo.getEndTime()!=null,"createtime",noticeVo.getEndTime());
//根据公告创建时间进行排序
q.orderByAsc("createtime");
noticeService.page(page,q);
List list =noticeService.list(q);
long num=list.size();
if(list.isEmpty()){
return new Dataobj(null,num);
}else {
//返回DataGridView
return new Dataobj(page.getRecords(), page.getTotal());
}
}
/**
* 添加公告
* @param noticeVo
@RequestMapping("initPermissionByRoleId")
public Dataobj initPermissionByRoleId(Integer id){
//1.查询所有可用的权限
QueryWrapper<permisson> q = new QueryWrapper<>();
q.eq("available", changliang.AVAILABLE_TRUE);
List<Map<String, Object>> listMaps = permissionService.listMaps(q);
//2.查询当前角色拥有的PID集合
List<Integer> currentUserRoleIds = roleService.queryRolePermissionIdsByRid(id);
for (Map<String, Object> map : listMaps) {
Boolean LAY_CHECKED=false;
Integer perssionId = (Integer) map.get("pid");
for (Integer pid : currentUserRoleIds) {
//如果当前角色已有该权限,则让LAY_CHECKED为true。LAY_CHECKED为true时,复选框选中
if (pid.equals(perssionId)){
LAY_CHECKED=true;
break;
}
}
map.put("LAY_CHECKED",LAY_CHECKED);
}
return new Dataobj(listMaps,Long.valueOf(listMaps.size()));
}
/**
* 保存角色和菜单权限之间的关系
* @param rid
* @param pids
* @return
*/
@RequestMapping("saveRolePermission")
public resultreturn saveRolePermission(Integer rid, Integer[] pids){
try {
if (pids==null){
roleService.deleteRolePermissionByRid(rid);
}
else {
int n=0;
List<Integer> list = new ArrayList<Integer>();
for (int i=0; i<pids.length; i++) {
if(!list.contains(pids[i])) {
list.add(pids[i]);
}
}
Integer[] ids = new Integer[list.size()];
for (Integer li:list) {
ids[n++]=li;
@RestController
@RequestMapping("/goods")
public class GoodsController {
@Autowired
private GoodsService goodsService;
@Autowired
private GoodsService1 AllgoodsService;
/**
* 查询物资
* @param
* @return
*/
@RequestMapping("loadAllGoods")
public Dataobj loadAllGoods(GoodsVo goodsVo){
IPage<goods> page = new Page<>(goodsVo.getPage(),goodsVo.getLimit());
QueryWrapper<goods> q = new QueryWrapper<>();
q.like(StringUtils.isNotBlank(goodsVo.getGname()),"gname",goodsVo.getGname());
q.like(StringUtils.isNotBlank(goodsVo.getRetunname()),"retunname",goodsVo.getRetunname());
q.like(StringUtils.isNotBlank(goodsVo.getOperatorname()),"operatorname",goodsVo.getOperatorname());
q.like(StringUtils.isNotBlank(goodsVo.getBorrowname()),"borrowname",goodsVo.getBorrowname());
q.orderByAsc("id");
goodsService.page(page,q);
List list =goodsService.list(q);
long num=list.size();
// message += "\n" + " " + name + ": " + simpleDateFormat.format(new Date()) + "port:" + socket.getRemoteSocketAddress() + "\n" + " " + new String(buf, 0, len);
message = "\n" + " " + name + ": " + simpleDateFormat.format(new Date()) + "<br>" + " " + new String(buf, 0, len);
}
new zhuanfa().start();
}
}
}catch (IOException e){
e.printStackTrace();
}
}
class zhuanfa extends Thread{
@Override
public void run() {
OutputStream os= null;
for (int i = 0; i <sockets.size(); i++) {
try {
os= sockets.get(i).getOutputStream();
BufferedOutputStream bufferedOutputStream=new BufferedOutputStream(os);
bufferedOutputStream.write(message.getBytes());
bufferedOutputStream.flush();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
public static void main(String[] args) throws IOException {
}
}
package com.ywj.business.controller;
/**
* 跳转到活动管理页面
* @return
*/
@RequestMapping("toActivityManager")
public String toActivityManager(){
return "business/activity/activityManager";
}
/**
* 跳转到文件管理页面
* @return
*/
@RequestMapping("tofileManager")
public String tofileManager(){
return "business/files/fileManager";
}
/**
* 跳转到财务管理页面
* @return
*/
@RequestMapping("toMoneysManager")
public String toMoneysManager(){
return "business/moneys/moneysManager";
}
/**
* 跳转到赞助商管理页面
* @return
*/
@RequestMapping("toSponsorManager")
public String toSponsorManager(){
return "business/sponsor/sponsorManager";
}
/**
* 跳转到用户管理页面
* @return
*/
@RequestMapping("toUserManager")
public String toUserManager(){
return "system/user/userManager";
}
/**
if (deptid!=null){
//先从缓存中去取,如果缓存中没有就去数据库中取
dpartment one = deptService.getById(deptid);
//设置user的部门名称
user.setDepartname(one.getDepartname());
//设置user的领导名称
user.setMinistername(one.getMinistername());
}
}
long num=list.size();
if(list.isEmpty()){
return new Dataobj(null,num);
}else {
//返回DataGridView
return new Dataobj(list, page.getTotal());
}
}
/**
* 添加用户
* @param userv
* @return
*/
@RequestMapping("addUser")
public resultreturn addUser(userv userv){
try {
//设置类型
userv.setStype(changliang.USER_TYPE_NORMAL);
userService.save(userv);
return resultreturn.ADD_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return resultreturn.ADD_ERROR;
}
}
if(lea.isEmpty()){//如果为空表示当前任务为初次办理
//循环遍历查询出来的请假状态为审核中的请假单
for (com.ywj.system.model.leaver item:leaver) {
//设置流程变量以便传入流程中
variables.put("请假人", item.getLeaver());
variables.put("请假id", item.getId());
variables.put("请假类型", item.getStyle());
variables.put("请假原因", item.getLeavereson());
variables.put("备注", item.getRemark());
variables.put("请假时间", new Date());
variables.put("请假流程", 0);
records.setLeaverid(item.getId());
}
}else {//否则表示当前任务为二次办理
//遍历请假状态为被驳回的请假单
for (com.ywj.system.model.leaver leaver1:lea) {
//设置流程变量以便传入流程中
variables.put("请假人", leaver1.getLeaver());
variables.put("请假id", leaver1.getId());
variables.put("请假类型", leaver1.getStyle());
variables.put("请假原因", leaver1.getLeavereson());
variables.put("备注", leaver1.getRemark());
records.setLeaverid(leaver1.getId());
}
}
//设置流程变量
variables.put("请假时间", new Date());
variables.put("干事批注", task.getGanpi());
//审核记录
records.setId(task.getId());
records.setName(task.getName());
records.setPizhu(task.getGanpi());
records.setRecordtime(new Date());
records.setStatu(1);
variables.put("dapartment", user.getLogintype().toString());
//添加审核记录
recordsService.save(records);
//执行完成任务
this.processEngine.getTaskService().complete(task.getId().toString(), variables);
} else if(user.getRemark().equals("部长")) {
if(task.getLeaver().equals(user.getName())){//如果成立表示部长请假
QueryWrapper<leaver> queryWrapper = new QueryWrapper<>();
//查询请假状态为初始化的请假单
queryWrapper.eq("leaver", task.getLeaver()).eq("status", 2);
List<leaver> leaver= leaverService.list(queryWrapper);
QueryWrapper<leaver> qu = new QueryWrapper<>();
//查询请假状态为被驳回的请假单
qu.eq("leaver", task.getLeaver()).eq("status", 3);
List<leaver> lea= leaverService.list(qu);
if(lea.isEmpty()){//如果为空表示初次办理任务
@RestController
@RequestMapping("/role")
public class JiaoseController {
@Autowired
private IjiaoseService roleService;
@Autowired
private IquanxianService permissionService;
/**
* 查询所有角色
* @param jiaosev
* @return
*/
@RequestMapping("loadAllRole")
public Dataobj loadAllRole(jiaosev jiaosev){
IPage<role> page = new Page<role>(jiaosev.getPage(), jiaosev.getLimit());
QueryWrapper<role> queryWrapper = new QueryWrapper<role>();
if(list.isEmpty()){
return new Dataobj(null,num);
}else {
//返回DataGridView
return new Dataobj(page.getRecords(), page.getTotal());
}
}
/**
* 添加物资
* @param goodsVo
* @return
*/
@RequestMapping("addGoods")
public Resultreturn addGoods(GoodsVo goodsVo){
try {
Integer gid=goodsVo.getGid();
Allgoods allgoods=AllgoodsService.getById(gid);
Integer goodssum=allgoods.getGoodsnum();
Integer brrownum=allgoods.getBorrownum();
Integer num=goodsVo.getGoodsnum();
if (allgoods.getGoodsnum() > 0 && num < allgoods.getGoodsnum()) {
if (brrownum>=0) {
brrownum += num;
allgoods.setBorrownum(brrownum);
allgoods.setGoodsnum(goodssum - num);
AllgoodsService.updateById(allgoods);goodsService.save(goodsVo);
}else {
goodsService.save(goodsVo);
}
return Resultreturn.ADD_SUCCESS;
}else { return Resultreturn.ADD_ERRORs; }
} catch (Exception e) {
e.printStackTrace();
return Resultreturn.ADD_ERROR;
}
}
/*修改物资*/
@RequestMapping("updateGoods")
public Resultreturn updateGoods(GoodsVo goodsVo){
try {
Integer gid=goodsVo.getGid();
Allgoods allgoods=AllgoodsService.getById(gid);
}
}
@RequestMapping("loadAllgoodsForSelect")
public Dataobj loadAllProviderForSelect(){
QueryWrapper<dpartment> queryWrapper = new QueryWrapper();
List<dpartment> list = deptService.list(queryWrapper);
return new Dataobj(list);
}
@RequestMapping("loadAllgoodsForSelect1")
public Dataobj loadAllProviderForSelect1(Integer did){
QueryWrapper<dpartment> q = new QueryWrapper();
q.eq("did",did);
List<dpartment> list = deptService.list(q);
return new Dataobj(list);
}
/**
* 根据id查询一个用户
* @param id 领导的id
* @return
*/
@RequestMapping("loadUserById")
public Dataobj loadUserById(Integer id){
return new Dataobj(userService.getById(id));
}
/**
* 修改用户
* @param userv
* @return
*/
@RequestMapping("updateUser")
public resultreturn updateUser(userv userv){
try {
userService.updateById(userv);
return resultreturn.UPDATE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return resultreturn.UPDATE_ERROR;
}
}
.createDeployment()//创建流程
.name("学生会请假流程.....")//流程名称
.addClasspathResource("diagrams/LeaveProgress.bpmn")//流程图文件
.addClasspathResource("diagrams/LeaveProgress.png")//流程图
.deploy();
//获取RuntimeService对象
RuntimeService runtimeService = this.processEngine.getRuntimeService();
//根据流程key值,获取流程
String processKey ="leave";
QueryWrapper<User> queryWrapper=new QueryWrapper<>();
queryWrapper.eq("logintype","生活文体部").eq("remark","部长");
User user=userService.getOne(queryWrapper);//查询生活文体部部长
QueryWrapper<User> q=new QueryWrapper<>();
q.eq("logintype","行政秘书部").eq("remark","部长");
User user1=userService.getOne(q);//查询行政秘书部部长
QueryWrapper<User> q1=new QueryWrapper<>();
q1.eq("logintype","实践部").eq("remark","部长");
User user2=userService.getOne(q1);
QueryWrapper<User> q2=new QueryWrapper<>();
q2.eq("logintype","组织部").eq("remark","部长");
User user3=userService.getOne(q2);
QueryWrapper<User> q3=new QueryWrapper<>();
q3.eq("logintype","策划部").eq("remark","部长");
User user4=userService.getOne(q3);
QueryWrapper<User> q4=new QueryWrapper<>();
q4.eq("logintype","宣传部").eq("remark","部长");
User user5=userService.getOne(q4);
QueryWrapper<User> q5=new QueryWrapper<>();
q5.eq("logintype","外联部").eq("remark","部长");
User user6=userService.getOne(q5);
QueryWrapper<User> q6=new QueryWrapper<>();
q6.eq("logintype","学习部").eq("remark","部长");
User user7=userService.getOne(q6);
userService.saveUserRole(uid,ids);
return resultreturn.DISPATCH_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return resultreturn.DISPATCH_ERROR;
}
}
}
package com.ywj.system.controller;
@RestController
@RequestMapping("/leave")
public class LeaveController {
//获取默认的流程引擎
private ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();
//实例流程id,用来记录流程,以便获取当前任务
/**
* 跳转到审核记录
*
* @return
*/
@RequestMapping("toRecordsManager")
public String toRecordsManager() {
return "system/myverify/RecordsManager";
}
/**
* 跳转到请假单管理
*
* @return
*/
@RequestMapping("toLeavesManagers")
public String toLeavesManagers() {
return "system/myverify/LeaveManagers";
}
/**
* 跳转到日志管理
*
* @return
*/
@RequestMapping("toLoginManagers")
public String toLoginManagers() {
return "system/login/LoginsManager";
}
@RequestMapping("toSocketManagers")
public String toSocketManagers() {
return "system/socket/SocketManager";
}
}
package com.ywj.system.controller;
* @return
*/
@RequestMapping("updateRole")
public resultreturn updateRole(jiaosev jiaosev){
try {
roleService.updateById(jiaosev);
return resultreturn.UPDATE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return resultreturn.UPDATE_ERROR;
}
}
/**
* 删除角色
* @param id
* @return
*/
@RequestMapping("deleteRole")
public resultreturn deleteRole(Integer id){
try {
this.roleService.removeById(id);
return resultreturn.DELETE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return resultreturn.DELETE_ERROR;
}
}
/**
* 根据用户id查询角色并选中已拥有的角色
* @param id 用户id
* @return
*/
@RequestMapping("initPermissionByRoleId")
public Dataobj initPermissionByRoleId(Integer id){
//1.查询所有可用的权限
QueryWrapper<permisson> q = new QueryWrapper<>();
q.eq("available", changliang.AVAILABLE_TRUE);
List<Map<String, Object>> listMaps = permissionService.listMaps(q);
}
}
}
package com.ywj.business.controller;
@RestController
@RequestMapping("/files")
public class FilesControler {
@Autowired
private FilesService filesService;
/**
* 查询文件
* @param
* @return
*/
@RequestMapping("loadAllfiles")
public Dataobj loadAllfiles(FileVo fileVo){
IPage<file> page = new Page<>(fileVo.getPage(),fileVo.getLimit());
QueryWrapper<file> q = new QueryWrapper<>();
q.like(StringUtils.isNotBlank(fileVo.getFilename()),"filename",fileVo.getFilename());
q.like(StringUtils.isNotBlank(fileVo.getDept()),"dept",fileVo.getDept());
q.like(StringUtils.isNotBlank(fileVo.getPersoncharge()),"personcharge",fileVo.getPersoncharge());
return new Dataobj(null,num);
}else {
//返回DataGridView
return new Dataobj(page.getRecords(), page.getTotal());
}
}
@RequestMapping("loadAllfilesForSelect")
public Dataobj loadAllProviderForSelect(){
QueryWrapper<file> q = new QueryWrapper();
List<file> list = filesService.list(q);
return new Dataobj(list);
}
/**
* 添加文件
* @param
* @return
*/
@RequestMapping("addfiles")
public Resultreturn addfile(FileVo fileVo){
try {
filesService.save(fileVo);
return Resultreturn.ADD_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return Resultreturn.ADD_ERROR;
}
}
/**
* 修改文件
* @param fileVo
* @return
*/
@RequestMapping("updatefiles")
public Resultreturn updatefiles(FileVo fileVo){
try {
filesService.updateById(fileVo);
return Resultreturn.UPDATE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return Resultreturn.UPDATE_ERROR;
}
}
/**
* 跳转到首页
*
* @return
*/
@RequestMapping("index")
public String index() {
return "system/index/index";
}
/**
* 跳转到登陆台
*
* @return
*/
@RequestMapping("toDeskManager")
public String toDeskManager() {
return "system/index/deskManager";
}
/**
* 跳转到部门管理
*
* @return
*/
@RequestMapping("toDeptManager")
public String toDeptManager() {
return "system/dept/deptManager";
}
/**
* 跳转到权限管理
*
* @return
*/
@RequestMapping("toPermissionManager")
public String toPermissionManager() {
try {
roleService.updateById(jiaosev);
return resultreturn.UPDATE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return resultreturn.UPDATE_ERROR;
}
}
/**
* 删除角色
* @param id
* @return
*/
@RequestMapping("deleteRole")
public resultreturn deleteRole(Integer id){
try {
this.roleService.removeById(id);
return resultreturn.DELETE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return resultreturn.DELETE_ERROR;
}
}
/**
* 根据用户id查询角色并选中已拥有的角色
* @param id 用户id
* @return
*/
@RequestMapping("initPermissionByRoleId")
public Dataobj initPermissionByRoleId(Integer id){
//1.查询所有可用的权限
QueryWrapper<permisson> q = new QueryWrapper<>();
q.eq("available", changliang.AVAILABLE_TRUE);
List<Map<String, Object>> listMaps = permissionService.listMaps(q);
//2.查询当前角色拥有的PID集合
List<Integer> currentUserRoleIds = roleService.queryRolePermissionIdsByRid(id);
for (Map<String, Object> map : listMaps) {
Boolean LAY_CHECKED=false;
Integer perssionId = (Integer) map.get("pid");
for (Integer pid : currentUserRoleIds) {
//如果当前角色已有该权限,则让LAY_CHECKED为true。LAY_CHECKED为true时,复选框选中
idList.add(id);
}
AllgoodsService.removeByIds(idList);
return Resultreturn.DELETE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return Resultreturn.DELETE_ERROR;
}
}
}
package com.ywj.system.controller;
@RestController
@RequestMapping("/role")
public class JiaoseController {
@Autowired
private IjiaoseService roleService;
}
public void setProcessInstanceId(String processInstanceId) {
this.processInstanceId = processInstanceId;
}
@RequestMapping(value = "/LoadAllProgress",method = RequestMethod.GET)
public ModelAndView loadAllRecord() {
QueryWrapper<records> q=new QueryWrapper<>();
List<records> list=recordsService.list(q);
return new ModelAndView("system/leave/LeaveManager","records",list);
}
@RequestMapping("loadAllrecords")
public Dataobj loadAllrecords(recordsV records) {
IPage<records> page = new Page<>(records.getPage(), records.getLimit());
QueryWrapper<records> q = new QueryWrapper<>();
q.like(records.getId()!=null,"id",records.getId());
q.like(records.getLeaverid()!=null,"leaverid",records.getLeaverid());
q.like(StringUtils.isNotBlank(records.getName()),"name",records.getName());
recordsService.page(page, q);
List list =recordsService.list(q);
long num=list.size();
if(list.isEmpty()){
return new Dataobj(null,num);
}else {
//返回DataGridView
return new Dataobj(page.getRecords(), page.getTotal());
}
}
/**
* 批量删除
*/
@RequestMapping("batchDeleterecords")
public Resultreturn batchDeletefiles(recordsV recordsV){
try {
Collection<Serializable> idList = new ArrayList<Serializable>();
public static void main(String[] args) throws IOException {
}
}
package com.ywj.business.controller;
@RestController
@RequestMapping("/plans")
public class PlansController {
@Autowired
private PlansService plansService;
/**
* 查询计划
* @param
* @return
*/
@RequestMapping("loadAllplans")
public Dataobj loadAllGoods1(PlansVo plansVo){
IPage<plans> page = new Page<>(plansVo.getPage(),plansVo.getLimit());
QueryWrapper<plans> q = new QueryWrapper<>();
q.like(StringUtils.isNotBlank(plansVo.getPlanname()),"planname",plansVo.getPlanname());
@Override
public void run() {
OutputStream os= null;
for (int i = 0; i <sockets.size(); i++) {
try {
os= sockets.get(i).getOutputStream();
BufferedOutputStream bufferedOutputStream=new BufferedOutputStream(os);
bufferedOutputStream.write(message.getBytes());
bufferedOutputStream.flush();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
public static void main(String[] args) throws IOException {
}
}
package com.ywj.business.controller;
@RestController
@RequestMapping("/plans")
public class PlansController {
@Autowired
private PlansService plansService;
/**
* 查询计划
* @param
@RestController
@RequestMapping("/leave")
public class LeaveController {
//获取默认的流程引擎
private ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();
//实例流程id,用来记录流程,以便获取当前任务
private String processInstanceId;
private String progressid;
@RestController
@RequestMapping("/goods")
public class GoodsController {
@Autowired
private GoodsService goodsService;
@Autowired
private GoodsService1 AllgoodsService;
/**
* 查询物资
* @param
* @return
*/
@RequestMapping("loadAllGoods")
public Dataobj loadAllGoods(GoodsVo goodsVo){
IPage<goods> page = new Page<>(goodsVo.getPage(),goodsVo.getLimit());
QueryWrapper<goods> q = new QueryWrapper<>();
q.like(StringUtils.isNotBlank(goodsVo.getGname()),"gname",goodsVo.getGname());
q.like(StringUtils.isNotBlank(goodsVo.getRetunname()),"retunname",goodsVo.getRetunname());
q.like(StringUtils.isNotBlank(goodsVo.getOperatorname()),"operatorname",goodsVo.getOperatorname());
q.like(StringUtils.isNotBlank(goodsVo.getBorrowname()),"borrowname",goodsVo.getBorrowname());
q.orderByAsc("id");
goodsService.page(page,q);
List list =goodsService.list(q);
@RestController
@RequestMapping("notice")
public class GongaoController {
@Autowired
private IgongaoService noticeService;
/**
* 公告的查询
* @param noticeVo
* @return
*/
@RequestMapping("loadAllNotice")
public Dataobj loadAllNotice(gongaov noticeVo){
IPage<Notice> page = new Page<Notice>(noticeVo.getPage(),noticeVo.getLimit());
QueryWrapper<Notice> q = new QueryWrapper<Notice>();
//进行模糊查询
q.like(StringUtils.isNotBlank(noticeVo.getTitle()),"title",noticeVo.getTitle());
q.like(StringUtils.isNotBlank(noticeVo.getOpername()),"opername",noticeVo.getOpername());
//公告创建时间应该大于搜索开始时间小于搜索结束时间
q.ge(noticeVo.getStartTime()!=null,"createtime",noticeVo.getStartTime());
q.le(noticeVo.getEndTime()!=null,"createtime",noticeVo.getEndTime());
//根据公告创建时间进行排序
q.orderByAsc("createtime");
noticeService.page(page,q);
List list =noticeService.list(q);
long num=list.size();
if(list.isEmpty()){
return new Dataobj(null,num);
}else {
//返回DataGridView
return new Dataobj(page.getRecords(), page.getTotal());
}
}
public Resultreturn addGoods1(huodonv huodonv){
try {
activitysService.save(huodonv);
return Resultreturn.ADD_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return Resultreturn.ADD_ERROR;
}
}
/**
* 修改活动
* @param huodonv
* @return
*/
@RequestMapping("updateactivitys")
public Resultreturn updateGoods1(huodonv huodonv){
try {
activitysService.updateById(huodonv);
return Resultreturn.UPDATE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return Resultreturn.UPDATE_ERROR;
}
}
//删除活动
@RequestMapping("deleteactivitys")
public Resultreturn deleteGoods1(Integer id){
try {
activitysService.removeById(id);
return Resultreturn.DELETE_SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return Resultreturn.DELETE_ERROR;
}
}
/**
* 批量删除
* @param huodonv 选中
}
/**
* 跳转到审核记录
*
* @return
*/
@RequestMapping("toRecordsManager")
public String toRecordsManager() {
return "system/myverify/RecordsManager";
}
/**
* 跳转到请假单管理
*
* @return
*/
@RequestMapping("toLeavesManagers")
public String toLeavesManagers() {
return "system/myverify/LeaveManagers";
}
/**
* 跳转到日志管理
*
* @return
*/
@RequestMapping("toLoginManagers")
public String toLoginManagers() {
return "system/login/LoginsManager";
}
@RequestMapping("toSocketManagers")
public String toSocketManagers() {
return "system/socket/SocketManager";
}
}
package com.ywj.system.controller;