Home >Backend Development >PHP Tutorial >Yii - Statistical functions in relations data association_PHP tutorial
Yii - Statistical functions in relations data association_PHP tutorial
- WBOYOriginal
- 2016-07-14 10:10:00856browse
Associative query, Yii also supports so-called statistical query (or aggregate query). It refers to retrieving aggregated information about associated objects, such as the number of comments for each post, the average rating of each product, etc. Statistical queries are only performed on objects associated with HAS_MANY (for example, a post has many comments) or MANY_MANY (for example, a post belongs to many categories and a category has many posts).
Performing statistical queries is very similar to the correlation queries described previously. We first need to declare the statistical query in the relations() method of CActiveRecord.
[html]
class Post extends CActiveRecord
{
Public function relations()
{
return array(
'commentCount'=>array(self::STAT, 'Comment', 'post_id'),
'categoryCount'=>array(self::STAT, 'Category', 'post_category(post_id,category_id)'),
);
}
}
class Post extends CActiveRecord
{
Public function relations()
{
return array(
'commentCount'=>array(self::STAT, 'Comment', 'post_id'),
'categoryCount'=>array(self::STAT, 'Category', 'post_category(post_id,category_id)'),
);
}
}Associated query namespace
Related queries can also be executed with namespaces. There are two forms. In the first form, the namespace is applied to the main model. In the second form, namespaces are applied to relational models.
The code below shows how to apply a namespace to the main model.
$posts=Post::model()->published()->recently()->with('comments')->findAll();
This is very similar to a non-associative query. The only difference is that we use the with() call after the namespace. This query should return recently published posts and their comments.
The code below shows how to apply a namespace to an associated model.
$posts=Post::model()->with('comments:recently:approved')->findAll();
The above query will return all posts and their moderated comments. Note that comments refers to the association name, while recently and approved refer to the namespace declared in the Comment model class. Association names and namespaces should be separated by colons.
Namespaces can also be specified in the with option of association rules declared in CActiveRecord::relations(). In the example below, if we access $user->posts, it will return all moderated comments for this post.
[html]
class User extends CActiveRecord
{
Public function relations()
{
return array(
'posts'=>array(self::HAS_MANY, 'Post', 'author_id', 'with'=>'comments:approved'),
);
}
}
class User extends CActiveRecord
{
Public function relations()
{
return array(
'posts'=>array(self::HAS_MANY, 'Post', 'author_id', 'with'=>'comments:approved'),
);
}
}