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\Form\Tools\UserUploadGeneratePasswordForm;

use PhpOffice\PhpSpreadsheet\IOFactory;

use LeadersLinked\Library\Functions;

class ToolsController 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 userfilePasswordGeneratorAction()

    {

        $request = $this->getRequest();

        if($request->isPost())

        {

            $form = new  UserUploadGeneratePasswordForm();

            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());

            $form->setData($dataPost);

            if($form->isValid()) {

                $file = $_FILES['file'];

                $tmp_filename = $file['tmp_name'];

                $filename = $file['name'];

                $final_filename =  'data/' . $filename;

                if(!move_uploaded_file($tmp_filename, $final_filename)) {

                    return new JsonModel([

                        'success' => false,

                        'data' => 'ERROR_UPLOAD_FILE'

                    ]);

                }

                $spreadsheet = IOFactory::load($final_filename);

                $sheet = $spreadsheet->getActiveSheet();

                $max = $sheet->getHighestDataRow('A');

                $caracteres =  ['#', '?', '!', '@', '$'];

                $max_caracteres = count($caracteres);

                for($i = 1; $i <= $max; $i++)

                {

                    $first_name = Functions::sanitizeFilterString($sheet->getCell('A' . $i)->getValue());

                    $last_name = Functions::sanitizeFilterString($sheet->getCell('B' . $i)->getValue());

                    $email = trim(filter_var(strval($sheet->getCell('C' . $i)->getValue()), FILTER_SANITIZE_EMAIL));

                    if(empty($first_name) || empty($last_name) || !filter_var($email, FILTER_VALIDATE_EMAIL) ) {

                        continue;

                    }

                    $caracter = $caracteres[ rand(0, $max_caracteres - 1) ];

                    $runmber = rand(1001, 9999);

                    $sfirst_name = ucfirst(substr(strtolower(str_replace(' ', '', $first_name)), 0, 4));

                    $slast_name = ucfirst(substr(strtolower(str_replace(' ', '', $last_name)), 0, 4));

                    $password = $sfirst_name . $slast_name . $runmber . $caracter;

                    $sheet->SetCellValue('D' . $i, $password);

                }

                $filename = $file['name'];

                $final_filename =  'data/' . $filename;

                $fileName = Functions::normalizeStringFilename($file['name']);

                $fileName = str_replace('.xlsx', '', $fileName);

                $fileName = str_replace('.xls', '', $fileName);

                $fileName = $fileName . '-generado-' . date('Y-m-d-H-i-s') . '.xlsx';

                $tempFilename = tempnam(sys_get_temp_dir(), $file['name'] . time());

                $writer = IOFactory::createWriter($spreadsheet, 'Xls');

                $writer->save($tempFilename);

                $content = file_get_contents($tempFilename);

                @unlink($final_filename);

                @unlink($tempFilename);

                return new JsonModel([

                    'success' => true,

                    'data' => [

                        'content' => base64_encode($content),

                        'basename' => $fileName

                    ]

                ]);

            } else {

                $messages = [];

                $form_messages = (array) $form->getMessages();

                foreach ($form_messages  as $fieldname => $field_messages) {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success'   => false,

                    'data'   => $messages

                ]);

            }

        }

        else if($request->isGet()) {

            $form = new  UserUploadGeneratePasswordForm();

            $this->layout()->setTemplate('layout/layout-backend.phtml');

            $viewModel = new ViewModel();

            $viewModel->setTemplate('leaders-linked/tools/password-generator-for-file.phtml');

            $viewModel->setVariables([

                'form' => $form

            ]);

            return $viewModel ;

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);;

        }

    }

}