Changeset 3423:e34ec8af1a67 for inc

Timestamp:

11/26/16 11:53:12 (9 years ago)

Author:

Jean-Christian Denis

Branch:

default

Message:

Add First Publication mecanism, closes #970, adresses #784, #843, #871, #548

Location:

inc

Files:

• core/class.dc.blog.php (modified) (7 diffs)
• dbschema/db-schema.php (modified) (1 diff)
• dbschema/upgrade.php (modified) (1 diff)

inc/core/class.dc.blog.php

@@ -832 +832 @@
                'post_tz, post_creadt, post_upddt, post_format, post_password, '.
                'post_url, post_lang, post_title, '.$content_req.
-               'post_type, post_meta, post_status, post_selected, post_position, '.
+               'post_type, post_meta, '.
+               'post_status, post_firstpub, post_selected, post_position, '.
                'post_open_comment, post_open_tb, nb_comment, nb_trackback, '.
                'U.user_name, U.user_firstname, U.user_displayname, U.user_email, '.
@@ -928 +929 @@
           if (isset($params['post_status'])) {
                $strReq .= 'AND post_status = '.(integer) $params['post_status'].' ';
+          }
+
+          if (isset($params['post_firstpub'])) {
+               $strReq .= 'AND post_firstpub = '.(integer) $params['post_firstpub'].' ';
           }
 
@@ -1319 +1324 @@
           $this->triggerBlog();
 
+          $this->firstPublicationEntries($cur->post_id);
+
           return $cur->post_id;
      }
@@ -1379 +1386 @@
 
           $this->triggerBlog();
+
+          $this->firstPublicationEntries($id);
      }
 
@@ -1423 +1432 @@
           $cur->update($strReq);
           $this->triggerBlog();
+
+          $this->firstPublicationEntries($posts_ids);
      }
 
@@ -1628 +1639 @@
                # --BEHAVIOR-- coreAfterScheduledEntriesPublish
                $this->core->callBehavior('coreAfterScheduledEntriesPublish',$this,$to_change);
-          }
-
+
+               $this->firstPublicationEntries($to_change);
+          }
+     }
+
+     /**
+     First publication mecanism (on post create, update, publish, status)
+
+     @param    ids       <b>mixed</b>        Post(s) ID(s)
+     */
+     public function firstPublicationEntries($ids)
+     {
+          $posts = $this->getPosts(array(
+               'post_id' => dcUtils::cleanIds($ids),
+               'post_status' => 1,
+               'post_firstpub' => 0
+          ));
+
+          $to_change = array();
+          while($posts->fetch()) {
+
+               $to_change[] = $posts->post_id; 
+          }
+
+          if (count($to_change)) {
+
+               $strReq =
+               'UPDATE '.$this->prefix.'post '.
+               'SET post_firstpub = 1 '.
+               "WHERE blog_id = '".$this->con->escape($this->id)."' ".
+               'AND post_id '.$this->con->in((array)$to_change).' ';
+               $this->con->execute($strReq);
+
+               # --BEHAVIOR-- coreFirstPublicationEntries
+               $this->core->callBehavior('coreFirstPublicationEntries',$this,$to_change);
+          }
      }
 
@@ -1760 +1805 @@
 
                $cur->post_words = implode(' ',text::splitWords($words));
+          }
+
+          if ($cur->isField('post_firstpub')) {
+               $cur->unsetField('post_firstpub');
           }
      }

inc/dbschema/db-schema.php

@@ -121 +121 @@
      ->post_words             ('text',       0,        true,     null)
      ->post_status            ('smallint',   0,        false,    0)
+     ->post_firstpub               ('smallint',   0,        false,    0)
      ->post_selected               ('smallint',   0,        false,    0)
      ->post_position               ('integer',         0,        false,    0)

inc/dbschema/upgrade.php

@@ -610 +610 @@
                $core->con->execute($strReq);
 
+               # Update first publication on published posts
+               $strReq = 'UPDATE '.$core->prefix.'post '.
+                         'SET post_firstpub = 1 '.
+                         'WHERE post_status = 1 ';
+               $core->con->execute($strReq);
+
                # A bit of housecleaning for no longer needed files
                $remfiles = array (