Add(_('Delete prohibited, invalid security token!')); $action = ACT_VIEW; break; } // tagref have to be empty // TODO $action = ACT_DEFAULT; break; default: $g_error->Add(sprintf(_('Unknown function!'), $submit)); $valid = FALSE; } // ========== ACTIONS END ===================================================== require 'header.php'; // ========== PAGE CONTENT ==================================================== if ($action == ACT_DEFAULT): // ========== VARIANT: default behavior ======================================= // load filter from db $flt = db_get_filter($user->id, 210, ['txt']); echo "

$pagetitle

\n"; // db_save_taglist('inv', 1, 'apple, banana , , , orange, ddd'); // Filter ?>
Filter
query($sql); $res = $sth->fetchAll(); echo '', "\n"; echo "\n"; echo "\n"; echo ''; echo '"; echo '"; echo '"; echo ""; echo "\n"; echo "\n"; $i = 0; foreach ($res as $row) { $i++; // record number echo "\n"; echo '\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } // Table summary table_rec_summary($i0, $i, $numrows, 6); echo "
#', _('Tag'), "', _('Description'), "', _('Color'), "
', $i; echo '', "\n"; echo "", $row['tagname'], "", $row['description'], "", format_color($row['color']), ""; // Edit current record button echo ""; echo '', "\n"; echo "
\n"; form_add_button($g_scriptname); elseif ($action == ACT_ADD): // ========== VARIANT: add record ============================================= echo '

', _('Add Tag'), "

\n"; ?>
\n"; elseif ($action == ACT_VIEW): // ========== VARIANT: view single record ===================================== $sql = "SELECT tagname, description, color " . "FROM tag " . "WHERE tagid=?"; $sth = $pdo->prepare($sql); $sth->execute([$id]); $tag = $sth->fetch(PDO::FETCH_OBJ); echo '

', _('View Tag'), "

\n"; echo '', "\n"; echo '\n"; echo '\n"; echo '\n"; echo "
', _('Tag'),"", $tag->tagname, "
', _('Color'),"", format_color($tag->color), "
', _('Description'),"", $tag->description, "
\n"; form_view_buttons($g_scriptname, $id); echo '

', _('Tag usage'), "

\n"; $sql = "SELECT objid, objtype FROM tagref WHERE tagid=?"; $sth = $pdo->prepare($sql); $sth->execute([$id]); echo '

'; if ($sth->rowCount() > 0) { $res = $sth->fetchAll(); foreach ($res as $row) { // select object name or description depending on objecttype // TODO function db_get_tag_target($objtype, $objid); /*switch ($row['objtype']) { case 'equip': $sql = "SELECT ename FROM equipment WHERE eid=?"; $target = "equipment.php"; break; case 'inv': $sql = "SELECT invname FROM inventory WHERE invid=?"; $target = "inventory.php"; break; case 'prov': $sql = "SELECT provname FROM provisions WHERE provvid=?"; $target = "provisions.php"; break; case 'doc': $sql = "SELECT title FROM document WHERE docid=?"; $target = "documents.php"; break; case 'proj': $sql = "SELECT projname FROM project WHERE projid=?"; $target = "projects.php"; break; case 'task': $sql = "SELECT taskname FROM task WHERE taskid=?"; $target = "task.php"; break; case 'maint': $sql = "SELECT activities FROM maintenance WHERE maintid=?"; $target = 'maintenance.php'; break; } $sth = $pdo->prepare($sql); $sth->execute([$row['objid']]); $desc = $sth->fetchColumn(); */ [$target, $desc] = db_get_tag_target($row['objtype'], $row['objid']); echo '', $desc, ' (', $row['objid'], '/', $row['objtype'], ")\n"; } } else { echo _('Tag is not used anywhere'); } echo "

\n"; echo '

', _('Related tags'), "

\n"; echo '

', _('Not yet implemented'), "

\n"; elseif ($action == ACT_EDIT): // ========== VARIANT: edit single record ===================================== $sql = "SELECT tagname, description, color " . "FROM tag " . "WHERE tagid=?"; $sth = $pdo->prepare($sql); $sth->execute([$id]); $tag = $sth->fetch(PDO::FETCH_OBJ); echo '

', _('Edit tag'), "

\n"; ?>
\n"; elseif ($action == ACT_DELETE): // ========== VARIANT: delete record ========================================== echo '

', _('Delete tag'), "

\n"; $sql = "SELECT objid, objtype FROM tagref WHERE tagid=?"; $sth = $pdo->prepare($sql); $sth->execute([$id]); if ($sth->rowCount() > 0) { foreach ($sth->fetchAll() as $row) { echo '', $row['objid'], '/', $row['objtype'], "\n"; } } else { echo _('Tag is not used anywhere'); $_SESSION['token'] = bin2hex(random_bytes(8)); form_delete_buttons($g_scriptname, $id, $_SESSION['token']); } else: // ========== ERROR UNKNOWN VARIANT =========================================== echo '

', _('Unknown function call: Please report to system development!'), "

\n"; endif; // $action == ... // ========== END OF VARIANTS ================================================= include 'footer.php';