Aimeos\MShop\Locale\Manager\Language\Standard::saveItem()

Complexity

Conditions	6
Paths	72

Size

Total Lines	121
Code Lines	36

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function saveItem( \Aimeos\MShop\Common\Item\Iface $item, $fetch = true )
	{
		self::checkClass( \Aimeos\MShop\Locale\Item\Language\Iface::class, $item );

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

		$context = $this->getContext();

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

		try
		{
			$id = $item->getId();
			$date = date( 'Y-m-d H:i:s' );
			$columns = $this->getObject()->getSaveAttributes();

			if( $id === null )
			{
				/** mshop/locale/manager/language/standard/insert/mysql
				 * Inserts a new language record into the database table
				 *
				 * @see mshop/locale/manager/language/standard/insert/ansi
				 */

				/** mshop/locale/manager/language/standard/insert/ansi
				 * Inserts a new language record into the database table
				 *
				 * 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 language item to the statement before they are
				 * sent to the database server. The number of question marks must
				 * be the same as the number of columns listed in the INSERT
				 * statement. 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 inserting records
				 * @since 2014.03
				 * @category Developer
				 * @see mshop/locale/manager/language/standard/update/ansi
				 * @see mshop/locale/manager/language/standard/delete/ansi
				 * @see mshop/locale/manager/language/standard/search/ansi
				 * @see mshop/locale/manager/language/standard/count/ansi
				 */
				$path = 'mshop/locale/manager/language/standard/insert';
				$sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) );
			}
			else
			{
				/** mshop/locale/manager/language/standard/update/mysql
				 * Updates an existing language record in the database
				 *
				 * @see mshop/locale/manager/language/standard/update/ansi
				 */

				/** mshop/locale/manager/language/standard/update/ansi
				 * Updates an existing language record 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 language 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 2014.03
				 * @category Developer
				 * @see mshop/locale/manager/language/standard/insert/ansi
				 * @see mshop/locale/manager/language/standard/delete/ansi
				 * @see mshop/locale/manager/language/standard/search/ansi
				 * @see mshop/locale/manager/language/standard/count/ansi
				 */
				$path = 'mshop/locale/manager/language/standard/update';
				$sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ), false );
			}

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

			foreach( $columns as $name => $entry ) {
				$stmt->bind( $idx++, $item->get( $name ), $entry->getInternalType() );
			}

			$stmt->bind( $idx++, $item->getLabel() );
			$stmt->bind( $idx++, $item->getStatus(), \Aimeos\MW\DB\Statement\Base::PARAM_INT );
			$stmt->bind( $idx++, $item->getSiteId(), \Aimeos\MW\DB\Statement\Base::PARAM_INT );
			$stmt->bind( $idx++, $date ); // mtime
			$stmt->bind( $idx++, $context->getEditor() );
			// code and ID are identical after saving and ID is the flag to detect updates or inserts
			$stmt->bind( $idx++, $item->getCode() );

			if( $id === null ) {
				$stmt->bind( $idx++, $date ); // ctime
			}

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

			$item->setId( $item->getCode() ); // set modified flag to false

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

		return $item;
	}