<?php if (! defined('ABSPATH')) exit; // Exit if accessed directly
interface SH4_Schedule_Html_View_ICommon
{
	public function getShifts();
	public function getCalendars();
	public function getEmployees();

	public function findAllCalendars();
	public function findAllEmployees();
	public function filterShifts( $shifts );
	public function filterViewTypes( $types );

	public function renderReport( $shiftsDuration, $alignRight = TRUE );

	public function renderDateLabelGrouped( $date );
}

#[AllowDynamicProperties]
class SH4_Schedule_Html_View_Common implements SH4_Schedule_Html_View_ICommon
{
	public function __construct(
		HC3_Hooks $hooks,

		HC3_Auth $auth,
		HC3_Settings $settings,

		HC3_Ui $ui,
		HC3_Request $request,
		HC3_Time $t,

		SH4_App_Query $appQuery,

		SH4_Shifts_Conflicts $conflicts,

		SH4_Calendars_Permissions $calendarsPermissions,
		SH4_Employees_Query $employeesQuery,
		SH4_Calendars_Query $calendarsQuery,
		SH4_Shifts_Query $shiftsQuery
		)
	{
		$this->self = $hooks->wrap( $this );

		$this->auth = $auth;

		$this->ui = $ui;
		$this->t = $t;
		$this->request = $request;
		$this->settings = $settings;

		$this->appQuery = $hooks->wrap( $appQuery );

		$this->conflicts = $hooks->wrap( $conflicts );

		$this->calendarsPermissions = $hooks->wrap( $calendarsPermissions );
		$this->employeesQuery = $hooks->wrap( $employeesQuery );
		$this->calendarsQuery = $hooks->wrap( $calendarsQuery );
		$this->shiftsQuery = $hooks->wrap( $shiftsQuery );
	}

	public function dateLabel( $date )
	{
		$slug = $this->request->getSlug();
		$today = $this->t->setNow()->formatDateDb();

		$this->t->setDateDb( $date );

		$weekdayView = $this->t->getWeekdayName();
		$weekdayView = $this->ui->makeBlock( $weekdayView )->tag('muted')->tag('font-size', 1);

		$ret = $this->t->getDay();
		$ret = $this->ui->makeListInline( array($weekdayView, $ret) )
			->tag('align', 'center')
			;

		return $ret;
	}

	public function renderDateLabel( $date )
	{
		$slug = $this->request->getSlug();
		$today = $this->t->setNow()->formatDateDb();

		$dateView = $this->self->dateLabel( $date );

		$this->t->setDateDb( $date );
		$weekLabel = $this->t->getWeekNo();
		$weekLabel = '__Week__' . ' #' . $weekLabel;

		$toDateParams = array();
		$toDateParams['type'] = 'day';
		$toDateParams['start'] = $date;
		$toDate = array( $slug, $toDateParams );

		$title = $this->t->formatDateWithWeekday() . ' ' . $weekLabel;

		$dateView = $this->ui->makeAhref( $toDate, $dateView )
			->tag('print')
			// ->addAttr( 'title', $title )
			->setAttr( 'title', $title )
			;

		if( $date == $today ){
			$dateView = $this->ui->makeBlock( $dateView )
				->tag('border')
				->tag('border-color', 'gray')
				;
		}

		$ret = $dateView;
		return $ret;
	}

	public function dateLabelGrouped( $date )
	{
		$this->t->setDateDb( $date );

		$dateView = array();
		$weekdayView = $this->t->getWeekdayName();
		$weekdayView = $this->ui->makeBlock( $weekdayView )->tag('muted')->tag('font-size', 1);
		$dateView[] = $weekdayView;

		$dayView = $this->t->getDay();
		$dateView[] = $dayView;

		$dateView = $this->ui->makeList( $dateView )
			->gutter( 0 )
			->tag('align', 'center')
			;

		return $dateView;
	}

