package cn.besteam.modules.medical.controller;

import java.io.IOException;
import java.math.RoundingMode;
import java.net.URLEncoder;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.besteam.common.aspect.annotation.OpenApi;
import cn.besteam.common.constant.CommonConstant;
import cn.besteam.common.constant.MedicalWasteEnum;
import cn.besteam.common.util.DateUtil;
import cn.besteam.modules.medical.dto.MwCollectRecordOpsDTO;
import cn.besteam.modules.medical.vo.MwCollectRecordVO;
import cn.besteam.modules.medical.vo.MwCollectionAmendantRecordVO;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import cn.besteam.common.api.vo.Result;
import cn.besteam.common.aspect.annotation.AutoLog;
import cn.besteam.common.util.oConvertUtils;
import cn.besteam.modules.medical.entity.MwCollectionAmendantRecord;
import cn.besteam.modules.medical.service.IMwCollectionAmendantRecordService;
import lombok.Data;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
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;

 /**
 * @Title: Controller
 * @Description: 医废修改记录
 * @author： besteam
 * @date：   2022-02-14
 * @version： V1.0
 */
@RestController
@RequestMapping("/medical/mwCollectionAmendantRecord")
@Slf4j
@Api(description = "医废修改记录")
public class MwCollectionAmendantRecordController {

	@Autowired
	private IMwCollectionAmendantRecordService mwCollectionAmendantRecordService;
	
	/**
	  * 分页列表查询
	 * @param mwCollectionAmendantRecord
	 * @param pageNo
	 * @param pageSize
	 * @param req
	 * @return
	 */
	@GetMapping(value = "/list")
	@ApiOperation(value = "获取医废修改记录数据列表", notes = "获取所有医废修改记录数据列表", produces = "application/json")
	public Result<IPage<MwCollectionAmendantRecord>> queryPageList(MwCollectionAmendantRecord mwCollectionAmendantRecord, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) {

		Result<IPage<MwCollectionAmendantRecord>> result = new Result<IPage<MwCollectionAmendantRecord>>();
		QueryWrapper<MwCollectionAmendantRecord> queryWrapper = new QueryWrapper<MwCollectionAmendantRecord>(mwCollectionAmendantRecord);
		Page<MwCollectionAmendantRecord> page = new Page<MwCollectionAmendantRecord>(pageNo, pageSize);
		//排序逻辑 处理
		String column = req.getParameter("column");
		String order = req.getParameter("order");
		if(oConvertUtils.isNotEmpty(column) && oConvertUtils.isNotEmpty(order)) {
			if("asc".equals(order)) {
				queryWrapper.orderByAsc(oConvertUtils.camelToUnderline(column));
			}else {
				queryWrapper.orderByDesc(oConvertUtils.camelToUnderline(column));
			}
		}else{
			queryWrapper.orderByAsc("create_time");
		}
		IPage<MwCollectionAmendantRecord> pageList = mwCollectionAmendantRecordService.page(page, queryWrapper);
		//log.debug("查询当前页："+pageList.getCurrent());
		//log.debug("查询当前页数量："+pageList.getSize());
		//log.debug("查询结果数量："+pageList.getRecords().size());
		//log.debug("数据总数："+pageList.getTotal());
		result.setSuccess(true);
		result.setResult(pageList);
		return result;
	}
	
	/**
	  *   添加
	 * @param mwCollectionAmendantRecord
	 * @return
	 */
	@PostMapping(value = "/add")
	@AutoLog(value = "添加医废修改记录")
	@ApiOperation(value = "添加医废修改记录", notes = "添加医废修改记录", produces = "application/json")
	public Result<MwCollectionAmendantRecord> add(@RequestBody MwCollectionAmendantRecord mwCollectionAmendantRecord) {

		Result<MwCollectionAmendantRecord> result = new Result<MwCollectionAmendantRecord>();
		try {
			mwCollectionAmendantRecordService.save(mwCollectionAmendantRecord);
			result.success("添加成功！");
		} catch (Exception e) {
			log.error("", e);
			result.error500("操作失败");
		}
		return result;
	}
	
