ZcglController.java

package cn.timer.api.controller.zcgl;

import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.pagehelper.PageHelper;

import cn.hutool.core.util.StrUtil;
import cn.timer.api.bean.yggl.YgglMainEmp;
import cn.timer.api.bean.zcgl.ZcglAdminZccrkgl;
import cn.timer.api.bean.zcgl.ZcglAssoZcda;
import cn.timer.api.bean.zcgl.ZcglAssoZcgh;
import cn.timer.api.bean.zcgl.ZcglAssoZcgx;
import cn.timer.api.bean.zcgl.ZcglAssoZcly;
import cn.timer.api.bean.zzgl.ZzglBmgwM;
import cn.timer.api.config.annotation.CurrentUser;
import cn.timer.api.config.annotation.UserBean;
import cn.timer.api.dao.zcgl.ZcglAdminZccrkglMapper;
import cn.timer.api.dao.zcgl.ZcglAssoZcdaMapper;
import cn.timer.api.dao.zcgl.ZcglAssoZcgxMapper;
import cn.timer.api.dto.zcgl.ZcglDetailsDto;
import cn.timer.api.dto.zcgl.ZcglLyDetailsDto;
import cn.timer.api.dto.zcgl.ZcglQueryDto;
import cn.timer.api.dto.zcgl.ZcglTjtDto;
import cn.timer.api.utils.Result;
import cn.timer.api.utils.ResultUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;

/**
 * 资产管理
 * 
 * @author dsc 2019-11-26
 */
@Api(tags = "6.0资产管理")
@RestController
@Transactional
@RequestMapping(value = "/zcgl", produces = { "application/json" })
public class ZcglController {

	@Autowired
	private ZcglAssoZcdaMapper zcdaMapper;

	@Autowired
	private ZcglAdminZccrkglMapper zccrkglMapper;

	@Autowired
	private ZcglAssoZcgxMapper zcglAssoZcgxMapper;

	// 寻找子节点
	private static ZcglAssoZcgx findChildren(ZcglAssoZcgx parent, List<ZcglAssoZcgx> listGoodsCategory) {
		for (ZcglAssoZcgx all : listGoodsCategory) {
			if (parent.getId().equals(all.getUpLbid())) {
				if (parent.getChildren() == null) {
					parent.setChildren(new ArrayList<ZcglAssoZcgx>());
				}
				parent.getChildren().add(findChildren(all, listGoodsCategory));
			}
		}
		return parent;
	}

