Ejemplo n.º 1
0
 /**
  * Finds the Questionnaire model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Questionnaire the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Questionnaire::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
Ejemplo n.º 2
0
 public function actionIndex()
 {
     if (array_key_exists('lang', $_GET)) {
         Yii::$app->language = $_GET['lang'];
     } else {
         Yii::$app->language = 'en';
     }
     $model = new Questionnaire();
     if ($model->load(Yii::$app->request->post())) {
         // get multiple clothing options
         if (is_array($model->clothing)) {
             $model->clothing = join(",", $model->clothing);
         }
         // save to database
         if ($model->save()) {
             return $this->render('success');
         }
     }
     return $this->render('index', ['model' => $model]);
 }
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Questionnaire::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'occupation' => $this->occupation, 'office' => $this->office, 'choice_content' => $this->choice_content, 'choice_contest' => $this->choice_contest, 'choice_seminar' => $this->choice_seminar, 'choice_ict' => $this->choice_ict, 'choice_food' => $this->choice_food, 'choice_news' => $this->choice_news, 'choice_register' => $this->choice_register, 'choice_environment' => $this->choice_environment, 'choice_audiovisual' => $this->choice_audiovisual, 'choice_location' => $this->choice_location, 'choice_overall' => $this->choice_overall, 'adjust' => $this->adjust, 'batter' => $this->batter, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
     return $dataProvider;
 }
Ejemplo n.º 4
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = QuestionnaireModel::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['id_ank' => $this->id_ank]);
     $query->andFilterWhere(['like', 'name_ua', $this->name_ua])->andFilterWhere(['like', 'name_ru', $this->name_ru]);
     return $dataProvider;
 }
Ejemplo n.º 5
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Questionnaire::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $username = Yii::$app->user->identity->username;
     $query->andWhere('altered = 1')->andWhere("creation_name = '{$username}'");
     $query->andFilterWhere(['id' => $this->id, 'fk_person' => $this->fk_person, 'date_interview' => $this->date_interview, 'time_interview' => $this->time_interview, 'mal_episodes' => $this->mal_episodes, 'dates_mal_occured' => $this->dates_mal_occured, 'left_date' => $this->left_date, 'return_date' => $this->return_date, 'mother_edu_level' => $this->mother_edu_level, 'child_5yrs_late' => $this->child_5yrs_late, 'toilet_type' => $this->toilet_type, 'floor_type' => $this->floor_type, 'fuel_type' => $this->fuel_type, 'household_own' => $this->household_own]);
     $query->andFilterWhere(['like', 'pregnant', $this->pregnant])->andFilterWhere(['like', 'menstruating', $this->menstruating])->andFilterWhere(['like', 'lmp', $this->lmp])->andFilterWhere(['like', 'ever_diagnosed_hbp', $this->ever_diagnosed_hbp])->andFilterWhere(['like', 'under_med_hbp', $this->under_med_hbp])->andFilterWhere(['like', 'hbp_med_list', $this->hbp_med_list])->andFilterWhere(['like', 'suffered_malaria', $this->suffered_malaria])->andFilterWhere(['like', 'mal_hospitalised', $this->mal_hospitalised])->andFilterWhere(['like', 'other_med_condition', $this->other_med_condition])->andFilterWhere(['like', 'med_condition_list', $this->med_condition_list])->andFilterWhere(['like', 'place_of_birth', $this->place_of_birth])->andFilterWhere(['like', 'date_of_relocation', $this->date_of_relocation])->andFilterWhere(['like', 'places_before_relocation', $this->places_before_relocation])->andFilterWhere(['like', 'Longest_time_away', $this->Longest_time_away])->andFilterWhere(['like', 'place_away', $this->place_away])->andFilterWhere(['like', 'household_school_greater_5', $this->household_school_greater_5])->andFilterWhere(['like', 'household_not_attend_primary', $this->household_not_attend_primary])->andFilterWhere(['like', 'household_malnourished', $this->household_malnourished])->andFilterWhere(['like', 'electricity', $this->electricity])->andFilterWhere(['like', 'share_toilet', $this->share_toilet])->andFilterWhere(['like', 'safe_drinking_water', $this->safe_drinking_water])->andFilterWhere(['like', 'time_safe_water_access', $this->time_safe_water_access])->andFilterWhere(['like', 'creation_name', $this->creation_name]);
     return $dataProvider;
 }
Ejemplo n.º 6
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getQuestionnaires()
 {
     return $this->hasMany(Questionnaire::className(), ['fk_person' => 'pk_person']);
 }
Ejemplo n.º 7
0
 public function import_excel(Request $request)
 {
     $file = $request->file('file_excel');
     $destinationPath = storage_path() . '/file_excel';
     if ($request->hasFile('file_excel')) {
         $filename = $file->getClientOriginalName();
         $ext = $file->getClientOriginalExtension();
         if ($ext == "xls" || $ext == "xlsx") {
             if ($file->isValid()) {
                 $file->move($destinationPath, $filename);
                 $dataTest = Excel::load(storage_path('file_excel') . '/' . $filename, function ($reader) {
                 })->get();
                 //dd($dataTest[0]);
                 foreach ($dataTest[0] as $data) {
                     /**ข้อมูลส่วนตัว**/
                     $input_profile = new Alumni();
                     $input_profile->year_of_graduation = $data->year_of_graduation;
                     $input_profile->national_id = $data->national_id;
                     $input_profile->student_id = $data->student_id;
                     $input_profile->title = $data->title;
                     $input_profile->firstname = $data->firstname;
                     $input_profile->lastname = $data->lastname;
                     $input_profile->birthdate = $data->birthdate;
                     $input_profile->gpa = $data->gpa;
                     $input_profile->house_no = $data->house_no;
                     $input_profile->moo = $data->moo;
                     $input_profile->soi = $data->soi;
                     $input_profile->road = $data->road;
                     $input_profile->district = $data->district;
                     $input_profile->amphur = $data->amphur;
                     $input_profile->province = $data->province;
                     $input_profile->phone = $data->phone;
                     $input_profile->zipcode = $data->zipcode;
                     $input_profile->email = $data->email;
                     $input_profile->education = $data->education;
                     $input_profile->faculty = $data->faculty;
                     $input_profile->branch = $data->branch;
                     $input_profile->firstname = $data->firstname;
                     $input_profile->course = $data->course;
                     $input_profile->save();
                     /////////////////
                     /**ข้อมูลสถานที่ทำงาน**/
                     $input_workplace = new Workplace();
                     $input_workplace->office = $data->office;
                     $input_workplace->number_office = $data->number_office;
                     $input_workplace->moo_office = $data->moo_office;
                     $input_workplace->building_office = $data->building_office;
                     $input_workplace->class_office = $data->class_office;
                     $input_workplace->soi_office = $data->soi_office;
                     $input_workplace->road_office = $data->road_office;
                     $input_workplace->amphur_office = $data->amphur_office;
                     $input_workplace->district_office = $data->district_office;
                     $input_workplace->province_office = $data->province_office;
                     $input_workplace->zipcode_office = $data->zipcode_office;
                     $input_workplace->phone_office = $data->phone_office;
                     $input_workplace->fax_office = $data->fax_office;
                     $input_workplace->email_office = $data->email_office;
                     $input_workplace->salary = $data->salary;
                     if ($input_profile != null) {
                         $input_workplace->alumni()->associate($input_profile);
                         $input_workplace->save();
                     }
                     /**ข้อมูลแบบสอบถาม**/
                     $input_questionnaire = new Questionnaire();
                     $input_questionnaire->the_knowledge_that_students_applied_to_work_done = $data->the_knowledge_that_students_applied_to_work_done;
                     $input_questionnaire->reasons_to_study = $data->reasons_to_study;
                     $input_questionnaire->the_reason_is_that_no_jobs = $data->the_reason_is_that_no_jobs;
                     $input_questionnaire->work_directly_with_the_subject_matter = $data->work_directly_with_the_subject_matter;
                     $input_questionnaire->issues_in_education = $data->issues_in_education;
                     $input_questionnaire->field_of_study = $data->field_of_study;
                     $input_questionnaire->to_study_or_not = $data->to_study_or_not;
                     $input_questionnaire->talent_helps_to_work = $data->talent_helps_to_work;
                     $input_questionnaire->time_to_get_the_job_done = $data->time_to_get_the_job_done;
                     $input_questionnaire->difficulties_in_finding_jobs = $data->difficulties_in_finding_jobs;
                     $input_questionnaire->agencies = $data->agencies;
                     $input_questionnaire->satisfaction_with_the_work_done = $data->satisfaction_with_the_work_done;
                     $input_questionnaire->functional_status = $data->functional_status;
                     $input_questionnaire->position = $data->position;
                     $input_questionnaire->category = $data->category;
                     $input_questionnaire->types_of_work = $data->types_of_work;
                     if ($input_profile != null) {
                         $input_questionnaire->alumni()->associate($input_profile);
                         $input_questionnaire->save();
                     }
                 }
                 return redirect('admin/import')->with('status', 'Import Success!!');
             } else {
                 return redirect()->back()->with('status', 'file is valid');
             }
         } else {
             return redirect()->back()->with('status', 'no file xls or xlsx!!');
         }
     } else {
         return redirect()->back()->with('no file failed');
     }
 }