public function mainAction() { echo "\nSent mails \n"; $mymail = Mail::find("state = 'output' AND active = 1"); foreach ($mymail as $value) { $adressee = Adressee::find("id_mail = " . $value->id_mail . " AND active = 1"); foreach ($adressee as $valueAdress) { $changeInAdress = Adressee::findFirst("id_adresse = " . $valueAdress->id_adresse . " AND active = 1"); $this->libaccess->sendNew($changeInAdress->adresse, $value->subject, $value->content); $changeInAdress->active = 0; $changeInAdress->save(); } $value->state = "sent"; $value->save(); } // var_dump($this); }
/** * This save the changes in adressee and mail */ public function saveChangesMailAdressAction() { //Disable the view $this->view->disable(); if ($this->request->isPost()) { if ($this->request->isAjax()) { //Mail $mailId = $this->request->getPost('id_mail'); $mailSubject = $this->request->getPost('subject'); $mailContent = $this->request->getPost('content'); //Adressee $adressId = $this->request->getPost('id_adresse'); $adress = $this->request->getPost('adress'); //Update Email $selectEmail = Mail::findFirst("id_mail = {$mailId}"); //assign new values $selectEmail->subject = $mailSubject; $selectEmail->content = $mailContent; if ($selectEmail->save()) { //Convert to array $adressId = explode(',', $adressId); $adress = explode(',', $adress); //Update the adressee for ($i = 0; $i < count($adressId); $i++) { $selectAdressee = Adressee::findFirst("id_adresse = {$adressId[$i]}"); //assign $selectAdressee->adresse = $adress[$i]; $selectAdressee->save(); } $this->response->setJsonContent('done'); } else { $this->response->setJsonContent('fail'); } $this->response->setStatusCode(200, "OK"); $this->response->send(); } else { $this->response->setStatusCode(404, "Not Found"); } } }