public function actionIndex()
{
if (Yii::$app->session->get('stu_id') || Yii::$app->session->get('emp_id')) {
return $this->redirect(['/course/courses/index']);
}
$actCourseData = \app\modules\course\models\Courses::find()->where(['is_status' => 0])->all();
return $this->render('index', ['actCourseData' => $actCourseData]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Courses::find()->where('is_status != 2');
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['course_id' => SORT_DESC]]]);
$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(['course_id' => $this->course_id, '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', 'course_name', $this->course_name])->andFilterWhere(['like', 'course_code', $this->course_code])->andFilterWhere(['like', 'course_alias', $this->course_alias]);
unset($_SESSION['exportData']);
$_SESSION['exportData'] = $dataProvider;
return $dataProvider;
}
public function actionIndex()
{
$fYearWiseAdm = [];
/**
* @Start Display Category Wise Student Details Graph
*/
$stuCateDataTmp = StuCategory::find()->where(['is_status' => 0])->asArray()->all();
foreach ($stuCateDataTmp as $cv) {
$stuCatWiseDisp[] = $cv['stu_category_name'];
$maleCount = (new \yii\db\Query())->from('stu_master sm')->join('JOIN', 'stu_info si', 'si.stu_info_stu_master_id = sm.stu_master_id')->where(['sm.is_status' => '0', 'si.stu_gender' => 'Male', 'sm.stu_master_category_id' => $cv['stu_category_id']])->count();
$femaleCount = (new \yii\db\Query())->from('stu_master sm')->join('JOIN', 'stu_info si', 'si.stu_info_stu_master_id = sm.stu_master_id')->where(['sm.is_status' => '0', 'si.stu_gender' => 'Female', 'sm.stu_master_category_id' => $cv['stu_category_id']])->count();
$stuCatWiseDataMale[] = $maleCount;
$stuCatWiseDataFemale[] = $femaleCount;
}
$stuCatWiseDisp[] = 'Not Set';
$stuCatWiseDataMale[] = (new \yii\db\Query())->from('stu_master sm')->join('JOIN', 'stu_info si', 'si.stu_info_stu_master_id = sm.stu_master_id')->where(['sm.is_status' => 0, 'sm.stu_master_category_id' => NULL, 'si.stu_gender' => 'Male'])->count();
$stuCatWiseDataFemale[] = (new \yii\db\Query())->from('stu_master sm')->join('JOIN', 'stu_info si', 'si.stu_info_stu_master_id = sm.stu_master_id')->where(['sm.is_status' => 0, 'sm.stu_master_category_id' => NULL, 'si.stu_gender' => 'Female'])->count();
/**
* @Start Display Student Status Wise Details in combine graph
*/
$dataRegTmp = $courseData = [];
$stuRegStat = StuMaster::find()->where(['is_status' => 0, 'stu_master_stu_status_id' => 0])->count();
$stuStatusWise[] = ['name' => "Default ({$stuRegStat})", 'y' => $stuRegStat, 'color' => '#77C730'];
$courseDataTmp = Courses::find()->where(['is_status' => 0])->asArray()->limit(10)->orderBy('course_id DESC')->all();
$stuStatusDataTmp = StuStatus::find()->where(['is_status' => 0])->orderBy('stu_status_id')->asArray()->all();
foreach ($courseDataTmp as $v) {
$stuCourseRegStat = StuMaster::find()->where(['is_status' => 0, 'stu_master_stu_status_id' => 0, 'stu_master_course_id' => $v['course_id']])->count();
$dataRegTmp[] = $stuCourseRegStat;
$courseData[] = $v['course_name'];
}
$stuStatusData[] = ['name' => "Default ({$stuRegStat})", 'type' => 'column', 'data' => $dataRegTmp, 'color' => '#77C730'];
//print_r($stuStatusData); exit;
foreach ($stuStatusDataTmp as $k => $sv) {
$dataTmp = [];
foreach ($courseDataTmp as $v) {
$stuCourseStat = StuMaster::find()->where(['is_status' => 0, 'stu_master_course_id' => $v['course_id'], 'stu_master_stu_status_id' => $sv['stu_status_id']])->count();
$dataTmp[] = $stuCourseStat;
}
$stuStatusWiseCount = StuMaster::find()->where(['is_status' => 0, 'stu_master_stu_status_id' => $sv['stu_status_id']])->count();
$stuStatusData[] = ['name' => $sv['stu_status_name'] . "({$stuStatusWiseCount})", 'type' => 'column', 'data' => $dataTmp];
$stuStatusWise[] = ['name' => $sv['stu_status_name'] . ' (' . $stuStatusWiseCount . ')', 'y' => $stuStatusWiseCount, 'color' => new JsExpression('Highcharts.getOptions().colors[' . $k . ']')];
}
/**
* @Start Gender Wise Data Display For Student
*/
$stuGenWise = (new \yii\db\Query())->select(["CONCAT(IFNULL(si.stu_gender, 'Not Set'), ' (', COUNT( stu_master_id ), ')') AS '0'", 'COUNT(stu_master_id) AS "1"'])->from('stu_master sm')->join('JOIN', 'stu_info si', 'si.stu_info_stu_master_id = sm.stu_master_id')->where(['sm.is_status' => '0'])->groupBy('si.stu_gender')->orderBy('si.stu_gender ASC')->all();
if ($stuGenWise) {
$stuGenWise[0][0] = "Not Set" . $stuGenWise[0][0];
}
/**
* @Start Gender Wise Data Display For Employee
*/
$empGenWise = (new \yii\db\Query())->select(["CONCAT(IFNULL(ei.emp_gender, 'Not Set'), ' (', COUNT( emp_master_id ), ')') AS '0'", 'COUNT(emp_master_id) AS "1"'])->from('emp_master em')->join('JOIN', 'emp_info ei', 'ei.emp_info_emp_master_id = em.emp_master_id')->where(['em.is_status' => '0'])->groupBy('ei.emp_gender')->orderBy('ei.emp_gender ASC')->all();
if ($empGenWise) {
$empGenWise[0][0] = "Not Set" . $empGenWise[0][0];
}
/**
* @Start Year wise employee joining
*/
$empYearWiseJoin = $depDisp = [];
$empYearJoin = (new \yii\db\Query())->select(["CONCAT(DATE_FORMAT(ei.emp_joining_date, '%Y'), ' (', COUNT(em.emp_master_id), ')') AS 'yearDisp'", 'DATE_FORMAT(ei.emp_joining_date, "%Y") as "year"'])->from('emp_master em')->join('JOIN', 'emp_info ei', 'ei.emp_info_emp_master_id = em.emp_master_id')->where(['em.is_status' => '0'])->groupBy(['DATE_FORMAT(ei.emp_joining_date, "%Y")'])->orderBy('YEAR(ei.emp_joining_date) DESC')->limit('3')->all();
foreach ($empYearJoin as $k => $v) {
$yearResults = $deptCount = $depDisp = [];
$deptData = \app\modules\employee\models\EmpDepartment::find()->where(['is_status' => 0])->limit(10)->orderBy('emp_department_id DESC')->asArray()->all();
foreach ($deptData as $k => $dv) {
$deptCountTmp = (new \yii\db\Query())->from('emp_master em')->join('JOIN', 'emp_info ei', 'ei.emp_info_emp_master_id = em.emp_master_id')->where(['YEAR(ei.emp_joining_date)' => $v['year'], 'emp_master_department_id' => $dv['emp_department_id'], 'is_status' => 0])->count();
$deptCount[] = $deptCountTmp;
$depDisp[] = $dv['emp_department_alias'];
}
$yearResults = ['name' => !empty($v['yearDisp']) ? $v['yearDisp'] : "Not Set", 'data' => $deptCount];
$empYearWiseJoin[] = $yearResults;
}
return $this->render('index', ['stuCatWiseDataMale' => $stuCatWiseDataMale, 'stuCatWiseDataFemale' => $stuCatWiseDataFemale, 'stuCatWiseDisp' => $stuCatWiseDisp, 'stuStatusWise' => $stuStatusWise, 'stuGenWise' => $stuGenWise, 'empYearWiseJoin' => $empYearWiseJoin, 'depDisp' => $depDisp, 'courseData' => $courseData, 'stuStatusData' => $stuStatusData, 'empGenWise' => $empGenWise]);
}
</div>
<div class="col-xs-4 left-padding">
<?php
echo Html::a(Yii::t('course', 'EXCEL'), ['/export-data/export-excel', 'model' => get_class($searchModel)], ['class' => 'btn btn-block btn-primary', 'target' => '_blank']);
?>
</div>
</div>
</div>
<div class="col-xs-12" style="padding-top: 10px;">
<div class="box">
<div class="box-body table-responsive">
<div class="batches-index">
<?php
\yii\widgets\Pjax::begin(['id' => 'batch-id', 'enablePushState' => false, 'enableReplaceState' => false]);
?>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'summary' => '', 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'batch_name', 'batch_alias', ['label' => Yii::t('app', 'Course'), 'attribute' => 'batch_course_id', 'value' => 'batchCourse.course_name', 'filter' => ArrayHelper::map(app\modules\course\models\Courses::find()->all(), 'course_id', 'course_name')], ['attribute' => 'start_date', 'value' => function ($data) {
return !empty($data->start_date) ? Yii::$app->formatter->asDate($data->start_date) : ' - ';
}, 'filter' => \yii\jui\DatePicker::widget(['model' => $searchModel, 'attribute' => 'start_date', 'clientOptions' => ['dateFormat' => 'dd-mm-yyyy', 'changeMonth' => true, 'changeYear' => true, 'defaultValue' => null, 'yearRange' => '1900:' . (date('Y') + 1), 'defaultDate' => null], 'options' => ['id' => 'start_date', 'value' => NULL, 'class' => 'form-control']]), 'format' => 'html'], ['attribute' => 'end_date', 'value' => function ($data) {
return !empty($data->end_date) ? Yii::$app->formatter->asDate($data->end_date) : ' - ';
}, 'filter' => \yii\jui\DatePicker::widget(['model' => $searchModel, 'attribute' => 'end_date', 'clientOptions' => ['dateFormat' => 'dd-mm-yyyy', 'changeMonth' => true, 'changeYear' => true, 'defaultValue' => null, 'defaultDate' => null, 'yearRange' => '1900:' . (date('Y') + 1)], 'options' => ['id' => 'end_date', 'value' => NULL, 'class' => 'form-control']]), 'format' => 'html'], ['class' => '\\pheme\\grid\\ToggleColumn', 'contentOptions' => ['class' => 'text-center'], 'attribute' => 'is_status', 'enableAjax' => false, 'filter' => ['1' => 'InActive', '0' => 'Active']], ['class' => 'app\\components\\CustomActionColumn']]]);
?>
<?php
\yii\widgets\Pjax::end();
?>
</div>
</div>
</div>
</div>
<div class="box box-info box-solid">
<div class="box-header with-border">
<h4 class="box-title"><i class="fa fa-search"></i> <?php
echo Yii::t('report', 'Select Criteria');
?>
</h4>
</div>
<?php
$form = ActiveForm::begin(['id' => 'stu_info-form']);
?>
<div class="box-body">
<div class="row">
<div class="col-xs-12 col-sm-4 col-lg-4">
<?php
echo $form->field($model, 'stu_master_course_id')->dropDownList(ArrayHelper::map(app\modules\course\models\Courses::find()->where(['is_status' => 0])->all(), 'course_id', 'course_name'), ['prompt' => Yii::t('course', '--- Select Course ---'), 'required' => 'true', 'onchange' => '
$.get( "' . Url::toRoute('dependent/studbatch') . '", { id: $(this).val() } )
.done(function( data ) {
$( "#' . Html::getInputId($model, 'report_batch_id') . '" ).html( data );
}
);
']);
?>
</div>
<div class="col-xs-12 col-sm-4 col-lg-4">
<?php
echo $form->field($model, 'report_batch_id')->dropDownList([], ['prompt' => Yii::t('stu', '--- Select Batch ---'), 'onchange' => '
$.get( "' . Url::toRoute('dependent/studsection') . '", { id: $(this).val() } )
.done(function( data ) {
$( "#' . Html::getInputId($model, 'report_section_id') . '" ).html( data );
}
/**
* @return all course
*/
public static function getStuCourse()
{
$dataTmp = Courses::find()->where(['is_status' => 0])->orderBy('course_name')->all();
$result = yii\helpers\ArrayHelper::map($dataTmp, 'course_id', 'course_name');
return $result;
}
