Changeset 501 for trunk/phpbms/include

Timestamp:

04/21/09 11:08:21 (3 years ago)

Author:

brieb

Message:

• Added basics for centralized posting

Files:

• trunk/phpbms/include/post_class.php (modified) (4 diffs)

trunk/phpbms/include/post_class.php

@@ -9 +9 @@
                 var $maintable = "";
                 var $datefieldname = "";
+                var $notpostedCriteria = "";
 
                 function tablePost($db, $modifiedby = NULL){
@@ -22 +23 @@
 
 
-                function getRecordsToPost($startdate, $enddate){
+                function getRecordsToPost($startdate = null, $enddate = null){
                         // This function creates an array of
                         // record ids within the date range given
@@ -34 +35 @@
                                         `".$this->maintable."`
                                 WHERE
-                                        `".$this->maintable."`.readytopost = 1
+                                        `".$this->maintable."`.readytopost = 1";
+
+                        if($startdate){
+
+                                $querystatement .= "
                                         AND `".$this->maintable."`.`".$this->datefieldname."` >= '".dateToString($startdate, "SQL")."'
                                         AND `".$this->maintable."`.`".$this->datefieldname."` <= '".dateToString($enddate, "SQL")."'";
 
+                        }//endif
+
+                        if($this->notpostedCriteria){
+
+                                $querystatement .= "
+                                        AND ".$this->notpostedCriteria;
+
+                        }//endif
+
                         $queryresult = $this->db->query($querystatement);
 
-                        while($thecord = $this->db->fetchArray($queryresult))
+                        while($therecord = $this->db->fetchArray($queryresult))
                                 $idarray[] = $therecord["id"];
 
@@ -53 +67 @@
                         // segment using 'IN'
 
-                        $where = "`".$this->maintable."`.id IN";
+                        $where = "`".$this->maintable."`.id ";
                         if(count($idarray))
                                 $where .= " IN(".implode(",", $idarray).")";