src/Service/Widget/Handlers/AppraisalAssessmentCyclesWidget.php line 16

Open in your IDE?
  1. <?php
  3. namespace App\Service\Widget\Handlers;
  5. use App\DataExport\AppraisalSummaryWorksheetFactory;
  6. use App\DataExport\AppraisalWorksheetFactory;
  7. use App\Entity\Appraisal;
  8. use App\Entity\User;
  9. use App\Entity\Widget;
  10. use App\Enum\Status;
  11. use App\Exception\ValidationException;
  12. use Doctrine\ORM\EntityManagerInterface;
  13. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  14. use Symfony\Component\Security\Core\User\UserInterface;
  16. class AppraisalAssessmentCyclesWidget extends AssessmentCyclesWidget
  17. {
  18.     private $worksheetFactory;
  20.     public function __construct(
  21.         EntityManagerInterface $em,
  22.         AppraisalWorksheetFactory $appraisalWorksheet,
  23.         AppraisalSummaryWorksheetFactory $appraisalSummaryWorksheet
  24.     )
  25.     {
  26.         $this->worksheetFactory = $appraisalWorksheet;
  27.         parent::__construct($em, $appraisalSummaryWorksheet, $appraisalWorksheet);
  28.     }
  30.     private function getAppraisals(Widget $widget)
  31.     {
  32.         $config = $widget->getConfigKeyValuePairs();
  33.         $appraisalCycleId = $this->getSourceId($config['source']);
  35.         return $this->em->getRepository(Appraisal::class)
  36.             ->findByCycleAndUsers($appraisalCycleId, $this->users);
  37.     }
  39.     public function getData(Widget $widget, User $user, bool $export = false, $dataset = null)
  40.     {
  41.         $config = $widget->getConfigKeyValuePairs();
  42.         $appraisalCycleId = $this->getSourceId($config['source']);
  44.         $data = [
  45.             'title' => $widget->getName(),
  46.             'completedCount' => 0,
  47.             'partiallyCompletedCount' => 0,
  48.             'notStartedCount' => 0
  49.         ];
  51.         if (empty($this->users)) {
  52.             return $data;
  53.         }
  55.         $completed = [];
  56.         $partiallyCompleted = [];
  57.         $notStarted = [];
  59.         foreach ($this->users as $user) {
  60.             $appraisal = $this->em->getRepository(Appraisal::class)->findOneBy([
  61.                 'cycle' => $appraisalCycleId,
  62.                 'user' => $user
  63.             ]);
  65.             if (!$appraisal) {
  66.                 $notStarted[] = $user;
  67.             } else {
  68.                 // @todo remove this widget once Aura-1157 has been deployed to Marcura
  69.                 $assessmentCycle = $appraisal->getFirstAssessmentCycle();
  71.                 if ($assessmentCycle->getStatus() === Status::INT_COMPLETE) {
  72.                     $completed[] = $assessmentCycle;
  73.                 } elseif ($assessmentCycle->getAssessments()->exists(function ($k, $a) {
  74.                     return $a->getTimeCompleted();
  75.                 })) {
  76.                     $partiallyCompleted[] = $assessmentCycle;
  77.                 } else {
  78.                     $notStarted[] = $user;
  79.                 }
  80.             }
  81.         }
  83.         if ($export) {
  84.             switch ($dataset) {
  85.                 case "completed":
  86.                     return $this->getAssessmentTableData($completed);
  87.                 case "partially_completed":
  88.                     return $this->getAssessmentTableData($partiallyCompleted);
  89.                 case "not_started":
  90.                     return $this->getNotStartedAssessmentTableData($notStarted);
  91.                 default:
  92.                     throw new ValidationException("Unknown dataset selected");
  93.             }
  94.         }
  96.         $denominator = sizeof($this->users);
  97.         $data['completedCount'] = (int) number_format((sizeof($completed) / $denominator) * 100);
  98.         $data['partiallyCompletedCount'] = (int) number_format((sizeof($partiallyCompleted) / $denominator) * 100);
  99.         $data['notStartedCount'] = (int) number_format((sizeof($notStarted) / $denominator) * 100);
  101.         return $data;
  102.     }
  104.     public function export(Widget $widget, UserInterface $user)
  105.     {
  106.         $appraisals = $this->getAppraisals($widget);
  108.         $spreadSheet = new Spreadsheet();
  109.         $spreadSheet->removeSheetByIndex(0);
  110.         $spreadSheet->addSheet($this->worksheetFactory->make($appraisals, $spreadSheet));
  112.         $filename = $this->getFilename($widget);
  114.         return $this->download($spreadSheet, $filename);
  115.     }
  116. }