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