Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
cache	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
controller	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
db	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
exception	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
helper	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
log	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
module	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
order	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
pdf	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
range	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
shop	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
stock	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
tax	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
tree	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
webservice	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
.htaccess	510 B	-rwxrwxrwx	2023-01-18 07:38
Address.php	16.32 KB	-rwxrwxrwx	2019-04-30 18:42
AddressFormat.php	22.17 KB	-rwxrwxrwx	2019-04-30 18:42
AdminTab.php	115.85 KB	-rwxrwxrwx	2019-04-30 18:42
Alias.php	4.41 KB	-rwxrwxrwx	2019-04-30 18:42
Attachment.php	6.57 KB	-rwxrwxrwx	2019-04-30 18:42
Attribute.php	12.62 KB	-rwxrwxrwx	2019-04-30 18:42
AttributeGroup.php	11.49 KB	-rwxrwxrwx	2019-04-30 18:42
Blowfish.php	21.79 KB	-rwxrwxrwx	2019-04-30 18:42
CMS.php	8.98 KB	-rwxrwxrwx	2019-04-30 18:42
CMSCategory.php	23.42 KB	-rwxrwxrwx	2019-04-30 18:42
CMSRole.php	1.61 KB	-rwxrwxrwx	2019-04-30 18:42
CSV.php	2.89 KB	-rwxrwxrwx	2019-04-30 18:42
Carrier.php	55.24 KB	-rwxrwxrwx	2019-04-30 18:42
Cart.php	167.24 KB	-rwxrwxrwx	2019-04-30 18:42
CartRule.php	70 KB	-rwxrwxrwx	2019-04-30 18:42
Category.php	68.83 KB	-rwxrwxrwx	2019-04-30 18:42
Chart.php	5.36 KB	-rwxrwxrwx	2019-04-30 18:42
Combination.php	11.54 KB	-rwxrwxrwx	2019-04-30 18:42
CompareProduct.php	5.06 KB	-rwxrwxrwx	2019-04-30 18:42
Configuration.php	22.73 KB	-rwxrwxrwx	2019-04-30 18:42
ConfigurationKPI.php	5.49 KB	-rwxrwxrwx	2019-04-30 18:42
ConfigurationTest.php	10.66 KB	-rwxrwxrwx	2019-04-30 18:42
Connection.php	9.69 KB	-rwxrwxrwx	2019-04-30 18:42
ConnectionsSource.php	5.02 KB	-rwxrwxrwx	2019-04-30 18:42
Contact.php	3.26 KB	-rwxrwxrwx	2019-04-30 18:42
Context.php	7.29 KB	-rwxrwxrwx	2019-04-30 18:42
ControllerFactory.php	2.16 KB	-rwxrwxrwx	2019-04-30 18:42
Cookie.php	13.04 KB	-rwxrwxrwx	2019-04-30 18:42
Country.php	14.07 KB	-rwxrwxrwx	2019-04-30 18:42
County.php	3.65 KB	-rwxrwxrwx	2019-04-30 18:42
Currency.php	15.33 KB	-rwxrwxrwx	2019-04-30 18:42
Customer.php	32.46 KB	-rwxrwxrwx	2019-04-30 18:42
CustomerMessage.php	4.33 KB	-rwxrwxrwx	2019-04-30 18:42
CustomerThread.php	8.04 KB	-rwxrwxrwx	2019-04-30 18:42
Customization.php	9.72 KB	-rwxrwxrwx	2019-04-30 18:42
CustomizationField.php	2.33 KB	-rwxrwxrwx	2019-04-30 18:42
DateRange.php	2.23 KB	-rwxrwxrwx	2019-04-30 18:42
Delivery.php	3.12 KB	-rwxrwxrwx	2019-04-30 18:42
Discount.php	8.97 KB	-rwxrwxrwx	2019-04-30 18:42
Dispatcher.php	36.2 KB	-rwxrwxrwx	2019-04-30 18:42
Employee.php	16.38 KB	-rwxrwxrwx	2019-04-30 18:42
Feature.php	10.6 KB	-rwxrwxrwx	2019-04-30 18:42
FeatureValue.php	6.66 KB	-rwxrwxrwx	2019-04-30 18:42
FileUploader.php	11.06 KB	-rwxrwxrwx	2019-04-30 18:42
Gender.php	2.25 KB	-rwxrwxrwx	2019-04-30 18:42
Group.php	12.98 KB	-rwxrwxrwx	2019-04-30 18:42
GroupReduction.php	9.33 KB	-rwxrwxrwx	2019-04-30 18:42
Guest.php	7.27 KB	-rwxrwxrwx	2019-04-30 18:42
Hook.php	30.84 KB	-rwxrwxrwx	2019-04-30 18:42
Image.php	27.35 KB	-rwxrwxrwx	2019-04-30 18:42
ImageManager.php	21.9 KB	-rwxrwxrwx	2019-04-30 18:42
ImageType.php	6.14 KB	-rwxrwxrwx	2019-04-30 18:42
Language.php	39.76 KB	-rwxrwxrwx	2019-04-30 18:42
Link.php	29.46 KB	-rwxrwxrwx	2019-04-30 18:42
LocalizationPack.php	19.08 KB	-rwxrwxrwx	2019-04-30 18:42
Mail.php	24.81 KB	-rwxrwxrwx	2019-04-30 18:42
Manufacturer.php	17.13 KB	-rwxrwxrwx	2019-04-30 18:42
Media.php	39.73 KB	-rwxrwxrwx	2019-04-30 18:42
Message.php	5.65 KB	-rwxrwxrwx	2019-04-30 18:42
Meta.php	17.5 KB	-rwxrwxrwx	2019-04-30 18:42
Notification.php	6.08 KB	-rwxrwxrwx	2019-04-30 18:42
ObjectModel.php	69.64 KB	-rwxrwxrwx	2019-04-30 18:42
Pack.php	17.82 KB	-rwxrwxrwx	2019-04-30 18:42
Page.php	4.2 KB	-rwxrwxrwx	2019-04-30 18:42
PaymentCC.php	2.49 KB	-rwxrwxrwx	2019-04-30 18:42
PaymentModule.php	53.64 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopAutoload.php	8.31 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopBackup.php	10.53 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopCollection.php	20.43 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopLogger.php	6.07 KB	-rwxrwxrwx	2019-04-30 18:42
Product.php	232.97 KB	-rwxrwxrwx	2019-04-30 18:42
ProductDownload.php	9.86 KB	-rwxrwxrwx	2019-04-30 18:42
ProductSale.php	11.37 KB	-rwxrwxrwx	2019-04-30 18:42
ProductSupplier.php	7.63 KB	-rwxrwxrwx	2019-04-30 18:42
Profile.php	5.19 KB	-rwxrwxrwx	2019-04-30 18:42
QuickAccess.php	2.58 KB	-rwxrwxrwx	2019-04-30 18:42
Referrer.php	16.19 KB	-rwxrwxrwx	2019-04-30 18:42
RequestSql.php	19.64 KB	-rwxrwxrwx	2019-04-30 18:42
Rijndael.php	4.88 KB	-rwxrwxrwx	2019-04-30 18:42
Risk.php	2.35 KB	-rwxrwxrwx	2019-04-30 18:42
Scene.php	9.85 KB	-rwxrwxrwx	2019-04-30 18:42
Search.php	38.85 KB	-rwxrwxrwx	2019-04-30 18:42
SearchEngine.php	2.57 KB	-rwxrwxrwx	2019-04-30 18:42
SmartyCacheResourceMysql.php	4.76 KB	-rwxrwxrwx	2019-04-30 18:42
SmartyCustom.php	12.28 KB	-rwxrwxrwx	2019-04-30 18:42
SpecificPrice.php	22.79 KB	-rwxrwxrwx	2019-04-30 18:42
SpecificPriceRule.php	13.64 KB	-rwxrwxrwx	2019-04-30 18:42
State.php	6.65 KB	-rwxrwxrwx	2019-04-30 18:42
Store.php	4.82 KB	-rwxrwxrwx	2019-04-30 18:42
Supplier.php	15.21 KB	-rwxrwxrwx	2019-04-30 18:42
Tab.php	19.1 KB	-rwxrwxrwx	2019-04-30 18:42
Tag.php	10.19 KB	-rwxrwxrwx	2019-04-30 18:42
Theme.php	12.58 KB	-rwxrwxrwx	2019-04-30 18:42
Tools.php	130.71 KB	-rwxrwxrwx	2019-04-30 18:42
Translate.php	11.48 KB	-rwxrwxrwx	2019-04-30 18:42
TranslatedConfiguration.php	3.99 KB	-rwxrwxrwx	2019-04-30 18:42
Upgrader.php	11.02 KB	-rwxrwxrwx	2019-04-30 18:42
Uploader.php	8.47 KB	-rwxrwxrwx	2019-04-30 18:42
Validate.php	31.72 KB	-rwxrwxrwx	2019-04-30 18:42
Zone.php	3.17 KB	-rwxrwxrwx	2019-04-30 18:42
index.php	29.14 KB	-rwxrwxrwx	2023-01-18 07:38

