PHPExcel导出图片表格

悠悠 2023-01-16 02:46 114阅读 0赞

public function exportTrackNumberInfo()
        { 
            $params = \request()->param();
            $ids = $params['ids'] = '38505,38504';
            $data = db('order')
                ->field('id,order_sn,tracking_num')
                ->whereIn('id', $ids)->order('id desc')->select();
    
            $or_go = db('order_goods')
                ->alias('or')
                ->join('goods_imgs go', 'or.goods_id=go.goods_id')
                ->field('or.order_id,go.path')
                ->whereIn('or.order_id', $ids)
                ->where('go.sort_order=0')
                ->order('or.order_id desc')
                ->select();
            $titleExcelss = [['商品图片', '订单号', '运单号']];
            $objPHPExcel = new \PHPExcel();
            $objPHPExcel->getActiveSheet()->getStyle('A1:C1')->getFont()->setSize(12);//字体大小
    
            foreach ($titleExcelss as $ki => $node) { 
                $k = 'A';
                foreach ($node as $one) { 
                    $objPHPExcel->setActiveSheetIndex(0)->setCellValue($k . strval($ki + 1), $one);
                    $k++;
                }
            }
    
            foreach ($data as $ki => $node) { 
                $objDrawing = new \PHPExcel_Worksheet_Drawing();
                $ptt = $or_go[$ki]['path'];
                $pat = ROOT_PATH . 'exportTrackNumberInfo/' . basename($ptt);
                copy(trim($ptt), $pat);
                $objDrawing->setPath($pat);
                $objDrawing->setWidthAndHeight(80, 80); //设置照片宽高度
                $objDrawing->setOffsetX(7);
                $objDrawing->setOffsetY(7);
                $objDrawing->setRotation(0);
                $objDrawing->getShadow()->setVisible(true);
                $objDrawing->getShadow()->setDirection(50);
                $objDrawing->setCoordinates('A' . ($ki + 2));
                $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
    
                $objPHPExcel->getActiveSheet()->getRowDimension($ki + 2)->setRowHeight(70);#设定从第二行开始的高度
                $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(13);#设置A裂的宽度
                $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(23);#设置B列的宽度
                $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);#设置C列的宽度
                $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . ($ki + 2), $node['order_sn']);
                $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C' . ($ki + 2), $node['tracking_num'] . ' ');
                $objPHPExcel->getActiveSheet()->getStyle('A1:C' . (count($data) + 1))->getAlignment()
                    ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//设置文字居中
    
    
            }
    
    
            ob_end_clean();
            header("Pragma: public");
            header("Expires: 0");
            header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
            header("Content-Type:application/force-download");
            header("Content-Type:application/vnd.ms-execl");
            header("Content-Type:application/octet-stream");
            header("Content-Type:application/download");;
            header('Content-Disposition:attachment;filename="' . '11' . '.xls"');
            header("Content-Transfer-Encoding:binary");
            $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
            $objWriter->save('php://output');
    
        }