PHP app\models Activity::tableName Exemples

Exemple #1

Fichier : ActivityUsers.php Projet : hanxiao84322/coach_system

 public static function getActivityInfoById($id = '')
 {
     $result = Yii::$app->db->createCommand('SELECT *,au.status as user_status FROM  ' . self::tableName() . ' au LEFT JOIN ' . Activity::tableName() . ' a ON au.activity_id = a.id WHERE au.activity_id=:id', [':id' => $id])->queryOne();
     return $result;
 }