	public function renderDateLabelGrouped( $date )
	{
		$slug = $this->request->getSlug();
		$today = $this->t->setNow()->formatDateDb();

		$dateView = $this->self->dateLabelGrouped( $date );

		$this->t->setDateDb( $date );
		$weekLabel = $this->t->getWeekNo();
		$weekLabel = '__Week__' . ' #' . $weekLabel;

		$toDateParams = array();
		$toDateParams['type'] = 'day';
		$toDateParams['start'] = $date;
		$toDate = array( $slug, $toDateParams );

		$title = $this->t->formatDateWithWeekday() . ' ' . $weekLabel;

		$dateView = $this->ui->makeAhref( $toDate, $dateView )
			->tag('print')
			// ->addAttr( 'title', $title )
			->setAttr( 'title', $title )
			;

		if( $date == $today ){
			$dateView = $this->ui->makeBlock( $dateView )
				->tag('border')
				->tag('border-color', 'gray')
				;
		}

		$ret = $dateView;
		return $ret;
	}

	public function employeeRowLabel( $employeeView, $employeeId, $range, $dates, $shifts )
	{
		return $employeeView;
	}

	public function renderReport( $shiftsDuration, $alignRight = true, $isVert = false )
	{
		$return = NULL;

		$hide = $this->settings->get('datetime_hide_schedule_reports');
		if( $hide ){
			return $return;
		}

		$currentUser = $this->auth->getCurrentUser();
		$currentUserId = $currentUser->getId();

		if( ! $currentUserId ){
			return $return;
		}

		$qty = $shiftsDuration->getQty();
		$duration = $shiftsDuration->getDuration();

		$qtyTimeoff = $shiftsDuration->getQtyTimeoff();
		$durationTimeoff = $shiftsDuration->getDurationTimeoff();

		if( $qtyTimeoff ){
			$qty = $qty - $qtyTimeoff;
			$duration = $duration - $durationTimeoff;
		}

		$return = array();
		// $return[] = $this->ui->makeBlockInline( $shiftsDuration->getQty() )
		// 	->addAttr( 'title', '__Number Of Shifts__' )
		// 	;
		$thisView = $shiftsDuration->formatDuration($duration);
		$return[] = $this->ui->makeSpan( $thisView )
			->addAttr( 'title', '__Hours__' . ': ' . $thisView )
			;
		$return[] = $this->ui->makeBlockInline( '(' . $qty . ')' )
			->addAttr( 'title', '__Shifts__' . ': ' . $qty )
			->tag('muted')
			->tag('font-size', 2)
			;

		$return = $isVert ? $this->ui->makeList( $return )->gutter(1) : $this->ui->makeListInline( $return )->gutter(1);

		if( $qtyTimeoff ){
			$timeoffReturn = array();
			$timeoffReturn[] = $this->ui->makeSpan( $shiftsDuration->formatDuration($durationTimeoff) )
				->addAttr( 'title', '__Hours__' )
				;
			$timeoffReturn[] = $this->ui->makeBlockInline( '(' . $qtyTimeoff . ')' )
				->addAttr( 'title', '__Time Off__' )
				->tag('muted')
				->tag('font-size', 2)
				;
			$timeoffReturn = $this->ui->makeListInline( $timeoffReturn )
				->gutter(1)
				;

			$return = $isVert ? $this->ui->makeList( array($return, $timeoffReturn) )->gutter(1) : $this->ui->makeListInline( array($return, $timeoffReturn) )->gutter(1);
		}

		if( $isVert ){
			$return = $this->ui->makeBlock( $return )
				// ->tag('border')
				->tag('padding', 1 )
				;
		}
		else {
			$return = $this->ui->makeBlockInline( $return )
				->tag('border')
				->tag('padding', 1 )
				;
		}
		if( $alignRight ){
			$return = $this->ui->makeBlock( $return )
				->tag('align', 'right')
				;
		}

		return $return;
	}

