Changeset 501

Timestamp:

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

Author:

brieb

Message:

• Added basics for centralized posting

Location:

trunk/phpbms

Files:

• common/stylesheet/mozilla/pages/bms/post.css (added)
• include/post_class.php (modified) (4 diffs)
• modules/bms/include/invoices.php (modified) (1 diff)
• modules/bms/include/post.php (added)
• modules/bms/include/receipts.php (modified) (3 diffs)
• modules/bms/javascript/post.js (added)
• modules/bms/post.php (added)

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).")";

trunk/phpbms/modules/bms/include/invoices.php

@@ -1322 +1322 @@
         class invoicesPost extends tablePost{
 
+                var $maintable = "invoices";
+                var $datefieldname = "invoicedate";
+                var $notpostedCriteria = "(invoices.type != 'Invoice' && invoices.type != 'VOID')";
 
                 function prepareWhere($whereclause=NULL){

trunk/phpbms/modules/bms/include/receipts.php

@@ -606 +606 @@
         class receiptsPost extends tablePost{
 
+                var $maintable = "receipts";
+                var $datefieldname = "receiptdate";
+                var $notpostedCriteria = "receipts.posted = 0";
 
                 function prepareWhere($whereclause=NULL){
@@ -741 +744 @@
 
                         $this->updatePostingSession($postsessionid, $count);
-                        
+
                         return $count;
 
@@ -751 +754 @@
 
 if(class_exists("tablePost")){
-        defineReceiptPost($db);
+        defineReceiptsPost($db);
 }
 ?>