function affich_detail_simple($form_name, $list_fields, $list_col_cant_del, $default_fields, $table, $tab_options = array()) { $form_name = "affich_controllers"; $table_name = $form_name; echo open_form($form_name); // $list_fields=array($l->g(64) => 'MANUFACTURER', // $l->g(49) => 'NAME', // $l->g(66) => 'TYPE', // 'Caption'=>'CAPTION', // $l->g(53)=>'DESCRIPTION', // $l->g(277)=> 'VERSION'); // //$list_fields['SUP']= 'ID'; // $list_col_cant_del[$l->g(66)]=$l->g(66); // $default_fields= array($l->g(64)=>$l->g(64),$l->g(49)=>$l->g(49),$l->g(66)=>$l->g(66)); $queryDetails = "SELECT "; foreach ($list_fields as $lbl => $value) { $queryDetails .= $value . ","; } $queryDetails = substr($queryDetails, 0, -1) . " FROM " . $table . " WHERE (hardware_id={$systemid})"; tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $queryDetails, $form_name, 80, $tab_options); echo close_form(); }
function affich_detail_simple($form_name, $list_fields, $list_col_cant_del, $default_fields, $table, $tab_options = array()) { if (AJAX) { parse_str($protectedPost['ocs']['0'], $params); $protectedPost += $params; ob_start(); $ajax = true; } else { $ajax = false; } $form_name = "affich_controllers"; $table_name = $form_name; $tab_options = $protectedPost; $tab_options['form_name'] = $form_name; $tab_options['table_name'] = $table_name; echo open_form($form_name); // $list_fields=array($l->g(64) => 'MANUFACTURER', // $l->g(49) => 'NAME', // $l->g(66) => 'TYPE', // 'Caption'=>'CAPTION', // $l->g(53)=>'DESCRIPTION', // $l->g(277)=> 'VERSION'); // //$list_fields['SUP']= 'ID'; // $list_col_cant_del[$l->g(66)]=$l->g(66); // $default_fields= array($l->g(64)=>$l->g(64),$l->g(49)=>$l->g(49),$l->g(66)=>$l->g(66)); $queryDetails = "SELECT "; foreach ($list_fields as $lbl => $value) { $queryDetails .= $value . ","; } $queryDetails = substr($queryDetails, 0, -1) . " FROM " . $table . " WHERE (hardware_id={$systemid})"; ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); echo close_form(); if ($ajax) { ob_end_clean(); tab_req($list_fields, $default_fields, $list_col_cant_del, $queryDetails, $tab_options); ob_start(); } }
asort($optArray_trait); $protectedPost['multiSearch'] = $l->g(32); $aff_field_search = $l->g(31) . ": " . show_modif($optArray_trait, 'multiSearch', 2, $form_name, array('DEFAULT' => 'NO')); $aff_field_search .= "<img src='image/delete-small.png' onclick='pag(\"ok\",\"reset\",\"" . $form_name . "\");' alt='" . $l->g(41) . "' style='margin-left:20px'>"; echo "<div class='mlt_bordure'>"; echo "<div class='field'>" . $aff_field_search . "</div>"; if (isset($_SESSION['OCS']['multiSearch']) and $_SESSION['OCS']['multiSearch'] != null) { $c = 0; foreach ($_SESSION['OCS']['multiSearch'] as $k => $v) { if (!isset($alreadyExist[$v])) { $alreadyExist[$v] = 'YES'; $ajout = ''; } else { $ajout = $v; } $color = $c % 2 == 0 ? "#F2F2F2" : "#FFFFFF"; show_ligne($v, $color, $k, $ajout, $form_name); $c++; } echo "<div class='form-buttons'><input type='submit' name='Valid-search' value='" . $l->g(30) . "' onclick='garde_valeur(\"VALID\",\"Valid\");'></div>"; echo "<input type=hidden name='Valid' id='Valid' value=''>"; } echo "<input type=hidden name=delfield id=delfield value=''>"; echo "<input type=hidden name='reset' id='reset' value=''>"; echo "</div>"; echo close_form(); echo $l->g(358); if ($ajax) { ob_end_clean(); tab_req($list_fields, $default_fields, $list_col_cant_del, $queryDetails['SQL'], $tab_options); }
} $table_name = "sd_cartridges"; $tab_options = $protectedPost; $tab_options['form_name'] = $form_name; $tab_options['table_name'] = $table_name; $list_fields = array($l->g(66) => 'TYPE', $l->g(1104) => 'LEVEL', $l->g(1225) => 'MAXCAPACITY', $l->g(1226) => 'COLOR', $l->g(53) => 'DESCRIPTION'); //$list_fields['SUP']= 'ID'; $sql = prepare_sql_tab($list_fields); $list_fields["PERCENT_BAR"] = 'CAPACITY'; $tab_options["replace_query_arg"]['CAPACITY'] = "round(100-(LEVEL*100/MAXCAPACITY))"; $list_col_cant_del = $list_fields; $default_fields = $list_fields; $sql['SQL'] = $sql['SQL'] . " , round(100-(LEVEL*100/MAXCAPACITY)) AS CAPACITY FROM %s WHERE (snmp_id=%s)"; $sql['ARG'][] = 'snmp_cartridges'; $sql['ARG'][] = $systemid; $tab_options['ARG_SQL'] = $sql['ARG']; $tab_options['LBL']['PERCENT_BAR'] = $l->g(1125); $tab_options['REPLACE_WITH_LIMIT']['DOWN'][$l->g(1104)] = 0; $tab_options['REPLACE_WITH_LIMIT']['DOWNVALUE'][$l->g(1104)] = $msq_tab_error; $tab_options['REPLACE_WITH_LIMIT']['DOWN'][$l->g(1225)] = 0; $tab_options['REPLACE_WITH_LIMIT']['DOWNVALUE'][$l->g(1225)] = $msq_tab_error; $tab_options['REPLACE_WITH_LIMIT']['DOWN']['PERCENT_BAR'] = 0; $tab_options['REPLACE_WITH_LIMIT']['DOWNVALUE']['PERCENT_BAR'] = $msq_tab_error; $tab_options['REPLACE_WITH_LIMIT']['UP']['PERCENT_BAR'] = 100; $tab_options['REPLACE_WITH_LIMIT']['UPVALUE']['PERCENT_BAR'] = $msq_tab_error; ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); if ($ajax) { ob_end_clean(); tab_req($list_fields, $default_fields, $list_col_cant_del, $sql['SQL'], $tab_options); ob_start(); }
} if (!isset($protectedPost["pcparpage"])) { $protectedPost["pcparpage"] = 5; } array_shift($array_fields); $list_fields = $array_fields; $list_fields['SUP'] = 'ID'; $list_fields['CHECK'] = 'ID'; $list_col_cant_del = $list_fields; $default_fields = $list_col_cant_del; $tab_options['REPLACE_VALUE'][$l->g(66)] = $multi_choice; $tab_options['REPLACE_VALUE'][$l->g(1064)] = $yes_no; $tab_options['REPLACE_VALUE'][$l->g(1065)] = $yes_no; $tab_options['REPLACE_VALUE'][$l->g(1066)] = $status; $tab_options['LBL_POPUP']['SUP'] = 'VALUE'; tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $queryDetails, $form_name, 100, $tab_options); //traitement par lot del_selection($form_name); } } elseif ($protectedPost['onglet'] == 2) { if ($protectedPost['Valid_modif_x'] != "") { if (trim($protectedPost['newfield']) != '') { $sql_verif = "SELECT count(*) c FROM " . $table . " WHERE FIELD = '%s'"; $arg_verif = $protectedPost['newfield']; $res_verif = mysql2_query_secure($sql_verif, $_SESSION['OCS']["readServer"], $arg_verif); $val_verif = mysql_fetch_array($res_verif); //this name is already exist if ($val_verif['c'] > 0) { $ERROR = $l->g(1067); } } else {
$sql['SQL'] .= " group by " . $field_name_soft; // $_SESSION['OCS']["forcedRequest"].=" group by name"; if ($sql_fin['SQL'] != '') { $sql['SQL'] .= $sql_fin['SQL']; $sql['ARG'] = array_merge_values($sql['ARG'], $sql_fin['ARG']); // $_SESSION['OCS']["forcedRequest"].=$sql_fin; } $list_fields = array('name' => 'name', 'nbre' => 'nb'); $default_fields = $list_fields; $list_col_cant_del = $default_fields; $tab_options['LIEN_LBL']['nbre'] = 'index.php?' . PAG_INDEX . '=' . $pages_refs['ms_multi_search'] . '&prov=allsoft&value='; $tab_options['LIEN_CHAMP']['nbre'] = 'id'; $tab_options['LBL']['name'] = $l->g(847); $tab_options['LBL']['nbre'] = $l->g(1120); $tab_options['ARG_SQL'] = $sql['ARG']; $result_exist = tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $sql['SQL'], $form_name, 80, $tab_options); } echo "<br><div class='mvt_bordure'>"; echo "<b>" . $l->g(735) . "</b><br><br>"; echo $l->g(382) . ": " . show_modif($protectedPost['NAME_RESTRICT'], 'NAME_RESTRICT', 0); echo " " . $l->g(381) . ": " . show_modif(array('<' => '<', '>' => '>', '=' => '='), 'COMPAR', 2); echo show_modif($protectedPost['NBRE'], 'NBRE', 0, '', array('MAXLENGTH' => 100, 'SIZE' => 10, 'JAVASCRIPT' => $numeric)); //echo "<input type='input' name='NBRE' value='".$protectedPost['NBRE']."' ".$numeric.">"; echo "<br><a href='index.php?" . PAG_INDEX . "=" . $pages_refs['ms_soft_csv'] . "&no_header=1&soft=" . $protectedPost['NAME_RESTRICT'] . "&nb=" . $protectedPost['NBRE'] . "&comp=" . htmlentities($protectedPost['COMPAR'], ENT_COMPAT | ENT_HTML401, "UTF-8") . "'><br>" . $l->g(183) . " " . $l->g(765) . "<br></a>"; if ($protectedPost['COMPAR'] == '<' and $protectedPost['NBRE'] <= 15 and $protectedPost['NBRE'] != "") { echo "<br><a href='index.php?" . PAG_INDEX . "=" . $pages_refs['ms_soft_csv'] . "&no_header=1&soft=" . $protectedPost['NAME_RESTRICT'] . "&nb=" . $protectedPost['NBRE'] . "&comp=" . htmlentities($protectedPost['COMPAR'], ENT_COMPAT | ENT_HTML401, "UTF-8") . "&all_computers=yes'>" . $l->g(912) . "</a><br>"; } echo "<br><input type='submit' value='" . $l->g(393) . "' name='SUBMIT_FORM'><input type='submit' value='" . $l->g(396) . "' name='RESET'>"; echo '</div>'; echo '</div>'; echo close_form();
$tab_options['VALUE']['NBRE'][] = 0; } //on recherche les groupes visible pour cocher la checkbox � l'affichage if ($protectedPost['onglet'] == "STAT") { $sql = "select id from hardware where workgroup='GROUP_4_ALL'"; $result = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"]); while ($item = mysql_fetch_object($result)) { $protectedPost['check' . $item->id] = "check"; } } //on ajoute un javascript lorsque l'on clic sur la visibilit� du groupe pour tous $tab_options['JAVA']['CHECK']['NAME'] = "NAME"; $tab_options['JAVA']['CHECK']['QUESTION'] = $l->g(811); $tab_options['FILTRE'] = array('NAME' => $l->g(679), 'DESCRIPTION' => $l->g(53)); //affichage du tableau $result_exist = tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $querygroup, $form_name, 100, $tab_options); //if your profil is an admin groups, you can create one if ($_SESSION['OCS']['CONFIGURATION']['GROUPS'] == "YES") { echo "</td></tr></table>"; if ($protectedPost['onglet'] == "STAT") { echo "<BR><input type='submit' name='add_static_group' value='" . $l->g(587) . "'>"; } } //if user want add a new group if (isset($protectedPost['add_static_group']) and $_SESSION['OCS']['CONFIGURATION']['GROUPS'] == "YES") { //NAME FIELD $name_field[] = "NAME"; $tab_name[] = $l->g(577); $type_field[] = 0; $value_field[] = $protectedPost['NAME']; $name_field[] = "DESCR";
$result_exist = ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del); //if your profil is an admin groups, you can create one if ($_SESSION['OCS']['profile']->getConfigValue('GROUPS') == "YES") { echo "</td></tr></table>"; if ($protectedPost['onglet'] == "STAT") { echo "<p><input type='submit' name='add_static_group' value='" . $l->g(587) . "'></p>"; } } //if user want add a new group if (isset($protectedPost['add_static_group']) and $_SESSION['OCS']['profile']->getConfigValue('GROUPS') == "YES") { //NAME FIELD $name_field[] = "NAME"; $tab_name[] = $l->g(577); $type_field[] = 0; $value_field[] = $protectedPost['NAME']; $name_field[] = "DESCR"; $tab_name[] = $l->g(53); $type_field[] = 1; $value_field[] = $protectedPost['DESCR']; $tab_typ_champ = show_field($name_field, $type_field, $value_field); $tab_typ_champ[0]['CONFIG']['SIZE'] = 20; $tab_hidden['add_static_group'] = 'add_static_group'; tab_modif_values($tab_name, $tab_typ_champ, $tab_hidden, array('form_name' => 'NO_FORM', 'show_frame' => false)); } echo '</div>'; //fermeture du formulaire echo close_form(); if ($ajax) { ob_end_clean(); tab_req($list_fields, $default_fields, $list_col_cant_del, $querygroup, $tab_options); }
function print_computers_cached($systemid) { global $l, $server_group, $protectedPost, $list_fields, $list_col_cant_del, $default_fields, $tab_options; //print_r($protectedPost); //traitement des machines du groupe if (isset($protectedPost["actshowgroup"]) and $protectedPost["modify"] != "") { foreach ($protectedPost as $key => $val) { //check65422 if (substr($key, 0, 5) == "check") { update_computer_group(substr($key, 5), $systemid, $protectedPost["actshowgroup"]); } } $tab_options['CACHE'] = 'RESET'; } if ($_SESSION['OCS']['RESTRICTION']['GUI'] == "YES") { $sql_mesMachines = "select hardware_id from accountinfo a where " . $_SESSION['OCS']["mesmachines"]; $res_mesMachines = mysql2_query_secure($sql_mesMachines, $_SESSION['OCS']["readServer"]); $mesmachines = "("; while ($item_mesMachines = mysql_fetch_object($res_mesMachines)) { $mesmachines .= $item_mesMachines->hardware_id . ","; } $mesmachines = "and e.hardware_id IN " . substr($mesmachines, 0, -1) . ")"; } $form_name = "list_computer_groupcache"; $table_name = $form_name; echo open_form($form_name); $queryDetails = "SELECT "; foreach ($list_fields as $lbl => $value) { $queryDetails .= $value . ","; } $queryDetails = substr($queryDetails, 0, -1) . " FROM hardware h LEFT JOIN accountinfo a ON a.hardware_id=h.id\n\t\t\t\t\t\t,groups_cache e\n\t\t\t\t\t\twhere group_id='" . $systemid . "' and h.id=e.HARDWARE_ID "; if (isset($mesmachines) and $mesmachines != '') { $queryDetails .= $mesmachines; } $tab_options['FILTRE'] = array('h.NAME' => 'Nom'); $statut = tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $queryDetails, $form_name, 80, $tab_options); if ($statut) { form_action_group($systemid); } echo close_form(); }
$size = 'as size'; } else { $name = ''; $date_create = ''; $date_modif = ''; $size = ''; } $sql .= "select '%s' " . $name . ",'%s' " . $date_create . ",'%s' " . $date_modif . ",'%s' " . $size . " union "; array_push($arg, $value); array_push($arg, rtrim($data['date_create'][$id], ".")); array_push($arg, rtrim($data['date_modif'][$id], ".")); array_push($arg, round($data['size'][$id] / 1024, 3) . " " . $l->g(516)); } $sql = substr($sql, 0, -6); $list_fields = array('name' => 'name', $l->g(951) => 'date_create', $l->g(952) => 'date_modif', $l->g(953) => 'size'); $list_col_cant_del = $list_fields; $default_fields = $list_fields; // $sql= "select '%s' as function,%s from deploy"; $tab_options['ARG_SQL'] = $arg; $tab_options['LBL']['name'] = $l->g(950); $tab_options['LIEN_LBL']['name'] = 'index.php?' . PAG_INDEX . '=' . $pages_refs['ms_csv'] . '&no_header=1&log='; $tab_options['LIEN_CHAMP']['name'] = 'name'; $tab_options['LIEN_TYPE']['name'] = 'POPUP'; $tab_options['POPUP_SIZE']['name'] = "width=900,height=600"; printEntete($l->g(928)); echo "<br>"; tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $sql, $form_name, 80, $tab_options); echo close_form(); } else { msg_warning($l->g(766)); }
} } else { if ($key != 'NO_NOTIF' and $key != 'ERR_') { $_SESSION['OCS']['SQL_DATA_FIXE'][$table_name][$key] = $sql_data_fixe . " group by FILEID"; } elseif ($key == 'NO_NOTIF') { $_SESSION['OCS']['SQL_DATA_FIXE'][$table_name][$key] = $sql_data_fixe_bis . " group by FILEID"; } elseif ($key == 'ERR_') { $_SESSION['OCS']['SQL_DATA_FIXE'][$table_name][$key] = $sql_data_fixe_ter . " group by FILEID"; } } } } $tab_options['COLOR']['ERR_'] = 'RED'; $tab_options['COLOR']['SUCC'] = 'GREEN'; $tab_options['COLOR']['NOTI'] = 'GREY'; $tab_options['COLOR']['NO_NOTIF'] = 'BLACK'; $tab_options['FILTRE'] = array('FILEID' => 'Timestamp', 'NAME' => $l->g(49)); $tab_options['TYPE']['ZIP'] = $protectedPost['SHOW_SELECT']; $tab_options['FIELD_REPLACE_VALUE_ALL_TIME'] = 'FILEID'; $result_exist = tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $querypack['SQL'], $form_name, 95, $tab_options); //only for profils who can activate packet if (!$cant_active) { del_selection($form_name); if ($protectedPost['SHOW_SELECT'] == 'download') { $config_input = array('MAXLENGTH' => 10, 'SIZE' => 15); $activ_manuel = show_modif($protectedPost['manualActive'], 'manualActive', 0, '', $config_input); echo "<b>" . $l->g(476) . "</b> " . $l->g(475) . ": " . $activ_manuel . ""; echo "<a href='#' OnClick='manualActive();'><img src='image/activer.png'></a>"; } } echo close_form();
function dde_show($form_name) { global $l, $protectedPost, $protectedGet, $pages_refs; //suppression d'une demande if (isset($protectedPost['SUP_PROF']) and is_numeric($protectedPost['SUP_PROF'])) { //on récupère l'id du champ status $item_id_STATUS = find_id_field(); $sql = "UPDATE downloadwk_pack \n\t\t\t\t\t\t\t\t\t\tset FIELDS_%s='1'\n\t\t\t\t\t\t\t\t\t\twhere ID='%s'"; $arg = array($item_id_STATUS['STATUS']->id, $protectedPost['SUP_PROF']); mysql2_query_secure($sql, $_SESSION['OCS']["writeServer"], $arg); $tab_options['CACHE'] = 'RESET'; } $table_name = 'LIST_DDE'; //recherche des champs qui ont été créés $sql_fields = "select lbl,id,type,field from downloadwk_fields "; $resultfields = mysql2_query_secure($sql_fields, $_SESSION['OCS']["readServer"]); //$resultfields = mysql_query($sql_fields, $_SESSION['OCS']["readServer"]) or mysql_error($_SESSION['OCS']["readServer"]); $id_field1 = 0; $id_field2 = 0; $default_fields = array(); while ($item = mysql_fetch_object($resultfields)) { $name_field[$item->id] = $item->field; $field = 'fields_' . $item->id; if ($item->field == "STATUS") { $id_status = $field; } if (($item->type == '2' or $item->type == '5') and $item->field != "STATUS") { $array_value_fields[$id_field1] = $field . ".VALUE as " . $field; $array_fields[$id_field1] = $field; $id_field1++; } else { $else_fields[$id_field2] = "downloadwk_pack." . $field; $id_field2++; } if (count($default_fields) < 5) { $default_fields[$field] = $field; } if ($l->g($item->lbl)) { $tab_options['LBL'][$field] = $l->g($item->lbl); } else { $tab_options['LBL'][$field] = $item->lbl; } $list_fields[$field] = $field; } // print_r($tab_options['LBL']); //recherche des valeurs des différents statuts $sql_statut = "select id,lbl from downloadwk_statut_request"; $resultfields = mysql2_query_secure($sql_statut, $_SESSION['OCS']["readServer"]); while ($item = mysql_fetch_object($resultfields)) { $statut[$item->id] = $item->lbl; } $tab_options['REPLACE_VALUE'][$id_status] = $statut; $list_col_cant_del[$id_status] = $id_status; $default_fields[$id_status] = $id_status; $list_fields[$id_status] = $id_status; $list_col_cant_del['Q_DATE'] = 'Q_DATE'; $default_fields['Q_DATE'] = 'Q_DATE'; $list_fields['Q_DATE'] = 'Q_DATE'; $list_col_cant_del['SUP'] = 'SUP'; $default_fields['SUP'] = 'SUP'; $list_fields['SUP'] = 'ID'; $list_fields['MODIF'] = 'ID'; $default_fields['MODIF'] = 'MODIF'; $list_col_cant_del['MODIF'] = 'MODIF'; $tab_options['LBL']['Q_DATE'] = "Date dde"; $sql = "select downloadwk_pack.ID,FROM_UNIXTIME(Q_DATE) as Q_DATE,"; if (isset($array_value_fields)) { $sql .= implode(', ', $array_value_fields); $bool_select = true; } // print_r($else_fields); if (isset($else_fields)) { if ($bool_select) { $sql .= ", "; } $sql .= implode(', ', $else_fields); $bool_normal = true; } if (!$bool_normal and !$bool_select) { $sql .= " * "; } $sql .= " from downloadwk_pack "; $i = 0; while ($array_fields[$i]) { $sql .= " left join downloadwk_conf_values " . $array_fields[$i] . " on downloadwk_pack." . $array_fields[$i] . "=" . $array_fields[$i] . ".ID "; $i++; } $sql .= " WHERE " . $id_status . "!= (Select id from downloadwk_statut_request where name='NIV0')"; if ($_SESSION['OCS']['RESTRICTION']['TELEDIFF_WK'] == 'LOGIN') { $sql .= " and LOGIN_USER='******'OCS']['loggeduser'] . "' "; } elseif ($_SESSION['OCS']['RESTRICTION']['TELEDIFF_WK'] == 'USER_GROUP') { $sql .= " and GROUP_USER='******'OCS']['user_group'] . "' "; } tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $sql, $form_name, 100, $tab_options); }
} else { if (!is_readable($file_name)) { runCommand("-cache -net=" . $pas, $fname); } $tabBalises = array($l->g(34) => "IP", $l->g(95) => "MAC", $l->g(49) => "NAME", $l->g(232) => "DATE", $l->g(66) => "TYPE"); $ret = array(); $ret = parse_xml_file($file_name, $tabBalises, "HOST"); if ($ret != array()) { $sql = "select "; $i = 0; //var_dump($ret); while ($ret[$i]) { foreach ($ret[$i] as $key => $value) { $sql .= "'" . $value . "' as " . $key . ","; } $sql = substr($sql, 0, -1) . " union select "; $i++; } $sql = substr($sql, 0, -13); $default_fields = $tabBalises; $list_col_cant_del = $default_fields; $tab_options['NO_NAME']['NAME'] = 1; $result_exist = ajaxtab_entete_fixe($tabBalises, $default_fields, $tab_options, $list_col_cant_del); } echo "<p><input type='submit' name='reset' value='" . $l->g(1261) . "'></p>"; } echo close_form(); if ($ajax) { ob_end_clean(); tab_req($tabBalises, $default_fields, $list_col_cant_del, $sql, $tab_options); }
$list_fonct["image/cadena_ferme.png"] = $l->g(1019); $list_fonct["image/mass_affect.png"] = $l->g(430); if ($_SESSION['OCS']['CONFIGURATION']['CONFIG'] == "YES") { $list_fonct["image/config_search.png"] = $l->g(107); $list_pag["image/config_search.png"] = $pages_refs['ms_custom_param']; } if ($_SESSION['OCS']['CONFIGURATION']['TELEDIFF'] == "YES") { $list_fonct["image/tele_search.png"] = $l->g(428); $list_pag["image/tele_search.png"] = $pages_refs["ms_custom_pack"]; } $list_pag["image/groups_search.png"] = $pages_refs["ms_custom_groups"]; $list_pag["image/cadena_ferme.png"] = $pages_refs["ms_custom_lock"]; $list_pag["image/mass_affect.png"] = $pages_refs["ms_custom_tag"]; //activation des LOGS $tab_options['LOGS'] = 'SEARCH_RESULT'; tab_req($table_tabname, $list_fields, $default_fields, $list_col_cant_del, $queryDetails['SQL'], $form_name, '95', $tab_options); add_trait_select($list_fonct, $list_id, $form_name, $list_pag); echo "<input type='hidden' value='" . $protectedPost['Valid-search'] . "' name='Valid-search'>"; } elseif ($protectedPost['Valid-search'] != '') { $no_result = "NO RESULT"; } if ($no_result == "NO RESULT" and !isset($ERROR)) { //choix des fonctionnalit�es pour les utilisateurs $list_fonct["image/groups_search.png"] = $l->g(583); $list_pag["image/groups_search.png"] = $pages_refs["ms_custom_groups"]; add_trait_select($list_fonct, $list_id, $form_name, $list_pag); msg_warning($l->g(42)); } if ($_SESSION['OCS']["mesmachines"] != '') { $list_id_computer = computer_list_by_tag(); }
$sql_field[$protectedPost["SHOW_ME"]]['ARG'][2] .= "hardware_id"; } $sql_field[$protectedPost["SHOW_ME"]]['ARG'][2] .= " in (" . implode(',', $myids['ARG']) . ") and "; } $sql_field[$protectedPost["SHOW_ME"]]['ARG'][2] .= $recup_list_add_field[0] . " is not null group by " . implode(',', $recup_list_add_field); $tab_options['SQL_COUNT'] = "select %s from %s %s"; $tab_options['ARG_SQL_COUNT'] = array("count(distinct " . implode(',', $recup_list_add_field) . ") count_nb_ligne", $sql_field[$protectedPost["SHOW_ME"]]['ARG'][1], $sql_field[$protectedPost["SHOW_ME"]]['ARG'][2]); $list_col_cant_del = $list_fields; $default_fields = $list_fields; $tab_options['ARG_SQL'] = $sql_field[$protectedPost["SHOW_ME"]]['ARG']; if (isset($multi_search[$protectedPost["SHOW_ME"]])) { $tab_options['LIEN_LBL'][$l->g(1120)] = 'index.php?' . PAG_INDEX . '=' . $pages_refs['ms_multi_search'] . '&fields='; $tab_options['LIEN_LBL'][$l->g(1120)] .= $multi_search[$protectedPost["SHOW_ME"]]['FIELD'] . "&comp=" . $multi_search[$protectedPost["SHOW_ME"]]['COMP'] . "&values="; $tab_options['LIEN_CHAMP'][$l->g(1120)] = $array_fields[0]; } tab_req($table_name, $list_fields, $default_fields, $list_col_cant_del, $sql_field[$protectedPost["SHOW_ME"]]['SQL'], $form_name, 50, $tab_options); } echo close_form(); //show messages if ($_SESSION['OCS']['RESTRICTION']['GUI'] == "YES") { $info_msg = look_config_default_values('GUI_REPORT_MSG%', 'LIKE'); if (is_array($info_msg['ivalue'])) { $list_id_groups = implode(',', $info_msg['ivalue']); } if ($list_id_groups != "") { $sql_my_msg = "select distinct g_c.group_id groups \n\t\t\t\t\tfrom accountinfo a ,groups_cache g_c\n\t\t\t\t\twhere g_c.HARDWARE_ID=a.HARDWARE_ID\n\t\t\t\t\t\tand\tg_c.GROUP_ID in (" . $list_id_groups . ")"; if (isset($_SESSION['OCS']['mesmachines']) and $_SESSION['OCS']['mesmachines'] != "") { $sql_my_msg .= " and " . $_SESSION['OCS']['mesmachines']; } $result_my_msg = mysql_query($sql_my_msg, $_SESSION['OCS']["readServer"]); while ($item_my_msg = mysql_fetch_object($result_my_msg)) {