	public function filterShifts( $return )
	{
		$currentUser = $this->auth->getCurrentUser();
		$currentUserId = $currentUser->getId();

		$allCalendars = $this->self->findAllCalendars();

		$meEmployeeId = NULL;
		$meEmployeeCalendars = array();

		$meEmployee = $this->appQuery->findEmployeeByUser( $currentUser );
		if( $meEmployee ){
			$meEmployeeId = $meEmployee->getId();
			$meEmployeeCalendars = $this->appQuery->filterCalendarsForEmployee( $allCalendars, $meEmployee );
		}

		$myManagedCalendars = array();
		$myViewedCalendars = array();
		if( $currentUserId ){
			$myManagedCalendars = $this->appQuery->filterCalendarsManagedByUser( $allCalendars, $currentUser );
			$myViewedCalendars = $this->appQuery->filterCalendarsViewedByUser( $allCalendars, $currentUser );
		}

		$ids = array_keys( $return );
		foreach( $ids as $id ){
			$shift = $return[$id];

			$shiftCalendar = $shift->getCalendar();
			$shiftCalendarId = $shiftCalendar->getId();
			$shiftEmployee = $shift->getEmployee();
			$shiftEmployeeId = $shiftEmployee->getId();

		// is manager?
			if( isset($myManagedCalendars[$shiftCalendarId]) ){
				continue;
			}

		// is viewer?
			if( isset($myViewedCalendars[$shiftCalendarId]) ){
				continue;
			}

		// is visitor
			if( ! $meEmployeeId ){
				if( $shift->isOpen() ){
					$permName = $shift->isPublished() ? 'visitor_view_open_publish' : 'visitor_view_open_draft';
				}
				else {
					$permName = $shift->isPublished() ? 'visitor_view_others_publish' : 'visitor_view_others_draft';
				}
				$perm = $this->calendarsPermissions->get( $shiftCalendar, $permName );
				if( ! $perm ){
					unset( $return[$id] );
				}
				continue;
			}

		// is shift employee
			if( $meEmployeeId == $shiftEmployeeId ){
				$permName = $shift->isPublished() ? 'employee_view_own_publish' : 'employee_view_own_draft';
				$perm = $this->calendarsPermissions->get( $shiftCalendar, $permName );
				if( ! $perm ){
					unset( $return[$id] );
				}
				continue;
			}

		// is other employee
			if( $meEmployeeId != $shiftEmployeeId ){
			// calendar employees
				if( isset($meEmployeeCalendars[$shiftCalendarId]) ){
					if( $shift->isOpen() ){
						$permName = $shift->isPublished() ? 'employee_view_open_publish' : 'employee_view_open_draft';
					}
					else {
						$permName = $shift->isPublished() ? 'employee_view_others_publish' : 'employee_view_others_draft';
					}
				}
			// other employees
				else {
					if( $shift->isOpen() ){
						$permName = $shift->isPublished() ? 'employee2_view_open_publish' : 'employee2_view_open_draft';
					}
					else {
						$permName = $shift->isPublished() ? 'employee2_view_others_publish' : 'employee2_view_others_draft';
					}
				}

				$perm = $this->calendarsPermissions->get( $shiftCalendar, $permName );
				if( ! $perm ){
					unset( $return[$id] );
				}

				continue;
			}
		}

	// sort
		uasort( $return, array($this, '_sortShifts') );

		return $return;
	}

	public function _sortShifts( $a, $b )
	{
		$compare1 = $a->getStart();
		$compare2 = $b->getStart();
		if( $compare1 != $compare2 ){
			return ( $compare1 > $compare2 ) ? 1 : -1;
		}

		$compare1 = $a->getEnd();
		$compare2 = $b->getEnd();
		if( $compare1 != $compare2 ){
			return ( $compare1 > $compare2 ) ? 1 : -1;
		}

		$cal1 = $a->getCalendar();
		$cal2 = $b->getCalendar();
		if( ! ($cal1 && $cal2) ){
			return 0;
		}

		$compare1 = $cal1->getSortOrder();
		$compare2 = $cal2->getSortOrder();
		if( $compare1 != $compare2 ){
			return ( $compare1 > $compare2 ) ? 1 : -1;
		}

		$compare1 = $cal1->getTitle();
		$compare2 = $cal2->getTitle();
		if( $compare1 != $compare2 ){
			return strcmp( $compare1, $compare2 );
		}

		$emp1 = $a->getEmployee();
		$emp2 = $b->getEmployee();
		if( ! ($emp1 && $emp2) ){
			return 0;
		}

		$compare1 = $emp1->getSortOrder();
		$compare2 = $emp2->getSortOrder();
		if( $compare1 != $compare2 ){
			return ( $compare1 > $compare2 ) ? 1 : -1;
		}

		$compare1 = $emp1->getTitle();
		$compare2 = $emp2->getTitle();
		if( $compare1 != $compare2 ){
			return strcmp( $compare1, $compare2 );
		}
	}

	public function filterViewTypes( $return )
	{
		$currentUser = $this->auth->getCurrentUser();
		$currentUserId = $currentUser->getId();
		if( ! $currentUserId ){
			unset( $return['report'] );
		}
		return $return;
	}

