39require_once
'../include/constant.php';
40require_once NOALYSS_INCLUDE.
'/class/database.class.php';
41require_once NOALYSS_INCLUDE.
'/lib/http_input.class.php';
42require_once NOALYSS_INCLUDE.
'/class/dossier.class.php';
43require_once NOALYSS_INCLUDE.
'/lib/ac_common.php';
49if ( ! isset($_SESSION[SESSION_KEY.
"g_user"])) {
65require_once(
'class/noalyss_user.class.php');
89 $filter_jrn=
$cn->make_list(
"select jrn_def_fiche_cred from jrn_def where jrn_def_id=$1",array(
$jrn));
90 $filter_card=($filter_jrn !=
"")?
" and fd_id in ($filter_jrn)":
' and false ';
93 $filter_jrn=
$cn->make_list(
"select jrn_def_fiche_deb from jrn_def where jrn_def_id=$1",array(
$jrn));
94 $filter_card=($filter_jrn !=
"")?
" and fd_id in ($filter_jrn)":
' and false ';
97 $get_cred=
'jrn_def_fiche_cred';
98 $get_deb=
'jrn_def_fiche_deb';
99 $deb=
$cn->get_value(
"select $get_deb from jrn_def where jrn_def_id=$1",array(
$jrn));
100 $cred=
$cn->get_value(
"select $get_cred from jrn_def where jrn_def_id=$1",array(
$jrn));
111 $filter_card=($filter_jrn != "")?" and fd_id in ($filter_jrn)":' and false ';
126 $get_cred=
'jrn_def_fiche_cred';
127 $get_deb=
'jrn_def_fiche_deb';
129 $filter_jrn=
$cn->make_list(
"select $get_cred||','||$get_deb as fiche from jrn_def where jrn_def_type=$1",array(
$type));
130 $filter_card=($filter_jrn !=
"")?
" and fd_id in ($filter_jrn)":
' and false ';
136$filter_enable_card=
" and f_enable='1' ";
140 join fiche_detail using (f_id)
143 and ad_value ilike '%'||$1||'%' ".$filter_enable_card.$filter_card.
' limit '.
$limit;
151if (
$sql !=
false &&
sizeof(
$sql) != 0 )
154 $sql_get=
$cn->prepare(
'get_name',
"select ad_value from fiche_detail where f_id = $1 and ad_id=$2");
162 $sql_name=
$cn->execute(
'get_name',array(
$sql[
$i][
'f_id'],1));
165 $sql_name=
$cn->execute(
'get_name',array(
$sql[
$i][
'f_id'],9));
168 $sql_name=
$cn->execute(
'get_name',array(
$sql[
$i][
'f_id'],23));
176 printf(
'<li id="%s">%s <span class="informal">%s %s</span></li>',
186 printf (
'<i>...'._(
'Résultat limité à %s').
' ...</i>',
$limit);
191 echo
"<ul><li>"._(
"Non trouvé").
"</li></ul>";
MaintenanceMode($p_file)
When you want to prevent users to connect, create a file in noalyss/ (NOALYSS_BASE) with the message ...
noalyss_str_replace($search, $replace, $string)
sql_string($p_string)
Fix the problem with the quote char for the database.
set_language()
set the lang thanks the _SESSION['g_lang'] var.
h( $row[ 'oa_description'])
static fetch_result($ret, $p_row=0, $p_col=0)
wrapper for the function pg_fetch_all
static num_row($ret)
wrapper for the function pg_num_rows
if(! isset($_SESSION[SESSION_KEY."g_user"])) $http
if not connected, session is expired then exit with a message NOCONX
if($typecard=='all') else if(strpos($typecard, 'sql]')==true) else
if( $delta< 0) elseif( $delta==0)
for($i=0;$i< $nb_jrn;$i++) $deb