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.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.MwDetectionIndex;
import cn.besteam.modules.medical.service.IMwDetectionIndexService;
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-09-02
 * @version： V1.0
 */
@RestController
@RequestMapping("/medical/mwDetectionIndex")
@Slf4j
@Api(description = "检测指标")
public class MwDetectionIndexController {

	@Autowired
	private IMwDetectionIndexService mwDetectionIndexService;
	
	/**
	  * 分页列表查询
	 * @param mwDetectionIndex
	 * @param pageNo
	 * @param pageSize
	 * @param req
	 * @return
	 */
	@GetMapping(value = "/list")
	@ApiOperation(value = "获取检测指标数据列表", notes = "获取所有检测指标数据列表", produces = "application/json")
	public Result<IPage<MwDetectionIndex>> queryPageList(MwDetectionIndex mwDetectionIndex, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) {

		Result<IPage<MwDetectionIndex>> result = new Result<IPage<MwDetectionIndex>>();
		QueryWrapper<MwDetectionIndex> queryWrapper = new QueryWrapper<MwDetectionIndex>();
		Page<MwDetectionIndex> page = new Page<MwDetectionIndex>(pageNo, pageSize);
		//排序逻辑 处理
		String column = req.getParameter("column");
		String order = req.getParameter("order");
		queryWrapper.eq("del_flag",CommonConstant.DEL_FLAG_0);
		if(oConvertUtils.isNotEmpty(column) && oConvertUtils.isNotEmpty(order)) {
			if("asc".equals(order)) {
				queryWrapper.orderByAsc(oConvertUtils.camelToUnderline(column));
			}else {
				queryWrapper.orderByDesc(oConvertUtils.camelToUnderline(column));
			}
		}
		if(oConvertUtils.isNotEmpty(mwDetectionIndex.getName()) ){
			queryWrapper.like("name",mwDetectionIndex.getName());
		}
		if(oConvertUtils.isNotEmpty(mwDetectionIndex.getCode()) ){
			queryWrapper.like("code",mwDetectionIndex.getCode());
		}
		if(oConvertUtils.isNotEmpty(mwDetectionIndex.getConcentrationUnit()) ){
			queryWrapper.like("concentration_unit",mwDetectionIndex.getConcentrationUnit());
		}
		IPage<MwDetectionIndex> pageList = mwDetectionIndexService.page(page, queryWrapper);
		result.setSuccess(true);
		result.setResult(pageList);
		return result;
	}
	
	/**
	  *   添加
	 * @param mwDetectionIndex
	 * @return
	 */
	@PostMapping(value = "/add")
	@AutoLog(value = "添加检测指标")
	@ApiOperation(value = "添加检测指标", notes = "添加检测指标", produces = "application/json")
	public Result<MwDetectionIndex> add(@RequestBody MwDetectionIndex mwDetectionIndex) {

		Result<MwDetectionIndex> result = new Result<MwDetectionIndex>();
		try {
			mwDetectionIndexService.save(mwDetectionIndex);
			result.success("添加成功！");
		} catch (Exception e) {
			result.error500("操作失败");
		}
		return result;
	}
	
	/**
	  *  编辑
	 * @param mwDetectionIndex
	 * @return
	 */
	@PostMapping(value = "/edit")
	@AutoLog(value = "编辑检测指标")
	@ApiOperation(value = "编辑检测指标", notes = "编辑检测指标", produces = "application/json")
	public Result<MwDetectionIndex> edit(@RequestBody MwDetectionIndex mwDetectionIndex) {

		Result<MwDetectionIndex> result = new Result<MwDetectionIndex>();
		MwDetectionIndex mwDetectionIndexEntity = mwDetectionIndexService.getById(mwDetectionIndex.getId());
		if(mwDetectionIndexEntity==null) {
			result.error500("未找到对应实体");
		}else {
			boolean ok = mwDetectionIndexService.updateById(mwDetectionIndex);
			//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<MwDetectionIndex> delete(@RequestParam(name="id",required=true) String id) {

		Result<MwDetectionIndex> result = new Result<MwDetectionIndex>();
		MwDetectionIndex mwDetectionIndex = mwDetectionIndexService.getById(id);
		if(mwDetectionIndex==null) {
			result.error500("未找到对应实体");
		}else {
			boolean ok = mwDetectionIndexService.removeById(id);
			if(ok) {
				result.success("删除成功!");
			}
		}
		
		return result;
	}
	
	/**
	  *  批量删除
	 * @param ids
	 * @return
	 */
	@PostMapping(value = "/deleteBatch")
	@AutoLog(value = "批量删除检测指标")
	@ApiOperation(value = "批量删除检测指标", notes = "批量删除检测指标", produces = "application/json")
	public Result<MwDetectionIndex> deleteBatch(@RequestParam(name="ids",required=true) String ids) {

		Result<MwDetectionIndex> result = new Result<MwDetectionIndex>();
		if(ids==null || "".equals(ids.trim())) {
			result.error500("参数不识别！");
		}else {
			this.mwDetectionIndexService.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<MwDetectionIndex> queryById(@RequestParam(name="id",required=true) String id) {

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

	 /*=====检测指标导出--开始=======*/
	 private static Map<String, String> headerMapList = new LinkedHashMap<>();

	 static {
		 headerMapList.put("name", "指标名称");
		 headerMapList.put("code", "指标编号");
		 headerMapList.put("concentrationUnit", "浓度单位");
		 headerMapList.put("maxNum", "上限值");
		 headerMapList.put("minNum", "下限值");
		 headerMapList.put("cumulativeUnit", "累计值单位");
	 }

	 @Data
	 private static class MwDetectionIndexExportListVO {

		 private String name;

		 private String code;

		 private String concentrationUnit;

		 private String maxNum;

		 private String minNum;

		 private String cumulativeUnit;


	 }

	 @GetMapping("/listExport")
	 @OpenApi
	 @ApiOperation(value = "检测指标导出", notes = "检测指标导出", produces = "application/json")
	 public void listExport(HttpServletResponse response, MwDetectionIndex mwDetectionIndex) throws IOException {

		 QueryWrapper<MwDetectionIndex> queryWrapper = new QueryWrapper<MwDetectionIndex>();
	 	queryWrapper.eq("del_flag",CommonConstant.DEL_FLAG_0);
		 if(oConvertUtils.isNotEmpty(mwDetectionIndex.getName()) ){
			 queryWrapper.like("name",mwDetectionIndex.getName());
		 }
		 if(oConvertUtils.isNotEmpty(mwDetectionIndex.getCode()) ){
			 queryWrapper.like("code",mwDetectionIndex.getCode());
		 }
		 if(oConvertUtils.isNotEmpty(mwDetectionIndex.getConcentrationUnit()) ){
			 queryWrapper.like("concentrationUnit",mwDetectionIndex.getConcentrationUnit());
		 }
		 List<MwDetectionIndex> list = mwDetectionIndexService.list( queryWrapper);
		 List<MwDetectionIndexController.MwDetectionIndexExportListVO> voList = new ArrayList<>();
		 for (MwDetectionIndex collectRecordVO : list) {
			 MwDetectionIndexController.MwDetectionIndexExportListVO vo=new MwDetectionIndexController.MwDetectionIndexExportListVO();
			 BeanUtils.copyProperties(collectRecordVO, vo);
			 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.setHeaderAlias(headerMapList);
		 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");
		 writer.flush(response.getOutputStream());
		 writer.close();

	 }
	 /*=====检测指标导出--结尾=======*/

}