<?php /** @var $model \bbn\mvc\model */ // DB connection $db =& $model->data['db']; if (!empty($db) && !empty($model->data['id_lib'])) { // Get all library's versions $versions = $db->get_rows("\n SELECT versions.*, \n CASE WHEN versions.name = libraries.latest THEN 1 ELSE 0 END AS is_latest\n FROM versions\n JOIN libraries\n ON versions.library = libraries.name\n WHERE versions.library = ?\n ORDER BY internal DESC", $model->data['id_lib']); foreach ($versions as $i => $ver) { // Get all version's dependencies $versions[$i]['dependencies'] = $db->get_rows("\n SELECT libraries.title, libraries.name, versions.name AS version\n FROM dependencies\n LEFT JOIN versions\n ON id_master = versions.id\n LEFT JOIN libraries\n ON versions.library = libraries.name\n WHERE id_slave = ?\n GROUP BY libraries.title\n ORDER BY libraries.name", $ver['id']); // Get all version's slave dependencies $versions[$i]['slave_dependencies'] = $db->get_rows("\n SELECT libr.name, libr.title, vers.name AS version\n FROM versions\n JOIN libraries\n ON versions.library = libraries.name\n AND versions.name = libraries.latest\n JOIN dependencies \n ON versions.id = dependencies.id_master\n JOIN versions AS vers\n ON dependencies.id_slave = vers.id\n JOIN libraries AS libr\n ON vers.library = libr.name\n WHERE versions.id = ?\n GROUP BY libr.name\n ORDER BY libr.title COLLATE NOCASE ASC, vers.internal DESC", $ver['id']); // Make version's files TreeView $versions[$i]['files_tree'] = \bbn\x::make_tree((array) json_decode($ver['content'])); } return $versions; } else { if (!empty($model->data['folder']) && !empty(BBN_CDN_PATH)) { // Library path $lib_path = BBN_CDN_PATH . 'lib/' . $model->data['folder']; // Check if the library's subfolders are already inserted into db and use the first not included as version if (is_dir($lib_path) && ($dirs = \bbn\file\dir::get_dirs($lib_path))) { $ver = []; foreach ($dirs as $dir) { if (empty($db->select('versions', [], ['name' => basename($dir), 'library' => $model->data['folder']]))) { array_push($ver, $dir); } } if (empty($ver)) { return ['error' => _("All library's versions (subfolders) are existing into database.")];
<?php if (isset($ctrl->post['session'])) { echo \bbn\x::make_tree($ctrl->inc->session->get()) . '<p> </p><hr><p> </p>' . \bbn\x::make_tree($_SERVER); } else { $ctrl->set_title('Infos Session'); echo '<h2><button class="k-button" onclick="appui.fn.post(\'' . $ctrl->say_dir() . '/session\', {session:1}, $(\'#info_session_container\'));"><i class="fa fa-refresh"> </i></button> Infos de session</h2>' . '<div class="appui-line-break">' . '</div>' . '<div id="info_session_container" class="appui-nl"> </div>'; $ctrl->add_script("appui.fn.post('" . $ctrl->say_dir() . "/session', {session:1}, \$('#info_session_container'));"); }