/**
       * Content::getProjects()
       *
       * @return
       */
      public function getProjects()
      {
          $sort = sanitize(get('sort'));
          $access = '';
          $order = '';
          if (Registry::get("Users")->userlevel == 5) {
              $extra = ($sort) ? "AND" : "WHERE";
              $access = "$extra pp.staff_id='" . Registry::get("Users")->uid . "'";
              $counter = countEntries("permissions", "staff_id", Registry::get("Users")->uid);
          } else {
              $counter = countEntries("projects");
          }

          $pager = Paginator::instance();
          $pager->items_total = $counter;
          $pager->default_ipp = Registry::get("Core")->perpage;
          $pager->paginate();

          ($sort) ? $order = "WHERE p.client_id = '" . (int)$sort . "'" : null;

          $sql = "SELECT p.id as pid, p.title, p.p_status, p.b_status, p.cost, p.start_date, u.id as uid,"
		  . "\n CONCAT(u.fname,' ',u.lname) as clientname,"
		  . "\n DATE_FORMAT(p.start_date, '" . Registry::get("Core")->short_date . "') as start,"
		  . "\n (SELECT CONCAT(fname,' ',lname) FROM users WHERE id = p.staff_id) as staffname, i.recurring"
		  . "\n FROM projects as p"
		  . "\n LEFT JOIN users as u ON u.id = p.client_id"
		  . "\n LEFT JOIN permissions as pp ON pp.project_id = p.id"
		  . "\n LEFT JOIN invoices as i ON i.project_id = p.id"
		  . "\n $order $access"
		  . "\n GROUP BY p.id ORDER BY p.start_date DESC" . $pager->limit;
          $row = self::$db->fetch_all($sql);

          return ($row) ? $row : 0;
      }