<?php
/**
 * mitrocops
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the EULA
 * that is bundled with this package in the file LICENSE.txt.
 *
/*
 *
 * @author    mitrocops
 * @category content_management
 * @package reviewsadv
 * @copyright Copyright mitrocops
 * @license   mitrocops
 */

function upgrade_module_1_2_2($module)
{
	$name_module = 'reviewsadv';
    $prefix = 'r';

    Configuration::updateValue($name_module.'crondelay'.$prefix, 10);
    Configuration::updateValue($name_module.'cronnpost'.$prefix, 20);

    Configuration::updateValue($name_module.'remrevsec'.$prefix, 0);
    Configuration::updateValue($name_module.'delaysec'.$prefix, 7);
    Configuration::updateValue($name_module.'remindersec'.$prefix, 0);


    Configuration::updateValue($name_module.'is_avatar'.$prefix, 1);
    Configuration::updateValue($name_module.'is_files'.$prefix, 1);
    Configuration::updateValue($name_module.'ruploadfiles', 7);
    Configuration::updateValue($name_module.'rminc', 20);
    Configuration::updateValue($name_module.'is_onerev', 1);


    $languages = Language::getLanguages(false);
    foreach ($languages as $language){
        $i = $language['id_lang'];
        Configuration::updateValue($name_module.'reminderok'.$prefix.'_'.$i, 'The emails requests on the reviews was successfully sent');
        Configuration::updateValue($name_module.'thankyou'.$prefix.'_'.$i, 'Thank you for your review');
        Configuration::updateValue($name_module.'newrev'.$prefix.'_'.$i, 'New review');
        Configuration::updateValue($name_module.'modrev'.$prefix.'_'.$i, 'One of your customers has modified own product review');
        Configuration::updateValue($name_module.'abuserev'.$prefix.'_'.$i, 'Someone send abuse for review');

        Configuration::updateValue($name_module.'facvouc'.$prefix.'_'.$i, 'You share review on Facebook and get voucher for discount');
        Configuration::updateValue($name_module.'revvouc'.$prefix.'_'.$i, 'You submit a review and get voucher for discount');

        Configuration::updateValue($name_module.'sugvouc'.$prefix.'_'.$i, 'Share your review on Facebook and get voucher for discount');

    }

    if (!defined('_PS_HOST_MODE_')) {
        $module->createFolderAndSetPermissionsAvatar();
        $module->createFolderAndSetPermissionsFiles();
    }


    $module->installUserTable();
    $module->installFiles2ReviewTable();


    Configuration::updateValue($name_module.'is_uprof', 1);

    Configuration::updateValue($name_module.'radv_home', 1);
    Configuration::updateValue($name_module.'radv_footer', 1);
    Configuration::updateValue($name_module.'radv_left', 1);

    Configuration::updateValue($name_module.'rshoppers_blc', 5);
    Configuration::updateValue($name_module.'rpage_shoppers', 16);


    ### add field email in ps_reviewsadv table ####

    $list_fields = Db::getInstance()->executeS('SHOW FIELDS FROM `'._DB_PREFIX_.'reviewsadv`');
    if (is_array($list_fields))
    {
        foreach ($list_fields as $k => $field)
            $list_fields[$k] = $field['Field'];
        if (!in_array('avatar', $list_fields)) {
            if (!Db::getInstance(_PS_USE_SQL_SLAVE_)->Execute('ALTER TABLE `' . _DB_PREFIX_ . 'reviewsadv` ADD `avatar` TEXT;')) {
                return false;
            }

        }
    }

    ### add field email in ps_reviewsadv table ####


    ### add field email in reviewsadv_data_order table ####

    $list_fields = Db::getInstance()->executeS('SHOW FIELDS FROM `'._DB_PREFIX_.'reviewsadv_data_order`');
    if (is_array($list_fields))
    {
        foreach ($list_fields as $k => $field)
            $list_fields[$k] = $field['Field'];
        if (!in_array('date_send', $list_fields)) {
            if (!Db::getInstance(_PS_USE_SQL_SLAVE_)->Execute('ALTER TABLE `' . _DB_PREFIX_ . 'reviewsadv_data_order` ADD `date_send` timestamp NULL;')) {
                return false;
            }

        }
    }


    $list_fields = Db::getInstance()->executeS('SHOW FIELDS FROM `'._DB_PREFIX_.'reviewsadv_data_order`');
    if (is_array($list_fields))
    {
        foreach ($list_fields as $k => $field)
            $list_fields[$k] = $field['Field'];
        if (!in_array('date_send_second', $list_fields)) {
            if (!Db::getInstance(_PS_USE_SQL_SLAVE_)->Execute('ALTER TABLE `' . _DB_PREFIX_ . 'reviewsadv_data_order` ADD `date_send_second` timestamp NULL;')) {
                return false;
            }

        }
    }

    $list_fields = Db::getInstance()->executeS('SHOW FIELDS FROM `'._DB_PREFIX_.'reviewsadv_data_order`');
    if (is_array($list_fields))
    {
        foreach ($list_fields as $k => $field)
            $list_fields[$k] = $field['Field'];
        if (!in_array('count_sent', $list_fields)) {
            if (!Db::getInstance(_PS_USE_SQL_SLAVE_)->Execute('ALTER TABLE `' . _DB_PREFIX_ . 'reviewsadv_data_order` ADD `count_sent` int(10) NOT NULL default \'0\';')) {
                return false;
            }

        }
    }


    ### add field email in reviewsadv_data_order table ####


    $tab_id = Tab::getIdFromClassName("AdminReview");
    if ($tab_id) {
        $tab = new Tab($tab_id);
        $tab->delete();
    }

    $tab_id = Tab::getIdFromClassName("AdminReviews");
    if ($tab_id) {
        $tab = new Tab($tab_id);
        $tab->delete();
    }

    @unlink(_PS_ROOT_DIR_."/img/t/AdminReview.gif");


    $module->createAdminTabs15();


    if(version_compare(_PS_VERSION_, '1.6', '<')) {
        $module->generateRewriteRulesUser();
    }


    return true;
}
?>