Dossier Class Reference

manage the current dossier, everywhere we need to know to which folder we are connected, because we can't use $_SESSION, we need to pass the dossier_id via a _GET or a POST variable private static $variable=array("id"=>"dos_id", "name"=>"dos_name", "desc"=>"dos_description"); More...

Collaboration diagram for Dossier:

Public Member Functions
	__construct ($p_id)
	count ()
	Count the number of folder in the repository.
	get_info ()
	get_parameter ($p_string)
	get_user_folder ($sql="")
	Return all the users as an array but NOALYSS_ADMINISTRATOR, that user cannot be changed by the interface for administrating user.
	load ()
	save ()
	set_parameter ($p_string, $p_value)
	update ()

Static Public Member Functions
static	check ()
	check if gDossier is set ?? dead code ???
static	connect ()
static	get ()
	return a string to put to gDossier into a GET
static	get_version ($p_cn)
static	hidden ()
	return a string to set gDossier into a FORM
static	id ()
	return the 'gDossier' value after a check
static	name ($id=0)
	retrieve the name of the current dossier
static	set_current ($p_dossier)
	Set the current dossier to $p_dossier.
static	show_dossier ($p_type, $p_login="", $p_text="", $limit=0)
	Show the folder where user have access.
static	synchro_admin ($p_id)
	connect to folder and give to admin.
static	upgrade ()
	Upgrade check if the folder ACCOUNT_REPOSITORY needs to be upgrade thanks the variable DBVERSIONREPO and run all the SQL script named ac-upgradeX.sql from the folder noalyss/include/sql/patch until X equal DBVERSIONREPO-1 After it will call the function apply_patch, remove_inexistant_user and clean_orphan_log for each folder.

Data Fields
	$cn
	Database connexion.
	$dos_description
	$dos_email
	$dos_id
	number of db
	$dos_name

Static Private Attributes
static	$variable

Detailed Description

manage the current dossier, everywhere we need to know to which folder we are connected, because we can't use $_SESSION, we need to pass the dossier_id via a _GET or a POST variable private static $variable=array("id"=>"dos_id", "name"=>"dos_name", "desc"=>"dos_description");

Definition at line 39 of file dossier.class.php.

Constructor & Destructor Documentation

__construct()

Dossier::__construct

(

$p_id

)

Definition at line 53 of file dossier.class.php.

    {
        $this->cn=new Database();  // Connect to the repository
        $this->dos_id=$p_id;
    }

References $p_id, and cn.

Member Function Documentation

check()

static Dossier::check ( )

static

check if gDossier is set ?? dead code ???

Definition at line 174 of file dossier.class.php.

    {
        try {
            $http=new HttpInput();
            $id=$http->request("gDossier","number");
            if ($id > 999999 || $id < 0) throw new \Exception(_("Dossier max dépassé "));
        } catch (\Exception $e) {
 
            die('Dossier invalide ');
        }
 
    }

References $e, $http, $id, and _.

connect()

static Dossier::connect ( )

static

Definition at line 294 of file dossier.class.php.

    {
        static $cn=null;
        if ($cn!=null)
            return $cn;
        $id=Dossier::id();
        $cn=new Database($id);
        return $cn;
    }

References $cn, $id, and id().

Here is the call graph for this function:

count()

Dossier::count

(

)

Count the number of folder in the repository.

Returns

integer

Definition at line 129 of file dossier.class.php.

    {
        $nb_folder=$this->cn->get_value('select count(*) from ac_dossier');
        return $nb_folder;
    }

References $nb_folder, and cn.

Referenced by synchro_admin().

get()

static Dossier::get ( )

static

return a string to put to gDossier into a GET

Definition at line 191 of file dossier.class.php.

    {
        $http=new \HttpInput();
        return "gDossier=".$http->request("gDossier","number");
    }

References $http.

get_info()

Dossier::get_info

(

)

Definition at line 242 of file dossier.class.php.

    {
        return var_export(self::$variable, true);
    }

get_parameter()

Dossier::get_parameter

(

$p_string

)

