/** * Returns a new ChildColissimoFreeshippingQuery object. * * @param string $modelAlias The alias of a model in the query * @param Criteria $criteria Optional Criteria to build the query from * * @return ChildColissimoFreeshippingQuery */ public static function create($modelAlias = null, $criteria = null) { if ($criteria instanceof \Colissimo\Model\ColissimoFreeshippingQuery) { return $criteria; } $query = new \Colissimo\Model\ColissimoFreeshippingQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
/** * @param $areaId * @param $weight * * @return mixed * @throws \Thelia\Exception\OrderException */ public static function getPostageAmount($areaId, $weight) { $freeshipping = ColissimoFreeshippingQuery::create()->getLast(); $postage = 0; if (!$freeshipping) { $prices = self::getPrices(); /* check if Colissimo delivers the asked area */ if (!isset($prices[$areaId]) || !isset($prices[$areaId]["slices"])) { throw new DeliveryException(Translator::getInstance()->trans("Colissimo delivery unavailable for the delivery country", [], self::MESSAGE_DOMAIN)); } $areaPrices = $prices[$areaId]["slices"]; ksort($areaPrices); /* Check cart weight is below the maximum weight */ end($areaPrices); $maxWeight = key($areaPrices); if ($weight > $maxWeight) { throw new DeliveryException(Translator::getInstance()->trans("Colissimo delivery unavailable for this cart weight (%weight kg)", array("%weight" => $weight), self::MESSAGE_DOMAIN)); } $postage = current($areaPrices); while (prev($areaPrices)) { if ($weight > key($areaPrices)) { break; } $postage = current($areaPrices); } } return $postage; }
/** * Performs an INSERT on the database, given a ColissimoFreeshipping or Criteria object. * * @param mixed $criteria Criteria or ColissimoFreeshipping 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(ColissimoFreeshippingTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from ColissimoFreeshipping object } if ($criteria->containsKey(ColissimoFreeshippingTableMap::ID) && $criteria->keyContainsValue(ColissimoFreeshippingTableMap::ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . ColissimoFreeshippingTableMap::ID . ')'); } // Set the correct dbName $query = ColissimoFreeshippingQuery::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; }
/** * * in this function you add all the fields you need for your Form. * Form this you have to call add method on $this->formBuilder attribute : * * $this->formBuilder->add("name", "text") * ->add("email", "email", array( * "attr" => array( * "class" => "field" * ), * "label" => "email", * "constraints" => array( * new \Symfony\Component\Validator\Constraints\NotBlank() * ) * ) * ) * ->add('age', 'integer'); * * @return null */ protected function buildForm() { $freeshipping = ColissimoFreeshippingQuery::create()->getLast(); $this->formBuilder->add("freeshipping", "checkbox", array('data' => $freeshipping, 'label' => Translator::getInstance()->trans("Activate free shipping: ", [], Colissimo::MESSAGE_DOMAIN))); }
/** * Removes this object from datastore and sets delete attribute. * * @param ConnectionInterface $con * @return void * @throws PropelException * @see ColissimoFreeshipping::setDeleted() * @see ColissimoFreeshipping::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(ColissimoFreeshippingTableMap::DATABASE_NAME); } $con->beginTransaction(); try { $deleteQuery = ChildColissimoFreeshippingQuery::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; } }