<?php
/**
* @copyright (C) 2013 iJoomla, Inc. - All rights reserved.
* @license GNU General Public License, version 2 (http://www.gnu.org/licenses/gpl-2.0.html)
* @author iJoomla.com <webmaster@ijoomla.com>
* @url https://www.jomsocial.com/license-agreement
* The PHP code portions are distributed under the GPL license. If not otherwise stated, all images, manuals, cascading style sheets, and included JavaScript *are NOT GPL, and are released under the IJOOMLA Proprietary Use License v1.0
* More info at https://www.jomsocial.com/license-agreement
*/

use Joomla\CMS\Factory;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Router\Route;
use Joomla\CMS\Session\Session;
use Joomla\CMS\Table\Table;
use Joomla\Filesystem\File;

// Disallow direct access to this file
defined('_JEXEC') or die('Restricted access');

jimport( 'joomla.application.component.controller' );

/**
 * JomSocial Component Controller
 */
class CommunityControllerGroups extends CommunityController
{
    public function __construct()
    {
        parent::__construct();

        $this->registerTask( 'publish' , 'savePublish' );
        $this->registerTask( 'unpublish' , 'savePublish' );
    }

    public function display( $cachable = false, $urlparams = array() )
    {
        $jinput = Factory::getApplication()->input;

        $viewName   = $jinput->get( 'view' , 'community' );

        // Set the default layout and view name
        $layout     = $jinput->get( 'layout' , 'default' );

        // Get the document object
        $document   = Factory::getDocument();

        // Get the view type
        $viewType   = $document->getType();

        // Get the view
        $view       = $this->getView( $viewName , $viewType );

        $model      = $this->getModel( $viewName ,'CommunityAdminModel' );

        if( $model )
        {
            $view->setModel( $model , $viewName );
        }

        // Set the layout
        $view->setLayout( $layout );

        // Display the view
        $view->display();
    }

    public function ajaxTogglePublish( $id , $type, $viewName = false )
    {
        // Send email notification to owner when a group is published.
        $config = CFactory::getConfig();
        $group  = Table::getInstance( 'Group' , 'CTable' );
        $group->load( $id );

        if( $type == 'published' && $group->published == 0 && $config->get( 'moderategroupcreation' ) )
        {
           $this->notificationApproval($group);
        }

        return parent::ajaxTogglePublish( $id , $type , 'groups' );
    }

    public function ajaxChangeGroupOwner( $groupId )
    {
        $response   = new JAXResponse();

        $group      = Table::getInstance( 'Group' , 'CTable' );
        $group->load( $groupId );
        $model          = CFactory::getModel( 'Groups' );

        $group->owner   = Factory::getUser( $group->ownerid );
        $rows           = $model->getMembers( $group->id , NULL , true , false , true );
        ob_start();
?>
<div class="alert alert-info">
    <?php echo Text::_('COM_COMMUNITY_GROUPS_CHANGE_OWNERSHIP');?>
</div>
<form name="editgroup" method="post" action="">
<table width="100%">
    <tbody>
        <tr>
            <td class="key"><?php echo Text::_('COM_COMMUNITY_GROUPS_OWNER');?></td>
            <td align="left">
                <?php echo $group->owner->name; ?>
            </td>
        </tr>
        <tr>
            <td class="key"><span class="js-tooltip" title="<?php echo Text::_('COM_COMMUNITY_GROUPS_NEW_OWNER_TIPS');?>"><?php echo Text::_('COM_COMMUNITY_GROUPS_NEW_OWNER');?></span></td>
            <td align="left">
                <?php
                if($rows)
                {
                ?>
                <select name="ownerid">
                    <?php
                        foreach( $rows as $row )
                        {
                            $user   = CFactory::getUser( $row->id );
                    ?>
                        <option value="<?php echo $user->id;?>"><?php echo Text::sprintf('%1$s [ %2$s ]' , $user->name , $user->email );?></option>
                    <?php
                        }
                    ?>
                </select>
                <?php
                }
                else
                {
                ?>
                <div><?php echo Text::_('COM_COMMUNITY_GROUPS_CHANGE_OWNER_WARN');?></div>
                <?php
                }
                ?>
            </td>
        </tr>
    </tbody>
</table>
<input name="id" value="<?php echo $group->id;?>" type="hidden" />
<input type="hidden" name="option" value="com_community" />
<input type="hidden" name="task" value="updateGroupOwner" />
<input type="hidden" name="view" value="groups" />
</form>
<?php
        $contents   = ob_get_contents();
        ob_end_clean();

        $response->addAssign( 'cWindowContent' , 'innerHTML' , $contents );

        $action = '<input type="button" class="btn btn-small btn-primary pull-right" onclick="azcommunity.saveGroupOwner();" name="' . Text::_('COM_COMMUNITY_SAVE') . '" value="' . Text::_('COM_COMMUNITY_SAVE') . '" />';
        $action .= '<input type="button" class="btn btn-small pull-left" onclick="cWindowHide();" name="' . Text::_('COM_COMMUNITY_CLOSE') . '" value="' . Text::_('COM_COMMUNITY_CLOSE') . '" />';
        $response->addScriptCall( 'cWindowActions' , $action );

        return $response->sendResponse();
    }

