/**
  * This is the default 'index' action that is invoked
  * when an action is not explicitly requested by users.
  */
 public function actionIndex()
 {
     $client = new Client();
     $vehicle = new VehicleClient();
     $technicaldate = new TechnicalDate();
     $concessioners = Concessioner::model()->findAll();
     $criteria = new CDbCriteria();
     //$criteria->condition = 'id != 32 AND id != 33 AND id != 34  AND id != 36 AND id != 37 AND id != 38 AND id != 39 AND id != 40 AND id != 41 AND id != 42';
     //$criteria->order=name;
     $criteria = new CDbCriteria();
     //$criteria->condition = 'id != 36';
     $criteria->order = "name";
     $versions = VehicleVersion::model()->with('vehicle')->findAllbyAttributes(array(), $criteria);
     //$versions= VehicleVersion::model()->findAllbyAttributes(array('status'=>'ACTIVE'),$criteria);
     if (isset($_POST['ajax']) && $_POST['ajax'] === 'client-form') {
         echo CActiveForm::validate($client);
         Yii::app()->end();
     }
     if (isset($_POST['siguiente'])) {
         // die("hola");
         if (isset($_POST['Client']) && isset($_POST['TechnicalDate']) && isset($_POST['VehicleClient'])) {
             //die("hola");
             $client = new Client();
             $client->attributes = $_POST['Client'];
             $client->save();
             $vehicle = new VehicleClient();
             $vehicle->attributes = $_POST['VehicleClient'];
             $vehicle->save();
             $technicaldate = new TechnicalDate();
             $technicaldate->attributes = $_POST['TechnicalDate'];
             $technicaldate->client_id = $client->primaryKey;
             $technicaldate->vehicle_id = $vehicle->primaryKey;
             if ($technicaldate->save()) {
                 $message = new YiiMailMessage();
                 $message->view = 'agendamiento';
                 $message->setSubject('Prospecto agendamiento de Cita');
                 $message->setBody(array("client" => $client, "vehicle" => $vehicle, "technicaldate" => $technicaldate), 'text/html');
                 $message->setFrom(array(Yii::app()->params['adminEmail'] => 'El Equipo Nissan Ecuador'));
                 foreach ($technicaldate->concessioner->emails as $email) {
                     if ($email->type == "TECHNICAL_DATE") {
                         $message->addTo($email->description);
                     }
                 }
                 //$message->addTo("*****@*****.**");
                 Yii::app()->mail->send($message);
                 $this->render('result', array("client" => $client, "vehicle" => $vehicle, "technicaldate" => $technicaldate));
             } else {
                 $this->render('error');
             }
         }
         //$this->render('index',array('concessioners'=>$concessioners,"client"=>$client,"vehicle"=>$vehicle,"technicaldate"=>$technicaldate));
     } else {
         $this->render('index', array('concessioners' => $concessioners, "client" => $client, "vehicle" => $vehicle, "technicaldate" => $technicaldate, "versions" => $versions));
     }
 }
 public function actionLoadVersionVehicle()
 {
     $criteria = new CDbCriteria();
     $criteria->order = 'reference';
     $criteria->condition = 'id != 32 AND id != 33 AND id != 34  AND id != 36 AND id != 37 AND id != 38 AND id != 39 AND id != 40 AND id != 41 AND id != 42';
     $vehicle_version = VehicleVersion::model()->findAllByAttributes(array("vehicle_id" => $_POST['vehicle_id'], "status" => "ACTIVE"), $criteria);
     $vehicle_image = Picture::model()->findByAttributes(array("vehicle_id" => $_POST['vehicle_id']));
     $vehicle_s = Vehicle::model()->findByPk($_POST['vehicle_id']);
     $return = array();
     foreach ($vehicle_version as $z => $vehicle) {
         $return[$z]['id'] = $vehicle->id;
         $return[$z]['reference'] = $vehicle->reference;
         $return[$z]['motor'] = $vehicle->motor;
         $return[$z]['type'] = $vehicle->type;
         $return[$z]['transmission'] = $vehicle->transmission;
         $return[$z]['combustion'] = $vehicle->combustion;
         $return[$z]['ac'] = $vehicle->ac;
         $return[$z]['abs'] = $vehicle->abs;
     }
     $return['image'] = $vehicle_image->description;
     $return['name'] = $vehicle_s->name;
     echo json_encode($return);
 }
 public function actionDiagnostic()
 {
     $medio = "default";
     if (isset($_GET["medio"])) {
         $medio = $_GET["medio"];
     }
     $client = new Client();
     $vehicle = new VehicleClient();
     $replacement = new Replacement();
     $criteria2 = new CDbCriteria();
     //$criteria2->condition = 'id = 1 OR id = 2 OR id = 9 OR id = 10 OR id = 11  OR id = 13 OR id = 14 OR id= 15 OR id = 16';
     $concessioners = Concessioner::model()->findAllbyAttributes(array(), $criteria2);
     $criteria = new CDbCriteria();
     //$criteria->condition = 'id != 36';
     $criteria->order = 'name';
     $versions = VehicleVersion::model()->with('vehicle')->findAllbyAttributes(array(), $criteria);
     if (isset($_POST['ajax']) && $_POST['ajax'] === 'replacement-form') {
         echo CActiveForm::validate($client);
         Yii::app()->end();
     }
     if (isset($_POST['siguiente'])) {
         if (isset($_POST['Client']) && isset($_POST['Replacement']) && isset($_POST['VehicleClient'])) {
             $client = new Client();
             $client->attributes = $_POST['Client'];
             $client->save();
             $vehicle = new VehicleClient();
             $vehicle->attributes = $_POST['VehicleClient'];
             //die(print_r($vehicle->attributes));
             $vehicle->kilometer = "1";
             $vehicle->save();
             $replacement = new Replacement();
             $replacement->attributes = $_POST['Replacement'];
             $replacement->client_id = $client->primaryKey;
             $replacement->vehicle_id = $vehicle->primaryKey;
             if ($replacement->save()) {
                 $rep = Replacement::model()->findByPk($replacement->primaryKey);
                 $message = new YiiMailMessage();
                 $message->view = 'repuesto';
                 $message->setBody(array("replacement" => $rep), 'text/html');
                 $message->setSubject('Prospecto para repuesto');
                 foreach ($rep->concessioner->emails as $email) {
                     if ($email->type == "REPLACEMENT") {
                         $message->addTo($email->description);
                     }
                 }
                 $message->addTo("*****@*****.**");
                 $message->addTo("*****@*****.**");
                 $message->addTo("*****@*****.**");
                 $message->addTo("*****@*****.**");
                 $message->setFrom(array(Yii::app()->params['adminEmail'] => 'El Equipo Nissan Ecuador'));
                 Yii::app()->mail->send($message);
                 $this->render('result', array("client" => $client, "vehicle" => $vehicle, "replacement" => $replacement));
             } else {
                 $this->render('error');
             }
         }
         //$this->render('index',array('concessioners'=>$concessioners,"client"=>$client,"vehicle"=>$vehicle,"replacement"=>$replacement));
     } else {
         $this->render('index_d', array('concessioners' => $concessioners, "client" => $client, "vehicle" => $vehicle, "replacement" => $replacement, "versions" => $versions, "medio" => $medio));
     }
 }
 public function actionIndex()
 {
     $concessioners = Concessioner::model()->findAll();
     $vehicles = Vehicle::model()->findAllByAttributes(array('status' => 'ACTIVE'));
     $versions = VehicleVersion::model()->findAllByAttributes(array('status' => 'ACTIVE'));
     $cities = City::model()->findAll();
     if (isset($_POST['Search'])) {
         $criteria = new CDbCriteria();
         $date = "";
         $vehicle_or_version = "";
         $columns = array();
         switch ($_POST['Search']['module']) {
             case "TechnicalDate":
                 $columns = array('id:number', 'client.identity:text', 'client.name:text', 'client.lastname:text', 'client.email:text', 'concessioner.name:text', 'work:text', 'preference_date:date', 'hour:text', 'taxi:text', 'detail_work:text', 'creation_date:date');
                 $date = "creation_date";
                 $vehicle_or_version = "vehicle_id";
                 break;
             case "Quotation":
                 $columns = array('id:number', 'client.identity:text', 'client.name:text', 'client.lastname:text', 'client.email:text', 'concessioner.name:text', 'vehicleversion.reference:text', 'vehicleversion2.reference:text', 'time:text', 'registration_date:date');
                 $date = "registration_date";
                 $vehicle_or_version = "vehicle_version_id";
                 break;
             case "Replacement":
                 $columns = array('id:number', 'client.identity:text', 'client.name:text', 'client.lastname:text', 'client.email:text', 'concessioner.name:text', 'part:text');
                 $vehicle_or_version = "vehicle_id";
                 break;
             case "Suggestion":
                 $columns = array('id:number', 'client.identity:text', 'client.name:text', 'client.lastname:text', 'client.email:text', 'concessioner.name:text', 'vehicle.name:text', 'description:text', 'type:text', 'creation_date:date');
                 $date = "creation_date";
                 break;
         }
         if ($_POST['Search']['date_from'] && $_POST['Search']['date_to']) {
             $criteria->addBetweenCondition('creation_date', $_POST['Search']['date_from'], $_POST['Search']['date_to']);
         }
         if ($_POST['Search']['city'] != 0 && $_POST['Search']['concessioner'] == 0) {
             $citiess = City::model()->findByPk($_POST['Search']['city']);
             foreach ($citiess->concessioners as $concessioner) {
                 $criteria->addSearchCondition('concessioner_id', $concessioner->id, "", 'OR');
             }
         } elseif ($_POST['Search']['city'] != 0 && $_POST['Search']['concessioner'] != 0) {
             $criteria->addSearchCondition('concessioner_id', $_POST['Search']['concessioner']);
         }
         if ($_POST['Search']['identity']) {
             $clients = Client::model()->findAllByAttributes(array('identity' => $_POST['Search']['identity']));
             foreach ($clients as $client) {
                 $criteria->addSearchCondition('client_id', $client->id, "", 'OR');
             }
         }
         if ($_POST['Search']['name']) {
             $clients2 = Client::model()->findAllByAttributes(array('name' => $_POST['Search']['name']));
             foreach ($clients2 as $client) {
                 $criteria->addSearchCondition('client_id', $client->id, "", 'OR');
             }
         }
         if ($_POST['Search']['lastname']) {
             $clients3 = Client::model()->findAllByAttributes(array('lastname' => $_POST['Search']['lastname']));
             foreach ($clients3 as $client) {
                 $criteria->addSearchCondition('client_id', $client->id, "", 'OR');
             }
         }
         if ($_POST['Search']['email']) {
             $clients4 = Client::model()->findAllByAttributes(array('email' => $_POST['Search']['email']));
             foreach ($clients4 as $client) {
                 $criteria->addSearchCondition('client_id', $client->id, "", 'OR');
             }
         }
         if ($_POST['Search']['model'] != 0 && $_POST['Search']['version'] == 0) {
             if ($vehicle_or_version == "vehicle_id") {
                 $criteria->addSearchCondition('vehicle_id', $_POST['Search']['model']);
             } elseif ($vehicle_or_version == "vehicle_version_id") {
                 $vehicle1 = Vehicle::model()->findByPk($_POST['Search']['model']);
                 foreach ($vehicle1->vehicleVersions as $version) {
                     $criteria->addSearchCondition('vehicle_version_id', $version->id, "", 'OR');
                     $criteria->addSearchCondition('vehicle_version_id2', $version->id, "", 'OR');
                 }
             }
         } elseif ($_POST['Search']['model'] == 0 && $_POST['Search']['version'] != 0) {
             if ($vehicle_or_version == "vehicle_version_id") {
                 $criteria->addSearchCondition('vehicle_version_id', $_POST['Search']['version'], "", 'OR');
                 $criteria->addSearchCondition('vehicle_version_id2', $_POST['Search']['version'], "", 'OR');
             }
         }
         if ($_POST['Search']['module'] != "0") {
             $pagination = new EDTPagination();
             $criteria->order = "id DESC";
             $pagination->applyLimit($criteria);
             $sort = new EDTSort($_POST['Search']['module'], $columns);
             $sort->defaultOrder = 'id';
             //die(print_r($criteria));
             $dataProvider = new CActiveDataProvider($_POST['Search']['module'], array('criteria' => $criteria, 'pagination' => $pagination, 'sort' => $sort));
         } else {
             $dataProvider = new CActiveDataProvider('TechnicalDate', array('criteria' => $criteria));
         }
         self::$wid = $this->createWidget('ext.EDataTables.EDataTables', array('id' => 'data_table', 'dataProvider' => $dataProvider, 'ajaxUrl' => $this->createUrl('grid/DataTables'), 'columns' => $columns, 'serverData' => array("module" => $_POST['Search']['module']), 'buttons' => array('export' => array('label' => Yii::t('app', 'Save as CSV'), 'text' => false, 'htmlClass' => '', 'icon' => Yii::app()->theme !== null && Yii::app()->theme->name == 'bootstrap' ? 'icon-download-alt' : 'ui-icon-disk', 'url' => $this->createUrl('grid/exportCVS'))), 'options' => array('bStateSave' => false, 'bPaginate' => false, 'bLengthChange' => true, 'iDisplayLength' => 50)));
         if (!Yii::app()->getRequest()->getIsAjaxRequest()) {
             $this->render('index', array('cities' => $cities, 'vehicles' => $vehicles, 'versions' => $versions, 'concessioners' => $concessioners, 'widget' => self::$wid));
             return;
         } else {
             echo json_encode($widget->getFormattedData(intval($_REQUEST['sEcho'])));
             Yii::app()->end();
         }
     } else {
         $this->render('index', array('cities' => $cities, 'vehicles' => $vehicles, 'versions' => $versions, 'concessioners' => $concessioners));
     }
 }
 public function actionIndex()
 {
     $medio = "default";
     if (isset($_GET["medio"])) {
         $medio = $_GET["medio"];
     }
     $client = new Client();
     $vehicle = new VehicleClient();
     $suggestion = new Suggestion();
     $concessioners = Concessioner::model()->findAll();
     $criteria = new CDbCriteria();
     $criteria->order = "name";
     $versions = VehicleVersion::model()->with('vehicle')->findAllbyAttributes(array(), $criteria);
     if (isset($_POST['ajax']) && $_POST['ajax'] === 'suggestion-form') {
         echo CActiveForm::validate($client);
         Yii::app()->end();
     }
     if (isset($_POST['siguiente'])) {
         if (isset($_POST['Client']) && isset($_POST['Suggestion']) && isset($_POST['VehicleClient'])) {
             $client = new Client();
             $client->attributes = $_POST['Client'];
             $client->preference_contact = "email";
             $client->save();
             $vehicle = new VehicleClient();
             $vehicle->attributes = $_POST['VehicleClient'];
             $vehicle->kilometer = "1";
             $vehicle->save();
             $suggestion = new Suggestion();
             $suggestion->attributes = $_POST['Suggestion'];
             $suggestion->type = $_POST['Suggestion']['type'] . "-" . $_POST['Suggestion']['type2'];
             $suggestion->client_id = $client->primaryKey;
             $suggestion->vehicle_id = $vehicle->primaryKey;
             //die(print_r($suggestion));
             $aux = substr($_POST['Suggestion']['type2'], 0, 1);
             if ($suggestion->save()) {
                 $message = new YiiMailMessage();
                 $message->setSubject('Sugerencia del Servicio.');
                 $message->view = 'sugerencia';
                 $message->setBody(array("client" => $client, "vehicle" => $vehicle, "suggestion" => $suggestion), 'text/html');
                 foreach ($suggestion->concessioner->emails as $email) {
                     if ($email->type == "SUGGESTION-{$aux}") {
                         $message->addTo($email->description);
                         // $message->addTo('*****@*****.**');
                         //			$message->addTo("*****@*****.**");
                         $message->addTo("*****@*****.**");
                         $message->addTo("*****@*****.**");
                         $message->addTo("*****@*****.**");
                         $message->addTo("*****@*****.**");
                         $message->addTo("*****@*****.**");
                         /*if($email->type=="SUGGESTION-O"){
                           $message->addTo("*****@*****.**");
                           }*/
                         $message->setFrom(array(Yii::app()->params['adminEmail'] => 'El Equipo Nissan Ecuador'));
                     }
                 }
                 Yii::app()->mail->send($message);
                 $this->render('result', array("client" => $client, "vehicle" => $vehicle, "suggestion" => $suggestion));
             } else {
                 $this->render('error');
             }
         }
         //$this->render('index',array('concessioners'=>$concessioners,"client"=>$client,"vehicle"=>$vehicle,"suggestion"=>$suggestion));
     } else {
         $this->render('index', array('concessioners' => $concessioners, "client" => $client, "vehicle" => $vehicle, "suggestion" => $suggestion, "versions" => $versions, "medio" => $medio));
     }
 }
 public function actionIndex()
 {
     $concessioners = Concessioner::model()->findAll();
     $vehicles = Vehicle::model()->findAllByAttributes(array('status' => 'ACTIVE'));
     $versions = VehicleVersion::model()->findAllByAttributes(array('status' => 'ACTIVE'));
     $cities = City::model()->findAll();
     if (isset($_POST['Search'])) {
         $criteria = new CDbCriteria();
         $date = "";
         $vehicle_or_version = "";
         $columns = array();
         switch ($_POST['Search']['module']) {
             case "TechnicalDate":
                 $columns = array('id', 'client.identity', 'client.name', 'client.lastname', 'client.email', 'client.phone', 'client.preference_contact', 'client.cellphone', 'client.medio', 'vehicle.model', 'vehicle.year', 'vehicle.license_plate', 'vehicle.kilometer', 'concessioner.name', 'concessioner.address', 'work', 'preference_date', 'hour', 'taxi', 'detail_work', 'creation_date');
                 $date = "creation_date";
                 $vehicle_or_version = "vehicle_id";
                 break;
             case "Quotation":
                 $columns = array('id', 'Cédula' => 'client.identity:text', 'Nombre' => 'client.name:text', 'Apellido' => 'client.lastname:text', 'client.email:text', 'client.phone', 'client.preference_contact', 'client.preference_contact2', 'client.cellphone', 'client.localize', 'client.medio', 'concessioner.name', 'Ciudad' => 'concessioner.city.name', 'Vehiculo 1' => 'vehicleversion.vehicle.name', 'Referencia 1 vehículo' => 'vehicleversion.reference', 'Vehiculo 2' => 'vehicleversion2.vehicle.name', 'Referencia 2 vehículo' => 'vehicleversion2.reference', 'Tiempo' => 'time:text', 'Fecha de creación' => 'creation_date');
                 $date = "creation_date";
                 $vehicle_or_version = "vehicle_version_id";
                 break;
             case "Replacement":
                 $columns = array('id:number', 'Cédula' => 'client.identity:text', 'Nombre' => 'client.name:text', 'Apellido' => 'client.lastname:text', 'client.email:text', 'client.phone', 'client.preference_contact', 'client.cellphone', 'client.medio', 'Concesionario' => 'concessioner.name:text', 'Parte a reemplazar' => 'part:text', 'vehicle.model', 'vehicle.year', 'vehicle.license_plate', 'vehicle.kilometer', 'vehicle.chasis', 'Fecha de creación' => 'creation_date');
                 $vehicle_or_version = "vehicle_id";
                 break;
             case "Suggestion":
                 $columns = array('id:number', 'Cédula' => 'client.identity:text', 'Nombre' => 'client.name:text', 'Apellido' => 'client.lastname:text', 'client.email:text', 'client.phone', 'client.preference_contact', 'client.cellphone', 'client.medio', 'Concesionario' => 'concessioner.name:text', 'Vehículo' => 'vehicle.name:text', 'Descripción' => 'description:text', 'Tipo' => 'type:text', 'Fecha de creación' => 'creation_date:date');
                 $date = "creation_date";
                 break;
             case "Satisfaction":
                 $columns = array('id:number', 'Cédula' => 'quotation.client.identity:text', 'Nombre' => 'quotation.client.name:text', 'Apellido' => 'quotation.client.lastname:text', 'quotation.client.email:text', 'quotation.client.phone', 'quotation.client.preference_contact', 'quotation.client.cellphone', 'client.medio', 'Concesionario' => 'quotation.concessioner.name:text', ' Cliente Contactado' => 'contact:text', 'Puntaje' => 'score:text', 'Descripción' => 'description:text', 'Fecha de creación' => 'creation_date:date');
                 $date = "creation_date";
                 break;
             case "SatisfactionR":
                 $columns = array('id:number', 'Cédula' => 'replacement.client.identity:text', 'Nombre' => 'replacement.client.name:text', 'Apellido' => 'replacement.client.lastname:text', 'replacement.client.email:text', 'replacement.client.phone', 'replacement.client.preference_contact', 'replacement.client.cellphone', 'Concesionario' => 'replacement.concessioner.name:text', ' Cliente Contactado' => 'contact:text', 'client.medio', 'Puntaje' => 'score:text', 'Descripción' => 'description:text', 'Fecha de creación' => 'creation_date:date');
                 $date = "creation_date";
                 break;
             case "SatisfactionS":
                 $columns = array('id:number', 'Cédula' => 'suggestion.client.identity:text', 'Nombre' => 'suggestion.client.name:text', 'Apellido' => 'suggestion.client.lastname:text', 'suggestion.client.email:text', 'suggestion.client.phone', 'suggestion.client.preference_contact', 'suggestion.client.cellphone', 'client.medio', 'Concesionario' => 'suggestion.concessioner.name:text', ' Cliente Contactado' => 'contact:text', 'Puntaje' => 'score:text', 'Descripción' => 'description:text', 'Fecha de creación' => 'creation_date:date');
                 $date = "creation_date";
                 break;
         }
         if ($_POST['Search']['date_from'] && $_POST['Search']['date_to']) {
             $criteria->addBetweenCondition('creation_date', $_POST['Search']['date_from'], $_POST['Search']['date_to']);
         }
         if ($_POST['Search']['city'] != 0 && $_POST['Search']['concessioner'] == 0) {
             $citiess = City::model()->findByPk($_POST['Search']['city']);
             foreach ($citiess->concessioners as $concessioner) {
                 $criteria->addSearchCondition('concessioner_id', $concessioner->id, "", 'OR');
             }
         } elseif ($_POST['Search']['city'] != 0 && $_POST['Search']['concessioner'] != 0) {
             $criteria->addSearchCondition('concessioner_id', $_POST['Search']['concessioner']);
         }
         if ($_POST['Search']['identity']) {
             $clients = Client::model()->findAllByAttributes(array('identity' => $_POST['Search']['identity']));
             foreach ($clients as $client) {
                 $criteria->addSearchCondition('client_id', $client->id, "", 'OR');
             }
         }
         if ($_POST['Search']['name']) {
             $clients2 = Client::model()->findAllByAttributes(array('name' => $_POST['Search']['name']));
             foreach ($clients2 as $client) {
                 $criteria->addSearchCondition('client_id', $client->id, "", 'OR');
             }
         }
         if ($_POST['Search']['lastname']) {
             $clients3 = Client::model()->findAllByAttributes(array('lastname' => $_POST['Search']['lastname']));
             foreach ($clients3 as $client) {
                 $criteria->addSearchCondition('client_id', $client->id, "", 'OR');
             }
         }
         if ($_POST['Search']['email']) {
             $clients4 = Client::model()->findAllByAttributes(array('email' => $_POST['Search']['email']));
             foreach ($clients4 as $client) {
                 $criteria->addSearchCondition('client_id', $client->id, "", 'OR');
             }
         }
         if ($_POST['Search']['model'] != 0 && $_POST['Search']['version'] == 0) {
             if ($vehicle_or_version == "vehicle_id") {
                 $criteria->addSearchCondition('vehicle_id', $_POST['Search']['model']);
             } elseif ($vehicle_or_version == "vehicle_version_id") {
                 $vehicle1 = Vehicle::model()->findByPk($_POST['Search']['model']);
                 foreach ($vehicle1->vehicleVersions as $version) {
                     $criteria->addSearchCondition('vehicle_version_id', $version->id, "", 'OR');
                     $criteria->addSearchCondition('vehicle_version_id2', $version->id, "", 'OR');
                 }
             }
         } elseif ($_POST['Search']['model'] == 0 && $_POST['Search']['version'] != 0) {
             if ($vehicle_or_version == "vehicle_version_id") {
                 $criteria->addSearchCondition('vehicle_version_id', $_POST['Search']['version'], "", 'OR');
                 $criteria->addSearchCondition('vehicle_version_id2', $_POST['Search']['version'], "", 'OR');
             }
         }
         if ($_POST['Search']['module'] != "0") {
             $pagination = new EDTPagination();
             $criteria->order = "id DESC";
             $pagination->applyLimit($criteria);
             $sort = new EDTSort($_POST['Search']['module'], $columns);
             $sort->defaultOrder = 'id';
             //die(print_r($criteria));
             self::$dataProvider = new CActiveDataProvider($_POST['Search']['module'], array('criteria' => $criteria, 'pagination' => $pagination, 'sort' => $sort));
         } else {
             self::$dataProvider = new CActiveDataProvider('TechnicalDate', array('criteria' => $criteria));
         }
         $widget2 = $this->widget('EExcelView', array('dataProvider' => self::$dataProvider, 'grid_mode' => 'export', 'title' => 'report', 'autoWidth' => true, 'template' => "{summary}\n{items}\n{exportbuttons}\n{pager}", 'filename' => 'report', 'stream' => false, 'columns' => $columns));
         $widget1 = $this->createWidget('ext.EDataTables.EDataTables', array('id' => 'data_table', 'dataProvider' => self::$dataProvider, 'columns' => $columns, 'serverData' => array("module" => $_POST['Search']['module']), 'buttons' => array('refresh' => null), 'options' => array('bStateSave' => false, 'bPaginate' => false, 'bLengthChange' => true)));
         if (!Yii::app()->getRequest()->getIsAjaxRequest()) {
             $export = 0;
             if ($_POST['Search']['print'] == "YES") {
                 $export = 1;
             }
             $this->render('index', array('cities' => $cities, 'vehicles' => $vehicles, 'versions' => $versions, 'concessioners' => $concessioners, 'widget2' => $widget2, 'widget1' => $widget1, 'export' => $export));
             return;
         } else {
             echo json_encode(self::$wid->getFormattedData(intval($_REQUEST['sEcho'])));
             Yii::app()->end();
         }
     } else {
         $this->render('index', array('cities' => $cities, 'vehicles' => $vehicles, 'versions' => $versions, 'concessioners' => $concessioners));
     }
 }