steveosoule
1/29/2015 - 1:11 AM

Miva - Order Items: Variant Code To Master Code

Miva - Order Items: Variant Code To Master Code

<mvt:foreach iterator="item" array="order:items">

	<mvt:comment>
		<!--
			Variant Basket Item Replacement Helper
		-->
	</mvt:comment>
	<mvt:comment><!-- Determine of product is a variant or not --></mvt:comment>
		<mvt:if expr="l.settings:item:product:id GT 0 AND l.settings:item:product:id NE l.settings:item:product_id">
			<mvt:assign name="l.settings:item:is_variant" value="1" />
			<mvt:assign name="l.settings:item:true:master:id" value="l.settings:item:product_id" />
			<mvt:assign name="l.settings:item:true:variant:id" value="l.settings:item:product:id" />
			<mvt:assign name="l.settings:item:true:lookup:id" value="l.settings:item:true:variant:id" />
		<mvt:else>
			<mvt:assign name="l.settings:item:is_variant" value="0" />
			<mvt:assign name="l.settings:item:true:master:id" value="l.settings:item:product_id" />
			<mvt:assign name="l.settings:item:true:variant:id" value="0" />
			<mvt:assign name="l.settings:item:true:lookup:id" value="l.settings:item:true:master:id" />
		</mvt:if>
	<mvt:comment><!-- Lookup & Standardize master product code --></mvt:comment>
		<mvt:if expr="l.settings:item:true:lookup:id">
			<mvt:assign name="g.sql_select" value="'SELECT id,code FROM ' $ g.store_table_prefix $ 'Products WHERE id = ' $ l.settings:item:true:lookup:id $ ' LIMIT 1'" />
			<mvt:item name="ry_toolbelt" param="query|g.sql_select|item:true:lookup:results" />
			<mvt:assign name="l.settings:item:standard:id" value="l.settings:item:true:lookup:results[1]:id" />
			<mvt:assign name="l.settings:item:standard:code" value="l.settings:item:true:lookup:results[1]:code" />
		</mvt:if>

	&mvt:item:standard:code;

</mvt:foreach