Proyectos de Subversion LeadersLinked - Backend

<?php

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Mvc\Controller\AbstractActionController;

use Laminas\Log\LoggerInterface;

use Laminas\View\Model\ViewModel;

use Laminas\View\Model\JsonModel;

use LeadersLinked\Mapper\CompanyMapper;

use LeadersLinked\Mapper\DailyPulseRecordMapper;

use LeadersLinked\Model\DailyPulseRecord;

use PhpOffice\PhpSpreadsheet\IOFactory;

use PhpOffice\PhpSpreadsheet\Spreadsheet;

class DailyPulseReportsController extends AbstractActionController

{

    /**

     *

     * @var \Laminas\Db\Adapter\AdapterInterface

     */

    private $adapter;

    /**

     *

     * @var \LeadersLinked\Cache\CacheInterface

     */

    private $cache;

    /**

     *

     * @var \Laminas\Log\LoggerInterface

     */

    private $logger;

    /**

     *

     * @var array

     */

    private $config;

    /**

     *

     * @var \Laminas\Mvc\I18n\Translator

     */

    private $translator;

    /**

     *

     * @param \Laminas\Db\Adapter\AdapterInterface $adapter

     * @param \LeadersLinked\Cache\CacheInterface $cache

     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger

     * @param array $config

     * @param \Laminas\Mvc\I18n\Translator $translator

     */

    public function __construct($adapter, $cache, $logger, $config, $translator)

    {

        $this->adapter      = $adapter;

        $this->cache        = $cache;

        $this->logger       = $logger;

        $this->config       = $config;

        $this->translator   = $translator;

    }

    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/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'

            ]);

        }

    }

}