modularsoftware / genealogy

app/Family.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use LaravelEnso\People\Models\Person;

This use statement conflicts with another class in this namespace, App\Person. Consider defining an alias.

// use App\Person;
use LaravelEnso\Tables\Traits\TableCache;

class Family extends Model
{
    use TableCache;
    // public function __construct(Array $attributes = [])
    // {
    //     parent::__construct($attributes);
    //     $db = \Session::get('db');
    //     error_log('+++Family++++++++++++++++++++++++++++++++'.$db);
    //     if(empty($db)) {
    //         $db = env('DB_DATABASE', 'enso');
    //     }
    //     if($db === env('DB_DATABASE')) {
    //         $key = 'database.connections.mysql.database';
    //         config([$key => $db]);
    //     } else {
    //         $key = 'database.connections.mysql.database';
    //         config([$key => $db]);
    //     }
    //     \DB::purge('mysql');
    //     \DB::reconnect('mysql');
    //     $this->setConnection('mysql');
    //     error_log('-----------------------------------'.$this->getConnection()->getDatabaseName());
    // }
    protected $fillable = ['description', 'is_active', 'husband_id', 'wife_id', 'type_id', 'chan', 'nchi', 'rin'];

    protected $attributes = ['is_active' => false];

    protected $casts = ['is_active' => 'boolean'];

    public function events()
    {
        return $this->hasMany(FamilyEvent::class);
    }

    public function children()
    {
        return $this->hasMany(Person::class, 'child_in_family_id');
    }

    public function husband()
    {
        return $this->hasOne(Person::class, 'id', 'husband_id');
    }

    public function wife()
    {
        return $this->hasOne(Person::class, 'id', 'wife_id');
    }

    public function title()
    {
        return (($this->husband) ? $this->husband->fullname() : '?').
            ' + '.
            (($this->wife) ? $this->wife->fullname() : '?');
    }

    public static function getList()
    {
        $families = self::get();
        $result = [];
        foreach ($families as $family) {
            $result[$family->id] = $family->title();
        }

        return collect($result);
    }

    public function addEvent($title, $date, $place, $description = '')
    {
        $place_id = Place::getIdByTitle($place);
        $event = FamilyEvent::updateOrCreate(
            [
                'family_id' => $this->id,
                'title' => $title,
            ],
            [
                'family_id' => $this->id,
                'title' => $title,
                'description' => $description,
            ]);
        if ($date) {
            $event->date = $date;
            $event->save();
        }
        if ($place) {
            $event->places_id = $place_id;
            $event->save();
        }
    }

    public function getWifeName()
    {
        if ($this->wife) {
            return $this->wife->fullname();
        } else {
            return 'unknown woman';
        }
    }

    public function getHusbandName()
    {
        if ($this->husband) {
            return $this->husband->fullname();
        } else {
            return 'unknown man';
        }
    }
}