Subversion-Projekte lars-tiefland.ci

<?php

/**
 *
 * @package WebanOS CI
 * @author Lars Tiefland <ltiefland@gmail.com> 
 * @copyright 2016
 * @version $Rev: 2385 $
 */

class User_model extends CI_Model
{
        public function __construct()
        {
                parent::__construct();
        }

        public function user_list()
        {
                $sql = "SELECT
                                *
                        FROM
                                Access
                        WHERE
                                user LIKE '%@".__SHOP__."'
                ";
                $res = $GLOBALS['db_red']->query($sql);
                $users = $res->result_array();
                return $users;
        }

        public function get_info($user_id)
        {
                $sql = "SELECT
                                *
                        FROM
                                Access
                        WHERE
                                id=".$user_id."
                ";
                trigger_error($sql);
                $res = $GLOBALS["db_red"]->query($sql);
                $user = $res->row_array();
                list($user_local, $domain) = explode("@", $user["user"]);
                $user["domain"] = $domain;
                $user["local"] = $user_local;
                $user["datenquellen"] = unserialize($user["datenquellen"]);
                trigger_error(var_export($user,true));
                return $user;
        }

        public function save($user)
        {
                if ($_SERVER['SERVER_NAME'] == "ci.starfleethq.de")
                {
                        $GLOBALS['db_red_write'] = $GLOBALS['db_red'];
                }
                else
                {
                        $GLOBALS['db_red_write'] = $this->load->database('db_red_write', TRUE);
                }
                if ($user["ID"])
                {
                        $sql = "
                                UPDATE
                                        Access
                                SET
                                        name='".$user['name']."',
                                        user='".$user['user'].'@'.$GLOBALS["webs"]['domain']."',
                        ";
                        if ($user["passwd"])
                        {
                                $passwd = crypt($user['passwd']);
                                $sql .= "passwd='".$passwd."',";
                        }
                        $sql .= "
                                        ignoreRemoteHosts='".$user["ignoreRemoteHosts"]."',
                                        email='".$user['email']."',
                                        telefon='".$user['telefon']."',
                                        fax='".$user['fax']."',
                                        dir='".$user['dir']."',
                                        beschreibung='".$user['beschreibung']."',
                                        mitarbeiter='".$user["Mitarbeiter"]."',
                                        app_user='".$user['app_user']."',
                                        letzte_aenderung_von='".$this->session->username."'
                                WHERE
                                        id=".$user["ID"]."                              
                        ";
                }
                else
                {
                        $sql = "
                                INSERT INTO
                                        Access
                                SET
                                        name='".$user['name']."',
                                        user='".$user['user'].'@'.$GLOBALS["webs"]['domain']."',
                                        passwd='".$passwd."',
                                        ignoreRemoteHosts=".$user["ignoreRemoteHosts"].",
                                        email='".$user['email']."',
                                        telefon='".$user['telefon']."',
                                        fax='".$user['fax']."',
                                        dir='".$user['dir']."',
                                        beschreibung='".$user['beschreibung']."',
                                        mitarbeiter='".$user["Mitarbeiter"]."',
                                        app_user='".$user['app_user']."',
                                        erstellt_am=NOW(),
                                        erstellt_von='".$this->session->username."'
                        ";
                }
                $GLOBALS['db_red_write']->query($sql);
        }
        
        public function del()
        {
                if ($_SERVER['SERVER_NAME'] == "ci.starfleethq.de")
                {
                        $GLOBALS['db_red_write'] = $GLOBALS['db_red'];
                }
                else
                {
                        $GLOBALS['db_red_write'] = $this->load->database('db_red_write', TRUE);
                }
                $sql="
                        DELETE FROM
                                Access
                        WHERE
                                ID = ".$this->input->post('id')."
                ";
                $res = $GLOBALS["db_red_write"]->query($sql);
                if ($res)
                {
                        $msg = "Benutzer wurde erfolgreich gelöscht!";
                }
                else
                {
                        $msg = "Leider ist ein Fehler aufgetreten.<br>";
                        $msg .= "Bitte versuchen Sie es später noch einmal!<br>";
                        //$msg .= mysql_error();
                }
                return $msg;
        }
}

?>