/** * Execute the console command. * * @return mixed */ public function fire() { ini_set('max_execution_time', 0); $answers = Answer::whereNotNull('id_attribute')->get(); Answer::whereRaw('1=1')->update(['id_attr_map' => null]); $oldAnswers = DB::connection('old')->select('select * from option_ans where attribute_id is not null'); foreach ($answers as $answer) { foreach ($oldAnswers as $oldAnswer) { if (strcmp($answer->name, $oldAnswer->opt_content) == 0) { $data = DB::connection('old')->select('select * from attribute where id = ' . $oldAnswer->attribute_id); $answer->id_attr_map = $data[0]->attribute; $answer->save(); echo $answer->name . "\n"; echo $oldAnswer->opt_content . "\n"; echo $answer->id_attr_map . "\n"; echo "---------\n"; break; } } } }
private function scoreAnswer($listAnswer) { $listAns = Answer::whereNotNull('id_attribute')->get(); $arrAnsPoint = []; foreach ($listAns as $ans) { $arrAnsPoint[$ans->id] = ['point' => null, 'level' => null, 'interactions' => [], 'attribute' => $ans->id_attribute]; } foreach ($listAnswer as $ans) { $arrAnsPoint[$ans]['point'] = 100; $arrAnsPoint[$ans]['level'] = 1; } return $arrAnsPoint; }