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 "
"; } 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']); } }