Esempi in PHP per fn_get_linked_option_variants

Esempio n. 1

File: fn.catalog.php Progetto: OneataBogdan/lead_coriolan

function fn_get_options_variants_by_option_variant_id($product_id, $variantsOptionsSelected = array())
{
    $condition = "";
    $fields = "?:product_options.option_id, c.variant_id";
    $condition .= db_quote(' (?:product_options.product_id = ?i OR (?:product_options.product_id=0 AND n.product_id = ?i))', $product_id, $product_id);
    $join = db_quote(' LEFT JOIN ?:product_global_option_links n ON ?:product_options.option_id = n.option_id ');
    $join .= db_quote(' JOIN ?:product_option_variants c ON ?:product_options.option_id = c.option_id');
    $opts = db_get_array("SELECT " . $fields . " FROM ?:product_options " . $join . " WHERE " . $condition . " GROUP BY c.variant_id, ?:product_options.option_id" . " ORDER BY ?:product_options.position, c.position");
    $initialOptionAndVariants = array();
    foreach ($opts as $opt) {
        $initialOptionAndVariants[$opt['option_id']][] = $opt['variant_id'];
    }
    $variantOptionsCombinationsArray = fn_get_linked_option_variants($product_id);
    //var_dump($variantOptionsCombinationsArray);
    $startArray = $variantOptionsCombinationsArray['option_variants'];
    $infoArray = $variantOptionsCombinationsArray['variant_option_ids'];
    $test_options_variants = fn_traverse_array_options($startArray, $infoArray);
    $followOptionsLinks = followOptionsLinks($test_options_variants, $variantsOptionsSelected);
    $mainOptions = getMainOptions($followOptionsLinks);
    $selectedOptionArray = createOptionsVariantsArrayBySelectedInfo($test_options_variants, $variantsOptionsSelected, $mainOptions);
    //var_dump($selectedOptionArray);echo"<br/>_________<br/>";
    foreach ($mainOptions as $mainOption) {
        unset($selectedOptionArray[$mainOption]);
    }
    foreach ($selectedOptionArray as $selectedOptionkey => $selectedOption) {
        if (count($selectedOption) > 1) {
            $arrayToIntersect = array();
            foreach ($selectedOption as $selectedOption1) {
                if ($selectedOption1) {
                    $arrayToIntersect[] = $selectedOption1;
                }
            }
            if (count($arrayToIntersect) > 1) {
                $selectedOptionArray[$selectedOptionkey] = call_user_func_array('array_intersect', $arrayToIntersect);
            } else {
                $selectedOptionArray[$selectedOptionkey] = $arrayToIntersect[0];
            }
        } elseif (count($selectedOption) == 1) {
            $selectedOptionArray[$selectedOptionkey] = $selectedOption[0];
        }
    }
    //    var_dump($selectedOptionArray);echo"<br/>________________<br/>";
    $selectedOptionArrayOrderedByVariantsOrders = array();
    foreach ($initialOptionAndVariants as $key1 => $value1) {
        foreach ($value1 as $key2 => $value2) {
            if ($selectedOptionArray[$key1] && in_array($value2, $selectedOptionArray[$key1])) {
                $selectedOptionArrayOrderedByVariantsOrders[$key1][] = $value2;
            }
        }
    }
    $selectedOptionArray = $selectedOptionArrayOrderedByVariantsOrders;
    return $selectedOptionArray;
}

Esempio n. 2

File: fn.catalog.php Progetto: OneataBogdan/lead_coriolan

function fn_get_options_variants_by_option_variant_id($product_id, $variantsOptionsSelected = array())
{
    $fields = "?:product_options.option_id, c.variant_id";
    $condition .= db_quote(' (?:product_options.product_id = ?i OR (?:product_options.product_id=0 AND n.product_id = ?i))', $product_id, $product_id);
    $join = db_quote(' LEFT JOIN ?:product_global_option_links n ON ?:product_options.option_id = n.option_id ');
    $join .= db_quote(' JOIN ?:product_option_variants c ON ?:product_options.option_id = c.option_id');
    $opts = db_get_array("SELECT " . $fields . " FROM ?:product_options " . $join . " WHERE " . $condition . " GROUP BY c.variant_id, ?:product_options.option_id" . " ORDER BY ?:product_options.position, c.position");
    $initialOptionAndVariants = array();
    foreach ($opts as $opt) {
        $initialOptionAndVariants[$opt['option_id']][] = $opt['variant_id'];
    }
    $variantOptionsCombinationsArray = fn_get_linked_option_variants($product_id);
    $startArray = $variantOptionsCombinationsArray['option_variants'];
    $infoArray = $variantOptionsCombinationsArray['variant_option_ids'];
    $test_options_variants = fn_traverse_array_options($startArray, $infoArray);
    $mainOptions = getMainOptions($test_options_variants);
    $selectedOptionArray = createOptionsVariantsArrayBySelectedInfo($test_options_variants, $variantsOptionsSelected);
    echo "<br/><br/><br/><br/>";
    var_dump($product_id);
    echo "<br/>";
    var_dump($variantsOptionsSelected);
    echo "<br/>";
    foreach ($mainOptions as $mainOption) {
        unset($selectedOptionArray[$mainOption]);
    }
    foreach ($selectedOptionArray as $selectedOptionkey => $selectedOption) {
        if (count($selectedOption) > 1) {
            $selectedOptionArray[$selectedOptionkey] = call_user_func_array('array_intersect', $selectedOption);
        }
    }
    return $selectedOptionArray;
}