	/**
	 * 查询资产名称列表
	 */
	@GetMapping(value = "/querylist")
	@ApiOperation(value = "查询资产名称列表", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> queryList(@CurrentUser UserBean userBean) {
		Integer orgCode = userBean.getOrgCode();
		List<ZcglAssoZcgx> treeList = new ArrayList<>();
		QueryWrapper<ZcglAssoZcgx> queryWrapper = new QueryWrapper<ZcglAssoZcgx>();
		queryWrapper.eq("org_code", orgCode).select("id", "lbmc", "up_lbid", "org_code");

		List<ZcglAssoZcgx> list = ZcglAssoZcgx.builder().build().selectList(queryWrapper);
		for (ZcglAssoZcgx parent : list) { // 遍历
			if (parent.getUpLbid().equals(0)) { // 找到parentId为零的节点，即一级目录，
				treeList.add(findChildren(parent, list));
			}
		}
		return ResultUtil.data(treeList, "查询成了");
	}

	/**
	 * 根据名称查询详情(按资产类别查询)
	 */
	@GetMapping(value = "/queryDetails")
	@ApiOperation(value = "查询资产详情列表", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> queryDetails(@RequestParam(defaultValue = "1") Integer currentPage,
			@RequestParam(defaultValue = "10") Integer totalPage, @RequestParam(required = false) String query,
			@RequestParam Integer id, @CurrentUser UserBean userBean) {

		Page<ZcglDetailsDto> p = new Page<ZcglDetailsDto>(currentPage, totalPage);

		List<ZcglAssoZcda> list = zcdaMapper.queryDetails(p, userBean.getOrgCode(), id, query);
		if (list != null) {
			return ResultUtil.datas(list, p, "终于查到了，我太难了");
		}
		return ResultUtil.error("空类别id，查不到的");
	}

	/**
	 * 增/改资产档案
	 */
	@PostMapping(value = "/updatezc")
	@ApiOperation(value = "新增/修改资产档案", httpMethod = "POST", notes = "接口发布说明")
	public Result<ZcglAssoZcda> updatezc(@CurrentUser UserBean userBean, @RequestBody ZcglAssoZcda zcda) {
		Boolean a = zcda.getId() == null;
		if (a && zcda.getLrrid() == null) {
			ZcglAssoZcda zc = ZcglAssoZcda.builder().build().selectOne(new QueryWrapper<ZcglAssoZcda>()
					.eq("org_code", userBean.getOrgCode()).orderByDesc("id").select("id"));

			if (zc != null && zc.getId() != null) {
				zcda.setZdyid("ZC-" + String.format("%05d", zc.getId() + 1));
			} else {
				zcda.setZdyid("ZC-" + String.format("%05d", 1));
			}
			zcda.setLrrid(userBean.getEmpNum());
			zcda.setLrsjTime(new Date());
			zcda.setOrgCode(userBean.getOrgCode());
			zcda.insert();
			return ResultUtil.data(zcda, "添加成功");
		} else {
			zcda.updateById();
			return ResultUtil.data(zcda, "修改成功");
		}

	}

	/**
	 * 新增入库
	 */
	@PostMapping(value = "/addrk")
	@ApiOperation(value = "新增入库管理", httpMethod = "POST", notes = "接口发布说明")
	public Result<ZcglAdminZccrkgl> addrk(@CurrentUser UserBean userBean, @RequestBody ZcglAdminZccrkgl zccrkgl) {
		Boolean a = zccrkgl.getId() == null;
		if (a && zccrkgl.getCkryid() == null) {
			zccrkgl.setCkryid(userBean.getEmpNum());
			zccrkgl.setOrgCode(userBean.getOrgCode());
			zccrkgl.setStatus(0);
			zccrkgl.setGrsjTime(new Date());
			zccrkgl.insert();

			Integer zcid = zccrkgl.getZcid();
			// 修改资产数量
			ZcglAssoZcda.builder().id(zcid)
					.xzsl(zccrkgl.getZcsl()
							+ new ZcglAssoZcda().selectOne(new QueryWrapper<ZcglAssoZcda>().eq("id", zcid)).getXzsl())
					.build().updateById();

		}
		return ResultUtil.data(zccrkgl, "新增入库成功");

	}

	/**
	 * 新增出库
	 */
	@PostMapping(value = "/addck")
	@ApiOperation(value = "新增出库管理", httpMethod = "POST", notes = "接口发布说明")
	public Result<ZcglAdminZccrkgl> addck(@CurrentUser UserBean userBean, @RequestBody ZcglAdminZccrkgl zccrkgl) {
		zccrkgl.setCkryid(userBean.getEmpNum());
		zccrkgl.setOrgCode(userBean.getOrgCode());
		zccrkgl.setStatus(1);
		zccrkgl.setCksjTime(new Date());
		zccrkgl.insert();

		Integer zcid = zccrkgl.getZcid();
		// 修改资产数量

		ZcglAssoZcda.builder().id(zcid)
				.xzsl(new ZcglAssoZcda().selectOne(new QueryWrapper<ZcglAssoZcda>().eq("id", zcid)).getXzsl()
						- zccrkgl.getZcsl())
				.build().updateById();
		return ResultUtil.data(zccrkgl, "新增出库成功");

	}

	/**
	 * 新增/修改资产分类
	 */
	@PostMapping(value = "/updatezcfl")
	@ApiOperation(value = "新增/修改资产分类", httpMethod = "POST", notes = "接口发布说明")
	public Result<ZcglAssoZcgx> updatezcfl(@CurrentUser UserBean userBean, @RequestBody ZcglAssoZcgx zcgx) {
		Boolean a = zcgx.getId() == null;
		if (a) {
			zcgx.setOrgCode(userBean.getOrgCode());
			zcgx.insert();
			return ResultUtil.success("新增成功");
		} else {
			zcgx.updateById();
			return ResultUtil.success("修改成功");
		}
	}

	/**
	 * 删除资产分类(批量)
	 */
	@DeleteMapping(value = "/delzcfl")
	@ApiOperation(value = "删除资产分类", httpMethod = "DELETE", notes = "接口发布说明")
	public Result<ZcglAssoZcgx> delzcfl(@CurrentUser UserBean userBean, @RequestBody List<Integer> ids) {
		zcglAssoZcgxMapper.deleteBatchIds(ids);
		return ResultUtil.success("删除成功");
	}

	/**
	 * 删除资产档案(按类别id批量)
	 */
	@DeleteMapping(value = "/delzcbypid")
	@ApiOperation(value = "删除资产档案(按父类名id批量)", httpMethod = "DELETE", notes = "接口发布说明")
	public Result<Integer> delzcbypid(@CurrentUser UserBean userBean, @RequestBody Integer id) {
		Integer rows = zcdaMapper.deleteDetails(userBean.getOrgCode(), id);
		return ResultUtil.success("成功删除了" + rows + "行资产档案！");
	}

	/**
	 * 删除分类名称(按类别id批量)
	 */
	@DeleteMapping(value = "/delzcbyLbmc")
	@ApiOperation(value = "删除资产分类名(按父类名id批量)", httpMethod = "DELETE", notes = "接口发布说明")
	public Result<Integer> delzcbyLbmc(@CurrentUser UserBean userBean, @RequestBody Integer id) {
		Integer rows = delzcLbmc(userBean, id);
		return ResultUtil.success("成功删除了" + rows + "行类名！");
	}

	// 根据父id批量删除类别名方法
	private Integer delzcLbmc(UserBean userBean, Integer id) {
		return zcglAssoZcgxMapper.deleteUpid(userBean.getOrgCode(), id);
	}

	/**
	 * 删除资产档案
	 */
	@DeleteMapping(value = "/delzc")
	@ApiOperation(value = "删除资产档案", httpMethod = "DELETE", notes = "接口发布说明")
	public Result<Integer> delzc(@CurrentUser UserBean userBean, @RequestBody List<Integer> ids) {
		// 加入记录 jlMapper.insertbydeldept(id, userBean.getEmpNum());
		if (ids != null) {
			zcdaMapper.deleteBatchIds(ids);
			return ResultUtil.success("删除成功");
		}
		return ResultUtil.error("没这个id");
	}

	/**
	 * 获取公司资产档案详情
	 */
	@GetMapping(value = "/getgszc")
	@ApiOperation(value = "获取全部公司资产档案", httpMethod = "GET", notes = "接口发布说明")
	public Result<List<ZcglAssoZcda>> getgszc(@CurrentUser UserBean userBean) {
		Integer orgCode = userBean.getOrgCode();
		QueryWrapper<ZcglAssoZcda> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("org_code", orgCode);
		List<ZcglAssoZcda> zcglAssoZcda = ZcglAssoZcda.builder().build().selectList(queryWrapper);
		return ResultUtil.data(zcglAssoZcda, "获取公司资产档案详情成功");
	}

	/**
	 * 获取个人资产档案、搜索、分页
	 */
	@GetMapping(value = "/getgrzc")
	@ApiOperation(value = "获取个人资产档案", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> getgrzc(@CurrentUser UserBean userBean, @RequestParam(required = false) String query,
			@RequestParam(required = false) String startTime, @RequestParam(required = false) String endTime,
			@RequestParam(required = false, defaultValue = "1") Integer currPage,
			@RequestParam(required = false, defaultValue = "10") Integer pageSize) {
		Integer orgCode = userBean.getOrgCode();
		Integer empNum = userBean.getEmpNum();

		com.github.pagehelper.Page<Object> page = PageHelper.startPage(currPage, pageSize);

		List<ZcglAssoZcda> zcglAssoZcda = zcdaMapper.personalassets(orgCode, empNum, query, startTime, endTime);

		Long total = page.getTotal();

		return ResultUtil.pageData(zcglAssoZcda, total, "个人资产记录搜索成功");

	}

	/**
	 * 入库搜索分页
	 */
	@PostMapping(value = "/getrkjl")
	@ApiOperation(value = "搜索入库记录", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> rkquery(@CurrentUser UserBean userBean, @RequestBody ZcglQueryDto zcglQueryDto) {
		String s = zcglQueryDto.getStartTime();
		String e = zcglQueryDto.getEndTime();
		String q = zcglQueryDto.getQuery();
		Page<ZcglAdminZccrkgl> page = new Page<ZcglAdminZccrkgl>(
				zcglQueryDto.getCurrentPage() == null ? 1 : zcglQueryDto.getCurrentPage(),
				zcglQueryDto.getTotalPage() == null ? 10 : zcglQueryDto.getTotalPage());

		QueryWrapper<ZcglAdminZccrkgl> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("org_code", userBean.getOrgCode()).eq("status", 0)
				.between(!StrUtil.hasBlank(s) && !StrUtil.hasBlank(e), "grsj_time",
						!StrUtil.hasBlank(s) ? s : "1000-01-01 00:00:00",
						!StrUtil.hasBlank(e) ? e : "9999-01-01 00:00:00")
				.and(!StrUtil.hasBlank(q),
						wq -> wq.like("zcmc", q).or().like("zcggxh", q).or().like("zcgys", q).or().like("zcbh", q));

		IPage<ZcglAdminZccrkgl> zPage = ZcglAdminZccrkgl.builder().build().selectPage(page, queryWrapper);
		List<ZcglAdminZccrkgl> zccrkgls = zPage.getRecords();
		zPage.getCurrent();
		zPage.getPages();
		zPage.getTotal();
		zPage.getSize();
		return ResultUtil.data(zPage, zccrkgls, "入库记录搜索成功");
	}

	/**
	 * 出库搜索分页
	 */
	@PostMapping(value = "/getckjl")
	@ApiOperation(value = "搜索出库记录", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> ckquery(@CurrentUser UserBean userBean, @RequestBody ZcglQueryDto zcglQueryDto) {
		String s = zcglQueryDto.getStartTime();
		String e = zcglQueryDto.getEndTime();
		String q = zcglQueryDto.getQuery();
		Page<ZcglAdminZccrkgl> page = new Page<ZcglAdminZccrkgl>(
				zcglQueryDto.getCurrentPage() == null ? 1 : zcglQueryDto.getCurrentPage(),
				zcglQueryDto.getTotalPage() == null ? 10 : zcglQueryDto.getTotalPage());

		QueryWrapper<ZcglAdminZccrkgl> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("org_code", userBean.getOrgCode()).eq("status", 1)
				.between(!StrUtil.hasBlank(s) && !StrUtil.hasBlank(e), "grsj_time",
						!StrUtil.hasBlank(s) ? s : "1000-01-01 00:00:00",
						!StrUtil.hasBlank(e) ? e : "9999-01-01 00:00:00")
				.and(!StrUtil.hasBlank(q),
						wq -> wq.like("zcmc", q).or().like("zcggxh", q).or().like("zcgys", q).or().like("zcbh", q));

		IPage<ZcglAdminZccrkgl> zPage = ZcglAdminZccrkgl.builder().build().selectPage(page, queryWrapper);
		List<ZcglAdminZccrkgl> zccrkgls = zPage.getRecords();
		zPage.getCurrent();
		zPage.getPages();
		zPage.getTotal();
		zPage.getSize();
		return ResultUtil.data(zPage, zccrkgls, "出库记录搜索成功");
	}

//	/**
//	 * 本月出、入库数量
//	 */
//	@GetMapping(value = "/getcrksl")
//	@ApiOperation(value = "本月出入库数量", httpMethod = "GET", notes = "接口发布说明")
//	public Result<Map<String, Integer>> getckrsl(@CurrentUser UserBean userBean) {
//
//		QueryWrapper<ZcglAdminZccrkgl> queryWrapper0 = new QueryWrapper<ZcglAdminZccrkgl>();
//		QueryWrapper<ZcglAdminZccrkgl> queryWrapper1 = new QueryWrapper<ZcglAdminZccrkgl>();
//		Date now = new Date();
//		Date begin = DateUtil.beginOfMonth(now);
//		Date end = DateUtil.endOfMonth(now);
//		queryWrapper0.eq("status", 0).between("cksj_time", begin, end);
//		queryWrapper1.eq("status", 1).between("cksj_time", begin, end);
//		Integer a = ZcglAdminZccrkgl.builder().build().selectCount(queryWrapper0);
//		Integer b = ZcglAdminZccrkgl.builder().build().selectCount(queryWrapper1);
//		Map<String, Integer> map = new HashMap<String, Integer>();
//		map.put("byrksl", a);
//		map.put("bycksl", b);
//		return ResultUtil.data(map, "查询成功");
//	}

	/**
	 * 设置报废资产
	 */
	@PostMapping(value = "/setScrap/{id}")
	@ApiOperation(value = "设置报废资产", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> setScrap(@CurrentUser UserBean userBean, @PathVariable Integer id, Integer bfsl) {

		QueryWrapper<ZcglAssoZcda> queryWrapper = new QueryWrapper<ZcglAssoZcda>();

		queryWrapper.eq("org_code", userBean.getOrgCode()).eq("id", id);

		ZcglAssoZcda zc = ZcglAssoZcda.builder().build().selectOne(queryWrapper);
		Integer xz = zc.getXzsl() - bfsl;
		Integer bf = zc.getBfsl() + bfsl;
		// 资产不为空 且 可报废数量大于等于0
		if (zc != null && xz >= 0) {

			zc.setXzsl(xz);
			zc.setBfsl(bf);

			UpdateWrapper<ZcglAssoZcda> updateWrapper = new UpdateWrapper<ZcglAssoZcda>();
			updateWrapper.eq("id", id);

			zc.update(updateWrapper);

			return ResultUtil.data(zc, "成功了");
		} else {
			return ResultUtil.error("请刷新！");
		}
	}

	/**
	 * 资产领用
	 */
	@PostMapping(value = "/zcly/{id}")
	@ApiOperation(value = "资产领用", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> zcly(@CurrentUser UserBean userBean, @RequestBody ZcglAssoZcly zcly,
			@PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
		Integer empNum = userBean.getEmpNum();

		QueryWrapper<ZcglAssoZcly> query = new QueryWrapper<ZcglAssoZcly>();
		query.eq("org_code", orgCode).eq("lyrid", zcly.getLyrid()).eq("zcid", id);
		ZcglAssoZcly zcglAssoZcly = ZcglAssoZcly.builder().build().selectOne(query);
		Integer xzlysl = zcly.getLysl();// 新增领用数量
		// 已有领用的物品
		if (zcglAssoZcly != null) {
			Integer ylysl = zcglAssoZcly.getLysl();

			UpdateWrapper<ZcglAssoZcly> updateWrapper = new UpdateWrapper<ZcglAssoZcly>();
			updateWrapper.eq("id", zcglAssoZcly.getId());
			zcly.setLysl(ylysl + xzlysl);
			zcly.update(updateWrapper);

			return ResultUtil.success("增加数量成功");
		} else {
			// 根据id查询资产详情
			QueryWrapper<ZcglAssoZcda> queryWrapper = new QueryWrapper<ZcglAssoZcda>();
			queryWrapper.eq("org_code", orgCode).eq("id", id);
			ZcglAssoZcda zcda = ZcglAssoZcda.builder().build().selectOne(queryWrapper);

			Integer zclysl = zcda.getLysl();// 仓库已领用
			Integer zcxzsl = zcda.getXzsl();// 仓库闲置
			Integer lysl = zcly.getLysl();// 领用数量

			UpdateWrapper<ZcglAssoZcda> updateWrapper = new UpdateWrapper<ZcglAssoZcda>();
			updateWrapper.eq("id", id);
			zcda.setLysl(zclysl + lysl);
			zcda.setXzsl(zcxzsl - lysl);
			zcda.update(updateWrapper);

			zcly.setZcid(id);
			zcly.setOrgCode(orgCode);
			zcly.setLyclr(empNum);
			zcly.setLyrqTime(new Date());

			zcly.insert();
			return ResultUtil.success("新增领用成功");
		}

	}

	/**
	 * 资产领用详情
	 */
	@PostMapping(value = "/zclyDetail/{id}")
	@ApiOperation(value = "资产领用详情", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> zclyDetail(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		QueryWrapper<ZcglAssoZcly> queryWrapper = new QueryWrapper<ZcglAssoZcly>();
		Integer orgCode = userBean.getOrgCode();
		queryWrapper.eq("org_code", orgCode).eq("zcid", id);
		List<ZcglAssoZcly> list = ZcglAssoZcly.builder().build().selectList(queryWrapper);
		List<ZcglLyDetailsDto> newList = new ArrayList<ZcglLyDetailsDto>();
		for (ZcglAssoZcly zcglAssoZcly : list) {
			ZcglLyDetailsDto zDto = new ZcglLyDetailsDto();
			Integer lyrid = zcglAssoZcly.getLyrid();
			Integer lyclr = zcglAssoZcly.getLyclr();
			String sybm = zcglAssoZcly.getSybm();
			QueryWrapper<YgglMainEmp> queryWrapper1 = new QueryWrapper<YgglMainEmp>();
			queryWrapper1.eq("org_code", orgCode).eq("emp_num", lyrid).select("name");
			YgglMainEmp yg1 = YgglMainEmp.builder().build().selectOne(queryWrapper1);
			if (yg1 != null && yg1.getName() != null) {
				zDto.setLyrid(yg1.getName());
			}

			QueryWrapper<YgglMainEmp> queryWrapper2 = new QueryWrapper<YgglMainEmp>();
			queryWrapper2.eq("org_code", orgCode).eq("emp_num", lyclr).select("name");
			YgglMainEmp yg2 = YgglMainEmp.builder().build().selectOne(queryWrapper2);
			if (yg2 != null && yg2.getName() != null) {
				zDto.setLyrid(yg2.getName());
			}

			QueryWrapper<ZzglBmgwM> queryWrapper3 = new QueryWrapper<ZzglBmgwM>();
			queryWrapper3.eq("org_code", orgCode).eq("id", sybm).select("name");
			ZzglBmgwM bm = ZzglBmgwM.builder().build().selectOne(queryWrapper3);
			if (bm != null && bm.getName() != null) {
				zDto.setSybm(bm.getName());
			}

			zDto.setGhrqTime(zcglAssoZcly.getGhrqTime());
			zDto.setLyhcfd(zcglAssoZcly.getLyhcfd());
			zDto.setLyrqTime(zcglAssoZcly.getLyrqTime());
			zDto.setLysl(zcglAssoZcly.getLysl());
			zDto.setOrgCode(orgCode);
			zDto.setSm(zcglAssoZcly.getSm());
			zDto.setZcid(id);
			zDto.setZtStatus(zcglAssoZcly.getZtStatus());
			newList.add(zDto);
		}

		return ResultUtil.data(newList, "查询成功");

	}

	/**
	 * 资产归还
	 */
	@PostMapping(value = "/zcback/{id}")
	@ApiOperation(value = "资产归还", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> zcback(@CurrentUser UserBean userBean, @RequestBody ZcglAssoZcgh zcgh,
			@PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
		Integer empNum = userBean.getEmpNum();

//		System.out.println(id);
		// 根据id查询资产详情
		QueryWrapper<ZcglAssoZcda> queryWrapper = new QueryWrapper<ZcglAssoZcda>();
		queryWrapper.eq("org_code", orgCode).eq("id", id);
		ZcglAssoZcda zcda = ZcglAssoZcda.builder().build().selectOne(queryWrapper);

		// 查询领用详情
		QueryWrapper<ZcglAssoZcly> queryWrapper2 = new QueryWrapper<ZcglAssoZcly>();
		queryWrapper2.eq("org_code", orgCode).eq("zcid", id).eq("lyrid", empNum);
		ZcglAssoZcly zcly = ZcglAssoZcly.builder().build().selectOne(queryWrapper2);

		// 仓库的已领用数量和闲置数量
		Integer lysl = zcda.getLysl();
		Integer xzsl = zcda.getXzsl();
		// 归还的数量
		Integer ghsl = zcgh.getGhsl();
		// 归还后的仓库已领用数量和闲置数量
		lysl = lysl - ghsl;
		xzsl = xzsl + ghsl;

		// 归还后的个人领用数量更新
		Integer grly = zcly.getLysl() - ghsl;

		// 更新數量
		if (ghsl > 0 && lysl >= 0 && grly >= 0) {

			UpdateWrapper<ZcglAssoZcda> updateWrapper = new UpdateWrapper<ZcglAssoZcda>();
			updateWrapper.eq("id", id);
			zcda.setLysl(lysl);
			zcda.setXzsl(xzsl);
			zcda.update(updateWrapper);

			UpdateWrapper<ZcglAssoZcly> updateWrapper2 = new UpdateWrapper<ZcglAssoZcly>();
			updateWrapper2.eq("lyrid", empNum).eq("zcid", id);
			zcly.setLysl(grly);
			if (grly == 0) {
				zcly.setZtStatus(1);
			}
			zcly.update(updateWrapper2);

//			System.out.println(id);

			// 插入资产归还表
			zcgh.setZcid(id);
			zcgh.setOrgCode(orgCode);
			zcgh.setGhrid(empNum);
			zcgh.setGhrqTime(new Date());
			zcgh.insert();
			// 更新仓库及个人领用

			return ResultUtil.data(zcgh, "归还成功");
		}
		return ResultUtil.error("归还失败，请确认归还数量是否正确！");

	}

	/********************** 手机端接口 ***************************/
	/**
	 * @param currPage 当前页
	 * @param pageSize 页码
	 * @return
	 */
	@GetMapping(value = "/queryGdzc")
	@ApiOperation(value = "固定资产查询(手机端)", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> queryGdzc(@CurrentUser UserBean userBean, @RequestParam(required = false) Integer currPage,
			@RequestParam(required = false) Integer pageSize) {
		if (currPage == null) {
			currPage = 1;
		}
		if (pageSize == null) {
			pageSize = 10;
		}
		List<ZcglDetailsDto> list = zcdaMapper.queryGdzc(userBean.getOrgCode(), (currPage - 1) * pageSize, pageSize);
		return ResultUtil.data(list, "查询成功");
	}

	@GetMapping(value = "/queryXhzc")
	@ApiOperation(value = "消耗资产查询(手机端)", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> queryXhzc(@CurrentUser UserBean userBean, @RequestParam(required = false) Integer currPage,
			@RequestParam(required = false) Integer pageSize) {
		if (currPage == null) {
			currPage = 1;
		}
		if (pageSize == null) {
			pageSize = 10;
		}
		List<ZcglDetailsDto> list = zcdaMapper.queryXhzc(userBean.getOrgCode(), (currPage - 1) * pageSize, pageSize);
		return ResultUtil.data(list, "查询成功");
	}

	/********************** 资产统计图 ***************************/
	/**
	 * 资产管理总资产、分类资产查询统计图查询
	 * 
	 * @param userBean
	 * @return
	 */
	@GetMapping(value = "/zcglzzc")
	@ApiOperation(value = "总资产、分类资产查询", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> queryZcglCartogram(@CurrentUser UserBean userBean, Integer id) {
		List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
		/**
		 * 查全部
		 */
		List<ZcglDetailsDto> zcdas = zcdaMapper.queryZczj(userBean.getOrgCode(), 0);
		Double zzc = 0D;
		for (ZcglDetailsDto zcglDetailsDto : zcdas) {
			Integer a = zcglDetailsDto.getXzsl();
			Integer b = zcglDetailsDto.getLysl();
			Double c = zcglDetailsDto.getZcdj();
			Double zj = (a + b) * c;
			zzc += zj;
		}

		/**
		 * 分类查
		 */
		List<ZcglDetailsDto> assoZcdas = zcdaMapper.queryZczj(userBean.getOrgCode(), id);
		for (ZcglDetailsDto zcglDetailsDto : assoZcdas) {
			Integer a = zcglDetailsDto.getXzsl();
			Integer b = zcglDetailsDto.getLysl();
			Double c = zcglDetailsDto.getZcdj();
			Double d = (a + b) * c;
			Map<String, Object> map = new HashMap<>();
			map.put("name", zcglDetailsDto.getMc());
			map.put("value", d);
			list.add(map);
		}

		return ResultUtil.datas(list, zzc, "查询成功");

	}

	/**
	 * 资产管理出入库数量按时间查询
	 * 
	 * @param userBean
	 * @param year
	 * @param yearMonth
	 * @return
	 */
	@PostMapping(value = "/zcglcrk")
	@ApiOperation(value = "出库、入库数量按时间查询", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> queryByDate(@CurrentUser UserBean userBean, @RequestBody ZcglTjtDto zcglTjtDto) {
		Integer orgCode = userBean.getOrgCode();
		Integer year = zcglTjtDto.getYear();
		Integer yearMonth = zcglTjtDto.getYearMonth();
		List<ZcglTjtDto> a = zccrkglMapper.queryRkByYear(orgCode);
		List<ZcglTjtDto> b = zccrkglMapper.queryCkByYear(orgCode);
		List<ZcglTjtDto> c = zccrkglMapper.queryRkByMonth(orgCode, year);
		List<ZcglTjtDto> d = zccrkglMapper.queryCkByMonth(orgCode, year);
		List<ZcglTjtDto> e = zccrkglMapper.queryRkByDay(orgCode, yearMonth);
		List<ZcglTjtDto> f = zccrkglMapper.queryCkByDay(orgCode, yearMonth);

		List<List<ZcglTjtDto>> list = new ArrayList<List<ZcglTjtDto>>();
		list.add(a);
		list.add(b);
		list.add(c);
		list.add(d);
		list.add(e);
		list.add(f);

		return ResultUtil.data(list, "查询成功");

	}

	/**
	 * 资产数量查询
	 * 
	 * @param userBean
	 * @param id
	 * @return
	 */
	@GetMapping(value = "/zcglzcsl")
	@ApiOperation(value = "资分类数量查询", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> queryZcsl(@CurrentUser UserBean userBean, Integer id) {

		List<ZcglDetailsDto> list = zcdaMapper.queryZczj(userBean.getOrgCode(), id);
		List<Object> l = new ArrayList<Object>();

		for (ZcglDetailsDto zcglDetailsDto : list) {
			Map<String, Object> map = new HashMap<>();
			String mc = zcglDetailsDto.getMc();
			Integer a = zcglDetailsDto.getXzsl();
			Integer b = zcglDetailsDto.getLysl();
			Integer c = zcglDetailsDto.getBfsl();
			map.put("mc", mc);
			map.put("xz", a);
			map.put("ly", b);
			map.put("bf", c);
			l.add(map);
		}

		return ResultUtil.data(l, "查询成功");
	}

}