/**
* Creates a new Frequencia model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate($date)
{
$model = new Frequencia();
$p = PeriodoInscricaoMonitoria::find()->orderBy(['id' => SORT_DESC])->one();
//$letivo = $p->ano.'/'.$p->periodo;
$aluno = AlunoMonitoria::find()->where(['cpf' => Yii::$app->user->identity->cpf])->andWhere(['IDperiodoinscr' => $p->id])->andFilterWhere(['or', ['like', 'status', 'Selecionado com bolsa'], ['like', 'status', 'Selecionado sem bolsa']])->one();
// pesquisa para pegar o id do alun
$model->dmy = $date;
$pesquisa = Frequencia::find()->where(['IDMonitoria' => $aluno->id])->andWhere(['dmy' => $date])->one();
// Serve para verificar se tem registro na data selecionada.
if (empty($pesquisa)) {
if ($model->load(Yii::$app->request->post())) {
$numDia = date('w', strtotime($date));
$cont = $flag = 0;
$dia1 = strtotime('-' . $numDia . ' day', strtotime($date));
$diaX = strtotime('+' . (6 - $numDia) . ' day', strtotime($date));
$p = Frequencia::find()->where(['IDMonitoria' => $aluno->id])->andWhere(['>=', 'dmy', date("Y-m-d", $dia1)])->andWhere(['<=', 'dmy', date("Y-m-d", $diaX)])->all();
foreach ($p as $f) {
$cont = $cont + $f->ch;
if ($cont > 12) {
$flag = 1;
}
}
if ($flag == 0 && $model->ch + $cont <= 12) {
$model->IDMonitoria = $aluno->id;
$model->save();
return $this->redirect(['index', 'id' => $model->IDMonitoria]);
} else {
return $this->redirect(['index', 'id' => $aluno->id, 'mensagem' => 'Carga não cadastrada por conta do excesso de horas.']);
}
} else {
return $this->renderAjax('create', ['model' => $model]);
}
} else {
return $this->redirect(['index', 'id' => $aluno->id, 'mensagem' => 'Já existe registro nesta data para a sua monitoria.']);
}
}
public function actionFrequenciaindividual()
{
$modelPeriodo = DisciplinaPeriodo::find()->orderBy(['anoPeriodo' => SORT_DESC, 'numPeriodo' => SORT_DESC])->one();
$periodoletivo = $modelPeriodo->anoPeriodo . '/' . $modelPeriodo->numPeriodo;
$dadosCabecalho = Periodo::find()->where(['codigo' => $periodoletivo])->one();
$monitor = Usuario::find()->where(['cpf' => Yii::$app->user->identity->cpf])->one();
$monitoria = AlunoMonitoria::find()->where(['periodo' => $periodoletivo])->andWhere(['IDAluno' => $monitor->id])->andFilterWhere(['or', ['like', 'status', 'Selecionado com bolsa'], ['like', 'status', 'Selecionado sem bolsa']])->one();
if ($monitoria == null) {
return $this->render('index', ['erro' => 1]);
} else {
$disc = DisciplinaMonitoria::find()->where(['id' => $monitoria->id_disciplina])->one();
}
if ($dadosCabecalho != null) {
$cssfile = file_get_contents('../web/css/estilo5.css');
$mpdf = new mPDF('utf-8', 'A4-L');
$mpdf->title = '3. Frequência Individual';
$mpdf->WriteHTML($cssfile, 1);
// Cabeçalho do doc
$mpdf->SetHTMLHeader('
<img src="../web/img/cabecalho5.png" alt="Universidade Federal do Amazonas...." width="980" height="100">
');
$mes = Monitoria::nomeMes(date('m') - 1);
$ano = date('Y');
if ($mes == 0) {
$mes = 12;
$ano = $ano - 1;
}
$mesNome = Monitoria::nomeMes($mes);
$mpdf->WriteHTML('
<br><br><br><br>
<table id="periodoLetivo_mesAno" width="56%">
<tr>
<td bgcolor="#e6e6e6" width="7%">PERÍODO LETIVO</td>
<td width="21%">' . $periodoletivo . '</td>
<td bgcolor="#e6e6e6" width="7%">MÊS/ANO</td>
<td width="21%">' . $mesNome . '/' . $ano . '</td>
</tr>
</table>
<br>
<table id="department_unity" width="99%">
<tr>
<td bgcolor="#e6e6e6" width="11%">DEPARTAMENTO</td>
<td width="40%">Coordenação Acadêmica</td>
<td bgcolor="#e6e6e6" width="10%">UNIDADE</td>
<td width="28%">Instituto de Computação - IComp</td>
</tr>
</table>
<br>
<table id="disc_dados" width="99%">
<tr>
<td bgcolor="#e6e6e6" width="25%">DISCIPLINA<br>(código e título sem abreviações)</td>
<td width="74%">' . $disc->codDisciplina . ' - ' . $monitoria->nomeDisciplina . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<br>
<table id="prof_monitor" width="99%">
<tr>
<td bgcolor="#e6e6e6" width="49%">PROFESSOR ORIENTADOR<br>(nome completo, sem abreviações e assinatura)</td>
<td bgcolor="#e6e6e6" width="50%">MONITOR<br>(nome completo, sem abreviações, nº de matrícula e assinatura)</td>
</tr>
<tr>
<td width="49%" align="left">Nome completo: ' . $monitoria->professor . '</td>
<td width="50%" align="left">Nome completo: ' . $monitoria->aluno . '</td>
</tr>
<tr>
<td width="49%" height="50" align="left">Ass:</td>
<td width="50%" height="50" align="left">Ass:</td>
</tr>
</table>
<br>
');
$array_diaSemana = array();
$array_diaMes = array();
$array_carga = array();
$cont_dia = 1;
$dia = $ano . '-' . $mes . '-01';
// O primeiro dia (data) do mês anterior
$diaTotal = date('d', strtotime(date('Y-m-t', strtotime($dia))));
while ($cont_dia <= $diaTotal) {
$f = Frequencia::find()->where(['dmy' => $dia])->andWhere(['>=', 'IDMonitoria', $monitoria->id])->one();
if ($f != null) {
$array_carga[] = $f->ch;
} else {
$array_carga[] = '-';
}
$array_diaSemana[] = Monitoria::nomeDia(date('w', strtotime($dia)));
// Pega tradução do dia da semana e põe no array
$aux = strtotime("+1 day", strtotime($dia));
$dia = date('Y-m-d', $aux);
$array_diaMes[] = $cont_dia;
// Põe o dia no array
$cont_dia++;
}
//return $this->render('index');
if ($diaTotal == 28) {
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="900px">
<tr>
<td bgcolor="#e6e6e6" >
<img src="../web/img/dia_da_semana.png" alt="DIA DA SEMANA" width="42px" height="50px">
</td>
<td width="30px">' . $array_diaSemana[0] . '</td> <td width="30px">' . $array_diaSemana[1] . '</td> <td width="30px">' . $array_diaSemana[2] . '</td>
<td width="30px">' . $array_diaSemana[3] . '</td> <td width="30px">' . $array_diaSemana[4] . '</td> <td width="30px">' . $array_diaSemana[5] . '</td>
<td width="30px">' . $array_diaSemana[6] . '</td> <td width="30px">' . $array_diaSemana[7] . '</td> <td width="30px">' . $array_diaSemana[8] . '</td>
<td width="30px">' . $array_diaSemana[9] . '</td> <td width="30px">' . $array_diaSemana[10] . '</td> <td width="30px">' . $array_diaSemana[11] . '</td>
<td width="30px">' . $array_diaSemana[12] . '</td> <td width="30px">' . $array_diaSemana[13] . '</td> <td width="30px">' . $array_diaSemana[14] . '</td>
<td width="30px">' . $array_diaSemana[15] . '</td> <td width="30px">' . $array_diaSemana[16] . '</td> <td width="30px">' . $array_diaSemana[17] . '</td>
<td width="30px">' . $array_diaSemana[18] . '</td> <td width="30px">' . $array_diaSemana[19] . '</td> <td width="30px">' . $array_diaSemana[20] . '</td>
<td width="30px">' . $array_diaSemana[21] . '</td> <td width="30px">' . $array_diaSemana[22] . '</td> <td width="30px">' . $array_diaSemana[23] . '</td>
<td width="30px">' . $array_diaSemana[24] . '</td> <td width="30px">' . $array_diaSemana[25] . '</td> <td width="30px">' . $array_diaSemana[26] . '</td>
<td width="30px">' . $array_diaSemana[27] . '</td> <td width="30px">' . $array_diaSemana[28] . '</td> <td width="30px">' . $array_diaSemana[29] . '</td>
<td width="30px">' . $array_diaSemana[30] . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="902px">
<tr>
<td bgcolor="#e6e6e6" >
<img src="../web/img/dia_do_mes.png" alt="DIA DO MÊS" width="42px" height="50px">
</td>
<td width="30px">' . $array_diaMes[0] . '</td> <td width="30px">' . $array_diaMes[1] . '</td> <td width="30px">' . $array_diaMes[2] . '</td>
<td width="30px">' . $array_diaMes[3] . '</td> <td width="30px">' . $array_diaMes[4] . '</td> <td width="30px">' . $array_diaMes[5] . '</td>
<td width="30px">' . $array_diaMes[6] . '</td> <td width="30px">' . $array_diaMes[7] . '</td> <td width="30px">' . $array_diaMes[8] . '</td>
<td width="30px">' . $array_diaMes[9] . '</td> <td width="30px">' . $array_diaMes[10] . '</td> <td width="30px">' . $array_diaMes[11] . '</td>
<td width="30px">' . $array_diaMes[12] . '</td> <td width="30px">' . $array_diaMes[13] . '</td> <td width="30px">' . $array_diaMes[14] . '</td>
<td width="30px">' . $array_diaMes[15] . '</td> <td width="30px">' . $array_diaMes[16] . '</td> <td width="30px">' . $array_diaMes[17] . '</td>
<td width="30px">' . $array_diaMes[18] . '</td> <td width="30px">' . $array_diaMes[19] . '</td> <td width="30px">' . $array_diaMes[20] . '</td>
<td width="30px">' . $array_diaMes[21] . '</td> <td width="30px">' . $array_diaMes[22] . '</td> <td width="30px">' . $array_diaMes[23] . '</td>
<td width="30px">' . $array_diaMes[24] . '</td> <td width="30px">' . $array_diaMes[25] . '</td> <td width="30px">' . $array_diaMes[26] . '</td>
<td width="30px">' . $array_diaMes[27] . '</td> <td width="30px">' . $array_diaMes[28] . '</td> <td width="30px">' . $array_diaMes[29] . '</td>
<td width="30px">' . $array_diaMes[30] . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="90px">
<tr>
<td bgcolor="#e6e6e6">
<img src="../web/img/carga_horaria.png" alt="CARGA HORÁRIA" width="42px" height="50px">
</td>
<td width="30px">' . $array_carga[0] . '</td> <td width="30px">' . $array_carga[1] . '</td> <td width="30px">' . $array_carga[2] . '</td>
<td width="30px">' . $array_carga[3] . '</td> <td width="30px">' . $array_carga[4] . '</td> <td width="30px">' . $array_carga[5] . '</td>
<td width="30px">' . $array_carga[6] . '</td> <td width="30px">' . $array_carga[7] . '</td> <td width="30px">' . $array_carga[8] . '</td>
<td width="30px">' . $array_carga[9] . '</td> <td width="30px">' . $array_carga[10] . '</td> <td width="30px">' . $array_carga[11] . '</td>
<td width="30px">' . $array_carga[12] . '</td> <td width="30px">' . $array_carga[13] . '</td> <td width="30px">' . $array_carga[14] . '</td>
<td width="30px">' . $array_carga[15] . '</td> <td width="30px">' . $array_carga[16] . '</td> <td width="30px">' . $array_carga[17] . '</td>
<td width="30px">' . $array_carga[18] . '</td> <td width="30px">' . $array_carga[19] . '</td> <td width="30px">' . $array_carga[20] . '</td>
<td width="30px">' . $array_carga[21] . '</td> <td width="30px">' . $array_carga[22] . '</td> <td width="30px">' . $array_carga[23] . '</td>
<td width="30px">' . $array_carga[24] . '</td> <td width="30px">' . $array_carga[25] . '</td> <td width="30px">' . $array_carga[26] . '</td>
<td width="30px">' . $array_carga[27] . '</td> <td width="30px"> -- </td> <td width="30px"> -- </td>
<td width="30px"> -- </td>
</tr>
</table>
');
} elseif ($diaTotal == 29) {
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="900px">
<tr>
<td bgcolor="#e6e6e6" >
<img src="../web/img/dia_da_semana.png" alt="DIA DA SEMANA" width="42px" height="50px">
</td>
<td width="30px">' . $array_diaSemana[0] . '</td> <td width="30px">' . $array_diaSemana[1] . '</td> <td width="30px">' . $array_diaSemana[2] . '</td>
<td width="30px">' . $array_diaSemana[3] . '</td> <td width="30px">' . $array_diaSemana[4] . '</td> <td width="30px">' . $array_diaSemana[5] . '</td>
<td width="30px">' . $array_diaSemana[6] . '</td> <td width="30px">' . $array_diaSemana[7] . '</td> <td width="30px">' . $array_diaSemana[8] . '</td>
<td width="30px">' . $array_diaSemana[9] . '</td> <td width="30px">' . $array_diaSemana[10] . '</td> <td width="30px">' . $array_diaSemana[11] . '</td>
<td width="30px">' . $array_diaSemana[12] . '</td> <td width="30px">' . $array_diaSemana[13] . '</td> <td width="30px">' . $array_diaSemana[14] . '</td>
<td width="30px">' . $array_diaSemana[15] . '</td> <td width="30px">' . $array_diaSemana[16] . '</td> <td width="30px">' . $array_diaSemana[17] . '</td>
<td width="30px">' . $array_diaSemana[18] . '</td> <td width="30px">' . $array_diaSemana[19] . '</td> <td width="30px">' . $array_diaSemana[20] . '</td>
<td width="30px">' . $array_diaSemana[21] . '</td> <td width="30px">' . $array_diaSemana[22] . '</td> <td width="30px">' . $array_diaSemana[23] . '</td>
<td width="30px">' . $array_diaSemana[24] . '</td> <td width="30px">' . $array_diaSemana[25] . '</td> <td width="30px">' . $array_diaSemana[26] . '</td>
<td width="30px">' . $array_diaSemana[27] . '</td> <td width="30px">' . $array_diaSemana[28] . '</td> <td width="30px">' . $array_diaSemana[29] . '</td>
<td width="30px">' . $array_diaSemana[30] . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="902px">
<tr>
<td bgcolor="#e6e6e6" >
<img src="../web/img/dia_do_mes.png" alt="DIA DO MÊS" width="42px" height="50px">
</td>
<td width="30px">' . $array_diaMes[0] . '</td> <td width="30px">' . $array_diaMes[1] . '</td> <td width="30px">' . $array_diaMes[2] . '</td>
<td width="30px">' . $array_diaMes[3] . '</td> <td width="30px">' . $array_diaMes[4] . '</td> <td width="30px">' . $array_diaMes[5] . '</td>
<td width="30px">' . $array_diaMes[6] . '</td> <td width="30px">' . $array_diaMes[7] . '</td> <td width="30px">' . $array_diaMes[8] . '</td>
<td width="30px">' . $array_diaMes[9] . '</td> <td width="30px">' . $array_diaMes[10] . '</td> <td width="30px">' . $array_diaMes[11] . '</td>
<td width="30px">' . $array_diaMes[12] . '</td> <td width="30px">' . $array_diaMes[13] . '</td> <td width="30px">' . $array_diaMes[14] . '</td>
<td width="30px">' . $array_diaMes[15] . '</td> <td width="30px">' . $array_diaMes[16] . '</td> <td width="30px">' . $array_diaMes[17] . '</td>
<td width="30px">' . $array_diaMes[18] . '</td> <td width="30px">' . $array_diaMes[19] . '</td> <td width="30px">' . $array_diaMes[20] . '</td>
<td width="30px">' . $array_diaMes[21] . '</td> <td width="30px">' . $array_diaMes[22] . '</td> <td width="30px">' . $array_diaMes[23] . '</td>
<td width="30px">' . $array_diaMes[24] . '</td> <td width="30px">' . $array_diaMes[25] . '</td> <td width="30px">' . $array_diaMes[26] . '</td>
<td width="30px">' . $array_diaMes[27] . '</td> <td width="30px">' . $array_diaMes[28] . '</td> <td width="30px">' . $array_diaMes[29] . '</td>
<td width="30px">' . $array_diaMes[30] . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="90px">
<tr>
<td bgcolor="#e6e6e6">
<img src="../web/img/carga_horaria.png" alt="CARGA HORÁRIA" width="42px" height="50px">
</td>
<td width="30px">' . $array_carga[0] . '</td> <td width="30px">' . $array_carga[1] . '</td> <td width="30px">' . $array_carga[2] . '</td>
<td width="30px">' . $array_carga[3] . '</td> <td width="30px">' . $array_carga[4] . '</td> <td width="30px">' . $array_carga[5] . '</td>
<td width="30px">' . $array_carga[6] . '</td> <td width="30px">' . $array_carga[7] . '</td> <td width="30px">' . $array_carga[8] . '</td>
<td width="30px">' . $array_carga[9] . '</td> <td width="30px">' . $array_carga[10] . '</td> <td width="30px">' . $array_carga[11] . '</td>
<td width="30px">' . $array_carga[12] . '</td> <td width="30px">' . $array_carga[13] . '</td> <td width="30px">' . $array_carga[14] . '</td>
<td width="30px">' . $array_carga[15] . '</td> <td width="30px">' . $array_carga[16] . '</td> <td width="30px">' . $array_carga[17] . '</td>
<td width="30px">' . $array_carga[18] . '</td> <td width="30px">' . $array_carga[19] . '</td> <td width="30px">' . $array_carga[20] . '</td>
<td width="30px">' . $array_carga[21] . '</td> <td width="30px">' . $array_carga[22] . '</td> <td width="30px">' . $array_carga[23] . '</td>
<td width="30px">' . $array_carga[24] . '</td> <td width="30px">' . $array_carga[25] . '</td> <td width="30px">' . $array_carga[26] . '</td>
<td width="30px">' . $array_carga[27] . '</td> <td width="30px">' . $array_carga[28] . '</td> <td width="30px"> -- </td>
<td width="30px"> -- </td>
</tr>
</table>
');
} elseif ($diaTotal == 30) {
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="900px">
<tr>
<td bgcolor="#e6e6e6" >
<img src="../web/img/dia_da_semana.png" alt="DIA DA SEMANA" width="42px" height="50px">
</td>
<td width="30px">' . $array_diaSemana[0] . '</td> <td width="30px">' . $array_diaSemana[1] . '</td> <td width="30px">' . $array_diaSemana[2] . '</td>
<td width="30px">' . $array_diaSemana[3] . '</td> <td width="30px">' . $array_diaSemana[4] . '</td> <td width="30px">' . $array_diaSemana[5] . '</td>
<td width="30px">' . $array_diaSemana[6] . '</td> <td width="30px">' . $array_diaSemana[7] . '</td> <td width="30px">' . $array_diaSemana[8] . '</td>
<td width="30px">' . $array_diaSemana[9] . '</td> <td width="30px">' . $array_diaSemana[10] . '</td> <td width="30px">' . $array_diaSemana[11] . '</td>
<td width="30px">' . $array_diaSemana[12] . '</td> <td width="30px">' . $array_diaSemana[13] . '</td> <td width="30px">' . $array_diaSemana[14] . '</td>
<td width="30px">' . $array_diaSemana[15] . '</td> <td width="30px">' . $array_diaSemana[16] . '</td> <td width="30px">' . $array_diaSemana[17] . '</td>
<td width="30px">' . $array_diaSemana[18] . '</td> <td width="30px">' . $array_diaSemana[19] . '</td> <td width="30px">' . $array_diaSemana[20] . '</td>
<td width="30px">' . $array_diaSemana[21] . '</td> <td width="30px">' . $array_diaSemana[22] . '</td> <td width="30px">' . $array_diaSemana[23] . '</td>
<td width="30px">' . $array_diaSemana[24] . '</td> <td width="30px">' . $array_diaSemana[25] . '</td> <td width="30px">' . $array_diaSemana[26] . '</td>
<td width="30px">' . $array_diaSemana[27] . '</td> <td width="30px">' . $array_diaSemana[28] . '</td> <td width="30px">' . $array_diaSemana[29] . '</td>
<td width="30px">' . $array_diaSemana[30] . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="902px">
<tr>
<td bgcolor="#e6e6e6" >
<img src="../web/img/dia_do_mes.png" alt="DIA DO MÊS" width="42px" height="50px">
</td>
<td width="30px">' . $array_diaMes[0] . '</td> <td width="30px">' . $array_diaMes[1] . '</td> <td width="30px">' . $array_diaMes[2] . '</td>
<td width="30px">' . $array_diaMes[3] . '</td> <td width="30px">' . $array_diaMes[4] . '</td> <td width="30px">' . $array_diaMes[5] . '</td>
<td width="30px">' . $array_diaMes[6] . '</td> <td width="30px">' . $array_diaMes[7] . '</td> <td width="30px">' . $array_diaMes[8] . '</td>
<td width="30px">' . $array_diaMes[9] . '</td> <td width="30px">' . $array_diaMes[10] . '</td> <td width="30px">' . $array_diaMes[11] . '</td>
<td width="30px">' . $array_diaMes[12] . '</td> <td width="30px">' . $array_diaMes[13] . '</td> <td width="30px">' . $array_diaMes[14] . '</td>
<td width="30px">' . $array_diaMes[15] . '</td> <td width="30px">' . $array_diaMes[16] . '</td> <td width="30px">' . $array_diaMes[17] . '</td>
<td width="30px">' . $array_diaMes[18] . '</td> <td width="30px">' . $array_diaMes[19] . '</td> <td width="30px">' . $array_diaMes[20] . '</td>
<td width="30px">' . $array_diaMes[21] . '</td> <td width="30px">' . $array_diaMes[22] . '</td> <td width="30px">' . $array_diaMes[23] . '</td>
<td width="30px">' . $array_diaMes[24] . '</td> <td width="30px">' . $array_diaMes[25] . '</td> <td width="30px">' . $array_diaMes[26] . '</td>
<td width="30px">' . $array_diaMes[27] . '</td> <td width="30px">' . $array_diaMes[28] . '</td> <td width="30px">' . $array_diaMes[29] . '</td>
<td width="30px">' . $array_diaMes[30] . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="90px">
<tr>
<td bgcolor="#e6e6e6">
<img src="../web/img/carga_horaria.png" alt="CARGA HORÁRIA" width="42px" height="50px">
</td>
<td width="30px">' . $array_carga[0] . '</td> <td width="30px">' . $array_carga[1] . '</td> <td width="30px">' . $array_carga[2] . '</td>
<td width="30px">' . $array_carga[3] . '</td> <td width="30px">' . $array_carga[4] . '</td> <td width="30px">' . $array_carga[5] . '</td>
<td width="30px">' . $array_carga[6] . '</td> <td width="30px">' . $array_carga[7] . '</td> <td width="30px">' . $array_carga[8] . '</td>
<td width="30px">' . $array_carga[9] . '</td> <td width="30px">' . $array_carga[10] . '</td> <td width="30px">' . $array_carga[11] . '</td>
<td width="30px">' . $array_carga[12] . '</td> <td width="30px">' . $array_carga[13] . '</td> <td width="30px">' . $array_carga[14] . '</td>
<td width="30px">' . $array_carga[15] . '</td> <td width="30px">' . $array_carga[16] . '</td> <td width="30px">' . $array_carga[17] . '</td>
<td width="30px">' . $array_carga[18] . '</td> <td width="30px">' . $array_carga[19] . '</td> <td width="30px">' . $array_carga[20] . '</td>
<td width="30px">' . $array_carga[21] . '</td> <td width="30px">' . $array_carga[22] . '</td> <td width="30px">' . $array_carga[23] . '</td>
<td width="30px">' . $array_carga[24] . '</td> <td width="30px">' . $array_carga[25] . '</td> <td width="30px">' . $array_carga[26] . '</td>
<td width="30px">' . $array_carga[27] . '</td> <td width="30px">' . $array_carga[28] . '</td> <td width="30px">' . $array_carga[29] . '</td>
<td width="30px"> -- </td>
</tr>
</table>
');
} elseif ($diaTotal == 31) {
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="900px">
<tr>
<td bgcolor="#e6e6e6" >
<img src="../web/img/dia_da_semana.png" alt="DIA DA SEMANA" width="42px" height="50px">
</td>
<td width="30px">' . $array_diaSemana[0] . '</td> <td width="30px">' . $array_diaSemana[1] . '</td> <td width="30px">' . $array_diaSemana[2] . '</td>
<td width="30px">' . $array_diaSemana[3] . '</td> <td width="30px">' . $array_diaSemana[4] . '</td> <td width="30px">' . $array_diaSemana[5] . '</td>
<td width="30px">' . $array_diaSemana[6] . '</td> <td width="30px">' . $array_diaSemana[7] . '</td> <td width="30px">' . $array_diaSemana[8] . '</td>
<td width="30px">' . $array_diaSemana[9] . '</td> <td width="30px">' . $array_diaSemana[10] . '</td> <td width="30px">' . $array_diaSemana[11] . '</td>
<td width="30px">' . $array_diaSemana[12] . '</td> <td width="30px">' . $array_diaSemana[13] . '</td> <td width="30px">' . $array_diaSemana[14] . '</td>
<td width="30px">' . $array_diaSemana[15] . '</td> <td width="30px">' . $array_diaSemana[16] . '</td> <td width="30px">' . $array_diaSemana[17] . '</td>
<td width="30px">' . $array_diaSemana[18] . '</td> <td width="30px">' . $array_diaSemana[19] . '</td> <td width="30px">' . $array_diaSemana[20] . '</td>
<td width="30px">' . $array_diaSemana[21] . '</td> <td width="30px">' . $array_diaSemana[22] . '</td> <td width="30px">' . $array_diaSemana[23] . '</td>
<td width="30px">' . $array_diaSemana[24] . '</td> <td width="30px">' . $array_diaSemana[25] . '</td> <td width="30px">' . $array_diaSemana[26] . '</td>
<td width="30px">' . $array_diaSemana[27] . '</td> <td width="30px">' . $array_diaSemana[28] . '</td> <td width="30px">' . $array_diaSemana[29] . '</td>
<td width="30px">' . $array_diaSemana[30] . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="902px">
<tr>
<td bgcolor="#e6e6e6" >
<img src="../web/img/dia_do_mes.png" alt="DIA DO MÊS" width="42px" height="50px">
</td>
<td width="30px">' . $array_diaMes[0] . '</td> <td width="30px">' . $array_diaMes[1] . '</td> <td width="30px">' . $array_diaMes[2] . '</td>
<td width="30px">' . $array_diaMes[3] . '</td> <td width="30px">' . $array_diaMes[4] . '</td> <td width="30px">' . $array_diaMes[5] . '</td>
<td width="30px">' . $array_diaMes[6] . '</td> <td width="30px">' . $array_diaMes[7] . '</td> <td width="30px">' . $array_diaMes[8] . '</td>
<td width="30px">' . $array_diaMes[9] . '</td> <td width="30px">' . $array_diaMes[10] . '</td> <td width="30px">' . $array_diaMes[11] . '</td>
<td width="30px">' . $array_diaMes[12] . '</td> <td width="30px">' . $array_diaMes[13] . '</td> <td width="30px">' . $array_diaMes[14] . '</td>
<td width="30px">' . $array_diaMes[15] . '</td> <td width="30px">' . $array_diaMes[16] . '</td> <td width="30px">' . $array_diaMes[17] . '</td>
<td width="30px">' . $array_diaMes[18] . '</td> <td width="30px">' . $array_diaMes[19] . '</td> <td width="30px">' . $array_diaMes[20] . '</td>
<td width="30px">' . $array_diaMes[21] . '</td> <td width="30px">' . $array_diaMes[22] . '</td> <td width="30px">' . $array_diaMes[23] . '</td>
<td width="30px">' . $array_diaMes[24] . '</td> <td width="30px">' . $array_diaMes[25] . '</td> <td width="30px">' . $array_diaMes[26] . '</td>
<td width="30px">' . $array_diaMes[27] . '</td> <td width="30px">' . $array_diaMes[28] . '</td> <td width="30px">' . $array_diaMes[29] . '</td>
<td width="30px">' . $array_diaMes[30] . '</td>
</tr>
</table>
');
$mpdf->WriteHTML('
<table id="calendario" height="25px" width="90px">
<tr>
<td bgcolor="#e6e6e6">
<img src="../web/img/carga_horaria.png" alt="CARGA HORÁRIA" width="42px" height="50px">
</td>
<td width="30px">' . $array_carga[0] . '</td> <td width="30px">' . $array_carga[1] . '</td> <td width="30px">' . $array_carga[2] . '</td>
<td width="30px">' . $array_carga[3] . '</td> <td width="30px">' . $array_carga[4] . '</td> <td width="30px">' . $array_carga[5] . '</td>
<td width="30px">' . $array_carga[6] . '</td> <td width="30px">' . $array_carga[7] . '</td> <td width="30px">' . $array_carga[8] . '</td>
<td width="30px">' . $array_carga[9] . '</td> <td width="30px">' . $array_carga[10] . '</td> <td width="30px">' . $array_carga[11] . '</td>
<td width="30px">' . $array_carga[12] . '</td> <td width="30px">' . $array_carga[13] . '</td> <td width="30px">' . $array_carga[14] . '</td>
<td width="30px">' . $array_carga[15] . '</td> <td width="30px">' . $array_carga[16] . '</td> <td width="30px">' . $array_carga[17] . '</td>
<td width="30px">' . $array_carga[18] . '</td> <td width="30px">' . $array_carga[19] . '</td> <td width="30px">' . $array_carga[20] . '</td>
<td width="30px">' . $array_carga[21] . '</td> <td width="30px">' . $array_carga[22] . '</td> <td width="30px">' . $array_carga[23] . '</td>
<td width="30px">' . $array_carga[24] . '</td> <td width="30px">' . $array_carga[25] . '</td> <td width="30px">' . $array_carga[26] . '</td>
<td width="30px">' . $array_carga[27] . '</td> <td width="30px">' . $array_carga[28] . '</td> <td width="30px">' . $array_carga[29] . '</td>
<td width="30px">' . $array_carga[30] . '</td>
</tr>
</table>
');
}
$mpdf->WriteHTML('
<br>
<table id="assinatura" style="margin-left:30em;">
<tr>
<td bgcolor="#e6e6e6" text-align:center>
VISTO DA CHEFIA <br>DO DEPARTAMENTO ACADÊMICO <br> (COM CARIMBO)
</td>
<td width="70%" height="100"> </td>
</tr>
</table>');
$mpdf->Output();
exit;
} else {
return $this->render('index', ['erro' => 2]);
}
}
<h3><?php
echo Html::encode($this->title);
?>
</h3>
<?php
// echo $this->render('_search', ['model' => $searchModel]);
?>
<p>
<?php
echo Html::a('Plano Semestral', ['planosemestral'], ['class' => 'btn btn-success']);
?>
<?php
echo Html::a('Quadro Geral', ['gerarquadrogeral'], ['class' => 'btn btn-success']);
?>
<?php
echo Html::a('Frequência Geral', ['frequenciageral'], ['class' => 'btn btn-success']);
?>
</p>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'summary' => '', 'showHeader' => true, 'columns' => [['attribute' => 'aluno', 'label' => 'Nome Aluno'], ['attribute' => 'codDisciplina', 'label' => 'Cod. Disciplina'], 'nomeDisciplina', 'professor', ['attribute' => 'periodo', 'filter' => ArrayHelper::map(AlunoMonitoria::find()->distinct()->orderBy(['periodo' => SORT_DESC])->asArray()->all(), 'periodo', 'periodo')], ['attribute' => 'codTurma', 'label' => 'Turma'], 'nomeCurso', ['attribute' => 'bolsa_traducao', 'filter' => array("Sim" => "Sim", "Não" => "Não")], ['attribute' => 'status', 'filter' => array("Aguardando Avaliação" => "Aguardando Avaliação", "Selecionado com bolsa" => "Selecionado com bolsa", "Selecionado sem bolsa" => "Selecionado sem bolsa", "Não selecionado" => "Não selecionado", "Indeferido - Nota < 7" => "Indeferido - Nota < 7", "Indeferido - Coeficiente < 5" => "Indeferido - Coeficiente < 5", "Indeferido - Não cursou a disciplina" => "Indeferido - Não cursou a disciplina")], ['class' => 'yii\\grid\\ActionColumn', 'header' => 'Ações', 'headerOptions' => ['style' => 'text-align:center; color:#337AB7'], 'contentOptions' => ['style' => 'text-align:center; vertical-align:middle'], 'template' => '{view}', 'buttons' => ['view' => function ($url, $model) {
return Html::a('<span class="glyphicon glyphicon-eye-open"></span>', ['monitoria/view', 'id' => $model->id], ['title' => 'Detalhar', 'aria-label' => 'Detalhar', 'data-pjax' => '0']);
}]]]]);
?>
<a href="?r=monitoria/index" class="btn btn-default">Voltar</a>
</div>
public function searchAvaliador($params)
{
$query = AlunoMonitoria::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id]);
$query->andFilterWhere(['like', 'aluno', $this->aluno]);
$query->andFilterWhere(['like', 'matricula', $this->matricula]);
$query->andFilterWhere(['like', 'cpf', $this->cpf]);
$query->andFilterWhere(['like', 'codDisciplina', $this->codDisciplina]);
$query->andFilterWhere(['like', 'nomeDisciplina', $this->nomeDisciplina]);
$query->andFilterWhere(['like', 'codTurma', $this->codTurma]);
$query->andFilterWhere(['like', 'professor', $this->professor]);
$query->andFilterWhere(['like', 'nomeCurso', $this->nomeCurso]);
$query->andFilterWhere(['like', 'bolsa_traducao', $this->bolsa_traducao]);
$query->andFilterWhere(['like', 'status', $this->status]);
$query->andFilterWhere(['like', 'periodo', $this->periodo]);
$query->orderBy(['id' => SORT_DESC]);
return $dataProvider;
}
