public function generate_excel_one($data=array()){
    // 导出Exl
    import("PHPExcel.PHPExcel");
    import("PHPExcel.PHPExcel.Worksheet.Drawing");
    //import("PHPExcel.PHPExcel.Writer.Excel2007");
    $objPHPExcel = new \PHPExcel();
    //$objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel);    $objActSheet = $objPHPExcel->getActiveSheet();    // 水平居中(位置很重要,建议在最初始位置)
    $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->setActiveSheetIndex(0)->getStyle('B1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->setActiveSheetIndex(0)->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->setActiveSheetIndex(0)->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->setActiveSheetIndex(0)->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->setActiveSheetIndex(0)->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);    $objActSheet->setCellValue('A1', '序号');
    $objActSheet->setCellValue('B1', '创建时间');
    $objActSheet->setCellValue('C1', '分享模块');
    $objActSheet->setCellValue('D1', '分享文案');
    $objActSheet->setCellValue('E1', '背景图片');
    $objActSheet->setCellValue('F1', '分享微信图片');
    $objActSheet->setCellValue('G1', '生成海报图片');
    $objActSheet->setCellValue('H1', 'APP&小程序');
    $objActSheet->setCellValue('I1', '操作账号');
    // 设置个表格宽度
    $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(8);
    $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
    $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);
    $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
    $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(12);
    $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(12);
    $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(12);
    $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(12);
    // 垂直居中
    $objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $dir_mk=PUBLIC_PATH . '/download_temp/';
    if (!is_dir($dir_mk)) {
        @mkdir($dir_mk, 0755, true);
    }
    foreach((array)$data as $k=>$v){
        $k +=2;
        $objActSheet->setCellValue('A'.$k, $v['share_management_id']);
        $objActSheet->setCellValue('B'.$k, $v['create_time']);
        $objActSheet->setCellValue('C'.$k, $v['share_module_name']);
        $objActSheet->setCellValue('D'.$k, $v['share_article']);
        if(!empty($v['share_background_img'])) {
            $objDrawing[$k] = new \PHPExcel_Worksheet_Drawing();
            $temp_img_1 = $this->download($v['share_background_img'], PUBLIC_PATH . '/download_temp/');//background
            $local_pic_path_1 = $dir_mk . $temp_img_1;
            if (file_exists($local_pic_path_1)) {
                // 图片生成 poster
                $objDrawing[$k]->setPath($local_pic_path_1);
                // 设置宽度高度
                $objDrawing[$k]->setHeight(80);//照片高度
                $objDrawing[$k]->setWidth(80); //照片宽度
                //设置图片要插入的单元格
                $objDrawing[$k]->setCoordinates('E' . $k);
                // 图片偏移距离
                $objDrawing[$k]->setOffsetX(0);
                $objDrawing[$k]->setOffsetY(0);
                $objDrawing[$k]->setWorksheet($objPHPExcel->getActiveSheet());
            }
        }
        if(!empty($v['share_wechat_img'])) {
            $objDrawing_k[$k] = new \PHPExcel_Worksheet_Drawing();
            $temp_img_2 = $this->download($v['share_wechat_img'], PUBLIC_PATH . '/download_temp/');//wechat
            $local_pic_path_2 = $dir_mk .$temp_img_2;
            if (file_exists($local_pic_path_2)) {
                // 图片生成 poster
                $objDrawing_k[$k]->setPath($local_pic_path_2);
                // 设置宽度高度
                $objDrawing_k[$k]->setHeight(80);//照片高度
                $objDrawing_k[$k]->setWidth(80); //照片宽度
                //设置图片要插入的单元格
                $objDrawing_k[$k]->setCoordinates('F' . $k);
                // 图片偏移距离
                $objDrawing_k[$k]->setOffsetX(0);
                $objDrawing_k[$k]->setOffsetY(0);
                $objDrawing_k[$k]->setWorksheet($objPHPExcel->getActiveSheet());
            }
        }        if(!empty($v['share_poster_img'])) {
            $objDrawing_kk[$k] = new \PHPExcel_Worksheet_Drawing();
            $temp_img = $this->download($v['share_poster_img'], PUBLIC_PATH . '/download_temp/');//poster
            $local_pic_path = $dir_mk . $temp_img;
            if (file_exists($local_pic_path)) {
                // 图片生成 poster
                $objDrawing_kk[$k]->setPath($local_pic_path);
                // 设置宽度高度
                $objDrawing_kk[$k]->setHeight(80);//照片高度
                $objDrawing_kk[$k]->setWidth(80); //照片宽度
                //设置图片要插入的单元格
                $objDrawing_kk[$k]->setCoordinates('G' . $k);
                // 图片偏移距离
                $objDrawing_kk[$k]->setOffsetX(0);
                $objDrawing_kk[$k]->setOffsetY(0);
                $objDrawing_kk[$k]->setWorksheet($objPHPExcel->getActiveSheet());
            }
        }        // 表格内容
        $objActSheet->setCellValue('H'.$k, $v['share_platform']);
        $objActSheet->setCellValue('I'.$k, $v['admin_account_number']);        // 表格高度
        $objActSheet->getRowDimension($k)->setRowHeight(80);    }    $fileName = '后台创建分享列表';
    $date = date("Y-m-d",time());
    $fileName .= "_{$date}.xls";
    $fileName = iconv("utf-8", "gb2312", $fileName);
    //重命名表
    // $objPHPExcel->getActiveSheet()->setTitle('test');
    //设置活动单指数到第一个表,所以Excel打开这是第一个表
    $objPHPExcel->setActiveSheetIndex(0);
    header('Content-Type: application/vnd.ms-excel');
    header("Content-Disposition: attachment;filename=\"$fileName\"");
    header('Cache-Control: max-age=100');
    $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    $objWriter->save('php://output'); //文件通过浏览器下载
    // END
}
private function download($url, $path = './public/download_temp/')
{
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 90);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // 信任任何证书
    $file = curl_exec($ch);
    curl_close($ch);
    $filename = pathinfo($url, PATHINFO_BASENAME);
    $resource = fopen($path . $filename, 'w');
    fwrite($resource, $file);
    fclose($resource);
    return $filename;
}

点赞(0) 打赏

评论列表 共有 0 条评论

暂无评论

微信小程序

微信扫一扫体验

立即
投稿

微信公众账号

微信扫一扫加关注

发表
评论
返回
顶部