[src=php]diff --git a/inventory.php b/inventory.php
index 313c58d..76d6a4d 100644
--- a/inventory.php
+++ b/inventory.php
@@ -109,7 +109,7 @@
} else if (isset($_GET['subcategory']) && !empty($_GET['subcategory'])) {
$categoryId = intVal($_GET['subcategory']);
$category = DB::queryFirstRow('SELECT id, name, amount from subCategories WHERE id=%d', $categoryId);
- $items = DB::query('SELECT * FROM items WHERE subcategories LIKE %ss', $categoryId);
+ $items = DB::query('SELECT * FROM items WHERE subcategories LIKE %s', ($categoryId . '%'));
printf('<div class="storage-area"><ul class="list-group"><h4>%s <small>(%d %s)</small></h4>', $category['name'], DB::affectedRows(), DB::affectedRows() == 1 ? 'Position' : 'Positionen');
$storages = DB::query('SELECT id, label FROM storages');
@@ -147,14 +147,14 @@
$storages = DB::query('SELECT id, label, amount FROM storages', $searchValue);
$headCategories = DB::query('SELECT id FROM headCategories WHERE name LIKE %ss', $searchValue);
- $subCategories = DB::query('SELECT id FROM subCategories WHERE name LIKE %ss', $searchValue);
+ $subCategories = DB::query('SELECT id FROM subCategories WHERE name LIKE %s', ($searchValue + '%'));
foreach ($storages as $store) {
$hasHeader = FALSE;
if ($headCategories != null) {
foreach ($headCategories as $headCategory) {
- $items = DB::query('SELECT * FROM items WHERE storageid=%d AND (headCategory=%d OR label LIKE %ss OR comment LIKE %ss OR serialnumber LIKE %ss OR subcategories LIKE %ss)', $store['id'], $headCategory['id'], $searchValue, $searchValue, $searchValue, $searchValue);
+ $items = DB::query('SELECT * FROM items WHERE storageid=%d AND (headCategory=%d OR label LIKE %ss OR comment LIKE %ss OR serialnumber LIKE %ss OR subcategories LIKE %s)', $store['id'], $headCategory['id'], $searchValue, $searchValue, $searchValue, ($searchValue + '%'));
if (!$hasHeader) {
addHeadColumnsPositions($store);
$hasHeader = TRUE;
@@ -165,7 +165,7 @@
}
} else {
foreach ($headCategories as $headCategory) {
- $items = DB::query('SELECT * FROM items WHERE storageid=%d AND (label LIKE %ss OR comment LIKE %ss OR serialnumber LIKE %ss OR subcategories LIKE %ss)', $store['id'], $searchValue, $searchValue, $searchValue, $searchValue);
+ $items = DB::query('SELECT * FROM items WHERE storageid=%d AND (label LIKE %ss OR comment LIKE %ss OR serialnumber LIKE %ss OR subcategories LIKE %s)', $store['id'], $searchValue, $searchValue, $searchValue, ($searchValue + '%'));
if ($items != null) {
foreach($items as $item) { addItem($item, $storages); }
@@ -177,7 +177,7 @@
if ($subCategories != null) {
foreach ($subCategories as $subCategory) {
- $items = DB::query('SELECT * FROM items WHERE storageid=%d AND (label LIKE %ss OR comment LIKE %ss OR serialnumber LIKE %ss OR subcategories LIKE %ss)', $store['id'], $subCategory['id'], $searchValue, $searchValue, $searchValue, $searchValue);
+ $items = DB::query('SELECT * FROM items WHERE storageid=%d AND (label LIKE %ss OR comment LIKE %ss OR serialnumber LIKE %ss OR subcategories LIKE %s)', $store['id'], $subCategory['id'], $searchValue, $searchValue, $searchValue, ($searchValue + '%'));
if (!$hasHeader) {
addHeadColumnsPositions($store);
$hasHeader = TRUE;
[/src]