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)) {
