/** * this method returns a Propel ModelCriteria * * @return \Propel\Runtime\ActiveQuery\ModelCriteria */ public function buildModelCriteria() { $search = CustomerCustomerFamilyQuery::create(); if (null !== ($customerId = $this->getCustomerId())) { $search->filterByCustomerId($customerId, Criteria::IN); } if (null !== ($customerFamilyId = $this->getCustomerFamilyId())) { $search->filterByCustomerFamilyId($customerFamilyId, Criteria::IN); } return $search; }
/** * Removes this object from datastore and sets delete attribute. * * @param ConnectionInterface $con * @return void * @throws PropelException * @see CustomerCustomerFamily::setDeleted() * @see CustomerCustomerFamily::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(CustomerCustomerFamilyTableMap::DATABASE_NAME); } $con->beginTransaction(); try { $deleteQuery = ChildCustomerCustomerFamilyQuery::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; } }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this CustomerFamily is new, it will return * an empty collection; or if this CustomerFamily has previously * been saved, it will retrieve related CustomerCustomerFamilies 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 CustomerFamily. * * @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|ChildCustomerCustomerFamily[] List of ChildCustomerCustomerFamily objects */ public function getCustomerCustomerFamiliesJoinCustomer($criteria = null, $con = null, $joinBehavior = Criteria::LEFT_JOIN) { $query = ChildCustomerCustomerFamilyQuery::create(null, $criteria); $query->joinWith('Customer', $joinBehavior); return $this->getCustomerCustomerFamilies($query, $con); }
/** * Callback used to add some fields to the Thelia's CustomerCreateForm. * It add two fields : one for the SIRET number and one for VAT. * @param TheliaFormEvent $event */ public function addCustomerFamilyFieldsForUpdate(TheliaFormEvent $event) { // Adding new fields $customer = $this->request->getSession()->getCustomerUser(); if (is_null($customer)) { // No customer => no account update => stop here return; } $customerCustomerFamily = CustomerCustomerFamilyQuery::create()->findOneByCustomerId($customer->getId()); $cfData = array(self::CUSTOMER_FAMILY_CODE_FIELD_NAME => (is_null($customerCustomerFamily) or is_null($customerCustomerFamily->getCustomerFamily())) ? '' : $customerCustomerFamily->getCustomerFamily()->getCode(), self::CUSTOMER_FAMILY_SIRET_FIELD_NAME => is_null($customerCustomerFamily) ? false : $customerCustomerFamily->getSiret(), self::CUSTOMER_FAMILY_VAT_FIELD_NAME => is_null($customerCustomerFamily) ? false : $customerCustomerFamily->getVat()); // Retrieving CustomerFamily choices $customerFamilyChoices = array(); /** @var \CustomerFamily\Model\CustomerFamily $customerFamilyChoice */ foreach (CustomerFamilyQuery::create()->find() as $customerFamilyChoice) { $customerFamilyChoices[$customerFamilyChoice->getCode()] = self::trans($customerFamilyChoice->getTitle()); } // Building additional fields $event->getForm()->getFormBuilder()->add(self::CUSTOMER_FAMILY_CODE_FIELD_NAME, 'choice', array('constraints' => array(new Constraints\Callback(array('methods' => array(array($this, 'checkCustomerFamily')))), new Constraints\NotBlank()), 'choices' => $customerFamilyChoices, 'empty_data' => false, 'required' => false, 'label' => self::trans('Customer family'), 'label_attr' => array('for' => 'customer_family_id'), 'mapped' => false, 'data' => $cfData[self::CUSTOMER_FAMILY_CODE_FIELD_NAME]))->add(self::CUSTOMER_FAMILY_SIRET_FIELD_NAME, 'text', array('required' => true, 'empty_data' => false, 'label' => self::trans('Siret number'), 'label_attr' => array('for' => 'siret'), 'mapped' => false, 'data' => $cfData[self::CUSTOMER_FAMILY_SIRET_FIELD_NAME]))->add(self::CUSTOMER_FAMILY_VAT_FIELD_NAME, 'text', array('required' => true, 'empty_data' => false, 'label' => self::trans('Vat'), 'label_attr' => array('for' => 'vat'), 'mapped' => false, 'data' => $cfData[self::CUSTOMER_FAMILY_VAT_FIELD_NAME])); }
/** * @param CustomerCustomerFamilyEvent $event */ public function customerCustomerFamilyUpdate(CustomerCustomerFamilyEvent $event) { $customerCustomerFamily = CustomerCustomerFamilyQuery::create()->findOneByCustomerId($event->getCustomerId()); if ($customerCustomerFamily === null) { $customerCustomerFamily = new CustomerCustomerFamily(); $customerCustomerFamily->setCustomerId($event->getCustomerId()); } $customerCustomerFamily->setCustomerFamilyId($event->getCustomerFamilyId())->setSiret($event->getSiret())->setVat($event->getVat())->save(); }
/** * Performs an INSERT on the database, given a CustomerCustomerFamily or Criteria object. * * @param mixed $criteria Criteria or CustomerCustomerFamily 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(CustomerCustomerFamilyTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from CustomerCustomerFamily object } // Set the correct dbName $query = CustomerCustomerFamilyQuery::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; }