protected function processServiceStatements($business, $date, $services)
{
$changed = false;
foreach ($services as $serviceSlug => $statements) {
$service = Service::where('slug', $serviceSlug)->get()->first();
if ($service === null) {
continue;
}
$vacancy = $business->vacancies()->forDate(Carbon::parse($date))->forService($service);
if ($vacancy) {
$vacancy->delete();
}
$changed |= $this->processStatements($business, $date, $service, $statements);
}
return $changed;
}
public static function getFirstServiceOfBranch($branch_id)
{
return Service::where('branch_id', '=', $branch_id)->first();
}
protected function processServiceStatements($business, $date, $services)
{
$changed = false;
foreach ($services as $serviceSlug => $statements) {
$service = Service::where('slug', $serviceSlug)->get()->first();
if ($service === null) {
// Invalid services are skipped to avoid user frustration.
// TODO: Still, a user-level WARNING should be raised with no fatal error
continue;
}
$vacancy = $business->vacancies()->forDate(Carbon::parse($date))->forService($service);
if ($vacancy) {
$vacancy->delete();
}
$changed |= $this->processStatements($business, $date, $service, $statements);
}
return $changed;
}
private function _covenant($society, $blank = "false")
{
$pdf = new Fpdf();
$soc = Society::find($society);
if (!$blank) {
$households = Household::with('individual')->where('society_id', '=', $society)->orderBy('sortsurname')->get();
if ($soc->logo == "") {
$logopath = base_path() . '/public/images/defaultlogo.jpg';
} else {
$logopath = base_path() . '/public/images/defaultlogo.jpg';
}
} else {
$individual = (object) ['firstname' => 'Name:', 'surname' => '', 'memberstatus' => 'member', 'title' => '', 'birthdate' => '', 'cellphone' => '', 'email' => '', 'giving' => '', 'group' => array()];
$individuals[] = $individual;
$individuals[] = $individual;
$individuals[] = $individual;
$household = (object) ['addressee' => 'Household:', 'addr1' => '', 'addr2' => '', 'addr3' => '', 'post1' => '', 'post2' => '', 'post3' => '', 'homephone' => '', 'householdcell' => '', 'individual' => $individuals];
$households[] = $household;
}
$churchname = $soc->society . " Methodist Church";
foreach ($households as $household) {
$pg = 1;
$pdf->AddPage('P');
$pdf->SetAutoPageBreak(0, 0);
$pdf->SetFont('Arial', 'B', 12);
$pdf->text(10, 10, utf8_decode($household->addressee));
$pdf->SetFont('Arial', '', 11);
$pdf->rect(48, 12, 152, 7);
$pdf->text(10, 17, "Physical Address");
if ($household->addr1) {
$addr = $household->addr1;
if ($household->addr2) {
$addr = $addr . ", " . $household->addr2;
if ($household->addr3) {
$addr = $addr . ", " . $household->addr3;
}
}
$pdf->text(50, 17, $addr);
}
$pdf->rect(48, 21, 152, 7);
$pdf->text(10, 26, "Postal Address");
if ($household->addr1) {
$paddr = $household->post1;
if ($household->post2) {
$paddr = $paddr . ", " . $household->post2;
if ($household->post3) {
$paddr = $paddr . ", " . $household->post3;
}
}
$pdf->text(50, 26, $paddr);
}
$pdf->text(10, 35, "Home phone");
$pdf->rect(48, 30, 152, 7);
$pdf->text(10, 44, "Church SMSes go to");
$pdf->rect(48, 40, 152, 7);
$pdf->text(50, 35, substr($household->homephone, 0, 3) . " " . substr($household->homephone, 3, 4) . " " . substr($household->homephone, 7, 3));
if ($household->householdcell != 0 and Individual::where('id', '=', $household->householdcell)->exists()) {
$pdf->text(50, 45, Individual::find($household->householdcell)->firstname);
}
$yy = 54;
foreach ($household->individual as $indiv) {
if ($indiv->memberstatus == "child") {
$threshold = 270;
} else {
$threshold = 210;
}
if ($yy > $threshold) {
$pg++;
$pdf->AddPage('P');
$pdf->SetFont('Arial', 'B', 11);
$pdf->text(10, 10, utf8_decode($household->addressee) . " - page " . $pg);
$yy = 18;
$pdf->SetFont('Arial', '', 11);
}
$starty = $yy;
$pdf->SetFont('Arial', 'B', 11);
$pdf->text(10, $yy, $indiv->title . " " . utf8_decode($indiv->firstname) . " " . utf8_decode($indiv->surname));
$pdf->SetFont('Arial', '', 11);
$pdf->text(100, $yy, "Date of birth");
$pdf->rect(123, $yy - 5, 8, 7);
$pdf->rect(132, $yy - 5, 25, 7);
$pdf->rect(158, $yy - 5, 20, 7);
if ($indiv->birthdate != "0000-00-00" and $indiv->birthdate != "") {
$pdf->text(125, $yy, date("d", strtotime($indiv->birthdate)));
$pdf->text(134, $yy, date("F", strtotime($indiv->birthdate)));
if (substr($indiv->birthdate, 0, 4) != "1900" and substr($indiv->birthdate, 0, 4) != "") {
$pdf->text(163, $yy, date("Y", strtotime($indiv->birthdate)));
} else {
$pdf->SetFont('Arial', '', 7);
$pdf->setxy(178, $yy - 5.2);
$pdf->multicell(23, 2, "Please include year of birth - this is helpful for worship planning");
}
} else {
$pdf->SetFont('Arial', '', 7);
$pdf->setxy(178, $yy - 5.2);
$pdf->multicell(23, 2, "Please include year of birth - this is helpful for worship planning");
}
$pdf->SetFont('Arial', '', 11);
$yy = $yy + 9;
$pdf->text(10, $yy, "Cellphone");
$pdf->rect(48, $yy - 5, 50, 7);
$pdf->text(50, $yy, substr($indiv->cellphone, 0, 3) . " " . substr($indiv->cellphone, 3, 4) . " " . substr($indiv->cellphone, 7, 3));
$pdf->text(100, $yy, "Email");
$pdf->rect(111, $yy - 5, 89, 7);
$pdf->text(113, $yy, $indiv->email);
$yy = $yy + 9;
$pdf->text(10, $yy, "I would like to be considered as a: ");
$pdf->rect(72, $yy - 4, 6, 6);
$pdf->text(80, $yy, "member");
$pdf->rect(102, $yy - 4, 6, 6);
$pdf->text(110, $yy, "non-member");
$pdf->rect(138, $yy - 4, 6, 6);
$pdf->text(146, $yy, "child");
if ($indiv->memberstatus == "child") {
$pdf->text(140, $yy, "X");
}
$pdf->rect(162, $yy - 4, 6, 6);
$pdf->text(170, $yy, "youth");
if ($indiv->memberstatus == "youth") {
$pdf->text(164, $yy, "X");
}
$yy = $yy + 3;
if (strtolower($indiv->memberstatus) != "child") {
$adultgroups = array();
$pdf->rect(10, $yy, 38, 45);
$pdf->image(base_path() . '/public/images/serve.png', 32, $yy + 30, 14, 14);
$pdf->rect(48, $yy, 38, 45);
$pdf->image(base_path() . '/public/images/worship.png', 70, $yy + 30, 14, 14);
$pdf->rect(86, $yy, 38, 45);
$pdf->image(base_path() . '/public/images/learn.png', 108, $yy + 30, 14, 14);
$pdf->rect(124, $yy, 38, 45);
$pdf->image(base_path() . '/public/images/give.png', 147, $yy + 30, 14, 14);
$pdf->rect(162, $yy, 38, 45);
$pdf->image(base_path() . '/public/images/connect.png', 184, $yy + 30, 14, 14);
$adultgroups['service'] = "";
$adultgroups['course'] = "";
$adultgroups['fellowship'] = "";
$adultgroups['worship'] = "";
$pdf->SetFont('Arial', '', 8);
// Giving
$pdf->setxy(124, $yy);
if ($indiv->giving == 0) {
$pdf->multicell(38, 4, "I do not have a planned giving number.");
$pdf->rect(125, $yy + 9, 5, 5);
$pdf->text(132, $yy + 12, "Please send me info");
$pdf->rect(125, $yy + 15, 5, 5);
$pdf->text(132, $yy + 18, "Please sign me up");
} else {
$pdf->multicell(38, 4, "I am a planned giver and have a PG number.");
$pdf->rect(125, $yy + 9, 5, 5);
$pdf->text(132, $yy + 12, "But I can't remember it!");
$pdf->rect(125, $yy + 15, 5, 5);
$pdf->setxy(131, $yy + 16);
$pdf->multicell(30, 4, "I have not been receiving a quarterly acknowledgement of my planned giving offerings");
}
foreach ($indiv->group as $group) {
if ($group->grouptype != "admin") {
$adultgroups[$group->grouptype] = $adultgroups[$group->grouptype] . $group->groupname . ", ";
}
}
//Service
$pdf->setxy(10, $yy);
$pdf->SetFont('Arial', 'B', 8);
if ($adultgroups['service']) {
$pdf->multicell(38, 3, "Current: " . substr($adultgroups['service'], 0, strlen($adultgroups['service']) - 2));
}
$pdf->SetFont('Arial', '', 8);
$pdf->setxy(10, $pdf->gety());
$pdf->multicell(38, 3, "I'm interested in getting involved in: ");
// Worship
$pdf->setxy(48, $yy);
$services = Service::where('society_id', '=', $soc->id)->get();
if (count($services) > 1) {
$pdf->multicell(38, 4, "The service I usually attend is:");
$yadd = 0;
foreach ($services as $service) {
$pdf->rect(60, $yy + 9 + $yadd, 5, 5);
$pdf->text(67, $yy + 12 + $yadd, $service->servicetime);
$yadd = $yadd + 7;
}
} else {
$pdf->text(58, $yy + 6, $services[0]->servicetime . " service");
}
// Courses
$pdf->setxy(86, $yy);
$courses = Group::where('society_id', '=', $soc->id)->where('groupname', 'like', date('Y') . "%")->where('grouptype', '=', 'course')->get();
if (count($courses)) {
$pdf->multicell(38, 4, "I am interested in doing a course this year:");
$yadd = 0;
foreach ($courses as $course) {
$pdf->rect(87, $yy + 9 + $yadd, 5, 5);
$pdf->text(93, $yy + 12 + $yadd, substr($course->groupname, 4));
$yadd = $yadd + 7;
}
} else {
$pdf->multicell(38, 4, "I would love to do a course this year. I am interested in:");
}
//Groups
$pdf->setxy(162, $yy);
if ($adultgroups['fellowship']) {
$pdf->SetFont('Arial', 'B', 8);
$pdf->multicell(38, 4, "Current group: " . substr($adultgroups['fellowship'], 0, -2));
$pdf->SetFont('Arial', '', 8);
} else {
$groups = Group::where('society_id', '=', $soc->id)->where('groupname', 'like', date('Y') . "%")->where('grouptype', '=', 'fellowship')->get();
if (count($groups)) {
$pdf->multicell(38, 4, "I would like to join a small group:");
$yadd = 0;
foreach ($groups as $group) {
$pdf->rect(163, $yy + 9 + $yadd, 5, 5);
$pdf->text(169, $yy + 12 + $yadd, substr($group->groupname, 4));
$yadd = $yadd + 7;
}
} else {
$pdf->multicell(38, 4, "I would like to join a small group - please send more info.");
}
}
$yy = $yy + 3;
$yy = $yy + 48;
$pdf->rect(9, $starty - 6, 192, $yy - $starty + 1);
} else {
$allgroups = "";
foreach ($indiv->group as $group) {
$allgroups = $allgroups . $group->groupname . ", ";
}
$pdf->SetFont('Arial', '', 8);
$pdf->text(10, $yy + 2, substr($allgroups, 0, -2));
$yy = $yy + 6;
$pdf->rect(9, $starty - 6, 192, $yy - $starty + 3);
$yy = $yy + 2;
}
$yy = $yy + 2;
}
}
$pdf->Output();
exit;
}
public function index()
{
return view('home.index', ['services' => Service::where('on_the_home', 1)->orderBy('weight')->get(), 'portfolios' => Portfolio::where('on_the_home', 1)->orderBy('weight')->get()]);
}
public static function createBusinessNewTerminal($business_id, $name)
{
$first_branch = Branch::where('business_id', '=', $business_id)->first();
$first_service = Service::where('branch_id', '=', $first_branch->branch_id)->first();
$terminal = new Terminal();
$terminal->name = $name;
$terminal->service_id = $first_service->service_id;
$terminal->status = 1;
$terminal->box_rank = Terminal::generateBoxRank($first_service->service_id);
// Added by PAG
$terminal->save();
}
