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");
}
}
}
