phpmyadmin/libraries/rte/rte_footer.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Common functions for generating the footer for Routines, Triggers and Events.
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * Creates a fieldset for adding a new item, if the user has the privileges.
  14  *
  15  * @param string $docu String used to create a link to the MySQL docs
  16  * @param string $priv Privilege to check for adding a new item
  17  * @param string $name MySQL name of the item
  18  *
  19  * @return string An HTML snippet with the link to add a new item
  20  */
  21 function PMA_RTE_getFooterLinks($docu, $priv, $name)
  22 {
  23     global $db, $table, $url_query, $ajax_class;
  24
  25     $icon = /*overload*/mb_strtolower($name) . '_add.png';
  26     $retval  = "";
  27     $retval .= "<!-- ADD " . $name . " FORM START -->\n";
  28     $retval .= "<fieldset class='left'>\n";
  29     $retval .= "<legend>" . _pgettext('Create new procedure', 'New') . "</legend>\n";
  30     $retval .= "        <div class='wrap'>\n";
  31     if (PMA_Util::currentUserHasPrivilege($priv, $db, $table)) {
  32         $retval .= "            <a {$ajax_class['add']} ";
  33         $retval .= "href='db_" . /*overload*/mb_strtolower($name) . "s.php";
  34         $retval .= "$url_query&amp;add_item=1' ";
  35         $retval .= "onclick='$.datepicker.initialized = false;'>";
  36         $icon = 'b_' . $icon;
  37         $retval .= PMA_Util::getIcon($icon);
  38         $retval .= PMA_RTE_getWord('add') . "</a>\n";
  39     } else {
  40         $icon = 'bd_' . $icon;
  41         $retval .= PMA_Util::getIcon($icon);
  42         $retval .= PMA_RTE_getWord('add') . "\n";
  43     }
  44     $retval .= "            " . PMA_Util::showMySQLDocu($docu) . "\n";
  45     $retval .= "        </div>\n";
  46     $retval .= "</fieldset>\n";
  47     $retval .= "<!-- ADD " . $name . " FORM END -->\n\n";
  48
  49     return $retval;
  50 } // end PMA_RTE_getFooterLinks()
  51
  52 /**
  53  * Creates a fieldset for adding a new routine, if the user has the privileges.
  54  *
  55  * @return string    HTML code with containing the footer fieldset
  56  */
  57 function PMA_RTN_getFooterLinks()
  58 {
  59     return PMA_RTE_getFooterLinks('CREATE_PROCEDURE', 'CREATE ROUTINE', 'ROUTINE');
  60 }// end PMA_RTN_getFooterLinks()
  61
  62 /**
  63  * Creates a fieldset for adding a new trigger, if the user has the privileges.
  64  *
  65  * @return string    HTML code with containing the footer fieldset
  66  */
  67 function PMA_TRI_getFooterLinks()
  68 {
  69     return PMA_RTE_getFooterLinks('CREATE_TRIGGER', 'TRIGGER', 'TRIGGER');
  70 } // end PMA_TRI_getFooterLinks()
  71
  72 /**
  73  * Creates a fieldset for adding a new event, if the user has the privileges.
  74  *
  75  * @return string    HTML code with containing the footer fieldset
  76  */
  77 function PMA_EVN_getFooterLinks()
  78 {
  79     global $db, $url_query;
  80
  81     /**
  82      * For events, we show the usual 'Add event' form and also
  83      * a form for toggling the state of the event scheduler
  84      */
  85     // Init options for the event scheduler toggle functionality
  86     $es_state = $GLOBALS['dbi']->fetchValue(
  87         "SHOW GLOBAL VARIABLES LIKE 'event_scheduler'",
  88         0,
  89         1
  90     );
  91     $es_state = /*overload*/mb_strtolower($es_state);
  92     $options = array(
  93                     0 => array(
  94                         'label' => __('OFF'),
  95                         'value' => "SET GLOBAL event_scheduler=\"OFF\"",
  96                         'selected' => ($es_state != 'on')
  97                     ),
  98                     1 => array(
  99                         'label' => __('ON'),
 100                         'value' => "SET GLOBAL event_scheduler=\"ON\"",
 101                         'selected' => ($es_state == 'on')
 102                     )
 103                );
 104     // Generate output
 105     $retval  = "<!-- FOOTER LINKS START -->\n";
 106     $retval .= "<div class='doubleFieldset'>\n";
 107     // show the usual footer
 108     $retval .= PMA_RTE_getFooterLinks('CREATE_EVENT', 'EVENT', 'EVENT');
 109     $retval .= "    <fieldset class='right'>\n";
 110     $retval .= "        <legend>\n";
 111     $retval .= "            " . __('Event scheduler status') . "\n";
 112     $retval .= "        </legend>\n";
 113     $retval .= "        <div class='wrap'>\n";
 114     // show the toggle button
 115     $retval .= PMA_Util::toggleButton(
 116         "sql.php$url_query&amp;goto=db_events.php" . urlencode("?db=$db"),
 117         'sql_query',
 118         $options,
 119         'PMA_slidingMessage(data.sql_query);'
 120     );
 121     $retval .= "        </div>\n";
 122     $retval .= "    </fieldset>\n";
 123     $retval .= "    <div style='clear: both;'></div>\n";
 124     $retval .= "</div>";
 125     $retval .= "<!-- FOOTER LINKS END -->\n";
 126
 127     return $retval;
 128 } // end PMA_EVN_getFooterLinks()
 129