Changeset 537

Timestamp:

05/20/08 20:43:23 (8 months ago)

Author:

aarkerio

Message:

Discussions

Location:

trunk/app

Files:

• controllers/discussions_controller.php (modified) (1 diff)
• controllers/news_controller.php (modified) (1 diff)
• models/discussion.php (modified) (2 diffs)
• models/news.php (modified) (2 diffs)
• models/theme.php (modified) (1 diff)
• views/discussions/admin_listing.ctp (modified) (2 diffs)
• views/news/view.ctp (modified) (4 diffs)
• webroot/img/themes (modified) (1 prop)

trunk/app/controllers/discussions_controller.php

@@ -125 +125 @@
    $this->layout    = 'admin';
 
-   $this->pageTitle = 'Comments on Blogs';
-      
+   $this->pageTitle = 'Comments on News';
+
+   $this->Discussion->bindModel(array('belongsTo'=> array('News' =>array('className'=> 'News', 'foreignKey'=> 'new_id' ))));   
+
    $conditions  = null;
+   
+   $fields = array('Discussion.id','News.id','News.title','Discussion.id','Discussion.comment', 'Discussion.created', 'Discussion.username', 'Discussion.user_id', 'Discussion.status');
 
-   $fields = array("Discussion.id", "News.title", "Discussion.id", "Discussion.comment", "Discussion.created", "Discussion.username", "Discussion.user_id");
-   $order           = "Discussion.id DESC";
-       
+   $order  = "Discussion.id DESC";
+   
+   $limit  = 50;     
+    
    $this->set('data', $this->Discussion->findAll($conditions, $fields, $order, $limit));
  }
  
- public function admin_edit($id)
+ public function admin_edit($id=null)
  {
-    if (empty($this->data["Discussion"]))
-    {
+    if (empty($this->data["Discussion"])):
+
         $this->layout = 'admin';
-        
-        $this->Discussion->poll_id = $id;
-              
-        $this->data = $this->Discussion->read();
-    }
-    else
-    {
+                      
+        $this->data = $this->Discussion->read(null, $id);
+   
+    else:
+
         $this->Sanitize = new Sanitize;
         
         $this->Sanitize->clean($this->data["Discussion"]);
         
-        if ($this->Discussion->save($this->data["Discussion"]))
-        {
-            $this->msgFlash('/polls/listing');
-        }
-    }
-}
+        if ($this->Discussion->save($this->data["Discussion"])):
+             $this->msgFlash('Disccusion saved', '/admin/discussions/listing');
+    endif;
+    endif;
+ }
 
- public function admin_delete($id)
+ // change status enabled/disabled actived
+ public function admin_change($discussion_id, $status)
+ { 
+     $this->data['Discussion']['status'] = ($status == 0 ) ? 1 : 0;
+     
+     $this->data['Discussion']['id']     = $discussion_id;
+     
+    if ($this->Discussion->save($this->data['Discussion'])):
+          $this->msgFlash('Discussio status changed', '/admin/discussions/listing');
+    endif;
+ }
+
+ public function admin_delete($discussion_id)
  {
     // deletes comment on database
-    $this->Discussion->del($id);
-    $this->msgFlash('Comment deleted', '/admin/commentnews/listing');
-  }
+   if ( $this->Discussion->del($discussion_id) ):
+        $this->msgFlash('Comment deleted', '/admin/discussions/listing');
+   endif;
+ }
 }
 ?>

trunk/app/controllers/news_controller.php

@@ -53 +53 @@
         
         $this->Portal->statics(); // Charge Portal components aka Sidebars
-    }
+ }
     
-    public function view($id = null)
-    {
-        if ($id == null)
-        {
+ public function view($new_id = null)
+ {
+  if ( $new_id == null || !intval($new_id) ):
             $this->redirect("/");
-        }
-        
-        $this->layout = 'portal';
-
-        $this->pageTitle = '::News';
-        
-        $conditions = array("News.status"=>1, "News.id"=>$id);
-        
-        $fields     = array("News.id", "News.title", "News.comments", "News.body", "News.created", "News.reference", "News.theme_id", "News.user_id", "Theme.img", "Theme.theme", "User.username");
-        
-        $this->set('data', $this->News->find($conditions, $fields, null, 2));
-        
-        $this->Portal->statics(); // Charge Portal components aka Sidebars
-    }
+  endif;
+        
+  $this->layout = 'portal';
+
+  $this->pageTitle = '::News';
+
+  $this->News->User->unbindAll();
+        
+  $conditions = array('News.status'=>1, 'News.id'=>$new_id);
+        
+  $fields     = array('News.id','News.title','News.comments', 'News.body', 'News.created', 'News.reference', 'News.theme_id', 'News.user_id', 'Theme.img', 'Theme.theme', 'User.username');
+        
+  $this->set('data', $this->News->find($conditions, $fields, null, 2));
+        
+  $this->Portal->statics(); // Charge Portal components aka Sidebars
+ }
   
     /**

trunk/app/models/discussion.php

@@ -11 +11 @@
   public $name = 'Discussion';
   
-  public $belongsTo = array('News' =>
+  /* public $belongsTo = array('News' =>
                          array('className'     => 'News',
                                'conditions'    => null,
@@ -21 +21 @@
                                'finderQuery'   => ''
                          )
-                  );
+                  ); */
 
   public $validate = array(

trunk/app/models/news.php

@@ -20 +20 @@
              'Theme' => array(
                              'className'    => 'Theme',    
-                             'foreignKey'   => 'theme_id'
+                             'foreignKey'   => 'theme_id' 
                               )
              );
