Qfyilyi

- sc_cours -

    idCour

    volHoraireCour

    idMat



- sc_matieres -

    idMat

    nomMat

$query->select('*')

      ->from('sc_cours')

      ->innerJoin('sc_matieres', 'sc_cours.idMat = sc_matieres.idMat');

SQLSTATE[42000]: Syntax error or access violation: 1066 Table/alias: 'sc_matieres' non unique

The SQL being executed was: SELECT * FROM `sc_cours` INNER JOIN `sc_matieres` ON sc_cours.idMat = sc_matieres.idMat INNER JOIN `sc_matieres` ON sc_cours.idMat = sc_matieres.idMat

<?php



namespace appmodels;



use Yii;



/**

 * This is the model class for table "sc_cours" => ScCours.

 *

 * @property int $idCour

 * @property string $heureDebCour

 * @property string $heureFinCour

 * @property int $jourCour

 * @property int $volHoraireCour

 * @property int $partieCour

 * @property string $semestreCour

 * @property int $sharedCour

 * @property int $idMat

 *

 * @property ScMatieres $mat

 * @property ScHoraires $scHoraires

 */

class ScCours extends yiidbActiveRecord

{

    /**

     * {@inheritdoc}

     */

    public static function tableName()

    {

        return 'sc_cours';

    }



    /**

     * {@inheritdoc}

     */

    public function rules()

    {

        return [

            [['heureDebCour', 'heureFinCour', 'jourCour', 'volHoraireCour', 'partieCour', 'semestreCour', 'sharedCour', 'idClasse', 'idMat', 'idProf', 'idSalle'], 'required'],

            [['jourCour', 'volHoraireCour', 'partieCour', 'sharedCour', 'idClasse', 'idMat', 'idProf', 'idSalle'], 'integer'],

            [['semestreCour'], 'string'],

            [['heureDebCour', 'heureFinCour'], 'string', 'max' => 255],

            [['idMat'], 'exist', 'skipOnError' => true, 'targetClass' => ScMatieres::className(), 'targetAttribute' => ['idMat' => 'idMat']],

        ];

    }



    /**

     * {@inheritdoc}

     */

    public function attributeLabels()

    {

        return [

            'idCour' => 'Id Cour',

            'heureDebCour' => 'Début Cour',

            'heureFinCour' => 'Fin Cour',

            'jourCour' => 'Jour',

            'volHoraireCour' => 'Volume Horaire',

            'partieCour' => 'Partie',

            'semestreCour' => 'Semestre',

            'sharedCour' => 'Partagé ?',

            'idMat' => 'Matière',

        ];

    }



    /**

     * @return yiidbActiveQuery

     */

    public function getMat()

    {

        return $this->hasOne(ScMatieres::className(), ['idMat' => 'idMat']);

    }



    /**

     * @return yiidbActiveQuery

     */

    public function getScHoraires()

    {

        return $this->hasMany(ScHoraires::className(), ['idCour' => 'idCour']);

    }

}

<?php

/**

 * Created by PhpStorm.

 * User: Badara

 * Date: 21/11/2018

 * Time: 02:16

 */

namespace appcomponents;



   

use appmodelsScCours;

use appmodelsScMatieres;

use Yii;

use yiibaseComponent;

use yiibaseInvalidConfigException;

use yiidbQuery;

use yiihelpersUrl;



class MyGFunctions extends Component{



    public function show($partie, $semestre){

        $request = Yii::$app->request;

        $id = $request->get('id');



        $query = new Query;

        for ($i = 1; $i <= 6; $i++){

            $query->select('*')

                ->from('sc_cours')

                ->innerJoin('sc_matieres', 'sc_cours.idMat = sc_matieres.idMat')

                ->where(['partieCour' => $partie, 'semestreCour' => $semestre, 'idClasse' => $id, 'jourCour' => $i ]);



            $cours = $query->all();

            if ($cours){

                echo "Get them"

                }

            }else{

                echo 'Get nothing';

            }

        }



    }

}