/** * Lists all DiaryNutrition models. * @return mixed */ public function actionIndex() { $model = new DiaryNutrition(); if ($model->load(Yii::$app->request->post())) { $model->member_id = Yii::$app->getUser()->id; if ($model->save()) { return $this->redirect(['index']); } } $dataProvider = new ActiveDataProvider(['query' => DiaryNutrition::find()->where(['member_id' => Yii::$app->getUser()->id])->select(["DATE_FORMAT(created_at,'%m-%d-%Y') as c, created_at, id"])->groupBy(['c'])->orderBy('c DESC'), 'pagination' => ['pageSize' => 5, 'validatePage' => false]]); return $this->render('index', ['dataProvider' => $dataProvider, 'model' => $model]); }
<?php use yii\helpers\Html; use yii\grid\GridView; use yii\data\ActiveDataProvider; use frontend\models\DiaryNutrition; $diaryDate = date('m-d-Y', strtotime($model->created_at)); $dataProvider = new ActiveDataProvider(['query' => DiaryNutrition::find()->where(['=', "DATE_FORMAT(created_at,'%m-%d-%Y')", $diaryDate])->andWhere(['member_id' => Yii::$app->getUser()->id])->orderBy('created_at ASC')]); ?> <div class="diary-item"> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'summary' => $diaryDate == date('m-d-Y') ? Yii::t('frontend', 'Today') : $diaryDate, 'columns' => [['attribute' => 'created_at', 'label' => Yii::t('frontend', 'Time'), 'format' => ['date', 'php:H:i']], ['attribute' => 'value', 'label' => Yii::t('frontend', 'Meal')], 'comment', ['class' => 'yii\\grid\\ActionColumn', 'visible' => false, 'template' => '']]]); ?> </div>