public function actionStudsection($id) { $rows = \app\modules\course\models\Section::find()->where(['section_batch_id' => $id, 'is_status' => 0])->all(); echo "<option value=''>---Select Section---</option>"; if (count($rows) > 0) { foreach ($rows as $row) { echo "<option value='{$row->section_id}'>{$row->section_name}</option>"; } } else { echo ""; } }
/** * Creates a new Courses model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Courses(); $batch = new Batches(); $section = new Section(); if ($model->load(Yii::$app->request->post()) && $batch->load(Yii::$app->request->post()) && $section->load(Yii::$app->request->post()) && Yii::$app->request->isAjax) { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; return array_merge(ActiveForm::validate($model), ActiveForm::validate($batch), ActiveForm::validate($section)); } if ($model->load(Yii::$app->request->post()) && $batch->load(Yii::$app->request->post()) && $section->load(Yii::$app->request->post())) { $model->attributes = $_POST['Courses']; $model->created_by = Yii::$app->getid->getId(); $model->created_at = new \yii\db\Expression('NOW()'); if ($model->save()) { if (isset($_POST['Batches'])) { $batch->attributes = $_POST['Batches']; $batch->batch_course_id = $model->course_id; $batch->start_date = date('Y-m-d', strtotime($_POST['Batches']['start_date'])); $batch->end_date = date('Y-m-d', strtotime($_POST['Batches']['end_date'])); $batch->created_by = Yii::$app->getid->getId(); $batch->created_at = new \yii\db\Expression('NOW()'); if ($batch->save()) { $section->attributes = $_POST['Section']; $section->section_batch_id = $batch->batch_id; $section->created_by = Yii::$app->getid->getId(); $section->created_at = new \yii\db\Expression('NOW()'); if ($section->save()) { return $this->redirect(['index']); } else { return $this->render('create', ['model' => $model, 'batch' => $batch, 'section' => $section]); } } } } else { return $this->render('create', ['model' => $model, 'batch' => $batch, 'section' => $section]); } } else { return $this->render('create', ['model' => $model, 'batch' => $batch, 'section' => $section]); } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Section::find()->where('is_status != 2'); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['section_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(['section_id' => $this->section_id, 'section_batch_id' => $this->section_batch_id, 'intake' => $this->intake, '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', 'section_name', $this->section_name]); unset($_SESSION['exportData']); $_SESSION['exportData'] = $dataProvider; return $dataProvider; }
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); }
/** * @return \yii\db\ActiveQuery */ public function getSections() { return $this->hasMany(Section::className(), ['section_batch_id' => 'batch_id']); }
/** * @return all Section */ public static function getStuSection() { $dataTmp = Section::find()->where(['is_status' => 0])->orderBy('section_name')->all(); $result = yii\helpers\ArrayHelper::map($dataTmp, 'section_id', 'section_name'); return $result; }
} 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>"; } } else { if ($s == 'stu_cadd') { if ($sd['stu_master_stu_address_id'] != 0) { if (!empty(StuAddress::findOne($sd['stu_master_stu_address_id'])->stu_cadd_city)) { $add_c = City::findOne(StuAddress::findOne($sd['stu_master_stu_address_id'])->stu_cadd_city); if (!empty($add_c)) { $add_city = $add_c->city_name . " , "; } else { $add_city = ''; } } else { $add_city = ''; } if (!empty(StuAddress::findOne($sd['stu_master_stu_address_id'])->stu_cadd_state)) {
echo Yii::t('course', 'Active'); ?> </span> <?php } else { ?> <span class="label label-danger"><?php echo Yii::t('course', 'Inactive'); ?> </span> <?php } ?> </div> <?php $secData = \app\modules\course\models\Section::find()->where('is_status!=2 AND section_batch_id = ' . $bv['batch_id'])->asArray()->all(); ?> <ol> <?php foreach ($secData as $sk => $sv) { ?> <li> <?php echo $sv['section_name']; ?> <?php echo Html::a('<i class="fa fa-eye"></i>', ['section/view', 'id' => $sv['section_id']], ['class' => 'btn-xs btn btn-default', 'title' => Yii::t('course', 'View Section Details')]); ?> <?php echo Html::a('<i class="fa fa-pencil-square-o"></i>', ['section/update', 'id' => $sv['section_id']], ['class' => 'btn-xs btn btn-default', 'title' => Yii::t('course', 'Edit Section Details')]); ?>
/** * Deletes an existing Batches model. * If deletion is successful, the browser will be redirected to the 'index' page. * @param integer $id * @return mixed */ public function actionDelete($id) { $section = Section::find()->where(['section_batch_id' => $id, 'is_status' => 0])->exists(); if ($section) { $err_msg = 'Section'; } 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 = Batches::findOne($id); $model->is_status = 2; $model->update(); } return $this->redirect(['index']); }
public function getRelSectionData() { return $this->hasOne(\app\modules\course\models\Section::className(), ['section_id' => 'fees_pay_tran_section_id']); }
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]; }
echo Yii::t('course', 'Active'); ?> </span> <?php } else { ?> <span class="label label-danger"><?php echo Yii::t('course', 'Inactive'); ?> </span> <?php } ?> </div> <?php $secData = \app\modules\course\models\Section::find()->where(['<>', 'is_status', 2])->andWhere(['section_batch_id' => $bv['batch_id']])->asArray()->all(); ?> <ol> <?php foreach ($secData as $sk => $sv) { ?> <li> <?php echo $sv['section_name']; ?> <?php echo Html::a('<i class="fa fa-eye"></i>', ['section/view', 'id' => $sv['section_id']], ['class' => 'btn-xs btn btn-default', 'title' => Yii::t('course', 'View Section Details')]); ?> <?php echo Html::a('<i class="fa fa-pencil-square-o"></i>', ['section/update', 'id' => $sv['section_id']], ['class' => 'btn-xs btn btn-default', 'title' => Yii::t('course', 'Edit Section Details')]); ?>
/** * @return \yii\db\ActiveQuery */ public function getStuMasterSection() { return $this->hasOne(\app\modules\course\models\Section::className(), ['section_id' => 'stu_master_section_id']); }
/** * Finds the Section model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Section the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Section::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }