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;
 }
 public function actionIndex()
 {
     $paidData = $unPaidData = $fcCategory = [];
     if (Yii::$app->session->get('stu_id')) {
         return $this->redirect(['/fees/fees-payment-transaction/stu-fees-data']);
     }
     //Course Wise Collection Count
     $cateWisePaid = 0;
     $courseWiseCollect = (new \yii\db\Query())->select(["(cs.course_name) AS '0'", 'SUM(fpt.fees_pay_tran_amount) AS "1"'])->from('fees_payment_transaction fpt')->join('JOIN', 'courses cs', 'cs.course_id = fpt.fees_pay_tran_course_id')->where(['cs.is_status' => 0, 'fpt.is_status' => 0])->groupBy('fpt.fees_pay_tran_course_id')->all();
     $actFcc = \app\modules\fees\models\FeesCollectCategory::find()->where(['is_status' => 0])->asArray()->all();
     foreach ($actFcc as $v) {
         $stuCount = \app\modules\student\models\StuMaster::find()->where(['is_status' => 0, 'stu_master_batch_id' => $v['fees_collect_batch_id']])->count();
         $fccTotal = \app\modules\fees\models\FeesCategoryDetails::getFeeCategoryTotal($v['fees_collect_category_id']);
         $cateWisePaid += $stuCount * $fccTotal;
     }
     $paidTotal = (new \yii\db\Query())->from('fees_payment_transaction fpt')->join('JOIN', 'fees_collect_category fcc', 'fpt.fees_pay_tran_collect_id = fees_collect_category_id')->where(['fcc.is_status' => 0, 'fpt.is_status' => 0])->sum('fpt.fees_pay_tran_amount');
     $paidPer = ' (' . ($cateWisePaid != 0 ? round($paidTotal * 100 / $cateWisePaid, 2) : 0) . '%)';
     $unPaidPer = ' (' . ($cateWisePaid != 0 ? round(($cateWisePaid - $paidTotal) * 100 / $cateWisePaid, 2) : 0) . '%)';
     $paidUnpaidData = [['name' => 'Paid' . $paidPer, 'y' => $paidTotal, 'color' => '#77C730'], ['name' => 'Unpaid' . $unPaidPer, 'y' => $cateWisePaid - $paidTotal, 'color' => '#F45B5B']];
     //Individual Fees Collection Category Wise
     $fcWiseDetails = (new \yii\db\Query())->select(['fees_collect_category_id', 'fees_collect_batch_id', "CONCAT(fcc.fees_collect_name,'(',bt.batch_name,')') AS fc_name"])->from('fees_collect_category fcc')->join('JOIN', 'batches bt', 'bt.batch_id = fcc.fees_collect_batch_id')->where(['fcc.is_status' => '0'])->orderBy('fcc.fees_collect_category_id DESC')->limit('10')->all();
     $fccTotal = $fccPaid = 0;
     foreach ($fcWiseDetails as $k => $v) {
         $stuCount = \app\modules\student\models\StuMaster::find()->where(['is_status' => 0, 'stu_master_batch_id' => $v['fees_collect_batch_id']])->count();
         $fccTotalTmp = \app\modules\fees\models\FeesCategoryDetails::getFeeCategoryTotal($v['fees_collect_category_id']);
         $fccPaidTmp = (new \yii\db\Query())->from('fees_payment_transaction fpt')->where(['fpt.is_status' => 0, 'fpt.fees_pay_tran_collect_id' => $v['fees_collect_category_id']])->sum('fpt.fees_pay_tran_amount');
         $fccTotal = $stuCount * $fccTotalTmp;
         $fccPaid = $fccPaidTmp === NULL ? 0 : $fccPaidTmp;
         $fccUnPaid = $fccTotal - $fccPaid;
         $fcCategory[] = $v['fc_name'];
         $paidData[] = $fccPaid;
         $unPaidData[] = $fccUnPaid;
     }
     $fccWisePaidUnPaid = [['name' => 'Paid Amount', 'data' => $paidData, 'color' => '#77C730'], ['name' => 'Unpaid Amount', 'data' => $unPaidData, 'color' => '#F45B5B']];
     //Recently fees transaction
     $feeRecent = (new \yii\db\Query())->select(['fpt.fees_pay_tran_id', 'fpt.fees_pay_tran_amount', 'stu_unique_id', "CONCAT(si.stu_first_name, ' ', si.stu_last_name) AS 'stu_name'", 'fcc.fees_collect_name', 'DATE_FORMAT(fpt.fees_pay_tran_date, "%d-%m-%Y") AS tranDate'])->from('fees_payment_transaction fpt')->join('JOIN', 'fees_collect_category fcc', 'fcc.fees_collect_category_id = fpt.fees_pay_tran_collect_id')->join('JOIN', 'stu_info si', 'si.stu_info_stu_master_id = fpt.fees_pay_tran_stu_id')->where(['fpt.is_status' => '0'])->orderBy('fees_pay_tran_id DESC')->limit(10)->all();
     return $this->render('index', ['feeRecent' => $feeRecent, 'courseWiseCollect' => $courseWiseCollect, 'paidUnpaidData' => $paidUnpaidData, 'fccWisePaidUnPaid' => $fccWisePaidUnPaid, 'fcCategory' => $fcCategory]);
 }
