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