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(); }