Implement a random image block for the side bar. Ticket #13

5 files changed, 142 insertions, 0 deletions

diff --git a/modules/image_block/helpers/image_block_event.php b/modules/image_block/helpers/image_block_event.php
new file mode 100644
index 00000000..3bcabda1
--- /dev/null
+++ b/modules/image_block/helpers/image_block_event.php
@@ -0,0 +1,27 @@
+<?php defined("SYSPATH") or die("No direct script access.");
+/**
+ * Gallery - a web based photo album viewer and editor
+ * Copyright (C) 2000-2008 Bharat Mediratta
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or (at
+ * your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful, but
+ * WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA  02110-1301, USA.
+ */
+class image_block_event_Core {
+  static function item_created($item) {
+    $db = Database::instance();
+    $db->query("UPDATE `items` SET `rand_key` = RAND() WHERE id = {$item->id}");
+    Kohana::log("debug", Database::instance()->last_query());
+  }
+
+}
diff --git a/modules/image_block/helpers/image_block_installer.php b/modules/image_block/helpers/image_block_installer.php
new file mode 100644
index 00000000..6b0ec20b
--- /dev/null
+++ b/modules/image_block/helpers/image_block_installer.php
@@ -0,0 +1,42 @@
+<?php defined("SYSPATH") or die("No direct script access.");
+/**
+ * Gallery - a web based photo album viewer and editor
+ * Copyright (C) 2000-2008 Bharat Mediratta
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or (at
+ * your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful, but
+ * WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA  02110-1301, USA.
+ */
+class image_block_installer {
+  static function install() {
+    $db = Database::instance();
+    $version = module::get_version("image_block");
+    if ($version == 0) {
+      $db = Database::instance();
+      
+      $db->query("ALTER TABLE `items` ADD `rand_key` FLOAT DEFAULT NULL");
+      $db->query("UPDATE `items` SET `rand_key` = RAND()");
+      $db->query("CREATE INDEX `random_index` ON `items` (rand_key DESC)");
+
+      module::set_version("image_block", 1);
+    }
+  }
+
+  static function uninstall() {
+    $db = Database::instance();
+    // Dropping the column should drop the index as well.
+    $db->query("ALTER TABLE `items` DROP `rand_key`");
+
+    module::delete("image_block");
+  }
+}
diff --git a/modules/image_block/helpers/image_block_theme.php b/modules/image_block/helpers/image_block_theme.php
new file mode 100644
index 00000000..0a103add
--- /dev/null
+++ b/modules/image_block/helpers/image_block_theme.php
@@ -0,0 +1,64 @@
+<?php defined("SYSPATH") or die("No direct script access.");
+/**
+ * Gallery - a web based photo album viewer and editor
+ * Copyright (C) 2000-2008 Bharat Mediratta
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or (at
+ * your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful, but
+ * WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA  02110-1301, USA.
+ */
+class image_block_theme_Core {
+  static function sidebar_blocks($theme) {
+    $result = ORM::factory("item")
+      ->viewable()
+      ->select("COUNT(*) AS C")
+      ->find();
+    if (empty($result->C)) {
+      return "";
+    }
+
+    $block = new Block();
+    $block->css_id = "gImageBlock";
+    $block->title = t("Random Image");
+    $block->content = new View("image_block_block.html");
+
+    $result = ORM::factory("item")
+      ->viewable()
+      ->select("MAX(rand_key) AS max_random")
+      ->find();
+
+    $max_rand = $result->max_random;
+    $random = ((float)mt_rand()) / (float)mt_getrandmax();
+
+    $items = ORM::factory("item")
+      ->viewable()
+      ->where("type !=", "album")
+      ->where("rand_key < ", $max_rand * $random)
+      ->orderby(array("rand_key" => "DESC"))
+      ->find_all(1);
+
+    if ($items->count() == 0) {
+      $items = ORM::factory("item")
+        ->viewable()
+        ->where("type !=", "album")
+        ->where("rand_key > ", $max_rand * $random)
+        ->orderby(array("rand_key" => "DESC"))
+        ->find_all(1);
+     
+    }
+ 
+    $block->content->item = $items->current();
+
+    return $items->count() == 0 ? "" : $block;
+  }
+}
diff --git a/modules/image_block/module.info b/modules/image_block/module.info
new file mode 100644
index 00000000..8852d33c
--- /dev/null
+++ b/modules/image_block/module.info
@@ -0,0 +1,3 @@
+name = Image Block
+description = Display a random image in the sidebar
+version = 1
diff --git a/modules/image_block/views/image_block_block.html.php b/modules/image_block/views/image_block_block.html.php
new file mode 100644
index 00000000..87afe4da
--- /dev/null
+++ b/modules/image_block/views/image_block_block.html.php
@@ -0,0 +1,6 @@
+<?php defined("SYSPATH") or die("No direct script access.") ?>
+<div class="gItem">
+  <a href="<?= $item->thumb_url() ?>">
+   <?= $item->thumb_tag(array("class" => "gThumbnail")) ?>
+  </a>
+</div>