public function get_fcd($params) { $query = FeesCategoryDetails::find()->where(['fees_details_category_id' => $_REQUEST['id'], 'is_status' => 0]); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['fees_category_details_id' => $this->fees_category_details_id, 'fees_details_category_id' => $this->fees_details_category_id, 'fees_details_amount' => $this->fees_details_amount, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by, 'is_status' => $this->is_status]); $query->andFilterWhere(['like', 'fees_details_name', $this->fees_details_name])->andFilterWhere(['like', 'fees_details_description', $this->fees_details_description]); return $dataProvider; }
echo $model->isNewRecord ? 'box-success' : 'box-info'; ?> box col-xs-12 col-lg-12 no-padding"> <div class="box-header with-border"> <h3 class="box-title"><i class="fa fa-inr"></i><sub><i class="fa fa-info-circle"></i></sub> <?php echo Yii::t('fees', 'Fees Collection Category'); ?> : <?php echo $FccModel->fees_collect_name; ?> </h3> </div> <div class="box-body table-responsive"> <?php $totalAmount = $totalPay = 0; $feesDetails = \app\modules\fees\models\FeesCategoryDetails::find()->where(['fees_details_category_id' => $FccModel->fees_collect_category_id, 'is_status' => 0])->asArray()->all(); echo '<table class="table table-bordered tbl-pay-fees">'; echo '<col class="col-xs-1">'; echo '<col class="col-xs-9">'; echo '<col class="col-xs-2">'; echo '<tr>'; echo '<th class="">' . Yii::t('fees', 'SI No.') . '</th>'; echo '<th>' . Yii::t('fees', 'Fees Details') . '</th>'; echo '<th>' . Yii::t('fees', 'Amount') . '</th>'; echo '</tr>'; foreach ($feesDetails as $key => $value) { echo '<tr>'; echo '<td>' . ($key + 1) . '</td>'; echo '<td>' . $value['fees_details_name'] . '</td>'; echo '<td>' . $value['fees_details_amount'] . '</td>'; echo '</tr>';
<div class="box-header with-border"><h4 class="box-title"><i class="fa fa-inr"> </i> <?php echo Yii::t('fees', 'Current Fees Details'); ?> </h4></div> <div class="box-body table-responsive"> <?php $currFeesData = new ActiveDataProvider(['query' => $FccModel->getBatchFeesCategory($stuData->stu_master_batch_id), 'sort' => ['defaultOrder' => ['fees_collect_category_id' => SORT_DESC]], 'pagination' => ['pageSize' => 10]]); $currFeesData->sort = false; echo GridView::widget(['dataProvider' => $currFeesData, 'layout' => "{items}\n{pager}", 'showOnEmpty' => true, 'emptyText' => Yii::t('fees', 'No current fees data available.'), 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'fees_collect_name', 'fees_collect_details', ['attribute' => 'fees_collect_start_date', 'value' => function ($data) { return Yii::$app->formatter->asDate($data['fees_collect_start_date']); }], ['attribute' => 'fees_collect_end_date', 'value' => function ($data) { return Yii::$app->formatter->asDate($data['fees_collect_end_date']); }], ['attribute' => 'fees_collect_due_date', 'value' => function ($data) { return Yii::$app->formatter->asDate($data['fees_collect_due_date']); }], ['header' => 'Fees Details', 'format' => 'raw', 'value' => function ($data) { $fcdModel = \app\modules\fees\models\FeesCategoryDetails::find()->where(['is_status' => 0, 'fees_details_category_id' => $data->fees_collect_category_id])->asArray()->all(); $tmp = '<ol>'; foreach ($fcdModel as $value) { $tmp .= '<li>' . $value['fees_details_name'] . ' (' . $value['fees_details_amount'] . ') </li>'; } $tmp .= '</ol>'; return $tmp; }], ['header' => Yii::t('fees', 'Total Amount'), 'value' => function ($data) { return \app\modules\fees\models\FeesCategoryDetails::getFeeCategoryTotal($data->fees_collect_category_id); }], ['header' => Yii::t('fees', 'Total Paid Fees'), 'value' => function ($data) use($model, $stuData) { return $model->getStuTotalPayFees($stuData->stu_master_id, $data->fees_collect_category_id); }]]]); ?> </div> </div> </div>