Rename

<?php
/*
* 2007-2017 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Open Software License (OSL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/osl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
*  @author PrestaShop SA <contact@prestashop.com>
*  @copyright  2007-2017 PrestaShop SA
*  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
*  International Registered Trademark & Property of PrestaShop SA
*/

class EmployeeCore extends ObjectModel
{
    public $id;

/** @var string Determine employee profile */
    public $id_profile;

/** @var string employee language */
    public $id_lang;

/** @var string Lastname */
    public $lastname;

/** @var string Firstname */
    public $firstname;

/** @var string e-mail */
    public $email;

/** @var string Password */
    public $passwd;

/** @var datetime Password */
    public $last_passwd_gen;

public $stats_date_from;
    public $stats_date_to;

public $stats_compare_from;
    public $stats_compare_to;
    public $stats_compare_option = 1;

public $preselect_date_range;

/** @var string Display back office background in the specified color */
    public $bo_color;

public $default_tab;

/** @var string employee's chosen theme */
    public $bo_theme;

/** @var string employee's chosen css file */
    public $bo_css = 'admin-theme.css';

/** @var int employee desired screen width */
    public $bo_width;

/** @var bool, false */
    public $bo_menu = 1;

/* Deprecated */
    public $bo_show_screencast = false;

/** @var bool Status */
    public $active = 1;

/** @var bool Optin status */
    public $optin = 1;

public $remote_addr;

/* employee notifications */
    public $id_last_order;
    public $id_last_customer_message;
    public $id_last_customer;

/**
     * @see ObjectModel::$definition
     */
    public static $definition = array(
        'table' => 'employee',
        'primary' => 'id_employee',
        'fields' => array(
            'lastname' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isName', 'required' => true, 'size' => 32),
            'firstname' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isName', 'required' => true, 'size' => 32),
            'email' =>                        array('type' => self::TYPE_STRING, 'validate' => 'isEmail', 'required' => true, 'size' => 128),
            'id_lang' =>                    array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
            'passwd' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isPasswdAdmin', 'required' => true, 'size' => 32),
            'last_passwd_gen' =>            array('type' => self::TYPE_STRING),
            'active' =>                    array('type' => self::TYPE_BOOL, 'validate' => 'isBool'),
            'optin' =>                        array('type' => self::TYPE_BOOL, 'validate' => 'isBool'),
            'id_profile' =>                array('type' => self::TYPE_INT, 'validate' => 'isInt', 'required' => true),
            'bo_color' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isColor', 'size' => 32),
            'default_tab' =>                array('type' => self::TYPE_INT, 'validate' => 'isInt'),
            'bo_theme' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'size' => 32),
            'bo_css' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'size' => 64),
            'bo_width' =>                    array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'),
            'bo_menu' =>                    array('type' => self::TYPE_BOOL, 'validate' => 'isBool'),
            'stats_date_from' =>            array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
            'stats_date_to' =>                array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
            'stats_compare_from' =>            array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
            'stats_compare_to' =>            array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
            'stats_compare_option' =>        array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'),
            'preselect_date_range' =>        array('type' => self::TYPE_STRING, 'size' => 32),
            'id_last_order' =>                array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'),
            'id_last_customer_message' =>    array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'),
            'id_last_customer' =>            array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'),
        ),
    );