Definition at line 220 of file dossier.class.php.

    {
        if (array_key_exists($p_string, self::$variable))
        {
            $idx=self::$variable[$p_string];
            return $this->$idx;
        }
        else
            throw new Exception("Attribut inexistant $p_string");
    }

References $idx.

get_user_folder()

Dossier::get_user_folder

(

$sql = ""

)

Return all the users as an array but NOALYSS_ADMINISTRATOR, that user cannot be changed by the interface for administrating user.

Parameters

SQL

$sql

sql string to add to the query :

Note

that string MUST be the result of Database\escape_string

Definition at line 141 of file dossier.class.php.

    {
 
        $sql="
            select
                use_id,
                use_first_name,
                use_name,
                use_email,
                use_login,
                use_active,
                use_admin,
                ag_dossier,
                use_auth_method
            from
            ac_users  as ac
            left join    
                (select array_to_string(array_agg(dos_name),',') as ag_dossier,
                        jt.use_id as jt_use_id
                  from ac_dossier as ds
                    join  jnt_use_dos as jt on (jt.dos_id=ds.dos_id)
                    group by jt.use_id) as dossier_name on (jt_use_id=ac.use_id)
            $sql
            ";
 
        $res=$this->cn->get_array($sql);
        return $res;
    }

References $res, $sql, and cn.

get_version()

static Dossier::get_version ( $p_cn )

static

Definition at line 289 of file dossier.class.php.

    {
        return $p_cn->get_value('select max(val) from version');
    }

hidden()

static Dossier::hidden ( )

static

return a string to set gDossier into a FORM

Definition at line 201 of file dossier.class.php.

    {
        $http=new \HttpInput();
 
        return '<input type="hidden" id="gDossier" name="gDossier" value="'.$http->request("gDossier","number").'">';
    }

References $http.

id()

static Dossier::id ( )

static

return the 'gDossier' value after a check

Definition at line 61 of file dossier.class.php.

    {
        $http=new HttpInput();
        
        return $http->request('gDossier','number');
    }

References $http.

Referenced by connect().

load()

Dossier::load

(

)

Definition at line 271 of file dossier.class.php.

    {
 
        $sql="select * from ac_dossier where dos_id=$1";
 
        $res=$this->cn->exec_sql(
                $sql, array($this->dos_id)
        );
 
        if (Database::num_row($res)==0)
            return;
        $row=Database::fetch_array($res, 0);
        foreach ( self::$variable as $idx)
        {
            $this->$idx=$row[$idx];
        }
    }

References $idx, $res, $row, $sql, cn, DatabaseCore\fetch_array(), and DatabaseCore\num_row().

Here is the call graph for this function:

name()

static Dossier::name ( $id = 0 )

static

retrieve the name of the current dossier

Definition at line 210 of file dossier.class.php.

    {
 
        $http=new \HttpInput();
        $cn=new Database();
        $id=($id==0)?$http->request("gDossier","number"):$id;
        $name=$cn->get_value("select dos_name from ac_dossier where dos_id=$1", array($id));
        return $name;
    }

References $cn, $http, $id, and $name.

save()

Dossier::save

(

)

Definition at line 247 of file dossier.class.php.

    {
        $this->update();
    }

References update().

Here is the call graph for this function:

set_current()

static Dossier::set_current ( $p_dossier )

static

Set the current dossier to $p_dossier.

Parameters

numeric

$p_dossier

Definition at line 429 of file dossier.class.php.

                                            {
        
        self::check($p_dossier);
        put_global([ [ "key"=>"gDossier","value"=>$p_dossier]]);
 
    }

References put_global().

Here is the call graph for this function:

set_parameter()

Dossier::set_parameter	(		$p_string,
			$p_value )

Definition at line 231 of file dossier.class.php.

    {
        if (array_key_exists($p_string, self::$variable))
        {
            $idx=self::$variable[$p_string];
            $this->$idx=$p_value;
        }
        else
            throw new Exception("Attribut inexistant $p_string");
    }

References $idx.

show_dossier()

