modify_item.php

<?php



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


// include class.secure.php to protect this file and the whole CMS!
if (defined('WB_PATH')) {	
	include(WB_PATH.'/framework/class.secure.php'); 
} elseif (file_exists($_SERVER['DOCUMENT_ROOT'].'/framework/class.secure.php')) {
	include($_SERVER['DOCUMENT_ROOT'].'/framework/class.secure.php'); 
} else {
	$subs = explode('/', dirname($_SERVER['SCRIPT_NAME']));	$dir = $_SERVER['DOCUMENT_ROOT'];
	$inc = false;
	foreach ($subs as $sub) {
		if (empty($sub)) continue; $dir .= '/'.$sub;
		if (file_exists($dir.'/framework/class.secure.php')) { 
			include($dir.'/framework/class.secure.php'); $inc = true;	break; 
		} 
	}
	if (!$inc) trigger_error(sprintf("[ <b>%s</b> ] Can't include class.secure.php!", $_SERVER['SCRIPT_NAME']), E_USER_ERROR);
}
// end include class.secure.php
 
// Make use of the skinable backend themes of WB > 2.7
// Check if THEME_URL is supported otherwise use ADMIN_URL
if (!defined('THEME_URL')) {
	define('THEME_URL', ADMIN_URL);
}

// Look for language File
if (LANGUAGE_LOADED) {
	require_once(WB_PATH.'/modules/bakery/languages/EN.php');
	if (file_exists(WB_PATH.'/modules/bakery/languages/'.LANGUAGE.'.php')) {
		require_once(WB_PATH.'/modules/bakery/languages/'.LANGUAGE.'.php');
	}
}

// Get id
if (!isset($_GET['item_id']) OR !is_numeric($_GET['item_id'])) {
	header("Location: ".ADMIN_URL."/pages/index.php");
} else {
	$item_id = $_GET['item_id'];
}
// Get from
if (isset($_GET['from']) AND $_GET['from'] == 'add_item') {
	$show_item_mover = false;
} else {
	$show_item_mover = true;
}


// Include WB admin wrapper script
require(WB_PATH.'/modules/admin.php');

// Get item
$query_item = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_items WHERE item_id = '$item_id'");
$fetch_item = $query_item->fetchRow();
$fetch_item = array_map('stripslashes', $fetch_item);
$fetch_item = array_map('htmlspecialchars', $fetch_item);

// Get general settings
$query_settings = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_bakery_general_settings");
$fetch_settings = $query_settings->fetchRow();
$fetch_settings = array_map('stripslashes', $fetch_settings);

// Set image resize default values
$fetch_item['imgresize'] = "";  // yes = selected by default
$fetch_item['quality']   = 75;
$fetch_item['maxwidth']  = 400;
$fetch_item['maxheight'] = 300;

// Prepopulate the text fields with previously entered item data when it has been submitted incompletely
if (isset($_SESSION['bakery']['item']) && is_array($_SESSION['bakery']['item'])) {
	$fetch_item['sku'] = htmlspecialchars($_SESSION['bakery']['item']['sku']);
	$fetch_item['stock'] = htmlspecialchars($_SESSION['bakery']['item']['stock']);
	$fetch_item['price'] = htmlspecialchars($_SESSION['bakery']['item']['price']);
	$fetch_item['shipping'] = htmlspecialchars($_SESSION['bakery']['item']['shipping']);
	$fetch_item['tax_rate'] = htmlspecialchars($_SESSION['bakery']['item']['tax_rate']);
	$fetch_item['definable_field_0'] = htmlspecialchars($_SESSION['bakery']['item']['definable_field_0']);
	$fetch_item['definable_field_1'] = htmlspecialchars($_SESSION['bakery']['item']['definable_field_1']);
	$fetch_item['definable_field_2'] = htmlspecialchars($_SESSION['bakery']['item']['definable_field_2']);
	$fetch_item['main_image'] = htmlspecialchars($_SESSION['bakery']['item']['main_image']);
	$fetch_item['description'] = htmlspecialchars($_SESSION['bakery']['item']['description']);
	$fetch_item['characteristics'] = htmlspecialchars($_SESSION['bakery']['item']['characteristics']);
	$fetch_item['full_desc'] = htmlspecialchars($_SESSION['bakery']['item']['full_desc']);
	$fetch_item['imgresize'] = $_SESSION['bakery']['item']['imgresize'];
	$fetch_item['quality'] = htmlspecialchars($_SESSION['bakery']['item']['quality']);
	$fetch_item['maxheight'] = htmlspecialchars($_SESSION['bakery']['item']['maxheight']);
	$fetch_item['maxwidth'] = htmlspecialchars($_SESSION['bakery']['item']['maxwidth']);
	$fetch_item['active'] = htmlspecialchars($_SESSION['bakery']['item']['active']);
	$fetch_item['new_section_id'] = $_SESSION['bakery']['item']['new_section_id'];
	$fetch_item['action'] = $_SESSION['bakery']['item']['action'];	
	unset($_SESSION['bakery']['item']);
}


