Document_Type Class Reference

class for the table document_type , a document_type is a kind of action in the follow up More...

Collaboration diagram for Document_Type:

Public Member Functions
	__construct ($p_cn, $p_id=-1)
	document_type More...
	get ()
	Get all the data for this dt_id. More...
	set_number ($p_int)
	Restart the increment of the document. More...

Static Public Member Functions
static	get_list ($p_cn)
	get a list More...

Detailed Description

class for the table document_type , a document_type is a kind of action in the follow up

< dt_id pk document_type < dt_value value

Definition at line 34 of file document_type.class.php.

Constructor & Destructor Documentation

__construct()

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

document_type

constructor

Parameters

$p_cn

database connx

Definition at line 41 of file document_type.class.php.

        {
                $this->db = $p_cn;
                $this->dt_id = $p_id;
        }

References $p_id, and db.

Member Function Documentation

get()

Document_Type::get

(

)

Get all the data for this dt_id.

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

        {
                $sql = "select * from document_type where dt_id=$1";
                $R = $this->db->exec_sql($sql, array($this->dt_id));
                if ($this->db->count($R) == 0) return 1;
                $r = Database::fetch_array($R, 0);
                $this->dt_id = $r['dt_id'];
                $this->dt_value = $r['dt_value'];
                $this->dt_prefix = $r['dt_prefix'];
                return 0;
        }

References $r, $sql, db, and DatabaseCore\fetch_array().

Here is the call graph for this function:

get_list()

static Document_Type::get_list (   $p_cn )

static

get a list

Parameters

$p_cn

database connection

Returns

array of data from document_type

Definition at line 68 of file document_type.class.php.

        {
                $sql = "select * from document_type order by dt_value";
                $r = $p_cn->get_array($sql);
                $array = array();
                for ($i = 0; $i < count($r); $i++)
                {
                        $tmp['dt_value'] = $r[$i]['dt_value'];
                        $tmp['dt_prefix'] = $r[$i]['dt_prefix'];
 
                        $bt = new IButton('M' . $r[$i]['dt_id']);
                        $bt->label = _('Modifier');
                        $bt->javascript = "cat_doc_change('" . $r[$i]['dt_id'] . "','" . Dossier::id() . "');";
 
                        $tmp['js_mod'] = $bt->input();
                        $tmp['dt_id'] = $r[$i]['dt_id'];
 
                        $bt = new IButton('X' . $r[$i]['dt_id']);
                        $bt->label = _('Effacer');
                        $bt->javascript = "confirm_box('X{$r[$i]['dt_id']}','" . _('Vous confirmez') . "',";
                        $bt->javascript.="function () { cat_doc_remove('{$r[$i]['dt_id']}','" . Dossier::id() . "');})";
 
                        $tmp['js_remove'] = $bt->input();
 
 
                        $array[$i] = $tmp;
                }
                return $array;
        }

References $array, $i, $r, $sql, $tmp, and Dossier\id().

Here is the call graph for this function:

set_number()

Document_Type::set_number

(

$p_int

)

Restart the increment of the document.

Parameters

type

$p_int

Definition at line 102 of file document_type.class.php.

        {
                try
                {
                        $this->db->exec_sql("alter sequence seq_doc_type_" . $this->dt_id . " restart " . $p_int);
                }
                catch (Exception $e)
                {
                      record_log($e);
                        alert("Erreur " . $e->getMessage());
                }
        }

References $e, alert(), db, and record_log().

Here is the call graph for this function:

---

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

• include/class/document_type.class.php