Proyectos de Subversion LeadersLinked - Backend

<?php

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;
use Laminas\Cache\Storage\Adapter\AbstractAdapter;
use Laminas\Mvc\Controller\AbstractActionController;
use Laminas\Log\LoggerInterface;
use Laminas\View\Model\ViewModel;
use Laminas\View\Model\JsonModel;
use LeadersLinked\Library\Functions;
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
use LeadersLinked\Mapper\CompanyMapper;
use LeadersLinked\Mapper\DailyPulseEmojiMapper;
use LeadersLinked\Form\DailyPulse\DailyPulseAddEmojiForm;
use LeadersLinked\Form\DailyPulse\DailyPulseEditEmojiForm;
use LeadersLinked\Model\DailyPulseEmoji;
use LeadersLinked\Library\Image;
use LeadersLinked\Mapper\DailyPulseRecordMapper;
use LeadersLinked\Model\DailyPulseRecord;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

class DailyPulseReportsController extends AbstractActionController
{
    /**
     *
     * @var AdapterInterface
     */
    private $adapter;


    /**
     *
     * @var AbstractAdapter
     */
    private $cache;

    /**
     *
     * @var  LoggerInterface
     */
    private $logger;


    /**
     *
     * @var array
     */
    private $config;

    /**
     *
     * @param AdapterInterface $adapter
     * @param AbstractAdapter $cache
     * @param LoggerInterface $logger
     * @param array $config
     */
    public function __construct($adapter, $cache, $logger, $config)
    {
        $this->adapter      = $adapter;
        $this->cache        = $cache;
        $this->logger       = $logger;
        $this->config       = $config;
    }

    public function indexAction()
    {
        return new JsonModel([
            'success' => false,
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
        ]);
    }

    public function overviewAction()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();

        $currentNetworkPlugin = $this->plugin('currentNetworkPlugin');
        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $companyMapper = CompanyMapper::getInstance($this->adapter);
        $company = $companyMapper->fetchDefaultForNetworkByNetworkId($currentNetwork->id);

