$tab_options['table_name'] = $table_tabname;
ajaxtab_entete_fixe($list_fields, $default_fields, $tab_options, $list_col_cant_del);
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();
}
//pour tous les tableaux:
//TABLE-NOMCHAMP =>lbl du champ
//option: TABLE-NOMCHAMP-LBL => commentaire à ajouter après le champ de saisi
//composotion du tableau
// option: TABLE-NOMCHAMP-SELECT =>array des valeurs du champ select ou requete sql (affichage du select)
// si option absente le select affiche array('exact'=> 'EXACTEMENT','ressemble'=>'RESSEMBLE','diff'=>'DIFFERENT')
//a l'affichage on se retrouve avec le lbl du champ,un select et un champ de saisi
$sort_list = array("NETWORKS-IPADDRESS" => $l->g(82) . ": " . $l->g(34), "NETWORKS-MACADDR" => $l->g(82) . ": " . $l->g(95), "SOFTWARES-NAME" => $l->g(20) . ": " . $l->g(49), "SOFTWARES-VERSION" => $l->g(20) . ": " . $l->g(277), "SOFTWARES-BITSWIDTH" => $l->g(20) . ": " . $l->g(1247), "SOFTWARES-PUBLISHER" => $l->g(20) . ": " . $l->g(69), "SOFTWARES-COMMENTS" => $l->g(20) . ": " . $l->g(51), "HARDWARE-DESCRIPTION" => $l->g(25) . ": " . $l->g(53), "HARDWARE-USERDOMAIN" => $l->g(82) . ": " . $l->g(557), "BIOS-BVERSION" => $l->g(273) . ": " . $l->g(209), "HARDWARE-USERID" => $l->g(243) . ": " . $l->g(49), "HARDWARE-OSCOMMENTS" => $l->g(25) . ": " . $l->g(51), "HARDWARE-OSVERSION" => $l->g(25) . ": " . $l->g(277), "NETWORKS-IPGATEWAY" => $l->g(82) . ": " . $l->g(207), "NETWORKS-IPSUBNET" => $l->g(82) . ": " . $l->g(331), "NETWORKS-IPDHCP" => $l->g(82) . ": " . $l->g(281), "BIOS-SSN" => $l->g(273) . ": " . $l->g(36), "BIOS-SMODEL" => $l->g(273) . ": " . $l->g(65), "HARDWARE-NAME" => $l->g(729) . ": " . $l->g(49), "HARDWARE-PROCESSORT" => $l->g(54) . " (old): " . $l->g(66), "BIOS-SMANUFACTURER" => $l->g(729) . ": " . $l->g(64), "MONITORS-SERIAL" => $l->g(554), "MONITORS-DESCRIPTION" => $l->g(556), "MONITORS-MANUFACTURER" => $l->g(555), "DRIVES-VOLUMN" => $l->g(92) . ": " . $l->g(964), "BIOS-BMANUFACTURER" => $l->g(273) . ": " . $l->g(284), "BIOS-BVERSION" => $l->g(273) . ": " . $l->g(277), "BIOS-ASSETTAG" => $l->g(273) . ": " . $l->g(216), "HARDWARE-LASTDATE" => "OCS: " . $l->g(46), "HARDWARE-LASTCOME" => "OCS: " . $l->g(820), "HARDWARE-WORKGROUP" => $l->g(82) . ": " . $l->g(33), "STORAGES-NAME" => $l->g(63) . ": " . $l->g(49), "STORAGES-SERIALNUMBER" => $l->g(63) . ": " . $l->g(36), "STORAGES-DISKSIZE" => $l->g(63) . ": " . $l->g(67), "PRINTERS-NAME" => $l->g(79) . ": " . $l->g(49), "PRINTERS-DRIVER" => $l->g(79) . ": " . $l->g(278), "PRINTERS-PORT" => $l->g(79) . ": " . $l->g(279), "PRINTERS-DESCRIPTION" => $l->g(79) . ": " . $l->g(53), "PRINTERS-SERVERNAME" => $l->g(79) . ": " . $l->g(1323), "PRINTERS-SHARENAME" => $l->g(79) . ": " . $l->g(1324), "PRINTERS-RESOLUTION" => $l->g(79) . ": " . $l->g(1325), "PRINTERS-COMMENT" => $l->g(79) . ": " . $l->g(51), "HARDWARE-ARCH" => $l->g(25) . ": " . $l->g(1247), "CPUS-MANUFACTURER" => $l->g(54) . ": " . $l->g(64), "CPUS-TYPE" => $l->g(54) . ": " . $l->g(66), "CPUS-SERIALNUMBER" => $l->g(54) . ": " . $l->g(36), "CPUS-SPEED" => $l->g(54) . ": " . $l->g(429), "CPUS-CORES" => $l->g(54) . ": " . $l->g(1317), "CPUS-L2CACHESIZE" => $l->g(54) . ": " . $l->g(1318), "CPUS-LOGICAL_CPUS" => $l->g(54) . ": " . $l->g(1314), "CPUS-VOLTAGE" => $l->g(54) . ": " . $l->g(1319), "CPUS-CURRENT_SPEED" => $l->g(54) . ": " . $l->g(1315), "CPUS-SOCKET" => $l->g(54) . ": " . $l->g(1316));
$optSelectField = array("NETWORKS-IPADDRESS" => $sort_list["NETWORKS-IPADDRESS"], "NETWORKS-MACADDR" => $sort_list["NETWORKS-MACADDR"], "SOFTWARES-NAME" => $sort_list["SOFTWARES-NAME"], "SOFTWARES-VERSION" => $sort_list["SOFTWARES-VERSION"], "SOFTWARES-BITSWIDTH" => $sort_list["SOFTWARES-BITSWIDTH"], "SOFTWARES-PUBLISHER" => $sort_list["SOFTWARES-PUBLISHER"], "SOFTWARES-COMMENTS" => $sort_list["SOFTWARES-COMMENTS"], "HARDWARE-DESCRIPTION" => $sort_list["HARDWARE-DESCRIPTION"], "HARDWARE-USERDOMAIN" => $sort_list["HARDWARE-USERDOMAIN"], "BIOS-BVERSION" => $sort_list["BIOS-BVERSION"], "HARDWARE-USERID" => $sort_list["HARDWARE-USERID"], "HARDWARE-OSCOMMENTS" => $sort_list["HARDWARE-OSCOMMENTS"], "HARDWARE-OSVERSION" => $sort_list["HARDWARE-OSVERSION"], "NETWORKS-IPGATEWAY" => $sort_list["NETWORKS-IPGATEWAY"], "NETWORKS-IPSUBNET" => $sort_list["NETWORKS-IPSUBNET"], "NETWORKS-IPDHCP" => $sort_list["NETWORKS-IPDHCP"], "BIOS-SSN" => $sort_list["BIOS-SSN"], "BIOS-SMODEL" => $sort_list["BIOS-SMODEL"], "HARDWARE-NAME" => $sort_list["HARDWARE-NAME"], "HARDWARE-PROCESSORT" => $sort_list["HARDWARE-PROCESSORT"], "BIOS-SMANUFACTURER" => $sort_list["BIOS-SMANUFACTURER"], "MONITORS-SERIAL" => $sort_list["MONITORS-SERIAL"], "MONITORS-DESCRIPTION" => $sort_list["MONITORS-DESCRIPTION"], "MONITORS-MANUFACTURER" => $sort_list["MONITORS-MANUFACTURER"], "DRIVES-VOLUMN" => $sort_list["DRIVES-VOLUMN"], "BIOS-BMANUFACTURER" => $sort_list["BIOS-BMANUFACTURER"], "BIOS-BVERSION" => $sort_list["BIOS-BVERSION"], "BIOS-ASSETTAG" => $sort_list["BIOS-ASSETTAG"], "PRINTERS-NAME" => $sort_list["PRINTERS-NAME"], "PRINTERS-DRIVER" => $sort_list["PRINTERS-DRIVER"], "PRINTERS-PORT" => $sort_list["PRINTERS-PORT"], "PRINTERS-DESCRIPTION" => $sort_list['PRINTERS-DESCRIPTION'], "PRINTERS-SERVERNAME" => $sort_list["PRINTERS-SERVERNAME"], "PRINTERS-SHARENAME" => $sort_list["PRINTERS-SHARENAME"], "PRINTERS-RESOLUTION" => $sort_list["PRINTERS-RESOLUTION"], "PRINTERS-COMMENT" => $sort_list["PRINTERS-COMMENT"], "HARDWARE-ARCH" => $l->g(25) . ": " . $l->g(1247), "HARDWARE-LASTDATE" => $sort_list["HARDWARE-LASTDATE"], "HARDWARE-LASTDATE-LBL" => "calendar", "HARDWARE-LASTDATE-SELECT" => array("small" => $l->g(346), "tall" => $l->g(347)), "HARDWARE-LASTCOME" => $sort_list["HARDWARE-LASTCOME"], "HARDWARE-LASTCOME-LBL" => "calendar", "HARDWARE-LASTCOME-SELECT" => array("small" => $l->g(346), "tall" => $l->g(347)), "HARDWARE-WORKGROUP" => $sort_list["HARDWARE-WORKGROUP"], "STORAGES-NAME" => $sort_list["STORAGES-NAME"], "STORAGES-SERIALNUMBER" => $sort_list["STORAGES-SERIALNUMBER"], "STORAGES-DISKSIZE" => $sort_list["STORAGES-DISKSIZE"], "STORAGES-DISKSIZE-SELECT" => array("exact" => $l->g(410), "small" => $l->g(201), "tall" => $l->g(202)), "STORAGES-DISKSIZE-LBL" => "MB", "HARDWARE-ARCH" => $sort_list["HARDWARE-ARCH"], "CPUS-MANUFACTURER" => $sort_list["CPUS-MANUFACTURER"], "CPUS-SERIALNUMBER" => $sort_list["CPUS-SERIALNUMBER"], "CPUS-SOCKET" => $sort_list["CPUS-SOCKET"], "CPUS-TYPE" => $sort_list["CPUS-TYPE"], "CPUS-SPEED" => $sort_list["CPUS-SPEED"], "CPUS-SPEED-SELECT" => array("exact" => $l->g(410), "small" => $l->g(201), "tall" => $l->g(202)), "CPUS-SPEED-LBL" => "MHz", "CPUS-CORES" => $sort_list["CPUS-CORES"], "CPUS-CORES-SELECT" => array("exact" => $l->g(410), "small" => $l->g(201), "tall" => $l->g(202)), "CPUS-L2CACHESIZE" => $sort_list["CPUS-L2CACHESIZE"], "CPUS-L2CACHESIZE-SELECT" => array("exact" => $l->g(410), "small" => $l->g(201), "tall" => $l->g(202)), "CPUS-LOGICAL_CPUS" => $sort_list["CPUS-LOGICAL_CPUS"], "CPUS-LOGICAL_CPUS-SELECT" => array("exact" => $l->g(410), "small" => $l->g(201), "tall" => $l->g(202)), "CPUS-CURRENT_SPEED" => $sort_list["CPUS-CURRENT_SPEED"], "CPUS-CURRENT_SPEED-SELECT" => array("exact" => $l->g(410), "small" => $l->g(201), "tall" => $l->g(202)), "CPUS-CURRENT_SPEED-LBL" => "MHz", "CPUS-VOLTAGE" => $sort_list["CPUS-VOLTAGE"], "CPUS-VOLTAGE-SELECT" => array("exact" => $l->g(410), "small" => $l->g(201), "tall" => $l->g(202)));
//ajout des champs de accountinfo
$optSelectField = array_merge($optSelectField_account, $optSelectField);
//composotion du tableau
// TABLE-NOMCHAMP-SQL1 => requete avec les champs ID (option) et NAME. Peut également être un tableau de données
//à l'affichage on se retrouve avec le lbl du champ et un select
$ajax = false;
}
require_once 'require/function_telediff.php';
require_once 'require/function_computers.php';
$form_name = 'packlist';
//show or not stats on the table
$show_stats = true;
echo open_form($form_name);
PrintEnTete($l->g(465));
if ($_SESSION['OCS']['profile']->getRestriction('TELEDIFF_ACTIVATE') == 'NO') {
$cant_active = false;
} else {
$cant_active = true;
}
if ($_SESSION['OCS']['profile']->getRestriction('GUI') == 'YES') {
$restrict_computers = computer_list_by_tag('', 'ARRAY');
if ($restrict_computers == "ERROR") {
msg_error($l->g(893));
require_once FOOTER_HTML;
die;
}
}
$tab_options = $protectedPost;
//only for profils who can activate packet
if (!$cant_active) {
if ($protectedPost["SUP_PROF"] != "") {
del_pack($protectedPost["SUP_PROF"]);
$tab_options['CACHE'] = 'RESET';
}
//delete more than one packet
if ($protectedPost['del_check'] != '') {
$result = creat_group($protectedPost['NAME'], $protectedPost['DESCR'], '', '', 'STATIC');
if ($result['RESULT'] == "ERROR") {
msg_error($result['LBL']);
} elseif ($result['RESULT'] == "OK") {
msg_success($result['LBL']);
unset($protectedPost['add_static_group']);
}
$tab_options['CACHE'] = 'RESET';
}
//reset add static group
if ($protectedPost['Reset_modif_x'] or $protectedPost['onglet'] != $protectedPost['old_onglet']) {
unset($protectedPost['add_static_group']);
}
//view only your computers
if ($_SESSION['OCS']['RESTRICTION']['GUI'] == 'YES') {
$mycomputers = computer_list_by_tag();
if ($mycomputers == "ERROR") {
msg_error($l->g(893));
require_once FOOTER_HTML;
die;
}
}
//View for all profils?
if (isset($protectedPost['CONFIRM_CHECK']) and $protectedPost['CONFIRM_CHECK'] != "") {
$result = group_4_all($protectedPost['CONFIRM_CHECK']);
}
//if delete group
if ($protectedPost['SUP_PROF'] != "") {
$result = delete_group($protectedPost['SUP_PROF']);
if ($result['RESULT'] == "ERROR") {
msg_error($result['LBL']);
} else {
$afus = array();
$i = 0;
while (isset($list_id_fusion[$i])) {
$res = mysqli_query($_SESSION['OCS']["readServer"], "SELECT deviceid,id,lastcome FROM hardware WHERE id=" . $list_id_fusion[$i]) or die(mysqli_error($_SESSION['OCS']["readServer"]));
$afus[] = mysqli_fetch_array($res, MYSQL_ASSOC);
$i++;
}
if (isset($afus)) {
fusionne($afus);
}
}
}
//restriction for profils?
if ($_SESSION['OCS']['mesmachines']) {
$tab_id_mes_machines = computer_list_by_tag('', 'ARRAY');
if ($tab_id_mes_machines == "ERROR") {
echo $l->g(923);
break;
}
} else {
$tab_id_mes_machines = "";
}
printEnTete($l->g(199));
/************************ hostname double ***************************************/
$sql_doublon['hostname'] = "select NAME val from hardware ";
$arg_doublon['hostname'] = array();
if (isset($tab_id_mes_machines) and $tab_id_mes_machines != "") {
$sql = mysql2_prepare($sql_doublon['hostname'] . ' where id in ', $arg_doublon['hostname'], $tab_id_mes_machines);
$sql_doublon['hostname'] = $sql['SQL'];
$arg_doublon['hostname'] = $sql['ARG'];
