/** * @param $options * @return array */ function b_wgteams_teams_show($options) { include_once XOOPS_ROOT_PATH . '/modules/wgteams/include/functions.php'; $GLOBALS['xoTheme']->addStylesheet(XOOPS_URL . '/modules/wgteams/assets/css/style.css'); $GLOBALS['xoopsTpl']->assign('wgteams_teams_upload_url', WGTEAMS_UPLOAD_URL . '/teams/images/'); $wgteams = WgteamsHelper::getInstance(); $teamsHandler = $wgteams->getHandler('teams'); $crit_teams = new CriteriaCompo(); $crit_teams->add(new Criteria('team_online', '1')); $crit_teams->setSort('team_weight'); $crit_teams->setOrder('ASC'); $teamsCount = $teamsHandler->getCount($crit_teams); $teamsAll = $teamsHandler->getAll($crit_teams); $block = array(); if ($teamsCount > 0) { $block = wgteamsGetTeamDetails($teamsAll, false); } return $block; }
/** * @param $options * @return string */ function b_wgteams_teamsmembers_edit($options) { include_once XOOPS_ROOT_PATH . '/modules/wgteams/class/teams.php'; $wgteams = WgteamsHelper::getInstance(); $teamsHandler = $wgteams->getHandler('teams'); $GLOBALS['xoopsTpl']->assign('wgteams_upload_url', WGTEAMS_UPLOAD_URL); $form = _MB_WGTEAMS_TEAM_TO_DISPLAY; $form .= "<input type='hidden' name='options[0]' value='" . $options[0] . "' />"; array_shift($options); $criteria = new CriteriaCompo(); $criteria->add(new Criteria('team_id', 0, '!=')); $criteria->add(new Criteria('team_online', 1)); $criteria->setSort('team_weight'); $criteria->setOrder('ASC'); $teamsAll = $teamsHandler->getAll($criteria); unset($criteria); $form .= "<select name='options[]' size='5'>"; foreach (array_keys($teamsAll) as $i) { $team_id = $teamsAll[$i]->getVar('team_id'); $form .= "<option value='" . $team_id . "' " . (array_search($team_id, $options) === false ? '' : "selected='selected'") . '>' . $teamsAll[$i]->getVar('team_name') . '</option>'; } $form .= '</select>'; return $form; }
$modversion['sqlfile']['mysql'] = 'sql/mysql.sql'; // Tables $modversion['tables'][1] = 'wgteams_teams'; $modversion['tables'][2] = 'wgteams_members'; $modversion['tables'][3] = 'wgteams_relations'; $modversion['tables'][4] = 'wgteams_infofields'; // ------------------- Search ------------------- // $modversion['hasSearch'] = 1; $modversion['search']['file'] = 'include/search.inc.php'; $modversion['search']['func'] = 'wgteams_search'; // ------------------- Submenu ------------------- // global $xoopsModule; if (is_object($xoopsModule) && $xoopsModule->getVar('dirname') == $modversion['dirname']) { global $xoopsModuleConfig, $xoopsUser; $s = 0; $wgteams = WgteamsHelper::getInstance(); $teamsHandler = $wgteams->getHandler('teams'); $crit_teams = new CriteriaCompo(); $crit_teams->add(new Criteria('team_online', '1')); $crit_teams->setSort('team_weight'); $crit_teams->setOrder('ASC'); $teamsAll = $teamsHandler->getAll($crit_teams); foreach (array_keys($teamsAll) as $i) { $s++; $modversion['sub'][$s]['name'] = $teamsAll[$i]->getVar('team_name'); $modversion['sub'][$s]['url'] = 'index.php?team_id=' . $teamsAll[$i]->getVar('team_id'); } } // ------------------- Blocks ------------------- // $modversion['blocks'][] = array('file' => 'b_teamsmembers.php', 'name' => _MI_WGTEAMS_TEAMSMEMBERS_BLOCK, 'description' => _MI_WGTEAMS_TEAMSMEMBERS_BLOCK_DESC, 'show_func' => 'b_wgteams_teamsmembers_show', 'edit_func' => 'b_wgteams_teamsmembers_edit', 'options' => 'showsingleteam|0', 'template' => 'wgteams_block_teamsmembers.tpl'); $modversion['blocks'][] = array('file' => 'b_teams.php', 'name' => _MI_WGTEAMS_TEAMS_BLOCK, 'description' => _MI_WGTEAMS_TEAMS_BLOCK_DESC, 'show_func' => 'b_wgteams_teams_show', 'edit_func' => '', 'options' => 'showlistofteams|0', 'template' => 'wgteams_block_teams.tpl');
/** * Constructor * * @param string $db */ public function __construct(&$db) { parent::__construct($db, 'wgteams_relations', 'wgteamsrelations', 'rel_id', 'rel_team_id'); $this->wgteams = WgteamsHelper::getInstance(); }
/** * Constructor * * @param string $db */ public function __construct(&$db) { parent::__construct($db, 'wgteams_teams', 'wgteamsteams', 'team_id', 'team_name'); $this->wgteams = WgteamsHelper::getInstance(); }
/** * Constructor * * @param string $db */ public function __construct(&$db) { parent::__construct($db, 'wgteams_members', 'wgteamsmembers', 'member_id', 'member_firstname'); $this->wgteams = WgteamsHelper::getInstance(); }
/** * @param $teamsAll * @return array */ function wgteamsGetTeamMemberDetails(&$teamsAll) { // Get All Teams global $xoopsTpl, $xoTheme; $wgteams = WgteamsHelper::getInstance(); $teamsHandler = $wgteams->getHandler('teams'); $membersHandler = $wgteams->getHandler('members'); $relationsHandler = $wgteams->getHandler('relations'); $infofieldsHandler = $wgteams->getHandler('infofields'); xoops_loadLanguage('main', WGTEAMS_DIRNAME); $team_image_url = WGTEAMS_UPLOAD_URL . '/teams/images/'; $member_image_url = WGTEAMS_UPLOAD_URL . '/members/images/'; foreach (array_keys($teamsAll) as $i) { $team_id = $teamsAll[$i]->getVar('team_id'); $team_name = $teamsAll[$i]->getVar('team_name'); $team_descr = $teamsAll[$i]->getVar('team_descr', 'n'); if ($teamsAll[$i]->getVar('team_image') === 'blank.gif') { $team_image = ''; } else { $team_image = $teamsAll[$i]->getVar('team_image'); } $team_nb_cols = $teamsAll[$i]->getVar('team_nb_cols'); $team_tablestyle = $teamsAll[$i]->getVar('team_tablestyle') === 'default' ? '' : $teamsAll[$i]->getVar('team_tablestyle'); $team_imagestyle = $teamsAll[$i]->getVar('team_imagestyle') === 'default' ? '' : $teamsAll[$i]->getVar('team_imagestyle'); $team_displaystyle = $teamsAll[$i]->getVar('team_displaystyle'); $member_labels = $wgteams->getConfig('wgteams_labels') == 1 ? true : false; $crit_rels = new CriteriaCompo(); $crit_rels->add(new Criteria('rel_team_id', $team_id)); $crit_rels->setSort('rel_weight'); $crit_rels->setOrder('ASC'); $relsCount = $relationsHandler->getCount($crit_rels); $relsAll = $relationsHandler->getAll($crit_rels); unset($relations); $relations = array(); $counter = 0; $nb_infos = 0; foreach (array_keys($relsAll) as $r) { $member_id = $relsAll[$r]->getVar('rel_member_id'); $member_obj = $membersHandler->get($member_id); $member_title = $member_obj->getVar('member_title'); if (!$member_title === '') { $nb_infos++; } $member_firstname = $member_obj->getVar('member_firstname'); $member_lastname = $member_obj->getVar('member_lastname'); $member_name = $member_firstname; $member_name .= ' ' . $member_lastname; $member_name = trim($member_name); if (!$member_name === '') { $nb_infos++; } $member_address = $member_obj->getVar('member_address', 'n'); if (!$member_address === '') { $nb_infos++; } $member_phone = $member_obj->getVar('member_phone', 'n'); if (!$member_phone === '') { $nb_infos++; } $member_email = $member_obj->getVar('member_email', 'n'); if (!$member_email === '') { $nb_infos++; } $member_image = $member_obj->getVar('member_image'); // reset info field $infofield_id = 0; $rel_info_1_name = ''; $rel_info_2_name = ''; $rel_info_3_name = ''; $rel_info_4_name = ''; $rel_info_5_name = ''; $infofield_id = $relsAll[$r]->getVar('rel_info_1_field'); if ($infofield_id > 0) { $infofield_obj = $infofieldsHandler->get($infofield_id); $rel_info_1_name = $infofield_obj->getVar('infofield_name', 'n'); $infofield_id = 0; unset($infofield_obj); $nb_infos++; } $rel_info_1 = $relsAll[$r]->getVar('rel_info_1', 'n'); $infofield_id = $relsAll[$r]->getVar('rel_info_2_field'); if ($infofield_id > 0) { $infofield_obj = $infofieldsHandler->get($infofield_id); $rel_info_2_name = $infofield_obj->getVar('infofield_name'); $infofield_id = 0; unset($infofield_obj); $nb_infos++; } $rel_info_2 = $relsAll[$r]->getVar('rel_info_2', 'n'); $infofield_id = $relsAll[$r]->getVar('rel_info_3_field'); if ($infofield_id > 0) { $infofield_obj = $infofieldsHandler->get($infofield_id); $rel_info_3_name = $infofield_obj->getVar('infofield_name'); $infofield_id = 0; unset($infofield_obj); $nb_infos++; } $rel_info_3 = $relsAll[$r]->getVar('rel_info_3', 'n'); $infofield_id = $relsAll[$r]->getVar('rel_info_4_field'); if ($infofield_id > 0) { $infofield_obj = $infofieldsHandler->get($infofield_id); $rel_info_4_name = $infofield_obj->getVar('infofield_name'); $infofield_id = 0; unset($infofield_obj); $nb_infos++; } $rel_info_4 = $relsAll[$r]->getVar('rel_info_4', 'n'); $infofield_id = $relsAll[$r]->getVar('rel_info_5_field'); if ($infofield_id > 0) { $infofield_obj = $infofieldsHandler->get($infofield_id); $rel_info_5_name = $infofield_obj->getVar('infofield_name'); $infofield_id = 0; unset($infofield_obj); $nb_infos++; } $rel_info_5 = $relsAll[$r]->getVar('rel_info_5', 'n'); $counter++; $relations[] = array('rel_counter' => $counter, 'member_id' => $member_id, 'member_title' => $member_title, 'member_firstname' => $member_firstname, 'member_lastname' => $member_lastname, 'member_name' => $member_name, 'member_address' => $member_address, 'member_phone' => $member_phone, 'member_email' => $member_email, 'member_image' => $member_image, 'member_image_url' => $member_image_url, 'info_1_name' => $rel_info_1_name, 'info_1' => $rel_info_1, 'info_2_name' => $rel_info_2_name, 'info_2' => $rel_info_2, 'info_3_name' => $rel_info_3_name, 'info_3' => $rel_info_3, 'info_4_name' => $rel_info_4_name, 'info_4' => $rel_info_4, 'info_5_name' => $rel_info_5_name, 'info_5' => $rel_info_5, 'rel_nb_cols' => $team_nb_cols, 'rel_tablestyle' => $team_tablestyle, 'rel_imagestyle' => $team_imagestyle, 'rel_displaystyle' => $team_displaystyle, 'rel_nb_infos' => $nb_infos, 'member_labels' => $member_labels); } $teams_list[] = array('team_id' => $team_id, 'team_name' => $team_name, 'team_descr' => $team_descr, 'team_image' => $team_image, 'team_image_url' => $team_image_url, 'members' => $relations); } return $teams_list; }
/** * Constructor * * @param string $db */ public function __construct($db) { parent::__construct($db, 'wgteams_infofields', 'wgteamsinfofields', 'infofield_id', 'infofield_name'); $this->wgteams = WgteamsHelper::getInstance(); }