?>
<h2>1. <?php echo $TEXT['ADD'].'/'.$TEXT['MODIFY'].' '.$MOD_BAKERY['TXT_ITEM']; ?></h2>

<form name="modify" action="<?php echo WB_URL; ?>/modules/bakery/save_item.php" method="post" enctype="multipart/form-data" style="margin: 0;">

<input type="hidden" name="section_id" value="<?php echo $section_id; ?>" />
<input type="hidden" name="page_id" value="<?php echo $page_id; ?>" />
<input type="hidden" name="item_id" value="<?php echo $item_id; ?>" />
<input type="hidden" name="link" value="<?php echo $fetch_item['link']; ?>" />

<table class="row_a" cellpadding="2" cellspacing="0" border="0" align="center" width="98%">
	<tr>
		<td width="20%" align="right"><?php echo $MOD_BAKERY['TXT_NAME']; ?>:</td>
		<td>
			<input type="text" name="title" id="title" style="width: 98%;" maxlength="150" value="<?php echo $fetch_item['title']; ?>" />
	  </td>
	</tr>
	<tr>
		<td width="20%" align="right" valign="top"><?php echo $MOD_BAKERY['TXT_DESCRIPTION']; ?>:</td>
		<td>
			<textarea name="description" id="description" style="width: 98%; height: 50px;"><?php echo $fetch_item['description']; ?></textarea>
		</td>
	</tr>
	<tr>
		<td width="20%" align="right" valign="top"><?php echo $MOD_BAKERY['TXT_CHARACTERISTICS']; ?>:</td>
		<td>
			<textarea name="characteristics" id="characteristics" style="width: 98%; height: 50px;"><?php echo $fetch_item['characteristics']; ?></textarea>
		</td>
	</tr>
	<tr>
		<td width="20%" align="right"><?php echo $MOD_BAKERY['TXT_SKU']; ?>:</td>
		<td>
			<input type="text" name="sku" id="sku" style="width: 100px;" maxlength="150" value="<?php echo $fetch_item['sku']; ?>" />
		</td>
	</tr>
	<tr>
		<td width="20%" align="right"><?php echo $MOD_BAKERY['TXT_IN_STOCK']; ?>:</td>
		<td>
			<input type="text" name="stock" id="stock" style="width: 100px; text-align: right;" maxlength="150" value="<?php echo $fetch_item['stock']; ?>" />
		</td>
	</tr>
	<tr>
		<td width="20%" align="right"><?php echo $MOD_BAKERY['TXT_PRICE']; ?>:</td>
		<td>
			<input type="text" name="price" id="price" style="width: 100px; text-align: right;" maxlength="150" value="<?php echo $fetch_item['price']; ?>" />&nbsp;<?php echo $fetch_settings['shop_currency']; ?>
	  </td>
	</tr>
	<tr>
		<td width="20%" align="right"><?php echo $MOD_BAKERY['TXT_SHIPPING']; ?>:</td>
		<td>
			<input type="text" name="shipping" id="shipping" style="width: 100px; text-align: right;" maxlength="150" value="<?php echo $fetch_item['shipping']; ?>" />&nbsp;<?php echo $fetch_settings['shop_currency']; ?>&nbsp;&nbsp;&nbsp;(<?php echo $MOD_BAKERY['TXT_PER_ITEM']; ?>)
		</td>
	</tr>
	<tr>
		  <?php
			$selected = 0;
			$top = "";
			$no_tax_rate = "";
			$item_tax_rate = $fetch_item['tax_rate'];
			$settings_tax_rate = $fetch_settings['tax_rate'];
			$settings_tax_rate1 = $fetch_settings['tax_rate1'];
			$settings_tax_rate2 = $fetch_settings['tax_rate2'];
			// Show error message if no tax rate has been set
			if ($settings_tax_rate == 0 && $settings_tax_rate1 == 0 && $settings_tax_rate2 == 0) {
				$top = "valign='top'";
				$no_tax_rate = "<span style='color: red;'>{$MOD_BAKERY['TXT_SET_TAX_RATE']}:</span> <a href='".WB_URL."/modules/bakery/modify_general_settings.php?page_id=$page_id&section_id=$section_id'> &gt; {$MOD_BAKERY['TXT_GENERAL_SETTINGS']}</a><br />";
			}
			echo "<td width='20%' align='right' $top>{$MOD_BAKERY['TXT_TAX_RATE']}:</td>";
			echo "<td>$no_tax_rate";
			// Make tax rate <select>
			echo "<select name='tax_rate'>\n";
			echo "<option value='$settings_tax_rate'";
			if ($item_tax_rate == $settings_tax_rate) { echo " selected='selected' "; $selected = 1; }
			echo "> $settings_tax_rate%</option>\n";
			// Only show 2nd and 3rd taxe rate if they have been set
				if ($settings_tax_rate1 > 0) { 
					echo "<option value='$settings_tax_rate1'";
					if ($item_tax_rate == $settings_tax_rate1) { echo " selected='selected' "; $selected = 1; }
					echo "> $settings_tax_rate1%</option>\n";
				}
				if ($settings_tax_rate2 > 0) { 
					echo "<option value='$settings_tax_rate2'";
					if ($item_tax_rate == $settings_tax_rate2) { echo " selected='selected' "; $selected = 1; }
					echo "> $settings_tax_rate2%</option>\n";
				}
			echo "</select>\n";
			if ($selected == 0) { echo "<span style='color: red;'> {$MOD_BAKERY['TXT_SAVED_TAX_RATE']}: <b>$item_tax_rate%</b></span><br />"; }
			?>
	    </td>
	</tr>
	<?php
	// Generate the required adaptable text fields
	for ($i=0; $i<=3; $i++) {
		if (isset($fetch_settings['definable_field_'.$i]) && $fetch_settings['definable_field_'.$i] != "") {
			?>
			<tr>
				<td width="20%" align="right"><?php echo $fetch_settings['definable_field_'.$i]; ?>:</td>
				<td>
					<input type="text" name="definable_field_<?php echo $i; ?>" id="definable_field_<?php echo $i; ?>" style="width: 98%;" maxlength="150" value="<?php echo $fetch_item['definable_field_'.$i]; ?>" />
			  </td>
			</tr>
		<?php
		}
	}
	?>
	<tr>
		<td width="20%" align="right"><?php echo $TEXT['ACTIVE']; ?>:</td>
		<td>
			<input type="radio" name="active" id="active_true" value="1" <?php if ($fetch_item['active'] == 1) { echo " checked='checked'"; } ?> />
			<label for="active_true"><?php echo $TEXT['YES']; ?></label>
			&nbsp;
			<input type="radio" name="active" id="active_false" value="0" <?php if ($fetch_item['active'] == 0) { echo " checked='checked'"; } ?> />
			<label for="active_false"><?php echo $TEXT['NO']; ?></label></td>
	</tr>
