RAPAV_Formulaire Class Reference

Inheritance diagram for RAPAV_Formulaire:

Collaboration diagram for RAPAV_Formulaire:

Public Member Functions
	__construct ($f_id=-1)
	anchor_document ()
	Anchor to the template. More...
	load_definition ()
	Get data from database, from the table rapport_advanced.formulaire_param. More...
	input_formulaire ()
	input_definition ()
	input the definition More...
	echo_formulaire ()
	input_parameter ()
	remove_doc_template ()
	remove a doc template More...

Static Public Member Functions
static	listing ()
	show a list of all existing declaration type $cn database connection More...
static	save_definition ($p_array)
	save the definition $p_array contains More...
static	verify_definition (&$p_array)
	Check data and change them if needed database connection $cn. More...
static	update_definition ($p_array)
static	load_file (RAPAV_Formulaire $p_rapav)
static	generate_code ()

Detailed Description

Definition at line 32 of file class_rapav_formulaire.php.

Constructor & Destructor Documentation

RAPAV_Formulaire::__construct

(

$f_id = -1

)

Definition at line 35 of file class_rapav_formulaire.php.

    {
        $this->f_id = $f_id;
        $this->definition = array();
        parent::__construct($f_id);
    }

Member Function Documentation

RAPAV_Formulaire::anchor_document

(

)

Anchor to the template.

Returns

html anchor string

Definition at line 57 of file class_rapav_formulaire.php.

References $url.

    {
        $url=HtmlInput::request_to_string(array('gDossier','ac','plugin_code'));
        $url='extension.raw.php'.$url.'&act=export_definition_modele&id='.$this->f_id;
        return HtmlInput::anchor($this->f_filename,$url);
    }

RAPAV_Formulaire::echo_formulaire

(

)

Definition at line 243 of file class_rapav_formulaire.php.

    {
        echo '<h2>' . h($this->f_title) . '</h2>';
        echo '<p>' . h($this->f_description) . '<p>';
    }

static RAPAV_Formulaire::generate_code ( )

static

Definition at line 272 of file class_rapav_formulaire.php.

References $max.

Referenced by update_definition(), and verify_definition().

                                        {
            $a_possible= explode(',', 'A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,0,1,2,3,4,5,6,7,8,9');
            $max=count($a_possible);
            $max--;
            $code=$a_possible[rand(0,$max)].
                    $a_possible[rand(0,$max)].
                    $a_possible[rand(0,$max)].
                    $a_possible[rand(0, $max)].
                    $a_possible[rand(0, $max)].
                    $a_possible[rand(0, $max)]
                    ;
            return$code;
            
        }

RAPAV_Formulaire::input_definition

(

)

input the definition

Definition at line 89 of file class_rapav_formulaire.php.

References $cn, and $max.

    {
        $max = count($this->definition);
        global $cn;

        require 'template/formulaire_definition.php';
    }

RAPAV_Formulaire::input_formulaire

(

)

Definition at line 80 of file class_rapav_formulaire.php.

    {
        $this->load();
        require_once 'template/formulaire_titre.php';
    }

RAPAV_Formulaire::input_parameter

(

)

Definition at line 249 of file class_rapav_formulaire.php.

References $max, $obj, and Formulaire_Param\factory().

    {
        $max = count($this->definition);
        for ($i = 0; $i < $max; $i++)
        {
            $obj = Formulaire_Param::factory($this->definition[$i]);

            $obj->input();
        }
    }

static RAPAV_Formulaire::listing ( )

static

show a list of all existing declaration type $cn database connection

Definition at line 46 of file class_rapav_formulaire.php.

