package cn.com.lzt.useractiviti.wagechange.controller;

import cn.com.lzt.common.util.DictUtil;
import cn.com.lzt.common.util.LztUtil;
import cn.com.lzt.common.view.JsonDataModelAndView;
import cn.com.lzt.useractiviti.data.controller.ActivitiToolsController;
import cn.com.lzt.useractiviti.data.util.ActivitiPdfExport;
import cn.com.lzt.useractiviti.data.util.ActivitiTools;
import cn.com.lzt.useractiviti.wagechange.entity.TBusActivitiWageChangeEntity;
import cn.com.lzt.useractiviti.wagechange.entity.TBusActivitiWageChangePage;
import cn.com.lzt.useractiviti.wagechange.service.TBusActivitiWageChangeServiceI;
import cn.com.lzt.userwage.dao.UserWageMinidaoDao;
import cn.com.lzt.userwage.dto.UserWageDto;
import com.lowagie.text.pdf.PdfPCell;
import com.lowagie.text.pdf.PdfPTable;
import com.jeecg.qianbao.util.FormProcUtil;
import com.xcgl.weixin.entity.WXAjaxJson;
import org.apache.commons.lang3.StringUtils;
import org.apache.log4j.Logger;
import org.hibernate.criterion.Restrictions;
import org.jeecgframework.core.beanvalidator.BeanValidators;
import org.jeecgframework.core.common.exception.BusinessException;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.AjaxJson;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.*;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.web.system.pojo.base.TSRole;
import org.jeecgframework.web.system.pojo.base.TSRoleUser;
import org.jeecgframework.web.system.pojo.base.TSUser;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.util.UriComponentsBuilder;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.ConstraintViolation;
import javax.validation.Validator;
import java.io.IOException;
import java.math.BigDecimal;
import java.net.URI;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * @author onlineGenerator
 * @version V1.0
 * @Title: Controller
 * @Description: 薪资调整
 * @date 2019-10-22 12:57:51
 */
@Controller
@RequestMapping("/tBusActivitiWageChangeController")
public class TBusActivitiWageChangeController extends ActivitiToolsController {
    /**
     * Logger for this class
     */
    private static final Logger logger = Logger.getLogger(TBusActivitiWageChangeController.class);

    @Autowired
    private TBusActivitiWageChangeServiceI tBusActivitiWageChangeService;
    @Autowired
    private SystemService systemService;
    @Autowired
    private Validator validator;

    @Autowired
    private UserWageMinidaoDao userWageMinidaoDao;


    /**
     * 薪资调整列表 页面跳转
     *
     * @return
     */
    @RequestMapping(params = "list")
    public ModelAndView list(HttpServletRequest request) {
        return new ModelAndView("cn/com/lzt/useractiviti/wagechange/tBusActivitiWageChangeList");
    }

    /**
     * easyui AJAX请求数据
     *
     * @param request
     * @param response
     * @param dataGrid
     */

