<?php

class StickerUpdate
{
    public $update = false;

    public $updateList = array();

    public function __construct()
    {

    }

    public function checkUpdate()
    {
        $this->updateVersion102();
        $this->updateVersion103();
        $this->updateVersion104();
        $this->updateVersion105();
        $this->updateVersion106();
    }

    private function updateVersion102()
    {
        $update102_sql1 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "price_min"');
        if (empty($update102_sql1)) {
            $this->update = true;
            $this->updateList[0] = 'price_min';
        }
        $update102_sql2 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "price_max"');
        if (empty($update102_sql2)) {
            $this->update = true;
            $this->updateList[1] = 'price_max';
        }
    }

    private function updateVersion103()
    {
        $update103_sql1 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers_product` WHERE `Field` = "inherit"');
        if (empty($update103_sql1)) {
            $this->update = true;
            $this->updateList[2] = 'inherit';
        }
    }

    private function updateVersion104()
    {
        $update104_sql1 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "qty_min"');
        if (empty($update104_sql1)) {
            $this->update = true;
            $this->updateList[3] = 'qty_min';
        }
        $update104_sql2 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "qty_max"');
        if (empty($update104_sql2)) {
            $this->update = true;
            $this->updateList[4] = 'qty_max';
        }
        $update104_sql3 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "price_on"');
        if (empty($update104_sql3)) {
            $this->update = true;
            $this->updateList[5] = 'price_on';
        }
        $update104_sql4 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "qty_on"');
        if (empty($update104_sql4)) {
            $this->update = true;
            $this->updateList[6] = 'qty_on';
        }
        $update104_sql5 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "manu_on"');
        if (empty($update104_sql5)) {
            $this->update = true;
            $this->updateList[7] = 'manu_on';
        }
        $update104_sql6 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "id_manufacturer"');
        if (empty($update104_sql6)) {
            $this->update = true;
            $this->updateList[8] = 'id_manufacturer';
        }
    }

    private function updateVersion105()
    {
        $update105_sql1 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "position_price"');
        if (empty($update105_sql1)) {
            $this->update = true;
            $this->updateList[9] = 'position_price';
        }
        $update105_sql2 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "position_qty"');
        if (empty($update105_sql2)) {
            $this->update = true;
            $this->updateList[10] = 'position_qty';
        }
        $update105_sql3 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "position_manu"');
        if (empty($update105_sql3)) {
            $this->update = true;
            $this->updateList[11] = 'position_manu';
        }
        $update105_sql4 = Db::getInstance()->getRow('SELECT * FROM `'._DB_PREFIX_.'phstickers_lang` WHERE `file_name` = "100proc.png"');
        if (empty($update105_sql4)) {
            $this->update = true;
            $this->updateList[12][0] = '100proc.png';
        }
        $update105_sql5 = Db::getInstance()->getRow('SELECT * FROM `'._DB_PREFIX_.'phstickers_lang` WHERE `file_name` = "polecany.png"');
        if (empty($update105_sql5)) {
            $this->update = true;
            $this->updateList[12][1] = 'polecany.png';
        }
    }

    private function updateVersion106()
    {
        $update106_sql1 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "position_new"');
        if (empty($update106_sql1)) {
            $this->update = true;
            $this->updateList[13] = 'position_new';
        }
        $update106_sql2 = Db::getInstance()->executeS('SHOW COLUMNS FROM `'._DB_PREFIX_.'phstickers` WHERE `Field` = "show_new"');
        if (empty($update106_sql2)) {
            $this->update = true;
            $this->updateList[14] = 'show_new';
        }
    }

    public function processUpdate($adminLink)
    {
        if (Tools::getIsset('addPriceMinProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `price_min` DOUBLE(20, 6) NOT NULL AFTER `id_sticker`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addPriceMaxProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `price_max` DOUBLE(20, 6) NOT NULL AFTER `price_min`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addInheritProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers_product` ADD `inherit` int(11) NOT NULL');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addQtyMinProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `qty_min` int(11) NOT NULL AFTER `price_max`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addQtyMaxProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `qty_max` int(11) NOT NULL AFTER `qty_min`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addPriceOnProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `price_on` int(11) NOT NULL AFTER `id_sticker`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addQtyOnProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `qty_on` int(11) NOT NULL AFTER `price_max`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addManuOnProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `manu_on` int(11) NOT NULL AFTER `qty_max`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addIdManuProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `id_manufacturer` int(11) NOT NULL AFTER `manu_on`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addPosPriceProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `position_price` int(11) NOT NULL AFTER `price_max`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addPosQtyProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `position_qty` int(11) NOT NULL AFTER `qty_max`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addPosManuProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `position_manu` int(11) NOT NULL AFTER `id_manufacturer`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addImage105Process')) {
            $naklejki = Tools::getValue('manyImage');
            $naklejkiExp = explode('|', $naklejki);
            if (!empty($naklejkiExp)) {
                foreach ($naklejkiExp as $item) {
                    if (!empty($item)) {
                        Db::getInstance()->insert('phstickers', array(
                            'date_add' => date('Y-m-d H:i:s')
                        ));
                        $id = Db::getInstance()->Insert_ID();
                        Db::getInstance()->insert('phstickers_lang', array(
                            'id_sticker' => (int)$id,
                            'file_name' => $item,
                            'id_lang' => Context::getContext()->cookie->id_lang
                        ));
                    }
                }
            }
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addPosNewProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `position_new` int(11) NOT NULL AFTER `position_manu`');
            Tools::redirect($adminLink.'&conf=4');
        }
        if (Tools::getIsset('addShowNewProcess')) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.'phstickers` ADD `show_new` int(11) NOT NULL AFTER `position_new`');
            Tools::redirect($adminLink.'&conf=4');
        }

    }

}