/**
* @param CAccount $oAccount
*
* @return array|bool
*/
public function getFetchers($oAccount)
{
$mResult = false;
if ($this->oConnection->Execute($this->oCommandCreator->getFetchers($oAccount))) {
$oRow = null;
$mResult = array();
while (false !== ($oRow = $this->oConnection->GetNextRecord())) {
$oFetcher = new CFetcher($oAccount);
$oFetcher->InitByDbRow($oRow);
$mResult[] = $oFetcher;
}
}
$this->throwDbExceptionIfExist();
return $mResult;
}
/**
* @param CAccount $oAccount
*
* @return array
*/
public function FoldersOrder($oAccount)
{
$aList = array();
if ($this->oConnection->Execute($this->oCommandCreator->FoldersOrder($oAccount))) {
$oRow = $this->oConnection->GetNextRecord();
if ($oRow) {
$sOrder = $oRow->folders_order;
if (!empty($sOrder)) {
$aOrder = @json_decode($sOrder, 3);
if (is_array($aOrder) && 0 < count($aOrder)) {
$aList = $aOrder;
}
}
}
$this->oConnection->FreeResult();
}
$this->throwDbExceptionIfExist();
return $aList;
}
/**
* @param array $aIds
* @return array
*/
public function ContactIdsLinkedToGroups($aIds)
{
$aResult = array();
if ($this->oConnection->Execute($this->oCommandCreator->ContactIdsLinkedToGroups($aIds))) {
$oRow = $this->oConnection->GetNextRecord();
if ($oRow) {
$aResult[] = (int) $oRow->id_addr;
}
$this->oConnection->FreeResult();
}
return $aResult;
}
/**
* Updates a list of senders wich are considered safe to show external images coming from.
*
* @param string $iUserId User identifier.
* @param string $sEmail Email of sender wich is considered safe.
*
* @return bool
*/
public function setSafetySender($iUserId, $sEmail)
{
$bResult = false;
if ($this->oConnection->Execute($this->oCommandCreator->getSafetySenderQuery($iUserId, $sEmail))) {
$oRow = $this->oConnection->GetNextRecord();
if (!$oRow) {
$bResult = $this->oConnection->Execute($this->oCommandCreator->insertSafetySenderQuery($iUserId, $sEmail));
}
$this->oConnection->FreeResult();
}
$this->throwDbExceptionIfExist();
return $bResult;
}
/**
* @param string $sSearchDesc Default value is empty string.
* @param int $iTenantId Default value is **0**.
*
* @return int|false
*/
public function getDomainCount($sSearchDesc = '', $iTenantId = 0)
{
$iResultCount = false;
if ($this->oConnection->Execute($this->oCommandCreator->getDomainCount($sSearchDesc, $iTenantId))) {
$oRow = $this->oConnection->GetNextRecord();
if ($oRow) {
$iResultCount = (int) $oRow->domains_count;
}
$this->oConnection->FreeResult();
}
$this->throwDbExceptionIfExist();
return $iResultCount;
}
/**
* @param CSocial &$oSocial
*
* @return bool
*/
public function isSocialExists(CSocial $oSocial)
{
$bResult = false;
if ($this->oConnection->Execute($this->oCommandCreator->isSocialExists($oSocial->IdAccount, $oSocial->TypeStr))) {
$oRow = $this->oConnection->GetNextRecord();
if ($oRow) {
$bResult = 0 < (int) $oRow->social_count;
}
$this->oConnection->FreeResult();
}
$this->throwDbExceptionIfExist();
return $bResult;
}
/**
* @return array|bool
*/
private function parseGetMinDbResult()
{
$mResult = false;
$oRow = $this->oConnection->GetNextRecord();
if ($oRow && !empty($oRow->data)) {
$aData = @\json_decode($oRow->data, true);
if (is_array($aData) && 0 < count($aData)) {
$mResult = $aData;
}
}
$this->oConnection->FreeResult();
return $mResult;
}
/**
* @param string $sType
* @param string $sIdSocial
* @return string
*/
public function SocialExists($sType, $sIdSocial)
{
$bResult = false;
if ($this->oConnection->Execute($this->oCommandCreator->SocialExists($sType, $sIdSocial))) {
$oRow = $this->oConnection->GetNextRecord();
if ($oRow) {
$bResult = 0 < (int) $oRow->social_count;
}
$this->oConnection->FreeResult();
}
$this->throwDbExceptionIfExist();
return $bResult;
}
/**
* @param int $iTenantId
*
* @return array
*/
public function GetTenantDomains($iTenantId)
{
$mResult = false;
if ($this->oConnection->Execute($this->oCommandCreator->GetTenantDomains($iTenantId))) {
$oRow = null;
$mResult = array();
while (false !== ($oRow = $this->oConnection->GetNextRecord())) {
$mResult[$oRow->id_domain] = $oRow->name;
}
}
$this->throwDbExceptionIfExist();
return $mResult;
}
/**
* @param int $iIdTenant
* @param string $sSocialName
*
* @return array | false
*/
public function GetSocialByName($iIdTenant, $sSocialName)
{
$oSocial = null;
if ($this->oConnection->Execute($this->oCommandCreator->GetSocialByName($iIdTenant, $sSocialName))) {
$oRow = $this->oConnection->GetNextRecord();
if ($oRow) {
$oSocial = new CTenantSocials();
$oSocial->InitByDbRow($oRow);
}
$this->oConnection->FreeResult();
}
$this->throwDbExceptionIfExist();
return $oSocial;
}
/**
* @param int $iSubscriptionID
*
* @return array|bool
*/
public function getSubscriptionById($iSubscriptionID)
{
$mResult = false;
if ($this->oConnection->Execute($this->oCommandCreator->getSubscriptionById($iSubscriptionID))) {
$oRow = $this->oConnection->GetNextRecord();
if ($oRow && isset($oRow->id_tenant) && 0 < (int) $oRow->id_tenant) {
$oSubscription = new CSubscription((int) $oRow->id_tenant);
$oSubscription->InitByDbRow($oRow);
$mResult = $oSubscription;
}
$this->oConnection->FreeResult();
}
$this->throwDbExceptionIfExist();
return $mResult;
}
/**
* @param int $iThreadID
*
* @return array|bool
*/
public function GetOnline(CHelpdeskUser $oHelpdeskUser, $iThreadID)
{
$mResult = false;
if ($this->oConnection->Execute($this->oCommandCreator->GetOnline($oHelpdeskUser, $iThreadID, 5))) {
$oRow = null;
$mResult = array();
while (false !== ($oRow = $this->oConnection->GetNextRecord())) {
if ($oRow && isset($oRow->id_helpdesk_user) && isset($oRow->name) && isset($oRow->email)) {
if ((string) $oRow->id_helpdesk_user !== (string) $oHelpdeskUser->IdHelpdeskUser) {
$mResult[$oRow->id_helpdesk_user] = array((string) $oRow->name, (string) $oRow->email);
}
}
}
$mResult = array_values($mResult);
}
$this->throwDbExceptionIfExist();
return $mResult;
}
/**
*
* @param type $sType
* @param type $aViewAttrs
* @param type $iOffset
* @param type $iLimit
* @param type $aSearchAttrs
* @param type $sOrderBy
* @param type $iSortOrder
* @param type $aIdsOrUUIDs
* @return \AEntity
*/
public function getEntities($sType, $aViewAttrs = array(), $iOffset = 0, $iLimit = 20, $aSearchAttrs = array(), $sOrderBy = '', $iSortOrder = \ESortOrder::ASC, $aIdsOrUUIDs = array())
{
$mResult = false;
if ($aViewAttrs === null) {
$aViewAttrs = array();
} else {
if (count($aViewAttrs) === 0) {
$this->oConnection->Execute($this->oCommandCreator->getAttributesNamesByEntityType($sType));
while (false !== ($oRow = $this->oConnection->GetNextRecord())) {
$aViewAttrs[] = $oRow->name;
}
$this->oConnection->FreeResult();
}
}
if ($this->oConnection->Execute($this->oCommandCreator->getEntities($sType, $aViewAttrs, $iOffset, $iLimit, $aSearchAttrs, $sOrderBy, $iSortOrder, $aIdsOrUUIDs))) {
$oRow = null;
$mResult = array();
while (false !== ($oRow = $this->oConnection->GetNextRecord())) {
if (class_exists($sType)) {
$oEntity = call_user_func($sType . '::createInstance');
} else {
$oEntity = new \AEntity($sType);
}
$oEntity->iId = (int) $oRow->entity_id;
$oEntity->sUUID = $oRow->entity_uuid;
$oEntity->sModuleName = $oRow->entity_module;
foreach (get_object_vars($oRow) as $sKey => $mValue) {
if (strrpos($sKey, 'attr_', -5) !== false) {
$sAttrKey = substr($sKey, 5);
$oEntity->{$sAttrKey} = \CAttribute::createInstance($sAttrKey, $mValue, null, $oEntity->isEncryptedAttribute($sAttrKey), $oEntity->iId);
}
}
$mResult[] = $oEntity;
}
$this->oConnection->FreeResult();
}
$this->throwDbExceptionIfExist();
return $mResult;
}