Beispiel #3
0
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>';
Beispiel #4
0
?>
<html>
<head>
	<title><?php 
echo Yii::t('fees', 'Fees Collection Category Wise PDF Report');
?>
</title>
</head>
<body>
<?php 
$totalAmount = $gTotalAmount = $gpayFees = $gActualCollect = $payFees = $actualCollect = 0;
$stuDataTmp = Yii::$app->db->createCommand("SELECT stu_master_id FROM stu_master WHERE stu_master_batch_id=" . $FccModel->fees_collect_batch_id . " AND is_status=0")->queryColumn();
$payFeesTmp = Yii::$app->db->createCommand("SELECT fees_pay_tran_stu_id FROM fees_payment_transaction WHERE fees_pay_tran_batch_id=" . $FccModel->fees_collect_batch_id . " AND is_status=0 AND fees_pay_tran_collect_id=" . $FccModel->fees_collect_category_id)->queryColumn();
$stuData = array_unique(array_merge($stuDataTmp, $payFeesTmp));
$feesData = \app\modules\fees\models\FeesPaymentTransaction::find()->where(['fees_pay_tran_batch_id' => $FccModel->fees_collect_batch_id, 'is_status' => 0])->asArray()->all();
$totalAmountTmp = \app\modules\fees\models\FeesCategoryDetails::getFeeCategoryTotal($FccModel->fees_collect_category_id);
$totalAmount = !$totalAmountTmp ? 0 : $totalAmountTmp;
?>
<div class="grid-view">
<?php 
if (!empty($stuData)) {
    echo '<table class="table table-striped">';
    echo '<tr>';
    echo '<th class="text-center">' . Yii::t('fees', 'SI No.') . '</th>';
    echo '<th>' . Yii::t('fees', 'Student No') . '</th>';
    echo '<th>' . Yii::t('fees', 'Student Name') . '</th>';
    echo '<th>' . Yii::t('fees', 'Total Collection') . '</th>';
    echo '<th>' . Yii::t('fees', 'Paid Amount') . '</th>';
    echo '<th>' . Yii::t('fees', 'Unpaid Amount') . '</th>';
    echo '</tr>';
    $sr = 1;
Beispiel #5
0
 public function getFeesCategoryDetails()
 {
     return $this->hasMany(FeesCategoryDetails::className(), ['fees_details_category_id' => 'fees_collect_category_id']);
 }
Beispiel #6
0
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>
<!-----End current batch fees details----->

<!-----Start student payment history block----->
<div class="col-xs-12" style="padding-top: 10px;">
    <div class="box box-info col-xs-12 col-lg-12 no-padding">
     <div class="box-header with-border">
	<h3 class="box-title"><i class="fa fa-inr"></i><sup><i class="fa fa-clock-o"></i></sup> <?php 
echo Yii::t('fees', 'Student Payment History');
 /**
  * Finds the FeesCategoryDetails model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return FeesCategoryDetails the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = FeesCategoryDetails::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }