SalaryManagementController.java

package cn.timer.api.controller.xcgl;

import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;

import javax.annotation.Resource;
import javax.script.ScriptEngine;
import javax.script.ScriptEngineManager;
import javax.script.ScriptException;

import cn.timer.api.dto.xcgl.*;
import com.google.common.collect.Lists;
import com.google.common.collect.Maps;
import lombok.SneakyThrows;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.validation.annotation.Validated;
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.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import cn.hutool.json.JSONObject;
import cn.timer.api.bean.kqgl.AttendanceGroup;
import cn.timer.api.bean.kqgl.AttendanceReport;
import cn.timer.api.bean.kqgl.AttendanceWeeklySch;
import cn.timer.api.bean.kqgl.PunchCardDetails;
import cn.timer.api.bean.kqgl.PunchRecord;
import cn.timer.api.bean.kqgl.Schedule;
import cn.timer.api.bean.kqgl.SpecialDate;
import cn.timer.api.bean.kqmk.KqglAssoDkjl;
import cn.timer.api.bean.kqmk.KqglAssoMonthPunchSummary;
import cn.timer.api.bean.kqmk.KqglAssoRelationSummary;
import cn.timer.api.bean.sbgjj.SbgjjAssoDetailed;
import cn.timer.api.bean.sbgjj.SbgjjAssoYjzd;
import cn.timer.api.bean.xcgl.XcglAdminXzz;
import cn.timer.api.bean.xcgl.XcglAssoBszqsz;
import cn.timer.api.bean.xcgl.XcglAssoGsjsmx;
import cn.timer.api.bean.xcgl.XcglAssoGztsz;
import cn.timer.api.bean.xcgl.XcglAssoGztzt;
import cn.timer.api.bean.xcgl.XcglAssoJsgzzx;
import cn.timer.api.bean.xcgl.XcglAssoJxgz;
import cn.timer.api.bean.xcgl.XcglAssoOption;
import cn.timer.api.bean.xcgl.XcglAssoTaxFormula;
import cn.timer.api.bean.xcgl.XcglAssoXcjsgz;
import cn.timer.api.bean.xcgl.XcglAssoXzb;
import cn.timer.api.bean.xcgl.XcglAssoXzdadx;
import cn.timer.api.bean.xcgl.XcglAssoXzdaz;
import cn.timer.api.bean.xcgl.XcglAssoXzdazdy;
import cn.timer.api.bean.xcgl.XcglAssoXzury;
import cn.timer.api.bean.xcgl.XcglAssoZxfjkc;
import cn.timer.api.bean.yggl.YgglMainEmp;
import cn.timer.api.config.annotation.CurrentUser;
import cn.timer.api.config.annotation.UserBean;
import cn.timer.api.config.validation.ValidList;
import cn.timer.api.controller.kqgl.ClockInTool;
import cn.timer.api.dao.kqgl.AttendanceGroupMapper;
import cn.timer.api.dao.kqgl.AttendanceWeeklySchMapper;
import cn.timer.api.dao.kqgl.PunchCardDetailsMapper;
import cn.timer.api.dao.kqgl.PunchRecordMapper;
import cn.timer.api.dao.kqgl.ScheduleMapper;
import cn.timer.api.dao.kqgl.SpecialDateMapper;
import cn.timer.api.dao.kqmk.KqglAssoDkjlMapper;
import cn.timer.api.dao.kqmk.KqglAssoMonthPunchSummaryMapper;
import cn.timer.api.dao.kqmk.KqglAssoRelationSummaryMapper;
import cn.timer.api.dao.sbgjj.SbgjjAssoDetailedMapper;
import cn.timer.api.dao.sbgjj.SbgjjAssoYjzdMapper;
import cn.timer.api.dao.xcgl.XcglAdminXzzMapper;
import cn.timer.api.dao.xcgl.XcglAssoGsjsmxMapper;
import cn.timer.api.dao.xcgl.XcglAssoGztszMapper;
import cn.timer.api.dao.xcgl.XcglAssoGztztMapper;
import cn.timer.api.dao.xcgl.XcglAssoJsgzzxMapper;
import cn.timer.api.dao.xcgl.XcglAssoJxgzMapper;
import cn.timer.api.dao.xcgl.XcglAssoOptionMapper;
import cn.timer.api.dao.xcgl.XcglAssoXcjsgzMapper;
import cn.timer.api.dao.xcgl.XcglAssoXzbMapper;
import cn.timer.api.dao.xcgl.XcglAssoXzdadxMapper;
import cn.timer.api.dao.xcgl.XcglAssoXzdazMapper;
import cn.timer.api.dao.xcgl.XcglAssoXzdazdyMapper;
import cn.timer.api.dao.xcgl.XcglAssoXzuryMapper;
import cn.timer.api.dao.xcgl.XcglAssoZxfjkcMapper;
import cn.timer.api.dao.xcgl.XcglSalaryItemMapper;
import cn.timer.api.dao.yggl.YgglMainEmpMapper;
import cn.timer.api.dto.kqmk.CalculatingCompensationDto;
import cn.timer.api.dto.sbgjj.InspersonnelDto;
import cn.timer.api.utils.DateUtil;
import cn.timer.api.utils.ResponseResult;
import cn.timer.api.utils.Result;
import cn.timer.api.utils.ResultUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;

@Api(tags = "薪酬管理Api")
@RestController
@RequestMapping(value = "/sala", produces = { "application/json" })
public class SalaryManagementController {
	
	@Value("${config-8timer.prescription}")
	public double prescription; // 一天工作小时数
	
	// 薪酬管理-定薪
	@Autowired
	private XcglAssoXzdadxMapper xcglassoxzdadxmapper;

	// 薪资档案自定义
	@Autowired
	private XcglAssoXzdazdyMapper xcglassoxzdazdymapper;

	// 薪资档案值
	@Autowired
	private XcglAssoXzdazMapper xcglassoxzdazmapper;

	// 薪资组
	@Autowired
	private XcglAdminXzzMapper xcgladminxzzmapper;

	// 薪资组内人员
	@Autowired
	private XcglAssoXzuryMapper xcglassoxzurymapper;

	//计薪规则组项
	@Autowired
    private XcglAssoJsgzzxMapper xcglassojsgzzxmapper;
	
	//计薪规则组
	@Autowired
	private XcglAssoJxgzMapper xcglassojxgzmapper;
	
	//薪酬计算规则公式
	@Autowired
    private XcglAssoXcjsgzMapper xcglassoxcjsgzmapper;
	
	//薪资项名
	@Autowired
	private XcglSalaryItemMapper xcglsalaryitemmapper;
	
	//薪资选项
	@Autowired
	private XcglAssoOptionMapper xcglassooptionmapper;
	
	//薪资表
	@Autowired
	private XcglAssoXzbMapper xcglassoxzbmapper;
	
	@Resource
    private YgglMainEmpMapper ygglmainempmapper;
	
	
	//考勤组
	@Resource
	private AttendanceGroupMapper attendancegroupservice;
	//打卡明细表
	@Resource
	private PunchCardDetailsMapper punchcarddetailsservice;
	//打卡记录
	@Resource
	private PunchRecordMapper punchrecordservice;	
	@Resource
	private SpecialDateMapper specialdateservice;
	//考勤周排班
	@Resource
	private AttendanceWeeklySchMapper attendanceweeklyschservice;
	//排班明细
	@Resource
	private ScheduleMapper scheduleservice;
	//专项附加扣除
	@Resource
	private XcglAssoZxfjkcMapper xcglassozxfjkcmapper;
	
	//工资条组内成员状态
	@Resource
	private XcglAssoGztztMapper xcglassogztztmapper;
	//工资条组-设置
	@Resource
	private XcglAssoGztszMapper xcglassogztszmapper;
	
	static SimpleDateFormat mat = new SimpleDateFormat("yyyy-MM-dd");