        $request = $this->getRequest();
        if ($request->isGet()) {

            $headers  = $request->getHeaders();

            $isJson = false;
            if ($headers->has('Accept')) {
                $accept = $headers->get('Accept');

                $prioritized = $accept->getPrioritized();

                foreach ($prioritized as $key => $value) {
                    $raw = trim($value->getRaw());

                    if (!$isJson) {
                        $isJson = strpos($raw, 'json');
                    }
                }
            }


            if ($isJson) {

                $startDate = $this->params()->fromQuery('startDate');
                if (empty($startDate)) {
                    $startDate = date('Y-m-d');
                }


                $endDate = $this->params()->fromQuery('endDate');
                if (empty($endDate)) {
                    $endDate = date('Y-m-d');
                }

                $dtStartDate = \DateTime::createFromFormat('Y-n-d', $startDate);
                $dtEndDate = \DateTime::createFromFormat('Y-n-d', $endDate);

                if (!$dtStartDate || !$dtEndDate) {
                    $startDate = date('Y-m-d');
                    $endDate = date('Y-m-d');
                } else {

                    if ($dtStartDate->getTimestamp() > $dtEndDate->getTimestamp()) {
                        $startDate = date('Y-m-d');
                        $endDate = date('Y-m-d');
                    }
                }

                $dailyPulseRecordMapper = DailyPulseRecordMapper::getInstance($this->adapter);
                $how_are_you_feel = $dailyPulseRecordMapper->fetchAllDataChartOrExcelByCompanyIdAndTypeAndDateRange($company->id, DailyPulseRecord::TYPE_HOW_ARE_YOU_FEEL, $startDate, $endDate);

                $climate_on_your_organization = $dailyPulseRecordMapper->fetchAllDataChartOrExcelByCompanyIdAndTypeAndDateRange($company->id, DailyPulseRecord::TYPE_CLIMATE_ON_YOUR_ORGANIZATION, $startDate, $endDate);



                $data = [
                    'labels'             => [],
                    'users' => [
                        'how_are_you_feel' => [],
                        'climate_on_your_organization' => [],
                    ],
                    'points' => [
                        'how_are_you_feel' => [],
                        'climate_on_your_organization' => [],
                    ],
                    'average' => [
                        'how_are_you_feel' => [],
                        'climate_on_your_organization' => [],
                    ],
                    'how_are_you_feel' => [
                        'average_points'     => 0,
                        'average_users'      => 0,
                    ],
                    'climate_on_your_organization' => [
                        'average_points'    => 0,
                        'average_users'     => 0,
                    ]


                ];



                $how_are_you_feel_points = 0;
                $how_are_you_feel_users = 0;

                $climate_on_your_organization_points = 0;
                $climate_on_your_organization_users = 0;

                $count = 0;


                $dt = \DateTime::createFromFormat('Y-m-d', $startDate);
                do {
                    $count++;
                    $date = $dt->format('Y-m-d');
                    $label = $dt->format('d/m/Y');

                    array_push($data['labels'], $label);


                    $points = 0;
                    $users = 0;
                    foreach ($how_are_you_feel as $record) {
                        if ($date == $record['date']) {
                            $points = $record['points'];
                            $users = $record['users'];
                        }
                    }



                    array_push($data['points']['how_are_you_feel'], $points);
                    array_push($data['users']['how_are_you_feel'], $users);
                    array_push($data['average']['how_are_you_feel'], $users ?  $points / $users : 0);


                    $how_are_you_feel_points += $points;
                    $how_are_you_feel_users += $users;

                    $points = 0;
                    $users = 0;
                    foreach ($climate_on_your_organization as $record) {
                        if ($date == $record['date']) {
                            $points = $record['points'];
                            $users = $record['users'];
                        }
                    }


                    array_push($data['points']['climate_on_your_organization'], $points);
                    array_push($data['users']['climate_on_your_organization'], $users);
                    array_push($data['average']['climate_on_your_organization'], $users ?  $points / $users : 0);


                    $climate_on_your_organization_points += $points;
                    $climate_on_your_organization_users += $users;


                    $dt->add(new \DateInterval('P1D'));
                } while ($date < $endDate);




                $data['how_are_you_feel']['average_points'] =  number_format($how_are_you_feel_points / $count, 2);
                $data['how_are_you_feel']['average_users'] = number_format($how_are_you_feel_users / $count, 2);

                $data['climate_on_your_organization']['average_points'] = number_format($climate_on_your_organization_points / $count, 2);
                $data['climate_on_your_organization']['average_users'] = number_format($climate_on_your_organization_users / $count, 2);





                return new JsonModel([
                    'success' => true,
                    'data' => $data,
                ]);
            } else {
                $this->layout()->setTemplate('layout/layout-backend');
                $viewModel = new ViewModel();
                $viewModel->setTemplate('leaders-linked/daily-pulse-reports/overview.phtml');
                return $viewModel;
            }
        } else {


            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }
    }

    public function overviewDownloadAction()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();

        $currentNetworkPlugin = $this->plugin('currentNetworkPlugin');
        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $companyMapper = CompanyMapper::getInstance($this->adapter);
        $company = $companyMapper->fetchDefaultForNetworkByNetworkId($currentNetwork->id);

        $request = $this->getRequest();

        if ($request->isGet()) {

            $startDate = $this->params()->fromQuery('startDate');
            if (empty($startDate)) {
                $startDate = date('Y-m-d');
            }


            $endDate = $this->params()->fromQuery('endDate');
            if (empty($startDate)) {
                $endDate = date('Y-m-d');
            }

            //$startDate = '2023-03-01';
            //$endDate = '2023-03-19';

            $dtStartDate = \DateTime::createFromFormat('Y-n-d', $startDate);
            $dtEndDate = \DateTime::createFromFormat('Y-n-d', $endDate);

            if (!$dtStartDate || !$dtEndDate) {
                $startDate = date('Y-m-d');
                $endDate = date('Y-m-d');
            } else {

                if ($dtStartDate->getTimestamp() > $dtEndDate->getTimestamp()) {
                    $startDate = date('Y-m-d');
                    $endDate = date('Y-m-d');
                }
            }

            $dailyPulseRecordMapper = DailyPulseRecordMapper::getInstance($this->adapter);
            $how_are_you_feel = $dailyPulseRecordMapper->fetchAllDataChartOrExcelByCompanyIdAndTypeAndDateRange($company->id, DailyPulseRecord::TYPE_HOW_ARE_YOU_FEEL, $startDate, $endDate);

            $climate_on_your_organization = $dailyPulseRecordMapper->fetchAllDataChartOrExcelByCompanyIdAndTypeAndDateRange($company->id, DailyPulseRecord::TYPE_CLIMATE_ON_YOUR_ORGANIZATION, $startDate, $endDate);



            $data = [
                'labels'             => [],
                'average' => [
                    'how_are_you_feel' => [],
                    'climate_on_your_organization' => [],
                ],
                'users' => [
                    'how_are_you_feel' => [],
                    'climate_on_your_organization' => [],
                ],
                'points' => [
                    'how_are_you_feel' => [],
                    'climate_on_your_organization' => [],
                ],
                'how_are_you_feel' => [
                    'average_points'     => 0,
                    'average_users'      => 0,
                ],
                'climate_on_your_organization' => [
                    'average_points'    => 0,
                    'average_users'     => 0,
                ]


            ];



            $how_are_you_feel_points = 0;
            $how_are_you_feel_users = 0;

            $climate_on_your_organization_points = 0;
            $climate_on_your_organization_users = 0;

            $count = 0;


            $dt = \DateTime::createFromFormat('Y-m-d', $startDate);
            do {
                $count++;
                $date = $dt->format('Y-m-d');
                $label = $dt->format('d/m/Y');

                array_push($data['labels'], $label);


                $points = 0;
                $users = 0;
                foreach ($how_are_you_feel as $record) {
                    if ($date == $record['date']) {
                        $points = $record['points'];
                        $users = $record['users'];
                    }
                }



                array_push($data['points']['how_are_you_feel'], $points);
                array_push($data['users']['how_are_you_feel'], $users);
                array_push($data['average']['how_are_you_feel'], $users ?  $points / $users : 0);


                $how_are_you_feel_points += $points;
                $how_are_you_feel_users += $users;

                $points = 0;
                $users = 0;
                foreach ($climate_on_your_organization as $record) {
                    if ($date == $record['date']) {
                        $points = $record['points'];
                        $users = $record['users'];
                    }
                }


                array_push($data['points']['climate_on_your_organization'], $points);
                array_push($data['users']['climate_on_your_organization'], $users);
                array_push($data['average']['climate_on_your_organization'], $users ?  $points / $users : 0);


                $climate_on_your_organization_points += $points;
                $climate_on_your_organization_users += $users;


                $dt->add(new \DateInterval('P1D'));
            } while ($date < $endDate);

            $data['how_are_you_feel']['average_points'] =  number_format($how_are_you_feel_points / $count, 2);
            $data['how_are_you_feel']['average_users'] = number_format($how_are_you_feel_users / $count, 2);

            $data['climate_on_your_organization']['average_points'] = number_format($climate_on_your_organization_points / $count, 2);
            $data['climate_on_your_organization']['average_users'] = number_format($climate_on_your_organization_users / $count, 2);





            $spreadsheet = new Spreadsheet();
            $spreadsheet->getProperties()->setTitle('Pulso Diario');



            $spreadsheet->setActiveSheetIndex(0);
            $dt = \DateTime::createFromFormat('Y-m-d', $startDate);

            $spreadsheet->getActiveSheet()->SetCellValue('A1', 'Desde:');
            $spreadsheet->getActiveSheet()->SetCellValue('B1', $dt->format('d/m/Y'));


            $dt = \DateTime::createFromFormat('Y-m-d', $startDate);
            $spreadsheet->getActiveSheet()->SetCellValue('C1', 'Hasta:');
            $spreadsheet->getActiveSheet()->SetCellValue('D1', $dt->format('d/m/Y'));


            $spreadsheet->getActiveSheet()->SetCellValue('A3', 'Como te sientes hoy');
            $spreadsheet->getActiveSheet()->setMergeCells(['A3', 'B3', 'C3', 'D3']);
            $spreadsheet->getActiveSheet()->SetCellValue('A4', 'Puntos promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('B4',  $data['how_are_you_feel']['average_points']);
            $spreadsheet->getActiveSheet()->SetCellValue('C4', 'Usuarios promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('D4',  $data['how_are_you_feel']['average_users']);


            $spreadsheet->getActiveSheet()->SetCellValue('F3', 'Clima en su organización');
            $spreadsheet->getActiveSheet()->setMergeCells(['F3', 'G3', 'H3', 'I3']);
            $spreadsheet->getActiveSheet()->SetCellValue('F4', 'Puntos promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('G4',  $data['climate_on_your_organization']['average_points']);
            $spreadsheet->getActiveSheet()->SetCellValue('H4', 'Usuarios promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('I4',  $data['climate_on_your_organization']['average_users']);


            $spreadsheet->getActiveSheet()->SetCellValue('A6', 'Usuarios');
            $spreadsheet->getActiveSheet()->setMergeCells(['A6', 'B6', 'C6']);
            $spreadsheet->getActiveSheet()->SetCellValue('A7', 'Fecha');
            $spreadsheet->getActiveSheet()->SetCellValue('B7', 'Puntos promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('C7', 'Cantidad de usuarios');

            $row = 8;
            $max = count($data['labels']);

            for ($i = 0; $i < $max; $i++) {
                $spreadsheet->getActiveSheet()->SetCellValue('A' . $row, $data['labels'][$i]);
                $spreadsheet->getActiveSheet()->SetCellValue('B' . $row, $data['users']['how_are_you_feel'][$i]);
                $spreadsheet->getActiveSheet()->SetCellValue('C' . $row, $data['users']['climate_on_your_organization'][$i]);
                $row++;
            }


            $spreadsheet->getActiveSheet()->SetCellValue('F6', 'Puntos');
            $spreadsheet->getActiveSheet()->setMergeCells(['F6', 'G6', 'H6']);
            $spreadsheet->getActiveSheet()->SetCellValue('F7', 'Fecha');
            $spreadsheet->getActiveSheet()->SetCellValue('G7', 'Puntos promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('H7', 'Cantidad de usuarios');



            $row = 8;
            $max = count($data['labels']);

            for ($i = 0; $i < $max; $i++) {
                $spreadsheet->getActiveSheet()->SetCellValue('F' . $row, $data['labels'][$i]);
                $spreadsheet->getActiveSheet()->SetCellValue('G' . $row, $data['points']['how_are_you_feel'][$i]);
                $spreadsheet->getActiveSheet()->SetCellValue('H' . $row, $data['points']['climate_on_your_organization'][$i]);
                $row++;
            }

            $spreadsheet->getActiveSheet()->SetCellValue('J6', 'Puntos promedios ( puntos / usuarios ) ');
            $spreadsheet->getActiveSheet()->setMergeCells(['J6', 'K6', 'L6']);
            $spreadsheet->getActiveSheet()->SetCellValue('J7', 'Fecha');
            $spreadsheet->getActiveSheet()->SetCellValue('K7', 'Puntos promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('L7', 'Cantidad de usuarios');



            $row = 8;
            $max = count($data['labels']);

            for ($i = 0; $i < $max; $i++) {
                $spreadsheet->getActiveSheet()->SetCellValue('J' . $row, $data['labels'][$i]);
                $spreadsheet->getActiveSheet()->SetCellValue('K' . $row, number_format($data['average']['how_are_you_feel'][$i], 2));
                $spreadsheet->getActiveSheet()->SetCellValue('L' . $row, number_format($data['average']['climate_on_your_organization'][$i], 2));
                $row++;
            }


            $fileName = 'reporte_pulso_diario_'  . date('d-m-Y-h-i-a', time()) . '.xls';
            $tempFilename = tempnam(sys_get_temp_dir(), 'reporte_pulso_diario_' . time());

            $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
            $writer->save($tempFilename);

            $content = file_get_contents($tempFilename);
            @unlink($tempFilename);

            return new JsonModel([
                'success' => true,
                'data' => [
                    'content' => base64_encode($content),
                    'basename' => $fileName

                ]
            ]);
        } else {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }
    }
}