	public function findAllEmployees()
	{
		// $return = $this->employeesQuery->findActive();
		$return = $this->employeesQuery->findAll();

		$currentUser = $this->auth->getCurrentUser();
		$currentUserId = $currentUser->getId();

		$employee = $this->appQuery->findEmployeeByUser( $currentUser );
		$managedCalendars = $this->appQuery->findCalendarsManagedByUser( $currentUser );
		$viewedCalendars = $this->appQuery->findCalendarsViewedByUser( $currentUser );

		$allowed = array();
		if( $employee ){
			$allowed[ $employee->getId() ] = $employee;
		}

		$calendars = $this->self->findAllCalendars();
		foreach( $calendars as $calendar ){
			$thisCalendarId = $calendar->getId();

			// $thisAllowed = $this->appQuery->findEmployeesForCalendar( $calendar );
			$thisAllowed = $this->appQuery->filterEmployeesForCalendar( $return, $calendar );

			if( isset($managedCalendars[$thisCalendarId]) ){
				$allowed = $allowed + $thisAllowed;
				continue;
			}

			if( isset($viewedCalendars[$thisCalendarId]) ){
				$allowed = $allowed + $thisAllowed;
				continue;
			}

		// OPEN?
			if( isset($thisAllowed[0]) ){
				$permNames = array();
				$permNames[] = 'visitor_view_open_publish';
				$permNames[] = 'visitor_view_open_draft';
				if( $employee ){
					$permNames[] = 'employee_view_open_publish';
					$permNames[] = 'employee_view_open_draft';
				}

				reset( $permNames );
				foreach( $permNames as $permName ){
					$perm = $this->calendarsPermissions->get( $calendar, $permName );
					if( $perm ){
						$allowed[0] = $thisAllowed[0];
						break;
					}
				}

				unset( $thisAllowed[0] );
			}

			$permNames = array();
			$permNames[] = 'visitor_view_others_publish';
			$permNames[] = 'visitor_view_others_draft';
			if( $employee ){
				$permNames[] = 'employee_view_others_publish';
				$permNames[] = 'employee_view_others_draft';
			}

			reset( $permNames );
			foreach( $permNames as $permName ){
				$perm = $this->calendarsPermissions->get( $calendar, $permName );
				if( $perm ){
					$allowed = $allowed + $thisAllowed;
					break;
				}
			}

		// PICKUP?
			if( $employee ){
				$permNames = array();
				$permNames[] = 'employee_pickup_others';

				reset( $permNames );
				foreach( $permNames as $permName ){
					$perm = $this->calendarsPermissions->get( $calendar, $permName );
					if( $perm ){
						$allowed = $allowed + $thisAllowed;
						break;
					}
				}
			}

			// $allowed = $allowed + $thisReturn;
		}

		$ids = array_keys( $return );
		foreach( $ids as $id ){
			if( ! array_key_exists($id, $allowed) ){
				unset( $return[$id] );
			}
		}

		return $return;
	}