References $cn.

    {
        global $cn;
        $alist = $cn->get_array("select f_id,f_title,f_description
            from rapport_advanced.formulaire order by 2");
        require 'template/formulaire_listing.php';
    }

RAPAV_Formulaire::load_definition

(

)

Get data from database, from the table rapport_advanced.formulaire_param.

Definition at line 66 of file class_rapav_formulaire.php.

References $f, $max, and $ret.

    {
        $f = new Formulaire_Param_Sql();
        $ret = $f->seek(" where f_id=" . sql_string($this->f_id) . " order by p_order ");
        $max = Database::num_row($ret);

        for ($i = 0; $i < $max; $i++)
        {
            $o = new Formulaire_Param_Sql();
            $o = $f->next($ret, $i);
            $this->definition[] = clone $o;
        }
    }

static RAPAV_Formulaire::load_file ( RAPAV_Formulaire  $p_rapav )

static

Definition at line 206 of file class_rapav_formulaire.php.

References $cn, and $name.

    {
        global $cn;
        // nothing to save
        if (sizeof($_FILES) == 0)
            return;

        // Start Transaction
        $cn->start();
        $name = $_FILES['rapav_template']['name'];
        $new_name = tempnam($_ENV['TMP'], 'rapav_template');
        // check if a file is submitted
        if (strlen($_FILES['rapav_template']['tmp_name']) != 0)
        {
            // upload the file and move it to temp directory
            if (move_uploaded_file($_FILES['rapav_template']['tmp_name'], $new_name))
            {
                $oid = $cn->lo_import($new_name);
                // check if the lob is in the database
                if ($oid == false)
                {
                    $cn->rollback();
                    return 1;
                }
            }
            // the upload in the database is successfull
            $p_rapav->f_lob = $oid;
            $p_rapav->f_filename = $_FILES['rapav_template']['name'];
            $p_rapav->f_mimetype = $_FILES['rapav_template']['type'];
            $p_rapav->f_size= $_FILES['rapav_template']['size'];

            // update rapav
            $p_rapav->update();
        }
        $cn->commit();
    }

RAPAV_Formulaire::remove_doc_template

(

)

remove a doc template

Definition at line 262 of file class_rapav_formulaire.php.

References $cn.

    {
        global $cn;
        $cn->lo_unlink($this->f_lob);
        $this->f_filename=null;
        $this->f_size=null;
        $this->f_mimetype=null;
        $this->f_lob=null;
        $this->update();
    }

static RAPAV_Formulaire::save_definition (   $p_array )

static

save the definition $p_array contains

• f_id id of the formulaire
• f_title title of the formulaire
• f_description description of the formulaire
• p_id array of the row in formulaire_param
• p_code array of the row in formulaire_param
• p_libelle array of the row in formulaire_param
• p_type array of the row in formulaire_param
• t_id array of the row in formulaire_param
• p_order array of the row in formulaire_param

Definition at line 111 of file class_rapav_formulaire.php.

    {
        self::verify_definition($p_array);
        self::update_definition($p_array);
        return;
    }

static RAPAV_Formulaire::update_definition (   $p_array )

static

See Also

save_definition

Parameters

type

$p_array

Definition at line 153 of file class_rapav_formulaire.php.

References $cn, $ret, and generate_code().

    {
        global $cn;
        $rapav = new RAPAV_Formulaire($p_array['f_id']);
        // save into table formulaire
        $rapav->f_title = $p_array['f_title'];
        $rapav->f_description = $p_array['f_description'];
        $rapav->update();
        $nb_line=count($p_array['p_id']);
        for ($i = 0; $i < $nb_line ; $i++)
        {
            $form_param = new formulaire_param_sql($p_array['p_id'][$i]);
            $form_param->p_code = (trim($p_array['p_code'][$i])!="")?$p_array['p_code'][$i]:  RAPAV_Formulaire::generate_code();
            // remove space from p_code
            $form_param->p_code=str_replace(' ', "",$form_param->p_code);

            $form_param->p_libelle = trim($p_array['p_libelle'][$i]);
                        if ( $form_param->p_libelle == '') continue;
            $form_param->p_type = $p_array['p_type'][$i];
            $form_param->p_order = (isNumber($p_array['p_order'][$i]) == 0) ?  ($i+1) * 10 : $p_array['p_order'][$i];
            $form_param->t_id = $p_array['t_id'][$i];
            $form_param->f_id = $p_array['f_id'];
            // update or insert the row
            if ($p_array['p_id'][$i] == -1)
                $form_param->insert();
            else
                $form_param->update();
        }
                
        // delete checked rows
        if ( isset ($p_array["del_row"]))
        {
            for ($i=0;$i<count($p_array['del_row']);$i++)
            {
                if (isNumber($p_array['del_row'][$i]) == 1 &&  $p_array['del_row'][$i]!=-1) {
                    $cn->exec_sql('delete from rapport_advanced.formulaire_param where p_id=$1',array($p_array['del_row'][$i]));
                }
            }
        }
                // Reorder
                //
                $order_param=new formulaire_param_sql();
                $ret=$order_param->seek(' where f_id=$1 order by p_order',array($p_array['f_id']));
                $nb_rows=Database::num_row($ret);
                for ($i=0;$i < $nb_rows;$i++)
                {
                    $param=$order_param->next($ret,$i);
                    $param->p_order=($i+1)*10;
                    $param->update();
                }
        self::load_file($rapav);
    }

static RAPAV_Formulaire::verify_definition ( &  $p_array )

static

Check data and change them if needed database connection $cn.

Parameters

array

$p_array

normally $_POST

Definition at line 122 of file class_rapav_formulaire.php.

References $cn, and generate_code().

    {
        global $cn;
                $count_code=count($p_array['p_code']);
        for ($i=0;$i<$count_code;$i++)
        {
            $c=$cn->get_value('select count(*) from rapport_advanced.formulaire_param
                where p_code=$1 and p_id <> $2 and f_id=$3',
                    array($p_array['p_code'][$i],$p_array['p_id'][$i],$p_array['f_id']));

            if ( $c > 0 ) {
                $p_array['p_code'][$i]=RAPAV_Formulaire::generate_code();
            }
        }
                
                for ($i=0;$i<$count_code;$i++)
                {
                    for ($e=0;$e<$count_code;$e++) {
                        if ($p_array['p_code'][$i] == $p_array['p_code'][$e] && $i != $e)
                        {
                            $p_array['p_code'][$e]=  RAPAV_Formulaire::generate_code();
                        }
                    }
                }
    }

---

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

• rapport_avance/include/class_rapav_formulaire.php