jya-oa-api/application/common/model/SalaryRecord.php

<?php
namespace app\common\model;

use app\hander\HelpHander;
use think\Db;
use think\Exception;
use think\Model;

class SalaryRecord extends Model
{
    // 工资发放
    public function add(){
        $data = [
            'type' => input('type/d',0),
            'month' => input('month','','trim'),
            'types' => input('types','','trim'),
            'remark' => input('remark','','trim'),
            'user_id' => input('userId/d',0),
            'users' => input('users','','trim')
        ];
        $orgId = input('orgId/d',0);
        $result = validate('SalaryRecord')->check($data,[],'');
        if(true !== $result){
            HelpHander::error(validate('SalaryRecord')->getError());
        }

        // 检查是否已设置审批流程
        $apply = model('SalaryApply')->all2($data['type']);
        if(!$apply){
            HelpHander::error('该类型工资的发放未设置审批节点');
        }

        $curinfo = $apply[0];
        $data['apply'] = json_encode($apply);
        $data['cur_node'] = $curinfo['id'];

        Db::startTrans();
        try{
            $users = json_decode($data['users'],true);
            unset($data['users']);

            $sdata = $data;
            $sdata['nums'] = count($users);
            $sdata['create_time'] = date('Y-m-d H:i:s');
            $salaryId = Db::name('SalaryRecord')->insertGetId($sdata);
            if(!$salaryId){
                \exception('操作失败');
            }

            $data['users'] = $users;
            $data['salary_record_id'] = $salaryId;

            if($data['type'] == 5){ //1=中心编制 2=新华聘用 3=中心劳务 4=新华劳务 5=中心退休
                $ret = model('UserRetiredSalary')->sendSalary($data);
            }else if(in_array($data['type'],[1,2,3,4])){
                $ret = model('SalaryRecord')->sendSalary($data);
            } else{ // 年绩效 6=中心编制 7=新华聘用 8=中心劳务 9=新华劳务
                $ret = model('SalaryRecord')->sendSalaryJx($data);
            }

            if(!$ret){
                \exception('操作失败');
            }

            // 生成审核记录
            $uids = explode(',',$curinfo['userids']);
            foreach ($uids as $k=>$v){
                $sd = [
                    'salary_record_id' => $salaryId,
                    'user_id' => $v,
                    'status' => 0,
                    'create_time' => date('Y-m-d H:i:s'),
                    'salary_apply_id' => $curinfo['id'],
                    'sign' => $curinfo['sign'],
                ];
                $ret = Db::name('salary_apply_record')->insertGetId($sd);
                if(!$ret){
                    \exception('操作失败');
                }

                model('Message')->add(3,$salaryId,12,$v,$orgId,'工资流程待您的审核确认');
            }

            if(!$ret){
                \exception('操作失败');
            }

            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            HelpHander::error($e->getMessage());
        }

        return true;
    }

    // 重新发工资
    public function resend(){
        $salaryRecordId = input('salaryRecordId/d',0);
        $id = input('id/d',0);
        $users = input('users','','trim');
        $userId = input('userId/d',0);
        $info = Db::name('salary_record')->where('id',$salaryRecordId)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 0 && $info['status'] != 3){ //审核中或已打回
            HelpHander::error('无权限操作');
        }

        if($info['status'] == 3 && $info['user_id'] != $userId){
            HelpHander::error('无权限操作');
        }

        if($info['status'] == 0){
            $sar = Db::name('salary_apply_record')
                ->where('salary_apply_id',$info['cur_node'])
                ->where('salary_record_id',$salaryRecordId)
                ->where('user_id',$userId)
                ->where('status',0)
                ->where('del',0)
                ->find();
            if(!$sar){
                HelpHander::error('无权限修改3');
            }
        }

        $users = json_decode($users,true);
        if(!$users){
            HelpHander::error('参数错误');
        }

        Db::startTrans();
        try{
            if($info['type'] === 5){
                $ret = model('UserRetiredSalary')->sendOneSalary($users[0],$info,$id);
            }else if(in_array($info['type'],[1,2,3,4])){
                $ret = model('SalaryRecord')->sendOneSalary($users[0],$info,$id);
            }else{
                $ret = model('SalaryRecord')->sendOneSalaryJx($users[0],$info,$id);
            }

            if(!$ret){
                \exception('操作失败');
            }

            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            HelpHander::error($e->getMessage());
        }

