public function import(){
$filePath = '/'.iconv('UTF-8', 'GBK', 'lq').'.xls';
Excel::load($filePath, function ($reader) {
/* $reader->noHeading();*/
$data = $reader->toArray();
/* array_pull($data, 0);//去除0号元素 =>Excel表格的头*/
for ($m=0;$m<sizeof($data);$m++) {
$item = new enroll();
$item->save();
}
});
}
public function export()
{
$arr = ['排名', '微信昵称', '姓名', '手机号'];
$list = [];
$enrolls = Member::query()->where('zongnum',6)->get()->toArray();
/*dd($enrolls);*/
foreach ($enrolls as $k=>$item)
{
$nickname = iconv("UTF-8","GB2312//IGNORE",$item['nickname']);
$nickname = iconv("GB2312","UTF-8//IGNORE",$nickname);
$list[$k][] = $k;
$list[$k][] =$nickname;
$list[$k][] = $item['realname'];
$list[$k][] = $item['tel'];
//类型 1.正常 2.处长 3.联络员
}
/*array_unshift($list, $arr);*/
Excel::create('中奖名单',function ($excel) use ($list) {
$excel->sheet('score', function ($sheet) use ($list) {
$sheet->rows($list);
});
})->export('xls');
}
}
