Esempio n. 1
0
 public function store()
 {
     if ($this->getEventNotificationId() != 0) {
         try {
             $stmt = DB::getInstance()->prepare("UPDATE event_notifications SET\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tuser_id = ?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tupdate_date = NOW(),\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\taction = ?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tobject = ?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tnotify = ?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tnotified = ?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tnotification_date = FROM_UNIXTIME(?)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE id=?");
             $stmt->execute(array($this->getUserId(), $this->getAction(), $this->getObject(), $this->getNotify(), $this->getNotified(), $this->getNotificationDate(), $this->getEventNotificationId()));
             return $stmt->rowCount();
         } catch (PDOException $e) {
             echo $e->getMessage();
             echo $e->getTraceAsString();
         }
     } elseif ($this->getUserId() != 0 and $this->getAction() != "") {
         //check if there already exists an event for the given action, object and user_id
         $event_notification = new EventNotification(false, $this->getUserId(), $this->getAction(), $this->getObject());
         if (!$event_notification->fetch()) {
             try {
                 $stmt = DB::getInstance()->prepare("INSERT INTO event_notifications (user_id, create_date, update_date, action, object, notify, notified, notification_date)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (?, NOW(), NOW(), ?, ?, ?, ?, ?)");
                 $stmt->execute(array($this->getUserId(), $this->getAction(), $this->getObject(), $this->getNotify(), $this->getNotified(), $this->getNotificationDate()));
                 return DB::getInstance()->lastInsertId();
             } catch (PDOException $e) {
                 echo $e->getMessage();
                 echo $e->getTraceAsString();
             }
         }
     }
     return false;
 }
 public function __construct($user_id = false, $action = false, $object = false, $notify = false, $notified = false, $offset = false, $limit = false, $sort_by = false, $order = false)
 {
     $result = array();
     if ($offset !== false) {
         $this->setOffset((int) $offset);
     }
     if ($limit !== false) {
         $this->setLimit((int) $limit);
     }
     if ($sort_by !== false) {
         $this->setSortBy($sort_by);
     }
     if ($order !== false) {
         $this->SetOrder($order);
     }
     // initialize $total_count with the total number of objects in the list (over all pages)
     try {
         $stmt = DB::getInstance()->prepare("SELECT COUNT(*) as total_count\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM event_notifications\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(user_id = :user_id OR :user_id=0) AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(action = :action OR :action='') AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(object = :object OR :object=0) AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(notify = :notify OR :notify=0) AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(notified = :notified OR :notified=0)");
         $stmt->bindParam(':user_id', $user_id, PDO::PARAM_INT);
         $stmt->bindParam(':action', $action, PDO::PARAM_STR);
         $stmt->bindParam(':object', $object, PDO::PARAM_INT);
         $stmt->bindParam(':notify', $notify, PDO::PARAM_INT);
         $stmt->bindParam(':notified', $notified, PDO::PARAM_INT);
         $stmt->execute();
         $total_count = $stmt->fetch(PDO::FETCH_ASSOC);
     } catch (PDOException $e) {
         echo $e->getMessage();
         echo $e->getTraceAsString();
     }
     $this->setTotalCount((int) $total_count['total_count']);
     //if limit -1 then get all ressource records
     if ($this->getLimit() == -1) {
         $this->setLimit($this->getTotalCount());
     }
     try {
         $stmt = DB::getInstance()->prepare("SELECT event_notifications.id as event_notification_id, event_notifications.*\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM event_notifications\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(user_id = :user_id OR :user_id=0) AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(action = :action OR :action='') AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(object = :object OR :object=0) AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(notify = :notify OR :notify=0) AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(notified = :notified OR :notified=0)\n\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcase :sort_by\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\twhen 'event_notification_id' then event_notifications.id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\telse NULL\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tend\n\t\t\t\t\t\t\t\t\t\t\t\t\t" . $this->getOrder() . "\n\t\t\t\t\t\t\t\t\t\t\t\t\tLIMIT :offset, :limit");
         $stmt->bindParam(':user_id', $user_id, PDO::PARAM_INT);
         $stmt->bindParam(':action', $action, PDO::PARAM_STR);
         $stmt->bindParam(':object', $object, PDO::PARAM_INT);
         $stmt->bindParam(':notify', $notify, PDO::PARAM_INT);
         $stmt->bindParam(':notified', $notified, PDO::PARAM_INT);
         $stmt->bindParam(':offset', $this->getOffset(), PDO::PARAM_INT);
         $stmt->bindParam(':limit', $this->getLimit(), PDO::PARAM_INT);
         $stmt->bindParam(':sort_by', $this->getSortBy(), PDO::PARAM_STR);
         $stmt->execute();
         $resultset = $stmt->fetchAll(PDO::FETCH_ASSOC);
     } catch (PDOException $e) {
         echo $e->getMessage();
         echo $e->getTraceAsString();
     }
     foreach ($resultset as $item) {
         $event_notification = new EventNotification((int) $item['event_notification_id']);
         $event_notification->fetch();
         $this->event_notification_list[] = $event_notification;
     }
 }
 /**
  * Poll stdin for Supervisord notifications and dispatch notifications to
  * the callback function which should accept this object (EventListener) as
  * its first parameter and an EventNotification as its second.  The callback
  * should return TRUE if it was successful, FALSE on failure, or 'quit' to
  * break from the event listener loop.
  *
  * @param Closure|array Closure callback
  */
 public function listen($callback)
 {
     $this->sendReady();
     while (true) {
         if (!($input = trim($this->readLine()))) {
             continue;
         }
         $headers = EventNotification::parseData($input);
         $payload = fread($this->inputStream, (int) $headers['len']);
         $notification = new EventNotification($input, $payload, $headers);
         $result = call_user_func($callback, $this, $notification);
         if (true === $result) {
             $this->sendComplete();
         } else {
             if (false === $result) {
                 $this->sendFail();
             } else {
                 if ($result == 'quit') {
                     break;
                 }
             }
         }
         $this->sendReady();
     }
 }
 /**
  * Poll stdin for Supervisord notifications and dispatch notifications to
  * the callback function which should accept this object (EventListener) as
  * its first parameter and an EventNotification as its second.  The callback
  * should return TRUE if it was successful, FALSE on failure, or 'quit' to
  * break from the event listener loop.
  *
  * @param Closure|array Closure callback
  */
 public function listen($callback)
 {
     $this->sendReady();
     while (true) {
         if (!($input = trim($this->readLine()))) {
             continue;
         }
         $headers = EventNotification::parseData($input);
         // PHP 5.6 doesn't deal gracefully with this causing a buffer overflow
         $payload = '';
         if (isset($headers['len'])) {
             $payload = fread($this->inputStream, (int) $headers['len']);
         }
         $notification = new EventNotification($input, $payload, $headers);
         $result = call_user_func($callback, $this, $notification);
         if (true === $result) {
             $this->sendComplete();
         } else {
             if (false === $result) {
                 $this->sendFail();
             } else {
                 if ($result == 'quit') {
                     break;
                 }
             }
         }
         $this->sendReady();
     }
 }