	/**
	  *  编辑
	 * @param mwCollectionAmendantRecord
	 * @return
	 */
	@PostMapping(value = "/edit")
	@AutoLog(value = "编辑医废修改记录")
	@ApiOperation(value = "编辑医废修改记录", notes = "编辑医废修改记录", produces = "application/json")
	public Result<MwCollectionAmendantRecord> edit(@RequestBody MwCollectionAmendantRecord mwCollectionAmendantRecord) {

		Result<MwCollectionAmendantRecord> result = new Result<MwCollectionAmendantRecord>();
		MwCollectionAmendantRecord mwCollectionAmendantRecordEntity = mwCollectionAmendantRecordService.getById(mwCollectionAmendantRecord.getId());
		if(mwCollectionAmendantRecordEntity==null) {
			result.error500("未找到对应实体");
		}else {
			boolean ok = mwCollectionAmendantRecordService.updateById(mwCollectionAmendantRecord);
			//TODO 返回false说明什么？
			if(ok) {
				result.success("修改成功!");
			}
		}
		
		return result;
	}
	
	/**
	  *   通过id删除
	 * @param id
	 * @return
	 */
	@PostMapping(value = "/delete")
	@AutoLog(value = "删除医废修改记录")
	@ApiOperation(value = "删除医废修改记录", notes = "删除医废修改记录", produces = "application/json")
	public Result<MwCollectionAmendantRecord> delete(@RequestParam(name="id",required=true) String id) {

		Result<MwCollectionAmendantRecord> result = new Result<MwCollectionAmendantRecord>();
		MwCollectionAmendantRecord mwCollectionAmendantRecord = mwCollectionAmendantRecordService.getById(id);
		if(mwCollectionAmendantRecord==null) {
			result.error500("未找到对应实体");
		}else {
			boolean ok = mwCollectionAmendantRecordService.removeById(id);
			if(ok) {
				result.success("删除成功!");
			}
		}
		
		return result;
	}
	
	/**
	  *  批量删除
	 * @param ids
	 * @return
	 */
	@PostMapping(value = "/deleteBatch")
	@AutoLog(value = "批量删除医废修改记录")
	@ApiOperation(value = "批量删除医废修改记录", notes = "批量删除医废修改记录", produces = "application/json")
	public Result<MwCollectionAmendantRecord> deleteBatch(@RequestParam(name="ids",required=true) String ids) {

		Result<MwCollectionAmendantRecord> result = new Result<MwCollectionAmendantRecord>();
		if(ids==null || "".equals(ids.trim())) {
			result.error500("参数不识别！");
		}else {
			this.mwCollectionAmendantRecordService.removeByIds(Arrays.asList(ids.split(",")));
			result.success("删除成功!");
		}
		return result;
	}
	
	/**
	  * 通过id查询
	 * @param id
	 * @return
	 */
	@GetMapping(value = "/queryById")
	@ApiOperation(value = "通过id查询医废修改记录", notes = "通过id查询医废修改记录", produces = "application/json")
	public Result<MwCollectionAmendantRecord> queryById(@RequestParam(name="id",required=true) String id) {

		Result<MwCollectionAmendantRecord> result = new Result<MwCollectionAmendantRecord>();
		MwCollectionAmendantRecord mwCollectionAmendantRecord = mwCollectionAmendantRecordService.getById(id);
		if(mwCollectionAmendantRecord==null) {
			result.error500("未找到对应实体");
		}else {
			result.setResult(mwCollectionAmendantRecord);
			result.setSuccess(true);
		}
		return result;
	}


	 @GetMapping(value = "/listHistory")
	 @ApiOperation(value = "医废修改记录列表", notes = "医废修改记录列表", produces = "application/json")
	 public Result<IPage<MwCollectionAmendantRecordVO>> listHistory(MwCollectRecordOpsDTO dto, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize) {

		 dto.setAuditStatus(MedicalWasteEnum.MedicalWasteAuditStatusEnum.PASS.getStatus());
		 dto.setDelFlag(CommonConstant.DEL_FLAG_0);
		 //
		 IPage<MwCollectionAmendantRecordVO> pageList = mwCollectionAmendantRecordService.queryPageCollectList(pageNo, pageSize, dto);
		 return Result.ok(pageList);
	 }

	 /*=====医废追溯导出--开始=======*/
	 private static Map<String, String> headerMapListHistory = new LinkedHashMap<>();

