private function insertOneExtraFeed(EntityManager $em, \Pimple $DI)
{
$feed = new Feed();
$publisher = new FeedPublisher();
$user = $DI['user_alt1'];
$publisher->setUser($user);
$publisher->setIsOwner(true);
$publisher->setFeed($feed);
$feed->addPublisher($publisher);
$feed->setTitle("Feed test, Private for user_alt1!");
$feed->setIsPublic(false);
$feed->setSubtitle("description");
$em->persist($feed);
$em->persist($publisher);
$this->insertOneFeedEntry($em, $DI, $feed, true);
$this->insertOneFeedToken($em, $DI, $feed);
}
/**
* {@inheritDoc}
*/
public function getCreatedOn()
{
$this->__initializer__ && $this->__initializer__->__invoke($this, 'getCreatedOn', array());
return parent::getCreatedOn();
}
/**
* @param Request $request
* @param int $id
* @return Response
*/
public function addPublisherAction(Request $request, $id)
{
$error = '';
try {
/** @var UserRepository $userRepository */
$userRepository = $this->app['repo.users'];
$user = $userRepository->find($request->request->get('usr_id'));
$feed = $this->getFeedRepository()->find($id);
$publisher = new FeedPublisher();
$publisher->setUser($user);
$publisher->setFeed($feed);
$feed->addPublisher($publisher);
$manager = $this->getObjectManager();
$manager->persist($feed);
$manager->persist($publisher);
$manager->flush();
} catch (\Exception $e) {
$error = "An error occured";
}
return $this->app->redirectPath('admin_feeds_feed', ['id' => $id, 'error' => $error]);
}
/**
* {@inheritdoc}
*/
public function apply(base $appbox, Application $app)
{
if (false === $this->hasFeedBackup($app)) {
return false;
}
$sql = 'DELETE FROM Feeds';
$stmt = $app->getApplicationBox()->get_connection()->prepare($sql);
$stmt->execute();
$stmt->closeCursor();
$sql = 'DELETE FROM FeedEntries';
$stmt = $app->getApplicationBox()->get_connection()->prepare($sql);
$stmt->execute();
$stmt->closeCursor();
$sql = 'DELETE FROM FeedPublishers';
$stmt = $app->getApplicationBox()->get_connection()->prepare($sql);
$stmt->execute();
$stmt->closeCursor();
$sql = 'DELETE FROM FeedItems';
$stmt = $app->getApplicationBox()->get_connection()->prepare($sql);
$stmt->execute();
$stmt->closeCursor();
$sql = 'DELETE FROM FeedTokens';
$stmt = $app->getApplicationBox()->get_connection()->prepare($sql);
$stmt->execute();
$stmt->closeCursor();
$sql = 'DELETE FROM AggregateTokens';
$stmt = $app->getApplicationBox()->get_connection()->prepare($sql);
$stmt->execute();
$stmt->closeCursor();
$conn = $app->getApplicationBox()->get_connection();
$sql = 'SELECT id, title, subtitle, public, created_on, updated_on, base_id FROM feeds_backup;';
$stmt = $conn->prepare($sql);
$stmt->execute();
$rs = $stmt->fetchAll(\PDO::FETCH_ASSOC);
$stmt->closeCursor();
$n = 0;
$em = $app['orm.em'];
$fpSql = 'SELECT id, usr_id, owner, created_on FROM feed_publishers WHERE feed_id = :feed_id;';
$fpStmt = $conn->prepare($fpSql);
$feSql = 'SELECT id, title, description, created_on, updated_on, author_name, author_email FROM feed_entries WHERE feed_id = :feed_id AND publisher = :publisher_id;';
$feStmt = $conn->prepare($feSql);
$fiSql = 'SELECT sbas_id, record_id, ord FROM feed_entry_elements WHERE entry_id = :entry_id;';
$fiStmt = $conn->prepare($fiSql);
$ftSql = 'SELECT token, usr_id, aggregated FROM feed_tokens WHERE feed_id = :feed_id;';
$ftStmt = $conn->prepare($ftSql);
$faSql = 'SELECT token, usr_id FROM feed_tokens WHERE aggregated = 1;';
$faStmt = $conn->prepare($faSql);
foreach ($rs as $row) {
$feed = new Feed();
$feed->setTitle($row['title']);
$feed->setSubtitle($row['subtitle']);
$feed->setIconUrl(false);
$feed->setIsPublic($row['public']);
$feed->setCreatedOn(new \DateTime($row['created_on']));
$feed->setUpdatedOn(new \DateTime($row['updated_on']));
$feed->setBaseId($row['base_id']);
$fpStmt->execute([':feed_id' => $row['id']]);
$fpRes = $fpStmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($fpRes as $fpRow) {
if (null === ($user = $this->loadUser($app['orm.em'], $fpRow['usr_id']))) {
continue;
}
$feedPublisher = new FeedPublisher();
$feedPublisher->setFeed($feed);
$feed->addPublisher($feedPublisher);
$feedPublisher->setCreatedOn(new \DateTime($fpRow['created_on']));
$feedPublisher->setIsOwner((bool) $fpRow['owner']);
$feedPublisher->setUser($user);
$feStmt->execute([':feed_id' => $row['id'], ':publisher_id' => $fpRow['id']]);
$feRes = $feStmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($feRes as $feRow) {
$feedEntry = new FeedEntry();
$feedEntry->setFeed($feed);
$feed->addEntry($feedEntry);
$feedEntry->setPublisher($feedPublisher);
$feedEntry->setTitle($feRow['title']);
$feedEntry->setSubtitle($feRow['description']);
$feedEntry->setAuthorName((string) $feRow['author_name']);
$feedEntry->setAuthorEmail((string) $feRow['author_email']);
$feedEntry->setCreatedOn(new \DateTime($feRow['created_on']));
$feedEntry->setUpdatedOn(new \DateTime($feRow['updated_on']));
$fiStmt->execute([':entry_id' => $feRow['id']]);
$fiRes = $fiStmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($fiRes as $fiRow) {
$feedItem = new FeedItem();
$feedItem->setEntry($feedEntry);
$feedEntry->addItem($feedItem);
$feedItem->setOrd($fiRow['ord']);
$feedItem->setSbasId($fiRow['sbas_id']);
$feedItem->setRecordId($fiRow['record_id']);
$em->persist($feedItem);
}
$em->persist($feedEntry);
}
$em->persist($feedPublisher);
}
$ftStmt->execute([':feed_id' => $row['id']]);
$ftRes = $ftStmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($ftRes as $ftRow) {
if (null === ($user = $this->loadUser($app['orm.em'], $ftRow['usr_id']))) {
continue;
}
$token = new FeedToken();
$token->setFeed($feed);
$feed->addToken($token);
$token->setUser($user);
$token->setValue($ftRow['token']);
$em->persist($token);
}
$em->persist($feed);
$n++;
if ($n % 100 === 0) {
$em->flush();
$em->clear();
}
}
$fiStmt->closeCursor();
$feStmt->closeCursor();
$fpStmt->closeCursor();
$ftStmt->closeCursor();
$faStmt->execute();
$faRes = $faStmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($faRes as $faRow) {
if (null === ($user = $this->loadUser($app['orm.em'], $faRow['usr_id']))) {
continue;
}
$token = new AggregateToken();
$token->setUser($user);
$token->setValue($faRow['token']);
$em->persist($token);
}
$faStmt->closeCursor();
$em->flush();
$em->clear();
return true;
}
public function connect(Application $app)
{
$app['controller.admin.publications'] = $this;
$controllers = $app['controllers_factory'];
$app['firewall']->addMandatoryAuthentication($controllers);
$controllers->before(function (Request $request) use($app) {
$app['firewall']->requireAccessToModule('admin')->requireRight('bas_chupub');
});
$controllers->get('/list/', function (PhraseaApplication $app) {
$feeds = $app['EM']->getRepository('Phraseanet:Feed')->getAllForUser($app['acl']->get($app['authentication']->getUser()));
return $app['twig']->render('admin/publications/list.html.twig', ['feeds' => $feeds]);
})->bind('admin_feeds_list');
$controllers->post('/create/', function (PhraseaApplication $app, Request $request) {
if ('' === ($title = trim($request->request->get('title', '')))) {
$app->abort(400, "Bad request");
}
$publisher = new FeedPublisher();
$feed = new Feed();
$publisher->setFeed($feed);
$publisher->setUser($app['authentication']->getUser());
$publisher->setIsOwner(true);
$feed->addPublisher($publisher);
$feed->setTitle($title);
$feed->setSubtitle($request->request->get('subtitle', ''));
if ($request->request->get('public') == '1') {
$feed->setIsPublic(true);
} elseif ($request->request->get('base_id')) {
$feed->setCollection(\collection::get_from_base_id($app, $request->request->get('base_id')));
}
$publisher->setFeed($feed);
$app['EM']->persist($feed);
$app['EM']->persist($publisher);
$app['EM']->flush();
return $app->redirectPath('admin_feeds_list');
})->bind('admin_feeds_create');
$controllers->get('/feed/{id}/', function (PhraseaApplication $app, Request $request, $id) {
$feed = $app["EM"]->find('Phraseanet:Feed', $id);
return $app['twig']->render('admin/publications/fiche.html.twig', ['feed' => $feed, 'error' => $app['request']->query->get('error')]);
})->bind('admin_feeds_feed')->assert('id', '\\d+');
$controllers->post('/feed/{id}/update/', function (PhraseaApplication $app, Request $request, $id) {
if ('' === ($title = trim($request->request->get('title', '')))) {
$app->abort(400, "Bad request");
}
$feed = $app["EM"]->find('Phraseanet:Feed', $id);
try {
$collection = \collection::get_from_base_id($app, $request->request->get('base_id'));
} catch (\Exception $e) {
$collection = null;
}
$feed->setTitle($title);
$feed->setSubtitle($request->request->get('subtitle', ''));
$feed->setCollection($collection);
$feed->setIsPublic('1' === $request->request->get('public'));
$app['EM']->persist($feed);
$app['EM']->flush();
return $app->redirectPath('admin_feeds_list');
})->before(function (Request $request) use($app) {
$feed = $app["EM"]->find('Phraseanet:Feed', $request->attributes->get('id'));
if (!$feed->isOwner($app['authentication']->getUser())) {
return $app->redirectPath('admin_feeds_feed', ['id' => $request->attributes->get('id'), 'error' => $app->trans('You are not the owner of this feed, you can not edit it')]);
}
})->bind('admin_feeds_feed_update')->assert('id', '\\d+');
$controllers->post('/feed/{id}/iconupload/', function (PhraseaApplication $app, Request $request, $id) {
$datas = ['success' => false, 'message' => ''];
$feed = $app["EM"]->find('Phraseanet:Feed', $id);
if (null === $feed) {
$app->abort(404, "Feed not found");
}
$request = $app["request"];
if (!$feed->isOwner($app['authentication']->getUser())) {
$app->abort(403, "Access Forbidden");
}
try {
if (!$request->files->get('files')) {
throw new BadRequestHttpException('Missing file parameter');
}
if (count($request->files->get('files')) > 1) {
throw new BadRequestHttpException('Upload is limited to 1 file per request');
}
$file = current($request->files->get('files'));
if (!$file->isValid()) {
throw new BadRequestHttpException('Uploaded file is invalid');
}
$media = $app['mediavorus']->guess($file->getPathname());
if ($media->getType() !== \MediaVorus\Media\MediaInterface::TYPE_IMAGE) {
throw new BadRequestHttpException('Bad filetype');
}
$spec = new \MediaAlchemyst\Specification\Image();
$spec->setResizeMode(\MediaAlchemyst\Specification\Image::RESIZE_MODE_OUTBOUND);
$spec->setDimensions(32, 32);
$spec->setStrip(true);
$spec->setQuality(72);
$tmpname = tempnam(sys_get_temp_dir(), 'feed_icon') . '.png';
try {
$app['media-alchemyst']->turnInto($media->getFile()->getPathname(), $tmpname, $spec);
} catch (\MediaAlchemyst\Exception\ExceptionInterface $e) {
throw new \Exception_InternalServerError('Error while resizing');
}
unset($media);
$feed->setIconUrl(true);
$app['EM']->persist($feed);
$app['EM']->flush();
$app['filesystem']->copy($tmpname, $app['root.path'] . '/config/feed_' . $feed->getId() . '.jpg');
$app['filesystem']->copy($tmpname, sprintf('%s/www/custom/feed_%d.jpg', $app['root.path'], $feed->getId()));
$app['filesystem']->remove($tmpname);
$datas['success'] = true;
} catch (\Exception $e) {
$datas['message'] = $app->trans('Unable to add file to Phraseanet');
}
return $app->json($datas);
})->bind('admin_feeds_feed_icon')->assert('id', '\\d+');
$controllers->post('/feed/{id}/addpublisher/', function (PhraseaApplication $app, $id) {
$error = '';
try {
$request = $app['request'];
$user = $app['manipulator.user']->getRepository()->find($request->request->get('usr_id'));
$feed = $app["EM"]->find('Phraseanet:Feed', $id);
$publisher = new FeedPublisher();
$publisher->setUser($user);
$publisher->setFeed($feed);
$feed->addPublisher($publisher);
$app['EM']->persist($feed);
$app['EM']->persist($publisher);
$app['EM']->flush();
} catch (\Exception $e) {
$error = "An error occured";
}
return $app->redirectPath('admin_feeds_feed', ['id' => $id, 'error' => $error]);
})->bind('admin_feeds_feed_add_publisher')->assert('id', '\\d+');
$controllers->post('/feed/{id}/removepublisher/', function (PhraseaApplication $app, $id) {
try {
$request = $app['request'];
$feed = $app["EM"]->find('Phraseanet:Feed', $id);
$publisher = $app["EM"]->find('Phraseanet:FeedPublisher', $request->request->get('publisher_id'));
if (null === $publisher) {
$app->abort(404, "Feed Publisher not found");
}
$user = $publisher->getUser();
if ($feed->isPublisher($user) && !$feed->isOwner($user)) {
$feed->removePublisher($publisher);
$app['EM']->remove($publisher);
$app['EM']->flush();
}
} catch (\Exception $e) {
$error = "An error occured";
}
return $app->redirectPath('admin_feeds_feed', ['id' => $id, 'error' => $error]);
})->bind('admin_feeds_feed_remove_publisher')->assert('id', '\\d+');
$controllers->post('/feed/{id}/delete/', function (PhraseaApplication $app, $id) {
$feed = $app["EM"]->find('Phraseanet:Feed', $id);
if (null === $feed) {
$app->abort(404);
}
if (true === $feed->getIconURL()) {
unlink($app['root.path'] . '/config/feed_' . $feed->getId() . '.jpg');
unlink('custom/feed_' . $feed->getId() . '.jpg');
}
$app['EM']->remove($feed);
$app['EM']->flush();
return $app->redirectPath('admin_feeds_list');
})->bind('admin_feeds_feed_delete')->assert('id', '\\d+');
return $controllers;
}
