public function findPlanList($exclude) { $example = new OW_Example(); if (!empty($exclude)) { $example->andFieldNotInArray('id', $exclude); } return $this->findListByExample($example); }
/** * get All invitations with userId * * @param OW_Example * * @return array YNCONTACTIMPORTER_BOL_Invitation */ public function getInvitationByUserId($params = array()) { $example = new OW_Example(); if (isset($params['count']) && $params['count']) { $example->setLimitClause($params['first'], $params['count']); } if (isset($params['userId'])) { $example->andFieldEqual('userId', $params['userId']); } if (isset($params['provider'])) { $example->andFieldEqual('provider', $params['provider']); } else { $example->andFieldEqual('isUsed', 0); } if (isset($params['userId']) && empty($params['provider'])) { // check queues $emails = YNCONTACTIMPORTER_BOL_PendingService::getInstance()->getAllPendingEmailsByUserId(array('userId' => $params['userId'])); $socials = YNSOCIALBRIDGE_BOL_QueueService::getInstance()->getQueuesByUserId(array('userId' => $params['userId'], 'type' => 'sendInvite')); $friendIds = array(); foreach ($emails as $email) { $friendIds[] = $email['recipientEmail']; } foreach ($socials as $social) { $arr_id = $arr = explode('/', $social['id']); $friendIds[] = $arr_id[0]; } if ($friendIds) { $example->andFieldNotInArray('friendId', $friendIds); } } if (isset($params['search']) && $params['search']) { $example->andFieldLike('friendId', "%" . $params['search'] . "%"); } $example->setOrder("`sentTime` DESC"); return $this->findListByExample($example); }
/** * Return search result item count * * @param int $listId * @param int $first * @param int $count * return array */ public function getUserIdList($listId, $first, $count, $excludeList = array()) { $example = new OW_Example(); $example->andFieldEqual('searchId', (int) $listId); $example->setOrder(' sortOrder '); $example->setLimitClause($first, $count); if (!empty($excludeList)) { $example->andFieldNotInArray('userId', $excludeList); } $results = BOL_SearchResultDao::getInstance()->findListByExample($example); $userIdList = array(); foreach ($results as $result) { $userIdList[] = $result->userId; } return $userIdList; }
public function findPhotoListByUploadKey($uploadKey, $exclude, $status = null) { $example = new OW_Example(); $example->andFieldEqual('uploadKey', $uploadKey); if ($status !== null) { $example->andFieldEqual('status', $status); } if ($exclude && is_array($exclude)) { $example->andFieldNotInArray('id', $exclude); } $example->setOrder('`id` DESC'); return $this->findListByExample($example); }
/** * Get the list of user albums * * @param int $userId * @param int $page * @param int $limit * @return array of PHOTO_BOL_PhotoAlbum */ public function getUserAlbumList($userId, $page, $limit, $exclude) { $first = ($page - 1) * $limit; $example = new OW_Example(); $example->andFieldEqual('userId', $userId); if ($exclude) { $example->andFieldNotInArray('id', $exclude); } $example->setLimitClause($first, $limit); return $this->findListByExample($example); }
public function findInvitationCount($userId, $viewed = null, $exclude = null) { $example = new OW_Example(); $example->andFieldEqual('userId', $userId); if ($viewed !== null) { $example->andFieldEqual('viewed', (int) (bool) $viewed); } if ($exclude) { $example->andFieldNotInArray('id', $exclude); } return $this->countByExample($example); }
public function findPhotoListByUploadKey($uploadKey, $exclude) { $example = new OW_Example(); $example->andFieldEqual('uploadKey', $uploadKey); if ($exclude && is_array($exclude)) { $example->andFieldNotInArray('id', $exclude); } $example->setOrder('`addDatetime` DESC'); return $this->findListByExample($example); }