Exemple #1
0
 public function buildModelCriteria()
 {
     $product = $this->getProduct();
     $category = $this->getCategory();
     if ($product === null && $category === null) {
         throw new \InvalidArgumentException('You have to provide either `product` or `category` argument in associated_content loop');
     }
     if ($product !== null) {
         /** @var ProductAssociatedContentQuery $search */
         $search = ProductAssociatedContentQuery::create();
         $search->filterByProductId($product, Criteria::EQUAL);
     } elseif ($category !== null) {
         /** @var CategoryAssociatedContentQuery $search */
         $search = CategoryAssociatedContentQuery::create();
         $search->filterByCategoryId($category, Criteria::EQUAL);
     }
     $excludeProduct = $this->getExcludeProduct();
     // If we have to filter by product, find all products assigned to this product, and filter by found IDs
     if (null !== $excludeProduct) {
         // Exclude all contents related to the given product
         $search->filterById(ProductAssociatedContentQuery::create()->filterByProductId($excludeProduct)->select('product_id')->find(), Criteria::NOT_IN);
     }
     $excludeCategory = $this->getExcludeCategory();
     // If we have to filter by category, find all contents assigned to this category, and filter by found IDs
     if (null !== $excludeCategory) {
         // Exclure tous les attribut qui sont attachés aux templates indiqués
         $search->filterById(CategoryAssociatedContentQuery::create()->filterByProductId($excludeCategory)->select('category_id')->find(), Criteria::NOT_IN);
     }
     $order = $this->getOrder();
     $orderByAssociatedContent = array_search('associated_content', $order);
     $orderByAssociatedContentReverse = array_search('associated_content_reverse', $order);
     if ($orderByAssociatedContent !== false) {
         $search->orderByPosition(Criteria::ASC);
         $order[$orderByAssociatedContent] = 'given_id';
         $this->args->get('order')->setValue(implode(',', $order));
     }
     if ($orderByAssociatedContentReverse !== false) {
         $search->orderByPosition(Criteria::DESC);
         $order[$orderByAssociatedContentReverse] = 'given_id';
         $this->args->get('order')->setValue(implode(',', $order));
     }
     $associatedContents = $this->search($search);
     $associatedContentIdList = array(0);
     $this->contentPosition = $this->contentId = array();
     foreach ($associatedContents as $associatedContent) {
         $associatedContentId = $associatedContent->getContentId();
         array_push($associatedContentIdList, $associatedContentId);
         $this->contentPosition[$associatedContentId] = $associatedContent->getPosition();
         $this->contentId[$associatedContentId] = $associatedContent->getId();
     }
     $receivedIdList = $this->getId();
     /* if an Id list is receive, loop will only match accessories from this list */
     if ($receivedIdList === null) {
         $this->args->get('id')->setValue(implode(',', $associatedContentIdList));
     } else {
         $this->args->get('id')->setValue(implode(',', array_intersect($receivedIdList, $associatedContentIdList)));
     }
     return parent::buildModelCriteria();
 }
Exemple #2
0
 public function preImport()
 {
     // Delete table before proceeding
     ProductQuery::create()->deleteAll();
     CategoryQuery::create()->deleteAll();
     FeatureTemplateQuery::create()->deleteAll();
     AttributeTemplateQuery::create()->deleteAll();
     TemplateQuery::create()->deleteAll();
     CategoryImageQuery::create()->deleteAll();
     CategoryDocumentQuery::create()->deleteAll();
     CategoryAssociatedContentQuery::create()->deleteAll();
     // Create T1 <-> T2 IDs correspondance tables
     $this->cat_corresp->reset();
     $this->tpl_corresp->reset();
 }
Exemple #3
0
 /**
  * If this collection has already been initialized with
  * an identical criteria, it returns the collection.
  * Otherwise if this Content is new, it will return
  * an empty collection; or if this Content has previously
  * been saved, it will retrieve related CategoryAssociatedContents from storage.
  *
  * This method is protected by default in order to keep the public
  * api reasonable.  You can provide public methods for those you
  * actually need in Content.
  *
  * @param      Criteria $criteria optional Criteria object to narrow the query
  * @param      ConnectionInterface $con optional connection object
  * @param      string $joinBehavior optional join type to use (defaults to Criteria::LEFT_JOIN)
  * @return Collection|ChildCategoryAssociatedContent[] List of ChildCategoryAssociatedContent objects
  */
 public function getCategoryAssociatedContentsJoinCategory($criteria = null, $con = null, $joinBehavior = Criteria::LEFT_JOIN)
 {
     $query = ChildCategoryAssociatedContentQuery::create(null, $criteria);
     $query->joinWith('Category', $joinBehavior);
     return $this->getCategoryAssociatedContents($query, $con);
 }
 public function getAvailableRelatedContentAction($categoryId, $folderId)
 {
     $result = array();
     $folders = FolderQuery::create()->filterById($folderId)->find();
     if ($folders !== null) {
         $list = ContentQuery::create()->joinWithI18n($this->getCurrentEditionLocale())->filterByFolder($folders, Criteria::IN)->filterById(CategoryAssociatedContentQuery::create()->select('content_id')->findByCategoryId($categoryId), Criteria::NOT_IN)->find();
         if ($list !== null) {
             foreach ($list as $item) {
                 $result[] = array('id' => $item->getId(), 'title' => $item->getTitle());
             }
         }
     }
     return $this->jsonResponse(json_encode($result));
 }
