تالار گفتمان nCIS.ir

SELECT `p`.* FROM `catproject` `cp`
LEFT JOIN `category` `c` ON `cp`.`cid`=`c`.`id`
LEFT JOIN `product` `p` ON `cp`.`pid`=`p`.`id`
WHERE (`c`.`title`='Android')
ORDER BY `cp`.`pid` DESC
LIMIT 1

$posts = Posts::find()
    ->joinWith('categories', true)
    ->where(['category.title' => 'Android'])
    ->all();

$project = frontendmodelsProject::find()
        ->joinWith('catprojects', true)
       ->where(['category.name' => 'اندروید'])
       ->all();

نقل قول:

Column not found: 1054 Unknown column 'category.name' in 'where clause'
The SQL being executed was: SELECT `project`.* FROM `project` LEFT JOIN `catproject` ON `project`.`id` = `catproject`.`project_id` WHERE `category`.`name`='اندروید'

public function getCatprojects()
    {
       return $this->hasMany(Catproject::className(), ['project_id' => 'id']);
   }

public function getCat()
    {
       return $this->hasOne(Category::className(), ['id' => 'cat_id']);
   }

public function getProject()
    {
       return $this->hasOne(Project::className(), ['id' => 'project_id']);
   }

public function getCatprojects()
    {
       return $this->hasMany(Catproject::className(), ['cat_id' => 'id']);
   }

$project = frontendmodelsProject::find()
        ->joinWith('catprojects', true)
        ->leftJoin('category','`category`.`id`=`catproject`.`cat_id`')
        ->where(['category.name' => $name])
        ->orderBy('id DESC')
        ->limit(1)
        ->all();