Aimeos\MShop\Customer\Manager\Ezpublish::saveItem()

Complexity

Conditions	7
Paths	141

Size

Total Lines	102
Code Lines	55

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
	public function saveItem( \Aimeos\MShop\Common\Item\Iface $item, $fetch = true )
	{
		$iface = '\\Aimeos\\MShop\\Customer\\Item\\Iface';
		if( !( $item instanceof $iface ) ) {
			throw new \Aimeos\MShop\Customer\Exception( sprintf( 'Object is not of required type "%1$s"', $iface ) );
		}

		if( !$item->isModified() ) { return; }

		$context = $this->getContext();

		$class = '\Aimeos\MShop\Context\Item\Ezpublish';
		if( !is_a( $context, $class ) ) {
			throw new \Aimeos\MShop\Customer\Exception( sprintf( 'Object is not of required type "%1$s"', $class ) );
		}

		if( $item->getId() === null )
		{
			$fcn = $context->getEzUser();
			$contentId = $fcn( $item->getCode(), $item->getPaymentAddress()->getEmail(), $item->getPassword() );
			$item->setId( $contentId );
		}

		$dbm = $context->getDatabaseManager();
		$dbname = $this->getResourceName();
		$conn = $dbm->acquire( $dbname );

		try
		{
			$date = date( 'Y-m-d H:i:s' );
			$ctime = ( $item->getTimeCreated() ? $item->getTimeCreated() : $date );
			$billingAddress = $item->getPaymentAddress();

			/** mshop/customer/manager/ezpublish/update
			 * Updates an existing customer record in the database
			 *
			 * Items which already have an ID (i.e. the ID is not NULL) will
			 * be updated in the database.
			 *
			 * The SQL statement must be a string suitable for being used as
			 * prepared statement. It must include question marks for binding
			 * the values from the customer item to the statement before they are
			 * sent to the database server. The order of the columns must
			 * correspond to the order in the saveItems() method, so the
			 * correct values are bound to the columns.
			 *
			 * The SQL statement should conform to the ANSI standard to be
			 * compatible with most relational database systems. This also
			 * includes using double quotes for table and column names.
			 *
			 * @param string SQL statement for updating records
			 * @since 2016.07
			 * @category Developer
			 * @see mshop/customer/manager/ezpublish/insert
			 * @see mshop/customer/manager/ezpublish/newid
			 * @see mshop/customer/manager/ezpublish/delete
			 * @see mshop/customer/manager/ezpublish/search
			 * @see mshop/customer/manager/ezpublish/count
			 */
			$path = 'mshop/customer/manager/ezpublish/update';

			$stmt = $this->getCachedStatement( $conn, $path );

			$stmt->bind( 1, $item->getCode() ); // login normalized
			$stmt->bind( 2, $item->getCode() ); // login
			$stmt->bind( 3, $billingAddress->getCompany() );
			$stmt->bind( 4, $billingAddress->getVatID() );
			$stmt->bind( 5, $billingAddress->getSalutation() );
			$stmt->bind( 6, $billingAddress->getTitle() );
			$stmt->bind( 7, $billingAddress->getFirstname() );
			$stmt->bind( 8, $billingAddress->getLastname() );
			$stmt->bind( 9, $billingAddress->getAddress1() );
			$stmt->bind( 10, $billingAddress->getAddress2() );
			$stmt->bind( 11, $billingAddress->getAddress3() );
			$stmt->bind( 12, $billingAddress->getPostal() );
			$stmt->bind( 13, $billingAddress->getCity() );
			$stmt->bind( 14, $billingAddress->getState() );
			$stmt->bind( 15, $billingAddress->getCountryId() );
			$stmt->bind( 16, $billingAddress->getLanguageId() );
			$stmt->bind( 17, $billingAddress->getTelephone() );
			$stmt->bind( 18, $billingAddress->getEmail() );
			$stmt->bind( 19, $billingAddress->getTelefax() );
			$stmt->bind( 20, $billingAddress->getWebsite() );
			$stmt->bind( 21, $item->getBirthday() );
			$stmt->bind( 22, $item->getStatus(), \Aimeos\MW\DB\Statement\Base::PARAM_INT );
			$stmt->bind( 23, $item->getDateVerified() );
			$stmt->bind( 24, $item->getPassword() );
			$stmt->bind( 25, $date ); // Modification time
			$stmt->bind( 26, $context->getEditor() );
			$stmt->bind( 27, $ctime ); // Creation time
			$stmt->bind( 28, $item->getId(), \Aimeos\MW\DB\Statement\Base::PARAM_INT );

			$stmt->execute()->finish();

			$dbm->release( $conn, $dbname );
		}
		catch( \Exception $e )
		{
			$dbm->release( $conn, $dbname );
			throw $e;
		}
	}