/** * @param int $affiliateId * @return array */ public function findListByAffiliateId($affiliateId) { $example = new OW_Example(); $example->andFieldEqual('affiliateId', $affiliateId); $example->setOrder('`paymentDate` 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); }
public function findList($count) { $example = new OW_Example(); $example->setLimitClause(0, $count); $example->setOrder('timeStamp DESC'); return $this->findListByExample($example); }
public function findListByCategoryId($id) { $example = new OW_Example(); $example->andFieldEqual('categoryId', $id); $example->setOrder('`order` ASC'); return $this->findListByExample($example); }
public function findByGroup($groupId) { $example = new OW_Example(); $example->andFieldEqual('groupId', $groupId); $example->setOrder('timestamp DESC'); return $this->findListByExample($example); }
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); }
/** * 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 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; }
/** * Returns list of packs for account type * * @param $accountTypeId * @return array */ public function getAllPacks($accountTypeId = null) { $example = new OW_Example(); if ($accountTypeId) { $example->andFieldEqual('accountTypeId', $accountTypeId); } $example->setOrder('`price` ASC'); 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 findHotList($start = 0, $count = null) { $example = new OW_Example(); $example->setOrder("`timestamp` DESC"); if ($count !== null) { $example->setLimitClause($start, $count); } return $this->findListByExample($example); }
/** * * @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 getAllSteps($page, $onlyActive = 1) { $example = new OW_Example(); if ($page != 'all') { $example->andFieldEqual('page', $page); } if ($onlyActive == 1) { $example->andFieldEqual('active', 1); } $example->setOrder('`page` ASC,`order` ASC'); return $this->findListByExample($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; }
public function getSponsors($count, $forAdmin = 1, $checkValidty = 1) { $example = new OW_Example(); if ($forAdmin != 1) { $example->andFieldEqual('status', 1); } $example->setOrder('price DESC,timestamp DESC'); $sponsors = $this->findListByExample($example); $userService = BOL_UserService::getInstance(); $allSponsors = array(); $imagePath = OW::getPluginManager()->getPlugin('sponsors')->getUserFilesUrl(); foreach ($sponsors as $sponsor) { $id = $sponsor->id; if ($checkValidty) { if ((time() - $sponsor->timestamp) / 86400 > $sponsor->validity) { $this->disapprove($id); continue; } } $allSponsors[$id]['id'] = $id; $allSponsors[$id]['name'] = $sponsor->name; $allSponsors[$id]['email'] = $sponsor->email; $allSponsors[$id]['website'] = $sponsor->website; $allSponsors[$id]['image'] = $imagePath . $sponsor->image; $allSponsors[$id]['status'] = $sponsor->status; $allSponsors[$id]['price'] = $sponsor->price; $allSponsors[$id]['userId'] = $sponsor->userId; $allSponsors[$id]['userName'] = $userService->getDisplayName($sponsor->userId); $allSponsors[$id]['userUrl'] = $userService->getUserUrl($sponsor->userId); $allSponsors[$id]['timestamp'] = $sponsor->timestamp; $allSponsors[$id]['validity'] = $sponsor->validity; if ($sponsor->status == 1) { $allSponsors[$id]['activityUrl'] = OW::getRouter()->urlFor('SPONSORS_CTRL_Admin', 'disapprove', array('id' => $id)); } else { $allSponsors[$id]['activityUrl'] = OW::getRouter()->urlFor('SPONSORS_CTRL_Admin', 'approve', array('id' => $id)); } $allSponsors[$id]['editUrl'] = OW::getRouter()->urlFor('SPONSORS_CTRL_Admin', 'edit', array('id' => $id)); $allSponsors[$id]['deleteUrl'] = OW::getRouter()->urlFor('SPONSORS_CTRL_Admin', 'delete', array('id' => $id)); } if ($count > 0) { $allSponsors = array_slice($allSponsors, 0, $count); } return $allSponsors; }
public function findListByIdList($list) { $ex = new OW_Example(); $ex->andFieldInArray('id', $list); $ex->andFieldEqual('privacy', 'everybody'); $ex->setOrder('timestamp DESC'); return $this->findListByExample($ex); }
public function getList() { $example = new OW_Example(); $example->setOrder('`order` ASC'); return $this->findListByExample($example); }
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 findList($first, $count, $admin = false) { if ($admin === true) { $ex = new OW_Example(); $ex->setOrder('joinStamp DESC')->setLimitClause($first, $count); return $this->findListByExample($ex); } $queryParts = $this->getUserQueryFilter("u", "id", array("method" => "BOL_UserDao::findList")); $query = "SELECT `u`.*\n \t\tFROM `{$this->getTableName()}` as `u`\n \t\t{$queryParts["join"]}\n\n WHERE {$queryParts["where"]}\n \t\tORDER BY " . (!empty($queryParts["order"]) ? $queryParts["order"] . ", " : "") . " `u`.`joinStamp` DESC\n \t\tLIMIT ?,? "; $cacheLifeTime = 0; $tag = array(); // cached latest list query //TODO: create cache for other pages, now cached only first page. if ($first == 0) { //TODO: Enable cache $cacheLifeTime = 0; $tag = array(self::CACHE_TAG_LATEST_LIST, self::CACHE_TAG_ALL_USER_LIST); } return $this->dbo->queryForObjectList($query, $this->getDtoClassName(), array($first, $count), $cacheLifeTime, $tag); }
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 findSortedSectionList() { $example = new OW_Example(); $example->setOrder('sortOrder'); 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 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 $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); }
/** * * @param int $userId * @param string $entityId * @return array<MAILBOX_BOL_FileUpload> */ public function findUploadFileList($entityId) { if (empty($entityId)) { return array(); } $example = new OW_Example(); $example->andFieldEqual('entityId', $entityId); $example->setOrder('id'); return $this->findListByExample($example); }
public function findAll($cacheLifeTime = 0, $tags = array()) { $example = new OW_Example(); $example->setOrder('id'); return $this->findListByExample($example, 3600 * 24, array(BOL_AuthorizationActionDao::CACHE_TAG_AUTHORIZATION, OW_CacheManager::TAG_OPTION_INSTANT_LOAD)); }
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); }