<?php


// Only show item mover for existing items
if ($show_item_mover) {
?>
	<tr>
		<td width="20%" align="right"><?php echo $MOD_BAKERY['TXT_ITEM_TO_PAGE']; ?>... </td>
		<td>
	<?php
	// Bakery page list
	$query_pages = "SELECT p.page_id, p.page_title, p.visibility, p.admin_groups, p.admin_users, p.viewing_groups, p.viewing_users, s.section_id FROM ".TABLE_PREFIX."pages p INNER JOIN ".TABLE_PREFIX."sections s ON p.page_id = s.page_id WHERE s.module = 'bakery' AND p.visibility != 'deleted' ORDER BY p.level, p.position ASC";
	$get_pages = $database->query($query_pages);
	
	if ($get_pages->numRows() > 0) {
		// Generate sections select
		echo "<select name='new_section_id' style='width: 240px'>\n";
		while($page = $get_pages->fetchRow()) {
			$page = array_map('stripslashes', $page);
			// Only display if visible
			if ($admin->page_is_visible($page) == false)
				continue;
			// Get user perms
			$admin_groups = explode(',', str_replace('_', '', $page['admin_groups']));
			$admin_users = explode(',', str_replace('_', '', $page['admin_users']));
			// Check user perms
			$in_group = FALSE;
			foreach ($admin->get_groups_id() as $cur_gid){
				if (in_array($cur_gid, $admin_groups)) {
					$in_group = TRUE;
				}
			}
			if (($in_group) OR is_numeric(array_search($admin->get_user_id(), $admin_users))) {
				$can_modify = true;
			} else {
				$can_modify = false;
			}
			// Options
			echo "<option value='{$page['section_id']}'";
			echo $fetch_item['section_id'] == $page['section_id'] ? " selected='selected'" : "";
			echo $can_modify == false ? " disabled='disabled' style='color: #aaa;'" : "";
			echo ">{$page['page_title']}</option>\n";
			// Prepare prechecked radio buttons
			$action_move = "";
			$action_duplicate = "";
			if (isset($fetch_item['action']) && $fetch_item['action'] == "duplicate") {
				$action_duplicate = " checked='checked'";
			} else {
				$action_move = " checked='checked'";
			}
		
		} ?>
		</select>
		<input name="action" type="radio" id="action_move" value="move"<?php echo $action_move; ?> /><label for="action_move">...<?php echo $MOD_BAKERY['TXT_MOVE']; ?></label>&nbsp; 
		<input name="action" type="radio" id="action_duplicate" value="duplicate"<?php echo $action_duplicate; ?> /><label for="action_duplicate">...<?php echo $MOD_BAKERY['TXT_DUPLICATE']; ?></label>
<?php	
	}
	else {	
		echo $TEXT['NONE_FOUND'];
	} ?>
		</td>
	</tr>
<?php
}



