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['success'] = $sponsorEvent->delete();
$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);
});
