noalyss Version-9
poste_analytique_sql.class.php
Go to the documentation of this file.
1<?php
2
3/*
4 * This file is part of NOALYSS.
5 *
6 * PhpCompta is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 2 of the License, or
9 * (at your option) any later version.
10 *
11 * NOALYSS is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
15 *
16 * You should have received a copy of the GNU General Public License
17 * along with PhpCompta; if not, write to the Free Software
18 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
19 */
20// Copyright (2016) Author Dany De Bontridder <dany@alchimerys.be>
21
22/**
23 * class_poste_analytique_sql.php
24 *
25 * @file
26 * @brief abstract of the table public.poste_analytique
27 *
28 *
29 * @class Poste_analytique_SQL
30 * @brief abstract of the table public.poste_analytique */
31require_once NOALYSS_INCLUDE.'/lib/ac_common.php';
32
34{
35
36 function __construct(DatabaseCore $p_cn, $p_id=-1)
37 {
38 $this->table="public.poste_analytique";
39 $this->primary_key="po_id";
40 /*
41 * List of columns
42 */
43 $this->name=array(
44 "po_id"=>"po_id"
45 , "po_name"=>"po_name"
46 , "pa_id"=>"pa_id"
47 , "po_amount"=>"po_amount"
48 , "po_description"=>"po_description"
49 , "ga_id"=>"ga_id"
50 , 'po_state'=>'po_state'
51 );
52 /*
53 * Type of columns
54 */
55 $this->type=array(
56 "po_id"=>"numeric"
57 , "po_name"=>"text"
58 , "pa_id"=>"numeric"
59 , "po_amount"=>"numeric"
60 , "po_description"=>"text"
61 , "ga_id"=>"text"
62 , 'po_state'=>'numeric'
63 );
64
65
66 $this->default=array(
67 "po_id"=>"auto"
68 );
69
70 $this->date_format="DD.MM.YYYY";
71 parent::__construct($p_cn, $p_id);
72 }
73
74}
$from_poste name
$input_from type
Definition: balance.inc.php:65
This class allow you to connect to the postgresql database, execute sql, retrieve data.
abstract of the table public.poste_analytique
__construct(DatabaseCore $p_cn, $p_id=-1)
Interface : this wrapper is used to created easily a wrapper to a table (ORM) You must create a class...
$all table