$data['abaPage'] = 'apresentacao_redigge';
$data['alias'] = 'apresentacao_redigge';
$this->load->view($this->load->getUrlTema(), $data);
}
public function evolucao()
{
$msg = null;
$data = $this->getParametroVisao();
if ($data['mobile']) {
$data['usuario'] = unserialize($_SESSION['usuario']);
$data['page'] = __FUNCTION__;
$data['tema'] = $this->load->setTheme('responsive');
} else {
$data['page'] = 'home';
$data['tema'] != '' ? $this->load->setTheme($data['tema']) : '';
}
$data['msg'] = $msg;
$data['abaAtiva'] = 21;
$data['abaPage'] = 'evolucao';
$data['alias'] = 'evolucao';
$pk_aluno_usuario = (int) substr($this->uri->segment(4), 1);
$sqlRedigge = new SqlRedigge();
$dados = $sqlRedigge->get_dados_evolucao($pk_aluno_usuario);
$data['total'] = count($dados);
$total = count($dados);
// gráfico de evolução
$html = '<script type="text/javascript" src="https://www.google.com/jsapi"></script>';
$html .= '<script type="text/javascript">';
$html .= ' google.load("visualization", "1", {packages:["corechart"]});';
$html .= ' google.setOnLoadCallback(drawChart);';
$html .= ' function drawChart() {';
$html .= ' var data = google.visualization.arrayToDataTable([';
$html .= ' [\'Sequência\', \'Média geral\', \'Aluno\', \'link\'],';
$registros = '';
$i = 0;
foreach ($dados as $dado) {
$i++;
$registros .= ' [\'' . $dado['titulo'] . '\', ' . number_format($dado['media'], 1) . ', ' . number_format($dado['nota'], 1) . ', \'' . base_url() . 'redigge/tema/detalhe_aluno/' . $dado['fk_redigge'] . '/' . $dado['fk_usuario'] . '?shadowbox=1/\'],';
}
$html .= substr($registros, 0, -1);
$html .= ' ]);';
$html .= ' var view = new google.visualization.DataView(data);';
$html .= ' view.setColumns([0, 1, 2]);';
$html .= ' var options = {';
$html .= ' title: \'Título\'';
$html .= ' };';
if ($total < 3) {
$html .= ' var chart = new google.visualization.ColumnChart(';
} else {
$html .= ' var chart = new google.visualization.LineChart(';
}
$html .= ' document.getElementById(\'chart_div\'));';
$html .= ' chart.draw(view, options);';
$html .= ' var selectHandler = function(e) {';
$html .= ' window.location = data.getValue(chart.getSelection()[0][\'row\'], 3 );';
$html .= ' };';
$html .= ' google.visualization.events.addListener(chart, \'select\', selectHandler);';
$html .= ' }';
$html .= '</script>';
if ($data['mobile']) {
$html .= '<div id="chart_div"></div>';
} else {
$html .= '<div id="chart_div" style="width: 800px; height: 300px;"></div>';
