';print_r($structure_tree);
		$this->layout_object->assign('structure_tree', $structure_tree);

		// get schema
		$schemas = $this->item_object ->get_all_item_schemas();
		$this->layout_object->assign('schemas', $schemas);

		// get customer groups
		$customerGroups_object = new Customer_group($this->base_object);
		$customerGroups = $customerGroups_object->get_all_price_groups();
		$groups = array();
		foreach ($customerGroups as $group) {
			if ($id) {
				$group->prices = $this->item_object->getPricesForCustomerGroup($group->id);
			} else {
				// For new items, create empty prices object
				$group->prices = new stdClass();
				$group->prices->graduated_prices = false;
				// Manually add all price properties with numeric defaults (for calculations)
				$group->prices->price_1 = 0; $group->prices->quantity_1 = 1; $group->prices->bargain_price_1 = 0;
				$group->prices->price_2 = 0; $group->prices->quantity_2 = 0; $group->prices->bargain_price_2 = 0;
				$group->prices->price_3 = 0; $group->prices->quantity_3 = 0; $group->prices->bargain_price_3 = 0;
				$group->prices->price_4 = 0; $group->prices->quantity_4 = 0; $group->prices->bargain_price_4 = 0;
				$group->prices->price_5 = 0; $group->prices->quantity_5 = 0; $group->prices->bargain_price_5 = 0;
			}
			$groups[] = $group;
		}
		$this->layout_object->assign('customerGroups', $groups);

		// get accessories
		if ($id) {
			$item_items = $this->item_object ->get_all_item_items(1, $id, 1);
			$this->layout_object->assign('item_items', $item_items);

			$item_items2 = $this->item_object ->get_all_item_items(2, $id, 1);
			$this->layout_object->assign('item_items2', $item_items2);

			$item_items3 = $this->item_object ->get_all_item_items(3, $id, 1);
			$this->layout_object->assign('item_items3', $item_items3);
		}

		// get accessories childs
		if ($id) {
			$item_items = $this->item_object ->get_all_item_items(1, $id, 0);
			$this->layout_object->assign('item_item_child', $item_items);

			$item_items2 = $this->item_object ->get_all_item_items(2, $id, 0);
			$this->layout_object->assign('item_item_child2', $item_items2);

			$item_items3 = $this->item_object ->get_all_item_items(3, $id, 0);
			$this->layout_object->assign('item_item_child3', $item_items3);
		}

		// get shipping areas
		$shipping_area_object = new Shipping_area($this->base_object);
		$shipping_areas = $shipping_area_object->get_all();
		$this->layout_object->assign('shipping_areas', $shipping_areas);

		// get google item categories
		$google_item_categories1 = $this->item_object ->get_all_google_item_categories();
		$this->layout_object->assign('google_item_categories1', $google_item_categories1);

		// get item type definitions
		$item_type_definitions = self::get_item_type_definitions();
		$this->layout_object->assign('item_type_definitions', $item_type_definitions);

		// get item types
		if ($this->item_object) {
			$item_types = $this->item_object->get_item_types();
		} else {
			$item_types = array(); // For new items
		}
		$this->layout_object->assign('item_types', $item_types);

		// item opinion
		if ($id) {
			$opinion = $this->item_object->get_opinion_list($id);
			$this->layout_object->assign('item_opinion', $opinion);
		}

		// item inventory
		if ($id) {
			$inventory_object = new ItemInventory($this->base_object);
			$inventory = $inventory_object->get_all_item_inventory($id);
			$price_sum_output = 0;
			$price_sum_input = 0;
			foreach ($inventory as $item_inventory) {
				if ($item_inventory->inventory_object_type_id == 2) {
					$price_sum_input += $item_inventory->price_sum;
				} else {
					$price_sum_output += $item_inventory->price_sum;
				}
			}
			$this->layout_object->assign('item_inventory_stats', array('price_sum_input' => $price_sum_input, 'price_sum_output' => $price_sum_output));
			$this->layout_object->assign('item_inventory', $inventory);
		}

		// get variant configuration
		include './web/'.SHOP_SYSTEM.'/config/item_variant_schema.inc.php';
		$this->layout_object->assign('item_variant_config', $item_fields);

		// Ensure item_data is always set (default values for new items)  
		if (!$this->layout_object->getTemplateVars('item_data')) {
			// Create comprehensive default item object with all needed properties
			$default_item_data = new stdClass();
			$default_item_data->id = '';
			$default_item_data->parent_id = 0;
			$default_item_data->structure_id = 0;
			$default_item_data->schema_id = 0;
			$default_item_data->manufacturer_id = 0;
			$default_item_data->name = '';
			$default_item_data->name_en = '';
			$default_item_data->number = '';
			$default_item_data->tax_id = 0;
			$default_item_data->short_description = '';
			$default_item_data->short_description_en = '';
			$default_item_data->detail_description = '';
			$default_item_data->detail_description_en = '';
			$default_item_data->manufacturer_item_number = '';
			$default_item_data->default_image_file_name = '';
			$default_item_data->seo_title = '';
			$default_item_data->seo_description = '';
			$default_item_data->seo_keywords = '';
			$default_item_data->short_uri = '';
			$default_item_data->ean_code = '';
			$default_item_data->price_type = '';
			$default_item_data->shipping_cost_type = '';
			$default_item_data->shipping_item_type = '';
			$default_item_data->shipping_weight = '';
			$default_item_data->available_from = '';
			$default_item_data->available_till = '';
			$default_item_data->base_price = '';
			$default_item_data->buy_quantity = '';
			$default_item_data->google_product_category = '';
			$default_item_data->inventory_min = '';
			$default_item_data->inventory_number = '';
			$default_item_data->inventory_order_quantity = '';
			$default_item_data->inventory_rack_number = '';
			$default_item_data->min_quantity = '';
			$default_item_data->price_je_vpe = '';
			$default_prices = new stdClass();
			$default_prices->value = 0;
			$default_item_data->prices = $default_prices;
			$default_item_data->uvp = '';
			$default_item_data->uvp_netto = '';
			$default_item_data->vpe_amount = '';
			$default_item_data->vpe_unit = '';
			$default_item_data->youtube_video = '';
			$default_item_data->vendor_id = 0;
			$default_item_data->vendor_item_number = '';
			$default_item_data->price_1 = '';
			$default_item_data->has_user_data = 0;
			$default_item_data->shippable = 1;
			$default_item_data->shippable_inventory = 1;
			$default_item_data->bargain_price_type = 0;
			// Create empty last_change_user object for new items
			$default_last_change_user = new stdClass();
			$default_last_change_user->firstname = '';
			$default_last_change_user->surname = '';
			$default_item_data->last_change_user = $default_last_change_user;
			$default_item_data->last_change_date = '';
			$default_item_data->schema_data_attributes = array();
			$default_item_data->variant_structure = array();
			$this->layout_object->assign('item_data', $default_item_data);
		}
		
		// Ensure message variables are always set as arrays
		if (!$this->layout_object->getTemplateVars('warning_message')) {
			$this->layout_object->assign('warning_message', array());
		}
		if (!$this->layout_object->getTemplateVars('error_message')) {
			$this->layout_object->assign('error_message', array());
		}
		if (!$this->layout_object->getTemplateVars('info_message')) {
			$this->layout_object->assign('info_message', array());
		}
		
		// Ensure item_structure_assignment is always set
		if (!$this->layout_object->getTemplateVars('item_structure_assignment')) {
			$this->layout_object->assign('item_structure_assignment', array());
		}
		
		// Ensure itemsTax is always set as numeric value for calculations
		if (!$this->layout_object->getTemplateVars('itemsTax')) {
			$this->layout_object->assign('itemsTax', 0);
		}
		
		// Ensure item_types is always set as array
		if (!$this->layout_object->getTemplateVars('item_types')) {
			$this->layout_object->assign('item_types', array());
		}
		
		// Ensure all show_* variables are set as integers for template conditions
		$show_vars = ['show_price_and_marketing', 'show_attributes', 'show_versand', 'show_seo', 'show_lager', 'show_price_variants'];
		foreach ($show_vars as $var_name) {
			if (!$this->layout_object->getTemplateVars($var_name)) {
				$this->layout_object->assign($var_name, 0);
			}
		}
		
		// Ensure base_dir and info object are set for all icon paths
		if (!$this->layout_object->getTemplateVars('base_dir')) {
			$this->layout_object->assign('base_dir', '.');
		}
		if (!$this->layout_object->getTemplateVars('info')) {
			$info = new stdClass();
			$info->base_url = '.';
			$this->layout_object->assign('info', $info);
		}

		return $this->layout_object->fetch('admin_item_editor.tpl');
	}

	private function save_item_types() {
		$this->db->autocommit(false);

		self::update_item_types();
		self::insert_item_types();
		self::delete_item_types();

		$result = $this->db->commit();
		$this->db->autocommit(true);
	} // end save_item_types

	private function update_item_types() {
		if (!isset($_POST['item_type'])) {
			return; // No item_type data to update
		}
		$data = $_POST['item_type'];
		$len = (isset($data['item_type_id']) && is_array($data['item_type_id'])) ? count($data['item_type_id']) : 0;
		
		for ($i = 0; $i < $len; $i++) {
			if ($data['item_type_id'][$i] != '') {
				if (!$data['item_type_available_from'][$i]) {
					$data['item_type_available_from'][$i] = '0000-00-00';
				}
				if (!$data['item_type_available_until'][$i]) {
					$data['item_type_available_until'][$i] = '0000-00-00';
				}

				$sql  = 'UPDATE
							item_types
						SET
							item_type_definition_id='.$this->db->real_escape_string($data['item_type_definition_id'][$i]);
				$sql .= " , item_type_text='".$this->db->real_escape_string($data['item_type_text'][$i])."'";
				$sql .= " , item_type_available_from='".$this->db->real_escape_string($data['item_type_available_from'][$i])."'";
				$sql .= " , item_type_available_until='".$this->db->real_escape_string($data['item_type_available_until'][$i])."'";
				$sql .= ' WHERE item_type_id='.$this->db->real_escape_string($data['item_type_id'][$i]);
				$sql .= ' AND item_id='.$this->id;
				$this->db->query($sql);
			}
		}
	} // end update_item_types

	private function insert_item_types() {
		if (!isset($_POST['item_type'])) {
			return; // No item_type data to insert
		}
		$data = $_POST['item_type'];
		$len = (isset($data['item_type_id']) && is_array($data['item_type_id'])) ? count($data['item_type_id']) : 0;

		$sql = 'INSERT INTO item_types (item_id, item_type_definition_id, item_type_text, item_type_available_from, item_type_available_until) VALUES ';
		$first = true;
		for ($i = 0; $i < $len; $i++) {
			if ($data['item_type_id'][$i] == '') {
				if ($first) {
					$first = false;
				} else {
					$sql .= ', ';
				}

				// Fix: Check if array keys exist before accessing them
				if (!isset($data['item_type_available_from'][$i]) || !$data['item_type_available_from'][$i]) {
					$data['item_type_available_from'][$i] = '0000-00-00';
				}
				if (!isset($data['item_type_available_until'][$i]) || !$data['item_type_available_until'][$i]) {
					$data['item_type_available_until'][$i] = '0000-00-00';
				}

				$sql .= " ('".
					$this->db->real_escape_string($this->id)."', '".
					$this->db->real_escape_string($data['item_type_definition_id'][$i])."', '".
					$this->db->real_escape_string($data['item_type_text'][$i] ?? '')."', '".
					$this->db->real_escape_string($data['item_type_available_from'][$i])."', '".
					$this->db->real_escape_string($data['item_type_available_until'][$i])."') ";
			}
		}

		if (!$first) {
			$this->db->query($sql);
		}

		return '';
	} // end insert_item_types

	private function delete_item_types() {
		if (isset($_POST['deletable_item_types'])) {
			$data = implode(', ',  $_POST['deletable_item_types']);

			$sql = 'DELETE FROM
						item_types
					WHERE
						item_type_id IN ('.$data.')
					AND
						item_id='.$this->id.';';

			$this->db->query($sql);
		}
	} // end delete_item_types

	private function get_item_type_definitions() {
		$sql = 'SELECT
					*
				FROM
					item_type_definitions';

		$result = $this->db->query($sql);

		if ($result->num_rows > 0) {
			$data = array();
			while ($obj = $result->fetch_object()) {
				$data[] = $obj;
			}

			return $data;
		}

		return false;
	} // end get_item_type_definitions

	private function add_item_type() {
		$item_type_definitions = self::get_item_type_definitions();
		$this->layout_object->assign('item_type_definitions', $item_type_definitions);
		
		// Create empty item_type object for new item type
		$item_type = new stdClass();
		$item_type->item_type_ordering = '';
		$item_type->item_type_id = '';
		$item_type->item_type_definition_id = '';
		$item_type->item_type_text = '';
		$item_type->item_type_definition_type = 0;
		$item_type->item_type_available_from = '';
		$item_type->item_type_available_until = '';
		$this->layout_object->assign('item_type', $item_type);
		
		// Ensure all show_* variables are set for snippet template
		$show_vars = ['show_price_and_marketing', 'show_attributes', 'show_versand', 'show_seo', 'show_lager', 'show_price_variants'];
		foreach ($show_vars as $var_name) {
			if (!$this->layout_object->getTemplateVars($var_name)) {
				$this->layout_object->assign($var_name, 0);
			}
		}
		
		// Ensure base_dir and info object are set for icon paths in snippet template
		if (!$this->layout_object->getTemplateVars('base_dir')) {
			$this->layout_object->assign('base_dir', '.');
		}
		if (!$this->layout_object->getTemplateVars('info')) {
			$info = new stdClass();
			$info->base_url = '.';
			$this->layout_object->assign('info', $info);
		}

		echo $this->layout_object->fetch('snipet_item_type.tpl');
		exit();
	} // end add_item_type

	protected function rename_item_document() {
		if (isset($_POST['document_id']) && isset($_POST['new_name'])) {
			$document_id = $_POST['document_id'];
			$new_name = $_POST['new_name'];

			if ($new_name != '') {
				if (!stristr('.pdf', $new_name)) {
					$new_name.'.pdf';
				}

				$sql = "UPDATE
							item_files
						SET
							alt='".$this->db->real_escape_string($new_name)."'
						WHERE
							id=".$this->db->real_escape_string($document_id);

				$this->db->query($sql);
			}
		}

		echo " ";
		exit();
	}

	protected function delete_item_document() {
		if (isset($_POST['document_id']) && isset($_POST['item_id'])) {
			$item_id = $_POST['item_id'];
			$document_id = $_POST['document_id'];

			$result = $this->item_object->delete_file($document_id, $item_id);

			if ($result) {
				$return_array = array('status' => 'success');
			} else {
				$return_array = array('status' => 'error');
			}
		} else {
			$return_array = array('status' => 'error');
		}

		echo json_encode($return_array);

		exit();
	}

	protected function upload_file() {
		// DEBUG: Log upload attempt mit Timestamps
		$debug_log = '/var/www/vhosts/intelectra.de/httpdocs/logs/upload_debug.log';
		$start = microtime(true);
		file_put_contents($debug_log, date('Y-m-d H:i:s') . " === UPLOAD_FILE START ===\n", FILE_APPEND);
		file_put_contents($debug_log, date('Y-m-d H:i:s') . " POST submit: " . (isset($_POST['submit']) ? $_POST['submit'] : 'NOT SET') . "\n", FILE_APPEND);
		file_put_contents($debug_log, date('Y-m-d H:i:s') . " FILES name: " . (isset($_FILES['Filedata']['name']) ? $_FILES['Filedata']['name'] : 'NOT SET') . "\n", FILE_APPEND);
		file_put_contents($debug_log, date('Y-m-d H:i:s') . " FILES size: " . (isset($_FILES['Filedata']['size']) ? $_FILES['Filedata']['size'] : 'NOT SET') . "\n", FILE_APPEND);
		file_put_contents($debug_log, date('Y-m-d H:i:s') . " FILES tmp_name: " . (isset($_FILES['Filedata']['tmp_name']) ? $_FILES['Filedata']['tmp_name'] : 'NOT SET') . "\n", FILE_APPEND);
		file_put_contents($debug_log, date('Y-m-d H:i:s') . " Item ID: " . (isset($_POST['id']) ? $_POST['id'] : 'NOT SET') . "\n", FILE_APPEND);

		$this->item_object->id = $_POST['id'];

		if ($_FILES['Filedata']['tmp_name'] != "") { // check if a file has been set
			file_put_contents($debug_log, date('Y-m-d H:i:s') . " [1] File found, starting processing...\n", FILE_APPEND);

			if (substr($_FILES['Filedata']['name'], -3) == 'pdf') { // check if file is pdf
				file_put_contents($debug_log, date('Y-m-d H:i:s') . " [2] PDF detected, calling add_uploaded_pdf\n", FILE_APPEND);
				$return_object = $this->item_object ->add_uploaded_pdf($_FILES);
			} else {
				file_put_contents($debug_log, date('Y-m-d H:i:s') . " [2] Image detected, calling add_uploaded_file\n", FILE_APPEND);
				$return_object = $this->item_object ->add_uploaded_file($_FILES, $_POST['watermark_activ']);
			}

			file_put_contents($debug_log, date('Y-m-d H:i:s') . " [3] Upload function returned: " . ($return_object ? 'SUCCESS' : 'FAILED') . "\n", FILE_APPEND);

			if ($return_object) {
				$return_data = array('status' => 'success', 'data' => $return_object);
			} else {
				$return_data = array('status' => 'error');
			}

			// 🔥 FIX: Bei Datei-Upload sofort Response senden und beenden!
			file_put_contents($debug_log, date('Y-m-d H:i:s') . " [4] Checking exit - submit=" . $_POST['submit'] . "\n", FILE_APPEND);
			if (isset($_POST['submit']) && $_POST['submit'] == 'Datei hochladen') {
				$elapsed = round((microtime(true) - $start) * 1000, 2);
				file_put_contents($debug_log, date('Y-m-d H:i:s') . " [5] EXIT - redirecting! (took {$elapsed}ms)\n", FILE_APPEND);
				header('Location: ./index.php?admin_modul=admin_item_editor&id=' . $this->item_object->id);
				exit();
			}
			file_put_contents($debug_log, date('Y-m-d H:i:s') . " [5] NO EXIT - continuing to update()!\n", FILE_APPEND);
		}

		return;
	}

	private function get_item_variants($item_id) {
		$sql = "SELECT
					items.*,
					item_schema.selectable_attribute_1,
					item_schema.selectable_attribute_2
				FROM
					items
				LEFT JOIN
					item_schema
				ON
					items.schema_id = item_schema.id
				WHERE
					items.id=".$this->db->real_escape_string($item_id);

		$request = $this->db->query($sql);

		$attributes_array_1 = false;
		$attributes_array_2 = false;
		$return_array = false;

		if ($request->num_rows > 0) {
			$data = $request->fetch_object();

			if (isset($data->selectable_attribute_1) && $data->selectable_attribute_1 != '0') {
				$attributes_array_1 = explode(';', $data->{'attribute_'.$data->selectable_attribute_1});
				$this->layout_object->assign('item_variants_1', $attributes_array_1);
			}

			if (isset($data->selectable_attribute_2) && $data->selectable_attribute_2 != '0') {
				$attributes_array_2 = explode(';', $data->{'attribute_'.$data->selectable_attribute_2});
				$this->layout_object->assign('item_variants_2', $attributes_array_2);
			}
		}
	} // end get_item_variants
}

?>