wms / wms4_wuhanfeipu · Files

package org.jeecg.modules.working.controller;

import java.math.BigDecimal;
import java.text.DateFormat;
import java.text.Format;
import java.text.SimpleDateFormat;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.*;
import java.util.stream.Collectors;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.hutool.core.date.DateTime;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import org.apache.commons.beanutils.PropertyUtils;
import org.apache.shiro.SecurityUtils;
import org.hibernate.jdbc.Work;
import org.jeecg.common.StringUtils;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.common.system.util.JwtUtil;
import org.jeecg.common.system.vo.LoginUser;
import org.jeecg.common.util.ShiroUtils;
import org.jeecg.common.util.oConvertUtils;
import org.jeecg.modules.config.pbom.entity.Pbom;
import org.jeecg.modules.config.pbom.service.IPbomService;
import org.jeecg.modules.config.wmsdatabase.entity.ReceiptDetail;
import org.jeecg.modules.config.wmsdatabase.entity.WmsInventory;
import org.jeecg.modules.config.wmsdatabase.entity.WmsShipmentDetail;
import org.jeecg.modules.epbom_info.entity.EpbomInfo;
import org.jeecg.modules.makeInventory.entity.MakeInventory;
import org.jeecg.modules.makeInventory.service.IMakeInventoryService;
import org.jeecg.modules.scheduler.entity.ScheduleConstants;
import org.jeecg.modules.scheduler.entity.SchedulerDetail;
import org.jeecg.modules.scheduler.entity.SchedulerHeader;
import org.jeecg.modules.scheduler.service.SchedulerDetailService;
import org.jeecg.modules.scheduler.service.SchedulerHeaderService;
import org.jeecg.modules.scheduler.service.SchedulerTransactionService;
import org.jeecg.modules.scheduler.service.impl.SchedulerTransactionServiceImpl;
import org.jeecg.modules.system.entity.SysDepart;
import org.jeecg.modules.system.entity.SysUser;
import org.jeecg.modules.system.entity.SysUserRole;
import org.jeecg.modules.system.entity.Technology;
import org.jeecg.modules.system.service.ISysDepartService;
import org.jeecg.modules.system.service.ISysUserRoleService;
import org.jeecg.modules.system.service.ISysUserService;
import org.jeecg.modules.system.service.TechnologyService;
import org.jeecg.modules.working.entity.TotalTime;
import org.jeecg.modules.working.entity.Working;
import org.jeecg.modules.working.entity.WorkingData;
import org.jeecg.modules.working.entity.partWorking;
import org.jeecg.modules.working.service.IWorkingService;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import lombok.extern.slf4j.Slf4j;

import org.jeecg.common.system.base.controller.JeecgController;
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.jeecg.common.aspect.annotation.AutoLog;

import static java.math.BigDecimal.ROUND_HALF_DOWN;

/**
 * @Description: 工时统计
 * @Author: jeecg-boot
 * @Date:   2021-03-10
 * @Version: V1.0
 */
@Api(tags="工时统计")
@RestController
@RequestMapping("/working/working")
@Slf4j
public class WorkingController extends JeecgController<Working, IWorkingService> {
	@Autowired
	private IWorkingService workingService;
	@Autowired
	private ISysDepartService sysDepartService;
	@Autowired
	private ISysUserService sysUserService;
	@Autowired
	private SchedulerDetailService schedulerDetailService;
	@Autowired
	private SchedulerHeaderService schedulerHeaderService;
	@Autowired
	private TechnologyService technologyService;
	@Resource
	private IMakeInventoryService makeInventoryService;
	@Resource
	private IPbomService pbomService;
	@Resource
	private ISysUserRoleService userRoleService;

