function loadItems() { $membersFound = array('' => '---'); $query = 'SELECT `hostgroup_id`, `hostgroup_name` FROM `' . 'hostgroup` WHERE (user_id=' . $this->user->getUserID() . ') ORDER BY hostgroup_name '; $membersFoundArray = EaseShared::myDbLink()->queryToArray($query); if (count($membersFoundArray)) { foreach ($membersFoundArray as $request) { $membersFound[$request['hostgroup_id']] = $request['hostgroup_name']; } } return $membersFound; }
/** * Editor k přidávání členů skupiny * * @param string $fieldName název políčka formuláře * @param string $fieldCaption popisek políčka * @param IEcfg $dataSource editovaný objekt */ public function __construct($fieldName, $fieldCaption, $dataSource, $members) { $iDColumn = $dataSource->keywordsInfo[$fieldName]['refdata']['idcolumn']; $nameColumn = $dataSource->keywordsInfo[$fieldName]['refdata']['captioncolumn']; $sTable = $dataSource->keywordsInfo[$fieldName]['refdata']['table']; if (isset($dataSource->keywordsInfo[$fieldName]['refdata']['condition'])) { $conditions = $dataSource->keywordsInfo[$fieldName]['refdata']['condition']; } else { $conditions = array(); } if (isset($dataSource->keywordsInfo[$fieldName]['refdata']['public']) && intval($dataSource->keywordsInfo[$fieldName]['refdata']['public'])) { $sqlConds = " ( " . $dataSource->myDbLink->prepSelect(array_merge($conditions, array($dataSource->userColumn => EaseShared::user()->getUserID()))) . " ) OR ( " . $dataSource->myDbLink->prepSelect(array_merge($conditions, array('public' => 1))) . ") "; } else { $sqlConds = $dataSource->myDbLink->prepSelect(array_merge($conditions, array($dataSource->userColumn => EaseShared::user()->getUserID()))); } $initialContent = new EaseTWBPanel($fieldCaption); $initialContent->setTagCss(array('width' => '100%')); if (is_null($dataSource->getMyKey())) { $initialContent->addItem(_('Nejprve je potřeba uložit záznam')); } else { if ($sTable == $dataSource->myTable) { $tmpKey = $dataSource->getMyKey(); if ($tmpKey) { $members[$tmpKey] = true; } } if ($members && count($members)) { $aviavbleCond = 'AND ' . $iDColumn . ' NOT IN (' . join(',', array_keys($members)) . ') '; } else { $aviavbleCond = ''; } $membersAviableArray = EaseShared::myDbLink()->queryToArray('SELECT ' . $nameColumn . ', ' . $iDColumn . ' ' . 'FROM `' . $sTable . '` ' . 'WHERE (' . $sqlConds . ') ' . $aviavbleCond . 'ORDER BY ' . $nameColumn, $iDColumn); if ($sTable == $dataSource->myTable) { unset($members[$dataSource->getMyKey()]); } $addText = _('Přiřadit'); $delText = _('Odebrat'); if (count($membersAviableArray)) { foreach ($membersAviableArray as $memberID => $memberName) { $reftable = $dataSource->keywordsInfo[$fieldName]['refdata']['table']; $initialContent->addItem(new EaseTWBButtonDropdown($memberName[$nameColumn], 'inverse', 'xs', array(new EaseHtmlATag($reftable . '.php?' . $reftable . '_id=' . $memberID, EaseTWBPart::GlyphIcon('wrench') . ' ' . _('Editace')), new EaseHtmlATag(null, EaseTWBPart::GlyphIcon('plus-sign') . ' ' . $addText, array('onClick' => "addGroupMember('" . get_class($dataSource) . "','" . $dataSource->getId() . "','" . $fieldName . "','" . $memberName[$nameColumn] . "','" . $memberID . "')", 'class' => 'handle', 'data-addtext' => $addText, 'data-deltext' => $delText))), array('id' => get_class($dataSource) . '_' . $fieldName . '_' . $memberID, 'style' => 'margin: 1px;'))); } } if ($members && count($members)) { $initialContent->addItem('</br>'); foreach ($members as $memberID => $memberName) { $reftable = $dataSource->keywordsInfo[$fieldName]['refdata']['table']; $initialContent->addItem(new EaseTWBButtonDropdown($memberName, 'success', 'xs', array(new EaseHtmlATag($reftable . '.php?' . $reftable . '_id=' . $memberID, EaseTWBPart::GlyphIcon('wrench') . ' ' . _('Editace')), new EaseHtmlATag(null, EaseTWBPart::GlyphIcon('remove') . ' ' . _('Odebrat'), array('onClick' => "delGroupMember('" . get_class($dataSource) . "','" . $dataSource->getId() . "','" . $fieldName . "','" . $memberName . "','" . $memberID . "')", 'class' => 'handle', 'data-addtext' => $addText, 'data-deltext' => $delText))), array('id' => get_class($dataSource) . '_' . $fieldName . '_' . $memberID, 'style' => 'margin: 1px;'))); } } } parent::__construct($initialContent); }
/** * Přejmenuje hosta * * @param string $oldname * @param string $newname */ public function renameHost($oldname, $newname) { $memberOf = EaseShared::myDbLink()->queryToArray('SELECT ' . $this->getmyKeyColumn() . ',' . $this->nameColumn . ' FROM ' . $this->myTable . ' WHERE members LIKE \'%"' . $oldname . '"%\' ', $this->getmyKeyColumn()); foreach ($memberOf as $groupID => $group) { $found = false; $this->loadFromMySQL($groupID); foreach ($this->data['members'] as $id => $member) { if ($member == $oldname) { $found = true; $this->data['members'][$id] = $newname; $this->addStatusMessage(sprintf(_(' %s byl přejmenován na %s ve skupině %s '), $oldname, $newname, $group[$this->nameColumn])); } } if ($found) { $this->saveToMySQL(); } } }
/** * Hlavní menu aplikace * * @param string $name * @param mixed $content * @param array $properties */ public function __construct($name = null, $content = null, $properties = null) { parent::__construct("Menu", new \Ease\Html\ImgTag('images/LinkQuickTwitterLogo.png', 'NetspotAdmin', 20, 20, ['class' => 'img-rounded']), ['class' => 'navbar-fixed-top']); $user = \Ease\Shared::user(); \Ease\TWB\Part::twBootstrapize(); if (!$user->getUserID()) { // $this->addMenuItem('<a href="createaccount.php">' . \Ease\TWB\Part::GlyphIcon('leaf') . ' ' . _('Register') . '</a>', 'right'); $this->addMenuItem(' <li class="divider-vertical"></li> <li class="dropdown"> <a class="dropdown-toggle" href="login.php" data-toggle="dropdown"><i class="icon-circle-arrow-left"></i> ' . _('Logon') . '<strong class="caret"></strong></a> <div class="dropdown-menu" style="padding: 15px; padding-bottom: 0px; left: -120px;"> <form method="post" class="navbar-form navbar-left" action="login.php" accept-charset="UTF-8"> <input class="form-control" style="margin-bottom: 15px;" type="text" placeholder="' . _('Username') . '" id="username" name="login"> <input class="form-control" style="margin-bottom: 15px;" type="password" placeholder="' . _('Password') . '" id="password" name="password"> <!-- input style="float: left; margin-right: 10px;" type="checkbox" name="remember-me" id="remember-me" value="1"> <label class="string optional" for="remember-me"> ' . _('zapamatuj si mne') . '</label --> <input class="btn btn-primary btn-block" type="submit" id="sign-in" value="' . _('Log in') . '"> </form> </div>', 'right'); } else { $userID = EaseShared::user()->getUserID(); if ($userID) { $myLinksCount = EaseShared::myDbLink()->queryToValue('SELECT COUNT(*) FROM entry WHERE owner=' . $userID); } else { $myLinksCount = EaseShared::myDbLink()->queryToValue('SELECT COUNT(*) FROM entry'); } $brand = new \Ease\HtmlDivTag('sitelogo', $myLinksCount, ['class' => 'brand']); $this->addMenuItem($brand); $userMenu = '<li class="dropdown" style="width: 120px; text-align: right; background-image: url( ' . $user->getIcon() . ' ) ; background-repeat: no-repeat; background-position: left center; background-size: 40px 40px;"><a href="#" class="dropdown-toggle" data-toggle="dropdown">' . $user->getLogin() . ' <b class="caret"></b></a> <ul class="dropdown-menu" style="text-align: left; left: -60px;"> <li><a href="settings.php">' . \Ease\TWB\Part::GlyphIcon('wrench') . '<i class="icon-cog"></i> ' . _('Settings') . '</a></li> '; $this->addMenuItem($userMenu . ' <li><a href="http://v.s.cz/ease.php">' . \Ease\TWB\Part::GlyphIcon('envelope') . ' ' . _('Developer support') . '</a></li> <li class="divider"></li> <li><a href="logout.php">' . \Ease\TWB\Part::GlyphIcon('off') . ' ' . _('Logout') . '</a></li> </ul> </li> ', 'right'); } }
/** * Editor k přidávání členů skupiny * * @param IEHost $host */ public function __construct($host) { parent::__construct(); $fieldName = $host->getmyKeyColumn(); $initialContent = new EaseTWBPanel(_('rodiče hostu')); $addparentForm = $initialContent->addItem(new EaseTWBForm('addparent')); $addparentForm->addItem(new EaseTWBFormGroup(_('IP nebo Hostname'), new EaseHtmlInputTextTag('newparent'))); $addparentForm->addItem(new EaseHtmlInputHiddenTag($fieldName, $host->getId())); $addparentForm->addItem(new EaseTWSubmitButton(_('Přidat rodiče'), 'success')); $initialContent->setTagCss(array('width' => '100%')); if (is_null($host->getMyKey())) { $initialContent->addItem(_('Nejprve je potřeba uložit záznam')); } else { $allParents = $host->getListing(); unset($allParents[$host->getID()]); //Nenabízet sám sebe jako rodiče foreach ($allParents as $parentID => $parentInfo) { if ($parentInfo['register'] != 1) { unset($allParents[$parentID]); } } $parentsAssigned = array(); foreach ($host->getDataValue('parents') as $parentAssigned) { $parentID = EaseShared::myDbLink()->queryToValue('SELECT `' . $host->myKeyColumn . '` FROM ' . $host->myTable . ' WHERE `' . $host->nameColumn . '` = \'' . addSlashes($parentAssigned) . '\''); $parentsAssigned[$parentID][$host->nameColumn] = $parentAssigned; $parentsAssigned[$parentID][$host->myKeyColumn] = $parentID; unset($allParents[$parentID]); } if (count($allParents)) { foreach ($allParents as $parentID => $parentInfo) { $initialContent->addItem($this->parentButton($parentInfo, 'plus', $host)); } } if (count($parentsAssigned)) { $initialContent->addItem('</br>'); foreach ($parentsAssigned as $parentID => $parentInfo) { $initialContent->addItem($this->parentButton($parentInfo, 'remove', $host)); } } } $this->addItem($initialContent); }
function loadItems() { $membersFound = array('' => '---'); $query = 'SELECT `service_id`, `icon_image`,`platform`,`service_description` FROM `' . 'service` WHERE (user_id=' . $this->user->getUserID() . ' OR public=1) AND register=1 ORDER BY service_description '; $membersFoundArray = EaseShared::myDbLink()->queryToArray($query); if (count($membersFoundArray)) { foreach ($membersFoundArray as $request) { $membersFound[$request['service_id']] = $request['service_description']; if (isset($request['icon_image'])) { $icon = $request['icon_image']; } else { if (isset($request['platform']) && isset($this->platforms[$request['platform']])) { $icon = $this->platforms[$request['platform']]['image']; } else { $icon = 'logos/unknown.gif'; } } $this->services[$request['service_id']] = array('image' => $icon); } } return $membersFound; }
/** * Vloží do stránky widget pro editaci hodnoty * * @param EaseHtmlDivTag $fieldBlock * @param string $fieldName * @param mixed $value */ public function insertWidget($fieldBlock, $fieldName, $value) { $disabled = false; $hint = ''; $keywordInfo = $this->objectEdited->keywordsInfo[$fieldName]; $fieldType = $this->objectEdited->useKeywords[$fieldName]; $fType = preg_replace('/\\(.*\\)/', '', $fieldType); $required = isset($keywordInfo['requeired']) && $keywordInfo['requeired'] === true; if ($this->objectEdited->allowTemplating) { $effective = $this->objectEdited->getCfg($fieldName, true); $templateName = key($effective); $templateValue = current($effective); if ($fType == 'BOOL') { EaseShared::webPage()->addJavaScript("\$(\"#useTpl{$fieldName}\").change(function(){\n if( this.checked ){\n \$(\"[name='{$fieldName}']\").prop('disabled', true);\n \$(\"input[name='{$fieldName}']\").bootstrapSwitch('toggleDisabled', true);\n\n } else {\n \$(\"[name='{$fieldName}']\").prop('disabled', false);\n \$(\"input[name='{$fieldName}']\").bootstrapSwitch('toggleDisabled', false);\n }\n\n});", null, true); } else { EaseShared::webPage()->addJavaScript("\$(\"#useTpl{$fieldName}\").change(function(){\n if( this.checked ){\n \$(\"[name='{$fieldName}']\").prop('disabled', true);\n } else {\n \$(\"[name='{$fieldName}']\").prop('disabled', false);\n }\n\n});", null, true); } if ($templateName && !is_null($templateValue)) { $fieldBlock->addItem(new EaseHtmlCheckboxTag(null, true, 1, array('id' => 'useTpl' . $fieldName))); $hint = current($effective); $disabled = true; } else { $fieldBlock->addItem(new EaseHtmlCheckboxTag(null, false, 1, array('id' => 'useTpl' . $fieldName))); $hint = $value; } $fieldBlock->addItem(' ' . _('Hodnota z předlohy') . ':'); $fieldBlock->addItem(new EaseHtmlATag('search.php?search=' . key($effective), key($effective))); $fieldBlock->addItem(': ' . current($effective)); } if ($disabled) { EaseShared::webPage()->addJavaScript("\$(\"[name='{$fieldName}']\").prop('disabled', true);", null, true); } switch ($fType) { case 'INT': case 'STRING': case 'VARCHAR': //$fieldBlock->addItem($this->optionEnabler($fieldName)); if ($required) { $fieldBlock->addItem(new EaseTWBFormGroup($fieldName, new EaseHtmlInputTextTag($fieldName, $value, array('class' => 'required form-control', 'title' => $fieldName)), $hint, $keywordInfo['title'])); // $fieldBlock->addItem(new EaseHtmlDivTag(null, new EaseLabeledTextInput($fieldName, $value, $keywordInfo['title'], array('class' => 'required form-control', 'title' => $fieldName)))); } else { $fieldBlock->addItem(new EaseTWBFormGroup($fieldName, new EaseHtmlInputTextTag($fieldName, $value, array('title' => $fieldName, 'class' => 'form-control')), $hint, $keywordInfo['title'])); // $fieldBlock->addItem(new EaseLabeledTextInput($fieldName, $value, $keywordInfo['title'], array('title' => $fieldName, 'class' => 'form-control'))); } break; case 'TINYINT': case 'BOOL': $fieldBlock->addItem(new EaseTWBFormGroup($keywordInfo['title'], new IEYesNoSwitch($fieldName, $value, 'on', array('id' => $keywordInfo['title'] . 'sw')))); break; case 'FLAGS': $values = array(); $checkboxes = array(); $flags = explode(',', str_replace(array($fType, "'", '(', ')'), '', $fieldType)); foreach ($flags as $flag) { if (isset($keywordInfo[$flag])) { $checkboxes[$flag] = $keywordInfo[$flag]; } else { $this->addStatusMessage(_('Chybi definice') . ' ' . $fieldName . ' ' . $flag, 'error'); } } foreach ($checkboxes as $chKey => $chTopic) { $checkboxes[$chKey] = ' ' . $chTopic . '</br>'; if (strchr($value, $chKey)) { $values[$chKey] = true; } else { $values[$chKey] = false; } } $sliderField = $fieldBlock->addItem(new EaseTWBPanel($keywordInfo['title'], 'default', new EaseHtmlCheckboxGroup($fieldName, $checkboxes, $values))); $sliderField->setTagCss(array('width' => '100%')); break; case 'IDLIST': if (!is_array($value)) { $values = array(); } $fieldBlock->addItem(new IEGroupMembersEditor($fieldName, $keywordInfo['title'], $this->objectEdited, $value)); break; case 'SLIDER': $sliderField = $fieldBlock->addItem(new EaseTWBPanel($keywordInfo['title'], 'default', new EaseTWBSlider($fieldName, (int) $value, array('data-slider-min' => 0)))); $sliderField->setTagCss(array('width' => '100%')); break; case 'TEXT': $fieldBlock->addItem(new EaseTWBFormGroup($keywordInfo['title'], new EaseTWBTextarea($fieldName, $value, array('style' => 'width:100%')))); break; case 'ENUM': $flags = explode(',', str_replace(array($fType, "'", '(', ')'), '', $fieldType)); $selector = $fieldBlock->addItem(new EaseLabeledSelect($fieldName, $value, $keywordInfo['title'])); $selector->addItems(array_combine($flags, $flags)); $selector->enclosedElement->setTagCss(array('width' => '100%')); $selector->enclosedElement->setTagClass('form-control'); break; case 'PLATFORM': $fieldBlock->addItem(new EaseTWBFormGroup($keywordInfo['title'], new IEPlatformSelector($fieldName, null, $value))); break; case 'RADIO': $flags = explode(',', str_replace(array($fType, "'", '(', ')'), '', $fieldType)); if (is_array($flags)) { foreach (array_values($flags) as $flag) { $infoFlags[$flag] = ' ' . $keywordInfo[$flag]; } $buttons = new EaseHtmlRadiobuttonGroup($fieldName, $infoFlags); $buttons->setValue($value); $FB = $fieldBlock->addItem(new EaseTWBPanel($keywordInfo['title'], 'default', new EaseTWRadioButtonGroup($fieldName, $infoFlags, $value))); $FB->setTagCss(array('width' => '100%')); } break; case 'SELECT': $IDColumn = $keywordInfo['refdata']['idcolumn']; $nameColumn = $keywordInfo['refdata']['captioncolumn']; $sTable = $keywordInfo['refdata']['table']; if (isset($keywordInfo['refdata']['condition'])) { $conditions = $keywordInfo['refdata']['condition']; } else { $conditions = array(); } $sqlConds = " ( " . $this->objectEdited->myDbLink->prepSelect(array_merge($conditions, array($this->objectEdited->userColumn => EaseShared::user()->getUserID()))) . " ) OR ( " . $this->objectEdited->myDbLink->prepSelect(array_merge($conditions, array('public' => 1))) . ") "; $membersAviableArray = EaseShared::myDbLink()->queryTo2DArray('SELECT ' . $nameColumn . ' ' . 'FROM `' . $sTable . '` ' . 'WHERE ' . $sqlConds . ' ' . 'ORDER BY ' . $nameColumn, $IDColumn); $selector = $fieldBlock->addItem(new EaseLabeledSelect($fieldName, $value, $keywordInfo['title'])); $selector->enclosedElement->setTagClass('form-control'); if (!$required) { $selector->addItems(array('NULL' => _('Výchozí'))); } if (count($membersAviableArray)) { $selector->addItems(array_combine($membersAviableArray, $membersAviableArray)); } break; case 'SELECTID': $IDColumn = $keywordInfo['refdata']['idcolumn']; $nameColumn = $keywordInfo['refdata']['captioncolumn']; $sTable = $keywordInfo['refdata']['table']; if (isset($keywordInfo['refdata']['condition'])) { $conditions = $keywordInfo['refdata']['condition']; } else { $conditions = array(); } $sqlConds = " ( " . $this->objectEdited->myDbLink->prepSelect(array_merge($conditions, array($this->objectEdited->userColumn => EaseShared::user()->getUserID()))) . " ) OR ( " . $this->objectEdited->myDbLink->prepSelect(array_merge($conditions, array('public' => 1))) . ") "; $membersAviableArray = EaseShared::myDbLink()->queryToArray('SELECT ' . $nameColumn . ',' . $IDColumn . ' ' . 'FROM `' . $sTable . '` ' . 'WHERE ' . $sqlConds . ' ' . 'ORDER BY ' . $nameColumn, $IDColumn); $selector = $fieldBlock->addItem(new EaseLabeledSelect($fieldName, $value, $keywordInfo['title'])); $selector->enclosedElement->setTagClass('form-control'); if (!$required) { $selector->addItems(array('NULL' => _('Výchozí'))); } if (count($membersAviableArray)) { foreach ($membersAviableArray as $option) { $options[$option[$IDColumn]] = $option[$nameColumn]; } $selector->addItems($options); } break; case 'SELECT+PARAMS': $IDColumn = $keywordInfo['refdata']['idcolumn']; $nameColumn = $keywordInfo['refdata']['captioncolumn']; $sTable = $keywordInfo['refdata']['table']; if (isset($keywordInfo['refdata']['condition'])) { $conditions = $keywordInfo['refdata']['condition']; } else { $conditions = array(); } $conditions['command_type'] = 'check'; $sqlConds = " ( " . $this->objectEdited->myDbLink->prepSelect(array_merge($conditions, array('command_local' => true, $this->objectEdited->userColumn => EaseShared::user()->getUserID()))) . " ) OR ( " . $this->objectEdited->myDbLink->prepSelect($conditions) . " AND public=1 ) "; // $SqlConds = $this->ObjectEdited->myDbLink->prepSelect(array_merge($Conditions, array($this->ObjectEdited->userColumn => EaseShared::user()->getUserID()))); if (isset($this->objectEdited->keywordsInfo['platform'])) { $platform = $this->objectEdited->getDataValue('platform'); $sqlConds .= " AND ((`platform` = '" . $platform . "') OR (`platform` = 'generic') OR (`platform` IS NULL) OR (`platform`='') ) "; } $membersAviableArray = EaseShared::myDbLink()->queryTo2DArray('SELECT ' . $nameColumn . ' ' . 'FROM `' . $sTable . '` ' . 'WHERE ' . $sqlConds . ' ' . 'ORDER BY ' . $nameColumn, $IDColumn); $selector = $fieldBlock->addItem(new EaseLabeledSelect($fieldName, $value, $keywordInfo['title'])); $selector->enclosedElement->setTagClass('form-control'); if (!$required) { $selector->addItems(array('' => '')); } if (count($membersAviableArray)) { $selector->addItems(array_combine($membersAviableArray, $membersAviableArray)); } $sqlConds = " ( " . $this->objectEdited->myDbLink->prepSelect(array_merge($conditions, array('command_remote' => true, $this->objectEdited->userColumn => EaseShared::user()->getUserID()))) . " ) OR ( " . $this->objectEdited->myDbLink->prepSelect($conditions) . " AND public=1 ) "; // $SqlConds = $this->ObjectEdited->myDbLink->prepSelect(array_merge($Conditions, array($this->ObjectEdited->userColumn => EaseShared::user()->getUserID()))); $membersAviableArray = EaseShared::myDbLink()->queryTo2DArray('SELECT ' . $nameColumn . ' ' . 'FROM `' . $sTable . '` ' . 'WHERE ' . $sqlConds . ' ' . 'ORDER BY ' . $nameColumn, $IDColumn); $addNewItem = $fieldBlock->addItem(new EaseHtmlInputSearchTag($fieldName . '-remote', $this->objectEdited->getDataValue($fieldName . '-remote'), array('class' => 'search-input', 'title' => _('vzdálený test')))); $addNewItem->setDataSource('jsoncommand.php?maxRows=10'); $fieldBlock->addItem(new EaseLabeledTextInput($fieldName . '-params', $this->objectEdited->getDataValue($fieldName . '-params'), _('Parametry'), array('style' => 'width: 100%'))); break; case 'USER': $fieldBlock->addItem(new IEUserSelect($fieldName, null, $this->objectEdited->getDataValue($fieldName), null, array('style' => 'width: 100%'))); break; default: $fieldBlock->addItem(new EaseLabeledTextInput($fieldName, $value, $keywordInfo['title'], array('title' => $fieldName))); $this->addStatusMessage(sprintf(_('Neznámý typ %s pro sloupec %s'), $fType, $fieldName), 'warning'); break; } }
} break; case 'rename': $newname = $oPage->getRequestValue('newname'); if (strlen($newname)) { if ($host->rename($newname)) { $oUser->addStatusMessage(_('Host byl přejmenován'), 'success'); } else { $oUser->addStatusMessage(_('Host nebyl přejmenován'), 'warning'); } } break; case 'parent': $np = $oPage->getRequestValue('newparent'); if ($np) { $newParent = EaseShared::myDbLink()->queryToValue('SELECT `' . $host->nameColumn . '` FROM ' . $host->myTable . ' ' . 'WHERE `' . $host->nameColumn . '` = \'' . addSlashes($np) . '\' ' . 'OR `alias` = \'' . addSlashes($np) . '\' ' . 'OR `address` = \'' . addSlashes($np) . '\' ' . 'OR `address6` = \'' . addSlashes($np) . '\' '); if (!$newParent) { $oUser->addStatusMessage(_('Rodič nebyl nalezen'), 'warning'); $oPage->redirect('watchroute.php?action=parent&host_id=' . $host->getId() . '&ip=' . $np); exit; } else { $currentParents = $host->getDataValue('parents'); $currentParents[] = $newParent; $host->setDataValue('parents', $currentParents); $hostID = $host->saveToMySQL(); if (is_null($hostID)) { $oUser->addStatusMessage(_('Rodič nebyl přidán'), 'warning'); } else { $oUser->addStatusMessage(_('Rodič byl přidán'), 'success'); } }
if (!$oUser->GetUserID()) { die(_('nejprve se prosím přihlaš')); } header('Cache-Control: no-cache, must-revalidate'); header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); header('Content-type: application/json'); $request = $oPage->getRequestValue('term'); $platform = $oPage->getRequestValue('platform'); $source = $oPage->getRequestValue('source', 'array'); $limit = $oPage->getRequestValue('maxRows', 'int'); if ($limit) { $limit = 'LIMIT ' . $limit; } else { $limit = ''; } $membersFound = array(); if ($request) { if ($platform) { $sqlConds = " AND ((`platform` = '" . $platform . "') OR (`platform` = 'generic') OR (`platform` IS NULL) OR (`platform`='') ) "; } else { $sqlConds = ''; } $query = 'SELECT `command_name` FROM `command` WHERE command_type=\'check\' AND (user_id=' . $oUser->getUserID() . ' OR public=1) AND command_name LIKE \'%' . EaseShared::myDbLink()->AddSlashes($request) . '%\' ' . $sqlConds . ' ORDER BY command_name ' . $limit; $membersFoundArray = EaseShared::myDbLink()->queryToArray($query); if (count($membersFoundArray)) { foreach ($membersFoundArray as $request) { $membersFound[] = $request['command_name']; } } } echo json_encode($membersFound);
/** * Vrací jSon * @package IcingaEditor */ require_once 'includes/IEInit.php'; $oPage->onlyForLogged(); if (!$oUser->GetUserID()) { die(_('nejprve se prosím přihlaš')); } header('Cache-Control: no-cache, must-revalidate'); header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); header('Content-type: application/json'); $request = $oPage->getRequestValue('term'); $source = $oPage->getRequestValue('source', 'array'); $limit = $oPage->getRequestValue('maxRows', 'int'); if ($limit) { $limit = 'LIMIT ' . $limit; } else { $limit = ''; } $membersFound = array(); if ($request) { $membersFoundArray = EaseShared::myDbLink()->queryToArray('SELECT ' . current($source) . ' FROM `' . key($source) . '` WHERE user_id=' . $oUser->getUserID() . ' AND ' . current($source) . ' LIKE \'%' . EaseShared::myDbLink()->AddSlashes($request) . '%\' ORDER BY contact_name ' . $limit); if (count($membersFoundArray)) { foreach ($membersFoundArray as $request) { $membersFound[] = $request[current($source)]; } } } echo json_encode($membersFound);
} else { $check_email = EaseShared::myDbLink()->queryToValue("SELECT COUNT(*) AS total FROM user WHERE email = '" . $oPage->EaseAddSlashes($emailAddress) . "'"); if ($check_email > 0) { $error = true; $oUser->addStatusMessage(sprintf(_('Mailová adresa %s je již zaregistrována'), $emailAddress), 'warning'); } } } if (strlen($password) < 5) { $error = true; $oUser->addStatusMessage(_('heslo je příliš krátké'), 'warning'); } elseif ($password != $confirmation) { $error = true; $oUser->addStatusMessage(_('kontrola hesla nesouhlasí'), 'warning'); } $usedLogin = EaseShared::myDbLink()->QueryToValue('SELECT id FROM user WHERE login=\'' . $oPage->EaseAddSlashes($login) . '\''); if ($usedLogin) { $error = true; $oUser->addStatusMessage(sprintf(_('Zadané uživatelské jméno %s je již v databázi použito. Zvolte prosím jiné.'), $login), 'warning'); } if ($error == false) { $newOUser = new IEUser(); //TODO zde by se měly doplnit defaultní hodnoty z konfiguráku registry.php $newOUser->setData(array('email' => $emailAddress, 'parent' => (int) $customerParent, 'login' => $login, 'firstname' => $firstname, 'lastname' => $lastname)); $userID = $newOUser->insertToMySQL(); if (!is_null($userID)) { $newOUser->setMyKey($userID); $newOUser->passwordChange($password); if ($userID == 0) { $newOUser->setSettingValue('admin', TRUE); $oUser->addStatusMessage(_('Administrátirský účet byl vytvořen'), 'success');