iao_team/app/Http/Livewire/Member.php

<?php

namespace App\Http\Livewire;

use Livewire\Component;
use Livewire\Attributes\Url;
use Livewire\WithFileUploads;

use DateTime;

class Member extends Component
{

    use WithFileUploads;

    public $records, $first_name, $last_name, $image, $image_old, $status, $birth_place, $birth_city_id, $birth_province_id, $birth_nation_id, $birth_date, $gender, $fiscal_code, $address, $zip_code, $nation_id, $province_id, $city_id, $phone, $email, $enabled, $dataId, $update = false, $add = false;

    public $father_name, $mother_name, $father_email, $mother_email, $father_phone, $mother_phone, $father_fiscal_code, $mother_fiscal_code;

    public $selectId = 0;

    public $causalId = 0;

    public $under18 = false;

    public $multipleIds = [];
    public $multipleAction = '';

    public $isItaly = true;
    public $isBirthItaly = true;

    public $showDetail = false;

    public $currentMember;

    public $age = '';

    public $cards = array();
    public $categories = array();
    public $nations = array();
    public $provinces = array();
    public $cities = array();

    public $searchTxt;
    public $search;
    public $showReset = false;

    public $advanced = false;

    public $birthNations = array();
    public $birthProvinces = array();
    public $birthCities = array();

    public $active;

    // Card data
    public $member_cards = array(), $card_card_id, $card_number, $card_date, $card_accept_date, $card_status, $addCard, $updateCard, $cardDataId;

    // Categories data
    public $member_categories = array(), $category_category_id;

    // Certificates data
    public $member_certificates = array(), $certificate_type, $certificate_filename_old, $certificate_filename, $certificate_expire_date, $certificate_status, $addCertificate, $updateCertificate, $certificateDataId;

    protected $rules = [
        'first_name' => 'required',
        'last_name' => 'required',
    ];

    public function resetFields(){
        $this->dataId = -1;
        $this->first_name = '';
        $this->last_name = '';
        $this->status = '';
        $this->birth_city_id = null;

        //$this->birth_province_id = null;
        //$this->birth_nation_id = null;
        $this->birth_province_id = 178;
        $this->birth_nation_id = 1;

        $this->birth_date = null;
        $this->birth_place = '';
        $this->father_name = '';
        $this->mother_name = '';
        $this->father_email = '';
        $this->mother_email = '';
        $this->father_phone = '';
        $this->mother_phone = '';
        $this->father_fiscal_code = '';
        $this->mother_fiscal_code = '';
        $this->gender = '';
        $this->fiscal_code = '';
        $this->address = '';
        $this->zip_code = '';

        //$this->nation_id = null;
        //$this->province_id = null;
        $this->nation_id = 1;
        $this->province_id = 178;

        $this->city_id = null;
        $this->phone = '';
        $this->email = '';
        $this->enabled = true;
        $this->under18 = false;
        $this->image = null;
    }

    public function resetCardFields(){
        $this->card_card_id = null;
        $this->card_number = '';
        $this->card_date = null;
        $this->card_accept_date = null;
        $this->card_status = 0;
    }

    public function resetCertificateFields(){
        $this->certificate_type = '';
        $this->certificate_filename = '';
        $this->certificate_filename_old = '';
        $this->certificate_expire_date = null;
        $this->certificate_status = 0;
    }

    public function executeMultipleAction(){

        if ($this->multipleAction == 'delete')
            $this->multipleDelete();

    }

    public function updatedImage()
    {
        $this->validate([
            'image' => 'image|max:1024',
        ]);
        $this->image_old = '';
    }


    public function resetCategoryFields(){
        $this->category_category_id = null;
    }

    public function getCategories($records, $indentation)
    {
        foreach($records as $record)
        {
            // $this->categories[] = array('id' => $record->id, 'name' => str_repeat(" / ", $indentation) . $record->name);
            $this->categories[] = array('id' => $record->id, 'name' => $record->getTree());
            if(count($record->childs))
                $this->getCategories($record->childs, $indentation + 1);
        }
    }

    public function updatedBirthDate()
    {
        $date1 = new DateTime($this->birth_date);
        $date2 = new DateTime("now");
        $interval = $date1->diff($date2);
        $this->age = $interval->y . " anni";
        $this->under18 = $interval->y < 18;
    }

