function getList(&$params) { $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $userId = (int) $user->get('id'); $Itemid =JomWallGroupsHelper::getComItemId(); $count = (int) $params->get('count', 5); $ordering = trim( $params->get('ordering1') ); $topgroup=$params->get('topgroup', ''); $groupModel = new AwdwallModelGroup(); if(!empty($user->id)) { $uid=$user->id; $sql="Select * from #__awd_groups "; if($topgroup) { $sql=$sql." where id!=".$topgroup." "; } if($ordering==0) { $order=" Order by id desc"; } else { $order=" Order by rand()"; } $sql.=$order; $db->setQuery($sql); $grows = $db->loadObjectList(); $ids=array(); foreach($grows as $row) { if($row->privacy==1) { $ids[]=$row->id; } else { $sql="select group_id from #__awd_groups_members where user_id=".$uid." and status=1 and group_id=".$row->id; $db->setQuery($sql); $gid = $db->loadResult(); if(!empty($gid)) { $ids[]=$row->id; } } } if(count($ids>0)) { $gids=implode(",",$ids); if($ordering==0) { $order=" Order by id desc"; } else { $order=" Order by rand()"; } $sql="Select * from #__awd_groups where id in (".$gids.") ".$order; $db->setQuery($sql, 0, $count); $rows = $db->loadObjectList(); } } else { $sql="Select * from #__awd_groups where privacy=1 "; if($topgroup) { $sql=$sql." and id!=".$topgroup." "; } if($ordering==0) { $order=" Order by id desc"; } else { $order=" Order by rand()"; } $sql.=$order; $db->setQuery($sql, 0, $count); $rows = $db->loadObjectList(); } $i = 0; $lists = array(); if($rows) { foreach ( $rows as $row ) { $nofPosts = $groupModel->countPostGrp($row->id); $nofMembers = $groupModel->countMemGrp($row->id) + 1; $lists[$i]->thumb = AwdwallHelperUser::getBigGrpImg133($row->image,$row->id); $lists[$i]->title = $row->title; $lists[$i]->id = $row->id; $lists[$i]->descr= $row->description; $lists[$i]->nofPosts= $nofPosts; $lists[$i]->nofMembers= $nofMembers; $lists[$i]->created_date= $row->created_date; $lists[$i]->link= 'index.php?option=com_awdwall&task=viewgroup&groupid='.$row->id.'&Itemid='.$Itemid; $lists[$i]->memberlink= 'index.php?option=com_awdwall&task=grpmembers&groupid='.$row->id.'&Itemid='.$Itemid; $i++; } } return $lists; }
?> <link rel="stylesheet" href="<?php echo JURI::base();?>modules/mod_jomwallgroups/css/style.css" type="text/css" /> <div id="awdWallGroup"> <?php if($topgroup) { $sql="select * from #__awd_groups where id=".$topgroup." limit 1"; $db->setQuery($sql); $topgrouprows = $db->loadObjectList(); $grouplink= 'index.php?option=com_awdwall&task=viewgroup&groupid='.$topgroup.'&Itemid='.$Itemid; $groupmemberlink= 'index.php?option=com_awdwall&task=grpmembers&groupid='.$topgroup.'&Itemid='.$Itemid; $grpthumb=AwdwallHelperUser::getBigGrpImg133($topgrouprows[0]->image,$topgroup); $groupModel = new AwdwallModelGroup(); $nofPosts = $groupModel->countPostGrp($topgroup); $nofMembers = $groupModel->countMemGrp($topgroup) + 1; ?> <div id="parentGroupDiv" class="parentgrpdiv"> <div id="jomwallgrpthumb" ><a href="<?php echo JRoute::_($grouplink,false); ?>" ><div style="background-image:url('<?php echo $grpthumb; ?>'); background-position:center center; " class="featuregrpthumb"></div></a></div> <div id="jomwallgrpcontent" ><h3 class="jomwallgrphtitle"><a href="<?php echo JRoute::_($grouplink,false); ?>" > <?php echo $topgrouprows[0]->title; ?></a></h3> <div class="jomwallgrpActions clearfix"> <div style="float:left; "> <i class="jomwallmembericon"></i> <a href="<?php echo JRoute::_($groupmemberlink); ?>"><?php echo $nofMembers . ' ' . JText::_('GROUP MEMBER');?></a> </div> <div style="float:left;margin-left:5px;"> <i class="jomwallwallposticon"></i><a href="<?php echo JRoute::_($grouplink,false); ?>"> <?php echo $nofPosts . ' ' .JText::_('POSTS');?> </a></div> </div> <div id="jomwallgrpdescr" class="clearfix"><?php if(str_word_count($topgrouprows[0]->description)>10){ echo substr($topgrouprows[0]->description,0,50).'...'; } else { echo $topgrouprows[0]->description; } ?></div> <span class="grpdate"><?php echo JText::_('Created');?> : <strong><?php echo AwdwallHelperUser::getDisplayTime($topgrouprows[0]->created_date);?></strong></span> </div> </div> <?php }