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 (\Database $p_cn, int $dt_id=-1)
	constructor document_type
	__toString ()
	get ()
	Get all the data for this dt_id.
	set_number (int $p_int)
	Restart the increment of the document.

Static Public Member Functions
static	get_list ($p_cn)
	get a list
static	test_me ()
	unit test for Document_Type

Data Fields
	$db
	Database Connection.
	$dt_id
	primary key see SQL DOCUMENT_TYPE.DT_ID
	$dt_prefix
	prefix for numbering see SQL DOCUMENT_TYPE.DT_PREFIX
	$dt_value
	description of the document see SQL DOCUMENT_TYPE.DT_VALUE

Detailed Description

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

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

Constructor & Destructor Documentation

__construct()

Document_Type::__construct	(	\Database	$p_cn,
		int	$dt_id = -1 )

constructor document_type

Parameters

$p_cn	database connx
$dt_id	primary key see SQL DOCUMENT_TYPE.DT_ID

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

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

References $dt_id, and db.

Member Function Documentation

__toString()

Document_Type::__toString

(

)

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

                         : string
    {
      return sprintf("dt_id : [%d] \n dt_value [%s] \n dt_prefix [%s]\n",$this->dt_id,$this->dt_value,$this->dt_prefix);
    }

get()

Document_Type::get

(

)

Get all the data for this dt_id.

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

        {
                $sql = "select * from document_type where dt_id=$1";
                $r = $this->db->get_row($sql, array($this->dt_id));
                if ( $r == null ) return 1;
 
                $this->dt_id = $r['dt_id'];
                $this->dt_value = $r['dt_value'];
                $this->dt_prefix = $r['dt_prefix'];
                return 0;
        }

References $r, $sql, and db.

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 71 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=array();
                        $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 _.

Referenced by test_me().

set_number()

Document_Type::set_number

(

int

$p_int

)

Restart the increment of the document.

Parameters

type

$p_int

Definition at line 106 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)
                {
                        alert("Erreur " . $e->getMessage());
                }
        }

References $e, alert(), and db.

Here is the call graph for this function:

test_me()

static Document_Type::test_me ( )

static

unit test for Document_Type

Returns

void

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

    {
       // if (! defined('TEST_UNIT')) return;
        $cn=Dossier::connect();
        function prv_echo_error($msg,int $lineno) {
            print '<p class="p-2 alert-danger">';
            print "ERROR : $lineno";
            print $msg;
            print '</p>';
        }
        // prepare test
        $old_value=[];
        try {
            $cn->start();
            $old_value[0]=$cn->get_row('select * from document_type where dt_id=$1',[8]);
            $old_value[1]=$cn->get_row('select * from document_type where dt_id=$1',[6]);
 
            $cn->exec_sql("update document_type set dt_value='Email' where dt_id=$1",[6]);
            $cn->exec_sql("update document_type set dt_prefix='PML' where dt_id=$1",[8]);
            $document_type=new Document_Type($cn,8);
            echo $document_type;
 
            if ( $document_type->get() == 1 ) {
            }
 
            if ( $document_type->dt_prefix!='PML') {
                prv_echo_error("PREFIX :". $document_type,__LINE__);
            }
 
            $document_type->set_number(6);
            $document_type->get();
 
            if ( $document_type->dt_value!='Email') {
                prv_echo_error("VALUE :". $document_type,__LINE__);
            }
            $list=Document_Type::get_list($cn);
 
            // list array > 1 and key =5
            if (count ($list) == 0) {
                prv_echo_error("GET_LIST :EMPTY",__LINE__);
            } else {
               foreach (['js_mod','dt_id','dt_value','dt_prefix','js_remove'] as $key) {
                   if ( ! isset ($list[0][$key])) {
                       prv_echo_error ('NOT SET '.$key,__LINE__);
                   }   else {
                       echo '<pre>';
                       var_dump( $list[0][$key]);
                       echo '</pre>';
                   }
               }
            }
        } catch (\Exception $e) {
            prv_echo_error("EXCEPTION :". $document_type,__LINE__);
            print_r($e->getTraceAsString());
        }
        $cn->rollback();
    }

References $cn, $document_type, $e, $list, $msg, get_list(), and print.

Here is the call graph for this function:

Field Documentation

$db

Document_Type::$db

Database Connection.

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

$dt_id

Document_Type::$dt_id

primary key see SQL DOCUMENT_TYPE.DT_ID

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

Referenced by __construct().

$dt_prefix

Document_Type::$dt_prefix

prefix for numbering see SQL DOCUMENT_TYPE.DT_PREFIX

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

$dt_value

Document_Type::$dt_value

description of the document see SQL DOCUMENT_TYPE.DT_VALUE

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

---

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

• include/class/document_type.class.php