public function validateFieldsUnique($attribute, $params)
{
$modelAux = DisciplinaPeriodo::findOne(['idDisciplina' => $this->idDisciplina, 'codTurma' => $this->codTurma, 'anoPeriodo' => $this->anoPeriodo, 'numPeriodo' => $this->numPeriodo]);
if ($modelAux != null) {
if ($modelAux->id != $this->id) {
$this->addError($attribute, 'O conjunto (Disciplina, Código Turma, Ano Período e Número Período) já existem no sistema.');
}
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = DisciplinaPeriodo::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->joinWith(['disciplina']);
$query->joinWith(['curso']);
$query->joinWith(['professor']);
$query->andFilterWhere(['id' => $this->id, 'qtdVagas' => $this->qtdVagas, 'numPeriodo' => $this->numPeriodo, 'anoPeriodo' => $this->anoPeriodo, 'dataInicioPeriodo' => $this->dataInicioPeriodo, 'dataFimPeriodo' => $this->dataFimPeriodo, 'usaLaboratorio' => $this->usaLaboratorio]);
$query->andFilterWhere(['like', 'codTurma', $this->codTurma])->andFilterWhere(['like', 'nomeUnidade', $this->nomeUnidade]);
$query->andFilterWhere(['like', 'disciplina.nomeDisciplina', $this->idDisciplina]);
$query->andFilterWhere(['like', 'curso.nome', $this->idCurso]);
$query->andFilterWhere(['like', 'professor.Nome', $this->idProfessor]);
return $dataProvider;
}
public function actionImportarcsv()
{
$model = new DisciplinaPeriodo(['scenario' => 'csv']);
$erros = array();
$erroFatal = '';
$COD_CURSO = null;
$NOME_DOCENTE = null;
$COD_DISCIPLINA = null;
$COD_TURMA = null;
$NOME_UNIDADE = null;
$NOME_DISCIPLINA = null;
$ANO = null;
$CH_TOTAL = null;
$CREDITOS = null;
$PERIODO = null;
$DT_INICIO_PERIODO = null;
$DT_FIM_PERIODO = null;
$VAGAS_OFERECIDAS = null;
$NOME_CURSO_DIPLOMA = null;
if ($model->load(Yii::$app->request->post())) {
$model->file = UploadedFile::getInstance($model, 'file');
$uploadExists = 0;
if ($model->file) {
$imagepath = 'uploads/disciplinas-periodo/';
$model->file_import = $imagepath . rand(10, 1000) . '-' . str_replace('', '-', $model->file->name);
$bulkInsertArray = array();
$bulkInsertArray2 = array();
$uploadExists = 1;
}
if ($uploadExists) {
$model->file->saveAs($model->file_import);
$handle = fopen($model->file_import, 'r');
if ($handle) {
$loop = 0;
while (($data = fgetcsv($handle, 0, ";")) != FALSE) {
$loop++;
//Encontra os índices das colunas
if ($loop == 1) {
foreach ($data as $key => $value) {
switch ($value) {
case trim(strtoupper('COD_CURSO')):
$COD_CURSO = $key;
break;
case trim(strtoupper('NOME_CURSO_DIPLOMA')):
$NOME_CURSO_DIPLOMA = $key;
break;
case trim(strtoupper('NOME_DOCENTE')):
$NOME_DOCENTE = $key;
break;
case trim(strtoupper('COD_DISCIPLINA')):
$COD_DISCIPLINA = $key;
break;
case trim(strtoupper('COD_TURMA')):
$COD_TURMA = $key;
break;
case trim(strtoupper('NOME_UNIDADE')):
$NOME_UNIDADE = $key;
break;
case trim(strtoupper('NOME_DISCIPLINA')):
$NOME_DISCIPLINA = $key;
break;
case trim(strtoupper('ANO')):
$ANO = $key;
break;
case trim(strtoupper('PERIODO')):
$PERIODO = $key;
break;
case trim(strtoupper('CH_TOTAL')):
$CH_TOTAL = $key;
break;
case trim(strtoupper('CREDITOS')):
$CREDITOS = $key;
break;
case trim(strtoupper('DT_INICIO_PERIODO')):
$DT_INICIO_PERIODO = $key;
break;
case trim(strtoupper('DT_FIM_PERIODO')):
$DT_FIM_PERIODO = $key;
break;
case trim(strtoupper('VAGAS_OFERECIDAS')):
$VAGAS_OFERECIDAS = $key;
break;
}
}
//Se registro de cabeçalho está inválido, então o arquivo está inválido e o procedimento é encerrado.
if (is_null($COD_DISCIPLINA) || is_null($NOME_DISCIPLINA) || is_null($COD_TURMA) || is_null($PERIODO) || is_null($ANO) || is_null($DT_INICIO_PERIODO) || is_null($DT_FIM_PERIODO) || is_null($COD_CURSO) || is_null($NOME_DOCENTE)) {
$erroFatal = 'O cabeçalho do arquivo está inválido. Coluna(s) obrigatória(s) ausente(s).<br><br>Colunas obrigatórias: COD_DISCIPLINA, NOME_DISCIPLINA, COD_TURMA, PERIODO, ANO, DT_INICIO_PERIODO, DT_FIM_PERIODO, COD_CURSO, NOME_DOCENTE';
break;
} else {
continue;
//É a linha de cabeçalho, então vai para o próximo registro.
}
}
if (count($data) == 1) {
continue;
}
//Linha vazia, então vai para o próximo registro.
$nomeUnidade = '';
$codDisciplina = '';
$nomeDisciplina = '';
$cargaHoraria = '';
$creditos = '';
$codTurma = '';
$qtdVagas = '';
$numPeriodo = '';
$anoPeriodo = '';
$date1 = '';
$date2 = '';
$codigoCurso = '';
$nomeCurso = '';
$nomeProfessor = '';
if ($NOME_UNIDADE != null) {
$nomeUnidade = trim(utf8_encode(addslashes(strtoupper($data[$NOME_UNIDADE]))));
}
if ($COD_DISCIPLINA != null) {
$codDisciplina = trim(utf8_encode(addslashes(strtoupper($data[$COD_DISCIPLINA]))));
}
if ($NOME_DISCIPLINA != null) {
$nomeDisciplina = trim(utf8_encode(addslashes(strtoupper($data[$NOME_DISCIPLINA]))));
}
if ($CH_TOTAL != null) {
$cargaHoraria = $data[$CH_TOTAL];
}
if ($CREDITOS != null) {
$creditos = $data[$CREDITOS];
}
if ($COD_TURMA != null) {
$codTurma = trim(utf8_encode(addslashes(strtoupper($data[$COD_TURMA]))));
}
if ($VAGAS_OFERECIDAS != null) {
$qtdVagas = $data[$VAGAS_OFERECIDAS];
}
if ($PERIODO != null) {
$numPeriodo = substr(trim(utf8_encode(addslashes(strtoupper($data[$PERIODO])))), 0, 1);
}
if ($ANO != null) {
$anoPeriodo = $data[$ANO];
}
if ($DT_INICIO_PERIODO != null) {
$date1 = trim(utf8_encode(addslashes(strtoupper($data[$DT_INICIO_PERIODO]))));
}
if ($DT_FIM_PERIODO != null) {
$date2 = trim(utf8_encode(addslashes(strtoupper($data[$DT_FIM_PERIODO]))));
}
if ($COD_CURSO != null) {
$codigoCurso = trim(utf8_encode(addslashes(strtoupper($data[$COD_CURSO]))));
}
if ($NOME_CURSO_DIPLOMA != null) {
$nomeCurso = trim(utf8_encode(addslashes($data[$NOME_CURSO_DIPLOMA])));
}
if ($NOME_DOCENTE != null) {
$nomeProfessor = trim(utf8_encode(addslashes(strtoupper($data[$NOME_DOCENTE]))));
}
//Se registro inválido, então vai para o próximo registro
$erro = '0';
if (empty($codDisciplina)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna COD_DISCIPLINA está inválido.';
$erro = '1';
}
if (empty($nomeDisciplina)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna NOME_DISCIPLINA está inválido.';
$erro = '1';
}
if (empty($codTurma)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna COD_TURMA está inválido.';
$erro = '1';
}
if (empty($numPeriodo)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna PERIODO está inválido.';
$erro = '1';
}
if (empty($anoPeriodo)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna ANO está inválido.';
$erro = '1';
}
if (empty($date1)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna DT_INICIO_PERIODO está inválido.';
$erro = '1';
}
if (empty($date2)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna DT_FIM_PERIODO está inválido.';
$erro = '1';
}
if (empty($codigoCurso)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna COD_CURSO está inválido.';
$erro = '1';
}
if (empty($nomeProfessor)) {
$erros[] = 'Erro na linha ' . $loop . '. O valor da coluna NOME_DOCENTE está inválido.';
$erro = '1';
}
if ($erro == '1') {
continue;
}
//Formata as datas
if ($date1 != null && !empty($date1)) {
$arrayDate = explode("/", $date1);
$dataInicioPeriodo = $arrayDate[2] . '-' . $arrayDate[1] . '-' . $arrayDate[0];
} else {
$dataInicioPeriodo = null;
}
if ($date2 != null && !empty($date2)) {
$arrayDate = explode("/", $date2);
$dataFimPeriodo = $arrayDate[2] . '-' . $arrayDate[1] . '-' . $arrayDate[0];
} else {
$dataFimPeriodo = null;
}
//Procura ID do Curso
$query = sprintf("SELECT id FROM curso WHERE UPPER(codigo) = '%s'", $codigoCurso);
$idCurso = Yii::$app->db->createCommand($query)->queryScalar();
//INSERT Tabela: curso
if (!$idCurso) {
Yii::$app->db->createCommand()->insert('curso', ['codigo' => $codigoCurso, 'nome' => $nomeCurso, 'max_horas' => 0])->execute();
$query = sprintf("SELECT id FROM curso WHERE codigo = '%s'", $codigoCurso);
$idCurso = Yii::$app->db->createCommand($query)->queryScalar();
}
//Procura ID do Professor
$query = sprintf("SELECT id FROM usuario WHERE perfil = 'Professor' AND UPPER(name) = '%s'", $nomeProfessor);
$idProfessor = Yii::$app->db->createCommand($query)->queryScalar();
//Se não localizar o professor, então vai para o próximo registro
if (!$idProfessor) {
$erros[] = 'Erro na linha ' . $loop . '. Professor (' . $nomeProfessor . ') não localizado no banco de dados.';
continue;
}
//Tabela: disciplina
$query = sprintf("SELECT id FROM disciplina WHERE codDisciplina = '%s'", $codDisciplina);
$idDisciplina = Yii::$app->db->createCommand($query)->queryScalar();
if ($idDisciplina) {
//Quando a disciplina não possui monitoria, então não se cadastra em disciplina-periodo
$query = sprintf("SELECT possuiMonitoria FROM disciplina WHERE id = '%s'", $idDisciplina);
$possuiMonitoria = Yii::$app->db->createCommand($query)->queryScalar();
if (!$possuiMonitoria) {
continue;
}
$arrayUpdate = ['nomeDisciplina' => $nomeDisciplina, 'cargaHoraria' => $cargaHoraria, 'creditos' => $creditos];
Yii::$app->db->createCommand()->update('disciplina', $arrayUpdate, 'id=' . $idDisciplina)->execute();
} else {
//if (array_search($codDisciplina, array_column($bulkInsertArray, 'codDisciplina'))) {
// $bulkInsertArray[]=[
// 'codDisciplina' => $codDisciplina,
// 'nomeDisciplina' => $nomeDisciplina,
// 'cargaHoraria' => $cargaHoraria,
// 'creditos' => $creditos,
// ];
//}
$arrayInsert = ['codDisciplina' => $codDisciplina, 'nomeDisciplina' => $nomeDisciplina, 'cargaHoraria' => $cargaHoraria, 'creditos' => $creditos];
Yii::$app->db->createCommand()->insert('disciplina', $arrayInsert)->execute();
}
//Tabela: disciplina_periodo
$query = sprintf("SELECT id FROM disciplina WHERE codDisciplina = '%s'", $codDisciplina);
$idDisciplina = Yii::$app->db->createCommand($query)->queryScalar();
$query = sprintf("SELECT id FROM disciplina_periodo WHERE idDisciplina='%s' and codTurma='%s' and anoPeriodo='%s' and numPeriodo='%s'", $idDisciplina, $codTurma, $anoPeriodo, $numPeriodo);
$result = Yii::$app->db->createCommand($query)->queryScalar();
if ($result) {
$arrayUpdate = ['nomeUnidade' => $nomeUnidade, 'qtdVagas' => $qtdVagas, 'dataInicioPeriodo' => $dataInicioPeriodo, 'dataFimPeriodo' => $dataFimPeriodo, 'idCurso' => $idCurso, 'idProfessor' => $idProfessor];
Yii::$app->db->createCommand()->update('disciplina_periodo', $arrayUpdate, 'id=' . $result)->execute();
} else {
//if (array_search($idDisciplina, array_column($bulkInsertArray2, 'idDisciplina'))) {
// $bulkInsertArray2[]=[
// 'idDisciplina' => $idDisciplina,
// 'numPeriodo' => $numPeriodo,
// 'anoPeriodo' => $anoPeriodo,
// 'codTurma' => $codTurma,
// 'nomeUnidade' => $nomeUnidade,
// 'qtdVagas' => $qtdVagas,
// 'dataInicioPeriodo' => $dataInicioPeriodo,
// 'dataFimPeriodo' => $dataFimPeriodo,
// 'idCurso' => $idCurso
// ];
//}
$arrayInsert = ['idDisciplina' => $idDisciplina, 'numPeriodo' => $numPeriodo, 'anoPeriodo' => $anoPeriodo, 'codTurma' => $codTurma, 'nomeUnidade' => $nomeUnidade, 'qtdVagas' => $qtdVagas, 'dataInicioPeriodo' => $dataInicioPeriodo, 'dataFimPeriodo' => $dataFimPeriodo, 'idCurso' => $idCurso, 'idProfessor' => $idProfessor];
Yii::$app->db->createCommand()->insert('disciplina_periodo', $arrayInsert)->execute();
}
}
fclose($handle);
unlink($model->file_import);
//Apaga o arquivo
//$columnNameArray1 = ['codDisciplina', 'nomeDisciplina', 'cargaHoraria', 'creditos'];
//Yii::$app->db->createCommand()->batchInsert('disciplina', $columnNameArray1, $bulkInsertArray)->execute();
//$columnNameArray2 = ['idDisciplina', 'numPeriodo', 'anoPeriodo', 'codTurma', 'nomeUnidade', 'qtdVagas', 'dataInicioPeriodo', 'dataFimPeriodo', 'idCurso'];
//Yii::$app->db->createCommand()->batchInsert('disciplina_periodo', $columnNameArray2, $bulkInsertArray2)->execute();
}
}
//return $this->redirect(['index']);
return $this->render('importarcsv', ['model' => $model, 'etapa' => '2', 'erroFatal' => $erroFatal, 'erros' => $erros]);
} else {
return $this->render('importarcsv', ['model' => $model, 'etapa' => '1', 'erroFatal' => '', 'erros' => null]);
}
}
public function actionImportarcsv()
{
$model = new DisciplinaPeriodo(['scenario' => 'csv']);
/*
if (Yii::$app->request->get('success') != null) {
return $this->render('importarcsv', [
'model' => $model,
'success' => $success]);
} else {
return $this->render('importarcsv', [
'model' => $model,
'success' => '']);
}
*/
if ($model->load(Yii::$app->request->post())) {
$model->file = UploadedFile::getInstance($model, 'file');
$uploadExists = 0;
if ($model->file) {
$imagepath = 'uploads/disciplinas-periodo/';
$model->file_import = $imagepath . rand(10, 1000) . '-' . str_replace('', '-', $model->file->name);
$bulkInsertArray = array();
$bulkInsertArray2 = array();
$uploadExists = 1;
}
if ($uploadExists) {
$model->file->saveAs($model->file_import);
$handle = fopen($model->file_import, 'r');
if ($handle) {
while (($data = fgetcsv($handle, 0, ",")) != FALSE) {
$nomeUnidade = trim(utf8_encode(addslashes(strtoupper($data[0]))));
if ($nomeUnidade == 'NOME_UNIDADE') {
continue;
}
//Linha de cabeçalho, então vai para o próximo registro.
$codDisciplina = trim(utf8_encode(addslashes(strtoupper($data[5]))));
$nomeDisciplina = trim(utf8_encode(addslashes(strtoupper($data[1]))));
$cargaHoraria = $data[13];
$creditos = $data[14];
$codTurma = trim(utf8_encode(addslashes(strtoupper($data[2]))));
$qtdVagas = $data[23];
$numPeriodo = substr(trim(utf8_encode(addslashes(strtoupper($data[15])))), 0, 1);
$anoPeriodo = $data[10];
$date1 = trim(utf8_encode(addslashes(strtoupper($data[18]))));
$date2 = trim(utf8_encode(addslashes(strtoupper($data[19]))));
if ($date1 != null && !empty($date1)) {
$arrayDate = explode("/", $date1);
$dataInicioPeriodo = $arrayDate[2] . '-' . $arrayDate[1] . '-' . $arrayDate[0];
} else {
$dataInicioPeriodo = null;
}
if ($date2 != null && !empty($date2)) {
$arrayDate = explode("/", $date2);
$dataFimPeriodo = $arrayDate[2] . '-' . $arrayDate[1] . '-' . $arrayDate[0];
} else {
$dataFimPeriodo = null;
}
$siglaCurso = trim(utf8_encode(addslashes(strtoupper($data[16]))));
$query = sprintf("SELECT ID FROM curso WHERE sigla = '%s'", $siglaCurso);
$idCurso = Yii::$app->db->createCommand($query)->queryScalar();
//Tabela: curso
if (!$idCurso) {
Yii::$app->db->createCommand()->insert('curso', ['sigla' => $siglaCurso])->execute();
$query = sprintf("SELECT ID FROM curso WHERE sigla = '%s'", $siglaCurso);
$idCurso = Yii::$app->db->createCommand($query)->queryScalar();
}
//Tabela: disciplina
$query = sprintf("SELECT id FROM disciplina WHERE codDisciplina = '%s'", $codDisciplina);
$idDisciplina = Yii::$app->db->createCommand($query)->queryScalar();
if ($idDisciplina) {
$arrayUpdate = ['nomeDisciplina' => $nomeDisciplina, 'cargaHoraria' => $cargaHoraria, 'creditos' => $creditos];
Yii::$app->db->createCommand()->update('disciplina', $arrayUpdate, 'id=' . $idDisciplina)->execute();
} else {
//if (array_search($codDisciplina, array_column($bulkInsertArray, 'codDisciplina'))) {
// $bulkInsertArray[]=[
// 'codDisciplina' => $codDisciplina,
// 'nomeDisciplina' => $nomeDisciplina,
// 'cargaHoraria' => $cargaHoraria,
// 'creditos' => $creditos,
// ];
//}
$arrayInsert = ['codDisciplina' => $codDisciplina, 'nomeDisciplina' => $nomeDisciplina, 'cargaHoraria' => $cargaHoraria, 'creditos' => $creditos];
Yii::$app->db->createCommand()->insert('disciplina', $arrayInsert)->execute();
}
//Tabela: disciplina_periodo
$query = sprintf("SELECT id FROM disciplina WHERE codDisciplina = '%s'", $codDisciplina);
$idDisciplina = Yii::$app->db->createCommand($query)->queryScalar();
$query = sprintf("SELECT id FROM disciplina_periodo WHERE idDisciplina='%s' and codTurma='%s' and anoPeriodo='%s' and numPeriodo='%s'", $idDisciplina, $codTurma, $anoPeriodo, $numPeriodo);
$result = Yii::$app->db->createCommand($query)->queryScalar();
if ($result) {
$arrayUpdate = ['nomeUnidade' => $nomeUnidade, 'qtdVagas' => $qtdVagas, 'dataInicioPeriodo' => $dataInicioPeriodo, 'dataFimPeriodo' => $dataFimPeriodo, 'idCurso' => $idCurso];
Yii::$app->db->createCommand()->update('disciplina_periodo', $arrayUpdate, 'id=' . $result)->execute();
} else {
//if (array_search($idDisciplina, array_column($bulkInsertArray2, 'idDisciplina'))) {
// $bulkInsertArray2[]=[
// 'idDisciplina' => $idDisciplina,
// 'numPeriodo' => $numPeriodo,
// 'anoPeriodo' => $anoPeriodo,
// 'codTurma' => $codTurma,
// 'nomeUnidade' => $nomeUnidade,
// 'qtdVagas' => $qtdVagas,
// 'dataInicioPeriodo' => $dataInicioPeriodo,
// 'dataFimPeriodo' => $dataFimPeriodo,
// 'idCurso' => $idCurso
// ];
//}
$arrayInsert = ['idDisciplina' => $idDisciplina, 'numPeriodo' => $numPeriodo, 'anoPeriodo' => $anoPeriodo, 'codTurma' => $codTurma, 'nomeUnidade' => $nomeUnidade, 'qtdVagas' => $qtdVagas, 'dataInicioPeriodo' => $dataInicioPeriodo, 'dataFimPeriodo' => $dataFimPeriodo, 'idCurso' => $idCurso];
Yii::$app->db->createCommand()->insert('disciplina_periodo', $arrayInsert)->execute();
}
}
fclose($handle);
//$columnNameArray1 = ['codDisciplina', 'nomeDisciplina', 'cargaHoraria', 'creditos'];
//Yii::$app->db->createCommand()->batchInsert('disciplina', $columnNameArray1, $bulkInsertArray)->execute();
//$columnNameArray2 = ['idDisciplina', 'numPeriodo', 'anoPeriodo', 'codTurma', 'nomeUnidade', 'qtdVagas', 'dataInicioPeriodo', 'dataFimPeriodo', 'idCurso'];
//Yii::$app->db->createCommand()->batchInsert('disciplina_periodo', $columnNameArray2, $bulkInsertArray2)->execute();
}
}
return $this->redirect(['index']);
} else {
return $this->render('importarcsv', ['model' => $model]);
}
}
/* @var $dataProvider yii\data\ActiveDataProvider */
$this->title = 'Disciplinas para Monitoria';
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="disciplina-periodo-index">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<?php
// echo $this->render('_search', ['model' => $searchModel]);
?>
<p>
<?php
echo Html::a('Criar Disciplina', ['create'], ['class' => 'btn btn-success']);
?>
<?php
echo Html::a('Importar Disciplinas - Arquivo CSV', ['importarcsv'], ['class' => 'btn btn-success']);
?>
</p>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'summary' => '', 'columns' => [['attribute' => 'codDisciplina', 'value' => 'disciplina.codDisciplina'], ['attribute' => 'idDisciplina', 'value' => 'disciplina.nomeDisciplina'], 'codTurma', ['attribute' => 'idCurso', 'value' => 'curso.nome'], ['attribute' => 'idProfessor', 'value' => 'usuario.name'], ['attribute' => 'qtdMonitorBolsista', 'label' => 'Bolsista'], ['attribute' => 'qtdMonitorNaoBolsista', 'label' => 'Não Bolsista'], ['attribute' => 'anoPeriodo', 'filter' => ArrayHelper::map(DisciplinaPeriodo::find()->distinct()->orderBy(['anoPeriodo' => SORT_DESC])->asArray()->all(), 'anoPeriodo', 'anoPeriodo')], ['attribute' => 'numPeriodo', 'filter' => ArrayHelper::map(DisciplinaPeriodo::find()->distinct()->orderBy(['numPeriodo' => SORT_DESC])->asArray()->all(), 'numPeriodo', 'numPeriodo')], ['class' => 'yii\\grid\\ActionColumn', 'header' => 'Ações', 'headerOptions' => ['style' => 'text-align:center; color:#337AB7'], 'contentOptions' => ['style' => 'text-align:center; vertical-align:middle']]]]);
?>
<a href="?r=monitoria/index" class="btn btn-default">Voltar</a>
</div>
/**
* @return \yii\db\ActiveQuery
*/
public function getDisciplinaPeriodos()
{
return $this->hasMany(DisciplinaPeriodo::className(), ['idDisciplina' => 'id']);
}
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]);
}
}
public function afterFind()
{
switch ($this->bolsa) {
case 0:
$this->traducao_bolsa = 'Não';
break;
case 1:
$this->traducao_bolsa = 'Sim';
break;
}
switch ($this->status) {
case 0:
$this->traducao_status = 'Aguardando Avaliação';
break;
case 1:
$this->traducao_status = 'Selecionado com bolsa';
break;
case 2:
$this->traducao_status = 'Selecionado sem bolsa';
break;
case 3:
$this->traducao_status = 'Não selecionado';
break;
case 4:
$this->traducao_status = 'Indeferido - Nota < 7';
break;
case 5:
$this->traducao_status = 'Indeferido - Coeficiente < 5';
break;
case 6:
$this->traducao_status = 'Indeferido - Não cursou a disciplina';
break;
}
$periodo = PeriodoInscricaoMonitoria::findOne(['id' => $this->IDperiodoinscr]);
$this->IDperiodoinscr = $periodo->ano . '/' . $periodo->periodo;
$disciplinaPeriodo = DisciplinaPeriodo::findOne($this->IDDisc);
$disciplina = Disciplina::find()->where(['id' => $disciplinaPeriodo->idDisciplina])->one();
$this->nomeDisciplina = $disciplina->nomeDisciplina;
$curso = Curso::find()->where(['id' => $disciplinaPeriodo->idCurso])->one();
$this->nomeCurso = $curso->nome;
}
