/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$mEvents = new Event();
$event_data = $mEvents->with('sender')->find($id);
$this->view_data('event_data', $event_data);
return $this->view('events.show');
}
public function renderDefault($event_id = null)
{
if ($event_id) {
$this->template->filterName = $this->event->get($event_id)->name;
$this->template->registration = $this->registration->where('event_id = ?', $event_id)->order('id DESC');
} else {
$this->template->filterName = '';
$this->template->registration = $this->registration->order('id DESC')->limit(100);
}
}
protected function createComponentNewsletterForm()
{
$events = $this->event->order('id DESC')->limit(10)->fetchPairs('id', 'name');
$events[null] = 'ODESLAT VŠEM';
$form = new UI\Form();
$form->addSelect('event_id', 'Účatníků události', $events);
$form->addText('subject', 'Předmět:');
$form->addTextArea('text', 'text')->setAttribute('class', 'tinyMCE');
$form->addCheckbox('notTest', 'TOTO NENÍ TEST');
$form->addMultiUpload('files', 'Přílohy');
$form->addSubmit('send', 'Odeslat')->setAttribute('class', 'btn btn-danger');
$form->onSuccess[] = array($this, 'newsletterFormSucceeded');
$form->setDefaults($this->loadFormValues());
return $form;
}
public function eventTicketFormSucceeded(Nette\Application\UI\Form $form, $values)
{
// Udalost
$event = $this->event->get($values['event_id']);
// Drive zamluvene vstupenky
$duplicite = $this->ticket->where('event_id = ? AND email = ?', [$values['event_id'], $values['email']]);
// Vycerpan limit
if (count($duplicite) >= $event['max_ticket_per_email']) {
$this->flashMessage('Limit na počet vstupenek pro Váš email byl již vyčerpán, použijte jiný email.', 'warning');
$this->redirect('this');
}
// Ulozeni do databaze
try {
$ticket = $this->ticket->insert($values);
} catch (\Exception $e) {
$ticket = false;
}
// Notifikace na email a odeslání vstupenky
if ($ticket) {
$this->mailNotify('SOS - nova vstupenka', 'Uzivatel s emailem ' . $values['email'] . ' si zazadal o vstupenku na akci ' . $event->name . '.', $values);
$this->sendTicket($ticket);
$this->flashMessage('Byla Vám zaslána vstupenka.', 'success');
} else {
$this->flashMessage('Je nám líto, ale došlo k chybě. Pro vstupenku se obraťte se pořadatelku akce.', 'danger');
}
$this->redirect('this');
}
public function search(APIRequest $request)
{
if (!$request->has('query')) {
return response(json_encode(['error' => 'The /search endpoint requires a query parameter'], JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES), 400);
}
$results = Event::elasticFind($request->input('query'));
$resource = new Collection($results, new EventTransformer(), 'event');
// TODO: pagination
return $this->fractal->createData($resource)->toArray();
}
public function handleToggleMain($id)
{
$event = $this->event->get($id);
if (!$event) {
$this->flashMessage('Akce nenalezena.', 'danger');
} else {
$event->update(['main' => !$event->main]);
$this->flashMessage('Akce upravena.', 'success');
}
$this->redirect('default');
}
public function renderDefault()
{
$this->template->event = $this->event->where('date > ?', new \DateTime('now'))->where('date < ?', new \DateTime('+3months'))->order('date ASC');
}
/**
*
* @return string[]|\Illuminate\Database\Eloquent\Collection[]|\Illuminate\Database\Eloquent\static[][]
*/
private function load_nearest_events()
{
$mEvents = new Event();
return ['type' => 'events', 'data' => $mEvents->get_nearest_events([])];
}
/**
* 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;
}
/**
* @param $info
* @param $loc Location
**/
protected function createEvent($info, $loc)
{
// TODO: validate input types
$event = Event::create(['title' => $info['title'], 'description' => $info['description'], 'hash' => $info['hash'], 'starting_time' => Carbon::parse($info['starting_time']), 'url' => $info['url']]);
if (isset($info['ending_time'])) {
$event->ending_time = Carbon::parse($info['ending_time']);
}
if (isset($info['notes'])) {
$event->notes = $info['notes'];
}
$event->location()->associate($loc);
if (isset($info['tags'])) {
foreach ($info['tags'] as $tagName) {
try {
$tag = Tag::whereName($tagName)->firstOrFail();
$event->tags()->save($tag);
} catch (ModelNotFoundException $e) {
$this->raiseIssue("[{$this->name}]: Unknown tag name '{$tagName}'", "The tag '{$tagName}' is not registered.\n\n" . "Full entity info was:\n\n" . var_export($info, true));
continue;
}
}
}
$event->save();
}
public function delete($id, Request $request, Application $app)
{
$event = new Event($app['dbconn']);
if ($event->isEventExist($id)) {
$error = array("message" => "Event {$id} does not exist.");
return $app->json($error, 403);
}
try {
$result = $app['dbconn']->delete('events', array('id' => $id));
if ($result) {
return $app->json(array("message" => "Event {$id} is deleted!"), 201);
} else {
return $app->json($issue_post, 403);
}
} catch (\Exception $e) {
$error = array("message" => $e->getMessage());
return $app->json($error, 403);
}
}
public function delete($id)
{
if ($this->shouldLockIfNoPermission('data.edit')) {
return;
}
if ($this->request->is('post')) {
$eventService = new Event($this->db);
$event = $eventService->findById($id);
$eventService->deleteById($id);
$this->flash->success('Deleted event successfully!');
if ($event !== null) {
$endpoint = idate('m', $event['created']) . '/' . idate('Y', $event['created']);
return $this->redirect('/events/calendar/' . $endpoint);
}
return $this->redirect('/events');
}
$this->set('id', $id);
}