protected $webserviceParameters = array(
        'fields' => array(
            'id_lang' => array('xlink_resource' => 'languages'),
            'last_passwd_gen' => array('setter' => null),
            'stats_date_from' => array('setter' => null),
            'stats_date_to' => array('setter' => null),
            'stats_compare_from' => array('setter' => null),
            'stats_compare_to' => array('setter' => null),
            'passwd' => array('setter' => 'setWsPasswd'),
        ),
    );

protected $associated_shops = array();

public function __construct($id = null, $id_lang = null, $id_shop = null)
    {
        parent::__construct($id, null, $id_shop);

if (!is_null($id_lang)) {
            $this->id_lang = (int)(Language::getLanguage($id_lang) !== false) ? $id_lang : Configuration::get('PS_LANG_DEFAULT');
        }

if ($this->id) {
            $this->associated_shops = $this->getAssociatedShops();
        }

$this->image_dir = _PS_EMPLOYEE_IMG_DIR_;
    }

/**
     * @see ObjectModel::getFields()
     * @return array
     */
    public function getFields()
    {
        if (empty($this->stats_date_from) || $this->stats_date_from == '0000-00-00') {
            $this->stats_date_from = date('Y-m-d', strtotime('-1 month'));
        }

if (empty($this->stats_compare_from) || $this->stats_compare_from == '0000-00-00') {
            $this->stats_compare_from = null;
        }

if (empty($this->stats_date_to) || $this->stats_date_to == '0000-00-00') {
            $this->stats_date_to = date('Y-m-d');
        }

if (empty($this->stats_compare_to) || $this->stats_compare_to == '0000-00-00') {
            $this->stats_compare_to = null;
        }

return parent::getFields();
    }

