Aimeos\MShop\Index\Manager\Price\Standard::savePrices()

Complexity

Conditions	8
Paths	12

Size

Total Lines	48
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	protected function savePrices( \Aimeos\MW\DB\Statement\Iface $stmt, \Aimeos\MShop\Common\Item\ListRef\Iface $item )
	{
		$prices = [];
		$date = date( 'Y-m-d H:i:s' );
		$context = $this->getContext();
		$siteid = $context->getLocale()->getSiteId();

		/** mshop/index/manager/price/types
		 * Use different product prices types for indexing
		 *
		 * In some cases, prices are stored with different types, eg. price per kg.
		 * This configuration option defines which types are incorporated in which
		 * order. If a price of the defined type with the lowest index is available,
		 * it will be indexed, otherwise the next lowest index price type. It is
		 * highly recommended to add the price type 'default' with the highest index.
		 *
		 * @param array List of price types codes
		 * @since 2019.04
		 * @category Developer
		 */
		$types = $context->getConfig()->get( 'mshop/index/manager/price/types', ['default'] );

		foreach( $types as $priceType )
		{
			foreach( $item->getListItems( 'price', 'default', $priceType ) as $listItem )
			{
				if( ( $refItem = $listItem->getRefItem() ) !== null
					&& $refItem->isAvailable()
					&& !isset ( $prices[$refItem->getCurrencyId()][$refItem->getQuantity()] )
				) {
					$prices[$refItem->getCurrencyId()][$refItem->getQuantity()] = $refItem->getValue();
				}
			}
		}

		foreach( $prices as $currencyId => $list )
		{
			ksort( $list );

			$stmt->bind( 1, $item->getId(), \Aimeos\MW\DB\Statement\Base::PARAM_INT );
			$stmt->bind( 2, $currencyId );
			$stmt->bind( 3, reset( $list ) );
			$stmt->bind( 4, $date ); // mtime
			$stmt->bind( 5, $siteid, \Aimeos\MW\DB\Statement\Base::PARAM_INT );

			try {
				$stmt->execute()->finish();
			} catch( \Aimeos\MW\DB\Exception $e ) { ; } // Ignore duplicates
		}