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');
                }
                
                $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'             => [],
                    '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'
            ]);
        }
    }
    
    
}