<?php class TiposDocumentosController extends CrController { /** * @var string the default layout for the views. Defaults to '//layouts/column2', meaning * using two-column layout. See 'protected/views/layouts/column2.php'. */ public $layout='//layouts/column1'; /** * @return array action filters */ public function filters() { return array( 'accessControl', // perform access control for CRUD operations ); } /** * Specifies the access control rules. * This method is used by the 'accessControl' filter. * @return array access control rules */ public function accessRules() { return array( array('allow', // allow all users to perform 'index' and 'view' actions 'actions'=>array('index','view','activo'), 'users'=>array('@'), ), array('allow', // allow authenticated user to perform 'create' and 'update' actions 'actions'=>array('create','update','GeneratePdf','GenerateExcel'), 'users'=>array('@'), ), array('allow', // allow admin user to perform 'admin' and 'delete' actions 'actions'=>array('admin','delete'), 'users'=>array('admin'), ), array('deny', // deny all users 'users'=>array('*'), ), ); } /** * Displays a particular model. * @param integer $id the ID of the model to be displayed */ public function actionView($id) { $this->render('view',array( 'model'=>$this->loadModel($id), )); } /** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model=new TiposDocumentos; // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if(isset($_POST['TiposDocumentos'])) { $model->attributes=$_POST['TiposDocumentos']; if($model->save()) $this->redirect(array('index')); } $this->render('create',array( 'model'=>$model, )); } /** * Updates a particular model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id the ID of the model to be updated */ public function actionUpdate($id) { $model=$this->loadModel($id); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if(isset($_POST['TiposDocumentos'])) { $model->attributes=$_POST['TiposDocumentos']; if($model->save()) $this->redirect(array('index')); } $this->render('update',array( 'model'=>$model, )); } /** * Deletes a particular model. * If deletion is successful, the browser will be redirected to the 'admin' page. * @param integer $id the ID of the model to be deleted */ public function actionDelete($id) { if(Yii::app()->request->isPostRequest) { // we only allow deletion via POST request $this->loadModel($id)->delete(); // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser if(!isset($_GET['ajax'])) $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin')); } else throw new CHttpException(400,'Invalid request. Please do not repeat this request again.'); } public function actionActivo($id){ $model=$this->loadModel($id); //Importante tener declarado el campo activo //en el modelo de base de datos $activo=$model->activo; if($model->activo){ $model->activo=0; }else{ $model->activo=1; } $arrResp=array(); if($model->saveAttributes(array('activo'=>$model->activo))){ $arrResp=array( 'check'=>1,'activo'=>$model->activo); }else{ $arrResp=array( 'check'=>0,'activo'=>$activo); } echo json_encode($arrResp); Yii::App()->end(); } /** * Lists all models. */ public function actionIndex() { /* $session=new CHttpSession; $session->open(); $criteria = new CDbCriteria(); $model=new TiposDocumentos('search'); $model->unsetAttributes(); // clear any default values if(isset($_GET['TiposDocumentos'])) { $model->attributes=$_GET['TiposDocumentos']; if (!empty($model->id_tipo_documento)) $criteria->addCondition("id_tipo_documento = '".$model->id_tipo_documento."'"); if (!empty($model->nombre)) $criteria->addCondition("nombre = '".$model->nombre."'"); if (!empty($model->activo)) $criteria->addCondition("activo = '".$model->activo."'"); $session['TiposDocumentos_records']=TiposDocumentos::model()->findAll($criteria); }*/ $model = TiposDocumentos::model()->findall(); $this->render('index',array('model'=>$model,)); } /** * Manages all models. */ public function actionAdmin() { $model=new TiposDocumentos('search'); $model->unsetAttributes(); // clear any default values if(isset($_GET['TiposDocumentos'])) $model->attributes=$_GET['TiposDocumentos']; $this->render('admin',array( 'model'=>$model, )); } /** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model=TiposDocumentos::model()->findByPk($id); if($model===null) throw new CHttpException(404,'The requested page does not exist.'); return $model; } /** * Performs the AJAX validation. * @param CModel the model to be validated */ protected function performAjaxValidation($model) { if(isset($_POST['ajax']) && $_POST['ajax']==='tipos-documentos-form') { echo CActiveForm::validate($model); Yii::app()->end(); } } public function actionGenerateExcel() { $session=new CHttpSession; $session->open(); if(isset($session['TiposDocumentos_records'])) { $model=$session['TiposDocumentos_records']; } else $model = TiposDocumentos::model()->findAll(); Yii::app()->request->sendFile(date('YmdHis').'.xls', $this->renderPartial('excelReport', array( 'model'=>$model ), true) ); } public function actionGeneratePdf() { $session=new CHttpSession; $session->open(); Yii::import('application.extensions.bootstrap.gii.*'); require_once('bootstrap/tcpdf/tcpdf.php'); require_once('bootstrap/tcpdf/config/lang/eng.php'); if(isset($session['TiposDocumentos_records'])) { $model=$session['TiposDocumentos_records']; } else $model = TiposDocumentos::model()->findAll(); $html = $this->renderPartial('expenseGridtoReport', array( 'model'=>$model ), true); //die($html); $pdf = new TCPDF(); $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor(Yii::app()->name); $pdf->SetTitle('TiposDocumentos Report'); $pdf->SetSubject('TiposDocumentos Report'); //$pdf->SetKeywords('example, text, report'); $pdf->SetHeaderData('', 0, "Report", ''); $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, "Example Report by ".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("TiposDocumentos_002.pdf", "I"); } }