// ITEM FULL DESCRIPTION WYSIWYG EDITOR
// ************************************
?>	
	<tr>
		<td width="20%" height="40" align="right" valign="bottom"><b><?php echo $MOD_BAKERY['TXT_FULL_DESC']; ?>:</b></td>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td colspan="2">
			<?php
			$content = $fetch_item['full_desc'];
			$name = "full_desc";
			$id = "full_desc";
			$width = "98%";
			$height = "300px";
			if (!defined('WYSIWYG_EDITOR') OR WYSIWYG_EDITOR=="none" OR !file_exists(WB_PATH.'/modules/'.WYSIWYG_EDITOR.'/include.php')) {
				function show_wysiwyg_editor($name,$id,$content,$width,$height) {
					echo '<textarea name="'.$name.'" id="'.$id.'" style="width: '.$width.'; height: '.$height.';">'.$content.'</textarea>';
				}
			} else {
				$id_list=array("full_desc");
				require(WB_PATH.'/modules/'.WYSIWYG_EDITOR.'/include.php');
			}		
			show_wysiwyg_editor($name,$id,$content,$width,$height);
			?>
	  </td>
	</tr>
	<tr height="40" class="mod_bakery_submit_row_b">
		<td colspan="2">
		<table width="100%" border="0" cellspacing="0" cellpadding="0">
			<tr>
				<td align="left" style="padding-left: 12px;">
					<input name="save_and_return" type="submit" value="<?php echo $TEXT['SAVE']; ?>" style="width: 100px;" />
					<input name="save" type="submit" value="<?php echo $TEXT['SAVE'].' &amp; '.$TEXT['BACK']; ?>" style="width: 160px; margin-left: 20px;" />
				</td>
				<td align="right" style="padding-right: 12px;">
				<input type="button" value="<?php echo $TEXT['CANCEL']; ?>" onclick="javascript: window.location = '<?php echo ADMIN_URL; ?>/pages/modify.php?page_id=<?php echo $page_id; ?>';" style="width: 100px; float: right;" />
				</td>
			</tr>
		</table>
		</td>
	</tr>
