public function buildModelCriteria() { $areaId = $this->getAreaId(); $modeId = $this->getDeliveryModeId(); $areaPrices = SocolissimoPriceQuery::create()->filterByDeliveryModeId($modeId)->filterByAreaId($areaId)->orderByWeightMax(); return $areaPrices; }
public function deletePrice() { if (null !== ($response = $this->checkAuth(array(AdminResources::MODULE), array('SoColissimo'), AccessManager::DELETE))) { return $response; } $data = $this->getRequest()->request; SocolissimoPriceQuery::create()->filterByAreaId($data->get('area'))->filterByDeliveryModeId($data->get('delivery_mode'))->findOneByWeightMax($data->get('weight'))->delete(); return $this->priceTabResponse($data->get('delivery_mode')); }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this SocolissimoDeliveryMode is new, it will return * an empty collection; or if this SocolissimoDeliveryMode has previously * been saved, it will retrieve related SocolissimoPrices 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 SocolissimoDeliveryMode. * * @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|ChildSocolissimoPrice[] List of ChildSocolissimoPrice objects */ public function getSocolissimoPricesJoinArea($criteria = null, $con = null, $joinBehavior = Criteria::LEFT_JOIN) { $query = ChildSocolissimoPriceQuery::create(null, $criteria); $query->joinWith('Area', $joinBehavior); return $this->getSocolissimoPrices($query, $con); }
/** * Removes this object from datastore and sets delete attribute. * * @param ConnectionInterface $con * @return void * @throws PropelException * @see SocolissimoPrice::setDeleted() * @see SocolissimoPrice::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(SocolissimoPriceTableMap::DATABASE_NAME); } $con->beginTransaction(); try { $deleteQuery = ChildSocolissimoPriceQuery::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; } }
public static function importJsonPrice(SocolissimoDeliveryMode $deliveryMode, ConnectionInterface $con) { $areaPrices = self::getPrices($deliveryMode); $priceExist = SocolissimoPriceQuery::create()->filterByDeliveryModeId($deliveryMode->getId())->findOne(); //If at least one price exist doesn't import the xml (or it will erase the user price) if (null !== $priceExist) { return; } $con->beginTransaction(); try { foreach ($areaPrices as $areaId => $area) { foreach ($area['slices'] as $weight => $price) { $slice = (new SocolissimoPrice())->setAreaId($areaId)->setWeightMax($weight)->setPrice($price)->setDeliveryModeId($deliveryMode->getId()); $slice->save(); } $con->commit(); } } catch (PropelException $e) { $con->rollback(); throw $e; } }
/** * Performs an INSERT on the database, given a SocolissimoPrice or Criteria object. * * @param mixed $criteria Criteria or SocolissimoPrice 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(SocolissimoPriceTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from SocolissimoPrice object } if ($criteria->containsKey(SocolissimoPriceTableMap::ID) && $criteria->keyContainsValue(SocolissimoPriceTableMap::ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . SocolissimoPriceTableMap::ID . ')'); } // Set the correct dbName $query = SocolissimoPriceQuery::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; }