public function getYesOrNoId($answer) { $greekStringConversion = new GreekStringConversionHelper(); $answer = $greekStringConversion->grstrtoupper($answer); foreach ($this->binaryYesNo as $binary) { $binary->description = $greekStringConversion->grstrtoupper($binary->description); if (strcasecmp($answer, $binary->description) == 0) { return $binary->id; } } // no yes or no found in answer return null; }
private function getWorkTitleIdFromDBAndInsertNewWorkTitleIfNeeded($workTitleFromForm) { // initialize the GreekStringConversionHelper service $greekStringConversion = new GreekStringConversionHelper(); $workTitleId = null; $allWorkTitlesAvailable = \DB::table('work_title_list_lookup')->get(); $workTitleFromForm = $greekStringConversion->grstrtoupper($workTitleFromForm); // if there are some work titles in DB if ($allWorkTitlesAvailable != null) { // check for each one if the names are the same after greek string conversion to uppercase foreach ($allWorkTitlesAvailable as $work_title) { $work_title->work_title = $greekStringConversion->grstrtoupper($work_title->work_title); // if strings are the same set the $workTitleId to the DB's id if (strcasecmp($work_title->work_title, $workTitleFromForm) == 0) { $workTitleId = $work_title->id; break; } } } // if work title was not found in DB if ($workTitleId == null) { $workTitleId = \DB::table('work_title_list_lookup')->insertGetId(array('work_title' => $workTitleFromForm)); } return $workTitleId; }