    public function ajaxAssignGroup( $memberId )
    {
        require_once( JPATH_ROOT . '/components/com_community/libraries/core.php' );
        $response   = new JAXResponse();

        $model      = $this->getModel( 'groups', 'CommunityAdminModel' );
        $groups     = $model->getAllGroups();
        $user       = CFactory::getUser( $memberId );
        ob_start();
?>
<form name="assignGroup" action="" method="post" id="assignGroup">
<div class="alert alert-info">
    <?php echo Text::sprintf('COM_COMMUNITY_GROUP_ASSIGN_MEMBER', $user->getDisplayName() );?>
</div>
<table width="100%">
    <tbody>
        <tr>
            <td class="key"><span class="js-tooltip" title="<?php echo Text::_('COM_COMMUNITY_ASSIGN_GROUPS_TIPS');?>"><?php echo Text::_('COM_COMMUNITY_GROUPS');?></span></td>
            <td>
                <select name="groupid[]" id="groupid" multiple="true">
                    <!--option value="-1" selected="selected"><?php echo Text::_('COM_COMMUNITY_GROUPS_SELECT');?></option-->
                <?php
                    foreach($groups as $row )
                    {
                        $selected = $model->isMember($user->id , $row->id)?'selected="true"':'';
                ?>
                    <option value="<?php echo $row->id;?>" <?php echo $selected?> ><?php echo $row->name;?></option>
                <?php

                    }
                ?>
                </select>
            </td>
        </tr>
    </tbody>
</table>
<div id="group-error-message" style="color: red;font-weight:700;"></div>
<input type="hidden" name="memberid" value="<?php echo $user->id;?>" />
<input type="hidden" name="option" value="com_community" />
<input type="hidden" name="task" value="addmember" />
<input type="hidden" name="view" value="groups" />
<?php
        $contents   = ob_get_contents();
        ob_end_clean();

        $response->addAssign( 'cWindowContent' , 'innerHTML' , $contents );

        $action = '<input type="button" class="btn btn-small btn-primary pull-right" onclick="azcommunity.saveAssignGroup();" name="' . Text::_('COM_COMMUNITY_SAVE') . '" value="' . Text::_('COM_COMMUNITY_SAVE') . '" />';
        $action .= '&nbsp;<input type="button" class="btn btn-small pull-left" onclick="cWindowHide();" name="' . Text::_('COM_COMMUNITY_CLOSE') . '" value="' . Text::_('COM_COMMUNITY_CLOSE') . '" />';
        $response->addScriptCall( 'cWindowActions' , $action );
        $response->addScriptCall( 'joms.jQuery("#cwin_logo").html("' . Text::_('COM_COMMUNITY_GROUPS_ASSIGN_USER') . '");');
        return $response->sendResponse();
    }

