protected function handler_participants(Collection $activities, $fields)
{
$res = XDB::iterator('SELECT id, participant
FROM activities_participants
WHERE id IN {?}', $activities->ids());
$users = new Collection('User');
$part = array();
while ($datas = $res->next()) {
$part[$datas['id']][] = $users->addget($datas['participant']);
}
foreach ($part as $key => $obj) {
$activities->get($key)->participants($obj);
}
$users->select($this->subs['participants']);
}
function handler_logs_sessions($page)
{
$iter = XDB::iterator('SELECT id, uid, host, ip, forward_ip, forward_host,
browser, suid, flags, start
FROM log_sessions
ORDER BY start DESC
LIMIT 50');
$sessions = array();
$users = new Collection('User');
while ($session = $iter->next()) {
$user = $users->addget($session['uid']);
$sessions[$session['id']] = array('user' => $user, 'host' => $session['host'], 'ip' => uint_to_ip($session['ip']), 'forward_host' => $session['forward_host'], 'forward_ip' => uint_to_ip($session['forward_ip']), 'browser' => $session['browser'], 'suid' => $session['suid'], 'flags' => $session['flags'], 'start' => new FrankizDateTime($session['start']));
}
$users->select(UserSelect::base());
$page->assign('title', "Logs des sessions");
$page->assign('sessions', $sessions);
$page->changeTpl('admin/logs_sessions.tpl');
}
public static function all()
{
$res = XDB::iterator('SELECT id, date, question, answer1, answer2, count1, count2, writer
FROM qdj
WHERE date!="0000-00-00" AND date<NOW()
ORDER BY date DESC');
$qdjs = new Collection('QDJ');
$users = new Collection('User');
while ($datas = $res->next()) {
$datas['writer'] = $users->addget($datas['writer']);
$datas['date'] = new FrankizDateTime($datas['date']);
$qdjs->addget($datas['id'])->fillFromArray($datas);
}
$users->select(UserSelect::base());
return $qdjs;
}
/**
* Select a collection from the database
*
* @param Collection $metas The objects to select
* @param string $field collection field
*/
protected function helper_collection(Collection $metas, $field)
{
// Retrieve link attributes
list($l_className, $table, $l_id, $id) = $this->schema->collectionType($field);
$_metas = array();
foreach ($metas as $meta) {
$_metas[$meta->id()] = new Collection($l_className);
}
// Get collection ids
$iter = XDB::iterRow("SELECT {$id}, {$l_id}\n FROM {$table}\n WHERE {$id} IN {?}", $metas->ids());
$linkeds = new Collection($l_className);
while (list($id, $l_id) = $iter->next()) {
$linked = $linkeds->addget($l_id);
$_metas[$id]->add($linked);
}
// Update metas
foreach ($metas as $meta) {
$meta->fillFromArray(array($field => $_metas[$meta->id()]));
}
if (!empty($this->subs[$field])) {
$linkeds->select($this->subs[$field]);
}
}
protected function handler_castes(Collection $users, $fields)
{
$_users = array();
foreach ($users as $user) {
$_users[$user->id()] = new Collection('Caste');
}
// Bootstrap session
$newuid = S::i('newuid');
if (S::has('newuid') && in_array($newuid, $users->ids())) {
$iter = XDB::iterRow('SELECT uid, cid
FROM castes_users
WHERE uid IN {?}', $users->ids());
} else {
$iter = XDB::iterRow('SELECT uid, cid
FROM castes_users
WHERE uid IN {?} AND
(visibility IN {?} OR uid IN {?})', $users->ids(), S::user()->visibleGids(), array($newuid, S::user()->id()));
}
$linkeds = new Collection('Caste');
while (list($uid, $cid) = $iter->next()) {
$linked = $linkeds->addget($cid);
$_users[$uid]->add($linked);
}
foreach ($users as $user) {
$user->fillFromArray(array('castes' => $_users[$user->id()]));
}
if (!empty($this->subs['castes'])) {
$linkeds->select($this->subs['castes']);
}
}
public static function batchFrom(array $mixed)
{
$collec = new Collection('Caste');
if (!empty($mixed)) {
$sql = array();
foreach ($mixed as $mix) {
$sql[] = XDB::format('(`group` = {?} AND rights = {?})', Group::toId($mix['group']), (string) $mix['rights']);
}
$iter = XDB::iterRow('SELECT cid, `group`, rights
FROM castes
WHERE ' . implode(' OR ', $sql));
$groups = new Collection('Group');
while (list($cid, $group, $rights) = $iter->next()) {
$group = $groups->addget($group);
$collec->add(new self(array('id' => $cid, 'group' => $group, 'rights' => new Rights($rights))));
}
}
return $collec;
}
public static function batchSelect(array $wikis, $options = null)
{
if (empty($wikis)) {
return;
}
$bits = self::optionsToBits($options);
$wikis = array_combine(self::toIds($wikis), $wikis);
$joins = array();
$cols = array();
if ($bits & self::SELECT_BASE) {
$cols['w'] = array('name', 'comments');
}
if ($bits & self::SELECT_COUNT || $bits & self::SELECT_VERSION) {
$cols[-1] = array('COUNT(wv.version) AS count');
$joins['wv'] = PlSqlJoin::left('wiki_version', '$ME.wid = w.wid');
}
if (!empty($cols)) {
$iter = XDB::iterator('SELECT w.wid AS id, ' . self::arrayToSqlCols($cols) . '
FROM wiki AS w
' . PlSqlJoin::formatJoins($joins, array()) . '
WHERE w.wid IN {?}
GROUP BY w.wid', array_keys($wikis));
while ($datas = $iter->next()) {
$wikis[$datas['id']]->fillFromArray($datas);
}
}
// Load last version
if ($bits & self::SELECT_VERSION) {
if (!isset($options[self::SELECT_VERSION])) {
$opts = array('versions' => array('last'));
} else {
$opts = $options[self::SELECT_VERSION];
}
$conds = array();
foreach ($wikis as $w) {
if ($w->versions == null) {
$w->versions = array();
}
$versions = array();
if (in_array('last', $opts['versions'])) {
$versions[] = $w->count();
}
foreach ($opts['versions'] as $version) {
if ($version != 'last') {
$versions[] = $version;
}
}
if (!empty($versions)) {
$conds[] = XDB::format('( wid = {?} AND version IN {?} )', $w->id(), $versions);
}
}
$iter = XDB::iterator('SELECT wid AS id, version, wrote, writer, content
FROM wiki_version
WHERE ' . implode(' OR ', $conds));
$writers = new Collection('User');
while ($datas = $iter->next()) {
$writer = $writers->addget($datas['writer']);
$wikis[$datas['id']]->versions[$datas['version']] = array('wrote' => $datas['wrote'], 'writer' => $writer, 'content' => $datas['content']);
}
if (isset($opts['options'])) {
$writers->select($opts['options']);
}
}
}
