citywebshop_cms/application/controllers/admin.php

<?php

class admin extends Controller {
    
    
    //Dashboard
    public function index($action='') {
        $this->isAdmin();
        header("Location: /admin/users");
        die();
    }
    
    
    public function hu($action='') {
        $_SESSION['admin_lang'] = 'hu';
        if ($_REQUEST['redir']!="") {
            header('Location: '.$_REQUEST['redir']);
            die();
        }
    }
    
    
    public function en($action='') {
        $_SESSION['admin_lang'] = 'en';
        if ($_REQUEST['redir']!="") {
            header('Location: '.$_REQUEST['redir']);
            die();
        }
    }

    
    //Check admin user
    public function isAdmin() {
        if ($_SESSION['admin_user']->admin_id=='') {
            header('Location: /admin/login/');
            die();
        }
        else {
            $model = $this->loadModel('admin_login_model');
            $model->reloadProfile();
        }
    }
    
    
    //Login
    public function login($action='') {
        $view = $this->loadView('admin_login');
        $model = $this->loadModel('admin_login_model');
        $forgotView = false;
        
        if ($action=='logmein') {
            if ($model->logmein()) {
                if ($_REQUEST['remember']=='rememberme') {
                    setcookie('kreatin_username',$_REQUEST['email'],time()+31536000);
                    setcookie('kreatin_password',$_REQUEST['pass'],time()+31536000);
                }
                else {
                    setcookie('kreatin_username','',time()+31536000);
                    setcookie('kreatin_password','',time()+31536000);
                }
                header("Location: /admin/dashboard/");
                die();
            }
            else {
                $view->set('login_error',true);
            }
        }
        
        if ($action=='reminder-error') {
            $view->set('reminder_error',true);
            $forgotView = true;
        }
        if ($action=='reminder-sent') {
            $view->set('reminder_message',true);
            $forgotView = true;
        }
        
        
        if ($_COOKIE['kreatin_username']!='') {
            $view->set('remember',' checked');
            $view->set('kreatin_username',$_COOKIE['kreatin_username']);
            $view->set('kreatin_password',$_COOKIE['kreatin_password']);
        }
        
        $view->set('forgotview',$forgotView);

        $view->render();
    }
    
    
    //Logout
    public function logout() {
        $this->isAdmin();
        $_SESSION['admin_lang'] = '';
        $_SESSION['admin_user'] = null;
        $_SESSION['currency'] = '';
        $_SESSION['filters'] = null;
        //$model = $this->loadModel('admin_login_model');
        //$model->logmeout();
        header("Location: /admin/login/");
        die();
    }
    
    
    //Forgot password
    public function forgot($action='') {
        if ($action=='send') {
            $model = $this->loadModel('admin_login_model');
            $reminderData = $model->passwordReminder();
            if ($reminderData!==false) {
                $mail_template = $this->loadView('admin_mail_reminder');
                $mail = new PHPMailer;
                $mail->CharSet = 'UTF-8';
                $mail->From = 'no-reply@mingo.hu';
                $mail->FromName = 'Mingo system';
                $mail->addAddress($reminderData->admin_email);
                $mail->isHTML(true);
                $mail->Subject = lang::_('Password reminder');
                
                $mail_template->set('name',$reminderData->admin_name);
                $mail_template->set('username',$reminderData->admin_email);
                $mail_template->set('password',$reminderData->admin_pass);
                
                $mail->Body = $mail_template->getHTML();
                
                $mail->send();
                
                self::login('reminder-sent');
            }
            else {
                self::login('reminder-error');
            }
        }
    }
    
    
    //Admin users manager
    public function admins($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_admins_model');
        $view = $this->loadView('admin_admins');
        $api = $this->loadModel('api_model');
        
        if ($action=='save') {
            $model->saveAdmin();
            admin_utils::reloadAccount();
            $view->set('error',true);
        }
        
        if ($action=='notifications') {
            $model->set_notifications($_REQUEST['id']);
            exit;
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadAdmin());
        }
        
