I'm trying to generate a pdf file according to the amount of products that are needed.
$html2pdf->writeHTML($this->render($template, array(
'offerte' => $offerte,
'customer' => $customer
))->getContent());
try {
$html2pdf->output();
} catch (Html2PdfException $e) {
}
in the html.twig file i loop through the amount of objects inside my $offerte object. but when my objects exceed the page height , i get a 502 bad gateway crash. So when i have like 1 table row it works just fine, but when i have like 40 rows and it's bigger than 1 pdf page it keeps loading and crashes. After checking the logs there's a maximum execution error :
request.CRITICAL: Uncaught PHP Exception Symfony\Component\Debug\Exception\FatalErrorException: "Error: Maximum execution time of 30 seconds exceeded" at /var/www/todo-symfony/vendor/tecnickcom/tcpdf/tcpdf.php line 7776 {"exception":"[object] (Symfony\Component\Debug\Exception\FatalErrorException(code: 0): Error: Maximum execution time of 30 seconds exceeded at /var/www/todo-symfony/vendor/tecnickcom/tcpdf/tcpdf.php:7776)"} []
is there a way to start a new page when i'm having too much table rows on 1 page , or is this error there for another reason?
my html.twig template file that is getting loaded :
<page backtop="7mm" backbottom="7mm" backleft="10mm" backright="10mm">
<page_header>
<img class="banner" src="img/cue/offerte_header.JPG"/><br>
<div class="row customer_info">
<table>
<tbody>
<tr>
<td width="90">Naam :</td>
<td width="225">{{ customer.firstName }} {{ customer.lastName }}</td>
<td width="90">Lever adres :</td>
<td width="225">{{ offerte.deliveryaddress }} {{ offerte.postcode }} {{ offerte.place }}</td>
</tr>
<tr>
<td width="90">Adres :</td>
<td width="225">{{ customer.address }} {{ customer.postcode }} {{ customer.place }}</td>
<td width="90">Lever datum :</td>
<td width="225">{{ offerte.deliverydate|date("d/m/Y") }}</td>
</tr>
<tr>
<td>Telefoon :</td>
<td>{{ customer.phone }}</td>
</tr>
</tbody>
</table>
</div>
<table class="data_table" width="780px">
<col width="50">
<col width="505">
<col width="50">
<col width="50">
<col width="50">
<thead>
<tr>
<th align="center" class="data_table">Code</th>
<th align="center" class="data_table">Omschrijving</th>
<th align="center" class="data_table">Aantal</th>
<th align="center" class="data_table">Prijs</th>
<th align="center" class="data_table">Totaal</th>
</tr>
</thead>
<tbody>
{% set totaal = 0 %}
{% for object in offerte.objects %}
<tr>
<td class="data_table">{{ object.code }}</td>
<td class="data_table"><pre>{{ object.omschrijving }}</pre></td>
<td class="data_table">{{ object.aantal }}</td>
<td class="data_table">€ {{ object.prijs }}</td>
<td class="data_table">€ {{ object.totaal }}</td>
{#{% set totaal = totaal + object.totaal %}#}
</tr>
{% endfor %}
<tr>
<td></td>
<td></td>
<td colspan="2" align="right" class="left-center">Subtotaal</td>
<td class="data_table_foot">€ {{ totaal }} </td>
</tr>
<tr>
<td></td>
<td></td>
<td colspan="2" align="right" class="left-center">Korting</td>
<td class="data_table_foot">{{ offerte.korting }} %</td>
</tr>
<tr>
<td></td>
<td colspan="3" align="right" class="left-center">Opbouw/afbouw + transport</td>
<td class="data_table_foot">€ {{ offerte.extracost }} </td>
</tr>
<tr>
<td></td>
<td colspan="3" align="right" class="left-center">BTW</td>
<td class="data_table_foot">{{ offerte.btw }} %</td>
</tr>
<tr>
<td></td>
<td colspan="3" align="right" class="left-center">Totaal</td>
{#{% set h1 = totaal - (totaal / 100 * offerte.korting) %}#}
{#{% set h2 = h1 + offerte.extracost %}#}
{#{% set h3 = h2 + (h2 / 100 * offerte.btw) %}#}
<td class="data_table_foot">€ {{ h3|round(2) }} </td>
</tr>
</tbody>
</table>
</page_header>
<page_footer>
<img class="bannerfooter" src="img/cue/offerte_footer.JPG"/><br>
</page_footer>