        return true;

    }

    // 删除工资项
    public function delsalary(){
        $salaryRecordId = input('salaryRecordId/d',0);
        $tids = input('tids','','trim');
        if(!$tids){
            HelpHander::error('未选择要删除的工资项');
        }
        $tids = array_unique(explode(',',$tids));
        $userId = input('userId/d',0);
        $orgId = input('orgId/d',0);
        $info = Db::name('salary_record')->where('id',$salaryRecordId)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 0 && $info['status'] != 3){ //审核中或已打回
            HelpHander::error('无权限操作');
        }
        if(!$info['types']){
            HelpHander::error('无可删除工资项');
        }
        if($info['status'] == 0){
            $sar = Db::name('salary_apply_record')
                ->where('salary_apply_id',$info['cur_node'])
                ->where('salary_record_id',$salaryRecordId)
                ->where('user_id',$userId)
                ->where('status',0)
                ->where('del',0)
                ->find();
            if(!$sar){
                HelpHander::error('无权限修改');
            }
        }


        $ntypes = [];
        $otypes = explode(',',$info['types']);
        foreach ($otypes as $v){
            if(!in_array($v,$tids)){
                $ntypes[] = $v;
            }
        }
        $info['types'] = !empty($ntypes)?implode(',',$ntypes):'';

        Db::startTrans();
        try{
            // 更新工资项
            $ret = Db::name('salary_record')->where('id',$salaryRecordId)->update([
                'types' => $info['types'],
            ]);
            if(!$ret){
                \exception('操作失败');
            }

            // 重新计算每个人的工资
            $logs = Db::name('salary_record_log')->where('salary_record_id',$salaryRecordId)->field('id,user_id')->select();
            foreach ($logs as $k=>$v){
                $rdata = array_change_line_to_hump($this->reloadAdd($salaryRecordId,$v['user_id'],$orgId,0));
                $types = $rdata['types'];
                $users = $rdata['list'];
                foreach ($users as $uk=>$uv){
                    foreach ($types as $tk=>$tv){
                        if(in_array($tv['id'],$tids)){
                            unset($users[$uk]['subsidies'.$tv['id']]);
                        }
                    }
                }

                if($info['type'] === 5){
                    $ret = model('UserRetiredSalary')->sendOneSalary($users[0],$info,$v['id']);
                }else if(in_array($info['type'],[1,2,3,4])){
                    $ret = model('SalaryRecord')->sendOneSalary($users[0],$info,$v['id']);
                }else{
                    $ret = model('SalaryRecord')->sendOneSalaryJx($users[0],$info,$v['id']);
                }

                if(!$ret){
                    \exception('操作失败');
                }
            }
            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            HelpHander::error($e->getMessage());
        }

        return true;
    }

    // 添加工资项
    public function addsalary(){
        $salaryRecordId = input('salaryRecordId/d',0);
        $tids = input('tids','','trim');
        if(!$tids){
            HelpHander::error('未选择要添加的工资项');
        }
        $tids = array_unique(explode(',',$tids));
        $userId = input('userId/d',0);
        $orgId = input('orgId/d',0);
        $info = Db::name('salary_record')->where('id',$salaryRecordId)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 0 && $info['status'] != 3){ //审核中或已打回
            HelpHander::error('无权限操作');
        }
        if($info['status'] == 0){
            $sar = Db::name('salary_apply_record')
                ->where('salary_apply_id',$info['cur_node'])
                ->where('salary_record_id',$salaryRecordId)
                ->where('user_id',$userId)
                ->where('status',0)
                ->where('del',0)
                ->find();
            if(!$sar){
                HelpHander::error('无权限修改');
            }
        }
        $postusers = input('users','','trim');
        $postusers = json_decode($postusers,true);
        if(!$postusers){
            HelpHander::error('参数错误');
        }

        $otypes = explode(',',$info['types']);
        if(array_intersect($tids,$otypes)){ // 有交集说明参数错误
            HelpHander::error('部分工资项已存在，不能添加');
        }

        $ntypes = $otypes;
        foreach ($tids as $v){
            if(!in_array($v,$otypes)){
                $ntypes[] = $v;
            }
        }
        $info['types'] = !empty($ntypes)?implode(',',$ntypes):'';

        Db::startTrans();
        try{
            // 更新工资项
            $ret = Db::name('salary_record')->where('id',$salaryRecordId)->update([
                'types' => $info['types'],
            ]);
            if(!$ret){
                \exception('操作失败');
            }

            // 重新计算每个人的工资
            $logs = Db::name('salary_record_log')->where('salary_record_id',$salaryRecordId)->field('id,user_id')->select();
            foreach ($logs as $k=>$v){
                $rdata =  array_change_line_to_hump($this->reloadAdd($salaryRecordId,$v['user_id'],$orgId,0));
                $users = $rdata['list'];
                foreach ($users as $uk=>$uv){
                    $userSn = think_encrypt($uv['userId']);
                    foreach ($tids as $tk=>$tv){
                        foreach ($postusers as $puk=>$puv){
                            if($userSn == $puv['userSn']){
                                $users[$uk]['subsidies'.$tv] = !empty($puv['subsidies'.$tv])?$puv['subsidies'.$tv]:0;
                                break;
                            }
                        }
                    }
                }

                if($info['type'] === 5){
                    $ret = model('UserRetiredSalary')->sendOneSalary($users[0],$info,$v['id']);
                }else if(in_array($info['type'],[1,2,3,4])){
                    $ret = model('SalaryRecord')->sendOneSalary($users[0],$info,$v['id']);
                }else{
                    $ret = model('SalaryRecord')->sendOneSalaryJx($users[0],$info,$v['id']);
                }

                if(!$ret){
                    \exception('操作失败');
                }
            }
            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            HelpHander::error($e->getMessage());
        }

        return true;
    }

    // 修改工资项
    public function modifysalary(){
        $salaryRecordId = input('salaryRecordId/d',0);
        $tids = input('tids','','trim');
        if(!$tids){
            HelpHander::error('未选择要修改的工资项');
        }
        $tids = array_unique(explode(',',$tids));
        $userId = input('userId/d',0);
        $orgId = input('orgId/d',0);
        $info = Db::name('salary_record')->where('id',$salaryRecordId)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 0 && $info['status'] != 3){ //审核中或已打回
            HelpHander::error('无权限操作');
        }
        if($info['status'] == 0){
            $sar = Db::name('salary_apply_record')
                ->where('salary_apply_id',$info['cur_node'])
                ->where('salary_record_id',$salaryRecordId)
                ->where('user_id',$userId)
                ->where('status',0)
                ->where('del',0)
                ->find();
            if(!$sar){
                HelpHander::error('无权限修改');
            }
        }
        $postusers = input('users','','trim');
        $postusers = json_decode($postusers,true);
        if(!$postusers){
            HelpHander::error('参数错误');
        }

        $otypes = explode(',',$info['types']);
        if(array_intersect($tids,$otypes) != $tids){ // 不是子集
            HelpHander::error('修改的工资项不存在');
        }

        Db::startTrans();
        try{

            // 重新计算每个人的工资
            $logs = Db::name('salary_record_log')->where('salary_record_id',$salaryRecordId)->field('id,user_id')->select();
            foreach ($logs as $k=>$v){
                $rdata =  array_change_line_to_hump($this->reloadAdd($salaryRecordId,$v['user_id'],$orgId,0));
                $users = $rdata['list'];
                foreach ($users as $uk=>$uv){
                    $userSn = think_encrypt($uv['userId']);
                    foreach ($tids as $tk=>$tv){
                        foreach ($postusers as $puk=>$puv){
                            if($userSn == $puv['userSn']){
                                $users[$uk]['subsidies'.$tv] = !empty($puv['subsidies'.$tv])?$puv['subsidies'.$tv]:0;
                                break;
                            }
                        }
                    }
                }

                if($info['type'] === 5){
                    $ret = model('UserRetiredSalary')->sendOneSalary($users[0],$info,$v['id']);
                }else if(in_array($info['type'],[1,2,3,4])){
                    $ret = model('SalaryRecord')->sendOneSalary($users[0],$info,$v['id']);
                }else{
                    $ret = model('SalaryRecord')->sendOneSalaryJx($users[0],$info,$v['id']);
                }

                if(!$ret){
                    \exception('操作失败');
                }
            }
            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            HelpHander::error($e->getMessage());
        }

        return true;
    }

    // 重新计算个税
    public function resendtax(){
        $id = input('id/d',0);
        $userId = input('userId/d',0);
        $log = Db::name('salary_record_log')->where('id',$id)->find();
        if(!$log){
            HelpHander::error('记录不存在');
        }
        $salaryRecordId = $log['salary_record_id'];
        $info = Db::name('salary_record')->where('id',$salaryRecordId)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 0){
            HelpHander::error('无权限操作');
        }
        $sar = Db::name('salary_apply_record')
            ->where('salary_apply_id',$info['cur_node'])
            ->where('salary_record_id',$salaryRecordId)
            ->where('user_id',$userId)
            ->where('status',0)
            ->where('del',0)
            ->find();

        if(!$sar){
            HelpHander::error('无权限修改');
        }

        if(!in_array($info['type'],[1,2])){
            HelpHander::error('无权限修改');
        }

        $sbdata = Db::name('salary_record_sb')->where('user_id',$log['user_id'])->where('salary_record_id',$salaryRecordId)->find();
        $jbsalary = $log['gwgz'] + $log['xjgz'] + $log['jcjx'] + $log['yjx'];
        $srid = Db::name('salary_record')
            ->alias('sr')
            ->join('salary_record_special srs','srs.salary_record_id = sr.id')
            ->where('sr.month',$info['month'])
            ->where('srs.user_id',$log['user_id'])
            ->where('sr.type',$info['type'])
            ->where('sr.del',0)
            ->order('sr.id desc')
            ->value('sr.id');

        $spdata = $this->getSalaryTax($log['should_total'],$sbdata,$log['user_id'],$log['company_id'],$info['month'],$info['type'],$jbsalary,$srid); // 计算个税
        $tax = $spdata['tax'];
        if($tax == $log['tax']){
            return true;
        }

        Db::startTrans();
        try{
            $salary = $log['salary'] - ($tax - $log['tax']);
            $sdata = [
                'tax' => $tax,
                'salary' => $salary,
            ];
            $ret = Db::name('salary_record_log')->where('id',$id)->update($sdata);
            if(!$ret){
                \exception('操作失败');
            }

            $spdata['salary_record_id'] = $salaryRecordId;
            $spdata['user_id'] = $log['user_id'];
            $m = intval(date('m',strtotime($info['month'].'-01')));
            if($m == 1 && $spdata['type'] != 1){ // 一月的第一次发工资
                $spdata['tax'] = 0;
            }

            $ret = Db::name('salary_record_special')
                ->where('salary_record_id',$salaryRecordId)
                ->where('user_id',$log['user_id'])
                ->strict(false)
                ->update($spdata);
            if(!$ret){
                \exception('操作失败');
            }

            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            HelpHander::error($e->getMessage());
        }

        return true;

    }

    private function sendOneSalary($user,$data,$id){
        $user['psmoney'] = (float)$user['psmoney'];
        $user['pwmoney'] = (float)$user['pwmoney'];
        $user['fixedPerformance'] = (float)$user['fixedPerformance'];
        $user['psmonth'] = (float)$user['psmonth'];
        $types = [];
        if($data['types']){
            $types = Db::name('user_subsidies')
                ->where('id','in',$data['types'])
                ->where('del',0)
                ->order('sorts asc,id asc')
                ->select();
        }
        if($data['type'] == 3||$data['type'] == 4){ // 劳务费
            $sdata = [
                'salary_record_id' => $data['id'],
                'user_id' => $user['userId'],
                'gwgz' => $user['psmoney'],
                'xjgz' => $user['pwmoney'],
                'jcjx' => $user['fixedPerformance'],
                'yjx' => $user['psmonth'],
                'pwlevel' => $user['pwlevel'],
                'psid' => $user['psid'],
                'type' => $user['type'],
                'company_id' => $user['companyId'],
                'child' => 0
            ];
            $should_total = $user['psmoney'] + $user['pwmoney'] + $user['fixedPerformance'] + $user['psmonth'];
            $jbsalary = $should_total;
            $btjson = [];
            $kcsalary = 0;
            foreach ($user as $key=>$val){
                if(strpos($key,'subsidies') === 0){
                    foreach ($types as $kk=>$vv){
                        if($vv['id'] == str_ireplace('subsidies','',$key)){
//                            $val = (float)$val > 0?(float)$val:0; // 不填或小于0的值默认成0
                            $val = (float)$val; // 支持负值
                            $btjson[] = [
                                'id' => $vv['id'],
                                'cate' => $vv['cate'],
                                'title' => $vv['title'],
                                'money' => $val
                            ];
                            if($vv['cate'] == 1){ // 补贴
                                $should_total += $val;
                            }else{
                                $kcsalary += $val;
                            }
                        }
                    }
                }
            }
            $sdata['should_total'] = $should_total;
            $sdata['tax'] = $this->getLaborTax($should_total,$user['userId']);
            $sdata['salary'] = round($should_total - $sdata['tax'] - $sdata['child'] - $kcsalary,2);
            if($sdata['salary'] < 0){
                return false;
            }
            $sdata['btjson'] = json_encode($btjson,JSON_UNESCAPED_UNICODE);
            $res = Db::name('salary_record_log')->where('id',$id)->update($sdata);
            if($res === false){
                return false;
            }
        }else if($data['type'] == 1||$data['type'] == 2){ // 新华聘算社保及累计数
            $sdata = [
                'salary_record_id' => $data['id'],
                'user_id' => $user['userId'],
                'gwgz' => $user['psmoney'],
                'xjgz' => $user['pwmoney'],
                'jcjx' => $user['fixedPerformance'],
                'yjx' => $user['psmonth'],
                'pwlevel' => $user['pwlevel'],
                'psid' => $user['psid'],
                'type' => $user['type'],
                'company_id' => $user['companyId'],
                'child' => 0
            ];

            $should_total = $user['psmoney'] + $user['pwmoney'] + $user['fixedPerformance'] + $user['psmonth'];
            $jbsalary = $should_total; // 基本工资,如果不发基本工资,专项附件不累计,如果发基本工资,按正常工资走
            $btjson = [];
            $kcsalary = 0;

            $bkdata = [
                'ggj' => 0, // 补扣公积金
                'qynj' => 0, // 补扣企业年金
                'yla' => 0, // 补扣养老保险
                'yli' => 0, // 补扣医疗保险
                'sye' => 0 // 补扣失业保险
            ];

            foreach ($user as $key=>$val){
                if(strpos($key,'subsidies') === 0){
                    foreach ($types as $kk=>$vv){
                        if($vv['id'] == str_ireplace('subsidies','',$key)){
//                            $val = (float)$val > 0?(float)$val:0; // 不填或小于0的值默认成0
                            $val = (float)$val; // 支持负值
                            $btjson[] = [
                                'id' => $vv['id'],
                                'cate' => $vv['cate'],
                                'title' => $vv['title'],
                                'money' => $val,
                                'sbtype' => $vv['sbtype']
                            ];
                            $vvl = 0;
                            if($vv['cate'] == 1){ // 补贴
                                $should_total += $val;
                                $vvl = $val;
                            }else{
                                $kcsalary += $val;
                                $vvl = -$val;
                            }

                            // 是否关联社保公积金
                            // 1=公积金 2=企业年金 3=养老保险 4=医疗保险 5=失业保险
                            if($vv['sbtype'] == 1){
                                $bkdata['ggj'] += $vvl;
                            }else if($vv['sbtype'] == 2){
                                $bkdata['qynj'] += $vvl;
                            }else if($vv['sbtype'] == 3){
                                $bkdata['yla'] += $vvl;
                            }else if($vv['sbtype'] == 4){
                                $bkdata['yli'] += $vvl;
                            }else if($vv['sbtype'] == 5){
                                $bkdata['sye'] += $vvl;
                            }
                        }
                    }
                }
            }

            $sbdata = $this->getShebao($user['userId'],$user['companyId'],$user,$jbsalary);

            $sbdata['salary_record_id'] = $data['id'];
            $sbdata['user_id'] = $user['userId'];


            // 社保扣除金额
            $sbkc = $sbdata['gjjp'] + $sbdata['qynjp'] +$sbdata['ylip'] +$sbdata['syep'] +$sbdata['ylap'];
            $sdata['should_total'] = $should_total;
            $sdata['sbgjj'] = $sbkc;

            $srid = Db::name('salary_record')
                ->alias('sr')
                ->join('salary_record_special srs','srs.salary_record_id = sr.id')
                ->where('sr.month',$data['month'])
                ->where('srs.user_id',$user['userId'])
                ->where('sr.type',$data['type'])
                ->where('sr.del',0)
                ->order('sr.id desc')
                ->value('sr.id');
            $spdata = $this->getSalaryTax($should_total,$sbdata,$user['userId'],$user['companyId'],$data['month'],$data['type'],$jbsalary,$srid,$bkdata); // 计算个税

            $spdata['salary_record_id'] = $data['id'];
            $spdata['user_id'] = $user['userId'];
            $tax = $spdata['tax'];

            $m = intval(date('m',strtotime($data['month'].'-01')));
            if($m == 1 && $spdata['type'] != 1){ // 一月的第一次发工资
                $spdata['tax'] = 0;
            }else if($m == 1 && $spdata['type'] == 1){ // 补交不算税
                /*$count = Db::name('salary_record')
                    ->alias('sr')
                    ->join('salary_record_log srl','srl.salary_record_id = sr.id')
                    ->join('salary_record_special srs','srs.salary_record_id = sr.id')
                    ->where('sr.month',$data['month'])
                    ->where('sr.id','<>',$id)
                    ->where('srs.user_id',$data['userId'])
                    ->where('sr.type',$data['type'])
                    ->where('sr.del',0)
                    ->order('sr.id desc')
                    ->count();
                if($count == 1){
                    $tax = Db::name('salary_record')
                        ->alias('sr')
                        ->join('salary_record_log srl','srl.salary_record_id = sr.id')
                        ->join('salary_record_special srs','srs.salary_record_id = sr.id')
                        ->where('sr.month',$data['month'])
                        ->where('srs.user_id',$data['userId'])
                        ->where('sr.type',$data['type'])
                        ->where('sr.del',0)
                        ->order('sr.id desc')
                        ->value('srl.tax');
                    $spdata['tax'] = $tax;
                }*/
            }

            unset($sdata['type']);
            $sparr[] = $spdata;
            if($jbsalary > 0){
                $sdata['salary'] = round($should_total - $tax - $sbkc - $kcsalary,2);
            }else{
                $sdata['salary'] = round($should_total - $tax - $kcsalary,2);
            }

            if($sdata['salary'] < 0){
                return false;
            }

            $sdata['btjson'] = json_encode($btjson,JSON_UNESCAPED_UNICODE);
            $sdata['tax'] = $tax;
            $res = Db::name('salary_record_log')->where('id',$id)->update($sdata);
            if($res === false){
                return false;
            }
            $res2 = Db::name('salary_record_sb')
                ->where('user_id',$user['userId'])
                ->where('salary_record_id',$data['id'])
                ->update($sbdata);
            if($res2 === false){
                return false;
            }
            $res3 = Db::name('salary_record_special')
                ->where('user_id',$user['userId'])
                ->where('salary_record_id',$data['id'])
                ->strict(false)
                ->update($spdata);
            if($res3 === false){
                return false;
            }
        }

        return true;
    }

    private function sendOneSalaryJx($user,$data,$id){
        // 判断下记录是否存在
        $ret = Db::name('salary_record_log')
            ->where('id',$id)
            ->where('salary_record_id',$data['id'])
            ->where('user_id',$user['userId'])
            ->find();
        if(!$ret){
            return false;
        }

        $sdata = [
            'salary_record_id' => $data['id'],
            'user_id' => $user['userId'],
            'njx' => floatval($user['psyear']) > 0?floatval($user['psyear']):0,
            'pwlevel' => $user['pwlevel'],
            'psid' => $user['psid'],
            'type' => $user['type'],
            'company_id' => $user['companyId'],
            'should_total' => floatval($user['shouldTotal']) > 0?floatval($user['shouldTotal']):0,
            'salary' => floatval($user['salary']) > 0?floatval($user['salary']):0,
            'tax' => floatval($user['tax']) > 0?floatval($user['tax']):0,
        ];

        if($data['type'] == 6||$data['type'] == 7){
            $sdata['level'] = trim($user['level'])?trim($user['level']):'';
            $sdata['factor'] = floatval($user['factor']) > 0?floatval($user['factor']):0;
            $sdata['months'] = intval($user['months']) > 0?intval($user['months']):0;
            $sdata['taxrate'] = floatval($user['taxrate']) > 0?floatval($user['taxrate']):0;
        }

        $res = Db::name('salary_record_log')->where('id',$id)->update($sdata);
        if($res === false){
            return false;
        }

        return true;
    }

    private function sendSalary($data){
        $types = [];
        if($data['types']){
            $types = Db::name('user_subsidies')
                ->where('id','in',$data['types'])
                ->where('del',0)
                ->order('sorts asc,id asc')
                ->select();
        }
        $users = $data['users'];
        foreach ($users as $k=>$v){
            $users[$k]['psmoney'] = (float)$v['psmoney'];
            $users[$k]['pwmoney'] = (float)$v['pwmoney'];
            $users[$k]['fixedPerformance'] = (float)$v['fixedPerformance'];
            $users[$k]['psmonth'] = (float)$v['psmonth'];
        }

        if($data['type'] == 3||$data['type'] == 4){ // 劳务费
            $arr = [];
            foreach ($users as $k=>$v){
                $sdata = [
                    'salary_record_id' => $data['salary_record_id'],
                    'user_id' => $v['userId'],
                    'gwgz' => $v['psmoney'],
                    'xjgz' => $v['pwmoney'],
                    'jcjx' => $v['fixedPerformance'],
                    'yjx' => $v['psmonth'],
                    'pwlevel' => $v['pwlevel'],
                    'psid' => $v['psid'],
                    'type' => $v['type'],
                    'company_id' => $v['companyId'],
                    'child' => $v['child']
                ];
                $should_total = $v['psmoney'] + $v['pwmoney'] + $v['fixedPerformance'] + $v['psmonth'];
                $btjson = [];
                $kcsalary = 0;
                foreach ($v as $key=>$val){
                    if(strpos($key,'subsidies') === 0){
                        foreach ($types as $kk=>$vv){
                            if($vv['id'] == str_ireplace('subsidies','',$key)){
//                                  $val = (float)$val > 0?(float)$val:0; // 不填或小于0的值默认成0
                                $val = (float)$val; // 支持负值
                                $btjson[] = [
                                    'id' => $vv['id'],
                                    'cate' => $vv['cate'],
                                    'title' => $vv['title'],
                                    'money' => $val
                                ];
                                if($vv['cate'] == 1){ // 补贴
                                    $should_total += $val;
                                }else{
                                    $kcsalary += $val;
                                }
                            }
                        }
                    }
                }
                $sdata['should_total'] = $should_total;

                $sdata['tax'] = $this->getLaborTax($should_total,$v['userId']);
                $sdata['salary'] = round($should_total - $sdata['tax'] - $kcsalary,2);
                if($sdata['salary'] < 0){
                    return false;
                }
                $sdata['btjson'] = json_encode($btjson,JSON_UNESCAPED_UNICODE);

                $arr[] = $sdata;
                if(count($arr) == 300){
                    $res = Db::name('salary_record_log')->insertAll($arr);
                    if($res != count($arr)){
                        return false;
                    }
                }
            }
            if($arr){
                $res = Db::name('salary_record_log')->insertAll($arr);
                if($res != count($arr)){
                    return false;
                }
            }
        }else if($data['type'] == 1||$data['type'] == 2){ // 新华聘算社保及累计数

            $arr = [];
            $sbarr = [];
            $sparr = [];
            foreach ($users as $k=>$v){
                $sdata = [
                    'salary_record_id' => $data['salary_record_id'],
                    'user_id' => $v['userId'],
                    'gwgz' => $v['psmoney'],
                    'xjgz' => $v['pwmoney'],
                    'jcjx' => $v['fixedPerformance'],
                    'yjx' => $v['psmonth'],
                    'pwlevel' => $v['pwlevel'],
                    'psid' => $v['psid'],
                    'type' => $v['pwlevel'],
                    'company_id' => $v['companyId'],
                    'child' => $v['child']
                ];
                $should_total = $v['psmoney'] + $v['pwmoney'] + $v['fixedPerformance'] + $v['psmonth'];
                $jbsalary = $should_total; // 基本工资,如果不发基本工资,专项附件不累计,如果发基本工资,按正常工资走
                $btjson = [];
                $kcsalary = 0;

                $bkdata = [
                    'ggj' => 0, // 补扣公积金
                    'qynj' => 0, // 补扣企业年金
                    'yla' => 0, // 补扣养老保险
                    'yli' => 0, // 补扣医疗保险
                    'sye' => 0 // 补扣失业保险
                ];
                foreach ($v as $key=>$val){
                    if(strpos($key,'subsidies') === 0){
                        foreach ($types as $kk=>$vv){
                            if($vv['id'] == str_ireplace('subsidies','',$key)){
//                                $val = (float)$val > 0?(float)$val:0; // 不填或小于0的值默认成0
                                $val = (float)$val; // 支持负值
                                $btjson[] = [
                                    'id' => $vv['id'],
                                    'cate' => $vv['cate'],
                                    'title' => $vv['title'],
                                    'money' => $val,
                                    'sbtype' => $vv['sbtype']
                                ];
                                $vvl = 0;
                                if($vv['cate'] == 1){ // 补贴
                                    $should_total += $val;
                                    $vvl = $val;
                                }else{
                                    $kcsalary += $val;
                                    $vvl = -$val;
                                }

                                // 是否关联社保公积金
                                // 1=公积金 2=企业年金 3=养老保险 4=医疗保险 5=失业保险
                                if($vv['sbtype'] == 1){
                                    $bkdata['ggj'] += $vvl;
                                }else if($vv['sbtype'] == 2){
                                    $bkdata['qynj'] += $vvl;
                                }else if($vv['sbtype'] == 3){
                                    $bkdata['yla'] += $vvl;
                                }else if($vv['sbtype'] == 4){
                                    $bkdata['yli'] += $vvl;
                                }else if($vv['sbtype'] == 5){
                                    $bkdata['sye'] += $vvl;
                                }
                            }
                        }
                    }
                }
                if($should_total <= 0){
                    return false;
                }

                $sbdata = $this->getShebao($v['userId'],$v['companyId'],$v,$jbsalary);
                $sbdata['salary_record_id'] = $data['salary_record_id'];
                $sbdata['user_id'] = $v['userId'];
                $sbarr[] = $sbdata;

                // 社保扣除金额
                $sbkc = $sbdata['gjjp'] + $sbdata['qynjp'] +$sbdata['ylip'] +$sbdata['syep'] +$sbdata['ylap'];
                $sdata['should_total'] = $should_total;
                $sdata['sbgjj'] = $sbkc;
                $spdata = $this->getSalaryTax($should_total,$sbdata,$v['userId'],$v['companyId'],$data['month'],$data['type'],$jbsalary,0,$bkdata); // 计算个税
                trace($spdata);

                $spdata['salary_record_id'] = $data['salary_record_id'];
                $spdata['user_id'] = $v['userId'];
                $tax = $spdata['tax'];
                $m = intval(date('m',strtotime($data['month'].'-01')));
                if($m == 1 && $spdata['type'] != 1){ // 一月的第一次发工资
                    $spdata['tax'] = 0;
                }else if($m == 1 && $spdata['type'] == 1){ // 补交不算税
                    /*$count = Db::name('salary_record')
                        ->alias('sr')
                        ->join('salary_record_log srl','srl.salary_record_id = sr.id')
                        ->join('salary_record_special srs','srs.salary_record_id = sr.id')
                        ->where('sr.month',$data['month'])
                        ->where('srs.user_id',$v['userId'])
                        ->where('sr.type',$data['type'])
                        ->where('sr.del',0)
                        ->order('sr.id desc')
                        ->count();
                    if($count == 1){
                        $tax = Db::name('salary_record')
                            ->alias('sr')
                            ->join('salary_record_log srl','srl.salary_record_id = sr.id')
                            ->join('salary_record_special srs','srs.salary_record_id = sr.id')
                            ->where('sr.month',$data['month'])
                            ->where('srs.user_id',$v['userId'])
                            ->where('sr.type',$data['type'])
                            ->where('sr.del',0)
                            ->order('sr.id desc')
                            ->value('srl.tax');
                        $spdata['tax'] = $tax;
                    }*/
                }

                unset($spdata['type']);
                $sparr[] = $spdata;

                if($jbsalary > 0){
                    $sdata['salary'] = round($should_total - $tax - $sbkc - $kcsalary,2);
                }else{
                    $sdata['salary'] = round($should_total - $tax - $kcsalary,2);
                }
                if($sdata['salary'] < 0){ // 实发金额不能小于0
                    return false;
                }
                $sdata['btjson'] = json_encode($btjson,JSON_UNESCAPED_UNICODE);
                $sdata['tax'] = $tax;
                $arr[] = $sdata;

                if(count($arr) == 300){
                    $res = Db::name('salary_record_log')->insertAll($arr);
                    if($res != count($arr)){
                        return false;
                    }
                }
                if(count($sbarr) == 300){
                    $res = Db::name('salary_record_sb')->insertAll($sbarr);
                    if($res != count($sbarr)){
                        return false;
                    }
                }
                if(count($sparr) == 300){
                    $res = Db::name('salary_record_special')->insertAll($sparr);
                    if($res != count($sparr)){
                        return false;
                    }
                }

            }
            
            if($arr){
                $res = Db::name('salary_record_log')->insertAll($arr);
                if($res != count($arr)){
                    return false;
                }
            }
            if($sbarr){
                $res = Db::name('salary_record_sb')->insertAll($sbarr);
                if($res != count($sbarr)){
                    return false;
                }
            }
            if($sparr){
                $res = Db::name('salary_record_special')->insertAll($sparr);
                if($res != count($sparr)){
                    return false;
                }
            }
            trace($sparr);
        }

        return true;
    }

    private function sendSalaryJx($data){
        $users = $data['users'];
        $arr = [];
        $uids = [];
        foreach ($users as $k=>$v){
            if(in_array($v['userId'],$uids)){
                continue;
            }
            $uids[] = $v['userId'];
            $sdata = [
                'salary_record_id' => $data['salary_record_id'],
                'user_id' => $v['userId'],
                'njx' => floatval($v['psyear']) > 0?floatval($v['psyear']):0,
                'pwlevel' => $v['pwlevel'],
                'psid' => $v['psid'],
                'type' => $v['type'],
                'company_id' => $v['companyId'],
                'should_total' => floatval($v['shouldTotal']) > 0?floatval($v['shouldTotal']):0,
                'salary' => floatval($v['salary']) > 0?floatval($v['salary']):0,
                'tax' => floatval($v['tax']) > 0?floatval($v['tax']):0,
            ];
            if($data['type'] == 6||$data['type'] == 7){
                $sdata['level'] = trim($v['level'])?trim($v['level']):'';
                $sdata['factor'] = floatval($v['factor']) > 0?floatval($v['factor']):0;
                $sdata['months'] = intval($v['months']) > 0?intval($v['months']):0;
                $sdata['taxrate'] = floatval($v['taxrate']) > 0?floatval($v['taxrate']):0;
            }

            $arr[] = $sdata;
            if(count($arr) == 300){
                $res = Db::name('salary_record_log')->insertAll($arr);
                if($res != count($arr)){
                    return false;
                }
            }
        }
        if($arr){
            $res = Db::name('salary_record_log')->insertAll($arr);
            if($res != count($arr)){
                return false;
            }
        }

        return true;
    }

    // 新华聘用税/编制个税
    private function getSalaryTax($should_total,$sbdata,$userId,$companyId,$month,$type,$jbsalary,$from=0,$bkdata=[]){// from 0=新增 0<重新计算
        $data = [
            'salary' => 0,
            'mssr' => 0,
            'sr' => 0,
            'ljsr' => 0,
            'ljjc' => 0,
            'ljgjj' => 0,
            'ljylobx' => 0,
            'ljsybx' => 0,
            'ljylibx' => 0,
            'ljnj' => 0,
            'ljznjy' => 0,
            'ljjxjy' => 0,
            'ljzfdklx' => 0,
            'ljzfzj' => 0,
            'ljsylr' => 0,
            'syjkbx' => 0,
            'ysylbx' => 0,
            'grbk' => 0,
            'jzjbjsb' => 0,
            'ljgzds' => 0,
            'qtkc' => 0,
            'ljsqljxmhj' => 0,
            'ljykjse' => 0,
            'tax' => 0,
            'zykcjze' => 0,
            'jmsebl' => 0,
            'extratax' => 0,
            'ljyyezh' => 0,
            'ljgrylj' => 0,
        ];
        $lastinfo = [];
        if($from > 0){
            // 每月发多次工资,先找本月是否已经发放过工资,没有的话获取上个月的记录,在没有的话获取初始值
            $lastinfo = Db::name('salary_record')
                ->alias('sr')
                ->join('salary_record_special srs','srs.salary_record_id = sr.id')
                ->where('sr.month',$month)
                ->where('srs.user_id',$userId)
                ->where('sr.id','<>',$from)
                ->where('sr.type',$type)
                ->where('sr.del',0)
                ->field('srs.*')
                ->order('sr.id desc')
                ->find();

        }else{
            // 每月发多次工资,先找本月是否已经发放过工资,没有的话获取上个月的记录,在没有的话获取初始值
            $lastinfo = Db::name('salary_record')
                ->alias('sr')
                ->join('salary_record_special srs','srs.salary_record_id = sr.id')
                ->where('sr.month',$month)
                ->where('srs.user_id',$userId)
                ->where('sr.type',$type)
                ->where('sr.del',0)
                ->field('srs.*')
                ->order('sr.id desc')
                ->find();
        }

        $stype = 0; // 无累计
        if(!$lastinfo){
            $lastmonth = date('Y-m',strtotime($month.'-01') - 24*60*60); // 上个月
            $lastinfo = Db::name('salary_record')
                ->alias('sr')
                ->join('salary_record_special srs','srs.salary_record_id = sr.id')
                ->where('sr.month',$lastmonth)
                ->where('srs.user_id',$userId)
                ->where('sr.type',$type)
                ->where('sr.del',0)
                ->field('srs.*')
                ->order('sr.id desc')
                ->find();
            if($lastinfo){
                $stype = 2; // 有上月累计
            }
        }else{
            $stype = 1; // 有本月累计
        }

        if(!$lastinfo){
            $lastinfo = Db::name('user_total')->where('user_id',$userId)->find();
            if($lastinfo){
                $stype = 3; // 有初始累计
            }
        }

        if($lastinfo){
            $data = [
                'salary' => $lastinfo['salary'],
                'mssr' => $lastinfo['mssr'],
                'sr' => $lastinfo['sr'],
                'ljsr' => $lastinfo['ljsr'],
                'ljjc' => $lastinfo['ljjc'],
                'ljgjj' => $lastinfo['ljgjj'],
                'ljylobx' => $lastinfo['ljylobx'],
                'ljsybx' => $lastinfo['ljsybx'],
                'ljylibx' => $lastinfo['ljylibx'],
                'ljnj' => $lastinfo['ljnj'],
                'ljznjy' => $lastinfo['ljznjy'],
                'ljjxjy' => $lastinfo['ljjxjy'],
                'ljzfdklx' => $lastinfo['ljzfdklx'],
                'ljzfzj' => $lastinfo['ljzfzj'],
                'ljsylr' => $lastinfo['ljsylr'],
                'ljyyezh' => $lastinfo['ljyyezh'],
                'syjkbx' => $lastinfo['syjkbx'],
                'ysylbx' => $lastinfo['ysylbx'],
                'grbk' => $lastinfo['grbk'],
                'jzjbjsb' => $lastinfo['jzjbjsb'],
                'ljgzds' => $lastinfo['ljgzds'],
                'qtkc' => $lastinfo['qtkc'],
                'ljsqljxmhj' => $lastinfo['ljsqljxmhj'],
                'ljykjse' => $lastinfo['ljykjse'],
                'tax' => $lastinfo['tax'],
                'zykcjze' => $lastinfo['zykcjze'],
                'jmsebl' => $lastinfo['jmsebl'],
                'ljgrylj' => $lastinfo['ljgrylj'],
                'extratax' => isset($lastinfo['extratax'])?$lastinfo['extratax']:0
            ];
        }

        $extratax = $data['extratax']; // 额外税差额
        unset($data['extratax']);
        // 使用上月数据计算个税
        $ljkc = $data['ljsr'] - $data['ljsqljxmhj']; // 累计预扣预缴应纳税所得额
        if($ljkc > 0){
            $tax = $this->getYkyjTax($ljkc);// 累计应预扣预缴税额
            $jmse = round($tax*$data['jmsebl'],2); // 减免税额
            $ljykjse = $data['ljykjse'] + $data['tax'];
            $tax = round($tax - $jmse - $ljykjse,2);
            $tax = $tax>0?$tax:0;
            $data['ljykjse'] = $ljykjse;
        }else{
            $tax = 0;
        }
        $data['tax'] = round($tax + $extratax,2);

        $data['salary'] = $should_total;

        $mssr = 0;
        $m = intval(date('m',strtotime($month.'-01')));
        if($jbsalary > 0){ // 发基本工资
            // 加累计值
            $mssr = 0;
            $special = Db::name('user_special')->where('user_id',$userId)->find();
            if($special){}

            $mssr = $special?$special['mssr']:0;
            if($m > 1){
                $data['ljjc'] += 5000; // 减除费用每月只能使用1次
                $data['ljgjj'] += $sbdata['gjjp'] - (!empty($bkdata)?$bkdata['ggj']:0);
                $data['ljylobx'] += $sbdata['ylap'] - (!empty($bkdata)?$bkdata['yla']:0);
                $data['ljsybx'] += $sbdata['syep'] - (!empty($bkdata)?$bkdata['sye']:0);
                $data['ljylibx'] += $sbdata['ylip'] - (!empty($bkdata)?$bkdata['yli']:0);
                $data['ljnj'] += $sbdata['qynjp'] - (!empty($bkdata)?$bkdata['qynj']:0);
                $data['ljznjy'] += $special?$special['znjy']:0;
                $data['ljjxjy'] += $special?$special['jxjy']:0;
                $data['ljzfdklx'] += $special?$special['zfdklx']:0;
                $data['ljzfzj'] += $special?$special['zfzj']:0;
                $data['ljsylr'] += $special?$special['sylr']:0;
                $data['ljyyezh'] += $special?$special['yyezh']:0;
                $data['ljgzds'] += $special?$special['gzds']:0;
                $data['syjkbx'] += $special?$special['syjkbx']:0;
                $data['ysylbx'] += $special?$special['ysylbx']:0;
                $data['grbk'] += $special?$special['grbk']:0;
                $data['jzjbjsb'] += $special?$special['nzjds']:0;
                $data['qtkc'] += $special?$special['qtkc']:0;
                $data['zykcjze'] += $special?$special['zykcjze']:0;
                $data['ljgrylj'] += $special?$special['grylj']:0;
            }else{
                $data['ljjc'] = 5000;
                $data['ljgjj'] = $sbdata['gjjp'] - (!empty($bkdata)?$bkdata['ggj']:0);
                $data['ljylobx'] = $sbdata['ylap'] - (!empty($bkdata)?$bkdata['yla']:0);
                $data['ljsybx'] = $sbdata['syep'] - (!empty($bkdata)?$bkdata['sye']:0);
                $data['ljylibx'] = $sbdata['ylip'] - (!empty($bkdata)?$bkdata['yli']:0);
                $data['ljnj'] = $sbdata['qynjp'] - (!empty($bkdata)?$bkdata['qynj']:0);
                $data['ljznjy'] = $special?$special['znjy']:0;
                $data['ljjxjy'] = $special?$special['jxjy']:0;
                $data['ljzfdklx'] = $special?$special['zfdklx']:0;
                $data['ljzfzj'] = $special?$special['zfzj']:0;
                $data['ljsylr'] = $special?$special['sylr']:0;
                $data['ljgzds'] = $special?$special['gzds']:0;
                $data['ljyyezh'] = $special?$special['yyezh']:0;
                $data['ljykjse'] = 0;
                $data['ljsr'] = 0;
                $data['syjkbx'] = $special?$special['syjkbx']:0;
                $data['ysylbx'] = $special?$special['ysylbx']:0;
                $data['grbk'] = $special?$special['grbk']:0;
                $data['jzjbjsb'] = $special?$special['nzjds']:0;
                $data['qtkc'] = $special?$special['qtkc']:0;
                $data['zykcjze'] = $special?$special['zykcjze']:0;
                $data['ljgrylj'] = $special?$special['grylj']:0;
            }

            $data['jmsebl'] = $special?$special['jmsebl']:0;

            $data['mssr'] = $special?$special['mssr']:0;

        }else{
            if($m == 1 && $stype != 1){
                $data['ljjc'] = 0;
                $data['ljgjj'] = 0;
                $data['ljylobx'] = 0;
                $data['ljsybx'] = 0;
                $data['ljylibx'] = 0;
                $data['ljnj'] = 0;
                $data['ljznjy'] = 0;
                $data['ljjxjy'] = 0;
                $data['ljzfdklx'] = 0;
                $data['ljzfzj'] = 0;
                $data['ljsylr'] = 0;
                $data['ljgzds'] = 0;
                $data['ljykjse'] = 0;
                $data['ljsr'] = 0;
                $data['syjkbx'] = 0;
                $data['ysylbx'] = 0;
                $data['grbk'] = 0;
                $data['jzjbjsb'] = 0;
                $data['qtkc'] = 0;
                $data['zykcjze'] = 0;
                $data['ljsqljxmhj'] = 0;
                $data['jmsebl'] = 0;
                $data['ljyyezh'] = 0;
                $data['ljgrylj'] = 0;
            }
            $data['tax'] = 0; // 补助不算个税,只累计值
        }

        $data['mssr'] = $mssr;
        $data['sr'] = $should_total - $mssr;
        $data['ljsr'] += $data['sr'];
        $data['type'] = $stype;

        $data['ljsqljxmhj'] = $data['ljjc'] + $data['ljgjj'] + $data['ljyyezh'] + $data['ljgrylj'] + $data['ljylobx'] + $data['ljsybx'] + $data['ljylibx'] + $data['ljnj'] + $data['ljznjy']
        + $data['ljjxjy'] + $data['ljzfdklx'] + $data['ljzfzj'] + $data['ljsylr'] + $data['ljgzds'] + $data['syjkbx'] + $data['ysylbx']
        + $data['grbk'] + $data['jzjbjsb'] + $data['zykcjze'] + $data['qtkc'];

        return $data;

    }

    // 社保公积金
    private function getShebao($userId,$companyId,$info,$jbsalary){
        $bls = Db::name('user_bl')->select(); // 社保比例
        $base = Db::name('user_base')->where('user_id',$userId)->find();
        $data = [
            'qynj' => 0,
            'gjj' => 0,
            'sb' => 0,
            'syyl' => 0,
            'gssy' => 0,
            'ylnj' => 0,
            'ylap' => 0,
            'ylac' => 0,
            'syep' => 0,
            'syec' => 0,
            'ylip' => 0,
            'ylic' => 0,
            'gsc' => 0,
            'qynjp' => 0,
            'qynjc' => 0,
            'gjjp' => 0,
            'gjjc' => 0,
        ];
        if(!$base||$jbsalary == 0){ //不是发基本工资就不扣缴社保
            return $data;
        }
        $data['qynj'] = $base['qynj'];
        $data['gjj'] = $base['gjj'];
        $data['sb'] = $base['sb'];
        $data['syyl'] = $base['syyl'];
        $data['gssy'] = $base['gssy'];
        $data['ylnj'] = $base['ylnj'];

        // 计算各项扣除
        foreach ($bls as $key=>$val){
            if($val['company_id'] == $companyId){
                switch ($val['name']){
                    case 'gjj': // 住房公积金，企业和个人只保留整数，四舍五入
                        $data['gjjp'] = round(calculate_money($base['gjj'],$val['p_bl'],$val['p_bl_type'],$val['p_bl_extra'],$val['p_free_bl']));
                        $data['gjjc'] = round(calculate_money($base['gjj'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']));
                        break;
                    case 'qynj':
                        if ($val['company_id'] == 1) {
                            $data['qynjp'] = calculate_money($base['ylnj'], $val['p_bl'], $val['p_bl_type'], $val['p_bl_extra'], $val['p_free_bl']);
                            $data['qynjc'] = calculate_money($base['ylnj'], $val['c_bl'], $val['c_bl_type'], $val['c_bl_extra'], $val['c_free_bl']);
                        } else {
                            $data['qynjp'] = calculate_money($base['qynj'], $val['p_bl'], $val['p_bl_type'], $val['p_bl_extra'], $val['p_free_bl']);
                            $data['qynjc'] = calculate_money($base['qynj'], $val['c_bl'], $val['c_bl_type'], $val['c_bl_extra'], $val['c_free_bl']);
                        }
                        break;
                    case 'yla':
                        if($info['yla']) {
                            if($val['company_id'] == 1){
                                $data['ylap'] = calculate_money($base['ylnj'],$val['p_bl'],$val['p_bl_type'],$val['p_bl_extra'],$val['p_free_bl']);
                                $data['ylac'] = calculate_money($base['ylnj'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']);
                            } else {
                                $data['ylap'] = calculate_money($base['sb'],$val['p_bl'],$val['p_bl_type'],$val['p_bl_extra'],$val['p_free_bl']);
                                $data['ylac'] = calculate_money($base['sb'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']);
                            }
                        }
                        break;
                    case 'sye':
                        if($val['company_id'] == 1){
                            $data['syep'] = calculate_money($base['gssy'],$val['p_bl'],$val['p_bl_type'],$val['p_bl_extra'],$val['p_free_bl']);
                            $data['syec'] = calculate_money($base['gssy'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']);
                        } else {
                            $data['syep'] = calculate_money($base['sb'],$val['p_bl'],$val['p_bl_type'],$val['p_bl_extra'],$val['p_free_bl']);
                            $data['syec'] = calculate_money($base['sb'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']);
                        }
                        break;
                    case 'yli':
                        if($val['company_id'] == 1){
                            $data['ylip'] = calculate_money($base['syyl'],$val['p_bl'],$val['p_bl_type'],$val['p_bl_extra'],$val['p_free_bl']);
                            $data['ylic'] = calculate_money($base['syyl'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']);
                        } else {
                            $data['ylip'] = calculate_money($base['sb'],$val['p_bl'],$val['p_bl_type'],$val['p_bl_extra'],$val['p_free_bl']);
                            $data['ylic'] = calculate_money($base['sb'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']);
                        }
                        break;
                    case 'gs':
                        if($val['company_id'] == 1){
                            $data['gsc'] = calculate_money($base['gssy'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']);
                        } else {
                            $data['gsc'] = calculate_money($base['sb'],$val['c_bl'],$val['c_bl_type'],$val['c_bl_extra'],$val['c_free_bl']);
                        }
                        break;
                }
            }
        }

        if(!$info['gjj']){
            $data['gjjp'] = 0;
            $data['gjjc'] = 0;
        }
        if(!$info['qynj']){
            $data['qynjp'] = 0;
            $data['gjjc'] = 0;
        }
        if(!$info['yla']){
            $data['ylap'] = 0;
            $data['ylac'] = 0;
        }
        if(!$info['sye']){
            $data['syep'] = 0;
            $data['syec'] = 0;
        }
        if(!$info['yli']){
            $data['ylip'] = 0;
            $data['ylic'] = 0;
        }
        if(!$info['gs']){
            $data['gsc'] = 0;
        }
        return $data;
    }

    // 获取劳务费个税
    public function getLaborTax($salary,$userId){
//        =ROUND(MAX((MIN((G4)*0.8,(G4)-800)*{0;20;30;40}%-1000*{0;0;2;7}),0),2) //计算公式

        if($salary*0.8 <= $salary - 800){
            $salary = $salary*0.8;
        }else{
            $salary = $salary - 800;
        }

        $arr = [
            $salary*0 - 0,
            $salary*0.2 - 0,
            $salary*0.3 - 2000,
            $salary*0.4 - 7000,
            0
        ];
        $tax = max($arr);
        if($tax > 0){
            $bl = Db::name('user_jmlabor')->where('user_id',$userId)->value('jmsebl');
            $bl = $bl?$bl:0;
            if($bl > 0){
                $tax = (1 - $bl)*$tax;
            }
        }

        $tax = round($tax,2);
        return $tax;
    }

    public function preAdd($data,$orgId){
        $uids = model('User')->getAdminUsers();
        if($uids){
            $map[] = ['u.id','not in',$uids];
        }
        $map[] = ['u.del','=',0];
        $map[] = ['r.type','=',3];
        $map[] = ['r.org_id','=',$orgId];

        if($data['type'] == 6){
            $map[] = ['ui.pay_type','=',1];
        } else if($data['type'] == 7){
            $map[] = ['ui.pay_type','=',2];
        } else if($data['type'] == 8){
            $map[] = ['ui.pay_type','=',3];
        } else if($data['type'] == 9){
            $map[] = ['ui.pay_type','=',4];
        } else {
            $map[] = ['ui.pay_type','=',$data['type']];
        }
        $lists = Db::name('user_info')
            ->alias('ui')
            ->join('user u','ui.user_id = u.id')
            ->join('user_roles ur','ur.user_id = u.id')
            ->join('roles r','ur.roles_id = r.id')
            ->where($map)
            ->field('u.phone,ui.company_id,ui.user_id,ui.name,ui.gender,ui.work_date,ui.company_id,ui.pwlevel,ui.type,ui.psid,ui.fixed_performance,ui.child')
            ->order('ui.sorts3 asc,u.id desc')
            ->select();
        if(!$lists){
            HelpHander::error('该工资类型下无可发放工资的人员');
        }
        $types = [];
        if($data['types']){
            $types = Db::name('user_subsidies')
                ->where('id','in',$data['types'])
                ->where('del',0)
                ->order('sorts asc,id asc')
                ->select();
        }

        foreach ($lists as $k=>$v){
            $lists[$k]['user_sn'] = think_encrypt($v['user_id']);
            if(in_array($data['type'],[6,7,8,9])){
                $lists[$k]['level'] = '';
                $lists[$k]['factor'] = '';
                $lists[$k]['months'] = '';
                $lists[$k]['taxrate'] = '';
                $lists[$k]['tax'] = '';
                $lists[$k]['salary'] = '';
                $lists[$k]['should_total'] = '';
                $lists[$k]['psyear'] = '';
            }
            $lists[$k]['pwstatus'] = 0; // 薪级变化状态
            $lists[$k]['work_age'] = $v['work_date']?calculate_age($v['work_date']):0; // 工龄
            if($data['type'] == 5){
                $retired = Db::name('user_retired')->where('user_id',$v['user_id'])->find();
                $lists[$k]['bz'] = $retired?$retired['bz']:0;
                $lists[$k]['zysdbt'] = $retired?$retired['zysdbt']:0;
                $lists[$k]['fb'] = $retired?$retired['fb']:0;
                $lists[$k]['wybt'] = $retired?$retired['wybt']:0;
            }else{
                $lists[$k]['psname'] = '';
                $lists[$k]['psmonth'] = 0;
//                $lists[$k]['psyear'] = 0;
                $lists[$k]['psmoney'] = 0;
                if($lists[$k]['psid'] > 0){
                    $psinfo = Db::name('post_salary')->where('id',$v['psid'])->find();
                    if($psinfo){
                        $lists[$k]['psname'] = $psinfo['job'];
                        $lists[$k]['psmoney'] = $psinfo['money'];
//                        $lists[$k]['psyear'] = $psinfo['year_performance'];
                        $lists[$k]['psmonth'] = $psinfo['month_performance'];
                        if($lists[$k]['work_age'] > 25 && $psinfo['month_performance2'] > 0){
                            $lists[$k]['psmonth'] = $psinfo['month_performance2'];
                        }
//                        if($lists[$k]['work_age'] > 25 && $psinfo['year_performance2'] > 0){
//                            $lists[$k]['psyear'] = $psinfo['year_performance2'];
//                        }
                    }
                }

                $lists[$k]['pwmoney'] = 0;
                if($v['type'] > 0 && $v['company_id'] > 0){
                    $pay_wages = Db::name('pay_wages')
                        ->where('company_id',$v['company_id'])
                        ->where('type',$v['type'])
                        ->value('content');
                    $pay_wages = $pay_wages?json_decode($pay_wages,true):[];
                    foreach ($pay_wages as $kk=>$vv){
                        if($v['pwlevel'] == $vv['level']){
                            $lists[$k]['pwmoney'] = $vv['money'];
                            break;
                        }
                    }
                }
                if($data['type'] == 1||$data['type'] == 2){
                    $lists[$k]['gjj'] = true;
                    $lists[$k]['yla'] = true;
                    $lists[$k]['sye'] = true;
                    $lists[$k]['yli'] = true;
                    $lists[$k]['qynj'] = true;
                    $lists[$k]['gs'] = true;
                }
            }

            $lastmonth = date('Y-m',strtotime($data['month'].'-01') - 1000);
            $btjson = null;
            $log = null;
            if($data['type'] != 5 && $data['continue'] == 1){ //延续上月，获取上月补贴,只获取基本工资的补贴项
                $log = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where('sr.month',$data['month'])
                    ->where('srl.user_id',$v['user_id'])
                    ->where('sr.status','in',[1,2])
                    ->where('srl.gwgz','>',0)
                    ->where('sr.del',0)
                    ->field('srl.*')
                    ->order('srl.id desc')
                    ->find();
                if(!$log){
                    $log = Db::name('salary_record_log')
                        ->alias('srl')
                        ->join('salary_record sr','sr.id = srl.salary_record_id')
                        ->where('sr.month',$lastmonth)
                        ->where('srl.user_id',$v['user_id'])
                        ->where('sr.status','in',[1,2])
                        ->where('srl.gwgz','>',0)
                        ->where('sr.del',0)
                        ->field('srl.*')
                        ->order('srl.id desc')
                        ->find();
                }

                if(!empty($log) && ($data['type'] == 3||$data['type'] == 4)){ // 劳务基本工资项也要继承上次的
                    $lists[$k]['psmoney'] = $log['gwgz'];
                    $lists[$k]['pwmoney'] = $log['xjgz'];
                    $lists[$k]['fixed_performance'] = $log['jcjx'];
                    $lists[$k]['psmonth'] = $log['yjx'];
                }

                if(!empty($log) && ($v['pwlevel'] != $log['pwlevel'])){ // 有薪级变化
                    $lists[$k]['pwstatus'] = 1;
                }

                $btjson = !empty($log)?$log['btjson']:null;
                /*$btjson = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where('sr.month',$data['month'])
                    ->where('srl.user_id',$v['user_id'])
                    ->where('sr.status','in',[1,2])
                    ->where('srl.gwgz','>',0)
                    ->where('sr.del',0)
                    ->value('btjson');
                if(!$btjson){
                    $btjson = Db::name('salary_record_log')
                        ->alias('srl')
                        ->join('salary_record sr','sr.id = srl.salary_record_id')
                        ->where('sr.month',$lastmonth)
                        ->where('srl.user_id',$v['user_id'])
                        ->where('sr.status','in',[1,2])
                        ->where('srl.gwgz','>',0)
                        ->where('sr.del',0)
                        ->value('btjson');
                }*/
            }else if($data['type'] == 5 && $data['continue'] == 1){
                $btjson = Db::name('user_retired_salary')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where('sr.month',$data['month'])
                    ->where('srl.user_id',$v['user_id'])
                    ->where('sr.status','in',[1,2])
                    ->where('sr.del',0)
                    ->order('srl.id desc')
                    ->value('btjson');
                if(!$btjson){
                    $btjson = Db::name('user_retired_salary')
                        ->alias('srl')
                        ->join('salary_record sr','sr.id = srl.salary_record_id')
                        ->where('sr.month',$lastmonth)
                        ->where('srl.user_id',$v['user_id'])
                        ->where('sr.status','in',[1,2])
                        ->where('sr.del',0)
                        ->order('srl.id desc')
                        ->value('btjson');
                }
            }
            $btjson = !empty($btjson)?json_decode($btjson,true):[];
            foreach ($types as $kk=>$vv){
                if(empty($btjson)){
                    $lists[$k]['subsidies'.$vv['id']] = $this->getBtByName($vv,$lists[$k]['psid'],$lists[$k]['work_age'],$data['type'],$v['gender']);
                }else{
                    $flag = 1;
                    foreach ($btjson as $key=>$val){
                        if($val['id'] == $vv['id']){
                            $flag = 0;
                            $lists[$k]['subsidies'.$vv['id']] = $val['money'];
                        }
                    }
                    if($flag == 1){ // 无相同的分类
                        $lists[$k]['subsidies'.$vv['id']] = $this->getBtByName($vv,$lists[$k]['psid'],$lists[$k]['work_age'],$data['type'],$v['gender']);
                    }
                }
            }
        }

        return ['types' => $types,'list' => $lists];

    }

    // 重新计算
    public function reloadAdd($salaryRecordId,$uid,$orgId,$verification=1){
        $data = Db::name('salary_record')->where('id',$salaryRecordId)->find();

        // 判断下记录是否存在
        $ret = Db::name('salary_record_log')->where('salary_record_id',$salaryRecordId)->where('user_id',$uid)->find();
        if($verification == 1 && !$ret){
            HelpHander::error('记录不存在');
        }

        $map[] = ['u.id','=',$uid];
        $map[] = ['u.del','=',0];
        $map[] = ['r.type','=',3];
        $map[] = ['r.org_id','=',$orgId];
        // 不再判断类型，已发放时为准
        /*if($data['type'] == 1||$data['type'] == 6){
            $map[] = ['ui.pay_type','=',1];
        }else if($data['type'] == 2||$data['type'] == 7){
            $map[] = ['ui.pay_type','=',2];
        }else if($data['type'] == 3||$data['type'] == 8){
            $map[] = ['ui.pay_type','=',3];
        }else if($data['type'] == 4||$data['type'] == 9){
            $map[] = ['ui.pay_type','=',4];
        }else{
            $map[] = ['ui.pay_type','=',$data['type']];
        }*/

        $lists = Db::name('user_info')
            ->alias('ui')
            ->join('user u','ui.user_id = u.id')
            ->join('user_roles ur','ur.user_id = u.id')
            ->join('roles r','ur.roles_id = r.id')
            ->where($map)
            ->field('u.phone,ui.company_id,ui.user_id,ui.name,ui.gender,ui.work_date,ui.company_id,ui.pwlevel,ui.type,ui.psid,ui.fixed_performance,ui.child')
            ->order('ui.sorts3 asc,u.id desc')
            ->select();
        if($verification == 1 && !$lists){
            HelpHander::error('该工资类型下无可发放工资的人员');
        }
        $types = [];
        if($data['types']){
            $types = Db::name('user_subsidies')->where('id','in',$data['types'])->where('del',0)->order('sorts asc')->select();
        }

        foreach ($lists as $k=>$v){
            if(in_array($data['type'],[6,7,8,9])){
                $log = Db::name('salary_record_log')
                    ->where('salary_record_id',$salaryRecordId)
                    ->where('user_id',$v['user_id'])
                    ->find();
                $lists[$k]['level'] = $log?$log['level']:'';
                $lists[$k]['factor'] = $log?$log['factor']:'';
                $lists[$k]['months'] = $log?$log['months']:'';
                $lists[$k]['taxrate'] = $log?$log['taxrate']:'';
                $lists[$k]['tax'] = $log?$log['tax']:'';
                $lists[$k]['salary'] = $log?$log['salary']:'';
                $lists[$k]['should_total'] = $log?$log['should_total']:'';
                $lists[$k]['psyear'] = $log?$log['njx']:'';
            }
            $lists[$k]['work_age'] = $v['work_date']?calculate_age($v['work_date']):0; // 工龄
            if($data['type'] == 5){
                $retired = Db::name('user_retired')->where('user_id',$v['user_id'])->find();
                $lists[$k]['bz'] = $retired?$retired['bz']:0;
                $lists[$k]['zysdbt'] = $retired?$retired['zysdbt']:0;
                $lists[$k]['fb'] = $retired?$retired['fb']:0;
                $lists[$k]['wybt'] = $retired?$retired['wybt']:0;
            }else{
                $lists[$k]['psname'] = '';
                $lists[$k]['psmonth'] = 0;
                $lists[$k]['psmoney'] = 0;
                if($lists[$k]['psid'] > 0){
                    $psinfo = Db::name('post_salary')->where('id',$v['psid'])->find();
                    if($psinfo){
                        $lists[$k]['psname'] = $psinfo['job'];
                        $lists[$k]['psmoney'] = $psinfo['money'];
                        $lists[$k]['psmonth'] = $psinfo['month_performance'];
                        if($lists[$k]['work_age'] > 25 && $psinfo['month_performance2'] > 0){
                            $lists[$k]['psmonth'] = $psinfo['month_performance2'];
                        }
                    }
                }

                $lists[$k]['pwmoney'] = 0;
                if($v['type'] > 0 && $v['company_id'] > 0){
                    $pay_wages = Db::name('pay_wages')
                        ->where('company_id',$v['company_id'])
                        ->where('type',$v['type'])
                        ->value('content');
                    $pay_wages = $pay_wages?json_decode($pay_wages,true):[];
                    foreach ($pay_wages as $kk=>$vv){
                        if($v['pwlevel'] == $vv['level']){
                            $lists[$k]['pwmoney'] = $vv['money'];
                            break;
                        }
                    }
                }
                if($data['type'] == 1||$data['type'] == 2){
                    $lists[$k]['gjj'] = true;
                    $lists[$k]['yla'] = true;
                    $lists[$k]['sye'] = true;
                    $lists[$k]['yli'] = true;
                    $lists[$k]['qynj'] = true;
                    $lists[$k]['gs'] = true;
                    // 检查开关
                    $sbinfo = Db::name('salary_record_sb')->where('salary_record_id',$salaryRecordId)->where('user_id',$v['user_id'])->find();
                    if($sbinfo){
                        if($sbinfo['gjjp'] <= 0){
                            $lists[$k]['gjj'] = false;
                        }
                        if($sbinfo['ylap'] <= 0){
                            $lists[$k]['yla'] = false;
                        }
                        if($sbinfo['syep'] <= 0){
                            $lists[$k]['sye'] = false;
                        }
                        if($sbinfo['ylip'] <= 0){
                            $lists[$k]['yli'] = false;
                        }
                        if($sbinfo['gsc'] <= 0){
                            $lists[$k]['gs'] = false;
                        }
                        if($sbinfo['qynjp'] <= 0){
                            $lists[$k]['qynj'] = false;
                        }
                    }else{
                        $lists[$k]['gjj'] = false;
                        $lists[$k]['yla'] = false;
                        $lists[$k]['sye'] = false;
                        $lists[$k]['yli'] = false;
                        $lists[$k]['qynj'] = false;
                        $lists[$k]['gs'] = false;
                    }
                }
            }
            $btjson = null;
            $log = null;
            if($data['type'] != 5){
                $log = Db::name('salary_record_log')
                    ->where('salary_record_id',$salaryRecordId)
                    ->where('user_id',$uid)
                    ->find();
                if(!empty($log)){
                    $lists[$k]['psmoney'] = $log['gwgz'];
                    $lists[$k]['pwmoney'] = $log['xjgz'];
                    $lists[$k]['fixed_performance'] = $log['jcjx'];
                    $lists[$k]['psmonth'] = $log['yjx'];
                }

                $btjson = !empty($log)?$log['btjson']:null;
            }else{
                $btjson = Db::name('user_retired_salary')
                    ->where('salary_record_id',$salaryRecordId)
                    ->where('user_id',$uid)
                    ->value('btjson');
            }

            $btjson = !empty($btjson)?json_decode($btjson,true):[];
            foreach ($types as $kk=>$vv){
                if(empty($btjson)){
                    $lists[$k]['subsidies'.$vv['id']] = $this->getBtByName($vv,$lists[$k]['psid'],$lists[$k]['work_age'],$data['type'],$v['gender']);
                }else{
                    $flag = 1;
                    foreach ($btjson as $key=>$val){
                        if($val['id'] == $vv['id']){
                            $flag = 0;
                            $lists[$k]['subsidies'.$vv['id']] = $val['money'];
                        }
                    }
                    if($flag == 1){ // 无相同的分类
                        $lists[$k]['subsidies'.$vv['id']] = $this->getBtByName($vv,$lists[$k]['psid'],$lists[$k]['work_age'],$data['type'],$v['gender']);
                    }
                }
            }

//            foreach ($types as $kk=>$vv){
//                $lists[$k]['subsidies'.$vv['id']] = $this->getBtByName($vv,$lists[$k]['psid'],$lists[$k]['work_age'],$data['type'],$v['gender']);
//            }
        }

        return ['types' => $types,'list' => $lists];

    }

    private function getBtByName($info,$psid,$age,$payType,$gender){
        $val = 0;
        if($payType == 1){ // 中心在编
            if($info['type'] == 1){
                if($info['gender'] == 0){
                    $val = $info['money'];
                }else if($info['gender'] != 0&&$info['gender'] == $gender){
                    $val = $info['money'];
                }
            }else if($info['type'] == 3){ // 检测上个月的记录
                $val = 0;
            } else {
                $dd = json_decode($info['values'],true);
                $dd = $dd?$dd:[];
                foreach ($dd as $k=>$v){
                    if($v['id'] == $psid){
                        if($v['money2']){
                            if($age < 15){
                                $val = $v['money1'];
                            } else if ($age >= 15 && $age < 25){
                                $val = $v['money2'];
                            }else{
                                $val = $v['money3'];
                            }
                        }else{
                            $val = $v['money1'];
                        }
                        break;
                    }
                }

                if($info['gender'] != 0&&$info['gender'] != $gender){
                    $val = 0;
                }
            }
        }else{
            if($info['type'] == 1){
                if($info['gender'] == 0){
                    $val = $info['money'];
                }else if($info['gender'] != 0&&$info['gender'] == $gender){
                    $val = $info['money'];
                }
            }else if($info['type'] == 3){ // 检测上个月的记录
                $val = 0;
            }
        }

        return $val;
    }

    public function info($id){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('数据不存在');
        }
        $types = [];
        $tids = [];
        if($info['types']){
            $tids = explode(',',$info['types']);
            $types = Db::name('user_subsidies')->where('id','in',$info['types'])->select();
        }
        $info['types'] = $types;
        $alltypes = Db::name('user_subsidies')->where('del',0)->where('pay_type',$info['type'])->select();
        $addtypes = [];
        foreach ($alltypes as $v){
            if(!in_array($v['id'],$tids)){
                $addtypes[] = $v;
            }
        }
        $info['addtypes'] = $addtypes;

        $info['sarlist'] = [];
        if($info['status'] == 0){ // 审核中
            $sarlist = Db::name('salary_apply_record')
                ->alias('sar')
                ->join('salary_apply sa','sa.id = sar.salary_apply_id')
                ->where('sar.salary_apply_id',$info['cur_node'])
                ->where('sar.salary_record_id',$info['id'])
                ->where('sar.del',0)
                ->field('sa.cate,sar.*')
                ->order('sar.id asc')
                ->select();
            foreach ($sarlist as $k=>$v){
                $sarlist[$k]['userName'] = Db::name('user_info')->where('user_id',$v['user_id'])->value('name');
            }
            $info['sarlist'] = $sarlist;
        }
        // 计算实发总金额
        if($info['type'] == 5){
            $totalSalary = Db::name('user_retired_salary')->where('salary_record_id',$id)->sum('salary');
        }else{
            $totalSalary = Db::name('salary_record_log')->where('salary_record_id',$id)->sum('salary');
        }
        $info['total_salary'] = $totalSalary;

        //获取已审批人员
        $alist = Db::name('salary_apply_record')
            ->alias('sar')
            ->join('salary_record sr','sr.id = sar.salary_record_id')
            ->join('user_info ui','ui.user_id = sar.user_id')
            ->where('sar.salary_record_id',$id)
            ->where('sar.status',1)
            ->where('sar.del',0)
            ->field('sar.*,ui.name as user_name')
            ->order('sar.id desc')
            ->select();
        $info['alist'] = $alist?$alist:[];

        return $info;
    }

    public function lists($page,$size,$month,$type){
        if($month != ''){
            $map[] = ['month','=',$month];
        }
        if($type >= 0){
            $map[] = ['type','=',$type];
        }
        $map[] = ['del','=',0];
        $map = empty($map)?true:$map;
        $lists = Db::name('salary_record')
            ->where($map)
            ->page($page,$size)
            ->order('id desc')
            ->select();
        foreach ($lists as $k=>$v){
            // 计算实发总金额
            if($v['type'] == 5){
                $totalSalary = Db::name('user_retired_salary')->where('salary_record_id',$v['id'])->sum('salary');
            }else{
                $totalSalary = Db::name('salary_record_log')->where('salary_record_id',$v['id'])->sum('salary');
            }
            $lists[$k]['total_salary'] = $totalSalary;
        }
        $total = Db::name('salary_record')
            ->where($map)->count();
        $data = [
            'total' => $total,
            'list' => $lists?$lists:[]
        ];
        return $data;
    }

    public function payinfo($id){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('数据不存在');
        }
        $info['user_name'] = Db::name('user_info')->where('user_id',$info['user_id'])->value('name');
        if($info['status'] == 1||$info['status'] == 2){
            $last_time = Db::name('salary_apply_record')
                ->where('salary_record_id',$info['id'])
                ->where('status',1)
                ->where('del',0)
                ->order('id desc')
                ->value('update_time');
            $info['last_time'] = date('Y年m月d日',strtotime($last_time));
            if($info['id'] > 407){
                $rsinfo = Db::name('salary_apply_record')
                    ->alias('sar')
//                    ->join('salary_apply sa','sa.id = sar.salary_apply_id')
                    ->join('user_info ui','ui.user_id = sar.user_id')
                    ->where('sar.salary_record_id',$info['id'])
                    ->where('sar.status',1)
                    ->where('sar.sign',2)
                    ->where('sar.del',0)
                    ->order('sar.id asc')
                    ->value('ui.name');
                $info['rsl_user_name'] = $rsinfo?$rsinfo:'';

                $cwinfo = Db::name('salary_apply_record')
                    ->alias('sar')
//                    ->join('salary_apply sa','sa.id = sar.salary_apply_id')
                    ->join('user_info ui','ui.user_id = sar.user_id')
                    ->where('sar.sign',1)
                    ->where('sar.status',1)
                    ->where('sar.del',0)
                    ->where('sar.salary_record_id',$info['id'])
                    ->order('sar.id asc')
                    ->value('ui.name');
                $info['kj_user_name'] = $cwinfo?$cwinfo:'';

                $cwlinfo = Db::name('salary_apply_record')
                    ->alias('sar')
//                    ->join('salary_apply sa','sa.id = sar.salary_apply_id')
                    ->join('user_info ui','ui.user_id = sar.user_id')
                    ->where('sar.salary_record_id',$info['id'])
                    ->where('sar.sign',3)
                    ->where('sar.status',1)
                    ->where('sar.del',0)
                    ->order('sar.id asc')
                    ->value('ui.name');
                $info['cwl_user_name'] = $cwlinfo?$cwlinfo:'';
            }else{
                $rsinfo = Db::name('salary_apply_record')
                    ->alias('sar')
                    ->join('salary_apply sa','sa.id = sar.salary_apply_id')
                    ->join('user_info ui','ui.user_id = sar.user_id')
                    ->where('sar.salary_record_id',$info['id'])
                    ->where('sar.status',1)
                    ->where('sa.cate',2)
                    ->where('sar.del',0)
                    ->order('sar.id asc')
                    ->value('ui.name');
                $info['rsl_user_name'] = $rsinfo?$rsinfo:'';

                $cwinfo = Db::name('salary_apply_record')
                    ->alias('sar')
                    ->join('salary_apply sa','sa.id = sar.salary_apply_id')
                    ->join('user_info ui','ui.user_id = sar.user_id')
                    ->where('sa.cate',3)
                    ->where('sar.status',1)
                    ->where('sar.del',0)
                    ->where('sar.salary_record_id',$info['id'])
                    ->order('sar.id asc')
                    ->value('ui.name');
                $info['kj_user_name'] = $cwinfo?$cwinfo:'';

                $cwlinfo = Db::name('salary_apply_record')
                    ->alias('sar')
                    ->join('salary_apply sa','sa.id = sar.salary_apply_id')
                    ->join('user_info ui','ui.user_id = sar.user_id')
                    ->where('sar.salary_record_id',$info['id'])
                    ->where('sa.cate',4)
                    ->where('sar.status',1)
                    ->where('sar.del',0)
                    ->order('sar.id asc')
                    ->value('ui.name');
                $info['cwl_user_name'] = $cwlinfo?$cwlinfo:'';

                if($info['type'] == 1||$info['type'] == 3||$info['type'] == 5){
                    $info['kj_user_name'] = '郑琳';
                }else{
                    $info['kj_user_name'] = '汪涵';
                }

                $info['cwl_user_name'] = '许倩鸿';
            }
        }else{
            $info['last_time'] = '';
            $info['kj_user_name'] = '';
            $info['rsl_user_name'] = '';
            $info['cwl_user_name'] = '';
        }


        if($info['type'] == 5){
            $totalSalary = Db::name('user_retired_salary')->where('salary_record_id',$id)->sum('salary');
        }else{
            $totalSalary = Db::name('salary_record_log')->where('salary_record_id',$id)->sum('salary');
        }

        $use = "";
        switch ($info['type']){
            case 1:
                $use = "发放中心编制工资";
                break;
            case 2:
                $use = "发放新华聘用工资";
                break;
            case 3:
                $use = "发放中心劳务工资";
                break;
            case 4:
                $use = "发放新华劳务工资";
                break;
            case 5:
                $use = "发放中心退休工资";
                break;
            case 6:
                $use = "发放中心编制工资";
                break;
            case 7:
                $use = "发放新华聘用年绩效";
                break;
            case 8:
                $use = "发放中心劳务年绩效";
                break;
            case 9:
                $use = "发放新华劳务年绩效";
                break;
        }
        $info['use'] = $use;

//        获取上个月
        $lastmonth = get_lastmonth_by_day($info['month'].'-01');
//        社保的汇缴是滞后的，即3月请款单上应汇缴的是2月的社保

        $lastmonthtxt = date('Y年m月',strtotime($lastmonth.'-01'));

        if($info['type'] == 1){
            $month = date('Y年m月',strtotime($info['month'].'-01'));
//            $lastinfo = Db::name('salary_record_sb')
//                ->alias('a')
//                ->join('salary_record b','a.salary_record_id = b.id')
//                ->where('b.month',$lastmonth)
//                ->where('a.ylnj','>',0)
//                ->field('b.*')
//                ->find();
//            if($lastinfo){
//                $info['ylause'] = "基建中心".$lastmonthtxt.$lastinfo['nums']."人职业年金汇缴";
//                $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('ylac');
//                $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('ylap');
//            }else{
//                $info['ylause'] = "基建中心".$lastmonthtxt."0人职业年金汇缴";
//                $hjsalary1 = 0;
//                $hjsalary2 = 0;
//            }

            $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('ylac');
            $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('ylap');
            $info['ylause'] = "基建中心".$lastmonthtxt.$info['nums']."人养老保险汇缴";
            $info['ylasalary'] = round($hjsalary1+$hjsalary2,2);
            $info['ylacompany'] = "中央国家机关养老保险管理中心";

            $info['njcompany'] = "中国建设银行中央国家机关事业单位职业年金基金归集财产";
            $info['njuse'] = "基建中心".$lastmonthtxt.$info['nums']."人职业年金汇缴";
            $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('qynjc');
            $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('qynjp');
            $info['njsalary'] = round($hjsalary1+$hjsalary2,2);


//            if($lastinfo){
//                $info['sbuse'] = "基建中心".$lastmonthtxt.$lastinfo['nums']."人医疗（含生育）、失业、工伤保险汇缴";
//                $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('ylic');
//                $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('ylip');
//                $hjsalary3 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('syec');
//                $hjsalary4 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('syep');
//                $hjsalary5 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('gsc');
//            }else{
//                $info['sbuse'] = "基建中心".$lastmonthtxt."0人医疗（含生育）、失业、工伤保险汇缴";
//                $hjsalary1 = 0;
//                $hjsalary2 = 0;
//                $hjsalary3 = 0;
//                $hjsalary4 = 0;
//                $hjsalary5 = 0;
//            }

            $info['sbuse'] = "基建中心".$lastmonthtxt.$info['nums']."人医疗（含生育）、失业、工伤保险汇缴";
            $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('ylic');
            $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('ylip');
            $hjsalary3 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('syec');
            $hjsalary4 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('syep');
            $hjsalary5 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('gsc');
            $info['sbcompany'] = "国家税务总局北京市西城区税务局";
//            $info['sbuse'] = "基建中心".$month.$info['nums']."人医疗（含生育）、失业、工伤保险汇缴";
            $info['sbsalary'] = round($hjsalary1+$hjsalary2+$hjsalary3+$hjsalary4+$hjsalary5,2);

            $info['gjjcompany'] = "中央国家机关住房资金管理中心";
            $info['gjjuse'] = "基建中心".$month.$info['nums']."人住房公积金汇缴";
            $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('gjjc');
            $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('gjjp');
            $info['gjjsalary'] = round($hjsalary1+$hjsalary2,2);


        }else if($info['type'] == 2){
            $month = date('Y年m月',strtotime($info['month'].'-01'));

            $info['gjjcompany'] = "中央国家机关住房资金管理中心";
            $info['gjjuse'] = "新华公司".$month.$info['nums']."人住房公积金汇缴";
            $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('gjjc');
            $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('gjjp');
            $info['gjjsalary'] = round($hjsalary1+$hjsalary2,2);

            $info['njcompany'] = "中国银行建信养老养颐乐安享集合计划受托财产";
            $info['njuse'] = "新华公司".$month.$info['nums']."人企业年金汇缴";
            $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('qynjc');
            $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('qynjp');
            $info['njsalary'] = round($hjsalary1+$hjsalary2,2);

//            $lastinfo = Db::name('salary_record_sb')
//                ->alias('a')
//                ->join('salary_record b','a.salary_record_id = b.id')
//                ->where('b.month',$lastmonth)
//                ->where('a.sb','>',0)
//                ->field('b.*')
//                ->find();
//            if($lastinfo){
//                $info['sbuse'] = "新华公司".$lastmonthtxt.$lastinfo['nums']."人养老、医疗（含生育）、失业、工伤保险汇缴";
//                $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('ylic');
//                $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('ylip');
//                $hjsalary3 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('syec');
//                $hjsalary4 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('syep');
//                $hjsalary5 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('gsc');
//                $hjsalary6 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('ylac');
//                $hjsalary7 = Db::name('salary_record_sb')->where('salary_record_id',$lastinfo['id'])->sum('ylap');
//            }else{
//                $info['sbuse'] = "新华公司".$lastmonthtxt."0人养老、医疗（含生育）、失业、工伤保险汇缴";
//                $hjsalary1 = 0;
//                $hjsalary2 = 0;
//                $hjsalary3 = 0;
//                $hjsalary4 = 0;
//                $hjsalary5 = 0;
//                $hjsalary6 = 0;
//                $hjsalary7 = 0;
//            }

            $info['sbuse'] = "新华公司".$lastmonthtxt.$info['nums']."人养老、医疗（含生育）、失业、工伤保险汇缴";
            $hjsalary1 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('ylic');
            $hjsalary2 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('ylip');
            $hjsalary3 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('syec');
            $hjsalary4 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('syep');
            $hjsalary5 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('gsc');
            $hjsalary6 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('ylac');
            $hjsalary7 = Db::name('salary_record_sb')->where('salary_record_id',$id)->sum('ylap');

            $info['sbcompany'] = "国家税务总局北京市西城区税务局";
//            $info['sbuse'] = "基建中心".$month.$info['nums']."人养老、医疗（含生育）、失业、工伤保险汇缴";
            $info['sbsalary'] = round($hjsalary1+$hjsalary2+$hjsalary3+$hjsalary4+$hjsalary5+$hjsalary6+$hjsalary7,2);
        }

        $info['total_salary'] = $totalSalary;

        return $info;
    }

    public function del($id){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('数据不存在');
        }
//        if($info['status'] == 2){
//            HelpHander::error('该状态不能删除');
//        }
        $ret = Db::name('salary_record')->where('id',$id)->setField('del',1);
        if(!$ret){
            HelpHander::error('操作失败');
        }

        return true;
    }

    public function send($id){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 3){
            HelpHander::error('该状态不能重新发放');
        }
        $ret = Db::name('salary_record')->where('id',$id)->setField('status',0);
        if(!$ret){
            HelpHander::error('操作失败');
        }

        return true;
    }

    // 工资列表
    public function listLog($page,$size,$name,$id){
        $info = $this->info($id);
        if($info['type'] == 5){ // 退休
            $data = model('UserRetiredSalary')->lists($page,$size,$name,$info['id']);
        } else {
            if($name != ''){
                $map[] = ['ui.name','like','%'.$name.'%'];
            }
            $map[] = ['ur.salary_record_id','=',$info['id']];

            $lists = Db::name('salary_record_log')
                ->alias('ur')
                ->join('user_info ui','ui.user_id = ur.user_id')
                ->where($map)
                ->field('ur.*,ui.name')
                ->page($page,$size)
                ->order('ui.sorts3 asc,ur.id desc')
                ->select();
            $lists = $lists?$lists:[];
            foreach ($lists as $k=>$v){
                $lists[$k]['user_sn'] = think_encrypt($v['user_id']);
                if($info['type'] == 1||$info['type'] == 2){
                    $sb = Db::name('salary_record_sb')->where('salary_record_id',$v['salary_record_id'])->where('user_id',$v['user_id'])->find();
                    $lists[$k]['gjjp'] = $sb?$sb['gjjp']:0;
                    $lists[$k]['qynjp'] = $sb?$sb['qynjp']:0;
                    $lists[$k]['ylap'] = $sb?$sb['ylap']:0;
                    $lists[$k]['syep'] = $sb?$sb['syep']:0;
                    $lists[$k]['ylip'] = $sb?$sb['ylip']:0;
                }
                $btjson = $v['btjson']?json_decode($v['btjson'],true):[];
                $kcmoney = 0;
                foreach ($btjson as $kk=>$vv){
                    $lists[$k]['subsidies'.$vv['id']] = $vv['money'];
                    if($vv['cate'] == 2){ // 扣除项
                        $kcmoney += $vv['money'];
                    }
                }

                $lists[$k]['dktotal'] = round($v['sbgjj'] + $v['tax'] + $kcmoney,2);

                $depjob = Db::name('user_job')
                    ->alias('uj')
                    ->join('job j','j.id = uj.job_id')
                    ->join('dep d','d.id = j.dep_id')
                    ->where('d.enable',1)
                    ->where('uj.user_id',$v['user_id'])
                    ->field('d.name as dep_name,j.name as job_name')
                    ->find();
                $lists[$k]['dep_name'] = $depjob?$depjob['dep_name']:'';

                //职级
                $lists[$k]['job_name'] = Db::name('post_salary')->where('id',$v['psid'])->value('title');
            }
            $total = Db::name('salary_record_log')
                ->alias('ur')
                ->join('user_info ui','ui.user_id = ur.user_id')
                ->where($map)->count();
            $data = [
                'total' => $total,
                'list' => $lists?$lists:[]
            ];
        }
        $data['info'] = $info;
        return $data;
    }

    // 个税累计列表
    public function listSpecial($page,$size,$name,$id){
        $info = $this->info($id);
        if($info){
            if($name != ''){
                $map[] = ['ui.name','like','%'.$name.'%'];
            }
            $map[] = ['ur.salary_record_id','=',$info['id']];

            $lists = Db::name('salary_record_special')
                ->alias('ur')
                ->join('user_info ui','ui.user_id = ur.user_id')
                ->where($map)
                ->field('ur.*,ui.name,ui.pwlevel')
                ->page($page,$size)
                ->order('ui.sorts3 asc,ur.id desc')
                ->select();
            $lists = $lists?$lists:[];
            foreach ($lists as $k=>$v){
                $ljkc = $v['ljsr'] - $v['ljsqljxmhj']; // 累计预扣预缴应纳税所得额
                $lists[$k]['ljkc'] = round($ljkc,2);

                $lists[$k]['ljyykyjsr'] = 0;
                $lists[$k]['jmsr'] = 0;
                $ljykjse = $v['ljykjse'] + $v['tax'];
                $lists[$k]['ljykjse'] = round($ljykjse,2);
                if($ljkc > 0){
                    $tax = $this->getYkyjTax($ljkc); // 累计应预扣预缴税额
                    $lists[$k]['ljyykyjsr'] = round($tax,2);
                    $jmse = round($tax*$v['jmsebl'],2); // 减免税额
                    $lists[$k]['jmsr'] = $jmse;
                    $tax = round($tax - $jmse - $ljykjse,2);
                    $tax = $tax>0?$tax:0;
                }else{
                    $tax = 0;
                }
                $lists[$k]['nextTax'] = $tax;
            }
            $total = Db::name('salary_record_special')
                ->alias('ur')
                ->join('user_info ui','ui.user_id = ur.user_id')
                ->where($map)->count();
            $data = [
                'total' => $total,
                'list' => $lists?$lists:[]
            ];
        }
        $data['info'] = $info;
        return $data;
    }

    // 导出
    public function exportListLog($name,$id){
        $info = $this->info($id);
        if($info['type'] == 5){ // 退休
            $data = model('UserRetiredSalary')->lists(1,100000,$name,$info['id']);
        } else {
            if($name != ''){
                $map[] = ['ui.name','like','%'.$name.'%'];
            }
            $map[] = ['ur.salary_record_id','=',$info['id']];

            $lists = Db::name('salary_record_log')
                ->alias('ur')
                ->join('user_info ui','ui.user_id = ur.user_id')
                ->where($map)
                ->field('ur.*,ui.name,ui.pwlevel')
                ->order('ui.sorts3 asc,ur.id desc')
                ->select();
            $lists = $lists?$lists:[];
            foreach ($lists as $k=>$v){
                if($info['type'] == 1||$info['type'] == 2){
                    $sb = Db::name('salary_record_sb')->where('salary_record_id',$v['salary_record_id'])->where('user_id',$v['user_id'])->find();
                    $lists[$k]['gjjp'] = $sb?$sb['gjjp']:0;
                    $lists[$k]['qynjp'] = $sb?$sb['qynjp']:0;
                    $lists[$k]['ylap'] = $sb?$sb['ylap']:0;
                    $lists[$k]['syep'] = $sb?$sb['syep']:0;
                    $lists[$k]['ylip'] = $sb?$sb['ylip']:0;
                }

                $btjson = $v['btjson']?json_decode($v['btjson'],true):[];
                $kcmoney = 0;
                foreach ($btjson as $kk=>$vv){
                    $lists[$k]['subsidies'.$vv['id']] = $vv['money'];
                    if($vv['cate'] == 2){
                        $kcmoney += $vv['money'];
                    }
                }
                $lists[$k]['dktotal'] = $v['sbgjj'] + $v['tax'] + $kcmoney;
                $depjob = Db::name('user_job')
                    ->alias('uj')
                    ->join('job j','j.id = uj.job_id')
                    ->join('dep d','d.id = j.dep_id')
                    ->where('uj.user_id',$v['user_id'])
                    ->field('d.name as dep_name,j.name as job_name')
                    ->find();
                $lists[$k]['dep_name'] = $depjob?$depjob['dep_name']:'';

                //职级
                $lists[$k]['job_name'] = Db::name('post_salary')->where('id',$v['psid'])->value('title');
            }
            if($lists){
                $darr = $lists[0];

                foreach ($darr as $k=>$v){
                    $darr[$k] = '';
                    if($k == 'name'){
                        $darr[$k] = '合计';
                    }


                    if($info['type'] == 5){
                        $arrs = ['bz','zysdbt','fb','wybt'];
                        if(in_array($k,$arrs)){
                            $val = 0;
                            foreach ($lists as $kk=>$vv){
                                $val += $vv[$k];
                            }
                            $darr[$k] = round($val,2);
                        }
                    }else{
                        $arrs = ['gwgz','xjgz','jcjx','yjx','should_total','child','dktotal','njx','tax'];
                        if(in_array($k,$arrs)){
                            $val = 0;
                            foreach ($lists as $kk=>$vv){
                                $val += $vv[$k];
                            }
                            $darr[$k] = round($val,2);
                        }
                    }
                    $arrs = ['salary'];
                    foreach ($info['types'] as $kkk=>$vvv){
                        $arrs[] = "subsidies".$vvv['id'];
                    }
                    if(in_array($k,$arrs)){

                        $val = 0;
                        foreach ($lists as $kk=>$vv){
                            $val += $vv[$k];
                        }
                        $darr[$k] = round($val,2);
                    }

                    if($info['type'] == 1||$info['type'] == 2){
                        $arrs = ['gjjp','qynjp','ylap','ylip','syep','tax'];
                        if(in_array($k,$arrs)){
                            $val = 0;
                            foreach ($lists as $kk=>$vv){
                                $val += $vv[$k];
                            }
                            $darr[$k] = round($val,2);
                        }
                    }

                    if($info['type'] == 3||$info['type'] == 4){
                        $arrs = ['tax'];
                        if(in_array($k,$arrs)){
                            $val = 0;
                            foreach ($lists as $kk=>$vv){
                                $val += $vv[$k];
                            }
                            $darr[$k] = round($val,2);
                        }
                    }
                }
                $lists[] = $darr;
            }

            //转成数字格式
            $extra = ['dep_name','name','job_name'];
            foreach ($lists as $k=>$v){
                foreach ($v as $kk=>$vv){
                    if(!in_array($kk,$extra)){
                        $v[$kk] = (float)$vv;
                    }
                }
                $lists[$k] = $v;
            }

            $data = [
                'total' => count($lists),
                'list' => $lists?$lists:[]
            ];
        }

        $columns = [
            ["title" => "姓名","key" => "name"]
        ];
        if($info['type'] == 5){
            $columns[] = ["title" => "补助","key" => "bz"];
            $columns[] = ["title" => "中央适当补贴","key" => "zysdbt"];
            $columns[] = ["title" => "房补","key" => "fb"];
            $columns[] = ["title" => "物业补贴","key" => "wybt"];
        }else if(in_array($info['type'],[1,2,3,4])){
            $columns[] = ["title" => "部门","key" => "depName"];
            $columns[] = ["title" => "职级","key" => "jobName"];
            $columns[] = ["title" => "薪级","key" => "pwlevel"];
            $columns[] = ["title" => "岗位工资","key" => "gwgz"];
            $columns[] = ["title" => "薪级工资","key" => "xjgz"];
            $columns[] = ["title" => "基础绩效","key" => "jcjx"];
            $columns[] = ["title" => "月绩效","key" => "yjx"];
        }else if(in_array($info['type'],[6,7])){
            $columns[] = ["title" => "部门","key" => "depName"];
            $columns[] = ["title" => "职级","key" => "jobName"];
            $columns[] = ["title" => "薪级","key" => "pwlevel"];
            $columns[] = ["title" => "年绩效","key" => "njx"];
            $columns[] = ["title" => "等次","key" => "level"];
            $columns[] = ["title" => "系数","key" => "factor"];
            $columns[] = ["title" => "发放月数","key" => "months"];
        }else if(in_array($info['type'],[8,9])){
            $columns[] = ["title" => "部门","key" => "depName"];
            $columns[] = ["title" => "职级","key" => "jobName"];
            $columns[] = ["title" => "薪级","key" => "pwlevel"];
            $columns[] = ["title" => "年绩效","key" => "njx"];
        }

        foreach ($info['types'] as $k=>$v){
            if($v['cate'] == 1){
                $columns[] = ["title" => $v['title'],"key" => "subsidies".$v['id']];
            }
        }
        if($info['type'] != 5){
            $columns[] = ["title" => "应发工资","key" => "shouldTotal"];
        }
        foreach ($info['types'] as $k=>$v){
            if($v['cate'] != 1){
                $columns[] = ["title" => $v['title'],"key" => "subsidies".$v['id']];
            }
        }
        if($info['type'] == 1||$info['type'] == 2){
//            $columns[] = ["title" => "社保公积金代扣","key" => "sbgjj"];
            $columns[] = ["title" => "公积金","key" => "gjjp"];
            if($info['type'] == 1){
                $columns[] = ["title" => "职业年金","key" => "qynjp"];
            }else{
                $columns[] = ["title" => "企业年金","key" => "qynjp"];
            }
            $columns[] = ["title" => "养老保险","key" => "ylap"];
            $columns[] = ["title" => "医疗保险","key" => "ylip"];
            $columns[] = ["title" => "失业保险","key" => "syep"];
        }

        if(in_array($info['type'],[6,7])){
            $columns[] = ["title" => "适用税率","key" => "taxrate"];
        }

        if($info['type'] != 5){
            $columns[] = ["title" => "个税","key" => "tax"];
        }
        if($info['type'] < 5){
            $columns[] = ["title" => "代扣合计","key" => "dktotal"];
        }
        $columns[] = ["title" => "实发工资","key" => "salary"];

        $data = [
            'columns' => $columns,
            'list' => $data['list']
        ];

        return $data;
    }

    public function mySalary($page,$size,$month,$userId){
        if($month != ''){
            $map[] = ['month','=',$month];
        }
        $map[] = ['user_id','=',$userId];
        $lists = Db::name('common_salary')
            ->where($map)
            ->page($page,$size)
            ->order('month desc,id desc')
            ->select();
        foreach ($lists as $k=>$v){
            if($v['type'] == 1){
                $lists[$k]['type_name'] = '中心编制';
            }else if($v['type'] == 2){
                $lists[$k]['type_name'] = '新华聘用';
            }else if($v['type'] == 3){
                $lists[$k]['type_name'] = '中心劳务';
            }else if($v['type'] == 4){
                $lists[$k]['type_name'] = '新华劳务';
            }else if($v['type'] == 6){
                $lists[$k]['type_name'] = '中心编制年绩效';
            }else if($v['type'] == 7){
                $lists[$k]['type_name'] = '新华聘用年绩效';
            }else if($v['type'] == 8){
                $lists[$k]['type_name'] = '中心劳务年绩效';
            }else if($v['type'] == 9){
                $lists[$k]['type_name'] = '新华劳务年绩效';
            }else{
                $lists[$k]['type_name'] = '中心退休';
            }
        }
        $total = Db::name('common_salary')
            ->where($map)->count();
        $data = [
            'total' => $total,
            'list' => $lists?$lists:[]
        ];
        return $data;
    }

    public function salaryDetail($id,$userId){
        $info = Db::name('common_salary')->where('id',$id)->where('user_id',$userId)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['type'] == 5){ // 退休
            $data = Db::name('user_retired_salary')->where('salary_record_id',$id)->where('user_id',$userId)->find();
        }else{ // 其他
            $data = Db::name('salary_record_log')->where('salary_record_id',$id)->where('user_id',$userId)->find();
        }
        if(!$data){
            HelpHander::error('工资不存在');
        }
        $data['pay_type'] = $info['type'];
        $data['btjson'] = $data['btjson']?json_decode($data['btjson'],true):[];
        $btmoney = $kcmoney = 0;
        foreach ($data['btjson'] as $k=>$v){
            if($v['cate'] == 1){ // 补贴
                $btmoney += floatval($v['money']);
            }else{
                $kcmoney += floatval($v['money']);
            }
        }
        $data['btmoney'] = round($btmoney,2);
        $data['kcmoney'] = round($kcmoney,2);
        $data['gjj'] = '0';
        $data['yla'] = '0';
        $data['qynj'] = '0';
        $data['yli'] = '0';
        $data['sye'] = '0';
        $sbdata = Db::name('salary_record_sb')->where('salary_record_id',$id)->where('user_id',$userId)->find();
        if($sbdata){
            $data['gjj'] = $sbdata['gjjp'];
            $data['yla'] = $sbdata['ylap'];
            $data['qynj'] = $sbdata['qynjp'];
            $data['yli'] = $sbdata['ylip'];
            $data['sye'] = $sbdata['syep'];
        }
        return $data;
    }


    public function sbinfo($id,$uid){
        $info = Db::name('salary_record_sb')
            ->alias('srs')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->where('srs.salary_record_id',$id)
            ->where('srs.user_id',$uid)
            ->field('sr.type,srs.*')
            ->find();
        if(!$info){
            HelpHander::error('数据不存在');
        }
        return $info;
    }

    public function taxinfo($id,$uid){
        $info = Db::name('salary_record_special')
            ->alias('srs')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->where('srs.salary_record_id',$id)
            ->where('srs.user_id',$uid)
            ->field('sr.type,srs.*')
            ->find();
        if(!$info){
            HelpHander::error('数据不存在');
        }
        return $info;
    }

    // 同意 或签
    public function agree($id,$userId,$orgId){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 0){
            HelpHander::error('无权限操作');
        }
        $uinfo = Db::name('salary_apply_record')
            ->where('salary_record_id',$id)
            ->where('user_id',$userId)
            ->where('salary_apply_id',$info['cur_node'])
            ->where('status',0)
            ->where('del',0)
            ->find();
        if(!$uinfo){
            HelpHander::error('无权限操作');
        }

        $apply = json_decode($info['apply'],true);

        Db::startTrans();
        try{

            $res = Db::name('salary_apply_record')->where('del',0)->where('id',$uinfo['id'])->update(['status'=>1,'update_time'=>date('Y-m-d H:i:s')]);
            if(!$res){
                \exception('操作失败');
            }

            if($info['cur_node'] == $apply[count($apply)-1]['id']){ // 最后一个节点
                $res2 = Db::name('salary_record')->where('id',$id)->setField('status',1);
                if(!$res2){
                    \exception('操作失败');
                }
            }else{
                // 获取下一节点
                $next = [];
                foreach ($apply as $k=>$v){
                    if($v['id'] == $info['cur_node']){
                        $next = $apply[$k+1];
                        break;
                    }
                }
                $res2 = Db::name('salary_record')->where('id',$id)->setField('cur_node',$next['id']);
                if(!$res2){
                    \exception('操作失败');
                }
                // 生成审核记录
                $uids = explode(',',$next['userids']);
                foreach ($uids as $k=>$v){
                    $sd = [
                        'salary_record_id' => $id,
                        'user_id' => $v,
                        'status' => 0,
                        'create_time' => date('Y-m-d H:i:s'),
                        'salary_apply_id' => $next['id'],
                        'sign' => $next['sign']
                    ];
                    $ret = Db::name('salary_apply_record')->insertGetId($sd);
                    if(!$ret){
                        \exception('操作失败');
                    }

                    model('Message')->add(3,$id,12,$v,$orgId,'工资流程待您的审核确认');
                }
            }
            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            $this->error = '操作失败';
            return false;
        }
        return true;
    }

    // 打回
    public function disagree($id,$userId,$orgId){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 0){
            HelpHander::error('无权限操作');
        }
        $uinfo = Db::name('salary_apply_record')
            ->where('salary_record_id',$id)
            ->where('user_id',$userId)
            ->where('salary_apply_id',$info['cur_node'])
            ->where('status',0)
            ->where('del',0)
            ->find();
        if(!$uinfo){
            HelpHander::error('无权限操作');
        }

        Db::startTrans();
        try{

            $res = Db::name('salary_apply_record')->where('del',0)->where('id',$uinfo['id'])->update(['status'=>2,'update_time'=>date('Y-m-d H:i:s')]);
            if(!$res){
                \exception('操作失败');
            }
            $res2 = Db::name('salary_record')->where('id',$id)->setField('status',3);
            if(!$res2){
                \exception('操作失败');
            }
            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            $this->error = '操作失败';
            return false;
        }
        return true;
    }

    public function reapply($id,$userId,$orgId){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 3 || $info['user_id'] != $userId){
            HelpHander::error('无权限操作');
        }
        Db::startTrans();
        try{
            // 删除原审批记录
            Db::name('salary_apply_record')->where('salary_record_id',$id)->update(['del'=>1,'update_time'=>date('Y-m-d H:i:s')]);
            $apply = json_decode($info['apply'],true);
            $curinfo = $apply[0];
            $res2 = Db::name('salary_record')->where('id',$id)->update(['status'=>0,'cur_node'=>$curinfo['id']]);
            if(!$res2){
                \exception('操作失败');
            }


            // 生成审核记录
            $uids = explode(',',$curinfo['userids']);
            foreach ($uids as $k=>$v){
                $sd = [
                    'salary_record_id' => $id,
                    'user_id' => $v,
                    'status' => 0,
                    'create_time' => date('Y-m-d H:i:s'),
                    'salary_apply_id' => $curinfo['id'],
                    'sign' => $curinfo['sign'],
                ];
                $ret = Db::name('salary_apply_record')->insertGetId($sd);
                if(!$ret){
                    \exception('操作失败');
                }

                model('Message')->add(3,$id,12,$v,$orgId,'工资流程待您的审核确认');
            }

            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            $this->error = '操作失败';
            return false;
        }

        return true;
    }

    // 会签版本
    public function agreeold($id,$userId,$orgId){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 0){
            HelpHander::error('无权限操作');
        }
        $uinfo = Db::name('salary_apply_record')
            ->where('salary_record_id',$id)
            ->where('user_id',$userId)
            ->where('salary_apply_id',$info['cur_node'])
            ->where('status',0)
            ->where('del',0)
            ->find();
        if(!$uinfo){
            HelpHander::error('无权限操作');
        }
        // 检查是否有除自己之外的未处理的人
        $others = Db::name('salary_apply_record')
            ->where('salary_record_id',$id)
            ->where('user_id','<>',$userId)
            ->where('salary_apply_id',$info['cur_node'])
            ->where('del',0)
            ->where('status',0)
            ->find();

        $apply = json_decode($info['apply'],true);

        Db::startTrans();
        try{

            $res = Db::name('salary_apply_record')->where('del',0)->where('id',$uinfo['id'])->update(['status'=>1,'update_time'=>date('Y-m-d H:i:s')]);
            if(!$res){
                \exception('操作失败');
            }

            if(!$others){ // 没有未处理的人了，走下一节点
                if($info['cur_node'] == $apply[count($apply)-1]['id']){ // 最后一个节点
                    $res2 = Db::name('salary_record')->where('id',$id)->setField('status',1);
                    if(!$res2){
                        \exception('操作失败');
                    }
                }else{
                    // 获取下一节点
                    $next = [];
                    foreach ($apply as $k=>$v){
                        if($v['id'] == $info['cur_node']){
                            $next = $apply[$k+1];
                            break;
                        }
                    }
                    $res2 = Db::name('salary_record')->where('id',$id)->setField('cur_node',$next['id']);
                    if(!$res2){
                        \exception('操作失败');
                    }
                    // 生成审核记录
                    $uids = explode(',',$next['userids']);
                    foreach ($uids as $k=>$v){
                        $sd = [
                            'salary_record_id' => $id,
                            'user_id' => $v,
                            'status' => 0,
                            'create_time' => date('Y-m-d H:i:s'),
                            'salary_apply_id' => $next['id']
                        ];
                        $ret = Db::name('salary_apply_record')->insertGetId($sd);
                        if(!$ret){
                            \exception('操作失败');
                        }

                        model('Message')->add(3,$id,12,$v,$orgId,'工资流程待您的审核确认');
                    }
                }
            }

            Db::commit();
        }catch (Exception $e){
            Db::rollback();
            return false;
        }
        return true;
    }

    public function confirm($id,$userId){
        $info = Db::name('salary_record')->where('id',$id)->where('del',0)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        if($info['status'] != 1){
            HelpHander::error('无权限操作');
        }
        $res = Db::name('salary_record')->where('id',$id)->update([
            'cw_time' => date('Y-m-d H:i:s'),
            'cw_user_id' => $userId,
            'status' => 2
        ]);
        if(!$res){
            HelpHander::error('操作失败');
        }
        return true;
    }

    // 工资统计
    public function financeSalaryStructure($type,$cate){
        $map[] = ['b.type','=',$cate];
        $map[] = ['b.status','=',2];
        $map[] = ['b.del','=',0];

        if($type == 1){
            $map[] = ['b.month','=',date('Y-m')];
        }else {// 当年
            $year = date('Y');
            $startMonth = $year . '-01';
            $endMonth = ($year + 1) . '-01';
            $map[] = ['b.month','>=',$startMonth];
            $map[] = ['b.month','<',$endMonth];
        }

        if($cate == 5){ // 中心养老
            $total = Db::name('user_retired_salary')
                ->alias('a')
                ->join('salary_record b','b.id = a.salary_record_id')
                ->where($map)
                ->sum('salary');
        }else{// 其他
            $total = Db::name('salary_record_log')
                ->alias('a')
                ->join('salary_record b','b.id = a.salary_record_id')
                ->where($map)
                ->sum('salary');
        }

        return $total;
    }

    public function taxlist($page,$size,$month,$name,$type){
        if($month != ''){
            $map[] = ['sr.month','=',$month];
        }
        if($name != ''){
            $map[] = ['ui.name','=',$name];
        }
        if(in_array($type,[1,2])){
            $map[] = ['sr.type','=',$type];
        }
        $map[] = ['sr.del','=',0];
        $map = empty($map)?true:$map;

        $lists = Db::name('salary_record_special')
            ->alias('srs')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->where($map)
            ->page($page,$size)
            ->order('sr.id desc,ui.sorts3 asc')
            ->field('srs.*,ui.name,sr.month')
            ->select();

        foreach ($lists as $k=>$v){
            $ljkc = $v['ljsr'] - $v['ljsqljxmhj']; // 累计预扣预缴应纳税所得额
            $lists[$k]['ljkc'] = round($ljkc,2);

            $lists[$k]['ljyykyjsr'] = 0;
            $lists[$k]['jmsr'] = 0;
            $ljykjse = $v['ljykjse'] + $v['tax'];
            $lists[$k]['ljykjse'] = round($ljykjse,2);
            if($ljkc > 0){
                $tax = $this->getYkyjTax($ljkc);// 累计应预扣预缴税额
                $lists[$k]['ljyykyjsr'] = round($tax,2);
                $jmse = round($tax*$v['jmsebl'],2); // 减免税额
                $lists[$k]['jmsr'] = $jmse;
                $tax = round($tax - $jmse - $ljykjse,2);
                $tax = $tax>0?$tax:0;
            }else{
                $tax = 0;
            }
            $lists[$k]['nextTax'] = $tax;
        }
        $total = Db::name('salary_record_special')
            ->alias('srs')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->where($map)->count();
        $data = [
            'total' => $total,
            'list' => $lists?$lists:[]
        ];
        return $data;
    }

    // 个税累计列表
    public function ntaxlist($month,$name,$type){
        if($month){
            $map[] = ['sr.month','=',$month];
        }else{
            return [];
        }
        if($name != ''){
            $map[] = ['ui.name','=',$name];
        }
        if(in_array($type,[1,2])){
            $map[] = ['sr.type','=',$type];
        }

        $map[] = ['sr.del','=',0];
        $map = empty($map)?true:$map;

        $lists = Db::name('salary_record_special')
            ->alias('srs')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->where($map)
            ->group('sr.month,srs.user_id')
            ->field('srs.*,ui.name,sr.month')
            ->order('sr.id desc,ui.sorts3 asc')
            ->select();

        foreach ($lists as $k=>$v){
            $children = Db::name('salary_record_special')
                ->alias('srs')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->where('sr.month',$v['month'])
                ->where('srs.user_id',$v['user_id'])
                ->where('sr.del',0)
                ->field('srs.*,ui.name,sr.month')
                ->order('srs.id desc')
                ->select();
            $nsalary = 0;
            $nmssr = 0;
            $nsr = 0;
            foreach ($children as $kk=>$vv){
                $ljkc = $vv['ljsr'] - $vv['ljsqljxmhj']; // 累计预扣预缴应纳税所得额
                $children[$kk]['ljkc'] = round($ljkc,2);

                $children[$kk]['ljyykyjsr'] = 0;
                $children[$kk]['jmsr'] = 0;
                $ljykjse = $vv['ljykjse'] + $vv['tax'];
                $children[$kk]['ljykjse'] = round($ljykjse,2);
                if($ljkc > 0){
                    $tax = $this->getYkyjTax($ljkc);// 累计应预扣预缴税额
                    $children[$kk]['ljyykyjsr'] = round($tax,2);
                    $jmse = round($tax*$vv['jmsebl'],2); // 减免税额
                    $children[$kk]['jmsr'] = $jmse;
                    $tax = round($tax - $jmse - $ljykjse,2);
                    $tax = $tax>0?$tax:0;
                }else{
                    $tax = 0;
                }
                $children[$kk]['nextTax'] = $tax;
                $children[$kk]['child'] = 1;

                $nsalary += $vv['salary'];
                $nmssr += $vv['mssr'];
                $nsr += $vv['sr'];
                $children[$kk]['nsalary'] = $vv['salary'];
                $children[$kk]['nmssr'] = $vv['mssr'];
                $children[$kk]['nsr'] = $vv['sr'];
                $children[$kk]['unique'] = 'C'.$vv['id'];
            }

            $lists[$k] = $children[0];
            $lists[$k]['child'] = 0;
            $lists[$k]['nsalary'] = round($nsalary,2);
            $lists[$k]['nmssr'] = round($nmssr,2);
            $lists[$k]['nsr'] = round($nsr,2);
            $lists[$k]['unique'] = $children[0]['id'];

            if(count($children) >= 2){
                $lists[$k]['children'] = $children;
            }
        }
        return $lists?$lists:[];
    }

    public function ntaxexport($month,$name,$type){
        if($month != ''){
            $map[] = ['sr.month','=',$month];
        }
        if($name != ''){
            $map[] = ['ui.name','=',$name];
        }
        if(in_array($type,[1,2])){
            $map[] = ['sr.type','=',$type];
        }
        $map[] = ['sr.del','=',0];
        $map = empty($map)?true:$map;

        $lists = Db::name('salary_record_special')
            ->alias('srs')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->where($map)
            ->group('sr.month,srs.user_id')
            ->field('srs.*,ui.name,sr.month')
            ->order('sr.id desc,ui.sorts3 asc')
            ->select();

        foreach ($lists as $k=>$v){
            $children = Db::name('salary_record_special')
                ->alias('srs')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->where('sr.month',$v['month'])
                ->where('srs.user_id',$v['user_id'])
                ->where('sr.del',0)
                ->field('srs.*,ui.name,sr.month')
                ->order('srs.id desc')
                ->select();
            $nsalary = 0;
            $nmssr = 0;
            $nsr = 0;
            foreach ($children as $kk=>$vv){
                $ljkc = $vv['ljsr'] - $vv['ljsqljxmhj']; // 累计预扣预缴应纳税所得额
                $children[$kk]['ljkc'] = round($ljkc,2);

                $children[$kk]['ljyykyjsr'] = 0;
                $children[$kk]['jmsr'] = 0;
                $ljykjse = $vv['ljykjse'] + $vv['tax'];
                $children[$kk]['ljykjse'] = round($ljykjse,2);
                if($ljkc > 0){
                    $tax = $this->getYkyjTax($ljkc);// 累计应预扣预缴税额
                    $children[$kk]['ljyykyjsr'] = round($tax,2);
                    $jmse = round($tax*$vv['jmsebl'],2); // 减免税额
                    $children[$kk]['jmsr'] = $jmse;
                    $tax = round($tax - $jmse - $ljykjse,2);
                    $tax = $tax>0?$tax:0;
                }else{
                    $tax = 0;
                }
                $children[$kk]['nextTax'] = $tax;
                $children[$kk]['child'] = 1;

                $nsalary += $vv['salary'];
                $nmssr += $vv['mssr'];
                $nsr += $vv['sr'];
                $children[$kk]['nsalary'] = $vv['salary'];
                $children[$kk]['nmssr'] = $vv['mssr'];
                $children[$kk]['nsr'] = $vv['sr'];
                $children[$kk]['unique'] = 'C'.$vv['id'];
            }

            $lists[$k] = $children[0];
            $lists[$k]['child'] = 0;
            $lists[$k]['nsalary'] = round($nsalary,2);
            $lists[$k]['nmssr'] = round($nmssr,2);
            $lists[$k]['nsr'] = round($nsr,2);
            $lists[$k]['unique'] = $children[0]['id'];

            if(count($children) >= 2){
                $lists[$k]['children'] = $children;
            }

        }

        //转成数字格式
        $extra = ['month','name'];
        foreach ($lists as $k=>$v){
            foreach ($v as $kk=>$vv){
                if(!in_array($kk,$extra)){
                    $v[$kk] = (float)$vv;
                }
            }
            $lists[$k] = $v;
        }

        $columns[] = ["title" => "月份","key" => "month"];
        $columns[] = ["title" => "姓名","key" => "name"];
        $columns[] = ["title" => "应发工资","key" => "nsalary"];
        $columns[] = ["title" => "免税收入","key" => "nmssr"];
        $columns[] = ["title" => "应税收入","key" => "nsr"];
        $columns[] = ["title" => "累计应税收入","key" => "ljsr"];
        $columns[] = ["title" => "累计减除费用","key" => "ljjc"];
        $columns[] = ["title" => "累计公积金","key" => "ljgjj"];
        $columns[] = ["title" => "累计养老保险","key" => "ljylobx"];
        $columns[] = ["title" => "累计失业保险","key" => "ljsybx"];
        $columns[] = ["title" => "累计医疗保险","key" => "ljylibx"];
        $columns[] = ["title" => "累计职业年金","key" => "ljnj"];
        $columns[] = ["title" => "累计子女教育","key" => "ljznjy"];
        $columns[] = ["title" => "累计继续教育","key" => "ljjxjy"];
        $columns[] = ["title" => "累计住房贷款利息","key" => "ljzfdklx"];
        $columns[] = ["title" => "累计住房租金","key" => "ljzfzj"];
        $columns[] = ["title" => "累计赡养老人","key" => "ljsylr"];
        $columns[] = ["title" => "商业健康保险","key" => "syjkbx"];
        $columns[] = ["title" => "延税养老保险","key" => "ysylbx"];
        $columns[] = ["title" => "个人补扣/补交社保年金","key" => "grbk"];
        $columns[] = ["title" => "年终奖补交社保年金","key" => "jzjbjsb"];
        $columns[] = ["title" => "工资中补交社保年金","key" => "ljgzds"];
        $columns[] = ["title" => "累计准予扣除的捐赠额","key" => "zykcjze"];
        $columns[] = ["title" => "累计其他扣除","key" => "qtkc"];
        $columns[] = ["title" => "税前扣除项目合计","key" => "ljsqljxmhj"];
        $columns[] = ["title" => "累计预扣预缴应纳税所得额","key" => "ljkc"];
        $columns[] = ["title" => "累计应预扣预缴税额","key" => "ljyykyjsr"];
        $columns[] = ["title" => "减免税额","key" => "jmsr"];
        $columns[] = ["title" => "累计已扣缴税额","key" => "ljykjse"];
        $columns[] = ["title" => "下月应扣个人所得税税额","key" => "nextTax"];

        $data = [
            'columns' => $columns,
            'list' => $lists
        ];

        return $data;
    }

    // 根据累计预扣预缴应纳税所得额获取累计应预扣预缴税额
    public function getYkyjTax($ljkc){
        $tax1 = $ljkc*0.03 - 0;
        $tax2 = $ljkc*0.1 - 2520;
        $tax3 = $ljkc*0.2 - 16920;
        $tax4 = $ljkc*0.25 - 31920;
        $tax5 = $ljkc*0.3 - 52920;
        $tax6 = $ljkc*0.35 - 85920;
        $tax7 = $ljkc*0.45 - 181920;
        $tax = round(max([$tax1,$tax2,$tax3,$tax4,$tax5,$tax6,$tax7]),2); // 累计应预扣预缴税额
        return $tax;
    }

    public function taxEdit(){
        $id = input('id/d',0);
        $info = Db::name('salary_record_special')->where('id',$id)->find();
        if(!$info){
            HelpHander::error('记录不存在');
        }
        $oldljsr = $info['ljsr'] - $info['sr'];
        $data = [
            'id' => input('id/d',0),
            'salary' => input('salary/f',0),
            'mssr' => input('mssr/f',0),
//            'sr' => input('sr/f',0),
//            'ljsr' => input('ljsr/f',0),
            'ljjc' => input('ljjc/f',0),
            'ljgjj' => input('ljgjj/f',0),
            'ljylobx' => input('ljylobx/f',0),
            'ljylibx' => input('ljylibx/f',0),
            'ljsybx' => input('ljsybx/f',0),
            'ljnj' => input('ljnj/f',0),
            'ljznjy' => input('ljznjy/f',0),
            'ljjxjy' => input('ljjxjy/f',0),
            'ljzfdklx' => input('ljzfdklx/f',0),
            'ljzfzj' => input('ljzfzj/f',0),
            'ljsylr' => input('ljsylr/f',0),
            'ljyyezh' => input('ljyyezh/f',0),
            'syjkbx' => input('syjkbx/f',0),
            'ysylbx' => input('ysylbx/f',0),
            'grbk' => input('grbk/f',0),
            'jzjbjsb' => input('jzjbjsb/f',0),
            'ljgzds' => input('ljgzds/f',0),
            'qtkc' => input('qtkc/f',0),
//            'ljsqljxmhj' => input('ljsqljxmhj/f',0),
            'ljykjse' => input('ljykjse/f',0),
            'tax' => input('tax/f',0),
            'zykcjze' => input('zykcjze/f',0),
            'jmsebl' => input('jmsebl/f',0),
            'ljgrylj' => input('ljgrylj/f',0),
        ];
        $data['sr'] = round($data['salary'] - $data['mssr'],2);
        $data['ljsr'] = round($oldljsr + $data['sr'],2);

        $data['ljsqljxmhj'] = $data['ljjc'] + $data['ljgjj'] + $data['ljyyezh'] + $data['ljgrylj'] + $data['ljylobx'] + $data['ljsybx'] + $data['ljylibx'] + $data['ljnj'] + $data['ljznjy']
            + $data['ljjxjy'] + $data['ljzfdklx'] + $data['ljzfzj'] + $data['ljsylr'] + $data['ljgzds'] + $data['syjkbx'] + $data['ysylbx']
            + $data['grbk'] + $data['jzjbjsb'] + $data['zykcjze'] + $data['qtkc'];
        $data['ljsqljxmhj'] = round($data['ljsqljxmhj'],2);

        $ret = Db::name('salary_record_special')->where('id',$data['id'])->update($data);
        if(!$ret){
            HelpHander::error('操作失败');
        }

        $userId = input('userId/d',0);
        model('ActionLog')->add(19,'修改个税累计',$userId,json_encode($data));

        return true;
    }

    // 社保公积金
    public function sblist($month,$name,$type){
        if($month){
            $map[] = ['sr.month','=',$month];
        }else{
            return [];
        }
        if($name != ''){
            $map[] = ['ui.name','=',$name];
        }
        if(in_array($type,[1,2])){
            $map[] = ['sr.type','=',$type];
        }
        $map[] = ['sr.del','=',0];
        $map = empty($map)?true:$map;

        $lists = Db::name('salary_record_sb')
            ->alias('srs')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->where($map)
//            ->page($page,$size)
            ->order('sr.id desc,ui.sorts3 asc')
            ->field('ui.name,sr.month,srs.id,srs.user_id,sum(srs.qynj) as qynj,sum(srs.gjj) as gjj,
            sum(srs.sb) as sb,sum(srs.syyl) as syyl,sum(srs.gssy) as gssy,sum(srs.ylnj) as ylnj,
            sum(srs.gjjp) as gjjp,sum(srs.gjjc) as gjjc,sum(srs.ylap) as ylap,sum(srs.ylac) as ylac,
            sum(srs.syep) as syep,sum(srs.syec) as syec,sum(srs.ylip) as ylip,sum(srs.ylic) as ylic,
            sum(srs.gsc) as gsc,sum(srs.qynjp) as qynjp,sum(srs.qynjc) as qynjc')
            ->group('sr.month,srs.user_id')
            ->select();

        foreach ($lists as $k=>$v){
            $lists[$k]['sbtotalp'] = round($v['ylap'] + $v['syep'] + $v['ylip'],2);
            $lists[$k]['sbtotalc'] = round($v['ylac'] + $v['syec'] + $v['ylic'] + $v['gsc'],2);
            $lists[$k]['sbtotal'] = round($lists[$k]['sbtotalp'] + $lists[$k]['sbtotalc'],2);
            $lists[$k]['gjjtotal'] = round($lists[$k]['gjjp'] + $lists[$k]['gjjc'],2);
            $lists[$k]['qynjtotal'] = round($lists[$k]['qynjp'] + $lists[$k]['qynjc'],2);
        }
//        $total = Db::name('salary_record_sb')
//            ->alias('srs')
//            ->join('salary_record sr','sr.id = srs.salary_record_id')
//            ->join('user_info ui','ui.user_id = srs.user_id')
//            ->where($map)
//            ->group('sr.month,srs.user_id')
//            ->count();
//        $data = [
//            'total' => $total,
//            'list' => $lists?$lists:[]
//        ];
        return $lists?$lists:[];
    }

    public function sbexport($month,$name,$type){
        if($month != ''){
            $map[] = ['sr.month','=',$month];
        }
        if($name != ''){
            $map[] = ['ui.name','=',$name];
        }
        if(in_array($type,[1,2])){
            $map[] = ['sr.type','=',$type];
        }
        $map[] = ['sr.del','=',0];
        $map = empty($map)?true:$map;

        $lists = Db::name('salary_record_sb')
            ->alias('srs')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->where($map)
            ->order('sr.id desc,ui.sorts3 asc')
            ->field('ui.name,sr.month,srs.id,srs.user_id,sum(srs.qynj) as qynj,sum(srs.gjj) as gjj,
            sum(srs.sb) as sb,sum(srs.syyl) as syyl,sum(srs.gssy) as gssy,sum(srs.ylnj) as ylnj,
            sum(srs.gjjp) as gjjp,sum(srs.gjjc) as gjjc,sum(srs.ylap) as ylap,sum(srs.ylac) as ylac,
            sum(srs.syep) as syep,sum(srs.syec) as syec,sum(srs.ylip) as ylip,sum(srs.ylic) as ylic,
            sum(srs.gsc) as gsc,sum(srs.qynjp) as qynjp,sum(srs.qynjc) as qynjc')
            ->group('sr.month,srs.user_id')
            ->distinct(true)
            ->select();

        foreach ($lists as $k=>$v){
            $lists[$k]['sbtotalp'] = round($v['ylap'] + $v['syep'] + $v['ylip'],2);
            $lists[$k]['sbtotalc'] = round($v['ylac'] + $v['syec'] + $v['ylic'] + $v['gsc'],2);
            $lists[$k]['sbtotal'] = round($lists[$k]['sbtotalp'] + $lists[$k]['sbtotalc'],2);
            $lists[$k]['gjjtotal'] = round($lists[$k]['gjjp'] + $lists[$k]['gjjc'],2);
            $lists[$k]['qynjtotal'] = round($lists[$k]['qynjp'] + $lists[$k]['qynjc'],2);
        }


        //转成数字格式
        $extra = ['month','name'];
        foreach ($lists as $k=>$v){
            foreach ($v as $kk=>$vv){
                if(!in_array($kk,$extra)){
                    $v[$kk] = (float)$vv;
                }
            }
            $lists[$k] = $v;
        }

        $columns[] = ["title" => "月份","key" => "month"];
        $columns[] = ["title" => "姓名","key" => "name"];
        if($type == 2){
            $columns[] = ["title" => "企业年金基数","key" => "qynj"];
        }
        $columns[] = ["title" => "公积金缴纳基数","key" => "gjj"];
        if($type == 2){
            $columns[] = ["title" => "社保缴纳基数","key" => "sn"];
        }else{
            $columns[] = ["title" => "生育/医疗基数","key" => "syyl"];
            $columns[] = ["title" => "工伤/失业基数","key" => "gssy"];
            $columns[] = ["title" => "养老/年金基数","key" => "ylnj"];
        }
        $columns[] = ["title" => "养老保险(个人)","key" => "ylap"];
        $columns[] = ["title" => "失业保险(个人)","key" => "syep"];
        $columns[] = ["title" => "医疗保险(个人)","key" => "ylip"];
        $columns[] = ["title" => "个人小计(社保)","key" => "sbtotalp"];
        $columns[] = ["title" => "养老保险(单位)","key" => "ylac"];
        $columns[] = ["title" => "失业保险(单位)","key" => "syec"];
        $columns[] = ["title" => "医疗保险(单位)","key" => "ylic"];
        $columns[] = ["title" => "工伤保险(单位)","key" => "gsc"];
        $columns[] = ["title" => "单位小计(社保)","key" => "sbtotalc"];
        $columns[] = ["title" => "社保合计","key" => "sbtotal"];
        $columns[] = ["title" => "公积金(个人)","key" => "gjjp"];
        $columns[] = ["title" => "公积金(单位)","key" => "gjjc"];
        $columns[] = ["title" => "公积金合计","key" => "gjjtotal"];
        if($type == 2){
            $columns[] = ["title" => "企业年金(个人)","key" => "qynjp"];
            $columns[] = ["title" => "企业年金(单位)","key" => "qynjc"];
            $columns[] = ["title" => "企业年金合计","key" => "qynjtotal"];
        }else{
            $columns[] = ["title" => "职业年金(个人)","key" => "qynjp"];
            $columns[] = ["title" => "职业年金(单位)","key" => "qynjc"];
            $columns[] = ["title" => "职业年金合计","key" => "qynjtotal"];
        }

        $data = [
            'columns' => $columns,
            'list' => $lists
        ];

        return $data;
    }

    public function unapply($userId){
        $lists = Db::name('salary_apply_record')
            ->alias('sar')
            ->join('salary_record sr','sr.id = sar.salary_record_id and sr.cur_node = sar.salary_apply_id')
            ->where('sar.user_id',$userId)
            ->where('sr.del',0)
            ->where('sr.status',0)
            ->where('sar.del',0)
            ->field('sr.id,sr.month,sr.type,sar.create_time')
            ->select();
        $nlist = [];
        foreach ($lists as $k=>$v){
            $arr = [
                'id' => $v['id'],
                'create_time' => $v['create_time']
            ];
            if($v['type'] == 1){
                $arr['title'] = $v['month'].'-中心编制';
            }else if($v['type'] == 2){
                $arr['title'] = $v['month'].'-新华聘用';
            }else if($v['type'] == 3){
                $arr['title'] = $v['month'].'-中心劳务';
            }else if($v['type'] == 4){
                $arr['title'] = $v['month'].'-新华劳务';
            }else if($v['type'] == 5){
                $arr['title'] = $v['month'].'-中心养老';
            }else if($v['type'] == 6){ //6=中心编制 7=新华聘用 8=中心劳务 9=新华劳务
                $arr['title'] = $v['month'].'-中心编制年绩效';
            }else if($v['type'] == 7){
                $arr['title'] = $v['month'].'-新华聘用年绩效';
            }else if($v['type'] == 8){
                $arr['title'] = $v['month'].'-中心劳务年绩效';
            }else if($v['type'] == 9){
                $arr['title'] = $v['month'].'-新华劳务年绩效';
            }else{
                $arr['title'] = $v['month'].'-';
            }
            $nlist[] = $arr;
        }
        return $nlist;
    }

    // 个人明细
    public function userdetail($page,$size,$type,$year){
        // 先取出本年发放工资人数
        if($type != 5){
            $users = Db::name('salary_record_log')
                ->alias('srl')
                ->join('salary_record sr','sr.id = srl.salary_record_id')
                ->join('user_info ui','ui.user_id = srl.user_id')
                ->where('sr.type',$type)
                ->where('sr.month','like',$year.'%')
                ->where('sr.status',2)
                ->where('sr.del',0)
                ->group('srl.user_id')
                ->page($page,$size)
                ->field('ui.name,srl.user_id,sum(gwgz) as gwgz,sum(xjgz) as xjgz,sum(jcjx) as jcjx,sum(yjx) as yjx,
                sum(tax) as tax,sum(salary) as salary,sum(should_total) as should_total,sum(sbgjj) as sbgjj')
                ->distinct(true)
                ->order('ui.sorts3 asc')
                ->select();
            return $users;
        }else{

        }
    }

    public function userYear($type,$year,$name,$month = 0){
        $map[] = ['sr.status','=',2];
        $map[] = ['sr.del','=',0];
        $map2 = $map;

        if($month > 0){
            if($month < 10){
                $map[] = ['sr.month','=',$year.'-0'.$month];
            }else{
                $map[] = ['sr.month','=',$year.'-'.$month];
            }
        }else{
            $map[] = ['sr.month','like',$year.'%'];
        }
        $map[] = ['sr.type','=',$type];
        $map1 = $map;
        if($name){
            $map[] = ['ui.name','like','%'.$name.'%'];
        }
        $ntype = $type + 5; // 年绩效类型
        $map2[] = ['sr.type','=',$ntype];

        if($month > 0){
            if($month < 10){
                $map2[] = ['sr.month','=',$year.'-0'.$month];
            }else{
                $map2[] = ['sr.month','=',$year.'-'.$month];
            }
        }else{
            $map2[] = ['sr.month','like',$year.'%'];
        }
        if(in_array($type,[1,2])){
            $lists = Db::name('salary_record_sb')
                ->alias('srs')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->where($map)
                ->field('ui.name,srs.user_id,srs.salary_record_id')
                ->group('srs.user_id')
                ->distinct(true)
                ->order('ui.sorts3 asc')
                ->select();
            $lists = $lists?$lists:[];
            foreach ($lists as $k=>$v){
                $lists[$k]['should_total'] = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.should_total');
                $lists[$k]['ylac'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.ylac');

                $lists[$k]['ylic'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.ylic');
                $lists[$k]['gsc'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.gsc');
                $lists[$k]['syec'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.syec');
                $lists[$k]['gjjc'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.gjjc');
                $lists[$k]['qynjc'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.qynjc');

                $lists[$k]['njx'] = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map2)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.should_total');

                $lists[$k]['key'] = $k+1;
                $lists[$k]['sb_total'] = round($lists[$k]['ylac'] + $lists[$k]['ylic'] + $lists[$k]['gsc'] + $lists[$k]['syec'],2);
                $lists[$k]['total'] = round($lists[$k]['njx'] + $lists[$k]['ylac'] + $lists[$k]['ylic'] + $lists[$k]['gsc'] + $lists[$k]['syec'] + $lists[$k]['gjjc'] + $lists[$k]['qynjc'] + $lists[$k]['should_total'],2);
            }
        }else{
            $lists = Db::name('salary_record_log')
                ->alias('srs')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->where($map)
                ->field('ui.name,srs.user_id,srs.salary_record_id')
                ->group('srs.user_id')
                ->distinct(true)
                ->order('ui.sorts3 asc')
                ->select();
            $lists = $lists?$lists:[];;
            foreach ($lists as $k=>$v){
                $lists[$k]['should_total'] = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.should_total');

                $lists[$k]['njx'] = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map2)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.should_total');

                $lists[$k]['key'] = $k+1;
                $lists[$k]['total'] = round($lists[$k]['should_total'] + $lists[$k]['njx'] + $lists[$k]['should_total'],2);
            }
        }

        return $lists;
    }

    public function yearExport($type,$year,$name,$month = 0){
        $map[] = ['sr.status','=',2];
        $map[] = ['sr.del','=',0];
        $map2 = $map;
        $map[] = ['sr.type','=',$type];
        if($month > 0){
            if($month < 10){
                $map[] = ['sr.month','=',$year.'-0'.$month];
            }else{
                $map[] = ['sr.month','=',$year.'-'.$month];
            }
        }else{
            $map[] = ['sr.month','like',$year.'%'];
        }
        $map1 = $map;
        if($name){
            $map[] = ['ui.name','like','%'.$name.'%'];
        }

        $ntype = $type + 5; // 年绩效类型
        $map2[] = ['sr.type','=',$ntype];
//        $map2[] = ['sr.month','like','%'.($year+1).'%'];
        if($month > 0){
            if($month < 10){
                $map2[] = ['sr.month','=',$year.'-0'.$month];
            }else{
                $map2[] = ['sr.month','=',$year.'-'.$month];
            }
        }else{
            $map2[] = ['sr.month','like',$year.'%'];
        }
        if(in_array($type,[1,2])){
            $lists = Db::name('salary_record_sb')
                ->alias('srs')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->where($map)
                ->field('ui.name,srs.user_id,srs.salary_record_id')
                ->group('srs.user_id')
                ->distinct(true)
                ->order('ui.sorts3 asc')
                ->select();
            $lists = $lists?$lists:[];
            $shoud_total = 0;
            $ylac = 0;
            $ylic = 0;
            $gsc = 0;
            $syec = 0;
            $gjjc = 0;
            $qynjc = 0;
            $sb_total = 0;
            $njx = 0;
            $total = 0;
            foreach ($lists as $k=>$v){
                $lists[$k]['should_total'] = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.should_total');
                $lists[$k]['ylac'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.ylac');
//
                $lists[$k]['ylic'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.ylic');
                $lists[$k]['gsc'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.gsc');
                $lists[$k]['syec'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.syec');
                $lists[$k]['gjjc'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where('sr.type',$type)
                    ->where('sr.month','like',$year.'%')
                    ->where('sr.status',2)
                    ->where('sr.del',0)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.gjjc');
                $lists[$k]['qynjc'] = Db::name('salary_record_sb')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.qynjc');

                $lists[$k]['njx'] = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map2)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.should_total');

                $lists[$k]['key'] = $k+1;
                $lists[$k]['sb_total'] = round($lists[$k]['ylac'] + $lists[$k]['ylic'] + $lists[$k]['gsc'] + $lists[$k]['syec'],2);
                $lists[$k]['total'] = round($lists[$k]['njx'] + $lists[$k]['ylac'] + $lists[$k]['ylic'] + $lists[$k]['gsc'] + $lists[$k]['syec'] + $lists[$k]['gjjc'] + $lists[$k]['qynjc'] + $lists[$k]['should_total'],2);

                $shoud_total += $lists[$k]['should_total'];
                $ylac += $lists[$k]['ylac'];
                $ylic += $lists[$k]['ylic'];
                $gsc += $lists[$k]['gsc'];
                $syec += $lists[$k]['syec'];
                $gjjc += $lists[$k]['gjjc'];
                $qynjc += $lists[$k]['qynjc'];
                $sb_total += $lists[$k]['sb_total'];
                $njx += $lists[$k]['njx'];
                $total += $lists[$k]['total'];
            }

            $lists[] = [
                'salary_record_id' => 0,
                'user_id' => 0,
                'name' => '',
                'key' => '合计',
                'should_total' => $shoud_total,
                'ylac' => $ylac,
                'ylic' => $ylic,
                'gsc' => $gsc,
                'syec' => $syec,
                'gjjc' => $gjjc,
                'qynjc' => $qynjc,
                'sb_total' => $sb_total,
                'njx' => $njx,
                'total' => $total,
            ];
        }else{
            $lists = Db::name('salary_record_log')
                ->alias('srs')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->where($map)
                ->field('ui.name,srs.user_id,srs.salary_record_id')
                ->group('srs.user_id')
                ->distinct(true)
                ->order('ui.sorts3 asc')
                ->select();
            $lists = $lists?$lists:[];
            $shoud_total = 0;
            $njx = 0;
            $total = 0;
            foreach ($lists as $k=>$v){
                $lists[$k]['should_total'] = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map1)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.should_total');

                $lists[$k]['njx'] = Db::name('salary_record_log')
                    ->alias('srl')
                    ->join('salary_record sr','sr.id = srl.salary_record_id')
                    ->where($map2)
                    ->where('srl.user_id',$v['user_id'])
                    ->sum('srl.should_total');

                $lists[$k]['key'] = $k+1;
                $lists[$k]['total'] = round($lists[$k]['should_total']+$lists[$k]['njx'] + $lists[$k]['should_total'],2);
                $shoud_total += $lists[$k]['should_total'];
                $total += $lists[$k]['total'];
                $njx += $lists[$k]['njx'];
            }

            $lists[] = [
                'salary_record_id' => 0,
                'user_id' => 0,
                'name' => '',
                'key' => '合计',
                'njx' => $njx,
                'should_total' => $shoud_total,
                'total' => $total,
            ];
        }


        $columns[] = ["title" => "序号","key" => "key"];
        $columns[] = ["title" => "姓名","key" => "name"];
        $columns[] = ["title" => "应发工资","key" => "shouldTotal"];
        if(in_array($type,[1,2])){
            $columns[] = ["title" => "养老保险(单位)","key" => "ylac"];
            $columns[] = ["title" => "失业保险(单位)","key" => "syec"];
            $columns[] = ["title" => "医疗保险(单位)","key" => "ylic"];
            $columns[] = ["title" => "工伤保险(单位)","key" => "gsc"];
            $columns[] = ["title" => "社保小计","key" => "sbTotal"];
            $columns[] = ["title" => "住房公积金(单位)","key" => "gjjc"];
            if($type == 2){
                $columns[] = ["title" => "企业年金(单位)","key" => "qynjc"];
            }else{
                $columns[] = ["title" => "职业年金(单位)","key" => "qynjc"];
            }
        }
        $columns[] = ["title" => "应发年绩效","key" => "njx"];
        $columns[] = ["title" => "用工成本合计","key" => "total"];

        $data = [
            'columns' => $columns,
            'list' => $lists
        ];

        return $data;
    }

    public function workerYear($type,$year,$name){
        // 先取出所有补助项
        // 取出所有人并算出人员的全年合计
        // 取出每个人的记录明细
        $types = Db::name('salary_record')->where('month','like','%'.$year.'%')->where('status',2)->where('del',0)->where('type',$type)->column('types');
        $typeids = [];
        foreach ($types as $k=>$v){
            if($v){
                $typeids = array_merge($typeids,explode(',',$v));
            }
        }
        $typeids = array_unique($typeids);
        if($typeids){
            $tlist = Db::name('user_subsidies')->where('id','in',$typeids)->field('id,title,type,pay_type,cate')->order('sorts asc,id asc')->select();
        }else{
            $tlist = [];
        }

        $map[] = ['sr.status','=',2];
        $map[] = ['sr.del','=',0];
        $map2 = $map;
        $map[] = ['sr.type','=',$type];
        $map[] = ['sr.month','like','%'.$year.'%'];
        $map1 = $map;
        if($name){
            $map[] = ['ui.name','like','%'.$name.'%'];
        }
        $map2[] = ['sr.type','=',$type+5];
        $map2[] = ['sr.month','like','%'.($year+1).'%'];

        $lists = Db::name('salary_record_log')
            ->alias('srs')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->where($map)
            ->field('ui.name,srs.user_id,ui.id,max(srs.pwlevel) as pwlevel,srs.psid')
            ->group('srs.user_id')
            ->distinct(true)
            ->order('ui.sorts3 asc,srs.id desc')
            ->select();
        $lists = $lists?$lists:[];
        foreach ($lists as $k=>$v){
            $data = [
                'gwgz' => 0,
                'xjgz' => 0,
                'jcjx' => 0,
                'yjx' => 0,
                'tax' => 0,
                'salary' => 0,
                'should_total' => 0,
                'sbgjj' => 0,
                'dktotal' => 0,
                'njxyf' => 0,
                'njxtax' => 0,
                'njx' => 0,
                'alltotal' => 0
            ];

            $data['njxyf'] = Db::name('salary_record_log')
                ->alias('srl')
                ->join('salary_record sr','sr.id = srl.salary_record_id')
                ->where($map2)
                ->where('srl.user_id',$v['user_id'])
                ->sum('srl.should_total');
            $data['njx'] = Db::name('salary_record_log')
                ->alias('srl')
                ->join('salary_record sr','sr.id = srl.salary_record_id')
                ->where($map2)
                ->where('srl.user_id',$v['user_id'])
                ->sum('srl.salary');
            $data['njxtax'] = Db::name('salary_record_log')
                ->alias('srl')
                ->join('salary_record sr','sr.id = srl.salary_record_id')
                ->where($map2)
                ->where('srl.user_id',$v['user_id'])
                ->sum('srl.tax');

            // 积累值
            foreach ($tlist as $key=>$val){
                $data['subsidies'.$val['id']] = 0;
            }
            // 获取本年的详细信息
            $depjob = Db::name('user_job')
                ->alias('uj')
                ->join('job j','j.id = uj.job_id')
                ->join('dep d','d.id = j.dep_id')
                ->where('uj.user_id',$v['user_id'])
                ->where('d.enable',1)
                ->field('d.name as dep_name,j.name as job_name')
                ->find();
            $lists[$k]['dep_name'] = $depjob?$depjob['dep_name']:'';

            //职级
//            $lists[$k]['job_name'] = Db::name('post_salary')->where('id',$v['psid'])->value('title');
            $lists[$k]['job_name'] = '';

            $children = Db::name('salary_record_log')
                ->alias('srs')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->where($map1)
                ->where('srs.user_id',$v['user_id'])
                ->field('srs.*,ui.name,sr.month')
                ->order('sr.month asc,sr.id asc')
                ->select();
            $children = $children?$children:[];


            foreach ($children as $kk=>$vv){
                $data['gwgz'] += $vv['gwgz'];
                $data['xjgz'] += $vv['xjgz'];
                $data['jcjx'] += $vv['jcjx'];
                $data['yjx'] += $vv['yjx'];
                $data['tax'] += $vv['tax'];
                $data['salary'] += $vv['salary'];
                $data['should_total'] += $vv['should_total'];
                $data['sbgjj'] += $vv['sbgjj'];
                $btjson = json_decode($vv['btjson'],true);
                $btjson = $btjson?$btjson:[];
                foreach ($tlist as $key=>$val){
                    $children[$kk]['subsidies'.$val['id']] = 0;
                    foreach ($btjson as $bk=>$bv){
                        if($val['id'] == $bv['id']){
                            $data['subsidies'.$val['id']] += $bv['money'];
                            $children[$kk]['subsidies'.$val['id']] = $bv['money'];
                        }
                    }
                }

                $kcmoney = 0;
                foreach ($btjson as $kkk=>$vvv){
                    if($vvv['cate'] == 2){
                        $kcmoney += $vvv['money'];
                    }
                }
                $children[$kk]['dktotal'] = round($vv['sbgjj'] + $vv['tax'] + $kcmoney,2);

                $children[$kk]['dep_name'] =  $lists[$k]['dep_name'];
                $children[$kk]['job_name'] = Db::name('post_salary')->where('id',$vv['psid'])->value('title');
//                $children[$kk]['job_name'] =  $lists[$k]['job_name'];
                $lists[$k]['job_name'] = $children[$kk]['job_name'];
                $children[$kk]['njxyf'] =  0;
                $children[$kk]['njxtax'] =  0;
                $children[$kk]['njx'] =  0;

                $children[$kk]['alltotal'] = $children[$kk]['salary'];

                $data['dktotal'] += $children[$kk]['dktotal'];
            }
            $lists[$k]['children'] = $children?$children:[];
            $lists[$k]['month'] = '合计';

            // 处理精度问题
            $data['gwgz'] = round($data['gwgz'],2);
            $data['xjgz'] = round($data['xjgz'],2);
            $data['jcjx'] = round($data['jcjx'],2);
            $data['yjx'] = round($data['yjx'],2);
            $data['tax'] = round($data['tax'],2);
            $data['salary'] = round($data['salary'],2);
            $data['should_total'] = round($data['should_total'],2);
            $data['sbgjj'] = round($data['sbgjj'],2);
            $data['dktotal'] = round($data['dktotal'],2);
            foreach ($tlist as $key=>$val){
                $data['subsidies'.$val['id']] = round($data['subsidies'.$val['id']],2);
            }

            $data['alltotal'] = round($data['salary'] + $data['njx'],2);

            $lists[$k] = array_merge($lists[$k],$data);
        }


        return ['types' => $tlist,'lists' => $lists];
    }

    public function yearWorkerExport($type,$year,$name){
        // 先取出所有补助项
        // 取出所有人并算出人员的全年合计
        // 取出每个人的记录明细
        $types = Db::name('salary_record')->where('month','like','%'.$year.'%')->where('status',2)->where('del',0)->where('type',$type)->column('types');
        $typeids = [];
        foreach ($types as $k=>$v){
            if($v){
                $typeids = array_merge($typeids,explode(',',$v));
            }
        }
        $typeids = array_unique($typeids);
        if($typeids){
            $tlist = Db::name('user_subsidies')->where('id','in',$typeids)->field('id,title,type,pay_type,cate')->order('sorts asc,id asc')->select();
        }else{
            $tlist = [];
        }

        $map[] = ['sr.status','=',2];
        $map[] = ['sr.del','=',0];
        $map2 = $map;
        $map[] = ['sr.type','=',$type];
        $map[] = ['sr.month','like','%'.$year.'%'];
        $map1 = $map;
        if($name){
            $map[] = ['ui.name','like','%'.$name.'%'];
        }
        $map2[] = ['sr.type','=',$type+5];
        $map2[] = ['sr.month','like','%'.($year+1).'%'];

        $lists = Db::name('salary_record_log')
            ->alias('srs')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->where($map)
            ->field('ui.name,srs.user_id,ui.id,srs.pwlevel,srs.psid')
            ->group('srs.user_id')
            ->distinct(true)
            ->order('ui.sorts3 asc')
            ->select();
        $lists = $lists?$lists:[];
        foreach ($lists as $k=>$v){
            $data = [
                'gwgz' => 0,
                'xjgz' => 0,
                'jcjx' => 0,
                'yjx' => 0,
                'tax' => 0,
                'salary' => 0,
                'should_total' => 0,
                'sbgjj' => 0,
                'dktotal' => 0,
                'njxyf' => 0,
                'njxtax' => 0,
                'njx' => 0,
                'alltotal' => 0
            ];

            $data['njxyf'] = Db::name('salary_record_log')
                ->alias('srl')
                ->join('salary_record sr','sr.id = srl.salary_record_id')
                ->where($map2)
                ->where('srl.user_id',$v['user_id'])
                ->sum('srl.should_total');
            $data['njx'] = Db::name('salary_record_log')
                ->alias('srl')
                ->join('salary_record sr','sr.id = srl.salary_record_id')
                ->where($map2)
                ->where('srl.user_id',$v['user_id'])
                ->sum('srl.salary');
            $data['njxtax'] = Db::name('salary_record_log')
                ->alias('srl')
                ->join('salary_record sr','sr.id = srl.salary_record_id')
                ->where($map2)
                ->where('srl.user_id',$v['user_id'])
                ->sum('srl.tax');

            // 积累值
            foreach ($tlist as $key=>$val){
                $data['subsidies'.$val['id']] = 0;
            }
            // 获取本年的详细信息
            $depjob = Db::name('user_job')
                ->alias('uj')
                ->join('job j','j.id = uj.job_id')
                ->join('dep d','d.id = j.dep_id')
                ->where('uj.user_id',$v['user_id'])
                ->where('d.enable',1)
                ->field('d.name as dep_name,j.name as job_name')
                ->find();
            $lists[$k]['dep_name'] = $depjob?$depjob['dep_name']:'';

            //职级
//            $lists[$k]['job_name'] = Db::name('post_salary')->where('id',$v['psid'])->value('title');
            $lists[$k]['job_name'] = '';

            $children = Db::name('salary_record_log')
                ->alias('srs')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->where($map1)
                ->where('srs.user_id',$v['user_id'])
                ->field('srs.*,ui.name,sr.month')
                ->order('sr.month asc,sr.id asc')
                ->select();
            $children = $children?$children:[];


            foreach ($children as $kk=>$vv){
                $data['gwgz'] += $vv['gwgz'];
                $data['xjgz'] += $vv['xjgz'];
                $data['jcjx'] += $vv['jcjx'];
                $data['yjx'] += $vv['yjx'];
                $data['tax'] += $vv['tax'];
                $data['salary'] += $vv['salary'];
                $data['should_total'] += $vv['should_total'];
                $data['sbgjj'] += $vv['sbgjj'];
                $btjson = json_decode($vv['btjson'],true);
                $btjson = $btjson?$btjson:[];
                foreach ($tlist as $key=>$val){
                    $children[$kk]['subsidies'.$val['id']] = 0;
                    foreach ($btjson as $bk=>$bv){
                        if($val['id'] == $bv['id']){
                            $data['subsidies'.$val['id']] += $bv['money'];
                            $children[$kk]['subsidies'.$val['id']] = $bv['money'];
                        }
                    }
                }

                $kcmoney = 0;
                foreach ($btjson as $kkk=>$vvv){
                    if($vvv['cate'] == 2){
                        $kcmoney += $vvv['money'];
                    }
                }
                $children[$kk]['dktotal'] = round($vv['sbgjj'] + $vv['tax'] + $kcmoney,2);

                $children[$kk]['dep_name'] =  $lists[$k]['dep_name'];
                $children[$kk]['job_name'] = Db::name('post_salary')->where('id',$vv['psid'])->value('title');
//                $children[$kk]['job_name'] =  $lists[$k]['job_name'];
                $lists[$k]['job_name'] = $children[$kk]['job_name'];

                $children[$kk]['njxyf'] =  0;
                $children[$kk]['njxtax'] =  0;
                $children[$kk]['njx'] =  0;
                $children[$kk]['alltotal'] =  $children[$kk]['salary'];

                $data['dktotal'] += $children[$kk]['dktotal'];
            }
            $lists[$k]['children'] = $children?$children:[];
            $lists[$k]['month'] = '合计';

            // 处理精度问题
            $data['gwgz'] = round($data['gwgz'],2);
            $data['xjgz'] = round($data['xjgz'],2);
            $data['jcjx'] = round($data['jcjx'],2);
            $data['yjx'] = round($data['yjx'],2);
            $data['tax'] = round($data['tax'],2);
            $data['salary'] = round($data['salary'],2);
            $data['should_total'] = round($data['should_total'],2);
            $data['sbgjj'] = round($data['sbgjj'],2);
            $data['dktotal'] = round($data['dktotal'],2);
            foreach ($tlist as $key=>$val){
                $data['subsidies'.$val['id']] = round($data['subsidies'.$val['id']],2);
            }

            $data['alltotal'] = round($data['salary'] + $data['njx'],2);

            $lists[$k] = array_merge($lists[$k],$data);
        }

        $newList = [];
        foreach ($lists as $k=>$v){
            $children = $v['children'];
            unset($v['children']);
            $newList[] = $v;
            foreach ($children as $kk=>$vv){
                $newList[] = $vv;
            }
        }


        $columns[] = ["title" => "姓名","key" => "name"];
        $columns[] = ["title" => "月份","key" => "month"];
        $columns[] = ["title" => "部门","key" => "depName"];
        $columns[] = ["title" => "职级","key" => "jobName"];
        $columns[] = ["title" => "薪级","key" => "pwlevel"];
        $columns[] = ["title" => "岗位工资","key" => "gwgz"];
        $columns[] = ["title" => "薪级工资","key" => "xjgz"];
        foreach ($tlist as $k=>$v){
            if($v['cate'] == 1){
                $columns[] = ["title" => $v['title'],"key" => "subsidies".$v['id']];
            }
        }
        $columns[] = ["title" => "基础绩效","key" => "jcjx"];
        $columns[] = ["title" => "月绩效","key" => "yjx"];
        $columns[] = ["title" => "应发工资","key" => "shouldTotal"];
        foreach ($tlist as $k=>$v){
            if($v['cate'] == 2){
                $columns[] = ["title" => $v['title'],"key" => "subsidies".$v['id']];
            }
        }
        $columns[] = ["title" => "社保公积金代扣","key" => "sbgjj"];
        $columns[] = ["title" => "个税","key" => "tax"];
        $columns[] = ["title" => "代扣合计","key" => "dktotal"];
        $columns[] = ["title" => "实发工资","key" => "salary"];
        $columns[] = ["title" => "应发年绩效","key" => "njxyf"];
        $columns[] = ["title" => "年绩效个税","key" => "njxtax"];
        $columns[] = ["title" => "实发年绩效","key" => "njx"];
        $columns[] = ["title" => "总实发","key" => "alltotal"];

        $data = [
            'columns' => $columns,
            'list' => $newList
        ];

        return $data;
    }

    public function userWorkerYear($type,$year,$userId){
        // 先取出所有补助项
        // 取出所有人并算出人员的全年合计
        // 取出每个人的记录明细
        if($type != 5){
            $types = Db::name('salary_record')
                ->alias('a')
                ->join('salary_record_log b','b.salary_record_id = a.id')
                ->where('a.month','like',$year.'%')
                ->where('a.status',2)
                ->where('a.del',0)
                ->where('a.type',$type)
                ->where('b.user_id',$userId)
                ->column('a.types');
        }else{
            $types = Db::name('salary_record')
                ->alias('a')
                ->join('user_retired_salary b','b.salary_record_id = a.id')
                ->where('a.month','like','%'.$year.'%')
                ->where('a.status',2)
                ->where('a.del',0)
                ->where('a.type',$type)
                ->where('b.user_id',$userId)
                ->column('a.types');
        }
        $types = $types?$types:[];

        $typeids = [];
        foreach ($types as $k=>$v){
            if($v){
                $typeids = array_merge($typeids,explode(',',$v));
            }
        }
        $typeids = array_unique($typeids);
        if($typeids){
            $tlist = Db::name('user_subsidies')->where('id','in',$typeids)->field('id,title,type,pay_type,cate')->order('sorts asc,id asc')->select();
        }else{
            $tlist = [];
        }

        $map[] = ['sr.type','=',$type];
        $map[] = ['sr.month','like',$year.'%'];
        $map[] = ['sr.status','=',2];
        $map[] = ['sr.del','=',0];
        $map[] = ['srs.user_id','=',$userId];
        $map1 = $map;
        $lists = Db::name('salary_record_log')
            ->alias('srs')
            ->join('user_info ui','ui.user_id = srs.user_id')
            ->join('salary_record sr','sr.id = srs.salary_record_id')
            ->where($map)
            ->field('ui.name,srs.user_id,ui.id,srs.pwlevel,srs.psid,srs.njx')
            ->group('srs.user_id')
            ->distinct(true)
            ->order('ui.sorts3 asc')
            ->select();
        $lists = $lists?$lists:[];
        foreach ($lists as $k=>$v){
            if($type != 5){
                $data = [
                    'njx' => 0,
                    'gwgz' => 0,
                    'xjgz' => 0,
                    'jcjx' => 0,
                    'yjx' => 0,
                    'tax' => 0,
                    'salary' => 0,
                    'should_total' => 0,
                    'sbgjj' => 0,
                    'dktotal' => 0,
                    'level' => '',
                    'factor' => '',
                    'months' => '',
                    'taxrate' => '',
                    'gjjp' => 0,
                    'qynjp' => 0,
                    'ylap' => 0,
                    'syep' => 0,
                    'ylip' => 0,
                ];
            }else{
                $data = [
                    'bz' => 0,
                    'zysdbt' => 0,
                    'fb' => 0,
                    'wybt' => 0,
                    'salary' => 0,
                    'dktotal' => 0,
                ];
            }

            // 积累值
            foreach ($tlist as $key=>$val){
                $data['subsidies'.$val['id']] = 0;
            }
            // 获取本年的详细信息
            $depjob = Db::name('user_job')
                ->alias('uj')
                ->join('job j','j.id = uj.job_id')
                ->join('dep d','d.id = j.dep_id')
                ->where('uj.user_id',$v['user_id'])
                ->where('d.enable',1)
                ->field('d.name as dep_name,j.name as job_name')
                ->find();
            $lists[$k]['dep_name'] = $depjob?$depjob['dep_name']:'';

            //职级
//            $lists[$k]['job_name'] = Db::name('post_salary')->where('id',$v['psid'])->value('title');
            $lists[$k]['job_name'] = '';

            $children = Db::name('salary_record_log')
                ->alias('srs')
                ->join('user_info ui','ui.user_id = srs.user_id')
                ->join('salary_record sr','sr.id = srs.salary_record_id')
                ->where($map1)
                ->where('srs.user_id',$v['user_id'])
                ->field('srs.*,ui.name,sr.month')
                ->order('sr.month asc,sr.id asc')
                ->select();
            $children = $children?$children:[];


            foreach ($children as $kk=>$vv){
                if($type != 5){
                    if(in_array($type,[1,2,3,4])){
                        $data['gwgz'] += $vv['gwgz'];
                        $data['xjgz'] += $vv['xjgz'];
                        $data['jcjx'] += $vv['jcjx'];
                        $data['yjx'] += $vv['yjx'];
                    }else if(in_array($type,[6,7,8,9])){
                        $data['njx'] += $vv['njx'];
                    }
                    $data['tax'] += $vv['tax'];
                    $data['should_total'] += $vv['should_total'];
                    $data['sbgjj'] += $vv['sbgjj'];

                    if($type == 1||$type == 2){
                        $sb = Db::name('salary_record_sb')->where('salary_record_id',$vv['salary_record_id'])->where('user_id',$vv['user_id'])->find();
                        $children[$kk]['gjjp'] = $sb?$sb['gjjp']:0;
                        $children[$kk]['qynjp'] = $sb?$sb['qynjp']:0;
                        $children[$kk]['ylap'] = $sb?$sb['ylap']:0;
                        $children[$kk]['syep'] = $sb?$sb['syep']:0;
                        $children[$kk]['ylip'] = $sb?$sb['ylip']:0;

                        $data['gjjp'] += $children[$kk]['gjjp'];
                        $data['qynjp'] += $children[$kk]['qynjp'];
                        $data['ylap'] += $children[$kk]['ylap'];
                        $data['syep'] += $children[$kk]['syep'];
                        $data['ylip'] += $children[$kk]['ylip'];
                    }
                }else{
                    $data['bz'] += $vv['bz'];
                    $data['zysdbt'] += $vv['zysdbt'];
                    $data['fb'] += $vv['fb'];
                    $data['wybt'] += $vv['wybt'];
                }

                $data['salary'] += $vv['salary'];
                $btjson = json_decode($vv['btjson'],true);
                $btjson = $btjson?$btjson:[];
                foreach ($tlist as $key=>$val){
                    $children[$kk]['subsidies'.$val['id']] = 0;
                    foreach ($btjson as $bk=>$bv){
                        if($val['id'] == $bv['id']){
                            $data['subsidies'.$val['id']] += $bv['money'];
                            $children[$kk]['subsidies'.$val['id']] = $bv['money'];
                        }
                    }
                }

                $kcmoney = 0;
                foreach ($btjson as $kkk=>$vvv){
                    if($vvv['cate'] == 2){
                        $kcmoney += $vvv['money'];
                    }
                }

                if($type != 5){
                    $children[$kk]['dktotal'] = round($vv['sbgjj'] + $vv['tax'] + $kcmoney,2);
                }else{
                    $children[$kk]['dktotal'] = round($kcmoney,2);
                }

                $children[$kk]['dep_name'] =  $lists[$k]['dep_name'];

                //职级
                $children[$kk]['job_name'] = Db::name('post_salary')->where('id',$vv['psid'])->value('title');
//                $children[$kk]['job_name'] =  $lists[$k]['job_name'];
                $lists[$k]['job_name'] = $children[$kk]['job_name'];

                $data['dktotal'] += $children[$kk]['dktotal'];
            }
            $lists[$k]['children'] = $children?$children:[];
            $lists[$k]['month'] = '合计';

            // 处理精度问题
            if($type != 5){
                $data['gwgz'] = round($data['gwgz'],2);
                $data['xjgz'] = round($data['xjgz'],2);
                $data['jcjx'] = round($data['jcjx'],2);
                $data['yjx'] = round($data['yjx'],2);
                $data['tax'] = round($data['tax'],2);
                $data['should_total'] = round($data['should_total'],2);
                $data['sbgjj'] = round($data['sbgjj'],2);
                $data['gjjp'] = round($data['gjjp'],2);
                $data['qynjp'] = round($data['qynjp'],2);
                $data['ylap'] = round($data['ylap'],2);
                $data['syep'] = round($data['syep'],2);
                $data['ylip'] = round($data['ylip'],2);
            }else{
                $data['bz'] = round($data['bz'],2);
                $data['zysdbt'] = round($data['zysdbt'],2);
                $data['fb'] = round($data['fb'],2);
                $data['wybt'] = round($data['wybt'],2);
            }
            $data['salary'] = round($data['salary'],2);
            $data['dktotal'] = round($data['dktotal'],2);
            foreach ($tlist as $key=>$val){
                $data['subsidies'.$val['id']] = round($data['subsidies'.$val['id']],2);
            }

            $lists[$k] = array_merge($lists[$k],$data);
        }


        return ['types' => $tlist,'lists' => $lists];
    }

    // 获取用户发放工资的所有类型
    public function getUserSalayrTypes($userId){
        $types1 = Db::name('salary_record')
            ->alias('a')
            ->join('salary_record_log b','b.salary_record_id = a.id')
            ->where('a.status',2)
            ->where('a.del',0)
            ->where('b.user_id',$userId)
            ->group('a.type')
            ->distinct(true)
            ->column('a.type');
        $types1 = $types1?$types1:[];
        $types2 = Db::name('salary_record')
            ->alias('a')
            ->join('user_retired_salary b','b.salary_record_id = a.id')
            ->where('a.status',2)
            ->where('a.del',0)
            ->where('b.user_id',$userId)
            ->group('a.type')
            ->order('a.type asc')
            ->distinct(true)
            ->column('a.type');
        $types2 = $types2?$types2:[];

        $types = array_merge($types1,$types2);
        $list = [];
        foreach ($types as $v){
            $a['id'] = $v;
            if($v == 1){
                $a['title'] = '中心编制';
            } else if ($v == 2){
                $a['title'] = '新华聘用';
            } else if ($v == 3){
                $a['title'] = '中心劳务';
            } else if ($v == 4){
                $a['title'] = '新华劳务';
            }else if($v == 6){
                $a['title'] = '中心编制年绩效';
            } else if ($v == 7){
                $a['title'] = '新华聘用年绩效';
            } else if ($v == 8){
                $a['title'] = '中心劳务年绩效';
            } else if ($v == 9){
                $a['title'] = '新华劳务年绩效';
            }else{
                $a['title'] = '中心退休';
            }
            $list[] = $a;
        }
        return $list;
    }

}