static Dossier::show_dossier ( $p_type, $p_login = "", $p_text = "", $limit = 0 )

static

Show the folder where user have access.

Parameters

p_type	string A for all dossiers R for accessible folders X forbidden folders
p_login	is the user name
p_text	is a part of the name where are looking for

Returns

nothing

Definition at line 79 of file dossier.class.php.

    {
        $cn=new Database();
        $str_limit=($limit==0)?'':' limit '.$limit;
        if ($p_type=="A")
        {
            $l_sql="select *, 'W' as priv_priv "
                    ."from ac_dossier "
                    ."where "
                    ."dos_name ilike '%'|| $2 ||'%'"
                    ."or dos_description ilike '%'|| $2 || '%' "
                    ."ORDER BY dos_name $str_limit  ";
            $a_row=$cn->get_array($l_sql, $p_text);
            return $a_row;
        }
        else if ($p_type=="R")
        {
            $l_sql="select * from jnt_use_dos
                   natural join ac_dossier
                   natural join ac_users
                   where
                   use_login=$1
                   and ( dos_name ilike '%'||  $2 || '%'  or dos_description ilike '%'|| $2|| '%' )
                   
                   order by dos_name 
                   $str_limit
                   ";
 
            $a_row=$cn->get_array($l_sql, array($p_login, $p_text));
            return $a_row;
        }
        else if ($p_type=='X')
        {
            $l_sql=" select * from ac_dossier where dos_id not in 
                  (select dos_id from jnt_use_dos where use_id=$1)
                  and ( dos_name ilike '%'||  $2|| '%'  or dos_description ilike '%'||  $2 || '%')
                  order by dos_name ".$str_limit;
            $a_row=$cn->get_array($l_sql, array($p_login, $p_text));
            return $a_row;
        }
        else
        {
            throw new Exception(_("Erreur paramètre"));
        }
    }

References $a_row, $cn, $limit, $p_type, and _.

synchro_admin()

static Dossier::synchro_admin ( $p_id )

static

connect to folder and give to admin.

the profile Admin(builtin)

Parameters

int

$p_id

dossier::id()

synchro global