    public function ajaxEditGroup( $groupId )
    {
        $response   = new JAXResponse();
        $model      = $this->getModel( 'groupcategories' );
        $categories = $model->getCategories();

        $group      = Table::getInstance( 'Group' , 'CTable' );
        $group->load( $groupId );

        $requireApproval    = ($group->approvals) ? ' checked="true"' : '';
        $noApproval         = (!$group->approvals) ? '' : ' checked="true"';

        // Escape the output
        $group->name    = CStringHelper::escape($group->name);
        $group->description = CStringHelper::escape($group->description);

        $params = $group->getParams();
        $config = CFactory::getConfig();

        ob_start();
?>
<form name="editgroup" action="" method="post" id="editgroup">
<div class="alert alert-info">
    <?php echo Text::_('COM_COMMUNITY_GROUPS_EDIT_GROUP');?>
</div>
<table cellspacing="0" class="admintable" border="0" width="100%">
    <tbody>
        <tr>
            <td class="key" width="100"><?php echo Text::_('COM_COMMUNITY_GROUPS_TITLE'); ?></td>
            <td>
                <input type="text" name="name" value="<?php echo $group->name; ?>" style="width: 200px;" />
            </td>
        </tr>
        <tr>
            <td class="key"><?php echo Text::_('COM_COMMUNITY_AVATAR');?></td>
            <td>
                <img width="90" src="<?php echo $group->getThumbAvatar();?>" style="border: 1px solid #eee;"/>
            </td>
        </tr>
        <tr>
            <td class="key"><?php echo Text::_('COM_COMMUNITY_PUBLISH_STATUS');?></td>
            <td>
                <?php echo CHTMLInput::checkbox('published' ,'ace-switch ace-switch-5', null , $group->get('published') ); ?>
            </td>
        </tr>
        <tr>
            <td class="key"><?php echo Text::_('COM_COMMUNITY_GROUP_TYPE');?></td>
            <td>
                <select style="visibility:visible;" name='approvals'>
                    <option value='0' <?php echo ($group->approvals == COMMUNITY_PUBLIC_GROUP ) ? ' selected="selected"' : '';?> ><?php echo Text::_('COM_COMMUNITY_PUBLIC');?></option>
                    <option value='1' <?php echo ($group->approvals == COMMUNITY_PRIVATE_GROUP ) ? ' selected="selected"' : '';?> ><?php echo Text::_('COM_COMMUNITY_GROUP_PRIVATE');?></option>
                </select>
            </td>
        </tr>
        <tr>
            <td class="key"><?php echo Text::_('COM_COMMUNITY_CATEGORY');?></td>
            <td>
                <select name="categoryid">
                <?php

                    for( $i = 0; $i < count( $categories ); $i++ )
                    {
                        $selected   = ($group->categoryid == $categories[$i]->id ) ? ' selected="selected"' : '';
                ?>
                        <option value="<?php echo $categories[$i]->id;?>"<?php echo $selected;?>><?php echo $categories[$i]->name;?></option>
                <?php
                    }
                ?>
                </select>
            </td>
        </tr>
        <tr>
            <td class="key"><?php echo Text::_('COM_COMMUNITY_DESCRIPTION');?></td>
            <td>
                <textarea name="description" style="width: 250px;" rows="5"
                    data-wysiwyg="trumbowyg" data-btns="viewHTML,|,bold,italic,underline,|,unorderedList,orderedList,|,link,image"><?php
                        echo $group->description;?></textarea>
            </td>
        </tr>
    <!--    <tr>
        <td class="key"><?php echo Text::_('COM_COMMUNITY_GROUPS_DISCUSS_ORDER'); ?></td>
        <td class="paramlist_value">
            <select style="visibility:visible;" name='discussordering'>
                <option value='0' <?php echo ($params->get('discussordering') == 0 ) ? ' selected="selected"' : '';?> ><?php echo Text::_('COM_COMMUNITY_GROUPS_DISCUSS_ORDER_LAST_REPLIED');?></option>
                <option value='1' <?php echo ($params->get('discussordering') == 1 ) ? ' selected="selected"' : '';?> ><?php echo Text::_('COM_COMMUNITY_GROUPS_DISCUSS_ORDER_CREATION_DATE');?></option>
            </select>
        </td>
    </tr>-->

    <?php if ($config->get('enablephotos') && $config->get('groupphotos')) { ?>
    <?php $photoAllowed = $params->get('photopermission', 1) >= 1; ?>
    <tr><td colspan="2">&nbsp;</td></tr>
    <tr>
        <td class="key">
            <span>
                <?php echo Text::_('COM_COMMUNITY_PHOTOS'); ?>
            </span>
        </td>
        <td>
            <label>
                <input type="checkbox" name="photopermission-admin" class="joms-js--group-photo-flag" style="position:relative;opacity:1" value="1"
                    <?php echo $photoAllowed ? 'checked' : '' ?>> <?php echo Text::_('COM_COMMUNITY_GROUPS_PHOTO_UPLOAD_ALOW_ADMIN'); ?>
            </label>
            <div class="joms-js--group-photo-setting" style="display:none">
                <label>
                    <input type="checkbox" name="photopermission-member" class="joms-js--group-photo-setting" style="position:relative;opacity:1" value="1"
                        <?php echo $photoAllowed ? '' : ' disabled="disabled"' ?>
                        <?php echo $photoAllowed && $params->get('photopermission') > 1 ? 'checked' : '' ?>
                    > <?php echo Text::_('COM_COMMUNITY_GROUPS_PHOTO_UPLOAD_ALLOW_MEMBER'); ?>
                </label>
                <select name="grouprecentphotos">
                    <?php for ($i = 2; $i <= 10; $i += 2) { ?>
                    <option value="<?php echo $i; ?>"
                        <?php echo ($params->get('grouprecentphotos') == $i || ($i == 6 && $params->get('grouprecentphotos')==0)) ? 'selected': ''; ?>
                        ><?php echo $i; ?></option>
                    <?php } ?>
                </select>
            </div>
        </td>
    </tr>
    <?php } ?>

    <?php if ($config->get('enablevideos') && $config->get('groupvideos')) { ?>
    <?php $videoAllowed = $params->get('videopermission', 1) >= 1; ?>
    <tr><td colspan="2">&nbsp;</td></tr>
    <tr>
        <td class="key">
            <span>
                <?php echo Text::_('COM_COMMUNITY_VIDEOS'); ?>
            </span>
        </td>
        <td>
            <label>
                <input type="checkbox" name="videopermission-admin" class="joms-js--group-video-flag" style="position:relative;opacity:1" value="1"
                    <?php echo $videoAllowed ? 'checked' : '' ?>> <?php echo Text::_('COM_COMMUNITY_GROUPS_VIDEO_UPLOAD_ALLOW_ADMIN'); ?>
            </label>
            <div class="joms-js--group-video-setting" style="display:none">
                <label>
                    <input type="checkbox" name="videopermission-member" class="joms-js--group-video-setting" style="position:relative;opacity:1" value="1"
                        <?php echo $videoAllowed ? '' : ' disabled="disabled"' ?>
                        <?php echo $videoAllowed && $params->get('videopermission') > 1 ? 'checked' : '' ?>
                    > <?php echo Text::_('COM_COMMUNITY_GROUPS_VIDEO_UPLOAD_ALLOW_MEMBER'); ?>
                </label>
                <select name="grouprecentvideos">
                    <?php for ($i = 2; $i <= 10; $i += 2) { ?>
                    <option value="<?php echo $i; ?>"
                        <?php echo ($params->get('grouprecentvideos') == $i || ($i == 6 && $params->get('grouprecentvideos')==0)) ? 'selected': ''; ?>
                        ><?php echo $i; ?></option>
                    <?php } ?>
                </select>
            </div>
        </td>
    </tr>
    <?php } ?>

    <?php if ($config->get('enableevents') && $config->get('group_events')) { ?>
    <?php $eventAllowed = $params->get('eventpermission', 1) >= 1; ?>
    <tr><td colspan="2">&nbsp;</td></tr>
    <tr>
        <td class="key">
            <span>
                <?php echo Text::_('COM_COMMUNITY_EVENTS'); ?>
            </span>
        </td>
        <td>
            <label>
                <input type="checkbox" name="eventpermission-admin" class="joms-js--group-event-flag" style="position:relative;opacity:1" value="1"
                    <?php echo $eventAllowed ? 'checked' : '' ?>> <?php echo Text::_('COM_COMMUNITY_GROUP_EVENTS_ADMIN_CREATION'); ?>
            </label>
            <div class="joms-js--group-event-setting" style="display:none">
                <label>
                    <input type="checkbox" name="eventpermission-member" class="joms-js--group-event-setting" style="position:relative;opacity:1" value="1"
                        <?php echo $eventAllowed ? '' : ' disabled="disabled"' ?>
                        <?php echo $eventAllowed && $params->get('eventpermission') > 1 ? 'checked' : '' ?>
                    > <?php echo Text::_('COM_COMMUNITY_GROUP_EVENTS_MEMBERS_CREATION'); ?>
                </label>
                <select name="grouprecentevents">
                    <?php for ($i = 2; $i <= 10; $i += 2) { ?>
                    <option value="<?php echo $i; ?>"
                        <?php echo ($params->get('grouprecentevents') == $i || ($i == 6 && $params->get('grouprecentevents')==0)) ? 'selected': ''; ?>
                        ><?php echo $i; ?></option>
                    <?php } ?>
                </select>
            </div>
        </td>
    </tr>
    <?php } ?>

    <tr><td colspan="2">&nbsp;</td></tr>

    <?php if ($config->get('file_sharing_group')) { ?>
    <?php $filesharingAllowed = $params->get('filesharingpermission') >= 1; ?>
    <tr><td colspan="2">&nbsp;</td></tr>
    <tr>
        <td class="key">
            <span>
                <?php echo Text::_('COM_COMMUNITY_GROUPS_RECENT_FILESHARING'); ?>
            </span>
        </td>
        <td>
            <label>
                <input type="checkbox" name="filesharingpermission-admin" class="joms-js--group-filesharing-flag" style="position:relative;opacity:1" value="1"
                    <?php echo $filesharingAllowed ? 'checked' : '' ?>> <?php echo Text::_('COM_COMMUNITY_GROUPS_FILESHARING_ALOW_ADMIN'); ?>
            </label>
            <div class="joms-js--group-filesharing-setting" style="display:none">
                <label>
                    <input type="checkbox" name="filesharingpermission-member" class="joms-js--group-filesharing-setting" style="position:relative;opacity:1" value="1"
                        <?php echo $filesharingAllowed ? '' : ' disabled="disabled"' ?>
                        <?php echo $filesharingAllowed && $params->get('filesharingpermission') > 1 ? 'checked' : '' ?>
                    > <?php echo Text::_('COM_COMMUNITY_GROUPS_FILESHARING_ALLOW_MEMBER'); ?>
                </label>
            </div>
        </td>
    </tr>
    <?php } ?>

    <tr><td colspan="2">&nbsp;</td></tr>

    <?php if ($config->get('groupdiscussfilesharing') && $config->get('creatediscussion')) { ?>
    <tr>
        <td class="key"><?php echo Text::_('COM_COMMUNITY_DISCUSSION'); ?></td>
        <td>
            <label>
                <input type="checkbox" name="groupdiscussionfilesharing" style="position:relative;opacity:1" value="1"
                    <?php echo $params->get('groupdiscussionfilesharing') >= 1 ? 'checked' : '' ?>
                > <?php echo Text::_('COM_COMMUNITY_GROUPS_DISCUSSION_ENABLE_FILE_SHARING'); ?>
                <input type="hidden" name="discussordering" value="0" />
            </label>
        </td>
    </tr>
    <?php } ?>
    <?php if ($config->get('createannouncement')) { ?>
    <tr>
        <td class="key"><?php echo Text::_('COM_COMMUNITY_ANNOUNCEMENT'); ?></td>
        <td>
            <label>
                <input type="checkbox" name="groupannouncementfilesharing" style="position:relative;opacity:1" value="1"
                    <?php echo $params->get('groupannouncementfilesharing') >= 1 ? 'checked' : '' ?>
                > <?php echo Text::_('COM_COMMUNITY_GROUPS_ANNOUNCEMENT_ENABLE_FILE_SHARING'); ?>
            </label>
        </td>
    </tr>
    <?php } ?>
    <tr>
        <td class="key"><?php echo Text::_('COM_COMMUNITY_GROUPS_NEW_MEMBER_NOTIFICATION'); ?></td>
        <td class="paramlist_value">
            <div class="space-12"></div>
            <select style="visibility:visible;" name='newmembernotification'>
                <option value='1' <?php echo ($params->get('newmembernotification', '1') == true ) ? ' selected="selected"' : '';?> ><?php echo Text::_('COM_COMMUNITY_ENABLE');?></option>
                <option value='0' <?php echo ($params->get('newmembernotification', '1') == false ) ? ' selected="selected"' : '';?>><?php echo Text::_('COM_COMMUNITY_DISABLE');?></option>
            </select>
            <div class="space-12"></div>
        </td>
    </tr>
    <tr>
        <td class="key"><?php echo Text::_('COM_COMMUNITY_GROUPS_JOIN_REQUEST_NOTIFICATION'); ?></td>
        <td class="paramlist_value">
            <div class="space-12"></div>
            <select style="visibility:visible;" name='joinrequestnotification'>
                <option value='1' <?php echo ($params->get('joinrequestnotification', '1') == true ) ? ' selected="selected"' : '';?> ><?php echo Text::_('COM_COMMUNITY_ENABLE');?></option>
                <option value='0' <?php echo ($params->get('joinrequestnotification', '1') == false ) ? ' selected="selected"' : '';?>><?php echo Text::_('COM_COMMUNITY_DISABLE');?></option>
            </select>
            <div class="space-12"></div>
        </td>
    </tr>
    <tr>
        <td class="key"><?php echo Text::_('COM_COMMUNITY_GROUPS_WALL_NOTIFICATION'); ?></td>
        <td class="paramlist_value">
            <div class="space-12"></div>
            <select style="visibility:visible;" name='wallnotification'>
                <option value='1' <?php echo ($params->get('wallnotification', '1') == true ) ? ' selected="selected"' : '';?> ><?php echo Text::_('COM_COMMUNITY_ENABLE');?></option>
                <option value='0' <?php echo ($params->get('wallnotification', '1') == false ) ? ' selected="selected"' : '';?> ><?php echo Text::_('COM_COMMUNITY_DISABLE');?></option>
            </select>
            <div class="space-12"></div>
        </td>
    </tr>
    </tbody>
</table>
<input type="hidden" name="id" value="<?php echo $group->id;?>" />
<input type="hidden" name="option" value="com_community" />
<input type="hidden" name="task" value="savegroup" />
<input type="hidden" name="view" value="groups" />
<?php
        $contents   = ob_get_contents();
        ob_end_clean();

        $response->addAssign( 'cWindowContent' , 'innerHTML' , $contents );

        $action = '<input type="button" class="btn btn-small btn-primary pull-right" onclick="azcommunity.saveGroup();" name="' . Text::_('COM_COMMUNITY_SAVE') . '" value="' . Text::_('COM_COMMUNITY_SAVE') . '" />';
        $action .= '&nbsp;<input type="button" class="btn btn-small pull-left" onclick="cWindowHide();" name="' . Text::_('COM_COMMUNITY_CLOSE') . '" value="' . Text::_('COM_COMMUNITY_CLOSE') . '" />';
        $response->addScriptCall( 'cWindowActions' , $action );
        $response->addScriptCall( 'joms.util.wysiwyg.start' );

        return $response->sendResponse();
    }

