public function formAction()
{
$this->view->getJsManager()->addJs('helper/state.js');
$this->view->getJsManager()->addJsVar('urlGetCities', '"' . $this->view->url(array('module' => 'Ajax', 'controller' => 'States', 'action' => 'getCities')) . '"');
$em = $this->getEntityManager('DefaultDb');
if (!is_null($this->getRequest()->getParam('id')) && is_numeric($this->getRequest()->getParam('id'))) {
$idReq = $this->getRequest()->getParam('id');
$user = $em->getRepository('DefaultDb_Entity_User')->find($this->_credentials['id']);
$this->view->dataRequest = $em->getRepository('DefaultDb_Entity_Route')->findOneBy(array('id' => $idReq, 'user' => $user));
}
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
if (is_null($this->view->dataRequest)) {
$route = new DefaultDb_Entity_Route();
} else {
$route = $this->view->dataRequest;
}
$route->setRouteAccepted(1);
$route->setEmail($post['email']);
$route->setFrequency($post['frequency']);
$route->setEffectiveDays($post['effectiveDays']);
$route->setLoadAvailabilityDate(new DateTime($post['startDate']));
$route->setTiresCondition($post['tireCondition']);
$route->setLetterMechanicalConditions($post['mechanicalCondition']);
$route->setPlates($post['activePlates']);
$route->setDriverLicence($post['activeLicense']);
$route->setOwnTarpaulin($post['tarpaulin']);
$route->setSatelitalTracking($post['satelitalTracking']);
$route->setCellularPhone($post['driverPhone']);
$route->setLetters_carry($post['letterCarry']);
$route->setComments($post['comments']);
$sourceState = $em->getRepository('DefaultDb_Entity_State')->find($post['sourceState']);
$route->setStateOrigin($sourceState);
$sourceCity = $em->getRepository('DefaultDb_Entity_City')->find($post['sourceStateCity']);
$route->setMunicipalityOrigin($sourceCity);
$destinyState = $em->getRepository('DefaultDb_Entity_State')->find($post['destinyState']);
$route->setStateDestiny($destinyState);
$destinyCity = $em->getRepository('DefaultDb_Entity_City')->find($post['destinyStateCity']);
$route->setMunicipalityDestiny($destinyCity);
$vehicle = $em->getRepository('DefaultDb_Entity_Vehicle')->find($post['vehicleCB']);
$route->setVehicle($vehicle);
$vehicleType = $em->getRepository('DefaultDb_Entity_VehicleType')->find($post['vehicleTypeCB']);
$route->setVehicleType($vehicleType);
$user = $em->getRepository('DefaultDb_Entity_User')->find($this->_credentials['id']);
$route->setUser($user);
$em->persist($route);
$em->flush();
$date = $route->getLoadAvailabilityDate()->format('Y-m-d');
$emailUser = $em->getRepository('DefaultDb_Entity_User');
$this->view->email = $emailUser->getEmailUser($this->_credentials['id']);
foreach ($this->view->email as $value) {
$emailAgent = $value['username'];
}
////////////////////////////////////////////////////////////////////
// Mi Panel //
// Rutas que coinciden con cargas //
////////////////////////////////////////////////////////////////////
$Shipments = $em->getRepository('DefaultDb_Entity_Shipment');
$this->view->getShipment = $Shipments->getNotificationForShipments($vehicle->getId(), $destinyState->getId(), $destinyCity->getId(), $date);
$countShipmentsPanel = count($this->view->getShipment);
if ($countShipmentsPanel >= 1) {
foreach ($this->view->getShipment as $key) {
$this->view->idShipment .= $key['Shipments_Id'] . ',';
}
$event_panel = new DefaultDb_Entity_EventPanel();
$event_panel->setEvent('routes');
$event_panel->setIdUser($this->_credentials['id']);
$event_panel->setIdEvent($route->getId());
$event_panel->setCoincidenceNumber($this->view->idShipment);
$event_panel->setCreationDate($route->getLoadAvailabilityDate());
$event_panel->setStatus('0');
$event_panel->setDataHidden('0');
$em->persist($event_panel);
$em->flush();
}
///////////////////////////////////////////////////////////////////
// Mi Panel
// Rutas que coinciden con una notificacion //
////////////////////////////////////////////////////////////////////
$routesNotification = $em->getRepository('DefaultDb_Entity_Notification');
$actionType = '2';
$this->view->routesNotifications = $routesNotification->getCoincidenceEvent($actionType, $vehicle->getId(), $destinyState->getId(), $destinyCity->getId());
$countRoutesNotification = count($this->view->routesNotifications);
if ($countRoutesNotification != 0) {
foreach ($this->view->routesNotifications as $key) {
$this->view->idNotification = $key['Id_Notification'] . ',';
}
$em = $this->getEntityManager('DefaultDb');
$notificationEventPanel = new DefaultDb_Entity_EventPanel();
$notificationEventPanel->setEvent('routes');
$notificationEventPanel->setIdUser($this->_credentials['id']);
$notificationEventPanel->setIdEvent($route->getId());
$notificationEventPanel->setCreationDate($route->getLoadAvailabilityDate());
$notificationEventPanel->setStatus('0');
$notificationEventPanel->setDataHidden('0');
$notificationEventPanel->setCoincidenceEvent('3');
$notificationEventPanel->setCoincidenceNumber($this->view->idNotification);
$em->persist($notificationEventPanel);
$em->flush();
}
$getZone = $em->getRepository('DefaultDb_Entity_Zone');
$this->view->getZone = $getZone->getZone($destinyState->getId(), $destinyCity->getId());
$countZone = count($this->view->getZone);
if ($countZone <= 0) {
$this->view->messageZone = "* NOTA: Por el momento nuestro sistema no encuentra resultados que coincidan con una zona.<br />";
}
if ($countZone != 0) {
foreach ($this->view->getZone as $key) {
$this->view->numberZone = $key['Number_Zone'];
$this->view->nameZone = $key['Name_Zone'];
}
$this->view->shipmentZone = $Shipments->getSearchShipmentsForZone($vehicle->getId(), $this->view->numberZone, $date);
$countShipmentZone = count($this->view->shipmentZone);
if ($countShipmentZone >= 0) {
while ($value = $this->view->shipmentZone->fetch(PDO::FETCH_ASSOC)) {
$this->view->id .= $value['Shipments_Id'] . '<br />';
$this->view->destiny .= $value['City_Destiny_Name'] . ' , ' . $value['State_D_Abbrev'] . '<br />';
$this->view->origin .= $value['City_Origin_Name'] . ' , ' . $value['State_O_Abbrev'] . '<br />';
$this->view->vehicle .= $value['Vehicle_Name'] . ' De ' . $value['Vehicle_Type_Name'] . '<br />';
$this->view->Date .= $value['New_Availability_Date'] . '<br />';
$this->view->Comments .= $value['Comment'] . '<br />';
$this->view->Zone .= $value['Zone_Name'] . '<br />';
}
$this->view->detailsZone = '<table border="1" cellpadding="3" cellspacing="3"style=" font-size: 11px;">
<tr>
<td align="center"><strong>Carga</strong></td>
<td align="center"><strong>Destino</strong></td>
<td align="center"><strong>Vehículo</strong></td>
<td align="center"><strong>Disponible Hasta</strong></td>
<td align="center"><strong>Comentarios</strong></td>
<td align="center"><strong>Zona</strong></td>
</tr>
<tr>
<td align="center"> ' . $this->view->id . '</td>
<td> ' . $this->view->destiny . '</td>
<td> ' . $this->view->vehicle . '</td>
<td> ' . $this->view->Date . '</td>
<td> ' . $this->view->Comments . '</td>
<td> ' . $this->view->Zone . '</td>
</tr>
</table><br />';
$this->view->messageZone = '* NOTA: Esta ruta se encuentra dentro de la Zona No. ' . $this->view->numberZone . ' ( ' . $this->view->nameZone . ' )' . ' y coincide con Cargas.<br />';
}
}
/////////////////////////////////////////////////////////////////////
//
// E::N::V::I::O:: C::O::R::R::E::O
//
/////////////////////////////////////////////////////////////////////
///////////////////////////////////////
// //
// ::: CONFIGURATIONS ::: //
// //
///////////////////////////////////////
$resultConfiguration = $em->getRepository('DefaultDb_Entity_ConfigurationEmail');
$this->view->resultConfiguration = $resultConfiguration->getDetailsConfigurations($this->_credentials['id']);
while ($rowConfigurations = $this->view->resultConfiguration->fetch(PDO::FETCH_ASSOC)) {
$routesConfig = $rowConfigurations['send_routes'];
$notificationsConfig = $rowConfigurations['send_notifications'];
$emailAdd = $rowConfigurations['email'];
}
/////////////////////////////////////////////////////////////////////
// Buscar rutas que coinicdan con un notificacion registrada y //
// que se envie al correo, aun no funciona si el usuario quiere //
// o no que se le envíen. //
// //
// ActionType: 1(Shipment), 2(Routes) //
/////////////////////////////////////////////////////////////////////
if ($notificationsConfig == 0) {
$notification = $em->getRepository('DefaultDb_Entity_Notification');
$actiontype = '2';
$this->view->email = $notification->getEmailForSend($actiontype, $vehicle->getId(), $destinyState->getId(), $destinyCity->getId());
$countEmail = count($this->view->email);
if ($countEmail != 0) {
foreach ($this->view->email as $var) {
$this->view->idofnotification .= $var['id'];
$this->view->emailforuser .= $var['email'];
$this->view->notificationdate = $var['Notification_Date_Format'];
}
$routes = $em->getRepository('DefaultDb_Entity_Route');
$this->view->routes = $routes->getNotificationForRoutes($vehicle->getId(), $destinyState->getId(), $destinyCity->getId(), $this->view->notificationdate);
$countRoutes = count($this->view->routes);
if ($countRoutes != 0) {
list($typeText, $eventText) = $route->getTypeText();
foreach ($this->view->routes as $key) {
$this->view->idRoutes .= $key['Route_Id'] . '<br />';
$this->view->destinyRoutes .= $key['City_Destiny_Name'] . ' , ' . $key['State_D_Abbrev'] . '<br />';
$this->view->originRoutes .= $key['City_Origin_Name'] . ' , ' . $key['State_O_Abbrev'] . '<br />';
$this->view->vehicleRoutes .= $key['Vehicle_Name'] . ' De ' . $key['Vehicle_Type_Name'] . '<br />';
$this->view->Date .= $key['New_Availability_Date'] . '<br />';
$this->view->Comments .= $key['Comment'] . '<br />';
}
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px">
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de unidades disponibles en MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:12px;line-height:16px;">
<strong>Tenemos ' . $countRoutes . ' unidades de tu interés que están disponibles.</strong><br /><br />
<table border="1" cellpadding="3" cellspacing="3" style="font-size:12px;">
<tr>
<td align="center"><strong>' . $typeText . ' No.</strong></td>
<td align="center"><strong>Origen</strong></td>
<td align="center"><strong>Destino</strong></td>
<td align="center"><strong>Vehículo</strong></td>
<td align="center"><strong>Disponible Hasta</strong></td>
<td align="center"><strong>Comentarios</strong></td>
</tr>
<tr>
<td align="center"> ' . $this->view->idRoutes . '</td>
<td> ' . $this->view->originRoutes . '</td>
<td> ' . $this->view->destinyRoutes . '</td>
<td> ' . $this->view->vehicleRoutes . '</td>
<td> ' . $this->view->Date . '</td>
<td> ' . $this->view->Comments . '</td>
</tr>
</table><br />
<strong>Otros clientes interesados en estas rutas también han sido notificados.</strong><br /><br />
<strong>Si deseas ser notificado de otras rutas por favor, contáctanos.</strong><br /><br />
<strong>De interesarte alguna de ellas contacta a tu coordinador o comunícate a los siguientes teléfonos:</strong><br />
<strong>Nextel: 62 * 179099 *5 ó *2 ó al 01 - 444 - 2571546 con Arturo Macías</strong><br />
<strong>Oficina: 01 - 444 - 8240764 Con Cesar Castillo</strong><br />
<strong>Oficina: 01 - 444 - 8240647</strong><br />
<strong>Correo : masfletes@masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de Mas Fletes';
$mail->AddAddress($emailAgent, 'Coordinador');
/* foreach (explode(',', $this->view->emailforuser) as $varx)
{
$mail->AddAddress($varx);
}*/
$mail->Subject = 'Notificaciones de ' . $typeText . ' de Mas Fletes';
$mail->MsgHTML($correo);
$mail->Send();
}
}
}
////////////////////////////////////////////////////////////////////
// //
// BUSQUEDA DE CARGAS QUE COINCIDEN O NO CON RUTA //
// //
////////////////////////////////////////////////////////////////////
if ($routesConfig == 0) {
$coincide = $em->getRepository('DefaultDb_Entity_Shipment');
$this->view->coincide = $coincide->getNotificationForShipments($vehicle->getId(), $destinyState->getId(), $destinyCity->getId(), $date);
$countShipments = count($this->view->coincide);
////////////////////////////////////////////////////////////////////
// //
// Esta sección envía correos a: Coordinadores cuando no //
// encuentra coincidnecia con alguna carga //
// //
////////////////////////////////////////////////////////////////////
if ($countShipments <= 0) {
list($typeText, $eventText) = $route->getTypeText();
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px">
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de ' . $typeText . ' de MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:13px;line-height:16px;">
<strong>Un usuario acaba de registrar una ' . $typeText . ' con estos datos:</strong><br /><br />
<strong>* Correo: ' . $route->getUser()->getUsername() . ' </strong><br />
<strong>* ' . $typeText . ' número: </strong>' . $route->getId() . '<br />
<strong>* De: </strong>' . utf8_decode($sourceCity->getName() . ' , ' . $sourceState->getName()) . '<br />
<strong>* A: </strong>' . utf8_decode($destinyCity->getName() . ' , ' . $destinyState->getName()) . '<br />
<strong>* Con Vehículo: </strong> ' . $vehicle->getName() . ' , ' . $vehicleType->getName() . '<br />
<strong>* Fecha Disponible: </strong>' . $date . '<br />
<strong>* Comentarios: </strong>' . $route->getComments() . '<br /><br />
<strong>* NOTA: Por el momento ninguna de nuestras opciones arrojan resultados con los datos de esta ' . $typeText . '. **</strong> <br /> <br />
<strong>' . $this->view->messageZone . '</strong><br />
<strong>Gracias por utilizar MasFletes.</strong><br />
<strong>www.masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de Mas Fletes';
$mail->AddAddress($emailAgent, 'Coordinador');
if ($emailAdd != "") {
$mail->AddBCC('' . $emailAdd . '', "Usuario Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de Mas Fletes';
$mail->MsgHTML($correo);
$mail->Send();
}
////////////////////////////////////////////////////////////////////
// //
// Esta sección envía correos a: Coordinador cuando si //
// encuentra una ruta que coincide con la carga ingresada //
// //
////////////////////////////////////////////////////////////////////
if ($countShipments != 0) {
foreach ($this->view->coincide as $key) {
$this->view->idShipments .= $key['Shipments_Id'] . '<br />';
$this->view->emailShipments .= $key['EmailUser'] . '<br />';
$this->view->comShipments .= $key['Comment'] . '<br />';
$this->view->dateShipments .= $key['New_Availability_Date'] . '<br />';
}
list($typeText, $eventText) = $route->getTypeText();
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px">
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de ' . $typeText . ' de MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:13px;line-height:16px;">
<strong>Se encontraron las siguientes ' . $eventText . ' que coinciden con la publicación de un usuario, los detalles son: </strong><br /><br />
<strong>* Correo: ' . $route->getUser()->getUsername() . ' </strong><br /><br />
<strong>Por favor contactar con los correos electronicos que aparecen acontinuación:</strong><br /><br />
<strong>INFORMACIÓN GENERAL</strong><br />
<strong>**************************************************************************************</strong><br />
<strong>* Ruta No.:' . $route->getId() . '<br />
<strong>* De: </strong>' . utf8_decode($sourceCity->getName() . ' , ' . $sourceState->getName()) . '<br />
<strong>* A: </strong>' . utf8_decode($destinyCity->getName() . ' , ' . $destinyState->getName()) . '<br />
<strong>* Con Vehículo: </strong> ' . $vehicle->getName() . ' , ' . $vehicleType->getName() . '<br />
<strong>**************************************************************************************</strong><br /><br />
<table border="1" cellpadding="5" cellspacing="5">
<tr>
<td align="center"><strong>Carga</strong></td>
<td align="center"><strong>Correo</strong></td>
<td align="center"><strong>Comentario</strong></td>
<td align="center"><strong>Fecha Carga</strong></td>
</tr>
<tr>
<td> ' . $this->view->idShipments . '</td>
<td> ' . $this->view->emailShipments . '</td>
<td> ' . $this->view->comShipments . '</td>
<td> ' . $this->view->dateShipments . '</td>
</tr>
</table><br /><br />
<strong>' . $this->view->messageZone . '</strong><br />
<strong>' . $this->view->detailsZone . '</strong><br />
<strong>Gracias por utilizar MasFletes.</strong><br />
<strong>www.masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de Mas Fletes';
$mail->AddAddress($emailAgent, 'Coordinador');
if ($emailAdd != "") {
$mail->AddBCC('' . $emailAdd . '', "Usuario Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de Mas Fletes';
$mail->MsgHTML($correo);
$mail->Send();
}
}
if (is_null($this->view->dataRequest)) {
Model3_Site::setTempMsg("msg", "La ruta ha sido registrada correctamente");
} else {
Model3_Site::setTempMsg("msg", "Cambios guardados correctamente");
}
$this->redirect("Agent/" . $this->getRequest()->getController() . "/form");
}
}
public function formAction()
{
$this->view->getJsManager()->addJs('helper/state.js');
$this->view->getJsManager()->addJsVar('urlGetCities', '"' . $this->view->url(array('module' => 'Ajax', 'controller' => 'States', 'action' => 'getCities')) . '"');
if (!is_null($this->getRequest()->getParam('id')) && is_numeric($this->getRequest()->getParam('id'))) {
$idReq = $this->getRequest()->getParam('id');
$em = $this->getEntityManager('DefaultDb');
$this->view->dataRequest = $em->getRepository('DefaultDb_Entity_Shipment')->find($idReq);
}
if ($this->getRequest()->isPost()) {
$em = $this->getEntityManager('DefaultDb');
$post = $this->getRequest()->getPost();
if (is_null($this->view->dataRequest)) {
$shipment = new DefaultDb_Entity_Shipment();
} else {
$shipment = $this->view->dataRequest;
}
$sourceD = new DateTime($post['sourceDate']);
$destinyD = new DateTime($post['destinyDate']);
$shipment->setContactName("");
$shipment->setContactPhone("");
$shipment->setCreation_date(new DateTime());
$shipment->setShipmentAccepted(1);
$shipment->setSourceAddress($post['sourceAddress']);
$shipment->setSourceDate($sourceD);
$shipment->setDestinyAddress($post['destinyAddress']);
$shipment->setDestinyDate($destinyD);
$shipment->setFrequency($post['frequency']);
$shipment->setEffectiveDays($post['effectiveDays']);
$shipment->setComments($post['comments']);
$sourceState = $em->getRepository('DefaultDb_Entity_State')->find($post['sourceState']);
$shipment->setStateOrigin($sourceState);
$sourceCity = $em->getRepository('DefaultDb_Entity_City')->find($post['sourceStateCity']);
$shipment->setMunicipalityOrigin($sourceCity);
$destinyState = $em->getRepository('DefaultDb_Entity_State')->find($post['destinyState']);
$shipment->setStateDestiny($destinyState);
$destinyCity = $em->getRepository('DefaultDb_Entity_City')->find($post['destinyStateCity']);
$shipment->setMunicipalityDestiny($destinyCity);
$vehicle = $em->getRepository('DefaultDb_Entity_Vehicle')->find($post['vehicleCB']);
$shipment->setVehicle($vehicle);
$vehicleType = $em->getRepository('DefaultDb_Entity_VehicleType')->find($post['vehicleTypeCB']);
$shipment->setVehicleType($vehicleType);
$shipmentType = $em->getRepository('DefaultDb_Entity_ShipmentType')->find($post['shipmentTypeCB']);
$shipment->setShipmentType($shipmentType);
$user = $em->getRepository('DefaultDb_Entity_User')->find($this->_credentials['id']);
$shipment->setUser($user);
$em->persist($shipment);
$em->flush();
/*$connection = $em->getConnection();
$statement = $connection->executeQuery('
SELECT u.*
FROM notifications n
LEFT JOIN users u
ON n.user_id = u.id
WHERE action_type = '.DefaultDb_Entity_Notification::ACTION_TYPE_SHIPMENT.'
AND state_origin_id = '.$sourceState->getId().'
AND state_destiny_id = '.$destinyState->getId().'
AND municipality_origin_id = '.$sourceCity->getId().'
AND municipality_destiny_id = '.$destinyCity->getId().'
AND vehicle_id = '.$vehicle->getId().'
AND vehicle_type_id = '.$vehicleType->getId().'
');
$users = $statement->fetchAll();
if(is_array($users) && count($users) > 0)
{
//mandar correo a estos usuarios
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'ssl://boxpeople.boxpeople.net';
$mail->Port = 465;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Administracion Mas Fletes';
foreach($users as $u)
{
$mail->AddAddress($u['username']);
}
$mail->Subject = 'Notificacion de nueva carga';
$mail->Body = 'Se ha agregado una nueva carga desde con las siguientes características:<br /><br />';
$mail->Body .= 'Estado de origen: '.$sourceState->getName().'<br />';
$mail->Body .= 'Ciudad de origen: '.$sourceCity->getName().'<br />';
$mail->Body .= 'Estado de destino: '.$destinyState->getName().'<br />';
$mail->Body .= 'Ciudad de destino: '.$destinyCity->getName().'<br />';
$mail->Body .= 'Vehículo: '.$vehicle->getName().'<br />';
$mail->Body .= 'Tipo de vehículo: '.$vehicleType->getName().'<br />';
$mail->IsHTML (true);
$mail->Send();
}*/
$date = $shipment->getSourceDate()->format('Y-m-d');
$emailUser = $em->getRepository('DefaultDb_Entity_User');
$this->view->email = $emailUser->getEmailUser($this->_credentials['id']);
foreach ($this->view->email as $value) {
$emailCustomer = $value['username'];
}
$this->view->emailCordinator = $emailUser->getEmailCordinator();
////////////////////////////////////////////////////////////////////
// Mi Panel
// Cargas que coinciden con Rutas //
////////////////////////////////////////////////////////////////////
$Routes = $em->getRepository('DefaultDb_Entity_Route');
$this->view->getRoute = $Routes->getNotificationForRoutes($vehicle->getId(), $destinyState->getId(), $destinyCity->getId(), $date);
$count = count($this->view->getRoute);
if ($count != 0) {
foreach ($this->view->getRoute as $key) {
$this->view->idRoute .= $key['Route_Id'] . ',';
}
$event_panel = new DefaultDb_Entity_EventPanel();
$event_panel->setEvent('shipments');
$event_panel->setIdUser($this->_credentials['id']);
$event_panel->setIdEvent($shipment->getId());
$event_panel->setCoincidenceNumber($this->view->idRoute);
$event_panel->setCreationDate($shipment->getSourceDate());
$event_panel->setStatus('0');
$event_panel->setDataHidden('0');
$em->persist($event_panel);
$em->flush();
}
$getZone = $em->getRepository('DefaultDb_Entity_Zone');
$this->view->getZone = $getZone->getZone($destinyState->getId(), $destinyCity->getId());
$countZone = count($this->view->getZone);
if ($countZone <= 0) {
$this->view->messageZone = "* NOTA: Por el momento nuestro sistema no encuentra resultados que coincidan con una zona.<br />";
}
if ($countZone != 0) {
foreach ($this->view->getZone as $key) {
$this->view->numberZone = $key['Number_Zone'];
$this->view->nameZone = $key['Name_Zone'];
}
$this->view->routeZone = $Routes->getSearchRoutesForZone($vehicle->getId(), $this->view->numberZone, $date);
$countRouteZone = count($this->view->routeZone);
if ($countRouteZone >= 0) {
while ($value = $this->view->routeZone->fetch(PDO::FETCH_ASSOC)) {
$this->view->id .= $value['Route_Id'] . '<br />';
$this->view->destiny .= $value['City_Destiny_Name'] . ' , ' . $value['State_D_Abbrev'] . '<br />';
$this->view->origin .= $value['City_Origin_Name'] . ' , ' . $value['State_O_Abbrev'] . '<br />';
$this->view->vehicle .= $value['Vehicle_Name'] . ' De ' . $value['Vehicle_Type_Name'] . '<br />';
$this->view->Date .= $value['New_Availability_Date'] . '<br />';
$this->view->Comments .= $value['Comment'] . '<br />';
$this->view->Zone .= $value['Zone_Name'] . '<br />';
}
$this->view->detailsZone = '<table border="1" cellpadding="3" cellspacing="3" style="font-size:12px;">
<tr>
<td align="center"><strong>Ruta</strong></td>
<td align="center"><strong>Destino</strong></td>
<td align="center"><strong>Vehículo</strong></td>
<td align="center"><strong>Disponible Hasta</strong></td>
<td align="center"><strong>Comentarios</strong></td>
<td align="center"><strong>Zona</strong></td>
</tr>
<tr>
<td align="center"> ' . $this->view->id . '</td>
<td> ' . $this->view->destiny . '</td>
<td> ' . $this->view->vehicle . '</td>
<td> ' . $this->view->Date . '</td>
<td> ' . $this->view->Comments . '</td>
<td> ' . $this->view->Zone . '</td>
</tr>
</table><br />';
$this->view->messageZone = '* NOTA: Esta carga se encuentra dentro de la Zona No. ' . $this->view->numberZone . ' ( ' . $this->view->nameZone . ' )' . ' y coincide con Rutas.<br />';
}
}
///////////////////////////////////////////////////////////////////
// Mi Panel //
// Cargas que coinciden con una notificacion //
///////////////////////////////////////////////////////////////////
$shipmentsNotification = $em->getRepository('DefaultDb_Entity_Notification');
$actionType = '1';
$this->view->shipmentsNotification = $shipmentsNotification->getCoincidenceEvent($actionType, $vehicle->getId(), $destinyState->getId(), $destinyCity->getId());
$countShipmentsNotification = count($this->view->shipmentsNotification);
if ($countShipmentsNotification != 0) {
foreach ($this->view->shipmentsNotification as $key) {
$this->view->idNotification = $key['Id_Notification'] . ',';
}
$em = $this->getEntityManager('DefaultDb');
$notificationEventPanel = new DefaultDb_Entity_EventPanel();
$notificationEventPanel->setEvent('shipments');
$notificationEventPanel->setIdUser($this->_credentials['id']);
$notificationEventPanel->setIdEvent($shipment->getId());
$notificationEventPanel->setCreationDate($shipment->getSourceDate());
$notificationEventPanel->setStatus('0');
$notificationEventPanel->setDataHidden('0');
$notificationEventPanel->setCoincidenceEvent('3');
$notificationEventPanel->setCoincidenceNumber($this->view->idNotification);
$em->persist($notificationEventPanel);
$em->flush();
}
/////////////////////////////////////////////////////////////////////
//
// E::N::V::I::O:: C::O::R::R::E::O
//
/////////////////////////////////////////////////////////////////////
//////////////////////////////////////
// //
// ::: CONFIGURATIONS ::: //
// //
/////////////////////////////////////
$resultConfiguration = $em->getRepository('DefaultDb_Entity_ConfigurationEmail');
$this->view->resultConfiguration = $resultConfiguration->getDetailsConfigurations($this->_credentials['id']);
while ($rowConfigurations = $this->view->resultConfiguration->fetch(PDO::FETCH_ASSOC)) {
$shipmentsConfig = $rowConfigurations['send_shipments'];
$notificationsConfig = $rowConfigurations['send_notifications'];
$emailAdd = $rowConfigurations['email'];
}
/////////////////////////////////////////////////////////////////////
// Buscar cargas que coinicdan con un notificacion registrada y //
// que se envie al correo, aun no funciona si el usuario quiere //
// o no que se le envíen. //
//
// ActionType: 1(Shipment), 2(Routes) //
/////////////////////////////////////////////////////////////////////
if ($notificationsConfig == 0) {
$notification = $em->getRepository('DefaultDb_Entity_Notification');
$actiontype = '1';
$this->view->email = $notification->getEmailForSend($actiontype, $vehicle->getId(), $destinyState->getId(), $destinyCity->getId());
$countEmail = count($this->view->email);
if ($countEmail != 0) {
foreach ($this->view->email as $var) {
$this->view->idofnotification .= $var['id'];
$this->view->emailforuser .= $var['email'];
$this->view->notificationdate = $var['Notification_Date_Format'];
}
$shipments = $em->getRepository('DefaultDb_Entity_Shipment');
$this->view->shipments = $shipments->getNotificationForShipments($vehicle->getId(), $destinyState->getId(), $destinyCity->getId(), $this->view->notificationdate);
$countShipments = count($this->view->shipments);
if ($countShipments != 0) {
list($typeText, $eventText) = $shipment->getTypeText();
foreach ($this->view->shipments as $key) {
$this->view->idShipments .= $key['Shipments_Id'] . '<br />';
$this->view->destinyShipments .= $key['City_Destiny_Name'] . ' , ' . $key['State_Destiny_Name'] . '<br />';
$this->view->originShipments .= $key['City_Origin_Name'] . ' , ' . $key['State_Origin_Name'] . '<br />';
$this->view->vehicleShipments .= $key['Vehicle_Name'] . ' De ' . $key['Vehicle_Type_Name'] . '<br />';
$this->view->Date .= $key['New_Availability_Date'] . '<br />';
$this->view->Comments .= $key['Comment'] . '<br />';
}
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px">
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de ' . $typeText . ' de MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:12px;line-height:16px;">
<strong>Tenemos ' . $countShipments . ' ' . $typeText . ' de tu interés que están disponibles.</strong><br /><br />
<table border="1" cellpadding="3" cellspacing="3" style="font-size:12px;">
<tr>
<td align="center"><strong>' . $typeText . ' No.</strong></td>
<td align="center"><strong>Origen</strong></td>
<td align="center"><strong>Destino</strong></td>
<td align="center"><strong>Vehículo</strong></td>
<td align="center"><strong>Disponible Hasta</strong></td>
<td align="center"><strong>Comentarios</strong></td>
</tr>
<tr>
<td align="center"> ' . $this->view->idShipments . '</td>
<td> ' . $this->view->originShipments . '</td>
<td> ' . $this->view->destinyShipments . '</td>
<td> ' . $this->view->vehicleShipments . '</td>
<td> ' . $this->view->Date . '</td>
<td> ' . $this->view->Comments . '</td>
</tr>
</table><br />
<strong>Otros clientes interesados en estas ' . $typeText . ' también han sido notificados.</strong><br /><br />
<strong>Si deseas ser notificado de otras rutas por favor, contáctanos.</strong><br /><br />
<strong>De interesarte alguna de ellas contacta a tu coordinador o comunícate a los siguientes teléfonos:</strong><br /><br />
<strong>Gracias por utilizar MasFletes.</strong><br />
<strong>www.masfletes.com</strong><br />
<strong>Nextel: 62 * 179099 *5 ó *2 ó al 01 - 444 - 2571546 con Arturo Macías</strong><br />
<strong>Oficina: 01 - 444 - 8240764 Con Cesar Castillo</strong><br />
<strong>Oficina: 01 - 444 - 8240647</strong><br />
<strong>Correo : masfletes@masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de Mas Fletes';
$mail->AddAddress($emailAgent, 'Coordinador');
$mail->AddBCC($emailCustomer, 'Usuario Mas Fletes');
if ($emailAdd != "") {
$mail->AddBCC('' . $emailAdd . '', "Usuario Mas Fletes");
}
foreach ($this->view->emailCordinator as $value) {
$mail->AddBCC($value['username'], "Coordinador De Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de Mas Fletes';
$mail->MsgHTML($correo);
$mail->Send();
}
}
}
////////////////////////////////////////////////////////////////////
// //
// BUSQUEDA DE RUTAS QUE COINCIDEN O NO //
// //
////////////////////////////////////////////////////////////////////
if ($shipmentsConfig == 0) {
$coincide = $em->getRepository('DefaultDb_Entity_Route');
$this->view->coincide = $coincide->getNotificationForRoutes($vehicle->getId(), $destinyState->getId(), $destinyCity->getId(), $date);
$countRoute = count($this->view->coincide);
////////////////////////////////////////////////////////////////////
// //
// Esta sección envía correos a: Coordinadores cuando no //
// encuentra coincidnecia con alguna rutas //
// //
////////////////////////////////////////////////////////////////////
if ($countRoute <= 0) {
list($typeText, $eventText) = $shipment->getTypeText();
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px>
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de ' . $typeText . ' de MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:13px;line-height:16px;">
<strong>Un usuario acaba de registrar una ' . $typeText . ' con estos datos:</strong><br /><br />
<strong>* Correo: ' . $shipment->getUser()->getUsername() . ' </strong><br /><br />
<strong>* ' . $typeText . ' número: </strong>' . $shipment->getId() . '<br />
<strong>* De: </strong>' . $sourceCity->getName() . ' , ' . $sourceState->getName() . '<br />
<strong>* A: </strong>' . $destinyCity->getName() . ' , ' . $destinyState->getName() . '<br />
<strong>* Con Vehículo: </strong>' . $vehicle->getName() . ' , ' . $vehicleType->getName() . '<br />
<strong>* Fecha Carga: </strong>' . $date . '<br />
<strong>* Comentarios: </strong>' . $shipment->getComments() . '<br /><br />
<strong>* NOTA: Por el momento ninguna de nuestras opciones arrojan resultados con los datos de esta ' . $typeText . '. **</strong> <br /> <br />
<strong>' . $this->view->messageZone . '</strong><br /><br />
<strong>Gracias por utilizar MasFletes.</strong><br />
<strong>www.masfletes.com</strong><br />
<strong>Nextel: 62 * 179099 *5 ó *2 ó al 01 - 444 - 2571546 con Arturo Macías</strong><br />
<strong>Oficina: 01 - 444 - 8240764 Con Cesar Castillo</strong><br />
<strong>Oficina: 01 - 444 - 8240647</strong><br />
<strong>Correo : masfletes@masfletes.com</strong><br /><br />´
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de MasFletes';
foreach ($this->view->emailCordinator as $value) {
$mail->AddBCC($value['username'], "Coordinador De Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de MasFletes';
$mail->MsgHTML($correo);
$mail->Send();
}
////////////////////////////////////////////////////////////////////
// //
// Esta sección envía correos a: Usuario quien registro la carga //
// cuando no encuentra coincidencia cona alguna ruta //
// //
////////////////////////////////////////////////////////////////////
//Esta sección no esta disponible para el coordinador
if ($countRoute <= 0) {
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px">
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de ' . $typeText . ' de MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:13px;line-height:16px;">
<strong>Gracias por utilizar nuestros servicios.</strong><br />
<strong>Su publicación estara a la vista para todos los ususarios. </strong><br />
<strong>Por favor siga en contacto con nosotros.</strong><br /><br />
<strong>* NOTA: Por el momento ninguna de nuestras opciones arrojan resultados con los datos de esta ' . $typeText . '. *</strong> <br /> <br />
<strong>' . $this->view->messageZone . '</strong><br /><br />
<strong>Gracias por utilizar MasFletes.</strong><br />
<strong>www.masfletes.com</strong><br />
<strong>Nextel: 62 * 179099 *5 ó *2 ó al 01 - 444 - 2571546 con Arturo Macías</strong><br />
<strong>Oficina: 01 - 444 - 8240764 Con Cesar Castillo</strong><br />
<strong>Oficina: 01 - 444 - 8240647</strong><br />
<strong>Correo : masfletes@masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de MasFletes';
$mail->AddAddress($emailCustomer, 'Usuario Mas Fletes');
if ($emailAdd != "") {
$mail->AddCC('' . $emailAdd . '', "Usuario Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de MasFletes';
$mail->MsgHTML($correo);
$mail->Send();
}
////////////////////////////////////////////////////////////////////
// //
// Esta sección envía correos a: Coordinador cuando si //
// encuentra una ruta que coincide con la carga ingresada //
// //
////////////////////////////////////////////////////////////////////
if ($countRoute != 0) {
foreach ($this->view->coincide as $key) {
$this->view->idRoutes .= $key['Route_Id'] . '<br />';
$this->view->emailRoutes .= $key['EmailUser'] . '<br />';
$this->view->comRoutes .= $key['Comment'] . '<br />';
$this->view->dateRoutes .= $key['New_Availability_Date'] . '<br />';
}
list($typeText, $eventText) = $shipment->getTypeText();
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px>
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de ' . $typeText . ' de MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:13px;line-height:16px;">
<strong>Se encontraron las siguientes ' . $eventText . ' que coinciden con la publicación del usuario, los detalles son: </strong><br />
<strong>* Correo: ' . $shipment->getUser()->getUsername() . ' </strong><br /><br />
<strong>Por favor contactar con los correos electronicos que aparecen acontinuación:</strong><br /><br />
<strong>INFORMACIÓN GENERAL</strong><br />
<strong>**************************************************************************************</strong><br />
<strong>* Carga No.:' . $shipment->getId() . '<br />
<strong>* De: </strong>' . $sourceCity->getName() . ' , ' . $sourceState->getName() . '<br />
<strong>* A: </strong>' . $destinyCity->getName() . ' , ' . $destinyState->getName() . '<br />
<strong>* Con Vehículo: </strong> ' . $vehicle->getName() . ' , ' . $vehicleType->getName() . '<br />
<strong>**************************************************************************************</strong><br /><br />
<table border="1" cellpadding="5" cellspacing="5">
<tr>
<td align="center"><strong>Ruta</strong></td>
<td align="center"><strong>Correo</strong></td>
<td align="center"><strong>Comentario</strong></td>
<td align="center"><strong>Fecha</strong></td>
</tr>
<tr>
<td> ' . $this->view->idRoutes . '</td>
<td> ' . $this->view->emailRoutes . '</td>
<td> ' . $this->view->comRoutes . '</td>
<td> ' . $this->view->dateRoutes . '</td>
</tr>
</table><br /><br />
<strong>' . $this->view->messageZone . '</strong><br />
<strong>' . $this->view->detailsZone . '</strong><br /><br />
<strong>Gracias por utilizar MasFletes.</strong><br />
<strong>www.masfletes.com</strong><br />
<strong>Nextel: 62 * 179099 *5 ó *2 ó al 01 - 444 - 2571546 con Arturo Macías</strong><br />
<strong>Oficina: 01 - 444 - 8240764 Con Cesar Castillo</strong><br />
<strong>Oficina: 01 - 444 - 8240647</strong><br />
<strong>Correo : masfletes@masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de MasFletes';
$mail->AddAddress($emailAgent, 'Coordinador');
foreach ($this->view->emailCordinator as $value) {
$mail->AddBCC($value['username'], "Coordinador De Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de MasFletes';
$mail->MsgHTML($correo);
$mail->Send();
}
}
////////////////////////////////////////////////////////////////////
// //
// Esta sección envía correos a: Usuario que registro la carga //
// cuando si encuentra una ruta que coincide con la carga //
// ingresada //
// //
////////////////////////////////////////////////////////////////////
//Esta sección no esta disponible para el coordinador
if ($countRoute != 0) {
list($typeText, $eventText) = $shipment->getTypeText();
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px">
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de ' . $typeText . ' de MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:13px;line-height:16px;">
<strong>Gracias por publicar tu ' . $typeText . ', existen ' . $countRoute . ' ' . $eventText . ' que se adaptan a tus necesidades.</strong><br /><br />
<strong>' . $this->view->messageZone . '</strong><br />
<strong>Por favor comunicate con nosotros mediante los datos que aparecen acontinuación para verificar si aún continua vigente.</strong><br /><br />
<strong>Gracias por utilizar MasFletes.</strong><br />
<strong>www.masfletes.com</strong><br />
<strong>Nextel: 62 * 179099 *5 ó *2 ó al 01 - 444 - 2571546 con Arturo Macías</strong><br />
<strong>Oficina: 01 - 444 - 8240764 Con Cesar Castillo</strong><br />
<strong>Oficina: 01 - 444 - 8240647</strong><br />
<strong>Correo : masfletes@masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de MasFletes';
$mail->AddAddress($emailCustomer, 'Usuario Mas Fletes');
if ($emailAdd != "") {
$mail->AddCC('' . $emailAdd . '', "Usuario Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de MasFletes';
$mail->MsgHTML($correo);
$mail->Send();
}
if (is_null($this->view->dataRequest)) {
Model3_Site::setTempMsg("msg", "La carga ha sido registrada correctamente");
} else {
Model3_Site::setTempMsg("msg", "Cambios guardados correctamente");
}
$this->redirect("Customer/" . $this->getRequest()->getController() . "/form");
}
}
public function formAction()
{
$this->view->dataRequest = NULL;
$this->view->getJsManager()->addJs('helper/state.js');
$this->view->getJsManager()->addJsVar('urlGetCities', '"' . $this->view->url(array('module' => 'Ajax', 'controller' => 'States', 'action' => 'getCities')) . '"');
if (!is_null($this->getRequest()->getParam('id')) && is_numeric($this->getRequest()->getParam('id'))) {
$idReq = $this->getRequest()->getParam('id');
$em = $this->getEntityManager('DefaultDb');
$this->view->dataRequest = $em->getRepository('DefaultDb_Entity_Notification')->find($idReq);
}
if ($this->getRequest()->isPost()) {
$em = $this->getEntityManager('DefaultDb');
$post = $this->getRequest()->getPost();
if (is_null($this->view->dataRequest)) {
$notification = new DefaultDb_Entity_Notification();
} else {
$notification = $this->view->dataRequest;
}
$notification->setNotificationDate(new DateTime());
$notification->setActionType($post['actionType']);
$sourceState = $em->getRepository('DefaultDb_Entity_State')->find($post['sourceState']);
$notification->setStateOrigin($sourceState);
$sourceCity = $em->getRepository('DefaultDb_Entity_City')->find($post['sourceStateCity']);
$notification->setMunicipalityOrigin($sourceCity);
$destinyState = $em->getRepository('DefaultDb_Entity_State')->find($post['destinyState']);
$notification->setStateDestiny($destinyState);
$destinyCity = $em->getRepository('DefaultDb_Entity_City')->find($post['destinyStateCity']);
$notification->setMunicipalityDestiny($destinyCity);
$vehicle = $em->getRepository('DefaultDb_Entity_Vehicle')->find($post['vehicle']);
$notification->setVehicle($vehicle);
$vehicleType = $em->getRepository('DefaultDb_Entity_VehicleType')->find($post['vehicleType']);
$notification->setVehicleType($vehicleType);
$user = $em->getRepository('DefaultDb_Entity_User')->find($this->_credentials['id']);
$notification->setUser($user);
$em->persist($notification);
$em->flush();
///////////////////////////////////////////////////////////////////
// Bsqueda que coincida con la notificacion para enviar correo //
// ActionType: 1(Shipment), 2(Routes) //
////////////////////////////////////////////////////////////////////
$action = $notification->getActionType();
$date = $notification->getNotificationDate()->format('y-m-d');
$emailUser = $em->getRepository('DefaultDb_Entity_User');
$this->view->email = $emailUser->getEmailUser($this->_credentials['id']);
foreach ($this->view->email as $value) {
$emailCustomer = $value['username'];
}
$this->view->emailCordinator = $emailUser->getEmailCordinator();
////////////////////////////////////////
// //
// ::: CONFIGURATIONS ::: //
// //
/////////////////////////////////////////
$resultConfiguration = $em->getRepository('DefaultDb_Entity_ConfigurationEmail');
$this->view->resultConfiguration = $resultConfiguration->getDetailsConfigurations($this->_credentials['id']);
while ($rowConfigurations = $this->view->resultConfiguration->fetch(PDO::FETCH_ASSOC)) {
$notificationsConfig = $rowConfigurations['send_notifications'];
$emailAdd = $rowConfigurations['email'];
}
$emnot = $this->getEntityManager('DefaultDb');
$event_panel = new DefaultDb_Entity_EventPanel();
if ($action == 1) {
$shipments = $em->getRepository('DefaultDb_Entity_Shipment');
$shipment = new DefaultDb_Entity_Shipment();
list($typeText, $eventText) = $shipment->getTypeText();
$this->view->shipments = $shipments->getNotificationForShipments($vehicle->getId(), $destinyState->getId(), $destinyCity->getId(), $date);
$countShipments = count($this->view->shipments);
if ($countShipments != 0) {
foreach ($this->view->shipments as $key) {
$this->view->idShipments .= $key['Shipments_Id'] . '<br />';
$this->view->idShipment .= $key['Shipments_Id'] . ',';
$this->view->destinyShipments .= $key['City_Destiny_Name'] . ' , ' . $key['State_D_Abbrev'] . '<br />';
$this->view->originShipments .= $key['City_Origin_Name'] . ' , ' . $key['State_O_Abbrev'] . '<br />';
$this->view->vehicleShipments .= $key['Vehicle_Name'] . ' De ' . $key['Vehicle_Type_Name'] . '<br />';
$this->view->Date .= $key['New_Availability_Date'] . '<br />';
$this->view->Comments .= $key['Comment'] . '<br />';
}
$event_panel->setEvent('notifications');
$event_panel->setIdEvent($notification->getId());
$event_panel->setCreationDate($notification->getNotificationDate());
$event_panel->setIdUser($this->_credentials['id']);
$event_panel->setStatus('0');
$event_panel->setDataHidden('0');
$event_panel->setCoincidenceEvent('1');
$event_panel->setCoincidenceNumber($this->view->idShipment);
$emnot->persist($event_panel);
$emnot->flush();
if ($notificationsConfig == 0) {
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px">
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de ' . $typeText . ' de MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:12px;line-height:16px;">
<strong>Tenemos ' . $countShipments . ' ' . $typeText . ' de tu interés que están disponibles.</strong><br /><br />
<table border="1" cellpadding="3" cellspacing="3" style="font-size:12px;">
<tr>
<td align="center"><strong>' . $typeText . ' No.</strong></td>
<td align="center"><strong>Origen</strong></td>
<td align="center"><strong>Destino</strong></td>
<td align="center"><strong>Vehículo</strong></td>
<td align="center"><strong>Disponible Hasta</strong></td>
<td align="center"><strong>Comentarios</strong></td>
</tr>
<tr>
<td align="center"> ' . $this->view->idShipments . '</td>
<td> ' . $this->view->originShipments . '</td>
<td> ' . $this->view->destinyShipments . '</td>
<td> ' . $this->view->vehicleShipments . '</td>
<td> ' . $this->view->Date . '</td>
<td> ' . $this->view->Comments . '</td>
</tr>
</table><br />
<strong>Otros clientes interesados en estas ' . $typeText . ' también han sido notificados.</strong><br /><br />
<strong>Si deseas ser notificado de otras rutas por favor, contáctanos.</strong><br /><br />
<strong>De interesarte alguna de ellas contacta a tu coordinador o comunícate a los siguientes teléfonos:</strong><br />
<strong>Nextel: 62 * 179099 *5 ó *2 ó al 01 - 444 - 2571546 con Arturo Macías</strong><br />
<strong>Oficina: 01 - 444 - 8240764 Con Cesar Castillo</strong><br />
<strong>Oficina: 01 - 444 - 8240647 </strong><br />
<strong>Correo : masfletes@masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de Mas Fletes';
$mail->AddBCC($emailCustomer, 'Usuario Mas Fletes');
if ($emailAdd != "") {
$mail->AddBCC('' . $emailAdd . '', "Usuario Mas Fletes");
}
foreach ($this->view->emailCordinator as $value) {
$mail->AddBCC($value['username'], "Coordinador De Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de Mas Fletes';
$mail->MsgHTML($correo);
$mail->Send();
}
}
}
if ($action == 2) {
$routes = $em->getRepository('DefaultDb_Entity_Route');
$route = new DefaultDb_Entity_Route();
$this->view->routes = $routes->getNotificationForRoutes($vehicle->getId(), $destinyState->getId(), $destinyCity->getId(), $date);
$countRoutes = count($this->view->routes);
list($typeText, $eventText) = $route->getTypeText();
if ($countRoutes != 0) {
foreach ($this->view->routes as $key) {
$this->view->idRoutes .= $key['Route_Id'] . '<br />';
$this->view->idRoute .= $key['Route_Id'] . ',';
$this->view->destinyRoutes .= $key['City_Destiny_Name'] . ' , ' . $key['State_D_Abbrev'] . '<br />';
$this->view->originRoutes .= $key['City_Origin_Name'] . ' , ' . $key['State_O_Abbrev'] . '<br />';
$this->view->vehicleRoutes .= $key['Vehicle_Name'] . ' De ' . $key['Vehicle_Type_Name'] . '<br />';
$this->view->Date .= $key['New_Availability_Date'] . '<br />';
$this->view->Comments .= $key['Comment'] . '<br />';
}
$event_panel->setEvent('notifications');
$event_panel->setIdUser($this->_credentials['id']);
$event_panel->setIdEvent($notification->getId());
$event_panel->setCreationDate($notification->getNotificationDate());
$event_panel->setStatus('0');
$event_panel->setDataHidden('0');
$event_panel->setCoincidenceEvent('2');
$event_panel->setCoincidenceNumber($this->view->idRoute);
$emnot->persist($event_panel);
$emnot->flush();
if ($notificationsConfig == 0) {
$correo = '<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#F5F5F5" leftmargin="18px" topmargin="10px" rightmargin="10px" bottommargin="10px">
<h3 style="color:#AF080F;text-align:left;">:::::: Notificación de unidades disponibles en MasFletes.com ::::::</h3>
<p style="font-family:Arial;font-size:12px;line-height:16px;">
<strong>Tenemos ' . $countRoutes . ' unidades de tu interés que están disponibles.</strong><br /><br />
<table border="1" cellpadding="3" cellspacing="3" style="font-size:12px;">
<tr>
<td align="center"><strong>' . $typeText . ' No.</strong></td>
<td align="center"><strong>Origen</strong></td>
<td align="center"><strong>Destino</strong></td>
<td align="center"><strong>Vehículo</strong></td>
<td align="center"><strong>Disponible</strong></td>
<td align="center"><strong>Comentarios</strong></td>
</tr>
<tr>
<td align="center"> ' . $this->view->idRoutes . '</td>
<td> ' . $this->view->originRoutes . '</td>
<td> ' . $this->view->destinyRoutes . '</td>
<td> ' . $this->view->vehicleRoutes . '</td>
<td> ' . $this->view->Date . '</td>
<td> ' . $this->view->Comments . '</td>
</tr>
</table><br />
<strong>Otros clientes interesados en estas rutas también han sido notificados.</strong><br /><br />
<strong>Si deseas ser notificado de otras rutas por favor, contáctanos.</strong><br /><br />
<strong>De interesarte alguna de ellas contacta a tu coordinador o comunícate a los siguientes teléfonos:</strong><br />
<strong>Nextel: 62 * 179099 *5 ó *2 ó al 01 - 444 - 2571546 con Arturo Macías</strong><br />
<strong>Oficina: 01 - 444 - 8240764 Con Cesar Castillo</strong><br />
<strong>Oficina: 01 - 444 - 8240647 </strong><br />
<strong>Correo : masfletes@masfletes.com</strong><br /><br />
</p></body></html>';
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = 'mail.masdistribucion.com.mx';
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = '******';
$mail->Password = '******';
$mail->From = '*****@*****.**';
$mail->FromName = 'Notificaciones de MasFletes.Com';
$mail->AddBCC($emailCustomer, 'Usuario Mas Fletes');
if ($emailAdd != "") {
$mail->AddBCC('' . $emailAdd . '', "Usuario Mas Fletes");
}
foreach ($this->view->emailCordinator as $value) {
$mail->AddBCC($value['username'], "Coordinador De Mas Fletes");
}
$mail->Subject = 'Notificaciones de ' . $typeText . ' de Mas Fletes';
$mail->MsgHTML($correo);
$mail->Send();
}
}
}
if (is_null($this->view->dataRequest)) {
Model3_Site::setTempMsg("msg", "La notificación ha sido registrada correctamente");
} else {
Model3_Site::setTempMsg("msg", "Cambios guardados correctamente");
}
$this->redirect("Customer/" . $this->getRequest()->getController() . "/form");
}
}