glpi_flush() static public méthode

Flush the current displayed items (do not works really fine)
static public glpi_flush ( )
Exemple #1
0
 /**
  * Manage progresse bars
  *
  * @since version 0.85
  *
  * @param $id                 HTML ID of the progress bar
  * @param $options    array   progress status
  *                    - create    do we have to create it ?
  *                    - message   add or change the message
  *                    - percent   current level
  *
  *
  * @return nothing (display)
  **/
 static function progressBar($id, array $options = array())
 {
     $params = array();
     $params['create'] = false;
     $params['message'] = NULL;
     $params['percent'] = -1;
     if (is_array($options) && count($options)) {
         foreach ($options as $key => $val) {
             $params[$key] = $val;
         }
     }
     if ($params['create']) {
         echo "<div class='doaction_cadre'>";
         echo "<div class='doaction_progress' id='{$id}'>";
         echo "<div class='doaction_progress_text' id='" . $id . "_text' >&nbsp;</div>";
         echo "</div>";
         echo "</div><br>";
         echo Html::scriptBlock(self::jsGetElementbyID($id) . ".progressbar();");
     }
     if ($params['message'] !== NULL) {
         echo Html::scriptBlock(self::jsGetElementbyID($id . '_text') . ".text(\"" . addslashes($params['message']) . "\");");
     }
     if ($params['percent'] >= 0 && $params['percent'] <= 100) {
         echo Html::scriptBlock(self::jsGetElementbyID($id) . ".progressbar('option', 'value', " . $params['percent'] . " );");
     }
     if (!$params['create']) {
         Html::glpi_flush();
     }
 }
function plugin_fusioninventory_displayMigrationMessage($id, $msg = "")
{
    static $created = 0;
    static $deb;
    if ($created != $id) {
        if (empty($msg)) {
            $msg = __('Work in progress...');
        }
        echo "<div id='migration_message_{$id}'><p class='center'>{$msg}</p></div>";
        $created = $id;
        $deb = time();
    } else {
        if (empty($msg)) {
            $msg = __('Task completed.');
        }
        $fin = time();
        $tps = Html::timestampToString($fin - $deb);
        echo "<script type='text/javascript'>document.getElementById('migration_message_{$id}')." . "innerHTML = '<p class=\"center\">{$msg} ({$tps})</p>';</script>\n";
    }
    Html::glpi_flush();
}
Exemple #3
0
 /**
  * Additional message in global message
  *
  * @param $msg    text  to display
  **/
 function displayMessage($msg)
 {
     $now = time();
     $tps = Html::timestampToString($now - $this->deb);
     echo "<script type='text/javascript'>document.getElementById('" . $this->current_message_area_id . "').innerHTML=\"<p class='center'>" . addslashes($msg) . " ({$tps})</p>\";" . "</script>\n";
     $this->flushLogDisplayMessage();
     $this->lastMessage = array('time' => time(), 'msg' => $msg);
     Html::glpi_flush();
 }
