<?php
/**
 * Created by PhpStorm.
 * User: sicilon_IT
 * Date: 2020/2/6
 * Time: 23:29
 */

namespace app\index\controller;
use app\index\logic\checkmanger;
use app\index\logic\contactlogic;
use app\index\logic\recuitlogic;
use think\Controller;

class Checkinfo extends Controller {
    /*
     * 20200302
     * steelxu
     * 标准输出检查找包
     * 测试成功后，再看是做到扩展的基础类，还是
     */
    public function stdout($arr) {
        $res_r = array();
        if (empty($arr)) {
            $res_r['code'] = 0;
            $res_r['msg'] = '无数据';
        } else {
            $res_r['code'] = 200;
            $res_r['resultData'] = $arr;
        }

        return $res_r;
    }
    /*
     * web端获取按月按人统计出勤天数，出勤总分的接口
     * 20200206
     * steelxu
     */
    public function summonthcheckinfo() {
        $queryinfo = request()->param();
        //预处理奖励数据
        $l_r = new recuitlogic();
        $l_r->oprrecuitaward();
        $l_check = new checkmanger();
        $r_list = $l_check->getsumcheckinfo($queryinfo);

        if (empty($r_list)) {
            $res_r['code'] = 0;
            $res_r['errmsg'] = '无汇总数据';
        } else {
            $res_r['code'] = 200;
            $res_r['resultData'] = $r_list;
        }
        return json_encode($res_r, 320);
    }

    /*
     * 20230215
     * 统计本公司考勤
     */
    public function sumcompanymonthcheckinfo() {
        $queryinfo = request()->param();
        //预处理奖励数据
        $l_r = new recuitlogic();
        $l_r->oprrecuitaward();
        $l_check = new checkmanger();
        $r_list = $l_check->getsumcompanycheckinfo($queryinfo);

        if (empty($r_list)) {
            $res_r['code'] = 0;
            $res_r['errmsg'] = '无汇总数据';
        } else {
            $res_r['code'] = 200;
            $res_r['resultData'] = $r_list;
        }
        return json_encode($res_r, 320);
    }

    /*
     * 考勤汇总信息导出execl
     * 20200210
     * steelxu
     * 20203005
     * 加身份证号
     */

