Accessing Element Attribute In Dataprovider From Within A Foreach

aglikall · July 7, 2014, 10:17pm

Hi guys. As I’m new to Yii2 I’m stuck on a minor problem that I need help with.

Here is an action I added to my controller.

This controller finds all items in the model with the status "0"

What I’m trying to do is sum up total price on items in this particular model.

Can anyone wonderful Yii2 veteran point me in the right direction with this so I can stop scratching my hair off ?

Best Regards


public function actionLokid()

    {

        $searchModel = new InnkaupSearch;


        // Returns all records that have the status "0" in stada(stada=icelandic for Status)

        $dataProvider = $searchModel->search(['InnkaupSearch'=>['stada'=>0]]);


        $totalPrice = 0;


        //Want to sum up total price on all items in dataProvider

        foreach($dataProvider as $record) {

            // How do I access attribute value of each object/record in model <img src='http://www.yiiframework.com/forum/public/style_emoticons/default/huh.gif' class='bbc_emoticon' alt='???' />

        }


        


        return $this->render('lokid', [

            'dataProvider' => $dataProvider,

            'searchModel' => $searchModel,


            // Total price on all items in dataProvider

            'total' => $total,

        ]);

    }

amnah · July 7, 2014, 10:59pm

I recommend you read through this to understand how data providers work:

github.com

yiisoft/yii2/blob/master/docs/guide/output-data-providers.md

Data Providers
==============

In the [Pagination](output-pagination.md) and [Sorting](output-sorting.md) sections, we have described how to
allow end users to choose a particular page of data to display and sort them by some columns. Because the task
of paginating and sorting data is very common, Yii provides a set of *data provider* classes to encapsulate it.

A data provider is a class implementing [[yii\data\DataProviderInterface]]. It mainly supports retrieving paginated
and sorted data. It is usually used to work with [data widgets](output-data-widgets.md) so that end users can 
interactively paginate and sort data. 

The following data provider classes are included in the Yii releases:

* [[yii\data\ActiveDataProvider]]: uses [[yii\db\Query]] or [[yii\db\ActiveQuery]] to query data from databases
  and return them in terms of arrays or [Active Record](db-active-record.md) instances.
* [[yii\data\SqlDataProvider]]: executes a SQL statement and returns database data as arrays.
* [[yii\data\ArrayDataProvider]]: takes a big array and returns a slice of it based on the paginating and sorting
  specifications.

The usage of all these data providers share the following common pattern:

This file has been truncated. show original

Quick answer:




$models = $dataProvider->getModels();

aglikall · July 10, 2014, 7:59am

amnah:

I recommend you read through this to understand how data providers work:

https://github.com/yiisoft/yii2/blob/master/docs/guide/output-data-providers.md

Quick answer:
$models = $dataProvider->getModels(); 

I’ll take a look at this, thanks Amnah

Any chance you could dumb it down a shade for me if I run into some more trouble ?