/** * @param int $iSubscriptionID * * @return string */ public function getSubscriptionById($iSubscriptionID) { $aMap = api_AContainer::DbReadKeys(CSubscription::getStaticMap()); $aMap = array_map(array($this, 'escapeColumn'), $aMap); $sSql = 'SELECT %s FROM %sawm_subscriptions WHERE %s = %d'; return sprintf($sSql, implode(', ', $aMap), $this->prefix(), $this->escapeColumn('id_subscription'), $iSubscriptionID); }
/** * @param CAccount $oAccount * @return string */ public function getFetchers($oAccount) { $aMap = api_AContainer::DbReadKeys(CFetcher::getStaticMap()); $aMap = array_map(array($this, 'escapeColumn'), $aMap); $sSql = 'SELECT %s FROM %sawm_fetchers WHERE %s = %d'; return sprintf($sSql, implode(', ', $aMap), $this->prefix(), $this->escapeColumn('id_acct'), $oAccount->IdAccount); }
/** * @param string $sWhere * @param string $sTableName * @param array $aStaticMap * @param object $oHelper * * @return string */ public static function DbGetObjectSqlString($sWhere, $sTableName, $aStaticMap, $oHelper) { $aMap = api_AContainer::DbReadKeys($aStaticMap); $aMap = array_map(array($oHelper, 'EscapeColumn'), $aMap); $sSql = 'SELECT %s FROM %s WHERE %s'; return sprintf($sSql, implode(', ', $aMap), $sTableName, $sWhere); }
/** * @param string $sWhere * @return string */ protected function getSocialByWhere($sWhere) { $aMap = api_AContainer::DbReadKeys(CSocial::GetStaticMap()); $aMap = array_map(array($this, 'escapeColumn'), $aMap); $sSql = 'SELECT %s FROM %sawm_social WHERE %s'; return sprintf($sSql, implode(', ', $aMap), $this->Prefix(), $sWhere); }
/** * @param string $sWhere * @return string */ protected function getAccountByWhere($sWhere) { $aMap = api_AContainer::DbReadKeys(CTwofactorauth::getStaticMap()); $aMap = array_map(array($this, 'escapeColumn'), $aMap); $sSql = 'SELECT %s FROM %stwofa_accounts WHERE %s'; return sprintf($sSql, implode(', ', $aMap), $this->prefix(), $sWhere); }
/** * @param CHelpdeskUser $oHelpdeskUser * @param int $iPostId * * @return string */ public function GetAttachments(CHelpdeskUser $oHelpdeskUser, CHelpdeskThread $oHelpdeskThread) { $aMap = api_AContainer::DbReadKeys(CHelpdeskAttachment::GetStaticMap()); $aMap = array_map(array($this, 'escapeColumn'), $aMap); $sSql = 'SELECT %s FROM %sahd_attachments'; $sSql = sprintf($sSql, implode(', ', $aMap), $this->Prefix()); $aWhere = array(); if (0 < $oHelpdeskUser->IdTenant) { $aWhere[] = $this->escapeColumn('id_tenant') . ' = ' . $oHelpdeskUser->IdTenant; } $aWhere[] = $this->escapeColumn('id_helpdesk_thread') . ' = ' . $oHelpdeskThread->IdHelpdeskThread; return $sSql . ' WHERE ' . implode(' AND ', $aWhere); }
/** * @param string $sWhere * @return string */ protected function getGroupByWhere($sWhere) { $aMap = api_AContainer::DbReadKeys(CGroup::getStaticMap()); $aMap = array_map(array($this, 'escapeColumn'), $aMap); $sSql = 'SELECT %s FROM %sawm_addr_groups WHERE %s'; return sprintf($sSql, implode(', ', $aMap), $this->prefix(), $sWhere); }
/** * Returns query-string for obtaining user by specified condition. * * @param string $sWhere Specified condition. * * @return string */ protected function _getUserByWhereQuery($sWhere) { $aMap = api_AContainer::DbReadKeys(CUser::getStaticMap()); $aMap = array_map(array($this, 'escapeColumn'), $aMap); $sSql = 'SELECT %s FROM %sawm_settings WHERE %s'; return sprintf($sSql, implode(', ', $aMap), $this->prefix(), $sWhere); }