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