Getting ActiveQuery instead of array in Yii2 ActiveRecord

Question

I have this ActiveQuery that should return an array:

$logData = VisitorLog::find()
            ->select($reportMetaHash[$selectedType]['select'])
            ->from("visitor_log v");


        foreach($reportMetaHash[$selectedType]['joins'] as $join){

            $logData->join($join['type'],$join['table'],$join['on']);

        }

        $logData->where(['=', 'v.app_id' , $app_id])
            ->andWhere(['=', 'assorted_id' , $selectedType])
            ->andWhere(['>=', 'access_time', $app->start_date])
            ->andWhere('assorted_id IN ('.$selectedType.')')
            ->groupBy("v.access_log_id, v.content_id")
            ->orderBy('b.booth_name, u.`first_name`')
            ->asArray()
            ->all();

        echo '<pre>'; print_r($logData); exit;

This return and ActiveQuery object instead of an expected array.

But when i add the joins without the loop, like below, i get an array, as expected.

$logData = VisitorLog::find()
            ->select($reportMetaHash[$selectedType]['select'])
            ->from("visitor_log v")
            ->join("JOIN", "user u", "u.`app_id`=".$app_id." AND u.id = v.access_log_id AND u.`user_type_id`=8")
            ->join("JOIN", "document d", "d.doc_id = v.`content_id` AND d.`doctypeId` = 1")
            ->join("JOIN", "booths b", "b.booth_id = d.booth_id")
            ->where(['=','v.app_id' , $app_id])
            ->andWhere(['=', 'assorted_id' , $selectedType])
            ->andWhere(['>=', 'access_time', $app->start_date])
            ->andWhere('assorted_id IN ('.$selectedType.')')
            ->groupBy("v.`access_log_id`, v.content_id")
            ->orderBy('b.booth_name, u.`first_name`')
            ->asArray()
            ->all();

The chaining should work in the loop just as it does without it i think. What am i doing wrong here?

PS: When i run the the same raw query in SQL it returns correct resultset.

rob006 · Accepted Answer · 2018-05-11 20:18:02Z

2

Query result is returned by all() call - this method does not modify query object, it just returns the results. You should pass its result to variable:

$result = $logData->where(['=', 'v.app_id' , $app_id])
    ->andWhere(['=', 'assorted_id' , $selectedType])
    ->andWhere(['>=', 'access_time', $app->start_date])
    ->andWhere('assorted_id IN ('.$selectedType.')')
    ->groupBy("v.access_log_id, v.content_id")
    ->orderBy('b.booth_name, u.`first_name`')
    ->asArray()
    ->all();

echo '<pre>'; print_r($result); exit;

edited May 11, 2018 at 20:18

answered May 10, 2018 at 7:44

rob006

22.3k5 gold badges57 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting ActiveQuery instead of array in Yii2 ActiveRecord

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related