	public function findAllCalendars()
	{
		static $return = null;
		if( null !== $return ){
			return $return;
		}

		// $return = $this->calendarsQuery->findActive();
		$return = $this->calendarsQuery->findAll();

		$params = $this->request->getParams();
		if( isset($params['calendar']) && $params['calendar'] ){
			$paramCalendarIdList = $params['calendar'];
			if( $paramCalendarIdList && (! is_array($paramCalendarIdList)) ){
				$paramCalendarIdList = array( $paramCalendarIdList );
			}

			$excludeIdList = array();
			foreach( $paramCalendarIdList as $id ){
				if( $id < 0 ){
					$excludeIdList[ -$id ] = -$id;
				}
			}

			if( $excludeIdList ){
				$return = array_diff_key( $return, $excludeIdList );

				$newParamCalendarIdList = array();
				foreach( $paramCalendarIdList as $id ){
					if( $id < 0 ) continue;
					$newParamCalendarIdList[] = $id;
				}

				$this->request->setParam( 'calendar', $newParamCalendarIdList );
			}
		}

		$allowed = array();

		$currentUser = $this->auth->getCurrentUser();
		$currentUserId = $currentUser->getId();
		$employee = $this->appQuery->findEmployeeByUser( $currentUser );

		if( $currentUserId ){
			$thisReturn = $this->appQuery->filterCalendarsManagedByUser( $return, $currentUser );
			$allowed = $allowed + $thisReturn;

			$thisReturn = $this->appQuery->filterCalendarsViewedByUser( $return, $currentUser );
			$allowed = $allowed + $thisReturn;
		}

		$calendarsForEmployee = array();
		if( $employee ){
			$calendarsForEmployee = $this->appQuery->filterCalendarsForEmployee( $return, $employee );
			$allowed = $allowed + $calendarsForEmployee;
		}

		foreach( $return as $calendar ){
			$calendarId = $calendar->getId();

			$permNames = array();
			$permNames[] = 'visitor_view_others_publish';
			$permNames[] = 'visitor_view_others_draft';
			$permNames[] = 'visitor_view_open_publish';
			$permNames[] = 'visitor_view_open_draft';

			if( $currentUserId ){
				// if( ! isset($calendarsForEmployee[$currentUserId]) ){
					// continue;
				// }

				if( isset($calendarsForEmployee[$currentUserId]) ){
					$permNames[] = 'employee_view_others_publish';
					$permNames[] = 'employee_view_others_draft';
				}
				else {
					$permNames[] = 'employee2_view_others_publish';
					$permNames[] = 'employee2_view_others_draft';
				}
			}

			reset( $permNames );
			foreach( $permNames as $permName ){
				$perm = $this->calendarsPermissions->get( $calendar, $permName );
				if( $perm ){
					$allowed[ $calendarId ] = $calendar;
					break;
				}
			}
		}

		$ids = array_keys( $return );
		foreach( $ids as $id ){
			// if( ! array_key_exists($id, $allowed) ){
			if( ! isset($allowed[$id]) ){
				unset( $return[$id] );
			}
		}

		return $return;
	}

