}
$dataContents = ob_get_contents();
ob_end_clean();
foreach ($replace as $rep) {
if (array_key_exists($rep, $replacements)) {
$value = $replacements[$rep];
} else {
$value = '-';
}
$dataContents = str_replace($rep, $value, $dataContents);
}
echo $dataContents;
if ($pagination != null) {
?>
<?php
Easol_Widget::show("PaginationWidget", $pagination);
}
?>
<div class="col-md-4 pull-right">
<?php
if (isset($filter) && isset($filter['fields']) && isset($filter['fields']['Result'])) {
?>
<div class="col-md-5">
<select class="form-control" id="filter-result" >
<?php
foreach ($filter['fields']['Result']['range']['set'] as $key => $value) {
?>
<option value="<?php
echo $key;
<div class="row">
<div class="col-md-12 col-sm-12">
<h1 class="page-header">Cohorts</h1>
</div>
</div>
<div class="row">
<div class="col-md-12 col-sm-12">
<?php
Easol_Widget::show("DataTableWidget", ['query' => $query, 'pagination' => $pagination, 'filter' => $filter, 'colOrderBy' => $colOrderBy, 'colGroupBy' => $colGroupBy, 'columns' => [['name' => 'CohortIdentifier', 'title' => 'Name', 'type' => 'url', 'url' => function ($model) {
return site_url('cohorts/students/' . $model->CohortIdentifier);
}], ['name' => 'CohortDescription', 'title' => 'Description'], ['name' => 'StudentCount', 'title' => 'Students']], 'downloadCSV' => true]);
?>
</div>
</div>
');
d3.select('#chart1 svg')
.datum(long_short_data)
.call(chart);
nv.utils.windowResize(chart.update);
chart.dispatch.on('stateChange', function(e) { nv.log('New State:', JSON.stringify(e)); });
chart.state.dispatch.on('change', function(state){
nv.log('state', JSON.stringify(state));
});
return chart;
});
</script>
</div>
</div>
</div>
</div>
<?php
if (isset($pageNo)) {
?>
<div class="row">
<div class="col-md-12">
<?php
Easol_Widget::show("DataTableWidget", ['query' => preg_replace("/ORDER BY.*?(?=\\)|\$)/mi", " ", clean_subquery($model->CommandText)), 'pagination' => ['pageSize' => EASOL_PAGINATION_PAGE_SIZE, 'currentPage' => $pageNo, 'url' => 'reports/view/' . $model->ReportId . '/@pageNo'], 'colOrderBy' => [$_columns[0]], 'columns' => $_columns, 'downloadCSV' => true]);
?>
</div>
</div>
<?php
}
<?php
/* @var $model Easol_Report */
?>
<?php
//find columns
$_colums = [];
foreach ($this->db->query($model->CommandText)->row() as $key => $value) {
$_columns[] = $key;
}
if ($displayTitle == true) {
?>
<div class="row">
<div class="col-md-12 col-sm-12">
<h1 class="page-header"><?php
echo $model->ReportName;
?>
</h1>
</div>
</div>
<?php
}
?>
<div class="row">
<div class="col-md-12 col-sm-12">
<?php
Easol_Widget::show("DataTableWidget", ['query' => clean_subquery($model->CommandText), 'pagination' => ['pageSize' => EASOL_PAGINATION_PAGE_SIZE, 'currentPage' => $pageNo, 'url' => isset($paginationUrl) ? $paginationUrl . '/@pageNo' : 'reports/view/' . $model->ReportId . '/@pageNo'], 'colOrderBy' => [$_columns[0]], 'columns' => $_columns, 'downloadCSV' => true]);
?>
</div>
</div>
</div>
<div class="col-md-6">
<table class="table table-bordered ">
<tr>
<th>Cohort ID:</th>
<td><?php
echo $cohort->CohortIdentifier;
?>
</td>
</tr>
<tr>
<th>Cohort Description:</th>
<td><?php
echo $cohort->CohortDescription;
?>
</td>
</tr>
</table>
</div>
<br>
<div class="row">
<div class="col-md-12">
<?php
Easol_Widget::show("DataTableWidget", ['query' => $query, 'pagination' => $pagination, 'colOrderBy' => $colOrderBy, 'columns' => [['name' => 'FirstName', 'title' => 'Student Name', 'value' => function ($model) {
return $model->FirstName . ' ' . $model->LastSurname;
}, 'type' => 'url', 'url' => function ($model) {
return site_url('student/profile/' . $model->StudentUSI);
}]], 'downloadCSV' => true]);
?>
</div>
</div>
<div class="row">
<div class="col-md-12 col-sm-12">
<h1 class="page-header">Schools</h1>
</div>
</div>
<div class="row">
<div class="col-md-12 col-sm-12">
<?php
Easol_Widget::show("DataTableWidget", ['query' => $query, 'pagination' => $pagination, 'colOrderBy' => 'EducationOrganizationId', 'columns' => [['name' => 'EducationOrganizationId', 'title' => 'Education Organization Id', 'type' => 'url', 'url' => function ($model) {
return $model->EducationOrganizationId;
}], ['name' => 'NameOfInstitution', 'title' => 'Name of Institution'], ['name' => 'City', 'title' => 'City']]]);
?>
</div>
</div>
<div class="row">
<div class="col-md-12 col-sm-12">
<h1 class="page-header">Students</h1>
</div>
</div>
<div class="row">
<div class="col-md-12 col-sm-12">
<?php
Easol_Widget::show("DataTableWidget", ['query' => $query, 'filter' => $filter, 'pagination' => $pagination, 'colOrderBy' => $colOrderBy, 'columns' => [['name' => 'StudentUSI', 'title' => 'Student Name', 'sortable' => true, 'sortField' => 'FirstName', 'type' => 'url', 'url' => function ($model) {
return site_url('student/profile/' . $model->StudentUSI);
}, 'value' => function ($model) {
return $model->FirstName . ' ' . $model->LastSurname;
}], ['name' => 'Description', 'sortable' => true, 'sortField' => 'GradeLevelType.Description', 'title' => 'Grade Level'], ['name' => 'CohortIdentifier', 'sortable' => true, 'sortField' => 'StudentCohortAssociation.CohortIdentifier', 'title' => 'Cohort']], 'downloadCSV' => true]);
?>
</div>
</div>