Exemple #4
0
/**  Restore a mysql dump
 *
 * @param $DB        DB object
 * @param $dumpFile  dump file
 * @param $duree     max delay before refresh
**/
function restoreMySqlDump($DB, $dumpFile, $duree)
{
    global $DB, $TPSCOUR, $offset, $cpt;
    // $dumpFile, fichier source
    // $duree=timeout pour changement de page (-1 = aucun)
    // Desactivation pour empecher les addslashes au niveau de la creation des tables
    // En plus, au niveau du dump on considere qu'on est bon
    // set_magic_quotes_runtime(0);
    if (!file_exists($dumpFile)) {
        echo sprintf(__('File %s not found.'), $dumpFile) . "<br>";
        return false;
    }
    if (substr($dumpFile, -2) == "gz") {
        $fileHandle = gzopen($dumpFile, "rb");
    } else {
        $fileHandle = fopen($dumpFile, "rb");
    }
    if (!$fileHandle) {
        //TRASN: %s is the name of the file
        echo sprintf(__('Unauthorized access to the file %s'), $dumpFile) . "<br>";
        return false;
    }
    if ($offset != 0) {
        if (substr($dumpFile, -2) == "gz") {
            if (gzseek($fileHandle, $offset, SEEK_SET) != 0) {
                //erreur
                //TRANS: %s is the number of the byte
                printf(__("Unable to find the byte %s"), Html::formatNumber($offset, false, 0));
                echo "<br>";
                return false;
            }
        } else {
            if (fseek($fileHandle, $offset, SEEK_SET) != 0) {
                //erreur
                //TRANS: %s is the number of the byte
                printf(__("Unable to find the byte %s"), Html::formatNumber($offset, false, 0));
                echo "<br>";
                return false;
            }
        }
        Html::glpi_flush();
    }
    $formattedQuery = "";
    if (substr($dumpFile, -2) == "gz") {
        while (!gzeof($fileHandle)) {
            current_time();
            if ($duree > 0 && $TPSCOUR >= $duree) {
                //on atteint la fin du temps imparti
                return true;
            }
            // specify read length to be able to read long lines
            $buffer = gzgets($fileHandle, 102400);
            // do not strip comments due to problems when # in begin of a data line
            $formattedQuery .= $buffer;
            if (substr(rtrim($formattedQuery), -1) == ";") {
                // Do not use the $DB->query
                if ($DB->query($formattedQuery)) {
                    //if no success continue to concatenate
                    $offset = gztell($fileHandle);
                    $formattedQuery = "";
                    $cpt++;
                }
            }
        }
    } else {
        while (!feof($fileHandle)) {
            current_time();
            if ($duree > 0 && $TPSCOUR >= $duree) {
                //on atteint la fin du temps imparti
                return true;
            }
            // specify read length to be able to read long lines
            $buffer = fgets($fileHandle, 102400);
            // do not strip comments due to problems when # in begin of a data line
            $formattedQuery .= $buffer;
            if (substr(rtrim($formattedQuery), -1) == ";") {
                // Do not use the $DB->query
                if ($DB->query($formattedQuery)) {
                    //if no success continue to concatenate
                    $offset = ftell($fileHandle);
                    $formattedQuery = "";
                    $cpt++;
                }
            }
        }
    }
    if ($DB->error) {
        echo "<hr>";
        //TRANS: %s is the SQL query which generates the error
        printf(__("SQL error starting from %s"), "[{$formattedQuery}]");
        echo "<br>" . $DB->error() . "<hr>";
    }
    if (substr($dumpFile, -2) == "gz") {
        gzclose($fileHandle);
    } else {
        fclose($fileHandle);
    }
    $offset = -1;
    return true;
}
Exemple #5
0
    $query = "SELECT `utf8_conv`\n             FROM `{$config_table}`\n             WHERE `id` = '1'";
    $result = $DB->query($query);
    $data = $DB->fetch_assoc($result);
    if ($data["utf8_conv"]) {
        $complete_utf8 = false;
    }
}
if ($offsettable >= 0 && $complete_utf8) {
    if ($percent >= 0) {
        Html::displayProgressBar(400, $percent);
        echo "</div></div></body></html>";
        Html::glpi_flush();
    }
    if (UpdateContent($DB, $duree, $rowlimit, $conv_utf8, $complete_utf8)) {
        echo "<br><a href='update_content.php?dump=1&amp;duree={$duree}&amp;rowlimit=" . "{$rowlimit}&amp;offsetrow={$offsetrow}&amp;offsettable={$offsettable}&amp;cpt={$cpt}'>" . __('Automatic redirection, else click') . "</a>";
        echo "<script language='javascript' type='text/javascript'>\n             window.location=\"update_content.php?dump=1&duree={$duree}&rowlimit={$rowlimit}&offsetrow=" . "{$offsetrow}&offsettable={$offsettable}&cpt={$cpt}\";</script>";
        Html::glpi_flush();
        exit;
    }
} else {
    echo "<p><a class='vsubmit' href='../index.php'>" . __('Use GLPI') . "</a></p>";
    echo "</div></div></body></html>";
}
if ($conv_utf8) {
    $query = "ALTER TABLE `{$config_table}`\n             ADD `utf8_conv` INT( 11 ) DEFAULT '0' NOT NULL";
    $DB->queryOrDie($query, " 0.6 add utf8_conv to {$config_table}");
}
if ($complete_utf8) {
    $DB->query("ALTER DATABASE `" . $DB->dbdefault . "` DEFAULT\n               CHARACTER SET utf8 COLLATE utf8_unicode_ci");
    $DB->query("UPDATE `{$config_table}`\n               SET `utf8_conv` = '1'\n               WHERE `id` = '1'");
}
/**
 * Upgrade => 1.16
 * 
 * Upgrade fields to be compatable with mysql strict mode
 */