</table>
<br /><br /><br />
<?php



// ITEM IMAGES
// ***********

// Title and table header
?>
<a name="images"><h2>2. <?php echo $MOD_BAKERY['TXT_ITEM']." ".$MOD_BAKERY['TXT_IMAGES']; ?></h2></a>
<table cellpadding="2" cellspacing="0" border="0" width="98%" align="center">
	<tr height="30" valign="bottom" class="mod_bakery_submit_row_b">
	  <th width="10%" align="left"><span style="margin-left: 5px;"><?php echo $MOD_BAKERY['TXT_PREVIEW']; ?></span></th>
	  <th width="22%" align="left"><?php echo $MOD_BAKERY['TXT_FILE_NAME']; ?></th>
	  <th width="15%" align="left"><?php echo $MOD_BAKERY['TXT_MAIN_IMAGE']; ?></th>
	  <th width="15%" align="left"><?php echo $TEXT['DELETE']; ?></th>
	  <th>&nbsp;</th>
	</tr>
	<tr class="mod_bakery_submit_row_b">
	  <td colspan="2">&nbsp;</td>
	  <td>
		<input type="radio" name="main_image" id="main_image" value=""<?php echo $fetch_item['main_image'] == "" ? " checked='checked'" : ""; ?> />
		<label for="main_image"><?php echo $MOD_BAKERY['TXT_NON']; ?></label></td>
	  <td colspan="2">&nbsp;</td>
	</tr>


	<?php
	// Get all images of this item
	$i = 0;     // Image counter for radio and checkbox ids used for labels
	$row = 'a'; // Row color
	$no_image = true;

	// Prepare image and thumb directory pathes and urls
	$img_dir = WB_PATH.MEDIA_DIRECTORY.'/bakery/images/item'.$item_id;
	$thumb_dir = WB_PATH.MEDIA_DIRECTORY.'/bakery/thumbs/item'.$item_id;
	$img_url = WB_URL.MEDIA_DIRECTORY.'/bakery/images/item'.$item_id.'/';
	$thumb_url = WB_URL.MEDIA_DIRECTORY.'/bakery/thumbs/item'.$item_id.'/';
	
	// Check if the image and thumb directories exist
	if (is_dir($img_dir) && is_dir($thumb_dir)) {
		// Open the image directory then loop through its contents
		$dir = dir($img_dir);
		while (false !== $image_file = $dir->read()) {
			// Skip index file and pointers
			if (strpos($image_file, '.php') !== false || substr($image_file, 0, 1) == ".") {
				continue;
			}
			// Thumbs use .jpg extension only
			$thumb_file = str_replace(".png", ".jpg", $image_file);
			$no_image = false;
		?>
		<tr class="row_<?php echo $row; ?>">
		  <td><a href="<?php echo $img_url.$image_file; ?>" target="_blank"><img src="<?php echo $thumb_url.$thumb_file; ?>" alt="<?php echo $MOD_BAKERY['TXT_IMAGE']." ".$image_file; ?>" title="<?php echo $image_file; ?>" height="40" border="0" /></a></td>
		  <td><a href="<?php echo $img_url.$image_file; ?>" target="_blank"><?php echo $image_file; ?></a></td>
		  <td nowrap="nowrap">
		  	<input type="radio" name="main_image" id="main_image_<?php echo $i; ?>" value="<?php echo $image_file; ?>"<?php echo $fetch_item['main_image'] == $image_file ? " checked='checked'" : ""; ?> />
			<label for="main_image_<?php echo $i; ?>"><?php echo $MOD_BAKERY['TXT_MAIN_IMAGE']; ?></label></td>
		  <td nowrap="nowrap">
		  	<input type="checkbox" name="delete_image[]" id="delete_image_<?php echo $i; ?>" value="<?php echo $image_file; ?>" />
			<label for="delete_image_<?php echo $i; ?>"><?php echo $TEXT['DELETE']; ?></label></td>
		  <td>&nbsp;</td>
		</tr>
		<?php
		$i++;
		$row = $row == 'a' ? 'b' : 'a'; // Alternate row color
		}
	}

	// Display message if no directories nor images found
	if ($no_image) {
		echo "<tr height='30'><td colspan='5'>\n";
		echo "<span style='color: red; padding-left: 50px;'>".$TEXT['NONE_FOUND']."</span>";
		echo "</td></tr>";
	}
	?>