    public function importGroupsForm(){
        $response   = new JAXResponse();

        //lets display the upload form here
        ob_start();
        ?>

        <div class="alert alert-info">
            <p><?php echo Text::_('COM_COMMUNITY_GROUPS_IMPORT_MESSAGE'); ?></p>
            <a href="http://documentation.jomsocial.com/wiki/Import_Groups_From_CSV" class="btn btn-small btn-info" target="_blank" ><?php echo Text::_('COM_COMMUNITY_DOC') ?></a>
        </div>

        <form enctype="multipart/form-data" action="<?php echo CRoute::_('index.php?option=com_community&view=groups&task=importGroups'); ?>" method="post" onsubmit="return joms_js_import_users(this);">
            <table>
                <tr>
                    <td width="110"></td>
                    <td width="400"><input name="csv" type="file" /></td>
                </tr>
                <tr>
                    <td></td>
                    <td><input class="btn btn-small btn-primary" type="submit" value="<?php echo Text::_('COM_COMMUNITY_CONFIGURATION_IMPORT_GROUPS'); ?>" /></td>
                </tr>
            </table>
        </form>
        <?php
        $html = ob_get_contents();
        ob_end_clean();

        $response->addAssign( 'cWindowContent' , 'innerHTML' , $html );
        return $response->sendResponse();
    }

