Manage the menu of a profile. More...

Inheritance diagram for Profile_Menu:

Collaboration diagram for Profile_Menu:

Public Member Functions
	__construct ($p_cn, $p_id=-1)

	available_profile ()
	Show the available profile for the profile $p_id, it concerns only the action of management (action-gestion)

	available_repository ()
	Show the available repository for the profile $p_id.

	display_module ($ap_module)
	Display the module, with a javascript inside to show the menu contained in the module Used for setting the configuration.

	display_module_menu ($p_module_id, $p_level)
	Display all menu and submenu of a module.

	display_profile_menu_detail ()
	Show a table with all the menu and the type.

	mobile_device ()
	menu for device

	printing ()
	display all the accessible export of a profile $p_id

	sub_menu ($resource, $p_id)
	Display the content of a profile menu for printing.

Public Member Functions inherited from Profile_Menu_sql
	__construct (&$p_cn, $p_id=-1)

Public Member Functions inherited from Table_Data_SQL
	build_query ()
	Build the SQL select statement for querying the object and returns it.

	column_update ($column_expr, $value)
	update the value of a column with an expression for $value for the current record

	count ($p_where="", $p_array=null)
	return the number of count in the table corresponding to the where condition

	delete ()

	exist ()
	Count the number of record with the id ,.

	get_all_to_array ($p_key_col, $p_cond="", $p_array=NULL)
	Get all the row and use the p_key_code are the key value of array.

	insert ()

	load ()
	Load the current row return false if not found.

	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition

	update ()

Public Member Functions inherited from Data_SQL
	__construct (DatabaseCore $p_cn, $p_id=-1)

	__toString ()

	collect_objects ($cond='', $p_array=null)
	return an array of objects.

	from_array ($p_array)
	Transform an array into object.

	get ($p_string)
	get the value thanks the colum name and not the alias (name).

	get_cn ()

	get_info ()

	get_name ()

	get_object ($p_ret, $idx)

	get_pk_value ()

	get_primary_key ()

	get_type ()

	getp ($p_string)
	set the value thanks the alias name instead of the colum name

	next ($ret, $i)
	get_seek return the next object, the return of the query must have all the column of the object

	save ()
	Insert or update : if the row already exists, update otherwise insert.

	set ($p_string, $p_value)
	set the value thanks the colum name and not the alias (name)

	set_cn ($cn)

	set_name ($name)

	set_pk_value ($p_value)

	set_primary_key ($primary_key)

	set_type ($type)

	setp ($p_string, $p_value)
	set the value thanks the alias name instead of the colum name

	to_array ($prefix="")
	Turn an object (row) into an array, and the key could be prefixed with $prefix.

	to_row ($p_array)
	turns a row fetched from the DB into a SQL object in updating all his attribute

	verify ()

Additional Inherited Members
Data Fields inherited from Data_SQL
	$cn

	$date_format
	Type of the data.

	$default
	defaullt date format

	$name
	Database connection.

	$primary_key
	Array of logical and real name.

	$table

	$type
	Column name of the primary key.

Detailed Description

Manage the menu of a profile.

Definition at line 33 of file profile_menu.class.php.

Constructor & Destructor Documentation

◆ __construct()

Profile_Menu::__construct	(		$p_cn,
			$p_id = -1 )

Reimplemented from Table_Data_SQL.

Definition at line 37 of file profile_menu.class.php.

    {
        $this->cn=$p_cn;
        parent::__construct($p_cn, $p_id);
    }

References $p_id, and cn.

Member Function Documentation

◆ available_profile()

Profile_Menu::available_profile ( )

Show the available profile for the profile $p_id, it concerns only the action of management (action-gestion)

Parameters

$p_id is the profile p_id

