public function getReport()
{
/* $campaignid = Request::segment(3);
$datefrom = Request::segment(4);
$dateto = Request::segment(5);
$bankchosen = Request::segment(6);
*/
$campaignid = Input::get('campaignid');
$datefrom = Input::get('datefrom');
$dateto = Input::get('dateto');
$bankchosen = Input::get('bankchosen');
$donate = new Donations();
if ($bankchosen == "All") {
$report = $donate->getAllReports($campaignid, $dateto, $datefrom);
} else {
$report = $donate->getReports($campaignid, $dateto, $datefrom, $bankchosen);
}
$stringreport = "";
$amount = "";
if ($report) {
foreach ($report as $data) {
$amount += $data->amountdonated;
$stringreport .= "<tr class='append-tr'><td><small class='font'><strong>" . $data->datedonated . "</strong></small></td><td><small class='font'><strong>" . $data->username . "</strong></small></td><td><small class='font'><strong>" . $data->userbankname . "</strong></small></td><td><small class='font'><strong>" . $data->bankaccount . "</strong></small></td><td><small class='font'><strong>" . $data->amountdonated . "</strong></small></td></tr>";
}
$stringreport .= "<tr class='append-tr'><td colspan='4' style='text-align:right;'><small class='font'><strong>Total Amount Donated:</small></strong></td><td><small class'font'><strong>P" . number_format($amount) . ".00</strong></small></td></tr>";
} else {
$stringreport = '<tr class="append-tr"><td colspan="5">No result found.</td></tr>';
// $stringreport = "null";
}
return $stringreport;
}
