PATH:
home
/
beestk
/
lpda
/
classes
<?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' ); } }
[+]
..
[-] Tag.php
[open]
[+]
proxy
[-] Translate.php
[open]
[-] Meta.php
[open]
[-] Image.php
[open]
[-] Access.php
[open]
[+]
pdf
[-] Manufacturer.php
[open]
[+]
log
[-] Country.php
[open]
[-] ValidateConstraintTranslator.php
[open]
[-] Dispatcher.php
[open]
[+]
range
[-] DateRange.php
[open]
[-] .htaccess
[open]
[-] Context.php
[open]
[-] PrestaShopBackup.php
[open]
[+]
shop
[-] Media.php
[open]
[-] Pack.php
[open]
[-] LocalizationPack.php
[open]
[-] RequestSql.php
[open]
[-] Windows.php
[open]
[-] Uploader.php
[open]
[+]
db
[-] Search.php
[open]
[-] PrestaShopLogger.php
[open]
[-] Delivery.php
[open]
[-] TranslatedConfiguration.php
[open]
[-] Page.php
[open]
[-] Profile.php
[open]
[+]
exception
[-] Curve.php
[open]
[-] Connection.php
[open]
[+]
container
[-] AddressChecksumCore.php
[open]
[-] Gender.php
[open]
[-] Contact.php
[open]
[+]
module
[-] Store.php
[open]
[-] ProductSupplier.php
[open]
[-] PaymentModule.php
[open]
[+]
tax
[+]
cache
[+]
assets
[+]
form
[-] ProductSale.php
[open]
[-] Hook.php
[open]
[-] CustomerThread.php
[open]
[-] FileUploader.php
[open]
[-] QqUploadedFileXhr.php
[open]
[-] QuickAccess.php
[open]
[+]
controller
[-] CMS.php
[open]
[-] Mail.php
[open]
[-] Carrier.php
[open]
[-] Alias.php
[open]
[-] ProductPresenterFactory.php
[open]
[-] ImageManager.php
[open]
[-] Validate.php
[open]
[-] Tools.php
[open]
[-] Configuration.php
[open]
[-] CSV.php
[open]
[-] ProductAssembler.php
[open]
[-] ConfigurationTest.php
[open]
[-] Cookie.php
[open]
[-] Zone.php
[open]
[-] AddressFormat.php
[open]
[+]
tree
[-] ProductDownload.php
[open]
[-] Link.php
[open]
[-] Chart.php
[open]
[-] Notification.php
[open]
[-] WarehouseAddress.php
[open]
[-] Message.php
[open]
[-] PhpEncryptionLegacyEngine.php
[open]
[-] Language.php
[open]
[-] PhpEncryption.php
[open]
[+]
checkout
[-] Group.php
[open]
[-] ManufacturerAddress.php
[open]
[-] SpecificPrice.php
[open]
[-] Feature.php
[open]
[-] Upgrader.php
[open]
[-] Customer.php
[open]
[-] ObjectModel.php
[open]
[-] SpecificPriceRule.php
[open]
[+]
lang
[-] PrestaShopAutoload.php
[open]
[-] CustomerAddress.php
[open]
[-] FeatureValue.php
[open]
[-] PhpEncryptionEngine.php
[open]
[-] Customization.php
[open]
[-] PrestaShopCollection.php
[open]
[-] CMSRole.php
[open]
[-] GroupReduction.php
[open]
[-] Cart.php
[open]
[-] Attribute.php
[open]
[-] Tab.php
[open]
[-] Currency.php
[open]
[-] index.php
[open]
[-] AttributeGroup.php
[open]
[-] ConnectionsSource.php
[open]
[+]
order
[+]
webservice
[-] Guest.php
[open]
[-] CustomerMessage.php
[open]
[-] ImageType.php
[open]
[-] State.php
[open]
[-] Employee.php
[open]
[-] Risk.php
[open]
[-] ChecksumInterface.php
[open]
[-] Attachment.php
[open]
[-] CartRule.php
[open]
[-] Product.php
[open]
[+]
Smarty
[+]
stock
[-] Referrer.php
[open]
[-] Category.php
[open]
[-] QqUploadedFileForm.php
[open]
[-] PaymentFree.php
[open]
[-] CustomizationField.php
[open]
[-] CMSCategory.php
[open]
[-] SupplierAddress.php
[open]
[-] Combination.php
[open]
[-] ConfigurationKPI.php
[open]
[-] Address.php
[open]
[-] SearchEngine.php
[open]
[+]
helper
[-] Supplier.php
[open]