Exemple #5
0
$localizedFaker = [];
foreach ($localeList as $locale) {
    $localizedFaker[$locale] = Faker\Factory::create($locale);
}
$con = \Propel\Runtime\Propel::getConnection(Thelia\Model\Map\ProductTableMap::DATABASE_NAME);
$con->beginTransaction();
// Intialize URL management
$url = new Thelia\Tools\URL();
$currency = \Thelia\Model\CurrencyQuery::create()->filterByCode('EUR')->findOne();
//\Thelia\Log\Tlog::getInstance()->setLevel(\Thelia\Log\Tlog::ERROR);
try {
    $stmt = $con->prepare("SET foreign_key_checks = 0");
    $stmt->execute();
    echo "Clearing tables\n";
    Model\ProductAssociatedContentQuery::create()->deleteAll();
    Model\CategoryAssociatedContentQuery::create()->deleteAll();
    Model\FeatureProductQuery::create()->deleteAll();
    Model\AttributeCombinationQuery::create()->deleteAll();
    Model\FeatureQuery::create()->deleteAll();
    Model\FeatureI18nQuery::create()->deleteAll();
    Model\FeatureAvQuery::create()->deleteAll();
    Model\FeatureAvI18nQuery::create()->deleteAll();
    Model\AttributeQuery::create()->deleteAll();
    Model\AttributeI18nQuery::create()->deleteAll();
    Model\AttributeAvQuery::create()->deleteAll();
    Model\AttributeAvI18nQuery::create()->deleteAll();
    Model\CategoryQuery::create()->deleteAll();
    Model\CategoryI18nQuery::create()->deleteAll();
    Model\ProductQuery::create()->deleteAll();
    Model\ProductI18nQuery::create()->deleteAll();
    Model\CustomerQuery::create()->deleteAll();
Exemple #6
0
 public function removeContent(CategoryDeleteContentEvent $event)
 {
     $content = CategoryAssociatedContentQuery::create()->filterByContentId($event->getContentId())->filterByCategory($event->getCategory())->findOne();
     if ($content !== null) {
         $content->setDispatcher($event->getDispatcher())->delete();
     }
 }
 /**
  * Performs an INSERT on the database, given a CategoryAssociatedContent or Criteria object.
  *
  * @param mixed               $criteria Criteria or CategoryAssociatedContent object containing data that is used to create the INSERT statement.
  * @param ConnectionInterface $con the ConnectionInterface connection to use
  * @return mixed           The new primary key.
  * @throws PropelException Any exceptions caught during processing will be
  *         rethrown wrapped into a PropelException.
  */
 public static function doInsert($criteria, ConnectionInterface $con = null)
 {
     if (null === $con) {
         $con = Propel::getServiceContainer()->getWriteConnection(CategoryAssociatedContentTableMap::DATABASE_NAME);
     }
     if ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
         // rename for clarity
     } else {
         $criteria = $criteria->buildCriteria();
         // build Criteria from CategoryAssociatedContent object
     }
     if ($criteria->containsKey(CategoryAssociatedContentTableMap::ID) && $criteria->keyContainsValue(CategoryAssociatedContentTableMap::ID)) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . CategoryAssociatedContentTableMap::ID . ')');
     }
     // Set the correct dbName
     $query = CategoryAssociatedContentQuery::create()->mergeWith($criteria);
     try {
         // use transaction because $criteria could contain info
         // for more than one table (I guess, conceivably)
         $con->beginTransaction();
         $pk = $query->doInsert($con);
         $con->commit();
     } catch (PropelException $e) {
         $con->rollBack();
         throw $e;
     }
     return $pk;
 }
 /**
  * Removes this object from datastore and sets delete attribute.
  *
  * @param      ConnectionInterface $con
  * @return void
  * @throws PropelException
  * @see CategoryAssociatedContent::setDeleted()
  * @see CategoryAssociatedContent::isDeleted()
  */
 public function delete(ConnectionInterface $con = null)
 {
     if ($this->isDeleted()) {
         throw new PropelException("This object has already been deleted.");
     }
     if ($con === null) {
         $con = Propel::getServiceContainer()->getWriteConnection(CategoryAssociatedContentTableMap::DATABASE_NAME);
     }
     $con->beginTransaction();
     try {
         $deleteQuery = ChildCategoryAssociatedContentQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
         $ret = $this->preDelete($con);
         if ($ret) {
             $deleteQuery->delete($con);
             $this->postDelete($con);
             $con->commit();
             $this->setDeleted(true);
         } else {
             $con->commit();
         }
     } catch (Exception $e) {
         $con->rollBack();
         throw $e;
     }
 }