/cron/centAcl-Func.php

<?php

/*
 * Copyright 2005-2015 Centreon
 * Centreon is developped by : Julien Mathis and Romain Le Merlus under
 * GPL Licence 2.0.
 *
 * This program 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.
 *
 * This program 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
 * this program; if not, see <http://www.gnu.org/licenses>.
 *
 * Linking this program statically or dynamically with other modules is making a
 * combined work based on this program. Thus, the terms and conditions of the GNU
 * General Public License cover the whole combination.
 *
 * As a special exception, the copyright holders of this program give Centreon
 * permission to link this program with independent modules to produce an executable,
 * regardless of the license terms of these independent modules, and to copy and
 * distribute the resulting executable under terms of Centreon choice, provided that
 * Centreon also meet, for each linked independent module, the terms  and conditions
 * of the license of that module. An independent module is a module which is not
 * derived from this program. If you modify this program, you may extend this
 * exception to your version of the program, but you are not obliged to do so. If you
 * do not wish to do so, delete this exception statement from your version.
 *
 * For more information : contact@centreon.com
 *
 */

/*
 * Init functions
 */

function microtime_float2() {
    list($usec, $sec) = explode(" ", microtime());
    return ((float) $usec + (float) $sec);
}

/**
 * Return host tab after poller filter
 */
function getFilteredPollers($host, $acl_group_id, $res_id) {
    global $pearDB, $hostCache;

    $request = "SELECT COUNT(*) AS count FROM acl_resources_poller_relations WHERE acl_res_id = '".$res_id."'";
	$DBRESULT = $pearDB->query($request);
	$row = $DBRESULT->fetchRow();
	$isPollerFilter = $row['count'];

    $hostTmp = $host;
    $request = "SELECT host_host_id " .
            "FROM acl_resources_poller_relations, acl_res_group_relations, acl_resources, ns_host_relation " .
            "WHERE acl_resources_poller_relations.acl_res_id = acl_res_group_relations.acl_res_id " .
            "AND acl_res_group_relations.acl_group_id = '" . $acl_group_id . "' " .
            "AND acl_resources_poller_relations.acl_res_id = acl_resources.acl_res_id " .
            "AND acl_resources.acl_res_id = '" . $res_id . "' " .
            "AND ns_host_relation.nagios_server_id = acl_resources_poller_relations.poller_id " .
            "AND acl_res_activate = '1'";
    $DBRESULT = $pearDB->query($request);

    if ($DBRESULT->numRows()) {
        $host = array();
		while ($row = $DBRESULT->fetchRow()) {
			if (isset($hostTmp[$row['host_host_id']])) {
				$host[$row['host_host_id']] = $hostCache[$row['host_host_id']];
			}
		}
    } else {
		# If result of query is empty and user have poller restriction, clean host table.
		if ($isPollerFilter) {
			$host = array();
		}
	}
    return $host;
}

/**
 * Return host tab after host categories filter
 */
function getFilteredHostCategories($host, $acl_group_id, $res_id) {
    global $pearDB, $hostCache, $hostTemplateCache;

    $hostTmp = $host;
    $request = "SELECT host_host_id " .
            "FROM acl_resources_hc_relations, acl_res_group_relations, acl_resources, hostcategories_relation " .
            "WHERE acl_resources_hc_relations.acl_res_id = acl_res_group_relations.acl_res_id " .
            "AND acl_res_group_relations.acl_group_id = '" . $acl_group_id . "' " .
            "AND acl_resources_hc_relations.acl_res_id = acl_resources.acl_res_id " .
            "AND acl_resources.acl_res_id = '" . $res_id . "' " .
            "AND hostcategories_relation.hostcategories_hc_id = acl_resources_hc_relations.hc_id " .
            "AND acl_res_activate = '1'";
    $DBRESULT = $pearDB->query($request);
    if ($DBRESULT->numRows()) {
        $host = array();
    }
    while ($row = $DBRESULT->fetchRow()) {
        if (isset($hostTemplateCache[$row['host_host_id']])) {
            // is a template
            foreach ($hostTemplateCache[$row['host_host_id']] as $hId) {
                if (isset($hostTmp[$hId])) {
                    $host[$hId] = $hostCache[$hId];
                }
            }
        } elseif (isset($hostTmp[$row['host_host_id']])) {
            // is not a template
            $host[$row['host_host_id']] = $hostCache[$row['host_host_id']];
        }
    }
    return $host;
}

/*
 * Return enable categories for this resource access
 */

