/** * 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 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)); } }