	 static {
		 headerMapListHistory.put("createTime", "收集时间");
		 headerMapListHistory.put("code", "废物编号");
		 headerMapListHistory.put("hospitalName", "医院名称");
		 headerMapListHistory.put("departmentName", "科室名称");
		 /*headerMapListHistory.put("wasteTypeStr", "废物类型");
		 headerMapListHistory.put("weight", "重量(kg)");*/
		 headerMapListHistory.put("departmentUserName", "科室人员");
		 headerMapListHistory.put("creator", "收集人员");
		 headerMapListHistory.put("statusName", "状态");
		 headerMapListHistory.put("typeName", "修改内容");
		 headerMapListHistory.put("contentBefore", "修改前");
		 headerMapListHistory.put("contentAfter", "修改后");
	 }

	 @Data
	 private static class MwCollectRecordExportListHistoryVO {

		 private String createTime="";

		 private String code="";

		 private String hospitalName="";

		 private String departmentName="";

		 /*private String wasteTypeStr="";

		 private String weight="";*/

		 private String departmentUserName="";

		 private String creator="";

		 private String statusName="";
		 private String typeName="";
		 private String contentBefore="";
		 private String contentAfter="";

	 }

	 @GetMapping("/listHistoryExport")
	 @OpenApi
	 @ApiOperation(value = "医废修改导出", notes = "医废修改导出", produces = "application/json")
	 public void listHistoryExport(HttpServletResponse response, MwCollectRecordOpsDTO dto) throws IOException {
		 dto.setAuditStatus(MedicalWasteEnum.MedicalWasteAuditStatusEnum.PASS.getStatus());
		 dto.setDelFlag(CommonConstant.DEL_FLAG_0);
		 List<MwCollectionAmendantRecordVO> list=mwCollectionAmendantRecordService.queryPageCollectList( dto);
		 List<MwCollectionAmendantRecordController.MwCollectRecordExportListHistoryVO> voList = new ArrayList<>();
		 for (MwCollectionAmendantRecordVO collectRecordVO : list) {
			 MwCollectionAmendantRecordController.MwCollectRecordExportListHistoryVO vo=new MwCollectionAmendantRecordController.MwCollectRecordExportListHistoryVO();
			 BeanUtils.copyProperties(collectRecordVO, vo);
			 vo.setCreateTime(DateUtil.formatTime(collectRecordVO.getCreateTime(), "yyyy-MM-dd HH:mm:ss"));
			 //状态1新增 2已入库 3已出库
			 if (collectRecordVO.getStatus().equals(1)) {
				 vo.setStatusName("未入库");
			 } else if (collectRecordVO.getStatus().equals(2)) {
				 vo.setStatusName("已入库");
			 } else if (collectRecordVO.getStatus().equals(3)) {
				 vo.setStatusName("已出库");
			 }
			 if(collectRecordVO.getType().equals(1)){
				 vo.setTypeName("修改废物类型");
			 } else if (collectRecordVO.getType().equals(2)) {
				 vo.setTypeName("修改重量");
			 } else if (collectRecordVO.getType().equals(3)) {
				 vo.setTypeName("删除数据");
			 }
			 voList.add(vo);
		 }
		 ExcelWriter writer = ExcelUtil.getWriter(true);
		 writer.renameSheet("数据修改记录");
		 writer.setColumnWidth(0, 30);
		 writer.setColumnWidth(1, 30);
		 writer.setColumnWidth(2, 30);
		 writer.setColumnWidth(3, 30);
		 writer.setColumnWidth(4, 30);
		 writer.setColumnWidth(5, 30);
		 writer.setColumnWidth(6, 30);
		 writer.setColumnWidth(7, 30);
		 writer.setColumnWidth(8, 30);
		 writer.setColumnWidth(9, 30);
		 writer.setHeaderAlias(headerMapListHistory);
		 writer.write(voList);
		 //
		 String fileName = "数据修改记录";
		 response.setContentType("application/octet-stream;charset=utf-8");
		 response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8") + ".xlsx");
		 //response.setContentType("application/octet-stream"); // 响应内容格式
		 writer.flush(response.getOutputStream());
		 writer.close();

	 }

}