function loadItems() { $items = array(); $contacts = $this->contact->getColumnsFromMySQL(array($this->contact->myKeyColumn, $this->contact->nameColumn), null, $this->contact->nameColumn); if (count($contacts)) { foreach ($contacts as $contact) { $items[$contact[$this->contact->myKeyColumn]] = $contact[$this->contact->nameColumn]; } } return $items; }
/** * Vrací jméno prvního kontaktu uživatele */ public function getFirstContact() { $contact = new IEContact(); $cn = $contact->getColumnsFromMySQL(array($contact->nameColumn, $contact->myKeyColumn), array($contact->userColumn => $this->getUserID(), 'parent_id' => 'IS NOT NULL'), $contact->myKeyColumn, $contact->nameColumn, 1); if (count($cn)) { $curcnt = current($cn); return array($curcnt[$contact->myKeyColumn] => $curcnt[$contact->nameColumn]); } return null; }
$tools = new EaseTWBPanel(_('Nástroje'), 'warning'); if ($command->getId()) { $tools->addItem($command->deleteButton()); $tools->addItem(new EaseTWBPanel(_('Transfer'), 'warning', $command->transferForm())); $service = new IEService(); $usages = $service->getColumnsFromMySQL(array($service->getMyKeyColumn(), $service->nameColumn), array('check_command' => $command->getName()), $service->nameColumn, $service->getMyKeyColumn()); if (count($usages)) { $usedBy = new EaseTWBPanel(_('Používající služby')); $listing = $usedBy->addItem(new EaseHtmlUlTag(null, array('class' => 'list-group'))); foreach ($usages as $usage) { $listing->addItem(new EaseHtmlLiTag(new EaseHtmlATag('service.php?service_id=' . $usage['service_id'], $usage[$service->nameColumn]), array('class' => 'list-group-item'))); } $infopanel->addItem($usedBy); } $contact = new IEContact(); $hostNotify = $contact->getColumnsFromMySQL(array($contact->getMyKeyColumn(), $contact->nameColumn), array('host_notification_commands' => '%' . $command->getName() . '%'), $contact->nameColumn, $contact->getMyKeyColumn()); $serviceNotify = $contact->getColumnsFromMySQL(array($contact->getMyKeyColumn(), $contact->nameColumn), array('service_notification_commands' => '%' . $command->getName() . '%'), $contact->nameColumn, $contact->getMyKeyColumn()); $usages = array_merge($hostNotify, $serviceNotify); if (count($usages)) { $usedBy = new EaseTWBPanel(_('Používající kontakty')); $listing = new EaseHtmlUlTag(null, array('class' => 'list-group')); foreach ($usages as $usage) { if (!isset($usage[$contact->nameColumn])) { $usage[$contact->nameColumn] = 'n/a'; } $listing->addItem(new EaseHtmlLiTag(new EaseHtmlATag('contact.php?contact_id=' . $usage['contact_id'], $usage[$contact->nameColumn]), array('class' => 'list-group-item'))); } EaseContainer::addItemCustom($listing, $usedBy); $infopanel->addItem($usedBy); } }