public function add($autodate = true, $null_values = true)
    {
        $this->last_passwd_gen = date('Y-m-d H:i:s', strtotime('-'.Configuration::get('PS_PASSWD_TIME_BACK').'minutes'));
        $this->saveOptin();
        $this->updateTextDirection();
        return parent::add($autodate, $null_values);
    }

public function update($null_values = false)
    {
        if (empty($this->stats_date_from) || $this->stats_date_from == '0000-00-00') {
            $this->stats_date_from = date('Y-m-d');
        }

if (empty($this->stats_date_to) || $this->stats_date_to == '0000-00-00') {
            $this->stats_date_to = date('Y-m-d');
        }

$currentEmployee = new Employee((int)$this->id);

if ($currentEmployee->optin != $this->optin) {
            $this->saveOptin();
        }

$this->updateTextDirection();
        return parent::update($null_values);
    }

protected function updateTextDirection()
    {
        if (!defined('_PS_ADMIN_DIR_')) {
            return;
        }

$path = _PS_ADMIN_DIR_.DIRECTORY_SEPARATOR.'themes'.DIRECTORY_SEPARATOR.$this->bo_theme.DIRECTORY_SEPARATOR.'css'.DIRECTORY_SEPARATOR;
        $language = new Language($this->id_lang);

if ($language->is_rtl && !strpos($this->bo_css, '_rtl')) {
            $bo_css = preg_replace('/^(.*)\.css$/', '$1_rtl.css', $this->bo_css);

if (file_exists($path.$bo_css)) {
                $this->bo_css = $bo_css;
            }
        } elseif (!$language->is_rtl && strpos($this->bo_css, '_rtl')) {
            $bo_css = preg_replace('/^(.*)_rtl\.css$/', '$1.css', $this->bo_css);

if (file_exists($path.$bo_css)) {
                $this->bo_css = $bo_css;
            }
        }
    }

