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);
}
