protected function importIssues()
{
$issues = DB::connection('oldissue')->select('select * from initlaws where currentphase=1');
foreach ($issues as $issue) {
$newIssue = new Issue();
$newIssue->id = $issue->propid;
$newIssue->public_code = str_random(40);
$newIssue->archived = false;
if ($issue->issuestatus === 'INPROGRESS') {
$newIssue->phase = 'curent';
} elseif ($issue->issuestatus === 'REFERRED_BACK' || $issue->issuestatus === 'ARCHIVED') {
$newIssue->phase = 'arhivatRespinsSauAbrogat';
} elseif ($issue->issuestatus === 'ENDSTAGE' || $issue->issuestatus === 'COMPLETE') {
$newIssue->phase = 'publicatMO';
}
$translatableData = ['ro' => ['name' => $issue->name ? $issue->name : '', 'description' => $issue->description ? $issue->description : '', 'impact' => $issue->impact ? $issue->impact : '', 'status' => $issue->observatii ? $issue->observatii : ''], 'en' => ['name' => $issue->enname ? $issue->enname : '', 'description' => $issue->endescription ? $issue->endescription : '', 'impact' => $issue->enimpact ? $issue->enimpact : '', 'status' => $issue->enobservatii ? $issue->enobservatii : '']];
$newIssue->fill($translatableData);
$newIssue->save();
}
return print_r('Au fost importate: ' . Issue::count() . ' initiative.' . "\n");
}
