/**
* 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>
