Gecko [ gandhischool.edu.np ]

Name	Size	Permission
AboutusController.php	4.59 KB	-rw-rw-r--
AdminController.php	3.14 KB	-rw-rw-r--
AlbumController.php	7.63 KB	-rw-rw-r--
CarousellController.php	4.41 KB	-rw-rw-r--
CommitteeController.php	9.26 KB	-rw-rw-r--
CommitteeTypeController.php	4.57 KB	-rw-rw-r--
ContactPersonController.php	5.13 KB	-rw-rw-r--
MasterCommitteeController.php	3.55 KB	-rw-rw-r--
MemberController.php	15.48 KB	-rw-rw-r--
MemberTypeController.php	3.14 KB	-rw-rw-r--
NewsController.php	4.57 KB	-rw-rw-r--
NoticeController.php	4.49 KB	-rw-rw-r--
SetupController.php	3.82 KB	-rw-rw-r--
VideoController.php	4 KB	-rw-rw-r--

Code Editor : CommitteeController.php

<?php

namespace App\Http\Controllers\admin;

use App\Http\Controllers\Controller;
use App\Models\ExecutiveCommitteeTerm;
use Illuminate\Http\Request;
use App\Models\MasterCommittee;
use App\Models\Commitee;
use App\Models\Member;
use App\Models\CommitteeType;
use App\Http\Requests\CommitteRequest;

