Esempio n. 1
0
 public function actionStudbatch($id)
 {
     $rows = \app\modules\course\models\Batches::find()->where(['batch_course_id' => $id, 'is_status' => 0])->all();
     echo "<option value=''>---Select Batch---</option>";
     if (count($rows) > 0) {
         foreach ($rows as $row) {
             echo "<option value='{$row->batch_id}'>{$row->batch_name}</option>";
         }
     } else {
         echo "";
     }
 }
Esempio n. 2
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Batches::find()->where(['<>', 'is_status', 2]);
     $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['batch_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(['batch_id' => $this->batch_id, 'batch_course_id' => $this->batch_course_id, 'start_date' => $this->dbDateSearch($this->start_date), 'end_date' => $this->dbDateSearch($this->end_date), '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', 'batch_name', $this->batch_name])->andFilterWhere(['like', 'batch_alias', $this->batch_alias]);
     unset($_SESSION['exportData']);
     $_SESSION['exportData'] = $dataProvider;
     return $dataProvider;
 }
Esempio n. 3
0
 public function actionStudentProfilePdf($sid)
 {
     $nationality = $stuAdd = [];
     $stuMaster = StuMaster::findOne($sid);
     $stuDocs = StuDocs::find()->where(['stu_docs_stu_master_id' => $sid])->join('join', 'document_category dc', 'dc.doc_category_id = stu_docs_category_id AND dc.is_status <> 2')->all();
     $stuInfo = StuInfo::find()->where(['stu_info_stu_master_id' => $sid])->one();
     $stuCourse = Courses::findOne($stuMaster->stu_master_course_id);
     $stuBatch = Batches::findOne($stuMaster->stu_master_batch_id);
     $stuSection = Section::findOne($stuMaster->stu_master_section_id);
     $stuGuard = StuGuardians::findAll(['guardia_stu_master_id' => $sid]);
     $sDocs = new StuDocs();
     if ($stuMaster->stu_master_nationality_id !== null) {
         $nationality = Nationality::findOne($stuMaster->stu_master_nationality_id)->nationality_name;
     }
     if ($stuMaster->stu_master_stu_address_id !== null) {
         $stuAdd = StuAddress::findOne($stuMaster->stu_master_stu_address_id);
     }
     $html = $this->renderPartial('/stu-master/stuprofilepdf', ['stuDocs' => $stuDocs, 'stuMaster' => $stuMaster, 'stuInfo' => $stuInfo, 'nationality' => $nationality, 'stuBatch' => $stuBatch, 'stuCourse' => $stuCourse, 'stuSection' => $stuSection, 'stuAdd' => $stuAdd, 'stuGuard' => $stuGuard, 'sDocs' => $sDocs]);
     $fName = $stuInfo->stu_first_name . "_" . $stuInfo->stu_last_name . "_" . date('Ymd-His');
     return Yii::$app->pdf->exportData(Yii::t('report', 'Student Report'), $fName, $html);
 }
Esempio n. 4
0
 /**
  * @return all batches
  */
 public static function getStuBatches()
 {
     $dataTmp = Batches::find()->where(['is_status' => 0])->orderBy('batch_name')->all();
     $result = yii\helpers\ArrayHelper::map($dataTmp, 'batch_id', 'batch_name');
     return $result;
 }