	@Resource
	private SchedulerTransactionServiceImpl schedulerTransactionServiceImpl;
	/**
	 * 分页列表查询
	 *
	 * @param working
	 * @param pageNo
	 * @param pageSize
	 * @param req
	 * @return
	 */
	@AutoLog(value = "工时统计-分页列表查询")
	@ApiOperation(value="工时统计-分页列表查询", notes="工时统计-分页列表查询")
	@GetMapping(value = "/list")
	public Result<?> queryPageList(Working working,
								   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
								   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
								   String createTime_begin, String createTime_end,
								   HttpServletRequest req) {
		String userName = JwtUtil.getUserNameByToken(req);
		SysUser user = sysUserService.getUserByName(userName);

		if(working.getTechnology() != null) {
		   LambdaQueryWrapper<Technology> technologyLambdaQueryWrapper =  Wrappers.lambdaQuery();
		   technologyLambdaQueryWrapper.eq(Technology::getName, working.getTechnology());
		   Technology technology = technologyService.getOne(technologyLambdaQueryWrapper);
		   if(technology != null) {
			   working.setTechnology(technology.getCode());
		   }
    	}

		LambdaQueryWrapper<Working> lambdaQueryWrapper = Wrappers.lambdaQuery();
		lambdaQueryWrapper
				.eq(StrUtil.isNotBlank(working.getCompanyCode()), Working::getCompanyCode, working.getCompanyCode())
				.eq(StrUtil.isNotBlank(working.getOperater()), Working::getOperater, working.getOperater())
				.eq(StrUtil.isNotBlank(working.getCode()), Working::getCode, working.getCode())
				.eq(StrUtil.isNotBlank(working.getDepart()), Working::getDepart, working.getDepart())
				.eq(StrUtil.isNotBlank(working.getMaterialname()), Working::getMaterialname, working.getMaterialname())
				.eq(StrUtil.isNotBlank(working.getCreateBy()), Working::getCreateBy, working.getCreateBy())
				.eq(StrUtil.isNotBlank(working.getTechnology()), Working::getTechnology, working.getTechnology())
				.like(StrUtil.isNotBlank(working.getDrawingno()),Working::getDrawingno, working.getDrawingno())
				.like(StrUtil.isNotBlank(working.getMaterialname()), Working::getMaterialname, working.getMaterialname())
				.ge(StrUtil.isNotBlank(createTime_begin), Working::getCreateTime, createTime_begin)
				.le(StrUtil.isNotBlank(createTime_end), Working::getCreateTime, createTime_end)
				.orderByDesc(Working::getId);
		Page<Working> page = new Page<Working>(pageNo, pageSize);
		IPage<Working> pageList = workingService.page(page, lambdaQueryWrapper);
		return Result.OK(pageList);
	}

	 /**
	  * 分页列表查询
	  *
	  * @param working
	  * @return
	  */
	 @AutoLog(value = "工时统计-分页列表查询")
	 @ApiOperation(value="工时统计-分页列表查询", notes="工时统计-分页列表查询")
	 @GetMapping(value = "/queryList")
	 public Result<?> queryList(Working working,
								@RequestParam(name = "createdBegin") String createdBegin,
								@RequestParam(name = "createdEnd") String createdEnd,HttpServletRequest request) {

		 String userName = JwtUtil.getUserNameByToken(request);
		 SysUser user = sysUserService.getUserByName(userName);
         //判断是否为现场管理员角色
		 LambdaQueryWrapper<SysUserRole>roleWrapper=Wrappers.lambdaQuery();
		 roleWrapper.eq(SysUserRole::getUserId,user.getId())
				 .eq(SysUserRole::getRoleId,"1527477162645389313");
		 List<SysUserRole>list=userRoleService.list(roleWrapper);
		 LambdaQueryWrapper<Working> lambdaQueryWrapper = Wrappers.lambdaQuery();
		 lambdaQueryWrapper
				 .eq(StrUtil.isNotBlank(working.getCompanyCode()), Working::getCompanyCode, working.getCompanyCode())
				 .eq(StrUtil.isNotBlank(working.getOperater()), Working::getOperater, working.getOperater())
				 .eq(StrUtil.isNotBlank(working.getCreateBy()), Working::getCreateBy, working.getCreateBy())
				 .like(StrUtil.isNotBlank(working.getDrawingno()),Working::getDrawingno, working.getDrawingno())
				 .like(StrUtil.isNotBlank(working.getMaterialname()), Working::getMaterialname, working.getMaterialname())
				 .ge(StrUtil.isNotBlank(createdBegin), Working::getCreateTime, createdBegin)
				 .isNull(Working::getWork_type)
				 .le(StrUtil.isNotBlank(createdEnd), Working::getCreateTime, createdEnd);
		 List<Working> pageList = workingService.list(lambdaQueryWrapper);
		 if (list.size()>0){
		 	LambdaQueryWrapper<Working>workingLambdaQueryWrapper=Wrappers.lambdaQuery();
			workingLambdaQueryWrapper.eq(Working::getWork_type,"1");
			List<Working>workingList= workingService.list(workingLambdaQueryWrapper);
			for (Working working1:workingList){
				LambdaQueryWrapper<SysUser>sysUserLambdaQueryWrapper=Wrappers.lambdaQuery();
				sysUserLambdaQueryWrapper.eq(SysUser::getUsername,working1.getCreateBy()).last("limit 1");
				SysUser user1=sysUserService.getOne(sysUserLambdaQueryWrapper);
				if (user1!=null){
					working1.setRealname(user1.getRealname());
				}
			}
			pageList.addAll(workingList);
		 }
		 return Result.OK(pageList);
	 }

