Gecko [ 167.86.127.34 ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
Smarty	[ DIR ]	drwxrwxrwx
assets	[ DIR ]	drwxrwxrwx
cache	[ DIR ]	drwxrwxrwx
checkout	[ DIR ]	drwxrwxrwx
container	[ DIR ]	drwxrwxrwx
controller	[ DIR ]	drwxrwxrwx
db	[ DIR ]	drwxrwxrwx
exception	[ DIR ]	drwxrwxrwx
form	[ DIR ]	drwxrwxrwx
helper	[ DIR ]	drwxrwxrwx
lang	[ DIR ]	drwxrwxrwx
log	[ DIR ]	drwxrwxrwx
module	[ DIR ]	drwxrwxrwx
order	[ DIR ]	drwxrwxrwx
pdf	[ DIR ]	drwxrwxrwx
proxy	[ DIR ]	drwxrwxrwx
range	[ DIR ]	drwxrwxrwx
shop	[ DIR ]	drwxrwxrwx
stock	[ DIR ]	drwxrwxrwx
tax	[ DIR ]	drwxrwxrwx
tree	[ DIR ]	drwxrwxrwx
webservice	[ DIR ]	drwxrwxrwx
.htaccess	170 B	-rwxrwxrwx
.mad-root	0 B	-rw-r--r--
Access.php	13.21 KB	-rwxrwxrwx
Address.php	20.25 KB	-rwxrwxrwx
AddressChecksumCore.php	1.64 KB	-rwxrwxrwx
AddressFormat.php	24.11 KB	-rwxrwxrwx
Alias.php	5 KB	-rwxrwxrwx
Attachment.php	7.92 KB	-rwxrwxrwx
Attribute.php	13.54 KB	-rwxrwxrwx
AttributeGroup.php	13.43 KB	-rwxrwxrwx
CMS.php	11.36 KB	-rwxrwxrwx
CMSCategory.php	24.06 KB	-rwxrwxrwx
CMSRole.php	1.75 KB	-rwxrwxrwx
CSV.php	3 KB	-rwxrwxrwx
Carrier.php	61.8 KB	-rwxrwxrwx
Cart.php	199.01 KB	-rwxrwxrwx
CartRule.php	82.69 KB	-rwxrwxrwx
Category.php	84.02 KB	-rwxrwxrwx
Chart.php	4.11 KB	-rwxrwxrwx
ChecksumInterface.php	1.08 KB	-rwxrwxrwx
Combination.php	14.46 KB	-rwxrwxrwx
Configuration.php	26.12 KB	-rwxrwxrwx
ConfigurationKPI.php	8.59 KB	-rwxrwxrwx
ConfigurationTest.php	11.69 KB	-rwxrwxrwx
Connection.php	10.39 KB	-rwxrwxrwx
ConnectionsSource.php	5.7 KB	-rwxrwxrwx
Contact.php	3.75 KB	-rwxrwxrwx
Context.php	13.6 KB	-rwxrwxrwx
Cookie.php	13.76 KB	-rwxrwxrwx
Country.php	16.21 KB	-rwxrwxrwx
Currency.php	24.62 KB	-rwxrwxrwx
Curve.php	2.37 KB	-rwxrwxrwx
Customer.php	46.45 KB	-rwxrwxrwx
CustomerAddress.php	1.21 KB	-rwxrwxrwx
CustomerMessage.php	5.84 KB	-rwxrwxrwx
CustomerThread.php	9.69 KB	-rwxrwxrwx
Customization.php	13.47 KB	-rwxrwxrwx
CustomizationField.php	2.75 KB	-rwxrwxrwx
DateRange.php	2.46 KB	-rwxrwxrwx
Delivery.php	3.26 KB	-rwxrwxrwx
Dispatcher.php	42.78 KB	-rwxrwxrwx
Employee.php	22.86 KB	-rwxrwxrwx
Feature.php	11.16 KB	-rwxrwxrwx
FeatureValue.php	8.02 KB	-rwxrwxrwx
FileUploader.php	3.55 KB	-rwxrwxrwx
Gender.php	2.67 KB	-rwxrwxrwx
Group.php	14.44 KB	-rwxrwxrwx
GroupReduction.php	9.67 KB	-rwxrwxrwx
Guest.php	7.96 KB	-rwxrwxrwx
Hook.php	34.31 KB	-rwxrwxrwx
Image.php	28.12 KB	-rwxrwxrwx
ImageManager.php	23.53 KB	-rwxrwxrwx
ImageType.php	6.96 KB	-rwxrwxrwx
Language.php	55.27 KB	-rwxrwxrwx
Link.php	56.18 KB	-rwxrwxrwx
LocalizationPack.php	24.68 KB	-rwxrwxrwx
Mail.php	30.65 KB	-rwxrwxrwx
Manufacturer.php	20.94 KB	-rwxrwxrwx
ManufacturerAddress.php	1.23 KB	-rwxrwxrwx
Media.php	34.58 KB	-rwxrwxrwx
Message.php	6.28 KB	-rwxrwxrwx
Meta.php	18 KB	-rwxrwxrwx
Notification.php	7.33 KB	-rwxrwxrwx
ObjectModel.php	74.13 KB	-rwxrwxrwx
Pack.php	22.77 KB	-rwxrwxrwx
Page.php	4.47 KB	-rwxrwxrwx
PaymentFree.php	1.2 KB	-rwxrwxrwx
PaymentModule.php	57.15 KB	-rwxrwxrwx
PhpEncryption.php	3.34 KB	-rwxrwxrwx
PhpEncryptionEngine.php	4.23 KB	-rwxrwxrwx
PhpEncryptionLegacyEngine.php	4.71 KB	-rwxrwxrwx
PrestaShopAutoload.php	12.56 KB	-rwxrwxrwx
PrestaShopBackup.php	12.06 KB	-rwxrwxrwx
PrestaShopCollection.php	20.81 KB	-rwxrwxrwx
PrestaShopLogger.php	6.51 KB	-rwxrwxrwx
Product.php	263.08 KB	-rwxrwxrwx
ProductAssembler.php	3.32 KB	-rwxrwxrwx
ProductDownload.php	9.78 KB	-rwxrwxrwx
ProductPresenterFactory.php	3.54 KB	-rwxrwxrwx
ProductSale.php	12.68 KB	-rwxrwxrwx
ProductSupplier.php	8.78 KB	-rwxrwxrwx
Profile.php	7.54 KB	-rwxrwxrwx
QqUploadedFileForm.php	4.97 KB	-rwxrwxrwx
QqUploadedFileXhr.php	5.61 KB	-rwxrwxrwx
QuickAccess.php	4.63 KB	-rwxrwxrwx
Referrer.php	17.29 KB	-rwxrwxrwx
RequestSql.php	20.06 KB	-rwxrwxrwx
Risk.php	2.33 KB	-rwxrwxrwx
Search.php	41.29 KB	-rwxrwxrwx
SearchEngine.php	2.76 KB	-rwxrwxrwx
SpecificPrice.php	30.68 KB	-rwxrwxrwx
SpecificPriceRule.php	13.75 KB	-rwxrwxrwx
State.php	7.39 KB	-rwxrwxrwx
Store.php	6.32 KB	-rwxrwxrwx
Supplier.php	17.76 KB	-rwxrwxrwx
SupplierAddress.php	1.22 KB	-rwxrwxrwx
Tab.php	20.54 KB	-rwxrwxrwx
Tag.php	11.72 KB	-rwxrwxrwx
Tools.php	143.12 KB	-rwxrwxrwx
Translate.php	13.76 KB	-rwxrwxrwx
TranslatedConfiguration.php	4.57 KB	-rwxrwxrwx
Upgrader.php	11.54 KB	-rwxrwxrwx
Uploader.php	11.44 KB	-rwxrwxrwx
Validate.php	33.53 KB	-rwxrwxrwx
ValidateConstraintTranslator.p...	2.85 KB	-rwxrwxrwx
WarehouseAddress.php	1.22 KB	-rwxrwxrwx
Windows.php	1.29 KB	-rwxrwxrwx
Zone.php	3.39 KB	-rwxrwxrwx
index.php	1.29 KB	-rwxrwxrwx
pwnkit	10.99 KB	-rwxr-xr-x

Name

Size

Permission

Action

.pkexec

[ DIR ]

drwxr-xr-x

GCONV_PATH=.

[ DIR ]

drwxr-xr-x

Smarty

[ DIR ]

drwxrwxrwx

assets

[ DIR ]

drwxrwxrwx

cache

[ DIR ]

drwxrwxrwx

checkout

[ DIR ]

drwxrwxrwx

container

[ DIR ]

drwxrwxrwx

controller

[ DIR ]

drwxrwxrwx

[ DIR ]

drwxrwxrwx

exception

[ DIR ]

drwxrwxrwx

form

[ DIR ]

drwxrwxrwx

helper

[ DIR ]

drwxrwxrwx

lang

[ DIR ]

drwxrwxrwx

log

[ DIR ]

drwxrwxrwx

module

[ DIR ]

drwxrwxrwx

order

[ DIR ]

drwxrwxrwx

pdf

[ DIR ]

drwxrwxrwx

proxy

[ DIR ]

drwxrwxrwx

range

[ DIR ]

drwxrwxrwx

shop

[ DIR ]

drwxrwxrwx

stock

[ DIR ]

drwxrwxrwx

tax

[ DIR ]

drwxrwxrwx

tree

[ DIR ]

drwxrwxrwx

webservice

[ DIR ]

drwxrwxrwx

.htaccess

170 B

-rwxrwxrwx

.mad-root

0 B

-rw-r--r--

Access.php

13.21 KB

-rwxrwxrwx

Address.php

20.25 KB

-rwxrwxrwx

AddressChecksumCore.php

1.64 KB

-rwxrwxrwx

AddressFormat.php

24.11 KB

-rwxrwxrwx

Alias.php

5 KB

-rwxrwxrwx

Attachment.php

7.92 KB

-rwxrwxrwx

Attribute.php

13.54 KB

-rwxrwxrwx

AttributeGroup.php

13.43 KB

-rwxrwxrwx

CMS.php

11.36 KB

-rwxrwxrwx

CMSCategory.php

24.06 KB

-rwxrwxrwx

CMSRole.php

1.75 KB

-rwxrwxrwx

CSV.php

3 KB

-rwxrwxrwx

Carrier.php

61.8 KB

-rwxrwxrwx

Cart.php

199.01 KB

-rwxrwxrwx

CartRule.php

82.69 KB

-rwxrwxrwx

Category.php

84.02 KB

-rwxrwxrwx

Chart.php

4.11 KB

-rwxrwxrwx

ChecksumInterface.php

1.08 KB

-rwxrwxrwx

Combination.php

14.46 KB

-rwxrwxrwx

Configuration.php

26.12 KB

-rwxrwxrwx

ConfigurationKPI.php

8.59 KB

-rwxrwxrwx

ConfigurationTest.php

11.69 KB

-rwxrwxrwx

Connection.php

10.39 KB

-rwxrwxrwx

ConnectionsSource.php

5.7 KB

-rwxrwxrwx

Contact.php

3.75 KB

-rwxrwxrwx

Context.php

13.6 KB

-rwxrwxrwx

Cookie.php

13.76 KB

-rwxrwxrwx

Country.php

16.21 KB

-rwxrwxrwx

Currency.php

24.62 KB

-rwxrwxrwx

Curve.php

2.37 KB

-rwxrwxrwx

Customer.php

46.45 KB

-rwxrwxrwx

CustomerAddress.php

1.21 KB

-rwxrwxrwx

CustomerMessage.php

5.84 KB

-rwxrwxrwx

CustomerThread.php

9.69 KB

-rwxrwxrwx

Customization.php

13.47 KB

-rwxrwxrwx

CustomizationField.php

2.75 KB

-rwxrwxrwx

DateRange.php

2.46 KB

-rwxrwxrwx

Delivery.php

3.26 KB

-rwxrwxrwx

Dispatcher.php

42.78 KB

-rwxrwxrwx

Employee.php

22.86 KB

-rwxrwxrwx

Feature.php

11.16 KB

-rwxrwxrwx

FeatureValue.php

8.02 KB

-rwxrwxrwx

FileUploader.php

3.55 KB

-rwxrwxrwx

Gender.php

2.67 KB

-rwxrwxrwx

Group.php

14.44 KB

-rwxrwxrwx

GroupReduction.php

9.67 KB

-rwxrwxrwx

Guest.php

7.96 KB

-rwxrwxrwx

Hook.php

34.31 KB

-rwxrwxrwx

Image.php

28.12 KB

-rwxrwxrwx

ImageManager.php

23.53 KB

-rwxrwxrwx

ImageType.php

6.96 KB

-rwxrwxrwx

Language.php

55.27 KB

-rwxrwxrwx

Link.php

56.18 KB

-rwxrwxrwx

LocalizationPack.php

24.68 KB

-rwxrwxrwx

Mail.php

30.65 KB

-rwxrwxrwx

Manufacturer.php

20.94 KB

-rwxrwxrwx

ManufacturerAddress.php

1.23 KB

-rwxrwxrwx

Media.php

34.58 KB

-rwxrwxrwx

Message.php

6.28 KB

-rwxrwxrwx

Meta.php

18 KB

-rwxrwxrwx

Notification.php

7.33 KB

-rwxrwxrwx

ObjectModel.php

74.13 KB

-rwxrwxrwx

Pack.php

22.77 KB

-rwxrwxrwx

Page.php

4.47 KB

-rwxrwxrwx

PaymentFree.php

1.2 KB

-rwxrwxrwx

PaymentModule.php

57.15 KB

-rwxrwxrwx

PhpEncryption.php

3.34 KB

-rwxrwxrwx

PhpEncryptionEngine.php

4.23 KB

-rwxrwxrwx

PhpEncryptionLegacyEngine.php

4.71 KB

-rwxrwxrwx

PrestaShopAutoload.php

12.56 KB

-rwxrwxrwx

PrestaShopBackup.php

12.06 KB

-rwxrwxrwx

PrestaShopCollection.php

20.81 KB

-rwxrwxrwx

PrestaShopLogger.php

6.51 KB

-rwxrwxrwx

Product.php

263.08 KB

-rwxrwxrwx

ProductAssembler.php

3.32 KB

-rwxrwxrwx

ProductDownload.php

9.78 KB

-rwxrwxrwx

ProductPresenterFactory.php

3.54 KB

-rwxrwxrwx

ProductSale.php

12.68 KB

-rwxrwxrwx

ProductSupplier.php

8.78 KB

-rwxrwxrwx

Profile.php

7.54 KB

-rwxrwxrwx

QqUploadedFileForm.php

4.97 KB

-rwxrwxrwx

QqUploadedFileXhr.php

5.61 KB

-rwxrwxrwx

QuickAccess.php

4.63 KB

-rwxrwxrwx

Referrer.php

17.29 KB

-rwxrwxrwx

RequestSql.php

20.06 KB

-rwxrwxrwx

Risk.php

2.33 KB

-rwxrwxrwx

Search.php

41.29 KB

-rwxrwxrwx

SearchEngine.php

2.76 KB

-rwxrwxrwx

SpecificPrice.php

30.68 KB

-rwxrwxrwx

SpecificPriceRule.php

13.75 KB

-rwxrwxrwx

State.php

7.39 KB

-rwxrwxrwx

Store.php

6.32 KB

-rwxrwxrwx

Supplier.php

17.76 KB

-rwxrwxrwx

SupplierAddress.php

1.22 KB

-rwxrwxrwx

Tab.php

20.54 KB

-rwxrwxrwx

Tag.php

11.72 KB

-rwxrwxrwx

Tools.php

143.12 KB

-rwxrwxrwx

Translate.php

13.76 KB

-rwxrwxrwx

TranslatedConfiguration.php

4.57 KB

-rwxrwxrwx

Upgrader.php

11.54 KB

-rwxrwxrwx

Uploader.php

11.44 KB

-rwxrwxrwx

Validate.php

33.53 KB

-rwxrwxrwx

ValidateConstraintTranslator.p...

2.85 KB

-rwxrwxrwx

WarehouseAddress.php

1.22 KB

-rwxrwxrwx

Windows.php

1.29 KB

-rwxrwxrwx

Zone.php

3.39 KB

-rwxrwxrwx

index.php

1.29 KB

-rwxrwxrwx

pwnkit

10.99 KB

-rwxr-xr-x

Code Editor : CustomerMessage.php

<?php
/**
 * 2007-2019 PrestaShop and Contributors
 *
 * 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:
 * https://opensource.org/licenses/OSL-3.0
 * 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 https://www.prestashop.com for more information.
 *
 * @author    PrestaShop SA <contact@prestashop.com>
 * @copyright 2007-2019 PrestaShop SA and Contributors
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 * International Registered Trademark & Property of PrestaShop SA
 */

/**
 * Class CustomerMessageCore.
 */
class CustomerMessageCore extends ObjectModel
{
    public $id;
    /** @var int CustomerThread ID */
    public $id_customer_thread;

/** @var   */
    public $id_employee;

/** @var string $message */
    public $message;

/** @var string $file_name */
    public $file_name;

/** @var string $ip_address */
    public $ip_address;

/** @var string $user_agent */
    public $user_agent;

/** @var int $private */
    public $private;

/** @var string $date_add */
    public $date_add;

/** @var string $date_upd */
    public $date_upd;

/** @var bool $read */
    public $read;

/**
     * @see ObjectModel::$definition
     */
    public static $definition = array(
        'table' => 'customer_message',
        'primary' => 'id_customer_message',
        'fields' => array(
            'id_employee' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId'),
            'id_customer_thread' => array('type' => self::TYPE_INT),
            'ip_address' => array('type' => self::TYPE_STRING, 'validate' => 'isIp2Long', 'size' => 15),
            'message' => array('type' => self::TYPE_STRING, 'validate' => 'isCleanHtml', 'required' => true, 'size' => 16777216),
            'file_name' => array('type' => self::TYPE_STRING),
            'user_agent' => array('type' => self::TYPE_STRING),
            'private' => array('type' => self::TYPE_INT),
            'date_add' => array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
            'date_upd' => array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
            'read' => array('type' => self::TYPE_BOOL, 'validate' => 'isBool'),
        ),
    );

/** @var array $webserviceParameters */
    protected $webserviceParameters = array(
        'fields' => array(
            'id_employee' => array(
                'xlink_resource' => 'employees',
            ),
            'id_customer_thread' => array(
                'xlink_resource' => 'customer_threads',
            ),
        ),
    );

/**
     * Get CustomerMessages by Order ID.
     *
     * @param int $idOrder Order ID
     * @param bool $private Private
     *
     * @return array|false|mysqli_result|PDOStatement|resource|null
     */
    public static function getMessagesByOrderId($idOrder, $private = true)
    {
        return Db::getInstance()->executeS('
			SELECT cm.*,
				c.`firstname` AS cfirstname,
				c.`lastname` AS clastname,
				e.`firstname` AS efirstname,
				e.`lastname` AS elastname,
				(COUNT(cm.id_customer_message) = 0 AND ct.id_customer != 0) AS is_new_for_me
			FROM `' . _DB_PREFIX_ . 'customer_message` cm
			LEFT JOIN `' . _DB_PREFIX_ . 'customer_thread` ct
				ON ct.`id_customer_thread` = cm.`id_customer_thread`
			LEFT JOIN `' . _DB_PREFIX_ . 'customer` c
				ON ct.`id_customer` = c.`id_customer`
			LEFT OUTER JOIN `' . _DB_PREFIX_ . 'employee` e
				ON e.`id_employee` = cm.`id_employee`
			WHERE ct.id_order = ' . (int) $idOrder . '
			' . (!$private ? 'AND cm.`private` = 0' : '') . '
			GROUP BY cm.id_customer_message
			ORDER BY cm.date_add DESC
		');
    }

/**
     * Get total CustomerMessages.
     *
     * @param string|null $where Additional SQL query
     *
     * @return int Amount of CustomerMessages found
     */
    public static function getTotalCustomerMessages($where = null)
    {
        if (null === $where) {
            return (int) Db::getInstance()->getValue(
                '
				SELECT COUNT(*)
				FROM ' . _DB_PREFIX_ . 'customer_message
				LEFT JOIN `' . _DB_PREFIX_ . 'customer_thread` ct ON (cm.`id_customer_thread` = ct.`id_customer_thread`)
				WHERE 1' . Shop::addSqlRestriction()
            );
        } else {
            return (int) Db::getInstance()->getValue(
                '
				SELECT COUNT(*)
				FROM ' . _DB_PREFIX_ . 'customer_message cm
				LEFT JOIN `' . _DB_PREFIX_ . 'customer_thread` ct ON (cm.`id_customer_thread` = ct.`id_customer_thread`)
				WHERE ' . $where . Shop::addSqlRestriction()
            );
        }
    }

/**
     * Deletes current CustomerMessage from the database.
     *
     * @return bool `true` if delete was successful
     *
     * @throws PrestaShopException
     */
    public function delete()
    {
        if (!empty($this->file_name)) {
            @unlink(_PS_UPLOAD_DIR_ . $this->file_name);
        }

return parent::delete();
    }

/**
     * Get the last message for a thread customer.
     *
     * @param $id_customer_thread   Thread customer reference
     *
     * @return string Last message
     */
    public static function getLastMessageForCustomerThread($id_customer_thread)
    {
        return (string) Db::getInstance()->getValue(
            '
            SELECT message
            FROM ' . _DB_PREFIX_ . 'customer_message
            WHERE id_customer_thread = ' . (int) $id_customer_thread . '
            ORDER BY date_add DESC'
        );
    }
}

${this.title}

Code Editor : CustomerMessage.php