/**
* @test
*/
public function prepareDB()
{
global $DB;
$DB->connect();
$pfDeployPackage = new PluginFusioninventoryDeployPackage();
$pfDeployGroup = new PluginFusioninventoryDeployGroup();
$pfTask = new PluginFusioninventoryTask();
$pfTaskjob = new PluginFusioninventoryTaskjob();
$pfTaskjobState = new PluginFusioninventoryTaskjobstate();
$pfTaskjoblog = new PluginFusioninventoryTaskjoblog();
$pfDeployGroup_Dynamicdata = new PluginFusioninventoryDeployGroup_Dynamicdata();
// Create package
$input = array('entities_id' => 0, 'name' => 'package');
$packages_id = $pfDeployPackage->add($input);
// Create fusioninventory dynamic group
$input = array('name' => 'all computers have name computer', 'type' => 'DYNAMIC');
$groups_id = $pfDeployGroup->add($input);
$input = array('plugin_fusioninventory_deploygroups_id' => $groups_id, 'fields_array' => 'a:2:{s:8:"criteria";a:1:{i:0;a:3:{s:5:"field";s:1:"1";s:10:"searchtype";s:8:"contains";s:5:"value";s:8:"computer";}}s:12:"metacriteria";s:0:"";}');
$pfDeployGroup_Dynamicdata->add($input);
// create task
$input = array('entities_id' => 0, 'name' => 'deploy', 'is_active' => 1);
self::$tasks_id = $pfTask->add($input);
// create taskjob
$input = array('plugin_fusioninventory_tasks_id' => self::$tasks_id, 'entities_id' => 0, 'name' => 'deploy', 'method' => 'deployinstall', 'targets' => '[{"PluginFusioninventoryDeployPackage":"' . $packages_id . '"}]', 'actors' => '[{"PluginFusioninventoryDeployGroup":"' . self::$tasks_id . '"}]');
self::$taskjobs_id = $pfTaskjob->add($input);
//create taskjobstate
$input = array('plugin_fusioninventory_taskjobs_id' => self::$taskjobs_id, 'items_id' => 0, 'itemtype' => 'Computer', 'state' => PluginFusioninventoryTaskjobstate::FINISHED, 'plugin_fusioninventory_agents_id' => 0, 'specificity' => 0, 'uniqid' => 0);
self::$taskjobstates_id = $pfTaskjobState->add($input);
//crfeate taskjoblogR
$input = array('plugin_fusioninventory_taskjobstates_id' => self::$taskjobstates_id, 'date ' => date('Y-m-d H:i:s'), 'items_id' => 0, 'itemtype' => 'Computer', 'state' => PluginFusioninventoryTaskjoblog::TASK_RUNNING, 'comment' => "1 ==devicesfound==");
self::$taskjoblogs_id = $pfTaskjoblog->add($input);
}
function prepareRun($taskjobs_id)
{
$pfTask = new PluginFusioninventoryTask();
$pfTaskjob = new PluginFusioninventoryTaskjob();
$pfTaskjoblog = new PluginFusioninventoryTaskjoblog();
$pfTaskjobstate = new PluginFusioninventoryTaskjobstate();
$pfAgentmodule = new PluginFusioninventoryAgentmodule();
$pfIPRange = new PluginFusioninventoryIPRange();
$pfAgent = new PluginFusioninventoryAgent();
$uniqid = uniqid();
$pfTaskjob->getFromDB($taskjobs_id);
$pfTask->getFromDB($pfTaskjob->fields['plugin_fusioninventory_tasks_id']);
$communication = $pfTask->fields['communication'];
//list all iprange
$a_iprange = importArrayFromDB($pfTaskjob->fields['definition']);
$count_ip = 0;
$a_iprangelist = array();
$a_subnet_nbip = array();
foreach ($a_iprange as $iprange) {
$iprange_id = current($iprange);
$a_iprangelist[] = $iprange_id;
$pfIPRange->getFromDB($iprange_id);
$s = $pfIPRange->getIp2long($pfIPRange->fields['ip_start']);
$e = $pfIPRange->getIp2long($pfIPRange->fields['ip_end']);
$a_subnet_nbip[$iprange_id] = $e - $s;
$count_ip += $e - $s;
}
//list all agents
$a_agent = importArrayFromDB($pfTaskjob->fields['action']);
$dynagent = 0;
$a_agentlist = array();
foreach ($a_agent as $agent) {
$agent_id = current($agent);
if ($agent_id == '.1') {
$dynagent = 1;
} else {
if ($agent_id == '.2') {
$dynagent = 2;
} else {
// Detect if agent exists
if ($pfAgent->getFromDB($agent_id)) {
if ($pfTask->fields['communication'] == 'pull') {
$a_agentlist[$agent_id] = 1;
} else {
if ($pfTaskjob->isAgentAlive('1', $agent_id)) {
$a_agentlist[$agent_id] = 1;
}
}
}
}
}
}
if ($dynagent == '1') {
$a_agents = $pfAgentmodule->getAgentsCanDo('NETWORKDISCOVERY');
foreach ($a_agents as $data) {
if ($count_ip / 10 >= count($a_agentlist)) {
$pfAgent->getFromDB($data['id']);
$a_ip = $pfAgent->getIPs();
foreach ($a_ip as $ip) {
if ($pfTask->fields['communication'] == 'push') {
if ($pfTaskjob->isAgentAlive('1', $data['id'])) {
$a_agentlist[$data['id']] = 1;
}
} else {
if ($pfTask->fields['communication'] == 'pull') {
$a_agentlist[$data['id']] = 1;
}
}
}
}
}
}
if ($dynagent == '2') {
// Dynamic with subnet
$pfSnmpinventory = new PluginFusioninventoryNetworkinventory();
$taskvalid = 0;
foreach ($a_subnet_nbip as $iprange_id => $nbips) {
//$maxagentpossible = $nbips/10;
$pfIPRange->getFromDB($iprange_id);
$a_agentListComplete = array();
$a_agentList = $pfSnmpinventory->getAgentsSubnet($nbips, "push", "", $pfIPRange->fields['ip_start'], $pfIPRange->fields['ip_end']);
if (isset($a_agentList)) {
$a_agentListComplete = array_merge($a_agentListComplete, $a_agentList);
}
if (!isset($a_agentListComplete) or empty($a_agentListComplete)) {
$a_input = array();
$a_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$a_input['plugin_fusioninventory_agents_id'] = 0;
$a_input['state'] = 1;
$a_input['itemtype'] = 'PluginFusioninventoryIPRange';
$a_input['items_id'] = $iprange_id;
$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, 'PluginFusioninventoryIPRange', 1, "Unable to find agent to run this job");
$input_taskjob = array();
$input_taskjob['id'] = $pfTaskjob->fields['id'];
//$input_taskjob['status'] = 1;
$pfTaskjob->update($input_taskjob);
} else {
$s = $pfIPRange->getIp2long($pfIPRange->fields['ip_start']);
$e = $pfIPRange->getIp2long($pfIPRange->fields['ip_end']);
$nbIpAgent = ceil(($e - $s) / count($a_agentListComplete));
$iptimes = 0;
foreach ($a_agentListComplete as $agent_id) {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$agent_id] = 1;
//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['itemtype'] = 'PluginFusioninventoryIPRange';
$a_input['uniqid'] = $uniqid;
$a_input['execution_id'] = $task->fields['execution_id'];
$a_input['items_id'] = $iprange_id;
if ($iptimes + $nbIpAgent > $e - $s) {
$a_input['specificity'] = $iptimes . "-" . ($e - $s);
} else {
$a_input['specificity'] = $iptimes . "-" . ($iptimes + $nbIpAgent);
}
$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']);
$iptimes += $nbIpAgent + 1;
if ($iptimes >= $e - $s + 1) {
break;
}
$input_taskjob = array();
$input_taskjob['id'] = $pfTaskjob->fields['id'];
$input_taskjob['status'] = 1;
$pfTaskjob->update($input_taskjob);
}
}
}
if ($taskvalid == "0") {
$pfTaskjob->reinitializeTaskjobs($pfTaskjob->fields['plugin_fusioninventory_tasks_id']);
}
// *** Add jobstate
} else {
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'] = 'PluginFusioninventoryIPRange';
$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, 'PluginFusioninventoryIPRange', 1, "Unable to find agent to run this job");
$input_taskjob = array();
$input_taskjob['id'] = $pfTaskjob->fields['id'];
//$input_taskjob['status'] = 1;
$pfTaskjob->update($input_taskjob);
} else {
$iptimes = 0;
$nbIpadded = 0;
$break = 0;
$numberIpByAgent = ceil($count_ip / count($a_agentlist));
$a_iprangelistTmp = $a_iprangelist;
$ip_id = array_shift($a_iprangelistTmp);
foreach ($a_agentlist as $agent_id => $ip) {
//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['itemtype'] = 'PluginFusioninventoryIPRange';
$a_input['uniqid'] = $uniqid;
$a_input['execution_id'] = $task->fields['execution_id'];
// $nbIpAgent = $numberIpByAgent;
$nbIpadded = 0;
foreach ($a_iprangelist as $iprange_id) {
if ($ip_id == $iprange_id) {
$pfIPRange->getFromDB($iprange_id);
$s = $pfIPRange->getIp2long($pfIPRange->fields['ip_start']);
$e = $pfIPRange->getIp2long($pfIPRange->fields['ip_end']);
if ($communication == "push") {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$agent_id] = 1;
}
$a_input['items_id'] = $iprange_id;
$nbIpAgent = $numberIpByAgent - $nbIpadded;
if ($iptimes + $nbIpAgent > $e - $s) {
$a_input['specificity'] = $iptimes . "-" . ($e - $s);
$nbIpadded = $e - $s - $iptimes;
$ip_id = array_shift($a_iprangelistTmp);
$iptimes = 0;
} else {
$a_input['specificity'] = $iptimes . "-" . ($iptimes + $nbIpAgent);
$iptimes += $nbIpAgent + 1;
$nbIpadded = 0;
$break = 1;
}
$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']);
}
}
$input_taskjob = array();
$input_taskjob['id'] = $pfTaskjob->fields['id'];
$input_taskjob['status'] = 1;
$pfTaskjob->update($input_taskjob);
}
}
}
return $uniqid;
}
if ($className == "PluginFusioninventoryCollect") {
$class = new PluginFusioninventoryCollect();
foreach ($array as $data) {
$out = $class->run($data, $a_agent);
if (count($out) > 0) {
$response[] = $out;
}
$pfTaskjobstate->changeStatus($data['id'], PluginFusioninventoryTaskjobstate::SERVER_HAS_SENT_DATA);
$a_input = array();
$a_input['plugin_fusioninventory_taskjobstates_id'] = $data['id'];
$a_input['items_id'] = $a_agent['id'];
$a_input['itemtype'] = 'PluginFusioninventoryAgent';
$a_input['date'] = date("Y-m-d H:i:s");
$a_input['comment'] = '';
$a_input['state'] = PluginFusioninventoryTaskjoblog::TASK_STARTED;
$pfTaskjoblog->add($a_input);
}
}
}
}
}
}
break;
case 'setAnswer':
// example
// ?action=setAnswer&InformationSource=0x00000000&BIOSVersion=VirtualBox&SystemManufacturer=innotek%20GmbH&uuid=fepjhoug56743h&SystemProductName=VirtualBox&BIOSReleaseDate=12%2F01%2F2006
$pfTaskjobstate = new PluginFusioninventoryTaskjobstate();
$pfAgent = new PluginFusioninventoryAgent();
$jobstate = current($pfTaskjobstate->find("`uniqid`='" . $_GET['uuid'] . "'\n AND `state`!='" . PluginFusioninventoryTaskjobstate::FINISHED . "'", '', 1));
if (isset($jobstate['plugin_fusioninventory_agents_id'])) {
$pfAgent->getFromDB($jobstate['plugin_fusioninventory_agents_id']);
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;
}
function cancel($reason = '')
{
$log = new PluginFusioninventoryTaskjoblog();
$log_input = array('plugin_fusioninventory_taskjobstates_id' => $this->fields['id'], 'items_id' => $this->fields['items_id'], 'itemtype' => $this->fields['itemtype'], 'date' => date("Y-m-d H:i:s"), 'state' => PluginFusioninventoryTaskjoblog::TASK_INFO, 'comment' => Toolbox::addslashes_deep($reason));
$log->add($log_input);
$this->update(array('id' => $this->fields['id'], 'state' => self::CANCELLED));
}
function prepareTaskjobs($methods = array())
{
global $DB;
$agent = new PluginFusioninventoryAgent();
$timeslot = new PluginFusioninventoryTimeslot();
$now = new DateTime();
//transform methods array into string for database query
$methods = "'" . implode("','", $methods) . "'";
$query = implode(" \n", array("SELECT", " task.`id`, task.`name`,", " job.`id`, job.`name`, job.`method`, ", " job.`targets`, job.`actors`", "FROM `glpi_plugin_fusioninventory_taskjobs` job", "LEFT JOIN `glpi_plugin_fusioninventory_tasks` task", " ON task.`id` = job.`plugin_fusioninventory_tasks_id`", "WHERE task.`is_active` = 1", "AND (", " ( task.`datetime_start` IS NOT NULL AND task.`datetime_end` IS NULL", " AND '" . $now->format("Y-m-d H:i:s") . "' >= task.`datetime_start` )", " OR", " ( task.`datetime_start` IS NOT NULL AND task.`datetime_end` IS NOT NULL", " AND '" . $now->format("Y-m-d H:i:s") . "' ", " between task.`datetime_start` AND task.`datetime_end` )", " OR", " ( task.`datetime_start` IS NULL AND task.`datetime_end` IS NULL )", ")", "AND job.`method` IN (" . $methods . ")", "ORDER BY job.`id`"));
$query_result = $DB->query($query);
$results = array();
if ($query_result) {
$results = PluginFusioninventoryToolbox::fetchAssocByTable($query_result);
}
// Fetch a list of actors to be prepared. We may have the same actors for each job so this
// part can speed up the process.
//$actors = array();
// Set basic elements of jobstates
$run_base = array('state' => PluginFusioninventoryTaskjobstate::PREPARED);
$log_base = array('date' => $now->format("Y-m-d H:i:s"), 'state' => PluginFusioninventoryTaskjoblog::TASK_PREPARED, 'comment' => '');
$jobstate = new PluginFusioninventoryTaskjobstate();
$joblog = new PluginFusioninventoryTaskjoblog();
foreach ($results as $index => $result) {
$actors = importArrayFromDB($result['job']['actors']);
// Get agents linked to the actors
$agent_ids = array();
foreach ($this->getAgentsFromActors($actors) as $agent_id) {
$agent_ids[$agent_id] = true;
}
//Continue with next job if there are no agents found from actors.
//TODO: This may be good to report this kind of information. We just need to do a list of
//agent's ids generated by actors like array('actors_type-id' => array( 'agent_0',...).
//Then the following could be put in the targets foreach loop before looping through
//agents.
if (count($agent_ids) == 0) {
continue;
}
$saved_agent_ids = $agent_ids;
$targets = importArrayFromDB($result['job']['targets']);
if ($result['job']['method'] == 'networkinventory') {
$pfNetworkinventory = new PluginFusioninventoryNetworkinventory();
foreach ($targets as $keyt => $target) {
$item_type = key($target);
$items_id = current($target);
if ($item_type == 'PluginFusioninventoryIPRange') {
unset($targets[$keyt]);
// In this case get devices of this iprange
$deviceList = $pfNetworkinventory->getDevicesOfIPRange($items_id);
$targets = array_merge($targets, $deviceList);
}
}
}
$limit = 0;
foreach ($targets as $target) {
$agent_ids = $saved_agent_ids;
$item_type = key($target);
$item_id = current($target);
$job_id = $result['job']['id'];
$jobstates_running = $jobstate->find(implode(" \n", array(" `itemtype` = '" . $item_type . "'", "AND `items_id` = " . $item_id, "AND `plugin_fusioninventory_taskjobs_id` = " . $job_id, "AND `state` not in ('" . implode("','", array(PluginFusioninventoryTaskjobstate::FINISHED, PluginFusioninventoryTaskjobstate::IN_ERROR, PluginFusioninventoryTaskjobstate::CANCELLED)) . "')", "AND `plugin_fusioninventory_agents_id` IN (", "'" . implode("','", array_keys($agent_ids)) . "'", ")")));
// Filter out agents that are already running the targets.
foreach ($jobstates_running as $jobstate_running) {
$jobstate_agent_id = $jobstate_running['plugin_fusioninventory_agents_id'];
if (isset($agent_ids[$jobstate_agent_id])) {
$agent_ids[$jobstate_agent_id] = false;
}
}
// Cancel agents prepared but not in $agent_ids (like computer
// not in dynamic group)
$jobstates_tocancel = $jobstate->find(implode(" \n", array(" `itemtype` = '" . $item_type . "'", "AND `items_id` = " . $item_id, "AND `plugin_fusioninventory_taskjobs_id` = " . $job_id, "AND `state` not in ('" . implode("','", array(PluginFusioninventoryTaskjobstate::FINISHED, PluginFusioninventoryTaskjobstate::IN_ERROR, PluginFusioninventoryTaskjobstate::CANCELLED)) . "')", "AND `plugin_fusioninventory_agents_id` NOT IN (", "'" . implode("','", array_keys($agent_ids)) . "'", ")")));
foreach ($jobstates_tocancel as $jobstate_tocancel) {
$jobstate->getFromDB($jobstate_tocancel['id']);
$jobstate->cancel(__('Device no longer defined in definition of job', 'fusioninventory'));
}
foreach ($agent_ids as $agent_id => $agent_not_running) {
if ($agent_not_running) {
$limit += 1;
if ($limit > 500) {
$limit = 0;
break;
}
$run = array_merge($run_base, array('itemtype' => $item_type, 'items_id' => $item_id, 'plugin_fusioninventory_taskjobs_id' => $job_id, 'plugin_fusioninventory_agents_id' => $agent_id, 'uniqid' => uniqid()));
$run_id = $jobstate->add($run);
if ($run_id !== false) {
$log = array_merge($log_base, array('plugin_fusioninventory_taskjobstates_id' => $run_id, ''));
$joblog->add($log);
}
}
}
}
}
return true;
}
/**
* Get all devices and put in taskjobstate each task for
* each device for each agent
*
* @param type $taskjobs_id id of taskjob esx
*
* @return uniqid value
*/
function prepareRun($taskjobs_id)
{
$task = new PluginFusioninventoryTask();
$job = new PluginFusioninventoryTaskjob();
$joblog = new PluginFusioninventoryTaskjoblog();
$jobstate = new PluginFusioninventoryTaskjobstate();
$uniqid = uniqid();
$job->getFromDB($taskjobs_id);
$task->getFromDB($job->fields['plugin_fusioninventory_tasks_id']);
$communication = $task->fields['communication'];
//list all agents
$agent_actions = importArrayFromDB($job->fields['action']);
$task_definitions = importArrayFromDB($job->fields['definition']);
$agent_actionslist = array();
foreach ($agent_actions as $targets) {
foreach ($targets as $itemtype => $items_id) {
$item = new $itemtype();
// Detect if agent exists
if ($item->getFromDB($items_id)) {
$agent_actionslist[$items_id] = 1;
}
}
}
// *** Add jobstate
if (empty($agent_actionslist)) {
$a_input = array();
$a_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$a_input['state'] = 0;
$a_input['plugin_fusioninventory_agents_id'] = 0;
$a_input['uniqid'] = $uniqid;
$a_input['execution_id'] = $task->fields['execution_id'];
foreach ($task_definitions as $task_definition) {
foreach ($task_definition as $task_itemtype => $task_items_id) {
$a_input['itemtype'] = $task_itemtype;
$a_input['items_id'] = $task_items_id;
$jobstates_id = $jobstate->add($a_input);
//Add log of taskjob
$a_input['plugin_fusioninventory_taskjobstates_id'] = $jobstates_id;
$a_input['state'] = PluginFusioninventoryTaskjoblog::TASK_PREPARED;
$a_input['date'] = date("Y-m-d H:i:s");
$joblog->add($a_input);
$jobstate->changeStatusFinish($jobstates_id, 0, 'PluginFusioninventoryInventoryComputerESX', 1, "Unable to find agent to run this job");
}
}
$job->update($job->fields);
} else {
foreach ($agent_actions as $targets) {
foreach ($targets as $items_id) {
if ($communication == "push") {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$items_id] = 1;
}
foreach ($task_definitions as $task_definition) {
foreach ($task_definition as $task_itemtype => $task_items_id) {
$a_input = array();
$a_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$a_input['state'] = 0;
$a_input['plugin_fusioninventory_agents_id'] = $items_id;
$a_input['itemtype'] = $task_itemtype;
$a_input['items_id'] = $task_items_id;
$a_input['uniqid'] = $uniqid;
$a_input['date'] = date("Y-m-d H:i:s");
$a_input['execution_id'] = $task->fields['execution_id'];
$jobstates_id = $jobstate->add($a_input);
//Add log of taskjob
$a_input['plugin_fusioninventory_taskjobstates_id'] = $jobstates_id;
$a_input['state'] = PluginFusioninventoryTaskjoblog::TASK_PREPARED;
$joblog->add($a_input);
unset($a_input['state']);
}
}
}
}
$job->fields['status'] = 1;
$job->update($job->fields);
}
return $uniqid;
}
function prepareRun($taskjob_id, $definitions_filter = NULL)
{
global $DB;
$task = new PluginFusioninventoryTask();
$job = new PluginFusioninventoryTaskjob();
$joblog = new PluginFusioninventoryTaskjoblog();
$jobstate = new PluginFusioninventoryTaskjobstate();
$agent = new PluginFusioninventoryAgent();
$agentmodule = new PluginFusioninventoryAgentmodule();
$job->getFromDB($taskjob_id);
$task->getFromDB($job->fields['plugin_fusioninventory_tasks_id']);
$communication = $task->fields['communication'];
$actions = importArrayFromDB($job->fields['action']);
$definitions = importArrayFromDB($job->fields['definition']);
$taskvalid = 0;
$computers = array();
foreach ($actions as $action) {
$itemtype = key($action);
$items_id = current($action);
switch ($itemtype) {
case 'Computer':
if ($this->definitionFiltered("Computer", $definitions_filter)) {
break;
}
$computers[] = $items_id;
break;
case 'Group':
if ($this->definitionFiltered("Group", $definitions_filter)) {
break;
}
$computer_object = new Computer();
//find computers by user associated with this group
$group_users = new Group_User();
$group = new Group();
$group->getFromDB($items_id);
$members = array();
$computers_a_1 = array();
$computers_a_2 = array();
//array_keys($group_users->find("groups_id = '$items_id'"));
$members = $group_users->getGroupUsers($items_id);
foreach ($members as $member) {
$computers = $computer_object->find("users_id = '{$member['id']}' " . " AND `is_deleted`='0' AND `is_template`='0'");
foreach ($computers as $computer) {
$computers_a_1[] = $computer['id'];
}
}
//find computers directly associated with this group
$computers = $computer_object->find("groups_id = '{$items_id}' " . " AND `is_deleted`='0' AND `is_template`='0'");
foreach ($computers as $computer) {
$computers_a_2[] = $computer['id'];
}
//merge two previous array and deduplicate entries
$computers = array_unique(array_merge($computers_a_1, $computers_a_2));
break;
case 'PluginFusioninventoryDeployGroup':
$group = new PluginFusioninventoryDeployGroup();
$group->getFromDB($items_id);
switch ($group->getField('type')) {
case 'STATIC':
if ($this->definitionFiltered("PluginFusioninventoryDeployGroupStatic", $definitions_filter)) {
break;
}
$query = "SELECT items_id\n FROM glpi_plugin_fusioninventory_deploygroups_staticdatas\n WHERE groups_id = '{$items_id}'\n AND itemtype = 'Computer'";
$res = $DB->query($query);
while ($row = $DB->fetch_assoc($res)) {
$computers[] = $row['items_id'];
}
break;
case 'DYNAMIC':
if ($this->definitionFiltered("PluginFusioninventoryDeployGroupDynamic", $definitions_filter)) {
break;
}
//$definitions_filter is NULL = update by crontask !
if ($definitions_filter != NULL) {
$where = " AND `can_update_group`='1'";
} else {
$where = "";
}
$query = "SELECT fields_array\n FROM glpi_plugin_fusioninventory_deploygroups_dynamicdatas\n WHERE groups_id = '{$items_id}' {$where}\n LIMIT 1";
$res = $DB->query($query);
$row = $DB->fetch_assoc($res);
//No dynamic groups have been found : break
if ($DB->numrows($res) == 0) {
break;
}
if (isset($_GET)) {
$get_tmp = $_GET;
}
if (isset($_SESSION["glpisearchcount"]['Computer'])) {
unset($_SESSION["glpisearchcount"]['Computer']);
}
if (isset($_SESSION["glpisearchcount2"]['Computer'])) {
unset($_SESSION["glpisearchcount2"]['Computer']);
}
$_GET = importArrayFromDB($row['fields_array']);
$_GET["glpisearchcount"] = count($_GET['field']);
if (isset($_GET['field2'])) {
$_GET["glpisearchcount2"] = count($_GET['field2']);
}
$pfSearch = new PluginFusioninventorySearch();
Search::manageParams('Computer');
$glpilist_limit = $_SESSION['glpilist_limit'];
$_SESSION['glpilist_limit'] = 999999999;
$result = $pfSearch->constructSQL('Computer', $_GET);
$_SESSION['glpilist_limit'] = $glpilist_limit;
while ($data = $DB->fetch_array($result)) {
$computers[] = $data['id'];
}
if (count($get_tmp) > 0) {
$_GET = $get_tmp;
}
break;
}
break;
}
}
//Remove duplicatas from array
//We are using isset for faster processing than array_unique because we might have many
//entries in this list.
$tmp_computers = array();
foreach ($computers as $computer) {
if (!isset($tmp_computers[$computer])) {
$tmp_computers[$computer] = 1;
}
}
$computers = array_keys($tmp_computers);
$c_input = array();
$c_input['plugin_fusioninventory_taskjobs_id'] = $job->fields['id'];
$c_input['state'] = 0;
$c_input['plugin_fusioninventory_agents_id'] = 0;
$c_input['execution_id'] = $task->fields['execution_id'];
$package = new PluginFusioninventoryDeployPackage();
foreach ($computers as $computer_id) {
//Unique Id match taskjobstatuses for an agent(computer)
foreach ($definitions as $definition) {
$uniqid = uniqid();
$package->getFromDB($definition['PluginFusioninventoryDeployPackage']);
$c_input['state'] = 0;
$c_input['itemtype'] = 'PluginFusioninventoryDeployPackage';
$c_input['items_id'] = $package->fields['id'];
$c_input['date'] = date("Y-m-d H:i:s");
$c_input['uniqid'] = $uniqid;
//get agent for this computer
$agents_id = $agent->getAgentWithComputerid($computer_id);
if ($agents_id === FALSE) {
$jobstates_id = $jobstate->add($c_input);
$jobstate->changeStatusFinish($jobstates_id, 0, '', 1, "No agent found for [[Computer::" . $computer_id . "]]", 0, 0);
} else {
if ($agentmodule->isAgentCanDo('DEPLOY', $agents_id)) {
$c_input['plugin_fusioninventory_agents_id'] = $agents_id;
$jobstates_running = $jobstate->find(implode(" ", array(" `itemtype` = 'PluginFusioninventoryDeployPackage'", "AND `items_id` = " . $package->fields['id'], "AND `state` <> " . PluginFusioninventoryTaskjobstate::FINISHED, "AND `plugin_fusioninventory_agents_id` = " . $agents_id)));
if (count($jobstates_running) == 0) {
# Push the agent, in the stack of agent to awake
if ($communication == "push") {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$agents_id] = 1;
}
$jobstates_id = $jobstate->add($c_input);
//Add log of taskjob
$c_input['plugin_fusioninventory_taskjobstates_id'] = $jobstates_id;
$c_input['state'] = PluginFusioninventoryTaskjoblog::TASK_PREPARED;
$taskvalid++;
$joblog->add($c_input);
unset($c_input['state']);
unset($c_input['plugin_fusioninventory_agents_id']);
}
}
}
}
}
if ($taskvalid > 0) {
$job->fields['status'] = 1;
$job->update($job->fields);
} else {
$job->reinitializeTaskjobs($job->fields['plugin_fusioninventory_tasks_id']);
}
}
function prepareRun($taskjobs_id)
{
global $DB;
$task = new PluginFusioninventoryTask();
$job = new PluginFusioninventoryTaskjob();
$joblog = new PluginFusioninventoryTaskjoblog();
$jobstate = new PluginFusioninventoryTaskjobstate();
$agent = new PluginFusioninventoryAgent();
$uniqid = uniqid();
$job->getFromDB($taskjobs_id);
$task->getFromDB($job->fields['plugin_fusioninventory_tasks_id']);
$communication = $task->fields['communication'];
$actions = importArrayFromDB($job->fields['action']);
$definitions = importArrayFromDB($job->fields['definition']);
$taskvalid = 0;
$computers = array();
foreach ($actions as $action) {
$itemtype = key($action);
$items_id = current($action);
switch ($itemtype) {
case 'Computer':
$computers[] = $items_id;
break;
case 'Group':
$computer_object = new Computer();
//find computers by user associated with this group
$group_users = new Group_User();
$group = new Group();
$group->getFromDB($items_id);
$members = array();
$computers_a_1 = array();
$computers_a_2 = array();
//array_keys($group_users->find("groups_id = '$items_id'"));
$members = $group_users->getGroupUsers($items_id);
foreach ($members as $member) {
$computers = $computer_object->find("users_id = '{$member['id']}'");
foreach ($computers as $computer) {
$computers_a_1[] = $computer['id'];
}
}
//find computers directly associated with this group
$computers = $computer_object->find("groups_id = '{$items_id}'");
foreach ($computers as $computer) {
$computers_a_2[] = $computer['id'];
}
//merge two previous array and deduplicate entries
$computers = array_unique(array_merge($computers_a_1, $computers_a_2));
break;
case 'PluginFusioninventoryDeployGroup':
$group = new PluginFusioninventoryDeployGroup();
$group->getFromDB($items_id);
switch ($group->getField('type')) {
case 'STATIC':
$query = "SELECT items_id\n FROM glpi_plugin_fusioninventory_deploygroups_staticdatas\n WHERE groups_id = '{$items_id}'\n AND itemtype = 'Computer'";
$res = $DB->query($query);
while ($row = $DB->fetch_assoc($res)) {
$computers[] = $row['items_id'];
}
break;
case 'DYNAMIC':
$query = "SELECT fields_array\n FROM glpi_plugin_fusioninventory_deploygroups_dynamicdatas\n WHERE groups_id = '{$items_id}'\n LIMIT 1";
$res = $DB->query($query);
$row = $DB->fetch_assoc($res);
if (isset($_GET)) {
$get_tmp = $_GET;
}
if (isset($_SESSION["glpisearchcount"]['Computer'])) {
unset($_SESSION["glpisearchcount"]['Computer']);
}
if (isset($_SESSION["glpisearchcount2"]['Computer'])) {
unset($_SESSION["glpisearchcount2"]['Computer']);
}
$_GET = importArrayFromDB($row['fields_array']);
$_GET["glpisearchcount"] = count($_GET['field']);
if (isset($_GET['field2'])) {
$_GET["glpisearchcount2"] = count($_GET['field2']);
}
$pfSearch = new PluginFusioninventorySearch();
Search::manageGetValues('Computer');
$glpilist_limit = $_SESSION['glpilist_limit'];
$_SESSION['glpilist_limit'] = 999999999;
$result = $pfSearch->constructSQL('Computer', $_GET);
$_SESSION['glpilist_limit'] = $glpilist_limit;
while ($data = $DB->fetch_array($result)) {
$computers[] = $data['id'];
}
if (count($get_tmp) > 0) {
$_GET = $get_tmp;
}
break;
}
break;
}
}
$c_input = array();
$c_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$c_input['state'] = 0;
$c_input['plugin_fusioninventory_agents_id'] = 0;
$c_input['execution_id'] = $task->fields['execution_id'];
$pfCollect = new PluginFusioninventoryCollect();
foreach ($computers as $computer_id) {
//get agent if for this computer
$agents_id = $agent->getAgentWithComputerid($computer_id);
if ($agents_id === FALSE) {
$jobstates_id = $jobstate->add($c_input);
$jobstate->changeStatusFinish($jobstates_id, 0, '', 1, "No agent found for [[Computer::" . $computer_id . "]]", 0, 0);
} else {
foreach ($definitions as $definition) {
$pfCollect->getFromDB($definition['PluginFusioninventoryCollect']);
switch ($pfCollect->fields['type']) {
case 'registry':
// get all registry
$pfCollect_Registry = new PluginFusioninventoryCollect_Registry();
$a_registries = $pfCollect_Registry->find("`plugin_fusioninventory_collects_id`='" . $pfCollect->fields['id'] . "'");
foreach ($a_registries as $data_r) {
$uniqid = uniqid();
$c_input['state'] = 0;
$c_input['itemtype'] = 'PluginFusioninventoryCollect_Registry';
$c_input['items_id'] = $data_r['id'];
$c_input['date'] = date("Y-m-d H:i:s");
$c_input['uniqid'] = $uniqid;
$c_input['plugin_fusioninventory_agents_id'] = $agents_id;
# Push the agent, in the stack of agent to awake
if ($communication == "push") {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$agents_id] = 1;
}
$jobstates_id = $jobstate->add($c_input);
//Add log of taskjob
$c_input['plugin_fusioninventory_taskjobstates_id'] = $jobstates_id;
$c_input['state'] = PluginFusioninventoryTaskjoblog::TASK_PREPARED;
$taskvalid++;
$joblog->add($c_input);
}
break;
case 'wmi':
// get all wmi
$pfCollect_Wmi = new PluginFusioninventoryCollect_Wmi();
$a_wmies = $pfCollect_Wmi->find("`plugin_fusioninventory_collects_id`='" . $pfCollect->fields['id'] . "'");
foreach ($a_wmies as $data_r) {
$uniqid = uniqid();
$c_input['state'] = 0;
$c_input['itemtype'] = 'PluginFusioninventoryCollect_Wmi';
$c_input['items_id'] = $data_r['id'];
$c_input['date'] = date("Y-m-d H:i:s");
$c_input['uniqid'] = $uniqid;
$c_input['plugin_fusioninventory_agents_id'] = $agents_id;
# Push the agent, in the stack of agent to awake
if ($communication == "push") {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$agents_id] = 1;
}
$jobstates_id = $jobstate->add($c_input);
//Add log of taskjob
$c_input['plugin_fusioninventory_taskjobstates_id'] = $jobstates_id;
$c_input['state'] = PluginFusioninventoryTaskjoblog::TASK_PREPARED;
$taskvalid++;
$joblog->add($c_input);
}
break;
case 'file':
// find files
$pfCollect_File = new PluginFusioninventoryCollect_File();
$a_files = $pfCollect_File->find("`plugin_fusioninventory_collects_id`='" . $pfCollect->fields['id'] . "'");
foreach ($a_files as $data_r) {
$uniqid = uniqid();
$c_input['state'] = 0;
$c_input['itemtype'] = 'PluginFusioninventoryCollect_File';
$c_input['items_id'] = $data_r['id'];
$c_input['date'] = date("Y-m-d H:i:s");
$c_input['uniqid'] = $uniqid;
$c_input['plugin_fusioninventory_agents_id'] = $agents_id;
# Push the agent, in the stack of agent to awake
if ($communication == "push") {
$_SESSION['glpi_plugin_fusioninventory']['agents'][$agents_id] = 1;
}
$jobstates_id = $jobstate->add($c_input);
//Add log of taskjob
$c_input['plugin_fusioninventory_taskjobstates_id'] = $jobstates_id;
$c_input['state'] = PluginFusioninventoryTaskjoblog::TASK_PREPARED;
$taskvalid++;
$joblog->add($c_input);
}
break;
}
}
}
}
if ($taskvalid > 0) {
$job->fields['status'] = 1;
$job->update($job->fields);
} else {
$job->reinitializeTaskjobs($job->fields['plugin_fusioninventory_tasks_id']);
}
}
function prepareRun($taskjobs_id)
{
global $DB;
$pfTask = new PluginFusioninventoryTask();
$pfTaskjob = new PluginFusioninventoryTaskjob();
$pfTaskjobstate = new PluginFusioninventoryTaskjobstate();
$pfTaskjoblog = new PluginFusioninventoryTaskjoblog();
$pfAgent = new PluginFusioninventoryAgent();
$uniqid = uniqid();
$pfTaskjob->getFromDB($taskjobs_id);
$pfTask->getFromDB($pfTaskjob->fields['plugin_fusioninventory_tasks_id']);
$communication = $pfTask->fields['communication'];
$a_definitions = importArrayFromDB($pfTaskjob->fields['definition']);
$a_computers_to_wake = array();
foreach ($a_definitions as $definition) {
$itemtype = key($definition);
$items_id = current($definition);
switch ($itemtype) {
case 'Computer':
$a_computers_to_wake[] = $items_id;
break;
case 'PluginFusioninventoryDeployGroup':
$group = new PluginFusioninventoryDeployGroup();
$group->getFromDB($items_id);
switch ($group->getField('type')) {
case 'STATIC':
$query = "SELECT items_id\n FROM glpi_plugin_fusioninventory_deploygroups_staticdatas\n WHERE groups_id = '{$items_id}'\n AND itemtype = 'Computer'";
$res = $DB->query($query);
while ($row = $DB->fetch_assoc($res)) {
$a_computers_to_wake[] = $row['items_id'];
}
break;
case 'DYNAMIC':
$query = "SELECT fields_array\n FROM glpi_plugin_fusioninventory_deploygroups_dynamicdatas\n WHERE groups_id = '{$items_id}'\n LIMIT 1";
$res = $DB->query($query);
$row = $DB->fetch_assoc($res);
if (isset($_GET)) {
$get_tmp = $_GET;
}
if (isset($_SESSION["glpisearchcount"]['Computer'])) {
unset($_SESSION["glpisearchcount"]['Computer']);
}
if (isset($_SESSION["glpisearchcount2"]['Computer'])) {
unset($_SESSION["glpisearchcount2"]['Computer']);
}
$_GET = importArrayFromDB($row['fields_array']);
$_GET["glpisearchcount"] = count($_GET['field']);
if (isset($_GET['field2'])) {
$_GET["glpisearchcount2"] = count($_GET['field2']);
}
$pfSearch = new PluginFusioninventorySearch();
Search::manageGetValues('Computer');
$glpilist_limit = $_SESSION['glpilist_limit'];
$_SESSION['glpilist_limit'] = 999999999;
$result = $pfSearch->constructSQL('Computer', $_GET);
$_SESSION['glpilist_limit'] = $glpilist_limit;
while ($data = $DB->fetch_array($result)) {
$a_computers_to_wake[] = $data['id'];
}
if (count($get_tmp) > 0) {
$_GET = $get_tmp;
}
break;
}
}
}
$a_actions = importArrayFromDB($pfTaskjob->fields['action']);
$a_agentList = array();
if (!strstr($pfTaskjob->fields['action'], '".1"') and !strstr($pfTaskjob->fields['action'], '".2"')) {
foreach ($a_actions as $a_action) {
if (!in_array('.1', $a_action) && !in_array('.2', $a_action)) {
$agent_id = current($a_action);
if ($pfAgent->getFromDB($agent_id)) {
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($a_computers_to_wake), $communication);
} else {
if (in_array('.2', $a_actions)) {
$subnet = '';
foreach ($a_computers_to_wake as $items_id) {
$sql = "SELECT * FROM `glpi_networkports`\n WHERE `items_id`='" . $items_id . "'\n AND `itemtype`='Computer'\n AND `mac`!='' ";
$result = $DB->query($sql);
if ($result) {
while ($data = $DB->fetch_array($result)) {
$subnet = $data['subnet'];
}
}
}
if ($subnet != '') {
$a_agentList = $this->getAgentsSubnet(count($a_computers_to_wake), $communication, $subnet);
}
}
}
}
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'] = 'Computer';
$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, 'Computer', 1, "Unable to find agent to run this job");
} else {
$nb_computers = ceil(count($a_computers_to_wake) / count($a_agentList));
$a_input = array();
$a_input['plugin_fusioninventory_taskjobs_id'] = $taskjobs_id;
$a_input['state'] = 0;
$a_input['itemtype'] = 'Computer';
$a_input['uniqid'] = $uniqid;
while (count($a_computers_to_wake) != 0) {
$agent_id = array_pop($a_agentList);
$a_input['plugin_fusioninventory_agents_id'] = $agent_id;
for ($i = 0; $i < $nb_computers; $i++) {
//Add jobstate and put status
$a_input['items_id'] = array_pop($a_computers_to_wake);
$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;
}
}
}
}
$pfTaskjob->fields['status'] = 1;
$pfTaskjob->update($pfTaskjob->fields);
return $uniqid;
}
