package com.example.controller;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.collection.CollectionUtil;
import cn.hutool.core.io.IoUtil;
import cn.hutool.core.util.ObjectUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.crypto.SecureUtil;
import cn.hutool.json.JSONObject;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import com.example.common.Result;
import com.example.common.ResultCode;
import com.example.entity.QiyexinxiInfo;
import com.example.dao.QiyexinxiInfoDao;
import com.example.service.QiyexinxiInfoService;
import com.example.exception.CustomException;
import com.example.common.ResultCode;
import com.example.vo.EchartsData;
import com.example.vo.QiyexinxiInfoVo;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.example.service.*;
import org.springframework.web.bind.annotation.*;
import org.springframework.beans.factory.annotation.Value;
import cn.hutool.core.util.StrUtil;
import org.springframework.web.multipart.MultipartFile;
import javax.annotation.Resource;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.*;
import java.util.stream.Collectors;
@RestController
@RequestMapping(value = "/qiyexinxiInfo")
public class QiyexinxiInfoController {
@Resource
private QiyexinxiInfoService qiyexinxiInfoService;
@Resource
private QiyexinxiInfoDao qiyexinxiInfoDao;
@PostMapping
public Result<QiyexinxiInfo> add(@RequestBody QiyexinxiInfoVo qiyexinxiInfo) {
//mixmajixami
qiyexinxiInfoService.add(qiyexinxiInfo);
return Result.success(qiyexinxiInfo);
}
//youtixing1
//youtixing2
@GetMapping("/getByDiqu")
public Result<List<Map<String,String>>> qidu() {
return Result.success(qiyexinxiInfoService.findByDiqu());
}
@DeleteMapping("/{id}")
public Result delete(@PathVariable Long id) {
qiyexinxiInfoService.delete(id);
return Result.success();
}
@PutMapping
public Result update(@RequestBody QiyexinxiInfoVo qiyexinxiInfo) {
qiyexinxiInfoService.update(qiyexinxiInfo);
return Result.success();
}
//@PutMapping("/update2")
// public Result update2(@RequestBody QiyexinxiInfoVo qiyexinxiInfo) {
// qiyexinxiInfoService.update2(qiyexinxiInfo);
// return Result.success();
// }
@GetMapping("/{id}")
public Result<QiyexinxiInfo> detail(@PathVariable Long id) {
QiyexinxiInfo qiyexinxiInfo = qiyexinxiInfoService.findById(id);
return Result.success(qiyexinxiInfo);
}
@GetMapping("/changeStatus/{id}")
public Result<QiyexinxiInfo> changeStatus(@PathVariable Long id) {
qiyexinxiInfoService.changeStatus(id);
return Result.success();
}
@GetMapping
public Result<List<QiyexinxiInfoVo>> all() {
return Result.success(qiyexinxiInfoService.findAll());
}
@GetMapping("/page/{name}")
public Result<PageInfo<QiyexinxiInfoVo>> page(@PathVariable String name,
@RequestParam(defaultValue = "1") Integer pageNum,
@RequestParam(defaultValue = "5") Integer pageSize,
HttpServletRequest request) {
return Result.success(qiyexinxiInfoService.findPage(name, pageNum, pageSize, request));
}
@GetMapping("/pageqt/{name}")
public Result<PageInfo<QiyexinxiInfoVo>> pageqt(@PathVariable String name,
@RequestParam(defaultValue = "1") Integer pageNum,
@RequestParam(defaultValue = "8") Integer pageSize,
HttpServletRequest request) {
return Result.success(qiyexinxiInfoService.findPageqt(name, pageNum, pageSize, request));
}
// @PostMapping("/register")
// public Result<QiyexinxiInfo> register(@RequestBody QiyexinxiInfo qiyexinxiInfo) {
// if (StrUtil.isBlank(qiyexinxiInfo.getName()) || StrUtil.isBlank(qiyexinxiInfo.getPassword())) {
// throw new CustomException(ResultCode.PARAM_ERROR);
// }
// return Result.success(qiyexinxiInfoService.add(qiyexinxiInfo));
// }
/**
* 批量通过excel添加信息
* @param file excel文件
* @throws IOException
*/
@PostMapping("/upload")
public Result upload(MultipartFile file) throws IOException {
List<QiyexinxiInfo> infoList = ExcelUtil.getReader(file.getInputStream()).readAll(QiyexinxiInfo.class);
if (!CollectionUtil.isEmpty(infoList)) {
// 处理一下空数据
List<QiyexinxiInfo> resultList = infoList.stream().filter(x -> ObjectUtil.isNotEmpty(x.getQiyemingcheng())).collect(Collectors.toList());
for (QiyexinxiInfo info : resultList) {
qiyexinxiInfoService.add(info);
}
}
return Result.success();
}
@GetMapping("/get/qiyexinxi_tj_qiyeleixing")
Result<List<EchartsData>> qiyexinxi_tj_qiyeleixing() {
List<EchartsData> list = new ArrayList<>();
List<Map<String, Object>> qiyexinxi_tj_qiyeleixingList = qiyexinxiInfoDao.qiyexinxi_tj_qiyeleixing();
Map<String, Double> typeMap = new HashMap<>();
for (Map<String, Object> map : qiyexinxi_tj_qiyeleixingList) {
typeMap.put((String)map.get("aa"), (Double.valueOf((String)map.get("bb").toString())));
}
getPieData("企业信息按企业类型统计", list, typeMap);
getBarData("企业信息按企业类型统计", list, typeMap);
return Result.success(list);
}
@GetMapping("/get/qiyexinxi_tj_suoshuxingye")
Result<List<EchartsData>> qiyexinxi_tj_suoshuxingye() {
List<EchartsData> list = new ArrayList<>();
List<Map<String, Object>> qiyexinxi_tj_suoshuxingyeList = qiyexinxiInfoDao.qiyexinxi_tj_suoshuxingye();
Map<String, Double> typeMap = new HashMap<>();
for (Map<String, Object> map : qiyexinxi_tj_suoshuxingyeList) {
typeMap.put((String)map.get("aa"), (Double.valueOf((String)map.get("bb").toString())));
}
getPieData("企业信息按所属行业统计", list, typeMap);
getBarData("企业信息按所属行业统计", list, typeMap);
return Result.success(list);
}
@GetMapping("/getExcelModel")
public void getExcelModel(HttpServletResponse response) throws IOException {
// 1. 生成excel
Map<String, Object> row = new LinkedHashMap<>();
row.put("qiyebianhao", "A企业编号");
row.put("qiyemingcheng", "A企业名称");
row.put("qiyeleixing", "A企业类型");
row.put("suoshuxingye", "A所属行业");
row.put("fuzeren", "A负责人");
row.put("lianxidianhua", "A联系电话");
row.put("zhucezijin", "A注册资金");
row.put("dizhi", "A地址");
row.put("zhaopian", "A照片");
row.put("qiyejianjie", "A企业简介");
row.put("status", "是");
row.put("level", "qiyexinxi");
List<Map<String, Object>> list = CollUtil.newArrayList(row);
// 2. 写excel
ExcelWriter writer = ExcelUtil.getWriter(true);
writer.write(list, true);
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
response.setHeader("Content-Disposition","attachment;filename=qiyexinxiInfoModel.xlsx");
ServletOutputStream out = response.getOutputStream();
writer.flush(out, true);
writer.close();
IoUtil.close(System.out);
}
@GetMapping("/getExcel")
public void getExcel(HttpServletResponse response) throws IOException {
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经
资源推荐
资源详情
资源评论
收起资源包目录
微信小程序名片管理系统源码数据库.zip (736个子文件)
QiyexinxiInfoController.class 14KB
ZhuceyonghuInfoController.class 13KB
KehumingpianInfoController.class 13KB
LianxirenmingpianInfoController.class 13KB
XinwentongzhiInfoController.class 13KB
LiuyanbanInfoController.class 12KB
AccountController.class 11KB
AdminInfoController.class 9KB
NxSystemFileController.class 8KB
YonghuService.class 7KB
ZhuceyonghuInfoService.class 6KB
YonghuController.class 5KB
EchartsController.class 5KB
KehumingpianInfoService.class 5KB
XinwentongzhiInfoService.class 5KB
QiyexinxiInfoService.class 5KB
AdminInfoService.class 5KB
AdminInfo.class 4KB
LianxirenmingpianInfoService.class 4KB
CommentInfoService.class 4KB
QiyexinxiInfo.class 4KB
XinwentongzhiInfo.class 4KB
LianxirenmingpianInfo.class 4KB
LiuyanbanInfoService.class 4KB
CommentInfoController.class 4KB
ZhuceyonghuInfo.class 4KB
CollectInfoController.class 4KB
RichtextInfoController.class 3KB
CollectInfoService.class 3KB
KehumingpianInfo.class 3KB
RichtextInfoService.class 3KB
NxSystemFileInfoService.class 3KB
LiuyanbanInfo.class 3KB
CollectInfo.class 3KB
CommentInfo.class 3KB
Account.class 3KB
Yonghu.class 3KB
Result.class 2KB
EchartsData.class 2KB
KehumingpianInfoDao.class 2KB
ResultCode.class 2KB
MyInterceptor.class 2KB
ZhuceyonghuInfoDao.class 2KB
QiyexinxiInfoDao.class 2KB
GlobalExceptionHandler.class 2KB
XinwentongzhiInfoDao.class 2KB
LianxirenmingpianInfoDao.class 2KB
EchartsData$Data.class 2KB
WebMvcConfig.class 2KB
CommentInfoDao.class 1KB
YonghuDao.class 1KB
EchartsData$Series.class 1KB
MyInterceptorConfig.class 1KB
AuthorityInfo.class 1KB
NxSystemFileInfo.class 1KB
CollectInfoDao.class 1KB
RichtextInfo.class 1KB
LiuyanbanInfoDao.class 1KB
YonghuVo.class 1KB
AuthorityInfo$Model.class 1KB
CustomException.class 1KB
AdminInfoDao.class 928B
Application.class 793B
NxSystemFileInfoDao.class 773B
RichtextInfoDao.class 641B
LianxirenmingpianInfoVo.class 348B
XinwentongzhiInfoVo.class 332B
KehumingpianInfoVo.class 328B
ZhuceyonghuInfoVo.class 324B
QiyexinxiInfoVo.class 316B
LiuyanbanInfoVo.class 316B
RichtextInfoVo.class 312B
CollectInfoVo.class 308B
AdminInfoVo.class 300B
index.css 227KB
index.css 227KB
bootstrap.css 131KB
bootstrap.css 131KB
bootstrap.min.css 119KB
bootstrap.min.css 119KB
bootstrap.min.css 115KB
bootstrap.min.css 115KB
style.css 56KB
style.css 56KB
font-awesome.css 26KB
font-awesome.css 26KB
quill.snow.css 24KB
quill.snow.css 24KB
laydate.css 6KB
laydate.css 6KB
css.css 5KB
css.css 5KB
clndr.css 5KB
clndr.css 5KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
laydate.css 3KB
共 736 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
老了敲不动了
- 粉丝: 80
- 资源: 4289
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功