site\modules\dashboard\modules\ap_amazon\views\default\index.php

 

<?php
use yii\helpers\Html;
use yii\grid\GridView;
?>
<?= Html::a('Добавить', ['#/add'], ['class' => 'btn btn-primary']) ?>
<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        'id',
        'ASIN',
        'name',
        'name_rus',
        'trnslate',
        'profit',
        'margin',
        'price',
        ['class' => 'yii\grid\ActionColumn'],
    ],
]); ?>

 

site\models\scamazon\Products.php

 

<?php

namespace app\models\scamazon;

/**
 *
 * @property string 	$ASIN
 * @property integer 	id
 * @property string	 	name
 * @property string	 	name_rus
 * @property string	 	trnslate
 * @property string	 	profit
 * @property string	 	margin
 * @property string	 	cost
 * @property string	 	$price
 * @property string 	$created_at
 * @property string 	$updated_at
 *
 */

class Products extends \yii\db\ActiveRecord
{
    public static function getDb()
    {
        return \Yii::$app->get('db_rawdata');
    }

    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'sc_amazon_products';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [];
    }

}

 

 

site\modules\dashboard\modules\ap_amazon\controllers\DefaultController.php

 

 

<?php

namespace app\modules\dashboard\modules\ap_amazon\controllers;

use yii\helpers\ArrayHelper;
use yii\web\Controller;
use yii\filters\AccessControl;
use yii\data\ActiveDataProvider;




use app\models\scamazon\Products;


class DefaultController extends Controller
{
	public function init(){
		parent::init();
		\Yii::$app->language = 'en-US';
	}

    /**
     * {@inheritdoc}
     */
    public function behaviors()
    {
        return [
            'access' => [
                'class' => AccessControl::class,
                //'only' => ['logout'],
                'rules' => [
                    [
                        //'actions' => ['logout'],
                        'allow' => true,
                        'roles' => ['@'],           //Только авторизованный
                    ],
                ],
            ],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function actions()
    {
        return [
            'error' => [
                'class' => 'yii\web\ErrorAction',
            ],
        ];
    }

    /**
     *
     * @return string
     */
	public function actionIndex()
	{
		if (\Yii::$app->request->isGet) {

		} elseif (\Yii::$app->request->isPost) {

		}
	}

	public function actionUpdate() {

	}

    public function actionScAmazonProducts()
    {

        $query = Products::find();
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
                'pageSize' => 100,
            ],
        ]);
        return $this->render('index', [
            'dataProvider' => $dataProvider,
        ]);
 
    }

}

 

info url :: https://p0vidl0.info/yii2-razbiraemsya-s-gridview.html