function prepareRun($taskjobs_id)
{
global $DB;
$pfTask = new PluginFusioninventoryTask();
$pfTaskjob = new PluginFusioninventoryTaskjob();
$pfTaskjoblog = new PluginFusioninventoryTaskjoblog();
$pfTaskjobstate = new PluginFusioninventoryTaskjobstate();
$pfIPRange = new PluginFusioninventoryIPRange();
$pfAgent = new PluginFusioninventoryAgent();
$a_specificity = array();
$a_specificity['DEVICE'] = array();
$uniqid = uniqid();
$pfTaskjob->getFromDB($taskjobs_id);
$pfTask->getFromDB($pfTaskjob->fields['plugin_fusioninventory_tasks_id']);
$NetworkEquipment = new NetworkEquipment();
$NetworkPort = new NetworkPort();
/*
* * Different possibilities :
* IP RANGE
* NetworkEquipment
* Printer
*
* We will count total number of devices to query
*/
// get all snmpauth
$a_snmpauth = getAllDatasFromTable("glpi_plugin_fusioninventory_configsecurities");
// get items_id by type
$a_iprange = array();
$a_NetworkEquipment = array();
$a_Printer = array();
$communication = $pfTask->fields['communication'];
$a_definition = importArrayFromDB($pfTaskjob->fields['definition']);
foreach ($a_definition as $datas) {
$itemtype = key($datas);
$items_id = current($datas);
switch ($itemtype) {
case 'PluginFusioninventoryIPRange':
$a_iprange[] = $items_id;
break;
case 'NetworkEquipment':
$query = "SELECT `glpi_networkequipments`.`id` AS `gID`,\n `glpi_ipaddresses`.`name` AS `gnifaddr`,\n `plugin_fusioninventory_configsecurities_id`,\n FROM `glpi_networkequipments`\n LEFT JOIN `glpi_plugin_fusioninventory_networkequipments`\n ON `networkequipments_id`=`glpi_networkequipments`.`id`\n LEFT JOIN `glpi_networkports`\n ON `glpi_networkports`.`items_id`=`glpi_networkequipments`.`id`\n AND `glpi_networkports`.`itemtype`='NetworkEquipment'\n LEFT JOIN `glpi_networknames`\n ON `glpi_networknames`.`items_id`=`glpi_networkports`.`id`\n AND `glpi_networknames`.`itemtype`='NetworkPort'\n LEFT JOIN `glpi_ipaddresses`\n ON `glpi_ipaddresses`.`items_id`=`glpi_networknames`.`id`\n AND `glpi_ipaddresses`.`itemtype`='NetworkName'\n WHERE `glpi_networkequipments`.`is_deleted`='0'\n AND `plugin_fusioninventory_configsecurities_id`!='0'\n AND `glpi_networkequipments`.`id` = '" . $items_id . "'\n AND `glpi_ipaddresses`.`name`!=''\n LIMIT 1";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
if (isset($a_snmpauth[$data['plugin_fusioninventory_configsecurities_id']])) {
$input = array();
$input['TYPE'] = 'NETWORKING';
$input['ID'] = $data['gID'];
$input['IP'] = $data['gnifaddr'];
$input['AUTHSNMP_ID'] = $data['plugin_fusioninventory_configsecurities_id'];
$a_specificity['DEVICE']['NetworkEquipment' . $data['gID']] = $input;
$a_NetworkEquipment[] = $items_id;
}
}
break;
case 'Printer':
$query = "SELECT `glpi_printers`.`id` AS `gID`,\n `glpi_ipaddresses`.`name` AS `gnifaddr`,\n `plugin_fusioninventory_configsecurities_id`,\n FROM `glpi_printers`\n LEFT JOIN `glpi_plugin_fusioninventory_printers`\n ON `printers_id`=`glpi_printers`.`id`\n LEFT JOIN `glpi_networkports`\n ON `glpi_networkports`.`items_id`=`glpi_printers`.`id`\n AND `glpi_networkports`.`itemtype`='Printer'\n LEFT JOIN `glpi_networknames`\n ON `glpi_networknames`.`items_id`=`glpi_networkports`.`id`\n AND `glpi_networknames`.`itemtype`='NetworkPort'\n LEFT JOIN `glpi_ipaddresses`\n ON `glpi_ipaddresses`.`items_id`=`glpi_networknames`.`id`\n AND `glpi_ipaddresses`.`itemtype`='NetworkName'\n WHERE `glpi_printers`.`is_deleted`=0\n AND `plugin_fusioninventory_configsecurities_id`!='0'\n AND `glpi_printers`.`id` = '" . $items_id . "'\n AND `glpi_ipaddresses`.`name`!=''\n LIMIT 1";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
if (isset($a_snmpauth[$data['plugin_fusioninventory_configsecurities_id']])) {
$input = array();
$input['TYPE'] = 'PRINTER';
$input['ID'] = $data['gID'];
$input['IP'] = $data['gnifaddr'];
$input['AUTHSNMP_ID'] = $data['plugin_fusioninventory_configsecurities_id'];
$a_specificity['DEVICE']['Printer' . $data['gID']] = $input;
$a_Printer[] = $items_id;
}
}
break;
}
}
// Get all devices on each iprange
foreach ($a_iprange as $items_id) {
$pfIPRange->getFromDB($items_id);
// Search NetworkEquipment
$query = "SELECT `glpi_networkequipments`.`id` AS `gID`,\n `glpi_ipaddresses`.`name` AS `gnifaddr`,\n `plugin_fusioninventory_configsecurities_id`,\n FROM `glpi_networkequipments`\n LEFT JOIN `glpi_plugin_fusioninventory_networkequipments`\n ON `networkequipments_id`=`glpi_networkequipments`.`id`\n LEFT JOIN `glpi_networkports`\n ON `glpi_networkports`.`items_id`=`glpi_networkequipments`.`id`\n AND `glpi_networkports`.`itemtype`='NetworkEquipment'\n LEFT JOIN `glpi_networknames`\n ON `glpi_networknames`.`items_id`=`glpi_networkports`.`id`\n AND `glpi_networknames`.`itemtype`='NetworkPort'\n LEFT JOIN `glpi_ipaddresses`\n ON `glpi_ipaddresses`.`items_id`=`glpi_networknames`.`id`\n AND `glpi_ipaddresses`.`itemtype`='NetworkName'\n WHERE `glpi_networkequipments`.`is_deleted`='0'\n AND `plugin_fusioninventory_configsecurities_id`!='0'";
if ($pfIPRange->fields['entities_id'] != '-1') {
$entities = "(" . $this->fields['entities_id'];
foreach (getAncestorsOf("glpi_entities", $pfIPRange->fields['entities_id']) as $parent) {
$entities .= ",{$parent}";
}
$entities .= ")";
$query .= " AND `glpi_networkequipments`.`entities_id` IN " . $entities . " ";
}
$query .= " AND inet_aton(`glpi_ipaddresses`.`name`)\n BETWEEN inet_aton('" . $pfIPRange->fields['ip_start'] . "')\n AND inet_aton('" . $pfIPRange->fields['ip_end'] . "') ";
$query .= " GROUP BY `glpi_networkequipments`.`id`";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
if (isset($a_snmpauth[$data['plugin_fusioninventory_configsecurities_id']])) {
$input = array();
$input['TYPE'] = 'NETWORKING';
$input['ID'] = $data['gID'];
$input['IP'] = $data['gnifaddr'];
$input['AUTHSNMP_ID'] = $data['plugin_fusioninventory_configsecurities_id'];
$a_specificity['DEVICE']['NetworkEquipment' . $data['gID']] = $input;
$a_NetworkEquipment[] = $data['gID'];
}
}
// Search Printer
$query = "SELECT `glpi_printers`.`id` AS `gID`,\n `glpi_ipaddresses`.`name` AS `gnifaddr`,\n `plugin_fusioninventory_configsecurities_id`,\n FROM `glpi_printers`\n LEFT JOIN `glpi_plugin_fusioninventory_printers`\n ON `printers_id`=`glpi_printers`.`id`\n LEFT JOIN `glpi_networkports`\n ON `glpi_networkports`.`items_id`=`glpi_printers`.`id`\n AND `glpi_networkports`.`itemtype`='Printer'\n LEFT JOIN `glpi_networknames`\n ON `glpi_networknames`.`items_id`=`glpi_networkports`.`id`\n AND `glpi_networknames`.`itemtype`='NetworkPort'\n LEFT JOIN `glpi_ipaddresses`\n ON `glpi_ipaddresses`.`items_id`=`glpi_networknames`.`id`\n AND `glpi_ipaddresses`.`itemtype`='NetworkName'\n WHERE `glpi_printers`.`is_deleted`=0\n AND `plugin_fusioninventory_configsecurities_id`!='0'";
if ($pfIPRange->fields['entities_id'] != '-1') {
$entities = "(" . $this->fields['entities_id'];
foreach (getAncestorsOf("glpi_entities", $pfIPRange->fields['entities_id']) as $parent) {
$entities .= ",{$parent}";
}
$entities .= ")";
$query .= "AND `glpi_printers`.`entities_id` IN " . $entities . " ";
}
$query .= " AND inet_aton(`glpi_ipaddresses`.`name`)\n BETWEEN inet_aton('" . $pfIPRange->fields['ip_start'] . "')\n AND inet_aton('" . $pfIPRange->fields['ip_end'] . "') ";
$query .= " GROUP BY `glpi_printers`.`id`";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
if (isset($a_snmpauth[$data['plugin_fusioninventory_configsecurities_id']])) {
$input = array();
$input['TYPE'] = 'PRINTER';
$input['ID'] = $data['gID'];
$input['IP'] = $data['gnifaddr'];
$input['AUTHSNMP_ID'] = $data['plugin_fusioninventory_configsecurities_id'];
$a_specificity['DEVICE']['Printer' . $data['gID']] = $input;
$a_Printer[] = $data['gID'];
}
}
}
$count_device = count($a_NetworkEquipment) + count($a_Printer);
$a_actions = importArrayFromDB($pfTaskjob->fields['action']);
// *** For dynamic agent same subnet, it's an another management ***
if (strstr($pfTaskjob->fields['action'], '".2"')) {
$a_subnet = array();
$a_agentList = array();
$a_devicesubnet = array();
foreach ($a_NetworkEquipment as $items_id) {
$NetworkEquipment->getFromDB($items_id);
$a_ip = explode(".", $NetworkEquipment->fields['ip']);
$ip_subnet = $a_ip[0] . "." . $a_ip[1] . "." . $a_ip[2] . ".";
if (!isset($a_subnet[$ip_subnet])) {
$a_subnet[$ip_subnet] = 0;
}
$a_subnet[$ip_subnet]++;
$a_devicesubnet[$ip_subnet]['NetworkEquipment'][$items_id] = 1;
}
foreach ($a_Printer as $items_id) {
$a_ports = $NetworkPort->find("`itemtype`='Printer'\n AND `items_id`='" . $items_id . "'\n AND `ip`!='127.0.0.1'");
foreach ($a_ports as $a_port) {
$a_ip = explode(".", $a_port['ip']);
$ip_subnet = $a_ip[0] . "." . $a_ip[1] . "." . $a_ip[2] . ".";
if (!isset($a_subnet[$ip_subnet])) {
$a_subnet[$ip_subnet] = 0;
}
$a_subnet[$ip_subnet]++;
$a_devicesubnet[$ip_subnet]['Printer'][$items_id] = 1;
}
}
$a_agentsubnet = array();
foreach ($a_subnet as $subnet => $num) {
$a_agentList = $this->getAgentsSubnet($num, $communication, $subnet);
if (!isset($a_agentList)) {
$a_agentsubnet[$subnet] = '';
} else {
$a_agentsubnet[$subnet] = $a_agentList;
}
}
$a_input = array();
$a_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$a_input['state'] = 1;
$a_input['plugin_fusioninventory_agents_id'] = 0;
$a_input['itemtype'] = '';
$a_input['items_id'] = 0;
$a_input['uniqid'] = $uniqid;
$a_input['execution_id'] = $task->fields['execution_id'];
$taskvalid = 0;
foreach ($a_agentsubnet as $subnet => $a_agentList) {
if (!isset($a_agentList) or isset($a_agentList) && is_array($a_agentList) && count($a_agentList) == '0' or isset($a_agentList) && !is_array($a_agentList) && $a_agentList == '') {
// No agent available for this subnet
for ($i = 0; $i < 2; $i++) {
$itemtype = 'Printer';
if ($i == '0') {
$itemtype = 'NetworkEquipment';
}
if (isset($a_devicesubnet[$subnet][$itemtype])) {
foreach ($a_devicesubnet[$subnet][$itemtype] as $items_id => $num) {
$a_input['itemtype'] = $itemtype;
$a_input['items_id'] = $items_id;
$a_input['specificity'] = exportArrayToDB($a_specificity['DEVICE'][$itemtype . $items_id]);
$Taskjobstates_id = $pfTaskjobstate->add($a_input);
//Add log of taskjob
$a_input['plugin_fusioninventory_taskjobstates_id'] = $Taskjobstates_id;
$a_input['state'] = 7;
$a_input['date'] = date("Y-m-d H:i:s");
$pfTaskjoblog->add($a_input);
$pfTaskjobstate->changeStatusFinish($Taskjobstates_id, 0, '', 1, "Unable to find agent to inventory " . "this " . $itemtype, 0, 0);
$a_input['state'] = 1;
}
}
}
} else {
// add taskjobstate
$count_device_subnet = 0;
if (isset($a_devicesubnet[$subnet]['NetworkEquipment'])) {
$count_device_subnet += count($a_devicesubnet[$subnet]['NetworkEquipment']);
}
if (isset($a_devicesubnet[$subnet]['Printer'])) {
$count_device_subnet += count($a_devicesubnet[$subnet]['Printer']);
}
$nb_devicebyagent = ceil($count_device_subnet / count($a_agentList));
$nbagent = 0;
$agent_id = array_pop($a_agentList);
$a_input['state'] = 0;
for ($i = 0; $i < 2; $i++) {
$itemtype = 'Printer';
if ($i == '0') {
$itemtype = 'NetworkEquipment';
}
if (isset($a_devicesubnet[$subnet][$itemtype])) {
foreach ($a_devicesubnet[$subnet][$itemtype] as $items_id => $num) {
$a_input['itemtype'] = $itemtype;
$a_input['items_id'] = $items_id;
$a_input['specificity'] = exportArrayToDB($a_specificity['DEVICE'][$itemtype . $items_id]);
if ($nbagent == $nb_devicebyagent) {
$agent_id = array_pop($a_agentList);
$nbagent = 0;
}
$a_input['plugin_fusioninventory_agents_id'] = $agent_id;
$nbagent++;
$taskvalid++;
$Taskjobstates_id = $pfTaskjobstate->add($a_input);
//Add log of taskjob
$a_input['plugin_fusioninventory_taskjobstates_id'] = $Taskjobstates_id;
$a_input['state'] = 7;
$a_input['date'] = date("Y-m-d H:i:s");
$pfTaskjoblog->add($a_input);
unset($a_input['state']);
$a_input['plugin_fusioninventory_agents_id'] = 0;
$a_input['state'] = 0;
if ($communication == "push") {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$agent_id] = 1;
}
}
}
}
}
}
if ($taskvalid == "0") {
$pfTaskjob->reinitializeTaskjobs($pfTaskjob->fields['plugin_fusioninventory_tasks_id']);
}
} else {
$a_agentList = array();
// *** Only agents not dynamic ***
if (!strstr($pfTaskjob->fields['action'], '".1"') and !strstr($pfTaskjob->fields['action'], '".2"')) {
$agent_require_model = 0;
foreach ($a_actions as $a_action) {
if (!in_array('.1', $a_action) and !in_array('.2', $a_action)) {
$agent_id = current($a_action);
if ($pfAgent->getFromDB($agent_id)) {
$agent_version = $pfAgent->getAgentVersion($agent_id);
if (strnatcmp($agent_version, '2.3.4') < 0) {
$agent_require_model = 1;
}
if ($communication == 'pull') {
$a_agentList[] = $agent_id;
} else {
if ($pfTaskjob->isAgentAlive('1', $agent_id)) {
$a_agentList[] = $agent_id;
}
}
}
}
}
} else {
if (strstr($pfTaskjob->fields['action'], '".1"')) {
$a_agentList = $this->getAgentsSubnet($count_device, $communication);
}
}
/*
* Manage agents
*/
if (count($a_agentList) == 0) {
$a_input = array();
$a_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$a_input['state'] = 1;
$a_input['plugin_fusioninventory_agents_id'] = 0;
$a_input['itemtype'] = '';
$a_input['items_id'] = 0;
$a_input['uniqid'] = $uniqid;
$a_input['execution_id'] = $task->fields['execution_id'];
$Taskjobstates_id = $pfTaskjobstate->add($a_input);
//Add log of taskjob
$a_input['plugin_fusioninventory_taskjobstates_id'] = $Taskjobstates_id;
$a_input['state'] = 7;
$a_input['date'] = date("Y-m-d H:i:s");
$pfTaskjoblog->add($a_input);
$pfTaskjobstate->changeStatusFinish($Taskjobstates_id, 0, '', 1, "Unable to find agent to run this job");
$input_taskjob = array();
$input_taskjob['id'] = $pfTaskjob->fields['id'];
//$input_taskjob['status'] = 0;
$pfTaskjob->update($input_taskjob);
} elseif ($count_device == 0) {
$a_input = array();
$a_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$a_input['state'] = 1;
$a_input['plugin_fusioninventory_agents_id'] = 0;
$a_input['itemtype'] = '';
$a_input['items_id'] = 0;
$a_input['uniqid'] = $uniqid;
$Taskjobstates_id = $pfTaskjobstate->add($a_input);
//Add log of taskjob
$a_input['plugin_fusioninventory_taskjobstates_id'] = $Taskjobstates_id;
$a_input['state'] = 7;
$a_input['date'] = date("Y-m-d H:i:s");
$pfTaskjoblog->add($a_input);
$pfTaskjobstate->changeStatusFinish($Taskjobstates_id, 0, '', 0, "No suitable devices to inventory");
$input_taskjob = array();
$input_taskjob['id'] = $pfTaskjob->fields['id'];
//$input_taskjob['status'] = 1;
$pfTaskjob->update($input_taskjob);
} else {
foreach ($a_agentList as $agent_id) {
//Add jobstate and put status (waiting on server = 0)
$a_input = array();
$a_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$a_input['state'] = 0;
$a_input['plugin_fusioninventory_agents_id'] = $agent_id;
$a_input['uniqid'] = $uniqid;
$a_input['execution_id'] = $task->fields['execution_id'];
$alternate = 0;
for ($d = 0; $d < ceil($count_device / count($a_agentList)); $d++) {
if (count($a_NetworkEquipment) + count($a_Printer) > 0) {
$getdevice = "NetworkEquipment";
if ($alternate == "1") {
$getdevice = "Printer";
$alternate = 0;
} else {
$getdevice = "NetworkEquipment";
$alternate++;
}
if (count($a_NetworkEquipment) == '0') {
$getdevice = "Printer";
} else {
if (count($a_Printer) == '0') {
$getdevice = "NetworkEquipment";
}
}
$a_input['itemtype'] = $getdevice;
switch ($getdevice) {
case 'NetworkEquipment':
$a_input['items_id'] = array_pop($a_NetworkEquipment);
$a_input['specificity'] = exportArrayToDB($a_specificity['DEVICE']['NetworkEquipment' . $a_input['items_id']]);
break;
case 'Printer':
$a_input['items_id'] = array_pop($a_Printer);
$a_input['specificity'] = exportArrayToDB($a_specificity['DEVICE']['Printer' . $a_input['items_id']]);
break;
}
$Taskjobstates_id = $pfTaskjobstate->add($a_input);
//Add log of taskjob
$a_input['plugin_fusioninventory_taskjobstates_id'] = $Taskjobstates_id;
$a_input['state'] = 7;
$a_input['date'] = date("Y-m-d H:i:s");
$pfTaskjoblog->add($a_input);
unset($a_input['state']);
if ($communication == "push") {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$agent_id] = 1;
}
}
}
}
$input_taskjob = array();
$input_taskjob['id'] = $pfTaskjob->fields['id'];
$input_taskjob['status'] = 1;
$pfTaskjob->update($input_taskjob);
}
}
return $uniqid;
}