protected function saveOptin()
    {
        if ($this->optin && !defined('PS_INSTALLATION_IN_PROGRESS')) {
            $language = new Language($this->id_lang);
            $params = http_build_query(array(
                'email' => $this->email,
                'method' => 'addMemberToNewsletter',
                'language' => $language->iso_code,
                'visitorType' => 1,
                'source' => 'backoffice'
            ));
            Tools::file_get_contents('https://www.prestashop.com/ajax/controller.php?'.$params);
        }
    }

/**
     * Return list of employees
     *
     * @param bool $active_only Filter employee by active status
     * @return array|false Employees or false
     */
    public static function getEmployees($active_only = true)
    {
        return Db::getInstance()->executeS('
			SELECT `id_employee`, `firstname`, `lastname`
			FROM `'._DB_PREFIX_.'employee`
			'.($active_only ? ' WHERE `active` = 1' : '').'
			ORDER BY `lastname` ASC
		');
    }

/**
     * Return employee instance from its e-mail (optionnaly check password)
     *
     * @param string $email e-mail
     * @param string $passwd Password is also checked if specified
     * @param bool $active_only Filter employee by active status
     * @return Employee instance
     */
    public function getByEmail($email, $passwd = null, $active_only = true)
    {
        if (!Validate::isEmail($email) || ($passwd != null && !Validate::isPasswd($passwd))) {
            die(Tools::displayError());
        }

$result = Db::getInstance()->getRow('
		SELECT *
		FROM `'._DB_PREFIX_.'employee`
		WHERE `email` = \''.pSQL($email).'\'
		'.($active_only ? ' AND `active` = 1' : '')
        .($passwd !== null ? ' AND `passwd` = \''.Tools::encrypt($passwd).'\'' : ''));
        if (!$result) {
            return false;
        }
        $this->id = $result['id_employee'];
        $this->id_profile = $result['id_profile'];
        foreach ($result as $key => $value) {
            if (property_exists($this, $key)) {
                $this->{$key} = $value;
            }
        }
        return $this;
    }

public static function employeeExists($email)
    {
        if (!Validate::isEmail($email)) {
            die(Tools::displayError());
        }

return (bool)Db::getInstance()->getValue('
		SELECT `id_employee`
		FROM `'._DB_PREFIX_.'employee`
		WHERE `email` = \''.pSQL($email).'\'');
    }

/**
     * Check if employee password is the right one
     *
     * @param string $passwd Password
     * @return bool result
     */
    public static function checkPassword($id_employee, $passwd)
    {
        if (!Validate::isUnsignedId($id_employee) || !Validate::isPasswd($passwd, 8)) {
            die(Tools::displayError());
        }

return Db::getInstance()->getValue('
		SELECT `id_employee`
		FROM `'._DB_PREFIX_.'employee`
		WHERE `id_employee` = '.(int)$id_employee.'
		AND `passwd` = \''.pSQL($passwd).'\'
		AND `active` = 1');
    }

public static function countProfile($id_profile, $active_only = false)
    {
        return Db::getInstance()->getValue('
		SELECT COUNT(*)
		FROM `'._DB_PREFIX_.'employee`
		WHERE `id_profile` = '.(int)$id_profile.'
		'.($active_only ? ' AND `active` = 1' : ''));
    }

public function isLastAdmin()
    {
        return ($this->isSuperAdmin()
            && Employee::countProfile($this->id_profile, true) == 1
            && $this->active
        );
    }

public function setWsPasswd($passwd)
    {
        if ($this->id != 0) {
            if ($this->passwd != $passwd) {
                $this->passwd = Tools::encrypt($passwd);
            }
        } else {
            $this->passwd = Tools::encrypt($passwd);
        }
        return true;
    }

/**
     * Check employee informations saved into cookie and return employee validity
     *
     * @return bool employee validity
     */
    public function isLoggedBack()
    {
        if (!Cache::isStored('isLoggedBack'.$this->id)) {
            /* Employee is valid only if it can be load and if cookie password is the same as database one */
            $result = (
                            $this->id && Validate::isUnsignedId($this->id) && Employee::checkPassword($this->id, Context::getContext()->cookie->passwd)
                            && (!isset(Context::getContext()->cookie->remote_addr) || Context::getContext()->cookie->remote_addr == ip2long(Tools::getRemoteAddr()) || !Configuration::get('PS_COOKIE_CHECKIP'))
                        );
            Cache::store('isLoggedBack'.$this->id, $result);
            return $result;
        }
        return Cache::retrieve('isLoggedBack'.$this->id);
    }

/**
     * Logout
     */
    public function logout()
    {
        if (isset(Context::getContext()->cookie)) {
            Context::getContext()->cookie->logout();
            Context::getContext()->cookie->write();
        }
        $this->id = null;
    }

public function favoriteModulesList()
    {
        return Db::getInstance()->executeS('
			SELECT `module`
			FROM `'._DB_PREFIX_.'module_preference`
			WHERE `id_employee` = '.(int)$this->id.' AND `favorite` = 1 AND (`interest` = 1 OR `interest` IS NULL)'
        );
    }

/**
     * Check if the employee is associated to a specific shop
     *
     * @since 1.5.0
     * @param int $id_shop
     * @return bool
     */
    public function hasAuthOnShop($id_shop)
    {
        return $this->isSuperAdmin() || in_array($id_shop, $this->associated_shops);
    }

/**
     * Check if the employee is associated to a specific shop group
     *
     * @since 1.5.0
     * @param int $id_shop_shop
     * @return bool
     */
    public function hasAuthOnShopGroup($id_shop_group)
    {
        if ($this->isSuperAdmin()) {
            return true;
        }

foreach ($this->associated_shops as $id_shop) {
            if ($id_shop_group == Shop::getGroupFromShop($id_shop, true)) {
                return true;
            }
        }
        return false;
    }

/**
     * Get default id_shop with auth for current employee
     *
     * @since 1.5.0
     * @return int
     */
    public function getDefaultShopID()
    {
        if ($this->isSuperAdmin() || in_array(Configuration::get('PS_SHOP_DEFAULT'), $this->associated_shops)) {
            return Configuration::get('PS_SHOP_DEFAULT');
        }
        return $this->associated_shops[0];
    }

public static function getEmployeesByProfile($id_profile, $active_only = false)
    {
        return Db::getInstance()->executeS('
		SELECT *
		FROM `'._DB_PREFIX_.'employee`
		WHERE `id_profile` = '.(int)$id_profile.'
		'.($active_only ? ' AND `active` = 1' : ''));
    }

/**
     * Check if current employee is super administrator
     *
     * @return bool
     */
    public function isSuperAdmin()
    {
        return $this->id_profile == _PS_ADMIN_PROFILE_;
    }

public function getImage()
    {
        if (!Validate::isLoadedObject($this)) {
            return Tools::getAdminImageUrl('prestashop-avatar.png');
        }
        return Tools::getShopProtocol().'profile.prestashop.com/'.urlencode($this->email).'.jpg';
    }

public function getLastElementsForNotify($element)
    {
        $element = bqSQL($element);
        $max = Db::getInstance()->getValue('
			SELECT MAX(`id_'.$element.'`) as `id_'.$element.'`
			FROM `'._DB_PREFIX_.$element.($element == 'order' ? 's': '').'`');

// if no rows in table, set max to 0
        if ((int)$max < 1) {
            $max = 0;
        }

return (int)$max;
    }

public static function setLastConnectionDate($id_employee)
    {
        return Db::getInstance()->execute('
			UPDATE `'._DB_PREFIX_.'employee`
			SET `last_connection_date` = CURRENT_DATE()
			WHERE `id_employee` = '.(int)$id_employee.' AND `last_connection_date`< CURRENT_DATE()
		');
    }
}