	/**
	 * 分页列表查询
	 *
	 * @param working
	 * @return
	 */
	@AutoLog(value = "工时汇总-查询")
	@ApiOperation(value="工时汇总-查询", notes="工时汇总-查询")
	@GetMapping(value = "/queryHzList")
	public Result<?> queryHzList(Working working,
							   @RequestParam(name = "createdBegin") String createdBegin,
							   @RequestParam(name = "createdEnd") String createdEnd,HttpServletRequest request) {
//		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
//		//取今天日期,如果日期类型为String类型,可以使用df.parse()方法,转换为Date类型
//		Date date = new Date();
//		Calendar calendar = Calendar.getInstance();//new一个Calendar类,把Date放进去
//		calendar.setTime(date);
//		calendar.add(Calendar.DATE, 1);//实现日期加一操作,也就是明天
//		calendar.add(Calendar.DATE, -2);
//		System.out.println("昨天的日期为:" + df.format(calendar.getTime()));
//		LambdaQueryWrapper<Working> lambdaQueryWrapper = Wrappers.lambdaQuery();
//		lambdaQueryWrapper
//				.eq(StrUtil.isNotBlank(working.getCompanyCode()), Working::getCompanyCode, working.getCompanyCode())
//				.eq(StrUtil.isNotBlank(working.getOperater()), Working::getOperater, working.getOperater())
//				.eq(StrUtil.isNotBlank(working.getCreateBy()), Working::getCreateBy, working.getCreateBy())
//				.like(StrUtil.isNotBlank(working.getDrawingno()),Working::getDrawingno, working.getDrawingno())
//				.like(StrUtil.isNotBlank(working.getMaterialname()), Working::getMaterialname, working.getMaterialname())
//				.ge(StrUtil.isNotBlank(createdBegin), Working::getCreateTime, createdBegin)
//				.le(StrUtil.isNotBlank(createdEnd), Working::getCreateTime, df.format(calendar.getTime()));
//		List<Working> pageList = workingService.list(lambdaQueryWrapper);
//		return Result.OK(pageList);
        String userName = JwtUtil.getUserNameByToken(request);
        SysUser user = sysUserService.getUserByName(userName);
        //判断是否为现场管理员角色
        LambdaQueryWrapper<SysUserRole>roleWrapper=Wrappers.lambdaQuery();
        roleWrapper.eq(SysUserRole::getUserId,user.getId())
                .eq(SysUserRole::getRoleId,"1527477162645389313");
        List<SysUserRole>list=userRoleService.list(roleWrapper);
        LambdaQueryWrapper<Working> lambdaQueryWrapper = Wrappers.lambdaQuery();
        lambdaQueryWrapper
                .eq(StrUtil.isNotBlank(working.getCompanyCode()), Working::getCompanyCode, working.getCompanyCode())
                .eq(StrUtil.isNotBlank(working.getOperater()), Working::getOperater, working.getOperater())
                .eq(StrUtil.isNotBlank(working.getCreateBy()), Working::getCreateBy, working.getCreateBy())
                .like(StrUtil.isNotBlank(working.getDrawingno()),Working::getDrawingno, working.getDrawingno())
                .like(StrUtil.isNotBlank(working.getMaterialname()), Working::getMaterialname, working.getMaterialname())
                .ge(StrUtil.isNotBlank(createdBegin), Working::getCreateTime, createdBegin)
                .isNull(Working::getWork_type)
                .le(StrUtil.isNotBlank(createdEnd), Working::getCreateTime, createdEnd);
        List<Working> pageList = workingService.list(lambdaQueryWrapper);
        if (list.size()>0){
            LambdaQueryWrapper<Working>workingLambdaQueryWrapper=Wrappers.lambdaQuery();
            workingLambdaQueryWrapper.eq(Working::getWork_type,"1");
            List<Working>workingList= workingService.list(workingLambdaQueryWrapper);
            for (Working working1:workingList){
                LambdaQueryWrapper<SysUser>sysUserLambdaQueryWrapper=Wrappers.lambdaQuery();
                sysUserLambdaQueryWrapper.eq(SysUser::getUsername,working1.getCreateBy()).last("limit 1");
                SysUser user1=sysUserService.getOne(sysUserLambdaQueryWrapper);
                if (user1!=null){
                    working1.setRealname(user1.getRealname());
                }
            }
            pageList.addAll(workingList);
        }
        return Result.OK(pageList);
	}

