lw_test/app/admin/controller/Performance.php

<?php

namespace app\admin\controller;

use app\admin\AdminBaseController;

class Performance extends AdminBaseController
{

    public function index()
    {
        return view();
    }

    public function import()
    {
        return view();
    }

    public function match()
    {
        $file = input('file/s', "");
        if (!file_exists($file)) {
            return '绩效工资文件不存在';
        }

        //初始化数据
        $data     = [
            'xuhao', 'xingming', 'zhiwei', 'bumen', 'jixiaogongzijishu',
            'yingchuqin1', 'yingchuqin2', 'yingchuqin3',
            'shichuqin1', 'shichuqin2', 'shichuqin3',
            'jixiaofen1', 'jixiaofen2', 'jixiaofen3',
//            'jixiaofen1', 'jixiaofen2', 'jixiaofen3',
        ];
        $exl_list = import_exl_jixiao($file, $data, 2);

        if (empty($exl_list)) {
            return '绩效工资文件无数据';
        }

        $list = [];
        foreach ($exl_list as $v) {
            $item                      = [];
            $item['xuhao']             = $v['xuhao'];
            $item['xingming']          = $v['xingming'];
            $item['zhiwei']            = $v['zhiwei'];
            $item['bumen']             = $v['bumen'];
            $item['jixiaofen1']        = $v['jixiaofen1'];
            $item['jixiaofen2']        = $v['jixiaofen2'];
            $item['jixiaofen3']        = $v['jixiaofen3'];
            $item['jixiaoxishu1']      = $item['jixiaofen1'] > 100 ? 1 : $item['jixiaofen1'] / 100;
            $item['jixiaoxishu2']      = $item['jixiaofen2'] > 100 ? 1 : $item['jixiaofen2'] / 100;
            $item['jixiaoxishu3']      = $item['jixiaofen3'] > 100 ? 1 : $item['jixiaofen3'] / 100;
            $item['jixiaogongzijishu'] = $v['jixiaogongzijishu'];
            if ($v['shichuqin1'] > $v['yingchuqin1']) {
                return $item['xingming'] . '的第一个月实际出勤天数应小于应出勤人数，请检查';
            }
            if ($v['shichuqin2'] > $v['yingchuqin2']) {
                return $item['xingming'] . '的第二个月实际出勤天数应小于应出勤人数，请检查';
            }
            if ($v['shichuqin3'] > $v['yingchuqin3']) {
                return $item['xingming'] . '的第三个月实际出勤天数应小于应出勤人数，请检查';
            }
            $chuqinlv1                = empty($v['yingchuqin1']) ? 0 : $v['shichuqin1'] / $v['yingchuqin1'];
            $chuqinlv2                = empty($v['yingchuqin2']) ? 0 : $v['shichuqin2'] / $v['yingchuqin2'];
            $chuqinlv3                = empty($v['yingchuqin3']) ? 0 : $v['shichuqin3'] / $v['yingchuqin3'];
            $item['jixiaogongzi1']    = round($item['jixiaogongzijishu'] * $item['jixiaoxishu1'] * $chuqinlv1, 2);
            $item['jixiaogongzi2']    = round($item['jixiaogongzijishu'] * $item['jixiaoxishu2'] * $chuqinlv2, 2);
            $item['jixiaogongzi3']    = round($item['jixiaogongzijishu'] * $item['jixiaoxishu3'] * $chuqinlv3, 2);
            $item['jixiaogongziheji'] = $item['jixiaogongzi1'] + $item['jixiaogongzi2'] + $item['jixiaogongzi3'];
            $item['yufagongzi1']      = round($item['jixiaogongzijishu'] * 0.8 * $chuqinlv1, 2);
            $item['yufagongzi2']      = round($item['jixiaogongzijishu'] * 0.8 * $chuqinlv2, 2);
            $item['yufagongzi3']      = round($item['jixiaogongzijishu'] * 0.8 * $chuqinlv3, 2);
            $item['yufagongziheji']   = $item['yufagongzi1'] + $item['yufagongzi2'] + $item['yufagongzi3'];
            $item['bufa']             = $item['jixiaogongziheji'] - $item['yufagongziheji'];
            $item['gonghui']          = round($item['bufa'] * 0.005, 2);
            $item['shifa']            = round($item['bufa'] - $item['gonghui'], 2);
            $list[]                   = $item;
        }

        $xlsCell = [
            ['xuhao', '序号'],
            ['xingming', '姓名'],
            ['zhiwei', '职位'],
            ['bumen', '部门'],
            ['jixiaofen1', '绩效得分第1月'],
            ['jixiaofen2', '绩效得分第2月'],
            ['jixiaofen3', '绩效得分第3月'],
            ['jixiaoxishu1', '绩效系数第1月'],
            ['jixiaoxishu2', '绩效系数第2月'],
            ['jixiaoxishu3', '绩效系数第3月'],
            ['jixiaogongzijishu', '绩效工资基数'],
            ['jixiaogongzi1', '绩效工资第1月'],
            ['jixiaogongzi2', '绩效工资第2月'],
            ['jixiaogongzi3', '绩效工资第3月'],
            ['jixiaogongziheji', '绩效工资合计'],
            ['yufagongzi1', '已预发工资第1月'],
            ['yufagongzi2', '已预发工资第2月'],
            ['yufagongzi3', '已预发工资第3月'],
            ['yufagongziheji', '已预发工资合计'],
            ['bufa', '应补发绩效工资'],
            ['gonghui', '工会会费'],
            ['shifa', '实际补发绩效工资'],
        ];
        unlink($file);
        export_exl("绩效工资", $xlsCell, $list,[],[10,10,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]);
    }
}