public function delete_info_page() { $id = Request::segment(4); Information::where('id', $id)->delete(); return Redirect::to("/admin/informations"); }
$info = Information::where('type', '=', 'contact')->get(); foreach ($info as $key => $value) { echo '<b>' . ucfirst($value['keyname']) . ': </b>'; echo $value['value'] . '<br/>'; } ?> </p> </div> <!-- Footer stay connected --> <div class="col-footer col-md-3 col-xs-6"> <h3>Stay Connected</h3> <ul class="footer-stay-connected no-list-style"> <?php $info = Information::where('type', '=', 'link')->get(); foreach ($info as $key => $value) { echo '<li> <a href="' . $value['value'] . '" class="' . $value['keyname'] . '" ></a></li>'; } ?> </ul> </div> </div> <!-- All Rights Reserved --> <div class="row"> <div class="col-md-12"> <div class="footer-copyright">© All rights reserved.</div> </div> </div> </div>
public function monthly($res, $id) { $dt = DateTime::createFromFormat('!m', $id); $fpdf = new Fpdf(); $fpdf->AddPage('L'); $fpdf->SetFont('Arial', 'B', 16); $fpdf->Cell(130); $fpdf->Cell(20, 10, Information::where('keyname', '=', 'name')->first()->value, 0, 1, 'C'); $fpdf->Cell(130); $fpdf->SetFont('Arial', '', 14); $fpdf->Cell(20, 10, Information::where('keyname', '=', 'address')->first()->value, 0, 1, 'C'); $header = array('ID', 'Date', 'Pax', 'Status', 'Amount', 'Payment Method', 'Duration'); $fpdf->SetFont('Arial', 'B', 16); $fpdf->Cell(130); $fpdf->Cell(20, 10, 'Monthly Report for the Month of: ' . $dt->format('F'), 0, 1, 'C'); // Colors, line width and bold font $fpdf->SetFillColor(255, 0, 0); $fpdf->SetTextColor(255); $fpdf->SetDrawColor(128, 0, 0); $fpdf->SetLineWidth(0.3); $fpdf->SetFont('', ''); // Header $fpdf->Ln(); $fpdf->Cell(10); $w = array(35, 25, 25, 45, 23, 50, 55); for ($i = 0; $i < count($header); $i++) { $fpdf->Cell($w[$i], 7, $header[$i], 1, 0, 'C', true); } $fpdf->Ln(); // Color and font restoration $fpdf->SetFillColor(224, 235, 255); $fpdf->SetTextColor(0); $fpdf->SetFont('Arial', '', 12); // Data $fill = false; $total = 0; foreach ($res as $row) { $fpdf->Cell(10); $fpdf->Cell($w[0], 6, $row->id, 'LR', 0, 'L', $fill); $fpdf->Cell($w[1], 6, $row->date_request, 'LR', 0, 'L', $fill); $fpdf->Cell($w[2], 6, $row->pax, 'LR', 0, 'R', $fill); $fpdf->Cell($w[3], 6, $row->status, 'LR', 0, 'R', $fill); $fpdf->Cell($w[4], 6, $row->net_total, 'LR', 0, 'R', $fill); if ($row->payment_mode != '') { $fpdf->Cell($w[5], 6, $row->payment_mode . " (" . $row->payment_method . ")", 'LR', 0, 'L', $fill); } else { $fpdf->Cell($w[5], 6, 'Payment Method not set', 'LR', 0, 'L', $fill); } $fpdf->Cell($w[6], 6, $row->reservation_start . ' to ' . $row->reservation_end, 'LR', 0, 'L', $fill); $fpdf->Ln(); $fill = !$fill; $total = +$row->net_total; } // Closing line $fpdf->Cell(10); $fpdf->Cell(array_sum($w), 0, '', 'T'); $fpdf->Ln(); $fpdf->Cell(190); $fpdf->SetFont('Arial', 'B', 13); $fpdf->Cell(40, 7, 'Total:', '', 0, 'R'); $fpdf->SetFont('Arial', '', 13); $fpdf->Cell(40, 7, "{$total}", 0); $fpdf->Output(); exit; }