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

Timestamp:

06/06/10 02:16:31 (2 years ago)

Author:

ort

Message:

доработка плагина Page - появилась сортировка и вывод на главную

Files:

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

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

@@ -28 +28 @@
                         page_seo_keywords,
                         page_seo_description,
-                        page_active                     
+                        page_active,                    
+                        page_main,                      
+                        page_sort                       
                         )
-                        VALUES(?, ?,    ?,      ?,  ?,  ?,  ?,  ?,  ?d)
+                        VALUES(?, ?,    ?,      ?,  ?,  ?,  ?,  ?,  ?d,  ?d,  ?d)
                 ";                      
-                if ($iId=$this->oDb->query($sql,$oPage->getPid(),$oPage->getUrl(),$oPage->getUrlFull(),$oPage->getTitle(),$oPage->getText(),$oPage->getDateAdd(),$oPage->getSeoKeywords(),$oPage->getSeoDescription(),$oPage->getActive())) 
+                if ($iId=$this->oDb->query($sql,$oPage->getPid(),$oPage->getUrl(),$oPage->getUrlFull(),$oPage->getTitle(),$oPage->getText(),$oPage->getDateAdd(),$oPage->getSeoKeywords(),$oPage->getSeoDescription(),$oPage->getActive(),$oPage->getMain(),$oPage->getSort())) 
                 {
                         return $iId;
@@ -49 +51 @@
                         page_seo_keywords = ? ,
                         page_seo_description = ? ,
-                        page_active      = ?            
+                        page_active      = ?,           
+                        page_main        = ?,           
+                        page_sort        = ?            
                         WHERE page_id = ?d
                 ";                      
-                if ($this->oDb->query($sql,$oPage->getPid(),$oPage->getUrl(),$oPage->getUrlFull(),$oPage->getTitle(),$oPage->getText(),$oPage->getDateEdit(),$oPage->getSeoKeywords(),$oPage->getSeoDescription(),$oPage->getActive(),$oPage->getId())) 
+                if ($this->oDb->query($sql,$oPage->getPid(),$oPage->getUrl(),$oPage->getUrlFull(),$oPage->getTitle(),$oPage->getText(),$oPage->getDateEdit(),$oPage->getSeoKeywords(),$oPage->getSeoDescription(),$oPage->getActive(),$oPage->getMain(),$oPage->getSort(),$oPage->getId())) 
                 {
                         return true;
@@ -103 +107 @@
                                 FROM 
                                         ".Config::Get('plugin.page.table.page')."                               
-                                ORDER by page_title asc;        
+                                ORDER by page_sort desc;        
                                         ";
                 if ($aRows=$this->oDb->select($sql)) {
@@ -134 +138 @@
                 return $aResult;
         }
+        
+        public function GetNextPageBySort($iSort,$sPid,$sWay) {
+                if ($sWay=='up') {
+                        $sWay='>';
+                        $sOrder='asc';
+                } else {
+                        $sWay='<';
+                        $sOrder='desc';
+                }
+                $sPidNULL='';
+                if (is_null($sPid)) {
+                        $sPidNULL='page_pid IS NULL and';
+                }
+                $sql = "SELECT * FROM ".Config::Get('plugin.page.table.page')." WHERE { page_pid = ? and } {$sPidNULL} page_sort {$sWay} ? order by page_sort {$sOrder} limit 0,1";
+                if ($aRow=$this->oDb->selectRow($sql,is_null($sPid) ? DBSIMPLE_SKIP : $sPid, $iSort)) {
+                        return Engine::GetEntity('PluginPage_Page',$aRow);
+                }
+                return null;
+        }
+        
+        public function GetMaxSortByPid($sPid) {
+                $sPidNULL='';
+                if (is_null($sPid)) {
+                        $sPidNULL='and page_pid IS NULL';
+                }
+                $sql = "SELECT max(page_sort) as max_sort FROM ".Config::Get('plugin.page.table.page')." WHERE 1=1 { and page_pid = ? } {$sPidNULL} ";
+                if ($aRow=$this->oDb->selectRow($sql,is_null($sPid) ? DBSIMPLE_SKIP : $sPid)) {
+                        return $aRow['max_sort'];
+                }
+                return null;
+        }
 }
 ?>