PHP data visualization and report generation in small program development

<?php
// 创建一个400x300的画布
$image = imagecreatetruecolor(400, 300);

// 设置画布背景颜色为白色
$white = imagecolorallocate($image, 255, 255, 255);
imagefill($image, 0, 0, $white);

// 设置柱状图的数据
$data = array(50, 80, 120, 200, 150);
$colors = array('red', 'green', 'blue', 'yellow', 'orange');

// 计算柱状图的宽度和间距
$barWidth = 40;
$gap = 10;

// 绘制柱状图
foreach ($data as $key => $value) {
    $x1 = $key * ($barWidth + $gap) + 50;
    $y1 = 300 - $value;
    $x2 = $x1 + $barWidth;
    $y2 = 300;
    
    $color = imagecolorallocate($image, hexdec(substr($colors[$key], 0, 2)), hexdec(substr($colors[$key], 2, 2)), hexdec(substr($colors[$key], 4, 2)));
    imagefilledrectangle($image, $x1, $y1, $x2, $y2, $color);
}

// 输出图像
header("Content-type: image/png");
imagepng($image);

// 释放内存
imagedestroy($image);
?>

<?php
require('php_highcharts/Highchart.php');

// 创建一个折线图
$chart = new Highchart();

// 设置图表配置
$chart->chart->renderTo = 'container';
$chart->title->text = '折线图';
$chart->xAxis->categories = array('一月', '二月', '三月', '四月', '五月', '六月');
$chart->yAxis->title->text = '销售量';

// 设置图表数据
$chart->series[] = array('name' => '苹果', 'data' => array(8, 11, 10, 17, 12, 13));
$chart->series[] = array('name' => '香蕉', 'data' => array(7, 8, 6, 10, 9, 11));
$chart->series[] = array('name' => '橙子', 'data' => array(5, 7, 6, 8, 9, 10));

// 输出图表
echo $chart->render();
?>

<?php
require_once 'PHPExcel/PHPExcel.php';

// 创建一个Excel对象
$objPHPExcel = new PHPExcel();

// 设置表格属性
$objPHPExcel->getProperties()->setCreator('小程序开发')->setTitle('报表');

// 设置单元格内容
$objPHPExcel->getActiveSheet()->setCellValue('A1', '姓名');
$objPHPExcel->getActiveSheet()->setCellValue('B1', '年龄');
$objPHPExcel->getActiveSheet()->setCellValue('C1', '性别');

// 填充数据
$data = array(
    array('张三', 25, '男'),
    array('李四', 30, '女'),
    array('王五', 28, '男')
);

foreach ($data as $key => $row) {
    $objPHPExcel->getActiveSheet()->setCellValue('A'.($key+2), $row[0]);
    $objPHPExcel->getActiveSheet()->setCellValue('B'.($key+2), $row[1]);
    $objPHPExcel->getActiveSheet()->setCellValue('C'.($key+2), $row[2]);
}

// 导出Excel文件
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="report.xlsx"');
header('Cache-Control: max-age=0');
$objWriter->save('php://output');
?>

<?php
require_once('tcpdf/tcpdf.php');

// 创建一个PDF对象
$pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8', false);

// 设置PDF属性
$pdf->SetCreator('小程序开发');
$pdf->SetAuthor('小程序开发');
$pdf->SetTitle('报表');

// 添加一页
$pdf->AddPage();

// 设置字体
$pdf->SetFont('dejavusans', '', 12);

// 设置表头
$pdf->Cell(30, 7, '姓名', 1, 0, 'C');
$pdf->Cell(30, 7, '年龄', 1, 0, 'C');
$pdf->Cell(30, 7, '性别', 1, 1, 'C');

// 填充数据
$data = array(
    array('张三', 25, '男'),
    array('李四', 30, '女'),
    array('王五', 28, '男')
);

foreach ($data as $row) {
    $pdf->Cell(30, 7, $row[0], 1, 0, 'C');
    $pdf->Cell(30, 7, $row[1], 1, 0, 'C');
    $pdf->Cell(30, 7, $row[2], 1, 1, 'C');
}

// 输出PDF
$pdf->Output('report.pdf', 'I');
?>