	/**
	 *   添加
	 *
	 * @param working
	 * @return
	 */
	@AutoLog(value = "工时统计-添加")
	@ApiOperation(value="工时统计-添加", notes="工时统计-添加")
	@PostMapping(value = "/add")
	public Result<?> add(@RequestBody Working working) {
		workingService.save(working);
		return Result.OK("添加成功！");
	}

	 @AutoLog(value = "手工工时统计-分页列表查询")
	 @ApiOperation(value="工时统计-分页列表查询", notes="工时统计-分页列表查询")
	 @GetMapping(value = "/queryManualList")
	 public Result<?> queryManualList(Working working,
								@RequestParam(name = "createdBegin") String createdBegin,
								@RequestParam(name = "createdEnd") String createdEnd,
								HttpServletRequest req) {
		 LambdaQueryWrapper<Working> lambdaQueryWrapper = Wrappers.lambdaQuery();
		 lambdaQueryWrapper
				 .eq(StrUtil.isNotBlank(working.getCompanyCode()), Working::getCompanyCode, working.getCompanyCode())
				 .eq(StrUtil.isNotBlank(working.getOperater()), Working::getOperater, working.getOperater())
				 .eq(StrUtil.isNotBlank(working.getCreateBy()), Working::getCreateBy, working.getCreateBy())
				 .like(StrUtil.isNotBlank(working.getCode()),Working::getCode, working.getCode())
				 .like(StrUtil.isNotBlank(working.getMaterialname()), Working::getMaterialname, working.getMaterialname())
				 .like(StrUtil.isNotBlank(working.getWorkcontent()), Working::getWorkcontent, working.getWorkcontent())
				 .isNotNull(Working::getWorkcontent)  //通过工作内容来判断手工工时
				 .ge(StrUtil.isNotBlank(createdBegin), Working::getCreateTime, createdBegin)
				 .le(StrUtil.isNotBlank(createdEnd), Working::getCreateTime, createdEnd);
		 List<Working> pageList = workingService.list(lambdaQueryWrapper);
		 return Result.OK(pageList);
	 }