@@ -26 +26 @@
   public $hasMany  = array(
              'Discussion' => array(
-                             'className'    => 'Discussion',
-                             'foreignKey'   => 'new_id'
-                               )
-             );
+                                   'className'    => 'Discussion',
+                                   'foreignKey'   => 'new_id',
+                                   'conditions'   => 'Discussion.status = 1'
+                                   )
+                         );
 
      public $validate = array(

trunk/app/models/theme.php

@@ -2 +2 @@
 /**
 *  Karamelo E-Learning Platform
-*  Manuel Montoya 2002-2007 
-*  Chipotle Software
-*  GPLv3 manuel<at>mononeurona.org
+*  Manuel Montoya 2002-2008 
+*  Chipotle Software tm
+*  GPLv3 manuel<ARROBA>mononeurona<PUNTO>org
 */ 
-class Theme extends AppModel
-{
+class Theme extends AppModel {
+
 public $name = 'Theme';
 
-public $hasMany  = array(
+ /* public $hasMany  = array(
              "News" => array(
                              "className"    => "News",
                              "foreignKey"   => "theme_id"
-                               ));
+                               )); */
 
 public $validate = array(

trunk/app/views/discussions/admin_listing.ctp

@@ -1 +1 @@
 <?php
-die(debug($data));
+//die(debug($data));
 echo $html->addCrumb('Control Tools', '/admin/news/start'); 
 echo $html->addCrumb('Comments', '/admin/comments/listing'); 
@@ -8 +8 @@
 
 foreach ($data as $val):
-   $tmp  = $html->link($val['Discussion']['title'], '/users/entry/'. $cU['User']['username'] . '/'.$val['Discussion']['id']) . '<br />';
-   $tmp .= $val['Comment']['created'].' <b>'.$val['Comment']['username'].' wrote:</b><br />';
-   $tmp .= $html->para(null, $val['Comment']['comment']);
-   $tmp .= $gags->confirmDel($val['Comment']['id'], 'Comment');
-   echo $html->div(null, $tmp);
+   $st   = ( $val['Discussion']['status'] == 1 ) ? 'Published' : 'Non published'; 
+   $tmp  = $html->link($val['News']['title'], '/news/view/'.$val['News']['id']) . '<br />';
+   $tmp .= $val['Discussion']['created'].' <b>'.$val['Discussion']['username'].' wrote:</b><br />';
+   $tmp .= $html->para(null, $val['Discussion']['comment']);
+   $tmp .= $html->para(null, $html->link($st, '/admin/discussions/change/'.$val['Discussion']['id'].'/'.$val['Discussion']['status']));
+   $tmp .= $gags->confirmDel($val['Discussion']['id'], 'Discussion');
+   echo $html->div('grayblock', $tmp);
 endforeach;
 ?>
-

trunk/app/views/news/view.ctp

@@ -1 +1 @@
 <?php
+// die(debug($data));
 echo $html->div('titnew', $data['News']['title']);
 
@@ -8 +9 @@
 <?php
 
-echo $html->div('img_new', $html->link(
+ echo $html->div('img_new', $html->link(
                         $html->image('themes/'.$data['Theme']['img'], 
                             array("alt"=>$data['Theme']['theme'], "title"=>$data['Theme']['theme'], "class"=>"themes")), 
@@ -14 +15 @@
                     null, null, false));
  
-    echo $data['News']['body']; 
+ echo $data['News']['body']; 
 ?>
     
@@ -43 +44 @@
   foreach($data['Discussion'] as $v)
   {
-      $bg = ($i%2==0) ? "#e2e2e2" : "#fff";
-              
-      echo '<div class="comentnew" style="background-color:'.$bg.'">';  
-      echo $time->timeAgoInWords($v['created']) . ' <b>'. $v['username']    . '</b> wrote:<br />';
-      echo $v["comment"];
-      echo "</div>";
+      $bg = ($i%2 == 0) ? "#e2e2e2" : "#fff";
+          
+      $tmp  = $html->para(null,$time->timeAgoInWords($v['created']) . ' <b>'. $v['username']    . '</b> wrote:<br />', array('style'=>'font-size:8pt;font-family:Georgia;'));
+      $tmp .= $html->para(null, $v['comment']);
+      echo $html->div('divblock', $tmp, array('style'=>'background-color:'.$bg)); 
       $i++;
   }