Definition at line 236 of file profile_menu.class.php.

        {
            $array=$this->cn->get_array("
                                        select p.p_id,p.p_name,s.p_granted,s.ua_id,s.ua_right
                                                from profile as p
                                                join user_sec_action_profile as s on (s.p_granted=p.p_id)
                                                where s.p_id=$1
                                        union
                                                select p2.p_id, p2.p_name,null,null,'X'
                                                from profile as p2
                                                where
                                                p2.p_id not in (select p_granted from user_sec_action_profile where p_id = $1) order by p_name;
                                ", array($this->p_id));
            $aright_value=array(
                array('value'=>'R', 'label'=>_('Lecture')),
                array('value'=>'W', 'label'=>_('Ecriture et suppression')),
                array('value'=>'O', 'label'=>_('Ecriture')),
                array('value'=>'X', 'label'=>_('Aucun accès'))
            );
            require_once NOALYSS_TEMPLATE.'/user_sec_profile.php';
        }

References $array, _, cn, and p_id.

◆ available_repository()

Profile_Menu::available_repository ( )

Show the available repository for the profile $p_id.

Parameters

$p_id is the profile p_id

Definition at line 262 of file profile_menu.class.php.

        {
            $array=$this->cn->get_array("
                                        select p.r_id,p.r_name,s.ur_id,s.ur_right
                                                from stock_repository as p
                                                join profile_sec_repository as s on (s.r_id=p.r_id)
                                                where s.p_id=$1
                                        union
                                                select p2.r_id, p2.r_name,null,'X'
                                                from stock_repository as p2
                                                where
                                                p2.r_id not in (select r_id from profile_sec_repository where p_id = $1) order by r_name;
                                ", array($this->p_id));
            $aright_value=array(
                array('value'=>'R', 'label'=>_('Lecture')),
                array('value'=>'W', 'label'=>_('Ecriture')),
                array('value'=>'X', 'label'=>_('Aucun accès'))
            );
            require_once NOALYSS_TEMPLATE.'/profile_sec_repository.php';
        }

References $array, _, cn, and p_id.

◆ display_module()

Profile_Menu::display_module ( $ap_module )

Display the module, with a javascript inside to show the menu contained in the module Used for setting the configuration.

Parameters

$ap_module $array of module received from display_profile_menu_detail

See also: Profile_menu::display_profile_menu_detail

Definition at line 167 of file profile_menu.class.php.

        {
            include NOALYSS_TEMPLATE.'/profile_menu_display_module.php';
        }

Referenced by display_profile_menu_detail().

◆ display_module_menu()

Profile_Menu::display_module_menu	(		$p_module_id,
			$p_level )

Display all menu and submenu of a module.

See also: display_profile_module

Definition at line 177 of file profile_menu.class.php.

        {
            // Get the submenu
            $a_module=$this->cn->get_array('
                SELECT pm_id, 
                    me_code, 
                    me_code_dep, 
                    p_id, 
                    p_order, 
                    p_type_display, 
                    pm_default,
                    me_menu,
                    me_file,
                    me_url,
                    me_javascript,
                    me_parameter,
                    me_description
                FROM profile_menu
                join menu_ref using (me_code)
                where
                p_id = $1 and
                pm_id_dep = $2 order by p_order',
                    array($this->p_id, $p_module_id));
            require NOALYSS_TEMPLATE.'/profile_menu_display_submenu.php';
        }

References $a_module, $p_level, cn, and p_id.

◆ display_profile_menu_detail()

Profile_Menu::display_profile_menu_detail ( )

Show a table with all the menu and the type.

Parameters

type $p_id profile.p_id

Definition at line 109 of file profile_menu.class.php.

        {
            $a_module=$this->cn->get_array("
                        SELECT pm_id,
                                        pm.me_code,
                                        me_code_dep,
                                        p_id,
                                        p_order,
                                        p_type_display,
                                        pm_default,
                                        pm_desc,
                                        me_menu,
                                        me_description,
                                        me_url,
                                        me_file,
                                        me_javascript
                        FROM profile_menu as pm 
                        join profile_menu_type on (p_type_display=pm_type)
                        join menu_ref as mr on (mr.me_code=pm.me_code)
                        where
                        p_id=$1 and p_type_display='M'
                        order by p_order asc
                        ", array($this->p_id));
            ////////////////////////////////////////////////////////////
            // With a module
            ////////////////////////////////////////////////////////////
            $this->display_module($a_module);
 
            //*******************************************
            // show also menu without a module
            //*******************************************
            $ret=$this->cn->exec_sql("
                                        SELECT pm_id,
                                        pm.me_code,
                                        me_code_dep,
                                        p_id,
                                        p_order,
                                        p_type_display,
                                        pm_default,
                                        pm_desc,
                                        me_menu,
                                        me_description
                                        FROM profile_menu as pm
                                                join profile_menu_type on (p_type_display=pm_type)
                                                join menu_ref as mr on (mr.me_code=pm.me_code)
                                        where
                                        p_id=$1 and  p_type_display not in ('M','P') and me_code_dep is null
                                        order by p_order asc
                                                        ", array($this->p_id));
        }

References $a_module, $ret, cn, display_module(), and p_id.

Here is the call graph for this function:

◆ mobile_device()

Profile_Menu::mobile_device ( )

menu for device

Definition at line 285 of file profile_menu.class.php.

                                 {
            $profile_mobile=Mobile_Device_MTable::build(0,$this->p_id);
            $profile_mobile->display_table("where p_id=$1 order by pmo_order",[ $this->p_id ]);
            echo create_script("profile_menu_mtable.param_add({profile_id:{$this->p_id}});");
        }

References $profile_mobile, Mobile_Device_MTable\build(), create_script(), and p_id.

Here is the call graph for this function:

◆ printing()

Profile_Menu::printing ( )

display all the accessible export of a profile $p_id

Parameters

type $p_id profile.p_id

Definition at line 207 of file profile_menu.class.php.

        {
            $ret=$this->cn->exec_sql("
                            SELECT pm_id,
                                pm.me_code,
                                me_code_dep,
                                p_id,
                                p_order,
                                p_type_display,
                                pm_default,
                                pm_desc,
                                me_menu,
                                me_description
                                FROM profile_menu as pm
                                        join profile_menu_type on (p_type_display=pm_type)
                                        join menu_ref as mr on (mr.me_code=pm.me_code)
                                where
                                p_id=$1 and me_type='PR'
                                order by p_order asc
                                                        ", array($this->p_id));
            // Menu by module
            $gDossier=Dossier::id();
            $this->sub_menu($ret, $this->p_id);
        }

References $gDossier, $ret, cn, p_id, and sub_menu().

Here is the call graph for this function:

◆ sub_menu()

Profile_Menu::sub_menu	(		$resource,
			$p_id )

Display the content of a profile menu for printing.

Parameters

type	$resource
type	$p_id

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

    {
        if (Database::num_row($resource)!=0)
        {
            ////
            // If there are submenus
            $gDossier=dossier::id();
            echo '<td>';
            for ($e=0; $e<Database::num_row($resource); $e++)
            {
                $menu=Database::fetch_array($resource, $e);
                $me_code=$menu['me_code'];
 
                $me_code_dep=$menu['me_code_dep'];
 
                $mp_type=$menu['p_type_display'];
 
                $me_menu=$menu['me_menu'];
                $me_desc=$menu['me_description'];
                $me_def=($menu['pm_default']=='1')?'<span class="notice" style="display:inline">Défaut</span>':'';
                ?>
                <li id="sub<?php echo $menu['pm_id'] ?>">
 
                    <?php echo $me_code ?>
                    <?php echo $me_menu ?>
                    <?php echo $me_desc ?>  <?php echo $me_def ?>
                    <?php $ret2=$this->cn->exec_sql("
                                    SELECT pm_id,
                                            pm.me_code,
                                            me_code_dep,
                                            p_id,
                                            p_order,
                                            p_type_display,
                                            pm_default,
                                            pm_desc,
                                            me_menu,
                                            me_description
                                            FROM profile_menu as pm
                                                    join profile_menu_type on (p_type_display=pm_type)
                                                    join menu_ref as mr on (mr.me_code=pm.me_code)
                                            where
                                            p_id=$1 and me_code_dep=$2
                                            order by p_order asc
                        ", array($p_id, $me_code)); ?>
                    <span>
                        <?php
                         echo Icon_Action::trash(uniqid(), sprintf (" remove_sub_menu(%d,%d)", Dossier::id(),
                                 $menu['pm_id']))
                        ?>
                    </span>
                    <?php
                    echo "</li>";
                } //end loop e
                echo '</ul>';
            } // end if
        }