Excel导出

(五).Excel导出:

 

   一.引入composer包:


1.composer require -vvv //生成最新版本的 composer.json
2.config/app.php: 'provider'=>:Maatwebsite\Excel\ExcelServiceProvider::class //服务
  'aliases' =>:'Excel' => Maatwebsite\Excel\Facades\Excel::class //门面
3.生成配置文件: php artisan vendor:publish  //Excel.php


   二.模板里:


    // 1.button按钮 id
    <form id="export"></form>
<button type="button" class="btn btn-warning btn-sm" οnclick="exports()">导出</button>


// 2.商品导出方法
function exports()
{
  var data = $("#export").serialize();
  location.href = "{{url("admin/goods/export")}}?"+data;
}


三.路由
        Route::get("export","GoodsController@export")->name("goods.export");


    四.控制器
    
    public function export(Goods $goods,NormsGroup $normsGroup,Request $request,GoodsType $goodsType,GoodsStatus $goodsStatus)
    {
        //获取商品分类
        $goodsTypeInfo=$goodsType::whereNotIn("parent_id",[0,56])->get()->toArray();
        //获取所有商品状态
        $goodsStatusInfo=$goodsStatus::all()->toArray();
        //获取商品分类
        $info['name']=$request->input("name")?$request->input("name"):"";
        $info['id']=$request->input("id")?$request->input("id"):"";
        $info['category']=$request->input("category")?$request->input("category"):0;
        $info['status']=$request->input("status")?[$request->input("status")]:[1,2,3,4,5];
        //获取商品列表
        if ($info['id'])
        {
            if ($info['category'])
            {
                $goodsInfos=$goods::with("goodsStatus","goodsType")->where([["name","like","%{$info['name']}%"],["id",$info['id']],["f_goods_type_id",$info['category']]])->whereIn("f_goods_status_id",$info['status'])->get();
            }else
            {
                $goodsInfos=$goods::with("goodsStatus","goodsType")->where([["name","like","%{$info['name']}%"],["id",$info['id']]])->whereIn("f_goods_status_id",$info['status'])->get();
            }
        }else
        {
            if ($info['category'])
            {
                $goodsInfos=$goods::with("goodsStatus","goodsType")->where([["name","like","%{$info['name']}%"],["f_goods_type_id",$info['category']]])->whereIn("f_goods_status_id",$info['status'])->get();
            }else
            {
                $goodsInfos=$goods::with("goodsStatus","goodsType")->where("name","like","%{$info['name']}%")->whereIn("f_goods_status_id",$info['status'])->get();
            }
        }
        $goodsInfo=$goodsInfos->toArray();
        foreach ($goodsInfo as $k =>$v)
        {
            $normsGroupId=explode(",",$v['f_norms_group_id']);
            $normsGroupInfo=$normsGroup->whereIn("id",$normsGroupId)->get()->toArray();
            $goodsInfo[$k]["norms_group"]=$normsGroupInfo;
        }


        //整成一维数组
        $data[]=[
            '编号',
            '商品名称',
            '所属分类',
            '录入时间',
            '商品规格组合',
            '状态',
            '商品价格',
            '11121(价格)',
        ];
        // foreach($goodsInfo as $k=>$v){
        //     $temp['id'] = $v['id'];
        //     $temp['open_id'] = $v['open_id'];
        //     $temp['goods_type'] = $v['goods_type']['name'];
        //     $temp['create_time'] = date('Y-m-d',$v['create_time']);
        //     $temp['norms_group']="";
        //     foreach ($v['norms_group'] as $kk=>$vv){
        //         $temp['norms_group'] .= $vv['name']."|";
        //     }
        //     $temp['norms_group']=trim($temp['norms_group'],"|");
        //     $temp['status'] = $v['goods_status']['name'];
        //     $temp['show_price'] = $v['show_price'];
        //     $temp['show_sale_price'] = $v['show_sale_price'];
        //     $data[] = $temp;
        // }


        //排行 用户成交额计算 number_format
    $i=0;
        foreach($employeeInfo as $k=>$v){
            $temp_money["no"] = ++$i;
            $temp_money["username"] = $v['username'];
            $temp_money['userTurnover'] = number_format($price[$v['id']]/100,2,".","");
            $temp_money['area1'] = "";
            foreach($areaInfo as $kk=>$vv){
                if ($v['f_area_id'] == $vv['id']){
                    $temp_money['area1'] = $vv['name'];
                }
            }
            $data[] = $temp_money;
        }


        Excel::create('goodsInfo',function($excel) use ($data){
            $excel->sheet('goodsInfo', function($sheet) use ($data){
                $sheet->rows($data);
            });
        })->export('xls');


    }