    public function importGroups(){

        $mainframe  = Factory::getApplication();
        $jinput     = $mainframe->input;

        $csv = $jinput->files->get('csv');

        $groups = array();
        $i = 0;

        ini_set('auto_detect_line_endings',true); // we need to detect the new line break automatically

        $handle = fopen($csv['tmp_name'],"r");
        if($handle){
            while(!feof($handle)){
                $results = fgetcsv($handle);


                if(!$results[0]){
                    //this can be due to empty line
                    continue;
                }elseif(!$results[0] || !$results[3] || count($results) > 5){
                    //we must check if every results exists, else, return the error
                    //redirect and display error
                    fclose($handle);
                    $url        = Route::_('index.php?option=com_community&view=groups' , false );
                    $message    = Text::_('COM_COMMUNITY_GROUPS_CSV_FILE_ERROR');
                    return $this->setRedirect( $url , $message ,'error');
                }

                $groups[$i] = $results;
                $i++;
            }
        }else{
            //redirect and display error
            $url        = Route::_('index.php?option=com_community&view=groups' , false );
            $message    = Text::_('COM_COMMUNITY_GROUPS_CSV_FILE_ERROR');
            return $this->setRedirect( $url , $message ,'error');
        }
        fclose($handle);

        $totalGroups = count($groups);

        if(!$totalGroups){
            //if it's empty
            //redirect and display error
            $url        = Route::_('index.php?option=com_community&view=groups' , false );
            $message    = Text::_('COM_COMMUNITY_GROUPS_CSV_FILE_ERROR');
            return $this->setRedirect( $url , $message ,'error');
        }

        $duplicates = 0;
        $db = Factory::getDbo();

        //lets try to create the users
        foreach($groups as $group){
            //check if the groupname already exists in the system
            $groupName = utf8_encode(trim($group[0]));
            $categoryId = $group[4];
            $description = utf8_encode($group[3]);
            $summary = utf8_encode($group[2]);
            $unlisted = ($group[1]) ? 1 : 0 ;

            //category must be numeric
            if(!is_numeric($categoryId)){
                continue;
            }

            $query = 'SELECT id FROM '.$db->quoteName('#__community_groups').' WHERE name='.$db->quote($groupName);
            $db->setQuery($query);
            $result = $db->loadResult();
            
            if($result){
                //if the email already exists, we will skip this user
                $duplicates++;
                continue;
            }

            $date = JDate::getInstance();

            //lets add in the new group here
            $groupTable = Table::getInstance( 'Groups' , 'CommunityTable' );
            $groupTable->name = $groupName;
            $groupTable->published = 1;
            $groupTable->ownerid = CFactory::getUser()->id;
            $groupTable->categoryid = $categoryId;
            $groupTable->description = $description;
            $groupTable->approvals = $unlisted;
            $groupTable->membercount = 1;
            $groupTable->params = '{"discussordering":0,"photopermission":2,"videopermission":2,"filesharingpermission":2,"eventpermission":2,"grouprecentphotos":6,"grouprecentvideos":6,"grouprecentevents":6,"newmembernotification":1,"joinrequestnotification":1,"wallnotification":1,"groupdiscussionfilesharing":1,"groupannouncementfilesharing":1,"stream":1}';
            $groupTable->summary = $summary;
            $groupTable->unlisted = $unlisted;
            $groupTable->created =  $date->toSql(true);
            $groupTable->store();

            $query = "INSERT INTO ".$db->quoteName('#__community_groups_members')." (groupid, memberid, approved, permissions) VALUES(".$db->quote($groupTable->id).",".$db->quote(CFactory::getUser()->id).",'1','1')";
            $db->setQuery($query);
            $db->execute();
        }

        $url        = Route::_('index.php?option=com_community&view=groups' , false );
        $message    = Text::sprintf('COM_COMMUNITY_GROUPS_IMPORT_USER_SUCCESS',$totalGroups-$duplicates, $duplicates);
        return $this->setRedirect( $url , $message ,'message');
    }