function getAuthorizedCategories($groupstr, $res_id) {
    global $pearDB;

    if (strlen($groupstr) == 0)
        return array();

    $tab_categories = array();
    $request = "SELECT sc_id " .
            "FROM acl_resources_sc_relations, acl_res_group_relations, acl_resources " .
            "WHERE acl_resources_sc_relations.acl_res_id = acl_res_group_relations.acl_res_id " .
            "AND acl_res_group_relations.acl_group_id IN (" . $groupstr . ") " .
            "AND acl_resources_sc_relations.acl_res_id = acl_resources.acl_res_id " .
            "AND acl_resources.acl_res_id = '" . $res_id . "' " .
            "AND acl_res_activate = '1'";
    $DBRESULT = $pearDB->query($request);
    while ($res = $DBRESULT->fetchRow()) {
        $tab_categories[$res["sc_id"]] = $res["sc_id"];
    }
    $DBRESULT->free();
    unset($res);
    unset($DBRESULT);
    return $tab_categories;
}

function getServiceTemplateCategoryList($service_id = NULL) {
    global $pearDB, $svcTplCache, $svcCatCache;

    $tabCategory = array();

    if (!$service_id)
        return;

    if (isset($svcCatCache[$service_id])) {
        foreach ($svcCatCache[$service_id] as $ct_id => $flag) {
            $tabCategory[$ct_id] = $ct_id;
        }
    }

    /*
     * Init Table of template
     */
    $loopBreak = array();
    while (1) {
        if (isset($svcTplCache[$service_id]) && !isset($loopBreak[$service_id])) {
            if (isset($svcCatCache[$service_id])) {
                foreach ($svcCatCache[$service_id] as $ct_id => $flag) {
                    $tabCategory[$ct_id] = $ct_id;
                }
            }
            $loopBreak[$service_id] = true;
            $service_id = $svcTplCache[$service_id];
        } else {
            return $tabCategory;
        }
    }
}

function getACLSGForHost($pearDB, $host_id, $groupstr) {
    global $svcCache, $sgCache;

    if (!$pearDB || !isset($host_id))
        return;

    $svc = array();
    if (isset($sgCache[$groupstr])) {
        foreach ($sgCache[$groupstr] as $key => $tab) {
            foreach ($tab as $hostId => $tab2) {
                if ($host_id == $hostId) {
                    foreach ($tab2 as $svcDesc => $svcId) {
                        $svc[$svcDesc] = $svcId;
                    }
                }
            }
        }
    }
    return $svc;

    /*
     * Init Acl Table
     */
    $svc = array();
    $condition = "";
    if ($groupstr != "") {
        $condition = " WHERE `acl_group_id` IN (" . $groupstr . ") AND ";
    } else {
        $condition = " WHERE ";
    }

    $DBRESULT = $pearDB->query("SELECT argr.`acl_res_id` FROM `acl_res_group_relations` argr, `acl_resources` ar " . $condition . " " .
            "argr.acl_res_id = ar.acl_res_id " .
            "AND ar.acl_res_activate = '1'");
    while ($res = $DBRESULT->fetchRow()) {
        $DBRESULT2 = $pearDB->query("SELECT `service_service_id` " .
                "FROM `servicegroup`, `acl_resources_sg_relations`, `servicegroup_relation` " .
                "WHERE `acl_res_id` = '" . $res["acl_res_id"] . "' " .
                "AND `acl_resources_sg_relations`.`sg_id` = `servicegroup`.`sg_id` " .
                "AND `servicegroup_relation`.`servicegroup_sg_id` = `servicegroup`.`sg_id` " .
                "AND `servicegroup_relation`.`host_host_id` = '" . $host_id . "'");
        while ($service = $DBRESULT2->fetchRow()) {
            if (isset($svcCache[$service["service_service_id"]])) {
                $svc[$svcCache[$service["service_service_id"]]] = $service["service_service_id"];
            }
        }
        $DBRESULT2->free();
    }
    $DBRESULT->free();
    return $svc;
}

/**
 * If the ressource ACL has poller filter
 *
 * @param int $res_id The ACL ressource id
 * @return bool
 */
function hasPollerFilter($res_id) {
    global $pearDB;

    if (!is_numeric($res_id)) {
        return false;
    }

    $query = 'SELECT COUNT(*) as c FROM acl_resources_poller_relations WHERE acl_res_id = ' . $res_id;
    $res = $pearDB->query($query);
    if (PEAR::isError($res)) {
        return false;
    }
    $row = $res->fetchRow();
    if ($row['c'] > 0) {
        return true;
    }
    return false;
}

/**
 * If the ressource ACL has host category filter
 *
 * @param int $res_id The ACL ressource id
 * @return bool
 */
function hasHostCategoryFilter($res_id) {
    global $pearDB;

    if (!is_numeric($res_id)) {
        return false;
    }

    $query = 'SELECT COUNT(*) as c FROM acl_resources_hc_relations WHERE acl_res_id = ' . $res_id;
    $res = $pearDB->query($query);
    if (PEAR::isError($res)) {
        return false;
    }
    $row = $res->fetchRow();
    if ($row['c'] > 0) {
        return true;
    }
    return false;
}

