* Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
*
* Copyright (C) 2008 by Gleb Y. Averchuk <*****@*****.**>
* Vedro System - Web CMS с удобными компонентами для работы с БД.
*/
include "global.php";
require_once "classes/table.php";
function GroupList()
{
include "global.php";
$sql = "SELECT id, name " . "FROM groups WHERE is_deleted=0 " . "ORDER by name";
$colums = array("name" => new Column("Название"), "delete" => new Column_Button("Действие", "?action=group_delete", "id", "удалить"));
$colums["name"]->SetLink("group_edit.php", "id");
$table = new Table($db, "system_group_list", $sql, $colums);
$table->SetTheme("system");
$table->Show_PageSwitch(false);
$table->Show();
}
function GroupDelete()
{
include "global.php";
if (!isset($_GET["id"])) {
return;
}
$db->Query("UPDATE groups SET is_deleted=1 WHERE id='" . $_GET["id"] . "'");
}
if (isset($_GET["action"]) && $_GET["action"] == "group_delete") {
GroupDelete();
}
GroupList();
}
}
return $nodegrouplist;
}
if (isset($_POST['from']) && isset($_POST['to'])) {
$from = $_POST['from'];
$to = $_POST['to'];
if ($from != '' && $to != '' && $from != $to) {
$prio['from'] = $DB->GetOne('SELECT prio FROM nodegroups WHERE id=?', array($from));
$prio['to'] = $DB->GetOne('SELECT prio FROM nodegroups WHERE id=?', array($to));
if ($prio['to'] < $prio['from']) {
$DB->Execute('UPDATE nodegroups SET prio=prio+1 WHERE id<>? AND prio<? AND prio>=?', array($from, $prio['from'], $prio['to']));
} else {
$DB->Execute('UPDATE nodegroups SET prio=prio-1 WHERE id<>? AND prio<=? AND prio>?', array($from, $prio['to'], $prio['from']));
}
$DB->Execute('UPDATE nodegroups SET prio=? WHERE id=?', array($prio['to'], $from));
$LMS->CompactNodeGroups();
}
} else {
$from = 0;
}
$layout['pagetitle'] = trans('Node Groups List');
$nodegrouplist = GroupList();
$listdata['total'] = $nodegrouplist['total'];
$listdata['nodestotal'] = $nodegrouplist['nodestotal'];
unset($nodegrouplist['total']);
unset($nodegrouplist['nodestotal']);
$SMARTY->assign('selectednodegroupid', $from);
$SMARTY->assign('nodegrouplist', $nodegrouplist);
$SMARTY->assign('listdata', $listdata);
$SMARTY->display('nodegrouplist.html');
$log[] = $lang['mnsent'];
}
}
$view->info('<ul><li>' . join('</li><li>', $log) . '</li></ul>');
} elseif (isset($_POST['next'])) {
$ile = 0;
$lv = Prepare($_POST['lv']);
$gr = Prepare($_POST['gr']);
if ($lv && $gr) {
$ile = dbCount('users WHERE mails=1 AND lv IN(' . $lv . ') AND ID IN (SELECT u FROM ' . PRE . 'groupuser WHERE g IN(' . $gr . '))');
}
if ($ile == 0) {
$view->info($lang['nousnd']);
}
}
#Show form
if (isset($_POST['next']) && $ile > 0) {
$view->script('./lib/editor.js');
//Edytor
$view->script('./cache/emots.js');
//Emotki
$view->script(LANG_DIR . 'edit.js');
//Jêzyk
$view->add('mailing', array('start' => false, 'cfg' => &$cfg, 'level' => $lv, 'group' => $gr, 'title' => $lang['massl'] . $ile));
}
#START
if (!$_POST) {
include './lib/user.php';
$view->info($lang['apmm1']);
$view->add('mailing', array('levels' => LevelList('all', 1), 'groups' => GroupList('all'), 'start' => true));
}
