citywebshop_cms/application/models/admin_admins_model.php

<?php

class admin_admins_model extends Model {
    
    public function getAdmins() {
        if ($_SESSION['access_level'] == 13) {
            $result = $this->query("select * from azonics_admin_users where admin_status<>'2' and admin_access_level='14' and admin_creator='".$_SESSION['admin_user']->admin_id."' order by admin_name asc;");
        } else {
            $result = $this->query("select * from azonics_admin_users where admin_status<>'2' order by admin_name asc;");
        }
        if (sizeof($result)>0) {
            return $result;
        }
        else {
            return false;
        }
    }
    
    
    public function loadAdmin() {
        $data = $this->escapeArray($_REQUEST);
        $result = $this->query("select * from azonics_admin_users where admin_id='".$data['id']."';");
        return $result[0];
    }
    
    
    public function set_notifications($id) {
        $id = $this->escapeString($id);
        $check = $this->query("select * from azonics_admin_users where admin_id='".$id."';");
        if ($check[0]->admin_notifications=='n') {
            $notif = 'y';
        }
        else {
            $notif = 'n';
        }
        
        $this->execute("UPDATE azonics_admin_users SET admin_notifications='".$notif."' WHERE admin_id='".$id."';");
        
        return true;
    }
    
    
    public function saveAdmin() {
        //$data = $this->escapeArray($_REQUEST);
        $data = $_REQUEST;
        $hotels = explode(',',$data['selectedHotels']);
        if ($data['admin_id']!='') {
            $this->execute("update azonics_admin_users set "
                    . "admin_name='".$data['admin_name']."', "
                    . "admin_email='".$data['admin_email']."', "
                    . "admin_access_level='".$data['admin_access_level']."', "
                    . "admin_dashboard='".serialize($hotels)."', "
                    . "admin_real_name='".$data['admin_real_name']."' where admin_id='".$data['admin_id']."';");
            
            if ($data['admin_pass']!='' && $data['admin_pass']==$data['admin_pass_repeat']) {
                $this->execute("update azonics_admin_users set admin_pass='".$data['admin_pass']."' where admin_id='".$data['admin_id']."';");
            }
            
            if ($data['tempContainer']!='') {
                $fname = Image_helper::saveImageToFile('avatars',$data['tempContainer']);
                $this->execute("update azonics_admin_users set admin_avatar='".$fname."' where admin_id='".$data['admin_id']."';");
            }
            
            return true;
        }
        else {
            $checkAlredy = $this->query("select * from azonics_admin_users where "
                    . "admin_name='".$data['admin_name']."' and "
                    . "admin_email='".$data['admin_email']."' and "
                    . "admin_pass='".$data['admin_pass']."' and "
                    . "admin_status='1';");
            
            if (sizeof($checkAlredy)>0) {
                return false;
            }
            else {
                if ($data['tempContainer']!='') {
                    $fname = Image_helper::saveImageToFile('avatars',$data['tempContainer']);
                }
                
                $this->execute("insert into azonics_admin_users set "
                    . "admin_name='".$data['admin_name']."', "
                    . "admin_email='".$data['admin_email']."', "
                    . "admin_pass='".$data['admin_pass']."', "
                    . "admin_avatar='".$fname."', "
                    . "admin_status='1', "
                    . "admin_access_level='".$data['admin_access_level']."', "
                    . "admin_dashboard='".serialize($hotels)."', "
                    . "admin_real_name='".$data['admin_real_name']."', admin_creator='".$_SESSION['admin_user']->admin_id."';");
            
                return true;
            }
        }
    }
    
    
    public function deleteAdmin() {
        $data = $this->escapeArray($_REQUEST);
        $this->execute("update azonics_admin_users set admin_status='2' where admin_id='".$data['id']."';");
        return true;
    }
    
    
}