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($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 = [
                   'how_are_you_feel' => [
                       'average_points'     => 0,
                       'average_users'      => 0,
                       'labels'             => [],
                       'dataset1'           => [],
                       'dataset2'           => [],
                    ],    
                    'climate_on_your_organization' => [
                        'average_points'    => 0,
                        'average_users'     => 0,
                        'labels'            => [],
                        'dataset1'          => [],
                        'dataset2'          => [],
                    ]
                ];
                
                
                $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');
                    
                    
                    $dataset1 = 0;
                    $dataset2 = 0;
                    foreach($how_are_you_feel as $record)
                    {
                        if($date == $record['date']) {
                            $dataset1 = $record['points'];
                            $dataset2 = $record['users'];
                        }
                    }
                    
                    $how_are_you_feel_points += $dataset1;
                    $how_are_you_feel_users += $dataset2;
                    
                    array_push($data['how_are_you_feel']['labels'], $label); 
                    array_push($data['how_are_you_feel']['dataset1'], $dataset1);
                    array_push($data['how_are_you_feel']['dataset2'], $dataset2);

                    
                    $dataset1 = 0;
                    $dataset2 = 0;
                    foreach($climate_on_your_organization as $record)
                    {
                        if($date == $record['date']) {
                            $dataset1 = $record['points'];
                            $dataset2 = $record['users'];
                        }
                    }
                    
                    $climate_on_your_organization_points += $dataset1;
                    $climate_on_your_organization_users += $dataset2;
                    
                    
                    array_push($data['climate_on_your_organization']['labels'], $label);
                    array_push($data['climate_on_your_organization']['dataset1'], $dataset1);
                    array_push($data['climate_on_your_organization']['dataset2'], $dataset2);
                    

                    
                    
                    $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 {
            
                //$form = new BehaviorForm();
                
                $this->layout()->setTemplate('layout/layout-backend');
                $viewModel = new ViewModel();
                $viewModel->setTemplate('leaders-linked/daily-pulse-reports/overview.phtml');
               // $viewModel->setVariable('form', $form);
                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 = [
                'how_are_you_feel' => [
                    'average_points'    => 0,
                    'average_users'     => 0,
                    'items'             => [],
                ],
                'climate_on_your_organization' => [
                    'average_points'    => 0,
                    'average_users'     => 0,
                    'items'             => [],
                ]
            ];
            
            
            $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');
                
                
                $dataset1 = 0;
                $dataset2 = 0;
                foreach($how_are_you_feel as $record)
                {
                    if($date == $record['date']) {
                        $dataset1 = $record['points'];
                        $dataset2 = $record['users'];
                    }
                }
                
                $how_are_you_feel_points += $dataset1;
                $how_are_you_feel_users += $dataset2;
                
                array_push($data['how_are_you_feel']['items'], [
                    'label' => $label, 
                    'dataset1' =>  $dataset1,
                    'dataset2' => $dataset2
                ]);
                
                
                $dataset1 = 0;
                $dataset2 = 0;
                foreach($climate_on_your_organization as $record)
                {
                    if($date == $record['date']) {
                        $dataset1 = $record['points'];
                        $dataset2 = $record['users'];
                    }
                }
                
                $climate_on_your_organization_points += $dataset1;
                $climate_on_your_organization_users += $dataset2;
                
                array_push($data['climate_on_your_organization']['items'], [
                    'label' => $label,
                    'dataset1' =>  $dataset1,
                    'dataset2' => $dataset2
                ]);
                
                
                $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()->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()->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', 'Fecha');
            $spreadsheet->getActiveSheet()->SetCellValue('B6', 'Puntos promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('C6', 'Cantidad de usuarios');
            
            $i = 7;
            foreach($data['how_are_you_feel']['items'] as $record)
            {
                $spreadsheet->getActiveSheet()->SetCellValue('A' . $i, $record['label']);
                $spreadsheet->getActiveSheet()->SetCellValue('B' . $i, $record['dataset1']);
                $spreadsheet->getActiveSheet()->SetCellValue('C' . $i, $record['dataset2']);
                
                $i++;
            }
            
            
            $spreadsheet->getActiveSheet()->SetCellValue('F6', 'Fecha');
            $spreadsheet->getActiveSheet()->SetCellValue('G6', 'Puntos promedios');
            $spreadsheet->getActiveSheet()->SetCellValue('H6', 'Cantidad de usuarios');
            
            $i = 7;
            foreach($data['climate_on_your_organization']['items'] as $record)
            {
                $spreadsheet->getActiveSheet()->SetCellValue('F' . $i, $record['label']);
                $spreadsheet->getActiveSheet()->SetCellValue('G' . $i, $record['dataset1']);
                $spreadsheet->getActiveSheet()->SetCellValue('H' . $i, $record['dataset2']);
                
                $i++;
            }
            
                     
            $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'
            ]);
        }
    }
    
    
}