echo $this->tag->linkTo(array('versions/edit/' . $version->id . '/' . $version->system_id, '<span class="glyphicon glyphicon-pencil"></span>'));
?>
<?php
echo $this->tag->linkTo(array('versions/delete/' . $version->id . '/' . $version->system_id, '<span class="glyphicon glyphicon-trash"></span>'));
?>
</span></p>
<?php
$last_version = Versions::findFirst(array("date < '{$version->date}'", "order" => "date DESC", "limit" => 1));
if ($last_version) {
$last_date = $last_version->date;
} else {
$last_date = '0000-00-00';
}
$date = $version->date;
$activities = Activities::query()->where('date <= :date:')->andWhere('system_id = :system_id: ')->andWhere('date > :last_date: ')->bind(array('date' => $version->date, 'system_id' => $version->system_id, 'last_date' => $last_date))->order('date')->execute();
?>
<table class="table table-bordered">
<thead>
<tr>
<th>No</th>
<th>Date</th>
<th>Time</th>
<th>Description</th>
<th>Module</th>
</tr>
</thead>
<?php
$i = 1;
?>
<?php