function plugin_customfields_upgradeto116()
{
    global $DB;
    // Upgrade
    $query = "DROP TABLE IF EXISTS `glpi_plugin_customfields`";
    $DB->query($query) or die($DB->error());
    $query = "CREATE TABLE `glpi_plugin_customfields` (\n               `ID` int(11) NOT NULL auto_increment,\n               `device_type` int(11) NOT NULL default '0',\n               `enabled` smallint(6) NOT NULL default '0',\n               PRIMARY KEY (`ID`)\n             ) ENGINE=MyISAM\n             DEFAULT\n              CHARSET=utf8\n              COLLATE=utf8_unicode_ci\n              AUTO_INCREMENT=3";
    $DB->query($query) or die($DB->error());
    $query = "INSERT INTO `glpi_plugin_customfields`\n                    (`device_type`,`enabled`)\n             VALUES ('-1', '116')";
    $DB->query($query) or die($DB->error());
    $query = "INSERT INTO `glpi_plugin_customfields`\n                    (`device_type`)\n             VALUES ('1'), ('41'), ('4'), ('6'), ('39'), ('20'), ('2'),\n             ('42'), ('5'), ('3'), ('11'),\n                    ('17'), ('23'), ('16'), ('7'), ('8'), ('10'), ('13'),\n                    ('15'), ('27'), ('28')";
    $DB->query($query) or die($DB->error());
    $transform = array();
    $transform['general'] = 'VARCHAR(255) collate utf8_unicode_ci default NULL';
    $transform['dropdown'] = 'INT(11) NOT NULL default \'0\'';
    $transform['yesno'] = 'SMALLINT(6) NOT NULL default \'0\'';
    $transform['text'] = 'TEXT collate utf8_unicode_ci';
    $transform['notes'] = 'LONGTEXT collate utf8_unicode_ci';
    $transform['number'] = 'INT(11) NOT NULL default \'0\'';
    $transform['money'] = 'DECIMAL(20,4) NOT NULL default \'0.0000\'';
    $sql = "SELECT `itemtype`, `system_name`, `data_type`\n           FROM `glpi_plugin_customfields_fields`\n           WHERE `deleted` = 0\n                 AND `data_type` != 'sectionhead'\n                 AND `data_type` != 'date'\n           ORDER BY `itemtype`, `sort_order`, `ID`";
    $result = $DB->query($sql) or die($DB->error());
    set_time_limit(300);
    echo 'Updating Custom Fields...';
    while ($data = $DB->fetch_array($result)) {
        echo '.';
        Html::glpi_flush();
        $table = plugin_customfields_table($data['itemtype']);
        $field = $data['system_name'];
        $newtype = $transform[$data['data_type']];
        $sql = "ALTER TABLE `{$table}`\n              CHANGE `{$field}` `{$field}` {$newtype}";
        $DB->query($query) or die($DB->error());
        if (in_array($data['data_type'], array('general', 'text', 'notes'))) {
            $sql = "UPDATE `{$table}`\n                 SET `{$field}` = NULL\n                 WHERE `{$field}` = ''";
            $DB->query($sql) or die($DB->error());
        }
    }
    $query = "ALTER TABLE `glpi_plugin_customfields_fields`\n             CHANGE `system_name` `system_name` varchar(40)\n              collate utf8_unicode_ci default NULL,\n             CHANGE `label` `label` varchar(70)\n              collate utf8_unicode_ci default NULL,\n             CHANGE `default_value` `default_value` varchar(255)\n              collate utf8_unicode_ci default NULL,\n             CHANGE `dropdown_table` `dropdown_table` varchar(255)\n              collate utf8_unicode_ci default NULL";
    $DB->query($query) or die($DB->error());
    $query = "ALTER TABLE `glpi_plugin_customfields_dropdowns`\n             CHANGE `system_name` `system_name` varchar(40)\n              collate utf8_unicode_ci default NULL,\n             CHANGE `name` `name` varchar(70)\n              collate utf8_unicode_ci default NULL,\n             CHANGE `dropdown_table` `dropdown_table` varchar(255)\n              collate utf8_unicode_ci default NULL";
    $DB->query($query) or die($DB->error());
    $query = "UPDATE `glpi_plugin_customfields_fields`\n             SET `default_value` = NULL\n             WHERE `default_value` = ''";
    $DB->query($query) or die($DB->error());
    echo 'finished.';
    Html::glpi_flush();
}
 function displayReport(&$result, $PluginAddressingAddressing)
 {
     global $DB, $CFG_GLPI;
     $network = $PluginAddressingAddressing->fields["networks_id"];
     $ping = $PluginAddressingAddressing->fields["use_ping"];
     $PluginAddressingConfig = new PluginAddressingConfig();
     $PluginAddressingConfig->getFromDB('1');
     $system = $PluginAddressingConfig->fields["used_system"];
     // Set display type for export if define
     $output_type = Search::HTML_OUTPUT;
     if (isset($_GET["display_type"])) {
         $output_type = $_GET["display_type"];
     }
     $header_num = 1;
     $nbcols = 6;
     $ping_response = 0;
     $parameters = "id=";
     $row_num = 1;
     echo Search::showHeader($output_type, 1, $nbcols, 1);
     echo $this->displaySearchNewLine($output_type);
     echo Search::showHeaderItem($output_type, __('IP'), $header_num);
     echo Search::showHeaderItem($output_type, __('Connected to'), $header_num);
     echo Search::showHeaderItem($output_type, _n('User', 'Users', 1), $header_num);
     echo Search::showHeaderItem($output_type, __('MAC address'), $header_num);
     echo Search::showHeaderItem($output_type, __('Item type'), $header_num);
     echo Search::showHeaderItem($output_type, __('Free Ip', 'addressing'), $header_num);
     // End Line for column headers
     echo Search::showEndLine($output_type);
     $user = new User();
     foreach ($result as $num => $lines) {
         $ip = long2ip(substr($num, 2));
         if (count($lines)) {
             if (count($lines) > 1) {
                 $disp = $PluginAddressingAddressing->fields["double_ip"];
             } else {
                 $disp = $PluginAddressingAddressing->fields["alloted_ip"];
             }
             if ($disp) {
                 foreach ($lines as $line) {
                     $row_num++;
                     $item_num = 1;
                     $name = $line["dname"];
                     $namep = $line["pname"];
                     // IP
                     echo $this->displaySearchNewLine($output_type, count($lines) > 1 ? "double" : $row_num % 2);
                     echo Search::showItem($output_type, $ip, $item_num, $row_num);
                     // Device
                     $item = new $line["itemtype"]();
                     $link = Toolbox::getItemTypeFormURL($line["itemtype"]);
                     if ($line["itemtype"] != 'NetworkEquipment') {
                         if ($item->canView()) {
                             $output_iddev = "<a href='" . $link . "?id=" . $line["on_device"] . "'>" . $name . (empty($name) || $_SESSION["glpiis_ids_visible"] ? " (" . $line["on_device"] . ")" : "") . "</a>";
                         } else {
                             $output_iddev = $name . (empty($name) || $_SESSION["glpiis_ids_visible"] ? " (" . $line["on_device"] . ")" : "");
                         }
                     } else {
                         if ($item->canView()) {
                             if (empty($namep)) {
                                 $linkp = '';
                             } else {
                                 $linkp = $namep . " - ";
                             }
                             $output_iddev = "<a href='" . $link . "?id=" . $line["on_device"] . "'>" . $linkp . $name . (empty($name) || $_SESSION["glpiis_ids_visible"] ? " (" . $line["on_device"] . ")" : "") . "</a>";
                         } else {
                             $output_iddev = $namep . " - " . $name . (empty($name) || $_SESSION["glpiis_ids_visible"] ? " (" . $line["on_device"] . ")" : "");
                         }
                     }
                     echo Search::showItem($output_type, $output_iddev, $item_num, $row_num);
                     // User
                     if ($line["users_id"] && $user->getFromDB($line["users_id"])) {
                         $username = formatUserName($user->fields["id"], $user->fields["name"], $user->fields["realname"], $user->fields["firstname"]);
                         if ($user->canView()) {
                             $output_iduser = "******" . $CFG_GLPI["root_doc"] . "/front/user.form.php?id=" . $line["users_id"] . "'>" . $username . "</a>";
                         } else {
                             $output_iduser = $username;
                         }
                         echo Search::showItem($output_type, $output_iduser, $item_num, $row_num);
                     } else {
                         echo Search::showItem($output_type, " ", $item_num, $row_num);
                     }
                     // Mac
                     if ($line["id"]) {
                         if ($item->canView()) {
                             $output_mac = "<a href='" . $CFG_GLPI["root_doc"] . "/front/networkport.form.php?id=" . $line["id"] . "'>" . $line["mac"] . "</a>";
                         } else {
                             $output_mac = $line["mac"];
                         }
                         echo Search::showItem($output_type, $output_mac, $item_num, $row_num);
                     } else {
                         echo Search::showItem($output_type, " ", $item_num, $row_num);
                     }
                     // Type
                     echo Search::showItem($output_type, $item::getTypeName(), $item_num, $row_num);
                     // Reserved
                     if ($PluginAddressingAddressing->fields["reserved_ip"] && strstr($line["pname"], "reserv")) {
                         echo Search::showItem($output_type, __('Reserved Address', 'addressing'), $item_num, $row_num);
                     } else {
                         echo Search::showItem($output_type, " ", $item_num, $row_num);
                     }
                     // End
                     echo Search::showEndLine($output_type);
                 }
             }
         } else {
             if ($PluginAddressingAddressing->fields["free_ip"]) {
                 $row_num++;
                 $item_num = 1;
                 if (!$ping) {
                     echo $this->displaySearchNewLine($output_type, "free");
                     echo Search::showItem($output_type, $ip, $item_num, $row_num);
                     echo Search::showItem($output_type, " ", $item_num, $row_num);
                 } else {
                     if ($output_type == Search::HTML_OUTPUT) {
                         Html::glpi_flush();
                     }
                     if ($this->ping($system, $ip)) {
                         $ping_response++;
                         echo $this->displaySearchNewLine($output_type, "ping_off");
                         echo Search::showItem($output_type, $ip, $item_num, $row_num);
                         echo Search::showItem($output_type, __('Ping: got a response - used Ip', 'addressing'), $item_num, $row_num);
                     } else {
                         echo $this->displaySearchNewLine($output_type, "ping_on");
                         echo Search::showItem($output_type, $ip, $item_num, $row_num);
                         echo Search::showItem($output_type, __('Ping: no response - free Ip', 'addressing'), $item_num, $row_num);
                     }
                 }
                 echo Search::showItem($output_type, " ", $item_num, $row_num);
                 echo Search::showItem($output_type, " ", $item_num, $row_num);
                 echo Search::showItem($output_type, " ", $item_num, $row_num);
                 echo Search::showItem($output_type, " ", $item_num, $row_num);
                 echo Search::showEndLine($output_type);
             }
         }
     }
     // Display footer
     echo Search::showFooter($output_type, $PluginAddressingAddressing->getTitle());
     return $ping_response;
 }