stagfe2/app/Models/Point.php

<?php

namespace App\Models;

# use Illuminate\Database\Eloquent\Model;

class Point extends Model
{
    protected $table = 'point';

    public function childReviews()
    {
        return $this->hasMany(Point::class, 'parent_point_id', 'id')
            ->where('category', 'REVIEW')
            ->orderBy('created_at', 'DESC');
    }

    public function childReviewAddedInNote($_note)
    {
        $review = Point::where('added_in_note_id', $_note->id)
            ->where('category', 'REVIEW')
            ->where('parent_point_id', $this->id)
            ->orderBy('created_at', 'DESC')
            ->first();
        if(!!$review) {
            $review->data = json_decode($review->data);
        }
        return $review;
    }

    public function childPlanAddedInNote($_note)
    {
        $review = Point::where('added_in_note_id', $_note->id)
            ->where('category', 'PLAN')
            ->where('parent_point_id', $this->id)
            ->orderBy('created_at', 'DESC')
            ->first();
        if(!!$review) {
            $review->data = json_decode($review->data);
        }
        return $review;
    }

    public function lastChildReview()
    {
        return $this->hasOne(Point::class, 'id', 'last_child_review_point_id');
    }

    public function lastChildReviewNote()
    {
        return $this->hasOne(Note::class, 'id', 'last_child_review_point_scoped_note_id');
    }

    public function childPlans()
    {
        return $this->hasMany(Point::class, 'parent_point_id', 'id')
            ->where('category', 'PLAN')
            ->orderBy('created_at', 'DESC');
    }

    public function lastChildPlan()
    {
        return $this->hasOne(Point::class, 'id', 'last_child_plan_point_id');
    }

    public function lastChildPlanNote()
    {
        return $this->hasOne(Note::class, 'id', 'last_child_plan_point_scoped_note_id');
    }

    public function client()
    {
        return $this->hasOne(Client::class, 'id', 'client_id');
    }

    public function note()
    {
        return $this->hasOne(Note::class, 'id', 'added_in_note_id');
    }

    public function relevanceToNote($_note) {
        return NotePoint
            ::where('is_active', true)
            ->where('note_id', $_note->id)
            ->where('point_id', $this->id)
            ->first();
    }

    public static function getGlobalSingletonOfCategory(Client $_patient, String $_category, $_assoc = false) {
        $point = Point
            ::where('client_id', $_patient->id)
            ->where('category', $_category)
            ->orderBy('created_at', 'DESC')
            ->first();
        if ($point && @$point->data) {
            $point->data = json_decode($point->data, $_assoc);
        }
        return $point;
    }

    public static function getIntakePointsOfCategory(Client $_patient, String $_category, Note $_note, $_assoc = false) {
        $points = Point
            ::where('client_id', $_patient->id)
            ->where('category', $_category)
            ->where('is_removed_due_to_entry_error', false)
            ->where(function ($query1) use ($_note) {
                $query1
                    ->where('addition_reason_category', 'ON_INTAKE')
                    ->orWhere(function ($query2) use ($_note) {
                        $query2->where('addition_reason_category', 'DURING_VISIT')
                            ->where('added_in_note_id', '<>', $_note->id);
                    });
            })
            ->where(function ($query1) use ($_note) {
                $query1
                    ->where('is_removed', false)
                    ->orWhere(function ($query2) use ($_note) {
                        $query2->where('is_removed', true)
                            ->where('removed_in_note_id', $_note->id);
                    });
            })
            ->orderBy('created_at')
            ->get();
        foreach ($points as $point) {
            if ($point->data) {
                $point->data = json_decode($point->data, $_assoc);
            }
        }
        return $points;
    }

    public static function getPlanPointsOfCategory(Client $_patient, String $_category, Note $_note, $_assoc = false) {
        $points = Point
            ::where('client_id', $_patient->id)
            ->where('category', $_category)
            ->where('is_removed_due_to_entry_error', false)
            ->where(function ($query1) use ($_note) {
                $query1
                    ->where('is_removed', false)
                    ->orWhere(function ($query2) use ($_note) {
                        $query2->where('is_removed', true)
                            ->where('removed_in_note_id', $_note->id);
                    });
            })
            ->orderBy('created_at')
            ->get();
        foreach ($points as $point) {
            if ($point->data) {
                $point->data = json_decode($point->data, $_assoc);
            }
        }
        return $points;
    }

    public static function getPointsOfCategory(Client $_patient, String $_category, $_assoc = false) {
        $points = Point
            ::where('client_id', $_patient->id)
            ->where('category', $_category)
            ->where('is_removed', false)
            ->orderBy('created_at')
            ->get();
        foreach ($points as $point) {
            if ($point->data) {
                $point->data = json_decode($point->data, $_assoc);
            }
        }
        return $points;
    }
}