PHP CHelpdeskPost::GetStaticMap Examples

Example #1

File: command_creator.php Project: hallnewman/webmail-lite

 /**
  * @param CHelpdeskUser $oHelpdeskUser
  * @param CHelpdeskThread $oThread
  * @param int $iStartFromId = 0
  * @param int $iLimit = 20
  *
  * @return string
  */
 public function GetPosts(CHelpdeskUser $oHelpdeskUser, $oThread, $iStartFromId = 0, $iLimit = 20)
 {
     $aMap = api_AContainer::DbReadKeys(CHelpdeskPost::GetStaticMap());
     $aMap = array_map(array($this, 'escapeColumn'), $aMap);
     $sSql = 'SELECT %s FROM %sahd_posts WHERE deleted = 0';
     $sSql = sprintf($sSql, implode(', ', $aMap), $this->Prefix());
     $aWhere = $this->buildPostsWhere($oHelpdeskUser, $oThread);
     if (0 < $iStartFromId) {
         $aWhere[] = $this->escapeColumn('id_helpdesk_post') . ' < ' . $iStartFromId;
     }
     if (0 < count($aWhere)) {
         $sSql .= ' AND ' . implode(' AND ', $aWhere);
     }
     $sSql .= ' ORDER BY id_helpdesk_post desc LIMIT ' . $iLimit;
     return $sSql;
 }