noalyss Version-9
Public Member Functions
Quant_Sold_SQL Class Reference

ORM of the table public.quant_sold. More...

+ Inheritance diagram for Quant_Sold_SQL:
+ Collaboration diagram for Quant_Sold_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 of the table public.quant_sold.

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

Constructor & Destructor Documentation

◆ __construct()

Quant_Sold_SQL::__construct ( DatabaseCore  $p_cn,
  $p_id = -1 
)

Reimplemented from Data_SQL.

Definition at line 39 of file quant_sold.class.php.

40 {
41 $this->table = "public.quant_sold";
42 $this->primary_key = "qs_id";
43 /*
44 * List of columns
45 */
46 $this->name = array(
47 "qs_id" => "qs_id"
48 , "qs_internal" => "qs_internal"
49 , "qs_fiche" => "qs_fiche"
50 , "qs_quantite" => "qs_quantite"
51 , "qs_price" => "qs_price"
52 , "qs_vat" => "qs_vat"
53 , "qs_vat_code" => "qs_vat_code"
54 , "qs_client" => "qs_client"
55 , "qs_valid" => "qs_valid"
56 , "j_id" => "j_id"
57 , "qs_vat_sided" => "qs_vat_sided"
58 , "qs_unit" => "qs_unit"
59 );
60 /*
61 * Type of columns
62 */
63 $this->type = array(
64 "qs_id" => "numeric"
65 , "qs_internal" => "text"
66 , "qs_fiche" => "numeric"
67 , "qs_quantite" => "numeric"
68 , "qs_price" => "numeric"
69 , "qs_vat" => "numeric"
70 , "qs_vat_code" => "numeric"
71 , "qs_client" => "numeric"
72 , "qs_valid" => "text"
73 , "j_id" => "numeric"
74 , "qs_vat_sided" => "numeric"
75 , "qs_unit" => "numeric"
76 );
77
78
79 $this->default = array(
80 "qs_id" => "auto"
81 );
82
83 $this->date_format = "DD.MM.YYYY";
84 parent::__construct($p_cn, $p_id);
85 }
$from_poste name
$input_from type
Definition: balance.inc.php:65
$all table

References $p_id, name, table, and type.


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