Draft code for filtering product variations on the front-end

ProductVariationsFiltering.php

<?php

if((isset($_SESSION['FilterTypes'])) && $types = $_SESSION['FilterTypes']){
			$products = $products->innerJoin("ProductVariation","PV.ProductID = Product_Live.ID","PV");
			$y = 0;
			foreach ($types as $type){
				$products = $products->innerJoin("ProductVariation_AttributeValues","PVA".$y.".ProductVariationID = PV.ID","PVA".$y);
				$wheres = array();
				foreach ($type as $value){
					$wheres[] = "PVA".$y.".ProductAttributeValueID = ".$value;
				}
				$products = $products->where(implode("OR",$wheres));
				$y++;
			}
		}