Definition at line 308 of file dossier.class.php.

    {
// connect to target
        $cn=new Database($p_id);
 
        if (!$cn->exist_table("profile_menu"))
        {
            echo_warning("Dossier invalide");
            return;
        }
// connect to repo
        $repo=new Database();
 
        $a_admin=$repo->get_array("select use_login from ac_users where
                        use_admin=1 and use_active=1");
        try
        {
            /**
             * synchro global
             */
            $cn->start();
            for ($i=0; $i<count($a_admin); $i++)
            {
                Noalyss_user::grant_admin_access($a_admin[$i]['use_login'], $p_id);
            }
            $cn->commit();
        }
        catch (Exception $e)
        {
 
            echo_warning($e->getMessage());
              record_log($e);
            $cn->rollback();
        }
    }

References $cn, $e, $i, $p_id, $repo, count(), echo_warning(), and record_log().

Referenced by upgrade().

Here is the call graph for this function:

update()

Dossier::update

(

)

Definition at line 252 of file dossier.class.php.

    {
        if (noalyss_strlentrim($this->dos_name)==0)
            return;
 
        if ($this->cn->get_value("select count(*) from ac_dossier "
                        ." where dos_name=$1 and dos_id<>$2", array($this->dos_name, $this->dos_id))!=0)
            return;
 
        $sql="update ac_dossier set dos_name=$1,dos_description=$2 ,dos_email=$3".
                " where dos_id = $4";
        $res=$this->cn->exec_sql(
                $sql, array(trim($this->dos_name),
            trim($this->dos_description),
            $this->dos_email,
            $this->dos_id)
        );
    }

References $res, $sql, cn, and noalyss_strlentrim().

Referenced by save().

Here is the call graph for this function:

upgrade()

static Dossier::upgrade ( )

static

Upgrade check if the folder ACCOUNT_REPOSITORY needs to be upgrade thanks the variable DBVERSIONREPO and run all the SQL script named ac-upgradeX.sql from the folder noalyss/include/sql/patch until X equal DBVERSIONREPO-1 After it will call the function apply_patch, remove_inexistant_user and clean_orphan_log for each folder.

Definition at line 350 of file dossier.class.php.

    {
        $rep=new Database();
        /* If multi folders */
        $Resdossier=$rep->exec_sql("select dos_id, dos_name from ac_dossier");
        $MaxDossier=$rep->size($Resdossier);
 
        //----------------------------------------------------------------------
        // Upgrade the account_repository
        //----------------------------------------------------------------------
        echo "<h2>"._("Mise à jour de la base de données principale")."</h2>";
        $cn=new Database();
        if (DEBUGNOALYSS == 0)
            ob_start();
        $MaxVersion=DBVERSIONREPO-1;
        for ($i=4; $i<=$MaxVersion; $i++)
        {
            if ($cn->get_version()<=$i)
            {
                $cn->execute_script(NOALYSS_INCLUDE.'/sql/patch/ac-upgrade'.$i.'.sql');
            }
        }
        if (DEBUGNOALYSS == 0)             ob_end_clean();
        //----------------------------------------------------------------------
        // Upgrade the folders
        //----------------------------------------------------------------------
        echo "<h2>"._("Mise à jour dossiers")."</h2>";
 
        for ($e=0; $e<$MaxDossier; $e++)
        {
            $db_row=Database::fetch_array($Resdossier, $e);
            $name=$rep->format_name($db_row['dos_id'], 'dos');
            echo "<h3>Patching ".$db_row['dos_name'].'</h3>';
            echo _('Base de données')." ".$name;
 
            if ($rep->exist_database($name)>0)
            {
                $db=new Database($db_row['dos_id'], 'dos');
                $db->apply_patch($db_row['dos_name']);
                Dossier::synchro_admin($db_row['dos_id']);
                Noalyss_user::remove_inexistant_user($db_row['dos_id']);
                $db->clean_orphan_lob();
            }
            else
            {
                echo_warning(_("Dossier inexistant")." $name");
            }
        }
 
        //----------------------------------------------------------------------
        // Upgrade the template
        //----------------------------------------------------------------------
        $Resdossier=$rep->exec_sql("select mod_id, mod_name from modeledef");
        $MaxDossier=$rep->size();
        echo "<h2>"._("Mise à jour modèles")."</h2>";
 
        for ($e=0; $e<$MaxDossier; $e++)
        {
            $db_row=Database::fetch_array($Resdossier, $e);
            $name=$rep->format_name($db_row['mod_id'], 'mod');
            echo "<h3>Patching ".$db_row['mod_name']."</h3>";
            echo _('Base de données')." ".$name;
            if ($rep->exist_database($name)>0)
            {
                $db=new Database($db_row['mod_id'], 'mod');
                $db->apply_patch($db_row['mod_name']);
                $db->clean_orphan_lob();
            }
            else
            {
                echo_warning(_("Modèle inexistant")." $name");
            }
        }
    }

References $cn, $e, $i, $name, $rep, _, DBVERSIONREPO, echo_warning(), DatabaseCore\fetch_array(), and synchro_admin().

Here is the call graph for this function:

Field Documentation

$cn

Dossier::$cn

Database connexion.

Definition at line 47 of file dossier.class.php.

Referenced by connect(), name(), show_dossier(), synchro_admin(), and upgrade().

$dos_description

Dossier::$dos_description

Definition at line 50 of file dossier.class.php.

$dos_email

Dossier::$dos_email

Definition at line 51 of file dossier.class.php.

$dos_id

Dossier::$dos_id

number of db

Definition at line 48 of file dossier.class.php.

$dos_name

Dossier::$dos_name

Definition at line 49 of file dossier.class.php.

$variable

Dossier::$variable

staticprivate

Initial value:

=array("id"=>"dos_id",
        "name"=>"dos_name",
        "desc"=>"dos_description",
        "max_email"=>'dos_email')

Definition at line 42 of file dossier.class.php.

---

The documentation for this class was generated from the following file:

• include/class/dossier.class.php