    @RequestMapping(params = "datagrid")
    public void datagrid(TBusActivitiWageChangeEntity tBusActivitiWageChange, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
        CriteriaQuery cq = new CriteriaQuery(TBusActivitiWageChangeEntity.class, dataGrid);
        //查询条件组装器
        org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tBusActivitiWageChange, request.getParameterMap());
        try {
            //自定义追加查询条件
            TSUser user = ResourceUtil.getSessionUser();
            cq.add(Restrictions.eq("createBy", user.getUserName()));
        } catch (Exception e) {
            throw new BusinessException(e.getMessage());
        }
        cq.add();
        this.tBusActivitiWageChangeService.getDataGridReturn(cq, true);
        TagUtil.datagrid(response, dataGrid);
    }

    /**
     * 删除薪资调整
     *
     * @return
     */
    @RequestMapping(params = "doDel")
    @ResponseBody
    public AjaxJson doDel(TBusActivitiWageChangeEntity tBusActivitiWageChange, HttpServletRequest request) {
        String message = null;
        AjaxJson j = new AjaxJson();
        tBusActivitiWageChange = systemService.getEntity(TBusActivitiWageChangeEntity.class, tBusActivitiWageChange.getId());
        message = "薪资调整删除成功";
        try {
            tBusActivitiWageChangeService.delete(tBusActivitiWageChange);
            systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
        } catch (Exception e) {
            e.printStackTrace();
            message = "薪资调整删除失败";
            throw new BusinessException(e.getMessage());
        }
        j.setMsg(message);
        return j;
    }

    /**
     * 批量删除薪资调整
     *
     * @return
     */
    @RequestMapping(params = "doBatchDel")
    @ResponseBody
    public AjaxJson doBatchDel(String ids, HttpServletRequest request) {
        String message = null;
        AjaxJson j = new AjaxJson();
        message = "薪资调整删除成功";
        try {
            for (String id : ids.split(",")) {
                TBusActivitiWageChangeEntity tBusActivitiWageChange = systemService.getEntity(TBusActivitiWageChangeEntity.class,
                        id
                );
                tBusActivitiWageChangeService.delete(tBusActivitiWageChange);
                systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
            }
        } catch (Exception e) {
            e.printStackTrace();
            message = "薪资调整删除失败";
            throw new BusinessException(e.getMessage());
        }
        j.setMsg(message);
        return j;
    }


    /**
     * 添加薪资调整
     *
     * @return
     */
    @RequestMapping(params = "doAdd")
    @ResponseBody
    public AjaxJson doAdd(TBusActivitiWageChangeEntity tBusActivitiWageChange, HttpServletRequest request) {
        if (StringUtils.isNotBlank(tBusActivitiWageChange.getId())) {
            return doUpdate(tBusActivitiWageChange, request);
        }
        String message = null;
        AjaxJson j = new AjaxJson();
        message = "薪资调整添加成功";
        try {
            tBusActivitiWageChangeService.save(tBusActivitiWageChange);
            systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
        } catch (Exception e) {
            e.printStackTrace();
            message = "薪资调整添加失败";
            throw new BusinessException(e.getMessage());
        }
        j.setMsg(message);
        return j;
    }

    @ResponseBody
    @RequestMapping(params = "doAddList")
    public AjaxJson doAddList(TBusActivitiWageChangePage tBusActivitiWageChangePage, HttpServletRequest request) {
        AjaxJson j = new AjaxJson();
        String message = "薪资调整添加成功";
        List<TBusActivitiWageChangeEntity> lists = tBusActivitiWageChangePage.getTBusActivitiWageChangeEntityList();
        try {
            for (TBusActivitiWageChangeEntity list : lists) {
                tBusActivitiWageChangeService.save(list);
            }
            systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
        } catch (Exception e) {
            e.printStackTrace();
            message = "薪资调整添加失败";
            throw new BusinessException(e.getMessage());
        }
        j.setMsg(message);
        return j;
    }

    /**
     * 更新薪资调整
     *
     * @return
     */
    @RequestMapping(params = "doUpdate")
    @ResponseBody
    public AjaxJson doUpdate(TBusActivitiWageChangeEntity tBusActivitiWageChange, HttpServletRequest request) {
        String message = null;
        AjaxJson j = new AjaxJson();
        message = "薪资调整更新成功";
        TBusActivitiWageChangeEntity t = tBusActivitiWageChangeService.get(TBusActivitiWageChangeEntity.class, tBusActivitiWageChange.getId());
        try {
            MyBeanUtils.copyBeanNotNull2Bean(tBusActivitiWageChange, t);
            tBusActivitiWageChangeService.saveOrUpdate(t);
            systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
        } catch (Exception e) {
            e.printStackTrace();
            message = "薪资调整更新失败";
            throw new BusinessException(e.getMessage());
        }
        j.setMsg(message);
        return j;
    }

    /**
     * @author: 许宛东
     * @methodsName: judgeUserRole
     * @description: 判断当前登录用户是否有对应角色
     * @param: role 角色
     * @return: boolean
     * @throws:
     */
    public boolean judgeUserRole(String[] role) {
        TSUser sessionUser = ResourceUtil.getSessionUser();
        boolean temp = false;
        List<TSRoleUser> tSRoleUser = systemService.findByProperty(TSRoleUser.class, "TSUser.id", sessionUser.getId());
        if (!tSRoleUser.isEmpty()) {
            for (TSRoleUser tsRoleUser2 : tSRoleUser) {
                TSRole userRole = tsRoleUser2.getTSRole();
                for (int i = 0; i < role.length; i++) {
                    if (role[i].equals(userRole.getRoleCode())) {
                        temp = true;
                        break;
                    }
                }
                if (temp) {
                    break;
                }
            }
        }
        return temp;
    }

    /**
     * 薪资调整新增页面跳转
     *
     * @return
     */
    @RequestMapping(params = "goAdd")
    public ModelAndView goAdd(TBusActivitiWageChangeEntity tBusActivitiWageChange, HttpServletRequest req) {
        String[] userRole = {"A_HRJL", "A_HRZL"};
        req.setAttribute("getPersonnelManager", this.judgeUserRole(userRole));
        if (StringUtil.isNotEmpty(tBusActivitiWageChange.getId())) {
            tBusActivitiWageChange = tBusActivitiWageChangeService.getEntity(TBusActivitiWageChangeEntity.class, tBusActivitiWageChange.getId());
            req.setAttribute("tBusActivitiWageChangePage", tBusActivitiWageChange);
        }
        return new ModelAndView("cn/com/lzt/useractiviti/wagechange/tBusActivitiWageChange-newAdd");
        //return new ModelAndView("cn/com/lzt/useractiviti/wagechange/tBusActivitiWageChange-add");
    }

    /**
     * 薪资调整编辑页面跳转
     *
     * @return
     */
    @RequestMapping(params = "goUpdate")
    public ModelAndView goUpdate(TBusActivitiWageChangeEntity tBusActivitiWageChange, HttpServletRequest req) {
        String[] userRole = {"A_HRJL", "A_HRZL"};
        req.setAttribute("getPersonnelManager", this.judgeUserRole(userRole));
        if (StringUtil.isNotEmpty(tBusActivitiWageChange.getId())) {
            tBusActivitiWageChange = tBusActivitiWageChangeService.getEntity(TBusActivitiWageChangeEntity.class, tBusActivitiWageChange.getId());
            req.setAttribute("entity", tBusActivitiWageChange);
        }
        return new ModelAndView("cn/com/lzt/useractiviti/wagechange/tBusActivitiWageChange-update");
        //return new ModelAndView("cn/com/lzt/useractiviti/wagechange/tBusActivitiWageChange-add");
    }

    /**
     * 导入功能跳转
     *
     * @return
     */
    @RequestMapping(params = "upload")
    public ModelAndView upload(HttpServletRequest req) {
        req.setAttribute("controller_name", "tBusActivitiWageChangeController");
        return new ModelAndView("common/upload/pub_excel_upload");
    }

    /**
     * 导出excel
     *
     * @param request
     * @param response
     */
    @RequestMapping(params = "exportXls")
    public String exportXls(TBusActivitiWageChangeEntity tBusActivitiWageChange, HttpServletRequest request, HttpServletResponse response
            , DataGrid dataGrid, ModelMap modelMap) {
        CriteriaQuery cq = new CriteriaQuery(TBusActivitiWageChangeEntity.class, dataGrid);
        org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tBusActivitiWageChange, request.getParameterMap());
        List<TBusActivitiWageChangeEntity> tBusActivitiWageChanges = this.tBusActivitiWageChangeService.getListByCriteriaQuery(cq, false);
        modelMap.put(NormalExcelConstants.FILE_NAME, "薪资调整");
        modelMap.put(NormalExcelConstants.CLASS, TBusActivitiWageChangeEntity.class);
        modelMap.put(NormalExcelConstants.PARAMS, new ExportParams("薪资调整列表", "导出人:" + ResourceUtil.getSessionUser().getRealName(),
                "导出信息"));
        modelMap.put(NormalExcelConstants.DATA_LIST, tBusActivitiWageChanges);
        return NormalExcelConstants.JEECG_EXCEL_VIEW;
    }

    /**
     * 导出excel 使模板
     *
     * @param request
     * @param response
     */
    @RequestMapping(params = "exportXlsByT")
    public String exportXlsByT(TBusActivitiWageChangeEntity tBusActivitiWageChange, HttpServletRequest request, HttpServletResponse response
            , DataGrid dataGrid, ModelMap modelMap) {
        modelMap.put(NormalExcelConstants.FILE_NAME, "薪资调整");
        modelMap.put(NormalExcelConstants.CLASS, TBusActivitiWageChangeEntity.class);
        modelMap.put(NormalExcelConstants.PARAMS, new ExportParams("薪资调整列表", "导出人:" + ResourceUtil.getSessionUser().getRealName(),
                "导出信息"));
        modelMap.put(NormalExcelConstants.DATA_LIST, new ArrayList());
        return NormalExcelConstants.JEECG_EXCEL_VIEW;
    }

    @SuppressWarnings("unchecked")
    @RequestMapping(params = "importExcel", method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
        AjaxJson j = new AjaxJson();

        MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
        Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
        for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
            MultipartFile file = entity.getValue();// 获取上传文件对象
            ImportParams params = new ImportParams();
            params.setTitleRows(2);
            params.setHeadRows(1);
            params.setNeedSave(true);
            try {
                List<TBusActivitiWageChangeEntity> listTBusActivitiWageChangeEntitys = ExcelImportUtil.importExcel(file.getInputStream(), TBusActivitiWageChangeEntity.class, params);
                for (TBusActivitiWageChangeEntity tBusActivitiWageChange : listTBusActivitiWageChangeEntitys) {
                    tBusActivitiWageChangeService.save(tBusActivitiWageChange);
                }
                j.setMsg("文件导入成功！");
            } catch (Exception e) {
                j.setMsg("文件导入失败！");
                logger.error(ExceptionUtil.getExceptionMessage(e));
            } finally {
                try {
                    file.getInputStream().close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        return j;
    }

    @RequestMapping(method = RequestMethod.GET)
    @ResponseBody
    public List<TBusActivitiWageChangeEntity> list() {
        List<TBusActivitiWageChangeEntity> listTBusActivitiWageChanges = tBusActivitiWageChangeService.getList(TBusActivitiWageChangeEntity.class);
        return listTBusActivitiWageChanges;
    }

    @RequestMapping(value = "/{id}", method = RequestMethod.GET)
    @ResponseBody
    public ResponseEntity<?> get(@PathVariable("id") String id) {
        TBusActivitiWageChangeEntity task = tBusActivitiWageChangeService.get(TBusActivitiWageChangeEntity.class, id);
        if (task == null) {
            return new ResponseEntity(HttpStatus.NOT_FOUND);
        }
        return new ResponseEntity(task, HttpStatus.OK);
    }

    @RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE)
    @ResponseBody
    public ResponseEntity<?> create(@RequestBody TBusActivitiWageChangeEntity tBusActivitiWageChange, UriComponentsBuilder uriBuilder) {
        //调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
        Set<ConstraintViolation<TBusActivitiWageChangeEntity>> failures = validator.validate(tBusActivitiWageChange);
        if (!failures.isEmpty()) {
            return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
        }

        //保存
        try {
            tBusActivitiWageChangeService.save(tBusActivitiWageChange);
        } catch (Exception e) {
            e.printStackTrace();
            return new ResponseEntity(HttpStatus.NO_CONTENT);
        }
        //按照Restful风格约定，创建指向新任务的url, 也可以直接返回id或对象.
        String id = tBusActivitiWageChange.getId();
        URI uri = uriBuilder.path("/rest/tBusActivitiWageChangeController/" + id).build().toUri();
        HttpHeaders headers = new HttpHeaders();
        headers.setLocation(uri);

        return new ResponseEntity(headers, HttpStatus.CREATED);
    }

    @RequestMapping(value = "/{id}", method = RequestMethod.PUT, consumes = MediaType.APPLICATION_JSON_VALUE)
    public ResponseEntity<?> update(@RequestBody TBusActivitiWageChangeEntity tBusActivitiWageChange) {
        //调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
        Set<ConstraintViolation<TBusActivitiWageChangeEntity>> failures = validator.validate(tBusActivitiWageChange);
        if (!failures.isEmpty()) {
            return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
        }

        //保存
        try {
            tBusActivitiWageChangeService.saveOrUpdate(tBusActivitiWageChange);
        } catch (Exception e) {
            e.printStackTrace();
            return new ResponseEntity(HttpStatus.NO_CONTENT);
        }

        //按Restful约定，返回204状态码, 无内容. 也可以返回200状态码.
        return new ResponseEntity(HttpStatus.NO_CONTENT);
    }

    @RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
    @ResponseStatus(HttpStatus.NO_CONTENT)
    public void delete(@PathVariable("id") String id) {
        tBusActivitiWageChangeService.deleteEntityById(TBusActivitiWageChangeEntity.class, id);
    }

    //审批
    @RequestMapping(params = "goView")
    public ModelAndView goView(TBusActivitiWageChangeEntity entity, HttpServletRequest req) {
        String userid = "";
        if (StringUtil.isNotEmpty(entity.getId())) {
            entity = tBusActivitiWageChangeService.getEntity(TBusActivitiWageChangeEntity.class, entity.getId());
            req.setAttribute("entity", entity);
        }

        String taskId = oConvertUtils.getString(req.getParameter("taskId"));
        if (oConvertUtils.isNotEmpty(taskId)) {
            FormProcUtil.initWorkflowParam(req);
            req.setAttribute("taskId", taskId);
        }

        req.setAttribute("in_process", true);

        return new ModelAndView("cn/com/lzt/useractiviti/wagechange/tBusActivitiWageChange-add");
    }

    //手机审批
    @RequestMapping(params = "goViewMobile")
    public ModelAndView goViewMobile(TBusActivitiWageChangeEntity entity, HttpServletRequest req) {
        goView(entity, req);
        entity = (TBusActivitiWageChangeEntity) req.getAttribute("entity");
        String wagechangeType = DictUtil.formatToTypeName(entity.getType(), "wagechange_type");
        Map<String, Object> data = LztUtil.copyReqAttributes(new String[]{
                "entity"});
        data.put("wagechangeType", wagechangeType);
        return new JsonDataModelAndView(WXAjaxJson.success(data));
//		return new ModelAndView("cn/com/lzt/useractiviti/wagechange/wageChange_view_mobile");
    }

    @RequestMapping(params = "goWage")
    public ModelAndView goWage(TBusActivitiWageChangeEntity entity, HttpServletRequest req) {
        return new ModelAndView("cn/com/lzt/useractiviti/wagechange/user_wage");
    }

    @RequestMapping(params = "datagridWage")
    public void datagridWage(UserWageDto userWage, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) throws ParseException {
        List<UserWageDto> list = getUserWageHistory(userWage.getUserid(), 3);
        dataGrid.setResults(list);
        TagUtil.datagrid(response, dataGrid);
    }

    private List<UserWageDto> getUserWageHistory(String userId, int showLastMonth) {
        Calendar now = Calendar.getInstance();
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM");
        now.add(Calendar.MONTH, -1);
        String endMonth = format.format(now.getTime());
        now.add(Calendar.MONTH, -showLastMonth);
        String startMonth = format.format(now.getTime());
        List<UserWageDto> list = userWageMinidaoDao.getUserWage(userId, startMonth, endMonth);
        return list;
    }

    @RequestMapping(params = "exportDetailPdf4Mobile")
    public void exportDetailPdf4Mobile(@RequestParam("procInstId") String procInstId, HttpServletResponse response) {
        ActivitiTools tools = ActivitiTools.getInstance(procInstId, true);
        ActivitiPdfExport pdfExport = tools.getPdfExport();
        exportPdf(pdfExport, tools.getBusId());
        pdfExport.procInstId(null);
        tools.exportToResponse(response);
    }

    private void exportPdf(ActivitiPdfExport pdfExport, String id) {
        TBusActivitiWageChangeEntity entity = systemService.getEntity(TBusActivitiWageChangeEntity.class, id);
        pdfExport
                .table()
                .cell("申请人", entity.getCreateName())
                .cell("员工", entity.getRealName())
                .cell("项目", entity.getDepName())
                .cell("薪资调整类型", DictUtil.formatToTypeName(entity.getType(), "wagechange_type"))
                .cell("薪资调整说明", entity.getRemark());
        List<UserWageDto> list = getUserWageHistory(entity.getUserid(), 3);
        PdfPCell cellWageTitle = ActivitiPdfExport.createCell("近三月工资详情");
        cellWageTitle.setColspan(2);
        pdfExport.cell(cellWageTitle);
        if (list.size() > 0) {
            for (UserWageDto dto : list) {
                pdfExport.cell(dto.getMonthly());//工资月度
                PdfPTable detailTable1 = pdfExport.createTable(5);
                pdfExport.titleCell(detailTable1, "员工工号", "员工姓名", "所属单位", "身份证号", "职务");
                pdfExport.cell(detailTable1, dto.getUsername(), false);
                pdfExport.cell(detailTable1, dto.getRealname(), false);
                pdfExport.cell(detailTable1, dto.getBelongUnitName(), false);
                pdfExport.cell(detailTable1, dto.getPduname(), false);
                pdfExport.cell(detailTable1, dto.getDuname(), false);

                pdfExport.titleCell(detailTable1, "开户银行", "工资卡号", "缴金单位", "基本工资", "职务津贴");
                pdfExport.cell(detailTable1, dto.getBelongBank(), false);
                pdfExport.cell(detailTable1, dto.getCardNumber(), false);
                pdfExport.cell(detailTable1, dto.getSocialSecurityUnit(), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getBasicWage()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getDutiesAllowance()), false);

                pdfExport.titleCell(detailTable1, "证书补贴", "交通补贴", "高温补贴", "独生子女费", "其他补贴");
                pdfExport.cell(detailTable1, getBigdecimal(dto.getCertificateSubsidy()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getTrafficSubsidy()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getMegathermalSubsidy()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getOnlyChildCost()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getOtherSubsidy()), false);

                pdfExport.titleCell(detailTable1, "奖金", "项目绩效", "餐补白班津贴", "餐补夜班津贴", "餐费补助");
                pdfExport.cell(detailTable1, getBigdecimal(dto.getBonus()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getProjectPerformance()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getMealsSubsidyDay()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getMealsSubsidyNight()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getMealsSubsidy()), false);

                pdfExport.titleCell(detailTable1, "加班超时费", "国定加班费", "值班费", "特殊加班费", "病假扣");
                pdfExport.cell(detailTable1, getBigdecimal(dto.getOvertimepayTimeout()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getOvertimepayFixed()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getDuty()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getSpecialOvertime()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getSickLeaveDebit()), false);

                pdfExport.titleCell(detailTable1, "事假扣", "缺勤扣", "代扣款", "其他扣除", "缴金补贴");
                pdfExport.cell(detailTable1, getBigdecimal(dto.getThingLeaveDebit()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getAbsenceDebit()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getDaikouDebit()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getOtherDebit()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getPaymentSubsidy()), false);

                pdfExport.titleCell(detailTable1, "补发调整", "应发金额", "社保扣除", "公积金扣除", "扣税金额");
                pdfExport.cell(detailTable1, getBigdecimal(dto.getReissue()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getPreTaxMone()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getSocialSecurityDebit()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getProvidentFundDebit()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getTaxMoney()), true);

                pdfExport.titleCell(detailTable1, "实发金额", "企业社保", "企业公积金", "企业成本合计", "备注说明");
                pdfExport.cell(detailTable1, getBigdecimal(dto.getActualMoney()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getComSocialSecurityDebit()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getComProvidentFundDebit()), false);
                pdfExport.cell(detailTable1, getBigdecimal(dto.getComCost()), false);
                pdfExport.cell(detailTable1, dto.getRemark(), false);
                ;
                pdfExport.cell(detailTable1);
            }
        }
    }

    private String getBigdecimal(BigDecimal bigDecimal) {
        if (bigDecimal == null) return BigDecimal.ZERO.toString();
        return bigDecimal.toString();
    }
}