";
}
/**
* Includes the javascript datetime picker
*/
function incPicker() {
global $l;
echo "
";
}
function dateOnClick($input, $checkOnClick=false) {
global $l;
$dateForm = $l->g(269) == "%m/%d/%Y" ? "MMDDYYYY" : "DDMMYYYY" ;
if( $checkOnClick ) $cOn = ",'$checkOnClick'";
$ret = "OnClick=\"javascript:NewCal('$input','$dateForm',false,24{$cOn});\"";
return $ret;
}
function datePick($input, $checkOnClick=false) {
global $l;
$dateForm = $l->g(269) == "%m/%d/%Y" ? "MMDDYYYY" : "DDMMYYYY" ;
if( $checkOnClick ) $cOn = ",'$checkOnClick'";
$ret = "";
$ret .= "";
return $ret;
}
/*
*
* This function check an mail addresse
*
*/
function VerifyMailadd($addresse)
{
$Syntaxe='#^[\w.-]+@[\w.-]+\.[a-zA-Z]{2,6}$#';
if(preg_match($Syntaxe,$addresse))
return true;
else
return false;
}
function send_mail($mail_to,$subjet,$body){
global $l;
// few personnes
$to="";
if (is_array($mail_to)){
$to = implode(',',$mail_to);
}else
$to = $mail_to;
// message
$message = '
' . $subjet . '
' . $body . '
';
// Pour envoyer un mail HTML, l'en-tête Content-type doit être défini
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
// En-têtes additionnels
$headers .= 'To: '. implode(',',$mail_to) . "\r\n";
$headers .= 'From: Ocsinventory ' . "\r\n";
// $headers .= 'Cc: anniversaire_archive@example.com' . "\r\n";
// $headers .= 'Bcc: anniversaire_verif@example.com' . "\r\n";
// Envoi
$test_mail=@mail($to, $subject, $message, $headers);
if (!$test_mail){
echo "";
}
}
function replace_entity_xml($txt){
$cherche = array("&","<",">","\"","'");
$replace = array( "&","<",">", """, "'");
return str_replace($cherche, $replace, $txt);
}
function printEnTete_tab($ent) {
echo "
".$ent."
";
}
//function for escape_string before use database
function escape_string($array){
if (is_array($array)){
foreach ($array as $key=>$value){
$trait_array[$key]=mysql_real_escape_string($value);
}
return ($trait_array);
}else
return array();
}
function xml_escape_string($array){
foreach ($array as $key=>$value){
$trait_array[$key]=utf8_encode($value);
$trait_array[$key]=htmlspecialchars($value,ENT_QUOTES);
}
return ($trait_array);
}
function xml_encode( $txt ) {
$cherche = array("&","<",">","\"","'","é","è","ô","Î","î","à","ç","ê","â");
$replace = array( "&","<",">", """, "'","é","è","ô","Î","î","à","ç","ê","â");
return str_replace($cherche, $replace, $txt);
}
function xml_decode( $txt ) {
$cherche = array( "â","ê","ç","à","<",">", """, "'","é","è","ô","Î","î","&");
$replace = array( "â","ê","ç","à","<",">","\"","'","é","è","ô","Î","î", "&" );
return str_replace($cherche, $replace, $txt);
}
//fonction qui permet d'afficher un tableau de donn�es
/*
* $entete_colonne = array ; => ex: $i=0;
while($colname = mysql_fetch_field($result))
$entete2[$i++]=$colname->name;
* $data= array; => ex: $i=0;
while($item = mysql_fetch_object($result)){
$data2[$i]['ID']=$item ->ID;
$data2[$i]['PRIORITY']=$up.$item ->PRIORITY.$down;
$data2[$i]['TITLE']=$item ->TITLE;
}
* $titre= varchar => ex: "Administration des messages"
* $width= taille tableau => ex: "60"
* $height= taille tableau => ex: "300"
* $lien = array ; => liste des colonnes qui ont le tri
*
*/
function tab_entete_fixe($entete_colonne,$data,$titre,$width,$height,$lien=array(),$option=array())
{
echo "
";
global $protectedGet,$l;
if ($protectedGet['sens'] == "ASC"){
$sens="DESC";
}
else
{
$sens="ASC";
}
if(isset($data))
{
?>
";
//titre du tableau
$i=1;
foreach($entete_colonne as $k=>$v)
{
if (in_array($v,$lien))
echo "
".$v."
";
else
echo "
".$v."
";
$i++;
}
echo "
";
// $i=0;
$j=0;
//lignes du tableau
// while (isset($data[$i]))
//{
foreach ($data as $k2=>$v2){
($j % 2 == 0 ? $color = "#f2f2f2" : $color = "#ffffff");
echo "
";
foreach ($v2 as $k=>$v)
{
if (isset($option['B'][$i])){
$begin="";
$end="";
}else{
$begin="";
$end="";
}
if ($v == "") $v=" ";
echo "
".$begin.$v.$end."
";
}
$j++;
echo "
";
//$i++;
}
echo "
";
}
else{
msg_warning($l->g(766));
return FALSE;
}
return TRUE;
}
//variable pour la fonction champsform
$num_lig=0;
/* fonction li�e � show_modif
* qui permet de cr�er une ligne dans le tableau de modification/ajout
* $title = titre � l'affichage du champ
* $value_default = - pour un champ text ou input, la valeur par d�faut du champ.
* - pour un champ select, liste des valeurs du champ
* $input_name = nom du champ que l'on va r�cup�rer en $protectedPost
* $input_type = 0 :
* 1 : ";
}elseif ($input_type ==0)
return "";
elseif($input_type ==2){
$champs="";
return $champs;
}elseif($input_type == 3){
$hid="";
// echo $name." ";
return $name.$hid;
}elseif ($input_type == 4)
return "";
elseif ($input_type == 5 and isset($name) and is_array($name)){
foreach ($name as $key=>$value){
$champs.= "";
}
return $champs;
}elseif($input_type == 6){
if (isset($configinput['NB_FIELD']))
$i=$configinput['NB_FIELD'];
else
$i=6;
$j=0;
echo $name;
while ($j<$i){
$champs.="";
$j++;
}
return $champs;
}elseif($input_type == 7)
return "";
elseif ($input_type == 8){
return "";
}elseif ($input_type == 9){
$aff="";
if (is_array($name)){
foreach ($name as $key=>$value){
$aff.="".
$value." ";
}
}
return $aff;
}elseif ($input_type == 10){
//le format de de $name doit etre sous la forme d'une requete sql avec éventuellement
//des arguments. Dans ce cas, les arguments sont séparés de la requête par $$$$
//et les arguments entre eux par des virgules
//echo $name;
$sql=explode('$$$$',$name);
if (isset($sql[1])){
$arg_sql=explode(',',$sql[1]);
$i=0;
while ($arg_sql[$i]){
$arg[$i]=$protectedPost[$arg_sql[$i]];
$i++;
}
}
if (isset($arg_sql))
$result = mysql2_query_secure($sql[0], $_SESSION['OCS']["readServer"],$arg);
else
$result = mysql2_query_secure($sql[0], $_SESSION['OCS']["readServer"]);
if (isset($result) and $result != ''){
$i=0;
while($colname = mysql_fetch_field($result))
$entete2[$i++]=$colname->name;
$i=0;
while ($item = mysql_fetch_object($result)){
$j=0;
while ($entete2[$j]){
$data2[$i][$entete2[$j]]=$item ->$entete2[$j];
$j++;
}
$i++;
}
}
return tab_entete_fixe($entete2,$data2,"",60,300);
}elseif($input_type == 11 and isset($name) and is_array($name)){
foreach ($name as $key=>$value){
$champs.= "";
}
return $champs;
}elseif($input_type == 12){ //IMG type
$champs="";
}elseif($input_type == 13){
return "";
}
}
function tab_modif_values($tab_name,$tab_typ_champ,$tab_hidden,$title="",$comment="",$name_button="modif",$showbutton=true,$form_name='CHANGE',$showbutton_action='')
{
global $l,$protectedPost,$css;
if (!isset($css))
$css="mvt_bordure";
if ($form_name != 'NO_FORM'){
echo open_form($form_name);
}
echo '
';
if ($showbutton_action != '')
echo "
" . $showbutton_action . "
";
echo "
";
echo "
" . $title . "
";
if (is_array($tab_name)){
foreach ($tab_name as $key=>$values)
{
//print_r($tab_typ_champ[$key]['DEFAULT_VALUE']);
echo "
";
if ($showbutton and $showbutton !== 'BUTTON'){
echo "
";
echo "
";
}elseif($showbutton === 'BUTTON'){
echo "
";
}
echo "
";
echo "
";
if ($tab_hidden != ""){
foreach ($tab_hidden as $key=>$value)
{
echo "";
}
}
if ($form_name != 'NO_FORM')
echo close_form();
}
function show_field($name_field,$type_field,$value_field,$config=array()){
global $protectedPost;
foreach($name_field as $key=>$value){
$tab_typ_champ[$key]['DEFAULT_VALUE']=$value_field[$key];
$tab_typ_champ[$key]['INPUT_NAME']=$name_field[$key];
$tab_typ_champ[$key]['INPUT_TYPE']=$type_field[$key];
if (!isset($config['ROWS'][$key]) or $config['ROWS'][$key] == '')
$tab_typ_champ[$key]['CONFIG']['ROWS']=7;
else
$tab_typ_champ[$key]['CONFIG']['ROWS']=$config['ROWS'][$key];
if (!isset($config['COLS'][$key]) or $config['COLS'][$key] == '')
$tab_typ_champ[$key]['CONFIG']['COLS']=40;
else
$tab_typ_champ[$key]['CONFIG']['COLS']=$config['COLS'][$key];
if (!isset($config['SIZE'][$key]) or $config['SIZE'][$key] == '')
$tab_typ_champ[$key]['CONFIG']['SIZE']=50;
else
$tab_typ_champ[$key]['CONFIG']['SIZE']=$config['SIZE'][$key];
if (!isset($config['MAXLENGTH'][$key]) or $config['MAXLENGTH'][$key] == '')
$tab_typ_champ[$key]['CONFIG']['MAXLENGTH']=255;
else
$tab_typ_champ[$key]['CONFIG']['MAXLENGTH']=$config['MAXLENGTH'][$key];
if (isset($config['COMMENT_BEHING'][$key])) {
$tab_typ_champ[$key]['COMMENT_BEHING']= $config['COMMENT_BEHING'][$key];
}
if (isset($config['DDE'][$key])) {
$tab_typ_champ[$key]['CONFIG']['DDE']=$config['DDE'][$key];
}
if (isset($config['SELECT_DEFAULT'][$key])) {
$tab_typ_champ[$key]['CONFIG']['DEFAULT']=$config['SELECT_DEFAULT'][$key];
}
if (isset($config['JAVASCRIPT'][$key])) {
$tab_typ_champ[$key]['CONFIG']['JAVASCRIPT']=$config['JAVASCRIPT'][$key];
}
}
// $i=0;
// while ($name_field[$i]){
// $tab_typ_champ[$i]['DEFAULT_VALUE']=$value_field[$i];
// $tab_typ_champ[$i]['INPUT_NAME']=$name_field[$i];
// $tab_typ_champ[$i]['INPUT_TYPE']=$type_field[$i];
// $tab_typ_champ[$i]['CONFIG']['ROWS']=7;
// $tab_typ_champ[$i]['CONFIG']['COLS']=40;
// $tab_typ_champ[$i]['CONFIG']['SIZE']=50;
// $tab_typ_champ[$i]['CONFIG']['MAXLENGTH']=255;
// $i++;
// }
return $tab_typ_champ;
}
function filtre($tab_field,$form_name,$query,$arg='',$arg_count=''){
global $protectedPost,$l;
if ($protectedPost['RAZ_FILTRE'] == "RAZ")
unset($protectedPost['FILTRE_VALUE'],$protectedPost['FILTRE']);
if ($protectedPost['FILTRE_VALUE'] and $protectedPost['FILTRE']){
$temp_query=explode("GROUP BY",$query);
if ($temp_query[0] == $query)
$temp_query=explode("group by",$query);
if (substr_count(mb_strtoupper ($temp_query[0]), "WHERE")>0){
$t_query=explode("WHERE",$temp_query[0]);
if ($t_query[0] == $temp_query[0])
$t_query=explode("where",$temp_query[0]);
$temp_query[0]= $t_query[0]." WHERE (".$t_query[1].") and ";
}else
$temp_query[0].= " where ";
if (substr($protectedPost['FILTRE'],0,2) == 'a.'){
require_once('require/function_admininfo.php');
$id_tag=explode('_',substr($protectedPost['FILTRE'],2));
if (!isset($id_tag[1]))
$tag=1;
else
$tag=$id_tag[1];
$list_tag_id= find_value_in_field($tag,$protectedPost['FILTRE_VALUE']);
}
if ($list_tag_id){
$query_end= " in (".implode(',',$list_tag_id).")";
}else{
if ($arg == '')
$query_end = " like '%".$protectedPost['FILTRE_VALUE']."%' ";
else{
$query_end = " like '%s' ";
array_push($arg,'%' . $protectedPost['FILTRE_VALUE'] . '%');
if (is_array($arg_count))
array_push($arg_count,'%' . $protectedPost['FILTRE_VALUE'] . '%');
else
$arg_count[] = '%' . $protectedPost['FILTRE_VALUE'] . '%';
}
}
$query= $temp_query[0].$protectedPost['FILTRE'].$query_end;
if (isset($temp_query[1]))
$query.="GROUP BY ".$temp_query[1];
}
$view=show_modif($tab_field,'FILTRE',2);
$view.=show_modif($protectedPost['FILTRE_VALUE'],'FILTRE_VALUE',0);
echo $l->g(883).": ".$view."
";
echo "";
return array('SQL'=>$query,'ARG'=>$arg,'ARG_COUNT'=>$arg_count);
}
function tab_list_error($data,$title)
{
global $l;
echo " ";
echo "
";
echo "
".$title."
";
$i=0;
$j=0;
while ($data[$i])
{
if ($j == 10)
{
echo "
";
$j=0;
}
echo "
".$data[$i]."
";
$i++;
$j++;
}
echo "
";
}
function nb_page($form_name = '',$taille_cadre='80',$bgcolor='#C7D9F5',$bordercolor='#9894B5',$table_name=''){
global $protectedPost,$l;
//catch nb result by page
if (isset($_SESSION['OCS']['nb_tab'][$table_name]))
$protectedPost["pcparpage"]=$_SESSION['OCS']['nb_tab'][$table_name];
elseif(isset($_COOKIE[$table_name.'_nbpage']))
$protectedPost["pcparpage"]=$_COOKIE[$table_name.'_nbpage'];
if ($protectedPost['old_pcparpage'] != $protectedPost['pcparpage'])
$protectedPost['page']=0;
if (!(isset($protectedPost["pcparpage"])) or $protectedPost["pcparpage"] == ""){
$protectedPost["pcparpage"]=PC4PAGE;
}
$html_show = "
";
//gestion d"une phrase d'alerte quand on utilise le filtre
if (isset($protectedPost['FILTRE_VALUE']) and $protectedPost['FILTRE_VALUE'] != '' and $protectedPost['RAZ_FILTRE'] != 'RAZ')
$html_show .= msg_warning($l->g(884));
$html_show .= "
";
$html_show .= $pcParPageHtml;
if (isset($protectedPost["pcparpage"])){
$deb_limit=$protectedPost['page']*$protectedPost["pcparpage"];
$fin_limit=$deb_limit+$protectedPost["pcparpage"]-1;
}
$html_show .= "";
if ($form_name != '')
echo $html_show;
return (array("BEGIN"=>$deb_limit,"END"=>$fin_limit));
}
function show_page($valCount,$form_name){
global $protectedPost;
if (isset($protectedPost["pcparpage"]) and $protectedPost["pcparpage"] != 0)
$nbpage= ceil($valCount/$protectedPost["pcparpage"]);
if ($nbpage >1){
$up=$protectedPost['page']+1;
$down=$protectedPost['page']-1;
echo "
";
echo "
";
if ($protectedPost['page'] > 0)
echo " ";
//if ($nbpage<10){
$i=0;
$deja="";
while ($i<$nbpage){
$point="";
if ($protectedPost['page'] == $i){
if ($i<$nbpage-10 and $i>10 and $deja==""){
$point=" ... ";
$deja="ok";
}
if($i<$nbpage-10 and $i>10){
$point2=" ... ";
}
echo $point."".$i." ".$point2;
}
elseif($i>$nbpage-10 or $i<10)
echo "".$i." ";
elseif ($i<$nbpage-10 and $i>10 and $deja==""){
echo " ... ";
$deja="ok";
}
$i++;
}
if ($protectedPost['page']< $nbpage-1)
echo " ";
}
echo "
";
echo "";
echo "";
}
function onglet($def_onglets,$form_name,$post_name,$ligne)
{
global $protectedPost;
/* $protectedPost['onglet_soft']=stripslashes($protectedPost['onglet_soft']);
$protectedPost['old_onglet_soft']=stripslashes($protectedPost['old_onglet_soft']);*/
if ($protectedPost["old_".$post_name] != $protectedPost[$post_name]){
$protectedPost['page']=0;
}
if (!isset($protectedPost[$post_name]) and is_array($def_onglets)){
foreach ($def_onglets as $key=>$value){
$protectedPost[$post_name]=$key;
break;
}
}
/*This fnction use code of Douglas Bowman (Sliding Doors of CSS)
http://www.alistapart.com/articles/slidingdoors/
THANKS!!!!
$def_onglets is array like : $def_onglets[$l->g(499)]=$l->g(499); //Serveur
$def_onglets[$l->g(728)]=$l->g(728); //Inventaire
$def_onglets[$l->g(312)]=$l->g(312); //IP Discover
$def_onglets[$l->g(512)]=$l->g(512); //T�l�d�ploiement
$def_onglets[$l->g(628)]=$l->g(628); //Serveur de redistribution
behing this function put this lign:
echo open_form($form_name);
At the end of your page, close this form
$post_name is the name of var will be post
$ligne is if u want have onglet on more ligne*/
if ($def_onglets != ""){
echo "\n";
echo "
";
echo "
";
$current="";
$i=0;
foreach($def_onglets as $key=>$value){
if ($i == $ligne){
echo "
";
$i=0;
}
echo "
alert('".mysql_real_escape_string(stripslashes($protectedPost[$post_name]))." => ".$key."')";
if (mysql_real_escape_string(stripslashes($protectedPost[$post_name])) === mysql_real_escape_string(stripslashes($key)) or (!isset($protectedPost[$post_name]) and $current != 1)){
echo "id='current'";
$current=1;
}
}
echo ">".htmlspecialchars($value, ENT_QUOTES)."
";
$i++;
}
echo "
";
echo "";
echo "";
}
}
function gestion_col($entete,$data,$list_col_cant_del,$form_name,$tab_name,$list_fields,$default_fields,$id_form='form'){
global $protectedPost,$l;
//search in cookies columns values
if (isset($_COOKIE[$tab_name]) and $_COOKIE[$tab_name] != '' and !isset($_SESSION['OCS']['col_tab'][$tab_name])){
$col_tab=explode("///", $_COOKIE[$tab_name]);
foreach ($col_tab as $key=>$value){
$_SESSION['OCS']['col_tab'][$tab_name][$value]=$value;
}
}
if (isset($protectedPost['SUP_COL']) and $protectedPost['SUP_COL'] != ""){
unset($_SESSION['OCS']['col_tab'][$tab_name][$protectedPost['SUP_COL']]);
}
if ($protectedPost['restCol'.$tab_name]){
$_SESSION['OCS']['col_tab'][$tab_name][$protectedPost['restCol'.$tab_name]]=$protectedPost['restCol'.$tab_name];
}
if ($protectedPost['RAZ'] != ""){
unset($_SESSION['OCS']['col_tab'][$tab_name]);
$_SESSION['OCS']['col_tab'][$tab_name]=$default_fields;
}
if (!isset($_SESSION['OCS']['col_tab'][$tab_name])){
$_SESSION['OCS']['col_tab'][$tab_name]=$default_fields;
}
//add all fields we must have
if (is_array($list_col_cant_del)){
if (!is_array($_SESSION['OCS']['col_tab'][$tab_name]))
$_SESSION['OCS']['col_tab'][$tab_name]=array();
foreach ($list_col_cant_del as $key=>$value){
if (!in_array($key,$_SESSION['OCS']['col_tab'][$tab_name])){
$_SESSION['OCS']['col_tab'][$tab_name][$key]=$key;
}
}
}
if (is_array($entete)){
if (!is_array($_SESSION['OCS']['col_tab'][$tab_name]))
$_SESSION['OCS']['col_tab'][$tab_name]=array();
foreach ($entete as $k=>$v){
if (in_array($k,$_SESSION['OCS']['col_tab'][$tab_name])){
$data_with_filter['entete'][$k]=$v;
if (!isset($list_col_cant_del[$k]))
$data_with_filter['entete'][$k].="";
}
else
$list_rest[$k]=$v;
}
}
if (is_array($data)){
if (!is_array($_SESSION['OCS']['col_tab'][$tab_name]))
$_SESSION['OCS']['col_tab'][$tab_name]=array();
foreach ($data as $k=>$v){
foreach ($v as $k2=>$v2){
if (in_array($k2,$_SESSION['OCS']['col_tab'][$tab_name])){
$data_with_filter['data'][$k][$k2]=$v2;
}
}
}
}
if (is_array ($list_rest)){
//$list_rest=lbl_column($list_rest);
$select_restCol= $l->g(349).": ".show_modif($list_rest,'restCol'.$tab_name,2,$form_name);
$select_restCol .= "
"; //
echo $select_restCol;
}else
echo "
";
echo "";
echo "";
echo "";
return( $data_with_filter);
}
function lbl_column($list_fields){
//p($list_rest);
require_once('maps.php');
$return_fields=array();
$return_default=array();
foreach($list_fields as $poub=>$table){
if (isset($lbl_column[$table])){
foreach($lbl_column[$table] as $field=>$lbl){
//echo $field;
if (isset($alias_table[$table])){
$return_fields[$lbl]=$alias_table[$table].'.'.$field;
if (isset($default_column[$table])){
foreach($default_column[$table] as $poub2=>$default_field)
$return_default[$lbl_column[$table][$default_field]]=$lbl_column[$table][$default_field];
}else{
msg_error($table.' DEFAULT VALUES NOT DEFINE IN MAPS.PHP');
return false;
}
}else{
msg_error($table.' ALIAS NOT DEFINE IN MAPS.PHP');
return false;
}
}
}else{
msg_error($table.' NOT DEFINE IN MAPS.PHP');
return false;
}
}
ksort($return_fields);
return array('FIELDS'=>$return_fields,'DEFAULT_FIELDS'=>$return_default);
}
function tab_req($table_name,$list_fields,$default_fields,$list_col_cant_del,$queryDetails,$form_name,$width='100',$tab_options='')
{
global $protectedPost,$l,$pages_refs;
if (!$tab_options['AS'])
$tab_options['AS']=array();
if ($_SESSION['OCS']["tabcache"] == 0)
$tab_options['CACHE']='RESET';
echo "";
$link=$_SESSION['OCS']["readServer"];
//show select nb page
$limit=nb_page($form_name,100,"","",$table_name);
//you want to filter your result
if (isset($tab_options['FILTRE'])){
$Details=filtre($tab_options['FILTRE'],$form_name,$queryDetails,$tab_options['ARG_SQL'],$tab_options['ARG_SQL_COUNT']);
$queryDetails=$Details['SQL'];
if (is_array($Details['ARG']))
$tab_options['ARG_SQL']=$Details['ARG'];
if (is_array($Details['ARG_COUNT']))
$tab_options['ARG_SQL_COUNT']=$Details['ARG_COUNT'];
}
//by default, sort by column 1
if ($protectedPost['tri_'.$table_name] == "" or (!in_array ($protectedPost['tri_'.$table_name], $list_fields) and !in_array ($protectedPost['tri_'.$table_name], $tab_options['AS'])))
$protectedPost['tri_'.$table_name]=1;
//by default, sort ASC
if ($protectedPost['sens_'.$table_name] == "")
$protectedPost['sens_'.$table_name]='ASC';
//if data is signed and data = ip
$tab_iplike=array('H.IPADDR','IPADDRESS','IP','IPADDR');
if (in_array(mb_strtoupper($protectedPost['tri_'.$table_name]),$tab_iplike)){
$queryDetails.= " order by INET_ATON(".$protectedPost['tri_'.$table_name].") ".$protectedPost['sens_'.$table_name];
}elseif ($tab_options['TRI']['SIGNED'][$protectedPost['tri_'.$table_name]])
$queryDetails.= " order by cast(".$protectedPost['tri_'.$table_name]." as signed) ".$protectedPost['sens_'.$table_name];
elseif($tab_options['TRI']['DATE'][$protectedPost['tri_'.$table_name]]){
if(isset($tab_options['ARG_SQL'])){
$queryDetails.=" order by STR_TO_DATE(%s,'%s') %s";
$tab_options['ARG_SQL'][]=$protectedPost['tri_'.$table_name];
$tab_options['ARG_SQL'][]=$tab_options['TRI']['DATE'][$protectedPost['tri_'.$table_name]];
$tab_options['ARG_SQL'][]=$protectedPost['sens_'.$table_name];
}else
$queryDetails.= " order by STR_TO_DATE(".$protectedPost['tri_'.$table_name].",'".$tab_options['TRI']['DATE'][$protectedPost['tri_'.$table_name]]."') ".$protectedPost['sens_'.$table_name];
}else
$queryDetails.= " order by ".$protectedPost['tri_'.$table_name]." ".$protectedPost['sens_'.$table_name];
if (isset($protectedPost["pcparpage"]) and $protectedPost["pcparpage"]<= 200){
$limit_result_cache=200;
$force_no_cache=false;
}elseif (isset($protectedPost["pcparpage"])){
$limit_result_cache=$protectedPost["pcparpage"];
$force_no_cache=true;
}
//$tab_options['CACHE']='RESET';
//suppression de la limite de cache
//si on est sur la m�me page mais pas sur le m�me onglet
if ($_SESSION['OCS']['csv']['SQL'][$table_name] != $queryDetails or (isset($tab_options['ARG_SQL']) and $tab_options['ARG_SQL'] != $_SESSION['OCS']['csv']['ARG'][$table_name])){
unset($protectedPost['page']);
$tab_options['CACHE']='RESET';
}
//Delete cache
if ($tab_options['CACHE']=='RESET'
or (isset($protectedPost['SUP_PROF']) and $protectedPost['SUP_PROF'] != '')
or (isset($protectedPost['RESET']) and $protectedPost['RESET'] != '') ){
if ($_SESSION['OCS']['DEBUG'] == 'ON')
msg_info($l->g(5003));
unset($_SESSION['OCS']['DATA_CACHE'][$table_name]);
unset($_SESSION['OCS']['NUM_ROW'][$table_name]);
}
if (isset($_SESSION['OCS']['NUM_ROW'][$table_name])
and $_SESSION['OCS']['NUM_ROW'][$table_name]>$limit["BEGIN"]
and $_SESSION['OCS']['NUM_ROW'][$table_name]<=$limit["END"]
and !isset($_SESSION['OCS']['DATA_CACHE'][$table_name][$limit["END"]])){
if ($_SESSION['OCS']['DEBUG'] == 'ON')
msg_info($l->g(5004)." ".$limit["END"]." => ".($_SESSION['OCS']['NUM_ROW'][$table_name]-1));
$limit["END"]=$_SESSION['OCS']['NUM_ROW'][$table_name]-1;
}
if (isset($_SESSION['OCS']['DATA_CACHE'][$table_name][$limit["END"]]) and isset($_SESSION['OCS']['NUM_ROW'][$table_name])){
if ($_SESSION['OCS']['DEBUG'] == 'ON')
msg_info($l->g(5005));
$var_limit=$limit["BEGIN"];
while ($var_limit<=$limit["END"]){
$sql_data[$var_limit]=$_SESSION['OCS']['DATA_CACHE'][$table_name][$var_limit];
$var_limit++;
}
$num_rows_result=$_SESSION['OCS']['NUM_ROW'][$table_name];
if (isset($_SESSION['OCS']['REPLACE_VALUE_ALL_TIME']))
$tab_options['REPLACE_VALUE_ALL_TIME']=$_SESSION['OCS']['REPLACE_VALUE_ALL_TIME'];
$result_data=gestion_donnees($sql_data,$list_fields,$tab_options,$form_name,$default_fields,$list_col_cant_del,$queryDetails,$table_name);
$data=$result_data['DATA'];
$entete=$result_data['ENTETE'];
$correct_list_col_cant_del=$result_data['correct_list_col_cant_del'];
$correct_list_fields=$result_data['correct_list_fields'];
$i=1;
}else
{
//search static values
if (isset($_SESSION['OCS']['SQL_DATA_FIXE'][$table_name])){
foreach ($_SESSION['OCS']['SQL_DATA_FIXE'][$table_name] as $key=>$sql){
if (!isset($_SESSION['OCS']['ARG_DATA_FIXE'][$table_name][$key]))
$arg=array();
else
$arg=$_SESSION['OCS']['ARG_DATA_FIXE'][$table_name][$key];
if ($table_name == "TAB_MULTICRITERE"){
$sql.=" and hardware_id in (".implode(',',$_SESSION['OCS']['ID_REQ']).") group by hardware_id ";
//ajout du group by pour r�gler le probl�me des r�sultats multiples sur une requete
//on affiche juste le premier crit�re qui match
$result = mysql_query($sql, $_SESSION['OCS']["readServer"]);
}else{
//add sort on column if need it
if ($protectedPost['tri_fixe']!='' and strstr($sql,$protectedPost['tri_fixe'])){
$sql.=" order by '%s' %s";
array_push($protectedPost['tri_fixe'],$arg);
array_push($protectedPost['sens_'.$table_name],$arg);
}
$result = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"],$arg);
}
while($item = mysql_fetch_object($result)){
if ($item->HARDWARE_ID != "")
$champs_index=$item->HARDWARE_ID;
elseif($item->FILEID != "")
$champs_index=$item->FILEID;
//echo $champs_index." ";
if (isset($tablename_fixe_value)){
if (strstr($sql,$tablename_fixe_value[0]))
$list_id_tri_fixe[]=$champs_index;
}
foreach ($item as $field=>$value){
if ($field != "HARDWARE_ID" and $field != "FILEID" and $field != "ID"){
// echo " champs => ".$field." valeur => ".$value;
$tab_options['REPLACE_VALUE_ALL_TIME'][$field][$champs_index]=$value;
}
}
}
}
if (isset($tab_options['REPLACE_VALUE_ALL_TIME']))
$_SESSION['OCS']['REPLACE_VALUE_ALL_TIME']=$tab_options['REPLACE_VALUE_ALL_TIME'];
}
// print_r($tab_options['VALUE']);
// print_r($list_id_tri_fixe);
//on vide les valeurs pr�c�dentes
//pour optimiser la place sur le serveur
if(!isset($tab_options['SAVE_CACHE']))
unset($_SESSION['OCS']['csv'],$_SESSION['OCS']['list_fields']);
$_SESSION['OCS']['csv']['SQL'][$table_name]=$queryDetails;
if (isset($tab_options['ARG_SQL']))
$_SESSION['OCS']['csv']['ARG'][$table_name]=$tab_options['ARG_SQL'];
//requete de count
unset($_SESSION['OCS']['NUM_ROW']);
if (!isset($_SESSION['OCS']['NUM_ROW'][$table_name])){
unset($_SESSION['OCS']['NUM_ROW']);
if (!isset($tab_options['SQL_COUNT'])){
$querycount_begin="select count(*) count_nb_ligne ";
if (stristr($queryDetails,"group by") and substr_count($queryDetails,"group by") == 1){
$querycount_end=",".substr( $queryDetails,6);
}else
$querycount_end=stristr($queryDetails, 'from ');
$querycount=$querycount_begin.$querycount_end;
}else
$querycount=$tab_options['SQL_COUNT'];
if (isset($tab_options['ARG_SQL_COUNT'])){
$resultcount = mysql2_query_secure($querycount, $link,$tab_options['ARG_SQL_COUNT']);
}
elseif (isset($tab_options['ARG_SQL']))
$resultcount = mysql2_query_secure($querycount, $link,$tab_options['ARG_SQL']);
else
$resultcount = mysql2_query_secure($querycount, $link);
//if this query is only for show data (like :
//select '%s' as NOM,'%s' as LIBELLE)
if (!stristr($queryDetails,"from"))
unset($resultcount) ;
//En dernier recourt, si le count n'est pas bon,
//on joue la requete initiale
if (!$resultcount){
if (isset($tab_options['ARG_SQL'])){
$resultcount = mysql2_query_secure($queryDetails, $link,$tab_options['ARG_SQL']);
}else
$resultcount = mysql2_query_secure($queryDetails, $link);
}
if ($resultcount)
$num_rows_result = mysql_num_rows($resultcount);
//echo "".$num_rows_result."";
if ($num_rows_result==1){
$count=mysql_fetch_object($resultcount);
// echo $queryDetails;
if ($count->count_nb_ligne > 0)
$num_rows_result = $count->count_nb_ligne;
}
$_SESSION['OCS']['NUM_ROW'][$table_name]=$num_rows_result;
}else{
$num_rows_result=$_SESSION['OCS']['NUM_ROW'][$table_name];
if ($_SESSION['OCS']['DEBUG'] == 'ON')
msg_info($l->g(5007));
}
//echo $querycount;
//FIN REQUETE COUNT
if (isset($limit)){
if ($limit["END"]<$limit_result_cache)
$queryDetails.=" limit ".$limit_result_cache;
else{
$queryDetails.=" limit ".floor($limit["END"]/$limit_result_cache)*$limit_result_cache.",".$limit_result_cache;
}
}
if (isset($tab_options['ARG_SQL']))
$resultDetails = mysql2_query_secure($queryDetails, $link,$tab_options['ARG_SQL']);
else
$resultDetails = mysql2_query_secure($queryDetails, $link);
flush();
$i=floor($limit["END"]/$limit_result_cache)*$limit_result_cache;
$index=$limit["BEGIN"];
$value_data_begin=$limit["BEGIN"];
$value_data_end=$limit["END"]+1;
//echo $num_rows_result;
if ($index>$num_rows_result){
$value_data_end=$num_rows_result-1;
}
//echo $queryDetails;
while($item = mysql_fetch_object($resultDetails)){
if ($i>=$index){
unset($champs_index);
if ($item->ID != "")
$champs_index=$item->ID;
elseif($item->FILEID != "")
$champs_index=$item->FILEID;
if (isset($list_id_tri_fixe)){
$index=$champs_index;
}
if ($index>$num_rows_result){
break;
}
//on arr�te le traitement si on est au dessus du nombre de ligne
foreach($item as $key => $value){
$sql_data_cache[$index][$key]=$value;
if ($index<$value_data_end and $index>=$value_data_begin){
flush();
$sql_data[$index][$key]=$value;
foreach ($list_fields as $key=>$value){
if ($tab_options['VALUE'][$key]){
if ($tab_options['VALUE'][$key][$champs_index] == "" and isset($tab_options['VALUE_DEFAULT'][$key]))
$sql_data[$index][$value]=$tab_options['VALUE_DEFAULT'][$key];
else
$sql_data[$index][$value]=$tab_options['VALUE'][$key][$champs_index];
}
}
}
//ajout des valeurs statiques
foreach ($list_fields as $key=>$value){
if ($tab_options['VALUE'][$key]){
if ($tab_options['VALUE'][$key][$champs_index] == "" and isset($tab_options['VALUE_DEFAULT'][$key]))
$sql_data_cache[$index][$value]=$tab_options['VALUE_DEFAULT'][$key];
else
$sql_data_cache[$index][$value]=$tab_options['VALUE'][$key][$champs_index];
}
}
}
$index++;
}
$i++;
}
// if ($i == 1){
// $num_rows_result=1;
// $_SESSION['OCS']['NUM_ROW'][$table_name]=1;
// }
flush();
//traitement du tri des r�sultats sur une valeur fixe
if (isset($list_id_tri_fixe)){
$i=0;
//parcourt des id tri�s
while ($list_id_tri_fixe[$i]){
if ($limit["BEGIN"] <= $i and $i <$limit["BEGIN"]+$limit_result_cache)
$sql_data_tri_fixe[$i]=$sql_data[$list_id_tri_fixe[$i]];
$i++;
}
unset($sql_data);
$sql_data=$sql_data_tri_fixe;
}
// print_r($sql_data_cache);
//on vide le cache des autres tableaux
//pour optimiser la place dispo sur le serveur
unset($_SESSION['OCS']['DATA_CACHE']);
if (!$force_no_cache)
$_SESSION['OCS']['DATA_CACHE'][$table_name]=$sql_data_cache;
$result_data=gestion_donnees($sql_data,$list_fields,$tab_options,$form_name,$default_fields,$list_col_cant_del,$queryDetails,$table_name);
$data=$result_data['DATA'];
$entete=$result_data['ENTETE'];
$correct_list_col_cant_del=$result_data['correct_list_col_cant_del'];
$correct_list_fields=$result_data['correct_list_fields'];
}
if ($num_rows_result > 0){
if (count($data) == 1 and (!isset($protectedPost['page']) or $protectedPost['page'] == 0))
$num_rows_result=1;
$title=$num_rows_result." ".$l->g(90);
if (isset($tab_options['LOGS']))
addLog($tab_options['LOGS'],$num_rows_result." ".$l->g(90));
if (!isset($tab_options['no_download_result']))
$title.= " (".$l->g(183).")";
$result_with_col=gestion_col($entete,$data,$correct_list_col_cant_del,$form_name,$table_name,$list_fields,$correct_list_fields,$form_name);
$no_result=tab_entete_fixe($result_with_col['entete'],$result_with_col['data'],$title,$width,"",array(),$tab_options);
if ($no_result){
show_page($num_rows_result,$form_name);
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
return TRUE;
}else
return FALSE;
}else{
echo "";
msg_warning($l->g(766));
return FALSE;
}
}
//fonction qui permet de g�rer les donn�es � afficher dans le tableau
function gestion_donnees($sql_data,$list_fields,$tab_options,$form_name,$default_fields,$list_col_cant_del,$queryDetails,$table_name){
global $l,$protectedPost,$pages_refs;
//p($tab_options['REPLACE_VALUE_ALL_TIME']);
$_SESSION['OCS']['list_fields'][$table_name]=$list_fields;
//requete de condition d'affichage
//attention: la requete doit etre du style:
//select champ1 AS FIRST from table where...
if (isset($tab_options['REQUEST'])){
foreach ($tab_options['REQUEST'] as $field_name => $value){
$tab_condition[$field_name]=array();
$resultDetails = mysql2_query_secure($value, $_SESSION['OCS']["readServer"],$tab_options['ARG'][$field_name]);
while($item = mysql_fetch_object($resultDetails)){
$tab_condition[$field_name][$item -> FIRST]=$item -> FIRST;
}
}
}
if (isset($sql_data)){
foreach ($sql_data as $i=>$donnees){
foreach($list_fields as $key=>$value){
$htmlentities=true;
$truelabel=$key;
// p($tab_options);
//gestion des as de colonne
if (isset($tab_options['AS'][$value]))
$value=$tab_options['AS'][$value];
//echo $value." ";
$num_col=$key;
if ($default_fields[$key])
$correct_list_fields[$num_col]=$num_col;
if ($list_col_cant_del[$key])
$correct_list_col_cant_del[$num_col]=$num_col;
$alias=explode('.',$value);
if (isset($alias[1])){
$no_alias_value=$alias[1];
}else
$no_alias_value=$value;
//echo $no_alias_value;
//si aucune valeur, on affiche un espace
if ($donnees[$no_alias_value] == ""){
$value_of_field = " ";
$htmlentities=false;
}else //sinon, on affiche la valeur
{
$value_of_field=$donnees[$no_alias_value];
}
//utf8 or not?
$value_of_field=data_encode_utf8($value_of_field);
$col[$i]=$key;
if ($protectedPost['sens_'.$table_name] == "ASC")
$sens="DESC";
else
$sens="ASC";
$affich='OK';
//on n'affiche pas de lien sur les colonnes non pr�sentes dans la requete
if (isset($tab_options['NO_TRI'][$key]))
$lien='KO';
else
$lien='OK';
if (isset($tab_options['REPLACE_VALUE_ALL_TIME'][$key])){
if (isset($tab_options['FIELD_REPLACE_VALUE_ALL_TIME']))
$value_of_field=$tab_options['REPLACE_VALUE_ALL_TIME'][$key][$donnees[$tab_options['FIELD_REPLACE_VALUE_ALL_TIME']]];
else
$value_of_field=$tab_options['REPLACE_VALUE_ALL_TIME'][$key][$donnees['ID']];
}
if (isset($tab_options['REPLACE_VALUE'][$key])){
//if multi value, $temp_val[1] isset
$temp_val=explode('&&&',$value_of_field);
$multi_value=0;
$temp_value_of_field="";
while (isset($temp_val[$multi_value])){
$temp_value_of_field.=$tab_options['REPLACE_VALUE'][$key][$temp_val[$multi_value]]." ";
$multi_value++;
}
$temp_value_of_field=substr($temp_value_of_field,0,-4);
$value_of_field=$temp_value_of_field;
}
if (isset($tab_options['REPLACE_WITH_CONDITION'][$key][$value_of_field])){
if (!is_array($tab_options['REPLACE_WITH_CONDITION'][$key][$value_of_field]))
$value_of_field= $tab_options['REPLACE_WITH_CONDITION'][$key][$value_of_field];
else{
foreach ($tab_options['REPLACE_WITH_CONDITION'][$key][$value_of_field] as $condition=>$condition_value){
if ($donnees[$condition] == '' or is_null($donnees[$condition]))
{
$value_of_field=$condition_value;
}
}
}
}
if (isset($tab_options['REPLACE_WITH_LIMIT']['UP'][$key])){
if ($value_of_field > $tab_options['REPLACE_WITH_LIMIT']['UP'][$key])
$value_of_field= $tab_options['REPLACE_WITH_LIMIT']['UPVALUE'][$key];
}
if (isset($tab_options['REPLACE_WITH_LIMIT']['DOWN'][$key])){
if ($value_of_field < $tab_options['REPLACE_WITH_LIMIT']['DOWN'][$key])
$value_of_field = $tab_options['REPLACE_WITH_LIMIT']['DOWNVALUE'][$key];
}
unset($key2);
if (isset($tab_condition[$key])){
if ((!$tab_condition[$key][$donnees[$tab_options['FIELD'][$key]]] and !$tab_options['EXIST'][$key])
or ($tab_condition[$key][$donnees[$tab_options['FIELD'][$key]]] and $tab_options['EXIST'][$key])){
if ($key == "STAT" or $key == "SUP" or $key == "CHECK"){
$key2 = "NULL";
}else{
$data[$i][$num_col]=htmlspecialchars($value_of_field, ENT_QUOTES);
$affich="KO";
}
}
}
//if (!isset($entete[$num_col])){
if (!isset($tab_options['LBL'][$key])){
$entete[$num_col]=$key;
}else
$entete[$num_col]=$tab_options['LBL'][$key];
//}
if (isset($tab_options['NO_LIEN_CHAMP']['SQL'][$key])){
$exit=false;
foreach ($tab_options['NO_LIEN_CHAMP']['SQL'][$key] as $id=>$sql_rest){
$sql=$sql_rest;
if (isset($tab_options['NO_LIEN_CHAMP']['ARG'][$id][$key]))
$arg=$donnees[$tab_options['NO_LIEN_CHAMP']['ARG'][$id][$key]];
else
$arg="";
$result_lien = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"],$arg);
if ($item = mysql_fetch_object($result_lien)){
$data[$i][$num_col]="".$value_of_field."";
// $exit=true;
break;
}else
echo 'toto';
}
}
//si un lien doit �tre mis sur le champ
//l'option $tab_options['NO_LIEN_CHAMP'] emp�che de mettre un lien sur certaines
//valeurs du champs
//exemple, si vous ne voulez pas mettre un lien si le champ est 0,
//$tab_options['NO_LIEN_CHAMP'][$key] = array(0);
if (isset($tab_options['LIEN_LBL'][$key]) and !is_array($tab_options['LIEN_LBL'][$key])
and (!isset($tab_options['NO_LIEN_CHAMP'][$key]) or !in_array($value_of_field,$tab_options['NO_LIEN_CHAMP'][$key]))){
$affich="KO";
if (!isset($tab_options['LIEN_TYPE'][$key])){
$data[$i][$num_col]="".$value_of_field."";
}else{
if (!isset($tab_options['POPUP_SIZE'][$key]))
$size="width=550,height=350";
else
$size=$tab_options['POPUP_SIZE'][$key];
$data[$i][$num_col]="".$value_of_field."";
}
}
if (isset($tab_options['JAVA']['CHECK'])){
$javascript="OnClick='confirme(\"".htmlspecialchars($donnees[$tab_options['JAVA']['CHECK']['NAME']], ENT_QUOTES)."\",".$value_of_field.",\"".$form_name."\",\"CONFIRM_CHECK\",\"".htmlspecialchars($tab_options['JAVA']['CHECK']['QUESTION'], ENT_QUOTES)." \")'";
}else
$javascript="";
//si on a demander un affichage que sur certaine ID
if (is_array($tab_options) and !$tab_options['SHOW_ONLY'][$key][$value_of_field] and $tab_options['SHOW_ONLY'][$key]){
$key = "NULL";
}
if (isset($tab_options['COLOR'][$key])){
$value_of_field="".$value_of_field."";
$htmlentities=false;
}
if ($affich == 'OK'){
$lbl_column=array("SUP"=>$l->g(122),
"MODIF"=>$l->g(115),
"CHECK"=>$l->g(1119) . "");
if (!isset($tab_options['NO_NAME']['NAME']))
$lbl_column["NAME"]=$l->g(23);
//modify lbl of column
if (!isset($entete[$num_col])
or ($entete[$num_col] == $key and !isset($tab_options['LBL'][$key]))){
if (array_key_exists($key,$lbl_column))
$entete[$num_col]=$lbl_column[$key];
else
$entete[$num_col]=$truelabel;
}
if ($key == "NULL" or isset($key2)){
$data[$i][$num_col]=" ";
$lien = 'KO';
}elseif ($key == "GROUP_NAME"){
$data[$i][$num_col]="".$value_of_field."";
}elseif ($key == "SUP" and $value_of_field!= ' '){
if (isset($tab_options['LBL_POPUP'][$key])){
if (isset($donnees[$tab_options['LBL_POPUP'][$key]]))
$lbl_msg=$l->g(640)." ".$donnees[$tab_options['LBL_POPUP'][$key]];
else
$lbl_msg=$tab_options['LBL_POPUP'][$key];
}else
$lbl_msg=$l->g(640)." ".$value_of_field;
$data[$i][$num_col]="";
$lien = 'KO';
}elseif ($key == "MODIF"){
if (!isset($tab_options['MODIF']['IMG']))
$image="image/modif_tab.png";
else
$image=$tab_options['MODIF']['IMG'];
$data[$i][$num_col]="";
$lien = 'KO';
}elseif ($key == "SELECT"){
$data[$i][$num_col]="";
$lien = 'KO';
}elseif ($key == "OTHER"){
$data[$i][$num_col]="";
$lien = 'KO';
}elseif ($key == "ZIP"){
$data[$i][$num_col]="";
$lien = 'KO';
}
elseif ($key == "STAT"){
$data[$i][$num_col]="";
$lien = 'KO';
}elseif ($key == "ACTIVE"){
$data[$i][$num_col]="";
$lien = 'KO';
}elseif ($key == "SHOWACTIVE"){
$data[$i][$num_col]="".$value_of_field."";
}
elseif ($key == "CHECK" and $value_of_field!= ' '){
$data[$i][$num_col]="";
$lien = 'KO';
}elseif ($key == "NAME" and !isset($tab_options['NO_NAME']['NAME'])){
$link_computer="index.php?".PAG_INDEX."=".$pages_refs['ms_computer']."&head=1";
if ($donnees['ID'])
$link_computer.="&systemid=".$donnees['ID'];
if ($donnees['MD5_DEVICEID'])
$link_computer.= "&crypt=".$donnees['MD5_DEVICEID'];
$data[$i][$num_col]="".$value_of_field."";
}elseif ($key == "MAC"){
//echo substr($value_of_field,0,8);
//echo $_SESSION['OCS']["mac"][substr($value_of_field,0,8)];
if (isset($_SESSION['OCS']["mac"][mb_strtoupper(substr($value_of_field,0,8))]))
$constr=$_SESSION['OCS']["mac"][mb_strtoupper(substr($value_of_field,0,8))];
else
$constr="".$l->g(885)."";
//echo "=>".$constr." ";
$data[$i][$num_col]=$value_of_field." (".$constr.")";
}elseif (substr($key,0,11) == "PERCENT_BAR"){
require_once("function_graphic.php");
$data[$i][$num_col]="
".percent_bar($value_of_field)."
";
//$lien = 'KO';
}
else{
if (isset($tab_options['OTHER'][$key][$value_of_field])){
$end="";
}elseif (isset($tab_options['OTHER_BIS'][$key][$value_of_field])){
$end="";
}elseif (isset($tab_options['OTHER_TER'][$key][$value_of_field])){
$end="";
}else{
$end="";
}
if ($htmlentities)
//$value_of_field=htmlentities($value_of_field,ENT_COMPAT,'UTF-8');
$value_of_field=strip_tags_array($value_of_field);
$data[$i][$num_col]=$value_of_field.$end;
}
}
if ($lien == 'OK'){
$deb="";
$fin="";
$entete[$num_col]=$deb.$entete[$num_col].$fin;
if ($protectedPost['tri_'.$table_name] == $value){
if ($protectedPost['sens_'.$table_name] == 'ASC')
$img="";
else
$img="";
$entete[$num_col]=$img.$entete[$num_col];
}
}
}
}
if ($tab_options['UP']){
$i=0;
while($data[$i]){
foreach ($tab_options['UP'] as $key=>$value){
if ($data[$i][$key] == $value){
$value_temp=$data[$i];
unset($data[$i]);
}
}
$i++;
}
array_unshift ($data, $value_temp);
}
// echo $protectedPost['tri_'.$table_name];
// echo " ";
//p($tab_options['REPLACE_VALUE']);
if(isset($tab_options['REPLACE_VALUE'][$protectedPost['tri_'.$table_name]])){
//p($data);
//echo " ";
if ($protectedPost['sens_repart_tag'] == 'ASC')
asort($data);
else
arsort($data);
// p($data);
}
return array('ENTETE'=>$entete,'DATA'=>$data,'correct_list_fields'=>$correct_list_fields,'correct_list_col_cant_del'=>$correct_list_col_cant_del);
}else
return false;
}
function del_selection($form_name){
global $l;
echo "";
echo "
![\"Pick](\"image/cal.gif\")
";
elseif ($protectedPost['SHOW'] != 'NEVER_SHOW')
$html_show .= "
";
$html_show .= "
";
//if ($nbpage<10){
$i=0;
$deja="";
while ($i<$nbpage){
$point="";
if ($protectedPost['page'] == $i){
if ($i<$nbpage-10 and $i>10 and $deja==""){
$point=" ... ";
$deja="ok";
}
if($i<$nbpage-10 and $i>10){
$point2=" ... ";
}
echo $point."".$i." ".$point2;
}
elseif($i>$nbpage-10 or $i<10)
echo "".$i." ";
elseif ($i<$nbpage-10 and $i>10 and $deja==""){
echo " ... ";
$deja="ok";
}
$i++;
}
if ($protectedPost['page']< $nbpage-1)
echo "
";
}
echo "
";
$lien = 'KO';
}elseif ($key == "OTHER"){
$data[$i][$num_col]="
";
$lien = 'KO';
}elseif ($key == "ZIP"){
$data[$i][$num_col]="
";
$lien = 'KO';
}
elseif ($key == "STAT"){
$data[$i][$num_col]="
";
$lien = 'KO';
}elseif ($key == "ACTIVE"){
$data[$i][$num_col]="
";
$lien = 'KO';
}elseif ($key == "SHOWACTIVE"){
$data[$i][$num_col]="".$value_of_field."";
}
elseif ($key == "CHECK" and $value_of_field!= ' '){
$data[$i][$num_col]="";
$lien = 'KO';
}elseif ($key == "NAME" and !isset($tab_options['NO_NAME']['NAME'])){
$link_computer="index.php?".PAG_INDEX."=".$pages_refs['ms_computer']."&head=1";
if ($donnees['ID'])
$link_computer.="&systemid=".$donnees['ID'];
if ($donnees['MD5_DEVICEID'])
$link_computer.= "&crypt=".$donnees['MD5_DEVICEID'];
$data[$i][$num_col]="".$value_of_field."";
}elseif ($key == "MAC"){
//echo substr($value_of_field,0,8);
//echo $_SESSION['OCS']["mac"][substr($value_of_field,0,8)];
if (isset($_SESSION['OCS']["mac"][mb_strtoupper(substr($value_of_field,0,8))]))
$constr=$_SESSION['OCS']["mac"][mb_strtoupper(substr($value_of_field,0,8))];
else
$constr="".$l->g(885)."";
//echo "=>".$constr."
";
else
$img="
";
$entete[$num_col]=$img.$entete[$num_col];
}
}
}
}
if ($tab_options['UP']){
$i=0;
while($data[$i]){
foreach ($tab_options['UP'] as $key=>$value){
if ($data[$i][$key] == $value){
$value_temp=$data[$i];
unset($data[$i]);
}
}
$i++;
}
array_unshift ($data, $value_temp);
}
// echo $protectedPost['tri_'.$table_name];
// echo "