# HG changeset patch # User Matti Hamalainen # Date 1385250170 -7200 # Node ID ef9a007c08769e7190b6ae8f4a09bee2a2d153c8 # Parent ed8d8d0164209d7fb372baa68dc6c1a4a756b400 Modularize and add methods for getting single entry. diff -r ed8d8d016420 -r ef9a007c0876 admajax.php --- a/admajax.php Sun Nov 24 01:42:25 2013 +0200 +++ b/admajax.php Sun Nov 24 01:42:50 2013 +0200 @@ -105,6 +105,23 @@ } +function stGetEntryItemData($eid, $item, $prefix) +{ + echo + " ".$eid."\n". + " ".($item["show_id"] > 0 ? $item["show_id"] : "-")."\n". + " ".stGetFormTextInput(20, SET_LEN_ENTRY_NAME, "name", $eid, $prefix, $item["name"])."\n". + " ".stGetFormTextInput(15, SET_LEN_ENTRY_AUTHOR, "author", $eid, $prefix, $item["author"])."\n". + " ".stGetFormTextInput(20, SET_LEN_ENTRY_FILENAME, "filename", $eid, $prefix, $item["filename"])."\n". + " ".stGetFormTextInput(20, SET_LEN_ENTRY_INFO, "info", $eid, $prefix, $item["info"])."\n". + " ". + stGetFormButtonInput("delete", $eid, $prefix, "Del", "deleteEntry(".$eid.")"). + stGetFormTextInput(3, 3, "compo_id", $eid, $prefix, $item["compo_id"]). + stGetFormButtonInput("update", $eid, $prefix, "Upd", "updateEntry(".$eid.")"). + "\n"; +} + + function stGetSaveButton() { return "\n"; @@ -284,6 +301,12 @@ } break; + case "entry": + $res = stFetchSQL(stPrepareSQL("SELECT * FROM entries WHERE id=%D", "id")); + if ($res !== FALSE) + echo stGetEntryItemData($res["id"], $res, "en"); + break; + case "entries": $id = intval(stGetRequestItem("id", 0)); if (($compo = stFetchSQL("SELECT * FROM compos WHERE id=".$id)) !== false) @@ -302,23 +325,11 @@ " Actions\n". " \n"; - $prefix = "en"; foreach (stExecSQL("SELECT * FROM entries WHERE compo_id=".$id) as $entry) { - $eid = $entry["id"]; echo - " \n". - " ".$eid."\n". - " ".($entry["show_id"] > 0 ? $entry["show_id"] : "-")."\n". - " ".stGetFormTextInput(20, SET_LEN_ENTRY_NAME, "name", $eid, "en", $entry["name"])."\n". - " ".stGetFormTextInput(15, SET_LEN_ENTRY_AUTHOR, "author", $eid, "en", $entry["author"])."\n". - " ".stGetFormTextInput(20, SET_LEN_ENTRY_FILENAME, "filename", $eid, "en", $entry["filename"])."\n". - " ".stGetFormTextInput(20, SET_LEN_ENTRY_INFO, "info", $eid, "en", $entry["info"])."\n". - " ". - stGetFormButtonInput("delete", $eid, $prefix, "Del", "deleteEntry(".$eid.")"). - stGetFormTextInput(3, 3, "compo_id", $eid, "en", $id). - stGetFormButtonInput("update", $eid, $prefix, "Upd", "updateEntry(".$eid.")"). - "\n". + " \n". + stGetEntryItemData($entry["id"], $entry, "en"). " \n"; }