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 

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

MainFactory::load_class('AdminHttpViewController');

class ShippingPaymentMatrixAjaxController extends AdminHttpViewController
{
    public function actionGetCountryList()
    {
        $db            = StaticGXCoreLoader::getDatabaseQueryBuilder();

        $languageTextManager = MainFactory::create_object('LanguageTextManager', array('countries', $_SESSION['languages_id']));

        $countriesData = $db->select()
                            ->from('countries')
                            ->join('languages', 'countries.countries_iso_code_2 = languages.code', 'left')
                            ->get()
                            ->result_array();
        
        $matrixData = $db->get('shipping_and_payment_matrix')->result_array();
        
        $data = [];
        foreach($countriesData as $country)
        {
            $active  = false;
            $oldData = [];
            
            foreach($matrixData as $matrixDataSet)
            {
                if($country['countries_iso_code_2'] === $matrixDataSet['country_code'])
                {
                    $active                                                                 = true;
                    $oldData[$matrixDataSet['language_id']][$matrixDataSet['country_code']] = [
                        'shippingInfo' => $matrixDataSet['shipping_info'],
                        'shippingTime' => $matrixDataSet['shipping_time'],
                        'paymentInfo'  => $matrixDataSet['payment_info'],
                    ];
                }
            }
            
            $data['countries'][] = [
                'id'         => $country['countries_id'],
                'languageId' => $country['languages_id'],
                'code'       => $country['countries_iso_code_2'],
                'name'       => $languageTextManager->get_text($country['countries_iso_code_2']),
                'active'     => (int)$country['status'] === 1 || $active,
                'data'       => count($oldData) > 0 ? $oldData : null
            ];
        }
        
        $languages = $db->order_by('sort_order')->get('languages')->result_array();
        foreach($languages as $language)
        {
            $data['languages'][] = [
                'id'        => $language['languages_id'],
                'directory' => $language['directory'],
                'code'      => $language['code']
            ];
        }
        
        return MainFactory::create('JsonHttpControllerResponse', $data);
    }
    
    
    public function actionSave()
    {
        $db                  = StaticGXCoreLoader::getDatabaseQueryBuilder();
        $shippingInformation = $this->_getPostData('shipping_info');
        $shippingTimes       = $this->_getPostData('shipping_time');
        $paymentInformation  = $this->_getPostData('payment_info');
        
        $db->truncate('shipping_and_payment_matrix');
        foreach($shippingInformation as $languageId => $shippingInfoData)
        {
            foreach($shippingInfoData as $languageCode => $shippingInfo)
            {
                $db->replace('shipping_and_payment_matrix', [
                    'country_code'  => $languageCode,
                    'language_id'   => $languageId,
                    'shipping_info' => $shippingInfo,
                    'payment_info'  => $paymentInformation[$languageId][$languageCode],
                    'shipping_time' => $shippingTimes[$languageId][$languageCode]
                ]);
            }
        }
        
        return MainFactory::create('JsonHttpControllerResponse', ['success' => true]);
    }
}