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 MessageCore. */ class MessageCore extends ObjectModel { public $id; /** @var string message content */ public $message; /** @var int Cart ID (if applicable) */ public $id_cart; /** @var int Order ID (if applicable) */ public $id_order; /** @var int Customer ID (if applicable) */ public $id_customer; /** @var int Employee ID (if applicable) */ public $id_employee; /** @var bool Message is not displayed to the customer */ public $private; /** @var string Object creation date */ public $date_add; /** * @see ObjectModel::$definition */ public static $definition = array( 'table' => 'message', 'primary' => 'id_message', 'fields' => array( 'message' => array('type' => self::TYPE_STRING, 'validate' => 'isCleanHtml', 'required' => true, 'size' => 1600), 'id_cart' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId'), 'id_order' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId'), 'id_customer' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId'), 'id_employee' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId'), 'private' => array('type' => self::TYPE_BOOL, 'validate' => 'isBool'), 'date_add' => array('type' => self::TYPE_DATE, 'validate' => 'isDate'), ), ); protected $webserviceParameters = array( 'fields' => array( 'id_cart' => array( 'xlink_resource' => 'carts', ), 'id_order' => array( 'xlink_resource' => 'orders', ), 'id_customer' => array( 'xlink_resource' => 'customers', ), 'id_employee' => array( 'xlink_resource' => 'employees', ), ), ); /** * Return the last message from cart. * * @param int $idCart Cart ID * * @return array Message */ public static function getMessageByCartId($idCart) { return Db::getInstance()->getRow( ' SELECT * FROM `' . _DB_PREFIX_ . 'message` WHERE `id_cart` = ' . (int) $idCart ); } /** * Return messages from Order ID. * * @param int $idOrder Order ID * @param bool $private return WITH private messages * * @return array Messages */ public static function getMessagesByOrderId($idOrder, $private = false, Context $context = null) { if (!Validate::isBool($private)) { die(Tools::displayError()); } if (!$context) { $context = Context::getContext(); } return Db::getInstance()->executeS(' SELECT m.*, c.`firstname` AS cfirstname, c.`lastname` AS clastname, e.`firstname` AS efirstname, e.`lastname` AS elastname, (COUNT(mr.id_message) = 0 AND m.id_customer != 0) AS is_new_for_me FROM `' . _DB_PREFIX_ . 'message` m LEFT JOIN `' . _DB_PREFIX_ . 'customer` c ON m.`id_customer` = c.`id_customer` LEFT JOIN `' . _DB_PREFIX_ . 'message_readed` mr ON mr.`id_message` = m.`id_message` AND mr.`id_employee` = ' . (isset($context->employee) ? (int) $context->employee->id : '\'\'') . ' LEFT OUTER JOIN `' . _DB_PREFIX_ . 'employee` e ON e.`id_employee` = m.`id_employee` WHERE id_order = ' . (int) $idOrder . ' ' . (!$private ? ' AND m.`private` = 0' : '') . ' GROUP BY m.id_message ORDER BY m.date_add DESC '); } /** * Return messages from Cart ID. * * @param int $id_order Order ID * @param bool $private return WITH private messages * * @return array Messages */ public static function getMessagesByCartId($idCart, $private = false, Context $context = null) { if (!Validate::isBool($private)) { die(Tools::displayError()); } if (!$context) { $context = Context::getContext(); } return Db::getInstance()->executeS(' SELECT m.*, c.`firstname` AS cfirstname, c.`lastname` AS clastname, e.`firstname` AS efirstname, e.`lastname` AS elastname, (COUNT(mr.id_message) = 0 AND m.id_customer != 0) AS is_new_for_me FROM `' . _DB_PREFIX_ . 'message` m LEFT JOIN `' . _DB_PREFIX_ . 'customer` c ON m.`id_customer` = c.`id_customer` LEFT JOIN `' . _DB_PREFIX_ . 'message_readed` mr ON (mr.id_message = m.id_message AND mr.id_employee = ' . (int) $context->employee->id . ') LEFT OUTER JOIN `' . _DB_PREFIX_ . 'employee` e ON e.`id_employee` = m.`id_employee` WHERE id_cart = ' . (int) $idCart . ' ' . (!$private ? ' AND m.`private` = 0' : '') . ' GROUP BY m.id_message ORDER BY m.date_add DESC '); } /** * Registered a message 'readed'. * * @param int $idMessage Message ID * @param int $id_emplyee Employee ID * * @return bool */ public static function markAsReaded($idMessage, $idEmployee) { if (!Validate::isUnsignedId($idMessage) || !Validate::isUnsignedId($idEmployee)) { die(Tools::displayError()); } $result = Db::getInstance()->execute(' INSERT INTO ' . _DB_PREFIX_ . 'message_readed (id_message , id_employee , date_add) VALUES (' . (int) $idMessage . ', ' . (int) $idEmployee . ', NOW()); '); return $result; } }
[+]
..
[-] 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]