src/Command/SendMannedAlertsCommand.php line 202

Open in your IDE?
  1. <?php
  3. namespace App\Command;
  5. use Datetime;
  6. use Pimcore\Db;
  7. use GuzzleHttp\Client;
  8. use Pimcore\Log\Simple;
  9. use App\Service\RedisCache;
  10. use App\Model\LocationModel;
  11. use GuzzleHttp\Psr7\Request;
  12. use App\Service\EmailService;
  13. use Pimcore\Model\DataObject;
  14. use App\Model\EwsNotificationModel;
  15. use App\Service\NCMWeatherAPIService;
  16. use App\Service\MeteomaticsWeatherService;
  17. use Symfony\Component\Console\Command\Command;
  18. use Symfony\Component\Templating\EngineInterface;
  19. use Symfony\Component\Console\Input\InputArgument;
  20. use Symfony\Component\Console\Input\InputInterface;
  21. use Symfony\Component\Console\Output\OutputInterface;
  22. use App\C2IntegrationBundle\Service\C2Service;
  23. use App\Service\RichService;
  24. use Symfony\Contracts\HttpClient\HttpClientInterface;
  25. class SendMannedAlertsCommand extends Command
  26. {
  27.     protected static $defaultName = 'app:get-manned-alerts';
  28.     const HOURS = 24;
  29.     var $emailService = null;
  30.     private $templating;
  31.     private $nCMWeatherAPIService;
  32.     private $redisCache;
  33.     private $locationModel;
  34.     private $ewsNotificationModel;
  35.     private $c2Service;
  36.     private $richService;
  37.     private $httpClient;
  39.     public function __construct(EngineInterface $templating, RedisCache $redisCache, RichService $richService, HttpClientInterface $httpClient)
  40.     {
  41.         parent::__construct();
  43.         $this->templating = $templating;
  44.         $this->nCMWeatherAPIService = new NCMWeatherAPIService($redisCache,$httpClient);
  45.         $this->redisCache = $redisCache;
  46.         $this->locationModel = new LocationModel();
  47.         $this->ewsNotificationModel = new EwsNotificationModel();
  48.         $this->c2Service = new C2Service();
  49.         $this->richService = $richService;
  50.     }
  52.     protected function configure()
  53.     {
  54.         $this->setDescription('Retrieve manned alerts by location');
  55.     }
  57.     protected function execute(InputInterface $input, OutputInterface $output)
  58.     {   date_default_timezone_set(TIMEZONE);
  59.         $this->emailService = new EmailService();
  60.         $mateoMaticsService = new MeteomaticsWeatherService($this->redisCache);
  62.         $db = DB::get();
  63.         $localities = [];
  64.         $loopCount = 5;
  66.         $distincLocalities = $db->fetchAll("SELECT GROUP_CONCAT(DISTINCT addressValue) as localities FROM `object_collection_AddressComponents_location` WHERE `addressKey` = 'locality'");
  68.         if ($distincLocalities) {
  69.             $localities = explode(",", $distincLocalities[0]['localities']);
  70.         }
  72.         // Fetching alerts 
  73.         $alerts = $this->nCMWeatherAPIService->getAlerts();
  74.         if ($alerts) {
  76.             foreach ($alerts as $alert) {
  77.                 try {
  78.                     // Create update alert
  79.                     $mannedAlert = $this->createUpdateAlertNotification($alert, $output);
  81.                     if (!$mannedAlert) {
  82.                         $output->writeln('Nothing updated on notification = ' . $alert['id']);
  83.                         continue;
  84.                     }
  85.                     if ($_ENV['SEND_EMAIL_NOTIFICATION'] == "false") {
  86.                         $output->writeln('Email is not allowed on this environment');
  87.                         continue;
  88.                     }
  90.                     if (!$mannedAlert->getIsSent()) {
  92.                         $mannedAlertSubscription = new DataObject\MannedAlertSubscription\Listing();
  93.                         $mannedAlertSubscription->setOrderKey("o_creationDate");
  94.                         $mannedAlertSubscription->setOrder("desc");
  95.                         foreach ($mannedAlertSubscription as $subscription) {
  97.                             if ($subscription->getIsPublic() == false) {
  98.                                 # code...
  99.                                 // $subscriptionRegion = $subscription->getIsPublic() ?? false;
  100.                                 $subscriptionRegion =  false;
  101.                                 if ($subscription->getRegion()) {
  102.                                     if ($subscription->getRegion()->getRegionId() == $alert['regionID']) {
  103.                                         $subscriptionRegion = true;
  104.                                     }
  105.                                 }
  106.     
  107.                                 // $alertType = $subscription->getIsPublic() ?? false;
  108.                                 $alertType =  false;
  109.                                 if ($subscription->getAlertType()) {
  110.                                     foreach ($subscription->getAlertType() as $alertType) {
  111.                                         if ($alertType->getAlertTypeId() == $alert['alertType']) {
  112.                                             $alertType = true;
  113.                                             break;
  114.                                         }
  115.                                     }
  116.                                 }
  117.     
  118.                                 // $alertGovernorate = $subscription->getIsPublic() ?? false;
  119.                                 $alertGovernorate =  false;
  120.                                 $alertGovernoratesIds = array_column($alert['governorates'], 'id');
  121.                                 if ($subscription->getGovernorate()) {
  122.                                     foreach ($subscription->getGovernorate() as $governorate) {
  123.                                         if (in_array($governorate->getGovernoteId(), $alertGovernoratesIds)) {
  124.                                             $alertGovernorate = true;
  125.                                             break;
  126.                                         }
  127.                                     }
  128.                                 }
  129.     
  130.                                 // $phenomena = $subscription->getIsPublic() ?? false;
  131.                                 $phenomena = false;
  132.                                 $phenomenaIds = array_column($alert['alertHazards'], 'id');
  133.                                 if ($subscription->getPhenomena()) {
  134.                                     foreach ($subscription->getPhenomena() as $phenomenas) {
  135.                                         if (in_array($phenomenas->getPhenomenaListId(), $phenomenaIds)) {
  136.                                             $phenomena = true;
  137.                                             break;
  138.                                         }
  139.                                     }
  140.                                 }
  141.     
  142.     
  143.                                 if ($subscriptionRegion && $alertType && $alertGovernorate && $phenomena) {
  144.                                     // if (!empty($subscription->getEmail())) {
  145.                                     //     $user_name = explode('@', $subscription->getEmail());
  146.                                     //     $email = $this->sendEmailNotification($user_name[0], $alert, $subscription->getEmail(), $actualUser = false);
  147.     
  148.                                     //     // continue;
  149.                                     // }
  150.                                     if (!empty($subscription->getCreator())) {
  151.                                         $user = $subscription->getCreator();
  152.     
  153.                                         if ($user->getSevereWeatherAlert()) {
  154.                                             $email = $this->sendEmailNotification($user, $alert, null , true);
  155.                                         }
  156.                                     }
  157.                                 }
  158.                             }
  160.                         }
  162.                         // if (in_array($alert['regionEn'], $localities)) {
  164.                         //     // SELECT olqre.name as region,olqge.name as governate,olqwfc.name as municipality FROM object_region ore LEFT JOIN object_governorate ogo ON ore.oo_id = ogo.regionId__id LEFT JOIN object_weather_forecasting_city owfc ON owfc.MappedGovernorateId__id = ogo.oo_id LEFT JOIN object_localized_query_region_en olqre ON ore.oo_id = olqre.ooo_id LEFT JOIN object_localized_query_governorate_en olqge ON ogo.oo_id = olqge.ooo_id LEFT JOIN object_localized_query_weather_forecasting_city_en olqwfc ON owfc.oo_id = olqwfc.ooo_id
  165.                         //     // Fetching user fall in found localities
  166.                         //     $selectedLocalities = $this->ewsNotificationModel->getEwsNotificationByByRegionName($alert['regionEn']);
  167.                         //     if ($selectedLocalities) {
  169.                         //         $totalIterations = count($selectedLocalities);
  170.                         //         $iterations = 0;
  171.                         //         foreach ($selectedLocalities as $locality) {
  172.                         //             $locality = \Pimcore\Model\DataObject::getById($locality['o_id']);
  173.                         //             $users = $locality->getUser();
  175.                         //             // $email = $this->sendEmailNotification($users, $alert);
  177.                         //             // Increment the iteration count
  178.                         //             $iterations++;
  180.                         //             // Check if 5 iterations have passed
  181.                         //             if ($iterations % $loopCount === 0 && $iterations !== $totalIterations) {
  182.                         //                 // If 5 iterations have passed and it's not the last iteration, sleep for 65 seconds
  183.                         //                 sleep(65);
  184.                         //             }
  185.                         //         }
  186.                         //     }
  187.                         // }
  189.                     }
  191.                     $mannedAlert->setIsSent(true);
  192.                     $mannedAlert->save();
  193.                 } catch (\Exception $ex) {
  194.                     p_r($ex->getMessage());
  195.                 }
  196.             }
  197.         }
  199.         return 0;
  200.     }
  202.     private function sendEmailNotification($users, $alert, $email = null, $actualUser)
  203.     {
  204.         $mailSent = null;
  205.         if ($alert) {
  206.             $governatesArr = $alert['governorates'];
  207.             $governates = [];
  208.             if ($governatesArr) {
  209.                 foreach ($governatesArr as $gov) {
  210.                     $governates[] = $gov['nameEn'];
  211.                 }
  212.             }
  214.             $alertHazardsArr = $alert['alertHazards'];
  215.             $alertHazards = [];
  216.             $alertHazards_ar = [];
  217.             if ($alertHazardsArr) {
  218.                 foreach ($alertHazardsArr as $alertHazard) {
  219.                     $alertHazards[] = $alertHazard['descriptionEn'];
  220.                     $alertHazards_ar[] = ['nameAr' =>$alertHazard['descriptionAr']];
  221.                 }
  222.             }
  224.             $alertActionsArr = $alert['alertActions'];
  225.             $alertActions = [];
  226.             if ($alertActionsArr) {
  227.                 foreach ($alertActionsArr as $alertAction) {
  228.                     $alertActions[] = $alertAction['descriptionEn'];
  229.                 }
  230.             }
  233.             $data = $alert;
  234.             $data['sender'] = 'National Center for Meteorology';
  235.             // $subject =$alert['searchEwsIdAr'] ??'Severe Weather Alert - ' . $alert['regionEn'];
  236.             $subject = $alert['alertStatusAr'] . ' - ' . $alert['regionAR'];
  239.             //sending an email document (pimcore document)
  240.             $emailAlertTemplate = '/email/alert_notification';
  242.             if ($users) {
  243.                 $data['name'] = $email ? $users : $users->getName();
  245.                 // extra param js
  246.                 $alertObj = \Pimcore\Model\DataObject\AlertType::getByAlertTypeId($alert['alertType'], true);
  247.                 $alertName = $alertObj->getColor() ? $alertObj->getColor() : '';
  249.                 $alert['user_name'] = $email ? $users : $users->getName();
  250.                 $alert['host'] = API_BASE_URL;
  251.                 $alert['alertColor'] = $alertName;
  253.                 $backgroundColor = '#fcb82526';
  254.                 $borderColor = '#000000';
  255.                 $textColor = '#000000';
  257.                 if (isset($alert['alertColor']) && !empty(trim($alert['alertColor']))) {
  258.                     $alertColorLower = strtolower(trim($alert['alertColor']));
  260.                     if ($alertColorLower === 'red') {
  261.                         $backgroundColor = '#f6000017';
  262.                         $borderColor = '#F60000';
  263.                         $textColor = '#F60000';
  264.                     } elseif ($alertColorLower === 'orange') {
  265.                         $backgroundColor = '#ff66001f';
  266.                         $borderColor = '#FF6600';
  267.                         $textColor = '#FF6600';
  268.                     } elseif ($alertColorLower === 'yellow') {
  269.                         $backgroundColor = '#fcb82526';
  270.                         $borderColor = '#FCB825';
  271.                         $textColor = '#FCB825';
  272.                     }
  273.                 }
  275.                 $alert['backgroundColor'] = $backgroundColor;
  276.                 $alert['borderColor'] = $borderColor;
  277.                 $alert['textColor'] = $textColor;
  279.                 $currentDate = new \DateTime($alert['fromDate']);
  280.                 $searchIdAr= 'النظام Ø§Ù„الي Ù„لإنذار Ø§Ù„مبكر | '.$currentDate->format('dmY').'-'.$alert['id'].' | '.$alert['alertTypeAr'].' | '.$alert['alertStatusAr'];
  281.                 $alert['searchEwsIdAr'] = $searchIdAr;
  282.                 $alert['alertHazard'] = $alertHazards_ar;
  283.                 $alert['last_modified_date'] =  $alert['lastModified'];
  285.                
  286.                 $alert['tokenURL'] = null; // for now this is null but we have to develop unsubscribe functionality for this as well 
  287.                 if ($actualUser) {
  288.                     // general un subscribe function
  289.                     $token = \App\Lib\Utility::getUnSubscribeToken($users->getId());
  290.                     $alert['tokenURL'] = BASE_URL . '/unsubscribe/email?token=' . $token;
  291.                 }
  293.               
  294.               
  295.               
  296.                 
  297.                 $alert['mannedAlertDatailUrl'] = "https://ncm.gov.sa/Ar/alert/Pages/MapDetail.aspx?AlertId=".$alert['id'];
  298.                 $html = $this->templating->render('web2print/_manned_alert_notification_ar.html.twig', $alert);
  300.                 $mannedAlert = \Pimcore\Model\DataObject\MannedAlertNotification::getByAlertId($alert['id'], true);
  301.                 $purpose = MANNED_ALERT_MESSAGE;
  302.                 if ($email) {
  303.                     $mailSent = $this->c2Service->sendDefaultEmail($_ENV['EWS_MAIL_TEMPLATE'], $mannedAlert->getId(), $email, $html, $subject, $purpose);
  304.                 } else {
  305.                     $mailSent = $this->c2Service->sendNotificationEmail($_ENV['EWS_MAIL_TEMPLATE'], $mannedAlert->getId(), $users->getId(), $html, $subject, $purpose);
  306.                 }
  308.                 if ($users->getPhoneNo() && strlen($users->getPhoneNo()) == 9) {
  309.                     $messageSMS = sprintf(SMS_MESSAGE["MANNED_ALERT"], strtoupper($alertName) . " alert raised in " . $alert['regionAR'] . ' for ' . $alert['alertStatusAr'] . " event");
  310.                     $this->richService->sendSms(SAUDI_CALL_CODE.$users->getPhoneNo(), $messageSMS);
  311.                 }
  314.                 // $html = $this->templating->render('web2print/_manned_alert_notification_ar.html.twig', $alert);
  315.                 // $response['message_en'] = $html;
  317.                 // $email = $users->getEmail();
  318.                 // $param = ['user' => $users, 'message' => $html, 'url' => null];
  319.                 // $mailSent = $this->emailService->sendMail($param, $email, $emailAlertTemplate, $subject);
  320.             }
  322.             // if ($users) {
  323.             //     foreach ($users as $user) {
  324.             //         $data['name'] = $user->getName();
  325.             //         $html = $this->templating->render('web2print/_manned_alert_notification_ar.html.twig', $data);
  326.             //         $currentUser = $user->getObject();
  327.             //         $data = $user->getData();
  328.             //         if (isset($data['get_severe_alert']) && $data['get_severe_alert']) {
  329.             //             $email = $currentUser->getEmail();
  330.             //             $param = ['user' => $currentUser, 'message' => $html, 'url' => null];
  331.             //             $mailSent = $this->emailService->sendMail($param, $email, $emailAlertTemplate, $subject);
  332.             //         }
  333.             //     }
  334.             // }
  335.         }
  337.         return $mailSent;
  338.     }
  340.     private function createUpdateAlertNotification($alert, $output)
  341.     {
  342.         // Generate the hash for the current alert data
  343.         $alertHash = md5(json_encode($alert));
  345.         // Retrieve the existing MannedAlertNotification object by alert ID
  346.         $mannedAlert = \Pimcore\Model\DataObject\MannedAlertNotification::getByAlertId($alert['id'], true);
  348.         // Check if the alert already exists
  349.         if ($mannedAlert) {
  350.             // Compare the old hash with the new hash
  351.             if ($mannedAlert->getHash() === $alertHash) {
  352.                 // If the hashes match, the alert has not changed; ignore it
  353.                 return null;
  354.             }
  355.         } else {
  356.             // If the alert does not exist, create a new MannedAlertNotification object
  357.             $mannedAlert = new DataObject\MannedAlertNotification();
  358.             $mannedAlert->setKey($alert['id']);
  359.             $date = date('Y-m-d', strtotime($alert['fromDate']));
  360.             $mannedAlert->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/MannedAlert/Master/Notification/' . $date));
  361.             $mannedAlert->setPublished(TRUE);
  362.         }
  364.         // Update the MannedAlertNotification object with the new alert data
  365.         $mannedAlert->setAlertId($alert['id']);
  366.         $mannedAlert->setTitle($alert['title']);
  367.         $mannedAlert->setAlertType($this->getAlertType($alert['alertType'], $alert['alertTypeAr'], $alert['alertTypeEn']));
  369.         $fromDate = \Carbon\Carbon::createFromFormat('m/d/Y h:i:s A', $alert['fromDate']);
  370.         $toDate = \Carbon\Carbon::createFromFormat('m/d/Y h:i:s A', $alert['toDate']);
  371.         $lastModified = \Carbon\Carbon::createFromFormat('m/d/Y h:i:s A', $alert['lastModified']);
  373.         $mannedAlert->setFromDate($fromDate);
  374.         $mannedAlert->setToDate($toDate);
  375.         $mannedAlert->setLastModifiedDate($lastModified);
  376.         $mannedAlert->setAlertStatusCategory($this->getAlertStatusCategory($alert['alertStatusCategory']));
  377.         $mannedAlert->setAlertStatus($this->getAlertStatus($alert['alertStatusID'], $alert['alertStatusAr'], $alert['alertStatusEn']));
  379.         $alertHazardArr = [];
  380.         if ($alert['alertHazards']) {
  381.             foreach ($alert['alertHazards'] as $alertHazard) {
  382.                 $alertHazardArr[] = $this->getAlertHazard($alertHazard['id'], $alertHazard['descriptionAr'], $alertHazard['descriptionEn']);
  383.             }
  384.             $mannedAlert->setAlertHazards(array_filter($alertHazardArr));
  385.         }
  387.         $mannedAlert->setRegion($this->getRegion($alert['regionID'], $alert['regionAR'], $alert['regionEn']));
  389.         $alertGovernorateArr = [];
  390.         if ($alert['governorates']) {
  391.             foreach ($alert['governorates'] as $alertGovernorate) {
  392.                 $alertGovernorateArr[] = $this->getGovernorates($alertGovernorate['id'], $alertGovernorate['nameAr'], $alertGovernorate['nameEn'], $alertGovernorate['longitude'], $alertGovernorate['latitude']);
  393.             }
  394.             $mannedAlert->setGovernorates(array_filter($alertGovernorateArr));
  395.         }
  397.         $mannedAlert->setOtherLocation($alert['otherLocationsEn'], 'en');
  398.         $mannedAlert->setOtherLocation($alert['otherLocationsAr'], 'ar');
  399.         $mannedAlert->settweetID($alert['tweetID']);
  401.         $alertAlertActionArr = [];
  402.         if ($alert['alertActions']) {
  403.             foreach ($alert['alertActions'] as $alertAlertAction) {
  404.                 $alertAlertActionArr[] = $this->getAlertAction($alertAlertAction['id'], $alertAlertAction['descriptionAr'], $alertAlertAction['descriptionEn']);
  405.             }
  406.             $mannedAlert->setAlertAction(array_filter($alertAlertActionArr));
  407.         }
  409.         // Set the hash for the alert
  410.         $mannedAlert->setHash($alertHash);
  411.         $mannedAlert->setRawText(json_encode($alert));
  412.         $mannedAlert->setIsSent(false);
  414.         // Save the updated MannedAlertNotification object
  415.         $mannedAlert->save();
  417.         return $mannedAlert;
  418.     }
  420.     private function getAlertType($id, $nameAr, $nameEn)
  421.     {
  422.         $alertType = \Pimcore\Model\DataObject\AlertType::getByAlertTypeId($id, true);
  423.         if (!$alertType) {
  424.             $alertType = new \Pimcore\Model\DataObject\AlertType();
  425.             $alertType->setKey($id);
  426.             $alertType->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/MannedAlert/Master/AlertType'));
  427.             $alertType->setAlertTypeId($id);
  428.             $alertType->setName($nameAr, "en");
  429.             $alertType->setName($nameEn, "ar");
  430.             $alertType->setPublished(true);
  431.             $alertType->save();
  432.         }
  433.         return $alertType;
  434.     }
  436.     private function getAlertStatusCategory($name)
  437.     {
  438.         $alertStatusCategory = \Pimcore\Model\DataObject\AlertStatusCategory::getByName($name, true);
  439.         if (!$alertStatusCategory) {
  440.             $alertStatusCategory = new \Pimcore\Model\DataObject\AlertStatusCategory();
  441.             $alertStatusCategory->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/MannedAlert/Master/AlertStatusCategory'));
  442.             $alertStatusCategory->setKey($name);
  443.             $alertStatusCategory->setName($name);
  444.             $alertStatusCategory->setPublished(true);
  445.             $alertStatusCategory->save();
  446.         }
  447.         return $alertStatusCategory;
  448.     }
  450.     private function getAlertStatus($id, $nameAr, $nameEn)
  451.     {
  452.         $alertStatus = \Pimcore\Model\DataObject\AlertStatus::getByAlertStatusId($id, true);
  453.         if (!$alertStatus) {
  454.             $alertStatus = new \Pimcore\Model\DataObject\AlertStatus();
  455.             $alertStatus->setKey($id);
  456.             $alertStatus->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/MannedAlert/Master/AlertStatus'));
  457.             $alertStatus->setAlertStatusId($id);
  458.             $alertStatus->setName($nameAr, 'ar');
  459.             $alertStatus->setName($nameEn, 'en');
  460.             $alertStatus->setPublished(true);
  461.             $alertStatus->save();
  462.         }
  463.         return $alertStatus;
  464.     }
  466.     private function getAlertHazard($id, $descriptionAr, $descriptionEn)
  467.     {
  468.         $alertHazard = \Pimcore\Model\DataObject\AlertHazard::getByAlertHazardId($id, true);
  469.         if (!$alertHazard) {
  470.             $alertHazard = new \Pimcore\Model\DataObject\AlertHazard();
  471.             $alertHazard->setKey($id);
  472.             $alertHazard->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/MannedAlert/Master/AlertHazard'));
  473.             $alertHazard->setAlertHazardId($id);
  474.             $alertHazard->setName($descriptionAr, "ar");
  475.             $alertHazard->setName($descriptionEn, "en");
  476.             $alertHazard->setPublished(true);
  477.             $alertHazard->save();
  478.         } else {
  479.             $alertHazard->setName($descriptionAr, "ar");
  480.             $alertHazard->setName($descriptionEn, "en");
  481.             $alertHazard->save();
  482.         }
  485.         return $alertHazard;
  486.     }
  488.     private function getRegion($id, $nameAr, $nameEn)
  489.     {
  490.         $region = \Pimcore\Model\DataObject\Region::getByRegionId($id, true);
  491.         if (!$region) {
  492.             $region = new \Pimcore\Model\DataObject\Region();
  493.             $region->setKey($id);
  494.             $region->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/MannedAlert/Master/Region'));
  495.             $region->setRegionId($id);
  496.             $region->setName($nameAr, 'ar');
  497.             $region->setName($nameEn, 'en');
  498.             $region->setPublished(true);
  499.             $region->save();
  500.         }
  501.         return $region;
  502.     }
  504.     private function getGovernorates($id, $nameAr, $nameEn, $longitude, $latitude)
  505.     {
  506.         $governorate = \Pimcore\Model\DataObject\Governorate::getByGovernoteId($id, true);
  507.         if (!$governorate) {
  508.             $governorate = new \Pimcore\Model\DataObject\Governorate();
  509.             $governorate->setKey($id);
  510.             $governorate->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/MannedAlert/Master/Governorate'));
  511.             $governorate->setGovernoteId($id);
  512.             $governorate->setName($nameAr, "ar");
  513.             $governorate->setName($nameEn, "en");
  514.             $governorate->setLongitude($longitude);
  515.             $governorate->setLatitude($latitude);
  516.             $governorate->setPublished(true);
  517.             $governorate->save();
  518.         }
  519.         return $governorate;
  520.     }
  522.     private function getAlertAction($id, $descriptionAr, $descriptionEn)
  523.     {
  524.         $alertAction = \Pimcore\Model\DataObject\AlertAction::getByAlertActionId($id, true);
  525.         if (!$alertAction) {
  526.             $alertAction = new \Pimcore\Model\DataObject\AlertAction();
  527.             $alertAction->setKey($id);
  528.             $alertAction->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/MannedAlert/Master/AlertAction'));
  529.             $alertAction->setAlertActionId($id);
  530.             $alertAction->setName($descriptionAr, "ar");
  531.             $alertAction->setName($descriptionEn, "en");
  532.             $alertAction->setPublished(true);
  533.             $alertAction->save();
  534.         }
  535.         return $alertAction;
  536.     }
  537. }