ActivityModel::getComments PHP Метод

getComments() публичный Метод

Events: BeforeGetComments.
public getComments ( array $ActivityIDs ) : Gdn_DataSet
$ActivityIDs array IDs of activity items.
Результат Gdn_DataSet SQL results.
    public function getComments($ActivityIDs)
    {
        $Result = $this->SQL->select('c.*')->from('ActivityComment c')->whereIn('c.ActivityID', $ActivityIDs)->orderBy('c.ActivityID, c.DateInserted')->get()->resultArray();
        Gdn::userModel()->joinUsers($Result, ['InsertUserID'], ['Join' => ['Name', 'Photo', 'Email']]);
        return $Result;
    }

Usage Example

 /**
  * Display a single activity item & comments.
  *
  * Email notifications regarding activities link to this method.
  *
  * @since 2.0.0
  * @access public
  *
  * @param int $ActivityID Unique ID of activity item to display.
  */
 public function item($ActivityID = 0)
 {
     $this->addJsFile('activity.js');
     $this->title(t('Activity Item'));
     if (!is_numeric($ActivityID) || $ActivityID < 0) {
         $ActivityID = 0;
     }
     $this->ActivityData = $this->ActivityModel->getWhere(array('ActivityID' => $ActivityID));
     $this->setData('Comments', $this->ActivityModel->getComments(array($ActivityID)));
     $this->setData('Activities', $this->ActivityData);
     $this->render();
 }
All Usage Examples Of ActivityModel::getComments