Changeset 935 for trunk/plugins/page/classes/modules/page/mapper/Page.mapper.class.php

Timestamp:

06/06/10 14:41:17 (2 years ago)

Author:

ort

Message:

доработка плагина Page

Files:

• trunk/plugins/page/classes/modules/page/mapper/Page.mapper.class.php (modified) (2 diffs)

trunk/plugins/page/classes/modules/page/mapper/Page.mapper.class.php

@@ -100 +100 @@
         }
         
-        public function GetPages() {
+        public function GetPages($aFilter) {
+                $sPidNULL='';
+                if (array_key_exists('pid',$aFilter) and is_null($aFilter['pid'])) {
+                        $sPidNULL='and page_pid IS NULL';
+                }
                 $sql = "SELECT 
                                         *,                                      
@@ -106 +110 @@
                                         page_pid as PARENT_KEY
                                 FROM 
-                                        ".Config::Get('plugin.page.table.page')."                               
+                                        ".Config::Get('plugin.page.table.page')." 
+                                WHERE 
+                                        1=1
+                                        { and page_active = ?d }                                        
+                                        { and page_main = ?d }  
+                                        { and page_pid = ? } {$sPidNULL}                                
                                 ORDER by page_sort desc;        
                                         ";
-                if ($aRows=$this->oDb->select($sql)) {
+                if ($aRows=$this->oDb->select($sql,
+                                isset($aFilter['main']) ? $aFilter['main']:DBSIMPLE_SKIP,
+                                isset($aFilter['active']) ? $aFilter['active']:DBSIMPLE_SKIP,
+                                (array_key_exists('pid',$aFilter) and !is_null($aFilter['pid'])) ? $sPid : DBSIMPLE_SKIP
+                                )) {
                         return $aRows;
                 }