/**
* Displays a single Members model.
* @param integer $id
* @return mixed
*/
public function actionView($id)
{
// get mapping category
//$pageModel = CmsPages::findOne(['id' => GeneralSettings::findOne(['name' => 'mapping_page_id'])->value]);
//$categoryModel = MappingCategories::findOne($pageModel->mapping_id);
$categoriesModel = MappingCategories::findAll(['is_active' => 1]);
// get questions answers
/*$questionsAnswers = new ActiveDataProvider([
'query' => $categoryModel->getQuestions()->with('questionsAnswers'),
]);*/
// get attributes Answers
/*$attributesAnswers = new ActiveDataProvider([
'query' => MembersAttributes::find($categoryModel->attributes_id)->with('attributesAnswers'),
]);*/
$weightTracker = new ActiveDataProvider(['query' => MembersWeightTracker::find(['member_id' => $id]), 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]]]);
$diaryNutritions = new ActiveDataProvider(['query' => DiaryNutrition::find()->where(['member_id' => $id])->select(["*, DATE_FORMAT(created_at,'%m-%d-%Y') as c"])->groupBy(['c']), 'pagination' => ['pageSize' => 5, 'validatePage' => false], 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]]]);
$diaryTraining = new ActiveDataProvider(['query' => DiaryTraining::find()->where(['member_id' => $id])->select(["*, DATE_FORMAT(created_at,'%m-%d-%Y') as c"])->groupBy(['c']), 'pagination' => ['pageSize' => 5, 'validatePage' => false], 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]]]);
return $this->render('view', ['model' => $this->findModel($id), 'categoriesModel' => $categoriesModel, 'weightTracker' => $weightTracker, 'diaryNutritions' => $diaryNutritions, 'diaryTraining' => $diaryTraining]);
}
<?php
use yii\helpers\Html;
use yii\grid\GridView;
use yii\data\ActiveDataProvider;
use backend\models\DiaryNutrition;
$dairyDate = date('m-d-Y', strtotime($model->created_at));
$dataProvider = new ActiveDataProvider(['query' => DiaryNutrition::find()->where(['=', "DATE_FORMAT(created_at,'%m-%d-%Y')", $dairyDate])->andWhere(['member_id' => $model->member_id])->orderBy('created_at ASC')]);
?>
<div class="dairy-item">
<div id="statusMsg"></div>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'summary' => $dairyDate == date('m-d-Y') ? Yii::t('frontend', 'Today') : $dairyDate, 'columns' => [['attribute' => 'created_at', 'label' => Yii::t('frontend', 'Time'), 'format' => ['date', 'php:H:i']], ['attribute' => 'value', 'label' => Yii::t('frontend', 'Meal')], ['attribute' => 'comment', 'format' => 'raw', 'value' => function ($data) {
return '<div id="nutrition-comment-' . $data->id . '">' . $data->comment . '</div>';
}], ['class' => 'yii\\grid\\ActionColumn', 'template' => '{update}', 'headerOptions' => ['width' => '20%', 'class' => 'activity-view-link'], 'contentOptions' => ['class' => 'padding-left-5px'], 'controller' => 'members', 'buttons' => ['update' => function ($url, $model, $key) {
return Html::a('<span class="glyphicon glyphicon-pencil"></span>', '#', ['class' => 'activity-update-link', 'title' => Yii::t('backend', 'Update Comment'), 'data-toggle' => 'modal', 'data-href' => '../members/update-nutrition-comment', 'data-target' => '#activity-modal', 'data-id' => $key, 'data-pjax' => '0']);
}]]]]);
?>
</div>
