/**
* 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;
}
