<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Votes;

class APIResolutionsController extends Controller
{

    public function apiResolutionOne(){

        $data = Votes::query()->whereNotNull('approval_of_final_dividend')->whereRaw("approval_of_final_dividend <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionTwo(){

        $data = Votes::query()->whereNotNull('ebenezer_twum_asante')->whereRaw("ebenezer_twum_asante <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionThree(){

        $data = Votes::query()->whereNotNull('modupe_agbolade_kadri')->whereRaw("modupe_agbolade_kadri <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionFour(){

        $data = Votes::query()->whereNotNull('fatima_daniels')->whereRaw("fatima_daniels <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionFive(){

        $data = Votes::query()->whereNotNull('approval_of_directors_remuneration')->whereRaw("approval_of_directors_remuneration <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionSix(){

        $data = Votes::query()->whereNotNull('authorization_of_directors')->whereRaw("authorization_of_directors <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionSeven(){

        $data = Votes::query()->whereNotNull('resolution7')->whereRaw("resolution7 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionEight(){

        $data = Votes::query()->whereNotNull('resolution8')->whereRaw("resolution8 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionNine(){

        $data = Votes::query()->whereNotNull('resolution9')->whereRaw("resolution9 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionTen(){

        $data = Votes::query()->whereNotNull('resolution10')->whereRaw("resolution10 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionEleven(){

        $data = Votes::query()->whereNotNull('resolution11')->whereRaw("resolution11 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionTwelve(){

        $data = Votes::query()->whereNotNull('resolution12')->whereRaw("resolution12 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionThirteen(){

        $data = Votes::query()->whereNotNull('resolution13')->whereRaw("resolution13 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionFourteen(){

        $data = Votes::query()->whereNotNull('resolution14')->whereRaw("resolution14 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionFifteen(){

        $data = Votes::query()->whereNotNull('resolution15')->whereRaw("resolution15 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

    public function apiResolutionSixteen(){

        $data = Votes::query()->whereNotNull('resolution16')->whereRaw("resolution16 <> ''")
            ->get()->toArray();
        return response()->json($data);
    }

}