From f87e1de3ec0b199a48818f84bdef4cdf34b50244 Mon Sep 17 00:00:00 2001 From: Tim Almdal Date: Thu, 26 Feb 2009 15:02:04 +0000 Subject: Implement a random image block for the side bar. Ticket #13 --- modules/image_block/helpers/image_block_theme.php | 64 +++++++++++++++++++++++ 1 file changed, 64 insertions(+) create mode 100644 modules/image_block/helpers/image_block_theme.php (limited to 'modules/image_block/helpers/image_block_theme.php') 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 @@ +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; + } +} -- cgit v1.2.3