hotel_commerce/modules/wkhotelroom/classes/WkHotelRoomDisplay.php

<?php
/**
* 2010-2020 Webkul.
*
* NOTICE OF LICENSE
*
* All right is reserved,
* Please go through this link for complete license : https://store.webkul.com/license.html
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade this module to newer
* versions in the future. If you wish to customize this module for your
* needs please refer to https://store.webkul.com/customisation-guidelines/ for more information.
*
*  @author    Webkul IN <support@webkul.com>
*  @copyright 2010-2020 Webkul IN
*  @license   https://store.webkul.com/license.html
*/

class WkHotelRoomDisplay extends ObjectModel
{
    public $id_product;
    public $active;
    public $position;
    public $date_add;
    public $date_upd;

    public static $definition = array(
        'table' => 'htl_room_block_data',
        'primary' => 'id_room_block',
        'fields' => array(
            'id_product' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId'),
            'active' => array('type' => self::TYPE_BOOL, 'validate' => 'isBool'),
            'position' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'),
            'date_add' => array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
            'date_upd' => array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
    ));

    public function gerRoomByIdProduct($id_product)
    {
        return DB::getInstance()->getRow(
            'SELECT * FROM `'._DB_PREFIX_.'htl_room_block_data` WHERE `id_product` = '.(int)$id_product
        );
    }

    public function getHotelRoomDisplayData($active = true)
    {
        $sql = 'SELECT * FROM `'._DB_PREFIX_.'htl_room_block_data` WHERE 1';
        if ($active !== false) {
            $sql .= ' AND `active` = '.(int)$active;
        }
        $sql .= ' ORDER BY `position`';

        $result = DB::getInstance()->executeS($sql);
        if ($result) {
            return $result;
        }
        return false;
    }

    public function checkRoomTypeAlreadySelected($id_product, $idRoomDisplayBlock)
    {
        $sql = 'SELECT * FROM `'._DB_PREFIX_.'htl_room_block_data` WHERE `id_product` = '.(int)$id_product;
        if ($idRoomDisplayBlock) {
            $sql .= ' AND `id_room_block` != '.(int)$idRoomDisplayBlock;
        }
        $result = DB::getInstance()->getRow($sql);
        if ($result) {
            return $result;
        }
        return false;
    }

    public function deleteRoomByIdProduct($id_product)
    {
        return Db::getInstance()->delete('htl_room_block_data', 'id_product = '.(int)$id_product);
    }

    public function delete()
    {
        $return = parent::delete();
        /* Reinitializing position */
        $this->cleanPositions();
        return $return;
    }

    public function getHigherPosition()
    {
        $position = DB::getInstance()->getValue(
            'SELECT MAX(`position`) FROM `'._DB_PREFIX_.'htl_room_block_data`'
        );
        $result = (is_numeric($position)) ? $position : -1;
        return $result + 1;
    }

    public function updatePosition($way, $position)
    {
        if (!$result = Db::getInstance()->executeS(
            'SELECT htb.`id_room_block`, htb.`position` FROM `'._DB_PREFIX_.'htl_room_block_data` htb
            WHERE htb.`id_room_block` = '.(int) $this->id.' ORDER BY `position` ASC'
        )
        ) {
            return false;
        }

        $movedBlock = false;
        foreach ($result as $block) {
            if ((int)$block['id_room_block'] == (int)$this->id) {
                $movedBlock = $block;
            }
        }

        if ($movedBlock === false) {
            return false;
        }
        return (Db::getInstance()->execute(
            'UPDATE `'._DB_PREFIX_.'htl_room_block_data` SET `position`= `position` '.($way ? '- 1' : '+ 1').
            ' WHERE `position`'.($way ? '> '.
            (int)$movedBlock['position'].' AND `position` <= '.(int)$position : '< '
            .(int)$movedBlock['position'].' AND `position` >= '.(int)$position)
        ) && Db::getInstance()->execute(
            'UPDATE `'._DB_PREFIX_.'htl_room_block_data`
            SET `position` = '.(int)$position.'
            WHERE `id_room_block`='.(int)$movedBlock['id_room_block']
        ));
    }

    /**
     * Reorder blocks position
     * Call it after deleting a blocks.
     * @return bool $return
     */
    public function cleanPositions()
    {
        Db::getInstance()->execute('SET @i = -1', false);
        $sql = 'UPDATE `'._DB_PREFIX_.'htl_room_block_data` SET `position` = @i:=@i+1 ORDER BY `position` ASC';
        return (bool) Db::getInstance()->execute($sql);
    }

    // enter the default demo data of the module
    public function insertModuleDemoData()
    {
        $languages = Language::getLanguages(false);
        $HOTEL_ROOM_DISPLAY_HEADING = array();
        $HOTEL_ROOM_DISPLAY_DESCRIPTION = array();
        foreach ($languages as $lang) {
            $HOTEL_ROOM_DISPLAY_HEADING[$lang['id_lang']] = 'Our Rooms';
            $HOTEL_ROOM_DISPLAY_DESCRIPTION[$lang['id_lang']] = 'Families travelling with kids will find Amboseli national park a safari destination matched to no other, with less tourist traffic, breathtaking open space.';
        }

        // update global configuration values in multilang
        Configuration::updateValue('HOTEL_ROOM_DISPLAY_HEADING', $HOTEL_ROOM_DISPLAY_HEADING);
        Configuration::updateValue('HOTEL_ROOM_DISPLAY_DESCRIPTION', $HOTEL_ROOM_DISPLAY_DESCRIPTION);
        if ($roomTypes = HotelHelper::getPsProducts(Configuration::get('PS_LANG_DEFAULT'), 0, 5)) {
            foreach ($roomTypes as $product) {
                if (Validate::isLoadedObject($objProduct = new Product($product['id_product']))) {
                    $objRoomBlock = new WkHotelRoomDisplay();
                    $objRoomBlock->id_product = $product['id_product'];
                    $objRoomBlock->position = $this->getHigherPosition();
                    $objRoomBlock->active = $objProduct->active;
                    $objRoomBlock->save();
                }
            }
        }
        return true;
    }
}