package com.ibeetl.admin.console.web;
|
|
import java.io.IOException;
|
import java.io.InputStream;
|
import java.io.OutputStream;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.servlet.http.HttpServletResponse;
|
|
import com.ibeetl.admin.console.service.*;
|
import com.ibeetl.admin.console.web.query.XzxUserVehicleInfoQuery;
|
import com.ibeetl.admin.core.entity.XzxUserOtherInfo;
|
import com.ibeetl.admin.core.entity.XzxUserVehicleInfo;
|
import com.ibeetl.admin.core.entity.XzxUserVehicleRel;
|
import org.apache.commons.lang3.StringUtils;
|
import org.apache.commons.logging.Log;
|
import org.apache.commons.logging.LogFactory;
|
import org.beetl.sql.core.engine.PageQuery;
|
import org.jxls.common.Context;
|
import org.jxls.util.JxlsHelper;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.validation.annotation.Validated;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.RequestParam;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
import org.springframework.web.multipart.MultipartFile;
|
import org.springframework.web.servlet.ModelAndView;
|
import com.ibeetl.admin.core.annotation.Function;
|
import com.ibeetl.admin.core.file.FileItem;
|
import com.ibeetl.admin.core.file.FileService;
|
import com.ibeetl.admin.core.web.JsonResult;
|
import com.ibeetl.admin.core.util.*;
|
|
/**
|
* XzxUserVehicleInfo 接口
|
*/
|
@Controller
|
public class XzxUserVehicleInfoController{
|
|
private final Log log = LogFactory.getLog(this.getClass());
|
private static final String MODEL = "/admin/xzxUserVehicleInfo";
|
|
|
@Autowired private XzxUserVehicleInfoService xzxUserVehicleInfoService;
|
@Autowired private XzxUserVehicleRelService xzxUserVehicleRelService;
|
@Autowired private XzxUserOtherInfoService xzxUserOtherInfoService;
|
|
@Autowired
|
FileService fileService;
|
@Autowired
|
SettingConsoleService settingConsoleService;
|
@Autowired
|
CuserConsoleService cuserConsoleService;
|
/* 页面 */
|
|
@GetMapping(MODEL + "/index.do")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public ModelAndView index() {
|
ModelAndView view = new ModelAndView("/admin/xzxUserVehicleInfo/index.html") ;
|
view.addObject("search", XzxUserVehicleInfoQuery.class.getName());
|
return view;
|
}
|
|
@GetMapping(MODEL + "/edit.do")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public ModelAndView edit(Long id,Long relId) {
|
ModelAndView view = new ModelAndView("/admin/xzxUserVehicleInfo/edit.html");
|
XzxUserVehicleInfo xzxUserVehicleInfo = xzxUserVehicleInfoService.queryById(id);
|
XzxUserVehicleRel relInfo = xzxUserVehicleRelService.queryById(relId);
|
XzxUserOtherInfo otherInfo = xzxUserOtherInfoService.queryById(relInfo.getUserId());
|
view.addObject("xzxUserVehicleInfo", xzxUserVehicleInfo);
|
view.addObject("relId", relId);
|
view.addObject("userIdTemp", relInfo.getUserId());
|
view.addObject("userNameTemp", otherInfo.getName());
|
return view;
|
}
|
|
@GetMapping(MODEL + "/add.do")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public ModelAndView add() {
|
ModelAndView view = new ModelAndView("/admin/xzxUserVehicleInfo/add.html");
|
return view;
|
}
|
|
/* ajax json */
|
|
/*@PostMapping(MODEL + "/list.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public JsonResult<PageQuery> list(XzxUserVehicleInfoQuery condtion)
|
{
|
PageQuery page = condtion.getPageQuery();
|
xzxUserVehicleInfoService.queryByCondition(page);
|
return JsonResult.success(page);
|
}*/
|
@PostMapping(MODEL + "/list.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
Map<String, Object> list(String vehicleNo, String page, String limit)
|
{
|
return xzxUserVehicleInfoService.queryByVehicleInfoList(vehicleNo,page,limit);
|
}
|
|
@PostMapping(MODEL + "/add.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public JsonResult add(@Validated(ValidateConfig.ADD.class)XzxUserVehicleInfo xzxUserVehicleInfo,String userId,String storageId)
|
{
|
if(null!=storageId){
|
xzxUserVehicleInfo.setStorageId(Integer.parseInt(storageId));
|
}
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
xzxUserVehicleInfo.setCreateTime(sdf.format(new Date()));
|
xzxUserVehicleInfo.setDelFlag(0);
|
xzxUserVehicleInfoService.save(xzxUserVehicleInfo);
|
System.out.println("==========="+xzxUserVehicleInfo.getId());
|
if(null!=xzxUserVehicleInfo.getId()){
|
XzxUserVehicleRel rel = new XzxUserVehicleRel();
|
rel.setDelFlag(0);
|
rel.setVehicleId(xzxUserVehicleInfo.getId());
|
rel.setUserId(userId);
|
xzxUserVehicleRelService.save(rel);
|
}
|
return new JsonResult().success();
|
}
|
|
@PostMapping(MODEL + "/edit.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public JsonResult<String> update(@Validated(ValidateConfig.UPDATE.class) XzxUserVehicleInfo xzxUserVehicleInfo,String userId,String storageId,String relId) {
|
boolean success = xzxUserVehicleInfoService.update(xzxUserVehicleInfo);
|
if (success) {
|
XzxUserVehicleRel rel = xzxUserVehicleRelService.queryById(Long.parseLong(relId));
|
rel.setDelFlag(0);
|
rel.setUserId(userId);
|
xzxUserVehicleRelService.update(rel);
|
return new JsonResult().success();
|
} else {
|
return JsonResult.failMessage("保存失败");
|
}
|
}
|
|
|
|
@GetMapping(MODEL + "/view.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public JsonResult<XzxUserVehicleInfo>queryInfo(Long id) {
|
XzxUserVehicleInfo xzxUserVehicleInfo = xzxUserVehicleInfoService.queryById( id);
|
return JsonResult.success(xzxUserVehicleInfo);
|
}
|
|
@PostMapping(MODEL + "/delete.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public JsonResult delete(String ids) {
|
if (ids.endsWith(",")) {
|
ids = StringUtils.substringBeforeLast(ids, ",");
|
}
|
List<Long> idList = ConvertUtil.str2longs(ids);
|
xzxUserVehicleInfoService.batchDelXzxUserVehicleInfo(idList);
|
return new JsonResult().success();
|
}
|
|
|
@PostMapping(MODEL + "/excel/export.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public JsonResult<String> export(HttpServletResponse response,XzxUserVehicleInfoQuery condtion) {
|
/**
|
* 1)需要用你自己编写一个的excel模板
|
* 2)通常excel导出需要关联更多数据，因此xzxUserVehicleInfoService.queryByCondition方法经常不符合需求，需要重写一个为模板导出的查询
|
* 3)参考ConsoleDictController来实现模板导入导出
|
*/
|
String excelTemplate ="excelTemplates/admin/xzxUserVehicleInfo/你的excel模板文件名字.xls";
|
PageQuery<XzxUserVehicleInfo> page = condtion.getPageQuery();
|
//取出全部符合条件的
|
page.setPageSize(Integer.MAX_VALUE);
|
page.setPageNumber(1);
|
page.setTotalRow(Integer.MAX_VALUE);
|
//本次导出需要的数据
|
List<XzxUserVehicleInfo> list =xzxUserVehicleInfoService.queryByCondition(page).getList();
|
try(InputStream is = Thread.currentThread().getContextClassLoader().getResourceAsStream(excelTemplate)) {
|
if(is==null) {
|
throw new PlatformException("模板资源不存在："+excelTemplate);
|
}
|
FileItem item = fileService.createFileTemp("XzxUserVehicleInfo_"+DateUtil.now("yyyyMMddHHmmss")+".xls");
|
OutputStream os = item.openOutpuStream();
|
Context context = new Context();
|
context.putVar("list", list);
|
JxlsHelper.getInstance().processTemplate(is, os, context);
|
os.close();
|
//下载参考FileSystemContorller
|
return JsonResult.success(item.getPath());
|
} catch (IOException e) {
|
throw new PlatformException(e.getMessage());
|
}
|
|
}
|
|
@PostMapping(MODEL + "/excel/import.do")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
public JsonResult importExcel(@RequestParam("file") MultipartFile file) throws Exception {
|
if (file.isEmpty()) {
|
return JsonResult.fail();
|
}
|
InputStream ins = file.getInputStream();
|
/*解析模板并导入到数据库里,参考DictConsoleContorller，使用jxls reader读取excel数据*/
|
ins.close();
|
return JsonResult.success();
|
}
|
|
/**
|
* 查询字典里面的角色
|
* @return
|
*/
|
@PostMapping(MODEL + "/queryAllStorage.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
List<Map<String, Object>> queryAllStorage(){
|
List<Map<String, Object>> result = settingConsoleService.queryAllStorage();
|
return result;
|
}
|
|
@PostMapping(MODEL + "/queryAllOtherUserByName.json")
|
@Function("xzxUserVehicleInfo")
|
@ResponseBody
|
List<Map<String, Object>> queryAllOtherUserByName() {
|
List<Map<String, Object>> otherUser = cuserConsoleService.queryCuserListByName(null);
|
return otherUser;
|
}
|
|
}
|
