1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66  67  68  69  70  71  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99 100 101 102 103 104 105 106 107 108 

<?php
/* --------------------------------------------------------------
  MagnalisterModuleCenterModule.inc.php 2015-09-24
  Gambio GmbH
  http://www.gambio.de
  Copyright (c) 2015 Gambio GmbH
  Released under the GNU General Public License (Version 2)
  [http://www.gnu.org/licenses/gpl-2.0.html]
  --------------------------------------------------------------
*/

/**
 * Class MagnalisterModuleCenterModule
 *
 * @extends    AbstractModuleCenterModule
 * @category   System
 * @package    Modules
 */
class MagnalisterModuleCenterModule extends AbstractModuleCenterModule
{
    protected function _init()
    {
        $this->title       = $this->languageTextManager->get_text('magnalister_title');
        $this->description = $this->languageTextManager->get_text('magnalister_description');
        $this->sortOrder   = 13490;
    }


    /**
     * Installs the module
     */
    public function install()
    {
        parent::install();

        $this->magnalisterOrderColumn(true);
        $columnsQuery = $this->db->query('DESCRIBE `admin_access` \'magnalister\'');
        if(!$columnsQuery->num_rows())
        {
            $this->db->query('ALTER TABLE `admin_access` ADD `magnalister` INT( 1 ) NOT NULL DEFAULT \'0\';');
        }

        $this->db->set('magnalister', '1')->where('customers_id', '1')->limit(1)->update('admin_access');
        $this->db->set('magnalister', '1')
                 ->where('customers_id', $_SESSION['customer_id'])
                 ->limit(1)
                 ->update('admin_access');

        $this->db->insert('configuration', array(
            'configuration_key'      => 'MODULE_MAGNALISTER_STATUS',
            'configuration_value'    => 'True',
            'configuration_group_id' => '6',
            'sort_order'             => '1',
            'set_function'           => '',
            'date_added'             => 'NOW()'
        ));
        return xtc_href_link('admin.php', 'do=EmbeddedModule/magnalister&update=true');
    }
    
    
    /**
     * Adds or removes the magnalister column in the orders overview.
     *
     * @deprecated This method should be replaced when Gambio provides a generic service method.
     *             https://tracker.gambio-server.net/issues/48136
     *
     * @param bool $blInstall Flag for adding (true) or removing (false) the magnalister column in user_configuration
     *                        table.
     */
    protected function magnalisterOrderColumn ($blInstall) {
        $userConfigurationService = StaticGXCoreLoader::getService('UserConfiguration');
        $activeColumns = json_decode(str_replace('\\"', '"', $userConfigurationService->getUserConfiguration(new IdType(1), 'ordersOverviewSettingsColumns')), true);
        if (!empty($activeColumns) && is_array($activeColumns)) {
            $magnaActiveColumns = array();
            if ($blInstall) { // add magnalister column
                foreach ($activeColumns as $iColumn => $sColumn) {
                    if ($sColumn == 'magnalister') {// already setted
                        $magnaActiveColumns = array();
                        break;
                    }
                    $magnaActiveColumns[] = $sColumn;
                    if ($iColumn == 0) {
                        $magnaActiveColumns[] = 'magnalister';
                    }
                }
            } else if (in_array('magnalister', $activeColumns)) {// remove magnalister column
                $magnaActiveColumns = $activeColumns;
                unset($magnaActiveColumns[array_search('magnalister', $magnaActiveColumns)]);
                $magnaActiveColumns = array_values($magnaActiveColumns); // rebuild index for clean json array
            }
            if (!empty($magnaActiveColumns)) {
                $userConfigurationService->setUserConfiguration(new IdType(1), 'ordersOverviewSettingsColumns', str_replace('"', '\\"', json_encode($magnaActiveColumns)));
            }
        }
    }

    /**
     * Uninstalls the module
     */
    public function uninstall()
    {
        parent::uninstall();
        
        $this->magnalisterOrderColumn(false);
        $this->db->query('ALTER TABLE `admin_access` DROP `magnalister`');
        $this->db->where_in('configuration_key', 'MODULE_MAGNALISTER_STATUS')->delete('configuration');
    }
}