dsrbb20862 2015-10-29 02:04
浏览 74

DOMPDF创建大型PDF时计时

I'm using DOMPDF with Laravel 5 to generate PDFs from some of my views. It works well on everything except one where it keeps timing out. The code I am using for this view is exactly the same as what I'm using for another which works fine except this one returns more results. I've tried increasing the timeout limit but this didn't help.

Just wondering if anyone has any ideas on how to fix this? I found a few results online but they are all quite old and most of them were a bug with nested tables.

$TheDate = Request::input('TheDate');
    $contractor_results = DB::table('contractors')
    ->where('CurrentEmployee', '=', 1)
    ->get();
    $employee_results = DB::table('current_employees')
    ->where('CurrentEmployee', '=', 1)
    ->get();

    $sortResults = array_merge($contractor_results, $employee_results);
    $sortResults = collect($sortResults);
    $contractors = $sortResults->sortBy(function($sortResults){
        return sprintf('%-12s%s', $sortResults->SURNAME, $sortResults->NAME);
    });

    $Departments = DepartmentCode::where('ShowOnSheet', 1)
        ->orderBy('Sort', 'ASC')
        ->get();

   $pdf = PDF::loadView('attendance.contractor_sheet', compact('contractors', 'TheDate', 'Departments'))->setPaper('a4')->setOrientation('portrait');
    return $pdf->stream('SignonSheet.pdf');

Edited to add code. If I render the view as normal without going to a PDF it works without any issues.

Thanks for your help.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 对于相关问题的求解与代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
    • ¥15 保护模式-系统加载-段寄存器
    • ¥15 电脑桌面设定一个区域禁止鼠标操作
    • ¥15 求NPF226060磁芯的详细资料
    • ¥15 使用R语言marginaleffects包进行边际效应图绘制