    public function updateGroupOwner()
    {
        $mainframe  = Factory::getApplication();
        $jinput     = $mainframe->input;

        $group  = Table::getInstance( 'Groups' , 'CommunityTable' );

        $groupId    = $jinput->post->get('id', '', 'INT');
        $group->load( $groupId );

        $oldOwner   = $group->ownerid;
        $newOwner   = $jinput->get('ownerid', NULL, 'INT');

        // Add member if member does not exist.
        if( !$group->isMember( $newOwner , $group->id ) )
        {
            $data   = new stdClass();
            $data->groupid          = $group->id;
            $data->memberid     = $newOwner;
            $data->approved     = 1;
            $data->permissions  = 1;

            // Add user to group members table
            $group->addMember( $data );

            // Add the count.
            $group->addMembersCount( $group->id );

            $message    = Text::_('COM_COMMUNITY_GROUP_SAVED');
        }
        else
        {
            // If member already exists, update their permission
            $member = Table::getInstance( 'GroupMembers' , 'CTable' );
            $keys = array('groupId'=>$group->id, 'memberId'=>$newOwner);
            $member->load( $keys );
            $member->permissions    = '1';

            $member->store();
        }

        $group->ownerid = $newOwner;
        $group->store();

        $message    = Text::_('COM_COMMUNITY_GROUP_OWNER_SAVED');

        $mainframe  = Factory::getApplication();
        return $this->setRedirect( 'index.php?option=com_community&view=groups' , $message ,'message');
    }

    /**
     *  Adds a user to an existing group
     **/
    public function addMember()
    {
        require_once(JPATH_ROOT . '/components/com_community/libraries/core.php');

        $app = Factory::getApplication();
        $jinput = $app->input;

        $groupId = $jinput->request->get('groupid', array(), 'array');
        $memberId = $jinput->request->get('memberid', '', 'INT');
        $user = CFactory::getUser($memberId);

        if (!$memberId || !$user->id || $groupId == '-1') {
            $message = Text::_('COM_COMMUNITY_INVALID_ID');
            return $this->setRedirect('index.php?option=com_community&view=users', $message, 'error');
        }

        $group = Table::getInstance('Group', 'CTable');
        $model = $this->getModel('groups', 'CommunityAdminModel');
        $joinedGroups = $model->getGroupIds($memberId);
        $new_groups = [];

        foreach ($groupId as $id) {
            $group->load($id);

            if (!$group->id) {
                continue;
            }
            if (in_array($group->id, $joinedGroups)) {
                continue;
            }

            if($group->isMember($memberid, null)){
                // approving member
                $member = Table::getInstance('GroupMembers', 'CTable');
                $keys = array('groupId' => $group->id, 'memberId' => $memberId);
                $member->load($keys);
                $member->approve();
            } else {
                $data = new stdClass();
                $data->groupid = $group->id;
                $data->memberid = $memberId;
                $data->approved = 1;
                $data->permissions = 0;

                $group->addMember($data);
                $group->updateStats();
                $group->store();

                $this->triggerEvent('onGroupJoin', $group, $user->id);
            }

            $new_groups[] = $group->name;
        }

        if ($new_groups) {
            $new_groups_name = implode(', ', $new_groups);
            $message = Text::sprintf('COM_COMMUNITY_GROUP_USER_ASSIGNED', $user->getDisplayName(), $new_groups_name);
            $app->enqueueMessage($message);
            $user->updateGroupList(true);
        }

        $leave_groups = [];

        foreach ($joinedGroups as $id) {
            if (in_array($id, $groupId)) {
                continue;
            }

            $group->load($id);

            if ($group->isMember($memberId)) {
                $data = new stdClass();
                $data->groupid = $id;
                $data->memberid = $user->id;
                $model->removeMember($data);
                $group->updateStats();
                $group->store();

                $this->triggerEvent('onGroupLeave', $group, $user->id);

                $leave_groups[] = $group->name;
            }
        }

        if ($leave_groups) {
            $leave_groups_name = implode(', ', $leave_groups);
            $message = Text::sprintf('COM_COMMUNITY_GROUP_USER_UNASSIGNED', $user->getDisplayName(), $leave_groups_name);
            $app->enqueueMessage($message, 'notice');
            $user->updateGroupList(true);
        }

        return $this->setRedirect('index.php?option=com_community&view=users');
    }

