35if ( ! defined(
'ALLOWED')) die (_(
'Non authorisé'));
37require_once NOALYSS_INCLUDE.
'/lib/ac_common.php';
38require_once NOALYSS_INCLUDE.
'/lib/function_javascript.php';
39mb_internal_encoding(
"UTF-8");
54 $attr=sprintf(
'this.ctl=\'%s\';',$ipopup);
56 $it=
new IText(
'acc_query');
58 $it->value=(isset(
$q))?
$q:
'';
59 $str_poste=$it->input();
65 $r.=
'<form id="sp" method="get" onsubmit="'.$attr.
'search_get_poste(this);return false;">';
67 require_once NOALYSS_TEMPLATE.
'/account_search.php';
68 $r.=ob_get_contents();
70 $r.=dossier::hidden();
81 select pcm_val,pcm_lib,array_to_string(array_agg(j_qcode) , ',') as acode
82 from tmp_pcmn left join vw_poste_qcode on (j_poste=pcm_val) ";
85 if ( isset($j) && $j > 0 &&
isNumber($j))
92 $sql.=
" $sep (".$fd_id.
')';
100 $sql.=sprintf(
" $sep ( pcm_val::text like '%s%%' or pcm_lib::text ilike '%%%s%%') ",
103 $sql.=
' group by pcm_val,pcm_lib,pcm_val_parent, pcm_type order by pcm_val::text limit 50';
115 if ( isset($bracket))
117 $pcm_val=
'['.$pcm_val.
']';
122 $str=sprintf(
"$('%s').value=$('%s').value+' '+'%s';",
128 $str=sprintf(
"$('%s').value='%s';",
134 $str.=sprintf(
"set_value('%s',g('%s').innerHTML);",
138 $str.=
"removeDiv('search_account');";
143 require_once NOALYSS_TEMPLATE.
'/account_result.php';
144 $r.=ob_get_contents();
152if (headers_sent() && DEBUGNOALYSS > 0) {
157 header(
'Content-type: text/xml; charset=UTF-8');
161<?xml version=
"1.0" encoding=
"UTF-8"?>
noalyss_strlentrim($p_string)
sql_string($p_string)
Fix the problem with the quote char for the database.
global $g_user
if no group available , then stop
if(headers_sent() &&DEBUGNOALYSS > 0) $html
catch(Exception $exc) if(! $g_user->can_write_action($ag_id)) $r
Manage the account from the table jrn, jrnx or tmp_pcmn.
static id()
return the 'gDossier' value after a check
for($e=0; $e< count($afiche); $e++) exit
escape_xml($p_xml)
When data are transfered thanks ajax in a xml document, the xml can not contains some character,...