    public function mount()
    {

        if (isset($_GET["new"]))
            $this->add();

        $this->cards = \App\Models\Card::select('id', 'name')->get();

        $this->categories = array();

        $this->getCategories(\App\Models\Category::select('id', 'name')->where('parent_id', null)->get(), 0);

        $this->nations = \App\Models\Nation::select('id', 'name')->orderBy('name')->get();
        $this->provinces = \App\Models\Province::where('nation_id', 1)->orderBy('name')->get();
        $this->cities = \App\Models\City::where('province_id', 178)->orderBy('name')->orderBy('name')->get();

        $c = \App\Models\Causal::where('type', 'IN')->where('money', true)->first();
        if ($c)
            $this->causalId = $c->id;

        $this->birthNations = \App\Models\Nation::select('id', 'name')->orderBy('name')->get();
        //$this->birthProvinces = array();
        //$this->birthCities = array();
        $this->birthProvinces = \App\Models\Province::where('nation_id', 1)->orderBy('name')->get();
        $this->birthCities = \App\Models\City::where('province_id', 178)->orderBy('name')->orderBy('name')->get();
    }

    public function updated()
    {
        $this->emit('load-select');
    }

    public function hydrate()
    {
        $this->emit('load-select');
    }

    public function loadProvinces()
    {
        $n = \App\Models\Nation::findOrFail($this->nation_id);
        $this->isItaly = $n->is_italy;
        $this->provinces = \App\Models\Province::where('nation_id', $this->nation_id)->orderBy('name')->get();
        $this->cities = array();
        $this->selectId++;
    }

    public function loadCities()
    {
        $this->cities = \App\Models\City::where('province_id', $this->province_id)->orderBy('name')->orderBy('name')->get();
        $this->selectId++;
    }

    public function loadBirthProvinces()
    {
        $n = \App\Models\Nation::findOrFail($this->birth_nation_id);
        $this->isBirthItaly = $n->is_italy;
        $this->birthProvinces = \App\Models\Province::where('nation_id', $this->birth_nation_id)->orderBy('name')->get();
        $this->birthCities = array();
        $this->selectId++;
    }

    public function loadBirthCities()
    {
        $this->birthCities = \App\Models\City::where('province_id', $this->birth_province_id)->get();
        $this->selectId++;
    }

    public function search()
    {
        if ($this->searchTxt != '')
        {
            $this->search = $this->searchTxt;
            $this->showReset = true;
        }
    }
    public function resetSearch()
    {
        $this->showReset = false;
        $this->searchTxt = '';
        $this->search = $this->searchTxt;
    }

    public function advancedSearch()
    {
        $this->avanced = true;

    }

    public function render()
    {

        if (!$this->advanced)
        {
            if ($this->search != '')
                $this->records = \App\Models\Member::where('first_name', 'LIKE', '%' . $this->search . '%')->orWhere('last_name', 'LIKE', '%' . $this->search . '%')->orWhere('email', 'LIKE', '%' . $this->search . '%')->get();
            else
                $this->records = \App\Models\Member::get();
        }
        else
        {
            $this->records = \App\Models\Member::where('id', '>', 0);

            $this->records = $this->records->get();
        }


        //$this->records = $this->records->get();
        $this->loadMemberCards();
        $this->loadMemberCategories();
        $this->loadMemberCertificates();
        return view('livewire.member');
    }

    public function loadMemberCards()
    {
        $this->member_cards = \App\Models\MemberCard::where('member_id', $this->dataId)->get();
        // return view('livewire.member');
    }

    public function loadMemberCategories()
    {
        $this->member_categories = \App\Models\MemberCategory::where('member_id', $this->dataId)->get();
        // return view('livewire.member');
    }

    public function loadMemberCertificates()
    {
        $this->member_certificates = \App\Models\MemberCertificate::where('member_id', $this->dataId)->get();
        // return view('livewire.member');
    }

    public function showDetail($id)
    {
        $this->currentMember = \App\Models\Member::findOrFail($id);
        $this->showDetail = true;
    }

    public function add()
    {
        $this->emit('load-select');
        $this->showDetail = false;
        $this->resetFields();
        $this->add = true;
        $this->update = false;
    }