</table>
<br /><br />


<?php
// Image upload
?>
<a name="images"><h2>3. <?php echo $TEXT['ADD']." ".$MOD_BAKERY['TXT_IMAGES']; ?></h2></a>
<table class="row_a" cellpadding="2" cellspacing="0" border="0" width="100%" align="center">	
	<tr align="left" valign="top">
		<td>
		<?php
		// Image resize table
		?>
			<table class="mod_bakery_img_resize_table_b" cellspacing="4">
				<tr>
					<th colspan="2">
						<input type="checkbox" name="imgresize" id="imgresize" value="yes"<?php echo $fetch_item['imgresize'] == 'yes' ? " checked='checked'" : ""; ?> />
						<label for="imgresize"><strong><?php echo $MOD_BAKERY['TXT_IMAGE']." ".$TEXT['RESIZE']; ?></strong></label>
					</th>
				</tr>				
				<tr>
					<td><?php echo $MOD_BAKERY['TXT_MAX_WIDTH']; ?>:</td>
					<td><input type="text" size="5" name="maxwidth" value="<?php echo $fetch_item['maxwidth']; ?>" /></td>
				</tr>			
				<tr>
					<td><?php echo $MOD_BAKERY['TXT_MAX_HEIGHT']; ?>:</td>
					<td><input type="text" size="5" name="maxheight" value="<?php echo $fetch_item['maxheight']; ?>" /></td>
				</tr>				
				<tr>
					<td> <?php echo $MOD_BAKERY['TXT_JPG_QUALITY']; ?>:</td>
					<td><input type="text" size="3" name="quality" value="<?php echo $fetch_item['quality']; ?>" /></td>
				</tr>
			</table>
		</td>
		<td width="70%">
		<?php
		// Image upload table
		?>
		<table align="left" id="upload" style="margin: 5px;">	
			<tr>
				<td>
					<input type="file" name="image[]">
					<input type="radio" name="main_image" id="main_image_<?php echo $i; ?>" value="upload" /> 
					<label for="main_image_<?php echo $i; ?>"><?php echo $MOD_BAKERY['TXT_MAIN_IMAGE']; ?></label>
				</td>
			</tr>	
			<tfoot>
				<tr>
					<td>
						<span onclick="addFile(' [-] <?php echo $TEXT['DELETE']; ?>')" style="cursor: pointer;"> [+]  <?php echo $TEXT['ADD']; ?></span>
						<br /><br />
					</td>
				</tr>
			</tfoot>			
		</table>
		</td>
	</tr>
	<tr height="40" class="mod_bakery_submit_row_b">
		<td colspan="2">
		<table width="100%" border="0" cellspacing="0" cellpadding="0">
			<tr>
				<td align="left" style="padding-left: 12px;">
					<input name="save_and_return_to_images" type="submit" value="<?php echo $TEXT['SAVE']; ?>" style="width: 100px;" />
					<input name="save" type="submit" value="<?php echo $TEXT['SAVE'].' &amp; '.$TEXT['BACK']; ?>" style="width: 160px; margin-left: 20px;" />
				</td>
				<td align="right" style="padding-right: 12px;">
				<input type="button" value="<?php echo $TEXT['CANCEL']; ?>" onclick="javascript: window.location = '<?php echo ADMIN_URL; ?>/pages/modify.php?page_id=<?php echo $page_id; ?>';" style="width: 100px; float: right;" />
				</td>
			</tr>
		</table>
		</td>
	</tr>
