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 : /proc/1700/cwd/html/app/model/

Upload File :

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

Current File : /proc/1700/cwd/html/app/model/AdministratorRepository.php

<?php

namespace Promoteus;

use Nette\Database\Context;
use Nette\Http\FileUpload;
use Nette\Security\User;
use Nette\Utils\DateTime;
use Tracy\Debugger;

/**
 * Table "administrator"
 */
class AdministratorRepository extends Repository
{
    const Role_Administrator = 'administrator', Role_User = 'user', Role_Salesman = 'salesman';


    /**
     * @param $values
     * @return mixed|\Nette\Database\Table\ActiveRow|null
     * @throws RepositoryException
     */
    public function insert($values)
    {
        $values['password'] = $this->hashPassword($values['password']);

        $values2 = clone $values;
        $column = 'image';
        unset($values2[$column]);
        $newAdmin = parent::insert($values2);

        if (key_exists($column, $values)) {
            /** @var FileUpload $img */
            $img = $values[$column];
            if ($img instanceof FileUpload && $img->getName()) {
                $this->checkImage($column, $values, $newAdmin->id, ImagesTypeRepository::Salesman, $newAdmin->id);
            }
        }

        /** @var PresenterAdministratorRepository $presenterAdministratorRepository */
        $presenterAdministratorRepository = $this->getService('presenterAdministratorRepository');
        $presenterAdministratorRepository->setNewUser($newAdmin->id);

        return $newAdmin;

    }

    /* public function updateAdmin($id, $values)
     {

         $values['password'] = $this->hashPassword($values['password']);
         return $this->db->table("administrator")->where("id=?", $id)->update($values);

         //parent::update($id, $values);
     }*/

    /**
     * @param $administratorId
     * @param $values
     * @return bool
     * @throws RepositoryException
     */
    public function update($administratorId, $values)
    {
        if (isset($values['password'])) {
            $values['password'] = $this->hashPassword($values['password']);
        }
        if (key_exists('image', $values)) {
            /** @var FileUpload $img */
            $img = $values['image'];
            if ($img instanceof FileUpload && $img->getName()) {
                $this->checkImage('image', $values, $administratorId, ImagesTypeRepository::Salesman, $values->id);
            }
        }
        unset($values['image']);
        if (parent::update($administratorId, $values)) {
            return true;
        } else {
            return false;
        }

    }

    public function getAgents()
    {
        $agents = $this->getDataForSelectInput('username');
        $agents[''] = '--- žádný zástupce ---';
        return $agents;
    }
    public function isUsernameAvailable($username, $id = NULL)
    {
        $stmt = $this->getTable()->where('username', $username)->limit(1);
        if ($id) {
            $stmt->where('id != ?', $id);
        }
        return !(bool)$stmt->fetch();
    }

    private function hashPassword($password)
    {
        return sha1($password);
    }

    public function getAdmin($id)
    {
        return $this->db->query('SELECT * FROM administrator WHERE id = ' . $id)->fetch();
    }
    public function getAdministrators()
    {
        return $this->db->query('SELECT * FROM administrator')->fetchAll();
    }
    public function setLastActionTime($id)
    {
        $time = DateTime::from(0)->format('Y-m-d H:i:s');
        $data = array('logged_at' => $time);
        return $this->db->table('administrator')->where('id=?', $id["administrator"])->update($data);
    }

    private function getEmployeesByRole($role)
    {
        return $this->findBy(['role' => $role]);
    }

    public function getEmployeesByRoleSaleMans()
    {
        return $this->getEmployeesByRole(static::Role_Salesman);
    }

    public function getEmployeesByRoleUser()
    {
        return $this->getEmployeesByRole(static::Role_User);
    }

    public function getEmployeesByRoleAdministrator()
    {
        return $this->getEmployeesByRole(static::Role_Administrator);
    }

    public function getReferentData($id, $surfix)
    {
        return $this->db
            ->table('administrator')
            ->select('id')
            ->select('is_on_holiday')
            ->select('name')
            ->select('zastupce_id')
            ->select('telephone')
            ->select('email_' . $surfix . ' AS email')
            ->where("id=?", $id)
            ->fetch();
    }

    /**
     * @param $id
     * @return \Nette\Database\Table\ActiveRow
     * @throws RepositoryException
     */
    public function delete($id)
    {
        //$this->db->beginTransaction();
        foreach ($this->findBy(['zastupce_id' => $id]) ?: [] as $admin) {
            $admin->update(['zastupce_id' => null]);
        }
        foreach ($this->db->table('client')->where(['referent' => $id])->fetchAll() ?: [] as $admin) {
            $admin->update(['referent' => null]);
        }
        foreach ($this->db->table('link_presenter_administrator')->where(['who_changed' => $id])->fetchAll() ?: [] as $admin) {
            $admin->update(['who_changed' => null]);
        }
        $this->db->table('link_admin_client')->where(['administrator_id' => $id])->delete();
        $this->db->table('link_presenter_administrator')->where(['administrator_id' => $id])->delete();

        $deleted = parent::delete($id);

        /** @var ImagesTypeRepository $imagesTypeRepository */
        $imagesTypeRepository = $this->getService('imagesTypeRepository');
        $imagesTypeRepository->delImageByTypeAndName(ImagesTypeRepository::Salesman, $deleted->id);

        //$this->db->commit();
        return $deleted;
    }

    public function getValuesForSelect()
    {
        $values = $this->findAll('name');

        $result = [];

        foreach ($values as $value)
        {
            $result[$value->id] = sprintf('%s (%s)', $value->name, $value->email_cze);
        }

        return $result;
    }
}

Anon7 - 2022
AnonSec Team