public function fileDelete($id) { $file = $this->em->getRepository('Uppu3\\Entity\\File')->findOneById($id); $filePath = \Uppu3\Helper\FormatHelper::formatUploadLink($file->getId(), $file->getName()); if (in_array($file->getExtension(), $this->pictures)) { $fileResizePath = \Uppu3\Helper\FormatHelper::formatUploadResizeLink($file->getId(), $file->getName()); unlink($fileResizePath); } unlink($filePath); $this->em->remove($file); $this->em->flush(); echo "all is done"; die; }
$file = $app->em->find('Uppu3\\Entity\\File', $id); $user = $app->em->getRepository('Uppu3\\Entity\\User')->findOneById($file->getUploadedBy()); if (!$file) { $app->notFound(); } $helper = new FormatHelper(); $comments = $app->em->getRepository('Uppu3\\Entity\\Comment')->findBy(array('fileId' => $id), array('path' => 'ASC')); $app->render('view.html', array('file' => $file, 'user' => $user, 'helper' => $helper, 'comments' => $comments)); }); $app->get('/comment/:id/', function ($id) use($app) { $comment = $app->em->find('Uppu3\\Entity\\Comment', $id); echo $comment->getComment(); }); $app->get('/download/:id/:name', function ($id, $name) use($app) { $file = $app->em->find('Uppu3\\Entity\\File', $id); $name = FormatHelper::formatDownloadFile($id, $file->getName()); if (file_exists($name)) { header("X-Sendfile:" . realpath(dirname(__FILE__)) . '/' . $name); header("Content-Type: application/octet-stream"); header("Content-Disposition: attachment"); return; } else { $app->notFound(); } }); $app->get('/users/', 'checkAuthorization', function () use($app) { $page = 'users'; $users = $app->em->getRepository('Uppu3\\Entity\\User')->findBy([], ['created' => 'DESC']); $filesCount = $app->em->createQuery('SELECT IDENTITY(u.uploadedBy), count(u.uploadedBy) FROM Uppu3\\Entity\\File u GROUP BY u.uploadedBy'); $filesCount = $filesCount->getArrayResult(); $list = [];