PHP DiscussionModel::CategoryPermissions方法代码示例

 public function Get($Begin, $End, $Offset = '0', $Limit = '')
 {
     // Validate parameters, set today as default
     $BeginDate = strtotime($Begin);
     if ($BeginDate <= 0) {
         $BeginDate = date('Y-m-d');
     } else {
         $BeginDate = date('Y-m-d', $BeginDate);
     }
     $EndDate = strtotime($End);
     if ($EndDate <= 0) {
         $EndDate = date('Y-m-d');
     } else {
         $EndDate = date('Y-m-d', $EndDate);
     }
     if (!is_numeric($Offset)) {
         $Offset = 0;
     }
     if (!is_numeric($Limit)) {
         $Limit = '';
     }
     $Sql = GDN::SQL();
     $Sql->Select('d.Name, d.Body, d.Format')->Select('d.InsertUserID', '', 'UserID')->Select('DAY FROM d.EventCalendarDate', 'EXTRACT', 'EventCalendarDay')->From('Discussion d')->Where('d.EventCalendarDate >=', $BeginDate)->Where('d.EventCalendarDate <=', $EndDate)->OrderBy('d.EventCalendarDate')->Limit($Limit, $Offset);
     // add permission restrictions if necessary
     $Perms = DiscussionModel::CategoryPermissions();
     if ($Perms !== TRUE) {
         $Sql->WhereIn('d.CategoryID', $Perms);
     }
     // return $Sql->GetSelect();
     return $Sql->Get()->ResultArray();
 }

   public function GetData($Limit = 10) {
      $this->Data = FALSE;
      if (Gdn::Session()->IsValid() && C('Vanilla.Modules.ShowBookmarkedModule', TRUE)) {
         $BookmarkIDs = Gdn::SQL()
            ->Select('DiscussionID')
            ->From('UserDiscussion')
            ->Where('UserID', Gdn::Session()->UserID)
            ->Where('Bookmarked', 1)
            ->Get()->ResultArray();
         $BookmarkIDs = ConsolidateArrayValuesByKey($BookmarkIDs, 'DiscussionID');

         if (count($BookmarkIDs)) {
            $DiscussionModel = new DiscussionModel();
            DiscussionModel::CategoryPermissions();

            $DiscussionModel->SQL->WhereIn('d.DiscussionID', $BookmarkIDs);
            
            $this->Data = $DiscussionModel->Get(
               0,
               $Limit
            );
         } else {
            $this->Data = FALSE;
         }
      }
   }

 public function getData()
 {
     if (Gdn::session()->isValid()) {
         $BookmarkIDs = Gdn::sql()->select('DiscussionID')->from('UserDiscussion')->where('UserID', Gdn::session()->UserID)->where('Bookmarked', 1)->get()->resultArray();
         $BookmarkIDs = consolidateArrayValuesByKey($BookmarkIDs, 'DiscussionID');
         if (count($BookmarkIDs)) {
             $DiscussionModel = new DiscussionModel();
             DiscussionModel::CategoryPermissions();
             $DiscussionModel->SQL->whereIn('d.DiscussionID', $BookmarkIDs);
             $Bookmarks = $DiscussionModel->get(0, $this->Limit, array('w.Bookmarked' => '1'));
             $this->setData('Bookmarks', $Bookmarks);
         } else {
             $this->setData('Bookmarks', new Gdn_DataSet());
         }
     }
 }

 /**
  *
  * Get comments for a user. This is an optimized version of CommentModel->GetByUser().
  *
  * @since 2.1
  * @access public
  *
  * @param int $UserID Which user to get comments for.
  * @param int $Limit Max number to get.
  * @param int $Offset Number to skip.
  * @param int $LastCommentID A hint for quicker paging.
  * @return Gdn_DataSet SQL results.
  */
 public function getByUser2($UserID, $Limit, $Offset, $LastCommentID = false)
 {
     $Perms = DiscussionModel::CategoryPermissions();
     if (is_array($Perms) && empty($Perms)) {
         return new Gdn_DataSet(array());
     }
     // The point of this query is to select from one comment table, but filter and sort on another.
     // This puts the paging into an index scan rather than a table scan.
     $this->SQL->select('c2.*')->select('d.Name', '', 'DiscussionName')->select('d.CategoryID')->from('Comment c')->join('Comment c2', 'c.CommentID = c2.CommentID')->join('Discussion d', 'c2.DiscussionID = d.DiscussionID')->where('c.InsertUserID', $UserID)->orderBy('c.CommentID', 'desc');
     if ($LastCommentID) {
         // The last comment id from the last page was given and can be used as a hint to speed up the query.
         $this->SQL->where('c.CommentID <', $LastCommentID)->limit($Limit);
     } else {
         $this->SQL->limit($Limit, $Offset);
     }
     $Data = $this->SQL->get();
     $Result =& $Data->result();
     $this->LastCommentCount = $Data->numRows();
     if (count($Result) > 0) {
         $this->LastCommentID = $Result[count($Result) - 1]->CommentID;
     } else {
         $this->LastCommentID = null;
     }
     // Now that we have th comments we can filter out the ones we don't have permission to.
     if ($Perms !== true) {
         $Remove = array();
         foreach ($Data->result() as $Index => $Row) {
             if (!in_array($Row->CategoryID, $Perms)) {
                 $Remove[] = $Index;
             }
         }
         if (count($Remove) > 0) {
             foreach ($Remove as $Index) {
                 unset($Result[$Index]);
             }
             $Result = array_values($Result);
         }
     }
     Gdn::userModel()->joinUsers($Data, array('InsertUserID', 'UpdateUserID'));
     $this->EventArguments['Comments'] =& $Data;
     $this->fireEvent('AfterGet');
     return $Data;
 }

 /**
  * Get full data for a single category by its URL slug. Respects permissions.
  * 
  * @since 2.0.0
  * @access public
  *
  * @param string $UrlCode Unique category slug from URL.
  * @return object SQL results.
  */
 public function GetFullByUrlCode($UrlCode)
 {
     $Data = (object) self::Categories($UrlCode);
     // Check to see if the user has permission for this category.
     // Get the category IDs.
     $CategoryIDs = DiscussionModel::CategoryPermissions();
     if (is_array($CategoryIDs) && !in_array(GetValue('CategoryID', $Data), $CategoryIDs)) {
         $Data = FALSE;
     }
     return $Data;
 }

 /**
  *
  * Get discussions for a user.
  *
  * Events: BeforeGetByUser
  *
  * @since 2.1
  * @access public
  *
  * @param int $UserID Which user to get discussions for.
  * @param int $Limit Max number to get.
  * @param int $Offset Number to skip.
  * @param int $LastDiscussionID A hint for quicker paging.
  * @param int $WatchUserID User to use for read/unread data.
  * @return Gdn_DataSet SQL results.
  */
 public function getByUser($UserID, $Limit, $Offset, $LastDiscussionID = false, $WatchUserID = false)
 {
     $Perms = DiscussionModel::CategoryPermissions();
     if (is_array($Perms) && empty($Perms)) {
         return new Gdn_DataSet(array());
     }
     // Allow us to set perspective of a different user.
     if (!$WatchUserID) {
         $WatchUserID = $UserID;
     }
     // The point of this query is to select from one comment table, but filter and sort on another.
     // This puts the paging into an index scan rather than a table scan.
     $this->SQL->select('d2.*')->select('d2.InsertUserID', '', 'FirstUserID')->select('d2.DateInserted', '', 'FirstDate')->select('d2.DateLastComment', '', 'LastDate')->select('d2.LastCommentUserID', '', 'LastUserID')->from('Discussion d')->join('Discussion d2', 'd.DiscussionID = d2.DiscussionID')->where('d.InsertUserID', $UserID)->orderBy('d.DiscussionID', 'desc');
     // Join in the watch data.
     if ($WatchUserID > 0) {
         $this->SQL->select('w.UserID', '', 'WatchUserID')->select('w.DateLastViewed, w.Dismissed, w.Bookmarked')->select('w.CountComments', '', 'CountCommentWatch')->select('w.Participated')->join('UserDiscussion w', 'd2.DiscussionID = w.DiscussionID and w.UserID = ' . $WatchUserID, 'left');
     } else {
         $this->SQL->select('0', '', 'WatchUserID')->select('now()', '', 'DateLastViewed')->select('0', '', 'Dismissed')->select('0', '', 'Bookmarked')->select('0', '', 'CountCommentWatch')->select('d.Announce', '', 'IsAnnounce');
     }
     if ($LastDiscussionID) {
         // The last comment id from the last page was given and can be used as a hint to speed up the query.
         $this->SQL->where('d.DiscussionID <', $LastDiscussionID)->limit($Limit);
     } else {
         $this->SQL->limit($Limit, $Offset);
     }
     $this->fireEvent('BeforeGetByUser');
     $Data = $this->SQL->get();
     $Result =& $Data->result();
     $this->LastDiscussionCount = $Data->numRows();
     if (count($Result) > 0) {
         $this->LastDiscussionID = $Result[count($Result) - 1]->DiscussionID;
     } else {
         $this->LastDiscussionID = null;
     }
     // Now that we have th comments we can filter out the ones we don't have permission to.
     if ($Perms !== true) {
         $Remove = array();
         foreach ($Data->result() as $Index => $Row) {
             if (!in_array($Row->CategoryID, $Perms)) {
                 $Remove[] = $Index;
             }
         }
         if (count($Remove) > 0) {
             foreach ($Remove as $Index) {
                 unset($Result[$Index]);
             }
             $Result = array_values($Result);
         }
     }
     // Change discussions returned based on additional criteria
     $this->AddDiscussionColumns($Data);
     // Join in the users.
     Gdn::userModel()->joinUsers($Data, array('FirstUserID', 'LastUserID'));
     CategoryModel::JoinCategories($Data);
     if (c('Vanilla.Views.Denormalize', false)) {
         $this->AddDenormalizedViews($Data);
     }
     $this->EventArguments['Data'] =& $Data;
     $this->fireEvent('AfterAddColumns');
     return $Data;
 }

 /**
  * Join external records to an array.
  *
  * @param array &$Data The data to join.
  * In order to join records each row must have the a RecordType and RecordID column.
  * @param string $Column The name of the column to put the record in.
  * If this is blank then the record will be merged into the row.
  * @param bool $Unset Whether or not to unset rows that don't have a record.
  * @since 2.3
  */
 function joinRecords(&$Data, $Column = '', $Unset = false)
 {
     $IDs = array();
     $AllowedCats = DiscussionModel::CategoryPermissions();
     if ($AllowedCats === false) {
         // This user does not have permission to view anything.
         $Data = array();
         return;
     }
     // Gather all of the ids to fetch.
     foreach ($Data as &$Row) {
         if (!$Row['RecordType']) {
             continue;
         }
         $RecordType = ucfirst(StringEndsWith($Row['RecordType'], '-Total', true, true));
         $Row['RecordType'] = $RecordType;
         $ID = $Row['RecordID'];
         $IDs[$RecordType][$ID] = $ID;
     }
     // Fetch all of the data in turn.
     $JoinData = array();
     foreach ($IDs as $RecordType => $RecordIDs) {
         if ($RecordType == 'Comment') {
             Gdn::SQL()->Select('d.Name, d.CategoryID')->Join('Discussion d', 'd.DiscussionID = r.DiscussionID');
         }
         $Rows = Gdn::SQL()->Select('r.*')->WhereIn($RecordType . 'ID', array_values($RecordIDs))->Get($RecordType . ' r')->ResultArray();
         $JoinData[$RecordType] = Gdn_DataSet::Index($Rows, array($RecordType . 'ID'));
     }
     // Join the rows.
     $Unsets = array();
     foreach ($Data as $Index => &$Row) {
         $RecordType = $Row['RecordType'];
         $ID = $Row['RecordID'];
         if (!isset($JoinData[$RecordType][$ID])) {
             if ($Unset) {
                 $Unsets[] = $Index;
             }
             continue;
             // orphaned?
         }
         $Record = $JoinData[$RecordType][$ID];
         if ($AllowedCats !== true) {
             // Check to see if the user has permission to view this record.
             $CategoryID = GetValue('CategoryID', $Record, -1);
             if (!in_array($CategoryID, $AllowedCats)) {
                 $Unsets[] = $Index;
                 continue;
             }
         }
         switch ($RecordType) {
             case 'Discussion':
                 $Url = DiscussionUrl($Record, '', '/') . '#latest';
                 break;
             case 'Comment':
                 $Url = CommentUrl($Record, '/');
                 $Record['Name'] = sprintf(T('Re: %s'), $Record['Name']);
                 break;
             default:
                 $Url = '';
         }
         $Record['Url'] = $Url;
         if ($Column) {
             $Row[$Column] = $Record;
         } else {
             $Row = array_merge($Row, $Record);
         }
     }
     foreach ($Unsets as $Index) {
         unset($Data[$Index]);
     }
     // Join the users.
     Gdn::UserModel()->JoinUsers($Data, array('InsertUserID'));
     if (!empty($Unsets)) {
         $Data = array_values($Data);
     }
 }

 /**
  * Get comments for a user.
  * 
  * @since 2.0.17
  * @access public
  * 
  * @param int $UserID Which user to get comments for.
  * @param int $Limit Max number to get.
  * @param int $Offset Number to skip.
  * @return object SQL results.
  */
 public function GetByUser($UserID, $Limit, $Offset = 0)
 {
     // Get category permissions
     $Perms = DiscussionModel::CategoryPermissions();
     // Build main query
     $this->CommentQuery(TRUE, FALSE);
     $this->FireEvent('BeforeGet');
     $this->SQL->Select('d.Name', '', 'DiscussionName')->Join('Discussion d', 'c.DiscussionID = d.DiscussionID')->Where('c.InsertUserID', $UserID)->OrderBy('c.CommentID', 'desc')->Limit($Limit, $Offset);
     // Verify permissions (restricting by category if necessary)
     if ($Perms !== TRUE) {
         $this->SQL->Join('Category ca', 'd.CategoryID = ca.CategoryID', 'left')->WhereIn('d.CategoryID', $Perms);
     }
     //$this->OrderBy($this->SQL);
     $Data = $this->SQL->Get();
     Gdn::UserModel()->JoinUsers($Data, array('InsertUserID', 'UpdateUserID'));
     return $Data;
 }

   /**
    * Get full data for a single category by its URL slug. Respects permissions.
    * 
    * @since 2.0.0
    * @access public
    *
    * @param string $UrlCode Unique category slug from URL.
    * @return object SQL results.
    */
   public function GetFullByUrlCode($UrlCode) {
      $this->SQL
         ->Select('c.*')
         ->From('Category c')
         ->Where('c.UrlCode', $UrlCode)
         ->Where('c.CategoryID >', 0);
         
      $Data = $this->SQL
         ->Get()
         ->FirstRow();

      // Check to see if the user has permission for this category.
      // Get the category IDs.
      $CategoryIDs = DiscussionModel::CategoryPermissions();
      if (is_array($CategoryIDs) && !in_array(GetValue('CategoryID', $Data), $CategoryIDs))
         $Data = FALSE;
      return $Data;
   }