public function findBySponsorId($sponsorId) { $sql = 'select e.* from events e, sponsor_event se' . ' where se.event_id = e.id and se.sponsor_id = :sponsorId'; $results = $this->fetch($sql, ['sponsorId' => $sponsorId]); foreach ($results as $result) { $event = new \Conftrack\Model\Event($this->getDb()); $event->load($result, false); $this->add($event); } }
$data['message'] = 'Sponsor removed successfully'; } catch (\Exception $e) { $data['message'] = "Error: " . implode("\n", $sponsorEvent->getMessages()); } return $response->withJson($data); }); $app->post('/create', function ($request, $response, $args) { $body = $request->getParsedBody(); $message = ''; $data = ['success' => false]; $sponsors = new \Conftrack\Collection\Sponsors($this->getContainer()->get('db')); $sponsors->findAll(); $startDate = new \DateTime($body['start_date']); $endDate = new \DateTime($body['end_date']); $event = new \Conftrack\Model\Event($this->getContainer()->get('db')); $event->load(['name' => $body['name'], 'start_date' => $startDate->format('Y-m-d H:i:s'), 'end_date' => $endDate->format('Y-m-d H:i:s')]); try { $event->verify(); $event->save(); $data['success'] = true; $message = 'Event created successfully!'; } catch (\Exception $e) { error_log($e->getMessage()); $message = "Error: " . implode("\n", $event->getMessages()); } $type = $data['success'] == false ? 'danger' : 'success'; $this->flash->addMessage($type, $message); $data = ['sponsors' => $sponsors->toArray(true)]; $this->view->render($response, 'event/create.twig', $data); }); });