*/
-function get_title($id)
-{
- global $db;
-
- $query = sprintf('SELECT name FROM metro_ordersatz WHERE id = %d', $id);
- $sth = $db->query($query);
- $row = $sth->fetch();
- if ($row) return 'Ordersatz für ' . $row['name'];
- else return 'Unbekannter Ordersatz';
-}
-
$href = "new Rico.TableColumn.link('./?mask=metro__ordersatz_pos&id={0}')";
# INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT ORDERID,id,'joey',now() FROM metro_artikel;
{
global $db;
- $sql = sprintf("INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT %d,id,%s,now() FROM metro_artikel",
+ $sql = sprintf("INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT %d,id,%s,now() " .
+ "FROM metro_artikel WHERE removed = 0",
$id, $db->quote($_SESSION['sys']['login']));
$sth = $db->query($sql);