iao_team/app/Http/Livewire/CourseList.php

<?php

namespace App\Http\Livewire;

use Livewire\Component;

class CourseList extends Component
{

    public $records = array();
    public $courses = array();

    public $courseId = 0;

    public $filterCourse = [];
    public $filterLevel = [];
    public $filterFrequency = [];
    public $filterType = [];
    public $filterDuration = [];

    public $course_durations = [];
    public $course_types = [];
    public $course_frequencies = [];
    public $course_levels = [];

    public $months = array('Gen', 'Feb', 'Mar', 'Apr', 'Mag', 'Giu', 'Lug', 'Ago', 'Set', 'Ott', 'Nov', 'Dic');

    public function mount()
    {

        $this->course_types = \App\Models\CourseType::select('*')->where('enabled', true)->get();
        $this->course_durations = \App\Models\CourseDuration::select('*')->where('enabled', true)->get();
        $this->course_levels = \App\Models\CourseLevel::select('*')->where('enabled', true)->get();
        $this->course_frequencies = \App\Models\CourseFrequency::select('*')->where('enabled', true)->get();

        $this->courses = \App\Models\Course::orderBy('name')->groupBy('name')->pluck('name');

        //if (sizeof($this->courses) > 0)
        //    $this->courseId = $this->courses[0]->id;

    }

    public function render()
    {

        // Carico tutti i corsi associati
        /*
        if ($this->courseId > 0)
            $member_course = \App\Models\MemberCourse::where('course_id', $this->courseId)->with('member'); //->get();
        else
            $member_course = \App\Models\MemberCourse::with('member'); //->get();
        */
        $member_course = \App\Models\MemberCourse::with('member');
        if (sizeof($this->filterCourse) > 0)
        {
            $course_ids = [];
            foreach($this->filterCourse as $c)
            {
                $all = \App\Models\Course::where('name', 'like', '%' . $c . "%")->get();
                foreach($all as $a)
                {
                    $course_ids[] = $a->id;
                }
                //$course_ids = array_merge($course_ids, $a);
            }
            //$course_ids = \App\Models\Course::where('name', 'like', '%' . $this->filterCourse . "%")->pluck('id');
            $member_course = $member_course->whereIn('course_id', $course_ids);
        }
        if (sizeof($this->filterLevel) > 0)
        {
            $course_ids = \App\Models\Course::whereIn('course_level_id', $this->filterLevel)->pluck('id');
            $member_course = $member_course->whereIn('course_id', $course_ids);
        }
        if (sizeof($this->filterFrequency) > 0)
        {
            $course_ids = \App\Models\Course::whereIn('course_frequency_id', $this->filterFrequency)->pluck('id');
            $member_course = $member_course->whereIn('course_id', $course_ids);
        }
        if (sizeof($this->filterType) > 0)
        {
            $course_ids = \App\Models\Course::whereIn('course_type_id', $this->filterType)->pluck('id');
            $member_course = $member_course->whereIn('course_id', $course_ids);
        }
        if (sizeof($this->filterDuration) > 0)
        {
            $course_ids = \App\Models\Course::whereIn('course_duration_id', $this->filterDuration)->pluck('id');
            $member_course = $member_course->whereIn('course_id', $course_ids);
        }

        $member_course = $member_course->get();

        $this->records = array();

        foreach($member_course as $x)
        {
            $this->records[] = array(
                $x->member_id . "§" . $x->member->first_name . " " . $x->member->last_name,
                $this->getColor($x->months, 1),
                $this->getColor($x->months, 2),
                $this->getColor($x->months, 3),
                $this->getColor($x->months, 4),
                $this->getColor($x->months, 5),
                $this->getColor($x->months, 6),
                $this->getColor($x->months, 7),
                $this->getColor($x->months, 8),
                $this->getColor($x->months, 9),
                $this->getColor($x->months, 10),
                $this->getColor($x->months, 11),
                $this->getColor($x->months, 12),
                $x->course_id,
                $x->id,
            );
        }

        $this->emit('load-data-table');

        return view('livewire.course_list');

    }

    public function getColor($months, $m)
    {
        $class = "grey";
        foreach(json_decode($months) as $mm)
        {
            if ($mm->m == $m)
            {
                if ($mm->status == "")
                {
                    $class = "orange";
                }
                if ($mm->status == "1")
                {
                    $class = "green";
                }
                if ($mm->status == "2")
                {
                    $class = "yellow";
                }
            }
        }
        return $class;
    }

    public function search()
    {

    }

    public function newPayment($course_id, $month, $member_id, $id)
    {
        $c = \App\Models\Course::findOrFail($course_id);
        return redirect()->to('/in?new=1&memberId=' . $member_id . '&causalId=' . $c->causal_id . '&subCausalId=' . $c->sub_causal_id . '&createSubscription=0&months=' . $month . '&price=' . $c->price . '&subscription_price=' . $c->subscription_price . "&courseId=" . $id);

    }

}