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 run($args)
 {
     $daynow = date("d");
     $monthnow = date("m");
     $datenow = date("Y-m-d");
     $datenow1 = new DateTime($datenow);
     //die($datenow);
     $quotations = Quotation::model()->findAllByAttributes(array('review' => 'NO'));
     foreach ($quotations as $quotation) {
         // $datequotation=date("Y-m-d",$quotation->registration_date);
         $datequotation1 = new DateTime($quotation->creation_date);
         $aux = date_diff($datenow1, $datequotation1);
         //die(print_r($datequotation1));
         //die(print_r($aux->days));
         if ($aux->days == 2) {
             $message = new YiiMailMessage();
             $message->view = '48hours';
             $message->setBody(array("quotation" => $quotation), 'text/html');
             $message->setSubject('¿Le ofrecieron la información requerida del vehículo Nissan cotizado?. Trabajamos para ofrecerle un mejor servicio.');
             $message->addTo($quotation->client->email);
             $message->from = Yii::app()->params['adminEmail'];
             if (Yii::app()->mail->send($message)) {
                 $quotation->review = "YES";
                 $quotation->save();
             }
         }
     }
     $suggestions = Suggestion::model()->findAllByAttributes(array('review' => 'NO'));
     foreach ($suggestions as $suggestion) {
         // $datequotation=date("Y-m-d",$quotation->registration_date);
         $datequotation1 = new DateTime($suggestion->creation_date);
         $aux = date_diff($datenow1, $datequotation1);
         //die(print_r($datequotation1));
         //die(print_r($aux->days));
         if ($aux->days == 2) {
             $message = new YiiMailMessage();
             $message->view = '48hours_sugerencia';
             $message->setBody(array("suggestion" => $suggestion), 'text/html');
             $message->setSubject('¿Le ofrecieron la información requerida de la sugerencia solicitada.?. Trabajamos para ofrecerle un mejor servicio.');
             $message->addTo($suggestion->client->email);
             $message->from = Yii::app()->params['adminEmail'];
             if (Yii::app()->mail->send($message)) {
                 $suggestion->review = "YES";
                 $suggestion->save();
             }
         }
     }
     $replacements = Replacement::model()->findAllByAttributes(array('review' => 'NO'));
     foreach ($replacements as $replacement) {
         // $datequotation=date("Y-m-d",$quotation->registration_date);
         $datequotation1 = new DateTime($replacement->creation_date);
         $aux = date_diff($datenow1, $datequotation1);
         //die(print_r($datequotation1));
         //die(print_r($aux->days));
         if ($aux->days == 2) {
             $message = new YiiMailMessage();
             $message->view = '48hours_repuesto';
             $message->setBody(array("replacement" => $replacement), 'text/html');
             $message->setSubject('¿Le ofrecieron la información requerida del repuesto Nissan solicitado?. Trabajamos para ofrecerle un mejor servicio.');
             $message->addTo($replacement->client->email);
             $message->from = Yii::app()->params['adminEmail'];
             if (Yii::app()->mail->send($message)) {
                 $replacement->review = "YES";
                 $replacement->save();
             }
         }
     }
     $technicals = TechnicalDate::model()->findAllByAttributes(array('review' => 'NO'));
     foreach ($technicals as $technical) {
         // $datequotation=date("Y-m-d",$quotation->registration_date);
         $datequotation1 = new DateTime($technical->creation_date);
         $aux = date_diff($datenow1, $datequotation1);
         //die(print_r($datequotation1));
         //die(print_r($aux->days));
         if ($aux->days == 2) {
             $message = new YiiMailMessage();
             $message->view = '48hours_agendamiento';
             $message->setBody(array("technical" => $technical), 'text/html');
             $message->setSubject('Nos interesa servirle mejor.');
             $message->addTo($technical->client->email);
             $message->from = Yii::app()->params['adminEmail'];
             if (Yii::app()->mail->send($message)) {
                 $technical->review = "YES";
                 $technical->save();
             }
         }
     }
 }