<?php /** * composer 安装 composer require phpoffice/phpexcel */ /** * 导入绑定 * @throws PHPExcel_Exception * @throws PHPExcel_Reader_Exception * User: Dh106 * Date: 2018/8/9 * Time: 16:14 */ public function importBind() { $name = request()->file('file'); $info = $name->move(ROOT_PATH . 'public' . DS . 'uploads'. DS . 'file'); $file = $info->getPathname(); $objPHPExcel = PHPExcel_IOFactory::load($file); $objPHPExcel->setActiveSheetIndex(0); $sheet=$objPHPExcel->getSheet(0); $highrow = $sheet->getHighestRow(); for ($i=2;$i<=$highrow;$i++) { $userteamtitle = (string)$sheet->getCellByColumnAndRow(3,$i)->getValue(); if(empty($userteamtitle)) { break; } $cardsn = trim((string)$sheet->getCellByColumnAndRow(1,$i)->getValue(),' '); $cardsnONE = substr($cardsn,0,1); $cardsn = $cardsnONE=='y'?$cardsn:substr($cardsn,2); $username = (string)$sheet->getCellByColumnAndRow(2,$i)->getValue(); $teamid = $this->logicIdentityTeam->getTeamIdByName($userteamtitle); $data = [ 'user_name' => $username, 'user_team' => $teamid, 'bind_time' => time(), 'update_time' => time(), ]; $this->logicIdentityCard->bindCardByImport($cardsn,$data); } $this->ajaxJump([RESULT_SUCCESS,'导入成功',url('identitycard/cardList')]); }
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。