39 if ($p_jrn == null || $p_jrn == -1)
44 $tledger = $cn->get_value(
'select jrn_def_name from jrn_def where jrn_def_id=$1', array($p_jrn));
45 $ledger.=
" le journal " . $tledger;
63 return "la date concerne la date d'opération";
66 return "la date concerne la date de paiement, la recherche sera limitée au journaux de type ACH & VEN";
69 return "la date concerne la date d'échéance, la recherche sera limitée au journaux de type ACH & VEN";
72 throw new Exception(
'str_date_type : type de date inconnu');
86 if ($p_prefix !=
"") {$p_prefix=$p_prefix.
".";}
90 $sql_date =
"and (".$p_prefix.
"j_date >= to_date($2,'DD.MM.YYYY') and ".$p_prefix.
"j_date <= to_date($3,'DD.MM.YYYY'))";
93 $sql_date =
" and ".$p_prefix.
"j_id in
94 (select j_id from jrnx join jrn on (j_grpt = jr_grpt_id)
96 coalesce(jr_date_paid,to_date('01.01.1900','DD.MM.YYYY')) >= to_date($2,'DD.MM.YYYY')
97 and coalesce(jr_date_paid,to_date('01.01.1900','DD.MM.YYYY')) <= to_date($3,'DD.MM.YYYY')
102 $sql_date =
" and ".$p_prefix.
"j_id in
103 (select j_id from jrnx join jrn on (j_grpt = jr_grpt_id)
105 coalesce(jr_ech,to_date('01.01.1900','DD.MM.YYYY')) >= to_date($2,'DD.MM.YYYY')
106 and coalesce(jr_ech,to_date('01.01.1900','DD.MM.YYYY')) <= to_date($3,'DD.MM.YYYY')
112 throw new Exception(
'get_sql_date paramètre invalide');
127 if (trim($p_formula) ==
"")
129 $errcode =
" Aucune formule trouvée";
134 $formula = $p_formula;
137 preg_match_all(
"/\[([A-Z]*[0-9]*)*([0-9]*[A-Z]*)\]/i", $formula, $e);
138 $formula = preg_replace(
'/_/',
'', $formula);
139 $formula = preg_replace(
"/\[([A-Z]*[0-9]*)*([0-9]*[A-Z]*)%*s*d*c*\]/i",
'', $formula);
140 $formula = preg_replace(
"/\[([a-z]*[0-9]*)*([0-9]*[A-Z]*)%*s*d*c*\]/i",
'', $formula);
141 $formula = preg_replace(
'/([0-9]+.{0,1}[0.9]*)*(\+|-|\*|\/)*/',
'', $formula);
142 $formula = preg_replace(
'/(\(|\))/',
'', $formula);
143 $formula = preg_replace(
'/\s/',
'', $formula);
144 $formula = preg_replace(
'/</',
'', $formula);
145 $formula = preg_replace(
'/>/',
'', $formula);
146 $formula = preg_replace(
'/=/',
'', $formula);
147 $formula = preg_replace(
'/\?/',
'', $formula);
152 $errcode = _(
" Erreur dans la formule ") . $formula;
162 if (Impress::check_formula($p_formula) ==
false)
164 $errcode =
"Erreur dans votre formule";
167 if (trim($p_formula) ==
"")
169 $errcode =
" Aucune formule trouvée";
static verify_compute($p_formula)
check if the formula is valid, return 1 for an error and set errcode to the error msg errcode is glob...
static str_date_type($p_type)
Compute the string to display for date.
Common function to RAPAV_Listing RAPAV_Formulaire and RAPAV_Declaration.
static get_sql_date($p_date, $p_prefix="")
Compute the SQL for the date.
static verify_formula($p_formula)
static get_ledger_name($p_jrn)
Return the ledger's name of p_jrn.