function section_admin_ml()
{
global $tpl, $srcdir, $pdo;
include $srcdir . '/libs/GoogleApi.php';
$api = new GoogleApi();
$mdl = new Modele('sections');
$mdl->fetch($_REQUEST['section']);
$mdl->assignTemplate('section');
$lnk = new Modele('section_ml');
$lnk->find(array('sm_section' => $_REQUEST['section'], 'sm_ml' => $_REQUEST['ml']));
if (!$lnk->next()) {
modexec('syscore', 'forbidden');
}
$grp = $api->getGroupsDetails($lnk->sm_ml);
$tpl->assign('group', $grp);
$members = $api->getGroupMembers($grp->id);
$usql = $pdo->prepare('SELECT * FROM users WHERE user_email = ?');
foreach ($members->members as $member) {
$usql->bindValue(1, $member->email);
$usql->execute();
$user = $usql->fetch();
$tpl->append('members', array('isSave' => strpos($member->email, 'save_') === 0, 'user' => $user, 'obj' => $member));
}
display();
}
function ml_view()
{
global $tpl, $pdo;
$api = new GoogleApi();
$details = $api->getGroupsDetails($_GET['ml']);
$tpl->assign('group', $details);
$members = $api->getGroupMembers($_GET['ml']);
$usql = $pdo->prepare('SELECT * FROM users WHERE user_email = ?');
foreach ($members->members as $member) {
$usql->bindValue(1, $member->email);
$usql->execute();
$user = $usql->fetch();
$tpl->append('members', array('obj' => $member, 'user' => $user, 'isSave' => strpos($member->email, 'save_') === 0));
}
$mls = new Modele('section_ml');
$mls->find(array('sm_ml' => $details->id));
$ids = array();
while ($mls->next()) {
$tpl->append('mls', new Modele($mls));
$ids[] = $mls->raw_sm_section;
}
$sec = new Modele('sections');
$sec->find();
while ($sec->next()) {
if (!in_array($sec->section_id, $ids)) {
$tpl->append('sections', new Modele($sec));
}
}
display();
}
