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>