Esempio n. 5
0
        header('Location: ./event_notifications.php');
    } else {
        Permission::denyAccess(PERM_ROOT, $event_notification->getUserId());
    }
} elseif (empty($_POST)) {
    if (Permission::checkPermission(PERM_USER)) {
        $routerlist = new Routerlist(false, false, false, false, false, false, false, false, 0, -1);
        $routerlist->sort("hostname", "asc");
        $smarty->assign('routerlist', $routerlist->getRouterlist());
        $event_notification_list = new EventNotificationList($_SESSION['user_id']);
        $smarty->assign('event_notification_list', $event_notification_list->getEventNotificationList());
        $smarty->display("header.tpl.html");
        $smarty->display("event_notifications.tpl.html");
        $smarty->display("footer.tpl.html");
    } else {
        Permission::denyAccess(PERM_USER);
    }
} else {
    if (Permission::checkPermission(PERM_USER)) {
        $event_notification = new EventNotification(false, (int) $_SESSION['user_id'], $_POST['action'], (int) $_POST['object'], true);
        if ($event_notification->store()) {
            $message[] = array('Die Benachrichtigung wurde eingetragen.', 1);
        } else {
            $message[] = array('Die Benachrichtigung konnte nicht eingetragen werden.', 2);
        }
        Message::setMessage($message);
        header('Location: ./event_notifications.php');
    } else {
        Permission::denyAccess(PERM_USER);
    }
}