    public function saveGroup()
    {
        $group  = Table::getInstance( 'Groups' , 'CommunityTable' );
        $mainframe  = Factory::getApplication();
        $jinput     = $mainframe->input;
        $id         = $jinput->post->get('id' , '', 'INT');

        if( empty($id) )
        {
            Factory::getApplication()->enqueueMessage(Text::_('COM_COMMUNITY_INVALID_ID'), 'error');
        }

        $postData   = $jinput->post->getArray();
        $description = $jinput->post->get('description', '', 'RAW');
        $postData['description'] = $description;

        if ($postData['photopermission-admin'] == 1) {
            if ($postData['photopermission-member'] == 1) {
                $postData['photopermission'] = GROUP_PHOTO_PERMISSION_ALL;
            } else {
                $postData['photopermission'] = GROUP_PHOTO_PERMISSION_ADMINS;
            }
        } else {
            $postData['photopermission'] = GROUP_PHOTO_PERMISSION_DISABLE;
        }

        if ($postData['videopermission-admin'] == 1) {
            if ($postData['videopermission-member'] == 1) {
                $postData['videopermission'] = GROUP_VIDEO_PERMISSION_ALL;
            } else {
                $postData['videopermission'] = GROUP_VIDEO_PERMISSION_ADMINS;
            }
        } else {
            $postData['videopermission'] = GROUP_VIDEO_PERMISSION_DISABLE;
        }

        if ($postData['filesharingpermission-admin'] == 1) {
            if ($postData['filesharingpermission-member'] == 1) {
                $postData['filesharingpermission'] = GROUP_FILESHARING_PERMISSION_ALL;
            } else {
                $postData['filesharingpermission'] = GROUP_FILESHARING_PERMISSION_ADMINS;
            }
        } else {
            $postData['filesharingpermission'] = GROUP_FILESHARING_PERMISSION_DISABLE;
        }

        if ($postData['eventpermission-admin'] == 1) {
            if ($postData['eventpermission-member'] == 1) {
                $postData['eventpermission'] = GROUP_EVENT_PERMISSION_ALL;
            } else {
                $postData['eventpermission'] = GROUP_EVENT_PERMISSION_ADMINS;
            }
        } else {
            $postData['eventpermission'] = GROUP_EVENT_PERMISSION_DISABLE;
        }

        if (!isset($postData['groupdiscussionfilesharing'])) {
            $postData['groupdiscussionfilesharing'] = 0;
        }

        if (!isset($postData['groupannouncementfilesharing'])) {
            $postData['groupannouncementfilesharing'] = 0;
        }

        $group->load( $id );

        $groupParam = new CParameter($group->params);
        $group->bind( $postData );

        foreach($postData as $key=>$data){

            if(!is_null($groupParam->get($key,NULL))) {
                $groupParam->set($key,$data);
            }
        }

        $group->params = $groupParam->toString();

        $message    = '';
        if( $group->store() )
        {
            $message    = Text::_('COM_COMMUNITY_GROUP_SAVED');
        }
        else
        {
            $message    = Text::_('COM_COMMUNITY_GROUP_SAVE_ERROR');
        }

        $mainframe  = Factory::getApplication();

        return $this->setRedirect( 'index.php?option=com_community&view=groups' , $message ,'message' );
    }

    public function deleteGroup()
    {
        require_once(JPATH_ROOT . '/components/com_community/libraries/featured.php');
        require_once(JPATH_ROOT . '/components/com_community/defines.community.php');

        $featured   = new CFeatured(FEATURED_GROUPS);

        $groupWithError = array();

        $group  = Table::getInstance( 'Group' , 'CTable' );

        $mainframe  = Factory::getApplication();
        $jinput     = $mainframe->input;

        $id         = $jinput->get('cid' , '', 'NONE');

        if( empty($id) )
        {
            Factory::getApplication()->enqueueMessage(Text::_('COM_COMMUNITY_INVALID_ID'), 'error');
        }

        foreach($id as $data)
        {
            require_once( JPATH_ROOT . '/components/com_community/models/groups.php' );

            //delete group bulletins
            CommunityModelGroups::deleteGroupBulletins($data);

            //delete group members
            CommunityModelGroups::deleteGroupMembers($data);

            //delete group wall
            CommunityModelGroups::deleteGroupWall($data);

            //delete group discussions
            CommunityModelGroups::deleteGroupDiscussions($data);

            //delete group media files
            CommunityModelGroups::deleteGroupMedia($data);

            //load group data before delete
            $group->load( $data );
            $groupData = $group;

            //delete group avatar.
            jimport( 'joomla.filesystem.file' );
            if( !empty( $groupData->avatar) )
            {
                //images/avatar/groups/d203ccc8be817ad5b6a8335c.png
                $path = explode('/', $groupData->avatar);
                $file = JPATH_ROOT .'/'. $path[0] .'/'. $path[1] .'/'. $path[2] .'/'. $path[3];
                if(file_exists($file))
                {
                    File::delete($file);
                }
            }

            if( !empty( $groupData->thumb ) )
            {
                //images/avatar/groups/thumb_d203ccc8be817ad5b6a8335c.png
                $path = explode('/', $groupData->thumb);
                $file = JPATH_ROOT .'/'. $path[0] .'/'. $path[1] .'/'. $path[2] .'/'. $path[3];
                if(file_exists($file))
                {
                    File::delete($file);
                }
            }

            if( !$group->delete( $data ) )
            {
                array_push($groupWithError, $data.':'.$groupData->name);
            }

            $featured->delete( $data );
        }

        $message    = '';
        if( empty($error) )
        {
            $message    = Text::_('COM_COMMUNITY_GROUP_DELETED');
        }
        else
        {
            $error = implode(',', $groupWithError);
            $message    = Text::sprintf('COM_COMMUNITY_GROUPS_DELETE_GROUP_ERROR' , $error);
        }

        $mainframe  = Factory::getApplication();

        return $this->setRedirect( 'index.php?option=com_community&view=groups' , $message ,'message');
    }