	public function getShifts()
	{
		static $cache = null;
		if( null !== $cache ) return $cache;

	// init params
		$params = $this->request->getParams();
		if( isset($params['time']) && ('now' == $params['time']) ){
			$params['time'] = $this->t->setNow()->formatDateTimeDb();
		}

		$type = $params['type'];
		$startDate = $params['start'];
		$endDate = $params['end'];

		if( 'start-week' == $startDate ){
			$this->t->setNow()->setStartWeek();
			$startDate = $this->t->formatDateDb();
		}
		elseif( 'start-month' == $startDate ){
			$this->t->setNow()->setStartMonth();
			$startDate = $this->t->formatDateDb();
		}
		elseif( 'start-year' == $startDate ){
			$this->t->setNow()->setStartYear();
			$startDate = $this->t->formatDateDb();
		}
		elseif( 'first-non-blank' == $startDate ){
			$now = $this->t->setNow()->setStartDay()->formatDateTimeDb();

			$q = array();
			$q[] = array( 'sort', 'starts_at', 'asc' );
			$q[] = array( 'starts_at', '>', $now );
			$q[] = array( 'limit', 1 );

			$allCalendars = $this->self->findAllCalendars();
			$listCalendarId = array_keys( $allCalendars );
			$calendarFilter = $this->getCalendarFilter();
			if( $calendarFilter ){
				$listCalendarId = array_intersect( $listCalendarId, $calendarFilter );
			}
			$q[] = array( 'calendar_id', 'IN', $listCalendarId );

			$allEmployees = $this->self->findAllEmployees();
			$listEmployeeId = array_keys( $allEmployees );
			$employeeFilter = $this->getEmployeeFilter();
			if( $employeeFilter ){
				$listEmployeeId = array_intersect( $listEmployeeId, $employeeFilter );
			}
			$q[] = array( 'employee_id', 'IN', $listEmployeeId );

			$res = $this->shiftsQuery->read( $q );
			if( $res ){
				$shift = current( $res );
				$startDate = $this->t->setDateTimeDb( $shift->getStart() )->formatDateDb();
			}
			else {
				$startDate = $this->t->setDateTimeDb( $now )->formatDateDb();
			}
		}
		elseif( 'first-blank' == $startDate ){
			$now = $this->t->setNow()->setStartDay()->formatDateTimeDb();

			$q = array();
			$q[] = array( 'sort', 'ends_at', 'desc' );
			$q[] = array( 'limit', 1 );

			$allCalendars = $this->self->findAllCalendars();
			$listCalendarId = array_keys( $allCalendars );
			$calendarFilter = $this->getCalendarFilter();
			if( $calendarFilter ){
				$listCalendarId = array_intersect( $listCalendarId, $calendarFilter );
			}
			$q[] = array( 'calendar_id', 'IN', $listCalendarId );

			$allEmployees = $this->self->findAllEmployees();
			$listEmployeeId = array_keys( $allEmployees );
			$employeeFilter = $this->getEmployeeFilter();
			if( $employeeFilter ){
				$listEmployeeId = array_intersect( $listEmployeeId, $employeeFilter );
			}
			$q[] = array( 'employee_id', 'IN', $listEmployeeId );

			$res = $this->shiftsQuery->read( $q );
			if( $res ){
				$shift = current( $res );
				$startDate = $this->t->setDateTimeDb( $shift->getStart() )->formatDateDb();
			}
			else {
				$startDate = $this->t->setDateTimeDb( $now )->formatDateDb();
			}

			switch( $type ){
				case 'day':
					$startDate = $this->t->setDateDb( $startDate )->modify( '+1 day' )->formatDateDb();
					break;

				case 'week':
					$startDate = $this->t->setDateDb( $startDate )->modify( '+1 week' )->setStartWeek()->formatDateDb();
					break;

				case '4weeks':
					$nWeeks = $this->settings->get( 'datetime_n_weeks' );
					if( ! $nWeeks ) $nWeeks = 4;
					$startDate = $this->t->setDateDb( $startDate )->modify('+' . $nWeeks . ' weeks')->setStartWeek()->formatDateDb();
					break;

				case '2weeks':
					$startDate = $this->t->setDateDb( $startDate )->modify('+2 weeks')->setStartWeek()->formatDateDb();
					break;

				case 'month':
					$startDate = $this->t->setDateDb( $startDate )->modify( '+1 month' )->setStartMonth()->formatDateDb();
					break;
			}
		}
		else {
			if( (FALSE !== strpos($startDate, '+')) OR (FALSE !== strpos($startDate, '-')) ){
				$this->t->setNow()->setStartDay()->modify($startDate);
				$startDate = $this->t->formatDateDb();
			}
		}

		if( FALSE !== strpos($endDate, '+') ){
			$this->t->setDateDb($startDate)->modify($endDate)->modify('-1 day')->setEndDay();
			$endDate = $this->t->formatDateDb();
		}

		$exactDateTime = isset( $params['time'] ) ? $params['time'] : NULL;
		if( $exactDateTime ){
			$startDate = $this->t->setDateTimeDb( $exactDateTime )->formatDateDb();
			$endDate = $startDate;
		}

		switch( $type ){
			case 'day':
				$this->t->setDateDb($startDate);
				$start = $this->t->formatDateTimeDb();

				$startDate = $this->t->formatDateDb();
				$this->request->setParam('start', $startDate);
				$endDate = $this->t->formatDateDb();
				$this->request->setParam('end', $endDate);

				$daysToShow = isset( SH4_Schedule_Html_View_Day::$daysToShow ) ? SH4_Schedule_Html_View_Day::$daysToShow : 1;
				if( $daysToShow > 1 ){
					$this->t->modify( '+' . ($daysToShow - 1) . ' days' );
				}
				$end = $this->t->setEndDay()->formatDateTimeDb();
				break;

			case 'week':
				$this->t->setDateDb($startDate)->setStartWeek();
				$startDate = $this->t->formatDateDb();
				$this->request->setParam('start', $startDate);

				$start = $this->t->formatDateTimeDb();
				$this->t->setEndWeek();
				// $this->t->modify('+1 week')
					// ->modify('-1 day')
					// ;
				$endDate = $this->t->formatDateDb();

				$this->request->setParam('end', $endDate);
				$end = $this->t->setEndDay()->formatDateTimeDb();
				break;

			case '4weeks':
				$nWeeks = $this->settings->get( 'datetime_n_weeks' );
				if( ! $nWeeks ) $nWeeks = 4;

				$this->t->setDateDb($startDate)->setStartWeek();
				$startDate = $this->t->formatDateDb();
				$this->request->setParam('start', $startDate);

				$start = $this->t->formatDateTimeDb();
				$this->t->modify('+' . $nWeeks . ' weeks')
					->modify('-1 day')
					;
				$endDate = $this->t->formatDateDb();
				$this->request->setParam('end', $endDate);

				$end = $this->t->setEndDay()->formatDateTimeDb();
				break;

			case '2weeks':
				$this->t->setDateDb($startDate)->setStartWeek();
				$startDate = $this->t->formatDateDb();
				$this->request->setParam('start', $startDate);

				$start = $this->t->formatDateTimeDb();
				$this->t->modify('+2 weeks')
					->modify('-1 day')
					;
				$endDate = $this->t->formatDateDb();
				$this->request->setParam('end', $endDate);

				$end = $this->t->setEndDay()->formatDateTimeDb();
				break;

			case 'month':
				$this->t->setDateDb($startDate)->setStartMonth();
				$startDate = $this->t->formatDateDb();
				$this->request->setParam('start', $startDate);

				$start = $this->t->formatDateTimeDb();
				$this->t->setEndMonth();
				// $this->t->modify('+1 month')
					// ->modify('-1 day')
					// ;
				$endDate = $this->t->formatDateDb();
				$this->request->setParam('end', $endDate);

				$end = $this->t->setEndDay()->formatDateTimeDb();
				break;

			default:
				if( $exactDateTime ){
					$start = $exactDateTime;
					$end = $exactDateTime;
				}
				else {
					$this->t->setDateDb($startDate);
					$start = $this->t->formatDateTimeDb();

					// $this->t->setDateDb($endDate)->modify('+1 day');
					$this->t->setDateDb($endDate);
					$end = $this->t->setEndDay()->formatDateTimeDb();
				}

				break;
		}

		$this->shiftsQuery
			->setStart( $start )
			->setEnd( $end )
			;

		$return = $this->shiftsQuery->find();

	// filter
		$employees = $this->getEmployees();
		$calendars = $this->getCalendars();

		$employeeFilter = $this->getEmployeeFilter();
		$calendarFilter = $this->getCalendarFilter();

		foreach( array_keys($return) as $id ){
			$shift = $return[$id];

			$calendar = $shift->getCalendar();
			if( $calendarFilter && (! in_array($calendar->getId(), $calendarFilter)) ){
				unset( $return[$id] );
				continue;
			}

			$employee = $shift->getEmployee();
			$employeeId = $employee->getId();

			if( $employeeFilter ){
			// any assigned
				if( in_array(-1, $employeeFilter) ){
					if( ! $employeeId ){
						unset( $return[$id] );
						continue;
					}
				}
				else {
					if( ! in_array($employeeId, $employeeFilter) ){
						unset( $return[$id] );
						continue;
					}
				}
			}

			$shiftStart = $shift->getStart();
			$shiftEnd = $shift->getEnd();

			if( $shiftEnd <= $start ){
				unset( $return[$id] );
				continue;
			}

			if( $shiftStart >= $end ){
				unset( $return[$id] );
				continue;
			}

			// if( $shiftStart < $start ){
			// 	unset( $return[$id] );
			// 	continue;
			// }
		}

		$params = $this->request->getParams();

	// skip those shifts that start before period and end during the first day
		// $when = array( 'report', 'list' );
		// if( in_array('report', $when) ){
		if( 1 ){
			$startRange = $this->t->setDateDb( $params['start'] )->formatDateTimeDb();
			$endFirstDay = $this->t->setDateDb( $params['start'] )->modify('+1 day')->formatDateTimeDb();

			$ids = array_keys( $return );
			foreach( $ids as $id ){
				$shift = $return[ $id ];
				if( $shift->getStart() >= $startRange ) continue;
				if( $shift->getEnd() >= $endFirstDay ) continue;
				unset( $return[$id] );
			}
		}

		// filter conflicts?
		if( isset($params['conflict']) && $params['conflict'] ){
			$withConflicts = ( $params['conflict'] > 0 ) ? true : false;

			$ids = array_keys( $return );
			foreach( $ids as $id ){
				$shift = $return[ $id ];
				$conflicts = $this->conflicts->get( $shift );
				if( $withConflicts && (! $conflicts) ){
					unset( $return[$id] );
				}

				if( (! $withConflicts) && $conflicts ){
					unset( $return[$id] );
				}
			}
		}

    // t1: array of start/end time like this: 32400-576000_36000-64800
        if (isset($params['t'])) {
            $tParam = $params['t'];

            if (false !== strpos($tParam, '_')) {
                $tParam = explode('_', $tParam);
            } else {
                $tParam = [$tParam];
            }

            foreach (array_keys($tParam) as $ii) {
                $tParam[$ii] = explode('-', $tParam[$ii]);
                $tParam[$ii] = array_map('intval', $tParam[$ii]);
            }

            foreach (array_keys($return) as $id) {
                $startTime = (int) $return[$id]->getStartInDay();
                $endTime = (int) $return[$id]->getEndInDay();

                $ok = false;
                reset($tParam);
                foreach ($tParam as $p) {
                    if (($p[0] == $startTime) && ($p[1] == $endTime)) {
                        $ok = true;
                        break;
                    }
                }

                if (!$ok) {
                    unset($return[$id]);
                    continue;
                }
            }
        }

    // t1 or t2 params: start/end time
        if (isset($params['t1']) or isset($params['t2'])) {
            $t1 = $t2 = array();

            if (isset($params['t1'])) {
                $t1 = $params['t1'];
                if (false !== strpos($t1, '-')) {
                    $t1 = explode('-', $t1);
                } else {
                    $t1 = [$t1];
                }
                $t1 = array_map('intval', $t1);
            }

            if (isset($params['t2'])) {
                $t2 = $params['t2'];
                if (false !== strpos($t2, '-')) {
                    $t2 = explode('-', $t2);
                } else {
                    $t2 = [$t2];
                }
                $t2 = array_map('intval', $t2);
            }

            foreach (array_keys($return) as $id) {
                if ($t1) {
                    $startTime = (int) $return[$id]->getStartInDay();
                    if (!in_array($startTime, $t1)) {
                        unset($return[$id]);
                        continue;
                    }
                }

                if ($t2) {
                    $endTime = (int) $return[$id]->getEndInDay();
                    if (!in_array($endTime, $t2)) {
                        unset($return[$id]);
                        continue;
                    }
                }
            }
        }

		$return = $this->self->filterShifts( $return );
		$cache = $return;
		return $return;
	}

