save_stock.php

<?php

/*
  Module developed for the Open Source Content Management System WebsiteBaker (http://websitebaker.org)
  Copyright (C) 2007 - 2017, Christoph Marti

  LICENCE TERMS:
  This module is free software. You can redistribute it and/or modify it 
  under the terms of the GNU General Public License  - version 2 or later, 
  as published by the Free Software Foundation: http://www.gnu.org/licenses/gpl.html.

  DISCLAIMER:
  This module is distributed in the hope that it will be useful, 
  but WITHOUT ANY WARRANTY; without even the implied warranty of 
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 
  GNU General Public License for more details.
*/


require('../../config.php');

// Include WB admin wrapper script
$update_when_modified = true; // Tells script to update when this page was last updated
require(WB_PATH.'/modules/admin.php');

// Get category
if (isset($_POST['cat'])) {
	$category = is_numeric($_POST['cat']) ? $_POST['cat'] : '';
} else {
	$category = '';
}

// Loop through the items... 
foreach ($_POST['stock'] as $item_id => $stock) {
	$stock = $admin->add_slashes(strip_tags($stock));
	$active = isset($_POST['active'][$item_id]) ? 1 : 0;
	// ...and update items
	$database->query("UPDATE ".TABLE_PREFIX."mod_bakery_items SET stock = '$stock', active = '$active' WHERE item_id = '$item_id'");
}

// Check if there is a db error, otherwise say successful
if ($database->is_error()) {
	$admin->print_error($database->get_error(), WB_URL.'/modules/bakery/stock.php?page_id='.$page_id.'&cat='.$category);
} else {
	$admin->print_success($TEXT['SUCCESS'], WB_URL.'/modules/bakery/stock.php?page_id='.$page_id.'&cat='.$category);
}

// Print admin footer
$admin->print_footer();