/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $delimiter = ','; $csvFile = public_path() . '/gtd_70to91_0615dist.csv'; if (($handle = fopen($csvFile, 'r')) !== FALSE) { $i = 0; while (($row = fgetcsv($handle, 8192, $delimiter)) !== FALSE) { if ($i != 0) { /* Creating the where entry */ $when = new When(); $when->year = $row[1]; $when->month = $row[2]; $when->day = $row[3]; $when->approxdate = $row[4]; $when->extended = $row[5]; $when->resolution = $row[6]; $when->save(); /* Check if Countyr, provstate and city exist. * If no, creating them */ $country = Country::where('txt', $row[8])->first(); if ($country == null) { $country = new Country(); $country->txt = $row[8]; $country->save(); } $provstate = Provstate::where('txt', $row[11])->first(); if ($provstate == null) { $provstate = new Provstate(); $provstate->txt = $row[11]; $provstate->save(); } $city = City::where('txt', $row[12])->first(); if ($city == null) { $city = new City(); $city->txt = $row[12]; $city->save(); } /* Creating the where entry */ $where = new Where(); $where->country_id = $country->id; $where->provstate_id = $provstate->id; $where->city_id = $city->id; $where->latitude = $row[13]; $where->longitude = $row[14]; $where->specificity_id = $row[15]; $where->vicinity = $row[16]; $where->txt = $row[17]; $where->save(); /* Creating the what entry */ $what = new What(); $what->crit1 = $row[19]; $what->crit2 = $row[20]; $what->crit3 = $row[21]; $what->success = $row[26]; $what->suicide = $row[27]; $what->attacktype1 = $row[28]; $what->attacktype2 = $row[30]; $what->attacktype3 = $row[32]; $what->save(); /* Creating the target entry */ $target = new Target(); $target->targettype1 = $row[34]; $target->targetsubtype1 = $row[36]; $target->corp1 = $row[38]; $target->target1 = $row[39]; $target->natlty1 = $row[40]; $target->targettype2 = $row[42]; $target->targetsubtype2 = $row[44]; $target->corp2 = $row[46]; $target->target2 = $row[47]; $target->natlty2 = $row[48]; $target->targettype3 = $row[50]; $target->targetsubtype3 = $row[52]; $target->corp3 = $row[54]; $target->target3 = $row[55]; $target->natlty3 = $row[56]; $target->save(); /* Check if perpetrator groups and sub groups exist. * If no, creating them */ $perpetrator_group1 = PerpetratorGroup::where('txt', $row[58])->first(); if ($perpetrator_group1 == null) { $perpetrator_group1 = new PerpetratorGroup(); $perpetrator_group1->txt = $row[58]; $perpetrator_group1->save(); } $perpetrator_sub_group1 = PerpetratorSubGroup::where('txt', $row[59])->first(); if ($perpetrator_sub_group1 == null) { $perpetrator_sub_group1 = new PerpetratorSubGroup(); $perpetrator_sub_group1->txt = $row[59]; $perpetrator_sub_group1->save(); } $perpetrator_group2 = PerpetratorGroup::where('txt', $row[60])->first(); if ($perpetrator_group2 == null) { $perpetrator_group2 = new PerpetratorGroup(); $perpetrator_group2->txt = $row[60]; $perpetrator_group2->save(); } $perpetrator_sub_group2 = PerpetratorSubGroup::where('txt', $row[61])->first(); if ($perpetrator_sub_group2 == null) { $perpetrator_sub_group2 = new PerpetratorSubGroup(); $perpetrator_sub_group2->txt = $row[61]; $perpetrator_sub_group2->save(); } $perpetrator_group3 = PerpetratorGroup::where('txt', $row[62])->first(); if ($perpetrator_group3 == null) { $perpetrator_group3 = new PerpetratorGroup(); $perpetrator_group3->txt = $row[62]; $perpetrator_group3->save(); } $perpetrator_sub_group3 = PerpetratorSubGroup::where('txt', $row[63])->first(); if ($perpetrator_sub_group3 == null) { $perpetrator_sub_group3 = new PerpetratorSubGroup(); $perpetrator_sub_group3->txt = $row[63]; $perpetrator_sub_group3->save(); } /* Creating the who entry */ $who = new Who(); $who->perpetrator_group1 = $perpetrator_group1->id; $who->perpetrator_sub_group1 = $perpetrator_sub_group1->id; $who->perpetrator_group2 = $perpetrator_group2->id; $who->perpetrator_sub_group2 = $perpetrator_sub_group2->id; $who->perpetrator_group3 = $perpetrator_group3->id; $who->perpetrator_sub_group3 = $perpetrator_sub_group3->id; $who->motive = $row[64]; $who->perpetrator_1confirmed = $row[65]; $who->perpetrator_2confirmed = $row[66]; $who->perpetrator_3confirmed = $row[67]; $who->nperps = $row[68]; $who->nperpscap = $row[69]; $who->claimed1 = $row[70]; $who->claimed_mode1 = $row[71]; $who->claimed2 = $row[73]; $who->claimed_mode2 = $row[74]; $who->claimed3 = $row[76]; $who->claimed_mode3 = $row[77]; $who->compclaim = $row[79]; $who->save(); /* Creating the how entry */ $how = new How(); $how->weaptype1 = $row[80]; $how->weapsubtype1 = $row[82]; $how->weaptype2 = $row[84]; $how->weapsubtype2 = $row[86]; $how->weaptype3 = $row[88]; $how->weapsubtype3 = $row[90]; $how->weaptype4 = $row[92]; $how->weapsubtype4 = $row[94]; $how->weapdetail = $row[96]; $how->save(); /* Creating the victim entry */ $victims = new Victims(); $victims->total_killed = $row[97]; $victims->us_killed = $row[98]; $victims->perpetrators_killed = $row[99]; $victims->total_injured = $row[100]; $victims->us_injured = $row[101]; $victims->perpetrators_injured = $row[102]; $victims->property_damage = $row[103]; $victims->property_damage_id = $row[104]; $victims->property_value = $row[106]; $victims->property_comment = $row[107]; $victims->hostages_kidnapping = $row[108]; $victims->hostages_kidnapping_victims = $row[109]; $victims->us_hostages_kidnapping_victims = $row[110]; $victims->hours_of_kidnapping = $row[111]; $victims->days_of_kidnapping = $row[112]; $victims->divert = $row[113]; $victims->kidhijcountry = $row[114]; $victims->ransom_demanded = $row[115]; $victims->ransom_amount = $row[116]; $victims->ransom_us_amount = $row[117]; $victims->ransom_paied = $row[118]; $victims->ransom_us_paied = $row[119]; $victims->ransom_note = $row[120]; $victims->kidnapping_hostage_outcome = $row[121]; $victims->nb_released = $row[122]; $victims->save(); /* Creating the event */ $event = new Event(); $event->where_id = $where->id; $event->when_id = $when->id; $event->what_id = $what->id; $event->who_id = $who->id; $event->how_id = $how->id; $event->target_id = $target->id; $event->victims_id = $victims->id; $event->alternative_id = $row[23]; $event->summary = $row[18]; $event->multiple = $row[25]; $event->related = $row[133]; $event->add_informations = $row[124]; $event->INT_LOG = $row[129]; $event->INT_IDEO = $row[130]; $event->INT_MISC = $row[131]; $event->INT_ANY = $row[132]; $event->source1 = $row[125]; $event->source2 = $row[126]; $event->source3 = $row[127]; $event->db_source = $row[128]; $event->doubtter = $row[22]; $event->save(); /* Updating the event id into the several fields */ $where->event_id = $event->id; $where->save(); $when->event_id = $event->id; $when->save(); $what->event_id = $event->id; $what->save(); $who->event_id = $event->id; $who->save(); $how->event_id = $event->id; $how->save(); $target->event_id = $event->id; $target->save(); $victims->event_id = $event->id; $victims->save(); dd([$event, $when, $where, $what, $who, $how, $target, $victims]); } $i++; } fclose($handle); } return $data; }