246 lines
7.6 KiB
PHP
246 lines
7.6 KiB
PHP
<?php
|
|
|
|
include ('../inc/includes.php');
|
|
include ('../inc/utils.class.php');
|
|
|
|
|
|
function getOrdinaturs($unity){
|
|
|
|
global $DB;
|
|
|
|
$query = "SELECT c.name,c.serial FROM `glpi_computers` c
|
|
JOIN glpi_locations l ON c.locations_id = l.id
|
|
WHERE c.serial != '' and c.locations_id in
|
|
(SELECT id FROM `glpi_locations` WHERE completename like '%".$unity."%')";
|
|
|
|
if($unity == 'ALL')
|
|
$query = "SELECT name,serial FROM `glpi_computers`
|
|
WHERE serial != ''";
|
|
|
|
$result = $DB->query($query);
|
|
|
|
|
|
if ($result->num_rows > 0) {
|
|
$rows = array();
|
|
while($row = $result->fetch_assoc()) {
|
|
$rows[] = $row;
|
|
}
|
|
return $rows;
|
|
}
|
|
|
|
return null;
|
|
}
|
|
|
|
function get_inventory_Phone($phone_id){
|
|
|
|
global $DB;
|
|
$res = array();
|
|
$sql =" SELECT DISTINCT `glpi_phones`.id AS Phone_id,glpi_phonemodels.name AS modele , glpi_phonetypes.name AS types ,glpi_phonepowersupplies.name AS alimentation,
|
|
glpi_phones.`number_line`,glpi_phones.users_id ,glpi_users.name AS user_name,glpi_phones.comment,glpi_phones.brand AS marque,
|
|
glpi_phones.serial AS num_serie
|
|
FROM `glpi_phones`
|
|
LEFT JOIN `glpi_phonemodels` ON (glpi_phones.phonemodels_id = glpi_phonemodels.id )
|
|
LEFT JOIN `glpi_phonetypes` ON (glpi_phones.phonetypes_id = glpi_phonetypes.id )
|
|
LEFT JOIN glpi_users ON (glpi_phones.users_id = glpi_users.id )
|
|
LEFT JOIN `glpi_phonepowersupplies` ON (glpi_phones.phonepowersupplies_id = glpi_phonepowersupplies.id )
|
|
WHERE glpi_phones.is_deleted = 0 AND glpi_phones.is_template = 0 ";
|
|
if ($phone_id == 'ALL'){
|
|
$stmt = $DB->prepare($sql);
|
|
}else{
|
|
$sql = $sql."and glpi_phones.id = ?";
|
|
$stmt = $DB->prepare($sql);
|
|
$stmt->bind_param("i",$phone_id);
|
|
}
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
|
|
|
|
|
|
if ($result->num_rows > 0) {
|
|
|
|
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
|
|
$res[] = $row;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
function get_inventory_Monitor($monitor_id){
|
|
|
|
global $DB;
|
|
$res = array();
|
|
$sql =" SELECT glpi_monitors.id AS Monitor_id, glpi_manufacturers.name AS fabricant, glpi_monitors.serial AS serial ,
|
|
`glpi_monitormodels`.`name` AS modele FROM `glpi_monitors`
|
|
JOIN `glpi_manufacturers` ON `glpi_monitors`.`manufacturers_id` = `glpi_manufacturers`.`id`
|
|
LEFT JOIN `glpi_monitormodels` ON `glpi_monitors`.`monitormodels_id` = `glpi_monitormodels`.`id`
|
|
WHERE is_deleted = 0 AND is_template = 0 ";
|
|
if ($monitor_id == 'ALL'){
|
|
$stmt = $DB->prepare($sql);
|
|
}else{
|
|
$sql = $sql."and glpi_monitors.id = ?";
|
|
$stmt = $DB->prepare($sql);
|
|
$stmt->bind_param("i",$monitor_id);
|
|
}
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
|
|
|
|
|
|
if ($result->num_rows > 0) {
|
|
|
|
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
|
|
$res[] = $row;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
function get_inventory_NetworkEqui($monitor_id){
|
|
|
|
global $DB;
|
|
$res = array();
|
|
$sql =" SELECT glpi_networkequipments.id AS NwEquip_id, glpi_manufacturers.name AS fabricant, glpi_networkequipments.serial AS serial ,
|
|
`glpi_networkequipmentmodels`.name AS modele FROM `glpi_networkequipments`
|
|
JOIN `glpi_manufacturers` ON `glpi_networkequipments`.`manufacturers_id` = `glpi_manufacturers`.`id`
|
|
LEFT JOIN `glpi_networkequipmentmodels` ON `glpi_networkequipments`.`networkequipmentmodels_id` = `glpi_networkequipmentmodels`.`id`
|
|
WHERE is_deleted = 0 AND is_template = 0 ";
|
|
if ($monitor_id == 'ALL'){
|
|
$stmt = $DB->prepare($sql);
|
|
}else{
|
|
$sql = $sql."and glpi_networkequipments.id = ?";
|
|
$stmt = $DB->prepare($sql);
|
|
$stmt->bind_param("i",$monitor_id);
|
|
}
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
|
|
|
|
|
|
if ($result->num_rows > 0) {
|
|
|
|
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
|
|
$res[] = $row;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
function get_inventory_Printer($monitor_id){
|
|
|
|
global $DB;
|
|
$res = array();
|
|
$sql =" SELECT glpi_printers.id AS Printer_id, glpi_manufacturers.name AS fabricant, glpi_printers.serial AS serial ,
|
|
`glpi_printermodels`.name AS modele FROM `glpi_printers`
|
|
JOIN `glpi_manufacturers` ON `glpi_printers`.`manufacturers_id` = `glpi_manufacturers`.`id`
|
|
LEFT JOIN `glpi_printermodels` ON `glpi_printers`.`printermodels_id` = `glpi_printermodels`.`id`
|
|
WHERE is_deleted = 0 AND is_template = 0 ";
|
|
if ($monitor_id == 'ALL'){
|
|
$stmt = $DB->prepare($sql);
|
|
}else{
|
|
$sql = $sql."and glpi_printers.id = ?";
|
|
$stmt = $DB->prepare($sql);
|
|
$stmt->bind_param("i",$monitor_id);
|
|
}
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
|
|
|
|
|
|
if ($result->num_rows > 0) {
|
|
|
|
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
|
|
$res[] = $row;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
function get_inventory_Rack($monitor_id){
|
|
|
|
global $DB;
|
|
$res = array();
|
|
$sql =" SELECT glpi_racks.id AS Rack_id,glpi_racks.name AS Rack_name, glpi_manufacturers.name AS fabricant, glpi_racks.serial AS serial ,
|
|
`glpi_rackmodels`.name AS modele FROM `glpi_racks`
|
|
LEFT JOIN `glpi_manufacturers` ON `glpi_racks`.`manufacturers_id` = `glpi_manufacturers`.`id`
|
|
LEFT JOIN `glpi_rackmodels` ON `glpi_racks`.`rackmodels_id` = `glpi_rackmodels`.`id`
|
|
WHERE is_deleted = 0 AND is_template = 0 ";
|
|
if ($monitor_id == 'ALL'){
|
|
$stmt = $DB->prepare($sql);
|
|
}else{
|
|
$sql = $sql."and glpi_racks.id = ?";
|
|
$stmt = $DB->prepare($sql);
|
|
$stmt->bind_param("i",$monitor_id);
|
|
}
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
|
|
|
|
|
|
if ($result->num_rows > 0) {
|
|
|
|
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
|
|
$res[] = $row;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
function get_inventory_Ordinateur($computer_id){
|
|
|
|
global $DB;
|
|
$res = array();
|
|
$sql = "SELECT DISTINCT
|
|
glpi_computers.id AS Computer_id, glpi_manufacturers.name AS fabricant, glpi_computers.serial AS serial,
|
|
glpi_computertypes.name AS types, glpi_computermodels.name AS modele, glpi_users.id AS user_id,
|
|
glpi_users.name AS user_name, glpi_computers.uuid , glpi_computers.comment AS comment , glpi_computers.serial as num_serie
|
|
FROM glpi_computers
|
|
LEFT JOIN glpi_states ON (glpi_computers.states_id = glpi_states.id )
|
|
LEFT JOIN glpi_manufacturers ON (glpi_computers.manufacturers_id = glpi_manufacturers.id )
|
|
LEFT JOIN glpi_computertypes ON (glpi_computers.computertypes_id = glpi_computertypes.id )
|
|
LEFT JOIN glpi_computermodels ON (glpi_computers.computermodels_id = glpi_computermodels.id )
|
|
LEFT JOIN glpi_items_operatingsystems ON (glpi_computers.id = glpi_items_operatingsystems.items_id AND glpi_items_operatingsystems.itemtype = 'Computer' )
|
|
LEFT JOIN glpi_operatingsystems AS glpi_operatingsystems_8 ON (glpi_items_operatingsystems.operatingsystems_id = glpi_operatingsystems_8.id )
|
|
LEFT JOIN glpi_locations ON (glpi_computers.locations_id = glpi_locations.id )
|
|
LEFT JOIN glpi_users ON (glpi_computers.users_id = glpi_users.id )
|
|
LEFT JOIN glpi_items_deviceprocessors ON (glpi_computers.id = glpi_items_deviceprocessors.items_id AND glpi_items_deviceprocessors.itemtype = 'Computer' )
|
|
LEFT JOIN glpi_deviceprocessors AS glpi_deviceprocessors_7 ON (glpi_items_deviceprocessors.deviceprocessors_id = glpi_deviceprocessors_7.id )
|
|
WHERE glpi_computers.is_deleted = 0 AND glpi_computers.is_template = 0 ";
|
|
if ($computer_id == 'ALL'){
|
|
$sql = $sql."GROUP BY glpi_computers.id";
|
|
$stmt = $DB->prepare($sql);
|
|
}else{
|
|
$sql = $sql."and glpi_computers.id = ?
|
|
GROUP BY glpi_computers.id";
|
|
$stmt = $DB->prepare($sql);
|
|
$stmt->bind_param("i",$computer_id);
|
|
}
|
|
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
|
|
if ($result->num_rows > 0) {
|
|
|
|
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
|
|
$res[] = $row;
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
return $res;
|
|
} |