Changeset 10259 for temp

Timestamp:

2006/12/06 09:22:14 (20 years ago)

Author:

kaki

Message:

 

Location:

temp/trunk

Files:

• data/class/SC_Query.php (modified) (1 diff)
• html/admin/products/index.php (modified) (2 diffs)

temp/trunk/data/class/SC_Query.php

@@ -121 +121 @@
     }
     
-    function setlimitoffset($limit, $offset = 0) {
+    function setlimitoffset($limit, $offset = 0, $return = false) {
         if (is_numeric($limit) && is_numeric($offset)){
-            $this->option.= " LIMIT " . $limit;
-            $this->option.= " OFFSET " . $offset;
+            
+            $option.= " LIMIT " . $limit;
+            $option.= " OFFSET " . $offset;
+            
+            if($return){
+                return $option;
+            }else{
+                $this->option.= $option;
+            }
         }
     }

temp/trunk/html/admin/products/index.php

@@ -262 +262 @@
 
             // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
-            $objQuery->setlimitoffset($page_max, $startno);
+            //$objQuery->setlimitoffset($page_max, $startno);
             // ɽ¼¨½ç½ø
             $objQuery->setorder($order);
@@ -275 +275 @@
                 $where_tmp .= sfQuoteSmart($arrval[$i - 1]) . $arrWhere[$i];
             }
-            $arrViewWhere["&&noncls_where&&"] = $where_tmp . " " . $objQuery->order . " " .  $objQuery->option; 
+            $arrViewWhere["&&noncls_where&&"] = $where_tmp . " " . $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true);
             
             sfprintr($objQuery->option);