CAdvancedArFindBehavior.php
2.56 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
/**
* CAdvancedArFindBehavior class file.
*
* @author Rajat Singhal <rajat.developer.singhal@gmail.com>
* @link http://www.yiiframework.com/
* @version 0.0.1
*/
/* The CAdvancedArFindBehavior extension adds up some functionality to the default
* possibilites of yii´s ActiveRecord implementation.
*
* To use this extension, just copy this file to your extensions/ directory,
* add 'import' => 'application.extensions.CAdvancedArFindBehavior', [...] to your
* config/main.php and add this behavior to each model you would like to
* inherit the new possibilities:
*
* public function behaviors(){
* return array( 'CAdvancedArFindBehavior' => array(
* 'class' => 'application.extensions.CAdvancedArFindBehavior'));
* }
*
*
* This extension is useful when you need only one attribute of selected rows from database, and loading whole objects for them is not only big data pull and hense slow, but also it's more code, as you will have to traverse through all the objects and foreach of them put the required attrute's value in the array, and then proceed with it...
* With this extension you have one function similar to findAll, in which one extra attribute selects you need to provide, and it return array containing all row's values for that attribute, or attributes..
* This is a similar function to pluck of ruby on rails.
** Syntex **
* public array findColumn(string $column, mixed $condition='', array $params=array()) {}
** Things to Notice **
* `beforeFind`, `afterFind` functions will be ignored.
* Scopes will work as normal.
** Example **
$active_users_emails = User::model()->findColumn('email', 'active = 1');
**returns array('rajat@gmail.com','rajatsinghal@gmail.com')..**
*/
class CAdvancedArFindBehavior extends CActiveRecordBehavior {
public function findColumn($column, $condition='', $params=array()) {
$criteria = $this->owner->getCommandBuilder()->createCriteria($condition,$params);
$criteria->select = $column;
$this->owner->applyScopes($criteria);
$command = $this->owner->getCommandBuilder()->createFindCommand($this->owner->getTableSchema(),$criteria);
if(empty($criteria->with))
return $command->queryColumn();
else {
$finder=new CActiveFinder($this->owner, $criteria->with);
$results = $finder->query($criteria, true);
$data = array();
foreach($results as $result)
$data[] = $result[$column];
return $data;
}
}
}