noalyss Version-9
anc_acc_link.class.php
Go to the documentation of this file.
1<?php
2/*
3 * This file is part of NOALYSS.
4 *
5 * NOALYSS is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
9 *
10 * NOALYSS is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
14 *
15 * You should have received a copy of the GNU General Public License
16 * along with NOALYSS; if not, write to the Free Software
17 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
18*/
19
20// Copyright Author Dany De Bontridder danydb@aevalys.eu
21
22/*!
23* \file
24 * \brief link between accountancy and analytic, like table but as a listing
25 */
26/*!
27 * \class Anc_Acc_Link
28 * \brief link between accountancy and analytic, like table but as a listing
29 */
31{
32 function __contruct($p_cn)
33 {
34 parent::__construct($p_cn);
35 //@todo to remove = useless since the parent has a database object $db
36 $this->cn=$p_cn;
37 }
38
39 /**
40 *@brief get the parameters
41 */
42 function get_request()
43 {
44 parent::get_request();
45 $http=new HttpInput();
46 $this->card_poste=$http->get('card_poste',"string",1);
47 }
48 function set_sql_filter()
49 {
50 $sql="";
51 $and=" and ";
52 if ( $this->from != "" && $this->from=isDate($this->from) )
53 {
54 $sql.="$and oa_date >= to_date('".$this->from."','DD.MM.YYYY')";
55 }
56 if ( $this->to != "" && $this->to=isDate($this->to))
57 {
58 $sql.=" $and oa_date <= to_date('".$this->to."','DD.MM.YYYY')";
59 }
60
61 return $sql;
62
63 }
64
65
66}
67
isDate($p_date)
Definition: ac_common.php:236
$anc_grandlivre to
$anc_grandlivre from
$input_from cn
Definition: balance.inc.php:66
this class is the mother class for the CA printing
manage the http input (get , post, request) and extract from an array