    public function store($close)
    {
        $this->emit('load-select');
        $this->validate();
        try {

            $name = '';
            if ($this->image)
            {
                $name = md5($this->image . microtime()).'.'.$this->image->extension();
                $this->image->storeAs('public', $name);
            }

            $member = \App\Models\Member::create([
                'first_name' => $this->first_name,
                'last_name' => $this->last_name,
                'status' => $this->status,
                'birth_city_id' => $this->birth_city_id,
                'birth_province_id' => $this->birth_province_id,
                'birth_nation_id' => $this->birth_nation_id,
                'birth_date' => $this->birth_date,
                'birth_place' => $this->birth_place,
                'father_name' => $this->father_name,
                'mother_name' => $this->mother_name,
                'father_email' => $this->father_email,
                'mother_email' => $this->mother_email,
                'father_phone' => $this->father_phone,
                'mother_phone' => $this->mother_phone,
                'father_fiscal_code' => $this->father_fiscal_code,
                'mother_fiscal_code' => $this->mother_fiscal_code,
                'gender' => $this->gender,
                'fiscal_code' => $this->fiscal_code,
                'address' => $this->address,
                'zip_code' => $this->zip_code,
                'nation_id' => $this->nation_id,
                'province_id' => $this->province_id,
                'city_id' => $this->city_id,
                'phone' => $this->phone,
                'email' => $this->email,
                'image' => $name,
                'enabled' => $this->enabled
            ]);
            session()->flash('success, Tesserato creato');
            $this->resetFields();
            if ($close)
            {
                $this->add = false;
            }
            else
            {
                $this->edit($member->id);
            }
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function duplicate($id){
        $member = \App\Models\Member::findOrFail($id);
        $newMember = $member->replicate();
        $newMember->save();
        $this->edit($newMember->id);
    }

    public function edit($id){
        $this->showDetail = false;
        $this->emit('load-select');
        try {
            $member = \App\Models\Member::findOrFail($id);
            if( !$member) {
                session()->flash('error','Tesserato non trovato');
            } else {
                $this->first_name = $member->first_name;
                $this->last_name = $member->last_name;
                $this->status = $member->status;
                $this->birth_city_id = $member->birth_city_id;
                $this->birth_province_id = $member->birth_province_id;
                $this->birth_nation_id = $member->birth_nation_id;
                $this->birth_date = $member->birth_date;
                $this->birth_place = $member->birth_place;
                $this->father_name = $member->father_name;
                $this->mother_name = $member->mother_name;
                $this->father_email = $member->father_email;
                $this->mother_email = $member->mother_email;
                $this->father_phone = $member->father_phone;
                $this->mother_phone = $member->mother_phone;
                $this->father_fiscal_code = $member->father_fiscal_code;
                $this->mother_fiscal_code = $member->mother_fiscal_code;
                $this->gender = $member->gender;
                $this->fiscal_code = $member->fiscal_code;
                $this->address = $member->address;
                $this->zip_code = $member->zip_code;
                $this->nation_id = $member->nation_id;
                $this->province_id = $member->province_id;
                $this->city_id = $member->city_id;
                $this->phone = $member->phone;
                $this->email = $member->email;
                $this->image_old = $member->image;
                $this->enabled = $member->enabled;
                $this->dataId = $member->id;
                $this->active = $member->isActive();
                $this->provinces = \App\Models\Province::where('nation_id', $this->nation_id)->get();
                $this->cities = \App\Models\City::where('province_id', $this->province_id)->get();
                $this->birthProvinces = \App\Models\Province::where('nation_id', $this->birth_nation_id)->get();
                $this->birthCities = \App\Models\City::where('province_id', $this->birth_province_id)->get();
                $this->update = true;
                $this->add = false;
            }
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function update($close)
    {
        $this->emit('load-select');
        $this->validate();
        try {

            $name = '';
            if ($this->image)
            {
                $name = md5($this->image . microtime()).'.'.$this->image->extension();
                $this->image->storeAs('public', $name);
            }

            \App\Models\Member::whereId($this->dataId)->update([
                'first_name' => $this->first_name,
                'last_name' => $this->last_name,
                'status' => $this->status,
                'birth_city_id' => $this->birth_city_id,
                'birth_province_id' => $this->birth_province_id,
                'birth_nation_id' => $this->birth_nation_id,
                'birth_date' => $this->birth_date,
                'birth_place' => $this->birth_place,
                'father_name' => $this->father_name,
                'mother_name' => $this->mother_name,
                'father_email' => $this->father_email,
                'mother_email' => $this->mother_email,
                'father_phone' => $this->father_phone,
                'mother_phone' => $this->mother_phone,
                'father_fiscal_code' => $this->father_fiscal_code,
                'mother_fiscal_code' => $this->mother_fiscal_code,
                'gender' => $this->gender,
                'fiscal_code' => $this->fiscal_code,
                'address' => $this->address,
                'zip_code' => $this->zip_code,
                'nation_id' => $this->nation_id,
                'province_id' => $this->province_id,
                'city_id' => $this->city_id,
                'image' => $name != '' ? $name : $this->image_old,
                'phone' => $this->phone,
                'email' => $this->email,
                'enabled' => $this->enabled
            ]);
            session()->flash('success','Tesserato aggiornato');
            if ($close)
            {
                $this->resetFields();
                $this->update = false;
            }
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function cancel()
    {
        $this->add = false;
        $this->update = false;
        $this->showDetail = false;
        $this->resetFields();
    }

    public function delete($id)
    {
        try{
            \App\Models\Member::find($id)->delete();
            session()->flash('success',"Tesserato eliminato");
        }catch(\Exception $e){
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function multipleDelete()
    {
        try{
            foreach($this->multipleIds as $id)
            {
                \App\Models\Member::find($id)->delete();
            }
        }catch(\Exception $e){
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
        $this->multipleAction = '';
    }

    // Card

    public function addCard()
    {
        $this->resetCardFields();
        $this->addCard = true;
        $this->updateCard = false;
    }

    public function storeCard()
    {

        $this->validate(['card_card_id' => 'required']);
        try {
            // in base alla card selezionata calcolo la scadenza
            $expire_date = null;
            if ($this->card_date != '')
            {
                $card = \App\Models\Card::findOrFail($this->card_card_id);
                if ($card->next_day_expire > 0 && $card->next_month_expire > 0)
                {
                    $m = strlen($card->next_month_expire) == 1 ? ('0' . $card->next_month_expire) : $card->next_month_expire;
                    $next_exp = date("Y-" . $m . "-" . $card->next_day_expire);

                    if ($next_exp > $this->card_date)
                    {
                        $expire_date = $next_exp;
                    }
                    else
                        $expire_date = date("Y-" . $card->next_month_expire . "-" . $card->next_day_expire, strtotime(' + 1 years'));
                }
            }
            \App\Models\MemberCard::create([
                'member_id' => $this->dataId,
                'card_id' => $this->card_card_id,
                'number' => $this->card_number,
                'date' => $this->card_date,
                'accept_date' => $this->card_accept_date,
                'expire_date' => $expire_date,
                'status' => $this->card_status
            ]);
            session()->flash('success, Tesserato creato');
            $this->resetCardFields();
            $this->addCard = false;
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function editCard($id){
        try {
            $memberCard = \App\Models\MemberCard::findOrFail($id);
            if( !$memberCard) {
                session()->flash('error','Tesserato non trovato');
            } else {
                $this->card_card_id = $memberCard->card_id;
                $this->card_number = $memberCard->number;
                $this->card_date = $memberCard->date;
                $this->card_accept_date = $memberCard->accept_date;
                $this->card_status = $memberCard->status;
                $this->cardDataId = $memberCard->id;
                $this->updateCard = true;
                $this->addCard = false;
            }
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function updateCard()
    {
        //$this->validate();
        $this->validate(['card_card_id' => 'required']);
        try {

            // in base alla card selezionata calcolo la scadenza
            $expire_date = null;
            if ($this->card_date != '')
            {
                $card = \App\Models\Card::findOrFail($this->card_card_id);
                if ($card->next_day_expire > 0 && $card->next_month_expire > 0)
                {
                    $m = strlen($card->next_month_expire) == 1 ? ('0' . $card->next_month_expire) : $card->next_month_expire;
                    $next_exp = date("Y-" . $m . "-" . $card->next_day_expire);

                    if ($next_exp > $this->card_date)
                    {
                        $expire_date = $next_exp;
                    }
                    else
                        $expire_date = date("Y-" . $card->next_month_expire . "-" . $card->next_day_expire, strtotime(' + 1 years'));

                }
            }

            \App\Models\MemberCard::whereId($this->cardDataId)->update([
                'member_id' => $this->dataId,
                'card_id' => $this->card_card_id,
                'number' => $this->card_number,
                'date' => $this->card_date,
                'accept_date' => $this->card_accept_date,
                'expire_date' => $expire_date,
                'status' => $this->card_status
            ]);
            session()->flash('success','Tesserato aggiornato');
            $this->resetCardFields();
            $this->updateCard = false;
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function cancelCard()
    {
        $this->addCard = false;
        $this->updateCard = false;
        $this->resetCardFields();
    }

    public function deleteCard($id)
    {
        try{
            \App\Models\MemberCard::find($id)->delete();
            session()->flash('success',"Tesserato eliminato");
        }catch(\Exception $e){
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    // Certificates

    public function addCertificate()
    {
        $this->resetCertificateFields();
        $this->addCertificate = true;
        $this->updateCertificate = false;
    }

    public function storeCertificate()
    {

        $this->validate(['certificate_expire_date' => 'required']);
        // $this->validate();
        try {

            $name = '';
            try{

                if ($this->certificate_filename)
                {
                    $name = md5($this->certificate_filename . microtime()).'.'.$this->certificate_filename->extension();
                    $this->certificate_filename->storeAs('public', $name);
                }
            } catch (\Exception $ex) {
                //session()->flash('error','Errore (' . $ex->getMessage() . ')');
            }

            if ($this->dataId > -1)
            {
                \App\Models\MemberCertificate::create([
                    'member_id' => $this->dataId,
                    'type' => $this->certificate_type,
                    'filename' => $name,
                    'expire_date' => $this->certificate_expire_date,
                    'status' => $this->certificate_status
                ]);
            }
            /*else
            {
                $this->certificateTmp = new \App\Models\MemberCertificate();
                $this->certificateTmp->type = $this->certificate_type;
                $this->certificateTmp->filename = $name;
                $this->certificateTmp->expire_date = $this->certificate_expire_date;
                $this->certificateTmp->status = $this->certificate_status;
                $this->certificateTmp->status = $this->certificate_status;
                // s    $this->member_certificates[] = $certificateTmp;
            }*/
            session()->flash('success, Tesserato creato');
            $this->resetCertificateFields();
            $this->addCertificate = false;
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function editCertificate($id){
        try {
            $memberCertificate = \App\Models\MemberCertificate::findOrFail($id);
            if( !$memberCertificate) {
                session()->flash('error','Tesserato non trovato');
            } else {
                $this->certificate_type = $memberCertificate->type;
                $this->certificate_filename_old = $memberCertificate->filename;
                $this->certificate_expire_date = $memberCertificate->expire_date;
                $this->certificate_status = $memberCertificate->status;
                $this->cardCertificateId = $memberCertificate->id;
                $this->updateCertificate = true;
                $this->addCertificate = false;
            }
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function updateCertificate()
    {
        $this->validate(['certificate_expire_date' => 'required']);
        try {

            $name = '';
            try{

                if ($this->certificate_filename)
                {
                    $name = md5($this->certificate_filename . microtime()).'.'.$this->certificate_filename->extension();
                    $this->certificate_filename->storeAs('public', $name);
                }
            } catch (\Exception $ex) {
                //session()->flash('error','Errore (' . $ex->getMessage() . ')');
            }

            \App\Models\MemberCertificate::whereId($this->cardCertificateId)->update([
                'member_id' => $this->dataId,
                'type' => $this->certificate_type,
                'filename' => $name != '' ? $name : $this->certificate_filename_old,
                'expire_date' => $this->certificate_expire_date,
                'status' => $this->certificate_status
            ]);
            session()->flash('success','Tesserato aggiornato');
            $this->resetCertificateFields();
            $this->updateCertificate = false;
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function cancelCertificate()
    {
        $this->addCertificate = false;
        $this->updateCertificate = false;
        $this->resetCertificateFields();
    }

    public function deleteCertificate($id)
    {
        try{
            \App\Models\MemberCertificate::find($id)->delete();
            session()->flash('success',"Tesserato eliminato");
        }catch(\Exception $e){
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    // Gruppi di appartenenza

    public function storeCategory()
    {

        $this->validate(['category_category_id' => 'required']);
        try {
            \App\Models\MemberCategory::create([
                'member_id' => $this->dataId,
                'category_id' => $this->category_category_id,
                'date' => \Carbon\Carbon::now()
            ]);
            session()->flash('success, Associazione creato');
            $this->resetCategoryFields();
            $this->addCard = false;
        } catch (\Exception $ex) {
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

    public function deleteCategory($id)
    {
        try{
            \App\Models\MemberCategory::find($id)->delete();
            session()->flash('success',"Associazione eliminata");
        }catch(\Exception $e){
            session()->flash('error','Errore (' . $ex->getMessage() . ')');
        }
    }

}