public function report($dat)
{
$pdf = new Fpdf();
$pdf->AddPage('L');
$logopath = base_path() . '/public/images/logo.jpg';
$pdf->SetAutoPageBreak(true, 0);
$pdf->SetFont('Arial', '', 9);
$num_ser = 0;
foreach ($dat['societies'] as $s1) {
foreach ($s1->service as $se1) {
$num_ser++;
}
}
$header = 20;
$left_side = 5;
$left_edge = 40;
$num_soc = count($dat['societies']);
$num_sun = count($dat['sundays']);
$soc_width = $left_edge - 17;
$pg_height = 210;
$pg_width = 297;
$y = $header;
$x = $left_edge;
$y_add = ($pg_height - $header - 3 * ($num_ser - $num_soc)) / $num_ser;
$x_add = ($pg_width - 5 - $left_edge) / $num_sun;
$toprow = true;
$pdf->Image($logopath, 5, 5, 0, 21);
$pdf->SetFillColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 14);
$pdf->text($left_side + $soc_width, 10, "THE METHODIST CHURCH OF SOUTHERN AFRICA: " . strtoupper(Helpers::getSetting('circuit_name')) . " CIRCUIT " . Helpers::getSetting('circuit_number'));
$pdf->text($left_side + $soc_width, 17, "PREACHING PLAN: " . strtoupper(date("F Y", $dat['sundays'][0]['dt'])) . " - " . strtoupper(date("F Y", $dat['sundays'][count($dat['sundays']) - 1]['dt'])));
foreach ($dat['societies'] as $soc) {
$firstserv = true;
foreach ($soc->service as $ser) {
if ($firstserv) {
$y = $y + $y_add;
$pdf->SetFont('Arial', 'B', 8);
$pdf->rect($left_side, $y - 2, $pg_width - 2 * $left_side, $y_add + $y_add * (count($soc->service) - 1) - 3 * (count($soc->service) - 1), 'D');
$pdf->setxy($left_side, $y);
if (count($soc->service) == 1) {
$pdf->setxy($left_side, $y);
} else {
$pdf->setxy($left_side, $y + ($y_add - 3) * (count($soc->service) - 1) / 2);
}
$font_size = 8;
$decrement_step = 0.1;
$pdf->SetFont('Arial', 'B', $font_size);
while ($pdf->GetStringWidth($soc->society) > $soc_width - 2) {
$pdf->SetFontSize($font_size -= $decrement_step);
}
$pdf->cell($soc_width, $y_add - 3, $soc->society, 0, 0, 'R');
$pdf->SetFont('Arial', 'B', 8);
$pdf->setxy($left_side + $soc_width, $y);
$pdf->cell(12, $y_add - 3, $ser->servicetime, 0, 0, 'C');
$pdf->SetFillColor(0, 0, 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetDrawColor(0, 0, 0);
} else {
$y = $y + $y_add - 3;
$pdf->SetFont('Arial', 'B', 8);
$pdf->setxy($left_side + $soc_width, $y);
$pdf->cell(12, $y_add - 3, $ser->servicetime, 0, 0, 'C');
$pdf->SetFillColor(0, 0, 0);
$pdf->SetTextColor(0, 0, 0);
}
$firstserv = false;
foreach ($dat['sundays'] as $sun) {
if ($toprow) {
// Weekly dates
$pdf->SetFont('Arial', 'B', 8);
if (date("D", $sun['dt']) == "Sun") {
$pdf->setxy($x, $header + 2);
$pdf->cell($x_add, $y_add - 6, date("j M", $sun['dt']), 0, 0, 'C');
} else {
$wd = Weekday::where('servicedate', '=', $sun['dt'])->first();
$pdf->setxy($x, $header + 4);
$pdf->SetFont('Arial', '', 7);
$pdf->cell($x_add, $y_add - 6, $wd->description, 0, 0, 'C');
$pdf->SetFont('Arial', 'B', 8);
$pdf->setxy($x, $header);
$pdf->cell($x_add, $y_add - 6, date("j M", $sun['dt']), 0, 0, 'C');
}
}
if (isset($dat['fin'][$soc['society']][$sun['yy']][$sun['mm']][$sun['dd']][$ser->servicetime]['tname'])) {
$tagadd = 1;
$pdf->setxy($x, $y - 2);
$pdf->SetFont('Arial', 'B', 7.5);
$pdf->cell($x_add, $y_add - 2, $dat['fin'][$soc['society']][$sun['yy']][$sun['mm']][$sun['dd']][$ser->servicetime]['tname'], 0, 0, 'C');
} else {
$tagadd = 0;
}
if (isset($dat['fin'][$soc['society']][$sun['yy']][$sun['mm']][$sun['dd']][$ser->servicetime]['pname'])) {
$pdf->setxy($x, $y + $tagadd);
$pname = utf8_decode($dat['fin'][$soc['society']][$sun['yy']][$sun['mm']][$sun['dd']][$ser->servicetime]['pname']);
$font_size = 8;
$decrement_step = 0.1;
$pdf->SetFont('Arial', '', $font_size);
while ($pdf->GetStringWidth($pname) > $x_add - 1) {
$pdf->SetFontSize($font_size -= $decrement_step);
}
$pdf->cell($x_add, $y_add - 3, $pname, 0, 0, 'C');
}
$x = $x + $x_add;
}
$toprow = false;
$x = $left_edge;
}
}
$x2 = $x;
foreach ($dat['sundays'] as $sun2) {
$pdf->line($x2, $header + 8, $x2, $y + $y_add - 2);
$x2 = $x2 + $x_add;
}
$pdf->AddPage('L');
$pdf->Image($logopath, 10, 5, 0, 21);
$pdf->SetFillColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 14);
$pdf->text($left_side + $soc_width + 8, 10, "THE METHODIST CHURCH OF SOUTHERN AFRICA: " . strtoupper(Helpers::getSetting('circuit_name')) . " CIRCUIT " . Helpers::getSetting('circuit_number'));
$pdf->text($left_side + $soc_width + 8, 17, "PREACHING PLAN: " . strtoupper(date("F Y", $dat['sundays'][0]['dt'])) . " - " . strtoupper(date("F Y", $dat['sundays'][count($dat['sundays']) - 1]['dt'])));
$pfin = array();
foreach ($dat['preachers'] as $preacher1) {
$dum = array();
$thissoc = Society::find($preacher1->society_id)->society;
$dum['name'] = $preacher1->individual->title . " " . $preacher1->individual->firstname . " " . $preacher1->individual->surname;
if ($preacher1->emeritus) {
$dum['name'] = $dum['name'] . "*";
}
$dum['soc'] = $preacher1->society_id;
if ($preacher1->individual->cellphone == "") {
$dum['cellphone'] = $preacher1->individual->officephone;
} else {
$dum['cellphone'] = $preacher1->individual->cellphone;
}
$dum['fullplan'] = $preacher1->fullplan;
if ($dum['fullplan'] == "Trial") {
$vdum['9999' . $preacher1->individual->surname . $preacher1->individual->firstname] = $dum;
} else {
$vdum[$preacher1->fullplan . $preacher1->individual->surname . $preacher1->individual->firstname] = $dum;
}
}
foreach ($dat['guests'] as $guest1) {
$dum['name'] = $guest1->title . " " . $guest1->firstname . " " . $guest1->surname;
}
ksort($vdum);
foreach ($vdum as $vd) {
$thissoc = Society::find($vd['soc'])->society;
$pfin[$thissoc][] = $vd;
}
$cols = 4;
$spacer = 5;
$col_width = ($pg_width - 2 * $left_side) / $cols;
$y = 30;
$col = 1;
$pdf->SetFont('Arial', '', 8);
$pdf->text($left_side + $spacer, $y, "Presiding Bishop: " . $dat['pb']);
$y = $y + 4;
$pdf->text($left_side + $spacer, $y, "General Secretary: " . $dat['gs']);
$y = $y + 4;
$pdf->text($left_side + $spacer, $y, "District Bishop: " . $dat['db']);
$y = $y + 4;
$pdf->text($left_side + $spacer, $y, "Superintendent: " . $dat['super']->title . " " . $dat['super']->firstname . " " . $dat['super']->surname);
$y = $y + 6;
$pdf->SetFont('Arial', 'B', 11);
$pdf->text($left_side + $spacer, $y, "Circuit Ministers");
$y = $y + 4;
$pdf->SetFont('Arial', '', 8);
foreach ($dat['ministers'] as $minister) {
$mins[$minister->individual->surname . $minister->individual->firstname]['name'] = $minister->individual->title . " " . $minister->individual->firstname . " " . $minister->individual->surname . " (" . $minister->individual->cellphone . ")";
}
ksort($mins);
foreach ($mins as $min) {
$pdf->text($left_side + $spacer, $y, $min['name']);
$y = $y + 4;
}
$y = $y + 2;
$pdf->SetFont('Arial', '', 8);
$officers = explode(',', Helpers::getSetting('circuit_stewards'));
$subhead = "";
$pdf->SetFont('Arial', 'B', 11);
$pdf->text($left_side + $spacer, $y, "Circuit Stewards");
$pdf->SetFont('Arial', '', 8);
foreach ($officers as $officer) {
$y = $y + 4;
$fn = Individual::find($officer);
$pdf->text($left_side + $spacer, $y, $fn->title . " " . $fn->firstname . " " . $fn->surname . " (" . $fn->cellphone . ")");
}
$pdf->SetFont('Arial', 'B', 11);
$y = $y + 6;
$pdf->text($left_side + $spacer, $y, "Circuit Treasurer");
$pdf->SetFont('Arial', '', 8);
$treasurer = Helpers::getSetting('treasurer');
$y = $y + 4;
$fn = Individual::find($treasurer);
$pdf->text($left_side + $spacer, $y, $fn->title . " " . $fn->firstname . " " . $fn->surname . " (" . $fn->cellphone . ")");
$pdf->SetFont('Arial', 'B', 11);
$y = $y + 6;
$pdf->SetFont('Arial', 'B', 11);
$pdf->text($left_side + $spacer, $y, "Circuit Office");
$circuitoffice = Society::find(Helpers::getSetting('circuit_office'));
$pdf->SetFont('Arial', '', 8);
$y = $y + 4;
$pdf->text($left_side + $spacer, $y, $circuitoffice->society . " Methodist Church");
if ($circuitoffice->phone) {
$y = $y + 4;
$pdf->text($left_side + $spacer, $y, "Phone: " . $circuitoffice->phone);
}
if ($circuitoffice->email) {
$y = $y + 4;
$pdf->text($left_side + $spacer, $y, "Email: " . $circuitoffice->email);
}
$csecretary = Helpers::getSetting('circuit_secretary');
if ($csecretary) {
$y = $y + 4;
$pdf->SetFont('Arial', '', 8);
$fn = Individual::find($csecretary);
$pdf->text($left_side + $spacer, $y, "Secretary: " . $fn->title . " " . $fn->firstname . " " . $fn->surname);
}
$y = $y + 6;
if (count($dat['meetings'])) {
$pdf->SetFont('Arial', 'B', 11);
$pdf->text($left_side + $spacer, $y, "Circuit Meetings");
$y = $y + 4;
foreach ($dat['meetings'] as $meeting) {
$x = $left_side + $spacer + ($col - 1) * $col_width;
$pdf->SetFont('Arial', 'B', 8);
$pdf->text($x, $y, $meeting['description']);
$pdf->SetFont('Arial', '', 8);
$y = $y + 4;
$msoc = Society::find($meeting['society_id'])->society;
$pdf->text($x, $y, date("d M Y H:i", $meeting['meetingdatetime']) . " (" . $msoc . ")");
$y = $y + 4;
}
}
$y = $y + 2;
$col++;
$x = $left_side + $spacer + ($col - 1) * $col_width;
$y = 30;
$pdf->SetFont('Arial', 'B', 11);
$pdf->text($x, $y, "Local Preachers");
$supervisor = Helpers::getSetting('supervisor_of_studies');
if ($supervisor) {
$y = $y + 4;
$pdf->SetFont('Arial', '', 8);
$fn = Individual::find($supervisor);
$pdf->text($x, $y, "Supervisor of studies: " . $fn->title . " " . $fn->firstname . " " . $fn->surname);
}
$lpsec = Helpers::getSetting('local_preachers_secretary');
if ($lpsec) {
$y = $y + 4;
$pdf->SetFont('Arial', '', 8);
$fn = Individual::find($lpsec);
$pdf->text($x, $y, "Local Preachers Secretary: " . $fn->title . " " . $fn->firstname . " " . $fn->surname);
}
$y = $y + 4;
$ythresh = 200;
ksort($pfin);
foreach ($pfin as $key => $soc) {
if ($y > $ythresh - 6) {
$col++;
$y = 30;
}
$x = $left_side + $spacer + ($col - 1) * $col_width;
$pdf->SetFont('Arial', 'B', 9);
$y = $y + 2;
$pdf->text($x, $y, $key);
$y = $y + 4;
$pdf->SetFont('Arial', '', 8);
foreach ($soc as $pre) {
if ($y > $ythresh) {
$col++;
$x = $left_side + $spacer + ($col - 1) * $col_width;
$y = 30;
}
$pre['name'] = utf8_decode($pre['name']);
$pdf->text($x + 2, $y, $pre['fullplan']);
$pdf->text($x + 10, $y, $pre['name'] . " (" . $pre['cellphone'] . ")");
$y = $y + 4;
}
}
$pdf->SetFont('Arial', '', 8);
$y = $y + 4;
$pdf->text($x + 2, $y, "* Emeritus");
/*
$y=$y+8;
if (count($guest1)){
$pdf->SetFont('Arial','B',11);
$pdf->text($x,$y,"Guest Preachers");
$y=$y+2;
foreach ($guest1 as $guest){
$y=$y+4;
$pdf->text($x+10,$y,$guest['name'] . " (" . $guest['cellphone'] . ")");
}
}
*/
$pdf->Output();
exit;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$weekday = Weekday::find($id);
$weekday->delete();
return Redirect::route('weekdays.index')->with('okmessage', 'Weekday service has been deleted');
}