protected function tearDown()
{
$this->usuario1->delete();
$this->usuario2->delete();
Materia::model()->deleteAll();
}
<?php
$this->pageTitle = Yii::app()->name . ' - Examenes.';
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n \$('.search-form').toggle();\n return false;\n});\n\$('.search-form form').submit(function(){\n \$('#examen-grid').yiiGridView('update', {\n data: \$(this).serialize()\n });\n return false;\n});\n");
?>
<div class="titulo">
<h1>Examenes</h1>
</div>
<?php
$this->widget('bootstrap.widgets.TbMenu', array('type' => 'pills', 'items' => array(array('label' => 'Nuevo', 'icon' => 'icon-plus', 'url' => Yii::app()->controller->createUrl('create')), array('label' => 'Listado', 'icon' => 'icon-th-list', 'url' => Yii::app()->controller->createUrl('index'), 'active' => true, 'linkOptions' => array()), array('label' => 'Exportar a PDF', 'icon' => 'icon-download', 'url' => Yii::app()->controller->createUrl('GeneratePdf'), 'linkOptions' => array('target' => '_blank'), 'visible' => true), array('label' => 'Exportar a Excel', 'icon' => 'icon-download', 'url' => Yii::app()->controller->createUrl('GenerateExcel'), 'linkOptions' => array('target' => '_blank'), 'visible' => true), array('itemOptions' => array('id' => 'deleteAll', 'onclick' => 'delete_all_records()'), 'label' => 'Eliminar todos los examenes', 'icon' => 'icon-remove-sign', 'url' => '#', 'linkOptions' => array('class' => ' btn-danger btn-small '), 'visible' => Yii::app()->user->isAdmin()), array('itemOptions' => array('id' => 'deleteAll', 'onclick' => 'delete_all_my_records(' . Yii::app()->user->name . ')'), 'label' => 'Eliminar todos mis examenes', 'icon' => 'icon-remove-sign', 'url' => '#', 'linkOptions' => array('class' => ' btn-danger btn-small '), 'visible' => !Yii::app()->user->isAdmin()))));
$grid = $this->widget('bootstrap.widgets.TbGridView', array('id' => 'examen-grid', 'dataProvider' => $model->search(), 'type' => $this->table_style, 'template' => $this->table_template, 'filter' => $model, 'columns' => array(array('header' => 'Fecha', 'name' => 'fechaExamen', 'headerHtmlOptions' => array('style' => 'width:145px'), 'value' => 'Yii::app()->dateFormatter->format("dd MMM y",strtotime($data->fechaExamen))', 'filter' => CHtml::listData(Examen::model()->findAll(), 'fechaExamen', 'formattedDate')), array('header' => 'Materia', 'name' => 'materia_id', 'value' => '$data->materia->id." - ".$data->materia->nombreMateria', 'headerHtmlOptions' => array('style' => 'width:550px'), 'filter' => CHtml::listData(Materia::model()->getTodasLasMaterias('nombreMateria'), 'id', 'concatened')), array('header' => 'Tipo de examen', 'name' => 'tipoexamen_id', 'value' => '$data->tipoexamen->nombreTipoExamen', 'headerHtmlOptions' => array('style' => 'width:200px'), 'filter' => CHtml::listData(Tipoexamen::model()->findAll(array('order' => 'nombreTipoExamen')), 'id', 'nombreTipoExamen')), array('type' => 'raw', 'value' => ' Yii::app()->user->getName()==$data->materia_id || Yii::app()->user->isAdmin() ?
"<a href=\'javascript:void(0);\' onclick=\'renderView(".$data->id.")\' class=\'btn btn-small view\' ><i class=\'icon-eye-open\'></i></a><a href=\'index.php?r=examen/update&id=$data->id\' onclick=\'renderUpdateForm(".$data->id.")\' class=\'btn btn-small view\' ><i class=\'icon-pencil\'></i></a>
<a href=\'javascript:void(0);\' onclick=\'delete_record(".$data->id.")\' class=\'btn btn-small view\' ><i class=\'icon-trash\'></i></a>
": "<a href=\'javascript:void(0);\' onclick=\'renderView(".$data->id.")\' class=\'btn btn-small view\' ><i class=\'icon-eye-open\'></i></a>"', 'headerHtmlOptions' => array('style' => 'width:95px;text-align:left')))));
$this->renderPartial("_ajax_view");
?>
<script type="text/javascript">
function delete_record(id) {
var id;
this.id = id;
bootbox.confirm("<img src='images/warning.png'/> ¿Está seguro de eliminar este examen?<br/><br/>", function (result) {
if (!result) return;
// $('#ajaxtest-view-modal').modal('hide');
var data = "id=" + id;
jQuery.ajax({
type: 'POST',
url: '<?php
echo Yii::app()->createAbsoluteUrl("examen/delete");
?>
',
data: data,
<?php
$this->endWidget();
?>
</div>
<!-- Form -->
<div id="plan-label"> Arrastra los elementos para armar el plan </div>
<div id="container_Mat_Tabla">
<div id="materias" class="drop" ondrop="dropMateria(this, event)" ondragenter="return false" ondragover="return false" >
<!-- Generacion de las materias dropeables -->
<?php
$materias = Materia::model()->getTodasLasMaterias('nombreMateria');
echo '<ul>';
foreach ($materias as $item) {
$codigo = $item->id;
$nombre = $item->nombreMateria;
echo '<span draggable="true" class="materia" id="' . $codigo . '" ondragstart="dragMateria(this, event)">' . $codigo . '-' . $nombre . '</span>';
}
echo '</ul>';
?>
<!-- FIN Generacion de las materias dropeables -->
</div>
<div id="tabla">
<table class="tg-table-light">
public function actionGeneratePdf()
{
$session = new CHttpSession();
$session->open();
Yii::import('application.extensions.ajaxgii.bootstrap.*');
require_once 'tcpdf/tcpdf.php';
require_once 'tcpdf/config/lang/eng.php';
$Criteria = new CDbCriteria();
$Criteria->condition = "id != -1";
$model = Materia::model()->findAll($Criteria);
$html = $this->renderPartial('expenseGridtoReport', array('model' => $model), true);
$pdf = new TCPDF();
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(Yii::app()->name);
$pdf->SetTitle('Materia Report');
$pdf->SetSubject('Materia Report');
$pdf->SetHeaderData('', 0, "Report", '');
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, "Reporte generado por " . Yii::app()->name, "");
$pdf->setHeaderFont(array('helvetica', '', 8));
$pdf->setFooterFont(array('helvetica', '', 6));
$pdf->SetMargins(15, 18, 15);
$pdf->SetHeaderMargin(5);
$pdf->SetFooterMargin(10);
$pdf->SetAutoPageBreak(TRUE, 0);
$pdf->SetFont('dejavusans', '', 7);
$pdf->AddPage();
$pdf->writeHTML($html, true, false, true, false, '');
$pdf->LastPage();
$pdf->Output("Materia_002.pdf", "I");
}
public function actionAbrir($id)
{
$abrirMateria = Materia::model()->findByPk($id);
$this->render('formEditarMateria', ['materia' => $abrirMateria]);
}
</div>
<p class="note">
Campos obligatorios <span class="required">*</span>
</p>
<div class="control-group">
<div class="span10">
<div class="row">
<div class="span4">
<?php
if (Yii::app()->user->isAdmin()) {
?>
<?php
echo $form->labelEx($modelos[1], 'materia_id');
?>
<?php
echo CHtml::activeDropDownList($modelos[1], '[1]materia_id', CHtml::listData(Materia::model()->getTodasLasMaterias('nombreMateria'), 'id', 'concatened'), array('options' => array($modelos[1]->materia_id => array('selected' => true)), 'empty' => '-Por favor seleccione-'));
?>
<?php
echo $form->error($modelos[1], 'materia_id');
}
?>
</div>
</div>
<?php
for ($i = 1; $i <= 10; $i++) {
?>
<div class="entries" id="<?php
echo 'entry' . $i;
?>
">
<hr/>
public function existsInDatabase($nombreMateria)
{
$criteria = new CDbCriteria();
$criteria->select = 'nombreMateria';
$criteria->condition = 'LOWER(nombreMateria)=:nombreMateria';
$criteria->params = array(':nombreMateria' => strtolower($nombreMateria));
$records = Materia::model()->find($criteria);
return count($records) > 0;
}
echo ' <tr>
<th>1º Cuatrimestre</th>
<th>2º Cuatrimestre</th>
</tr>';
for ($i = 1; $i < 6; $i++) {
echo ' <tr class="tg-even">
<td class="anio" colspan="2">' . $i . 'º Año</td>
</tr>';
echo '<td><ul>';
$results = Materia::model()->findAllBySql('SELECT Materia.nombreMateria,Materia.id FROM Materia_has_Plan INNER JOIN Materia WHERE Materia_id=Materia.id AND anio=' . $i . ' AND cuatrimestre=1 AND Plan_id=' . $model->id);
foreach ($results as $result) {
$nombre = $result->nombreMateria;
$codigo = $result->id;
echo '<li class="materia">' . $codigo . ' - ' . $nombre;
}
echo '</ul></td>';
echo '<td><ul>';
$results = Materia::model()->findAllBySql('SELECT Materia.nombreMateria,Materia.id FROM Materia_has_Plan INNER JOIN Materia WHERE Materia_id=Materia.id AND anio=' . $i . ' AND cuatrimestre=2 AND Plan_id=' . $model->id);
foreach ($results as $result) {
$nombre = $result->nombreMateria;
$codigo = $result->id;
echo '<li class="materia">' . $codigo . ' - ' . $nombre;
}
echo '</ul></td>';
echo '</tr>';
}
echo "</table>";
} else {
echo '<div class="alert alert-warning">
No se han cargado materias.</div>';
}