/**
 * If the ressource ACL has service category filter
 *
 * @param int $res_id The ACL ressource id
 * @return bool
 */
function hasServiceCategoryFilter($res_id) {
    global $pearDB;

    if (!is_numeric($res_id)) {
        return false;
    }

    $query = 'SELECT COUNT(*) as c FROM acl_resources_sc_relations WHERE acl_res_id = ' . $res_id;
    $res = $pearDB->query($query);
    if (PEAR::isError($res)) {
        return false;
    }
    $row = $res->fetchRow();
    if ($row['c'] > 0) {
        return true;
    }
    return false;
}

function getAuthorizedServicesHost($host_id, $groupstr, $res_id, $authorizedCategories) {
    global $pearDB, $svcCache, $hostCache;

    $tab_svc = getMyHostServicesByName($host_id);

    /*
     * Get Service Groups
     */
    $svc_SG = getACLSGForHost($pearDB, $host_id, $groupstr);

    $tab_services = array();
    if (count($authorizedCategories)) {
        if ($tab_svc) {
            foreach ($tab_svc as $svc_descr => $svc_id) {
                $tab = getServiceTemplateCategoryList($svc_id);
                foreach ($tab as $t) {
                    if (isset($authorizedCategories[$t])) {
                        $tab_services[$svc_descr] = $svc_id;
                    }
                }
            }
        }
    } else {
        $tab_services = $tab_svc;
        if ($svc_SG) {
            foreach ($svc_SG as $key => $value) {
                $tab_services[$key] = $value;
            }
        }
    }
    return $tab_services;
}

function hostIsAuthorized($host_id, $group_id) {
    global $pearDB;

    $query = "SELECT rhr.host_host_id " .
            "FROM acl_resources_host_relations rhr, acl_resources res, acl_res_group_relations rgr " .
            "WHERE rhr.acl_res_id = res.acl_res_id " .
            "AND res.acl_res_id = rgr.acl_res_id " .
            "AND rgr.acl_group_id = '" . $group_id . "' " .
            "AND rhr.host_host_id = '" . $host_id . "' " .
            "AND res.acl_res_activate = '1'";
    $DBRES = $pearDB->query($query);
    if ($DBRES->numRows())
        return true;

    $query2 = "SELECT hgr.host_host_id FROM " .
            "hostgroup_relation hgr, acl_resources_hg_relations rhgr, acl_resources res, acl_res_group_relations rgr " .
            "WHERE rhgr.acl_res_id = res.acl_res_id " .
            "AND res.acl_res_id = rgr.acl_res_id " .
            "AND rgr.acl_group_id = '" . $group_id . "' " .
            "AND hgr.hostgroup_hg_id = rhgr.hg_hg_id " .
            "AND hgr.host_host_id = '" . $host_id . "' " .
            "AND res.acl_res_activate = '1' " .
            "AND hgr.host_host_id NOT IN (SELECT host_host_id FROM acl_resources_hostex_relations WHERE acl_res_id = rhgr.acl_res_id)";

    $DBRES2 = $pearDB->query($query2);
    if (PEAR::isError($DBRES2))
        print "DB Error : " . $DBRES2->getDebugInfo() . "<br />";
    if ($DBRES2->numRows())
        return true;

    return false;
}

/*
 * Retreive service description
 */

function getMyHostServicesByName($host_id = NULL) {
    global $pearDB, $hsRelation, $svcCache;

    if (!$host_id)
        return;

    $hSvs = array();
    if (isset($hsRelation[$host_id])) {
        foreach ($hsRelation[$host_id] as $service_id => $flag) {
            $service_description = str_replace('#S#', '/', $svcCache[$service_id]);
            $service_description = str_replace('#BS#', '\\', $service_description);
            $hSvs[$service_description] = html_entity_decode($service_id, ENT_QUOTES);
        }
    }
    return $hSvs;
}

/**
 * Get meta services
 * 
 * @param int $resId
 * @param CentreonDB $db
 * @param CentreonMeta $metaObj
 * @return array
 */
function getMetaServices($resId, $db, $metaObj) {
    $sql = "SELECT meta_id 
                FROM acl_resources_meta_relations
                WHERE acl_res_id = {$db->escape($resId)}";
    $res = $db->query($sql);
    $arr = array();
    if ($res->numRows()) {
        $hostId = $metaObj->getRealHostId();
        while ($row = $res->fetchRow()) {
            $svcId = $metaObj->getRealServiceId($row['meta_id']);
            $arr['_Module_Meta']['meta_' . $row['meta_id']] = "$hostId,$svcId";
        }
    }
    return $arr;
}

?>