]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/admin-inc.php
Rewritten handling of menu weightning and updating/deleting menu entries except admin...
[mailer.git] / inc / modules / admin / admin-inc.php
index e10ccf0f24b9b228955a7bc8dada4b777a91ffcb..0f7b4897f77c582b048c75ed197ccc9bc61d519e 100644 (file)
@@ -14,8 +14,6 @@
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
@@ -177,6 +175,9 @@ function doAdminAction () {
        } else {
                $content['welcome'] = loadTemplate('admin_welcome', true, $content);
        }
+
+       // Load header, footer, render menu
+       $content['header'] = loadTemplate('admin_header' , true, $content);
        $content['footer'] = loadTemplate('admin_footer' , true, $content);
        $content['menu']   = addAdminMenu($action, $what, true);
 
@@ -501,7 +502,7 @@ function adminSaveSettings (&$postData, $tableName = '_config', $whereStatement
                                } // END - if
 
                                // Shall we add numbers or strings?
-                               $test = (float)$val;
+                               $test = (float) $val;
                                if ('' . $val . '' == '' . $test . '') {
                                        // Add numbers
                                        $tableData[] = sprintf("`%s`=%s", $id, $test);
@@ -586,7 +587,7 @@ function adminSaveSettings (&$postData, $tableName = '_config', $whereStatement
 // Generate a selection box
 function adminAddMenuSelectionBox ($menu, $type, $name, $default = '') {
        // Open the requested menu directory
-       $menuArray = getArrayFromDirectory(sprintf("inc/modules/%s/", $menu), '', false, false);
+       $menuArray = getArrayFromDirectory(sprintf("inc/modules/%s/", $menu), $type . '-', false, false);
 
        // Init the selection box
        $OUT = '<select name="' . $name . '" class="form_select" size="1"><option value="">{--ADMIN_IS_TOP_MENU--}</option>';
@@ -1359,7 +1360,7 @@ function generateUnconfirmedAdminLink ($id, $unconfirmed, $type = 'bid') {
        // Do we have unconfirmed mails?
        if ($unconfirmed > 0) {
                // Add link to list_unconfirmed what-file
-               $OUT = '<a href="{%url=modules.php?module=admin&amp;what=list_unconfirmed&amp;' . $type . '=' . $id . '%}">' . translateComma($unconfirmed) . '</a>';
+               $OUT = '<a href="{%url=modules.php?module=admin&amp;what=list_unconfirmed&amp;' . $type . '=' . $id . '%}">{%pipe,translateComma=' . $unconfirmed . '%}</a>';
        } // END - if
 
        // Return it
@@ -1428,5 +1429,124 @@ function addEmailNavigation ($numPages, $offset, $show_form, $colspan, $return=f
        }
 }
 
+// Process menu editing form
+function adminProcessMenuEditForm ($type, $subMenu) {
+       // An action is done...
+       foreach (postRequestParameter('sel') as $sel => $menu) {
+               $AND = "(`what` = '' OR `what` IS NULL)";
+
+               $sel = bigintval($sel);
+
+               if (!empty($subMenu)) {
+                       $AND = "`action`='" . $subMenu . "'";
+               } // END - if
+
+               switch (postRequestParameter('ok')) {
+                       case 'edit': // Edit menu
+                               if (postRequestParameter('sel_what', $sel) == '') {
+                                       // Update with 'what'=null
+                                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_%s_menu` SET `title`='%s', `action`='%s', `what`=NULL WHERE ".$AND." AND `id`=%s LIMIT 1",
+                                               array(
+                                                       $type,
+                                                       $menu,
+                                                       postRequestParameter('sel_action', $sel),
+                                                       $sel
+                                               ), __FILE__, __LINE__);
+                               } else {
+                                       // Update with selected 'what'
+                                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_%s_menu` SET `title`='%s', `action`='%s', `what`='%s' WHERE ".$AND." AND `id`=%s LIMIT 1",
+                                               array(
+                                                       $type,
+                                                       $menu,
+                                                       postRequestParameter('sel_action', $sel),
+                                                       postRequestParameter('sel_what', $sel),
+                                                       $sel
+                                               ), __FILE__, __LINE__);
+                               }
+                               break;
+
+                       case 'delete': // Delete menu
+                               SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE ".$AND." AND `id`=%s LIMIT 1",
+                                       array($type, $sel), __FILE__, __LINE__);
+                               break;
+
+                       case 'status': // Change status of menus
+                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_%s_menu` SET `visible`='%s', `locked`='%s' WHERE ".$AND." AND `id`=%s LIMIT 1",
+                                       array($type, postRequestParameter('visible', $sel), postRequestParameter('locked', $sel), $sel), __FILE__, __LINE__);
+                               break;
+
+                       default: // Unexpected action
+                               logDebugMessage(__FILE__, __LINE__, sprintf("Unsupported action %s detected.", postRequestParameter('ok')));
+                               loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_UNKNOWN_OKAY', postRequestParameter('ok')));
+                               break;
+               } // END - switch
+       } // END - foreach
+
+       // Load template
+       loadTemplate('admin_settings_saved', false, '{--SETTINGS_SAVED--}');
+}
+
+// Handle weightning
+function doAdminProcessMenuWeightning ($type) {
+       // Are there all required (generalized) GET parameter?
+       if ((isGetRequestParameterSet('act')) && (isGetRequestParameterSet('tid')) && (isGetRequestParameterSet('fid'))) {
+               // Init variables
+               $tid = ''; $fid = '';
+
+               // Get ids
+               if (isGetRequestParameterSet('w')) {
+                       // Sub menus selected
+                       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE `action`='%s' AND `sort`=%s LIMIT 1",
+                               array(
+                                       $type,
+                                       getRequestParameter('act'),
+                                       bigintval(getRequestParameter('tid'))
+                               ), __FILE__, __LINE__);
+                       list($tid) = SQL_FETCHROW($result);
+                       SQL_FREERESULT($result);
+                       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE `action`='%s' AND `sort`=%s LIMIT 1",
+                               array(
+                                       $type,
+                                       getRequestParameter('act'),
+                                       bigintval(getRequestParameter('fid'))
+                               ), __FILE__, __LINE__);
+                       list($fid) = SQL_FETCHROW($result);
+                       SQL_FREERESULT($result);
+               } else {
+                       // Main menu selected
+                       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE (`what`='' OR `what` IS NULL) AND `sort`=%s LIMIT 1",
+                               array(
+                                       $type,
+                                       bigintval(getRequestParameter('tid'))
+                               ), __FILE__, __LINE__);
+                       list($tid) = SQL_FETCHROW($result);
+                       SQL_FREERESULT($result);
+                       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE (`what`='' OR `what` IS NULL) AND `sort`=%s LIMIT 1",
+                               array(
+                                       $type,
+                                       bigintval(getRequestParameter('fid'))
+                               ), __FILE__, __LINE__);
+                       list($fid) = SQL_FETCHROW($result);
+                       SQL_FREERESULT($result);
+               }
+
+               if ((!empty($tid)) && (!empty($fid))) {
+                       // Sort menu
+                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_%s_menu` SET `sort`=%s WHERE ".$AND." AND `id`=%s LIMIT 1",
+                               array(
+                                       $type,
+                                       bigintval(getRequestParameter('tid')),
+                                       bigintval($fid)
+                               ), __FILE__, __LINE__);
+                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_%s_menu` SET `sort`=%s WHERE ".$AND." AND `id`=%s LIMIT 1",
+                               array(
+                                       $type,
+                                       bigintval(getRequestParameter('fid')),
+                                       bigintval($tid)
+                               ), __FILE__, __LINE__);
+               } // END - if
+       } // END - if
+}
+
 // [EOF]
 ?>