	 /**
	  * @param working
	  * @return
	  */
	 @AutoLog(value = "移动端手动报工")
	 @ApiOperation(value="移动端手动报工", notes="移动端手动报工")
	 @PostMapping(value = "/manual/add")
	 public Result<?> manualAdd(@RequestBody Working working, HttpServletRequest request) {
		String userName = JwtUtil.getUserNameByToken(request);
		SysUser user = sysUserService.getUserByName(userName);
		Integer manualWork = user.getManualwork();
		if(manualWork.intValue() == 0) {
			 return Result.error("没有手动报工权限，请向班组长申请");
		}
		List<SysDepart> departs = sysDepartService.queryUserDeparts(user.getId());
	 	working.setOperater(user.getUsername());
	 	working.setDepart(departs.get(0).getId());
	 	working.setCreateBy(userName);
	 	working.setUpdateBy(userName);
	 	working.setType(1);
	 	working.setUpdateTime(LocalDateTime.now());
	 	working.setCompleteDate(new Date());
	 	working.setCompanyCode(user.getCompanyCode());
		workingService.save(working);

		// TODO 生成自制件库存表，存在疑问：working.schedulerDetailId不能为空
		if (working.getSchedulerDetailId() == null){
			return Result.OK("添加成功！");
		}
		SchedulerDetail schedulerDetail = schedulerDetailService.getById(working.getSchedulerDetailId());
		SchedulerHeader schedulerHeader = schedulerHeaderService.getById(schedulerDetail.getHeaderId());
		int status = schedulerHeader == null ? 0 : schedulerHeader.getStatus();
		if (status > 0){
			schedulerTransactionServiceImpl.saveMakeInventory(schedulerDetail, working.getQty(), schedulerHeader,  ScheduleConstants.product_type_accessories, null, schedulerHeader.getProjectName());
		}
		 return Result.OK("添加成功！");
	 }

	/**
	 *  编辑
	 *
	 * @param working
	 * @return
	 */
	@AutoLog(value = "工时统计-编辑")
	@ApiOperation(value="工时统计-编辑", notes="工时统计-编辑")
	@PutMapping(value = "/edit")
	public Result<?> edit(@RequestBody Working working) {
		workingService.updateById(working);
		return Result.OK("编辑成功!");
	}

	/**
	 *   通过id删除
	 *
	 * @param id
	 * @return
	 */
	@AutoLog(value = "工时统计-通过id删除")
	@ApiOperation(value="工时统计-通过id删除", notes="工时统计-通过id删除")
	@DeleteMapping(value = "/delete")
	public Result<?> delete(@RequestParam(name="id",required=true) String id) {
		Working working = workingService.getById(id);
        if(working.getCreateTime().toLocalDate().isAfter(LocalDateTime.now().toLocalDate().minusDays(1))){
			LambdaQueryWrapper<SchedulerDetail> schedulerDetailLambdaQueryWrapper = Wrappers.lambdaQuery();
			schedulerDetailLambdaQueryWrapper.eq(SchedulerDetail::getDrawingNo, working.getDrawingno())
					.eq(StrUtil.isNotBlank(working.getMaterialname()), SchedulerDetail::getName, working.getMaterialname())
					.eq(StrUtil.isNotBlank(working.getSpec()), SchedulerDetail::getSpec, working.getSpec())
					.eq(working.getSchedulerDetailId()!= null, SchedulerDetail::getId, working.getSchedulerDetailId())
					.eq(SchedulerDetail::getTechnology, working.getTechnology());
			working.getCode();
			SchedulerDetail schedulerDetail = schedulerDetailService.getOne(schedulerDetailLambdaQueryWrapper);
			if(schedulerDetail != null) {
				schedulerDetail.setStatus(0);
				BigDecimal completeQty = schedulerDetail.getCompleteQty().subtract(working.getQty());
				if(completeQty.compareTo(BigDecimal.ZERO) < 0) {
					completeQty = new BigDecimal(0);
				}
				if(working.getReadycomplete().intValue() == 1) {
					schedulerDetail.setReadyComplete(0);
				}
				schedulerDetail.setCompleteQty(completeQty);
				schedulerDetail.setCompleteBy("");
				schedulerDetailService.update(schedulerDetail, schedulerDetailLambdaQueryWrapper);
			}
			workingService.removeById(id);
			return Result.OK("删除成功!");
		}else{
			return Result.error("只能删除当天报工工时!!!");
		}
	}

