ControleurRequete.php

<?php

namespace bdd\controllers;

use bdd\models\Company;
use bdd\models\Game;
use bdd\models\Platform;
use bdd\models\Character;
use bdd\models\Game2character;
use bdd\models\Game_publisher;
use bdd\views\RequeteView;

class ControleurRequete{
    public function selectMario(){
        $jeu = Game::select('name')->where('name','like','%Mario%','or','alias','like','%Mario%')->get();
              
        $vue = new RequeteView($jeu);
        $vue->render(1);
    }

    public function selectJapanCompany(){
        $company = Company::select('name')->where('location_country','like','%Japan%')->get();
        $vue = new RequeteView($company);
        $vue->render(1);

    }

    public function selectPlatformBase(){
        $platform = Platform::select('name')->where('install_base','>','10000000')->get();
        $vue = new RequeteView($platform);
        $vue->render(1);
    }

    public function selectGameNumber(){
        $game = Game::select('name')->orderBy('name')->take(442)->skip(21173)->get();
        $vue = new RequeteView($game);
        $vue->render(1);
    }
    
    public function selectPage($p){
        $p = ($p-1)*500;
        $jeu = Game::select('id','name')->orderBy('id')->take(500)->skip($p)->get();
        $vue = new RequeteView($jeu);
        $vue->render(1);
    }

    public function selectChar(){
        $data = Character::join('game2character','character.id','=','game2character.character_id')
                            ->select('id','deck')
                            ->where('game2character.game_id','=','12342');
    
        $vue = new RequeteView($data);
        $vue->render(1);
    }

    public function selectCharMario(){
        $data = Character::join('game2character','character.id','=','game2character.character_id')
                            ->join('game','game2character.game_id','=','game.id')
                            ->select('id')
                            ->where('game.name','LIKE','Mario%');
       
        $vue = new RequeteView($data);
        $vue->render(1);
    }

    public function gameCompanySony(){
        $data = Game::join('game_publisher','game.id','=','game_publisher.game_id')
                            ->join('company','game_publisher.comp_id','=','company.id')
                            ->select('id')
                            ->where('company.name','LIKE','%Sony%');
       
        $vue = new RequeteView($data);
        $vue->render(1);
    }

    
}