Changeset 698 for trunk/phpbms

Timestamp:

12/31/09 16:28:12 (2 years ago)

Author:

nate

Message:

• Removed unused function in bms/install/update.php
• Fixed aritem relatedid update in generateuuids.php
• Fixed sql statement in aritems.php

Location:

trunk/phpbms

Files:

• install/generateuuids.php (modified) (6 diffs)
• modules/bms/include/aritems.php (modified) (1 diff)
• modules/bms/install/update.php (modified) (1 diff)
• modules/bms/install/updatev0.98.sql (modified) (1 diff)

trunk/phpbms/install/generateuuids.php

@@ -51 +51 @@
     var $tabledefList;
     var $moduleList;
+    var $receiptList;
+    var $invoiceList;
 
 
@@ -116 +118 @@
 
             $this->aritemList = $this->generateUUIDList("aritems");
-            $this->recieptList = $this->generateUUIDList("reciepts");
+            $this->receiptList = $this->generateUUIDList("receipts");
             $this->productsList = $this->generateUUIDList("products");
             $this->addressList = $this->generateUUIDList("addresses");
@@ -211 +213 @@
             $this->updateFields("aritems", array("clientid"=>$this->clientList));
             $this->updateFields("prerequisites", array("parentid"=>$this->productList, "childid"=>$this->productList));
-            $this->updateAritems("clientemailprojects", array("userid"=>$this->userList));
+            $this->updateFields("clientemailprojects", array("userid"=>$this->userList));
 
             //we would have to run this if their were addresses associated with other records
@@ -459 +461 @@
 
                 case "credit":
-
                     $oldRelatedid = $therecord["relatedid"];
                     $updatestatement = "
@@ -465 +466 @@
                             `aritems`
                         SET
-                            `relatedid`='".$this->recieptList[$oldRelatedid]."'
+                            `relatedid`='".$this->receiptList[$oldRelatedid]."'
                         WHERE
                             `relatedid` = '".$oldRelatedid."'
@@ -482 +483 @@
                             `aritems`
                         SET
-                            `relatedid`='".$this->recieptList[$oldRelatedid]."'
+                            `relatedid`='".$this->invoiceList[$oldRelatedid]."'
                         WHERE
                             `relatedid` = '".$oldRelatedid."'

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

@@ -121 +121 @@
                         if($this->aritem["type"] == "deposit")
                                 $querystatement.="
-                                        AND receipts.uuid != ".mysql_real_escape_string($this->aritem["relatedid"]);
+                                        AND receipts.uuid != '".mysql_real_escape_string($this->aritem["relatedid"])."'";
 
                         $querystatement.=

trunk/phpbms/modules/bms/install/update.php

@@ -447 +447 @@
         }//end function v098UpdatePostingSession
 
-        /**
-         * function v098UpdateProducts
-         * Updates the categoryid field from the category's id to uuid.
-         */
-
-        function v098UpdateProducts() {
-
-                $querystatement = "
-                        SELECT
-                                `id`,
-                                `uuid`
-                        FROM
-                                `productcategories`
-                        ";
-
-                $queryresult = $this->db->query($querystatement);
-
-                while($therecord = $this->db->fetchArray($queryresult)){
-
-                        $id = $therecord["id"];
-                        $uuid = $therecord["uuid"];
-
-                        $updatestatement = "
-                                UPDATE
-                                        `products`
-                                SET
-                                        `categoryid`='".$uuid."'
-                                WHERE
-                                        `categoryid`='".$id."'
-                                ";
-
-                        $this->db->query($updatestatement);
-
-                }//end while
-
-        }//end method --v098UpdateProducts00
-
 }//end class updateBMS
 

trunk/phpbms/modules/bms/install/updatev0.98.sql

@@ -750 +750 @@
 --end tablegroupings UPDATE--
 --tableoptions DELETE--
-DELETE FROM `tableoptions WHERE `name`='massEmail';
+DELETE FROM `tableoptions` WHERE `name`='massEmail';
 --end tableoptions DELETe
 --tableoptions INSERT--