src/Controller/AppraisalController.php line 1123

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Appraisal;
  6. use App\Entity\AppraisalForm;
  7. use App\Entity\AppraisalComment;
  8. use App\Entity\AppraisalNote;
  9. use App\Entity\AppraisalQuestionnaire;
  10. use App\Entity\AppraisalCategory;
  11. use App\Entity\User;
  12. use App\Entity\Office;
  13. use App\Entity\Department;
  14. use App\Form\AppraisalType;
  15. use App\Form\AppraisalNoteType;
  16. use App\Form\AppraisalRequestType;
  17. use App\Form\AppraisalSettingsType;
  18. use App\Form\AppraisalCategoryType;
  19. use App\Repository\AppraisalCategoryRepository;
  20. use App\Repository\AppraisalCommentRepository;
  21. use App\Repository\AppraisalFormRepository;
  22. use App\Repository\AppraisalNoteRepository;
  23. use App\Repository\AppraisalRepository;
  24. use App\Service\AppraisalService;
  25. use App\Service\GoogleDriveService;
  26. use App\Service\MailgunService;
  27. use App\Service\LogService;
  28. use App\Service\UserService;
  29. use App\Service\ObjectiveService;
  30. use App\Service\NotificationService;
  31. use App\Service\ICSService;
  32. use App\Service\LeaveService;
  33. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  34. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  35. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  36. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  37. use Symfony\Component\Routing\Annotation\Route;
  38. use Symfony\Component\HttpFoundation\Request;
  39. use Symfony\Component\HttpFoundation\JsonResponse;
  40. use Symfony\Component\HttpFoundation\RedirectResponse;
  41. use Symfony\Component\HttpFoundation\Response;
  42. use Symfony\Component\Serializer\SerializerInterface;
  43. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  44. use Symfony\Contracts\Translation\TranslatorInterface;
  45. use Symfony\Component\Security\Core\Security;
  47. class AppraisalController extends AbstractController
  48. {
  49.     #[Route(path: '/settings/appraisal', name: 'appraisal_settings')]
  50.     public function appraisalSettings(): \Symfony\Component\HttpFoundation\Response
  51.     {
  52.         $user = $this->getUser();
  54.         $company = $user->assignedCompany();
  55.         $formSettings = $this->createForm(AppraisalSettingsType::class);
  56.        
  58.         return $this->render('private/appraisal/edit-appraisal-v2.html.twig', [
  59.             'formSettings' => $formSettings->createView(),
  60.             'company' => $company
  61.             //'formAppraisal' => $formAppraisal->createView()
  62.         ]);
  63.     }
  65.     #[Route(path: '/ajax/appraisal-settings/update', name: 'ajax_update_appraisal_settings')]
  66.     public function ajaxUpdateAppraisalSettings(Request $request, LogService $log, AppraisalService $appraisalService): JsonResponse
  67.     {
  68.         $user = $this->getUser();
  69.         $result['status'] = 'OK';
  71.         $form = $this->createForm(AppraisalSettingsType::class);
  72.         $form->handleRequest($request);
  74.         if ($form->isSubmitted() && !$form->isValid()) {
  75.             $result['status'] = 'ERROR';
  76.             foreach ($form->getErrors(true) as $key => $error) {
  77.                 $result['message'][$key] = $error->getMessage();
  78.             }
  79.             return new JsonResponse($result);
  80.         }
  82.         if ($form->isSubmitted() && $form->isValid()) {
  83.             //$result['status']
  84.             $company = $user->assignedCompany();
  85.             $attributes = $company->getAttributes();
  86.             $oldData = $attributes;
  87.             $entityManager = $this->getDoctrine()->getManager();
  89.             $currentAttributes = $company->getAttributes();
  91.             $currentUserSubmitAt = isset($currentAttributes['appraisalUserSubmitAt']) ? new \DateTime($currentAttributes['appraisalUserSubmitAt']['date'].' '.$currentAttributes['appraisalUserSubmitAt']['timezone']) : null;
  92.             $currentManagerSubmitAt = isset($currentAttributes['appraisalManagerSubmitAt']) ? new \DateTime($currentAttributes['appraisalManagerSubmitAt']['date'].' '.$currentAttributes['appraisalManagerSubmitAt']['timezone']) : null;
  93.             
  95.             $attributes['appraisalStartAt'] = $form->get('appraisalStartAt')->getData();
  96.             $attributes['appraisalEndAt'] = $form->get('appraisalEndAt')->getData();
  97.             $attributes['appraisalUserSubmitAt'] = $form->get('appraisalUserSubmitAt')->getData();
  98.             $attributes['appraisalManagerSubmitAt'] = $form->get('appraisalManagerSubmitAt')->getData();
  99.             //$attributes['appraisalPulseCheck'] = $form->get('appraisalPulseCheck')->getData();
  101.             $company->setAttributes($attributes);
  103.             $startDate = isset($attributes['appraisalStartAt']) ? new \DateTime($attributes['appraisalStartAt']->format('Y-m-d')) : null;
  104.             $endDate = isset($attributes['appraisalEndAt']) ? new \DateTime($attributes['appraisalEndAt']->format('Y-m-d')) : null;
  106.             if($currentUserSubmitAt != $attributes['appraisalUserSubmitAt']) {
  107.                 $appraisals = $this->getDoctrine()->getRepository(Appraisal::class)->findBy(['probation' => false, 'adHoc' => false, 'submitAt' => $currentUserSubmitAt, 'submittedAt' => null]);
  108.                 foreach ($appraisals as $appraisal) {
  109.                     $appraisal->setSubmitAt($attributes['appraisalUserSubmitAt']);
  110.                 };
  111.             };
  114.             $employees =  $this->getDoctrine()->getRepository(User::class)->findAllEligibleForAppraisal($company, $startDate);
  115.             foreach ($employees as $employee) {
  116.                 $employee->getPersonalInfo()->setJobExpiryDate($form->get('appraisalEndAt')->getData());
  117.             };
  119.             $entityManager->flush();
  120.             $entityManager->refresh($company);
  121.             $appraisalService->syncAppraisalStatus();
  123.             $log->save($user, [
  124.                 'owner' => $user,
  125.                 'message' => 'log.appraisal.settings',
  126.                 'old_data' => $oldData,
  127.                 'new_data' => $attributes
  128.             ]);
  129.         };
  131.         return new JsonResponse($result);
  132.     }
  135.     #[Route(path: '/ajax/appraisal/crud', name: 'ajax_crud_appraisal')]
  136.     public function ajaxCRUDAppraisal(Request $request, TranslatorInterface $translator, AppraisalService $appraisalService, LogService $log, AppraisalFormRepository $appraisalFormRepository): JsonResponse
  137.     {
  138.         $id = $request->get("id");
  139.         $userId = $request->get("userId");
  140.         //$officeId = $request->get("officeId");
  141.         $crud = $request->get("crud");
  142.         $user = $this->getUser();
  143.         $result['status'] = 'OK';
  145.         if (!$id) {
  146.             $appraisal = new AppraisalForm();
  147.         } else {
  148.             $appraisal =  $this->getDoctrine()->getRepository(AppraisalForm::class)->find($id);
  149.             $oldData = clone $appraisal;
  150.         };
  152.         $form = $this->createForm(AppraisalType::class, $appraisal);
  153.         $form->handleRequest($request);
  155.         if ($form->isSubmitted() && !$form->isValid()) {
  156.             $result['status'] = 'ERROR';
  157.             foreach ($form->getErrors(true) as $key => $error) {
  158.                 $result['message'][$key] = $error->getMessage();
  159.             }
  160.             return new JsonResponse($result);
  161.         }
  163.         if ($form->isSubmitted() && $form->isValid()) {
  165.             $entityManager = $this->getDoctrine()->getManager();
  167.             if ($id === null) {
  168.                 $appraisal->setCompany($user->assignedCompany());
  169.                 $appraisal->setCreatedBy($user);
  170.                 $appraisal->setCreatedAt(new \DateTimeImmutable());
  171.                 $entityManager->persist($appraisal);
  172.             }
  174.             if ($id) {
  175.                 $appraisal->setUpdatedBy($user);
  176.                 $appraisal->setUpdatedAt(new \DateTimeImmutable());
  177.             }
  179.             $entityManager->flush();
  180.             $entityManager->refresh($appraisal);
  182.             $log->save($user, [
  183.                 'owner' => $user,
  184.                 'message' => $id === null ? 'log.appraisal.questionnaire.add' : 'log.appraisal.questionnaire.update',
  185.                 'old_data' => $id === null ? null : $oldData,
  186.                 'new_data' =>  $appraisal
  187.             ]);
  189.             $result['id'] = $appraisal->getId();
  190.             $result['content'] = $this->renderView('private/appraisal/components/appraisal-row.html.twig', [
  191.                 'appraisal' => $appraisal,
  192.                 'waitForPage' => false
  193.             ]);
  194.             $result['update'] = $id != null;
  195.             // if ($id != null && $appraisal->getIsHidden() != $oldData->getIsHidden()) $result['hide'] = true;
  197.             return  new JsonResponse($result);
  198.         }
  200.         if ($crud === 'delete' && $appraisal !== null) {
  201.             if ($result['status'] == 'OK') {
  202.                 $entityManager = $this->getDoctrine()->getManager();
  203.                 $entityManager->remove($appraisal);
  204.                 $entityManager->flush();
  206.                 $log->save($user, [
  207.                     'owner' => $user,
  208.                     'message' => 'log.appraisal.questionnaire.delete',
  209.                     'old_data' => $appraisal,
  210.                     'new_data' => null,
  211.                 ]);
  212.             }
  213.             return  new JsonResponse($result);
  214.         }
  216.         if ($crud === 'create' || $crud === 'update') {
  217.             $result['form'] = $this->renderView('private/appraisal/components/form-appraisal.html.twig', [
  218.                 'id' => $id,
  219.                 'form' => $form->createView(),
  220.             ]);
  221.             return  new JsonResponse($result);
  222.         };
  224.         $order = $request->get('order');
  225.         $orderBy = $request->get('orderBy');
  226.         $keyword = $request->get('keyword');
  227.         $type = $request->get('type');
  228.         $department = $request->get('department');
  229.         $page  = intval($request->query->get('page'));
  230.         $limit = intval($request->query->get('limit'));
  231.         if ($limit === 0) $limit = 20;
  233.         $company = $user->assignedCompany();
  235.         $appraisals = $appraisalFormRepository->findByPage($page, $limit, $order, $orderBy, $company, $keyword, $type, $department);
  236.         $totalCount =  $appraisalFormRepository->countByPage($company, $keyword, $type, $department);
  238.         $body = $this->renderView('private/appraisal/components/appraisal-list.html.twig', [
  239.             'appraisals' => $appraisals
  240.         ]);
  242.         $result['content'] = [
  243.             'html' => $body,
  244.             'total' => $totalCount
  245.         ];
  248.         return  new JsonResponse($result);
  249.     }
  251.     #[Route(path: '/ajax/list/appraisal', name: 'ajax_list_appraisal')]
  252.     public function ajaxListAppraisal(TranslatorInterface $translator, AppraisalService $appraisalService, LogService $log): JsonResponse
  253.     {
  254.     }
  256.     #[Route(path: '/ajax/appraisal-schedule/crud', name: 'ajax_crud_appraisal_schedule')]
  257.     public function ajaxCRUDAppraisalSchedule(Request $request, AppraisalService $appraisalService, ObjectiveService $objectiveService, LogService $log): JsonResponse
  258.     {
  259.         $user = $this->getUser();
  261.         if ($_SERVER['APP_ENV'] != "prod" && $user->getAppraisalStatus() == null && $user->getObjectiveStatus() == null) {
  262.             $appraisalService->syncAppraisalStatus();
  263.             $objectiveService->syncObjectiveStatus();
  264.             $result['sync'] = 'OK';
  265.         };
  267.         $isManager = !$this->isGranted('ROLE_HR') && $user->getIsManager();
  268.         $page  = intval($request->query->get('page'));
  269.         $limit = intval($request->query->get('limit'));
  270.         if ($limit === 0) $limit = 20;
  272.         $order = $request->get('order');
  273.         $orderBy = $request->get('orderBy');
  274.         $keyword = $request->get('keyword');
  275.         $manager = $isManager ? $user->getId() : $request->get('manager');
  276.         $subManager = $request->get('subManager');
  277.         $office = $request->get('office');
  278.         $employment = $request->get('employment');
  279.         $department = $request->get('department');
  280.         $appraisal = $request->get('appraisal');
  281.         $objective = $request->get('objective');
  282.         $waitForPage = $request->query->get('waitForPage');
  283.         $waitForPage === null ? $result['waitForPage'] = 'false' : $result['waitForPage'] = $waitForPage;
  284.         $result['status'] = 'OK';
  286.         // $appraisals = $this->getDoctrine()->getRepository(Appraisal::class)->findByPage($page, $limit, $order, $orderBy, $keyword);
  287.         // $totalCount =  $this->getDoctrine()->getRepository(Appraisal::class)->countByPage($keyword);
  288.         $company = $user->assignedCompany();
  289.         $users = $this->getDoctrine()->getRepository(User::class)->findByAppraisalPage($page, $limit, $order, $orderBy, $company, $keyword, $manager, $subManager, $office, $employment, $department, $appraisal, $objective);
  290.         $totalCount =  $this->getDoctrine()->getRepository(User::class)->countByAppraisalPage($company, $keyword, $manager, $subManager, $office,$employment, $department, $appraisal, $objective);
  292.         $body = $this->renderView('private/appraisal/components/appraisal-schedule-list.html.twig', [
  293.             // 'appraisals' => $appraisals
  294.             'users' => $users,
  295.             'testAccounts' => explode(',', str_replace(array("\r", "\n", " "), '',$_SERVER['TEST_ACCOUNTS']))
  296.         ]);
  298.         $result['content'] = [
  299.             'html' => $body,
  300.             'total' => $totalCount
  301.         ];
  303.         return new JsonResponse($result);
  304.     }
  306.     #[Route(path: '/ajax/appraisal-category/crud', name: 'ajax_crud_appraisal_category')]
  307.     public function ajaxCRUDAppraisalCategory(Request $request, LogService $log, AppraisalCategoryRepository $appraisalCategoryRepository): JsonResponse
  308.     {
  309.         $id = $request->get("id");
  310.         $userId = $request->get("userId");
  311.         //$officeId = $request->get("officeId");
  312.         $crud = $request->get("crud");
  313.         $user = $this->getUser();
  314.         $result['status'] = 'OK';
  316.         if (!$id) {
  317.             $category = new AppraisalCategory();
  318.         } else {
  319.             $category =  $this->getDoctrine()->getRepository(AppraisalCategory::class)->find($id);
  320.             $oldData = clone $category;
  321.         };
  323.         $form = $this->createForm(AppraisalCategoryType::class, $category);
  324.         $form->handleRequest($request);
  326.         if ($form->isSubmitted() && !$form->isValid()) {
  327.             $result['status'] = 'ERROR';
  328.             foreach ($form->getErrors(true) as $key => $error) {
  329.                 $result['message'][$key] = $error->getMessage();
  330.             }
  331.             return new JsonResponse($result);
  332.         }
  334.         if ($form->isSubmitted() && $form->isValid()) {
  336.             $entityManager = $this->getDoctrine()->getManager();
  338.             if ($id === null) {
  339.                 $category->setCompany($user->assignedCompany());
  341.                 $questionnaires = $form->get('questionnaire')->getData();
  342.                 foreach($questionnaires as $question){
  343.                     $question->setCompany($user->assignedCompany());
  344.                     $question->setType($category->getType());
  345.                     $question->setDepartment($category->getDepartment());
  346.                     $question->setCreatedAt(new \DateTime());
  347.                     $question->setCreatedBy($user);
  348.                 }
  350.                 $category->setCreatedBy($user);
  351.                 $category->setCreatedAt(new \DateTimeImmutable());
  352.                 $entityManager->persist($category);
  353.             }
  355.             if ($id) {
  357.                 $questionnaires = $form->get('questionnaire')->getData();
  358.                 foreach($questionnaires as $question){
  359.                     if(!$question->getCompany()) $question->setCompany($user->assignedCompany());
  360.                     if(!$question->getType()) $question->setType($category->getType());
  361.                     if(!$question->getDepartment()) $question->setDepartment($category->getDepartment());
  362.                     $question->setCreatedAt(new \DateTime());
  363.                     $question->setCreatedBy($user);
  364.                 }
  366.                 $category->setUpdatedBy($user);
  367.                 $category->setUpdatedAt(new \DateTimeImmutable());
  368.             }
  370.             $entityManager->flush();
  371.             $entityManager->refresh($category);
  373.             $log->save($user, [
  374.                 'owner' => $user,
  375.                 'message' => $id === null ? 'log.appraisal.category.add' : 'log.appraisal.category.update',
  376.                 'old_data' => $id === null ? null : $oldData,
  377.                 'new_data' =>  $category
  378.             ]);
  380.             $result['id'] = $category->getId();
  381.             $result['content'] = $this->renderView('private/appraisal/components/appraisal-category-row.html.twig', [
  382.                 'category' => $category,
  383.                 'waitForPage' => false
  384.             ]);
  385.             $result['update'] = $id != null;
  386.             // if ($id != null && $category->getIsHidden() != $oldData->getIsHidden()) $result['hide'] = true;
  388.             return  new JsonResponse($result);
  389.         }
  391.         if ($crud === 'delete' && $category !== null) {
  392.             if ($result['status'] == 'OK') {
  393.                 $entityManager = $this->getDoctrine()->getManager();
  394.                 $entityManager->remove($category);
  395.                 $entityManager->flush();
  397.                 $log->save($user, [
  398.                     'owner' => $user,
  399.                     'message' => 'log.appraisal.questionnaire.delete',
  400.                     'old_data' => $category,
  401.                     'new_data' => null,
  402.                 ]);
  403.             }
  404.             return  new JsonResponse($result);
  405.         }
  407.         if ($crud === 'create' || $crud === 'update') {
  408.             $result['form'] = $this->renderView('private/appraisal/components/form-appraisal-category.html.twig', [
  409.                 'id' => $id,
  410.                 'form' => $form->createView(),
  411.             ]);
  412.             return  new JsonResponse($result);
  413.         };
  415.         $order = $request->get('order');
  416.         $orderBy = $request->get('orderBy');
  417.         $keyword = $request->get('keyword');
  418.         $type = $request->get('type');
  419.         $department = $request->get('department');
  420.         $page  = intval($request->query->get('page'));
  421.         $limit = intval($request->query->get('limit'));
  422.         if ($limit === 0) $limit = 20;;
  424.         $company = $user->assignedCompany();
  426.         $categories = $appraisalCategoryRepository->findByPage($page, $limit, $order, $orderBy, $company, $keyword, $type, $department);
  427.         $totalCount =  $appraisalCategoryRepository->countByPage($company, $keyword, $type, $department);
  429.         $body = $this->renderView('private/appraisal/components/appraisal-category-list.html.twig', [
  430.             'categories' => $categories
  431.         ]);
  433.         $result['content'] = [
  434.             'html' => $body,
  435.             'total' => $totalCount
  436.         ];
  439.         return  new JsonResponse($result);
  440.     }
  442.     #[Route(path: '/ajax/appraisal-request', name: 'ajax_appraisal_request')]
  443.     public function ajaxAppraisalRequest(Request $request, TranslatorInterface $translator, AppraisalService $appraisalService, LogService $log): JsonResponse
  444.     {
  445.         $user = $this->getUser();
  446.         $appraisal = new Appraisal();
  447.         $form = $this->createForm(AppraisalRequestType::class, $appraisal);
  448.         $form->handleRequest($request);
  450.         $result['status'] = 'OK';
  452.         $editedUser =  $this->getDoctrine()->getRepository(User::class)->find($request->get("userId"));
  454.         if ($editedUser == null) {
  455.             $result['status'] = 'ERROR';
  456.             $result['message'] = $translator->trans('messages.request.missing') . ': UID';
  457.         }
  459.         if ($form->isSubmitted() && !$form->isValid() && $result['status'] == 'OK') {
  460.             $result['status'] = 'ERROR';
  461.             foreach ($form->getErrors(true) as $key => $error) {
  462.                 $result['message'][$key] = $error->getMessage();
  463.             }
  464.         };
  466.         if ($result['status'] == 'OK') {
  467.             $result['content'] =  $appraisalService->initiateAppraisal($request, $user, $editedUser, $form->get('title')->getData(), $form->get('submitAt')->getData(), $form->get('reviewAt')->getData(), $request->request->get('addonform-text'), $request->request->get('addonform-score'), $form->get('adHoc')->getData());
  469.             /*$log->save($user, [
  470.                 'owner' => $editedUser,
  471.                 'message' => 'log.appraisal.request',
  472.                 'old_data' => null,
  473.                 'new_data' => $appraisal
  474.             ]);*/
  476.             $result['ordering'] = [
  477.                 'key' => 'submit',
  478.                 'sort' => 'desc'
  479.             ];
  480.         };
  482.         return new JsonResponse($result);
  483.     }
  485.     #[Route(path: '/ajax/edit-appraisal-request', name: 'ajax_edit_appraisal_request', methods: 'POST')]
  486.     function ajaxEditAppraisalRequest(Request $request, AppraisalService $appraisalService, TranslatorInterface $translator): \Symfony\Component\HttpFoundation\Response
  487.     {
  488.         $user = $this->getUser();
  489.         $appraisal = $this->getDoctrine()->getRepository(Appraisal::class)->find($request->get("id"));
  490.         $formAppraisal = $this->createForm(AppraisalRequestType::class, $appraisal);
  491.         $addOnQuestions = $this->getDoctrine()->getRepository(AppraisalForm::class)->findByAppraisal($appraisal);
  492.         $defaultQuestions = $this->getDoctrine()->getRepository(AppraisalQuestionnaire::class)->findByUser($appraisal->getUser());
  494.         return $this->render('private/appraisal/components/form-edit-appraisal-request.html.twig', array(
  495.             'userData' => $user,
  496.             'editedUser' => $appraisal->getUser(),
  497.             'dataId' => $appraisal->getId(),
  498.             'formAppraisal' => $formAppraisal->createView(),
  499.             'addOnQuestions' => $addOnQuestions ? $addOnQuestions : null,
  500.             'defaultQuestions' => $defaultQuestions ? $defaultQuestions : null
  501.         ));
  502.     }
  504.     #[Route(path: '/ajax/update-appraisal-request', name: 'ajax_update_appraisal_request')]
  505.     public function ajaxUpdateRequestAppraisal(Request $request, TranslatorInterface $translator, AppraisalService $appraisalService, LogService $log, MailgunService $mailgunService, NotificationService $notification, ICSService $ics, SerializerInterface $serializer): JsonResponse
  506.     {
  507.         $user = $this->getUser();
  508.         $appraisal = $this->getDoctrine()->getRepository(Appraisal::class)->find($request->get("dataId"));
  509.         $oldData = clone $appraisal;
  510.         $result['status'] = 'OK';
  511.         $loggedIn = $request ? true : false;
  513.         if ($appraisal != null) {
  514.             /*
  515.             if ($user->isSubordinate($appraisal->getUser()->getId())) {
  516.                 $result['status'] = 'ERROR';
  517.                 $result['message'] = $translator->trans('messages.security.forbidden');
  518.             };
  519.             */
  521.             $form = $this->createForm(AppraisalRequestType::class, $appraisal);
  522.             $form->handleRequest($request);
  524.             if ($form->isSubmitted() && !$form->isValid() && $result['status'] == 'OK') {
  525.                 $result['status'] = 'ERROR';
  526.                 foreach ($form->getErrors(true) as $key => $error) {
  527.                     $result['message'][$key] = $error->getMessage();
  528.                 }
  529.             };
  531.             if ($result['status'] == 'OK') {
  532.                 $entityManager = $this->getDoctrine()->getManager();
  533.                 if ($appraisal->getReviewAt() != $oldData->getReviewAt()) {
  534.                     $appraisal->setReschedule($appraisal->getReschedule() + 1);
  535.                     if ($appraisal->getAdHoc()) $appraisal->setSubmitAt($appraisal->getReviewAt());
  536.                 };
  537.                 $entityManager->flush();
  538.                 $entityManager->refresh($appraisal);
  540.                 //$addOnQuestions = $this->getDoctrine()->getRepository(AppraisalForm::class)->findByAppraisal($appraisal);
  541.                 $addOnFormTexts = $request->request->get('addonform-text');
  542.                 if ($addOnFormTexts != null) {
  543.                     $addOnFormId = $request->request->get('addonform-id');
  544.                     $addOnFormDelete = $request->request->get('addonform-delete');
  545.                     $addOnFormScores = $request->request->get('addonform-score');
  546.                     $n = 1;
  547.                     foreach ($addOnFormTexts as $addOnFormText) {
  548.                         if ($addOnFormId[$n]) {
  549.                             $appraisalForm = $this->getDoctrine()->getRepository(AppraisalForm::class)->findById($addOnFormId[$n]);
  550.                             if ($addOnFormDelete[$n] == 'true') {
  551.                                 $entityManager->remove($appraisalForm);
  552.                                 $entityManager->flush();
  553.                                 $n++;
  554.                                 continue;
  555.                             }
  556.                         } else {
  557.                             $appraisalForm = new AppraisalForm();
  558.                             if ($addOnFormText == null) {
  559.                                 $n++;
  560.                                 continue;
  561.                             }
  562.                         }
  564.                         $appraisalForm->setDescription($addOnFormText);
  565.                         if ($addOnFormScores[$n] == 'true') {
  566.                             $appraisalForm->setUseScore(true);
  567.                         } else {
  568.                             $appraisalForm->setUseScore(false);
  569.                         };
  570.                         $appraisalForm->setCreatedBy($user);
  571.                         $appraisalForm->setCreatedAt(new \DateTime());
  572.                         $appraisalForm->setCompany($user->assignedCompany());
  574.                         if ($addOnFormId[$n] == null) {
  575.                             $entityManager->persist($appraisalForm);
  576.                             $appraisalForm->setAppraisal($appraisal);
  577.                             $appraisal->setSubmittedAt(null);
  578.                         };
  579.                         $entityManager->flush();
  581.                         $n++;
  582.                     };
  583.                 }
  585.                 $attendee = [
  586.                     [
  587.                         'name' => $user->getPersonalInfo()->getFullName(),
  588.                         'email' => $user->getEmail(),
  589.                         'role' => $appraisal->getUser()->getManager() == $user ? 'REQ-PARTICIPANT' : 'OPT-PARTICIPANT'
  590.                     ],
  591.                     [
  592.                         'name' => $appraisal->getUser()->getPersonalInfo()->getFullName(),
  593.                         'email' => $appraisal->getUser()->getEmail(),
  594.                         'role' => 'REQ-PARTICIPANT'
  595.                     ],
  596.                 ];
  597.                 foreach ($appraisal->getUser()->getAllManager() as $manager) {
  598.                     if ($manager != $user) {
  599.                         array_push($attendee,   [
  600.                             'name' => $manager->getPersonalInfo()->getFullName(),
  601.                             'email' => $manager->getEmail(),
  602.                             'role' => $appraisal->getUser()->getManager() == $manager ? 'REQ-PARTICIPANT' : 'OPT-PARTICIPANT'
  603.                         ]);
  604.                     }
  605.                 }
  606.                 // if ($_SERVER['NOTIF_SUPER_ADMIN'] == 'true') {
  607.                 //     foreach ($user->assignedCompany()->superAdmins($user) as $superAdmin) {
  608.                 //         if ($superAdmin != $user) {
  609.                 //             array_push($attendee,   [
  610.                 //                 'name' => $superAdmin->getPersonalInfo()->getFullName(),
  611.                 //                 'email' => $superAdmin->getEmail(),
  612.                 //                 'role' => 'OPT-PARTICIPANT'
  613.                 //             ]);
  614.                 //         }
  615.                 //     }
  616.                 // };
  618.                 if ($appraisal->getReviewAt() != $oldData->getReviewAt() && in_array($appraisal->currentStep(), [3, 4])) {
  619.                     $hrSetSchedule = $oldData->getReviewAt() == null && $appraisal->currentStep() == 3 && $appraisal->getUser()->inProbation() == false ? true : false;
  620.                     if ($hrSetSchedule) {
  621.                         $emailTemplate = 'email/user-notification/appraisal/hr-invitation-default.html.twig';
  622.                         $titleTemplate = 'email.appraisal.invitation.default.';
  623.                     } else {
  624.                         if ($appraisal->getProbation()) {
  625.                             if($oldData->getReschedule() == 0 && $oldData->getReviewAt() == null){
  626.                                 $emailTemplate = 'email/user-notification/appraisal/invitation-probation.html.twig';
  627.                                 $titleTemplate = 'email.appraisal.invitation.probation.';
  628.                             } else {
  629.                                 $emailTemplate = 'email/user-notification/appraisal/reschedule-probation.html.twig';
  630.                                 $titleTemplate = 'email.appraisal.rescheduled.probation.';
  631.                             }
  632.                         } elseif ($oldData->getReschedule() == 0) {
  633.                             $emailTemplate =  'email/user-notification/appraisal/hr-invitation-default.html.twig';
  634.                             $titleTemplate = 'email.appraisal.invitation.default.';
  635.                         } else {
  636.                             $emailTemplate =  'email/user-notification/appraisal/reschedule-default.html.twig';
  637.                             $titleTemplate = 'email.appraisal.rescheduled.default.';
  638.                         };
  639.                     }
  641.                     $endTime = new \DateTime($appraisal->getReviewAt()->format('Ymd H:i:s'));
  642.                     $endTime->modify('+ 30 minutes');
  644.                     $ICSTitle = $appraisal->getUser()->inProbation() ? 'Review (Probation)' : 'Review';
  646.                     $icsData =  $ics->generateEventFile([
  647.                         'uid' => $appraisal->getId() . $appraisal->getUser()->getId() . ':' . $appraisal->getUser()->getEmail(),
  648.                         'title' => $ICSTitle . ': ' . $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  649.                         'description' => $translator->trans('ics.appraisal.description', ['%uid%' => $appraisal->getUser()->getId(), '%user%' => strtolower($appraisal->getUser()->getPersonalInfo()->getFirstName()), '%link%' => $this->generateUrl('user_profile', array(), UrlGeneratorInterface::ABSOLUTE_URL) . '/' . $appraisal->getUser()->getEmail() . '?g=appraisal&open=appraisal-' . $appraisal->getId()]),
  650.                         'startDateTime' => $appraisal->getReviewAt()->format('Ymd') . 'T' . $appraisal->getReviewAt()->format('His'),
  651.                         'endDateTime' =>  $appraisal->getReviewAt()->format('Ymd') . 'T' . $endTime->format('His'),
  652.                         'location' =>  $this->generateUrl('submit_appraisal', array(), UrlGeneratorInterface::ABSOLUTE_URL) . '/' . $appraisal->getId(),
  653.                         'organizer' => [
  654.                             'name' => $this->getParameter('systemEmailName'),
  655.                             'email' => $_SERVER['APP_ENV'] == 'prod' ? $this->getParameter('systemEmailAddr') : 'devops@mediatropy.com'
  656.                         ],
  657.                         'attendee' => $attendee,
  658.                         'reschedule' => $appraisal->getReschedule(),
  659.                         'reminderTime' => '-15M',
  660.                         'reminderDescription' => $translator->trans('ics.appraisal.title') . ' ' . $appraisal->getTitle(),
  661.                         'fileName' => 'Appraisal-' . $appraisal->getIcsToken()
  662.                     ], true);
  664.                     $mailgunService->sendEmailWithAttachment([
  665.                         'subject' =>  $translator->trans($titleTemplate . 'user', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(), '%date%' => $appraisal->getReviewAt()->format('l, d M Y')]),
  666.                         'to' => $appraisal->getUser()->getEmail(),
  667.                         'template' => $emailTemplate,
  668.                         'params' => [
  669.                             'recipient' => $appraisal->getUser(),
  670.                             'appraisal' => $appraisal,
  671.                             'group' => 'user'
  672.                         ],
  673.                         'ical' => $icsData
  674.                     ], $loggedIn);
  676.                     // $notification->push($appraisal->getUser(), [
  677.                     //     'message' => 'notification.appraisal.rescheduled_alt.user',
  678.                     //     'entity' => 'Appraisal',
  679.                     //     'objectId' => $appraisal->getId(),
  680.                     //     'data' => $serializer->serialize([
  681.                     //         'title' => $appraisal->getTitle(),
  682.                     //         'name' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  683.                     //         'url' => $this->generateUrl('submit_appraisal') . '/' . $appraisal->getId(),
  684.                     //         'time' => $appraisal->getReviewAt()->format('Ymd His'),
  685.                     //     ], 'json')
  686.                     // ], true);
  688.                     foreach ($appraisal->getUser()->getAllManager() as $manager) {
  689.                         // $notification->push($manager, [
  690.                         //     'message' => 'notification.appraisal.rescheduled_alt.manager',
  691.                         //     'entity' => 'Appraisal',
  692.                         //     'objectId' => $appraisal->getId(),
  693.                         //     'data' => $serializer->serialize([
  694.                         //         'title' => $appraisal->getTitle(),
  695.                         //         'name' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  696.                         //         'url' => $this->generateUrl('submit_appraisal') . '/' . $appraisal->getId(),
  697.                         //         'time' => $appraisal->getReviewAt()->format('Ymd His'),
  698.                         //     ], 'json')
  699.                         // ], true);
  700.                         $mailgunService->sendEmailWithAttachment([
  701.                             'subject' => $translator->trans($titleTemplate . 'manager', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFullName(), '%date%' => $appraisal->getReviewAt()->format('l, d M Y')]),
  702.                             'to' => $manager->getEmail(),
  703.                             'template' => $emailTemplate,
  704.                             'params' => [
  705.                                 'recipient' => $manager,
  706.                                 'appraisal' => $appraisal,
  707.                                 'group' => 'manager'
  708.                             ],
  709.                             'ical' => $icsData
  710.                         ], $loggedIn);
  711.                     }
  713.                     $emailGroup = $this->getParameter('systemEmailGroup');
  715.                     foreach ($emailGroup as $groupName => $groupEmail) {
  716.                         if ($groupName == 'hr') { // only HR
  717.                             $mailgunService->sendEmailWithAttachment([
  718.                                 'subject' => $translator->trans($titleTemplate . 'hr', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFullName(), '%date%' => $appraisal->getReviewAt()->format('l, d M Y')]),
  719.                                 'to' => $groupEmail,
  720.                                 'template' => $emailTemplate,
  721.                                 'params' => [
  722.                                     'recipient' => strtoupper($groupName) . ' Team',
  723.                                     'appraisal' => $appraisal,
  724.                                     'group' => $groupName
  725.                                 ],
  726.                                 'ical' => $icsData
  727.                             ], $loggedIn);
  728.                         };
  729.                     };
  731.                     /*if ($_SERVER['NOTIF_SUPER_ADMIN'] == 'true') {
  732.                         foreach ($user->assignedCompany()->superAdmins($user) as $superAdmin) {
  733.                             if ($superAdmin != $user && !in_array($superAdmin, $appraisal->getUser()->getAllManager())) {
  734.                                 $notification->push($superAdmin, [
  735.                                     'message' => 'notification.appraisal.rescheduled_alt.manager',
  736.                                     'entity' => 'Appraisal',
  737.                                     'objectId' => $appraisal->getId(),
  738.                                     'data' => $serializer->serialize([
  739.                                         'title' => $appraisal->getTitle(),
  740.                                         'name' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  741.                                         'url' => $this->generateUrl('submit_appraisal') . '/' . $appraisal->getId(),
  742.                                         'time' => $appraisal->getSubmitAt()->format('Ymd His'),
  743.                                     ], 'json')
  744.                                 ], true);
  745.                                 $mailgunService->sendEmailWithAttachment([
  746.                                     //'subject' => $translator->trans('email.appraisal.created_cc_updated') . ' ' . $appraisal->getSubmitAt()->format('d F Y').' at '.$appraisal->getSubmitAt()->format('H:i'),
  747.                                     'subject' => $translator->trans('email.system.copy_super_admin') . ' ' . $subject,
  748.                                     'to' => $superAdmin->getEmail(),
  749.                                     'template' => 'email/user-notification/appraisal/request-cc.html.twig',
  750.                                     'params' => [
  751.                                         'sender' => $user,
  752.                                         'recipient' => $superAdmin,
  753.                                         'appraisal' => $appraisal,
  754.                                         'reschedule' => true
  755.                                     ],
  756.                                     //'attachments' => $this->generateUrl('download_ics_appraisal', array('token' => $appraisal->getIcsToken()))
  757.                                     'ical' => $icsData
  758.                                 ]);
  759.                             };
  760.                         }
  761.                     }*/
  762.                 } elseif ($appraisal->getSubmitAt() != $oldData->getSubmitAt() and $appraisal->currentStep() <= 1) {
  763.                     //TODO Add email or notification when user submit date changed?
  764.                 };
  765.                 /*
  766.                 if ($appraisal->getReviewAt() != $oldData->getReviewAt()) {
  767.                     $mailgunService->rescheduleEmail(new \DateTime($appraisal->getReviewAt()->format('Ymd H:i:s')), 'Appraisal', $appraisal->getId());
  768.                 };*/
  770.                 $log->save($user, [
  771.                     'owner' => $appraisal->getUser(),
  772.                     'message' => 'log.appraisal.request_update',
  773.                     'old_data' => $oldData,
  774.                     'new_data' => $appraisal
  775.                 ]);
  777.                 /*switch ($appraisal->currentStep($user)) {
  778.                     case 1:
  779.                         $action = $translator->trans('form.appraisal.pending.user');
  780.                         $attr = 'disabled="disabled"';
  781.                         break;
  782.                     case 2:
  783.                         $action = $translator->trans('form.appraisal.pending.manager');
  784.                         $attr = '';
  785.                         break;
  786.                     case 3:
  787.                         $action = $translator->trans('form.appraisal.pending.review');
  788.                         $attr = '';
  789.                         break;
  790.                     case 4:
  791.                         $action = $translator->trans('form.appraisal.ready');
  792.                         $attr = '';
  793.                         break;
  794.                     default:
  795.                         $action = $translator->trans('form.appraisal.done');
  796.                         $attr = '';
  797.                         break;
  798.                 }
  799.                 if ($appraisal->currentStep($user) == 1) {
  800.                     if ($appraisal->getSubmitAt()->format('Ymd') <= date('Ymd')) {
  801.                         $appraisalClass = 'b-danger';
  802.                     } else {
  803.                         $appraisalClass = 'b-warning';
  804.                     };
  805.                 } else {
  806.                     $appraisalClass = '';
  807.                 };*/
  808.                 $result['id'] = $appraisal->getId();
  809.                 if ($user != $appraisal->getUser()) {
  810.                     $result['content'] = $this->renderView('private/user/components/tab-appraisal-list-manager.html.twig', [
  811.                         'appraisal' => $appraisal
  812.                     ]);
  813.                 } else {
  814.                     $result['content'] = $this->renderView('private/user/components/tab-appraisal-list-user.html.twig', [
  815.                         'appraisal' => $appraisal
  816.                     ]);
  817.                 }
  818.                 $result['update'] = true;
  819.                 $result['ordering'] = [
  820.                     'key' => 'submit',
  821.                     'sort' => 'desc'
  822.                 ];
  823.             }
  824.             $appraisalService->syncAppraisalStatus($appraisal->getUser());
  825.         } else {
  826.             $result['status'] = 'ERROR';
  827.             $result['message'] = $translator->trans('messages.request.missing');
  828.         }
  829.         return new JsonResponse($result);
  830.     }
  832.     #[Route(path: '/ajax/edit-appraisal-questionnaire', name: 'ajax_edit_appraisal_questionnaire', methods: 'POST')]
  833.     function ajaxEditAppraisalQuestionnaire(Request $request, TranslatorInterface $translator)
  834.     {
  835.         $user = $this->getUser();
  836.         $editedUser = $this->getDoctrine()->getRepository(User::class)->find($request->get("id"));
  838.         if ($editedUser == null) return false;
  840.         $questionnaires = $this->getDoctrine()->getRepository(AppraisalQuestionnaire::class)->findByUser($editedUser);
  842.         return $this->render('private/appraisal/components/form-appraisal-questionnaire.html.twig', array(
  843.             'userData' => $user,
  844.             'editedUser' => $editedUser,
  845.             'questionnaires' => $questionnaires ? $questionnaires : null
  846.         ));
  847.     }
  849.     #[Route(path: '/ajax/update-appraisal-questionnaire', name: 'ajax_update_appraisal_questionnaire')]
  850.     public function ajaxUpdateAppraisalQuestionnaire(Request $request, TranslatorInterface $translator, AppraisalService $appraisalService, SerializerInterface $serializer): JsonResponse
  851.     {
  852.         $user = $this->getUser();
  853.         $editedUser = $this->getDoctrine()->getRepository(User::class)->find($request->get("userId"));
  854.         $result['status'] = 'OK';
  856.         if ($editedUser == null) { // TODO: Make other error response like this
  857.             $result['status'] = 'ERROR';
  858.             $result['message'] = $translator->trans('messages.request.missing');
  859.             return new JsonResponse($result);
  860.         };
  862.         $result['content'] = $appraisalService->setDefaultQuestionnaire($request, $user, $editedUser);
  864.         return new JsonResponse($result);
  865.     }
  867.     #[Route(path: '/ajax/appraisal/addon-questionnaire/crud', name: 'ajax_crud_appraisal_addon_questionnaire')]
  868.     public function ajaxCRUDAppraisalAddonQuestionnaire(Request $request, TranslatorInterface $translator, AppraisalService $appraisalService, LogService $log): JsonResponse
  869.     {
  870.         $crud = $request->get("crud");
  871.         $user = $this->getUser();
  872.         $editedUser = $this->getDoctrine()->getRepository(User::class)->find($request->get("userId"));
  873.         $result['status'] = 'OK';
  875.         $entityManager = $this->getDoctrine()->getManager();
  877.         if ($editedUser == null) return false;
  879.         $questionnaires = $this->getDoctrine()->getRepository(AppraisalQuestionnaire::class)->findByUser($editedUser);
  881.         if ($crud == 'update') {
  882.             $result['form'] = $this->renderView('private/appraisal/components/form-appraisal-questionnaire.html.twig', [
  883.                 'editedUser' => $editedUser,
  884.                 'questionnaires' => $questionnaires ? $questionnaires : null,
  885.                 'waitForPage' => false
  886.             ]);
  887.         } else {
  888.             $result['total'] = $appraisalService->setDefaultQuestionnaire($request, $user, $editedUser);
  889.             $result['update'] = true;
  890.             $result['id'] = $request->get("userId");
  891.         }
  893.         return  new JsonResponse($result);
  894.     }
  896.     #[Route(path: '/ajax/remind-appraisal', name: 'ajax_remind_appraisal')]
  897.     public function ajaxRemindAppraisal(Request $request, TranslatorInterface $translator, LogService $log, MailgunService $mailgunService, NotificationService $notification, ICSService $ics, SerializerInterface $serializer): JsonResponse
  898.     {
  899.         $user = $this->getUser();
  900.         $appraisal = $this->getDoctrine()->getRepository(Appraisal::class)->find($request->get("id"));
  901.         $result['status'] = 'OK';
  903.         if ($appraisal != null) {
  904.             $attendee = [
  905.                 [
  906.                     'name' => $user->getPersonalInfo()->getFullName(),
  907.                     'email' => $user->getEmail(),
  908.                     'role' => $appraisal->getUser()->getManager() == $user ? 'REQ-PARTICIPANT' : 'OPT-PARTICIPANT'
  909.                 ],
  910.                 [
  911.                     'name' => $appraisal->getUser()->getPersonalInfo()->getFullName(),
  912.                     'email' => $appraisal->getUser()->getEmail(),
  913.                     'role' => 'REQ-PARTICIPANT'
  914.                 ],
  915.             ];
  917.             foreach ($appraisal->getUser()->getAllManager() as $manager) {
  918.                 if ($manager != $user) {
  919.                     array_push($attendee,   [
  920.                         'name' => $manager->getPersonalInfo()->getFullName(),
  921.                         'email' => $manager->getEmail(),
  922.                         'role' => $appraisal->getUser()->getManager() == $manager ? 'REQ-PARTICIPANT' : 'OPT-PARTICIPANT'
  923.                     ]);
  924.                 }
  925.             }
  926.             // if ($_SERVER['NOTIF_SUPER_ADMIN'] == 'true') {
  927.             //     foreach ($user->assignedCompany()->superAdmins($user) as $superAdmin) {
  928.             //         if ($superAdmin != $user) {
  929.             //             array_push($attendee,   [
  930.             //                 'name' => $superAdmin->getPersonalInfo()->getFullName(),
  931.             //                 'email' => $superAdmin->getEmail(),
  932.             //                 'role' => 'OPT-PARTICIPANT'
  933.             //             ]);
  934.             //         }
  935.             //     }
  936.             // };
  937.             $scheduleDate = $appraisal->getReviewAt() != null ? $appraisal->getReviewAt() : $appraisal->getSubmitAt();
  938.             $subject = $appraisal->getTitle() . ' | ' . $appraisal->getUser()->getPersonalInfo()->getFirstName() . ' | ' . $scheduleDate->format('d F Y');
  939.             $endTime = new \DateTime($scheduleDate->format('Ymd H:i:s'));
  940.             $endTime->modify('+ 1 hour');
  942.             $ICSTitle = $appraisal->getUser()->inProbation() ? 'Review (Probation)' : 'Review';
  944.             $icsData =  $ics->generateEventFile([
  945.                 'uid' => $appraisal->getId() . $appraisal->getUser()->getId() . ':' . $appraisal->getUser()->getEmail(),
  946.                 'title' => $ICSTitle . ': ' . $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  947.                 'description' => $translator->trans('ics.appraisal.description', ['%uid%' => $appraisal->getUser()->getId(), '%user%' => strtolower($appraisal->getUser()->getPersonalInfo()->getFirstName()), '%link%' => $this->generateUrl('user_profile', array(), UrlGeneratorInterface::ABSOLUTE_URL) . '/' . $appraisal->getUser()->getEmail() . '?g=appraisal&open=appraisal-' . $appraisal->getId()]),
  948.                 'startDateTime' => $scheduleDate->format('Ymd') . 'T' . $scheduleDate->format('His'),
  949.                 'endDateTime' =>  $scheduleDate->format('Ymd') . 'T' . $endTime->format('His'),
  950.                 'location' =>  $this->generateUrl('submit_appraisal', array(), UrlGeneratorInterface::ABSOLUTE_URL) . '/' . $appraisal->getId(),
  951.                 'organizer' => [
  952.                     'name' => $this->getParameter('systemEmailName'),
  953.                     'email' => $request->getHost() == 'hr.mediatropy.com' ? $this->getParameter('systemEmailAddr') : 'devops@mediatropy.com'
  954.                 ],
  955.                 'attendee' => $attendee,
  956.                 'reminderTime' => '-15M',
  957.                 'reminderDescription' => $translator->trans('ics.appraisal.title') . ' ' . $appraisal->getTitle(),
  958.                 'fileName' => 'Appraisal-' . $appraisal->getIcsToken()
  959.             ], true);
  960.             /*
  961.             $mailgunService->sendEmail(
  962.                 $translator->trans('email.appraisal.scheduled') . ' ' . $appraisal->getSubmitAt()->format('d F Y'),
  963.                 [$appraisal->getUser()->getEmail()],
  964.                 'email/user-notification/appraisal/request.html.twig',
  965.                 [
  966.                     'user' => $appraisal->getUser(),
  967.                     'appraisal' => $appraisal,
  968.                 ]
  969.             );*/
  971.             $mailgunService->sendEmailWithAttachment([
  972.                 'subject' => $subject,
  973.                 'to' => $appraisal->getUser()->getEmail(),
  974.                 'template' => 'email/user-notification/appraisal/request.html.twig',
  975.                 'params' => [
  976.                     'recipient' => $appraisal->getUser(),
  977.                     'sender' => $user,
  978.                     'appraisal' => $appraisal,
  979.                     'reschedule' => false
  980.                 ],
  981.                 'ical' => $icsData
  982.             ]);
  984.             foreach ($appraisal->getUser()->getAllManager() as $manager) {
  985.                 $mailgunService->sendEmailWithAttachment([
  986.                     'subject' => $subject,
  987.                     'to' => $manager->getEmail(),
  988.                     'template' => 'email/user-notification/appraisal/request-cc.html.twig',
  989.                     'params' => [
  990.                         'sender' => $user,
  991.                         'recipient' => $manager,
  992.                         'appraisal' => $appraisal,
  993.                         'reschedule' => false
  994.                     ],
  995.                     'ical' => $icsData
  996.                 ]);
  997.             }
  998.             /*
  999.             if ($_SERVER['NOTIF_SUPER_ADMIN'] == 'true') {
  1000.                 foreach ($user->assignedCompany()->superAdmins($user) as $superAdmin) {
  1001.                     if ($superAdmin != $user && !in_array($superAdmin, $appraisal->getUser()->getAllManager())) {
  1002.                         $mailgunService->sendEmailWithAttachment([
  1003.                             'subject' => $translator->trans('email.system.copy_super_admin').' '.$subject,
  1004.                             'to' => $superAdmin->getEmail(),
  1005.                             'template' => 'email/user-notification/appraisal/request-cc.html.twig',
  1006.                             'params' => [
  1007.                                 'recipient' => $appraisal->getUser(),
  1008.                                 'sender' => $user,
  1009.                                 'cc' => $superAdmin,
  1010.                                 'appraisal' => $appraisal,
  1011.                                 'reschedule' => false
  1012.                             ],
  1013.                             'ical' => $icsData
  1014.                         ]);
  1015.                     };
  1016.                 }
  1017.             };*/
  1019.             $log->save($user, [
  1020.                 'owner' => $appraisal->getUser(),
  1021.                 'message' => 'log.appraisal.reminder',
  1022.                 'old_data' => null,
  1023.                 'new_data' => null
  1024.             ]);
  1025.             /*
  1026.             if ($appraisal->currentStep($user) == 1) {
  1027.                 if ($appraisal->getSubmitAt()->format('Ymd') <= date('Ymd')) {
  1028.                     $appraisalClass = 'b-danger';
  1029.                 } else {
  1030.                     $appraisalClass = 'b-warning';
  1031.                 };
  1032.             } else {
  1033.                 $appraisalClass = '';
  1034.             };*/
  1035.             $result['content'] = $this->renderView('private/user/components/tab-appraisal-list-manager.html.twig', [
  1036.                 'appraisal' => $appraisal
  1037.             ]);
  1038.         } else {
  1039.             $result['status'] = 'ERROR';
  1040.             $result['message'] = $translator->trans('messages.request.missing');
  1041.         }
  1042.         return new JsonResponse($result);
  1043.     }
  1045.     #[Route(path: '/ajax/close-appraisal', name: 'ajax_close_appraisal')]
  1046.     public function ajaxCloseAppraisal(Request $request, TranslatorInterface $translator, LogService $log, MailgunService $mailgunService, NotificationService $notification, ICSService $ics, SerializerInterface $serializer): JsonResponse
  1047.     {
  1048.         $user = $this->getUser();
  1049.         $appraisal = $this->getDoctrine()->getRepository(Appraisal::class)->find($request->get("id"));
  1050.         $result['status'] = 'OK';
  1052.         if ($appraisal != null) {
  1053.             $entityManager = $this->getDoctrine()->getManager();
  1055.             // $appraisal->setReviewAt(new \DateTime());
  1056.             // $appraisal->setReviewedBy($user);
  1057.             // $appraisal->setReviewedAt(new \DateTime());
  1058.             $appraisal->setConcludedAt(new \DateTime());
  1060.             $entityManager->flush();
  1061.             $entityManager->refresh($appraisal);
  1063.             $log->save($user, [
  1064.                 'owner' => $appraisal->getUser(),
  1065.                 'message' => 'log.appraisal.close',
  1066.                 'old_data' => null,
  1067.                 'new_data' => $appraisal
  1068.             ]);
  1070.             // $notification->push($appraisal->getUser(), [
  1071.             //     'message' => 'notification.appraisal.reviewed_alt',
  1072.             //     'entity' => 'Appraisal',
  1073.             //     'objectId' => $appraisal->getId(),
  1074.             //     'data' => $serializer->serialize([
  1075.             //         'title' => $appraisal->getTitle(),
  1076.             //         'url' => $this->generateUrl('submit_appraisal') . '/' . $appraisal->getId(),
  1077.             //         'time' => $appraisal->getReviewAt()->format('Ymd His'),
  1078.             //     ], 'json')
  1079.             // ], true);
  1080.             $subject = $appraisal->getTitle() . ' | ' . $appraisal->getUser()->getPersonalInfo()->getFirstName() . ' | ' . $translator->trans('email.appraisal.result');
  1081.             $mailgunService->sendEmail(
  1082.                 $subject,
  1083.                 [$appraisal->getUser()->getEmail()],
  1084.                 'email/user-notification/appraisal-result.html.twig',
  1085.                 [
  1086.                     'recipient' => $appraisal->getUser(),
  1087.                     'appraisal' => $appraisal,
  1088.                 ]
  1089.             );
  1090.         } else {
  1091.             $result['status'] = 'ERROR';
  1092.             $result['message'] = $translator->trans('messages.request.missing');
  1093.         }
  1094.         return new JsonResponse($result);
  1095.     }
  1097.     #[Route(path: '/ajax/delete-appraisal-request', name: 'ajax_delete_appraisal_request', methods: 'POST')]
  1098.     function ajaxDeleteAppraisalRequest(Request $request, TranslatorInterface $translator, MailgunService $mailgunService, ICSService $ics, NotificationService $notification, LogService $log, SerializerInterface $serializer): JsonResponse
  1099.     {
  1100.         $user = $this->getUser();
  1101.         $appraisal =  $this->getDoctrine()->getRepository(Appraisal::class)->find($request->get("id"));
  1102.         //$oldData = clone $appraisal;
  1103.         $result['status'] = 'OK';
  1105.         if ($appraisal != null) {
  1106.             $response = $this->forward('App\Controller\AppraisalController::deleteAppraisalRequest', [
  1107.                 'request' => $request,
  1108.                 'user' => $user,
  1109.                 'appraisal' => $appraisal,
  1110.                 'logged' => true
  1111.             ]);
  1112.             //dump(json_decode($response->getContent(),true));
  1113.             $result['status'] = json_decode($response->getContent(), true);
  1114.         } else {
  1115.             $result['status'] = 'ERROR';
  1116.             $result['message'] = $translator->trans('messages.request.missing');
  1117.         }
  1119.         return new JsonResponse($result);
  1120.     }
  1122.     #[Route(path: '/function/delete-appraisal-request', name: 'function_delete_appraisal_request', methods: 'POST')]
  1123.     function deleteAppraisalRequest($request, $user, $appraisal, $logged = true, TranslatorInterface $translator, MailgunService $mailgunService, AppraisalService $appraisalService, ICSService $ics, NotificationService $notification, LogService $log, SerializerInterface $serializer): JsonResponse
  1124.     {
  1125.         $oldData = clone $appraisal;
  1126.         $loggedIn = $request ? true : false;
  1127.         if ($logged) {
  1128.             $log->save($user, [
  1129.                 'owner' => $appraisal->getUser(),
  1130.                 'message' => 'log.appraisal.request_delete',
  1131.                 'old_data' => $oldData,
  1132.                 'new_data' => null
  1133.             ]);
  1134.         };
  1136.         if (($appraisal->getAdHoc() || $appraisal->currentStep() > 2) && $appraisal->getReviewAt() != null && date('YmdHis') < $appraisal->getReviewAt()->format('YmdHis')) { // Only send notification if review set       
  1137.             $attendee = [
  1138.                 [
  1139.                     'name' => $user->getPersonalInfo()->getFullName(),
  1140.                     'email' => $user->getEmail(),
  1141.                     'role' => $appraisal->getUser()->getManager() == $user ? 'REQ-PARTICIPANT' : 'OPT-PARTICIPANT'
  1142.                 ],
  1143.                 [
  1144.                     'name' => $appraisal->getUser()->getPersonalInfo()->getFullName(),
  1145.                     'email' => $appraisal->getUser()->getEmail(),
  1146.                     'role' => 'REQ-PARTICIPANT'
  1147.                 ],
  1148.             ];
  1149.             foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1150.                 try {
  1151.                     if ($manager != $user) {
  1152.                         array_push($attendee,   [
  1153.                             'name' => $manager->getPersonalInfo()->getFullName(),
  1154.                             'email' => $manager->getEmail(),
  1155.                             'role' => $appraisal->getUser()->getManager() == $manager ? 'REQ-PARTICIPANT' : 'OPT-PARTICIPANT'
  1156.                         ]);
  1157.                     }
  1158.                 } catch (Exception $e) {
  1159.                     continue;
  1160.                 }
  1161.             }
  1162.             /*if ($_SERVER['NOTIF_SUPER_ADMIN'] == 'true') {
  1163.                 foreach ($user->assignedCompany()->superAdmins($user) as $superAdmin) {
  1164.                     if ($superAdmin != $user) {
  1165.                         array_push($attendee,   [
  1166.                             'name' => $superAdmin->getPersonalInfo()->getFullName(),
  1167.                             'email' => $superAdmin->getEmail(),
  1168.                             'role' => 'OPT-PARTICIPANT'
  1169.                         ]);
  1170.                     }
  1171.                 }
  1172.             };*/
  1174.             $subject =  $appraisal->getTitle() . ' | ' . $appraisal->getUser()->getPersonalInfo()->getFirstName() . ' | ' . $translator->trans('email.appraisal.cancel');
  1175.             $endTime = new \DateTime($appraisal->getReviewAt()->format('Ymd H:i:s'));
  1176.             $endTime->modify('+ 1 hour');
  1178.             $ICSTitle = $appraisal->getUser()->inProbation() ? 'Review (Probation)' : 'Review';
  1180.             if ($appraisal->getAdHoc()) $ICSTitle = 'Ad hoc Review';
  1182.             if ($appraisal->getAdHoc() || $appraisal->currentStep() > 2) {
  1183.                 $icsData =  $ics->generateEventFile([
  1184.                     'uid' => $appraisal->getId() . $appraisal->getUser()->getId() . ':' . $appraisal->getUser()->getEmail(),
  1185.                     'title' => $ICSTitle . ': ' . $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  1186.                     'description' => null,
  1187.                     'startDateTime' => $appraisal->getReviewAt()->format('Ymd') . 'T' . $appraisal->getReviewAt()->format('His'),
  1188.                     'endDateTime' =>  $appraisal->getReviewAt()->format('Ymd') . 'T' . $endTime->format('His'),
  1189.                     'location' =>  $this->generateUrl('submit_appraisal', array(), UrlGeneratorInterface::ABSOLUTE_URL) . '/' . $appraisal->getId(),
  1190.                     'organizer' => [
  1191.                         'name' => $this->getParameter('systemEmailName'),
  1192.                         'email' => $request->getHost() == 'hr.mediatropy.com' ? $this->getParameter('systemEmailAddr') : 'devops@mediatropy.com'
  1193.                     ],
  1194.                     'attendee' => $attendee,
  1195.                     'reschedule' => $appraisal->getReschedule(),
  1196.                     'reminderTime' => '-15M',
  1197.                     'reminderDescription' => $translator->trans('ics.appraisal.title') . ' ' . $appraisal->getTitle(),
  1198.                     'fileName' => 'Appraisal-' . $appraisal->getIcsToken()
  1199.                 ], true, 'CANCEL');
  1200.             } else {
  1201.                 $icsData = null;
  1202.             };
  1204.             /*$notification->disable($appraisal->getUser(), [
  1205.                 'entity' => 'appraisal',
  1206.                 'objectId' => $appraisal->getId(),
  1207.             ]);*/
  1208.             if ($logged) {
  1209.                 // $notification->push($appraisal->getUser(), [
  1210.                 //     'message' => 'notification.appraisal.canceled.user',
  1211.                 //     'entity' => 'Appraisal',
  1212.                 //     'objectId' => $appraisal->getId(),
  1213.                 //     'data' => $serializer->serialize([
  1214.                 //         'title' => $appraisal->getTitle(),
  1215.                 //         'name' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  1216.                 //         'url' => $this->generateUrl('submit_appraisal') . '/' . $appraisal->getId(),
  1217.                 //         'time' => $appraisal->getReviewAt()->format('Ymd His'),
  1218.                 //     ], 'json')
  1219.                 // ], true);
  1220.             };
  1222.             $mailgunService->sendEmailWithAttachment([
  1223.                 'subject' => $subject,
  1224.                 'to' => $appraisal->getUser()->getEmail(),
  1225.                 'template' => 'email/user-notification/appraisal/cancel.html.twig',
  1226.                 'params' => [
  1227.                     'recipient' => $appraisal->getUser(),
  1228.                     'appraisal' => $appraisal,
  1229.                     'group' => 'user'
  1230.                 ],
  1231.                 'ical' => $icsData
  1232.             ], $loggedIn);
  1234.             foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1235.                 try {
  1236.                     /*$notification->clear($manager, [
  1237.                     'entity' => 'appraisal',
  1238.                     'objectId' => $appraisal->getId(),
  1239.                 ]);*/
  1240.                     // $notification->push($manager, [
  1241.                     //     'message' => 'notification.appraisal.canceled.manager',
  1242.                     //     'entity' => 'Appraisal',
  1243.                     //     'objectId' => $appraisal->getId(),
  1244.                     //     'data' => $serializer->serialize([
  1245.                     //         'title' => $appraisal->getTitle(),
  1246.                     //         'name' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  1247.                     //         'url' => $this->generateUrl('submit_appraisal') . '/' . $appraisal->getId(),
  1248.                     //         'time' => $appraisal->getReviewAt()->format('Ymd His'),
  1249.                     //     ], 'json')
  1250.                     // ], true);
  1251.                     $mailgunService->sendEmailWithAttachment([
  1252.                         'subject' => $subject,
  1253.                         'to' => $manager->getEmail(),
  1254.                         'template' => 'email/user-notification/appraisal/cancel-cc.html.twig',
  1255.                         'params' => [
  1256.                             'recipient' => $manager,
  1257.                             'appraisal' => $appraisal,
  1258.                             'group' => 'manager'
  1259.                         ],
  1260.                         'ical' => $icsData
  1261.                     ], $loggedIn);
  1262.                 } catch (Exception $e) {
  1263.                     continue;
  1264.                 }
  1265.             }
  1267.             $emailGroup = $this->getParameter('systemEmailGroup');
  1268.             foreach ($emailGroup as $groupName => $groupEmail) {
  1269.                 if ($appraisal->getUser()->inProbation() == false && $groupName == 'finance') continue;
  1270.                 try {
  1271.                     $mailgunService->sendEmailWithAttachment([
  1272.                         'subject' => $subject,
  1273.                         'to' => $groupEmail,
  1274.                         'template' => 'email/user-notification/appraisal/cancel-cc.html.twig',
  1275.                         'params' => [
  1276.                             'recipient' => strtoupper($groupName) . ' Team',
  1277.                             'appraisal' => $appraisal,
  1278.                             'group' => $groupName
  1279.                         ],
  1280.                         'ical' => $icsData
  1281.                     ], $loggedIn);
  1282.                 } catch (Exception $e) {
  1283.                     continue;
  1284.                 }
  1285.             };
  1287.             /*if ($_SERVER['NOTIF_SUPER_ADMIN'] == 'true') {
  1288.                 foreach ($user->assignedCompany()->superAdmins($user) as $superAdmin) {
  1289.                     if ($superAdmin != $user && !in_array($superAdmin, $appraisal->getUser()->getAllManager())) {
  1290.                         // $notification->push($superAdmin, [
  1291.                         //             'message' => 'notification.appraisal.canceled.manager',
  1292.                         //             'entity' => 'Appraisal',
  1293.                         //             'objectId' => $appraisal->getId(),
  1294.                         //             'data' => $serializer->serialize([
  1295.                         //                 'title' => $appraisal->getTitle(),
  1296.                         //                 'name' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  1297.                         //                 'url' => $this->generateUrl('submit_appraisal') . '/' . $appraisal->getId(),
  1298.                         //             ], 'json')
  1299.                         //         ], true);
  1300.                         $mailgunService->sendEmailWithAttachment([
  1301.                             'subject' => $translator->trans('email.system.copy_super_admin') . ' ' . $subject,
  1302.                             'to' => $superAdmin->getEmail(),
  1303.                             'template' => 'email/user-notification/appraisal/cancel-cc.html.twig',
  1304.                             'params' => [
  1305.                                 'sender' => $user,
  1306.                                 'recipient' => $superAdmin,
  1307.                                 'appraisal' => $appraisal,
  1308.                             ],
  1309.                             'ical' => $icsData
  1310.                         ]);
  1311.                     };
  1312.                 }
  1313.             };*/
  1314.         } else if (in_array($appraisal->currentStep(), [1, 2])) {
  1315.             $subject =  $appraisal->getTitle() . ' | ' . $appraisal->getUser()->getPersonalInfo()->getFirstName() . ' | ' . $translator->trans('email.appraisal.cancel');
  1316.             $emailTemplate = 'email/user-notification/appraisal/cancel.html.twig';
  1318.             $mailgunService->sendEmail(
  1319.                 $subject,
  1320.                 [$appraisal->getUser()->getEmail()],
  1321.                 $emailTemplate,
  1322.                 [
  1323.                     'recipient' => $appraisal->getUser(),
  1324.                     'appraisal' => $appraisal,
  1325.                     'group' => 'user'
  1326.                 ]
  1327.             );
  1329.             $emailTemplate = 'email/user-notification/appraisal/cancel-cc.html.twig';
  1331.             foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1332.                 $mailgunService->sendEmail(
  1333.                     $subject,
  1334.                     [$manager->getEmail()],
  1335.                     $emailTemplate,
  1336.                     [
  1337.                         'recipient' => $manager,
  1338.                         'appraisal' => $appraisal,
  1339.                         'group' => 'manager'
  1340.                     ]
  1341.                 );
  1342.             };
  1344.             $emailGroup = $this->getParameter('systemEmailGroup');
  1345.             foreach ($emailGroup as $groupName => $groupEmail) {
  1346.                 if ($appraisal->getUser()->inProbation() == false && $groupName == 'finance') continue;
  1347.                 try {
  1348.                     $mailgunService->sendEmail(
  1349.                         $subject,
  1350.                         [$groupEmail],
  1351.                         $emailTemplate,
  1352.                         [
  1353.                             'recipient' => strtoupper($groupName) . ' Team',
  1354.                             'appraisal' => $appraisal,
  1355.                             'group' => $groupName,
  1356.                         ]
  1357.                     );
  1358.                 } catch (Exception $e) {
  1359.                 }
  1360.             };
  1361.         };
  1363.         $entityManager = $this->getDoctrine()->getManager();
  1364.         $appraisalComments = $this->getDoctrine()->getRepository(AppraisalComment::class)->findByAppraisal($appraisal);
  1365.         if ($appraisalComments != null) {
  1366.             foreach ($appraisalComments as $appraisalComment) {
  1367.                 $entityManager->remove($appraisalComment);
  1368.             };
  1369.         }
  1370.         $appraisalForms = $this->getDoctrine()->getRepository(AppraisalForm::class)->findByAppraisal($appraisal);
  1371.         if ($appraisalForms != null) {
  1372.             foreach ($appraisalForms as $appraisalForm) {
  1373.                 $entityManager->remove($appraisalForm);
  1374.             };
  1375.         };
  1376.         $entityManager->remove($appraisal);
  1377.         $entityManager->flush();
  1379.         $appraisalService->syncAppraisalStatus($appraisal->getUser());
  1381.         return new JsonResponse('OK');
  1382.     }
  1384.     #[Route(path: '/appraisal/{_id}', defaults: ['_id' => 0], name: 'submit_appraisal')]
  1385.     public function submitAppraisal(string $_id, Request $request, TranslatorInterface $translator, SerializerInterface $serializer, MailgunService $mailgunService, NotificationService $notification, ICSService $ics, AppraisalService $appraisalService, LeaveService $leaveService, UserService $userService, LogService $log)
  1386.     {
  1387.         $user = $this->getUser();
  1388.         $appraisal =  $this->getDoctrine()->getRepository(Appraisal::class)->find($_id);
  1390.         if ($appraisal == null) {
  1391.             return $this->redirectToRoute('user_profile', ['g' => 'appraisal']);
  1392.         };
  1394.         $oldAppraisal = clone $appraisal;
  1395.         $oldData = [];
  1396.         $newData = [];
  1397.         $userNote = null;
  1398.         $appraisalNotes = null;
  1399.         $userAppraisalNote = new AppraisalNote();
  1400.         $loggedIn = $request ? true : false;
  1401.         $concludeAppraisal = false;
  1402.         $permanent=false;
  1403.         if(!is_null($oldAppraisal)){
  1404.             $permanent=$oldAppraisal->getUser()->getPersonalInfo()->getJobStatus();
  1405.             if($permanent=='form.job_status.permanent'){$permanent=true;}else{$permanent=false;}
  1406.         }
  1408.         if ($appraisal->getAppraisalNotes() != null and count($appraisal->getAppraisalNotes()) > 0) {
  1409.             $appraisalNotes = $this->getDoctrine()->getRepository(AppraisalNote::class)->findByAppraisal($appraisal);
  1410.             $userNote = $this->getDoctrine()->getRepository(AppraisalNote::class)->findByAppraisalByUser($appraisal, $user);
  1411.             if ($userNote != null) {
  1412.                 $userAppraisalNote = $userNote;
  1413.             }
  1414.         };
  1415.         $oldUserNote = is_object($userNote) ? clone $userNote : null;
  1416.         $appraisalNoteForm = $this->createForm(AppraisalNoteType::class, $userAppraisalNote);
  1418.         // Only HR, Appraisse and included Manager access this function
  1419.         if ($this->isGranted('ROLE_HR') || $appraisal->getUser() == $user || $appraisal->getUser()->getIsIncludedManager($user)) {
  1420.             
  1421.             $categorizedAssessments = [];
  1422.             $categories =  $this->getDoctrine()->getRepository(AppraisalCategory::class)->findByCDT($appraisal->getUser()->assignedCompany(), $appraisal->getUser()->organizationDepartments(), $appraisal->getUser()->appraisalType($appraisal));
  1424.             foreach($categories as $category){
  1425.                 foreach($category->getQuestionnaire() as $question){
  1426.                    $categorizedAssessments[] = $question;
  1427.                 }
  1428.             }
  1430.             if ($_SERVER['APP_ENV'] == "prod" && $appraisal->getUser()->inProbation() && $appraisal->getSubmitAt()->format('Ymd') < '20221001') {
  1431.                 $oldAssessments = $this->getDoctrine()->getRepository(AppraisalForm::class)->findByCODA($appraisal->getUser()->assignedCompany(), $appraisal->getUser()->getOffice(), $appraisal->getUser()->organizationDepartments(), $appraisal);
  1432.             } else {
  1433.                 $oldAssessments = $this->getDoctrine()->getRepository(AppraisalForm::class)->findByType($appraisal->getUser()->assignedCompany(), $appraisal->getUser()->appraisalType($appraisal), $appraisal);
  1434.             }
  1436.             // This is to check between old and new assessments (has been categorized or not)
  1437.             if(count($categorizedAssessments) > 0){
  1438.                 $assessments = $categorizedAssessments;
  1439.                 // Below are for combine old and new assessments
  1440.                 // if(count($oldAssessments) > 0){
  1441.                 //     foreach($oldAssessments as $oldAssessment){
  1442.                 //         $exist = false;
  1443.                 //         foreach($categorizedAssessments as $assessment){
  1444.                 //             if($oldAssessment->getId() == $assessment->getId()){
  1445.                 //                 $exist = true;
  1446.                 //                 break;
  1447.                 //             }
  1448.                 //         }
  1449.                 //         if(!$exist){
  1450.                 //             $assessments[] = $oldAssessment;
  1451.                 //         }
  1452.                 //     }
  1453.                 // }
  1454.             } else {
  1455.                 $assessments = $oldAssessments;
  1456.             }
  1457.         
  1458.             if ($request->isMethod('post')) {
  1459.                 $entityManager = $this->getDoctrine()->getManager();
  1460.                 
  1462.                 if ($user != $appraisal->getUser()) {
  1463.                     $requestNote = $request->request->get('appraisal_note');
  1464.                     $summary = false;
  1466.                     if ($userAppraisalNote->getId() && $userAppraisalNote->getNote() != '') {
  1467.                         $oldUserAppraisalNote = clone $userAppraisalNote;
  1468.                     } else {
  1469.                         $oldUserAppraisalNote = null;
  1470.                     };
  1471.                     if ($requestNote['note'] != '') {
  1472.                         $summary = $userAppraisalNote->getNote() == $requestNote['note'] ? false : $requestNote['note'];
  1473.                         $userAppraisalNote->setNote($requestNote['note']);
  1474.                         $userAppraisalNote->setDraft($request->request->get('draft') == "false" ? false : true);
  1475.                     };
  1477.                     if ($userNote == null) {
  1478.                         $userAppraisalNote->setAppraisal($appraisal);
  1479.                         $userAppraisalNote->setUser($user);
  1480.                         $userAppraisalNote->setCreatedAt(new \DateTime());
  1481.                         $entityManager->persist($userAppraisalNote);
  1482.                     } else {
  1483.                         $userAppraisalNote->setUpdatedAt(new \DateTime());
  1484.                     }
  1485.                     // Only proceed if it's not a draft anymore
  1486.                     if ($request->request->get('draft') == 'false') {
  1487.                         // Only proceed if it still not concluded yet
  1488.                         if (($appraisal->getConcludedAt() == null && $appraisal->getUser()->getIsIncludedManager($user)) || ($appraisal->getConcludedAt() == null && $this->isGranted('ROLE_HR'))) {
  1489.                             $currentStep = $appraisal->currentStep();
  1490.                             $objectiveInvitation = false;
  1491.                             $objectiveEmailTemplate = 'email/user-notification/appraisal/set-objective.html.twig';
  1492.                             $emailGroup = $this->getParameter('systemEmailGroup'); 
  1494.                             // Only proceed if in step 2 or 3
  1495.                             if ($currentStep == 2 && $appraisal->getUser()->getIsIncludedManager($user) || $currentStep == 3 && $appraisal->getUser()->getManager() == $user && $appraisal->getReviewAt() == null || $this->isGranted('ROLE_HR')) { // Manager or HR
  1496.                                 if ($appraisal->getUser()->getManager() == $user) $appraisal->setReviewedAt(new \DateTime());
  1497.                                 // if ($appraisal->getUser()->inProbation()) $appraisal->setReviewAt(\DateTime::createFromFormat('d/m/Y H:i', $request->request->get('reviewDate')));
  1498.                                 if($request->request->get('reviewDate') != null){
  1499.                                     $appraisal->setReviewAt(\DateTime::createFromFormat('d/m/Y H:i', $request->request->get('reviewDate')));
  1500.                                 }
  1502.                                 $entityManager->flush();
  1503.                                 $entityManager->refresh($appraisal);
  1505.                                 // Only proceed if user still in probation, so it can process to permanent or not
  1506.                                 if ($appraisal->getUser()->inProbation() || $appraisal->getUser()->getManager() == $user && $appraisal->getConcludedAt() == null) {
  1507.                                     $notificationData = [
  1508.                                         '%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  1509.                                         '%date%' => $appraisal->getReviewAt()->format('l, d M Y') . ' at ' . $appraisal->getReviewAt()->format('H:i')
  1510.                                     ];
  1512.                                     $attendee = [
  1513.                                         [
  1514.                                             'name' => $user->getPersonalInfo()->getFullName(),
  1515.                                             'email' => $user->getEmail(),
  1516.                                             'role' => $appraisal->getUser()->getManager() == $user ? 'REQ-PARTICIPANT' : 'OPT-PARTICIPANT'
  1517.                                         ],
  1518.                                         [
  1519.                                             'name' => $appraisal->getUser()->getPersonalInfo()->getFullName(),
  1520.                                             'email' => $appraisal->getUser()->getEmail(),
  1521.                                             'role' => 'REQ-PARTICIPANT'
  1522.                                         ],
  1523.                                     ];
  1524.                                     foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1525.                                         if ($manager != $user) {
  1526.                                             array_push($attendee,   [
  1527.                                                 'name' => $manager->getPersonalInfo()->getFullName(),
  1528.                                                 'email' => $manager->getEmail(),
  1529.                                                 'role' => $appraisal->getUser()->getManager() == $manager ? 'REQ-PARTICIPANT' : 'OPT-PARTICIPANT'
  1530.                                             ]);
  1531.                                         }
  1532.                                     }
  1534.                                     $endTime = new \DateTime($appraisal->getReviewAt()->format('Ymd H:i:s'));
  1535.                                     $endTime->modify('+ 30 minutes');
  1537.                                     $ICSTitle = $appraisal->getUser()->inProbation() ? 'Review (Probation)' : 'Review';
  1539.                                     $icsData =  $ics->generateEventFile([
  1540.                                         'uid' => $appraisal->getId() . $appraisal->getUser()->getId() . ':' . $appraisal->getUser()->getEmail(),
  1541.                                         'title' => $ICSTitle . ': ' . $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  1542.                                         'description' => $translator->trans('ics.appraisal.description', ['%uid%' => $appraisal->getUser()->getId(), '%user%' => strtolower($appraisal->getUser()->getPersonalInfo()->getFirstName()), '%link%' => $this->generateUrl('user_profile', array(), UrlGeneratorInterface::ABSOLUTE_URL) . '/' . $appraisal->getUser()->getEmail() . '?g=appraisal&open=appraisal-' . $appraisal->getId()]),
  1543.                                         'startDateTime' => $appraisal->getReviewAt()->format('Ymd') . 'T' . $appraisal->getReviewAt()->format('His'),
  1544.                                         'endDateTime' =>  $appraisal->getReviewAt()->format('Ymd') . 'T' . $endTime->format('His'),
  1545.                                         'location' =>  $this->generateUrl('submit_appraisal', array(), UrlGeneratorInterface::ABSOLUTE_URL) . '/' . $appraisal->getId(),
  1546.                                         'organizer' => [
  1547.                                             'name' => $this->getParameter('systemEmailName'),
  1548.                                             'email' => $_SERVER['APP_ENV'] == 'prod' ? $this->getParameter('systemEmailAddr') : 'devops@mediatropy.com'
  1549.                                         ],
  1550.                                         'attendee' => $attendee,
  1551.                                         'reminderTime' => '-15M',
  1552.                                         'reminderDescription' => $translator->trans('ics.appraisal.title') . ' ' . $appraisal->getTitle(),
  1553.                                         'fileName' => 'Appraisal-' . $appraisal->getIcsToken()
  1554.                                     ], true);
  1556.                                     if ($appraisal->getUser()->inProbation()) {
  1557.                                         $emailTemplate = 'email/user-notification/appraisal/invitation-probation.html.twig';
  1558.                                         $titleTemplate = 'email.appraisal.invitation.probation.';
  1559.                                         $titleNotificationUser = $translator->trans('notification.appraisal.invitation.probation.user', ['%link%' => $this->generateURL('submit_appraisal') . '/' . $appraisal->getId()]);
  1560.                                         $titleNotificationManager = $translator->trans('notification.appraisal.invitation.probation.manager', ['%link%' => $this->generateURL('submit_appraisal') . '/' . $appraisal->getId()]);
  1561.                                     } else {
  1562.                                         $emailTemplate = 'email/user-notification/appraisal/invitation-default.html.twig';
  1563.                                         $titleTemplate = 'email.appraisal.invitation.default.';
  1564.                                         $titleNotificationUser = $translator->trans('notification.appraisal.invitation.default.user', ['%link%' => $this->generateURL('submit_appraisal') . '/' . $appraisal->getId()]);
  1565.                                         $titleNotificationManager = $translator->trans('notification.appraisal.invitation.default.manager', ['%link%' => $this->generateURL('submit_appraisal') . '/' . $appraisal->getId()]);
  1566.                                     };
  1569.                                     $mailgunService->sendEmailWithAttachment([
  1570.                                         'subject' =>  $translator->trans($titleTemplate . 'user', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(), '%date%' => $appraisal->getReviewAt()->format('l, d M Y')]),
  1571.                                         'to' => $appraisal->getUser()->getEmail(),
  1572.                                         'template' => $emailTemplate,
  1573.                                         'params' => [
  1574.                                             'recipient' => $appraisal->getUser(),
  1575.                                             'appraisal' => $appraisal,
  1576.                                             'group' => 'user'
  1577.                                         ],
  1578.                                         'ical' => $icsData
  1579.                                     ], $loggedIn);
  1581.                                     $notification->push($appraisal->getUser(), $titleNotificationUser, $notificationData, 'i-review', $appraisal->getId());
  1583.                                     foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1584.                                         $mailgunService->sendEmailWithAttachment([
  1585.                                             'subject' => $translator->trans($titleTemplate . 'manager', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(), '%date%' => $appraisal->getReviewAt()->format('l, d M Y')]),
  1586.                                             'to' => $manager->getEmail(),
  1587.                                             'template' => $emailTemplate,
  1588.                                             'params' => [
  1589.                                                 'recipient' => $manager,
  1590.                                                 'appraisal' => $appraisal,
  1591.                                                 'group' => 'manager'
  1592.                                             ],
  1593.                                             'ical' => $icsData
  1594.                                         ], $loggedIn);
  1596.                                         $notification->push($manager, $titleNotificationManager, $notificationData, 'i-review', $appraisal->getId());
  1597.                                     }
  1598.                                     foreach ($emailGroup as $groupName => $groupEmail) {
  1599.                                         if ($groupName == 'hr') { // only HR
  1600.                                             $mailgunService->sendEmailWithAttachment([
  1601.                                                 'subject' => $translator->trans($titleTemplate . 'hr', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(), '%date%' => $appraisal->getReviewAt()->format('l, d M Y')]),
  1602.                                                 'to' => $groupEmail,
  1603.                                                 'template' => $emailTemplate,
  1604.                                                 'params' => [
  1605.                                                     'recipient' => strtoupper($groupName) . ' Team',
  1606.                                                     'appraisal' => $appraisal,
  1607.                                                     'group' => $groupName
  1608.                                                 ],
  1609.                                                 'ical' => $icsData
  1610.                                             ], $loggedIn);
  1611.                                         };
  1612.                                     };
  1613.                                 } elseif ($appraisal->getUser()->getIsIncludedManager($user) && $appraisal->getConcludedAt() == null) { // Yearly
  1614.                                     if ($appraisal->getProbation() == true) {
  1615.                                         $emailTemplate = 'email/user-notification/appraisal/manager-submitted-probation.html.twig';
  1616.                                         $titleTemplate = 'email.appraisal.submitted.manager_probation.';
  1617.                                     } else {
  1618.                                         $emailTemplate = 'email/user-notification/appraisal/manager-submitted-default.html.twig';
  1619.                                         $titleTemplate = 'email.appraisal.submitted.manager_default.';
  1620.                                       
  1621.                                     };
  1623.                                     // $mailgunService->sendEmail(
  1624.                                     //     $translator->trans($titleTemplate . 'manager'),
  1625.                                     //     [$user->getEmail()],
  1626.                                     //     $emailTemplate,
  1627.                                     //     [
  1628.                                     //         'recipient' => $user,
  1629.                                     //         'sender' => $user,
  1630.                                     //         'group' => 'manager',
  1631.                                     //         'appraisal' => $appraisal,
  1632.                                     //     ]
  1633.                                     // );
  1635.                                     // foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1636.                                     //     $mailgunService->sendEmail(
  1637.                                     //         $translator->trans($titleTemplate . 'manager', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName()]),
  1638.                                     //         [$manager->getEmail()],
  1639.                                     //         $emailTemplate,
  1640.                                     //         [
  1641.                                     //             'recipient' => $manager,
  1642.                                     //             'group' => 'manager',
  1643.                                     //             'appraisal' => $appraisal,
  1644.                                     //         ]
  1645.                                     //     );
  1646.                                     // }
  1647.                            
  1648.                                         // $appraisal->setReviewAt(new \DateTime());
  1649.                                     
  1650.                                     foreach ($emailGroup as $groupName => $groupEmail) {
  1651.                                         if ($groupName == 'hr') { // only HR
  1652.                                             $mailgunService->sendEmail(
  1653.                                                 $translator->trans($titleTemplate . 'hr', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFullName()]),
  1654.                                                 [$groupEmail],
  1655.                                                 $emailTemplate,
  1656.                                                 [
  1657.                                                     'recipient' => strtoupper($groupName) . ' Team',
  1658.                                                     'group' => $groupName,
  1659.                                                     'appraisal' => $appraisal,
  1660.                                                 ]
  1661.                                             );
  1662.                                         };
  1663.                                     };
  1664.                                  
  1665.                                 }
  1666.                             } elseif (in_array($currentStep, [4, 5]) == true && $appraisal->getUser()->inProbation() && $appraisal->getAdHoc() == false) { // Probation User
  1667.                                 $expiryDate = $appraisal->getUser()->getPersonalInfo()->getJobExpiryDate() ? $appraisal->getUser()->getPersonalInfo()->getJobExpiryDate() : new \DateTime();
  1668.                                 $joinDate = $appraisal->getUser()->getPersonalInfo()->getJobJoinDate();
  1669.                                 $conclusion = $request->request->get('conclusion');
  1670.                                 $notificationData = [
  1671.                                     '%link%' => '<a href="' . $this->generateURL('submit_appraisal') . '/' . $appraisal->getId() . '">Probation\'s Appraisal Form</a>'
  1672.                                 ];
  1673.                                 switch ($conclusion) {
  1674.                                     case 'permanent':
  1675.                                         //$newExpiryDate = date('Y-m-d', strtotime('6 months', $expiryDate->getTimestamp()));
  1676.                                         /*$newExpiryDate = $userService->nextReviewDate();
  1677.                                         $appraisal->getUser()->getPersonalInfo()->setJobExpiryDate(\DateTime::createFromFormat('Y-m-d', $newExpiryDate));
  1678.                                         /*$totalProbation = 3 + $appraisal->getExtendedProbation();
  1679.                                         echo $totalProbation.' '.$appraisal->getExtendedProbation();
  1680.                                         $becomePermanentDate = $joinDate->modify('+'.$totalProbation.' months');
  1681.                                         dump($becomePermanentDate);die;*/
  1682.                                         //$appraisal->getUser()->getPersonalInfo()->setJobPermanentDate($joinDate->modify('+3 months'));
  1683.                                         $attributes =  $appraisal->getUser()->assignedCompany()->getAttributes();
  1684.                                         $newExpiryDate = isset($attributes['appraisalEndAt']) ? new \DateTime($attributes['appraisalEndAt']['date']) : new \DateTime('+ 1 years');
  1685.                                         $appraisal->getUser()->getPersonalInfo()->setJobExpiryDate($newExpiryDate);
  1686.                                         $appraisal->getUser()->getPersonalInfo()->setJobPermanentDate($expiryDate);
  1687.                                         $emailTemplate = 'email/user-notification/appraisal/conclude-pass.html.twig';
  1688.                                         $titleTemplate = 'email.appraisal.concluded.pass.';
  1689.                                         $objectiveInvitation = true;
  1690.                                         $concludeAppraisal = true;
  1691.                                         $notification->push($appraisal->getUser(), 'notification.appraisal.concluded.pass', $notificationData, 'i-star-svg', $appraisal->getId());
  1692.                                         break;
  1693.                                     case 'limited':
  1694.                                         $newExpiryDate = date('Y-m-d', strtotime('3 months', $expiryDate->getTimestamp()));
  1695.                                         $appraisal->getUser()->getPersonalInfo()->setJobExpiryDate(\DateTime::createFromFormat('Y-m-d', $newExpiryDate));
  1696.                                         $emailTemplate = 'email/user-notification/appraisal/conclude-pass.html.twig';
  1697.                                         $titleTemplate = 'email.appraisal.concluded.pass.';
  1698.                                         $objectiveInvitation = true;
  1699.                                         $concludeAppraisal = true;
  1700.                                         $notification->push($appraisal->getUser(), 'notification.appraisal.concluded.pass', $notificationData, 'i-star-svg', $appraisal->getId());
  1701.                                         break;
  1702.                                     case 'temporary':
  1703.                                         $newExpiryDate = date('Y-m-d', strtotime('3 months', $expiryDate->getTimestamp()));
  1704.                                         $appraisal->getUser()->getPersonalInfo()->setJobExpiryDate(\DateTime::createFromFormat('Y-m-d', $newExpiryDate));
  1705.                                         $emailTemplate = 'email/user-notification/appraisal/conclude-pass.html.twig';
  1706.                                         $titleTemplate = 'email.appraisal.concluded.pass.';
  1707.                                         $objectiveInvitation = true;
  1708.                                         $concludeAppraisal = true;
  1709.                                         $notification->push($appraisal->getUser(), 'notification.appraisal.concluded.pass', $notificationData, 'i-star-svg', $appraisal->getId());
  1710.                                         break;
  1711.                                     case 'fail':
  1712.                                         $appraisal->getUser()->getPersonalInfo()->setJobTerminateReason('form.terminate_reason.probation_failed');
  1713.                                         $appraisal->getUser()->getPersonalInfo()->setJobTerminateDate($expiryDate);
  1714.                                         $emailTemplate = 'email/user-notification/appraisal/conclude-fail.html.twig';
  1715.                                         $titleTemplate = 'email.appraisal.concluded.fail.';
  1716.                                         break;
  1717.                                     default: // Extended
  1718.                                         $newExpiryDate = date('Y-m-d', strtotime($conclusion == 1 ? '1 month' : '3 months', $expiryDate->getTimestamp()));
  1719.                                         $appraisal->getUser()->getPersonalInfo()->setJobExpiryDate(\DateTime::createFromFormat('Y-m-d', $newExpiryDate));
  1720.                                         //$previousExtendedProbation = $appraisal->getUser()->getPersonalInfo()->getExtendedProbation();
  1721.                                         //$appraisal->getUser()->getPersonalInfo()->setExtendedProbation($previousExtendedProbation + $conclusion);
  1722.                                         $emailTemplate = 'email/user-notification/appraisal/conclude-extend.html.twig';
  1723.                                         $titleTemplate = 'email.appraisal.concluded.extend.';
  1724.                                         $concludeAppraisal = true;
  1725.                                         $notification->push($appraisal->getUser(), 'notification.appraisal.concluded.extend', $notificationData, 'i-star-blank-svg', $appraisal->getId());
  1726.                                         break;
  1727.                                 };
  1729.                                 $appraisal->setConcludedAt(new \DateTime());
  1730.                                 // Email     
  1731.                                 $mailgunService->sendEmail(
  1732.                                     $translator->trans($titleTemplate . 'user', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName()]),
  1733.                                     [$appraisal->getUser()->getEmail()],
  1734.                                     $emailTemplate,
  1735.                                     [
  1736.                                         'recipient' => $appraisal->getUser(),
  1737.                                         'appraisal' => $appraisal,
  1738.                                         'group' => 'user',
  1739.                                         'conclusion' => $conclusion
  1740.                                     ]
  1741.                                 );
  1743.                                 foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1744.                                     $mailgunService->sendEmail(
  1745.                                         $translator->trans($titleTemplate . 'manager', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName()]),
  1746.                                         [$manager->getEmail()],
  1747.                                         $emailTemplate,
  1748.                                         [
  1749.                                             'recipient' => $manager,
  1750.                                             'appraisal' => $appraisal,
  1751.                                             'group' => 'manager',
  1752.                                             'conclusion' => $conclusion
  1753.                                         ]
  1754.                                     );
  1755.                                 }
  1756.                                 foreach ($emailGroup as $groupName => $groupEmail) {
  1757.                                     if ($groupEmail != '') {
  1758.                                         $mailgunService->sendEmail(
  1759.                                             $translator->trans($titleTemplate . $groupName, ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName()]),
  1760.                                             [$groupEmail],
  1761.                                             $emailTemplate,
  1762.                                             [
  1763.                                                 'recipient' => strtoupper($groupName) . ' Team',
  1764.                                                 'appraisal' => $appraisal,
  1765.                                                 'group' => $groupName,
  1766.                                                 'conclusion' => $conclusion
  1767.                                             ]
  1768.                                         );
  1769.                                     };
  1770.                                 };
  1772.                                 switch ($conclusion) {
  1773.                                     case 'permanent':
  1774.                                         $appraisal->getUser()->getPersonalInfo()->setJobStatus('form.job_status.permanent');
  1775.                                         break;
  1776.                                     case 'limited':
  1777.                                         $appraisal->getUser()->getPersonalInfo()->setJobStatus('form.job_status.time_limited');
  1778.                                         break;
  1779.                                     case 'temporary':
  1780.                                         $appraisal->getUser()->getPersonalInfo()->setJobStatus('form.job_status.temporary');
  1781.                                         break;
  1782.                                 };
  1783.                             } elseif (in_array($currentStep, [4, 5]) == true && $appraisal->getUser()->inProbation() == false && $appraisal->getAdHoc() == false) { // Permanent User
  1784.                                 //$expiryDate = $appraisal->getUser()->getPersonalInfo()->getJobExpiryDate();
  1785.                                 //$newExpiryDate = $expiryDate ? date('Y-m-d', strtotime('6 months', $expiryDate->getTimestamp())) : date('Y-m-d');
  1786.                                 /*$newExpiryDate = $userService->nextReviewDate();
  1787.                                 $appraisal->getUser()->getPersonalInfo()->setJobExpiryDate(\DateTime::createFromFormat('Y-m-d', $newExpiryDate));*/
  1788.                                 // $oldData = clone $appraisal->getUser()->getPersonalInfo();
  1789.                              
  1790.                                 if($appraisal->getUser()->getManager() == $user){
  1791.                                     $appraisal->setConcludedAt(new \DateTime());
  1792.                                     $concludeAppraisal = true;
  1793.                                 }
  1794.                             } elseif ($appraisal->getAdHoc()) {
  1795.                                 // $oldData = clone $appraisal->getUser()->getPersonalInfo();
  1796.                                 
  1797.                                 $appraisal->setConcludedAt(new \DateTime());
  1798.                                 $concludeAppraisal = true;
  1799.                             }
  1800.                             if ($summary) {
  1801.                                 //$updateSummary = $userNote == null ? null : ' (update)';
  1802.                                 $updateSummary = null;
  1803.                                 if ($appraisal->getAdHoc()) {
  1804.                                     $titleTemplate = 'email.appraisal.ad_hoc.';
  1805.                                     $emailTemplate = 'email/user-notification/appraisal/summary-ad-hoc.html.twig';
  1806.                                 } else {
  1807.                                     $titleTemplate = 'email.appraisal.summary.';
  1808.                                     $emailTemplate = 'email/user-notification/appraisal/summary.html.twig';
  1809.                                 };
  1810.                                 //Summary Copy
  1811.                                 $mailgunService->sendEmail(
  1812.                                     $translator->trans($titleTemplate . 'user', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(), '%date%' => $appraisal->getReviewAt()->format('d F Y')]) . $updateSummary,
  1813.                                     [$appraisal->getUser()->getEmail()],
  1814.                                     $emailTemplate,
  1815.                                     [
  1816.                                         'recipient' => $appraisal->getUser(),
  1817.                                         'appraisal' => $appraisal,
  1818.                                         'summary' => $summary,
  1819.                                         'group' => 'user'
  1820.                                     ]
  1821.                                 );
  1823.                                 //$notification->push($appraisal->getUser(),'notification.objective.invitation.user', $notificationData, 'i-review', $appraisal->getId());
  1825.                                 foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1826.                                     $mailgunService->sendEmail(
  1827.                                         $translator->trans($titleTemplate . 'manager', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFullName(), '%manager%' => $manager->getPersonalInfo()->getFirstName(), '%date%' => $appraisal->getReviewAt()->format('d F Y')]) . $updateSummary,
  1828.                                         [$manager->getEmail()],
  1829.                                         $emailTemplate,
  1830.                                         [
  1831.                                             'recipient' => $manager,
  1832.                                             'appraisal' => $appraisal,
  1833.                                             'summary' => $summary,
  1834.                                             'group' => 'manager'
  1835.                                         ]
  1836.                                     );
  1837.                                     //$notification->push($manager,'notification.objective.invitation.manager', $notificationData, 'i-review', $appraisal->getId());
  1838.                                 }
  1840.                                 foreach ($emailGroup as $groupName => $groupEmail) {
  1841.                                     if ($appraisal->getUser()->inProbation() == false && $groupName == 'finance') continue;
  1842.                                     $mailgunService->sendEmail(
  1843.                                         $translator->trans($titleTemplate . $groupName, ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFullName(), '%date%' => $appraisal->getReviewAt()->format('d F Y')]) . $updateSummary,
  1844.                                         [$groupEmail],
  1845.                                         $emailTemplate,
  1846.                                         [
  1847.                                             'recipient' => strtoupper($groupName) . ' Team',
  1848.                                             'appraisal' => $appraisal,
  1849.                                             'summary' => $summary,
  1850.                                             'group' => $groupName,
  1851.                                         ]
  1852.                                     );
  1853.                                 };
  1854.                             };
  1856.                             //Objective Invitation
  1857.                             /*
  1858.                             if ($objectiveInvitation) {
  1859.                                 $notificationData = [
  1860.                                     '%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  1861.                                     '%link%' => '<a href="' . $this->generateURL('user_profile') . '/' . $appraisal->getUser()->getEmail() . '?g=objective">Objectives</a>'
  1862.                                 ];
  1863.                                 $mailgunService->sendEmail(
  1864.                                     $translator->trans('email.objective.invitation.user', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName()]),
  1865.                                     [$appraisal->getUser()->getEmail()],
  1866.                                     $objectiveEmailTemplate,
  1867.                                     [
  1868.                                         'recipient' => $appraisal->getUser(),
  1869.                                         'appraisal' => $appraisal,
  1870.                                         'group' => 'user'
  1871.                                     ]
  1872.                                 );
  1873.                                 $notification->push($appraisal->getUser(), 'notification.objective.invitation.user', $notificationData, 'i-review', $appraisal->getId());
  1874.                                 foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1875.                                     $mailgunService->sendEmail(
  1876.                                         $translator->trans('email.objective.invitation.manager', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName()]),
  1877.                                         [$manager->getEmail()],
  1878.                                         $objectiveEmailTemplate,
  1879.                                         [
  1880.                                             'recipient' => $manager,
  1881.                                             'appraisal' => $appraisal,
  1882.                                             'group' => 'manager'
  1883.                                         ]
  1884.                                     );
  1885.                                     $notification->push($manager, 'notification.objective.invitation.manager', $notificationData, 'i-review', $appraisal->getId());
  1886.                                 }
  1887.                                 foreach ($emailGroup as $groupName => $groupEmail) {
  1888.                                     if ($groupName == 'hr') {
  1889.                                         $mailgunService->sendEmail(
  1890.                                             $translator->trans('email.objective.invitation.hr', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(), '%manager%' => $appraisal->getUser()->getManager()->getPersonalInfo()->getFirstName()]),
  1891.                                             [$groupEmail],
  1892.                                             $objectiveEmailTemplate,
  1893.                                             [
  1894.                                                 'recipient' => strtoupper($groupName) . ' Team',
  1895.                                                 'appraisal' => $appraisal,
  1896.                                                 'group' => $groupName
  1897.                                             ]
  1898.                                         );
  1899.                                     }
  1900.                                 };
  1901.                             }*/
  1902.                         };
  1903.                     };
  1904.                 };
  1906.                 // Only proceed if $user not yet in "reviewed" table or if it for amend purpose
  1907.                 if (!$appraisal->hasReviewed($user)){
  1908.                     foreach ($assessments as $assessment) {
  1909.                         try {
  1910.                             $comment = $assessment->appraisalCommentsByOwner($_id, $user->getId());
  1911.                             if ($comment != null) {
  1912.                                 $_comment = clone $comment;
  1913.                                 array_push($oldData, $_comment);
  1914.                                 if ($request->request->get('score-' . $assessment->getId()) != null) $comment->setScore($request->request->get('score-' . $assessment->getId()));
  1915.                                 if ($request->request->get('comment-' . $assessment->getId()) != null) $comment->setComment($request->request->get('comment-' . $assessment->getId()));
  1916.                                 $comment->setDraft($request->request->get('draft') == "false" ? false : true);
  1917.                                 $comment->setUpdatedAt(new \DateTime());
  1918.                                 if ($user == $appraisal->getUser())
  1919.                                     $comment->setFormContent($serializer->serialize($serializer->normalize($assessment, null, ['groups' => 'Appraisal']), 'json'));
  1920.                             } else {
  1921.                                 $comment = new AppraisalComment();
  1922.                                 if ($request->request->get('score-' . $assessment->getId()) != null) $comment->setScore($request->request->get('score-' . $assessment->getId()));
  1923.                                 if ($request->request->get('comment-' . $assessment->getId()) != null) $comment->setComment($request->request->get('comment-' . $assessment->getId()));
  1924.                                 $comment->setForm($assessment);
  1925.                                 $comment->setAppraisal($appraisal);
  1926.                                 $comment->setDraft($request->request->get('draft') == "false" ? false : true);
  1927.                                 $comment->setCreatedAt(new \DateTime());
  1928.                                 if ($user == $appraisal->getUser()) {
  1929.                                     $comment->setUser($appraisal->getUser());
  1930.                                     $comment->setType('submit');
  1931.                                 } else {
  1932.                                     $comment->setUser($user);
  1933.                                     $comment->setType('review');
  1934.                                 };
  1936.                                 if ($user == $appraisal->getUser())
  1937.                                     $comment->setFormContent($serializer->serialize($serializer->normalize($assessment, null, ['groups' => 'Appraisal']), 'json'));
  1939.                                 $entityManager->persist($comment);
  1940.                                 //$oldData = null;
  1941.                             }
  1942.                             array_push($newData, $comment);
  1943.                         } catch (Throwable $t) {
  1944.                             continue;
  1945.                         }
  1946.                     }
  1947.                     if ($user == $appraisal->getUser() && $request->request->get('draft') == 'false') {
  1948.                         $appraisal->setSubmittedAt(new \DateTime());
  1950.                         if ($appraisal->getUser()->inProbation()) {
  1951.                             $emailTitle = 'email.appraisal.submitted.probation.';
  1952.                             $emailTemplate = 'email/user-notification/appraisal/submitted-probation.html.twig';
  1953.                             $titleNotification = 'notification.appraisal.submitted.probation.';
  1954.                             $notificationLinkTitle = 'Appraisal (Probation) Form';
  1955.                         } else {
  1956.                             $emailTitle = 'email.appraisal.submitted.default.';
  1957.                             $emailTemplate = 'email/user-notification/appraisal/submitted-default.html.twig';
  1958.                             $titleNotification = 'notification.appraisal.submitted.default.';
  1959.                             $notificationLinkTitle = 'Appraisal Form';
  1960.                         };
  1962.                         $notificationData = [
  1963.                             '%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(),
  1964.                             '%link%' => '<a href="' . $this->generateURL('submit_appraisal') . '/' . $appraisal->getId() . '">' . $notificationLinkTitle . '</a>',
  1965.                         ];
  1967.                         $mailgunService->sendEmail(
  1968.                             $translator->trans($emailTitle . 'user', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName()]),
  1969.                             [$appraisal->getUser()->getEmail()],
  1970.                             $emailTemplate,
  1971.                             [
  1972.                                 'recipient' => $appraisal->getUser(),
  1973.                                 'appraisal' => $appraisal,
  1974.                                 'group' => 'user'
  1975.                             ],
  1976.                             $loggedIn
  1977.                         );
  1979.                         $notification->push($appraisal->getUser(), $titleNotification . 'user', $notificationData, 'i-review', $appraisal->getId());
  1981.                         foreach ($appraisal->getUser()->getAllManager() as $manager) {
  1982.                             $mailgunService->sendEmail(
  1983.                                 $translator->trans($emailTitle . 'manager', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(), '%manager%' => $manager->getPersonalInfo()->getFirstName()]),
  1984.                                 [$manager->getEmail()],
  1985.                                 $emailTemplate,
  1986.                                 [
  1987.                                     'recipient' => $manager,
  1988.                                     'appraisal' => $appraisal,
  1989.                                     'group' => 'manager'
  1990.                                 ],
  1991.                                 $loggedIn
  1992.                             );
  1993.                             $notification->push($manager, $titleNotification . 'manager', $notificationData, 'i-review', $appraisal->getId());
  1994.                         }
  1997.                         $emailGroup = $this->getParameter('systemEmailGroup');
  1998.                         foreach ($emailGroup as $groupName => $groupEmail) {
  1999.                             try {
  2000.                                 if ($groupName == 'hr') {
  2001.                                     $mailgunService->sendEmail(
  2002.                                         $translator->trans($emailTitle . 'hr', ['%user%' => $appraisal->getUser()->getPersonalInfo()->getFirstName(), '%manager%' => $appraisal->getUser()->getManager()->getPersonalInfo()->getFirstName()]),
  2003.                                         [$groupEmail],
  2004.                                         $emailTemplate,
  2005.                                         [
  2006.                                             'recipient' => strtoupper($groupName) . ' Team',
  2007.                                             'appraisal' => $appraisal,
  2008.                                             'group' => $groupName,
  2009.                                         ],
  2010.                                         $loggedIn
  2011.                                     );
  2012.                                 };
  2013.                             } catch (Exception $e) {
  2014.                             }
  2015.                         };
  2016.                         /*
  2017.                         if ($_SERVER['NOTIF_SUPER_ADMIN'] == 'true') {
  2018.                             foreach ($user->assignedCompany()->superAdmins($user) as $superAdmin) {
  2019.                                 if ($superAdmin != $user && !in_array($superAdmin, $appraisal->getUser()->getAllManager())) {
  2020.                                     $mailgunService->sendEmail(
  2021.                                         $translator->trans('email.system.copy_super_admin').' '.$subject,
  2022.                                         [$superAdmin->getEmail()],
  2023.                                         'email/user-notification/appraisal-review.html.twig',
  2024.                                         [
  2025.                                             'user' => $appraisal->getUser(),
  2026.                                             'user_creator' => $user,
  2027.                                             'user_cc' => $superAdmin,
  2028.                                             'appraisal' => $appraisal,
  2029.                                         ]
  2030.                                     );
  2031.                                 };
  2032.                             }
  2033.                         };*/
  2034.                     } elseif ($request->request->get('draft') == 'false') {
  2035.                         /*
  2036.                         $mailgunService->scheduleEmail([
  2037.                             'subject' => $appraisal->getTitle() . ' | ' .$appraisal->getUser()->getPersonalInfo()->getFirstName(). ' | '.$translator->trans('email.appraisal.result'),
  2038.                             'to' => [$appraisal->getUser()->getEmail()],
  2039.                             'template' => 'email/user-notification/appraisal-result.html.twig',
  2040.                             'params' => [
  2041.                                 'user' => $appraisal->getUser(),
  2042.                                 'appraisal' => $appraisal,
  2043.                             ],
  2044.                         ], $appraisal->getReviewAt(), $user, 'Appraisal', $appraisal->getId());*/
  2045.                         if ($appraisal->getUser()->getManager() != $user && $appraisal->getUser()->getisIncludedManager($user)) {
  2046.                             // $notification->push($appraisal->getUser(), [
  2047.                             //     'message' => 'notification.appraisal.reviewed_alt',
  2048.                             //     'entity' => 'Appraisal',
  2049.                             //     'objectId' => $appraisal->getId(),
  2050.                             //     'data' => $serializer->serialize([
  2051.                             //         'title' => $appraisal->getTitle(),
  2052.                             //         'url' => $this->generateUrl('submit_appraisal') . '/' . $appraisal->getId(),
  2053.                             //         'manager' => $user->getPersonalInfo()->getFirstName()
  2054.                             //     ], 'json')
  2055.                             // ], true);
  2056.                             /*
  2057.                             $subject =  $appraisal->getTitle() . ' | ' . $appraisal->getUser()->getPersonalInfo()->getFirstName() . ' | ' . $translator->trans('email.appraisal.result');
  2058.                             $mailgunService->sendEmail(
  2059.                                 $subject,
  2060.                                 [$appraisal->getUser()->getEmail()],
  2061.                                 'email/user-notification/appraisal-review.html.twig',
  2062.                                 [
  2063.                                     'recipient' => $appraisal->getUser(),
  2064.                                     'sender' => $user,
  2065.                                     'appraisal' => $appraisal,
  2066.                                 ]
  2067.                             );*/
  2068.                         }
  2069.                     }
  2070.                 }
  2072.                 if ($user != $appraisal->getUser() && $request->request->get('draft') == "false" ){
  2073.                     // if($currentStep == 2) $appraisal->setReviewedBy($user);
  2074.                     $appraisal->addReviewer($user);
  2075.                 } 
  2078.                 $entityManager->flush();
  2079.                 $entityManager->refresh($appraisal);
  2081.                 $appraisalService->syncAppraisalStatus($appraisal->getUser());
  2082.              
  2083.                 //$leaveService->leavePermanent($appraisal->getUser(),false,false,null,$permanent);
  2085.                 if ($concludeAppraisal && $appraisal->getUser()->latestAppraisal($appraisal)) {
  2086.                     /*
  2087.                     $inProbation = $appraisal->getUser()->inProbation();
  2088.                     $nextTitleDate = $inProbation ? '' : ucfirst(date('M'));
  2089.                     $appraisalService->initiateAppraisal($request, $user, $appraisal->getUser(), $translator->trans($inProbation ? 'page.appraisal.title.list.probation' : 'page.appraisal.title.list.objective').' '.$nextTitleDate, $appraisal->getUser()->getPersonalInfo()->getJobExpiryDate()->modify('- 1 weeks'), null, null, null);
  2090.                     */
  2091.                 };
  2093.                 if ($request->request->get('draft') == 'false') {
  2094.                     if ($user == $appraisal->getUser()) {
  2095.                         $this->addFlash(
  2096.                             'success',
  2097.                             'messages.appraisal.submit'
  2098.                         );
  2099.                         $log->save($user, [
  2100.                             'owner' => $appraisal->getUser(),
  2101.                             'message' => 'log.appraisal.submit',
  2102.                             'old_data' => $oldData,
  2103.                             'new_data' => $newData
  2104.                         ]);
  2105.                     } else {
  2106.                         if ($request->request->get('note') == 'true') {
  2107.                             if ($appraisal->getAdHoc()) {
  2108.                                 $this->addFlash(
  2109.                                     'success',
  2110.                                     'messages.appraisal.ad_hoc'
  2111.                                 );
  2112.                                 $log->save($user, [
  2113.                                     'owner' => $appraisal->getUser(),
  2114.                                     'message' => 'log.appraisal.ad_hoc.update',
  2115.                                     'old_data' => [],
  2116.                                     'new_data' => $appraisal->getUser()->getPersonalInfo()
  2117.                                 ]);
  2118.                             } else if ($request->request->get('conclusion') || $concludeAppraisal) {
  2119.                                 $this->addFlash(
  2120.                                     'success',
  2121.                                     'messages.appraisal.conclude'
  2122.                                 );
  2123.                                 $log->save($user, [
  2124.                                     'owner' => $appraisal->getUser(),
  2125.                                     'message' => 'log.appraisal.conclude',
  2126.                                     'old_data' => [],
  2127.                                     'new_data' => $appraisal->getUser()->getPersonalInfo()
  2128.                                 ]);
  2129.                             } else {
  2130.                                 $this->addFlash(
  2131.                                     'success',
  2132.                                     'messages.appraisal.summary.save'
  2133.                                 );
  2134.                                 $log->save($user, [
  2135.                                     'owner' => $appraisal->getUser(),
  2136.                                     'message' => $oldUserAppraisalNote ? 'log.appraisal.note.update' : 'log.appraisal.note.add',
  2137.                                     'old_data' => $oldUserAppraisalNote,
  2138.                                     'new_data' => $userAppraisalNote
  2139.                                 ]);
  2140.                             }
  2141.                         } else {
  2142.                             $this->addFlash(
  2143.                                 'success',
  2144.                                 'messages.appraisal.review'
  2145.                             );
  2146.                             $log->save($user, [
  2147.                                 'owner' => $appraisal->getUser(),
  2148.                                 'message' => 'log.appraisal.review',
  2149.                                 'old_data' => $oldData,
  2150.                                 'new_data' => $newData
  2151.                             ]);
  2152.                         }
  2153.                     }
  2155.                     /* $log->save($user, [
  2156.                         'owner' => $appraisal->getUser(),
  2157.                         'message' => $logDesc,
  2158.                         'old_data' => $oldData,
  2159.                         'new_data' => $newData
  2160.                     ], false, true);*/
  2161.                 } else if ($user != $appraisal->getUser() && $request->request->get('note') == 'true' && $userAppraisalNote->getDraft()) {
  2162.                     $userAppraisalNote->setDraft(false);
  2163.                     $entityManager->flush();
  2164.                     $this->addFlash(
  2165.                         'success',
  2166.                         'messages.appraisal.summary.submit'
  2167.                     );
  2168.                     // $log->save($user, [
  2169.                     //     'owner' => $appraisal->getUser(),
  2170.                     //     'message' => 'log.appraisal.review',
  2171.                     //     'old_data' => $oldData,
  2172.                     //     'new_data' => $newData
  2173.                     // ]);
  2174.                 } else {
  2175.                     $log->save($user, [
  2176.                         'owner' => $appraisal->getUser(),
  2177.                         'message' => 'log.appraisal.draft',
  2178.                         'old_data' => $oldData,
  2179.                         'new_data' => $newData
  2180.                     ]);
  2181.                     $this->addFlash(
  2182.                         'success',
  2183.                         'messages.appraisal.draft'
  2184.                     );
  2185.                 }
  2187.                 return $this->redirect($request->getUri());
  2188.             };
  2190.             return $this->render('private/appraisal/appraisal.html.twig', [
  2191.                 'appraisal' => $appraisal,
  2192.                 'assessments' => $assessments,
  2193.                 'categorizedAssessments' => $categorizedAssessments,
  2194.                 'appraisalNotes' => $appraisalNotes,
  2195.                 'appraisalNoteForm' => $appraisalNoteForm->createView()
  2196.                 //'formComments' => $formComments
  2197.                 //'form' => $form->createView()
  2198.             ]);
  2199.         } else {
  2200.             throw new \Exception($translator->trans('messages.security.forbidden'));
  2201.             //throw $this->createNotFoundException($translator->trans('messages.error.not_found'));
  2202.         }
  2203.     }
  2204.     #[Route(path: '/ajax/save-appraisal', name: 'ajax_save_appraisal')]
  2205.     public function saveAppraisal(Request $request, TranslatorInterface $translator, SerializerInterface $serializer): JsonResponse
  2206.     {
  2207.         /*if (!$this->isGranted('ROLE_STAFF')) {
  2208.             return new JsonResponse([
  2209.                 'status' => "TIMEOUT",
  2210.             ]);
  2211.         }*/
  2213.         $_id = $request->request->get('appraisalId');
  2214.         $user = $this->getUser();
  2216.         $appraisal =  $this->getDoctrine()->getRepository(Appraisal::class)->find($_id);
  2218.         if ($appraisal == null) {
  2219.             return $this->redirectToRoute('user_profile', ['g' => 'appraisal']);
  2220.         };
  2222.         $oldData = [];
  2223.         $newData = [];
  2224.         $userNote = null;
  2225.         $appraisalNotes = null;
  2226.         $userAppraisalNote = new AppraisalNote();
  2228.         if ($appraisal->getAppraisalNotes() != null and count($appraisal->getAppraisalNotes()) > 0) {
  2229.             $appraisalNotes = $this->getDoctrine()->getRepository(AppraisalNote::class)->findByAppraisal($appraisal);
  2230.             $userNote = $this->getDoctrine()->getRepository(AppraisalNote::class)->findByAppraisalByUser($appraisal, $user);
  2231.             if ($userNote != null) {
  2232.                 $userAppraisalNote = $userNote;
  2233.             }
  2234.         };
  2235.         $oldUserNote = is_object($userNote) ? clone $userNote : null;
  2236.         $appraisalNoteForm = $this->createForm(AppraisalNoteType::class, $userAppraisalNote);
  2238.         $result['status'] = 'OK';
  2240.         if ($this->isGranted('ROLE_HR') || $appraisal->getUser() == $user || $appraisal->getUser()->getIsIncludedManager($user)) {
  2241.             if ($_SERVER['APP_ENV'] == "prod" && $appraisal->getUser()->inProbation() && $appraisal->getSubmitAt()->format('Ymd') < '20221001') {
  2242.                 $assessments = $this->getDoctrine()->getRepository(AppraisalForm::class)->findByCODA($appraisal->getUser()->assignedCompany(), $appraisal->getUser()->getOffice(), $appraisal->getUser()->organizationDepartments(), $appraisal);
  2243.             } else {
  2244.                 $assessments = $this->getDoctrine()->getRepository(AppraisalForm::class)->findByType($appraisal->getUser()->assignedCompany(), $appraisal->getUser()->appraisalType($appraisal), $appraisal);
  2245.             }
  2246.             if ($request->isMethod('post')) {
  2247.                 $entityManager = $this->getDoctrine()->getManager();
  2248.                 if (!$appraisal->hasReviewed($user)) {
  2249.                     foreach ($assessments as $assessment) {
  2250.                         $comment = $assessment->appraisalCommentsByOwner($_id, $user->getId());
  2251.                         if ($comment != null) {
  2252.                             $_comment = clone $comment;
  2253.                             array_push($oldData, $_comment);
  2254.                             if ($request->request->get('score-' . $assessment->getId()) != null) $comment->setScore($request->request->get('score-' . $assessment->getId()));
  2255.                             if ($request->request->get('comment-' . $assessment->getId()) != null) $comment->setComment($request->request->get('comment-' . $assessment->getId()));
  2256.                             $comment->setDraft($request->request->get('draft') == "false" ? false : true);
  2257.                             $comment->setUpdatedAt(new \DateTime());
  2258.                             if ($user == $appraisal->getUser())
  2259.                                 $comment->setFormContent($serializer->serialize($serializer->normalize($assessment, null, ['groups' => 'Appraisal']), 'json'));
  2260.                         } else {
  2261.                             $comment = new AppraisalComment();
  2262.                             if ($request->request->get('score-' . $assessment->getId()) != null) $comment->setScore($request->request->get('score-' . $assessment->getId()));
  2263.                             if ($request->request->get('comment-' . $assessment->getId()) != null) $comment->setComment($request->request->get('comment-' . $assessment->getId()));
  2264.                             $comment->setForm($assessment);
  2265.                             $comment->setAppraisal($appraisal);
  2266.                             $comment->setDraft($request->request->get('draft') == "false" ? false : true);
  2267.                             $comment->setCreatedAt(new \DateTime());
  2268.                             if ($user == $appraisal->getUser()) {
  2269.                                 $comment->setUser($appraisal->getUser());
  2270.                                 $comment->setType('submit');
  2271.                             } else {
  2272.                                 $comment->setUser($user);
  2273.                                 $comment->setType('review');
  2274.                             };
  2276.                             if ($user == $appraisal->getUser())
  2277.                                 $comment->setFormContent($serializer->serialize($serializer->normalize($assessment, null, ['groups' => 'Appraisal']), 'json'));
  2279.                             $entityManager->persist($comment);
  2280.                             //$oldData = null;
  2281.                         }
  2283.                         array_push($newData, $comment);
  2284.                     }
  2285.                 }
  2287.                 if ($user != $appraisal->getUser()) {
  2288.                     $requestNote = $request->request->get('appraisal_note');
  2289.                    
  2290.                     if ($requestNote != '') {
  2291.                         $userAppraisalNote->setNote($requestNote['note']);
  2292.                         $userAppraisalNote->setDraft($request->request->get('draft') == "false" ? false : true);
  2293.                         if ($userNote == null) {
  2294.                             $userAppraisalNote->setAppraisal($appraisal);
  2295.                             $userAppraisalNote->setUser($user);
  2296.                             $userAppraisalNote->setCreatedAt(new \DateTime());
  2297.                             $entityManager->persist($userAppraisalNote);
  2298.                         } else {
  2299.                             $userAppraisalNote->setUpdatedAt(new \DateTime());
  2300.                         }
  2301.                     };
  2302.                 };
  2303.             }
  2304.             $entityManager->flush();
  2305.         } else {
  2306.             $result['status'] = 'ERROR';
  2307.         }
  2309.         return new JsonResponse($result);
  2310.     }
  2312.     #[Route(path: '/ajax/save-appraisal-field', name: 'ajax_save_appraisal_field')]
  2313.     public function saveAppraisalField(Request $request, TranslatorInterface $translator, SerializerInterface $serializer): JsonResponse
  2314.     {
  2315.         /*if (!$this->isGranted('ROLE_STAFF')) {
  2316.             return new JsonResponse([
  2317.                 'status' => "TIMEOUT",
  2318.             ]);
  2319.         }*/
  2321.         $appraisalId = $request->request->get('appraisalId');
  2322.         $appraisalCommentValue = $request->request->get('comment');
  2323.         $appraisalScoreValue = $request->request->get('score');
  2324.         $formId = $request->request->get('formId');
  2326.         if($appraisalId == null || $formId == null){
  2327.             return new JsonResponse([
  2328.                 'status' => "ID Missing",
  2329.             ]);
  2330.         }
  2332.         $user = $this->getUser();
  2334.         $appraisal = $this->getDoctrine()->getRepository(Appraisal::class)->find($appraisalId);
  2335.         $appraisalForm = $this->getDoctrine()->getRepository(AppraisalForm::class)->find($formId);
  2336.         $appraisalComment = $this->getDoctrine()->getRepository(AppraisalComment::class)->findByAppraisalForm($appraisalId, $formId, $user);
  2337.         
  2339.         if($appraisalComment == null){
  2340.             $appraisalComment = new AppraisalComment();
  2341.         };
  2343.         $result['status'] = 'OK';
  2345.         if ($appraisalId && ($this->isGranted('ROLE_HR') || $appraisal->getUser() == $user || $appraisal->getUser()->getIsIncludedManager($user))) {
  2346.            
  2347.             $entityManager = $this->getDoctrine()->getManager(); 
  2348.            
  2349.             if($appraisalScoreValue) $appraisalComment->setScore($appraisalScoreValue);
  2350.             if($appraisalCommentValue) $appraisalComment->setComment($appraisalCommentValue);
  2351.             $appraisalComment->setFormContent($serializer->serialize($serializer->normalize($appraisalForm, null, ['groups' => 'Appraisal']), 'json'));
  2352.             
  2353.             if($appraisalComment->getId() == null){
  2354.                 if ($user == $appraisal->getUser()) {
  2355.                     $appraisalComment->setUser($appraisal->getUser());
  2356.                     $appraisalComment->setType('submit');
  2357.                 } else {
  2358.                     $appraisalComment->setUser($user);
  2359.                     $appraisalComment->setType('review');
  2360.                 };
  2361.                 $appraisalComment->setAppraisal($appraisal);
  2362.                 $appraisalComment->setForm($appraisalForm);
  2363.                 $appraisalComment->setDraft(true);
  2364.                 $appraisalComment->setCreatedAt(new \DateTime());
  2365.                 $entityManager->persist($appraisalComment);
  2366.             } else {
  2367.                 $appraisalComment->setUpdatedAt(new \DateTime());
  2368.             }
  2369.             
  2370.             $entityManager->flush();
  2372.             if($appraisalComment->getDraft() == false && $appraisalScoreValue){
  2373.                 $result['questionScore'] = $appraisal->appraisalQuestionScore($appraisalComment);
  2374.                 $result['appraisalScore'] = $appraisal->appraisalScore();
  2375.             }
  2376.         } else {
  2377.             $result['status'] = 'ERROR';
  2378.         }
  2380.         return new JsonResponse($result);
  2381.     }
  2383.     #[Route(path: '/ajax/add-appraisal', name: 'ajax_add_appraisal')]
  2384.     public function ajaxAddAppraisal(Request $request, TranslatorInterface $translator): JsonResponse
  2385.     {
  2386.         $user = $this->getUser();
  2387.         $appraisal = new AppraisalForm();
  2388.         $form = $this->createForm(AppraisalType::class, $appraisal);
  2390.         if ($this->isGranted('ROLE_ACCESS_ALL_OFFICE')) {
  2391.             $office_choices['form.office.all'] = null;
  2392.             foreach ($user->assignedOffices() as $office) {
  2393.                 $office_choices[$office->getFullName()] = $office->getId();
  2394.             };
  2395.             $form->add('office',  ChoiceType::class, [
  2396.                 'mapped' => false,
  2397.                 'label' => 'Office',
  2398.                 'choices' => $office_choices,
  2399.                 'placeholder' => 'form.placeholder.choice'
  2400.             ]);
  2401.         };
  2403.         $department_choices['form.department.all'] = null;
  2404.         foreach ($user->assignedCompany()->getDepartments() as $department) {
  2405.             $department_choices[$department->getName()] = $department->getId();
  2406.         };
  2407.         $form->add('department',  ChoiceType::class, [
  2408.             'mapped' => false,
  2409.             'label' => 'Department',
  2410.             'choices' => $department_choices,
  2411.             'placeholder' => 'form.placeholder.choice'
  2412.         ]);
  2414.         $form->handleRequest($request);
  2416.         $result['status'] = 'OK';
  2418.         if ($form->isSubmitted() && !$form->isValid() && $result['status'] == 'OK') {
  2419.             $result['status'] = 'ERROR';
  2420.             foreach ($form->getErrors(true) as $key => $error) {
  2421.                 $result['message'][$key] = $error->getMessage();
  2422.             }
  2423.         };
  2425.         if ($result['status'] == 'OK') {
  2426.             $appraisal->setCreatedBy($user);
  2427.             $appraisal->setCreatedAt(new \DateTime());
  2428.             $appraisal->setCompany($user->assignedCompany());
  2429.             if ($this->isGranted('ROLE_ACCESS_ALL_OFFICE')) {
  2430.                 if ($form->get('office')->getData() != null) {
  2431.                     $office = $this->getDoctrine()->getRepository(Office::class)->find($form->get('office')->getData());
  2432.                     $appraisal->setOffice($office);
  2433.                 } else {
  2434.                     $appraisal->setOffice(null);
  2435.                 }
  2436.             } else {
  2437.                 $appraisal->setOffice($user->getOffice());
  2438.             }
  2439.             if ($form->get('department')->getData() != null) {
  2440.                 $department = $this->getDoctrine()->getRepository(Department::class)->find($form->get('department')->getData());
  2441.                 $appraisal->setDepartment($department);
  2442.             } else {
  2443.                 $appraisal->setDepartment(null);
  2444.             }
  2445.             $entityManager = $this->getDoctrine()->getManager();
  2446.             $entityManager->persist($appraisal);
  2447.             $entityManager->flush();
  2449.             $result['content'] = $this->renderView('private/appraisal/components/edit-appraisal-list.html.twig', [
  2450.                 'appraisal' => $appraisal,
  2451.                 'waitForPage' => false
  2452.             ]);
  2453.         };
  2455.         return new JsonResponse($result);
  2456.     }
  2458.     #[Route(path: '/ajax/edit-appraisal', name: 'ajax_edit_appraisal')]
  2459.     public function ajaxEditAppraisal(Request $request, TranslatorInterface $translator): \Symfony\Component\HttpFoundation\Response
  2460.     {
  2461.         $user = $this->getUser();
  2463.         $appraisal = $this->getDoctrine()->getRepository(AppraisalForm::class)->find($request->get("id"));
  2464.         $formAppraisal = $this->createForm(AppraisalType::class, $appraisal);
  2466.         if ($this->isGranted('ROLE_ACCESS_ALL_OFFICE')) {
  2467.             $office_choices['form.office.all'] = null;
  2468.             foreach ($user->assignedOffices() as $office) {
  2469.                 $office_choices[$office->getFullName()] = $office->getId();
  2470.             };
  2471.             $formAppraisal->add('office',  ChoiceType::class, [
  2472.                 'mapped' => false,
  2473.                 'label' => 'Office',
  2474.                 'choices' => $office_choices,
  2475.                 'placeholder' => 'form.placeholder.choice',
  2476.                 'data' => $appraisal->getOffice() ? $appraisal->getOffice()->getId() : null,
  2477.             ]);
  2478.         };
  2480.         $department_choices['form.department.all'] = null;
  2481.         foreach ($user->assignedCompany()->getDepartments() as $department) {
  2482.             $department_choices[$department->getName()] = $department->getId();
  2483.         };
  2484.         $formAppraisal->add('department',  ChoiceType::class, [
  2485.             'mapped' => false,
  2486.             'label' => 'Department',
  2487.             'choices' => $department_choices,
  2488.             'placeholder' => 'form.placeholder.choice',
  2489.             'data' => $appraisal->getDepartment() ? $appraisal->getDepartment()->getId() : null,
  2490.         ]);
  2492.         return $this->render('private/appraisal/components/form-appraisal.html.twig', [
  2493.             'dataId' => $appraisal->getId(),
  2494.             'formAppraisal' => $formAppraisal->createView()
  2495.         ]);
  2496.     }
  2498.     #[Route(path: '/ajax/update-appraisal', name: 'ajax_update_appraisal', methods: 'POST')]
  2499.     function ajaxUpdateAppraisal(Request $request, TranslatorInterface $translator)
  2500.     {
  2501.         $user = $this->getUser();
  2502.         $appraisal = $this->getDoctrine()->getRepository(AppraisalForm::class)->find($request->get("dataId"));
  2503.         $result['status'] = 'OK';
  2505.         if ($appraisal != null) {
  2506.             // if ($user->assignedCompany() != $appraisal->getCompany() || !$this->isGranted('ROLE_HR')) {
  2507.             //     $result['status'] = 'ERROR';
  2508.             //     $result['message'] = $translator->trans('messages.security.forbidden');
  2509.             // };
  2511.             $form = $this->createForm(AppraisalType::class, $appraisal);
  2513.             if ($this->isGranted('ROLE_ACCESS_ALL_OFFICE')) {
  2514.                 $office_choices['form.office.all'] = null;
  2515.                 foreach ($user->assignedOffices() as $office) {
  2516.                     $office_choices[$office->getFullName()] = $office->getId();
  2517.                 };
  2518.                 $form->add('office',  ChoiceType::class, [
  2519.                     'mapped' => false,
  2520.                     'label' => 'Office',
  2521.                     'choices' => $office_choices,
  2522.                     'placeholder' => 'form.placeholder.choice'
  2523.                 ]);
  2524.             };
  2526.             $department_choices['form.department.all'] = null;
  2527.             foreach ($user->assignedCompany()->getDepartments() as $department) {
  2528.                 $department_choices[$department->getName()] = $department->getId();
  2529.             };
  2530.             $form->add('department',  ChoiceType::class, [
  2531.                 'mapped' => false,
  2532.                 'label' => 'Department',
  2533.                 'choices' => $department_choices,
  2534.                 'placeholder' => 'form.placeholder.choice'
  2535.             ]);
  2537.             $form->handleRequest($request);
  2539.             if ($form->isSubmitted() && !$form->isValid() && $result['status'] == 'OK') {
  2540.                 $result['status'] = 'ERROR';
  2541.                 foreach ($form->getErrors(true) as $key => $error) {
  2542.                     $result['message'][$key] = $error->getMessage();
  2543.                 }
  2544.             };
  2546.             if ($result['status'] == 'OK') {
  2547.                 if ($this->isGranted('ROLE_ACCESS_ALL_OFFICE')) {
  2548.                     if ($form->get('office')->getData() != null) {
  2549.                         $office = $this->getDoctrine()->getRepository(Office::class)->find($form->get('office')->getData());
  2550.                         $appraisal->setOffice($office);
  2551.                     } else {
  2552.                         $appraisal->setOffice(null);
  2553.                     }
  2554.                 } else {
  2555.                     $appraisal->setOffice($user->getOffice());
  2556.                 }
  2557.                 if ($form->get('department')->getData() != null) {
  2558.                     $department = $this->getDoctrine()->getRepository(Department::class)->find($form->get('department')->getData());
  2559.                     $appraisal->setDepartment($department);
  2560.                 } else {
  2561.                     $appraisal->setDepartment(null);
  2562.                 }
  2563.                 $entityManager = $this->getDoctrine()->getManager();
  2564.                 $entityManager->flush();
  2565.                 $result['id'] = $appraisal->getId();
  2566.                 $result['content'] = $this->renderView('private/appraisal/components/edit-appraisal-list.html.twig', [
  2567.                     'appraisal' => $appraisal,
  2568.                     'waitForPage' => false
  2569.                 ]);
  2570.                 $result['update'] = true;
  2571.             }
  2572.         } else {
  2573.             $result['status'] = 'ERROR';
  2574.             $result['message'] = $translator->trans('messages.request.missing');
  2575.         }
  2576.         return new JsonResponse($result);
  2577.     }
  2579.     #[Route(path: '/ajax/delete-appraisal', name: 'ajax_delete_appraisal', methods: 'POST')]
  2580.     function ajaxDeleteAppraisal(Request $request, TranslatorInterface $translator): JsonResponse
  2581.     {
  2582.         $user = $this->getUser();
  2583.         $appraisal =  $this->getDoctrine()->getRepository(AppraisalForm::class)->find($request->get("id"));
  2585.         $result['status'] = 'OK';
  2587.         if ($appraisal != null) {
  2588.             // if ($user->assignedCompany() != $appraisal->getCompany() || !$this->isGranted('ROLE_HR')) {
  2589.             //     $result['status'] = 'ERROR';
  2590.             //     $result['message'] = $translator->trans('messages.security.forbidden');
  2591.             // };
  2593.             if ($result['status'] == 'OK') {
  2594.                 $entityManager = $this->getDoctrine()->getManager();
  2595.                 // The keep consistenty, the form will not be actually deleted if got some comments
  2596.                 if (count($appraisal->getAppraisalComments()) > 0) {
  2597.                     $appraisal->setIsHidden(true);
  2598.                 } else {
  2599.                     $entityManager->remove($appraisal);
  2600.                 }
  2601.                 $entityManager->remove($appraisal);
  2602.                 $entityManager->flush();
  2603.             }
  2604.         } else {
  2605.             $result['status'] = 'ERROR';
  2606.             $result['message'] = $translator->trans('messages.request.missing');
  2607.         }
  2608.         return new JsonResponse($result);
  2609.     }
  2611.     #[Route(path: '/download/ics/appraisal/{token}.ics', name: 'download_ics_appraisal')]
  2612.     public function downloadAppraisalICS(Request $request, TranslatorInterface $translator, ICSService $ics)
  2613.     {
  2614.         $user = $this->getUser();
  2615.         $appraisal = $this->getDoctrine()->getRepository(Appraisal::class)->findByToken($request->get("token"));
  2616.         if ($appraisal != null) {
  2617.             return $ics->generateEventFile([[
  2618.                 'title' => $translator->trans('ics.appraisal.title') . ' ' . $appraisal->getTitle(),
  2619.                 'description' => $translator->trans('ics.appraisal.description', ['%uid%' => $appraisal->getUser()->getId(), '%user%' => strtolower($appraisal->getUser()->getPersonalInfo()->getFirstName()), '%link%' => $this->generateUrl('user_profile', array(), UrlGeneratorInterface::ABSOLUTE_URL) . '/' . $appraisal->getUser()->getEmail() . '?g=appraisal&open=appraisal-' . $appraisal->getId()]),
  2620.                 'startDate' => $appraisal->getReviewAt()->format('Ymd'),
  2621.                 'startTime' => '090000',
  2622.                 'endDate' =>  $appraisal->getReviewAt()->format('Ymd'),
  2623.                 'endTime' => '180000',
  2624.                 'location' => 'HR Platfrom',
  2625.                 'reminderTime' => '-15M',
  2626.                 'reminderDescription' => $translator->trans('ics.appraisal.title') . ' ' . $appraisal->getTitle(),
  2627.                 'fileName' => 'Appraisal-' . $appraisal->getIcsToken()
  2628.             ]]);
  2629.         } else {
  2630.             throw $this->createNotFoundException($translator->trans('messages.error.not_found'));
  2631.         }
  2632.     }
  2634.     #[Route(path: '/appraisal-export/{_type}/{_target}', defaults: ['_target' => 'local', '_type' => 'excel'], name: 'appraisal_export')]
  2635.     public function exportAppraisal(string $_type, string $_target, Request $request, AppraisalService $appraisalService)
  2636.     {
  2637.         $appraisalId = $request->get('id') ?: null;
  2638.         if($_type == 'excel' || empty($_type) || $_type == 'google'){
  2639.             if($_type == 'google'){
  2640.                 $_target = $_type;
  2641.             }
  2642.             return $appraisalService->exportExcel($appraisalId, $_target);
  2643.         }elseif($_type == 'pdf'){
  2644.             return $appraisalService->exportPdf($appraisalId, $_target);
  2645.         }
  2646.     }
  2648.     #[Route(path: '/appraisal-report/{_target}', defaults: ['_target' => 'local'], name: 'report_appraisal')]
  2649.     public function reportAppraisal(string $_target, Request $request, TranslatorInterface $translator, LogService $log, GoogleDriveService $googleDriveService, AppraisalRepository $appraisalRepository, AppraisalNoteRepository $appraisalNoteRepository)
  2650.     {
  2651.         $appraisalYear = $request->get('year') ?: null;
  2652.         $type = $request->get('type');
  2653.         $department = $request->get('department') ?: null;
  2655.         $queries = $appraisalRepository->createQueryBuilder('a')
  2656.         ->leftJoin('a.user', 'u')
  2657.         ->leftJoin('u.department', 'dept')
  2658.         ->andWhere('u.isActive = :ia')->setParameter('ia', 1);
  2659.         // ->andWhere('a.user = :user')->setParameter('user', 128);
  2660.         if($department){
  2661.             $queries->andWhere('dept.id = :department')->setParameter('department', $department);
  2662.         }
  2664.         if ($type == 'probation') {
  2665.             if ($appraisalYear) {
  2666.                 if (strpos($appraisalYear, '-end') !== false) {
  2667.                     $year = str_replace('-end', '', $appraisalYear);
  2668.                 } elseif (strpos($appraisalYear, '-mid') !== false) {
  2669.                     $year = str_replace('-mid', '', $appraisalYear);
  2670.                 } else {
  2671.                     $year = $appraisalYear;
  2672.                 }
  2673.                 $queries->andWhere('YEAR(a.reviewAt) = :year')->setParameter('year', $year);
  2674.             }
  2676.             $queries->andWhere('LOWER(a.title) LIKE LOWER(:probation)')->setParameter('probation', '%probation%');
  2677.         } elseif ($type == 'permanent') {
  2678.             if (strpos($appraisalYear, '-end') !== false) {
  2679.                 $year = str_replace('-end', '', $appraisalYear);
  2680.                 $queries->andWhere('LOWER(a.title) LIKE LOWER(:yearEnd)')
  2681.                     ->setParameter('yearEnd', '%' . $year . '%end%');
  2682.             } elseif (strpos($appraisalYear, '-mid') !== false) {
  2683.                 $year = str_replace('-mid', '', $appraisalYear);
  2684.                 $queries->andWhere('LOWER(a.title) LIKE LOWER(:yearMid)')
  2685.                     ->setParameter('yearMid', '%' . $year . '%mid%');
  2686.             } else {
  2687.                 $queries->andWhere('LOWER(a.title) LIKE LOWER(:year)')
  2688.                     ->setParameter('year', '%' . $appraisalYear . '%');
  2689.             }
  2690.             $queries->andWhere('LOWER(a.title) NOT LIKE LOWER(:probation)')->setParameter('probation', '%probation%');
  2691.         }
  2693.         $appraisals = $queries->getQuery()->getResult();
  2695.         usort($appraisals, function($a, $b) {
  2696.             $scoreA = $a->appraisalScore();
  2697.             $scoreB = $b->appraisalScore();
  2698.             
  2699.             if ($scoreA === null && $scoreB === null) return 0;
  2700.             if ($scoreA === null) return 1;
  2701.             if ($scoreB === null) return -1;
  2702.         
  2703.             return $scoreB <=> $scoreA;
  2704.         });
  2706.         $user = null;
  2708.         $spreadsheet = new Spreadsheet();
  2709.         $summarySheet = $spreadsheet->getActiveSheet()->setTitle('Summary');
  2710.         $summarySheet->setCellValue('A1', 'Name');
  2711.         $summarySheet->setCellValue('B1', 'Department');
  2712.         $summarySheet->setCellValue('C1', 'Office');
  2713.         $summarySheet->setCellValue('D1', 'Job Title');
  2714.         // $summarySheet->setCellValue('E1', 'Appraisal Title');
  2715.         $summarySheet->setCellValue('E1', 'Supervised By');
  2716.         $summarySheet->setCellValue('F1', 'Reviewed At');
  2717.         $summarySheet->setCellValue('G1', 'Overall Rating');
  2719.         $lastCol = $summarySheet->getHighestColumn();
  2721.         $summarySheet->getDefaultColumnDimension()->setWidth(25);
  2722.         // $summarySheet->getColumnDimension('B')->setWidth(120);
  2723.         $summarySheet->getStyle("A1:".$lastCol."1")->getFont()->setBold(true);
  2724.         $summarySheet->getStyle("A1:".$lastCol."1")->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_WHITE);
  2725.         $summarySheet->getStyle("A1:".$lastCol."1")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('00000000');
  2726.         $summarySheet->getStyle("A2:".$lastCol."2")->getFont()->setBold(false);
  2727.         $summarySheet->getStyle("A2:".$lastCol."2")->getAlignment()->setWrapText(true);
  2728.         $summarySheet->getStyle("A2:".$lastCol."2")->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
  2730.         $filename = 'Appraisal-Report_';
  2732.         if ($appraisalYear) {
  2733.             if (strpos($appraisalYear, '-end') !== false) {
  2734.                 $filename .= str_replace('-end', '', $appraisalYear) . '-End-Year';
  2735.             } elseif (strpos($appraisalYear, '-mid') !== false) {
  2736.                 $filename .= str_replace('-mid', '', $appraisalYear) . '-Year-Mid';
  2737.             } else {
  2738.                 $filename .= $appraisalYear;
  2739.             }
  2740.         }
  2741.         // $filename .= $user ? "-" . urlencode($user->getPersonalInfo()->getFullName()) : "";
  2742.         // $filename .= '.xlsx';
  2743.         $filename .= "_" . date('Y-m-d') . '.xlsx';
  2745.         $row = $summarySheet->getHighestRow();
  2747.         foreach($appraisals as $appraisal){
  2748.             $user = $appraisal->getUser();
  2749.             $summarySheet->setCellValue('A'.$row, $user->getPersonalInfo()->getFullName());
  2750.             $summarySheet->setCellValue('B'.$row, $user->getDepartment()->getName());
  2751.             $summarySheet->setCellValue('C'.$row, $user->getOffice()->getFullName());
  2752.             $summarySheet->setCellValue('D'.$row, $user->organizationTitles());
  2753.             $managerArray = [];
  2754.             foreach ($user->getAllManager() as $manager) {
  2755.                 $managerArray[] = $manager->getPersonalInfo()->getFirstName();
  2756.             }
  2757.             // $summarySheet->setCellValue('E'.$row, $appraisal->getTitle());
  2758.             $summarySheet->setCellValue('E'.$row, implode(', ', $managerArray));
  2759.             $summarySheet->setCellValue('F'.$row, $appraisal->getReviewAt() ? $appraisal->getReviewAt()->format('d-M-Y') : '-');
  2760.             $summarySheet->setCellValue('G'.$row, $appraisal->appraisalScore() ?: '-');
  2761.             $summarySheet->getStyle('G'.$row)->getFont()->setBold(true);
  2762.             $row++;
  2763.         }
  2765.         $summarySheet->setAutoFilter('A1:'.$lastCol.$summarySheet->getHighestRow());
  2767.         $writer = new Xlsx($spreadsheet);
  2768.         $writer->save($filename);
  2770.         if ($_target == 'google') {
  2771.             $gsheetURL = $googleDriveService->uploadToGoogleDrive($filename);
  2772.             if ($gsheetURL) {
  2773.                 unlink($filename);
  2774.                 return new RedirectResponse($gsheetURL, 302);
  2775.             }
  2776.         } else {
  2777.             $response = new Response();
  2778.             $response->headers->set('Content-type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  2779.             $response->headers->set('Content-Disposition', sprintf('attachment; filename="%s"', $filename));
  2780.             $response->setContent(file_get_contents($filename));
  2781.             $response->setStatusCode(\Symfony\Component\HttpFoundation\Response::HTTP_OK);
  2782.             $response->headers->set('Content-Transfer-Encoding', 'binary');
  2783.             $response->headers->set('Pragma', 'no-cache');
  2784.             $response->headers->set('Expires', '0');
  2785.             unlink($filename);
  2786.             return $response;
  2787.             exit;
  2788.         }
  2789.     }
  2792. }