/**
* Get Auth result
*
* @param \Phire\Table\UserTypes $type
* @return string
*/
public function getAuthResult($type)
{
$result = null;
if (!$this->isValid()) {
$result = $this->getResultMessage();
} else {
$user = $this->getUser();
$session = Table\UserSessions::findBy(array('user_id' => $user['id']));
if (!$type->multiple_sessions && isset($session->id)) {
$result = 'Multiple sessions are not allowed. Someone is already logged on from ' . $session->ip . '.';
} else {
if (!$type->mobile_access && \Pop\Web\Mobile::isMobileDevice()) {
$result = 'Mobile access is not allowed.';
} else {
if (!$user['verified']) {
$result = 'The user is not verified.';
} else {
if ($type->id != $user['type_id']) {
$userType = Table\UserTypes::findById($user['type_id']);
if (isset($userType->id) && !$userType->global_access) {
$result = 'The user is not allowed in this area.';
}
}
}
}
}
}
return $result;
}
/**
* Method to determine the mobile device
*
* @param string $mobile
* @return string
*/
public static function getDevice($mobile = null)
{
$session = Session::getInstance();
if (null !== $mobile) {
$force = $mobile;
if ($force == 'clear') {
unset($session->mobile);
} else {
$session->mobile = $force;
}
}
if (!isset($session->mobile)) {
$device = Mobile::getDevice();
if (null !== $device) {
$device = strtolower($device);
if ($device == 'android' || $device == 'windows') {
$device .= Mobile::isTabletDevice() ? '-tablet' : '-phone';
}
}
} else {
$device = $session->mobile;
}
return $device;
}
/**
* Get calendar by content type ID
*
* @param int $tid
* @param boolean $time
* @return View
*/
public function getById($tid, $time = false)
{
if ($this->force_list || Mobile::isMobileDevice() && $this->force_list_mobile) {
$calendar = new View(__DIR__ . '/../../view/calendar-list.phtml');
} else {
$calendar = new View(__DIR__ . '/../../view/calendar.phtml');
}
$sql = Table\Content::sql();
$sql2 = clone $sql;
$sql->select(['id' => DB_PREFIX . 'content.id', 'type_id' => DB_PREFIX . 'content.type_id', 'title' => DB_PREFIX . 'content.title', 'uri' => DB_PREFIX . 'content.uri', 'slug' => DB_PREFIX . 'content.slug', 'status' => DB_PREFIX . 'content.status', 'roles' => DB_PREFIX . 'content.roles', 'publish' => DB_PREFIX . 'content.publish', 'expire' => DB_PREFIX . 'content.expire']);
$sql2->select(['id' => DB_PREFIX . 'content.id', 'type_id' => DB_PREFIX . 'content.type_id', 'title' => DB_PREFIX . 'content.title', 'uri' => DB_PREFIX . 'content.uri', 'slug' => DB_PREFIX . 'content.slug', 'status' => DB_PREFIX . 'content.status', 'roles' => DB_PREFIX . 'content.roles', 'publish' => DB_PREFIX . 'content.publish', 'expire' => DB_PREFIX . 'content.expire']);
// YYYY-MM
if (null !== $this->date && strlen($this->date) == 7 && strpos($this->date, '-') !== false) {
$dateAry = explode('-', $this->date);
$start = $dateAry[0] . '-' . $dateAry[1] . '-01 00:00:00';
$end = $dateAry[0] . '-' . $dateAry[1] . '-' . date('t', strtotime($dateAry[0] . '-' . $dateAry[1] . '-01')) . ' 23:59:59';
} else {
$y = date('Y');
$m = date('m');
$this->date = $y . '-' . $m;
$start = $y . '-' . $m . '-01 00:00:00';
$end = $y . '-' . $m . '-' . date('t', strtotime($y . '-' . $m . '-01')) . ' 23:59:59';
}
$sql->select()->where('type_id = :type_id')->where('status = :status')->where('publish >= :publish1')->where('publish <= :publish2');
$sql->select()->orderBy('publish', 'ASC');
$sql2->select()->where('type_id = :type_id')->where('status = :status');
$sql2->select()->orderBy('publish', 'ASC');
$params = ['type_id' => $tid, 'status' => 1, 'publish' => [$start, $end]];
$params2 = ['type_id' => $tid, 'status' => 1];
$monthOptions = $this->getMonthOptions();
$content = Table\Content::execute((string) $sql, $params)->rows();
$allContent = Table\Content::execute((string) $sql2, $params2)->rows();
$events = [];
$months = [];
foreach ($content as $c) {
$day = substr($c->publish, 0, strpos($c->publish, ' '));
$mon = substr($day, 0, strrpos($day, '-'));
if (!isset($events[$day])) {
$events[$day] = [];
}
if (!in_array($mon, $monthOptions)) {
$months[] = $mon;
}
$roles = unserialize($c->roles);
if (count($roles) == 0 || null !== $this->user_role_id && in_array($this->user_role_id, $roles)) {
$events[$day][] = $c;
}
if (null !== $c->expire) {
$start = (int) substr($day, strrpos($day, '-') + 1) + 1;
$expireDay = substr($c->expire, 0, strpos($c->expire, ' '));
$expireTime = substr($c->expire, strpos($c->expire, ' ') + 1);
$end = (int) substr($expireDay, strrpos($expireDay, '-') + 1);
$expireMonth = substr($expireDay, 0, strrpos($expireDay, '-'));
$daysBetween = strtotime($expireDay) - strtotime($day);
$hoursBetween = strtotime($expireTime) - strtotime('00:00:00');
if ($daysBetween > 86400 || $daysBetween == 86400 && $hoursBetween >= 21600) {
if (!in_array($expireMonth, $monthOptions)) {
$months[] = $expireMonth;
}
for ($i = $start; $i <= $end; $i++) {
if ($i <= $calendar->numOfDays) {
$expDay = $calendar->date . '-' . (strlen($i) == 1 ? '0' . $i : $i);
if (!isset($events[$expDay])) {
$events[$expDay] = [];
}
if (count($roles) == 0 || null !== $this->user_role_id && in_array($this->user_role_id, $roles)) {
$events[$expDay][] = $c;
}
}
}
}
}
}
foreach ($allContent as $c) {
$day = substr($c->publish, 0, strpos($c->publish, ' '));
$mon = substr($day, 0, strrpos($day, '-'));
if (!in_array($mon, $monthOptions)) {
$months[] = $mon;
}
if (null !== $c->expire) {
$expireDay = substr($c->expire, 0, strpos($c->expire, ' '));
$expireTime = substr($c->expire, strpos($c->expire, ' ') + 1);
$expireMonth = substr($expireDay, 0, strrpos($expireDay, '-'));
$daysBetween = strtotime($expireDay) - strtotime($day);
$hoursBetween = strtotime($expireTime) - strtotime('00:00:00');
if ($daysBetween > 86400 || $daysBetween == 86400 && $hoursBetween >= 21600) {
if (!in_array($expireMonth, $monthOptions)) {
$months[] = $expireMonth;
}
}
}
}
if (!$this->show_all) {
foreach ($monthOptions as $month => $option) {
if (!in_array($month, $months)) {
unset($monthOptions[$month]);
}
}
}
if (!array_key_exists($this->date, $monthOptions)) {
reset($monthOptions);
$this->date = key($monthOptions);
$sql = Table\Content::sql();
$sql->select(['id' => DB_PREFIX . 'content.id', 'type_id' => DB_PREFIX . 'content.type_id', 'title' => DB_PREFIX . 'content.title', 'uri' => DB_PREFIX . 'content.uri', 'slug' => DB_PREFIX . 'content.slug', 'status' => DB_PREFIX . 'content.status', 'roles' => DB_PREFIX . 'content.roles', 'publish' => DB_PREFIX . 'content.publish', 'expire' => DB_PREFIX . 'content.expire']);
$dateAry = explode('-', $this->date);
$start = $dateAry[0] . '-' . $dateAry[1] . '-01 00:00:00';
$end = $dateAry[0] . '-' . $dateAry[1] . '-' . date('t', strtotime($dateAry[0] . '-' . $dateAry[1] . '-01')) . ' 23:59:59';
$sql->select()->where('type_id = :type_id')->where('status = :status')->where('publish >= :publish1')->where('publish <= :publish2');
$sql->select()->orderBy('publish', 'ASC');
$params = ['type_id' => $tid, 'status' => 1, 'publish' => [$start, $end]];
$content = Table\Content::execute((string) $sql, $params)->rows();
$events = [];
foreach ($content as $c) {
$day = substr($c->publish, 0, strpos($c->publish, ' '));
$mon = substr($day, 0, strrpos($day, '-'));
if (!isset($events[$day])) {
$events[$day] = [];
}
$roles = unserialize($c->roles);
if (count($roles) == 0 || null !== $this->user_role_id && in_array($this->user_role_id, $roles)) {
$events[$day][] = $c;
}
if (null !== $c->expire) {
$start = (int) substr($day, strrpos($day, '-') + 1) + 1;
$expireDay = substr($c->expire, 0, strpos($c->expire, ' '));
$expireTime = substr($c->expire, strpos($c->expire, ' ') + 1);
$end = (int) substr($expireDay, strrpos($expireDay, '-') + 1);
$expireMonth = substr($expireDay, 0, strrpos($expireDay, '-'));
$daysBetween = strtotime($expireDay) - strtotime($day);
$hoursBetween = strtotime($expireTime) - strtotime('00:00:00');
if ($daysBetween > 86400 || $daysBetween == 86400 && $hoursBetween >= 21600) {
for ($i = $start; $i <= $end; $i++) {
if ($i <= $calendar->numOfDays) {
$expDay = $calendar->date . '-' . (strlen($i) == 1 ? '0' . $i : $i);
if (!isset($events[$expDay])) {
$events[$expDay] = [];
}
if (count($roles) == 0 || null !== $this->user_role_id && in_array($this->user_role_id, $roles)) {
$events[$expDay][] = $c;
}
}
}
}
}
}
}
$calendar->date = $this->date;
$calendar->time = $time;
$calendar->weekdays = $this->weekdays;
$calendar->day_format = $this->day_format;
$calendar->numOfWeeks = $this->getNumberOfWeeks();
$calendar->startDay = date('D', strtotime($this->date));
$calendar->numOfDays = date('t', strtotime($this->date));
$calendar->monthOptions = $monthOptions;
$calendar->events = $events;
return $calendar;
}