    //
    public function outtoexecl() {
        //获取传入参数

        $queryinfo = $queryinfo = request()->param();
        //预处理奖励数据
        $l_r = new recuitlogic();
        $l_r->oprrecuitaward();
        $month = $queryinfo['monthinfo'];
        $year = $queryinfo['yearinfo'];
        //获取数据
        $l_check = new checkmanger();
        $r_list = $l_check->getsumcheckinfo($queryinfo);
        //获取当用天数
        $daysofm = date('t', strtotime($year . '-' . $month . '-1'));

        //加载类库
        vendor('PHPExcel.PHPExcel');
        $objPHPExcel = new \PHPExcel();
        //4.激活当前的sheet表
        $objPHPExcel->setActiveSheetIndex(0);
        //5.设置表格头（即excel表格的第一行）
        $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'ID')
            ->setCellValue('B1', '姓名')
            ->setCellValue('C1', '记工天数')
            ->setCellValue('D1', '当月计分')
            ->setCellValue('E1', '身份证号');
        for ($j = 1; $j <= $daysofm; $j++) {
            $columnname = strval($j);
            if (strlen($columnname) < 2) {
                $columnname = '0' . $columnname;
            }
            $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($j + 4);
            $objPHPExcel->setActiveSheetIndex(0)->setCellValue($fcolumnchar . '1', $columnname);
        }
        $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 5);
        $objPHPExcel->setActiveSheetIndex(0)->setCellValue($fcolumnchar . '1', '推荐奖励');

        //设置A列水平居中
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        //设置单元格宽度
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(8);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(12);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(12);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(12);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(20);
        //6.循环刚取出来的数组，将数据逐一添加到excel表格。
        for ($i = 0; $i < count($r_list); $i++) {
            $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $r_list[$i]['wid']); //ID
            $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $r_list[$i]['wname']); //名称
            $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $r_list[$i]['daycount']); //说明
            $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $r_list[$i]['monthsum']); //说明
            $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), "'" . $r_list[$i]['sfz']); //说明
            for ($j = 1; $j <= $daysofm; $j++) {
                $fname = strval($j);
                if (strlen($fname) < 2) {
                    $fname = '0' . $fname;
                }
                //$eecll=new \PHPExcel_Cell()
                $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($j + 4);
                $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($i + 2), (array_key_exists($fname, $r_list[$i]) ? $r_list[$i][$fname] : '-')); //说明
            }
            $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 5);
            $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($i + 2), $r_list[$i]['sumaward']); //说明

        }
        //7.设置保存的Excel表格名称
        $filename = $year . '年' . $month . '月考勤统计表' . date('ymd', time()) . '.xls';
        //8.设置当前激活的sheet表格名称；
        $objPHPExcel->getActiveSheet()->setTitle('考勤信息' . $year . '年' . $month . '月');
        //9.设置浏览器窗口下载表格
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");
        header('Content-Disposition:inline;filename="' . $filename . '"');
        //生成excel文件
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        //下载文件在浏览器窗口
        $objWriter->save('php://output');
        //原代码没有返回
        $res_r['code'] = 200;
        $res_r['resultData'] = $filename;
        return json_encode($res_r, 320);
    }

    /*
     * 20230215
     */
    public function outcompanytoexecl() {
        //获取传入参数

        $queryinfo = $queryinfo = request()->param();
        //预处理奖励数据
        $l_r = new recuitlogic();
        $l_r->oprrecuitaward();
        $month = $queryinfo['monthinfo'];
        $year = $queryinfo['yearinfo'];
        $cid = $queryinfo['companyid'];
        //获取数据
        $l_check = new checkmanger();
        $r_list = $l_check->getsumcompanycheckinfo($queryinfo);
        //获取当用天数
        $daysofm = date('t', strtotime($year . '-' . $month . '-1'));

        //加载类库
        vendor('PHPExcel.PHPExcel');
        $objPHPExcel = new \PHPExcel();
        //4.激活当前的sheet表
        $objPHPExcel->setActiveSheetIndex(0);
        //5.设置表格头（即excel表格的第一行）
        $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'ID')
            ->setCellValue('B1', '姓名')
            ->setCellValue('C1', '记工天数')
            ->setCellValue('D1', '当月计分')
            ->setCellValue('E1', '身份证号');
        for ($j = 1; $j <= $daysofm; $j++) {
            $columnname = strval($j);
            if (strlen($columnname) < 2) {
                $columnname = '0' . $columnname;
            }
            $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($j + 4);
            $objPHPExcel->setActiveSheetIndex(0)->setCellValue($fcolumnchar . '1', $columnname);
        }
        $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 5);
        $objPHPExcel->setActiveSheetIndex(0)->setCellValue($fcolumnchar . '1', '推荐奖励');

        //设置A列水平居中
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        //设置单元格宽度
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(8);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(12);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(12);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(12);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(20);
        //6.循环刚取出来的数组，将数据逐一添加到excel表格。
        for ($i = 0; $i < count($r_list); $i++) {
            $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $r_list[$i]['wid']); //ID
            $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $r_list[$i]['wname']); //名称
            $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $r_list[$i]['daycount']); //说明
            $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $r_list[$i]['monthsum']); //说明
            if (array_key_exists('sfz', $r_list[$i])) {
                $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), "'" . $r_list[$i]['sfz']); //说明
            }

            for ($j = 1; $j <= $daysofm; $j++) {
                $fname = strval($j);
                if (strlen($fname) < 2) {
                    $fname = '0' . $fname;
                }
                //$eecll=new \PHPExcel_Cell()
                $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($j + 4);
                $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($i + 2), (array_key_exists($fname, $r_list[$i]) ? $r_list[$i][$fname] : '-')); //说明
            }
            $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 5);
            $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($i + 2), $r_list[$i]['sumaward']); //说明

        }
        //7.设置保存的Excel表格名称
        $filename = $year . '年' . $month . '月考勤统计表' . date('ymd', time()) . '.xls';
        //8.设置当前激活的sheet表格名称；
        $objPHPExcel->getActiveSheet()->setTitle('考勤信息' . $year . '年' . $month . '月');
        //9.设置浏览器窗口下载表格
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");
        header('Content-Disposition:inline;filename="' . $filename . '"');
        //生成excel文件
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        //下载文件在浏览器窗口
        $objWriter->save('php://output');
        //原代码没有返回
        $res_r['code'] = 200;
        $res_r['resultData'] = $filename;
        return json_encode($res_r, 320);
    }

    /*
     * 20200307
     * 做一个加班请求
     */

    public function queryworkovertime() {
        $queryinfo = request()->param();

        $pagenum = $queryinfo['pageNum'];
        $pagesize = $queryinfo['pageSize'];
        $l_check = new checkmanger();
        $rlist = $l_check->getworkovertime($pagenum, $pagesize);

        return json_encode($this->stdout($rlist), 320);
    }

    /*
     *
     * 20230215
     * 修改请求加班记录的功能
     * 只能请求本公司的数据
     */
    public function querycompanyworkovertime() {
        $queryinfo = request()->param();

        $pagenum = $queryinfo['pageNum'];
        $pagesize = $queryinfo['pageSize'];
        $cid = $queryinfo['companyid'];
        $l_check = new checkmanger();
        $rlist = $l_check->getworkovertimebycid($pagenum, $pagesize, $cid);

        return json_encode($this->stdout($rlist), 320);
    }
    /*
     * 20200310
     * 请求各合同下各班组的月度统计
     */
    public function queryglistmonthsum() {
        $queryinfo = request()->param();
        $l_contact = new contactlogic();
        $gsumlist = $l_contact->getgroupsumbycid($queryinfo);
        // print_r($gsumlist);
//        var_dump($gsumlist);
//       if (array_key_exists('0',$gsumlist)){
//           $r_list=$gsumlist[0]->data;
//       }else{
//           $r_list=$gsumlist;
//       }
//        var_dump($r_list);
        return json_encode($this->stdout($gsumlist), 320);
    }

    /*
     * 20200316
     * w合同下班组统计，到个人
     * getworkersumbycid
     */
    public function querywlistsummonth() {
        $queryinfo = request()->param();
        $l_contact = new contactlogic();
        $gsumlist = $l_contact->getworkersumbycid($queryinfo);
        return json_encode($this->stdout($gsumlist), 320);
    }

    /*
     * 20200318
     * 导出按合同汇总考勤数据
     */

    public function workersumtoexecl() {
        //获取数据
        $queryinfo = request()->param();
        $yearinfo = $queryinfo['yearinfo'];
        $monthinfo = $queryinfo['monthinfo'];
        $cname = $queryinfo['cname'];
        $l_contact = new contactlogic();
        //获取当用天数
        $daysofm = date('t', strtotime($yearinfo . '-' . $monthinfo . '-1'));
        $gsumlist = $l_contact->getworkersumbycid($queryinfo);

        //加载类库
        vendor('PHPExcel.PHPExcel');
        $objPHPExcel = new \PHPExcel();
        //4.激活当前的sheet表
        $objPHPExcel->setActiveSheetIndex(0);
        //5.设置表格头（即excel表格的第一行）
        $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', '班组/工人')
            ->setCellValue('B1', '当月总记分');
        for ($j = 1; $j <= $daysofm; $j++) {
            $columnname = strval($j);
            if (strlen($columnname) < 2) {
                $columnname = '0' . $columnname;
            }
            $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($j + 2);
            $objPHPExcel->setActiveSheetIndex(0)->setCellValue($fcolumnchar . '1', $columnname);
        }
        //设置A列水平居中
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        //设置单元格宽度
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(20);
        $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(15);
        //6.循环刚取出来的数组，将数据逐一添加到excel表格。
        $rowindex = 0;
        for ($i = 0; $i < count($gsumlist); $i++) {
            //班组汇总信息
            $objPHPExcel->getActiveSheet()->setCellValue('A' . ($rowindex + 2), $gsumlist[$i]['gname']); //ID
            $objPHPExcel->getActiveSheet()->setCellValue('B' . ($rowindex + 2), $gsumlist[$i]['summonth']); //名称
            for ($j = 1; $j <= $daysofm; $j++) {
                //  for ($j=13; $j<=16;$j++){//测试临时
                $daystr = strval($j);
                if (strlen($daystr) < 2) {
                    $daystr = '0' . $daystr;
                }
                $fname = $yearinfo . '-' . $monthinfo . '-' . $daystr;
                //$eecll=new \PHPExcel_Cell()
                $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($j + 2);
                $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($rowindex + 2), (array_key_exists($fname, $gsumlist[$i]) ? $gsumlist[$i][$fname] : '-')); //说明
                //  $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr.($rowindex+2),$gsumlist[$i][$fname]);//说明
            }
            $rowindex++; //行控制
            //员工数据
            for ($workerindex = 0; $workerindex < count($gsumlist[$i]['detail']); $workerindex++) {
                $objPHPExcel->getActiveSheet()->setCellValue('A' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['gname']); //
                $objPHPExcel->getActiveSheet()->setCellValue('B' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['summonth']); //
                for ($j = 1; $j <= $daysofm; $j++) {
                    $daystr = strval($j);
                    if (strlen($daystr) < 2) {
                        $daystr = '0' . $daystr;
                    }
                    $fname = $yearinfo . '-' . $monthinfo . '-' . $daystr;
                    //$eecll=new \PHPExcel_Cell()
                    $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($j + 2);
                    $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($rowindex + 2), (array_key_exists($fname, $gsumlist[$i]['detail'][$workerindex]) ? $gsumlist[$i]['detail'][$workerindex][$fname] : '-')); //说明
                }
                $rowindex++; //行控制
            }
        }
        //7.设置保存的Excel表格名称
        $filename = $cname . '考勤汇总' . date('ymd', time()) . '.xls';
        //8.设置当前激活的sheet表格名称；
        $objPHPExcel->getActiveSheet()->setTitle($cname . '考勤汇总');
        //9.设置浏览器窗口下载表格
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");
        header('Content-Disposition:inline;filename="' . $filename . '"');
        //生成excel文件
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        //下载文件在浏览器窗口
        $objWriter->save('php://output');
        //原代码没有返回
        $res_r['code'] = 200;
        $res_r['resultData'] = $filename;
        return json_encode($res_r, 320);
    }

    /*
     * 20200320
     * 自动导出所有的项目合同考勤，分页
     *
     */

    public function allworkersumtoexecl() {
        /*
         * 准备
         */
        //获取数据
        $queryinfo = request()->param();
        $yearinfo = $queryinfo['yearinfo'];
        $monthinfo = $queryinfo['monthinfo'];
        //获取所有导出的合同
        $l_contact = new contactlogic();
        $list_contact = $l_contact->getclist();
        //获取当用天数
        $daysofm = date('t', strtotime($yearinfo . '-' . $monthinfo . '-1'));
        //加载类库
        vendor('PHPExcel.PHPExcel');
        $objPHPExcel = new \PHPExcel();
        $pageindex = 0; //初始化页数
        /*
         * 循环处理所有合同
         */
        foreach ($list_contact as $contact) {
            $queryinfo['cid'] = $contact['id'];
            $cname = $contact['contactname'];
            //获取合同的数据
            $gsumlist = $l_contact->getworkersumbycid($queryinfo);

            //4.激活当前的sheet表
            if ($pageindex > 0) {
                $objPHPExcel->createSheet();
            }
            $objPHPExcel->setActiveSheetIndex($pageindex);
            //5.设置表格头（即excel表格的第一行）
            $objPHPExcel->setActiveSheetIndex($pageindex)
                ->setCellValue('A1', '班组')
                ->setCellValue('B1', '总分')
                ->setCellValue('C1', '班组')
                ->setCellValue('D1', '工人')
                ->setCellValue('E1', '当月总记分');
            for ($j = 1; $j <= $daysofm; $j++) {
                $columnname = strval($j);
                if (strlen($columnname) < 2) {
                    $columnname = '0' . $columnname;
                }
                $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($j + 4);
                $objPHPExcel->setActiveSheetIndex($pageindex)->setCellValue($fcolumnchar . '1', $columnname);

//                $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle($fcolumnchar)->getAlignment()
//                    ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
//                $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension($fcolumnchar)->setWidth(6);
            }

            $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 5);
            $objPHPExcel->setActiveSheetIndex($pageindex)->setCellValue($fcolumnchar . '1', '招工成本');
            //设置A列水平居中
            $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('A')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('B')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('C')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('D')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('E')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            //设置单元格宽度
            $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('A')->setWidth(20);
            $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('B')->setWidth(11);
            $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('C')->setWidth(20);
            $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('D')->setWidth(10);
            $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('E')->setWidth(13);

            //6.循环刚取出来的数组，将数据逐一添加到excel表格。
            $rowindex = 0;
            for ($i = 0; $i < count($gsumlist); $i++) {
//                //班组汇总信息
//               // var_dump($gsumlist[$i]);
//                $objPHPExcel->getActiveSheet()->setCellValue('A'.($rowindex+2),$gsumlist[$i]['gname']);//ID
//                $objPHPExcel->getActiveSheet()->setCellValue('B'.($rowindex+2),$gsumlist[$i]['summonth']);//名称
//                for ($j=1; $j<=$daysofm;$j++){
//                    //  for ($j=13; $j<=16;$j++){//测试临时
//                    $daystr=strval($j);
//                    if (strlen($daystr)<2){
//                        $daystr='0'.$daystr;
//                    }
//                    $fname=$yearinfo.'-'.$monthinfo.'-'.$daystr;
//                    //$eecll=new \PHPExcel_Cell()
//                    $fcolumnstr=\PHPExcel_Cell::stringFromColumnIndex($j+2);
//                    $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr.($rowindex+2),(array_key_exists($fname,$gsumlist[$i])?$gsumlist[$i][$fname]:'-'));//说明
//                    //  $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr.($rowindex+2),$gsumlist[$i][$fname]);//说明
//                }
//                $rowindex++;//行控制
                //员工数据
                $firstworker = $rowindex + 2;
                $workercounts = count($gsumlist[$i]['detail']);
                for ($workerindex = 0; $workerindex < $workercounts; $workerindex++) {
                    $objPHPExcel->getActiveSheet()->setCellValue('A' . ($rowindex + 2), $gsumlist[$i]['gname']);
                    $objPHPExcel->getActiveSheet()->setCellValue('C' . ($rowindex + 2), $gsumlist[$i]['gname']);
                    $objPHPExcel->getActiveSheet()->setCellValue('D' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['gname']); //
                    $objPHPExcel->getActiveSheet()->setCellValue('E' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['summonth']); //
                    for ($j = 1; $j <= $daysofm; $j++) {
                        $daystr = strval($j);
                        if (strlen($daystr) < 2) {
                            $daystr = '0' . $daystr;
                        }
                        $fname = $yearinfo . '-' . $monthinfo . '-' . $daystr;
                        //$eecll=new \PHPExcel_Cell()
                        $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($j + 4);
                        $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($rowindex + 2), (array_key_exists($fname, $gsumlist[$i]['detail'][$workerindex]) ? $gsumlist[$i]['detail'][$workerindex][$fname] : '-')); //说明
                    }
                    //招工成本处理
                    $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 5);
                    $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($rowindex + 2), (array_key_exists('recuitcost', $gsumlist[$i]['detail'][$workerindex]) ? $gsumlist[$i]['detail'][$workerindex]['recuitcost'] : '-'));

                    $rowindex++; //行控制
                }
                if ($workercounts > 0) {
                    $endworker = $rowindex + 1; //最后一行
                    $objPHPExcel->getActiveSheet()->mergeCells('A' . $firstworker . ':A' . $endworker);
                    $objPHPExcel->getActiveSheet()->getstyle('A' . $firstworker . ':A' . $endworker)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
                    $objPHPExcel->getActiveSheet()->mergeCells('B' . $firstworker . ':B' . $endworker);
                    $objPHPExcel->getActiveSheet()->getstyle('B' . $firstworker . ':B' . $endworker)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
                    $objPHPExcel->getActiveSheet()->setCellValue('B' . $firstworker, $gsumlist[$i]['summonth']);
                } else {
                    $objPHPExcel->getActiveSheet()->setCellValue('A' . ($rowindex + 2), $gsumlist[$i]['gname']);
                    $objPHPExcel->getActiveSheet()->setCellValue('B' . ($rowindex + 2), 0);
                    $rowindex++;
                }

            }
            //8.设置当前激活的sheet表格名称；
            $objPHPExcel->getActiveSheet()->setTitle($cname . '考勤汇总');
            $pageindex++;

        }

        //7.设置保存的Excel表格名称
        $filename = '考勤汇总' . date('ymd', time()) . '.xls';

        //9.设置浏览器窗口下载表格
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");
        header('Content-Disposition:inline;filename="' . $filename . '"');
        //生成excel文件
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        //下载文件在浏览器窗口
        $objWriter->save('php://output');
        //原代码没有返回
        $res_r['code'] = 200;
        $res_r['resultData'] = $filename;
        return json_encode($res_r, 320);
    }

    /*
     * 20201029
     * 自动导出所有的项目合同考勤，分页
     * 并且合并成一个表
     * 在allworkersumtoexecl（）方法基础上修改
     *
     *
     */

    public function allworkersumuniontoexecl() {
        /*
         * 准备
         */
        //获取数据
        $queryinfo = request()->param();
        $yearinfo = $queryinfo['yearinfo'];
        $monthinfo = $queryinfo['monthinfo'];
        $strmonth = $yearinfo . '-' . $monthinfo;
        //获取所有导出的合同
        $l_contact = new contactlogic();
        $list_contact = $l_contact->getclist();
        //获取当用天数
        $daysofm = date('t', strtotime($yearinfo . '-' . $monthinfo . '-1'));
        //加载类库
        vendor('PHPExcel.PHPExcel');
        $objPHPExcel = new \PHPExcel();
        $pageindex = 0; //初始化页数，后面不再循环  todo 去掉此变理
        /*
         * 循环处理所有合同
         */
        $rowindex = 0;

        //4.激活当前的sheet表

        $objPHPExcel->setActiveSheetIndex($pageindex);
        //5.设置表格头（即excel表格的第一行）
        $objPHPExcel->setActiveSheetIndex($pageindex)
            ->setCellValue('A1', '合同')
            ->setCellValue('B1', '班组')
            ->setCellValue('C1', '总分')
            ->setCellValue('D1', '月度')
            ->setCellValue('E1', '工人')
            ->setCellValue('F1', '身份证')
            ->setCellValue('G1', '当月总记分');
        for ($j = 1; $j <= $daysofm; $j++) {
            $columnname = strval($j);
            if (strlen($columnname) < 2) {
                $columnname = '0' . $columnname;
            }
            $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($j + 6);
            $objPHPExcel->setActiveSheetIndex($pageindex)->setCellValue($fcolumnchar . '1', $columnname);

        }

        $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 7);
        $objPHPExcel->setActiveSheetIndex($pageindex)->setCellValue($fcolumnchar . '1', '招工成本');
        //设置A列水平居中
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('A')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('B')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('C')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('D')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('E')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('F')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        //设置F列为文本列
        $objPHPExcel->getActiveSheet()->getStyle('F')->getNumberFormat()
            ->setFormatCode(\PHPExcel_Style_NumberFormat::FORMAT_TEXT); //
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('G')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        //设置单元格宽度
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('A')->setWidth(20);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('B')->setWidth(20);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('C')->setWidth(11);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('D')->setWidth(20);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('E')->setWidth(10);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('F')->setWidth(18);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('G')->setWidth(13);
        //6.循环刚取出来的数组，将数据逐一添加到excel表格。
        foreach ($list_contact as $contact) {
            $queryinfo['cid'] = $contact['id'];
            $cname = $contact['contactname'];
            //获取合同的数据
            $gsumlist = $l_contact->getworkersumbycid($queryinfo);

            for ($i = 0; $i < count($gsumlist); $i++) {

                $firstworker = $rowindex + 2;
                $workercounts = count($gsumlist[$i]['detail']);
                for ($workerindex = 0; $workerindex < $workercounts; $workerindex++) {
                    $objPHPExcel->getActiveSheet()->setCellValue('A' . ($rowindex + 2), $cname);
                    $objPHPExcel->getActiveSheet()->setCellValue('B' . ($rowindex + 2), $gsumlist[$i]['gname']);
                    $objPHPExcel->getActiveSheet()->setCellValue('D' . ($rowindex + 2), $strmonth);
                    $objPHPExcel->getActiveSheet()->setCellValue('E' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['gname']); //
                    $objPHPExcel->getActiveSheet()->setCellValue('F' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['sfz']); //
                    $objPHPExcel->getActiveSheet()->setCellValue('G' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['summonth']); //
                    for ($j = 1; $j <= $daysofm; $j++) {
                        $daystr = strval($j);
                        if (strlen($daystr) < 2) {
                            $daystr = '0' . $daystr;
                        }
                        $fname = $yearinfo . '-' . $monthinfo . '-' . $daystr;
                        //$eecll=new \PHPExcel_Cell()
                        $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($j + 6);
                        $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($rowindex + 2), (array_key_exists($fname, $gsumlist[$i]['detail'][$workerindex]) ? $gsumlist[$i]['detail'][$workerindex][$fname] : '-')); //说明
                    }
                    //招工成本处理
                    $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 7);
                    $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($rowindex + 2), (array_key_exists('recuitcost', $gsumlist[$i]['detail'][$workerindex]) ? $gsumlist[$i]['detail'][$workerindex]['recuitcost'] : '-'));

                    $rowindex++; //行控制
                }
                if ($workercounts > 0) {
                    $endworker = $rowindex + 1; //最后一行
                    //根据客户要求，不再分隔，20201106
//                    $objPHPExcel->getActiveSheet()->mergeCells('A'.$firstworker.':A'.$endworker);
//                    $objPHPExcel->getActiveSheet()->getstyle('A'.$firstworker.':A'.$endworker)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
//                    $objPHPExcel->getActiveSheet()->mergeCells('B'.$firstworker.':B'.$endworker);
//                    $objPHPExcel->getActiveSheet()->getstyle('B'.$firstworker.':B'.$endworker)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
                    $objPHPExcel->getActiveSheet()->mergeCells('C' . $firstworker . ':C' . $endworker);
                    $objPHPExcel->getActiveSheet()->getstyle('C' . $firstworker . ':C' . $endworker)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
                    $objPHPExcel->getActiveSheet()->setCellValue('C' . $firstworker, $gsumlist[$i]['summonth']);

                } else {
                    $objPHPExcel->getActiveSheet()->setCellValue('A' . ($rowindex + 2), $cname);
                    $objPHPExcel->getActiveSheet()->setCellValue('B' . ($rowindex + 2), $gsumlist[$i]['gname']);
                    $objPHPExcel->getActiveSheet()->setCellValue('C' . ($rowindex + 2), 0);
                    $rowindex++;
                }

            }
            //8.设置当前激活的sheet表格名称；
            //  $objPHPExcel->getActiveSheet()->setTitle($cname .'考勤汇总');
            //  $pageindex++;

        }

        $objPHPExcel->getActiveSheet()->setTitle($strmonth . '考勤汇总');

        //7.设置保存的Excel表格名称
        $filename = '考勤汇总' . date('ymd', time()) . '.xls';

        //9.设置浏览器窗口下载表格
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");
        header('Content-Disposition:inline;filename="' . $filename . '"');
        //生成excel文件
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        //下载文件在浏览器窗口
        $objWriter->save('php://output');
        //原代码没有返回
        $res_r['code'] = 200;
        $res_r['resultData'] = $filename;
        return json_encode($res_r, 320);
    }

    /*
     * 20230215
     *  获取本公司的项目合同汇总
     */
    public function companyworkersumuniontoexecl() {
        /*
         * 准备
         */
        //获取数据
        $queryinfo = request()->param();
        $yearinfo = $queryinfo['yearinfo'];
        $monthinfo = $queryinfo['monthinfo'];
        $cid = $queryinfo['companyid']; //公司id
        $strmonth = $yearinfo . '-' . $monthinfo;
        //获取所有导出的合同
        $l_contact = new contactlogic();
        $list_contact = $l_contact->getcompanyclist($cid);
        //获取当用天数
        $daysofm = date('t', strtotime($yearinfo . '-' . $monthinfo . '-1'));
        //加载类库
        vendor('PHPExcel.PHPExcel');
        $objPHPExcel = new \PHPExcel();
        $pageindex = 0; //初始化页数，后面不再循环  todo 去掉此变理
        /*
         * 循环处理所有合同
         */
        $rowindex = 0;

        //4.激活当前的sheet表

        $objPHPExcel->setActiveSheetIndex($pageindex);
        //5.设置表格头（即excel表格的第一行）
        $objPHPExcel->setActiveSheetIndex($pageindex)
            ->setCellValue('A1', '合同')
            ->setCellValue('B1', '班组')
            ->setCellValue('C1', '总分')
            ->setCellValue('D1', '月度')
            ->setCellValue('E1', '工人')
            ->setCellValue('F1', '身份证')
            ->setCellValue('G1', '当月总记分');
        for ($j = 1; $j <= $daysofm; $j++) {
            $columnname = strval($j);
            if (strlen($columnname) < 2) {
                $columnname = '0' . $columnname;
            }
            $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($j + 6);
            $objPHPExcel->setActiveSheetIndex($pageindex)->setCellValue($fcolumnchar . '1', $columnname);

        }

        $fcolumnchar = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 7);
        $objPHPExcel->setActiveSheetIndex($pageindex)->setCellValue($fcolumnchar . '1', '招工成本');
        //设置A列水平居中
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('A')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('B')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('C')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('D')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('E')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('F')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        //设置F列为文本列
        $objPHPExcel->getActiveSheet()->getStyle('F')->getNumberFormat()
            ->setFormatCode(\PHPExcel_Style_NumberFormat::FORMAT_TEXT); //
        $objPHPExcel->setActiveSheetIndex($pageindex)->getStyle('G')->getAlignment()
            ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        //设置单元格宽度
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('A')->setWidth(20);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('B')->setWidth(20);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('C')->setWidth(11);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('D')->setWidth(20);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('E')->setWidth(10);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('F')->setWidth(18);
        $objPHPExcel->setActiveSheetIndex($pageindex)->getColumnDimension('G')->setWidth(13);
        //6.循环刚取出来的数组，将数据逐一添加到excel表格。
        foreach ($list_contact as $contact) {
            $queryinfo['cid'] = $contact['id'];
            $cname = $contact['contactname'];
            //获取合同的数据
            $gsumlist = $l_contact->getworkersumbycid($queryinfo);

            for ($i = 0; $i < count($gsumlist); $i++) {

                $firstworker = $rowindex + 2;
                $workercounts = count($gsumlist[$i]['detail']);
                for ($workerindex = 0; $workerindex < $workercounts; $workerindex++) {
                    $objPHPExcel->getActiveSheet()->setCellValue('A' . ($rowindex + 2), $cname);
                    $objPHPExcel->getActiveSheet()->setCellValue('B' . ($rowindex + 2), $gsumlist[$i]['gname']);
                    $objPHPExcel->getActiveSheet()->setCellValue('D' . ($rowindex + 2), $strmonth);
                    $objPHPExcel->getActiveSheet()->setCellValue('E' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['gname']); //
                    $objPHPExcel->getActiveSheet()->setCellValue('F' . ($rowindex + 2), "'" . $gsumlist[$i]['detail'][$workerindex]['sfz']); //
                    $objPHPExcel->getActiveSheet()->setCellValue('G' . ($rowindex + 2), $gsumlist[$i]['detail'][$workerindex]['summonth']); //
                    for ($j = 1; $j <= $daysofm; $j++) {
                        $daystr = strval($j);
                        if (strlen($daystr) < 2) {
                            $daystr = '0' . $daystr;
                        }
                        $fname = $yearinfo . '-' . $monthinfo . '-' . $daystr;
                        //$eecll=new \PHPExcel_Cell()
                        $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($j + 6);
                        $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($rowindex + 2), (array_key_exists($fname, $gsumlist[$i]['detail'][$workerindex]) ? $gsumlist[$i]['detail'][$workerindex][$fname] : '-')); //说明
                    }
                    //招工成本处理
                    $fcolumnstr = \PHPExcel_Cell::stringFromColumnIndex($daysofm + 7);
                    $objPHPExcel->getActiveSheet()->setCellValue($fcolumnstr . ($rowindex + 2), (array_key_exists('recuitcost', $gsumlist[$i]['detail'][$workerindex]) ? $gsumlist[$i]['detail'][$workerindex]['recuitcost'] : '-'));

                    $rowindex++; //行控制
                }
                if ($workercounts > 0) {
                    $endworker = $rowindex + 1; //最后一行
                    //根据客户要求，不再分隔，20201106
//                    $objPHPExcel->getActiveSheet()->mergeCells('A'.$firstworker.':A'.$endworker);
//                    $objPHPExcel->getActiveSheet()->getstyle('A'.$firstworker.':A'.$endworker)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
//                    $objPHPExcel->getActiveSheet()->mergeCells('B'.$firstworker.':B'.$endworker);
//                    $objPHPExcel->getActiveSheet()->getstyle('B'.$firstworker.':B'.$endworker)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
                    $objPHPExcel->getActiveSheet()->mergeCells('C' . $firstworker . ':C' . $endworker);
                    $objPHPExcel->getActiveSheet()->getstyle('C' . $firstworker . ':C' . $endworker)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
                    $objPHPExcel->getActiveSheet()->setCellValue('C' . $firstworker, $gsumlist[$i]['summonth']);

                } else {
                    $objPHPExcel->getActiveSheet()->setCellValue('A' . ($rowindex + 2), $cname);
                    $objPHPExcel->getActiveSheet()->setCellValue('B' . ($rowindex + 2), $gsumlist[$i]['gname']);
                    $objPHPExcel->getActiveSheet()->setCellValue('C' . ($rowindex + 2), 0);
                    $rowindex++;
                }

            }
            //8.设置当前激活的sheet表格名称；
            //  $objPHPExcel->getActiveSheet()->setTitle($cname .'考勤汇总');
            //  $pageindex++;

        }

        $objPHPExcel->getActiveSheet()->setTitle($strmonth . '考勤汇总');

        //7.设置保存的Excel表格名称
        $filename = '考勤汇总' . date('ymd', time()) . '.xls';

        //9.设置浏览器窗口下载表格
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");
        header('Content-Disposition:inline;filename="' . $filename . '"');
        //生成excel文件
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        //下载文件在浏览器窗口
        $objWriter->save('php://output');
        //原代码没有返回
        $res_r['code'] = 200;
        $res_r['resultData'] = $filename;
        return json_encode($res_r, 320);
    }
}