基于springboot、orgtree的家谱树管理系统，将纸质版的家谱进行电子化、信息化，建立家族的家谱血脉联系。.zip

package com.wdata.system.controller; import com.wdata.base.controller.BaseController; import com.wdata.base.util.*; import com.wdata.system.service.*; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFDataFormat; import org.apache.poi.hssf.usermodel.HSSFDateUtil; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.math.BigDecimal; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; /** * @Title: UserController * @ProjectName wdata * @Description: 用户基础信息 * @author 青锋 * @date 2018-8-24 11:51 */ @Controller @RequestMapping(value = "/system/user") public class UserController extends BaseController { @Autowired private UserService userService; @Autowired private MenuService menuService; @Autowired private RoleService roleService; @Autowired private OrganizeService organizeService; /** * @Description: index * @Param: [map, request, response] * @return: java.lang.String * @Author: 青锋 * @Date: 2018-9-2 0:36 */ @RequestMapping(value = "/index", method = RequestMethod.GET) public String index(ModelMap map,HttpServletRequest request, HttpServletResponse response) throws IOException { PageData pd = new PageData(request); // if(Verify.verifyIsNotNull(pd.get("index"))){ // page.setIndex(Integer.parseInt(pd.get("index").toString())); // }else{ // page.setIndex(1); // } // List<PageData> list = userService.findListPage(page); // int num = userService.findListSize(page); // map.put("list",list); // map.put("num",num); map.put("pd",pd); return "web/system/user/user_list"; } /** * @Description: findByPage * @Param: [request, response] * @return: void * @Author: 青锋 * @Date: 2018-8-24 11:51 */ @RequestMapping(value = "/findListPage", method = RequestMethod.GET) public void findListPage(Page page, HttpServletRequest request, HttpServletResponse response, HttpSession session) throws IOException { PageData pd = new PageData(request); //{limit=10, page=1} //处理数据权限 page = dealDataAuth(page,pd,session); //处理分页 if(Verify.verifyIsNotNull(pd.get("page"))){ page.setIndex(Integer.parseInt(pd.get("page").toString())); }else{ page.setIndex(1); } if(Verify.verifyIsNotNull(pd.get("limit"))){ page.setShowCount(Integer.parseInt(pd.get("limit").toString())); }else{ page.setShowCount(10); } page.setPd(pd); List<PageData> list = userService.findListPage(page); int num = userService.findListSize(page); Json json = new Json(); json.setMsg("获取数据成功。"); json.setCode(0); json.setCount(num); json.setData(list); json.setSuccess(true); this.writeJson(response,json); } /** * @Description: findList * @Param: [map] * @return: java.lang.String * @Author: 青锋 * @Date: 2018-8-24 11:52 */ @RequestMapping(value = "/findList", method = RequestMethod.GET) public void findList(HttpServletRequest request,HttpServletResponse response) throws IOException { PageData pd = new PageData(request); List<PageData> list = userService.findList(pd); Json json = new Json(); json.setMsg("获取数据成功。"); json.setData(list); json.setSuccess(true); this.writeJson(response,json); } /** * @Description: findInfo * @Param: [map] * @return: java.lang.String * @Author: 青锋 * @Date: 2018-8-24 11:53 */ @RequestMapping(value = "/findInfo", method = RequestMethod.GET) public String findInfo(ModelMap map,HttpServletRequest request) { PageData pd = new PageData(request); PageData p = userService.findInfo(pd); map.addAttribute("p",p); return "web/system/user/user_info"; } /** * @Description: toAdd * @Param: [map, request] * @return: java.lang.String * @Author: 青锋 * @Date: 2018-8-24 12:58 */ @RequestMapping(value = "/toAdd", method = RequestMethod.GET) public String toAdd(ModelMap map,HttpServletRequest request) { PageData pd = new PageData(request); map.put("pd",pd); return "web/system/user/user_add"; } /** * @Description: toAddMore * @Param: [map, request] * @return: java.lang.String * @Author: 青锋 * @Date: 2018-8-28 10:03 */ @RequestMapping(value = "/toAddMore", method = RequestMethod.GET) public String toAddMore(ModelMap map,HttpServletRequest request) { PageData pd = new PageData(request); map.put("pd",pd); String return_url = "web/system/user/user_addMore"; return return_url; } /** * @Description: save * @Param: [request, response] * @return: void * @Author: 青锋 * @Date: 2018-8-24 13:02 */ @RequestMapping(value = "/save", method = RequestMethod.POST) public void save(HttpServletRequest request,HttpServletResponse response,HttpSession session) throws IOException { PageData pd = new PageData(request); Json json = new Json(); List<String> ls = new ArrayList<String>(); ls.add(pd.get("login_name").toString()); pd.put("query_login_name",ls); List<PageData> list = userService.findVerifyUser(pd); if(list.size()>0){ json.setSuccess(false); json.setMsg("用户【"+pd.get("login_name").toString()+"】已经存在！"); }else{ String time = DateTimeUtil.getDateTimeStr(); pd.put("status","Y"); pd.put("create_time", time); pd.put("update_time", time); pd.put("login_password",MD5.md5(pd.get("login_password").toString())); //处理数据权限 PageData user = (PageData) session.getAttribute("loginUser"); pd.put("create_user",user.get("id")); pd.put("create_organize",user.get("organize_id")); pd.put("create_org_cascade",user.get("org_cascade")); int num = userService.save(pd); if(num==1){//处理组织信息 pd.put("user_id",pd.get("id")); pd.put("type","0"); userService.saveUserOrganize(pd); } json.setSuccess(true); json.setMsg("操作成功。"); } this.writeJson(response,json); } /** * @Description: saveMore * @Param: [request, response] * @return: void * @Author: 青锋 * @Date: 2018-8-28 10:06 */ @RequestMapping(value = "/saveMore", method = RequestMethod.POST) public void saveMore(HttpServletRequest request,HttpServletResponse response,HttpSession session) throws IOException { PageData pd = new PageData(request); String[] login_name = request.getParameterValues("login_name"); String[] login_password = request.getParameterValues("login_password"); String[] nickname = request.getParameterValues("nick