class CommitteeController extends Controller
{
    public function index()
    {
        try {
            $ec_terms = ExecutiveCommitteeTerm::where('status', 1)->first();

if ($ec_terms) {

$committee = Commitee::with('committee_types', 'members', 'master_committees', 'ec_terms')
                    ->whereIn('committee_types_id', [1])
                    ->where('status', 'active')
                    ->where('ec_terms_id', $ec_terms->id)
                    ->get()
                    ->sortBy('display_order')
                    ->sortBy('master_committees.rank');

} else {
                $committee = Commitee::with('committee_types', 'members', 'master_committees')->where('committee_types_id', 1)->where('status', 'active')->get()->sortBy('display_order')->sortBy('master_committees.rank');

}
            $inactive_committee = Commitee::with('committee_types', 'members', 'master_committees')->where('committee_types_id', 1)->where('status', 'in-active')->get()->sortBy('master_committees.rank')->sortBy('status');
            // return $committee;
            return view('admin.committee.index', compact('committee', 'inactive_committee', 'ec_terms'));
        } catch (\Exception $e) {
            return $e;
            return redirect()->back()->with('error', "Something Went Wrong");
        }
    }

public function patrons()
    {
        try {
            // $committee = Commitee::with(['committee_types','members','master_committees'=>function($q){
            //     $q->orderBy('rank','ASC');
            // }])->get();

$committee = Commitee::with('committee_types', 'members', 'master_committees')->where(['committee_types_id' => 2], ['status' => 'active'])->get()->sortBy('master_committees.rank')->sortBy('status');
            return view('admin.committee.patrons', compact('committee'));
        } catch (\Exception $e) {
            // return $e;
            return redirect()->back()->with('error', "Something Went Wrong");
        }
    }

public function advisory_board()
    {
        try {
            // $committee = Commitee::with(['committee_types','members','master_committees'=>function($q){
            //     $q->orderBy('rank','ASC');
            // }])->get();

$committee = Commitee::with('committee_types', 'members', 'master_committees')->where(['committee_types_id' => 3], ['status' => 'active'])->get()->sortBy('master_committees.rank')->sortBy('status');
            return view('admin.committee.advisory_board', compact('committee'));
        } catch (\Exception $e) {
             return $e;
            return redirect()->back()->with('error', "Something Went Wrong");
        }
    }

/**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        try {
            $committee_types = CommitteeType::all();
            $members = Member::orderBy('name')->get();
            $master_committees = MasterCommittee::orderBy('rank')->get();
            $ec_terms = ExecutiveCommitteeTerm::all();
            return view('admin.committee.create', compact('committee_types', 'members', 'master_committees', 'ec_terms'));
        } catch (\Exception $e) {
            return view('frontend.index')->with('error', "Something Went Wrong");
        }
    }
    public function create_patrons()
    {
        try {
            $committee_types = CommitteeType::all();
            $members = Member::orderBy('name')->get();
            $master_committees = MasterCommittee::orderBy('rank')->get();
            return view('admin.committee.create_patrons', compact('committee_types', 'members', 'master_committees'));
        } catch (\Exception $e) {
            return view('frontend.index')->with('error', "Something Went Wrong");
        }
    }

public function create_advisory_board()
    {
        try {
            $committee_types = CommitteeType::all();
            $members = Member::orderBy('name')->get();
            $master_committees = MasterCommittee::orderBy('rank')->get();
            return view('admin.committee.create_advisory_board', compact('committee_types', 'members', 'master_committees'));
        } catch (\Exception $e) {
            return view('frontend.index')->with('error', "Something Went Wrong");
        }
    }
    /** create_advisory_board
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(CommitteRequest $request)
    {
        try {

$input['members_id'] = $request->members_id;
            $input['master_committees_id'] = $request->master_committees_id;
            $input['committee_types_id'] = $request->committee_types_id;
            $input['start_date'] = $request->start_date;
            $input['end_date'] = $request->end_date;
            $input['remarks'] = $request->remarks;
            $input['status'] = $request->status;
            $input['display_order'] = $request->display_order;
            $input['ec_terms_id'] = $request->ec_terms_id;
            Commitee::create($input);
            return redirect()
                ->back()
                //->route('committees.index')
                ->with('success', 'Committee Member Posted Successfully');

} catch (\Exception $e) {
            // return $e;
            return redirect()
                //->route('committees.index')
                ->back()->with('error', "SomeThing Went Wrong");
        }
    }

/**
     * Display the specified resource.
     *
     * @param  \App\Models\committee  $committee
     * @return \Illuminate\Http\Response
     */
    public function show(Commitee $committee)
    {
        //
    }

/**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\committee  $committee
     * @return \Illuminate\Http\Response
     */
    public function edit(Commitee $committee)
    {
        try {
            $committee_types = CommitteeType::all();
            $members = Member::orderBy('name')->get();
            $master_committees = MasterCommittee::orderBy('rank')->get();
            $ec_terms = ExecutiveCommitteeTerm::all();
            return view('admin.committee.edit', compact('committee', 'committee_types', 'members', 'master_committees', 'ec_terms'));
        } catch (\Exception $e) {
            return redirect()->route('committees.index')->with('error', "SomeThing Went Wrong");
        }
    }

/**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\committee  $committee
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Commitee $committee)
    {
        try {
            $input['id'] = $request->id;
            $input['members_id'] = $request->members_id;
            $input['master_committees_id'] = $request->master_committees_id;
            $input['committee_types_id'] = $request->committee_types_id;
            $input['start_date'] = $request->start_date;
            $input['end_date'] = $request->end_date;
            $input['remarks'] = $request->remarks;
            $input['status'] = $request->status;
            $input['display_order'] = $request->display_order;
            $input['ec_terms_id'] = $request->ec_terms_id;
            $committee->update($input);
            return redirect()->back()
                //->route('committees.index')
                ->with('success', 'Committee updated successfully');
        } catch (\Exception $e) {
            return redirect()
                //->route('committees.index')
                ->back()
                ->with('error', 'Something Went Wrong');
        }
    }
    public function update_status(Request $request, Commitee $committee)
    {
        try {
            $input['id'] = $request->id;
            $input['start_date'] = $request->start_date;
            $input['end_date'] = $request->end_date;
            $input['status'] = $request->status;
            $input['display_order'] = $request->display_order;
            $committee->update($input);
            return redirect()->back()
                //->route('committees.index')
                ->with('success', 'Committee updated successfully');
        } catch (\Exception $e) {
            return redirect()
                //->route('committees.index')
                ->back()
                ->with('error', 'Something Went Wrong');
        }
    }

/**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\committee  $committee
     * @return \Illuminate\Http\Response
     */
    public function destroy(Commitee $committee)
    {
        try {
            $committee->delete();
            return redirect()->back()->with('success', "SuccessFully Deleted");
        } catch (\Exception $e) {
            return redirect()
                //->route('committees.index')
                ->back()
                ->with('error', 'Something Went Wrong');
        }
    }

}

${this.title}

Code Editor : CommitteeController.php