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; }