/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getList($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR", $tablesString = null, $staticFilter = null, $aAddFilters = array(), $aGroup = array()) { if (is_null($staticFilter)) { $staticFilter = "user_id IS NULL"; } return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType, $tablesString, $staticFilter, $aAddFilters, ""); }
/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getListBySearch($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR") { $aAddFilters = array(); $tablesString = null; $aGroup = array(); if (isset($filters['fullname']) && !empty($filters['fullname'])) { $filters['CONCAT(firstname," ",lastname)'] = $filters['fullname']; unset($filters['fullname']); } return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType, $tablesString, null, $aAddFilters, $aGroup); }
/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getList($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR") { $aAddFilters = array(); $aGroup = array(); if (array('tagname', array_values($filters)) && !empty($filters['tagname'])) { $aAddFilters = array('tables' => array('cfg_tags', 'cfg_tags_contacts'), 'join' => array('cfg_tags.tag_id = cfg_tags_contacts.tag_id', 'cfg_tags_contacts.resource_id = cfg_contacts.contact_id ')); } if (isset($filters['tagname']) && count($filters['tagname']) > 1) { $aGroup = array('sField' => 'cfg_tags_contacts.resource_id', 'nb' => count($filters['tagname'])); } return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType, null, null, $aAddFilters, $aGroup); }
/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getList($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR", $tablesString = null, $staticFilter = null, $aAddFilters = array(), $aGroup = array()) { $filters['host_register'] = '0'; return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType, null, null, $aAddFilters, $aGroup); }
/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getListBySearch($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR") { $filters['s.enabled'] = '1'; $aAddFilters = array(); $tablesString = null; $aGroup = array(); if (array('tagname', array_values($filters)) && !empty($filters['tagname'])) { $aAddFilters['tables'][] = 'cfg_tags'; $aAddFilters['join'][] = 'cfg_tags.tag_id = cfg_tags_services.tag_id'; $aAddFilters['tables'][] = 'cfg_tags_services'; $aAddFilters['join'][] = 'cfg_tags_services.resource_id = s.service_id'; } if (isset($filters['tagname']) && count($filters['tagname']) > 1) { $aGroup = array('sField' => 'cfg_tags_services.resource_id', 'nb' => count($filters['tagname'])); } if (isset($filters['host_id']) && !empty($filters['host_id'])) { $aAddFilters['tables'][] = 'rt_hosts'; $aAddFilters['join'][] = 'rt_hosts.host_id = s.host_id'; } if (isset($filters['state'])) { $filters['s.state'] = $filters['state']; unset($filters['state']); } if (isset($filters['host_id'])) { $filters['name'] = $filters['host_id']; unset($filters['host_id']); } return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType, $tablesString, null, $aAddFilters, $aGroup); }
/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getList($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR", $tablesString = null, $staticFilter = null, $aAddFilters = array(), $aGroup = array()) { $filters['host_register'] = '1'; if (is_array($filterType)) { $filterType['host_register'] = 'AND'; } else { $filterType = array('*' => $filterType, 'host_register' => 'AND'); } return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType, null, null, $aAddFilters, $aGroup); }
/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getList($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR") { $aAddFilters = array(); $aGroup = array(); $filters['service_register'] = '0'; if (is_array($filterType)) { $filterType['service_register'] = 'AND'; } else { $filterType = array('*' => $filterType, 'service_register' => 'AND'); } if (array('tagname', array_values($filters)) && !empty($filters['tagname'])) { $aAddFilters = array('tables' => array('cfg_tags', 'cfg_tags_services'), 'join' => array('cfg_tags.tag_id = cfg_tags_services.tag_id', 'cfg_tags_services.resource_id=cfg_services.service_id ')); } if (isset($filters['tagname']) && count($filters['tagname']) > 1) { $aGroup = array('sField' => 'cfg_tags_services.resource_id', 'nb' => count($filters['tagname'])); } return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType, null, null, $aAddFilters, $aGroup); }
/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getListBySearch($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR") { $aAddFilters = array(); $tablesString = null; $aGroup = array(); if ($parameterNames != '*' && $count != -1) { $aParam = explode(",", $parameterNames); $aParam = array_diff($aParam, array('')); $aParam = array_map("self::concatNameTable", $aParam); $parameterNames = implode(",", $aParam); } // Add join on node table if (isset($filters['ip_address']) && !empty($filters['ip_address'])) { $aAddFilters['tables'][] = 'cfg_nodes n'; $aAddFilters['join'][] = static::$table . '.node_id = n.node_id'; } // Add join on instance table if (isset($filters['running']) && !empty($filters['running']) || isset($filters['version']) && !empty($filters['version'])) { $aAddFilters['tables'][] = 'rt_instances i'; $aAddFilters['join'][] = static::$table . '.name = i.name'; } // Avoid error on ambiguous column if (isset($filters['name'])) { $sField = static::$table . '.name'; $filters[$sField] = $filters['name']; unset($filters['name']); } // Avoid error on ambiguous column if (isset($filters['enable'])) { $sField = static::$table . '.enable'; $filters[$sField] = $filters['enable']; unset($filters['enable']); } return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType, $tablesString, null, $aAddFilters, $aGroup); }
/** * * @param type $parameterNames * @param type $count * @param type $offset * @param type $order * @param type $sort * @param array $filters * @param type $filterType * @return type */ public static function getList($parameterNames = "*", $count = -1, $offset = 0, $order = null, $sort = "ASC", $filters = array(), $filterType = "OR") { $filters['activate'] = '1'; $filters['current_status'] = array('0', '1', '2'); return parent::getList($parameterNames, $count, $offset, $order, $sort, $filters, $filterType); }