public function deleteByGroupId($groupId, $status = GHEADER_BOL_Cover::STATUS_ACTIVE)
{
$example = new OW_Example();
$example->andFieldEqual('groupId', $groupId);
$example->andFieldEqual('status', $status);
return $this->deleteByExample($example);
}
public function findByGenderAndAccountType($accountType, $gender)
{
$example = new OW_Example();
$example->andFieldEqual(self::ACCOUNT_TYPE, $accountType);
$example->andFieldEqual(self::GENDER_VALUE, $gender);
return $this->findObjectByExample($example);
}
/**
*
* @param int $placeId
* @param int $entityId
* @return BOL_PlaceScheme
*/
public function findPlaceScheme($placeId, $entityId)
{
$example = new OW_Example();
$example->andFieldEqual('placeId', $placeId);
$example->andFieldEqual('entityId', $entityId);
return $this->findObjectByExample($example);
}
public function deleteActivity($questionId, $activityType, $activityId)
{
$example = new OW_Example();
$example->andFieldEqual('questionId', $questionId);
$example->andFieldEqual('activityType', $activityType);
$example->andFieldEqual('activityId', $activityId);
return $this->deleteByExample($example);
}
public function findUsersetting($userId, $key)
{
$example = new OW_Example();
$example->andFieldEqual('userId', $userId);
if (!empty($key)) {
$example->andFieldEqual('key', $key);
}
return $this->findObjectByExample($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);
}
/**
* find User Token
*
* @param array $params
* @return YNSOCIALBRIDGE_BOL_Token
*/
public function findUserToken($params = array())
{
if (!$params) {
return null;
}
$example = new OW_Example();
$example->andFieldEqual('service', $params['service']);
$example->andFieldEqual('userId', $params['userId']);
return $this->findObjectByExample($example);
}
public function deleteDataItem($entityTypeId, $entityId)
{
if (empty($entityTypeId) || empty($entityId)) {
return FALSE;
}
$example = new OW_Example();
$example->andFieldEqual(self::ENTITY_TYPE_ID, $entityTypeId);
$example->andFieldEqual(self::ENTITY_ID, $entityId);
return $this->deleteByExample($example);
}
public function unmark($userId, $markUserId)
{
if (empty($userId) || empty($markUserId)) {
return NULL;
}
$example = new OW_Example();
$example->andFieldEqual(self::USER_ID, $userId);
$example->andFieldEqual(self::MARK_USER_ID, $markUserId);
return $this->deleteByExample($example);
}
/**
* find User Statistic
*
* @param array $params
* @return YNSOCIALBRIDGE_BOL_Statistic
*/
public function getTotalInviteOfDay($params = array())
{
if (!$params) {
return null;
}
$example = new OW_Example();
$example->andFieldEqual('uid', $params['uid']);
$example->andFieldEqual('date', $params['date']);
$example->andFieldEqual('service', $params['service']);
return $this->findObjectByExample($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 findListByCategoryId($id)
{
$example = new OW_Example();
$example->andFieldEqual('categoryId', $id);
$example->setOrder('`order` ASC');
return $this->findListByExample($example);
}
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 sendExpiryEmail()
{
$config = OW::getConfig();
$subject = OW::getLanguage()->text('sponsors', 'reminder_subject');
$content = OW::getLanguage()->text('sponsors', 'reminder_content');
$sitemail = $config->getValue('base', 'site_email');
$sitename = $config->getValue('base', 'site_name');
$mails = array();
$example = new OW_Example();
$example->andFieldEqual('status', 1);
$example->andFieldGreaterThan('price', 0);
$sponsors = $this->dao->findListByExample($example);
foreach ($sponsors as $sponsor) {
$cutoffDay = $sponsor->validity - (int) OW::getConfig()->getValue('sponsors', 'cutoffDay');
if ((time() - $sponsor->timestamp) / 86400 > $cutoffDay && $cutoffDay > 0) {
$mail = OW::getMailer()->createMail();
$mail->addRecipientEmail($sponsor->email);
$mail->setSender($sitemail, $sitename);
$mail->setSubject($subject);
$mail->setHtmlContent($content);
$textContent = strip_tags(preg_replace("/\\<br\\s*[\\/]?\\s*\\>/", "\n", $content));
$mail->setTextContent($textContent);
$mails[] = $mail;
}
}
if (count($mails) > 0) {
OW::getMailer()->addListToQueue($mails);
}
}
public function findByGroup($groupId)
{
$example = new OW_Example();
$example->andFieldEqual('groupId', $groupId);
$example->setOrder('timestamp DESC');
return $this->findListByExample($example);
}
public function findBySectionName($sectionName)
{
if ($sectionName === null || mb_strlen($sectionName) === 0) {
return null;
}
$example = new OW_Example();
$example->andFieldEqual('name', $sectionName);
return $this->findObjectByExample($example);
}
/**
* 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);
}
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;
}
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 Config
*
* @param string $name
* @return YNSOCIALBRIDGE_BOL_Apisetting
*/
public function getConfig($name)
{
if (!$name) {
return null;
}
$example = new OW_Example();
$example->andFieldEqual('apiName', $name);
return $this->findObjectByExample($example);
}
public function markUnfeatured($videoId)
{
if (!$videoId) {
return false;
}
$example = new OW_Example();
$example->andFieldEqual('videoId', $videoId);
$this->deleteByExample($example);
return true;
}
public function isDuplicate($category)
{
$example = new OW_Example();
$example->andFieldEqual('name', $category);
if (count($this->findObjectByExample($example)) > 0) {
return true;
} else {
return false;
}
}
public function deleteByUserId($userId)
{
$example = new OW_Example();
$example->andFieldEqual('userId', $userId);
$this->deleteByExample($example);
$example = new OW_Example();
$example->andFieldEqual('oppUserId', $userId);
$this->deleteByExample($example);
return true;
}
/**
* Finds user avatar by userId
*
* @param int $userId
* @return BOL_Avatar
*/
public function findByUserId($userId)
{
$userId = intval($userId);
if (empty($this->cachedItems[$userId])) {
$example = new OW_Example();
$example->andFieldEqual('userId', $userId);
$example->setLimitClause(0, 1);
$this->cachedItems[$userId] = $this->findObjectByExample($example);
}
return $this->cachedItems[$userId];
}
public function getItemCategoryId($eventId)
{
$example = new OW_Example();
$example->andFieldEqual('eventId', $eventId);
$categories = $this->findListByExample($example);
if (count($categories) > 0) {
return $categories;
} else {
return false;
}
}
public function getCompletedFeaturesCount($userId, array $features)
{
if (empty($userId) || count($features) === 0) {
return NULL;
}
$perDay = OW::getConfig()->getValue('profileprogressbar', 'per_day');
$example = new OW_Example();
$example->andFieldEqual(self::USER_ID, $userId);
$example->andFieldInArray(self::ENTITY_TYPE, $features);
$example->andFieldBetween(self::TIME_STAMP, strtotime("-{$perDay} day"), time());
return $this->countByExample($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 getVideoCategories($videoId)
{
$example = new OW_Example();
$example->andFieldEqual('videoId', $videoId);
$categories = $this->findListByExample($example);
$list = array();
foreach ($categories as $category) {
$list[] = IVIDEO_BOL_CategoryService::getInstance()->getCategoryName($category->categoryId);
}
if (count($list) > 0) {
return $list;
} else {
return false;
}
}
/**
* 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 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;
}
