ORM abstract of the table public.jrn_def. More...
Inheritance diagram for Jrn_def_SQL:
Collaboration diagram for Jrn_def_SQL:
Public Member Functions | |
| __construct (DatabaseCore $p_cn, $p_id=-1) | |
| Public Member Functions inherited from Table_Data_SQL | |
| __construct ($p_cn, $p_id=-1) | |
| build_query () | |
| Build the SQL select statement for querying the object and returns it. More... | |
| column_update ($column_expr, $value) | |
| update the value of a column with an expression for $value for the current record More... | |
| count ($p_where="", $p_array=null) | |
| return the number of count in the table corresponding to the where condition More... | |
| delete () | |
| exist () | |
| Count the number of record with the id ,. More... | |
| 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. More... | |
| insert () | |
| load () | |
| Load the current row return false if not found. More... | |
| seek ($cond='', $p_array=null) | |
| retrieve array of object thanks a condition More... | |
| 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. More... | |
| count ($p_where="", $p_array=null) | |
| delete () | |
| exist () | |
| Count the number of record with the id ,. More... | |
| from_array ($p_array) | |
| Transform an array into object. More... | |
| get ($p_string) | |
| get the value thanks the colum name and not the alias (name). More... | |
| 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 More... | |
| insert () | |
| load () | |
| Load the current row return false if not found. More... | |
| next ($ret, $i) | |
| get_seek return the next object, the return of the query must have all the column of the object More... | |
| save () | |
| Insert or update : if the row already exists, update otherwise insert. More... | |
| seek ($cond='', $p_array=null) | |
| retrieve array of object thanks a condition More... | |
| set ($p_string, $p_value) | |
| set the value thanks the colum name and not the alias (name) More... | |
| 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 More... | |
| to_array ($prefix="") | |
| Turn an object (row) into an array, and the key could be prefixed with $prefix. More... | |
| to_row ($p_array) | |
| turns a row fetched from the DB into a SQL object in updating all his attribute More... | |
| update () | |
| verify () | |
Additional Inherited Members | |
| Data Fields inherited from Data_SQL | |
| $cn | |
| $date_format | |
| Type of the data. More... | |
| $default | |
| defaullt date format More... | |
| $name | |
| Database connection. More... | |
| $primary_key | |
| Array of logical and real name. More... | |
| $table | |
| $type | |
| Column name of the primary key. More... | |
Detailed Description
ORM abstract of the table public.jrn_def.
Definition at line 30 of file jrn_def_sql.class.php.
Constructor & Destructor Documentation
◆ __construct()
| Jrn_def_SQL::__construct | ( | DatabaseCore | $p_cn, |
$p_id = -1 |
|||
| ) |
Reimplemented from Data_SQL.
Definition at line 33 of file jrn_def_sql.class.php.
34 {
36 $this->primary_key="jrn_def_id";
37 /*
38 * List of columns
39 */
40 $this->name=array(
41 "jrn_def_id"=>"jrn_def_id"
42 , "jrn_def_name"=>"jrn_def_name"
43 , "jrn_def_class_deb"=>"jrn_def_class_deb"
44 , "jrn_def_class_cred"=>"jrn_def_class_cred"
45 , "jrn_def_fiche_deb"=>"jrn_def_fiche_deb"
46 , "jrn_def_fiche_cred"=>"jrn_def_fiche_cred"
47 , "jrn_deb_max_line"=>"jrn_deb_max_line"
48 , "jrn_cred_max_line"=>"jrn_cred_max_line"
49 , "jrn_def_ech"=>"jrn_def_ech"
50 , "jrn_def_ech_lib"=>"jrn_def_ech_lib"
51 , "jrn_def_type"=>"jrn_def_type"
52 , "jrn_def_code"=>"jrn_def_code"
53 , "jrn_def_pj_pref"=>"jrn_def_pj_pref"
54 , "jrn_def_bank"=>"jrn_def_bank"
55 , "jrn_def_num_op"=>"jrn_def_num_op"
56 , "jrn_def_description"=>"jrn_def_description"
57 , "jrn_enable"=>"jrn_enable"
58 , "currency_id"=>"currency_id"
59 , "jrn_def_negative_amount"=>"jrn_def_negative_amount"
60 , "jrn_def_negative_warning"=>"jrn_def_negative_warning"
61 , 'jrn_def_quantity'=>'jrn_def_quantity'
62 );
63 /*
64 * Type of columns
65 */
66 $this->type=array(
67 "jrn_def_id"=>"numeric"
68 , "jrn_def_name"=>"text"
69 , "jrn_def_class_deb"=>"text"
70 , "jrn_def_class_cred"=>"text"
71 , "jrn_def_fiche_deb"=>"text"
72 , "jrn_def_fiche_cred"=>"text"
73 , "jrn_deb_max_line"=>"numeric"
74 , "jrn_cred_max_line"=>"numeric"
75 , "jrn_def_ech"=>"boolean"
76 , "jrn_def_ech_lib"=>"text"
77 , "jrn_def_type"=>"text"
78 , "jrn_def_code"=>"text"
79 , "jrn_def_pj_pref"=>"text"
80 , "jrn_def_bank"=>"numeric"
81 , "jrn_def_num_op"=>"numeric"
82 , "jrn_def_description"=>"text"
83 , "jrn_enable"=>"numeric"
84 , "currency_id"=>"numeric"
85 , "jrn_def_negative_amount"=>"text"
86 ,"jrn_def_negative_warning"=>"text"
87 ,'jrn_def_quantity'=>"numeric"
88 );
89
90 $this->default=array(
91 "jrn_def_id"=>"auto");
92
93 $this->date_format="DD.MM.YYYY";
94 parent::__construct($p_cn, $p_id);
95 }
The documentation for this class was generated from the following file:
- include/database/jrn_def_sql.class.php