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 setFeed(\Alchemy\Phrasea\Model\Entities\Feed $feed = NULL) { $this->__initializer__ && $this->__initializer__->__invoke($this, 'setFeed', array($feed)); return parent::setFeed($feed); }
/** * @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; }