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