public function findList($count)
{
$example = new OW_Example();
$example->setLimitClause(0, $count);
$example->setOrder('timeStamp DESC');
return $this->findListByExample($example);
}
/**
* get top inviters
* @param array $params
* @return array YNCONTACTIMPORTER_BOL_Statistic
*/
public function getTopInviters($params = array())
{
$example = new OW_Example();
$example->setLimitClause(0, 10);
$example->setOrder("`totalSent` DESC");
return $this->findListByExample($example);
}
/**
* Finds user trial plan usage by user Id
*
* @param int $userId
* @return MEMBERSHIP_BOL_MembershipUserTrial
*/
public function findByUserId($userId)
{
$example = new OW_Example();
$example->andFieldEqual('userId', $userId);
$example->setLimitClause(0, 1);
return $this->findObjectByExample($example);
}
public function find($type, $entityId, $userId)
{
$ex = new OW_Example();
$ex->andFieldEqual('type', $type)->andFieldEqual('entityId', $entityId)->andFieldEqual('userId', $userId);
$ex->setLimitClause(0, 1);
return $this->findObjectByExample($ex);
}
public function findByUserId($userId, $first, $count)
{
$example = new OW_Example();
$example->andFieldEqual(self::USER_ID, (int) $userId);
$example->setLimitClause($first, $count);
return $this->findListByExample($example);
}
public function getId($moderatorId, $groupId)
{
$ex = new OW_Example();
$ex->andFieldEqual('moderatorId', $moderatorId);
$ex->andFieldEqual('groupId', $groupId);
$ex->setLimitClause(1, 1);
return $this->findIdByExample($ex);
}
public function getGoalLatestDonations($goalId, $limit)
{
$example = new OW_Example();
$example->andFieldEqual('goalId', $goalId);
$example->setOrder('`donationStamp` DESC');
$example->setLimitClause(0, $limit);
return $this->findListByExample($example);
}
/**
* @param $userId
* @param $page
* @param $limit
* @return array|mixed
*/
public function findUserGuests($userId, $page, $limit)
{
$first = ($page - 1) * $limit;
$example = new OW_Example();
$example->andFieldEqual('userId', $userId);
$example->setLimitClause($first, $limit);
$example->setOrder('`visitTimestamp` DESC');
return $this->findListByExample($example);
}
public function getUpdatedActions()
{
$ex = new OW_Example();
$ex->andFieldEqual(PRIVACY_BOL_CronDao::IN_PROCESS, 0);
$ex->setOrder(PRIVACY_BOL_CronDao::TIMESTAMP);
$ex->setLimitClause(0, 500);
$objectList = $this->findListByExample($ex);
return $objectList;
}
/**
* Finds user last action log
*
* @param int $userId
* @param int $actionId
*/
public function findLast($userId, $actionId)
{
$example = new OW_Example();
$example->andFieldEqual('userId', $userId);
$example->andFieldEqual('actionId', $actionId);
$example->setOrder('`logTimestamp` DESC');
$example->setLimitClause(0, 1);
return $this->findObjectByExample($example);
}
public function findHotList($start = 0, $count = null)
{
$example = new OW_Example();
$example->setOrder("`timestamp` DESC");
if ($count !== null) {
$example->setLimitClause($start, $count);
}
return $this->findListByExample($example);
}
public function findList($optionId, $limit = null)
{
$example = new OW_Example();
$example->andFieldEqual('optionId', $optionId);
if (!empty($limit)) {
$example->setLimitClause(0, $limit);
}
$example->setOrder('timeStamp DESC');
return $this->findListByExample($example);
}
public function findImages($plugin, $userId = null, $first, $count)
{
$ex = new OW_Example();
$ex->andFieldEqual('plugin', $plugin);
if ($userId !== null && intval($userId) > 0) {
$ex->andFieldEqual('userId', $userId);
}
$ex->setLimitClause($first, $count)->setOrder('stamp DESC');
return $this->findListByExample($ex);
}
/**
*
* @param array $entityTypes
* @return array
*/
public function findByEntityTypeList($entityTypes, array $limit = null)
{
$example = new OW_Example();
$example->andFieldInArray("entityType", $entityTypes);
if (!empty($limit)) {
$example->setLimitClause($limit[0], $limit[1]);
}
$example->setOrder("timeStamp DESC");
return $this->findListByExample($example);
}
/**
* find All Provider
*
* @param array $params
* @return array YNCONTACTIMPORTER_BOL_Provider
*/
public function getAllProviders($params = array())
{
$example = new OW_Example();
if (isset($params['limit'])) {
$example->setLimitClause(0, $params['limit']);
}
if (isset($params['enable'])) {
$example->andFieldEqual('enable', $params['enable']);
}
$example->setOrder("`order`");
return $this->providerDao->getAllProviders($example);
}
public function processScheduler()
{
/**
* following step to speed up & beat performance
* 1. check album limit
* 2. check quota limit
* 3. get nodes of this schedulers
* 4. get all items of current schedulers.
* 5. process each node
* 5.1 check required quota
* 5.2 fetch data to pubic file
* 5.3 store to file model
* 6. check status of schedulers, if scheduler is completed == (remaining == 0)
* 6.1 udpate feed and message.
*/
/**
* Unlimited time.
*/
set_time_limit(0);
/**
* default 20
* @var int
*/
$configs = OW::getConfig()->getValues('ynmediaimporter');
$limitUserPerCron = $configs['number_photo'] ? intval($configs['number_photo']) : 20;
/**
* default 20
* @var int
*/
$limitQueuePerCron = $configs['number_queue'] ? intval($configs['number_queue']) : 20;
/**
* process number queue.
*/
/**
* get scheduler from tables data.
*/
$example = new OW_Example();
$example->andFieldLessThan('status', '3');
$example->setOrder('last_run');
$example->setLimitClause($first, $count)->setLimitClause(0, $limitQueuePerCron);
$schedulers = YNMEDIAIMPORTER_BOL_SchedulerDao::getInstance()->findListByExample($example);
foreach ($schedulers as $scheduler) {
Ynmediaimporter::processScheduler($scheduler, 0, $limitUserPerCron, 1, 1);
}
echo "success!";
exit(0);
}
public function findUserVideos($userId, $start, $offset)
{
$clipDao = VIDEO_BOL_ClipDao::getInstance();
$example = new OW_Example();
$example->andFieldEqual('status', 'approved');
$example->andFieldEqual('userId', $userId);
$example->setOrder('`addDatetime` DESC');
$example->setLimitClause($start, $offset);
$list = $clipDao->findListByExample($example);
$out = array();
foreach ($list as $video) {
$id = $video->id;
$videoThumb = VIDEO_BOL_ClipService::getInstance()->getClipThumbUrl($id);
$out[$id] = array('id' => $id, 'embed' => $video->code, 'title' => UTIL_String::truncate($video->title, 65, ' ...'), 'description' => UTIL_String::truncate($video->description, 130, ' ...'), 'thumb' => $videoThumb == 'undefined' ? null : $videoThumb, 'date' => UTIL_DateTime::formatDate($video->addDatetime), 'permalink' => OW::getRouter()->urlForRoute('view_clip', array('id' => $id)));
$out[$id]['oembed'] = json_encode(array('type' => 'video', 'thumbnail_url' => $out[$id]['thumb'], 'html' => $out[$id]['embed'], 'title' => $out[$id]['title'], 'description' => $out[$id]['description']));
}
return $out;
}
/**
* 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);
}
public function isDocumentUriUnique($uri)
{
$ex = new OW_Example();
$ex->andFieldEqual('uri', $uri);
$ex->setLimitClause(0, 1);
return $this->findObjectByExample($ex) === null;
}
public function findUserAlbums($userId, $start, $offset)
{
if (!$this->isActive()) {
return null;
}
$service = PHOTO_BOL_PhotoAlbumService::getInstance();
$albumDao = PHOTO_BOL_PhotoAlbumDao::getInstance();
$example = new OW_Example();
$example->andFieldEqual('userId', $userId);
$example->setOrder('createDatetime DESC');
$example->setLimitClause($start, $offset);
$albumList = $albumDao->findListByExample($example);
$albumListIds = array();
foreach ($albumList as $album) {
$albumListIds[] = $album->id;
}
$covers = $service->getAlbumCoverForList($albumIdList);
$out = array();
foreach ($albumList as $album) {
$out[] = array('id' => $album->id, 'cover' => $covers[$album->id], 'name' => $album->name);
}
return $out;
}
public function findVisibleNotDeletableSection()
{
$example = new OW_Example();
$example->andFieldEqual('isHidden', 0);
$example->andFieldEqual('isDeletable', 0);
$example->andFieldNotEqual('name', 'about_my_match');
$example->setOrder(' sortOrder ASC ');
$example->setLimitClause(0, 1);
return $this->findObjectByExample($example);
}
public function findAllLimited($first = null, $count = null)
{
$example = new OW_Example();
$example->setOrder(" id DESC ");
if ($first != null && $count != null) {
$example->setLimitClause($first, $count);
}
return $this->findListByExample($example);
}
public function findListAfterAvatarId($avatarId, $count, $includes = true)
{
$avatar = $this->findLastByAvatarId($avatarId);
if ($avatar === null) {
return array();
}
$example = new OW_Example();
$example->andFieldEqual("userId", $avatar->userId);
if ($includes) {
$example->andFieldLessOrEqual("timeStamp", $avatar->timeStamp);
} else {
$example->andFieldLessThan("timeStamp", $avatar->timeStamp);
}
$example->setOrder("`timeStamp` DESC");
$example->setLimitClause(0, $count);
return $this->findListByExample($example);
}
/**
*
* @param int $avatarId
* @return UAVATARS_BOL_Avatar
*/
public function findLastByAvatarId($avatarId)
{
$example = new OW_Example();
$example->andFieldEqual('avatarId', $avatarId);
$example->setOrder('timeStamp DESC');
$example->setLimitClause(0, 1);
return $this->findObjectByExample($example);
}
/**
* @param int $count
* @return array
*/
public function getNextUrlList($count)
{
$example = new OW_Example();
$example->andFieldEqual(self::STATUS, 0);
$example->setLimitClause(0, $count);
return $this->findListByExample($example);
}
public function findUserPostListByPeriod($id, $lb, $ub, $first, $count)
{
if ($first < 0) {
$first = 0;
}
if ($count < 0) {
$count = 1;
}
$ex = new OW_Example();
$ex->andFieldEqual('authorId', $id);
$ex->andFieldBetween('timestamp', $lb, $ub);
$ex->andFieldEqual('isDraft', 0);
$ex->setOrder('`timestamp` DESC');
$ex->setLimitClause($first, $count);
return $this->findListByExample($ex);
}
public function findIdByExample(OW_Example $example, $cacheLifeTime = 0, $tags = array())
{
if ($example === null) {
throw new InvalidArgumentException('argument must not be null');
}
$example->setLimitClause(0, 1);
$sql = 'SELECT `id` FROM ' . $this->getTableName() . $example;
return $this->dbo->queryForColumn($sql, array(), $cacheLifeTime, $tags);
}
/**
* 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 getNextPhoto($albumId, $id)
{
if (!$id) {
return false;
}
$example = new OW_Example();
$example->andFieldEqual('albumId', $albumId);
$example->andFieldLessThan('id', $id);
$example->andFieldEqual('status', 'approved');
$example->setOrder('`id` DESC');
$example->setLimitClause(0, 1);
return $this->findObjectByExample($example);
}
/**
* @param $userId
* @return MAILBOX_BOL_Message
*/
public function findUserLastMessage($userId)
{
$example = new OW_Example();
$example->andFieldEqual('senderId', $userId);
$example->setOrder('timeStamp DESC');
$example->setLimitClause(0, 1);
return $this->findObjectByExample($example);
}
