?>
</td>
<td><?php
echo $row->date_booking;
?>
</td>
<td><?php
echo $row->number_of_days;
?>
Days</td>
<td><?php
echo $row->date_booking_to;
?>
</td>
<td><?php
echo CountService($row->id) + CountRoom($row->id);
?>
</td>
<td><?php
echo Total($row->id);
?>
</td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
</div>
</div>
?>
</td>
<td><?php
echo $row->booking_code;
?>
</td>
<td><?php
echo $row->date_booking;
?>
</td>
<td><?php
echo $row->date_booking_to;
?>
</td>
<td><?php
echo CountService($row->id);
?>
</td>
<td><?php
echo CountRoom($row->id);
?>
</td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
</div>
</div>
public function getPayments()
{
$first_date = Input::get('first_date');
$last_date = Input::get('last_date');
$submit = Input::get('submit');
$page = Input::get('page');
if (isset($first_date) && isset($last_date)) {
$data = Bookings::where('date_booking', '>=', $first_date)->where('date_booking', '<=', $last_date)->paginate(10);
} else {
$data = Bookings::orderBy('id', 'desc')->paginate(10);
}
if (isset($submit) && $submit == 'print') {
if (isset($page)) {
$no = $page * 10 - 9;
} else {
$no = 1;
}
$pdf = App::make('dompdf');
$html = '<center><b>Report of Financial</b></center>';
$html .= '<br><br><br>';
$html .= '<table border="1" align="center" width="100%" padding="0" cellpadding="5">';
$html .= '<tr>';
$html .= '<td>No</td>';
$html .= '<td>Booking Code</td>';
$html .= '<td>Date Booking</td>';
$html .= '<td>Date Expired</td>';
$html .= '<td>Service & Room Count</td>';
$html .= '<td>Total</td>';
$html .= '</tr>';
foreach ($data as $row) {
$temp = CountService($row->id) + CountRoom($row->id);
$html .= '<tr>';
$html .= '<td>' . $no . '</td>';
$html .= '<td>' . $row->booking_code . '</td>';
$html .= '<td>' . $row->date_booking . '</td>';
$html .= '<td>' . $row->date_booking_to . '</td>';
$html .= '<td>' . $temp . '</td>';
$html .= '<td>' . Total($row->id) . '</td>';
$html .= '</tr>';
$no++;
}
$html .= '</table>';
$pdf->loadHTML($html)->setPaper('a4')->setOrientation('potrait');
return $pdf->download('Report Of Financial.pdf');
} else {
return View::make('home/dashboard', array())->nest('content', 'payments/report', array('data' => $data));
}
}
