Changeset 727 for temp

Timestamp:

2006/12/11 22:40:09 (20 years ago)

Author:

uehara

Message:

 

Location:

temp/test-xoops.ec-cube.net/html/modules/xoopspoll

Files:

• class/xoopspolloption.php (modified) (1 diff)
• class/xoopspollrenderer.php (modified) (1 diff)
• pollregist.php (modified) (1 diff)

temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspolloption.php

@@ -120 +120 @@
 
     // public static
+    function &getAllCommentByOptionId($option_id)
+    {
+        $db =& Database::getInstance();
+        $ret = array();
+        $sql = "SELECT u.uid, u.uname, l.rating_id, l.comment FROM ".$db->prefix("xoopspoll_log")." l, ". $db->prefix("users") ." u WHERE l.user_id = u.uid AND l.option_id=".intval($option_id)." ORDER BY time DESC";
+        $result = $db->query($sql);
+        while ( $myrow = $db->fetchArray($result) ) {
+            $ret[] = new XoopsPollOption($myrow);
+        }
+        //echo $sql;
+        return $ret;
+    }
+    
+    
+    // public static
     function &getOptionByOptionId($option_id)
     {

temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspollrenderer.php

@@ -161 +161 @@
         $tpl->assign('option_list', $options_arr);
     }
+
+    function assignComment(&$tpl, $option_id)
+    {
+        $arrComment =& XoopsPollOption::getAllCommentByOptionId($option_id);
+        $tpl->assign('arrComment', $arrComment);
+    }
+
 }
 ?>

temp/test-xoops.ec-cube.net/html/modules/xoopspoll/pollregist.php

@@ -45 +45 @@
 $renderer = new XoopsPollRenderer();
 $renderer->assignOptions($xoopsTpl, $option_id);
+$renderer->assignComment($xoopsTpl, $option_id);
 
 $xoopsTpl->assign('arrStatus', $arrStatus);