</table>
<br /><br /><br />
<?php



// ITEM OPTIONS AND ATTRIBUTES
// ***************************

// Title and table header
?>

<a name="options"><h2>4. <?php echo $MOD_BAKERY['TXT_ITEM_OPTIONS']; ?></h2></a>
<table cellpadding="2" cellspacing="0" border="0" width="100%" align="center">
	<tr height="30" valign="bottom" class="mod_bakery_submit_row_b">
	  <th width="320" align="left"><span style="margin-left: 5px;"><?php echo $MOD_BAKERY['TXT_OPTION_NAME'].": ".$MOD_BAKERY['TXT_OPTION_ATTRIBUTES']; ?></span></th>
	  <th width="140" align="center"><?php echo $MOD_BAKERY['TXT_OPTION_PRICE'] ?></th>
	  <th>&nbsp;</th>
	  <th colspan="2" align="center"><?php echo $TEXT['ACTIONS']; ?></th>
	</tr>

<?php
// Initialize vars
$listed_attribute_ids = array();
$attribute_id = "";
$ia_operator = "";
$ia_price = "";
$db_action = "insert";

// Get items attributes
$query_items_attributes = $database->query("SELECT o.option_name, a.attribute_name, a.attribute_id, ia.price, ia.operator FROM ".TABLE_PREFIX."mod_bakery_options o INNER JOIN ".TABLE_PREFIX."mod_bakery_attributes a ON o.option_id = a.option_id INNER JOIN ".TABLE_PREFIX."mod_bakery_item_attributes ia ON a.attribute_id = ia.attribute_id WHERE ia.item_id = '$item_id' ORDER BY o.option_name, a.attribute_name ASC");

