//控制器调用
$id=\Yii::$app->request->get('id');
$arr=\Yii::$app->exam->createCommand("select * from `order` INNER JOIN movie on `order`.movie_id=![]()
movie.id where `order`.id in ($id)")->queryAll();
$strTable ='<table width="500" border="1">';
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="150px">订单</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">姓名</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">电话</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">预约时间</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">预约座位</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">预约电影</td>';
$strTable .= '</tr>';
foreach($arr as $key=>$val)
{
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['order_no'].' </td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['username'].' </td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['tel'].'</td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['start_time'].' </td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['seatnum'].' </td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['name'].' </td>';
$strTable .= '</tr>';
}
$strTable .='</table>';
//echo '123';
$reportObj = new PHPExcel();
$reportObj->setFileName('demo');
$reportObj->toDownload($strTable);
$arr=\Yii::$app->exam->createCommand("select * from `order` INNER JOIN movie on `order`.movie_id=
$strTable ='<table width="500" border="1">';
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="150px">订单</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">姓名</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">电话</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">预约时间</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">预约座位</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">预约电影</td>';
$strTable .= '</tr>';
foreach($arr as $key=>$val)
{
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['order_no'].' </td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['username'].' </td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['tel'].'</td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['start_time'].' </td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['seatnum'].' </td>';
$strTable .= '<td style="text-align:center;font-size:12px;">'.$val['name'].' </td>';
$strTable .= '</tr>';
}
$strTable .='</table>';
//echo '123';
$reportObj = new PHPExcel();
$reportObj->setFileName('demo');
$reportObj->toDownload($strTable);
//model里引用
<?php
namespace frontend\models;
//include $_SERVER['D3OCUMENT_ROOT'].'/PHPExcel/EXCEL/PHPExcel.php';
// include 'E:\www\WWW\advanced\common\widgets\PHPExcel\EXCEL\PHPExcel\Writer\Excel2007.php';
use yii\base\Model;
/**
* This is the model class for table "country".
*
* @property string $code
* @property string $name
* @property integer $population
*/
class PHPExcel extends Model
{
//文件名
private $fileName = 'user';
//构造函数
public function __construct($fileName = '')
{
$this->setFileName($fileName);
}
//设置要导出的文件名
public function setFileName($fileName)
{
$this->fileName = $fileName;
}
//开始下载
public function toDownload($strTable)
{
header("Content-type: application/vnd.ms-excel");
header("Content-Type: application/force-download");
header("Content-Disposition: attachment; filename=".$this->fileName."_".date('Y-m-d').".xls");
header('Expires:0');
header('Pragma:public');
echo '<html><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />'.$strTable.'</html>';
}
}
namespace frontend\models;
//include $_SERVER['D3OCUMENT_ROOT'].'/PHPExcel/EXCEL/PHPExcel.php';
// include 'E:\www\WWW\advanced\common\widgets\PHPExcel\EXCEL\PHPExcel\Writer\Excel2007.php';
use yii\base\Model;
/**
* This is the model class for table "country".
*
* @property string $code
* @property string $name
* @property integer $population
*/
class PHPExcel extends Model
{
//文件名
private $fileName = 'user';
//构造函数
public function __construct($fileName = '')
{
$this->setFileName($fileName);
}
//设置要导出的文件名
public function setFileName($fileName)
{
$this->fileName = $fileName;
}
//开始下载
public function toDownload($strTable)
{
header("Content-type: application/vnd.ms-excel");
header("Content-Type: application/force-download");
header("Content-Disposition: attachment; filename=".$this->fileName."_".date('Y-m-d').".xls");
header('Expires:0');
header('Pragma:public');
echo '<html><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />'.$strTable.'</html>';
}
}