	/**
	 * 获取薪资组信息
	 */
	@GetMapping(value = "/paylist/{yemon}")
	@ApiOperation(value = "获取薪资组信息", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult selectpaylist(@CurrentUser UserBean userBean,@PathVariable String yemon) {
		List<XcglAdminXzz> xcgladminxzz = new LambdaQueryChainWrapper<XcglAdminXzz>(xcgladminxzzmapper).eq(XcglAdminXzz::getQyid, userBean.getOrgCode()).eq(XcglAdminXzz::getMonthtime, yemon).list();
		return new ResponseResult().success("获取薪资组信息成功", xcgladminxzz);
	}
	
	/**
	 *	获取薪资组人员数据
	 */
	@GetMapping(value = "/paygroupdate/{id}")
	@ApiOperation(value = "获取薪资组人员数据", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult Getpaygroupstaff(@CurrentUser UserBean userBean,@PathVariable Integer id) {
		List<XcglAssoXzury> xzurylist = new LambdaQueryChainWrapper<XcglAssoXzury>(xcglassoxzurymapper).eq(XcglAssoXzury::getQyid, userBean.getOrgCode()).eq(XcglAssoXzury::getXzzid, id).list();
		return new ResponseResult().success("获取薪资组人员数据成功", xzurylist);
	}
	
	/**
	 *	获取薪资组数据
	 */
	@GetMapping(value = "/salarygroupdata/{id}")
	@ApiOperation(value = "获取薪资组数据", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult Salarygroupdata(@CurrentUser UserBean userBean,@PathVariable Integer id) {
		XcglAdminXzz xzzlist = new LambdaQueryChainWrapper<XcglAdminXzz>(xcgladminxzzmapper).eq(XcglAdminXzz::getQyid, userBean.getOrgCode()).eq(XcglAdminXzz::getId, id).one();
		return new ResponseResult().success("获取薪资组数据成功", xzzlist);
	}
	

	/**
	 * 	添加薪资组（选择配薪方式：0-空白模板   df-默认模板）*********
	 */
	@PostMapping(value = "/paygro")
	@ApiOperation(value = "添加薪资组", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult PayrollGroup(@CurrentUser UserBean userBean, @RequestBody PayrollGroupDto paygro) {
		Integer empNum = userBean.getEmpNum();
		Integer orgCode = userBean.getOrgCode();
		
//		Calendar lastm = Calendar.getInstance();
//		lastm.setTime(new Date()); // 设置为当前时间
//		lastm.set(Calendar.MONTH, lastm.get(Calendar.MONTH) - 1);
//		String lastmonth = new SimpleDateFormat("yyyy-MM").format(lastm.getTime());// 上
//		
//		Calendar thism = Calendar.getInstance();
//		lastm.set(Calendar.MONTH, thism.get(Calendar.MONTH) + 1);
//		String thismonth = new SimpleDateFormat("yyyy-MM").format(thism.getTime());// 本
//		
//		Calendar calendar = Calendar.getInstance();
//		calendar.add(Calendar.MONTH, 1);
//		String nextMonth = new SimpleDateFormat("yyyy-MM").format(calendar.getTime());// 下
		
		Calendar lastm = Calendar.getInstance();
		lastm.setTime(SalaryTool.strToDateLong(paygro.getXzyf() + "-01 00:00:00")); // 设置为当前时间
		lastm.set(Calendar.MONTH, lastm.get(Calendar.MONTH) - 1);
		String lastmonth = new SimpleDateFormat("yyyy-MM").format(lastm.getTime());// 上
		
		String thismonth = paygro.getXzyf();// 本
		
		Calendar calendar = Calendar.getInstance();
		calendar.setTime(SalaryTool.strToDateLong(paygro.getXzyf() + "-01 00:00:00")); // 设置为当前时间
		calendar.set(Calendar.MONTH, calendar.get(Calendar.MONTH) + 1);
		String nextMonth = new SimpleDateFormat("yyyy-MM").format(calendar.getTime());// 下
		
		
		XcglAdminXzz xcglxzz = XcglAdminXzz.builder().build();
		xcglxzz.setName(paygro.getName());// 薪资组命名
		xcglxzz.setPayperiod(paygro.getPayperiod());// 算薪月周期 0：上月；1：当月
		xcglxzz.setPaydayperiod(paygro.getPaydayperiod());// 算薪日周期 全月
		String payper = String.format("%02d", paygro.getPaydayperiod());
		String payrollcycle = null;
		if (paygro.getPayperiod() == 0) {// 上月
			if (paygro.getPaydayperiod() == 1) {
				payrollcycle = SalaryTool.getfirstlastTwo(paygro.getXzyf() + "-01 00:00:00") + "到" + SalaryTool.getlastlastTwo(paygro.getXzyf() + "-01 00:00:00");
			} else {
				String firstnext = lastmonth + "-" + payper;
				int jgs = paygro.getPaydayperiod() - 1;
				String lastnext = thismonth + "-" + String.format("%02d", jgs);
				payrollcycle = firstnext + "到" + lastnext;
			}
		} else {// 当月
			if (paygro.getPaydayperiod() == 1) {
				payrollcycle = SalaryTool.getfirstnowTwo(paygro.getXzyf() + "-01 00:00:00") + "到" + SalaryTool.getlastnowTwo(paygro.getXzyf() + "-01 00:00:00");
			} else {
				String firstnow = thismonth + "-" + payper;
				int jgs = paygro.getPaydayperiod() - 1;
				String lastnow = nextMonth + "-" + String.format("%02d", jgs);
				payrollcycle = firstnow + "到" + lastnow;
			}
		}
		xcglxzz.setPayrollcycle(payrollcycle);// 算薪周期
		xcglxzz.setDeletestate(1);// 状态 0：已删除；1：使用中
		xcglxzz.setCountstate(0);// 计算状态 0：未计算；1：已计算
		xcglxzz.setPxfs(paygro.getPxfs());// 选择配薪方式(0:	空白模板；df：默认)
		xcglxzz.setAdduserid(empNum);// 员工工号
		xcglxzz.setQyid(orgCode);// 企业编码
		xcglxzz.setAddtime(new Date().getTime());// 添加时间
		xcglxzz.setMonthtime(paygro.getXzyf());//薪资月份
		xcglxzz.setXzyf(payrollcycle.substring(0, 7));//开始);//算薪月份
		xcgladminxzzmapper.insert(xcglxzz);
		int payid = xcglxzz.getId();
		
		String[][] mrzd = {{"姓名","从人事花名册-姓名自动提取数据"},{"部门","从人事花名册-部门自动提取数据"},{"职位","从人事花名册-职位自动提取数据"},{"工号","从人事花名册-工号自动提取数据"}};
		if(("0").contentEquals(paygro.getPxfs())) {//空白模板
			List<XcglAssoJsgzzx> zzxlist = new ArrayList<XcglAssoJsgzzx>();
			for(String[] q : mrzd) {
				XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
				zzx.setSalaryitem(q[0]);//薪资项
				zzx.setYhmbzd(q[0]);//银行模板项 需与银行一一对应
				zzx.setRule(q[1]);//规则
				zzx.setType(1);//类型 1：系统项；2：非系统项
				zzx.setAddtime(new Date().getTime());//添加时间
				zzx.setAdduserid(empNum);//添加人员id
				zzx.setJxgzid(0);//计薪规则组id 0：未加入组
				zzx.setRemarks("");//备注
				zzx.setGsid(0);//公式id  0：未关联规则
				zzx.setGsgs("");//公式格式 系统提供/自定义公式
				zzx.setXzzid(payid);
				zzx.setRulestate(0);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
				XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, q[0]).one();
				if(opt != null) {
					zzx.setOptionid(opt.getId());
				}else {zzx.setOptionid(0);}
				zzx.setDygk(0.0);//公式变量值1
				zzx.setDegk(0.0);//公式变量值2
				zzxlist.add(zzx);
			}
			if(zzxlist.size() > 0) {
				xcglassojsgzzxmapper.insertxcglassojsgzzxList(zzxlist);
			}
		}else if(("df").contentEquals(paygro.getPxfs())){//默认
			//创建分组    
			//1、人事信息；2、固定工资；3、考勤；4、绩效奖金；5、应发；6、社保公积金；7、个税及实发
			String[] grouping = {"人事信息","固定工资","考勤","绩效奖金","应发","社保公积金","个税及实发"};
			for(int g=0;g<grouping.length;g++) {
				XcglAssoJxgz jxgz = new XcglAssoJxgz();
				jxgz.setXzzid(payid);
				jxgz.setName(grouping[g]);
				jxgz.setRemarks("");
				jxgz.setAddtime(new Date().getTime());
				jxgz.setAdduserid(empNum);
				jxgz.setQyid(orgCode);
				xcglassojxgzmapper.jxgzinsert(jxgz);
				int groid = jxgz.getId();
				if(("人事信息").equals(grouping[g])) {
					String[][] mrzd1 = {{"姓名","从人事花名册-姓名自动提取数据"},{"部门","从人事花名册-部门自动提取数据"},{"职位","从人事花名册-职位自动提取数据"},{"工号","从人事花名册-工号自动提取数据"}};
					List<XcglAssoJsgzzx> zzxlist = new ArrayList<XcglAssoJsgzzx>();
					for(String[] q : mrzd1) {
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(q[0]);//薪资项
						zzx.setYhmbzd(q[0]);//银行模板项 需与银行一一对应
						zzx.setRule(q[1]);//规则
						zzx.setType(1);//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(groid);//计薪规则组id 0：未加入组
						zzx.setRemarks("");//备注
						zzx.setGsid(0);//公式id  0：未关联规则
						zzx.setGsgs("");//公式格式 系统提供/自定义公式
						zzx.setXzzid(payid);
						zzx.setRulestate(0);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
						XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, q[0]).one();
						if(opt != null) {
							zzx.setOptionid(opt.getId());
						}else {zzx.setOptionid(0);}
						zzx.setDygk(0.0);//公式变量值1
						zzx.setDegk(0.0);//公式变量值2
						zzxlist.add(zzx);
					}
					if(zzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(zzxlist);
					}
				}else if(("固定工资").equals(grouping[g])) {
					String[] fixed = {"底薪","岗位津贴","基本工资"};
					List<XcglAssoJsgzzx> gzzxlist=new ArrayList<XcglAssoJsgzzx>();
					for(int f=0;f<fixed.length;f++) {
						XcglAssoXcjsgz xzxj = xcglassoxcjsgzmapper.QuerySalaryRules(fixed[f]);
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(fixed[f]);//薪资项
						zzx.setYhmbzd(fixed[f]);//银行模板项 需与银行一一对应
//						XcglAssoXzdazdy daz = xcglassoxzdazdymapper.SalaryFixedWages(fixed[f]);
						if(xzxj != null) {//系统有规则
							zzx.setRule(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//规则********************************
							zzx.setGsid(xzxj.getId());//公式id  0：未关联规则
							zzx.setGsgs(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//公式格式 系统提供/自定义公式
							zzx.setRulestate(xzxj.getRulestate());//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
							zzx.setDygk(xzxj.getDygk() == null ? 0 : xzxj.getDygk());//公式变量值1 
							zzx.setDegk(xzxj.getDegk() == null ? 0 : xzxj.getDegk());//公式变量值2
							XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, fixed[f]).one();
							zzx.setOptionid(opt.getId());
						}else {
							zzx.setRule("从薪资档案-"+fixed[f]+"自动提取数据");//规则********************************
							zzx.setGsid(0);//公式id  0：未关联规则
							zzx.setGsgs("从薪资档案-"+fixed[f]+"自动提取数据");//公式格式 系统提供/自定义公式
							zzx.setRulestate(1);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
							zzx.setDygk(0.0);//公式变量值1
							zzx.setDegk(0.0);//公式变量值2
							zzx.setOptionid(0);
						}
						zzx.setType(2);//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(groid);//计薪规则组id 0：未加入组
						zzx.setRemarks("");//备注
						zzx.setXzzid(payid);
						
						gzzxlist.add(zzx);
					}
					if(gzzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(gzzxlist);
					}
				}else if(("考勤").equals(grouping[g])) {
					String[] att = {"应出勤天数","实出勤天数","事假","病假","事假扣款","病假扣款","迟到次数","迟到时长","早退次数","迟到早退扣款"};
					List<XcglAssoJsgzzx> gzzxlist=new ArrayList<XcglAssoJsgzzx>();
					for(int a=0;a<att.length;a++) {
						XcglAssoXcjsgz xzxj = xcglassoxcjsgzmapper.QuerySalaryRules(att[a]);
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(att[a]);//薪资项
						zzx.setYhmbzd(att[a]);//银行模板项 需与银行一一对应
						if(xzxj != null) {//系统有规则
							zzx.setRule(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//规则********************************
							zzx.setGsid(xzxj.getId());//公式id  0：未关联规则
							zzx.setGsgs(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//公式格式 系统提供/自定义公式
							zzx.setRulestate(xzxj.getRulestate());//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
							
							zzx.setDygk(xzxj.getDygk() == null ? 0 : xzxj.getDygk());//公式变量值1 
							zzx.setDegk(xzxj.getDegk() == null ? 0 : xzxj.getDegk());//公式变量值2
						}else {
							String xxs = "自动提取数据";
							String[] strxz = {"从月度汇总-"};
							zzx.setRule(strxz[0] + att[a] + xxs);//规则********************************
							zzx.setGsid(0);//公式id  0：未关联规则
							zzx.setGsgs(strxz[0] + att[a] + xxs);//公式格式 系统提供/自定义公式
							zzx.setRulestate(0);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
							zzx.setDygk(0.0);//公式变量值1
							zzx.setDegk(0.0);//公式变量值2
						}
						XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, att[a]).one();
						zzx.setOptionid(opt.getId());
						zzx.setType(2);//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(groid);//计薪规则组id 0：未加入组
						zzx.setRemarks("");//备注
						zzx.setXzzid(payid);
						gzzxlist.add(zzx);
					}
					if(gzzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(gzzxlist);
					}
				}else if(("绩效奖金").equals(grouping[g])) {
					String[] jxjj = {"绩效奖金","业绩提成"};
					List<XcglAssoJsgzzx> gzzxlist=new ArrayList<XcglAssoJsgzzx>();
					for(int a=0;a<jxjj.length;a++) {
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(jxjj[a]);//薪资项
						zzx.setYhmbzd(jxjj[a]);//银行模板项 需与银行一一对应
						zzx.setRule("每月手动导入");//规则********************************
						zzx.setGsid(0);//公式id  0：未关联规则
						zzx.setGsgs("每月手动导入");//公式格式 系统提供/自定义公式
						zzx.setRulestate(4);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
						XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, jxjj[a]).one();
						zzx.setOptionid(opt.getId());
						zzx.setType(2);//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(groid);//计薪规则组id 0：未加入组
						zzx.setRemarks("");//备注
						zzx.setXzzid(payid);
						zzx.setDygk(0.0);//公式变量值1
						zzx.setDegk(0.0);//公式变量值2
						gzzxlist.add(zzx);
					}
					if(gzzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(gzzxlist);
					}
				}else if(("应发").equals(grouping[g])) {
					String[] yingfa = {"应发工资","税前补差"};
					List<XcglAssoJsgzzx> gzzxlist=new ArrayList<XcglAssoJsgzzx>();
					for(int a=0;a<yingfa.length;a++) {
						XcglAssoXcjsgz xzxj = xcglassoxcjsgzmapper.QuerySalaryRules(yingfa[a]);
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(yingfa[a]);//薪资项
						zzx.setYhmbzd(yingfa[a]);//银行模板项 需与银行一一对应
						if(xzxj != null) {//系统有规则
							zzx.setRule(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//规则********************************
							zzx.setGsid(xzxj.getId());//公式id  0：未关联规则
							zzx.setGsgs(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//公式格式 系统提供/自定义公式
							zzx.setRulestate(xzxj.getRulestate());//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
							
							zzx.setDygk(xzxj.getDygk() == null ? 0 : xzxj.getDygk());//公式变量值1 
							zzx.setDegk(xzxj.getDegk() == null ? 0 : xzxj.getDegk());//公式变量值2
						}else {
							zzx.setRule("每月手动导入");//规则********************************
							zzx.setGsid(0);//公式id  0：未关联规则
							zzx.setGsgs("每月手动导入");//公式格式 系统提供/自定义公式
							zzx.setRulestate(4);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
							zzx.setDygk(0.0);//公式变量值1
							zzx.setDegk(0.0);//公式变量值2
						}
						XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, yingfa[a]).one();
						zzx.setOptionid(opt.getId());
						zzx.setType(2);//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(groid);//计薪规则组id 0：未加入组
						zzx.setRemarks("");//备注
						zzx.setXzzid(payid);
						gzzxlist.add(zzx);
					}
					if(gzzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(gzzxlist);
					}
				}else if(("社保公积金").equals(grouping[g])) {
					String[] sbgjj = {"个人社保","个人公积金"};
					List<XcglAssoJsgzzx> gzzxlist=new ArrayList<XcglAssoJsgzzx>();
					for(int a=0;a<sbgjj.length;a++) {
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(sbgjj[a]);//薪资项
						zzx.setYhmbzd(sbgjj[a]);//银行模板项 需与银行一一对应
						String xxs = "自动提取数据";
						String[] strxz = {"从社保账单-"};
						zzx.setRule(strxz[0] + sbgjj[a]+"部分合计" + xxs);//规则********************************
						zzx.setGsid(0);//公式id  0：未关联规则
						zzx.setGsgs(strxz[0] + sbgjj[a]+"部分合计" + xxs);//公式格式 系统提供/自定义公式
						zzx.setRulestate(0);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
						XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, sbgjj[a]).one();
						zzx.setOptionid(opt.getId());
						zzx.setType(2);//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(groid);//计薪规则组id 0：未加入组
						zzx.setRemarks("");//备注
						zzx.setXzzid(payid);
						zzx.setDygk(0.0);//公式变量值1
						zzx.setDegk(0.0);//公式变量值2
						gzzxlist.add(zzx);
					}
					if(gzzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(gzzxlist);
					}
				}else if(("个税及实发").equals(grouping[g])) {
					String[] jsjsf = {"个税","实发工资","其他扣除"};
					List<XcglAssoJsgzzx> gzzxlist=new ArrayList<XcglAssoJsgzzx>();
					for(int a=0;a<jsjsf.length;a++) {
						XcglAssoXcjsgz xzxj = xcglassoxcjsgzmapper.QuerySalaryRules(jsjsf[a]);
						
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(jsjsf[a]);//薪资项
						zzx.setYhmbzd(jsjsf[a]);//银行模板项 需与银行一一对应
						
						if(xzxj != null) {
							zzx.setRule(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//规则********************************
							zzx.setGsid(xzxj.getId());//公式id  0：未关联规则
							zzx.setGsgs(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//公式格式 系统提供/自定义公式
							zzx.setRulestate(xzxj.getRulestate());//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
							
							zzx.setDygk(xzxj.getDygk() == null ? 0 : xzxj.getDygk());//公式变量值1 
							zzx.setDegk(xzxj.getDegk() == null ? 0 : xzxj.getDegk());//公式变量值2
						}else {
							zzx.setRule("每月手动导入");//规则********************************
							zzx.setGsid(0);//公式id  0：未关联规则
							zzx.setGsgs("每月手动导入");//公式格式 系统提供/自定义公式
							zzx.setRulestate(4);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
							zzx.setDygk(0.0);//公式变量值1
							zzx.setDegk(0.0);//公式变量值2
						}
						
						XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, jsjsf[a]).one();
						zzx.setOptionid(opt.getId());
						zzx.setType(2);//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(groid);//计薪规则组id 0：未加入组
						zzx.setRemarks("");//备注
						zzx.setXzzid(payid);
						gzzxlist.add(zzx);
					}
					if(gzzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(gzzxlist);
					}
				}
			}
		}else {//从其他薪资组复制规则
			//未加入分组
			List<XcglAssoJsgzzx> wjrfzlist = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getXzzid, paygro.getPxfs()).eq(XcglAssoJsgzzx::getJxgzid,0).list();
			
			List<XcglAssoJsgzzx> wjrfzzzxlist = new ArrayList<XcglAssoJsgzzx>();
			for(XcglAssoJsgzzx zxs : wjrfzlist) {
				XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
				zzx.setSalaryitem(zxs.getSalaryitem());//薪资项
				zzx.setYhmbzd(zxs.getYhmbzd());//银行模板项 需与银行一一对应
				zzx.setRule(zxs.getRule());//规则
				zzx.setType(zxs.getType());//类型 1：系统项；2：非系统项
				zzx.setAddtime(new Date().getTime());//添加时间
				zzx.setAdduserid(empNum);//添加人员id
				zzx.setJxgzid(zxs.getJxgzid());//计薪规则组id 0：未加入组
				zzx.setRemarks(zxs.getRemarks());//备注
				zzx.setGsid(zxs.getGsid());//公式id  0：未关联规则
				zzx.setGsgs(zxs.getGsgs());//公式格式 系统提供/自定义公式
				zzx.setXzzid(payid);
				zzx.setRulestate(zxs.getRulestate());//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
				
				zzx.setOptionid(zxs.getOptionid());
				
				zzx.setDygk(zxs.getDygk());//公式变量值1  
				zzx.setDegk(zxs.getDegk());//公式变量值2
				
				wjrfzzzxlist.add(zzx);
			}
			if(wjrfzzzxlist.size() > 0) {
				xcglassojsgzzxmapper.insertxcglassojsgzzxList(wjrfzzzxlist);
			}
			
			//计薪规则组
			List<XcglAssoJxgz> jxgzlist = new LambdaQueryChainWrapper<XcglAssoJxgz>(xcglassojxgzmapper).eq(XcglAssoJxgz::getXzzid, paygro.getPxfs()).list();
			@SuppressWarnings("unused")
			List<XcglAssoJxgz> jxgzs = new ArrayList<XcglAssoJxgz>();
			for(XcglAssoJxgz jxgzl : jxgzlist) {
				
				XcglAssoJxgz jxgz = new XcglAssoJxgz();
				jxgz.setXzzid(payid);
				jxgz.setName(jxgzl.getName());
				jxgz.setRemarks(jxgzl.getRemarks());
				jxgz.setAddtime(new Date().getTime());
				jxgz.setAdduserid(empNum);
				jxgz.setQyid(orgCode);
//				jxgzs.add(jxgz);
				xcglassojxgzmapper.jxgzinsert(jxgz);
				int jxgzid = jxgz.getId();
				
				List<XcglAssoJsgzzx> yjrfzlist = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getXzzid, paygro.getPxfs()).eq(XcglAssoJsgzzx::getJxgzid,jxgzl.getId()).list();
				if(yjrfzlist.size() > 0) {
					List<XcglAssoJsgzzx> yjrfzzzxlist = new ArrayList<XcglAssoJsgzzx>();
					for(XcglAssoJsgzzx yzxs : yjrfzlist) {
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(yzxs.getSalaryitem());//薪资项
						zzx.setYhmbzd(yzxs.getYhmbzd());//银行模板项 需与银行一一对应
						zzx.setRule(yzxs.getRule());//规则
						zzx.setType(yzxs.getType());//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(jxgzid);//计薪规则组id 0：未加入组
						zzx.setRemarks(yzxs.getRemarks());//备注
						zzx.setGsid(yzxs.getGsid());//公式id  0：未关联规则
						zzx.setGsgs(yzxs.getGsgs());//公式格式 系统提供/自定义公式
						zzx.setXzzid(payid);
						zzx.setRulestate(yzxs.getRulestate());//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
						zzx.setOptionid(yzxs.getOptionid());
						
						zzx.setDygk(yzxs.getDygk());//公式变量值1
						zzx.setDegk(yzxs.getDegk());//公式变量值2
						yjrfzzzxlist.add(zzx);
					}
					if(yjrfzzzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(yjrfzzzxlist);
					}
				}
			}
		}
		List<XcglAssoXzury> xcgllist = new ArrayList<XcglAssoXzury>();
		String[] attser = paygro.getPayuserids();
		if (attser.length > 0) {
			for (int u = 0; u < attser.length; u++) {
				xcglassoxzurymapper.deleteByuseridoqyid(Integer.valueOf(attser[u]), orgCode);
				XcglAssoXzury kquser = new XcglAssoXzury();
				kquser.setXzzid(payid);// 薪资组id
				kquser.setUserid(Integer.valueOf(attser[u]));
				kquser.setQyid(orgCode);
				xcgllist.add(kquser);
			}
		}
		if (xcgllist.size() > 0) {
			xcglassoxzurymapper.insertxcglassoxzuryList(xcgllist);
		}
		return new ResponseResult().success("添加/修改薪资组成功", xcglxzz);
	}
	
	/**
	 * @param userBean
	 * @param modifysalaryruledto
	 * @return
	 */
	@PostMapping(value = "/modifysalaryrule")
	@ApiOperation(value = "修改薪资规则", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> Modifysalaryrule(@CurrentUser UserBean userBean,@RequestBody ModifysalaryruleDto modifysalaryruledto) {
		
		XcglAssoXcjsgz xcjsgz = XcglAssoXcjsgz.builder().id(modifysalaryruledto.getXcjsgzid()).build().selectById();
		//11：应发工资   13：实发工资
		if(modifysalaryruledto.getXcjsgzid().equals(11) || modifysalaryruledto.getXcjsgzid().equals(13)) {
			if(!xcjsgz.getGsxs().equals(modifysalaryruledto.getFormula())) {
				XcglAssoJsgzzx.builder().gsid(modifysalaryruledto.getXcjsgzid()).gsgs(modifysalaryruledto.getFormula())
					.rule(modifysalaryruledto.getFormula()).rulestate(3).id(modifysalaryruledto.getJsgzzxid()).build().updateById();
			}else {
				XcglAssoJsgzzx.builder().gsid(modifysalaryruledto.getXcjsgzid()).gsgs(modifysalaryruledto.getFormula())
				.rule(modifysalaryruledto.getFormula()).rulestate(xcjsgz.getRulestate()).id(modifysalaryruledto.getJsgzzxid()).build().updateById();
			}
		}else {
			XcglAssoJsgzzx.builder().gsid(modifysalaryruledto.getXcjsgzid()).gsgs(modifysalaryruledto.getFormula())
					.dygk(modifysalaryruledto.getDygk()).degk(modifysalaryruledto.getDegk())
					.rule(modifysalaryruledto.getFormula()).rulestate(xcjsgz.getRulestate())
					.id(modifysalaryruledto.getJsgzzxid()).build().updateById();
		}
		
		return ResultUtil.success("操作成功!");
	}
	
	/**
	 * 弹出薪资规则
	 * @param userBean
	 * @param id 薪资选项id
	 * @return
	 */
	@GetMapping(value="/popupsalaryrule/{id}")
	@ApiOperation(value = "弹出薪资规则", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> Popupsalaryrule(@CurrentUser UserBean userBean,@PathVariable("id") Integer id) {
		
		List<XcglAssoXcjsgz> gzgs = XcglAssoXcjsgz.builder().build().selectList(new QueryWrapper<XcglAssoXcjsgz>().lambda().eq(XcglAssoXcjsgz::getOptionid, id));
		
		return ResultUtil.data(gzgs,"操作成功!");
	}
	
	
	
	/**
	 * 	删除薪资组  ***********
	 */
	@DeleteMapping(value = "/paydelete/{id}")
	@ApiOperation(value = "删除薪资组", httpMethod = "DELETE", notes = "接口发布说明")
	public ResponseResult paydelete(@PathVariable Integer id) {
		XcglAdminXzz.builder().build().deleteById(id);
		List<XcglAssoXzury> znrylist = new LambdaQueryChainWrapper<XcglAssoXzury>(xcglassoxzurymapper).eq(XcglAssoXzury::getXzzid, id).list();
		for(XcglAssoXzury qcjs:znrylist) {
			xcglassoxzbmapper.deleteXcglAssoXzb(qcjs.getUserid());
		}
		xcglassoxzurymapper.xzurydelete(id);
		xcglassojxgzmapper.deleteByxzzid(id);//计薪规则组
		xcglassojsgzzxmapper.deleteByxzzid(id);//计薪规则组项
		
		xcglassogztztmapper.deletegztztByxzzid(id);
		
		xcglassogztszmapper.deletexcglassogztszByxzzid(id);
		
		return new ResponseResult().success("删除成功", id);
	}

	/**
	 *	修改薪资组
	 */
	@PutMapping(value = "/salarygroup")
	@ApiOperation(value = "修改薪资组", httpMethod = "PUT", notes = "接口发布说明")
	public ResponseResult ModifySalaryGroup(@CurrentUser UserBean userBean, @RequestBody PayrollGroupDto paygro) {
		@SuppressWarnings("unused")
		Integer empNum = userBean.getEmpNum();
		Integer orgCode = userBean.getOrgCode();
		
		Calendar lastm = Calendar.getInstance();
		lastm.setTime(SalaryTool.strToDateLong(paygro.getXzyf() + "-01 00:00:00")); // 设置为当前时间
		lastm.set(Calendar.MONTH, lastm.get(Calendar.MONTH) - 1);
		String lastmonth = new SimpleDateFormat("yyyy-MM").format(lastm.getTime());// 上
		
		String thismonth = paygro.getXzyf();// 本
		
		Calendar calendar = Calendar.getInstance();
		calendar.setTime(SalaryTool.strToDateLong(paygro.getXzyf() + "-01 00:00:00")); // 设置为当前时间
		calendar.set(Calendar.MONTH, calendar.get(Calendar.MONTH) + 1);
		String nextMonth = new SimpleDateFormat("yyyy-MM").format(calendar.getTime());// 下
		
		XcglAdminXzz xcglxzz = XcglAdminXzz.builder().build();
		xcglxzz.setName(paygro.getName());// 薪资组命名
		xcglxzz.setPayperiod(paygro.getPayperiod());// 算薪月周期 0：上月；1：当月
		xcglxzz.setPaydayperiod(paygro.getPaydayperiod());// 算薪日周期 全月
		
		String payper = String.format("%02d", paygro.getPaydayperiod());
		String payrollcycle = null;
		if (paygro.getPayperiod() == 0) {// 上月
			if (paygro.getPaydayperiod() == 1) {
				payrollcycle = SalaryTool.getfirstlastTwo(paygro.getXzyf() + "-01 00:00:00") + "到" + SalaryTool.getlastlastTwo(paygro.getXzyf() + "-01 00:00:00");
			} else {
				String firstnext = lastmonth + "-" + payper;
				int jgs = paygro.getPaydayperiod() - 1;
				String lastnext = thismonth + "-" + String.format("%02d", jgs);
				payrollcycle = firstnext + "到" + lastnext;
			}
		} else {// 当月
			if (paygro.getPaydayperiod() == 1) {
				payrollcycle = SalaryTool.getfirstnowTwo(paygro.getXzyf() + "-01 00:00:00") + "到" + SalaryTool.getlastnowTwo(paygro.getXzyf() + "-01 00:00:00");
			} else {
				String firstnow = thismonth + "-" + payper;
				int jgs = paygro.getPaydayperiod() - 1;
				String lastnow = nextMonth + "-" + String.format("%02d", jgs);
				payrollcycle = firstnow + "到" + lastnow;
			}
		}
		xcglxzz.setPayrollcycle(payrollcycle);// 算薪周期
		xcglxzz.setDeletestate(1);// 状态 0：已删除；1：使用中
		xcglxzz.setCountstate(0);// 计算状态 0：未计算；1：已计算
		xcglxzz.setPxfs(paygro.getPxfs());// 选择配薪方式(0:空白模板；df:默认)
		xcglxzz.setQyid(orgCode);// 企业编码
		xcglxzz.setId(paygro.getId());
		xcglxzz.setXzyf(payrollcycle.substring(0, 7));//算薪月份
		xcglxzz.updateById();
		int payid = paygro.getId();
		xcglassoxzurymapper.xzurydelete(payid);
		List<XcglAssoXzury> xcgllist = new ArrayList<XcglAssoXzury>();
		String[] attser = paygro.getPayuserids();
		if (attser.length > 0) {
			for (int u = 0; u < attser.length; u++) {
				XcglAssoXzury kquser = new XcglAssoXzury();
				kquser.setXzzid(payid);// 薪资组id
				kquser.setUserid(Integer.valueOf(attser[u]));
				kquser.setQyid(orgCode);
				xcgllist.add(kquser);
			}
		}
		if (xcgllist.size() > 0) {
			xcglassoxzurymapper.insertxcglassoxzuryList(xcgllist);
		}
		return new ResponseResult().success("修改薪资组成功", xcglxzz);
	}
	
	/**
	 * 	获取自定义薪资组表头信息*******
	 */
	@GetMapping(value = "/paycustom")
	@ApiOperation(value = "获取自定义薪资组信息", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult selectpaycustomlist(@CurrentUser UserBean userBean) {
		List<XcglAssoXzdazdy> Xzdazdy = new LambdaQueryChainWrapper<XcglAssoXzdazdy>(xcglassoxzdazdymapper).eq(XcglAssoXzdazdy::getQyid, userBean.getOrgCode()).list();
		return new ResponseResult().success("获取自定义薪资组表头信息", Xzdazdy);
	}

	/**
	 * 	查询定薪人员+模糊查询*******
	 */
	@PostMapping(value = "/fixedstaff")
	@ApiOperation(value = "查询定薪人员/分页", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> FixedSalarStaff(@CurrentUser UserBean userBean,@RequestBody SearchSalariedPeopleDto search) {
		search.setOrgcode(userBean.getOrgCode());
		Page<FixedSalaryStaffDto> page = new Page<FixedSalaryStaffDto>(
				search.getCurrentPage() == null ? 1 : search.getCurrentPage(),
				search.getTotalPage() == null ? 10 : search.getTotalPage());

		long total = xcglassoxzdazdymapper.selectFixedSalaryStaffCount(search);
		List<FixedSalaryStaffDto> dxrylist = xcglassoxzdazdymapper.selectFixedSalaryStaff(search);
		page.setTotal(total);
		return ResultUtil.data(page, dxrylist, "获取自定义薪资组表头信息");
	}


	/**
	 * 	查询定薪人员+模糊查询*******
	 */
	@PostMapping(value = "/fixedstaffAll")
	@ApiOperation(value = "查询定薪人员 不分页", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> FixedSalarStaffAll(@CurrentUser UserBean userBean,@RequestBody SearchSalariedPeopleDto search) {
		search.setOrgcode(userBean.getOrgCode());
		List<FixedSalaryStaffDto> dxrylist = xcglassoxzdazdymapper.selectFixedSalaryStaffAll(search);
		return ResultUtil.data(dxrylist, "获取自定义薪资组表头信息");
	}
	
	/**
	 * 	核对算薪人员及薪资档案*******
	 */
	@PostMapping(value = "/check_staff_file")
	@ApiOperation(value = "核对算薪人员及薪资档案", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult Check_staff_file(@CurrentUser UserBean userBean,@RequestBody CheckSalaryStaffDto checksalary) {
		
		checksalary.setOrgcode(userBean.getOrgCode());
		
		List<FixedSalaryStaffDto> dxrylist = xcglassoxzdazdymapper.selectPaygroupStaff(checksalary);//
		return new ResponseResult().success("获取核对算薪人员及薪资档案信息", dxrylist);
	}


	/**
	 * 	自定义薪资表头
	 */
	@PostMapping(value = "/Custsave")
	@ApiOperation(value = "添加/修改薪资档案自定义", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult Customheadersave(@CurrentUser UserBean userBean,@RequestBody SalaryCustomizationDto salarycustomizationdto) {
		List<XcglAssoXzdazdy> xzdazdy = new LambdaQueryChainWrapper<XcglAssoXzdazdy>(xcglassoxzdazdymapper).eq(XcglAssoXzdazdy::getQyid, userBean.getOrgCode()).list();
		List<XcglAssoXzdazdy> zdylist = new ArrayList<XcglAssoXzdazdy>();
		PayCustomDto[] paycus = salarycustomizationdto.getPaycustomdto();//
		if (paycus.length > 0) {
			int z = xzdazdy.size() + 1;
			for (int p = 0; p < paycus.length; p++) {
				if (paycus[p].getId() != null) {// 修改
					XcglAssoXzdazdy zdy = new XcglAssoXzdazdy();
					zdy.setId(paycus[p].getId());
					zdy.setZdmc(paycus[p].getTitle());// 字段名
					int zdsrklx = 2;
					if (paycus[p].getType() == "文字") {
						zdsrklx = 1;
					}
					zdy.setZdsrklx(zdsrklx);// 字段输入框类型 1：文本 2：数字
					xcglassoxzdazdymapper.dazdyupdate(zdy);
				} else {// 新增
					XcglAssoXzdazdy zdy = new XcglAssoXzdazdy();
					zdy.setQyid(userBean.getOrgCode());// 企业
					zdy.setXhpx(z);// 序号
					zdy.setZdmc(paycus[p].getTitle());// 字段名
					int zdsrklx = 2;
					if (paycus[p].getType() == "文字") {
						zdsrklx = 1;
					}
					zdy.setZdsrklx(zdsrklx);// 字段输入框类型 1：文本 2：数字
					zdy.setZdlx(1);// 字段类型 0：系统项 1：自定义
					zdylist.add(zdy);
					z++;
				}
			}
		}
		if (zdylist.size() > 0) {
			xcglassoxzdazdymapper.insertxcglassoxzdazdyList(zdylist);
		}
		//薪资档案-定薪
		List<XcglAssoXzdadx> xzdxlist = new LambdaQueryChainWrapper<XcglAssoXzdadx>(xcglassoxzdadxmapper).eq(XcglAssoXzdadx::getQyid, userBean.getOrgCode()).list();
		for(XcglAssoXzdazdy xzd:zdylist) {//26 测试字段
			
			for(XcglAssoXzdadx dad:xzdxlist) { //
				XcglAssoXzdaz daz = new LambdaQueryChainWrapper<XcglAssoXzdaz>(xcglassoxzdazmapper).eq(XcglAssoXzdaz::getXzdazdyid, xzd.getId()).eq(XcglAssoXzdaz::getXzdadxid,dad.getId()).one();
				if(daz == null) {
					XcglAssoXzdaz xzdaz = new XcglAssoXzdaz();
					xzdaz.setXzdazdyid(xzd.getId());
					xzdaz.setRsz("");
					xzdaz.setXzdadxid(dad.getId());
					xzdaz.insert();
				}
			}
		}
		return new ResponseResult().success("添加/修改成功", zdylist);
	}

	/**
	 * 	删除薪资组自定义表头
	 */
	@DeleteMapping(value = "/customdelete/{id}")
	@ApiOperation(value = "删除薪资组自定义表头", httpMethod = "DELETE", notes = "接口发布说明")
	public ResponseResult customdelete(@CurrentUser UserBean userBean,@PathVariable Integer id) {
		XcglAssoXzdazdy.builder().build().deleteById(id);

		// 同时删除已添加到薪资组(未锁定的组)中的薪资项
		xcglassojsgzzxmapper.deleteByxzdazdyid(id);

		return new ResponseResult().success("删除成功", id);
	}

	/**
	 * 	初始化数据
	 */
	@GetMapping(value = "/initialization")
	@ApiOperation(value = "初始化薪资档案自定义", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult Initialization(@CurrentUser UserBean userBean) {
		List<XcglAssoXzdazdy> cshsj = xcglassoxzdazdymapper.selectxcglassoxzdazdy(userBean.getOrgCode());
			String[] zdmc = { "底薪", "岗位津贴" };
			// 检查是否有初始化数据
			if (cshsj.size() == 0) {
				for (int z = 0; z < zdmc.length; z++) {
					XcglAssoXzdazdy zdy = new XcglAssoXzdazdy();
					zdy.setZdmc(zdmc[z]);// 字段名
					zdy.setZdsrklx(2);// 字段输入框类型 1：文本 2：数字
					zdy.setZdlx(0);// 字段类型 0：系统项 1：自定义
					zdy.setQyid(userBean.getOrgCode());// 企业id
					zdy.setXhpx(z + 1);// 序号
					zdy.insert();
				}
			}
			return new ResponseResult().success("初始化成功", null);
	}
	
	/**
	 *	定薪
	 */
	@PostMapping(value = "/fixedsalary")
	@ApiOperation(value = "定薪", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult fixedsalary(@CurrentUser UserBean userBean,@RequestBody FixedsalaryDto fixedsalarydto) {
		XcglAssoXzdadx xzdadx = XcglAssoXzdadx.builder().build();
		xzdadx.setUserid(Integer.valueOf(fixedsalarydto.getUserid()));//用户id
		xzdadx.setSxrq(fixedsalarydto.getSxrq());//生效日期
		xzdadx.setAddtime(new Date().getTime());
		xzdadx.setRemarks(fixedsalarydto.getRemarks());
		xzdadx.setQyid(userBean.getOrgCode());
		xzdadx.setTxzt(0);//0：使用中；1：历史, 2: 未生效
		xcglassoxzdadxmapper.xzdadxinsert(xzdadx);
		int zdyid = xzdadx.getId();
		List<XcglAssoXzdaz> xzdazlist=new ArrayList<XcglAssoXzdaz>();
		CustomDto[] cus = fixedsalarydto.getCus();
		
		List<XcglAssoXzdazdy> xzs = XcglAssoXzdazdy.builder().build().selectList(new QueryWrapper<XcglAssoXzdazdy>().lambda().eq(XcglAssoXzdazdy::getQyid, userBean.getOrgCode()));
		for(XcglAssoXzdazdy xz : xzs) {
			XcglAssoXzdaz xzdaz = XcglAssoXzdaz.builder().build();
			xzdaz.setXzdazdyid(xz.getId());//薪资档案自定义id
			xzdaz.setRsz("0");//输入值
			xzdaz.setXzdadxid(zdyid);//薪资档案-定薪id
			xzdaz.insert();
		}
		
		if(cus.length>0){
			for(int p=0;p<cus.length;p++){
				XcglAssoXzdaz.builder().build().delete(new QueryWrapper<XcglAssoXzdaz>().lambda().eq(XcglAssoXzdaz::getXzdazdyid, cus[p].getId()).eq(XcglAssoXzdaz::getXzdadxid, zdyid));
				XcglAssoXzdaz xzdaz = new XcglAssoXzdaz();
				xzdaz.setXzdazdyid(cus[p].getId());//薪资档案自定义id
				xzdaz.setRsz(cus[p].getVal());//输入值
				xzdaz.setXzdadxid(zdyid);//薪资档案-定薪id
				xzdazlist.add(xzdaz);
			}
		}
		if(xzdazlist.size()>0){
			xcglassoxzdazmapper.insertxcglassoxzdazList(xzdazlist);
		}
		return new ResponseResult().success("成功", xzdadx); 
	}

	/**
	 *	获取调薪数据
	 */
	@GetMapping(value = "/getsalaryadjustment/{empnum}")
	@ApiOperation(value = "获取调薪数据", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult GetSalaryAdjustment(@CurrentUser UserBean userBean,@PathVariable Integer empnum) {
		List<ChangeSalaryDto> hqtxsj = xcglassoxzdazdymapper.AchieveSalaryAdjustment(userBean.getOrgCode(),empnum);
		return new ResponseResult().success("获取自定义薪资组表头信息", hqtxsj);
	}
	
	/**
	 *	调薪
	 */
	@SneakyThrows(Exception.class)
	@PostMapping(value = "/payensaad")
	@ApiOperation(value = "调薪", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult EnterSalaryAdjustment(@CurrentUser UserBean userBean,@RequestBody FixedsalaryDto fixedsalarydto) {
		// 当前日期
		String curDate = DateUtil.getStringFormat(new Date().getTime());
		// 未生效的调薪记录同一天只能有一条
		XcglAssoXzdadx tmp = new LambdaQueryChainWrapper<XcglAssoXzdadx>(xcglassoxzdadxmapper)
				.eq(XcglAssoXzdadx::getUserid, Integer.valueOf(fixedsalarydto.getUserid()))
				.eq(XcglAssoXzdadx::getTxzt, 2)
				.eq(XcglAssoXzdadx::getSxrq, fixedsalarydto.getSxrq())
				.one();
		if (!Objects.isNull(tmp)) {
			return new ResponseResult().fail("调薪成功失败, 已存在生效日期" + fixedsalarydto.getSxrq() + "的待生效记录, 请到调薪记录页面查看!");
		}
		int txzt = 2;
		if (DateUtil.getFormat(fixedsalarydto.getSxrq()) <= DateUtil.getFormat(curDate)) {
			// 生效日期在当天或之前的， 立即生效, 原使用中的记录变成历史记录
			XcglAssoXzdadx xzds = new LambdaQueryChainWrapper<XcglAssoXzdadx>(xcglassoxzdadxmapper)
					.eq(XcglAssoXzdadx::getUserid, Integer.valueOf(fixedsalarydto.getUserid()))
					.eq(XcglAssoXzdadx::getTxzt, 0)
					.one();
			if(xzds != null) {
				XcglAssoXzdadx txrz = XcglAssoXzdadx.builder().build();
				txrz.setTxzt(1);//0：使用中；1：历史, 2: 未生效
				txrz.setId(xzds.getId());
				txrz.updateById();
			}
			txzt = 0;
		}
		XcglAssoXzdadx xzdadx = XcglAssoXzdadx.builder().build();
		xzdadx.setUserid(Integer.valueOf(fixedsalarydto.getUserid()));//用户id
		xzdadx.setSxrq(fixedsalarydto.getSxrq());//生效日期
		xzdadx.setAddtime(new Date().getTime());
		xzdadx.setXgyhid(userBean.getEmpNum());//修改用户id
		xzdadx.setRemarks(fixedsalarydto.getRemarks());
		xzdadx.setQyid(userBean.getOrgCode());
		xzdadx.setTxzt(txzt);
		xcglassoxzdadxmapper.xzdadxinsert(xzdadx);
		int zdyid = xzdadx.getId();
		List<XcglAssoXzdaz> xzdazlist=new ArrayList<XcglAssoXzdaz>();
		CustomDto[] cus = fixedsalarydto.getCus();
		if(cus.length>0){
			for(int p=0;p<cus.length;p++){
				XcglAssoXzdaz xzdaz = new XcglAssoXzdaz();
				xzdaz.setXzdazdyid(cus[p].getId());//薪资档案自定义id
				xzdaz.setRsz(cus[p].getVal());//输入值
				xzdaz.setXzdadxid(zdyid);//薪资档案-定薪id
				xzdazlist.add(xzdaz);
			}
		}
		if(xzdazlist.size()>0){
			xcglassoxzdazmapper.insertxcglassoxzdazList(xzdazlist);
		}
		return new ResponseResult().success("调薪成功", xzdadx);
	}
	
	/**
	 *	调薪记录
	 */
	@GetMapping(value = "/payzdysj/{id}")
	@ApiOperation(value = "获取调薪记录信息", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult SalaryAdjustmentRecord(@CurrentUser UserBean userBean,@PathVariable Integer id) {
		List<FixedSalaryStaffDto> txjllist = xcglassoxzdazdymapper.SalaryAdjustmentRecord(userBean.getOrgCode(),id);
			return new ResponseResult().success("获取调薪记录信息", txjllist);
	}

	/**
	 *	调薪记录编辑保存
	 */
	@SneakyThrows(Exception.class)
	@PostMapping(value = "/saveTXjlEdit")
	@ApiOperation(value = "调薪", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult saveTXjlEdit(@CurrentUser UserBean userBean,@RequestBody FixedsalaryDto fixedsalarydto) {
		// 当前日期
		String curDate = DateUtil.getStringFormat(new Date().getTime());
		// 未生效的调薪记录同一天只能有一条
		XcglAssoXzdadx tmp = new LambdaQueryChainWrapper<XcglAssoXzdadx>(xcglassoxzdadxmapper)
				.eq(XcglAssoXzdadx::getUserid, Integer.valueOf(fixedsalarydto.getUserid()))
				.eq(XcglAssoXzdadx::getTxzt, 2)
				.eq(XcglAssoXzdadx::getSxrq, fixedsalarydto.getSxrq())
				.one();
		if (!Objects.isNull(tmp) && !tmp.getId().equals(fixedsalarydto.getId())) {
			return new ResponseResult().fail("调薪成功失败, 已存在生效日期" + fixedsalarydto.getSxrq() + "的待生效记录, 请到调薪记录页面查看!");
		}
		int txzt = 2;
		if (DateUtil.getFormat(fixedsalarydto.getSxrq()) <= DateUtil.getFormat(curDate)) {
			// 生效日期在当天或之前的， 立即生效, 原使用中的记录变成历史记录
			XcglAssoXzdadx xzds = new LambdaQueryChainWrapper<XcglAssoXzdadx>(xcglassoxzdadxmapper)
					.eq(XcglAssoXzdadx::getUserid, Integer.valueOf(fixedsalarydto.getUserid()))
					.eq(XcglAssoXzdadx::getTxzt, 0)
					.one();
			if(xzds != null) {
				XcglAssoXzdadx txrz = XcglAssoXzdadx.builder().build();
				txrz.setTxzt(1);//0：使用中；1：历史, 2: 未生效
				txrz.setId(xzds.getId());
				txrz.updateById();
			}
			txzt = 0;
		}
		XcglAssoXzdadx xzdadx = new XcglAssoXzdadx();
		xzdadx.setId(fixedsalarydto.getId());
		xzdadx.setSxrq(fixedsalarydto.getSxrq());//生效日期
		xzdadx.setAddtime(new Date().getTime());
		xzdadx.setXgyhid(userBean.getEmpNum());//修改用户id
		xzdadx.setRemarks(fixedsalarydto.getRemarks());
		xzdadx.setTxzt(txzt);
		xcglassoxzdadxmapper.updateById(xzdadx);

		CustomDto[] cus = fixedsalarydto.getCus();
		if(cus.length > 0){
			for(int p = 0; p < cus.length; p++){
				XcglAssoXzdaz xzdaz = new XcglAssoXzdaz();
				xzdaz.setId(cus[p].getId());
				xzdaz.setRsz(cus[p].getVal());//输入值

				xcglassoxzdazmapper.updateById(xzdaz);
			}
		}
		return new ResponseResult().success("保存成功");
	}
	
	/**
	 *	删除调薪记录
	 */
	@DeleteMapping(value = "/delSalaryAdjustmentRecord/{id}")
	@ApiOperation(value = "删除调薪记录", httpMethod = "DELETE", notes = "接口发布说明")
	public ResponseResult delSalaryAdjustmentRecord(@CurrentUser UserBean userBean,@PathVariable Integer id) {
		XcglAssoXzdadx.builder().build().deleteById(id);//薪资档案-定薪
		xcglassoxzdazmapper.Recorddelete(id);//薪资档案值
		return new ResponseResult().success("删除成功", id);
	}
	
	/**payrulegroupitem
	 *	获取薪资选项
	 */
	@PostMapping(value = "/salaryoptions")
	@ApiOperation(value = "获取薪资选项", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult SalaryOoptions(@CurrentUser UserBean userBean, @RequestBody SalaryoptionsDto dto) {
		List<XcglAssoOptionDto> itemlist = xcglsalaryitemmapper.selectxcglsalaryitemList(dto);
		return new ResponseResult().success("获取薪资选项信息", itemlist);
	}
	
	/**
	 *	创建薪资组
	 */
	@PostMapping(value = "/paycreategro")
	@ApiOperation(value = "创建薪资组", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult CreatePayGroup(@CurrentUser UserBean userBean,@RequestBody CjPayrollGroupDto cjpaygro) {
		XcglAssoJxgz jxgz = new XcglAssoJxgz();
			jxgz.setXzzid(cjpaygro.getId());
			jxgz.setName(cjpaygro.getName());
			jxgz.setRemarks(cjpaygro.getRemarks());
			jxgz.setAddtime(new Date().getTime());
			jxgz.setAdduserid(userBean.getEmpNum());
			jxgz.setQyid(userBean.getOrgCode());
			xcglassojxgzmapper.jxgzinsert(jxgz);
			return new ResponseResult().success("创建薪资组成功", jxgz);
	}

	/**
	 *	修改薪资组
	 */
	@PutMapping(value = "/movecreatepaygroup")
	@ApiOperation(value = "修改薪资组", httpMethod = "PUT", notes = "接口发布说明")
	public Result<XcglAssoJxgz> MoveCreatePayGroup(@RequestBody CjPayrollGroupDto cjpaygro) {
		XcglAssoJxgz jxgz = XcglAssoJxgz.builder().build();
			jxgz.setId(cjpaygro.getId());
			jxgz.setName(cjpaygro.getName());
			jxgz.setRemarks(cjpaygro.getRemarks());
			jxgz.updateById();
			return ResultUtil.data(jxgz,"编辑员工权限成功");
	}
	
	/**
	 *	删除薪资组	
	 */
	@DeleteMapping(value = "/delcreatepaygroup/{id}")
	@ApiOperation(value = "删除薪资组", httpMethod = "DELETE", notes = "接口发布说明")
	public ResponseResult deleteCreatePayGroup(@PathVariable Integer id) {
		List<XcglAssoJsgzzx> jsgzzx = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getJxgzid, id).list();
		if(jsgzzx.size() > 0) {//
			for(XcglAssoJsgzzx jsgz:jsgzzx) {
				XcglAssoJsgzzx jsg = XcglAssoJsgzzx.builder().build();
				jsg.setId(jsgz.getId());
				jsg.setJxgzid(0);
				jsg.updateById();
			}	
		}
		XcglAssoJxgz.builder().build().deleteById(id);
		return new ResponseResult().success("解散成功", id);
	}

	/**
	 *	删除薪资项
	 */
	@DeleteMapping(value = "/deletesalaryitem/{id}/{ident}")
	@ApiOperation(value = "删除薪资项", httpMethod = "DELETE", notes = "接口发布说明")
	public ResponseResult deleteSalaryItem(@PathVariable Integer id,@PathVariable Integer ident) {
		if(ident == 1) {
			XcglAssoJsgzzx zx = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getId, id).one();
			XcglAdminXzz yjs = XcglAdminXzz.builder().build();
			yjs.setCountstate(0);//计算状态 0：未计算；1：已计算
			yjs.setId(zx.getXzzid());
			yjs.updateById();
			List<XcglAssoXzury> znrylist = new LambdaQueryChainWrapper<XcglAssoXzury>(xcglassoxzurymapper).eq(XcglAssoXzury::getXzzid, zx.getXzzid()).list();
			for(XcglAssoXzury qcjs:znrylist) {
				xcglassoxzbmapper.deleteXcglAssoXzb(qcjs.getUserid());
			}
		}
		XcglAssoJsgzzx.builder().build().deleteById(id);
		return new ResponseResult().success("删除成功", id);
	}
	
	
	@GetMapping(value = "/paysettings/{id}")
	@ApiOperation(value = "计薪规则设置", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult SalaryCalculationRuleSettings(@PathVariable Integer id) {
		SalaryGroupGroupingDto salgr = new SalaryGroupGroupingDto();
		//#薪资组里未加入分组的字段
		List<PayTermDto> jsgzzx = xcglassojsgzzxmapper.selectxcglassojxgzList(id);
		salgr.setJsgzzx(jsgzzx);
		//#加入分组的字段
		List<PayGroupedDataDto> jrxzzs = xcglassojxgzmapper.selectPayrollGroupList(id);
		salgr.setPaygrte(jrxzzs);
		return new ResponseResult().success("获取调薪记录信息", salgr);
	}
	
	
	/**	
	 *	创建计薪规则组项【非自定义】
	 */
	@PostMapping(value = "/payrulegroupitem")
	@ApiOperation(value = "创建计薪规则组项", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult PayRuleGroupItem(@CurrentUser UserBean userBean,@RequestBody TjSalaryItemDot tjsal) {
		if(tjsal.getIdent() == 1) {//
			XcglAdminXzz yjs = XcglAdminXzz.builder().build();
			yjs.setCountstate(0);//计算状态 0：未计算；1：已计算
			yjs.setId(tjsal.getId());
			yjs.updateById();
			List<XcglAssoXzury> znrylist = new LambdaQueryChainWrapper<XcglAssoXzury>(xcglassoxzurymapper).eq(XcglAssoXzury::getXzzid, tjsal.getId()).eq(XcglAssoXzury::getQyid,userBean.getOrgCode()).list();
			for(XcglAssoXzury qcjs:znrylist) {
				xcglassoxzbmapper.deleteXcglAssoXzb(qcjs.getUserid());
			}
		}
		List<XcglAssoJsgzzx> gzzxlist=new ArrayList<XcglAssoJsgzzx>();
		//optitemid;//类型  1：人事信息、2：考勤、3：绩效奖金、4：应发、5：社保公积金、6：个税及实发
		SalaryItemRulesDto[] term = tjsal.getTerm();
		if(term.length > 0){
			for(int a=0;a<term.length;a++){
				XcglAssoXcjsgz xzxj = xcglassoxcjsgzmapper.QuerySalaryRules(term[a].getOptname());
				XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
				zzx.setSalaryitem(term[a].getOptname());//薪资项
				zzx.setYhmbzd(term[a].getOptname());//银行模板项 需与银行一一对应
				if(xzxj != null && term[a].getOptitemid() != 0) {//系统有规则
					zzx.setRule(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//规则********************************
					zzx.setGsid(xzxj.getId());//公式id  0：未关联规则
					zzx.setGsgs(xzxj.getGsxs().replace("{{", "").replace("}}", ""));//公式格式 系统提供/自定义公式
					zzx.setRulestate(2);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
				}else {//系统无规则
					//薪资档案自定义
					XcglAssoXzdazdy daz = xcglassoxzdazdymapper.SalaryFixedWages(term[a].getOptname());
					if(daz!=null && term[a].getOptitemid() == 0) {//系统有固定设值  ==>  term[a].getOptitemid() == 0
						zzx.setRule("从薪资档案-"+term[a].getOptname()+"自动提取数据");//规则********************************
						zzx.setGsid(0);//公式id  0：未关联规则
						zzx.setGsgs("从薪资档案-"+term[a].getOptname()+"自动提取数据");//公式格式 系统提供/自定义公式
						zzx.setRulestate(1);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
						XcglAssoXzdazdy xzd = XcglAssoXzdazdy.builder().build().selectOne(new QueryWrapper<XcglAssoXzdazdy>().lambda().eq(XcglAssoXzdazdy::getQyid, userBean.getOrgCode())
								.eq(XcglAssoXzdazdy::getZdmc, term[a].getOptname()));
						int xzdazdyid = 0;
						if(xzd != null) {
							xzdazdyid = xzd.getId();
						}
						zzx.setXzdazdyid(xzdazdyid);
					}else {//
						String xxs = "自动提取数据";
						String[] strxz = {"从人事花名册-","从月度汇总-","从社保账单-"};
						String describe = "";
						int rule = 0;//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月手动导入]
						if(term[a].getOptitemid() == 1) {//人事信息
							describe = strxz[0] + term[a].getOptname() + xxs;
						}else if(term[a].getOptitemid() == 2){//考勤
							describe = strxz[1] + term[a].getOptname() + xxs;
						}else if(term[a].getOptitemid() == 3){//绩效奖金
							describe = "每月手动导入";
							rule = 4;
						}else if(term[a].getOptitemid() == 4){//应发
							describe = "每月手动导入";
							rule = 4;
						}else if(term[a].getOptitemid() == 5){//社保公积金
							describe = strxz[2] + term[a].getOptname()+"部分合计" + xxs;
						}
						zzx.setRule(describe);//规则********************************
						zzx.setGsid(0);//公式id  0：未关联规则
						zzx.setGsgs(describe);//公式格式 系统提供/自定义公式
						zzx.setRulestate(rule);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
						
						zzx.setXzdazdyid(0);
					}
				}
				if(term[a].getOptitemid() != 0) {
					XcglAssoOption opt = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getOptionname, term[a].getOptname()).one();
					zzx.setOptionid(opt.getId());
				}else {
					zzx.setOptionid(0);
				}
				zzx.setType(2);//类型 1：系统项；2：非系统项
				zzx.setAddtime(new Date().getTime());//添加时间
				zzx.setAdduserid(userBean.getEmpNum());//添加人员id
				zzx.setJxgzid(tjsal.getGroid());//计薪规则组id 0：未加入组
				zzx.setRemarks("");//备注
				zzx.setXzzid(tjsal.getId());
				if(xzxj != null) {
					zzx.setDygk(xzxj.getDygk() == null ? 0 : xzxj.getDygk());
					zzx.setDegk(xzxj.getDegk() == null ? 0 : xzxj.getDegk());
				}else {
					zzx.setDygk(0.0);
					zzx.setDegk(0.0);
				}
				
				gzzxlist.add(zzx);
			}
		}
		if(gzzxlist.size() > 0) {
			xcglassojsgzzxmapper.insertxcglassojsgzzxListTwo(gzzxlist);
		}
		return new ResponseResult().success("创建薪资组成功", gzzxlist);
	}
	
	/**
	 *	创建自定义计薪规则组项
	 */
	@PostMapping(value = "/payCustomitem")
	@ApiOperation(value = "创建自定义计薪规则组项", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult PayCustomRuleGroupItem(@CurrentUser UserBean userBean,@RequestBody PayCustomZDYDto payc) {
		
		XcglAssoJsgzzx sfcz = XcglAssoJsgzzx.builder().build().selectOne(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, payc.getGid()).eq(XcglAssoJsgzzx::getSalaryitem, payc.getName()));
		if(sfcz == null) {
			XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
			zzx.setSalaryitem(payc.getName());//薪资项
			zzx.setYhmbzd(payc.getName());//银行模板项 需与银行一一对应
			if(payc.getSource() == 1) {//自定义公式
				zzx.setRule(payc.getFormula());//规则********************************
				zzx.setGsid(0);//公式id  0：未关联规则
				zzx.setGsgs(payc.getFormula());//公式格式 系统提供/自定义公式
				zzx.setRulestate(3);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
			}else if(payc.getSource() == 2){
				zzx.setRule("每月手动导入");//规则********************************
				zzx.setGsid(0);//公式id  0：未关联规则
				zzx.setGsgs("每月手动导入");//公式格式 系统提供/自定义公式
				zzx.setRulestate(4);//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
			}
			zzx.setType(2);//类型 1：系统项；2：非系统项
			zzx.setAddtime(new Date().getTime());//添加时间
			zzx.setAdduserid(userBean.getEmpNum());//添加人员id
			zzx.setJxgzid(payc.getFgid());//计薪规则组id 0：未加入组
			zzx.setRemarks(payc.getRemarks());//备注
			zzx.setXzzid(payc.getGid());//
			zzx.setOptionid(0);
			zzx.setIsCustom(1);//是否自定义项（0：否；1：是）
			xcglassojsgzzxmapper.jsgzzxinsert(zzx);
			return new ResponseResult().success("创建薪资组成功", zzx);
		}else {
			return new ResponseResult().error(payc.getName()+"重复添加");
		}
	}
	
	@PostMapping(value = "/duplicatedetection")
	@ApiOperation(value = "检测重复", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult DuplicateDetection(@CurrentUser UserBean userBean,@RequestBody PayCustomZDYDto payc) {
		
		XcglAssoXzdazdy xzd = XcglAssoXzdazdy.builder().build().selectOne(new QueryWrapper<XcglAssoXzdazdy>().lambda().eq(XcglAssoXzdazdy::getQyid, userBean.getOrgCode())
				.eq(XcglAssoXzdazdy::getZdmc, payc.getName()));
		if(xzd != null) {
			return new ResponseResult().error(payc.getName()+"重复添加");
		}else {
			return new ResponseResult().success("", null);
		}
		
	}
	
	
	/**
	 *	获取薪资项公式
	 */
	@GetMapping(value = "/salaryitemformula")
	@ApiOperation(value = "获取薪资项公式", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult SalaryItemFormula(@PathVariable String text) {
		XcglAssoXcjsgz xzxj = xcglassoxcjsgzmapper.QuerySalaryRules(text);
		return new ResponseResult().success("创建薪资组成功", xzxj);
	}
	
	/**
	 *	移动薪资项
	 */
	@PutMapping(value = "/movesalaryitem")
	@ApiOperation(value = "移动薪资项", httpMethod = "PUT", notes = "接口发布说明")
	public ResponseResult MoveSalaryItem(@RequestBody YdMobilePacketDto ydmob) {
		if(ydmob.getYdgid() != 0) {//踢出当前薪资组
			XcglAssoJsgzzx jsgzzx = XcglAssoJsgzzx.builder().build();
			jsgzzx.setJxgzid(ydmob.getYdgid());
			jsgzzx.setId(ydmob.getXid());
			jsgzzx.updateById();
		}else {
			XcglAssoJsgzzx jsgzzx = XcglAssoJsgzzx.builder().build();
			jsgzzx.setJxgzid(0);
			jsgzzx.setId(ydmob.getXid());
			jsgzzx.updateById();
		}
		return new ResponseResult().success("移动薪资项成功", null);
	}
	
	
	/*******计算薪资*********/
	
	
	/**
	 *	每月手动导入所需导出的表头数据
	 */
	@GetMapping(value = "/monthly_manual_import/{id}")
	@ApiOperation(value = "每月手动导入所需导出的表头数据", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> MonthlyManualImport(@CurrentUser UserBean userBean,@PathVariable Integer id) {
		
		FloatingDataDto data = new FloatingDataDto();
		//rulestate：规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
		List<XcglAssoJsgzzx> jsgzzx = XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, id)
				.eq(XcglAssoJsgzzx::getRulestate, 4));
		data.setJsgzzx(jsgzzx);
		
		List<UserPersonnelDto> sonn = xcglassoxzbmapper.UserPersonnel(id, userBean.getOrgCode());
		data.setUsers(sonn);
		
		return ResultUtil.data(data);
	}
	
	/**
	 *	导入浮动数据薪资
	 */
	@PostMapping(value = "/payimport")
	@ApiOperation(value = "导入薪资", httpMethod = "POST", notes = "接口发布说明")
	public Result<ImportDescriptionDto> ImportSalaryData(@CurrentUser UserBean userBean,@RequestBody ImportSalarySetDto impor) {
		int toinsert = 0;//新增
		int toupdate = 0;//更新
		int failure = 0;//失败
		List<Map<String, String>> reasons = Lists.newArrayList();
		ImportSalaryDto[] ims = impor.getImsalary();//
		if (ims.length > 0) {
			for( int p=0; p < ims.length; p++) {
				Map<String, String> map = Maps.newHashMap();
				String name = ims[0].getUsername();
				try {
					//用户工号来匹配入库
					XcglAssoXzury xzuryone = new LambdaQueryChainWrapper<XcglAssoXzury>(xcglassoxzurymapper).eq(XcglAssoXzury::getQyid, userBean.getOrgCode())
							.eq(XcglAssoXzury::getXzzid, impor.getGid()).eq(XcglAssoXzury::getUserid, ims[p].getUsernum()).one();
					if(xzuryone != null) {
						XcglAssoXzb xzb = XcglAssoXzb.builder().build();
						xzb.setUserid(xzuryone.getUserid());//
						xzb.setXzyf(impor.getSxrq());//
						xzb.setXzxid(ims[p].getJsgzzx());//
						xzb.setXzxjg(ims[p].getSrz());//
						xzb.setQyid(userBean.getOrgCode());
						xcglassoxzbmapper.ModifyImportedSalary(xzb);
						toupdate++;
					}
				} catch (Exception e) {
					failure++;
					map.put("name", name);
					map.put("msg", StringUtils.isBlank(e.getMessage()) ? "必填数据出现空值" : e.getMessage());
				} finally {
					reasons.add(map);
				}
			}
		}
		ImportDescriptionDto imds = new ImportDescriptionDto();
		imds.setSuccess(toinsert + toupdate);//成功
		imds.setToinsert(toinsert);
		imds.setToupdate(toupdate);//更新
		imds.setFailure(failure);//失败
		imds.setReasons(reasons);
		return ResultUtil.data(imds,"导入成功");
	}
	
	
	/**
	 *	导入薪资
	 * @throws ParseException 
	 */
	@PostMapping(value = "/paysalaryfile")
	@ApiOperation(value = "导入薪资", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> paySalaryfile(@CurrentUser UserBean userBean,@Validated @RequestBody ValidList<ImportSalaryfileDto> impor) {
		
		int toinsert = 0;//新增
		int toupdate = 0;//更新
		int failure = 0;//失败
		List<Map<String, String>> reasons = Lists.newArrayList();
		for(ImportSalaryfileDto file : impor) {
			String name = file.getEmpname();
			
			Map<String, String> map = Maps.newHashMap();
			
			try {
				YgglMainEmp emp = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getName, file.getEmpname()).eq(YgglMainEmp::getPhone, file.getPhone())
						.eq(YgglMainEmp::getOrgCode, userBean.getOrgCode()));
				if(emp != null) {
					
					if(ClockInTool.Str_Time_formatting(file.getSxrq().replace("/", "-"),"yyyy-MM-dd").length() == 10) {
						
						//0:定薪  1：调薪
						if(file.getSfdx() == 0) {
							XcglAssoXzdadx xzdadx = XcglAssoXzdadx.builder().build();
							xzdadx.setUserid(emp.getEmpNum());//用户id
							xzdadx.setSxrq(file.getSxrq().replace("/", "-"));//生效日期
							xzdadx.setAddtime(new Date().getTime());
							xzdadx.setRemarks("");
							xzdadx.setQyid(userBean.getOrgCode());
							xzdadx.setTxzt(0);//0：使用中；1：历史, 2: 未生效
							xcglassoxzdadxmapper.xzdadxinsert(xzdadx);
							int zdyid = xzdadx.getId();
							List<XcglAssoXzdaz> xzdazlist=new ArrayList<XcglAssoXzdaz>();
							CustomDto[] cus = file.getCus();
							
							List<XcglAssoXzdazdy> xzs = XcglAssoXzdazdy.builder().build().selectList(new QueryWrapper<XcglAssoXzdazdy>().lambda().eq(XcglAssoXzdazdy::getQyid, userBean.getOrgCode()));
							for(XcglAssoXzdazdy xz : xzs) {
								XcglAssoXzdaz xzdaz = XcglAssoXzdaz.builder().build();
								xzdaz.setXzdazdyid(xz.getId());//薪资档案自定义id
								xzdaz.setRsz("0");//输入值
								xzdaz.setXzdadxid(zdyid);//薪资档案-定薪id
								xzdaz.insert();
							}
							
							if(cus.length>0){
								for(int p=0;p<cus.length;p++){
									XcglAssoXzdaz.builder().build().delete(new QueryWrapper<XcglAssoXzdaz>().lambda().eq(XcglAssoXzdaz::getXzdazdyid, cus[p].getId()).eq(XcglAssoXzdaz::getXzdadxid, zdyid));
									XcglAssoXzdaz xzdaz = new XcglAssoXzdaz();
									xzdaz.setXzdazdyid(cus[p].getId());//薪资档案自定义id
									xzdaz.setRsz(cus[p].getVal());//输入值
									xzdaz.setXzdadxid(zdyid);//薪资档案-定薪id
									xzdazlist.add(xzdaz);
								}
							}
							if(xzdazlist.size()>0){
								xcglassoxzdazmapper.insertxcglassoxzdazList(xzdazlist);
							}
							toinsert++;
						}else {
							// 当前日期
							String curDate = DateUtil.getStringFormat(new Date().getTime());
							// 未生效的调薪记录同一天只能有一条
							XcglAssoXzdadx tmp = new LambdaQueryChainWrapper<XcglAssoXzdadx>(xcglassoxzdadxmapper)
									.eq(XcglAssoXzdadx::getUserid, emp.getEmpNum())
									.eq(XcglAssoXzdadx::getTxzt, 2)
									.eq(XcglAssoXzdadx::getSxrq, file.getSxrq())
									.one();
							if (!Objects.isNull(tmp)) {
								return ResultUtil.error("调薪成功失败, 已存在生效日期" + file.getSxrq() + "的待生效记录, 请到调薪记录页面查看!");
							}
							int txzt = 2;
							if (DateUtil.getFormat(file.getSxrq()) <= DateUtil.getFormat(curDate)) {
								// 生效日期在当天或之前的， 立即生效, 原使用中的记录变成历史记录
								XcglAssoXzdadx xzds = new LambdaQueryChainWrapper<XcglAssoXzdadx>(xcglassoxzdadxmapper)
										.eq(XcglAssoXzdadx::getUserid, emp.getEmpNum())
										.eq(XcglAssoXzdadx::getTxzt, 0)
										.one();
								if(xzds != null) {
									XcglAssoXzdadx txrz = XcglAssoXzdadx.builder().build();
									txrz.setTxzt(1);//0：使用中；1：历史, 2: 未生效
									txrz.setId(xzds.getId());
									txrz.updateById();
								}
								txzt = 0;
							}
							XcglAssoXzdadx xzdadx = XcglAssoXzdadx.builder().build();
							xzdadx.setUserid(emp.getEmpNum());//用户id
							xzdadx.setSxrq(file.getSxrq());//生效日期
							xzdadx.setAddtime(new Date().getTime());
							xzdadx.setXgyhid(userBean.getEmpNum());//修改用户id
							xzdadx.setRemarks("");
							xzdadx.setQyid(userBean.getOrgCode());
							xzdadx.setTxzt(txzt);
							xcglassoxzdadxmapper.xzdadxinsert(xzdadx);
							int zdyid = xzdadx.getId();
							List<XcglAssoXzdaz> xzdazlist=new ArrayList<XcglAssoXzdaz>();
							CustomDto[] cus = file.getCus();
							if(cus.length>0){
								for(int p=0;p<cus.length;p++){
									XcglAssoXzdaz xzdaz = new XcglAssoXzdaz();
									xzdaz.setXzdazdyid(cus[p].getId());//薪资档案自定义id
									xzdaz.setRsz(cus[p].getVal());//输入值
									xzdaz.setXzdadxid(zdyid);//薪资档案-定薪id
									xzdazlist.add(xzdaz);
								}
							}
							if(xzdazlist.size()>0){
								xcglassoxzdazmapper.insertxcglassoxzdazList(xzdazlist);
							}
							toinsert++;
						}
					
					}else {
						failure++;
						map.put("name", name);
						map.put("msg", "日期格式不对（Excel中输入时间处设置为“短日期”即可）");
						reasons.add(map);
					}
				}else {
					failure++;
					map.put("name", name);
					map.put("msg", "该员工不存在");
					reasons.add(map);
				}
			}catch (Exception e) {
				failure++;
				map.put("name", name);
				map.put("msg", StringUtils.isBlank(e.getMessage()) ? "必填数据出现空值" : e.getMessage());
				reasons.add(map);
			}
		}
		
		ImportDescriptionDto imds = new ImportDescriptionDto();
		imds.setSuccess(toinsert + toupdate);//成功
		imds.setToinsert(toinsert);
		imds.setToupdate(toupdate);//更新
		imds.setFailure(failure);//失败
		imds.setReasons(reasons);
		
		return ResultUtil.data(imds,"成功");
	}
	
	
	@PostMapping(value = "/determinesalaryrules")
	@ApiOperation(value = "是否确定薪资规则", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> DetermineSalaryRules(@CurrentUser UserBean userBean,@RequestBody SalaryRulesDto salaryrulesdto) {
		XcglAdminXzz.builder().id(salaryrulesdto.getXzzid()).isXzgz(salaryrulesdto.getState()).build().updateById();
		return ResultUtil.success("操作成功!");
	}
	
	@PostMapping(value = "/locksalary")
	@ApiOperation(value = "是否锁定薪资", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> LockSalary(@CurrentUser UserBean userBean,@RequestBody SalaryRulesDto salaryrulesdto) {
		XcglAdminXzz.builder().id(salaryrulesdto.getXzzid()).isXzsd(salaryrulesdto.getState()).build().updateById();
		return ResultUtil.success("操作成功!");
	}
	
	
	/**
	 *	查看薪资
	 */
	@PostMapping(value = "/checksalary")
	@ApiOperation(value = "查看薪资", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult CheckSalary(@CurrentUser UserBean userBean, @RequestBody CheckSalaryStaffDto checksalary) {
		//计算完成 返回数据
		checksalary.setOrgcode(userBean.getOrgCode());
		List<CalculationDto> jswsj = xcglassoxzbmapper.CalculationResults(checksalary);
		return new ResponseResult().success("查看薪资成功", jswsj);
	}
	
	/**
	 *	获取计薪规则组项
	 */
	@GetMapping(value = "/payrulegroupitem/{id}")
	@ApiOperation(value = "获取计薪规则组项", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult Payrulegroupitem(@CurrentUser UserBean userBean,@PathVariable Integer id) {
		SalaryFieldDto salfie = new SalaryFieldDto();
		List<XcglAssoJsgzzx> jsgzzxlist = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getXzzid, id).eq(XcglAssoJsgzzx::getType,2).list();
		List<CalculatedFieldDto> fielist = new ArrayList<CalculatedFieldDto>();
		for(XcglAssoJsgzzx jsg : jsgzzxlist) {
			CalculatedFieldDto fie = new CalculatedFieldDto();
			fie.setId(jsg.getId());
			fie.setTitle(jsg.getSalaryitem());
			fie.setFormula(jsg.getGsgs());//公式
			fielist.add(fie);
		}
		if(fielist.size() > 0) {
			salfie.setCalfie(fielist);
		}
		
			
//		List<CalculationDto> jswsj = xcglassoxzbmapper.CalculationResults(id,userBean.getOrgCode());
		CheckSalaryStaffDto checksalary = new CheckSalaryStaffDto();
		checksalary.setPaygroupid(id);
		// checksalary.setXzyf(xzyf);
		checksalary.setOrgcode(userBean.getOrgCode());
		List<CalculationDto> jswsj = xcglassoxzbmapper.CalculationResults(checksalary);
		salfie.setComuser(jswsj);
		
		return new ResponseResult().success("获取计薪规则组项成功", salfie);
	}
	
	
	@Autowired
	private KqglAssoMonthPunchSummaryMapper kqglassomonthpunchsummarymapper;
	@Autowired
	private SbgjjAssoYjzdMapper sbgjjassoyjzdmapper;
	@Autowired
	private SbgjjAssoDetailedMapper sbgjjassodetailedmapper;
	/**
	 *	（保存，下一步）计算薪资  ()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()()
	 */
	@GetMapping(value = "/calculatesalary/{id}")
	@ApiOperation(value = "计算薪资", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult CalculateSalary(@CurrentUser UserBean userBean,@PathVariable Integer id) {
		int orgcode = userBean.getOrgCode();
		String xzyf = "";
		
		//typeid--1:计算   2：重新计算
		//已知薪资组id****
		//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
		//计算薪资改变薪资组计算状态
		XcglAdminXzz yjs = XcglAdminXzz.builder().build();
		yjs.setCountstate(1);//计算状态 0：未计算；1：已计算
		yjs.setId(id);
		yjs.updateById();
		
		//薪资组信息
		XcglAdminXzz xzz = new LambdaQueryChainWrapper<XcglAdminXzz>(xcgladminxzzmapper).eq(XcglAdminXzz::getId, id).one();
//		sxrq = xzz.getXzyf();
		xzyf = xzz.getXzyf();
		//当前薪资组内人员
		List<XcglAssoXzury> znrys = new LambdaQueryChainWrapper<XcglAssoXzury>(xcglassoxzurymapper).eq(XcglAssoXzury::getXzzid, id).eq(XcglAssoXzury::getQyid,userBean.getOrgCode()).list();
		List<CalculationDto> jswsj = null;
		if(znrys.size() > 0) {//该薪资组有成员
			
			for(XcglAssoXzury znr:znrys) {
				
				xcglassoxzbmapper.deleteByuserid(znr.getUserid(),id,xzyf);//删除已经计算的薪资
				
				//查询员工定薪数据
				XcglAssoXzdadx isdx = new LambdaQueryChainWrapper<XcglAssoXzdadx>(xcglassoxzdadxmapper).eq(XcglAssoXzdadx::getUserid,znr.getUserid()).eq(XcglAssoXzdadx::getQyid, userBean.getOrgCode()).eq(XcglAssoXzdadx::getTxzt, 0).one();
				if(isdx != null) {
					//查询 “1：系统固定值”数据----入[薪资表]
					List<CalculationOptionsDto> gdxzx = xcglassojsgzzxmapper.selectCalculationOptionsList(id,znr.getUserid());
					for(CalculationOptionsDto cal:gdxzx) {
						XcglAssoXzb xzb = XcglAssoXzb.builder().build();
						xzb.setUserid(znr.getUserid());//用户id
						xzb.setXzyf(xzyf);//薪资月
						xzb.setXzxid(cal.getId());//薪资项id
						xzb.setXzxjg(StringUtils.isBlank(cal.getRsz()) ? 0 : Double.valueOf(cal.getRsz()));//薪资项结果
						xzb.setQyid(userBean.getOrgCode());
						xcglassoxzbmapper.xzbinsert(xzb);
					}
				}else {
					//未定薪人员   薪资表内“1：系统固定值”全为-->0
					List<XcglAssoJsgzzx> jsgzzxlist = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getXzzid, id).eq(XcglAssoJsgzzx::getRulestate,1).list();
					for(XcglAssoJsgzzx cal:jsgzzxlist) {
						XcglAssoXzb xzb = XcglAssoXzb.builder().build();
						xzb.setUserid(znr.getUserid());//用户id
						xzb.setXzyf(xzyf);//薪资月
						xzb.setXzxid(cal.getId());//薪资项id
						xzb.setXzxjg(0.0);//薪资项结果
						xzb.setQyid(userBean.getOrgCode());
						xcglassoxzbmapper.xzbinsert(xzb);
					}
				}
				//查询“0：系统自动提取”数据----入[薪资表]   200---姓名    系统项不加入薪资表
				List<XcglAssoJsgzzx> xtzdtqlist = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getXzzid, id).eq(XcglAssoJsgzzx::getRulestate,0)
						.eq(XcglAssoJsgzzx::getType, 2).list();
				for(XcglAssoJsgzzx xtzd:xtzdtqlist) {
					if(xtzd.getOptionid() > 0) {//说明阔以根据表查出结果
						XcglAssoOption lbcx = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getId,xtzd.getOptionid()).one(); 
						if(lbcx.getTablename() != null && !lbcx.getTablename().equals("") && lbcx.getFieldname() != null && !lbcx.getFieldname().equals("")) {
							String tablename = lbcx.getTablename();//对应库表名
							String fieldname = lbcx.getFieldname();//对应库字段名
							List<Map<String, Object>> list = null;
							double vacation = 0;//假期
							int numover = 0;
							double workover = 0;//加班
							if(tablename.equals("yggl_main_emp")) {//员工管理
								QueryWrapper<YgglMainEmp> queryWrapper = new QueryWrapper<>();
								queryWrapper.select(fieldname).eq("emp_num", znr.getUserid()).eq("org_code", userBean.getOrgCode());//select #{tablename} from yggl_main_emp where emp_num = ?
								list = ygglmainempmapper.selectMaps(queryWrapper);
							}else if(tablename.equals("kqgl_asso_month_punch_summary")) {
								QueryWrapper<KqglAssoMonthPunchSummary> queryWrapper = new QueryWrapper<>();
								queryWrapper.select(fieldname).eq("num", znr.getUserid()).eq("org_code", userBean.getOrgCode()).eq("belong_year", xzyf.substring(0, 4)).eq("belong_month", Integer.valueOf(xzyf.substring(5, 7)));//select #{tablename} from yggl_main_emp where emp_num = ?
								list = kqglassomonthpunchsummarymapper.selectMaps(queryWrapper);
							}else if(tablename.equals("sbgjj_asso_yjzd")) {
								QueryWrapper<SbgjjAssoYjzd> queryWrapper = new QueryWrapper<>();
								queryWrapper.select(fieldname).eq("user_num", znr.getUserid()).eq("qyid", userBean.getOrgCode()).eq("zymonth", xzyf);//select #{tablename} from yggl_main_emp where emp_num = ?
								list = sbgjjassoyjzdmapper.selectMaps(queryWrapper);
							}else if(tablename.equals("sbgjj_asso_detailed")) {//社保公积金
								QueryWrapper<SbgjjAssoDetailed> queryWrapper = new QueryWrapper<>();
								queryWrapper.select(fieldname).eq("coverage_name", lbcx.getOptionname().substring(0, 2)).eq("user_id", znr.getUserid()).eq("org_code", userBean.getOrgCode()).eq("attribution_time", xzyf);//select #{tablename} from yggl_main_emp where emp_num = ?
								list = sbgjjassodetailedmapper.selectMaps(queryWrapper);
							}else if(tablename.equals("kqgl_asso_relation_summary")) {//假期（32~41）[请假的总小时数]、补卡次数15、工作日加班24、休息日加班25、节假日加班26
								if(lbcx.getId() == 32) { 
									HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 1, znr.getUserid()); 
									vacation = balance.getBalance();
								}
								if(lbcx.getId() == 33) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 2, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 34) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 3, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 35) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 4, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 36) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 5, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 37) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 6, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 38) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 7, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 39) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 8, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 40) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 9, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 41) { HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(orgcode, xzyf, 10, znr.getUserid()); vacation = balance.getBalance();}
								if(lbcx.getId() == 15) { HolidayInquiryDto num = xcglassoxzbmapper.NumberOvertime(orgcode, xzyf, znr.getUserid()); numover = num.getNum();}
								if(lbcx.getId() == 24) { HolidayInquiryDto worov = xcglassoxzbmapper.PeriodsOvertime(orgcode, xzyf, 1, znr.getUserid()); workover = worov.getBalance();}
								if(lbcx.getId() == 25) { HolidayInquiryDto worov = xcglassoxzbmapper.PeriodsOvertime(orgcode, xzyf, 2, znr.getUserid()); workover = worov.getBalance();}
								if(lbcx.getId() == 26) { HolidayInquiryDto worov = xcglassoxzbmapper.PeriodsOvertime(orgcode, xzyf, 3, znr.getUserid()); workover = worov.getBalance();}
							}else if(tablename.equals("xcgl_asso_gsjsmx")) {
								QueryWrapper<XcglAssoGsjsmx> queryWrapper = new QueryWrapper<>();
								queryWrapper.select(fieldname).eq("user_num", znr.getUserid()).eq("qyid", userBean.getOrgCode()).eq("salary_month", xzyf);//select #{tablename} from yggl_main_emp where emp_num = ?
								list = xcglassogsjsmxmapper.selectMaps(queryWrapper);
							}
							
					        String autacq = "";
					        if(list != null) {
					        	for(Map<String, Object> aut:list) {
					        		if(aut != null) {
					        			autacq = aut.toString().substring(aut.toString().indexOf("=")+1).replace("}", "");
					        		}
					        	}
					        }else {
					        	if(lbcx.getId() == 15) {
					        		autacq = String.valueOf(numover);
					        	}else if(lbcx.getId() == 24 || lbcx.getId() == 25 || lbcx.getId() == 26) {
					        		autacq = String.valueOf(workover);
					        	}else {
					        		autacq = String.valueOf(vacation);
					        	}
					        }
					        //处理结果
					        if(fieldname.equals("job_type")) {
					        	if(autacq.equals("0")) {autacq="全职";}else
								if(autacq.equals("1")) {autacq="实习生";}else
								if(autacq.equals("2")) {autacq="兼职";}else		
								if(autacq.equals("3")) {autacq="劳务派遣";}else		
								if(autacq.equals("4")) {autacq="劳务";}else		
								if(autacq.equals("5")) {autacq="派遣";}else		
								if(autacq.equals("6")) {autacq="外包";}else {autacq="退休返聘";}		
					        }else if(fieldname.equals("job_status")) {
					        	if(autacq.equals("0")) {autacq="试用";}else
								if(autacq.equals("1")) {autacq="正式";}else
								if(autacq.equals("2")) {autacq="离职中";}else {autacq="已离职";}	
				        	}else if(fieldname.equals("rz_time") || fieldname.equals("zz_time")) {
				        		autacq = autacq.substring(0, 10);
				        	}
					        //入[薪资表]
					        XcglAssoXzb xzb = XcglAssoXzb.builder().build();
							xzb.setUserid(znr.getUserid());//用户id
							if(fieldname.equals("name") || fieldname.equals("emp_num")) {
								xzb.setXzyf("");//薪资月
							}else {
								xzb.setXzyf(xzyf);//薪资月
							}
							xzb.setXzxid(xtzd.getId());//薪资项id
							xzb.setXzxjg(("").equals(autacq) ? 0.0 : Double.valueOf(autacq));//薪资项结果
							xzb.setQyid(userBean.getOrgCode());
							xcglassoxzbmapper.xzbinsert(xzb);
						}else {
							if(lbcx.getItemid() == 1) {//人事
								//入[薪资表]
						        XcglAssoXzb xzb = XcglAssoXzb.builder().build();
								xzb.setUserid(znr.getUserid());//用户id
								if(("部门").equals(lbcx.getOptionname()) || ("职位").equals(lbcx.getOptionname())) {
									xzb.setXzyf("");//薪资月
								}else {
									xzb.setXzyf(xzyf);//薪资月
								}
								xzb.setXzxid(xtzd.getId());//薪资项id
								xzb.setXzxjg(null);//薪资项结果
								xzb.setQyid(userBean.getOrgCode());
								xcglassoxzbmapper.xzbinsert(xzb);
							}else {
								//入[薪资表]
						        XcglAssoXzb xzb = XcglAssoXzb.builder().build();
								xzb.setUserid(znr.getUserid());//用户id
								xzb.setXzyf(xzyf);//薪资月
								xzb.setXzxid(xtzd.getId());//薪资项id
								xzb.setXzxjg(0.0);//薪资项结果
								xzb.setQyid(userBean.getOrgCode());
								xcglassoxzbmapper.xzbinsert(xzb);
							}
						}
					}
				}
				
				//查询“0：系统自动提取”数据----入[薪资表]   200---姓名
				List<XcglAssoJsgzzx> xtzdtqother = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getXzzid, id).list();
				for(XcglAssoJsgzzx xtzd:xtzdtqother) {
					if(xtzd.getRulestate() == 2 || xtzd.getRulestate() == 3 || xtzd.getRulestate() == 4) {
						if(xtzd.getOptionid() > 0 || xtzd.getIsCustom() == 1) {//说明阔以根据表查出结果
							XcglAssoOption lbcx = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getId,xtzd.getOptionid()).one(); 
							if(lbcx != null && lbcx.getTablename() != null && !lbcx.getTablename().equals("") && lbcx.getFieldname() != null && !lbcx.getFieldname().equals("")) {
								@SuppressWarnings("unused")
								String tablename = lbcx.getTablename();//对应库表名
								@SuppressWarnings("unused")
								String fieldname = lbcx.getFieldname();//对应库字段名
								@SuppressWarnings("unused")
								List<Map<String, Object>> list = null;
					        	
					        	//入[薪资表]
						        XcglAssoXzb xzb = XcglAssoXzb.builder().build();
								xzb.setUserid(znr.getUserid());//用户id
								xzb.setXzyf(xzyf);//薪资月
								xzb.setXzxid(xtzd.getId());//薪资项id
								xzb.setXzxjg(0.0);//薪资项结果
								xzb.setQyid(userBean.getOrgCode());
								xcglassoxzbmapper.xzbinsert(xzb);
					        	
							}else {
								//入[薪资表]
						        XcglAssoXzb xzb = XcglAssoXzb.builder().build();
								xzb.setUserid(znr.getUserid());//用户id
								xzb.setXzyf(xzyf);//薪资月
								xzb.setXzxid(xtzd.getId());//薪资项id
								xzb.setXzxjg(0.0);//薪资项结果
								xzb.setQyid(userBean.getOrgCode());
								xcglassoxzbmapper.xzbinsert(xzb);
							}
						}
					}
				}
			}
			
			//计算完成 返回数据
//			jswsj = xcglassoxzbmapper.CalculationResults(id,userBean.getOrgCode());
			CheckSalaryStaffDto checksalary = new CheckSalaryStaffDto();
			checksalary.setPaygroupid(id);
			checksalary.setXzyf(xzyf);
			checksalary.setOrgcode(userBean.getOrgCode());
			jswsj = xcglassoxzbmapper.CalculationResults(checksalary);
			
			return new ResponseResult().success("计算完成", jswsj);
		}else {//该组无人
			return new ResponseResult().error("请先添加算薪人员");
		}
		
	}
	
	
	/**
	 *	 计算薪资!@#$%^&*()_+
	 * @param userBean
	 * @param calcomtiondto
	 * @return
	 * @throws ScriptException 
	 * @throws NumberFormatException 
	 */
	@PostMapping(value = "/salary_calculation")
	@ApiOperation(value = "计算薪资", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> SalaryCalculation(@CurrentUser UserBean userBean, @RequestBody CalculatingCompensationDto calcomtiondto) throws NumberFormatException, ScriptException {
		int orgcode = userBean.getOrgCode();
		String strY = new SimpleDateFormat("yyyy").format(new Date());
		ScriptEngine js = new ScriptEngineManager().getEngineByName("JavaScript");
		
		//查询出薪资组内成员
		List<XcglAssoXzury> paygrlist = XcglAssoXzury.builder().build().selectList(new QueryWrapper<XcglAssoXzury>().lambda().eq(XcglAssoXzury::getXzzid, calcomtiondto.getPay_group_id()));
		//查询出当前薪资组里所有列表头   计薪规则组项  固定数值
		//32:事假、33:调休、34:病假、35:年假、36:产假、37:陪产假、38:婚假、39:例假、40:丧假、41:哺乳假;
		List<XcglAssoJsgzzx> sjbt = xcglassojsgzzxmapper.SalaryRuleGroupItem(calcomtiondto.getPay_group_id());//XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, calcomtiondto.getPay_group_id()));
		
		//薪资组信息
		XcglAdminXzz xzz = XcglAdminXzz.builder().id(calcomtiondto.getPay_group_id()).build().selectById();
		//算薪月周期
		String startcycle = xzz.getPayrollcycle().substring(0, 10);//开始
		String endcycle = xzz.getPayrollcycle().substring(11, 21);//结束
		//算薪月份
		String salary_month = xzz.getXzyf();//算薪月份
				
		//基本工资,岗位津贴,应出勤天数,实出勤天数,事假,病假
		double base_salary = 0;//底薪######
		double base_pay = 0;//基本工资
		
		double post_allowance = 0;//岗位津贴
		double attendance_days = 0;//应出勤天数
//		double actual_attendance_days = 0;//实出勤天数
		double matter_leave = 0;//事假
		double sick_leave = 0;//病假
		double absenteeism_days = 0;//旷工天数
		double personal_income_tax = 0;//个税
		double other_deductions = 0;//其他扣除
		double wages_payable = 0;//应发工资
		double late_cs = 0;//迟到次数
		double leave_early_cs = 0;//早退次数
		double late_sc = 0;//迟到时长
		double leave_early_sc = 0;//早退时长
		
		double achievement_bonus = 0;//绩效奖金##
		double performance_commission = 0;//业绩提成###
		double pre_taxmakediff = 0;//税前补差###
		
		double matter_leave_deduction = 0;//事假扣款
		double sick_leave_deduction = 0;//病假扣款
		double secretary_ling = 0;//司龄
		double grsb = 0;//个人社保
		double grgjj = 0;//个人公积金
		double net_salary = 0;//实发工资
		
		int matter_leave_num = 0;//事假次数
		int sick_leave_num = 0;//病假次数
		
		//薪资组内成员
		for(XcglAssoXzury pag : paygrlist) {
			
			//存在的计薪规则组项数据对应   写入薪资表
			for(XcglAssoJsgzzx xzx : sjbt) {
				if(xzx.getRulestate() == 1 && xzx.getIsCustom() == 0 && xzx.getOptionid() == 0 && xzx.getSalaryitem().equals("底薪")) {
					XcglAssoXzb xzb = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
					base_salary = xzb.getXzxjg();
				}
				if(xzx.getRulestate() == 1 && xzx.getIsCustom() == 0 && xzx.getOptionid() == 0 && xzx.getSalaryitem().equals("岗位津贴")) {
					XcglAssoXzb xzb = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
					post_allowance = xzb.getXzxjg();
				}
				
				XcglAssoXzb xzb = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
				
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 10) { attendance_days = xzb.getXzxjg(); }//实出勤天数
//				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 11) { actual_attendance_days = xzb.getXzxjg(); }//实出勤天数
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 32) { 
						matter_leave = xzb.getXzxjg(); //
						
						HolidayInquiryDto balance = xcglassoxzbmapper.HolidayamountNum(orgcode, salary_month, 1, pag.getUserid()); 
						matter_leave_num = balance.getNum();
				}//事假
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 34) { 
					sick_leave = xzb.getXzxjg(); //
					
					HolidayInquiryDto balance = xcglassoxzbmapper.HolidayamountNum(orgcode, salary_month, 3, pag.getUserid()); 
					sick_leave_num = balance.getNum();
				}//病假
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 12) { absenteeism_days = xzb.getXzxjg(); }//旷工天数
				
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 46) { achievement_bonus = xzb.getXzxjg(); }//绩效奖金
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 47) { performance_commission = xzb.getXzxjg(); }//业绩提成
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 49) { pre_taxmakediff = xzb.getXzxjg(); }//税前补差
				
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 72) { other_deductions = xzb.getXzxjg(); }//其他扣除
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 13) { late_cs = xzb.getXzxjg(); }//迟到次数
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 14) { leave_early_cs = xzb.getXzxjg(); }//早退次数
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 18) { late_sc = xzb.getXzxjg(); }//迟到时长
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 22) { leave_early_sc = xzb.getXzxjg(); }//早退时长
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 50) { grsb = xzb.getXzxjg(); }//个人社保
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 51) { grgjj = xzb.getXzxjg(); }//个人公积金
				
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 43) {//司龄
					YgglMainEmp xzrz = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getEmpNum, pag.getUserid()).eq(YgglMainEmp::getOrgCode, orgcode));
					int entry_date = Integer.valueOf(ClockInTool.SunNovCSTY(xzrz.getRzTime()));//yyyy
					if(Integer.valueOf(strY) - entry_date >= 0) {
						secretary_ling = Integer.valueOf(strY) - entry_date;
					}
					XcglAssoXzb.builder().xzxjg(secretary_ling).build().update(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
				}
				
				//基本工资
				if(xzx.getRulestate().equals(3) && xzx.getIsCustom() == 0 && xzx.getOptionid() == 73) {
					double result = 0;
					//计薪规则组项中自定义项
					List<XcglAssoJsgzzx> zdyx =  XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, calcomtiondto.getPay_group_id()).eq(XcglAssoJsgzzx::getIsCustom, 1));
					String formula = xzx.getGsgs();//#底薪#+#岗位津贴#？
					String qaz = formula.replace("#底薪#", String.valueOf(base_salary)).replace("#岗位津贴#", String.valueOf(post_allowance));
						
					for(XcglAssoJsgzzx zdy : zdyx) {
						double custom_ = 0;//自定义
						boolean status = qaz.contains("#"+zdy.getSalaryitem()+"#");//公式中是否存在自定义
						if(status) {//存在
							XcglAssoJsgzzx zdygsx = XcglAssoJsgzzx.builder().build().selectOne(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getRulestate, 4).eq(XcglAssoJsgzzx::getIsCustom, 1)
									.eq(XcglAssoJsgzzx::getOptionid, 0).eq(XcglAssoJsgzzx::getSalaryitem, zdy.getSalaryitem()));
							XcglAssoXzb xzb_custom = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, zdygsx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
							custom_ = xzb_custom.getXzxjg();
							qaz = qaz.replace("#"+zdy.getSalaryitem()+"#", String.valueOf(custom_));
						}
					}
					boolean status = qaz.contains("#");//再次确认公式中是否存在系统数据项
					if(status) {
						List<XcglAssoJsgzzx> system_zdyx =  XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, calcomtiondto.getPay_group_id())
								.eq(XcglAssoJsgzzx::getIsCustom, 0).ne(XcglAssoJsgzzx::getType, 1));
						for(XcglAssoJsgzzx sys : system_zdyx) {
							if(qaz.contains("#"+sys.getSalaryitem()+"#")) {
								XcglAssoXzb xzb_custom = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, sys.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
								double custom_two = xzb_custom.getXzxjg();
								qaz = qaz.replace("#"+sys.getSalaryitem()+"#", String.valueOf(custom_two));
							}
						}
					}
					
					if(!qaz.contains("#")) {
						result = Double.valueOf(String.valueOf(js.eval(qaz)));
					}else {
						System.err.println(xzx.getOptionid() + ":"+qaz+"有误！！！");
					}
					
					
					base_pay = result;
					XcglAssoXzb.builder().xzxjg(result).build().update(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
					
				}
				
				
				//公式计算
				//(固定公式计算)：迟到早退扣款、事假扣款、病假扣款、旷工扣款、司龄工资、应发工资、实发工资
				if(xzx.getRulestate().equals(2)) {
					double result = 0;
					if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 31) {//司龄工资
						String formula = xzx.getGsgs();//#司龄#*100
						String qaz = formula.replace("#司龄#", String.valueOf(secretary_ling));
						result = Double.valueOf(String.valueOf(js.eval(qaz)));
					}
					if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 27) {//事假扣款
						String formula = xzx.getGsgs();//#基本工资#/#应出勤天数#*#事假天数#      
						
						if(xzx.getGsid() == 3) {//事假天数
							matter_leave = matter_leave/prescription;//转化天数
							String qaz = formula.replace("#基本工资#", String.valueOf(base_pay)).replace("#应出勤天数#", String.valueOf(attendance_days)).replace("#事假天数#", String.valueOf(matter_leave));
						    if(attendance_days > 0) {
						    	result = SalaryTool.formatDouble_(Double.valueOf(String.valueOf(js.eval(qaz))));
						    }
						}else if(xzx.getGsid() == 4) {//事假次数  #事假次数#*200
							String qaz = formula.replace("#事假次数#", String.valueOf(matter_leave_num));
						    if(attendance_days > 0) {
						    	result = SalaryTool.formatDouble_(Double.valueOf(String.valueOf(js.eval(qaz))));
						    }
						}
					    
					    matter_leave_deduction = result;
					}
					if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 28) {//病假扣款
						String formula = xzx.getGsgs();//#基本工资#/#应出勤天数#*#病假天数#*0.4     
						
						if(xzx.getGsid() == 5) {//病假天数
							sick_leave = sick_leave/prescription;//转化天数
							String qaz = formula.replace("#基本工资#", String.valueOf(base_pay)).replace("#应出勤天数#", String.valueOf(attendance_days)).replace("#病假天数#", String.valueOf(sick_leave));
							if(attendance_days > 0) {
								result = SalaryTool.formatDouble_(Double.valueOf(String.valueOf(js.eval(qaz))));
							}
						}else if(xzx.getGsid() == 6) {//病假次数   #病假次数#*100
							String qaz = formula.replace("#病假次数#", String.valueOf(sick_leave_num));
						    if(attendance_days > 0) {
						    	result = SalaryTool.formatDouble_(Double.valueOf(String.valueOf(js.eval(qaz))));
						    }
						}
						
					    sick_leave_deduction = result;
					}
					if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 29) {//旷工扣款
						String formula = xzx.getGsgs();//#基本工资#/#应出勤天数#*#旷工天数#*3    #旷工天数#*100
						String qaz = formula.replace("#基本工资#", String.valueOf(base_pay)).replace("#应出勤天数#", String.valueOf(attendance_days)).replace("#旷工天数#", String.valueOf(absenteeism_days));
						if(attendance_days > 0) {
							result = SalaryTool.formatDouble(Double.valueOf(String.valueOf(js.eval(qaz))));
						}
					}
					if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 30) {//迟到早退扣款
						String qaz = "";
						if(xzx.getGsid().equals(1)) {
							String formula = xzx.getGsgs();//#迟到次数#*20+#早退次数#*15
							qaz = formula.replace("#迟到次数#", String.valueOf(late_cs)).replace("#早退次数#", String.valueOf(leave_early_cs));
						}else {
							String formula = xzx.getGsgs();//#迟到时长#*10+#早退时长#*5
							qaz = formula.replace("#迟到时长#", String.valueOf(late_sc)).replace("#早退时长数#", String.valueOf(leave_early_sc));
						}
						if(!("").equals(qaz)) {
							result = SalaryTool.formatDouble_(Double.valueOf(String.valueOf(js.eval(qaz))));
						}
					}
					
					XcglAssoXzb.builder().xzxjg(result).build().update(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
				}
				
				//应发工资
				if(xzx.getRulestate().equals(2) && xzx.getIsCustom() == 0 && xzx.getOptionid() == 48) {
					String formula = xzx.getGsgs();//#基本工资#+#绩效奖金#+#业绩提成#+#税前补差#-#事假扣款#-#病假扣款#
					String qaz = formula.replace("#基本工资#", String.valueOf(base_pay)).replace("#绩效奖金#", String.valueOf(achievement_bonus))
							.replace("#业绩提成#", String.valueOf(performance_commission)).replace("#税前补差#", String.valueOf(pre_taxmakediff))
							.replace("#事假扣款#", String.valueOf(matter_leave_deduction)).replace("#病假扣款#", String.valueOf(sick_leave_deduction));
				    double result = SalaryTool.formatDouble(Double.valueOf(String.valueOf(js.eval(qaz))));
				    wages_payable = result;
				    
				    XcglAssoXzb.builder().xzxjg(result).build().update(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
				}else if(xzx.getRulestate() == 3 && xzx.getIsCustom() == 0 && xzx.getOptionid() == 48) {//(自定义公式计算): 应发工资
					double result = 0;
					//计薪规则组项中自定义项
					List<XcglAssoJsgzzx> zdyx =  XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, calcomtiondto.getPay_group_id()).eq(XcglAssoJsgzzx::getIsCustom, 1));
					String formula = xzx.getGsgs();//#基本工资#+#绩效奖金#+#业绩提成#+#税前补差#-#事假扣款#-#病假扣款#?
					String qaz = formula.replace("#基本工资#", String.valueOf(base_pay)).replace("#绩效奖金#", String.valueOf(achievement_bonus))
							.replace("#业绩提成#", String.valueOf(performance_commission)).replace("#税前补差#", String.valueOf(pre_taxmakediff))
							.replace("#事假扣款#", String.valueOf(matter_leave_deduction)).replace("#病假扣款#", String.valueOf(sick_leave_deduction));
						
					for(XcglAssoJsgzzx zdy : zdyx) {
						double custom_ = 0;//自定义
						boolean status = qaz.contains("#"+zdy.getSalaryitem()+"#");//公式中是否存在自定义
						if(status) {//存在
							XcglAssoJsgzzx zdygsx = XcglAssoJsgzzx.builder().build().selectOne(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getRulestate, 4).eq(XcglAssoJsgzzx::getIsCustom, 1)
									.eq(XcglAssoJsgzzx::getOptionid, 0).eq(XcglAssoJsgzzx::getSalaryitem, zdy.getSalaryitem()));
							XcglAssoXzb xzb_custom = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, zdygsx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
							custom_ = xzb_custom.getXzxjg();
							qaz = qaz.replace("#"+zdy.getSalaryitem()+"#", String.valueOf(custom_));
						}
					}
					boolean status = qaz.contains("#");//再次确认公式中是否存在系统数据项
					if(status) {
						List<XcglAssoJsgzzx> system_zdyx =  XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, calcomtiondto.getPay_group_id())
								.eq(XcglAssoJsgzzx::getIsCustom, 0).ne(XcglAssoJsgzzx::getType, 1));
						for(XcglAssoJsgzzx sys : system_zdyx) {
							if(qaz.contains("#"+sys.getSalaryitem()+"#")) {
								XcglAssoXzb xzb_custom = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, sys.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
								double custom_two = xzb_custom.getXzxjg();
								qaz = qaz.replace("#"+sys.getSalaryitem()+"#", String.valueOf(custom_two));
							}
						}
					}
					
					if(!qaz.contains("#")) {
						result = SalaryTool.formatDouble_(Double.valueOf(String.valueOf(js.eval(qaz))));
					}else {
						System.err.println(xzx.getOptionid() + ":"+qaz+"有误！！！");
					}
					
					wages_payable = result;
					XcglAssoXzb.builder().xzxjg(result).build().update(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
				}
				
				
				
				if(xzx.getIsCustom() == 0 && xzx.getOptionid() == 69) {//个税
					//个税计算
					try {
						personal_income_tax = CalculationOfIndividualIncomeTax(String.valueOf(pag.getUserid()), salary_month, orgcode, wages_payable, other_deductions);
					} catch (ParseException e) {
						e.printStackTrace();
						System.out.println("个税计算错误");
					}
					double result = personal_income_tax < 0 ? 0.0 : personal_income_tax;
					XcglAssoXzb.builder().xzxjg(SalaryTool.formatDouble_(result)).build().update(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
				}
				
				
				//实发工资
				if(xzx.getRulestate().equals(2) && xzx.getIsCustom() == 0 && xzx.getOptionid() == 70) {
					String formula = xzx.getGsgs();//#应发工资#-#个人社保#-#个人公积金#-#个税#
					String qaz = formula.replace("#应发工资#", String.valueOf(wages_payable)).replace("#个人社保#", String.valueOf(grsb)).replace("#个人公积金#", String.valueOf(grgjj)).replace("#个税#", String.valueOf(personal_income_tax < 0 ? 0.0 : personal_income_tax));
					double result = SalaryTool.formatDouble(Double.valueOf(String.valueOf(js.eval(qaz))));
					net_salary = result;
					
					XcglAssoXzb.builder().xzxjg(result).build().update(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
				}else if(xzx.getRulestate().equals(3) && xzx.getIsCustom() == 0 && xzx.getOptionid() == 70) {
					double result = 0;
					//计薪规则组项中自定义项
					List<XcglAssoJsgzzx> zdyx =  XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, calcomtiondto.getPay_group_id()).eq(XcglAssoJsgzzx::getIsCustom, 1));
					String formula = xzx.getGsgs();//#应发工资#-#个人社保#-#个人公积金#-#个税#
					String qaz = formula.replace("#应发工资#", String.valueOf(wages_payable)).replace("#个人社保#", String.valueOf(grsb)).replace("#个人公积金#", String.valueOf(grgjj)).replace("#个税#", String.valueOf(personal_income_tax < 0 ? 0.0 : personal_income_tax));
					
					for(XcglAssoJsgzzx zdy : zdyx) {
						double custom_ = 0;//自定义
						boolean status = qaz.contains("#"+zdy.getSalaryitem()+"#");//公式中是否存在自定义
						if(status) {//存在
							XcglAssoJsgzzx zdygsx = XcglAssoJsgzzx.builder().build().selectOne(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getRulestate, 4).eq(XcglAssoJsgzzx::getIsCustom, 1)
									.eq(XcglAssoJsgzzx::getOptionid, 0).eq(XcglAssoJsgzzx::getSalaryitem, zdy.getSalaryitem()));
							XcglAssoXzb xzb_custom = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, zdygsx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
							custom_ = xzb_custom.getXzxjg();
							qaz = qaz.replace("#"+zdy.getSalaryitem()+"#", String.valueOf(custom_));
						}
					}
					boolean status = qaz.contains("#");//再次确认公式中是否存在系统数据项
					if(status) {
						List<XcglAssoJsgzzx> system_zdyx =  XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, calcomtiondto.getPay_group_id())
								.eq(XcglAssoJsgzzx::getIsCustom, 0).ne(XcglAssoJsgzzx::getType, 1));
						for(XcglAssoJsgzzx sys : system_zdyx) {
							if(qaz.contains("#"+sys.getSalaryitem()+"#")) {
								XcglAssoXzb xzb_custom = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, sys.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
								double custom_two = xzb_custom.getXzxjg();
								qaz = qaz.replace("#"+sys.getSalaryitem()+"#", String.valueOf(custom_two));
							}
						}
					}
					
					if(!qaz.contains("#")) {
						result = SalaryTool.formatDouble_(Double.valueOf(String.valueOf(js.eval(qaz))));
					}else {
						System.err.println(xzx.getOptionid() + ":"+qaz+"有误！！！");
					}
					net_salary = result;
					
					XcglAssoXzb.builder().xzxjg(result).build().update(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getXzxid, xzx.getId()).eq(XcglAssoXzb::getUserid, pag.getUserid()));
				}
				
			}//存在的计薪规则组项数据对应   写入薪资表  --结束
			
			XcglAssoGztzt.builder().build().delete(new QueryWrapper<XcglAssoGztzt>().lambda().eq(XcglAssoGztzt::getUserid, pag.getUserid()).eq(XcglAssoGztzt::getXzyf, salary_month)
					.eq(XcglAssoGztzt::getQyid, orgcode));
			
			//xcgl_asso_gztzt
			XcglAssoGztzt gzt = XcglAssoGztzt.builder().build();
			gzt.setUserid(pag.getUserid());
			gzt.setXzyf(salary_month);//薪资月
			gzt.setFsType(0);
			gzt.setCkType(0);
			gzt.setQrType(0);
			gzt.setFkyj(null);
			gzt.setYhqm(null);
			gzt.setSfgz(net_salary);
			gzt.setQyid(orgcode);
			gzt.setXzzid(calcomtiondto.getPay_group_id());
			gzt.insert();
		}//薪资组内成员--结束
		
		return ResultUtil.data(null, "计算完成");
	}
	
	/**
	 * 个税计算明细
	 * @param gsus 用户id
	 * @param salary_month 计算薪资月
	 * @param orgcode 企业id
	 * @param wages_payable 应发工资
	 * @param other_deductions 其他扣除
	 * @return
	 * @throws ParseException 
	 */
	public double CalculationOfIndividualIncomeTax(String gsus,String salary_month,int orgcode,double wages_payable,double other_deductions) throws ParseException {
		double personalincome = 0;
		String strY = new SimpleDateFormat("yyyy").format(new Date());
		
		XcglAssoGsjsmx.builder().build().delete(new QueryWrapper<XcglAssoGsjsmx>().lambda().eq(XcglAssoGsjsmx::getUserNum, gsus).eq(XcglAssoGsjsmx::getSalaryMonth, salary_month)
				.eq(XcglAssoGsjsmx::getQyid, orgcode));
		
		//当月个税存在则直接获取  无则根据计算薪资月的上月个税为基准计算
		XcglAssoGsjsmx dyxzgs = XcglAssoGsjsmx.builder().build().selectOne(new QueryWrapper<XcglAssoGsjsmx>().lambda().eq(XcglAssoGsjsmx::getUserNum, gsus).eq(XcglAssoGsjsmx::getQyid, orgcode)
				.eq(XcglAssoGsjsmx::getSalaryMonth, salary_month));
		if(dyxzgs != null) {
			personalincome = dyxzgs.getThmonthPersonal();
		}else {
			//#（上月）# 对应薪资月的-1 个税对标数据     （九月工资：对应8月的个税来计算九月的个税）
			XcglAssoGsjsmx sygs = XcglAssoGsjsmx.builder().build().selectOne(new QueryWrapper<XcglAssoGsjsmx>().lambda().eq(XcglAssoGsjsmx::getUserNum, gsus).eq(XcglAssoGsjsmx::getQyid, orgcode)
					.eq(XcglAssoGsjsmx::getSalaryMonth, SalaryTool.getfirstlastMo(salary_month+"-01 00:00:00")));
			
			boolean status = salary_month.contains("-01");
			double childrenedu_ = 0;//累计子女教育
			double houseloans_ = 0;//累计住房贷款利息
			double houserents_ = 0;//累计住房租金
			double supportolder_ = 0;//累计赡养老人
			double continueedu_ = 0;//累计继续教育
			double totalmoney_ = 0;//累计专项附加扣除
			if(!status && sygs != null) {
				childrenedu_ = sygs.getCumZljy(); 
				houseloans_ = sygs.getCumZfdklx();  
				houserents_ = sygs.getCumZfzj();  
				supportolder_ = sygs.getCumSylr();
				continueedu_ = sygs.getCumJxjy(); 
				totalmoney_ = sygs.getCumZxfjkc();  
			}
			YgglMainEmp yh = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getEmpNum, gsus).eq(YgglMainEmp::getOrgCode, orgcode));
			//对应算薪月份的专项附加扣除
			XcglAssoZxfjkc zxf = XcglAssoZxfjkc.builder().build().selectOne(new QueryWrapper<XcglAssoZxfjkc>().lambda().eq(XcglAssoZxfjkc::getUserid, gsus)
					.eq(XcglAssoZxfjkc::getQyid, orgcode).eq(XcglAssoZxfjkc::getTaxmonth, salary_month));
			//写入个税明细表*****************
			XcglAssoGsjsmx gsmx = XcglAssoGsjsmx.builder().build();
			gsmx.setUserNum(gsus);//用户id
			gsmx.setUserName(yh.getName());//用户姓名
			gsmx.setSalaryMonth(salary_month);//薪资月
			//报税周期：(1:当月报税；2:次月报税)
			XcglAssoBszqsz bssz = XcglAssoBszqsz.builder().build().selectOne(new QueryWrapper<XcglAssoBszqsz>().lambda().eq(XcglAssoBszqsz::getQyid, orgcode));
			String taxmonth = "";
			if(bssz.getTaxReturnCycle().equals(1)) {
				taxmonth = salary_month;
			}else{
				taxmonth = SalaryTool.getfirstnextMo(salary_month+"-01 00:00:00");
			}
			gsmx.setTaxMonth(taxmonth);//税款所属月份
			gsmx.setCumZljy(zxf == null ? 0 : (zxf.getChildrenedu() == null ? 0 : zxf.getChildrenedu()) + childrenedu_);//累计子女教育
			gsmx.setCumZfdklx(zxf == null ? 0 : (zxf.getHouseloans() == null ? 0 : zxf.getHouseloans()) + houseloans_);//累计住房贷款利息
			gsmx.setCumZfzj(zxf == null ? 0 : (zxf.getHouserents() == null ? 0 : zxf.getHouserents()) + houserents_);//累计住房租金
			gsmx.setCumSylr(zxf == null ? 0 : (zxf.getSupportolder() == null ? 0 : zxf.getSupportolder()) + supportolder_);//累计赡养老人
			gsmx.setCumJxjy(zxf == null ? 0 : (zxf.getContinueedu() == null ? 0 : zxf.getContinueedu()) + continueedu_);//累计继续教育
			gsmx.setCumZxfjkc(zxf == null ? 0 : (zxf.getTotalmoney() == null ? 0 : zxf.getTotalmoney()) + totalmoney_);//累计专项附加扣除
			gsmx.setTaxType("工资薪金所得");//计税类型
			gsmx.setCurrentIncome(wages_payable);//本期收入  【应发工资】
				SbgjjAssoYjzd cuspde = sbgjjassoyjzdmapper.IndividualTotalsbgjj(gsus, orgcode, salary_month);
			gsmx.setCurrentSpecialDeduction(cuspde == null ? 0 : Double.valueOf(cuspde.getGrjltotal()));//本期专项扣除 【个人的社保公积金缴纳扣除】
			gsmx.setCumSre(wages_payable+(sygs == null ? 0 : sygs.getCumSre()));//累计收入额 【本期收入+累计收入额(上月)】
			double cumjcfy = 0;			
			if(sygs != null && sygs.getCumJcfy() > 0) {
				cumjcfy = sygs.getCumJcfy() + 5000;
			}else {
				int xcy = 0;
				YgglMainEmp xzrz = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getEmpNum, gsus).eq(YgglMainEmp::getOrgCode, orgcode));
				if(xzrz != null) {
//					String entry_date = ClockInTool.SunNovCSTYMD(xzrz.getRzTime());//yyyyMMdd
					String entry_date = ClockInTool.SunNovCSTYM(xzrz.getRzTime());//yyyyMM
					if(bssz.getTaxReturnCycle().equals(1)) {//当月报税
						if(entry_date.substring(0,4).equals(strY)) {//判断是否是本年
							xcy = SalaryTool.getMonthDiff(entry_date+"-01", salary_month+"-01");
						}else {
							xcy = SalaryTool.getMonthDiff(strY+"-01-01", salary_month+"-01");
						}
						cumjcfy = xcy*5000;
					}else {//次月报税
						if(entry_date.substring(0,4).equals(strY)) {//判断是否是本年
							xcy = SalaryTool.getMonthDiff(entry_date+"-01", salary_month+"-01")+1;
						}else {
							xcy = SalaryTool.getMonthDiff(strY+"-01-01", salary_month+"-01")+1;
						}
						cumjcfy = xcy*5000;
					}
				}
			}
			gsmx.setCumJcfy(cumjcfy);//累计减除费用 【5000*在职月份数】
			
			gsmx.setCumZxkc((cuspde == null ? 0 : Double.valueOf(cuspde.getGrjltotal())) + (sygs == null ? 0 : sygs.getCumZxkc()));//累计专项扣除 【本期专项扣除+累计专项扣除(上月)】
			gsmx.setCumQtkc(other_deductions+(sygs == null ? 0 : sygs.getCumQtkc()));//累计其他扣除 【其他扣除+累计其他扣除(上月)】
			
			double cumynssde = 0;
			cumynssde = gsmx.getCumSre() - cumjcfy - gsmx.getCumZxkc() - gsmx.getCumZxfjkc() - gsmx.getCumQtkc();
			gsmx.setCumYnssde(SalaryTool.formatDouble_(cumynssde));//累计应纳税所得额 【累计收入额-累计减除费用-累计专项扣除-累计专项附加扣除-累计其他扣除】
			
			String[] miscalculation = getPersonalincometax(cumynssde);
			gsmx.setTaxRate(Double.valueOf(miscalculation[0]));//税率
			gsmx.setQuickCalculationDeduction(Double.valueOf(miscalculation[1]));//速算扣除数
			gsmx.setCumYnse(SalaryTool.formatDouble_(Double.valueOf(miscalculation[2])));//累计应纳税额 【累计应纳税所得额*税率-速算扣除数】
			
			double cumyyjse = 0;
			cumyyjse = (sygs == null ? 0 : sygs.getCumYyjse()) + (sygs == null ? 0 : sygs.getCumYbtse());
			gsmx.setCumYyjse(cumyyjse);//累计已预缴纳税额 【累计已预缴税额(上月)+累计应补（退）税额（上月）】
			
			double cumybtse = 0;
			cumybtse = gsmx.getCumYnse() - gsmx.getCumYyjse();
			gsmx.setCumYbtse(SalaryTool.formatDouble_(cumybtse));//累计应补（退）税额（本月个税）   【累计应纳税额-累计已预缴纳税额】
			gsmx.setThmonthPersonal(SalaryTool.formatDouble_(cumybtse));//本月个税
			gsmx.setQyid(orgcode);//企业id
			gsmx.insert();
			
			if(cumybtse > 0) {
				personalincome = cumybtse;
			}
			
		}
		return personalincome;
	}
	
	
	/**
	 * 计算个税
	 * @param taxpayroll 累计应纳税所得额
	 */
	public String[] getPersonalincometax(double taxpayroll){
		String[] perinctax = new String[3];
		List<XcglAssoTaxFormula> taxratelist = XcglAssoTaxFormula.builder().build().selectList(new QueryWrapper<XcglAssoTaxFormula>().lambda().eq(XcglAssoTaxFormula::getQyid, 0));
		double personalIncomeTax=0;//个税
		double money=36000;//应交税工资最低点
		if(taxpayroll>0){//应交税
			for (XcglAssoTaxFormula  tax : taxratelist) {//计算个税
				if(tax.getTaxablestart()<=taxpayroll&&taxpayroll<tax.getTaxableend()){
					//个人所得税=计税工资*税率-速算扣除数
					BigDecimal aa = new BigDecimal(tax.getTaxrate());
					BigDecimal bb = new BigDecimal(100);
					double taxrate = aa.divide(bb,2,BigDecimal.ROUND_HALF_UP).doubleValue();
					personalIncomeTax = taxpayroll*taxrate-tax.getDeductions();
					
					perinctax[0] = String.valueOf(tax.getTaxrate());//税率
					perinctax[1] = String.valueOf(tax.getDeductions());//速算扣除数
					perinctax[2] = String.valueOf(SalaryTool.formatDouble(personalIncomeTax));//累计应纳税额
				}
			}
		}else{
			
			perinctax[0] = "0";
			perinctax[1] = "0";
			perinctax[2] = "0";
		}
		return perinctax;
	}
	
	
	@GetMapping(value = "/gettaxreturncycle")
	@ApiOperation(value = "查询报税周期信息", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> gettaxreturncycle(@CurrentUser UserBean userBean) {
		XcglAssoBszqsz bszq = XcglAssoBszqsz.builder().build().selectOne(new QueryWrapper<XcglAssoBszqsz>().lambda().eq(XcglAssoBszqsz::getQyid, userBean.getOrgCode()));
		if(bszq == null) {
			XcglAssoBszqsz.builder().taxReturnCycle(1).qyid(userBean.getOrgCode()).build().insert();
		}
		bszq = XcglAssoBszqsz.builder().build().selectOne(new QueryWrapper<XcglAssoBszqsz>().lambda().eq(XcglAssoBszqsz::getQyid, userBean.getOrgCode()));
		
		return ResultUtil.data(bszq, "完成");
	}
	
	

	/**
	 * 	新增/修改--报税周期信息
	 */
	@PostMapping(value = "/taxreturncycle")
	@ApiOperation(value = "新增/修改--报税周期信息", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> Taxreturncycle(@CurrentUser UserBean userBean,@RequestBody XcglAssoBszqsz xcglassobszqsz) {
		xcglassobszqsz.setQyid(userBean.getOrgCode());
		return xcglassobszqsz.insertOrUpdate() ? ResultUtil.success("操作成功!") : ResultUtil.error("操作失败!");
	}
	
	
	/** 构建薪资组
	 * @param userBean
	 * @param budpaygr
	 * @return
	 */
	@PostMapping(value = "/buildpaygroup")
	@ApiOperation(value = "构建薪资组", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> Buildpaygroup(@CurrentUser UserBean userBean, @RequestBody BuildPayGroupDto budpaygr) {
		Integer empNum = userBean.getEmpNum();
		Integer orgCode = userBean.getOrgCode();
		
		Calendar lastm = Calendar.getInstance();
		lastm.setTime(SalaryTool.strToDateLong(budpaygr.getXzyf() + "-01 00:00:00")); // 设置为当前时间
		lastm.set(Calendar.MONTH, lastm.get(Calendar.MONTH) - 1);
		String lastmonth = new SimpleDateFormat("yyyy-MM").format(lastm.getTime());// 上
		
		String thismonth = budpaygr.getXzyf();// 本
		
		Calendar calendar = Calendar.getInstance();
		calendar.setTime(SalaryTool.strToDateLong(budpaygr.getXzyf() + "-01 00:00:00")); // 设置为当前时间
		calendar.set(Calendar.MONTH, calendar.get(Calendar.MONTH) + 1);
		String nextMonth = new SimpleDateFormat("yyyy-MM").format(calendar.getTime());// 下
		
		//查询系统现有的薪资组
		List<XcglAdminXzz> xcxz = XcglAdminXzz.builder().build().selectList(new QueryWrapper<XcglAdminXzz>().lambda().eq(XcglAdminXzz::getQyid, userBean.getOrgCode()));
		for(XcglAdminXzz xzz : xcxz) {
			
			XcglAdminXzz xcglxzz = XcglAdminXzz.builder().build();
			xcglxzz.setName(xzz.getName());// 薪资组命名
			xcglxzz.setPayperiod(xzz.getPayperiod());// 算薪月周期 0：上月；1：当月
			xcglxzz.setPaydayperiod(xzz.getPaydayperiod());// 算薪日周期 全月
			String payper = String.format("%02d", xzz.getPaydayperiod());
			String payrollcycle = null;
			if (xzz.getPayperiod() == 0) {// 上月
				if (xzz.getPaydayperiod() == 1) {
					payrollcycle = SalaryTool.getfirstlastTwo(budpaygr.getXzyf() + "-01 00:00:00") + "到" + SalaryTool.getlastlastTwo(budpaygr.getXzyf() + "-01 00:00:00");
				} else {
					String firstnext = lastmonth + "-" + payper;
					int jgs = xzz.getPaydayperiod() - 1;
					String lastnext = thismonth + "-" + String.format("%02d", jgs);
					payrollcycle = firstnext + "到" + lastnext;
				}
			} else {// 当月
				if (xzz.getPaydayperiod() == 1) {
					payrollcycle = SalaryTool.getfirstnowTwo(budpaygr.getXzyf() + "-01 00:00:00") + "到" + SalaryTool.getlastnowTwo(budpaygr.getXzyf() + "-01 00:00:00");
				} else {
					String firstnow = thismonth + "-" + payper;
					int jgs = xzz.getPaydayperiod() - 1;
					String lastnow = nextMonth + "-" + String.format("%02d", jgs);
					payrollcycle = firstnow + "到" + lastnow;
				}
			}
			xcglxzz.setPayrollcycle(payrollcycle);// 算薪周期
			xcglxzz.setDeletestate(1);// 状态 0：已删除；1：使用中
			xcglxzz.setCountstate(0);// 计算状态 0：未计算；1：已计算
			xcglxzz.setPxfs(xzz.getPxfs());// 选择配薪方式(0:	空白模板；df：默认)
			xcglxzz.setAdduserid(empNum);// 员工工号
			xcglxzz.setQyid(orgCode);// 企业编码
			xcglxzz.setAddtime(new Date().getTime());// 添加时间
			xcglxzz.setMonthtime(budpaygr.getXzyf());//薪资月份
			xcglxzz.setXzyf(payrollcycle.substring(0, 7));//算薪月份
			xcgladminxzzmapper.insert(xcglxzz);
			int payid = xcglxzz.getId();
			
			
			//从其他薪资组复制规则
			/*****************/
			//未加入分组
			List<XcglAssoJsgzzx> wjrfzlist = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getXzzid, xzz.getId()).eq(XcglAssoJsgzzx::getJxgzid,0).list();
			
			List<XcglAssoJsgzzx> wjrfzzzxlist = new ArrayList<XcglAssoJsgzzx>();
			for(XcglAssoJsgzzx zxs : wjrfzlist) {
				XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
				zzx.setSalaryitem(zxs.getSalaryitem());//薪资项
				zzx.setYhmbzd(zxs.getYhmbzd());//银行模板项 需与银行一一对应
				zzx.setRule(zxs.getRule());//规则
				zzx.setType(zxs.getType());//类型 1：系统项；2：非系统项
				zzx.setAddtime(new Date().getTime());//添加时间
				zzx.setAdduserid(empNum);//添加人员id
				zzx.setJxgzid(zxs.getJxgzid());//计薪规则组id 0：未加入组
				zzx.setRemarks(zxs.getRemarks());//备注
				zzx.setGsid(zxs.getGsid());//公式id  0：未关联规则
				zzx.setGsgs(zxs.getGsgs());//公式格式 系统提供/自定义公式
				zzx.setXzzid(payid);
				zzx.setRulestate(zxs.getRulestate());//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
				
				zzx.setOptionid(zxs.getOptionid());
				
				zzx.setDygk(zxs.getDygk());//公式变量值1
				zzx.setDegk(zxs.getDegk());//公式变量值2
				wjrfzzzxlist.add(zzx);
			}
			if(wjrfzzzxlist.size() > 0) {
				xcglassojsgzzxmapper.insertxcglassojsgzzxList(wjrfzzzxlist);
			}
			/*************/
			
			//计薪规则组
			List<XcglAssoJxgz> jxgzlist = new LambdaQueryChainWrapper<XcglAssoJxgz>(xcglassojxgzmapper).eq(XcglAssoJxgz::getXzzid, xzz.getId()).list();
			@SuppressWarnings("unused")
			List<XcglAssoJxgz> jxgzs = new ArrayList<XcglAssoJxgz>();
			for(XcglAssoJxgz jxgzl : jxgzlist) {
				XcglAssoJxgz jxgz = new XcglAssoJxgz();
				jxgz.setXzzid(payid);
				jxgz.setName(jxgzl.getName());
				jxgz.setRemarks(jxgzl.getRemarks());
				jxgz.setAddtime(new Date().getTime());
				jxgz.setAdduserid(empNum);
				jxgz.setQyid(orgCode);
//				jxgzs.add(jxgz);
				xcglassojxgzmapper.jxgzinsert(jxgz);
				int jxgzid = jxgz.getId();
				
				List<XcglAssoJsgzzx> yjrfzlist = new LambdaQueryChainWrapper<XcglAssoJsgzzx>(xcglassojsgzzxmapper).eq(XcglAssoJsgzzx::getXzzid, xzz.getId()).eq(XcglAssoJsgzzx::getJxgzid,jxgzl.getId()).list();
				if(yjrfzlist.size() > 0) {
					List<XcglAssoJsgzzx> yjrfzzzxlist = new ArrayList<XcglAssoJsgzzx>();
					for(XcglAssoJsgzzx yzxs : yjrfzlist) {
						XcglAssoJsgzzx zzx = XcglAssoJsgzzx.builder().build();
						zzx.setSalaryitem(yzxs.getSalaryitem());//薪资项
						zzx.setYhmbzd(yzxs.getYhmbzd());//银行模板项 需与银行一一对应
						zzx.setRule(yzxs.getRule());//规则
						zzx.setType(yzxs.getType());//类型 1：系统项；2：非系统项
						zzx.setAddtime(new Date().getTime());//添加时间
						zzx.setAdduserid(empNum);//添加人员id
						zzx.setJxgzid(jxgzid);//计薪规则组id 0：未加入组
						zzx.setRemarks(yzxs.getRemarks());//备注
						zzx.setGsid(yzxs.getGsid());//公式id  0：未关联规则
						zzx.setGsgs(yzxs.getGsgs());//公式格式 系统提供/自定义公式
						zzx.setXzzid(payid);
						zzx.setRulestate(yzxs.getRulestate());//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
						zzx.setOptionid(yzxs.getOptionid());
						
						zzx.setDygk(yzxs.getDygk());//公式变量值1
						zzx.setDegk(yzxs.getDegk());//公式变量值2
						yjrfzzzxlist.add(zzx);
					}
					if(yjrfzzzxlist.size() > 0) {
						xcglassojsgzzxmapper.insertxcglassojsgzzxList(yjrfzzzxlist);
					}
				}
			}
		
			
			List<XcglAssoXzury> zxzus = XcglAssoXzury.builder().build().selectList(new QueryWrapper<XcglAssoXzury>().lambda().eq(XcglAssoXzury::getXzzid, xzz.getId()));
			
			List<XcglAssoXzury> xcgllist = new ArrayList<XcglAssoXzury>();
		
			for (XcglAssoXzury xzr : zxzus) {
//				xcglassoxzurymapper.deleteByuseridoqyid(Integer.valueOf(attser[u]), orgCode);
				XcglAssoXzury kquser = new XcglAssoXzury();
				kquser.setXzzid(payid);// 薪资组id
				kquser.setUserid(xzr.getUserid());
				kquser.setQyid(orgCode);
				xcgllist.add(kquser);
			}
			
			if (xcgllist.size() > 0) {
				xcglassoxzurymapper.insertxcglassoxzuryList(xcgllist);
			}
			
		}//循环结束
		
		
		
		return ResultUtil.data(null, "完成");
	}
	
	
	
	/**
	 *	同步考勤   XXXXXXX
	 */
	@GetMapping(value = "/SynchroAtt/{id}/{xzyf}")
	@ApiOperation(value = "同步考勤", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult SynchroAttendance(@CurrentUser UserBean userBean,@PathVariable Integer id,@PathVariable String xzyf) {
		//已知薪资组id****
		//规则状态[0：系统自动提取；1：系统固定值；2：固定公式计算；3：自定义公式计算；4：每月自动导入]
		//薪资组信息
		XcglAdminXzz xzz = new LambdaQueryChainWrapper<XcglAdminXzz>(xcgladminxzzmapper).eq(XcglAdminXzz::getId, id).one();
		//薪资组项--考勤
		List<XcglAssoJsgzzx> attsect = xcglassojsgzzxmapper.selectSalarySectionList(id);
		//当前薪资组内人员
		List<XcglAssoXzury> znrys = new LambdaQueryChainWrapper<XcglAssoXzury>(xcglassoxzurymapper).eq(XcglAssoXzury::getXzzid, id).eq(XcglAssoXzury::getQyid,userBean.getOrgCode()).list();
		if(znrys.size() > 0) {//该薪资组有成员
			for(XcglAssoXzury znr:znrys) {
				//删除已经计算的考勤薪资
				xcglassoxzbmapper.deleteByAttendance(znr.getUserid(), id,xzyf);
				//计算得出考勤相关数据
				AttendanceReport attrep = getAttendanceReport(userBean.getOrgCode(),znr.getUserid(),xzz.getPayrollcycle());
				
				for(XcglAssoJsgzzx payatt:attsect) {//查询同步考勤时所需要的字段
					if(payatt.getOptionid() > 0) {//说明阔以根据表查出结果
						XcglAssoOption lbcx = new LambdaQueryChainWrapper<XcglAssoOption>(xcglassooptionmapper).eq(XcglAssoOption::getId,payatt.getOptionid()).one();
						if(lbcx.getFieldname() != null && !lbcx.getFieldname().equals("")) {//关于考勤的只有 -- 字段名：“fieldname”
							@SuppressWarnings("unused")
							String tablename = lbcx.getTablename();//对应库表名
							String fieldname = lbcx.getFieldname();//对应库字段名
							
							int autacq = 0;
							if(fieldname.equals("days_duty")) {//应出勤天数
								autacq = attrep.getAnswerday();
							}else if(fieldname.equals("actual_days")) {//实际出勤天数
								autacq = attrep.getActualday();
							}else if(fieldname.equals("rest_days")) {//休息天数
								autacq = attrep.getRestday();
							}else if(fieldname.equals("gzsc")) {//工作时长
								autacq = attrep.getWorkhours();
							}else if(fieldname.equals("late_num")) {//迟到次数
								autacq = attrep.getLatenum();
							}else if(fieldname.equals("late_time")) {//迟到时长
								autacq = attrep.getLatehours();
							}else if(fieldname.equals("absen_days ")) {//矿工天数
								autacq = attrep.getMinerday();
							}else if(fieldname.equals("early_num")) {//早退次数
								autacq = attrep.getLeanum();
							}else if(fieldname.equals("early_time")) {//早退时长
								autacq = attrep.getLeahours();
							}else if(fieldname.equals("sbqk_num")) {//上班缺卡次数
								autacq = attrep.getGoworkmissingcard();
							}else if(fieldname.equals("xbqk_num")) {//下班缺卡次数
								autacq = attrep.getOffworkmissingcard();
							}
							
							//入[薪资表]
					        XcglAssoXzb xzb = XcglAssoXzb.builder().build();
							xzb.setUserid(znr.getUserid());//用户id
							xzb.setXzyf(xzyf);//薪资月
							xzb.setXzxid(payatt.getId());//薪资项id
							xzb.setXzxjg(Double.valueOf(autacq));//薪资项结果
							xzb.setQyid(userBean.getOrgCode());
							xcglassoxzbmapper.xzbinsert(xzb);
						}else {
							
							//入[薪资表]
					        XcglAssoXzb xzb = XcglAssoXzb.builder().build();
							xzb.setUserid(znr.getUserid());//用户id
							xzb.setXzyf(xzyf);//薪资月
							xzb.setXzxid(payatt.getId());//薪资项id
							xzb.setXzxjg(0.0);//薪资项结果
							xzb.setQyid(userBean.getOrgCode());
							xcglassoxzbmapper.xzbinsert(xzb);
							
						}
					}
				}
				
				
			}
			
			//计算完成 返回数据
//			List<CalculationDto> jswsj = xcglassoxzbmapper.CalculationResults(id,userBean.getOrgCode());
			CheckSalaryStaffDto checksalary = new CheckSalaryStaffDto();
			checksalary.setPaygroupid(id);
			checksalary.setXzyf(xzyf);
			checksalary.setOrgcode(userBean.getOrgCode());
			List<CalculationDto> jswsj = xcglassoxzbmapper.CalculationResults(checksalary);
			
			return new ResponseResult().success("考勤数据同步成功", jswsj);
			
		}else {//该组无人
			return new ResponseResult().error("请先添加算薪人员");
		}
		
	}
	
	
	/***************/
	/***考勤****/
	/**
	 * @param orgCode 企业id
	 * @param userid	用户id	
	 * @param payrolldate 计薪日期
	 * @return
	 */
	public AttendanceReport getAttendanceReport(int orgCode,int userid,String payrolldate) {
		
		String start = payrolldate.substring(0, 10);
		String end = payrolldate.substring(11, 21);
		
		Calendar cal = Calendar.getInstance();
		int year = cal.get(Calendar.YEAR);
		int month = cal.get(Calendar.MONTH) + 1;
		int date = cal.get(Calendar.DATE);
		
	    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		
		Long startDate = 0l;
		Long endDate = 0l;
		

	   try {
		   String sdaet = SalaryTool.getMinMonthDate(start);
		   startDate = DateUtil.getStartTime(0,DateUtil.getStringTime(sdaet,"yyyy-MM-dd")).getTime();
		       
		   String edate = SalaryTool.getMaxMonthDate(end);
		   endDate = DateUtil.getnowEndTime(23,DateUtil.getStringTime(edate,"yyyy-MM-dd")).getTime();
		} catch (ParseException e) {
			e.printStackTrace();
		}
	
		int gzsc = punchcarddetailsservice.selectWorkingHours(userid,startDate,endDate);
		
		List<PunchRecord> initial = punchrecordservice.getMaintenancePunchCardList(startDate,endDate,userid,orgCode);
		int latenum = 0;// 迟到次数
		int latehours = 0;// 迟到时长
		int leanum = 0;// 早退次数
		int leahours = 0;// 早退时长
		if(initial.size() > 0){
			for(PunchRecord prd : initial){
				if(prd.getType() == 1 && prd.getResults() > 0){
					latenum++;
					latehours += prd.getResults();
				}
				if(prd.getType() == 2 && prd.getResults() > 0){
					leanum++;
					leahours += prd.getResults();
				}
			}
		}
		
		AttendanceReport attrep = new AttendanceReport();
		attrep.setId(0);
		attrep.setName("");//姓名
		attrep.setJobnumber(userid);//工号
		attrep.setWorkhours(gzsc);//工作时长
		
		attrep.setLatenum(latenum);//
		attrep.setLatehours(latehours);//
		attrep.setLeanum(leanum);//
		attrep.setLeahours(leahours);//
		/**********/
		AttendanceGroup attgro = attendancegroupservice.getAttendanceGroupInformationByUserid(userid,orgCode); //考勤组信息
		//pbfs;// 排班方式 1：固定排班；2：自由排班；3：自由工时
		if(attgro != null){//该员工是否加入到考勤组
			if(attgro.getPbfs() == 1){
				//当前月     必须打卡日期
				List<SpecialDate> bxdklist = specialdateservice.ShouldSpecialDatessetByKqzid(attgro.getId(),startDate,endDate);
				int bxdk = bxdklist.size();
				//当前月     无需打卡日期
				List<SpecialDate> wxdk = specialdateservice.RestSpecialDatessetByKqzid(attgro.getId(),startDate,endDate);
				String[] appmaps= new String[wxdk.size()];
				int d1 = 0;
				for(SpecialDate spe:wxdk){
					appmaps[d1] = spe.getTsrq();
					d1++;
				}
				List<AttendanceWeeklySch> atwek = attendanceweeklyschservice.selectAttendanceMadeByUserid(userid,orgCode);
				String[] week= new String[atwek.size()];
				int e = 0;
				for(AttendanceWeeklySch awek : atwek){
					week[e] = awek.getWekmc();
					e++;
				}
				String yemo = year + "-" + month;
				String datetime = year + "-" + month + "-" + date;
				SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
				sdf1.setLenient(false);
				SimpleDateFormat sdf2 = new SimpleDateFormat("EEE");
				try {
					Date parse = sdf.parse(datetime);
					Calendar lastDate = Calendar.getInstance();
					 lastDate.setTime(parse);
					 lastDate.set(Calendar.DATE, 1);
					 lastDate.add(Calendar.MONTH, 1);
					 lastDate.add(Calendar.DATE, -1);
				} catch (ParseException e1) {
					e1.printStackTrace();
				}
				int y = 0;
				int q = 0;
				 for(int i = 1; i <= SalaryTool.getDaysByYearMonth(year,month); i++){
					 try {
						Date date1 = sdf1.parse(yemo + "-" + i);
						for(int u=0;u<week.length;u++){
							if(sdf2.format(date1).equals(week[u])){
								
								q++;
								
								y++;
								if(Arrays.asList(appmaps).contains(String.valueOf(sdf1.format(date1)))){
									y = y-1;
								}
							}
						}
					} catch (ParseException c) {
						c.printStackTrace();
					}
				 }
				 
				 int xiuxi = SalaryTool.getDaysByYearMonth(year,month) - q - bxdk + wxdk.size();
				 attrep.setRestday(xiuxi);//休息天数
				 attrep.setAnswerday(y+bxdk);//应出勤
				/***********/
			}else if(attgro.getPbfs() == 2){
				List<Schedule> ycqs = scheduleservice.getAttendanceShouldList(userid,startDate,endDate);
				int xiuxi = 0;
				int shangban = 0;
				for(Schedule sc : ycqs){
					if(sc.getBcid().equals(0)){
						xiuxi++;
					}else{
						shangban++;
					}
				}
				attrep.setRestday(xiuxi);//休息天数
				attrep.setAnswerday(shangban);//应出勤
			}else{
				List<AttendanceWeeklySch> atwek = attendanceweeklyschservice.selectAttendanceMadeByUserid(userid,orgCode);
				String[] week= new String[atwek.size()];
				int e = 0;
				for(AttendanceWeeklySch awek : atwek){
					week[e] = awek.getWekmc();
					e++;
				}
				String yemo = year + "-" + month;
				String datetime = year + "-" + month + "-" + date;
				SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
				sdf1.setLenient(false);
				SimpleDateFormat sdf2 = new SimpleDateFormat("EEE");
				try {
					Date parse = sdf.parse(datetime);
					Calendar lastDate = Calendar.getInstance();
					 lastDate.setTime(parse);
					 lastDate.set(Calendar.DATE, 1);
					 lastDate.add(Calendar.MONTH, 1);
					 lastDate.add(Calendar.DATE, -1);
				} catch (ParseException e1) {
					e1.printStackTrace();
				}
				int y = 0;
				 for(int i = 1; i <= SalaryTool.getDaysByYearMonth(year,month); i++){
					 try {
						Date date1 = sdf1.parse(yemo + "-" + i);
						for(int u=0;u<week.length;u++){
							if(sdf2.format(date1).equals(week[u])){
								y++;
							}
						}
					} catch (ParseException c) {
						c.printStackTrace();
					}
				 }
				 
				 int xiuxi = SalaryTool.getDaysByYearMonth(year,month) - y;
				 attrep.setRestday(xiuxi);//休息天数
				 attrep.setAnswerday(y);//应出勤
			}
		    List<PunchCardDetails> attendance = punchcarddetailsservice.selectAttendanceDays(userid, startDate, endDate);//打卡记录
		    attrep.setActualday(attendance.size());//已出勤
			if(attrep.getAnswerday() > 0){
				BigDecimal g = new BigDecimal(attrep.getAnswerday());  
				BigDecimal h = new BigDecimal(attrep.getActualday()); 
				int lack = g.subtract(h).intValue();  
				attrep.setMinerday(lack);//缺勤
			}
            int sbqk = 0;
            int xbqk = 0;
            for(PunchCardDetails pcd:attendance){
            	if(pcd.getYdkcs() == 2 || pcd.getYdkcs() == 4 || pcd.getYdkcs() == 6){
            		if(pcd.getSbdk1() == null){
            			sbqk++;
            		}
            		if(pcd.getXbdk1() == null){
            			xbqk++;
            		}
            	}
            	if(pcd.getYdkcs() == 4 || pcd.getYdkcs() == 6){
            		if(pcd.getSbdk2() == null){
            			sbqk++;
            		}
            		if(pcd.getXbdk2() == null){
            			xbqk++;
            		}
            	}
            	if(pcd.getYdkcs() == 6){
            		if(pcd.getSbdk3() == null){
            			sbqk++;
            		}
            		if(pcd.getXbdk3() == null){
            			xbqk++;
            		}
            	}
            }
            attrep.setGoworkmissingcard(sbqk);//上班缺卡
            attrep.setOffworkmissingcard(xbqk);//下班缺卡
		}
		/**********/
		
		
		return attrep;
			
	}
	
	
	/**
	 *	切换薪资日期
	 */
	@GetMapping(value = "/switchsalarydate/{sxrq}")
	@ApiOperation(value = "切换薪资日期", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult SwitchSalaryDate(@CurrentUser UserBean userBean,@PathVariable String sxrq) {
		List<XcglAdminXzz> xcgladminxzz = new LambdaQueryChainWrapper<XcglAdminXzz>(xcgladminxzzmapper).eq(XcglAdminXzz::getQyid, userBean.getOrgCode()).eq(XcglAdminXzz::getMonthtime, sxrq).list();
		
		return new ResponseResult().success("成功", xcgladminxzz);
	}
	
	
	/**
	 *	切换薪资日期
	 */
//	@GetMapping(value = "/switchsalarydate/{sxrq}")
//	@ApiOperation(value = "切换薪资日期", httpMethod = "GET", notes = "接口发布说明")
//	public ResponseResult SwitchSalaryDate(@CurrentUser UserBean userBean,@PathVariable String sxrq) {
//		List<SwitchSalaryDateDto> ssd = new ArrayList<SwitchSalaryDateDto>();
//		List<XcglAdminXzz> xcgladminxzz = new LambdaQueryChainWrapper<XcglAdminXzz>(xcgladminxzzmapper).eq(XcglAdminXzz::getQyid, userBean.getOrgCode()).list();
//		for(XcglAdminXzz xzx : xcgladminxzz) {
//			XcglAssoXzury isck = xcglassoxzurymapper.selectISswitchdate(xzx.getId(),sxrq);
//			// int payperiod = xzx.getPayperiod();//算薪月周期 0：上月；1：当月
//			// int paydayperiod = xzx.getPaydayperiod();//算薪日周期 全月
//			//输入月份的开始于结束
//			String strstartdate = "";
//			String strendDate = "";
//			String lastmonth = "";
//			String nextMonth = "";
//			
//			String lasstrstartdate = "";
//			String lasstrendDate = "";
//			try {
//			   String date = sxrq+"-01";
//			   String sdaet = SalaryTool.getMinMonthDate(date);
//			   Long startDate = DateUtil.getStartTime(0,DateUtil.getStringTime(sdaet,"yyyy-MM-dd")).getTime();
//			   strstartdate = new SimpleDateFormat("yyyy-MM-dd").format(startDate);// 上
//			   String edate = SalaryTool.getMaxMonthDate(date);
//			   Long endDate = DateUtil.getnowEndTime(23,DateUtil.getStringTime(edate,"yyyy-MM-dd")).getTime();
//			   strendDate = new SimpleDateFormat("yyyy-MM-dd").format(endDate);// 上
//			   
//				String dateStr = date+" 00:00:00";
//				SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//				Date transDate = sdf.parse(dateStr);
//				
//				Calendar lastm = Calendar.getInstance();
//				lastm.setTime(transDate); // 设置为当前时间
//				lastm.set(Calendar.MONTH, lastm.get(Calendar.MONTH) - 1);
//				lastmonth = new SimpleDateFormat("yyyy-MM").format(lastm.getTime());// 上
//				
//				Calendar lastmtow = Calendar.getInstance();
//				lastmtow.setTime(transDate); // 设置为当前时间
//				lastmtow.add(Calendar.MONTH, 1);
//				nextMonth = new SimpleDateFormat("yyyy-MM").format(lastmtow.getTime());// 下
//				
//				String lasdate = lastmonth+"-01";
//			    String sdaetlas = SalaryTool.getMinMonthDate(lasdate);
//			    Long startDatelas = DateUtil.getStartTime(0,DateUtil.getStringTime(sdaetlas,"yyyy-MM-dd")).getTime();
//			    lasstrstartdate = new SimpleDateFormat("yyyy-MM-dd").format(startDatelas);// 上
//			    String edatelas = SalaryTool.getMaxMonthDate(lasdate);
//			    Long endDatelas = DateUtil.getnowEndTime(23,DateUtil.getStringTime(edatelas,"yyyy-MM-dd")).getTime();
//			    lasstrendDate = new SimpleDateFormat("yyyy-MM-dd").format(endDatelas);// 上
//			} catch (ParseException e) {
//				e.printStackTrace();
//			}
//			
//			
//			String payper = String.format("%02d", xzx.getPaydayperiod());
//			String payrollcycle = "";
//			if (xzx.getPayperiod() == 0) {// 上月
//				if (xzx.getPaydayperiod() == 1) {
//					//上个月开始  --- 上个月结束
//					payrollcycle = lasstrstartdate + "到" + lasstrendDate;
//				} else {
//					String firstnext = lastmonth + "-" + payper;
//					int jgs = xzx.getPaydayperiod() - 1;
//					String lastnext = sxrq + "-" + String.format("%02d", jgs);
//					payrollcycle = firstnext + "到" + lastnext;
//				}
//			} else {// 当月
//				if (xzx.getPaydayperiod() == 1) {
//					//本月开始 -- 本月结束
//					payrollcycle = strstartdate + "到" + strendDate;//*********
//				} else {
//					String firstnow = sxrq + "-" + payper;
//					int jgs = xzx.getPaydayperiod() - 1;
//					String lastnow = nextMonth + "-" + String.format("%02d", jgs);
//					payrollcycle = firstnow + "到" + lastnow;
//				}
//			}
//			
//			SwitchSalaryDateDto sds = new SwitchSalaryDateDto();
//			if(isck != null) {
//				sds.setGid(xzx.getId());
//				sds.setState(1);//已计算
//				sds.setCycle(payrollcycle);
//				ssd.add(sds);
//			}else {
//				sds.setGid(xzx.getId());
//				sds.setState(0);//未计算
//				sds.setCycle(payrollcycle);
//				ssd.add(sds);
//			}
//		}
//		
//		return new ResponseResult().success("成功", ssd);
//	}
	
	/**
	 *	获取附加扣除数据
	 */
	@PostMapping(value = "/obtainidedu")
	@ApiOperation(value = "获取附加扣除数据", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult ObtainAdditionalDeduction(@CurrentUser UserBean userBean,@RequestBody SearchSalariedPeopleDto search) {
		search.setOrgcode(userBean.getOrgCode());
		
		List<AdditionalDeductionDto> fjkclist = xcglassozxfjkcmapper.selectAdditionalDeductiontwo(search);
		return new ResponseResult().success("获取附加扣除数据成功", fjkclist);
	}
	
	/**
	 * 	查询列表-获取附加扣除数据-分页
	 */
	@PostMapping(value = "/select_leave_rules")
	@ApiOperation(value = "获取附加扣除数据-分页", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> selectleaverules(@CurrentUser UserBean userBean, @RequestBody SearchSalariedPeopleDto search) {
			IPage<AdditionalDeductionDto> page = new Page<AdditionalDeductionDto>(
			search.getCurrentPage() == null ? 1 : search.getCurrentPage(),
			search.getTotalPage() == null ? 10 : search.getTotalPage());
			
			search.setOrgcode(userBean.getOrgCode());
			
			IPage<AdditionalDeductionDto> pageAs = xcglassozxfjkcmapper.selectAdditionalDeduction(page, search);
			List<AdditionalDeductionDto> listAs = pageAs.getRecords();
			
			return ResultUtil.data(pageAs, listAs, "操作成功!");
	}
	
	
	
	/**
	 *	专项附加扣除
	 */
	@PostMapping(value = "/addduction")
	@ApiOperation(value = "专项附加扣除", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult AdditionalDeduction(@CurrentUser UserBean userBean,@RequestBody XcglAssoZxfjkc xcglas) {
		if(xcglas.getId() == 0) {
			xcglas.setQyid(userBean.getOrgCode());
			xcglas.setAddtime(new Date().getTime());
			xcglassozxfjkcmapper.insertXcglAssoZxfjkc(xcglas);
		}else {
			XcglAssoZxfjkc fjkc = XcglAssoZxfjkc.builder().build();
			fjkc.setId(xcglas.getId());
			fjkc.setChildrenedu(xcglas.getChildrenedu());
			fjkc.setHouseloans(xcglas.getHouseloans());
			fjkc.setHouserents(xcglas.getHouserents());
			fjkc.setSupportolder(xcglas.getSupportolder());
			fjkc.setContinueedu(xcglas.getContinueedu());
			fjkc.setTotalmoney(xcglas.getTotalmoney());
			xcglassozxfjkcmapper.updateXcglAssoZxfjkc(fjkc);
		}
		
		
		return new ResponseResult().success("成功", xcglas);
	}

	@GetMapping(value = "/payslip/{id}/{sxrq}")
	@ApiOperation(value = "工资条", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult EnterPayslip(@CurrentUser UserBean userBean,@PathVariable Integer id,@PathVariable String sxrq) {
		int xscgztszid = 0;
		XcglAssoGztsz xscid = new LambdaQueryChainWrapper<XcglAssoGztsz>(xcglassogztszmapper).eq(XcglAssoGztsz::getQyid, userBean.getOrgCode())
				.eq(XcglAssoGztsz::getGztyf, sxrq).eq(XcglAssoGztsz::getXzzid,id).one();
		if(xscid != null) {
			xscgztszid = xscid.getId();
			xcglassogztszmapper.deletexcglassogztsz(sxrq,id);
		}
		
		XcglAdminXzz xzz = new LambdaQueryChainWrapper<XcglAdminXzz>(xcgladminxzzmapper).eq(XcglAdminXzz::getQyid, userBean.getOrgCode()).eq(XcglAdminXzz::getId, id).one();
		
		XcglAssoGztsz gztsz = XcglAssoGztsz.builder().build();
		gztsz.setMbmc(sxrq+"工资条（"+xzz.getName()+"）");//模板名称
		gztsz.setGztyf(sxrq);
		gztsz.setIsWxts(1);//温馨提示开关 （0：关；1：开）
		gztsz.setWxtslr("工资条属于敏感信息，请注意保密");//温馨提示内容
		gztsz.setTop(0);//实发金额（头部显示） 实发金额是指员工实际到手的工资，将显示在员工工资条的顶部蓝色区域
		gztsz.setIsYcksj(0);//隐藏空数据项开关-（0：关；1：开） 在员工收到的工资条上，隐藏数值为空（或数值为0）的薪资项
		gztsz.setXsxzx("");//显示薪资项（数组）
		gztsz.setIsYhjf(0);//阅后即焚开关-（0：关；1：开） 在员工查看工资条一定时间之后，将变为不可查阅
		gztsz.setYhjfdw(1);//阅后即焚单位 1：分钟；2：小时；3：天
		gztsz.setYhjfTime("");//阅后即焚时间（分钟）
		gztsz.setQmqr(0);//签名确认-（0：关；1：开） 开启后，员工确认工资条时需要手写签名
		gztsz.setIsYgfk(0);//员工反馈开关-（0：关；1：开） 允许员工在工资条上反馈工资问题
		gztsz.setXzzid(id);//薪资组id
		gztsz.setQyid(userBean.getOrgCode());//企业id
		xcglassogztszmapper.insertxcglassogztsz(gztsz);
		int gztszid = gztsz.getId();
		
		if(xscgztszid > 0) {
			xcglassogztztmapper.deletexcglassogztzt(xscgztszid);//
		}
		
		List<PayrollExceptionDto> payrolllist = xcgladminxzzmapper.PayrollException(userBean.getOrgCode(), id, sxrq);
		List<XcglAssoGztzt> gztzs = new ArrayList<XcglAssoGztzt>();
		for(PayrollExceptionDto ped:payrolllist) {
			XcglAssoGztzt gztz = XcglAssoGztzt.builder().build();
			gztz.setUserid(ped.getUserid());//用户ID
			gztz.setXzyf(ped.getXzyf());//薪资月
			gztz.setFsType(0);//发送状态 0：未发送 1：已发送
			gztz.setCkType(0);//查看状态 0：未 1：已
			gztz.setQrType(0);//确认状态 0：未 1：已
			gztz.setFkyj("");//反馈意见
			gztz.setYhqm("");//用户签名
			gztz.setQyid(userBean.getOrgCode());
			gztz.setGztszid(gztszid);
			gztzs.add(gztz);
		}
		
		if(gztzs.size()>0) {
			xcglassogztztmapper.insertxcglassogztztList(gztzs);
		}
		
		
		return new ResponseResult().success("成功", gztzs);
	}

	
	@PostMapping(value = "/paysliplist")
	@ApiOperation(value = "工资条数据", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult Paysliplist(@CurrentUser UserBean userBean,@RequestBody InspersonnelDto inspers) {
		List<PayslipListDto> paydan = new ArrayList<PayslipListDto>();
		List<XcglAssoGztsz> gztzlist = new LambdaQueryChainWrapper<XcglAssoGztsz>(xcglassogztszmapper).eq(XcglAssoGztsz::getQyid, userBean.getOrgCode()).eq(XcglAssoGztsz::getGztyf, inspers.getTitle()).list();
		for(XcglAssoGztsz dzts:gztzlist) {
			PayslipListDto pagz = new PayslipListDto();
			pagz.setGztszid(dzts.getId());
			pagz.setGztname(dzts.getMbmc());
			pagz.setGztyf(dzts.getGztyf());
			pagz.setXzzid(dzts.getXzzid());
			List<XcglAssoGztzt> zrs = new LambdaQueryChainWrapper<XcglAssoGztzt>(xcglassogztztmapper).eq(XcglAssoGztzt::getQyid, userBean.getOrgCode())
					.eq(XcglAssoGztzt::getGztszid, dzts.getId()).list();
			if(zrs.size() > 0) {
				pagz.setUsertotal(zrs.size());//
			}else {
				pagz.setUsertotal(0);//
			}
			
			List<XcglAssoGztzt> yfs = new LambdaQueryChainWrapper<XcglAssoGztzt>(xcglassogztztmapper).eq(XcglAssoGztzt::getQyid, userBean.getOrgCode())
					.eq(XcglAssoGztzt::getGztszid, dzts.getId()).eq(XcglAssoGztzt::getFsType,1).list();
			if(yfs.size() > 0) {
				pagz.setYfsnum(yfs.size());
			}else {
				pagz.setYfsnum(0);
			}
			
			List<XcglAssoGztzt> yck = new LambdaQueryChainWrapper<XcglAssoGztzt>(xcglassogztztmapper).eq(XcglAssoGztzt::getQyid, userBean.getOrgCode())
					.eq(XcglAssoGztzt::getGztszid, dzts.getId()).eq(XcglAssoGztzt::getCkType,1).list();
			if(yck.size()>0) {
				pagz.setYckrs(yck.size());
			}else {
				pagz.setYckrs(0);
			}
			
			List<XcglAssoGztzt> yqr = new LambdaQueryChainWrapper<XcglAssoGztzt>(xcglassogztztmapper).eq(XcglAssoGztzt::getQyid, userBean.getOrgCode())
					.eq(XcglAssoGztzt::getGztszid, dzts.getId()).eq(XcglAssoGztzt::getQrType,1).list();
			if(yqr.size()>0) {
				pagz.setYqrrs(yqr.size());
			}else {
				pagz.setYqrrs(0);
			}
			
			paydan.add(pagz);
		}
		
		return new ResponseResult().success("成功", paydan);
	}
	
	@PostMapping(value = "/payslipSearch")
	@ApiOperation(value = "工资条搜索", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult payslipSearch(@CurrentUser UserBean userBean, @RequestBody PayslipSearchDto dto) {
		dto.setOrgcode(userBean.getOrgCode());
		List<PayslipDetailsDto> paydetlist = xcglassogztztmapper.payslipSearch(dto);
		return new ResponseResult().success("成功", paydetlist);
	}
	
	
	/**
	 * 	删除工资条
	 */
	@DeleteMapping(value = "/deletepayslip/{id}")
	@ApiOperation(value = "删除工资条", httpMethod = "DELETE", notes = "接口发布说明")
	public ResponseResult Deletepayslip(@PathVariable Integer id) {
		
		XcglAssoGztsz.builder().build().deleteById(id);
		xcglassogztztmapper.deletexcglassogztzt(id);//
		
		return new ResponseResult().success("删除成功", id);
	}
	
	@GetMapping(value = "/payslipsetti/{id}")
	@ApiOperation(value = "获取工资条设置", httpMethod = "GET", notes = "接口发布说明")
	public ResponseResult PayslipSetti(@CurrentUser UserBean userBean,@PathVariable Integer id) {  
		XcglAssoGztsz gztz = new LambdaQueryChainWrapper<XcglAssoGztsz>(xcglassogztszmapper).eq(XcglAssoGztsz::getQyid, userBean.getOrgCode()).eq(XcglAssoGztsz::getId, id).one(); 
		return new ResponseResult().success("成功", gztz);
	}
	
	
	
	@PutMapping(value = "/modifypayslip")
	@ApiOperation(value = "修改工资条", httpMethod = "PUT", notes = "接口发布说明")
	public ResponseResult ModifyPayslip(@CurrentUser UserBean userBean, @RequestBody ModifyPayslipDto modifypay) {
		
		XcglAssoGztsz gztz = XcglAssoGztsz.builder().build();
		gztz.setId(modifypay.getId());
//		gztz.setMbmc(mbmc);//模板名称
		if(modifypay.getSwitchs()) {
			gztz.setIsWxts(1);//温馨提示开关
			gztz.setWxtslr(modifypay.getTip());//温馨提示内容
		}else {
			gztz.setIsWxts(0);//温馨提示开关
			gztz.setWxtslr("");//温馨提示内容
		}
		gztz.setTop(modifypay.getSfje());//实发金额（头部显示）
		if(modifypay.getYc()) {
			gztz.setIsYcksj(1);//隐藏空数据项开关
		}else {
			gztz.setIsYcksj(0);//隐藏空数据项开关
		}
//		gztz.setXsxzx(xsxzx);//显示薪资项（数组）
		if(modifypay.getYhjf()) {
			gztz.setIsYhjf(1);//阅后即焚开关 在员工查看工资条一定时间之后，将变为不可查阅
			gztz.setYhjfTime(modifypay.getJfinp());//阅后即焚时间（分钟） 
			gztz.setYhjfdw(modifypay.getJfsel());//阅后即焚单位 1：分钟；2：小时；3：天
		}else {
			gztz.setIsYhjf(0);//阅后即焚开关 在员工查看工资条一定时间之后，将变为不可查阅
			gztz.setYhjfTime("");//阅后即焚时间（分钟） 
			gztz.setYhjfdw(1);//阅后即焚单位 1：分钟；2：小时；3：天
		}
		if(modifypay.getAutograph()) {
			gztz.setQmqr(1);//签名确认 开启后，员工确认工资条时需要手写签名
		}else{
			gztz.setQmqr(0);//签名确认 开启后，员工确认工资条时需要手写签名
		}
		
		if(modifypay.getFeedback()) {
			gztz.setIsYgfk(1);//员工反馈开关 允许员工在工资条上反馈工资问题
		}else {
			gztz.setIsYgfk(0);//员工反馈开关 允许员工在工资条上反馈工资问题
		}
		gztz.updateById();
		
		return new ResponseResult().success("成功", gztz);
	}
	
	
	
	//###################################################################################################################
	
	/**	
	 * 导入专项附加扣除
	 */
	@PostMapping(value = "/import_special_additional_deduction")
	@ApiOperation(value = "导入专项附加扣除", httpMethod = "POST", notes = "接口发布说明")
	public Result<ImportDescriptionDto> importSpecialAdditionalDeduction(@CurrentUser UserBean userBean,
			@Validated @RequestBody ValidList<SpecialDeductionDto> specialdeductiondto) throws Exception {

		Integer orgCode = userBean.getOrgCode();

		int toinsert = 0;//新增
		int toupdate = 0;//更新
		int failure = 0;//失败
		List<Map<String, String>> reasons = Lists.newArrayList();
		for (SpecialDeductionDto spec : specialdeductiondto) {
			String name = spec.getName();
			String phone = spec.getPhone();
			String date = spec.getDate();
			Map<String, String> map = Maps.newHashMap();
			try {
				YgglMainEmp ygl = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getName, name)
						.eq(YgglMainEmp::getPhone, phone).eq(YgglMainEmp::getOrgCode, orgCode));

				XcglAssoZxfjkc xcg = XcglAssoZxfjkc.builder().build().selectOne(new QueryWrapper<XcglAssoZxfjkc>().lambda().eq(XcglAssoZxfjkc::getTaxmonth, date)
						.eq(XcglAssoZxfjkc::getQyid, userBean.getOrgCode()).eq(XcglAssoZxfjkc::getUserid, ygl.getEmpNum()));

				if(xcg == null) {
					XcglAssoZxfjkc xcglas = XcglAssoZxfjkc.builder().build();
					xcglas.setUserid(ygl.getEmpNum());
					xcglas.setTaxmonth(date);
					xcglas.setChildrenedu(Double.valueOf(spec.getZljy()));//子女教育
					xcglas.setHouseloans(Double.valueOf(spec.getZfdk()));//住房贷款利息
					xcglas.setHouserents(Double.valueOf(spec.getZfzj()));//住房租金
					xcglas.setSupportolder(Double.valueOf(spec.getSylr()));//赡养老人
					xcglas.setContinueedu(Double.valueOf(spec.getJxjy()));//继续教育

					BigDecimal num1 = new BigDecimal(spec.getZljy());
					BigDecimal num2 = new BigDecimal(spec.getZfdk());
					double result1 = num1.add(num2).doubleValue();
					BigDecimal num3 = new BigDecimal(result1);
					BigDecimal num4 = new BigDecimal(spec.getZfzj());
					double result2 = num3.add(num4).doubleValue();

					BigDecimal num5 = new BigDecimal(result2);
					BigDecimal num6 = new BigDecimal(spec.getSylr());
					double result3 = num5.add(num6).doubleValue();

					BigDecimal num7 = new BigDecimal(result3);
					BigDecimal num8 = new BigDecimal(spec.getJxjy());
					double result = num7.add(num8).doubleValue();

					xcglas.setTotalmoney(result);//累计专项附加扣除
					xcglas.setQyid(userBean.getOrgCode());
					xcglas.setAddtime(new Date().getTime());
					xcglassozxfjkcmapper.insertXcglAssoZxfjkc(xcglas);
					toinsert++;
				}else {
					XcglAssoZxfjkc fjkc = XcglAssoZxfjkc.builder().build();
					fjkc.setId(xcg.getId());
					fjkc.setChildrenedu(Double.valueOf(spec.getZljy()));//子女教育
					fjkc.setHouseloans(Double.valueOf(spec.getZfdk()));//住房贷款利息
					fjkc.setHouserents(Double.valueOf(spec.getZfzj()));//住房租金
					fjkc.setSupportolder(Double.valueOf(spec.getSylr()));//赡养老人
					fjkc.setContinueedu(Double.valueOf(spec.getJxjy()));//继续教育

					BigDecimal num1 = new BigDecimal(spec.getZljy());
					BigDecimal num2 = new BigDecimal(spec.getZfdk());
					double result1 = num1.add(num2).doubleValue();
					BigDecimal num3 = new BigDecimal(result1);
					BigDecimal num4 = new BigDecimal(spec.getZfzj());
					double result2 = num3.add(num4).doubleValue();

					BigDecimal num5 = new BigDecimal(result2);
					BigDecimal num6 = new BigDecimal(spec.getSylr());
					double result3 = num5.add(num6).doubleValue();

					BigDecimal num7 = new BigDecimal(result3);
					BigDecimal num8 = new BigDecimal(spec.getJxjy());
					double result = num7.add(num8).doubleValue();

					fjkc.setTotalmoney(Double.valueOf(result));//累计专项附加扣除
					xcglassozxfjkcmapper.updateXcglAssoZxfjkc(fjkc);
					toupdate++;
				}
			} catch (Exception e) {
				failure++;
				map.put("name", name);
				map.put("msg", StringUtils.isBlank(e.getMessage()) ? "必填数据出现空值" : e.getMessage());
			} finally {
				reasons.add(map);
			}
		}
		ImportDescriptionDto imds = new ImportDescriptionDto();
		imds.setSuccess(toinsert + toupdate);//成功
		imds.setToinsert(toinsert);
		imds.setToupdate(toupdate);//更新
		imds.setFailure(failure);//失败
		imds.setReasons(reasons);
		return ResultUtil.data(imds, "成功");
	}
	
	
	
	/**	
	 * 导入个税明细
	 */
	@PostMapping(value = "/individual_income_tax_details")
	@ApiOperation(value = "导入个税明细", httpMethod = "POST", notes = "接口发布说明")
	public Result<ImportDescriptionDto> IndividualIncomeTaxDetails(@CurrentUser UserBean userBean,
			@Validated @RequestBody ValidList<IndividualTaxDetailsDto> individualtaxdetailsdto) throws Exception {
		
		Integer orgCode = userBean.getOrgCode();
		
		int toinsert = 0;//新增
		int toupdate = 0;//更新
		int failure = 0;//失败
		
		List<Map<String, String>> reasons = Lists.newArrayList();
		for (IndividualTaxDetailsDto indv : individualtaxdetailsdto) {
			String userName = indv.getUserName();
			String phone = indv.getPhone();
			String date = indv.getSalaryMonth();//薪资月
			Map<String, String> map = Maps.newHashMap();
			try {
				XcglAssoBszqsz bssz = XcglAssoBszqsz.builder().build().selectOne(new QueryWrapper<XcglAssoBszqsz>().lambda().eq(XcglAssoBszqsz::getQyid, orgCode));
				String taxmonth = "";
				if(bssz.getTaxReturnCycle().equals(1)) {
//					taxmonth = indv.getTaxMonth();
					taxmonth = indv.getSalaryMonth();
				}else{
					taxmonth = SalaryTool.getfirstnextMo(indv.getSalaryMonth()+"-01 00:00:00");
				}
				YgglMainEmp ygl = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getName, userName)
						.eq(YgglMainEmp::getPhone, phone).eq(YgglMainEmp::getOrgCode, orgCode));
				
				if(ygl != null) {
					XcglAssoGsjsmx gsjs = XcglAssoGsjsmx.builder().build().selectOne(new QueryWrapper<XcglAssoGsjsmx>().lambda().eq(XcglAssoGsjsmx::getUserNum, ygl.getEmpNum())
							.eq(XcglAssoGsjsmx::getQyid, ygl.getOrgCode()).eq(XcglAssoGsjsmx::getSalaryMonth, date));
					
					if(gsjs == null) {
						XcglAssoGsjsmx gsgs = XcglAssoGsjsmx.builder().build();
						gsgs.setUserNum(String.valueOf(ygl.getEmpNum()));
						gsgs.setUserName(indv.getUserName());
						gsgs.setSalaryMonth(indv.getSalaryMonth());
						gsgs.setTaxMonth(taxmonth);//税款所属月份
						gsgs.setThmonthPersonal(indv.getThmonthPersonal() == null ? null : Double.valueOf(indv.getThmonthPersonal()));
						gsgs.setCumZljy(indv.getCumZljy() == null ? null : Double.valueOf(indv.getCumZljy()));
						gsgs.setCumZfdklx(indv.getCumZfdklx() == null ? null : Double.valueOf(indv.getCumZfdklx()));
						gsgs.setCumZfzj(indv.getCumZfzj() == null ? null : Double.valueOf(indv.getCumZfzj()));
						gsgs.setCumSylr(indv.getCumSylr() == null ? null : Double.valueOf(indv.getCumSylr()));
						gsgs.setCumJxjy(indv.getCumJxjy() == null ? null : Double.valueOf(indv.getCumJxjy()));
						gsgs.setCumZxfjkc(indv.getCumZxfjkc() == null ? null : Double.valueOf(indv.getCumZxfjkc()));
						gsgs.setTaxType(indv.getTaxType());
						gsgs.setCurrentIncome(indv.getCurrentIncome() == null ? null : Double.valueOf(indv.getCurrentIncome()));
						gsgs.setCurrentSpecialDeduction(indv.getCurrentSpecialDeduction() == null ? null : Double.valueOf(indv.getCurrentSpecialDeduction()));
						gsgs.setCumSre(indv.getCumSre() == null ? null : Double.valueOf(indv.getCumSre()));
						gsgs.setCumJcfy(indv.getCumJcfy() == null ? null : Double.valueOf(indv.getCumJcfy()));
						gsgs.setCumZxkc(indv.getCumZxkc() == null ? null : Double.valueOf(indv.getCumZxkc()));
						gsgs.setCumQtkc(indv.getCumQtkc() == null ? null : Double.valueOf(indv.getCumQtkc()));
						gsgs.setCumYnssde(indv.getCumYnssde() == null ? null : Double.valueOf(indv.getCumYnssde()));
						gsgs.setTaxRate(indv.getTaxRate() == null ? null : Double.valueOf(indv.getTaxRate()));
						gsgs.setQuickCalculationDeduction(indv.getQuickCalculationDeduction() == null ? null : Double.valueOf(indv.getQuickCalculationDeduction()));
						gsgs.setCumYnse(indv.getCumYnse() == null ? null : Double.valueOf(indv.getCumYnse()));
						gsgs.setCumYyjse(indv.getCumYyjse() == null ? null : Double.valueOf(indv.getCumYyjse()));
						gsgs.setCumYbtse(indv.getCumYbtse() == null ? null : Double.valueOf(indv.getCumYbtse()));
						gsgs.setQyid(ygl.getOrgCode());
						gsgs.insert();
						toinsert++;
					}else {
						XcglAssoGsjsmx gsgs = XcglAssoGsjsmx.builder().build();
						gsgs.setUserNum(String.valueOf(ygl.getEmpNum()));
						gsgs.setUserName(indv.getUserName());
						gsgs.setSalaryMonth(indv.getSalaryMonth());
						gsgs.setTaxMonth(taxmonth);//税款所属月份
						gsgs.setThmonthPersonal(indv.getThmonthPersonal() == null ? null : Double.valueOf(indv.getThmonthPersonal()));
						gsgs.setCumZljy(indv.getCumZljy() == null ? null : Double.valueOf(indv.getCumZljy()));
						gsgs.setCumZfdklx(indv.getCumZfdklx() == null ? null : Double.valueOf(indv.getCumZfdklx()));
						gsgs.setCumZfzj(indv.getCumZfzj() == null ? null : Double.valueOf(indv.getCumZfzj()));
						gsgs.setCumSylr(indv.getCumSylr() == null ? null : Double.valueOf(indv.getCumSylr()));
						gsgs.setCumJxjy(indv.getCumJxjy() == null ? null : Double.valueOf(indv.getCumJxjy()));
						gsgs.setCumZxfjkc(indv.getCumZxfjkc() == null ? null : Double.valueOf(indv.getCumZxfjkc()));
						gsgs.setTaxType(indv.getTaxType());
						gsgs.setCurrentIncome(indv.getCurrentIncome() == null ? null : Double.valueOf(indv.getCurrentIncome()));
						gsgs.setCurrentSpecialDeduction(indv.getCurrentSpecialDeduction() == null ? null : Double.valueOf(indv.getCurrentSpecialDeduction()));
						gsgs.setCumSre(indv.getCumSre() == null ? null : Double.valueOf(indv.getCumSre()));
						gsgs.setCumJcfy(indv.getCumJcfy() == null ? null : Double.valueOf(indv.getCumJcfy()));
						gsgs.setCumZxkc(indv.getCumZxkc() == null ? null : Double.valueOf(indv.getCumZxkc()));
						gsgs.setCumQtkc(indv.getCumQtkc() == null ? null : Double.valueOf(indv.getCumQtkc()));
						gsgs.setCumYnssde(indv.getCumYnssde() == null ? null : Double.valueOf(indv.getCumYnssde()));
						gsgs.setTaxRate(indv.getTaxRate() == null ? null : Double.valueOf(indv.getTaxRate()));
						gsgs.setQuickCalculationDeduction(indv.getQuickCalculationDeduction() == null ? null : Double.valueOf(indv.getQuickCalculationDeduction()));
						gsgs.setCumYnse(indv.getCumYnse() == null ? null : Double.valueOf(indv.getCumYnse()));
						gsgs.setCumYyjse(indv.getCumYyjse() == null ? null : Double.valueOf(indv.getCumYyjse()));
						gsgs.setCumYbtse(indv.getCumYbtse() == null ? null : Double.valueOf(indv.getCumYbtse()));
						gsgs.setQyid(ygl.getOrgCode());
						gsgs.setId(gsjs.getId());
						gsgs.updateById();
						toupdate++;
					}
				}else {
					failure++;
					map.put("name", userName);
					map.put("msg", "员工不存在");
				}
			} catch (Exception e) {
				failure++;
				map.put("name", userName);
				map.put("msg", StringUtils.isBlank(e.getMessage()) ? "必填数据出现空值" : e.getMessage());
			}finally {
				reasons.add(map);
			}
		}
		
		ImportDescriptionDto imds = new ImportDescriptionDto();
		imds.setSuccess(toinsert + toupdate);//成功
		imds.setToinsert(toinsert);
		imds.setToupdate(toupdate);//更新
		imds.setFailure(failure);//失败
		imds.setReasons(reasons);
		
		return ResultUtil.data(imds,"导入个税明细");
	}
	
	
	@Autowired
	private XcglAssoGsjsmxMapper xcglassogsjsmxmapper;
	
	/**
	 * 	查询列表-获取个税明细数据-分页
	 */
	@PostMapping(value = "/individual_income_details")
	@ApiOperation(value = "获取个税明细数据-分页", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> IndividualIncomeDetails(@CurrentUser UserBean userBean, @RequestBody SearchSalariedPeopleDto search) {
			IPage<XcglAssoGsjsmxDto> page = new Page<XcglAssoGsjsmxDto>(
			search.getCurrentPage() == null ? 1 : search.getCurrentPage(),
			search.getTotalPage() == null ? 10 : search.getTotalPage());
			
			search.setOrgcode(userBean.getOrgCode());

			page.setTotal(xcglassogsjsmxmapper.listPageCount(search));
			List<XcglAssoGsjsmxDto> listAs = xcglassogsjsmxmapper.listPage(search);
			
			return ResultUtil.data(page, listAs, "操作成功!");
	}

	/**
	 * 	查询列表-获取个税明细数据
	 */
	@PostMapping(value = "/individual_income_details_all")
	@ApiOperation(value = "获取个税明细数据", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> IndividualIncomeDetailsAll(@CurrentUser UserBean userBean, @RequestBody SearchSalariedPeopleDto search) {
		search.setOrgcode(userBean.getOrgCode());
		List<XcglAssoGsjsmxDto> listAs = xcglassogsjsmxmapper.SelectIndividualincomedetailsAll(search);
		return ResultUtil.data(listAs, "操作成功!");
	}
	
	
	@GetMapping(value="/allyearround/{year}/{usernum}")
	@ApiOperation(value = "获取全年信息", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> AllyearroundList(@CurrentUser UserBean userBean,@PathVariable("year") String year,@PathVariable("usernum") String usernum) {
		
		List<XcglAssoGsjsmx> allyearround = xcglassogsjsmxmapper.Allyearround(year, usernum, userBean.getOrgCode());
		
		return ResultUtil.data(allyearround,"操作成功!");
	}
	
	@GetMapping(value="/justone/{id}")
	@ApiOperation(value = "获取单个信息", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> justone(@CurrentUser UserBean userBean,@PathVariable("id") Integer id) {
		
		XcglAssoGsjsmx allyearround = XcglAssoGsjsmx.builder().id(id).build().selectById();
		
		return ResultUtil.data(allyearround,"操作成功!");
	}
	
	@PostMapping(value = "/modifyindividualincometaxdetails")
	@ApiOperation(value = "修改个税明细", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> ModifyIndividualIncomeTaxDetails(@CurrentUser UserBean userBean, @RequestBody XcglAssoGsjsmx xcglassogsjsmx) {
		
		xcglassogsjsmx.updateById();
		
		return ResultUtil.data(xcglassogsjsmx,"操作成功!");
	}
	
	/**
	 * 	新增或编辑
	 */
	@PostMapping(value = "/paysave")
	@ApiOperation(value = "添加/修改薪资组", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult paysave(@CurrentUser UserBean userBean,@RequestBody XcglAdminXzz obj) { 
		obj.setAdduserid(userBean.getEmpNum());// 员工工号
		obj.setQyid(userBean.getOrgCode());// 企业编码
		obj.setAddtime(new Date().getTime());// 添加时间 
		obj.insertOrUpdate();
		return new ResponseResult().success("添加/修改成功", obj);
	}

	@PostMapping(value = "/saveSalaryDetails")
	@ApiOperation(value = "保存薪资明细修改", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult saveSalaryDetails(@CurrentUser UserBean userBean,@RequestBody List<XcglAssoXzb> list) {
		xcglassoxzbmapper.updateBatchXzxjg(list);
		
		XcglAssoGztzt gzt = XcglAssoGztzt.builder().build().selectOne(new QueryWrapper<XcglAssoGztzt>().lambda().eq(XcglAssoGztzt::getUserid, list.get(0).getUserid()).eq(XcglAssoGztzt::getQyid, userBean.getOrgCode())
				.eq(XcglAssoGztzt::getXzyf, list.get(0).getXzyf()));
		if(gzt != null) {
			XcglAssoXzb paycol = xcglassoxzbmapper.PayInColumn(list.get(0).getXzxid(), list.get(0).getUserid(), list.get(0).getXzyf());
			
			XcglAssoGztzt.builder().sfgz(paycol.getXzxjg()).id(gzt.getId()).build().updateById();
		}
		
		return new ResponseResult().success("保存成功");
	}

	@PostMapping(value = "/sendpayslip/{id}/{fsType}")
	@ApiOperation(value = "发送工资条--操作", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult sendpayslip(@CurrentUser UserBean userBean, @PathVariable Integer id, @PathVariable Integer fsType) {
		xcglassogztztmapper.payslipSend(id, fsType);
		return new ResponseResult().success("成功");
	}

	@PostMapping(value = "/sendpayslipBatch")
	@ApiOperation(value = "发送工资条--一键发送", httpMethod = "POST", notes = "接口发布说明")
	public ResponseResult sendpayslipBatch(@CurrentUser UserBean userBean, @RequestBody SendpayslipBatchDto dto) {
		xcglassogztztmapper.payslipSendBatch(dto);
		return new ResponseResult().success("成功");
	}
	
	
	/***************************APP*************************************************/
	
	@GetMapping(value="/wageconfirmation/{id}")
	@ApiOperation(value = "工资确认", httpMethod = "GET", notes = "接口发布说明")
	public Result<Object> WageConfirmation(@CurrentUser UserBean userBean,@PathVariable("id") Integer id) {
		XcglAssoGztzt.builder().qrType(1).id(id).build().updateById();
		return ResultUtil.success("成功");
	}
	
	
	
	
	@PostMapping(value="/appacquisition")
	@ApiOperation(value = "APP获取工资前期预备数据", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> AppAcquisition(@CurrentUser UserBean userBean,@RequestBody APPPayslipPeriodDto apppays) {
		PushPayslipDto pays = new PushPayslipDto();
		
		XcglAssoGztzt gzt = XcglAssoGztzt.builder().build().selectOne(new QueryWrapper<XcglAssoGztzt>().lambda().eq(XcglAssoGztzt::getUserid, apppays.getUserid())
				.eq(XcglAssoGztzt::getXzyf, apppays.getXzyf()).eq(XcglAssoGztzt::getQyid, userBean.getOrgCode()));
		if(gzt != null) {
			pays.setGztid(gzt.getId());
			pays.setXzzid(gzt.getXzzid());
			pays.setUserid(gzt.getUserid());
			pays.setXzyf(gzt.getXzyf());
		}else {
			pays.setGztid(0);
			pays.setXzzid(0);
			pays.setUserid(0);
			pays.setXzyf("");
		}
		
		return ResultUtil.data(pays,"操作成功!");
	}
	
	@Autowired
	private KqglAssoRelationSummaryMapper kqglassorelationsummarymapper;
	
	@Autowired
	private KqglAssoDkjlMapper kqglassodkjlmapper;
	
	@PostMapping(value = "/pushpayslip")
	@ApiOperation(value = "发送工资条", httpMethod = "POST", notes = "接口发布说明")
	public Result<Object> PushPayslip(@CurrentUser UserBean userBean,@RequestBody APPPayslipPeriodDto apppays) {
		
		PushPayslipDto pays = new PushPayslipDto();
		
		XcglAssoGztzt gzt = XcglAssoGztzt.builder().build().selectOne(new QueryWrapper<XcglAssoGztzt>().lambda().eq(XcglAssoGztzt::getUserid, apppays.getUserid())
				.eq(XcglAssoGztzt::getXzyf, apppays.getXzyf()).eq(XcglAssoGztzt::getQyid, userBean.getOrgCode()));
		if(gzt != null) {
			pays.setGztid(gzt.getId());
			pays.setXzzid(gzt.getXzzid());
			pays.setUserid(gzt.getUserid());
			pays.setXzyf(gzt.getXzyf());
		}
		
		
		String strY = new SimpleDateFormat("yyyy").format(new Date());
//		double prescription = 8;
		//顶层
		AppPayslipDetailsDto top = new AppPayslipDetailsDto();
		//工资条数据
//		XcglAssoGztzt gzt = XcglAssoGztzt.builder().id(pays.getGztid()).build().selectById();
		if(gzt != null && gzt.getFsType() == 1) {//已发送的工资条
			top.setId(gzt.getId());
			top.setNetsalary(gzt.getSfgz());//实发工资
			top.setWagetime(gzt.getXzyf());//工资时间
			top.setUserid(gzt.getUserid());
			top.setSfyqrgz(gzt.getQrType());
			//薪资组里项
			List<XcglAssoJsgzzx> jsgs = XcglAssoJsgzzx.builder().build().selectList(new QueryWrapper<XcglAssoJsgzzx>().lambda().eq(XcglAssoJsgzzx::getXzzid, pays.getXzzid()).eq(XcglAssoJsgzzx::getType, 2)
					.orderByAsc(XcglAssoJsgzzx::getId));
			//第一层集合
			List<AppPaysSalaryOneDto> specific = new ArrayList<AppPaysSalaryOneDto>();
			
			for(XcglAssoJsgzzx xzx : jsgs) {
				//第二层集合
				List<AppPaysSalaryTwoDto> detailed = new ArrayList<AppPaysSalaryTwoDto>();
				
				//第一层
				AppPaysSalaryOneDto spe = new AppPaysSalaryOneDto();
				
				XcglAssoXzb xzb = XcglAssoXzb.builder().build().selectOne(new QueryWrapper<XcglAssoXzb>().lambda().eq(XcglAssoXzb::getUserid, pays.getUserid()).eq(XcglAssoXzb::getXzyf, pays.getXzyf())
						.eq(XcglAssoXzb::getXzxid, xzx.getId()));
				//事假扣款、病假扣款、旷工扣款、迟到早退扣款、司龄工资、个税
				if(xzx.getOptionid() != 27 && xzx.getOptionid() != 28 && xzx.getOptionid() != 29 && xzx.getOptionid() != 30 && xzx.getOptionid() != 31  && xzx.getOptionid() != 69) {
					spe.setItemname(xzx.getSalaryitem());//
					spe.setDeduction(xzb == null ? 0 : xzb.getXzxjg());//
					spe.setFieldone("");
					spe.setFieldtwo("");
					spe.setDetailed(detailed);
					specific.add(spe);
				}else {
					//事假扣款
					if(xzx.getOptionid() == 27) {
						spe.setItemname(xzx.getSalaryitem());//
						spe.setDeduction(xzb == null ? 0 : xzb.getXzxjg());//扣款金额
						
						if(xzx.getGsid() == 3) {//天数
							HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(userBean.getOrgCode(), pays.getXzyf(), 1, pays.getUserid()); 
							double ts = 0;
							if(balance.getBalance() > 0) {
								ts = balance.getBalance()/prescription;
							}
							spe.setFieldone("共"+balance.getBalance()+"小时="+SalaryTool.formatDouble_(ts)+"天");
						}else if(xzx.getGsid() == 4) {//次数
							HolidayInquiryDto balance = xcglassoxzbmapper.HolidayamountNum(userBean.getOrgCode(), pays.getXzyf(), 1, pays.getUserid()); 
							spe.setFieldone("共"+balance.getNum()+"次");
						}
						
						spe.setFieldtwo("");
						//事假详细
						List<KqglAssoRelationSummary> holdet = kqglassorelationsummarymapper.HolidayDetails(userBean.getOrgCode(), pays.getXzyf(), 1, pays.getUserid());
						for(KqglAssoRelationSummary sjxx : holdet) {
							AppPaysSalaryTwoDto two = new AppPaysSalaryTwoDto();
							two.setTerm("事假日期");
							two.setSpecifictime(sjxx.getStartTime().substring(5, 16)+"至"+sjxx.getEndTime().substring(5, 16));
							two.setField(sjxx.getDuration());
							detailed.add(two);
						}
						
						spe.setDetailed(detailed);
					}
					//病假扣款
					if(xzx.getOptionid() == 28) {
						spe.setItemname(xzx.getSalaryitem());//
						spe.setDeduction(xzb == null ? 0 : xzb.getXzxjg());//
						
						if(xzx.getGsid() == 5) {//天数
							HolidayInquiryDto balance = xcglassoxzbmapper.Holidayamount(userBean.getOrgCode(), pays.getXzyf(), 3, pays.getUserid()); 
							double ts = 0;
							if(balance.getBalance() > 0) {
								ts = balance.getBalance()/prescription;
							}
							spe.setFieldone("共"+balance.getBalance()+"小时="+SalaryTool.formatDouble_(ts)+"天");
						}else if(xzx.getGsid() == 6) {//次数
							HolidayInquiryDto balance = xcglassoxzbmapper.HolidayamountNum(userBean.getOrgCode(), pays.getXzyf(), 3, pays.getUserid()); 
							spe.setFieldone("共"+balance.getNum()+"次");
						}
						
						spe.setFieldtwo("");
						//病假详细
						List<KqglAssoRelationSummary> holdet = kqglassorelationsummarymapper.HolidayDetails(userBean.getOrgCode(), pays.getXzyf(), 3, pays.getUserid());
						for(KqglAssoRelationSummary sjxx : holdet) {
							AppPaysSalaryTwoDto two = new AppPaysSalaryTwoDto();
							two.setTerm("病假日期");
							two.setSpecifictime(sjxx.getStartTime().substring(5, 16)+"至"+sjxx.getEndTime().substring(5, 16));
							two.setField(sjxx.getDuration());
							detailed.add(two);
						}
						spe.setDetailed(detailed);
					}
					//旷工扣款
					if(xzx.getOptionid() == 29) {
						spe.setItemname(xzx.getSalaryitem());//
						spe.setDeduction(xzb == null ? 0 : xzb.getXzxjg());//
						
						KqglAssoMonthPunchSummary kgts = KqglAssoMonthPunchSummary.builder().build().selectOne(new QueryWrapper<KqglAssoMonthPunchSummary>().lambda().eq(KqglAssoMonthPunchSummary::getNum, pays.getUserid())
								.eq(KqglAssoMonthPunchSummary::getOrgCode, userBean.getOrgCode()).eq(KqglAssoMonthPunchSummary::getBelongYear, pays.getXzyf().substring(0, 4)).eq(KqglAssoMonthPunchSummary::getBelongMonth, pays.getXzyf().substring(5, 7)));
						if(xzx.getGsid() == 7) {//天数
							spe.setFieldone("共"+kgts == null ? "0" : String.valueOf(kgts.getAbsenteeismDays())+"天");
						}else if(xzx.getGsid() == 8) {
							spe.setFieldone("共"+kgts == null ? "0" : String.valueOf(kgts.getAbsenteeismDays())+"次");
						}
						spe.setFieldtwo("");
						
						com.alibaba.fastjson.JSONObject jo= (com.alibaba.fastjson.JSONObject) com.alibaba.fastjson.JSONObject.toJSON(kgts); 
						//旷工具体天数
						for(String str:jo.keySet()){
							if(jo.get(str).equals("旷工") && str.contains("day")) {
								AppPaysSalaryTwoDto two = new AppPaysSalaryTwoDto();
								two.setTerm("旷工日期");
								String rq = str.substring(str.indexOf("y")+1);
								int qq = Integer.valueOf(str.substring(str.indexOf("y")+1));
								if(qq <= 9) {
									rq = "0"+qq;
								}
								two.setSpecifictime(pays.getXzyf().substring(5, 7)+"-"+rq);
								two.setField(0.0);
								detailed.add(two);
							}
						}
						spe.setDetailed(detailed);
					}
					//迟到早退扣款
					if(xzx.getOptionid() == 30) {
						spe.setItemname(xzx.getSalaryitem());//
						spe.setDeduction(xzb == null ? 0 : xzb.getXzxjg());//扣款金额
						
						if(xzx.getGsid() == 1) {//次数
							HolidayInquiryDto cdcs = kqglassodkjlmapper.TimesBeingLateLeavingEarly(userBean.getOrgCode(), pays.getUserid(), 1, pays.getXzyf().substring(2, 7));
							HolidayInquiryDto ztcs = kqglassodkjlmapper.TimesBeingLateLeavingEarly(userBean.getOrgCode(), pays.getUserid(), 2, pays.getXzyf().substring(2, 7));
							
							spe.setFieldone("迟到"+cdcs.getNum()+"次");//迟到
							spe.setFieldtwo("早退"+ztcs.getNum()+"次");//早退
						}else if(xzx.getGsid() == 2) {//分钟
							HolidayInquiryDto cdfz = kqglassodkjlmapper.MinutesLateLeaveEarly(userBean.getOrgCode(), pays.getUserid(), 1, pays.getXzyf().substring(2, 7));
							HolidayInquiryDto ztfz = kqglassodkjlmapper.MinutesLateLeaveEarly(userBean.getOrgCode(), pays.getUserid(), 2, pays.getXzyf().substring(2, 7));
							
							spe.setFieldone("迟到"+cdfz.getBalance()+"分钟");//迟到
							spe.setFieldtwo("早退"+ztfz.getBalance()+"分钟");//早退
						}
						
						List<KqglAssoDkjl> cdzts = kqglassodkjlmapper.LateleaveEarly(userBean.getOrgCode(), pays.getUserid(), pays.getXzyf().substring(2, 7));
						for(KqglAssoDkjl cz : cdzts) {
							AppPaysSalaryTwoDto two = new AppPaysSalaryTwoDto();
							if(cz.getType() == 1) {//上班
								two.setTerm("迟到日期");
							}else if(cz.getType() == 2) {//下班
								two.setTerm("早退日期");
							}
							two.setSpecifictime(ClockInTool.stampToDate5(String.valueOf(cz.getDktime())));
							two.setField(Double.valueOf(String.valueOf(cz.getResults())));
							detailed.add(two);
						}
						
						spe.setDetailed(detailed);
					}
					
					//司龄工资
					if(xzx.getOptionid() == 31) {
						spe.setItemname(xzx.getSalaryitem());//
						spe.setDeduction(xzb == null ? 0 : xzb.getXzxjg());//
						spe.setFieldone("");
						spe.setFieldtwo("");
						YgglMainEmp xzrz = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getEmpNum, pays.getUserid()).eq(YgglMainEmp::getOrgCode, userBean.getOrgCode()));
						String entry_date = ClockInTool.SunNovCSTYMD(xzrz.getRzTime());//yyyyMMdd
						int jssl = Integer.valueOf(ClockInTool.SunNovCSTY(xzrz.getRzTime()));//yyyy
						double slage = 0;
						if(Integer.valueOf(strY) - jssl >= 0) {
							slage = Integer.valueOf(strY) - jssl;
						}
						AppPaysSalaryTwoDto two = new AppPaysSalaryTwoDto();
						two.setTerm("入职日期");
						two.setSpecifictime(entry_date);
						two.setField(slage);
						detailed.add(two);
						spe.setDetailed(detailed);
					}
					
					//个税
					if(xzx.getOptionid() == 69) {
						spe.setItemname(xzx.getSalaryitem());//
						spe.setDeduction(xzb == null ? 0 : xzb.getXzxjg());//
						spe.setFieldone("");
						spe.setFieldtwo("");
						String[] remarks = {"本月个税","税款所属月份","累计专项附加扣除","本期收入","本期专项扣除","累计收入额","累计减除费用","累计专项扣除","累计其他扣除","累计应纳税所得额","税率","速算扣除数","累计应纳税额","累计已预缴税额","累计应补（退）税额"};
						String[] field = {"thmonth_personal","tax_month","cum_zxfjkc","current_income","current_special_deduction","cum_sre","cum_jcfy","cum_zxkc","cum_qtkc","cum_ynssde","tax_rate","quick_calculation_deduction","cum_ynse","cum_yyjse","cum_ybtse"};
						//个税详情
						for(int i=0;i<remarks.length;i++) {
							AppPaysSalaryTwoDto two = new AppPaysSalaryTwoDto();
							two.setTerm(remarks[i]);
							
							QueryWrapper<XcglAssoGsjsmx> queryWrapper = new QueryWrapper<>();
							queryWrapper.select(field[i]).eq("user_num", pays.getUserid()).eq("salary_month", pays.getXzyf()).eq("qyid", userBean.getOrgCode());
							List<Map<String, Object>> list = xcglassogsjsmxmapper.selectMaps(queryWrapper);
							String autacq = "";
							if(list != null) {
					        	for(Map<String, Object> aut:list) {
					        		if(aut != null) {
					        			autacq = aut.toString().substring(aut.toString().indexOf("=")+1).replace("}", "");
					        		}
					        	}
					        }
							two.setSpecifictime(("").equals(autacq) ? "0" : autacq);
							two.setField(0.0);
							detailed.add(two);
						}
						spe.setDetailed(detailed);
					}
					specific.add(spe);
				}
				top.setSpecific(specific);
			}
			
		}
		return ResultUtil.data(top,"操作成功!");
	}
}