guochanhua/zskk_new_manage/application/index/controller/Index.php

<?php

namespace app\index\controller;

use app\common\controller\Frontend;
use PhpOffice\PhpSpreadsheet\IOFactory;
use think\Db;

class Index extends Frontend
{

    protected $noNeedLogin = '*';
    protected $noNeedRight = '*';
    protected $layout = '';

    public function index()
    {
        var_dump(1);die;
        return $this->view->fetch();
        import('phpexcel.PHPExcel', EXTEND_PATH);
//        $a = new Spreadsheet();
        $path = ROOT_PATH.'public/mx.xlsx';
        $reader = IOFactory::createReader('Xlsx');
        $excal= $reader->load($path);
        $sheet = $excal->getActiveSheet();
        $all = 0;
        for ($i=1;$i<1251;$i++)
        {
            $value2 = $sheet->getCell('B'.$i)->getValue();
            $value3 = $sheet->getCell('C'.$i)->getValue();
            $value4 = $sheet->getCell('D'.$i)->getValue();
            $value4 = $this->excelTime($value4);
            $num = Db::table('print_sync')->where('institution_id','06300006')->where("DATE_FORMAT(print_time,'%Y-%m-%d') = '$value4'")->where('code',$value3)->sum('times');
            if($num == $value2)
            {
                continue;
            }
            $x = $num - $value2;
            $all += $x;
            var_dump('查询数'.$num);
            var_dump('表格数'.$value2);
            var_dump('code码'.$value3);
            echo "<br>";
        }
        var_dump('总差值'.$all);die;
    }

    public function excelTime($date, $time = false) {
        if (function_exists('GregorianToJD')) {
            if (is_numeric($date)) {
                $jd = GregorianToJD(1, 1, 1970);
                $gregorian = JDToGregorian($jd + intval($date) - 25569);
                $date = explode('/', $gregorian);
                $date_str = str_pad($date[2], 4, '0', STR_PAD_LEFT) . "-" . str_pad($date[0], 2, '0', STR_PAD_LEFT) . "-" . str_pad($date[1], 2, '0', STR_PAD_LEFT) . ($time ? " 00:00:00" : '');
                return $date_str;
            }
        } else {
            $date = $date > 25568 ? $date + 1 : 25569;
            /*There was a bug if Converting date before 1-1-1970 (tstamp 0)*/
            $ofs = (70 * 365 + 17 + 2) * 86400;
            $date = date("Y-m-d", ($date * 86400) - $ofs) . ($time ? " 00:00:00" : '');
        }
        return $date;
    }

    public function news()
    {
        $newslist = [];
        return jsonp(['newslist' => $newslist, 'new' => count($newslist), 'url' => 'https://www.fastadmin.net?ref=news']);
    }

}