X-Git-Url: https://git.infodrom.org/?p=misc%2Fhallinta-metro;a=blobdiff_plain;f=ordersatz_pos.php;h=8bb8cd164d50dc61bd4cee96943cb9f3daa479f7;hp=942cae406a60929f50589653d9c53c4bf28d984f;hb=1547f4a3265f3e4a59ca9cbd5a0f891b49e70622;hpb=16e5a2b1e6e711c9d8315d4594e328a1e07f765f

diff --git a/ordersatz_pos.php b/ordersatz_pos.php
index 942cae4..8bb8cd1 100644
--- a/ordersatz_pos.php
+++ b/ordersatz_pos.php
@@ -127,7 +127,7 @@ function get_title($id)
 $mask = array(
 	      'table' => 'metro_ordersatz',
 	      'join' => array('metro_ordersatz_pos ON ordersatz = metro_ordersatz.id',
-			      'metro_artikel ON artikel = metro_artikel.id'),
+			      'metro_artikel ON artikel = metro_artikel.id AND removed = 0'),
 	      'title' => get_title($_SESSION['ordersatz']),
 	      'edit_title' => 'Ordersatz',
 	      'where' => sprintf('ordersatz = %d AND owner = %d', $_SESSION['ordersatz'], $_SESSION['sys']['uid']),
@@ -227,7 +227,10 @@ $mask = array(
 				 ),
 	      );
 
-if ($done) unset($mask['edit']);
+if ($done) {
+  unset($mask['edit']);
+  $mask['join'] = str_replace(' AND removed = 0','',$mask['join']);
+}
 
 function cb_cellsave()
 {