    /**
     *  Responsible to save an existing or a new group.
     */
    public function save()
    {
        Session::checkToken() or jexit( Text::_( 'COM_COMMUNITY_INVALID_TOKEN' ) );

        $mainframe  = Factory::getApplication();
        $jinput     = $mainframe->input;

        if( StringHelper::strtoupper($jinput->getMethod()) != 'POST')
        {
            return $this->setRedirect( 'index.php?option=com_community&view=groups' , Text::_( 'COM_COMMUNITY_PERMISSION_DENIED' ) , 'error');
        }

        // Load frontend language file.
        $lang   = Factory::getLanguage();
        $lang->load( 'com_community' , JPATH_ROOT );

        $group          = Table::getInstance( 'Group' , 'CTable' );
        $id             = $jinput->getInt( 'groupid' );
        $group->load( $id );

        $tmpPublished   = $group->published;
        $name           = $jinput->post->get('name' , '', 'STRING') ;
        $published      = $jinput->post->get('published' , '', 'NONE') ;
        $description    = $jinput->post->get('description' , '', 'STRING') ;
        $categoryId     = $jinput->post->get('categoryid' , '', 'INT') ;
        $creator        = $jinput->post->get( 'creator' , 0 );
        $website        = $jinput->post->get('website' , '', 'STRING') ;
        $validated      = true;
        $model          = $this->getModel( 'Groups','CommunityAdminModel' );
        $isNew          = $group->id < 1;
        $ownerChanged   = $group->ownerid != $creator && $group->id >= 1 ;

        // @rule: Test for emptyness
        if( empty( $name ) )
        {
            $validated  = false;
            $mainframe->enqueueMessage( Text::_('COM_COMMUNITY_GROUPS_EMPTY_NAME_ERROR'), 'error');
        }

        // @rule: Test if group exists
        if( $model->groupExist( $name , $group->id ) )
        {
            $validated  = false;
            $mainframe->enqueueMessage( Text::_('COM_COMMUNITY_GROUPS_NAME_TAKEN_ERROR'), 'error');
        }

        // @rule: Test for emptyness
        if( empty( $description ) )
        {
            $validated  = false;
            $mainframe->enqueueMessage( Text::_('COM_COMMUNITY_GROUPS_DESCRIPTION_EMPTY_ERROR'), 'error');
        }

        if( empty( $categoryId ) )
        {
            $validated  = false;
            $mainframe->enqueueMessage(Text::_('COM_COMMUNITY_GROUPS_CATEGORY_ERROR'), 'error');
        }

        if($validated)
        {
            // Get the configuration object.
            $config = CFactory::getConfig();

            $group->bindRequestParams();

            // Bind the post with the table first
            $group->name        = $name;
            $group->published       = $published;
            $group->description = $description;
            $group->categoryid  = $categoryId;
            $group->website     = $website;
            $group->approvals   = $jinput->post->get('approvals' , '0');
            $oldOwner           = $group->ownerid;
            $group->ownerid     = $creator;
            if( $isNew )
            {
                $group->created     = gmdate('Y-m-d H:i:s');
            }

            $group->store();

            if( $isNew )
            {
                // Since this is storing groups, we also need to store the creator / admin
                // into the groups members table
                $member             = Table::getInstance( 'GroupMembers' , 'CTable' );
                $member->groupid    = $group->id;
                $member->memberid   = $group->ownerid;

                // Creator should always be 1 as approved as they are the creator.
                $member->approved   = 1;

                // @todo: Setup required permissions in the future
                $member->permissions    = '1';
                $member->store();
            }

            if( !$isNew && $ownerChanged )
            {
                $group->updateOwner( $oldOwner , $creator );
            }

            // send notification if necessary
            if($tmpPublished==0 && $group->published == 1 && $config->get( 'moderategroupcreation' )){
                $this->notificationApproval($group);
            }

            $message    = $isNew ? Text::_( 'COM_COMMUNITY_GROUPS_CREATED' ) : Text::_( 'COM_COMMUNITY_GROUPS_UPDATED' );
            return $this->setRedirect( 'index.php?option=com_community&view=groups' , $message, 'message' );
        }

        $document   = Factory::getDocument();

        $viewName   = $jinput->get( 'view' , 'community' );

        // Get the view type
        $viewType   = $document->getType();

        // Get the view
        $view       = $this->getView( $viewName , $viewType );

        $view->setLayout( 'edit' );

        $model      = $this->getModel( $viewName ,'CommunityAdminModel' );

        if( $model )
        {
            $view->setModel( $model , $viewName );
        }

        $view->display();
    }

    public function notificationApproval($group)
    {
        $lang = Factory::getLanguage();
        $lang->load( 'com_community', JPATH_ROOT );

        $my         = CFactory::getUser();

        // Add notification
        //Send notification email to owner
        $params = new CParameter( '' );
        $params->set('url' , 'index.php?option=com_community&view=groups&task=viewgroup&groupid=' . $group->id );
        $params->set('groupName' , $group->name );
        $params->set('group' , $group->name );
        $params->set('group_url' , 'index.php?option=com_community&view=groups&task=viewgroup&groupid=' . $group->id );

        CNotificationLibrary::add( 'groups_notify_creator' , $my->id , $group->ownerid , Text::_( 'COM_COMMUNITY_GROUPS_PUBLISHED_MAIL_SUBJECT') , '' , 'groups.notifycreator' , $params );

    }

    public function triggerEvent( $eventName, &$args, $target = null)
    {
        CError::assert( $args , 'object', 'istype', __FILE__ , __LINE__ );

        require_once( COMMUNITY_COM_PATH.'/libraries/apps.php' );
        $appsLib    = CAppPlugins::getInstance();
        $appsLib->loadApplications();

        $params     = array();
        $params[]   = $args;

        if(!is_null($target))
            $params[]   = $target;

        $appsLib->triggerEvent( $eventName , $params);
        return true;
    }
}