	public function getCalendars()
	{
		$return = $this->self->findAllCalendars();
		$params = $this->request->getParams();

		if( $params['calendar'] ){
			$filterIds = $params['calendar'];

			$ids = array_keys($return);
			foreach( $ids as $id ){
				if( ! in_array($id, $filterIds) ){
					unset( $return[$id] );
				}
			}
		}

		if( $params['employee'] ){
			$employees = $this->self->findAllEmployees();

			$filterEmployeeIds = $params['employee'];
			$filter = array();
			foreach( $employees as $employee ){
				$employeeId = $employee->getId();
				if( ! (in_array(-1, $filterEmployeeIds) && ($employeeId > 0)) ){
					if( ! in_array($employeeId, $filterEmployeeIds) ){
						continue;
					}
				}
				$filter = $filter + $this->appQuery->filterCalendarsForEmployee( $return, $employee );
			}
			$filterIds = array_keys( $filter );

			$ids = array_keys($return);
			foreach( $ids as $id ){
				if( ! in_array($id, $filterIds) ){
					unset( $return[$id] );
				}
			}
		}

		return $return;
	}

	public function getEmployees()
	{
		$return = $this->self->findAllEmployees();
		$params = $this->request->getParams();

		if( $params['employee'] ){
			$filterIds = $params['employee'];

			$ids = array_keys($return);
			foreach( $ids as $id ){
				if( in_array(-1, $filterIds) && ($id > 0) ){
					continue;
				}

				if( ! in_array($id, $filterIds) ){
					unset( $return[$id] );
				}
			}
		}

		if( $params['calendar'] ){
			$calendars = $this->self->findAllCalendars();

			$filter = array();
			foreach( $calendars as $calendar ){
				if( ! in_array($calendar->getId(), $params['calendar']) ){
					continue;
				}
				$filter = $filter + $this->appQuery->findEmployeesForCalendar( $calendar );
			}
			$filterIds = array_keys( $filter );

			$ids = array_keys($return);
			foreach( $ids as $id ){
				if( ! in_array($id, $filterIds) ){
					unset( $return[$id] );
				}
			}
		}

		return $return;
	}

	public function getEmployeeFilter()
	{
		$params = $this->request->getParams();
		$ret = isset( $params['employee'] ) ? $params['employee'] : array();
		return $ret;
	}

	public function getCalendarFilter()
	{
		$params = $this->request->getParams();
		$ret = isset( $params['calendar'] ) ? $params['calendar'] : array();
		return $ret;
	}
}