process.php

<?php
    session_start();
    require('lib/MySQLConnection.php');

    if ((isset($_POST['item-name']) && $_POST['item-name'] != "") || isset($_POST['food-id'])) {
        $userid = $_SESSION['user-id'];
        if((isset($_POST['item-name']) && $_POST['item-name'] != "") )
            $name = $_POST['item-name'];
        else
            $name = "";
        $quantity = $_POST['quantity'];
        $storageenv = $_POST['storage-env'];

        $query = "SELECT * FROM `environments` WHERE `env_id`=$storageenv";
        $result = $db->query($query) or die($db->error);
        $storage_result = $result->fetch_assoc();

        if($storage_result['temperature'] <= 32)
            $sqlenv = 'food_expire_freezer';
        else if($storage_result['temperature'] <= 39)
            $sqlenv = 'food_expire_fridge';
        else
            $sqlenv = 'food_expire_room';

        if(isset($_POST['item-name']) && $_POST['item-name'] != "")
            $foodid = $_POST['food-category-id']; // This because the food-category-id also is the same as the "other" related food item for the category
        else
            $foodid = $_POST['food-id'];
        if(isset($_POST['expiration-date']) && $_POST['expiration-date'] != "")
            $expirationdate = date('Y-m-d', strtotime($_POST['expiration-date']));
        else{
            $query = "SELECT *
                      FROM foods
                      WHERE food_id = ".$foodid;
            $food_result = $db->query($query) or die($db->error);
            $row = $food_result->fetch_assoc(); //need to figure out what expiration time to use based on storage env still
            $expirationdate = date('Y-m-d', strtotime('+'.$row[$sqlenv].' hour'));
        }

        $query = "INSERT INTO `items`(`user_id`, `item_name`, `food_id`, `expiration_date`, `quantity`, `env_id`)
                    VALUES ('$userid', '$name', '$foodid', '$expirationdate', '$quantity', '$storageenv')";
        $result = $db->query($query) or die($db->error);

        $itemid = $db->insert_id;

        $query = "SELECT * FROM foods F, categories C WHERE F.food_id=$foodid AND F.food_category = C.cat_id";
        $result = $db->query($query) or die($db->error);
        $food_result = $result->fetch_assoc();
        if($name == ""){
            $name = $food_result['food_name'];
        }

        echo json_encode(array(
            "id"                => $itemid,
            "name"              => $name,
            "expDate"           => $expirationdate,
            "quantity"          => $quantity,
            "foodCategories"    => $food_result['cat_name'],
            "itemClass"         => $food_result['food_class'],
            "storageEnv"        => $storage_result['env_name']
        ));
    }

    if ((isset($_POST['sl-item-name']) && $_POST['sl-item-name'] != "") || isset($_POST['sl-food-id'])) {
        $userid = $_SESSION['user-id'];

        // Manual Entry
        if((isset($_POST['sl-item-name']) && $_POST['sl-item-name'] != "") ) {
            $name = $_POST['sl-item-name'];
        }
        // Quick Entry
        else {
            $name = "";
            $food_id = $_POST['sl-food-id'];
            $query = "SELECT * FROM `foods` WHERE food_id=$food_id";
            $result = $db->query($query) or die($db->error);
            if ($result->num_rows) {
                $row = $result->fetch_assoc();
                $name = $row['food_name'];
            }
        }

        $quantity = $_POST['quantity'];

        // See if item is already in the list
        $query = "SELECT * FROM `sl_items` WHERE user_id='$userid' AND item_name='$name'";
        $result = $db->query($query) or die($db->error);
        if ($result->num_rows) {
            // If so, increment the quantity to buy
            $query = "UPDATE `sl_items` SET quantity = quantity + $quantity WHERE user_id='$userid' AND item_name='$name'";
            $result = $db->query($query) or die($db->error);
        }
        // If none of that item is in the list, add it to the list
        else {
            $query = "INSERT INTO `sl_items` VALUES ($userid, '$name', $quantity, 0)";
            $result = $db->query($query) or die($db->error);
        }

        echo json_encode(array(
            "name"              => $name,
            "quantity"          => $quantity
        ));
    }

    if (isset($_POST['remove-item-id'])) {
        $userid = $_SESSION['user-id'];
        $itemid = $_POST['remove-item-id'];

        $query = "DELETE FROM `items`
                     WHERE user_id = ".$userid." AND item_id = ".$itemid;
        $result = $db->query($query) or die($db->error);

        echo $itemid;
    }

    if (isset($_POST['storage-name'])) {
        $userid = $_SESSION['user-id'];
        $name = $_POST['storage-name'];
        $temp = $_POST['storage-temp'];

        $query = "INSERT INTO `environments`(`user_id`, `env_name`, `temperature`)
                    VALUES ('$userid', '$name', '$temp')";
        $result = $db->query($query) or die($db->error);

        $storageid = $db->insert_id;

        echo json_encode(array(
            "id"    => $storageid,
            "name"  => $name,
            "temp"  => $temp,
        ));
    }

    if (isset($_POST['remove-storage-id'])) {
        $userid = $_SESSION['user-id'];
        $envid = $_POST['remove-storage-id'];

        $query = "DELETE FROM `environments`
                     WHERE user_id = ".$userid." AND env_id = ".$envid;
        $result =  $db->query($query) or die($db->error);

        echo $envid;
    }
?>