group.php

<?php

/**
 * group
 * 
 * @package Delus
 * @author Dmitry
 */

// fetch bootloader
require('bootloader.php');

// user access
if (!$system['system_public']) {
  user_access();
}

// check username
if (is_empty($_GET['username']) || !valid_username($_GET['username'])) {
  _error(404);
}

try {

  // [1] get main group info
  $get_group = $db->query(sprintf("SELECT `groups`.*, picture_photo.source as group_picture_full, cover_photo.source as group_cover_full, groups_categories.category_name as group_category_name FROM `groups` LEFT JOIN posts_photos as picture_photo ON groups.group_picture_id = picture_photo.photo_id LEFT JOIN posts_photos as cover_photo ON `groups`.group_cover_id = cover_photo.photo_id LEFT JOIN groups_categories ON `groups`.group_category = groups_categories.category_id WHERE `groups`.group_name = %s", secure($_GET['username'])));
  if ($get_group->num_rows == 0) {
    _error(404);
  }
  $group = $get_group->fetch_assoc();
  /* check username case */
  if (strtolower($_GET['username']) == strtolower($group['group_name']) && $_GET['username'] != $group['group_name']) {
    redirect('/groups/' . $group['group_name']);
  }
  /* get group picture */
  $group['group_picture_default'] = ($group['group_picture']) ? false : true;
  $group['group_picture'] = get_picture($group['group_picture'], 'group');
  $group['group_picture_full'] = ($group['group_picture_full']) ? $system['system_uploads'] . '/' . $group['group_picture_full'] : $group['group_picture_full'];
  /* get group cover */
  $group['group_cover'] = ($group['group_cover']) ? $system['system_uploads'] . '/' . $group['group_cover'] : $group['group_cover'];
  $group['group_cover_full'] = ($group['group_cover_full']) ? $system['system_uploads'] . '/' . $group['group_cover_full'] : $group['group_cover_full'];
  /* check group category */
  $group['group_category_name'] = (!$group['group_category_name']) ? __('N/A') : $group['group_category_name']; /* in case deleted by system admin */
  /* get the connection */
  $group['i_admin'] = $user->check_group_adminship($user->_data['user_id'], $group['group_id']);
  $group['i_joined'] = $user->check_group_membership($user->_data['user_id'], $group['group_id']);
  $group['i_invited'] = $user->check_group_invitation($user->_data['user_id'], $group['group_id']);
  /* get chatbox converstaion */
  if ($system['chat_enabled'] && $group['chatbox_enabled'] && $group['i_joined'] == "approved") {
    $group['chatbox_conversation'] = $user->get_chatbox($group['chatbox_conversation_id']);
  }
  /* get group posts count */
  $group['posts_count'] = $user->get_posts_count($group['group_id'], 'group');
  /* get group photos count */
  $group['photos_count'] = $user->get_photos_count($group['group_id'], 'group');
  /* get group videos count */
  if ($system['videos_enabled']) {
    $group['videos_count'] = $user->get_videos_count($group['group_id'], 'group');
  }
  /* get group reviews count */
  if ($system['groups_reviews_enabled']) {
    $group['reviews_count'] = $user->get_reviews_count($group['group_id'], 'group');
  }
  /* check if group's admin can monetize content */
  $group['can_monetize_content'] = $system['monetization_enabled'] && $user->check_user_permission($group['group_admin'], 'monetization_permission');
  /* check if group has monetization enabled && subscriptions plans */
  $group['has_subscriptions_plans'] = $group['can_monetize_content'] && $group['group_monetization_enabled'] && $group['group_monetization_plans'] > 0;
  /* check if the group needs subscription (exclude: admins & mods & group's admin) */
  $group['needs_subscription'] = false;
  if ($group['has_subscriptions_plans']) {
    if ($user->_logged_in) {
      if ($user->_data['user_group'] == 3 && !$group['i_admin']) {
        if (!$user->is_subscribed($group['group_id'], 'group')) {
          $group['needs_subscription'] = true;
        }
      }
    } else {
      $group['needs_subscription'] = true;
    }
  }

  // [2] get view content
  /* check group privacy */
  if ($group['group_privacy'] == "secret") {
    if ($group['i_joined'] != "approved" && !$group['i_invited'] && !$group['i_admin']) {
      if (!$user->_is_admin && !$user->_is_moderator) {
        _error(404);
      }
    }
    if ($group['i_joined'] != "approved" && $group['i_invited']) {
      $_GET['view'] = 'members';
    }
  }
  if ($group['group_privacy'] == "closed") {
    if ($group['i_joined'] != "approved" && !$group['i_admin']) {
      if (!$user->_is_admin && !$user->_is_moderator) {
        $_GET['view'] = 'members';
      }
    }
  }
  switch ($_GET['view']) {
    case '':
      /* get custom fields */
      $smarty->assign('custom_fields', $user->get_custom_fields(["for" => "group", "get" => "profile", "node_id" => $group['group_id']]));

      /* get subscribers */
      if ($group['has_subscriptions_plans']) {
        /* get subscribers count */
        $group['subscribers_count'] = $user->get_subscribers_count($group['group_id'], 'group');
        /* get subscribers */
        if ($group['subscribers_count'] > 0) {
          $group['subscribers'] = $user->get_subscribers($group['group_id'], 'group');
        }
      }

      /* get invites */
      $group['invites'] = $user->get_group_invites($group['group_id']);

      /* get photos */
      if (!$group['needs_subscription']) {
        $group['photos'] = $user->get_photos($group['group_id'], 'group');
      }

      /* get [pending] group requests */
      if ($group['i_admin'] && $group['group_privacy'] != "public") {
        $group['total_requests'] = $user->get_group_requests_total($group['group_id']);
      }

      /* get [pending] group posts */
      if ($group['group_publish_approval_enabled']) {
        $get_all = ($group['i_admin']) ? true : false;
        $group['pending_posts'] = $user->get_group_pending_posts($group['group_id'], $get_all);
      }

      /* prepare publisher */
      $smarty->assign('feelings', get_feelings());
      $smarty->assign('feelings_types', get_feelings_types());
      if ($system['colored_posts_enabled']) {
        $smarty->assign('colored_patterns', $user->get_posts_colored_patterns());
      }
      if ($user->_data['can_upload_videos']) {
        $smarty->assign('videos_categories', $user->get_categories("posts_videos_categories"));
      }
      /* check if there is share URL */
      if ($_GET['url']) {
        $smarty->assign('url', $_GET['url']);
      }

      /* get pinned post */
      $pinned_post = $user->get_post($group['group_pinned_post'], true, false, true);
      $smarty->assign('pinned_post', $pinned_post);

      /* get posts */
      if (isset($_GET['pending'])) {
        $get = ($group['i_admin']) ? "posts_group_pending_all" : "posts_group_pending";
      } else {
        $get = "posts_group";
      }
      /* newsfeed location filter */
      if ($system['newsfeed_location_filter_enabled']) {
        // get selected country
        if (isset($_GET['country'])) {
          /* get selected country */
          $selected_country = $user->get_country_by_name($_GET['country']);
          /* assign variables */
          $smarty->assign('selected_country', $selected_country);
        }
      }
      $posts = ($selected_country) ? $user->get_posts(['country' => $selected_country['country_id'], 'get' => $get, 'id' => $group['group_id']]) : $user->get_posts(['get' => $get, 'id' => $group['group_id']]);
      /* assign variables */
      $smarty->assign('posts', $posts);
      $smarty->assign('get', $get);

      /* get ads */
      $smarty->assign('ads', $user->ads('groups', $group['group_id']));
      break;

    case 'photos':
      /* get content */
      if (!$group['needs_subscription']) {
        /* get photos */
        $group['photos'] = $user->get_photos($group['group_id'], 'group');
      }
      break;

    case 'albums':
      /* get content */
      if (!$group['needs_subscription']) {
        /* get albums */
        $group['albums'] = $user->get_albums($group['group_id'], 'group');
      }
      break;

    case 'album':
      /* get content */
      if (!$group['needs_subscription']) {
        /* get album */
        $album = $user->get_album($_GET['id']);
        if (!$album || ($album['group_id'] != $group['group_id'])) {
          _error(404);
        }
        /* assign variables */
        $smarty->assign('album', $album);
      }
      break;

    case 'videos':
      /* check if videos enabled */
      if (!$system['videos_enabled']) {
        _error(404);
      }
      /* get content */
      if (!$group['needs_subscription']) {
        /* get videos */
        $group['videos'] = $user->get_videos($group['group_id'], 'group');
      }
      break;

    case 'reels':
      /* check if reels enabled */
      if (!$system['reels_enabled']) {
        _error(404);
      }
      /* get content */
      if (!$group['needs_subscription']) {
        /* get reels */
        $group['reels'] = $user->get_reels($group['group_id'], 'group');
      }
      break;

    case 'products':
      /* get content */
      if (!$group['needs_subscription']) {
        /* get posts (products) */
        $posts = $user->get_posts(['get' => 'posts_group', 'id' => $group['group_id'], 'filter' => 'product']);
        /* assign variables */
        $smarty->assign('posts', $posts);
      }
      break;

    case 'reviews':
      /* check if reviews enabled */
      if (!$system['groups_reviews_enabled']) {
        _error(404);
      }
      /* get reviews */
      if ($group['reviews_count'] > 0) {
        $group['reviews'] = $user->get_reviews($group['group_id'], 'group');
      }
      break;

    case 'members':
      /* get members */
      if ($group['group_members'] > 0) {
        $group['members'] = $user->get_group_members($group['group_id']);
      }
      break;

    case 'subscribers':
      /* check if has subscriptions plans */
      if (!$group['has_subscriptions_plans']) {
        _error(404);
      }
      /* get subscribers count */
      $group['subscribers_count'] = $user->get_subscribers_count($group['group_id'], 'group');
      /* get subscribers */
      if ($group['subscribers_count'] > 0) {
        $group['subscribers'] = $user->get_subscribers($group['group_id'], 'group');
      }
      break;

    case 'invites':
      /* check if the viewer is a group member */
      if ($group['i_joined'] != "approved") {
        _error(404);
      }
      /* get invites */
      $group['invites'] = $user->get_group_invites($group['group_id']);
      break;

    case 'search':
      /* get search */
      if (isset($_GET['query'])) {
        $filter = (isset($_GET['filter'])) ? $_GET['filter'] : 'all';
        $posts = $user->get_posts(['get' => 'posts_group', 'id' => $group['group_id'], 'query' => $_GET['query'], 'filter' => $filter]);
        /* assign variables */
        $smarty->assign('query', htmlentities($_GET['query'], ENT_QUOTES, 'utf-8'));
        $smarty->assign('filter', $filter);
        $smarty->assign('posts', $posts);
      }
      break;

    case 'settings':
      /* check if the viewer is the admin */
      if (!$group['i_admin']) {
        _error(404);
      }
      /* get sub_view content */
      $sub_view = $_GET['id'];
      switch ($sub_view) {
        case '':
          /* get group categories */
          $smarty->assign('categories', $user->get_categories("groups_categories"));

          /* get countries if not defined */
          if (!$countries) {
            $smarty->assign('countries', $user->get_countries());
          }

          /* get custom fields */
          $smarty->assign('custom_fields', $user->get_custom_fields(["for" => "group", "get" => "settings", "node_id" => $group['group_id']]));
          break;

        case 'requests':
          if ($group['group_privacy'] == "public") {
            _error(404);
          }
          /* get requests */
          $group['requests'] = $user->get_group_requests($group['group_id']);
          break;

        case 'members':
          /* get admins */
          $group['group_admins_count'] = count($user->get_group_admins_ids($group['group_id']));
          $group['group_admins'] = $user->get_group_admins($group['group_id']);

          /* get members */
          if ($group['group_members'] > 0) {
            $group['members'] = $user->get_group_members($group['group_id'], 0, true);
          }
          break;

        case 'monetization':
          // check monetization permission (only group's super admin can do this)
          if (!$user->_data['can_monetize_content']) {
            _error(404);
          }

          // get monetozaion plans
          $smarty->assign('monetization_plans', $user->get_monetization_plans($group['group_id'], 'group'));

          // get subscribers count
          $smarty->assign('subscribers_count', $user->get_subscribers_count($group['group_id'], 'group'));
          break;

        case 'delete':
          /* check if the viewer not the super admin */
          if ($user->_data['user_id'] != $group['group_admin']) {
            _error(404);
          }
          break;

        default:
          _error(404);
          break;
      }
      /* assign variables */
      $smarty->assign('sub_view', $sub_view);
      break;

    default:
      _error(404);
      break;
  }

  // recent rearches
  if (isset($_GET['ref']) && $_GET['ref'] == "qs") {
    $user->set_search_log($group['group_id'], 'group');
  }
} catch (Exception $e) {
  _error(__("Error"), $e->getMessage());
}

// page header
page_header($group['group_title'], $group['group_description'], $group['group_picture']);

// assign variables
$smarty->assign('group', $group);
$smarty->assign('view', $_GET['view']);

// page footer
page_footer('group');