Esempio n. 5
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getSectionBatch()
 {
     return $this->hasOne(Batches::className(), ['batch_id' => 'section_batch_id']);
 }
 $i = 1;
 $add_city_c = $add_c = $add_city = $add_s = $add_co = $add_city_c = '';
 foreach ($student_data as $t => $sd) {
     if ($i % 2 == 0) {
         $bgcolor = "#FFFFFF";
     } else {
         $bgcolor = "#E3E3E3";
     }
     echo '<tr align=center bgcolor=' . $bgcolor . '>';
     echo "<td style='text-align:center;'>" . $i . "</td>";
     foreach ($selected_list as $s) {
         if ($s == 'batch_name') {
             if ($sd['stu_master_batch_id'] == 0) {
                 echo "<td style='text-align:center;'><i>Not Set</i></td>";
             } else {
                 echo "<td style='text-align:center;'>" . Batches::findOne($sd['stu_master_batch_id'])->{$s} . "</td>";
             }
         } else {
             if ($s == 'course_name') {
                 if ($sd['stu_master_course_id'] == 0) {
                     echo "<td></i> Not Set</i></td>";
                 } else {
                     echo "<td>" . Courses::findOne($sd['stu_master_course_id'])->{$s} . "</td>";
                 }
             } else {
                 if ($s == 'section_name') {
                     if ($sd['stu_master_section_id'] == 0) {
                         echo "<td> Not Set </td>";
                     } else {
                         echo "<td>" . Section::findOne($sd['stu_master_section_id'])->{$s} . "</td>";
                     }
Esempio n. 7
0
?>
</span>
		        </div><!-- /.info-box-content -->
		      </div><!-- /.info-box -->
		</div>

		<div class="col-md-4 col-sm-6 col-xs-12">
		      <div class="edusec-link-box">
		        <span class="edusec-link-box-icon bg-teal"><i class="fa fa-users"></i></span>
		        <div class="edusec-link-box-content">
		          <span class="edusec-link-box-text"><?php 
echo Html::a(Yii::t('course', 'Manage Batches'), ['/course/batches']);
?>
</span>
		          <span class="edusec-link-box-number"><?php 
echo app\modules\course\models\Batches::find()->where(['is_status' => 0])->count();
?>
</span>
			 <span class="edusec-link-box-desc"></span>
			  <span class="edusec-link-box-bottom"><?php 
echo Html::a('<i class="fa fa-plus-square"></i> ' . Yii::t('course', 'Create New'), ['/course/batches/create']);
?>
</span>
		        </div><!-- /.info-box-content -->
		      </div><!-- /.info-box -->
		</div>

		<div class="col-md-4 col-sm-6 col-xs-12">
		      <div class="edusec-link-box">
		        <span class="edusec-link-box-icon bg-green"><i class="fa fa-sitemap"></i></span>
		        <div class="edusec-link-box-content">
Esempio n. 8
0
 /**
  * Finds the Batches model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Batches the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Batches::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
Esempio n. 9
0
 public function getRelBatchData()
 {
     return $this->hasOne(\app\modules\course\models\Batches::className(), ['batch_id' => 'fees_pay_tran_batch_id']);
 }
Esempio n. 10
0
                 }
             }
         }
     }
 }
 echo "</tr>";
 $i = 1;
 foreach ($student_data as $t => $sd) {
     echo "<tr>";
     echo "<td class='text-center'>" . $i . "</td>";
     foreach ($selected_list as $s) {
         if ($s == 'batch_name') {
             if ($sd['stu_master_batch_id'] == 0) {
                 echo "<td class='text-center'><i>" . Yii::t('report', 'Not Set') . "</i></td>";
             } else {
                 echo "<td class='text-center'>" . Batches::findOne($sd['stu_master_batch_id'])->{$s} . "</td>";
             }
         } else {
             if ($s == 'course_name') {
                 if ($sd['stu_master_course_id'] == 0) {
                     echo "<td></i> " . Yii::t('report', 'Not Set') . "</i></td>";
                 } else {
                     echo "<td>" . Courses::findOne($sd['stu_master_course_id'])->{$s} . "</td>";
                 }
             } else {
                 if ($s == 'section_name') {
                     if ($sd['stu_master_section_id'] == 0) {
                         echo "<td> " . Yii::t('report', 'Not Set') . " </td>";
                     } else {
                         echo "<td>" . Section::findOne($sd['stu_master_section_id'])->{$s} . "</td>";
                     }
Esempio n. 11
0
 public function importStuData($model)
 {
     $dispResults = [];
     $totalSuccess = 0;
     $objPHPExcel = PHPExcel_IOFactory::load($model->importFilePath . $model->importFile);
     $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
     //print_r($sheetData); exit;
     unset($sheetData[1]);
     //start import student row by row
     foreach ($sheetData as $k => $line) {
         //print_r($line); exit;
         if (!array_filter($line)) {
             continue;
         }
         $line = array_map('trim', $line);
         $line = array_map(function ($value) {
             return empty($value) ? NULL : $value;
         }, $line);
         $stuMaster = new StuMaster();
         $stuInfo = new StuInfo();
         $stuInfo->scenario = 'import-stu';
         $stuAddress = new StuAddress();
         $user = new User();
         $auth_assign = new AuthAssignment();
         //set student info attributes
         $stuInfo->stu_unique_id = $stuInfo->getUniqueId();
         // Student Unique Id
         $stuInfo->stu_title = $this->valueReplace($line['A'], $stuInfo->getTitleOptions());
         //Title Name
         $stuInfo->stu_first_name = $line['B'];
         //First Name
         $stuInfo->stu_last_name = $line['C'];
         //Last Name
         $stuInfo->stu_dob = Yii::$app->dateformatter->getDateFormat($line['D']);
         //Date of Birth
         $stuInfo->stu_admission_date = Yii::$app->dateformatter->getDateFormat($line['H']);
         //Student Admission Date
         $stuInfo->stu_gender = $this->valueReplace($line['I'], $stuInfo->getGenderOptions());
         // Gender
         $stuInfo->stu_email_id = $line['J'];
         // Email ID
         $stuInfo->stu_mobile_no = $line['K'];
         // Mobile No
         //set student master attribute
         $stuMaster->stu_master_course_id = $this->valueReplace($line['E'], Courses::getStuCourse());
         // Course
         $stuMaster->stu_master_batch_id = $this->valueReplace($line['F'], Batches::getStuBatches());
         // Batch
         $stuMaster->stu_master_section_id = $this->valueReplace($line['G'], Section::getStuSection());
         // Section
         $stuMaster->stu_master_category_id = $this->valueReplace($line['L'], StuCategory::getStuCategoryId());
         //Admission Category
         $stuMaster->stu_master_nationality_id = $this->valueReplace($line['M'], Nationality::getNationality());
         //Nationality
         //set student address attribute
         $stuAddress->stu_cadd = $line['N'];
         //Current Address
         $stuAddress->stu_cadd_city = $this->valueReplace($line['O'], City::getAllCity());
         //City
         $stuAddress->stu_cadd_state = $this->valueReplace($line['P'], State::getAllState());
         //State
         $stuAddress->stu_cadd_country = $this->valueReplace($line['Q'], Country::getAllCountry());
         //Country
         $stuAddress->stu_cadd_pincode = $line['R'];
         //Pincode
         $stuAddress->stu_cadd_house_no = $line['S'];
         //House No
         $stuAddress->stu_cadd_phone_no = $line['T'];
         //Phone No
         //set user login info attributes
         $uniq_id = $stuInfo->getUniqueId();
         $login_id = \app\models\Organization::find()->one()->org_stu_prefix . $uniq_id;
         $user->user_login_id = $login_id;
         //user login id
         $user->user_password = md5($user->user_login_id . $user->user_login_id);
         //user password
         $user->user_type = "S";
         //user type
         $user->created_by = Yii::$app->getid->getId();
         //created by
         $user->created_at = new \yii\db\Expression('NOW()');
         //created at
         if ($user->validate() && $stuInfo->validate() && $stuAddress->validate()) {
             $transaction = Yii::$app->db->beginTransaction();
             try {
                 if ($stuInfo->save() && $user->save() && $stuAddress->save()) {
                     $stuMaster->stu_master_stu_info_id = $stuInfo->stu_info_id;
                     $stuMaster->stu_master_user_id = $user->user_id;
                     $stuMaster->stu_master_stu_address_id = $stuAddress->stu_address_id;
                     $stuMaster->created_by = Yii::$app->getid->getId();
                     $stuMaster->created_at = new \yii\db\Expression('NOW()');
                     if ($stuMaster->save()) {
                         $stuInfo->stu_info_stu_master_id = $stuMaster->stu_master_id;
                         if ($stuInfo->save(false)) {
                             $auth_assign->item_name = 'Student';
                             $auth_assign->user_id = $user->user_id;
                             $auth_assign->created_at = date_format(date_create(), 'U');
                             $auth_assign->save(false);
                             $transaction->commit();
                             $totalSuccess += 1;
                             $dispResults[] = array_merge($line, ['type' => 'S', 'stuMasterId' => $stuMaster->stu_master_id, 'message' => 'Success']);
                         }
                     } else {
                         $dispResults[] = array_merge($line, ['type' => 'E', 'message' => Html::errorSummary($stuMaster)]);
                     }
                 }
                 // end stuInfo, user, StuAddress
                 $transaction->rollback();
             } catch (\Exception $e) {
                 $transaction->rollBack();
                 $dispResults[] = array_merge($line, ['type' => 'E', 'message' => $e->getMessage()]);
             }
         } else {
             $dispResults[] = array_merge($line, ['type' => 'E', 'message' => Html::errorSummary([$user, $stuInfo, $stuMaster, $stuAddress])]);
         }
         //end validated if
     }
     //end foreach
     return ['dispResults' => $dispResults, 'totalSuccess' => $totalSuccess];
 }
Esempio n. 12
0
 /**
  * Deletes an existing Courses model.
  * If deletion is successful, the browser will be redirected to the 'index' page.
  * @param integer $id
  * @return mixed
  */
 public function actionDelete($id)
 {
     $batch = Batches::find()->where('batch_course_id=' . $id . ' AND is_status!=2')->exists();
     if ($batch) {
         $err_msg = 'Batch';
     } else {
         $err_msg = '';
     }
     if (!empty($err_msg)) {
         throw new HttpException(400, 'You can not delete this record because it is used in ' . $err_msg . ' table.');
     } else {
         $model = Courses::findOne($id);
         $model->is_status = 2;
         $model->update();
     }
     return $this->redirect(['index']);
 }
Esempio n. 13
0
 public function getFeesCollectBatch()
 {
     return $this->hasOne(Batches::className(), ['batch_id' => 'fees_collect_batch_id']);
 }
Esempio n. 14
0
 $i = 1;
 $add_c = $add_s = $add_city = $add_co = $add_city_c = '';
 $student_info = new StuInfo();
 echo "</br></br><h1>" . Yii::t('report', 'Students List') . "</h1>";
 foreach ($student_data as $t => $sd) {
     echo "<h3>" . $sd['stu_first_name'] . " " . $sd['stu_last_name'] . "</h3>";
     echo "<table>";
     echo '<tr >';
     echo "<td class='label'>" . Yii::t('report', 'SI No.') . "</td><td>" . $i . "</td>";
     foreach ($selected_list as $s) {
         if ($s == 'batch_name') {
             echo "<tr><td class='label'>" . Yii::t('report', 'Batch') . " </td>";
             if ($sd['stu_master_batch_id'] == 0) {
                 echo "<td ><i>" . Yii::t('report', 'Not Set') . "</i></td></tr>";
             } else {
                 echo "<td>" . Batches::findOne($sd['stu_master_batch_id'])->{$s} . "</td></tr>";
             }
         } else {
             if ($s == 'course_name') {
                 echo "<tr><td class='label'>" . Yii::t('report', 'Course') . "</td>";
                 if ($sd['stu_master_batch_id'] == 0) {
                     echo "<td><i>" . Yii::t('report', 'Not Set') . "</i></td></tr>";
                 } else {
                     echo "<td>" . Courses::findOne($sd['stu_master_course_id'])->{$s} . "</td></tr>";
                 }
             } else {
                 if ($s == 'section_name') {
                     echo "<tr><td class='label'>" . Yii::t('report', 'Section') . " </td>";
                     if ($sd['stu_master_section_id'] == 0) {
                         echo "<td ><i>" . Yii::t('report', 'Not Set') . "</i></td></tr>";
                     } else {
Esempio n. 15
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getStuMasterBatch()
 {
     return $this->hasOne(\app\modules\course\models\Batches::className(), ['batch_id' => 'stu_master_batch_id']);
 }
Esempio n. 16
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getBatches()
 {
     return $this->hasMany(Batches::className(), ['batch_course_id' => 'course_id']);
 }