iv>
{{/dates}}
{{#status}}
<div class="form-group row">
	<div class="col-sm-4 font-weight-bold">{{i18n.status}}</div>
	<div class="col-sm-8">{{status}}</div>
</div>
{{/status}}
{{#validfrom}}
<div class="form-group row">
	<div class="col-sm-4 font-weight-bold">{{i18n.validfrom}}</div>
	<div class="col-sm-8">
		<i class="fa fa-calendar fa-fw" aria-hidden="true"></i> {{date}}
		{{#time}}
		<br />
		{{/time}}
	</div>
</div>
{{/validfrom}}
{{#validto}}
<div class="form-group row">
	<div class="col-sm-4 font-weight-bold">{{i18n.validto}}</div>
	<div class="col-sm-8">
		<i class="fa fa-calendar fa-fw" aria-hidden="true"></i> {{date}}
		{{#time}}
		<br /><i class="fa fa-clock-o fa-fw" aria-hidden="true"></i> {{time}}
		{{/time}}
	</div>
</div>
{{/validto}}
{{#class}}
<div class="form-group row">
	<div class="col-sm-4 font-weight-bold">{{i18n.class}}</div>
	<div class="col-sm-8">{{class}}</div>
</div>
{{/class}}
{{#singleevent}}
{{#eventraces}}
<div class="form-group row">
	<div class="col-sm-4 font-weight-bold">{{i18n.distance}}</div>
	<div class="col-sm-8">{{length}}</div>
</div>
<div class="form-group row">
	<div class="col-sm-4 font-weight-bold">{{i18n.when}}</div>
	<div class="col-sm-8">{{light}}</div>
</div>
{{/eventraces}}
{{/singleevent}}
{{#discipline}}
<div class="form-group row">
	<div class="col-sm-4 font-weight-bold">{{i18n.discipline}}</div>
	<div class="col-sm-8">{{discipline}}</div>
</div>
{{/discipline}}
{{#results}}
<div class="form-group row">
	<div class="col-sm-4 font-weight-bold">{{i18n.results}}</div>
	<div class="col-sm-8">	
		<a href="https://eventor.orientering.se/Events/ResultList?eventId={{id}}&organisationId={{eventorid}}" target="_blank" rel="nofollow">{{i18n.results_club}}</a>&nbsp;|&nbsp;
		<a href="https://eventor.orientering.se/Events/ResultList?eventId={{id}}" target="_blank" rel="nofollow">{{i18n.results_all}}</a>
	</div>
</div>
{{/results}}

{{#haseventraces}}
{{^singleevent}}
<h5>Etapper</h5>
<table class="table table-sm table-striped table-hover">
<thead>
<tr>
<th>{{i18n.name}}</th>
<th>{{i18n.distance}}</th>
<th>{{i18n.when}}</th>
</tr>
</thead>
<tbody>
{{#eventraces}}
<tr>
<td>{{name}}</td>
<td>{{length}}</td>
<td>{{light}}</td>
{{/eventraces}}
</tbody>
</table>
{{/singleevent}}
{{/haseventraces}}

<div id="eventor-connect" class="mx-auto my-4" style="max-width: 320px;">
{{#eventor_connect}}
	<h3>{{i18n.eventor.login}}</h3>
	<p>{{i18n.eventor.desc}}</p>
	<form id="frmEventorConnect">
	<div class="form-group required">
		<label for="Passwd" class="sr-only">{{i18n.eventor.passwd}}</label>
		<input type="password" id="Passwd" name="Passwd" class="form-control" placeholder="{{i18n.eventor.passwd}}" aria-describedby="passwordHelpBlock" required>
		<small id="passwordHelpBlock" class="form-text text-muted">{{i18n.eventor.passwd_hlp}}</small>
		<small id="eventor-response" class="text-danger" style="display:none;">{{i18n.eventor.error}}</small>
	</div>

	<button type="submit" class="btn btn-success btn-block">{{i18n.eventor.login}}</button>
	</form>
{{/eventor_connect}}
{{#eventor_login}}
<a class="btn btn-block btn-success shadow-sm" href="" id="eventor-login" href="#" data-returnurl="/Entry?eventId={{id}}">{{i18n.isopen}}</a>
{{/eventor_login}}

<a class="btn btn-outline-primary btn-sm btn-block text-center mt-2" href="https://eventor.orientering.se/Events/Show/{{id}}" target="_blank" rel="nofollow">{{i18n.details}}</a>
</div>
{{#isopen}}
{{/isopen}}
{{/data}}
EOT;

		$paging_template = <<<EOT
{{#data}}
<div class="d-flex justify-content-between">
	{{#prev}}
	<div class="mr-auto">
	<a class="btn btn-link" href="{{absurl}}{{id}}-{{slug}}/" data-toggle="tooltip" data-html="true" title="{{name}}<br />{{start}}">
		<i class="fa fa-chevron-circle-left" aria-hidden="true"></i> Föreg
	</a>
	</div>
	{{/prev}}
	{{#next}}
	<div class="ml-auto">
	<a class="btn btn-link" href="{{absurl}}{{id}}-{{slug}}/" data-toggle="tooltip" data-html="true" title="{{name}}<br />{{start}}">
		Nästa <i class="fa fa-chevron-circle-right"></i>
	</a>
	</div>
	{{/next}}
</div><hr />
{{/data}}
EOT;
		if($paging['prev'] !== falue` = 1, `m1`.`MetaValue`, NULL) `Email`, IF(`m5`.`MetaValue` = 1, `m2`.`MetaValue`, NULL) `Phone`, `m3`.`MetaValue` `Desc`, `b`.`Name` `Title`, `b`.`Props` 
				FROM `school_notifies` 
				INNER JOIN `school_user` 
				ON `not_user_id` = `user_id` 
				 LEFT JOIN `school_user_meta` `m1` 
				 ON `user_id` = `m1`.`UserId` 
				 AND `m1`.`MetaKey` = 'Email' 
				 LEFT JOIN `school_user_meta` `m2` 
				 ON `user_id` = `m2`.`UserId` 
				 AND `m2`.`MetaKey` = 'Phone' 
				 LEFT JOIN `school_user_meta` `m3` 
				 ON `user_id` = `m3`.`UserId` 
				 AND `m3`.`MetaKey` = 'Desc' 
				 LEFT JOIN `school_user_meta` `m4` 
				 ON `user_id` = `m4`.`UserId` 
				 AND `m4`.`MetaKey` = 'Title' 
				 LEFT JOIN `school_user_meta` `m5` 
				 ON `user_id` = `m5`.`UserId` 
				 AND `m5`.`MetaKey` = 'ShowPhone' 
				 LEFT JOIN `school_user_meta` `m6` 
				 ON `user_id` = `m6`.`UserId` 
				 AND `m6`.`MetaKey` = 'ShowEmail' 
				  INNER JOIN `roles` b 
				  ON `not_role` = b.`ID` 
				WHERE `not_group_id` = ? 
				AND `not_type` = 1 
				AND `Staff` = 1 
				ORDER BY b.`Order`, `Name` 
			";
//			echo sprintf("<pre>%s</pre>", print_r($query, true)); exit;

		}elseif(!$this->FromActivity && intval($this->Group) !== 0){
			$query = "
				SELECT 
				`b`.`user_id`, CONCAT_WS(' ', `b`.`user_firstname`, `b`.`user_lastname`) `Name`, IF(`m6`.`MetaValue` = 1, `m1`.`MetaValue`, NULL) `Email`, IF(`m5`.`MetaValue` = 1, `m2`.`MetaValue`, NULL) `Phone`, `m3`.`MetaValue` `Desc`, `m4`.`MetaValue` `Title`  
				FROM `site_organisation` a 
				INNER JOIN `school_user` b 
				ON a.`user_id` = b.`user_id` 
				 LEFT JOIN `school_user_meta` `m1` 
				 ON b.`user_id` = `m1`.`UserId` 
				 AND `m1`.`MetaKey` = 'Email' 
				 LEFT JOIN `school_user_meta` `m2` 
				 ON b.`user_id` = `m2`.`UserId` 
				 AND `m2`.`MetaKey` = 'Phone' 
				 LEFT JOIN `school_user_meta` `m3` 
				 ON b.`user_id` = `m3`.`UserId` 
				 AND `m3`.`MetaKey` = 'Desc' 
				 LEFT JOIN `school_user_meta` `m4` 
				 ON b.`user_id` = `m4`.`UserId` 
				 AND `m4`.`MetaKey` = 'Title' 
				 LEFT JOIN `school_user_meta` `m5` 
				 ON b.`user_id` = `m5`.`UserId` 
				 AND `m5`.`MetaKey` = 'ShowPhone' 
				 LEFT JOIN `school_user_meta` `m6` 
				 ON b.`user_id` = `m6`.`UserId` 
				 AND `m6`.`MetaKey` = 'ShowEmail' 
				WHERE a.`group_id` = ? 
				ORDER BY a.`post_order` ASC
			";

		}else{
			$query = "
				SELECT 
				`user_id`, CONCAT_WS(' ', `user_firstname`, `user_lastname`) `Name`, IF(`m6`.`MetaValue` = 1, `m1`.`MetaValue`, NULL) `Email`, IF(`m5`.`MetaValue` = 1, `m2`.`MetaValue`, NULL) `Phone`, `m3`.`MetaValue` `Desc`, `m4`.`MetaValue` `Title`    
				FROM `school_user` 
				 LEFT JOIN `school_user_meta` `m1` 
				 ON `user_id` = `m1`.`UserId` 
				 AND `m1`.`MetaKey` = 'Email' 
				 LEFT JOIN `school_user_meta` `m2` 
				 ON `user_id` = `m2`.`UserId` 
				 AND `m2`.`MetaKey` = 'Phone' 
				 LEFT JOIN `school_user_meta` `m3` 
				 ON `user_id` = `m3`.`UserId` 
				 AND `m3`.`MetaKey` = 'Desc' 
				 LEFT JOIN `school_user_meta` `m4` 
				 ON `user_id` = `m4`.`UserId` 
				 AND `m4`.`MetaKey` = 'Title' 
				 LEFT JOIN `school_user_meta` `m5` 
				 ON `user_id` = `m5`.`UserId` 
				 AND `m5`.`MetaKey` = 'ShowPhone' 
				 LEFT JOIN `school_user_meta` `m6` 
				 ON `user_id` = `m6`.`UserId` 
				 AND `m6`.`MetaKey` = 'ShowEmail' 
				WHERE `user_id` = ? 
				LIMIT 1
			";
		}
//		echo sprintf("<pre>%s</pre>", $query);

		if((int)$this->Group !== 0){
			$Id = $this->Group;
		}else{
			$Id = $this->User;
		}

		$pst = $this->dbh->prepare($query);
		$pst->execute( [ $Id ] );
		if($pst->rowCount() !== 0){
			require_once(sprintf('%s%sCORE/inc/class.User.PDO.php', ROOTPATH, ADMPATH));

			$i = 0;
			while($res = $pst->fetch(PDO::FETCH_ASSOC)){
//				if(!isset($res['user_title'])) $res['user_title'] = $res['role'];
				
				$Title = null;
				if(!is_null($res['Title'])) $Title = $res['Title'];
				
				$Email = null;
				if(!is_null($res['Email'])){
					$Email = $this->StaffEmail($res['Email']);

				}elseif(strlen($_GLOBAL_DEFAULT_EMAIL) !== 0){
					$Email = $this->StaffEmail($_GLOBAL_DEFAULT_EMAIL);
		 == true && console) console.log(jqXHR.responseText);
			$('#tblResults').DataTable().clear().draw();
		},
		data: function ( d ) {
			return $('#frmResults').serialize();
		}
	},
	initComplete: function () {
		$('[data-toggle="tooltip"]').tooltip();		
	},
	drawCallback: function () {
		$('[data-toggle="tooltip"]').tooltip();
	},
	autoWidth: false,
	pageLength: 10,
//	order: [[ 3, "asc" ], [ 6, "desc" ]],
	columnDefs: [
//		{ orderable: false, targets: [ -1 ] },
		{ targets: 0, data: 'Position' },
		{ targets: 1, data: 'Name' },
		{ targets: 2, data: 'Born' },
		{ targets: 3, data: 'Date' },
		{ targets: 4, data: 'Time' }
	]
});
$('#Distance').on('change', function(){
	Table.ajax.reload();
});
EOT;

			$Content .= <<<EOT
			<h3>Föreningsresultat</h3>
			<form id="frmResults" action="{$__AbsPath}Ajax/ajax.Competition.Result.php" method="post">
			<div class="form-group">
				<label for="Distance">Distans</label>
				<select id="Distance" name="Distance" class="form-control">
				<option value="0">-- välj --</option>
EOT;
			foreach($Competition['Results'] as $Group){
				$Content .= <<<EOT
				<optgroup label="{$Group['Pool']}">
EOT;
				foreach($Group['Distance'] as $Dist){
					$Content .= <<<EOT
					<option value="{$Dist['Distance']}">{$Dist['Name']}</option>
EOT;
				}
				$Content .= <<<EOT
				</optgroup>
EOT;
			}

			$Content .= <<<EOT
				</select>
			</div>
			<input type="hidden" name="CompId" value="{$Competition['Id']}" />
			</form>

			<table id="tblResults" class="table table-striped table-hover">
			<thead>
			<tr>
			<th>Placering</th>
			<th>Namn</th>
			<th>Född</th>
			<th>Datum</th>
			<th>Tid</th>
			</tr>
			</thead>
			</table>
EOT;
		}
	}
//	$Content .= sprintf('<pre>%s</pre>', var_export($data, true));
//	$Content .= sprintf('<pre>%s</pre>', var_export($Competition, true));
}