        if ($action=='delete') {
            $model->deleteAdmin();
        }
        
        $admins = $model->getAdmins();
        
        if ($admins!==false) {
            $view->set('admins',$admins);
        }
        else {
            $view->set('admins','<tr><td colspan="6">'.lang::_('Actually no active admin users in databse').'</td></tr>');
        }

        $view->set('hotels', $api->getHotels(true));
        
        $view->render();
    }
    
    
    //Admin user profile editor
    public function myprofile($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_admins_model');
        $view = $this->loadView('admin_myprofile');
        
        $_REQUEST['id'] = $_SESSION['admin_user']->admin_id;

        if ($action=='save') {
            $model->saveAdmin();
            admin_utils::reloadAccount();
        }
        
        $view->set('active',$model->loadAdmin());
        $view->render();
    }
    
    
    public function roles($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_roles_model');
        $view = $this->loadView('admin_roles');
        
        if ($action=='save') {
            $model->saveRole();
            $view->set('active',$model->loadRole($model->getLastInsertID()));
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadRole());
        }
        
        if ($action=='delete') {
            $model->deleteRole();
        }
        
        if ($action=='set') {
            $model->setModuleRole();
        }
        
        $roles = $model->getRoles();
        
        if ($roles!==false) {
            $view->set('roles',$roles);
        }
        else {
            $view->set('roles','<tr><td colspan="6">'.lang::_('Actually no active admin role in databse').'</td></tr>');
        }
        
        $view->render();
    }
    
    
    //Users management
    public function users($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_users_model');
        $view = $this->loadView('admin_users');
        
        if ($action=='save') {
            $model->saveUser();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active_item',$model->loadUser());
        }
        
        if ($action=='delete') {
            $model->deleteUser();
        }
        
        if ($action=='set') {
            $model->setUserState();
        }
        
        if ($action=='setdefaultmailer') {
            $model->setUserDefaultMailerState();
        }
        
        $users = $model->getUsers();
        $view->set('users',$users);
        
        $view->render();
    }
    
    
    public function orders($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_orders_model');
        $view = $this->loadView('admin_orders');
        
        if ($action=='show') {
            $view->set('active_item',$model->loadOrder());
            $view->set('cart',$model->loadCart());
        }
        
        if ($action=='delete') {
            $model->deleteOrder($_REQUEST['id']);
            header("Location: /admin/orders");
            die();
        }
        
        if ($action=='deletecart') {
            $model->deleteCartItem($_REQUEST['cid']);
            header("Location: /admin/orders/show/?id=".$_REQUEST['id']."#editor");
            die();
        }
        
        if ($action=='set') {
            $model->setOrderState($_REQUEST['id'],$_REQUEST['state']);
        }
        
        $orders = $model->getOrders();
        $view->set('orders',$orders);
        
        $view->render();
    }
    
    
    //System settings editor
    public function settings($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_settings_model');
        $view = $this->loadView('admin_settings');
        
        if ($action=='save') {
            $model->saveSettings();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadSettings());
        }
        
        if ($action=='delete') {
            $model->deleteSettings();
        }
        
        $settings = $model->getSettings();
        $view->set('settings',$settings);
        
        $view->render();
    }
    
    
    //Translation management
    public function translator($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_translator_model');
        $view = $this->loadView('admin_translator');
        
        if ($action=='set') {
            $model->saveTranslate();
        }
        
        $translations = $model->getTranslations();
        $view->set('translations',$translations);
        $view->set('languages',$model->getLanguages());

        $view->render();
    }

    
    public function slideshow($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_slideshow_model');
        $view = $this->loadView('admin_slideshow');
        
        if ($action=='save') {
            $model->saveImage();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadImage());
        }
        
        if ($action=='delete') {
            $model->deleteImage();
        }
        
        $images = $model->getImages();
        $view->set('images',$images);
        
        $view->render();
    }

  
    public function productsOld($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_products_model');
        $view = $this->loadView('admin_products');
        
        if ($action=='save') {
            $model->saveImage();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadImage());
        }
        
        if ($action=='delete') {
            $model->deleteImage();
        }
        
        $images = $model->getImages();
        $view->set('images',$images);
      	$view->set('products', $model->getProductsAPI());
        
        $view->render();
    }

    
    public function news($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_news_model');
        $view = $this->loadView('admin_news');
        
        if ($action=='save') {
            $model->saveImage();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadImage());
        }
        
        if ($action=='delete') {
            $model->deleteImage();
        }
        
        $images = $model->getImages();
        $view->set('images',$images);
        
        $view->render();
    }


    public function boxes($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_boxes_model');
        $view = $this->loadView('admin_boxes');
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadBox());
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes();
        $view->set('boxes',$boxes);
        
        $view->render();
    }

    public function menueditor($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_menueditor_model');
        $view = $this->loadView('admin_menueditor');
        
        if ($action=='save') {
            $model->saveMenu();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadMenu());
        }
        
        if ($action=='delete') {
            $model->deleteMenu();
        }
        
        $menus = $model->getMenus();
        $view->set('menus',$menus);
        
        $view->render();
    }

    public function boarding($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_boarding_model');
        $view = $this->loadView('admin_boarding');
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadBox());
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes();
        $view->set('boxes',$boxes);
        
        $view->render();
    }

    public function blocks($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_blocks_model');
        $view = $this->loadView('admin_blocks');
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadBox());
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes();
        $view->set('boxes',$boxes);
        
        $view->render();
    }

    public function reviews($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_reviews_model');
        $view = $this->loadView('admin_reviews');
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadBox());
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes();
        $view->set('boxes',$boxes);
        
        $view->render();
    }

    public function faq($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_faq_model');
        $view = $this->loadView('admin_faq');
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadBox());
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes();
        $view->set('boxes',$boxes);
        
        $view->render();
    }

    public function services($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_services_model');
        $apimodel = $this->loadModel('api_model');
        $view = $this->loadView('admin_services');

        $services = $apimodel->getGroupsList();
        $view->set('services', $services);
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadBox());
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes();
        $view->set('boxes',$boxes);
        
        $view->render();
    }

    public function packages($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_packages_model');
        $apimodel = $this->loadModel('api_model');
        $view = $this->loadView('admin_packages');

        if ($_REQUEST['eventID'] != '') {
            $_SESSION['eventID'] = $_REQUEST['eventID'];
        }

        $services = $apimodel->getGroupsList();
        $view->set('services', $services);

        if ($action == 'subpage' || $action=='show' || $action=='view') {
            if ($_REQUEST['block_action'] == 'addBlock') {
                $model->addBlock();
            }
            if ($_REQUEST['block_action'] == 'updateBlock') {
                $model->updateBlock();
            }
            if ($_REQUEST['block_action'] == 'deleteBlock') {
                $model->deleteBlock();
            }
            if ($_REQUEST['move'] == 'up') {
                $model->moveBlock('up');
                header("Location: /admin/packages/subpage/?id=".$_REQUEST['id']."&block_id=".$_REQUEST['block_id']."#newBlock");
                die();
            }
            if ($_REQUEST['move'] == 'down') {
                $model->moveBlock('down');
                header("Location: /admin/packages/subpage/?id=".$_REQUEST['id']."&block_id=".$_REQUEST['block_id']."#newBlock");
                die();
            }
            $box = $model->loadBox();
            if ($action=='view') {
                $view->set('readonly','disabled="true"');
            }
            else {
                $view->set('readonly',"");
            }
            $view->set('active',$box);
            $events = $apimodel->getEventsList($box->parent_service);
            $view->set('events',val: $events);
            $menus = $apimodel->getMenusList($box->parent_event);
            $view->set('menus',$menus);
            $blocks = $model->getPackageBlocks();
            $view->set('blocks', $blocks);
            if ($_REQUEST['block_id'] != '') {
                $view->set('blockdata',$model->loadBlock($_REQUEST['block_id']));
            }
        }
        else {
            $view->set('readonly',"");
        }
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes($_SESSION['eventID']);
        foreach ($boxes as $box) {
            $box->box_event_name = $apimodel->getEventName($box->parent_service, $box->parent_event);
            $checkBlock = $model->getPackageBlocks($box->box_id);
            $box->error_status = count($checkBlock)==0 ? '<span style="color: red;">Inactive: <br>No image</span>' : 'Active';
        }
        $view->set('boxes',$boxes);
        $view->set('eventSearchOptions', $apimodel->getEventsRawList());
        $blocks = $model->getPackageBlocks($_REQUEST);
        
        $view->render();
    }

    public function events($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_events_model');
        $apimodel = $this->loadModel('api_model');
        $view = $this->loadView('admin_events');

        $services = $apimodel->getGroupsList();
        $view->set('services', $services);

        if ($action == 'subpage' || $action=='show') {
            if ($_REQUEST['block_action'] == 'addBlock') {
                $model->addBlock();
            }
            if ($_REQUEST['block_action'] == 'updateBlock') {
                $model->updateBlock();
            }
            if ($_REQUEST['block_action'] == 'deleteBlock') {
                $model->deleteBlock();
            }
            if ($_REQUEST['move'] == 'up') {
                $model->moveBlock('up');
                header("Location: /admin/events/subpage/?id=".$_REQUEST['id']."&block_id=".$_REQUEST['block_id']."#newBlock");
                die();
            }
            if ($_REQUEST['move'] == 'down') {
                $model->moveBlock('down');
                header("Location: /admin/events/subpage/?id=".$_REQUEST['id']."&block_id=".$_REQUEST['block_id']."#newBlock");
                die();
            }
            $box = $model->loadBox();
            $view->set('active',$box);
            $events = $apimodel->getEventsList($box->parent_service);
            $view->set('events',$events);
            $menus = $apimodel->getMenusList($box->parent_event);
            $view->set('menus',$menus);
            $blocks = $model->getPackageBlocks();
            $view->set('blocks', $blocks);
            if ($_REQUEST['block_id'] != '') {
                $view->set('blockdata',$model->loadBlock($_REQUEST['block_id']));
            }
        }
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes();
        $view->set('boxes',$boxes);
        $blocks = $model->getPackageBlocks($_REQUEST);
        
        $view->render();
    }


    public function prods($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_prods_model');
        $apimodel = $this->loadModel('api_model');
        $view = $this->loadView('admin_prods');

        $services = $apimodel->getGroupsList();
        $view->set('services', $services);

        if ($action == 'subpage' || $action=='show') {
            if ($_REQUEST['block_action'] == 'addBlock') {
                $model->addBlock();
            }
            if ($_REQUEST['block_action'] == 'updateBlock') {
                $model->updateBlock();
            }
            if ($_REQUEST['block_action'] == 'deleteBlock') {
                $model->deleteBlock();
            }
            if ($_REQUEST['move'] == 'up') {
                $model->moveBlock('up');
                header("Location: /admin/prods/subpage/?id=".$_REQUEST['id']."&block_id=".$_REQUEST['block_id']."#newBlock");
                die();
            }
            if ($_REQUEST['move'] == 'down') {
                $model->moveBlock('down');
                header("Location: /admin/prods/subpage/?id=".$_REQUEST['id']."&block_id=".$_REQUEST['block_id']."#newBlock");
                die();
            }
            $box = $model->loadBox();
            $view->set('active',$box);
            $products = $apimodel->getProductsList($box->parent_service);
            $view->set('products',$products);
            $blocks = $model->getPackageBlocks();
            $view->set('blocks', $blocks);
            if ($_REQUEST['block_id'] != '') {
                $view->set('blockdata',$model->loadBlock($_REQUEST['block_id']));
            }
        }
        
        if ($action=='save') {
            $model->saveBox();
            $view->set('error',true);
        }
        
        if ($action=='delete') {
            $model->deleteBox();
        }
        
        $boxes = $model->getBoxes();
        foreach ($boxes as $box) {
            $box->group = $apimodel->getGroupNameByID($box->parent_service);
        }
        $view->set('boxes',$boxes);
        $blocks = $model->getPackageBlocks($_REQUEST);
        
        $view->render();
    }


    public function quicktext($action = '') {
        $model = $this->loadModel('admin_text_pages_model');
        if ($action == 'save') {
            $model->saveText($_REQUEST['id'], $_REQUEST['field'], $_REQUEST['text']);
        }
        echo true;
    }

    
    public function pages($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_pages_model');
        $view = $this->loadView('admin_pages');
        
        if ($action=='save') {
            $model->savePage();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadPage());
        }
        
        if ($action=='delete') {
            $model->deletePage();
        }
        
        $pages = $model->getPages();
        $view->set('pages',$pages);
        
        $view->render();
    }

    public function textpages($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_text_pages_model');
        $view = $this->loadView('admin_text_pages');
        
        if ($action=='save') {
            $model->savePage();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadPage());
        }
        
        if ($action=='delete') {
            $model->deletePage();
        }
        
        $pages = $model->getPages();
        $view->set('pages',$pages);
        $view->render();
    }

    public function blog($action='') {
        $this->isAdmin();
        
        $model = $this->loadModel('admin_blog_model');
        $view = $this->loadView('admin_blog');

        if ($_REQUEST['filter'] != '') {
            $_SESSION['catfilter'] = $_REQUEST['filter'];
        }
        else {
            $_SESSION['catfilter'] = 'csapattagok';
        }

        if ($action == 'setstate') {
            $model->setArticeState($_REQUEST['id'], $_REQUEST['state']);
            echo 'ok';
        }
        
        if ($action=='save') {
            $model->saveBlog();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadBlog());
        }
        
        if ($action=='delete') {
            $model->deleteBlog();
        }
        
        $pages = $model->getBlog();
        $view->set('pages',$pages);
        
        $view->render();
    }
    
    public function seo($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_seo_model');
        $view = $this->loadView('admin_seo');
        
        if ($action=='save') {
            $model->saveSeo();
            $view->set('error',true);
        }
        
        if ($action=='show') {
            $view->set('active',$model->loadSeo());
        }
        
        if ($action=='delete') {
            $model->deleteSeo();
        }
        
        $seo = $model->getSeo();
        $view->set('seo',$seo);
        
        $view->render();
    }

    
    public function profiles($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_profiles_model');
        $view = $this->loadView('admin_profiles');
        
        if ($action=='save') {
            $design_id = $model->saveProfile();
            if ($design_id!='') {
                $action = 'show';
                $_REQUEST['id'] = $design_id;
            }
            $view->set('error',true);
        }
        
        if ($action=='set') {
            $model->setProfileStatus();
        }
        
        if ($action=='delete') {
            $model->deleteProfile();
        }
        
        if ($action=='search') {
            if ($_REQUEST['keyword']=='') {
                $_SESSION['keyword'] = '';
                $profiles = $model->getProfiles();
            }
            else {
                $_SESSION['keyword'] = $_REQUEST['keyword'];
                $profiles = $model->searchProfiles($_SESSION['keyword']);
            }
        }
        else {
            if ($_SESSION['keyword']=='') {
                $profiles = $model->getProfiles();
            }
            else {
                $profiles = $model->searchProfiles($_SESSION['keyword']);
            }
        }
        
        $view->set('profiles',$profiles);
        $view->set('action',$action);
        
        if ($action=='show') {
            $view->set('active',$model->loadProfile());
            $view->set('user',$model->loadUserProfile());
            $view->set('designs',$model->getUserDesigns());
            $model = $this->loadModel('admin_galery_model');
            $view->set('images',$model->listGalery());
        }
        
        $view->render();
    }
    
    
    public function bigdata($action='') {
        if ($action=='bigdatastart') {
            echo bigdata::startDataSession($_REQUEST['data']);
            die();
        }
        elseif ($action=='bigdatafinish') {
            sleep(1);
            echo bigdata::appendDataSession($_REQUEST['data'],$_REQUEST['temp_file']);
            die();
        }
    }
    
    
    public function todo($action='') {
        $this->isAdmin();

        $model = $this->loadModel('admin_todo_model');
        if ($action=='add') {
            $model->add_todo($_REQUEST);
            die('ok');
        }
        elseif ($action=='delete') {
            $model->delete_todo($_REQUEST);
            die('ok');
        }
        elseif ($action=='finish') {
            $model->finish_todo($_REQUEST);
            die('ok');
        }
    }


    public function dashboard($action='') {
        $this->isAdmin();
        $api = $this->loadModel('api_model');
        $view = $this->loadView('admin_dashboard');
        $view->set('reports', $api->getReports());
        $view->render();
    }
    

    public function exportXLSX($fname,$model) {
        $data = $model->get_export_costs_list();
        
//        $excel = new PHPExcel();
//        
//        $excel->getProperties()->setCreator("Smart Circle");
//        $excel->getProperties()->setLastModifiedBy("Smart Circle");
//        $excel->getProperties()->setTitle("Data export");
//        $excel->getProperties()->setSubject("Smart Cricle - Költség lista export");
//        $excel->getProperties()->setDescription("Smart Cricle - Költség lista export");
//        
//        $excel->setActiveSheetIndex(0);
//        $excel->getActiveSheet()->setTitle('Költség lista');
//        
//        $excel->getActiveSheet()->fromArray($data,NULL,'A1');
//        
//        $export = new PHPExcel_Writer_Excel2007($excel);
//        $export->save('static/exports/'.$fname);
        $sorok = '';
        
        foreach ($data as $row) {
            foreach ($row as $value) {
                $sorok.= $value.";";
            }
            $sorok.= PHP_EOL;
        }
        
        $sorok = utf8_decode($sorok);
        
        file_put_contents('static/exports/'.$fname,$sorok);
        
        echo '/static/exports/'.$fname;
        die();
    }
    
    
    public function download($action='') {
        $filePath = $_REQUEST['file'];
        if(file_exists($filePath)) {
            $fileName = basename($filePath);
            $fileSize = filesize($filePath);
            header("Cache-Control: private");
            header("Content-Type: application/stream");
            header("Content-Length: ".$fileSize);
            header("Content-Disposition: attachment; filename=".$fileName);
            readfile($filePath);
            exit();
        }
        else {
            die('Hiba a fájl letöltésekor...');
        }
    }
    
    
    public function sqltable($action='') {
        $this->isAdmin();
        $model = $this->loadModel('admin_sqltable_model');
        
        if ($_SESSION['SQLTable_filter_type']=='') $_SESSION['SQLTable_filter_type'] = 'status';
        if ($_SESSION['SQLTable_filter_command']=='') $_SESSION['SQLTable_filter_command'] = 'Aktív';
        
        if ($_REQUEST['filter_type']!='') $_SESSION['SQLTable_filter_type'] = $_REQUEST['filter_type'];
        if ($_REQUEST['filter_command']!='') $_SESSION['SQLTable_filter_command'] = $_REQUEST['filter_command'];
        
        if ($_REQUEST['search']!='') $_SESSION['sqltable_search'] = $_REQUEST['search'];
        if ($_REQUEST['keywords']!='') $_SESSION['sqltable_keywords'] = $_REQUEST['keywords'];
        
        if ($_REQUEST['subaction']=='delete') {
            //nast::add_log($_SESSION['admin_user']->admin_real_name,'Törlés',$_SESSION['amodule'],$_SERVER['REMOTE_ADDR']);
            $model->delete_row($_REQUEST);
        }

        if ($_REQUEST['subaction']=='undelete') {
            //nast::add_log($_SESSION['admin_user']->admin_real_name,'Sor visszaállítása',$_SESSION['amodule'],$_SERVER['REMOTE_ADDR']);
            $model->undelete_row($_REQUEST);
        }

        if ($action=='reorder') {
            $model->reorder_table($_REQUEST);
        }
        
        if ($action=='list') {
            $view = $this->loadView($_REQUEST['template']);
            $result = $model->get_list($_REQUEST);
            $view->set('list',$result['rows']);
            $response['list'] = $view->getHTML();
            
            $view = $this->loadView('admin_sqltable_paginator');
            $view->set('pages',$result['pages']);
            $view->set('active_page',$_SESSION['active_page']);
            $response['paginator'] = $view->getHTML();
            $response['pagesnum'] = $result['pages'];
        }
        
        echo json_encode($response);
        exit();
    }
    
    
    public function crawlerlogs($action='') {
        $model = $this->loadModel('crawler_model');
        
        if ($_SESSION['SQLTable_page_limit']=='') $_SESSION['SQLTable_page_limit'] = 20;
        
        if ($action=='') {
            $view = $this->loadView('crawler_view');
        }
        elseif ($action=='edit') {
            $view = $this->loadView('crawler_edit_view');
            $view->set('row',$model->get_crawler_log_row($_REQUEST['id']));
        }
        elseif ($action=='save') {
            $model->update_crawler_log($_REQUEST);
            header("Location: /admin/crawlerlogs");
            die();
        }
        elseif ($action=='delete') {
            $model->delete_crawler_log($_REQUEST['id']);
            header("Location: /admin/crawlerlogs");
            die();
        }
        
        $view->render();
    }
    
    
    public function releaselogs($action='') {
        $model = $this->loadModel('crawler_model');
        
        if ($_SESSION['SQLTable_page_limit']=='') $_SESSION['SQLTable_page_limit'] = 20;
        
        if ($action=='') {
            $view = $this->loadView('release_view');
        }
        elseif ($action=='delete') {
            $model->delete_release_log($_REQUEST['id']);
            header("Location: /admin/releaselogs");
            die();
        }
        
        $view->render();
    }
    
    
    public function monitoring($action='') {
        $model = $this->loadModel('crawler_model');
        $api = $this->loadModel('api_model');
        $view = $this->loadView('monitoring_view');
        $view->set('hotels', $api->getHotels(true));
        $view->render();
    }
    
    public function ertekkeszlet($action='') {
        $model = $this->loadModel('ertekkeszlet_model');
        
        if ($_REQUEST['kategoria']!='' || $_REQUEST['new_kategoria']!='') {
            $_SESSION['kategoria'] = $_REQUEST['kategoria'];
            $_SESSION['mezo'] = '';
        }
        
        if ($_REQUEST['mezo']!='') $_SESSION['mezo'] = $_REQUEST['mezo'];
        
        if ($_REQUEST['kategoria']=='0') { $_SESSION['kategoria'] = ''; $_SESSION['mezo'] = ''; }
        if ($_REQUEST['mezo']=='0') $_SESSION['mezo'] = '';
        
        if ($action=='insert') {
            $model->insert_ertek($_REQUEST);
            exit;
        }
        else if ($action=='refresh_mezo') {
            echo $model->select_mezo($_REQUEST['new_kategoria']);
            exit;
        }
        else if ($action=='delete') {
            $model->delete_row($_REQUEST['id']);
            exit;
        }
        else if ($action=='update') {
            $model->update_row($_REQUEST['val'],$_REQUEST['id']);
            exit;
        }
        else if ($action=='field') {
            $model->update_field($_REQUEST['field'],$_REQUEST['val'],$_REQUEST['id']);
            exit;
        }
        else {
            $view = $this->loadView('ertekkeszlet_view');
            $view->set('kategoriak',$model->get_kategoria_list($_SESSION['kategoria']));
            $view->set('mezok',$model->get_mezo_list($_SESSION['kategoria'],$_SESSION['mezo']));
            $view->set('list',$model->get_ertekkeszlet_list($_SESSION['kategoria'],$_SESSION['mezo']));
        }
        
        $view->render();
    }
    
    
    public function azonositas($action='') {
        $model = $this->loadModel('ertekkeszlet_model');
        $view = $this->loadView('azonositas_view');
        
        if ($_REQUEST['kategoria']!='' || $_REQUEST['new_kategoria']!='') {
            $_SESSION['kategoria'] = $_REQUEST['kategoria'];
            $_SESSION['mezo'] = '';
        }
        
        if ($_REQUEST['mezo']!='') $_SESSION['mezo'] = $_REQUEST['mezo'];
        
        if ($_REQUEST['kategoria']=='0') { $_SESSION['kategoria'] = ''; $_SESSION['mezo'] = ''; }
        if ($_REQUEST['mezo']=='0') $_SESSION['mezo'] = '';
        
        if ($action=='update') {
            $model->update_azonositas($_REQUEST['bazis'],$_REQUEST['ertek']);
            exit;
        }
        
        $view->set('kategoriak',$model->get_kategoria_list($_SESSION['kategoria']));
        $view->set('mezok',$model->get_mezo_list($_SESSION['kategoria'],$_SESSION['mezo']));
        if ($_SESSION['kategoria']!='') {
            $view->set('list',$model->get_tultip_list($_SESSION['kategoria'],$_SESSION['mezo']));
        }
        else {
            $view->set('list',null);
        }

        $view->render();
    }
    
    
    public function factors($action='') {
        $model = $this->loadModel('factors_model');
        $view = $this->loadView('admin_factors_view');
        
        if ($action=='save') {
            $model->save_factor($_REQUEST);
        }
        
        $view->set('categories',$model->get_categories());
        
        $view->render();
    }


    public function irodak($action='') {
        $model = $this->loadModel('admin_irodak_model');

        if ($action=='irodakereses') {
            $view = $this->loadView('admin_iroda_kereso_view');
            $view->set('offices',$model->getOffices());
            $view->render();
            die();
        }

        if ($action=='addiroda') {
            echo $model->add_iroda($_REQUEST['id']);
            die();
        }

        if ($action=='setstate') {
            $model->setIrodaState($_REQUEST['id']);
            echo 'ok';
            die();
        }

        $view = $this->loadView('admin_iroda_view');

        if ($_REQUEST['do']=='saveiroda') {
            $result = $model->saveIroda($_REQUEST);
            if ($result==false) {
                $view->set('error','yes');
            }
            else {
                $view->set('error','no');
            }
        }

        if ($action=='delete') {
            $model->deleteIroda($_REQUEST['id']);
        }

        if ($action=='edit') {
            $iroda = $model->getIroda($_REQUEST['id']);
            $view->set('active',$iroda);
        }

        $view->set('irodak',$model->getIrodaList());
        $view->set('action',$action);
        $view->render();
    }


    public function ertekeles($action='') {
        $model = $this->loadModel('admin_ertekeles_model');

        if ($action=='referenskereses') {
            $view = $this->loadView('admin_referens_kereso_view');
            $view->set('agents',$model->getAgents());
            $view->render();
            die();
        }

        if ($action=='addreferens') {
            echo $model->add_referens($_REQUEST['id']);
            die();
        }

        $view = $this->loadView('admin_ertekeles_view');

        if ($_REQUEST['do']=='saveertekeles') {
            $model->saveErtekeles($_REQUEST);
            $view->set('error','no');
        }

        if ($_REQUEST['do']=='savevelemenyek') {
            $model->saveVelemeny($_REQUEST);
            $view->set('error','no');
        }

        if ($_REQUEST['do']=='editvelemeny') {
            $view->set('velemeny',$model->getVelemeny($_REQUEST['velemenyid']));
        }

        if ($_REQUEST['do']=='deletevelemeny') {
            $model->deleteVelemeny($_REQUEST['velemenyid']);

        }

        if ($action=='delete') {
            $model->deleteReferens($_REQUEST['id']);
        }

        if ($action=='edit') {
            $referens = $model->getReferens($_REQUEST['id']);
            $view->set('active',$referens);
            $view->set('velemenyek',$model->getVelemenyek($_REQUEST['id']));
        }

        $view->set('referensek',$model->getReferensList());
        $view->set('action',$action);
        $view->render();
    }
        
    
}