Exemplos de insert_sales_table em PHP

Exemplo n.º 1

Arquivo: add_food.php Projeto: Tonyx1995/Food_inventory

function add_info()
{
    $food_name = $_POST['food_name'];
    $food_description = $_POST['food_description'];
    $regular_price = $_POST['regular_price'];
    $sale_price = $_POST['sale_price'];
    $cyclone_price = $_POST['cyclone_price'];
    $category_id = $_POST['category_id'];
    $sale_start_date = $_POST['sale_start_date'];
    $sale_end_date = $_POST['sale_end_date'];
    $current_date = date("Y-m-d");
    $current_date = date("Y-m-d", strtotime($current_date));
    $sale_start = date("Y-m-d", strtotime($_POST['sale_start_date']));
    $sale_end = date("Y-m-d", strtotime($_POST['sale_end_date']));
    $cyclone_card = $_POST['cyclone_card'];
    if (ucfirst($cyclone_card) == "Yes") {
        $cyclone_card = 1;
    } else {
        if (ucfirst($cyclone_card) == "No") {
            $cyclone_card = 0;
        }
    }
    $sql = "INSERT INTO food SET\n\t\t\t\t\tfood_name = '" . $food_name . "',\n\t\t\t\t\tfood_description = '" . $food_description . "',\n\t\t\t\t\tregular_price = '" . $regular_price . "',\n\t\t\t\t\tsale_price = '" . $sale_price . "',\n\t\t\t\t\tsale_start_date = '" . format_date_update($sale_start_date) . "',\n\t\t\t\t\tsale_end_date = '" . format_date_update($sale_end_date) . "',";
    if ($current_date >= $sale_start && $current_date <= $sale_end) {
        $sql .= " on_sale = '1', ";
    } else {
        $sql .= " on_sale = '0', ";
    }
    $sql .= "cyclone_card_price = '" . $cyclone_price . "',\n\t\t\t\t\tcyclone_card_item = '" . $cyclone_card . "',\n\t\t\t\t\tcategory_id = '" . $category_id . "'";
    $result = mysql_query($sql);
    $id = mysql_insert_id();
    //Insert into sales_history table if item was on sale.
    if ($current_date >= $sale_start && $current_date <= $sale_end) {
        insert_sales_table($id);
    }
    echo " \n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\twindow.location.href = 'upload.php?id=" . $id . "';\n\t\t\t\t\t\t</script>\n\t\t\t\t\t";
}

Exemplo n.º 2

Arquivo: edit_food.php Projeto: Tonyx1995/Food_inventory

function update_info($id)
{
    $food_name = $_POST['food_name'];
    $food_description = $_POST['food_description'];
    $regular_price = $_POST['regular_price'];
    $sale_price = $_POST['sale_price'];
    $category_id = $_POST['category_id'];
    $sale_start_date = $_POST['sale_start_date'];
    $sale_end_date = $_POST['sale_end_date'];
    $current_date = date("Y-m-d");
    $current_date = date("Y-m-d", strtotime($current_date));
    $sale_start = date("Y-m-d", strtotime($_POST['sale_start_date']));
    $sale_end = date("Y-m-d", strtotime($_POST['sale_end_date']));
    $cyclone_card = $_POST['cyclone_card'];
    if (ucfirst($cyclone_card) == "Yes") {
        $cyclone_card = 1;
    } else {
        if (ucfirst($cyclone_card) == "No") {
            $cyclone_card = 0;
        }
    }
    $cyclone_card_price = $_POST['cyclone_card_price'];
    $sql = "UPDATE food SET\n\t\t\t\t\tfood_name = '" . $food_name . "',\n\t\t\t\t\tfood_description = '" . $food_description . "',\n\t\t\t\t\tregular_price = '" . $regular_price . "',\n\t\t\t\t\tcyclone_card_item = '" . $cyclone_card . "',\n\t\t\t\t\tcyclone_card_price = '" . $cyclone_card_price . "',\n\t\t\t\t\tsale_price = '" . $sale_price . "',\n\t\t\t\t\tsale_start_date = '" . format_date_update($sale_start_date) . "',\n\t\t\t\t\tsale_end_date = '" . format_date_update($sale_end_date) . "',";
    if ($current_date >= $sale_start && $current_date <= $sale_end) {
        $sql .= " on_sale = '1', ";
        insert_sales_table($id);
    } else {
        $sql .= " on_sale = '0', ";
    }
    $sql .= "category_id = '" . $category_id . "'\n\t\t\t\t\tWHERE\n\t\t\t\t\tfood_id = " . $id;
    $result = mysql_query($sql);
    echo " \n\t\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\t\twindow.location.href = 'food_inventory.php?page=1';\n\t\t\t\t\t\t</script>\n\t\t\t\t\t";
}