<div class="row">
<div class="col-lg-12 col-md-12">
<p class="h4 bold"><?php
echo $Grupos;
?>
</p>
<p>Grupo(s)</p>
</div>
</div>
</div>
<div class="dashboard_footer red"></div>
<div class="clearfix"></div>
</article>
<article class="col-lg-3">
<?php
$read->ExeRead(DB_PSICO_GRUPOS, "WHERE grupo_status = 1 AND grupo_semana LIKE '%' :s '%'", "s=" . Check::TranslateDayweek(date('D')));
?>
<header class="dashboard_header blue">
<h1 class="h5"><i class="fa fa-lg fa-arrow-up"></i>SESSÕES EM GRUPO DE HOJE</h1>
</header>
<div class="dashboard_content">
<div class="row">
<div class="col-lg-12 col-md-12 small">
<?php
if ($read->getResult()) {
?>
<table class="table table-condensed table-hover">
<thead>
<tr class="bg-info">
<th>Nome: </th>
<th>-</th>
<th data-column-id="data">Data:</th>
<th data-column-id="chamada">Chamada Realizada:</th>
<th data-column-id="links" data-formatter="commands" data-sortable="false">-</th>
</tr>
</thead>
<tbody>
<?php
$readTurma->ExeRead(DB_AULAS, "WHERE curso_id = :id AND turma_id = :idt ORDER BY data ASC", "id={$cursoId}&idt={$turmaId}");
if ($readTurma->getResult()) {
foreach ($readTurma->getResult() as $tur) {
extract($tur);
$chamada_status = $chamada_status ? 'Sim' : 'Não';
?>
<tr>
<td><span><?php
echo Check::TranslateDayweek(date('D', strtotime($data)));
?>
</span></td>
<td><span><?php
echo date('d/m/Y', strtotime($data));
?>
</span></td>
<td><span><?php
echo $chamada_status;
?>
</span></td>
<td>
<?php
echo $cursoId . ',' . $turmaId . ',' . $id;
?>
</td>
private function UpdateClasses()
{
$readClass = new Read();
$createClass = new Create();
$deleteClass = new Delete();
$initialTime = strtotime($this->Data['turma_data_inicio']);
$finalTime = strtotime($this->Data['turma_data_termino']);
$timeClass = $finalTime - $initialTime;
$totalDaysClass = (int) floor($timeClass / (60 * 60 * 24));
$Class = ['curso_id' => $this->Data['curso_id'], 'turma_id' => $this->TurmaId, 'chamada_status' => '0', 'create_date' => date('Y-m-d H:i:s'), 'created_by' => $this->UserId];
for ($i = 0; $i <= $totalDaysClass; $i++) {
$dayClass = date('Y-m-d', strtotime($this->Data['turma_data_inicio'] . ' + ' . $i . ' days'));
$weekday = date('D', strtotime($dayClass));
$readClass->FullRead("SELECT data FROM " . DB_AULAS . " WHERE data = :data", "data=" . $dayClass);
if ($readClass->getResult()) {
if (strpos($this->Data['turma_semana'], Check::TranslateDayweek($weekday)) === false) {
$deleteClass->ExeDelete(DB_AULAS, "WHERE data = :data", "data=" . $dayClass);
}
} else {
if (strpos($this->Data['turma_semana'], Check::TranslateDayweek($weekday)) !== false) {
$Class['data'] = date('Y-m-d', strtotime($this->Data['turma_data_inicio'] . ' + ' . $i . ' days'));
$createClass->ExeCreate(DB_AULAS, $Class);
}
}
}
}
private function SomaHoras()
{
$numDays = cal_days_in_month(CAL_GREGORIAN, $this->Mes, $this->Ano);
$daysClass = 0;
list($horaInicio, $minInicio) = explode(":", $this->DataHeader['turma_hora_inicio']);
list($horaFinal, $minFinal) = explode(":", $this->DataHeader['turma_hora_termino']);
$totalMinutesPerClass = $horaFinal * 60 + $minFinal - ($horaInicio * 60 + $minInicio);
for ($i = 0; $i < $numDays; $i++) {
$dayClass = date('Y-m-d', strtotime($this->Ano . '-' . $this->Mes . '-01' . ' + ' . $i . ' days'));
$weekday = date('D', strtotime($dayClass));
if (strpos($this->DataHeader['turma_semana'], Check::TranslateDayweek($weekday)) !== false) {
$daysClass++;
}
}
$totalMinutes = $totalMinutesPerClass * $daysClass;
$totalHoras = floor($totalMinutes / 60);
$totalMinutes -= $totalHoras * 60;
return sprintf("%02d", $totalHoras) . "h" . sprintf("%02d", $totalMinutes) . "m";
}
