layui导出PHPExcle.rar

<?php use think\Controller; use app\common\library\Y; use think\Db; class PurseController extends Controller { public function PHPExcel() { $status = $this->request->post('status', -1, 'intval'); $time = input('time', '', 'trim'); $keyword = input('keyword', '', 'trim'); $list = Db::table('tx')->alias('a') ->leftJoin('user b', 'a.user_id = b.id') ->field('a.*,b.nickname,b.mobile,b.bank_card,b.bank_name,b.bank_address') ->when($time, function ($q) use ($time) { $rang_time = range_time($time); $t1 = date('Y-m-d', $rang_time[0]); $t2 = date('Y-m-d', $rang_time[1]); return $q->whereTime('create_time', 'between', [$t1, $t2]); })->when($keyword, function ($q) use ($keyword) { return $q->where('b.mobile|b.nickname', $keyword); })->when(isset($status), function ($q) use ($status) { if ($status > -1) { return $q->where('a.status', $status); } })->order('a.id', 'desc') ->select(); foreach ($list as &$value) { $card = '`' . $value['bank_card'] . '`'; $value['bank_card'] = $card; } return Y::json(1, '提现记录表', $list); } }