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