<?php

require_once 'connection.php';

Class User {

    private $db;
    private $connection;

    function __construct() {
        $this->db = new DB_Connection();
        $this->connection = $this->db->get_connection();
    }

    public function getRecipe($categoryone, $categorytwo, $price, $glutenfree, $vegetarian, $vegan, $lactosefree) {

        echo $price;
        $query = "SELECT recipe_id FROM Recipes";
        $resultSet = mysqli_query($this->connection, $query);

        $recipeId = mysqli_fetch_array($resultSet, MYSQLI_ASSOC);

        $query = "SELECT Ingredients.ingredients_id FROM Ingredients Where Ingredients.ingredients_name = '$categoryone'";
        $resultSet = mysqli_query($this->connection, $query);

        $categoryOneId = mysqli_fetch_row($resultSet)[0];

        $query = "SELECT Ingredients.ingredients_id FROM Ingredients Where Ingredients.ingredients_name = '$categorytwo'";
        $resultSet = mysqli_query($this->connection, $query);

        $categoryTwoId = mysqli_fetch_row($resultSet)[0];

        $matchedRecipes = [];

        echo 'funkar loopen då?';
        echo count($recipeId);
        for ($i = 0; $i < count($recipeId); $i++) {
            $currentRecipeId = $recipeId["recipe_id"][$i];

            echo 'we be in da loop man';
            echo $currentRecipeId;
            echo '    sweg   ';
            print $categoryOneId;

            $query = "SELECT * FROM Recipes_has_Ingredients WHERE Recipes_recipe_id = '$currentRecipeId' AND Ingredients_ingredients_id = '$categoryOneId'";
            $resultSet = mysqli_query($this->connection, $query);
            if (mysqli_num_rows($resultSet) > 0) {
                echo 'first ingridient found';
                $query = "SELECT * FROM Recipes_has_Ingredients WHERE Recipes_recipe_id = '$currentRecipeId' AND Ingredients_ingredients_id = '$categoryTwoId'";
                $resultSet = mysqli_query($this->connection, $query);
                if (mysqli_num_rows($resultSet) > 0) {
                    echo 'second ingridient found';
                    $query = "Select * from Recipes_has_Recipe_Category where Recipes_recipe_id = '$currentRecipeId' AND Recipe_Category_recipe_category = '$glutenfree'";
                    $resultSet = mysqli_query($this->connection, $query);
                    if (mysqli_num_rows($resultSet) > 0 || $glutenfree == 0) {
                        echo 'checking glutenfree \n';
                        $query = "Select * from Recipes_has_Recipe_Category where Recipes_recipe_id = '$currentRecipeId' AND Recipe_Category_recipe_category = '$vegetarian'";
                        $resultSet = mysqli_query($this->connection, $query);
                        if (mysqli_num_rows($resultSet) > 0 || $vegetarian == 0) {
                            echo 'checking vegetarian \n';
                            $query = "Select * from Recipes_has_Recipe_Category where Recipes_recipe_id = '$currentRecipeId' AND Recipe_Category_recipe_category = '$vegan'";
                            $resultSet = mysqli_query($this->connection, $query);
                            if (mysqli_num_rows($resultSet) > 0 || $vegan == 0) {
                                echo 'checking vegan \n';
                                $query = "Select * from Recipes_has_Recipe_Category where Recipes_recipe_id = '$currentRecipeId' AND Recipe_Category_recipe_category = '$lactosefree'";
                                $resultSet = mysqli_query($this->connection, $query);
                                if (mysqli_num_rows($resultSet) > 0 || $lactosefree == 0) {
                                    echo 'checking lactosefree';
                                    $query = "SELECT * from Recipes where recipe_id = '$currentRecipeId' AND price <= '$price'";
                                    $resultSet = mysqli_query($this->connection, $query);
                                    if (mysqli_num_rows($resultSet) > 0) {
                                        echo 'recept hittat';
                                        $matchedRecipes[] = $currentRecipeId;
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }

        print_r($result);
    }

}

$user = New User();

if (isset($_POST['categoryone'], $_POST['categorytwo'], $_POST['price'], $_POST['glutenfree'], $_POST['vegetarian'], $_POST['vegan'], $_POST['lactosefree'])) {
    $categoryone = $_POST['categoryone'];
    $categorytwo = $_POST['categorytwo'];
    $price = $_POST['price'];
    $glutenfree = $_POST['glutenfree'];
    $vegetarian = $_POST['vegetarian'];
    $vegan = $_POST['vegan'];
    $lactosefree = $_POST['lactosefree'];

    echo 'på rätt spår';
    $user->getRecipe($categoryone, $categorytwo, $price, $glutenfree, $vegetarian, $vegan, $lactosefree);
} else {
    echo 'nåt gick fel mannen';
}