	/**
	 *  批量删除
	 *
	 * @param ids
	 * @return
	 */
	@AutoLog(value = "工时统计-批量删除")
	@ApiOperation(value="工时统计-批量删除", notes="工时统计-批量删除")
	@DeleteMapping(value = "/deleteBatch")
	public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
		List<String> idList = Arrays.asList(ids.split(","));
		for(String id : idList) {
			Working working = workingService.getById(id);
			LambdaQueryWrapper<SchedulerDetail> schedulerDetailLambdaQueryWrapper = Wrappers.lambdaQuery();
			schedulerDetailLambdaQueryWrapper.eq(SchedulerDetail::getDrawingNo, working.getDrawingno())
					.ne(SchedulerDetail::getStatus, 0)
					.eq(SchedulerDetail::getName, working.getMaterialname())
					.eq(SchedulerDetail::getId, working.getSchedulerDetailId())
					.eq(SchedulerDetail::getTechnology, working.getTechnology())
			        .last("limit 1");
			SchedulerDetail schedulerDetail = schedulerDetailService.getOne(schedulerDetailLambdaQueryWrapper);
			if (schedulerDetail != null) {
				SchedulerDetail schedulerDetail1=new SchedulerDetail();
				schedulerDetail1.setStatus(0);
				BigDecimal completeQty = schedulerDetail.getCompleteQty().subtract(working.getQty());
				schedulerDetail1.setCompleteQty(completeQty);
				schedulerDetail1.setCompleteBy("");
				schedulerDetailService.update(schedulerDetail1, schedulerDetailLambdaQueryWrapper);
			}
		}
		this.workingService.removeByIds(Arrays.asList(ids.split(",")));
		return Result.OK("批量删除成功!");
	}

	/**
	 * 通过id查询
	 *
	 * @param id
	 * @return
	 */
	@AutoLog(value = "工时统计-通过id查询")
	@ApiOperation(value="工时统计-通过id查询", notes="工时统计-通过id查询")
	@GetMapping(value = "/queryById")
	public Result<?> queryById(@RequestParam(name="id",required=true) String id) {
		Working working = workingService.getById(id);
		if(working==null) {
			return Result.error("未找到对应数据");
		}
		return Result.OK(working);
	}

	 @GetMapping(value = "/calculateTotal")
	 public TotalTime calculateTotal(HttpServletRequest request, Working working) {
		 String userName = JwtUtil.getUserNameByToken(request);
		 SysUser user = sysUserService.getUserByName(userName);
		 if(working.getTechnology() != null) {
			 LambdaQueryWrapper<Technology> technologyLambdaQueryWrapper =  Wrappers.lambdaQuery();
			 technologyLambdaQueryWrapper.eq(Technology::getName, working.getTechnology());
			 Technology technology = technologyService.getOne(technologyLambdaQueryWrapper);
			 if(technology != null) {
				 working.setTechnology(technology.getCode());
			 }
		 }
		 QueryWrapper<Working> queryWrapper = QueryGenerator.initQueryWrapper(working, request.getParameterMap());
		 LambdaQueryWrapper<Working> lambdaQueryWrapper = queryWrapper.lambda();
		 lambdaQueryWrapper.eq(Working::getCompanyCode, user.getCompanyCode());
 		 // Step.2 获取导出数据
		 List<Working> pageList = workingService.list(lambdaQueryWrapper);
		 List<Working> exportList = null;

		 // 过滤选中数据
		 String selections = request.getParameter("selections");
		 if (oConvertUtils.isNotEmpty(selections)) {
			 List<String> selectionList = Arrays.asList(selections.split(","));
			 exportList = pageList.stream().filter(item -> selectionList.contains(getId(item))).collect(Collectors.toList());
		 } else {
			 exportList = pageList;
		 }
		 List<String> createList = new ArrayList<>();
		 BigDecimal totalQty = new BigDecimal(0);
		 if(exportList != null && exportList.size() > 0) {
			 createList = exportList.stream().map(t-> t.getCreateBy()).distinct().collect(Collectors.toList());
			 createList.removeAll(Collections.singleton(null));
			 for (Working working1 : exportList) {
				 if(working1.getApprovedtime().compareTo(BigDecimal.ZERO)  > 0) {
					 totalQty = totalQty.add(working1.getApprovedtime());
				 } else {
					 totalQty = totalQty.add(working1.getCompletetime());
				 }
			 }
		 }
		 BigDecimal hourtotalQty = totalQty.divide(new BigDecimal(60), 1, ROUND_HALF_DOWN);
		 TotalTime totalTime = new TotalTime();
		 totalTime.setTotalHour(hourtotalQty.toString());
		 totalTime.setTotalMinutes(totalQty.toString());
		 totalTime.setNum(String.valueOf(createList.size()));
		 return totalTime;
	 }


	 @GetMapping(value = "/getProjectSum")
	 public String  getProjectSum(@RequestParam(name = "field0056") String field0056){
		 List<partWorking> list2 = workingService.getSumPartWorking(field0056);
		 String str="";
		 for(partWorking part:list2){
			 str+=part.getDepartName()+":"+part.getTime()+"小时;";
		 }
		 return str;
	 }

    /**
    * 导出excel
    *
    * @param request
    * @param working
    */
    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, Working working,  String createTime_begin, String createTime_end) {
		QueryWrapper<Working> queryWrapper = QueryGenerator.initQueryWrapper(working, request.getParameterMap());
		LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();
		if(working.getTechnology() != null) {
			LambdaQueryWrapper<Technology> technologyLambdaQueryWrapper =  Wrappers.lambdaQuery();
			technologyLambdaQueryWrapper.eq(Technology::getName, working.getTechnology());
			Technology technology = technologyService.getOne(technologyLambdaQueryWrapper);
			if(technology != null) {
				working.setTechnology(technology.getCode());
			}
		}
		LambdaQueryWrapper<Working> lambdaQueryWrapper = Wrappers.lambdaQuery();
		lambdaQueryWrapper
				.eq(StrUtil.isNotBlank(working.getCompanyCode()), Working::getCompanyCode, working.getCompanyCode())
				.eq(StrUtil.isNotBlank(working.getOperater()), Working::getOperater, working.getOperater())
				.eq(StrUtil.isNotBlank(working.getCode()), Working::getCode, working.getCode())
				.eq(StrUtil.isNotBlank(working.getDepart()), Working::getDepart, working.getDepart())
				.eq(StrUtil.isNotBlank(working.getMaterialname()), Working::getMaterialname, working.getMaterialname())
				.eq(StrUtil.isNotBlank(working.getCreateBy()), Working::getCreateBy, working.getCreateBy())
				.eq(StrUtil.isNotBlank(working.getTechnology()), Working::getTechnology, working.getTechnology())
				.like(StrUtil.isNotBlank(working.getDrawingno()),Working::getDrawingno, working.getDrawingno())
				.like(StrUtil.isNotBlank(working.getMaterialname()), Working::getMaterialname, working.getMaterialname())
				.ge(StrUtil.isNotBlank(createTime_begin), Working::getCreateTime, createTime_begin)
				.le(StrUtil.isNotBlank(createTime_end), Working::getCreateTime, createTime_end)
				.orderByDesc(Working::getId);
		List<Working> pageList = workingService.list(lambdaQueryWrapper);
		List<Working> exportList = null;

		// 过滤选中数据
		String selections = request.getParameter("selections");
		if (oConvertUtils.isNotEmpty(selections)) {
			List<String> selectionList = Arrays.asList(selections.split(","));
			exportList = pageList.stream().filter(item -> selectionList.contains(getId(item))).collect(Collectors.toList());
		} else {
			exportList = pageList;
		}
		BigDecimal totalQty = new BigDecimal(0);
		if(exportList != null && exportList.size() > 0) {
			for (Working working1 : exportList) {
				if(working1.getApprovedtime().compareTo(BigDecimal.ZERO)  > 0) {
					totalQty = totalQty.add(working1.getApprovedtime());
				} else {
					totalQty = totalQty.add(working1.getCompletetime());
				}
			}
		}
		BigDecimal hourtotalQty = totalQty.divide(new BigDecimal(60), 1, ROUND_HALF_DOWN);
		// Step.3 AutoPoi 导出Excel
		ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
		mv.addObject(NormalExcelConstants.FILE_NAME, "工时统计"); //此处设置的filename无效 ,前端会重更新设置一下
		mv.addObject(NormalExcelConstants.CLASS, Working.class);
		//update-begin--Author:liusq  Date:20210126 for：图片导出报错，ImageBasePath未设置--------------------
		ExportParams exportParams=new ExportParams("工时统计" + "报表", "总工时" + totalQty.toString() + "分钟    " + hourtotalQty.toString() + "小时     "+ "导出人:" + sysUser.getRealname(), "工时统计");
		//update-end--Author:liusq  Date:20210126 for：图片导出报错，ImageBasePath未设置----------------------
		mv.addObject(NormalExcelConstants.PARAMS,exportParams);
		mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
		return mv;
    }

	 private String getId(Working item) {
		 try {
			 return PropertyUtils.getProperty(item, "id").toString();
		 } catch (Exception e) {
			 e.printStackTrace();
			 return null;
		 }
	 }

    /**
      * 通过excel导入数据
    *
    * @param request
    * @param response
    * @return
    */
    @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
    public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
        return super.importExcel(request, response, Working.class);
    }


	@AutoLog(value = "部件工时统计-分页列表查询")
	@ApiOperation(value="部件工时统计-分页列表查询", notes="部件工时统计-分页列表查询")
	@GetMapping(value = "/partWoringList")
	public Result<?> partWoringList(Working working,
									 @RequestParam(name = "field0056") String field0056,
									 HttpServletRequest req) {
		List<partWorking> list = workingService.getPartWorking(field0056);
		return Result.OK(list);
	}



	@GetMapping(value = "/partList")
	public Result<IPage<partWorking>> partList(partWorking partWork,@RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
										@RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
										HttpServletRequest req) {
		Result<IPage<partWorking>> result = new Result<IPage<partWorking>>();
		IPage<partWorking> bomList=new Page<>();
		if (StrUtil.isNotEmpty(partWork.getParCno())) {
			List<partWorking> list = workingService.getBomPartWorking(partWork.getHeaderId(), partWork.getPartNo(), partWork.getCno(),partWork.getParCno());
			for (partWorking bo : list) {
				QueryWrapper<Pbom> queryWrapper2 = new QueryWrapper<Pbom>();
				queryWrapper2.eq("pno", bo.getCno())
						.eq("uuid", partWork.getPartNo())
						.eq("f04", "自制");
				List<Pbom> list3 = pbomService.list(queryWrapper2);
				if (list3.size() > 0) {
					bo.setHasChild("1");
				} else {
					bo.setHasChild("0");
				}
			}
			bomList.setRecords(list);
			result.setResult(bomList);
			result.setSuccess(true);
		}else {
			List<partWorking>list=new ArrayList<>();
			partWork.setHasChild("1");
			partWork.setCno(partWork.getPartNo());
			partWork.setParCno(partWork.getParCno());
			list.add(partWork);
			bomList.setRecords(list);
			result.setSuccess(true);
			result.setResult(bomList);
		}
		return result;
	}




	@GetMapping(value = "/childList")
	public Result<List<partWorking>> childList(partWorking partWork,HttpServletRequest req){
		Result<List<partWorking>> result = new Result<List<partWorking>>();
		List<partWorking>list=workingService.getBomPartWorking(partWork.getHeaderId(),partWork.getPartNo(),partWork.getCno(),partWork.getParCno());
		for (partWorking bo:list){
			QueryWrapper<Pbom> queryWrapper2 = new QueryWrapper<Pbom>();
			queryWrapper2.eq("pno", bo.getCno())
					.eq("uuid", partWork.getPartNo())
			.eq("f04","自制");
			List<Pbom>list3=pbomService.list(queryWrapper2);
			if (list3.size()>0){
				bo.setHasChild("1");
			}else{
				bo.setHasChild("0");
			}
		}
		result.setResult(list);
		result.setSuccess(true);
		return result;
	}

	@GetMapping(value = "/getCompanyWorkList")
	public Result<?> queryVersionPageList(Working working){
    	List<WorkingData>list=workingService.getCompanyWorkList(working.getId(),working.getSpec());
    	return Result.OK(list);
	}

}