1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
<?php
/*
* Copyright 2005-2016 OCSInventory-NG/OCSInventory-ocsreports contributors.
* See the Contributors file for more details about them.
*
* This file is part of OCSInventory-NG/OCSInventory-ocsreports.
*
* OCSInventory-NG/OCSInventory-ocsreports is free software: you can redistribute
* it and/or modify it under the terms of the GNU General Public License as
* published by the Free Software Foundation, either version 2 of the License,
* or (at your option) any later version.
*
* OCSInventory-NG/OCSInventory-ocsreports is distributed in the hope that it
* will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty
* of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with OCSInventory-NG/OCSInventory-ocsreports. if not, write to the
* Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
* MA 02110-1301, USA.
*/
if (AJAX) {
parse_str($protectedPost['ocs']['0'], $params);
$protectedPost += $params;
ob_start();
}
unset($list_fields);
print_item_header($l->g(20));
$form_name = "affich_soft";
$table_name = $form_name;
$tab_options = $protectedPost;
$tab_options['form_name'] = $form_name;
$tab_options['table_name'] = $table_name;
echo open_form($form_name, '', '', 'form-horizontal');
$list_fields[$l->g(69)] = 'PUBLISHER';
if (isset($_SESSION['OCS']['USE_NEW_SOFT_TABLES'])
and $_SESSION['OCS']['USE_NEW_SOFT_TABLES'] == 1) {
$queryDetails = "SELECT s.PUBLISHER,
s_name.NAME as NAME,
s_version.NAME as VERSION,
s.COMMENTS,s.FOLDER,s.FILENAME,s.FILESIZE,s.GUID,
s.LANGUAGE,s.INSTALLDATE,s.BITSWIDTH, c.CATEGORY_NAME as CATEGORY
FROM softwares s
left join type_softwares_name s_name on s_name.id= s.name_id
left join type_softwares_version s_version on s_version.id=s.version_id
left join software_categories c on c.id = s.category
WHERE (hardware_id=$systemid)";
$list_fields[$l->g(49)] = 's_name.NAME';
} else {
$queryDetails = "SELECT *, c.CATEGORY_NAME as CATEGORY FROM softwares s
left join software_categories c on c.id=s.category
WHERE (hardware_id=$systemid)";
$list_fields[$l->g(49)] = 'NAME';
}
$list_fields[$l->g(277)] = 'VERSION';
$list_fields[$l->g(51)] = 'COMMENTS';
if ($show_all_column) {
$list_col_cant_del = $list_fields;
} else {
$list_col_cant_del = array($l->g(49) => $l->g(49));
}
$default_fields = $list_fields;
$list_fields[$l->g(1248)] = 'FOLDER';
$list_fields[$l->g(446)] = 'FILENAME';
$list_fields[ucfirst(strtolower($l->g(953)))] = 'FILESIZE';
$list_fields['GUID'] = 'GUID';
$list_fields[ucfirst(strtolower($l->g(1012)))] = 'LANGUAGE';
$list_fields[$l->g(1238)] = 'INSTALLDATE';
$list_fields[$l->g(1247)] = 'BITSWIDTH';
$list_fields[$l->g(388)] = 'CATEGORY';
$tab_options['FILTRE'] = array_flip($list_fields);
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();
}
?>
|