if ($query_items_attributes->numRows() > 0) {
	$row = 'a';
	// Show table with all existing item attributes
	while($option = $query_items_attributes->fetchRow()) {
		$option = array_map('stripslashes', $option);
		// Get the item attribute which should be modified and start a new loop
		if (isset($_GET['attribute_id']) && $option['attribute_id'] == $_GET['attribute_id']) {
			$attribute_id = $option['attribute_id'];
			$ia_operator = $option['operator'];
			$ia_price = $option['price'];
			$db_action = "update";
			continue;
		}
		// Add all listed attribute ids to an array => omit them in the option and attribute select
		$listed_attribute_ids[] = $option['attribute_id'];


		// Show the existing item attributes
		?>
	<tr class="row_<?php echo $row; ?>" height="20">
	  <td align="left"><span style="margin-left: 5px;"><?php echo $option['option_name'].": ".$option['attribute_name']; ?></span></td>
	  <td align="right"><?php echo $option['operator']." ".$fetch_settings['shop_currency']." ".$option['price']; ?></td>
	  <td>&nbsp;</td>
	  <td align="center" width="22">
		<a href="<?php echo WB_URL; ?>/modules/bakery/modify_item.php?page_id=<?php echo $page_id; ?>&section_id=<?php echo $section_id; ?>&item_id=<?php echo $item_id; ?>&attribute_id=<?php echo $option['attribute_id']; ?>#options" title="<?php echo $TEXT['MODIFY']; ?>">
			<img src="<?php echo THEME_URL; ?>/images/modify_16.png" alt="<?php echo $TEXT['MODIFY']." ".$MOD_BAKERY['TXT_OPTION_NAME']; ?>" border="0" />
		</a>
	  </td>
	  <td align="left" width="22">
		<a href="javascript: confirm_link('<?php echo $TEXT['ARE_YOU_SURE']; ?>', '<?php echo WB_URL; ?>/modules/bakery/delete_item_attribute.php?page_id=<?php echo $page_id; ?>&section_id=<?php echo $section_id; ?>&item_id=<?php echo $item_id; ?>&attribute_id=<?php echo $option['attribute_id'] ?>');" title="<?php echo $TEXT['DELETE']; ?>">
			<img src="<?php echo THEME_URL; ?>/images/delete_16.png" border="0" alt="<?php echo $TEXT['DELETE']." ".$MOD_BAKERY['TXT_OPTION_NAME']; ?>" />
		</a>
	  </td>
	</tr>
	<?php
	// Alternate row color
	$row = $row == 'a' ? 'b' : 'a';
	}
} else {
	echo "<tr height='30'><td colspan='5'>\n";
	echo "<span style='color: red; padding-left: 50px;'>".$TEXT['NONE_FOUND']."</span>";
	echo "</td></tr>";
}

// Show form to add new item attributes
echo "<tr height='50' class='mod_bakery_submit_row_b'>\n<td>\n";
// Get options and attributes
$query_options = $database->query("SELECT o.option_name, o.option_id, a.attribute_id, a.attribute_name FROM ".TABLE_PREFIX."mod_bakery_options o INNER JOIN ".TABLE_PREFIX."mod_bakery_attributes a ON o.option_id = a.option_id ORDER BY o.option_name, a.attribute_name ASC");
if ($query_options->numRows() > 0) {
	// Generate option and attribute select
	echo "<select name='attribute_id' style='width: 320px'>\n";
	while($option = $query_options->fetchRow()) {
		$option = array_map('stripslashes', $option);
		// Only display if not listed in the item attributes table above	
		if (in_array($option['attribute_id'], $listed_attribute_ids))
			continue;
		echo "<option value='{$option['attribute_id']}'";
		echo $attribute_id == $option['attribute_id'] ? " selected='selected'" : "";
		echo ">{$option['option_name']}: {$option['attribute_name']}</option>\n";
	}
	echo "</select>";
} else {
	echo "{$TEXT['NONE_FOUND']}&nbsp;&nbsp;<a href='".WB_URL."/modules/bakery/modify_options.php?page_id=$page_id&amp;section_id=$section_id'>&gt; {$TEXT['ADD']}/<span style='text-transform: lowercase;'>{$TEXT['MODIFY']}/{$TEXT['DELETE']}</span></a>";
}
?>
	  </td>
	  <td align="right"><?php echo $fetch_settings['shop_currency']; ?>
		<select name="ia_operator">
		  <option value="+"<?php echo $ia_operator == "+" ? " selected='selected'" : ""; ?>> + </option>
		  <option value="-"<?php echo $ia_operator == "-" ? " selected='selected'" : ""; ?>> - </option>
		  <option value="="<?php echo $ia_operator == "=" ? " selected='selected'" : ""; ?>> = </option>
		</select>
		<input type="text" name="ia_price" style="width: 60px; text-align: right;" maxlength="150" value="<?php echo $ia_price; ?>" />
		<input type="hidden" name="db_action" value="<?php echo $db_action; ?>" />
	  </td>
	  <td>&nbsp;</td>
	  <td colspan="2"><input type="submit" name="save_attribute" value=" <?php echo $TEXT['ADD']; ?> " />
	  </td>
	</tr>
</table>
</form>

<?php

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

?>